tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 526132d1499155872-top-10-table-with-criteria-example
Sheet: Feuil1

 |  |  |  |  |  |  | Top 10 Table
Main Data Table |  |  |  |  |  |  |  |  | Project: | Cat
I.D | Project | Score | Cost | Action | Date
1 | Cat | 25 | 15061 | Fix |  |  | Position | I.D | Score | Cost
2 | Dog | 15 | 2156 | Fix |  |  | 1
3 | Whale | 5 | 561596 | Fix |  |  | 2 |  |  |  | The leaderboard is ordered by score relating to whatever project is chosen from the cell above and the other headings taken from the table relating to that score.
4 | Beetle | 10 | 56 | Fix |  |  | 3
5 | Cat | 10 | 16 | Fix |  |  | 4
6 | Beetle | 10 | 560 | Fix |  |  | 5
7 | Bird | 15 | 156 | Fix |  |  | 6
8 | Whale | 25 | 156 | Fix |  |  | 7
9 | Dog | 25 | 10 | Fix |  |  | 8
10 | Dog | 25 | 560156 | Fix |  |  | 9
11 | Bird | 5 | 1569 | Fix |  |  | 10
12 | Fish | 5 | 1560 | Fix
13 | Fish | 10 | 1591 | Fix
14 | Cat | 15 | 5 | Fix
15 | Beetle | 5 | 105 | Fix
16 | Beetle | 10 | 156 | Fix
17 | Beetle | 10 | 5961 | Fix
18 | Cat | 5 | 51 | Fix
19 | Cat | 25 | 561 | Fix
20 | Whale | 5 | 526 | Fix
21 | Bird | 5 | 105189 | Fix
22 | Cat | 5 | 515 | Fix
23 | Cat | 5 | 159 | Fix
24 | Cat | 5 | 1891 | Fix
25 | Whale | 10 | 891 | Fix
26 | Fish | 15 | 561 | Fix
27 | Dog | 5 | 56 | Fix
28 | Fish | 5 | 123 | Fix
29 | Cat | 15 | 159 | Fix
30 | Bird | 5 | 156 | Fix
31 | Bird | 5 | 1561 | Fix
32 | Fish | 15 | 5156 | Fix
33 | Fish | 5 | 4789 | Fix
34 | Beetle | 10 | 51 | Fix
35 | Whale | 15 | 56 | Fix
36 | Dog | 5 | 648 | Fix
Spreadsheet: 769532d1645579581-determine-smallest-reel-possible-for-x-meters-of-cable-smallest-reel-possible-for-meters-rev2
Sheet: Reel sizes

Reel size sequence from smaller to bigger | [NAME] of reel in inches
1 | 20x13
2 | 20x14.5
3 | 24x11
4 | 24x13
5 | 24x14.5
6 | 24x21
7 | 252x129
8 | 27x20.5
9 | 27x21
10 | 30x21
11 | 30x23
12 | 32x27
13 | 336x172
14 | 36x20.5
15 | 36x26
16 | 36x27.5
17 | 40x24
18 | 40x27
19 | 42x30
20 | 44x27
21 | 45x32
22 | 48x30
23 | 48x32.5
24 | 50x38
25 | 54x38
26 | 56x38
27 | 58x38
28 | 60x38
29 | 64x54
30 | 66x38
31 | 66x42
32 | 66x48
33 | 68x38
34 | 68x44
35 | 72x39
36 | 72x42
37 | 72x48
38 | 72x54
39 | 72x55
40 | 78x39
41 | 78x54
42 | 80x54
43 | 84x43
44 | 84x51
45 | 84x60
46 | 84x60.5
47 | 87x62
48 | 88x54
49 | 90x46
50 | 90x60
51 | 90x61
52 | 90x64
53 | 92x68
54 | 96x47
55 | 96x61
56 | 100x65
57 | 100x76
58 | 112x76
59 | 120x76
60 | 128x76
61 | 144x78
62 | 168x86
Spreadsheet: 145463d1331595658-pasting-mixed-character-types-book2
Sheet: Sheet1

DATE | SALES | EBIT | [NAME] | TOTAL NET | EPS | TAX RATE
 |  |  |  | INCOME |  | (%)
2012-11-11 00:00:00 | 8.55 Bil | [NAME] | 97.39 [NAME] | 2.23 Bil | 4.06 | 36.6 |  | #N/A
2012-10-11 00:00:00 | 8.24 Bil | 1.27 Bil | 95.87 [NAME] | [NAME] | 1.22 | 39.7
2012-09-11 00:00:00 | 7.99 Bil | 2.12 Bil | 105.30 [NAME] | 1.28 Bil | 2.38 | 39.8
2012-08-11 00:00:00 | [NAME] | 1.66 Bil | 108.00 [NAME] | 1.06 Bil | 2.18 | 35.9
2012-07-11 00:00:00 | [NAME] | [NAME] | 115.40 Mil | 964.20 Mil | 2.01 | 36.8
2012-06-11 00:00:00 | 5.58 Bil | 1.67 Bil | [NAME] | 1.13 Bil | 2.37 | 32.1
2012-05-11 00:00:00 | 5.11 Bil | 924.26 [NAME] | 214.31 [NAME] | 577.92 [NAME] | 1.21 | 37.5
2012-04-11 00:00:00 | 5.11 Bil | 1.22 Bil | 193.13 [NAME] | [NAME] | 1.47 | 36.3
2012-03-11 00:00:00 | 5.36 Bil | 1.03 Bil | 0 | 648.63 [NAME] | 1.23 | 36.8
2012-02-11 00:00:00 | 5.84 Bil | 1.15 Bil | 0 | [NAME] | 1.41 | 35.2
Spreadsheet: 746067d1630483724-conditional-formatting-for-highlighting-month-if-dates-are-not-matched-sample1234556-etaf-
Sheet: Sheet1

 |  |  | Case 1 |  |  |  |  |  |  |  | Case 2
 |  |  | Month |  | Start Date | End Date |  |  |  | Start Date | End Date | Net workdays
 |  |  | 2021-08-01 00:00:00 |  | 2021-08-01 00:00:00 | 2021-08-06 00:00:00 |  |  |  | 2021-08-01 00:00:00 | 2021-08-06 00:00:00 | 5
 |  |  | 2021-08-02 00:00:00 |  | 2021-08-05 00:00:00 | 2021-08-17 00:00:00 |  |  |  | 2021-08-05 00:00:00 | 2021-08-17 00:00:00 | 9
 |  |  | 2021-08-03 00:00:00 |  | 2021-08-01 00:00:00 | 2021-08-31 00:00:00 |  |  |  | 2021-08-01 00:00:00 | 2021-08-31 00:00:00 | 20
 |  |  | 2021-08-04 00:00:00 |  | 2021-05-01 00:00:00 | 2021-05-31 00:00:00 | Month, start date and end date not falling in the same month |  |  | 2021-05-01 00:00:00 | 2021-05-31 00:00:00 | 13
 |  |  | 2021-08-05 00:00:00 |  | 2021-09-01 00:00:00 | 2021-09-17 00:00:00 | Month, start date and end date not falling in the same month |  |  | 2021-09-01 00:00:00 | 2021-09-17 00:00:00 | 13
 |  |  | 2021-08-06 00:00:00 |  | 2021-08-08 00:00:00 | 2021-08-29 00:00:00 |  |  |  | 2021-08-08 00:00:00 | 2021-08-29 00:00:00 | 15
 |  |  |  |  |  |  |  |  |  | Here if the network days are not matching with [NAME] date and end date, then that particular cell to be highlighted
 |  |  | Start date, end date and month should fall within the same month . If any of the column D,F and G not matching within the month then month column should be highligted. Here [NAME], F7 adn G7 not fallling on same month hence i need to get column D7 to be highlighted nd similar to D8, F8 adn G8.
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 9d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 147653 | 64007 | 327808 | 38061
OTHER* | 48063 | 166115 | 29721 | 46734
TOTAL | 195716 | 230122 | 357529 | 84795
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, FRA, Fixed-Fixed, Inflation, OIS, and Swaption.
Spreadsheet: 869228d1715854624-i-need-help-with-vacation-time-example-bvj-2
Sheet: New Test

Start | End | Period | First time Vacation |  | Second time Vacation
2024-01-01 00:00:00 |  | 12
2024-02-05 00:00:00 |  | 8
2024-06-03 00:00:00 |  | 18
Start | End | Period | First time Vacation 7th month |  | Second time Vacation 1m before the last
2024-01-01 00:00:00 | 2024-12-31 00:00:00 | 12 | 2024-07-01 00:00:00 | 2024-07-30 00:00:00 | 2024-11-01 00:00:00 | 2024-11-30 00:00:00 | the 7th month is between 01-07-2024 until 30-07-2024 | The month before the last is november
2024-01-01 00:00:00 | 2024-09-30 00:00:00 | 9 | 2024-07-01 00:00:00 | 2024-07-30 00:00:00 | 2024-08-01 00:00:00 | 2024-08-31 00:00:00 | the 7th month is between 01-07-2024 until 30-07-2024 | The month before the last is august
2024-01-01 00:00:00 | 2024-07-30 00:00:00 | 7 | 2024-07-01 00:00:00 | 2024-07-30 00:00:00 | No vacation |  | the 7th month is between 01-07-2024 until 30-07-2024 | The month before the last is july and it's the same 7th month (No second time vacation)
Spreadsheet: 739375d1625666228-schedule-generator-sheperd-team-schedule
Sheet: Sheet2

Positions | Names | Positions Can Work |  |  |  | Shifts Not Available
 |  | Cameras | Inside | Outside | Cart | July 4th a.m. | July 4th p.m. | July 8th | July 11th a.m. | July 11th p.m. | July 15th | July 18th a.m. | July 18th p.m. | July 22nd | July 25th a.m. | July 25th p.m. | July 29th | August 1st a.m. | August 1st p.m. | August 5th
Cameras | [NAME] | x | x | x | x
Inside | [NAME] | x | x | x | x |  |  |  |  |  |  | x
Outside | [NAME] | x | x | x | x |  |  |  | x
Cart | [NAME] | x |  |  | x
 | [NAME] | x | x | x | x
 | [NAME] | x
 | Chad |  | x | x | x
 | [NAME] | x | x | x | x
 | [NAME] | x | x | x | x
 | [NAME] | x | x | x | x
 | [NAME] | x | x | x | x
 | [NAME] | x | x | x | x
 | [NAME] | x |  |  | x
 | [NAME] | x |  | x
 | [NAME] | x |  | x | x
 | [NAME] |  |  | x | x
 | Rich |  |  | x | x
 | Mick | x
 |  |  |  |  |  | Sunday a.m. | Sunday p.m. | Thursday | Sunday a.m. | Sunday p.m. | Thursday | Sunday a.m. | Sunday p.m. | Thursday | Sunday a.m. | Sunday p.m. | Thursday | Sunday a.m. | Sunday p.m. | Thursday
Spreadsheet: 66768d1267461849-subtotal-sumif-on-autofilter-visible-cells-only-mikal_autofilter
Sheet: Sheet1

UPN | SURNAME | GEN | YES/NO
Q31735 | SMITH | M | Y
W31784 | JONES | M | Y
T31777 | BRIDGE | F | N
P31715 | BRIDGE | F | Y
Q31778 | COLLINS | M | N
N31795 | EVENS | F | N
N31733 | [NAME] | F | Y
Z31722 | BLOGGS | M | N
Spreadsheet: 142936d1330095614-auto-filter-using-macro-auto-filter-name-doc
Sheet: Leavers

First Name | Last Name | Job Title | Company | Parent Co. | Office Location | Manager's Name | Temp/Perm | Leave Date | Comments
[NAME] | Sleight |  |  |  | Scratchwood |  |  | 2011-11-11 00:00:00
[NAME] | Rainbow | Revenue | CPS |  | [NAME] | [NAME] | Permanant | 2011-11-11 00:00:00
Spreadsheet: 43080d1241685200-creating-a-drop-down-list-from-another-table-of-data-book1
Sheet: Sheet2

Suppliers | Manager | Key |  | Q1
Supplier 1 | [NAME] | 0 |  | [NAME] | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sept | Oct | Nov | Dec
Supplier 2 | [NAME] | 0 |  | Supplier 23
Supplier 3 | [NAME] | 0 |  | Supplier 24
Supplier 4 | [NAME] | 0 |  | Supplier 25
Supplier 5 | [NAME] | 0 |  | Supplier 26
Supplier 6 | [NAME] | 0 |  | Supplier 27
Supplier 7 | [NAME] | 0 |  | Supplier 28
Supplier 8 | [NAME] | 0 |  | Supplier 29
Supplier 9 | [NAME] | 0 |  | Supplier 30
Supplier 10 | [NAME] | 0 |  | Supplier 31
Supplier 11 | [NAME] | 0 |  | Supplier 32
Supplier 12 | [NAME] | 0 |  | Supplier 33
Supplier 13 | [NAME] | 0 |  | Supplier 34
Supplier 14 | [NAME] | 0 |  | Supplier 35
Supplier 15 | [NAME] | 0 |  | Supplier 36
Supplier 16 | [NAME] | 0 |  | Supplier 37
Supplier 17 | [NAME] | 0
Supplier 18 | [NAME] | 0 |  | Q1
Supplier 19 | [NAME] | 0 |  | [NAME] | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sept | Oct | Nov | Dec
Supplier 20 | [NAME] | 0
Supplier 21 | Emma | 0
Supplier 22 | Emma | 0
Supplier 23 | [NAME] | 1
Supplier 24 | [NAME] | 2
Supplier 25 | [NAME] | 3
Supplier 26 | [NAME] | 4
Supplier 27 | [NAME] | 5
Supplier 28 | [NAME] | 6
Supplier 29 | [NAME] | 7
Supplier 30 | [NAME] | 8
Supplier 31 | [NAME] | 9
Supplier 32 | [NAME] | 10
Supplier 33 | [NAME] | 11
Supplier 34 | [NAME] | 12
Supplier 35 | [NAME] | 13
Supplier 36 | [NAME] | 14
Supplier 37 | [NAME] | 15
Supplier 38 | [NAME] | 15
Supplier 39 | [NAME] | 15
Supplier 40 | Rachel | 15
Supplier 41 | Rachel | 15
Supplier 42 | [NAME] | 15
Supplier 43 | [NAME] | 15
Supplier 44 | [NAME] | 15
Supplier 45 | [NAME] | 15
Supplier 46 | [NAME] | 15
Supplier 47 | [NAME] | 15
Supplier 48 | [NAME] | 15
Supplier 49 | [NAME] | 15
Supplier 50 | [NAME] | 15
Supplier 51 | [NAME] | 15
Supplier 52 | [NAME] | 15
Supplier 53 | [NAME] | 15
Supplier 54 | [NAME] | 15
Supplier 55 | [NAME] | 15
Supplier 56 | [NAME] | 15
Supplier 57 | [NAME] | 15
Supplier 58 | [NAME] | 15
Supplier 59 | [NAME] | 15
Supplier 60 | [NAME] | 15
Supplier 61 | [NAME] | 15
Supplier 62 | [NAME] | 15
Supplier 63 | [NAME] | 15
Supplier 64 | [NAME] | 15
Supplier 65 | [NAME] | 15
Supplier 66 | [NAME] | 15
Supplier 67 | [NAME] | 15
Supplier 68 | [NAME] | 15
Supplier 69 | [NAME] | 15
Supplier 70 | [NAME] | 15
Supplier 71 | Template | 15
Supplier 72 | Unknown | 15
Supplier 73 | Unknown | 15
Supplier 74 | Unknown | 15
Supplier 75 | Unknown | 15
Spreadsheet: 702075d1604071564-need-a-if-formula-for-a-customer-list-that-has-different-price-lists-example
Sheet: Price List

Column1 | Column1 | Column1 | Column1 | Column1
 | Price List 1/2020
Material | Material Description | $ [NAME] | U of M
1726 | CALF COAT - LARGE | 36.72 | EA
5320A | Life Jacket Non-Breakaway Large Teal | 36.72 | EA
Z0004-8000-015 | Diaphram | 8.313 | EA
Z0007-3196-700 | ORING300 CLASSIC BOWL | 3.57 | EA
Z0019-6471-300 | [NAME],Hex Head 6X115MM | 5.1 | EA
Z02100001611 | Air Filter Element | 52.7136 | EA
Spreadsheet: 860279d1708437104-spill-formula-on-aggregation-by-currency-and-account-type-book1
Sheet: Sheet2

 |  |  | Values
 | Account Type: Long Name | Currency | A | B | C | D | E | F | G | H | Sum of Total |  |  | Currency | A | B | C | D | E | F | G | H | Total
 | Income | AUD | -213.01 | 0 | 0 | 0 | 0 | 0 | 29460.02 | 0
 | Income | EUR | -28.57 | 0 | 0 | 0 | 0 | 0 | 3257298.73 | 0 |  |  |  | CAD
 | Income | GBP | 2709.4 | 0 | 0 | 0 | 59617.25 | 0 | 2822142.98 | 0 |  |  |  | EUR
 | Income | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | -5850.939999999999 | 0 |  |  |  | GBP
 | Income | USD |  |  |  |  |  |  |  |  |  |  |  | ILS
 | Income Total |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Cost of Goods Sold | AUD | 0 | 0 | 0 | 0 | 0 | 0 | -18298.83 | 0 |  |  |  | USD
 | Cost of Goods Sold | EUR | 0 | 0 | 0 | 0 | 0 | 0 | -1459685.33 | 0 |  |  |  | Grand Total
 | Cost of Goods Sold | GBP | 0 | 0 | 0 | 0 | 0 | 0 | -1748632.38 | 0
 | Cost of Goods Sold | ILS | 0 | 0 | 0 | 0 | 0 | 0 | -73455.33 | 0 |  |  |  |  | A | B | C | D | E | F | G | H | Sum of Total
 | Cost of Goods Sold | USD | -5677 |  |  |  | -11899 |  | -579000 |  |  |  |  | USD | -8887.18 | 0 | -169656.29 | 0 | -293167.24 | 0 | 5093951.79 | 0 | 4622241.079999999
 | Cost of Goods Sold Total |  |  |  |  |  |  |  |  |  |  |  |  | EUR | -28.57 | 0 | 0 | 0 | -12878.01 | 0 | 1597659.91 | 0 | 1584753.330000001
 | Expense | AUD | 0 | 0 | 0 | 0 | 0 | 0 | -120.5 | 0 |  |  |  | GBP | 2709.4 | 0 | 0 | 0 | 54342.04 | 0 | 1044159.879999999 | 0 | 1101211.319999999
 | Expense | CAD | 0 | 0 | 0 | 0 | 0 | 0 | -77.33 | 0 |  |  |  | AUD | -213.01 | 0 | 0 | 0 | 0 | 0 | 11040.69 | 0 | 10827.68
 | Expense | EUR | 0 | 0 | 0 | 0 | -12878.01 | 0 | -199953.49 | 0 |  |  |  | CAD | 0 | 0 | 0 | 0 | 0 | 0 | -77.33 | 0 | -77.33
 | Expense | GBP | 0 | 0 | 0 | 0 | -5275.21 | 0 | -29350.72 | 0 |  |  |  | [NAME] | 0 | 0 | -993.32 | 0 | 0 | 0 | -5850.939999999999 | 0 | -6844.259999999998
 | Expense | ILS | 0 | 0 | -168662.97 | 0 | -310833.27 | 0 | -3458991 | 0 |  |  |  | ILS | 0 | 0 | -168662.97 | 0 | -310833.27 | 0 | -3532446.33 | 0 | -4011942.57
 | Expense | [NAME] | 0 | 0 | -993.32 | 0 | 0 | 0 | 0 | 0 |  |  |  | Total | -6419.360000000001 | 0 | -339312.58 | 0 | -562536.48 | 0 | 4208437.669999999 | 0 | 3300169.249999997
 | Expense | USD | -5678 |  |  |  |  |  | -430099
 | Expense Total
 | Grand Total
Spreadsheet: 847382d1698334019-calculating-clients-owed-amounts-month-by-month-excelamounts
Sheet: Sheet1

 | [NAME] | amount | date
 | [NAME] | 5 | 2022-11-30 00:00:00 |  |  | for example, [NAME] had a total of |  |  |  | amount in November
 | [NAME] | 10 | 2022-11-30 00:00:00 |  |  | in December [NAME] had a total of
 | [NAME] | 0 | 2022-11-30 00:00:00 |  |  | So it decreased by 10, I need to sum up all of these clients
 | Jake | 20 | 2022-11-30 00:00:00 |  |  | another example: [NAME] had 11 in November
 | [NAME] | 4.339992000000001 | 2022-11-30 00:00:00 |  |  | In December this client is gone, so this number (11) goes to the "Decreased" pile together with Bobs 10 (total 10+11=21)
 | [NAME] | 3 | 2022-11-30 00:00:00
 | [NAME] | 0 | 2022-11-30 00:00:00 |  |  | same goes for Increased amounts
 | [NAME] | 11 | 2022-11-30 00:00:00 |  |  | [NAME] had no amount in November, but in December he has a total of 25, so an increase of 25.
 | [NAME] | 1 | 2022-11-30 00:00:00 |  |  | [NAME] had 4 in November, he has 30 in December, so an increas of 26 (total 25+26=51)
 | [NAME] | 0 | 2022-12-31 00:00:00
 | [NAME] | 6 | 2022-12-31 00:00:00
 | [NAME] | 0 | 2022-12-31 00:00:00
 | Jake | 15 | 2022-12-31 00:00:00 |  |  | End result should look like this
 | [NAME] | 30 | 2022-12-31 00:00:00 |  |  |  | New client amounts + increased amounts (december)
 | [NAME] | 0 | 2022-12-31 00:00:00 |  |  |  | Client amounts that are gone + decreased amounts (december)
 | [NAME] | 23 | 2022-12-31 00:00:00
 | [NAME] | 5 | 2022-12-31 00:00:00
 | [NAME] | 20 | 2022-12-31 00:00:00
Spreadsheet: a885a531-0970-4ed1-9c78-640356cbbecb
Sheet: Sheet1

Syracuse Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2013-04-27 | 1 | Portland | 3 | Syracuse | 4 | Final OT | Onondaga County War Memorial Arena Syracuse, NY
2013-04-28 | 2 | Portland | 2 | Syracuse | 4 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-05-02 | 3 | Syracuse | 4 | Portland | 3 | Final OT | Cumberland County Civic Center Portland, ME
2013-05-10 | 1 | Syracuse | 5 | Springfield | 2 | Final | [NAME], MA
2013-05-11 | 2 | Syracuse | 5 | Springfield | 3 | Final | [NAME], MA
2013-05-15 | 3 | Springfield | 0 | Syracuse | 3 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-05-17 | 4 | Springfield | 2 | Syracuse | 5 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-05-25 | 1 | W-B/Scranton | 4 | Syracuse | 2 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-05-26 | 2 | W-B/Scranton | 2 | Syracuse | 3 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-05-29 | 3 | Syracuse | 2 | W-B/Scranton | 0 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2013-05-31 | 4 | Syracuse | 4 | W-B/Scranton | 2 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2013-06-01 | 5 | W-B/Scranton | 0 | Syracuse | 7 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-06-08 | 1 | Grand Rapids | 3 | Syracuse | 1 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-06-09 | 2 | Grand Rapids | 6 | Syracuse | 4 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-06-12 | 3 | Syracuse | 2 | Grand Rapids | 4 | Final | [NAME] Arena Grand Rapids, MI
2013-06-14 | 4 | Syracuse | 3 | Grand Rapids | 2 | Final | [NAME] Arena Grand Rapids, MI
2013-06-15 | 5 | Syracuse | 5 | Grand Rapids | 2 | Final | [NAME] Arena Grand Rapids, MI
2013-06-18 | 6 | Grand Rapids | 5 | Syracuse | 2 | Final | Onondaga County War Memorial Arena Syracuse, NY
Spreadsheet: 705194d1605912044-replicating-series-of-dates-for-different-people-copy-sequence
Sheet: Required Format

0000001 | 01/01/2020
0000001 | 02/01/2020
0000001 | 01/02/2020
0000001 | 02/02/2020
0000001 | 01/03/2020
0000001 | 02/03/2020
0000001 | 01/04/2020
0000001 | 02/04/2020
0000001 | 01/05/2020
0000001 | 02/05/2020
0000002 | 01/01/2020
0000002 | 02/01/2020
0000002 | 01/02/2020
0000002 | 02/02/2020
0000002 | 01/03/2020
0000002 | 02/03/2020
0000002 | 01/04/2020
0000002 | 02/04/2020
0000002 | 01/05/2020
0000002 | 02/05/2020
0000003 | 01/01/2020
0000003 | 02/01/2020
0000003 | 01/02/2020
0000003 | 02/02/2020
0000003 | 01/03/2020
0000003 | 02/03/2020
0000003 | 01/04/2020
0000003 | 02/04/2020
0000003 | 01/05/2020
0000003 | 02/05/2020
0000004 | 01/01/2020
0000004 | 02/01/2020
0000004 | 01/02/2020
0000004 | 02/02/2020
0000004 | 01/03/2020
0000004 | 02/03/2020
0000004 | 01/04/2020
0000004 | 02/04/2020
0000004 | 01/05/2020
0000004 | 02/05/2020
0000005 | 01/01/2020
0000005 | 02/01/2020
0000005 | 01/02/2020
0000005 | 02/02/2020
0000005 | 01/03/2020
0000005 | 02/03/2020
0000005 | 01/04/2020
0000005 | 02/04/2020
0000005 | 01/05/2020
0000005 | 02/05/2020
Spreadsheet: 769984d1645764623-sums-of-dynamic-unique-values-with-multiple-criteria-sample-tests
Sheet: Calculation

 | Selected Information (Form Controls) |  |  |  |  |  |  |  |  |  |  | Calculation for scrolling table
 |  | Selected Type | 1
 |  | Selected Year | 1
 |  | Selected Bug | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | Year
 | For Drop_down selections |  |  |  |  | Types data |  |  |  |  |  |  |  |  |  |  | difference from  previous year
 | Year | Type | Values |  |  |  | gram_positive |  |  |  |  | Nr. | Type | isolates_tested | isolates_susceptible | %susceptibility | Δ% susceptibility
 | 2018 | gram_negative | isolates_tested |  |  | Amikacin-Citrobacter freundii | Ampicillin-Enterococcus spp.
 | 2019 | gram_positive | isolates_susceptible |  |  | Amikacin-Klebsiella pneumoniae | Group A Strep-Penicillin
 | 2020 |  | %susceptibility |  |  | Amikacin-Proteus mirabilis | Group B Strep-Penicillin
 |  |  |  |  |  | [NAME] cloacae complex | Linezolid-MRSA
 |  |  |  |  |  | [NAME] morganii | Penicillin-Staphylococcus aureus
 |  |  |  |  |  | [NAME] coli | Linezolid-MSSA
 |  |  |  |  |  | Ertapenem-Acinetobacter baumannii | Penicillin-MRSA
 |  |  |  |  |  | Ertapenem-E. coli | Penicillin-MSSA
 |  |  |  |  |  | Tobramycin-Klebsiella aerogenes
 |  |  |  |  |  | Imipenem-Citrobacter freundii
 |  |  |  |  |  | Meripenem-Citrobacter freundii
 |  |  |  |  |  | Amikacin-E. coli
 |  |  |  |  |  |  |  |  |  |  |  |  | Calculations for headers
 |  |  |  |  |  |  |  |  |  |  |  |  | Hospital Numbers
 |  |  |  |  |  |  |  |  |  |  |  |  | isolate_hospital_n | `=sum of unique values  for each "type",  "year" and "bug" | *** one result from the data is that the isolates_hospital_n  sum for Citrobacter Freundii bug is 13 and not 39. and for MSSA is 66 and not 132.
Spreadsheet: 92426d1291990958-value-otr-n-a-return-salessum
Sheet: 1522

Qty (Kg) |  | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
000115410 - EAGLE C6 FUEL DRY YEAST |  | 6990 | 0 | 0 | 4500 | 0 | 19500 | 18490 | 16110 | 17110 | 25800 | 0
Spreadsheet: 191054d1351886244-dynamically-extending-or-de-extending-a-data-table-based-on-another-table-table-assist
Sheet: Table 2

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18
Spreadsheet: 723556d1615780418-find-max-and-min-records-in-an-array-test-temperature
Sheet: Sheet1

Date | Probe | Time | Temp
2021-03-01 00:00:00 | 1 | 12:00:00 | -18.1
2021-03-01 00:00:00 | 2 | 12:00:00 | -18
2021-03-01 00:00:00 | 3 | 12:00:00 | -18.1
2021-03-01 00:00:00 | 4 | 12:00:00 | -18.1
2021-03-01 00:00:00 | 1 | 12:15:00 | -18
2021-03-01 00:00:00 | 2 | 12:15:00 | -18
2021-03-01 00:00:00 | 3 | 12:15:00 | -18.1
2021-03-01 00:00:00 | 4 | 12:15:00 | -18.1
2021-03-01 00:00:00 | 1 | 12:30:00 | -17.9
2021-03-01 00:00:00 | 2 | 12:30:00 | -18
2021-03-01 00:00:00 | 3 | 12:30:00 | -18.1
2021-03-01 00:00:00 | 4 | 12:30:00 | -18
2021-03-01 00:00:00 | 1 | 12:45:00 | -18.1
2021-03-01 00:00:00 | 2 | 12:45:00 | -17.9
2021-03-01 00:00:00 | 3 | 12:45:00 | -17.9
2021-03-01 00:00:00 | 4 | 12:45:00 | -18
2021-03-01 00:00:00 | 1 | 01:00:00 | -17.9
2021-03-01 00:00:00 | 2 | 01:00:00 | -18
2021-03-01 00:00:00 | 3 | 01:00:00 | -18.1
2021-03-01 00:00:00 | 4 | 01:00:00 | -18
2021-03-02 00:00:00 | 1 | 12:00:00 | -18.1
2021-03-02 00:00:00 | 2 | 12:00:00 | -18
2021-03-02 00:00:00 | 3 | 12:00:00 | -18.1
2021-03-02 00:00:00 | 4 | 12:00:00 | -18.1
2021-03-02 00:00:00 | 1 | 12:15:00 | -18
2021-03-02 00:00:00 | 2 | 12:15:00 | -18
2021-03-02 00:00:00 | 3 | 12:15:00 | -18.1
2021-03-02 00:00:00 | 4 | 12:15:00 | -18.1
2021-03-02 00:00:00 | 1 | 12:30:00 | -17.9
2021-03-02 00:00:00 | 2 | 12:30:00 | -18
2021-03-02 00:00:00 | 3 | 12:30:00 | -18.1
2021-03-02 00:00:00 | 4 | 12:30:00 | -18
2021-03-02 00:00:00 | 1 | 12:45:00 | -18.1
2021-03-02 00:00:00 | 2 | 12:45:00 | -17.9
2021-03-02 00:00:00 | 3 | 12:45:00 | -17.9
2021-03-02 00:00:00 | 4 | 12:45:00 | -18
2021-03-02 00:00:00 | 1 | 01:00:00 | -17.9
2021-03-02 00:00:00 | 2 | 01:00:00 | -18
2021-03-02 00:00:00 | 3 | 01:00:00 | -18.1
2021-03-02 00:00:00 | 4 | 01:00:00 | -18
2021-03-03 00:00:00 | 1 | 12:00:00 | -18.1
2021-03-03 00:00:00 | 2 | 12:00:00 | -18
2021-03-03 00:00:00 | 3 | 12:00:00 | -18.1
2021-03-03 00:00:00 | 4 | 12:00:00 | -18.1
2021-03-03 00:00:00 | 1 | 12:15:00 | -18
2021-03-03 00:00:00 | 2 | 12:15:00 | -18
2021-03-03 00:00:00 | 3 | 12:15:00 | -18.1
2021-03-03 00:00:00 | 4 | 12:15:00 | -18.1
2021-03-03 00:00:00 | 1 | 12:30:00 | -17.9
2021-03-03 00:00:00 | 2 | 12:30:00 | -18
2021-03-03 00:00:00 | 3 | 12:30:00 | -18.1
2021-03-03 00:00:00 | 4 | 12:30:00 | -18
2021-03-03 00:00:00 | 1 | 12:45:00 | -18.1
2021-03-03 00:00:00 | 2 | 12:45:00 | -17.9
2021-03-03 00:00:00 | 3 | 12:45:00 | -17.9
2021-03-03 00:00:00 | 4 | 12:45:00 | -18
2021-03-03 00:00:00 | 1 | 01:00:00 | -17.9
2021-03-03 00:00:00 | 2 | 01:00:00 | -18
2021-03-03 00:00:00 | 3 | 01:00:00 | -18.1
2021-03-03 00:00:00 | 4 | 01:00:00 | -17.9
Spreadsheet: 295040d1391576815-automatically-fitering-values-through-based-on-a-criteria-database-and-constituent-tabs
Sheet: NSW

 |  |  | Category | List A | List B | List C
 |  |  | A | 0.8451013965258007 | 0.4232240621275081 | 0.02194651506100243
 |  |  | B | 0.1173042878678868 | 0.6465767962754666 | 0.5645157664299879
 |  |  | C | 0.4963556320036083 | 0.5007580101696384 | 0.3530085434334198
 |  |  | D | 0.5288290663519298 | 0.4495786342779263 | 0.8550160712642259
 |  |  | E | 0.5298993254044969 | 0.5498010938624269 | 0.6092992868129393
 |  |  | F | 0.5784435286374845 | 0.6294835667158095 | 0.5514572090898321
 |  |  | G | 0.5435321913698196 | 0.5019708120547799 | 0.3936818627735323
 |  |  | H | 0.03695074451148106 | 0.8983198386127563 | 0.1670678800299645
 |  |  | I | 0.08673871967482638 | 0.2595955610229939 | 0.4300324232709879