tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0abb1a65-0af0-48df-a047-b31ff552a815
Sheet: Sheet1

Unnamed: 0 | Sportler | [NAME]
1 | Bader, [NAME] [37205] | BC Haunstetten [340]
2 | Baumgärtner, [NAME] [24721] | BC Haunstetten [340]
3 | Bruder, Thorsten [35967] | PBC Ulm/Neu-Ulm [348]
4 | Diso, [NAME] [23158] | PBC Ulm/Neu-Ulm [348]
5 | Ernst, [NAME] [26531] | BC Haunstetten [340]
6 | Fant, Silvio [39055] | BC Hombre [477]
7 | Fritsch, [NAME] [32806] | BSC Augsburg [400]
8 | Fritzsche, [NAME] [39056] | BC Hombre [477]
9 | Gehring, Philipp [39057] | BC Hombre [477]
10 | [NAME], [NAME] [35277] | BSC Augsburg [400]
11 | [NAME], [NAME] [35766] | BC Haunstetten [340]
12 | Gök, Yilmaz [32379] | BSC Augsburg [400]
13 | Harms, Carsten [39470] | BC Haunstetten [340]
14 | Kohnle, [NAME] [14375] | BSC Augsburg [400]
15 | [NAME], Christian [39362] | PBC Augsburg [341]
16 | Krehl, Matthias [39376] | PBC Ulm/Neu-Ulm [348]
17 | Lenk, Daniel [35864] | PBSC Donauwörth [373]
18 | Lücking, Reinhold [32558] | PBC Ulm/Neu-Ulm [348]
19 | Messerschmidt, [NAME] [36352] | PBC Ulm/Neu-Ulm [348]
20 | Mittmann, [NAME] [16332] | PBSC Donauwörth [373]
21 | Moeller, Fabian [35540] | BC Haunstetten [340]
22 | [NAME], [NAME] [20265] | PBC Ulm/Neu-Ulm [348]
23 | Nguyen, Hao [19975] | BC Haunstetten [340]
24 | Proksch, [NAME] [35541] | BC Haunstetten [340]
25 | Roll, Manuel [39060] | BC Hombre [477]
26 | Sachers, [NAME] [39591] | PBSC Donauwörth [373]
27 | Schnürer, Andrè [39061] | BC Hombre [477]
28 | Schosser, [NAME] [14996] | BC Haunstetten [340]
29 | Schröder, [NAME] [39366] | PBC Augsburg [341]
30 | [NAME], Matthias [35127] | BC Haunstetten [340]
31 | [NAME], [NAME] [28373] | PBC Ulm/Neu-Ulm [348]
32 | Spreter, [NAME] [31587] | BSC Augsburg [400]
33 | Stadler, Nils [39368] | PBC Augsburg [341]
34 | [NAME], Roland [28578] | BC Haunstetten [340]
35 | Thorp, Arno [38371] | BC Haunstetten [340]
36 | [NAME], Florian [31589] | BC Haunstetten [340]
37 | Wilk, Andreas [38372] | BC Haunstetten [340]
Spreadsheet: 126211d1319567683-counting-instances-of-a-string-in-non-contiguous-columns-example
Sheet: Sheet1

[NAME] | # of Interactions | # of Clicks | '72711 Opens'! | '72711 Clicks'! | '72711(2) [NAME]'! | '72711(2) Clicks'!
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
Spreadsheet: 455425d1460339301-how-can-this-spradsheet-be-improved-lunar-theme-park
Sheet: Visitors

Maximum Visitors
Day | No of visitors
1 | 224 |  |  |  | Ticket Prices |  |  |  |  | Rides |  |  | Ride Score
 | 232 |  |  |  |  |  |  |  |  | Major | Minor
 | 264 |  |  |  | Team1
 | 398 |  |  |  | Team2
 | 433 |  |  |  | Team3
 | 353 |  |  |  | Team4
 | 676 |  |  |  | Team5
 | 157
 | 524 |  |  |  | Total
 | 732
 | 523
 | 689
 | 396
 | 265
 | 198 |  |  |  | Week |  | Team1 | Team2 | Team3 | Team4 | Team5
 | 854
 | 375 |  |  |  | 1
 | 855 |  |  |  | 2
 | 964 |  |  |  | 3
 | 433 |  |  |  | 4
 | 275
 | 843
 | 1108
 | 423
 | 2867
 | 3853
 | 7443
 | 8465
Spreadsheet: benjamin_rogers__1218__test model from Erin
Sheet: ENA Assumptions

ENA Assumptions
Principal:
Interest Rate:
Term | 20
Amortization Method
Grace Period | 1
 |  |  |  |  |  | Original Debt | Debt
Project Years |  | Debt Amort | Peak Season Weight | Non-Peak Season Weight |  | Project Years | Amort
2000 |  | 0 | 0.7 |  |  | 2000 | 0 |  | 0.5
 |  | 0.01681111453104864 | 0.7 |  |  | 2001 | 0.034 |  | 1.5
 |  | 0.01879276388447527 | 0.7 |  |  | 2002 | 0.031 |  | 2.5
 |  | 0.02335974840623719 | 0.7 |  |  | 2003 | 0.0405 |  | 3.5
 |  | 0.02791069656180013 | 0.7 |  |  | 2004 | 0.0471 |  | 4.5
 |  | 0.02791069656180013 | 0.7 |  |  | 2005 | 0.009 |  | 5.5
 |  | 0.03817517164562447 | 0.7 |  |  | 2006 | 0.0445 |  | 6.5
 |  | 0.03817517164562458 | 0.7 |  |  | 2007 | 0.0885 |  | 7.5
 |  | 0.05006538696395124 | 0.7 |  |  | 2008 | 0.1005 |  | 8.5
 |  | 0.05006538696395124 | 0.7 |  |  | 2009 | 0.095 |  | 9.5
 |  | 0.06330858437846706 | 0.7 |  |  | 2010 | 0.095 |  | 10.5
 |  | 0.06330858437846718 | 0.7 |  |  | 2011 | 0.09 |  | 11.5
 |  | 0.065 | 0.7 |  |  | 2012 | 0.09 |  | 12.5
 |  | 0.065 | 0.7 |  |  | 2013 | 0.085 |  | 13.5
 |  | 0.07523612479161064 | 0.7 |  |  | 2014 | 0.08 |  | 14.5
 |  | 0.07523612479161076 | 0.7 |  |  | 2015 | 0.06990000000000018 |  | 15.5
 |  | 0.075 | 0.7 |  |  |  |  |  | 16.5
2017 |  | 0.075 | 0.7 |  |  |  |  |  | 17.5
2018 |  | 0.05 | 0.7 |  |  |  |  |  | 18.5
2019 |  | 0.05 | 0.7 |  |  |  |  |  | 19.5
2020 |  | 0.0516 | 0.7 |  |  |  |  |  | 20.5
Spreadsheet: 808311d1670408306-convert-the-birth-date-to-the-current-next-year-with-specific-conditions-book22656
Sheet: Sheet1

 |  | EMPLOYEE NAME | DATE ON THIS YEAR | Birthday
 |  | MAGED NAJI AHMED |  | 1985-01-01 00:00:00
 |  | SALMAN TARIQ |  | 1995-05-15 00:00:00
 |  | ZAHOOR AHAD |  | 1980-06-01 00:00:00
 |  | JEFFREY ALFARO |  | 1996-07-07 00:00:00
 |  | CHARLOT JENNIFER LEONCITO |  | 1986-12-24 00:00:00
 |  | [NAME]
 |  | SALEH SAYED MOHAMED |  | 1980-12-19 00:00:00
 |  | AAQIB MANZOOR LONE |  | 1982-06-06 00:00:00
 |  | SHAMIMU NALWANGA |  | 1999-10-12 00:00:00
 |  | NADEEM HAMID
 |  | [NAME]
 |  | SAHALAH NAMUGERWA
 |  | MAGDELDIN [NAME] |  | 1992-12-15 00:00:00
 |  | HERBERT ANANIAS NTUYO
 |  | ISSA SHOOK |  | 1984-09-03 00:00:00
 |  | GHUFRAN ULLAH |  | 1982-01-01 00:00:00
 |  | ISHIFAQ AHMED
 |  | OMAIR WANI |  | 1975-07-24 00:00:00
 |  | LAXMI PRASAD |  | 1970-10-26 00:00:00
 |  | SHIVA RAUT
 |  | [NAME]
 |  | ALFREDO I GEROY |  | 1996-05-15 00:00:00
 |  | DANILO JR. ALEMANIA |  | 1988-07-21 00:00:00
Spreadsheet: 841609d1693802060-displays-months-in-chronological-order-pivot-table
Sheet: Pivot Table

Row Labels | Sum of Sales
April 2013 | 192920
April 2014 | 231504
December 2013 | 103775
December 2014 | 124530
February 2013 | 165964.75
February 2014 | 177690
January 2013 | 171668
January 2014 | 170834
May 2013 | 129070
May 2014 | 154884
March 2013 | 125317.5
March 2014 | 150381
November 2013 | 119947.5
November 2014 | 128863
Grand Total | 2147348.75
Spreadsheet: 837107d1689856155-filter-birthdays-onto-dynamic-calendar-calendar-birthdays
Sheet: Calendar

 |  | JULY |  | MONDAY
 | CALENDAR YEAR | CALENDAR MONTH |  | FIRST DAY OF WEEK
 |  |  |  |  |  |  |  |  |  |  | What it should look like
 |  |  |  |  |  |  |  |  |  |  | 2023-07-20 00:00:00 | * This should be dynamic as well, so if the calendar changes it'll move with it
 |  |  |  |  |  |  |  |  |  |  | PERSON A - AGE 46
 |  |  |  |  |  |  |  |  |  |  | PERSON B - AGE 41
 |  |  |  |  |  |  |  |  |  |  | Optional if you can do it too
 |  |  |  |  |  |  |  |  |  |  | 2023-07-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  | PERSON A - AGE 46
 |  |  |  |  |  |  |  |  |  |  | PERSON B - AGE 41
 |  |  |  |  |  |  |  |  |  |  | aaaaaaaaaaaa
Spreadsheet: 793662d1661618315-lookup-value-and-return-corresponding-cell-range-help
Sheet: Sheet1

 | Source data
23 | 38 | 54 | 78 | 82
66463 | 66863 | 67063 | 66764 | 67053
Case-1 |  |  | Case-2
Enter value | 54 |  | If input value | 79
requirement: | 66463 |  | requirement: | 66463
 | 66863 |  |  | 66863
 | 67063 |  |  | 67063
 |  |  |  | 66764
Spreadsheet: 476593d1471938523-counting-value-oeldere0-476569d1471929840-counting-value-counting_summary
Sheet: Sheet1

 |  |  | Name | Location | Type | Status
 |  |  | Name1 | Location1 | A | Closed
 |  |  | [NAME] | Location2 | A & B | Closed
 |  |  | Name3 | Location3 | A
 |  |  | Name4 | Location1 | B | Closed
 |  |  | Name5 | Location3 | B
 |  |  | Name6 | Location2 | A & B | Closed
 |  |  | Name7 | Location1 | A & B
 |  |  | Name8 | Location2 | A | Closed
 |  |  | Name9 | Location3 | B
 |  |  | Name10 | Location5 | A & B
 |  |  | Name11 | Location4 | A
 |  |  | Name12 | Location3 | B
 |  |  | Name13 | Location5 | B | Closed
 |  |  | Name14 | Location4 | A & B
 |  |  | Summary of CLOSED activity
 |  |  | Location | A | B |  |  | Aantal [NAME] | Kolomlabels
 |  |  | Location1 | 1 | 1 |  |  | Rijlabels | A | A & B | B | Eindtotaal
 |  |  | Location2 | 3 | 2 |  |  | Location1 | 1 |  | 1 | 2
 |  |  | Location3 | 0 | 0 |  |  | Location2 | 1 | 2 |  | 3
 |  |  | Location4 | 0 | 0 |  |  | Location3
 |  |  | Location5 | 0 | 1 |  |  | Location4
 |  |  |  |  |  |  |  | Location5 |  |  | 1 | 1
 |  |  |  |  |  |  |  | Eindtotaal | 2 | 2 | 2 | 6
Spreadsheet: 29871d1225101304-merging-two-worksheets-into-one-example1
Sheet: Additional Donor Information Ex

First Name | Last Name | Date of Donation | Amount Donated | Method of Donation | Title (Mr., Mrs. [NAME]) | SpouseFirst | SpouseLast | Company | [NAME] | Phone | Address | City | Country | State | ZipCode | Preferred Contact | Donation | PaymentMethod | DateofDonation | Recurring Donor | Tax Deductible | ThankYouNoteSent | Organization | [NAME] | Notes
Peanut | MM | 2008-10-15 00:00:00 | 100 | Check | Mr. | Eva | [NAME] | 0 | [EMAIL] | 4444444 | 4411 [NAME] | Los Angeles | USA | CA | 91321 | 0 | 100 | Check | 2008-10-15 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Kent | 2008-10-17 00:00:00 | 200 | Check | Ms. | Edmund | Kent | 0 | [EMAIL] | 222222222 | 1111 Doe Pl. | New York | USA | NY | 112233 | 0 | 200 | Check | 2008-10-17 00:00:00 | No | No | No | 0 | No | 0
[NAME] | MM | 2008-10-19 00:00:00 | 50 | Online | NE | NE | NE | NE | NE | NE | NE | NE | NE | NE | NE | NE | 50 | Online | 2008-10-19 00:00:00 | NE | NE | NE | NE | NE | NE
[NAME] | Doe | 2008-10-23 00:00:00 | 300 | Check | Mr. | [NAME] | Doe | 0 | [EMAIL] | 1112223333 | 1113 Doe Pl | Syracuse | USA | NY | 13210 | 0 | 300 | Check | 2008-10-23 00:00:00 | No | Yes | Yes | 0 | No | 0
Peanut | MM | 2008-10-24 00:00:00 | 50 | Online | Mr. | Eva | [NAME] | 0 | [EMAIL] | 4444444 | 4411 [NAME] | Los Angeles | USA | CA | 91321 | 0 | 50 | Online | 2008-10-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
X | Y1 |  |  |  | Mrs. | [NAME] | Roosevelt | 0 | xxxx | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 848767d1699398697-count-pairs-a-and-b-in-same-row-four-columns-down-multiple-rows-book1
Sheet: Sheet1

 | Week 1
Tee | Name | Code | Name | Code | Name | Code | Name | Code
1 | [NAME] | Host 1 | [NAME] | Host 2 | Sparky | 45 | Kargo | 46
2 | Ray | 1 | [NAME] | 12 | Garth | 23 | [NAME] | 34
3 | [NAME] | 2 | Al | 13 | [NAME] | 24 | [NAME] | 35
4 | [NAME] | 3 | Walter | 14 | [NAME] | 25 | [NAME] | 36
5 | [NAME] | 4 | [NAME] | 15 | [NAME] | 26 | [NAME] | 37
6 | [NAME] | 5 | [NAME] | 16 | [NAME] | 27 | [NAME] | 38
7 | Geoff | 6 | Mario | 17 | [NAME] | 28 | Hans | 39
8 | [NAME] | 7 | [NAME] | 18 | [NAME] | 29 | Dennis | 40
9 | [NAME] | 8 | [NAME] | 19 | [NAME] | 30 | [NAME] | 41
10 | [NAME] | 9 | Cluade | 20 | [NAME] | 31 | [NAME] | 42
11 | [NAME] | 10 | [NAME] | 21 | [NAME] | 32 | [NAME] | 43
12 | Al | 11 | [NAME] | 22 | Sal | 33 | [NAME] | 44
 | Week 2
Tee | Name | Code | Name | Code | Name | Code | Name | Code
1 | [NAME] | Host 1 | [NAME] | Host 2 | Sparky | 45 | Kargo | 46
2 | Ray | 1 | [NAME] | 12 | [NAME] | 23 | [NAME] | 34
3 | [NAME] | 2 | [NAME] | 13 | Sal | 24 | [NAME] | 35
4 | [NAME] | 3 | Al | 14 | Garth | 25 | [NAME] | 36
5 | [NAME] | 4 | Walter | 15 | [NAME] | 26 | [NAME] | 37
6 | [NAME] | 5 | [NAME] | 16 | [NAME] | 27 | [NAME] | 38
7 | Geoff | 6 | [NAME] | 17 | [NAME] | 28 | [NAME] | 39
8 | [NAME] | 7 | Mario | 18 | [NAME] | 29 | [NAME] | 40
9 | [NAME] | 8 | [NAME] | 19 | [NAME] | 30 | [NAME] | 41
10 | [NAME] | 9 | [NAME] | 20 | [NAME] | 31 | Hans | 42
11 | [NAME] | 10 | Cluade | 21 | [NAME] | 32 | Dennis | 43
12 | Al | 11 | [NAME] | 22 | [NAME] | 33 | [NAME] | 44
Spreadsheet: 114293d1310061400-sumifs-dummybook2
Sheet: Summary

Neg ID | Name |  | June |  |  |  | YTD
 |  |  | Approval Count | % of Total Approvals | Rejection Count | % of Total Rejections | Approval Count | % of Total Approvals | Rejection Count | % of Total Rejections
000001 | Amber Simms |  | #[NAME]! | #[NAME]! | 0 | 0 | 0 | 0.0003869162772701569 | 0 | 0.01038535118884941
000002 | [NAME] |  | #[NAME]! | #[NAME]! | 0 | 0 | 0 | 0.04330486026369833 | 0 | 0.2101667122164526
000003 | [NAME] |  | #[NAME]! | #[NAME]! | 0 | 0.1038338658146965 | 0 | 0.1797374921872675 | 0 | 0.03060945613555616
Spreadsheet: 5c65297b-1887-40e8-874d-5c41a3076890
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Delitzsch, Stadt - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 3623 | 3649 | 3530 | 3271
20 - 25 | 1597 | 732 | 810 | 866
25 - 35 | 3130 | 3028 | 2168 | 1615
35 - 55 | 7730 | 6841 | 5949 | 5480
55 - 67 | 4252 | 4977 | 5189 | 4817
67 und mehr | 5703 | 5851 | 6330 | 6866
Insgesamt | 26035 | 25078 | 23976 | 22915
%
unter 20 | 13.91588246591127 | 14.55060212138129 | 14.72305638972306 | 14.27449269037748
20 - 25 | 6.134050316881122 | 2.918893053672542 | 3.378378378378379 | 3.779183940650229
25 - 35 | 12.02227770309199 | 12.07432809633942 | 9.042375709042377 | 7.047785293475889
35 - 55 | 29.69080084501632 | 27.27888986362549 | 24.81231231231231 | 23.91446650665503
55 - 67 | 16.33186095640484 | 19.84608022968339 | 21.64247580914247 | 21.02116517564914
67 und mehr | 21.90512771269445 | 23.33120663529787 | 26.4014014014014 | 29.96290639319223
Insgesamt | 100 | 100 | 100 | 100
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: 834517d1687881389-how-to-average-based-on-the-value-of-another-cell-forum-help
Sheet: Sheet1

22468.75
27947.91666666667
29958.33333333333
29979.16666666667
22145.83333333333
22468.75
21682.5
19567.91666666666
17745
22468.75
22484.58333333333
21656.25
14245
22370
11781.25
25047.08333333333
27593.75
29979.16666666667 | 3.75
22578.33333333333 | 14
22484.58333333333 | 14
22468.75 | 14
Spreadsheet: tracy_geaccone__40401__GPM 101021  101073 Recalculation
Sheet: June 2001

KN Processing |  | GPM Agency Agreement |  |  | Prepared by [NAME]
Bushton Plant |  | TFDV Volume & Dollar Calculation
 |  | For
 |  | 2001-06-01 00:00:00
Contract #101021 |  |  | NNG Numbers |  |  | Oneok Numbers |  |  | Difference
 | Total Deliveries |  |  | 4675460 |  |  | 3479050
 |  | Deliveries to Inlet | 4473250 |  |  | 3337210
 |  | Deliveries to PVR
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 4656944 |  |  | 3479649
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
Contract #101073
 | Total Deliveries |  |  | 1171979 |  |  | 1330289
 |  | Deliveries to Inlet | 0
 |  | Deliveries to PVR | 1121301 |  |  | 1273566
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 1085805 |  |  | 1319413
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
 |  | Total Both Contracts
 |  | Index |  | 3.451
 |  | Total Revenue Due
Total Revenue Billed |  | 101021 |  | 44113.22
 |  | 101073
 |  |  |  |  |  |  | 45596.23
 |  | Amount Due NNG (GPM)
Charge given by NNG on prior reconciliation
 |  | Amount Due NNG (GPM)
Spreadsheet: 134938d1325707637-countif-with-certain-criteria-no-duplicates-portfolio-management-report-template
Sheet: Summary

Rep Name | Total Accounts | Total Worked ( at least 1 attempt to) | % Worked | Total Penetrated (min 5 attempts) | % Penetrated | POD Touch #1 - Complete (Presentation) | % Completed 1st call | POD Touch #2 - Complete (Pres) | % Completed 2nd Call | POD Touch #3 - Complete (Pres) | % Completed 3rd Call | Accts w/ 4+ POD Touch - Complete (Pres) | % of Accts w/ 4+ Completed | Do Not Call Request | % DNC | [NAME] | % Merchant Refused/ Disconnect | [NAME] | % [NAME] | Left Voicemail | Scheduled Callback | Unreachable (fax/modem, wrong #)
Rep 1
Rep 2
Rep 3
Rep 4
Rep 5
Total
Spreadsheet: 839148d1691693505-lookup-example-1-
Sheet: Income

 | INCOME
 |  |  |  |  |  |  |  | Total Made
 | Date | Item | Income Stream | Price | Payment | Fees | Postage | Total | Notes |  |  | Fees | Percentage | Column2
 | 20th May 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | Lutterworth |  |  | Cash | 0
 | 20th May 2023 | [NAME] | Craft Market | 15 | SumUp |  | 0 |  | Lutterworth |  |  | Paypal | 0.029 | 0.3
 | 20th May 2023 | [NAME] | Craft Market | 15 | Cash |  | 0 |  | Lutterworth |  |  | SumUp | 0.0169
 | 20th May 2023 | Dragonfly | Craft Market | 10 | Cash |  | 0 |  | Lutterworth |  |  | Stripe | 0.015 | 0.2
 | 20th May 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | Lutterworth
 | 27th May 2023 | [NAME] | Craft Market | 25 | SumUp |  | 0 |  | Hinckley
 | 27th May 2023 | Gothic Spinner & [NAME] | Craft Market | 35 | SumUp |  | 0 |  | Hinckley
 | 27th May 2023 | Rainbow Spinner & Squirly Heart | Craft Market | 35 | SumUp |  | 0 |  | Hinckley
 | 27th May 2023 | [NAME] | Craft Market | 15 | Cash |  | 0 |  | Hinckley
 | 3rd June 2023 | [NAME] | Craft Market | 25 | Cash |  | 0 |  | [NAME]
 | 8th June 2023 | Poppy Spinner | Craft Market | 25 | Paypal |  | 3.29 |  | March
 | 8th June 2023 | Dragonfly | Craft Market | 10 | Cash |  | 0 |  | March
 | 8th June 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | March
 | 22nd June 2023 | Custom Dangle & Custom Heart | Craft Market | 40 | SumUp |  | 3.29 |  | Banbury
 | 22nd June 2023 | Dragonfly | Craft Market | 10 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | [NAME] | Craft Market | 10 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | Crystal Sqaure | Craft Market | 20 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | [NAME] | Craft Market | 25 | Cash |  | 0 |  | Banbury
 | 4th August | [NAME] | Website | 20 | Stripe |  | 3.29
Spreadsheet: 759078d1639296363-if-with-dates-and-conditions-simplified-sheet
Sheet: test (2)

Status | Client Code | Invoice | Invoice date | Reminder 1 | Reminder 2 |  |  | FR | 411F030 |  | 411F052
 | 411F030 | FA0685 | 2020-01-07 00:00:00 | 2021-12-09 00:00:00
 | 411F033 | FA0738 | 2020-02-11 00:00:00 | 2021-08-12 00:00:00 | 2021-09-15 00:00:00
 | 411f033 | FA0803 | 2021-10-15 00:00:00
 | 411f030 | FA1528 | 2021-11-15 00:00:00
 | 411f033 | FA1267 | 2021-09-08 00:00:00 | 2021-10-08 00:00:00 | 2021-12-01 00:00:00
 | 411f032 | FA2365 | 2020-03-12 00:00:00 | 2021-10-15 00:00:00
 | 411f032 | FA1052 | 2020-09-08 00:00:00 | 2021-11-19 00:00:00
 | 411f030 | FA1312 | 2021-12-02 00:00:00
 | 411f033 | FA0985 | 2021-10-23 00:00:00
Spreadsheet: 781735d1653504059-sumifs-not-working-sumifs
Sheet: Sheet1

Lookup Acct | [NAME] |  | Acct # | Currency
520100 |  |  | 520100 | 500
520010 |  |  | 534821 | 300
 |  |  | 520010 | 250
 |  |  | 500100 | 100
 |  |  | 520100 | 100
 |  |  | 520010 | 50
Spreadsheet: 766844d1644088808-function-to-put-space-and-comma-in-between-numbers-testwks1
Sheet: Sheet1

11 | 16 | 11 | 21 | 22 | 26 | 31 |  |  |  | 21,22
4 | 10 | 15 | 25 | 27 | 21 | 32
11 | 14 | 25 | 26 | 31 | 34 | 35 |  |  |  | 25,26 34,35
2 | 9 | 13 | 24 | 21 | 29 | 33
5 | 15 | 20 | 27 | 21 | 29 | 34
16 | 11 | 19 | 23 | 26 | 32 | 35
3 | 10 | 13 | 16 | 20 | 29 | 33
3 | 11 | 25 | 30 | 32 | 33 | 34 |  |  |  | 32,33 33,34
4 | 9 | 14 | 25 | 21 | 29 | 34
4 | 5 | 19 | 26 | 27 | 30 | 33 |  |  |  | 4,5 26,27
3 | 9 | 16 | 17 | 21 | 22 | 34 |  |  |  | 16,17 21,22
1 | 2 | 3 | 11 | 15 | 33 | 34 |  |  |  | 1,2 2,3 33,34
1 | 2 | 3 | 4 | 15 | 17 | 20 |  |  |  | 1,2 2,3 3,4
 |  |  |  |  |  |  |  |  | Current function results in Col J
 |  |  |  |  |  |  |  |  | function unable to accept comma seperating each number
 |  |  |  |  |  |  |  |  | Desired new function results in column K
 |  |  |  |  |  |  |  |  | IF(B20=[NAME]=[NAME]=C20+1,C20&D20,"")&IF(E20=D20+1,D20&E20,"")&IF(F20=E20+1,E20&F20,"")&IF(G20=F20+1,F20&G20,"")
Spreadsheet: 271982d1382123265-logical-formulas-for-schedule-creation-master-schedule-template
Sheet: New Voices

 | WEDNESDAY, MARCH 26 |  |  |  |  |  |  |  |  |  |  |  |  | THURSDAY, MARCH 27
 | 9-10a | 10-11a | 11a-12p | 12-1p | 1-2p | 2-3p | 3-4p | 4-5p | 5-6p | 6-7p | 7-8p | 8-9p | 9-10p | 9-10a | 10-11a | 11a-12p | 12-1p | 1-2p | 2-3p | 3-4p | 4-5p | 5-6p | 6-7p | 7-8p | 8-9p | 9-10p
Guest Artist 1
Guest Artist 2
Guest Artist 3
Guest Artist 4
Guest Artist 5
Guest Artist 6
Guest Artist 7
Guest Artist 8
Guest Artist 9
Guest Artist 10
Guest Artist 11
Guest Artist 12
Guest Artist 13
Guest Artist 14
Guest Artist 15
Guest Artist 16
Guest Artist 17
Guest Artist 18
Guest Artist 19
Guest Artist 20
Guest Artist 21
Guest Artist 22
Guest Artist 23
Guest Artist 24
Guest Artist 25
Guest Artist 26
Guest Artist 27
Guest Artist 28
Guest Artist 29
Guest Artist 30
Spreadsheet: 6ec68e1d-a383-4824-8fda-fb39f865a90a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
9806 | Test | 9806 | Fontana-Masson Silver Stain | Fontana-Masson Silver ST | Includes pathology consultation charged separately. | Formalin-fixed, paraffin-embedded tumor tissue block. Include 1 H & E slide: FFPTHE |  |  |  | Varies | Container/Tube:  Preferred: Formalin-fixed, paraffin-embedded tissue block Acceptable: Tissue in formalin Collection Instructions: Include 1 hematoxylin-and-eosin stained slide. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Tuesday through Thursday 7 a.m. | 3 days | 9 days | 1 | 88313 |  |  |  |  | Rochester
9806 | [NAME] | MIXED | Mixed |  |  |  | Ambient
9806 | Result | 9806 | Fontana-Masson Silver ST | Fontana-Masson Silver ST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10810-0 | Microscopic observation:Prid:Pt:Tiss:Nom:Silver stain.Fontana-Masson
Spreadsheet: 154885d1336588792-lookup-lookup-peiling
Sheet: Sheet1

 | 0 | -45 | 45 | 100 | 250 | 500 | 1000 |  |  |  | DEST weight RATES
CDG | 100 | 20.45 | 4 | 3.9 | 3.8 | 3.5 | 3.2 |  |  |  | CDG | 100 | need to look up 3.90 from table 1)
IST | 100 | 20.45 | 3 | 2.8 | 2.7 | 2.7 | 2.5 |  |  |  | IST | 320 | need to look up 2.70 from table 1)
AMS | 100 | 20.45 | 3.9 | 3.8 | 3.7 | 3.4 | 3.1 |  |  |  | AMS | 250 | need to look up 3.70 from table 1)
HAM | 100 | 20.45 | 4.1 | 4 | 3.9 | 3.5 | 3.2 |  |  |  | HAM | 999 | need to look up 3.50 from table 1)
Spreadsheet: 799703d1665221033-case-sensitive-with-match-while-using-arrays-excel_help-1-
Sheet: control-2arrays

UNMATCH: |  | (case-unsensitive) |  | =SUMPRODUCT((1*ISNA(MATCH(A4&A5:A1000,E5:E10&F5:F10,0))=1)*(A5:A1000<>"")*1)
 | ? | (case-sensitive)
grade | location |  |  | label | value
A | US |  |  | location | MX
A | DE |  |  | grade | A
B | MX |  |  | grade | B
C | US |  |  | location | US
D | DE |  |  | location | NL
a | MX |  |  | grade | C
F | US
A | DE
A | MX
B | FR
B | DE
D | MX
A | FR
B | US