tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 149189d1333737065-excel-2007-data-table-total-row-wont-calculate-time-employee-2-timecard
Sheet: April 2

 |  |  | Employee Name |  |  |  |  |  |  |  |  |  |  | Week Start Date |  |  |  | 2012-04-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Week End Date
 |  | Job / Task Information |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  | Sunday
 |  | Client | Cost Code | Written Description | Start | Stop | Tally | Start | Stop | Tally | Start | Stop | Tally | Start | Stop | Tally | Start | Stop | Tally | Start | Stop | Tally | Start | Stop | Tally | TOTAL
 |  | [NAME] | 100.630   General Condition Punchlist & Misc. Construction |  | 08:00:00 | 09:45:00
 |  | Arlington / Drake | 100.640   General Condition Supervision |  | 09:45:00 | 14:15:00
 |  | Arlington / Drake | 100.640   General Condition Supervision |  | 14:15:00 | 17:15:00
 |  | Testing 11 | 100.610   General Condition Debris Removal & Cleanup |  |  |  |  | 08:15:00 | 10:15:00
 |  | Testing 11 | 101.120   Sitework Tree Removal |  |  |  |  | 10:15:00 | 13:00:00
 |  | Testing 11 | 100.610   General Condition Debris Removal & Cleanup |  |  |  |  | 13:00:00 | 17:00:00
 |  | Testing 11 | 100.610   General Condition Debris Removal & Cleanup |  |  |  |  |  |  |  | 08:00:00 | 10:00:00
 |  | Testing 14 | 100.610   General Condition Debris Removal & Cleanup |  |  |  |  |  |  |  | 10:00:00 | 12:00:00
 |  | Testing 14 | 100.620   General Condition Safety & Control Measures |  |  |  |  |  |  |  | 12:00:00 | 14:30:00
 |  | Testing 14 | 100.620   General Condition Safety & Control Measures |  |  |  |  |  |  |  | 14:30:00 | 16:30:00
 |  | Testing 14 | 106.230   Site Finishes & Landscape Finished Landscape Fence | Finished the Landscape fence around the house |  |  |  |  |  |  | 16:30:00 | 17:30:00
 |  | Testing 14 | 000.002   Lunch |  |  |  |  |  |  |  |  |  |  | 10:15:00 | 12:15:00
 |  | Testing 14 | 100.615   General Condition Silt Fencing |  | 05:00:00 | 05:30:00
 |  |  |  |  | Monday Total |  |  | Tuesday Total |  |  | Wednesday Total |  |  | Thursday Total |  |  | Friday Total |  |  | Saturday Total |  |  | Sunday Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week Total
 |  | Reimbursements
 |  | Client | Cost Code | Written Description | Amount
 |  |  |  | Total Reimbursement
Spreadsheet: 758953d1639168595-countifs-with-blank-criteria-countifs-with-blank-criteria
Sheet: Sheet1

Criteria 1 | [NAME] | Criteria 3 | [NAME] |  | [NAME]: | [NAME] suggested | sumproduct: | Expected: |  | Fruit | Price | Season | Organic or not
Apple | 18 | Autumn | Yes |  |  |  |  | 2 |  | Apple | 18 | Autumn | Yes
Apple | 18 |  |  |  |  | original - ignore |  | 2 |  | Apple | 18 | Autumn | Yes
[NAME] |  | Summer |  |  |  |  |  | 2 |  | Apple | 18 | Autumn | Yes
[NAME] |  |  | No |  |  |  |  | 0 |  | Apple | 18 | Autumn | Yes
 |  |  |  |  |  |  |  |  |  | Apple | 18 | Autumn | Yes
 |  |  |  |  |  |  |  |  |  | Apple | 18 | Autumn | Yes
 |  |  |  |  |  |  |  |  |  | [NAME] | 18 | Summer | No
 |  |  |  |  |  |  |  |  |  | [NAME] | 45 | Summer | No
 |  |  |  |  |  |  |  |  |  | [NAME] | 18 | Summer | No
 |  |  |  |  |  |  |  |  |  | [NAME] | 45 | Summer | No
 |  |  |  |  |  |  |  |  |  | [NAME] | 18 | Winter | No
 |  |  |  |  |  |  |  |  |  | [NAME] | 45 | Winter | No
 |  |  |  |  |  |  |  |  |  | [NAME] | 16 | Summer | Yes
 |  |  |  |  |  |  |  |  |  | [NAME] | 76 | Summer | Yes
 |  |  |  |  |  |  |  |  |  | [NAME] | 16 | Summer | Yes
 |  |  |  |  |  |  |  |  |  | [NAME] | 76 | Summer | Yes
 |  |  |  |  |  |  |  |  |  | [NAME] | 16 | Summer | No
 |  |  |  |  |  |  |  |  |  | [NAME] | 76 | Summer | No
 |  |  |  |  |  |  |  |  |  | Orange | 15 | Winter | No
 |  |  |  |  |  |  |  |  |  | Orange | 56 | Winter | No
 |  |  |  |  |  |  |  |  |  | Orange | 15 | Winter | No
 |  |  |  |  |  |  |  |  |  | Orange | 56 | Winter | No
 |  |  |  |  |  |  |  |  |  | Orange | 15 | Winter | No
 |  |  |  |  |  |  |  |  |  | Orange | 56 | Winter | No
Spreadsheet: 811846d1672831266-identify-last-entry-and-display-data-staff-work-allocations-2023-v2-1-
Sheet: 2023

 |  |  | WRAPPING (R) |  | Wrapping (%) |  | AUTOCLAVE (A) | AUTOCLAVE (%) |  | BOOKING ON (B) | BOOKING ON (%) |  | WASH EMPTY (E) | WASH EMPTY (%) |  | PORTERING (P) | PORTERING (%) |  | WASH (W) | WASH (%) |  | JANUARY
SURNAME | FIRST NAME |  |  | Last Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  | 2023-01-02 00:00:00 |  | 2023-01-03 00:00:00 |  | 2023-01-04 00:00:00 |  | 2023-01-05 00:00:00 |  | 2023-01-06 00:00:00 |  | 2023-01-07 00:00:00 |  | 2023-01-08 00:00:00 |  | 2023-01-09 00:00:00 |  | 2023-01-10 00:00:00
aaaa | aaaaa
aaaaa | aaaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r |  | a |  | b |  | w |  | e |  |  | r | r
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 | Hans
 | avk
Spreadsheet: michelle_lokay__26627__imbalsumm0102
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 6766 | 5699 | 104 | 86 | 1368 | 1203 | 1841 | 1182
2 | 4639 | 5862 | 79 | 91 | 1158 | 1182 | 1791 | 1923
3 | 6141 | 5862 | 95 | 91 | 672 | 1182 | 1847 | 1923
4 | 6706 | 5862 | 84 | 91 | 1203 | 1182 | 1844 | 1923
5 | 6889 | 5861 | 70 | 91 | 1005 | 1182 | 1830 | 1923
6 | 6901 | 5862 | 84 | 91 | 1161 | 1182 | 1812 | 1923
7 | 6504 | 5862 | 128 | 91 | 1412 | 1182 | 1767 | 1923
8 | 6408 | 5862 | 168 | 85 | 1302 | 1109 | 1775 | 1923
9 | 6262 | 5862 | 159 | 91 | 1388 | 1182 | 1790 | 1923
10 | 6435 | 5862 | 149 | 91 | 1338 | 1182 | 1765 | 1923
11 | 6475 | 5862 | 152 | 91 | 929 | 1182 | 1746 | 1923
12 | 181 | 5862 | 109 | 91 | 964 | 1182 | 1745 | 1923
13 | 6841 | 5862 | 145 | 91 | 948 | 1182 | 1731 | 1923
14 | 6761 | 5862 | 149 | 91 | 1028 | 1182 | 1742 | 1923
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  |  |  |  |  |  |  | 612557.93
2001-02-14 00:00:00
Spreadsheet: 711418d1609698031-extract-data-in-two-columns-into-one-column-with-formula-sample_twocolumns_to_onecolumn
Sheet: DataBase

Last Name | First Name
Abdelnour | Abnor
Abdelrahman | Abo
Abdi | Abra
Abdo | Abrahaim
[NAME] | [NAME]
Abdoo | Abrahame
Abdou | Abrahamo
Abdul | [NAME]
Abdulla | Abraheem
[NAME] | Abrahem
[NAME] | Abrahim
[NAME] | Abrahm
Abed | Abrahon
Abee | Abrahsa
[NAME] | Abram
Abegglen | Abramo
Abeita | Absalon
Abel | Abselon
[NAME] | Absolom
Abele | Absolum
Abeles | [NAME]
Spreadsheet: 760405d1640190952-embedded-math-in-vlookup-ok-to-post-hourly-timesheet-generic-aes-template2
Sheet: TS-1

State: | Florida |  |  |  | Pay Period: |  |  |  | Through:
Work Site: | 20 - Waste Connections Leesville |  |  |  | Onsite Manager: |  | [NAME]
Date |  | Mon | [NAME] | Wed | Thur | Fri | Sat | Sun | Total Hours | Reg Hours | OT Hours | Extra Pay/ Bonus | Reg Hourly Pay Rate | Reg Hourly [NAME] | OT Hourly Pay Rate | OT Hourly Bill Rate | Total Earnings | Total Reg Bill | Total OT Bill | [NAME] | Total Invoice
 |  | 2021-10-25 00:00:00
Last Name | First Name | Hours | Hours | Hours | Hours | Hours | Hours | Hours
 |  | 6 | 9 | 11 | 5 | 8 | 6 |  |  |  |  | 100 | 15.5
TOTAL:
No Longer Employed - Mark this color
Spreadsheet: 0ffbbf19-3513-43d9-b6f7-ba180395f4c9
Sheet: 5 | Not included

 |  | --> Return to first page
MRWs not included on SpringerReference
Following groups of titles are not included on SpringerReference: SpringerHandbooks, German-language titles, Handbook of Neurochemistry series, Spin-Offs.                                                                                                                                    Following titles were not migrated because not suitable:
Title | [NAME]. | Library
Computational Complexity: Theory, Techniques, and Applications [spin-off Enc Complexity] | 1 | Computer Science
Concise Encyclopedia of Supersymmetry | 1 | Physics and Astronomy
Directory of Microbicides for the Protection of Materials | 1 | Chemistry and Materials Science
[NAME] of Acoustics | 1 | Engineering
Handbook of K-Theory | 1 | Mathematics and Statistics
Handbook of Neurochenistry series | 3 | Biomedical and Life Sciences
Historical Encyclopedia of Natural and Mathematical Sciences | 1 | Earth and Environmental Science
Host Plant Catalogue of Aphids | 1 | Biomedical and Life Sciences
[NAME] for the Year 2000 | 1 | Humanities
[NAME] for the Year 2001 | 1 | Humanities
[NAME] for the Year 2002 | 1 | Humanities
Magnetism: Fundamentals, Materials, Applications | 1 | Engineering
Mathematics of Complexity and Dynamical Systems [spin-off Enc Complexity] | 1 | Mathematics and Statistics
Springer Handbook of Acoustics | 1 | Physics and Astronomy
Springer Handbook of Atomic, Molecular and Optical Physics | 2 | Physics and Astronomy
Springer Handbook of Condensed Matter and Materials Data | 1 | Chemistry and Materials Science
Springer Handbook of Electronic and Photonic Materials | 1 | Chemistry and Materials Science
Springer Handbook of Engineering Statistics | 1 | Engineering
Springer Handbook of Experimental [NAME] | 1 | Engineering
Springer Handbook of Experimental Solid Mechanics | 1 | Engineering
Springer Handbook of Lasers and Optics | 1 | Physics and Astronomy
Springer Handbook of Materials Measurement Methods | 1 | Chemistry and Materials Science
Springer Handbook of Nanotechnology | 1 | Engineering
Springer Handbook of Nanotechnology | 2 | Engineering
Springer Handbook of Speech Processing | 1 | Engineering
The ASCRS Textbook of Colon and Rectal Surgery | 1 | Medicine
The Springer Index of Viruses | 1 | Biomedical and Life Sciences
VDI-Heat Atlas | 1 | Engineering
VDI-Wärmeatlas | 10 | Engineering
Wörterbuch Design | 1 | Architecture
--> Return to first page
Spreadsheet: 0a2d325c-cd46-439f-b4f3-af24c55eaae8
Sheet: Sheet1

Table S15. Functional enrichment using Ingenuity category  Top Bio Function
for PCL-responsive genes at week 40
Top Bio functions - Disease and Disorders
Name | p-value | # Molecules
Connective Tissue Disorders | 1.24x10-10 - 4.23x10-3 | 59
Metabolic Disease | 1.24x10-10 - 2.25x10-2 | 58
Hematological Disease | 4.68x10-7 - 2.25x10-2 | 24
Endocrine Systems Disorders | 1.28x10-6 - 2.25x10-2 | 38
Genetic Disorders | 2.09x10-5 - 3.74x10-2 | 57
Top Bio functions - Molecular and Cellular Functions
Name | p-value | # Molecules
Lipid Metabolism | 3.97x10-17 - 3.67x10-2 | 130
Molecular Transport | 3.97x10-17 - 3.51x10-2 | 105
Small Molecule Biochemistry | 3.97x10-17 - 3.89x10-2 | 160
Energy Production | 8.44x10-15 - 2.16x10-2 | 34
Carbohydrate Metabolism | 4.79x10-10 - 2.98x10-2 | 81
Spreadsheet: 273014d1382576421-vlookup-nested-functions-sample-file_102313
Sheet: Data

Reference # | Status | Score | Username | [NAME] | Team Name: | Team Number: | Your First Name: | Your Last Name: | [NAME]: | Team Satisfaction | Please add any comments about your rating below | Team Member 1 (You): | Team Member 1 Contribution % | Team Member 2: | Team Member 2 Contribution % | Team Member 3: | Team Member 3 Contribution % | Team Member 4: | Team Member 4 Contribution % | Team Member 5: | Team Member 5 Contribution % | Team Member 6: | Team Member 6 Contribution %
7400173 | Complete | 100 | none | none | TeamA | 1 | [NAME] | Poppins | [EMAIL] | Strongly Agree | Overall I would say our group was very effective. | [NAME] | 15 | [NAME] | 21 | [NAME] | 12 | Dawson | 15 | [NAME] | 15 | Anna | 22
7400172 | Complete | 100 | none | none | TeamA | 1 | [NAME] | Test2 | [EMAIL] | Agree | We worked well together and had few issues with personal conflicts. | [NAME] | 18 | Anna | 20 | [NAME] | 16 | Dawson | 16 | [NAME] | 16 | [NAME] | 14
7401917 | Complete | 100 | none | none | TeamA | 1 | Anna | Test3 | [EMAIL] | Agree | Our group was definitely one of the more productive, focused, and organized group, but there were some issues with scheduling and group dynamics. | Anna | 20 | [NAME] | 10 | [NAME] | 20 | [NAME] | 17 | [NAME] | 17 | Dawson | 16
7400194 | Complete | 100 | none | none | TeamA | 1 | [NAME] | Test4 | [EMAIL] | Strongly Agree | We always completed our work to the best of our ability given certain unwelcomed circumstances. | [NAME] | 17 | [NAME] | 18 | [NAME] | 15 | Dawson | 15 | [NAME] | 15 | Anna | 20
7400191 | Complete | 100 | none | none | TeamA | 1 | Dawson | Test5 | [EMAIL] | Strongly Agree | My team worked effectively and efficiently when given any task. WE always got work done on time and before any other groups, and it was always done to the best of our abilities. | Dawson | 10 | [NAME] | 10 | Anna | 30 | [NAME] | 15 | [NAME] | 25 | [NAME] | 10
7400206 | Complete | 100 | none | none | TeamA | 1 | [NAME] | Test6 | [EMAIL] | Agree |  | [NAME] | 19 | [NAME] | 10 | Dawson | 19 | [NAME] | 19 | [NAME] | 14 | Anna | 19
Spreadsheet: 878027d1724980233-linking-two-sheets-with-data-specific-information-master-sample-test-jwalden15-
Sheet: Sample Register 

Sample No | Sample Identification |  |  |  | Mass  Received | Sample Type | Date  Received | Job Number | Client | Job Details | Prep | CL | HAC | A/C | MIX | A/S SO3 | W/S SO4 | tS | S2- | Alkalis | Volhard | Paint | Water | C/S | Other
1 | S1 | TP5 | 5-25 |  |  | Concrete Dust | 2024-08-28 00:00:00 | 21544 | Walden | [NAME] camebridge |  | x |  |  |  |  |  |  | x | x
2 | S2 |  | 5-26 |  |  |  |  |  |  |  |  | x | x
3 | S3 |  | 5-27 |  |  |  |  |  |  |  |  | x | x
4 | [NAME] |  | 5-28 |  |  |  |  |  |  |  |  | x |  |  |  | x
5 | S5 |  | 5-29 |  |  |  |  |  |  |  |  |  |  |  |  | x
6 | S6 |  | 5-30 |  |  |  |  |  |  |  |  | x |  | x
7 | S7 |  | 5-31 |  |  |  |  |  |  |  |  | x |  | x
8 | S8 |  | 5-32 |  |  | [NAME] |  |  |  |  |  |  |  |  | x
9 |  |  |  |  |  |  |  | 21545
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
Spreadsheet: andy_zipper__735__10_29_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 |  |  |  |  |  | 27.1 | 2001-10-25 14:38:00
 | NG Z1 | 325 | 61 | 63 | 83.9 | 86.6 | 17.42 | 2001-10-29 10:14:00
 | NG F2 | 340 | 85 | 89 | 79.4 | 83.2 | 17.38 | 2001-10-29 10:14:00
 | NG G2 | 340 | 98 | 102 | 73.5 | 76.5 | 16.03 | 2001-10-29 10:14:00
 | NG H2 | 330 | 98 | 102 | 66.4 | 69.2 | 14.07 | 2001-10-29 10:14:00
 | NG J2 | 320 | 82 | 86 | 51.7 | 54.2 | 10.65 | 2001-10-29 10:14:00
 | NG K2 | 325 | 85 | 89 | 48.1 | 50.4 | 10.06 | 2001-10-29 10:14:00
 | NG M2 | 325 | 89 | 94 | 46.5 | 49.1 | 9.77 | 2001-10-29 10:14:00
 | NG N2 | 330 | 95 | 100 | 46.1 | 48.5 | 9.81 | 2001-10-29 10:14:00
 | NG Q2 | 335 | 102 | 107 | 46 | 48.3 | 9.93 | 2001-10-29 10:14:00
 | NG U2 | 335 | 107 | 113 | 46 | 48.6 | 9.96 | 2001-10-29 10:14:00
 | NG V2 | 335 | 112 | 120 | 46.2 | 49.5 | 10.08 | 2001-10-29 10:14:00
 | [NAME] |  |  |  |  |  |  | 2001-10-26 15:01:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 132948d1324051176-converting-minutes-into-seconds-and-showing-difference-between-times-in-percentage-wr-calculator
Sheet: Sheet1

 | WR | 1.005 | 1.01 | 1.02 | 1.03 | 1.04 | 1.05 | 1.06 | 1.07 |  | My time | WR % | WR s
 | 00:01:40.460000 | 00:01:40.962000 |  |  | 00:01:43.474000 |  | 00:01:45.483000 |  | 00:01:47.492000 |  | 00:01:44.981000 | 1.045 | 00:00:04.521000 |  |  | WR in seconds | 100.46
 | 00:01:40.460000 | 00:01:40.962000 |  |  | 00:01:43.474000 |  | 00:01:45.483000 |  | 00:01:47.492000 |  | 00:01:43.400000 | ??? | ??? |  |  | divider (to find 0.5%) | 200
 | 00:01:40.460000 | 00:01:40.962000 |  |  | 00:01:43.474000 |  | 00:01:45.483000 |  | 00:01:47.492000 |  | 00:01:41 | ??? | ??? |  |  | multiplyer (to find 100.5%) | 201
 | Yellow cells have comments. Please read them. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WR +0.5% (seconds)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100.5% of WR | WR +0.5% (minutes) | 00:01:40.962000
 | WR | 1.005 | 1.01 | 1.02 | 1.03 | 1.04 | 1.05 | 1.06 | 1.07 |  | My time | WR % | WR s |  |  | WR in seconds | 100.46
 | 00:01:40.460000 |  |  |  |  |  |  |  |  |  | 00:01:45 |  |  |  |  | divider (to find 1%) | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mutiplyer (to find 105%) | 105
 | WR | 1.005 | 1.01 | 1.02 | 1.03 | 1.04 | 1.05 | 1.06 | 1.07 |  | My time | WR % | WR sec |  |  | WR+5% (seconds)
 | 00:01:40.460000 | 00:01:40.962000 | x:xx.xxx | x:xx.xxx | 00:01:43.474000 | x:xx.xxx | 00:01:45.483000 | x:xx.xxx | 00:01:47.492000 |  | 00:01:44.981000 | 1.045 | 00:00:04.521000 |  | 105% of WR | WR+5% (minutes) | 00:01:45.483000
 | WR | 1.005 | 1.01 | 1.02 | 1.03 | 1.04 | 1.05 | 1.06 | 1.07 |  | My time | WR % | WR s |  |  | WR in seconds | 100.46
 | 00:01:40.460000 | 00:01:40.962000 | x:xx.xxx | x:xx.xxx | 00:01:43.474000 | x:xx.xxx | 00:01:45.483000 | x:xx.xxx | 00:01:47.492000 |  | 00:01:44.981000 | 1.045 | 00:00:04.521000 |  |  | divider (to find 0.5%) | 200
 | 00:01:40.460000 | 00:01:40.962000 | x:xx.xxx | x:xx.xxx | 00:01:43.474000 | x:xx.xxx | 00:01:45.483000 | x:xx.xxx | 00:01:47.492000 |  | 00:01:43.400000 | ??? | ??? |  |  | multiplyer (to find 104.5%) | 209
 | 00:01:40.460000 | 00:01:40.962000 | x:xx.xxx | x:xx.xxx | 00:01:43.474000 | x:xx.xxx | 00:01:45.483000 | x:xx.xxx | 00:01:47.492000 |  | 00:01:41 | ??? | ???
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WR +0.5% (seconds)
 | This is want I want (above) |  |  |  |  |  |  |  |  |  |  |  |  |  | 104.5% of WR | WR +0.5% (minutes) | 00:01:40.962000
Spreadsheet: 199948d1355370031-lookup-formula-to-pick-up-first-arriving-values-lookup-across-columns-picking-up-first-arriving-values
Sheet: Sheet1

LOOK UP TABLE
 | Jan | Feb | Mar | April | May | June
Cadburys | 40 | 60 | 25
Cadburys | 40 | 60 | 25
Cadburys | 40 | 60 | 25
Mars | 20 | 30 | 65
Mars | 20 | 30 | 65
Snickers | 25 | 27 | 54
Snickers | 25 | 27 | 54
 | Jan | Feb | Mar | April | May | June
Cadburys | 40 | 60 | 25
Mars | 20 | 30 | 65
Snickers | 25 | 27 | 54
 |  |  |  |  |  |  |  | Lookup formula to pick first values for the criteria, matching product name and month
Spreadsheet: 77716d1278150462-hide-a-row-advancedfilter
Sheet: Sheet1

Test1 | Test2 | Test3 |  |  | Test1 | Test2 | Test3
0 | 0 | 2 |  |  | <>0 | <>0 | <>0
0 | 9 | 3
0 | 5 | 4
12 | 0 | 8
14 | 15 | 20
becomes
Test1 | Test2 | Test3
0 | 0 | 2
0 | 9 | 3
0 | 5 | 4
12 | 0 | 8
14 | 15 | 20
Spreadsheet: 721970d1614968168-google-sheets-need-to-find-the-match-number-then-enter-the-text-find-the-match-number-etaf
Sheet: Sheet1

MATCHING NUMBER |  |  |  |  |  |  |  |  |  | [NAME] in this Column K:K to enter text "FOUND" if
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Spreadsheet: 192068d1352300178-creating-interactive-map-usa-map
Sheet: Count by State

Row Labels | Sum of Count |  |  |  | [NAME]. | State | Equation
AB | 69 |  |  |  | AK | Alaska
AK | 28 |  |  |  | AL | Alabama
AL | 8 |  |  |  | AR | Arkansas
AR | 38 |  |  |  | AZ | Arizona
AZ | 103 |  |  |  | CA | California
BC | 72 |  |  |  | CO | Colorado
CA | 1023 |  |  |  | CT | Connecticut
CO | 237 |  |  |  | DE | Delaware
CT | 587 |  |  |  | FL | Florida
DE | 31 |  |  |  | GA | Georgia
FL | 313 |  |  |  | HI | Hawaii
GA | 88 |  |  |  | IA | Iowa
HI | 20 |  |  |  | ID | Idaho
IA | 5 |  |  |  | IL | Illinois
ID | 27 |  |  |  | IN | Indiana
IL | 1186 |  |  |  | KS | Kansas
IN | 26 |  |  |  | KY | Kentucky
KS | 250 |  |  |  | LA | Louisiana
KY | 2 |  |  |  | MA | Massachusetts
LA | 128 |  |  |  | MD | Maryland
MA | 42 |  |  |  | ME | Maine
MB | 12 |  |  |  | MI | Michigan
MD | 125 |  |  |  | MN | Minnesota
ME | 2 |  |  |  | MO | Missouri
MI | 257 |  |  |  | MS | Mississippi
MN | 36 |  |  |  | MT | Montana
MO | 190 |  |  |  | NE | Nebraska
MS | 2 |  |  |  | NC | North Carolina
MT | 34 |  |  |  | ND | North Dakota
NC | 587 |  |  |  | NH | New Hampshire
ND | 3 |  |  |  | NJ | New Jersey
NE | 22 |  |  |  | NM | New Mexico
NH | 8 |  |  |  | NY | New York
NJ | 76 |  |  |  | NV | Nevada
NM | 28 |  |  |  | OH | Ohio
NS | 3 |  |  |  | OK | Oklahoma
NV | 18 |  |  |  | OR | Oregon
NY | 731 |  |  |  | PA | Pennsylvania
OH | 431 |  |  |  | RI | Rhode Island
OK | 26 |  |  |  | SC | South Carolina
ON | 197 |  |  |  | SD | South Dakota
OR | 162 |  |  |  | TN | Tennessee
PA | 424 |  |  |  | TX | Texas
QC | 177 |  |  |  | UT | Utah
RI | 5 |  |  |  | VA | Virginia
SC | 3 |  |  |  | VT | Vermont
SD | 738 |  |  |  | WA | Washington
SK | 23 |  |  |  | WI | Wisconsin
TN | 254 |  |  |  | WV | West Virginia
TX | 632 |  |  |  | WY | Wyoming
UT | 38
VA | 22
VT | 1
WA | 247
WI | 30
(blank) | 1
Grand Total | 9828
Spreadsheet: 796261d1663175865-excel-formula-to-return-multiple-values-based-off-of-multiple-criteria-2022-09-14-oeldere-chase-casey-book2-2-1-
Sheet: Sheet1

Value | Result | Value | Result | Value | Result
Hello | Hello | Goodbye | Goodbye | Hello | Aloha
Hello | Hello | Goodbye | Goodbye | Goodbye | Aloha
Hello | Hello | Goodbye | Goodbye | Hello | Aloha
Hello | Goodbye | Help
Hello | Goodbye | Goodbye
Hello | Goodbye | Help
 | For this example, in the attached I'm using "Hello" as Criteria/Return Value 1, "Goodbye" as Criteria/Return Value 2, and "Aloha" as Return Value 3 if both Criteria Values 1 & 2 are present within the range.
Example 1 |  |  | Example 2 |  |  | Example 2
Value | Result |  | Value | Result |  | Value | Result
Hello |  |  | Hello |  |  | Goodbye
Hello |  |  | Hello |  |  | Goodbye
Hello |  |  | Hello |  |  | Goodbye
Hello |  |  | Hello |  |  | Goodbye
Goodbye |  |  | Hello |  |  | Goodbye
Hello |  |  | Hello |  |  | Goodbye
Hello |  |  | Hello |  |  | Goodbye
Goodbye |  |  | Hello |  |  | Goodbye
Hello |  |  | Hello |  |  | Goodbye
Hello |  |  | Hello |  |  | Goodbye
IF both "Hello" and "Goodbye" are present in Range A18:A27, then the result is Aloha". If only "Hello" is present in Range A18:A27, then the result is "Hello". If only "Goodbye" is present in Range A18:A27, then the result is "Goodbye". "Goodbye".
Spreadsheet: 56559d1256740662-copy-cell-reference-from-seperate-sheet-to-increment-correctly-copy-of-book3-2-
Sheet: Sheet1

 | org -> | A | b | c | d
jan | plan | 4 | 5 | 5 | 3
 | actual
 | over/under
feb | plan | 6 | 2 | 9 | 8
 | actual
 | over/under
[NAME] | plan
 | actual
 | over/under
apr | plan
 | actual
 | over/under
may | plan
 | actual
 | over/under
jun | plan
 | actual
 | over/under
jun | plan
 | actual
 | over/under
Spreadsheet: 851311d1701529785-research-then-create-table-in-formula-one_to_many
Sheet: Sheet1

Date | Name | Age | Country |  | Date | Name | Age | Country
2023-11-23 00:00:00 | [NAME] | 25 | USA |  | 2023-11-23 00:00:00
2023-11-23 00:00:00 | Maria | 30 | Canada
2023-09-11 00:00:00 | [NAME] | 26 | France
2023-10-10 00:00:00 | [NAME] | 40 | Australia
2023-09-24 00:00:00 | [NAME] | 40 | USA
2023-06-14 00:00:00 | [NAME] | 28 | Japan
 |  |  |  |  | Result should come
 |  |  |  |  | Date | Name | Age | Country
 |  |  |  |  | 2023-11-23 00:00:00 | [NAME] | 25 | USA
 |  |  |  |  |  | Maria | 30 | Canada
Spreadsheet: 132325d1323702053-how-to-access-information-from-a-table-updated-pipe-pricing
Sheet: Sheet1

 |  | WATER PIPING
Material |  | [NAME]
Qty |  | Description |  | Mat. Price |  | Mat. Total
0
0 |  | 4"
0 |  | 3"
0 |  | 2 1/2"
0 |  | 2"
0 |  | 1 1/2"
0 |  | 1 1/4"
0 |  | 1"
0 |  | 3/4"
0 |  | 1/2"