tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 806184d1669148547-sum-values-in-index-and-match-formula-seller-finance-calculator
Sheet: Sheet1

Principal, Interest, and Balloon Payment Calculator |  |  |  |  |  |  |  |  |  |  |  | Seller Finance
 |  | Purchase Price | 100000 |  |  |  |  |  |  |  |  | ACQUISITION
 |  | Down Payment | 20000 |  |  |  |  |  |  |  |  | Acquisition type: | Seller Finance |  | Seller Presentation
 |  |  |  |  |  |  |  |  |  |  |  | Purchase Price |  |  | Purchase Price
Mortgage Information |  |  |  |  | Balloon Balances |  |  |  |  |  |  | Down Payment |  |  | Down Payment
 |  | Loan Amount |  |  |  | Balance at Year | 2 | 2 | 3 | 4 |  | Loan Amt |  |  | Loan Amt |  |  | Balloon Due (Yrs) |  |  | Downpayment
 |  | Annual Interest Rate | 0.02 |  |  | Date |  |  |  |  |  | Interest Rate |  |  | Interest Rate |  |  | Interest Paid |  |  | + Interest
 |  | Term Length (in Years) | 30 |  |  | Interest Paid |  |  |  |  |  | Term (Yrs) |  |  | Term (Yrs) |  |  | [NAME] |  |  | + Principle
 |  | First Payment Date | 2023-01-01 00:00:00 |  |  | Principle Paid |  |  |  |  |  | Monthly P&I |  |  | Monthly Pmt |  |  | Balloon Payment |  |  | = TOTAL PAID
 |  | Monthly Payment |  |  |  | Outstanding Balance
Payment Schedule
No. | Payment Date | Year | Monthly Payment | Interest | Principle | Balance (Balloon Payment)
1 | 2023-01-01 00:00:00
2
3
4
5
6
7
8
9
10
11
12
13 |  | 1
14
15
16
17
18
19
20
21
22
23
24
25 |  | 2
26
27
28
29
30
31
32
33
34
35
36
37 |  | 3
38
39
40
41
42
43
44
45
46
47
48
49 |  | 4
50
51
52
53
54
55
56
57
58
59
60
61 |  | 5
62
63
64
65
66
67
68
69
70
71
72
73 |  | 6
74
75
76
77
78
79
80
81
82
83
84
85 |  | 7
86
87
88
89
90
91
92
93
94
95
96
97 |  | 8
98
99
100
101
102
103
104
105
106
107
108
109 |  | 9
110
111
112
113
114
115
116
117
118
119
120
121 |  | 10
122
123
124
125
126
127
128
129
130
131
132
133 |  | 11
134
135
136
137
138
139
140
141
142
143
144
145 |  | 12
146
147
148
149
150
151
152
153
154
155
156
157 |  | 13
158
159
160
161
162
163
164
165
166
167
168
169 |  | 14
170
171
172
173
174
175
176
177
178
179
180
181 |  | 15
182
183
184
185
186
187
188
189
190
191
192
193 |  | 16
194
195
196
197
198
199
200
201
202
203
204
205 |  | 17
206
207
208
209
210
211
212
213
214
215
216
217 |  | 18
218
219
220
221
222
223
224
225
226
227
228
229 |  | 19
230
231
232
233
234
235
236
237
238
239
240
241 |  | 20
242
243
244
245
246
247
248
249
250
251
252
253 |  | 21
254
255
256
257
258
259
260
261
262
263
264
265 |  | 22
266
267
268
269
270
271
272
273
274
275
276
277 |  | 23
278
279
280
281
282
283
284
285
286
287
288
289 |  | 24
290
291
292
293
294
295
296
297
298
299
300
301 |  | 25
302
303
304
305
306
307
308
309
310
311
312
313 |  | 26
314
315
316
317
318
319
320
321
322
323
324
325 |  | 27
326
327
328
329
330
331
332
333
334
335
336
337 |  | 28
338
339
340
341
342
343
344
345
346
347
348
349 |  | 29
350
351
352
353
354
355
356
357
358
359
360
Spreadsheet: 793327d1661417050-apply-formula-based-on-blank-and-non-blank-cells-excel-forum-25-august-aligw
Sheet: Sheet1

Number | [NAME] | Discount Code | [NAME] to be displayed here | AliGW
#28800 | [EMAIL] | michelsawma78 | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#29185 |  |  | 0
#29184 |  | MahmoudFree | 0
#29183 |  | souadmarket71 | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29179 | [EMAIL] |  | 1
#29179 | [EMAIL] |  | 1
#29179 | [EMAIL] |  | 1
#29178 |  | harfouchtrading50 | 0
#29178 |  |  | 0
#29178 |  |  | 0
#28799 | [EMAIL] |  | 1
#28798 |  |  | 0
#28797 |  |  | 0
#28796 |  |  | 0
#28607 |  | Sponsor101 | 0
#28606 |  | WF30 | 0
#28605 |  | hadad71 | 0
Spreadsheet: 746860d1631079504-two-criteria-are-matched-to-bring-out-the-value-the-cell-has-a-merged-cell-9-08
Sheet: Sheet1

name | suject | serial number |  | serial number | name | suject
AA | 2253.1234 | AA31326557 |  | AA31325358 | BB | 4601.2345 | 4601.2345 | 4601.2345
AA | 2253.1234 | AA31326559 |  | AA31326556 | CC | 4609.5111B | 4609.5111B | 4609.5111B
AA | 2253.1234 | BB94908860 |  | AA31326557 | AA | 2253.1234 | 2253.1234 | 2253.1234
BB | 4601.2345 | AA31325358 |  | AA31326558 | DD | 4601.2345 | 4609.7540 | 4609.7540
CC | 4609.5111B | AA31326556 |  | AA31326559 | AA | 2253.1234 | 2253.1234 | 2253.1234
DD | 4609.7540 | AA31326558 |  | AA31326560 | DD | 2253.1234 | 4609.7540 | 4609.7540
DD | 4609.7540 | AA31326560 |  | AA31326561 | DD | 4609.7540 | 4609.7540 | 4609.7540
DD | 4609.7540 | AA31326561 |  | BB94908860 | AA | 2253.1234 | 2253.1234 | 2253.1234
DD | 4609.7540 | AA31326562 |  | AA31326562 | DD | 4609.7540 | 4609.7540 | 4609.7540
DD | 4609.7540 | AA31326557 |  | AA31326557 | DD | 4609.7540 | 4609.7540 | 4609.7540
 |  | Sheet1 |  |  |  | Sheet2
Spreadsheet: 740511d1626360915-extract-from-google-sheets-into-excel-quarantine-coaches-data-download
Sheet: Sheet1

Employee Names
Employee Names |  | 2021-07-01 00:00:00 | 2021-07-02 00:00:00 | 2021-07-03 00:00:00 | 2021-07-04 00:00:00 | 2021-07-05 00:00:00 | 2021-07-06 00:00:00 | 2021-07-07 00:00:00 | 2021-07-08 00:00:00 | 2021-07-09 00:00:00 | 2021-07-10 00:00:00 | 2021-07-11 00:00:00 | 2021-07-12 00:00:00 | 2021-07-13 00:00:00 | 2021-07-14 00:00:00 | 2021-07-15 00:00:00 | 2021-07-16 00:00:00 | 2021-07-17 00:00:00 | 2021-07-18 00:00:00 | 2021-07-19 00:00:00 | 2021-07-20 00:00:00 | 2021-07-21 00:00:00 | 2021-07-22 00:00:00 | 2021-07-23 00:00:00 | 2021-07-24 00:00:00 | 2021-07-25 00:00:00 | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-01 00:00:00 | 2021-08-02 00:00:00 | 2021-08-03 00:00:00 | 2021-08-04 00:00:00 | 2021-08-05 00:00:00 | 2021-08-06 00:00:00 | 2021-08-07 00:00:00 | 2021-08-08 00:00:00 | 2021-08-09 00:00:00 | 2021-08-10 00:00:00 | 2021-08-11 00:00:00 | 2021-08-12 00:00:00 | 2021-08-13 00:00:00 | 2021-08-14 00:00:00 | 2021-08-15 00:00:00 | 2021-08-16 00:00:00 | 2021-08-17 00:00:00 | 2021-08-18 00:00:00 | 2021-08-19 00:00:00 | 2021-08-20 00:00:00
[NAME]
ABUBAKAR
ADIL
ALI
ANTHONY
BURHAAN
CARLOS
CHRIS
CHYRAL
COLIN
EBZ
FARHAN
HERSI
[NAME]
JEROME
KANDIAH
KEYSE
KOCULEN
LAWSON
LICA
MARIO
MAURICE
[NAME]
MUTHU
OTHMAN
PARKY
PAUL CLEAR
RAJ PILLAY
RAMANA
RAYMOND
RICHARD
RICKY
[NAME]
ROMAINE
SABRIE
SHABAZ
SHANE
SHIRE
SURESH
THIVA
WINSTON
Spreadsheet: chris_dorland__1613__Options Detail-ZARGON_JAN17
Sheet: Results

 |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | Phy/ | [NAME] | Opt |  | Option | Monthly | Option | Stike | Mid | Mid | Mid | Premium
Counterparty | Deal Num | Pub Code | Fin | Put | Type | Period | [NAME] | Option Qty | Delta | Price | Price | Vol | Value | Value
ZARGONOILGAS | VH6370.1 | NGMR-AECO/C | F | C | EUR | 2002-01-01 00:00:00 | 2002-01-02 00:00:00 | 0 | 0 | 7.05 | 3.5411 | 0.87420584 | 0 | 0
ZARGONOILGAS | VH6370.1 | NGMR-AECO/C | F | C | EUR | 2002-02-01 00:00:00 | 2002-02-01 00:00:00 | 56000 | 0 | 7.05 | 2.965 | 0.56128563 | 0 | 0
ZARGONOILGAS | VH6370.1 | NGMR-AECO/C | F | C | EUR | 2002-03-01 00:00:00 | 2002-03-01 00:00:00 | 62000 | 2.111 | 7.05 | 2.92070904 | 0.62758379 | 0.2771 | 0
ZARGONOILGAS | VH6370.2 | NGMR-AECO/C | F | P | EUR | 2002-01-01 00:00:00 | 2002-01-02 00:00:00 | 0 | 0 | 5 | 3.5411 | 0.8133258 | -90451.8 | 0
ZARGONOILGAS | VH6370.2 | NGMR-AECO/C | F | P | EUR | 2002-02-01 00:00:00 | 2002-02-01 00:00:00 | -56000 | 55948.6502 | 5 | 2.965 | 0.50042014 | -113855.5231 | 0
ZARGONOILGAS | VH6370.2 | NGMR-AECO/C | F | P | EUR | 2002-03-01 00:00:00 | 2002-03-01 00:00:00 | -62000 | 61603.3869 | 5 | 2.92070904 | 0.56672667 | -128622.4692 | 0
Spreadsheet: 76675d1277206558-excel-2007-freezing-result-progressiveentry-2-
Sheet: NOT REQUIRED DELETE AFTER TESTS

Order No | Order Date | Material | Colour | Ordered Quantity | Length | Date | Delivered | Kg | Balance of Order
2 | 2010-02-02 09:58:27 | 20V | BLACK | 10000 | 6000 |  |  |  | 1421
6 | 2010-04-23 10:01:36 | 20V | BLACK | 10000 | 6000 |  |  |  | 10000
22 | 2009-12-10 10:04:31 | 20VT | BLACK | 10000 | 6500 |  |  |  | 1200
6 | 2010-04-23 10:15:50 | 20VT | BLACK | 10000 | 6000 |  |  |  | 2900
7 | 2010-05-19 10:19:22 | 24V | BLACK | 10000 | 6000 |  |  |  | (+)1120
7 | 2010-05-19 10:20:31 | 20V | BLACK | 10000 | 6500 |  |  |  | 6850
7 | 2010-05-19 10:21:17 | 14.8I | BLACK | 5000 | 6000 |  |  |  | 450
8 | 2010-05-25 10:22:32 | 18I | BLACK | 5000 | 6000 |  |  |  | 100
9 | 2010-06-10 12:50:38 | 38 V2TN | BLACK | 500 | 6000 |  |  |  | 500
9 | 2010-06-10 12:51:06 | 22I | BLACK | 1000 | 6500 |  |  |  | 1000
10 | 2010-06-21 13:07:03 | 14.8 I | BLACK | 5000 | 6000 |  |  |  | 5000
Spreadsheet: 02d0aba9-4e63-4a58-8fe0-010bf1615e85
Sheet: Cochrane

[NAME]
2006-2007
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 price | Price per unit
[NAME]
Sessions | 31 | 19 | 94 | 122 | 129 | 42 | 44 | 146 | 146 | 107 | 65 | 60
Searches | 13 | 7 | 50 | 32 | 25 | 21 | 13 | 51 | 95 | 25 | 11 | 14 |  | 2633.02
Full-Text Articles Downloaded | 39 | 80 | 76 | 108 | 97 | 35 | 87 | 199 | 118 | 91 | 128 | 80 |  | 2633.02
Turnaways | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
COUNTER-Compliant?: | Yes
Spreadsheet: 126988d1320093079-help-with-pricing-formula-new-product-price-analyzer
Sheet: Sheet1

 | Product Cost |  |  |  | Old Price |  |  | New Full Case
 | Old Cost | New Cost | Difference |  | 3
 | 0.5 | 5
 |  |  |  |  |  | Margin
 |  |  |  |  |  |  |  | New Open Case
 | 1 |  |  |  |  | New Margin
 | 0.7
 | 0.15 |  |  |  |  |  |  | New Project
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1=IF(E15="x",F3*(1+D4),(IF(F5<B8,C4*1.7,IF(AND(F5>=B8,F5<B7),C4*2,IF(AND(F5>=B7,F3>C4),F3,C4*2)))))
 |  |  |  |  | Place "x" in box to pass along cost increase
Spreadsheet: d64d8043-b1e3-4bae-8817-ca82cec73413
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: September 22, 2014 (3:50 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 229371
2004 | 229646 | 233241 | 235336 | 237875
2005 | 242085 | 244136 | 247183 | 247443
2006 | 250954 | 254990 | 258328 | 262731
2007 | 263776 | 266272 | 270025 | 272054
2008 | 276019 | 278206 | 280691 | 273572
2009 | 267266 | 267665 | 268736 | 271174
2010 | 273058 | 275612 | 279685 | 281383
2011 | 283078 | 290271 | 293177 | 293795
2012 | 297910 | 301286 | 303811 | 309614
2013 | 311650 | 315125 | 320087 | 326348
Spreadsheet: 851158d1701374660-to-automatically-change-a-letter-in-a-column-to-a-value-based-on-a-value-in-same-column-vlookup-work-in-pogress-sheet
Sheet: VLOOKUP and MAX ETC

 |  |  |  |  |  | Column is copied here from B for Q2-Who/VLOOKUP [C8:F14 Range]
No | Club | CPG Name | Race 1 | Race 2 | Race 3 | CPG Name
 | Coastal Rowing Academy | Teylu | 1 | 7 | 11 | Teylu
 | Coastal Rowing Academy | [NAME] | 2 | 8 | 3 | [NAME]
 | Eastney Cruising Association | Cockleshell | 3 | 9 | 5 | Cockleshell
 | Eastney Cruising Association | [NAME] | 4 | 10 | 2 | [NAME]
 | Langstone Pilot Gig Club | Spirit of Langstone | N | 6 | 1 | Spirit of Langstone
 | Langstone Pilot Gig Club | Star of [NAME] | 5 | N | 4 | Star of [NAME]
 | Langstone Pilot Gig Club | Seraph | 6 | N | 6 | Seraph
 | RMA Gig Club | [NAME] | N | 4 | 7 | [NAME]
 | RN Portsmouth | Acorn | 7 | 3 | 8 | Acorn
 | [NAME] | [NAME] | N | 2 | 9 | [NAME]
 | [NAME] | Sir [NAME] | N | 1 | 10 | Sir [NAME]
The question is: How can "N" CPG Names in above each of the Races be automatically become the Lowest Rank+1 eg  for Race 1, the [NAME] would become 8, in Race 2, the [NAME] would become 11, in Race 3, no change as no Ns. There could up to 10 race columns. NOTE: The Race ranking with be generated by RANK.EQ after START/FINISH lap times.
 |  | Q1: VLOOKUP_ What is Cockleshell's Race 2 ranking(points)?
 |  | Cockleshell
 |  | Q2: MAX+VLOOKUP_ Who has maximun points in Race 1?
 |  | [NAME] CPG Name: |  | Who/VLOOKUP:
Spreadsheet: 143474d1330438075-excel-2007-rows-from-multiple-sheets-into-one-exclude-those-without-values-safety-tour
Sheet: (3)Bar Anneal & Annealing

Date: | 1/16 & 1/17 |  | Back to Department Listing
DEPARTMENT/LOCATION: |  | Bar Anneal
 |  | 0
ITEM # | ISSUES FOUND | [NAME] | STATUS | INTERIM SOLUTION
x | repair or replace guards on west side of RH-B (green tag #20884) | near entry into furnace | carryover
x | need better flame protection above Sentry [NAME] Control Module (shovels) | between MCC Room & RHA | complete
x | uneven flooring | exit side of RH A | carryover
ENVIRONMENT: PROPER HOUSEKEEPING, INSPECTION AND MAINTENANCE, STANDARD OPERATING PROCEDURES - overall housekeeping was okay; need cleaning around RH B
ESCORT:
Spreadsheet: 222802d1363950538-group-cells-in-row-schedule-sanafin
Sheet: IANUARIE2013

nr. [NAME] |  | Nume Prenume | ACTIV INACTIV | IANUARIE 2013
 |  |  |  | 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 | TOTAL
Spreadsheet: 272325d1382358504-missing-error-using-vlookup-function-if_is_it_missing
Sheet: other_worksheet

EVENT | one to six | JOINT | LENGTH
A | 1 | A-1 | 3
A | 2 | A-2 | 5
A | 3 | A-3 | 9
A | 4 | A-4 | 5
A | 5 | A-5 | 7
A | 6 | A-6 | 21
B | 1 | B-1 | 18
B | 2 | B-2 | 23
B | 3 | B-3 | 5
B | 4 | B-4 | 4
B | 5 | B-5 | 7
B | 6 | B-6 | 3
C | 2 | C-2 | 5
C | 3 | C-3 | 26
C | 4 | [NAME] | 10
C | 5 | C-5 | 19
C | 6 | C-6 | 5
D | 1 | D-1 | 3
D | 2 | D-2 | 6
D | 3 | D-3 | 6
D | 4 | D-4 | 5
D | 5 | D-5 | 20
D | 6 | D-6 | 11
Spreadsheet: 33901d1230771079-excel-file-for-deliberations-on-proper-entry-date-into-a-retirement-plan-john-eastland-example-sheet-with-edward-bentley-first-step-revised
Sheet: 410 a Elig&Cov

 |  | Eligibiltiy and Coverage
 |  | Name of Employee | Date of Birth | Date of Hire | Date of Termination | Hours Worked | Date of Entry | OYFDOH | MON | JJ | Year | DOE | Anniv | D1 | D2 | D3 |  |  |  | DOEIWKIECP | Eligible for Plan
 | 1 | [NAME] | 1980-07-20 00:00:00 | 2005-08-07 00:00:00 |  | 1000 | 1900-01-01 00:00:00 | 2006-08-07 00:00:00 | 8 | 1 | 2007 |  | 2006-08-07 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00
 | 1 | [NAME] | 1977-06-07 00:00:00 | 2005-01-02 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-01-02 00:00:00 | 1 | 7 | 2006 |  | 2006-01-02 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | [NAME] | 1973-03-05 00:00:00 | 2005-06-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-06-01 00:00:00 | 6 | 7 | 2006 |  | 2006-06-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | [NAME] | 1976-03-05 00:00:00 | 2005-03-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-03-01 00:00:00 | 3 | 7 | 2006 |  | 2006-03-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | Richland | 1970-03-05 00:00:00 | 2004-08-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2005-08-01 00:00:00 | 8 | 1 | 2006 |  | 2005-08-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00
 | 1 | Rolette | 1969-03-05 00:00:00 | 2005-06-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-06-01 00:00:00 | 6 | 7 | 2006 |  | 2006-06-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | Sargent | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | [NAME] | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Sioux | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Slope | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | [NAME] | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Steele | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Stutsman | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Towner | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Traill |  |  |  | 0
Total Ees | 15
 |  | Date of Hire plus one year nearest date of either July 1 or January 1
 |  | For example [NAME] 1, 2004 Date of Enty will be January 1 2006
 |  | For example DOH June 1, 2005 Date of Entry will be July 1 2006
Spreadsheet: 41476d1239952456-formula-to-shade-designated-cells-conditional-formatting-1-
Sheet: Sheet1

d | In above example if you will change any value in Cell A1.  Cells of all sheets containing the same value will be highlighed
b | I used a name range
r
e |  |  |  |  |  |  |  |  |  | a
r | e |  |  | c |  |  |  |  |  | b
f |  |  |  |  |  |  |  |  |  | r
 |  |  |  |  |  |  |  |  |  | e
 |  |  |  | c |  |  |  |  |  | r
 |  |  |  |  |  |  |  |  |  | f
 | d |  |  |  | d
 |  |  |  |  |  |  |  | r
 |  |  |  |  |  |  |  | a
Spreadsheet: 103226d1300997326-comparing-the-time-portion-of-a-date-time-book1_syphlix
Sheet: Sheet1

 |  | Helper
09:30:00 | 10 | 0 |  | Start | 09:31:00
09:30:10 | 10 | 0 |  | End | 09:32:00
09:30:20 | 10 | 0 |  | Total | 60
09:30:30 | 10 | 0
09:30:40 | 10 | 0
09:30:50 | 10 | 0
09:31:00 | 10 | 1
09:31:10 | 10 | 1
09:31:20 | 10 | 1
09:31:30 | 10 | 1
09:31:40 | 10 | 1
09:31:50 | 10 | 1
09:32:00 | 10 | 0
09:32:10 | 10 | 0
09:32:20 | 10 | 0
09:32:30 | 10 | 0
09:32:40 | 10 | 0
09:32:50 | 10 | 0
09:33:00 | 10 | 0
09:33:10 | 10 | 0
09:33:20 | 10 | 0
09:33:30 | 10 | 0
09:33:40 | 10 | 0
09:33:50 | 10 | 0
09:34:00 | 10 | 0
09:34:10 | 10 | 0
09:34:20 | 10 | 0
Spreadsheet: 93466d1293038089-excel-2007-formula-cell-references-change-when-sorting-after-filtering-excel-2007-example-data
Sheet: Sheet1

Group | Group Bonus | Employee ID | Years of Employment | Employee Percentage of Group Bonus | Employee Bonus
1 | 5000 | A | 1
2 | 4000 | B | 5
1 | 5000 | C | 10
2 | 4000 | D | 1
1 | 5000 | E | 5
2 | 4000 | F | 10
1 | 5000 | G | 1
2 | 4000 | H | 5
1 | 5000 | I | 10
Spreadsheet: 703904d1605218109-calculate-g-between-f-and-m-recap-vs-actual-formula
Sheet: Sheet1

 |  |  | Bid Cost | Bid Freight | Bid Total | ReCap VS Actual | [NAME]  Cost | [NAME] | [NAME] | Order Ack # | PO # | PO Total
 |  |  | 77261 | 2431 |  |  | 0 | 0
 |  |  | 4618 | 0 |  |  | 100 | 25
 |  |  | 923.8 | 800
Spreadsheet: 810125d1671557540-lookup-with-multiple-criteria-analysis-of-sales
Sheet: Data

 |  | Red |  | Blue |  | Yellow |  | Green
Name | Date | Vol. | Time | Vol. | Time | Vol. | Time | Vol. | Time
[NAME] | 2022-12-01 00:00:00 | 0 | 00:00:00 | 135 | 05:10:00 | 0 | 00:00:00 | 44 | 07:30:00
[NAME] | 2022-12-01 00:00:00 | 0 | 00:00:00 | 27 | 01:10:00 | 0 | 00:00:00 | 54 | 03:36:00 |  | 12
[NAME] | 2022-12-01 00:00:00 | 16 | 01:37:00 | 0 | 00:00:00 | 0 | 00:00:00 | 23 | 02:00:00
Sue | 2022-12-04 00:00:00 | 62 | 06:30:00 | 0 | 00:00:00 | 0 | 00:00:00 | 69 | 00:00:00
[NAME] | 2022-12-04 00:00:00 | 0 | 00:00:00 | 89 | 03:47:00 | 0 | 00:00:00 | 30 | 00:00:00
[NAME] | 2022-12-04 00:00:00 | 34 | 05:11:00 | 0 | 00:00:00 | 0 | 00:00:00 | 0 | 00:00:00
[NAME] | 2022-12-07 00:00:00 | 37 | 05:30:00 | 10 | 00:40:00 | 0 | 00:00:00 | 0 | 00:00:00
[NAME] | 2022-12-07 00:00:00 | 0 | 00:00:00 | 0 | 00:00:00 | 0 | 00:00:00 | 0 | 00:00:00
Sue | 2022-12-07 00:00:00 | 0 | 00:00:00 | 60 | 03:25:00 | 29 | 01:05:00 | 0 | 00:00:00
[NAME] | 2022-12-07 00:00:00 | 53 | 05:10:00 | 0 | 00:00:00 | 0 | 00:00:00 | 19 | 02:40:00
[NAME] | 2022-12-11 00:00:00 | 0 | 00:00:00 | 63 | 03:18:00 | 0 | 00:00:00 | 0 | 00:00:00
Becky | 2022-12-11 00:00:00 | 14 | 00:00:00 | 0 | 00:00:00 | 0 | 00:00:00 | 47 | 04:30:00
Sue | 2022-12-11 00:00:00 | 0 | 00:00:00 | 63 | 03:18:00 | 0 | 00:00:00 | 60 | 00:00:00
Becky | 2022-12-11 00:00:00 | 71 | 06:30:00 | 0 | 00:00:00 | 0 | 00:00:00 | 60 | 00:00:00
Becky | 2022-12-15 00:00:00 | 0 | 00:00:00 | 0 | 00:00:00 | 53 | 00:00:00 | 50 | 05:30:00
[NAME] | 2022-12-15 00:00:00 | 0 | 00:00:00 | 0 | 00:00:00 | 0 | 01:17:00 | 46 | 00:00:00
Sue | 2023-01-01 00:00:00 | 0 | 00:00:00 | 49 | 00:00:00 | 0 | 00:00:00 | 0 | 00:00:00
[NAME] | 2023-01-01 00:00:00 | 0 | 00:00:00 | 5 | 00:31:00 | 54 | 01:58:00 | 0 | 00:00:00
Sue | 2023-01-01 00:00:00 | 37 | 04:24:00 | 10 | 00:40:00 | 0 | 00:00:00 | 0 | 00:00:00
[NAME] | 2023-01-01 00:00:00 | 13 | 01:45:00 | 0 | 00:00:00 | 0 | 00:00:00 | 0 | 00:00:00
Sue | 2023-01-08 00:00:00 | 55 | 00:00:00 | 0 | 00:00:00 | 0 | 00:00:00 | 21 | 03:05:00
[NAME] | 2023-01-08 00:00:00 | 32 | 03:45:00 | 0 | 00:00:00 | 0 | 00:00:00 | 62 | 05:18:00
Sue | 2023-01-08 00:00:00 | 35 | 04:04:00 | 0 | 00:00:00 | 0 | 00:00:00 | 70 | 00:00:00
[NAME] | 2023-01-08 00:00:00 | 0 | 00:00:00 | 60 | 02:00:00 | 0 | 00:00:00 | 22 | 01:17:00
Sue | 2023-01-08 00:00:00 | 102 | 07:30:00 | 0 | 00:00:00 | 0 | 00:00:00 | 0 | 00:00:00
Becky | 2022-12-18 00:00:00 | 55 | 04:10:00 | 0 | 00:00:00 | 0 | 00:00:00 | 51 | 02:40:00
Spreadsheet: 792517d1660930774-sum-and-count-with-identifiers-2022-08-19-hunterhunt-research-output-hd
Sheet: Sheet1

 | Output |  |  |  |  |  |  |  |  |  |  |  |  | Input (on different tab)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Servey | Sex | Country | Q19_11R1 | Q19_11R2 | Q19_11R3 | Q19_1R1 | Q19_1R2 | Q19_1R3
 | Filters |  |  |  |  |  |  |  |  |  |  |  |  | Survey 1 | Male | Germany | 4 | 2 | 1 | 4 | 4 | 4
 | Country | Poland |  |  |  |  |  |  |  |  |  |  |  | Survey 2 | Female | Poland | 3 | 5 | 2 | 4 | 4 | 4
 | Sex | Male |  |  |  |  |  |  |  |  |  |  |  | Survey 3 | Male | Germany | 1 | 5 | 3 | 4 | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Survey 4 | Male | Poland |  |  |  | 3 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Survey 5 | Male | Poland | 1 | 5 | 3 | 4 | 3 | 4
 | Company1 | Company2 | >> Sum | Company 1 | Company 2 |  |  | >> Count | Company 1 | Company 2
 | Q19_11R1 | Q19_1R1 | Fastest |  |  |  |  | Fastest
 | Q19_11R2 | Q19_1R2 | Cheapest |  |  |  |  | Cheapest
 | Q19_11R3 | Q19_1R3 | Slowest |  |  |  |  | Slowest
Spreadsheet: 48405d1247623185-help-with-a-formula-mafia-wars-loot-list-001
Sheet: Vehicles

Vehicles |  | Attack | [NAME] | Units | Power
[NAME] Truck |  | 10 | 20
Armored Truck |  | 4 | 8
Armored Car |  | 14 | 15
Prop plane |  | 5 | 20
[NAME] "[NAME] |  | 18 | 6
Humvee |  | 26 | 22
'35 Cabriolet |  | 10 | 20
[NAME] |  | 10 | 20
Porsche 911 |  | 20 | 14
Private Jet |  | 12 | 38
Police Cruiser |  | 22 | 28
[NAME] |  | 16 | 22
Armored Limousine |  | 16 | 36
[NAME] |  | 7 | 26
Armored State Car |  | 30 | 38
Si-14 Cargo Plane |  | 31 | 31
Montaine 320 |  | 27 | 23
[NAME] |  | 24 | 18
Mini-Sub |  | 30 | 25
[NAME] |  | 25 | 27
Ocelot Armored Truck |  | 18 | 28
[NAME] |  | 25 | 20
Hu-9 [NAME] |  | 36 | 27
El Rey Roadster |  | 40 | 34
[NAME] |  | 40 | 34
Vehicle |  | 0 | 0
Vehicle |  | 0 | 0
Vehicle |  | 0 | 0
Vehicle |  | 0 | 0
Vehicle |  | 0 | 0
Vehicle |  | 0 | 0
Vehicle |  | 0 | 0
Vehicle |  | 0 | 0
Vehicle |  | 0 | 0
Vehicle |  | 0 | 0
Vehicle |  | 0 | 0
Vehicle |  | 0 | 0
Spreadsheet: 117490d1312825946-excel-2007-extracting-certain-weekdays-in-a-month-extracting-certain-weekdays-in-a-month
Sheet: Validation

Years | Months | Weekdays | Selected or Not | [NAME]
2011 | January | Monday
2012 | February | Tuesday
2013 | March | Wednesday
 | April | Thursday
 | May | Friday
 | June | Saturday
 | July | Sunday
 | August
 | September
 | October
 | November
 | December