Spreadsheet: 853089d1703039775-need-help-with-creation-of-price-formula-leo-pricing-formula-rev-02-experimental
Sheet: Formula

Description | Length | Depth | Height | co-efficient 1 | co-efficient 2 | co-efficient 3 | Price |  | Type | co-efficient 2 |  |  |  |  |  |  |  |  |  |  |  |  | Models | Description | Selling Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Length | co-efficient 1 |  | Depth | co-efficient 2 |  | Height | co-efficient 3
 |  |  |  |  |  |  |  |  | 3 Tier | 1.15 |  |  |  |  |  |  |  |  | Faucet and [NAME] | Double | 1.1 |  | RT-96MA-S | 1 Dr [NAME]
Cabinet 3T | Length | Depth | Height |  |  |  |  |  | 2 Tier | 1.07 |  | Double Bowl Sink | Length | Depth | Height |  |  |  |  | Single | 1.08 |  | RT-98MA-S | 1 Dr [NAME] |  |  |  | 0.07571 |  |  | 3.13 |  |  | 10
 | 500 | 750 | 850 |  |  |  |  |  | Legs only | 0.98 |  |  | 700 | 750 | 850 |  | 1.39433551198257 |  | 300 |  |  |  |  |  |  |  |  |  |  |  | 3.13 |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | 600 | 850 |  | 1.176470588235294 |  | 300 |  |  |  | FT-96MA-S | 1 Dr [NAME] |  |  |  |  |  |  | 3.13 |  |  | 10
Cabinet 2T | Length | Depth | Height |  |  |  |  |  |  |  |  |  | 2400 | 750 | 850 |  | 1.111111111111111 |  | 300 |  |  |  | FT-98MA-S | 1 Dr [NAME]
 | 500 | 750 | 850 |  |  |  |  |  |  |  |  |  | 3600 | 750 | 850 |  | 0.9803921568627451 |  | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 4500 | 750 | 850 |  | 0.9411764705882353 |  | 300 |  |  |  | RT-126MA-S | 2 Dr [NAME]
Cabinet (Legs only) | Length | Depth | Height |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RT-156MA-S | 2 Dr [NAME]
 | 500 | 750 | 850 |  |  |  |  |  |  |  |  | Single Bowl Sink | Length | Depth | Height |  |  |  |  |  |  |  | RT-186MA-S | 3 Dr [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 2700 | 750 | 850 |  |  |  |  |  | 4500 | 750 | 850 |  | 0.9411764705882353
 |  |  |  |  |  |  |  |  |  |  |  | 3600 | 750 | 850
 |  |  |  |  |  |  |  |  |  |  |  | 4500 | 750 | 850 |  |  |  |  | Work Table 2T | Length | Depth | Height
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 | 750 | 850 |  | 1.394335511982571
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1800 | 750 | 850 |  | 1.176470588235294
 |  |  |  |  |  |  |  |  |  |  |  | 900 | 750 | 850 |  | 1.39433551198257 |  |  |  | 2400 | 750 | 850 |  | 1.111111111111111
 |  |  |  |  |  |  |  |  |  |  |  | 1800 | 750 | 850 |  | 1.176470588235294 |  |  |  | 3600 | 750 | 850 |  | 0.9803921568627451
 |  |  |  |  |  |  |  |  |  |  |  | 2400 | 750 | 850 |  | 1.111111111111111 |  |  |  | 4500 | 750 | 850 |  | 0.9411764705882353
 |  |  |  |  |  |  |  |  |  |  |  | 3600 | 750 | 850 |  | 0.9803921568627451
 |  |  |  |  |  |  |  |  |  |  |  | 4500 | 750 | 850 |  | 0.9411764705882353 |  |  | Work Table (Legs only) | Length | Depth | Height
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 | 750 | 850 |  |  | 1050
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1800 | 750 | 850
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2400 | 750 | 850
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3600 | 750 | 850
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4500 | 750 | 850