tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 147703d1332938386-vlookup-based-on-id-and-date-range-vlookup-for-id-and-date-within-a-range
Sheet: Sheet1

Emp Id | Starte Date in project | End Date in project | Project Name |  |  |  | Audit Date | Emp Id | Desired Result | ANS
1 | 2012-01-01 00:00:00 | 2012-01-31 00:00:00 | Project1 |  |  |  | 2012-01-12 00:00:00 | 2 | Project1 | Project1
2 | 2012-01-01 00:00:00 | 2012-01-31 00:00:00 | Project1 |  |  |  | 2012-02-20 00:00:00 | 1 | Project2 | not
3 | 2012-01-01 00:00:00 | 2012-01-31 00:00:00 | Project1 |  |  |  | 2012-03-01 00:00:00 | 3 | Data Unavailable | not
1 | 2012-02-01 00:00:00 | 2012-02-28 00:00:00 | Project2 |  |  |  | 2012-02-12 00:00:00 | 2 | Project1 | Project2
2 | 2012-02-01 00:00:00 | 2012-02-28 00:00:00 | Project2
3 | 2012-02-01 00:00:00 | 2012-02-28 00:00:00 | Project2
Spreadsheet: 0f94718d-4550-4dd9-b185-226bda9c4847
Sheet: POWER Data 

Meteorology (Wind):
Monthly Averaged Wind Speed At 50 m Above The Surface Of The Earth (m/s)
Latitude (Enter Value for Your School Here) | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual
Longitude (Enter Value for your School Here) |  |  |  |  |  |  |  |  |  |  |  |  | Average
10-year Average
Minimum And Maximum Difference From Monthly Averaged Wind Speed At 50 m (%)
Latitude (Enter Value for Your School Here) | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual
Longitude (Enter Value for Your School Here) |  |  |  |  |  |  |  |  |  |  |  |  | Average
Minimum
Maximum
Parameter Definition           Units Conversion Chart
Difference Between The Average Wind Speed At 10 m Above The Surface Of The Earth And The Average Wind speed At 50 m Above The Surface Of The Earth (%)
Vegetation type :   (Enter the Vegetation Type Found at Your School Here)
Latitude (Enter Value for Your School Here) | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual
Longitude (Enter Value for Your School Here) |  |  |  |  |  |  |  |  |  |  |  |  | Average
10-year Average
Spreadsheet: 493571d1481778993-compare-2-columns-with-1-column-and-highlight-difference-substitute-twice-for-pradeep
Sheet: Sheet1

FirstName | LastName | Name | Difference
ELMIRA | SAGER NP | SAGER, NP-C, ELMIRA F
KAYLA | NEWCOMB | BRUMMITTE NEWCOMB, FNP-C, BSN, RN, KAYLA R
SHOAIB | QURESHI | QURESHI, MD, SHOAIB
[NAME] | III | ROWAN, MD, [NAME]
Sarra | [NAME] | BROWN, MD, SARAH L
JEREMY | ELLIOTT | ELLIOTT, DO, JEREMY N
ANTON | DANIEL | DANIEL, MD, ANTON C
THOMAS | COX III | COX, MD, THOMAS R
SAMUEL | MC GAHA | MCGAHA, MD, SAMUEL W
JEFFREY | HOPLAND M.D. | HOPLAND, MD, JEFFREY A
FESTUS | ARINZE | ARINZE, MD, FESTUS
ORAN | BERKENSTOCK | BERKENSTOCK, MD, ORAN L
jeffrery | hopland | HOPLAND, MD, JEFFREY A
[NAME] | Frye | FRYE, PA-C, VICKI R
[NAME] | Steptoe | STEPTOE, MD, WILLIAM J
RICHARD | GADDIS, DO | GADDIS, DO, RICHARD M
CAROL | VARNADO | VARNADO, MD, CAROL E
Beverly | Turner-Winbush | TURNER-WINBUSH, MD, BEVERLY
[NAME] | [NAME] | MCDERMOTT, MEDICAL DOCTOR, DIANE S
FAOUR | SALAH | FAOUR, MD, MUHAMED S
Deka | Efobi | EFOBI, MD, ANTHONY
[NAME] | Rhody | RHODY, MD, JACK R
Richmond | [NAME] | AKATUE, MD, RICHMOND A
Caleb | [NAME] | WARREN, MD, CALEB
[NAME] | Cox | COX, MD, [NAME]
[NAME] | [NAME] | FREEMON, MD, [NAME]
CHERI | JOHNSTON | JOHNSTON, MD, CHERI C
WILLIAM | MCKEE | MCKEE, MD, WILLIAM N
Padmavathy | Chunduru | CHUNDURU, MD, PADMAVATHY
Ashok | Bhandari | BHANDARI, MD, ASHOK
Spreadsheet: 07088cc2-37ee-4d9d-9059-b5778e3719c8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Table 2.1.4 – Processing Traffic 2006 and percentage variations 2004:2006. Veneto and Italy (current millions of euro)
 |  | Veneto |  |  | Italy
 |  | 2006(*) | % variations |  | 2006(*) | % variations
 |  | (millions) | 2006/05 | 2005/04 | (millions) | 2006/05 | 2005/04
 | temporary exports | 453.303675 | -0.2624819324445384 | -27.09825105793142 | 2884.942624 | -6.653862000928246 | -4.950012656535702
 | re-imports | 555.866575 | 6.759256631613794 | -32.98826282759605 | 3218.085241 | -4.095138201087875 | -4.247570000341208
 | temporary imports | 493.715496 | -32.11375635468413 | -6.155142016593432 | 9229.557055 | 4.002478710081625 | 0.6512560117785667
 | re-exports | 798.209598 | -2.125551435632787 | -8.222583089203413 | 10209.241413 | 9.495863949301235 | 5.669128487832467
 | (*) provisional data
 | Source: Processing by [NAME] SISTAR on Istat data
Spreadsheet: 885520d1735199670-generate-two-columns-based-on-a-branching-map-of-values-columns-worksheet-1-
Sheet: Sheet1

eukaryotes
animals
mammals
domestic
 | \ |  | \
service | pets |  | farm
 |  | \ |  | \ | \ | \ | \ | \
 | cat | dog | horse | cow | sheep | pig | chicken | goat
 |  | collie | quarter | holstein | dorper | hampshire | [NAME] | pygmy
eukaryotes | animals |  |  | animals
animals | mammals |  | animals | mammals
mammals | domestic |  | mammals | domestic
domestic | service |  | domestic | service
domestic | pets |  | domestic | pets
domestic | farm |  | domestic | farm
pets | cat |  | pets | cat
pets | dog |  | pets | dog
dog | collie |  | farm | horse
farm | horse |  | farm | cow
farm | cow |  | farm | sheep
farm | sheep |  | farm | pig
farm | pig |  | farm | chicken
farm | chicken |  | farm | goat
farm | goat |  | dog | collie
horse | quarter |  | horse | quarter
cow | holstein |  | cow | holstein
sheep | dorper |  | sheep | dorper
pig | hampshire |  | pig | hampshire
chicken | [NAME] |  | chicken | [NAME]
goat | pygmy |  | goat | pygmy
Spreadsheet: darrell_schoolcraft__7792__imbalsumm0107
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 27686 | 27476
2 | 27971 | 27476
3 | 81478 | 81305
4 | 92416 | 92044
5 | 104180 | 107044
6 | 85005 | 84253
7 | 102170 | 103816
8 | 101849 | 97816
9 | 101901 | 101981
10 | 80229 | 79575
11 | 91609 | 91496
12 | 91776 | 91496
13 | 98890 | 98105
14 | 95006 | 95675
15 | 98127 | 90791
16 | 95603 | 94316
17 | 67072 | 66798
18 | 100738 | 99995
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | 48879.09
2001-07-18 00:00:00
Spreadsheet: kam_keiser__18048__EY request2_jh
Sheet: Request List

Item # | Description | Date Requested | Enron Contact | Enron Lead | Expected Date
1 | Daily Position Report by Counterparty/by Product as of November 30, 2001 | 2002-01-10 00:00:00 | [NAME] | [NAME] | 2002-01-14 00:00:00
2 | Daily Position Reports of Selected Post Petition Dates (12/31/01 requested) | 2002-01-10 00:00:00 | [NAME] | [NAME] | 2002-01-17 00:00:00
4 | Position Reports by Product/By Tenor (maturity buckets) | 2002-01-10 00:00:00 | [NAME] | [NAME] | 2001-01-18 00:00:00
5 | Position Reports by Commodity | 2002-01-10 00:00:00 | [NAME] | [NAME] | 2001-01-18 00:00:00
6 | Representation of Setoff/Netting Issues for Each Counterparty | 2002-01-10 00:00:00 | [NAME] | [NAME]
7 | Inventory Values By Product/By Entity/By Location | 2002-01-10 00:00:00 | [NAME] | [NAME]
8 | Product Programs for Each Desk and Sample Contracts | 2002-01-10 00:00:00 | [NAME] | [NAME] | 2002-01-18 00:00:00
9 | Supporting Documentation to Review Methodology and Approaches for Valuation Models | 2002-01-10 00:00:00 | [NAME] | [NAME] | 2001-01-25 00:00:00
 | Detailed Description of  Methodology to Construct Valuation Curves by Commodity and Copy of Policy & Procedures Documentation, if [NAME] | 2002-01-10 00:00:00 | [NAME] | [NAME] | 2001-01-25 00:00:00
11 | Where Appropriate, Market Data/Third Party Broker Quotes Supporting Curves when Reviewing Transactions | 2002-01-10 00:00:00 | [NAME] | [NAME] | 2001-01-25 00:00:00
12 | Listing of Counterparties that have entered into Global Master Netting Agreements with Enron, including effective and signing dates, as well as copies of the Agreements | 2002-01-10 00:00:00 | [NAME] | [NAME] | 2002-01-18 00:00:00
13 | Listing of All Outstanding Trading Related Intercompany Transactions (Debtor and Non-Debtor Entities) | 2002-01-10 00:00:00 | [NAME] | [NAME] | 1/21/21/02
14 | Corporate Organizational Charts and Reporting Lines Pre and Post Petition | 2002-01-10 00:00:00 | [NAME] | [NAME] | 2002-01-18 00:00:00
Spreadsheet: 44dfd1fa-4681-45da-961f-3277595f97b2
Sheet: Sheet1

Table S5:  Primers used for qRT-PCR analysis. | Unnamed: 1 | Unnamed: 2
Gene prediction notations are as follows: G = Jan06m300_GLEAN, A = aug_GLEAN.
Gene | Primer 1 | Primer 2
rad21.1 | TACGCTGAAGCCATTCTTTCGAGG | CCTTTCGACTGTAGATGCGAACCA
rad21.2 | AGAGCTATGCAGACATGAGTTGCC | TACTAGAATCCTGTGCACCGTCGT
rec8 | ACATGGCAACTACACCTCAGTTCG | [NAME]
G_10188 | CACATTACATCCAACGCCCTGCAA | AATAACGGCTGGGATGACCACTAC
A_07768 | CGGACGCAGATTACCTCATTGACA | AGTAATCCGCTAGTTCGAGCCTGT
mre11 | CTCAAGCACTATGGGAAGAACGCA | CCTTCTTGGATCTGTGGAACACAAGC
mer3 | TCCTCGATAGCAAGCTGTTTGGTG | CTGCATGGTGAACTCCAATACCGT
spo11 | TTAGTGGACGACCTTGCGGC | CTACAACCAATACCCACGCGATGT
[NAME] | TTGCCCTCATTCAGATAATGGCCC | TCGTCAAGCAGGATAAGAGAACGG
G_05011 | AACTCTGTGGCCTCTTCCAATGAC | TTAAGCGCCAATGGAGATGGGTGT
G_12285 | AGTCTCTCGTAGTTCATGGAGGCT | CCAAATCTCCAGCAGGATTGGTGA
Spreadsheet: 724662d1616294293-formula-to-look-column-a-and-column-c-and-place-desired-outcome-in-column-e-sample_place
Sheet: Sheet1

Date | User | YR _ User | Organization | Outcome
1999 | Fair, Usher F. |  | M.M. Inc. | Alpha & Son, Corp.
2000 | Fair, Usher F. |  | M.M. Inc. | Alpha & Son, Corp.
1999 | Fair, Usher F. |  | Alpha & Son, Corp. | M.M. Inc.
2000 | Fair, Usher F. |  | Alpha & Son, Corp. | M.M. Inc.
1999 | Fac, [NAME] |  | [NAME] | Mums & Dads Company
1999 | Fac, [NAME] |  | Mums & Dads Company | [NAME]
Spreadsheet: 875198d1721780335-formula-returning-false-value-why-book1a
Sheet: Formula Criterion

1
Spreadsheet: 288320d1389157213-how-to-repeat-same-values-latha-mani
Sheet: Sheet1

1001 | 5
1002 | 10
1003 | 48
1004 | 25
1005 | 35
1006 | 5
1007 | 8
1008 | 9
1009 | 7
1010 | 6
1011 | 7
1012 | 74
1013 | 4
1014 | 4
1015 | 4
1016 | 5
1017 | 4
1018 | 4
1019 | 4
1020 | 5
1021 | 8
Spreadsheet: b8366529-91fe-459a-b123-87fdb747c094
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
JCEDR | Test | JCEDR | [NAME], IgE | [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.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	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
JCEDR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
JCEDR | Result | JCEDR | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 14035-0 | Cryptomeria [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 682476d1592130089-help-with-drivers-hours-calculations-2020-06-14-oeldere-motzil-682470d1592124157-help-with-drivers-hours-calculations-weekly-runni
Sheet: Oeldere

Date | Day | [NAME] | Start Location | End Millage | End Location | Total Miles | Start Time | Finish Time | Total Hrs Worked | Daily Rest | Driver | manualy |  | help 1 | help 2 | 9 days, 0:00:00
2020-06-07 00:00:00 | Sun |  |  |  |  |  |  |  |  |  | 1
2020-06-08 00:00:00 | Mon | 421537 | Halfway | 421969 | Oakham |  | 00:45:00 | 15:45:00 |  |  | 1 | 09:30:00
2020-06-09 00:00:00 | [NAME] | 421969 | Oakham | 422376 | Ashford |  | 01:14:00 | 16:13:00 |  |  | 1 | 11:02:00
2020-06-10 00:00:00 | Weds | 422376 | Ashford | 422777 | Basildon |  | 03:45:00 | 18:42:00 |  |  | 1 | 10:53:00
2020-06-11 00:00:00 | Thurs | 422777 | Basildon | 423008 | [NAME] |  | 04:15:00 | 18:56:00 |  |  | 1 | 11:27:00
2020-06-12 00:00:00 | Fri | 423008 | [NAME] | 423348 | [NAME] |  | 05:23:00 | 18:03:00 |  |  | 1 | 11:12:00
2020-06-13 00:00:00 | Sat | 423348 | [NAME] | 423538 | Halfway |  | 05:15:00 | 11:00:00 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  | Total
I am a small transport company and I am trying to perfect a spread sheet that will record each drivers shift hours, [NAME] and Weekly rest. I have created a framework that works in part. However it falls downs in certain areas. I have enclosed a copy so that you can see what I’m trying to achieve.
You will see that from rows H & I. I have a drivers Start Time and Finish Time. What I want to do in row K is workout the drivers daily rest. By taking the Finish time on Tuesday and the start time on the Wednesday and deduct those hours. As currently I’m having to enter it manually. Which is way too slow. However I am currently using Sum to deduct H from I to give me the drivers total shift hours.
I would then like to take row J and work out the total number of hours worked over a 6 day period. But sum will not work for this calculation. I not sure if this is due to time cell format or the fact that I’m using H&I already
My third task is to calculate a drivers weekly rest. i.e take his/her finish time on Fri/Sat and calculate the number of hours from their Start time on Monday or whatever day they return to work i.e 17:00 Friday to 04:00 Monday which is 59 hours and for this to be displayed in a stand alone cell.
I have been using excel for a few years. But only for basics and I don’t wish to sound ungrateful when I ask if its possible for some to explain/show me how I need to make this calculation so that i can understand the principal should i have a similar problem later. I’m happy to play about till i get it right
Incidentally I am using office 365 on an iMac and on an iPad if this has any bearing.
Spreadsheet: 220924d1363303277-inventory-problem-calculator
Sheet: Vlookup Data

 |  | CODE | SUPPLIER | DESC | CASE | -2 | -1 | CURR | STOCK | PALLET | LAYER | ON ORD | LOC | DL
 | 1 | 1234 | A | SOME PRODUCT | 6 | 280 | 420 | 230 | 230 | 100 | 20 | 0 | A
 | 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 | TEST LINE
Spreadsheet: 490206d1479745749-conditional-formatting-based-on-column-average-conditional-formatting
Sheet: Sheet1

824 | 292 | 787 | 387 | 268 |  | Average + | 0.1
145 | 962 | 788 | 832 | 169
105 | 147 | 71 | 293 | 816
54 | 474 | 649 | 386 | 558
388 | 747 | 837 | 834 | 98
711 | 509 | 212 | 630 | 647
394 | 329 | 384 | 604 | 583
453 | 244 | 41 | 928 | 354
815 | 922 | 313 | 464 | 776
183 | 715 | 320 | 168 | 840
263 | 253 | 83 | 399 | 771
206 | 335 | 50 | 888 | 110
800 | 816 | 245 | 138 | 87
163 | 779 | 294 | 631 | 128
930 | 982 | 814 | 892 | 27
303 | 167 | 63 | 737 | 76
773 | 703 | 935 | 33 | 392
277 | 264 | 683 | 819 | 14
262 | 722 | 576 | 978 | 381
500 | 786 | 438 | 309 | 912
 |  |  |  |  |  | Calculated averages with the added factor in H1
Spreadsheet: 879328d1726819526-how-to-convert-data-from-columns-to-rows-book1-2-
Sheet: Sheet1

Program
[NAME] name
Spreadsheet: 28285d1222342101-looking-up-value-to-a-name-test
Sheet: Sheet1

Alina | 24 | 31 | 0 | 31 | 129.1666666666667
Andreas | 16 | 14 | 3 | 17 | 106.25
Beate | 17 | 22 | 3 | 25 | 147.0588235294118
Christine | 30 | 26 | 3 | 29 | 96.66666666666667
Danni | 27 | 26 | 5 | 31 | 114.8148148148148
Elina | 21 | 20 | 1 | 21 | 100
Eva | 24 | 24 | 5 | 29 | 120.8333333333333
Hanna | 23 | 12 | 11 | 23 | 100
Hans | 10 | 10 | 0 | 10 | 100
[NAME] | 14 | 13 | 2 | 15 | 107.1428571428571
[NAME] | 29 | 22 | 5 | 27 | 93.10344827586208
[NAME] | 25 | 21 | 4 | 25 | 100 |  | Group1 |  |  | Group 2
[NAME] | 27 | 28 | 0 | 28 | 103.7037037037037 |  | Alina |  |  | Elina
[NAME] | 14 | 9 | 4 | 13 | 92.85714285714285 |  | [NAME] |  |  | [NAME]
[NAME] | 22 | 13 | 1 | 14 | 63.63636363636363 |  | Beate |  |  | [NAME]
Laila | 14 | 18 | 1 | 19 | 135.7142857142857 |  | Hans |  |  | [NAME]
Lars | 24 | 21 | 3 | 24 | 100 |  | Knut |  |  | [NAME]
Lina | 34 | 18 | 9 | 27 | 79.41176470588235 |  | Laila |  |  | Sanna
Lotta | 14 | 26 | 3 | 29 | 207.1428571428571 |  | Liane |  |  | [NAME]
Magnus | 17 | 17 | 2 | 19 | 111.7647058823529 |  | Magnus |  |  | Ulla
[NAME] | 20 | 20 | 0 | 20 | 100 |  | [NAME]
Maria | 3 | 3 | 0 | 3 | 100 |  | Oerjan
Markus | 9 | 6 | 2 | 8 | 88.88888888888889 |  | Tor
Martin | 40 | 35 | 6 | 41 | 102.5 |  | [NAME]
Nikolaj | 10 | 9 | 0 | 9 | 90
Oerjan | 3 | 3 | 0 | 3 | 100 |  | Group 3 |  |  | Group 4
[NAME] | 7 | 6 | 3 | 9 | 128.5714285714286 |  | Andreas |  |  | Danni
[NAME] | 8 | 6 | 0 | 6 | 75 |  | Christine |  |  | [NAME]
Sanna | 7 | 11 | 1 | 12 | 171.4285714285714 |  | Eva-Marie |  |  | Jesper
[NAME] | 19 | 0 | 0 | 0 | 0 |  | Hanna |  |  | [NAME]
[NAME] | 4 | 7 | 1 | 8 | 200 |  | [NAME] |  |  | Maria
[NAME] | 20 | 16 | 4 | 20 | 100 |  | Lars |  |  | Martin
Ulla | 1 | 1 | 0 | 1 | 100 |  | Lina |  |  | Nikolaj
[NAME] | 7 | 8 | 1 | 9 | 128.5714285714286 |  | Markus |  |  | [NAME]
Total | 597 | 532 | 87 | 619 | 103.6850921273032 |  | [NAME]
Spreadsheet: 82581d1282652590-excel-2007-vlookup-formula-for-more-than-one-sheet-and-if-function-workbook-1
Sheet: Months

Months
January | 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
February | 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
March | 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
April | 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
May | 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
June | 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
July | 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
August | 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
September | 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
October | 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
November | 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
December | 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
Spreadsheet: d1fe5913-fa3e-4926-86b8-0dbd50509d1f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3736 | 7381 | Margarita | Riera | ESP | 472 | 00:24:11 | 00:02:02 | 01:27:47 | 00:01:15 | 00:49:07 | 1 | 02:44:21
3736 | 21300 | Monika | Wille | GER | 471 | 00:30:14 | 00:03:05 | 01:26:01 | [NAME] | 00:50:36 | 2 | 02:51:36
3736 | 22553 | [NAME] | [NAME] | GBR | 473 | 00:31:16 | 00:02:55 | 01:33:48 | 00:01:34 | 00:52:05 | 3 | 03:01:36
Spreadsheet: f1c85d0b-a395-41db-860a-67c649cbc8e1
Sheet: Sheet1

E2F TRANSFAC motif | Unnamed: 1 | E2F1-AP2 chromatin immunoprecipitation | Unnamed: 3 | ER chromatin immunoprecipitation | Unnamed: 5 | ER-mediated transcriptional change | Unnamed: 7
GeneID | Gene name | GeneID | Gene name | GeneID | Gene name | GeneID | Gene name
794 | CALB2 | 794 | CALB2 | 5728 | PTEN | 1001 | CDH3
1131 | CHRM3 | 1001 | CDH3 | 29842 | TFCP2L1 | 54149 | C21orf91
1824 | DSC2 | 3696 | ITGB8 | 57489 | [NAME] | 81611 | ANP32E
3696 | ITGB8 | 7368 | UGT8 | 80176 | SPSB1 | 149466 | C1orf210
5728 | PTEN | 29842 | TFCP2L1
7368 | UGT8 | 54149 | C21orf91
25894 | PLEKHG4 | 55520 | ELAC1
29842 | TFCP2L1 | 55612 | C20orf42
55520 | ELAC1 | 80176 | SPSB1
55612 | FERMT
57489 | [NAME]
80176 | SPSB1
84072 | HORMAD1
140578 | CHODL
152559 | PAQR3
Spreadsheet: 125369d1318993141-interest-calculated-daily-and-charged-quarterly-samp
Sheet: Sheet1

Balance
Days | 31 | Beginning Balance | 10000
Day | Purchase | Payment | BAL
1 |  | 1000 | 9000
2 |  |  | 9000
3 |  |  | 9000
4 |  |  | 9000
5 |  | 100 | 8900
6 |  |  | 8900
7 |  |  | 8900
8 |  |  | 8900
9 |  |  | 8900
10 |  |  | 8900
11 |  |  | 8900
12 |  |  | 8900
13 |  |  | 8900
14 |  |  | 8900
15 |  |  | 8900
16 |  |  | 8900
17 |  |  | 8900
18 |  |  | 8900
19 |  |  | 8900
20 |  |  | 8900
21 |  |  | 8900
22 |  |  | 8900
23 |  |  | 8900
24 |  |  | 8900
25 |  |  | 8900
26 |  |  | 8900
27 |  |  | 8900
28 |  |  | 8900
29 |  |  | 8900
30 |  |  | 8900
31 |  |  | 8900
Total All Balances |  |  | 276300
Days |  |  | 31
Average Daily |  |  | 8912.90322580645
Enter Annual Percentage Rate |  |  | 0.1
/ Days In The Year |  |  | 365
XBy Days In Billing Cycle |  |  | 31
X Average Daily Balance |  |  | 8912.90322580645
Interest Charge |  |  | 75.69863013698631
Spreadsheet: 36470d1234358493-moving-rows-to-anoter-worksheet-based-on-certain-criteria-anz-maximizer-monthly-kpi
Sheet: Steve

Opportunity Leader | Address Book Entry | Close Date | Number of Analyzers required | Total Capital | Annual Number of Cartridges | Annual Cartridge Revenue | Status | Confidence Rating | Revenue
want all rows from data drop sheet with name = [NAME] to appear here
1 |  |  | 0 | 0 |  | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 859429d1707825704-if-function-not-working-book-6-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  | IF | IF
 |  |  |  |  |  | 1 | 4
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1
 |  |  |  |  |  | 23
 |  |  |  |  |  | 12 | 2
 |  |  |  |  |  |  | 1
 |  |  |  |  |  | 4 | 3
 |  |  |  |  |  | 56 | 5
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1 | 6