tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 798998d1664870293-how-can-i-group-data-by-a-certain-attribute-example
Sheet: Tabelle1

Example Data
City | District | Plot Number | Owner First Name | Owner [NAME] | Staff member
Dresden | 2 | 45 | [NAME] | Tauber | [NAME]
Dresden | 2 | 45 | [NAME] | Tauber | [NAME]
Dresden | 2 | 62 | Manfred | Maurer | [NAME]
Dresden | 3 | 78 | Gesine | Held | [NAME]
Dresden | 3 | 23 | [NAME] | Zänker | [NAME]
Dresden | 3 | 8 | Gesine | Held | [NAME]
Berlin | 8 | 6 | [NAME] | Tauber | [NAME]
Berlin | 8 | 42 | Anne | [NAME] | [NAME]
Berlin | 8 | 39 | [NAME] | Tauber | [NAME]
Berlin | 8 | 39 | [NAME] | Tauber | [NAME]
Berlin | 9 | 78 | [NAME] | Zänker | [NAME]
Berlin | 9 | 24 | [NAME] | Tauber | [NAME]
What I want:
Owner First Name | Owner [NAME] | City | District | Plot Number | Staff member
[NAME] | Tauber | Dresden | 2 | 45 | [NAME]
[NAME] | Tauber | Berlin | 8 | 6 | [NAME]
[NAME] | Tauber | Berlin | 9 | 24 | [NAME]
[NAME] | Tauber | Berlin | 8 | 39 | [NAME]
[NAME] | Tauber | Dresden | 2 | 45 | [NAME]
[NAME] | Tauber | Berlin | 8 | 39 | [NAME]
Manfred | Maurer | Dresden | 2 | 62 | [NAME]
Gesine | Held | Dresden | 3 | 78 | [NAME]
Gesine | Held | Dresden | 3 | 8 | [NAME]
[NAME] | Zänker | Dresden | 3 | 23 | [NAME]
[NAME] | Zänker | Berlin | 9 | 78 | [NAME]
Anne | [NAME] | Berlin | 8 | 42 | [NAME]
Spreadsheet: 679570d1590504572-average-ifs-with-multiple-criteria-and-multiple-dynamic-columns-excel-help-average-with-multiple
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Result
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday |  |  | Monday
 | 08:00:00 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 14 |  | 08:00:00
 | 08:15:00 | 23 | 69 | 115 | 161 | 207 | 253 | 299 | 345 | 391 | 437 | 483 | 529 | 575 | 621 | 69 |  | 08:15:00
 | 08:30:00 | 45 | 12 | 217 | 263.333333333333 | 349.333333333333 | 435.333333333333 | 521.333333333333 | 607.333333333333 | 693.333333333333 | 779.333333333333 | 865.333333333333 | 951.333333333333 | 1037.33333333333 | 1123.33333333333 | 12 |  | 08:30:00
 | 08:45:00 | 78 | 2 | 319 | 374 | 494.5 | 615 | 735.5 | 856 | 976.5 | 1097 | 1217.5 | 1338 | 1458.5 | 1579 | 2 |  | 08:45:00
 | 09:00:00 | 45 | 9 | 421 | 534.333333333333 | 722.333333333333 | 910.333333333333 | 1098.33333333333 | 1286.33333333333 | 1474.33333333333 | 1662.33333333333 | 1850.33333333333 | 2038.33333333333 | 2226.33333333333 | 2414.33333333333 | 9 |  | 09:00:00
 | 09:15:00 | 1 | 65 | 129 | 193 | 257 | 321 | 385 | 449 | 513 | 577 | 641 | 705 | 769 | 833 | 65 |  | 09:15:00
 | 09:30:00 | 11 | 25 | 39 | 53 | 67 | 81 | 95 | 109 | 123 | 137 | 151 | 165 | 179 | 193 | 25 |  | 09:30:00
 | 09:45:00 | 45 | 62 | 79 | 96 | 113 | 130 | 147 | 164 | 181 | 198 | 215 | 232 | 249 | 266 | 62 |  | 09:45:00
 | 10:00:00 | 65 | 47 | 29 | 17 | 1.66666666666671 | 179 | 199 | 219 | 239 | 259 | 279 | 299 | 319 | 339 | 47 |  | 10:00:00
 | 10:15:00 | 78 | 12 | 4 | 182 | 205 | 228 | 251 | 274 | 297 | 320 | 343 | 366 | 389 | 412 | 12 |  | 10:15:00
 | 10:30:00 | 23 | 1 | 6 | 11 | 16 | 21 | 26 | 31 | 36 | 41 | 46 | 51 | 56 | 485 | 1 |  | 10:30:00
Spreadsheet: 46704c70-9c48-47c3-9a39-b4201ebc5ed6
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42827363 | 2014-08-22 05:19:27 | ALLIES | 1 | 5 | 4 | 590115 | SgtBob49 | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42827515 | 2014-08-22 05:33:48 | AXIS | 1 | 5 | 1 | 590115 | SgtBob49 | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42827655 | 2014-08-22 05:42:16 | AXIS | 0 | 4 | 6 | 590115 | SgtBob49 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
42827726 | 2014-08-22 05:49:25 | ALLIES | 1 | 6 | 2 | 590115 | SgtBob49 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
42926477 | 2014-08-29 05:47:58 | ALLIES | 1 | 6 | 5 | 414482 | [NAME] | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42926744 | 2014-08-29 06:20:06 | AXIS | 1 | 6 | 3 | 414482 | [NAME] | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42954255 | 2014-08-31 05:14:10 | ALLIES | 0 | 3 | 6 | 414482 | [NAME] | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
42954414 | 2014-08-31 [NAME] | AXIS | 0 | 4 | 6 | 414482 | [NAME] | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
42969968 | 2014-09-01 05:20:37 | ALLIES | 0 | 2 | 6 | 1502391 | Benaiah3 | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
42970141 | 2014-09-01 05:36:56 | AXIS | 0 | 3 | 6 | 1502391 | Benaiah3 | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
Spreadsheet: 187295d1350400028-hi-need-2-make-a-schedule-with-some-events-taking-place-on-a-specific-day-of-the-week-task-completion-schedule
Sheet: Main Page

 | Prgram Start Date:
 | 2013-01-01 00:00:00
 | Date | Task to Complete
2012-10-03 00:00:00 | 2012-10-01 00:00:00 | send customer account info sheet
2012-10-28 00:00:00 | 2012-10-26 00:00:00 | submit account info sheet for processing
2012-11-10 00:00:00 | 2012-11-08 00:00:00 | receive list of users from account
2012-12-02 00:00:00 | 2012-11-30 00:00:00 | notify vendor of new account
2012-12-07 00:00:00 | 2012-12-05 00:00:00 | receive sign copy of program usage agreement from account
2012-12-17 00:00:00 | 2012-12-15 00:00:00 | user data upload
2012-12-26 00:00:00 | 2012-12-24 00:00:00 | send users login information
2012-12-27 00:00:00 | 2012-12-25 00:00:00 | training session
2012-12-29 00:00:00 | 2012-12-27 00:00:00 | training session
2012-12-31 00:00:00 | 2012-12-29 00:00:00 | update company website with new program link
Spreadsheet: 01f2d7a0-a480-43f1-88c7-981f87366ffc
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
PARAV | Test | PARAV | Parainfluenza Virus (Types 1, 2, 3) Antibodies, Serum | Parainfluenza (Types 1, 2, 3) Ab, S | Complement Fixation (CF) | Plain, Red-Top or serum gel tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). Spin down and send 1 mL of serum refrigerated. Note: Serum gel tube is acceptable, but must pour off into a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | REFERENCE RANGE: < 1:8   INTERPRETIVE CRITERIA: < 1:8 Antibody Not Detected > or =1:8 Antibody Detected   Single titers > or = 1:64 are indicative of recent infection. Titers of 1:8 to 1:32 may be indicative of either past or recent infection, since CF antibody levels persist for only a few months.  A four-fold or greater increase in titer between acute and convalescent specimens confirms the diagnosis. After initial infection, antibody responses at a later date are often heterotypic and exhibit crossreactivity with other paramyxoviruses (e.g., mumps).   Test Performed by: Focus Diagnostics, Inc.                              5785 Corporate Avenue                              Cypress, CA  90630-4750 | Monday through Friday | 2 - 5 days | 4 - 9 days | 3 | 86790 |  |  |  |  | Focus Diagnositics, Inc.
PARAV | [NAME] | SERUM | Serum |  |  |  | Ambient | 7 days
PARAV | Result | Z0577 | Parainfluenza 1 Ab | Parainfluenza 1 Ab | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PARAV | Result | [NAME] | Parainfluenza 2 Ab | Parainfluenza 2 Ab | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PARAV | Result | Z0325 | Parainfluenza 3 Ab | Parainfluenza 3 Ab | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 455866d1460541933-how-to-get-names-from-a-list-based-on-multiple-criteria-example
Sheet: Datbase Data

Reg | Sale Date | Salesman | Location
DK13GHA | 2016-04-13 00:00:00 | N.Smith | [NAME]
DK13GHB | 2016-04-13 00:00:00 | T.Dobbs | [NAME]
DK13GHC | 2016-03-05 00:00:00 | N.Smith | London
GH14FGH | 2016-04-06 00:00:00 | G.Harrold | Birmingham
GH12JKB | 2016-04-13 00:00:00 | K.Ball | Birmingham
LK12HKJ | 2016-03-05 00:00:00 | N.Smith | London
FV15JKL | 2016-03-10 00:00:00 | S.Walker | London
FV16HJY | 2016-03-10 00:00:00 | S.Walker | London
Spreadsheet: 37360d1235352448-automatically-place-player-based-results-and-player-ranking-tree
Sheet: Sheet1

Rank |  | Score | Rank
(1) | Sandra | 18
 |  |  | (2) | [NAME]
(32) | [NAME] | 72
(2) | [NAME] | 63
 |  |  | (32) | [NAME]
(31) | [NAME] | -28
(3) | Martin | 57
 |  |  | (3) | Martin
(30) | [NAME] | 3
(4) | Corinne | 70
 |  |  | (4) | Corinne
(29) | Stuart | -42
Spreadsheet: 215519d1361396499-counting-duplicates-sampledup
Sheet: Sheet1

DATERECD | DUPSerial | DUPFlag | DUPCount
2012-02-27 00:00:00 | 40956_6.92_29 | Duplicate | 1
2012-07-21 00:00:00 | 40956_6.92_29 | Duplicate | 2
2012-03-16 00:00:00 | 40969_12.91_86 | Duplicate | 1
2012-04-05 00:00:00 | 40969_12.91_86 | Duplicate | 2
2012-03-24 00:00:00 | 40975_71.04_120 | Duplicate | 1
2012-04-27 00:00:00 | 40975_71.04_120 | Duplicate | 2
2012-06-07 00:00:00 | 41035_108.08_275 | Duplicate | 1
2012-09-19 00:00:00 | 41035_108.08_275 | Duplicate | 2
2012-05-31 00:00:00 | 41051_953.01_1550 | Duplicate | 1
2012-06-02 00:00:00 | 41051_953.01_1550 | Duplicate | 2
2012-06-13 00:00:00 | 41052_73.15_120 | Duplicate | 1
2012-06-27 00:00:00 | 41052_73.15_120 | Duplicate | 2
2012-07-16 00:00:00 | 41086_59.05_159 | Duplicate | 1
2012-08-16 00:00:00 | 41086_59.05_159 | Duplicate | 2
2012-07-20 00:00:00 | 41088_8.57_41 | Duplicate | 1
2012-08-23 00:00:00 | 41088_8.57_41 | Duplicate | 2
2012-08-14 00:00:00 | 41106_200.94_1043 | Duplicate | 1
2012-10-15 00:00:00 | 41106_200.94_1043 | Duplicate | 2
2012-11-01 00:00:00 | 41106_200.94_1043 | Duplicate | 3
Spreadsheet: 47430d1246466681-row-of-data-within-a-time-period-book111
Sheet: Sheet1

 | 1
 | 2
 | 2
 | 3
 | 4
 | 3
 | 4
 | 3
 | 2
 | 3 | 3
 | 4
 | 3 | 3
 | 2 | 2
 | 3 | 3
 | 4 | 4
 | 5
 | 4 | 4
 | 3 | 3
 | 4 | 4
 | 5
 | 3 | 3
 | 4 | 4
 | 5
 | 3 | 3
 | 2 | 2
 | 3 | 3
 | 45
Spreadsheet: vkaminski__40900__CASH_GasMat_0400MyCopy
Sheet: Taxes

CASH / BOOK TAXES ($000)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Offset For
Current Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "Tax_Table"
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  | 1
Months Of Operation
CASH TAXES
Taxable Income Calculation (Excluding Sudam)
Earnings Before Depr, Int, & Taxes
Plus: [NAME] To Cash Adjustment
Less: Tax Depreciation
Less: Interest Expense (Before W/H Tax)
Less: IDC To Be Expensed
Less: INE Interest Expense
Net Income Before NOL Carryforward
NOL Used In Current Year | See Below
Net Income Subject To Income Taxes (w/o [NAME])
Net Operating Loss Calculation (Normal Taxes)
Beginning NOL Balance |  |  | 0
Prior Year's NOL
NOL Used In Current Year
Ending NOL Balance
Corporate Income Tax
Net Income Subject To Income Tax (w/o [NAME])
Times: Corporate Income Tax
Total Corporate Income Tax Payable
Additional Income Tax
Net Income Subject To Income Tax (w/o [NAME])
Less: Amount Not Subject To Add'l Tax
Income Subject To Additional Tax
Times: Additional Tax
Total Additional Tax
Subtotal Corporate Income Tax & Additional Income Tax
[NAME] Used (See Sudam Tax Credit Calculation)
Net Corporate Tax & Additional Tax Payable
Social Contribution Tax
Net Income Subject To Income Tax (w/o [NAME])
Times: Social Contribution Tax Rate
Total Social Contribution Tax
Total Cash Taxes (Excluding [NAME])
Tax Savings Under [NAME] (Applied To Reserve)
Total Cash Taxes
Effective Corporate Tax Rate
BOOK TAXES
Corporate Income Tax (Before Sudam Credit)
Additional Income Tax (Before Sudam Credit)
Social Contribution Tax
Total Cash Taxes (Excluding [NAME])
Plus: Tax Depreciation
Less: Book Depreciaiton
Less: [NAME] To Cash Adjustment
Total Temporary Differences
Corporate Income Tax
Total Temporary Differences
Times: Corporate Income Tax
Total Corporate Income Tax Payable
Additional Income Tax
Total Temporary Differences
Times: Additional Tax
Total Additional Tax
Social Contribution Tax
Total Temporary Differences
Times: Social Contribution Tax Rate
Total Social Contribution Tax
Total Cash Taxes (Excl Sudam Credit & Temp Differences)
Total Cash Taxes On Temporary Differences
Book Provision For Income Tax
Deferred Tax Asset / Liability
Beginning Deferred Tax Asset / (Liability) |  |  | 0
Plus: Current Year Cash Taxes (Excluding Sudam Benefits)
Less: Current Year Book Taxes
Ending Deferred Tax Asset / (Liability)
Spreadsheet: 82480d1282562465-rounding-hours-forward-and-back-book1
Sheet: Sheet1

Biweekly Employee Time Sheet
 |  |  |  |  | Employee Name:
 |  |  |  |  | Manager [NAME]:
 |  |  |  |  | Week Starting:
Date | Time In | Time Out |  | Time In | Time Out | Total Hrs | [NAME] | HOL | VAC | SICK
 | 23:00:00 | 02:00:00 |  | 03:00:00 | 07:00:00
 | 19:00:00 | 00:00:00 |  | 01:00:00 | 04:00:00
 |  |  |  |  |  | TOTAL
 |  | Employee Signature |  |  |  |  |  | Date
 |  | Manager Signature |  |  |  |  |  | Date
Spreadsheet: 4c8e69d6-ecd9-46bb-aac7-7405f4ab31e5
Sheet: Sheet1

1.3.8 - Evolución de los ingresos de la Unión Europea y de los pagos a la [NAME]. En millones de euros. 1990-2007 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Ingresos líquidos procedentes de la UE |  |  |  |  |  |  | Pagos líquidos a la UE | Saldo
 | FEOGA-Garantía | FEOGA-Orientación | FEDER | FSE | Fondo de Cohesión | Otros | Total
1990 | 1634.752923923888 | 90.15181565756734 | 829.3967040496196 | 318.5364153234046 | - | 96.16193670140517 | 2968.999795655885 | 2253.795391439184 | 715.2044042167008
1991 | 2548.291322587237 | 438.7388362001611 | 1700.864255406104 | 805.3562198742683 | - | 126.2125419205943 | 5619.463175988364 | 3281.526089935452 | 2337.937086052912
1992 | 2752.635438077723 | 468.7894414193502 | 1881.167886721239 | 643.0829516906471 | - | 120.2024208767565 | 5865.878138785715 | 3894.558436406909 | 1971.319702378806
1992 | 3618.092868390369 | 631.0627096029714 | 1682.83389227459 | 637.0728306468092 | 192.3238734028103 | 30.05060521918912 | 6791.43677953674 | 4453.499693483826 | 2337.937086052913
1994 | 4207.084730686476 | 282.4756890603777 | 1562.631471397834 | 462.7793203755124 | 366.6173836741073 | 36.06072626302694 | 6917.649321457335 | 4826.127198201772 | 2091.522123255563
1995 | 4450 | 850 | 2691 | 1472 | 1023 | 56 | 10542 | 3702 | 6840
1996 | 3887 | 932 | 2521 | 1270 | 1265 | 51 | 9926 | 4443 | 5483
1997 | 4535 | 731 | 2547 | 1816 | 723 | 56 | 10408 | 5412 | 4996
1998 | 5317 | 1096 | 2823 | 1746 | 1184 | 55 | 12221 | 5915 | 6306
1999 | 5237 | 1410 | 3727 | 1969 | 1111 | 63 | 13517 | 6324 | 7193
2000 | 5482 | 514 | 2819 | 797 | 1197 | 48 | 10857 | 6558 | 4299
2001 | 6170 | 628 | 3381 | 1085 | 869 | 53 | 12186 | 6676 | 5510
2002 | 5933 | 978 | 4046 | 1795 | 2121 | 78 | 14951 | 6603 | 8348
2003 | 6459 | 1274 | 5344 | 1653 | 1807 | 79 | 16616 | 7942 | 8674
2004 | 6319 | 1127 | 4712 | 1774 | 1908 | 68 | 15908 | 8098 | 7810
2005 | 6407 | 1270 | 3851 | 1784 | 1391 | 100 | 14803 | 9929 | 4874
2006 (*) | 6655 | 1095 | 2214 | 1251 | 1283 | 137 | 12635 | 10275 | 2360
2007 (*) | 5713 | 1024 | 2761 | 1691 | 813 | 50 | 12052 | 9885 | 2167
(*) Datos provisionales.
Fuente: Elaboración [NAME] a partir de Banco de España, [NAME] estadístico, varios [NAME].
Spreadsheet: 858000d1706808414-formula-to-place-worksheet-name-in-cell-on-another-worksheet-sample-sheet
Sheet: Sup 1

 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 |  |  |  | Team Score
 |  |  |  | Updated 12/27/23
Spreadsheet: 170923d1343508394-counting-sequences-trends-1-
Sheet: sheet1

P/B |  | 1 | 2 | 0
2
2 |  |  |  |  |  | There are 1 consecutive P's
2 |  |  |  |  |  | There are 1 consecutive B's
2 |  |  | 4 |  |  | There are 1 consecutive T's
1
1
1 |  | 3
0
0
0
0 |  |  |  | 4
Spreadsheet: adbf5831-a5ae-4c3e-b983-44ef886f1bcf
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7946 | 65434 | [NAME] | [NAME] | USA | 2585 | 00:19:27 | 00:05:56 | 00:48:13 | 00:05:21 | 00:32:42 | 1 | 01:51:41
7946 | 8141 | Celeste | Callahan | USA | 2583 | 00:19:11 | 00:06:37 | 00:49:52 | 00:06:34 | 00:33:42 | 2 | 01:55:59
7946 | 65435 | [sarah] Fairbairn | Powers | USA | 2584 | 00:27:08 | 00:08:49 | 00:49:51 | 00:07:55 | 00:42:01 | 3 | 02:15:46
Spreadsheet: 848215d1698979193-how-to-calculate-a-pay-rate-that-is-affected-by-2-different-pay-conditions-pay-calculator_normal-pay-without-extra-days
Sheet: 40hr Build-Up Time

 |  |  |  | ADD ANNUAL LEAVE, SICK DAY |  |  |  |  | THIS IS NOT PICKING UP SICK DAY AND CHECK THE OTHERS
DATE | DAY | SHIFT [NAME] |  | WORK TIME | PUBLIC HOLIDAY | RDO | ADO | ANNUAL LEAVE | SICK DAY |  | NORMAL TIME | CUMULATIVE TIME | BALANCE |  | WEEKDAY OVERTIME | CUMULATIVE TIME | BALANCE |  | SATURDAY OVERTIME | CUMULATIVE TIME | BALANCE |  | SUNDAY OVERTIME | CUMULATIVE TIME | BALANCE |  | HOURS PAID BY EMPLOYER
WEEK 1
 |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  | 0 |  |  |  | 0
2022-09-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
2022-09-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
2022-09-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
2022-09-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
2022-09-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
2022-09-24 00:00:00 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
WEEK 2
2022-09-25 00:00:00 |  |  |  |  |  | 0 | 0 | N/A | N/A |  | 0 | 0 |  |  | 0 |  |  |  | 0
2022-09-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
2022-09-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
2022-09-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
2022-09-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
2022-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
2022-10-01 00:00:00 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | OVERTIME
Spreadsheet: 327731d1403668906-scheduling-and-auto-populating-time-of-dl-schedule-blue-print
Sheet: RTOs

NAME | DATE | RTO |  | 2014-07-11 00:00:00
[NAME] | 2014-07-12 00:00:00 | RTO | [NAME]
[NAME] | 2014-07-13 00:00:00 | RTO | [NAME]
 |  | RTO | [NAME]
 |  | RTO | [NAME]
 |  | RTO | Brittny
 |  | RTO | [NAME]
 |  | RTO | [NAME]
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO |  | When I add something to the left table I need excel to look at the name and date and if there is a spot on the schedule for it put an "RTO" there. I need to be able to change the dates at the top and the formula auto populate the letters "RTO" if there is an entry on the left.
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
 |  | RTO
Spreadsheet: larry_campbell__21461__Stor021800
Sheet: LiquidatedPosition

ForwardDate | CityGate_NM | MTM | Volume
1999-06-01 00:00:00 | CA-PG&E | 426092.505 | 485923
1999-06-01 00:00:00 | CA-SDG&E | 69133.02 | 135451
1999-06-01 00:00:00 | CA-SOCAL Gas | 819893.94 | 574727
1999-06-01 00:00:00 | Chicago CG | 2656175 | 1690000
1999-06-01 00:00:00 | OH-Columbia of Ohio | 2000186.188955 | 819779
1999-06-01 00:00:00 | OH-East Ohio Gas | 1207577.55 | 892310
1999-07-01 00:00:00 | CA-PG&E | 389550.63 | 152466
1999-07-01 00:00:00 | CA-SDG&E | 98284.48 | 41296
1999-07-01 00:00:00 | CA-SOCAL Gas | 604746.1 | 254095
1999-07-01 00:00:00 | Chicago CG | 777900 | 930000
1999-07-01 00:00:00 | OH-Columbia of Ohio | 149240.867868 | 60221
1999-07-01 00:00:00 | OH-East Ohio Gas | 1240332 | 900000
1999-08-01 00:00:00 | CA-SOCAL Gas | 0 | 251540
1999-08-01 00:00:00 | Chicago CG | 731767 | 800000
1999-08-01 00:00:00 | OH-East Ohio Gas | 1259545 | 371000
1999-09-01 00:00:00 | CA-SOCAL Gas | 0 | 251540
1999-09-01 00:00:00 | Chicago CG | 540799.7 | 570000
1999-10-01 00:00:00 | CA-PG&E | 29854.44 | 104484
1999-10-01 00:00:00 | CA-SDG&E | -1622.56 | 20282
1999-10-01 00:00:00 | CA-SOCAL Gas | -39904.6 | 751540
1999-10-01 00:00:00 | Chicago CG | 116020.5 | 2644000
1999-10-01 00:00:00 | Nat Fuels Gas Supply | 101643.12 | 68304
1999-10-01 00:00:00 | OH-East Ohio Gas | 161494.42 | 673620
1999-10-01 00:00:00 | PA-National Fuel Gas Dist. | 0 | 295024
1999-10-01 00:00:00 | PA-Peoples Natural Gas | 212339.202477 | 149851
1999-11-01 00:00:00 | Chicago CG | -265257.1 | 650000
1999-11-01 00:00:00 | Nat Fuels Gas Supply | 0 | 0
1999-12-01 00:00:00 | Chicago CG | -1806671.4 | 3780000
1999-12-01 00:00:00 | CNG POOL | -8346.8 | 40000
1999-12-01 00:00:00 | Nat Fuels Gas Supply | -16708.52609 | 42054
1999-12-01 00:00:00 | NYMEX | 0 | 200000
1999-12-01 00:00:00 | OH-Columbia of Ohio | -827736.737363 | 690000
1999-12-01 00:00:00 | OH-East Ohio Gas | -1304400 | 2140000
1999-12-01 00:00:00 | PA-Peoples Natural Gas | -104415.656979 | 150000
2000-01-01 00:00:00 | CA-PG&E | -732829.3175 | 846413
2000-01-01 00:00:00 | CA-SDG&E | -148201.87 | 92533
2000-01-01 00:00:00 | CA-SOCAL Gas | -1067826.12 | 1176908
2000-01-01 00:00:00 | Chicago CG | -1932870 | 3890000
2000-01-01 00:00:00 | Nat Fuels Gas Supply | -71206.9595 | 191350
2000-01-01 00:00:00 | NYMEX | 0 | 640000
2000-01-01 00:00:00 | OH-Columbia of Ohio | -1910202.673573 | 4050000
2000-01-01 00:00:00 | OH-East Ohio Gas | -1551200 | 4840000
2000-01-01 00:00:00 | PA-Peoples Natural Gas | -141854.195661 | 200000
Spreadsheet: 846088d1697390614-calculating-public-holidays-when-removing-and-adding-another-from-tables-sample
Sheet: Sheet1

Start Date | 2023-01-01 00:00:00 | End Date |  |  |  |  |  | 2023-01-31 00:00:00
Public Holidays
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  | Thursday | Friday | Saturday | Sunday
Current Public Holidays
Date | Holiday Name | Day | Override Date | Override Name | New Date | New Holiday Name | New Day |  | Public Holidays Support Requ'd: | YES
2023-01-01 00:00:00 | Public Holiday 1
2023-01-02 00:00:00 | Public Holiday 2 |  |  |  |  |  |  |  | Another Day In Lieu of Public Holiday | YES
2023-01-03 00:00:00 | Public Holiday 3
2023-01-04 00:00:00 | Public Holiday 4 |  |  |  |  |  |  |  | Select Public Holiday ignored | Public Holiday 7
2023-01-05 00:00:00 | Public Holiday 5
2023-01-06 00:00:00 | Public Holiday 6 |  | 2023-06-02 00:00:00 | My Holiday
2023-01-07 00:00:00 | Public Holiday 7
2023-01-08 00:00:00 | Public Holiday 8
2023-01-09 00:00:00 | Public Holiday 9
2023-01-10 00:00:00 | Public Holiday 10
2023-01-11 00:00:00 | Public Holiday 11
2023-01-12 00:00:00 | Public Holiday 7
2023-01-13 00:00:00 | Public Holiday 13
2023-01-14 00:00:00 | Public Holiday 14
 |  |  | 2023-05-04 00:00:00 | My Birthday