tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 215748d1361467766-need-formula-to-produce-a-cascading-irregular-incrementer-based-on-another-column-calcneeded
Sheet: CalcNeeded

 | # | Example | Calculation Needed |  | # | Data Column
 | 1 | 1 |  |  | 1 | 3
 | 2 | 1 |  |  | 2 | 5
 | 3 | 1 |  |  | 3 | 2
 | 4 | 2 |  |  | 4 | 7
 | 5 | 2 |  |  | 5 | 9
 | 6 | 2 |  |  | 6 | 2
 | 7 | 2 |  |  | 7 | 4
 | 8 | 2 |  |  | 8 | 1
 | 9 | 3 |  |  | 9 | 7
 | 10 | 3 |  |  | 10 | 3
 | 11 | 4 |  |  | 11 | 1
 | 12 | 4 |  |  | 12 | 5
 | 13 | 4 |  |  | 13 | 9
 | 14 | 4 |  |  | 14 | 13
 | 15 | 4 |  |  | 15 | 2
 | 16 | 4 |  |  | 16 | 1
 | 17 | 4 |  |  | 17 | 3
 | 18 | 5 |  |  | 18 | 6
 | 19 | 5 |  |  | 19 | 8
 | 20 | 5 |  |  | 20 | 2
 | 21 | 5 |  |  | 21 | 1
 | 22 | 5 |  |  | 22 | 2
 | 23 | 5 |  |  | 23 | 3
 | 24 | 5 |  |  | 24 | 2
 | 25 | 5 |  |  | 25 | 4
 | 26 | 5 |  |  | 26 | 3
 | 27 | 6 |  |  | 27 | 1
 | 28 | 6 |  |  | 28 | 5
 | 29 | 7 |  |  | 29 | 6
 | 30 | 7 |  |  | 30 | 8
 | 31 | 7 |  |  | 31 | 2
 | 32 | 7 |  |  | 32 | 3
 | 33 | 8 |  |  | 33 | 5
 | 34 | 9 |  |  | 34 | 76
 | 35 | 9 |  |  | 35 | 8
 | 36 | 9 |  |  | 36 | 1
 | 37 | 9 |  |  | 37 | 3
 | 38 | 9 |  |  | 38 | 1
 | 39 | 9 |  |  | 39 | 4
 | 40 | 9 |  |  | 40 | 6
 | 41 | 10
 | 42 | 10
 | 43 | 10
 | 44 | 11
 | 45 | 12
 | 46 | 12
 | 47 | 12
 | 48 | 12
 | 49 | 12
 | 50 | Etc.Etc
 | 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
 | 48
 | 49
Spreadsheet: 054e33ed-5a64-49f6-bc94-bc572cafff8f
Sheet: Sheet1

Crime Index | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Age and Sex
 | Under 18 |  |  | 18 and over
Year | Total | White | Nonwhite | Total | White | Nonwhite
1993 | 1277.696003747115 | 1045.864556822836 | 2177.196712036312 | 1097.640062075199 | 755.7039743966906 | 2975.564180057039
1994 | 1341.549109138044 | 1100.161901573606 | 2273.016789229652 | 1068.964186637417 | 755.4269096798563 | 2768.321467101403
1995 | 1302.084109002895 | 1063.865439712713 | 2215.370304919218 | 1075.374789272219 | 755.319259427326 | 2787.188355660315
1996 | 1257.770872751643 | 1060.995628177789 | 2008.026380046815 | 1003.181854376396 | 715.4807232012448 | 2522.048583548903
1997 | 1202.867857915411 | 1003.960536989118 | 1957.560180928798 | 996.3016782469282 | 705.9929514980942 | 2507.74957114117
1998 | 1039.763269128738 | 874.8709574344224 | 1662.434335086653 | 927.9469471735597 | 671.8169071831966 | 2244.320371663222
1999 | 918.5783132455845 | 760.9388062919385 | 1510.801238405063 | 846.1547002481963 | 620.5288984309758 | 1991.598228803452
2000 | 853.9261858875035 | 706.9151139325076 | 1402.972881571267 | 793.5025189077296 | 587.3282500493164 | 1827.755197839208
2001 | 800.6614287016453 | 675.3115484555857 | 1213.603034564773 | 788.0551439526204 | 595.8971480454106 | 1678.796990722682
Spreadsheet: 844433d1696232725-combine-week-sheets-into-week1-blank-workouttracker
Sheet: Body Fat

 | Body Fat Tracking Chart
 |  | A | B | C | D | E | F | G | H
 |  |  |  | (AxB)/100 | A-C |  | 100-E | (D/F)x100 | A-G
 | Date (MM/DD/YR) | Weight (lb) | % Body Fat | Fat (lb) | [NAME] (lb) | Body Fat % Goal | [NAME] % Goal | Weight [NAME] (lb) | Weight Loss Goal of Fat (lb)
Week 1 - Day 1 | 2016-12-08 00:00:00 | 175 | 30.66 |  |  | 15
2 |  |  |  |  |  | 15
3 |  |  |  |  |  | 15
4 |  |  |  |  |  | 15
5 |  |  |  |  |  | 15
6 |  |  |  |  |  | 15
7 |  |  |  |  |  | 15
Week 2 - Day 8 |  |  |  |  |  | 15
9 |  |  |  |  |  | 15
10 |  |  |  |  |  | 15
11 |  |  |  |  |  | 15
12 |  |  |  |  |  | 15
13 |  |  |  |  |  | 15
14 |  |  |  |  |  | 15
Week 3 - Day 15 |  |  |  |  |  | 15
16 |  |  |  |  |  | 15
17 |  |  |  |  |  | 15
18 |  |  |  |  |  | 15
19 |  |  |  |  |  | 15
20 |  |  |  |  |  | 15
21 |  |  |  |  |  | 15
Week 4 - Day 22 |  |  |  |  |  | 15
23 |  |  |  |  |  | 15
24 |  |  |  |  |  | 15
25 |  |  |  |  |  | 15
26 |  |  |  |  |  | 15
27 |  |  |  |  |  | 15
28 |  |  |  |  |  | 15
Week 5 - Day 29 |  |  |  |  |  | 15
30 |  |  |  |  |  | 15
31 |  |  |  |  |  | 15
32 |  |  |  |  |  | 15
33 |  |  |  |  |  | 15
34 |  |  |  |  |  | 15
35 |  |  |  |  |  | 15
Week 6 - Day 36 |  |  |  |  |  | 15
37 |  |  |  |  |  | 15
38 |  |  |  |  |  | 15
39 |  |  |  |  |  | 15
40 |  |  |  |  |  | 15
41 |  |  |  |  |  | 15
42 |  |  |  |  |  | 15
Week 7 - Day 43 |  |  |  |  |  | 15
44 |  |  |  |  |  | 15
45 |  |  |  |  |  | 15
46 |  |  |  |  |  | 15
47 |  |  |  |  |  | 15
48 |  |  |  |  |  | 15
49 |  |  |  |  |  | 15
Week 8 - Day 50 |  |  |  |  |  | 15
51 |  |  |  |  |  | 15
52 |  |  |  |  |  | 15
53 |  |  |  |  |  | 15
54 |  |  |  |  |  | 15
55 |  |  |  |  |  | 15
56 |  |  |  |  |  | 15
Week 9 - Day 57 |  |  |  |  |  | 15
58 |  |  |  |  |  | 15
59 |  |  |  |  |  | 15
60 |  |  |  |  |  | 15
61 |  |  |  |  |  | 15
62 |  |  |  |  |  | 15
63 |  |  |  |  |  | 15
Week 10 - Day 64 |  |  |  |  |  | 15
65 |  |  |  |  |  | 15
66 |  |  |  |  |  | 15
67 |  |  |  |  |  | 15
68 |  |  |  |  |  | 15
69 |  |  |  |  |  | 15
70 |  |  |  |  |  | 15
Week 11 - Day 71 |  |  |  |  |  | 15
72 |  |  |  |  |  | 15
73 |  |  |  |  |  | 15
74 |  |  |  |  |  | 15
75 |  |  |  |  |  | 15
76 |  |  |  |  |  | 15
77 |  |  |  |  |  | 15
Week 12 - Day 78 |  |  |  |  |  | 15
79 |  |  |  |  |  | 15
80 |  |  |  |  |  | 15
81 |  |  |  |  |  | 15
82 |  |  |  |  |  | 15
83 |  |  |  |  |  | 15
84 |  |  |  |  |  | 15
How to use:
 | 1. Input the date on the date column for that day.
 | 2. Input your weight in the weight column for that day.
 | 3. Input your bodyfat % in the bodyfat % column for that day.
 | 4. DO NOT change ANY of the values for the other columns.
How to find your Bodyfat %?
 | You may find some helpful info in this thread I started:
 |  | How do you check your Body Fat %?
Classification | Women (% fat) | Men (% fat)
Essential Fat | 10-12% | 2-4%
Athletes | 14-20% | 6-13%
Fitness | 21-24% | 14-17%
Acceptable | 25-31% | 18-25%
Obese | > 32% | > 25%
Spreadsheet: 66889459-0d81-4848-948d-f1c599e02a7a
Sheet: Sheet1

Percentage of Maine Residents Served by Community Water Systems with Fluoridated Water, 2009-2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
year | # of people served by fluoridated water systems | # of people served by community water systems | % of people served by community water systems whose water is fluoridated
2009 | 527137 | 657606 | 0.788
2010 | 524843 | 653469 | 0.803
2011 | 520928 | 659713 | 0.79
2012 | 521464 | 660105 | 0.79
US rate for 2011 |  |  | 0.739
Data Source: Water Fluoridating Reporting System, US CDC.
49.7% of Maine residents live in communities with public water systems, while the remaining 50.3% have private wells or get their water from small private systems (2011 population data.)
There are 380 community water systems in Maine.  Some of these systems serve more that one town.  The number of people served by a partitcular water system varies by location.
Spreadsheet: 1e6cce0b-2348-4966-bb3f-8a6a81c01091
Sheet: Category sales

Country | Region | Dairy | Produce | Grain | Beverage | Total Sales
Finland | North | 32726 | 38483 | 33016 | 19474
Finland | South | 34733 | 37971 | 32236 | 16734
Spain | North | 31062 | 73611 | 61085 | 45120
Spain | South | 45389 | 22189 | 22040 | 60116
France | East | 63539 | 50602 | 25347 | 21991
France | West | 49382 | 39100 | 55406 | 31810
Norway | North | 21842 | 62310 | 42256 | 19191
Norway | South | 15566 | 28321 | 21355 | 47141
Denmark | East | 63332 | 70239 | 61149 | 56706
Denmark | West | 21386 | 29939 | 63308 | 47036
Italy | Mid | 10471 | 15781 | 44755 | 64064
Italy | South | 40282 | 36045 | 35135 | 32748
Germany | East | 60161 | 32055 | 24207 | 26952
Germany | West | 70606 | 58763 | 65356 | 15132
UK | North | 13522 | 36363 | 24925 | 56741
UK | South | 50055 | 28828 | 28333 | 49805
Belgium | North | 57008 | 65101 | 73444 | 29043
Belgium | Mid | 52202 | 60639 | 38777 | 52787
Sweden | Mid | 65925 | 10865 | 41532 | 10731
Sweden | South | 61525 | 22930 | 10785 | 60148
Spreadsheet: 757886d1638495764-formula-help-example
Sheet: Management Contacts

BSA | Regional Ops Manager | EMOS Ops Manager | Assistant Ops Manager | Estate Upkeep Service Delivery Manager | Cleaning & Housekeeping Manager | Land Management | Transport Services | Pest & Vermin | BSSC Team Lead; BSSC Manager
AMB | [NAME] | [NAME] | N/A | [NAME] | Vacant - contact [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
AWMA | [NAME] | [NAME] | N/A | [NAME] [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
BNE | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
BPK | [NAME] | [NAME]; [NAME] | Vacant | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
CAN | [NAME] | [NAME] | N/A | Shane Doss | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
CPK | [NAME] | [NAME]; [NAME] | Vacant | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
CRN | [NAME] | [NAME] | N/A | Rees Jones | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
CTB | [NAME] | [NAME]; [NAME] | Vacant | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
DDO | [NAME] | [NAME] | N/A | Vacant - contact [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
HAR | [NAME] | [NAME]; [NAME] | Vacant | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
KMA | [NAME] | [NAME] | N/A | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
RCK | [NAME] | Jared Morkel | [NAME] | [NAME] | Christina Eade | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
RUS | [NAME] | [NAME]; [NAME] | Vacant | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
SHV | [NAME] | [NAME] | N/A | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
TWN | [NAME] | Jared Morkel | [NAME] | [NAME] | Christina Eade | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
TWS | [NAME] | Jared Morkel | [NAME] | [NAME] | Christina Eade | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
WAG | [NAME] | [NAME] | N/A | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]; [NAME]
Spreadsheet: 693942d1599220554-3-week-rolling-average-score-based-on-person-3-week-avg-question
Sheet: Sheet1

Approval Week | Person | Score |  |  |  | 1st | 2nd | 3rd | average
2020-08-24 00:00:00 | [NAME] | 100 |  |  | [NAME]
2020-08-24 00:00:00 | [NAME] | 100 |  |  | [NAME]
2020-08-10 00:00:00 | [NAME] | 95
2020-08-10 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 85
2020-08-10 00:00:00 | [NAME] | 95
2020-08-03 00:00:00 | [NAME] | 100
2020-08-03 00:00:00 | [NAME] | 0
2020-08-03 00:00:00 | [NAME] | 100
2020-07-27 00:00:00 | [NAME] | 70
2020-07-27 00:00:00 | [NAME] | 100
2020-08-24 00:00:00 | [NAME] | 100
2020-08-24 00:00:00 | [NAME] | 100
2020-08-24 00:00:00 | [NAME] | 65
2020-08-17 00:00:00 | [NAME] | 100
2020-08-17 00:00:00 | [NAME] | 85
2020-08-17 00:00:00 | [NAME] | 0
2020-08-17 00:00:00 | [NAME] | 0
2020-08-10 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 85
2020-07-27 00:00:00 | [NAME] | 95
2020-07-27 00:00:00 | [NAME] | 100
2020-08-24 00:00:00 | [NAME] | 85
2020-08-24 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 85
2020-08-10 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 65
2020-08-03 00:00:00 | [NAME] | 100
2020-07-27 00:00:00 | [NAME] | 100
2020-07-27 00:00:00 | [NAME] | 100
2020-07-27 00:00:00 | [NAME] | 85
2020-07-27 00:00:00 | [NAME] | 100
2020-08-24 00:00:00 | [NAME] | 85
2020-08-24 00:00:00 | [NAME] | 100
2020-08-17 00:00:00 | [NAME] | 0
2020-08-10 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 100
2020-08-03 00:00:00 | [NAME] | 100
2020-08-03 00:00:00 | [NAME] | 70
2020-07-27 00:00:00 | [NAME] | 100
2020-07-27 00:00:00 | [NAME] | 100
Spreadsheet: 768126d1644847134-append-several-columns-into-two-demo-1
Sheet: Sheet1

CURRENT |  |  |  |  |  |  | RESULT
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 |  | Column1 | Column2
A | 5 | B | 2 | C | 3
A | 1 | B | 2 | C | 3
A | 1 | B | 2 | C | 3
A | 1 | B | 2 | C | 3
A | 1 | B | 2 | C | 3
A | 1 | B | 2 | C | 3
Spreadsheet: 762424d1641554371-auto-inserting-a-formula-when-using-data-validation-list-formula-sheet-test-1-
Sheet: A

 | # | D |  |  |  |  | TYPE | Rate | S | TIME | COST | COST
 |  |  |  |  |  |  | 1M | 10 |  | 2 | 0.3333333333333333 | 0.3333333333333333
 |  |  |  |  |  |  | 2M | 7 |  | 3 | 0.35 | 0.35
 |  |  |  |  |  |  | OUT | 5 |  | 4 | 0.3333333333333333 | 0.3333333333333333
 |  |  |  |  |  |  | COOK | 4.5 |  | 5 | 22.5 | 22.5
 |  |  |  |  |  |  | MAT | 2.5 |  | 6 | 15 | 15
 |  |  |  |  |  |  | 1M | 10 |  |  | 0 | 0
 |  |  |  |  |  |  | MAT | 2.5 |  |  | 0 | 0
 |  |  |  |  |  |  | 2M | 7 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  | OUT | 5 |  | 10 | 0.8333333333333333 | 0.8333333333333333
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  | COOK | 4.5 |  | 8 | 36 | 36
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Spreadsheet: 5634fa75-3d1e-4bc6-b6a4-d2ecab313945
Sheet: New  Table 17

Table 17
Weekly Port Region Grain Ocean Vessel Activity (number of vessels)
 |  |  |  | Pacific | Vancouver
 | Gulf |  |  | Northwest | B.C.
 |  | Loaded | Due next
Date | In port | 7-days | 10-days | In port | In port
2013 range | (16..60) | (20..56) | (31..81) | (0..24) | n/a
2013 avg. | 32 | 33 | 51 | 12 | n/a
Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: 829972d1684587585-ipmt-function-failing-in-amortization-table-problem-ipmt-project-funding-loan-analysis
Sheet: 12 Mos

[NAME], 365 Day Year
 | Date | Payment | Interest | Principal | Balance
 | 2024-01-01 00:00:00
2 | 2024-02-01 00:00:00 |  |  |  |  |  |  |  | -382.2615830760672
3 | 2024-03-01 00:00:00 |  |  |  |  |  |  |  | -347.7991576794834
4 | 2024-04-01 00:00:00 |  |  |  |  |  |  |  | -313.2792949072385
5 | 2024-05-01 00:00:00 |  |  |  |  |  |  |  | -278.7018990303734
6 | 2024-06-01 00:00:00 |  |  |  |  |  |  |  | -244.0668741603801
7 | 2024-07-01 00:00:00 |  |  |  |  |  |  |  | -209.3741242489368
8 | 2024-08-01 00:00:00 |  |  |  |  |  |  |  | -174.623553087641
9 | 2024-09-01 00:00:00 |  |  |  |  |  |  |  | -139.8150643077432
10 | 2024-10-01 00:00:00 |  |  |  |  |  |  |  | -104.9485613798788
11 | 2024-11-01 00:00:00 |  |  |  |  |  |  |  | -70.02394761380135
12 | 2024-12-01 00:00:00 |  |  |  |  |  |  |  | -35.04112615811375
 | Totals
 |  |  |  |  | To record monthly payment on funding note for Project XXXXX
Spreadsheet: 164354d1340732189-frequency-of-a-name-corresponding-to-its-date-sample-1
Sheet: Sheet1

Date | Customer | Phone Number | Address |  |  | Count of Customer | Date
2012-05-25 00:00:00 | [NAME] | 000-0001 | 1456 Oakdale Road |  |  | Customer | 5/25/2012 - 5/31/2012 | 6/1/2012 - 6/7/2012 | 6/8/2012 - 6/14/2012 | 6/15/2012 - 6/18/2012 | Grand Total
2012-05-25 00:00:00 | [NAME] | 000-0002 | 786 [NAME] |  |  | [NAME] | 2 | 1 | 1 |  | 4
2012-05-25 00:00:00 | [NAME] | 000-0003 | 546 Brimley |  |  | [NAME] | 2 |  | 2 |  | 4
2012-05-25 00:00:00 | [NAME] | 000-0004 | 1324 Tree Dr |  |  | [NAME] | 2 |  | 2 |  | 4
2012-05-27 00:00:00 | [NAME] | 000-0005 | 67 King St |  |  | [NAME] | 1 | 1 |  | 1 | 3
2012-05-27 00:00:00 | [NAME] | 000-0002 | 786 [NAME] |  |  | [NAME] | 1 |  | 1 | 1 | 3
2012-05-27 00:00:00 | [NAME] | 000-0007 | 98 College |  |  | [NAME] | 1 |  |  | 1 | 2
2012-05-27 00:00:00 | [NAME] | 000-0008 | 543 Trailbreak |  |  | [NAME] | 1 |  |  |  | 1
2012-05-29 00:00:00 | [NAME] | 000-0003 | 546 Brimley |  |  | April Field |  | 1 |  |  | 1
2012-05-29 00:00:00 | [NAME] | 000-0004 | 1324 Tree Dr |  |  | Grand Total | 10 | 3 | 6 | 3 | 22
2012-06-02 00:00:00 | [NAME] | 000-0007 | 98 College
2012-06-02 00:00:00 | [NAME] | 000-0003 | 546 Brimley
2012-06-04 00:00:00 | April Field | 000-0013 | 785 [NAME] |  |  | Count of Customer | Date
2012-06-09 00:00:00 | [NAME] | 000-0004 | 1324 Tree Dr |  |  | Customer | May | Jun | Grand Total
2012-06-09 00:00:00 | [NAME] | 000-0002 | 786 [NAME] |  |  | [NAME] | 2 | 2 | 4
2012-06-09 00:00:00 | [NAME] | 000-0001 | 1456 Oakdale Road |  |  | [NAME] | 1 | 2 | 3
2012-06-10 00:00:00 | [NAME] | 000-0002 | 786 [NAME] |  |  | [NAME] | 1 | 2 | 3
2012-06-10 00:00:00 | [NAME] | 000-0003 | 546 Brimley |  |  | [NAME] | 2 | 2 | 4
2012-06-12 00:00:00 | [NAME] | 000-0004 | 1324 Tree Dr |  |  | [NAME] | 2 | 2 | 4
2012-06-16 00:00:00 | [NAME] | 000-0005 | 67 King St |  |  | April Field |  | 1 | 1
2012-06-16 00:00:00 | [NAME] | 000-0001 | 1456 Oakdale Road |  |  | [NAME] | 1 | 1 | 2
2012-06-17 00:00:00 | [NAME] | 000-0007 | 98 College |  |  | [NAME] | 1 |  | 1
 |  |  |  |  |  | Grand Total | 10 | 12 | 22
Spreadsheet: 3c619c77-c8af-43ad-ab64-02b4a229f179
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
267321 | 73107 | Rehab | Hamdy | EGY |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:09:27
267321 | 82048 | Langa | Salam | IRQ |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:38:22
Spreadsheet: 132893d1324004836-need-to-get-unique-values-from-range-with-some-criteria-re-sample
Sheet: Sheet2

WWW | 111 |  |  | WWW
SSS | 222 |  |  | SSS
RRR | 444 |  |  | RRR
FFF | 777 |  |  | FFF
Q2Q2 | 543 |  |  | Q2Q2
LLL | 234 |  |  | LLL
KKKK | 221 |  |  | KKKK
SASA | 222 |  |  | SASA
QQQQ | 43445 |  |  | QQQQ
WWW | 7572
www | 75275
RRR | 7527
FFF | 863
Q2Q3 | 147856
LLL | 785628
KKKK | 5286238
SASA | 518368
QQQQ | 52172558
WWW | 5Y
SSS | 6GH
RRR | 56UY5U
FFF | TYHTY6U
[NAME] | 65U6HH
LLL | 5Y5HG
Spreadsheet: 85678d1285746324-check-existence-using-two-worksheet-with-one-criteria-given-condition-1-and-0-store-test
Sheet: B using vlookup+countif

Worksheet 2B
 |  |  |  |  | Count if
ID | fruits |  |  |  | [NAME] | apple | grapes | kiwi
Store A | [NAME] | apple | grapes | kiwi | ????? | ????? | ????? | ?????
Store B | apple | grapes | banana |  | ????? | ????? | ????? | ?????
Store C | kiwi |  |  |  | ????? | ????? | ????? | ?????
Store D | apple | grapes |  |  | ????? | ????? | ????? | ?????
Spreadsheet: 215431d1361376903-conditional-data-transfer-between-worksheets-based-on-multiple-conditions-or-criteria-excelexample
Sheet: Worksheet "2"

A | B | C | D | E | F | G | H | I | J | K | L | M | N
ABC123DEF456X | ABC123 | Yes | No | No | 0 | 0 | 0 | 0 | 0 | Georgia | 0 | 0 | 0
GHI789JKL123Z | GHI789 | No | Yes | No | 0 | 0 | 0 | 0 | 0 | Alaska | [NAME] | [PHONE] | ([EMAIL])
Spreadsheet: 193438d1352832522-hiding-rows-using-macro-input-form-oct-2012
Sheet: Project Detail

 |  |  |  |  | Mandatory
 |  |  |  |  |  |  |  |  | True | True | True | True | True
Site Visit Done By: |  |  | Date:
Form Completed By: |  |  | Date:
Form Reviewed By: |  |  | Date:
CLIENT DETAILS
Project Name
Client: |  |  | Contact Name:
Address:
Tel No: |  | Mob No. | E-Mail:
BUILDING DETAILS
Site Address:
Description of Building/Site:
Type of Building: |  |  | Building Age
Total Area (Sq. Ft): |  |  | Leasable Area (Sq. Ft):
No. of Car Parks: |  |  | No. of Floors:
G Floor Description:
M Floor Description:
Other Floors Description:
No. of Retail Units
SERVICE REQUIREMENTS
Service Description:
Specific Requirements:
Current Service Provider:
Any Budget (AED)? |  | Start Date: |  | Duration:
Spreadsheet: 715861d1611893115-countif-from-a-starting-point-using-offset-countif-weights
Sheet: Sheet1

 |  | =TRIM(MID(REPT(" ",6-LEN($BB20))&$BB20,SEQUENCE(,6),1))
 |  | String Value | Indivual Characters |  |  |  |  |  |  | Str len | col where x is from left | col where x is from right | Str len - where x is to start offset | don’t calculate if "x" retruned in the column 5 or 6 | Count If 0 | [NAME] | New Weights
 |  | 0x3152 |  | x | 3 | 1 | 5 | 2
 |  | x46353 |  | 4 | 6 | 3 | 5 | 3
 |  | x46353 |  | 4 | 6 | 3 | 5 | 3
 |  | x46353 |  | 4 | 6 | 3 | 5 | 3
 |  | 13 |  |  |  |  | 1 | 3
 |  | 13 |  |  |  |  | 1 | 3
 |  | 41112x |  | 1 | 1 | 1 | 2 | x
 |  | 1x2876 |  | x | 2 | 8 | 7 | 6
 |  | 25x153 |  | 5 | x | 1 | 5 | 3
 |  | 25x153 |  | 5 | x | 1 | 5 | 3
 |  | 58x2 |  |  | 5 | 8 | x | 2
 |  | 58x2 |  |  | 5 | 8 | x | 2
 |  | 45x112 |  | 5 | x | 1 | 1 | 2
 |  | 961858 |  | 6 | 1 | 8 | 5 | 8
 |  | 415440 |  | 1 | 5 | 4 | 4 | 0
Spreadsheet: 328769d1404063792-need-cells-with-a-value-other-then-what-is-displayed-cut-list
Sheet: Mirrors

Mirror [NAME] | Mirror Height | Side Material | Bottom Material | Top Material | Overhang on end | Over hang onto mirror | Top | Sides | Bottom
90 | 40.625 |  |  |  | 0.5 | 0.25 | #N/A | #N/A | 89.5
42 | 31.75 |  |  |  | 0.5 | 0.25 | #N/A | #N/A | 41.5
72 | 40.625 |  |  |  | 0.5 | 0.25 | #N/A | #N/A | 71.5
Cut List |  |  |  |  |  |  | 1x2 | 1.5
 |  |  |  |  |  |  | 1x3 | 2.5
Quantity | 0 |  |  |  |  |  | 1x4 | 3.5
2 | #N/A |  |  |  |  |  | 1x6 | 5.5
2 | #N/A |  |  |  |  |  | 1x8 | 6.5
2 | #N/A |  |  |  |  |  | 5/4x4 | 3.5
2 | 0 |  |  |  |  |  | 5/4x6 | 5.5
2 | 0 |  |  |  |  |  | 5/4x8 | 7.5
2 | 0
1 | 89.5
1 | 41.5
1 | 71.5
1 | 0
1 | 0
1 | 0
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12353 | 11113 | -1
2 | 12672 | 11039
3 | 12650 | 11039 | -1
4 | 12883 | 11039 | -2
5 | 13332 | 11039 | -455
6 | 13796 | 11039 | -611
7 | 13804 | 11039 | -497
8 | 13728 | 11039 | -514
9 | 13407 | 10537 | -601
10 | 13410 | 10537 | -639
11 | 13165 | 11039 | -566
12 | 13333 | 11039 | -513
13 | 13177 | 11039 | -595
14 | 12983 | 11039 | -551
15 | 13223 | 10949 | -594
16 | 13029 | 10058 | -614
17 | 13115 | 10235 | -600
18 | 13133 | 10852 | -623
19 | 11429 | 11113 | -651
20 | 11584 | 11113 | -690
21 | 11606 | 11037 | -707
22 | 12644 | 11113 | -225
23 | 12722 | 10700 | -202
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  | 691849.47
2001-06-23 00:00:00
Spreadsheet: 686031d1594318275-very-similar-column-text-filter-on-one-sheet-number-filter-on-other-why-different-2020-07-09-gottajam-686029d1594317732-very-similar-column-text-filter-on-one-sheet-number-filte
Sheet: Sheet1

Code | B | C | D | E | F
710000
710001
710002
710003
710004
710005
710006
710007
710008
710009
710010
710011
710012
710013
710014
710015
710016
710017
710018