tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 36ab60e1-4a47-4b07-80c6-55da7fbc85a7
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
QBKU | Test | QBKU | BK Virus, Molecular Detection, Quantitative, PCR, [NAME] | BK Virus PCR, Quant, U | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME]: Urine |  |  | 1 | mL | For optimal results, specimen should arrive within 48 hours of collection.   Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 1 mL Collection Instructions:  1. Collect a random urine specimen. 2. No preservative Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.3 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | None detected | Monday through Saturday; Varies | Same day/1 day | 3 days | 1 | 87799 |  |  |  |  | Rochester
QBKU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
QBKU | Result | 87859 | BK Virus PCR, Quant, U | BK Virus PCR, Quant, U | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41480-5 | BK virus DNA:NCnc:Pt:[NAME]:Qn:Probe.amp.tar
QBKU | Result | 30058 | Copies/mL | Copies/mL | Numeric |  |  |  |  | copies/mL |  |  |  |  |  |  |  |  |  | 48309-9 | BK virus DNA:NCnc:Pt:[NAME]:Qn:Probe.amp.tar
Spreadsheet: 814298d1674264166-look-up-same-requirements-output-different-results-automated-schedule-gk
Sheet: Schedule

What | When | Who
Work | 2023-04-01 00:00:00 | [NAME]
Work | 2023-04-01 00:00:00 | [NAME]
Help | 2023-04-01 00:00:00 | [NAME]
Work | 2023-04-04 00:00:00 | [NAME]
Work | 2023-04-04 00:00:00 | [NAME]
Help | 2023-04-04 00:00:00 | Cameron
Work | 2023-04-07 00:00:00 | [NAME]
Work | 2023-04-07 00:00:00 | Helen
Help | 2023-04-07 00:00:00 | [NAME]
Spreadsheet: 811130d1672302054-hide-row-hide-empty-row
Sheet: Sheet1

No. | Name | Matric No. | Math | Sc | Arts | Eng | Geog | History | Helper
1 | [NAME] | 68751 | 92 | 85 | 78 | 82 | 77 | 74 | PRINT
 | Alexandra | 41803
 | [NAME] | 20636
 | Amanda | 34789
 | Amelia | 76662
 | [NAME] | 26158
 | [NAME] | 95100
 | [NAME] | 21301 | 93 | 86 | 79 | 83 | 78 | 75 | PRINT
 | Anna | 96074
 | Anne | 89705
 | [NAME] | 17900
 | Ava | 90594
 | [NAME] | 13064 | 94 | 87 | 80 | 84 | 79 | 76 | PRINT
 | [NAME] | 12687
 | Carol | 80939
 |  |  | 95 | 88 | 81 | 85 | 80 | 77 | PRINT
 |  |  | 93 | 86 | 79 | 83 | 78 | 75 | PRINT
 |  |  | 94 | 87 | 80 | 84 | 79 | 76 | PRINT
 |  |  | 96 | 89 | 82 | 86 | 81 | 78 | PRINT
 |  |  | 97 | 90 | 83 | 87 | 82 | 79 | PRINT
 |  |  | 98 | 91 | 84 | 88 | 83 | 80 | PRINT
 |  |  | 93 | 86 | 79 | 83 | 78 | 75 | PRINT
 |  |  | 92 | 85 | 78 | 82 | 77 | 74 | PRINT
 |  |  | 91 | 84 | 77 | 81 | 76 | 73 | PRINT
 |  |  | 92 | 85 | 78 | 82 | 77 | 74 | PRINT
 |  |  | 91 | 84 | 77 | 81 | 76 | 73 | PRINT
 |  |  | 92 | 85 | 78 | 82 | 77 | 74 | PRINT
 |  |  | 93 | 86 | 79 | 83 | 78 | 75 | PRINT
 |  |  | 92 | 85 | 78 | 82 | 77 | 74 | PRINT
 |  |  | 91 | 84 | 77 | 81 | 76 | 73 | PRINT
 |  |  | 90 | 83 | 76 | 80 | 75 | 72 | PRINT
 |  |  | 89 | 82 | 75 | 79 | 74 | 71 | PRINT
Spreadsheet: 125961d1319447434-split-large-file-into-several-smaller-xls-files-split-files
Sheet: Sheet1

Row 1 | Row 2 | Row 3 | Row 4 | Row 5 | Row 6 | Row 7 | Row 8 | Row 9 | Row 10
40006549 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006549 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006549 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006549 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006549 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006549 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006550 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006550 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006550 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006550 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006550 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006550 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006550 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006550 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006551 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006551 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006551 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006551 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006551 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006551 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006551 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006552 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006553 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006555 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006555 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006555 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006556 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006565 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006582 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006582 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006583 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006583 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006583 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006583 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006583 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
40006591 | 01 | X | 20120109 | 99991231 | X | 02 | 20120109 | 99991231 | B
Spreadsheet: 149795-extracting-data-from-different-different-cell-to-one-cell-dummy-compiled-sheet
Sheet: Sheet1

individual rating |  |  |  |  |  |  | Master File
Name | Kunal
Skill | Ratings |  |  |  |  |  | Skill | Kunal | [NAME] | [NAME] | Xyz
 | 1 | 2 | 3 | 4 |  |  | a
a |  | 0 |  |  |  |  | b
b |  | 0 |  |  |  |  | c
c |  |  | 0 | 0 |  |  | d
d |  |  |  | 0 |  |  | e
e |  |  |  |  |  |  | f
f | 0 |  |  |  |  |  | g
g |  | 0
Spreadsheet: 883392d1732017776-overview-of-dates-test
Sheet: Overview

WHAT  I WANT TO SEE ON THIS PAGE. This need to be updating everyday automaticly.
Upcomming delivey dates: (today and 3 days ahead) |  |  |  | Exceeded delevery dates that are not marked as recived |  |  |  | Purchases that have no Date for delevry
Vendor | Purchase number | Date for delevry |  | Vendor | Purchase number | Date for delevry |  | Vendor | Purchase number | Date for delevry
[NAME] | 50009 | 2024-11-19 00:00:00 |  | [NAME] | 50005 | 2024-11-17 00:00:00 |  | [NAME] | 50015 | -
[NAME] | 50010 | 2024-11-20 00:00:00 |  |  |  |  |  | [NAME] | 50004 | -
[NAME] | 50012 | 2024-11-21 00:00:00
[NAME] | 50007 | 2024-11-19 00:00:00
[NAME] | 50008 | 2024-11-20 00:00:00
[NAME] | 50014 | 2024-11-21 00:00:00
[NAME] | 50001 | 2024-11-21 00:00:00
Spreadsheet: 699284d1602519486-error-in-autofilling-for-patterned-rows-help-me-pleasee
Sheet: Awal

 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | No | User | Produk |  |  |  |  |  |  |  | User | Produk
 |  |  | Jaket | Kaos | Kemeja | [NAME] | Hoodie | Legging |  |  |  | Jaket | Kaos | Kemeja | [NAME] | Hoodie | Legging
 | 1 | [NAME] | 5 | 3 | 2 |  |  |  |  |  | [NAME] | 5 | 3 | 2
 | 2 | [NAME] | 2 | 2 | 5 | 2 |  |  |  |  | [NAME] | 2 | 2 | 5 | 2
 | 3 | [NAME] | 2 |  |  | 4 | 4 | 5 |  |  | [NAME] | 2 |  |  | 4 | 4 | 5
 | 4 | Damon | 5 |  | 3 | 4 |  |  |  |  | Damon | 5 |  | 3 | 4
 | 5 | [NAME] | 4 | 3 | 2 | 4 | 4 |  |  |  | [NAME] | 4 | 3 | 2 | 4 | 4
Spreadsheet: 33647d1230130909-expense-report-how-to-have-one-row-of-input-to-create-two-rows-of-output-expense-report
Sheet: Answer

 |  |  |  |  |  |  |  |  | Bay |  | Court
Name |  | Description | Amount | Account # |  | Handphone |  |  | 74-000-1505 |  | 26-000-1505
[NAME] | Meals during customer visit | Meals during customer visit,Chicago,Kevin & Carol of Dow | 150 | 74-950-6101 |  | Computer / Notebook |  |  | 74-000-1517 |  | 26-000-1517
[NAME] | Hotel | Hotel,Houston, | 120 | 74-950-6101 |  | Exhibition expenses |  |  | 74-950-6011 |  | 26-950-6011
[NAME] | Computer / Notebook | Computer / Notebook,New York, | 1000 | 74-000-1517 |  | Hotel |  |  | 74-950-6101 |  | 26-950-6101
[NAME] | Handphone | Handphone,Boston, | 30 | 74-000-1505 |  | Meals during customer visit |  |  | 74-950-6101 |  | 26-950-6101
Spreadsheet: 875856d1722496148-how-to-define-multiple-criteria-as-a-variable-in-let-function-survey-data-
Sheet: Sheet1

 | Year |  |  | Very Satisfied | Satisfied | Uncertain | Dissatisfied | Very Dissatisfied
 | 2024 |  | Question 1 |  | 39 | 7 | 4 | 4
 |  |  | Question 2 | 6 | 30 | 15 | 7 | 3
 | Gender |  | Question 3 | 6 | 30 | 18 | 2 | 5
 | Male
 | Departments |  |  | Very Unlikely | Somewhat Unlikely | Neither Likely Nor Unlikely | Somewhat Likely | Very Likely
 | All |  | Question 4 |  | 8 | 15 | 15 | 18
 |  |  | Question 5 | 25 | 14 | 15 | 5 | 2
 | Desingation |  | Question 6 | 10 | 16 | 16 | 15 | 4
 | All
 | Experience
 | All |  | Question 1 |  | 39 | 7 | 4 | 4
 |  |  | Question 2 | 6 | 30 | 15 | 7 | 3
 | Qualification |  | Question 3 | 6 | 30 | 18 | 2 | 5
 | All |  | Question 4 | 5 | 8 | 15 | 15 | 18
 |  |  | Question 5 | 25 | 14 | 15 | 5 | 2
 |  |  | Question 6 | 10 | 16 | 16 | 15 | 4
Spreadsheet: 838968d1691571682-how-to-create-a-dynamic-date-dynamic-date-1-
Sheet: Sheet1

 | The date is automatically update based on the Data in "Table B"
 |  | Table A |  |  |  | Table B
 |  |  |  |  |  | The data in this  table will be copied manually
 |  | Date | Sales |  |  | Date | Receipt | Product | Sales
 |  |  |  |  |  | 2023-01-01 00:00:00 | 1 | iPhone | 980
 |  |  |  |  |  | 2023-01-01 00:00:00 | 1 | Apple Watch | 320
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2 | MacBook | 2200
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | iPad | 950
 |  |  |  |  |  | 2023-01-01 00:00:00 | 3 | Earpod | 40
 |  |  |  |  |  | 2023-01-02 00:00:00 | 4 | Nokia | 150
 |  |  |  |  |  | 2023-01-02 00:00:00 | 4 | Earpod | 30
 |  |  |  |  |  | 2023-01-02 00:00:00 | 5 | iPhone | 850
 |  |  |  |  |  | 2023-01-02 00:00:00 | 6 | iPad | 750
Spreadsheet: 145319d1331530890-sheet-number-to-be-dynamic-in-the-formula-test-
Sheet: 2

 | Date
 | Total Invoices to be Processed
 | Total Invoices Processed
 | Total Pending
 | MTD Invoices Processed
 | Description | [NAME] |  | Assigned to |  | Status |  | Pending
 |  | Imported | Approved | Imported | Approved | Imported | Approved | Imported | Approved
Spreadsheet: 713821d1610961405-how-to-data-from-four-colums-but-list-two-of-them-under-each-other-example
Sheet: Example

date | Test | Test2 | Test3 |  | How I want data to be converted
2021-01-01 00:00:00 | 50 | 1900 | 3000
2021-01-05 00:00:00 | 500 | 1900 | 3000
etc
Spreadsheet: 696517d1600869348-auto-populating-rolling-month-calendar-using-drop-down-lists-calendar-any-month-start
Sheet: DATA

YEAR | MONTH | INSP FREQUENCY WKS | SERVICE FREQUENCY MTHS
2019 | January | 6 | 4
2020 | February | 8 | 6
2021 | March | 10 | 12
2022 | April | 12
2023 | May
2024 | June
2025 | July
2026 | August
2027 | September
2028 | October
2029 | November
2030 | December
Spreadsheet: 129288d1321538803-selecting-price-from-a-chart-forum
Sheet: Arkusz1

[NAME] |  | Price |  | [NAME] | Price
0 | 5 | 0.075 |  | 8
6 | 15 | 0.105
16 | 25 | 0.135
26 | 35 | 0.170
36 | 45 | 0.200
46 | 55 | 0.230
56 | 65 | 0.260
66 | 75 | 0.290
76 | 85 | 0.320
86 | 95 | 0.350
96 | 100 | 0.380
101 |  | 1.050
Spreadsheet: 836180d1689158655-combine-sumifs-index-match-and-date-range-excel-test-indirect-match-blank
Sheet: Summary

 | Annual Pro-Forma: |  | 2015-04-30 00:00:00
 | - Gross Potential Rent:
 | - Turnover Vacancy:
 | - Free Months of Rent:
 | Effective Gross Income:
 | - Property Taxes:
 | - Insurance & Utilities:
 | Operating Expenses:
 | Net Operating Income (NOI):
 | - Capital Expenditures:
 | - TIs & LCs:
 | Capital Costs:
 | Adjusted NOI:
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 102067 | 101181
2 | 100541 | 99669
3 | 113331 | 113022
4 | 75301 | 74820
5 | 74993 | 74822
6 | 77697 | 78322
7 | 83890 | 83066
8 | 85931 | 84822
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 8903
2001-12-08 00:00:00
CBS Volume
 |  |  | -51464
2001-12-04 00:00:00
Spreadsheet: 885585d1735316685-status-summary-on-form-completion-azaccaria-form-semaphore
Sheet: Form

Section | Field | Data
Personal | Name | [NAME]
 | Surname | Lolo
 | Phone | 123
Major | Area | English
 | Date | 2018-12-03 00:00:00
 | Institution
Minor | Area
 | Date
 | Institution
Spreadsheet: 754612d1636377982-calculate-value-till-date-and-update-status-contract-renewal
Sheet: Sheet1

Location Name | Contract Start Date |  |  | Contract Start Date | Contract [NAME] |  |  | Contract [NAME] | Contract Renewal Date |  |  | Contract Renewal Date | Contract Renewal Expiry |  |  | Contract Renewal Expiry | Rent Amount | Notice Period | Rent till today | Notes
 | Day | Month | Year |  | Day | Month | Year |  | Day | Month | Year |  | Day | Month | Year
Location 1 | 1 | 1 | 2021 | 2021-01-01 00:00:00 | 31 | 12 | 2021 | 2021-12-31 00:00:00 | 1 | 1 | 2022 | 2022-01-01 00:00:00 | 31 | 12 | 2022 | 2022-12-31 00:00:00 | 4000 | 2 month
Location 2 | 1 | 1 | 2021 | 2021-01-01 00:00:00 | 31 | 12 | 2022 | 2022-12-31 00:00:00 | 1 | 1 | 2023 | 2023-01-01 00:00:00 | 31 | 12 | 2024 | 2024-12-31 00:00:00 | 4000 | 1 month
Location 3 | 1 | 1 | 2021 | 2021-01-01 00:00:00 | 31 | 12 | 2021 | 2021-12-31 00:00:00 | 1 | 1 | 2022 | 2022-01-01 00:00:00 | 31 | 12 | 2022 | 2022-12-31 00:00:00 | 4000 | 2 month
Location 4 | 1 | 6 | 2020 | 2020-06-01 00:00:00 | 31 | 5 | 2022 | 2022-05-31 00:00:00 | 1 | 6 | 2022 | 2022-06-01 00:00:00 | 31 | 5 | 2024 | 2024-05-30 00:00:00 | 9000 | 3 month
Location 5 | 1 | 6 | 2017 | 2017-06-01 00:00:00 | 31 | 5 | 2022 | 2022-05-31 00:00:00 | 1 | 6 | 2022 | 2022-06-01 00:00:00 | 31 | 5 | 2027 | 2027-05-31 00:00:00 | 3000 | 1 month
Location 6 | 1 | 2 | 2021 | 2021-02-01 00:00:00 | 31 | 1 | 2022 | 2022-01-31 00:00:00 | 1 | 2 | 2022 | 2022-02-01 00:00:00 | 31 | 1 | 2023 | 2023-01-31 00:00:00 | 3000 | 3 month
Location 7 | 1 | 5 | 2020 | 2020-05-01 00:00:00 | 30 | 4 | 2021 | 2021-04-30 00:00:00 | 1 | 5 | 2021 | 2021-05-01 00:00:00 | 30 | 4 | 2022 | 2022-04-30 00:00:00 | 4000 | 2 month
Location 8 | 8 | 2 | 2021 | 2020-02-08 00:00:00 | 7 | 2 | 2022 | 2021-02-07 00:00:00 | 8 | 2 | 2022 | 2021-02-08 00:00:00 | 7 | 2 | 2023 | 2022-02-07 00:00:00 | 3500 | 3 month
Location 9 | 1 | 3 | 2019 | 2019-03-01 00:00:00 | 28 | 2 | 2021 | 2021-02-28 00:00:00 | 1 | 3 | 2021 | 2021-03-01 00:00:00 | 28 | 2 | 2023 | 2023-02-28 00:00:00 | 4000 | 2 month
Spreadsheet: 0062161b-bf47-470d-afc4-c8f145f94b44
Sheet: high_performing

District IRN | District Name | Building IRN | Building Name
048298 | Austintown Local | 021824 | [NAME]
048298 | Austintown Local | 039867 | Watson Elementary School
046854 | Berne Union Local | 002493 | Berne Union Elementary School
046318 | Bethel-Tate Local | 002584 | Bethel-Tate Middle School
046383 | Blanchester Local | 030916 | Putman Elementary School
050096 | Bloomfield-Mespo Local | 002956 | Bloomfield High School
048306 | Boardman Local | 032136 | [NAME]
048793 | Cardington-Lincoln Local | 004879 | Cardington-Lincoln Elementary School
050534 | [NAME] | 015743 | [NAME]
133520 | Citizens Academy | 133520 | Citizens Academy
045328 | [NAME] | 033340 | South Side Middle School
043828 | Coshocton City | 020636 | Lincoln Elementary School
044032 | Gallipolis City | 014332 | Green Elementary School
044065 | Girard City School District | 037366 | Girard Intermediate Middle School
044065 | Girard City School District | 013482 | Girard Sr High School
044065 | Girard City School District | 009159 | Prospect Elementary School
133215 | Intergenerational School, The | 133215 | Intergenerational School, The
048322 | Jackson-Milton Local | 017798 | Jackson-Milton High School
044248 | Logan-Hocking Local | 000387 | Central Elementary School
044248 | Logan-Hocking Local | 065581 | Union Furnace Elementary School
050211 | Maplewood Local | 022657 | Maplewood Middle School
044529 | North Olmsted City | 004424 | Butternut Elementary School
044529 | North Olmsted City | 064105 | Forest Elementary School
048728 | Northmont City | 037754 | Union Elementary School
049924 | [NAME] | 040972 | Whipple Heights Elementary School
046482 | River View Local | 039289 | Warsaw Elementary School
046003 | Shadyside Local | 017913 | Jefferson Ave Elementary School
044776 | Shelby City | 008730 | Dowds Elementary School
050583 | Southeast Local | 016659 | Holmesville Elementary School
048371 | Springfield Local | 026880 | Springfield Elementary School
044826 | Steubenville City | 040246 | Wells Academy
044891 | Tiffin City | 027268 | Noble Elementary School
050302 | Tuscarawas Valley Local | 003129 | Tuscarawas Valley Intermediate
044958 | Vandalia-Butler City | 026005 | Murlin Heights Elementary School
045641 | Wauseon Exempted Village | 010348 | Wauseon Elementary School
045120 | Wooster City | 021766 | [NAME]
045120 | Wooster City | 024166 | [NAME]
045161 | Youngstown City Schools | 000520 | Youngstown Early College
Spreadsheet: 706573d1606776524-compare-tho-columns-and-return-unpaired-cell-contents-book1
Sheet: Sheet1

DATE | plus | minus
1980-05-20 00:00:00 | abc
 | cde
1980-06-22 00:00:00 | fgh
 | ghi | VTRG
1984-06-24 00:00:00 | GHVC | ghi
 |  | cde
1988-07-23 00:00:00 |  | abc
1993-09-30 00:00:00 | abc
 |  |  | total
Spreadsheet: 272047d1382166700-if-cell-has-data-the-look-up-value-example-list
Sheet: Order List

Colour | 1st charm | 1st Letter | 2nd Charm | 2nd Letter | 3rd Charm | 3rd Letter | 3rd Letter | BOX | PILLOW | Price
grey | b'fly | M |  |  |  |  |  | box
aubergine | note | J |  |  |  |  |  | box | pillow
navy | heart | F |  | A |  | K
red | b'fly | M
hot pk | b'fly | N
Spreadsheet: 751618d1634210920-need-a-formula-for-the-column-letter-to-use-in-indirect-ytd-formula-v2
Sheet: Sheet1

 | 5
 |  | 2020-07-31 00:00:00 | 0.01
 |  | 2020-08-31 00:00:00 | 0.01
 |  | 2020-09-30 00:00:00 | 0.01
 |  | 2020-10-31 00:00:00 | 0.01
 |  | 2020-11-30 00:00:00 | 0.01
 |  | 2020-12-31 00:00:00 | 0.01
 |  | 2021-01-31 00:00:00 | 0.01 |  | 0.01
 |  | 2021-02-28 00:00:00 | 0.01 |  | 0.01
 |  | 2021-03-31 00:00:00 | 0.01 |  | 0.01
 |  | 2021-04-30 00:00:00
 |  | 2021-05-31 00:00:00
 |  | 2021-06-30 00:00:00
 |  | 2021-07-31 00:00:00
 |  | 2021-08-31 00:00:00
 |  | 2021-09-30 00:00:00
 |  | 2021-10-31 00:00:00
 |  | 2021-11-30 00:00:00
 |  | 2021-12-31 00:00:00
 |  | 2022-01-31 00:00:00
 |  | 2022-02-28 00:00:00
 |  | 2022-03-31 00:00:00
 |  |  |  |  |  | replaces match row
 |  |  |  |  |  | replaces range number for product formula
 |  |  |  |  |  | replaces the column letter (to count how many months)
 |  |  | beg of year date | 2021-01-31 00:00:00 |  | range needs to start at A1
Spreadsheet: 168539d1342490797-lookup-that-returns-true-value-if-cell-matches-text-in-a-column-test1
Sheet: Sheet2

CSA500000000831
CSA200000000850
CSA300000000042
CSA200000000092
CSA400000000359
CSA300000000862
CSA400000000134
[NAME]
CSA200000000525
CSA900000000247
CSA300000000882
CSA200000000233
CSA400000000875
CSA700000000822
[NAME]
CSA200000001053
CSA400000000428
CSA200000000167
CSA200000000662
CSA700000000406
CSA200000000508
CSA300000000316
CSA400000000627
CSA300000000602
[NAME]
CSA200000000691
[NAME]
CSA200000000186
CSA300000000928
[NAME]
CSA200000000503
CSA500000000299
CSA300000000809
CSA400000000873
CSA200000000896
[NAME]
Spreadsheet: 764135d1642602955-if-statement-to-bring-back-great-or-less-and-apply-rates-excel-
Sheet: master

Employee Number | Hours | Amount | Rate | Sum
525794
526050
526149
524844
525838
525591
522787
525597
525990
525718
522721
525080
521207
520560
526015
525733
522724
522729
524508
524892
525404
525996
525991
525424
525843
524980
525361
525965
522576
525131
522742
526162
526013
525570
526083
522746
526007
522749
525983
524806
523228
525580
522752
525572
520515
521685
524510
525540
525359
525828
525017
524511
526203
525613
525971
136550
525633
525693
522361
522780
524988
525953
524695
523348
524428
523017
525186
525483
525179
525881
521454
524941
521066
524523
524827
525378
521612
523073
202255
524945
526152
525844
522569
521567
520772
524616
525364
521710
525915
525368
526134
524936
526065
522870
526073
525284
526070
525290
526133
526067
526069
522577
526141
525562
522902
513100
526085
524691
525793
524367
525249
525393
526185
526166
167224
524902
524871
524904
524940
525263
526019
525212
522379
525312
524374
525941
525644
525482
522651
161374
207973
505393
509189
521656
522363
522886
523182
524498
525565
525949
525171
526059
521078
525784
525314
524412
521396
523429
525610
523266
525437
522613
524972
Spreadsheet: 267571d1380114479-rank-function-tie-break-rank-tie-break-alphabetical
Sheet: Version 1 with alph.

Rank | Name | Cost |  |  |  | Name | Cost
 | George | 20000 |  |  | 1
 | [NAME] |  |  |  | 2
 | [NAME] | 20000 |  |  | 3
 | [NAME] |  |  |  | 4
 | Helen | 20000 |  |  | 5
 | [NAME] | 20000 |  |  | 6
 | [NAME] | 15000 |  |  | 7
 | Maria |  |  |  | 8
 | [NAME] |  |  |  | 9
 | Rona | 20000 |  |  | 10
Spreadsheet: 54524d1254504918-matching-data-from-different-worksheets-excel-help
Sheet: Sheet1

261 | STABILIZER | New Orleans |  | 106A | PAVER | [NAME]
1030 | GENERATOR | Baton Rouge |  | 358 | EXCAVATOR | Lafayette
106A | PAVER | [NAME] |  | 1041 | LIGHT TOWER | New Orleans
1044 | LIGHT TOWER | Lake Charles |  | 1030 | GENERATOR | Baton Rouge
1041 | LIGHT TOWER | New Orleans |  | 879 | DOZER | Baton Rouge
 |  |  |  | 1044 | LIGHT TOWER | Lake Charles
 |  |  |  | 261 | STABILIZER | New Orleans