tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 81991d1282071065-only-one-entry-per-month-in-pivot-table-performance-revised
Sheet: G

Incident | Date | ID | Cause | Delay Code | Manager | Comm | Incident Location | Cost | Delays
189593 | 2010-07-30 00:00:00 | 4E19 | WTG RELIEF 421S PBO | C | FPEG | G | HOLME JN. | 101.16 | 3
182275 | 2010-07-27 00:00:00 | 4E19 | OSS XHO | L | MPEG | G | HUNTINGDON | 202.32 | 6
201856 | 2010-08-05 00:00:00 | 4E19 | BREAKDOWN XMO | T | APEG | G | MOUNTFIELD SIDINGS (GBRF) | 337.2 | 10
202353 | 2010-08-05 00:00:00 | 4E80 | [NAME] | C | FPEG | G | LINCOLN CENTRAL | 236.04 | 7
197269 | 2010-08-03 00:00:00 | 4E80 | LOCO ISSUES LBO | L | MPEG | G | LOUGHBOROUGH | 843 | 25
183892 | 2010-07-28 00:00:00 | 4h91 | TRAIN PREP DONCDDY | T | APEG | G | DONCASTER DOWN DECOY | 168.6 | 5
179580 | 2010-07-26 00:00:00 | 4M91 | DIESL OTH DONCRMT | L | MPEG | G | Doncaster Royal Mail Terminal | 1079.04 | 32
203518 | 2010-08-06 00:00:00 | 4O19 | 8 LOST TON | S | FPEG | G | TONBRIDGE | 134.88 | 4
179442 | 2010-07-26 00:00:00 | 4Y19 | LOST 3 NHD - XVJ | S | FPEG | G | PECKHAM RYE | 101.16 | 3
179540 | 2010-07-26 00:00:00 | 4Y19 | LOST 3 SNS-VIR | S | FPEG | G | STAINES | 101.16 | 3
194408 | 2010-08-02 00:00:00 | 6B51 | LATE START DONCDDY | T | FPEG | G | DONCDNDCY | 134.88 | 4
197505 | 2010-08-03 00:00:00 | 6B52 | 31 WTG STAFF WLBCKCL | T | APEG | G | WELBECK B.C. | 337.2 | 10
204997 | 2010-08-06 00:00:00 | 6B52 | TRAFFIC WLBCGBR | T | APEG | G | WELBECK B.C. | 2326.68 | 69
200874 | 2010-08-05 00:00:00 | 6H51 | RUNNING EARLY YRK | C | FPEG | G | YORK | 101.16 | 3
Spreadsheet: 68532d1269043520-formula-disappears-generic-version
Sheet: Exp Categories

 |  |  |  |  | [NAME]
 |  |  |  |  | % | Amount
1 | M |  | 0.5 | 58377.11617046119
2 | 1 |  | 0.2 | 23350.84646818448
3 | 2 |  | 0.3 | 35026.26970227671
4 |  |  |  | 0
5 |  |  |  | 0
6 |  |  |  | 0
7 |  |  |  | 0
8 |  |  |  | 0
 | Total |  | 1 | 116754.2323409224 | 0 | 0
 |  |  |  |  |  | 116754.2323409224
 |  |  |  |  |  | 0
Spreadsheet: 273470d1382722151-return-top-10-values-from-table-top-10-winners
Sheet: Table

 |  |  | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME], Jr. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | Christijan Albers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | Cliff [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | Red Amick |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | Mário de Araújo Cabral |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | René Arnoux |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Wins
Spreadsheet: 66254d1266951827-vlookup-or-test
Sheet: Data

STATEMENT OF ACCOUNT
Customer # | Customer Name | Inv date | Order | Invoice #
63800001 | NETWORKS INC   Sreadshare | 31.01.2010 | 121007670 | IA108292
63800001 | NETWORKS INC   Sreadshare | 31.01.2010 | 121007671 | IO306950
63800001 | NETWORKS INC   Sreadshare | 31.01.2010 | 121007672 | CA216419
63800001 | NETWORKS INC   Sreadshare | 31.01.2010 | 121007673 | CO414153
63800031 | WORLDWIDE CO., LTD | 30.12.2009 | 163013793 | S00051057/B
63800040 | CANADA INC. | 07.01.2010 | 162033460 | YTO056705300
63800040 | CANADA INC. | 13.01.2010 | 162033461 | YTO056905400
63800040 | CANADA INC. | 13.01.2010 | 163013484 | YTO056988500
63800040 | CANADA INC. | 13.01.2010 | 163013485 | YTO056988501
63800040 | CANADA INC. | 13.01.2010 | 163013731 | [NAME]
63800040 | CANADA INC. | 19.01.2010 | 162033503 | YTO057075500
63800048 | (HK) LTD | 07.01.2010 | 162033586 | S00133785
63800049 | (HK) LTD | 21.01.2010 | 162033472 | S00139285/A
63800074 | UNITED STATES, INC. | 05.01.2010 | 163013493 | CHI015225400
63800074 | UNITED STATES, INC. | 05.01.2010 | 163013494 | CHI015225700
63800074 | UNITED STATES, INC. | 18.01.2010 | 163013724 | CHI015684900
63800074 | UNITED STATES, INC. | 18.01.2010 | 163013725 | [NAME]
63800083 | (HK) SHANGAI | 06.01.2010 | 162033213 | S00526156
63800085 | (HK) LTD SHANGHAI OFFICE | 30.12.2009 | 163013779 | S00517832/A
63800085 | (HK) LTD SHANGHAI OFFICE | 30.12.2009 | 163013780 | S00519169/A
63800085 | (HK) LTD SHANGHAI OFFICE | 30.12.2009 | 163013788 | S00518400/A
63800085 | (HK) LTD SHANGHAI OFFICE | 16.12.2009 | 163013781 | S00512649/A
63800085 | (HK) LTD SHANGHAI OFFICE | 16.12.2009 | 163013782 | S00512649
63800085 | (HK) LTD SHANGHAI OFFICE | 17.12.2009 | 163013783 | S00514758/A
63800085 | (HK) LTD SHANGHAI OFFICE | 17.12.2009 | 163013784 | S00512290/A
63800085 | (HK) LTD SHANGHAI OFFICE | 22.12.2009 | 163013785 | S00515678
63800085 | (HK) LTD SHANGHAI OFFICE | 22.12.2009 | 163013786 | S00515678/A
63800085 | (HK) LTD SHANGHAI OFFICE | 24.12.2009 | 163013787 | S00507278/A
63800085 | (HK) LTD SHANGHAI OFFICE | 29.12.2009 | 163013775 | S00520671/A
63800085 | (HK) LTD SHANGHAI OFFICE | 29.12.2009 | 163013776 | S00520671
63800085 | (HK) LTD SHANGHAI OFFICE | 29.12.2009 | 163013777 | S00520670
63800085 | (HK) LTD SHANGHAI OFFICE | 29.12.2009 | 163013778 | S00520670/A
63800085 | (HK) LTD SHANGHAI OFFICE | 31.12.2009 | 163013789 | [NAME]
63800085 | (HK) LTD SHANGHAI OFFICE | 05.01.2010 | 163013790 | [NAME]/A
63800085 | (HK) LTD SHANGHAI OFFICE | 21.01.2010 | 163013645 | S00517846
63800085 | (HK) LTD SHANGHAI OFFICE | 28.01.2010 | 163013728 | S00490718/C
63800085 | (HK) LTD SHANGHAI OFFICE | 28.01.2010 | 163013729 | S00490718/B
63800085 | (HK) LTD SHANGHAI OFFICE | 29.01.2010 | 163013730 | S00483970/F
63800085 | (HK) LTD SHANGHAI OFFICE | 04.02.2010 | 163013791 | S00520671/B
63800085 | (HK) LTD SHANGHAI OFFICE | 04.02.2010 | 163013792 | S00520671/C
Spreadsheet: 869068d1715727351-remove-unwanted-character-from-the-text-sting-remove-unwanted-charaters-from-text-sting-sample-data-tms
Sheet: Sheet1

AMCOR Service Solutions�
Ampad�
�[NAME]
�AnalogFolk
Andr� Corporation
�Angell Echo
�Anubavam
Apex Computer Systems, Inc.�
�Apollo Matrix Inc
�App Maisters Inc
Spreadsheet: 826590d1682093270-dynamtic-monthly-calendar-but-with-a-gap-in-between-date-question
Sheet: Sheet2

2019 | Jan | 1
2020 | Feb | 2
2021 | Mar | 3
2022 | Apr | 4
2023 | May | 5
2024 | Jun | 6
2025 | Jul | 7
2026 | Aug | 8
2027 | Sep | 9
2028 | Oct | 10
2029 | Nov | 11
2030 | Dec | 12
Spreadsheet: 171bc156-a9ca-4f51-81d8-27aeb00be6f1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Searches | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Month: | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Grand total:
SearchGroups: | SearchType:
Total Browse Searches | Browse by Alphabet | 1701 | 1154 | 3369 | 4590 | 3523 | 2448 | 1907 | 3755 | 3319 | 3554 | 1093 | 1241 | 31654
 | Browse by Subject | 520 | 379 | 1160 | 1886 | 1275 | 689 | 486 | 1101 | 1219 | 1313 | 611 | 403 | 11042
 | Total Browse Searches total: | 2221 | 1533 | 4529 | 6476 | 4798 | 3137 | 2393 | 4856 | 4538 | 4867 | 1704 | 1644 | 42696
Total [NAME] | Title Begins With | 4040 | 2734 | 6483 | 8196 | 6560 | 5091 | 4279 | 6675 | 8120 | 7463 | 3680 | 3768 | 67089
 | Title Contains | 226 | 183 | 652 | 965 | 652 | 457 | 278 | 663 | 634 | 585 | 183 | 239 | 5717
 | Title Equals | 62 | 43 | 187 | 203 | 124 | 88 | 143 | 162 | 186 | 195 | 80 | 81 | 1554
 | Total Titles Searches total: | 4328 | 2960 | 7322 | 9364 | 7336 | 5636 | 4700 | 7500 | 8940 | 8243 | 3943 | 4088 | 74360
Other Searches | ISSN Equals | 48 | 89 | 63 | 144 | 66 | 42 | 105 | 239 | 268 | 245 | 22 | 20 | 1351
 | MARC | 871 | 778 | 1357 | 1926 | 1340 | 1110 | 911 | 1711 | 1793 | 1987 | 912 | 901 | 15597
 | OpenURL | 8849 | 5443 | 13023 | 24541 | 20467 | 12989 | 7259 | 17558 | 20300 | 24200 | 8891 | 10369 | 173889
 | Other Searches total: | 9768 | 6310 | 14443 | 26611 | 21873 | 14141 | 8275 | 19508 | 22361 | 26432 | 9825 | 11290 | 190837
Grand total: |  | 16317 | 10803 | 26294 | 42451 | 34007 | 22914 | 15368 | 31864 | 35839 | 39542 | 15472 | 17022 | 307893
Spreadsheet: 42e95595-bbd0-4c98-80f1-eaa3bd221d05
Sheet: Sheet1

Table 7--U.S. textile exports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Mar. | Apr. | May |  | May
Item | 2013 | 2013 | 2013 |  | 2012
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 244937.66 | 244686.047 | 261147.236 |  | 242916.198
Cotton | 130801.615 | 125705.037 | 138017.092 |  | 122404.056
Linen | 7018.848 | 6790.453 | 7401.513 |  | 7029.989
Wool | 2463.349 | 2870.298 | 2849.722 |  | 3329.681
Silk | 1270.316 | 1054.95 | 1278.736 |  | 1187.411
Manmade | 103383.532 | 108265.309 | 111600.173 |  | 108965.061
Apparel: | 27042.419 | 26462.174 | 29963.346 |  | 25192.224
Cotton | 11873.331 | 11643.623 | 12649.469 |  | 11255.011
Linen | 435.435 | 456.675 | 679.2 |  | 307.434
Wool | 1561.117 | 1488.855 | 1923.677 |  | 1246.979
Silk | 1251.246 | 1320.734 | 1629.411 |  | 1158.504
Manmade | 11921.29 | 11552.287 | 13081.589 |  | 11224.296
Home furnishings: | 4506.409 | 4528.871 | 5039.91 |  | 6145.53
Cotton | 2257.492 | 2253.592 | 2499.172 |  | 3051.567
Linen | 182.631 | 226.332 | 241.513 |  | 260.241
Wool | 121.151 | 101.616 | 118.359 |  | 129.118
Silk | 100.2 | 123.266 | 127.743 |  | 156.528
Manmade | 1844.935 | 1824.065 | 2053.123 |  | 2548.076
Floor coverings: | 31534.765 | 31854.42 | 31817.195 |  | 33349.636
Cotton | 2329.308 | 2291.035 | 2471.125 |  | 2110.363
Linen | 1205.378 | 1171.204 | 1289.971 |  | 1069.49
Wool | 3068.364 | 2983.614 | 2633.198 |  | 2946.957
Silk | 35.219 | 28.513 | 47.936 |  | 33.711
Manmade | 24896.496 | 25380.054 | 25374.965 |  | 27189.115
Total exports: 2/ | 308152.341 | 307619.383 | 328135.274 |  | 307728.194
Cotton | 147336.096 | 141959.172 | 155696.818 |  | 138915.158
Linen | 8842.291 | 8644.664 | 9612.196 |  | 8667.153
Wool | 7219.131 | 7447.393 | 7606.597 |  | 7656.504
Silk | 2656.981 | 2527.463 | 3083.827 |  | 2536.153
Manmade | 142097.842 | 147040.691 | 152135.836 |  | 149953.226
1/ Raw-fiber equivalent.  2/ Includes headgear.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 07/15/13.
Spreadsheet: 700726d1603305941-payroll-sreadsheet-payroll-michel-ralph-eba
Sheet: Table 1

 |  |  |  |  |  |  |  |  |  | SUPPRESSION
PAY PERIOD:   Oct 10  -  23, 2020       KENNER FIRE DEPARTMENT BI-WEEKLY TIME SHEET
CERTIFIED  CORRECT: |  |  |  |  |  |  |  |  |  |  |  |  |  | “A” |  |  |  |  | “B |  |  |  |  |  | “C”
EMPLOYEE | 10 S | 11 S | 12 M | 13 T | 14 W | 15 T | 16 F | 17 S | 18 S |  | 19 M | 20 T | 21 W |  | 22 T | 23 F |  | REGULAR | ACTING | HOLIDAY | ACTING OL | [NAME] | ACTING O.T. | SCHEDULE OT |  | ANNUAL VACATION | SICK | ACTING I | REMARKS
R/A/H/OT/AOT/SOT/V/S |  |  |  | A | A | V | V | A | A |  | A | A |  |  |  | V
R.MICHEL 3150 |  |  |  | 17 | 7 | 17 | 7 | 17 | 7 |  | 17 | 7 |  |  |  | 17
Employee Signature:                                                                                    Date:
[NAME]'s Signature:                                                                                Date:
Comments:
REGULAR |  | R
ACTING |  | A
HOLIDAY |  | H
OVERTIME |  | OT
ACTING OVERTIME |  | AOT
SCHEDULE OT |  | SOT
ANNUAL VACATION |  | V
SICK |  | S
Spreadsheet: 817059d1675969627-conditional-formatting-with-multiple-selection-of-cells-for-mrexcel
Sheet: Sheet1

Block | Acreage | Crops |  |  | Result
1 | 55 | Cotton |  |  | Crops | blocks | Acreage
2 | 55 | Wheat |  |  | Cotton | 1 | 25
3 | 60 | [NAME] |  |  | Wheat | 1 | 40
4 | 40 | Peas |  |  | [NAME]
5 | 55 | [NAME] |  |  | Peas
6 | 40 | AlfaAlfa |  |  | [NAME]
7 | 40 |  |  |  | AlfaAlfa
8 | 65
9 | 55
10 | 35
11 | 50
Spreadsheet: 129845d1321927020-ranking-ranking-score-sheet
Sheet: Sheet1

 | Application No. | Person | Person | Person | Person | Person | Person | Person
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 1 | 1 | 4 | 1 | 1 | 2 | 1 | 3
 | 2 | 1 | 3 | 4 | 3 | 1 | 2 | 2
 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 4
 | 4 | 4 | 1 | 3 | 4 | 4 | 4 | 1
 | 5 | 1 | 1 | 2 | 3 | 1 | 2 | 1
 | 6 | 2 | 4 | 1 | 2 | 3 | 1 | 3
 | 7 | 3 | 2 | 3 | 4 | 2 | 3 | 2
 | 8 | 4 | 3 | 4 | 1 | 4 | 4 | 4
 | 9 | 1 | 1 | 3 | 1 | 1 | 3 | 2
 | 10 | 2 | 4 | 2 | 3 | 3 | 2 | 1
 | 11 | 3 | 2 | 4 | 2 | 2 | 4 | 3
 | 12 | 4 | 3 | 1 | 4 | 4 | 1 | 4
 | 13 | 1 | 3 | 1 | 1 | 1 | 2 | 1
 | 14 | 2 | 2 | 4 | 3 | 4 | 1 | 4
 | 15 | 3 | 4 | 2 | 2 | 2 | 3 | 2
 | 16 | 4 | 1 | 3 | 4 | 3 | 4 | 3
 | 17 | 1 | 2 | 3 | 3 | 2 | 1 | 3
 | 18 | 2 | 1 | 2 | 2 | 1 | 4 | 2
 | 19 | 3 | 3 | 4 | 4 | 3 | 2 | 4
 | 20 | 4 | 4 | 1 | 1 | 4 | 3 | 1
 | 21 | 1 | 1 | 2 | 1 | 1 | 3 | 1
 | 22 | 2 | 4 | 1 | 4 | 3 | 2 | 3
 | 23 | 3 | 2 | 3 | 2 | 2 | 4 | 2
 | 24 | 4 | 3 | 4 | 3 | 4 | 1 | 4
 | 25 | 1 | 3 | 2 | 3 | 1 | 2 | 1
 | 26 | 2 | 2 | 1 | 2 | 3 | 1 | 3
 | 27 | 3 | 4 | 3 | 4 | 2 | 3 | 2
 | 28 | 4 | 1 | 4 | 1 | 4 | 4 | 4
 | 29 | 1 | 1 | 3 | 1 | 2 | 1 | 1
 | 30 | 2 | 3 | 2 | 3 | 1 | 3 | 3
 | 31 | 3 | 2 | 4 | 2 | 3 | 2 | 2
 | 32 | 4 | 4 | 1 | 4 | 4 | 4 | 4
 | 33 | 1 | 3 | 1 | 1 | 3 | 1 | 2
 | 34 | 2 | 2 | 3 | 3 | 2 | 3 | 1
 | 35 | 3 | 4 | 2 | 2 | 4 | 2 | 3
 | 36 | 4 | 1 | 4 | 4 | 1 | 4 | 4
 | 37 | 1 | 1 | 2 | 3 | 2 | 1 | 3
 | 38 | 2 | 3 | 1 | 2 | 1 | 3 | 2
 | 39 | 3 | 2 | 3 | 4 | 3 | 2 | 4
 | 40 | 4 | 4 | 4 | 1 | 4 | 4 | 1
 |  | 1 = Top 10
 |  | 2 = Between 10 - 20
 |  | 3 = Between 20 - 30
 |  | 4 = Between 30 - 40
Spreadsheet: 477207d1472185578-condition-fomatting-condition-format
Sheet: Sheet1

a | a | a | 2 |  | 1-2 | LOW
a | a | a | 5 |  | 3 | MEDIUM
a | a | a | 1 |  | 4-5 | HIGH
a | a | a | 1
a | a | a | 3
a | a | a | 3
a | a | a | 2
a | a | a | 5
a | a | a | 4
a | a | a | 4
a | a | a | 5
a | a | a | 2
a | a | a | 1
Spreadsheet: 162299d1339787291-formula-question-2012-06-14-oeldere-
Sheet: Blad1

 |  |  |  | helpcolum
2 |  | 40 |  | 2 |  | 40
3 |  |  |  | 3
4 |  |  |  | 0
5 |  |  |  | 1
6 |  |  |  | 2
7 |  |  |  | 3
8 |  |  |  | 0
9 |  |  |  | 1
10 |  |  |  | 2
11 |  |  |  | 3
12 |  |  |  | 0
13 |  |  |  | 1
14 |  |  |  | 2
15 |  |  |  | 3
16 |  |  |  | 0
17 |  |  |  | 1
Spreadsheet: 163456d1340309830-autosort-formula-ek-poule-2012
Sheet: Deelnemers en stand

Naam | punten |  | Aantal deelnemers:
 |  |  | Prijzenpot:
 |  |  | aantal prijzen:
 |  |  | 1e prijs
 |  |  | 2e prijs
 |  |  | 3e prijs
 |  |  | 4e prijs
Spreadsheet: 103605d1301346247-list-matching-values-indexmatch-example
Sheet: Sheet2

A Series |  |  |  |  | B Series
 |  |  | A1 |  |  |  |  | B1
 |  |  | A2 |  |  |  |  | B2
 |  |  | A3 |  |  |  |  | B3
 |  |  | A4 |  |  |  |  | B4
 |  |  | A5 |  |  |  |  | B5
 |  |  | A6 |  |  |  |  | B6
 |  |  | A7 |  |  |  |  | B7
 |  |  | A8 |  |  |  |  | B8
 |  |  | A9 |  |  |  |  | B9
 |  |  | A10 |  |  |  |  | B10
 |  |  | A11 |  |  |  |  | B11
 |  |  | A12 |  |  |  |  | B12
 |  |  | A13 |  |  |  |  | B13
 |  |  | A14 |  |  |  |  | B14
 |  |  | A15 |  |  |  |  | B15
Spreadsheet: 586906d1534735874-formula-add-the-largest-sequence-of-only-consecutive-positive-numbers-from-a4-a20-sum-of-max-run-total-using-helpers
Sheet: Sheet1

Numbers | Helper1 | Helper2 |  | [NAME] | Count of Max
 |  |  |  |  | << This is your answer using an Array Formula.
 |  |  |  |  | Press F9 to recalculate the random numbers in Column A
 |  |  |  |  | See the [NAME] run number change
 |  |  |  |  | Keep F9ing until count of [NAME] =2, then check to see if the formula is correct.
Spreadsheet: 868407d1715159690-calculating-summary-sheet-using-indirect-function-for-multiple-months-payroll-example
Sheet: Feb-2024

Emp Code | [NAME] | Date | Roster Schedule | Roster Location | Start Time | End Time | Roster TTL excl Lunch | FT Official Hour | Place | Clock In | Clock Out | Lunch | Lateness | Early Leave | Overtime | Total Hours | Compare
147 | [NAME] | 2024-02-01 00:00:00 | Off-1
147 | [NAME] | 2024-02-02 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 12:11:00 | 22:15:00 | 0
147 | [NAME] | 2024-02-03 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 12:25:00 | 23:18:00
147 | [NAME] | 2024-02-04 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 12:11:00 | 22:05:00 | 0
147 | [NAME] | 2024-02-05 00:00:00 | 09:15-18:30 |  |  |  |  |  | OP | 10:01:00 | 19:00:00 | 1
147 | [NAME] | 2024-02-06 00:00:00 | Off-1
147 | [NAME] | 2024-02-07 00:00:00 | 09:15-18:30 |  |  |  |  |  | OP | 09:44:00 | 18:34:00 | 1
147 | [NAME] | 2024-02-08 00:00:00 | 09:30-15:00 |  |  |  |  |  | OP | 09:29:00 | 15:06:00 | 0
147 | [NAME] | 2024-02-09 00:00:00 | 09:15-18:30 |  |  |  |  |  | OP | 09:54:00 | 18:30:00 | 1
147 | [NAME] | 2024-02-10 00:00:00 | 08:45-19:30 |  |  |  |  |  | OP | 08:45:00 | 19:30:00 | 0
147 | [NAME] | 2024-02-11 00:00:00 | 08:45-19:30 |  |  |  |  |  | OP | 08:44:00 | 20:00:00 | 0.25
147 | [NAME] | 2024-02-12 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 12:23:00 | 22:15:00 | 0.5
147 | [NAME] | 2024-02-13 00:00:00 | Off-1
147 | [NAME] | 2024-02-14 00:00:00 | 08:45-19:30 |  |  |  |  |  | OP | 09:26:00 | 19:30:00 | 0.25
147 | [NAME] | 2024-02-15 00:00:00 | 08:45-19:30 |  |  |  |  |  | OP | 09:01:00 | 19:30:00 | 0
147 | [NAME] | 2024-02-16 00:00:00 | 08:45-19:00 |  |  |  |  |  | OP | 08:44:00 | 19:34:00 | 1
147 | [NAME] | 2024-02-17 00:00:00 | 08:45-19:00 |  |  |  |  |  | OP | 09:08:00 | 19:47:00 | 1
147 | [NAME] | 2024-02-18 00:00:00 | 08:45-19:30 |  |  |  |  |  | OP | 09:05:00 | 19:35:00 | 1
147 | [NAME] | 2024-02-19 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 11:44:00 | 21:15:00 | 1
147 | [NAME] | 2024-02-20 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 11:58:00 | 21:02:00 | 1
147 | [NAME] | 2024-02-21 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 12:11:00 | 21:06:00 | 1
147 | [NAME] | 2024-02-22 00:00:00 | Off-1
147 | [NAME] | 2024-02-23 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 11:59:00 | 23:00:00 | 1
147 | [NAME] | 2024-02-24 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 12:10:00 | 22:00:00 | 1
147 | [NAME] | 2024-02-25 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 11:51:00 | 22:00:00 | 1
147 | [NAME] | 2024-02-26 00:00:00 | 09:15-19:15 |  |  |  |  |  | OP | 09:44:00 | 19:30:00 | 1
147 | [NAME] | 2024-02-27 00:00:00 | Off-1
147 | [NAME] | 2024-02-28 00:00:00 | Off-1
147 | [NAME] | 2024-02-29 00:00:00 | 09:15-19:15 |  |  |  |  |  | OP | 09:15:00 | 19:15:00 | 1
147 | [NAME] | 2024-03-01 00:00:00 | Off-1
PWHK147 | [NAME] | 2024-03-02 00:00:00 | Off-1
Total
 |  |  |  |  |  |  |  |  |  |  |  |  | EG
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 7.7
 |  |  |  |  |  |  |  |  |  |  |  |  | 07:46:00
Spreadsheet: 236279d1368735484-creating-a-drop-down-which-changes-adjacent-cell-data-25_08_2010_example_for_i-need-help
Sheet: Search

 |  |  |  | Models Number |  | Description
 |  |  |  | ABC |  | 123
 |  |  |  | ║ |  | ║
 |  |  |  | ║ |  | ╚> | =PROCV(E5;Models_Table!A1:B9;2;0)
 |  |  |  | ║
 |  |  |  | ║
 |  |  |  | ║
 |  |  |  | ║
ABC | <═ This list is used to Validation Cell |  |  | . <[NAME]
DEF
GHI
JKL
MNO
PQR
STU
VWX
YZZ
Spreadsheet: 143211d1330303178-problems-with-pivot-table-sales-summary-test
Sheet: Pivot

Channel | (All)
 | Values
Row Labels | Units Sold | $ Sales | $ GM | % GMN | Margin | [NAME]
Medium screw | 360 | 402.45 | 284.85 | 0.7077897875512486
Small screw | 335 | 427.35 | 240.81 | 0.5634959634959634
Large Screw | 92 | 90.61 | 37.22 | 0.4107714380311224
(blank)
Grand Total | 787 | 920.4100000000001 | 562.8800000000001 | 0.611553546788931
 | * How do I insert a calculated field to show the cumulative margin, as a % of total margin?
 | * In trying to use a helper column, I can't get the cell formula in column F to pick up the value in column D. Even removing absolute cell references does not help
Spreadsheet: 848725d1699377716-avoid-ref-error-when-deleting-columns-excel-help-forum-examples
Sheet: BEFORE Deletion

 | 2023-11-03 00:00:00 |  | Accumulated Savings: |  |  | Accumulated Savings: |  |  | Accumulated Savings: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 | Amt | Deposited? |  | Amt | Deposited? |  | Amt | Deposited? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
Income | 300 | Y | - | 350 | Y | - | 325 | Y | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A
Expenses | 200 | N/A | - | 200 | N/A | - | 200 | N/A | -
Savings |  |  |  |  | N
Rollover from previous period |  |  | N/A
Spreadsheet: 8f4a7945-31de-4a24-b3ac-dc96332a476c
Sheet: Salaries

Service Center Calculations
Salaries & Benefits Expenditures
Purpose:  To list personnel paid on the service center and allocate personnel costs to each service.
Sheet Instructions
1) Only fill in the areas shaded in yellow
2) Fill in the name of the person(s) that is providing the service (board apptd only)
3) For TH employee costs you may put in a lump sum total for the estimated expenditures.
4) Fill in that person's PCN
5) Enter in the employee type |  | *<<Type is EX for exempt, CL for classified, TH for temporary help, or GA for graduate assistant>>
6) Enter in the employee's annual salary
7) Enter in the employee's annual FTE (0.5, 1, 0.75, etc.)
8) Enter in the FTE % of this employee's time associated with the service and this budget
 |  |  |  |  |  |  | SERVICE 1 |  | SERVICE 2
NAME | PCN | TYPE* | ANNUAL SALARY | FTE | FRINGES | TOTAL COST | FTE % | Amount | FTE % | Amount
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
TOTAL SALARIES
Fringe Benefits* | Rate
Variable | 0.24
Fixed (Health) | 8600
TH | 0.0872
GA | 0.0051
*The FB rates can be modified if needed in this rate box
Spreadsheet: 695051d1600010285-count-unique-values-if-consecutive-condition-registru1
Sheet: Foaie1

 | Name | Month | Score
 | [NAME] | 2020-01-01 00:00:00 | 5
 | [NAME] |  | 2
 | Mark |  | 0
 | Amber |  | 5
 | [NAME] |  | 6
 | [NAME] |  | 4
 | Mark |  | 0
 | Amber |  | 0
 | [NAME] |  | 3
 | [NAME] |  | 4
 | Mark |  | 0
 | Amber |  | 0
 | [NAME] |  | 2
 | Mark |  | 0
 | Amber |  | 0
 | [NAME] |  | 6
 | Ester |  | 0
 | Mark |  | 0
 | Amber |  | 0
 | [NAME] |  | 3
 | Ester |  | 5
 | Mark |  | 0
 | [NAME] |  | 2
 | Ester |  | 3
 | Mark |  | 7
 | Timothy |  | 1