Sunday, November 27, 2016

yogi_Populate Required Number of Classes Given Number and Names Of Students And Max Number Of Students Per Class

Google Spreadsheet   Post  #2087
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-27-2016
question by: Andre LaFlamme:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/XGGHbo0tmHM;context-place=mydiscussions
calculating number of classes - please help
I have individual students enrolling for classes with a minimum of 2 and maximum of 8.  As such, 2 or more to 8 is 1 class.  8 is 1 class.  9 is 2 classes of less than 8.  37 students is 4 classes of 8 and 1 class of less than 8.  And so on.  So I will have a cell for individual students, a cell of classes of 8 and a cell for classes of 2 of more and less than 8.  Can someone suggest and efficient way/arrangement of cells and formulas to for me to calculate this?