tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 781646d1653463236-calculate-time-of-arrival-with-if-condition-based-on-departure-test
Sheet: TIP

 |  |  |  |  | 01:30:00 | 00:30:00 | 02:00:00
Concat | Date | Departure | Destination | Truck nr | Planned hr for truck to arrive | Plannedhr to load | Start load | [NAME] | Planned hr of departure | Delays | Delivery Window | Delivery Window +Delays | Finished load F&V | Finished Load CHILL | [NAME] | Departure hr | Nr of pallets | PALETI L&F | PALETI CIOCO | PALETI FLORI | PALETI CHILL | CONTAINER PESTE | PALETI CONG. | Nr of hr from C to D | Estimated hr of arrival to store | Status             (In Time/Delay) | SIGILII |  |  |  |  |  |  |  |  | ORE Cuplaj | ORE Bacau | ORA Brasov1 | ORA Cluj | ORA Sibiu | ORA Pitesti | ORA Ploiesti | ORA Oradea | ORA Constanta1 | ORA Timisoara1 | ORA Iasi | ORA Tg Mures | ORA [NAME] | ORA Brasov2 | ORA Constanta2 | ORA Militari | ORA Baneasa | ORA Berceni | ORA Voluntari | ORA Timisoara2 | ORA Arad | ORA TimisoaraR | ORA ConstantaR | ORA OradeaR | ORA SibiuR | ORA Tg MuresR | ORA BrasovR | Ora Craiova | Ora CraiovaR | Ore Satu MareR | Ore Baia Mare | Ore Baia MareR | Ore Pan VitanR | Ore GalatiR | Ore Suceava | Ore TimisoaraR2 | Ore BerceniR | Ore ClujR | Ore DevaR | Ore BacauR | Ore Deva | Ore AradR | Ore OradeaR2 | Ore PitestiR | Ore SuceavaR | Ore ConstantaR2 | Ore TimisoaraR3 | Ore PloiestiR | Ore Policolor | Ore PolicolorR | Ore Satu Mare Punct
 |  | BAIA MARE | SATU MARE | B400TBL | 11:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 12:30:00 | 00:00:00 | 00:00:00
 |  | CAMPUS CALAN | BAIA MARE | B400TBL | 11:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 12:30:00 | 00:00:00 | 00:00:00
 |  | CAMPUS CALAN | [NAME] | B401TBL | 11:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 12:30:00 | 00:00:00 | 00:00:00
 |  | CAMPUS CALAN | TG.MURES ISTORIC | B402TBL | 11:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 12:30:00 | 00:00:00 | 00:00:00
 |  | [NAME] | [NAME] | B403TBL | 12:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 13:30:00 | 00:00:00 | 00:00:00
 |  | CAMPUS CALAN | [NAME] | B403TBL | 14:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 15:30:00 | 00:00:00 | 00:00:00
 |  | CAMPUS CALAN | TG.MURES [NAME] | B404TBL | 14:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 15:30:00 | 00:00:00 | 00:00:00
 |  | CAMPUS CALAN | ORADEA | B405TBL | 13:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 14:30:00 | 00:00:00 | 00:00:00
 |  | CAMPUS CALAN | CLUJ NORD | B406TBL | 15:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 16:30:00 | 00:00:00 | 00:00:00
 |  | CAMPUS CALAN | CLUJ ISTORIC | B407TBL | 16:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 17:30:00 | 00:00:00 | 00:00:00
 |  | CAMPUS CALAN | [NAME] | B408TBL | 17:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 18:30:00 | 00:00:00 | 00:00:00
 |  | CAMPUS CALAN | BUZIAS | B409TBL | 21:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 22:30:00 | 00:00:00 | 00:00:00
 |  | CAMPUS CALAN | TURDA | B410TBL | 21:00:00 |  | 00:00:00 | 00:00:00 |  |  |  |  | 22:30:00 | 00:00:00 | 00:00:00
Spreadsheet: 882388d1730781624-req-formula-to-get-dynamic-headers-dynamic-headers
Sheet: Header

Service Reqest | Number | Short description | Assigned to | Assignment group | Opened Date | Priority | State | SLA end time | SLA time left | Opened by
Incident | Number | Description | Assigned Person | Assignment group | Created on Date | Priority | State | SLA end time | SLA time left | Opened by | Parent
Spreadsheet: 869760d1716338412-filter-based-on-value-pulling-data-to-new-worksheet-but-need-row-added-deleted-as-well-workbook-1
Sheet: Current Patients

Patient Last Name | Patient First Name | Notes | Benefits Verified | Copay/CoIns/Payment Plan | CCX | Primary Ins Group Name
 | D |  | X |  | X
B | E |  | X |  | X
X | Y |  | X |  | X
Spreadsheet: 64344d1265214028-a-list-within-an-if-statement-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Cable tray, ladder system, cleats, wire mesh tray | installstep24d1aa
 |  |  |  |  |  |  |  |  |  |  |  | In conduit | installstep24d1ab
 |  |  |  |  |  |  |  |  |  |  |  | In trunking/ducting (reference B) | installstep24d1ac
 |  |  |  |  |  |  |  |  |  |  |  | Direct in wall. Ceiling void | installstep24d1ad
 |  |  |  |  |  |  |  |  |  |  |  | On, or spaced from, wall of ceiling | installstep24d1ae
 |  |  |  |  |  |  |  |  |  |  |  | In moulding, architrave or window frame | installstep24d1af
 |  |  |  |  |  |  |  |  |  |  |  | Miscellaneous | installstep24d1ag
 |  |  |  | step 1 | On, or spaced from, wall of ceiling
 |  |  |  | step 2
 |  |  |  |  |  |  |  |  |  |  |  |  | installstep24d1aa | installstep24d1ab | installstep24d1ac | installstep24d1ad | installstep24d1ae | installstep24d1af | installstep24d1ag
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | a | zz1 | b`1 | s1 | r1 | d1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | b | zz2 | b`2 | s2 | r2 | d2
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | c | zz3 | b`3 | s3 | r3 | d3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | d | zz4 | b`4 | s4 | r4 | d4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | e | zz5 | b`5 | s5 | r5 | d5
Spreadsheet: 67507d1268132317-rearrange-data-book5
Sheet: Sheet1

 | Data at present
 | 001-Product A
 |  | 1000-Product AA
 |  |  | 100-Product AA1
 |  |  | 101-Product AA2
 |  |  | 102-Product AA3
 |  | 2000-Product AB
 |  |  | 200-Product AB1
 |  |  | 201-Product AB2
 |  |  | 203-Product AB3
 | Desired Data
 | 001-Product A | 1000-Product AA | 100-Product AA1
 |  |  | 101-Product AA2
 |  |  | 102-Product AA3
 |  | 2000-Product AB | 200-Product AB1
 |  |  | 201-Product AB2
 |  |  | 203-Product AB3
Spreadsheet: 786865d1657520506-formula-to-find-the-multiple-values-and-consolidate-in-new-row-consolidatemultiplelines
Sheet: Expected Result

 |  |  | ExpectedResult | [NAME]
Chars. | Task | Value | NewCol. |  |  |  | DD |  |  |  | DD
SKA1 | AA | TK01 |  |  |  | SKA1 | GG |  |  | SKA1 | DD
SKA1 | BB | TE22 |  |  |  | [NAME] | DD |  |  | SKA1 | GG
SKA1 | CC | VK10 |  |  |  | [NAME] | GG |  |  | SKA1 | GG
SKA1 | DD | AS11 | AS11, AS26 |  |  | SKT2 | DD |  |  | SKA1 | GG
SKA1 | DD | AS26 | AS11, AS26 |  |  | SKT2 | GG |  |  | SKA1 | GG
SKA1 | EE | BA01 |  |  |  |  |  |  |  | [NAME] | DD
SKA1 | FF | BA02 |  |  |  |  |  |  |  | [NAME] | DD
SKA1 | GG | 122 | 122, 340, 520, 540 |  |  |  |  |  |  | [NAME] | DD
SKA1 | GG | 340 | 122, 340, 520, 540 |  |  |  |  |  |  | [NAME] | GG
SKA1 | GG | 520 | 122, 340, 520, 540 |  |  |  |  |  |  | [NAME] | GG
SKA1 | GG | 540 | 122, 340, 520, 540 |  |  |  |  |  |  | SKT2 | DD
SKA1 | HH |  |  |  |  |  |  |  |  | SKT2 | GG
SKA1 | II
SKA1 | JJ
SKA1 | KK
SKA1 | LL
SKA1 | MM
SKA1 | NN
SKA1 | OO
SKA1 | PP
SKA1 | QQ
SKA1 | RR
SKA1 | SS
SKA1 | TT
SKA1 | UU
[NAME] | DD | AS22 | AS22, AS54,, AS59
[NAME] | DD | AS54 | AS22, AS54,, AS59
[NAME] | DD | AS59 | AS22, AS54,, AS59
[NAME] | EE
[NAME] | FF
[NAME] | GG | 220 | 220, 260
[NAME] | GG | 260 | 220, 260
[NAME] | HH
[NAME] | II
[NAME] | JJ
[NAME] | KK
[NAME] | LL
SKT2 | DD | AS19 | AS19
SKT2 | EE
SKT2 | FF
SKT2 | GG | 740 | 740
SKT2 | HH
SKT2 | II
SKT2 | JJ
SKT2 | KK
SKT2 | LL
Spreadsheet: john_forney__15551__ERCOT DATA v3 Balancing
Sheet: NERC HOLIDAYS

2000 NERC Holidays
Date
1999-01-01 00:00:00 |  |  |  |  | =IF(#REF!=(VLOOKUP(#REF!,Holidays,1,TRUE)),"Hol",#REF!)
1999-05-31 00:00:00
1999-07-05 00:00:00
1999-09-06 00:00:00
1999-11-25 00:00:00
1999-12-25 00:00:00
2000-01-01 00:00:00
2000-05-29 00:00:00
2000-07-04 00:00:00
2000-09-04 00:00:00
2000-11-23 00:00:00
2000-12-25 00:00:00
2001-01-01 00:00:00
2001-05-28 00:00:00
2001-07-04 00:00:00
2001-09-03 00:00:00
2001-11-22 00:00:00
2001-12-25 00:00:00
2002-01-01 00:00:00
2002-05-27 00:00:00
2002-07-04 00:00:00
2002-09-02 00:00:00
2002-11-28 00:00:00
2002-12-25 00:00:00
2003-01-01 00:00:00
2003-05-26 00:00:00
2003-07-04 00:00:00
2003-09-01 00:00:00
2003-11-27 00:00:00
2003-12-25 00:00:00
2004-01-01 00:00:00
2004-05-31 00:00:00
2004-07-05 00:00:00
2004-09-06 00:00:00
2004-11-25 00:00:00
2004-12-25 00:00:00
2005-01-01 00:00:00
2005-05-30 00:00:00
2005-07-04 00:00:00
2005-09-05 00:00:00
2005-11-24 00:00:00
2005-12-25 00:00:00
Spreadsheet: 856712d1705924113-more-troublesome-ifs-ands-and-ors-good-job-im-already-bald-vanity-hall-doors-jan-2024-issue-2
Sheet: Quote Sheet

 |  |  |  |  | Date:
 |  |  |  |  | Retailer/Studio: |  | Studio/Installer |  |  | Account Ref:
 | Make your selection by using the drop down lists below |  |  |  | Client/PO Ref:
 | Range (Select from List): |  | Colour: | Paint-to-Order? |  | PTO Colours have 4-6wk lead-time and are subject to additional charges
 | Choose Range |  | Choose Paint Colour
 | Door Description: |  | SKU: |  | Price Per Unit (inc VAT): |  | Quantity: | Total:
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 | *Leave this line if unused*
 |  |  |  |  |  |  | Sub-total:
 |  |  |  |  |  |  | PTO Charge:
 |  |  |  |  |  |  | Total (inc VAT):
 | Prices are valid for 30-days only from the date submitted, and confirmed received by Vanity Hall. We cannot be held responsible if the incorrect panels have been ordered once returned to retailer for confirmation. Doors, [NAME] and other items are non-returnable unless damaged and return agreed by Vanity Hall. |  |  |  |  |  | Total (inc VAT) Less Discount:
 |  |  |  |  |  |  | Total Payable (ex VAT):
Spreadsheet: 490024d1479583392-generate-invoicing-reports-from-rota-for-multiple-sites-example-rota-and-invoice-sheet
Sheet: rota

WC 21/11/2016
 | SITE 1 | SITE 2 | SITE 3 | SITE 4 | SITE 5
Monday 21st am | SQ/MM |  | JDS/CT | BMN/JC | VP/KD
Monday 21st pm | SQ/MM |  | JDS/CT | BMN/JC | VP/KD
Tuesday 22nd am |  | JDS/CT |  | DW-ADMIN | TB/JC
Tuesday 22nd pm |  | JDS/CT |  | DW-ADMIN | TB/JC
Wednesday 23rd am | SQ/JC |  | JDS/CT | BL/DW | TB/AM
Wednesday 23rd pm | SQ/JC |  | JDS/CT | BL/DW | TB/AM
Thursday 24th am | BL/JC | SJM/CT
Thursday 24th pm | BL/JC | SJM/CT
Friday 25th am | SQ/JC
Friday 25th pm
Saturday 26th am
Saturday 26th pm
Spreadsheet: 108951d1305878695-anova-2-factor-with-replication-anova
Sheet: Sheet1

Groups | Male | Female
Group 1 | 234 | 228
 | 252 | 256
 | 222 | 251
 | 239 | 236
 | 247 | 250
 | 234 | 242
 |  | 253
 |  | 235
 |  | 248
 |  | 245
Group 2 | 229 | 240
 | 220 | 231
 | 239 | 241
 | 241 | 250
 | 252 | 252
 | 247 | 256
 | 245 | 236
 | 244 | 244
 | 241 | 256
 | 244 | 245
 | 233 | 244
 |  | 235
Spreadsheet: 107096d1304294593-vlookup-with-concatenate-index-match-101
Sheet: Sheet1

Course | Sect | CRN
6001 | 1 | 14590
6001 | 2 | 13840
6001 | 3 | 12903
6001 | 4 | 11134
6001 | 5 | 22349
6001 | 6 | 22131
6001 | 7 | 22345
6001 | 8 | 65455
7002 | 1 | 55505
7002 | 2 | 56605
7002 | 3 | 45540
8000 | 1 | 99032
8000 | 2 | 11101
8000 | 3 | 33092
9001 | 1 | 33453
9001 | 2 | 77677
9001 | 3 | 65332
9001 | 4 | 11116
9001 | 5 | 67774
9001 | 6 | 33343
9001 | 7 | 90991
9001 | 8 | 99212
9002 | 1 | 88989
9002 | 2 | 88764
9002 | 3 | 88785
9002 | 4 | 55451
9002 | 5 | 22341
9002 | 6 | 11109
9002 | 7 | 55554
9002 | 8 | 67776
Spreadsheet: 78d86a6a-2310-44f5-8e55-cfd2d0d9ef41
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5562 | 16778 | [NAME] | Law | GBR | 0 | 00:53:59 | 00:02:12 | 01:33:59 | 00:25:53 | 00:53:58 | 1 | 02:56:02
Spreadsheet: 86227d1286246717-automatically-updating-multiple-sheets-to-a-master-sheet-welshgirl-finance-sheet-test
Sheet: Project B

Project B
Date | [NAME] | Invoice                          Number | Cheque No. | Paying In Slip No. | £             Inc | £                              Exp | £                         Bal
2010-08-07 00:00:00 | b | 1 | 3 | 4 | 200 | 100 | 100
2010-07-08 00:00:00 | b | 7 | 8 | 8 | 300 | 200 | 200
2010-10-09 00:00:00 | b | 7 | 8 | 9 | 300 | 200 | 300
1900-03-17 00:00:00 | 77 | 77 | 77 | 77 | 77 | 77 | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  |  |  | 300
 |  |  |  |  | 877 | 577 | 600
Spreadsheet: vkaminski__40853__ModelingProject
Sheet: 7.8

7.8 | [NAME] of Schwartz (1997) One Factor Model for a European Futures Option with Seasonal Volatility
 | S | a | m | l | s | mhat |  | K | T | s | N | r
 | 26.9 | 0.472 | 2.925 | 0 | 0.368 |  |  | 23.2 |  | 1 | 10 | 0.1
 | dt | lnS | P(0,T) |  |  |  |  | call_value |  | [NAME] |  | M
 |  |  |  |  |  |  |  |  |  |  |  | 1000
 | t | 0
 | s(t) | 0.508 | 0.633 | 0.623 | 0.669 | 0.689 | 0.708 | 0.606 | 0.479 | 0.478 | 0.472 | 0.322
 | e
 | xt
 |  |  |  |  |  |  |  |  |  | ST | F(T,s) | CT
 | Trials | [NAME] | x1 | x2 | [NAME] | x4 | x5 | x6 | x7 | [NAME] | x9 | x10 | ST | F(T,s) | CT | call
 | 1
Spreadsheet: 782853d1654333201-help-need-to-remove-multiple-nested-if-statements-2022-06-04-oeldere-beeno-timesheet
Sheet: Pivot table

Person A
Rijlabels | Som van Hours
2022 | 38700
14 | 900
15 | 4500
16 | 4500
17 | 4500
18 | 4500
19 | 4500
20 | 4500
21 | 4500
22 | 4500
23 | 1800
 | 900
 | 900
Eindtotaal | 39600
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: Mar00

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
2000-03-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.51 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 2.54
IFGMR (PEPL/TX/OK) |  |  | 2.48
IFGMR (ANR/LA) |  |  | 2.54
IFGMR (HENRY HUB) |  |  | 2.61
NX3 |  |  | 2.56067
Sitara 10227
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
Sitara 10226
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* (TX) |  | 2.5 |  | BASIS DIFFERENTIAL
TRIGGER* (LA) |  | 2.5 |  | IFGMR (HENRY HUB)
DIFFERENTIAL (TX) |  |  |  | LESS AVG IFGMR (TRKL/LA)
DIFFERENTIAL (LA) |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D | BASIS DIFFERENTIAL
 |  |  |  | IFGMR (HENRY HUB)
*Customer prefers rounding to nearest penny. |  |  |  | LESS AVG IFGMR(TRKL/TX)
 |  |  |  | BASIS DIFFERENTIAL
Spreadsheet: 101336d1299494909-excel-2007-cross-referencing-tables-testb
Sheet: Packages

 | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Product 12
Package 1 | 1 | 1 |  |  |  |  |  |  |  |  | 1 | 1
Package 2 |  |  | 1 |  | 1 | 1 |  |  |  |  | 1
Package 3 |  |  |  | 1 |  |  | 1
Package 4 |  |  |  |  |  | 1 | 1 | 1 | 1
Package 5 | 1 | 1 | 1 |  | 1
Package 6 |  |  |  |  |  |  | 1 | 1
Package 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Package 8
Package 9 |  | 1 |  | 1 | 1 | 1 |  |  |  |  | 1 | 1
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Measured | Scheduled | Measured | Scheduled
1 |  |  | -37797 | -39510
2 |  |  | -31170 | -33500
3 |  |  | -34998 | -34553
4 |  |  | -31429 | -37675
5 |  |  | -70684 | -71022
6 |  |  | -55515 | -53290
7 |  |  | -54660 | -54207
8 |  |  | -64278 | -65832
9 |  |  | -56899 | -51220
10 |  |  | -80878 | -83278
11 |  |  | -39218 | -34972
12 |  |  | -75159 | -76610
13 |  |  | -84552 | -83645
14 |  |  | -75573 | -76004
15 |  |  | -76895 | -77595
16 |  |  | -71854 | -71004
17 |  |  | -64280 | -68313
18 |  |  | -19489 | -24368
19 |  |  | -48291 | -48478
20 |  |  | -62451 | -61816
21 |  |  | -88377 | -90931
22 |  |  | -84974 | -86099
23
24
25
26
27
28
29
30
31
index
2001-06-30 00:00:00 |  |  |  |  | 555453.09
2001-07-22 00:00:00
Spreadsheet: mary_fischer__25634__31Q
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Q
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/2000 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2001
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: 763486d1642187500-help-nesting-sumif-and-left-or-sumproduct-left-and-and-example-5-
Sheet: Example

Column A | Column B | Column C | Column D |  | date1 | date2
DATE | Amount |  | Description |  | 2022-01-03 00:00:00 | 2022-01-10 00:00:00
2022-01-03 00:00:00 | -35.78 | * | PURCHASE Amazon Online DSW
2022-01-09 00:00:00 | -89.7 | * | PURCHASE Safeway #3120 Scottsdale, AZ
2022-01-10 00:00:00 | 200 | * | PURCHASE Refund credit card ending in 2233
2022-01-10 00:00:00 | -75 | * | [NAME] Buffalo Wild Wings Restaurant
2022-01-11 00:00:00 | -10 | * | PURCHASE Shell Oil #6140 Reno, NV
=SUMIFS( B2:B7, B2:B7, "<0", (LEFT(D2:D7,8)),="PURCHASE")
Spreadsheet: 828106d1683224643-map-xlookup-below-a-value-if-not-above-map-below-above
Sheet: map

id | qty |  | expected_result |  |  |  | current formula
Al-100 | 50 |  | 1165 | 30 |  |  |  |  |  |  |  |  | Al-100 | 2023-04-17 00:00:00 | 30 | g | 1165 | USD
Al-100 | 100 |  | 1165 | 30 |  |  | 1165 |  |  |  |  |  | Al-100 | 2023-04-17 00:00:00 | 1000 | g | 922 | USD
[NAME] | 250 |  | 1200 | 100 |  |  | 1200 |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 30 | g | 1500 | USD
[NAME] | 500 |  | 1100 | 500 |  |  | 1100 |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 500 | g | 1100 | USD
[NAME] | 1000 |  | 865 | 1000 |  |  | 865 |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 1000 | g | 865 | USD
Al-102 | 50 |  | 1000 | 830 |  |  | 1000 |  |  |  |  |  | Al-102 | 2023-04-17 00:00:00 | 30 | g | 1000 | USD
Al-102 | 100 |  | 1000 | 830 |  |  | 1000 |  |  |  |  |  | Al-102 | 2023-04-17 00:00:00 | 1000 | g | 830 | USD
Al-103 | 250 |  | 940 | 30 |  |  | 940 |  |  |  |  |  | Al-103 | 2023-04-17 00:00:00 | 30 | g | 940 | USD
Al-103 | 500 |  | 940 | 30 |  |  | 940 |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 100 | g | 1200 | USD
Al-104 | 1000 |  | 46 | 1000 |  |  | 46 |  |  |  |  |  | Al-104 | 2023-04-17 00:00:00 | 1000 | g | 46 | USD
Al-105 | 50 |  | 33 | 25000 |  |  | 33 |  |  |  |  |  | Al-105 | 2023-04-17 00:00:00 | 25000 | g | 33 | USD
Al-130 | 100 |  | 29 | 25000 |  |  | 29 |  |  |  |  |  | Al-130 | 2023-04-17 00:00:00 | 25000 | g | 29 | USD
Al-111 | 250 |  | 71 | 1000 |  |  | 71 |  |  |  |  |  | Al-111 | 2023-04-17 00:00:00 | 1000 | g | 71 | USD
Al-112 | 500 |  | 39 | 1000 |  |  | 39 |  |  |  |  |  | Al-112 | 2023-04-17 00:00:00 | 1000 | g | 39 | USD
Al-113 | 1000 |  | 7 | 1000 |  |  | 7 |  |  |  |  |  | AA7075-100 | 2023-04-17 00:00:00 | 500 | g | 130 | USD
Al-113 | 50 |  | 8 | 500 |  |  | 8 |  |  |  |  |  | Al-113 | 2023-04-17 00:00:00 | 1000 | g | 7 | USD
AA7075-100 | 100 |  | 130 | 500 |  |  | 130 |  |  |  |  |  | AA7075-100 | 2023-04-17 00:00:00 | 1000 | g | 120 | USD
AA7075-101 | 250 |  | 106 | 1000 |  |  | 106 |  |  |  |  |  | AA7075-101 | 2023-04-17 00:00:00 | 1000 | g | 106 | USD
AA7075-102 | 500 |  | ALERT | ALERT |  |  | ALERT |  |  |  |  |  | Al-113 | 2023-04-17 00:00:00 | 500 | g | 8 | USD
AA7075-103 | 1000 |  | ALERT | ALERT |  |  | ALERT
AA7075-104 | 50 |  | ALERT | ALERT |  |  | ALERT
Spreadsheet: 767001d1644231348-return-a-qty-and-ref-code-as-per-lookup-criteria-in-column-a-return-a-qty-and-ref-code-as-per-lookup-criteria-in-column-a
Sheet: Sheet1

Item Code | Item Description | Expected Results |  |  |  |  |  | Item Code | Item Description |  |  | HDR-2011/2313 | HDR-2011/2333 | HDR-2012/2337 | HDR-2011/2312 | HDR-2011/2334 | HDR-2012/2359 | HDR-2101/2422 | HDR-2101/2437+2438 | HDR-2102/2454 | HDR-2101/2426 |  | HDR-2102/2447
 |  | Qty | Ref# Code
9366 | Shore Brace Frame (H) | 14 | HDR-2011/2333 |  |  |  |  | 9366 | Shore Brace Frame (H) |  |  |  | 14 | 82 |  |  |  |  |  |  |  |  | 39
25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) | 50 | HDR-2011/2333 |  |  |  |  | 25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) |  |  |  | 50 | 65 |  |  | 6
25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) | 65 | HDR-2012/2359 |  |  |  |  | 13141 | Post head [NAME] (2.0'') (L) ([NAME].) |  |  |  | 115 | 38 |  | 74 | 7 | 137 |  | 178 |  |  | 421
9366 | Shore Brace Frame (H) | 82 | HDR-2102/2447 |  |  |  |  | 141516 | Cross Brace 0.90m |  |  |  |  |  | 62 |  |  |  | 15
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 115 | HDR-2011/2333 |  |  |  |  | 141523 | Cross Brace 1.20m |  |  | 55
25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) | 6 | HDR-2012/2337
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 38 | HDR-2012/2337
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 74 | HDR-2011/2334
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 7 | HDR-2012/2359
141516 | Cross Brace 0.90m | 62 | HDR-2011/2312
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 137 | HDR-2101/2422
141516 | Cross Brace 0.90m | 15 | HDR-2101/2437+2438
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 178 | HDR-2102/2454
9366 | Shore Brace Frame (H) | 39 | HDR-2012/2337
141523 | Cross Brace 1.20m | 55 | HDR-2011/2313
13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 421 | HDR-2102/2447