tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f596597d-2814-45bc-b7bb-f3812cbaa548
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
BPRP | Test | BPRP | Bordetella pertussis and Bordetella parapertussis, Molecular Detection, PCR | Bordetella PCR | Polymerase Chain Reaction (PCR)/DNA [NAME]  (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) Includes DNA extraction from specimen, PCR amplification, and hybridization | Stuart transport medium: Stuart |  |  |  | Varies | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.   [NAME] source is required.   Submit only 1 of the following specimens:   Preferred: [NAME]: Nasopharyngeal swab Container/Tube: Rayon swab with an aluminum shaft placed in transport medium such as Stuart's with charcoal or Amies with charcoal (Transwab Nasopharyngeal with Charcoal System [Supply T286]) Additional Information: Other swab or media types may be inhibitory to PCR testing and will be rejected.   Acceptable: [NAME] (not throat) aspirate/wash or nasal aspirate/wash Container/Tube: Sterile container with a screw top cap (no transport media) [NAME]: Entire collection | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Nose, nasal, or throat swab; calcium alginate or cotton-tipped swab; swab sent in gel transport medium, viral/universal transport medium, or [NAME] media; specimen in Stuart's or Amies medium without | Not applicable | Monday through Friday; 10 a.m., Sunday; 10 a.m. | 1 day | 3 days | 2 | 87798 |  |  |  |  | Rochester
BPRP | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
BPRP | Order Question | SRC54 | Specimen source |  | Answer List
BPRP | Option | SRC54-1 | Nasopharyngeal swab
BPRP | Option | SRC54-2 | Nasal aspirate/wash
BPRP | Option | SRC54-3 | Nasopharyngeal aspirate/wash
BPRP | Result | SRC54 | Specimen source | Specimen source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
BPRP | Result | 34994 | Bordetella pertussis PCR | Bordetella pertussis PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43913-3 | Bordetella pertussis DNA:ACnc:Pt:[NAME]:Ord:Probe.amp.tar
BPRP | Result | 34995 | Bordetella parapertussis PCR | Bordetella parapertussis PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42588-4 | Bordetella parapertussis DNA:ACnc:Pt:[NAME]:Ord:Probe.amp.tar
Spreadsheet: 102645d1300622517-automated-worksheet-for-accounting-filter-problem-automated-worksheets
Sheet: Codes Sorted

 | Account | Value |  | Account | Value |  | Account | Value
 | 62750.276 |  |  | 60308
 | 62750.278 |  |  | 76052
 | 62750.277 |  |  | 76060
 | 68700.565 |  |  | 76055
 | 68700.567 |  |  | 60300.164
 | 60850 |  |  | 60300.165
 | 62850 |  |  | 60300.167
 | 64972 |  |  | 60300.169
 | 79045
 | 64975
Spreadsheet: 696252d1600717748-coutif-function-error-probability-work-sheet-v4-forum
Sheet: probability work sheet csv

Common | 15 min
Elongated | 30 min
Extra Elongated | 45 min
Super Elongated | 60  min
Morning Session | Blank Slate | Scenario 1 | Scenario 2 | Scenario 3 | Scenario 4 | Scenario 5
8:00 AM |  |  |  |  |  | Extra Elongated
08:15:00 |  |  |  |  | Common
8:30 AM |  |  | Common
08:45:00 |  |  |  |  |  | Super Elongated
9:00 AM
09:15:00 |  |  |  |  | Common
9:30 AM
09:45:00
10:00 AM |  | IPF | IPF | IPF | IPF | IPF
10:15:00 |  | IPF | IPF | IPF | IPF | IPF
10:30:00
10:45:00 |  |  |  | Common
11:00:00 |  |  |  |  |  | Elongated
11:15:00
11:30:00 |  |  | SDA |  |  | Common
11:45:00 |  |  | SDA | SDA | SDA | SDA
Open Slots
Used Slots
Open Access Available
Blocked slots ( IPF & SDA)
Common
Elongated
Extra Elongated
Super Elongated
Potential Elongated VT (rounded down)
Cells with [NAME]
Sum of Consec Cells
CTrl Shift Ent/array
 |  | IPF
 |  | SDA
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 24744 | 27471 | 9254 | 11000 | 470 |  | 128
2 | 24610 | 23207 | 9162 | 8606
3 | 24285 | 23568 | 9138 | 8606
4 | 24251 | 24500 | 8984 | 8606 |  |  | 539
5 | 24317 | 24500 | 9434 | 8606
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
2001-05-31 00:00:00 |  |  |  |  |  |  |  |  | 409153
2001-06-05 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 848830d1699460394-ways-to-make-workbook-set-up-more-efficient-run-faster-081123-example-solution-trial
Sheet: Project name

Hidden tab | Drop down | Drop down | Free text | Drop down | Drop down | Free text | Hidden tab | Auto generated |  | Hidden tab
Helper | Region | Team | Name of project | Priority | Project Type | Number of tasks | Asset type | Project name | Folder name | Project number
1 | US | Team 1 | Project 1 | Low | Solo | 2 | Project |  |  | 1
 | India | Team 3 | Project 2 | Medium | Collaborative | 3 | Project |  |  | 2
 | APAC | Team 2 | Project 3 | High | Collaborative | 4 | Project |  |  | 3
 | UK | Team 4 | Project 4 | Low | Solo |  | Project |  |  | 4
 |  |  |  |  |  |  | Project |  |  | 5
 |  |  |  |  |  |  | Project |  |  | 6
 |  |  |  |  |  |  | Project |  |  | 7
 |  |  |  |  |  |  | Project |  |  | 8
 |  |  |  |  |  |  | Project |  |  | 9
 |  |  |  |  |  |  | Project |  |  | 10
 |  |  |  |  |  |  | Project |  |  | 11
 |  |  |  |  |  |  | Project |  |  | 12
 |  |  |  |  |  |  | Project |  |  | 13
 |  |  |  |  |  |  | Project |  |  | 14
 |  |  |  |  |  |  | Project |  |  | 15
 |  |  |  |  |  |  | Project |  |  | 16
 |  |  |  |  |  |  | Project |  |  | 17
 |  |  |  |  |  |  | Project |  |  | 18
 |  |  |  |  |  |  | Project |  |  | 19
 |  |  |  |  |  |  | Project |  |  | 20
 |  |  |  |  |  |  | Project |  |  | 21
 |  |  |  |  |  |  | Project |  |  | 22
 |  |  |  |  |  |  | Project |  |  | 23
 |  |  |  |  |  |  | Project |  |  | 24
 |  |  |  |  |  |  | Project |  |  | 25
 |  |  |  |  |  |  | Project |  |  | 26
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0119

01/19/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint | 16 | 4 | 6 |  |  |  |  | 92 | 2 | reporting/cap mgmt | 5.5 | 16.72727272727273
 | Dustin | 11 | 27 | 11 |  |  |  |  | 191 | 1.5 | trending/cap mgmt | 6.75 | 28.2962962962963
 | Sharron | 5 | 19 | 7 |  |  |  |  | 123 |  |  | 9.75 | 12.61538461538461
 | Roxy | 15 | 6 | 12 |  |  |  |  | 144 |  |  | 8.5 | 16.94117647058824
 | [NAME] |  |  |  |  |  | 18 | 1 | 152 |  |  | 8 | 19
 | Ana | 9 | 14 | 13 |  |  |  |  | 164 |  |  | 8 | 20.5
 |  |  |  |  |  |  |  |  | 0
 | [NAME] | 4 | 27 | 10 |  |  |  |  | 169 | 1 | CISS | 8.25 | 20.48484848484848
 | Petra | 12 | 6 | 2 |  | 1 | 1 | 3 | 92 | 5 | MISC | 8 | 11.5
 | Regina |  |  |  |  |  | 19 | 3 | 176 |  |  | 10.25 | 17.17073170731707
 | Noy | 9 |  |  |  | 2 | 11 | 2 | 126 | 1 | SWT | 8 | 15.75
 | [NAME] |  | 2 |  |  | 6 | 31 |  | 266 |  |  | 9.75 | 27.28205128205128
 | [NAME] | 15 | 16 |  |  |  |  |  | 78 |  | SME | 4 | 19.5
 | Michelle | 32 |  |  |  |  |  |  | 64 |  | SME | 2.5 | 25.6
 | Keisha |  | 6 | 5 |  |  |  |  | 58 | 1.5 | MISC | 8 | 7.25
 | [NAME] | 11 | 29 | 2 |  |  |  |  | 125 | 3 | DA TRAINING | 8.25 | 15.15151515151515
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 258.6177615837587
 | TASK VOLUME: | 139 | 156 | 68 | 0 | 9 | 80 | 9 | 2020 | 15 |  | 113.5 | 17.79735682819383
 | Pts Earned: | 278 | 468 | 544 | 0 | 18 | 640 | 72
 |  |  |  |  |  |  |  | Average PTS | 126.25 |  | Total Task Volume |  | 461
 | MID-DAY PPH  17.51
Spreadsheet: 792078d1660732302-formula-to-auto-calculate-gestation-please-help-2022-2023-screening-db-copy-ans
Sheet: April 22- March 23

Explanatory notes: The purpose of this spreadsheet is to act as our main ANNB screening failsafe database, monitoring each client closely to ensure seamless movement throughout the screening pathway.
Patient Details |  |  |  |  |  | Booking Details |  | Gestation Details |  |  | Bloods |  |  | ANSCT |  |  |  | Serology |  |  | Blood Group |  | First Trimester Screening |  |  |  |  |  |  |  | Second Trimester Screening |  |  |  |  |  | [NAME] |  |  |  | Anomaly Repeat |  |  | Growth |  | Referral/ Further Diagnostic Testing |  |  |  | Additional Comments | Affected by Covid-19
Surname | Forename | DOB | PASID | NHS number | Date of booking | Team | Caseload surgery | Gestation weeks | Gestation days | Live gestation from scan | Taken at booking | Reason | Date taken | Resulted before 10/40 | No- reason | Sickle Cell | Thalassaemia | HIV | [NAME] | Syphillis | Group | Antibodies | Dating scan | Gestation weeks | Gestation days | Reason for NOT having | T21 | T18/13 | <PAPP-A | <PAPP-A actioned | Reason for NOT having | Reason for having | Date taken | T21 | Raised AFP | [NAME] actioned | Reason for NOT having | Date | Gestation | Complete/for repeat scan/ referral | Date | Gestation | Complete/ incomplete | Date | Gestation | Reason for referral | Referred to | PND | Outcome
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 13 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-12 00:00:00 | 12 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-06 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 9 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-22 00:00:00 | 20 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-15 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 10 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-25 00:00:00 | 13 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-08 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 11 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-13 00:00:00 | 12 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-06 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 10 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-12 00:00:00 | 11 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-14 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 8 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-03 00:00:00 | 12 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-27 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 12 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-07 00:00:00 | 13 | 2
Spreadsheet: 822687d1679487266-match-person-based-on-date-postcode-to-a-location-date-postcode-muck-about
Sheet: Result

Date | Location | Person | Postcode | [NAME]
Spreadsheet: 124025d1318003280-countifs-
Sheet: Master

[NAME] |  | Radiology |  |  |  | Πρώτη [NAME] |  | Ετος
 |  |  |  |  |  | Σάββατο |  | 2011
 |  |  |  | [NAME] ΡΕΠΟ
Ονοματεπώνυμο | 1 | [NAME] |  | 10
Εργαζόμενου | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
Spreadsheet: 878371d1725448422-exclude-names-with-bold-formatting-from-randomizer-nihilimus-randomizer-1-spill-365-aligw
Sheet: Blad1

 | [NAME] |  | [NAME] for randomized names
 | dion
 | [NAME]
 | dirceo
 | jowan
x | Artur
 | Marian
 | Mohamed
 | Marek
 | Rafal
 | Elroy
 | [NAME]
 | Houcine
 | [NAME]
 | Maarten
 | Stef
 | [NAME]
 | Martien
 | [NAME]
Spreadsheet: 468611d1467386355-help-with-v-look-up-copy-of-copy-of-packing-slip-template-1-ndm
Sheet: Sheet1

Customer: | [NAME] |  |  |  |  | Date:
billing address: |  |  | Shipping Address:
Item |  | Quantity |  | retail Price | Wholesale Rate | Price
Shipping:
Total:
Spreadsheet: 814213d1674227726-look-up-same-requirements-output-different-results-automated-schedule-help-example
Sheet: Workers

Date | Activity | Results |  |  | Notes
2023-04-01 00:00:00 | Work |  |  |  | This is to build an automated schedule. The "Work, Work, and Help" all start on the same day.  I would like C2,C3, and C4 to display the person from the "schedule" sheet in row C into the corrosponding activity. For example C2,C3, and C4 would all reference A2.  C5,C6,C7 would all reference A5  C8, C9, C10 would all reference A7
2023-04-02 00:00:00 | Work
2023-04-03 00:00:00 | Help
2023-04-04 00:00:00 | Work
2023-04-05 00:00:00 | Work
2023-04-06 00:00:00 | Help
2023-04-07 00:00:00 | Work
2023-04-08 00:00:00 | Work
2023-04-09 00:00:00 | Help
Spreadsheet: 716772d1612360117-excel-formula-for-multi-tiered-pricing-water
Sheet: Sheet1

Charge Rate | Cost Per 1000 gallons |  |  | Total Gallons Used: | 25000
Base Charge | 21.53 | Floor |  | Final Bill:
0 to 5,000 gallons | 3 | 0
5,001 to 10,000 gallons | 3.45 | 5001
10,001 to 15,000 gallons | 3.97 | 10001
15,001 to 20,000 gallons | 4.56 | 15001
20,001 to 25,000 gallons | 5.25 | 20001
>25,001 gallons | 6.03 | 25001
Spreadsheet: 115271d1310910354-excel-2007-need-help-with-summing-up-the-data-in-sheet-sales-summary
Sheet: Summary Sheet

SUMMARY MONTHLY SALES DATA SHEET
CITY | SHOES | SHIRTS | PANTS | SOCKS
HOUSTON
DALLAS
AUSTIN
Spreadsheet: 129603d1321729704-sensitivity-and-solution-space-solver77-nyc
Sheet: Sensitivity Report 1

Microsoft Excel 14.0 Sensitivity Report
Worksheet: [solver_77 (1).xlsx]Sheet1
Report Created: 11/18/2011 9:58:31 PM
Variable Cells
 |  |  | Final | Reduced
 | Cell | Name | Value | Gradient
 | $B$4 | Chess beginner players Number of players | 7.999999999999996 | 0
 | $B$5 | chess  mediocre players  Number of players | 3.999999999999999 | 0
 | $B$6 | highly advanced chess players Number of players | 8.000000000000004 | 0
Constraints
 |  |  | Final | Lagrange
 | Cell | Name | Value | Multiplier
 | $B$8 | Total Number of players | 20 | -110
 | $C$8 | Total Entering at a cost | 600 | 6
 | $[NAME] | Total training cost per hour | 729.9999999999998 | 0
 | $E$8 | Total Hrs of training | 33.99999999999999 | 0
Spreadsheet: 192084d1352303402-is-there-such-a-thing-as-auto-filter-or-a-workaround-that-will-do-the-following-deal-log
Sheet: TEAM2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | counts:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL FRONT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total gross
## | SALESMAN | TEAM # | DATE | CUSTOMER | STOCK# | FRONT $$ | RESERVE | WARR | GAP | A/M | TOTAL $ | [N/U] | NEW UNITS | USED UNITS | NEW GROSS | USED GROSS | fe | reserve | WARR | gap | a/m | front | reserve | warr | gap | a/m
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
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
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
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
Spreadsheet: 231504d1367098248-two-misaligned-cells-16-team-planning-bracket
Sheet: 132

[NAME] | Aztec | 1
bl132 | Bloomfield
cib132 | Cibola
cle132 | Cleveland
[NAME] | Farmington
gal132 | Gallup
[NAME] | Grants | 8
[NAME] | [NAME]
miy132 | Miyamura | 5
new132 | Newcomb
pv132 | Piedra Vista
rr132 | Rio Rancho
sf132 | Santa Fe
ship132 | Shiprock
vv132 | [NAME] | 4
win132 | Wingate
 |  | 3
Paste Value - CTRL-N
 |  | 6
 |  | 7
 |  | 2
Spreadsheet: 117268d1312606008-formulas-and-dates-duplicates1-1-
Sheet: Sheet1

[NAME] | 2010-01-31 00:00:00 |  |  | Date | 2009-02-22 00:00:00
[NAME] | 2010-01-31 00:00:00 |  |  | Count |  |  |  |  | Note: Enter date in Cell F2
[NAME] | 2010-01-31 00:00:00 |  |  |  |  |  |  |  | The date in cell F2 could also be a part of formula in column H
[NAME] | 2010-01-31 00:00:00 |  |  |  |  |  |  |  | Array formula is used in column H and should be confirmed through Ctrl+Shift+Enter
[NAME] | 2010-01-31 00:00:00 |  |  |  |  |  |  |  | The logic of formul in Cell C2 is wrong. Use evaluate formula option in formula tab to understand the formula
[NAME] | 2010-01-31 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2010-04-30 00:00:00 | 4/31/2010 | The date was wrong
[NAME] | 2010-04-30 00:00:00 | 4/31/2010 | The date was wrong
[NAME] | 2010-04-30 00:00:00 | 4/31/2010 | The date was wrong
[NAME] | 2010-04-30 00:00:00 | 4/31/2010 | The date was wrong
[NAME] | 2010-04-30 00:00:00 | 4/31/2010 | The date was wrong
[NAME] | 2010-04-30 00:00:00 | 4/31/2010 | The date was wrong
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
Spreadsheet: c9567175-9e82-4c83-aae5-73165c2f2137
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
FMYPN | Test | FMYPN | Mycoplasma pneumoniae IgA | Mycoplasma pneumoniae IgA | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a red-top tube. Separate serum from cells immediately and send 1 mL of serum frozen in plastic vial. Required: Collection date | 0.6 mL | Specimens other than	Serum Anticoagulants other than	Plain red-top Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | [NAME]:   0 - 9 BU/mL None Detected There is no indication of M. pneumoniae infection.   10 - 20 BU/mL Equivocal Test a second sample, drawn two to four weeks later in parallel with the first sample. When second sample is equivocal the result should be considered as negative.   21 BU/mL and greater Relevant detectable levels of IgA antibodies. Suggestive of current or chronic M. pneumoniae infection.                                              Test Performed by: Cambridge Biomedical Inc. 	                        1320 Soldiers Field Rd. 	                         Boston, MA 02135 | Monday | 1-7 days | 15 days | 1 | 86738 |  |  |  |  | Cambridge Biomedical Inc.
FMYPN | [NAME] | SRED | Serum Red |  |  |  | Frozen | 120 days
FMYPN | Result | [NAME] | MP IgA | MP IgA | Alphanumeric |  |  |  |  | BU/mL |  |  |  |  |  |  |  |  |  | 26684-1
Spreadsheet: 674540d1587903414-unique-value-count-based-of-multiple-criteria-kv
Sheet: BONOUS

CUSTOMER CODE --->> |  | 0026628X
 |  |  |  |  |  | 04 | 03
 |  |  | TOTAL COUNT | SUM | UNIQUE COUNT | UNIQUE SUM |  |  | unique count(unique DOB in NB sheet) in Col.F6 if C2 satisfies below mentioned contidions:-
20190401 | 20200331 |  |  |  | 5 |  |  |  | IF(NB!A:A,"NB"and NB!M:M,C2 and NB!F:F>=A6 and NB!F:F<=&B6, nb!L:L (UNIQUE DOB)
20180401 | 20190331
20170401 | 20180331 |  |  |  |  |  |  |  | EXPECTED ANSWER IN WRITTEN IN COL F6 AND F14
20160401 | 20170331
20150401 | 20160331
20140401 | 20150331
20130401 | 20140331
20120401 | 20130331
20110401 | 20120331 |  |  |  | 6
20100401 | 20110331
20090401 | 20100331
20080401 | 20090331
20070401 | 20080331
20060401 | 20070331
SUM(--(FREQUENCY(IF(NB!A:A,"NB")*(NB!M:M,C2)*(NB!F:F,">="&A6)*(NB!F:F,"<="&B6),NB!L:L),NB!L:[NAME]))))
Spreadsheet: 109570d1306397786-conditional-formatting-copy-of-example-of-weekly-plan-only
Sheet: Weekly Training-Study Overview

Weekly Training/Study Schedule
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
7.00 - 7.30 |  |  |  |  |  |  | Total Training Hrs
7.30 - 8.00
8.00 - 8.30 | S&C/Phy |  |  |  | S&C/Phy
8.30 - 9.00 | S&C/Phy |  |  |  | S&C/Phy
9.00 - 9.30 | S&C/Phy | Study | Study | Study
9.30 - 10.00 |  | Study | Study | Study |  | S&C/Phy
10.00 - 10.30 | Study | Study | Study | Study | Study | S&C/Phy
10.30 - 11.00 | Study | Study | Study | Study | Study | S&C/Phy
11.00 - 11.30 | Study | Study | Study | Study | Study
11.30 - 12.00 | Study | Study | Study | Study | Study
12.00 - 12.30 | Study | Study | Study | Study | Study
12.30 - 13.00 | Study |  | Study | Study | Study
13.00 - 13.30 | Study | OT | Study | Study | Study
13.30 - 14.00 | Study | OT | Study | Study | Study
14.00 - 14.30 | Study | OT | Study | Study | Study
14.30 - 15.00 | Study | OT | Study | Study | Study
15.00 - 15.30 | Study |  | Study | Study | Study
15.30 - 16.00
16.00 - 16.30
16.30 - 17.00
17.00 - 17.30
17.30 - 18.00
18.00 - 18.30 |  |  |  | EPT | OT
18.30 - 19.00 |  |  |  | EPT | OT
19.00 - 19.30 |  | PC |  | EPT | OT
19.30 - 20.00 |  | PC | EPT | EPT
20.00 - 20.30 | PC | PC | EPT
20.30 - 21.00 | PC | PC | EPT
21.00 - 21.30 | PC |  | EPT
21.30 - 22.00 | PC
Total hrs | 3.5 | 4 | 2 | 2 | 2.5 | 1.5
 |  | EPT (England Performance Training) |  |  | OT (Own Training) |  | Study
 |  | PC (Performance Centre) |  |  | S&C/Phy ( S&C/Physical)
EPT
PC
Insert into cell type of training then drag down to represent time slot!!
Spreadsheet: 72332d1273022030-calculate-a-value-per-a-code-inserted-items-catalogue
Sheet: Sheet1

 |  | Catalogue of Items
Code | Item | Price |  | Code | Item | Price
1 | Casa | 1000 |  | 6 | Apartamento | 800
2 | Carro | 500 |  | 7 | Jeepeta | 600
3 | Computadora | 100 |  | 8 | Ipad | 90
4 | Iphone | 100 |  | 9 | SonyEricson | 60
5 | Ipod | 70 |  | 10 | Mp3 | 20
 |  | Imput the code and Get your Less Expensive option
 |  | Column A |  | Column B
 |  | 1 |  | 6
 |  | 4 |  | 9
 |  | 5 |  | 10
 | Total | 1170 |  | 880 | Total
 | Results:
Related to Column B,  [NAME] is |  |  | 290 | More Expensive
Related to Column A,  [NAME] is |  |  | -290 | Less Expensive
Your Best Option is |  | Column B | 880
 | You will Safe |  | 290
Hi All, What I need is page to calculate the best price between two groups of item chosed, Items have code name and Price, I want to input the code in the two columns, in the bottom of the column I would like an autosume not of the codes input but of the values of each code, if total is bigger than the total of the other colum cell should turn to Red if its lower should turn Green.