- 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
re: Formula 1 chief appalled to find team using Excel to manage 20,000 car parts
Posted on 3/21/24 at 7:01 am to GreatLakesTiger24
Posted on 3/21/24 at 7:01 am to GreatLakesTiger24
quote:
I'm not a data guy but excel for 20,000 items doesn't seem that bad if used properly
It's not. Excel maxes out at around 250,000 rows I believe. Depending on the data set, that could either be plenty or not nearly enough. Problem is if you max out the the sheet, and have it full of a bunch of vlookups and functions, it can take forever to load and save.
Posted on 3/21/24 at 8:40 am to facher08
quote:
Excel maxes out at around 250,000 rows
Excel has a limit of 1,048,576 rows and 16,384 columns per sheet. CSV files can hold many more rows. You can read more about these limits and others from this Microsoft support article here.Jul 7, 2023
But good luck trying to open that file if you have data and calculations in all of those cells….
Popular
Back to top
Follow TigerDroppings for LSU Football News