Spreadsheet: 111364d1307728468-evenly-forecast-a-group-wtih-varying-sizes-to_be_grouped
Sheet: Sheet1

 | Total Inspections
 | East | West | # of Inspections per month (three year cycle) | # of Inspections per month (wo year cycle)
Group
A | 142 | 22 | 4 | 0.92
B | 12 | 60 | 0 | 2.5
C | 255 | 16 | 7 | 0.67
D | 75 | 32 | 2 | 1.33
 |  |  |  | Start Date | 2012-01-01 00:00:00
House | Section | Group
1 | East | A
2 | East | A
3 | East | A
4 | East | A
5 | East | A
6 | East | A
7 | East | A
8 | East | A
9 | East | A
10 | East | A
11 | East | A
12 | East | A
13 | East | A
14 | East | A
15 | East | A
16 | East | A
17 | East | A
18 | East | A
19 | East | A
20 | East | A
21 | East | A
22 | East | A
23 | East | A
24 | East | A
25 | East | A
26 | East | A
27 | East | A
28 | East | A
29 | East | A
30 | East | A
31 | East | A
32 | East | A
33 | East | A
34 | East | A
35 | East | A
36 | East | A
37 | East | A
38 | East | A
39 | East | A
40 | East | A
41 | East | A
42 | East | A
43 | East | A
44 | East | A
45 | East | A
46 | East | A
47 | East | A
48 | East | A
49 | East | A
50 | East | A
51 | East | A
52 | East | A
53 | East | A
54 | East | A
55 | East | A
56 | East | A
57 | East | A
58 | East | A
59 | East | A
60 | East | A
61 | East | A
62 | East | A
63 | East | A
64 | East | A
65 | East | A
66 | East | A
67 | East | A
68 | East | A
69 | East | A
70 | East | A
71 | East | A
72 | East | A
73 | East | A
74 | East | A
75 | East | A
76 | East | A
77 | East | A
78 | East | A
79 | East | A
80 | East | A
81 | East | A
82 | East | A
83 | East | A
84 | East | A
85 | East | A
86 | East | A
87 | East | A
88 | East | A
89 | East | A
90 | East | A
91 | East | A
92 | East | A
93 | East | A
94 | East | A
95 | East | A
96 | East | A
97 | East | A
98 | East | A
99 | East | A
100 | East | A
101 | East | A
102 | East | A
103 | East | A
104 | East | A
105 | East | A
106 | East | A
107 | East | A
108 | East | A
109 | East | A
110 | East | A
111 | East | A
112 | East | A
113 | East | A
114 | East | A
115 | East | A
116 | East | A
117 | East | A
118 | East | A
119 | East | A
120 | East | A
121 | East | A
122 | East | A
123 | East | A
124 | East | A
125 | East | A
126 | East | A
127 | East | A
128 | East | A
129 | East | A
130 | East | A
131 | East | A
132 | East | A
133 | East | A
134 | East | A
135 | East | A
136 | East | A
137 | East | A
138 | East | A
139 | East | A
140 | East | A
141 | East | A
142 | East | A
143 | West | A
144 | West | A
145 | West | A
146 | West | A
147 | West | A
148 | West | A
149 | West | A
150 | West | A
151 | West | A
152 | West | A
153 | West | A
154 | West | A
155 | West | A
156 | West | A
157 | West | A
158 | West | A
159 | West | A
160 | West | A
161 | West | A
162 | West | A
163 | West | A
164 | West | A
165 | East | B
166 | East | B
167 | East | B
168 | East | B
169 | East | B
170 | East | B
171 | East | B
172 | East | B
173 | East | B
174 | East | B
175 | East | B
176 | East | B
177 | West | B
178 | West | B
179 | West | B
180 | West | B
181 | West | B
182 | West | B
183 | West | B
184 | West | B
185 | West | B
186 | West | B
187 | West | B
188 | West | B
189 | West | B
190 | West | B
191 | West | B
192 | West | B
193 | West | B
194 | West | B
195 | West | B
196 | West | B
197 | West | B
198 | West | B
199 | West | B
200 | West | B
201 | West | B
202 | West | B
203 | West | B
204 | West | B
205 | West | B
206 | West | B
207 | West | B
208 | West | B
209 | West | B
210 | West | B
211 | West | B
212 | West | B
213 | West | B
214 | West | B
215 | West | B
216 | West | B
217 | West | B
218 | West | B
219 | West | B
220 | West | B
221 | West | B
222 | West | B
223 | West | B
224 | West | B
225 | West | B
226 | West | B
227 | West | B
228 | West | B
229 | West | B
230 | West | B
231 | West | B
232 | West | B
233 | West | B
234 | West | B
235 | West | B
236 | West | B
237 | East | C
238 | East | C
239 | East | C
240 | East | C
241 | East | C
242 | East | C
243 | East | C
244 | East | C
245 | East | C
246 | East | C
247 | East | C
248 | East | C
249 | East | C
250 | East | C
251 | East | C
252 | East | C
253 | East | C
254 | East | C
255 | East | C
256 | East | C
257 | East | C
258 | East | C
259 | East | C
260 | East | C
261 | East | C
262 | East | C
263 | East | C
264 | East | C
265 | East | C
266 | East | C
267 | East | C
268 | East | C
269 | East | C
270 | East | C
271 | East | C
272 | East | C
273 | East | C
274 | East | C
275 | East | C
276 | East | C
277 | East | C
278 | East | C
279 | East | C
280 | East | C
281 | East | C
282 | East | C
283 | East | C
284 | East | C
285 | East | C
286 | East | C
287 | East | C
288 | East | C
289 | East | C
290 | East | C
291 | East | C
292 | East | C
293 | East | C
294 | East | C
295 | East | C
296 | East | C
297 | East | C
298 | East | C
299 | East | C
300 | East | C
301 | East | C
302 | East | C
303 | East | C
304 | East | C
305 | East | C
306 | East | C
307 | East | C
308 | East | C
309 | East | C
310 | East | C
311 | East | C
312 | East | C
313 | East | C
314 | East | C
315 | East | C
316 | East | C
317 | East | C
318 | East | C
319 | East | C
320 | East | C
321 | East | C
322 | East | C
323 | East | C
324 | East | C
325 | East | C
326 | East | C
327 | East | C
328 | East | C
329 | East | C
330 | East | C
331 | East | C
332 | East | C
333 | East | C
334 | East | C
335 | East | C
336 | East | C
337 | East | C
338 | East | C
339 | East | C
340 | East | C
341 | East | C
342 | East | C
343 | East | C
344 | East | C
345 | East | C
346 | East | C
347 | East | C
348 | East | C
349 | East | C
350 | East | C
351 | East | C
352 | East | C
353 | East | C
354 | East | C
355 | East | C
356 | East | C
357 | East | C
358 | East | C
359 | East | C
360 | East | C
361 | East | C
362 | East | C
363 | East | C
364 | East | C
365 | East | C
366 | East | C
367 | East | C
368 | East | C
369 | East | C
370 | East | C
371 | East | C
372 | East | C
373 | East | C
374 | East | C
375 | East | C
376 | East | C
377 | East | C
378 | East | C
379 | East | C
380 | East | C
381 | East | C
382 | East | C
383 | East | C
384 | East | C
385 | East | C
386 | East | C
387 | East | C
388 | East | C
389 | East | C
390 | East | C
391 | East | C
392 | East | C
393 | East | C
394 | East | C
395 | East | C
396 | East | C
397 | East | C
398 | East | C
399 | East | C
400 | East | C
401 | East | C
402 | East | C
403 | East | C
404 | East | C
405 | East | C
406 | East | C
407 | East | C
408 | East | C
409 | East | C
410 | East | C
411 | East | C
412 | East | C
413 | East | C
414 | East | C
415 | East | C
416 | East | C
417 | East | C
418 | East | C
419 | East | C
420 | East | C
421 | East | C
422 | East | C
423 | East | C
424 | East | C
425 | East | C
426 | East | C
427 | East | C
428 | East | C
429 | East | C
430 | East | C
431 | East | C
432 | East | C
433 | East | C
434 | East | C
435 | East | C
436 | East | C
437 | East | C
438 | East | C
439 | East | C
440 | East | C
441 | East | C
442 | East | C
443 | East | C
444 | East | C
445 | East | C
446 | East | C
447 | East | C
448 | East | C
449 | East | C
450 | East | C
451 | East | C
452 | East | C
453 | East | C
454 | East | C
455 | East | C
456 | East | C
457 | East | C
458 | East | C
459 | East | C
460 | East | C
461 | East | C
462 | East | C
463 | East | C
464 | East | C
465 | East | C
466 | East | C
467 | East | C
468 | East | C
469 | East | C
470 | East | C
471 | East | C
472 | East | C
473 | East | C
474 | East | C
475 | East | C
476 | East | C
477 | East | C
478 | East | C
479 | East | C
480 | East | C
481 | East | C
482 | East | C
483 | East | C
484 | East | C
485 | East | C
486 | East | C
487 | East | C
488 | East | C
489 | East | C
490 | East | C
491 | East | C
492 | West | C
493 | West | C
494 | West | C
495 | West | C
496 | West | C
497 | West | C
498 | West | C
499 | West | C
500 | West | C
501 | West | C
502 | West | C
503 | West | C
504 | West | C
505 | West | C
506 | West | C
507 | West | C
508 | East | D
509 | East | D
510 | East | D
511 | East | D
512 | East | D
513 | East | D
514 | East | D
515 | East | D
516 | East | D
517 | East | D
518 | East | D
519 | East | D
520 | East | D
521 | East | D
522 | East | D
523 | East | D
524 | East | D
525 | East | D
526 | East | D
527 | East | D
528 | East | D
529 | East | D
530 | East | D
531 | East | D
532 | East | D
533 | East | D
534 | East | D
535 | East | D
536 | East | D
537 | East | D
538 | East | D
539 | East | D
540 | East | D
541 | East | D
542 | East | D
543 | East | D
544 | East | D
545 | East | D
546 | East | D
547 | East | D
548 | East | D
549 | East | D
550 | East | D
551 | East | D
552 | East | D
553 | East | D
554 | East | D
555 | East | D
556 | East | D
557 | East | D
558 | East | D
559 | East | D
560 | East | D
561 | East | D
562 | East | D
563 | East | D
564 | East | D
565 | East | D
566 | East | D
567 | East | D
568 | East | D
569 | East | D
570 | East | D
571 | East | D
572 | East | D
573 | East | D
574 | East | D
575 | East | D
576 | East | D
577 | East | D
578 | East | D
579 | East | D
580 | East | D
581 | East | D
582 | East | D
583 | West | D
584 | West | D
585 | West | D
586 | West | D
587 | West | D
588 | West | D
589 | West | D
590 | West | D
591 | West | D
592 | West | D
593 | West | D
594 | West | D
595 | West | D
596 | West | D
597 | West | D
598 | West | D
599 | West | D
600 | West | D
601 | West | D
602 | West | D
603 | West | D
604 | West | D
605 | West | D
606 | West | D
607 | West | D
608 | West | D
609 | West | D
610 | West | D
611 | West | D
612 | West | D
613 | West | D
614 | West | D