Find Jobs
Hire Freelancers

Estimating + Quotation-Invoicing system for small shop

$750-1500 CAD

Closed
Posted almost 11 years ago

$750-1500 CAD

Paid on delivery
I have a relatively simple project that entails two sections. It is a specialized estimating system that will allow the workers of a sheet metal fabrication shop to enter dimensions of specific types of sheet metal enclosures and ducts, and then have the program calculate amounts of sheet metal required, cost per unit dependent upon the gauge/thickness/type of the metal, and add in a factor for labour, and the option to add in a couple other variable factors per type of shape. (Imagine a series of duct shapes... a "Y"-shaped vent, a curved right-angle bend, a reducing channel... all fairly standard shapes in the HVAC industry. However, a contractor will bring in specific dimensions, usually in inches, of how large the openings will be, how wide, tall and deep a component will be, etc. THERE is where the dimensions need to be entered into a subprogram for each type of shape, then the factors calculated to come up with a final cost.) See the attached PDF document for additional data that will clarify what the shop currently runs with, and what is required. The above mentioned part is relatively easy, actually, and I would do it myself in Excel, except the resultant quote results (and this is the second part of the project) must be stored in a format that can be brought over into a quotation/invoicing structure that can be stored like any typical sales/estimating/quoting system. The girl at the front of the shop must be able to bring up the data in its quoted form, confirm with the customer all the details, then save that as a customer order and later, an invoice that will be stored. Typical post-processing, in terms of end-of-month sales reporting, lookups, etc., must be possible from such a system. Either side of this type of processing is not terribly difficult; however, I have been unable to find a commercial package that will do such a task relatively economically... the ones who CAN do the estimating part are massive, expensive programs with long learning curves, offering so many features that the needed estimation part is less than a tenth of all that is offered; hence, much of the remaining application is never used and wasted. Companies with estimating/quoting/records-retrieval systems are a dime-a-dozen, but cannot do the variable-shape-dimensioning type of quoting required. Try to think of the finished product as a typical, relatively simple, quoting/invoicing/AR/AP, the kind that an experienced ACCESS programmer probably already has lots of boilerplate code for. The only difference is that the product costs come in through the estimating section from the shop floor, and I would supply all the formulas for that to work, most likely in Excel format, so the existing, working formulas can be transferred wholesale into your developed product. I would have done the project myself, but two limiting factors apply: 1) My MS-Access knowledge is rusty... somewhere over 10 years old. I am, however, very experienced in Excel and a range of other applications. 2) I have several other projects on the go, some technical, some programming and some investment, that prevent me from applying the proper amount of time required to do this in a timely manner. I would hope a programming task such as this could be accomplished in less than a week or two, with follow-up adjustments as required. If it would take more than 3 or 4 weeks to complete the main body of programming, this may not be feasible. Please advise accordingly. I await your response. Please respond with any clarifications you require. Thank you for your consideration. W. Halyn
Project ID: 4549273

About the project

16 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average $1,117 CAD for this job
User Avatar
VB, VBA and Databases expert for over a decade. Msc in Information Systems.
$750 CAD in 7 days
5.0 (248 reviews)
7.7
7.7
User Avatar
Can you give your existing Dos based application of calculations for analysis. I will appreciate if you let me know which other features of your existing software are to be used in New MS Access database application.
$1,172 CAD in 14 days
5.0 (226 reviews)
7.4
7.4
User Avatar
Hi, I have 12 years experience developing MS Access applications and feel confident that I could do this project for you. I would give this project priority in order to complete within the deadline. Please view my portfolio for some examples of my work.
$1,200 CAD in 14 days
4.9 (23 reviews)
5.5
5.5
User Avatar
I have 15 years exp building access databases. I would like to be the person to builds yours. I can start today. Thanks Donna
$1,111 CAD in 7 days
4.5 (34 reviews)
5.8
5.8
User Avatar
Hi, I have experience with this project, I happily if work with you in this project. Best Regards winnet21
$900 CAD in 14 days
4.6 (17 reviews)
5.1
5.1
User Avatar
I have 20 years of Access and VBA experience - please see your PMB for further details of my proposal.
$1,500 CAD in 14 days
5.0 (9 reviews)
4.8
4.8
User Avatar
Hi, Plz check PM
$1,111 CAD in 15 days
4.8 (3 reviews)
3.3
3.3
User Avatar
hi please check pm
$1,250 CAD in 10 days
5.0 (1 review)
1.0
1.0
User Avatar
I am interested in your project
$1,250 CAD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We can do this for you. But I would want to know if you would prefer it to be a web based application and done in PhP and my SQL instead of MS - Access. Please let me know if you would be interested in discussing this option. Thanks Lakshmi Swaminathan Cuion Technologies Pvt Ltd
$1,578 CAD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings Mr. Halyn. I have checked your requirements and I am ready to start. Please check my samples of past works along with some presentation of my work. Thanks also for your well detailed project. Best regards Filipe Francisco , VB Expert ============================== Tablassus Software "Simple Solutions for Complex Problems"
$833 CAD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I can start with the design and development right away. I will follow up with a 3 month free post-launch support that could be ongoing as per your requirements. Payments can be made in milestones after satisfaction with the completed work. To start with, Ours is an international award winning team for design-development and we will put in our best. Please check PM for more on my work profile. Thanks and regards - FrankHardy
$1,150 CAD in 28 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm willing to work on this project - it sounds interesting
$1,211 CAD in 11 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I want to thank you for the opportunity to bid on your project. I will bring over 19 years of experience developing business and invoicing applications with Ms Access and Visual Basic to bear on your project should you elect to award the project to me. I will deliver documented source code and users guide. Please contact me if you need any further clarifications on any or all aspects of my bid.
$833 CAD in 15 days
0.0 (0 reviews)
2.4
2.4
User Avatar
This would probably take less than a week.
$777 CAD in 6 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Muskoka, Canada
0.0
0
Member since May 21, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.