{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["R Divider"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"R Divider","index":0,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Resistor Divider"]
[null,"Electronic Design with Excel",null,null,null,null,null,null,null,null,"Enter"]
[null,null,null,null,null,null,null,null,null,null,"Calc"]
[]
[]
[]
[null,"ALT-F11 to see VBA Function."]
[]
[]
[null,"Vs","R1","R2","K Rdiv","Vo","Vo_err","Error (%)"]
[null,10,10000,10000,{"$f":"K_Rdiv1(C11,D11)","v":0.5},{"$f":"B11*E11","v":5},{"$f":"F11-$F$11","v":0},{"$f":"G11/$F$11*100","v":0},"Ideal output"]
[null,10,{"$f":"10000*1.01","v":10100},10000,{"$f":"K_Rdiv1(C12,D12)","v":0.49751243781094528},{"$f":"B12*E12","v":4.9751243781094532},{"$f":"F12-$F$11","v":-2.4875621890546817E-2},{"$f":"G12/$F$11*100","v":-0.49751243781093635},"1% error in R1"]
[null,10,10000,{"$f":"10000*1.01","v":10100},{"$f":"K_Rdiv1(C13,D13)","v":0.50248756218905477},{"$f":"B13*E13","v":5.0248756218905477},{"$f":"F13-$F$11","v":2.4875621890547706E-2},{"$f":"G13/$F$11*100","v":0.49751243781095411},"1% error in R2"]
[null,{"$f":"10*1.01","v":10.1},10000,10000,{"$f":"K_Rdiv1(C14,D14)","v":0.5},{"$f":"B14*E14","v":5.05},{"$f":"F14-$F$11","v":4.9999999999999822E-2},{"$f":"G14/$F$11*100","v":0.99999999999999634},"1% error in Vs"]