{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Quota Changes","17 Camels"],"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":"Quota Changes","index":0,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Name","Quota old","As Fraction","Quota old normed","As Fraction","Quota new","As Fraction","Quota new normed","As Fraction","Largest Denominator","Same Denominator","Change","As Fraction","Largest Denominator","Same Denominator"]
["Total",{"$f":"SUM(B3:B12)","v":1},{"$f":"IF(B2=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B2,999,0.0000000001)))","v":"1/1"},{"$f":"SUM(D3:D12)","v":1},{"$f":"IF(D2=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D2,999,0.0000000001)))","v":"1/1"},{"$f":"SUM(F3:F12)","v":0.66666666666666674},{"$f":"IF(F2=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F2,999,0.0000000001)))","v":"2/3"},{"$f":"SUM(H3:H12)","v":0.99999999999999978},{"$f":"IF(H2=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H2,999,0.0000000001)))","v":"1/1"},{"$f":"MAX(J3:J12)","v":6},{"$f":"IF(H2:H12<>0,ROUND(H2:H12*J2,0) & \"/\" & J2,\"\")","v":"6/6"},{"$f":"H2:H12-D2:D12","v":0},{"$f":"IF(L2=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L2,999,0.0000000001)))","v":""},{"$f":"MAX(N3:N12)","v":6},{"$f":"IF(L2:L12<>0,ROUND(L2:L12*N2,0) & \"/\" & N2,\"\")","v":""}]
["Miller",{"$f":"1/3","v":0.33333333333333331},{"$f":"IF(B3=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B3,999,0.0000000001)))","v":"1/3"},{"$f":"B3:B12/B2","v":0.33333333333333331},{"$f":"IF(D3=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D3,999,0.0000000001)))","v":"1/3"},{"$f":"1/3","v":0.33333333333333331},{"$f":"IF(F3=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F3,999,0.0000000001)))","v":"1/3"},{"$f":"F3:F12/F2","v":0.49999999999999989},{"$f":"IF(H3=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H3,999,0.0000000001)))","v":"1/2"},{"$f":"VALUE(\"0\" & RIGHT(I3:I12,LEN(I3:I12)-IFERROR(SEARCH(\"/\",I3:I12),0)))","v":2},"3/6",0.16666666666666657,{"$f":"IF(L3=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L3,999,0.0000000001)))","v":"1/6"},{"$f":"VALUE(\"0\" & RIGHT(M3:M12,LEN(M3:M12)-IFERROR(SEARCH(\"/\",M3:M12),0)))","v":6},"1/6"]
["Smith",{"$f":"1/3","v":0.33333333333333331},{"$f":"IF(B4=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B4,999,0.0000000001)))","v":"1/3"},0.33333333333333331,{"$f":"IF(D4=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D4,999,0.0000000001)))","v":"1/3"},null,{"$f":"IF(F4=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F4,999,0.0000000001)))","v":""},0,{"$f":"IF(H4=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H4,999,0.0000000001)))","v":""},0,"",-0.33333333333333331,{"$f":"IF(L4=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L4,999,0.0000000001)))","v":"-1/3"},3,"-2/6"]
["Schulz",{"$f":"1/3","v":0.33333333333333331},{"$f":"IF(B5=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B5,999,0.0000000001)))","v":"1/3"},0.33333333333333331,{"$f":"IF(D5=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D5,999,0.0000000001)))","v":"1/3"},null,{"$f":"IF(F5=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F5,999,0.0000000001)))","v":""},0,{"$f":"IF(H5=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H5,999,0.0000000001)))","v":""},0,"",-0.33333333333333331,{"$f":"IF(L5=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L5,999,0.0000000001)))","v":"-1/3"},3,"-2/6"]
["Schulz Widow",null,{"$f":"IF(B6=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B6,999,0.0000000001)))","v":""},0,{"$f":"IF(D6=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D6,999,0.0000000001)))","v":""},{"$f":"1/3 * 2/3","v":0.22222222222222221},{"$f":"IF(F6=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F6,999,0.0000000001)))","v":"2/9"},0.33333333333333326,{"$f":"IF(H6=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H6,999,0.0000000001)))","v":"1/3"},3,"2/6",0.33333333333333326,{"$f":"IF(L6=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L6,999,0.0000000001)))","v":"1/3"},3,"2/6"]
["Schulz  Child",null,{"$f":"IF(B7=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B7,999,0.0000000001)))","v":""},0,{"$f":"IF(D7=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D7,999,0.0000000001)))","v":""},{"$f":"1/3 * 1/3","v":0.1111111111111111},{"$f":"IF(F7=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F7,999,0.0000000001)))","v":"1/9"},0.16666666666666663,{"$f":"IF(H7=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H7,999,0.0000000001)))","v":"1/6"},6,"1/6",0.16666666666666663,{"$f":"IF(L7=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L7,999,0.0000000001)))","v":"1/6"},6,"1/6"]
[null,null,{"$f":"IF(B8=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B8,999,0.0000000001)))","v":""},0,{"$f":"IF(D8=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D8,999,0.0000000001)))","v":""},null,{"$f":"IF(F8=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F8,999,0.0000000001)))","v":""},0,{"$f":"IF(H8=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H8,999,0.0000000001)))","v":""},0,"",0,{"$f":"IF(L8=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L8,999,0.0000000001)))","v":""},0,""]
[null,null,{"$f":"IF(B9=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B9,999,0.0000000001)))","v":""},0,{"$f":"IF(D9=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D9,999,0.0000000001)))","v":""},null,{"$f":"IF(F9=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F9,999,0.0000000001)))","v":""},0,{"$f":"IF(H9=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H9,999,0.0000000001)))","v":""},0,"",0,{"$f":"IF(L9=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L9,999,0.0000000001)))","v":""},0,""]
[null,null,{"$f":"IF(B10=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B10,999,0.0000000001)))","v":""},0,{"$f":"IF(D10=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D10,999,0.0000000001)))","v":""},null,{"$f":"IF(F10=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F10,999,0.0000000001)))","v":""},0,{"$f":"IF(H10=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H10,999,0.0000000001)))","v":""},0,"",0,{"$f":"IF(L10=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L10,999,0.0000000001)))","v":""},0,""]
[null,null,{"$f":"IF(B11=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B11,999,0.0000000001)))","v":""},0,{"$f":"IF(D11=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D11,999,0.0000000001)))","v":""},null,{"$f":"IF(F11=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F11,999,0.0000000001)))","v":""},0,{"$f":"IF(H11=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H11,999,0.0000000001)))","v":""},0,"",0,{"$f":"IF(L11=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L11,999,0.0000000001)))","v":""},0,""]
[null,null,{"$f":"IF(B12=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B12,999,0.0000000001)))","v":""},0,{"$f":"IF(D12=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D12,999,0.0000000001)))","v":""},null,{"$f":"IF(F12=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F12,999,0.0000000001)))","v":""},0,{"$f":"IF(H12=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H12,999,0.0000000001)))","v":""},0,"",0,{"$f":"IF(L12=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L12,999,0.0000000001)))","v":""},0,""]
[]
["Note:","Enter values into these fields only!"]

{"sheet":"17 Camels","index":1,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,12,8]]}
["Name","Quota old","As Fraction","Quota old normed","As Fraction","Quota new","As Fraction","Quota new normed","As Fraction","Largest Denominator","Same Denominator","Change","As Fraction","Largest Denominator","Same Denominator"]
["Total",{"$f":"SUM(B3:B6)","v":0.94444444444444442},{"$f":"IF(B2=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B2,999,0.0000000001)))","v":"17/18"},{"$f":"SUM(D3:D6)","v":1},{"$f":"IF(D2=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D2,999,0.0000000001)))","v":"1/1"},{"$f":"SUM(F3:F6)","v":1},{"$f":"IF(F2=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F2,999,0.0000000001)))","v":"1/1"},{"$f":"SUM(H3:H6)","v":1},{"$f":"IF(H2=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H2,999,0.0000000001)))","v":"1/1"},{"$f":"MAX(J3:J6)","v":18},{"$f":"IF(H2:H6<>0,ROUND(H2:H6*J2,0) & \"/\" & J2,\"\")","v":"18/18"},{"$f":"H2:H6-D2:D6","v":0},{"$f":"IF(L2=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L2,999,0.0000000001)))","v":""},{"$f":"MAX(N3:N6)","v":153},{"$f":"IF(L2:L6<>0,ROUND(L2:L6*N2,0) & \"/\" & N2,\"\")","v":""}]
["Eldest son",{"$f":"1/2","v":0.5},{"$f":"IF(B3=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B3,999,0.0000000001)))","v":"1/2"},{"$f":"B3:B6/B2","v":0.52941176470588236},{"$f":"IF(D3=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D3,999,0.0000000001)))","v":"9/17"},{"$f":"1/2","v":0.5},{"$f":"IF(F3=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F3,999,0.0000000001)))","v":"1/2"},{"$f":"F3:F6/F2","v":0.5},{"$f":"IF(H3=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H3,999,0.0000000001)))","v":"1/2"},{"$f":"VALUE(\"0\" & RIGHT(I3:I6,LEN(I3:I6)-IFERROR(SEARCH(\"/\",I3:I6),0)))","v":2},"9/18",-2.9411764705882359E-2,{"$f":"IF(L3=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L3,999,0.0000000001)))","v":"-1/34"},{"$f":"VALUE(\"0\" & RIGHT(M3:M6,LEN(M3:M6)-IFERROR(SEARCH(\"/\",M3:M6),0)))","v":34},"-5/153"]
["Second son",{"$f":"1/3","v":0.33333333333333331},{"$f":"IF(B4=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B4,999,0.0000000001)))","v":"1/3"},0.3529411764705882,{"$f":"IF(D4=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D4,999,0.0000000001)))","v":"6/17"},{"$f":"1/3","v":0.33333333333333331},{"$f":"IF(F4=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F4,999,0.0000000001)))","v":"1/3"},0.33333333333333331,{"$f":"IF(H4=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H4,999,0.0000000001)))","v":"1/3"},3,"6/18",-1.9607843137254888E-2,{"$f":"IF(L4=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L4,999,0.0000000001)))","v":"-1/51"},51,"-3/153"]
["Youngest son",{"$f":"1/9","v":0.1111111111111111},{"$f":"IF(B5=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B5,999,0.0000000001)))","v":"1/9"},0.11764705882352941,{"$f":"IF(D5=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D5,999,0.0000000001)))","v":"2/17"},{"$f":"1/9","v":0.1111111111111111},{"$f":"IF(F5=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F5,999,0.0000000001)))","v":"1/9"},0.1111111111111111,{"$f":"IF(H5=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H5,999,0.0000000001)))","v":"1/9"},9,"2/18",-6.5359477124183052E-3,{"$f":"IF(L5=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L5,999,0.0000000001)))","v":"-1/153"},153,"-1/153"]
["Wise man",null,{"$f":"IF(B6=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(B6,999,0.0000000001)))","v":""},0,{"$f":"IF(D6=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(D6,999,0.0000000001)))","v":""},{"$f":"1/18","v":5.5555555555555552E-2},{"$f":"IF(F6=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(F6,999,0.0000000001)))","v":"1/18"},5.5555555555555552E-2,{"$f":"IF(H6=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(H6,999,0.0000000001)))","v":"1/18"},18,"1/18",5.5555555555555552E-2,{"$f":"IF(L6=0,\"\",_xlfn.TEXTJOIN(\"/\",TRUE,sbNRN(L6,999,0.0000000001)))","v":"1/18"},18,"9/153"]
[]
["Note:","Enter values into these fields only!"]
["A father left 17 camels to his three sons and, according to the will, the eldest son should be given a half of all camels, the middle son the one-third part and the youngest son the one-ninth. This is hard to do, but a wise man helped the sons: he added his own camel, the oldest son took 18/2=9 camels, the second son took 18/3=6 camels, the third son 18/9=2 camels and the wise man took his own camel and went away."]