{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"external_links":1,"defined_names":13},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":39,"n_cols":20,"rows_kept":39,"merged":[[0,0,0,20],[1,2,1,18],[2,1,2,3],[2,5,7,19],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,1,6,3],[7,2,7,3],[8,2,8,3],[8,5,8,6],[8,12,8,19],[9,2,9,3],[9,5,9,6],[9,12,9,19],[10,0,10,19],[11,1,11,4],[11,7,11,18],[12,1,12,3],[12,7,12,17],[14,1,14,3],[14,7,14,17],[15,1,15,2],[15,3,15,4],[15,7,15,9],[15,10,15,18],[17,2,17,14],[18,3,18,14],[19,3,19,14],[20,1,20,6],[20,7,20,8],[20,9,20,13],[20,14,20,19],[21,1,21,19],[22,2,22,14],[23,3,23,7],[23,8,23,15],[24,1,24,2],[24,3,24,7],[24,8,24,15],[25,3,25,7],[25,8,25,15],[26,1,26,2],[26,3,26,7],[26,8,26,15],[27,1,27,3],[27,5,27,19],[28,1,28,18],[29,1,29,19],[30,1,30,19],[31,1,31,19],[32,1,32,19],[37,3,37,14],[38,3,38,14]],"flags":["formulas_cached_only"]}
["This calculator solves for two unknowns, for equations similar to: AX+BY=V and KX+DY=W"]
[null,null,"Delete the numbers in the following six white input boxes, and enter your own numbers.  For calculated results, left click with the mouse on the calculation button, or on the background."]
[null,"Input boxes for AX+BY=V",{"$nulls":3},"If numbers entered for A & B or K & D are single-digit numbers, (when decimal places are removed) the equation is displayed in the gray box below.  (Decimals are not shown in the gray box)  However, if the numbers for A & B or K & D involve more than one digit, (excluding decimals), the equation is displayed in the larger green box, which is situated just below the gray box."]
[null,"A=",7]
[null,"B=",8]
[null,"V=",46]
[null,"Input boxes for KX+DY=W"]
[null,"K=",6]
[null,"D=",8,null,null,7,null,"X","+",8,"Y","=",46]
[null,"W=",36,null,null,6,null,"X","+",8,"Y","=",36]
["Equations are displayed in this  box, in a vertical format, IF:  A & B, or K & D have more than one digit.  "]
[null,"AX+BY=V",{"$nulls":5},"KX+DY=W"]
[null,"",null,null,"","AX",null,"",{"$nulls":10},"","KX"]
[{"$nulls":4},"","+",{"$nulls":12},"","+"]
[null,"",null,null,"","BY",null,"",{"$nulls":10},"","DY"]
[null,"",null,"",null,"=V",null,"",null,null,"",{"$nulls":8},"=W"]
[]
[null,null,"Calculated Results for X and Y Are:"]
[null,null,"X=",10]
[null,null,"Y=",-3]
[null,"Calculated results for X and Y are rounded to",{"$nulls":5},6,null,"decimal places.",{"$nulls":4},"This can be changed "]
[null,"by deleting the number in the small tan box, and entering the number of decimal places you prefer."]
[null,null,"Below, calculated values of X  and Y are checked for accuracy"]
[null,null,"V=",46,{"$nulls":4},"Calculation error is"]
[null,"AX+BY=",null,46,{"$nulls":4},{"v":0,"d":"0.000000000000"}]
[null,null,"W=",36,{"$nulls":4},"Calculation error is"]
[null,"KX+DY=",null,36,{"$nulls":4},{"v":0,"d":"0.000000000000"}]
[null,"Numbers in this box are rounded to   ",null,null,6,"decimal places.  This can be changed by deleting "]
[null,"the number in the small yellow box, and entering the number of decimal places you prefer.    "]
[null,"If the numbers in the pink box have more digits than is necessary for your calculations, you might get rounding errors, displayed in the pink box.  However, the settings in the pink box do not affect calculated results for X and Y.  Similarly, the number of decimal places that X and Y are rounded to, do not affect the calculations in the pink box."]
[null,"Certain combinations of numbers will not satisfy the two equations perfectly, and this can result in an error message, or calculated results that are not perfectly accurate.  If calculated results show an error of about 5%, an error message will be displayed.  "]
[null,"The relative degree of error is shown in the two green boxes inside of the larger pink box.  When numbers are entered that can satisfy both equations perfectly, and are in the range of the calculator, the green boxes will display 0.000000000000.   "]
[null," Actually, the numbers displayed in the upper green box is the difference between the value entered for V and the calculated value for V, based on the equation AX+BY=V, with the calculated values for X. and Y.  Similarly, the lower green box is for the KX+DY=W.   That is, the number in the upper green box is the value of V-AX+BY and the lower green box the value of    W-KX+DY. "]
[]
[]
[]
[]
[null,null,"XR=",10]
[null,null,"YR=",-3]