tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 747346d1631423258-calculating-values-but-ignoring-if-its-a-higher-value-than-the-previous-one-booksample
Sheet: BookSample

 | Monday | Tuesday | Wed | Thu | Fri | Sat | Sun | TOTAL |  |  |  |  |  |  |  |  | SUMPRODUCT
0 | 100 | 97 | 65 | 223 | 211 | 150 | 120 | -20 | Wrong
1 | 100 | 100 | 90 | 45 | 125 | 120 | 95 | 5 | Wrong
2 | 100 | 100 | 100 | 100 | 100 | 100 | 90 | 10
3 | 100 | 100 | 76 | 23 | 1 | 305 | 250 | -150 | Wrong
4 | 100 | 95 | 85 | 65 | 65 | 35 | 20 | 80
5 | 100 | 20 | 365 | 350 | 344 | 289 | 234 | -134 | Wrong
6 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
7 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
8 | 100 | 100 | 98 | 96 | 95 | 85 | 64 | 36
9 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
10 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
11 | 100 | 94 | 94 | 94 | 94 | 94 | 94 | 6
12 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
13 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
14 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
15 | 100 | 98 | 94 | 65 | 23 | 124 | 110 | -10 | Wrong
16 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
IGNORED CELLS
Spreadsheet: 4160c74c-6857-4033-8c1f-77755f7c2ea6
Sheet: APRIL3-15

RGE Water Quality April 16 - May 2, 2014
Date Time | Temp | Sal | pH | [NAME]
M/D/Y HH:MM:SS | F | ppt |  | mg/L
2014-04-16 13:00:33 | 61.61 | 0.1 | 7.75 | 9.18
2014-04-16 19:00:33 | 62.76 | 0.09 | 7.27 | 9.04
2014-04-17 01:00:33 | 61.77 | 0.09 | 7.45 | 8.77
2014-04-17 07:00:33 | 61.2 | 0.09 | 7.4 | 8.52
2014-04-17 13:00:33 | 62.08 | 0.09 | 7.62 | 9.67
2014-04-17 19:00:33 | 62.93 | 0.09 | 7.2 | 8.63
2014-04-18 01:00:33 | 62.82 | 0.09 | 7.36 | 8.35
2014-04-18 07:00:33 | 61.87 | 0.1 | 7.37 | 8.32
2014-04-18 13:00:33 | 62.12 | 0.1 | 7.49 | 9.64
2014-04-18 19:00:33 | 62 | 0.09 | 7.09 | 8.08
2014-04-19 01:00:33 | 61.86 | 0.09 | 7.32 | 7.97
2014-04-19 07:00:33 | 61.1 | 0.09 | 7.35 | 8.13
2014-04-19 13:00:33 | 61.85 | 0.09 | 7.47 | 8.04
2014-04-19 19:00:33 | 61.89 | 0.09 | 7.19 | 8.49
2014-04-20 01:00:33 | 62.1 | 0.09 | 7.34 | 8.34
2014-04-20 07:00:33 | 61.06 | 0.09 | 7.37 | 8.4
2014-04-20 13:00:33 | 63.27 | 0.09 | 7.57 | 9.23
2014-04-20 19:00:33 | 63.77 | 0.09 | 7.21 | 8.6
2014-04-21 01:00:33 | 63.62 | 0.09 | 7.37 | 8.4
2014-04-21 07:00:33 | 62.91 | 0.09 | 7.41 | 8.61
2014-04-21 13:00:33 | 62.82 | 0.09 | 7.53 | 8.34
2014-04-21 19:00:33 | 64.81 | 0.09 | 7.21 | 8.39
2014-04-22 01:00:33 | 64.59 | 0.09 | 7.37 | 8.35
2014-04-22 07:00:33 | 63.75 | 0.09 | 7.4 | 8.4
2014-04-22 13:00:00 | 64.63 | 0.09 | 7.51 | 8.3
2014-04-23 13:00:33 | 64.4 | 0.09 | 7.4 | 8.09
2014-04-23 19:00:33 | 64.16 | 0.09 | 7.15 | 8
2014-04-24 01:00:33 | 64.56 | 0.1 | 7.36 | 7.6
2014-04-24 07:00:33 | 64.23 | 0.09 | 7.41 | 8.18
2014-04-24 13:00:33 | 65.53 | 0.09 | 7.5 | 7.91
2014-04-25 13:00:33 | 64.64 | 0.09 | 7.5 | 7.52
2014-04-25 19:00:33 | 66.07 | 0.09 | 7.22 | 8.04
2014-04-26 01:00:33 | 65.75 | 0.09 | 7.36 | 7.65
2014-04-26 07:00:33 | 64.84 | 0.09 | 7.36 | 7.5
2014-04-26 19:00:00 | 66.5 | 0.1 | 7.59 | 7.76
2014-04-27 01:00:36 | 66.84 | 0.09 | 7.14 | 7.31
2014-04-27 07:00:33 | 66.33 | 0.1 | 7.34 | 7.3
2014-04-27 13:00:33 | 67.27 | 0.09 | 7.44 | 7.55
2014-04-27 19:00:33 | 67.11 | 0.09 | 7.19 | 7.6
2014-04-28 01:00:33 | 67.02 | 0.09 | 7.32 | 7.27
2014-04-28 07:00:33 | 66.89 | 0.09 | 7.34 | 7.24
2014-04-28 13:00:33 | 66.91 | 0.09 | 7.46 | 7.17
2014-04-28 19:00:33 | 67.29 | 0.09 | 7.19 | 7.36
2014-04-29 01:00:33 | 67.46 | 0.09 | 7.36 | 7.46
2014-04-29 07:00:33 | 66.38 | 0.09 | 7.36 | 7.29
2014-04-29 13:00:00 | 68.01 | 0.09 | 7.46 | 7.42
2014-04-29 19:00:33 | 68.66 | 0.09 | 7.13 | 6.37
2014-04-30 01:00:33 | 68.11 | 0.08 | 7.24 | 6.38
2014-04-30 07:00:33 | 67.16 | 0.07 | 7.15 | 6.41
2014-04-30 13:00:33 | 67.88 | 0.09 | 7.45 | 6.91
2014-04-30 19:00:33 | 68.36 | 0.07 | 7 | 5.98
2014-05-01 01:00:33 | 67.61 | 0.07 | 7.09 | 5.63
2014-05-01 07:00:33 | 67.42 | 0.07 | 7.22 | 5.19
2014-05-01 13:00:33 | 67.69 | 0.08 | 7.35 | 6.51
2014-05-01 19:00:33 | 68.32 | 0.07 | 6.99 | 6.19
2014-05-02 01:00:33 | 67 | 0.08 | 7.22 | 6.48
2014-05-02 07:00:33 | 66.58 | 0.09 | 7.24 | 6.45
Spreadsheet: 159682d1338815652-excel-2007-i-need-a-formula-which-when-dates-match-transfer-the-data-from-the-entire-row-dates-and-data
Sheet: Annual Data

 |  |  |  |  | When the date in Monthly Data Sheet matches with the date in Annual Data Sheet : Insert the entire row
 |  | 2012-01-01 00:00:00
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holidays11
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00 | Fixed Date | 1
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-06 00:00:00 | Fixed Date | 2
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-27 00:00:00 | Non Fixed Date | 3
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-25 00:00:00 | Fixed Date | 4
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-13 00:00:00 | Non Fixed Date | 5
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-16 00:00:00 | Non Fixed Date | 6
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00 | Fixed Date | 7
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-04 00:00:00 | Non Fixed Date | 8
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-15 00:00:00 | Fixed Date | 9
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-28 00:00:00 | Fixed Date | 10
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-24 00:00:00 | Fixed Date | 11
 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-25 00:00:00 | Fixed Date | 12
 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-26 00:00:00 | Fixed Date | 13
 | 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
Spreadsheet: 844663d1696407264-assembly-part-calculation-example2-7-aligw
Sheet: Sheet1

Assembly | Quantity of assembly | Parts name | Parts quantity in one assembly | The assembly to which the parts belong | Column1
B-PL-S-1_DP | 10 | B-PL-S-1 | 1 | B-PL-S-1_DP
B-PL-S-2_DP | 10 | B-PL-STD-1 | 1 | B-PL-S-1_DP
 |  | B-PL-STD-2 | 2 | B-PL-S-1_DP
 |  | Varztas HDG M12x140 ISO4017 8.8 | 2 | B-PL-S-1_DP
 |  | Poveržlė HDG M12 8.8 klasė | 2 | B-PL-S-1_DP
 |  | Medsraigtis [NAME] 12x100 DIN571 | 4 | B-PL-S-1_DP
 |  | Vinys_HILTI_X-U_16MX | 8 | B-PL-S-1_DP
 |  | B-PL-S-1 | 1 | B-PL-S-2_DP
 |  | B-PL-STD-1 | 1 | B-PL-S-2_DP
 |  | B-PL-STD-2 | 2 | B-PL-S-2_DP
 |  | Varztas HDG M12x140 ISO4017 8.8 | 2 | B-PL-S-2_DP
 |  | Poveržlė HDG M12 8.8 klasė | 2 | B-PL-S-2_DP
 |  | Medsraigtis [NAME] 12x100 DIN571 | 4 | B-PL-S-2_DP
 |  | Vinys_HILTI_X-U_16MX | 8 | B-PL-S-2_DP
Spreadsheet: 78862d1279151709-using-sumproduct-and-a-dynamic-range-dynamic-range
Sheet: Sheet1

 |  |  |  | Expense Log
 |  |  |  | 2010-06-30 00:00:00 | 2010-07-14 00:00:00 |  | 198.96
 |  |  |  | 2010-06-30 00:00:00 | 2010-07-14 00:00:00 |  | #N/A
 |  | Purchase |  |  |  |  |  | PMT
 |  | 2010-07-01 00:00:00 | Thu |  | 7.88 |  |  | 11
 |  | 2010-07-01 00:00:00 | Thu |  | 25.73 |  |  | 25.73
 |  | 2010-07-01 00:00:00 | Thu |  | 30 |  |  | 30
 |  | 2010-07-01 00:00:00 | Thu |  | 0 |  |  | 3
 |  | 2010-07-02 00:00:00 | Fri |  | 11.48 |  |  | 16
 |  | 2010-07-03 00:00:00 | Sat |  | 7.5 |  |  | 11
 |  | 2010-07-04 00:00:00 | Sun |  | 0 |  |  | 5
 |  | 2010-07-05 00:00:00 | Mon |  | 8.5 |  |  | 12
 |  | 2010-07-06 00:00:00 | Tue |  | 4.5 |  |  | 10
 |  | 2010-07-07 00:00:00 | Wed |  | 4.5 |  |  | 10
 |  | 2010-07-08 00:00:00 | Thu |  | 13.38 |  |  | 19
 |  | 2010-07-08 00:00:00 | Thu |  | 46.23 |  |  | 46.23
Spreadsheet: 42697d1241244933-updating-a-formula-based-on-multiple-sheets-demo
Sheet: Summary

No of Items Sold
 | 1 | 2 | 3 | 4
Apple | 24
Mango
[NAME]
Pine Apple
Kiwi
Estimation
 | 1 | 2 | 3 | 4
Apple
Mango
[NAME]
Pine Apple
Kiwi
Spreadsheet: 683070d1592474146-conditional-formatting-based-on-dates-in-cells-query-job-sheet-sample
Sheet: WAITING LIST UPDATE

WAITING LIST UPDATE
2020
Month | Waitlist Number as of month end | EMPLOYMENT SPECALIST NOTES
January | 5
February | 3
March | 4
April | 5
May | 6
June | 13
July | 0 | ALIEN INVASION
August | 70 | ALIENS WANT JOBS
September
October
November
December
Spreadsheet: 844538d1696327700-data-validation-example-data-validation-file
Sheet: Sheet1

 | =B11:B14 | =IF(B5=B11,G11:G14,IF(B12=B5,G15:G18,IF(B5=B13,G19:G21,IF(B14=B5,G22:G26,B15))))
 | Level 1 | Level 2 | Level 3
 | B | 2.4 | G2
 | Level 1 |  |  |  | Level 1 | Level 2 |  |  | Level 2 | Level 3
 | A |  |  |  | A | 1.1 |  |  | 1.1 | A1
 | B |  |  |  | A | 1.2 |  |  | 1.1 | A2
 | C |  |  |  | A | 1.3 |  |  | 1.2 | B1
 | D |  |  |  | A | 1.4 |  |  | 1.2 | B2
 |  |  |  |  | B | 2.1 |  |  | 1.3 | C1
 |  |  |  |  | B | 2.2 |  |  | 1.3 | C2
 |  |  |  |  | B | 2.3 |  |  | 1.4 | D1
 |  |  |  |  | B | 2.4 |  |  | 1.4 | D2
 |  |  |  |  | C | 3.1 |  |  | 2.1 | E1
 |  |  |  |  | C | 3.2 |  |  | 2.1 | E2
 |  |  |  |  | C | 3.3 |  |  | 2.2 | F1
 |  |  |  |  | D | 4.1 |  |  | 2.2 | F2
 |  |  |  |  | D | 4.2 |  |  | 2.3 | F3
 |  |  |  |  | D | 4.3 |  |  | 2.3 | F4
 |  |  |  |  | D | 4.4 |  |  | 2.4 | [NAME]
 |  |  |  |  | D | 4.5 |  |  | 2.4 | G2
 |  |  |  |  |  |  |  |  | 3.1 | H1
 |  |  |  |  |  |  |  |  | 3.1 | H2
 |  |  |  |  |  |  |  |  | 3.2 | I1
 |  |  |  |  |  |  |  |  | 3.2 | I2
 |  |  |  |  |  |  |  |  | 3.3 | J1
 |  |  |  |  |  |  |  |  | 3.3 | J2
 |  |  |  |  |  |  |  |  | 4.1 | K1
 |  |  |  |  |  |  |  |  | 4.1 | K2
 |  |  |  |  |  |  |  |  | 4.2 | L1
 |  |  |  |  |  |  |  |  | 4.2 | L2
 |  |  |  |  |  |  |  |  | 4.3 | M1
 |  |  |  |  |  |  |  |  | 4.3 | M2
 |  |  |  |  |  |  |  |  | 4.4 | N1
 |  |  |  |  |  |  |  |  | 4.4 | N2
 |  |  |  |  |  |  |  |  | 4.5 | O1
 |  |  |  |  |  |  |  |  | 4.5 | O2
Spreadsheet: 762911d1641899952-compact-cell-by-row-deleting-empty-cells-compact-by-row-1-
Sheet: Foglio1

a |  | b | c |  | d |  |  | e
 | f |  | g | h |  | j |  |  |  | k | l
 |  | i need to obtain
 |  |  |  |  |  | b | c | d | e
 |  |  |  |  |  | g | h | j | k | l
a | b | c | d | e
f | g | h | j | k | l
Spreadsheet: 33352d1229646113-pivot-table-filtering-on-individual-counts-not-total-test4
Sheet: Main Pivot

Week Num | (All)
Count of Case ID.
Name | Total
Name 1032 | 18
Name 1036 | 9
Name 1037 | 22
Name 1045 | 17
Name 1047 | 7
Name 106 | 22
Name 1070 | 10
Name 1076 | 15
Name 1104 | 12
Name 1152 | 6
Name 1159 | 6
Name 1169 | 8
Name 1173 | 34
Name 1178 | 20
Name 1246 | 8
Name 128 | 8
Name 1290 | 8
Name 1320 | 7
Name 1331 | 16
Name 1354 | 19
Name 1405 | 9
Name 1409 | 6
Name 1423 | 8
Name 1432 | 6
Name 1507 | 11
Name 1524 | 9
Name 1528 | 6
Name 1545 | 8
Name 1727 | 14
Name 1743 | 20
Name 1765 | 10
Name 180 | 6
Name 1823 | 10
Name 188 | 23
Name 1882 | 19
Name 1883 | 8
Name 1900 | 7
Name 1929 | 32
Name 1960 | 23
Name 1979 | 9
Name 198 | 8
Name 1994 | 27
Name 2023 | 11
Name 2033 | 11
Name 2051 | 6
Name 2070 | 7
Name 2073 | 32
Name 254 | 6
Name 261 | 15
Name 285 | 21
Name 311 | 6
Name 323 | 8
Name 369 | 13
Name 385 | 11
Name 417 | 7
Name 420 | 13
Name 427 | 6
Name 432 | 13
Name 472 | 9
Name 476 | 6
Name 507 | 10
Name 53 | 24
Name 573 | 7
Name 583 | 6
Name 630 | 17
Name 637 | 10
Name 68 | 9
Name 693 | 9
Name 705 | 12
Name 706 | 7
Name 721 | 19
Name 800 | 8
Name 804 | 9
Name 815 | 11
Name 828 | 11
Name 832 | 7
Name 864 | 6
Name 876 | 36
Name 877 | 15
Name 902 | 7
Name 92 | 6
Name 937 | 7
Name 95 | 14
Name 952 | 9
Grand Total | 1028
Spreadsheet: 836069d1689077374-using-offset-formula-to-calculate-the-average-where-there-is-no-data-zeros-in-data-dummy-data-for-offset
Sheet: Data_Leavers

Attrition rates
1. input data here - this format has to stay the same | 22/23 | 22/23 | 22/23 | 22/23 | 22/23 | 22/23 | 22/23 | 22/23 | 22/23 | 22/23 | 22/23 | 22/23 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24
 | P11 | P11 | P11 | P11 | P12 | P12 | P12 | P12 | P13 | P13 | P13 | P13 | P1 | P1 | P1 | P1 | P2 | P2 | P2 | P2 | P3 | P3 | P3 | P3 | P4 | P4 | P4 | P4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | P4 W4
Depot | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | Total No of employed drivers | Total No of leavers | Period Attrition Rate % | Internal transfers | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers
Barking | 340 | 1.5 | 0.004411764705882353 |  | 340 | 5.5 | 0.0161764705882353 |  | 335.5 | 5 | 0.01490312965722802 |  | 328 | 1.5 | 0.004573170731707317 |  | 321 | 6 | 0.01869158878504673
Bow | 358 | 5 | 0.01396648044692737 |  | 353 | 4.5 | 0.01274787535410765 |  | 355 | 3.5 | 0.009859154929577466 |  | 350.5 | 6 | 0.01711840228245364 |  | 344 | 3 | 0.00872093023255814
Leyton | 284.5 | 3.5 | 0.01230228471001757 |  | 280.5 | 4 | 0.0142602495543672 |  | 280 | 2.5 | 0.008928571428571428 |  | 276 | 3.5 | 0.01268115942028986 |  | 274 | 6.5 | 0.02372262773722628
Attrition trend | 1 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
2. formula to bring all the "period attrition rate" data from above together | 22/23 | 22/23 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24
 | P1 | P13 | P1 | P2 | P3 | P4 | P5 | P6
Depot | Period Attrition Rate % | Period Attrition Rate % | Period Attrition Rate % | Period Attrition Rate % | Period Attrition Rate % | Period Attrition Rate % | Period Attrition Rate % | Period Attrition Rate %
Barking |  |  |  |  |  |  |  |  |  | what if I use if is number/search to bring in % where there are numbers above otherwise show 0?
Bow
Leyton
Romford
3. the average to be used. I want this to be the average of the latest X months (X being B28) but if the data above = 0, I want it to ake the average there are numbers. E.g. in F,G,H and I32, it is showing blank because the cell it's looking up, F/G/H/I20 is blank so I want it to take the average of E,D and C 20 since there are numbers in here.
Moving average period >>> | 3
 | 22/23 | 22/23 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24 | 23/24
 | P1 | P13 | P1 | P2 | P3 | P4 | P5 | P6
Depot
Barking
Bow
Leyton
Romford
Spreadsheet: 723130d1615534701-formulas-for-pinochle-score-sheet-pinochle-scoring
Sheet: Sheet1

 | 1 | 2 | 3 | Dealer
 | 0 | 0 | 0
BID | 500
MELD | 100 | 140 | 160
TRICKS | 330 | 70 | 100 |  | IF((B4+B5>=B3),(B4+B5),(B2-B3))
TOTAL |  |  |  |  | IF(B5<100,B2,(IF(SUM(B4:B5)>B3,SUM(B2+B4+B5),B2-B3)))
BID | 710
MELD | 340 | 380 | 600
TRICKS | 300 | 100 | 100
TOTAL
BID |  | 610
MELD | 540 | 540 | 80
TRICKS | 0 | 240 | 180
TOTAL
Bid |  |  | 690
[NAME] | 100 | 100 | 1940
Tricks | 120 | 80 | 300
Total
Bid | 590
[NAME] | 360 | 240 | 260
Tricks | 300 | 90 | 110
Total
Bid |  |  | 650
[NAME] | 300 | 220 | 340
Tricks | 70 | 200 | 230
Total
Bid |  | 500
[NAME] | 460 | 380 | 120
Tricks | 130 | 240 | 130
Total
Bid |  |  | 750
[NAME] | 340 | 140 | 440
Tricks | 80 | 110 | 310
Total
Bid |  |  | 800
[NAME] | 300 | 60 | 630
Tricks | 90 | 80 | 330
Total
Bid | 620
[NAME] | 2400 | 140 | 120
Tricks | 190 | 160 | 150 |  | [NAME])
Total |  |  |  |  | IF(C41<100,C38,(IF(SUM(C40:C41)>C39,SUM(C38+C40+C41),C38-C39)))
Bid |  |  | 500 |  | For the individual that takes the bid, no matter how high the meld, if the total number of tricks doesn't equal 200, the bid is lost and bid amount should be negative and added to previous total.  That should be the first criteria and is the first formula.  The second formula works when the bid is achieved or the individual gains over 100 tricks and doesn't take the bid.
[NAME] | 440 | 220 | 580
Tricks | 140 | 80 | 270
Total
Bid |  | 470
[NAME] | 360 | 440 | 60
Tricks | 90 | 190 | 140
Total
Spreadsheet: d8b175cc-f1d0-4458-861b-61781414d46f
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Employee Benefits
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2005-06 |  |  | FY 2006-07
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2005-06 |  |  | FY 2006-07
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ |  |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 47739d1246910777-excel-2007-look-at-row-find-a-value-report-column-header-index-match-students
Sheet: Sheet1

 | [NAME] | [NAME] | [NAME] |  |  | Mr Still | [NAME] | [NAME] | Mr [NAME] | Mr [NAME]
13:00:00 | Mr Still | [NAME] | [NAME] |  | 13:00:00 | [NAME] | [NAME] | [NAME] | - | -
14:00:00 | Mr [NAME] | Mr [NAME] | [NAME] |  | 14:00:00 | - | [NAME] | - | [NAME] | [NAME]
15:00:00 | [NAME] | [NAME] | Mr [NAME] |  | 15:00:00 | - | [NAME] | [NAME] | [NAME] | -
Spreadsheet: 819872d1677742839-copy-all-sheets-data-into-one-sheet-copy-all-sheets-into-one
Sheet: Sheet1

code | name | task
 | 1 | 1
1 | 1 | 1
1 | 1 | 1
2 | 2 | 2
2 | 2 | 2
3 | 3 | 33
a | a | a
2 | 2 | 2
a | a | a
3 | 3 | 3
3 | 3 | 33
3 | 3 | 3
Spreadsheet: 781721d1653499571-filter-formula-with-multiple-conditions-test
Sheet: Sheet2

 |  |  | Person | Region | Responsible | District
 |  |  |  | R | Single | 11
 |  |  | B | R | Multi | 11
 |  |  | C | R | Single | 11
 |  |  | G | R | Multi | 12
 |  |  | I | R | Multi | 14
 |  |  | Person | Region | Responsible | District
 |  |  |  | R | Single | 11
 |  |  | C | R | Single | 11
Spreadsheet: 0b8cfc78-fd06-41be-a88c-fc2a74f45cd0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Name of Department | English-as-a-Second-Language | Unnamed: 5
 |  |  | Instructor Name
 |  |  | Name of Course
 |  |  | Semester, Year
Directions:
This form must be completed and submitted with your grades if you have given lab credit for
lab orientation (1 hour) or for an activity outside of the computer lab.  No lab credit can be
awarded for an outside activity unless it has officially been approved in advance by the E.S.L.
Deparment Chair, like those announced by the department through a memo or flyer.  To show
completion of the course lab requirement, computer hours and alternate hours should total 16 hours.
Alternate Lab Documentation
 |  | [NAME] | Activity or
 |  | on Final | Orientation |  | Total
 | STUDENT NAME | Lab Run | Credit | Name of Activity | Hours
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
If a student has no alternate credit (neither an outside activity nor 1 hour of orientation credit),
his/her name doesn't need to be entered on this form.
Spreadsheet: 0eb76dc4-6453-4ce0-a89b-3f4c79d3606f
Sheet: Table I.18

Table I.18 الجدول
Pilot SEEAW Physical Water Use Table, Egypt, 2009 (BCM)
[NAME] المياه الريادي، مصر، 2009 (مليار متر مكعب)
 |  | Industries by ISIC Categories |  |  |  |  |  |  | Households | Rest of the world | Total
 |  | الصناعات [NAME] [NAME] الموحد [NAME] – الأيزيك |  |  |  |  |  |  | الأسر المعيشية | سائر بلدان العالم | المجموع
 |  | Agriculture ISIC 1-3 | Industry and services 5-33, 38,39,41-43,45-99 | Electricity (only cooling) 35 | Electricity (hydroelectric) 35 | Public Water Supply 36 | Sewerage 37 | Total
 |  | الزراعة | الصناعة والخدمات | [NAME] ([NAME]) | [NAME] (الطاقة الكهرومائية) | إمدادات المياه العامة | مياه الصرف الصحي | المجموع
From the environment | i.a Abstraction for own use | 61.6 | 0.7 | 8.6 | 187 | 8.2 | - | 266.1 | - |  | 266.1 | 1-أ الاستخراج للاستخدام الشخصي | من البيئة
 | i.b Abstraction for distribution |  |  |  |  | 8.2 |  | 8.2 |  |  | 8.2 | 1-ب الاستخراج للتوزيع
 | i.b.1 From water resources: | 61.6 | 0.7 | 8.6 | 187 | 8.2 | - | 266.1 | - |  | 266.1 | 1-ب-1 من الموارد المائية:
 | i.b.1.I Surface water | 56.2 | 0.7 | 8.6 | 187 | 7.1 |  | 259.6 | - |  | 259.6 | 1-ب-1-ألف المياه السطحية
 | i.b.1.II Groundwater (shallow) | 4.3 |  |  |  | 1.1 |  | 5.4 |  |  | 5.4 | 1-ب-1-باء المياه الجوفية
 | i.b.1.III [NAME] (deep) | 1.1 |  |  |  |  |  | 1.1 | - |  | 1.1
 | i.b.1.IV Soil water |  |  |  |  |  |  | - |  |  | - | 1-ب-1-جيم مياه التربة
 | i.b.2 From other sources |  | - | - | - | 0.02 | - | - | - |  | - | 1-ب-2 من مصادر أخرى
 | i.b.2 Collection of precipitation |  |  |  |  |  |  | - |  |  | - | 1-ب-2-ألف تجميع مياه الأمطار
 | i.b.2.II Abstraction from the sea |  |  |  |  | 0.02 |  | - |  |  | - | 1-ب-2-باء الاستخراج من مياه البحر
Within the economy | ii Use of water received from other economic units (ii.a+ii.b) | - | 0.7 | - | - | - | 4.4 | 5.1 | 5.8 |  | 10.9 | 2- استخدام [NAME] الأخرى | [NAME]
(i+ii) | ii.a of which: Reused water | - | - |  |  |  |  | - |  |  | - | 2-أ المياه المعاد استخدامها
 | Total use of water | 61.6 | 1.4 | 8.6 | 187 | 8.2 | 4.4 | 271.2 | 5.8 |  | 277 | مجموع استخدام المياه
Source: | Technical Mission Report to Egypt, April 2010, ESCWA.