tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e55d5ff1-cd83-4a82-81fc-569156f00a9f
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
FPOS | Test | FPOS | Posaconazole | Posaconazole (POS) | [NAME] dilution |  |  |  |  |  | Container/Tube: Agar slant or other appropriate media [NAME] Organism in pure culture  Collection Instructions: 1.	Organism must be in pure culture, actively growing.  2.	Place specimen in a large infectious container (Supply T146) and label as an etiologic agent. |  | Specimens other than	Actively growing mold in pure culture Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Test Performed by:  U.T. Health Science Ctr San Antonio                                        7703 [NAME]Department of Pathology                                        Fungal Lab                                        San Antonio, TX 78229-3900 | Monday | 4-10 days | 6-12 days |  | Profile |  |  |  |  | U.T. Health Science Ctr San Antonio
FPOS | [NAME] | VARIES | Varies |  |  |  | Ambient
FPOS | Order Question | Z2202 | Source |  | Plain Text
FPOS | Order Question | Z2201 | Received as (Organism) |  | Plain Text
FPOS | Result | Z2202 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPOS | Result | Z2201 | Received as (Organism) | Received as (Organism) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPOS | Result | [NAME] | Result | Result | Alphanumeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
FPOS | Result | Z2207 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPOS | Billing Component | FPOS |  | microdilution or agar dilution, minimum lethal concentration |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87187
FPOS | Billing Component | FPOS |  | microdilution or agar dilution |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87186
FPOS | Billing Component | FPOS |  | macrobroth dilution method |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87188
Spreadsheet: 112931d1308889697-populating-cells-based-on-drop-box-newpc
Sheet: Custom Chart

 |  |  | CPU |  | MOBO |  | PSU |  | GPU |  | RAM |  | HDD |  | Sound |  | Case |  | ODD |  | OS
 |  |  | Intel Core i7 2600K | 315 | [NAME] 3 | 350 | Corsair Enthusiast TX750 | 110 | ATI Radeon HD 5850 (HIS) | 165 | [NAME] Series 16GB | 150 | WD Caviar Black 1TB 7200RPM 32MB Cache | 85 | [NAME] | 0 | Antec Twelve Hundred V3 | 160 |  |  | Win 7 Professional 64-bit
 |  |  | Intel Core i7 2500K | 220 | Asus P8P67 Deluxe Rev 3 | 220 | Thermaltake TPX-775M | 120 | ATI Radeon HD 5770 (MSI) | 140 | Corsair Vengeance [NAME] 2133 | 100 | WD [NAME] 7200RPM 64MB Cache | 80 |  |  | [NAME] PC-K63 | 100 |  |  | Win 7 Home Edition 64-bit
 |  |  |  |  | Asrock P67 Extreme 6 | 190 |  |  |  |  | Corsair Vengeance [NAME] 1600 | 87 |  |  |  |  | CM Storm Sniper | 150
 |  |  |  |  | Asrock P67 Extreme 4 | 160 |  |  |  |  | [NAME] X Series 8GB [NAME] 1600 | 84
CPU: | Intel Core i7 2600K
MB: | [NAME] 3
PSU: | Thermaltake TPX-775M
[NAME]: | ATI Radeon HD 5850 (HIS)
RAM: | [NAME] X Series 8GB [NAME] 1600
HDD: | WD Caviar Black 1TB 7200RPM 32MB Cache
Sound: | [NAME]
Case: | Antec Twelve Hundred V3
ODD:
OS: | Win 7 Professional 64-bit
Spreadsheet: 874934d1721451974-indirect-search-and-retrieve-data-test-workbook
Sheet: LabelSheet

 |  | I am using an indirect function to select the data sheet, C8 will be a drop down list of data sheets. I need to incorporate a Lookup function. The fiber numbers in the data sheet are not all populated, but this sheet all fibers 1-864 will be laid out. I need to search by the fiber numbers in rows 10,16,22,28 and populate the distance, and code info from the data sheet.
[NAME] number will be hard coded 1-36 on each, the fiber numbers will be hard coded 1-864
 | INDIRECT> | AAAAAA-BBBBBB
 | [NAME] | 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 |  | 33 |  | 34 |  | 35 |  | 36
 | fib num | 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 |  | 33 |  | 34 |  | 35 |  | 36
 | distance
 | code
 |  | 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 |  | 33 |  | 34 |  | 35 |  | 36
 |  | 37 |  | 38 |  | 39 |  | 40 |  | 41 |  | 42 |  | 43 |  | 44 |  | 45 |  | 46 |  | 47 |  | 48 |  | 49 |  | 50 |  | 51 |  | 52 |  | 53 |  | 54 |  | 55 |  | 56 |  | 57 |  | 58 |  | 59 |  | 60 |  | 61 |  | 62 |  | 63 |  | 64 |  | 65 |  | 66 |  | 67 |  | 68 |  | 69 |  | 70 |  | 71 |  | 72
 |  | 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 |  | 33 |  | 34 |  | 35 |  | 36
 |  | 73 |  | 74 |  | 75 |  | 76 |  | 77 |  | 78 |  | 79 |  | 80 |  | 81 |  | 82 |  | 83 |  | 84 |  | 85 |  | 86 |  | 87 |  | 88 |  | 89 |  | 90 |  | 91 |  | 92 |  | 93 |  | 94 |  | 95 |  | 96 |  | 97 |  | 98 |  | 99 |  | 100 |  | 101 |  | 102 |  | 103 |  | 104 |  | 105 |  | 106 |  | 107 |  | 108
 |  | 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 |  | 33 |  | 34 |  | 35 |  | 36
 |  | 109 |  | 110 |  | 111 |  | 112 |  | 113 |  | 114 |  | 115 |  | 116 |  | 117 |  | 118 |  | 119 |  | 120 |  | 121 |  | 122 |  | 123 |  | 124 |  | 125 |  | 126 |  | 127 |  | 128 |  | 129 |  | 130 |  | 131 |  | 132 |  | 133 |  | 134 |  | 135 |  | 136 |  | 137 |  | 138 |  | 139 |  | 140 |  | 141 |  | 142 |  | 143 |  | 144
Spreadsheet: 27562d1220907138-filtering-and-duplicates-dupfilterhelp
Sheet: Sheet1

Date | Firm Name | Analyst | Person ID | Job ID | Trans Firm | Ticker
2008-08-12 00:00:00 | Company 1 | [NAME] | 37222 | xxx | ACME Communications, Inc. | ACME
2008-08-19 00:00:00 | Company 1 | [NAME] | 37222 | xxx | Russ Berrie & Co., Inc. | RUS
2008-07-23 00:00:00 | Company 2 | [NAME] | 46549 | xxx | Air Products & Chemicals, Inc | APD
2008-07-24 00:00:00 | Company 2 | [NAME] | 46549 | xxx | Airgas, Inc. | ARG
2008-07-22 00:00:00 | Company 3 | [NAME] | 46549 | xxx | [NAME] | DD
2008-07-24 00:00:00 | Company 2 | [NAME] | 46549 | xxx | The Dow Chemical Co. | DOW
2008-07-25 00:00:00 | Company 2 | [NAME] | 46549 | xxx | The Dow Chemical Co. | DOW
2008-07-25 00:00:00 | Company 2 | [NAME] | 46549 | xxx | Eastman Chemical Co. | EMN
2008-07-23 00:00:00 | Company 2 | [NAME] | 46549 | xxx | Praxair, Inc. | PX
2008-08-05 00:00:00 | Company 2 | [NAME] | 46549 | xxx | Westlake Chemical Corp. | WLK
2008-08-08 00:00:00 | Company 4 | [NAME] | 51166 | xxx | Brooks Automation, Inc | BRKS
2008-08-08 00:00:00 | Company 4 | [NAME] | 51166 | xxx | MedCath Corp. | MDTH
2008-07-30 00:00:00 | Company 5 | [NAME] | 54982 | xxx | The Walt Disney Co | DIS
2008-07-29 00:00:00 | Company 5 | [NAME] | 54982 | xxx | DreamWorks Animation SKG Inc | DWA
2008-08-05 00:00:00 | Company 5 | [NAME] | 54982 | xxx | Six Flags, Inc. | SIX
2008-08-27 00:00:00 | Company 5 | [NAME] | 54982 | xxx | TiVo, Inc. | TIVO
2008-07-28 00:00:00 | Company 6 | [NAME] | 64029 | xxx | Silicom Ltd. | SILC
2008-08-08 00:00:00 | Company 7 | Mark | 70520 | xxx | Delek US Holdings, Inc. | DK
2008-08-28 00:00:00 | Company 7 | Mark | 70520 | xxx | Fred's, Inc | FRED
2008-08-19 00:00:00 | Company 7 | Mark | 70520 | xxx | Target Corp. | TGT
2008-08-20 00:00:00 | Company 7 | Mark | 70520 | xxx | Target Corp. | TGT
Spreadsheet: 3bb01a4e-fbcd-486c-9c68-64faeae8d9fe
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | 2009 NEW MEXICO ENERGY CONSERVATION CODE
 | PASSIVE SOLAR HEATING WORKSHEET
 |  | Project ID |  |  |  |  | Date
 |  | Builder Name
 |  | Builder Address
 |  | Submitted By |  |  |  |  | Phone
 |  | Building Address
 |  | Items meeting the listed criteria may be presented for simplified code compliance as solar features. All boxes by the system type definitions must be checked to certify compliance. The area in square feet of such features should be entered here and on the Tradeoff Worksheet with the other wall components. [NAME] A/Ro columns may be left blank on the Tradeoff Worksheet for these solar features.
 |  | All Solar Features
 |  |  | Orientation within 25° east and 15° west degrees of true South
 |  |  | No significant obstructions to sun above 25° elevation, from bottom of feature
 |  |  | No significant obstructions to sun within 45° horizontal from the east and west edges of the solar feature
 |  |  | Solar features of all kinds no greater than 20% of heated floor area
 |  |  | N + E + W windows not greater than 12% of heated floor area
 |  |  | Overhangs that prevent sun on south-facing glazing on June 21st
 |  | Direct Gain
 |  |  | Double glazed (minimum)
 |  |  | If South windows greater than 8% of heated floor area, add thermal mass (at least 5x area of South glazing, at least 3” thick)
 |  |  | TOTAL AREA DIRECT GAIN GLAZING |  |  |  |  | ft2
 |  | Solar Mass Wall
 |  |  | Solid masonry wall, no vents
 |  |  | TOTAL AREA MASS WALL GLAZING |  |  |  |  | ft2
 |  | Attached Sunspace
 |  |  | Double glazed (minimum)
 |  |  | Mass area at least 3x glazing area
 |  |  | Operable windows or doors to living space, at least 15% of  sunspace glazing area
 |  |  | TOTAL AREA SUN SPACE GLAZING |  |  |  |  | ft2
 |  | Note: This applications manual is not a solar heating design guide. The inclusion of solar features meeting the above definitions does not by guarantee correct solar heating performance for a building design. For example, solar features totaling 20% of heated floor area, while allowed by this manual, may be excessive in many applications. Passive solar heating features should be designed using appropriate design tools.
Spreadsheet: 818367d1676769605-i-cant-have-my-formula-to-also-spill-to-other-columns-but-rows-dummydata-helpplease
Sheet: Totals

Desired Input | For desired input, I want to only use a single formula so I don't drag it to the right in case times extend.
 | Date |  | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 1900-01-01 00:00:00 | 1900-01-01 00:30:00 | 1900-01-01 01:00:00 | 1900-01-01 01:30:00 | 1900-01-01 02:00:00 | 1900-01-01 02:30:00 | 1900-01-01 03:00:00 | 1900-01-01 03:30:00 | 1900-01-01 04:00:00 | 1900-01-01 04:30:00 | 1900-01-01 05:00:00 | 1900-01-01 05:30:00 | 1900-01-01 06:00:00 | 1900-01-01 06:30:00
 | 2023-02-14 00:00:00
 | 2023-02-15 00:00:00
 | 2023-02-16 00:00:00
 | 2023-02-17 00:00:00
 | 2023-02-18 00:00:00
 | 2023-02-19 00:00:00
Spreadsheet: 93953d1293717573-format-specific-cells-of-a-listbox-registroventas
Sheet: Hoja1

Nombre | [NAME] venta | Fecha venta | Articulo | Cant. | unid | [Bs/unid] | Importe [Bs] | Estado comisión | Fecha comisión
[NAME] | Diciembre | 2010-12-21 19:15:59 | fgfg | 8 | UN | 678 | 5424 | Por pagar
[NAME] | Diciembre | 2010-12-21 19:21:56 | rt | 6 | UN | 6 | 36 | Por pagar
[NAME] | Diciembre | 2010-12-21 20:34:37 | fth | 8 | UN | 78 | 624 | Por pagar
[NAME] | Diciembre | 2010-12-21 22:03:41 | uuuuuuuuu | 54 | UN | 67 | 3618 | Por pagar
[NAME] | Diciembre | 2010-12-21 22:03:57 | dfrrrrrrrrrrr | 45 | UN | 8 | 360 | Por pagar
Claudia [NAME] Guerra | Diciembre | 2010-12-21 22:27:24 | bbbbbbbbbbbbbbbbb | 19 | UN | 15 | 285 | Por pagar
Claudia [NAME] Guerra | Diciembre | 2010-12-21 22:28:21 | rrrrrrrrrrrrrrrrrrrrrrrrrrrrr | 45 | UN | 15 | 675 | Por pagar
[NAME] | Diciembre | 2010-12-21 23:06:58 | nnnnnnnnnnnnnnn | 7 | UN | 67 | 469 | Por pagar
[NAME] | Diciembre | 2010-12-21 23:07:08 | zzzzzzzzzzzzzzzzz | 90 | UN | 56 | 5040 | Por pagar
Claudia [NAME] Guerra | Diciembre | 2010-12-21 23:07:52 | qqqqqqqqqqqqqqqq | 7 | UN | 56 | 392 | Por pagar
Claudia [NAME] Guerra | Diciembre | 2010-12-21 23:08:03 | ccccccccccccccccc | 23 | UN | 34 | 782 | Por pagar
[NAME] | Diciembre | 2010-12-21 23:57:37 | rtrtrtrttrtrtrtrtrtr | 9 | UN | 678 | 6102 | Por pagar
[NAME] | Diciembre | 2010-12-22 00:00:06 | ñññññññññññññññññññññññññññ | 45 | UN | 45 | 2025 | Por pagar
Paola  Sanjines | Diciembre | 2010-12-23 00:00:00 | sdfg | 5 | UN | 5 | 25 | Por pagar
Alejandro Del Villar | Diciembre | 2010-12-23 00:00:00 | iiiiiiiiiiiiiiiiiiiiiiiii | 655 | UN | 7 | 4585 | Por pagar
Claudia [NAME] Guerra | Diciembre | 2010-12-23 00:00:00 | zzzzzzzzzzzzzzzz | 45 | UN | 5 | 225 | Por pagar
[NAME] | Diciembre | 2010-12-25 00:00:00 | rtrtrtretertertertertertertertert | 5 | UN | 44 | 220 | Por pagar
[NAME] | Diciembre | 2010-12-25 00:00:00 | rrrrrrfffffffffqqqqqqq | 33 | UN | 22 | 726 | Por pagar
[NAME] | Diciembre | 2010-12-26 00:00:00 | qqqqqqqqqqqwwwwwwwwwwww | 33 | UN | 22 | 726 | Por pagar
[NAME] | Diciembre | 2010-12-26 00:00:00 | eeeeeeeerrrrrrrrr | 22 | UN | 11 | 242 | Por pagar
Spreadsheet: 785562d1656495693-night-differential-calculation-book1
Sheet: Sheet1

Employee
 |  |  |  |  |  |  |  |  |  |  | Night Diff
Date | Day | Duty Schedule |  | In | Out | RD |  | L | UN | OT | ND | Remarks
 |  | From | To |  |  |  | min. |  |  | hr.
2022-06-11 00:00:00
2022-06-12 00:00:00
2022-06-13 00:00:00 |  | 18:00:00 | 04:00:00 | 18:23:00 | 03:11:00 | 8 |  |  |  |  | 5
2022-06-14 00:00:00 |  | 18:00:00 | 04:00:00 | 18:53:00 | 04:53:00 | 8 |  |  |  |  | 6
2022-06-15 00:00:00
2022-06-16 00:00:00
2022-06-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Last Day of Service (Resigned)
2022-06-18 00:00:00
2022-06-19 00:00:00
2022-06-20 00:00:00 |  | 09:00:00 | 19:00:00
2022-06-21 00:00:00 |  | 09:00:00 | 19:00:00
2022-06-22 00:00:00 |  | 09:00:00 | 19:00:00
2022-06-23 00:00:00 |  | 09:00:00 | 19:00:00
2022-06-24 00:00:00 |  | 09:00:00 | 19:00:00
2022-06-25 00:00:00
Night Differential Hours |  | 22:00:00
 |  | 06:00:00
Spreadsheet: 557122d1516442331-how-to-move-data-in-columns-below-another-set-of-columns-book1-5-
Sheet: New Request 2 var A

[NAME] | Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | Col 7 | Col 8 | Col 9 |  |  | [NAME] | Col 1 | Col 2 | Col 3
AAA | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
BBB | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
CCC | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
Spreadsheet: 115158d1310751272-difficult-lookup-sum-nesting-formula-notanexcelguy_sample
Sheet: Lookups

Names |  | Platforms |  | Months
Sixt |  | NCT - Bus Solutions-IP Analyst |  | 2000-01-01 00:00:00
[NAME] |  | NCT - Bus Solutions-Platform Analyst (RM/TX/HX) |  | 2000-02-01 00:00:00
[NAME] |  | NCT - Bus Solutions-Platform Analyst (ST/GN) |  | 2000-03-01 00:00:00
Roberson |  | NCT - Bus Solutions-ATM Analyst |  | 2000-04-01 00:00:00
Payne |  | NCT - Bus Solutions-Horizontal |  | 2000-05-01 00:00:00
Myers |  | NCT - Bus Solutions-Platform Analyst (IM) |  | 2000-06-01 00:00:00
[NAME] |  | NCT - Bus Solutions-DREM Analyst |  | 2000-07-01 00:00:00
[NAME] |  | NCT - Bus Solutions- Platfrom Analyst (IP) |  | 2000-08-01 00:00:00
Hedquist |  |  |  | 2000-09-01 00:00:00
Gradney |  |  |  | 2000-10-01 00:00:00
Frazier |  |  |  | 2000-11-01 00:00:00
Folse |  |  |  | 2000-12-01 00:00:00
Fater
Donnell
Clements
Chisholm
Bali
Atkinson
Althoff
Spreadsheet: 377830d1424181924-how-to-filter-out-the-last-ten-values-and-find-how-many-times-it-exceeds-x-sample_2
Sheet: Sheet2

A |  | 40
B |  | 35
A |  | 30
B |  | 25 |  |  |  |  |  | Exceeds | A | B | C
A |  | 20 |  |  |  |  |  | between 0 and 5
B |  | 15 |  |  |  |  |  | between 5 and 10
A |  | 10 |  |  |  |  |  | between 10 and 20
B |  | 5 |  |  |  |  |  | over 20
C |  | 15
A |  | 8
B |  | 10
A |  | 21
C |  | 7
A |  | 3
B |  | 18
A |  | 10
B | 2015-02-17 00:00:00 | 11
Spreadsheet: 715514d1611749474-how-to-automate-dates-in-excel-calendar-q-calendar-2021
Sheet: MASTER

 | JANUARY 2021
Sat
Sun
Mon
Tue
Wed
Thu
Fri | 1. PH: New Years Day
Sat | 2.
Sun | 3.
Mon | 4.
Tue | 5.
Wed | 6.
Thu | 7.
Fri | 8.
Sat | 9.
Sun | 10.
Mon | 11.
Tue | 12.
Wed | 13.
Thu | 14.
Fri | 15. |  | Q | Is there a way to get the date number automatic (i.e. drag down and autopopulate) in this format (i.e. small font with a dot to the left of the cell? Currently I am entering them in individually.
Sat | 16.
Sun | 17.
Mon | 18.
Tue | 19.
Wed | 20.
Thu | 21.
Fri | 22.
Sat | 23
Sun | 24.
Mon | 25.
Tue | 26.  PH: Australia Day
Wed | 27.
Thu | 28.
Fri | 29.
Sat | 30 .
Sun | 31.
Spreadsheet: 800426d1665664414-formula-to-return-multiple-matches-training-courses
Sheet: 2022.2023

W/C | Course Name | wk | Trainee Name | Result | Training Location
2022-09-20 00:00:00 | Delegate Examiner LGV | Wk 2 | [NAME] | Attended | [NAME]
2022-05-23 00:00:00 | [NAME] | Wk 1 | [NAME] | Completed - Week 1 | Leconfield
2022-05-30 00:00:00 | [NAME] | Wk 2 | [NAME] | Pass | Leconfield
2022-06-06 00:00:00 | CPC Training Group | Wk 1 | [NAME] | Pass | [NAME]
2022-05-16 00:00:00 | LDTM Supervision | Wk 1 | [NAME] | Completed - Week 1 | Avonmouth
2022-05-23 00:00:00 | LDTM Supervision | Wk 2 | [NAME] | Pass | Avonmouth
2022-04-04 00:00:00 | New Entrant X Mod 2 | Wk 3 | [NAME] | Completed - Week 3 | Leeds
2022-04-11 00:00:00 | New Entrant X Mod 2 | Wk 4 | [NAME] | Pass | Leeds
2022-09-20 00:00:00 | MC Development Week | Wk 3 | [NAME] | Pass | [NAME]
2022-09-12 00:00:00 | New Entrant I Mod 1 | Wk 1 | [NAME] | Attended | Virtual
2022-09-20 00:00:00 | New Entrant I Mod 2 | Wk 1 | [NAME] | Completed - Week 1 | Avonmouth
2022-09-26 00:00:00 | New Entrant I Mod 2 | Wk 2 | [NAME] | Further Development Needed | Avonmouth
2022-10-03 00:00:00 | New Entrant I Mod 2 | Wk 2 | [NAME] | Completed - Week 2 | Avonmouth
2022-10-10 00:00:00 | New Entrant i Mod 2 | Wk 3 | [NAME] |  | Avonmouth
2022-08-08 00:00:00 | New Entrant G Mod 1 | Wk 1 | [NAME] | Attended | Virtual
2022-08-15 00:00:00 | New Entrant G Mod 2 | Wk 1 | [NAME] | Completed - Week 1 | Brentwood
2022-08-22 00:00:00 | New Entrant G Mod 2 | Wk 2 | [NAME] | Completed - Week 2 | Brentwood
2022-08-29 00:00:00 | New Entrant G Mod 2 | Wk 3 | [NAME] | Further Development Needed | Brentwood
2022-09-05 00:00:00 | New Entrant G Mod 2 | Wk 3 | [NAME] | Further Development Needed | Brentwood
2022-09-12 00:00:00 | New Entrant G Mod 2 | Wk 5 | [NAME] | Further Development Needed | Brentwood
2022-10-03 00:00:00 | New Entrant I Mod 2 | Wk 3 | [NAME] | Completed - Week 3 | Brentwood
2022-10-10 00:00:00 | New Entrant i Mod 2 | Wk 4 | [NAME] |  | Brentwood
2022-04-04 00:00:00 | LDTM Supervision | Wk 1 | [NAME] |  | Slough
2022-04-11 00:00:00 | LDTM Supervision | Wk 1 | [NAME] | FTC | Slough
2022-08-29 00:00:00 | New Entrant H Mod 1 | Wk 1 | [NAME] | Attended | Virtual
2022-09-05 00:00:00 | New Entrant H Mod 2 | Wk 1 | [NAME] | Completed - Week 1 | Cambridge
2022-09-12 00:00:00 | New Entrant H Mod 2 | Wk 2 | [NAME] | Completed - Week 2 | Cambridge
2022-09-20 00:00:00 | New Entrant H Mod 2 | Wk 3 | [NAME] | Completed - Week 3 | Cambridge
2022-09-26 00:00:00 | New Entrant H Mod 2 | Wk 4 | [NAME] | Pass | Cambridge
Spreadsheet: 825913d1681638342-using-mod-and-if-to-find-cell-value-vs-reference-and-show-if-divisible-but-i-have-an-issue-newsample_ceepeebee
Sheet: Scenario 2 - not working

Week Date | 2023-05-04 00:00:00
Name | Team | Starting Weight | Starting Height | Starting BMI | Concurrent Week Losses | Hat-Trick | 2023-04-06 00:00:00
 |  |  |  |  |  |  | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg)
Stephan | White | 129 | 180 |  | 0 |  | 128 | 128 | 126 | 125 | 125
Stephan has lost weight 3 times in total since beginning, but has not lost weight this week compared to previous week - staying the same. This should NOT be a hat-trick as he was awarded that last week by hitting his 3rd total loss.
Spreadsheet: 86575d1286523207-i-need-a-formula-that-does-averages-only-if-a-certain-number-is-in-the-box-utahsample
Sheet: Sheet1

 |  | Team Jazz
 |  | 2 Pointers |  | 3 Pointers |  | Free Throws |  | Totals per game |  |  |  |  |  |  | Win/Losses |  | Score
 |  | Made | Attem. | Made | Attem. | Made | Attem. | Points |  | Reb | Assists | Steals | Blocks | TO's | W | L | Us | Them
Away | 1 | 39 | 62 | 5 | 12 | 31 | 34 | 124 |  | 45 | 25 | 3 | 4 | 12 | 1 |  | 124 | 95
Home | 2 | 37 | 64 | 6 | 21 | 26 | 30 | 118 |  | 48 | 21 | 18 | 8 | 16 | 1 |  | 118 | 82
Away | 3 | 33 | 73 | 7 | 21 | 15 | 19 | 102 |  | 53 | 28 | 8 | 6 | 4 | 1 |  | 102 | 74
Home | 4 | 30 | 75 | 4 | 12 | 11 | 22 | 83 |  | 32 | 18 | 9 | 6 | 5 |  | 1 | 83 | 111
Away | 5
Home | 6
Away | 7
Away | 8
Away | 9
Away | 10
Home | 75
Home | 76
Away | 77
Away | 78
Home | 79
Away | 80
Away | 81
Home | 82
 | HIGH | 39 | 75 | 7 | 21 | 31 | 34 | 124 |  | 53 | 28 | 18 | 8 | 16 |  |  | 124 | 111
 | LOW | 30 | 62 | 4 | 12 | 11 | 19 | 83 |  | 32 | 18 | 3 | 4 | 4 |  |  | 83 | 74
 | Totals | 139 | 274 | 22 | 66 | 83 | 105 | 427 |  | 178 | 92 | 38 | 24 | 37 | 3 | 1 | 427 | 362
 |  | Made | Attem. | Made | Attem. | Made | Attem. | Points |  | Reb | Assists | Steals | Blocks | TO's | W | L | Us | Them
 |  | 2 Pointers |  | 3 Pointers |  | Free Throws |  | Totals per game |  |  |  |  |  |  | Win/ Loss |  | Score
 |  | Season Totals
 |  | 2 Point % |  | 3 Point % |  | Free Throw % |  | FG % | PPG | RPG | APG | SPG | BPG | A TO's | W% |  | Us | Them
 |  | 0.5072992700729927 |  | 0.3333333333333333 |  | 0.7904761904761904 |  | 0.4735294117647059 | 106.75 | 44.5 | 23 | 38 | 6 | 9.25 | 0.75 |  | 106.75 | 90.5
 | At Home | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 49 |  |  | #N/A | #N/A
 | On Road | #N/A |  | #N/A |  | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A
 | In Wins
 | In Losses
 |  | 2 Point % |  | 3 Point % |  | Free Throw % |  | FG % | PPG | RPG | APG | SPG | BPG | A TO's | W% |  | Us | Them