tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 273454d1382717077-compare-two-names-list-and-compare-other-column-aftrerwards-vlookup-w-dupesheet-
Sheet: Sheet2

[NAME] | First Name | Last Name
Card | Nick | Smith
Card | Antoine | Genee
Yes | [NAME] | Burt
Card | Nick | Grossman
Yes | [NAME] | Fischer
Card | Anil | Kohli
Card | Markus | Ehrler
Yes | [NAME] | Beaty
Yes | Guy | Zarzavatdjian
Card | [NAME] | Wilson
Card | Vincent | Guillaumot
Card | [NAME] | Aguiar
Card | [NAME] | Schweitzer
Card | [NAME] | Wirtz
Card | [NAME] | [NAME]
Card | [NAME] | Salmon
Yes | Stuart | [NAME]
Card | Stuart | Miners
Card | [NAME] | Watts
Spreadsheet: 857453d1706471947-help-if-then-formula-samplem1
Sheet: Sheet1

Employee_Name | Birth_Date_(MM/DD/YYYY) | Age | Generation Category |  | GENERATIONS: | Born from: | To: | Oldest age | Youngest age
One Doe | 1987-07-31 00:00:00 | 18 |  |  | Traditional | 1922 | 1945 |  |  | 1922 - 1945
Two Doe | 1967-06-03 00:00:00 | 25 |  |  | [NAME] | 1946 | 1964 |  |  | 1946 - 1964
Three Doe | 1985-07-07 00:00:00 | 44 |  |  | [NAME] | 1965 | 1980 |  |  | 1965 - 1980
Four Doe | 1981-01-27 00:00:00 |  |  |  | Millennials | 1981 | 1996 |  |  | 1981 - 1996
Five Doe | 1974-09-05 00:00:00 |  |  |  | Gen Z | 1997 | 2012 |  |  | 1997 - 2012
Six Doe | 1976-06-19 00:00:00
Spreadsheet: 889798d1740726475-gannt-chart-conditional-formating-for-weekdays-fund-finance-wa-calendar-danielle87-test
Sheet: Gantt Chart New test

 |  | Project Start Date: | 2024-07-01 00:00:00 | FY25
 |  | Project Name: | Fund Finance Calendar
 | # | Task | Assigned To | Start | End | Days
 | 1 | PWG Distributions | [NAME] Danielle
 | 2 | CWA Distributions | [NAME] Danielle
 | 3 | Asset Management Fee Upload | [NAME]
 | 4 | EOM Bank Balance to FM | Danielle
 | 5 | TMS Accrual/ swap/ deal report | Danielle
Spreadsheet: 874d53d2-9e93-49f5-b2a3-adb1a54abc55
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6615 | 39909 | Tamara | Gomez Garrido | ESP | 31 | 00:14:28 | 00:01:39 | 01:29:09 | 00:01:11 | 00:25:22 | 5 | 02:11:50
6615 | 29856 | Baiba | Medne | LAT | 35 | 00:19:06 | 00:01:11 | 01:17:13 | 00:01:02 | [NAME] | 3 | 02:05:10
6615 | 41035 | Brigitta | Poór | HUN | 33 | 00:15:20 | 00:01:12 | 01:09:39 | 00:00:56 | [NAME] | 1 | 01:53:11
6615 | 17427 | Helen | [NAME] | EST | 36 | 00:14:58 | 00:01:12 | 01:24:03 | [NAME] | 00:30:41 | 4 | 02:11:46
6615 | 11296 | Kairi | [NAME] | EST | 32 | 00:14:05 | 00:01:15 | 01:18:51 | 00:00:54 | [NAME] | 2 | 02:01:53
Spreadsheet: 764828d1643026473-rank-not-correct-working-berekening-ranking_resultaten-ter-info-aan-ray-1-
Sheet: TC 1 > 2

 | 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
 |  |  |  |  |  |  |  |  | 0:17:51 | = Parameter tijd
 |  |  |  |  |  |  |  |  |  | = Omrekenen, [NAME], parameter tijd.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Afstand
 | Nr | PLAATS | DRIVER | CO-DRIVER | START   TC 1        "De Zilten" | SU-Getal | F - TC 2 Bergmolen | F - TK1 Getal | TK 2 TIJD | Tijd F - TK 1 Getal | PNT - Tijd TK 1 | STR PNT | KM | KM Verschil | TOTAAL | OPGAVE | Nieuwe Start |  | 1
 | 1 |  |  |  |  |  | 09:32:00
 | 2 |  |  |  |  |  | 09:33:00
 | 3 |  |  |  |  |  | 09:34:00
 | 4 |  |  |  |  |  | 09:35:00
 | 5 |  |  |  |  |  | 09:36:00
 | 6 |  |  |  |  |  | 09:37:00
 | 7 |  |  |  |  |  | 09:38:00
 | 8 |  |  |  |  |  | 09:39:00
 | 9 |  |  |  |  |  | 09:40:00
 | 10 |  |  |  |  |  | 09:41:00
 | 11 |  |  |  |  |  | 09:42:00
 | 12 |  |  |  |  |  | 09:43:00
 | 13 |  |  |  |  |  | 09:44:00
 | 14 |  |  |  |  |  | 09:45:00
 | 15 |  |  |  |  |  | 09:46:00
 | 16 |  |  |  |  |  | 09:47:00
 | 17 |  |  |  |  |  | 09:48:00
 | 18 |  |  |  |  |  | 09:49:00
 | 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
Spreadsheet: 119683d1314651759-count-text-copy-of-count-text-1
Sheet: Sheet1

 |  |  |  | Date | [NAME] | Sales |  | Top | Top 5 Sales people | Number of Sales
 | 1 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 26 |  | 1
 | 2 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 12 |  | 2
 | 3 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 4 |  | 3
 | 4 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 78 |  | 4
 | 5 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 78 |  | 5
 | 6 | [NAME] |  | 2011-06-06 00:00:00 | Tanya | 26
 | 7 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 58
 | 8 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 72
 | 9 | Mark |  | 2011-06-06 00:00:00 | [NAME] | 55
 | 10 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 87
 | 11 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 554
 | 12 | Tanya |  | 2011-06-06 00:00:00 | [NAME] | 15
 | 13 | [NAME] |  | 2011-06-06 00:00:00 | Gavin | 55
 | 14 | Gavin |  | 2011-06-06 00:00:00 | [NAME] | 552
 | 15 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 65
 |  |  |  | 2011-06-06 00:00:00 | [NAME] | 985
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 2255
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 22
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 225
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 2296
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 225
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 2259
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 398
 |  |  |  | 2011-06-07 00:00:00 | Tanya | 6259
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 6329
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 229
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 523
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 52269
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 822
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 522
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 922
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 516
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 5185
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 658
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 2648
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 256
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 587
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 574
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 258
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 218
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 159
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 94
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 1988
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 4198
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 488
Spreadsheet: 795452d1662705733-counting-matches-between-sheets-eforum-count-results
Sheet: Count

Client ID | Data | Data | Start | Ended | Missing | Fees Paid | Not Paid | Outcome A | Outcome B
422464478 |  |  | 2 | 0 | 1 | 0 | 0 | 0 | 0 | Manual Entry - outcome required
222228843 |  |  | 2 | 2 | 0 | 0 | 0 | 0 | 2 | Manual Entry - outcome required
222236693 |  |  |  |  |  |  |  |  |  | Formula NOT WORKING…..
222282882
222242632
222283289
222243327
222248228
222234283
222224228
222249626
422484984
222242262
222243786
222223838
222223246
222223482
222248874
222229439
422477763
422246824
222238982
222222874
222236272
222242298
222238788
422489366
222286932
222246326
222238924
222224242
222284426
222238762
222242878
222242462
222229688
222242828
222234274
422478488
222288926
222248868
222244346
222244926
222248284
222248442
422469448
222224878
222233889
422494743
222229847
222229864
422498987
222242242
422487647
422222242
222243898
222238834
222223628
222223389
222238889
422428384
222248274
222248683
222223288
222246247
222244282
222229288
422298483
422447378
222244237
222248487
222228926
422466878
222228648
222228726
422496423
222229289
422492436
422224929
222248888
422422483
222246323
422487839
422224282
222249283
222243486
222237422
422228294
222232278
222242768
222228334
222242244
222242277
222234878
222247942
222232772
222237326
222228842
222236438
222249266
222228434
222236444
222248394
222246886
222224278
222244246
422227482
222228484
222228492
222246622
222247428
222243484
222228782
422494366
222244687
222233668
422462294
422482938
222237827
222229788
422479983
222284242
222232396
222282824
222236723
422222899
222244288
422429384
222232298
222242474
222244692
222248464
222238822
222284249
222244483
222233843
Spreadsheet: 865256d1712306021-trying-to-tell-excell-to-do-one-thing-if-the-tick-box-is-ticked-and-another-if-the-tick-investment-property-spreadsheet-copy-1-aligw
Sheet: Sheet4

Input cells |  |  |  | Loan summary
Annual interest rate |  |  | 0 | Total payments
Loan term (in years) |  | 30 |  | Total interest
Payments per year |  | 12
Loan amount |  |  | 0
Period | Payment | Interest | Principal | Balance
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
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
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
Spreadsheet: eric_saibi__9823__Market briefs
Sheet: Sheet1

Market Brief | Wednesday, September 26
Stocks | Close | Change | % Change
DJIA | 8567.39 | -92.57999999999993 | -0.01069056821213006
DJ 15 Util. | 298.01 | -13.04 | -0.04192252049509732
NASDAQ | 1464.04 | -37.60000000000014 | -0.02503929037585582
S&P 500 | 1006.33 | -5.219999999999914 | -0.005160397409915391
Market Vols | Close | Change | % Change
AMEX (000) | 136149 | -35284 | -0.2058180163679105
NASDAQ (000) | 1761370 | -421831 | -0.1932167491678503
NYSE (000) | 1516950 | -88702 | -0.05524360197601971
Commodities | Close | Change | % Change
Crude Oil (Nov) | 22.75 | 0.9400000000000013 | 0.04309949564419997
Heating Oil (Oct) | 0.658 | 0.04039999999999999 | 0.06541450777202071
Nat. Gas (Henry) | 1.83 | -0.09999999999999987 | -0.05181347150259061
Propane (Oct) | 38 | -0.75 | -0.01935483870967742
Palo Verde (Oct) | 31.5 | 0 | 0
COB (Oct) | 33 | 0 | 0
PJM (Oct) | 29.7 | 0 | 0
Dollar US $ | Close | Change | % Change
Australia $ | 2.04 | 0.01500000000000012 | 0.007407407407407469
Canada $ | 1.573 | 0.002000000000000002 | 0.00127307447485678
Germany Dmark | 2.12 | 0 | 0
Euro | 0.9227 | -0.000300000000000078 | -0.0003250270855905504
Japan ¥en | 117.9 | 0.2000000000000028 | 0.001699235344095181
Mexico NP | 9.54 | 0.04999999999999893 | 0.005268703898840773
[NAME] | 0.6782 | -0.001900000000000013 | -0.002793706807822398
Foreign Indices | Close | Change | % Change
Arg MerVal | 244.65 | 0.7300000000000182 | 0.00299278451951467
[NAME]. | 2932.1 | 27.59999999999991 | 0.009502496126699917
[NAME] | 10005.87 | -223.1799999999985 | -0.0218182529169374
Can TSE 300 | 6654.83 | -47.18000000000029 | -0.007039679141033852
Germany DAX | 4095.32 | 86.20000000000027 | 0.02150097777068291
[NAME] | 9371.75 | 161.6900000000005 | 0.01755580311094613
Japan Nikkei 225 | 9641.7 | -52.26999999999862 | -0.005392011735130047
[NAME] | 5324.84 | 20.46 | 0.00385718971868532
UK FTSE 100 | 4696.1 | 32.70000000000073 | 0.007012051293048147
Source:  Yahoo! & TradingDay.com
Spreadsheet: benjamin_rogers__1224__test model from Erin
Sheet: CSHFLO w ePUP

Cash Flow
Project Revenues:
Fixed Pmt from ENA
Floating Pmt from ENA
Project Operating Expenses:
Fuel Charges
O&M Expenses
Floating Pmt to ENA
Working Capital Changes
Return of Maintenance Reserve
Operating Cash Flow
Debt Service:
Interest Payments
Principal Payments
Fixed Pmt to ENA
LC Charge on DSRF
Interest Income
Total Debt Service
Federal Income Taxes
NET A-T CASH FLOW
Debt Service Coverage Ratios
Debt Life
Long Term Debt
Interest
Principal
Long Term Debt Service
TOTAL DEBT SERVICE
DSC Ratios:
Long Term DSCR
Average
Minimum
Average Life
Total Debt Coverage Ratio
 |  | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5 | 8.5 | 9.5 | 10.5 | 11.5 | 12.5 | 13.5 | 14.5 | 15.5 | 16.5 | 17.5 | 18.5 | 19.5
Spreadsheet: 774452d1648483045-conditional-formatting-help-weekly-usage-units-test-etaf
Sheet: Stats

Product code | 2023-01-03 00:00:00 | 2023-01-10 00:00:00 | 2023-01-17 00:00:00 | 2023-01-24 00:00:00 | 2023-01-31 00:00:00 | 2023-02-07 00:00:00 | 2023-02-14 00:00:00 | 2023-02-21 00:00:00 | 2023-02-28 00:00:00 | 2023-03-07 00:00:00 | 2023-03-14 00:00:00 | 2023-03-21 00:00:00
subject a | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 3
subject b | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 7
subject c | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 3
subject d | 0 | 0 | 1 | 2 | 0 | 1 | 0 | 3 | 1 | 0 | 1 | 1
subject e | 0 | 0 | 0 | 8 | 23 | 0 | 2 | 0 | 0 | 0 | 44 | 6
subject f | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 20 | 30 | 1
subject g | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0
subject h | 1 | 0 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
subject i | 10 | 23 | 0 | 0 | 0 | 1 | 8 | 0 | 0 | 0 | 24 | 17
subject j | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 3 | 0
[NAME] | 0 | 0 | 1 | 9 | 2 | 0 | 0 | 3 | 13 | 9 | 1 | 1
Spreadsheet: 39251d1237426207-how-to-count-unique-non-0-values-in-one-range-based-on-categories-of-another-range-counting-awards
Sheet: Sheet1

Data | Data
986 | [NAME]
Dodsworth | 563
67 | 789
 | 235
[NAME] | Dodsworth
689 | 789
Dodsworth | 143
56 | 237
67 | 235
[NAME] | Description (Result)
 | Count the number of unique number values in cells A2:A10, but do not count blank cells or text values (4)
 | Count the number of unique text and number values in cells B2:B10 (which must not contain blank cells) (7)
 | Count the number of unique text and number values in cells A2:A10 , but do not count blank cells or text values (6)
Spreadsheet: 771484d1646695586-want-to-get-the-results-of-mavb-for-invoices-and-counts-and-sorted-smallest-to-largest-export-detail-ms-test-kisiji-
Sheet: INVOICE (1)

 | BANK ALFALAH
 | BANK IBAN # |  |  |  |  |  |  |  | NTN #
 | PAYMENT RECEIVED FROM : |  |  |  |  | INVOICE NO. |  |  | DATE | Financial Instrument No.
 |  |  |  |  |  | MS- | 497 | -2022
 |  |  |  |  |  | SHIPMENT PORT |  |  | DISCHARGE PORT
 | GOODS SHIP TO: |  |  |  |  | SKT / LHR / ISB
 |  |  |  |  |  | PAYMENT TERMS: |  |  | ADVANCE | PACKAGES. Cartons
 |  |  |  |  |  | COUNTRY OF ORIGIN |  |  |  | PER
 |  |  |  |  |  | PAKISTAN |  |  |  | BY AIR
 | Phone #
 | ART NO. | QUANTITY |  | [NAME] |  |  |  |  | C & F VALUE | TOTAL AMOUNT WITH C&F VALUE
 |  |  |  | SUBLIMATED SPORTS WEAR
 |  |  |  | HS 6107.2900
 |  |  |  | [NAME] AND NUMBERS
 |  |  |  | HS CODE 6107.2900
 |  |  |  | TOTAL C&F VALUE OF SHIPMENT:
 |  |  |  | UNDER REBATE CLAIM S.R.O NO. 209(I)/ 2009
 |  |  |  | DATED 05-03-09.
Spreadsheet: 689788d1596652452-error-with-formula-need-help-finding-the-error-in-my-formula-gross-margin-scenarios
Sheet: Sheet1

DESIRED GROSS MARGIN % | 0.45
SALES
BUDGETED+ADDITIONAL COST | 5000
ACTUAL TOTAL COST
ADJUSTED GROSS MARGIN | 46000
ORIGINAL GROSS MARGIN | 55000
Enter Additional Costs Below
Item | Amount |  |  |  | APPROXIMATE ANNUAL COMMISSION
 | 500 |  | ADJUSTED GROSS MARGIN
 | 0 |  | ORIGINAL GROSS MARGIN
 | 0 |  | ORIGINAL MARGIN %
 | 0 |  | ADJUSTED MARGIN %
 | 0 |  | ORIGINAL COMMISSION
 | 0 |  | ADJUSTED COMMISSION
 |  |  | DOLLAR CHANGE
Spreadsheet: 44739d1243507391-too-many-arguments-error-help-need-to-clean-up-formula-calendartest
Sheet: Calendar

 |  |  |  |  |  | August |  |  | Please fill out the fields shaded in yellow. |  |  | Make An Enquiry
 | MON | TUE | WED | THU | FRI | SAT | SUN |  | How many adults? |  |  | First Name | [NAME] |  |  | Yes
 |  |  |  |  |  |  |  |  | How many children? |  |  | Surname | Bingemann |  | 0 | No
 |  |  |  |  |  |  |  |  | Breakfast Inc. for first night? | No |  | [NAME] | [NAME] |  | 1
 |  |  |  |  |  |  |  |  | [NAME] | 2009-08-11 00:00:00 |  | Home/Work Phone | 5456788 |  | 2
 |  |  |  |  |  |  |  |  | Departure | 2009-08-14 00:00:00 |  | [NAME] | sdasdsa |  | 3
 |  |  |  |  |  |  |  |  | Staying x nights | 3 |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | Estimated Cost | - |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | Choose the dates you want by clicking on the box, fill in how many guests are staying, fill in personal details, click enquire.
Spreadsheet: 876922d1723639273-match-data-of-vertical-column-to-horizontal-row-of-another-sheet-fa-test
Sheet: F1

Main Group | Category | Name of Party | Description | No | Units | Date | ID |  | UK | Russia
 | Apple | Google Inc | Black Apple | 25 | Pcs | 2081.04.25 | S-12 | 5263
Group A | Grapes | All the best | Imported | 85 | ctns | 2081.05.26 | Bh-36
Group A | Orange | New Era | [NAME] | 100 | [NAME] | 2081.04.08 | S-24 |  | 6356
Group B | Jasmine | [NAME] | Home Grown | 256 | Bdl | 2081.04.28 | S-94 | 526
Group C | Software | Microsoft Inc. | Bing | 1 | set | 2084.04.09 | Asw-44 |  |  | 652
Required Result
Main Group | Category | Name of Party | Description | No | Units | Date | ID | America | UK | Russia
Group A | Apple | Google Inc | Black Apple | 25 | Pcs | 2081.04.25 | S-12 | 5263
Group A | Grapes | All the best | Imported | 85 | ctns | 2081.05.26 | Bh-36
Group A | Orange | New Era | [NAME] | 100 | [NAME] | 2081.04.08 | S-24 |  | 6356
Sub Total
Group B | Jasmine | [NAME] | Home Grown | 256 | Bdl | 2081.04.28 | S-94 | 526
Sub Total
Group C | Software | Microsoft Inc. | Bing | 1 | set | 2084.04.09 | Asw-44 |  |  | 652
Sub Total
Grand Total
Spreadsheet: 824175d1680352038-formula-for-plus-or-minus-with-different-letter-book1
Sheet: Sheet1

 | Column1 | Column2 | Column3 | Total
 | A | 100 | 100
 | A | 200 | 200
 | B | 300 | 300
 | B | 400 | 400
Spreadsheet: 266618d1379678515-sum-countiffs-of-two-different-variables-and-input-the-sums-in-cells-according-to-other-co-question
Sheet: Sheet1

1 | x | 1 |  | I have a macro running in my regular spreadsheet that says if case x then next column "1" and the same for case y with "2". What I am trying to do is take the countifs of all the "1"s until the count of those countifs is > F3. Then I want to move over one cell and populate it with "P". I want to do the same for y case, but take the countifs of all the "2"s until count of those countifs is > F5. After that I want it to continue to populate "P" till the end of the data set.
1 | y | 2 |  |  | Normal Amount
0 | 0 |  |  |  | 7
0 | 0 |  |  |  | 7
0 | 0
1 | x | 1
1 | y | 2
1 | x | 1
1 | y | 2
0 | 0
1 | x | 1
1 | y | 2
0 | 0
1 | x | 1
1 | y | 2
1 | x | 1
1 | y | 2
0 | 0
1 | x | 1
1 | y | 2
0 | 0
0 | 0
0 | 0
1 | x | 1 | P
1 | y | 2 | P
Spreadsheet: 846290d1697552758-days-and-averageifs-demo-averageif
Sheet: Sheet1

# | Date | Company | Quantity | Buy Price
 | 2023-10-13 00:00:00 | CPSE ETF | 2 | 53.56
 | 2023-10-13 00:00:00 | HDFC NIFTY SMALLCAP 250 ETF | 1 | 124.46
 | 2023-10-13 00:00:00 | MOTILAL OSWAL NIFTY MIDCAP 100 ETF | 3 | 43.19
 | 2023-10-13 00:00:00 | MOTILAL OSWAL NASDAQ 100 ETF | 1 | 122.85
 | 2023-10-16 00:00:00 | INDRAPRASTHA MEDICAL CORPORATION LTD | 15 | 173
 | 2023-01-13 00:00:00 | CPSE ETF | 2 | 53.56
 | 2023-01-13 00:00:00 | HDFC NIFTY SMALLCAP 250 ETF | 1 | 124.46
 | 2023-01-13 00:00:00 | MOTILAL OSWAL NIFTY MIDCAP 100 ETF | 3 | 43.19
 | 2023-01-13 00:00:00 | MOTILAL OSWAL NASDAQ 100 ETF | 1 | 122.85
 | 2023-01-13 00:00:00 | INDRAPRASTHA MEDICAL CORPORATION LTD | 15 | 173
 |  | CPSE ETF | 140.5
 |  | HDFC NIFTY SMALLCAP 250 ETF | 140.5
 |  | MOTILAL OSWAL NIFTY MIDCAP 100 ETF | 140.5
 |  | MOTILAL OSWAL NASDAQ 100 ETF | 140.5
 |  | INDRAPRASTHA MEDICAL CORPORATION LTD | 139
Spreadsheet: sara_shackleton__36843__MLGW ISDA
Sheet: Momma Credit Form 

ECT RELATIONSHIP CREDIT APPROVAL FORM
Ultimate Parent: |  | Suez Lyonnaise des Eaux S.A. |  |  |  |  |  |  | Ctypty
Address: |  | Paris, France |  |  |  |  |  | S&P | A
 |  |  |  |  |  |  |  | MOODY'S
 |  |  |  |  |  |  |  | E - Rating | 3
Date of prior Review : |  | 1999-05-06 00:00:00 |  |  |  |  |  | Most Recent Financials: |  | 1999-12-31 00:00:00
RECOMMENDATION: | Through a set of acquisitions during 1998 and 1999, Suez Lyonnaise des Eaux S.A. has increased its ownership stake in Societe Industrielle de Transports Automobiles (SITA),
 | Societe Generale de Belgique S.A. and Tractebel S.A. to nearly 100% in each company.  SITA is Europe's largest waste management firm and one of the largest
 | in the world with significant presense in Asia and Latin America, as well.  SITA maintains an A- rating by S&P and is said to have a strong position in this low-risk industry.
 | Societe Generale de Belgigue S.A.
COUNTERPARTY
CREDIT FACILITIES
 | "E" | Physical | Doc | Physical | Financial | Doc | Liquids Del. | Power Del. | Int'l Fuel Oil | Totals For
Counterparty(ies) Name(s) | RATING | Delivery | Stat | MTM | MTM | Stat | & MTM | & MTM | Del. & MTM | CP
Suez Lyonnaise des Eauz S.A. | 3 | 0 |  | 0 | 10000000 |  | 0 | 0 | 0
SITA | 3 | 0 |  | 0 | 5000000 |  | 0 | 0 | 0
Societe Generale de Belgique S.A. | 5 | 0 |  | 0 | 0 |  | 0 | 0 | 0
Tractebel S.A. | 5 | 0 |  | 0 | 0 |  | 0 | 0 | 0
Tractebel Energy Marketing, Inc. | 5 | 5000000 | N | 2500000 | 7500000 | E/N | 0 | 15000000 | 0
Total Appr'd Global Facility
 | LEGEND for Doc Status
 | E = Executed Master Agreement
 | N = Negotiating Master Agreement
Have all Compliance Checks for the above counterparties been completed? |  |  |  |  | N/AP |  | YES |  | NO
PREPARED BY: |  | [NAME] |  |  |  |  | Sr. Analyst | DATE
 |  | NAME |  |  |  |  | TITLE
APPROVED BY: |  |  |  |  |  |  |  | DATE
 |  | NAME |  |  |  |  | TITLE
(filename: t:\credit\forms2\star1.xls)
Spreadsheet: c496f9c9-f668-4c6c-b198-b71aa213bd6a
Sheet: Sheet1

Adults, Ages 18 years and Over, Ever Diagnosed with Depression,  by Year, Maine, 2006, 2008, 2009, 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Year | Unweighted Number | Weighted Number | % | LCL | UCL
2006 | 828 | 200145.9282734324 | 19.94338861209207 | 18.41817613385088 | 21.46860109033325
2008 | 872 | 212710.2782626691 | 20.8634856820937 | 19.19977309238193 | 22.52719827180548
2009 | 1851 | 220853.316506341 | 22.3699633246733 | 21.15503659239013 | 23.58489005695648
2010 | 1767 | 209498.3510800352 | 21.10370114893555 | 19.9129221729157 | 22.29448012495539
Data Source: Behavioral Risk Factor Surveillance System
Based on the question: "Has a doctor or other healthcare provider ever told you that you have a depressive disorder?"
% = Weighted percentage of respondents
LCL= Lower 95% confidence level of the weighted percentage
UCL= Upper 95% confidence level of the weighted percentage
All percentages are weighted to be more representative of the population of Maine and to adjust for non-response.
Spreadsheet: 183478d1348839241-convert-inches-to-feet-and-inches-inches-to-feet-and-inches
Sheet: Sheet1

0 |  | 0' 0 "
9.5 |  | 0' 9 1/2 "
9.75 |  | 0' 9 3/4 "
10 |  | 0' 10 "
10.25 |  | 0' 10 1/4 "
10.5 |  | 0' 10 1/2 "
10.75 |  | 0' 10 3/4 "
11 |  | 0' 11 "
11.25 |  | 0' 11 1/4 "
11.5 |  | 0' 11 1/2 "
11.75 |  | 0' 11 3/4 "
12 |  | 1' 0 "
12.25 |  | 1' 0 1/4 "
107.5 |  | 8' 11 1/2 "
107.75 |  | 8' 11 3/4 "
108 |  | 9' 0 "
108.125 |  | 9' 0 1/8 "
108.25 |  | 9' 0 1/4 "
108.75 |  | 9' 0 3/4 "
109 |  | 9' 1 "
109.25 |  | 9' 1 1/4 "
119.5 |  | 9' 11 1/2 "
119.75 |  | 9' 11 3/4 "
120 |  | 10' 0 "
120.25 |  | 10' 0 1/4 "
120.5 |  | 10' 0 1/2 "