tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 300f9657-7465-4915-b407-41f5cd6e5574
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FAMAN | Test | FAMAN | Amantadine (Symmetrel) | Amantadine (Symmetrel) | Gas Chromatography/Nitrogen Phosphorus Detection (GC-NPD) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 3 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s). ([NAME]) are not acceptable.)  [NAME] down and submit 3 mL  sodium heparin plasma refrigerated. Note:		1.  Indicate plasma on request form. 	2.  [NAME] specimen appropriately (plasma).                 	3.  Trough levels are most reproducible.   Serum Draw blood in a red-top tube(s).   (Serum gel tube(s) are not acceptable.)   Spin down and submit 3 mL serum, refrigerated. Note:		1.  Indicate serum on request form. 	2.  [NAME] specimen appropriately (serum). 	3.  Trough levels are most reproducible. | 0.6 mL Note: Submission of the m | Specimens other than	Plasma, serum Anticoagulants other than	Sodium heparin, EDTA, plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Therapeutic range has not been established. expected steady state amantadine concentrations in patients receiving recommended daily dosages: 200-1000 ng/mL Toxicity reported at greater than 2000 ng/mL   Test Performed by: Medtox Laboratories, Inc.                                       402 W. County Road D                                       St. Paul, MN. 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc
FAMAN | Result | Z1198 | Amantadine | Amantadine | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 37fdf648-dacf-4fab-a5ac-07c2a733e3e8
Sheet: Audit Summary

Audit Summary |  | Name of Auditee:
 |  | Date of audit:
Section | Questions | Total # in Section | # of C | # of CAN | # of IAR | # of NA | Question # of any CAN or IAR
1 | General Questions
1.1 | Management Responsibility | 3
1.2 | Food Safety Plan | 2
1.3 | Documentation & Recordkeeping | 3
1.4 | Worker Education & Training | 3
1.5 | Sampling & Testing | 4
1.6 | Traceability | 2
1.7 | Recall Program | 1
1.8 | Corrective Actions | 1
1.9 | Self Audits | 1
2 | Field Production
2.1 | Field History & Assessment | 2
2.2 | Worker Health/Hygiene and Toilet/Hand washing Facilities | 21
2.3 | Agricultural Chemicals/Plant Protection Products | 5
2.4 | Agricultural Water | 7
2.5 | Animal Control | 3
2.6 | Soil Amendments | 2
2.7 | Vehicles, Equipment, Tools and Utensils | 6
3 | Harvesting
3.1 | Pre-harvest Assessment | 1
3.2 | Water/Ice | 5
3.3 | Containers, Bins and Packaging Materials | 4
3.4 | Field Packaging and [NAME] | 7
3.5 | Postharvest Handling | 3
4 | Transportation (Field to Packinghouse)
4.1 | Equipment Sanitation & Maintenance | 3
5 | Global Markets Primary Production [NAME]
5.1 | Food Safety Plan and Documentation | 11
5.2 | Propagation Material | 3
5.3 | Fertilizers & Biosolids | 4
5.4 | Harvesting | 1
5.5 | Agricultural Chemicals | 9
5.6 | Waste Management | 2
5.7 | Food Defense | 3
C, Compliant with requirement; CAN, Corrective action needed to address nonconformance; IAR, Immediate action required because of imminent food safety risk; N/A, not applicable or not needed.
NOTE: | Section 5 is not a component of the Produce GAPs Harmonized Food Safety Standard and is offered only as a service to those auditees who need to conform to the Global Markets Primary Production Assessment
Spreadsheet: 861164d1709123184-remove-ap-team-rank-from-college-basketball-team-name-removeparentheseswithnumbersonly-aligw
Sheet: PROBLEM

DATA SET | TRIM FORMULA - AliGW | DESIRED RESULT | TRIM |  | Hey, [NAME]. I have here another tricky problem. Data in Column A has been pulled from a website.
 |  |  |  |  | Unfortunately, the way it's formatted does not suit my purposes. I would like to remove (TRIM)
Northern Arizona |  |  |  |  | the parentheses with numbers only, keeping the parentheses that enclose letters. In this case (NY).
Stonehill |  |  |  |  | I used a TRIM formula and it removes both the parentheses enclosing numbers and enclosing letters.
Mississippi Valley State |  |  |  |  | Colum A is the data I'm starting with, Column C is my desired result. Column B is the best my novice
Indiana |  |  |  |  | Excel skills can accomplish. Thanks, yet again, in advance.
Texas (15)
Manhattan |  |  |  |  | Thanks, [NAME], for your solution. However, there is one issue. Your solution returns FALSE values from the teams
New Hampshire |  |  |  |  | with numbers in parentheses. |  |  | I've trimmed that data with formula in Column D. I wonder is there a way to nest
Kansas (5) |  |  |  |  | that formula within your solution. Thanks in advance.
North Carolina (9)
Arkansas-Pine Bluff
Gonzaga (10)
[NAME]
St. John's (NY) |  | St. John's (NY)
[NAME]
Butler
Xavier
Georgetown
Creighton (18)
Villanova
Xavier
Providence
St. John's (NY) |  | St. John's (NY)
Butler
Georgetown
[NAME]
Marquette (4)
Creighton (15)
Villanova
[NAME]
Marquette (5)
Providence
Spreadsheet: joe_parks__14966__BridgeDPR0509
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 981.519808400004 | 2984.519808400004 | 8275.519808400004
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 981.519808400004 | 2984.519808400004 | 8275.519808400004
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: sally_beck__33766__Groups
Sheet: Org

 | Front Office |  |  |  | MG MCC Business Head |  |  |  |  |  | Office Of The Chair Enron Europe
 |  |  |  |  | [NAME]
 |  |  | Origination |  | Trading |  | Logistics
 | Middle Office |  | Business Controller* |  |  |  | Head [NAME] |  | CAO Enron Europe
 |  |  | [NAME] |  |  |  | [NAME] |  | [NAME]
 |  |  | Risk Management
 |  |  | Trade Accounting
 |  |  | Traffic/Co-ordination
 |  |  | Settlements |  |  |  | Functional Leads*
 |  |  | Repo/Re-Financing
 |  |  | Documentation
 |  |  | Records Management
 | Back Office |  | FinOps
 |  |  | [NAME]
 |  |  | RAC
 |  |  | [NAME]
 |  |  | Treasury
 |  |  | [NAME]
Spreadsheet: 733808d1621838979-index-formula-search-in-different-sheet-testalles3-ans2
Sheet: nieuw

project | Vertrek | Aankomst | begeleider | tijd | weg | wacht | uren | km | land | verkoop | Wacht2 | inkoop | [NAME] | Wacht3 |  | Verschil alles | prijs nl | prijs d | [NAME] <50 | km NL 50-100 | [NAME]500 | [NAME]50 | km d 50-100 | km d 100-500 | km d >500 | Wacht
5235 |  |  |  |  | 21:55:00 |  | 4 | 100 | nl |  |  |  |  |  |  |  | 42.5 | 1.15 | 150 | 2.8 | 1.8 | 300 | 4.5 | 1.65 | 1.3 | 45
5240 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | als J=nl;I:I | als J=nl; K:K | als J=d;I:I | als J=d:K:K | wacht
5240 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5235
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal
Spreadsheet: 90734d1290500047-lookup-from-separate-sheet-ops-cards
Sheet: Fettling Equipment

 |  |  |  |  | Master Information Record
 | Part No. |  |  |  |  | Tooling Ref. |  |  | Casting Weight |  | Kgs
 | Customer |  |  |  |  | Drg/lss.No. |  |  | Gross Wt./Mld |  | Kgs
 | Material |  |  |  |  |  |  |  | Yield |  | %
q | Cust. Spec |  |  |  |  |  |  |  | Castings/Mould
FETTLING EQUIPMENT
TOOLING NOTES
***FinishingNotes***
FETTLING AND DISPATCH DIRECTIVES |  |  |  |  |  |  | NOTES
 | Angle
 | Dwell
 | Advance
 | Stress Relieve
q | Heat Treatment |  |  | WI 9.07 & 9.63
 | Fettling
p | "First Off" Inspection |  |  | WI 10.9
 | Despatch Medium
p | Oil Wrap Paper Required
 | Castings Per Pallet
 | Stack Method
 | Stack Pattern
 | Stack Pattern Form
qDenotes Customer Significant Characteristic
(WHEN PRINTED) THIS IS AN UNCONTROLLED DOCUMENT
Spreadsheet: 93970d1293729232-auto-fill-consecutive-row-after-processing-from-different-sheet-inputouput
Sheet: Sell

Date | Buyer | Coupon | Type | [NAME] | Price | Weight | Decrease/Increase | Total
2010-03-29 00:00:00 | Billy | 102 | bowl |  | 14000 | 5400 | -115 | 75600000
2010-03-29 00:00:00 | [NAME] | 102 | triangle |  | 12600 |  | -3616 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | #N/A
 |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  | 75600000
Spreadsheet: 881890d1730116053-get-value-from-different-workbook-based-on-multiple-criteria-and-based-on-the-latest-date-source-workbook-example
Sheet: Source workbook

 |  | Machine | ID number | Blank | Blank | Cyceltime
 |  | Example1 | 12345 |  |  | 70
 |  | Example2 | 67891 |  |  | 40
 |  | Example3 | 65743 |  |  | 60
 |  | Example4 | 97745 |  |  | 80
 |  | I need the cyceltime "column G" to be dynamic updated.
 |  | Based on the latest date from the "input workbook."
 |  | if the criterias matches from column C and D.
Spreadsheet: 788038d1658234749-if-or-ifs-function-to-evaluate-multiple-conditions-sample-file-dose-comparision
Sheet: Sheet1

Theoritical dose based on age | Prescribed dose | Underdosed | overdosed
110mg | 110mg | No | No
110mg | 75mg | Yes | No
Dose down to clinical judgement | 150mg | Dose down to clinical judgement | Dose down to clinical judgement
100mg | 150mg | No | Yes
Dose down to clinical judgement | 110mg | Dose down to clinical judgement | Dose down to clinical judgement
150mg | 75mg | Yes | No
Spreadsheet: 540366d1506659587-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet:  January 2017 summary

January 2017 summary |  | Total per Period | Total Hours-Per Job
# |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
Job
1 |  |  | x
2 |  |  |  | x
3 |  |  |  |  | x
4 |  |  |  |  |  | x
5 |  |  |  |  |  |  | x
6 |  |  |  |  |  |  |  | x
 | less shop hours
 | Hours less Shop
Job
7 |  |  |  |  |  |  |  |  | x
8 |  |  |  |  |  |  |  |  |  | x
9 |  |  |  |  |  |  |  |  |  |  | x
10 |  |  |  |  |  |  |  |  |  |  |  | x
11 |  |  |  |  |  |  |  |  |  |  |  |  | x
12 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | less shop hours
 | Hours less Shop
#1
#2
 | total
Totals |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
%
 |  |  | test
Vehicles
 | Fuel | 1386.99
 |  |  | test
 | Repairs & Maintenance | 4166.2
 |  | 154.7
 | Overhead | 17499.64
 |  |  | test
Spreadsheet: 856771d1705946377-check-multiple-conditions-for-proper-value-topstep
Sheet: INSTRUMENTS

 | TIME CALCS
 | INSTRUMENT | CONTRACT SIZE | TYPE | POINT VALUE | [NAME] | TICK VALUE | MARGIN REQUIRED | EXCHANGE | RT COMM
 | NQ | 20 | Dollar | 20 | 0.25 |  | 18480 | GBLX | 4.26
 | MNQ | 2 | Dollar | 2 | 0.25 |  | 1848 | CME | 1.42
 | ES | 50 | Dollar | 50 | 0.25 |  | 12320 | GBLX | 4.26
 | MES | 5 | Dollar | 5 | 0.25 |  | 1232 | CME | 1.42
 | CL | 1000 | Barrels | 1000 | 0.01 | 10 | 6380 | NYMEX | 4.6
 | MCL | 100 | Barrels | 100 | 0.01 | 1 | 726 | NYMEX | 1.72
 | GC | 100 | Troy Oz | 100 | 0.1 | 10 | 9130 | COMEX | 4.7
 | MGC | 10 | Troy Oz | 10 | 0.1 | 1 | 913 | COMEX | 1.72
Spreadsheet: 198832d1354905882-display-all-rows-when-condition-is-true-book1
Sheet: Sheet2

Result to display:
in website but also on esp
search by email address
email | order | date | amount
Spreadsheet: 221439d1363552669-stock-report-help-me-to-rectify-the-error-stock-report
Sheet: Stock

Item Code | Item Description | UOM | Stock in hand
101 | aaaa | Each | 150
102 | bbb | Each | 200
103 | [NAME] | Each | 500
104 | ddd | Tin | 4000
105 | eee | Tin | 500
106 | [NAME] | Drum | 150
107 | ggg | Each | 220
108 | hhh | Each | 150
109 | iii | Each | 100
110 | jjj | Each | 110
111 | kkk | Each | 45
112 | lll | Each | 55
113 | mmm | Tin | 65
114 | nnn | Tin | 75
115 | ooo | Tin | 90
116 | ppp | Tin | 500
117 | qqq | Tin | 456
118 | rrr | Tin | 546
119 | sss | Cartoon | 654
120 | ttt | Cartoon | 150
121 | uuu | Cartoon | 140
122 | vvv | Tin | 225
123 | www | Tin | 330
124 | xxx | Cartoon | 444
125 | yyy | Drum | 450
126 | zzz | Drum | 630
Spreadsheet: 676328d1588762046-bill-amount-automatically-changing-depending-on-which-month-year-selected-finances
Sheet: Scheduled Payments

Car Tax |  |  |  | Council Tax |  |  |  | Car Insurance |  |  |  | [NAME] |  |  |  | Loan |  |  |  | Rent
Month | Year | Amount |  | Month | Year | Amount |  | Month | Year | Amount |  | Month | Year | Amount |  | Month | Year | Amount |  | Month | Year | Amount
May | 2020 | 16.02 |  | April | 2020 | 110.4 |  | April | 2020 | 28.62 |  | June | 2020 | 30 |  | June | 2019 | 61.2 |  | April | 2020 | 72.39
June | 2020 | 15 |  | May | 2020 | 125 |  | May | 2020 | 25 |  | July | 2020 | 30 |  | July | 2019 | 62 |  | May | 2020 | 72.39
July | 2020 | 15 |  | June | 2020 | 125 |  | June | 2020 | 25 |  | August | 2020 | 30 |  | August | 2019 | 62 |  | June | 2020 | 72.39
August | 2020 | 15 |  | July | 2020 | 125 |  | July | 2020 | 25 |  | September | 2020 | 30 |  | September | 2019 | 62 |  | July | 2020 | 72.39
September | 2020 | 15 |  | August | 2020 | 125 |  | August | 2020 | 25 |  | October | 2020 | 30 |  | October | 2019 | 62 |  | August | 2020 | 72.39
October | 2020 | 15 |  | September | 2020 | 125 |  | September | 2020 | 25 |  | November | 2020 | 30 |  | November | 2019 | 62 |  | September | 2020 | 72.39
November | 2020 | 15 |  | October | 2020 | 125 |  | October | 2020 | 25 |  | December | 2020 | 30 |  | December | 2019 | 62 |  | October | 2020 | 72.39
December | 2020 | 15 |  | November | 2020 | 125 |  | November | 2020 | 25 |  | January | 2020 | 30 |  | January | 2020 | 62 |  | November | 2020 | 72.39
January | 2021 | 15 |  | December | 2020 | 125 |  | December | 2020 | 25 |  | February | 2021 | 30 |  | February | 2020 | 62 |  | December | 2020 | 72.39
February | 2021 | 15 |  | January | 2021 | 125 |  | January | 2021 | 25 |  | March | 2021 | 30 |  | March | 2020 | 62 |  | January | 2021 | 72.39
March | 2021 | 15 |  | February | 2021 | 125 |  | February | 2021 | 25 |  | April | 2021 | 30 |  | April | 2020 | 62 |  | February | 2021 | 72.39
April | 2021 | 15 |  | March | 2021 | 125 |  | March | 2021 | 25 |  | May | 2021 | 22.75 |  | May | 2020 | 62 |  | March | 2021 | 72.39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November | 2020 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December | 2020 | 62
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0129

 | Date: | 2013-01-29 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 11 | 57.11
 | 11:00:00 | 45 | 234.04
 | 12:00:00 | 87 | 470.11
 | 13:00:00 | 56 | 317.99
 | 14:00:00 | 34 | 187.19
 | 15:00:00 | 45 | 235.44
 | 16:00:00 | 26 | 147.5
 | 17:00:00 | 61 | 457.06
 | 18:00:00 | 63 | 511.59
 | 19:00:00 | 43 | 321.35
 | 20:00:00 | 34 | 208.75
 | 21:00:00 | 22 | 132.63
 | 22:00:00 | 16 | 117.27
 | 23:00:00 | 16 | 81.33
 | 1900-01-01 00:00:00 | 17 | 121.39
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: darrell_schoolcraft__7260__saledoc02_16TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2002-02-15 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/16/2002-02/19/02 |  |  | FAX Number:
Total Quantity |  |  | 40532 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.01
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/16/2002 | 2002-02-19 00:00:00 | 40532 |  | 10133 |  | 10133
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 10133 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -89270 | -72220 | 0 | -16950
2 | -96891 | -72220 | 0 | -24950 |  |  |  |  |  |  |  |  |  | Avg
3 | -97824 | -72220 |  | -24950 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4 | -102043 | -77338 |  | -24624
5 | -85354 | -69960 |  | -14933
6 | -48847 | -43328 |  | -4968 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 | -92703 | -80852 |  | -11848 |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 | -118238 | -73499 |  | -44100 |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 | -108131 | -67831 |  | -44100 |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 | -117446 | -72624 |  | -44100 |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 | -71313 | -71801 |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 | -93812 | -78819 |  | -14695 |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13 | -116838 | -102869 |  | -14950
14 | -137469 | -112243 |  | -23575
15 | -126244 | -125717 | -24768 | -23900
16 | -124446 | -125649 | -26997 | -23475
17 | -122387 | -126207 | -28598 | -23922
18 | -108356 | -94698 | -798 | -14282
19 | -114725 | -105190 |  | -9460
20 | -76579 | -62903 |  | -14515
21 | -119961 | -114049 | -9635 | -16604
22 | -105798 | -93449 | -572 | -13946
23 | -114411 | -102286 |  | -13687
24
25
26
27
28
29
30
31
 |  |  |  | 2001-08-31 00:00:00 |  |  | 457935.18
 |  |  |  | 2001-09-23 00:00:00
 | CBS Volume
 |  |  |  | 110189
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 13c

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche / Index | 3924396 | 8510448 | 1252358 | 2368997
Asia | 0 | 183807 | 0 | 49567
Europe | 1653901 | 4259758 | 643726 | 1024563
North America | 2242466 | 3677589 | 599403 | 1238961
Other | 28029 | 389294 | 9229 | 55906
Other | 0 | 522748 | 0 | 281437
Exotic/Total Return Swap | 0 | 64262 | 0 | 39745
Swaptions | 0 | 458486 | 0 | 241692
TOTAL | 3924396 | 9033196 | 1252358 | 2650434
Spreadsheet: 69291d1269846399-transpose-column-to-rows-transpose-1-
Sheet: Sheet4

Count of ? | Column Labels
Row Labels | M | N | Y | (blank) | Grand Total
Data |  | 3 |  |  | 3
Data1 | 1 |  | 1 |  | 2
DATA2 |  | 1 | 1 |  | 2
(blank)
Grand Total | 1 | 4 | 2 |  | 7
Spreadsheet: 689468d1596444326-check-price-for-different-related-part-number-check-latest-part-price-1-
Sheet: Sheet2

Part | Price | Effective from | Effective To |  |  |  | Check Part | Current quotation | Last 1st quotation | Last 2nd quotation |  |  | Check Part | Current quotation | Last 1st quotation | Last 2nd quotation
123K45670 | 525 | 2015-04-20 00:00:00 | 2015-10-01 00:00:00 | quotation expired |  |  | 123K45675 |  |  |  |  |  | 123K45674 | BLANK | 626 | 508
123K45670 | 519 | 2015-10-02 00:00:00 | 2016-10-03 00:00:00 | quotation expired |  |  |  |  |  |  |  |  |  | 123K45674 | 123K45673 | 123K45670
123K45670 | 516 | 2016-10-04 00:00:00 | 2019-10-06 00:00:00 | quotation expired |  |  |  |  |  |  |  |  | can use concatenate | 123K45674 "BLANK" | 123K45673 626 | 123K45670 508
123K45670 | 508 | 2019-10-07 00:00:00 |  | <=active quotaton
123K45671 | 541 | 2015-05-13 00:00:00 | 2017-04-18 00:00:00 | quotation expired |  |  |  |  |  |  |  |  | Notes
123K45673 | 609 | 2015-08-20 00:00:00 | 2015-10-01 00:00:00 | quotation expired |  |  |  |  |  |  |  |  | part roll up on last part number
123K45673 | 602 | 2015-10-02 00:00:00 | 2016-10-03 00:00:00 | quotation expired |  |  |  |  |  |  |  |  | D5, D12 are active quotation
123K45673 | 673 | 2016-10-04 00:00:00 | 2017-10-03 00:00:00 | quotation expired |  |  |  |  |  |  |  |  | input 123K45674, want [NAME] part price for previous revision part number
123K45673 | 635 | 2017-10-04 00:00:00 | 2018-09-30 00:00:00 | quotation expired
123K45673 | 630 | 2018-10-01 00:00:00 | 2019-09-30 00:00:00 | quotation expired
123K45673 | 626 | 2019-10-01 00:00:00 |  | <=active quotaton
…
…
…
A list of different part quotation.
…
…
…
…
…
…