<BEGIN RANT>
If you want to waste some serious money -- Buy Excel. It's useless. Utterly and completely useless. I was helping a co-worker do some fairly deep nested logic IF(,,IF(,,IF())), etc. She has 14 categories we needed to "IF". When she got to the eight level, Excel threw an error. It can't handle more than 7 nested statements!
This is on the latest and greatest version of Microsoft Excel.
Out of curiousity, I ran a quick test with OpenOffice.org, an open-source (Free) office suite. It allowed me to nest at least 10 levels of logic. I did not bother to test any further.
The moral of the story: When you can't get your work done, it's probably because you paid too much money for your tool!
</END RANT>
Disclaimer: Yes, I do understand that a spreadsheet is not meant to be a programming tool, but when the client wants something in a certain file format (grumble grumble) you deliver what they want. Personally, I think all complex pivot tables should be built using a dedicated tool capable of doing complex vector logic like PSPP or R or just use a simple database.
Recent Comments
3 days 18 hours ago
1 week 1 day ago
1 week 1 day ago
1 week 3 days ago
1 week 3 days ago
1 week 3 days ago
1 week 3 days ago
1 week 4 days ago
1 week 4 days ago
1 week 4 days ago