tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 169618d1342979024-how-do-i-make-e-mail-groups-to-auto-populate-the-to-in-a-new-e-mail-to-send-my-incident-log-matrix-draft
Sheet: sheet 2

Date: |  |  |  | Time: |  |  |  |  |  |  |  |  |  | From: |  |  |  |  |  |  |  |  |  |  |  |  | Time:
To |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Description
 |  | Incident Email Group |  |  |  | e-mail group |  |  |  | CEO |  |  |  | Vice president |  |  |  | Marketing Dept |  |  |  | Finance Dept |  |  |  | Employee Relations |  |  |  | Staff
Notify:
Time Notified:
Initials:
 |  | [NAME] AFSD-Inspections Cell: 758-0305 |  |  |  | Manager Head |  |  |  | Assnt. Mngr> |  |  |  | Engineering Sup |  |  |  | Engineering staff |  |  |  | Houston Executive Staff |  |  |  | Huston CEO |  |  |  | Distribution Center Head
Notify:
Time Notified:
Initials:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IR Summary
 |  | MKE Airport OPS 747-5325 (see comment)
Notify:
Time Notified:
Initials:
Notify:
Time Notified:
Initials:
CC Officers:
Sensitive Security Information WARNING: This record contains Sensitive Security Information that is controlled under 49 CFR parts 15 and 1520. No part of this record may be disclosed to persons without a “need to know”, as defined in 49 CFR parts 15 and 1520, except with the written permission of the Administrator of the Transportation Security Administration or the Secretary of Transportation. Unauthorized release may result in civil penalty or other action. For U.S. government agencies, public disclosure is governed by 5 U.S.C. 552 and 49 CFR parts 15 and 1520.
Date: |  |  |  | Time: |  |  |  |  |  |  |  |  |  |  |  |  | Incident Location: |  |  |  |  |  |  |  |  |  | IR #:
Incident Timeline
Time | Actions and Significant Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Initials
CC Officers(s):
Sensitive Security Information WARNING: This record contains Sensitive Security Information that is controlled under 49 CFR parts 15 and 1520. No part of this record may be disclosed to persons without a “need to know”, as defined in 49 CFR parts 15 and 1520, except with the written permission of the Administrator of the Transportation Security Administration or the Secretary of Transportation. Unauthorized release may result in civil penalty or other action. For U.S. government agencies, public disclosure is governed by 5 U.S.C. 552 and 49 CFR parts 15 and 1520.
Spreadsheet: 214718d1361084928-help-with-specifics-in-a-data-series-copying-value-after-2nd-occurence
Sheet: Sheet1

5 | d
5 | c
5 | d
3 | c
3 | a
2 | a
1 | d
1 | s
0 | d
0 | c
0 | d
Spreadsheet: 763228d1642065721-average-of-20-most-recent-values-based-on-dates-book2
Sheet: Sheet1

 |  |  |  |  |  | Score | Date | Result |  |  | Pass |  |  |  | Pass
 |  |  |  |  |  | 97 | 2021-04-19 00:00:00 | Pass |  |  |  | [NAME] |  |  | Fail
 |  |  |  |  |  | 45 | 2021-06-09 00:00:00 | Rework |  |  |  |  |  |  | Rework
 |  |  |  |  |  | 60 | 2021-10-18 00:00:00 | Rework |  |  | Manual
 |  |  |  |  |  | 35 | 2020-10-29 00:00:00 | Fail |  |  |  | Pass
 |  |  |  |  |  | 55 | 2020-12-22 00:00:00 | Rework |  |  |  | Fail
 |  |  |  |  |  | 90 | 2020-10-25 00:00:00 | Pass |  |  |  | Rework
 |  |  |  |  |  | 99 | 2021-06-13 00:00:00 | Pass
 |  |  |  |  |  | 14 | 2021-04-11 00:00:00 | Fail
 |  |  |  |  |  | 74 | 2021-07-24 00:00:00 | Pass
 |  |  |  |  |  | 17 | 2021-08-04 00:00:00 | Fail
 |  |  |  |  |  | 55 | 2020-10-05 00:00:00 | Rework
 |  |  |  |  |  | 99 | 2021-10-14 00:00:00 | Pass
 |  |  |  |  |  | 29 | 2020-11-05 00:00:00 | Fail
 |  |  |  |  |  |  | 2021-05-21 00:00:00
Spreadsheet: tracy_geaccone__40332__Enron Goodwill Analysis-June 30 version tt
Sheet: consolid & recorded GW scheds.

Enron Goodwill Analysis
Summary by Operating Segment |  |  |  | Cumulative Effect of Accounting Change
As of June 30, 2001 |  |  |  | Non-Recurring Charge
(in millions) |  |  |  | Allocated $750MM to $[NAME] to Americas
 |  |  |  | Allocated to Americas
[NAME] (excluding equity method investments): |  | Transportation and Distribution |  | Americas |  | Global Markets |  | Industrial Markets |  | Europe |  | Global Assets |  | EES |  | EBS |  | Wind |  | TOTAL ENRON
Portland General |  | 1408
Elektro |  |  |  |  |  |  |  |  |  |  |  | 583
Enron Corp. (related to EES MI Buyback) |  |  |  |  |  |  |  |  |  |  |  |  |  | 434
Enron Europe (MG Metals) |  |  |  |  |  |  |  |  |  | 364
Enron Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  | 193
Wind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
Enron Global Power & Pipelines LLC |  |  |  |  |  |  |  |  |  |  |  | 165
Enron Internacional Panama S.A.(BLM) |  |  |  |  |  |  |  |  |  |  |  | 64
Enron Broadband Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55
HNG |  |  |  | 36
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 13
Global Markets |  |  |  |  |  | 9
Other |  |  |  |  |  |  |  |  |  |  |  | 12
Subtotals
[NAME] to Equity Method Investments:
TGS |  |  |  |  |  |  |  |  |  |  |  | 248
Ecoelectrica |  |  |  |  |  |  |  |  |  |  |  | 165
CEG/Riogas |  |  |  |  |  |  |  |  |  |  |  | 102
Gaspart |  |  |  |  |  |  |  |  |  |  |  | 127
Northern Plains |  | 72
Other |  |  |  |  |  |  |  |  |  |  |  | 35
Subtotals
Total Consolidated Goodwill
Unconsolidated Goodwill:
Azurix/Wessex |  | 697
Azurix/Other |  | 213
Stadacona |  |  |  |  |  |  |  | 149
SK Enron |  |  |  |  |  |  |  |  |  |  |  | 117
Pulp & Paper (Fishtail) |  |  |  |  |  |  |  | 223
Transredes |  |  |  |  |  |  |  |  |  |  |  | 31
Other |  | 24 |  |  |  |  |  |  |  |  |  | 1
Total Unconsolidated Goodwill
Spreadsheet: 818772d1677046670-trouble-with-significant-figures-significant-figure-challenges
Sheet: Sheet1

Here is an example of raw data of various magnitude
Entry 1 | 1.210215
Entry 2 | 5.023654
Entry 3 | 5
Entry 4 | 10258.60105
Entry 5 | 205.32154674
Entry 6 | 1025860105
Entry 7 | 21.0052
Entry 8 | 23.2101
Entry 9 | 500.0025
Entry 10 | 2140.261
I want to round to 3 significant figures (note: originally I had a problem with excel automatically dropping trailing zeros)
 | Rounded result | Notes on Challenge
Entry 1
Entry 2
Entry 3 |  | This should  say 5.00 but excel has dropped the trailing zeros
Entry 4
Entry 5
Entry 6
Entry 7 |  | This should  say 21.0 but excel has dropped the trailing zeros
Entry 8
Entry 9
Entry 10
To get around this, I have added some conditional formattiong (shown on the right) to asess the magnatiude of the cell and specify the decimal points
 | Rounded result
Entry 1
Entry 2 |  |  |  |  |  |  |  |  |  |  |  | Note on conditional formatting: this is only required for cells <100 because above that, the formula will perform the rounding without dropping the trailing zeros
Entry 3
Entry 4
Entry 5
Entry 6
Entry 7
Entry 8
Entry 9
Entry 10
After this, I want the ability to manually remove some points and add a note (in this case it will say "a" with a footnote somewhere else explaining this.
I also want to generate statisical data for the original results, and the results without footnotes.
 | Rounded result | Manually remove
Entry 1
Entry 2
Entry 3 |  | yes
Entry 4
Entry 5
Entry 6 |  | yes
Entry 7
Entry 8
Entry 9
Entry 10
 | Rounded result (with footnote) | I have also tried keeping the Significant Figure formula to obtain the Rounded result (with footnote) | Notes on Challenge
Entry 1
Entry 2
Entry 3 |  |  | I want this to say "5.00 a" but if my result is less than 100, and has a 0 as the third significant figure. I am not able to get it to work
Entry 4
Entry 5
Entry 6 |  |  | This entry (magnitude above 100) has worked properly.
Entry 7 |  |  | In this case (without a footnote) excel has not dropped the trailing zero. This is what I want.
Entry 8
Entry 9
Entry 10
 | [NAME] applied to all results | [NAME] applied to results without footnotes | Notes
Average |  |  | These are working fine but it is something to keep in mind if the formula to solve the above problem changes in a way such that they don't work
St. Dev.
Spreadsheet: 125980d1319455745-calculating-hours-that-have-passed-from-one-date-to-another-bookbeaut
Sheet: Sheet1

 | Incident | Severity | Status | Reported Date/Time | Responded Date/Time | Resolved Date | Response time | Resolution time | Comments - Exception?
1
2
3
4
5
6 |  |  |  |  | 00:00:00
7
8
9
10
11
12
13
14
15 |  |  |  |  | 00:00:00
16
17
18
19
20
21 |  |  |  |  | Example: clearly the resolutoion time should be much more the 9 hours lead time as the reported date is 05/10/2011 and the resolution comes 13 days later (12 days 23 hours 58 mins)
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
Spreadsheet: 700422d1603191861-dynamic-table_array-value-for-vlookup-function-funding-rate-data-exemple
Sheet: LTCUSDT

Date | Predicted Funding Rate | Funding Rate
2020-10-18 18:00:00 | 0.00028 | 0.00028
2020-10-18 10:00:00 | -0.00010 | -0.00010
2020-10-18 02:00:00 | 0.00025 | 0.00025
2020-10-17 18:00:00 | 0.00037 | 0.00037
2020-10-17 10:00:00 | 0.00001 | 0.00001
2020-10-17 02:00:00 | 0.00029 | 0.00029
2020-10-16 18:00:00 | 0.00031 | 0.00031
2020-10-16 10:00:00 | 0.00023 | 0.00023
2020-10-16 02:00:00 | 0.00030 | 0.00030
2020-10-15 18:00:00 | 0.00039 | 0.00039
2020-10-15 10:00:00 | 0.00022 | 0.00022
2020-10-15 02:00:00 | 0.00028 | 0.00028
2020-10-14 18:00:00 | 0.00025 | 0.00025
2020-10-14 10:00:00 | 0.00014 | 0.00014
2020-10-14 02:00:00 | 0.00015 | 0.00015
2020-10-13 18:00:00 | 0.00030 | 0.00030
2020-10-13 10:00:00 | 0.00019 | 0.00019
2020-10-13 02:00:00 | 0.00055 | 0.00055
2020-10-12 18:00:00 | 0.00025 | 0.00025
2020-10-12 10:00:00 | 0.00040 | 0.00040
2020-10-12 02:00:00 | 0.00024 | 0.00024
2020-10-11 18:00:00 | 0.00040 | 0.00040
2020-10-11 10:00:00 | 0.00020 | 0.00020
2020-10-11 02:00:00 | 0.00033 | 0.00033
2020-10-10 18:00:00 | 0.00033 | 0.00033
2020-10-10 10:00:00 | 0.00017 | 0.00017
2020-10-10 02:00:00 | 0.00034 | 0.00034
2020-10-09 18:00:00 | 0.00039 | 0.00039
2020-10-09 10:00:00 | 0.00027 | 0.00027
2020-10-09 02:00:00 | 0.00019 | 0.00019
2020-10-08 18:00:00 | 0.00014 | 0.00014
2020-10-08 10:00:00 | 0.00000 | 0.00000
2020-10-08 02:00:00 | 0.00009 | 0.00009
2020-10-07 18:00:00 | 0.00006 | 0.00006
2020-10-07 10:00:00 | 0.00021 | 0.00021
2020-10-07 02:00:00 | 0.00014 | 0.00014
2020-10-06 18:00:00 | 0.00016 | 0.00016
2020-10-06 10:00:00 | -0.00018 | -0.00018
2020-10-06 02:00:00 | 0.00020 | 0.00020
2020-10-05 18:00:00 | 0.00013 | 0.00013
2020-10-05 10:00:00 | 0.00013 | 0.00013
2020-10-05 02:00:00 | 0.00017 | 0.00017
2020-10-04 18:00:00 | 0.00006 | 0.00006
Spreadsheet: 157952d1337936608-removing-space-from-a-range-of-values-for-forum
Sheet: Sheet1

FACTORY NAME
CP Designs
CP Designs
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
CP Designs
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Best Corporation Private limited
Shanghai Jing Qingrong Garment Co., Ltd
Shanghai Jing Qingrong Garment Co., Ltd
Shanghai Jing Qingrong Garment Co., Ltd
Shanghai Jing Qingrong Garment Co., Ltd
Shanghai Jing Qingrong Garment Co., Ltd
Shanghai Jing Qingrong Garment Co., Ltd
Shanghai Jing Qingrong Garment Co., Ltd
Shanghai Jing Qingrong Garment Co., Ltd
Spreadsheet: 81d77b0c-65c3-4471-b086-6d249579019b
Sheet: Sheet1

Table S4. McDonald-Kreitman tables for AtLURE1 genes | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Gene | Polymorphic sites |  | Fixed differencesa |  | Neutrality index (pN/pS)/(dN/dS) | McDonald-Kreitman testb
 | Synonymous ([NAME]) | Nonsynonymous (pN) | Synonymous (dS) | Nonsynonymous (dN)
AtLURE1.1 | 3 | 6 | 12 | 33 | 0.727 | P = 0.696
AtLURE1.2 | 6 | 9 | 16 | 33 | 0.727 | P = 0.757
AtLURE1.3 | 6 | 11 | 14 | 29 | 0.885 | P = 1.000
AtLURE1.4 | 0 | 5 | 17 | 32 |  | P = 0.167
AtLURE1.5 | 1 | 14 | 17 | 31 | 7.677 | P = 0.047
AtLURE1.6 | 2 | 5 | 17 | 30 | 1.417 | P = 1.000
a Compared with AlLURE1.5 as a representative from AlLURE1 genes.
b  Fisher's exact test.
Spreadsheet: 862680d1710340111-like-vlookup-but-with-concatenate-results-sample-of-excel-dj
Sheet: Sheet1

 | =TEXTJOIN(", ",,FILTER(B:B,A:A="Depreciation"))
 | =TEKST.KOMBINER(", ";;FILTRER(B:B;A:A="Depreciation"))
 |  |  |  |  | Account Description | Note
All amounts in NOK 1000 | Note | 2023-03-01 00:00:00 |  |  | Sales revenues | 2.1
Sales revenues |  | 238001.45254 |  |  | Other operating income | 2.2
Other operating income |  | 50446.37224 | 2.2 |  | Other revenues | 2.2
Other revenues |  | 51020.1236 | 2.2 |  | Revenues | 1.5
Revenues |  | 239467.94838 | 1.5 |  | Cost of sales | 2.3
Cost of sales |  | 181987.24508 | 2.3 |  | Gross profit | 1.5
Gross profit |  | 107480.7033 | 1.5 |  | [NAME] and personnel expenses | 2.4
[NAME] and personnel expenses |  | 126332.75118 | 2.4 |  | Other operating expenses | 2.5
Other operating expenses |  | 135409.27006 | 2.5 |  | Impairment losses | 2.6
Impairment losses |  | 50027.2359 | 2.6 |  | Operating expenses | 1.5
Operating expenses |  | 211769.25714 | 1.5 |  | EBITDA | 1.5
EBITDA |  | -54288.55383999999 | 1.5 |  | Depreciation and amortisation | 3.2
Depreciation and amortisation |  | 83488.31904 | 3,2, 3,3, 3,4 |  | EBIT | 1.5
EBIT |  | -87776.87288000001 | 1.5 |  | Financial income | 2.7
Financial income |  | 53341.85239 | 2.7 |  | Financial expense | 2.7
Financial expense |  | 51942.5634 | 2.7 |  | Taxes | 2.8
Net Financial items |  | 51399.28899 |  |  | Depreciation and amortisation | 3.3
Profit before tax |  | -86377.58389000001 |  |  | Depreciation and amortisation | 3.4
Taxes |  | 49426.1191 | 2.8
Net result |  | -85803.70298999999
Spreadsheet: 29107d1223907599-multiple-vlookups-incrementalise
Sheet: Sheet1

customer# | CustomerEvent# | purchase amount | paid?
1000 | 1 | 123 | Y
1000 | 2 | 234 | Y
1000 | 3 | 345 | N
1001 | 1 | 9999 | N
1002 | 1 | 200003 | Y
1002 | 2 | 20054 | Y
1002 | 3 | 200566 | Y
1002 | 4 | 201234 | N
1002 | 5 | 200003 | Y
1002 | 6 | 205656 | Y
1002 | 7 | 200003 | N
1002 | 8 | 202345 | Y
1002 | 9 | 265666 | N
1002 | 10 | 209999 | Y
Spreadsheet: 185346d1349665783-index-formula-help-test-5-
Sheet: Test

[NAME]
Name: | Rank | FG% | FT% | 3PTM | PTS | REB | AST | ST | BLK | TO | Overall | Name: | FGM | FTM | 3PTM | PTS | REB | AST | ST | BLK | TO
[NAME]
[NAME]
Spreadsheet: 1818e590-d19a-410e-b7ca-4e633233448c
Sheet: Adult

Merit Badge University 2013
Registration Sheet for Scouts
Troop: | 123
First Name | Last Name | Youth/Adult | Passport Number | Nationality | Helping as | Special Dietary Needs
[NAME] | Summers | Adult | 123456 | USA | [NAME] | None
[NAME] | O'Hare | Adult | DOD Cardholder | USA | Catering Team | None
 |  | Adult
 |  | Adult
 |  | Adult
 |  | Adult
 |  | Adult
 |  | Adult
 |  | Adult
 |  | Adult
 |  | Adult
 |  | Adult
 |  | Adult
 |  | Adult
 |  | Adult
 |  | Adult
Spreadsheet: michelle_lokay__27295__grossmargin
Sheet: Sheet1

TW- Transactional Reporting
Posting Date | 2001-03-16 00:00:00
New/Amend | [NAME]# | [NAME] | [NAME]# | Affiliate Ind |  | Rate Charged
 |  |  |  |  |  | GROSS MARGIN =
A | 27528 | SEMPRA ENERGY TRADING CORP. | 609746565 | N | FTS-1
A | 27526 | RICHARDSON PRODUCTS COMPANY | 95220638 | N | FTS-1
h:\data\twtransrept.xls
Spreadsheet: 493008d1481395441-calc-avg-based-on-lookup-rate
Sheet: Sheet1

 | Year | Rate |  |  | LOOKUP TABLE
 | 2008 | -2.1 |  |  | 2008 | C4
 | 2009 | -1.3 |  |  | 2009 | C5
 | 2010 | -1.2 |  |  | 2010 | C6
 | 2011 | -7 |  |  | 2011 | C7
 | 2012 | -9.6 |  |  | 2012 | C8
 | 2013 | 4.7 |  |  | 2013 | C9
 | 2014 | 2.9 |  |  | 2014 | C10
 | 2015 | 0.5 |  |  | 2015 | C11
 |  | AVERAGE RATE OF RETURN
 | FROM | TO
 | 2009 | 20013 | -2.88
 | C5 | C11
Spreadsheet: 844292d1696006839-find-the-estimated-time-required-to-manufacture-a-product-based-on-non-linear-min-max-data-exponentialdecayratemodel-diminishingreturns-
Sheet: ExpDecayRate

Count | Time | [NAME] | Floor |  |  |  |  |  |  | A | C | B
1 | 6 | 1500 | 0.27 |  |  |  | y-C=A/(X-B) |  |  | 4600 | -0.15 | -700
500
1000 |  |  |  |  |  |  |  | 1 | 6
1500 |  |  |  |  |  |  |  | 5000 | 1
2000 |  |  |  |  |  |  |  | 10000 | 0.27
2500
3000
3500
4000
4500
5000
5500
6000
6500
7000
7500
8000
8500
9000
9500
10000
Spreadsheet: 105455d1302798707-pull-data-from-various-worksheets-into-a-summary-sheet-test-automerge-data-erica
Sheet: SUMMARY

NEAL NORTH 2011 |  |  |  |  |  | Gross | Net Unload |  | Unload report
# | Disabilities Y/N | Shipment ID | Trainset | Load Date | Unload Date | Unload (hh:[NAME]) | Unload (hh:[NAME]) | Queuing Time (hh:[NAME]) | Completed (date)
1 |  | BMSNC502 | RD03 | 2011-01-02 00:00:00 | 2011-01-05 00:00:00 | 14:15:00 | 7:30:00 | 1:20:00
2 |  | BMNNC001 | RD01 | 2011-01-03 00:00:00 | 2011-01-08 00:00:00 | 15:20:00 | 6:45:00 | 0:40:00
3 |  | BMNNC002 | BB01 | 2011-01-06 00:00:00 | 2011-01-09 00:00:00 | 9:10:00 | 7:45:00 | 2:10:00
4 |  | BMSNC504 | RD03 | 2011-01-06 00:00:00
5 |  | BMNNC003 | RD01 | 2011-01-08 00:00:00
6 |  | BMNNC004 | BB02 | 2011-01-11 00:00:00
7 |  | BMNNC005 | BB01 | 2011-01-11 00:00:00
8 |  | BMNNC006 | NL10 | 2011-01-13 00:00:00
9 |  | BMNNC007 | RD01 | 2011-01-14 00:00:00
10 |  | BMNNC008 | BB02 | 2011-01-15 00:00:00
11 |  | BMNNC010 | NL10 | 2011-01-17 00:00:00
12 |  | BMNNC011 | RD01 | 2011-01-19 00:00:00
13 |  | BMNNC012 | BB02 | 2011-01-20 00:00:00
14 |  | BMNNC013 | NL10 | 2011-01-22 00:00:00
15 |  | BMNNC014 | RD01 | 2011-01-23 00:00:00
16 |  | BMNNC015 | BB02 | 2011-01-24 00:00:00
17 |  | BMNNC016 | NL10 | 2011-01-26 00:00:00
18 |  | BMNNC017 | RD01 | 2011-01-27 00:00:00
19 |  | BMNNC019 | NL10 | 2011-01-30 00:00:00
20 |  | ETSNC509 | RD03 | 2011-01-30 00:00:00
What I Need: | should say "yes" if there is any data in cells B18-B28 and/or B30-B35 - otherwise, leave blank | from tab "Tonnage Report", column A -- should automatically add lines as lines are added to [NAME] tab | from tab "Tonnage Report", column B -- should automatically add lines as lines are added to [NAME] tab | from tab "Tonnage Report", column C -- should automatically add lines as lines are added to [NAME] tab | from individual tabs - reference shipment ID "E6" then enter unload date based on data in F12 & F13 - DATE ONLY - disregard time. If dates are the same, enter only once. If dates are different, enter as an & or a range. Ex: 4/11/11-4/12/11 OR 4/11/11 & 4/12/11 | from individual tabs -reference shipment ID "E6" then enters cell "F41" | from individual tabs -reference shipment ID "E6" then enters cell "F43" | from individual tabs -reference shipment ID "E6" then enters cell "H45" | leave column blank
 | So, the logic would require that first the summary page checked the tonnage report tab for new data, auto filled columns C, D, & E… THEN when the tabs were added,
 | the summary page would reference the tab to gain the data for A, F, G, H & I
Spreadsheet: 876555d1723270329-trying-to-display-yearly-quarter-using-start-date-sheet
Sheet: Sheet1

 | Construction Start Date | Constructiont End Date | Construction Start Date
 | 2025-08-15 08:00:00 | 2025-12-05 17:00:00 | Q3
 | 2025-07-02 08:00:00 | 2025-09-18 17:00:00 | Q3
 | 2026-04-26 08:00:00 | 2026-12-15 17:00:00 | Q2
 | 2025-06-04 08:00:00 | 2026-03-02 17:00:00 | Q2
 | 2025-10-16 08:00:00 | 2025-10-14 17:00:00 | Q4
 | 2025-11-20 08:00:00 | 2025-07-11 17:00:00 | Q4
 | 2026-03-03 08:00:00 | 2026-07-23 17:00:00 | Q1
 | 2025-04-01 08:00:00 | 2025-09-30 17:00:00 | Q2
 | 2025-10-09 08:00:00 | 2026-02-05 17:00:00 | Q4
 | 2026-02-23 08:00:00 | 2026-12-07 17:00:00 | Q1
 | 2026-02-16 08:00:00 | 2026-09-02 17:00:00 | Q1
 | 2025-06-06 08:00:00 | 2026-02-05 17:00:00 | Q2
Spreadsheet: 138935d1328008630-fetching-customer-ids-and-putting-it-in-ascending-order-in-report-sheet-ef21_sales_record_my_doubt
Sheet: Customer List

 | Customer ID | Customer Name | candy price
 | 001-001 | ABC Stores | 10
 | 001-002 | [NAME] and [NAME] | 10
 | 001-003 | Kids World | 8
 | 001-004 | Fun Time | 12
 | 001-005 | Animalz | 12
 | 001-006 | Kids Corners | 12
 | 001-007 | Kidddies | 10
 | 001-008 | The Family Shop | 12
 | 001-009 | The Roundabout | 11
 | 001-010 | Walky | 8
 | 001-011 | Rainbow | 11
 | 001-012 | Kids Park | 9
 | 001-013 | Fun Park | 12
 | 001-014 | The Sea Side | 12
 | 001-015 | [NAME] | 12
 | 001-016 | The Sunny | 12
 | 001-017 | Romantic | 11
 | 001-018 | Seasons | 8
 | 001-019 | Paragon | 12
 | 001-020 | Sagar | 12
Spreadsheet: 885586d1735316801-find-lookup-value-in-same-cell-thru-multilpe-sheets-and-count-word-on-that-sheet-book1
Sheet: Page009

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10
3 . 3 9 | Name |  |  | Gardens
User: | Name
 | Fr 12-27-24 9:54 AM |  | Status | Report |  |  |  |  | Report 6
Department: |  | 570 | Stitching Production
 | EmplNo | Last name, first name |  | Bk. | Date |  | Time | Status
 | 2002 | Names |  | Pre | Fr | 2024-12-27 00:00:00 | 9:54 AM | Present
 | 3008 | Names |  | Pre | Fr | 2024-12-27 00:00:00 | 9:54 AM | Present
 | 3009 | Names |  | Pre | Fr | 2024-12-27 00:00:00 | 9:54 AM | Present
 | 3021 | Names |  | Pre | Fr | 2024-12-27 00:00:00 | 9:54 AM | Present
 | 3032 | Names |  | Pre | Fr | 2024-12-27 00:00:00 | 9:54 AM | Present
 | 3057 | Names |  | Pre | Fr | 2024-12-27 00:00:00 | 9:54 AM | Present
 | 3061 | Names |  | Pre | Fr | 2024-12-27 00:00:00 | 9:54 AM | Present
 | 6001 | Names |  | Abs | Fr | 2024-12-27 00:00:00 | 9:54 AM | Absent (authorized)
 | 6002 | Names |  | Pre | Fr | 2024-12-27 00:00:00 | 9:54 AM | Present
 | 6003 | Names |  | Pre | Fr | 2024-12-27 00:00:00 | 9:54 AM | Present
 | 6004 | Names |  | Pre | Fr | 2024-12-27 00:00:00 | 9:54 AM | Present
 | Number of status lines: 11
Spreadsheet: 138967d1328021243-excel-2007-formula-references-an-answer-from-another-formula-example-productivity
Sheet: Sheet1

Day | Hours Worked | Down Time | Number of Passengers | Productivity |  |  | Day | Hours Worked | Down Time | Number of Passengers | Productivity
Monday |  |  |  |  |  |  | Monday
Tuesday |  |  |  |  |  |  | Tuesday
Wednesday |  |  |  |  |  |  | Wednesday
Thursday |  |  |  |  |  |  | Thursday
Friday |  |  |  |  |  |  | Friday
Saturday |  |  |  |  |  |  | Saturday
Totals |  |  |  |  |  |  | Totals
Day | Hours Worked | Down Time | Number of Passengers | Productivity |  |  | Day | Hours Worked | Down Time | Number of Passengers | Productivity
Monday |  |  |  |  |  |  | Monday
Tuesday |  |  |  |  |  |  | Tuesday
Wednesday |  |  |  |  |  |  | Wednesday
Thursday |  |  |  |  |  |  | Thursday
Friday |  |  |  |  |  |  | Friday
Saturday |  |  |  |  |  |  | Saturday
Totals |  |  |  |  |  |  | Totals
Day | Hours Worked | Down Time | Number of Passengers | Productivity |  |  | Monthly Totals
Monday |  |  |  |  |  |  | Hours Worked
Tuesday
Wednesday |  |  |  |  |  |  | Down Time
Thursday
Friday |  |  |  |  |  |  | Number of Passengers
Saturday
 |  |  |  |  |  |  | Monthly Productivity |  | =IF(ISERROR(J32/J28),"0",J32/J28)
Totals
 |  |  |  |  |  |  | Why is this formula not working? It seems to me as it should.