{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Values","WorkSheet","Answers","Working"],"not_rendered":{"charts":0,"images":1,"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":"Values","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[10,2,10,4],[12,2,12,6],[12,8,16,9],[14,2,17,7],[1,2,1,6],[3,2,4,7],[5,2,5,4],[7,2,8,7]]}
[null,null,null,null,"DIVISION - By 10's"]
[null,null,"INSTRUCTIONS"]
[]
[null,"Step 1","Enter the number digits to be used in the divisor for this sheet. (Either 2 or 3, use 1 for mixed)"]
[]
[null,null,"Digits in Divisor"]
[]
[null,"Step 2","Enter the number digits to be used in the quotient for this sheet. (Either 2 or 3, use 1 for mixed)"]
[]
[]
[null,null,"Digits in Quotient"]
[]
[null,"Step 3","Click on WorkSheet tab below.",null,null,null,null,null,"PRESS F9 for NEW WorkSheet"]
[]
[null,"Note","If you hold down shift then click on the WorkSheet tab and the Answers tab, you will be able to print both the WorkSheet and the solutions."]
[]
[]
[]
[]
[]
[null,null,"NOTES"]
[null,null,"* These questions have been answered in the division algorithm format."]
[null,null,"* The answers show all working steps and are formatted correctly."]
[null,null,"* Students may need to record more of their working to answer the questions efficiently."]
[null,null,"* Each Worksheet has 20 random generated questions."]

{"sheet":"WorkSheet","index":1,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"DIVISION"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Worksheet \",Working!C1,Working!B1)","v":"Worksheet LDW-974"}]
["Evaluate the following;"]
[]
[{"$f":"Working!C4","v":"1)"},{"$f":"Working!E4","v":52},{"$f":"Working!I4","v":12792},null,{"$f":"Working!C9","v":"6)"},{"$f":"Working!E9","v":910},{"$f":"Working!I9","v":52780},null,{"$f":"Working!C14","v":"11)"},{"$f":"Working!E14","v":63},{"$f":"Working!I14","v":5292},null,{"$f":"Working!C19","v":"16)"},{"$f":"Working!E19","v":790},{"$f":"Working!I19","v":492960}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Working!C5","v":"2)"},{"$f":"Working!E5","v":271},{"$f":"Working!I5","v":10840},null,{"$f":"Working!C10","v":"7)"},{"$f":"Working!E10","v":883},{"$f":"Working!I10","v":204856},null,{"$f":"Working!C15","v":"12)"},{"$f":"Working!E15","v":304},{"$f":"Working!I15","v":135584},null,{"$f":"Working!C20","v":"17)"},{"$f":"Working!E20","v":96},{"$f":"Working!I20","v":35424}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Working!C6","v":"3)"},{"$f":"Working!E6","v":680},{"$f":"Working!I6","v":425000},null,{"$f":"Working!C11","v":"8)"},{"$f":"Working!E11","v":920},{"$f":"Working!I11","v":342240},null,{"$f":"Working!C16","v":"13)"},{"$f":"Working!E16","v":108},{"$f":"Working!I16","v":8640},null,{"$f":"Working!C21","v":"18)"},{"$f":"Working!E21","v":90},{"$f":"Working!I21","v":3240}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Working!C7","v":"4)"},{"$f":"Working!E7","v":61},{"$f":"Working!I7","v":45750},null,{"$f":"Working!C12","v":"9)"},{"$f":"Working!E12","v":371},{"$f":"Working!I12","v":315350},null,{"$f":"Working!C17","v":"14)"},{"$f":"Working!E17","v":22},{"$f":"Working!I17","v":770},null,{"$f":"Working!C22","v":"19)"},{"$f":"Working!E22","v":225},{"$f":"Working!I22","v":85050}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Working!C8","v":"5)"},{"$f":"Working!E8","v":25},{"$f":"Working!I8","v":2325},null,{"$f":"Working!C13","v":"10)"},{"$f":"Working!E13","v":59},{"$f":"Working!I13","v":39294},null,{"$f":"Working!C18","v":"15)"},{"$f":"Working!E18","v":64},{"$f":"Working!I18","v":1088},null,{"$f":"Working!C23","v":"20)"},{"$f":"Working!E23","v":84},{"$f":"Working!I23","v":35448}]

{"sheet":"Answers","index":2,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"DIVISION"]
[null,null,null,null,null,null,null,"ANSWERS",null,null,null,null,{"$f":"CONCATENATE(\"Worksheet \",Working!C1,Working!B1)","v":"Worksheet LDW-974"}]
["Evaluate the following;"]
[null,null,{"$f":"Working!N4","v":"    246"},null,null,null,{"$f":"Working!N9","v":"      58"},null,null,null,{"$f":"Working!N14","v":"    84"},null,null,null,{"$f":"Working!N19","v":"      624"}]
[{"$f":"Working!C4","v":"1)"},{"$f":"Working!E4","v":52},{"$f":"Working!I4","v":12792},null,{"$f":"Working!C9","v":"6)"},{"$f":"Working!E9","v":910},{"$f":"Working!I9","v":52780},null,{"$f":"Working!C14","v":"11)"},{"$f":"Working!E14","v":63},{"$f":"Working!I14","v":5292},null,{"$f":"Working!C19","v":"16)"},{"$f":"Working!E19","v":790},{"$f":"Working!I19","v":492960}]
[null,null,{"$f":"Working!V4","v":"104"},null,null,null,{"$f":"Working!V9","v":"4550"},null,null,null,{"$f":"Working!V14","v":"504"},null,null,null,{"$f":"Working!V19","v":"4740"}]
[null,null,{"$f":"Working!AJ4","v":"  239"},null,null,null,{"$f":"Working!AJ9","v":"  7280"},null,null,null,{"$f":"Working!AJ14","v":"  252"},null,null,null,{"$f":"Working!AJ19","v":"  1896"}]
[null,null,{"$f":"Working!AQ4","v":"  208"},null,null,null,{"$f":"Working!AQ9","v":"  7280"},null,null,null,{"$f":"Working!AQ14","v":"  252"},null,null,null,{"$f":"Working!AQ19","v":"  1580"}]
[null,null,{"$f":"Working!AZ4","v":"    312"},null,null,null,{"$f":"Working!AZ9","v":"        0"},null,null,null,{"$f":"Working!AZ14","v":"      0"},null,null,null,{"$f":"Working!AZ19","v":"    3160"}]
[null,null,{"$f":"Working!BC4","v":"    312"},null,null,null,{"$f":"Working!BC9","v":""},null,null,null,{"$f":"Working!BC14","v":""},null,null,null,{"$f":"Working!BC19","v":"    3160"}]
[]
[null,null,{"$f":"Working!N5","v":"      40"},null,null,null,{"$f":"Working!N10","v":"      232"},null,null,null,{"$f":"Working!N15","v":"      446"},null,null,null,{"$f":"Working!N20","v":"    369"}]
[{"$f":"Working!C5","v":"2)"},{"$f":"Working!E5","v":271},{"$f":"Working!I5","v":10840},null,{"$f":"Working!C10","v":"7)"},{"$f":"Working!E10","v":883},{"$f":"Working!I10","v":204856},null,{"$f":"Working!C15","v":"12)"},{"$f":"Working!E15","v":304},{"$f":"Working!I15","v":135584},null,{"$f":"Working!C20","v":"17)"},{"$f":"Working!E20","v":96},{"$f":"Working!I20","v":35424}]
[null,null,{"$f":"Working!V5","v":"1084"},null,null,null,{"$f":"Working!V10","v":"1766"},null,null,null,{"$f":"Working!V15","v":"1216"},null,null,null,{"$f":"Working!V20","v":"288"}]
[null,null,{"$f":"Working!AD5","v":"      00"},null,null,null,{"$f":"Working!AJ10","v":"  2825"},null,null,null,{"$f":"Working!AJ15","v":"  1398"},null,null,null,{"$f":"Working!AJ20","v":"  662"}]
[null,null,{"$f":"Working!AQ5","v":""},null,null,null,{"$f":"Working!AQ10","v":"  2649"},null,null,null,{"$f":"Working!AQ15","v":"  1216"},null,null,null,{"$f":"Working!AQ20","v":"  576"}]
[null,null,{"$f":"Working!AZ5","v":""},null,null,null,{"$f":"Working!AZ10","v":"    1766"},null,null,null,{"$f":"Working!AZ15","v":"    1824"},null,null,null,{"$f":"Working!AZ20","v":"    864"}]
[null,null,{"$f":"Working!BC5","v":""},null,null,null,{"$f":"Working!BC10","v":"    1766"},null,null,null,{"$f":"Working!BC15","v":"    1824"},null,null,null,{"$f":"Working!BC20","v":"    864"}]
[]
[null,null,{"$f":"Working!N6","v":"      625"},null,null,null,{"$f":"Working!N11","v":"      372"},null,null,null,{"$f":"Working!N16","v":"    80"},null,null,null,{"$f":"Working!N21","v":"    36"}]
[{"$f":"Working!C6","v":"3)"},{"$f":"Working!E6","v":680},{"$f":"Working!I6","v":425000},null,{"$f":"Working!C11","v":"8)"},{"$f":"Working!E11","v":920},{"$f":"Working!I11","v":342240},null,{"$f":"Working!C16","v":"13)"},{"$f":"Working!E16","v":108},{"$f":"Working!I16","v":8640},null,{"$f":"Working!C21","v":"18)"},{"$f":"Working!E21","v":90},{"$f":"Working!I21","v":3240}]
[null,null,{"$f":"Working!V6","v":"4080"},null,null,null,{"$f":"Working!V11","v":"2760"},null,null,null,{"$f":"Working!V16","v":"864"},null,null,null,{"$f":"Working!V21","v":"270"}]
[null,null,{"$f":"Working!AD6","v":"  1700"},null,null,null,{"$f":"Working!AJ11","v":"  6624"},null,null,null,{"$f":"Working!AJ16","v":"    00"},null,null,null,{"$f":"Working!AJ21","v":"  540"}]
[null,null,{"$f":"Working!AQ6","v":"  1360"},null,null,null,{"$f":"Working!AQ11","v":"  6440"},null,null,null,{"$f":"Working!AQ16","v":""},null,null,null,{"$f":"Working!AQ21","v":"  540"}]
[null,null,{"$f":"Working!AZ6","v":"    3400"},null,null,null,{"$f":"Working!AZ11","v":"    1840"},null,null,null,{"$f":"Working!AZ16","v":""},null,null,null,{"$f":"Working!AZ21","v":"      0"}]
[null,null,{"$f":"Working!BC6","v":"    3400"},null,null,null,{"$f":"Working!BC11","v":"    1840"},null,null,null,{"$f":"Working!BC16","v":""},null,null,null,{"$f":"Working!BC21","v":""}]
[]
[null,null,{"$f":"Working!N7","v":"    750"},null,null,null,{"$f":"Working!N12","v":"      850"},null,null,null,{"$f":"Working!N17","v":"   35"},null,null,null,{"$f":"Working!N22","v":"    378"}]
[{"$f":"Working!C7","v":"4)"},{"$f":"Working!E7","v":61},{"$f":"Working!I7","v":45750},null,{"$f":"Working!C12","v":"9)"},{"$f":"Working!E12","v":371},{"$f":"Working!I12","v":315350},null,{"$f":"Working!C17","v":"14)"},{"$f":"Working!E17","v":22},{"$f":"Working!I17","v":770},null,{"$f":"Working!C22","v":"19)"},{"$f":"Working!E22","v":225},{"$f":"Working!I22","v":85050}]
[null,null,{"$f":"Working!V7","v":"427"},null,null,null,{"$f":"Working!V12","v":"2968"},null,null,null,{"$f":"Working!V17","v":"66"},null,null,null,{"$f":"Working!V22","v":"675"}]
[null,null,{"$f":"Working!AD7","v":"  305"},null,null,null,{"$f":"Working!AJ12","v":"  1855"},null,null,null,{"$f":"Working!AJ17","v":"110"},null,null,null,{"$f":"Working!AJ22","v":"1755"}]
[null,null,{"$f":"Working!AQ7","v":"  305"},null,null,null,{"$f":"Working!AQ12","v":"  1855"},null,null,null,{"$f":"Working!AQ17","v":"110"},null,null,null,{"$f":"Working!AQ22","v":"1575"}]
[null,null,{"$f":"Working!AZ7","v":"      00"},null,null,null,{"$f":"Working!AZ12","v":"        00"},null,null,null,{"$f":"Working!AZ17","v":"    0"},null,null,null,{"$f":"Working!AZ22","v":"  1800"}]
[null,null,{"$f":"Working!BC7","v":""},null,null,null,{"$f":"Working!BC12","v":""},null,null,null,{"$f":"Working!BC17","v":""},null,null,null,{"$f":"Working!BC22","v":"  1800"}]
[]
[null,null,{"$f":"Working!N8","v":"    93"},null,null,null,{"$f":"Working!N13","v":"    666"},null,null,null,{"$f":"Working!N18","v":"    17"},null,null,null,{"$f":"Working!N23","v":"    422"}]
[{"$f":"Working!C8","v":"5)"},{"$f":"Working!E8","v":25},{"$f":"Working!I8","v":2325},null,{"$f":"Working!C13","v":"10)"},{"$f":"Working!E13","v":59},{"$f":"Working!I13","v":39294},null,{"$f":"Working!C18","v":"15)"},{"$f":"Working!E18","v":64},{"$f":"Working!I18","v":1088},null,{"$f":"Working!C23","v":"20)"},{"$f":"Working!E23","v":84},{"$f":"Working!I23","v":35448}]
[null,null,{"$f":"Working!V8","v":"225"},null,null,null,{"$f":"Working!V13","v":"354"},null,null,null,{"$f":"Working!V18","v":"  64"},null,null,null,{"$f":"Working!V23","v":"336"}]
[null,null,{"$f":"Working!AD8","v":"    75"},null,null,null,{"$f":"Working!AJ13","v":"  389"},null,null,null,{"$f":"Working!AJ18","v":"  448"},null,null,null,{"$f":"Working!AJ23","v":"  184"}]
[null,null,{"$f":"Working!AQ8","v":"    75"},null,null,null,{"$f":"Working!AQ13","v":"  354"},null,null,null,{"$f":"Working!AQ18","v":"  448"},null,null,null,{"$f":"Working!AQ23","v":"  168"}]
[null,null,{"$f":"Working!AZ8","v":"      0"},null,null,null,{"$f":"Working!AZ13","v":"    354"},null,null,null,{"$f":"Working!AZ18","v":"      0"},null,null,null,{"$f":"Working!AZ23","v":"    168"}]
[null,null,{"$f":"Working!BC8","v":""},null,null,null,{"$f":"Working!BC13","v":"    354"},null,null,null,{"$f":"Working!BC18","v":""},null,null,null,{"$f":"Working!BC23","v":"    168"}]

{"sheet":"Working","index":3,"n_rows":23,"n_cols":55,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,6,1,7],[1,8,1,13]]}
[{"$f":"INT(900*RAND()+100)","v":974},{"$f":"TEXT(1,A1)","v":"974"},"LDW-"]
[null,null,null,null,null,null,"Numbers",null,"Text"]
[null,null,null,null,"Divisor",null,"Quotient","Dividend","Dividend","DLength","QLength",null,"Spaces","Quotient",null,null,null,null,null,null,"Space",null,null,null,"Space"]
[1,")",{"$f":"CONCATENATE(A4,B4)","v":"1)"},{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":2},{"$f":"INT((10^D4-10^(D4-1)-3)*RAND()+10^(D4-1)+3)","v":52},{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},{"$f":"INT((10^F4-10^(F4-1)-3)*RAND()+10^(F4-1)+3)","v":246},{"$f":"E4*G4","v":12792},{"$f":"H4","v":12792},{"$f":"LEN(I4)","v":5},{"$f":"LEN(G4)","v":3},{"$f":"J4-K4","v":2},{"$f":"IF(L4=0,\"  \",IF(L4=1,\"   \",IF(L4=2,\"    \",IF(L4=3,\"      \",\"        \"))))","v":"    "},{"$f":"CONCATENATE(M4,G4)","v":"    246"},{"$f":"MID(G4,1,1)","v":"2"},{"$f":"O4*$E4","v":104},{"$f":"LEN(P4)","v":3},{"$f":"MID(H4,1,Q4)","v":"127"},{"$f":"IF(P4>VALUE(R4),(Q4+1),Q4)","v":3},{"$f":"MID(H4,1,S4)","v":"127"},{"$f":"IF((S4-Q4)=0,\"\",IF((S4-Q4)=1,\"  \",IF((S4-Q4)=2,\"    \",IF((S4-Q4)=3,\"      \",IF((S4-Q4)=4,\"        \",\"          \")))))","v":""},{"$f":"CONCATENATE(U4,P4)","v":"104"},{"$f":"T4-P4","v":23},{"$f":"LEN(W4)","v":2},{"$f":"IF((Q4-X4)=0,\"\",IF((Q4-X4)=1,\"  \",IF((Q4-X4)=2,\"    \",IF((Q4-X4)=3,\"      \",IF((Q4-X4)=4,\"        \",\"          \")))))","v":"  "},{"$f":"LEN(P4)","v":3},{"$f":"J4-Q4","v":2},{"$f":"S4+1","v":4},{"$f":"MID(H4,AB4,1)","v":"9"},{"$f":"CONCATENATE(U4,Y4,W4,AC4)","v":"  239"},null,{"$f":"MID(G4,2,1)","v":"4"},{"$f":"IF(AF4=\"0\",(AB4+1),AB4)","v":4},{"$f":"MID(H4,AG4,1)","v":"9"},{"$f":"IF(AF4=\"0\",MID(G4,3,1),MID(G4,2,1))","v":"4"},{"$f":"IF(AF4=\"0\",(CONCATENATE(AD4,AH4)),AD4)","v":"  239"},{"$f":"IF(AI4=\"\",0,AI4*$E4)","v":208},{"$f":"LEN(AK4)","v":3},{"$f":"VALUE(AJ4)","v":239},{"$f":"LEN(AM4)","v":3},{"$f":"IF(AK4>AM4,(AL4+1),AL4)","v":3},{"$f":"IF((AN4-AO4)=0,\"\",IF((AN4-AO4)=1,\"  \",IF((AN4-AO4)=2,\"    \",IF((AN4-AO4)=3,\"      \",IF((AN4-AO4)=4,\"        \",\"          \")))))","v":""},{"$f":"IF(AK4=0,\"\",CONCATENATE(U4,Y4,AP4,AK4))","v":"  208"},{"$f":"IF(AI4=\"\",\"\",(AM4-AK4))","v":31},{"$f":"LEN(AK4)","v":3},{"$f":"LEN(AR4)","v":2},{"$f":"IF((AS4-AT4)=0,\"\",IF((AS4-AT4)=1,\"  \",IF((AS4-AT4)=2,\"    \",IF((AS4-AT4)=3,\"      \",IF((AS4-AT4)=4,\"        \",\"          \")))))","v":"  "},{"$f":"AM4-AK4","v":31},{"$f":"CONCATENATE(Y4,AP4,AU4,AV4)","v":"    31"},null,{"$f":"MID(H4,(AG4+1),1)","v":"2"},{"$f":"IF(AK4=0,\"\",CONCATENATE(U4,AW4,AY4))","v":"    312"},{"$f":"MID(G4,3,1)","v":"6"},{"$f":"IF(BA4=\"\",0,BA4*$E4)","v":312},{"$f":"IF(AV4=0,\"\",CONCATENATE(U4,Y4,AP4,AU4,BB4))","v":"    312"}]
[2,")",{"$f":"CONCATENATE(A5,B5)","v":"2)"},{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":3},271,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":2},{"$f":"INT((10^F5-10^(F5-1)-3)*RAND()+10^(F5-1)+3)","v":40},{"$f":"E5*G5","v":10840},{"$f":"H5","v":10840},{"$f":"LEN(I5)","v":5},{"$f":"LEN(G5)","v":2},{"$f":"J5-K5","v":3},{"$f":"IF(L5=0,\"  \",IF(L5=1,\"   \",IF(L5=2,\"    \",IF(L5=3,\"      \",\"        \"))))","v":"      "},"      40",{"$f":"MID(G5,1,1)","v":"4"},{"$f":"O5*$E5","v":1084},{"$f":"LEN(P5)","v":4},"1084",{"$f":"IF(P5>VALUE(R5),(Q5+1),Q5)","v":4},"1084",{"$f":"IF((S5-Q5)=0,\"\",IF((S5-Q5)=1,\"  \",IF((S5-Q5)=2,\"    \",IF((S5-Q5)=3,\"      \",IF((S5-Q5)=4,\"        \",\"          \")))))","v":""},{"$f":"CONCATENATE(U5,P5)","v":"1084"},{"$f":"T5-P5","v":0},{"$f":"LEN(W5)","v":1},{"$f":"IF((Q5-X5)=0,\"\",IF((Q5-X5)=1,\"  \",IF((Q5-X5)=2,\"    \",IF((Q5-X5)=3,\"      \",IF((Q5-X5)=4,\"        \",\"          \")))))","v":"      "},{"$f":"LEN(P5)","v":4},1,{"$f":"S5+1","v":5},{"$f":"MID(H5,AB5,1)","v":"0"},{"$f":"CONCATENATE(U5,Y5,W5,AC5)","v":"      00"},null,{"$f":"MID(G5,2,1)","v":"0"},{"$f":"IF(AF5=\"0\",(AB5+1),AB5)","v":6},{"$f":"MID(H5,AG5,1)","v":""},{"$f":"IF(AF5=\"0\",MID(G5,3,1),MID(G5,2,1))","v":""},{"$f":"IF(AF5=\"0\",(CONCATENATE(AD5,AH5)),AD5)","v":"      00"},{"$f":"IF(AI5=\"\",0,AI5*$E5)","v":0},{"$f":"LEN(AK5)","v":1},{"$f":"VALUE(AJ5)","v":0},{"$f":"LEN(AM5)","v":1},{"$f":"IF(AK5>AM5,(AL5+1),AL5)","v":1},{"$f":"IF((AN5-AO5)=0,\"\",IF((AN5-AO5)=1,\"  \",IF((AN5-AO5)=2,\"    \",IF((AN5-AO5)=3,\"      \",IF((AN5-AO5)=4,\"        \",\"          \")))))","v":""},{"$f":"IF(AK5=0,\"\",CONCATENATE(U5,Y5,AP5,AK5))","v":""},{"$f":"IF(AI5=\"\",\"\",(AM5-AK5))","v":""},{"$f":"LEN(AK5)","v":1},{"$f":"LEN(AR5)","v":0},{"$f":"IF((AS5-AT5)=0,\"\",IF((AS5-AT5)=1,\"  \",IF((AS5-AT5)=2,\"    \",IF((AS5-AT5)=3,\"      \",IF((AS5-AT5)=4,\"        \",\"          \")))))","v":"  "},{"$f":"AM5-AK5","v":0},{"$f":"CONCATENATE(Y5,AP5,AU5,AV5)","v":"        0"},null,{"$f":"MID(H5,(AG5+1),1)","v":""},{"$f":"IF(AK5=0,\"\",CONCATENATE(U5,AW5,AY5))","v":""},{"$f":"MID(G5,3,1)","v":""},{"$f":"IF(BA5=\"\",0,BA5*$E5)","v":0},{"$f":"IF(AV5=0,\"\",CONCATENATE(U5,Y5,AP5,AU5,BB5))","v":""}]
[3,")","3)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":3},680,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},625,425000,425000,6,3,3,"      ","      625","6",4080,4,"4250",4,"4250","","4080",170,3,"  ",4,2,5,"0","  1700",null,"2",5,"0","2","  1700",1360,4,1700,4,4,"","  1360",340,4,3,"  ",340,"    340",null,"0","    3400","5",3400,"    3400"]
[4,")","4)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":2},61,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},750,45750,45750,5,3,2,"    ","    750","7",427,3,"457",3,"457","","427",30,2,"  ",3,2,4,"5","  305",null,"5",4,"5","5","  305",305,3,305,3,3,"","  305",0,3,1,"    ",0,"      0",null,"0","      00","0",0,""]
[5,")","5)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":2},25,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":2},93,2325,2325,4,2,2,"    ","    93","9",225,3,"232",3,"232","","225",7,1,"    ",3,1,4,"5","    75",null,"3",4,"5","3","    75",75,2,75,2,2,"","    75",0,2,1,"  ",0,"      0",null,"","      0","",0,""]
[6,")","6)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":3},910,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":2},58,52780,52780,5,2,3,"      ","      58","5",4550,4,"5278",4,"5278","","4550",728,3,"  ",4,1,5,"0","  7280",null,"8",5,"0","8","  7280",7280,4,7280,4,4,"","  7280",0,4,1,"      ",0,"        0",null,"","        0","",0,""]
[7,")","7)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":3},883,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},232,204856,204856,6,3,3,"      ","      232","2",1766,4,"2048",4,"2048","","1766",282,3,"  ",4,2,5,"5","  2825",null,"3",5,"5","3","  2825",2649,4,2825,4,4,"","  2649",176,4,3,"  ",176,"    176",null,"6","    1766","2",1766,"    1766"]
[8,")","8)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":3},920,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},372,342240,342240,6,3,3,"      ","      372","3",2760,4,"3422",4,"3422","","2760",662,3,"  ",4,2,5,"4","  6624",null,"7",5,"4","7","  6624",6440,4,6624,4,4,"","  6440",184,4,3,"  ",184,"    184",null,"0","    1840","2",1840,"    1840"]
[9,")","9)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":3},371,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},850,315350,315350,6,3,3,"      ","      850","8",2968,4,"3153",4,"3153","","2968",185,3,"  ",4,2,5,"5","  1855",null,"5",5,"5","5","  1855",1855,4,1855,4,4,"","  1855",0,4,1,"      ",0,"        0",null,"0","        00","0",0,""]
[10,")","10)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":2},59,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},666,39294,39294,5,3,2,"    ","    666","6",354,3,"392",3,"392","","354",38,2,"  ",3,2,4,"9","  389",null,"6",4,"9","6","  389",354,3,389,3,3,"","  354",35,3,2,"  ",35,"    35",null,"4","    354","6",354,"    354"]
[11,")","11)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":2},63,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":2},84,5292,5292,4,2,2,"    ","    84","8",504,3,"529",3,"529","","504",25,2,"  ",3,1,4,"2","  252",null,"4",4,"2","4","  252",252,3,252,3,3,"","  252",0,3,1,"    ",0,"      0",null,"","      0","",0,""]
[12,")","12)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":3},304,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},446,135584,135584,6,3,3,"      ","      446","4",1216,4,"1355",4,"1355","","1216",139,3,"  ",4,2,5,"8","  1398",null,"4",5,"8","4","  1398",1216,4,1398,4,4,"","  1216",182,4,3,"  ",182,"    182",null,"4","    1824","6",1824,"    1824"]
[13,")","13)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":3},108,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":2},80,8640,8640,4,2,2,"    ","    80","8",864,3,"864",3,"864","","864",0,1,"    ",3,1,4,"0","    00",null,"0",5,"","","    00",0,1,0,1,1,"","","",1,0,"  ",0,"      0",null,"","","",0,""]
[14,")","14)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":2},22,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":2},35,770,770,3,2,1,"   ","   35","3",66,2,"77",2,"77","","66",11,2,"",2,1,3,"0","110",null,"5",3,"0","5","110",110,3,110,3,3,"","110",0,3,1,"    ",0,"    0",null,"","    0","",0,""]
[15,")","15)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":2},64,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":2},17,1088,1088,4,2,2,"    ","    17","1",64,2,"10",3,"108","  ","  64",44,2,"",2,2,4,"8","  448",null,"7",4,"8","7","  448",448,3,448,3,3,"","  448",0,3,1,"    ",0,"    0",null,"","      0","",0,""]
[16,")","16)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":3},790,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},624,492960,492960,6,3,3,"      ","      624","6",4740,4,"4929",4,"4929","","4740",189,3,"  ",4,2,5,"6","  1896",null,"2",5,"6","2","  1896",1580,4,1896,4,4,"","  1580",316,4,3,"  ",316,"    316",null,"0","    3160","4",3160,"    3160"]
[17,")","17)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":2},96,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},369,35424,35424,5,3,2,"    ","    369","3",288,3,"354",3,"354","","288",66,2,"  ",3,2,4,"2","  662",null,"6",4,"2","6","  662",576,3,662,3,3,"","  576",86,3,2,"  ",86,"    86",null,"4","    864","9",864,"    864"]
[18,")","18)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":2},90,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":2},36,3240,3240,4,2,2,"    ","    36","3",270,3,"324",3,"324","","270",54,2,"  ",3,1,4,"0","  540",null,"6",4,"0","6","  540",540,3,540,3,3,"","  540",0,3,1,"    ",0,"      0",null,"","      0","",0,""]
[19,")","19)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":3},225,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},378,85050,85050,5,3,2,"    ","    378","3",675,3,"850",3,"850","","675",175,3,"",3,2,4,"5","1755",null,"7",4,"5","7","1755",1575,4,1755,4,4,"","1575",180,4,3,"  ",180,"  180",null,"0","  1800","8",1800,"  1800"]
[20,")","20)",{"$f":"IF(Values!$F$6=2,2,IF(Values!$F$6=3,3,INT(2*RAND()+2)))","v":2},84,{"$f":"IF(Values!$F$11=2,2,IF(Values!$F$11=3,3,INT(2*RAND()+2)))","v":3},422,35448,35448,5,3,2,"    ","    422","4",336,3,"354",3,"354","","336",18,2,"  ",3,2,4,"4","  184",null,"2",4,"4","2","  184",168,3,184,3,3,"","  168",16,3,2,"  ",16,"    16",null,"8","    168","2",168,"    168"]