Need an application that can do some calculations from fields in a settings section and read some prices from a csv file. there are some rules that are needed. This is for a print shop to give quotes in matter of seconds.
First: User will input Qty in main window, then will choose type of product. and type of paper (like in screenshot), will continue to choose other requirements.
Csv file will have information for the type of paper needed and price for this paper. prices will be based on qty of 1000, everything is based on this qty.
i would like to have fields in the settings window, but if it is easier i can create csv files for all values and just select the file to corresponding value.
I have included sample csv files to show the format they will be in.
Formula: (price/sheet*qty (in main window)+Ink cost(per color)+Padding Cost+Cutting cost+Registration Cost+Pantone colors)*MarkUp
-Price per sheet will be detemined by using csv file that will contain paper type and cost per 1000
-Ink Cost is the cost to print. it is calculated per 1000, if less than 1000 is printed, then the charge is 15 (in csv file) if 1250 are printed, then the charge is 15+10 (15 for 1st 1000, and 10 for each additional 1000, you get this info from csv file)
-Padding is charged like ink cost on a per 1000 basis,
-Cutting Cost is charged on a per 250 basis.
-Registration and Pantone are charged on a per 1 basis for each. i should be able to pick unlimited number of Colors, Registrations and Pantone Colors.
-Mark up, there needs to be a MarkUp field in the settings so this can easily be changed without the use of csv files. which will just mark the price up from printers cost for printing.
I have included screenshots to show what i imagine this to look like. If you submit a demo will help me pick someone sooner because Ill know you understand what the requirements were.
I think i have included everything. Please feel free to contact me with any questions.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
Windows 98 and up to XP