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
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.
MS Excel 2000 & Palm OS