{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Calculations","Position File","TimeStamp","Output"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"Instructions","index":0,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"This file was created to assist in the PPK processing workflow for the DJI Phantom 4 RTK unit.  The input position file comes from RTKPOST, and the input TimeStamp file comes from the DJI Phantom 4 RTK aircraft itself.  For full instructions and documentation, visit the Aerotas website below."]
[null,"<<<Link to Instructions>>>"]
[]
[null,"Instructions"]
[null,"Step 1: If this file has been used before, click the button below to reset it to default settings."]
[]
[]
[null,"Step 2: In the yellow box below, enter in the name of the DJI folder in which the photos are stored.  This is important for properly naming the photos so that photogrammetry algorithms can match the location data from this file to the photos themselves."]
[null,"100_0001"]
[]
[null,"Step 3: Take the .pos file from RTKPOST, convert it to CSV format, and copy it into the Yellow \"Position File\" tab on cell B1.  This should populate colunmns B-P.",null,{"$f":"IF(Calculations!B16<=3,\"Please paste in Position data\",\"OK\")","v":"Please paste in Position data"}]
[]
[null,"Step 4: Take the timestamp.mrk file from DJI, and paste its contents into the \"TimeStamp\" tab in blue, on cell A2.  This should populate columns A-K.",null,{"$f":"IF(Calculations!B18<=3,\"Please paste in TimeStamp data\",\"OK\")","v":"Please paste in TimeStamp data"}]
[]
[null,"Step 5: Press the button below to perform calculations.  ",null,{"$f":"IF(OR(Calculations!B16>Calculations!B14,Calculations!B18>Calculations!B19),\"Please run calculations before exporting\",\"OK\")","v":"OK"}]
[]
[]
[null,"Step 6: After reviewing the data, press the final button to save the output as a CSV file for input into photogrammetry software."]

{"sheet":"Calculations","index":1,"n_rows":26,"n_cols":36,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,2,10,2]]}
[null,null,null,null,null,null,null,null,"Output Formulas",null,null,null,null,"Timestamp Formulas"]
[null,null,null,null,null,null,null,null,{"$f":"foldername&\"_\"&TEXT(TimeStamp!$A2,\"0000\")&\".JPG\"","v":"100_0001_0001.JPG"},{"$f":"TimeStamp!$AH2","v":{"$error":"#N/A"}},{"$f":"TimeStamp!$AI2","v":{"$error":"#N/A"}},{"$f":"TimeStamp!$AJ2","v":{"$error":"#N/A"}},null,{"$f":"VALUE(MID(D2,1,SEARCH(\",\",D2,1)-1))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(MID(E2,1,SEARCH(\",\",E2,1)-1))","v":{"$error":"#VALUE!"}},{"$f":"VALUE(MID(F2,1,SEARCH(\",\",F2,1)-1))","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(B2,'Position File'!C:Q,15,1)","v":0},{"$f":"VLOOKUP(Q2,'Position File'!$A:$C,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q2,'Position File'!$A:$F,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q2,'Position File'!$A:$F,5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q2,'Position File'!$A:$F,6)","v":{"$error":"#N/A"}},{"$f":"Q2+1","v":1},{"$f":"VLOOKUP(V2,'Position File'!$A:$C,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(V2,'Position File'!$A:$F,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(V2,'Position File'!$A:$F,5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(V2,'Position File'!$A:$F,6)","v":{"$error":"#N/A"}},{"$f":"(B2-R2)/(W2-R2)","v":{"$error":"#N/A"}},{"$f":"(S2*(1-$AA2))+(X2*$AA2)","v":{"$error":"#N/A"}},{"$f":"(T2*(1-$AA2))+(Y2*$AA2)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"N2/1000/Calculations!$B$9","v":{"$error":"#VALUE!"}},{"$f":"O2/1000/Calculations!$B$11","v":{"$error":"#VALUE!"}},{"$f":"P2/1000","v":{"$error":"#VALUE!"}},{"$f":"AB2+AE2","v":{"$error":"#N/A"}},{"$f":"AC2+AF2","v":{"$error":"#N/A"}},{"$f":"AD2-AG2","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
["CONVERSIONS","Calculation"]
["1 degree lat in meters",111111]
["Lat Used",{"$f":"INDIRECT(\"'Position File'!D3\")","v":0}]
["1 degree long in meters",{"$f":"COS(RADIANS(B10))*B9","v":111111}]
[]
[]
["Rows in Pos ID1",{"$f":"COUNTA('Position File'!A:A)-1","v":0}]
["Rows in Pos ID2",{"$f":"COUNTA('Position File'!Q:Q)-1","v":0}]
["Rows in Pos Data",{"$f":"COUNTA('Position File'!B:B)-2","v":0}]
[]
["Rows in Time Data",{"$f":"COUNTA(TimeStamp!A:A)","v":1}]
["Rows in Time Calcs",{"$f":"COUNTA(TimeStamp!N:N)-1","v":1}]
["Rows in Output",{"$f":"COUNTA(Output!A:A)-1","v":1}]
[]
["Checksums (0 is good)",{"$f":"SUM(B23:B26)","v":0}]
[null,{"$f":"ABS(B14-B15)","v":0}]
[null,{"$f":"ABS(B15-B16)","v":0}]
[null,{"$f":"ABS(B18-B19)","v":0}]
[null,{"$f":"ABS(B19-B20)","v":0}]

{"sheet":"Position File","index":2,"n_rows":2,"n_cols":17,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"% ref pos   : 33.617931918",-117.803421809,117.416]
["Location ID","%  GPST        "," latitude(deg)","longitude(deg)"," height(m)","  Q"," ns","  sdn(m)","  sde(m)","  sdu(m)"," sdne(m)"," sdeu(m)"," sdun(m)","age(s)"," ratio",null,"Location ID"]

{"sheet":"TimeStamp","index":3,"n_rows":2,"n_cols":36,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Northing diff (mm)","Easting diff (mm)","Elevation diff (mm)","Closest Loc ID","Timstamp of Closest","Closest Lat","Closest Lon","Closest El","2nd Closest Loc ID","Timestamp of 2nd closest","Closest Lat","Closest Lon","Closest El","% diff between timestamps","Interpolated Lat","Interpolated Lon","Interpolated El","Lat Diff (deg)","Long Diff (deg)","El Diff (m)","New Lat","New Lon","New El"]
[1,158535.31228700001,"[2028]","    11,N","    32,E","   191,V","33.69276096,Lat","-117.92183609,Lon","21.722,Ellh","1.267347, 1.422186, 2.759199","16,Q",null,null,{"$f":"VALUE(MID(D2,1,SEARCH(\",\",D2,1)-1))","v":11},{"$f":"VALUE(MID(E2,1,SEARCH(\",\",E2,1)-1))","v":32},{"$f":"VALUE(MID(F2,1,SEARCH(\",\",F2,1)-1))","v":191},{"$f":"VLOOKUP(B2,'Position File'!C:Q,15,1)","v":0},{"$f":"VLOOKUP(Q2,'Position File'!$A:$C,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q2,'Position File'!$A:$F,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q2,'Position File'!$A:$F,5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(Q2,'Position File'!$A:$F,6)","v":{"$error":"#N/A"}},{"$f":"Q2+1","v":1},{"$f":"VLOOKUP(V2,'Position File'!$A:$C,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(V2,'Position File'!$A:$F,4)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(V2,'Position File'!$A:$F,5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(V2,'Position File'!$A:$F,6)","v":{"$error":"#N/A"}},{"$f":"(B2-R2)/(W2-R2)","v":{"$error":"#N/A"}},{"$f":"(S2*(1-$AA2))+(X2*$AA2)","v":{"$error":"#N/A"}},{"$f":"(T2*(1-$AA2))+(Y2*$AA2)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"N2/1000/Calculations!$B$9","v":9.9000099000098999E-8},{"$f":"O2/1000/Calculations!$B$11","v":2.8800028800028801E-7},{"$f":"P2/1000","v":0.191},{"$f":"AB2+AE2","v":{"$error":"#N/A"}},{"$f":"AC2+AF2","v":{"$error":"#N/A"}},{"$f":"AD2-AG2","v":{"$error":"#N/A"}}]

{"sheet":"Output","index":4,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["PhotoNum","Latitude","Longidute","Elevation (meters)"]
[{"$f":"foldername&\"_\"&TEXT(TimeStamp!$A2,\"0000\")&\".JPG\"","v":"100_0001_0001.JPG"},{"$f":"TimeStamp!$AH2","v":{"$error":"#N/A"}},{"$f":"TimeStamp!$AI2","v":{"$error":"#N/A"}},{"$f":"TimeStamp!$AJ2","v":{"$error":"#N/A"}}]