tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: andy_zipper__714__Asian Options
Sheet: Cinergy Cal '02 Example

 | Asian on Multiple Underlyings
 | Cal '02 30 Strike  for [NAME]
 | EffDt | 2001-09-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OUTPUTS
 |  |  |  | INPUTS |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 4
 | Premium | Avg. Start Date | Avg. End Date | Fwd Price | Ann.Vol | Time to Avg. Start | Time to Avg. End | # [NAME] Prices | Set Days | Strike | Ann.IntRt | Correlation | Avg. Price to Date | Time to [NAME] | Call/Put (1/0) | Month | Price | Delta | Gamma | Vega | Rho
 |  | 2002-01-01 00:00:00 | 2002-01-31 00:00:00 | 33.47 | 0.75 |  |  |  |  | 30 | 0.045 | 0.25 | 0 |  | 1 | 1
 |  | 2002-02-01 00:00:00 | 2002-02-28 00:00:00 | 33.12 | 0.75 |  |  |  |  |  |  |  |  |  |  | 2
 |  | 2002-03-01 00:00:00 | 2002-03-31 00:00:00 | 32.02 | 0.7 |  |  |  |  |  |  |  |  |  |  | 3
 |  | 2002-04-01 00:00:00 | 2002-04-30 00:00:00 | 32.97 | 0.7 |  |  |  |  |  |  |  |  |  |  | 4
 |  | 2002-05-01 00:00:00 | 2002-05-31 00:00:00 | 37 | 0.7 |  |  |  |  |  |  |  |  |  |  | 5
 |  | 2002-06-01 00:00:00 | 2002-06-30 00:00:00 | 47 | 0.75 |  |  |  |  |  |  |  |  |  |  | 6
 |  | 2002-07-01 00:00:00 | 2002-07-31 00:00:00 | 60.75 | 0.9 |  |  |  |  |  |  |  |  |  |  | 7
 |  | 2002-08-01 00:00:00 | 2002-08-31 00:00:00 | 60.75 | 0.9 |  |  |  |  |  |  |  |  |  |  | 8
 |  | 2002-09-01 00:00:00 | 2002-09-30 00:00:00 | 32.55 | 0.5 |  |  |  |  |  |  |  |  |  |  | 9
 |  | 2002-10-01 00:00:00 | 2002-10-31 00:00:00 | 30.36 | 0.5 |  |  |  |  |  |  |  |  |  |  | 10
 |  | 2002-11-01 00:00:00 | 2002-11-30 00:00:00 | 30.56 | 0.5 |  |  |  |  |  |  |  |  |  |  | 11
 |  | 2002-12-01 00:00:00 | 2002-12-31 00:00:00 | 30.76 | 0.5 |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xASTRIP2m
Spreadsheet: 0341d454-e2c9-428c-a278-189e0ea6c7e0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
Stormwater Only at Discharge Outfall
Analytical [NAME] for Compost Facilities - DRAFT as of July 13, 2010
Compost Facility Type |  |  |  |  |  |  |  |  |  | I |  | II |  | III |  | IV/DWQ Permitted Fac.
Facility Size |  |  |  |  |  |  |  |  |  | Small | Large | Small | Large | Small | Large | Small | Large
Permit Required |  |  |  |  |  |  |  |  |  | Exempt | General | General | General | General2 | Individual | Individual | Individual
Monitored Constituents 1,3: |  | Units | North Carolina DWQ Rec. [NAME] (Ref. A)6 | Oregon 1200-Z Bmrk  (Ref. B) | Oregon 1200-COLS Bmrk  (Ref. B) | Washington Industrial General Bmrk  (Ref. B) | California Bmrk  (Ref. B) | Maine Multi-Sector General Permit Bmrk (Ref. B) | Frequency7
Total Suspended Solids |  | mg/l | 100 | 130 | 50 |  | 100 |  | Quarterly |  | ü | ü | ü | ü | ü | ü | ü
Chemical Oxygen Demand8 |  | mg/l | 30 | 30 (Ref. C) | 33 | 30 |  |  | Quarterly |  | ü | ü | ü | ü | ü | ü | ü
Total Nitrogen |  | mg/l | 30 |  |  |  |  |  | Quarterly |  | ü | ü | ü | ü | ü | ü | ü
Total Phosphorous |  | mg/l | 2 | 2 (Ref. C) | 0.16 | 2 | 2 | 2 | Quarterly |  | ü | ü | ü | ü | ü | ü | ü
Fecal Coliform |  | colonies/100ml | 1000 |  |  |  |  |  | Quarterly |  | ü | ü | ü | ü | ü | ü | ü
pH |  | standard units | 6 - 9 | 5.5-9 | 6.5-8.5 | 6 - 9 | 6 - 9 |  | Quarterly |  | ü | ü | ü | ü | ü | ü | ü
Total Cu 9,10 |  | mg/l | 0.0105 | 0.1 | 0.036 | .014-.032 |  |  | Quarterly |  | ü | ü | ü | ü | ü | ü | ü
Total Zn 9,10 |  | mg/l | 0.075 | 0.6 | 0.24 | 0.117 | 0.117 | 0.117 | Quarterly |  | ü | ü | ü | ü | ü | ü | ü
Total Pb 9,10 |  | mg/l | 0.126 | 0.4 | 0.006 | 0.0816 | 0.0816 | 0.0816 | Quarterly |  | ü | ü | ü | ü | ü | ü | ü
Total Rainfall |  | Inches |  |  |  |  |  |  | Quarterly |  | ü | ü | ü | ü | ü | ü | ü
Notes:
1. Total Maximum Daily Limits (TMDL) - Additional parameters may be required depending upon site watershed.  Units and benchmarks will depend on constituents in feedstocks.
2. Certain feedstock types may require Individual Permit.
3. Standard test methods as approved by DWQ where appropriate
4.  Excludes vehicle maintenance activities triggers associated with General Permits
5.  Normal tiered monitoring protocols for exceedances also apply.
6.  [NAME] are not violations they are triggers for action.
7.  Monitoring frequency maybe stepped depending on data.  Open to reduction of frequency based on consistent passing data.
8.  Monitoring Committee recommends measuring COD instead of BOD.
9. metal anaylis:  Total
10 Values reported are revised bench marks that are anticipated to be approved as part of the Classification and Standards Unit Triannual review
References:
A.  Individual Permit:  [NAME] and [NAME], August 10, 2007 provided by NCDENR - DWQ
B. Contract: Commerical Composting Water Quality Permit Development, May 12, 2004 provided by CH2MHill
[NAME], February 2008 provided by BioCycle
Spreadsheet: 0af6a203-a8f5-4bc5-9ce0-d8cc6a1e3c45
Sheet: Sheet1

Supplementary [NAME]. Summary of the details of sampling | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Sample No. | Formations |  | Lithologies | Location |  |  | Remarks*
 | The Shuangqiaoshan Group (SQS)
[NAME] | The Hengyong Formation |  | Mudstone | N 29o21'23.1", E 115o01'28.8" |  |  | G
WW221 |  |  | Mudstone |  |  |  | G
WW223 |  |  | Mudstone |  |  |  | G
WW225 |  |  | Mudstone |  |  |  | G
WW226 |  |  | Mudstone |  |  |  | G
[NAME] |  |  | Mudstone |  |  |  | G
WW230 | The Jiling Formation |  | Sandstone | N 29o21'14.2", E 115o01'31.6" |  |  | G, P
WW231 |  |  | Sandstone |  |  |  | G, P
[NAME] |  |  | Sandstone |  |  |  | P
WW235 |  |  | Sandstone |  |  |  | P
[NAME] |  |  | Sandstone | N 29o21'23.1", E 115o01'28.8" |  |  | G
WW237 |  |  | Sandstone |  |  |  | G, P
WW238 |  |  | Sandstone |  |  |  | G, P
WW158 | The Anlelin Formation |  | Mudstone | N 29o20'57.1", E 115o08'34.1" |  |  | G
WW161 |  |  | Mudstone |  |  |  | G
WW163 |  |  | Mudstone |  |  |  | G
[NAME] |  |  | Mudstone |  |  |  | G
WW171 |  |  | Sandstone |  |  |  | G
[NAME] |  |  | Sandstone |  |  |  | G
[NAME] |  |  | Sandstone |  |  |  | G, P
WW177 |  |  | Sandstone |  |  |  | G, P
WW180 |  |  | Sandstone | N 29o21'08.4", E 115o07'12.5" |  |  | G, P
WW182 |  |  | Sandstone |  |  |  | G, P
WW185 |  |  | Mudstone |  |  |  | G
WW240 | The Xiushui Formation |  | Sandstone | N 29o02'52.2", E 114o33'59.3" |  |  | G, P
[NAME] |  |  | Mudstone |  |  |  | G
WW246 |  |  | Sandstone |  |  |  | G, P
WW247 |  |  | Sandstone | N 29o03'09.1", E 114o35'37.1" |  |  | G, P
[NAME] |  |  | Sandstone |  |  |  | G, P
 | The Xikou Group (XK)
WN1001 | The Banqiao Formation |  | Sandstone | N 29o37'25.2", E 117o44'25.9" |  |  | G
WN1002 |  |  | Sandstone |  |  |  | G, P
WN1004 |  |  | Phyllitic siltstone |  |  |  | G
WN1006 |  |  | Sandstone |  |  |  | G, P
WN1007 |  |  | Sandstone |  |  |  | G
WN1008 |  |  | Sandstone |  |  |  | G
WN1012 | The Mukeng Formation |  | Sandstone | N 29o38'20.8", E 117o45'5.4 |  |  | G, P
WN1016 |  |  | Phyllitic siltstone |  |  |  | G
WN1021 |  |  | Phyllitic siltstone |  |  |  | G
WN1022 |  |  | Phyllitic siltstone |  |  |  | G
WN1023 |  |  | Phyllitic siltstone |  |  |  | G
WN1024 |  |  | Phyllitic siltstone |  |  |  | G
WN1025 | The Niuwu Formation |  | Sandstone | N 29o53'31.8", E 118o15'31.3" |  |  | G, P
WN1027 |  |  | Sandstone |  |  |  | G
*: G represents the sample used for geochemistry analysis; P indicates the sample used for petrology observation
Spreadsheet: darrell_schoolcraft__7322__imball0202
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 |  | 150
2 | 309 | 150
3 | 285 | 150
4 | 252 | 150
5 | 300 | 150
6 | 31 | 150
7 | 4 | 150
8 | 303 | 150
9 | 289 | 150
10 | 146 | 150
11 | 52 | 150
12 | 315 | 150
13 | 201 | 150
14 | 186 | 150
15 | 164 | 150
16 | 142 | 150
17 | 227 | 150
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 174593.14
2002-02-17 00:00:00
CBS Volume
 |  |  | 76390
Spreadsheet: 769496d1645560778-determine-smallest-reel-possible-for-x-meters-of-cable-smallest-reel-possible-for-meters
Sheet: Problem

Product X | Reel sizes in inches L x W | Lengths in meters
 |  | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750 | 800 | 850 | 900 | 950 | 1000 | 1050 | 1100 | 1150 | 1200 | 1250 | 1300 | 1350 | 1400 | 1450 | 1500 | 1550 | 1600 | 1650 | 1700 | 1750 | 1800 | 1850 | 1900 | 1950 | 2000 | 2100 | 2150 | 2200
 | 36x27.5 | 4 | 5 | 1 | 9 | 38
 | 40x27 |  |  | 1 | 34 | 64
 | 42x30 |  |  |  | 3 | 3
 | 44x27 | 2 | 1 | 2 | 1 | 1 | 1 | 1
 | 45x32 |  | 1 |  |  | 1 |  |  |  | 1
 | 50x38 |  | 1 |  | 2 | 1 | 11 | 7 | 10 | 7 | 3 | 15 | 5 | 4 | 1 | 1
 | 56x38 |  |  |  |  | 1 |  |  |  | 1 | 1 | 1 | 3 | 7 | 3 | 6 | 6 | 6 | 4 | 1 |  | 1
 | 60x38 |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 2 | 2 |  | 1 | 2 | 5 | 6 | 2 | 2 | 1 |  | 1
 | 68x38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 | 4 | 4 | 3 | 3 | 8 | 6 | 16 | 6 | 2 | 1 |  | 1 |  | 1
 | 72x39 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 | 1 | 2 | 4 | 10 | 4 | 3 | 4 | 1 | 1 | 1 | 2 | 4 | 4 |  | 1 |  | 1
 | 72x42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 1 |  |  |  |  | 1 |  |  | 1
 | 78x39 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 4 | 9 | 3 | 2 | 3 | 4 | 4 | 2 | 2 | 4 | 4
 | 84x43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  | 1 | 1 |  |  |  |  |  | 2 | 2 | 3 | 1 | 3
 | 96x47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
 | 100x76 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
1 | 300 meters of product X were put on a reel as small as 36x27.5
2 | 300 meters of product X were put on 40, 42, 44, 45, 50, 56, 78 in reels when they could have been put on 36 in reels
3 | All the red numbers could have been put on a smaller reel
4 | On tab Raw data, how do I determine the smallest reel on which the meters on that transaction for that transaction product could have been put on?
Spreadsheet: 706124d1606485304-large-condition-with-sumproduct-and-mmult-11111
Sheet: Sheet1

 |  |  | Total |  | Top 40% |  | Top 40% to 60% |  | Top 60% to 80% |  | Above 80%
 |  | code | No's | Value | No's | Value | No's | Value | No's | Value | No's | Value
 |  | 1111
 |  | 2222
 |  | 3333
 |  | 4444
 |  | 5555
 |  | 6666
Spreadsheet: 550136d1512124262-weekly-tables-score1
Sheet: WEEK 1

 |  | SCORE |  |  |  |  | CARL |  |  | PTS |  | CAOLAN |  |  | PTS |  | SHANE |  |  | PTS |  | JENNY |  |  | PTS |  | SHAUN |  |  | PTS |  |  | WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE | WK PTS | TOTAL PTS
 | ARSENAL | 5 | V | 0 | HUDDERSFIELD |  | 3 | V | 1 | 1 |  | 3 | V | 0 | 1 |  | 2 | V | 1 | 1 |  | 2 | V | 0 | 1 |  | 2 | V | 0 | 1 |  |  | CARL
 | BOURNEMOUTH | 1 | V | 2 | BURNLEY |  | 1 | V | 1 | 0 |  | 1 | V | 1 | 0 |  | 1 | V | 3 | 1 |  | 1 | V | 1 | 0 |  | 1 | V | 1 | 0 |  |  | SHANE
 | CHELSEA | 1 | V | 0 | SWANSEA |  | 2 | V | 0 | 1 |  | 4 | V | 1 | 1 |  | 2 | V | 0 | 1 |  | 3 | V | 0 | 1 |  | 3 | V | 0 | 1 |  |  | CAOLAN
 | EVERTON | 4 | V | 0 | WEST HAM |  | 2 | V | 1 | 1 |  | 2 | V | 2 | 0 |  | 1 | V | 1 | 0 |  | 0 | V | 0 | 0 |  | 1 | V | 1 | 0 |  |  | JENNY
 | MAN CITY | 2 | V | 1 | SOUTHAMPTON |  | 5 | V | 0 | 1 |  | 3 | V | 1 | 1 |  | 4 | V | 0 | 1 |  | 1 | V | 0 | 1 |  | 4 | V | 1 | 1 |  |  | SHAUN
 | STOKE | 0 | V | 3 | LIVERPOOL |  | 2 | V | 1 | 0 |  | 1 | V | 3 | 1 |  | 2 | V | 2 | 0 |  | 1 | V | 1 | 0 |  | 0 | V | 2 | 1
 | BRIGHTON | 0 | V | 0 | PALACE |  | 1 | V | 1 | 1 |  | 1 | V | 2 | 0 |  | 1 | V | 2 | 0 |  | 1 | V | 2 | 0 |  | 1 | V | 2 | 0
 | LEICESTER | 2 | V | 1 | TOTTENHAM |  | 1 | V | 3 | 0 |  | 0 | V | 2 | 0 |  | 0 | V | 2 | 0 |  | 1 | V | 2 | 0 |  | 0 | V | 2 | 0
 | WATFORD | 2 | V | 4 | MAN UTD |  | 1 | V | 2 | 1 |  | 2 | V | 2 | 0 |  | 1 | V | 1 | 0 |  | 0 | V | 2 | 1 |  | 2 | V | 2 | 0
 | WEST BROM | 2 | V | 2 | NEWCASTLE |  | 1 | V | 1 | 1 |  | 0 | V | 1 | 0 |  | 2 | V | 1 | 0 |  | 2 | V | 3 | 0 |  | 0 | V | 1 | 0
 |  |  |  |  |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  |  | TOTAL
Spreadsheet: 38307d1236422479-display-data-in-horizontal-format-task2
Sheet: Sheet2

 | label | carton | bottle | cap | tube | nozzle | tin | can | leaflet | box | pin | syringe
123456 | [NAME] | YYY | ZZZ | AAA
123457 | [NAME] |  |  |  | BBB
123458 |  | YYY | ZZZ |  | BBB | GGG | JJJ | KKK | LLL
123459 |  |  |  |  |  |  |  |  |  | UUU
123460 |  | YYY |  |  | BBB |  |  |  |  |  | CCC | TTT
Spreadsheet: 824420d1680572896-comparing-two-lists-with-multiple-columns-s666-pq-ists-difference
Sheet: Sheet9

Player | Year |  | Goals | Assists
[NAME] | 2016 |  | 29 | 39
Thorton | 2016 |  | 7 | 43
Burns | 2016 |  | 29 | 47
Couture | 2016 |  | 25 | 27
Meir | 2016 |  | 3 | 3
Herti | 2016 |  | 10 | 12
[NAME] | 2017 |  | 22 | 44
Thorton | 2017 |  | 13 | 23
Burns | 2017 |  | 12 | 55
Couture | 2017 |  | 34 | 27
Meir | 2017 |  | 21 | 15
Herti | 2017 |  | 22 | 24
[NAME] | 2018 |  | 23 | 10
Thorton | 2018 |  | 6 | 12
Burns | 2018 |  | 6 | 34
Couture | 2018 |  | 15 | 24
Meir | 2018 |  | 18 | 17
Herti | 2018 |  | 14 | 19
Goals
Player | 2016 | 2017 | 2018
[NAME]
Thorton
Burns
Couture
Meir
Herti
Spreadsheet: 693955d1599227893-return-most-recent-occurrence-in-list-based-on-multiple-array-criteria-return-most-recent-occurrence-in-list-based-on-multiple-array-criteria
Sheet: Sheet1

String | Title | Subchapter | Page | Earliest | Latest
Title001|Subchapter001|Page001 | Title001 | Subchapter001 | Page001 | 3/25/2020 2:43 PM | 3/25/2020 2:43 PM
Title002|Subchapter002|Page002 | Title002 | Subchapter002 | Page002 | 3/25/2020 2:43 PM | 3/27/2020 11:04 AM
Title003|Subchapter003|Page001 | Title003 | Subchapter003 | Page001 | 3/25/2020 2:39 PM | 3/27/2020 10:19 AM
Title004|Subchapter001|Page002 | Title004 | Subchapter001 | Page002 | 3/25/2020 2:39 PM | 3/27/2020 10:19 AM
Title005|Subchapter002|Page003 | Title005 | Subchapter002 | Page003 | 3/25/2020 2:40 PM | 3/27/2020 10:19 AM
Title006|Subchapter003|Page001 | Title006 | Subchapter003 | Page001 | 3/25/2020 2:40 PM | 3/27/2020 11:04 AM
Title007|Subchapter001|Page003 | Title007 | Subchapter001 | Page003 | 3/25/2020 2:40 PM | 3/25/2020 2:40 PM
Title008|Subchapter002|Page001 | Title008 | Subchapter002 | Page001 | 3/25/2020 2:41 PM | 3/27/2020 10:19 AM
Spreadsheet: 769168d1645361080-iferror-index-and-match-return-0-xlsx-test-2
Sheet: Sheet1

Components details
ATR 1 | ATR 1 Value | ATR 2 | ATR 2 Value
Component1 | 8pcs | Component1 | 4pcs
Component2 |  | Component2 | 2pcs
Component3 | 2pcs | Component3 | 2pcs
Component4 |  | Component4 | 4pcs
Component5 | 8pcs | Component5 | 2pcs
Component6 | 4pcs | Component6 | 8pcs
Component7 | 8pcs | Component7 | 4pcs
Component8 |  | Component8
Component9 | 8pcs | Component9 | 8pcs
Component10 | 8pcs | Component10 | 8pcs
Component11 | 4pcs | Component11 | 4pcs
Component12 |  | Component12
Component13 | 8pcs | Component13 | 8pcs
Component14 | 4pcs | Component14 | 4pcs
Component 15 | 8pcs | Component 15 | 8pcs
Spreadsheet: 854717d1704481744-lookup-and-find-the-in-between-days-and-return-number-of-days-20240105
Sheet: Sheet2

ID Number | Date From | Date To | Num Of Days
26827 | 2020-06-10 00:00:00 | 2020-06-15 00:00:00 | 6
26827 | 2020-07-04 00:00:00 | 2020-07-12 00:00:00 | 9
26827 | 2020-08-18 00:00:00 | 2020-08-31 00:00:00 | 14
26827 | 2020-09-01 00:00:00 | 2020-09-23 00:00:00 | 23
26827 | 2020-10-01 00:00:00 | 2020-10-07 00:00:00 | 7
26827 | 2020-10-09 00:00:00 | 2020-10-09 00:00:00 | 1
26827 | 2021-02-01 00:00:00 | 2021-02-28 00:00:00 | 28
26827 | 2021-03-01 00:00:00 | 2021-03-31 00:00:00 | 31
26827 | 2021-04-01 00:00:00 | 2021-04-30 00:00:00 | 30
26827 | 2021-05-01 00:00:00 | 2021-05-31 00:00:00 | 31
26827 | 2021-06-01 00:00:00 | 2021-06-14 00:00:00 | 14
26827 | 2021-08-02 00:00:00 | 2021-08-08 00:00:00 | 7
26827 | 2022-05-14 00:00:00 | 2022-05-18 00:00:00 | 5
26827 | 2022-06-01 00:00:00 | 2022-06-09 00:00:00 | 9
26827 | 2022-08-07 00:00:00 | 2022-08-31 00:00:00 | 25
26827 | 2022-09-01 00:00:00 | 2022-09-04 00:00:00 | 4
26827 | 2022-10-26 00:00:00 | 2022-10-31 00:00:00 | 6
26827 | 2022-11-10 00:00:00 | 2022-11-12 00:00:00 | 3
26827 | 2023-02-01 00:00:00 | 2023-02-06 00:00:00 | 6
26827 | 2023-03-01 00:00:00 | 2023-03-18 00:00:00 | 18
26827 | 2023-05-16 00:00:00 | 2023-05-19 00:00:00 | 4
26827 | 2023-06-01 00:00:00 | 2023-06-05 00:00:00 | 5
26827 | 2023-06-12 00:00:00 | 2023-06-13 00:00:00 | 2
26827 | 2023-11-10 00:00:00 | 2023-11-23 00:00:00 | 14
30617 | 2021-10-06 00:00:00 | 2021-10-20 00:00:00 | 15
30617 | 2021-10-21 00:00:00 | 2021-10-31 00:00:00 | 11
30617 | 2021-11-01 00:00:00 | 2021-11-15 00:00:00 | 15
30617 | 2021-11-16 00:00:00 | 2021-11-30 00:00:00 | 15
30617 | 2021-12-01 00:00:00 | 2021-12-15 00:00:00 | 15
30617 | 2021-12-16 00:00:00 | 2021-12-31 00:00:00 | 16
30617 | 2022-01-17 00:00:00 | 2022-01-31 00:00:00 | 15
30617 | 2022-02-01 00:00:00 | 2022-02-13 00:00:00 | 13
30617 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 15
30617 | 2022-03-01 00:00:00 | 2022-03-10 00:00:00 | 10
30617 | 2022-04-04 00:00:00 | 2022-04-30 00:00:00 | 27
30617 | 2022-05-01 00:00:00 | 2022-05-04 00:00:00 | 4
30617 | 2022-05-05 00:00:00 | 2022-05-15 00:00:00 | 11
30617 | 2022-05-16 00:00:00 | 2022-05-22 00:00:00 | 7
30617 | 2022-12-29 00:00:00 | 2022-12-31 00:00:00 | 3
30617 | 2023-03-13 00:00:00 | 2023-03-15 00:00:00 | 3
30706 | 2021-10-04 00:00:00 | 2021-10-31 00:00:00 | 28
30706 | 2021-11-01 00:00:00 | 2021-11-30 00:00:00 | 30
30706 | 2021-12-01 00:00:00 | 2021-12-31 00:00:00 | 31
30706 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 31
30706 | 2022-02-01 00:00:00 | 2022-02-28 00:00:00 | 28
30706 | 2022-03-01 00:00:00 | 2022-03-31 00:00:00 | 31
30706 | 2022-04-01 00:00:00 | 2022-04-30 00:00:00 | 30
30706 | 2022-05-01 00:00:00 | 2022-05-31 00:00:00 | 31
30706 | 2022-06-01 00:00:00 | 2022-06-13 00:00:00 | 13
Spreadsheet: 816912d1675886922-nested-if-with-vlookup-based-on-a-yes-no-selection-test-for-vlookup-mr-excel-etaf-3
Sheet: Membership List

 | List No | Title | Surname | First Name | Concat | Dining? | Payment Type |  |  |  | Payment type
 | 1 | Mr | Black | [NAME] |  | Yes | BACS Confirmed |  |  |  | BACS Confirmed
 | 2 | Ms | Evans | [NAME] |  | No | BACS TBN |  |  |  | BACS TBN
 | 3 | Mrs | [NAME] | [NAME] |  | Yes | BACS TBN |  |  |  | Card
 | 4 | Mr | Jones | [NAME] |  | Yes | Card
 | 5 | Mr | [NAME] | [NAME] |  | No | Card
 | 6 | Mr | Smith | [NAME] |  | Yes | BACS Confirmed
 | 7 | Miss | [NAME] | [NAME] |  | No | BACS TBN
 | 8 | Ms | Ward | [NAME] |  | Yes | Card
 | 9 | Mrs | White | [NAME] |  | Yes | BACS Confirmed
 | 10 | Mr | Wilson | [NAME] |  | No | Card
Spreadsheet: phillip_m_love__30648__9908_OA
Sheet: TOTAL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - CONSOLIDATED VARIANCE
COMPANY:  ALL
REGION: ALL
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: ff7ff4fe-f8c8-49a3-ae3a-23ac03420f12
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
PHD2 | Test | PHD2 | [NAME] Domain-2 (PHD2/EGLN1) [NAME] | PHD2 Gene, Mutation Analysis, B | Polymerase Chain Reaction (PCR) Amplification/Sanger Sequence Analysis |  |  |  |  |  | Only orderable as part of a profile. For further information see HEMP/61337 Hereditary Erythrocytosis Mutations. | 0.5 mL |  | Only orderable as part of a profile. For further information see HEMP/61337 Hereditary Erythrocytosis Mutations. |  |  |  | 1 | 81479 |  |  |  |  | Rochester
PHD2 | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 30 days
PHD2 | Result | 34646 | PHD2 Gene Sequencing Result | PHD2 Gene Sequencing Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 266693d1379699490-formula-for-value-by-date-and-find-number-count-with-word-on-multiple-sheets-setup-exception-tracking-by-ae-example
Sheet: Robert

Date | Company | Broker | Processor | [NAME]. Last | Loan # (Last 5) | Exception reason | Exceptions | Submissions | Exception %
2013-03-31 00:00:00 |  |  |  |  |  |  | 0 | 47
2013-04-10 00:00:00 | Rob Wolf & Associates | [NAME] | Ophelia Mose | [NAME] | 37628 | missing prelim
2013-04-11 00:00:00 | Rob Wolf & Associates | [NAME] | Ophelia Mose | [NAME] | 37535 | expired prelim
2013-04-23 00:00:00 | Rob Wolf & Associates | [NAME] | Ophelia Mose | Krakower | 38072 | assets expired
2013-04-24 00:00:00 | Guarantee Mortgage | [NAME] | [NAME] | Jimenez | 38241 | assets missing pages | 4 | 94
2013-05-14 00:00:00 | Bay Financial | [NAME] | Darya Gringauz | [NAME] | 38853 | missing paystub for new emp.
2013-05-30 00:00:00 | Rob Wolf & Associates | [NAME] | Ophelia Mose | Pharis | 39245 | missing prelim | 2 | 63
2013-06-10 00:00:00 | Rochex & Rochex | [NAME] | [NAME] | [NAME] | 39475 | missing 2012 W2s
2013-06-17 00:00:00 | Bay Financial | [NAME] | Darya Gringauz | [NAME] | 39629 | missing prelim
2013-06-17 00:00:00 | Bay Financial | Rina Khalfin | Darya Gringauz | Sapirstein | 39668 | missing prelim
2013-06-17 00:00:00 | Bay Financial | Rina Khalfin | Darya Gringauz | Balbon | 39792 | assets missing pages | 4 | 44
2013-07-08 00:00:00 | Guarantee Mortgage | [NAME] | [NAME] | [NAME] | 40010 | missing prelim
2013-07-08 00:00:00 | Guarantee Mortgage | [NAME] | [NAME] | Hahn | 40072 | paystub >30 & assets >45
2013-07-24 00:00:00 | Partner Equity | [NAME] | [NAME] | [NAME] | 40390 | missing 2012 W2s
2013-07-29 00:00:00 | Ella Financial, Inc. | [NAME] | [NAME] | [NAME] | 40375 | missing prelim | 4 | 44
2013-08-21 00:00:00 | All Homes Financial, Inc. | [NAME] | [NAME] | [NAME] | 40914 | credit & prelim  >45
2013-08-23 00:00:00 | Guarantee Mortgage | [NAME] | [NAME] | Martinez | 40934 | assets >45 | 2 | 25
2013-09-05 00:00:00 | Guarantee Mortgage | [NAME] | [NAME] | Lyon | 41086 | Assets & Credit >45
2013-09-11 00:00:00 | Bay Financial | Rina Khalfin | Darya Gringauz | [NAME] | 41224 | missing asset stmt