tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3201cf54-0619-4d32-9d69-de7749d63b65
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/12/2012 | Men's Swimming & Diving | West Virginia State Games (Huntington, W.Va.) | 12:00 AM | 1st place
10/13/2012 | Men's Swimming & Diving | West Virginia State Games (Huntington, W.Va.) | 12:00 AM | 1st place
10/19/2012 | Men's Swimming & Diving | Penn State | 12:00 AM | L, 174-69
10/27/2012 | Men's Swimming & Diving | at Villanova | 12:00 AM | W, 174-113
11/02/2012 | Men's Swimming & Diving | at Cincinnati | 12:00 AM | W, 177-114
11/16/2012 | Men's Swimming & Diving | Pitt Invitational (Pittsburgh, Pa.) | 12:00 AM | 2nd place
11/17/2012 | Men's Swimming & Diving | Pitt Invitational (Pittsburgh, Pa.) | 12:00 AM | 2nd place
11/18/2012 | Men's Swimming & Diving | Pitt Invitational (Pittsburgh, Pa.) | 12:00 AM | 2nd place
11/29/2012 | Men's Swimming & Diving | U.S. Winter Nationals (Austin, Texas) | 12:00 AM | Results
11/30/2012 | Men's Swimming & Diving | U.S. Winter Nationals (Austin, Texas) | 12:00 AM | Results
11/30/2012 | Men's Swimming & Diving | Miami Diving Invitational (Miami, Ohio) | 12:00 AM | Results
12/01/2012 | Men's Swimming & Diving | Miami Diving Invitational (Miami, Ohio) | 12:00 AM | Results
12/01/2012 | Men's Swimming & Diving | U.S. Winter Nationals (Austin, Texas) | 12:00 AM | 33rd place
01/03/2013 | Men's Swimming & Diving | Orange Bowl Classic (Key Largo, Fla.) | 12:00 AM | 2nd place
01/12/2013 | Men's Swimming & Diving | at Pitt | 12:00 AM | L, 217-63
01/18/2013 | Men's Swimming & Diving | TCU | 12:00 AM | L, 160-131
02/09/2013 | Men's Swimming & Diving | [NAME] (Diving) | 12:00 AM | Results
02/27/2013 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | 1st place
02/28/2013 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | 2nd place
03/01/2013 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | 2nd place
03/02/2013 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | 3rd place
03/15/2013 | Men's Swimming & Diving | NCAA Zone Diving (Blacksburg, Va.) | 12:00 AM | Results
03/16/2013 | Men's Swimming & Diving | NCAA Zone Diving (Blacksburg, Va.) | 12:00 AM | Results
Spreadsheet: 09a77ff5-fb2d-47fb-bcde-d573c13e478b
Sheet: Instructions

Instructions
The purpose of this file is to distribute teachers' salaries and contract hours among disability categories.
To use the file, you enter the following teacher-specific data into the yellow cells of the "Report" worksheet:
* | district number in the yellow cells
* | DO NOT CHANGE the threshold cell unless requested by MDE
* | total contact days,
* | total annual salary, and
* | pupil contacts by disability.
The file allows you to enter data for up to 20 teachers.  If you have more than 20 teachers, you have to
create multiple versions of the file.
The file also lets the user specify a particular district, and to specify a "threshold portion" that will be
explained below.
The inputs section is followed by a "TOTALS" section the adds up the results for individual teachers.
The come the detailed calculations, with six lines for each individual teacher:
1 | Inputs
n/a | This line simply restates the inputs that were entered in the yellow cells.
2 | Revised Pupils
n/a | In this line, a given disability's pupil count is eliminated if it represents less than 10% of a teacher's
n/a | total number of pupil contacts.  This 10% is the default "threshold portion", as noted above.
n/a | You probably don't want to change this 10% value.
3 | Pupil Portions
n/a | This shows the portion of pupils from the "Revised Pupils" line that are associated with each
n/a | category of disability.  Assuming that a teacher's overall pupil count is greater than zero,
n/a | the values in the "Pupil Portions" line will add up to 100%.
4 | Contract Days
n/a | In this line, the total number of contract days that were entered for a teacher in the yellow section
n/a | are distributed across disability categories in proportion to the "Pupil Portions" line.
EDRS DATA
n/a | The lines in the shaded (light green) area are the data that may be entered on EDRS.  It is the data below:
5 | Contract Hours
n/a | The number of hours per day varies from district to district.  One of the yellow cells lets the user
n/a | specify a particular district.  The file will automatically look up the hours per day for the district that
n/a | was specified as one of the inputs, and will use this value to convert contract days to contract hours.
6 | Annual Salary
n/a | In this line, the salary that was entered for a teacher in the yellow section is distributed across
n/a | disability categories in proportion to the "Pupil Portions" line.
As already noted, the totals across teachers for contract days, contract hours, and annual salaries
are shown in the TOTALS section that immediately follows the inputs.
Please address any spreadsheet questions to [NAME] at [EMAIL], or at [PHONE].
Tuition questions go the Michelle Jones at [PHONE] or email [EMAIL]
EDRS question may be sent to [NAME] at [PHONE] or email to [EMAIL]
End of worksheet
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 8c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 0 | 1 | 17 | 16 | 42 | 14 | 33 | 3 | 126
Cap/Floor | 2 | 0 | 3 | 21 | 44 | 9 | 2 | 0 | 81
Debt Option | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Exotic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed-Fixed | 5 | 0 | 1 | 3 | 1 | 0 | 5 | 0 | 15
Fixed-Float | 120 | 55 | 293 | 823 | 4529 | 6770 | 5110 | 1227 | 18927
FRA | 168 | 448 | 724 | 634 | 0 | 0 | 0 | 0 | 1974
Inflation | 6 | 4 | 11 | 16 | 44 | 30 | 32 | 10 | 153
OIS | 45 | 28 | 41 | 62 | 53 | 33 | 13 | 0 | 275
Swaption | 0 | 0 | 1 | 43 | 180 | 186 | 391 | 106 | 907
TOTAL | 346 | 536 | 1091 | 1618 | 4893 | 7042 | 5586 | 1346 | 22458
Spreadsheet: 852589d1702572272-how-to-sumif-with-dynamic-variable-number-of-criteria-ranges-excel-example
Sheet: Sheet1

 |  |  |  |  |  | Master [NAME] |  |  | Value Array |  |  | Unique Master Array |  |  | [NAME]
 |  |  |  |  |  |  | Red | True |  |  |  |  | Red | True
 |  |  |  |  |  | A | Blue | True | 40 |  |  | A | Blue | True | 740 | 740
 |  |  |  |  |  | B | Blue | False | 450 |  |  | B | Blue | False | 450 | 450
 |  |  |  |  |  | A | Blue | True | 100 |  |  | C | Blue | False | 25 | 25
 |  |  |  |  |  | A | Blue | True | 600 |  |  | A | Yellow | True | 400 | 400
 |  |  |  |  |  | C | Blue | False | 25
 |  |  |  |  |  | A | Red | True | 400
 |  |  |  |  |  | A | Red | True | 150
 |  |  |  |  |  | A | Yellow | True | 400
 |  |  |  |  |  | [NAME] | Working, but as the size of array is dynamic the number of criteria ranges and criteria will change.
 |  |  |  |  |  | Sometimes the data will be like this |  |  |  |  | Or like this etc.
 |  |  |  |  |  | Master [NAME] |  | Value Array |  |  | Master [NAME] |  |  |  | Value Array
 |  |  |  |  |  |  | Red |  |  |  |  | Red | True | Int
 |  |  |  |  |  | A | Blue | 40 |  |  | A | Blue | True | Int | 40
 |  |  |  |  |  | B | Blue | 450 |  |  | B | Blue | False | Int | 450
 |  |  |  |  |  | A | Blue | 100 |  |  | A | Blue | True | Ext | 100
 |  |  |  |  |  | A | Blue | 600 |  |  | A | Blue | True | Ext | 600
 |  |  |  |  |  | C | Blue | 25 |  |  | C | Blue | False | Ext | 25
 |  |  |  |  |  | A | Red | 400 |  |  | A | Red | True | Ext | 400
 |  |  |  |  |  | A | Red | 150 |  |  | A | Red | True | Int | 150
 |  |  |  |  |  | A | Yellow | 400 |  |  | A | Yellow | True | Ext | 400
Spreadsheet: 834062d1687424626-formula-to-summary-price-qty-on-selected-rows-sample-case2-etaf
Sheet: Sheet1

 |  |  |  | SUBTOTAL QTY
 |  |  |  | SUBTOTAL AMNT
 |  |  |  | EXPECTED SUBTOTAL AMNT
 |  | CATEGORY | Price/Unit | MODEL | JUL | AUG | SEP
 |  | 32" | 2 | [NAME] | 100 | 75 | 50
 |  | 32" | 2.1 | [NAME] | 50 | 50 | 25
 |  | 32" | 1.9 | AQT32K701A | 100 | 140 | 200
 |  | 32" | 2 | [NAME] | 50 | 50 | 0
 |  | 43" | 2.8 | [NAME] | 80 | 80 | 150
 |  | 43" | 2.7 | LE43AQT8500MF | 0 | 0 | 0
 |  | 43" | 2.8 | LE43AQT6700FG | 100 | 100 | 0
 |  | 43" | 2.7 | AQT43K701AF | 40 | 40 | 180
 |  | 43" | 2.7 | LE43AQT6700UG | 50 | 50 | 0
 |  | 43" | 2.7 | AQT43P750UX | 40 | 40 | 120
 |  | 50" | 3.5 | LE50AQT7000QUPRO | 50 | 50 | 50
Spreadsheet: 707067d1607018556-extract-json-data-values-and-identify-the-differences-data-for-excel-dec-3rd-2020
Sheet: Output

Billid | ctextid | cCode-Coder | cCode-Auditor | deletedccode | added-ccode | dCode-Coder | dCode-Auditor | deleted-dcode | added-dcode | hcpc-coder | hcpc-auditor | deletedhcpc | addedhcpc | mod-coder | mod-auditor | [NAME] | addedmod
7111 | 89321 | 7832,900114 | 78832,900114 | 7832 | 78832 | Y564,U3321,U1111,H8811,J8923 | Y564,U3321,U41111,H8811,J8923 | U1111 | U41111 | 5,1 | 8,1 | 5 | 8 | 67,26 | 67126 | 26 | 126
Spreadsheet: 51947d1251552191-excel-2007-hide-unhide-blank-rows-assigned-to-a-check-box-697444
Sheet: Sheet1

Title
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
Title
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
Title
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
 | Data
Title
 | Data
 | Data
 | Data
 | Data
 | Data
Spreadsheet: 377fa292-741f-455b-bca9-04376c49e4ef
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
 | 8731.0 Building Approvals, Australia
 | TABLE 85. Value of Building Approved, Chain Volume Measures, Original - Northern Territory
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
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  Houses ;  New ; |  |  | Original | A590537T | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  Total Other Residential ;  New ; |  |  | Original | A590538V | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  [NAME] ;  New ; |  |  | Original | A590539W | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  [NAME] ;  Alterations and additions including conversions ; |  |  | Original | A590540F | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  [NAME] ;  Total Work ; |  |  | Original | A590541J | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  [NAME]-residential ;  Total Work ; |  |  | Original | A590542K | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
Total value of building jobs ;  Chain Volume Measures ;  Northern Territory ;  Total (Type of Building) ;  Total Work ; |  |  | Original | A590543L | 1985-09-01 00:00:00 | 2013-06-01 00:00:00 | 112 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: 779458d1651789759-sumproduct-with-named-ranges-indirect-and-multiple-criteria-sales-2022-phone-stats-to-get-formula
Sheet: February

2022 | Inbound Sales
Date | Handled ACD Calls | [NAME] | Total Calls Rcd | [NAME] | [NAME] (sec) | [NAME] (sec) | Max Wait Time (sec) | Avg Wrap Time | Avg Call Time (sec) | Connect And Sell OB Calls | Outbound Calls
2022-01-30 00:00:00
 | 0 |  |  |  |  |  |  | 0
 | 366 | 41 |  |  | 157 | 152 | 976 |  | 249 | 501 | 452
 | 317 | 32 |  |  | 184 | 133 | 1074 |  | 292 | 477 | 385
 | 281 | 32 |  |  | 181 | 147 | 795 |  | 272 | 568 | 368
 | 274 | 38 |  |  | 122 | 171 | 842 |  | 272 | 401 | 313
Week TTL
 | 357 | 74 |  |  | 308 | 278 | 829 |  | 292 | 446 | 239
 | 321 | 72 |  |  | 394 | 269 | 1017 |  | 318 | 478 | 314
 | 368 | 127 |  |  | 423 | 327 | 1167 |  | 172 | 71 | 291
 | 376 | 168 |  |  | 470 | 387 | 1496 |  | 221 | 159 | 299
 | 354 | 91 |  |  | 361 | 301 | 1297 |  | 232 | 260 | 285
Week TTL
 | 294 | 122 |  |  | 413 | 321 | 1079 |  | 135 | 288 | 353
 | 374 | 47 |  |  | 251 | 208 | 1008 |  | 189 | 119 | 313
 | 386 | 119 |  |  | 406 | 309 | 1687 |  | 288 | 332 | 300
 | 339 | 67 |  |  | 252 | 255 | 883 |  | 179 | 427 | 358
 | 308 | 54 |  |  | 100 | 185 | 1003 |  | 237 | 343 | 435
Week TTL
 | 293 | 21 |  |  | 107 | 126 | 1141 |  | 268 | 516 | 366
 | 358 | 63 |  |  | 333 | 220 | 909 |  | 245 | 335 | 384
 | 345 | 104 |  |  | 365 | 280 | 1163 |  | 347 | 550 | 361
 |  | 32 |  |  | 215 | 330 | 991.15 |  | 877 | 573 | 0
 |  | 27 |  |  | 307 | 271 | 1050 |  | 622 | 505 | 0
Week TTL
 |  | 50 |  |  |  |  |  |  |  | 268 | 0
 |  | 0 |  | 0 |  |  |  | 0
 |  | 0 |  | 0 |  |  |  | 0
 |  | 0 |  | 0 |  |  |  | 0
 |  | 0 |  | 0 |  |  |  | 0
 |  | 0 |  | 0 |  |  |  | 0
Week TTL
Month TTL
Spreadsheet: 163484d1340321910-date-formula-not-working-datedrag
Sheet: PRIMARY MECHANICAL

STATION 103 | 2012-07-01 00:00:00 |  | 2012-07-02 00:00:00 |  | 2012-07-03 00:00:00 |  | 2012-07-04 00:00:00 |  | 2012-07-05 00:00:00 |  | 2012-07-06 00:00:00 |  | 2012-07-07 00:00:00 |  | 2012-07-08 00:00:00 |  | 2012-07-09 00:00:00 |  | 2012-07-10 00:00:00
Shift | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
Mileage
Vehicle
Medics #
INSPECT FOLLOWING | ENTER A "Y" FOR YES (THIS ITEM IS OK) OR "N" FOR NO (THIS ITEM IS NOT OK)
Fuel Level
Coolant Level
Brake Fluid Level
Power Steering Fluid Level
Motor Oil
[NAME]
Radiator Hoses
Battery & Cables
Belts
Engine Starts
INTERIOR | ENTER A "Y" FOR YES (THIS ITEM IS OK) OR "N" FOR NO (THIS ITEM IS NOT OK)
Toughbook computer
Radio
[NAME]
Interior Lights
[NAME]
Garage Door Opener
Spot Light
Horn
[NAME]
Compartment Lights
Compartment Heat / AC
Cab AC / Heater / Blower Fan
EXTERIOR | ENTER A "Y" FOR YES (THIS ITEM IS OK) OR "N" FOR NO (THIS ITEM IS NOT OK)
Emergency Lights
Opticom
[NAME]
[NAME]
Headlights (High & Low Beam)
Turn Signals
Four-Way Flashers
Tail Lights
Brake Lights
Back-up Lights & Alarm
Deer Whistles
[NAME] | ENTER A "Y" FOR YES (THIS ITEM IS OK) OR "N" FOR NO (THIS ITEM IS NOT OK)
Vehicle Registration
Insurance
Fuel Card
Airport Access Card
BODY INSPECTION:
Driver Side | y | y | y | y | y | y | y | y | Y | y | Y | y | y | Y | y | Y | y | y | y | y | y | y | y | y | Y | Y | y | y | y | Y | y | Y | y | y | y | y | y | y | y | y | y | y | y | y | y | y | y | y | y | y | y | y | y | y | y | y
Passenger Side
Front
Rear
Rear Bumper
Hood & Roof
Tires and Wheels
Spreadsheet: 673811d1587551839-is-there-a-way-to-simplify-sumif-formulas-across-multiple-sheets-home-finance-2020
Sheet: DA

 | Janurary |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges
 |  |  |  |  |  |  |  |  |  | Total
 | Discover |  |  |  |  |  |  |  |  | Prior Year
 | Month | Day | Transaction | Category | Description | Subcategory | Amount | Paid
Spreadsheet: 598282d1542358144-smallest-value-for-conditions-example
Sheet: Sheet1

Country | Location | Colour | Value
poland | warsaw | red apple | 20
poland | poznan | blue apple | 30
poland | warsaw | red apple | 10
poland | poznan | blue apple | 40
germany | xyz | orange juice | 50 |  |  | Provide Country: | poland
 |  |  |  |  |  | Provide Colour | blue apple
 |  |  |  |  |  | example
 |  |  |  |  |  | smallest value for provided country "H6" & "H7"
 |  |  |  |  |  | smallest value for Poland & red apple = 10
 |  |  |  |  |  | smallest value for Poland & blue apple = 30
 |  |  |  |  |  | smallest value for Poland & red apple = 10
 |  |  |  |  |  | =[NAME]H6)*($C$4:$C$18=H7),$D$2:$D$18))
 |  |  |  | [NAME] from samba_ravi
 |  |  |  |  | > instead of 30 it should return -> "poznan" (other result in same row)
 |  |  |  |  | Probably it would be index command or index.match but i am still not good enough for it [NAME]
Spreadsheet: 2cf43693-4b29-4a66-9cf1-8d916408210d
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
RA1M | Test | RA1M | Alpha-1-Microglobulin, Random, [NAME] | Alpha-1-Microglobulin, Random, U | CTUR/24017: Enzymatic Colorimetric Assay AIMR/24015: Immunonephelometry | [NAME]: Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <50 years: <13 mg/g creatinine > or =50 years: <20 mg/g creatinine | Varies; 8 a.m.-4 p.m. | 1 day | 7 days | 1 | 83883 |  |  |  |  | Rochester
RA1M | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
RA1M | Component | CTUR | Creatinine Concentration, [NAME] | [NAME] | For further information see CTU/8513 Creatinine, [NAME]. | [NAME]: Urine |  |  | 5 | mL | 5 mL from a random urine collection. No preservative.  Send specimen refrigerated in a plastic, 6 mL urine tube.  For further information see #8513 "Creatinine, [NAME]." | 1.0 mL |  | For further information see #8513 "Creatinine, [NAME]." |  |  |  |  |  |  |  | Yes | Yes (order CTU)
CTUR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CTUR | Result | CTUR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1
RA1M | Component | AIMR | Alpha-1-Microglobulin, Random, [NAME] | Alpha-1-Microglobulin, Random, U | Only orderable as part of a profile. For further information see #84448 "Alpha-1-Microglobulin, Random, [NAME]." | [NAME]: Urine |  |  | 5 | mL | Only orderable as part of a profile. For further information see #84448 "Alpha-1-Microglobulin, Random, [NAME]." | 4.00 mL |  | Only orderable as part of a profile. For further information see #84448 "Alpha-1-Microglobulin, Random, [NAME]." |  |  |  |  |  |  |  | Yes | No
AIMR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
AIMR | Result | A1M_U | Alpha-1-Microglobulin, Random, U | Alpha-1-Microglobulin, Random, U | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 46723-3
AIMR | Result | A1M_R | A1M/Creat Ratio | A1M/Creat Ratio | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 48415-4
Spreadsheet: 883873d1732628396-xlookup-to-find-more-than-one-value-jacc14-xlookup-2-spill-365-aligw
Sheet: Sheet1

 |  |  |  |  |  |  | Lookup D column 81
 |  |  | code
 |  |  | 55 | dog |  |  | result
 |  |  | 61 | cat |  |  | 81
 |  |  | 81 | [NAME] |  |  |  | duck
 |  |  | 55 | dog |  |  |  | [NAME]
 |  |  | 81 | cat
 |  |  | 81 | duck
 |  |  | 22
Spreadsheet: larry_campbell__21009__PCB Graphs
Sheet: 63.26A

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 2000-06-21 00:00:00 |  |  | 27 |  | Sherwood
63.26 A Side |  |  | 2000-06-27 00:00:00 |  |  | 24 |  | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 20 |  | Sherwood
 |  |  | 2000-07-26 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2000-08-23 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-09-06 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2000-11-08 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2001-02-14 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2001-03-14 00:00:00 |  |  | 10 |  | Sherwood
 |  |  | 2001-04-18 00:00:00 |  |  | 6 |  | Sherwood
 |  |  | 2001-05-08 00:00:00 |  |  | 4 |  | Sherwood
 |  |  | 2001-06-12 00:00:00 |  |  | 3 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 90091d1289845819-find-top-5-most-popular-test
Sheet: Summary

 |  | Total taught |  |  |  |  | Most popular
 |  | [NAME] | Amount |  |  |  | [NAME] | Amount
 |  | Maths1 |  |  |  |  |  |  |  | <- Trying to grab the lesson name from 'Total taught' table (C7-C18) automatically, based on the amount shown in cells I7-I11
 |  | Maths2
 |  | Maths3
 |  | English1
 |  | English2
 |  | English3
 |  | Science1
 |  | Science2
 |  | Science3
 |  | History1
 |  | History2
 |  | History3
Spreadsheet: 692634d1598470513-formula-to-evaluate-two-criteria-and-pull-data-if-both-met-scheduling-dummy-file
Sheet: Printable Schedule

 |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
Server Name | Shift | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
 | AM
 | MID
 | PM
Spreadsheet: 220377d1363134219-copy-data-from-other-sheets-by-typing-in-unique-identifier-from-them-example
Sheet: Main

FOOD | MAIN INGREDIENT | WEIGHT | UNIQUE CODE | PRICE
 |  |  | Fruit03
 |  |  | Pie04
 |  |  | Juice02
 |  |  | Sandwich01
 |  |  | ^ I want to be able to Type in the unique Code from any of The other sheets into This column, And copy the whole row if It matches
 |  |  | e.g. Type in “Pie03”, And that whole ham pie Row copies to this Sheet as pure text