{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calculator"],"not_rendered":{"charts":0,"images":2,"macros":0,"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":"Calculator","index":0,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Raster Orthogonality & Concurrency Calculator"]
["Raw Raster Corner Coorindates"]
[null,"Raster Name","Bottom","Left","Top","Right"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
["Orthogonal Raster Corner Coordinates"]
[null,"Raster Name","Bottom","Left","Top","Right"]
[1,{"$f":"IF(ISBLANK(B4),\"\",B4)","v":""},{"$f":"IF(ISBLANK(C4),\"\",ROUNDDOWN(C4,0))","v":""},{"$f":"IF(ISBLANK(D4),\"\",ROUNDDOWN(D4,0))","v":""},{"$f":"IF(ISBLANK(E4),\"\",ROUNDUP(E4,0))","v":""},{"$f":"IF(ISBLANK(F4),\"\",ROUNDUP(F4,0))","v":""}]
[2,{"$f":"IF(ISBLANK(B5),\"\",B5)","v":""},{"$f":"IF(ISBLANK(C5),\"\",ROUNDDOWN(C5,0))","v":""},"",{"$f":"IF(ISBLANK(E5),\"\",ROUNDUP(E5,0))","v":""},""]
[3,"","","",{"$f":"IF(ISBLANK(E6),\"\",ROUNDUP(E6,0))","v":""},""]
[4,"","","",{"$f":"IF(ISBLANK(E7),\"\",ROUNDUP(E7,0))","v":""},""]
[5,"","","",{"$f":"IF(ISBLANK(E8),\"\",ROUNDUP(E8,0))","v":""},""]
[6,"","","",{"$f":"IF(ISBLANK(E9),\"\",ROUNDUP(E9,0))","v":""},""]
[7,"","","",{"$f":"IF(ISBLANK(E10),\"\",ROUNDUP(E10,0))","v":""},""]
[8,"","","",{"$f":"IF(ISBLANK(E11),\"\",ROUNDUP(E11,0))","v":""},""]
[9,"","","",{"$f":"IF(ISBLANK(E12),\"\",ROUNDUP(E12,0))","v":""},""]
[10,"","","",{"$f":"IF(ISBLANK(E13),\"\",ROUNDUP(E13,0))","v":""},""]
[null,"Outer Bounds"]
[]
["Concurrent and Orthogonal Raster Corner Coordinates"]
[null,"Cell Resolution:",5]
[null,"Minimum Required Buffer:",50]
[]
[null,"Required buffer","Bottom","Left","Top","Right"]
[null,"Out Bounds",{"$f":"MIN($C$17:$C$26)","v":0},{"$f":"MIN($D$17:$D$26)","v":0},{"$f":"MAX($E$17:$E$26)","v":0},{"$f":"MAX($F$17:$F$26)","v":0}]
[null,"Buffered",{"$f":"C34-$C$31","v":-50},{"$f":"D34-$C$31","v":-50},{"$f":"E34+C31","v":50},{"$f":"F34+$C$31","v":50}]
[null,"Orthogonal & Divisible Coordinates",{"$f":"C35-MOD(C35,C30)","v":-50},{"$f":"D35-MOD(D35,C30)","v":-50},{"$f":"E35+($C$30-MOD(E35-C36,$C$30))","v":55},{"$f":"F35+($C$30-MOD(F35-D36,$C$30))","v":55}]
[null,"Actual Buffer",{"$f":"C34-C36","v":50},{"$f":"D34-D36","v":50},{"$f":"E36-E34","v":55},{"$f":"F36-F34","v":55}]
[null,"Coordinate is divisible",{"$f":"IF(MOD(C36,$C$30),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(MOD(D36,$C$30),\"No\",\"Yes\")","v":"Yes"},"Yes","Yes"]
[null,"Range is Divisible",{"$f":"IF(MOD(E36-C36,$C$30),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(MOD(F36-D36,$C$30),\"No\",\"Yes\")","v":"Yes"}]
[]
["Notes"]
[null,"Author:","Philip Bailey, North Arrow Research Ltd."]
[null,"Last updated:","2013-03-08"]