CNC Plasma Cutting Excel Pricing Worksheet
- djreiswig
- 4.5 Star Elite Contributing Member
- Posts: 2013
- Joined: Thu Nov 19, 2015 10:02 pm
- Location: SE Nebraska
Re: Excel Pricing Worksheet
Indexes are for if you have to move the sheet on the table because your cutting area isn't large enough to cut the entire part at once.
I go 1-1/2 or 2x material cost + the price per inch that is in the spreadsheet + pierces. I don't really add for design time, but mine is mostly a hobby.
I go 1-1/2 or 2x material cost + the price per inch that is in the spreadsheet + pierces. I don't really add for design time, but mine is mostly a hobby.
Last edited by djreiswig on Wed Jan 22, 2020 11:18 pm, edited 1 time in total.
2014 Bulltear (StarLab) 4x8
C&CNC EtherCut
Mach3, SheetCam, Draftsight
Hypertherm PM65
Oxy/Acetylene Flame Torch
Pneumatic Plate Marker, Ohmic, 10 inch Rotary Chuck (in progress)
C&CNC EtherCut
Mach3, SheetCam, Draftsight
Hypertherm PM65
Oxy/Acetylene Flame Torch
Pneumatic Plate Marker, Ohmic, 10 inch Rotary Chuck (in progress)
-
- 1/2 Star Member
- Posts: 5
- Joined: Mon Jul 01, 2019 10:35 pm
Re: Excel Pricing Worksheet
Thank you! How do you figure up the price per cut inch?
- djreiswig
- 4.5 Star Elite Contributing Member
- Posts: 2013
- Joined: Thu Nov 19, 2015 10:02 pm
- Location: SE Nebraska
Re: Excel Pricing Worksheet
I just used the defaults that were in the spreadsheet when I downloaded it. For artsy stuff, I adjust it a bit on some pieces if the total price sounds high. I've learned it isn't really a science. If you're selling stuff, but not being overrun with business, and you're making more than your spending then your probably about right. Like I said, I'm doing it more as a hobby, so I don't need to make a living off of it.
2014 Bulltear (StarLab) 4x8
C&CNC EtherCut
Mach3, SheetCam, Draftsight
Hypertherm PM65
Oxy/Acetylene Flame Torch
Pneumatic Plate Marker, Ohmic, 10 inch Rotary Chuck (in progress)
C&CNC EtherCut
Mach3, SheetCam, Draftsight
Hypertherm PM65
Oxy/Acetylene Flame Torch
Pneumatic Plate Marker, Ohmic, 10 inch Rotary Chuck (in progress)
-
- 1.5 Star Member
- Posts: 28
- Joined: Mon Feb 18, 2019 2:44 pm
Re: Excel Pricing Worksheet
Thank you very much.
-
- 1 Star Member
- Posts: 11
- Joined: Mon Apr 15, 2019 6:30 pm
Re: Excel Pricing Worksheet
A little confused on the height and width part are we looking for square footage or ? i can obviously see how it works for a single sheet but im trying to price a job that requires 3 4x8 sheets and dont know if i just multiply 48 & 96 x3 or how that would work.
- cstroke
- 3 Star Elite Contributing Member
- Posts: 406
- Joined: Thu May 24, 2012 7:45 pm
Re: Excel Pricing Worksheet
32sq ft per sheet x 3 pcs.. 96' of material
If you are using inches multiply 48x96 and divide by 144(12"x12"= a square foot)
Hope this is what you were asking.
If you are using inches multiply 48x96 and divide by 144(12"x12"= a square foot)
Hope this is what you were asking.
6’x12’ Dynatorch powermax 85
12’ Wysong brake
5’x 5/16’ wysong rolls
3.8’x10’ shear
65 Ton ironworker
Boss laser 3655 150 watt CO2.
SFX 100watt Mopa
Quicncy 7.5hp
Square wave tig, Multimatics, Miller bobcat efi.
12’ Wysong brake
5’x 5/16’ wysong rolls
3.8’x10’ shear
65 Ton ironworker
Boss laser 3655 150 watt CO2.
SFX 100watt Mopa
Quicncy 7.5hp
Square wave tig, Multimatics, Miller bobcat efi.
-
- 1 Star Member
- Posts: 15
- Joined: Wed Oct 20, 2021 3:47 pm
Re: Excel Pricing Worksheet
Thankyou Danny I know this is an old post but I'm sure still relevant.mdwalker wrote: ↑Fri Mar 15, 2013 11:11 am I have noticed a lot of discussion on product pricing. Here is the original Excel pricing worksheet (with a few updates and modifications) that I posted a few years back. It has made the rounds through other forums and has been modified several times by other users. Feel free to use it and to modify it to suit your needs.
Danny
Would anybody have this spreadsheet converted to Metric? I am from Australia and we work in mm and I totaly dont get the inch system. Otherwise what would I need to change to make it work?
-
- 6 Star Elite Contributing Member
- Posts: 9651
- Joined: Thu Sep 21, 2017 5:22 pm
- Location: Tucson, Arizona
- Contact:
Re: Excel Pricing Worksheet
I believe this might be what you are after.ShowbizAsh wrote: ↑Wed Oct 20, 2021 5:08 pm
Would anybody have this spreadsheet converted to Metric? I am from Australia and we work in mm and I totaly dont get the inch system. Otherwise what would I need to change to make it work?
David
You currently do not have access to download this file.
To gain download access for DXF, SVG & other files Click Here
-
- 1 Star Member
- Posts: 15
- Joined: Wed Oct 20, 2021 3:47 pm
Re: Excel Pricing Worksheet
Thanks David for that. I spent half the day trying to convert another spreadsheet to metric to suit. The problem I’m finding is to get a easy go to size to start from. With imperial the sq inch works well but in metric the Sq centimetre is I feel too small. It ends up too many zeros. And then it jumps up to Metres which is far too big. I Sm now working on 10Sq cm. Which seems to work.
I will have a look at your conversions tomorrow to see if it has a better idea. I have a feeling though from a quick look that the mix of inches and centre metres will be hard. We have different thickness steel plate here too. I will give it a shot though and see if I can do better tomorrow.
Edit: Also my output is in Aus $, Obviously editable I will see how I go and will post my finished spreadsheet back here for anybody else to use.
Thanks again. Ash
I will have a look at your conversions tomorrow to see if it has a better idea. I have a feeling though from a quick look that the mix of inches and centre metres will be hard. We have different thickness steel plate here too. I will give it a shot though and see if I can do better tomorrow.
Edit: Also my output is in Aus $, Obviously editable I will see how I go and will post my finished spreadsheet back here for anybody else to use.
Thanks again. Ash
-
- 6 Star Elite Contributing Member
- Posts: 9651
- Joined: Thu Sep 21, 2017 5:22 pm
- Location: Tucson, Arizona
- Contact:
Re: Excel Pricing Worksheet
Ash - the spreadsheet I posted above is one from this site. I did not have a hand in creating it, but I thought it might be useful for you since it is in metric units.
David
David
-
- 1 Star Member
- Posts: 15
- Joined: Wed Oct 20, 2021 3:47 pm
Re: Excel Pricing Worksheet
I do appreciate it David
-
- 1 Star Member
- Posts: 16
- Joined: Tue Nov 01, 2022 8:52 pm
Re: Excel Pricing Worksheet
Wondering if anybody can help me figure out how to add a column into this worksheet. In this case I want to add a column for 11ga, I was able to add this into the bottom "Cost Of Material" chart but when I inserted a new column for the 11ga into the top "number of items" chart, the pricing does not update as the others do as I input the values of the project.
-
- 6 Star Elite Contributing Member
- Posts: 9651
- Joined: Thu Sep 21, 2017 5:22 pm
- Location: Tucson, Arizona
- Contact:
Re: Excel Pricing Worksheet
I believe that you will need to type in the equation for the operation you wish to perform for that column.bwmetalworks wrote: ↑Sun Dec 04, 2022 11:16 am Wondering if anybody can help me figure out how to add a column into this worksheet. In this case I want to add a column for 11ga, I was able to add this into the bottom "Cost Of Material" chart but when I inserted a new column for the 11ga into the top "number of items" chart, the pricing does not update as the others do as I input the values of the project.
David
You currently do not have access to download this file.
To gain download access for DXF, SVG & other files Click Here
Last edited by adbuch on Sun Dec 04, 2022 5:28 pm, edited 1 time in total.
-
- 1 Star Member
- Posts: 16
- Joined: Tue Nov 01, 2022 8:52 pm
Re: Excel Pricing Worksheet
Yeah I had to go through and input & adjust the formula/function for the entire row. Would be alot easier if I could just insert a column and have it automatically adhere to the functions of the rest of the rowsadbuch wrote: ↑Sun Dec 04, 2022 5:22 pmI believe that you will need to type in the equation for the operation you wish to perform for that column.bwmetalworks wrote: ↑Sun Dec 04, 2022 11:16 am Wondering if anybody can help me figure out how to add a column into this worksheet. In this case I want to add a column for 11ga, I was able to add this into the bottom "Cost Of Material" chart but when I inserted a new column for the 11ga into the top "number of items" chart, the pricing does not update as the others do as I input the values of the project.
David
- tnbndr
- 4.5 Star Elite Contributing Member
- Posts: 1687
- Joined: Mon Jan 09, 2012 4:30 pm
- Location: New Berlin, WI
- Contact:
Re: Excel Pricing Worksheet
I haven't used excel in years but I think if you insert a column and drag the formula from the adjoining column over, as in copy, it will adjust the cell references automatically. Not sure though.t automatically adhere to the functions of the rest of the rows
Dennis
LDR 4x8, Scribe, DTHCIV
Hypertherm PM45, Macair Dryer
DeVilbiss Air America 6.5HP, 80Gal., 175psi, Two Stage
16.9scfm@100psi, 16.0scfm@175psi
Miller 215 MultiMatic
RW 390E Slip Roll (Powered)
AutoCAD, SheetCAM, Mach 3
http://ikescreations.com
LDR 4x8, Scribe, DTHCIV
Hypertherm PM45, Macair Dryer
DeVilbiss Air America 6.5HP, 80Gal., 175psi, Two Stage
16.9scfm@100psi, 16.0scfm@175psi
Miller 215 MultiMatic
RW 390E Slip Roll (Powered)
AutoCAD, SheetCAM, Mach 3
http://ikescreations.com
-
- 6 Star Elite Contributing Member
- Posts: 9651
- Joined: Thu Sep 21, 2017 5:22 pm
- Location: Tucson, Arizona
- Contact:
Re: Excel Pricing Worksheet
Doug - that sounds right. I haven't used it in many years either. Or he could probably copy and paste the formula into the new cell.
David
David
- Joe Jones
- 5 Star Elite Contributing Member
- Posts: 3375
- Joined: Sat Oct 11, 2014 2:33 pm
- Location: Franklin, KY., USA
- Contact:
Re: CNC Plasma Cutting Excel Pricing Worksheet
Here is a spreadsheet I created long ago, in a land far, far away. I get almost daily requests for it. People can make any changes to it that they choose.
Joe
Joe
You currently do not have access to download this file.
To gain download access for DXF, SVG & other files Click Here
Bitten by the laser bug.
Now my PlasmaCAM tables fight for attention!
X-TOOL D1 PRO (x 4 ? ) w/20W, 40W and 2W-IR heads + accs
X-TOOL F1, S1 (x3), P2 (x2), F1 ULTRA (x2) with conveyors, M1 ULTRA (x2)
LaserPecker 1 PRO, LP-2, LP-4 and accs
50 Watt GALVO fiber laser
TYVOK Spider S1 60W Diode Laser 49" x 96"
CreatBot D600 PRO 3D printer
Stratasys Fortus 400mc 3D Printer
Obscene Levels of Debt
No help.
FREE DesignEdge Training Via ZOOM!
Now my PlasmaCAM tables fight for attention!
X-TOOL D1 PRO (x 4 ? ) w/20W, 40W and 2W-IR heads + accs
X-TOOL F1, S1 (x3), P2 (x2), F1 ULTRA (x2) with conveyors, M1 ULTRA (x2)
LaserPecker 1 PRO, LP-2, LP-4 and accs
50 Watt GALVO fiber laser
TYVOK Spider S1 60W Diode Laser 49" x 96"
CreatBot D600 PRO 3D printer
Stratasys Fortus 400mc 3D Printer
Obscene Levels of Debt
No help.
FREE DesignEdge Training Via ZOOM!
-
- 1 Star Member
- Posts: 23
- Joined: Fri Jun 07, 2024 4:31 pm
Re: CNC Plasma Cutting Excel Pricing Worksheet
I know I'm necroing a very old thread, but for anyone who prefers the simplicity of this version over Joe Jones' version, you can open and edit this file in OpenOffice with no issues.
Not to bash Joe's version... his is more useful to me. But someone might like this version better.
Not to bash Joe's version... his is more useful to me. But someone might like this version better.
-
- 1 Star Member
- Posts: 13
- Joined: Wed Sep 20, 2023 9:24 pm
- Location: Montana
Re: CNC Plasma Cutting Excel Pricing Worksheet
Thank you for this, I tweaked some of the costs and prices and found I was undervaluing my products and time.