im making a parts list / price list for a project, and i would like to do it in spreadsheet format to make it easy to keep track of cost
i would like to be able to set it up like this
column a: part name
column b: mfg & part number
column c: place of purchase
column d: Price
column e: tax (multiply D x 1 for no tax, or by 1.85 for taxed items maybe?)
column f: shipping
column g: notes about this item
and then have it subtotal D, E, and F, a spit out a grand total for me
problems: i have no clue how to work a spreadsheet, and im not purchasing a program just for this one project when im not even sure if ill use the program again
I could probably work on making a spreadsheet for ya that does these functions… just gimme a day. I’d have to install open office if you need to use it…
Try excel first… if you dont have excel… then download and install open office and I’ll make the sheet for ya… Just lemme know what program to use.
u could do this in pretty much any program. notepad even. learn how to add and multiply, or just use windows calculator… or just write it down on paper. again education FTW…
yes education for the win, too bad it would be such a waste of resources and not cost effective to do this by hand, especially multiple times, I mean you should learn this in school, right. You always do things the most efficient way the first time.
problem is this. formulas go by the available info there now. ideally, i would have all your receipt for your parts and be able to throw it together. this means that you would have to do adjustments to the functions on the program if i were to do this as you’ll be adding more parts down the line.
if you want, shoot me an email with the info you have in the first post for a few parts you have so i can create a base for you to see how it works, then you can add to it as you go on.
