tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883326d1731938275-how-to-highlight-days-and-calculate-working-days-based-on-certain-conditions-tracker2-1-
Sheet: November

Holidays |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekend Shift | A |  |  |  |  | LEGEND
Date | Holiday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  | P
2024-11-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LL
2024-11-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Night Shift |  |  |  |  |  | WFH
2024-11-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT
2024-11-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUARTER |  | MONTH |  |  |  | YEAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ML
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q1 |  | NOVEMBER |  |  |  | 2024 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HL
EMPLOYEE ID | EMPLOYEE NAME | DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS |  |  |  |  |  |  |  | PERCENTAGE
 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Working Days | P | LL | WFH | OT | PL | UL | HL | Total Leave | P % | LL % | WFH %
 | A | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P
 | B | PL |  |  | PL | PL | PL | PL | PL
 | C | WFH |  |  | WFH | WFH | WFH | WFH | WFH |  |  | WFH | WFH | WFH | WFH | WFH |  |  | WFH | WFH | WFH | WFH | WFH |  |  | WFH | WFH | WFH | WFH | WFH
 |  | WFH |  |  | P | P | P | P | P
 |  | WFH |  |  | PL | LL | LL | UL | P
 |  | WFH |  |  | PL | PL | PL | PL | PL
 |  | PL |  |  | P | LL | P | P | P
 |  | WFH |  |  | P | P | P | P | P
 |  | WFH |  |  | ML | ML |  |  | P
NOTES
Spreadsheet: 822716d1679497760-excel-rent-analysis-for-multiple-lease-with-varying-start-date-end-dates-escalation-date-rent-analysis-sample
Sheet: New Agreements Export

Barcode | New Agreement? | In the LRF? | Profit Center | Agreement Number | Contract | Rental Object | GL Account | Description | [NAME] | [NAME] | Start Date | End Date | Escalation Date | Annual Escalation Rate | Annual Rent | 2023 Budget | Rent Schedule
 | Yes | Yes | A03132 - Building # 141 - Multi-Tenant | AYE450 | [NAME] of a portion of space in Building 141 | 141R0601~~JFK141~~JFK - Global Bus and Fleet Services, Inc.- Rent | 400-559 - UNCLASSIFIED TENANTS | Global Bus and Fleet Services, Inc.- Rent | United | 50203 | 1998-02-27 00:00:00 | 2027-02-27 00:00:00 | 1999-01-01 00:00:00 | 0.03 | 500 | 495.94 | Annual
Spreadsheet: 487732d1478210416-stopping-360days-count-when-adding-date-in-another-cell-360days-problem
Sheet: Sheet1

Invoice Submission & Tracking Log
Service | Client | Start Date | End date | Submission Date | Total Amount | Net 30 | Total invoiced | Date Paid | Invoice number
Example | Example | 2016-08-23 00:00:00 | 2016-08-27 00:00:00 | 2016-09-21 00:00:00 | 1687.5 |  |  | 2016-10-25 00:00:00 | 1
 |  | 2016-09-06 00:00:00 | 2016-09-07 00:00:00 | 2016-09-21 00:00:00 | 693 |  |  | 2016-11-03 00:00:00 | 2
 |  | 2016-09-06 00:00:00 | 2016-09-10 00:00:00 | 2016-09-21 00:00:00 | 1687.5 |  |  |  | 3
 |  | 2016-09-21 00:00:00 | 2016-09-24 00:00:00 | 2016-09-26 00:00:00 | 1350 |  |  |  | 4
 |  | 2016-09-14 00:00:00 | 2016-09-27 00:00:00 | 2016-09-29 00:00:00 | 4504.5 |  |  | 2016-11-03 00:00:00 | 5
 |  | 2016-10-06 00:00:00 | 2016-10-15 00:00:00 | 2016-10-21 00:00:00 | 3600 |  |  |  | 6
 |  |  |  |  |  |  |  | Stop count in H when date is entered in cell I
Spreadsheet: 042a914b-c16d-4ee8-9ff8-d1e05bc78454
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Figure 2.1.9 – Annual share and percentage variation of the Veneto’s reimports to the main geographic areas - 2006 (*)
 | (*) provisional data
 | (*) provisional data
 | Source: processing by [NAME] SISTAR on Istat data
 | Annual share and percentage variation of the Veneto’s reimports to the main geographic areas - 2006 (*)
 |  | Share 2006 | percentage var.
 | Eastern Europe | 47.47141649954398 | 9.077298136453274
 | EU25 | 42.49464990766894 | 22.58213669649108
 | North Africa | 5.708939415902099 | -3.765361822639199
 | East Asia | 2.465792982785482 | 41.32631987041282
 | Central Asia | 0.9759208853311605 | -84.35540114803773
 | Rest of the world | 0.8832803087683407 | 22.26307181404726
 | World | 100 | 7.729904211619449
 | Source: processing by [NAME] SISTAR on Istat data
Spreadsheet: 89454d1289248146-accounting-for-when-a-cell-is-blank-and-avoid-it-book2-1
Sheet: Sheet1

 |  | Weight (g)
Sample | Pan | Pan and | First |  | Result | Second
Number | Number | Sample | Drying | Pan | % | Drying
 | 1 | 10 | 9 | 1 | 83.33333333333334 | 8.5
 | 2 | 10 | 9 | 1 | 88.88888888888889 | 9.5
 | 3 | 10 | 9 | 1 | 88.77777777777777 | 8.99
 | 4 | 10 | 9 | 1 | 88.88888888888889
 | 5
Spreadsheet: 741685d1627277145-how-to-countif-formulas-with-time-example
Sheet: GL - ARENA FLOOR

EVENT ID |  |  |  |  |  |  | 1 day, 0:00:00
EVENT
EVENT DATE
EXTERNAL DOORS
INTERNAL DOORS
SHOW START TIME
APPROX END TIME
EVENT AREA | GROUND LEVEL, ARENA FLOOR
EVENT VENUE | ARENA
 |  |  | Roster |  |  | Actual
NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
 | Supervisor [NAME] | Bowl Supervisor - AREA WARDEN
Total
 |  |  | Roster |  |  | Actual
NAME | POSITION | POSITION | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
 | Usher - Warden | [NAME]
 | Usher - Warden | [NAME]
 | Usher | Floor Section - Position 1 / Redeploy to Aisle Stairs
 | Usher | Floor Section - Position 2 / Redeploy to Aisle Stairs
 | Usher | Floor Section - Position 3 / Redeploy to Aisle Stairs
 | Usher | Floor Section - Position 4 / Redeploy to Aisle Stairs
 | Usher | Floor Section - Position 5 / Redeploy to Aisle Stairs
 | Usher | Floor Section - Position 6 / Redeploy to Aisle Stairs
Total
Authorized by:
Name: |  |  | Date:               /                /
Position: | Event Manager
Spreadsheet: 35098d1232618212-copying-hyperlinks-december-2008-excel-forum
Sheet: Month(a)

Income |  |  |  |  |  |  | Month(a)
1st - 31st of December 2008
Name of company | Money X | Money Y | Total
[NAME] | 0 | 0 | 0 |  |  | [NAME] | A6 | C11 | D11 | E11
Вагриус книги | 0 | 0 | 0 |  |  | Вагриус книги | A22 | C27 | D27 | E27
Вагриус правда | 0 | 0 | 0 |  |  | Вагриус правда | A38 | C43 | D43 | E43
Вагриус минус | 0 | 0 | 0 |  |  | Вагриус минус | [NAME] | C59 | D59 | E59
Плюс-минус | 0 | 0 | 0 |  |  | Плюс-минус | A70 | C75 | D75 | E75
Издательство Вагриус | 0 | 0 | 0 |  |  | Издательство Вагриус | A86 | C91 | D91 | E91
Вагриус плюс-минус | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A102 | C107 | D107 | E107
Общий Итог: | 0 | 0 | 0 |  |  |  |  | C109 | D109 | E109
 |  |  |  |  |  | [NAME] | A124 | C129 | D129 | E129
 |  |  |  |  |  | Вагриус книги | A140 | C145 | D145 | E145
 |  |  |  |  |  | Вагриус правда | A156 | C161 | D161 | E161
Expenditure |  |  |  |  |  | Вагриус минус | A172 | C177 | D177 | E177
1st - 31st of December 2008 |  |  |  |  |  | Плюс-минус | A188 | C193 | D193 | E193
Name of company | Money X | Money Y | Total |  |  | Издательство Вагриус | A204 | C209 | D209 | E209
[NAME] | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A220 | C225 | D225 | E225
Вагриус книги | 0 | 0 | 0 |  |  |  |  | C227 | D227 | E227
Вагриус правда | 0 | 0 | 0
Вагриус минус | 0 | 0 | 0
Плюс-минус | 0 | 0 | 0
Издательство Вагриус | 0 | 0 | 0
Вагриус плюс-минус | 0 | 0 | 0 |  |  | Alright, I am on to the next step: the montly overview. I tried applying your weekly formulas, but I couldn't figure it out. What do you think?  Again, thank you so much for the help!
Общий Итог: | 0 | 0 | 0
Spreadsheet: 836037d1689062521-extract-data-based-on-two-dates-sample-15-
Sheet: CT

start | 2023-01-01 00:00:00
end | 2023-12-31 00:00:00
S/N | Customer | Name | Due date
Spreadsheet: 687971d1595511816-return-sheet-name-when-value-is-found-on-that-sheet-students-example
Sheet: Samenvatting

 |  |  |  |  |  |  |  |  |  |  |  |  | Vandaag |  |  |  |  |  |  | IF(IFERROR(HLOOKUP(O2;Alex!$2:$2;1;FALSE);"")=O2;"Alex";"")&" " &
 |  |  |  |  |  |  |  |  |  |  |  |  | Morgen |  |  |  |  |  |  | if(hlookup(O3;
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | indirect(Database!$A1&"!E24")
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COUNTIF(INDIRECT("'"&sheetname&"'!"&"Database!A:A");criteria)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 5 | 6 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
Spreadsheet: 215848d1361514334-find-a-value-in-the-first-column-return-first-non-zero-value-in-another-column-owumi
Sheet: Requested data

 | Person | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007
 | 1 | 0 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 8 | 8 | 3 | 3 | 3 | 3
 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 1 | 1 | 4
Spreadsheet: 864358d1711557799-the-solution-for-displaying-several-different-descriptions-and-codes-of-the-same-part-numb-test-ordera
Sheet: Artikli PN

Aigo šifra | Opis u NAV | Opis 2 | Opis [NAME] | Proizvođačev br. [NAME]
7100670 | 40X8421 Lexmark MKIT 200K | [NAME] | 40X8421 LEXMARK MKIT 200K | 40X8421
8500654 | RD 40X8421 Kmplt za odr. MS81x |  | RD 40X8421 KMPLT ZA ODR. MS81X | 40X8421
7100945 | 40X9136 Lexmark MKIT 200K | za [NAME], [NAME], MX510, MX610 |  | 40X9136
8500662 | RD 40X9136 Grejna jedin. [NAME] |  | RD 40X9136 GREJNA JEDIN. [NAME] | 40X9136
8500244 | RD SEP. ROLLER CANON IR3225N |  | RD SEP. ROLLER CANON IR3225N | FC6-6661-000
8504529 | [NAME] Roller 4570 |  | [NAME] ROLLER 4570 | FC6-6661-000
Spreadsheet: c533e462-7e6f-4718-9efa-b49b1eb9356f
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
PINS | Test | PINS | Proinsulin, Plasma | Proinsulin, P | Immunochemiluminescent Assay | EDTA (lavender-top) tube: EDTA |  |  | 1.5 | mL | Collection Container/Tube: Ice-cooled, lavender top (EDTA) Submission Container/Tube: Plastic vial [NAME]: 1.5 mL Collection Instructions: 1. Fasting 2. After draw, chill the whole blood on ice for at least 10 minutes, then spin down in a refrigerated centrifuge. | 0.65 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK <8 hours; Cold OK <14 days-refreeze-note to lab Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 3-20 pmol/L | Monday, Thursday; 10 a.m. | 2 days | 7 days | 1 | 84206 |  |  |  |  | Rochester
PINS | [NAME] | PLEDTA | [NAME] |  |  |  | Frozen | 14 days
PINS | Result | 80908 | Proinsulin, P | Proinsulin, P | Numeric |  |  |  |  | pmol/L |  |  |  |  |  |  |  |  |  | 27882-0 | Proinsulin:SCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 693298d1598904068-returning-row-names-for-multiple-largest-values-top3months
Sheet: Sheet1

2020-08-21 00:00:00 | 2020-08-27 00:00:00 | 500
2020-08-25 00:00:00 | 2020-08-27 00:00:00 | 300
Date | Average
2020-08-21 00:00:00 | 100
2020-08-24 00:00:00 | 100
2020-08-25 00:00:00 | 200
2020-08-26 00:00:00 | 200
2020-08-27 00:00:00 | 200
Spreadsheet: 66057d1266711117-calculate-number-of-business-days-between-two-dates-and-allocate-them-across-week-end-to-solve
Sheet: Sheet2

Task Start Date | Task Due Date |  | 2010-02-05 00:00:00 | 2010-02-12 00:00:00 | 2010-02-19 00:00:00 | 2010-02-26 00:00:00 | 2010-03-05 00:00:00 | 2010-03-12 00:00:00 | 2010-03-19 00:00:00 | 2010-03-26 00:00:00 | 2010-04-02 00:00:00 | 2010-04-09 00:00:00 | 2010-04-16 00:00:00 | 2010-04-23 00:00:00 | 2010-04-30 00:00:00 | 2010-05-07 00:00:00 | 2010-05-14 00:00:00 | 2010-05-21 00:00:00 | 2010-05-28 00:00:00 | 2010-06-04 00:00:00 | 2010-06-11 00:00:00 | 2010-06-18 00:00:00 | 2010-06-25 00:00:00 | 2010-07-02 00:00:00 | 2010-07-03 00:00:00
2010-02-01 00:00:00 | 2010-02-10 00:00:00 |  | 5 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-02-11 00:00:00 | 2010-03-10 00:00:00
2010-02-11 00:00:00 | 2010-03-10 00:00:00
2010-03-11 00:00:00 | 2010-03-17 00:00:00
2010-03-11 00:00:00 | 2010-03-17 00:00:00
2010-03-11 00:00:00 | 2010-03-17 00:00:00
2010-03-11 00:00:00 | 2010-03-17 00:00:00
2010-03-11 00:00:00 | 2010-03-17 00:00:00
 |  |  | Above Red Need to be Autocalculated. [NAME] needs to be in all cells from range d2:z9
Spreadsheet: 288d45ff-ec41-4cac-a024-fa2f4c3b3ae3
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
STEM | Test | STEM | Stemphyllium, IgE | Stemphyllium, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
STEM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
STEM | Result | STEM | Stemphyllium, IgE | Stemphyllium, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6252-1
Spreadsheet: 796866d1663604330-look-up-based-on-multiple-criteria-end-date
Sheet: Source

Company code | Contract | Company Code + Contract | Row valid until | Probable End Date | Absolute End Date
0010 | 15225 |  | 2021-08-31 00:00:00 | 2026-01-31 00:00:00 | 2036-01-31 00:00:00
0010 | 15225 |  | 2022-06-30 00:00:00 | 2026-01-31 00:00:00 | 2036-01-31 00:00:00
0010 | 15225 |  | 9999-12-31 00:00:00 | 2029-01-31 00:00:00 | 2036-01-31 00:00:00
0010 | 13656 |  | 2021-07-31 00:00:00 | 2028-01-31 00:00:00 | 2025-01-31 00:00:00
0010 | 13656 |  | 2020-06-30 00:00:00 | 2026-01-31 00:00:00 | 2025-01-31 00:00:00
0010 | 13656 |  | 2022-06-30 00:00:00 | 2030-01-31 00:00:00 | 2025-01-31 00:00:00
0010 | 13656 |  | 9999-12-31 00:00:00 | 2030-01-31 00:00:00 | 2025-01-31 00:00:00
0010 | 87134 |  | 2020-12-31 00:00:00 |  | 2025-01-31 00:00:00
0010 | 87134 |  | 2021-08-31 00:00:00 |  | 2025-01-31 00:00:00
0010 | 87134 |  | 2021-12-31 00:00:00 |  | 2027-01-31 00:00:00
0010 | 87134 |  | 9999-12-31 00:00:00 |  | 2028-01-31 00:00:00
Spreadsheet: 852697d1702648831-search-entire-workbook-and-display-results-search-jacc
Sheet: Search

 |  |  |  | Search box |  |  |  |  | https://www.excelforum.com/excel-general/1416643-search-entire-workbook-and-display-results.html
 |  |  |  | mx
 |  |  |  | Customer A Part No. | Customer B Part No. | Customer C Part No.
 |  |  | AA002MX | A002F | AA-002-F | A2MX
 |  |  | AA003MX | A003F | AA-003-F | A3MX
 |  |  | [NAME] | A004F | AA-004-F | A4MX
 |  |  | AA005MX | A005F | AA-005-F | A5MX
 |  |  | BB001MX | B001F | BB-001-F | [NAME]
 |  |  | BB002MX | B002F | BB-002-F | B2MX
 |  |  | BB003MX | B003F | BB-003-F | [NAME]
 |  |  | BB004MX | B004F | BB-004-F | B4MX
 |  |  | BB005MX | B005F | BB-005-F | B5MX
 |  |  | CC001MX | C001F | CC-001-F | C1MX
 |  |  | CC002MX | C002F | CC-002-F | C2MX
 |  |  | [NAME] | C003F | CC-003-F | [NAME]
 |  |  | CC004MX | C004F | CC-004-F | C4MX
 |  |  | CC005MX | C005F | CC-005-F | C5MX
Spreadsheet: 745311d1629848097-using-vlookup-across-two-sheets-with-multiple-matches-sheet-1
Sheet: Sheet1

Product Code | [NAME] | Barcode | Cost
1 | sock | 5678
1 | sock | 5679
1 | sock | 5680
2 | Tee | 5681
2 | Tee | 5682
1 | sock | 5683
3 | shoe | 5684
3 | shoe | 5685
3 | shoe | 5686
Spreadsheet: 819677d1677627318-help-with-complicated-formula-cant-figure-out-why-it-works-so-inconsistently-testing
Sheet: Matrika

 |  |  |  |  | [NAME]
 | Nastavi datum |  | 5 | 2022 | T | fee
 | EUR
 | 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
 | 32
 |  |  |  |  | <-- ta stolpec bi lahko dobil [NAME] z lsit 1 brez umesnih korakov, če bo trokiralo popravi
Spreadsheet: 853222d1703120727-fill-items-price-according-to-the-unit-selected-in-the-invoice-items-unit
Sheet: Sheet1

The Bill |  |  |  |  |  |  | The Stores
# | Item | Unit | Prince |  |  |  | Item Name | Rate | Unit | Unit 1 Price | Rate 2 | Unite 2 | Unit 2 Price | Rate 3 | Unit3 | Unit 3 Price
1 | Item 1 | pcs |  |  |  |  | Item 1 | 1 | pcs | 9 | 6 | [NAME] | 60 | 12 | dozen | 100
2 | Item 2 | pcs |  |  |  |  | Item 2 | 1 | pcs | 4 | 6 | [NAME] | 40 | 12 | dozen | 120
3 | Item 3 | [NAME] |  |  |  |  | Item 3 | 1 | pcs | 5 | 6 | [NAME] | 50 | 12 | dozen | 130
4 | Item 4 | [NAME] |  |  |  |  | Item 4 | 1 | pcs | 3 | 6 | [NAME] | 30 | 12 | dozen | 140
5 | Item 5 | pcs |  |  |  |  | Item 5 | 1 | pcs | 5 | 6 | [NAME] | 40 | 12 | dozen | 130
6 | Item 6 | [NAME] |  |  |  |  | Item 6 | 1 | pcs | 9 | 6 | [NAME] | 90 | 12 | dozen | 120
7 | Item 7 | dozen |  |  |  |  | Item 7 | 1 | pcs | 1 | 6 | [NAME] | 51 | 12 | dozen | 90
Spreadsheet: 857549d1706548886-trend-last-4-values-of-a-data-set-with-continually-updating-data-points-graphing-test_2
Sheet: Sheet1

 | Time | Temperature F
 | 00:00:00 | 10 |  |  | Time | temp
 | 01:00:00 | 12
 | 02:00:00 | 15
 | 03:00:00 | 16
 | 04:00:00 | 16
 | 05:00:00 | 15
 | 06:00:00 | 12
 | 07:00:00 | 11
 | 08:00:00 | 10
 | 09:00:00 | 9
 | 10:00:00 | 8
 | 11:00:00 | 6
 | 12:00:00 | 9
 | 13:00:00 | 5
 | 14:00:00 | 11
Spreadsheet: c797a90c-9df5-4321-9d37-a1d94b296201
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
FFTRE | Test | FFTRE | Trichloroethylene, Occupational Exposure, blood | Trichloroethylene Occupational Exp | Headspace Gas Chromatography/Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 20 | mL | Collect 2 tubes green-top (sodium heparin) whole blood at end of shift at end of workweek.. Tubes should be filled to prevent loss of  volatile compound into headspace. Send 20 mL sodium heparin whole blood refrigerate. | 2.5 mL NOTE: Submission of the m | Specimens other than	Whole blood Anticoagulants other than	Sodium heparin Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Trichloroethylene, Blood     Free Trichloroethanol Normal (Unexposed Population):    None Detected Exposed:    Biological Exposure Index (BEI):  4.0 mg/L      (End of Shift at End of Workweek)    Biological Tolerance Value (BAT):  5.0 mg/L      (End of Exposure or End of Shift, or After Several       Shifts for Long-Term Exposure) Toxic:    Not Established   Trichloroethylene, Blood Trichloroethylene   Normal (Unexposed Population):       None Detected    Exposed:       Not Established    Toxic:       Greater than 1.5 mg/L   Test Performed By: Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Sunday | 7 days | 9 - 11 days | 1 | 82441 |  |  |  |  | Medtox Laboratories, Inc
FFTRE | Result | Z1154 | Free Trichloroethanol | Free Trichloroethanol | Alphanumeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
FFTRE | Result | Z1065 | Trichloroethylene | Trichloroethylene | Alphanumeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 744786d1629453843-match-multiple-cells-to-create-a-win-loss-result-untitled-spreadsheet
Sheet: Covid Cup Selections & Results

 |  | $100 EW Bet |  |  |  |  |  |  |  | $200 Win Bet |  |  |  |  | $500 Wildcard Bet |  |  |  |  | $1000 Wildcard Bet
 | Name | Race | Horse Number | [NAME] | Win Result | Profit | Place Result | Profit | Total Win | Race | Horse Number | [NAME] | Result | Profit | Race | Horse Number | [NAME] | Result | Profit | Race | Horse Number | [NAME] | Result | Profit | #REF! | #REF!
#REF! | [NAME] | 1 | 1 | [NAME]
#REF! | [NAME] | 1 | 2 | Smith
#REF! | [NAME] | 1 | 3 | [NAME]
#REF! | [NAME] | 2 | 8 | [NAME]
#REF! | [NAME] | 2 | 3 | [NAME]
#REF! | [NAME] | 2 | 6 | [NAME]
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF! | #REF! | #REF!
#REF! | Race 1
#REF!
#REF! | Position | Race | Horse Number | [NAME] | Win | Place |  | $100 Win |  | $100 Place | $200 Win | $500 Win | $1000 Win
#REF! | 1st | 1 | 1 | [NAME] | 5 | 2
#REF! | 2nd |  | 2 | Smith
#REF! | 3rd |  | 3 | [NAME]
#REF! | 4th |  | Deadheat Only
#REF! | Race 1
#REF!
#REF! | Position | Race | Horse Number | [NAME] | Win | Place |  | $100 Win |  | $100 Place | $200 Win | $500 Win | $1000 Win
#REF! | 1st | 2 | 8 | [NAME] | 5 | 2
#REF! | 2nd |  | 3 | [NAME]
#REF! | 3rd |  | 3 | [NAME]
#REF! | 4th |  | Deadheat Only
#REF!
#REF!
#REF!
Spreadsheet: 104283d1301931257-editing-a-table-using-a-vlookup-status-version-1-
Sheet: add to sales

 |  | Prop Ref | Address | Special | Price | Status | In Book? | On RTM | On Market | Notes
home button | diary | search | rightmove | properties | rentals | sales
 |  | Ref | 89
 |  | Address | 20 [NAME], [NAME]
 |  | Special | 0
 |  | Price | 79950
 |  | Status | Fully Avaliable
 |  | In Book? | Yes
 |  | On RTM | Yes
 |  | On Market | 2008-02-01 00:00:00
Spreadsheet: 180569d1347642931-grouping-rows-similar-to-outlining-with-blank-row-in-between-book1
Sheet: Sheet1

What I have
sss | sss | sss | sss | sss | sss
sss | sss | sss | sss | sss | sss
sss | sss | sss | sss | sss | sss
sss | sss | sss | sss | sss | sss
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
eee | eee | eee | eee | eee | eee
jjj | jjj | jjj | jjj | jjj | jjj
jjj | jjj | jjj | jjj | jjj | jjj
jjj | jjj | jjj | jjj | jjj | jjj
jjj | jjj | jjj | jjj | jjj | jjj
jjj | jjj | jjj | jjj | jjj | jjj
jjj | jjj | jjj | jjj | jjj | jjj
What I want
sss | sss | sss | sss | sss | sss
sss | sss | sss | sss | sss | sss
sss | sss | sss | sss | sss | sss
sss | sss | sss | sss | sss | sss
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
eee | eee | eee | eee | eee | eee
jjj | jjj | jjj | jjj | jjj | jjj
jjj | jjj | jjj | jjj | jjj | jjj
jjj | jjj | jjj | jjj | jjj | jjj
jjj | jjj | jjj | jjj | jjj | jjj
jjj | jjj | jjj | jjj | jjj | jjj
jjj | jjj | jjj | jjj | jjj | jjj