Project Price Estimator
- This topic has 10 replies, 6 voices, and was last updated 8 years, 6 months ago by mkimber.
-
AuthorPosts
-
13 October 2015 at 4:34 am #131273
Hi everyone,
I’m writing a neat little calculus program in excel for us all to work out the costs for a project and what you can charge for your finished piece.
To give you a heads up of what will be included:
Every timber species that is currently available and used in shops other than sheet goods since most of us hand toolers don’t work with sheet goods unless we really, really have to. You won’t find timbers that are unavailable. This is selection of species is good for Australia, UK, Europe and the US. However if I have missed a species you can always add that in.
I am currently working on integrating both metric and imperial. If I’m unable to do that I may use a drop down box and then you select and write in decimal inches as fractional doesn’t work (pity) metric well that’s so much simpler to work in. Wouldn’t it be nice if the US converted.
You will see hourly rate, number of hours worked, components or parts plus costs, mark up etc.
This is still in it’s infancy stage and ideas are flowing and like my woodworking changes are being made. I hope to finish it soon and yes this will be free to everyone worldwide.
There is no installation as long as you have Excel it will work but I am using the 2016 version so I am not sure whether it will be compatible in lower versions. I have no way of testing this so I will rely on you for this.
I am also building my websites and blog area, I’m hoping to tap into the world market so your support in this would be greatly appreciated.
Let me know if you would be interested in such a program.
13 October 2015 at 5:55 am #131274Just a quick update I’ve made it to accept both mm and inches all I did was change the decimal parameters the only thing is it doesn’t have the symbols which shouldn’t matter because you know what your working in. The extra work isn’t worth it besides I would have to make two separate programs for that.
Here is a sample:
(inches) 36 x 18 x 0.375
(metric) 914.4 x 457.2 x 9.52Before it was rounding the numbers now it’s not.
13 October 2015 at 6:22 am #131275Awesome! II am going to take a look at this tomorrow. Thanks 🙂
13 October 2015 at 12:50 pm #131283Coming from a guy that can’t even type
This is pure magic
Love it
Frankj13 October 2015 at 1:03 pm #131286Thanks Frank I just tested it out to see how it works in 2007 and so far so good, I still have some more to do but hopefully very soon. The 2016 version I got is buggy so I’m reverting back to 2007 and in the mean time I’m going to give them an earful tomorrow. It’s locked my brand new system more than 20 times. I’ve had to do a cold reboot which is not ideal, so far I haven’t worked wood in a week and a half. It’s like the old days just sitting behind the screen till wee hours of the night and then up again at dawn.
15 October 2015 at 5:20 am #131349This is insanely difficult. Why is the US still stuck in feet and inches.
17 October 2015 at 4:05 am #131439I haven’t given up but I scrubbed it atleast 5 times, the hardest part is the formula’s and keeping it simple. I will need to create to versions one for metric and one for imperial the only thing getting it to work out the total Bdft using feet is impossible because excel does not like the quotation marks, so you will need to convert all your feet into inches only and you will then a total bdft result.
Anyway so far only page.1 has been completed.
20 October 2015 at 11:29 pm #131536I have searched throughout their symbols and quote marks are not in there and it never gave me an option to custom add them either, but it doesn’t matter as I have added the “mm” in the headings which is what this estimator version is based on the metric system. It will work out a cutlist.
The good news is I have completed it last night and I am just going over it one last time to check for errors.
-
AuthorPosts
- You must be logged in to reply to this topic.