{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Сборка","Data"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"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":"Сборка","index":0,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,4,19,5]]}
[]
[{"$f":"Data!A4","v":"Резисторы"},null,null,{"$f":"Data!A20","v":"Конденсаторы"},null,null,{"$f":"Data!A36","v":"Диоды "},null,null,{"$f":"Data!A51","v":"Разное"},null,null,"L"]
[{"$f":"Data!A5","v":"10 Ом"},{"$f":"Data!B5","v":1},null,{"$f":"Data!A21","v":"470 (47 пф)"},{"$f":"Data!B21","v":4},null,{"$f":"Data!A37","v":"1N4148"},{"$f":"Data!B37","v":30},null,{"$f":"Data!A52","v":"Бусинка"},{"$f":"Data!B52","v":2},null,"S"]
[{"$f":"Data!A6","v":"39 Ом"},{"$f":"Data!B6","v":4},null,{"$f":"Data!A22","v":"471 (470 пф)"},{"$f":"Data!B22","v":1},null,{"$f":"Data!A38","v":"ZD 9,1 V"},{"$f":"Data!B38","v":1},null,{"$f":"Data!A53","v":"Микрофон"},{"$f":"Data!B53","v":1},null,"F"]
[{"$f":"Data!A7","v":"240 Ом"},{"$f":"Data!B7","v":4},null,{"$f":"Data!A23","v":"102 (1000 пф)"},{"$f":"Data!B23","v":5},null,null,null,null,{"$f":"Data!A54","v":"Микровкл."},{"$f":"Data!B54","v":4},null,"P"]
[{"$f":"Data!A8","v":"270 Ом"},{"$f":"Data!B8","v":3},null,{"$f":"Data!A24","v":"682 (6800 пф)"},{"$f":"Data!B24","v":4},null,{"$f":"Data!A40","v":"Транзисторы "},null,null,{"$f":"Data!A55","v":"Микрокнопка"},{"$f":"Data!B55","v":1},null,"T"]
[{"$f":"Data!A9","v":"1 кОм"},{"$f":"Data!B9","v":5},null,{"$f":"Data!A25","v":"103 (0,01 мкФ)"},{"$f":"Data!B25","v":3},null,{"$f":"Data!A41","v":"BT547 N-P-N"},{"$f":"Data!B41","v":4},null,{"$f":"Data!A56","v":"BT137-600"},{"$f":"Data!B56","v":4},null,"X"]
[{"$f":"Data!A10","v":"2,2 кОм"},{"$f":"Data!B10","v":3},null,{"$f":"Data!A26","v":"683 (68 нф)"},{"$f":"Data!B26","v":1},null,{"$f":"Data!A42","v":"BT557 P-N-P"},{"$f":"Data!B42","v":2},null,{"$f":"Data!A57","v":"Радиатор Т"},{"$f":"Data!B57","v":0},null,"Led"]
[{"$f":"Data!A11","v":"10 кОм"},{"$f":"Data!B11","v":6},null,{"$f":"Data!A27","v":"104 (0,1 мкФ)"},{"$f":"Data!B27","v":4},null,{"$f":"Data!A43","v":"2N7000"},{"$f":"Data!B43","v":1},null,{"$f":"Data!A58","v":"Радиатор Х"},{"$f":"Data!B58","v":4}]
[{"$f":"Data!A12","v":"20 кОм"},{"$f":"Data!B12","v":5},null,{"$f":"Data!A28","v":"2,2 мкФ"},{"$f":"Data!B28","v":5},null,null,null,null,{"$f":"Data!A59","v":"Радиатор Led"},{"$f":"Data!B59","v":0}]
[{"$f":"Data!A13","v":"100 кОм"},{"$f":"Data!B13","v":17},null,{"$f":"Data!A29","v":"3,3 мкф"},{"$f":"Data!B29","v":2},null,{"$f":"Data!A45","v":"Микросхемы "},null,null,{"$f":"Data!A60","v":"Вентилятор"},{"$f":"Data!B60","v":2}]
[{"$f":"Data!A14","v":"220 кОм"},{"$f":"Data!B14","v":3},null,{"$f":"Data!A30","v":"4,7 мкФ"},{"$f":"Data!B30","v":0},null,{"$f":"Data!A46","v":"LM324N "},{"$f":"Data!B46","v":5},null,{"$f":"Data!A61","v":"Датчик 45 град."},{"$f":"Data!B61","v":1}]
[{"$f":"Data!A15","v":"1 мОм"},{"$f":"Data!B15","v":12},null,{"$f":"Data!A31","v":"10 мкФ"},{"$f":"Data!B31","v":4},null,{"$f":"Data!A47","v":"МОС3021"},{"$f":"Data!B47","v":4},null,{"$f":"Data!A62","v":"Джампер"},{"$f":"Data!B62","v":4}]
[null,null,null,{"$f":"Data!A32","v":"470х16 V"},{"$f":"Data!B32","v":2},null,{"$f":"Data!A48","v":"Модуль RL"},{"$f":"Data!B48","v":1},null,{"$f":"Data!A63","v":"Разъем Вход-1"},{"$f":"Data!B63","v":0}]
[{"$f":"Data!A17","v":"Переменные"},null,null,{"$f":"Data!A33","v":"470X25 V"},{"$f":"Data!B33","v":2},null,{"$f":"Data!A49","v":"Модуль BT"},{"$f":"Data!B49","v":1},null,{"$f":"Data!A64","v":"Разъем Вход-2"},{"$f":"Data!B64","v":1}]
[{"$f":"Data!A18","v":"50 кОм"},{"$f":"Data!B18","v":9},null,{"$f":"Data!A34","v":"0,01x400V"},{"$f":"Data!B34","v":4},null,null,null,null,{"$f":"Data!A65","v":"Разъем Вых-1"},{"$f":"Data!B65","v":1}]
[null,null,null,null,null,null,null,null,null,{"$f":"Data!A66","v":"Разъем Вых-2"},{"$f":"Data!B66","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Data!A67","v":"Разъем Вых-4"},{"$f":"Data!B67","v":4}]
[null,null,null,null,null,null,null,null,null,{"$f":"Data!A68","v":"Трансформатор"},{"$f":"Data!B68","v":1}]
[null,null,{"$f":"Data!E2","v":"Радуга-X-4"},null,{"$f":"Data!A72","v":"ИТОГО:"},null,{"$f":"Data!B72","v":193},null,null,{"$f":"Data!A69","v":"Вкл без подсв."},{"$f":"Data!B69","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Data!A70","v":"Вкл с подсв."},{"$f":"Data!B70","v":1}]

{"sheet":"Data","index":1,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[null,"ИТОГО ","L","S","F","P","T","X","Led","+","M","RL","BT"]
[{"$f":"IF(B2=\"\",\"\",\"Радуга-\")","v":"Радуга-"},"X",{"$f":"CONCATENATE(J2,K2,L2,M2)","v":"+M-RL-BT"},{"$f":"IF(C2=\"+M-RL-BT\",\"-4\",C2)","v":"-4"},{"$f":"CONCATENATE(A2,B2,D2)","v":"Радуга-X-4"},null,null,null,null,{"$f":"IF(J3=0,\" \",\"+\")","v":"+"},{"$f":"IF(K3=0,\" \",\"M\")","v":"M"},{"$f":"IF(L3=0,\" \",\"-RL\")","v":"-RL"},{"$f":"IF(M3=0,\" \",\"-BT\")","v":"-BT"}]
[null,null,{"$f":"IF(EXACT($B$2,C1),1,0)","v":0},{"$f":"IF(EXACT($B$2,D1),1,0)","v":0},{"$f":"IF(EXACT($B$2,E1),1,0)","v":0},{"$f":"IF(EXACT($B$2,F1),1,0)","v":0},{"$f":"IF(EXACT($B$2,G1),1,0)","v":0},{"$f":"IF(EXACT($B$2,H1),1,0)","v":1},{"$f":"IF(EXACT($B$2,I1),1,0)","v":0},{"$f":"IF(J4,1,0)","v":1},{"$f":"IF(K4,1,0)","v":1},1,1]
["Резисторы",null,null,null,null,null,null,null,null,true,true,true,true]
["10 Ом",{"$f":"$C$3*C5+$D$3*D5+$E$3*E5+$F$3*F5+$G$3*G5+$H$3*H5+$I$3*I5+$J$3*J5+$K$3*K5+$L$3*L5+$M$3*M5","v":1},1,1,1,1,1,1,1]
["39 Ом",4,null,null,null,4,4,4]
["240 Ом",4,2,2,2,2,2,2,2,null,null,null,2]
["270 Ом",3,3,3,3,3,3,3,3]
["1 кОм",5,4,4,4,4,4,4,4,null,1]
["2,2 кОм",3,3,3,3,3,3,3,3]
["10 кОм",6,5,5,5,5,5,5,5,null,null,1]
["20 кОм",5,4,4,4,4,4,4,4,null,1]
["100 кОм",17,14,14,14,14,14,14,14,null,1,null,2]
["220 кОм",{"$f":"$C$3*C14+$D$3*D14+$E$3*E14+$F$3*F14+$G$3*G14+$H$3*H14+$I$3*I14+$J$3*J14+$K$3*K14+$L$3*L14+$M$3*M14","v":3},1,1,1,1,1,1,1,1,1]
["1 мОм",{"$f":"$C$3*C15+$D$3*D15+$E$3*E15+$F$3*F15+$G$3*G15+$H$3*H15+$I$3*I15+$J$3*J15+$K$3*K15+$L$3*L15+$M$3*M15","v":12},12,12,12,12,12,12,12]
[]
["Переменные"]
["50 кОм",{"$f":"$C$3*C18+$D$3*D18+$E$3*E18+$F$3*F18+$G$3*G18+$H$3*H18+$I$3*I18+$J$3*J18+$K$3*K18+$L$3*L18+$M$3*M18","v":9},5,5,9,5,9,9,9]
[]
["Конденсаторы"]
["470 (47 пф)",4,4,4,4,4,4,4,4]
["471 (470 пф)",1,1,1,1,1,1,1,1]
["102 (1000 пф)",5,2,4,4,4,4,4,4,null,null,1]
["682 (6800 пф)",4,4,4,4,4,4,4,4]
["103 (0,01 мкФ)",3,3,3,3,3,3,3,3]
["683 (68 нф)",1,1,1,1,1,1,1,1]
["104 (0,1 мкФ)",4,2,2,2,2,2,2,2,null,1,null,1]
["2,2 мкФ",5,5,5,5,5,5,5,1]
["3,3 мкф",2,null,null,null,null,null,null,null,null,null,null,2]
["4,7 мкФ",0,null,null,null,null,null,null,4]
["10 мкФ",4,null,null,null,null,null,null,null,1,2,1]
["470х16 V",2,null,null,2,null,2,2,2]
["470X25 V",2,2,2,2,2,2,2,2]
["0,01x400V",4,null,null,null,4,4,4]
[]
["Диоды "]
["1N4148",30,13,21,21,21,21,21,21,null,null,9]
["ZD 9,1 V",1,null,null,null,null,null,null,null,null,null,1]
[null,0]
["Транзисторы ",0]
["BT547 N-P-N",4,4,4,4,4,4,4,4]
["BT557 P-N-P",2,1,1,1,1,1,1,1,1]
["2N7000",1,null,null,null,null,null,null,null,1]
[]
["Микросхемы "]
["LM324N ",5,5,5,5,5,5,5,5]
["МОС3021",4,4,4,4,4,4,4,4]
["Модуль RL",1,null,null,null,null,null,null,null,null,null,1]
["Модуль BT",1,null,null,null,null,null,null,null,null,null,null,1]
[]
["Разное"]
["Бусинка",2,2,2,2,2,2,2,2]
["Микрофон",1,null,null,null,null,null,null,null,null,1]
["Микровкл.",4,null,null,null,null,null,null,null,1,1,1,1]
["Микрокнопка",1,null,null,null,null,null,null,null,null,null,1]
["BT137-600",4,4,4,4,4,4,4,4]
["Радиатор Т",0,null,null,null,4,4]
["Радиатор Х",4,null,null,null,null,null,4]
["Радиатор Led",0,null,null,null,null,null,null,1]
["Вентилятор",2,null,null,null,null,null,2]
["Датчик 45 град.",1,null,null,null,null,null,1]
["Джампер",4,null,null,null,4,4,4]
["Разъем Вход-1",0,1,1,null,1]
["Разъем Вход-2",1,null,null,1,null,1,1,1]
["Разъем Вых-1",1,null,null,null,null,null,1]
["Разъем Вых-2",0,4,4,null,4]
["Разъем Вых-4",4,null,null,4,null,4,4,4]
["Трансформатор",1,1,1,1,1,1,1,1]
["Вкл без подсв.",0,1,1,1,1]
["Вкл с подсв.",1,null,null,null,null,1,1,1]
[]
["ИТОГО:",{"$f":"SUM(B5:B70)","v":193}]