tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 725463d1616686441-aderence-forumla-help-please-adherence
Sheet: Adherence

 | Lunch |  |  |  |  |  |  |  | Comfort
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2021-03-01 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-01 00:00:00
2021-03-02 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-02 00:00:00
2021-03-03 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-03 00:00:00
2021-03-04 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-04 00:00:00
2021-03-05 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-05 00:00:00
2021-03-06 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-06 00:00:00
2021-03-07 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-07 00:00:00
2021-03-08 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-08 00:00:00
2021-03-09 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-09 00:00:00
2021-03-10 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-10 00:00:00
2021-03-11 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-11 00:00:00
2021-03-12 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-12 00:00:00
2021-03-13 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-13 00:00:00
2021-03-14 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-14 00:00:00
2021-03-15 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-15 00:00:00
2021-03-16 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-16 00:00:00
2021-03-17 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-17 00:00:00
2021-03-18 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-18 00:00:00
2021-03-19 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-19 00:00:00
2021-03-20 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-20 00:00:00
2021-03-21 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-21 00:00:00
2021-03-22 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-22 00:00:00
2021-03-23 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-23 00:00:00
2021-03-24 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-24 00:00:00
2021-03-25 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-25 00:00:00
2021-03-26 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-26 00:00:00
2021-03-27 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-27 00:00:00
2021-03-28 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-28 00:00:00
2021-03-29 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-29 00:00:00
2021-03-30 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-30 00:00:00
2021-03-31 00:00:00 |  |  |  |  |  |  |  |  | 2021-03-31 00:00:00
Spreadsheet: 860890d1708906736-index-match-on-multiple-results-try1
Sheet: Discount % Approved

[NAME] | Discount Type | % | Customer Name | Date Approved
[NAME] | Discount Type | % | Customer Name | Date Approved
666571 | Huge | 50 | Techno Lg5 | 2021-05-01 00:00:00
444482 | Classic | 7.2 | Techno Lg5 | 2021-08-07 00:00:00
345 | Medium | 20 | Techno Lg5 | 2022-05-06 00:00:00
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 6802 | 5488 |  |  | 1020 | 1011 | 1891 | 1414
2 | 6013 | 5488 |  |  | 1005 | 1011 | 577 | 1414
3 | 5948 | 5488 |  |  | 1055 | 1011 | 1908 | 1414
4 | 6198 | 5488 |  |  | 1045 | 856 | 1668 | 1414
5 | 6168 | 5488 |  |  | 607 | 1011 | 1539 | 1414
6 | 6277 | 5488 | 898 |  | 978 | 1011 | 1481 | 1414
7 | 6183 | 5488 | 2419 |  | 1079 | 506 | 1419 | 1414
8 | 6277 | 5488 | 2312 | 1000 | 1035 | 1007 | 1405 | 1414
9 | 6323 | 5488 | 2355 | 1000 | 1015 | 1011 | 1492 | 1414
10 | 3536 | 5488 | 2271 | 1000 | 871 | 1011 | 1559 | 1414
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  | 423166.07
2001-12-10 00:00:00
CBS Volume
 |  |  | 174196
Spreadsheet: 704100d1605361050-redistribute-rebalance-percentages-percentage
Sheet: Sheet1

Token |  | Percentage |  | New Balanced
Asset1 |  | 0.7554830037098831 |  | 0.2
Asset2 |  | 0.1350910343217953
Asset3 |  | 0.01314133138239288
Asset4 |  | 0.01306883481185067
Asset5 |  | 0.01043900546088098
Asset6 |  | 0.009879816653137608
Asset7 |  | 0.008637746277701995
Asset8 |  | 0.007995864021321188
Asset9 |  | 0.007719320307237786
Asset10 |  | 0.005513255791807297
Asset11 |  | 0.005012536477499633
Asset12 |  | 0.004463589555460924
Asset13 |  | 0.004174951195840994
Asset14 |  | 0.004038431065181004
Asset15 |  | 0.003456376425504
Asset16 |  | 0.003456376425504
Asset17 |  | 0.00294656855861491
Asset18 |  | 0.00286007418247807
Asset19 |  | 0.002621883375907665
Spreadsheet: 587388d1534998604-scoring-between-tables-looking-at-data-set-copy-of-scoring-table-tennis-matthewmunro-
Sheet: Sheet1

Table Tennis Scoring
Date |  | Player 1 | Player 2 | Score Player 1 | Score Player 2 | [NAME] 1 | [NAME] 2 |  | Individual: | Win % |  | Player vs Player | Win % |  | Player vs Player | Average score
2018-08-16 00:00:00 | Game 1 | [NAME] | [NAME] | 11 | 7 | Win | Lose |  | [NAME] |  |  | [NAME] [NAME] |  |  | [NAME] [NAME]
 | Game 2 | [NAME] | [NAME] | 5 | 11 | Lose | Win |  | [NAME] |  |  | [NAME] vs [NAME] |  |  | [NAME] vs [NAME]
 | Game 3 | [NAME] | [NAME] | 9 | 11 | Lose | Win |  | Kurt H |  |  | [NAME] |  |  | [NAME]
 | Game 4 | [NAME] | [NAME] | 11 | 9 | Win | Lose |  |  |  |  | Kurt H vs [NAME] |  |  | Kurt H vs [NAME]
 | Game 5 | [NAME] | [NAME] | 9 | 11 | Lose | Win |  |  |  |  | [NAME] vs Kurt H |  |  | [NAME] vs Kurt H
 | Game 6 | [NAME] | [NAME] | 8 | 11 | Lose | Win |  |  |  |  | Kurt H vs [NAME] |  |  | Kurt H vs [NAME]
 | Game 7 | [NAME] | [NAME] | 11 | 13 | Lose | Win
 | Game 8 | [NAME] | Kurt H | 11 | 6 | Win | Lose
 | Game 9 | [NAME] | Kurt H | 11 | 4 | Win | Lose
 | Game 10 | [NAME] | Kurt H | 9 | 11 | Lose | Win
 | Game 11 | [NAME] | Kurt H | 11 | 3 | Win | Lose
 | Game 12 | [NAME] | Kurt H | 11 | 8 | Win | Lose
Spreadsheet: 803756d1667665227-need-an-alternative-to-vlookup-that-returns-all-values-found-spa-lista-de-estabelecimentos-dsavrlvt-29_07_2022
Sheet: CO_não programados_não atrasado

[NAME] | Estabelecimento | DAV | Observações | Data da Vistoria | [NAME] | GC
49313 | CIMPOR - INDÚSTRIA DE CIMENTOS, S.A. - Centro de Produção de Alhandra (RSC 006) | O | CD ALTERA GC | 2022-01-06 00:00:00 | CD | 1
49408 | INTERAVES , [NAME] | O | CV a pedido do operador (suspensão) | 2022-01-12 00:00:00 | VV | 2
49456 | Pet Memorial - Crematório de Animais (V 8107) | O | CD ALTERA GC | 2022-01-17 00:00:00 | CD | 1
49585 | Gomes & Severino Lda. (VST 041) | O | CD SEM ALTERAÇÃO DO GC | 2022-01-24 00:00:00 | CD | 2
49633 | Blueotter Circular, S.A. (V 8099) | O | CD ALTERA GC | 2022-01-31 00:00:00 | CD | 1
49758 | O CEREAL – Comércio e Indústria de Cereais, Lda.(VSE 018) | R | CD INFORMAÇÃO OPERADOR, SEM LABORAÇÃO | 2022-02-10 00:00:00 | CD | 0
50161 | MARINHAVE - Sociedade Agro-Avícola, S.A.(RST 034) | R | CD ALTERA GC | 2022-03-08 00:00:00 | CD | 1
50319 | AVIPERDIGÃO – Soc. Agro – Pecuária, Lda.(RSP 517) | O | CD ALTERA GC | 2022-03-14 00:00:00 | CD | 1
50321 | TRIPERÚ-Sociedade de Produção e Comercialização de Aves (V 8096) | O | CD ALTERA GC | 2022-03-15 00:00:00 | CD | 1
50308 | Agrofaria II, Lda (V 8096) | O | CD ALTERA GC | 2022-03-17 00:00:00 | CD | 1
50471 | Componatura, Lda. ([NAME] 037) | R | CD SEM ALTERAÇÃO DO GC | 2022-03-25 00:00:00 | CD | 2
50681 | AVENAL PETFOOD, S.A. (VAC 003) | O | CD ALTERA GC | 2022-04-11 00:00:00 | CD | 1
50898 | EUROCEREAL - Comercialização de Produtos Agro-Alimentares, S.A. (RSE 007) | O | CD ALTERA GC | 2022-05-02 00:00:00 | CD | 1
51120 | Tratolixo - Tratamento Resíduos Sólidos, SA (V 8012) | O | CD ALTERA GC | 2022-05-19 00:00:00 | CD | 1
Spreadsheet: chris_germany__2056__MCV Invoice Analysis 4-29-02
Sheet: April Deficiency

Gray represents what MCV is claiming
APRIL 2002 Enron Deficiency
Pipeline | Point | Contract MMBtu | Contract Price | Inside FERC | Replacement Price | Repl. Price % Diff from IF | Deficiency $/ MMBtu | Total Deficiency due to MCV
ANRSE | SE Headstation | 120000 | 2.46 | 3.31 | 3.3125
PEPL | Field Zone | 150000 | 2.44 | 3.29 | 3.3345
TRLN | Field Zone | 180000 | 2.455 | 3.28 | 3.28
Note that Article II of the May 1996 Purchase Agreement, states that buyer's deficiency
price "shall be no greater than one hundred and eight percent (108%) of the Inside Ferce Price".
Spreadsheet: 788522d1658509542-text-doesnt-wrap-up-as-intended-in-the-cells-containing-copied-formula-formula-formatting-problem
Sheet: Sheet1

Age | Prescribed medicine | Theoretical dose | Prescribed dose | Correct dose | Under-dosed | Over-dosed
67 | Dabigatran 110mg cap
90 | Dabigatran 150mg cap
65 | Dabigatran 110mg cap
70 | Dabigatran 150mg cap
87 | Dabigatran 150mg cap
90 | Dabigatran 150mg cap
65 | Dabigatran 110mg cap
90 | Dabigatran 150mg cap
69 | Dabigatran 150mg cap
Spreadsheet: 868961d1715670181-embedded-excel-file-not-working-on-website-funeral-landing-page_quote_v4
Sheet: All_Other

Cover | (01-05) | (06-17) | (18-24) | (25-34) | (35-44) | (45-54) | (55-64) | (65-69) | (70-74) | (75-79) | (80-84)
2000 | 7 | 7 | 9 | 12 | 13 | 18 | 29 | 46 | 48 | 78 | 91
4000 | 13 | 13 | 17 | 24 | 26 | 35 | 57 | 91 | 95 | 156 | 181
10000 | 32 | 32 | 42 | 58 | 63 | 86 | 141 | 226 | 237 | 389 | 452
14000 | 45 | 45 | 59 | 81 | 89 | 120 | 198 | 317 | 331 | 544 | 633
20000 | 63 | 63 | 84 | 116 | 126 | 171 | 282 | 452 | 473 | 777 | 903
24000 | 0 | 74 | 99 | 136 | 147 | 199 | 328 | 527 | 551 | 906 | 1053
30000 | 0 | 86 | 114 | 157 | 171 | 230 | 381 | 611 | 639 | 1049 | 1220
50000 | 0 | 132 | 175 | 241 | 262 | 354 | 585 | 0 | 0 | 0 | 0
74000 | 0 | 187 | 249 | 343 | 374 | 504 | 834 | 0 | 0 | 0 | 0
Age | Cover Amount |  | Premium
5 | 10000
Spreadsheet: 38443d1236615305-excel-2007-having-problem-with-averageifs-formula-monthly-gas-reports-2009-ne
Sheet: 2-9 thru 2-15

 |  |  |  |  |  | System:
 |  |  | 2009-02-09 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2009-02-09 00:00:00 |  |  |  |  |  |  | Total
1 |  |  | 63.5
2 |  |  | 68.23
3 |  |  | 55
4 |  | 39.35 |  |  | 41.54 |  | 41.89
5 |  |  |  |  | 33.96
6 |  |  |  |  | 24.34 |  |  | 40.46
7 |  |  | 50 |  |  |  |  | 38.2
8 |  |  |  |  |  |  | 39.06
9
10 |  |  |  |  |  |  |  | 35.58
11 |  | 43.6
12 |  | 36.83 |  |  |  | 36.01
13 |  |  |  | 39.15 |  | 40.97
14 |  |  |  |  | 39.11
15 |  |  |  |  |  | 37.35
16 |  |  | 29.68 |  | 31.76 |  |  | 22.15
17 |  | 30.7 |  |  |  | 38.36
18 |  | 29.65 |  |  |  | 35.21
19 |  |  |  | 36.35
20
21
22
23
24
25
 |  |  |  |  |  |  | Total:
Spreadsheet: 765508d1643368687-generate-unique-id-for-duplicate-cell-values-example-1-
Sheet: Sheet1

Invocie No | [NAME] | Concatenate
42006 | A
42006 | B
42006 | C
42006 | D
42777 | A
44757 | A
48929 | A
49806 | A
49806 | B
49806 | C
51232 | A
11131a | A
11131a | B
52313 | A
54096 | A
54570 | A
54570 | B
54570 | C
Spreadsheet: 882489d1730885635-matching-values-across-tables-grid
Sheet: Sheet1

Machine A | Machine B | Machine C | SKU | Plant |  |  | SKU | Machine A | Machine A | Machine A | Machine B | Machine B | Machine B | Machine C | Machine C | Machine C
X |  |  | 1 | New York |  |  |  | New York | Wisconsin | Idaho | New York | Wisconsin | Idaho | New York | Wisconsin | Idaho
 |  | X | 1 | Wisconsin |  |  | 1 | X |  |  |  |  |  |  | X
 |  |  | 1 | Idaho |  |  | 2 |  |  |  |  | X | X |  | X
 |  |  | 2 | New York |  |  | 3 | X | X | X |  |  |  |  | X
 | X | X | 2 | Wisconsin
 | X |  | 2 | Idaho
X |  |  | 3 | New York
X |  | X | 3 | Wisconsin
X |  |  | 3 | Idaho
Spreadsheet: 865214d1712252988-sumifs-with-index-and-match-ef1634_pensionable-pt-hours
Sheet: Calc_sheet

pensionable1 | pensionable2 | pensionable3 |  | Start date | End date | PThours1 | PThours2 | PThours3 | PThours1 if code in column E is pensionable | PThours1 if code in column F is pensionable | PThours1 if code in column G is pensionable |  | Expenditure codes | Pensionable
 |  |  |  | 2009-09-01 00:00:00 | 2010-08-31 00:00:00 |  |  |  |  |  |  |  | 20030 | No
 |  |  |  | 2010-09-01 00:00:00 | 2011-08-31 00:00:00 |  |  |  |  |  |  |  | 39300 | No
 |  |  |  | 2011-09-01 00:00:00 | 2012-08-31 00:00:00 |  |  |  |  |  |  |  | 44744 | No
 |  |  |  | 2012-09-01 00:00:00 | 2013-08-31 00:00:00 |  |  |  |  |  |  |  | 45994 | Yes
 |  |  |  | 2013-09-01 00:00:00 | 2014-08-31 00:00:00 |  |  |  |  |  |  |  | 46028 | Yes
 |  |  |  | 2014-09-01 00:00:00 | 2015-08-31 00:00:00 |  |  |  |  |  |  |  | 46500 | Yes
 |  |  |  | 2015-09-01 00:00:00 | 2016-08-31 00:00:00 |  |  |  |  |  |  |  | 46511 | No
 |  |  |  | 2016-09-01 00:00:00 | 2017-08-31 00:00:00 |  |  |  |  |  |  |  | 46514 | No
 |  |  |  | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 |  |  |  |  |  |  |  | 46531 | No
 |  |  |  | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 |  |  |  |  |  |  |  | 46532 | No
 |  |  |  | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  |  |  |  |  |  |  | 46533 | No
 |  |  |  | 2020-09-01 00:00:00 | 2021-08-31 00:00:00 |  |  |  |  |  |  |  | 46900 | No
 |  |  |  |  |  |  |  |  |  |  |  |  | 48110 | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  | 48572 | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  | 48577 | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  | 48579 | Yes
Spreadsheet: 771018d1646389092-conditional-formating-based-on-the-some-values-example
Sheet: Sheet1

Input
2022-01-01 00:00:00 | [NAME] | Dog |  |  | Compare values based on values in column C
2022-01-02 00:00:00 | [NAME] | Dog |  |  | Number of same values is randomly
2022-01-03 00:00:00 | [NAME] | Dog |  |  | i need fill each second entry fill with another colour
2022-01-04 00:00:00 | Persian | Cat
2022-01-05 00:00:00 | Persian | Cat
2022-01-06 00:00:00 | My | Cat
2022-01-07 00:00:00 | Fero | Goose
2022-01-08 00:00:00 | [NAME] | Goose
2022-01-09 00:00:00 | Karol | Dog
2022-01-10 00:00:00 | Matus | dog
2022-01-11 00:00:00 | Karol | [NAME]
2022-01-12 00:00:00 | Jozeg | [NAME]
Output
2022-01-01 00:00:00 | [NAME] | Dog
2022-01-02 00:00:00 | [NAME] | Dog
2022-01-03 00:00:00 | [NAME] | Dog
2022-01-04 00:00:00 | Persian | Cat
2022-01-05 00:00:00 | Persian | Cat
2022-01-06 00:00:00 | My | Cat
2022-01-07 00:00:00 | Fero | Goose
2022-01-08 00:00:00 | [NAME] | Goose
2022-01-09 00:00:00 | Karol | Dog
2022-01-10 00:00:00 | Matus | dog
2022-01-11 00:00:00 | Karol | [NAME]
2022-01-12 00:00:00 | Jozeg | [NAME]
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: SMS

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Program
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | SMS 101 | 1
5 | SMS 102 | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 47208d1246144109-pivot-table-using-custom-calculation-excel-customcalculated-example-926e
Sheet: Pivot

SKU | Recipe | Demand | Rate
K1001 | A | 100 | 4 |  |  |  |  |  |  | Data
[NAME] | A | 250 | 3 |  |  |  |  | Recipe | Rate | Sum of Demand | Demand % Total |  | Calculated field I want?
K1003 | A | 1500 | 6 |  |  |  |  | A | 3 | 250 | 0.00927643784786642 |  | 0.02782931354359926
K1004 | A | 2500 | 7 |  |  |  |  |  | 4 | 100 | 0.003710575139146568 |  | 0.01484230055658627
X1001 | B | 500 | 8 |  |  |  |  |  | 6 | 1500 | 0.05565862708719851 |  | 0.3339517625231911
X1002 | B | 250 | 4 |  |  |  |  |  | 7 | 2500 | 0.09276437847866419 |  | 0.6493506493506493
X1003 | B | 2000 | 5 |  |  |  |  | A Total |  | 4350 | 0.1614100185528757
X1004 | B | 2500 | 6 |  |  |  |  | B | 4 | 250 | 0.00927643784786642 |  | 0.03710575139146568
E1001 | C | 500 | 8 |  |  |  |  |  | 5 | 2000 | 0.07421150278293136 |  | 0.3710575139146568
E1002 | C | 250 | 5 |  |  |  |  |  | 6 | 2500 | 0.09276437847866419 |  | 0.5565862708719851
L1001 | D | 100 | 5 |  |  |  |  |  | 8 | 500 | 0.01855287569573284 |  | 0.1484230055658627
L1002 | D | 3000 | 7 |  |  |  |  | B Total |  | 5250 | 0.1948051948051948
P1001 | E | 3500 | 9 |  |  |  |  | C | 5 | 250 | 0.00927643784786642 |  | 0.0463821892393321
P1002 | F | 10000 | 10 |  |  |  |  |  | 8 | 500 | 0.01855287569573284 |  | 0.1484230055658627
 |  |  |  |  |  |  |  | C Total |  | 750 | 0.02782931354359926
 |  |  |  |  |  |  |  | D | 5 | 100 | 0.003710575139146568 |  | 0.01855287569573284
Want to get the average rate by Recipe in relationship to demand. |  |  |  |  |  |  |  |  | 7 | 3000 | 0.111317254174397 |  | 0.7792207792207793
First step I took was to turn [NAME] in to "% of Total" using custom calculation |  |  |  |  |  |  |  | D Total |  | 3100 | 0.1150278293135436
The next step I want to do is multiple that % by rate to total the average rate. |  |  |  |  |  |  |  | E | 9 | 3500 | 0.1298701298701299 |  | 1.168831168831169
But I can not use custom calculation in a Calculated field? |  |  |  |  |  |  |  | E Total |  | 3500 | 0.1298701298701299
 |  |  |  |  |  |  |  | F | 10 | 10000 | 0.3710575139146567 |  | 3.710575139146568
 |  |  |  |  |  |  |  | F Total |  | 10000 | 0.3710575139146567
 |  |  |  |  |  |  |  | Grand Total |  | 26950 | 1 |  | 8.011131725417439 | Average rate - Want Pivot table to calculate
Spreadsheet: 169436d1342833270-input-the-cross-referenced-value-after-looking-up-a-table-index-match-rows-columns
Sheet: Sheet1

 |  |  |  |  | Stainless | Aluminium | Brass/Copper | Mild Steel | Plastics |  | Stainless | 1
Material |  |  |  | 1 | 200 | 400 | 250 | 180 | 600 |  | Aluminium | 1.6
Plastics |  |  |  | 1.6 | 140 | 280 | 156.25 | 112.5 | 420 |  | Brass/Copper | 2
 |  |  |  | 2 | 100 | 200 | 125 | 90 | 300 |  | Mild Steel | 2.4
Thickness mm |  |  |  | 2.4 | 83.333 | 166.666 | 104.166 | 75 | 250 |  | Plastics | 3
40 |  |  |  | 3 | 66.666 | 133.332 | 83.333 | 60 | 200 |  |  | 4
 |  |  |  | 4 | 50 | 100 | 62.5 | 45 | 150 |  |  | 5
Speed mm/min |  |  |  | 5 | 40 | 80 | 50 | 36 | 120 |  |  | 6
 | <<Look at this formula. |  |  | 6 | 33.333 | 66.666 | 41.666 | 30 | 100 |  |  | 8
 |  |  |  | 8 | 25 | 50 | 31.25 | 22.5 | 75 |  |  | 10
 |  |  |  | 10 | 20 | 40 | 25 | 18 | 60 |  |  | 12
 |  |  |  | 12 | 16.66 | 33.32 | 20.833 | 15 | 50 |  |  | 16
 |  |  |  | 16 | 12.5 | 25 | 15.625 | 11.25 | 37.5 |  |  | 20
 |  |  |  | 20 | 10 | 20 | 12.5 | 9 | 30 |  |  | 25
 |  |  |  | 25 | 8 | 16 | 10 | 7.2 | 24 |  |  | 32
 |  |  |  | 32 | 6.25 | 13 | 7.815 | 5.65 | 18.75 |  |  | 40
 |  |  |  | 40 | 5 | 10 | 6.25 | 4.5 | 15 |  |  | 50
 |  |  |  | 50 | 4 | 8 | 5 | 3.6 | 12
Spreadsheet: 93609d1293200930-automatic-number-and-date-sorting-formula-number_n_category_sorting
Sheet: BA_Database

BA Number | Invoice Date | Invoice Number | Invoice Amount | BA First Invoice Date | BA Total Amount | BA Total Rounddown Amount | BA Due Date | Days Left | Payment Bank | Payment Account Number
801102 | 2010-11-10 00:00:00 | INV20918 | 5000 | **would like to find the first invoice date, which is [NAME], from group number of BA number 801102
801102 | 2010-11-13 00:00:00 | INV20919 | 6390
801102 | 2010-11-12 00:00:00 | INV20920 | 8432
801102 | 2010-11-13 00:00:00 | INV20921 | 7582
801102 | 2010-11-09 00:00:00 | INV20922 | 8450
801102 | 2010-11-15 00:00:00 | INV20923 | 31242
801103 | 2010-11-12 00:00:00 | INV20924 | 3912
801103 | 2010-11-06 00:00:00 | INV20925 | 734
801103 | 2010-11-09 00:00:00 | INV20926 | 450
801103 | 2010-11-15 00:00:00 | INV20927 | 12
801104 | 2010-11-15 00:00:00 | INV20927 | 1699
Spreadsheet: 802443d1666858580-let-reference-inside-curly-brackets-not-accepted-unique-index-sort-sortfilterdemo
Sheet: Sheet1

Column1 | Column2 | Column3 | Wave | Column5 | Phase | Column7 | Task | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 |  |  |  | 1 | A
 |  |  | 1 |  | 1 |  | A |  |  |  |  |  |  |  |  |  | 1 | 1 | B
 |  |  | 1 |  | 1 |  | B |  |  |  |  |  |  |  |  |  | 1 | 1 | F
 |  |  | 1 |  | 2 |  | C |  |  |  |  |  |  |  |  |  | 1 | 1 | G
 |  |  | 1 |  | 3 |  | D |  |  |  |  |  |  |  |  |  | 1 | 2 | C
 |  |  | 1 |  | 1 |  | F |  |  |  |  |  |  |  |  |  | 1 | 2 | J
 |  |  | 1 |  | 1 |  | G |  |  |  |  |  |  |  |  |  | 1 | 2 | K
 |  |  | 4 |  | 2 |  | H |  |  |  |  |  |  |  |  |  | 1 | 2 | L
 |  |  | 5 |  | 2 |  | I |  |  |  |  |  |  |  |  |  | 1 | 3 | D
 |  |  | 1 |  | 2 |  | J |  |  |  |  |  |  |  |  |  | 1 | 3 | M
 |  |  | 1 |  | 2 |  | K |  |  |  |  |  |  |  |  |  | 1 | 3 | P
 |  |  | 1 |  | 2 |  | L |  |  |  |  |  |  |  |  |  | 2 | 1 | T
 |  |  | 1 |  | 3 |  | M |  |  |  |  |  |  |  |  |  | 2 | 3 | O
 |  |  | 3 |  | 3 |  | N |  |  |  |  |  |  |  |  |  | 2 | 3 | Q
 |  |  | 2 |  | 3 |  | O |  |  |  |  |  |  |  |  |  | 2 | 3 | R
 |  |  | 1 |  | 3 |  | P |  |  |  |  |  |  |  |  |  | 2 | 3 | S
 |  |  | 2 |  | 3 |  | Q |  |  |  |  |  |  |  |  |  | 3 | 1 | U
 |  |  | 2 |  | 3 |  | R |  |  |  |  |  |  |  |  |  | 3 | 1 | V
 |  |  | 2 |  | 3 |  | S |  |  |  |  |  |  |  |  |  | 3 | 3 | N
 |  |  | 2 |  | 1 |  | T |  |  |  |  |  |  |  |  |  | 4 | 1 | X
 |  |  | 3 |  | 1 |  | U |  |  |  |  |  |  |  |  |  | 4 | 2 | H
 |  |  | 3 |  | 1 |  | V |  |  |  |  |  |  |  |  |  | 5 | 2 | I
 |  |  | 4 |  | 1 |  | X
Spreadsheet: 146500d1332220183-macro-clear-function-in-a-row-that-has-value-choosingteams2v
Sheet: Teams

TEAM |  | TEAM |  | TEAM |  | TEAM |  | TEAM
 |  | Capts#name |  | Capts#name |  | Capts#name |  | Capts#name
TEAM |  | TEAM |  | TEAM |  | TEAM |  | TEAM
Capts#name |  | Capts#name |  | Capts#name |  | Capts#name |  | Capts#name
TEAM |  | TEAM |  | TEAM |  | TEAM |  | TEAM
Capts#name |  | Capts#name |  | Capts#name |  | Capts#name |  | Capts#name
Spreadsheet: 119900d1314839184-vlookup-failing-when-value-is-a-formula-vlookupcalc
Sheet: RAW Data

row_date | medcalls | abncalls | acdcalls1 | acdcalls2 | acdcalls3 | acdcalls4 | anstime
2011-07-01 00:00:00 | 4688 | 499 | 2595 | 54 | 63 | 72 | 273653
2010-10-01 00:00:00 | 4998 | 524 | 2961 | 77 | 59 | 76 | 262147
2010-11-01 00:00:00 | 5258 | 394 | 3715 | 60 | 62 | 74 | 167569
2010-12-01 00:00:00 | 5140 | 356 | 3693 | 45 | 53 | 69 | 185681
2011-01-01 00:00:00 | 5117 | 384 | 3505 | 61 | 73 | 66 | 182135
2011-02-01 00:00:00 | 5178 | 173 | 4305 | 44 | 43 | 38 | 85734
2011-03-01 00:00:00 | 5239 | 217 | 4382 | 50 | 28 | 42 | 84033
2011-04-01 00:00:00 | 4448 | 392 | 2705 | 49 | 44 | 44 | 237203
2011-05-01 00:00:00 | 5554 | 681 | 3155 | 66 | 63 | 62 | 336646
2011-06-01 00:00:00 | 4646 | 369 | 3085 | 50 | 50 | 56 | 192678
2010-07-01 00:00:00 | 5311 | 331 | 3948 | 51 | 72 | 72 | 121988
2010-08-01 00:00:00 | 5297 | 373 | 3890 | 64 | 45 | 64 | 145693
2010-09-01 00:00:00 | 6002 | 562 | 3974 | 86 | 89 | 79 | 215065
Spreadsheet: 870556d1717057971-custom-sort-custom
Sheet: Required

 |  |  |  | OR
 | Guava | 97 |  | Guava | 97
 | Guava | 635 |  | Guava | 635
 | Guava Total |  |  | Mango | 86
 | Mango | 86 |  | Mango | 125
 | Mango | 125 |  | [NAME] | 36
 | Mango Total |  |  | [NAME] | 98
 | [NAME] | 36 |  | Apple | 526
 | [NAME] | 98 |  | Apple | 77
 | Banana Total |  |  | Orange | 36
 | Apple | 526
 | Apple | 77
 | Apple Total
 | Orange | 36
 | Orange Total
Spreadsheet: 116226d1311691449-index-match-duplicates-poker-league-standings
Sheet: Calculations

 | Rich | Geno | [NAME] | [NAME] | [NAME] | [NAME] | Kenny | Brett | Kris
Totals | 140 | 95 | 90 | 150 | 150 | 35 | 95 | 60 | 40
Week 1 | 100 | 15 | 40 | 80 | 50 | 20 | 70 | 30 | 25
Week 2 | 40 | 80 | 50 | 70 | 100 | 15 | 25 | 30 | 15
Week 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Totals: | 140 | 95 | 90 | 150 | 150 | 35 | 95 | 60 | 40