Data Extraction

[gxporras]

I have a spreadsheet that contains a list of work site numbers, and I want to extract the beginning and end of a range of sites for sets of 16, 24, 32, 35, and 61. Also, I have a column with numbers of boxes for each site and I need to count the number of boxes <=48 and return the beginning and end of the range, then continue with the next range of site numbers for the next count of <=48, and so on. e.g.:

Site	per team	black	blue	green	boxes
1	1 - 61 or 1 - 35	1 - 24	1 - 32	1 - 36	1 - 48
2
3
4 (+ 576)

<tbody>
</tbody>

Every team from 1 to 6 gets 61 sites (variable)

Every team from 7 to 12 gets 35 sites (variable)

Every site gets one bag of each color

Black bags are stacked in sets of 24

Blue bags are stacked in sets of 32

Green bags are stacked in sets of 36

Boxes per site are stacked in sets of 48

<tbody>
</tbody>

The results should be:

Range 1 - 61
Range 62 - 122
Range 123 - 184 and so on

Range 1 - 24
Range 25 - 48
Range 49 - 72 and so on for each set

Thanks for any leads you can provide.