Quote:
Originally Posted by Buehler445
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.
|
I don't know anything about your company obviously, but storage and processing power is so cheap now that you could probably build a DB for free in something like AWS on their free tier. You'd have to learn how to use it of course, but don't let cost be a reason you don't do it.