tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 793191d1661353861-identify-which-week-a-specified-date-falls-in-cash-flow-date-incl-new-year-and-eastern-hd
Sheet: Sheet1

 | Week begin | 2022-08-29 00:00:00
 | Expected result
 | Pmt 1st
 | Pmt 15th
 |  |  |  |  |  |  | 1st is Saturday |  | 15th is a Saturday
 | 2022-09-01 00:00:00 |  |  | 2022-09-15 00:00:00
 | 2022-10-01 00:00:00 |  |  | 2022-10-15 00:00:00 |  |  |  | INPUT YEAR | 2024
 | 2022-11-01 00:00:00 |  |  | 2022-11-15 00:00:00
 | 2022-12-01 00:00:00 |  |  | 2022-12-15 00:00:00
 | 2023-01-01 00:00:00 |  |  | 2023-01-15 00:00:00 |  |  |  |  | 2024-01-15 00:00:00
 | 2023-02-01 00:00:00 |  |  | 2023-02-15 00:00:00 |  |  |  |  | 2024-02-01 00:00:00
 | 2023-03-01 00:00:00 |  |  | 2023-03-15 00:00:00 |  |  |  |  | 2024-02-15 00:00:00
 | 2023-04-01 00:00:00 |  |  | 2023-04-15 00:00:00 |  |  |  |  | 2024-03-01 00:00:00
 | 2023-05-01 00:00:00 |  |  | 2023-05-15 00:00:00 |  |  |  |  | 2024-03-15 00:00:00
 | 2023-06-01 00:00:00 |  |  | 2023-06-15 00:00:00 |  |  |  |  | 2024-04-02 00:00:00
 | 2023-07-01 00:00:00 |  |  | 2023-07-15 00:00:00 |  |  |  |  | 2024-04-15 00:00:00
 | 2023-08-01 00:00:00 |  |  | 2023-08-15 00:00:00 |  |  |  |  | 2024-05-01 00:00:00
 | 2023-09-01 00:00:00 |  |  | 2023-09-15 00:00:00 |  |  |  |  | 2024-05-15 00:00:00
 | 2023-10-01 00:00:00 |  |  | 2023-10-15 00:00:00 |  |  |  |  | 2024-06-03 00:00:00
 | 2023-11-01 00:00:00 |  |  | 2023-11-15 00:00:00 |  |  |  |  | 2024-06-17 00:00:00
 | 2023-12-01 00:00:00 |  |  | 2023-12-15 00:00:00 |  |  |  |  | 2024-07-01 00:00:00
 |  |  |  |  |  |  |  |  | 2024-07-15 00:00:00
 |  |  |  |  |  |  |  |  | 2024-08-01 00:00:00
 |  |  |  |  |  |  |  |  | 2024-08-15 00:00:00
 |  |  |  |  |  |  |  |  | 2024-09-02 00:00:00
 |  |  |  |  |  |  |  |  | 2024-09-16 00:00:00
 |  |  |  |  |  |  |  |  | 2024-10-01 00:00:00
 |  |  |  |  |  |  |  |  | 2024-10-15 00:00:00
 |  |  |  |  |  |  |  |  | 2024-11-01 00:00:00
 |  |  |  |  |  |  |  |  | 2024-11-15 00:00:00
 |  |  |  |  |  |  |  |  | 2024-12-02 00:00:00
 |  |  |  |  |  |  |  |  | 2024-12-16 00:00:00
Spreadsheet: 110211d1306942670-excel-2007-lookup-column-data-based-upon-row-column-matches-ec-usage-help2
Sheet: Sheet1

[NAME] | P
Row Labels | Sum of Total | Sum of Feb-11 | Sum of Mar-11 | Sum of Apr-11
702273 | 41 | 18 | 14 | 9
702274 | 4 | 2 | 0 | 2
702287 | 4 | 2 | 2 | 0
702349 | 1 | 0 | 1 | 0
702732 | 120 | 29 | 46 | 45
702968 | 2 | 0 | 2 | 0
702994 | 16 | 1 | 5 | 10
703105 | 34 | 10 | 9 | 15
703113 | 19 | 9 | 3 | 7
703521 | 19 | 14 | 2 | 3
703610 | 15 | 0 | 12 | 3
703651 | 6 | 4 | 1 | 1
703702 | 5 | 1 | 1 | 3
703711 | 17 | 4 | 8 | 5
703825 | 17 | 6 | 11 | 0
703850 | 6 | 0 | 2 | 4
704013 | 21 | 3 | 6 | 12
704180 | 20 | 3 | 16 | 1
704183 | 7 | 2 | 3 | 2
704187 | 30 | 6 | 10 | 14
704191 | 45 | 11 | 19 | 15
704316 | 3 | 0 | 0 | 3
704413 | 8 | 5 | 3 | 0
704423 | 3 | 0 | 0 | 3
704560 | 7 | 2 | 5 | 0
704734 | 17 | 6 | 6 | 5
704762 | 2 | 2 | 0 | 0
704811 | 1 | 0 | 1 | 0
706168 | 5 | 0 | 3 | 2
706174 | 3 | 0 | 1 | 2
707254 | 1 | 0 | 1 | 0
707281 | 18 | 9 | 4 | 5
707507 | 26 | 15 | 8 | 3
707522 | 2 | 0 | 2 | 0
707680 | 11 | 5 | 3 | 3
Grand Total | 556 | 169 | 210 | 177
Spreadsheet: 84165d1284150720-billing-forecast-cash-flow-test-v3
Sheet: Data Source

Job Summary No | Project Type | ODD Yr | Site Name | Project Manager | RCI Type | ADA Type | State | Region | Phase | Property [NAME] Reno Level | Serial No | Facility Partner | Start Of Construction-Projected | Start Of Construction-Actual | Open Date For Customers (Proj/Act) | Closeout Package Submitted-Actual | On Hold? | Total Forecasted Cost (CW) | Adjustments | Total Projected (CW - Adj.) | Funded to date (CW-Capital) | Total Paid $ (CW-Capital) | 2010 YTD Implied Cash Flow- CW Capital | Payables Cash Flow - CW Capital | Adjustments - CW Capital | Management Fees - CW Capital | Amount Paid Prior to 2010- CW Capital | Amount Left to [NAME] | % Billed | % Left to [NAME] | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2010 PROJECTED Spend | 2010 Capital Utilization | 2011 Capital Utilization
 | New Store |  |  |  |  |  | CA |  | Feasibility | [NAME] | CA0140 |  | 2009-10-19 00:00:00 | 2009-10-28 00:00:00 | 2010-05-24 00:00:00 | 2010-08-20 00:00:00 |  | 3150665.44 |  |  | 4505802 |  | 877134.66 | 1449494.22 | -666506.08 | 94146.52 | 1964576.91
 | New Store |  |  |  |  |  | AZ |  | Feasibility |  | AZ0100 |  | 2010-02-26 00:00:00 | 2010-02-26 00:00:00 | 2010-09-22 00:00:00 |  |  | 1984763.86 |  |  | 1953978 |  | 1062604.68 | 997750.87 | 0 | 64853.81 | 218048.69
Spreadsheet: richard_shapiro__32653__2002 Plan Budget Pack -  Reg Affairs FINAL
Sheet: Headcount Summary

 |  |  |  |  |  |  |  |  |  |  | HIGHLIGHTS
 |  |  |  | Total Employee Costs * |  | Cost per Head |  | Ave Headcount | Average
 | 2000 Actual |  |  |  |  |  |  | 21
 | 2001 Actual/CE2 |  |  |  |  |  |  | 19 |  |  |  | December 2001 Closing | 19
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  |  |  | Additions/Subtractions
 |  |  |  |  |  |  |  |  |  |  |  | December 2002 Closing
 |  |  |  |  |  |  |  |  |  |  | COMMENTS
 |  |  |  |  |  |  |  |  |  |  | 2002 sees reduced T&E costs per person.
 |  |  |  |  |  |  |  |  |  |  | 2001 CE2 had a large forecasted T&E amount, in 2002 this is less
 |  |  |  |  |  |  |  |  |  |  | 2001 Salaries included expat costs.  2002 has no expat costs
 | * Total Employee Cost includes Salary & Wages, Travel & Entertainment and Office Expenses
Spreadsheet: 1654d189-8e4a-4ccf-bb68-300d81038d58
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
GAABS | Test | GAABS | [NAME], Blood Spot | [NAME], BS | Fluorometric Enzyme Assay |  |  |  | 2 | Blood spots | Container/Tube:  Preferred: Whatman Protein Saver 903 Paper Acceptable: Ahlstrom 226 Filter Paper, Supplemental Newborn Screening Card (Supply T493) [NAME]: 2 blood spots Collection Instructions:  1. Do not use device or capillary tube containing EDTA to collect specimen. 2. An alternative blood collection option for a patient >1 year of age is fingerstick. 3. Let blood dry on the filter paper at ambient temperature in a horizontal position for 3 hours. 4. Do not expose specimen to heat or direct sunlight. 5. Do not stack wet specimens. 6. Keep specimen dry. Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | Blood Spot: 1 | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Blood spot specimen that shows serum rings or has multiple layers | Normal >7.4 pmol/punch/h | Thursday; morning | 8 days | 15 days | 1 | 82657 |  |  |  |  | Rochester
GAABS | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 87 days
GAABS | Result | 30096 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
GAABS | Result | 30097 | [NAME] | [NAME] | Alphanumeric
GAABS | Result | 30098 | Source | Source | Alphanumeric
GAABS | Result | 30099 | Order Date | Order Date | Alphanumeric
GAABS | Result | 30100 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
GAABS | Result | 30101 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
GAABS | Result | 30149 | Acid alpha-glucosidase | Acid alpha-glucosidase | Numeric |  |  |  |  | pmol/punch/h |  |  |  |  |  |  |  |  |  | 55827-0
GAABS | Result | 30102 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
GAABS | Result | 30103 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
GAABS | Result | 30104 | Reviewed By | Reviewed By | Numeric
GAABS | Result | 30105 | Release Date | Release Date | Alphanumeric
Spreadsheet: 548912d1511369702-formula-to-index-values-based-on-criteria-in-numerical-order-index-unique-values-based-on-criteria
Sheet: Sheet1

 |  | DATA
 | 1 | 1.45
 | 2 | 1.46 |  |  |  |  |  |  | LOWER LIMIT | 1.4
 | 3 | 1.39 |  |  |  |  |  |  | UPPER LIMIT | 1.5
 | 4 | 1.43
 | 5 | 1.56 |  |  |  |  | COUNT:
 | 6 | 1.45 |  |  |  |  |  | LESS THAN LOWER LIMT | GREATER THAN UPPER LIMIT | UNIQUE AND IN ORDER | UNIQUE AND IN ORDER
 | 7 | 1.67 |  |  |  |  | 1 |  |  | 1.33 | 1.55
 | 8 | 1.49 |  |  |  |  | 2 |  |  | 1.34 | 1.56
 | 9 | 1.47 |  |  |  |  | 3 |  |  | 1.39 | 1.57
 | 10 | 1.55 |  |  |  |  | 4 |  |  |  | 1.61
 | 11 | 1.78 |  |  |  |  | 5 |  |  |  | 1.67
 | 12 | 1.56 |  |  |  |  | 6 |  |  |  | 1.78
 | 13 | 1.43 |  |  |  |  | 7
 | 14 | 1.45 |  |  |  |  | 8
 | 15 | 1.43 |  |  |  |  | 9
 | 16 | 1.57 |  |  |  |  | 10
 | 17 | 1.45 |  |  |  |  | 11
 | 18 | 1.41 |  |  |  |  | 12
 | 19 | 1.43 |  |  |  |  | 13
 | 20 | 1.45 |  |  |  |  | 14
 | 21 | 1.39 |  |  |  |  | 15
 | 22 | 1.45 |  |  |  |  | 16
 | 23 | 1.55 |  |  |  |  | 17
 | 24 | 1.33 |  |  |  |  | 18
 | 25 | 1.56 |  |  |  |  | 19
 | 26 | 1.56 |  |  |  |  | 20
 | 27 | 1.45 |  |  |  |  | 21
 | 28 | 1.34 |  |  |  |  | 22
 | 29 | 1.34 |  |  |  |  | 23
 | 30 | 1.61 |  |  |  |  | 24
 | 31 | 1.56 |  |  |  |  | 25
 | 32 | 1.61 |  |  |  |  | 26
 |  |  |  |  |  |  | 27
 |  |  |  |  |  |  | 28
 |  |  |  |  |  |  | 29
 |  |  |  |  |  |  | 30
 |  |  |  |  |  |  | 31
 |  |  |  |  |  |  | 32
 |  |  |  |  |  |  | 33
 |  |  |  |  |  |  | 34
 |  |  |  |  |  |  | 35
Spreadsheet: 870905d1717399455-targets-vs-act-test-177-aligw
Sheet: Sheet1

 | REV STREAM | 2023 Q1 | 2023 Q2 | 2023 Q3 | 2023 Q4 | 2023 ACT | 2023 TARGET | OPEN. ORDER | Q1 ACT 2024 | Q2 ACT 2024 | Q3 ACT 2024 | Q4 ACT 2024 | Q1 TARGET | [NAME] | [NAME] | [NAME] | 2024 TARGET | ACT VS TGT
PROPERTIES |  |  |  |  |  |  |  |  | 0.25 | 0.25 | 0.15 | 0.35 | 0.25 | 0.25 | 0.15 | 0.35
XY | ONG | 36419.69 | 20445.29 | 17640.29 | 7508.53 |  | 50000 | 0 | 10000 | 15000 | 10000 | 10000 | 7500 | 10000 | 18000 | 25000 | 70000
 |  |  |  |  |  |  |  |  |  |  |  | AliGW
Spreadsheet: 253bb729-334c-4c7b-9435-bb3f8127bbb6
Sheet: Sheet1

Table 4--Wheat: Monthly food disappearance estimates (1,000 grain-equivalent bushels), 9/16/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Mkt year and month 1/
 |  |  | Wheat ground for flour | + | Food imports 2/ | + | Nonmilled food use 3/ | - | Food exports 2/ | = | Food use 4/
2011/12 | Jun |  | 70554 |  | 2237 |  | 2000 |  | 1743 |  | 73048
 | Jul |  | 72573 |  | 2098 |  | 2000 |  | 1327 |  | 75344
 | Aug |  | 79317 |  | 2308 |  | 2000 |  | 2390 |  | 81235
 | Sep |  | 76269 |  | 2245 |  | 2000 |  | 1652 |  | 78863
 | Oct |  | 81402 |  | 2247 |  | 2000 |  | 1487 |  | 84162
 | Nov |  | 77915 |  | 2568 |  | 2000 |  | 1763 |  | 80720
 | Dec |  | 73135 |  | 2464 |  | 2000 |  | 1291 |  | 76308
 | Jan |  | 74522 |  | 2579 |  | 2000 |  | 1233 |  | 77868
 | Feb |  | 73931 |  | 2057 |  | 2000 |  | 1330 |  | 76658
 | Mar |  | 78437 |  | 2555 |  | 2000 |  | 1843 |  | 81149
 | Apr |  | 74497 |  | 2622 |  | 2000 |  | 1513 |  | 77606
 | May |  | 76171 |  | 2530 |  | 2000 |  | 2310 |  | 78390
2012/13 | Jun |  | 72876 |  | 2173 |  | 2000 |  | 1760 |  | 75290
 | Jul |  | 75861 |  | 2296 |  | 2000 |  | 2912 |  | 77245
 | Aug |  | 82910 |  | 2345 |  | 2000 |  | 2193 |  | 85063
 | Sep |  | 79725 |  | 2069 |  | 2000 |  | 2283 |  | 81511
 | Oct |  | 81567 |  | 2462 |  | 2000 |  | 1840 |  | 84189
 | Nov |  | 78073 |  | 2438 |  | 2000 |  | 1613 |  | 80897
 | Dec |  | 73283 |  | 2369 |  | 2000 |  | 1442 |  | 76210
 | Jan |  | 72290 |  | 2191 |  | 2000 |  | 1550 |  | 74931
 | Feb |  | 71716 |  | 2101 |  | 2000 |  | 1674 |  | 74143
 | Mar |  | 76088 |  | 2391 |  | 2000 |  | 1744 |  | 78734
 | Apr |  | 74750 |  | 2581 |  | 2000 |  | 1432 |  | 77899
 | May |  | 76429 |  | 2530 |  | 2000 |  | 2042 |  | 78917
2013/14 | Jun |  | 73123 |  | 2277 |  | 2000 |  | 2430 |  | 74970
 | Jul |  | 0 |  | 2519 |  | 0 |  | 1474 |  | 1044
1/ Current year is preliminary. Previous year is preliminary through August of current year, estimated afterwards. 2/ Food imports and exports used to calculate total food use. Includes all categories of wheat flour, semolina, bulgur, and couscous and selected categories of pasta. 3/ Wheat prepared for food use by processes other than milling.
4/ Estimated food use equals wheat ground for flour plus food imports plus nonmilled food use minus food exports. See http://www.ers.usda.gov/topics/crops/wheat/estimating-wheat-supply-and-use/food-use-estimates.aspx for more information. Source: Data through the 2nd quarter of 2011 was calculated using data from U.S. Department of Commerce, Bureau of the Census’ Flour Milling Products (MQ311A) and U.S. Department of Commerce, Bureau of Economic Analysis’ Foreign Trade Statistics. Subsequent flour milling calculations are based on data from the North American Millers Association.
Date run: 9/13/2013
Spreadsheet: 800008d1665432909-display-a-value-when-cells-reach-exceed-that-value-example-for-forum
Sheet: Sheet1 (2)

 |  |  | items sold | Answer goes here
Customer A |  | Customer A | 20 |  | When eg Customer A reaches more than 50 items, then in column C display "50 reached", otherwise leave D column blank until 50 has been reached
Customer B |  | Customer A | 2
Customer C |  | Customer B | 9 |  | In this example for Customer "A" cells C2 & C3 will be blank but the cells C5 and C7 will have "50 reached"
 |  | Customer A | 42 |  | In this example for Customer "B" the cell C4 will be blank as 50 hasn't been reached yet
 |  | Customer C | 31 |  | In this example for Customer "C" the cells C6 and C8 will be blank as they haven’t exceeded 50 yet
 |  | Customer A | 14
 |  | Customer C | 19
Spreadsheet: 165309d1341154797-link-row-data-to-column-copy-of-rows-from-cols
Sheet: Sheet3

 | Proizvod: | PILE ROSTER PODLOžAK |  |  |  |  |  | Proizvod: | PILE GRIL PODLOžAK |  |  |  |  |  | Proizvod: | PILE KALIBRO PODLOžAK |  |  |  |  |  | Proizvod: | PIL FILE PODLOž |  |  |  |  |  | Proizvod: | PILEćI FILE
 | Šifra proizvoda: | 100 |  |  |  |  |  | Šifra proizvoda: | 101 |  |  |  |  |  | Šifra proizvoda: | 102 |  |  |  |  |  | Šifra proizvoda: | 103 |  |  |  |  |  | Šifra proizvoda: | 104
 | [NAME] stanje zaliha: |  | [NAME] |  |  |  |  | [NAME] stanje zaliha: |  | [NAME] |  |  |  |  | [NAME] stanje zaliha: |  | [NAME] |  |  |  |  | [NAME] stanje zaliha: |  | [NAME] |  |  |  |  | [NAME] stanje zaliha: |  | [NAME]
 | Početna vrednost zaliha: |  | rsd |  |  |  |  | Početna vrednost zaliha: |  | rsd |  |  |  |  | Početna vrednost zaliha: |  | rsd |  |  |  |  | Početna vrednost zaliha: |  | rsd |  |  |  |  | Početna vrednost zaliha: |  | rsd
 | Prodaja po DI: |  | [NAME] |  |  |  |  | Prodaja po DI: |  | [NAME] |  |  |  |  | Prodaja po DI: |  | [NAME] |  |  |  |  | Prodaja po DI: |  | [NAME] |  |  |  |  | Prodaja po DI: |  | [NAME]
 | Završno stanje zaliha: |  | [NAME] |  |  |  |  | Završno stanje zaliha: |  | [NAME] |  |  |  |  | Završno stanje zaliha: |  | [NAME] |  |  |  |  | Završno stanje zaliha: |  | [NAME] |  |  |  |  | Završno stanje zaliha: |  | [NAME]
 | [NAME] vrednost zaliha: |  | rsd |  |  |  |  | [NAME] vrednost zaliha: |  | rsd |  |  |  |  | [NAME] vrednost zaliha: |  | rsd |  |  |  |  | [NAME] vrednost zaliha: |  | rsd |  |  |  |  | [NAME] vrednost zaliha: |  | rsd
 | [NAME] | Ukupno RSD | cene/jm |  |  |  |  | [NAME] | Ukupno RSD | cene/jm |  |  |  |  | [NAME] | Ukupno RSD | cene/jm |  |  |  |  | [NAME] | Ukupno RSD | cene/jm |  |  |  |  | [NAME] | Ukupno RSD | cene/jm
 | FIFO CK |  |  |  |  |  |  | FIFO CK |  |  |  |  |  |  | FIFO CK |  |  |  |  |  |  | FIFO CK |  |  |  |  |  |  | FIFO CK
 | [NAME] prodaja |  |  |  |  |  |  | [NAME] prodaja |  |  |  |  |  |  | [NAME] prodaja |  |  |  |  |  |  | [NAME] prodaja |  |  |  |  |  |  | [NAME] prodaja
 | Bruto dohodak |  |  |  |  |  |  | Bruto dohodak |  |  |  |  |  |  | Bruto dohodak |  |  |  |  |  |  | Bruto dohodak |  |  |  |  |  |  | Bruto dohodak
Spreadsheet: 809509d1671120067-use-comma-separated-values-in-a-cell-as-source-for-lookups-iterateovercommaseperateddatainacell
Sheet: Sheet1

Server | APPS |  | Expected result | Enhanced result | Enhanced result sorted by earliest date
S1 | app1 |  | 2021-12-10 00:00:00 | App1:10/12/21 | App1:10/12/21
[NAME] | app2,app10 |  | 17/03/2022, 10/12/21 | App2:17/03/2022, app10:10/12/21 | App10:10/12/21, App2:17/03/2022
S2
S6 | app6 |  | 2022-02-14 00:00:00 | App6:14/02/22 | App6:14/02/22
APPS | date
app1 | 2021-12-10 00:00:00 |  | Each server only appears once but and app can be on multiple servers.
app2 | 2022-03-17 00:00:00 |  | The removal date for an app is the same for all instances
app10 | 2021-12-10 00:00:00 |  | The server data will be on one worksheet and the app data on another
app6 | 2022-02-14 00:00:00 |  | Effectively I am looking for how to lookup things based on a previously textjoined list and possibly put in some extra data.
 |  |  | Office 365
Spreadsheet: 174033d1344890880-display-issue-is-there-a-fix-out-there-i-cant-find-pic-display-issue-row-19
Sheet: Team Cap Space

 |  | Team 1 |  |  |  | Team 2 |  |  |  | Team 3 |  |  |  | Team 4 |  |  |  | Team 5 |  |  |  | Team 6 |  |  |  | Team 7 |  |  |  | Team 8 |  |  |  | Team 9 |  |  |  | Team 10 |  |  |  | Team 11 |  |  |  | Team 12
 |  | Player |  | Price |  | Player |  | Price |  | Player |  | Price |  | Player |  | Price |  | Player |  | Price |  | Player |  | Price |  | Player |  | Price |  | Player |  | Price |  | Player |  | Price |  | Player |  | Price |  | Player |  | Price |  | Player |  | Price
QB |  | [NAME] |  | 120
QB |  |  |  | 5
RB |  |  |  | 50 |  |  |  | 40
RB |  |  |  | 10 |  |  |  |  |  |  |  | 45
RB |  |  |  | 6
RB
WR
WR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73
WR |  |  |  | 6
WR |  |  |  | 50
TE
D/ST
K
BE
BE
120
Key:
Starter
Our Team
Spreadsheet: 739713d1625871299-counting-unique-values-within-a-date-range-counting-unique-values-within-a-date-range
Sheet: CALC

Commission Event
 | Amount Paid | Appointments | Unique QCN | Start Month | End Month | Amount Paid | Appointments | Unique QCN
2020-10-01 00:00:00 | 150 | 2 | 2 | 2020-10-01 00:00:00 | 2020-10-31 00:00:00
2020-11-01 00:00:00 | 750 | 13 | 7 | 2020-11-01 00:00:00 | 2020-11-30 00:00:00
Spreadsheet: 120005d1314908160-removing-one-or-levels-of-nesting-data-extraction
Sheet: Sheet1

Doc# | Date | Bldg | List - Prob | List - Solv
ASP-1131-01 | 2011-05-11 00:00:00 | ASP | 416 | 416
35D-1172-01 | 2011-06-21 00:00:00 | 5-135D | One | 411
02-1172-01 | 2011-06-21 00:00:00 | 2 | Two | Two
42-1173-01 | 2011-06-22 00:00:00 | 42 | Forty-Two | Forty-Two
35-1104-01 | 2011-04-14 00:00:00 | 5-135 | 411 | 411
42F-1180-01 | 2011-06-29 00:00:00 | 42F | Two | Forty-Two
 |  | #N/A
1 | One
2 | Two
42 | Forty-Two
5-135 | 411
5-136 | 412
5-155 | 410
ASP | 416
Spreadsheet: 124187d1318230191-excel-2007-finding-information-on-a-table-indexmatch-simple
Sheet: Distances (2D table)

from | West Palm Beach |  |  |  |  | 280 |  | option 1 |  | INDEX/MATCH/MATCH
to | Sarasota |  |  |  |  | 280 |  | option 2 |  | VLOOKUP
distance (km) | Clearwater | Daytona Beach | Fort Lauderdale | [NAME] | Key West | Miami Beach | Naples | Orlando | Sarasota | St. Augustine | ST,Petersburg | Tampa | Titusville | Vero Beach | West Palm Beach
Clearwater |  | 260 | 400 | 200 | 635 | 420 | 255 | 170 | 90 | 300 | 35 | 40 | 235 | 250 | 345
Daytona Beach | 260 |  | 400 | 335 | 650 | 405 | 390 | 90 | 290 | 85 | 255 | 225 | 75 | 195 | 300
Fort Lauderdale | 400 | 400 |  | 215 | 285 | 40 | 170 | 335 | 325 | 450 | 375 | 375 | 295 | 180 | 70
[NAME] | 200 | 335 | 215 |  | 435 | 235 | 55 | 245 | 115 | 405 | 180 | 200 | 310 | 220 | 220
Key West | 635 | 650 | 285 | 435 |  | 265 | 380 | 595 | 550 | 730 | 610 | 620 | 575 | 460 | 355
Miami Beach | 420 | 405 | 40 | 235 | 265 |  | 185 | 370 | 345 | 485 | 395 | 395 | 330 | 215 | 105
Naples | 255 | 390 | 170 | 55 | 380 | 185 |  | 300 | 170 | 460 | 230 | 250 | 365 | 270 | 240
Orlando | 170 | 90 | 335 | 245 | 595 | 370 | 300 |  | 205 | 160 | 170 | 140 | 65 | 160 | 30
Sarasota | 90 | 290 | 325 | 115 | 550 | 345 | 170 | 205 |  | 365 | 65 | 85 | 270 | 260 | 280
St. Augustine | 300 | 85 | 450 | 405 | 730 | 485 | 460 | 160 | 365 |  | 320 | 285 | 160 | 275 | 385
St.Petersburg | 35 | 255 | 375 | 180 | 610 | 395 | 230 | 170 | 65 | 320 |  | 35 | 235 | 250 | 320
Tampa | 40 | 225 | 375 | 200 | 620 | 395 | 250 | 140 | 85 | 285 | 35 |  | 200 | 215 | 310
Titusville | 235 | 75 | 295 | 310 | 575 | 330 | 365 | 65 | 270 | 160 | 235 | 200 |  | 120 | 230
Vero Beach | 250 | 195 | 180 | 220 | 460 | 215 | 270 | 160 | 260 | 275 | 250 | 215 | 120 |  | 110
West Palm Beach | 345 | 300 | 70 | 220 | 355 | 105 | 240 | 30 | 280 | 385 | 320 | 310 | 230 | 110
 |  | Thanks to WHER for this sample sheet
Spreadsheet: 151493d1334943014-advanced-lookup-match-and-merge-feature-test
Sheet: U12 Age Group

Color | First Name | Last Name | Team | Shirt  # | Prospect Yes ?
[NAME] | [NAME] | Coffey | [NAME]
[NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | Powers | [NAME]
[NAME] | [NAME] | Locklear | [NAME]
[NAME] | Artem | Brenner | [NAME]
[NAME] | Kristen | Gregorich | [NAME]
[NAME] | [NAME] | Benchoff | [NAME]
[NAME] | Tiara | [NAME] | [NAME]
[NAME] | Lauren | [NAME] | [NAME]
Orange | [NAME] | Shank | Basen
Orange | Domenique | [NAME] | Basen
Orange | [NAME] | Basen | Basen
Orange | [NAME] | [NAME] | Basen
Orange | [NAME] | Day (sib) | Basen
Orange | Dominique | Day (sib) | Basen
Orange | [NAME] | [NAME] | Basen
Orange | Brittney | Segers | Basen
Orange | Katelyn | Leavines | Basen
Royal Blue | [NAME] | Glynn | Lassiter
Royal Blue | Connor | O'Malley | Lassiter
Royal Blue | [NAME] | Sherpan | Lassiter
Royal Blue | [NAME] | Lassiter | Lassiter
Royal Blue | Cayton | Lassiter | Lassiter
Royal Blue | [NAME] | Vicere | Lassiter | 6 | Yes
Royal Blue | [NAME] | Coppola | Lassiter
Royal Blue | Grace | Hummel | Lassiter | 8 | Yes
Royal Blue | [NAME] | O'Conner | Lassiter
Red | Chad | Paulsen | [NAME]
Red | [NAME] | Wheeler | [NAME]
Red | [NAME] | Aleo | [NAME] | 3 | Yes
Red | Trystan | Hanson | [NAME]
Red | [NAME] | DiBrango | [NAME]
Red | Tara | Powers | [NAME]
Red | Kaci | [NAME] | [NAME]
Red | Zareah | Jones | [NAME]
Red | Hailey | Barron | [NAME]
Grey | [NAME] | [NAME] | Polce
Grey | Christian | [NAME] | Polce
Grey | [NAME] | Cortelyou | Polce
Grey | [NAME] | Polce | Polce
Grey | Kayla | Mulford | Polce
Grey | [NAME] | [NAME] | Polce
Grey | Emily | Beazley | Polce
Grey | Emily | Esquinaldo | Polce
Grey | [NAME] | Melgar | Polce
Gold | [NAME] | First | [NAME]
Gold | Collin | Logan | [NAME]
Gold | [NAME] | [NAME] | [NAME]
Gold | [NAME] | [NAME] | [NAME]
Gold | Nick | Carroll | [NAME]
Gold | [NAME] | Reyes | [NAME]
Gold | Emily | Couch | [NAME]
Gold | Selenia | Caban | Polce
Gold | Aliza | Rivera | [NAME]