Simple sales quote calculator based on excel price charts

Closed

Description

I need a sales quote calculator for Windows XP and Windows 7 that will allow me to enter a number of materials, each at different sizes, and calculate the total cost based on price charts stored in excel spreadsheets.

I am trying to streamline the quoting process.

Right now when my sales staff need to quote an order they have a book of spreadsheets in which they look up each item at each size and add up all the prices.

I'd like a simple program that will let them add any quantity of specific materials, each at a specific size (length x width), that will reference the excel entry for that material, at that size, and create a final total, with any applicable discounts.

It's important that it be able to reference an excel spreadsheet because our materials cost change over time and we'd like to be able to update it manually.

Specifics:

- 30 unique materials with corresponding excel files

- Up to 16 Rows X 32 Columns of prices (512 entries) for each material to be referenced

- Some materials have one price for the first unit ordered, and a discounted price for each additional.

- For each entry I need input boxes for:

- Quantity

- Material Type

- Length

- Width

- Discount Percentage

- A "+" button to add a new field

-A global discount percentage for simply discounting the entire order.

- Each new entry line should auto-fill from the previous, since most parameters are often similar (eg. quantity, size, discount).

- The Material Type field should be a drop down menu as well as auto-fill the alphabetically closest option, to speed up input.

- For ease and speed you should be able to use only the keyboard for all entries:

- ie. press Tab to go from field to field, press + to add a new entry line, press the up and down arrows to scroll through field options.

I do not need invoicing, saving or printing functionality, as we have that with our accounting software.

I am open to options that may be more simple than referencing excel files for pricing, as long as they allow for dynamic updating.

If this software works well I would be open to paying for added features in the future.

Skills: Excel, Software Architecture, User Interface / IA, Visual Basic, Windows Desktop

See more: sales quote calculator, price quote calculator excel, quote calculator excel, simple quote calculator, sales price calculator excel, create pricing quote calculator excel, excel price quote calculator add, simple material quote excel, excel based sales quote software, quote calculator, visual basic price, simple entry in accounting, simple accounting spreadsheet, pricing calculator excel, on line accounting software, on line accounting, cost accounting spreadsheet, calculator for accounting, excel price charts, final price, discount printing, time accounting software, i need sales staff, spreadsheet excel and accounting, spreadsheet (excel) and accounting

Project ID: #4308300

Awarded to:

bharanisrihari

Hello, Excel VBA expert here. I've done many similar projects. Please check PM for details. Thanks!

$100 CAD in 3 days
(66 Reviews)
6.5

22 freelancers are bidding on average $122 for this job

mrbrave

Hi..I have past experience of developing cost calculators...See messagebox for demo.

$100 CAD in 2 days
(79 Reviews)
5.4
rajanlengde

I can do this well with a simple desktop application, Please see PMB

$150 CAD in 20 days
(27 Reviews)
5.1
ProfessionalBoss

I am here to do it

$500 CAD in 9 days
(3 Reviews)
4.6
kulhanekd

I have 15 years exp in excel and access. I can create the form you need for your quoting process. Donna

$150 CAD in 3 days
(11 Reviews)
4.5
Pharoa

Thank you for the opportunity to bid on your project. I propose to develop the calculator using Visual Basic 2010 in 5 days from the date of bid acceptance. I have very strong Visual Basic skills, using it for bu More

$150 CAD in 5 days
(1 Review)
3.8
JackBradford

Hello, I can accomplish the automated quote system you seek using Excel VBA. You will be able to create quotes as well as you will be able to change variables through an admin tab. I can even create a custom outpu More

$90 CAD in 1 day
(9 Reviews)
3.8
pixecs

Dear sir, i can help you with this project. I have over 16 years of experience in C/C++ development.

$75 CAD in 5 days
(7 Reviews)
3.7
vikashgadia

we have all the required capability make application as per ur 100% satisfaction

$100 CAD in 5 days
(15 Reviews)
3.6
armitagecorto

Hi, i have experience in converting excel formulas into executable applications.

$60 CAD in 7 days
(9 Reviews)
3.5
srdas2012

Hi Please check PMB

$120 CAD in 7 days
(11 Reviews)
3.4
sudewa

Hi, I am thinking of building a C# application for your requirement since it is easy to update/maintain your software. We can store the data in Access and provide a user interface for the users to update the data More

$200 CAD in 20 days
(2 Reviews)
2.7
epdailo

i would like to help you on this project. Please select me.

$30 CAD in 7 days
(2 Reviews)
2.2
Prinol

We can get this done.Please check PMB for a sample Calculator.

$100 CAD in 1 day
(2 Reviews)
2.2
xeancaile

Consider it done.... please see PMB...

$30 CAD in 2 days
(5 Reviews)
2.2
bubu77

Hi, MS Access/Excel expert having 8+ years of IT experience. I can do the project for you. Please see your PM for more details.

$150 CAD in 15 days
(1 Review)
2.0
TimotiusSL

I already create sample based on your description. Hope you'll like it. :)

$90 CAD in 3 days
(0 Reviews)
0.0
larryagrossman

I have previous created pull downs and a GUI via Excel macro code. I have also extracted excel data and created new spreadsheets. All for a financial firm in NY, NY. I entered a low bid since I need the work and nee More

$200 CAD in 3 days
(0 Reviews)
0.0
AbhilashMishra

Hi, I can get your project done.

$50 CAD in 3 days
(0 Reviews)
0.0
PercevalCiro

Dear digitalpassword, we have carefully considered your project and we are glad to confirm that we can do it. We really appreciate considering us for your project. More details in PMB. Best Regards.

$150 CAD in 5 days
(0 Reviews)
0.0
johnboscow

I am looking forward to join with you.

$30 CAD in 5 days
(0 Reviews)
0.0