tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 810175d1671586626-convert-horizontal-table-to-vertical-table-form-conversion
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Result
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 |  |  | A | Bangkok | 0.05 |  | Column1 | Value | [NAME]
A | Bangkok | 0.05 | Phuket | 0.06 | Nakhon Sawan | 0.07 |  |  |  |  | A | Phuket | 0.06 |  | A | Bangkok | 0.05
B | [NAME] | 0.07 | Ayutthaya | 0.04 |  |  |  |  |  |  | A | Nakhon Sawan | 0.07 |  | A | Phuket | 0.06
C | Pattaya | 0.03 | [NAME] | 0.1 | [NAME] | 0.09 | Pattani | 0.07 |  |  | B | [NAME] | 0.07 |  | A | Nakhon Sawan | 0.07
D | Rayong | 0.02 |  |  |  |  |  |  |  |  | B | Ayutthaya | 0.04 |  | B | [NAME] | 0.07
 |  |  |  |  |  |  |  |  |  |  | C | Pattaya | 0.03 |  | B | Ayutthaya | 0.04
 |  |  |  |  |  |  |  |  |  |  | C | [NAME] | 0.1 |  | C | Pattaya | 0.03
 |  |  |  |  |  |  |  |  |  |  | C | [NAME] | 0.09 |  | C | [NAME] | 0.1
 |  |  |  |  |  |  |  |  |  |  | C | Pattani | 0.07 |  | C | [NAME] | 0.09
 |  |  |  |  |  |  |  |  |  |  | D | Rayong | 0.02 |  | C | Pattani | 0.07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | Rayong | 0.02
Spreadsheet: 26333d1218475044-deleting-from-the-beginning-of-each-cell-sample-of-errors
Sheet: Sheet1

H1231041 |  | H1231041
H1180051 |  | H1180051
H1180073 |  | H1180073
H1181000 |  | H1181000
H1181017 |  | H1181017
H1181041 |  | H1181041
Z018 |  | Z018
Z332 |  | Z332
Z336 |  | Z336
H1015000 |  | H1015000
H1015001 |  | H1015001
Spreadsheet: 111460d1307825780-excel-2007-lookup-with-summing-lookup-with-summing
Sheet: Φύλλο1

Orders
 |  |  |  |  |  | Product
Name | Product | Amount |  |  |  | A | B | C | D
[NAME] | A | 320 |  |  | [NAME]
[NAME] | C | 300 |  |  | [NAME]
[NAME] | A | 430 |  |  | Gerard
Gerard | D | 300 |  |  | [NAME]
[NAME] | D | 300
[NAME] | B | 200
[NAME] | B | 600
[NAME] | B | 400
Spreadsheet: 691868d1597927313-fetching-value-from-another-sheet-for-next-9-months-if-the-month-changes-testing-d1_chris
Sheet: Main

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for data validation in G3
 |  |  |  |  | Month | 2020-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  | TYPE 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00
 |  |  |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00
 |  |  |  |  | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00
 |  |  |  |  | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-03-01 00:00:00
 |  |  |  |  | E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00
 |  |  |  |  | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-01 00:00:00
 |  |  |  |  | TYPE 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-01 00:00:00
 |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00
 |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-09-01 00:00:00
 |  |  |  |  | Z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  | If I select G3 as November , [NAME] and G14 Should become November , and next 9 month should be december , jan, feb and so on |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-01 00:00:00
 |  |  |  |  | and values should be referenced for these months from REFERENCE sheet in their respective months
Spreadsheet: 688501d1595833228-multiple-calculation-of-range-in-single-cell-to-find-largest-number-demo_file
Sheet: Sheet1

Value | Price |  | Value | Price
3861 | 7300 |  | 123.4 | 11200
- | 7350 |  | 151.95 | 11250 |  |  |  | I would like to do calculation in F2 cell to find laegest number and in G2 to find smallest number as below
- | 7400 |  | 184.4 | 11300
- | 7450 |  | 218.45 | 11350
3672 | 7500 |  | 257 | 11400
- | 7550 |  | 296.65 | 11450 |  |  |  | For F2 : find largest among below range and write it in F2
- | 7600 |  | 344.2 | 11500
- | 7650 |  | 390.75 | 11550 |  |  |  | (E2-B2)-(D2+A2)
2558.75 | 7700 |  | 432.05 | 11600 |  |  |  | (E2-B3)-(D2+A3)
- | 7750 |  | 480.4 | 11650 |  |  |  | (E2-B4)-(D2+A4)
- | 7800 |  | 530.35 | 11700 |  |  |  | (E2-B5)-(D2+A5)
- | 7850 |  | 594.35 | 11750 |  |  |  | (E2-B6)-(D2+A6)
3065.8 | 7900 |  | 643.7 | 11800 |  |  |  | (E2-B7)-(D2+A7)
- | 7950 |  | 730.15 | 11850
3168.35 | 8000 |  | 728.8 | 11900
- | 8050 |  | 850.05 | 11950
3045 | 8100 |  | 827.7 | 12000
- | 8150 |  | 1074.15 | 12050
3025 | 8200 |  | 920.15 | 12100
- | 8250 |  | 1530.3 | 12150
2785.2 | 8300 |  | 1085.5 | 12200
- | 8350 |  | - | 12250
2808.3 | 8400 |  | 1152.3 | 12300
- | 8450 |  | - | 12350
2672.55 | 8500 |  | 1281.9 | 12400
- | 8550 |  | - | 12450
2518.35 | 8600 |  | 1359.5 | 12500
- | 8650 |  | - | 12550
2470.9 | 8700 |  | - | 12600
- | 8750 |  | - | 12650
2330 | 8800 |  | - | 12700
710 | 8850
2248.8 | 8900
- | 8950
2171.4 | 9000
- | 9050
2074.35 | 9100
904.7 | 9150
1972.1 | 9200
- | 9250
1870 | 9300
928.8 | 9350
1771.3 | 9400
948.35 | 9450
1671.15 | 9500
1184.45 | 9550
1579.9 | 9600
994.5 | 9650
1475.95 | 9700
853.25 | 9750
1370.2 | 9800
1270.7 | 9850
1272.55 | 9900
1156.25 | 9950
1175.7 | 10000
1020.1 | 10050
1073 | 10100
962.15 | 10150
977 | 10200
928.35 | 10250
874.1 | 10300
829.15 | 10350
775.1 | 10400
725.8 | 10450
678 | 10500
630 | 10550
581.1 | 10600
532.3 | 10650
494.65 | 10700
441 | 10750
389.4 | 10800
350.8 | 10850
302.05 | 10900
255 | 10950
217 | 11000
180.05 | 11050
147.75 | 11100
118.2 | 11150
Spreadsheet: 872253d1718643985-countif-function-date-ranges-and-cell-exclusions-tracker
Sheet: Sheet1

 |  | Today's date
 |  | Overdue Tasks
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Due Date | Revised Date | Column 14 | Status
Task 1 |  |  |  |  |  |  |  |  |  |  | 2024-05-31 00:00:00 | 2024-06-21 00:00:00 |  | In Progress
Task 2 |  |  |  |  |  |  |  |  |  |  | 2024-06-05 00:00:00 | 2024-06-19 00:00:00 |  | Complete
Task 3 |  |  |  |  |  |  |  |  |  |  | TBC |  |  | Not Started
Task 4 |  |  |  |  |  |  |  |  |  |  | 2024-06-15 00:00:00 |  |  | Complete
Task 5 |  |  |  |  |  |  |  |  |  |  | 2024-06-28 00:00:00 | TBC |  | In Progress
Spreadsheet: 476317d1471798627-displaying-unique-results-from-a-custom-made-lookup-formula-ultimate-vlookup-trick-needs-adjustment-pcb-
Sheet: Ultimate VLOOKUP

First Name | Surname | Uniqe Reference |  |  |  | CURRENT RESULT | Desired Result Unique (not repeated) |  | First Name | [NAME] | <----Select 1
[NAME] | [NAME] | CAR |  |  | [NAME] | CAR | CAR |  | Surname | [NAME] | <----Select 2
[NAME] | [NAME] | BIKE |  |  | [NAME] | CAR | BIKE
[NAME] | [NAME] | BUS |  |  | [NAME] | CAR | BUS |  | Count of Uniqe Reference
[NAME] | [NAME] | HELICOPTER |  |  |  |  |  |  | Uniqe Reference | Total
[NAME] | [NAME] | CAR |  |  |  |  |  |  | BIKE | 3
[NAME] | [NAME] | BIKE |  |  |  |  |  |  | BUS | 3
[NAME] | [NAME] | BUS |  |  |  |  |  |  | CAR | 3
[NAME] | [NAME] | CAR |  |  |  |  |  |  | Grand Total | 9
[NAME] | [NAME] | BIKE
[NAME] | [NAME] | BUS
[NAME] | [NAME] | HELICOPTER
[NAME] | [NAME] | HELICOPTER
[NAME] | [NAME] | HELICOPTER
[NAME] | [NAME] | HELICOPTER
[NAME] | [NAME] | HELICOPTER
Spreadsheet: 60a95971-1b84-4b3a-a355-de55927d7a56
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: March 11, 2014 (6:05 am)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 237399
2004 | 223675 | 233241 | 232983 | 246201
2005 | 236033 | 244136 | 244711 | 255856
2006 | 245182 | 254735 | 255745 | 271401
2007 | 257973 | 265739 | 267325 | 281304
2008 | 270217 | 277643 | 277604 | 282885
2009 | 261948 | 266881 | 265508 | 280622
2010 | 267483 | 274697 | 276055 | 291990
2011 | 277885 | 289552 | 288862 | 304550
2012 | 290131 | 297462 | 296119 | 320584
2013 | 302663 | 309834 | 310513 | X
Spreadsheet: 809719d1671261816-add-serial-every-number-of-repeat-adding-serial-number-for-5-repeat-automatic
Sheet: Sheet1

Head | Example |  |  | Starting NO.
7003-STUR 1-D | 2304 |  |  | 2034
7002-STUR 1-G | 2306
7002-STUR 2-G | 2307
7002-STUR 2-G | 2307
7002-STUR 2-G | 2307
7002-STUR 2-G | 2307
7002-STUR 2-G | 2307
7003-STUR 1-D | 2304
7003-STUR 1-D | 2304
7003-STUR 1-D | 2304
7003-STUR 1-D | 2304
7003-STUR 1-D | 2305
7003-STUR 2-D | 2308
7003-STUR 2-D | 2308
7003-STUR 2-D | 2308
7003-STUR 2-D | 2308
7003-STUR 2-D | 2308
7003 / 1-STUR 1-D | 2309
7003 / 1-STUR 1-D | 2309
7003 / 1-STUR 2-D | 2310
7003 / 1-STUR 2-D | 2310
7003 / 1-STUR 2-D | 2310
7003 / 1-STUR 2-D | 2310
7002-STUR 1-G | 2306
7002-STUR 1-G | 2306
7002-STUR 1-G | 2306
7003 / 1-STUR 1-D | 2309
7003 / 1-STUR 1-D | 2309
7003 / 1-STUR 1-D | 2309
7003 / 1-STUR 2-D | 2310
7003 / 1-STUR 2-D | 2311
7003 / 1-STUR 2-D | 2311
7003 / 1-STUR 2-D | 2311
7003 / 1-STUR 2-D | 2311
7003 / 1-STUR 2-D | 2311
7003-INAh-T
7003-INAh-T
7003-AEF-D
7003-INAh-D
7003-INAh-D
7003-INAh-D
7002-RID-E
7003-INAh-D
7003-INAh-D
7003-INAh-D
7003-INAh-D
7003-RAN-D
7003-ZAN-D
7003-KAH-D
7003-AEF-D
7003-AEF-D
7003-AEF-D
7003-AEF-D
7003-AEF-D
7002-AEF-F
7002-KAH-F
7002-DAH-F
7003-SSA-D
7003-SSA-D
7003-AHA-D
7003-KAH-D
7003-KAH-D
7003-AEF-D
7003-AEF-D
7003-INAh-D
7003-INAh-D
7003-INAh-D
7003-INAh-D
7003-INAh-D
7003-AHA-D
7003-AEL-D
7003-AEL-D
7003-AHA-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7002-RID-E
7002-RID-E
7002-RID-E
7002-RID-F
7002-RID-F
7003-MAM-D
7002-MAM-F
7003-YAT-D
7003-YAT-D
7003-AFR-D
7002-OAFF-F
7003-OAFF-D
7003-AEL-D
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7002-OUK-T
7003-SSA-D
7003-SIM-D
7003-SIM-D
7003-SIM-D
7002-SSA-F
7002-SSA-F
7002-ORTH-F
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-ZAN-F
7003-ZAN-D
7003-AHA-D
7003-AHA-D
7003-AHA-D
7002-AHA-F
7002-AHA-F
7002-AHA-F
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7002-ORTH-F
7003-ORTH-T
7002-EER-F
7002-EER-F
7002-EER-F
7002-EER-F
7002-EER-F
7003-INAh-D
7002-EER-F
7002-EER-F
7002-AHA-F
7002-AHA-F
7002-SHAh-F
7002-ZAN-F
7002-ZAN-F
7002-AEF-G
7002-AEF-G
7002-AEF-G
7002-AEF-G
7002-AEF-G
7002-ONF-G
7002-ONF-G
7002-ORTH-G
7002-AEF-G
7002-AEF-G
7002-AEF-G
7002-DAH-G
7002-DAH-G
7003-DAH-D
7003-DAH-D
7003-SMC-D
7003-SMC-D
7003-SMC-D
7003-SMC-D
7003-MAM-D
7003-MAM-D
7003-MAM-D
7003-MAM-D
7003-AEL-D
7003-AEF-D
7003-MAM-D
7003-MAM-D
7003-MAH-D
7003-MAH-D
7003-MAH-D
7003-SMC-D
7003-OUK-D
7003-INAh-D
Spreadsheet: cc6621aa-82b6-4002-af32-51f1b16cca3e
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
GNEM | Test | GNEM | [NAME], IgE | [NAME], 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
GNEM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GNEM | Result | GNEM | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6133-3 | Cladotanytarsus lewisi Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 146114d1331904951-extract-from-1-sheet-to-many-sum-total-not-working-extract-from-1-sheet-to-many-sheets
Sheet: JOHN SMITH

SAMPLE CYCLE TEST RUNS
[NAME] | TECHNICIAN | CYCLE A |  | CYCLE B |  | CYCLE C |  | CYCLE D |  | CYCLE E |  | CYCLE F
 |  | P | Chart | P | Chart | P | Chart | P | Chart | P | Chart | P | Chart
RUN 1 | [NAME] | 1 | 14.A | 10 | 9.A | 12 | 4.DA | 14 | 11.AC | 16 | 7.ZA | 20 | 12.AE
RUN 6 | [NAME] | 11 | 16.A | 60 | 11.CB | 37 | 7.ZZ | 39 | 12.GB |  | 7.ZB | 30 | 14.FY
RUN 7 | [NAME] | 13 | 16.A | 70 | 11.CB | 42 | 7.ZZ | 44 | 12.GB | 46 | 7.ZB |  | 14.FY
RUN 15 | [NAME] | 29 | 12.A | 150 | 15.DD | 82 | 12.BD | 84 | 13.DF | 86 | 11.DX | 48 | 18.PO
TOTALS |  | 54 |  | 290 |  | 173 |  | 181 |  | 148 |  | 98
Spreadsheet: 1faf70b2-d9cd-41ec-b43d-a9fbb3e9af32
Sheet: Calculator Prestretch on Load

 | Calculator for Pre-Stretch on Load
 | [NAME] | Current
 | [NAME] ( inches ) | 19.685
 | [NAME] ( 80 gauge = .8 ) | 0.8
 | [NAME] (feet) | 6500
 | Net Poly Weight (calculated) |  | Net Poly Weight = [NAME] (in) x Mil x Film Length (ft) x .0004
 | Turn Table Revolutions | 11
 | [NAME] (inches) | 45.5
 | [NAME] (inches) | 49
 | [NAME]   (inches) | 41
 | [NAME] (feet) |  | Load perimeter= [(Load Length + Load Width) x 2]/12
 | Feet of Stretched Film |  | Feet of unstretched film = [NAME] x # turntable revolutions
 | Feet of Un-Stretched Film |  | Feet of un-streched film = Feet of unstretched film x (1/(1+stretch %))
 | Enter Actual Cut & Weigh ounces | 7.714
 | Without Pre-stretch ounces |  | Weight without prestretch=  Film width x  Mil x Feet of stretched film x 0.0004 x 16
 | Calculated stretch |  | Calculated stretch = (Weight without prestretch-Actual cut film weight)/Weight without prestretch
 |  |  | Calculated stretch = [([NAME] x  Mil x Feet of Stretched Film x 0.0004 x 16)-Actual Cut Film Weight]/(Film Width x  Mil x Feet of Stretched Film x 0.0004 x 16)
 | Imput Data Needed: |  | Calculated stretch = [(20 x  0.8 x 165 x 0.0004 x 16)-Actual Cut Film Weight]/(20 x  0.8 x 165 x 0.0004 x 16)
 | 1. Pallet size: width, length, height
 | 2. [NAME]: gauge, width, length
 | 3. Number of film rotations around the pallet during wrapping.
 | 4. Number of ounces of film used from Cut & Weigh test
Spreadsheet: 121808d1316431974-looking-up-column-values-and-apending-to-a-row-example-1-1-
Sheet: Sheet1

From This |  |  |  | To This
ID | Spec Type | Spec Value |  | ID | Spec Type 1 | Spec Value 1 | Spec Type 2 | Spec Value 2 | Spec Type 3 | Spec Value 3 | Spec Type 4 | Spec Value 4
5 | Type | A |  | 5 | Type | A | Color | Red | Sound | Loud
5 | Color | Red |  | 6 | Animal | Tiger | Color | Green | Type | A
5 | Sound | Loud |  | 7 | Color | Green
6 | Animal | Tiger |  | 8 | Smell | Strong | Type | B | Color | Red | Sound | Quiet
6 | Color | Green
6 | Type | A
7 | Color | Green
8 | Smell | Strong
8 | Type | B
8 | Color | Red
8 | Sound | Quiet
 |  |  |  | Note: array formula is used and should be confirmed throug Ctrl+Shift+Enter
Spreadsheet: 794570d1662123500-how-to-convert-return-value-horizontally-two-lookup-criteria-and-convert-a-returened-range-to-horizantal
Sheet: Sheet1

Date | Time | Subject Code | [NAME] | Technology | CT | ET | MT | PT | EnT | CST | EmT |  | CT | ET | MT | PT | EnT | CST | EmT
2022-08-22 00:00:00 | 10:00:00 | 67011 | Design-1 | CT | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: | 2022-08-22 00:00:00 | Two Input Criteria
2022-08-22 00:00:00 | 10:00:00 | 67012 | Design-2 | ET |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time: | 10:00:00
2022-08-22 00:00:00 | 10:00:00 | 67013 | Design-3 | MT |  |  | 1
2022-08-22 00:00:00 | 10:00:00 | 67014 | Design-4 | PT |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Required output as follow:
2022-08-22 00:00:00 | 10:00:00 | 67015 | Design-5 | EnT |  |  |  |  | 1
2022-08-22 00:00:00 | 10:00:00 | 67016 | Design-6 | CST |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1/CT | 1/ET | 1/MT | 1/PT | 1/EnT | 1/CST | 1/EmT
2022-08-22 00:00:00 | 10:00:00 | 67017 | Design-2 | EmT |  |  |  |  |  |  | 1
2022-08-22 00:00:00 | 02:00:00 | 67018 | Design-3 | CT | 5
2022-08-22 00:00:00 | 02:00:00 | 67019 | Design-4 | ET |  | 5
2022-08-22 00:00:00 | 02:00:00 | 67020 | Design-5 | MT |  |  | 5
2022-08-22 00:00:00 | 02:00:00 | 67021 | Design-6 | PT |  |  |  | 5
2022-08-22 00:00:00 | 02:00:00 | 67022 | [NAME] | EnT |  |  |  |  | 5
2022-08-22 00:00:00 | 02:00:00 | 67022 | [NAME] | CST |  |  |  |  |  | 5
2022-08-22 00:00:00 | 02:00:00 | 67023 | Design-8 | EmT |  |  |  |  |  |  | 5
2022-08-23 00:00:00 | 10:00:00 | 67011 | Design-1 | CT | 7
2022-08-23 00:00:00 | 10:00:00 | 67012 | Design-2 | ET |  | 7
2022-08-23 00:00:00 | 10:00:00 | 67013 | Design-3 | MT |  |  | 7
2022-08-23 00:00:00 | 10:00:00 | 67014 | Design-4 | PT |  |  |  | 7
2022-08-23 00:00:00 | 10:00:00 | 67015 | Design-5 | EnT |  |  |  |  | 7
2022-08-23 00:00:00 | 10:00:00 | 67016 | Design-6 | CST |  |  |  |  |  | 7
2022-08-23 00:00:00 | 10:00:00 | 67017 | Design-2 | EmT |  |  |  |  |  |  | 7
2022-08-23 00:00:00 | 02:00:00 | 67018 | Design-2 | CT | 3
2022-08-23 00:00:00 | 02:00:00 | 67019 | Design-6 | ET |  | 3
2022-08-23 00:00:00 | 02:00:00 | 67020 | Design-10 | MT |  |  | 3
2022-08-23 00:00:00 | 02:00:00 | 67021 | Design-14 | PT |  |  |  | 3
2022-08-23 00:00:00 | 02:00:00 | 67022 | Design-18 | EnT |  |  |  |  | 3
2022-08-23 00:00:00 | 02:00:00 | 67023 | Design-22 | CST |  |  |  |  |  | 3
2022-08-23 00:00:00 | 02:00:00 | 67024 | Design-26 | EmT |  |  |  |  |  |  | 3
Spreadsheet: 385896d1427476638-problem-with-protecting-workbooks-which-have-lists-recording-sheet-version-8
Sheet: Macro Moths

Macro Moths |  |  |  |  | Please enter data in as many fields below as possible - leave blank where information not known. Required fields are highlighted with a blue cell below. Comments are also inserted in each header below giving extra user information.
ABH Log | BF Log | Status | Species [NAME] | Species Latin Name | Place Name | [NAME]. | [NAME]. | [NAME] | Determiners Name | Date of Record | Qty Recorded | Method of Recording | [NAME] | Stage | Weather | Aspect | Altitude | [NAME]. | Notes
53.001 | 173 | None | Festoon | Apoda limacodes
53.002 | 174 | None | Triangle | Heterogenea asella
52.001 | 369a | None | [NAME] | Pennisetia hylaeiformis
52.002 | 370 | None | Hornet moth | Sesia apiformis
52.003 | 371 | C | [NAME] | Sesia bembeciformis
52.004 | 372 | None | Dusky Clearwing | Paranthrene tabaniformis
52.013 | 373 | D | Currant Clearwing | [NAME] tipuliformis
52.012 | 374 | D | Yellow-legged Clearwing | Synanthedon vespiformis
52.006 | 375 | None | White-barred Clearwing | [NAME] spheciformis
52.005 | 376 | C | Welsh Clearwing | [NAME] scoliaeformis
52.009 | 377 | None | Sallow Clearwing | [NAME]
52.01 | 378 | None | Orange-tailed Clearwing | Synanthedon andrenaeformis
Spreadsheet: 87632d1287512884-generating-combinations-of-text-enumerate-all-combinations
Sheet: Combinations

All Possible Combinations
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
A | D | H | J | O | Q | T | X
A | D | H | J | O | Q | T | Y
A | D | H | J | O | Q | T | Z | <---Copy this row and fill down to row 8,641!!
Spreadsheet: 3fd6c884-1122-4441-b550-af4696082ed0
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
9804 | Test | 9804 | Fite-Faraco Stain | Fite-Faraco ST | Includes pathology consultation charged separately. | Formalin-fixed, paraffin-embedded tumor tissue block. Include 1 H & E slide: FFPTHE |  |  |  | Varies | Container/Tube:  Preferred: Formalin-fixed, paraffin-embedded tissue block Acceptable: Tissue in formalin Collection Instructions: Include 1 hematoxylin-and-eosin stained slide. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Friday; 7 a.m. | 2 days/Paraffin 1 day, Fixative 2 days | 5 days | 1 | 88312 |  |  |  |  | Rochester
9804 | [NAME] | TISSUE | Tissue |  |  |  | Ambient
9804 | Result | 9804 | Fite-Faraco ST | Fite-Faraco ST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10785-4 | Microscopic observation:Prid:Pt:Tiss:Nom:Fite-Faraco stain
Spreadsheet: 455343d1460264355-formula-based-on-total-new-100-excel-weight-adjustment-1-
Sheet: Sheet1

S.NO. | CONTAINER NOS. |  | SEAL NOS. |  | NET WT | ADJUSTED WT |  |  | SLABS
1 | ABCD | 123456 | 56789 |  | 26.86 |  |  | 1 | below 23.7
 |  |  |  |  | 25.57 |  |  | 2 | below 27.7
 |  |  |  |  | 25.78
 |  |  |  |  | 24.89
 |  |  |  |  | 22.15
 |  |  |  |  | 22.68
 |  |  |  |  | 23.95
 |  |  |  |  | 27.65
 |  |  |  |  | 27.44
 |  |  |  |  | 22.38
 |  |  |  |  | 25.98
 |  |  |  |  | 24.73
 |  |  |  |  | 23.24
 |  |  |  |  | 23.72
 |  |  |  |  | 25.91
 |  |  |  |  | 25.86
 |  |  |  |  | 22.27
 |  |  |  |  | 23.82
 |  |  |  |  | 26.68
 |  |  |  |  | 27.15
 |  |  |  |  | 26.34
 |  |  |  |  | 23.11
 |  |  |  |  | 22.43
 |  |  |  |  | 27.56
 |  |  |  |  | 22.36
 |  |  |  |  | 23.91
 |  |  |  |  | 24.82
 |  |  |  |  | 24.91
 |  |  |  |  | 24.33
 |  |  |  |  | 27.68
 |  |  |  |  | 27.19
 |  |  |  |  | 22.19
 |  |  |  |  | 24.72
 |  |  |  |  | 25.99
 |  |  |  |  | 21.12
 |  |  |  |  | 20.18
 |  |  |  |  | 19.9
 |  |  |  |  | 23.72
 |  |  |  |  | 23.9
 |  |  |  |  | 24.82
 |  |  |  |  | 27.23
 |  |  |  |  | 22.81
 |  |  |  |  | 23.91
 |  |  |  |  | 24.99
 |  |  |  |  | 25.72
 |  |  |  |  | 24.55
 |  |  |  |  | 21.76
 |  |  |  |  | 27.69
 |  |  |  |  | 23.9
 |  |  |  |  | 25.87
 |  |  |  |  | 25.88
 |  |  |  |  | 24.9
 |  |  |  |  | 25.91
 |  |  |  |  | 26.91
 |  |  |  |  | 25.9
 |  |  |  |  | 27.65
 |  |  |  |  | 24.91
 |  |  |  |  | 23.89
 |  |  |  |  | 22.1
 |  |  |  |  | 21.9
 |  |  |  |  | 21
 |  |  |  |  | 22.71
 |  |  |  |  | 24.78
 |  |  |  |  | 22.65
 |  |  |  |  | 22.34
 |  |  |  |  | 26.98
 |  |  |  |  | 26.93
 |  |  |  |  | 23.33
 |  |  |  |  | 21.88
 |  |  |  |  | 21.98
 |  |  |  |  | 19.88
 |  |  |  |  | 20.81
 |  |  |  |  | 21.89
 |  |  |  |  | 20.33
 |  |  |  |  | 27.67
 |  |  |  |  | 25.98
 |  |  |  |  | 22.77
 |  |  |  |  | 21.98
 |  |  |  |  | 21.76
 |  |  |  |  | 24.56
 |  |  |  |  | 20.59
 |  |  |  |  | 21.5
 |  |  |  |  | 25.39
 |  |  |  |  | 22.48
 |  |  |  |  | 21.72
 |  |  |  |  | 21.89
 |  |  |  |  | 25.77
 |  |  |  |  | 26.33
 |  |  |  |  | 21.82
 |  |  |  |  | 25.99
 |  |  |  |  | 27.5
 |  |  |  |  | 26.37
 |  |  |  |  | 26.62
 |  |  |  |  | 25.46
 |  |  |  |  | 24.22
 |  |  |  |  | 26.18
 |  |  |  |  | 24.89
 |  |  |  |  | 25.88
 |  |  |  |  | 24.44
 |  |  |  |  | 25