{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Database","Date","Engineering","Finance","Information","Logical","Lookup","Math","Statistical","Text"],"not_rendered":{"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Database","index":0,"n_rows":45,"n_cols":15,"rows_kept":45}
["Database"]
["DAVERAGE",{"$f":"DAVERAGE(A24:E30,D2,A19:C21)","v":11.666666666666666},null,3]
["DCOUNT",{"$f":"DCOUNT(A24:E30,D2,A19:C21)","v":3}]
["DCOUNTA",{"$f":"DCOUNTA(A24:E30,D2,A19:C21)","v":3}]
["DGET",{"$f":"DGET(A24:E30,D2,A19:C20)","v":15}]
["DMAX",{"$f":"DMAX(A24:E30,D2,A19:C21)","v":15}]
["DMIN",{"$f":"DMIN(A24:E30,D2,A19:C21)","v":8}]
["DPRODUCT",{"$f":"DPRODUCT(A24:E30,D2,A19:C21)","v":1440}]
["DSTDEV",{"$f":"DSTDEV(A24:E30,D2,A19:A21)","v":5.057996968497839}]
["DSTDEVP",{"$f":"DSTDEVP(A24:E30,D2,A19:A21)","v":4.380353866983808}]
["DSUM",{"$f":"DSUM(A24:E30,D2,A19:C21)","v":35},null,{"$f":"B11-B2*B3","v":0}]
["DVAR",{"$f":"DVAR(A24:E30,D2,A19:C21)","v":12.333333333333343}]
["DVARP",{"$f":"DVARP(A24:E30,D2,A19:C21)","v":8.222222222222221}]
[]
["Pivot Table"]
["GETPIVOTDATA",{"$f":"GETPIVOTDATA(\"Sum of Qux\",B32)","v":57}]
[]
["Conditions"]
["Foo","Bar","Bar"]
["V8",">10","<16"]
["SM"]
[]
["Data"]
["Foo","Bar","Baz","Qux","Sna"]
["V8",18,20,14,105]
["SM",12,12,10,96]
["Nitro",13,14,9,105]
["V8",14,15,10,75]
["SM",9,8,8,76.8]
["V*",8,9,6,45]
[]
[null,"Sum of Qux","Column Labels"]
[null,null,8,"8 Total",9,"9 Total",12,"12 Total",13,"13 Total",14,"14 Total",18,"18 Total","Grand Total"]
[null,"Row Labels",45,null,76.8,null,96,null,105,null,75,null,105]
[null,"Nitro",{"$nulls":6},9,9,{"$nulls":4},9]
[null,14,{"$nulls":6},9,9,{"$nulls":4},9]
[null,"SM",null,null,8,8,10,10,{"$nulls":6},18]
[null,8,null,null,8,8,{"$nulls":8},8]
[null,12,{"$nulls":4},10,10,{"$nulls":6},10]
[null,"V*",6,6,{"$nulls":10},6]
[null,9,6,6,{"$nulls":10},6]
[null,"V8",{"$nulls":8},10,10,14,14,24]
[null,15,{"$nulls":8},10,10,null,null,10]
[null,20,{"$nulls":10},14,14,14]
[null,"Grand Total",6,6,8,8,10,10,9,9,10,10,14,14,57]

{"sheet":"Date","index":1,"n_rows":28,"n_cols":5,"rows_kept":28}
["Core"]
["DATE",{"$f":"DATE(C2,D2,E2)","v":"2013-06-09"},2013,6,9]
["DATEVALUE",{"$f":"DATEVALUE(C3)","v":25363},"June 9, 1969"]
["TIME",{"$f":"TIME(C4,D4,E4)","v":"06:09:23"},6,9,23]
["TIMEVALUE",{"$f":"TIMEVALUE(C5)","v":0.9748263888888888},"11:23:45 PM"]
["NOW",{"$f":"NOW()","v":"2013-05-05T21:06:01.510"}]
["TODAY",{"$f":"TODAY()","v":"2013-05-05"}]
[]
["Field Extraction"]
["YEAR",{"$f":"YEAR(B2)","v":2013}]
["MONTH",{"$f":"MONTH(B2)","v":6}]
["DAY",{"$f":"DAY(B2)","v":9}]
["HOUR",{"$f":"HOUR(B4)","v":6}]
["MINUTE",{"$f":"MINUTE(B4)","v":9}]
["SECOND",{"$f":"SECOND(B4)","v":23}]
["WEEKDAY",{"$f":"WEEKDAY(B2)","v":1}]
["WEEKNUM",{"$f":"WEEKNUM(B2)","v":24}]
[]
["Relative"]
["DATEDIF",{"$f":"DATEDIF(C20,D20,E20)","v":395},{"$f":"B2","v":"2013-06-09"},"2014-07-09","D"]
["DAYS360",{"$f":"DAYS360(C20,D20)","v":390}]
["EDATE",{"$f":"EDATE(B2,C22)","v":41526},3]
["EOMONTH",{"$f":"EOMONTH(B2,C23)","v":41547},3]
["NETWORKDAYS",{"$f":"NETWORKDAYS(C20,D20)","v":283}]
["NETWORKDAYS.INTL",{"$f":"NETWORKDAYS.INTL(C20,D20,C25)","v":340},17]
["WORKDAY",{"$f":"WORKDAY(C20,C26)","v":41605},123]
["WORKDAY.INTL",{"$f":"WORKDAY.INTL(C20,123,17)","v":41577}]
["YEARFRAC",{"$f":"YEARFRAC(C20,D20)","v":1.0833333333333333}]

{"sheet":"Engineering","index":2,"n_rows":50,"n_cols":5,"rows_kept":50}
["Bessel",null,"* FACTDOUBLE moved to Math"]
["BESSELI",{"$f":"BESSELI(C2,D2)","v":0.21273995970273565},2,3,{"$f":"BESSELI(-1,-1)","v":{"$error":"#NUM!"}}]
["BESSELJ",{"$f":"BESSELJ(C3,D3)","v":0.12894324997562717},2,3]
["BESSELK",{"$f":"BESSELK(C4,D4)","v":0.6473854},2,3]
["BESSELY",{"$f":"BESSELY(C5,D5)","v":-1.1277837651220644},2,3]
[]
["Error Function"]
["ERF",{"$f":"BESSELI(C8,D8)","v":1}]
["ERF.PRECISE",{"$f":"BESSELI(C9,D9)","v":1}]
["ERFC",{"$f":"BESSELI(C10,D10)","v":1}]
["ERFC.PRECISE",{"$f":"BESSELI(C11,D11)","v":1}]
[]
["Conversion"]
["CONVERT",{"$f":"CONVERT(C14,D14,E14)","v":-273.15},0,"K","C"]
["BIN2DEC",{"$f":"BIN2DEC(10)","v":2}]
["BIN2HEX",{"$f":"BIN2HEX(10)","v":"2"}]
["BIN2OCT",{"$f":"BIN2OCT(10)","v":"2"}]
["DEC2BIN",{"$f":"DEC2BIN(10)","v":"1010"}]
["DEC2HEX",{"$f":"DEC2HEX(10)","v":"A"}]
["DEC2OCT",{"$f":"DEC2OCT(10)","v":"12"}]
["OCT2BIN",{"$f":"OCT2BIN(10)","v":"1000"}]
["OCT2DEC",{"$f":"OCT2DEC(10)","v":8}]
["OCT2HEX",{"$f":"OCT2HEX(10)","v":"8"}]
["HEX2BIN",{"$f":"HEX2BIN(10)","v":"10000"}]
["HEX2DEC",{"$f":"HEX2DEC(10)","v":16}]
["HEX2OCT",{"$f":"HEX2OCT(10)","v":"20"}]
[]
["Dirac and Heaviside"]
["DELTA",{"$f":"DELTA(5)","v":0}]
["GESTEP",{"$f":"GESTEP(5)","v":1}]
[]
["Complex"]
["COMPLEX",{"$f":"COMPLEX(2,3)","v":"2+3i"},{"$f":"COMPLEX(2,3,\"j\")","v":"2+3j"}]
["IMABS",{"$f":"IMABS(C34)","v":3.6055512754639896},"2+3j"]
["IMAGINARY",{"$f":"IMAGINARY(C35)","v":3},"2+3j"]
["IMARGUMENT",{"$f":"IMARGUMENT(C36)","v":0.982793723247329},"2+3j"]
["IMCONJUGATE",{"$f":"IMCONJUGATE(C37)","v":"2-3j"},"2+3j"]
["IMCOS",{"$f":"IMCOS(C38)","v":"-4.18962569096881-9.10922789375534j"},"2+3j"]
["IMDIV",{"$f":"IMDIV(B43,B42)","v":"3.32192809488737-8.28846662730513E-15j"},"2+3j"]
["IMEXP",{"$f":"IMEXP(C40)","v":"-7.3151100949011+1.0427436562359j"},"2+3j"]
["IMLN",{"$f":"IMLN(C41)","v":"1.28247467873077+0.982793723247329j"},"2+3j"]
["IMLOG10",{"$f":"IMLOG10(C42)","v":"0.556971676153418+0.426821890855467j"},"2+3j"]
["IMLOG2",{"$f":"IMLOG2(C43)","v":"1.85021985907055+1.41787163074572j"},"2+3j"]
["IMPOWER",{"$f":"IMPOWER(C44,2)","v":"-5+12j"},"2+3j"]
["IMPRODUCT",{"$f":"IMPRODUCT(C45,D45)","v":"-10+24j"},"2+3j",{"$f":"COMPLEX(4,6,\"j\")","v":"4+6j"}]
["IMREAL",{"$f":"IMREAL(C46)","v":2},"2+3j"]
["IMSIN",{"$f":"IMSIN(C47)","v":"9.15449914691143-4.16890695996656j"},"2+3j"]
["IMSQRT",{"$f":"IMSQRT(C48)","v":"1.67414922803554+0.895977476129838j"},"2+3j"]
["IMSUB",{"$f":"IMSUB(C49,D49)","v":"-2-2j"},"2+3j",{"$f":"COMPLEX(4,5,\"j\")","v":"4+5j"}]
["IMSUM",{"$f":"IMSUM(C33:D50)","v":"48+70j"},"2+3j",{"$f":"COMPLEX(4,5,\"j\")","v":"4+5j"}]

{"sheet":"Finance","index":3,"n_rows":62,"n_cols":12,"rows_kept":62}
["Conversion"]
["DOLLARDE ",{"$f":"DOLLARDE(D2,E2)","v":1.125},null,1.02,16]
["DOLLARFR ",{"$f":"DOLLARFR(B2,E2)","v":1.02}]
["EFFECT ",{"$f":"EFFECT(D4,E4)","v":0.05354266737075841},null,{"v":0.0525,"d":"5.25%"},4]
["NOMINAL ",{"$f":"NOMINAL(B4,E4)","v":0.05250000000000021}]
[]
["Cash Flows"]
["IRR ",{"$f":"IRR(D8:I8,0.1)","v":{"v":0.08663094803652216,"d":"9%"}},null,-70000,12000,15000,18000,21000,26000]
["MIRR ",{"$f":"MIRR(D9:I9,J9,K9)","v":{"v":0.1260941303659051,"d":"13%"}},null,-120000,39000,30000,21000,37000,46000,{"v":0.1,"d":"10%"},{"v":0.12,"d":"12%"}]
["NPV ",{"$f":"NPV(D10,E10,F10,G10,H10)","v":{"v":1188.4434123352207,"d":"$1,188.44"}},null,{"v":0.1,"d":"10%"},-10000,3000,4200,6800]
["XIRR ",{"$f":"XIRR(E10:H10,E11:H11)","v":5.315237760543824},null,null,"2013-01-01","2013-02-01","2013-03-01","2013-04-01"]
["XNPV ",{"$f":"XNPV(B11,E10:H10,E11:H11)","v":-6.2115468608681113E-6}]
["FVSCHEDULE ",{"$f":"FVSCHEDULE(1,{0.09,0.11,0.1})","v":1.3308900000000004},{"$f":"FVSCHEDULE(1,D13:F13)","v":1.3308900000000004},0.09,0.11,0.1]
[]
["Annuities",null,null,"rate","nper","pmt","pv"]
["FV ",{"$f":"FV(D16/12,E16,F16,G16,1)","v":{"v":2581.4033740601185,"d":"$2,581.40"}},null,{"v":0.06,"d":"6%"},10,-200,-500]
["IPMT ",{"$f":"IPMT(D17/12,3,E17,G17)","v":{"v":-22.406893015924034,"d":"($22.41)"}},null,{"v":0.1,"d":"10%"},3,null,8000]
["ISPMT ",{"$f":"ISPMT(D18/12,1,E18*12,G18)","v":{"v":-64.81481481481482,"d":"($64.81)"}},null,{"v":0.1,"d":"10%"},3,null,8000]
["NPER ",{"$f":"NPER(D19/12,F19,G19)","v":-9.578594039813161},null,{"v":0.12,"d":"12%"},null,-100,-1000]
["PMT ",{"$f":"PMT(D17/12,E17,G17)","v":{"v":-2711.234054926808,"d":"($2,711.23)"}}]
["PPMT ",{"$f":"PPMT(D17/12,3,E17,G17)","v":{"v":-2688.827161910884,"d":"($2,688.83)"}}]
["PV ",{"$f":"PV(D22/12,12*E22,F22)","v":{"v":-59777.14585118782,"d":"($59,777.15)"}},null,{"v":0.08,"d":"8%"},20,500]
["RATE ",{"$f":"RATE(E23*12,F23,G23)*12","v":{"v":0.09241766985841642,"d":"9%"}},null,null,4,-200,8000]
["CUMIPMT ",{"$f":"CUMIPMT(D24/12,E24*12,F24,G24,H24,0)","v":-11135.232130750841},null,{"v":0.09,"d":"9%"},30,125000,13,24]
["CUMPRINC ",{"$f":"CUMPRINC(D24/12,E24*12,F24,G24,H24,0)","v":-934.1071234208979}]
[]
["Securities",null,null,"settlement","maturity","discount","pr","redemption"]
["TBILLEQ ",{"$f":"TBILLEQ(D29,E29,F28)","v":0.09415149356594302},{"$nulls":3},{"v":0.0914,"d":"9.14%"}]
["TBILLPRICE ",{"$f":"TBILLPRICE(D29,E29,F29)","v":98.45},null,"2008-03-31","2008-06-01",{"v":0.09,"d":"9%"},98.45]
["TBILLYIELD ",{"$f":"TBILLYIELD(D29,E29,G29)","v":0.09141696292534264}]
["PRICE ",{"$f":"PRICE(D31,E31,F31,G31,H31,I31)","v":94.63436162132213},null,"2008-02-15","2017-11-15",{"v":0.0575,"d":"5.75%"},{"v":0.065,"d":"6.50%"},100,2]
["YIELD ",{"$f":"YIELD(D32,E32,F32,G32,H32,I32)","v":0.06500000688073143},null,"2008-02-15","2016-11-15",{"v":0.0575,"d":"5.75%"},95.04287,100,2]
["DISC ",{"$f":"DISC(D33,E33,G33,H33)","v":0.05207142857142884},null,"2007-01-25","2007-06-15",null,97.975,100]
["PRICEDISC ",{"$f":"PRICEDISC(D34,E34,F34,H34,SQRT(4))","v":99.79583333333333},null,"2008-02-16","2008-03-01",{"v":0.0525,"d":"5.25%"},null,100]
["YIELDDISC ",{"$f":"YIELDDISC(D34,E34,G35,H34,LOG(100)/LOG(10))","v":0.05282257198685834},{"$nulls":4},99.795]
["PRICEMAT ",{"$f":"PRICEMAT(D36,E36,F36,G36,G36,H36)","v":99.98449887555694},null,"2008-02-15","2008-04-13","2007-11-11",{"v":0.061,"d":"6.10%"},"00:00:00"]
["YIELDMAT ",{"$f":"YIELDMAT(D37,E37,F37,G37,H37,I37)","v":0.06095433369153867},null,"2008-03-15","2008-11-03","2007-11-08",{"v":0.0625,"d":"6.25%"},100.0123,0]
["DURATION ",{"$f":"DURATION(D38,E38,F38,G38,H38,I38)","v":5.993774955545186},null,"2008-01-01","2016-01-01",{"v":0.08,"d":"8%"},{"v":0.09,"d":"9%"},2,1]
["MDURATION ",{"$f":"MDURATION(D38,E38,F38,G38,H38,I38)","v":5.735669813918839}]
["ACCRINT ",{"$f":"ACCRINT(D40,E40,F40,G40,H40,I40,J40)","v":16.666666666666664},null,"2008-03-01","2008-08-31","2008-05-01",{"v":0.1,"d":"10%"},1000,2,0]
["ACCRINTM ",{"$f":"ACCRINTM(D41,E41,G41,H41,I41)","v":20.54794520547945},null,"2008-04-01","2008-06-15",null,{"v":0.1,"d":"10%"},1000,3]
["INTRATE ",{"$f":"INTRATE(D42,E42,F42,G42,H42)","v":0.05768},null,"2008-02-15","2008-05-15",1000000,1014420,2]
["RECEIVED ",{"$f":"RECEIVED(D43,E43,F43,G43,H43)","v":1014584.6544071021},null,"2008-02-15","2008-05-15",1000000,{"v":0.0575,"d":"5.75%"},2]
["ODDFPRICE ",{"$f":"ODDFPRICE(D44,E44,F44,G44,H44,I44,J44,K44,L44)","v":113.59771747407883},null,"2008-11-11","2021-03-01","2008-10-15","2009-03-01",{"v":0.0785,"d":"7.85%"},{"v":0.0625,"d":"6.25%"},100,2,1]
["ODDFYIELD ",{"$f":"ODDFYIELD(D45,E45,F45,G45,H45,I45,J45,K45,L45)","v":0.07724554159729888},null,"2008-11-11","2021-03-01","2008-10-15","2009-03-01",{"v":0.0575,"d":"5.75%"},84.5,100,2,0]
["ODDLPRICE ",{"$f":"ODDLPRICE(D46,E46,F46,G46,H46,I46,J46,K46)","v":110.88286909824446},null,"2008-11-11","2021-03-01","2008-10-15",{"v":0.0785,"d":"7.85%"},{"v":0.0625,"d":"6.25%"},100,2,0]
["ODDLYIELD ",{"$f":"ODDLYIELD(D47,E47,F47,G47,H47,I47,J47,K47)","v":0.08254808631495333},null,"2008-11-11","2021-03-01","2008-10-15",{"v":0.0575,"d":"5.75%"},84.5,100,2,0]
["COUPDAYBS ",{"$f":"COUPDAYBS(D48,E48,F48,G48)","v":71},null,{"$f":"DATE(2007,1,25)","v":"2007-01-25"},{"$f":"DATE(2008,11,15)","v":"2008-11-15"},2,1]
["COUPDAYS ",{"$f":"COUPDAYS(D48,E48,F48,G48)","v":181}]
["COUPDAYSNC ",{"$f":"COUPDAYSNC(D48,E48,F48,G48)","v":110}]
["COUPNCD ",{"$f":"COUPNCD(D48,E48,F48,G48)","v":"2007-05-15"}]
["COUPNUM ",{"$f":"COUPNUM(D48,E48,F48,G48)","v":4}]
["COUPPCD ",{"$f":"COUPPCD(D48,E48,F48,G48)","v":39036}]
[]
["Depreciation",null,null,"cost","salvage","life","period"]
["DB ",{"$f":"DB(D56,E56,F56,G56,H56)","v":{"v":55841.756736028445,"d":"$55,841.76"}},null,1000000,100000,6,6,7]
["DDB ",{"$f":"DDB(D57,E57,F57*365,G57)","v":{"v":1.3143479076749858,"d":"$1.31"}},null,2400,300,10,2]
["SLN ",{"$f":"SLN(D59,E59,F59)","v":{"v":2250,"d":"$2,250.00"}}]
["SYD ",{"$f":"SYD(D59,E59,F59,G59)","v":{"v":409.09090909090907,"d":"$409.09"}},null,30000,7500,10,10]
["VDB ",{"$f":"VDB(D57,E57,F57*365,5,9)","v":{"v":5.24156794233124,"d":"$5.24"}},null,"cost","salvage","rate","period","datepurc","datefirst"]
["AMORDEGRC ",{"$f":"AMORDEGRC(D62,H62,I62,E62,G62,F62)","v":767}]
["AMORLINC ",{"$f":"AMORLINC(D62,H62,I62,E62,G62,F62)","v":360},null,2400,300,{"v":0.15,"d":"15%"},1,"2008-08-09","2008-12-31"]

{"sheet":"Information","index":4,"n_rows":17,"n_cols":3,"rows_kept":17}
["CELL",{"$f":"CELL(C1,D1)","v":"$D$1"},"address"]
["ERROR.TYPE",{"$f":"ERROR.TYPE(#VALUE!)","v":3},{"$f":"0/0","v":{"$error":"#DIV/0!"}}]
["INFO",{"$f":"INFO(C3)","v":"14.3"},"release"]
["ISBLANK",{"$f":"ISBLANK(C4)","v":true}]
["ISERR",{"$f":"ISERR(C5)","v":false}]
["ISERROR",{"$f":"ISERROR(C2)","v":true}]
["ISEVEN",{"$f":"ISEVEN(C7)","v":false},7]
["ISLOGICAL",{"$f":"ISLOGICAL(C8)","v":true},true]
["ISNA",{"$f":"ISNA(C9)","v":true},{"$f":"NA()","v":{"$error":"#N/A"}}]
["ISNONTEXT",{"$f":"ISNONTEXT(C10)","v":true},3]
["ISNUMBER",{"$f":"ISNUMBER(C11)","v":false},"3"]
["ISODD",{"$f":"ISODD(C12)","v":true},"3"]
["ISREF",{"$f":"ISREF(\"address\")","v":false},"A5"]
["ISTEXT",{"$f":"ISTEXT(C14)","v":false},3]
["N",{"$f":"N(C15)","v":1},true]
["NA",{"$f":"NA()","v":{"$error":"#N/A"}}]
["TYPE",{"$f":"TYPE({1,2;3,4})","v":64}]

{"sheet":"Logical","index":5,"n_rows":12,"n_cols":4,"rows_kept":12}
["Singletons"]
["FALSE",{"$f":"FALSE()","v":false}]
["TRUE",{"$f":"TRUE()","v":true}]
[]
["Operators"]
["AND",{"$f":"AND(C6,D6)","v":false},true,false]
["NOT",{"$f":"NOT(C6)","v":false}]
["OR",{"$f":"OR(C6,D6)","v":true}]
[]
["Conditionals"]
["IF",{"$f":"IF(B8,C11,D11)","v":123},123,456]
["IFERROR",{"$f":"IFERROR(C12,D12)","v":456},{"$f":"0/0","v":{"$error":"#DIV/0!"}},456]

{"sheet":"Lookup","index":6,"n_rows":26,"n_cols":5,"rows_kept":26}
["Reference Info"]
["COLUMN",{"$f":"COLUMN(C2)","v":3}]
["ROW",{"$f":"ROW(C3)","v":3}]
["COLUMNS",{"$f":"COLUMNS(A10:D21)","v":4}]
["ROWS",{"$f":"ROWS(A10:D21)","v":12}]
["INDIRECT",{"$f":"INDIRECT(C6)","v":"ADDRESS"},"A10"]
["AREAS",{"$f":"AREAS((B7:D14,E2,F4:H16))","v":3}]
[]
["Relative"]
["ADDRESS",{"$f":"ADDRESS(2,2)","v":"$B$2"}]
["OFFSET",{"$f":"OFFSET(C11,D11,E11)","v":0},"C14",-1,0]
[]
["Lookup"]
["CHOOSE",{"$f":"CHOOSE(C14,A10,A7,A14,#REF!,A2,A4,A15,A23,A16,A17)","v":"CHOOSE"},3]
["HLOOKUP",{"$f":"HLOOKUP(C15,A10:C21,10,FALSE)","v":"LOOKUP (arr)"},"ADDRESS"]
["INDEX (ref)",{"$f":"INDEX(A1:D21,C16,D16)","v":"ADDRESS"},6,2]
["INDEX (arr)",{"$f":"INDEX({1,2;3,4},C17,D17)","v":3},2,1]
["LOOKUP (ref)",{"$f":"LOOKUP(C18,A10:A21)","v":"MATCH"},"NIGGLER"]
["LOOKUP (arr)",{"$f":"LOOKUP(3,{1,2,2.5,4,5,6,7,8,9})","v":2.5}]
["MATCH",{"$f":"MATCH(C20,A10:A21)","v":11},"NIGGLER"]
["VLOOKUP",{"$f":"VLOOKUP(C21,A10:E21,D21)","v":"MATCH"},"NIGGLER",1]
[]
["HYPERLINK",{"$f":"HYPERLINK(\"http://nig.gl\",\"niggler\")","v":"niggler"}]
[]
["Array Formula"]
["TRANSPOSE",{"$f":"TRANSPOSE(A2:A4)","v":"COLUMN"},"ROW","COLUMNS"]

{"sheet":"Math","index":7,"n_rows":70,"n_cols":11,"rows_kept":70}
[1,2,3,4,5,6,7,8,9,10,11]
["ABS",{"$f":"ABS(B1)","v":2},5,6,7,8]
["ACOS",{"$f":"ACOS(1/B1)","v":1.0471975511965976}]
["ACOSH",{"$f":"ACOSH(B1)","v":1.3169578969248166}]
["AGGREGATE",{"$f":"_xlfn.AGGREGATE(A1,B1,C1:K1)","v":7}]
["ASIN",{"$f":"ASIN(1/B1)","v":0.5235987755982989}]
["ASINH",{"$f":"ASINH(B1)","v":1.4436354751788103}]
["ATAN",{"$f":"ATAN(B1)","v":1.1071487177940904}]
["ATAN2",{"$f":"ATAN2(A1,B1)","v":1.1071487177940904}]
["ATANH",{"$f":"ATANH(1/B1)","v":0.5493061443340549}]
["CEILING",{"$f":"CEILING(B1,C1)","v":3}]
["CEILING.PRECISE",{"$f":"_xlfn.CEILING.PRECISE(B1,C1)","v":3}]
["COMBIN",{"$f":"COMBIN(D1,C1)","v":4}]
["COS",{"$f":"COS(B1)","v":-0.4161468365471424}]
["COSH",{"$f":"COSH(B1)","v":3.7621956910836314}]
["DEGREES",{"$f":"DEGREES(B1)","v":114.59155902616465}]
["ECMA.CEILING",{"$f":"ECMA.CEILING(B2,2)","v":2},{"$nulls":3},"* not mentioned in summary"]
["EVEN",{"$f":"EVEN(B1)","v":2}]
["EXP",{"$f":"EXP(B1)","v":7.38905609893065}]
["FACT",{"$f":"FACT(B1)","v":2}]
["FACTDOUBLE",{"$f":"FACTDOUBLE(E1)","v":15},{"$nulls":3},"* originally in engineering"]
["FLOOR",{"$f":"FLOOR(B1,C1)","v":0}]
["FLOOR.PRECISE",{"$f":"_xlfn.FLOOR.PRECISE(B1,C1)","v":0}]
["GAMMALN",{"$f":"GAMMALN(C24)","v":3.1780538303479458},5,null,null,"* originally in statistical"]
["GAMMALN.PRECISE",{"$f":"_xlfn.GAMMALN.PRECISE(C24)","v":3.1780538303479458},{"$nulls":3},"* originally in statistical"]
["GCD",{"$f":"GCD(F1,J1)","v":2}]
["INT",{"$f":"INT(B1)","v":2}]
["ISO.CEILING",{"$f":"ISO.CEILING(F1)","v":6}]
["LCM",{"$f":"LCM(F1,I1)","v":18}]
["LN",{"$f":"LN(I1)","v":2.1972245773362196}]
["LOG",{"$f":"LOG(J1)","v":1}]
["LOG10",{"$f":"LOG10(E1)","v":0.6989700043360189}]
["MDETERM",{"$f":"MDETERM(C1:D2)","v":-2.0000000000000018}]
["MINVERSE",{"$f":"MINVERSE(C1:D2)","v":-2.9999999999999973}]
["MMULT",{"$f":"MMULT(C1:D2,E1:F2)","v":43}]
["MOD",{"$f":"MOD(E2,E1)","v":2}]
["MROUND",{"$f":"MROUND(C1,D1)","v":4}]
["MULTINOMIAL",{"$f":"MULTINOMIAL(J1,E1,C1)","v":2450448}]
["ODD",{"$f":"ODD(F1)","v":7}]
["PERMUT",{"$f":"PERMUT(F2,E1)","v":6720},{"$nulls":3},"* originally in statistical"]
["PI",{"$f":"PI()","v":3.141592653589793}]
["POWER",{"$f":"POWER(C1,D1)","v":81}]
["PRODUCT",{"$f":"PRODUCT(C1,D1,E1)","v":60}]
["QUOTIENT",{"$f":"QUOTIENT(E2,C1)","v":2}]
["RADIANS",{"$f":"RADIANS(E1)","v":0.08726646259971647}]
["RAND",{"$f":"RAND()","v":0.16104002347522117}]
["RANDBETWEEN",{"$f":"RANDBETWEEN(D1,E2)","v":5}]
["ROMAN",{"$f":"ROMAN(B1)","v":"II"},{"$f":"ROMAN(B1,C1)","v":"II"}]
["ROUND",{"$f":"ROUND(E1,D2)","v":5}]
["ROUNDDOWN",{"$f":"ROUNDDOWN(F1,H1)","v":6}]
["ROUNDUP",{"$f":"ROUNDUP(C1,B2)","v":3}]
["SERIESSUM",{"$f":"SERIESSUM(C1,C2,D2,D1:K1)","v":2.928421387459129E+23}]
["SIGN",{"$f":"SIGN(D2)","v":1}]
["SIN",{"$f":"SIN(E1)","v":-0.9589242746631385}]
["SINH",{"$f":"SINH(D2)","v":201.71315737027922}]
["SQRT",{"$f":"SQRT(C1)","v":1.7320508075688772}]
["SQRTPI",{"$f":"SQRTPI(B2)","v":2.5066282746310002}]
["STANDARDIZE",{"$f":"STANDARDIZE(C58,D58,E58)","v":0.2},3,2,5,"* originally in statistical"]
["SUBTOTAL",{"$f":"SUBTOTAL(A1,B1,C1:K1)","v":6.5}]
["SUM",{"$f":"SUM(B1)","v":2},{"$f":"SUM(B1:K1)","v":65},{"$f":"SUM(B1:K1,B2:F2)","v":93}]
["SUMIF",{"$f":"SUMIF(C1:C2,\">3\")","v":5},{"$f":"SUMIF(C1:C2,\">3\",D1:D2)","v":6}]
["SUMIFS",{"$f":"SUMIFS(C1:C2,D1:D2,\">0\",E1:E2,\"<7\")","v":3}]
["SUMPRODUCT",{"$f":"SUMPRODUCT(C1:K1)","v":63},{"$f":"SUMPRODUCT(C1:F1,C2:F2)","v":122}]
["SUMSQ",{"$f":"SUMSQ(C1,D2)","v":45},{"$f":"SUMSQ(D2,E1,F2)","v":125}]
["SUMX2MY2",{"$f":"SUMX2MY2(C1:F1,C2:F2)","v":-88}]
["SUMX2PY2",{"$f":"SUMX2PY2(C1:F1,C2:F2)","v":260}]
["SUMXMY2",{"$f":"SUMXMY2(C1:F1,C2:F2)","v":16}]
["TAN",{"$f":"TAN(C2)","v":-3.380515006246586}]
["TANH",{"$f":"TANH(C1)","v":0.9950547536867306}]
["TRUNC",{"$f":"TRUNC(C1,F2)","v":3}]

{"sheet":"Statistical","index":8,"n_rows":144,"n_cols":10,"rows_kept":144}
["Distributions"]
["BETA.DIST",{"$f":"_xlfn.BETA.DIST(C2,D2,E2,F2)","v":1.5},0.5,2,2,false]
["BETA.INV",{"$f":"_xlfn.BETA.INV(C3,D3,E3)","v":0.5},0.5,2,2]
["BETADIST",{"$f":"BETADIST(C4,D4,E4)","v":0.5},0.5,2,2]
["BETAINV",{"$f":"BETAINV(C5,D5,E5)","v":0.5},0.5,2,2]
["BINOM.DIST",{"$f":"_xlfn.BINOM.DIST(C6,D6,E6,F6)","v":0.9526510126000001},5,10,0.3,true]
["BINOM.INV",{"$f":"_xlfn.BINOM.INV(C7,D7,E7)","v":7},20,0.5,0.1,true]
["BINOMDIST",{"$f":"BINOMDIST(C8,D8,E8,F8)","v":0.10291934520000003},5,10,0.3,false]
["CHIDIST",{"$f":"CHIDIST(C9,D9)","v":0.6599632296942826},5,7]
["CHIINV",{"$f":"CHIINV(B9,D9)","v":5}]
["CHISQ.DIST",{"$f":"_xlfn.CHISQ.DIST(C11,D11,E11)","v":0.3400367703057174},5,7,true]
["CHISQ.DIST.RT",{"$f":"_xlfn.CHISQ.DIST.RT(C11,D11)","v":0.6599632296942826}]
["CHISQ.INV",{"$f":"_xlfn.CHISQ.INV(B11,D11)","v":5}]
["CHISQ.INV.RT",{"$f":"_xlfn.CHISQ.INV.RT(B12,D11)","v":5}]
["CONFIDENCE",{"$f":"CONFIDENCE(C15,D15,E15)","v":0.103643338949379},0.3,1,100]
["CONFIDENCE.NORM",{"$f":"_xlfn.CONFIDENCE.NORM(C16,D16,E16)","v":0.103643338949379},0.3,1,100]
["CONFIDENCE.T",{"$f":"_xlfn.CONFIDENCE.T(C17,D17,E17)","v":0.10418907592517826},0.3,1,100]
["CRITBINOM",{"$f":"CRITBINOM(C18,D18,E18)","v":64},120,0.5,0.75]
["EXPON.DIST",{"$f":"_xlfn.EXPON.DIST(C19,D19,E19)","v":0.8646647167633873},1,2,true]
["EXPONDIST",{"$f":"EXPONDIST(C20,D20,E20)","v":0.2706705664732254},1,2,false]
["F.DIST",{"$f":"_xlfn.F.DIST(C21,D21,E21,F21)","v":0.53524199845511},1,2,3,true]
["F.DIST.RT",{"$f":"_xlfn.F.DIST.RT(C21,D21,E21)","v":0.46475800154489}]
["F.INV",{"$f":"_xlfn.F.INV(B21,D21,E21)","v":1.0000000000000002}]
["F.INV.RT",{"$f":"_xlfn.F.INV.RT(B22,D21,E21)","v":1.0000000000000002}]
["FDIST",{"$f":"FDIST(C25,D25,E25)","v":0.17355371900826444},5,4,2]
["FINV",{"$f":"FINV(B25,D25,E25)","v":5.000000000000001}]
["FISHER",{"$f":"FISHER(C27)","v":0.5493061443340549},0.5]
["FISHERINV",{"$f":"FISHERINV(B27)","v":0.5000000000000001}]
["GAMMA.DIST",{"$f":"_xlfn.GAMMA.DIST(C29,D29,E29,F29)","v":0.3849400110633042},4,2,3,true]
["GAMMA.INV",{"$f":"_xlfn.GAMMA.INV(B29,D29,E29)","v":3.999999999999999}]
["GAMMADIST",{"$f":"GAMMADIST(C29,D29,E29,F29)","v":0.3849400110633042}]
["GAMMAINV",{"$f":"GAMMAINV(B31,D29,E29)","v":3.999999999999999}]
["HYPGEOM.DIST",{"$f":"_xlfn.HYPGEOM.DIST(C33,D33,E33,F33,G33)","v":0.41666666666666635},1,2,7,9,5]
["HYPGEOMDIST",{"$f":"HYPGEOMDIST(C34,D34,E34,F34)","v":0.5357142857142857},2,3,6,8]
["LOGINV",{"$f":"LOGINV(C35,D35,E35)","v":148.4131591025766},0.5,5,5]
["LOGNORM.DIST",{"$f":"_xlfn.LOGNORM.DIST(C36,D36,E36,F36)","v":0.34457825838967576},1,2,5,true]
["LOGNORM.INV",{"$f":"_xlfn.LOGNORM.INV(B36,D36,E36)","v":0.9999999999999987}]
["LOGNORMDIST",{"$f":"LOGNORMDIST(C36,D36,E36)","v":0.34457825838967576}]
["NEGBINOM.DIST",{"$f":"_xlfn.NEGBINOM.DIST(C39,D39,E39,F39)","v":0.03860084305800001},5,7,0.3,true]
["NEGBINOMDIST",{"$f":"NEGBINOMDIST(C39,D39,E39)","v":0.016981691958000006},5,7,0.3]
["NORM.DIST",{"$f":"_xlfn.NORM.DIST(C41,D41,E41,F41)","v":0.6305586598182364},0,-1,3,true]
["NORM.INV",{"$f":"_xlfn.NORM.INV(B41,D41,E41)","v":8.881784197001252e-16}]
["NORM.S.DIST",{"$f":"_xlfn.NORM.S.DIST(C43,D43)","v":0.9986501019683699},3,true]
["NORM.S.INV",{"$f":"_xlfn.NORM.S.INV(B43)","v":2.999999999999997}]
["NORMDIST",{"$f":"NORMDIST(C41,D41,E41,F41)","v":0.6305586598182364}]
["NORMINV",{"$f":"NORMINV(B45,D41,E41)","v":8.881784197001252e-16}]
["NORMSDIST",{"$f":"NORMSDIST(C47)","v":0.9772498680518208},2]
["NORMSINV",{"$f":"NORMSINV(B47)","v":2}]
["POISSON",{"$f":"POISSON(C49,D49,E49)","v":0.4060058497098381},1,2,true]
["POISSON.DIST",{"$f":"_xlfn.POISSON.DIST(C50,D50,E50)","v":0.27067056647322535},1,2,false]
["T.DIST",{"$f":"_xlfn.T.DIST(C51,D51,E51)","v":0.9900289369340037},3,7,true]
["T.DIST.2T",{"$f":"_xlfn.T.DIST.2T(C51,D51)","v":0.01994212613199254}]
["T.DIST.RT",{"$f":"_xlfn.T.DIST.RT(C51,D51)","v":0.00997106306599627}]
["T.INV",{"$f":"_xlfn.T.INV(B51,D51)","v":3}]
["T.INV.2T",{"$f":"_xlfn.T.INV.2T(B52,D51)","v":3}]
["TDIST",{"$f":"TDIST(C56,D56,E56)","v":0.01994212613199254},3,7,2]
["TINV",{"$f":"TINV(B56,D56)","v":3}]
["WEIBULL",{"$f":"WEIBULL(C58,D58,E58,F58)","v":0.22119921692859512},0.5,2,1,true]
["WEIBULL.DIST",{"$f":"_xlfn.WEIBULL.DIST(C59,D59,E59,F59)","v":0.7788007830714049},0.5,2,1,false]
[]
["Descriptive Statistics"]
["AVEDEV",{"$f":"AVEDEV(C62:I62,J62,ROW(B62))","v":31.78125},1,2,4,8,16,32,true,128]
["AVERAGE",{"$f":"AVERAGE(C63:I63,J63,ROW(B63))","v":31.75},1,2,4,8,16,32,true,128]
["AVERAGEA",{"$f":"AVERAGEA(C64:I64,J64,ROW(B64))","v":28.444444444444443},1,2,4,8,16,32,true,128]
["AVERAGEIF",{"$f":"AVERAGEIF(C65:I65,J65)","v":3.75},1,2,4,8,16,32,true,"<10"]
["AVERAGEIFS",{"$f":"AVERAGEIFS(C66:I66,C66:I66,\">3\",C66:I66,\"<20\")","v":9.333333333333334},1,2,4,8,16,32,true,"<10"]
["CORREL",{"$f":"CORREL({2,1,3,4,7,11},C67:H67)","v":0.9862413826124554},1,2,3,5,8,13]
["COUNT",{"$f":"COUNT(C68:J68)","v":6},1,2,4,8,16,32,true]
["COUNTA",{"$f":"COUNTA(C69:J69)","v":7},1,2,4,8,16,32,true]
["COUNTBLANK",{"$f":"COUNTBLANK(C70:J70)","v":1},1,2,4,8,16,32,true]
["COUNTIF",{"$f":"COUNTIF(C71:I71,J71)","v":2},1,2,4,8,16,32,true,">10"]
["COUNTIFS",{"$f":"COUNTIFS(C72:I72,J72,C72:I72,J71)","v":1},1,2,4,8,16,32,true,"<30"]
["COVAR",{"$f":"COVAR(C73:H73,C74:H74)","v":36.333333333333336},1,2,4,8,16,32,true]
["COVARIANCE.P",{"$f":"_xlfn.COVARIANCE.P(C73:H73,C74:H74)","v":36.333333333333336},2,1,3,4,7,11,18]
["COVARIANCE.S",{"$f":"_xlfn.COVARIANCE.S(C73:H73,C74:H74)","v":43.6}]
["DEVSQ",{"$f":"DEVSQ(C76:I76)","v":703.5},1,2,4,8,16,32,true]
["GEOMEAN",{"$f":"GEOMEAN(C77:I77)","v":5.65685424949238},1,2,4,8,16,32,true]
["HARMEAN",{"$f":"HARMEAN(C78:I78)","v":3.0476190476190474},1,2,4,8,16,32,true]
["KURT",{"$f":"KURT(C79:I79)","v":1.8749535902576664},1,2,4,8,16,32,true]
["LARGE",{"$f":"LARGE(C80:H80,I80)","v":8},1,2,4,8,16,32,3]
["MAX",{"$f":"MAX(C81:H81,I81)","v":32},1,2,4,8,16,32,3]
["MAXA",{"$f":"MAXA(C82:H82,I82)","v":32},1,2,4,8,16,32,3]
["MEDIAN",{"$f":"MEDIAN(C83:I83)","v":4},1,2,4,8,16,32,3]
["MIN",{"$f":"MIN(C84:I84)","v":1},1,2,4,8,16,32,3]
["MINA",{"$f":"MINA(C85:I85)","v":1},1,2,4,8,16,32,3]
["MODE",{"$f":"MODE(C86:I86)","v":16},1,2,4,8,16,16,3]
["MODE.MULT",{"$f":"_xlfn.MODE.MULT(C87:I87)","v":8},1,2,4,8,8,32,3]
["MODE.SNGL",{"$f":"_xlfn.MODE.SNGL(1,2,3,4,3,2,1,2,1,2,2)","v":2}]
["PERCENTILE",{"$f":"PERCENTILE(C89:H89,I89)","v":3},1,2,4,8,16,32,0.3]
["PERCENTILE.EXC",{"$f":"_xlfn.PERCENTILE.EXC(C90:H90,I90)","v":6},1,2,4,8,16,32,0.5]
["PERCENTILE.INC",{"$f":"_xlfn.PERCENTILE.INC(C91:H91,I91)","v":12},1,2,4,8,16,32,0.7]
["PERCENTRANK",{"$f":"PERCENTRANK(C92:H92,I92)","v":0.65},1,2,4,8,16,32,10]
["PERCENTRANK.EXC",{"$f":"_xlfn.PERCENTRANK.EXC(C93:H93,I93)","v":0.75},1,2,4,8,16,32,20]
["PERCENTRANK.INC",{"$f":"_xlfn.PERCENTRANK.INC(C94:H94,I94)","v":0.975},1,2,4,8,16,32,30]
["QUARTILE",{"$f":"QUARTILE(C95:H95,I95)","v":14},1,2,4,8,16,32,3]
["QUARTILE.EXC",{"$f":"_xlfn.QUARTILE.EXC(C96:H96,I96)","v":6},1,2,4,8,16,32,2]
["QUARTILE.INC",{"$f":"_xlfn.QUARTILE.INC(C97:H97,I97)","v":2.5},1,2,4,8,16,32,1]
["RANK",{"$f":"RANK(4,C98:H98)","v":4},1,2,4,8,16,32,"RANK(2,{4,6,8,7,5,3,1,2},2)"]
["RANK.AVG",{"$f":"_xlfn.RANK.AVG(4,C99:H99)","v":4},1,2,4,8,16,32,"* note that the docs say you can specify an array"]
["RANK.EQ",{"$f":"_xlfn.RANK.EQ(4,C100:H100)","v":4},1,2,4,8,16,32,"* but it appears that excel 2011 falters on those"]
["SKEW",{"$f":"SKEW(C101:H101)","v":1.499692957860436},1,2,4,8,16,32]
["SMALL",{"$f":"SMALL(C102:H102,I102)","v":4},1,2,4,8,16,32,3]
["STDEV",{"$f":"STDEV(C103:H103,I103)","v":13.098527725337247},1,2,4,8,16,32,30]
["STDEV.P",{"$f":"_xlfn.STDEV.P(C104:H104,I104)","v":12.126880245545262},1,2,4,8,16,32,30]
["STDEV.S",{"$f":"_xlfn.STDEV.S(C105:H105,I105)","v":13.098527725337247},1,2,4,8,16,32,30]
["STDEVA",{"$f":"STDEVA(C106:H106,I106)","v":13.098527725337247},1,2,4,8,16,32,30]
["STDEVP",{"$f":"STDEVP(C107:H107,I107)","v":12.126880245545262},1,2,4,8,16,32,30]
["STDEVPA",{"$f":"STDEVPA(C108:H108,I108)","v":12.126880245545262},1,2,4,8,16,32,30]
["TRIMMEAN"]
["VAR",{"$f":"VAR(C110:H110,I110)","v":171.57142857142856},1,2,4,8,16,32,30]
["VAR.P",{"$f":"_xlfn.VAR.P(C111:H111,I111)","v":147.0612244897959},1,2,4,8,16,32,30]
["VAR.S",{"$f":"_xlfn.VAR.S(C112:H112,I112)","v":171.57142857142856},1,2,4,8,16,32,30]
["VARA",{"$f":"VARA(C113:H113,I113)","v":171.57142857142856},1,2,4,8,16,32,30]
["VARP",{"$f":"VARP(C114:H114,I114)","v":147.0612244897959},1,2,4,8,16,32,30]
["VARPA",{"$f":"VARPA(C115:H115,I115)","v":147.0612244897959},1,2,4,8,16,32,30]
[]
["Statistical Tests"]
["CHISQ.TEST",{"$f":"_xlfn.CHISQ.TEST(D118:I118,D119:I119)","v":0.7664919367465142},null,1,2,3,4,5,6]
["CHITEST",{"$f":"CHITEST(D119:I119,D118:I118)","v":0.551818040730027},null,1.1,2.2,3.1,7,4,9]
["F.TEST",{"$f":"_xlfn.F.TEST(D118:I118,D119:I119)","v":0.3177442387481683}]
["FTEST",{"$f":"FTEST(D119:I119,D118:I118)","v":0.3177442387481683}]
["T.TEST",{"$f":"_xlfn.T.TEST(D118:I118,D119:I119,C122,D122)","v":0.551133456944575},2,3]
["TTEST",{"$f":"TTEST(D118:I118,D119:I119,C122,D122)","v":0.551133456944575}]
["Z.TEST",{"$f":"_xlfn.Z.TEST(D124:I124,C124)","v":0.39075564749935676},3,1,2,3,4,5,4]
["ZTEST",{"$f":"ZTEST(D124:I124,C124,C125)","v":0.46746265582105867},5]
[]
["Regression and Friends"]
["FORECAST",{"$f":"FORECAST(C128,D129:I129,D128:I128)","v":19.628571428571426},10,1,2,3,4,5,6]
["FREQUENCY",{"$f":"FREQUENCY(D128:I128,D129:I129)","v":2},null,2,4,6,8,11,11]
["GROWTH",{"$f":"GROWTH(D129:I129,D128:I128)","v":2.5725901588088202},null,0.1,0.1,0.2,0.2,0.2,0.2]
["INTERCEPT",{"$f":"INTERCEPT(D129:I129,D128:I128)","v":0.20000000000000018}]
["PROB",{"$f":"PROB(D128:I128,D130:I130,C132,D132)","v":0.4},2.1,4.5]
["PEARSON",{"$f":"PEARSON(D118:I118,D119:I119)","v":0.8646992925647675}]
["RSQ",{"$f":"RSQ(D129:I129,D128:I128)","v":0.9714285714285714}]
["SLOPE",{"$f":"SLOPE(D129:I129,D128:I128)","v":1.9428571428571428}]
["STEYX",{"$f":"STEYX(D129:I129,D128:I128)","v":0.6969320524371684}]
[{"$nulls":3},"LINEST (n+1 by 5)",{"$nulls":3},"LOGEST (n+1 by 5)"]
["LINEST",{"$f":"LINEST(D129:I129,D128:I128)","v":1.942857142857143},null,{"$f":"LINEST(D129:I129,D128:I128,TRUE,TRUE)","v":1.942857142857143},0.1999999999999993,null,null,{"$f":"LOGEST(D129:I129,D128:I128,TRUE,TRUE)","v":1.4027906571323456},1.833908820057183]
["LOGEST",{"$f":"LOGEST(D129:I129,D128:I128)","v":1.4027906571323456},null,0.1665986255670086,0.6488084316286133,null,null,0.05129082045694708,0.1997490475347993]
["TREND",{"$f":"TREND(D129:I129,D128:I128)","v":2.1428571428571423},null,0.9714285714285713,0.6969320524371697,null,null,0.9158702939558562,0.21456489602231923]
[{"$nulls":3},135.99999999999994,4,null,null,43.54563147886378,4]
[{"$nulls":3},66.05714285714285,1.9428571428571435,null,null,2.004757901661387,0.18415237842027465]
[]
["TREND",null,null,{"$f":"TREND(D129:I129,D128:I128)","v":2.1428571428571423},4.085714285714285,6.0285714285714285,7.9714285714285715,9.914285714285715,11.857142857142858]

{"sheet":"Text","index":9,"n_rows":49,"n_cols":6,"rows_kept":49}
["Operators"]
["CONCATENATE",{"$f":"CONCATENATE(C2,D2,E2,F2)","v":"Foobarbazqux"},"Foo","bar","baz","qux"]
["EXACT",{"$f":"EXACT(C3,D3)","v":false},"foo","Foo"]
["LEN",{"$f":"LEN(C4)","v":15},"foo bar baz qux"]
["LENB",{"$f":"LENB(C4)","v":15}]
[]
["Casing"]
["LOWER",{"$f":"LOWER(C8)","v":"foo bar baz qux"},"foo bAR BAZ Qux"]
["PROPER",{"$f":"PROPER(C9)","v":"Foo Bar Baz Qux"},"foo bAR BAZ Qux"]
["UPPER",{"$f":"UPPER(C10)","v":"FOO BAR BAZ QUX"},"foo bAR BAZ Qux"]
[]
["Formatting"]
["DOLLAR",{"$f":"DOLLAR(C13)","v":"$4.57"},4.567]
["FIXED",{"$f":"FIXED(C14,5)","v":"0.12346"},0.12345679]
["TEXT",{"$f":"TEXT(C15,D15)","v":"1977-07-07"},"1977-07-07","ee-mm-dd"]
["T",{"$f":"T(C16)","v":""},false]
["VALUE",{"$f":"VALUE(C17)","v":12},"12"]
[]
["Codepoints"]
["CHAR",{"$f":"CHAR(C20)","v":""},240]
["CODE",{"$f":"CODE(C21)","v":240},""]
[]
["Extracting Text"]
["LEFT",{"$f":"LEFT(C24,D24)","v":"foo"},"foo bar baz qux",3]
["LEFTB",{"$f":"LEFTB(C24,D24)","v":"foo"}]
["MID",{"$f":"MID(C26,D26,E26)","v":"bar"},"foo bar baz qux",5,3]
["MIDB",{"$f":"MIDB(C27,D27,E27)","v":"baz"},"foo bar baz qux",9,3]
["RIGHT",{"$f":"RIGHT(C24,D24)","v":"qux"}]
["RIGHTB",{"$f":"RIGHT(C24,D24)","v":"qux"}]
[]
["Searching"]
["FIND",{"$f":"FIND(C32,D32)","v":9},"b","foo Bar baz qux"]
["FINDB",{"$f":"FINDB(C32,D32)","v":9}]
["SEARCH",{"$f":"SEARCH(C32,D32)","v":5}]
["SEARCHB",{"$f":"SEARCHB(C32,D32)","v":5}]
[]
["Manipulating Text",{"$f":"REPT(\"badger \",12)&REPT(\"MUSHROOM! \",2)","v":"badger badger badger badger badger badger badger badger badger badger badger badger MUSHROOM! MUSHROOM! "}]
["CLEAN",{"$f":"CLEAN(C38)","v":"7"},{"$f":"CHAR(7)&\"7\"&CHAR(7)","v":"\u00077\u0007"}]
["REPT",{"$f":"REPT(C39,D39)","v":"badgerbadgerbadger"},"badger",3]
["REPLACE",{"$f":"REPLACE(C40,D40,E40,F40)","v":"foo FOO baz qux"},"foo bar baz qux",4,4," FOO"]
["REPLACEB",{"$f":"REPLACEB(C40,D40,E40,F40)","v":"foo FOO baz qux"}]
["SUBSTITUTE",{"$f":"SUBSTITUTE(C42,D42,E42,F42)","v":"foo bor baz qux"},"foo bar baz qux","a","o",1]
["TRIM",{"$f":"TRIM(C43)","v":"there are two spaces here"},"  there are two spaces here  "]
[]
["Asian Features"]
["ASC",{"$f":"ASC(C46)","v":""}]
["PHONETIC",{"$f":"PHONETIC(C47)","v":{"$error":"#N/A"}},"foo bar baz qux"]
["JIS",{"$f":"JIS(C48)","v":{"$error":"#NAME?"}}]
["YEN",{"$f":"YEN(C49)","v":{"$error":"#NAME?"}},5]