Excel Pricing Worksheet

Learn & share techniques, strategies, and experiences on marketing your plasma cut products in this forum.
User avatar
tnbndr
Elite Contributing Member
Elite Contributing Member
Posts: 1458
Joined: Mon Jan 09, 2012 4:30 pm
Location: New Berlin, WI
Contact:

Re: Excel Pricing Worksheet

Post by tnbndr » Wed Mar 28, 2018 7:56 pm

Staying with the excel version unless some has figured a way for the program to accept input data and save it.
If this is the app you are referring to: http://plasmaspider.com/viewtopic.php?f=88&t=17569
Follow the entire thread, I had the same issues and it has to do with where Windows is storing your files. It is saving your files with changes but in a location the program is not looking for them. You have to move them to the PlasmaEst folders and overwrite.
Dennis
LDR 4x8, Scribe, DTHCIV
PM45
DeVilbiss Air America 6.5HP, 80Gal., 175psi, Two Stage
[email protected], [email protected]
Miller 215
RW 390E Slip Roll
AutoCAD, SheetCAM, Mach 3
https://www.facebook.com/ikescreations?ref=hl
http://ikescreations.com

RhinoRearends
Posts: 1
Joined: Tue Dec 12, 2017 11:03 am

Re: Excel Pricing Worksheet

Post by RhinoRearends » Sat Jul 21, 2018 12:24 pm

Are you referring to the DD Metal Products Plasma Estimator? If you go into the File -> Setup, this should update your particular setup variations, steel prices, pierce charges, etc.

Eddie Tabor
Tabor Services
Mcallen, TX

Hazzard Engineering
Posts: 2
Joined: Sun Aug 05, 2018 7:26 am

Re: Excel Pricing Worksheet

Post by Hazzard Engineering » Sun Aug 05, 2018 6:44 pm

Cheers for that, I will have a play and see how it goes.

Cheers
Hugh

GreenDeere
Posts: 1
Joined: Sat Sep 29, 2018 2:53 pm

Re: Excel Pricing Worksheet

Post by GreenDeere » Sat Sep 29, 2018 3:02 pm

Hello all - we are new to the CNC world and have been surfing around for a good way to figure prices on our product. I see that an Excel spreadsheet was shared a while back, but I dont' see a link or attachment to the post. How do I go about being able to see it? I saw something that said about becoming a contributing member???

Any help is appreciated. Thanks so much.

plasmanewbie
Elite Contributing Member
Elite Contributing Member
Posts: 748
Joined: Thu Jul 24, 2008 11:15 am

Re: Excel Pricing Worksheet

Post by plasmanewbie » Sat Sep 29, 2018 8:08 pm

GreenDeere wrote:Hello all - we are new to the CNC world and have been surfing around for a good way to figure prices on our product. I see that an Excel spreadsheet was shared a while back, but I dont' see a link or attachment to the post. How do I go about being able to see it? I saw something that said about becoming a contributing member???

Any help is appreciated. Thanks so much.
Welcome to the site! The Excel spreadsheet is on the first post on the first page. To become a contributing member just click on your username near the upper right corner of the screen when logged in and from the drop down menu click on membership renewal.

Kenneth
Posts: 1
Joined: Wed Dec 05, 2018 4:06 pm

Re: Excel Pricing Worksheet

Post by Kenneth » Thu Dec 06, 2018 9:18 am

Thanks Danny.

ForceDesigns
Posts: 44
Joined: Mon Oct 22, 2018 7:08 pm

Re: Excel Pricing Worksheet

Post by ForceDesigns » Fri Dec 07, 2018 1:49 pm

Awesome, this should help those of us just starting out a ton. Appreciate the help. Love this site. Tons of help.
Home Built 4x4 CNC Plasma Table
Ethernet Smoothstepper
C25 BOB
MiniTHC
Hypertherm Powermax 45XP
Software: Mach3 and Sheetcam, Solidworks 2019 for serious design work and Inkscape for signs

User avatar
East German
Elite Contributing Member
Elite Contributing Member
Posts: 450
Joined: Sat Jan 05, 2013 8:21 am
Location: Stapelburg Germany

Re: Excel Pricing Worksheet

Post by East German » Mon Dec 10, 2018 8:17 am

Thanks Danny / mdwalker ;)

Here is a Test Version:

Input in mm or inch.
Display Dollar and Euro!

Peter

You do not have access to view or download this file.
Become a Contributing Member to gain access to this feature. Click Here

Sorry for my language! The last English class was in 1982.

Homemade CNC Plasma-Watertable with Mach 3
Triple Beast + Leadschine Drive
Hypertherm Powermax 85
Machine Torch + PriceCNC THC
Hypertherm Powermax 1100
Machine Torch + Proma THC

MaverickMetal
Posts: 1
Joined: Thu Feb 07, 2019 10:49 am

Re: Excel Pricing Worksheet

Post by MaverickMetal » Thu Feb 07, 2019 10:56 am

Thank you very much! This spreadsheet will help a lot with upcoming material quotes nd jobs!

Gearheadmex
Elite Contributing Member
Elite Contributing Member
Posts: 56
Joined: Sat Apr 27, 2013 9:10 pm

Re: Excel Pricing Worksheet

Post by Gearheadmex » Fri Feb 08, 2019 3:48 pm

EZ Router APC 4 x 8
V- Carve Pro
SheetCam
Mach3

dblas
Posts: 7
Joined: Wed Jun 06, 2018 11:33 am

Re: Excel Pricing Worksheet

Post by dblas » Sun Feb 24, 2019 11:04 am

Thanks for .xls, I will play with it over the next week and see if I can get the boss to sign off on using it.

One question, how is everyone figuring up cut inches? I understand pierce points, and after a certain number on really intricate pieces, I assume folks just flat rate it?

Thanks in advance.

dblas
Posts: 7
Joined: Wed Jun 06, 2018 11:33 am

Re: Excel Pricing Worksheet

Post by dblas » Sun Feb 24, 2019 11:12 am

dblas wrote:
Sun Feb 24, 2019 11:04 am
Thanks for .xls, I will play with it over the next week and see if I can get the boss to sign off on using it.

One question, how is everyone figuring up cut inches? I understand pierce points, and after a certain number on really intricate pieces, I assume folks just flat rate it?

Thanks in advance.
Never mind, read further down the forum and found that Sheetcam has a report for cut inches and number of pierce points.

Thanks.

Soter907
Posts: 7
Joined: Mon Feb 04, 2019 9:30 pm

Re: Excel Pricing Worksheet

Post by Soter907 » Sun Mar 03, 2019 9:46 pm

following to see if there is an updated file.

karensmc
Posts: 21
Joined: Mon Jan 02, 2017 3:30 pm

Re: Excel Pricing Worksheet

Post by karensmc » Wed Mar 06, 2019 2:08 pm

How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?

User avatar
firecapt
Posts: 5
Joined: Sat Oct 15, 2016 11:53 am

Re: Excel Pricing Worksheet

Post by firecapt » Wed Mar 06, 2019 3:36 pm

karensmc wrote:
Wed Mar 06, 2019 2:08 pm
How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?
You can roughly figure cut inches in InkScape by selecting the image and going to "Extensions" > "Visualize Path" > "Measure Path"
Make sure the image is made into a complete combined Path.
menu.png
box.png

You do not have access to view or download this file.
Become a Contributing Member to gain access to this feature. Click Here


User avatar
Ironken
Elite Contributing Member
Elite Contributing Member
Posts: 266
Joined: Thu Nov 30, 2017 7:29 pm

Re: Excel Pricing Worksheet

Post by Ironken » Wed Mar 06, 2019 6:05 pm

karensmc wrote:
Wed Mar 06, 2019 2:08 pm
How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?
In sheetcam, do a jet report. The icon is in the upper left corner of the screen. Tells elapsed time, pierces and length.

karensmc
Posts: 21
Joined: Mon Jan 02, 2017 3:30 pm

Re: Excel Pricing Worksheet

Post by karensmc » Wed Mar 06, 2019 7:31 pm

Ironken wrote:
Wed Mar 06, 2019 6:05 pm
karensmc wrote:
Wed Mar 06, 2019 2:08 pm
How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?
In sheetcam, do a jet report. The icon is in the upper left corner of the screen. Tells elapsed time, pierces and length.
Does it need to be put into a .tap file? I tried with a dxf and it didn't work.
thanks for the help?

karensmc
Posts: 21
Joined: Mon Jan 02, 2017 3:30 pm

Re: Excel Pricing Worksheet

Post by karensmc » Wed Mar 06, 2019 7:33 pm

firecapt wrote:
Wed Mar 06, 2019 3:36 pm
karensmc wrote:
Wed Mar 06, 2019 2:08 pm
How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?
You can roughly figure cut inches in InkScape by selecting the image and going to "Extensions" > "Visualize Path" > "Measure Path"
Make sure the image is made into a complete combined Path.menu.pngbox.png
I tried this with a .svg file, but I couldn't see anything that looked like approx cut length/inches. Does it need to be
in a .dxf file or am I missing something?
thanks for the help!!!

User avatar
Ironken
Elite Contributing Member
Elite Contributing Member
Posts: 266
Joined: Thu Nov 30, 2017 7:29 pm

Re: Excel Pricing Worksheet

Post by Ironken » Wed Mar 06, 2019 9:08 pm

karensmc wrote:
Wed Mar 06, 2019 7:31 pm
Ironken wrote:
Wed Mar 06, 2019 6:05 pm
karensmc wrote:
Wed Mar 06, 2019 2:08 pm
How do you figure inches cut? It there somewhere in inkscape, sheet-cam or Mach that shows the total inches to be cut?
In sheetcam, do a jet report. The icon is in the upper left corner of the screen. Tells elapsed time, pierces and length.
Does it need to be put into a .tap file? I tried with a dxf and it didn't work.
thanks for the help?
For artsy/trinket stuff, I price the item whatever I think it's worth if I charge at all. I usually only do that kind of work for friends and family. It's just not worth it for me to mess with by the time I add up CAD time, cut time, picky customers that want more than they're willing to pay for, etc. My machine makes its money on contract parts. For that, I want my machine to make $200/hr+....so I take cut time in minutes and multiply by $3.50/min, then add the price of steel with a 50% markup on the steel.

This pricing is probably low but, I nest half sheets with little waste. I do this in volume and it leaves a little meat on the bone for the customer. The beauty of going by the minute is that on thicker material, the slower cut already has a price increase built in because I charge by the minute.

To generate a "job report" work from the bottom pic up.....I can't put them in the correct order.....

-Import your drawing
-Edit Contours
-Apply jet cutting operations
-Click on the icon that looks like a pencil and paper (job report)
-choose "job summary" click OK
-your info should be on the generated page.....it is printable should your customer question time or length.

You do not have access to view or download this file.
Become a Contributing Member to gain access to this feature. Click Here


User avatar
tnbndr
Elite Contributing Member
Elite Contributing Member
Posts: 1458
Joined: Mon Jan 09, 2012 4:30 pm
Location: New Berlin, WI
Contact:

Re: Excel Pricing Worksheet

Post by tnbndr » Thu Mar 07, 2019 5:09 pm

.I can't put them in the correct order.....
Just insert the images in reverse order, last one first, first one last.
Dennis
LDR 4x8, Scribe, DTHCIV
PM45
DeVilbiss Air America 6.5HP, 80Gal., 175psi, Two Stage
[email protected], [email protected]
Miller 215
RW 390E Slip Roll
AutoCAD, SheetCAM, Mach 3
https://www.facebook.com/ikescreations?ref=hl
http://ikescreations.com

User avatar
Ironken
Elite Contributing Member
Elite Contributing Member
Posts: 266
Joined: Thu Nov 30, 2017 7:29 pm

Re: Excel Pricing Worksheet

Post by Ironken » Thu Mar 07, 2019 6:44 pm

tnbndr wrote:
Thu Mar 07, 2019 5:09 pm
.I can't put them in the correct order.....
Just insert the images in reverse order, last one first, first one last.
That makes waaaay too much sense.

karensmc
Posts: 21
Joined: Mon Jan 02, 2017 3:30 pm

Re: Excel Pricing Worksheet

Post by karensmc » Thu Mar 07, 2019 7:50 pm

Ironken wrote:
Thu Mar 07, 2019 6:44 pm
tnbndr wrote:
Thu Mar 07, 2019 5:09 pm
.I can't put them in the correct order.....
Just insert the images in reverse order, last one first, first one last.
That makes waaaay too much sense.
THANK YOU!!! It worked perfectly and gave me what I was looking for! I don't do much that I charge for as we use our
machine mostly for our parts and personal things. But it's nice if someone is willing to pay me and makes it easier for me
to give them a fair price.

User avatar
Ironken
Elite Contributing Member
Elite Contributing Member
Posts: 266
Joined: Thu Nov 30, 2017 7:29 pm

Re: Excel Pricing Worksheet

Post by Ironken » Thu Mar 07, 2019 8:04 pm

karensmc wrote:
Thu Mar 07, 2019 7:50 pm
Ironken wrote:
Thu Mar 07, 2019 6:44 pm
tnbndr wrote:
Thu Mar 07, 2019 5:09 pm

Just insert the images in reverse order, last one first, first one last.
That makes waaaay too much sense.
THANK YOU!!! It worked perfectly and gave me what I was looking for! I don't do much that I charge for as we use our
machine mostly for our parts and personal things. But it's nice if someone is willing to pay me and makes it easier for me
to give them a fair price.
You are very welcome! Glad I could help. If I remember correctly, one of the local steel shops is charging .17-.21 a linear inch and possibly .25 per pierce.

53hudson
Elite Contributing Member
Elite Contributing Member
Posts: 42
Joined: Tue Aug 22, 2017 4:22 pm

Re: Excel Pricing Worksheet

Post by 53hudson » Mon Aug 26, 2019 8:10 am

Thanks for a start on this Danny

Post Reply

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

Easyscriber engrave attachment for Hypertherm plasma cutters.