Spreadsheet: 272135d1382220882-value-from-formula-that-wont-ignore-anything-other-than-numbers-fi-formula-problem-b
Sheet: Field Invoice

Sharewell Energy Services, Field Invoice |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sharewell Energy Services, Field Invoice
 |  |  |  |  |  | Customer: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rig: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE TWO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rig:
 |  |  |  |  |  | Lease, Well: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Job No.: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lease, Well: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Job No.:
 |  |  |  |  |  | Location: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AFE No.: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AFE No.:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE TWO
 |  |  |  |  | Start Date:
Description |  | Cost | Unit | Qty. | Sub Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Description |  | Cost | Unit | Qty. | Sub Total
Total [NAME] (per man)  [NAME]: | 1920 | 2.5 | Mile |  |  | 4 | 1
Operational |  | 8450 | Day |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Standby - Attended |  | 4250 | Day |  |  | 1
[NAME] |  | 875 | Each |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
6 1/2 - 6 3/4"  LIH Motor Insurance |  | 625 | Day |  |  |  | 1 | 1 | 1
[NAME] / Gamma LIH Insurance |  | 650 | Day |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MWD Directional Only LIH Insurance |  | 600 | Day
Motor Inspection (per used motor) |  | 1600 | Each |  |  |  | 1 |  |  | 1
Motor Reline |  | 7000 | Each |  |  |  | 1 |  |  | 1
Inspection & Re-cut of Tools (Per End) |  | 100 | Each |  |  |  | 10 |  |  | 8
Post Well Reports |  | 475 | Well |  |  |  | 1
Float Valves (Sale Items Each) |  | 450 | Each |  |  |  | 1 |  |  | 1
Drill Pipe Screens (Sale Item Each) |  | 575 | EACH
4 3/4"  LIH Motor Insurance |  | 535 | Day |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
[NAME] |  |  | DAYS |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] |  |  | DAYS |  |  | 1
[NAME] |  |  | DAYS |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
Aric Pressly |  |  | DAYS |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] |  |  | DAYS |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | DAYS
Total Cost: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cost:
 |  |  |  |  |  | This is a field invoice and is subject to revisions upon review by Operations Management. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is a field invoice and is subject to revisions upon review by Operations Management.
 |  |  |  |  |  | Charges shown are as quoted and are not discounted. Any applicable discounts or credits will be posted on final invoice. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Charges shown are as quoted and are not discounted. Any applicable discounts or credits will be posted on final invoice.
 |  |  |  |  |  |  |  |  |  | Company Representative: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cost: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE TWO |  |  |  |  |  |  |  |  |  | Company Representative:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  |  |  |  |  | Sharewell Representative: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
 |  | DAY
 |  | EACH
Operational |  | END
Standby - Attended |  | HOUR
Standby-Unattended |  | ITEM
Mob & Demob |  | [NAME]
 |  | TOOL
Subsistance
Lodging
Mileage (Round Trip)
Tool Protection Charges (Per Day)
4 3/4" LIH Motor Insurance
6 1/2 - 6 3/4"  LIH Motor Insurance
8" LIH Motor Insurance
[NAME] / Gamma LIH Insurance
MWD Directional Only LIH Insurance
In House Engineering Charge
Well Planning
Lead Directional/Per Diem
Lead Directional/Mileage
Second Directional Hand/Day Rate
Second Directional Hand/Per Diem
Second Directional Hand/Mileage
Lead MWD/Per Diem
Lead MWD/Mileage
Second MWD Hand/Day Rate
Second MWD Hand/Per Diem
Second MWD Hand/Mileage
Engineering Wall Plots
End of Well & Completion Reports
Inspection & Re-cut of Tools (Per End)
Steel Connecitons (per conn)
Monel Connections (per conn)
Non-Mag Thread Inspection
Steel Thread Inspections
Motor Inspection (per used motor)
Motor Reline
Rotor Rechrome
Performance Motor (per day)
Daily Rental For Motors Not Used
[NAME]
Electro Trac EM MWD System
[NAME]
[NAME]
Piggy Back EM tool
Drill Pipe Screens (Sale Item Each)
Float Valves (Sale Items Each)
Double Float Valve System
Model "G" Float Valve
3 1/2 IF Float Valve
4 3/4" Float Valve
6 1/2" Float Valve
8" Float Valve
Tool Basket (per basket/day)
[NAME] (Additional/day, if needed)
Battery Disposal Fee (Per String below Rotary Table)
Satellite Set-up Charge
Satellite Charges (per day)
Witts Real Time Transmission Set Up
Witts Real Time Transmission
Real Time Internet rig communications (per day)
[NAME]
Non-Mag Rental
Post Well Reports