I've added in some more screenshots to give people a better idea of where this is at right now. The blurred areas are either where the photo's were cropped, or the names of my suppliers, or the purchase price I currently buy items at. These are real prices I currently use, so obviously I had to blur them out.
I'll do up a short video of it in use over the next few days and post that aswell. I'll remove the blurring and just change some details slightly so that its clearer in the vid.
The nature of such a program as this is such that it will always be only as good as the information you input to it yourself. i.e: I can put in lists of items (Nuts, bolts, wood, aluminium etc) with my local prices, but those prices won't help each individual get accurate costings. I have found that the best way to get usefulness and accuracy is to keep receipts and every few weeks add in any individual items and their prices. It only takes a few min's and in my case anyway, has built up a nice database of item prices from various suppliers I purchase from. If however, anyone wants to pay my flights, expenses, and accomodation to get their local prices for them, that'd be good too!
Some people might prefer something like this to be programmed 'correctly' in C or similar, but I like the freedom that a fairly open spreadsheet based design gives.
The program as it stands consists of 9 worksheets:
Machinery Wear & Drill Bits
Labour & Misc
Im planning to split Machinery Wear & Drill Bits into two seperate sheets, and add in the following:
The Quotation, Invoice, and Receipt sheets are able to be printed directly for each job to be given to a customer or what not.
Im also considering breaking down the General Consumables, Prep and Finishing Products, into other titles such as 'Abrasives' 'Paints' 'Fixings' etc. Do you think this is a good idea or no?
I'm also throwing around the idea of another printable records sheet with pertinent info on it such as useage rates for particular machinery and tools. And ideas on this are welcome.
At the moment theres no 'Fluff' such as logo's etc, also its a work in progress, theres a lot of relatively minor things like the general user-friendliness of the layout, and making the itemised qutation even 'more itemised' (Its not truely itemised at the moment), and a list on top of those.
Obviously if anyone's interested and I'm giving this to people when/as it progresses, I'll do up a .pdf with instructions in addition to the vid/vid's.
Right now I think its general enough to be used in any fabrication/manufacturing industry for keeping track of basic costs (Basic because its probably too general right now). To improve on it I'd need the assistance of knowledgeable people in specific area (Such as metalworking/machining etc)[ Wonder where I'll find them? !! ] who may have specific items which should be included, and which Im not aware of.
Of course any initial comments are welcome.....