{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Notes","Simplest","v.1","v.2","v.3","compex"],"not_rendered":{"charts":0,"images":21,"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":"Notes","index":0,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
["Notes:"]
["> For all \"column\" entries, put the column letter, not number."]
["> To convert Degrees to decimal format, use the following:"]
["Assuming you have DEGREES in A2, MINUTES in B2, and SECONDS in C2, then paste this wherever you'd like the decimal ones."]
["IF(A2>0,A2+B2/60+C2/3600,A2-B2/60-C2/3600)"]
["If you don't have the DEGREES as + and -, then you have to use this one, assuming N,S,E,W are in column D2"]
["IF(OR(D2=\"N\",D2=\"E\"),A2+B2/60+C2/3600,-A2-B2/60-C2/3600)"]
[]
["Help text:"]
["Start Cell","The column heading of the entry that has IDs, or some other field that's never blank… if the form sees a blank cell, it'll stop."]
["KML Path","Folder where the file should be saved. Press little circle button on the right to launch the folder picker."]
["Filename","Filename for the kml file. Don't put \".kml\", I'll do that for you."]
["Title","Title for the file (what you'll see in G Earth)"]
["Lat","Column where the latitudes are"]
["Long","Column where the longitudes are"]
["Advanced","Complex stuff!!!!!!!"]
["Description","What is this file? Here's where you put the general information, also info about the icons used, colours, etc"]
["Default pt","What symbol should be used unless otherwise specified?"]
["Column for point names","Column that has the point names (what's displayed as a label on the map)"]
["col for symb","In this column you can specify if you want another icon to be displayed for this point. Use this notation, 0-15 for a cardinal arrow, optionally preceeded by \"g\",\"b\", or \"r\" for green, blue, red, respectively."]
["Title on popups","Column that has the title in the popup. (html codes are allowed)"]
["label scale","Scale of the label (2 is double the size, 0.5 is half size)"]
["label color","Label color"]
["icon scale","Scale of the icon (2 is double the size, 0.5 is half size)"]
["icon color","Icon color"]
["opacity","Transparency level for points and labels… 100% is fully visible, 0% is transparent"]
["rest of info","You can put additional information inside the popup. Info has to be on contiguous cells. These cells start on column… and end on column:"]
["clear form","If left blank, then it keeps what has been entered… if checked, it clears the form"]
[]
[]
[]
["Features:",null,null,null,null,null,"Specific point directions:"]
["Simple and advanced modes"]
["userform for convenience",null,null,null,null,null,null,0,null,null,8]
["Icons change when highlighted"]
["Allows html to be passed to popup contents, everything is customizable"]
["Issue a default icon, and change icons for specific points",null,null,null,null,null,null,1,null,null,9]
["Change colours and opacity for points via easy dropdowns"]
["Pass data from excel columns to the popup for each point"]
[]
[null,null,null,null,null,null,null,2,null,null,10]
[]
[]
[null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,11]
[]
[null,null,null,null,null,null,null,4]
[]
[null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,5]
[]
[]
[null,null,null,null,null,null,null,6,null,null,13]
[]
[]
[null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,14]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,15]

{"sheet":"Simplest","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Point","Lat","Long"]
[null,1,24.33,24.32]
[null,2,24.22,24.22]
[null,3,24.33,24.22]
[null,4,24.22,24.32]
[]
["The settings above give the result below…… but try for yourself by playing with the data above and pushing the button \"Show form\""]

{"sheet":"v.1","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Point","Lat","Long"]
[null,null,1,24.33,24.32]
[null,null,2,24.22,24.22]
[null,null,3,24.33,24.22]
[null,null,4,24.22,24.32]
[]
["The settings above give the result below…… but try for yourself by playing with the data above and pushing the button \"Show form\""]

{"sheet":"v.2","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Point","Lat","Long"]
[null,null,1,24.33,24.32]
[null,null,2,24.22,24.22]
[null,null,3,24.33,24.22]
[null,null,4,24.22,24.32]
[]
["The settings above give the result below…… but try for yourself by playing with the data above and pushing the button \"Show form\""]

{"sheet":"v.3","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Point","Lat","Long"]
[null,null,1,24.33,24.32]
[null,null,2,24.22,24.22]
[null,null,3,24.33,24.22]
[null,null,4,24.22,24.32]
[]
[]
["The settings above give the result below…… but try for yourself by playing with the data above and pushing the button \"Show form\""]

{"sheet":"compex","index":5,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Point","Name","Lat","Long","Not default","Stuff 1","Stuff 2","Stuff 3"]
[null,null,1,{"$f":"IF(H4=\"doc\", \"has d\",\"no d\")","v":"has d"},24.33,24.32,null,"doc","cat","bat"]
[null,null,2,{"$f":"IF(H5=\"doc\", \"has d\",\"no d\")","v":"has d"},24.22,24.22,1,"doc","dog"]
[null,null,3,{"$f":"IF(H6=\"doc\", \"has d\",\"no d\")","v":"no d"},24.33,24.22,"r8",null,"Hello","please"]
[null,null,4,{"$f":"IF(H7=\"doc\", \"has d\",\"no d\")","v":"has d"},24.22,24.32,null,"doc"]
[]
[]
["The settings above give the result below…… but try for yourself by playing with the data above and pushing the button \"Show form\""]
["For information on the directions of the specific icons, look on Notes tab."]