{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":30,"n_cols":28,"rows_kept":30}
["copy and past as values into F:I",{"$nulls":9},"copy and paste down the desired variation you wish to test",{"$nulls":10},"to simulate downstream calculations",{"$nulls":4},{"$f":"ROW()-500000","v":-499999}]
["random numbers",{"$nulls":4},"a","b","c","d",null,"xi","xold","f(xold)","f'(xold)","xnew","converged?",null,"UDF double","UDF range",null,null,"lookup",1,"copy and paste down to ",null,null,{"$f":"ROW()-500000","v":-499998}]
[{"$f":"RAND()*2-1","v":0.8562843649047345},{"$f":"RAND()*2-1","v":0.539924117544281},-0.08236017455380029,-0.3179146059351776,null,-0.942046245128557,0.09513861431247106,0.8464365077576623,0.9558608420576236,null,0,{"$f":"IF($P3,$L3,IFERROR($O3,$K3))","v":0.747075820111895},{"$f":"$F3+SERIESSUM($L3,1,1,$G3:$I3)","v":8.52728998523844e-11},{"$f":"$G3+2*$H3*$L3+3*$I3*$L3^2","v":2.9603048111753534},{"$f":"L3-M3/N3","v":0.7470758200830896},{"$f":"OR(ISBLANK($O3),ABS(O3-L3)<0.000001)","v":true},null,{"$f":"nrcuberoot($K3,$F3,$G3,$H3,$I3)","v":0.7470758200830901},{"$f":"nrrootrange($K3,$F3:$I3)","v":0.7470758200830901},null,null,{"$f":"INT(IF(ISBLANK($R3),$O3,$R3))","v":0},{"$f":"MATCH(V3,$AA:$AA,W$2)","v":3},"include lookup in speed test.",null,null,-499997,"copy column AA to bottom to get full lookup array"]
[{"$f":"RAND()*2-1","v":-0.7238165090803954},0.11854592718872325,-0.720648575870368,-0.921700331248724,null,-0.24805074143532524,-0.4298810812376592,-0.06524210348243908,0.5500898259050606]
[-0.9991147718879452,-0.5003542764015947,-0.761806961456077,-0.7890655779825391,null,0.04372033880234394,0.6963494402108523,0.8588942920940519,-0.822117307533174]
[-0.18085890822688278,-0.9218006110005099,-0.7659832310670986,0.8697754154657655,null,-0.7469970785658866,-0.3283351959556913,-0.15224075065999143,0.9337688036823799]
[-0.22499470239956754,-0.4421252554799944,0.000200436439159013,-0.12181066653216766,null,0.5705062482788836,0.441069420134907,-0.48488874937154103,0.3405469097445111]
[0.6610547638397923,0.5252316237059027,-0.5569059127466054,-0.8189061937771207,null,-0.20890253620066757,0.5775394953210711,0.6762735933182302,0.052710762338556094]
[-0.27318220083588685,-0.6010191510895728,-0.13099071180398347,-0.24448714655007908,null,0.0648412137530947,-0.9458131724195447,-0.9329511421704777,-0.48147765574033086]
[0.25085554007900157,0.003867117792982988,0.6688454661633538,-0.31890833565361687,null,0.2299680068105383,-0.7410908296620935,-0.5495456944245833,-0.5498026041782627]
[0.927475355162136,-0.9536862521385396,0.6070731543018439,0.3984370794494638,null,0.9766449654945415,0.016710916124916597,-0.9873972063224912,-0.9928526873471242]
[-0.7821312284424309,0.12823040311983647,-0.8404027572014829,0.5689522994599461,null,0.5775885152376734,-0.8263236617741079,0.25520195251168687,-0.6713262019219743]
[0.8540500159259494,0.3556201117328506,-0.16737485659545648,0.18606877629799712,null,-0.7076824240752626,-0.33520823086544205,-0.2689688257023498,0.34605120033886116]
[0.18898355774783493,-0.4645143433824237,0.40185593316684853,-0.1710734798150888,null,0.7953123883519773,-0.2713776136579895,0.449353056951713,0.5417060553043385]
[0.40673960190673597,0.48866324066682454,0.520970909490043,-0.9525306723928377,null,0.21341141005593078,-0.5454250872252526,0.5607256879126608,-0.12619713797348586]
[0.8149972499274281,0.5196667894249849,0.16042245808674416,0.4142374123181849,null,0.74325587457936,-0.7961479078335532,0.6554549451150891,-0.8551135557869998]
[-0.4696270855840403,0.044885301302080904,-0.9367923291434366,-0.34866109007555757,null,0.8880377720075825,0.04762629911166094,0.08664156342864793,0.2347854174631454]
[-0.25679525887273336,0.751609005636594,0.4814153615697343,0.38056821968157095,null,-0.3125435058145598,0.2228839655625543,-0.6880040701833092,0.802089295314977]
[0.6073717500552416,0.07854526414350893,-0.39074296090821825,0.42507857454132036,null,-0.027305930745743723,-0.7912982038296654,-0.8791336444050888,0.936445075911422]
[0.8062335266265173,0.3892882152034529,0.02429826637251198,0.6711350446466775,null,-0.3041081680789812,-0.7676159545060788,0.7562159953539656,-0.1568229804494461]
[-0.6841574835923137,0.28274321857821505,0.1740940673342104,-0.4354358651416912,null,0.3215319468969522,0.48488868466873214,0.8028180482915155,0.04592419310356988]
[0.7554959703198247,0.7810538215411018,-0.2130156998962196,-0.6989813424226092,null,-0.9234323061556076,-0.016154284981840572,-0.7191813012045873,0.5310375621099848]
[0.08327752335459371,0.4570631087559893,0.8459411389736329,-0.5245454601843544,null,2.384246027773429E-4,-0.022691053899722036,-0.026973778619057143,-0.17612093214922453]
[{"$f":"RAND()*2-1","v":0.23177124109861857},0.8668925422571818,0.44103347892664146,-0.3629723554134614,null,0.4810831437032155,-0.47211126783439994,-0.6426151360774268,-0.4008182067433861]
[0.6172104517057702,0.2216840915127154,-0.9755126155629785,0.9793374155609165,null,-0.029605606075375768,0.13787418625871206,-0.03648909344751328,-0.8600203029375493]
[-0.9653291444153096,0.5440865081769393,0.18902326638249933,0.09748995446985909,null,-0.07537747615863877,0.35175238676803566,0.7466358271963696,-0.6154829669205064]
[-0.3867777453269152,0.741724555795205,-0.9233214704876325,0.6898384042264549,null,-0.31064892866903193,0.8780240497055782,-0.9891858478852154,-0.018680765557661516]
[-0.38970943493799304,-0.6529763278024774,-0.3063309711736695,-0.21949733378671787,null,0.5993207009471213,0.4579368390403733,-0.6959952252846424,0.09742611885053609]
[-0.10269677894105333,-0.42485299496548024,0.6732185345058852,0.7370477067265266,null,0.3385745766298527,-0.516744596389433,0.6723072680405995,-0.025991710836040127]
[0.7038660892962785,-0.573349350447915,0.4437970302032128,0.26130752885656516,null,-0.567309253505389,-0.33882357536221974,0.5891550989131087,-0.5124814359453094]