XKCD OTD
-
xkcd: Algorithms[^] Got me thinking: What's the worst example of misuse of a spreadsheet you've seen? Mine was a spreadsheet being used for production management: it clearly started small as a simple stock level check, but evolved to end up including:* Inventory
- Assembly instructions
- Subassembly instructions
- Purchasing
- Resource management (including human assemblers and their holiday requirements)
- Project Costing
- Invoicing.
Remember: this was a spreadsheet, and it was all done with cell functions, no macros or VBScript...it took around 45 minutes to open each day... :omg: But it worked! So it didn't get replaced, just added to. Tim: This was all your fault! :laugh: What's yours?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
xkcd: Algorithms[^] Got me thinking: What's the worst example of misuse of a spreadsheet you've seen? Mine was a spreadsheet being used for production management: it clearly started small as a simple stock level check, but evolved to end up including:* Inventory
- Assembly instructions
- Subassembly instructions
- Purchasing
- Resource management (including human assemblers and their holiday requirements)
- Project Costing
- Invoicing.
Remember: this was a spreadsheet, and it was all done with cell functions, no macros or VBScript...it took around 45 minutes to open each day... :omg: But it worked! So it didn't get replaced, just added to. Tim: This was all your fault! :laugh: What's yours?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
I have seen a lot big companies fron the "inside", and you cannot even begin to imagine what is handled using excel sheets. To me, the fact that it is so easy to program is partially responsible for the big mess. Making everybody to a potential sw developer was not the best idea.
-
xkcd: Algorithms[^] Got me thinking: What's the worst example of misuse of a spreadsheet you've seen? Mine was a spreadsheet being used for production management: it clearly started small as a simple stock level check, but evolved to end up including:* Inventory
- Assembly instructions
- Subassembly instructions
- Purchasing
- Resource management (including human assemblers and their holiday requirements)
- Project Costing
- Invoicing.
Remember: this was a spreadsheet, and it was all done with cell functions, no macros or VBScript...it took around 45 minutes to open each day... :omg: But it worked! So it didn't get replaced, just added to. Tim: This was all your fault! :laugh: What's yours?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
I have 2, the first one was for a car distributor in Oz, I did their entire cashflow projection in excel. Pulling data from a myriad of sheets, an AS400 and a bank feed. When I told the MD I had failed to get an accurate figure as it was about $200k out he was delighted, they had never got closer than $500k. The second was a contract for a financial org as in finance supplier not a bank. Their entire operation was run on spreadsheets, no database, nothing. I spent a day looking into the mess and rejected the contract. 2 years later they went tits up owing millions to joe public.
Never underestimate the power of human stupidity RAH
-
xkcd: Algorithms[^] Got me thinking: What's the worst example of misuse of a spreadsheet you've seen? Mine was a spreadsheet being used for production management: it clearly started small as a simple stock level check, but evolved to end up including:* Inventory
- Assembly instructions
- Subassembly instructions
- Purchasing
- Resource management (including human assemblers and their holiday requirements)
- Project Costing
- Invoicing.
Remember: this was a spreadsheet, and it was all done with cell functions, no macros or VBScript...it took around 45 minutes to open each day... :omg: But it worked! So it didn't get replaced, just added to. Tim: This was all your fault! :laugh: What's yours?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
A project management system spanning twenty or so files and hundreds of tabs, all with cross references and formulas and "special solutions". When the guy that managed it went into pension the whole house of cards fell apart and the company barely survived. I was luckily not involved.
Wrong is evil and must be defeated. - Jeff Ello
-
xkcd: Algorithms[^] Got me thinking: What's the worst example of misuse of a spreadsheet you've seen? Mine was a spreadsheet being used for production management: it clearly started small as a simple stock level check, but evolved to end up including:* Inventory
- Assembly instructions
- Subassembly instructions
- Purchasing
- Resource management (including human assemblers and their holiday requirements)
- Project Costing
- Invoicing.
Remember: this was a spreadsheet, and it was all done with cell functions, no macros or VBScript...it took around 45 minutes to open each day... :omg: But it worked! So it didn't get replaced, just added to. Tim: This was all your fault! :laugh: What's yours?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
I have before received the following a. Premium rating engine b. Project specification including diagrams.
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
xkcd: Algorithms[^] Got me thinking: What's the worst example of misuse of a spreadsheet you've seen? Mine was a spreadsheet being used for production management: it clearly started small as a simple stock level check, but evolved to end up including:* Inventory
- Assembly instructions
- Subassembly instructions
- Purchasing
- Resource management (including human assemblers and their holiday requirements)
- Project Costing
- Invoicing.
Remember: this was a spreadsheet, and it was all done with cell functions, no macros or VBScript...it took around 45 minutes to open each day... :omg: But it worked! So it didn't get replaced, just added to. Tim: This was all your fault! :laugh: What's yours?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
xkcd: Algorithms[^] Got me thinking: What's the worst example of misuse of a spreadsheet you've seen? Mine was a spreadsheet being used for production management: it clearly started small as a simple stock level check, but evolved to end up including:* Inventory
- Assembly instructions
- Subassembly instructions
- Purchasing
- Resource management (including human assemblers and their holiday requirements)
- Project Costing
- Invoicing.
Remember: this was a spreadsheet, and it was all done with cell functions, no macros or VBScript...it took around 45 minutes to open each day... :omg: But it worked! So it didn't get replaced, just added to. Tim: This was all your fault! :laugh: What's yours?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
I learnt spreadsheeting on Lotus 123. I had a project to put together some sheets to calculate costings for digging cable trenches back in the 80's. It started as the engineer providing routing data and then calculating the dig cost, then it evolved to the engineer giving topographical data and it worked out the cheapest route. No macros, just pure cell functionings. A great piece of work. Later I was involved in an abomination that even the scryptboyz would run a mile from. It --pulled-- had pushed into it holdings, prices and greeks for a portfolio and it produced the program trade list for sending to brokers. I was able to reproduce it as a component within the system that held the real correct and valid data, instead of lumps of guess work that were as stable as jelly in an earthquake. The new component even allowed some fiddling with the results as that was the reasoning behind the bastard child of a bastard that was in use. The brain-fecked traders 'preferred' to use the spreadsheet...
veni bibi saltavi
-
I learnt spreadsheeting on Lotus 123. I had a project to put together some sheets to calculate costings for digging cable trenches back in the 80's. It started as the engineer providing routing data and then calculating the dig cost, then it evolved to the engineer giving topographical data and it worked out the cheapest route. No macros, just pure cell functionings. A great piece of work. Later I was involved in an abomination that even the scryptboyz would run a mile from. It --pulled-- had pushed into it holdings, prices and greeks for a portfolio and it produced the program trade list for sending to brokers. I was able to reproduce it as a component within the system that held the real correct and valid data, instead of lumps of guess work that were as stable as jelly in an earthquake. The new component even allowed some fiddling with the results as that was the reasoning behind the bastard child of a bastard that was in use. The brain-fecked traders 'preferred' to use the spreadsheet...
veni bibi saltavi
I know of a financial "system" that had one spreadsheet for each month and they were linked so the closing balance of Jan 2014 fed into the opening balance field of Feb 2014 etc. The "system" was getting very slow because they had many years of spreadsheets to recalculate but then one day someone came along and deleted the > 10 year old monthly spreadsheets. The next month all the opening balances were wrong :rolleyes:
-
xkcd: Algorithms[^] Got me thinking: What's the worst example of misuse of a spreadsheet you've seen? Mine was a spreadsheet being used for production management: it clearly started small as a simple stock level check, but evolved to end up including:* Inventory
- Assembly instructions
- Subassembly instructions
- Purchasing
- Resource management (including human assemblers and their holiday requirements)
- Project Costing
- Invoicing.
Remember: this was a spreadsheet, and it was all done with cell functions, no macros or VBScript...it took around 45 minutes to open each day... :omg: But it worked! So it didn't get replaced, just added to. Tim: This was all your fault! :laugh: What's yours?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
xkcd: Algorithms[^] Got me thinking: What's the worst example of misuse of a spreadsheet you've seen? Mine was a spreadsheet being used for production management: it clearly started small as a simple stock level check, but evolved to end up including:* Inventory
- Assembly instructions
- Subassembly instructions
- Purchasing
- Resource management (including human assemblers and their holiday requirements)
- Project Costing
- Invoicing.
Remember: this was a spreadsheet, and it was all done with cell functions, no macros or VBScript...it took around 45 minutes to open each day... :omg: But it worked! So it didn't get replaced, just added to. Tim: This was all your fault! :laugh: What's yours?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
One of the accountants we have working with us is frighteningly skilled with Excel. She has managed (with no formal training) to create a myriad of sheets that all link and interact in order to assist the analysts; much to the chagrin of us software developers and IT. Her most recent accomplishment was to figure out how to connect Excel directly to our production database and managed to generate a query that literally maxed out our 12 core, 32GB ram database server for 5 SOLID MINUTES bringing the company's infrastructure to a halt. The accounting department was running it several times a day for a week before we finally figured out what was causing our system outages.
a posse ad esse
-
xkcd: Algorithms[^] Got me thinking: What's the worst example of misuse of a spreadsheet you've seen? Mine was a spreadsheet being used for production management: it clearly started small as a simple stock level check, but evolved to end up including:* Inventory
- Assembly instructions
- Subassembly instructions
- Purchasing
- Resource management (including human assemblers and their holiday requirements)
- Project Costing
- Invoicing.
Remember: this was a spreadsheet, and it was all done with cell functions, no macros or VBScript...it took around 45 minutes to open each day... :omg: But it worked! So it didn't get replaced, just added to. Tim: This was all your fault! :laugh: What's yours?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
Taking a collection of potentially overlapping 4 dimensional hypercubes, creating a new collection that covers the same parameter space with no overlaps, and then merging the mess of tiny cubes back together as much as possible to keep the list size reasonable. For some data sets with a few thousand members this operation could take several hours to execute in VBA (after order of magnitude level optimizations like 'disable refresh' and 'copy numbers to variables instead of reading from cells every single time') vs 15s for the same algorithm in a C# port. If my explanation didn't make sense, here's a 2d example.
initial input; 2 overlapping rectangles:
_____
| |
| _|___
|___|_| |
| |
|_____|first pass, after splitting to remove overlap; 7 non-overlapping rectangles:
_____
| | |
|___|_|___
|___|_|___|
| | |
|_|___|Second pass, after combining adjacent rectangles; 3 non-overlapping rectangles:
_____
| |
|_____|___
|_________|
| |
|_____|It gets a lot messier in 4-space. :omg:
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
-
xkcd: Algorithms[^] Got me thinking: What's the worst example of misuse of a spreadsheet you've seen? Mine was a spreadsheet being used for production management: it clearly started small as a simple stock level check, but evolved to end up including:* Inventory
- Assembly instructions
- Subassembly instructions
- Purchasing
- Resource management (including human assemblers and their holiday requirements)
- Project Costing
- Invoicing.
Remember: this was a spreadsheet, and it was all done with cell functions, no macros or VBScript...it took around 45 minutes to open each day... :omg: But it worked! So it didn't get replaced, just added to. Tim: This was all your fault! :laugh: What's yours?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
I forget exactly, but it was an Excel file that scheduled staff in call a center, it did a bunch of database calls too. What made it take even longer to open was that the anti-virus wanted to check everything it was doing. So I used Task Manager to kill the anti-virus whenever I opened the file. :badger:
