{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,7],[19,2,21,2],[3,0,3,7],[7,1,11,2],[11,3,11,7],[12,0,12,2],[12,5,12,7],[5,3,5,7],[15,3,31,3],[22,6,22,7],[20,6,21,7]]}
["ON Axis Guider (ONAG) Back Focus Calculator, Version 1.2\n\n© Innovations Foresight 2018. \n\nDisclosure:\n\nThis calculator is provided \"as is\" for supporting ONAG users in their back focus calculations.\nThe use of any result for making any decision on the final setup and related adapters/spacers, including any purchase, is solely the responsibility of the user.\nInnovations Foresight cannot be held responsible, nor liable, for any consequence related to the use of this calculator, its results and recommendations.\nWe strongly advice and recommend the user, before committing to any setup decision to review all and any results from this calculator\nas well as to draw a sketch, at scale, of the future setup including an ONAG in order to avoid any possible mechanical interference between various components (such as scope visual back, focuser, FW, ...)"]
[]
["For terms, defintions, examples and further information please visit: "]
["https://www.innovationsforesight.com/support/onag-back-focus-calculation/"]
[]
["All inputs in milimeters [mm]",null,null,"Information Data"]
[]
[null,null,null,"ONAG Total Optical\nBack Focus\n[mm] (TOBF, imager)",1,"ONAG Optical Imager\nBack focus\n[mm] (OIBF) ","ONAG Optical Guider\nBack Focus \n[mm] (OGBF)","ONAG \nBack Focus Offset\n[mm] (BFO=OGBF-OIBF)"]
[null,null,null,{"$f":"F9+F11","v":68},null,{"$f":"CHOOSE(E8,68,66)","v":68},{"$f":"CHOOSE(E8,101,90)","v":101},{"$f":"G9-F9","v":33}]
[null,null,null,"Available Scope\nBack Focus\n[mm] (At ONAG SP)",null,"Imager \nBack Focus\n[mm] (IBF) ","Guider \nBack Focus \n[mm] (GBF)","Differential \nBack Focus\n[mm] (DBF=IBF-GBF)"]
[null,null,null,{"$f":"A18-A21-A25-A28-A31","v":0},null,{"$f":"B18+B22+B25+B28+B31","v":0},{"$f":"C18+C25+C28+C31","v":0},{"$f":"F11-G11","v":0}]
[]
["Input Data",null,null," Design Status",null,"Ouput Data"]
[null,null,null,{"$f":"IF(F18<=0,\"Not Enough Back Focus!\",IF(AND(F18>0,F18<25),\"Focuser Travel < 25mm\",IF(F18>24,\"Focuser Travel >= 25mm\")))","v":"Not Enough Back Focus!"}]
["Scope Port (SP)","Imager Port (IP)","Guider Port (GP)",{"$f":"IF(H31,\"Chech List Completed\",\"Complete Check List\")","v":"Complete Check List"},null,"Scope Port (SP)","Imager Port (IP)","Guider Port (GP)"]
[]
["Scope \nBack Focus \n[mm] (At Visual Back)","Camera\nBack Focus \n[mm] (Imager)","Camera \nBack Focus \n[mm] (Guider)",null,null,"Remaining  Scope\nBack Focus\n[mm] (with ONAG)","Spacer(s) To Add\nAt ONAG Imager Port\n[mm] (At IP)","Spacer(s) To Add\nAt ONAG Guider Port \n[mm] (At GP)"]
[0,0,0,null,null,{"$f":"D11-D9","v":-68},{"$f":"IF((H11-H9<0),-(H11-H9),0)","v":33},{"$f":"IF((H11-H9>0),H11-H9,0)","v":0}]
[{"$f":"A18","v":0},{"$f":"B18","v":0},{"$f":"C18","v":0}]
["Focuser/Rotator \nBack Focus \n[mm] (Fully Retracted)","Filter Wheel \nBack Focus \n[mm] (-1mm for filter)"]
[0,0,null,null,null,null,"We stronlgy recommand to draw a sketch at scale \nof the setup with the ONAG for checking clearances"]
[{"$f":"A21","v":0},{"$f":"IF(B21>0,(B21)-1,0)","v":0}]
["Spacer/Adapter/Other\nBack Focus \n[mm]","Spacer/Adapter/Other\nBack Focus \n[mm]","Spacer/Adapter/Ohter\nBack Focus \n[mm]",null,null,"Mechanical Clearance \nCheck List: \n"]
["#1","#1","#1",null,null,"Imager/FW with Guider",null,false]
[0,0,0]
[null,null,{"$f":"C25","v":0}]
["#2","#2","#2",null,null,"Imager/FW with Scope",null,false]
[0,0,0,null,null,"Visual Back, Focuser,"]
[{"$f":"A28","v":0},{"$f":"B28","v":0},{"$f":"C28","v":0},null,null,"Rotator, AO, …"]
["#3","#3","#3",null,null,"Optical Train with Mount",null,false]
[0,0,0,null,null,"Fork Mount",null,{"$f":"AND(H24,H27,H30)","v":false}]
[{"$f":"A31","v":0},{"$f":"B31","v":0},{"$f":"C31","v":0}]