I need to create a quote page using excel where you have 7 products to select from and several more option that range in value depend on the original selection. I.e. if model 'A' is selected then the price for option 'X' is $10. If model 'B' is selected the price for option 'X' is $15. Also if model A is selected and option X then option Y is a certain value. I.e 2x criteria. There are 7 models with 10 -20 options for each model. . All the data will be provide. The user will only be able to select criteria available to that model. I.e model 'A' can have option 'x' not y. Therefore Y not available after model A is selected. The data behind the quote page needs to locked so no user can modify the formula.
Any questions ask.
I need this complete in one day.
50% escrow. Balance put in escrow once proof can be provide that spread is going to work. Payment on completion.