{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Модель к задаче №1","Модель к задаче №2"],"not_rendered":{"charts":2,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Модель к задаче №1","index":0,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Введите величину заряда q",98,null,"Максимальное значение напряженности",{"$f":"MAX(C5:C65)","v":18.8588287743645}]
["Введите расстояние между зарядами \n( не более 20)",12,null,"Ячейка в которой достигается максимальное знакчение напряженности электрического поля подсвечена красным"]
["Значение коэффициента к в законе Кулона\n (для простоты начальное значение 9)",{"$f":"9","v":9}]
["Значение x",null,"E"]
[0,null,{"$f":"(16*B$3*A5*B$1)/(POWER((4*A5*A5+B$2*B$2),1.5))","v":0}]
[0.2,null,1.6306148870803081]
[0.4,null,3.2450092523212763]
[0.6,null,4.8274081505237101]
[0.8,null,6.3629039912815353]
[1,null,7.8378328001797408]
[1.2,null,9.2400871363182802]
[1.4,null,10.559353053996885]
[1.6,null,11.787264408413547]
[1.8,null,12.917473754817356]
[2,null,13.94564448134256]
[2.2000000000000002,null,14.869373190878031]
[2.4,null,15.688054432199205]
[2.6,null,16.402701589965069]
[2.8,null,17.01573815794028]
[3,null,17.53077294359835]
[3.2,null,17.952371259922646]
[3.4,null,18.285832148323657]
[3.6,null,18.536979423491761]
[3.8,null,18.71197206996796]
[4,null,18.817137425794314]
[4.2,null,18.8588287743645]
[4.4000000000000004,null,18.843307489865254]
[4.5999999999999996,null,18.776648758068365]
[4.8,null,18.664669103760218]
[5,null,18.512873459149862]
[5.2,null,18.326419253951023]
[5.4,null,18.11009494447514]
[5.6,null,17.868310475579868]
[5.8,null,17.605097341168097]
[6,null,17.324116139070416]
[6.2,null,17.028669775339417]
[6.4,null,16.721720739385518]
[6.6,null,16.40591112959331]
[6.8,null,16.083584349027529]
[7,null,15.756807606733924]
[7.2,null,15.427394549291567]
[7.4,null,15.096927509268445]
[7.6,null,14.766778993184346]
[7.8,null,14.438132143541065]
[8,null,14.112]
[8.1999999999999993,null,13.789243456620206]
[8.4,null,13.470587867949327]
[8.6,null,13.156638299265992]
[8.8000000000000007,null,12.847893447747838]
[9,null,12.544758283862857]
[9.1999999999999993,null,12.24755547764684]
[9.4,null,11.956535684262354]
[9.6,null,11.671886768609356]
[9.8000000000000007,null,11.393742050821965]
[10,null,11.122187654095056]
[10.199999999999999,null,10.857269034120996]
[10.4,null,10.598996766022001]
[10.6,null,10.347351660461413]
[10.8,null,10.102289275932863]
[11,null,9.8637438893055709]
[11.2,null,9.6316319817317417]
[11.4,null,9.4058552921295266]
[11.6,null,9.1863034857357793]
[11.8,null,8.9728564807395621]
[12,null,8.7653864717991663]

{"sheet":"Модель к задаче №2","index":1,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Введите значение ЭДС",200,null,"Максимальная выделямая мощность",{"$f":"MAX(B5:B30)","v":5000}]
["Введите значение r\n ( не более 24)",2,null,"Ячейка с максимальный значением мощности подсвечивается красным"]
[]
["R","P"]
[0,{"$f":"POWER(B$1/(A5+B$2),2)*A5","v":0}]
[1,{"$f":"POWER(B$1/(A6+B$2),2)*A6","v":4444.4444444444453}]
[2,{"$f":"POWER(B$1/(A7+B$2),2)*A7","v":5000}]
[3,{"$f":"POWER(B$1/(A8+B$2),2)*A8","v":4800}]
[4,{"$f":"POWER(B$1/(A9+B$2),2)*A9","v":4444.4444444444453}]
[5,{"$f":"POWER(B$1/(A10+B$2),2)*A10","v":4081.6326530612246}]
[6,{"$f":"POWER(B$1/(A11+B$2),2)*A11","v":3750}]
[7,{"$f":"POWER(B$1/(A12+B$2),2)*A12","v":3456.7901234567898}]
[8,{"$f":"POWER(B$1/(A13+B$2),2)*A13","v":3200}]
[9,{"$f":"POWER(B$1/(A14+B$2),2)*A14","v":2975.2066115702487}]
[10,{"$f":"POWER(B$1/(A15+B$2),2)*A15","v":2777.7777777777783}]
[11,{"$f":"POWER(B$1/(A16+B$2),2)*A16","v":2603.5502958579882}]
[12,{"$f":"POWER(B$1/(A17+B$2),2)*A17","v":2448.9795918367349}]
[13,{"$f":"POWER(B$1/(A18+B$2),2)*A18","v":2311.1111111111113}]
[14,{"$f":"POWER(B$1/(A19+B$2),2)*A19","v":2187.5}]
[15,{"$f":"POWER(B$1/(A20+B$2),2)*A20","v":2076.1245674740489}]
[16,{"$f":"POWER(B$1/(A21+B$2),2)*A21","v":1975.3086419753085}]
[17,1883.6565096952913]
[18,1800]
[19,1723.3560090702947]
[20,1652.8925619834715]
[21,1587.9017013232515]
[22,1527.7777777777781]
[23,1472]
[24,1420.1183431952663]
[25,1371.7421124828534]
{"$rows_empty":15}
[10.25,{"$f":"POWER(B$1/(A46+B$2),2)*A46","v":2732.1949187838404}]