tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 763164d1642013876-start-array-based-on-matching-criteria-example
Sheet: SKU Fortcast

 | SKU Number | Region | Fcst-Mth 1 ($) | Fcst-Mth 2 ($) | Fcst-Mth 3 ($) | Fcst-Mth 4 ($) | Fcst-Mth 5 ($) | Fcst-Mth 6 ($) | Fcst-Mth 7 ($) | Fcst-Mth 8 ($) | Fcst-Mth 9 ($0 | Fcst-Mth 10 ($) | Fcst-Mth 11 ($) | Fcst-Mth 12 ($)
 | 120 | 1 | 1900 | 1900 | 1900 | 1900 | 3800 | 3800 | 3800 | 3800 | 3800 | 3800 | 3800 | 3800
 | 121 | 1 | 2125 | 2125 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550
 | 122 | 1 | 2000 | 2000 | 3000 | 3000 | 3000 | 3000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000
 | 123 | 1 | 2000 | 2000 | 4000 | 4000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000
 | 124 | 1 | 2000 | 2000 | 2000 | 2000 | 2000 | 5000 | 5000 | 6000 | 6000 | 6000 | 6000 | 6000
 | 125 | 1 | 1100 | 1100 | 1100 | 3300 | 3300 | 3300 | 3300 | 4400 | 4400 | 4400 | 4400 | 4400
 | 126 | 1 | 1400 | 1400 | 1400 | 2800 | 2800 | 2800 | 2800 | 2800 | 4200 | 4200 | 4200 | 4200
 | 120 | 2 | 340 | 340 | 340 | 340 | 340 | 340 | 340 | 340 | 340 | 340 | 340 | 340
 | 121 | 2 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380
 | 122 | 2 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440
 | 123 | 2 | 480 | 480 | 480 | 480 | 480 | 480 | 480 | 480 | 480 | 480 | 480 | 480
 | 124 | 2 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300
 | 125 | 2 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300
 | 126 | 2 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
 | 120 | 3 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315
 | 121 | 3 | 365 | 365 | 365 | 365 | 365 | 365 | 365 | 365 | 365 | 365 | 365 | 365
 | 122 | 3 | 330 | 330 | 330 | 330 | 330 | 330 | 330 | 330 | 330 | 330 | 330 | 330
 | 123 | 3 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380
 | 124 | 3 | 220 | 220 | 220 | 220 | 220 | 220 | 220 | 220 | 220 | 220 | 220 | 330
 | 125 | 3 | 330 | 330 | 330 | 330 | 330 | 330 | 330 | 330 | 330 | 330 | 330 | 495
 | 126 | 3 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700
Spreadsheet: 181790d1348154481-autopopulating-table-from-previous-sheet-example
Sheet: created tables

lot 1
number | [NAME] | data2
1 | 10 | 26
3 | 15 | 28
8 | 15 | 25
Lot 2
number | [NAME] | data2
2 | 20 | 25
4 | 12 | 29
5 | 13 | 24
6 | 17 | 26
7 | 18 | 28
9 | 20 | 23
 |  | Without touching sheet 1 I need to create a table that seperates the lot
 |  |  |  |  | Many thanks in advance :)
Spreadsheet: 858117d1706876631-how-to-stop-count-once-a-certain-value-has-been-reached-example-result-2-personas-new
Sheet: Example

Persona ID | Period | Absent | Pay
1234 | [NAME] | 1 | 324
12345 | [NAME] | 0 | 0
1234 | Feb20 | 1 | 5324
12345 | Feb20 | 0 | 0
1234 | Mar20 | 1 | 4234
12345 | Mar20 | 0 | 0
1234 | Apr20 | 1 | 234234
12345 | Apr20 | 0 | 0
1234 | May20 | 1 | 543543
12345 | May20 | 0 | 0
1234 | Jun20 | 1 | 2354
12345 | Jun20 | 0 | 0
1234 | Jul20 | 1 | 0
12345 | Jul20 | 0 | 0
1234 | Aug20 | 1 | 0
12345 | Aug20 | 0 | 0
1234 | Sep20 | 0 | 0
12345 | Sep20 | 0 | 645
1234 | Oct20 | 0 | 0
12345 | Oct20 | 0 | 0
1234 | Nov20 | 0 | 0
12345 | Nov20 | 0 | 0
1234 | Dec20 | 0 | 0
12345 | Dec20 | 0 | 534
1234 | Jan21 | 1 | 0
12345 | Jan21 | 0 | 4
1234 | Feb21 | 1 | 0
12345 | Feb21 | 0 | 5634
1234 | Mar21 | 0 | 0
12345 | Mar21 | 0 | 7645
1234 | Apr21 | 0 | 0
12345 | Apr21 | 0 | 0
1234 | May21 | 0 | 0
12345 | May21 | 0 | 0
1234 | Jun21 | 1 | 0
12345 | Jun21 | 0 | 0
1234 | [NAME] | 0 | 0
12345 | [NAME] | 1 | 6534
1234 | Aug21 | 1 | 0
12345 | Aug21 | 1 | 5465
1234 | Sep21 | 0 | 0
12345 | Sep21 | 1 | 6354
1234 | Oct21 | 0 | 0
12345 | Oct21 | 1 | 0
1234 | Nov21 | 0 | 0
12345 | Nov21 | 1 | 6534
1234 | Dec21 | 0 | 0
12345 | Dec21 | 1 | 6435
1234 | [NAME] | 0 | 0
12345 | [NAME] | 1 | 6534
1234 | Feb22 | 0 | 0
12345 | Feb22 | 0 | 456
1234 | Mar22 | 0 | 0
12345 | Mar22 | 0 | 5436
1234 | Apr22 | 0 | 0
12345 | Apr22 | 0 | 543
1234 | May22 | 0 | 0
12345 | May22 | 0 | 765
1234 | [NAME] | 0 | 0
12345 | [NAME] | 0 | 0
1234 | [NAME] | 1 | 0
12345 | [NAME] | 0 | 0
1234 | Aug22 | 1 | 0
12345 | Aug22 | 1 | 54
1234 | Sep22 | 1 | 543
12345 | Sep22 | 1 | 543
1234 | Oct22 | 1 | 432
12345 | Oct22 | 1 | 543
1234 | Nov22 | 1 | 4234
12345 | Nov22 | 1 | 543
1234 | Dec22 | 1 | 5435
12345 | Dec22 | 1 | 4532
Persona ID | Result | AliGW
1234 | Under 6 payments
12345
Spreadsheet: 67673d1268238808-require-scatter-chart-that-doesnt-plot-zero-or-example_file
Sheet: Sheet1

x | y
- | -
- | -
10 | 20
20 | 40
30 | 60
40 | 80
50 | 100
60 | 120
70 | 140
80 | 160
90 | 180
100 | 200
110 | 220
120 | 240
130 | 260
140 | 280
150 | 300
- | -
- | -
- | -
- | -
- | -
- | -
- | -
- | -
- | -
- | -
- | -
- | -
- | -
- | -
- | -
Spreadsheet: 857858d1706724644-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-gk-31-jan-final
Sheet: CALDERA

Name | ID |  |  |  |  | CHARGE MONTH: |  |  |  | PAYROLL WORKSHEET
CALDERA |  |  |  |  |  | 2023-11-01 00:00:00 |  |  |  | Schedule: | Weekly |  | Mo. [NAME]: |  |  | Hrly [NAME].: |  |  |  |  |  | Position: | [NAME]
 |  |  |  |  |  |  |  |  |  | Shift: | Swing |  | Stipend/UA: |  |  | Wk Equiv.: |  |  |  |  |  | Union: | [NAME]
LEAVE USAGE
TYPE | V | S | SF | CTO | HCTO | IH | PH |  |  |  |  |  | Hours Worked
DATE |  |  |  |  |  |  |  |  |  | Period # | Start | End | Regular | Holiday | Overtime | CTO | Total | Swing | S Due | Grave | G Due | Total Comp | OT Rate
2023-11-06 00:00:00 |  |  |  | 0.5 |  |  |  |  |  | 1 | 2023-10-29 00:00:00 | 2023-11-04 00:00:00
2023-11-13 00:00:00 |  |  | 10 |  |  |  |  |  |  | 2 | 2023-11-05 00:00:00 | 2023-11-11 00:00:00
11/26-27/2023 |  | 20 |  |  |  |  |  |  |  | 3 | 2023-11-12 00:00:00 | 2023-11-18 00:00:00
 |  |  |  |  |  |  |  |  |  | 4 | 2023-11-19 00:00:00 | 2023-11-25 00:00:00
 |  |  |  |  |  |  |  |  |  | 5 | 2023-11-26 00:00:00 | 2023-12-02 00:00:00
 |  |  |  |  |  |  |  |  |  | Total
TOTAL |  |  |  |  |  |  |  |  |  |  |  | Total All OT Worked:
 |  |  |  |  |  |  |  |  |  |  |  | OT Reported by Dept:
OVERTIME AUTHORIZED |  |  |  |  |  |  |  |  |  |  |  | Less Holiday RDO:
REASON | DATE | FROM | TO | HOURS | EARN ID | PAY CODE | SWING | GRAVE
SHIFT COVERAGE - VACANT | 2023-11-05 00:00:00 | 1600 | 1800 | 2 | OTPR | 213-425P | 1 |  |  |  |  |  | Difference:
VETERANS DAY - REG SHIFT | 2023-11-10 00:00:00 |  |  | 10 | HG6 | 213-425HP |  | 11
SHIFT COVERAGE - VACANT | 2023-11-12 00:00:00 | 1600 | 1800 | 2 | OTPR | 213-425P | 14
DISPATCH TRAINER MEETING | 2023-11-16 00:00:00 | 1300 | 1400 | 3 | CTO | 213-425P
THANKSGIVING - RDO | 2023-11-23 00:00:00 |  |  | 10 | RDO HOL PD | 213-425OT5
SHIFT COVERAGE - VACANT | 2023-11-24 00:00:00 | 1600 | 1800 | 2 | OTPR | 213-425P | 1
Total
 |  |  |  | Regular Shift Differential Hours:
 |  |  |  | Total Shift Differential Hours to Pay:
Spreadsheet: 018cdefb-ad04-4614-b9df-85ca45d43372
Sheet: Sheet1

DIVISION CHAIRPERSONS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
DIVISION |  |  | CHAIRPERSON |  | EXT. | [NAME]
BIOLOGY |  |  | KINDRA GIRARD |  | 5367 | SG 210
BUSINESS |  |  | [NAME] |  | 5525 | SR 315
COLLEGE SERVICES |  |  | JEANETTE STIRDIVANT |  | 5424 | SR 220
ENGLISH |  |  | MONETTE TIERNAN |  | 5609 | LB 215-A
ESL, CREDIT |  |  | KATHLEEN FLYNN |  | 5510 | SG 223
ESL, NON-CREDIT |  |  | [NAME] |  | 5692 | [NAME]
HEALTH AND |  |  | JON GOLD |  | 3193 | VG 223
PHYSICAL EDUCATION
HEALTH SCIENCES |  |  | [NAME] |  | 5892 | HS 311
LANGUAGE ARTS |  |  | JEAN PERRY |  | 5504 | AU 218-C
MATHEMATICS |  |  | KATHLEEN HOLMES |  | 5650 | SG324
NON-CREDIT BUSINESS |  |  | [NAME] |  | 5807 | [NAME]
AND LIFE SKILLS
PHYSICAL SCIENCE |  |  | [NAME] |  | 5794 | CS 185
SOCIAL SCIENCE |  |  | [NAME] |  | 5747 | SR 351
TECHNOLOGY AND |  |  | SCOTT RUBKE |  | 5541 | AT 106
AVIATION
VISUAL AND PERFORMING |  |  | TRUDI ABRAM |  | 5607 | AU 118-C
ARTS
Spreadsheet: 105745d1303017018-how-to-prevent-duplicate-using-randbetween-aa_vaultdemo
Sheet: Sheet1

 |  | Vault#1
Vault | x = Used
Vault#1 |  |  |  |  | 1
Vault#2 |  |  |  |  | 2
Vault#3 |  |  |  |  | 3
Vault#4 |  |  |  |  | 4
Vault#5 |  |  |  |  | 5
Vault#6 |  |  |  |  | 6
Vault#7 |  |  |  |  | 7
Vault#8 |  |  |  |  | 8
Vault#9 |  |  |  |  | 9
Vault#10 |  |  |  |  | 10
Vault#11 |  |  |  |  | 11
Vault#12 |  |  |  |  | 12
Vault#13 |  |  |  |  | 13
Vault#14 |  |  |  |  | 14
Vault#15 |  |  |  |  | 15
Vault#16 |  |  |  |  | 16
Vault#17 |  |  |  |  | 17
Vault#18 |  |  |  |  | 18
Vault#19 |  |  |  |  | 19
Vault#20 |  |  |  |  | 20
Vault#21 |  |  |  |  | 21
Vault#22 |  |  |  |  | 22
Vault#23 |  |  |  |  | 23
Vault#24 |  |  |  |  | 24
Vault#25 |  |  |  |  | 25
Vault#26 |  |  |  |  | 26
Vault#27 |  |  |  |  | 27
Vault#28 |  |  |  |  | 28
Vault#29 |  |  |  |  | 29
Vault#30 |  |  |  |  | 30
Vault#31 |  |  |  |  | 31
Vault#32 |  |  |  |  | 32
Vault#33 |  |  |  |  | 33
Vault#34 |  |  |  |  | 34
Vault#35 |  |  |  |  | 35
Vault#36 |  |  |  |  | 36
Vault#37 |  |  |  |  | 37
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 9a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 791659 | 177880 | 969539
FRA | 22803 | 37631 | 60434
OIS | 83751 | 103461 | 187212
OTHER* | 1951 | 247465 | 249416
TOTAL | 900164 | 566437 | 1466601
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, and Swaption.
Spreadsheet: 717033d1612454676-currency-as-text-with-currency-suffix-document
Sheet: Munka1

155 723.85 HUF |  | 155723.85
-108.00 HUF |  | -108
155 615.85 HUF |  | 155615.85
-150 000.00 HUF |  | -150000
5 615.85 HUF |  | 5615.85
-4 352.00 HUF |  | -4352
-468.61 HUF |  | -468.61
-776.00 HUF |  | -776
-500.00 HUF |  | -500
[NAME] |  | -480.76
Spreadsheet: 53c82683-b275-48dd-a6ce-4299346bde9d
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 17346 | 17086 | 16158 | 14785
20 - 65 | 71552 | 66086 | 58726 | 52627
65 und mehr | 30739 | 31374 | 33522 | 34816
Insgesamt | 119637 | 114546 | 108406 | 102228
%
unter 20 | 14.49885904862208 | 14.91627817645313 | 14.90507905466487 | 14.4627694956372
20 - 65 | 59.80758461011225 | 57.69385225149721 | 54.17227828717968 | 51.48002504206283
65 und mehr | 25.69355634126566 | 27.38986957204966 | 30.92264265815545 | 34.05720546229995
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 24.24250894454383 | 25.85418999485519 | 27.51421857439635 | 28.09394417314306
Altenquotient | 42.960364490161 | 47.474502920437 | 57.08204202567857 | 66.15615558553594
Gesamtquotient | 67.20287343470484 | 73.3286929152922 | 84.59626060007493 | 94.25009975867901
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 869560d1716175351-incorrect-time-counting-incorrect-time-counting
Sheet: Sheet1

 | When Issued (Z time) | Product expired (Z time) | Product Issued in CST | Product Expiration in CST | Length of Warning | Length of Warning in Minutes |  |  | Time | Time | # [NAME] | Correct # of Warnings
 | 1986-04-25T22:24:00Z | 1986-04-25T23:05:00Z |  |  |  |  |  |  |  |  |  | 0
 | 1986-04-25T22:40:00Z | 1986-04-25T23:20:00Z |  |  |  |  |  |  |  |  |  | 1
 | 1986-04-25T22:42:00Z | 1986-04-25T23:35:00Z |  |  |  |  |  |  |  |  |  | 4
 | 1986-04-25T22:50:00Z | 1986-04-25T23:50:00Z |  |  |  |  |  |  |  |  |  | 8
 | 1986-04-26T00:15:00Z | 1986-04-26T00:30:00Z |  |  |  |  |  |  |  |  |  | 5
 | 1986-04-26T00:15:00Z | 1986-04-26T01:15:00Z |  |  |  |  |  |  |  |  |  | 0
 | 1986-04-26T00:45:00Z | 1986-04-26T01:15:00Z |  |  |  |  |  |  |  |  |  | 0
 | 1986-04-26T02:35:00Z | 1986-04-26T03:30:00Z |  |  |  |  |  |  |  | 01:59:00 |  | 0
 | 1986-04-27T05:00:00Z | 1986-04-27T06:00:00Z
 | 1986-04-27T05:00:00Z | 1986-04-27T06:00:00Z |  |  |  |  |  |  | Incorrect Values
 | 1986-06-16T03:43:00Z | 1986-06-16T04:45:00Z
 | 1986-06-23T22:10:00Z | 1986-06-23T22:45:00Z
 | 1986-06-23T23:07:00Z | 1986-06-24T00:00:00Z
 | 1986-06-26T23:40:00Z | 1986-06-27T00:30:00Z
 | 1986-06-27T02:08:00Z | 1986-06-27T02:57:00Z
 | 1986-06-27T02:08:00Z | 1986-06-27T03:00:00Z
 | 1986-07-05T00:03:00Z | 1986-07-05T01:00:00Z
 | 1986-07-05T00:03:00Z | 1986-07-05T01:00:00Z
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R59

Ime artikla
Spreadsheet: 770931d1646338073-name-check-data-validation-formula-actor-list
Sheet: Sheet1

 |  |  |  |  | Director/ | Notes
 |  |  |  |  | Actor
 |  |  |  |  | Director: Coppola | Title. by: [NAME] (MA) | OK
 |  |  |  |  | Actor: [NAME] (MA) | Group: ma
 |  |  |  |  | Director: Lean | Title. by: P. O'Tool (MA) | NO
 |  |  |  |  | Actor: [NAME] (MA) | Group: ma
 |  |  |  |  | Director: Lean | Title. by: [NAME] (MA) | OK
 |  |  |  |  | Actor: [NAME] (MA) | Group: ma
 |  |  |  |  | Director: [NAME] | Title. by: [NAME] (MA) | NO
 |  |  |  |  | Actor: [NAME] (MA) | Group: ma
 |  |  |  |  | Director: [NAME] | Title. by: [NAME] (MA) | NO
 |  |  |  |  | Actor: [NAME] (FE) | Group: fe
 |  |  |  |  | Director: [NAME] | Title. by: [NAME] (MA) | OK
 |  |  |  |  | Actor: [NAME] (MA) | Group: ma
Spreadsheet: 876481d1723168505-attendance-tracking-with-occurrence-points-over-6-month-rolling-period-attendance-tracker-1-
Sheet: Summary

 |  |  | Override Dates:
From:
To:
Employee | Vacation | Sick | Unexcused | NCNS | Tardy | Late Return | Total Points
Spreadsheet: 800252d1665560700-count-and-display-duplicates-in-an-array-display_duplicates_3_solutions
Sheet: display_duplicates

 | COUNT AND DISPLAY DUPLICATES OF A COLUMN |  |  |  | (case-sensitive)
 | array: | =B11:B30 |  | HansDouwe |  | WideBoyDixon |  | TMS
 | formula:
 | expected result: | 4 A; 4 a; 2 b; 4 G
 | grade1 | grade2 | grade3 | grade4 | grade5 | grade6 | [NAME] | grade8 | grade9 | [NAME] | grade11 | grade12 | grade13 | [NAME] | grade15 | [NAME] | grade17 | grade18
HansDouwe
WideBoyDixon
TMS
 | A
 | A
 | A
 | a
 | a
 | a
 | a
 | F
 | b
 | b
 | A
 | G
 | G
 | G
 | G
 | H
 | I
 | B
 | T
 | R
 | Z