I use that bitch every day.
A simple =(timeout-timein)*24 makes a timesheet with multiple entities a breeze.
I use vlookup in a real simple purchase unit to application unit conversion.
DaFace actually turned me on to the SUBTOTAL function actually allows you total a column after a filter has been applied. I have an incredibly reerunedly convoluted billing spreadsheet that converts a myriad of field activities to whether or not they are billable to a billion different entities.
I should be doing that asshole on a database, but it's been a billion years since I've built one and I don't want to spend the money on access.
I also have a remarkably difficult to set up but remarkably easy to operate conversion from Quickbooks report to banks cashflow statement that is pretty much a series of references.
|