- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Surface Pro and MS Excel/Project?
Posted on 12/2/17 at 12:39 am
Posted on 12/2/17 at 12:39 am
Microsoft has thier Intel Core i5,128GB SSD, 4GB RAM Surface Pro on sale for $799. Basically lowest level Surface Pro. Thinking about picking it up. Y’all think I can run Excel and Project on it without any problems?
Posted on 12/2/17 at 6:44 am to jfturner212
I bought a Surface 3 Pro (3-4 years old by now) and run Oracle Enterprise database instance on it, I used it for client demos for a while. This is the same database software that Fortune 500 corporations use, I just didn't have as much data on it. It ran like a champ.
You will have zero problems running Excel and Project.
This post was edited on 12/2/17 at 6:45 am
Posted on 12/2/17 at 9:46 am to jfturner212
I routinely run P6, excel, and bluebeam on a three monitor system powered by a surface 2 i5.
If I'm scrolling through a giant set of plans on Adobe it might lag every once in a while but overall it's a beast.
If I'm scrolling through a giant set of plans on Adobe it might lag every once in a while but overall it's a beast.
Posted on 12/2/17 at 12:13 pm to baseballmind1212
Sweet. I’ve got an HP laptop with similar specs and same processor but am unfamiliar with the Surface. Everyone else is running on IPad Pros but Project isn’t available for IOS.
Posted on 12/3/17 at 10:32 am to jfturner212
You won't have any issues running excel on your SP
Posted on 12/3/17 at 4:45 pm to jfturner212
Define "using Excel". Are you talking about casual business use, as in a few hundred to a few thousand cells with light formulas, or hundreds of thousands of cells with half of them using VLookups?
It makes a difference in the answer.
It makes a difference in the answer.
Posted on 12/3/17 at 8:13 pm to jfturner212
Should have no issues. I run Excel and Project on my Surface Pro along with some Root Cause Analysis software. I've had all 3 open and going at once with no hiccups.
Posted on 12/3/17 at 9:04 pm to TigerFanatic99
quote:
Are you talking about casual business use, as in a few hundred to a few thousand cells with light formulas, or hundreds of thousands of cells with half of them using VLookups?
It makes a difference in the answer.
If you are doing hundreds of thousands of VLOOKUPS then you need to have a nice talk with your technical architect about why you don't have a dedicated database instance. At that scale you really shouldn't be using Excel, you should be using a real RDMS.
This isn't a Surface vs. competitors conversation, it's more Excel vs. a real database.
Posted on 12/4/17 at 7:11 am to foshizzle
quote:
If you are doing hundreds of thousands of VLOOKUPS then you need to have a nice talk with your technical architect about why you don't have a dedicated database instance. At that scale you really shouldn't be using Excel, you should be using a real RDMS.
This isn't a Surface vs. competitors conversation, it's more Excel vs. a real database.
Interesting. I have to compare tables between two spreadsheet and identify cells that do not match across 150 or so columns, usually 10k-20k lines. I use a nested Hlookup inside of a Vlookup formula to match up the cells, then insert a new column after each column with a = = formula to tell me if they match or not so all i have to do is filter to the FALSE messages in those "match?" columns.
I have to do this once a month or so to validate loads into SAP. different unique data sets every time. By the time I am done, it typically takes about 30 seconds for the file to save, etc.
You're telling me there's a better way to do this?
Posted on 12/4/17 at 8:21 am to jfturner212
quote:
Y’all think I can run Excel and Project on it without any problems?
Oh yeah, easily. Biggest issue you may run into is drive space, depending on how you manage it. Not from the application, but from adding other apps and personal files.
Posted on 12/4/17 at 9:38 am to TigerFanatic99
quote:
You're telling me there's a better way to do this?
Interested in this answer as well. My company uses excel to house our project data that uses a ton of vlookups to data sheets on a tab in the same file. It really bogs down sometimes. I've looked into things like Project but I couldn't really figure out how to load multiple projects with a schedule template. I need an easy to way to update a lot of projects at once and didn't really see that functionality either.
Posted on 12/4/17 at 1:11 pm to TigerFanatic99
quote:
You're telling me there's a better way to do this?
Without knowing the details of your spreadsheet I suggest talking to an in-house developer to simply load your spreadsheet data into your SAP database and have him write a stored procedure that will do all the work for you.
We do this all the time where I work, and I can tell you that taking the human element out of the process cuts the error rate pretty drastically.
ETA: Came back to elaborate a bit on why errors drop so much. Yes, code can have bugs but the thing about having a completely automated process is that you can reproduce errors, understand how they happened, and fix them. Excel is a great tool for whipping up something ad-hoc but detecting and tracking errors is often very hard.
Any time I review someone's code the first thing I look for is how well errors are handled. If it's done well then I know the rest of the code is probably okay too.
This post was edited on 12/4/17 at 7:12 pm
Popular
Back to top
Follow TigerDroppings for LSU Football News