Closed

Excel Sheet for Quick Quote

This project was awarded to icodeinvb for $85 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$100 - $115 USD
Total Bids
10
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online