Spreadsheet: 752291d1634691217-autopopulate-a-cell-on-one-sheet-based-on-a-calculation-on-another-sheet-frp-in-progress
Sheet: Flat Rate Book

 | Oil Heating Repairs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diagnostic Charge + ( Labor Rate * Time To Complete) + (Materials Cost * Materials Markup) + Warranty Reserve
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pricing Calculation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plan Pricing |  |  |  |  |  |  |  |  |  |  |  |  |  | Auto Fills |  |  |  | Auto Fills |  |  |  | Manually Enter |  |  |  | Auto Fills |  |  |  | Manually Enter |  |  |  | Auto Fills |  |  |  | Auto Fills
 | Task ID |  |  |  | Description |  |  |  |  |  |  |  |  |  |  |  |  | Standard Price |  |  |  |  |  |  |  | Secondary Repair |  |  |  | Plan Savings ! |  |  |  |  |  | Diagnostic Charge |  |  |  | Labor                 Rate |  |  |  | Time To Complete |  |  |  | Advantage Discount % |  |  |  | Materials               Cost |  |  |  | Materials    Markup |  |  |  | Warranty Reserve
 | OH101.60 |  |  |  | Replace Standard Burner Motor (Beckett) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 80 |  |  |  | 3
 | OH102.60 |  |  |  | Replace Carlin Oil Burner Motor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  | 100 |  |  |  | 2
 | OH103.45 |  |  |  | Replace R8184G Primary Control 15/30/45 Sec. Safety |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 49.4
 | OH104.30 |  |  |  | Replace Oil Burner [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 43.1
 | OH105.120 |  |  |  | [NAME] Relay To Primary Control |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 645.4
 | OH106.75 |  |  |  | Replace Primary Control w/ Cooling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75
 | OH107.60 |  |  |  | Replace Honeywell Fan Control Center |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 45
 | OH108.45 |  |  |  | Replace Honeywell L4064 Fan/Limit Control |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 34
 | OH109.15 |  |  |  | Replace [NAME] (Eye-Only) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 65
 | OH110.15 |  |  |  | Replace [NAME] (Assembly) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 134
 | OH111.15 |  |  |  | Replace Standard Fuel Filter Cartridge |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 65
 | OH112.15 |  |  |  | Replace Spin-On Fuel Filter Cartridge |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 234
 | OH113.45 |  |  |  | Replace Ignition Transformer - Standard |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 32
 | OH114.45 |  |  |  | Replace Ignition Transformer - Non-Standard |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 123
 | OH115.60 |  |  |  | Replace Single Stage Fuel Pump |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 123
 | OH116.60 |  |  |  | Replace 2 Stage Fuel Pump |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 365
 | OH117.40 |  |  |  | Clear Blocked Fuel Line w/ Nozzle, [NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 43
 | OH118.90 |  |  |  | Replace Blast Tube/End Cone Combo (up to 11") |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 56
 | OH119.50 |  |  |  | Replace End-Cone Only |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 67
 | OH120.30 |  |  |  | Replace [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 87
 | OH121.45 |  |  |  | Replace Standard Tank Gauge |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  |  |  | 987
 | OH122.60 |  |  |  | Replace Combo Tank Gauge/Vent Alarm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75
 | We Will Never Charge You Overtime Rates! |  |  |  |  |  |  |  |  |  |  |  | Know The Price BEFORE The Work Is Done! |  |  |  |  |  |  |  |  |  |  |  | FREE Extended Parts Warranty !