{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Plan1","1.1","1.2","tabela Lieberman 1.1","Lieberman 1.2"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":34,"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":"Plan1","index":0,"n_rows":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["X",0.83761949812090908,null,"x","f(x)",null,"Bisseção"]
["f(x)",{"$f":"-2*B1^6-3*B1^4+12*B1","v":7.8839455241274718},null,-11,{"$f":"-2*D2^6-3*D2^4+12*D2","v":-3587177},null,"x-tentativa","f(x)","novo x"]
[null,null,null,{"$f":"D2+0.5","v":-10.5},{"$f":"-2*D3^6-3*D3^4+12*D3","v":-2716782.46875},null,1,{"$f":"-2*G3^6-3*G3^4+12*G3","v":7}]
[null,null,null,{"$f":"D3+0.5","v":-10},{"$f":"-2*D4^6-3*D4^4+12*D4","v":-2030120},null,-1,{"$f":"-2*G4^6-3*G4^4+12*G4","v":-17},{"$f":"(G3+G4)/2","v":0}]
[null,null,null,-9.5,-1494732.96875,null,{"$f":"I4","v":0},0,{"$f":"IF(H5<H4,(G5+G4)/2,(G5+G3)/2)","v":0.5}]
[null,null,null,-9,-1082673,null,{"$f":"I5","v":0.5},5.78125,{"$f":"IF(H6<H5,(G6+G5)/2,(G6+G4)/2)","v":-0.25}]
[null,null,null,-8.5,-770061.21875,null,-0.25,-3.01220703125,0.125]
[null,null,null,-8,-536672,null,0.125,1.4992599487304687,0.3125]
[null,null,null,-7.5,-365539.21875,null,0.3125,3.7195271253585815,3.125E-2]
[null,null,null,-7,-242585,null,3.125E-2,0.37499713711440563,0.171875]
[null,null,null,-6.5,-156270.96875,null,0.171875,2.0598304259765428,0.2421875]
[null,null,null,-6,-97272,null,0.2421875,2.8955252585869857,0.13671875]
[null,null,null,-5.5,-58172.46875,null,0.13671875,1.6395637638832383,0.189453125]
[null,null,null,-5,-33185,null,0.189453125,2.2694802097531053,0.2158203125]
[null,null,null,-4.5,-17891.71875,null,0.2158203125,2.5831329977405333,0.17626953125]
[null,null,null,-4,-9008,null,0.17626953125,2.1122781716158432,0.196044921875]
[null,null,null,-3.5,-4168.71875,null,0.196044921875,2.3479940912054227,0.2059326171875]
[null,null,null,{"$f":"D17+0.5","v":-3},-1737,null,0.2059326171875,2.4656434900953519,0.19110107421875]
[null,null,null,-2.5,-635.46875,null,0.19110107421875,2.2891144313944749,0.198516845703125]
[null,null,null,-2,-200,null,0.198516845703125,2.3774205460109261,0.2022247314453125]
[null,null,null,-1.5,-55.96875,null,0.2022247314453125,2.4215428289406544,0.19666290283203125]
[null,null,null,-1,-17,null,0.19666290283203125,2.3553515577130852,0.19944381713867188]
[null,null,null,-0.5,-6.21875,null,0.19944381713867188,2.3884530978558693,0.20083427429199219]
[null,null,null,0,0,null,0.20083427429199219,2.4049994614387056,0.19874858856201172]
[null,null,null,0.5,5.78125,null,0.19874858856201172,2.3801788062708416,0.19979143142700195]
[null,null,null,1,7,null,0.19979143142700195,2.3925899672263693,0.20031285285949707]
[null,null,null,1.5,-19.96875,null,0.20031285285949707,2.3987949238316748,0.19953072071075439]
[null,null,null,2,-152,null,0.19953072071075439,2.3894873325228856,0.19992178678512573]
[null,null,null,2.5,-575.46875,null,0.19992178678512573,2.3941412455320914,0.2001173198223114]
[null,null,null,3,-1665,null,0.2001173198223114,2.3964681140815776,0.1998240202665329]
[null,null,null,3.5,-4084.71875,null,0.1998240202665329,2.3929777892457142,0.19997067004442215]
[null,null,null,4,-8912,null,0.19997067004442215,2.39472296817523,0.20004399493336678]
[null,null,null,4.5,-17783.71875,null,0.20004399493336678,2.3955955452595168,0.19993400759994984]
[null,null,null,5,-33065,null,0.19993400759994984,2.3942866765367632,0.19998900126665831]
[null,null,null,5.5,-58040.46875,null,0.19998900126665831,2.3949411132205336,0.20001649810001254]
[null,null,null,{"$f":"D35+0.5","v":6},{"$f":"-2*D36^6-3*D36^4+12*D36","v":-97128},null,0.20001649810001254,2.3952683298207931,0.19997525284998119]
[null,null,null,{"$f":"D36+0.5","v":6.5},-156114.96875]
[null,null,null,7,-242417]
[null,null,null,7.5,-365359.21875]
[null,null,null,8,-536480]
[null,null,null,8.5,-769857.21875]
[null,null,null,9,-1082457]
[null,null,null,9.5,-1494504.96875]
[null,null,null,10,-2029880]
[null,null,null,10.5,-2716530.46875]
[null,null,null,11,-3586913]
[null,null,null,11.5,-4678453.71875]
[null,null,null,12,-6034032]
[null,null,null,12.5,-7702486.71875]
[null,null,null,13,-9739145]
[null,null,null,13.5,-12206373.46875]
[null,null,null,14,-15174152]
[null,null,null,14.5,-18720669.96875]
[null,null,null,15,-22932945]
[null,null,null,15.5,-27907464.21875]
[null,null,null,16,-33750848]
[null,null,null,16.5,-40580536.21875]
[null,null,null,{"$f":"D57+0.5","v":17},{"$f":"-2*D58^6-3*D58^4+12*D58","v":-48525497}]
[null,null,null,{"$f":"D58+0.5","v":17.5},-57726957.96875]
[null,null,null,18,-68339160]
[null,null,null,18.5,-80530133.46875]
[null,null,null,19,-94482497]
[null,null,null,19.5,-110394278.71875]
[null,null,null,20,-128479760]
[null,null,null,20.5,-148970341.71875]
[null,null,null,21,-172115433]
[null,null,null,21.5,-198183362.46875]
[null,null,null,22,{"$f":"-2*D68^6-3*D68^4+12*D68","v":-227462312}]
[null,null,null,22.5,-260261272.96875]
[null,null,null,23,-296911025]
[null,null,null,23.5,-337765137.21875]
[null,null,null,24,-383200992]
[null,null,null,24.5,-433620831.21875]
[null,null,null,{"$f":"D73+0.5","v":25},{"$f":"-2*D74^6-3*D74^4+12*D74","v":-489452825}]
[null,null,null,{"$f":"D74+0.5","v":25.5},{"$f":"-2*D75^6-3*D75^4+12*D75","v":-551152162.96875}]
[null,null,null,26,-619202168]
[null,null,null,26.5,-694115432.46875]
[null,null,null,27,-776434977]
[null,null,null,27.5,-866735431.71875]
[null,null,null,28,-965624240]
[null,null,null,28.5,-1073742884.71875]
[null,null,null,29,-1191768137]

{"sheet":"1.1","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["a","(a+b)/2","b","f(a)","f((a+b)/2)","f(b)"]
[-20,{"$f":"(A2+C2)/2","v":-0.5},19,{"$f":"-2*A2^6-3*A2^4+12*A2","v":-128480240},{"$f":"-2*B2^6-3*B2^4+12*B2","v":-6.21875},-94482497]
[{"$f":"IF(D2>F2,A2,B2)","v":-0.5},{"$f":"(A3+C3)/2","v":9.25},{"$f":"IF(F2>D2,C2,B2)","v":19},-6.21875,{"$f":"-2*B3^6-3*B3^4+12*B3","v":-1274647.9223632813},{"$f":"-2*C3^6-3*C3^4+12*C3","v":-94482497}]
[-0.5,4.375,9.25,-6.21875,{"$f":"-2*B4^6-3*B4^4+12*B4","v":-15071.444282531738},{"$f":"-2*C4^6-3*C4^4+12*C4","v":-1274647.9223632813}]
[-0.5,1.9375,4.375,-6.21875,-124.82411968708038,-15071.444282531738]
[-0.5,0.71875,1.9375,-6.21875,7.5486301463097334,-124.82411968708038]
[-0.5,0.109375,0.71875,-6.21875,1.3120672437071335,7.5486301463097334]
[0.109375,0.4140625,0.71875,1.3120672437071335,4.8704878185340021,7.5486301463097334]
[0.4140625,0.56640625,0.71875,4.8704878185340021,6.4220675507051439,7.5486301463097334]
[0.56640625,0.642578125,0.71875,6.4220675507051439,7.0586673267134916,7.5486301463097334]
[0.642578125,0.6806640625,0.71875,7.0586673267134916,7.3251217663862498,7.5486301463097334]
[0.6806640625,0.69970703125,0.71875,7.3251217663862498,7.4426817307597215,7.5486301463097334]
[0.69970703125,0.709228515625,0.71875,7.4426817307597215,7.4971650567336203,7.5486301463097334]
[0.709228515625,0.7139892578125,0.71875,7.4971650567336203,{"$f":"-2*B14^6-3*B14^4+12*B14","v":7.5232822833738506},{"$f":"-2*C14^6-3*C14^4+12*C14","v":7.5486301463097334}]
[0.7139892578125,0.71636962890625,0.71875,7.5232822833738506,7.5360533228578426,7.5486301463097334]
[0.71636962890625,0.717559814453125,0.71875,7.5360533228578426,7.5423661295549342,7.5486301463097334]
[0.717559814453125,0.7181549072265625,0.71875,7.5423661295549342,7.5455042514695272,7.5486301463097334]
[0.7181549072265625,0.71845245361328125,0.71875,7.5455042514695272,7.5470687291262681,7.5486301463097334]
[0.71845245361328125,0.71860122680664063,0.71875,7.5470687291262681,7.5478498205088922,7.5486301463097334]
[0.71860122680664063,0.71867561340332031,0.71875,7.5478498205088922,7.5482400791360149,7.5486301463097334]
[0.71867561340332031,0.71871280670166016,0.71875,7.5482400791360149,7.5484351366581723,7.5486301463097334]
[0.71871280670166016,0.71873140335083008,0.71875,7.5484351366581723,7.5485326474682299,7.5486301463097334]

{"sheet":"1.2","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["a","(a+b)/2","b","f(a)","f((a+b)/2)","f(b)"]
[-20,{"$f":"(A2+C2)/2","v":0},20,{"$f":"-0.25*A2^4+A2^3-2*A2^2+2*A2","v":-48840},{"$f":"-0.25*B2^4+B2^3-2*B2^2+2*B2","v":0},-32760]
[{"$f":"IF(D2>F2,A2,B2)","v":0},{"$f":"(A3+C3)/2","v":10},{"$f":"IF(F2>D2,C2,B2)","v":20},{"$f":"-0.25*A3^4+A3^3-2*A3^2+2*A3","v":0},{"$f":"-0.25*B3^4+B3^3-2*B3^2+2*B3","v":-1680},{"$f":"-0.25*C3^4+C3^3-2*C3^2+2*C3","v":-32760}]
[0,5,10,0,-71.25,-1680]
[0,2.5,5,0,-1.640625,-71.25]
[0,1.25,2.5,0,0.7177734375,-1.640625]
[0,0.625,1.25,0,0.67474365234375,0.7177734375]
[0.625,0.9375,1.25,0.67474365234375,0.74804306030273438,0.7177734375]
[0.9375,1.09375,1.25,0.74804306030273438,0.74558615684509277,0.7177734375]
[0.9375,1.015625,1.09375,0.74804306030273438,0.74987791478633881,0.74558615684509277]
[0.9375,0.9765625,1.015625,0.74804306030273438,0.74972526635974646,0.74987791478633881]
[0.9765625,0.99609375,1.015625,0.74972526635974646,0.74999237054726109,0.74987791478633881]
[0.99609375,1.005859375,1.015625,0.74999237054726109,0.7499828335676284,0.74987791478633881]
[0.99609375,1.0009765625,1.005859375,0.74999237054726109,0.74999952316261442,0.7499828335676284]
[0.99609375,0.99853515625,1.0009765625,0.74999237054726109,0.74999892711524296,0.74999952316261442]
[0.99853515625,0.999755859375,1.0009765625,0.74999892711524296,0.74999997019767672,0.74999952316261442]
[0.999755859375,1.0003662109375,1.0009765625,0.74999997019767672,0.74999993294477019,0.74999952316261442]
[0.999755859375,1.00006103515625,1.0003662109375,0.74999997019767672,0.74999999813735485,0.74999993294477019]
[0.999755859375,0.999908447265625,1.00006103515625,0.74999997019767672,0.74999999580904841,0.74999999813735485]
[0.999908447265625,0.9999847412109375,1.00006103515625,0.74999999580904841,0.74999999988358468,0.74999999813735485]
[0.9999847412109375,1.0000228881835937,1.00006103515625,0.74999999988358468,0.74999999973806553,0.74999999813735485]
[0.9999847412109375,1.0000038146972656,1.0000228881835937,0.74999999988358468,0.74999999999272404,0.74999999973806553]
[]
["x",0.9999999921874998]
["f(x)",{"$f":"-0.25*B24^4+B24^3-2*B24^2+2*B24","v":0.75}]

{"sheet":"tabela Lieberman 1.1","index":3,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["f(x)=-2x^6-3x^4+12x ",null,"f'(x) = -12x^5-12x^3+12"]
["Iteração","df(x)/dx","x inf","x sup","novo x","f(x)"]
[1,null,-15,40,{"$f":"(C3+D3)/2","v":12.5},{"$f":"-2*E3^6-3*E3^4+12*E3","v":-7702486.71875}]
[2,{"$f":"-12*E3^5-12*E3^3+12","v":-3685534.875},{"$f":"IF(B4>0,E3,C3)","v":-15},{"$f":"IF(B4<0,E3,D3)","v":12.5},{"$f":"(C4+D4)/2","v":-1.25},{"$f":"-2*E4^6-3*E4^4+12*E4","v":-29.95361328125}]
[3,{"$f":"-12*E4^5-12*E4^3+12","v":72.05859375},{"$f":"IF(B5>0,E4,C4)","v":-1.25},{"$f":"IF(B5<0,E4,D4)","v":12.5},{"$f":"(C5+D5)/2","v":5.625},{"$f":"-2*E5^6-3*E5^4+12*E5","v":-66288.591499328613}]
[4,-69699.959838867188,-1.25,5.625,2.1875,-261.58150017261505]
[5,-714.67551040649414,-1.25,2.1875,0.46875,5.4589440207928419]
[6,10.492464423179626,0.46875,2.1875,1.328125,-4.3731946901243646]
[7,-65.700344379991293,0.46875,1.328125,0.8984375,7.7747249398703389]
[8,-3.7271003845380619,0.46875,0.8984375,0.68359375,7.3439274840877644]
[9,6.3753625188946899,0.68359375,0.8984375,0.791015625,7.8277274124112379]
[10,2.3444200045470325,0.791015625,0.8984375,0.8447265625,7.8825497181513882]
[11,-0.39452152022080256,0.791015625,0.8447265625,0.81787109375,7.8735154548426749]
[12,1.0435577578461785,0.81787109375,0.8447265625,0.831298828125,7.8828593516046537]
[13,0.34234528691668054,0.831298828125,0.8447265625,0.8380126953125,7.8839412924447476]
[14,-2.1544833685846143E-2,0.831298828125,0.8380126953125,0.83465576171875,7.8837057077322568]
[15,{"$f":"-12*E16^5-12*E16^3+12","v":0.16152514074894597},{"$f":"IF(B17>0,E16,C16)","v":0.83465576171875},{"$f":"IF(B17<0,E16,D16)","v":0.8380126953125},{"$f":"(C17+D17)/2","v":0.836334228515625},7.8839003191165444]
[16,7.0272739412025942E-2,0.836334228515625,0.8380126953125,0.8371734619140625,7.883940069862204]
[17,2.4434769523805855E-2,0.8371734619140625,0.8380126953125,0.83759307861328125,7.8839455046050624]
[18,1.462693390671177E-3,0.83759307861328125,0.8380126953125,0.83780288696289063,7.8839446053176792]
[19,-1.0036636114305608E-2,0.83759307861328125,0.83780288696289063,0.83769798278808594,7.8839453565432862]
[20,-4.2858631867588315E-3,0.83759307861328125,0.83769798278808594,0.83764553070068359,7.883945505955122]
[21,-1.4113078959283598E-3,0.83759307861328125,0.83764553070068359,0.83761930465698242,7.8839455241235132]
[22,2.576199269377355E-5,0.83761930465698242,0.83764553070068359,0.83763241767883301,7.8839455197503998]
[23,-6.9275563963699938E-4,0.83761930465698242,0.83763241767883301,0.83762586116790771,7.8839455231146989]
[24,-3.3349249555669758E-4,0.83761930465698242,0.83762586116790771,0.83762258291244507,7.8839455239135381]
[25,-1.538641694622811E-4,0.83761930465698242,0.83762258291244507,0.83762094378471375,7.8839455240921339]
[26,-6.4050817893956946E-5,0.83761930465698242,0.83762094378471375,0.83762012422084808,7.8839455241262257]

{"sheet":"Lieberman 1.2","index":4,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["f(x)=-0,25x^4+x^3-2x^2+2x",null,"f'(x) = -x^3+3x^2-4x+2"]
["Iteração","df(x)/dx","x inf","x sup","novo x","f(x)"]
[1,null,-100,100,{"$f":"(C3+D3)/2","v":0},{"$f":"-0.25*E3^4+E3^3-2*E3^2+2*E3","v":0}]
[2,{"$f":"-E3^3+3*E3^2-4*E3+2","v":2},{"$f":"IF(B4>0,E3,C3)","v":0},{"$f":"IF(B4<0,E3,D3)","v":100},{"$f":"(C4+D4)/2","v":50},{"$f":"-0.25*E4^4+E4^3-2*E4^2+2*E4","v":-1442400},{"$f":"IF(D4-C4<0.02,\"pare\",\"\")","v":""}]
[3,{"$f":"-E4^3+3*E4^2-4*E4+2","v":-117698},{"$f":"IF(B5>0,E4,C4)","v":0},{"$f":"IF(B5<0,E4,D4)","v":50},{"$f":"(C5+D5)/2","v":25},{"$f":"-0.25*E5^4+E5^3-2*E5^2+2*E5","v":-83231.25},{"$f":"IF(D5-C5<0.02,\"pare\",\"\")","v":""}]
[4,-13848,0,25,12.5,-4437.890625,""]
[5,-1532.375,0,12.5,6.25,-202.9541015625,""]
[6,-149.953125,0,6.25,3.125,-6.60552978515625,""]
[7,-11.720703125,0,3.125,1.5625,0.56676864624023438,""]
[8,-0.740478515625,0,1.5625,0.78125,0.72550177574157715,""]
[9,0.229217529296875,0.78125,1.5625,1.171875,0.73501132428646088,""]
[10,-0.17695236206054688,0.78125,1.171875,0.9765625,0.74972526635974646,""]
[11,2.3450374603271484E-2,0.9765625,1.171875,1.07421875,0.74723820289364085,""]
[12,-7.4627578258514404E-2,0.9765625,1.07421875,1.025390625,0.74967755417674198,""]
[13,-2.5406993925571442E-2,0.9765625,1.025390625,1.0009765625,0.74999952316261442,""]
[14,-9.7656343132257462E-4,0.9765625,1.0009765625,0.98876953125,0.74993693430904784,""]
[15,1.1231885175220668E-2,0.98876953125,1.0009765625,0.994873046875,0.7499868570030932,"pare"]
[16,5.1270878902869299E-3,0.994873046875,1.0009765625,0.9979248046875,0.7499978467775712,"pare"]
[17,2.0752042491949396E-3,0.9979248046875,1.0009765625,0.99945068359375,0.74999984912572026,{"$f":"IF(D19-C19<0.02,\"pare\",\"\")","v":"pare"}]
[18,5.493165720054094E-4,0.99945068359375,1.0009765625,1.000213623046875,0.74999997718259648,"pare"]
[19,-2.1362305662364633E-4,0.99945068359375,1.000213623046875,0.9998321533203125,0.74999998591374584,"pare"]
[20,1.6784668441616191E-4,0.9998321533203125,1.000213623046875,1.0000228881835937,0.74999999973806553,"pare"]
[21,-2.2888183605740409E-5,0.9998321533203125,1.0000228881835937,0.99992752075195313,0.7499999973733793,"pare"]
[22,7.2479248427681497E-5,0.99992752075195313,1.0000228881835937,0.99997520446777344,0.74999999969259079,"pare"]
[23,2.4795532241661533E-5,0.99997520446777344,1.0000228881835937,0.99999904632568359,0.74999999999954525]
[24,9.5367431640625E-7,0.99999904632568359,1.0000228881835937,1.0000109672546387,0.74999999993985966]
[25,-1.0967254640004143E-5,0.99999904632568359,1.0000109672546387,1.0000050067901611,0.74999999998746603]
[26,-5.0067901611328125E-6,0.99999904632568359,1.0000050067901611,1.0000020265579224,0.74999999999794653]