tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56183d1256273402-non-existing-date-to-0-example
Sheet: 10592

 | Vehicle service record
 | VEHICLE MAKE: | TRUCK. MITSUBISHI FK 3 WAY TIPPER | ID: | 10592
 | YEAR: | 2001 | REGO: | WPO-686 | Master |  | Service History
 | TEAM: | [NAME] \ Justin
 | DATE: | 2005-01-01 00:00:00 | 2005-02-01 00:00:00
 | MILEAGE: | 26000 | 28000
 | COMMENTS
 | SERVICE:
 | Change oil
 | Lubricate chassis
 | Change oil filter
 | Change air filter
 | Change transmission fluid
 | Flush cooling system
 | Add antifreeze
 | Align wheels
 | Rotate tires
 | Replace tires
 | Adjust brakes
 | Tune engine
 | Other service
 | Other service
 |  |  |  |  |  |  |  | Double Click
 | [NAME] \ [NAME]
 | Lupo Vaccarella\John Ventra
 | [NAME] \ [NAME]
 | [NAME] \ [NAME]
 | [NAME] \ [NAME]
 | [NAME]
 | [NAME]
 | [NAME] \ Justin
 | [NAME] \ [NAME]
 | [NAME] \ [NAME]
 | [NAME] \ [NAME]
 | [NAME]
 | spare
 | spare
 | spare
Spreadsheet: 546455d1510061312-calculation-time-tempo-sla
Sheet: Sheet1

Numero TT | Data Apertura | Data Fine Intervento | [NAME] intervallo | Data inizio | Data fine | Tempi di Attesa | Transazioni escluse | Tempo effettivo (F.I.) | Tempo SLA
[PHONE] | 2017-01-01 06:23:49 | 2017-01-01 06:44:34 | [NAME] | 2017-01-01 06:23:49 | 2017-01-01 06:27:27 | 0:03:38 |  |  | 0:20:45
[PHONE] | 2017-01-01 06:23:49 | 2017-01-01 06:44:34 | Assegnato -> In Carico | 2017-01-01 06:27:27 | 2017-01-01 06:27:44 | 0:00:17 |  |  | 0:20:45
[PHONE] | 2017-01-01 06:23:49 | 2017-01-01 06:44:34 | Fissato -> Chiuso | 2017-01-01 06:44:51 | 2017-01-02 07:28:28 | 1 day, 0:43:37 |  |  | 0:20:45
[PHONE] | 2017-01-01 06:23:49 | 2017-01-01 06:44:34 | In Carico -> Fissato | 2017-01-01 06:27:44 | 2017-01-01 06:44:51 | 0:17:07 |  |  | 0:20:45
[PHONE] | 2017-01-01 06:34:37 | 2017-01-01 07:05:59 | [NAME] | 2017-01-01 06:34:37 | 2017-01-01 06:36:23 | 0:01:46 |  |  | 0:21:42
[PHONE] | 2017-01-01 06:34:37 | 2017-01-01 07:05:59 | Assegnato -> In Carico | 2017-01-01 06:36:23 | 2017-01-01 06:36:48 | 0:00:25 |  |  | 0:21:42
[PHONE] | 2017-01-01 06:34:37 | 2017-01-01 07:05:59 | Attesa -> In Carico | 2017-01-01 06:56:12 | 2017-01-01 07:05:52 | 0:09:40 |  |  | 0:21:42
[PHONE] | 2017-01-01 06:34:37 | 2017-01-01 07:05:59 | Fissato -> Chiuso | 2017-01-01 07:06:04 | 2017-01-02 07:27:18 | 1 day, 0:21:14 |  |  | 0:21:42
[PHONE] | 2017-01-01 06:34:37 | 2017-01-01 07:05:59 | In Carico -> Attesa | 2017-01-01 06:36:48 | 2017-01-01 06:56:12 | 0:19:24 |  |  | 0:21:42
[PHONE] | 2017-01-01 06:34:37 | 2017-01-01 07:05:59 | In Carico -> Fissato | 2017-01-01 07:05:52 | 2017-01-01 07:06:04 | 0:00:12 |  |  | 0:21:42
Spreadsheet: 753610d1635559016-data-validation-to-prevent-time-overlapping-hours-report-data-validation
Sheet: Sheet1

Datum | von | bis | für Kunde | Zeit in Minuten
29.10.2021 | 13:00:00 | 13:30:00 | Test
30.10.2021 | 14:30:00 | 15:30:00 | [NAME]
31.10.2021 | 08:00:00 | 10:30:00 | Müller
31.10.2021 | 11:00:00 | 12:30:00 | [NAME]
31.10.2021 | 00:15:00 | 00:45:00 | Maria
31.10.2021 | 18:00:00 | 21:37:00 | Zatta
20.11.2021 | 19:37:00 | 20:15:00 | Test
Spreadsheet: 101840d1299871312-question-about-totals-in-excel-pivot-table-xlforum
Sheet: Sheet1

empid | mgr | Transferred Area | Transfers | Name | NCH
1 | [NAME] | Help1 | 17 | Doe, [NAME] | 289
2 | [NAME] | Help2 | 3 | Anyone, KB | 186
2 | [NAME] | Help3 | 1 | Anyone, KB | 186
2 | [NAME] | Help4 | 2 | Anyone, KB | 186
2 | [NAME] | Help1 | 9 | Anyone, KB | 186
2 | [NAME] | Help5 | 1 | Anyone, KB | 186
3 | [NAME] | Help6 | 1 | Doe, [NAME] | 194
3 | [NAME] | Help1 | 4 | Doe, [NAME] | 194
4 | [NAME] | Help2 | 2 | Someone, Else | 175
4 | [NAME] | Help1 | 9 | Someone, Else | 175
5 | [NAME] | Help2 | 2 | Another, [NAME] | 272
5 | [NAME] | Help7 | 1 | Another, [NAME] | 272
5 | [NAME] | Help4 | 1 | Another, [NAME] | 272
5 | [NAME] | Help1 | 9 | Another, [NAME] | 272
5 | [NAME] | Help8 | 1 | Another, [NAME] | 272
mgr | [NAME]
 |  |  | Data
Name | empid | Transferred Area | Sum of Transfers | Sum of % Transfers
Another, [NAME] | 5 | Help1 | 9 | 0.03308823529411765
 |  | Help2 | 2 | 0.007352941176470588
 |  | Help4 | 1 | 0.003676470588235294
 |  | Help7 | 1 | 0.003676470588235294
 |  | Help8 | 1 | 0.003676470588235294
Another, Name Total |  |  | 14 | 0.01029411764705882
Anyone, KB | 2 | Help1 | 9 | 0.04838709677419355
 |  | Help2 | 3 | 0.01612903225806452
 |  | Help3 | 1 | 0.005376344086021506
 |  | Help4 | 2 | 0.01075268817204301
 |  | Help5 | 1 | 0.005376344086021506
Anyone, KB Total |  |  | 16 | 0.01720430107526882
Doe, [NAME] | 3 | Help1 | 4 | 0.02061855670103093
 |  | Help6 | 1 | 0.005154639175257732
Doe, Jane Total |  |  | 5 | 0.01288659793814433
Doe, [NAME] | 1 | Help1 | 17 | 0.05882352941176471
Doe, [NAME] |  |  | 17 | 0.05882352941176471
Someone, Else | 4 | Help1 | 9 | 0.05142857142857143
 |  | Help2 | 2 | 0.01142857142857143
Someone, Else Total |  |  | 11 | 0.03142857142857143
Grand Total |  |  | 63 | 0.01899306602351522
Spreadsheet: 100503d1298882650-if-formula-query-answer-v2
Sheet: Sheet1

Unit | Veh Type | Date Out | Date returned | Cost | Total days | 800
ABC | [NAME] | 2011-02-25 00:00:00 | 2013-05-04 00:00:00 |  |  |  | Rate | Amount
 |  |  |  |  | months | 26 | 990 | 25740
 |  |  |  |  | weeks | 2 | 247.5 | 495
 |  |  |  |  | days | 6 | 33 | 198
 |  |  |  |  |  |  | Total | 26433 | (this calculation is based on the assumption that 1 month is equal to 30days)
 |  |  |  |  |  |  | Rate | Amount
 |  |  |  |  | months | 26 | 990 | 25740
 |  |  |  |  | weeks | 1 | 247.5 | 247.5
 |  |  |  |  | days | 1 | 33 | 33
 |  |  |  |  |  |  | Total | 26020.5 | (This is the correct amount)
 |  | Year | 2011 |  |  |  |  |  |  |  |  |  | Months | Days
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 201101 | 201102 | 201103 | 201104 | 201105 | 201106 | 201107 | 201108 | 201109 | 201110 | 201111 | 201112
 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
 |  | 4 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
Months |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10
Days |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 4
Months (in between 2011 and 2013) |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  | Year | 2013
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 201301 | 201302 | 201303 | 201304 | 201305 | 201306 | 201307 | 201308 | 201309 | 201310 | 201311 | 201312
 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
 | 31 | 28 | 31 | 30 | 4
Months | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 4
Days |  |  |  |  | 4 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | Total | 26 | 8
Spreadsheet: 889777d1740690638-dragging-formula-across-columns-referencing-rows-but-skipping-cells-book1-snook-adj-
Sheet: Sheet2

 | Sales | Expenses | % | Sales | Expenses | % | Sales | Expenses | % | Sales | Expenses | % | Sales | Expenses | %
2025-01-26 00:00:00 | 100 | 10 |  | 375 | 37
 | 2435 | 343 |  | 215 | 23
 | 3432 | 234
 | 67 | 67
 | 6556 | 98
 | 23 | 1
Counter formula in action
Column count |  | 1 |  |  | 4 |  |  | 7 |  |  | 10 |  |  | 13
Desired output |  | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 5
How do you convert the value in row 32 to the desired output in row 33? The steps I used are as follows:
1. Calculate the column count (starting from the first cell you want a name returning in).
2. Divide that number by 3 as that's the no of cells between each name.
3. Round that number down to the nearest whole number (using the INT function).
4. Add 1 (because that will give me the desired output - I'm not sure on the why).
Spreadsheet: 7256ef30-7963-45d9-ad2b-770f0ee9e077
Sheet: Healthy unique genes

Uniquely expressed genes within enriched pathways in healthy gingival tissues.
Neuroactive ligand-receptor [NAME]
C=256;O=11;E=0.97;R=11.39;rawP=4.47e-09;adjP=7.60e-08
[NAME] stable ID | Gene symbol | Description
ENSG00000152822 | GRM1 | glutamate receptor, metabotropic 1
ENSG00000082556 | OPRK1 | opioid receptor, kappa 1
ENSG00000152208 | [NAME] | glutamate receptor, ionotropic, delta 2
ENSG00000136928 | GABBR2 | gamma-aminobutyric acid (GABA) B receptor, 2
ENSG00000056291 | NPFFR2 | neuropeptide FF receptor 2
ENSG00000183729 | NPBWR1 | neuropeptides B/W receptor 1
ENSG00000043591 | ADRB1 | adrenergic, beta-1-, receptor
ENSG00000186297 | GABRA5 | gamma-aminobutyric acid (GABA) A receptor, alpha 5
ENSG00000169836 | TACR3 | [NAME] 3
ENSG00000164128 | [NAME] | neuropeptide Y receptor [NAME]
ENSG00000150086 | GRIN2B | glutamate receptor, ionotropic, N-methyl D-aspartate 2B
Glycolysis / Gluconeogenesis----00010
C=62;O=3;E=0.23;R=12.83;rawP=0.0017;adjP=0.0145
ENSG00000163114 | PDHA2 | pyruvate dehydrogenase (lipoamide) alpha 2
ENSG00000196616 | ADH1B | alcohol dehydrogenase 1B (class I), beta polypeptide
ENSG00000166796 | LDHC | lactate dehydrogenase C
Calcium signaling pathway----04020
C=178;O=4;E=0.67;R=5.96;rawP=0.0047;adjP=0.0208
ENSG00000152822 | GRM1 | glutamate receptor, metabotropic 1
ENSG00000067842 | ATP2B3 | ATPase, Ca++ transporting, plasma membrane 3
ENSG00000169836 | TACR3 | [NAME] 3
ENSG00000043591 | ADRB1 | adrenergic, beta-1-, receptor
Gap junction----04540
C=90;O=3;E=0.34;R=8.84;rawP=0.0049;adjP=0.0208
ENSG00000152822 | GRM1 | glutamate receptor, metabotropic 1
ENSG00000152086 | [NAME] | tubulin, alpha 3e
ENSG00000043591 | ADRB1 | adrenergic, beta-1-, receptor
Pyruvate metabolism----00620
C=40;O=2;E=0.15;R=13.26;rawP=0.0100;adjP=0.0283
ENSG00000163114 | PDHA2 | pyruvate dehydrogenase (lipoamide) alpha 2
ENSG00000166796 | LDHC | lactate dehydrogenase C
Tryptophan metabolism----00380
C=40;O=2;E=0.15;R=13.26;rawP=0.0100;adjP=0.0283
ENSG00000129167 | TPH1 | tryptophan hydroxylase 1
ENSG00000129673 | AANAT | arylalkylamine N-acetyltransferase
Spreadsheet: 297696d1392530505-coping-cell-when-a-condition-is-met-testdata
Sheet: Sheet1

 | A | B | C | D
1 |  | ID
2 | info | 1 | weather | Sunny |  |  |  |  |  | 1 | Sunny 60
3 | info | 1 | Temp | 60 |  |  |  |  |  | 2 | Sunny 65
4 | info | 1 | Time | 7:50PM |  |  |  |  |  | 3 | Raining 55
5 |  |  | Weather | Time
6 | id | 1
7 | play | 1
8 | play | 1
9 | stat | 1
10 | info | 2 | weather | Sunny
11 | info | 2 | Temp | 65
12 | info | 2 | Time | 5:35PM
13 | id | 2
14 | play | 2
15 | play | 2
16 | stat | 2
17 | info | 2 | weather | Raining
18 | info | 2 | Temp | 55
19 | info | 2 | Time | [NAME]
20 | id | 3
21 | play | 3
22 | play | 3
23 | stat | 3
Spreadsheet: 801549d1666254576-how-to-scroll-through-table-in-in-groups-of-5-shown-on-big-screen-cap-v-sec-comp-revised-columns-ref-vices-names
Sheet: Master Score Board

 |  | Captain v Vice Captain Match & Annual Awards Evening
 |  |  |  | Saturday 22nd October 2022
 |  |  | Captain'sPoints |  |  | Vice Captain's Points
 | Match 1 | [NAME][NAME] | 0 |  |  | 0 |  | [NAME][NAME] |  |  |  | 3 | 2
 | Match 2 | [NAME]       [NAME] | 0 |  |  | 0 |  | [NAME]       [NAME]
 | Match 3 | [NAME][NAME] | 0 |  |  | 0 |  | [NAME]   [NAME]
 | Match 4 | [NAME]  [NAME] | 0 |  |  | 0 |  | [NAME]   [NAME]
 | Match 5 | [NAME]        [NAME] | 0 |  |  | 0 |  | [NAME]   [NAME]
 | Match 6 | [NAME]       [NAME] | 0 |  |  | 0 |  | [NAME]   [NAME]
 | Match 7 | [NAME]   [NAME] | 0 |  |  | 0 |  | [NAME]
 | Match 8 | [NAME]    Les Humphries | 0 |  |  | 0 |  | Wavell Coulson    [NAME]
 | Match 9 | [NAME][NAME] | 0 |  |  | 0 |  | [NAME][NAME]
 | Match 10 | [NAME][NAME] | 0 |  |  | 0 |  | [NAME]  [NAME]
 | Match 11 | [NAME]    [NAME] | 0 |  |  | 0 |  | [NAME][NAME]
 | Match 12 | [NAME] | 0 |  |  | 0 |  | [NAME]
 | Match 13 | [NAME]       [NAME] | 0 |  |  | 0 |  | [NAME]
 | Match 14 | Captain                Pro | 0 |  |  | 0 |  | Vice Captain     Asst Pro
 | Match 15 | [NAME] South | 0 |  |  | 0 |  | [NAME]  [NAME]
 | Match 16 | [NAME]    [NAME] | 0 |  |  | 0 |  | [NAME]  [NAME]
 | Match 17 | [NAME] | 0 |  |  | 0 |  | [NAME]   [NAME]
 | Match 18 | [NAME]      [NAME] | 0 |  |  | 0 |  | [NAME][NAME]
 | Match 19 | [NAME][NAME] | 0 |  |  | 0 |  | [NAME]
 | Match 20 | [NAME] | 0 |  |  | 0 |  | [NAME]       [NAME]
 | Match 21 | [NAME]    [NAME] | 0 |  |  | 0 |  | [NAME]
 | Match 22 | [NAME][NAME] | 0 |  |  | 0 |  | [NAME]
 | Match 23 | [NAME]    [NAME] | 0 |  |  | 0 |  | [NAME][NAME] |  | 2
 | Match 24 | [NAME]    [NAME] | 0 |  |  | 0 |  | [NAME]   [NAME] |  | 2
 | Match 25 | Adam Yates  [NAME] | 0 |  |  | 0 |  | [NAME]          [NAME] |  | 2
Spreadsheet: 762206d1641452210-if-cell-contains-product-name-then-count-all-the-cells-that-contain-the-letter-a-sample
Sheet: Sales (2)

 |  |  |  | ACTIVE (a) | DEAD (d) | LOST (l) | CONVERTED (c) | TOTAL
 |  |  | TEFLON - PTFE
 |  |  | NYLON - PA
 |  |  | ACETAL - POM |  | 1 | 1
 |  |  | POLYESTER - PET
 |  |  | TEFLON - PTFE | 2 | 1 | 2 | 2
 |  |  | [NAME]'S
 |  |  | POWER TRANS | 1 | 2
 |  |  | CONPRO | 1 | 1 | 1 | 1
 |  |  | Totals
STATE | DATE | CUSTOMER | PRODUCT | [NAME] | QUANTITY | EST VALUE $ | PROJECT NAME | COMPETITORS | 2020
 |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
QLD | 2021-08-24 00:00:00 |  | CONPRO | STEEL ROLLERS | 8 | 8000 | ROLLER REPLACE | Other
 |  |  | CONPRO |  |  |  |  |  |  |  | a | d | c | l
 |  |  | ACETAL - POM |  |  |  |  |  |  |  | d |  |  |  |  |  | l
 |  |  | POWER TRANS | RELAG WHEELS |  |  |  |  |  | a | d |  |  |  |  |  |  | d
 |  |  | POLYESTER - PET | BUMP STOPS
 |  |  | TEFLON - PTFE | GUIDES |  |  |  |  |  | a | a |  | d | l | c | c |  |  | l
Spreadsheet: 06d9b519-b8ee-437c-90d4-c969de3e8939
Sheet: Pos FY 2011-12

Fund/Bureau | Position Count from SAP | Vacant Casuals | Other Adjustments | Revised Position Count | Allocation Percent | In Model? | Notes
100-AT | 64 | -1 | -63
100-AU | 61 | -4 | -57
100-CB | 9
100-EM | 21 | -2 | -19
100-FR | 801 | -17 | -1
100-GR | 9 |  | -9
100-HC | 63 | -2
100-MF | 303 | -16
100-MY | 29 | -1
100-NI | 53 | -5 | -6
100-OE | 6
100-PA | 14 |  | -12
100-PK | 4994 | -2023
100-PL | 1250 | -4
100-PN | 124 | -14
100-PS | 7 | -1 | -6
100-PU | 9 |  | -9
100-PW | 12 |  | -12
200-TR | 796 | -16
202-EC | 149 | -3
203-DS | 187
216-PA | 5 |  | -5
220-PK | 2 | -2
402-PK | 16 | -1
600-ES | 630 | -59
601-WA | 3
602-WA | 674 | -28
603-PK | 97 | -53
604-PK | 90 | -25
605-PN | 35 | -3
608-ES | 5
700-MF | 12 | -1
701-MF | 37
702-MF | 78 | -1
703-MF | 28 | -2
704-MF | 16 | -1
705-MF | 7
706-MF | 230 | -2
708-MF | 20
800-DR | 19 | -1
Spreadsheet: 166945d1341851127-adding-multiple-results-using-vlookup-sample-workbook
Sheet: January

Overtime Work for January 2012
 |  | Dates |  |  | Time Worked
Employees | Department | To | From | No. of Days | Start-time | End-Time | No. of [NAME].
[NAME] | MIS | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 |  | 00:00:00 | 04:45:00
[NAME] | CSU | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 |  | 16:30:00 | 19:15:00
[NAME] | [NAME] | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | [NAME] | 2012-01-19 00:00:00 | 2012-01-19 00:00:00 |  | 17:00:00 | 19:45:00
[NAME] | MIS | 2012-01-29 00:00:00 | 2012-01-29 00:00:00 | 1 | 07:30:00 | 20:00:00
[NAME] | CSU | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 |  | 16:30:00 | 19:15:00
[NAME] | CSU | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 |  | 16:30:00 | 19:15:00
Krystal Roper | [NAME] | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | [NAME] | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | [NAME] | 2012-01-19 00:00:00 | 2012-01-19 00:00:00 |  | 17:00:00 | 19:15:00
[NAME] | CSU | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 |  | 16:45:00 | 19:00:00
Nkachi Reeves | Cross [NAME] | 2012-01-03 00:00:00 | 2012-01-03 00:00:00 |  | 16:30:00 | 19:10:00
Nkachi Reeves | Cross [NAME] | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | MIS | 2012-01-29 00:00:00 | 2012-01-29 00:00:00 | 1 | 07:30:00 | 20:00:00
[NAME] | Accounts Division | 2012-01-14 00:00:00 | 2012-01-14 00:00:00 |  | 12:15:00 | 16:00:00
[NAME] | Accounts Division | 2012-01-20 00:00:00 | 2012-01-20 00:00:00 |  | 15:30:00 | 19:00:00
[NAME] | [NAME] | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 |  | 17:00:00 | 19:30:00
[NAME] | [NAME] | 2012-01-19 00:00:00 | 2012-01-19 00:00:00 |  | 17:00:00 | 19:45:00
[NAME] | Accounts Division | 2012-01-13 00:00:00 | 2012-01-13 00:00:00 |  | 15:30:00 | 19:00:00
[NAME] | Accounts Division | 2012-01-16 00:00:00 | 2012-01-16 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | MIS | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | Cross [NAME] | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | Cross [NAME] | 2012-01-03 00:00:00 | 2012-01-03 00:00:00 |  | 16:30:00 | 19:10:00
[NAME] | Accounts Division | 2012-01-14 00:00:00 | 2012-01-14 00:00:00 |  | 10:30:00 | 18:00:00
[NAME] | Accounts Division | 2012-01-21 00:00:00 | 2012-01-21 00:00:00 |  | 13:00:00 | 18:00:00
[NAME] | [NAME] | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 |  | 17:00:00 | 19:00:00
[NAME] | [NAME] | 2012-01-19 00:00:00 | 2012-01-19 00:00:00 |  | 17:00:00 | 19:15:00
Trudi-[NAME] | Cross [NAME] | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | CSU | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 |  | 16:30:00 | 19:00:00
[NAME] | Accounts Division | 2012-01-17 00:00:00 | 2012-01-17 00:00:00 |  | 16:30:00 | 19:00:00
Spreadsheet: 701147d1603564352-using-powerquery-to-import-data-from-a-website-to-an-excel-spreadsheet-finvizpquery-problem
Sheet: Sheet1

Path |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12
mo |  |  | Index | - | P/E | 46.97 | EPS (ttm) | 1.32 | Insider Own | 0.195 | Shs Outstand | 52.10M | Perf Week | -1.93%
 |  |  | Market [NAME] | 3.24B | Forward P/E | 50.70 | EPS next Y | 1.22 | Insider Trans | -0.019 | [NAME] | 40.85M | Perf Month | 7.88%
 |  |  | Income | 69.50M | PEG | 3.91 | EPS next Q | 0.34 | Inst Own | 0.723 | Short Float | 9.71% | Perf Quarter | 6.80%
 |  |  | Sales | 499.20M | P/S | 6.50 | EPS this Y | 27.00% | Inst Trans | 0.0002 | Short Ratio | 21.09 | Perf Half Y | 28.74%
 |  |  | Book/sh | 6.19 | P/B | 9.99 | EPS next Y | -11.66% | ROA | 0.179 | Target Price | 35.00 | Perf Year | 29.99%
 |  |  | Cash/sh | - | P/C | - | EPS next 5Y | 12.00% | ROE | 0.232 | 52W Range | 40.48 - 65.69 | Perf YTD | 25.20%
 |  |  | Dividend | 0.38 | P/FCF | 51.82 | EPS past 5Y | 5.10% | ROI | 0.181 | 52W High | -5.83% | Beta | 0.64
 |  |  | Dividend % | 0.61% | [NAME] | 1.80 | Sales past 5Y | 5.70% | Gross Margin | 0.29 | 52W Low | 52.81% | ATR | 1.50
 |  |  | Employees | 2290 | Current Ratio | 2.90 | Sales Q/Q | 5.20% | Oper. Margin | 0.172 | RSI (14) | 54.45 | Volatility | 2.01% 2.32%
 |  |  | Optionable | Yes | Debt/Eq | 0.02 | EPS Q/Q | 32.90% | Profit Margin | 0.139 | Rel Volume | 0.47 | Prev Close | 61.23
 |  |  | Shortable | Yes | LT Debt/Eq | 0.02 | Earnings | Aug 06 AMC | Payout | 0.262 | [NAME] | 188.09K | Price | 61.86
 |  |  | Recom | 3.50 | SMA20 | 0.09% | SMA50 | 4.42% | SMA200 | 0.1407 | Volume | 87,809 | Change | 1.03%
Spreadsheet: 698042d1601698200-second-to-last-non-empty-cell-display_last_non-empty_cell
Sheet: Sheet1

 |  | display last non-empty cell | = | OP01 |  |  |  |  | OP01 | OP02 | OP03 | OP04 |  | OP04 | OP03 | OP01
 |  | display second-to-last non empty cell | = | OP03
 |  | display third-to-last non empty cell | = | OP04
 |  | display fourth-to-last non empty cell | = | OP02
Spreadsheet: 792833d1661183152-formula-if-start-dates-over-lap-other-start-date-or-if-a-start-date-overlaps-end-date-e-and-o-log
Sheet: Equipment

 |  |  |  |  |  | EQUIPMENT LOG
 |  |  |  |  |  |  |  |  |  | SORT COLUMN
 |  |  |  |  |  | Date
 | Year | Month | Initals | AFA  Request | Booking Ref | Booking Name | Contact Number | Contact Email | Number | Check in Date | Nights | Check Out | Overlap | Archive | CP Equipment Required | 3rd Party Equipment Requested | PO Required | PO Number | Comments
 | 2022/23 |  | SF |  | 123456 | Jones | 12345 |  | LB51 | 2022-08-15 00:00:00 | 7 |  |  |  | [NAME]
 | 2022/23 |  | SF |  | 987654 | Smith | 54321 |  | TO91 | 2022-08-15 00:00:00 | 7 |  |  |  | [NAME] |  | To Raise
 | 2022/23
 | 2022/23
 | 2022/23
 | 2022/23
 | 2022/23
 | 2022/23
Spreadsheet: a5a75fe6-3474-4cb9-aa1f-a197234eda23
Sheet: Sheet1

VDE cassette | [NAME] | dAG | Relevant Genotype
VDE1 | Wild type | 206 | ura3::URA3-[arg4-vde]/ura3::URA3-[arg4-bgl] spo11-Y135F-HA3His6::KanMX/SPO11 TFP1::VDE/TFP1::TFP1
 | dmc1 | 288 | ura3::URA3-[arg4-vde]/ura3::URA3-[arg4-bgl] spo11-Y135F-HA3His6::KanMX/SPO11 [NAME] TFP1::VDE/TFP1::TFP1
 | spo11 | 205 | ura3::URA3-[arg4-vde]/ura3::URA3-[arg4-bgl] spo11-Y135F-HA3His6::KanMX/spo11-Y135F-HA3His6::KanMX TFP1::VDE/TFP1::TFP1
 | sae2 | 277 | ura3::URA3-[arg4-vde]/ura3::URA3-[arg4-bgl] spo11-Y135F-HA3His6::KanMX/SPO11 [NAME]/TFP1::TFP1
 | [NAME] | 300 | ura3::URA3-[arg4-vde]/ura3::URA3-[arg4-bgl] spo11-Y135F-HA3His6::KanMX/SPO11 hop1::LEU2/hop1::LEU2 TFP1::VDE/TFP1::TFP1
 | ndt80 | 292 | ura3::URA3-[arg4-vde]/ura3::URA3-[arg4-bgl] spo11-Y135F-HA3His6::KanMX/SPO11 ndt80::ADE2/ndt80::ADE2 TFP1::VDE/TFP1::TFP1
 | spo11 dmc1 | 287 | ura3::URA3-[arg4-vde]/ura3::URA3-[arg4-bgl] spo11-Y135F-HA3His6::KanMX/spo11-Y135F-HA3His6::KanMX dmc1::ADE2/dmc1::ADE2 TFP1::VDE/TFP1::TFP1
 | sae2 dmc1 | 534 | ura3::URA3-[arg4-vde]/ura3::URA3-[arg4-bgl] spo11-Y135F-HA3His6::KanMX/ SPO11 [NAME]/TFP1::TFP1
 | hop1 dmc1 | 484 | ura3::URA3-[arg4-vde]/ura3::URA3-[arg4-bgl] spo11-Y135F-HA3His6::KanMX/SPO11 hop1::LEU2/hop1::LEU2 dmc1::ADE2/dmc1::ADE2 TFP1::VDE/TFP1::TFP1
 | ndt80 dmc1 | 806 | ura3::URA3-[arg4-vde]/ura3::URA3-[arg4-bgl] spo11-Y135F-HA3His6::KanMX/SPO11 ndt80::ADE2/ndt80::ADE2 dmc1::ADE2/dmc1::ADE2 trp1::hisG/TRP TFP1::VDE/TFP1::TFP1
 | spo11 hypomorph | 1402 | ura3::URA3-[arg4-vde]/ura3::URA3-[arg4-bgl] SPO11-HA3His6::KanMX/spo11-Y135F-HA3His6::KanMX dmc1::ADE2/dmc1::ADE2 TFP1::VDE/TFP1::TFP1
VDE2 | Wild type | 630 | ade2::ura3–arg4-vde–URA3/ade2 trp1::hisG/TRP1 SPO11/SPO11 TFP1::VDE/TFP1::TFP1 NUC1/NUC1
 | dmc1 | 1265 | ade2::ura3–arg4-vde–URA3/ade2 SPO11/SPO11 dmc1::ARG4/dmc1::ARG4 leu2/LEU2 TFP1::VDE/TFP1::TFP1 NUC1/NUC1
 | spo11 | 759 | ade2::ura3–arg4-vde–URA3/ade2 spo11-Y135F-HA3His6::KanMX/ spo11-Y135F-HA3His6::KanMX TFP1::VDE/TFP1::TFP1 NUC1/NUC1
 | spo11 dmc1 | 1284 | ade2::ura3–arg4-vde–URA3/ade2 spo11-Y135F-HA3His6::KanMX/ spo11-Y135F-HA3His6::KanMX dmc1::ARG4/dmc1::ARG4 leu2/LEU2 TFP1::VDE/TFP1::TFP1 NUC1/NUC1
 | rad54 | 1236 | ade2::ura3–arg4-vde–URA3/ade2 SPO11/SPO11 his4B/HIS4B leu2/LEU2 rad54∆/rad54∆ TFP1::VDE/TFP1::TFP1 NUC1/NUC1
All strains are Mat a/a diploids and are homozygous for HO::LYS2 lys2 nuc1::LEU2 leu2 ura3 arg4-nsp,bgl unless otherwise stated.
Supporting Information Table 1:  Strains used in this study.
Spreadsheet: 671809d1586545333-subtractct-lunch-time-lunch-time
Sheet: Sheet1

Preferred
[NAME] | [NAME] HOURS WORKED END TIME | Time for Lunch | [NAME]
08:00:00 | 16:30:00 | 0.5 |  | Needs to say 8 hours
Or
[NAME] | [NAME] HOURS WORKED END TIME | [NAME] | [NAME] | [NAME]
08:00:00 | 16:30:00 | 11:00:00 | 11:30:00 |  | Needs to say 8 hours
Spreadsheet: 26b74ebf-a1bd-4cc3-9abc-8275f34d4081
Sheet: Instructions

When utilizing the Pricing Program, use the milk price calculation form to determine the price of milk charged to students.
Milk Price Calculation:
Milk Varieties | Amount of Milk Purchased for One Month Period                                   (Enter the Number of Half Pints Purchased) | Cost Per Half Pint of Milk | Cost for Each Type of Milk for the Month
[NAME] purchased for the month | Insert the amount of half pints purchased for the month | Insert the cost per half pint of milk for each variety of milk | Total cost of each milk type purchased
Totals: | Sum of all milks purchased for the month |  | The total cost of all milk types purchased for the month
Weighted Average Cost: |  |  | These cells will pre-populate
Optional Handling Charge: (+$.05)
Current Reimbursement Rate for School Year 14-15: (+$.23)
Price Charged per Half Pint (Round to the nearest nickel):
Final Price Charged to Students :