# free spreadsheet program? and how do i use it to track project costs ? **URL:** \ **Category:** NYSpeed Off Topic\ **Created:** [November 15, 2006, 4:10am UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231 "2006-11-15T04:10:22Z")\ **Posts on this page:** 15\ **Page:** 2
**Author:** ![Dex](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/dex/32/7210_2.png) [@Dex](https://forums.speedlife.net/u/Dex)\ **Post date:** [November 20, 2006, 9:42pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/21 "2006-11-20T21:42:58Z")
i understand that. i formatted about 30 rows for him. he can do about 30 rows if he wants. i’ll set it up for more if need be. i’m just concerned about him being able to use the functions and autosums and all that having no spread sheet knowledge and needing to add on further to the list. ---
**Author:** ![HotRodKid](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/hotrodkid/32/7609_2.png) [@HotRodKid](https://forums.speedlife.net/u/HotRodKid)\ **Post date:** [November 20, 2006, 9:52pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/22 "2006-11-20T21:52:48Z")
yea, i wish i knew spreadsheet stuff to, but its totaly greek to me right now thanks for the setup, ill start poking around and see how it works out for me ---
**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\ **Post date:** [November 20, 2006, 10:00pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/23 "2006-11-20T22:00:38Z")
i sent ya one too… it took all of ten minutes… if you like mine then use it… if you need something changed then tell me ---
**Author:** ![HotRodKid](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/hotrodkid/32/7609_2.png) [@HotRodKid](https://forums.speedlife.net/u/HotRodKid)\ **Post date:** [November 20, 2006, 10:31pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/24 "2006-11-20T22:31:12Z")
ilc, theres a flaw in your spreadsheet (sorta) i input the part price, then it dispays the tax as the proper 108.75% of that … but then it adds the part price and the tax column together so _price | tax | total_ for a part reads like this: _$100 | 108.75 | $208.75_ but now the reason for the “sorta” comment: this is a turbo kit, so the lil glitch is just a foreshadowing of the future reality 🤣 ---
**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\ **Post date:** [November 20, 2006, 10:32pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/25 "2006-11-20T22:32:28Z")
> [@HotRodKid](#): > > ilc, theres a flaw in your spreadsheet (sorta) > > i input the part price, then it dispays the tax as the proper 108.75% of that … > > but then it adds the part price and the tax column together > > so _price | tax | total_ for a part reads like this: _$100 | 108.75 | $208.75_ > > but now the reason for the “sorta” comment: this is a turbo kit, so the lil glitch is just a foreshadowing of the future reality 🤣 good call fixed and sent ---
**Author:** ![HotRodKid](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/hotrodkid/32/7609_2.png) [@HotRodKid](https://forums.speedlife.net/u/HotRodKid)\ **Post date:** [November 20, 2006, 10:45pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/26 "2006-11-20T22:45:25Z")
thanks guys :tup: this will make thinsg much easier ---
**Author:** ![HotRodKid](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/hotrodkid/32/7609_2.png) [@HotRodKid](https://forums.speedlife.net/u/HotRodKid)\ **Post date:** [November 21, 2006, 10:55am UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/27 "2006-11-21T10:55:44Z")
how do i apply a formula to an entire coulmn ? like if i want to change column I from =SUM(F;H) to =SUM(G;H) WTF do i do ? and i want column G to be “F times C” now too … i moved stuff around some so i can have part count now also … thought i was doing it right but i jumbled something and now i cant figure it back out again… ---
**Author:** ![badazzss](https://avatars.discourse-cdn.com/v4/letter/b/e19adc/32.png) [@badazzss](https://forums.speedlife.net/u/badazzss)\ **Post date:** [November 21, 2006, 11:58am UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/28 "2006-11-21T11:58:00Z")
wow, unreal. take a fucking class in excel, jesus fucking christ. or do a google search. stop being so lazy. and stupid. PS: none of u boneheads actually understood that i was making fun of the rampant stupidity in my earlier post. ---
**Author:** ![66impalass](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/66impalass/32/7429_2.png) [@66impalass](https://forums.speedlife.net/u/66impalass)\ **Post date:** [November 21, 2006, 11:58am UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/29 "2006-11-21T11:58:53Z")
maybe because you suck and life an can not convey your tone of voice through the intersweb??? :gotme: ps for colum multiplacation you have =F(n)\*G(n) where n is the cell number ---
**Author:** ![HotRodKid](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/hotrodkid/32/7609_2.png) [@HotRodKid](https://forums.speedlife.net/u/HotRodKid)\ **Post date:** [November 21, 2006, 12:14pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/30 "2006-11-21T12:14:45Z")
^^^ how do i apply that to an entire column at once ? i already know the formulas i need, i just dont fell like inserting them one cell at a time, lol ---
**Author:** ![Fry](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/fry/32/7284_2.png) [@Fry](https://forums.speedlife.net/u/Fry)\ **Post date:** [November 21, 2006, 12:15pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/31 "2006-11-21T12:15:53Z")
> [@HotRodKid](#): > > but now the reason for the “sorta” comment: this is a turbo kit, so the lil glitch is just a foreshadowing of the future reality 🤣 Ah, you included the Turbo/Murphy Multiplier. ---
**Author:** ![66impalass](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/66impalass/32/7429_2.png) [@66impalass](https://forums.speedlife.net/u/66impalass)\ **Post date:** [November 21, 2006, 12:28pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/32 "2006-11-21T12:28:22Z")
click and drag if your using excel, i am too lazy to go back and read what you are using ---
**Author:** ![HotRodKid](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/hotrodkid/32/7609_2.png) [@HotRodKid](https://forums.speedlife.net/u/HotRodKid)\ **Post date:** [November 21, 2006, 1:21pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/33 "2006-11-21T13:21:27Z")
got it working perfectly … sweeet i set it up so i could handle part COUNT and part PRICE seperatly so that if i decide to add more of something, i can change those numbers seperatly i didnt think of it till i wanted to add more mandrel bends to what i initialy plugged in, and felt stupid for havin you guys set it up a way that still required me to open the calculator in order to figure out the new price before tax, lol ---
**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\ **Post date:** [November 21, 2006, 1:27pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/34 "2006-11-21T13:27:25Z")
ah fuck… i should have formatted the cells for you _sigh_ … i’ll fix it ---
**Author:** ![HotRodKid](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/hotrodkid/32/7609_2.png) [@HotRodKid](https://forums.speedlife.net/u/HotRodKid)\ **Post date:** [November 21, 2006, 1:30pm UTC](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231/35 "2006-11-21T13:30:42Z")
its all good, im all set now man, thanks for the help [Previous page](https://forums.speedlife.net/t/free-spreadsheet-program-and-how-do-i-use-it-to-track-project-costs/20231.md?page=1)