tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0218267b-09bc-41d8-9d3f-84ba5bb2db9b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 41. OPERATING LEASE FINANCE COMMITMENTS, By Industry: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2413817T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2413818V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2413819W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2413820F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2413821J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2413823L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2413824R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2413825T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2413826V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2413827W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2413828X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2413829A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413830K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 584e542f-75df-4c44-a6d2-da331a3b1f63
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
NIRU | Test | NIRU | Nickel, Random, [NAME] | Nickel, Random, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 2 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 2 mL Collection Instructions: 1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.9 mL | Hemolysis	NA Thawing	Warm OK;  Cold OK Lipemia	NA Icterus	NA Other	NA | 0.0-6.0 mcg/L  Reference values apply to all ages. | Thursday; 5 p.m. | 1 day | 7 days | 1 | 83885 |  |  |  |  | Rochester
NIRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
NIRU | Result | 60441 | Nickel, Random, U | Nickel, Random, U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 14099-6 | Nickel:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 11d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | 0 | 537 | 0 | 133
Cross-Currency Fixed-Fixed | 0 | 119 | 0 | 75
Cross-Currency Fixed-Float | 0 | 459 | 0 | 399
TOTAL | 0
Spreadsheet: 723025d1615481742-index-match-vs-vlookup-or-is-there-a-better-way-sample_pr
Sheet: MSTR

Job Number: |  |  |  | Certified? |  |  |  | Prevailing Wage?
Job Description:
Customer: |  |  |  | OCIP? |  |  |  | Base Rate:
 |  |  |  |  |  |  |  | Fringe:
Portal: |  |  |  |  |  |  |  | Total Rate:
Notes/Instructions:
Employee First Name | Employee Last Name | Employee Number | Date | Job Number | Job Description | City | State | Earning Code | Hours Amount | Note
Spreadsheet: 33984d1230959987-how-to-do-a-progressive-add-with-an-if-clause-that-is-interrupted-copy-of-scratch2-2-
Sheet: Fresh &Ancilliary

 | Period 5 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total |  | [NAME] | [NAME]
 | week 4 | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan | Actual | Lw Pl Prod | Lw Act Prod
 | Meat Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Meat Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 625 | 595
 | Bakery Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Bakery Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 108 | 117
 | Deli Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Deli Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 152 | 131
 | Food Court Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Food Cout Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 44 | 66
 | Photo Sales | 2259 |  | 2168 |  | 2325 |  | 1707 |  | 3400 |  | 1831 |  | 1995 |  | 15685 | 0 | 100.5448717948718 | 0
 | Photo Hours | 24 |  | 24 |  | 24 |  | 24 |  | 21 |  | 19 |  | 20 |  | 156 | 0 | 71 | 89
 | Opti Sales | 1433 |  | 2355 |  | 4168 |  | 3825 |  | 2355 |  | 1097 |  | 1413 |  | 16646 | 0 | 99.08333333333333 | 0
 | Opti Hours | 32 |  | 24 |  | 32 |  | 32 |  | 16 |  | 16 |  | 16 |  | 168 | 0 | 67 | 57
 | Pharmacy Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Pharmacy Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 42 | 67
 | Hearing Aid Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Hearing Aid Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Gas Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Gas Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | Total Sales | 3692 | 0 | 4523 | 0 | 6493 | 0 | 5532 | 0 | 5755 | 0 | 2928 | 0 | 3408 | 0 | 32331 | 0 | 99.78703703703704 | 0
 | Total hours | 56 | 0 | 48 | 0 | 56 | 0 | 56 | 0 | 37 | 0 | 35 | 0 | 36 | 0 | 324 | 0 | 177 | 177
 |  |  |  |  |  |  |  | 0
 | Tire Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Tire sales units |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Tire Invoices |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | % Install
 | IPMH | 0
Spreadsheet: 793211d1661357468-formula-returning-value-of-each-row-in-col-a-where-value-in-col-j-of-same-row-is-yes-roster-example
Sheet: Sheet1

Roster
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10
Smith, [NAME] |  |  |  |  |  |  |  |  | No
Doe, [NAME] |  |  |  |  |  |  |  |  | Yes
Doe, [NAME] |  |  |  |  |  |  |  |  | Yes
Doe, [NAME] |  |  |  |  |  |  |  |  | Yes
Doe, [NAME] |  |  |  |  |  |  |  |  | No
People With Access:
Doe, [NAME]
Doe, [NAME]
Doe, [NAME]
Spreadsheet: 741606d1627201473-list-of-combinations-how-many-times-a-specific-combination-repeat-the-same-value-book2
Sheet: Sheet1

 | 1 | 2 | 3
Apple | 1 | 0 | 0
[NAME] | 0 | 3 | 2
Grape | 0 | 0 | 0
Output
 | Apple | [NAME] | Grape
Apple
[NAME]
Grape
Spreadsheet: 062d344f-9ce4-42b4-8949-8c4511244c5b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 15b. MERCHANDISE [NAME], State and Australia, Customs Value
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ; |  |  | Original | A1829564W | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Victoria ; |  |  | Original | A1829565X | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Queensland ; |  |  | Original | A1829566A | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
South Australia ; |  |  | Original | A1829567C | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Western Australia ; |  |  | Original | A1829568F | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Tasmania ; |  |  | Original | A1829569J | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Northern Territory ; |  |  | Original | A1829570T | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Australian Capital Territory ; |  |  | Original | A1829571V | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
State not available for publication ; |  |  | Original | A2529326T | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
Total (State of Final Destination) ; |  |  | Original | A1829572W | 1988-01-01 00:00:00 | 2012-07-01 00:00:00 | 295 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 79300d1279570204-formula-returning-div-0-example_1
Sheet: Panel Monthly TTV Macro

TTV by Month
 | January 2009 - Present
 | Ticker | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00
FBC
GNRC | GNRC
KEY
RF
STRI | STRI
SVU
SWY
TCB
VLY
Average
Spreadsheet: 855415d1704985901-need-help-solving-excell-formula-for-leave-plan-leave-plan-admin-shifts-test-3-ms2016test
Sheet: Record

Nr | Comp | Leave SD | Leave ED
Namelist 2016 |  |  |  | ADMIN (exclude weekends and public holidays) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A SHIFT (exc restdays, include weekends and public holidays) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B SHIFT (exc restdays, include weekends and public holidays) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B SHIFT (exc restdays, include weekends and public holidays)
1 | [NAME] | 2024-01-02 00:00:00 | 2024-01-28 00:00:00
2 | a-shift | 2024-01-02 00:00:00 | 2024-01-28 00:00:00
3 | b-shift | 2024-01-02 00:00:00 | 2024-01-28 00:00:00
4 | c-shift | 2024-01-02 00:00:00 | 2024-01-28 00:00:00
5 | d-shift | 2024-01-02 00:00:00 | 2024-01-28 00:00:00
6 | a-mess | 2024-01-02 00:00:00 | 2024-01-28 00:00:00
7 | b-mess | 2024-01-02 00:00:00 | 2024-01-28 00:00:00
1 | [NAME] | 2024-02-01 00:00:00 | 2024-03-04 00:00:00
2 | a-shift | 2024-02-01 00:00:00 | 2024-03-04 00:00:00
3 | b-shift | 2024-02-01 00:00:00 | 2024-03-04 00:00:00
4 | c-shift | 2024-02-01 00:00:00 | 2024-03-04 00:00:00
5 | d-shift | 2024-02-01 00:00:00 | 2024-03-04 00:00:00
6 | a-mess | 2024-02-01 00:00:00 | 2024-03-04 00:00:00
7 | b-mess | 2024-02-01 00:00:00 | 2024-03-04 00:00:00
Spreadsheet: 826550d1682077948-map-a-table-kg-to-g-map-kg-to-g
Sheet: convert

 |  |  |  |  |  |  | expected result
Al-100 | 0.025 | [NAME] |  |  |  |  |  | g
Al-100 | 1 | [NAME] |  |  |  |  |  | g
[NAME] | 0.025 | [NAME] |  |  |  |  |  | g
[NAME] | 0.5 | [NAME] |  |  |  |  |  | g
[NAME] | 1 | L |  |  |  |  |  | mL
Al-102 | 0.025 | [NAME] |  |  |  |  |  | g
Al-102 | 1 | [NAME] |  |  |  |  |  | g
Al-103 | 0.025 | [NAME] |  |  |  |  |  | g
Al-103 | 1 | g |  |  |  |  | 1 | g
Al-104 | 1 | [NAME] |  |  |  |  |  | g
Al-105 | 25 | [NAME] |  |  |  |  |  | g
[NAME] | 25 | [NAME] |  |  |  |  |  | g
Al-111 | 1 | [NAME] |  |  |  |  |  | g
Al-112 | 1 | L |  |  |  |  |  | g
Al-113 | 1 | g |  |  |  |  | 1 | g
Al-113 | 500 | g |  |  |  |  | 500 | g
AA7075-100 | 1 | [NAME] |  |  |  |  |  | g
Spreadsheet: 141456d1329281282-excel-2008-inserting-and-deleting-rows-in-a-multy-sheet-workbook-test-2
Sheet: B of Q

 |  | [NAME] OF QUANTITIES
 |  | Project:
 |  | Date:
 |  | Client:
 |  | TOTAL EXCLUDING GST:
No. | Item | Unit | Qty | Rate | Total
Column1 | Column2 | Column3 | Column4 | Column5
 | SECTIONS
 | CEILINGS - LININGS & PARTITIONS - CARPENTRY
 | *NOTE -
Spreadsheet: 69eee95f-3207-42bb-962a-74513bbc99d3
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0013348 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Bay River MSD  - Arapahoe | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | [NAME] | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 01 |  | Field Name: |  | 02 |  | Field Name: |  | 03 |  | Field Name: |  | 04
 |  |  |  |  |  | Area (acres): |  | 11.73 |  | Area (acres): |  | 10.27 |  | Area (acres): |  | 15.24 |  | Area (acres): |  | 10.42
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5
 |  |  |  |  |  | Annual Rate (in): |  | 68.3 |  | Annual Rate (in): |  | 68.3 |  | Annual Rate (in): |  | 68.3 |  | Annual Rate (in): |  | 68.3
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 875664d1722275281-formula-that-will-search-column-a-for-specific-name-before-calculating-sched-ks-07292024
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | Client | [NAME] Per Hour | Avg Per Day ([NAME] N1)
 |  |  |  |  |  |  |  |  |  |  | BASS | 45
 |  |  |  |  |  |  |  |  |  |  | CALE | 45
 |  |  |  |  |  |  |  |  |  |  | DELE | 25
 |  |  |  |  |  |  |  |  |  |  | GIAB | 25
 |  |  |  |  |  |  |  |  |  |  | GGPM | 25
 |  |  |  |  |  |  |  |  |  |  | HHGJ | 33
 |  |  |  |  |  |  |  |  |  |  | HHGL | 40
 |  |  |  |  |  |  |  |  |  |  | RACT | 25
 |  |  |  |  |  |  |  |  |  |  | LLBE | 25
 |  |  |  |  |  |  |  |  |  |  | NAC | 30
 |  |  |  |  |  |  |  |  |  |  | SAVE | 40
 |  |  |  |  |  |  |  |  |  |  | HALL | 40
 |  |  |  |  |  |  |  |  |  |  | BLST | 30
 |  |  |  |  |  |  |  |  |  |  | KNST | 45
 |  |  |  |  |  |  |  |  |  |  | TOFA | 25
 |  |  |  |  |  |  |  |  |  |  | SUNR | 25
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 25
 |  |  |  |  |  |  |  |  |  |  | CASY | 25
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] per day
Spreadsheet: 119530d1314512393-no-in-age-range-if-age-in-years-and-months-countagey-and-m
Sheet: Sheet1

Date1 | Date of birth | Age at Date1 | (Helper cell) AGE | Group
2011-07-05 00:00:00 | 1991-02-12 00:00:00 |  |  | 1
2011-07-05 00:00:00 | 1996-02-18 00:00:00 |  |  | 1
2011-08-12 00:00:00 | 2005-07-04 00:00:00 |  |  | 2
2011-07-02 00:00:00 | 2003-08-09 00:00:00 |  |  | 1
2011-01-11 00:00:00 | 2010-08-25 00:00:00 |  |  | 3
2011-05-28 00:00:00 | 2001-01-22 00:00:00 |  |  | 2
2011-11-03 00:00:00 | 2000-12-22 00:00:00 |  |  | 3
2011-07-05 00:00:00 | 1993-02-12 00:00:00 |  |  | 1
 |  |  |  | No. in group 1 aged 4y 0m or more but less than 18y 0m
Spreadsheet: 678488d1589911664-trying-to-make-a-value-change-according-to-the-date-route-card-calculator-mk2
Sheet: RC Page 1

 | Leg | Grid From (x) | Grid From (y) | Grid To (x) | Grid To (y) | Column1 | Column2 | Grid (Ꝋ) | [NAME] (Ꝋ) | Back (Ꝋ) | Dist. (m) | Paces | Time (m.s) | Description
 |  | 8800 | 500 | 8950 | 615
 |  |  |  | 8961 | 630
Spreadsheet: 765610d1643413011-conditional-formatting-with-a-difference-copy-of-sample
Sheet: Sheet1

Q1 2022
 |  | Volume
 |  | Renewed Value
 | 0.5 | 0.55 | 0.6 | 0.7 | Volume
0.6 | 250 | 300 | 500 | 600
0.7 | 300 | 500 | 600 | 750
0.8 | 500 | 600 | 750 | 850
0.9 | 600 | 750 | 850 | 1000
Value QTR
Renewal in QTR |  |  | Available | 4 | Volume
Business Name | Value renewed |  |  | 25000 | Value
abc corp | 10800
cde company | 6120
Spreadsheet: 349399d1412303509-set-a-name-to-specific-dates-test-1
Sheet: Sheet1

Client Inspection | Inspector |  |  | Start | End | Start | End
2014-10-02 00:00:00 |  |  | Inspectors | Vacation Wk1 |  | Vacation Wk2
2014-10-07 00:00:00 |  |  | Mark | 2014-10-06 00:00:00 | 2014-10-10 00:00:00 | 2014-10-20 00:00:00 | 2014-10-24 00:00:00
2014-10-07 00:00:00 |  |  | [NAME]
2014-10-10 00:00:00
2014-10-13 00:00:00 |  |  | Basically when "[NAME]" is on vacation the cell (Collumn B) needs to read "Allen"
2014-10-20 00:00:00
2014-10-24 00:00:00
2014-10-29 00:00:00
2014-10-31 00:00:00
2014-10-31 00:00:00
2014-11-03 00:00:00
2014-11-10 00:00:00
2014-11-12 00:00:00
2014-11-17 00:00:00
2014-11-17 00:00:00
2014-11-17 00:00:00
2014-11-26 00:00:00
2014-11-28 00:00:00
Spreadsheet: 145106d1331308846-vba-code-to-format-scatter-markers-book1
Sheet: Sheet1

 |  |  |  | Sales Data
 |  | Criteria 1 | [NAME] | Jan | Feb | March | April | May | June
 |  | A | 1 | 487641.0987758 | 726579.8644341502 | 545982.3015936989 | 388066.1929724694 | 66894.42964286663 | 122611.2253671676
 |  | B | 1 | 311500.7453110508 | 626218.1112753113 | 350753.6156421453 | 569586.4942623284 | 577266.4819293816 | 967727.959337934
 |  | C | 3 | 72639.83824570008 | 259711.5835997519 | 159008.3954761514 | 414667.7658829363 | 844981.8600102903 | 889394.5631168059
 |  | D | 4 | 229053.2039781708 | 341722.0405206676 | 294933.2743042696 | 46457.76937318579 | 598851.6737065266 | 268004.4222551219
 |  | B | 5 | 709469.8460259811 | 644016.0488810171 | 784231.6625918109 | 148222.7775516442 | 892970.7479915044 | 12252.94210754146
 |  | B | 1 | 465925.8313593089 | 694118.020797033 | 173459.7278785834 | 129455.6641821396 | 587862.0328947399 | 941431.0255607958
 |  | T | 8 | 953480.6201780895 | 859388.4729104153 | 529001.7457125302 | 182167.4837026872 | 562659.5225595881 | 190652.9279954183
 |  | Z | 1 | 609971.684233348 | 760341.4035949007 | 574330.3921029029 | 595708.8829210174 | 555556.4855777293 | 571841.3790744139
 |  | U | 5 | 167985.1402226049 | 531673.5026801673 | 20583.51331022345 | 687646.2441397768 | 102170.3587416916 | 191018.7303384543
 |  |  |  | 4007668.008330054 | 5443769.048693415 | 3432284.628612316 | 3161979.274988185 | 4789213.593054318 | 4154935.175153653
 |  | Problem | Using SUMPRODUCT, please calculate sales for January to june with following conditions:
 |  |  | Criteria 1 | B
 |  |  | [NAME] | 1
Spreadsheet: 69482d1270024426-list-all-duplicate-triplicate-etc-values-from-set-of-cells-forum10
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2 or more | 3 or more
Calgary |  | Edmonton |  | Toronto |  |  | Calgary | Calgary
Edmonton |  | Calgary |  | Edmonton |  |  | Edmonton | Edmonton | Edmonton
Vancouver |  | Quebec City |  | Quebec City |  |  | Toronto
Winnipeg |  | Montreal |  | Saskatoon |  |  | Vancouver
Saskatoon |  | Saskatoon |  | Saskatoon |  |  | Quebec City | Quebec City
 |  |  |  |  |  |  | Winnipeg
 |  |  |  |  |  |  | Montreal
 |  |  |  |  |  |  | Saskatoon | Saskatoon | Saskatoon
 |  |  |  |  |  |  | or perhaps
 |  |  |  |  |  |  |  | 2 or more | 3 or more
 |  |  |  |  |  |  | Calgary | X
 |  |  |  |  |  |  | Edmonton | X | X
 |  |  |  |  |  |  | Toronto
 |  |  |  |  |  |  | Vancouver
 |  |  |  |  |  |  | Quebec City | X
 |  |  |  |  |  |  | Winnipeg
 |  |  |  |  |  |  | Montreal
 |  |  |  |  |  |  | Saskatoon | X | X
Spreadsheet: 110656d1307274624-using-if-and-with-arrays-copy-of-testbook
Sheet: DATA

ITEM | USER | DATE | other [NAME] | other data2 | other [NAME] | other data4 | other data5 | other data6 | other data7 | STOCK
Shampoo | [NAME] | 2011-05-24 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 1
Shampoo | Louis | 2011-05-23 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 3
Shampoo | Louis | 2011-05-27 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 2
Shampoo | Louis | 2011-05-29 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 4
Shampoo | Louis | 2011-05-31 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 1
Shampoo | Louis | 2011-06-02 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 5
Shampoo | Stewie | 2011-05-27 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 2
Shampoo | Stewie | 2011-05-29 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 3
Shampoo | Stewie | 2011-05-31 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 1
Shampoo | Meg | 2011-05-23 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 3
Shampoo | Meg | 2011-05-27 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 2
Shampoo | Meg | 2011-05-29 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 1
Shampoo | Meg | 2011-06-05 00:00:00 | other data | other data | other data | other data | other data | other data | other data | 1
Spreadsheet: 468516d1467321351-sports-league-standings-and-schedule-cotsports
Sheet: Sheet3

Match | Home | Hscore | Ascore | Away |  | Rank | Player | P | W | D | L | F | A | [NAME] | Pts | points deducted | Tie Breaker |  |  |  |  | Player | P | W | D | L | F | A | [NAME] | Pts | points deducted
1 | C | 1 | 3 | D |  |  | A |  |  |  |  |  |  |  |  |  |  | 3 | pts |  | 1
2 | C | 2 | 2 | A |  |  | B |  |  |  |  |  |  |  |  |  |  | 1 | pts |  | 2
3 | C | 3 | 1 | B |  |  | C |  |  |  |  |  |  |  |  |  |  | 0 | pts |  | 3
4 | D | 4 | 4 | A |  |  | D |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
5 | D | 3 | 1 | B |  |  | e |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
6 | D | 2 | 2 | C |  |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
7 | A | 1 | 3 | D |  |  | g |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
8 | A |  |  | B |  |  | h |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
9 | A | 3 | 1 | C |  |  | i |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
10 | B | 4 | 2 | D |  |  | j |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 | B | 3 | 4 | A
12 | B | 2 | 5 | C
13