{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Unit assignment"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Unit assignment","index":0,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Total units still to do",86]
["Total",{"$f":"SUM(B5:B32)","v":90.6},{"$f":"SUM(C5:C32)","v":86.000000000000028},{"$f":"SUM(D5:D32)","v":86},{"$f":"SUM(E5:E32)","v":86}]
["Lecturer","Units done","Helper","Units to do (Formulas)","Units to do (RoundToSum)"]
["Fair share",{"$f":"(B2+B1)/ROWS(B5:B32)","v":6.3071428571428569}]
["Lecturer 1",12,{"$f":"IF(B5>=B6,MAX(0,B$4-B5-SUMPRODUCT(--(C$4:C4=0),B$4:B4-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C4=0))+1)),\"Values in column B are not decreasing!\")","v":0},{"$f":"ROUND(SUM(C$4:C5),0)-SUM(D$4:D4)","v":0},{"$f":"IFERROR(RoundToSum(C5:C32,0),0)","v":0}]
["Lecturer 2",11,{"$f":"IF(B6>=B7,MAX(0,B$4-B6-SUMPRODUCT(--(C$4:C5=0),B$4:B5-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C5=0))+1)),\"Values in column B are not decreasing!\")","v":0},{"$f":"ROUND(SUM(C$4:C6),0)-SUM(D$4:D5)","v":0},0]
["Lecturer 3",9,{"$f":"IF(B7>=B8,MAX(0,B$4-B7-SUMPRODUCT(--(C$4:C6=0),B$4:B6-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C6=0))+1)),\"Values in column B are not decreasing!\")","v":0},{"$f":"ROUND(SUM(C$4:C7),0)-SUM(D$4:D6)","v":0},0]
["Lecturer 4",8,{"$f":"IF(B8>=B9,MAX(0,B$4-B8-SUMPRODUCT(--(C$4:C7=0),B$4:B7-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C7=0))+1)),\"Values in column B are not decreasing!\")","v":0},{"$f":"ROUND(SUM(C$4:C8),0)-SUM(D$4:D7)","v":0},0]
["Lecturer 5",8,{"$f":"IF(B9>=B10,MAX(0,B$4-B9-SUMPRODUCT(--(C$4:C8=0),B$4:B8-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C8=0))+1)),\"Values in column B are not decreasing!\")","v":0},{"$f":"ROUND(SUM(C$4:C9),0)-SUM(D$4:D8)","v":0},0]
["Lecturer 6",7,{"$f":"IF(B10>=B11,MAX(0,B$4-B10-SUMPRODUCT(--(C$4:C9=0),B$4:B9-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C9=0))+1)),\"Values in column B are not decreasing!\")","v":0},{"$f":"ROUND(SUM(C$4:C10),0)-SUM(D$4:D9)","v":0},0]
["Lecturer 7",7,{"$f":"IF(B11>=B12,MAX(0,B$4-B11-SUMPRODUCT(--(C$4:C10=0),B$4:B10-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C10=0))+1)),\"Values in column B are not decreasing!\")","v":0},{"$f":"ROUND(SUM(C$4:C11),0)-SUM(D$4:D10)","v":0},0]
["Lecturer 8",6,{"$f":"IF(B12>=B13,MAX(0,B$4-B12-SUMPRODUCT(--(C$4:C11=0),B$4:B11-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C11=0))+1)),\"Values in column B are not decreasing!\")","v":0},{"$f":"ROUND(SUM(C$4:C12),0)-SUM(D$4:D11)","v":0},0]
["Lecturer 9",5,{"$f":"IF(B13>=B14,MAX(0,B$4-B13-SUMPRODUCT(--(C$4:C12=0),B$4:B12-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C12=0))+1)),\"Values in column B are not decreasing!\")","v":0.42999999999999972},{"$f":"ROUND(SUM(C$4:C13),0)-SUM(D$4:D12)","v":0},1]
["Lecturer 10",3,{"$f":"IF(B14>=B15,MAX(0,B$4-B14-SUMPRODUCT(--(C$4:C13=0),B$4:B13-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C13=0))+1)),\"Values in column B are not decreasing!\")","v":2.4299999999999997},{"$f":"ROUND(SUM(C$4:C14),0)-SUM(D$4:D13)","v":3},3]
["Lecturer 11",3,{"$f":"IF(B15>=B16,MAX(0,B$4-B15-SUMPRODUCT(--(C$4:C14=0),B$4:B14-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C14=0))+1)),\"Values in column B are not decreasing!\")","v":2.4299999999999997},{"$f":"ROUND(SUM(C$4:C15),0)-SUM(D$4:D14)","v":2},3]
["Lecturer 12",2,{"$f":"IF(B16>=B17,MAX(0,B$4-B16-SUMPRODUCT(--(C$4:C15=0),B$4:B15-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C15=0))+1)),\"Values in column B are not decreasing!\")","v":3.4299999999999997},{"$f":"ROUND(SUM(C$4:C16),0)-SUM(D$4:D15)","v":4},4]
["Lecturer 13",2,{"$f":"IF(B17>=B18,MAX(0,B$4-B17-SUMPRODUCT(--(C$4:C16=0),B$4:B16-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C16=0))+1)),\"Values in column B are not decreasing!\")","v":3.4299999999999997},{"$f":"ROUND(SUM(C$4:C17),0)-SUM(D$4:D16)","v":3},4]
["Lecturer 14",2,{"$f":"IF(B18>=B19,MAX(0,B$4-B18-SUMPRODUCT(--(C$4:C17=0),B$4:B17-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C17=0))+1)),\"Values in column B are not decreasing!\")","v":3.4299999999999997},{"$f":"ROUND(SUM(C$4:C18),0)-SUM(D$4:D17)","v":4},4]
["Lecturer 15",2,{"$f":"IF(B19>=B20,MAX(0,B$4-B19-SUMPRODUCT(--(C$4:C18=0),B$4:B18-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C18=0))+1)),\"Values in column B are not decreasing!\")","v":3.4299999999999997},{"$f":"ROUND(SUM(C$4:C19),0)-SUM(D$4:D18)","v":3},4]
["Lecturer 16",2,{"$f":"IF(B20>=B21,MAX(0,B$4-B20-SUMPRODUCT(--(C$4:C19=0),B$4:B19-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C19=0))+1)),\"Values in column B are not decreasing!\")","v":3.4299999999999997},{"$f":"ROUND(SUM(C$4:C20),0)-SUM(D$4:D19)","v":3},4]
["Lecturer 17",1,{"$f":"IF(B21>=B22,MAX(0,B$4-B21-SUMPRODUCT(--(C$4:C20=0),B$4:B20-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C20=0))+1)),\"Values in column B are not decreasing!\")","v":4.43},{"$f":"ROUND(SUM(C$4:C21),0)-SUM(D$4:D20)","v":5},4]
["Lecturer 18",0.6,{"$f":"IF(B22>=B23,MAX(0,B$4-B22-SUMPRODUCT(--(C$4:C21=0),B$4:B21-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C21=0))+1)),\"Values in column B are not decreasing!\")","v":4.83},{"$f":"ROUND(SUM(C$4:C22),0)-SUM(D$4:D21)","v":5},5]
["Lecturer 19",0,{"$f":"IF(B23>=B24,MAX(0,B$4-B23-SUMPRODUCT(--(C$4:C22=0),B$4:B22-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C22=0))+1)),\"Values in column B are not decreasing!\")","v":5.43},{"$f":"ROUND(SUM(C$4:C23),0)-SUM(D$4:D22)","v":5},5]
["Lecturer 20",0,{"$f":"IF(B24>=B25,MAX(0,B$4-B24-SUMPRODUCT(--(C$4:C23=0),B$4:B23-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C23=0))+1)),\"Values in column B are not decreasing!\")","v":5.43},{"$f":"ROUND(SUM(C$4:C24),0)-SUM(D$4:D23)","v":6},5]
["Lecturer 21",0,{"$f":"IF(B25>=B26,MAX(0,B$4-B25-SUMPRODUCT(--(C$4:C24=0),B$4:B24-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C24=0))+1)),\"Values in column B are not decreasing!\")","v":5.43},{"$f":"ROUND(SUM(C$4:C25),0)-SUM(D$4:D24)","v":5},5]
["Lecturer 22",0,{"$f":"IF(B26>=B27,MAX(0,B$4-B26-SUMPRODUCT(--(C$4:C25=0),B$4:B25-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C25=0))+1)),\"Values in column B are not decreasing!\")","v":5.43},{"$f":"ROUND(SUM(C$4:C26),0)-SUM(D$4:D25)","v":5},5]
["Lecturer 23",0,{"$f":"IF(B27>=B28,MAX(0,B$4-B27-SUMPRODUCT(--(C$4:C26=0),B$4:B26-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C26=0))+1)),\"Values in column B are not decreasing!\")","v":5.43},{"$f":"ROUND(SUM(C$4:C27),0)-SUM(D$4:D26)","v":6},5]
["Lecturer 24",0,{"$f":"IF(B28>=B29,MAX(0,B$4-B28-SUMPRODUCT(--(C$4:C27=0),B$4:B27-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C27=0))+1)),\"Values in column B are not decreasing!\")","v":5.43},{"$f":"ROUND(SUM(C$4:C28),0)-SUM(D$4:D27)","v":5},5]
["Lecturer 25",0,{"$f":"IF(B29>=B30,MAX(0,B$4-B29-SUMPRODUCT(--(C$4:C28=0),B$4:B28-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C28=0))+1)),\"Values in column B are not decreasing!\")","v":5.43},{"$f":"ROUND(SUM(C$4:C29),0)-SUM(D$4:D28)","v":6},5]
["Lecturer 26",0,{"$f":"IF(B30>=B31,MAX(0,B$4-B30-SUMPRODUCT(--(C$4:C29=0),B$4:B29-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C29=0))+1)),\"Values in column B are not decreasing!\")","v":5.43},{"$f":"ROUND(SUM(C$4:C30),0)-SUM(D$4:D29)","v":5},5]
["Lecturer 27",0,{"$f":"IF(B31>=B32,MAX(0,B$4-B31-SUMPRODUCT(--(C$4:C30=0),B$4:B30-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C30=0))+1)),\"Values in column B are not decreasing!\")","v":5.43},{"$f":"ROUND(SUM(C$4:C31),0)-SUM(D$4:D30)","v":6},5]
["Lecturer 28",0,{"$f":"IF(B32>=B33,MAX(0,B$4-B32-SUMPRODUCT(--(C$4:C31=0),B$4:B31-B$4)/(ROWS(B$5:B$32)-SUMPRODUCT(--(C$4:C31=0))+1)),\"Values in column B are not decreasing!\")","v":5.43},{"$f":"ROUND(SUM(C$4:C32),0)-SUM(D$4:D31)","v":5},5]