{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Map Edit","Calculations (Ex 1)","Ex 2","Ex 3"],"not_rendered":{"macros":1,"defined_names":35},"read":"whole","date_system":"1900"}

{"sheet":"Map Edit","index":0,"n_rows":63,"n_cols":41,"rows_kept":63,"merged":[[2,49,2,51],[40,0,42,0],[44,0,46,0],[48,0,50,0],[52,0,54,0]]}
[]
[]
[{"$nulls":40},"Developed By Jordan Goldmeier"]
["Key",{"$nulls":20},1,1,1,2,2,2,3,3,3,4,4,4,5,5,5,{"$nulls":4},"http://www.optionexplicitvba.com"]
[null,1,1,1,{"$nulls":3},1,2,3,4,5,{"$nulls":9},1,2,3,1,2,3,1,2,3,1,2,3,1,2,3,{"$nulls":4},"and"]
[1,1,{"$nulls":4},1,5,5,5,5,6,{"$nulls":7},1,1,{"$f":"INDEX(CHOOSE(INDEX(TileMap,$T6,V$4),Tile1,Tile2,Tile3,Tile4,Tile5,Tile6,Tile7,Tile8,Tile9,Tile10,Tile11,Tile12,Tile13,Tile14,Tile15),$U6,V$5)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$nulls":4},"Cary Walkin"]
[null,1,1,1,null,null,2,7,5,5,5,8,{"$nulls":7},1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,{"$nulls":4},"http://www.carywalkin.ca"]
[{"$nulls":6},3,15,7,5,5,6,{"$nulls":7},1,3,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1]
[null,1,1,1,null,null,4,13,14,11,11,12,{"$nulls":7},2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1]
[2,null,null,1,null,null,5,9,10,10,10,8,{"$nulls":7},2,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,1,1,1,{"$nulls":15},2,3,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$nulls":19},3,1,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,1,1,1,{"$nulls":15},3,2,1,0,1,1,0,0,0,0,0,0,0,0,0,0,1]
[3,1,null,1,{"$nulls":15},3,3,1,0,1,1,0,1,1,1,1,1,1,1,1,0,1]
[null,1,null,1,{"$nulls":15},4,1,1,0,1,1,0,1,1,1,1,1,1,1,1,0,1]
[{"$nulls":19},4,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,1,null,1,{"$nulls":15},4,3,1,0,1,1,0,1,1,0,1,1,0,1,1,0,1]
[4,1,null,1,{"$nulls":15},5,1,1,0,1,1,0,1,1,0,1,1,0,1,1,0,1]
[null,1,1,1,{"$nulls":15},5,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[{"$nulls":19},5,3,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,1,1,1]
[5]
[null,1,1,1]
[]
[null,1,1,1]
[6,null,null,1]
[null,1,null,1]
[]
[null,1,1,1]
[7,1]
[null,1,null,1]
[]
[null,1,null,1]
[8,null,null,1]
[null,1,1,1]
[]
[null,1,null,1]
[9,1]
[null,1,1,1]
[]
[10,1,null,1]
[]
[null,1,1,1]
[]
[11,1,1,1]
[]
[null,1,null,1]
[]
[12,1,null,1]
[{"$nulls":3},1]
[null,1,null,1]
[]
[13,1,null,1]
[null,1]
[null,1,null,1]
[]
[null,1,null,1]
[14]
[null,1,null,1]
[]
[null,1,null,1]
[15,1,null,1]
[null,1,null,1]

{"sheet":"Calculations (Ex 1)","index":1,"n_rows":17,"n_cols":20,"rows_kept":17}
[]
[{"$nulls":5},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"Top",2,null,1,{"$f":"INDEX(SquareMap,$E3,F$2)-AND(Calculations.Top=$E3,Calculations.Left=F$2)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Left",6,null,2,0,0,0,0,0,-1,0,0,0,0,0,0,0,0,1]
[{"$nulls":4},3,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1]
[{"$nulls":4},4,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1]
[{"$nulls":4},5,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[{"$nulls":4},6,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$nulls":4},7,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$nulls":4},8,1,0,1,1,0,0,0,0,0,0,0,0,0,0,1]
[{"$nulls":4},9,1,0,1,1,0,1,1,1,1,1,1,1,1,0,1]
[{"$nulls":4},10,1,0,1,1,0,1,1,1,1,1,1,1,1,0,1]
[{"$nulls":4},11,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[{"$nulls":4},12,1,0,1,1,0,1,1,0,1,1,0,1,1,0,1]
[{"$nulls":4},13,1,0,1,1,0,1,1,0,1,1,0,1,1,0,1]
[{"$nulls":4},14,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[{"$nulls":4},15,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]

{"sheet":"Ex 2","index":2,"n_rows":9,"n_cols":12,"rows_kept":9}
[]
[{"$nulls":5},{"$f":"Calculations.Left-3","v":-2},{"$f":"F2+1","v":-1},{"$f":"G2+1","v":0},1,2,3,4]
[null,"Top",2,null,{"$f":"Calculations.Top-3","v":-1},{"$f":"IFERROR(INDEX(SquareMap,$E3,F$2)-AND(Calculations.Top=$E3,Calculations.Left=F$2),\"##\")","v":"##"},"##","##","##","##","##","##"]
[null,"Left",1,null,{"$f":"E3+1","v":0},"##","##","##","##","##","##","##"]
[{"$nulls":4},{"$f":"E4+1","v":1},"##","##","##",1,1,1,1]
[{"$nulls":4},2,"##","##","##",-1,0,0,0]
[{"$nulls":4},3,"##","##","##",1,1,1,1]
[{"$nulls":4},4,"##","##","##",1,1,1,1]
[{"$nulls":4},5,"##","##","##",1,0,0,0]

{"sheet":"Ex 3","index":3,"n_rows":20,"n_cols":12,"rows_kept":20}
[]
[]
[null,"Top",2,null,null,1,2,3,4,5,6,7]
[null,"Left",1,null,1,{"$f":"IF(SQRT(($E14-Calculations.Top)^2+(F$13-Calculations.Left)^2)<=1,SQRT(($E14-Calculations.Top)^2+(F$13-Calculations.Left)^2)*(F14+1),SQRT(($E14-Calculations.Top)^2+(F$13-Calculations.Left)^2)*(F14+1)*4)","v":33.94112549695428},{"$f":"IF(SQRT(($E14-Calculations.Top)^2+(G$13-Calculations.Left)^2)<1,SQRT(($E14-Calculations.Top)^2+(G$13-Calculations.Left)^2)*(G14+1),SQRT(($E14-Calculations.Top)^2+(G$13-Calculations.Left)^2)*(G14+1)*4)","v":28.844410203711913},25.298221281347036,24,25.298221281347036,28.844410203711913,33.94112549695428]
[{"$nulls":4},2,{"$f":"IF(SQRT(($E15-Calculations.Top)^2+(F$13-Calculations.Left)^2)<1,SQRT(($E15-Calculations.Top)^2+(F$13-Calculations.Left)^2)*(F15+1),SQRT(($E15-Calculations.Top)^2+(F$13-Calculations.Left)^2)*(F15+1)*4)","v":28.844410203711913},22.627416997969522,17.88854381999832,16,8.94427190999916,22.627416997969522,28.844410203711913]
[{"$nulls":4},3,25.298221281347036,17.88854381999832,11.313708498984761,8,11.313708498984761,17.88854381999832,25.298221281347036]
[{"$nulls":4},4,24,16,8,0,4,8,12]
[{"$nulls":4},5,25.298221281347036,17.88854381999832,11.313708498984761,8,11.313708498984761,17.88854381999832,25.298221281347036]
[{"$nulls":4},6,28.844410203711913,22.627416997969522,17.88854381999832,16,17.88854381999832,22.627416997969522,28.844410203711913]
[{"$nulls":4},7,33.94112549695428,28.844410203711913,25.298221281347036,24,12.649110640673518,14.422205101855956,16.97056274847714]
[]
[]
[{"$nulls":5},{"$f":"Calculations.Left-3","v":-2},{"$f":"F13+1","v":-1},{"$f":"G13+1","v":0},1,2,3,4]
[{"$nulls":4},{"$f":"Calculations.Top-3","v":-1},{"$f":"IFERROR(INDEX(SquareMap,$E14,F$13)-AND(Calculations.Top=$E14,Calculations.Left=F$13),1)","v":1},1,1,1,1,1,1]
[{"$nulls":4},{"$f":"E14+1","v":0},1,1,1,1,0,1,1]
[{"$nulls":4},{"$f":"E15+1","v":1},1,1,1,1,1,1,1]
[{"$nulls":4},2,1,1,1,-1,0,0,0]
[{"$nulls":4},3,1,1,1,1,1,1,1]
[{"$nulls":4},4,1,1,1,1,1,1,1]
[{"$nulls":4},5,1,1,1,1,0,0,0]