tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 867609d1714439810-line-of-credit-schedule-schedue-of-rates-bixha-
Sheet: Data

Name | Starting Rate date | Payment Frequency Options | Number of rates | Next Rate 1 | Next Rate 2 | Next Rate 3 | Next Rate 4 | Next Rate 5
X1 | 2023-01-07 00:00:00 | Annual | 5 |  |  |  |  |  | Annual
X2 | 2024-01-07 00:00:00 | Annual | 5 |  |  |  |  |  | Monthly
X3 | 2022-12-27 00:00:00 | Annual | 5
X4 | 2020-01-16 00:00:00 | Annual | 5
X5 | 2019-04-18 00:00:00 | Monthly | 30
X6 | 2019-06-24 00:00:00 | Monthly | 12
X7 | 2019-07-24 00:00:00 | Monthly | 50
X8 | 2019-08-14 00:00:00 | Annual | 5
X9 | 2019-10-04 00:00:00 | Annual | 5
X10 | 2019-10-04 00:00:00 | Annual | 6
X11 | 2019-10-31 00:00:00 | Annual | 6
X12 | 2019-11-01 00:00:00 | Annual | 7
X13 | 2019-12-03 00:00:00 | Annual | 8
X14 | 2019-11-27 00:00:00 | Annual | 9
X15 | 2019-12-26 00:00:00 | Annual | 10
X16 | 2019-12-18 00:00:00 | Annual | 12
X17 | 2019-09-19 00:00:00 | Annual | 5
X18 | 2019-10-30 00:00:00 | Annual | 5
X19 | 2019-11-27 00:00:00 | Annual | 5
X20 | 2018-07-26 00:00:00 | Annual | 5
X21 | 2018-09-28 00:00:00 | Annual | 5
X22 | 2019-08-09 00:00:00 | Annual | 5
X23 | 2019-07-31 00:00:00 | Annual | 5
X24 | 2019-09-19 00:00:00 | Annual | 5
X25 | 2019-11-27 00:00:00 | Annual | 5
[NAME] | 2019-12-03 00:00:00 | Annual | 5
X27 | 2019-03-20 00:00:00 | Monthly | 60
X28 | 2018-02-08 00:00:00 | Monthly | 30
X29 | 2018-05-03 00:00:00 | Monthly | 60
X30 | 2018-07-19 00:00:00 | Monthly | 60
X31 | 2019-03-01 00:00:00 | Monthly | 60
X32 | 2019-02-25 00:00:00 | Monthly | 60
X33 | 2019-04-15 00:00:00 | Monthly | 60
X34 | 2019-04-15 00:00:00 | Annual | 1
X35 | 2019-04-18 00:00:00 | Annual | 5
X36 | 2019-06-18 00:00:00 | Annual | 5
Spreadsheet: 144046d1330695540-hlookup-autofill-row_index_number-help-filling-series
Sheet: Sheet1

Jan | Feb | Mar |  |  |  |  |  | Jan
0 | 0 | 0
0
0 | 0 | 0
-709623 | -680548 | -681490
415692 | 396121 | 393635 |  |  |  |  |  |  |  | ** I manually created these formulas and am trying to copy down…
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
211422 | 203641 | 203641
-207194 | -199568 | -199568
11753 | 11321 | 11321
311 | 300 | 300
17534 | 16889 | 16889
8436 | 8125 | 8125 |  |  |  |  |  |  |  | ** these are my results - just duplicating the Row_Index_number … instead of filling the series
2537 | 2444 | 2444
0 | 0 | 0
15222 | 14662 | 14662
2651 | 2544 | 2544
1000 | 1000 | 1000
250 | 250 | 250
0 | 0 | 0
500 | 500 | 500
1200 | 1200 | 1200
225 | 225 | 225
0 | 0 | 0
0 | 0 | 100
800 | 800 | 800
0 | 0 | 0
600 | 600 | 600
600 | 600 | 600
196 | 197 | 198
5322 | 5104 | 5111
9280 | 9280 | 10058
1416 | 1416 | 1416
1500 | 1500 | 1500
1866 | 1866 | 1866
4500 | 4500 | 4500
450 | 450 | 450
0 | 0 | 0
13014 | 13014 | 13014
17894 | 17894 | 22368
1433 | 1433 | 1791
40 | 40 | 49
1288 | 1288 | 1610
215 | 215 | 268
600 | 600 | 600
900 | 900 | 900
51978 | 49169 | 52495
11115 | 12181 | 23634
0 | 0 | 0
0 | 0 | 0
100 | 100 | 100
200 | 200 | 200
0 | 0 | 1500
0 | 0 | 0
0 | 0 | 0
250 | 250 | 250
0 | 0 | 0
0 | 0 | 0
1000 | 1000 | 1000
5000 | 5000 | 5000
Spreadsheet: 831344d1685558560-auto-populate-date-field-based-on-4-4-5-fiscal-month-chart-sample
Sheet: Sheet1

 | Reporting Date: | 2023-06-01 00:00:00
 |  | chart defaults to display full calendar month of reporting date
 | Day | Job variance | Adjustments | Budget | Total | Cumulative budget | Cumulative MTD | Sparklines |  |  | Fiscal Month | Weeks | Start date
 |  |  |  |  |  |  |  |  |  |  | FM 1 | 4 | 2022-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  | FM 2 | 4 | 2023-01-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  | FM 3 | 5 | 2023-02-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  | FM 4 | 4 | 2023-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | FM 5 | 4 | 2023-04-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  | FM 6 | 5 | 2023-05-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  | FM 7 | 4 | 2023-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | FM 8 | 4 | 2023-07-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  | FM 9 | 5 | 2023-09-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  | FM 10 | 4 | 2023-09-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  | FM 11 | 4 | 2023-10-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  | FM 12 | 5 | 2023-11-25 00:00:00
Spreadsheet: 750814d1633644244-search-row-for-2-matches-and-sum-collumn-below-excel-help-forum
Sheet: revenue x

Year |  | January | February | March | April | May | June | July | August | September | October | November | December
2022 | Branch 1 | 259200 | 268800 | 446400.0000000001 | 576000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Branch 2 | 28800 | 268800 | 446400.0000000001 | 576000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Branch 3 | 0 | 57600 | 297600 | 432000.0000000001 | 595200 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Branch 4 | 0 | 0 | 124800 | 288000 | 446400.0000000001 | 576000 | 0 | 0 | 0 | 0 | 0 | 0
 | Branch 5 | 0 | 0 | 0 | 172800 | 297600 | 432000.0000000001 | 595200 | 0 | 0 | 0 | 0 | 0
 | Branch 6 | 0 | 0 | 0 | 0 | 240000 | 288000 | 446400.0000000001 | 595200 | 0 | 0 | 0 | 0
 | Branch 7 | 0 | 0 | 0 | 0 | 0 | 288000 | 446400.0000000001 | 595200 | 0 | 0 | 564111 | 0
 | Branch 8 | 0 | 0 | 0 | 0 | 0 | 48000 | 297600 | 446400.0000000001 | 576000 | 45665 | 156632 | 86954
 | Branch 9 | 0 | 0 | 0 | 0 | 0 | 0 | 115200 | 297600 | 432000.0000000001 | 595200 | 29555 | 45955
2023 | Branch 1 | 259200 | 268800 | 446400.0000000001 | 576000 | 125111 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Branch 2 | 28800 | 268800 | 446400.0000000001 | 576000 | 96888 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Branch 3 | 69555 | 57600 | 297600 | 432000.0000000001 | 595200 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Branch 4 | 45411 | 14555 | 124800 | 288000 | 446400.0000000001 | 576000 | 0 | 0 | 0 | 0 | 0 | 0
 | Branch 5 | 0 | 0 | 0 | 172800 | 297600 | 432000.0000000001 | 595200 | 0 | 0 | 0 | 0 | 0
 | Branch 6 | 0 | 0 | 0 | 0 | 240000 | 288000 | 446400.0000000001 | 595200 | 0 | 0 | 0 | 0
 | Branch 7 | 0 | 0 | 0 | 0 | 0 | 288000 | 446400.0000000001 | 595200 | 0 | 432000.0000000001 | 595200 | 0
 | Branch 8 | 0 | 0 | 0 | 0 | 0 | 48000 | 297600 | 446400.0000000001 | 576000 | 288000 | 446400.0000000001 | 595200
 | Branch 9 | 0 | 0 | 0 | 0 | 0 | 0 | 115200 | 297600 | 432000.0000000001 | 288000 | 446400.0000000001 | 595200
Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -110977 | -108476
2 | -126065 | -133671
3 | -159519 | -157560
4 | -159784 | -158380
5 | -155647 | -154469
6 | -183350 | -180577
7 | -117148 | -116037
8 | -149643 | -148722
9 | -146498 | -145412
10 | -132398 | -131168
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | -12760
2001-07-10 00:00:00
Spreadsheet: 864792d1711931705-conditional-formatting-to-highlight-percentages-question2
Sheet: Holidays log

 |  |  | Employees | Dates
 |  |  | [NAME] | 2024-09-12 00:00:00
 |  |  | [NAME] | 2024-09-09 00:00:00
 |  |  | [NAME] | 2024-06-20 00:00:00
 |  |  | [NAME] | 2024-08-21 00:00:00
 |  |  | [NAME] | 2024-03-26 00:00:00
 |  |  | [NAME] | 2024-09-01 00:00:00
 |  |  | [NAME] | 2024-04-23 00:00:00
 |  |  | [NAME] | 2024-02-10 00:00:00
 |  |  | [NAME] | 2024-10-26 00:00:00
 |  |  | [NAME] | 2024-07-05 00:00:00
 |  |  | [NAME] | 2024-01-01 00:00:00
 |  |  | [NAME] | 2024-09-08 00:00:00
 |  |  | [NAME] | 2024-04-26 00:00:00
 |  |  | [NAME] | 2024-10-18 00:00:00
 |  |  | [NAME] | 2024-08-04 00:00:00
 |  |  | [NAME] | 2024-08-20 00:00:00
 |  |  | [NAME] | 2024-04-11 00:00:00
 |  |  | [NAME] | 2024-09-30 00:00:00
 |  |  | [NAME] | 2024-05-18 00:00:00
 |  |  | [NAME] | 2024-09-14 00:00:00
 |  |  | [NAME] | 2024-08-22 00:00:00
 |  |  | [NAME] | 2024-05-30 00:00:00
 |  |  | [NAME] | 2024-11-04 00:00:00
 |  |  | [NAME] | 2024-02-01 00:00:00
 |  |  | [NAME] | 2024-07-11 00:00:00
 |  |  | [NAME] | 2024-10-30 00:00:00
 |  |  | [NAME] | 2024-08-14 00:00:00
 |  |  | [NAME] | 2024-05-15 00:00:00
 |  |  | [NAME] | 2024-03-08 00:00:00
 |  |  | [NAME] | 2024-12-10 00:00:00
 |  |  | [NAME] | 2024-02-26 00:00:00
 |  |  | [NAME] | 2024-12-17 00:00:00
 |  |  | [NAME] | 2024-05-31 00:00:00
 |  |  | [NAME] | 2024-10-31 00:00:00
 |  |  | [NAME] | 2024-07-08 00:00:00
 |  |  | [NAME] | 2024-10-01 00:00:00
 |  |  | [NAME] | 2024-12-13 00:00:00
 |  |  | [NAME] | 2024-09-05 00:00:00
 |  |  | [NAME] | 2024-11-15 00:00:00
 |  |  | [NAME] | 2024-07-30 00:00:00
Spreadsheet: 139044d1328046362-extract-row-and-column-information-for-non-zero-table-entries-sample
Sheet: Sheet1

 |  | Input Table |  |  |  |  |  |  | Intermediate Results (optional) |  |  | Desired Output
 |  |  | (Column) |  |  |  |  |  | Line with non-zero columns | Number of non-zero entries on that line
 |  |  | 32 | 37 | 42 | 47 | 52 |  |  |  |  | Line | Column
 | (Line) | 14 | 0 | 0 | 0 | 0 | 0 |  | 15 | 2 |  | 15 | 37
 |  | 15 | 0 | 66 | 44 | 0 | 0 |  | 16 | 1 |  | 15 | 42
 |  | 16 | 0 | 33 | 0 | 0 | 0 |  | 17 | 2 |  | 16 | 37
 |  | 17 | 0 | 22 | 11 | 0 | 0 |  | 19 | 1 |  | 17 | 37
 |  | 18 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 17 | 42
 |  | 19 | 0 | 66 | 0 | 0 | 0 |  |  |  |  | 19 | 37
 |  | 20 | 0 | 0 | 0 | 0 | 0
 |  | 21 | 0 | 0 | 0 | 0 | 0
 |  | 22 | 0 | 0 | 0 | 0 | 0
 |  | 23 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 767041d1644253252-what-would-cause-excel-to-pause-its-calcs-when-it-is-set-to-automatic-livecards
Sheet: Giants

Hitters |  |  | Pitchers
UIG | NAME |  | UIG | NAME
Spreadsheet: 355927d1414860566-auto-filter-test-marks
Sheet: Database

Name | Marks Science | Maths | English | Physics | History | GK | Remarks
AS | 23 | 78 | 78 | 23 | 78 | 55 | Passed
DF | 45 | 78 | 67 | 45 | 67 | 23 | Passed
GT | 78 | 67 | 56 | 78 | 78 | 45 | Failed
SD | 67 | 78 | 98 | 67 | 67 | 78 | Passed
CF | 56 | 67 | 23 | 78 | 56 | 67 | Failed
SD | 98 | 56 | 45 | 67 | 98 | 78 | Absent
[NAME] | 23 | 98 | 78 | 56 | 45 | 67 | Passed
NJ | 67 | 56 | 67 | 98 | 23 | 56 | Passed
KL | 78 | 98 | 78 | 23 | 45 | 98 | Passed
OI | 67 | 67 | 67 | 45 | 78 | 67 | Absent
GH | 56 | 56 | 56 | 78 | 67 | 56 | Failed
YG | 44 | 98 | 98 | 67 | 77 | 98 | Passed
RT | 78 | 23 | 78 | 98 | 67 | 78 | Passed
NJ | 67 | 45 | 67 | 67 | 78 | 67 | Failed
FG | 56 | 78 | 78 | 56 | 67 | 56 | Passed
JK | 98 | 67 | 67 | 98 | 56 | 98 | Passed
YU | 23 | 56 | 56 | 23 | 98 | 23 | Passed
FT | 45 | 98 | 98 | 45 | 67 | 45 | Absent
ER | 78 | 23 | 45 | 78 | 56 | 78 | Passed
 | 67 | 67 | 23 | 45 | 98 | 67 | Passed
Spreadsheet: eric_linder__9650__EES March Dailies
Sheet: 3-1

NP15 | 2001-03-01 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 292.89 | Fixed Off Peak | 193 |  |  |  | Fixed Peak | 271.41 |  | Fixed Off Peak | 169.33 |  |  | Fixed Peak | 271.41 |  | Fixed Off Peak | 169.33
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | -1.55 | 0 | 0 | -5.55 |  |  | 1 | -38.11 | 0 | -18 | -56.11 |  |  | 1 | -2.01 | 0 | 0 | -2.01
2 | -4.67 | 0 | 0 | -4.67 |  |  | 2 | -34.66 | 0 | -18 | -51.66 |  |  | 2 | -1.97 | 0 | 0 | -1.97
3 | -4.23 | 0 | 0 | -4.23 | 0 |  | 3 | -35.25 | 0 | -18 | -49.25 |  |  | 3 | -1.94 | 0 | 0 | -1.94
4 | -4.16 | 0 | 0 | -4.16 |  |  | 4 | -34.99 | 0 | -18 | -48.99 |  |  | 4 | -1.94 | 0 | 0 | -1.94
5 | -4.5 | 0 | 0 | -4.5 |  |  | 5 | -35.12 | 0 | -18 | -53.12 |  |  | 5 | -1.96 | 0 | 0 | -1.96
6 | -4.02 | 0 | 0 | -7.02 |  |  | 6 | -35.04 | 0 | -18 | -53.04 |  |  | 6 | -2.07 | 0 | 0 | -2.07
7 | -11.08 | 0 | 0 | -11.08 |  |  | 7 | -93.93 | 0 | -18 | -84.93 |  |  | 7 | -2.24 | 0 | 0 | -2.24
8 | -13.4 | 0 | 0 | -13.4 |  |  | 8 | -91.99 | 0 | -18 | -98.99 |  |  | 8 | -2.33 | 0 | 0 | -2.33
9 | -13.54 | 0 | 0 | -13.54 |  |  | 9 | -91.48 | 0 | -18 | -110.48 |  |  | 9 | -2.34 | 0 | 0 | -2.34
10 | -12.26 | 0 | 0 | -12.26 |  |  | 10 | -93.24 | 0 | -18 | -117.24 |  |  | 10 | -2.29 | 0 | 0 | -2.29
11 | -12.25 | 0 | 0 | -12.25 |  |  | 11 | -93.27 | 0 | -18 | -122.27 |  |  | 11 | -2.29 | 0 | 0 | -2.29
12 | -13.37 | 0 | 0 | -13.37 |  |  | 12 | -91.35 | 0 | -18 | -122.35 |  |  | 12 | -2.33 | 0 | 0 | -2.33
13 | -13.19 | 0 | 0 | -13.19 |  |  | 13 | -92.46 | 0 | -18 | -122.46 |  |  | 13 | -2.33 | 0 | 0 | -2.33
14 | -12.68 | 0 | 0 | -12.68 |  |  | 14 | -92.38 | 0 | -18 | -122.38 |  |  | 14 | -2.3 | 0 | 0 | -2.3
15 | -12.18 | 0 | 0 | -12.18 |  |  | 15 | -93.39 | 0 | -18 | -120.39 |  |  | 15 | -2.28 | 0 | 0 | -2.28
16 | -12.36 | 0 | 0 | -12.36 |  |  | 16 | -92.41 | 0 | -18 | -116.41 |  |  | 16 | -2.29 | 0 | 0 | -2.29
17 | -12.77 | 0 | 0 | -12.77 |  |  | 17 | -92.81 | 0 | -18 | -111.81 |  |  | 17 | -2.3 | 0 | 0 | -2.3
18 | -14.75 | 0 | 0 | -14.75 |  |  | 18 | -90.5 | 0 | -18 | -114.5 |  |  | 18 | -2.39 | 0 | 0 | -2.39
19 | -16.69 | 0 | 0 | -16.69 |  |  | 19 | -88.42 | 0 | -18 | -112.42 |  |  | 19 | -2.47 | 0 | 0 | -2.47
20 | -15.11 | 0 | 0 | -15.11 |  |  | 20 | -90.33 | 0 | -18 | -107.33 |  |  | 20 | -2.4 | 0 | 0 | -2.4
21 | -13.76 | 0 | 0 | -13.76 |  |  | 21 | -91.49 | 0 | -18 | -102.49 |  |  | 21 | -2.35 | 0 | 0 | -2.35
22 | -12.34 | 0 | 0 | -12.34 |  |  | 22 | -92.71 | 0 | -18 | -92.71 |  |  | 22 | -2.29 | 0 | 0 | -2.29
23 | -6.98 | 0 | 0 | -9.98 |  |  | 23 | -7.76 | 0 | -18 | -65.76 |  |  | 23 | -2.19 | 0 | 0 | -2.19
24 | -6.44 | 0 | 0 | -7.44 |  |  | 24 | -33.35 | 0 | -18 | -51.35 |  |  | 24 | -2.09 | 0 | 0 | -2.09
Spreadsheet: 273376d1382696620-sum-of-different-lines-prosba_rebuilt
Sheet: List1

account | sheet | Row No | month | SUMIF
10101 |  |  | 9
11111 |  |  | 9
12345 |  |  | 9
 |  |  |  |  | make these automatic, at least for account (I can change a sheet manually.)
Spreadsheet: 883450d1732075873-freeze-panes-not-working-in-one-file-but-works-in-another-amortizationtable-rev-1
Sheet: Input

 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
 | 101
 | 102
 | 103
 | 104
 | 105
 | 106
 | 107
 | 108
 | 109
 | 110
 | 111
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
 | 121
 | 122
 | 123
 | 124
 | 125
 | 126
 | 127
 | 128
 | 129
 | 130
 | 131
 | 132
 | 133
 | 134
 | 135
 | 136
 | 137
 | 138
 | 139
 | 140
 | 141
 | 142
 | 143
 | 144
 | 145
 | 146
 | 147
 | 148
 | 149
 | 150
 | 151
 | 152
 | 153
 | 154
 | 155
 | 156
 | 157
 | 158
 | 159
 | 160
 | 161
 | 162
 | 163
 | 164
 | 165
 | 166
 | 167
 | 168
 | 169
 | 170
 | 171
 | 172
 | 173
 | 174
 | 175
 | 176
 | 177
 | 178
 | 179
 | 180
 | 181
 | 182
 | 183
 | 184
 | 185
 | 186
 | 187
 | 188
 | 189
 | 190
 | 191
 | 192
 | 193
 | 194
 | 195
 | 196
 | 197
 | 198
 | 199
 | 200
 | 201
 | 202
 | 203
 | 204
 | 205
 | 206
 | 207
 | 208
 | 209
 | 210
 | 211
 | 212
 | 213
 | 214
 | 215
 | 216
 | 217
 | 218
 | 219
 | 220
 | 221
 | 222
 | 223
 | 224
 | 225
 | 226
 | 227
 | 228
 | 229
 | 230
 | 231
 | 232
 | 233
 | 234
 | 235
 | 236
 | 237
 | 238
 | 239
 | 240
 | 241
 | 242
 | 243
 | 244
 | 245
 | 246
 | 247
 | 248
 | 249
 | 250
 | 251
 | 252
 | 253
 | 254
 | 255
 | 256
 | 257
 | 258
 | 259
 | 260
 | 261
 | 262
 | 263
 | 264
 | 265
 | 266
 | 267
 | 268
 | 269
 | 270
 | 271
 | 272
 | 273
 | 274
 | 275
 | 276
 | 277
 | 278
 | 279
 | 280
 | 281
 | 282
 | 283
 | 284
 | 285
 | 286
 | 287
 | 288
 | 289
 | 290
 | 291
 | 292
 | 293
 | 294
 | 295
 | 296
 | 297
 | 298
Spreadsheet: 544395d1508877356-autopopulate-dates-from-table-to-monthly-calendar-calendar_test
Sheet: Month View

 | ASSIGNMENTS | WEEK VIEW | CRF DUE
 | Select Month: | Enter Year:
 | MONTH VIEW
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: 0a700fdc-1f3e-4711-911a-b9a974958450
Sheet: Sheet1

Unnamed: 0 | 類別 | 書法類 | 組別：國小中年級組 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | 名次 | 姓名 | 題目 | 就讀學校 | 年級 | 指導老師 | 備註1
1 | 第一名 | 李欣諺 | 唐詩二首 | 斗南國小 | 四年級 | 張福城
2 | 第二名 | 陳乃瑄 | 古詩ㄧ首 | 立仁國小 | 四年級 | 柯依伶
3 | 第二名 | 蔡福義 | 古詩ㄧ首 | 立仁國小 | 三年級 | 鄭青青
4 | 第三名 | 王羿晴 | 詩兩首 | 安慶國小 | 四年級 | 廖晨佑
5 | 第三名 | 郭忠霖 | 唐詩兩首 | 台西國小 | 四年級 | 陳錦賢
6 | 第三名 | 張鈞雅 | 唐詩兩首 | 辰光國小 | 四年級 | 陳烈甫
7 | 優選 | 蔡晴卉 | 古詩ㄧ首 | 久安國小 | 四年級 | 丁碧莉
8 | 優選 | 吳昺均 | 古詩 | 土庫國小 | 三年級 | 黃淑梅
9 | 優選 | 詹筑涵 | 唐詩兩首 | 斗南國小 | 四年級 | 黃繼正
10 | 優選 | 朱佩文 | 詩兩首 | 蔦松國小 | 四年級 | 吳讚原
11 | 優選 | 謝嘉禎 | 詩兩首 | 口湖國小 | 四年級 | 李高梅
12 | 優選 | 曾琬晴 | 山居秋暝 | 林厝國小 | 四年級 | 連幸芳
13 | 優選 | 林晉寬 | 宋詩兩首 | 雲林國小 | 四年級 | 吳若琳
14 | 優選 | 吳佳璋 | 唐詩兩首 | 虎尾國小 | 四年級 | 張純純
15 | 優選 | [NAME] | 詩兩首 | 安慶國小 | 四年級 | 呂河成
16 | 優選 | 楊茗柯 | 雨中看牡丹 | 南陽國小 | 四年級 | 楊豐安
17 | 入選 | 蔡竹涵 | 金山晚眺還自廣陵 | [NAME] | 四年級
18 | 入選 | 陳柔均 | [NAME] | 燦林國小 | 三年級
19 | 入選 | 林庭玉 | 山居秋暝 | 林厝國小 | 三年級
20 | 入選 | 房禹欣 | 散文 | [NAME] | 四年級
21 | 入選 | 吳宇承 | 唐詩 | 飛沙國小 | 四年級
22 | 入選 | 劉育珊 | 唐詩 | 飛沙國小 | 四年級
23 | 入選 | 倪煒竣 | 唐詩兩首 | 斗南國小 | 四年級
24 | 入選 | 李章豪 | 唐詩兩首 | 鎮東國小 | 三年級
25 | 入選 | 林宥良 | 唐詩兩首 | 雲林國小 | 四年級
26 | 入選 | 張為泰 | 古詩 | 馬光國小 | 三年級
27 | 入選 | 涂秉豐 | 唐詩兩首 | 饒平國小 | 三年級
28 | 入選 | 曾華軒 | 杜甫詩野望 | 口湖國小 | 三年級
29 | 入選 | 紀柏謙 | 贈孟浩然 | 北辰國小 | 三年級
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: 19

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD
 | Dividend
 | Equity Swap
 | Portfolio
 | [NAME]
Option | Accumulator/Decumulator
 | Vanilla (put/call)
 | [NAME]
Forward | Vanilla
Exotic
Structured Products
TOTAL |  | N/A**** | N/A | N/A | N/A | N/A | N/A
Estimated swap transaction volumes, month ending October 31, by product, participant type, and cleared status (in number of transactions).
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type 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: 798072d1664290680-date-comparison-with-blank-cells-help
Sheet: Sheet1

[NAME] | Plan sch ship dt | OTD | Expected Answers
 | 2022-09-22 00:00:00 |  | Late
2022-09-22 00:00:00 | 2022-09-29 00:00:00 |  | On Time
 | 2022-09-30 00:00:00 |  | On Time
 | 2022-09-22 00:00:00 |  | Late
2022-09-06 00:00:00 | 2022-09-06 00:00:00 |  | On Time
2022-09-06 00:00:00 |  |  | Pull In
Spreadsheet: 851444d1701687301-how-to-write-a-macro-excel-2010-example
Sheet: List1

EXAMPLE
INPUT Datas |  |  |  | LEFT |  | RIGHT
 |  |  | N number of terms left | 1st | 2nd | 1st | 2nd
 |  | N | 2 | 7 | 25 | 9 | 22
 |  |  |  |  | number of terms [NAME] is always the same for both integers |  |  | number of terms RIGHT is also (2+2)=4
 |  |  |  |  | (in the example 2 for both) |  |  | BUT for 1st integer NUMBER OF TERMS is N-1 (in example 2-1=1)
 |  |  |  |  |  |  |  | AND for second integer NUMBER OF TERMS is N+1 (in example 2+1=3)
 |  | RESULT HAS TO BE:
 |  |  |  | LEFT |  | RIGHT
 |  |  | 2 terms | 7 |  | 9 | 1 term
 |  |  |  | 8 |  | 22
 |  |  | 2 terms | 25 |  | 23 | 3 terms
 |  |  |  | 26 |  | 24
Spreadsheet: 111706d1308040476-concatenate-book1_caitfox
Sheet: Sheet1

Name | Version |  | Helper Column
me123456 | 1.2 |  | 1.2
me123456 | 2.2 |  | 1.2, 2.2
me123456 | 4.2 | 1.2, 2.2, 4.2 | 1.2, 2.2, 4.2
me654321 | 3.2 |  | 3.2
me654321 | 5.2 |  | 3.2, 5.2
me654321 | 6.2 | 3.2, 5.2, 6.2 | 3.2, 5.2, 6.2
Spreadsheet: 81914d1282037633-how-to-add-a-counter-on-a-spreadsheet-goods-return-form
Sheet: Goods return

Goods return
Date issued: | [NAME]/dd/yyyy
 |  | Reference code: |  |  | Auto #
Customer Details
Name:
Address:
City:
State: |  | Post code:
Ph: |  | Mob: |  | [NAME]:
Sales ID#: |  | Invoice #: |  | Date purchased:
Sales company:
Return reason
Not satisfied | Damaged in delivery | DOA | Wrong item sent
Item condition
New | Opened | Used
Item(s) to be returned
Product Description |  | Product Code |  | QTY
Item(s) checked by (warehouse staff only)
Name: |  | Signature: |  | Date:
Item Allocation
Stock allocation |  | Damaged Goods
Bay location:
Credit type (Accounts Only)
Store Credit | Refund type |  |  | PayPal | Credit Card
Credit include postage |  |  | Postage not included
Total Refund Amount: $30.85
Credited processed by:
Name: |  | Signature: |  | Date:
Inventory stock entered by:
Name: |  | Signature: |  | Date:
Spreadsheet: 00eff674-be24-453c-b7f0-5c3c0d5fd27b
Sheet: B Term Mid Semester

University of Nevada, Reno |  |  |  |  | Academic Calendar
[NAME] |  |  |  |  | Enter semester and Fiscal Year start and end dates
 |  |  |  |  |  | Start Date | End Date | Wk days | Worked
 |  |  |  |  | Fall Semester:
Name: |  | Position Number: |  |  | Spring Semester:
Contract type: |  | Rank or Range: |  |  | Fiscal Year:
VP: |  | Retirement Plan: | 7
College/Division: |  |  | No
Unit/Department:
Title:
Tenure Status:
SALARY CALCULATION |  |  |  |  | Monthly
 | Contract Start Date: |  |  |  | working days in the start month
 | Contract End Date: |  |  |  | working days in the end month
 | Base Salary: | 0 |  |  | Months between start and end months
 | FTE: | 0 |  |  | Days worked in start month
 | Reduction factor: |  |  |  | Last day of start month
 | 2.5% Reduction: |  |  |  | Days worked in end month
 |  |  |  |  | First day of end month
 |  |  |  |  | Pay for start month
 | Annual Stipend: | 0 |  |  | Pay for months between start/end
 | Additional Stipend: | 0 |  |  | Pay for end month
 | Stipend EPR reduced: |  |  |  | Total Pay (Prorated Amount)
 |  |  |  |  | Prorated Stipend
 | TERM SEMESTER:
Pay Per Semester (Annualized Base Salary/2)
Daily Rate (Pay Per Semester/Contractual Days in Semester)
Fall Semester Pay Earned
Spring Semester Pay Earned
Stipend Earned
 | Total Pay earned:
Enter Salary plus Stipend amount paid to date: |  | 0
Spreadsheet: 775019d1648769896-combining-2-countif-formulas-test12-etaf-makaveeti-etafv2
Sheet: Sheet1

 | Type | Status | ID |  |  |  |  |  |  |  |  |  | Expires | Valid | New? | Expected | Old Only | NEW Formula | New Formula Adapted | New Formula Adapted - FIXED | new | new expired | old | old expired | old expired formula
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2021-11-13 10:49:36 |  |  | New
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2021-11-13 10:49:36 |  |  | New |  |  |  |  |  |  |  |  |  | New: B=OT O=Yes New Expired: B=OT O="" Old: B=<>OT O=Yes Old Expired: B=<>OT O=""
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2023-11-12 08:38:03 |  |  | New
 | OT | ISSUED | 568154112108 |  |  |  |  |  |  |  |  |  | 2023-11-12 08:38:03 |  |  | New
 | OT | RENEWED | 560828464107 |  |  |  |  |  |  |  |  |  | 2021-02-19 12:46:35 |  |  | New Expired
 | GMP | RENEWED | 561448899106 |  |  |  |  |  |  |  |  |  | 2023-03-18 08:53:48 |  |  | Old
 | GMP | RENEWED | 561448899106 |  |  |  |  |  |  |  |  |  | 2023-03-18 08:53:48 |  |  | Old
 | OT | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2018-04-06 10:20:51 |  |  | New
 | OT | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2019-09-12 09:35:30 |  |  | New
 | GMP2 | RENEWED | 77404689042 |  |  |  |  |  |  |  |  |  | 2021-06-11 10:12:51 |  |  | New
 | GMP | RENEWED | 77404689042 |  |  |  |  |  |  |  |  |  | 2023-06-10 09:35:53 |  |  | New
 | GMP | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2020-07-17 10:29:32 |  |  | New
 | OT | ISSUED | 77404689042 |  |  |  |  |  |  |  |  |  | 2022-06-27 14:09:07 |  |  | New
 | GMP | ISSUED | 563269721104 |  |  |  |  |  |  |  |  |  | 2023-02-22 10:00:04 |  |  | Old
 | OT | EXPIRED | 563269721104 |  |  |  |  |  |  |  |  |  | 2020-02-08 13:11:40 |  |  | Old
 | OT | ISSUED | 579064386101 |  |  |  |  |  |  |  |  |  | 2023-06-01 09:24:04 |  |  | New
 | OT | RENEWED | 560828464107 |  |  |  |  |  |  |  |  |  | 2021-02-19 12:46:35 |  |  | New Expired
 | GMP | RENEWED | 558862935103 |  |  |  |  |  |  |  |  |  | 2023-12-02 10:17:44 |  |  | Old
 | GMP | ISSUED | 563607617106 |  |  |  |  |  |  |  |  |  | 2020-03-22 15:54:35 |  |  | Old Expired
 | GMP | DESTROYED | 51403901047 |  |  |  |  |  |  |  |  |  | 2017-01-13 11:55:01 |  |  | NONE
 | GMP2 | CANCELLED | 51403901047 |  |  |  |  |  |  |  |  |  | 2020-05-02 15:06:43 |  |  | NONE