Calculated pricing of bespoke website products.

We sell foam cut to size on the internet; we have an existing website, [login to view URL], that allows user input and a submit button that emails us details and then we contact the user by phone with a quote. We now have a new website where we want to allow similar user input but where the submit button will email us all the details in the same way, and also give the user an immediate quotation and an option to purchase onsite. At this stage all we require is a system to give an immediate quotation - the facility to buy will be a seperate issue. It would be good if the coding could be kept private from anyone looking at the source code if that were possible. We would require access to and ownership of the coding. ## Deliverables The work to be completed within 7 days of an agreed contract. * * *This broadcast message was sent to all bidders on Monday Dec 20, 2010 7:03:10 AM: Hi, Many thanks for your interest. This project calls for the setting up of user data entry textfields,dropdown lists, a submit button, and a number of variables, and some formulas that calculate a final purchase price that can be passed to a PayPal check out. There is also a requirement to send the user a confirmation email, and to send an email with full order details to us. The user input textfields are to be as shown on our other website [login to view URL], but with the field order as specified below for the email to us, so that we can continue to use our same processing software once we receive the email. Anything not clear please ask ! Field order zname zadd1 zadd2 zadd3 zpcode zemail zphone zlg1 (Line 1 textfield for length) selector1 (Line 1 dropdown selector - Ins and Cms) s zwide1 (Line 1 textfield for width) Selector1a (Line 1 dropdown selector - Ins and Cms) Zth1 (Line 1 Textfield for thickness) zqty1 (Line 1 Textfield for quantity) Zg1 (Line 1 Dropdown selections - 28 Grade, 33 Grade, 400H Reflex Foam, Memory Foam = Values 28,33,38,60) 3 ps1 (Line 1 Dropdown selections - 0, 1, 2) zlentg2 (Line 2 textfield for length) zsel2 (Line 2 dropdown selector - Ins and Cms) zwid2 (Line 2 textfield for width) zsel2a (Line 2 dropdown selector - Ins and Cms) zith2 (Line 2 Textfield for thickness) zqtty2 (Line 2 Textfield for quantity) zgg2 (Line 2 Dropdown selections - 28 Grade, 33 Grade, 400H Reflex Foam, Memory Foam = Values 28,33,38,60) pss2 (Line 2 Dropdown selections - 0, 1, 2) wlng3 (Line 3 textfield for length) wsel3 (Line 3 dropdown selector - Ins and Cms) wwid3 (Line 3 textfield for width) wsel3a (Line 3 dropdown selector - Ins and Cms) wsel3x (Line 3 Textfield for thickness) wqty3 (Line 3 Textfield for quantity) wgg3 (Line 3 Dropdown selections - 28 Grade, 33 Grade, 400H Reflex Foam, Memory Foam = Values 28,33,38,60) wss3 (Line 3 Dropdown selections - 0, 1, 2) yln4 (Line 4 textfield for length) ysel4 (Line 4 dropdown selector - Ins and Cms) ywid4 (Line 4 textfield for width) ysel4a (Line 4 dropdown selector - Ins and Cms) ysel3x (Line 4 Textfield for thickness) yqty4 (Line 4 Textfield for quantity) ygg4 (Line 4 Dropdown selections - 28 Grade, 33 Grade, 400H Reflex Foam, Memory Foam Values 28,33,38,60) yss4 (Line 4 Dropdown selections - 0, 1, 2) r5ln (Line 5 textfield for length) r5sel (Line 5 dropdown selector - Ins and Cms) r5wid (Line 5 textfield for width) r5sela (Line 5 dropdown selector - Ins and Cms) r5selx (Line 5 Textfield for thickness) r5qty (Line 5 Textfield for quantity) r5gg (Line 5 Dropdown selections - 28 Grade, 33 Grade, 400H Reflex Foam, Memory Foam = Values 28,33,38,60) r5ss (Line 5 Dropdown selections - 0, 1, 2) f6ln (Line 6 textfield for length) f6sel (Line 6 dropdown selector - Ins and Cms) f6wid (Line 6 textfield for width) f6sela (Line 6 dropdown selector - Ins and Cms) f6selx (Line 6 Textfield for thickness) f6qty (Line 6 Textfield for quantity) f6gg (Line 6 Dropdown selections - 28 Grade, 33 Grade, 400H Reflex Foam, Memory Foam = Values 28,33,38,60) f6ss (Line 6 Dropdown selections - 0, 1, 2) Send Request Quotation Non-user Variables are PPSI28 Cost per square inch of 28 Grade foam - (If Dropdown selection value = 28) Value is 0.157105263 PPSI33 Cost per square inch of 33 Grade foam - (If Dropdown selection value = 33) Value is 0.171578947 PPSI400 Cost per square inch of 400H Grade foam - (If Dropdown selection value = 38) Value is 0.216578947 PPSIMEM Cost per square inch of Memory Foam Grade foam - (If Dropdown selection value = 60) Value is 0.433500954 VAT value = 1.2 wf value = 1.05 (wastefactor) wf2 value = 20 (wastefactor for costing) mup value = 3 (mark up) Adm value = 2.6/the number of lines (a line is counted when the quantity is larger than 0) Discount1 value = if stl > 70, message = “Our large order discount applies to this order 5% off?? Discount value = 5% x stl discount2 value = if stl > 80, if today is Tuesday or Wednesday or Then message = “Our mid-week sales targets are down ??" This order qualifies for our win-the business Discount of 5%?? Discount2 value = 5% x gtl discount2 value = if stl > 80, if today is Friday Then message = “Our end of week sales targets are Down ??" this order qualifies for our Win-The-Business Discount of 5%?? Discount2 value = 5% x gtl discount2 value = if stl > 80, if today is Saturday or Sunday Then message = “Our weekend sales targets are Down ??" this order qualifies for our Win-The-Business Discount of 5%?? Discount2 value = 5% x gtl Discount2 value = if stl > 80, if today is Monday Then message = “We want to get this week’s sales Targets on track ??" this order qualifies for our Win- The-Business Discount of 5%?? Discount value = 5% x gtl ps1, pss2, wss3, yss4, r5ss and f6ss are selections for stockinette or polywrap or nothing ps1 if selection = 1, value = 1.50 + (foamcost1 x 0.03) pss2 if selection = 1, value = 1.50 + (foamcost2 x 0.03) wss3 if selection = 1, value = 1.50 + (foamcost3 x 0.03) yss4 if selection = 1, value = 1.50 + (foamcost4 x 0.03) r5ss if selection = 1, value = 1.50 + (foamcost5 x 0.03) f6ss if selection = 1, value = 1.50 + (foamcost6 x 0.03) ps1 if selection = 0, value = 0 pss2 if selection = 0, value = 0 wss3 if selection = 0, value = 0 yss4 if selection = 0, value = 0 r5ss if selection = 0, value = 0 f6ss if selection = 0, value = 0 ps1 if selection = 2, value = 1.50 + (foamcost1 x 0.05) pss2 if selection = 2, value = 1.50 + (foamcost2 x 0.05) wss3 if selection = 2, value = 1.50 + (foamcost3 x 0.05) yss4 if selection = 2, value = 1.50 + (foamcost4 x 0.05) r5ss if selection = 2, value = 1.50 + (foamcost5 x 0.05) f6ss if selection = 2, value = 1.50 + (foamcost6 x 0.05) foamcost1 value = (if zg1 value = 28, zqty1 x zlg1 x zwide1 x zth1 x PPSI28) foamcost1 value = (if zg1 value = 33, zqty1 x zlg1 x zwide1 x zth1 x PPSI33) foamcost1 value = (if zg1 value = 400, zqty1 x zlg1 x zwide1 x zth1 x PPSI400) foamcost1 value = (if zg1 value = 60, zqty1 x zlg1 x zwide1 x zth1 x PPSIMEM) foamcost2 value = (if zgg2 value = 28, zqtty2 x zlentg2 x zwid2 x zith2 x PPSI28) foamcost2 value = (if zgg2 value = 33, zqtty2 x zlentg2 x zwid2 x zith2 x PPSI33) foamcost2 value = (if zgg2 value = 400, zqtty2 x zlentg2 x zwid2 x zith2 x PPSI400) foamcost2 value = (if zgg2 value = 60, zqtty2 x zlentg2 x zwid2 x zith2 x PPSIMEM) foamcost3 value = (if wgg3 value = 28, wqty3 x wlng3 x wwide3 x wsel3x x PPSI28) foamcost3 value = (if wgg3 value = 33, wqty3 x wlng3 x wwide3 x wsel3x x PPSI33) foamcost3 value = (if wgg3 value = 400, wqty3 x wlng3 x wwide3 x wsel3x x PPSI400) foamcost3 value = (if wgg3 value = 60, wqty3 x wlng3 x wwide3 x wsel3x x PPSIMEM) foamcost4 value = (if ygg4 value = 28, yqty4 x yln4 x ywid4 x ysel3x x PPSI28) foamcost4 value = (if ygg4 value = 33, yqty4 x yln4 x ywid4 x ysel3x x PPSI33) foamcost4 value = (if ygg4 value = 400, yqty4 x yln4 x ywid4 x ysel3x x PPSI400) foamcost4 value = (if ygg4 value = 60, yqty4 x yln4 x ywid4 x ysel3x x PPSIMEM) foamcost5 value = (if r5gg value = 28, r5qty x r5ln x r5wid x r5selx x PPSI28) foamcost5 value = (if r5gg value = 33, r5qty x r5ln x r5wid x r5selx x PPSI33) foamcost5 value = (if r5gg value = 400, r5qty x r5ln x r5wid x r5selx x PPSI400) foamcost5 value = (if r5gg value = 60, r5qty x r5ln x r5wid x r5selx x PPSIMEM) foamcost6 value = (if f6gg value =28, f6qty x f6ln x f6wid x f6selx x PPSI28) foamcost6 value = (if f6gg value = 33, f6qty x f6ln x f6wid x f6selx x PPSI33) foamcost6 value = (if f6gg value = 400, f6qty x f6ln x f6wid x f6selx x PPSI400) foamcost6 value = (if f6gg value = 60, f6qty x f6ln x f6wid x f6selx x PPSIMEM) tl1 total line 1 value = (((foamcost1 x wf x mup) +ps1 + adm) x VAT) +Carr tl2 total line 2 value = (((foamcost2 x wf x mup) +pss2 + adm) x VAT) +Carr tl3 total line 3 value = (((foamcost3 x wf x mup) +wss3 + adm) x VAT)+ Carr tl4 total line 4 value = (((foamcost4 x wf x mup) +yss4 + adm) x VAT)+ Carr tl5 total line 5 value = (((foamcost5 x wf x mup) +r5ss + adm) x VAT)+ Carr tl6 total line 6 value = (((foamcost6 x wf x mup) +f6ss + adm) x VAT)+ Carr stl sub-total value = tl1 +tl2 +tl3 +tl4 +tl5 +tl6 gtl grand-total value = stl x discount1 ftl final-total value = gt1 x discount2 Weight calculations GmPC Grams Per Cubic Inch value = (if zg1, zgg2, wgg3, ygg4, r5gg, f6gg value = 33, 0.5405405) GmPC Grams Per Cubic Inch value = (if zg1, zgg2, wgg3, ygg4, r5gg, f6gg value = 28, 0.4586404) GmPC Grams Per Cubic Inch value = (if zg1, zgg2, wgg3, ygg4, r5gg, f6gg value = 38, 0.62244) GmPC Grams Per Cubic Inch value = (if zg1, zgg2, wgg3, ygg4, r5gg, f6gg value = 60, 0.9) wt1 Weight for line1 value = (if Selector1a = "Ins", zlg1 x zwide1 x zth1 x zqty1 x GmPC) value = (if Selector1a = "Cms", zlg1 x zwide1 x zth1 x zqty1 x GmPC)/16.39 wt2 Weight for line2 value = (if zsel2 = "Ins", zlentg2 x zwid2 x zith2 x zqtty2 x GmPC) value = (if zSel2 = "Cms", zlentg2 x zwid2 x zith2 x zqtty2 x GmPC)/16.39 wt3 Weight for line3 value = (if wSel3 = "Ins", wlng3 x wwid3 x wsel3x x wqty3 x GmPC) value = (if wSel3 = "Cms", wlng3 x wwid3 x wsel3x x zqtty2 x GmPC)/16.39 wt4 Weight for line4 value = (if ySel4 = "Ins", yln4 x ywid4 x ysel3x x yqty4 x GmPC) value = (if ySel4 = "Cms", yln4 x ywid4 x ysel3x x yqty4 x GmPC)/16.39 wt5 Weight for line5 value = (if r5Sel = "Ins", r5ln x r5wid x r5selx x r5qty x GmPC) value = (if r5Sel = "Cms", r5ln x r5wid x r5selx x r5qty x GmPC)/16.39 wt6 Weight for line6 value = (if f6Sel = "Ins", f6ln x f6wid x f6selx x f6qty x GmPC) value = (if f6Sel = "Cms", f6ln x f6wid x f6selx x f6qty x GmPC)/16.39 twt total weight in kgs value = (wt1+wt2+wt3+wt4+wt5+wt6) Carr Carriage in £'s value = (if twt > 2, £8.99, < 2, £8.22 < 1.75, £6.6 <1.5, £5.90 <1.25,£5.20 <1.00, £4.50 <0.75, £3.35 <0.5, £2.75 <0.25, £2.24 <0.1, £1.39 OrdRef Order Reference value = (foamcost1+foamcost2+foamcost3+foamcost4+foamcost5+foamcost6)x(1+wf2/100) zname not used yet value = fastfoam zadd1 not used yet value = fastfoam zadd2 not used yet value = fastfoam zadd3 not used yet value = fastfoam zpcode not used yet value = fastfoam zemail not used yet value = fastfoam zphone not used yet value = fastfoam