- 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
Posted on 3/21/24 at 7:09 am to rickgrimes
If if they were to use an operating system, the data gathering is via excel templates. That onboarding process can take a year or two to see the benefits. Sounds like toxic leadership.
Posted on 3/21/24 at 7:23 am to KLSU
quote:
I’m not saying this is the best software to use for an inventory program but 20,000 rows in Excel isn’t that much data and what he was complaining about could have been easily fixed.
This is absolutely asinine for any business to track inventory be tracking inventory in excel, much less an F1 team.
This is way way more embarrassing to Williams than it may seem on the surface, and provides a good look at why such a formerly great and storied team has fallen on such tough times.
And now that their are (wholly?) owned by private equity, I don't see it getting better.
Posted on 3/21/24 at 7:25 am to ApisMellifera
quote:
Spoken like someone who doesn't know how to use vlookup.
Amateur.... I could bust your vlookup easily given it's not dynamic unless you put an =column() that will adjust if columns are added to reference to look-up column.
Index / match is the way
Nonetheless, this is ridiculous for an F1 team. Sadly, i'd expect this out of HAAS.
This post was edited on 3/21/24 at 7:27 am
Posted on 3/21/24 at 7:40 am to rickgrimes
Cloud-based ERP platform is the answer…
Posted on 3/21/24 at 7:40 am to Motorboat
Big sponsor of F1, that and Oracle. Williams has been behind for years, without the real capital to compete. Software was probably the least of their worries. New infusion of cash, new Principal from Merc and now the blame shifts to not having all the bells and whistles.
This post was edited on 3/21/24 at 8:00 am
Posted on 3/21/24 at 7:43 am to rickgrimes
Sounds like a common issue with growing businesses that need to transition from excel spreadsheets to hiring business process management team. Don't they have better planforms for this than excel, like SAP?
Posted on 3/21/24 at 7:48 am to rickgrimes
The worst DMS in the auto business would run circles around excel for this sort of thing.
The one I hated was microsoft Access.
Oh you have 5000 lines with 30 columns each? Allow me to take 9 minutes to load for no damned reason.
The one I hated was microsoft Access.
Oh you have 5000 lines with 30 columns each? Allow me to take 9 minutes to load for no damned reason.
Posted on 3/21/24 at 7:52 am to GumboPot
quote:
growing businesses
That's the big issue here. This isn't a "growing business". This is one of the most successful and storied programs in the highest form of motor sports.
Many innovations on consumer vehicles came via F1 technology.
Posted on 3/21/24 at 7:54 am to rickgrimes
Ars proceeds to say Renault used the same system while managing triple the data a few years ago.
Kinda negated the great visionary breakthrough Vowles intended to promote. Like a prior poster said, this sounds more like an advertisement for some software company they partnered with.
Kinda negated the great visionary breakthrough Vowles intended to promote. Like a prior poster said, this sounds more like an advertisement for some software company they partnered with.
Posted on 3/21/24 at 8:06 am to tylerlsu2008
I would think the bigger problem with managing it in Excel is permissions and access. If everyone has carte blanc access to change data and formulas, it wouldn't take long to render the spreadsheet useless. I would hope they have it locked down for the most part. At least putting it in a database, building out the database with past orders and inventory on hand would really help with their future needs.
I don't know how long he harped on the excel aspect of the team. The thread makes it seem like he came in and thought everything was fine except the excel usage. I'm guessing it was just one thing in a list a mile long of things that need to change. I would hope this is the case at least.
I don't know how long he harped on the excel aspect of the team. The thread makes it seem like he came in and thought everything was fine except the excel usage. I'm guessing it was just one thing in a list a mile long of things that need to change. I would hope this is the case at least.
Posted on 3/21/24 at 8:08 am to SB9513
quote:
Vlookup can't look left, xlookup is where it's at.
Naw mane. Index and match.
Left, right, and multiple criteria. And it works on older versions of excel, too.
BUT - I agree there are way better business systems catered specifically for inventory control.
This post was edited on 3/21/24 at 8:10 am
Posted on 3/21/24 at 8:09 am to rickgrimes
quote:
Microsoft Excel.
quote:
"Impossible to navigate and impossible to update."
It's actually one of the easiest to navigate and update lol. Not like they were using Access or some other nonsense.
Posted on 3/21/24 at 8:12 am to SB9513
quote:this guy knows.
Vlookup can't look left, xlookup is where it's at.
I was very happy when I discovered xlookup and got to throw vlookup in the trash.
This post was edited on 3/21/24 at 8:13 am
Posted on 3/21/24 at 8:15 am to rickgrimes
To be clear, what James Vowels wanted was specific engineering software that helps them track technical architecture. Using excel to for example, carry calculations based on different scenarios to be readily usable for moving to production
Posted on 3/21/24 at 8:20 am to athenslife101
Sticky notes is where it’s at.
Posted on 3/21/24 at 8:24 am to rickgrimes
Guilty.
I may or may not havea couple excel documents like that
I may or may not havea couple excel documents like that
Posted on 3/21/24 at 8:37 am to MSTiger33
quote:
Williams should worry more about designing something that isn’t a shite box than someone using excel.
Alpine must use a damn magic 8 ball, lol.
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….
Posted on 3/21/24 at 8:43 am to rickgrimes
The entire global financial system runs on Excel just fine
Popular
Back to top
Follow TigerDroppings for LSU Football News