tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 868411d1715160491-multiple-similar-cells-but-only-polular-the-first-new_sample
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  | Expected result |  |  |  |  |  | My formula (not working)
 | Project Name | Function | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 |  | Factor |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00
 | project A | PD IND GPDM Function | 4 | 0 | 0 | 0 | 0.25 |  | 120 |  | 4 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | How formula should work
 | project A | Global PIM | 4 | 0 | 0 | 0 | 0.1 |  | 127 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1)'If EOMonth < today return the first value to first cell when project name appears
 | project A | PD IND GPDM Function | 4 | 0 | 0 | 0 | 0.1 |  | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2) rest of the formula works (Factor*value in month)
 | project A | IND Global Programs | 4 | 0 | 0 | 0 | 0.25 |  | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3) If Function = Quality then numbers on that line are not allowed.
 | project A | Global PIM | 4 | 0 | 0 | 0 | 0.2 |  | 127
 | project A | Plants | 4 | 0 | 0 | 0 | 1 |  | 127
 | project A | PD IND D and D | 4 | 0 | 0 | 0 | 2 |  | 127
 | project A | PD IND D and D | 4 | 0 | 0 | 0 | 2 |  | 127
 | project A | PD IND D and D | 4 | 0 | 0 | 0 | 3 |  | 127
 | project A | PD IND D and D | 4 | 0 | 0 | 0 | 0.2 |  | 127
 | project A | PD IND D and D | 4 | 0 | 0 | 0 | 0.2 |  | 127
 | project A | PD IND D and D | 4 | 0 | 0 | 0 | 0 |  | 127
 | project A | PD IND D and D | 4 | 0 | 0 | 0 | 0.5 |  | 132
 | project A | PD IND D and D | 4 | 0 | 0 | 0 | 1 |  | 127
 | project A | GTI Digital Development | 4 | 0 | 0 | 0 | 1 |  | 127
 | project A | GTI Digital Development | 4 | 0 | 0 | 0 | 1 |  | 120
 | project A | GTI Digital Development | 4 | 0 | 0 | 0 | 0.1 |  | 120
 | project A | PD IND Dosing and Disinfection | 4 | 0 | 0 | 0 | 0.4 |  | 189
 | project A | PD IND Dosing and Disinfection | 4 | 0 | 0 | 0 | 0.2 |  | 127
 | project A | GTI Software Development | 4 | 0 | 0 | 0 | 0.2 |  | 127
 | project A | PD IND Dosing and Disinfection | 4 | 0 | 0 | 0 | 0.2 |  | 120
 | project A | PD IND D and D | 4 | 0 | 0 | 0 | 0.2 |  | 127
 | project A | PD IND D and D | 4 | 0 | 0 | 0 | 2 |  | 120
 | project b | Quality | 16.5 | 11 | 3 | 0 | 0 |  | 120
 | project b | PD IND Dosing and Disinfection | 16.5 | 11 | 3 | 0 | 0 |  | 120 |  | 16.5 | 11 | 3 | 0 | 0
 | project b | GTI Software Development | 16.5 | 11 | 3 | 0 | 0 |  | 120
 | project b | PD IND Dosing and Disinfection | 16.5 | 11 | 3 | 0 | 0 |  | 120
 | project b | PD IND Dosing and Disinfection | 16.5 | 11 | 3 | 0 | 0 |  | 120
 | project b | GTI Software Development | 16.5 | 11 | 3 | 0 | 0 |  | 120
 | project b | PD IND Dosing and Disinfection | 16.5 | 11 | 3 | 0 | 0 |  | 189
 | project b | PD IND Dosing and Disinfection | 16.5 | 11 | 3 | 0 | 0 |  | 128
Spreadsheet: 819390d1677488067-unique-filter-formula-automatically-getting-converted-into-an-array-formula-in-o365-test_file_forum_2
Sheet: WEEKLY DETAILS

 |  | WEEKLY FEEDBACK DETAILS FROM |  | 02/16/2023 | TO | 02/23/2023
[NAME] | USER'S NAME | USER'S EMAIL | USER'S ORGANIZATION | USER'S ROLE | USER FEELS | USER IS ON PAGE | FEEDBACK SUBMITTED | SUBMITTED ON
1 | Shivam Sri | [EMAIL] | ShivamOrg | System Administrator | 1 | trytrytrytrutrurtu | fsdfsdgretryrt | 02/14/2023 06:54:27 (GMT)
2 | Shivam Sri | [EMAIL] | ShivamOrg | SystemAdministrator | 1 | TESTYY | RTGHJHJJJJJJ | 02/20/2023 10:22:56 (GMT)
3 | [NAME] | [EMAIL] | supriya | SystemAdministrator | 1 | License Details | hshhgdggg     jhhhggg  <br/><br/>ndvv | 02/21/2023 08:21:31 (GMT)
4 | [NAME] | [EMAIL] | supriya | SystemAdministrator | 1 | Licenses | jfhfhhfhffhh     <br/>jgkjgjj<br/>bvhn | 02/21/2023 11:40:39 (GMT)
Spreadsheet: 6fda1691-caa0-4b2e-aa5e-d1c6330d8fa7
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
CINP | Test | CINP | Cortisol, Serum, LC-MS/MS | Cortisol, S, LC-MS/MS | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 0.6 | mL | Container/Tube: Red top [NAME]: 0.6 mL Collection Instructions: Morning (8 a.m.) and afternoon (4 p.m.) specimens are preferred. Additional Information: 1. Include time of draw. 2. If multiple specimens are drawn, send separate order for each specimen. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	Serum gel tube | 5-25 mcg/dL (a.m.) 2-14 mcg/dL (p.m.) Pediatric reference ranges are the same as adults, as confirmed by peer-reviewed literature.   Petersen KE: ACTH in normal children and children with pituitary and adrenal diseases. [NAME] in plasma by radioimmunoassay-basal values. Acta Paediatr Scand 1981;70:341-345 | Monday through Friday; 2 p.m. | 2 days | 5 days | 1 | 82533 |  |  |  |  | Rochester
CINP | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 7 days
CINP | Order Question | COLT2 | Collection Time in Military Time |  | Plain Text
CINP | Result | 84279 | Cortisol, S, LC-MS/MS | Cortisol, S, LC-MS/MS | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 2143-6 | Cortisol:MCnc:Pt:Ser/Plas:Qn:
CINP | Result | 23606 | AM Cortisol | AM Cortisol | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 9813-7 | Cortisol^morning:MCnc:Pt:Ser/Plas:Qn:
CINP | Result | 23607 | PM Cortisol | PM Cortisol | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 9812-9 | Cortisol^evening:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 10a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated net notional amount outstanding, February 15 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 538177d1505437810-pulling-unique-data-from-a-table-a-certain-number-of-times-advanced-interpretting-data-1-
Sheet: Nathan's Table

Row Labels
[NAME]
247 - Dixon Stage 5
08-Other
247 - Dixon Stage 5 Total
250 - 132 Kay Rd Subdivision
02-Roading
03-Stormwater
250 - 132 Kay Rd Subdivision Total
252 - Kay Rd Cutdown
03-Stormwater
252 - Kay Rd Cutdown Total
Adam Young Total
[NAME]
001 - Office
08-Other
001 - Office Total
247 - Dixon Stage 5
08-Other
247 - Dixon Stage 5 Total
250 - 132 Kay Rd Subdivision
02-Roading
03-Stormwater
08-Other
250 - 132 Kay Rd Subdivision Total
253 - 116 Kay Rd Subdivision
(blank)
253 - 116 Kay Rd Subdivision Total
[NAME]
[NAME]
250 - 132 Kay Rd Subdivision
06-Concrete
08-Other
250 - 132 Kay Rd Subdivision Total
252 - Kay Rd Cutdown
02-Roading
07-Environmental
08-Other
252 - Kay Rd Cutdown Total
[NAME]
Jury [NAME]
250 - 132 Kay Rd Subdivision
02-Roading
03-Stormwater
250 - 132 Kay Rd Subdivision Total
250 [NAME]
(blank)
250 Kay Rd Subd Total
252 - Kay Rd Cutdown
02-Roading
07-Environmental
252 - Kay Rd Cutdown Total
Jury Herewini Total
[NAME]
250 - 132 Kay Rd Subdivision
02-Roading
250 - 132 Kay Rd Subdivision Total
[NAME]
Spreadsheet: 79281d1279561629-disappearing-info-advanced-filters-running-down-the-page-with-macro-new-cost-centre-rev2
Sheet: Q1306

Cost Centre | Activity Code
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1306 | 303 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A
Spreadsheet: 179420d1347254592-return-latest-date-from-cell-containing-several-dates-latestdateonly
Sheet: Sheet1

ACTUAL DELIVERY DATE
2012-07-02 00:00:00
2012-07-02 00:00:00
12/06/2012, 15/06/2012 & 05/07/2012
15/06/2012 & 05/07/2012
2012-07-02 00:00:00
2012-07-18 00:00:00
2012-07-18 00:00:00
2012-07-23 00:00:00
2012-07-05 00:00:00
5/07/2012 & 31/07/2012
5/07/2012 & 14/08/2012
2012-07-31 00:00:00
2012-07-23 00:00:00
2012-07-18 00:00:00
2012-06-19 00:00:00
2012-07-06 00:00:00
2012-07-06 00:00:00
19/06/2012 & 23/06/2012
2012-05-10 00:00:00
Spreadsheet: darrell_schoolcraft__7844__Griffith1001
Sheet: PPL-OBA

Citizens Arizona Gas |  |  |  |  |  |  |  | Customer: | PP&L
Balance Tracking Report |  |  |  | Month:
 | Transwestern Lateral |  |  |  |  |  |  | El Paso Lateral |  |  |  |  |  |  | Total
 |  |  |  |  | Imbalance |  |  |  |  |  |  | Imbalance |  |  |  |  | Imbalance
 | Alloc. Del. | Oper. Alloc. | Total Alloc. | Scheduled | Daily | Cummulative |  | Alloc. Del. | Oper. Alloc. | Total Alloc. | Scheduled | Daily | Cummulative |  | Alloc. Del. | Scheduled | Daily | Cummulative
Day | Dth | Dth | Dth | Dth | Dth | Dth |  | Dth | Dth | Dth | Dth | Dth | Dth |  | Dth | Dth | Dth | Dth
Beginning Bal. |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
1
Total
(+due Pipeline/-due PPL)
Spreadsheet: 125802d1319219881-excel-2007-pivot-table-sample-workbook
Sheet: Data

Checked | Sent | Contact | Company | [NAME] | View | Last Read | Read Count | Title | Researcher | Reports Released
True | 2011-09-30 09:57:14 | Contact 1 | Company 1 | Email 1 | View | 9/30/2011 10:06:07 AM | 1 | Report1 | Anon | 4
True | 2011-09-30 10:03:29 | Contact 1 | Company 1 | Email 1 | View | 9/30/2011 10:05:45 AM | 1 | Report 2 | Anon | 4
True | 2011-09-30 09:53:49 | Contact 1 | Company 1 | Email 1 | View | 9/30/2011 10:06:26 AM | 1 | Report 4 | Anon | 4
True | 2011-09-30 10:09:58 | Contact 1 | Company 1 | Email 1 | View | 9/30/2011 10:43:30 AM | 1 | Report 3 | Anon | 4
True | 2011-09-30 09:57:14 | Contact 2 | Company 2 | [NAME] | View | 9/30/2011 9:41:19 PM | 2 | Report1 | Anon | 4
True | 2011-09-30 09:53:49 | Contact 2 | Company 2 | [NAME] | View | 9/30/2011 11:12:32 AM | 2 | Report 4 | Anon | 4
True | 2011-09-30 10:09:58 | Contact 2 | Company 2 | [NAME] | View | 9/30/2011 7:49:34 PM | 4 | Report 3 | Anon | 4
True | 2011-09-30 10:03:29 | Contact 3 | Company 3 | [NAME] | View | 9/30/2011 10:23:46 AM | 1 | Report 2 | Anon | 4
True | 2011-09-30 09:57:14 | Name1 | Company 4 | Email4 | View | 9/30/2011 10:15:37 AM | 1 | Report1 | Anon | 4
True | 2011-09-30 10:03:29 | Name1 | Company 4 | Email4 | View | 9/30/2011 10:15:33 AM | 1 | Report 2 | Anon | 4
True | 2011-09-30 09:53:49 | Name1 | Company 4 | Email4 | View | 9/30/2011 10:15:37 AM | 1 | Report 4 | Anon | 4
True | 2011-09-30 10:03:29 | [NAME] | Company 8 | Email8 | View | 9/30/2011 10:10:41 AM | 1 | Report 2 | Anon | 4
True | 2011-09-30 09:53:49 | [NAME] | Company 8 | Email8 | View | 9/30/2011 9:58:30 AM | 1 | Report 4 | Anon | 4
True | 2011-09-30 10:09:58 | [NAME] | Company 8 | Email8 | View | 9/30/2011 10:30:07 AM | 1 | Report 3 | Anon | 4
True | 2011-09-30 10:03:29 | Name3 | Company 9 | Email3 | View | 9/30/2011 10:05:21 AM | 1 | Report 2 | Anon | 4
True | 2011-09-30 10:09:58 | Name4 | Company 10 | Email4 | View | 9/30/2011 10:35:15 AM | 1 | Report 3 | Anon | 4
True | 2011-09-30 10:03:29 | Name5 | Company 5 | Email5 | View | 9/30/2011 12:42:55 PM | 2 | Report 2 | Anon | 4
True | 2011-09-30 09:57:14 | Name 6 | Company 6 | Email6 | View | 9/30/2011 9:58:41 AM | 1 | Report1 | Anon | 4
True | 2011-09-30 10:03:29 | Name 6 | Company 6 | Email6 | View | 9/30/2011 10:32:43 AM | 1 | Report 2 | Anon | 4
True | 2011-09-30 09:53:49 | Name 6 | Company 6 | Email6 | View | 9/30/2011 9:57:30 AM | 1 | Report 4 | Anon | 4
True | 2011-09-30 10:09:58 | Name 6 | Company 6 | Email6 | View | 9/30/2011 10:32:38 AM | 1 | Report 3 | Anon | 4
True | 2011-09-30 09:57:14 | Contact A | Company 1 | Email A | View | 9/30/2011 10:06:07 AM | 1 | Report1 | Anon | 4
True | 2011-09-30 10:03:29 | Contact A | Company 1 | Email A | View | 9/30/2011 10:05:45 AM | 1 | Report 2 | Anon | 4
Spreadsheet: 1dbfaa87-4b0b-47cd-b592-14eec685be6e
Sheet: Sheet1

Record Type | [NAME] | Element ID | Element | Format | Vendor Default | Min Len | [NAME] | [NAME] | Dict  Page
TH | 1 | [NAME] | Record Type | Alpha | No Default | 2 | 2 | Will be the literal string "TH" | 125
TH | 2 | [NAME] | Date Stamp | Date | No Default | 10 | 10 |  | 121
TH | 3 | H0020 | Time Stamp | Time | No Default | 8 | 8 |  | 129
TH | 4 | H0030 | Transmission ID | Alpha | No Default | 1 | 10 |  | 130
TH | 5 | H0050 | File Version | Alpha | No Default | 3 | 4 | Will be the literal string "1.0" for State ID file. | 123
TH | 6 | H0060 | Delimiter | Alpha | No Default | 14 | 14 | Will be the literal string "delimiter=0x09" | 122
ID | 1 | [NAME] | Record Type | Alpha | No Default | 2 | 2 | Will be the literal string "ID" | 125
ID | 2 | [NAME] | School Number | Alpha | No Default | 4 | 4 |  | 20
ID | 3 | D0200 | Resident District | Alpha | No Default | 4 | 4 |  | 30
ID | 4 | D0080 | Student Last Name | Alpha | No Default | 1 | 60 |  | 1
ID | 5 | D0060 | Student First Name | Alpha | No Default | 1 | 60 |  | 2
ID | 6 | D0070 | Student Middle Name | Alpha | No Default | 1 | 60 |  | 3
ID | 7 | D0090 | Student Suffix | Alpha | No Default | 1 | 10 |  | 4
ID | 8 | D0050 | Gender | Alpha | No Default | 1 | 1 |  | 6
ID | 9 | D0020 | Birth Date | Date | No Default | 10 | 10 |  | 5
ID | 10 | [NAME] | Grade Level | Alpha | No Default | 2 | 2 |  | 17
ID | 11 | D0010 | Local Student ID | Alpha | No Default | 1 | 20 |  | 15
ID | 12 | D0160 | Social Security Number | Numeric | No Default | 9 | 9 |  | 14
ID | 13 | D0035 | Race/Ethnicity_StateID | Alpha | No Default | 1 | 1 |  | 133
ID | 14 | K0020 | State Student ID | Numeric | No Default | 10 | 10 | For file inbound to the state, this field may be null.  For outbound file from the state, this field will be the State Student ID. | 16
ID | 15 | D0203 | Attending District | Alpha | No Default | 4 | 4 |  | 132
ID | 16 | [NAME] | Current School Year | Numeric | No Default | 4 | 4 |  | 120
TT | 1 | [NAME] | Record Type | Alpha | No Default | 2 | 2 | Will be the literal string "TT" | 125
TT | 2 | H0030 | Transmission ID | Alpha | No Default | 1 | 10 | Must match H0030 in the Transmission Header | 130
TT | 3 | H0040 | Number of Records | Numeric | No Default | 1 | 10 | The total count of records in the transmission, including the Transmission Header and Trailer records. | 124
Spreadsheet: chris_germany__2119__DecCohCHOICE-ENA
Sheet: Dec 1

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  | 1 |  | December
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1197 |  |  |  | 67694 | 0.33 |  |  |  |  | x | 1 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | 2 | x
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 4301 |  | [NAME] |  | 67694 | 0.9 |  |  |  |  | x | 3 | x
 |  |  |  |  |  |  |  |  | 5000 |  | [NAME] |  | 68918 | 0 |  |  |  |  | x | 4 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | 5 | x
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 1544 |  |  |  | 67694 | 1 |  |  |  |  | x | 6 | x
 |  |  |  |  |  |  |  |  | 1535 |  | [NAME] |  | 68915 | 0 |  |  |  |  | x | 7 | x
 |  |  |  |  |  |  |  |  | 1540 |  | [NAME] |  | 69693 | 0 |  |  |  |  | x | 8 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | 9 | x
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 12285 |  |  |  | 67694 | 0.75 |  |  |  |  | x | 15 | x
 |  |  |  |  |  |  |  |  | 673 |  | Maumee | x | 61837 | 0 |  |  |  |  | x | 35 | x
 |  |  |  |  |  |  |  |  | 0 |  | Crossroads |  | 68915 | 0 |  |  |  |  | x | 39 | x
 |  |  |  |  |  |  |  |  | 0 |  | Crossroads |  | 68918 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1218 |  |  |  | 67694 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 993 |  |  |  | 67694 | 1 |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | [NAME] |  | 61837 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 12192 |  |  |  | 67694 | 0.6
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 1723 |  |  |  | 67694 | 0.7
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4039 |  |  |  | 67694 | 0.33
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 3619 |  |  |  | 67694 | 0.45
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 586 |  |  |  | 67694 | 0.55
 |  |  |  |  |  |  |  |  | 1000 |  | [NAME] |  | 69823
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 41 |  |  |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA
Spreadsheet: 220999d1363346640-vlookup-or-other-tools-to-retun-more-than-1-match-from-2-criteria-sample4
Sheet: Sheet1

City | A
 | Type |  |  |  |  | Model | Result
 | C |  |  |  |  | 12 | 24
 | Select |  |  |  |  | 4 | 24 | while it should be 12
 | Select |  |  |  |  | 6 | 24 | while it should be 12
 |  |  |  |  |  | 8 | 24 | while it should be a list of 24 and 48
 |  |  |  |  |  | 12 | 24
 |  |  |  |  |  | 12 | 24
 |  |  |  |  |  | 12 | 24
 |  |  |  |  |  | 12 | 24
 |  |  |  |  |  | 12 | 24
 |  |  |  |  |  | 12 | 24
Spreadsheet: eric_saibi__9834__100201
Sheet:  Huntington Beach 01

Owner Name | AES Huntington Beach LLC
Station Name | Huntington Beach Power Station
Unit Name | Huntington Beach 01
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas
Capacity | 218 MW
Start Date | 2001-10-02 00:00:00
End Date | 2001-10-06 00:00:00
Comments | Problems with pumps, testing unit.
SIC | 4931
Plant ID | 1013155
Unit ID | 1006119
Outage ID | 18562
Spreadsheet: 853584d1703461988-list-all-values-that-begin-with-a-specific-letter-logbook2
Sheet: list boulders

List boulders at grade | 7a+ | # |  |  |  | List boulders at | Grampians |  |  | Font' boulders at | Cuisinière | # |  |  |  |  | other bouldering |  |  |  | fontainebleau
 | date | sector | area |  |  |  | sector |  |  |  |  |  |  |  |  |  | list areas |  | list sectors |  | font alphabetically
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95.2 Ouest
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont Bizons
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont Butte aux Dames
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont Désert
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont Envers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont Est
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont Haut des Gorges
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont Mare aux Biches
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont Marie-Thérèse
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont Ouest
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont Portes du Désert
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apremont Vallon de la Solitude
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boissy aux Cailles (HA)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boissy Château Renard (HA)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boissy Le Goulot
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boissy Le Plaid (HA)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 265343d1379201567-inserting-table-rows-from-another-file-2010-wine
Sheet: Whites

2010 Vintage Year - White Wines
 |  | Tracking Data
 |  | Category 1 |  |  | Category 2 |  |  | Category 3 |  |  | Category 4 |  |  | Category 5 |  |  | Category 6
Appellation | Wine | Element 1 | Element 2 | Element 3 | Element 4 | Element 5 | Element 6 | Element 7 | Element 8 | Element 9 | Element 10 | Element 11 | Element 12 | Element 13 | Element 14 | Element 15 | Element 16 | Element 17 | Element 18 | Comments
Central Coast, CA | Central Coast C1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Central Coast, CA | Central Coast C2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Central Coast, CA | Central Coast C3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Central Coast, CA | Central Coast C4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Needs to be Moved from 2010 to 2011 File
Central Coast, CA | Central Coast C5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Napa, CA | Napa N1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Napa, CA | Napa N2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Napa, CA | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Needs to be Moved from 2010 to 2011 File
Sonoma, CA | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Sonoma, CA | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Needs to be Moved from 2010 to 2011 File
Sonoma, CA | Sonoma S3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Sonoma, CA | Sonoma S4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Sonoma, CA | Sonoma S5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Already in both 2010 & 2011 Files - No Action Needed
Spreadsheet: 214856d1361157492-nested-if-function-bsbitu402a-part-b-task-1-1-
Sheet: Weekly Time Sheet

Bobs Building Services
Weekly Time Sheet
Employee Name:
Payroll period commencing: |  |  | 2013-01-28 00:00:00
Payroll period ending:
Day | Date | Start Time: | Lunch Break: | Finish Time: | Total Hours | Ordinary  Hours | Overtime | T 1/2 | DT
Monday |  | 07:30:00 | 00:30:00 | 16:00:00
Tuesday |  | 07:30:00 | 00:30:00 | 16:00:00
Wednesday |  | 07:30:00 | 00:30:00 | 16:00:00
Thursday |  | 07:30:00 | 00:30:00 | 16:00:00
Friday |  | 07:30:00 | 00:30:00 | 16:00:00
Saturday |  | 08:00:00 | 00:00:00 | 16:00:00
Total