tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2bf71dcb-1bbd-4534-b5cc-a6cf3d6a0a3c
Sheet: extract(40)

WHITMAN-HANSON REGIONAL HIGH SCHOOL
2012-2013 High Honor Roll Trimester 2
Last Name | First Name | Grade
Bailey | [NAME] | 9
[NAME] | [NAME] | 9
Bukow | Mikaela | 9
Curran | [NAME] | 9
Devlin | Gerard | 9
Downey | [NAME] | 9
Duffey | [NAME] | 9
Evans | [NAME] | 9
Farulla-Bastian | Gabrielle | 9
Hall | [NAME] | 9
Haskell | Paisley | 9
Meagher | [NAME] | 9
Mitchell | [NAME] | 9
O'Kane | [NAME] | 9
Polito | [NAME] | 9
Rabinovitz | Kaitlyn | 9
Shea | [NAME] | 9
Smith | [NAME] | 9
[NAME] | Ansley | 9
Talbot | [NAME] | 9
Concannon | [NAME] | 10
Dawber | Rachel | 10
DeLeon | Gabrielle | 10
Katarivas | Nicole | 10
Key | Madeline | 10
Mossman | Emily | 10
Simonelli | [NAME] | 10
Spillane | Rachel | 10
Benvie | [NAME] | 11
Bukow | Hayley | 11
Dempsey | [NAME] | 11
Devlin | Shane | 11
Edwards | [NAME] | 11
[NAME] | Emily | 11
Bonitatibus | [NAME] | 12
Boussy | [NAME] | 12
Cacciatore | [NAME] | 12
[NAME] | [NAME] | 12
[NAME] | Christina | 12
[NAME] | [NAME] | 12
Spivack | Danielle | 12
Wanschers | Tess | 12
Spreadsheet: 692204d1598177076-help-with-total-hour-calculation-between-shifts-19-hours-shift-excluding-weekend-hours-excelquestion
Sheet: HRF ACO ART

Week# | Lines | Start Time | Finish Time | Total Run Time
 | 1 | 2020-06-29 06:11:15.236000 | 2020-06-30 17:40:49.104000
 | 1 | 2020-06-30 17:44:26.457000 | 2020-07-02 16:00:13.486000
 | 1 | 2020-07-02 16:04:40.213000 | 2020-07-02 19:17:18.534000
 | 1 | 2020-07-02 19:17:48.211000 | 2020-07-03 14:40:41.049000
 | 1 | 2020-07-03 14:41:27.397000 | 2020-07-06 06:51:23.864000
 | 1 | 2020-07-06 06:52:23.480000 | 2020-07-07 09:06:23.610000
 | 1 | 2020-07-07 09:08:18.936000 | 2020-07-07 15:23:08.115000
 | 1 | 2020-07-07 15:24:08.447000 | 2020-07-09 07:25:09.849000
 | 1 | 2020-07-09 07:26:16.246000 | 2020-07-09 17:09:37.987000
 | 1 | 2020-07-09 17:10:20.877000 | 2020-07-10 13:43:34.865000
 | 2 | 2020-06-28 05:00:00 | 2020-06-30 07:07:24.386000
 | 2 | 2020-06-30 07:08:13.794000 | 2020-06-30 11:22:16.022000
 | 2 | 2020-06-30 11:22:56.316000 | 2020-06-30 19:11:04.353000
 | 2 | 2020-07-01 05:33:32.189000 | 2020-07-01 15:39:09.147000
 | 2 | 2020-07-01 18:05:14.339000 | 2020-07-01 20:14:41.995000
 | 2 | 2020-07-01 20:51:36.962000 | 2020-07-01 23:11:38.924000
 | 2 | 2020-07-02 07:14:05.370000 | 2020-07-02 22:39:33.053000
 | 2 | 2020-07-03 05:08:36.934000 | 2020-07-03 12:07:19.011000
 | 2 | 2020-07-03 12:14:43.286000 | 2020-07-06 23:52:23.003000
 | 2 | 2020-07-07 05:52:36.496000 | 2020-07-07 07:53:09.037000
 | 2 | 2020-07-07 07:53:46.599000 | 2020-07-08 17:11:58.928000
 | 3 | 2020-06-28 05:00:00 | 2020-06-29 14:10:28.853000
 | 3 | 2020-06-29 14:13:52.773000 | 2020-06-29 20:46:32.596000
 | 3 | 2020-06-29 20:47:06.459000 | 2020-06-30 11:55:15.659000
 | 3 | 2020-06-30 11:56:14.409000 | 2020-06-30 19:51:42.381000
 | 3 | 2020-07-01 05:29:07.149000 | 2020-07-01 22:57:38.299000
 | 3 | 2020-07-02 05:18:18.450000 | 2020-07-02 10:50:44.631000
 | 3 | 2020-07-02 10:51:36.328000 | 2020-07-02 13:42:02.054000
 | 3 | 2020-07-02 13:43:10.504000 | 2020-07-02 18:44:18.683000
 | 3 | 2020-07-02 18:45:00.452000 | 2020-07-02 22:27:17.110000
 | 3 | 2020-07-03 05:24:08.356000 | 2020-07-03 07:27:51.198000
 | 3 | 2020-07-03 07:28:53.737000 | 2020-07-03 19:17:20.933000
 | 3 | 2020-07-03 19:18:08.441000 | 2020-07-04 06:18:50.599000
 | 3 | 2020-07-04 06:20:01.742000 | 2020-07-04 09:59:17.766000
 | 3 | 2020-07-04 10:00:55.443000 | 2020-07-04 13:47:27.739000
 | 3 | 2020-07-06 05:17:30.673000 | 2020-07-06 10:43:20.775000
Spreadsheet: 804301d1667992759-index-and-match-formula-with-2-criteria-inc-nearest-date-sample-index-match-2-
Sheet: Sheet1

 | Part No. | Part Name | No. Ship | 1-C01 | 1-C02 | 1-C03 | 1-C04 | 1-C05 | 1-C06
 |  |  | ETA | 2022-10-30 00:00:00 | 2022-10-30 00:00:00 | 2022-11-15 00:00:00 | 2022-11-15 00:00:00 | 2022-11-10 00:00:00 | 2022-11-10 00:00:00
 |  |  | Status | Rcv | Rcv | Otw | Otw | Otw | Otw
 | 42219910030 | NUT,DOOR WINDOW REGULATOR |  | 0 | 90000 | 0 | 102000 | 0 | 80000
 | 4513050008 | ADJUSTER S/A, REC SEAT RH |  | 2000 | 1920 | 1560 | 3840 | 3200 | 3000
 | 4513060007 | ADJUSTER S/A, REC [NAME] |  | 0 | 1920 | 2568 | 1920 | 3200 | 3000
 | F210010075 | GREASE MULTEMP 2C194 |  | 30 | 0 | 10 | 0 | 25 | 0
 | F210010058 | [NAME] NO.2 |  | 0 | 0 | 0 | 30 | 0 | 10
 | 8020300141 | SPIRAL SPRING MN |  | 0 | 0 | 100 | 0 | 0 | 100
 | 4535690005 | [NAME] |  | 200 | 0 | 0 | 2000 | 3000 | 0
 | 4038090054 | BRACKET,SEAT TRACK STPR |  | 0 | 0 | 0 | 2400 | 3000 | 0
 | Criteria : | Otw
 | Part No. | Part Name | Qty Otw |  | Qty Otw & Nearest Date
 | 42219910030 | NUT,DOOR WINDOW REGULATOR |  |  | 80000
 | 4513050008 | ADJUSTER S/A, REC SEAT RH |  |  | 3200
 | 4513060007 | ADJUSTER S/A, REC [NAME] |  |  | 3200
 | F210010075 | GREASE MULTEMP 2C194 |  |  | 25
 | F210010058 | [NAME] NO.2 |  |  | 10
 | 8020300141 | SPIRAL SPRING MN |  |  | 100
 | 4535690005 | [NAME] |  |  | 3000
 | 4038090054 | BRACKET,SEAT TRACK STPR |  |  | 3000
Spreadsheet: fc6d507a-4f19-4e3b-8aaa-6fb725bc6a15
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
KUR | Test | KUR | Potassium, [NAME] | Potassium, U | Potentiometric, Indirect Ion-Selective Electrode | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. Add 25 mL of 50% acetic acid as preservative at start of collection. Additional Information: 1. 24-Hour volume is required. 2. [NAME] collected with toluene urine collected with no preservative if kept refrigerated continuously is acceptable. 3. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options   Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na(2)CO(3)	Yes Toluene	Yes 6N HNO(3)	Yes Boric Acid	Yes Thymol	Yes | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 17-77 mmol/24 hours | Monday through Sunday Varies | Same day/1 day | 2 days | 1 | 84133 |  |  |  |  | Rochester
KUR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
KUR | Order Question | TM28 | Collection Duration |  | Plain Text
KUR | Order Question | VL26 | [NAME] |  | Plain Text
KUR | Result | KURU | Potassium, 24 Hr, U | Potassium, 24 Hr, U | Numeric |  |  |  |  | mmol/24 h |  |  |  |  |  |  |  |  |  | 51720-1
KUR | Result | TM28 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9
KUR | Result | VL26 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 3167-4
KUR | Result | K_CN | Potassium Concentration | Potassium Concentration | Numeric |  |  |  |  | mmol/L |  |  |  |  |  |  |  |  |  | 21476-7
Spreadsheet: 104036d1301654135-multiple-entries-under-one-reference-on-a-table-lookup-values-example
Sheet: Sheet1

[NAME] Ref | Name -> Name | W/E Date | Company -> Name | Net Bill | Net Pay | Margin | [NAME]
8697 | [NAME] | 2010-09-04 00:00:00 | Test | 3243.64 | 3089.26 |  | 121
8697 | [NAME] | 2010-09-11 00:00:00 | Test | 2618.36 | 2493.74 |  | 122
8697 | [NAME] | 2010-09-18 00:00:00 | Test | 3353.07 | 3193.48 |  | 123
Where I would like to be.....
 | Week End | 2010-09-05 00:00:00
 | Working Days | 4 | 5 | 5 | < I've already used the NETWORKDAYS function for this
 | Week Start | 2010-08-30 00:00:00
8697 | [NAME]
Spreadsheet: 745438d1629927023-pulling-forward-data-under-filter-conditions-pullforward
Sheet: 1

AM Rounding |  |  | PM Rounding |  |  | Night Rounding
First Impression | everything looks good |  | First Impression | good |  | First Impression | good
Tunnel & Decontam | okay job |  | Tunnel & Decontam | need to follow up * |  | Tunnel & Decontam | good
Chutes/Chemo/Bio | need to follow up * |  | Chutes/Chemo/Bio | good |  | Chutes/Chemo/Bio | good
Key & Supply Room | looks good |  | Key & Supply Room | good |  | Key & Supply Room | good
Spreadsheet: 674347d1587771731-sum-total-past-due-invoices-from-a-list-of-clients-sum-client-total-invoices1
Sheet: Sheet1

 | The goal is to write a formula in column P that separately sums the total Past Due invoice amounts in column M for each individual client
 |  |  |  |  |  |  |  |  |  |  |  |  | Wrong |  | Wrong
Cust # | Name | Invoice # | Inv date | Due date | Order # | Inv amt | Paid | Cr/Adj | Balance | Age Balance as of Today | Days Past Due | Past Due | Client |  | Total
16625 | XYZ Corp | 81624 | 2020-02-10 00:00:00 | 2020-03-11 00:00:00 | 48752 | 600 | 0 | 55312.4 | -55312.4
 |  | 81668 | 2020-02-28 00:00:00 | 2020-03-29 00:00:00 | 48112 | 375849 | 0 | 0 | 375849
Customer total |  | Ph |  |  | Fax |  |  |  | 320536.6
16704 | ABC Corp | 81560 | 2020-01-20 00:00:00 | 2020-02-19 00:00:00 | 48516 | 12266.2 | 0 | 0 | 12266.2
 |  | 81599 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48711 | 0 | 0 | 1340 | -1340
 |  | 81600 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48713 | 0 | -1742.98 | 3317.76 | -1574.78
 |  | 81604 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48717 | 0 | 0 | 9097.02 | -9097.02
 |  | 81605 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48718 | 0 | 0 | 254.4 | -254.4
 |  | 81681 | 2020-03-04 00:00:00 | 2020-04-03 00:00:00 | 47924 | 576175.56 | 0 | 0 | 576175.56
 |  | 81739 | 2020-03-27 00:00:00 | 2020-04-26 00:00:00 | 48854 | 1950 | 0 | 0 | 1950
 |  | 81746 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 48846 | 1447.55 | 0 | 0 | 1447.55
Customer total |  | PH |  |  | Fax |  |  |  | 3305.56
14300 | DFG Corp | 81641 | 2020-02-19 00:00:00 | 2020-02-19 00:00:00 | 48647 | 4141.18 | 0 | 0 | 4141.18
 |  | 81720 | 2020-03-18 00:00:00 | 2020-03-18 00:00:00 | 48154 | 111438.26 | 0 | 0 | 111438.26
Customer total |  | PH |  |  | Fax |  |  |  | 115579.44
Spreadsheet: john_griffith__15604__Mesa Model 1_10_01
Sheet: % Summary

 | City of Mesa Summary
 | As of: | 2001-01-10 00:00:00
 | Current deal at El Paso San Juan
 |  |  |  |  | Customer | Mkt |  | PV
 | From | To | Term | Volume | Price | Price | $ | [NAME]
NP1265.2 | 2001-02-01 00:00:00 | 2001-07-01 00:00:00 |  | see below
Reprice Current deal | 2001-02-01 00:00:00 | 2001-07-01 00:00:00 |  | see below | 5.25
 |  |  |  |  |  | Difference
 |  |  |  |  |  | Origination | 0
 |  |  |  |  |  | Credit | 0
 |  |  |  | Discount to Current Market
 |  |  |  | Current Market
New Index Sale | 2001-08-01 00:00:00 | 2002-07-01 00:00:00 |  | see below
 | Existing Fixed Price
 | Month | Volume/month | To reprice
 | 2001-02-01 00:00:00 | 168000 | 160000
 | 2001-03-01 00:00:00 | 155000 | 155000
 | 2001-04-01 00:00:00 | 120000 | 120000
 | 2001-05-01 00:00:00 | 93000 | 93000
 | 2001-06-01 00:00:00 | 90000 | 90000
 | 2001-07-01 00:00:00 | 93000 | 77500
 | Totals
 | New Index Deal
 | Month | Volume/month
 | 2001-08-01 00:00:00 | 177000
 | 2001-09-01 00:00:00 | 178000
 | 2001-10-01 00:00:00 | 217000
 | 2001-11-01 00:00:00 | 268000
 | 2001-12-01 00:00:00 | 446000
 | 2002-01-01 00:00:00 | 421000
 | 2002-02-01 00:00:00 | 336000
 | 2002-03-01 00:00:00 | 317000
 | 2002-04-01 00:00:00 | 225000
 | 2002-05-01 00:00:00 | 190000
 | 2002-06-01 00:00:00 | 167000
 | 2002-07-01 00:00:00 | 166000
 | Total
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 3

 | December 20 | December 27 | January 3 | January 10 | January 17
Total Interest Rate* | 23541 | 5595 | 10717 | 29110 | 22666
Cleared** | 20423 | 4077 | 7228 | 19903 | 14178
Uncleared | 3118 | 1518 | 3489 | 9207 | 8488
Total Cross-Currency | 643 | 115 | 447 | 1357 | 1482
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 643 | 115 | 447 | 1357 | 1482
Total Credit | 6122 | 940 | 3358 | 6800 | 6809
Cleared | 4632 | 758 | 1740 | 4946 | 4891
Uncleared | 1490 | 182 | 1618 | 1854 | 1918
Total FX | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 30305 | 6650 | 14522 | 37267 | 30957
Weekly total, swap ticket volumes by asset class and cleared status (number of new trades), all products, tenors, and participant types. For cleared swaps, this table reflects the creation of only one of the two swaps that results from the clearing process. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes.
*See Data Dictionary for asset class descriptions.
**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: 864043d1711385056-if-then-multiple-criteria-help-book2
Sheet: Sheet1

Trade Date (M/D/YYYY) | Trader | Company | Commodity | Contract Month | Contract Year (YYYY) | Direction (B/S) | Lots | EFP | MERC Price | Trade Number | Line | Counterparty | TAS Price | [NAME] | Reported |  | SettlePrice TABLE
2024-03-20 00:00:00 | Justin | xyz | HO | APR | 2024 | S | -25 | EFP | 2024-03-22 00:00:00 | 957341 |  | Aramco | 2.6688 | good |  |  | 2.7271 | RB
2024-03-20 00:00:00 | Justin | xyz | HO | APR | 2024 | S | -25 | EFP | 2024-03-22 00:00:00 | 957342 |  | [NAME] | 2.6688 | good |  |  | 2.6688 | HO
Spreadsheet: 779736d1652077093-populate-calendars-based-on-office-location-office-scheduling-draft
Sheet: W

Month: | May
Year: | 2022
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Spreadsheet: daren_farmer__6635__Texas Nat_Gas Ops 0200 O&M Report
Sheet: 2940 Detail

[NAME] Class |  | Co |  |  |  | Work Order |  | Invoice # | Vendor# |  | [NAME] |  | Amount
1 | SALARIES AND WAGES
 |  | 413 | 9200 | 999 | 413-008-01 |  |  | SUMMARIZED | LD    1129 |  |  |  | 1770.82
 |  | 413 | 9200 | 999 | 413-008-02 |  |  | SUMMARIZED | LD    1992 |  |  |  | 1770.82
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 3541.64
552 | BENEFITS
 |  | 413 | 9260 | 999 | 413-008-01 |  |  | SUMMARIZED | LD    1129 |  |  |  | 239.98
 |  | 413 | 9260 | 999 | 413-008-02 |  |  | SUMMARIZED | LD    1992 |  |  |  | 302.9
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 542.88
557 | PAYROLL TAXES
 |  | 413 | 4081 | 510 | 413-008-01 |  |  | SUMMARIZED | LD    1129 |  |  |  | 6.52
 |  | 413 | 4081 | 520 | 413-008-01 |  |  | SUMMARIZED | LD    1129 |  |  |  | 135.61
 |  | 413 | 4081 | 520 | 413-008-02 |  |  | SUMMARIZED | LD    1992 |  |  |  | 135.4
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 277.53
 |  |  |  |  |  |  |  |  |  |  |  |  | Field58: | 4362.05
Spreadsheet: 872534d1718900672-needing-formula-to-read-the-last-entry-in-a-column-weekly-weight-2024
Sheet: Data

 | Weekly Weight 2024 |  |  |  |  | 2023
Week |  |  |  |  |  | Start | 113.8
 | Date | Weight | Target |  |  | End | 106
52 | 01.01.24 | 106
51 | 08.01.24 | 105.9
50 | 15.01.24 | 105.7
49 | 22.01.24 | 106.1
48 | 29.01.24 | 105.1
47 | 05.02.24 | 104.8
46 | 12.03.24 | 105.1
45 | 19.02.24 | 104.5
44 | 26.02.24 | 105.5
43 | 04.03.24 | 105.1
42 | 11.03.24 | 105.6
41 | 18.03.24 | 106.5
40 | 25.03.24 | 106.5
39 | 01.04.24 | 105.3 | 103
38 | 08.04.24 | 106
37 | 15.04.24 | 106.5
36 | 22.04.24 | 107
35 | 29.04.24 | 106.7
34 | 06.05.24 | 106.7
33 | 13.05.24 | 104.7
32 | 20.05.24 | 104.1
31 | 27.05.24 | 104.3
30 | 03.06.24 | 104.5
29 | 10.06.24 | 104.8
28 | 17.06.24 | 101.6
27 | 24.06.24 |  | 101
26 | 01.07.24
25 | 08.07.24
24 | 15.07.24
23 | 22.07.24
22 | 29.07.24
21 | 05.08.24
20 | 12.08.24
19 | 19.08.24
18 | 26.08.24
17 | 02.09.24
16 | 09.09.24
15 | 16.09.24
14 | 23.09.24
13 | 30.09.24 |  | 100
12 | 07.10.24
11 | 14.10.24
10 | 21.10.24
9 | 28.10.24
8 | 04.11.24
7 | 11.11.24
6 | 18.11.24
5 | 25.11.24
4 | 02.12.24
3 | 09.12.24
2 | 16.12.24
1 | 23.12.24
0 | 30.12.24 |  | 99
Spreadsheet: 732674d1621147419-create-a-drop-down-list-with-a-diminishing-data-set-dynamic-drop-down
Sheet: INNING LIST

RAW NAME LIST | INNING1 | INNING2 | INNING3 | INNING4 | INNING5 | INNING6
Philbert
Marnip
Flamhammer
Learcock
Nibhibbit
[NAME]
Crimphany
Noodlebopper
Spreadsheet: 793237d1661360208-return-cell-values-from-a-table-based-on-multiple-criteria-example-error-details
Sheet: Per Person

 | Sample Report - Team 1
 | Results per Person
Goal | Employee | QA [NAME] | Total Agreements  Audited | Total Attributes Reviewed | Total Attribute Errors | Attribute Error Details
0.95 | Gina
0.95 | [NAME]
0.95 | Manny
0.95 | Timothy
0.95 | Travis
0.95 | [NAME]
0.95 | [NAME]
0.95 | [NAME]
0.95 | Stacy
0.95 | Belen
0.95 | [NAME]
 | Sample Report - Team 2
 | Results per Person
Goal | Employee | QA [NAME] | Total Agreements  Audited | Total Attributes Reviewed | Total Attribute Errors | Attribute Error Details
0.95 | Kristen
0.95 | [NAME]
0.95 | [NAME]
0.95 | Justin
0.95 | [NAME]
0.95 | Heather
0.95 | [NAME]
0.95 | [NAME]
0.95 | Ricardo
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: ARUBA_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  ARUBA
 |  |  | Total |  | Reclasses |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | 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
Spreadsheet: 543645d1508493740-assistance-with-correct-formula-calculation-please-book3
Sheet: Princess Gate

Princess Gate Bookings
Check In | Check Out | Guest | Rate | Nights | Total (Ex VAT) | VAT | Cleaning Fee (Ex Vat) | VAT | Service Fee ([NAME]. [NAME]) | Total Payout | Property Owner | Manager | Check
04/10/2017 | 08/10/2017 | [NAME] | 805.5 | 4 |  |  | 150 |  |  |  |  |  |  | need to get Manager Figure to 618.00
08/10/2017 | 09/10/2017 | [NAME] | 895.5 | 1 |  |  | 150 |  |  |  |  |  |  | need to get Manager Figure to 281.00
Spreadsheet: 516144d1493834324-sumproduct-and-array-with-cell-references-formulas-example-2-
Sheet: Sheet1

Tiers | Commission% | January | February | March | April | May | June | July | August
$0 - 10M | % | 0.012
 | other data | other data | other data | other data | other data | other data | other data | other data | other data
 | % | 0.003
$10 - 25M | % | 0.011
 | other data | other data | other data | other data | other data | other data | other data | other data | other data
 | % | 0.0025
$25M+ | % | 0.01
 | other data | other data | other data | other data | other data | other data | other data | other data | other data
 | % | 0.002
Total Transacted |  | 15000000 | 17000000 | 20000000 | 21000000 | 17000000 | 22000000 | 19000000 | 26000000
Commission
 | 0
 | 10000000
 | 25000000
Expected result
Spreadsheet: 788277d1658377767-have-cell-display-item-that-match-three-different-criteria-service-planner
Sheet: Special Events

Date | Special Event
2020-08-16 00:00:00 | Lord's Supper
2020-11-08 00:00:00 | Lord's Supper
2020-12-27 00:00:00
2021-02-14 00:00:00 | Lord's Supper
2021-03-28 00:00:00
2021-05-16 00:00:00
2021-05-23 00:00:00 | Lord's Supper
2021-08-08 00:00:00 | Lord's Supper
2021-08-29 00:00:00
2021-10-03 00:00:00
2021-10-31 00:00:00
2021-11-14 00:00:00 | Lord's Supper
2021-12-12 00:00:00 | Christmas Luncheon (N-PM)
2022-01-16 00:00:00 | SERVICE CANCLED BECAUSE OF SNOW
2022-01-23 00:00:00 | SOUP Luncheon
2022-01-30 00:00:00
2022-02-13 00:00:00
2022-02-20 00:00:00 | Lord's Supper
2022-05-08 00:00:00 | Mothers Day
2022-05-15 00:00:00 | Lord's Supper/ 3rd Sunday
2022-05-29 00:00:00 | 5th Sunday
2022-06-12 00:00:00 | Catechism
2022-06-19 00:00:00 | Father's Day/ 3rd Sunday
2022-07-10 00:00:00 | Catechism
2022-07-31 00:00:00 | 5th Sunday
2022-08-14 00:00:00 | Lord's Supper
2022-10-30 00:00:00 | 5th Sunday
2022-11-13 00:00:00 | Lord's Supper
2022-11-20 00:00:00 | 3rd Sunday
2022-12-04 00:00:00 | [NAME]
2022-12-11 00:00:00 | Christmas Luncheon (N-PM)
2022-12-18 00:00:00 | 3rd Sunday
2023-01-29 00:00:00 | 5th Sunday
2023-02-12 00:00:00 | Lord's Supper
2023-04-30 00:00:00 | 5th Sunday
2023-05-14 00:00:00 | Lord's Supper
Spreadsheet: chris_germany__1705__July00_FOM_Req
Sheet: FOM Jul Storage

 |  | First-of-the Month Baseload Storage Injections/(Withdrawals)
 |  |  | Monthly | Daily
 |  |  | Inj/(WD) | Inj/(WD) | Delivery
LDC |  | Pipe/Service | Dth# | Dth# | Point
Atlanta Gas Light
 | IBSS
 |  | Transco / AGL City Gate## |  | 1694 | citygate | This volume included in citygate requirements for AGL
 |  | Sonat / ANR Shadyside |  | 2966 | Shadyside
 | DAS | [NAME] WSS | 52700 |  | storage injection meter
 |  | Transco ESS | 2666 |  | storage injection meter
 |  | Tennessee FS-MA |  | 0
 |  | Tennessee FS-PA | 0 |  | citygate
 |  | CNG |  | 0
 |  | SONAT | 134001 |  | storage injection meter
Columbia Gas of Ohio
 |  | TCO FSS | 1089109 |  | storage injection meter
##IBSS injections on [NAME] at AGL citygate are included in Transco citygate requirements in "Total Reqs" and 'Jun EPA Vols' worksheets.
Spreadsheet: 647760d1572613388-closest-match-with-multiple-criteria-3-criteria-boxes-breakdown-closest-match-sample-gk-final
Sheet: Sheet1 (2)

ID | length | width |  |  |  | [NAME] | length | width
1 | 600 | 400 |  |  |  | Cont1 | 450 | 305
2 | 400 | 300 |  |  |  | Cont2 | 800 | 500
3 | 200 | 150 |  |  |  | Cont3 | 600 | 402
 |  |  |  |  |  | Cont4 | 250 | 200
 |  | WORKING
ID | length | width | depth |  |  | [NAME] | length | width | depth
1 | 600 | 400 | 319 |  |  | Cont3 | 300 | 200 | 170
2 | 400 | 300 | 219 |  |  | Cont2 | 400 | 300 | 220
3 | 600 | 400 | 419 |  |  | Cont4 | 600 | 400 | 320
 |  |  |  |  |  | Cont1 | 600 | 400 | 420
 |  | DON'T KNOW HOW TO GET WORKING
 | MOCKUP: | For ID 1
 | Length 600 matches: |  | Cont1 |  | CLOSEST MATCH |  |  | ANSWER: |  |  | RESULT HERE
 |  |  | Cont4 |  | Cont1 & Cont4 |  |  | Cont4
 | [NAME] 400 matches: |  | Cont1 |  | CLOSEST MATCH
 |  |  | Cont4 |  | Cont1 & Cont4
 | Depth 319 matches: |  | Cont1 |  | CLOSEST MATCH
 |  |  | Cont4 |  | Cont4
Spreadsheet: 215242d1361311607-count-consecutive-by-day-book11
Sheet: Summary

Date | Name | Result
 | rep a | 0 |  |  |  |  | rep a
 | rep a | 1 |  |  |  |  | rep b
 | rep a | 0 |  |  |  |  | rep c
 | rep a | 1
 | rep a | 0 |  |  |  |  |  | Make sure you use Control+Shift+Enter same time. Then copy down
 | rep a | 1
 | rep a | 1
 | rep a | 0
 | rep a | 0
 | rep a | 0
 | rep a | 0
 | rep a | 0
 | rep b | 1
 | rep b | 0
 | rep b | 1
 | rep b | 1
 | rep b | 1
 | rep b | 1
 | rep b | 1
 | rep b | 1
 | rep b | 0
 | rep b | 1
 | rep b | 0
 | rep b | 1
 | rep c | 0