In Progress

Excel Sheet for Quick Quote

I have an excel list of about 250 items (stones, crystals and nailheads) with both part numbers and price. We need a spreadsheet that will accept the following input and use the data in the spreadsheet to make a calculation. The spreadsheet should be locked with our code so that only certain input can be made by the user so that they can't mess it all up. I would like to know if this job can be turned into a stand alone Palm pilot program in addition to the excel spreadsheet, by that I mean not using an excel viewer but a stand alone custom program in Palm OS

## Deliverables

The spreadsheet with the price list is in Euro. We want the end result in USD & CAN$ We want a cell to accept the value of the currency exchange. To test use USD exchange factor (See [url removed, login to view] ) Then with that figure entered they can plug in this info from the price list: Part # and quantity (1-4 parts and quantity) Total Number of designs Total cost of one design (with the 1-4 parts added up) Total cost of the parts in a design Then it should take the X & Y dimensions of the design (in metric and or imperial add a ½?? ) and calculate the cost of the backing material it needs per design: Cost of single transfer paper Square area of transfer paper and the total needed and then how many 11?? by 19?? sheets it will need. There are three price ranges of this foil paper. Finally the sheet needs to give me a summary section: Approximate time for production (Machine operates at 1 stone per second or 60/minute or 3600 per hour) Cost of single design, total cost of the entire order. And a cell where I can add in my margins. If I want 40%, 50%, 100% or 300% markup it should calculate it for me.

## Platform

MS Excel 2000 & Palm OS

Skills: Engineering, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Software Architecture, Software Testing, Word

See more: spreadsheet engineering, production spreadsheet, make a quote, imperial design, how to make a quote for a job, how to make 100 in an hour, custom list in excel, 42 design square, one sheet design, job for me test, excel test for job, i want to know about engineering, transfer data into an excel sheet, time sheet, test paper, sheet, quick order, material engineering, excel spreadsheet job quote, excel calculation, excel add-in, excel add in, excel 50/60, design me a machine, quick excel

About the Employer:
( 3 reviews ) United States

Project ID: #2936049

Awarded to:

icodeinvb

See private message.

$85 USD in 14 days
(315 Reviews)
7.1

10 freelancers are bidding on average $88 for this job

gribfritz

See private message.

$93.5 USD in 14 days
(477 Reviews)
7.6
DiegoCalp

See private message.

$85 USD in 14 days
(49 Reviews)
5.5
pvavw

See private message.

$85 USD in 14 days
(39 Reviews)
3.9
barreiro04

See private message.

$85 USD in 14 days
(22 Reviews)
3.7
vivekdvw

See private message.

$85 USD in 14 days
(5 Reviews)
3.2
vw570677vw

See private message.

$85 USD in 14 days
(3 Reviews)
2.2
code4youvw

See private message.

$85 USD in 14 days
(4 Reviews)
1.5
tomknowlton

See private message.

$96.9 USD in 14 days
(0 Reviews)
0.0
vw840909vw

See private message.

$97.75 USD in 14 days
(0 Reviews)
0.0