{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":27,"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":107,"n_cols":25,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["result",null,null,null,null,null,283,null,null,"1 - Enter your data in the yellow cells in Columns 17 & 18 (<=30 sets)",null,null,null,null,null,null,{"$f":"MAX(Q8:Q50)","v":1},{"$f":"MAX(R8:R50)","v":1.3402499999999999},null,null,null,null,null,null,"Data #"]
["coefficients and r-lag-1",null,null,null,null,null,null,null,null,"2 - Sort on x-value for visual convenience",null,null,null,null,null,null,{"$f":"MIN(Q8:Q50)","v":0},{"$f":"MIN(R8:R50)","v":1.3266},null,null,null,null,null,null,21]
[null,null,null,"a =",1.332813094348233,null,null,null,null,"3 - Duplicate the data in Columns 3 & 4"]
["cubic Akaho",null,null,"b =",7.3857158305373925E-3,null,null,"r-lag-1 =",{"$f":"I6/H6","v":0.34608505773851628},"4 - Enter your model in the VBA function \"Model\"",null,null,null,null,null,null,null,"N Realizations =",null,null,"Trial =",null,null,null,"sigma ="]
[1.3308687683702918,null,null,"c =",4.3190238874094184,null,null,null,null,"5 - Adjust the range in Columns 5-8 and 19 to match your data length",null,null,null,null,null,null,null,100,null,null,100,null,null,null,{"$f":"STDEV(Y8:Y515)","v":2.4953679967415726E-4}]
[5.1637648920633356E-2,null,null,"d =",-0.11894650407131449,"SSD =",{"$f":"SUM(G8:G108)","v":2.4241269798889755},{"$f":"SUM(H8:H108)","v":2.5722510404261344E-6},{"$f":"SUM(I8:I108)","v":8.9021764984383734E-7},"6 - Call solver and set up in blue cells for your model"]
[-8.1154917460625309E-2,null,"x-sample","y-sample","ymodel","d","Akakho d^2","d^2","d*d-1","7 - Choose a number of Bootstrapping realizations (<=500)",null,null,null,null,null,null,"x-data","y-data","ymodel","ymodelhigh","ymodellow","ymodel97.5","ymodel02.5"]
[2.6526468579048956E-2,null,0,1.3314999999999999,{"$f":"model(C8,$E$3,$E$4,$E$5,$E$6)","v":1.3319366593598028},{"$f":"D8-E8","v":-4.3665935980286008E-4},{"$f":"akaho_d2(C8,F8,$E$4,$E$5,$E$6)","v":0.17328686523878073},{"$f":"F8^2","v":1.9067139650344362E-7},null,"8 - Press the \"Bootstrapping\" button",null,null,null,null,null,null,0,1.3314999999999999,{"$f":"model(Q8,$E$3,$E$4,$E$5,$E$6)","v":1.3319366593598028},1.3329928694220299,1.3315011368966487,1.3324844515090855,1.3313888672105201,null,1.3260171795811986]
[-0.60629638691996279,null,0.05,1.333,{"$f":"model(C9,$E$3,$E$4,$E$5,$E$6)","v":1.3335284203333369},{"$f":"D9-E9","v":-5.2842033333688754E-4},{"$f":"akaho_d2(C9,F9,$E$4,$E$5,$E$6)","v":0.2536590530275552},{"$f":"F9^2","v":2.7922804868386736E-7},{"$f":"F8*F9","v":2.3073968446169924E-7},null,null,null,null,null,null,null,0.05,1.333,{"$f":"model(Q9,$E$3,$E$4,$E$5,$E$6)","v":1.3335284203333369},1.3344683340274268,1.333097508980617,1.3340341839303178,1.3330226567363559,null,1.3262680105759936]
[null,null,0.1,1.335,1.3350869515784449,-8.6951578444960376E-5,6.9229063386072077E-3,7.5605769940700975E-9,{"$f":"F9*F10","v":4.594698206605449E-8},null,null,null,null,null,null,null,0.1,1.335,1.3350869515784449,1.3358573291657632,1.3346936178605828,1.3355270243348472,1.3346468788220427,null,1.326449546451905]
["cubic SSD",null,0.15,1.337,1.3365398531388881,4.6014686111184311E-4,0.1968078202218613,2.1173513379108183E-7,-4.001049589016871E-8,null,null,null,null,null,null,null,0.15,1.337,1.3365398531388881,1.3371132510760924,1.3362084384952466,1.3369048336522364,1.3361748726255398,null,1.326617328116205]
[1.3314055943853116,null,0.2,1.3382499999999999,1.3378196319761233,4.303680238766372E-4,0.17556109201717482,1.8521663597548177E-7,1.9803249530974135E-7,null,null,null,null,null,null,null,0.2,1.3382499999999999,1.3378196319761233,1.3382494975729211,1.3375052889698178,1.3381190146494994,1.3375202493027472,null,1.3266393045349323]
[4.873931665314489E-2,null,0.25,1.3393999999999999,1.3388668372885693,5.3316271143066807E-4,0.27507698057955937,2.8426247686010183E-7,2.294561825231264E-7,null,null,null,null,null,null,null,0.25,1.3393999999999999,1.3388668372885693,1.3391655670891041,1.3385332401211574,1.3391290312026378,1.3386046433745007,null,1.3258362550447491]
[-7.8525642195183959E-2,null,0.3,1.33975,1.3396328222370735,1.171777629265236E-4,1.3527739164734008E-2,1.3730628124464568E-8,6.2474813801285338E-8,null,null,null,null,null,null,null,0.3,1.33975,1.3396328222370735,1.3399737799518627,1.3392942618281927,1.3398915294302227,1.3393741150439242,null,1.3265033463715945]
[2.6709402536570167E-2,null,0.35,1.3402499999999999,1.3400820037834869,1.6799621651308883E-4,2.8132897600895917E-2,2.8222728762712617E-8,1.9685420831123652E-8,null,null,null,null,null,null,null,0.35,1.3402499999999999,1.3400820037834869,1.3405092824021367,1.3397579904747094,1.3403555478951141,1.3398084596718596,null,1.3265938764263263]
[-0.5737761120739836,null,0.4,1.34,1.3401935156638791,-1.9351566387904029E-4,3.7442851656615046E-2,3.7448312166545702E-8,-3.2509899367697375E-8,null,null,null,null,null,null,null,0.4,1.34,1.3401935156638791,1.3406876057939501,1.3398620248645903,1.3404810782860979,1.3399059530416604,null,1.3263904505641131]
[null,null,0.45,1.3394999999999999,1.3399621777092381,-4.6217770923817625E-4,0.21224649206133084,2.1360823491664819E-7,8.9438626233319729E-8,null,null,null,null,null,null,null,0.45,1.3394999999999999,1.3399621777092381,1.3405001278014246,1.3395658282606231,1.3402535831198517,1.3396707722986245,null,1.3262765054041328]
["power Akaho",null,0.5,1.339,1.3393987364848603,-3.987364848603292E-4,0.15574328441310903,1.5899078435877153E-7,1.8428711516242969E-7,null,null,null,null,null,null,null,0.5,1.339,1.3393987364848603,1.3399559133953987,1.3389876534766474,1.3396849548394674,1.3391125181302532,null,1.3263868116671536]
[1.331466640952379,null,0.55000000000000004,1.3387500000000001,{"$f":"model(C19,$E$3,$E$4,$E$5,$E$6)","v":1.338529366069781},{"$f":"D19-E19","v":2.2063393021909405E-4},{"$f":"akaho_d2(C19,F19,$E$4,$E$5,$E$6)","v":4.6770986526055561E-2},{"$f":"F19^2","v":4.8679331163924068E-8},{"$f":"F18*F19","v":-8.7974797776480724E-8},null,null,null,null,null,null,null,0.55000000000000004,1.3387500000000001,{"$f":"model(Q19,$E$3,$E$4,$E$5,$E$6)","v":1.338529366069781},1.3390812765322686,1.3381496757624429,1.3388100947114461,1.338248637428116,null,1.3265537491711956]
[6.2725012396755736E-2,null,0.6,1.3369,1.3373944521670174,-4.9445216701737849E-4,0.23007937003268025,2.4448294546818155E-7,-1.0909292491439213E-7,null,null,null,null,null,null,null,0.6,1.3369,1.3373944521670174,1.3379185078166644,1.3369963295979166,1.3376800241729312,1.3371088801611035,null,1.3263656823290064]
[-6.6764165810095713E-2,null,0.65,1.3360000000000001,1.3360467160275245,-4.6716027524373871E-5,2.0165278423079692E-3,2.1823872276580571E-9,2.3098841043870159E-8,null,null,null,null,null,null,null,0.65,1.3360000000000001,1.3360467160275245,1.3365238296582513,1.3355206474026162,1.3363509533021376,1.3357424787529113,null,1.326327939518321]
[1.5234492316847232,null,0.7,1.3344,1.3345487653390389,-1.487653390388477E-4,2.0190136389448131E-2,2.2131126099343305E-8,6.9497256732116198E-9,null,null,null,null,null,null,null,0.7,1.3344,1.3345487653390389,1.3349646777952993,1.3339191273522029,1.3348773259238103,1.3342202047542675,null,1.326351468853082]
[-0.51863561955083792,null,0.75,1.3334999999999999,1.3329701858507301,5.2981414926978054E-4,0.25478869927614584,2.8070303276646127E-7,-7.8817981543697567E-8,null,null,null,null,null,null,null,0.75,1.3334999999999999,1.3329701858507301,1.3333164406292963,1.3322728378635953,1.3333142928535175,1.3326260788479427,null,1.3262446157677144]
[null,null,0.8,1.33175,1.3313843088392296,3.656911607703428E-4,0.12180006473799788,1.337300250655607E-7,1.9374835123901771E-7,null,null,null,null,null,null,null,0.8,1.33175,1.3313843088392296,1.3316713302482222,1.3306820215265709,1.3317225047102548,1.3310461129682045,null,1.3265613332243851]
["power SSD",null,0.85,1.33,1.3298648045800572,1.3519541994289064E-4,1.683751464015424E-2,1.8277801573534551E-8,4.9439770049749631E-8,null,null,null,null,null,null,null,0.85,1.33,1.3298648045800572,1.3301593261111948,1.329233437277584,1.3301725598468475,1.3295570493132669,null,1.32649432251599]
[1.331530117514879,null,0.9,1.3285,1.328482260071205,1.773992879505748E-5,2.9500810940392047E-4,3.1470507365370955E-10,2.3983571232047739E-9,null,null,null,null,null,null,null,0.9,1.3285,1.328482260071205,1.3287660947243611,1.3279891682801699,1.3287586161054041,1.3282059040370058,null,1.3264880648366575]
[6.3049231146755744E-2,null,0.95,1.3269,1.3273008999871889,-4.0089998718895181E-4,0.15378856469796129,1.6072079972810173E-7,-7.1119372266714612E-9,null,null,null,null,null,null,null,0.95,1.3269,1.3273008999871889,1.3275794754081911,1.3268386855070273,1.32761967105871,1.3269821289156678,null,1.3267177775692689]
[-6.6700689247595715E-2,null,1,1.3266,1.3263756031882523,2.2439681174768467E-4,4.9152125316597448E-2,5.0353929122525833E-8,-8.9960678954888409E-8,null,null,null,null,null,null,null,1,1.3266,1.3263756031882523,1.3268009769659326,1.3255208343887825,1.3268646953156136,1.3258865110608911,null,1.3261257142692198]
[1.4936978191847234,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263184607577407]
[-0.48591566079170967,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263656063478089]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3256950854247487]
["sine Akaho",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262484382485642]
[1.3337455681679367,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263745273402103]
[6.5917490517184126E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262792146792539]
[-4.2841865502942271,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3257654085436978]
[-0.78507291137831658,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3261155183088953]
[-0.35201857610363235,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263366440387157]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3260729731576468]
["sine SSD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.326370436436793]
[1.3337647705021549,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3261990166497386]
[6.5906806722788062E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262785481451143]
[-4.2905168273265426,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3261558401854592]
[-0.78763612528236515,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264730690402977]
[-0.35722369717130487,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3266192225299567]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263569686979026]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262937956625416]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3265893018610879]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3261816184478548]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3259200830826032]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262728910851924]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3258375321163811]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262484590875918]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263753363711002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263356026750808]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.326431132929166]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3260040064518854]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3265868499634328]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.326622022176442]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264197347729043]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264589065199524]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3266195790596815]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3265940256631377]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.326570270123639]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.326439253052843]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264437169279417]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3258484462208848]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3258442658472063]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3261882729454484]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262745540367726]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3259292481364577]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3255208343887825]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3257522938483413]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3257354703129778]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264641742801515]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262781728285715]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264557652618327]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264199141868047]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3266181157124037]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.326584595128919]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263210534697101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3266106623852514]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3268009769659326]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264601402278546]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262393491961575]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263981963068598]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264021420369325]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264993773770328]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264671186306911]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262842230703618]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3260876244296498]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262908957059345]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3259079874789721]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3260970118119844]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264269001187732]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3262169620863409]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263515874394807]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263884724081176]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264827324554624]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263180884311736]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3261909805292038]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.326498028101226]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264433867340646]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3265855308415855]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3265816523936445]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3264734521568164]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263415325657666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3263888442247946]