CNC Plasma Cutting Excel Pricing Worksheet

Learn & share techniques, strategies, and experiences on marketing your plasma cut products in this forum.
User avatar
djreiswig
4.5 Star Elite Contributing Member
4.5 Star Elite Contributing Member
Posts: 2013
Joined: Thu Nov 19, 2015 10:02 pm
Location: SE Nebraska

Re: Excel Pricing Worksheet

Post by djreiswig »

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.
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)
MalekMetalworks
1/2 Star Member
1/2 Star Member
Posts: 5
Joined: Mon Jul 01, 2019 10:35 pm

Re: Excel Pricing Worksheet

Post by MalekMetalworks »

Thank you! How do you figure up the price per cut inch?
User avatar
djreiswig
4.5 Star Elite Contributing Member
4.5 Star Elite Contributing Member
Posts: 2013
Joined: Thu Nov 19, 2015 10:02 pm
Location: SE Nebraska

Re: Excel Pricing Worksheet

Post by djreiswig »

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)
Rockdog
1.5 Star Member
1.5 Star Member
Posts: 28
Joined: Mon Feb 18, 2019 2:44 pm

Re: Excel Pricing Worksheet

Post by Rockdog »

Thank you very much.
cncplasmaworkz
1 Star Member
1 Star Member
Posts: 11
Joined: Mon Apr 15, 2019 6:30 pm

Re: Excel Pricing Worksheet

Post by cncplasmaworkz »

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.
User avatar
cstroke
3 Star Elite Contributing Member
3 Star Elite Contributing Member
Posts: 406
Joined: Thu May 24, 2012 7:45 pm

Re: Excel Pricing Worksheet

Post by cstroke »

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.
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.
ShowbizAsh
1 Star Member
1 Star Member
Posts: 15
Joined: Wed Oct 20, 2021 3:47 pm

Re: Excel Pricing Worksheet

Post by ShowbizAsh »

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
Thankyou Danny I know this is an old post but I'm sure still relevant.

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?
adbuch
6 Star Elite Contributing Member
6 Star Elite Contributing Member
Posts: 9651
Joined: Thu Sep 21, 2017 5:22 pm
Location: Tucson, Arizona
Contact:

Re: Excel Pricing Worksheet

Post by adbuch »

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?
I believe this might be what you are after.
David


CNC Plasma Price Work Sheet Input mm Output Euro.xls
cnc plasma price work sheet - input mm, output euro.jpg

You currently do not have access to download this file.
To gain download access for DXF, SVG & other files Click Here

ShowbizAsh
1 Star Member
1 Star Member
Posts: 15
Joined: Wed Oct 20, 2021 3:47 pm

Re: Excel Pricing Worksheet

Post by ShowbizAsh »

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
adbuch
6 Star Elite Contributing Member
6 Star Elite Contributing Member
Posts: 9651
Joined: Thu Sep 21, 2017 5:22 pm
Location: Tucson, Arizona
Contact:

Re: Excel Pricing Worksheet

Post by adbuch »

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
ShowbizAsh
1 Star Member
1 Star Member
Posts: 15
Joined: Wed Oct 20, 2021 3:47 pm

Re: Excel Pricing Worksheet

Post by ShowbizAsh »

I do appreciate it David
bwmetalworks
1 Star Member
1 Star Member
Posts: 16
Joined: Tue Nov 01, 2022 8:52 pm

Re: Excel Pricing Worksheet

Post by bwmetalworks »

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.
adbuch
6 Star Elite Contributing Member
6 Star Elite Contributing Member
Posts: 9651
Joined: Thu Sep 21, 2017 5:22 pm
Location: Tucson, Arizona
Contact:

Re: Excel Pricing Worksheet

Post by adbuch »

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.
I believe that you will need to type in the equation for the operation you wish to perform for that column.
David
spread sheet.jpg

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.
bwmetalworks
1 Star Member
1 Star Member
Posts: 16
Joined: Tue Nov 01, 2022 8:52 pm

Re: Excel Pricing Worksheet

Post by bwmetalworks »

adbuch wrote: Sun Dec 04, 2022 5:22 pm
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.
I believe that you will need to type in the equation for the operation you wish to perform for that column.
David
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 rows
User avatar
tnbndr
4.5 Star Elite Contributing Member
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

Post by tnbndr »

t automatically adhere to the functions of the rest of the rows
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.
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
adbuch
6 Star Elite Contributing Member
6 Star Elite Contributing Member
Posts: 9651
Joined: Thu Sep 21, 2017 5:22 pm
Location: Tucson, Arizona
Contact:

Re: Excel Pricing Worksheet

Post by adbuch »

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
User avatar
Joe Jones
5 Star Elite Contributing Member
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

Post by Joe Jones »

Here is a spreadsheet I created long ago, in a land far, far away. :lol: I get almost daily requests for it. People can make any changes to it that they choose.

Joe
2022 PRICING CALCULATOR.xlsx

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 ? :roll:) 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!
Awesome
1 Star Member
1 Star Member
Posts: 23
Joined: Fri Jun 07, 2024 4:31 pm

Re: CNC Plasma Cutting Excel Pricing Worksheet

Post by Awesome »

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.
Skidmore
1 Star Member
1 Star Member
Posts: 13
Joined: Wed Sep 20, 2023 9:24 pm
Location: Montana

Re: CNC Plasma Cutting Excel Pricing Worksheet

Post by Skidmore »

Thank you for this, I tweaked some of the costs and prices and found I was undervaluing my products and time.
Post Reply

Return to “Pricing, Advertising, & Marketing Your Products Forum”