{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["guide","calc","config"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"guide","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,32,8]]}
[]
[null,"Package: Reg\n\nAvailable functions:\n\nOutputLReg res = ols(y[], X[][], 0/1)\nwhere y[] is a range that represents dependable variable, X[][] is a range that represents exogenous variable, and 0/1 is an indicator whether constant is added or not to the regression;\n\ndouble[][] (double[]) get(OutputLReg res, String key)\nwhere key represents the key for a specific retrieved field. The following keys can be used:\n1. table-standard:  standard table output of the regression output;\n2. stats: regression statistics;\n3. y, yhat, res: dependent and projected variablles and residuals;\n4. XX, XX-INV, COV: matrices (XT x X), (XT x X)-1 and covariance matrix of estimated coefficients;"]

{"sheet":"calc","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TEST OF SET OBJECT"]
[]
[null,"Parameters"]
[null,"parameter","x1","x2","x3","parameter object"]
[null,"x-min",0.1,0.1,0.1,{"$f":"_xll.FS(\"AC.data.list_x\", C6:E6, 1, 1)","v":"java.util.ArrayList@Thu, 18 Jan 2018 19:53:25:653..2170293974657856558"}]
[null,"x-max",0.9,0.9,0.9,{"$f":"_xll.FS(\"AC.data.list_x\", C7:E7, 1, 1)","v":"java.util.ArrayList@Thu, 18 Jan 2018 19:53:25:654..5146256621131268085"}]
[null,"point-count",6,3,3,{"$f":"_xll.FS(\"AC.data.list_x\", C8:E8, 1, 1)","v":"java.util.ArrayList@Thu, 18 Jan 2018 19:53:25:652..8965743738809708571"}]
[null,null,null,null,null,null," "]
[null,"set parameters",{"$f":"_xll.FS(\"AC.data.map\", B6:B8, F6:F8)","v":"java.util.LinkedHashMap@Thu, 18 Jan 2018 19:53:25:656..6659261842140290088"}]
[null,"set object",{"$f":"_xll.FS(\"AC.test.set\", C10)","v":"jmathkr.lib.math.calculus.set.SetDiscreteRn@Thu, 18 Jan 2018 19:53:25:764..3977126197001369312"}]
[null,"set values",{"$f":"_xll.FS(\"AC.test.get\", C11, \"list-Rn\")","v":"java.util.ArrayList@Thu, 18 Jan 2018 19:53:32:841..6118731623791613080"}]
[null,null,null,{"$f":"_xll.FS(\"AC.data.size\", C12, 1)","v":54},{"$f":"_xll.FS(\"AC.data.size\", C12, 2)","v":3},null," "]
[]
[null,"Composite",null,null,null,null," "]
[]
[null,"set parameters",{"$f":"_xll.FS(\"AC.data.map\", B6:B8, C6:C8)","v":"java.util.LinkedHashMap@Thu, 18 Jan 2018 19:53:32:838..1736196870026628652"}]
[null,"set object",{"$f":"_xll.FS(\"AC.test.set\", C17)","v":"jmathkr.lib.math.calculus.set.SetDiscreteRn@Thu, 18 Jan 2018 19:53:25:764..3977126197001369312"}]
[null,"set values",{"$f":"_xll.FS(\"AC.test.get\", C18, \"list-Rn\")","v":"java.util.ArrayList@Thu, 18 Jan 2018 19:53:32:841..6118731623791613080"}]
[null,null,null,{"$f":"_xll.FS(\"AC.data.size\", C19, 1)","v":54},{"$f":"_xll.FS(\"AC.data.size\", C19, 2)","v":3},null," "]
[null,null,null,null,null,null," "]

{"sheet":"config","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: CONFIGURATION FILE"]
[]
[]
[null,"Path to xlloop jar file","C:\\Projects\\java\\data\\jcalc\\xlloop\\xlloop-ecolab.jar"]
[]
[null,"Test connection",{"$f":"_xll.FS(\"AC.test.connection\")","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cell address","Row count","Col count","Comment"]