{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[{"$nulls":6},"Senate Seat Allocation for College of Engineering"]
[]
[null,null,"Faculty","Based on",null,"Based on",null,"Based on",null,"Recommended","Current"]
["School/","Faculty","Count","Total *",null,"Non-Alloc **",null,"Non-alloc Seats ***",null,"Seat","Seat"]
["Dept","Count","above min","Sen. Seats","=(School#/TOTAL)*14","Sen. Seats","=(School#/TOTAL)*4 + 1","& Fac Count > Min","=(SchoolDiff#/DiffTot)*4 + 1","Allocation","Allocation"]
["AAE",27,17,1.2115384615384615,1,1.3461538461538463,1,1.320754716981132,1,1,1]
["BME",10,0,0.4487179487179487,1,1.1282051282051282,1,1,1,1,0]
["CHE",22,12,0.9871794871794872,1,1.282051282051282,1,1.2264150943396226,1,1,1]
["CE/CEM",50,40,2.2435897435897436,2,1.641025641025641,2,1.7547169811320755,2,2,2]
["ECE",81,71,3.634615384615385,4,2.0384615384615383,2,2.339622641509434,2,3,3]
["ENE/IDE",13,3,0.5833333333333333,1,1.1666666666666667,1,1.0566037735849056,1,1,1]
["IE",25,15,1.1217948717948718,1,1.3205128205128205,1,1.2830188679245282,1,1,1]
["ME",53,43,2.378205128205128,2,1.6794871794871795,2,1.8113207547169812,2,2,3]
["MSE",20,10,0.8974358974358974,1,1.2564102564102564,1,1.1886792452830188,1,1,1]
["NE",11,1,0.4935897435897436,1,1.141025641025641,1,1.0188679245283019,1,1,1]
[]
["TOTAL",312,212,14,15,13.999999999999998,13,14,13,14,14]
[]
[null,null,null,"(Calculated)","(Rounded)","(Calculated)","(Rounded)","(Calculated)","(Rounded)"]
[]
["*","This calculation simply allocates all 14 engineering senate seats"]
[null,null,"in proportion to the # of voting faculty in each school"]
[]
["**","This calculation gives each school its guaranteed seat, then allocates the"]
[null,null,"remaining 4 seats in proportion to the # of voting faculty in each school"]
[]
["***","This calculation gives each school its guaranteed seat, then allocates the remaining 4 seats in"]
[null,null,"proportion to the # of voting faculty in each school above the lowest # of voting faculty in any school"]
[]
[]
[]
[]
[null,"Current"]
["School/","Seat"]
["Dept","Allocation","Names (term expiration)"]
["AAE",1,"Grandt (2007)"]
["BME",0]
["CHE",1,"Reklaitis (2009)"]
["CE/CEM",2,"Bobet (2008), Bowman (2007)"]
["ECE",3,"Bouman (2008), DeCarlo (2009), Zoltowski (2007)"]
["ENE/IDE",1,"Montgomery (2008)"]
["IE",1,"Yih (2009)"]
["ME",3,"Bolton (2007), Braun (2008), Chen (2007)"]
["MSE",1,"Blendell (2009)"]
["NE",1,"Hibiki (2007)"]
[]
["TOTAL",14]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}