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.:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Site[/TD]
[TD]per team[/TD]
[TD]black[/TD]
[TD]blue[/TD]
[TD]green[/TD]
[TD]boxes[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1 - 61 or 1 - 35[/TD]
[TD]1 - 24[/TD]
[TD]1 - 32[/TD]
[TD]1 - 36[/TD]
[TD]1 - 48[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4 (+ 576)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 385"]
<tbody>[TR]
[TD]Every team from 1 to 6 gets 61 sites (variable)[/TD]
[/TR]
[TR]
[TD]Every team from 7 to 12 gets 35 sites (variable)[/TD]
[/TR]
[TR]
[TD]Every site gets one bag of each color[/TD]
[/TR]
[TR]
[TD]Black bags are stacked in sets of 24[/TD]
[/TR]
[TR]
[TD]Blue bags are stacked in sets of 32[/TD]
[/TR]
[TR]
[TD]Green bags are stacked in sets of 36[/TD]
[/TR]
[TR]
[TD]Boxes per site are stacked in sets of 48[/TD]
[/TR]
</tbody>[/TABLE]

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.