tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 275455d1383522253-looking-up-a-name-in-another-sheet-and-displaying-a-value-under-it-kpicalculatorver2
Sheet: Sales

2013-10-26 00:00:00 | 10:28AM
Boost Juice - Cockburn Gateways (F235)
Sales By Staff Member [aggregate]
From 21/10/13- 8:00AM to 25/10/13- 9:00PM
Location | Area | Staff |  |  | [NAME] | Net Sales | GST | Gross Sales | Net Sales % | [NAME]
Boost Gateways
 | <Consolidated> |  |  |  |  |  |  |  |  |  |  |  | Blessing |  | [NAME] rocks
 |  | Blessing |  |  | 108 | 839.1936357 | 66.3163643 | 905.51 | 4.3133109 | 7.7703114
 |  | Brittany |  |  | 51 | 434.5518186 | 37.1481814 | 471.7 | 2.2335216 | 8.5206239
 |  | Cassie |  |  | 251 | 1995.4736359 | 173.6663641 | 2169.14 | 10.2563911 | 7.9500942
 |  | Chloe |  |  | 3 | 11.6727271 | 0.7272729 | 12.4 | 0.0599958 | 3.890909
 |  | Connor |  |  | 35 | 266.7456965 | 25.6343035 | 292.38 | 1.371027 | 7.6213056
 |  | Deven |  |  | 40 | 298.1545464 | 26.7654536 | 324.92 | 1.5324631 | 7.4538637
 |  | Felicity |  |  | 252 | 1943.256241 | 167.073759 | 2110.33 | 9.9880026 | 7.7113343
 |  | Jaimee |  |  | 391 | 3046.3434695 | 268.7165305 | 3315.06 | 15.6576812 | 7.7911598
 |  | [NAME] |  |  | 5 | 16.8181818 | 1.6818182 | 18.5 | 0.0864426 | 3.3636364
 |  | [NAME] |  |  | 131 | 1090.2533534 | 98.1466466 | 1188.4 | 5.6037146 | 8.3225447
 |  | Lauren |  |  | 23 | 201.6081817 | 18.0418183 | 219.65 | 1.0362314 | 8.7655731
 |  | Pearlyn |  |  | 76 | 551.8654542 | 48.6245458 | 600.49 | 2.8364935 | 7.2613876
 |  | Taryn |  |  | 98 | 735.7836368 | 65.1863632 | 800.97 | 3.7818013 | 7.5079963
 |  | [NAME] |  |  | 318 | 2432.6315105 | 202.0284895 | 2634.66 | 12.5033073 | 7.6497846
 |  | [NAME] |  | Location Total: | 1782 | 13864.3520891 | 1199.7579109 | 15064.11 | 71.2603837
 |  | bob
 |  | dog |  |  |  | 44
Armadale |  | Chloe
 | <Consolidated>
 |  | Breanna |  |  | 259 | 1997.1137762 | 180.1862238 | 2177.3 | 10.2648211 | 7.710864
 |  | [NAME] |  |  | 38 | 287.3499987 | 23.0900013 | 310.44 | 1.4769295 | 7.5618421
 |  | Curtis |  |  | 129 | 995.5736342 | 93.0513658 | 1088.625 | 5.1170771 | 7.7176251
 |  | Danielle |  |  | 151 | 1074.7990891 | 97.5309109 | 1172.33 | 5.5242823 | 7.1178748
 |  | [NAME] |  |  | 15 | 111.5057574 | 9.6692426 | 121.175 | 0.5731204 | 7.4337172
 |  | Rebecca |  |  | 25 | 167.8181813 | 14.2318187 | 182.05 | 0.8625566 | 6.7127273
 |  | Sophie.D |  |  | 40 | 331.1090907 | 27.1909093 | 358.3 | 1.7018437 | 8.2777273
 |  |  |  | Location Total: | 741 | 5591.5522525 | 493.5777475 | 6085.13 | 28.7396163
 |  |  |  | Grand Total: | 2523 | 19455.9043416 | 1693.3356584 | 21149.24 | 100
***End Of File*** | RedCat [NAME]
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Gas Logistics

Gas Logistics | ok
[NAME] | Logistics (Central Desk) | Analyst |  | 9 |  | 5000
[NAME] | Logistics (Texas Desk) | Analyst | 2 | 21 |  | 5000
[NAME] | Logistics (Central Desk) | Associate |  | 7 |  | 10000
[NAME] | Logistics (Central Desk) | Associate |  | 6 |  | 5000
[NAME] | Logistics (West Desk) | Associate |  | 22 |  | 15000
[NAME] | Logistics (East Desk) | Associate | 4 | 18 |  | 15000
[NAME] | Logistics (East Desk) | Director | 1 | 10 |  |  | R
[NAME] | Logistics (Central Desk) | Manager |  | 5 |  | 12000
[NAME] | Logistics (Texas Desk) | Manager |  | 20 |  | 30000
[NAME] | Logistics (West Desk) | Manager |  | 28 |  |  | R
[NAME] | Support | Manager |  | 29 |  | 10000
[NAME] | Logistics (Central Desk) | Manager |  | 1 |  |  | R
[NAME] | Logistics (East Desk) | Manager |  | 15 |  | 15000
[NAME] | Logistics (West Desk) | Manager |  | 23 |  |  | R
[NAME] | Support | Manager |  | 31 |  | 15000
[NAME] | Logistics (East Desk) | Manager | 9 | 11 |  |  | R
[NAME] | Logistics (East Desk) | Spec |  | 19 |  | 15000
Shannon  Groenewold | Logistics (West Desk) | Spec |  | 24 |  | 5000
[NAME] | Logistics (West Desk) | Spec | 3 | 25 |  | 5000
[NAME] | Logistics (Central Desk) | Sr. Spec |  | 8 |  | 4000
[NAME] | Logistics (East Desk) | Sr. Spec |  | 16 |  | 5000
[NAME] | Logistics (East Desk) | Sr. Spec |  | 12 |  |  | ????
[NAME] | Logistics (Central Desk) | Sr. Spec |  | 2 |  |  | R
[NAME] | Logistics (West Desk) | Sr. Spec |  | 27 |  | 15000
[NAME] | Logistics (Central Desk) | Sr. Spec |  | 4 |  | 10000
[NAME] | Logistics (Central Desk) | Sr. Spec |  | 3 |  | 10000
Meredith Homco | Logistics (East Desk) | Sr. Spec |  | 14 |  | 10000
[NAME] | Support | Sr. Spec |  | 30 |  | 8000
[NAME] | Support | Sr. Spec |  | 32 |  | 8000
[NAME] | Logistics (East Desk) | Sr. Spec |  | 13 |  | 10000
[NAME] | Logistics (East Desk) | Sr. Spec |  | 17 |  | 15000
[NAME] | Logistics (West Desk) | Sr. Spec | 13 | 26 |  | 8000
 |  | TOTAL
Spreadsheet: 705246d1605960230-outputting-values-to-new-column-based-on-id-and-if-condition-sampx
Sheet: Sheet1

ID: |  |  | Type |  |  |  |  | Delivery: | Relation: | Expected Value:
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | RRR |  | -/-/-/-/-
11344 |  |  | AAAT |  |  |  |  | RRR | CCCR | TPAR
11344 |  |  | FFFT |  |  |  |  | ABC w/ I | [NAME] | TPAR
11454 |  |  | TTTT |  |  |  |  |  | CCCR | No Scenarios
11454 |  |  | AAAT |  |  |  |  | AAA | CCCR | No Scenarios
11454 |  |  | AAAT |  |  |  |  | AAA |  | No Scenarios
11454 |  |  | AAAT |  |  |  |  | RRR |  | No Scenarios
11556 |  |  | AAAT |  |  |  |  | AAA | CCCR | CCCR/ CCCR
11556 |  |  | IIIT |  |  |  |  | RRR | CCCR | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ABC w/ I | [NAME] | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ZZZ w/o I | IIIR | CCCR/ CCCR
11556 |  |  | AAAT |  |  |  |  | ZZZ w/o I | CCCR | CCCR/ CCCR
11556 |  |  | AAAT |  |  |  |  | AAA | CCCR | CCCR/ CCCR
11556 |  |  | IIIT |  |  |  |  | RRR | CCCR | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ZZZ w/o I | IIIR | CCCR/ CCCR
11556 |  |  | AAAT |  |  |  |  | ZZZ w/o I | CCCR | CCCR/ CCCR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | CCCR | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | DHR | VVVR
1158 |  |  | FFFT |  |  |  |  | ABC w/ I | VVVR | VVVR
1158 |  |  | IIIT |  |  |  |  | BBB | VVVR | VVVR
1158 |  |  | FFFT |  |  |  |  | RRR | CCCR | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I |  | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | DHR | VVVR
1158 |  |  | IIIT |  |  |  |  | BBB |  | VVVR
10975 |  |  | FFFT |  |  |  |  | ABC w/ I | TPAR | TPAR
10975 |  |  | FFFT |  |  |  |  | RRR | CCCR | TPAR
1407 |  |  | FFFT |  |  |  |  | CD w/o Z | TPAR | No Scenarios
1407 |  |  | FFFT |  |  |  |  | ZZZ w/o I | TPAR | No Scenarios
1407 |  |  | FFFT |  |  |  |  | ZZZ w/o I | CCCR | No Scenarios
1407 |  |  | FFFT |  |  |  |  | FFF | CCCR | No Scenarios
1161 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -
1161 |  |  | FFFT |  |  |  |  | RRR |  | -
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR | CCCR/ TPAR/ DPAC
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | TPAR | CCCR/ TPAR/ DPAC
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | DPAC | CCCR/ TPAR/ DPAC
Spreadsheet: 272299d1382350622-rearranging-datewise-horizontally-in-a-specified-format-from-raw-data-vat1_revised
Sheet: Result

Date | Name of Party | Particulars | Reference No. | Taxable Purchase | Taxable Import | [NAME] | [NAME] in Custom | Excise Duty | Total
Spreadsheet: phillip_m_love__30052__Physical Tab example
Sheet: Physical

 | INTRACENTRAL1
 |  |  |  | TOTAL |  |  |  |  |  |  | TOTAL
 | THIRD PARTY SALES |  | TOTAL $'s | MMBTU | AVG PRICE |  |  | THIRD PARTY PURCHASES |  | TOTAL $'s | MMBTU | AVG PRICE
1 | Sales |  |  |  |  |  | 6 | Purchases
 | AFFILIATE & |  |  | TOTAL |  |  |  | AFFILIATE & |  |  | TOTAL
 | INTERDESK SALES |  | TOTAL $'s | MMBTU | AVG PRICE |  |  | INTERDESK PURCHASES |  | TOTAL $'s | MMBTU | AVG PRICE
1 | Canada |  |  |  |  |  | 6 | Canada
1 | HPLR-Texas Desk |  |  |  |  |  | 6 | HPLR-Texas Desk
1 | LGM-Northeast |  |  |  |  |  | 6 | LGM-Northeast
3 | Central Desk |  |  |  |  |  | 8 | Central Desk
3 | [NAME] |  |  |  |  |  | 8 | [NAME]
3 | Market East Desk |  |  |  |  |  | 8 | Market East Desk
3 | Northeast Desk |  |  |  |  |  | 8 | Northeast Desk
3 | [NAME] |  |  |  |  |  | 8 | [NAME]
3 | [NAME] |  |  |  |  |  | 8 | [NAME]
3 | Sithe Desk |  |  |  |  |  | 8 | Sithe Desk
3 | Texas Desk |  |  |  |  |  | 8 | Texas Desk
3 | West Desk |  |  |  |  |  | 8 | West Desk
3 | Midwest Desk |  |  |  |  |  | 8 | Midwest Desk
3 | Storage Desk |  |  |  |  |  | 8 | Storage Desk
10 | [NAME] |  |  |  |  |  | 10 | [NAME]
11 | EMW - Desk |  |  |  |  |  | 12 | EMW - Desk
13 | CPR Imbalance |  |  |  |  |  | 13 | CPR Imbalance
14 | CPR Cash Out |  |  |  |  |  | 15 | CPR Cash Out
16 | CPR Pipeline Exchange |  |  |  |  |  | 16 | CPR Pipeline Exchange
17 | CPR Storage |  |  |  |  |  | 18 | CPR Storage
 | [NAME] Sales |  |  |  |  |  |  | Gross Affilliate Purchases
 | TOTAL SALES |  |  |  |  |  |  | TOTAL PURCHASES
 |  |  |  |  |  |  |  | This line is used exclusively for calculating Unaccounted For
 |  |  |  |  |  |  |  | Long Term Firm WACOG
 |  |  |  |  |  |  | 22 | Unaccounted For
Spreadsheet: 689090d1596118570-formula-to-calculate-totals-with-different-variables-build-test
Sheet: Sheet1

Date | SOR | A/C | Single / Tandem / Triple / Quad | WOR/s | Date released to Build area | Date Completed | Time Taken (days) | Bonus
2020-07-27 00:00:00 | 302564 | B214 | 1 | 12799 | 2020-07-27 00:00:00 | 2020-07-29 00:00:00
2020-07-27 00:00:00 | 302559 | GB-WR136AR | 1 | 12795 | 2020-07-27 00:00:00 | 2020-07-29 00:00:00
2020-07-24 00:00:00 | 302529 | H271 | 3 | 12786-12791 | 2020-07-24 00:00:00 | 2020-07-29 00:00:00
2020-07-21 00:00:00 | 302403 | P288 | 1 | 12756 | 2020-07-27 00:00:00 | 2020-07-29 00:00:00
2020-07-21 00:00:00 | 302403 | P288 | 1 | 12757 | 2020-07-27 00:00:00 | 2020-07-29 00:00:00
2020-06-25 00:00:00 | 301428 (BO) | M44 | 2 | 301428 | 2020-07-27 00:00:00 | 2020-07-29 00:00:00
Spreadsheet: 075935a9-6d98-49b6-9a11-20b5872ae8aa
Sheet: Sheet1

Table 7--U.S. feed grain imports by selected sources (1,000 metric tons) 1/, 9/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Import and country/region |  | ---------- 2010/11 ---------- |  | ---------- 2011/12 ---------- |  | 2012/13
 |  | Mkt year | [NAME] | Mkt year | [NAME] | [NAME]
Oats | Canada | 1393.292808 | 216.536372 | 1556.499397 | 143.054521 | 231.852351
 | Finland | 73.932572 | 51.724542 | 34.84057 | 7.837
 | Jamaica | 0.159212 | 0.003527 | 0.285218
 | All other countries | 0.264317 | 0.08096199999999999 | 29.802409 | 0.001512 | 0.263991
 | Total 2/ | 1467.648909 | 268.345403 | 1621.427594 | 150.893033 | 232.116342
Malting barley | Canada | 174.724159 | 55.611237 | 263.660306 | 4.08383 | 67.328575
 | All other countries | 0.006579999999999999 |  | 0.244638 | 0.017
 | Total 2/ | 174.730739 | 55.611237 | 263.904944 | 4.10083 | 67.328575
Other barley 3/ | Canada | 30.697571 | 3.617715 | 89.27383699999999 | 8.950962 | 6.303527000000001
 | All other countries | 1.288141 | 0.162659 | 0.7575109999999999 | 0.01262 | 0.164861
 | Total 2/ | 31.985712 | 3.780374 | 90.03134800000001 | 8.963581999999999 | 6.468388
1/ Grain only. Market year (June-May) and market year to date. 2/ Totals may not add due to rounding.
3/ Grain for purposes other than malting, such as feed and seed use. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics.
Date run: 9/12/2012
Spreadsheet: 166127d1341477252-how-to-align-dates-and-values-with-different-frequencies-book1
Sheet: Sheet1

Date | Exchange rate |  |  | Date | Price (RMB/kg) | Date (currency) | Exchange rate
2011-01-31 00:00:00 | 0,10 |  |  | 2011-01-01 00:00:00 | 100
2011-02-28 00:00:00 | 0,11 |  |  | 2011-01-07 00:00:00 | 113
2011-03-31 00:00:00 | 0,13 |  |  | 2011-01-15 00:00:00 | 110
2011-04-30 00:00:00 | 0,12 |  |  | 2011-01-31 00:00:00 | 114 | 2011-01-31 00:00:00 | 0,10
 |  |  |  | 2011-02-01 00:00:00 | 100
 |  |  |  | 2011-02-07 00:00:00 | 113
 |  |  |  | 2011-02-15 00:00:00 | 110
 |  |  |  | 2011-02-28 00:00:00 | 114 | 2011-02-28 00:00:00 | 0,11
Spreadsheet: 848637d1699335661-newbie-help-if-vlookup-not-sure-which-formula-to-use-formula-help-example-aligw
Sheet: Summary Sheet

FY24 Board Approved | FY Board Approved Date | FY24 Construction Start Date |  |  |  |  |  |  |  |  |  | FILTER |  |  |  |  | CHOOSECOLS
 |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
Store 14 |  | 2024-03-01 00:00:00 |  |  |  |  |  |  |  |  |  | Store 14 | 00:00:00 | 00:00:00 | 2024-03-01 00:00:00 |  | Store 14 | 00:00:00 | 2024-03-01 00:00:00
Store 20 | 2024-04-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | Store 20 | 00:00:00 | 2024-04-04 00:00:00 | 00:00:00 |  | Store 20 | 2024-04-04 00:00:00 | 00:00:00
Store 21 | 2024-05-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | Store 21 | 00:00:00 | 2024-05-05 00:00:00 | 00:00:00 |  | Store 21 | 2024-05-05 00:00:00 | 00:00:00
Store 22 | 2024-06-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | Store 22 | 00:00:00 | 2024-06-06 00:00:00 | 00:00:00 |  | Store 22 | 2024-06-06 00:00:00 | 00:00:00
The 'Examples' below is basically the Result that I'm looking for:
Examples
Store 1 | XX Date from 'Data Sheet' | XX Date from 'Data Sheet'
Store 4 | XX Date from 'Data Sheet' | XX Date from 'Data Sheet'
Store 10 | XX Date from 'Data Sheet' | XX Date from 'Data Sheet'
Spreadsheet: 728575d1618516709-consolidation-of-tables-table-consolidation
Sheet: Table consolidation

Table 1 |  |  |  | Table 2 |  |  |  | Table 3 |  |  |  | Table 4
A: | Data |  |  | A: | Sometimes data, if data in B |  |  | A: | Blank |  |  | A: | Data from A in Table 1 and Table 2, sorted in ascending order
B: | Blank |  |  | B: | Data |  |  | B: | Sometimes data, if data in C |  |  | B: | Data from B in Table 2 and Table 2, sorted in ascending order
C: | Blank |  |  | C: | Blank |  |  | C: | Data |  |  | C: | Data from C in Table 2, sorted in ascending order
A | B | C |  | A | B | C |  | A | B | C |  | A | B | C |  | A | B | C
8 |  |  |  | 5 | 6 |  |  |  |  | 10 |  | 1 | 2 |  |  |  | 2
5 |  |  |  |  | 9 |  |  |  | 6 | 7 |  | 5 | 6 | 7 |  | 5 | 6 | 7
 |  |  |  | 1 | 2 |  |  |  | 3 | 4 |  | 5 | 6 | 13 |  | 5 | 6 | 13
 |  |  |  | 5 | 11 |  |  |  | 6 | 13 |  | 5 | 11 | 12 |  | 5 | 11 | 12
 |  |  |  |  | 3 |  |  |  | 11 | 12 |  | 5 | 14 |  |  | 5 | 14
 |  |  |  | 5 | 14 |  |  |  | 15 | 17 |  | 8 |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 |  |  | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 17 |  |  | 15 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | 10
General: |  |  |  |  |  |  |  |  |  |  |  | Line two (5, 6, 7) is a merge of line 1 in Table 2 (5, 6, blank) and line 2 in Table 3 (blank, 6, 7)
A single A can point to many [NAME] which again can point to many [NAME]. |  |  |  |  |  |  |  |  |  |  |  | Line three  (5, 6, 13) is a merge of line 1 in Table 2 (5, 6, blank) and line 4 in Table 3 (blank, 6, 13)
A single C can point to only one B which again can point to only one A. |  |  |  |  |  |  |  |  |  |  |  | Line four (5, 11, 12) is a merge of line 4 in Table 2 (5, 11, blank) and line 5 in Table 3 (blank, 11, 12)
[NAME] should work with both text entries and number entries. |  |  |  |  |  |  |  |  |  |  |  | Line 2, 3, 4 and 5 absorbes line 2 in Table 1
 |  |  |  |  |  |  |  |  |  |  |  | Line 7 absorbes line 5 of table 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 11 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 737768d1624593724-sort-data-using-filter-or-sortby-function-excel-365-var-report-using-filter-function
Sheet: Sheet1

 |  |  | I'm kindly asking for a formula to produce VAT report using FILTER and or [NAME] function (excel 365)
 |  |  |  |  |  |  |  |  |  |  | Desired outcome
Date | Code | Invoice No. | Customer | [NAME]. No. | Description | Amount (excl vat) | Vat % | [NAME] | Amount (incl vat) |  | Customer | Date | Invoice No. | [NAME] | Amount (incl vat)
2021-06-01 00:00:00 | US001 | 2020-0001 | [NAME] | 102001 | Cash purchases | 10000 | 0.15 |  |  |  | CHIEDZA | 2021-06-03 00:00:00 | 2020-0002 | 0 | 20000
2021-06-03 00:00:00 | US002 | 2020-0002 | CHIEDZA | 102002 | Cash purchases | 20000 | 0 |  |  |  | CHIEDZA | 2021-07-12 00:00:00 | 2020-0006 | 9000 | 69000
2021-06-04 00:00:00 | US003 | 2020-0003 | CRAIG | 102003 | Cash purchases | 30000 | 0 |  |  |  | CHIEDZA | 2021-06-07 00:00:00 | 2020-0009 | 150 | 1150
2021-06-07 00:00:00 | US009 | 2020-0009 | CHIEDZA | 102002 | Cash purchases | 1000 | 0.15 |  |  |  | CRAIG | 2021-06-04 00:00:00 | 2020-0003 | 0 | 30000
2021-05-02 00:00:00 | US004 | 2020-0004 | YOLANDA | 102004 | Cash purchases | 40000 | 0.15 |  |  |  | CRAIG | 2021-07-13 00:00:00 | 2020-0007 | 10500 | 80500
2021-07-11 00:00:00 | US001 | 2020-0005 | [NAME] | 102005 | Cash purchases | 50000 | 0.15 |  |  |  | [NAME] | 2021-06-01 00:00:00 | 2020-0001 | 1500 | 11500
2021-07-12 00:00:00 | US003 | 2020-0006 | CHIEDZA | 102006 | Cash purchases | 60000 | 0.15 |  |  |  | [NAME] | 2021-07-11 00:00:00 | 2020-0005 | 7500 | 57500
2021-07-13 00:00:00 | US007 | 2020-0007 | CRAIG | 102007 | Cash purchases | 70000 | 0.15 |  |  |  | YOLANDA | 2021-05-02 00:00:00 | 2020-0004 | 6000 | 46000
2021-07-14 00:00:00 | US008 | 2020-0008 | YOLANDA | 102008 | Cash purchases | 80000 | 0.15 |  |  |  | YOLANDA | 2021-07-14 00:00:00 | 2020-0008 | 12000 | 92000
Spreadsheet: 140885d1328923302-returning-borrowed-amounts-borrowed-amounts
Sheet: Sheet1

Borrower | Amount ($) | Start Date | Repay Date | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00
[NAME] | 100 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 |  |  | 100 | 100
[NAME] | 120 | 2012-01-04 00:00:00 | 2012-01-06 00:00:00 |  | 120 | 120 | 120
[NAME] | 150 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 150 | 150
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
[NAME] |  |  |  | Volumetric | [NAME]
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | if changed to volumetric the volume would be 61,000 mmbtus
NGPL |  |  |  | Volumetric | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Amoco |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
Northwest |  |  |  | Volumetric | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME] | cashed out monthly
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 806943d1669685421-separate-the-value-ipv6
Sheet: Sheet1

IPV6 & IPV4 | IPV4
fe80::94f:607b:19bc:43b0 172.20.32.147
fe80::94ba:dd13:f43c:8e9f 172.20.4.100
fe80::94a3:cb56:c87e:ef5a 172.20.34.183
fe80::9489:9d8e:3e0d:6bcf 172.24.2.69
fe80::9470:93a3:124d:bca7 172.20.211.97
fe80::9424:1c8:f1f4:1bbd 172.20.4.14
fe80::9420:f100:7aed:e998 172.20.4.181
fe80::9406:f0fb:9bed:4b4e 172.20.211.113
fe80::91f:1dc9:9151:86ed 172.20.209.161
fe80::917:c4ef:4017:a7c8 172.20.34.38
fe80::9169:723f:4739:7ec0 172.20.34.192
fe80::9168:481b:8e29:9a52 10.45.1.245
fe80::90f1:5128:bce:5e12 172.20.211.106
fe80::90eb:112d:88e5:d2b5 172.20.34.235
fe80::90be:6155:b0dc:fd61 172.20.211.192
fe80::90bb:db8a:40ca:10c4 172.20.223.73
fe80::90a0:bb12:64d3:43e8 172.20.33.193
fe80::90a:94c1:45f6:69fa 172.20.223.75
fe80::9068:466d:50d4:ac20 172.20.34.49
fe80::9031:7514:3336:75b8 172.20.33.78
fe80::901a:62f8:4362:e0b6 172.20.32.105
fe80::8e5:999:70f8:b89f 172.20.32.190
fe80::8dfe:7c7e:6514:364a 172.20.35.78
fe80::8dd8:7ba0:35e7:c4bd 172.20.211.108
fe80::8d64:9b48:4e28:3670 172.20.211.200
[NAME]:adb9:3036:c88a 172.20.34.40
fe80::8d50:658:e2e7:47b1 172.24.2.44
fe80::8d4b:622f:bc5b:bbc2 10.45.1.246
fe80::8cd:eb30:7faa:42aa 172.20.33.146
fe80::8c95:7dfa:da40:6056 172.21.144.50
fe80::8c77:13ab:baa2:d839 172.20.211.101
fe80::8c62:f3a0:a5d:efbb 172.20.210.160
Spreadsheet: b353b1a6-e782-4d9c-a34b-a7b87e222c6e
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
FFLUR | Test | FFLUR | Flurazepam (Dalmane) and Desalkylflurazepam | Flurazepam (Dalmane) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL sodium heparin plasma frozen in plastic vial.   Serum Draw blood in a plain, red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum frozen in plastic vial. | 0.3 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | Flurazepam: Reference Range:  0-30 ng/mL   Desalkylflurazepam:  Reference Range: 30-150 ng/mL   Flurazepam + Desalkyflurazepam:  Reference Range:  30-180 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 | 82742 |  |  |  |  | Medtox Laboratories, Inc.
FFLUR | [NAME] | VARIES | Varies |  |  |  | Frozen | 180 days
FFLUR | Result | [NAME] | Flurazepam | Flurazepam | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFLUR | Result | Z1160 | Desalkylflurazepam | Desalkylflurazepam | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFLUR | Result | Z1161 | Flurazepam + Desalkylflurazepam | Flurazepam + Desalkylflurazepam | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process