tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: Premium

[NAME] I owes and paid Enron on Puts
Premium Owed:
1998-07-13 00:00:00 | 22824327
1999-01-12 00:00:00 | 23184711.72
1999-03-11 00:00:00 | 13334212.44
Total Owed
Premium Paid: |  | Coded to:
1998-07-22 00:00:00 | -22824327 | 011-[PHONE] | MSA
1999-06-30 00:00:00 | -8750000 | 011-[PHONE] | MSA
1999-07-22 00:00:00 | -1500000 | 0011-35000000 | SAP
1999-12-14 00:00:00 | -15215255 | 0011-35000000 | SAP
Balance Due:
Premium Owed:
2000-01-11 00:00:00 | 56719353.22
Premium Paid: |  | Coded to:
Repurchase Puts | -49873051 | 0011-35000000 | SAP
Shares bought | -17900024.02 | 0011-35000000 | SAP
Balance Due:
Puts bought back on 12/14/99 for 9/10/99 price of $4.351632
for value $52,275,302.00.
 | Entries were:
 |  |  |  |  | Entries should have been:
1998-07-13 00:00:00 | Cash | 22824327 |  |  | Cash | 22824327
 | Equity |  | -22824327 |  | Equity |  | -22824327
1999-01-12 00:00:00 |  |  |  |  | Accts Receivable | 23184711.72
 |  |  |  |  | Equity |  | -23184711.72
1999-03-11 00:00:00 |  |  |  |  | Accts Receivable | 13334212.44
 |  |  |  |  | Equity |  | -13334212.44
1999-06-30 00:00:00 | Cash | 8750000 |  |  | Cash | 8750000
 | Equity |  | -8750000 |  | Accts Receivable |  | -8750000
1999-07-22 00:00:00 | Cash | 1500000 |  |  | Cash | 1500000
 | Equity |  | -1500000 |  | Accts Receivable |  | -1500000
1999-12-14 00:00:00 | Cash | 15215255 |  |  | Cash | 15215255
 | Accts Receivable |  | -15215255 |  | Accts Receivable |  | -15215255
1999-12-14 00:00:00 | Equity | 52275302 |  |  | Equity | 52275302
 | Cash |  | -52275302 |  | Cash |  | -52275302
Spreadsheet: 637399d1565886692-football-score-predictor-similar-to-super-6-but-with-10-fixtures-a-week-predictor-2019-20-v1
Sheet: Fixtures and Results

[NAME]
DATE/TIME | HOME TEAM | AWAY TEAM | FINAL SCORE |  | ZW |  | LB |  | POINTS
Friday 9th - 20:00 | LIVERPOOL | NORWICH | 4 | 1
Saturday 10th - 12:30 | WEST HAM | MAN CITY | 0 | 5
Saturday 10th - 15:00 | BOURNEMOUTH | SHEFF UTD | 1 | 1
Saturday 10th - 15:00 | BURNLEY | SOUTHAMPTON | 3 | 0
Saturday 10th - 15:00 | CRYSTAL PALACE | EVERTON | 0 | 0
Saturday 10th - 15:00 | WATFORD | BRIGHTON | 0 | 3
Saturday 10th - 17:30 | TOTTENHAM | ASTON VILLA | 3 | 1
Sunday 11th - 13:30 | LEICESTER | WOLVES | 0 | 0
Sunday 11th - 14:30 | NEWCASTLE | ARSENAL | 0 | 1
Sunday 11th - 16:30 | MAN UTD | CHELSEA | 4 | 0
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
[NAME]
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
[NAME]
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
[NAME]
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
[NAME]
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
[NAME]
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
Debs
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
[NAME]
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
[NAME]
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
[NAME]
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
[NAME]
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
[NAME]
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
Adam
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
Shea Walmsey
DATE/TIME | HOME TEAM | AWAY TEAM | YOUR PREDICTION |  | FINAL SCORE |  | POINTS
 |  |  |  |  |  | Weekly Total:
 |  |  |  |  |  | Running Total:
Spreadsheet: 69104d1269608567-colouring-numbers-vehicle-status-chart-v2
Sheet: Sheet1

Vehicle Status Chart
Fully Charged |  |  |  |  |  |  | Flat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helper Columns
 |  |  |  |  |  |  | 1 | 2 |  | 4 | 5 | 6 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  | 7 | 8 | 9 |  | 11 | 12 |  |  | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  | 13 | 14 | 15 | 16 | 17 | 18 |  |  | 13 | 14 | 15 | 16 | 17 | 18
 |  |  |  |  |  |  |  | 20 | 21 | 22 |  | 24 |  |  | 19 | 20 | 21 | 22 | 23 | 24
Spreadsheet: 55739d1255946985-copying-data-from-several-worksheets-in-one-new-worksheet-book1
Sheet: Sheet1

Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME] | [NAME] | Header 9 | Header 10 | [NAME] | Header 12
Sheet1 21 | Sheet1 22 | Sheet1 23 | Sheet1 24 | Sheet1 25 | Sheet1 26 | Sheet1 27 | Sheet1 28 | Sheet1 29 | Sheet1 210 | Sheet1 211 | Sheet1 212
Sheet1 31 | Sheet1 32 | Sheet1 33 | Sheet1 34 | Sheet1 35 | Sheet1 36 | Sheet1 37 | Sheet1 38 | Sheet1 39 | Sheet1 310 | Sheet1 311 | Sheet1 312
Sheet1 41 | Sheet1 42 | Sheet1 43 | Sheet1 44 | Sheet1 45 | Sheet1 46 | Sheet1 47 | Sheet1 48 | Sheet1 49 | Sheet1 410 | Sheet1 411 | Sheet1 412
Sheet1 51 | Sheet1 52 | Sheet1 53 | Sheet1 54 | Sheet1 55 | Sheet1 56 | Sheet1 57 | Sheet1 58 | Sheet1 59 | Sheet1 510 | Sheet1 511 | Sheet1 512
Sheet1 61 | Sheet1 62 | Sheet1 63 | Sheet1 64 | Sheet1 65 | Sheet1 66 | Sheet1 67 | Sheet1 68 | Sheet1 69 | Sheet1 610 | Sheet1 611 | Sheet1 612
Sheet1 71 | Sheet1 72 | Sheet1 73 | Sheet1 74 | Sheet1 75 | Sheet1 76 | Sheet1 77 | Sheet1 78 | Sheet1 79 | Sheet1 710 | Sheet1 711 | Sheet1 712
Sheet1 81 | Sheet1 82 | Sheet1 83 | Sheet1 84 | Sheet1 85 | Sheet1 86 | Sheet1 87 | Sheet1 88 | Sheet1 89 | Sheet1 810 | Sheet1 811 | Sheet1 812
Sheet1 91 | Sheet1 92 | Sheet1 93 | Sheet1 94 | Sheet1 95 | Sheet1 96 | Sheet1 97 | Sheet1 98 | Sheet1 99 | Sheet1 910 | Sheet1 911 | Sheet1 912
Sheet1 101 | Sheet1 102 | Sheet1 103 | Sheet1 104 | Sheet1 105 | Sheet1 106 | Sheet1 107 | Sheet1 108 | Sheet1 109 | Sheet1 1010 | Sheet1 1011 | Sheet1 1012
Sheet1 111 | Sheet1 112 | Sheet1 113 | Sheet1 114 | Sheet1 115 | Sheet1 116 | Sheet1 117 | Sheet1 118 | Sheet1 119 | Sheet1 1110 | Sheet1 1111 | Sheet1 1112
Sheet1 121 | Sheet1 122 | Sheet1 123 | Sheet1 124 | Sheet1 125 | Sheet1 126 | Sheet1 127 | Sheet1 128 | Sheet1 129 | Sheet1 1210 | Sheet1 1211 | Sheet1 1212
Sheet1 131 | Sheet1 132 | Sheet1 133 | Sheet1 134 | Sheet1 135 | Sheet1 136 | Sheet1 137 | Sheet1 138 | Sheet1 139 | Sheet1 1310 | Sheet1 1311 | Sheet1 1312
Spreadsheet: 6f925413-ee4b-42ef-937b-f577632a22df
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5840 | 29433 | Fabrizio | Vignali | ITA | 0 | 00:24:53 | [NAME] | 00:47:19 | 00:00:00 | 00:14:15 | 1 | 01:27:06
5840 | 30688 | [NAME] | Smith | GBR | 0 | 00:26:28 | 00:00:43 | 00:52:33 | 00:00:00 | 00:14:14 | 2 | 01:34:00
5840 | 7981 | [NAME] | [NAME] | USA | 0 | 00:25:26 | 00:00:49 | 00:54:02 | 00:00:00 | 00:16:11 | 3 | 01:36:32
5840 | 42399 | [NAME] | Smyth | IRL | 0 | 00:31:01 | 00:01:09 | 01:01:49 | 00:00:00 | 00:29:51 | 4 | 02:03:53
5840 | 40953 | [NAME] | [NAME] | GBR | 0 | 00:43:03 | 00:01:24 | 01:06:59 | 00:00:00 | 00:26:25 | 5 | 02:17:54
Spreadsheet: 723631d1615814695-index-match-or-aggregate-book2
Sheet: Sheet1

Production Sheet |  |  |  |  |  |  | Products Sheet |  |  |  |  |  |  |  |  | Helper
Order no | Product | Date | Deadline | Order no. | Components |  | [NAME] |  | Country | Value | Item | Box | Label | Bag |  | P1 | Component B | Component D |  | Box A | [NAME] | Bag S
MO-1 | P1 | - |  | MO-1 |  |  | P1 | Component B | - | - | P1 | Box A | [NAME] | Bag S |  | P4 | Component A |  |  | [NAME] | [NAME] | Bag M
MO-1 | P10 | - | - |  | Component B |  |  | Component D | - | - | P4 | [NAME] | [NAME] | Bag M |  | P5 | Component C | Component A | Component B | Box C | [NAME] | Bag L
MO-2 | P5 | - | - |  | Component D |  | P4 | Component A | - | - | P5 | Box C | [NAME] | Bag L |  | P10 | Component B | Component E |  | Box D | [NAME] | Bag XL
MO-3 | P4 | - | - |  |  |  | P5 | Component C | - | - | P10 | Box D | [NAME] | Bag XL
 |  |  |  |  |  |  |  | Component A | - | -
 |  |  |  |  |  |  |  | Component B | - | -
 |  |  |  | MO-1 | P10 |  | P10 | Component B | - | -
 |  |  |  |  | Component B |  |  | Component E | - | -
 |  |  |  |  | Component E
 |  |  |  |  | Box D
 |  |  |  |  | [NAME] |  |  | Input
 |  |  |  |  | Bag XL |  |  | Result
 |  |  |  | MO-2 | P5
 |  |  |  |  | Component C
 |  |  |  |  | Component A
 |  |  |  |  | Component B
 |  |  |  |  | Box C
 |  |  |  |  | [NAME]
 |  |  |  |  | Bag XL
 |  |  |  | MO-3
Spreadsheet: 06986d73-8a01-4bf9-abed-fe7dfad1359c
Sheet: 2 YEARS

Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff
 | MUID |  |  |  | ACCT
Prepared by
Last Modified on
PI |  |  |  |  | DEPT
Project Title
Sponsor
 | Budget Period
 | Increase Annually By | 1.03
 | BUDGET ITEM | Name or Comment |  |  |  | PERIOD 1 | PERIOD 2 | TOTAL
A. | PERSONNEL
6000 | PI Acad. Year
6000 | Co-I Acad Year
6000 | Co-I Acad Year
6000 | Other Professional
6000 | Total Professional
6007 | PI Summer
6007 | Co-I Summer
6007 | Co-I Summer
6007 | Total Sumr Salaries
6008 | Post Doc/Fellow Full-Time
6012 | Clinical/Lab Staff Full-Time
6013 | Clinical/Lab Staff Part-Time
6020 | Full-Time Hourly Staff
6035 | Part-Time Hourly Staff
6050 | Undergraduate Students
6024 | GRA-Academic Year | #: |  | Biweekly $:
6024 | GRA-Summer | #: |  | Biweekly $:
6024 | Total GRA
6195 | Fringe FT |  |  |  | 0.285
6195 | [NAME] |  |  |  | 0.16
6195 | Fringe PT & Summer Students |  |  |  | 0.08
6195 | Total Fringes
 | TOTAL PERSONNEL
B. | NONPERSONNEL
6200 | Office Expenses
6235 | Lab Supplies
6247 | Equipment > $5000
6265 | Computer Software
6505 | Consulting Fees
6515 | Subcontract 1 < $25K
6520 | Subcontract 1 > $25K
6515 | Subcontract 2 < $25K
6520 | Subcontract 2 > $25K
6515 | Total Sub < $25K
6520 | Total Sub > $25K
6602 | Student Stipends
6900 | Domestic Travel
6900 | Domestic Travel
6900 | Total Domestic Travel
6930 | Foreign Travel
7010 | Publications
7225 | Tuition
 | TOTAL NONPERSONNEL
 | TOTAL DIRECT COSTS: NIH MODULAR (Less Subs I/C)
 | TOTAL DIRECT COSTS: MU (Includes Subs I/C)
 | MTDC BASE
7520 | F&A Costs |  |  |  | 0.51
 | TOTAL PROJ COSTS
 |  |  |  |  | F&A for Subcontracts
 |  |  |  |  | #1
 |  |  |  |  | #2
Spreadsheet: 473465d1470227427-time-calculation-formula-not-working-well-copy-of-book16-1-
Sheet: Sheet1

OPEN DATE | RECEIPT DATE | CLOSE DATE | Time period |  |  |  | =ISTEXT(A1) | =ISNUMBER(A1)
2016-12-07 09:37:36 | 2016-12-07 09:39:18 | 2016-12-07 09:39:50
2016-12-07 09:33:20 | 2016-12-07 09:36:33 | 2016-12-07 09:37:19
2016-12-07 07:51:33 | 2016-12-07 07:52:33 | 2016-12-07 07:53:01
2016-12-07 09:54:35 | 2016-12-07 10:08:48 | 2016-12-07 10:09:33
7/13/2016 11:08:27 AM | 7/13/2016 11:15:03 AM | 7/13/2016 11:15:37 AM
7/13/2016 11:41:45 AM | 7/13/2016 11:45:33 AM | 7/13/2016 11:46:10 AM
7/13/2016 11:32:25 AM | 7/13/2016 11:35:54 AM | 7/13/2016 11:36:21 AM
Spreadsheet: 697542d1601397708-vlookup-query-for-different-sheet-involving-indirect-substitute-address-example
Sheet: Input sheet

 |  |  |  |  |  |  |  |  |  |  |  | Starting position
 | Member [NAME] |  |  | Number of movements | 8 |  |  |  |  |  |  | Fund | Units
 | Member Code |  |  |  |  | 1 |  |  |  |  |  | KABG | 1515.266916
 |  |  |  |  |  |  |  |  |  |  |  | KABH | 935.520532
 |  |  |  |  |  |  |  |  |  |  |  | KABI | 954.368436
 |  |  |  |  |  |  |  |  |  |  |  | KABE | 365.826846
 |  |  |  |  |  |  |  |  |  |  |  | KCBH | 0
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  |  | KBBV | 0
 |  |  |  |  |  |  |  |  |  |  |  | KPRM | 0
Spreadsheet: 737921d1624673451-xlookup-missing-a-bunch-of-data-i-must-be-an-idiot-lookup-help
Sheet: Draw From

CODE | COUNT
64450 | 50
27447 | 49
27130 | 48
20985 | 47
20680 | 46
29826 | 45
29880 | 44
29827 | 43
29828 | 42
29881 | 41
27245 | 40
64721 | 39
26055 | 38
27197 | 37
29822 | 36
23500 | 35
25609 | 34
25290 | 33
23515 | 32
20103 | 31
26160 | 30
27236 | 29
13121 | 28
11012 | 27
25605 | 26
28470 | 25
27829 | 24
20692 | 23
29875 | 22
23472 | 21
23430 | 20
27814 | 19
13122 | 18
20694 | 17
29823 | 16
27822 | 15
25600 | 14
11043 | 13
25076 | 12
29882 | 11
97605 | 10
27266 | 9
24538 | 8
27759 | 7
11044 | 6
25000 | 5
26418 | 4
23600 | 3
27506 | 2
26480 | 1
Spreadsheet: eric_saibi__9788__020502
Sheet: Bowline 02

Owner Name | Mirant Bowline LLC
Station Name | [NAME]
Unit Name | Bowline 02
NERC Region | NPCC
State | NY
Fuel Type | Fuel Oil / Natural Gas
Capacity | 621 MW
Start Date | 2002-02-04 00:00:00
End Date | 2002-02-06 00:00:00
Comments | Emergency [NAME] repairs
SIC | 4931
Plant ID | 1008801
Unit ID | 1006100
Outage ID | 19771
Spreadsheet: kate_symes__18772__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-02 00:00:00 |  | 298.33 | 4800 | 223.97 | 584
 | 2001-03-01 00:00:00 |  | 292.12 | 6800 | 280 | 200 | 429.4 | 1762 | 326.61 | 930
 | 2001-02-28 00:00:00 |  | 200.76 | 5152 | 183.49 | 1328 | 338.36 | 10459 | 285.21 | 1523
 | 2001-02-27 00:00:00 |  | 202.25 | 2912 | 135 | 200 | 275.53 | 4475 | 267.2 | 795
 | 2001-02-26 00:00:00 |  | 248.21 | 5600 | 195 | 240 | 258.41 | 5480 | 226.05 | 950
 | 2001-02-25 00:00:00 |  |  |  |  |  |  |  | 181.6 | 2500 |  | 200 | 360
 | 2001-02-24 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 214.05 | 4252 | 232.89 | 760
 | 2001-02-23 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 296.91 | 1345 | 300 | 400
 | 2001-02-22 00:00:00 |  | 261 | 4000 | 200 | 200 | 233.22 | 2500 | 222.69 | 1730
 | 2001-02-21 00:00:00 |  | 283.75 | 4800 | 240 | 200 | 425 | 1050 | 372 | 750
 | 2001-02-20 00:00:00 |  | 326.82 | 4400 | 300 | 600 | 324.71 | 8650 | 350.06 | 1975
 | 2001-02-19 00:00:00 |  | 326.15 | 5200 | 300 | 600 | 382.2 | 4390 | 356.1 | 1540
 | 2001-02-18 00:00:00 |  |  |  |  |  |  |  | 399.12 | 4290 |  | 320 | 600
 | 2001-02-17 00:00:00 |  | 346.07 | 3360 | 320 | 200 | 397.33 | 8623 | 394.97 | 2510
 | 2001-02-16 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 444.06 | 5450 | 419.61 | 1985
 | 2001-02-15 00:00:00 |  | 448.85 | 5200 | 425 | 200 | 436.92 | 5630 | 480.72 | 1815
 | 2001-02-14 00:00:00 |  | 323 | 2000 | 300 | 0 | 601.45 | 2755 | 404.44 | 1970
 | 2001-02-13 00:00:00 |  | 307.5 | 2400 | 315 | 0 | 400.85 | 9115 | 379.49 | 2005
 | 2001-02-12 00:00:00 |  | 287.5 | 2400 | 277.5 | 0 | 380.82 | 9260 | 330.18 | 1690
 | 2001-02-11 00:00:00 |  |  |  |  |  |  |  | 398.34 | 5105 |  | 250 | 0
 | 2001-02-10 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.49 | 9007 | 373.04 | 3310
 | 2001-02-09 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.64 | 9525 | 391.75 | 2705
 | 2001-02-08 00:00:00 |  | 360.63 | 3200 | 300 | 48 | 407.79 | 7436 | 402.59 | 2830
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400 | 415.92 | 7768 | 431.28 | 1750
 | 2001-02-06 00:00:00 |  | 211.67 | 3600 | 200 | 600 | 458.43 | 2225 | 373.4 | 1560
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 159441d1338649094-data-validation-option-more-customised-approach-dependentdropdowns22
Sheet: Sheet2

Chemicals | Systems | Computers | Information |  |  | Teams
Storage | Here | Hardware | Some |  |  | Team A
Acquired | Are | Software | Things |  |  | Team B | The colored areas are "named" ranges.  Highlight a colored section
Delivery | Four | Processed | To |  |  | Team C | and look at the name box to the left of the formula bar, you will see
 | Options | Not Processes | Choose |  |  | Team D | the names.   Or press CTRL-F3 to open the Name Manager.
 |  |  |  |  |  |  | On sheet1, column A uses the named range [NAME] which is the gray section
 |  |  |  |  |  |  | The colored sections below each gray option is another named range that
 |  |  |  |  |  |  | matches the same word in the gray section
 |  |  |  |  |  |  | On sheet1, column B uses an INDIRECT() method to take the word selected
 |  |  |  |  |  |  | in column A as the name of the list to use in column B.
 |  |  |  |  |  |  | Research on Google on Dependent Drop Down lists for more detail.
 |  |  |  |  |  |  | See sheet1
 |  |  |  |  |  |  | If you change the option in colored to section to more/fewer, be sure to use the
 |  |  |  |  |  |  | CTRL-F3 name manager to edit the Defined range of the section so the drop
 |  |  |  |  |  |  | down on sheet1 stays clean.
Spreadsheet: 776224d1649615112-look-up-ids-that-meet-condition-on-sheet2-and-output-details-for-the-id-and-more-to-sheet1-test22v3xlsx
Sheet: Sheet2

 |  |  | ID | Family Name | First Name |  | Position Name |  | Status
 |  |  | 8450089035 | Smith | [NAME] |  | Reporting |  | Inactive
 |  |  | 8450089035 | Smith | [NAME] |  | Reporting |  | Inactive
 |  |  | 8450089035 | Smith | [NAME] |  | Reporting |  | Inactive
 |  |  | 309535517036 | Doe | [NAME] |  | Normal
 |  |  | 309535517036 | Doe | [NAME] |  | Normal |  | Inactive
 |  |  | 480673804039 | [NAME] | Julie |  | Reporting
 |  |  | 480673804039 | [NAME] | Julie |  | Reporting
 |  |  | 579059252100 | [NAME] | Gillian |  | Reporting
 |  |  | 579115681109 | [NAME] | Suzanne |  | [NAME]
Spreadsheet: 867432d1714285924-trying-to-find-the-earliest-and-latest-date-occurrence-in-year-earliest-and-latest-date-1-aligw
Sheet: Sheet1

 | Data Table |  |  | My curent table |  |  |  | Desired Results
 |  |  |  |  | Earliest | Latest |  |  | Earliest | Latest
 | 1996 | 2024-07-06 00:00:00 |  | 1996 |  | 2024-07-06 00:00:00 |  | 1996 | 2024-02-16 00:00:00 | 2024-07-06 00:00:00
 | 1996 | 2024-02-16 00:00:00 |  | 1997 |  |  |  | 1997 |  |  | Blank if no warnings that year
 | 1996 | 2024-05-15 00:00:00 |  | 1998 | 2024-02-12 00:00:00 | 2024-12-15 00:00:00 |  | 1998 | 2024-02-12 00:00:00 | 2024-12-15 00:00:00
 | 1998 | 2024-12-15 00:00:00 |  | 1999 | 2024-06-15 00:00:00 | 2024-06-15 00:00:00 |  | 1999 | 2024-06-15 00:00:00 | 2024-06-15 00:00:00
 | 1998 | 2024-04-13 00:00:00
 | 1998 | 2024-02-12 00:00:00 |  | Average |  |  |  | Average
 | 1999 | 2024-06-15 00:00:00
Spreadsheet: 868222d1714976502-date-wise-bank-balance-statement-required-sample
Sheet: Sheet2

 |  |  |  | 1525324308.87 | 1498034019.93
Date | Chq./Ref.No. | Value Dt | Withdrawal Amt. | Deposit Amt. | Closing Balance |  | Required
******** | ************ | ******** | ****************** | ****************** | ****************** |  | ******************
2024-04-01 00:00:00 | [NAME] | 2024-04-01 00:00:00 | 0 | 800000 | -81997915.44 |  | -81997915.44
2024-04-01 00:00:00 | BARBR52024040100725425 | 2024-04-01 00:00:00 | 0 | 200000 | -81797915.44 |  | -81797915.44
2024-04-01 00:00:00 | BARBR52024040100725433 | 2024-04-01 00:00:00 | 0 | 200000 | -81597915.44 |  | -81597915.44
2024-04-01 00:00:00 | IB01144537073548 | 2024-04-01 00:00:00 | 0 | 2010000 | -79587915.44 |  | -79587915.44
2024-04-01 00:00:00 | 0000409214298370 | 2024-04-01 00:00:00 | 0 | 300000 | -79287915.44 |  | -79287915.44
2024-04-01 00:00:00 | IB01162358713772 | 2024-04-01 00:00:00 | 0 | 6500000 | -72787915.44 |  | -72787915.44
2024-04-01 00:00:00 | IB01162416095917 | 2024-04-01 00:00:00 | 0 | 25000000 | -47787915.44 |  | -47787915.44
2024-04-01 00:00:00 | MAHBR52024040116949141 | 2024-04-02 00:00:00 | 0 | 350000 | -47437915.44 |  | -47787915.44
2024-04-01 00:00:00 | IB01175209338484 | 2024-04-03 00:00:00 | 0 | 225000 | -47212915.44 |  | -47787915.44
2024-04-02 00:00:00 | xyz | 2024-04-02 00:00:00 |  | 1 |  |  | -47437914.44
2024-04-03 00:00:00 | xyz | 2024-04-03 00:00:00 |  | 1 |  |  | -47212913.44
Spreadsheet: 60569d1261083859-printed-sheet-in-different-format-than-worksheet-printed
Sheet: WIP

SPONSOR | DEPT | ELEMENTS | DUE | BRIEF | FLIGHT | MEDIA | SUN APRV | ROUND 1 | FEEDBACK | ROUND 2 | APRV | PRODUCER/EDITOR | GRAPHIC VENDOR | PACKAGING | INTERNAL | STATUS | [NAME]
 |  | SPECTACLE
 |  | OOH
Infiniti | Design | 2-sheets, [NAME], CNN Wall | 2009-11-10 00:00:00 |  | 11/30 - 12/31 |  |  |  |  |  |  |  |  | Spectacle |  | DELIVERED | X
Infiniti | Desing | Times Square Addition |  |  | 11/30 - 12/31 |  |  |  |  |  |  |  |  | Spectacle |  |  | X
Infiniti |  | Print
 | Design | NYT ad Sunday Arts - Key art | 2009-11-30 00:00:00 |  | 2009-12-06 00:00:00 |  |  |  |  |  |  |  |  | Spectacle
 | Design | NYT ad Biz Section Front Right Read - Bono | 2009-11-30 00:00:00 |  | 2009-12-09 00:00:00 |  |  |  |  |  |  |  |  | Spectacle
Infiniti | Design | NYT ad Biz Section Back Page- Bruce | 2009-11-30 00:00:00 |  | 1/27? |  |  |  |  |  |  |  |  | Spectacle
Infiniti |  | On-Air
Infiniti | BE | VOD pre-roll | 2009-11-11 00:00:00 |  |  |  | 2009-01-27 00:00:00 |  |  |  |  | Steve/Lisa |  | Spectacle |  | DELIVERED 11/13 | X
Infiniti | BE | Season 1 promo | 2009-11-11 00:00:00 |  |  |  |  | 2009-11-06 00:00:00 |  |  |  |  |  | Spectacle |  | DELIVERED 11/6 | X
Infiniti | BE | Season 2 promo | 2009-11-20 00:00:00 |  |  |  |  | 2009-11-20 00:00:00 |  |  |  |  |  | Spectacle
Infiniti | BE | VOD Traffic Driver | 2009-11-24 00:00:00 |  |  |  |  | 2009-11-24 00:00:00 |  |  |  |  |  | Spectacle
Infiniti | BE | Digital Showcase | 2009-12-02 00:00:00 |  |  |  |  | 2009-11-30 00:00:00 |  |  |  |  |  | Spectacle
Spreadsheet: 236731d1368970294-different-real-cell-value-from-whats-showing-or-hidden-value-pls-help-activation-log
Sheet: Renewals 

Mobile Renewals
[NAME] | Phone # | Date | Equipment Model | IMEI | Post Paid Code |  | Rate Plan |  | Rate Plan Commission |  | Accessories | Total
 |  |  |  |  | 1yr | 2yr | $1.00-$49.99 | $50.00-$99.99 | $1.00-$49.99 | $50.00+
 |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0