{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Nat Grid Ref Conversions"],"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":"Nat Grid Ref Conversions","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[16,0,17,1],[6,0,13,0],[12,2,12,3],[13,2,13,3],[4,2,5,3],[27,0,27,3],[0,0,0,3],[18,0,25,0],[2,4,25,4],[2,0,2,3],[3,2,3,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[3,0,3,1],[16,2,16,3],[15,0,15,3]]}
["National Grid Reference format conversion (enter input data in the yellow boxes)"]
[]
["Full eastings and northings to National Grid reference including 100km square letters",null,null,null,"These calculations are performed using user defined functions.  To see the Visual Basic code of the functions - Enable the Developer menu and select \"View Code\", then view the code in \"Module 1\"."]
["Input Data",null,"Output Data"]
["Easting",400000,"National Grid reference"]
["Northing",400000]
["Square size of returned reference (km)",100,{"$f":"GridSquare($B$5,$B$6,$B$7)","v":"SE"}]
[null,10,{"$f":"GridSquare($B$5,$B$6,$B$8)","v":"SE00"}]
[null,5,{"$f":"GridSquare($B$5,$B$6,$B$9)","v":"SE00SW"}]
[null,1,{"$f":"GridSquare($B$5,$B$6,$B$10)","v":"SE0000"}]
[null,0.5,{"$f":"GridSquare($B$5,$B$6,$B$11)","v":"SE0000SW"}]
[null,0.1,{"$f":"GridSquare($B$5,$B$6,$B$12)","v":"SE000000"}]
[null,0.01,{"$f":"GridSquare($B$5,$B$6,$B$13)","v":"SE00000000"}]
[null,1E-3,{"$f":"GridSquare($B$5,$B$6,$B$14)","v":"SE0000000000"}]
[]
["National Grid reference to eastings and Northings"]
["Input Data",null,"Output Data"]
[null,null,"Easting","Northing"]
["National Grid reference","SE",{"$f":"GridRef_to_Eastings($B$19)","v":400000},{"$f":"GridRef_to_Northings($B$19)","v":400000}]
[null,"SE00",{"$f":"GridRef_to_Eastings($B$20)","v":400000},{"$f":"GridRef_to_Northings($B$20)","v":400000}]
[null,"SE00SW",{"$f":"GridRef_to_Eastings($B$21)","v":400000},{"$f":"GridRef_to_Northings($B$21)","v":400000}]
[null,"SE0000",{"$f":"GridRef_to_Eastings($B$22)","v":400000},{"$f":"GridRef_to_Northings($B$22)","v":400000}]
[null,"SE0000SW",{"$f":"GridRef_to_Eastings($B$23)","v":400000},{"$f":"GridRef_to_Northings($B$23)","v":400000}]
[null,"SE000000",{"$f":"GridRef_to_Eastings($B$24)","v":400000},{"$f":"GridRef_to_Northings($B$24)","v":400000}]
[null,"SE00000000",{"$f":"GridRef_to_Eastings($B$25)","v":400000},{"$f":"GridRef_to_Northings($B$25)","v":400000}]
[null,"SE0000000000",{"$f":"GridRef_to_Eastings($B$26)","v":400000},{"$f":"GridRef_to_Northings($B$26)","v":400000}]
[]
["Note : be aware when changing the layout of this sheet that all cell references are ABSOLUTE.  This is so that function inputs can be easily identified."]