Spreadsheet: 202409d1356549383-sum-like-cells-in-a-ticket-ticket-example1
Sheet: Data_Bid Sheet

 | BID SHEET
 | Date | 2012-12-19 00:00:00
 | Ticket Number
 | Service Point:
 | Address
 | Business Phone
 | Manager
 | E-mail
 | [NAME]
 | Company |  | Prepared For: |  |  |  |  | Well Data
 | Address |  | Business Phone: |  |  |  |  | Open Hole
 | Address |  | [NAME]: |  |  |  |  | Depth
 | Well Name |  | [NAME]: |  |  |  |  | String
 | Well Number |  | Prepared By: |  |  |  |  | Casing Size
 | Field |  | [NAME] |  |  |  |  | ID
 | County |  | [NAME]: |  |  |  |  | Weight
 | State |  | Business Phone: |  |  |  |  | Grade
 | City |  | Rig Contractor |  |  |  |  | Top (md)
 | API Number |  | [NAME]. |  |  |  |  | [NAME] (md)
 | Specific Job Type |  | [NAME]: |  |  |  |  | Thread
 |  |  | Company Rep
 |  |  | Rep Phone No.
 |  |  | Mileage (one-way)
 |  |  | Proposal Date
 |  |  | Units | UOM | Cost per Unit | Total |  | Unit Net | Net
 | OPERATIONS
 | Thru-Tbg or Drill Pipe Pump Charge 15000'+ |  | 1 | for 6 hours | 29500 | 29500 |  | 16225 | 16225
 | [NAME] (3-1/2" to 5-1/2") |  | 1 | per day | 165 | 165 |  | 90.75000000000001 | 90.75000000000001
 | [NAME] |  | 1 | per job | 880 | 880 |  | 484.0000000000001 | 484.0000000000001
 | Data Acquisition |  | 1 | per job | 1694 | 1694 |  | 931.7 | 931.7
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | Subtotal |  |  |  |  | 32239 |  |  | 17731.45
 | EQUIPMENT SALES
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | Subtotal |  |  |  |  | 0 |  |  | 0
 | PRODUCTS
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | CLASS H PREMIUM |  | 100 | per sack | 18.9 | 1890 |  | 10.395 | 1039.5
 | [NAME] |  | 29 | per pound | 33.5 | 971.5 |  | 18.425 | 534.325
 | Cement Retarder >200degF |  | 94 | per pound | 10.44 | 981.3599999999999 |  | 5.742 | 539.748
 | [NAME] |  | 3290 | per pound | 0.66 | 2171.4 |  | 0.363 | 1194.27
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | CLASS H PREMIUM |  | 30 | per sack | 18.9 | 567 |  | 10.395 | 311.85
 | [NAME] |  | 9 | per pound | 33.5 | 301.5 |  | 18.425 | 165.825
 | Cement Retarder >200degF |  | 23 | per pound | 10.44 | 240.12 |  | 5.742 | 132.066
 | [NAME] |  | 987 | per pound | 0.66 | 651.4200000000001 |  | 0.363 | 358.2810000000001
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | CLASS H PREMIUM |  | 30 | per sack | 18.9 | 567 |  | 10.395 | 311.85
 | [NAME] |  | 9 | per pound | 33.5 | 301.5 |  | 18.425 | 165.825
 | Cement Retarder >200degF |  | 23 | per pound | 10.44 | 240.12 |  | 5.742 | 132.066
 | [NAME] |  | 987 | per pound | 0.66 | 651.4200000000001 |  | 0.363 | 358.2810000000001
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | CLASS H PREMIUM |  | 45 | per sack | 18.9 | 850.4999999999999 |  | 10.395 | 467.775
 | [NAME] |  | 13 | per pound | 33.5 | 435.5 |  | 18.425 | 239.525
 | Cement Retarder >200degF |  | 22 | per pound | 10.44 | 229.68 |  | 5.742 | 126.324
 | [NAME] |  | 1481 | per pound | 0.66 | 977.46 |  | 0.363 | 537.6030000000001
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | Subtotal |  |  |  |  | 12027.48 |  |  | 6615.114
 | TRANSPORT
 | Products handling service charge |  | 307.4213928571429 | per cu. Ft. | 2.75 | 845.408830357143 |  | 1.5125 | 464.9748566964287
 | Drayage for Products |  | 1171.819342857143 | [NAME] | 2.75 | 3222.503192857143 |  | 1.5125 | 1772.376756071429
 | Light [NAME] |  | 220 | per mile | 5.225000000000001 | 1149.5 |  | 2.873750000000001 | 632.2250000000001
 | Heavy Vehicle Mileage |  | 220 | per mile | 7.700000000000001 | 1694 |  | 4.235000000000001 | 931.7000000000003
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | 0 |  | 0 | 0 | False | 0 |  | 0 | 0
 | Subtotal |  |  |  |  | 6911.412023214287 |  |  | 3801.276612767858
 | Totals: |  |  |  |  | 51177.89202321428 |  |  | 28147.84061276786
 | DISCOUNT: Operations |  |  |  | 0.45 | -14507.55
 | DISCOUNT: Equipment Sales |  |  |  | 0.3 | 0
 | DISCOUNT: Products |  |  |  | 0.45 | -5412.366
 | DISCOUNT: Transport |  |  |  | 0.45 | -3110.135410446429
 | DISCOUNT: ADDITIONAL ITEMS |  |  |  | 0.45 | 0
 |  |  |  |  | Total | -23030.05141044643
 |  |  |  | Gross |  | Discount |  | Final
 |  | Services Total |  | 39150.41202321429 |  | 17617.68541044643 |  | 21532.72661276786
 |  | Materials Total |  | 12027.48 |  | 5412.366 |  | 6615.114
 |  | Final Total |  | 51177.89202321428 |  | 23030.05141044642 |  | 28147.84061276786
 | ADDITIONAL ITEMS
 | Additional hours, in excess of set hours |  | 1 | per hour | 632.5 | 632.5 |  | 347.88 | 347.88
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | False | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  | Subtotal: |  |  | 347.88