tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 777213d1650263456-cant-get-dfunctions-to-work-tires
Sheet: Sheet1

[NAME] | Rehv | Hind
21 | Continental 165/70R14 VIKING CONTACT Lamell | 111.1 |  | Rehv | Hind | Hind
22 | Continental 165/70R14 WINTER VIKING Naast | 111.1 |  | Continental | >100 | <150 |  | 5) | a) |  |  |  | Rehv | Hind
23 | Continental 175/70R13 VIKING CONTACT Lamell | 102.2 |  | GoodYear |  |  |  |  |  |  |  |  | Continental | >100
24 | Continental 175/70R13 WINTER VIKING Naast | 102.2 |  | Michelin |  |  |  |  | b) |  |  |  | Michelin
25 | Continental 175/70R14 VIKING CONTACT Lamell | 115.6
26 | Continental 175/70R14 WINTER VIKING Naast | 115.6 |  | Rehv | Hind |  | Hind |  | c)
27 | Continental 185/70R14 VIKING CONTACT Lamell | 120 |  | Continental*Naast | <150 |  | >100
28 | Continental 185/70R14 WINTER VIKING Naast | 120 |  | Michelin*Naast |  |  | <150 |  | d) |  |  |  | Rehv | Hind
64 | GoodYear 185/55R14 | 100.9 |  |  |  |  |  |  |  |  |  |  | Continental*Naast | >100
65 | GoodYear 185/55R15 | 131.6 |  |  |  |  |  |  |  |  |  |  | Michelin*Naast
70 | GoodYear 185/70R14 | 104.2
102 | [NAME] 175/65 R 14 ALPIN [NAME] | 101.3
104 | [NAME] 175/65 R 14 X-ICE Lamell | 108.4
105 | [NAME] 175/65 R 15 ALPIN [NAME] | 110.8
115 | [NAME] 185/55 R 14 ALPIN [NAME] | 115.9
116 | [NAME] 185/55 R 15 ALPIN [NAME] | 116.5
117 | [NAME] R 14 ALPIN [NAME] | 104
118 | [NAME] R 15 ALPIN [NAME] | 108.7
119 | [NAME] 185/65 R 14 ALPIN [NAME] | 104.7
121 | [NAME] 185/65 R 14 X-ICE Lamell | 110.3
122 | [NAME] 185/65 R 15 ALPIN [NAME] | 108.1
123 | [NAME] 185/65 R 15 IVALO I2 Naast | 106.4
124 | [NAME] 185/65 R 15 X-ICE Lamell | 121
125 | [NAME] 185/65 R 14 | 106.4
126 | [NAME] 185/65 R 15 | 108.9
130 | [NAME] 195/55 R 15 ALPIN [NAME] | 144.3
131 | [NAME] 195/55 R 15 IVALO I2 Naast | 132.4
134 | [NAME] 195/60 R 15 ALPIN [NAME] | 122.4
136 | [NAME] 195/60 R 15 X-ICE Lamell | 133.6
137 | [NAME] 195/65 R 15 ALPIN [NAME] | 114
138 | [NAME] 195/65 R 15 IVALO I2 Naast | 109.2
139 | [NAME] 195/65 R 15 PILOT ALPIN PA2 Lamell | 135.6
140 | [NAME] 195/65 R 15 X-ICE Lamell | 130.2
141 | [NAME] 195/70 R 15 AGILIS 41 SNOW-ICE Lamell | 113.9
150 | Michelin 205/60 R 15 ALPIN [NAME] | 135.3
152 | Michelin 205/60 R 15 X-ICE Lamell | 149.9
156 | [NAME] 205/65 R 15 IVALO I2 Naast | 131
158 | [NAME] 205/65 R 15 X-ICE Lamell | 143.6
165 | Michelin 215/65 R 15 IVALO I2 Naast | 141.7
166 | Michelin 215/65 R 15 PILOT ALPIN PA2 Lamell | 146.7
Total |  | 4749.700000000001
Spreadsheet: 86190d1286220274-text-into-a-cell-2010-09-28-vendas-de-animais-janeiro-2010
Sheet: F4

CLIENTE |  | PE-EM |  |  |  | Nº CONTRIBUINTE |  |  |  |  | DATA |  | 2010-01-08 00:00:00
MORADA |  |  |  |  |  |  |  |  |  |  | PRAZO PAGAMENTO |  | 20 | DIAS
CIDADE |  |  |  |  |  | TIPO PAGAMENTO |  |  |  |  | VENCIMENTO
 |  |  |  |  | DATA RECEPÇÃO |  |  |  |  | Nº FACTURA |  | 169
REF. | DESCRIÇÃO |  |  |  | QUANTIDADE |  | PREÇO TON. |  |  |  | VALORES SEM IVA
 |  |  |  |  | Unidade | Kgs. | BGL |  | EUROS |  | BGL |  | EUROS
pabt |  |  |  |  | 150 | 26589 | 25
rabt |  |  |  |  | 10 | 12345 | 2.6
 |  |  |  | TOTAIS
 |  |  |  |  |  |  |  |  | IVA |  | 0.2
 |  |  |  |  |  |  |  |  | VALOR IVA
 |  |  |  |  |  |  |  |  | VALOR COM IVA
Spreadsheet: 791349d1660301920-help-with-sumproduct-countif-countifs-index-match-what-to-choose-count-help-with-expected-results1
Sheet: ExpectedResults

Doc_ID | All | SOP-02659 | SOP-04077 | WRK-00479 | WRK-00577 | WRK-01610 | WRK-01777 | WRK-02123 | WRK-03109 | WRK-03575 | WRK-04933
 | # of Rev
2015 |  | 3 | 4 |  |  | 1
2016 |  | 2 | 6 |  |  | 2
2017 |  | 3 | 7 | 1 | 2 | 1 | 1 | 1 | 4 | 2
2018 |  | 2 | 1 | 0 |  | 1 |  |  | 1 | 1
2019 |  | 2 | 1 | 1 |  |  |  |  |  | 2
2020 |  |  | 4 | 2 | 3 | 1 | 2 | 2 | 4 | 2
2021 |  |  | 0 |  |  |  |  |  | 1 |  | 1
2022 |  |  | 1 |  |  |  |  | 1 | 1
Null |  | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Sub Total
Total Training Events
2015 |  | 15 | 24 |  |  | 6
2016 |  | 14 | 49 |  |  | 27
2017 |  | 21 | 97 | 12 | 13 | 11 | 6 | 6 | 41 | 22
2018 |  | 15 | 11 |  |  | 3 |  |  | 11 | 12
2019 |  | 17 | 10 | 10 |  |  |  |  |  | 23
2020 |  |  | 44 | 25 | 18 | 8 | 14 | 6 | 42 | 20
2021 |  |  |  |  |  |  |  |  | 20 |  | 12
2022 |  |  | 35 |  |  |  |  | 11 | 5
Null |  | 12 | 1 | 10 | 13 | 5 | 6 | 4 | 11 | 11
Sub Total
Total Training Time in hours (sum of pages per doc/year * user count /60
2015 |  | 47.25 | 159.6 |  |  | 14.4
2016 |  | 45.73 | 1039.61 |  |  | 558.9
2017 |  | 101.15 | 4095.01 | 52.8 | 37.7 | 94.78 | 4.2 | 3.6 | 752.35 | 185.53
2018 |  | 50.75 | 48.4 |  |  | 6.9 |  |  | 62.51 | 93.6
2019 |  | 65.16 | 43.33 | 40 |  |  |  |  |  | 405.56
2020 |  |  | 522.13 | 265.83 | 75.6 | 50.12 | 40.12 | 4.2 | 933.1 | 360
2021 |  |  |  |  |  |  |  |  | 266.66 |  | 134.4
2022 |  |  | 449.16 |  |  |  |  | 18.15 | 15.41
Null |  | 8.16
Sub Total
Spreadsheet: 7df28b32-4acd-49b1-9751-550a4690f3fa
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
MCHZ | Test | MCHZ | Cheese, [NAME], IgE | Cheese, [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.70	Equivocal 2	0.71-3.5	Positive 3	3.51-17.5	Positive 4	17.6-50.0	Strongly positive 5	50.1-100.0	Strongly positive 6	> or =100.0	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
MCHZ | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
MCHZ | Result | MCHZ | Cheese, [NAME], IgE | Cheese, [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6068-1 | Cheese mold type [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 167838d1342115992-problem-with-formula-that-displays-contents-from-some-cells-but-not-others-pilotlog-sample
Sheet: Engine Log

G-BSGL |  |  |  |  |  |  |  | ENGINE LOG
 |  | Time run since new |  | Time run since top |  | Cycle run since new
TOTAL B/F | 49 days, 6:20:00 | or complete overhaul |  | overhaul |  | or complete overhaul | Particulars of Maintenance or othewr work carried out.
Date |  | Hours | Minutes | Hours | Minutes
 | Running
 | Total
 | Running
 | Total
 | Running
 | Total
 | Running
 | Total
 | Running
 | Total
Spreadsheet: 2e794531-290f-4cbf-a45d-6f65ea1ecafc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 47. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (TAS), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413748X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413749A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413750K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413751L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413752R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413753T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413754V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413755W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413756X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413757A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413758C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 859970d1708186346-display-value-if-criteria-is-met-and-specific-period-of-time-test
Sheet: Test

 |  | 2024-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Customer | Tag | Date
 |  | BLUE |  |  |  |  |  |  |  |  |  |  | CUSTOMER A | GREEN | 2024-02-02 00:00:00
 |  | Customers |  |  |  |  |  |  |  |  |  |  | CUSTOMER B | BLUE | 2024-01-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | CUSTOMER C | BLUE | 2024-01-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | CUSTOMER D | BLACK | 2024-01-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | CUSTOMER E | GREEN | 2023-12-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | CUSTOMER F | BLUE | 2024-01-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | CUSTOMER G | GREEN | 2023-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | CUSTOMER H | BLUE | 2023-12-10 00:00:00
Spreadsheet: 0d852e50-30dc-4f6f-ab02-3318f826fa4c
Sheet: Sheet1

Project Code | Lender Code | Borrower LoanNumber | Lender Name | Lender Contact | LenderMailAddress | LenderMailCity | LenderMailState | LenderMailZip | LenderContactPhone | LenderContactPhone2 | LenderContactEmailAddress | Borrower1 First Name | Borrower1 MiddleName | Borrower1 LastName | Borrower2 FirstName | Borrower2 MiddleInitial | Borrower2 LastName | NYSERDALoanAmount | LoanTerm | NoteRate | MonthlyPayment | OriginationDate | DateFirstPayment | MaturityDate | AnnualPercentageRate
1038 | 101 | 333000444 | Bank of America | C/O [NAME] | 1234 Any Street | Sometown | NY | 12345 | [PHONE] | [PHONE] | [EMAIL] |  |  | XYZ Corporation |  |  |  | 20000 | 96 | 0 | 208.33 | 2011-01-01 00:00:00 | 2011-02-05 00:00:00 | 2026-01-05 00:00:00 | 0
Spreadsheet: 831463d1685645429-sum-formula-stopped-working-book1
Sheet: Order of Merit

 |  | Colmworth | Oakland Park | Dunstable Downs | [NAME] |  | Daventry | Canons Brook | [NAME] |  | [NAME] | Drayton Park
No | MEMBER | ReUnion | Bucks | Beds | Memorial | Weekender | Northants | Essex | Pairs | European | [NAME] | Last Chance | Masters | Singles | TOTAL | WINS
1
2
3 |  |  |  | 3
4 |  |  |  | 7
5 |  | 2 | 9 | 6 |  |  |  |  |  |  |  |  |  | 1.25
6
7
8
9
10
11 |  |  |  | 12
12
13
14
15
16 |  |  | 3
17 |  | 9 | 1 | 15 |  |  |  |  |  |  |  |  |  | 1.25
18 |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 1.25
19 |  | 1 | 6 |  |  |  |  |  |  |  |  |  |  | 1.25
20
21
22 |  |  |  | 10
23 |  |  | 8
24
25 |  | 10 | 2
26
27 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.25
28 |  | 7 | 5
29 |  | 6 | 15 |  |  |  |  |  |  |  |  |  |  |  |  | 1
30 |  |  |  | 5 |  |  |  |  |  |  |  |  |  | 1.25
31
32
33 |  |  |  | 8
34 |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1.25
35 |  | 12
36
37 |  | 15 |  |  |  |  |  |  |  |  |  |  |  | 1.25 |  | 1
38 |  | 8
39
40 |  | 3 | 10 | 4
41 |  |  | 12
42 |  |  |  | 2
43 |  | 5
44
45 |  |  | 7 | 9
46 |  |  | 4
Spreadsheet: 682524d1592173399-vlookup-with-wildcard-not-working-example1750-1-
Sheet: REF

 | IN
 | KEY | [NAME]
 | RAJ | FRIENDS
 | OUT
 | KEY | [NAME]
 | 987654159D, | HOME CARE
 | 999999A, | MORTGAGE
 | 123456789, | WATER
 | GHTY7415, | HOUSE
 | WILKO | REPAIRS
 | SELCO | SHOPPING
 | OVERDRAFT | OVERDRAFT
 | MONTHLY FEE | BANK FEE
 | CARD PAYMENT TO THAMES WATER,17.76 GBP, RATE 1.00/GBP ON 23-03-2020 | bills
 | CARD PAYMENT TO THAMES WATER,73.78 GBP, RATE 1.00/GBP ON 22-01-2020 | bills
 | CARD PAYMENT TO THAMES WATER,618.49 GBP, RATE 1.00/GBP ON 15-01-2020 | bills
 | CARD PAYMENT TO THAMES WATER,16.35 GBP, RATE 1.00/GBP ON 07-11-2019 | bills
 | CARD PAYMENT TO VIRGIN MEDIA PYMTS,89.98 GBP, RATE 1.00/GBP ON 24-09-2019 | bills
Spreadsheet: 855109d1704804537-help-with-let-function-digital-operator-production-log-v3-3-
Sheet: Master Schedule Updates

↓Select Client Name↓ | ↓Select Job #↓ |  | Master [NAME] ↓Update Time↓ (Total inludes all LC's/Part #'s) |  |  | These helper columns can be hidden!!!
ggpm | 20307 | = |  |  |  |  | 20314
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
Spreadsheet: 266742d1379708726-extract-first-cell-in-a-row-given-the-column-header-and-data-point-in-that-column-extract-points-date
Sheet: Sheet1

 |  |  |  | Adam | [NAME] | [NAME] | [NAME] | [NAME]
2012-04-10 00:00:00 | info | Game | 1 |  | 177 | 193 |  | 124 |  |  |  | Adam |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/956588-extract-first-cell-in-a-row-given-the-column-header-and-data-point-in-that-column.html
2012-04-10 00:00:00 | info | Game | 2 |  | 192 | 128 |  | 156
2012-04-10 00:00:00 | info | Game | 3 |  | 202 | 158 |  | 193
2012-04-10 00:00:00 | info | Game | 4 |  | 155 | 169 |  | 164
2012-04-10 00:00:00 | info | Game | 5 |  | 214 | 192 |  | 160
2012-04-10 00:00:00 | info | Game | 6 |  | 200 | 208 |  | 191
2012-04-10 00:00:00 | info | Game | 7 |  | 182 | 226 |  | 134
2012-11-10 00:00:00 | info | Game | 1 | 113 | 202 | 150 | 169
2012-11-10 00:00:00 | info | Game | 2 | 146 | 159 | 144 | 150
2012-11-10 00:00:00 | info | Game | 3 | 120 | 134 | 194 | 117
2012-11-10 00:00:00 | info | Game | 4 | 138 | 119 | 175 | 145
2012-11-10 00:00:00 | info | Game | 5 | 161 | 178 | 158 | 131
2012-11-10 00:00:00 | info | Game | 6 | 199 | 151 | 142 | 182
2012-11-10 00:00:00 | info | Game | 7 | 166 | 180 | 144 | 162
10.18.12 | info | Game | 1 | 150 | 186 | 164 | 184
10.18.12 | info | Game | 2 | 158 | 166 | 172 | 153
10.18.12 | info | Game | 3 | 130 | 157 | 202 | 146
10.18.12 | info | Game | 4 | 135 | 188 | 215 | 146
10.18.12 | info | Game | 5 | 113 | 202 | 150 | 169
10.18.12 | info | Game | 6 | 146 | 159 | 144 | 150
10.18.12 | info | Game | 7
Spreadsheet: 272651d1382453794-trying-to-get-an-if-formula-to-show-more-than-one-answer-small-sample
Sheet: Sheet1

Project | Class | Milestone
PM50H | A | [NAME]
PM49H | B | [NAME]
PM49Z | A | [NAME]
PM48H | A | [NAME]
PM38H | A | Completed
PM92G | A | [NAME]
PM74G | A | Development
PM87Z | C | Pilot
PM87G | A | Pilot
PM96F-2 | A | Development
PM04G | A | SAT
[NAME] | A | UAT
PM44G | A | UAT
PM99F | A | Completed
[NAME] I posted: |  | =IF(AND(AS9:AS48="Completed",H9:H48="A"),F9:F48,"")
Now: |  | =IF(AND(C3:C16="Completed",B3:B16="A"),A3:A16,"")
Spreadsheet: 878948d1726291639-xirr-with-criteria-test
Sheet: Test

Tran Date | Amount Invest | Value Return | Total Value Return | XIRR To-Date | 6-Period XIRR | Fund Code
2013-12-30 00:00:00 | 3000 | 2902.91 | 2902.91 |  |  | 123
2014-04-01 00:00:00 | 0 | 53.66 | 2956.57 |  |  | 123
2014-12-29 00:00:00 | 3000 | 2904.86 | 5861.43 |  |  | 123
2015-04-01 00:00:00 | 0 | 131.12 | 5992.55 |  |  | 123
2015-12-22 00:00:00 | 3000 | 2899.32 | 8891.87 |  |  | 123
2016-04-01 00:00:00 | 0 | 234.31 | 9126.18 |  |  | 123
2016-12-20 00:00:00 | 3000 | 2899.32 | 12025.5 |  |  | 123
2017-04-03 00:00:00 | 0 | 322.24 | 12347.74 |  |  | 123
2017-12-13 00:00:00 | -12506.55 | -12506.55 | -158.8099999999995 |  |  | 123
2017-12-13 00:00:00 | 12506.55 | 12506.55 | 12506.55 |  |  | 456
2018-04-03 00:00:00 | 0 | 454.46 | 12961.01 |  |  | 456
2018-12-11 00:00:00 | 3000 | 2904.85 | 15865.86 |  |  | 456
2019-04-01 00:00:00 | 0 | 438.11 | 16303.97 |  |  | 456
2019-12-16 00:00:00 | 3000 | 2904.85 | 19208.82 |  |  | 456
2020-04-01 00:00:00 | 0 | 530.99 | 19739.81 |  |  | 456
2021-04-01 00:00:00 | 0 | 729.13 | 20468.94 |  |  | 456
2021-12-29 00:00:00 | 3000 | 2904.85 | 23373.79 |  |  | 456
2022-04-01 00:00:00 | 0 | 852.81 | 24226.6 |  |  | 456
2010-01-11 00:00:00 | 10000 | 9708.74 | 9708.74 |  |  | 789
2010-11-01 00:00:00 | 0 | 923.37 | 10632.11 |  |  | 789
2011-11-01 00:00:00 | 0 | 785 | 11417.11 |  |  | 789
2012-11-01 00:00:00 | 0 | 614.54 | 12031.65 |  |  | 789
2013-11-01 00:00:00 | 0 | 677.89 | 12709.54 |  |  | 789
2014-11-03 00:00:00 | 0 | 958 | 13667.54 |  |  | 789
2015-11-02 00:00:00 | 0 | 1031.28 | 14698.82 |  |  | 789
2016-11-01 00:00:00 | 0 | 827.93 | 15526.75 |  |  | 789
2017-11-01 00:00:00 | 0 | 871.57 | 16398.32 |  |  | 789
2018-11-01 00:00:00 | 0 | 917.2 | 17315.52 |  |  | 789
2019-11-01 00:00:00 | 0 | 161.54 | 17477.06 |  |  | 789
2020-11-02 00:00:00 | 0 | 522.03 | 17999.09 |  |  | 789
2021-11-01 00:00:00 | 0 | 538.49 | 18537.58000000001 |  |  | 789
2022-11-01 00:00:00 | 0 | 345.51 | 18883.09 |  |  | 789
2010-09-07 00:00:00 | 6000 | 5825.24 | 5825.24 |  |  | 234
2011-04-01 00:00:00 | 0 | 465.41 | 6290.65 |  |  | 234
2011-04-21 00:00:00 | 4500 | 4368.93 | 10659.58 |  |  | 234
2012-04-02 00:00:00 | 0 | 746.59 | 11406.17 |  |  | 234
2013-04-01 00:00:00 | 0 | 905.77 | 12311.94 |  |  | 234
2014-03-03 00:00:00 | 3000 | 2912.62 | 15224.56 |  |  | 234
2014-04-01 00:00:00 | 0 | 1072.88 | 16297.44 |  |  | 234
2015-04-01 00:00:00 | 0 | 1023.25 | 17320.69 |  |  | 234
2016-04-01 00:00:00 | 0 | 642.76 | 17963.45 |  |  | 234
2017-04-03 00:00:00 | 0 | 511.84 | 18475.29 |  |  | 234
2018-04-02 00:00:00 | 0 | 585.71 | 19061 |  |  | 234
2019-04-01 00:00:00 | 0 | 603.94 | 19664.94 |  |  | 234
2020-04-01 00:00:00 | 0 | 624.74 | 20289.68 |  |  | 234
2021-04-01 00:00:00 | 0 | 813.3 | 21102.98 |  |  | 234
2022-04-01 00:00:00 | 0 | 847.29 | 21950.27 |  |  | 234
2023-04-03 00:00:00 | 0 | 424.43 | 22374.7 |  |  | 234
2024-04-01 00:00:00 | 0 | 658.07 | 23032.77 |  |  | 234
Spreadsheet: darrell_schoolcraft__7309__imball0201
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 43413 | 45338
2 | 45284 | 45338
3 | 34397 | 34338
4 | 64090 | 66519 |  |  |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5 | 66505 | 66519 | -21381 | -20000
6 | 62713 | 66519 | -21994 | -20000 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7 | 67373 | 66519 | -20031 | -20000
8 | 60189 | 63115 | -1852 |  |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 | 62594 | 62519 |  |  |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 | 62214 | 62218 |  |  |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 | 30610 | 30338 |  |  |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 | 30325 | 30338 | -31967 | -31700 |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13 | 30332 | 30338 | -32619 | -31700
14 | 30283 | 30338 | -33085 | -31700 |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15 | 29984 | 30338 | -647
16 | 48253 | 48338 |  |  |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17 | 30456 | 30338
18 | 43183 | 43338 | -14965 | -14800
19 | 53211 | 53338 | -5264 | -5000
20 | 53307 | 53338 | -5074 | -5000
21 | 53312 | 53338 | -5324 | -5000
22 | 53299 | 53338 | -5082 | -5000
23
24
25
26
27
28
29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000 | 2
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10000 | 1.5
2001-12-31 00:00:00
2002-01-22 00:00:00
CBS Dollars
 |  |  | 296376
Spreadsheet: 5e9ae4d1-c21b-455a-bc77-995e1724fb4c
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
FKETO | Test | FKETO | Ketoconazole, Serum/Plasma | Ketoconazole | High-Performance Liquid Chromatography/Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Submit only 1 of the following specimens:   Serum Draw blood in a plain, red-top tube(s). Promptly centrifuge and send 1 mL of serum refrigerated in plastic vial.  Note:    1. Serum gel tubes are unacceptable.              2. Indicate serum on request form. 	3. Label specimen appropriately (serum).   [NAME] blood in an EDTA lavender-top or pink-top tube(s).  Promptly centrifuge and send 1 mL of EDTA plasma  refrigerated in plastic vial. Note:    1. [NAME] tubes are unacceptable.              2. Indicate plasma on request form. 	3. Label specimen appropriately (plasma). | 0.22 mL | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, EDTA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Reporting limit determined each analysis     Synonym(s): Nizoral   Peak plasma levels of 5.4 +/- 1.7 mcg/mL occurred at approximately 1 hour following a single 200 mg dose and peak plasma levels of 22 +/- 3 mcg/mL occurred at approximately 2 hours following a single 800 mg dose of ketoconazole.  Test Performed by:   NMS Labs                                 3701 Welsh Road                                 P.O. Box 433A                                 [NAME], PA 19090-0437 | Monday, Wednesday, Friday | 2 days | 4 - 11 days | 1 | 83789 |  |  |  |  | NMS Labs
FKETO | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FKETO | Result | Z1443 | Ketoconazole | Ketoconazole | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 10990-0
FKETO | Result | Z1865 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 456735d1461022459-vlookup-not-working-when-data-in-array-is-not-in-sequential-order-customer-db-and-invoices-test
Sheet: Sales_Data

Date | Customer # | Invoice # | Description | Quantity | Price | Total
2016-04-17 00:00:00 | 1 | 1 | Test1 | 1 | 1
 | 1 | 1 | Test2 | 2 | 2
 | 1 | 1 | Test3 | 3 | 3
 | 1 | 1 | Test4 | 4 | 4
2016-04-21 00:00:00 | 2 | 2 | Test5 | 5 | 5
 | 2 | 2 | Test6 | 6 | 6
 | 2 | 2 | [NAME] | 7 | 7
 | 2 | 2 | Test8 | 8 | 8
2016-04-25 00:00:00 | 3 | 3 | Test9 | 9 | 9
 | 3 | 3 | Test10 | 10 | 10
 | 3 | 3 | Test11 | 11 | 11
 | 3 | 3 | Test12 | 12 | 12
Spreadsheet: 738209d1624899151-count-of-multiple-criteria-raw-data
Sheet: Sheet2

Name of the ARTC | 1.Anemia | 10.Headache | 11.Hypersensitivity | 12.Jaundice | 15.Myalgia | 16.Nausea | 17.Neuropathy | 19.Renal abnormalities * | 2.Depression | 20.Skin rash / Reactions | 21.Vomiting (V) | 22.Abdominal pain
AFMC Pune
ART PLUS MEERUT
Bangalore Bowring
Chest Hyderabad
[NAME]
COE BJMC, Ahmedabad
COE RIMS Imphal
[NAME]
[NAME] COE
GGH Guntur
JJH Mumbai
Spreadsheet: 90801d1290532663-how-to-get-a-list-based-on-month-wise-attendees
Sheet: Sheet1

Count | Name | Admission Date | Month
 | AAAAAAAAAAA | 2010-08-01 00:00:00
 | BBBBBBBBBBB | 2010-11-10 00:00:00
 | CCCCCCCCCC | 2010-10-21 00:00:00
 | [NAME] | 2010-12-21 00:00:00
 | EEEEEEEEEEE | 2010-11-28 00:00:00
 | FFFFFFFFFFFFF | 2010-11-24 00:00:00
 | GGGGGGGGGG | 2010-10-05 00:00:00
 | HHHHHHHHHH | 2010-12-26 00:00:00
 | IIIIIIIIIIIIIIIIII | 2010-12-02 00:00:00
 | [NAME] | 2010-11-12 00:00:00
 | KKKKKKKKKKK | 2011-01-22 00:00:00
 | LLLLLLLLLLLLL | 2011-01-24 00:00:00