{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["About","Model","Analysis","Control"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":86,"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":"About","index":0,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["About"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"www.solvermax.com"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Key"]
[null,null,null,null,null,null,null,null,null,null,"Data"]
[null,null,null,null,null,null,null,null,null,null,"Constant"]
[null,null,null,null,null,null,null,null,null,null,"Highlight"]
[null,null,null,null,null,null,null,null,null,null,"Error"]
[null,null,null,null,null,null,null,null,null,null,"Solver variable"]
[null,null,null,null,null,null,null,null,null,null,"Pasted values"]
[]
[null,null,null,null,null,null,null,null,null,null,"Version"]
[null,null,null,null,null,null,null,null,null,null,"v 1.1"]
[null,null,null,null,null,null,null,null,null,null,"2021-11-19"]

{"sheet":"Model","index":1,"n_rows":77,"n_cols":22,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Team allocation, given multiple attributes"]
[]
["Assumptions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Description"]
[]
[null,"Attributes",null,null,null,null,null,"Team"]
[null,"Experience","Qualifications","Tenure","Overall",null,null,1,2,3,4,5,"Total"]
["Weight",5,2,1,10,null,"Team size",6,6,6,6,6,{"$f":"SUM(H7:L7)","v":30}]
[]
["Scores","Attributes"]
["Person",{"$f":"B6","v":"Experience"},{"$f":"C6","v":"Qualifications"},{"$f":"D6","v":"Tenure"},{"$f":"E6","v":"Overall"}]
["Aila",48,33,41,{"$f":"SUM(B11:D11)","v":122}]
["Allister",90,46,11,147]
["Arlie",40,36,62,138]
["Babette",98,19,45,162]
["Caresa",38,43,33,114]
["Chalmers",93,43,59,195]
["Charin",28,42,99,169]
["Elden",78,19,66,163]
["Gian",37,34,86,157]
["Heloise",30,95,45,170]
["Job",10,81,51,142]
["Kaitlin",67,42,26,135]
["Katalin",75,19,94,188]
["Lorain",79,3,35,117]
["Lucine",31,50,86,167]
["Mari",26,14,74,114]
["Marilin",93,7,21,121]
["Maurise",70,22,76,168]
["Mella",80,72,98,250]
["Nessa",3,90,31,124]
["Rosaleen",18,47,56,121]
["Smith",76,65,79,220]
["Stearne",16,59,3,78]
["Tab",64,33,23,120]
["Vevay",35,98,29,162]
["Vittoria",31,77,86,194]
["Washington",31,42,58,131]
["Wenona",48,77,13,138]
["Wes",73,15,10,98]
["Zebadiah",48,33,52,133]
["Total",{"$f":"SUM(B11:B40)","v":1554},{"$f":"SUM(C11:C40)","v":1356},{"$f":"SUM(D11:D40)","v":1548},{"$f":"SUM(E11:E40)","v":4458}]
[]
["Variables",null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermediate calculations",null,null,null,null,null,"Result"]
[]
[null,"Team's skills",null,null,null,null,"Allocation","Team",null,null,null,null,null,null,"Score","Attributes",null,null,null,null,"Objective"]
["Bound",{"$f":"B6","v":"Experience"},{"$f":"C6","v":"Qualifications"},{"$f":"D6","v":"Tenure"},{"$f":"E6","v":"Overall"},null,{"$f":"A10","v":"Person"},1,2,3,4,5,"Total",null,"Team",{"$f":"B6","v":"Experience"},{"$f":"C6","v":"Qualifications"},{"$f":"D6","v":"Tenure"},{"$f":"E6","v":"Overall"},null,"Total",{"$f":"SUM(B50:E50)","v":310}]
["Min",300,250,285,887,null,"Aila",0,0,1,0,0,{"$f":"SUM(H47:L47)","v":1},null,1,{"$f":"SUMPRODUCT(B$11:B$40,$H$47:$H$76)","v":300},{"$f":"SUMPRODUCT(C$11:C$40,$H$47:$H$76)","v":257},{"$f":"SUMPRODUCT(D$11:D$40,$H$47:$H$76)","v":330},{"$f":"SUM(P47:R47)","v":887}]
["Max",319,290,330,896,null,"Allister",0,0,0,1,0,1,null,2,{"$f":"SUMPRODUCT(B$11:B$40,$I$47:$I$76)","v":310},{"$f":"SUMPRODUCT(C$11:C$40,$I$47:$I$76)","v":250},{"$f":"SUMPRODUCT(D$11:D$40,$I$47:$I$76)","v":327},{"$f":"SUM(P48:R48)","v":887}]
["Range",{"$f":"B48-B47","v":19},{"$f":"C48-C47","v":40},{"$f":"D48-D47","v":45},{"$f":"E48-E47","v":9},null,"Arlie",0,0,0,0,1,1,null,3,{"$f":"SUMPRODUCT(B$11:B$40,$J$47:$J$76)","v":319},{"$f":"SUMPRODUCT(C$11:C$40,$J$47:$J$76)","v":290},{"$f":"SUMPRODUCT(D$11:D$40,$J$47:$J$76)","v":285},{"$f":"SUM(P49:R49)","v":894}]
["Weighted",{"$f":"B49*B7","v":95},{"$f":"C49*C7","v":80},45,90,null,"Babette",1,0,0,0,0,1,null,4,{"$f":"SUMPRODUCT(B$11:B$40,$K$47:$K$76)","v":309},{"$f":"SUMPRODUCT(C$11:C$40,$K$47:$K$76)","v":286},{"$f":"SUMPRODUCT(D$11:D$40,$K$47:$K$76)","v":301},{"$f":"SUM(P50:R50)","v":896}]
[null,null,null,null,null,null,"Caresa",0,0,0,0,1,1,null,5,{"$f":"SUMPRODUCT(B$11:B$40,$L$47:$L$76)","v":316},{"$f":"SUMPRODUCT(C$11:C$40,$L$47:$L$76)","v":273},{"$f":"SUMPRODUCT(D$11:D$40,$L$47:$L$76)","v":305},{"$f":"SUM(P51:R51)","v":894}]
[null,null,null,null,null,null,"Chalmers",0,0,0,0,1,1]
[null,null,null,null,null,null,"Charin",0,1,0,0,0,1,null,"Score min","Attributes"]
[null,null,null,null,null,null,"Elden",0,0,0,1,0,1,null,{"$f":"O46","v":"Team"},{"$f":"B6","v":"Experience"},{"$f":"C6","v":"Qualifications"},{"$f":"D6","v":"Tenure"},{"$f":"E6","v":"Overall"}]
[null,null,null,null,null,null,"Gian",1,0,0,0,0,1,null,1,{"$f":"B$47","v":300},250,285,887]
[null,null,null,null,null,null,"Heloise",0,1,0,0,0,1,null,2,300,250,285,887]
[null,null,null,null,null,null,"Job",0,1,0,0,0,1,null,3,300,250,285,887]
[null,null,null,null,null,null,"Kaitlin",0,0,0,0,1,1,null,4,300,250,285,887]
[null,null,null,null,null,null,"Katalin",0,0,0,0,1,1,null,5,300,250,285,{"$f":"E$47","v":887}]
[null,null,null,null,null,null,"Lorain",0,1,0,0,0,1]
[null,null,null,null,null,null,"Lucine",0,0,0,1,0,1,null,"Score max","Attributes"]
[null,null,null,null,null,null,"Mari",1,0,0,0,0,1,null,{"$f":"O46","v":"Team"},{"$f":"B6","v":"Experience"},{"$f":"C6","v":"Qualifications"},{"$f":"D6","v":"Tenure"},{"$f":"E6","v":"Overall"}]
[null,null,null,null,null,null,"Marilin",0,1,0,0,0,1,null,1,{"$f":"B$48","v":319},290,330,896]
[null,null,null,null,null,null,"Maurise",0,1,0,0,0,1,null,2,319,290,330,896]
[null,null,null,null,null,null,"Mella",0,0,1,0,0,1,null,3,319,290,330,896]
[null,null,null,null,null,null,"Nessa",0,0,0,0,1,1,null,4,319,290,330,896]
[null,null,null,null,null,null,"Rosaleen",0,0,0,1,0,1,null,5,319,290,330,896]
[null,null,null,null,null,null,"Smith",0,0,0,1,0,1]
[null,null,null,null,null,null,"Stearne",0,0,0,1,0,1]
[null,null,null,null,null,null,"Tab",0,0,1,0,0,1]
[null,null,null,null,null,null,"Vevay",1,0,0,0,0,1]
[null,null,null,null,null,null,"Vittoria",1,0,0,0,0,1]
[null,null,null,null,null,null,"Washington",0,0,1,0,0,1]
[null,null,null,null,null,null,"Wenona",0,0,1,0,0,1]
[null,null,null,null,null,null,"Wes",1,0,0,0,0,1]
[null,null,null,null,null,null,"Zebadiah",0,0,1,0,0,1]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H47:H76)","v":6},6,6,6,6,30]

{"sheet":"Analysis","index":2,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Supporting analyses"]
[]
["Description"]
[]
[]
[]
[]
["Results"]

{"sheet":"Control","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Workbook control"]
[]
["Constants",null,null,"Notes"]
["Boolean"]
[true]
[false]
[]
["Derived values"]