Patent ID: 8793566

Claim:
A computer containing a system for automated processing for scheduling, managing and reporting usage of two or more training facilities by two or more grade levels “xl” of instruction, wherein xl is a level variable indicating grade level, comprising: a processor, the processor being configured to perform the steps of: entering on a spreadsheet on said computer single-cell, multiple-criteria data with on-screen instructions, followed by single-cell student level classification, retrieval and totaling on a Tally Sheet using the formula =IF(ISNUMBER(FIND(“xl-”,Summary!$J10))*(FIND(“SIM-”,Summary!$J10)),MID(Summary!$J10,4,3),0), and a formula (CW5=FALSE,VALUE(0); obtaining automatically summed totals by room, student level, and simulation classification, on a Summary Sheet utilizing formulas =Tally!$C178&″Hrs: ″&Tally!$J178, and =SUM(Tally!K5:K175,Tally!Y5:Y175,Tally!AM5:AM175,Tally!BA5:BA175,Tally!BO5:BO175,Tally!CC5:CC175,Tally!CQ5:CQ175,Tally!DE5:DE175,Tally!DS5:DS175); obtaining automatically summed totals by student level, and simulation classification on individualized student level sheets utilizing formula =SUM(Tally!K5:K175,Tally!Y5:Y175,Tally!AM5:AM175,Tally!BA5:BA175,Tally!BO5:BO175,Tally!CC5:CC175,Tally!CQ5:CQ175,Tally!DE5:DE175,Tally!DS5:DS175); and copying the structure of the Summary Sheet to the student level sheets by formula, =(Summary!A10), so that when the Summary sheet is updated all related sheets are updated, followed by rendering said Summary Sheet as output data in customized cells as outputs to a user, and further wherein said user manually applies at least one color to at least one cell.