Multi-Stage Random Sampling with VBA

[Ehsan1981]

Hello,

I have a dataset which includes following fields in it (I have attached a sample dataset.):

• ID: an integer number from 1 to 4368
• Facility: 4 values (RF4, RF6, UF4, and UF6)
• 2008_SV_FI: an integer value from 0 to 5
• 2008_SV_PDO: an integer value from 0 to 5
• 2008_MV_FI: an integer value from 0 to 5
• 2008_MV_PDO: an integer value from 0 to 5
• 2009_SV_FI: an integer value from 0 to 5
• 2009_SV_PDO: an integer value from 0 to 5
• 2009_MV_FI: an integer value from 0 to 5
• 2009_MV_PDO: an integer value from 0 to 5
• 2010_SV_FI: an integer value from 0 to 5
• 2010_SV_PDO: an integer value from 0 to 5
• 2010_MV_FI: an integer value from 0 to 5
• 2010_MV_PDO: an integer value from 0 to 5

I need to have a subset of each facility type (i.e., RF4, RF6, UF4, and UF6) which meets:

1. The minimum size for the subset is 30.
2. At least summation of 100 for the all following fields (i.e., 2008_SV_FI, 2008_SV_PDO, 2008_MV_FI, etc.).

I appreciate any comments/assistance.