Pricing Calculator

[eckcotech]

Hey all,

I wrote a small pricing calculator for our plasma table and so far it seems to work pretty well for what we do. I figured that since the sight has helped me on numerous occasions, I would contribute back the best way I could, by sharing the program..

http://www.eckcotech.com/Files/Plasma%2 ... 20Calc.exe

It's not exactly a scientific approach it is just a simple little tool I made to help give me a quick off the cuff estimate so I can deliver a quote quickly without the risk of undercutting myself and doing a job for free.

Just setup your materials, table rate (include you cost to run the table), and per pierce price and you should be all set to start using it.

You can ignore the cut profile settings and combobox for now, that is being used for an update I am working on. At some point, I would like to have an import function to import a dxf and get an auto quote based on the file. I won't make any promises as to when that will be, but I am working on it.

If you have any suggestions, feel free to pass them on.

[jimcolt]

I get a little nervous about downloading an executable (.exe) type file when I am not 100% sure it is from a safe source! I'm pretty sure you have a nice program there....but is it safe?


Jim Colt

[eckcotech]

Hey Jim,

I see your point. I am a software developer by trade and I can assure you it's very safe. This app was developed in house and my contact info is on my web site if you have any questions.

http://www.eckcotech.com

That said, I have seen MANY more viruses, malware, and just plain bad stuff passed in excel sheets and word docs as macros then in exe files by a long shot. Generally someone passing a virus or some such thing is a bit more crafty.

And lastly, your caution should be commended. most people don't hesitate to download all the little bells and whistles without a second thought. In this case however, I'm not sure how to offer a piece of software for free without making the setup.exe available so users can install it.

I guess I could zip it into a compressed file, this does make some people feel better but really it's like putting a bomb in a cake box. If it's a bomb, its a bomb period.

[jmsrbrt]

I get an error message "unhandled exception has occurred in your application...data type mismatch in criteria expression" when trying to enter a material type. ???

[BrianMick]

I get the same unhandled error when I try to open it
Brian

[eckcotech]

I get an error message "unhandled exception has occurred in your application...data type mismatch in criteria expression" when trying to enter a material type. ???

That error is most likely caused by the wrong type of data being put into a column. Here is an example of what the data should look like.....(I should have put notes on the header names)...



Description - text (just a general description
Thickness - in inches (decimal) ex. .25
SheetSize - size of sheet in sq inches. ex. 4x8 sheet = 4608
SheetPrice = dollar amount (decimal) example 53.00
Markup Percent = percentage of markup (decimal or whole number) ex 200 = 200% markup

[BrianMick]

This is the error I get when I first open it. If I ingnore it opens but I cant save any configs or I get same message.....
Can you tell me whats wrong? I already tried uninstalling and re installing......
Brian


Unhandled exception has occured in your application
the microsoft ACE.OLEDB.12.0 provider is not registered on the local machine
Details
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Plasma_CNC_Job_Calc.PlasmaCalcDataSet1TableAdapters.TableSettingsTableAdapter.Fill(TableSettingsDataTable dataTable) in C:\Users\Corye\Desktop\Plasma CNC Job Calc\Plasma CNC Job Calc\PlasmaCalcDataSet11.Designer.vb:line 3124
at Plasma_CNC_Job_Calc.Form1.Form1_Load(Object sender, EventArgs e) in C:\Users\Corye\Desktop\Plasma CNC Job Calc\Plasma CNC Job Calc\Form1.vb:line 15
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3625 (GDR.050727-3600)
CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Plasma CNC Job Calc
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Eckco%20Technologies,%20Inc/My%20Product%20Name/Plasma%20CNC%20Job%20Calc.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3624 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3623 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data.DataSetExtensions
Assembly Version: 3.5.0.0
Win32 Version: 3.5.30729.1 built by: SP
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Data.DataSetExtensions/3.5.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
----------------------------------------
System.Core
Assembly Version: 3.5.0.0
Win32 Version: 3.5.30729.1 built by: SP
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[eckcotech]

BrianMick,

It sounds like you do not have the full office 2007 data connectivity driver installed. This should have installed with the application but it seems to have not done so. You can download that directly from Microsoft and install it from this link...

http://www.microsoft.com/download/en/de ... n&id=23734

Once installed, try to open it again.

I will look through the install application and see if I can pin down what would make this component miss during the install.

[BrianMick]

that did the trick...........now I can try it out and see how it works.....thanks
Brian

[deanfowell]

I like this program works good on windows xp but i cant get it to work right on windows 7

[4eleven]

Have there been any updates to this calculator? I'm looking for a pricing calculator and am having trouble finding one.

[tnbndr]

Have there been any updates to this calculator? I'm looking for a pricing calculator and am having trouble finding one.

Try this Link;
https://plasmaspider.com/viewtopic.php?f=88&t=9565