{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Examples","Sheet1"],"not_rendered":{"charts":0,"images":0,"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":"Examples","index":0,"n_rows":21,"n_cols":21,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,1,3,4,5,7,8,11,14,11,18,13,14,15,16,17,18,19,20]
[null,"Series with NA",null,100,{"$f":"D4*1.05","v":105},{"$f":"E4*1.05","v":110.25},115.7625,121.55062500000001,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$f":"po()","v":{"$error":"#NAME?"}},1200,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E4","v":105},110.25,-1259,{"$f":"O4","v":110.25},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"O4","v":110.25},115.7625,121.55062500000001]
[null,"Series for Test",null,{"$f":"IFERROR(D4,FALSE)","v":100},{"$f":"IFERROR(E4,FALSE)","v":105},110.25,115.7625,121.55062500000001,false,false,false,1200,false,105,110.25,-1259,110.25,false,110.25,115.7625,121.55062500000001]
[]
[null,null,null,1,{"$f":"D7+1","v":2},{"$f":"E7+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,null,{"$f":"MATCH(D7,3:3,0)","v":4},{"$error":"#N/A"},5,6,7,{"$error":"#N/A"},8,9,{"$error":"#N/A"},{"$error":"#N/A"},10,{"$error":"#N/A"},14,11,16,17,18,13]
[]
[null,null,"Sum",{"$f":"SUM(4:4)","v":{"$error":"#N/A"}},"Excel",{"$f":"_xlfn.FORMULATEXT(D10)","v":"=SUM(4:4)"},null,"Max NA",{"$f":"max_na(4:4)","v":1200},"Entire Line",null,{"$f":"_xlfn.FORMULATEXT(I10)","v":"=max_na(4:4)"}]
[null,null,"Sum",{"$f":"SUM(5:5)","v":1166.6262500000003},"Test",{"$f":"_xlfn.FORMULATEXT(D11)","v":"=SUM(5:5)"},null,"Min NA",{"$f":"min_na(5:5)","v":-1259},"Entire Line",null,{"$f":"_xlfn.FORMULATEXT(I11)","v":"=min_na(5:5)"}]
[null,null,"Sum_na",{"$f":"sum_na(D4:U4)","v":1166.6262512207031},"Selected",{"$f":"_xlfn.FORMULATEXT(D12)","v":"=sum_na(D4:U4)"}]
[null,null,"Sum_adj",{"$f":"sum_adj(4:4)","v":1166.6262512207031},"Entire Line","=sum_adj(4:4)",null,"Max NA 1",{"$f":"max_na(D4:U4)","v":1200},"Selected",null,{"$f":"_xlfn.FORMULATEXT(I13)","v":"=max_na(D4:U4)"}]
[null,null,null,null,null,null,null,"Min NA 1",{"$f":"min_na(D4:U4)","v":-1259},"Selected",null,{"$f":"_xlfn.FORMULATEXT(I14)","v":"=min_na(D4:U4)"}]
[null,null,"here:"]
[null,null,"ALT-F8",null,null,null,null,"Average",{"$f":"AVERAGE(5:5)","v":89.740480769230786},"Test",null,{"$f":"_xlfn.FORMULATEXT(I16)","v":"=AVERAGE(5:5)"}]
[null,null,"Copy function",null,null,null,null,"AVG_NA",{"$f":"AVG_NA(D4:U4)","v":89.740480769230786},"Selected",null,{"$f":"_xlfn.FORMULATEXT(I17)","v":"=AVG_NA(D4:U4)"}]
[null,null,null,null,null,null,null,"AVG_NA",{"$f":"AVG_NA(4:4)","v":89.740480769230786},"Entire Line",null,{"$f":"_xlfn.FORMULATEXT(I18)","v":"=AVG_NA(4:4)"}]
[null,null,"Your Sheet"]
[null,null,"ALT F8"]
[null,null,"Paste function"]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}