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

{"sheet":"Sheet1","index":0,"n_rows":435,"n_cols":16,"rows_kept":435,"merged":[[0,1,0,16],[1,1,1,16],[2,1,2,16],[3,1,3,16],[4,1,4,16],[5,2,5,15],[6,1,6,16],[8,2,8,7],[8,8,8,15],[9,2,9,3],[9,4,9,7],[9,9,9,14],[10,4,10,7],[10,9,10,14],[11,2,11,3],[11,4,11,7],[11,9,11,14],[12,2,12,4],[12,5,12,7],[12,9,12,14],[13,2,13,5],[13,6,13,7],[13,13,13,15],[14,1,14,16],[15,1,15,16],[16,2,16,7],[16,8,16,15],[17,2,17,3],[17,4,17,7],[17,9,17,14],[18,2,18,3],[18,4,18,7],[18,9,18,14],[19,2,19,3],[19,4,19,7],[19,9,19,14],[20,2,20,4],[20,5,20,7],[20,9,20,14],[21,2,21,5],[21,6,21,7],[21,13,21,15],[22,1,22,16],[23,1,23,16],[24,2,24,7],[24,8,24,15],[25,2,25,3],[25,4,25,7],[25,9,25,14],[26,2,26,3],[26,4,26,7],[26,9,26,14],[27,4,27,7],[27,9,27,14],[28,5,28,7],[28,9,28,14],[29,2,29,5],[29,6,29,7],[29,13,29,15],[30,1,30,16],[31,1,31,16],[32,1,32,16],[33,1,33,16],[34,1,34,16],[35,1,35,8],[35,10,35,16],[36,1,36,16],[37,1,37,16],[39,1,39,16],[40,1,40,16],[41,5,41,13],[42,5,42,13],[43,5,43,13],[44,1,44,16],[45,1,45,16],[46,1,46,16],[47,1,47,16],[49,1,49,16],[50,1,50,16],[51,1,51,16],[52,1,52,8],[52,10,52,16],[53,1,53,16],[54,2,54,8],[54,10,54,16],[55,2,55,8],[55,10,55,16],[56,2,56,8],[56,10,56,16],[57,2,57,8],[57,10,57,16],[58,2,58,8],[58,9,58,10],[58,11,58,16],[59,2,59,8],[59,9,59,10],[59,11,59,16],[60,2,60,8],[60,10,60,16],[61,2,61,8],[61,10,61,16],[62,2,62,8],[62,10,62,16],[63,2,63,8],[63,10,63,16],[64,2,64,8],[64,10,64,16],[65,2,65,8],[65,10,65,16],[67,1,67,15],[68,1,68,15],[69,3,70,3],[69,4,69,5],[69,7,70,7],[69,8,69,9],[69,11,70,11],[69,12,69,13],[70,4,70,5],[70,8,70,9],[70,12,70,13],[71,1,71,15],[72,1,72,15],[73,1,73,14],[74,2,74,7],[74,8,74,15],[75,2,75,7],[75,8,75,15],[77,4,77,10],[78,5,78,10],[80,5,80,7],[80,8,80,14],[82,5,82,10],[83,4,83,10],[84,1,84,15],[85,9,85,15],[86,1,87,1],[86,2,86,3],[86,4,86,7],[86,9,86,15],[87,2,87,3],[87,4,87,7],[87,9,87,15],[88,4,88,7],[88,9,88,15],[89,4,89,10],[90,5,90,10],[92,5,92,7],[92,8,92,14],[94,5,94,10],[95,4,95,10],[96,1,96,15],[97,9,97,15],[98,1,99,1],[98,2,98,3],[98,4,98,7],[98,9,98,15],[99,2,99,3],[99,4,99,7],[99,9,99,15],[100,4,100,7],[100,9,100,15],[101,4,101,10],[102,5,102,10],[104,5,104,7],[104,8,104,14],[106,5,106,10],[107,4,107,10],[108,1,108,15],[109,9,109,15],[110,1,111,1],[110,2,110,3],[110,4,110,7],[110,9,110,15],[111,2,111,3],[111,4,111,7],[111,9,111,15],[112,4,112,7],[112,9,112,15],[113,1,113,15],[114,1,114,15],[115,3,116,3],[115,4,115,5],[115,7,116,7],[115,8,115,9],[115,11,116,11],[115,12,115,13],[116,4,116,5],[116,8,116,9],[116,12,116,13],[117,1,117,15],[118,1,118,15],[119,1,119,14],[120,2,120,7],[120,8,120,15],[121,2,121,7],[121,8,121,15],[122,4,122,10],[123,5,123,10],[125,5,125,7],[125,8,125,14],[127,5,127,10],[128,4,128,10],[129,1,129,15],[130,9,130,15],[131,1,132,1],[131,2,131,3],[131,4,131,7],[131,9,131,15],[132,2,132,3],[132,4,132,7],[132,9,132,15],[133,4,133,7],[133,9,133,15],[134,4,134,10],[135,5,135,10],[137,5,137,7],[137,8,137,14],[139,5,139,10],[140,4,140,10],[141,1,141,15],[142,9,142,15],[143,1,144,1],[143,2,143,3],[143,4,143,7],[143,9,143,15],[144,2,144,3],[144,4,144,7],[144,9,144,15],[145,4,145,7],[145,9,145,15],[146,4,146,10],[147,5,147,10],[149,5,149,7],[149,8,149,14],[151,5,151,10],[152,4,152,10],[153,1,153,15],[154,9,154,15],[155,1,156,1],[155,2,155,3],[155,4,155,7],[155,9,155,15],[156,2,156,3],[156,4,156,7],[156,9,156,15],[157,4,157,7],[157,9,157,15],[159,1,159,15],[160,2,160,14],[161,2,161,14],[162,2,162,14],[163,2,163,14],[164,1,164,7],[164,8,164,14],[165,1,165,7],[165,8,165,14],[166,1,166,7],[166,8,166,14],[167,2,167,7],[167,9,167,14],[168,2,168,7],[168,9,168,14],[169,2,169,7],[169,9,169,14],[170,2,170,7],[170,9,170,14],[171,2,171,7],[171,9,171,14],[172,1,172,15],[173,1,173,15],[175,1,175,4],[175,6,175,10],[175,12,175,15],[176,1,176,4],[176,6,176,10],[176,12,176,15],[177,1,177,4],[177,6,177,10],[177,12,177,15],[178,1,178,15],[180,4,180,7],[180,8,180,13],[181,4,181,7],[181,8,181,13],[182,4,182,7],[182,8,182,13],[183,4,183,7],[183,8,183,13],[184,4,184,7],[184,8,184,13],[185,4,185,7],[185,8,185,13],[187,2,187,14],[188,2,188,14],[190,3,190,13],[191,3,191,13],[193,1,193,15],[195,6,195,7],[195,8,195,15],[196,6,196,7],[196,8,196,15],[197,6,197,7],[197,8,197,15],[199,2,199,14],[201,6,201,7],[201,8,201,15],[202,6,202,7],[202,8,202,15],[203,6,203,7],[203,8,203,15],[205,2,205,7],[205,8,205,15],[206,2,206,7],[206,8,206,15],[208,2,208,14],[209,2,209,14],[211,3,211,13],[212,3,212,13],[214,1,214,15],[216,6,216,7],[216,8,216,15],[217,6,217,7],[217,8,217,15],[218,6,218,7],[218,8,218,15],[220,2,220,14],[222,6,222,7],[222,8,222,15],[223,6,223,7],[223,8,223,15],[224,6,224,7],[224,8,224,15],[226,2,226,7],[226,8,226,15],[227,2,227,7],[227,8,227,15],[229,2,229,14],[230,2,230,14],[232,3,232,13],[233,3,233,13],[235,1,235,15],[237,6,237,7],[237,8,237,15],[238,6,238,7],[238,8,238,15],[239,6,239,7],[239,8,239,15],[241,2,241,14],[243,6,243,7],[243,8,243,15],[244,6,244,7],[244,8,244,15],[245,6,245,7],[245,8,245,15],[247,2,247,7],[247,8,247,15],[248,2,248,7],[248,8,248,15],[251,1,251,15],[253,4,253,13],[254,4,254,13],[255,5,255,13],[256,4,256,13],[257,4,257,13],[258,3,258,14],[259,4,259,13],[260,4,260,13],[262,4,262,13],[263,4,263,13],[264,5,264,13],[265,4,265,13],[266,4,266,13],[267,3,267,14],[268,4,268,13],[269,4,269,13],[271,5,271,12],[272,5,272,12],[273,6,273,13],[274,4,274,13],[275,4,275,13],[276,3,276,14],[277,4,277,13],[278,4,278,13],[280,4,280,13],[281,5,281,12],[282,9,282,10],[283,5,283,13],[284,4,284,13],[285,4,285,13],[286,3,286,14],[287,4,287,13],[288,4,288,13],[290,4,290,13],[291,4,291,13],[292,5,292,13],[293,4,293,13],[294,4,294,13],[295,3,295,14],[296,4,296,13],[297,4,297,13],[299,4,299,13],[300,4,300,13],[301,5,301,13],[302,4,302,13],[303,4,303,13],[304,2,304,15],[305,4,305,13],[306,4,306,13],[308,4,308,13],[309,4,309,13],[310,5,310,13],[311,4,311,13],[312,4,312,13],[313,2,313,15],[314,4,314,13],[315,4,315,13],[317,4,317,13],[318,4,318,13],[319,5,319,13],[320,4,320,13],[321,4,321,13],[322,2,322,15],[323,4,323,13],[324,4,324,13],[326,4,326,13],[327,4,327,13],[328,5,328,13],[329,4,329,13],[330,4,330,13],[331,2,331,15],[332,4,332,13],[333,4,333,13],[335,4,335,13],[336,4,336,13],[337,5,337,13],[338,3,338,14],[339,4,339,13],[340,1,340,16],[341,4,341,13],[342,4,342,13],[344,4,344,13],[345,4,345,13],[346,5,346,13],[347,4,347,13],[348,4,348,13],[349,2,349,15],[350,4,350,13],[351,4,351,13],[353,1,353,16],[355,4,355,13],[356,4,356,13],[357,4,357,6],[357,7,357,13],[358,4,358,13],[359,4,359,5],[359,6,359,13],[360,4,360,13],[361,4,361,13],[362,3,362,14],[363,4,363,13],[364,4,364,13],[366,3,366,14],[367,4,367,13],[368,4,368,6],[368,7,368,13],[369,4,369,13],[370,4,370,5],[370,6,370,13],[371,4,371,13],[372,4,372,13],[373,3,373,14],[374,4,374,13],[375,4,375,13],[377,4,377,13],[378,4,378,13],[379,5,379,13],[380,1,380,16],[381,4,381,13],[382,1,382,16],[383,4,383,13],[384,4,384,13],[386,4,386,13],[387,4,387,13],[388,5,388,13],[389,1,389,16],[390,4,390,13],[391,1,391,16],[392,4,392,13],[393,4,393,13],[395,4,395,13],[396,4,396,13],[397,5,397,13],[398,1,398,16],[399,4,399,13],[400,1,400,16],[401,4,401,13],[402,4,402,13],[404,4,404,13],[405,4,405,13],[406,5,406,13],[407,2,407,15],[408,4,408,13],[409,1,409,16],[410,4,410,13],[411,4,411,13],[413,4,413,13],[414,4,414,13],[415,5,415,13],[416,1,416,16],[417,4,417,13],[418,1,418,16],[419,4,419,13],[420,4,420,13],[422,4,422,13],[423,4,423,13],[424,5,424,13],[425,1,425,16],[426,4,426,13],[427,1,427,16],[428,4,428,13],[429,4,429,13],[434,1,434,16]],"flags":["formulas_cached_only"]}
[null,"CREATED BY:  David@TechForText.com ©2010  To contact the author use the email address on the left. "]
[null,"The Multiple-Algebraic Calculator"]
[null,"The Multiple-Algebraic Calculator demonstrates that a number of complex calculations (involving 24 unknowns, calculus, and trigonometry) can be carried out simultaneously, by devices created with specialized design concepts in the JavaScript or spreadsheet formats.  When the user enters 12 numbers, and left clicks with the mouse, the Multiple-Algebraic Calculator initially solves: AX+BY+KZ=M, DX+EY+FZ=N, GX+HY+JZ=W for X, Y and Z.   With the calculated values for X, Y, and Z, and the numbers entered by the user, additional sets of calculations are automatically  carried out involving six double integrals, ratios, algebra and trigonometry.    "]
[null,"Instructions"]
[null,"To use the Multiple-Algebraic Calculator enter twelve numbers in the twelve white input boxes, below. (To enter or delete numbers, left click with the mouse on the relevant white input box.)  For calculated results left click with the mouse on the background  Alternatively, with the online JavaScript version you can press the calculation button, and with the spreadsheet version you can press the enter key.  Numbers and words displayed in red type are calculated results."]
[null,null,"Note: If less than 12 numbers are entered this Calculator will NOT function properly.  All twelve input boxes must contain numbers entered by the user. "]
[null,"     To see all the equations, double integrals, trigonometry and calculated results, scroll down. The Multiple-Algebraic Calculator is approximately 20 times the height of a typical computer screen. It is equivalent to a 15 page document. "]
[]
[null,null,"Error checking for AX+BY+KZ = M   ",{"$nulls":5},"Input Set One: input boxes for AX+BY+KZ = M"]
[null,null," Accuracy  %",null,{"$error":"#DIV/0!"},{"$nulls":3},"A=",{"$nulls":6},"X +"]
[null,null," Error %",null,{"$error":"#DIV/0!"},{"$nulls":3},"B=",{"$nulls":6},"Y +"]
[null,null,"AX+BY+KZ =",null,{"$error":"#DIV/0!"},{"$nulls":3},"K=",{"$nulls":6},"Z +"]
[null,null,"(AX+BY+KZ) - M =",null,null,{"$error":"#DIV/0!"},null,null,"M=",{"$nulls":6},"  =M"]
[null,null,{"$error":"#DIV/0!"},{"$nulls":3},0,null,"X +",0,"Y+",0,"Z   =",0]
[null,"Above, right is a representation of the equation you entered. If an equation has numbers with more than four"]
[null," digits, look at the vertical representation of the equation, (right side of input boxes, blue numbers and letters) "]
[null,null,"Error checking for DX+EY+FZ = N  ",{"$nulls":5},"Input Set Two: input boxes for: DX+EY+FZ = N"]
[null,null,"Accuracy  %",null,{"$error":"#DIV/0!"},{"$nulls":3},"D=",{"$nulls":6},"X +"]
[null,null,"Error %",null,{"$error":"#DIV/0!"},{"$nulls":3},"E=",{"$nulls":6},"Y +"]
[null,null,"DX+EY+FZ =",null,{"$error":"#DIV/0!"},{"$nulls":3},"F=",{"$nulls":6},"Z +"]
[null,null,"(DX+EY+FZ) - N =",null,null,{"$error":"#DIV/0!"},null,null,"N=",{"$nulls":6},"  =N"]
[null,null,{"$error":"#DIV/0!"},{"$nulls":3},0,null,"X +",0,"Y+",0,"Z   =",0]
[null,"Above, right is a representation of the equation you entered. If an equation has numbers with more than four"]
[null," digits, look at the vertical representation of the equation, (right side of input boxes, blue numbers and letters) "]
[null,null,"Error checking for GX+HY+JZ = W  ",{"$nulls":5},"Input Set Three: input boxes for: GX+HY+JZ = W"]
[null,null," Accuracy %",null,{"$error":"#DIV/0!"},{"$nulls":3},"G =",{"$nulls":6},"X +"]
[null,null,"Error %",null,{"$error":"#DIV/0!"},{"$nulls":3},"H =",{"$nulls":6},"Y +"]
[null,null,"GX+HY+JZ =",null,{"$error":"#DIV/0!"},{"$nulls":3},"J =",{"$nulls":6},"Z +"]
[null,null,"(GX+HY+JZ) - W =",null,null,{"$error":"#DIV/0!"},null,null,"W = ",{"$nulls":6},"  =W"]
[null,null,{"$error":"#DIV/0!"},{"$nulls":3},0,null,"X +",0,"Y+",0,"Z   =",0]
[null,"Above, right is a representation of the equation you entered. If an equation has numbers with more than four"]
[null," digits, look at the vertical representation of the equation, (right side of input boxes, blue numbers and letters) "]
[null," The Multiple-Algebraic Calculator has a number of error-checking devices (above and below)."]
[null," These devices check the calculations and the numbers you entered to determine if they satisfy"]
[null," the equations. These devices provide feedback in words or numbers.  The calculations for "]
[null,"all of the error-checking devices are rounded to",{"$nulls":7},5,"decimal places.   You can change this,"]
[null,"by deleting the  blue number above, and entering the number of decimal places you prefer.  If you enter a number that is too high you may get false indications of errors. "]
[null,"Note: The number of zeros displayed is not affected by the blue number."]
[]
[null,"For AX+BY+KZ = M, DX+EY+FZ = N, GX+HY+JZ = W "]
[null,"The Calculated Results, for X, Y, and Z, are in the three yellow boxes, below  "]
[{"$nulls":4},"X =",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Y =",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Z =",{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for X is =(M-(B*Y+K*Z))/A"]
[null,"Spreadsheet formula for Y is =(A*N+D*K*Z-A*F*Z-D*M)/(A*E-D*B)"]
[null,"Spreadsheet formula for Z is"]
[null," =((A*E-D*B)*D*W-(A*E-D*B)*G*N-((D*H-G*E)*A*N)+(D*H-G*E)*D*M)/((D*H-G*E)*D*K-(D*H-G*E)*A*F-(A*E-D*B)*G*F+(A*E-D*B)*D*J)  "]
[]
[null,"The Multiple-Algebraic Calculator displays a summary of "]
[null,"calculated results for 24 unknowns, below.  This list does not"]
[null,"  include all the calculated results.   For all the results scroll down.  "]
[null,"Calculated results on this list are rounded to ",{"$nulls":7},5,"decimal places.  You can change this,   "]
[null,"by deleting the  blue number above, and entering the number of decimal places you prefer.  "]
[null,"X =",{"$error":"#DIV/0!"},{"$nulls":6},"Da =",{"$error":"#DIV/0!"}]
[null,"Y =",{"$error":"#DIV/0!"},{"$nulls":6},"Ea=",{"$error":"#DIV/0!"}]
[null,"Z =",{"$error":"#DIV/0!"},{"$nulls":6},"Fa=",{"$error":"#DIV/0!"}]
[null,"P =",{"$error":"#DIV/0!"},{"$nulls":6},"Ga=",{"$error":"#DIV/0!"}]
[null,"V =",{"$error":"#DIV/0!"},{"$nulls":6},"Angle_A=",null,{"$error":"#DIV/0!"}]
[null,"S=",{"$error":"#DIV/0!"},{"$nulls":6},"Angle_B=",null,{"$error":"#DIV/0!"}]
[null,"T=",{"$error":"#DIV/0!"},{"$nulls":6},"Ja=",{"$error":"#DIV/0!"}]
[null,"Q =",{"$error":"#DIV/0!"},{"$nulls":6},"Ka=",{"$error":"#DIV/0!"}]
[null,"U =",{"$error":"#DIV/0!"},{"$nulls":6},"La",{"$error":"#DIV/0!"}]
[null,"Aa =",{"$error":"#DIV/0!"},{"$nulls":6},"Ma=",{"$error":"#DIV/0!"}]
[null,"Ba =",{"$error":"#DIV/0!"},{"$nulls":6},"Na=",{"$error":"#DIV/0!"}]
[null,"Ca =",{"$error":"#DIV/0!"},{"$nulls":6},"Pa=",{"$error":"#DIV/0!"}]
[]
[null,"The three equations from the previous section, (AX+BY+KZ=M, DX+EY+FZ=N, "]
[null,"GX+HY+JZ=W are algebraically rearranged by solving for Y as follows: "]
[{"$nulls":3},"Y=","M-AX-KZ",null,null,"Y=","N-DX-FZ",null,null,"Y=","W-GX-JZ"]
[{"$nulls":4},"B",{"$nulls":3},"E",{"$nulls":3},"H"]
[null," In this section, calculations with double integrals, will be carried out, for each"]
[null,"of above.   The calculations are based on the following:"]
[null," "]
[null,null,"The X axis will be based 0 to",{"$nulls":5},{"$error":"#DIV/0!"}]
[null,null,"The Z axis will be based 0 to",{"$nulls":5},{"$error":"#DIV/0!"}]
[]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"}]
[]
[{"$nulls":5},"(M-AX-KZ)dxdz =",null,null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"B"]
[{"$nulls":5},0]
[{"$nulls":4},0]
[null,"Spreadsheet formula for the above is =(2*M*X*Z-A*Z*(X^2)-K*X*(Z^2))/(2*B)"]
[{"$nulls":8},"M =",0]
[null,"Y =","M-AX-KZ",null,"These are the values",{"$nulls":3},"A =",0]
[null,null,"B",null," you entered  in the ",{"$nulls":3},"K =",0]
[{"$nulls":4},"white input boxes. ",{"$nulls":3},"B =",0]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"}]
[]
[{"$nulls":5},"(N-DX-FZ)dxdz =",null,null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"E"]
[{"$nulls":5},0]
[{"$nulls":4},0]
[null,"Spreadsheet formula for the above is =((2*N*X*Z-D*Z*(X^2)-F*X*(Z^2))/2*E)"]
[{"$nulls":8},"N=",0]
[null,"Y=","N-DX-FZ",null,"These are the values",{"$nulls":3},"D=",0]
[null,null,"E",null," you entered  in the ",{"$nulls":3},"F=",0]
[{"$nulls":4},"white input boxes. ",{"$nulls":3},"E=",0]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"}]
[]
[{"$nulls":5},"(W-GX-JZ)dxdz =",null,null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"H"]
[{"$nulls":5},0]
[{"$nulls":4},0]
[null,"Spreadsheet formula for the above is =((2*W*X*Z-D*Z*(X^2)-F*X*(Z^2))/2*H)"]
[{"$nulls":8},"W=",0]
[null,"Y=","W-GX-JZ",null,"These are the values",{"$nulls":3},"G=",0]
[null,null,"H",null," you entered  in the ",{"$nulls":3},"J=",0]
[{"$nulls":4},"white input boxes. ",{"$nulls":3},"H=",0]
[null,"The three equations from the previous section, (AX+BY+KZ=M, DX+EY+FZ=N, and "]
[null,"GX+HY+JZ=W have been algebraically rearranged by solving for Z as follows: "]
[{"$nulls":3},"Z=","M-AX-BY",null,null,"Z=","N-DX-EY",null,null,"Z=","W-GX-HY"]
[{"$nulls":4},"K",{"$nulls":3},"F",{"$nulls":3},"J"]
[null," In this section, calculations with double integrals, will be carried out, for each"]
[null,"of above.   The calculations are based on the following:"]
[null," "]
[null,null,"The X axis will be based 0 to",{"$nulls":5},{"$error":"#DIV/0!"}]
[null,null,"The Y axis will be based 0 to",{"$nulls":5},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"}]
[]
[{"$nulls":5},"(M-AX-BY)dxdy =",null,null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"K"]
[{"$nulls":5},0]
[{"$nulls":4},0]
[null,"Spreadsheet formula for the above is =((2*M*X*Z-A*Z*(X^2)-K*X*(Z^2))/2*B)"]
[{"$nulls":8},"M =",0]
[null,"Z =","M-AX-BY",null,"These are the values",{"$nulls":3},"A =",0]
[null,null,"K",null," you entered  in the ",{"$nulls":3},"K =",0]
[{"$nulls":4},"white input boxes. ",{"$nulls":3},"B =",0]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"}]
[]
[{"$nulls":5},"(N-DX-EY)dxdy =",null,null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"F"]
[{"$nulls":5},0]
[{"$nulls":4},0]
[null,"Spreadsheet formula for the above is =((2*N*X*Z-D*Z*(X^2)-F*X*(Z^2))/2*E)"]
[{"$nulls":8},"N=",0]
[null,"Z=","N-DX-EY",null,"These are the values",{"$nulls":3},"D=",0]
[null,null,"F",null," you entered  in the ",{"$nulls":3},"F=",0]
[{"$nulls":4},"white input boxes. ",{"$nulls":3},"E=",0]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"}]
[]
[{"$nulls":5},"(W-GX-HY)dxdy =",null,null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"J"]
[{"$nulls":5},0]
[{"$nulls":4},0]
[null,"Spreadsheet formula for the above is =((2*W*X*Z-D*Z*(X^2)-F*X*(Z^2))/2*H)"]
[{"$nulls":8},"W=",0]
[null,"Z=","W-GX-HY",null,"These are the values",{"$nulls":3},"G=",0]
[null,null,"J",null," you entered  in the ",{"$nulls":3},"J=",0]
[{"$nulls":4},"white input boxes. ",{"$nulls":3},"H=",0]
[]
[null,"A Ratio Problem Involving only X as an Unknown"]
[null,null,"In this section: the equations AX+BY+KZ=M, DX+EY+FZ=N, and "]
[null," ","GX+HY+JZ=W and unknowns X, Y, and Z are converted into a ratio "]
[null,null,"problem, with only one  unknown, X.  This is possible because the "]
[null,null,"values for X, Y and Z  have been calculated.   "]
[null,"If P*X=Z",{"$nulls":6},"If V*X=Y"]
[null,"then P=Z/X",{"$nulls":6},"then V=Y/X"]
[null,"In terms of numbers",{"$nulls":6},"In terms of numbers"]
[null,"P=",{"$error":"#DIV/0!"},{"$nulls":5},"V=",{"$error":"#DIV/0!"}]
[null,"P*X=",{"$error":"#DIV/0!"},{"$nulls":5},"V*X=",{"$error":"#DIV/0!"}]
[null,"Z=",{"$error":"#DIV/0!"},{"$nulls":5},"Y=",{"$error":"#DIV/0!"}]
[null,null,"Thus, all of the unknowns represented",{"$nulls":6},"Thus, all of the unknowns represented"]
[null,null," by Z can be replaced by P*X",{"$nulls":6}," by Y can be replaced by V*X"]
[null,"The three equations (AX+BY+KZ=M, DX+EY+FZ=N, GX+HY+JZ=W) "]
[null," can now be rewritten in terms of X, as follows:"]
[]
[null,"AX+BY+KZ=M",{"$nulls":4},"DX+EY+FZ=N",{"$nulls":5},"GX+HY+JZ=W"]
[null,"In terms of X   ",{"$nulls":4},"In terms of X   ",{"$nulls":5},"In terms of X   "]
[null,"AX+BVX+KPX=M",{"$nulls":4},"DX+EVX+FPX=N",{"$nulls":5},"GX+HVX+JPX=W"]
[null,"The above conclusions and calculations can be checked as follows:"]
[]
[{"$nulls":4},"AX+BY+KZ =",{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":4},"AX+BVX+KPX =",{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":4},"DX+EY+FZ=",{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":4},"DX+EVX+FPX=",{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":4},"GX+HY+JZ=",{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":4},"GX+HVX+JPX=",{"$nulls":3},{"$error":"#DIV/0!"}]
[]
[null,null,"AX+BY+KZ=M rewritten in terms of X is AX+BVX+KPX=M  "]
[null,null,"This can be restated in the form of a word problem as follows: "]
[]
[null," ",null,"There are three numbers in the ratio of A, B*V, and K*P, "]
[null,null," ","and the sum of the three numbers is M."]
[]
[null," In terms of calculated data the three numbers are in the following RATIOS: "]
[]
[{"$nulls":6},"     A    =",null,0]
[{"$nulls":6},"     B*V   =",null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"    K*P  =",null,{"$error":"#DIV/0!"}]
[]
[null,null,"The three numbers are as follows:"]
[]
[{"$nulls":6},"A*X  =",null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"B*V*X =",null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"K*P*X=",null,{"$error":"#DIV/0!"}]
[]
[null,null,"The sum of the numbers is:",{"$nulls":5},{"$error":"#DIV/0!"}]
[null,null,"The above should equal M =",{"$nulls":5},0]
[]
[null,null,"DX+EY+FZ=N rewritten in terms of X is DX+EVX+FPX=N "]
[null,null,"This can be restated in the form of a word problem as follows: "]
[]
[null," ",null,"There are three numbers in the ratio of D, E*V, and F*P, "]
[null,null," ","and the sum of the three numbers is N."]
[]
[null," In terms of calculated data the three numbers are in the following RATIOS: "]
[]
[{"$nulls":6},"     D  =",null,0]
[{"$nulls":6},"     E*V   =",null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"    F*P=",null,{"$error":"#DIV/0!"}]
[]
[null,null,"The three numbers are as follows:"]
[]
[{"$nulls":6},"D*X  =",null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"E*V*X =",null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"F*P*X=",null,{"$error":"#DIV/0!"}]
[]
[null,null,"The sum of the numbers is:",{"$nulls":5},{"$error":"#DIV/0!"}]
[null,null,"The above should equal N =",{"$nulls":5},0]
[]
[null,null,"GX+HY+JZ=W rewritten in terms of X is GX+HVX+JPX=W  "]
[null,null,"This can be restated in the form of a word problem as follows: "]
[]
[null," ",null,"There are three numbers in the ratio of G, H*V, and J*P, "]
[null,null," ","and the sum of the three numbers is W."]
[]
[null," In terms of calculated data the three numbers are in the following RATIOS: "]
[]
[{"$nulls":6},"     G =",null,0]
[{"$nulls":6},"     H*V  =",null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"    J*P=",null,{"$error":"#DIV/0!"}]
[]
[null,null,"The three numbers are as follows:"]
[]
[{"$nulls":6},"G*X  =",null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"H*V*X =",null,{"$error":"#DIV/0!"}]
[{"$nulls":6},"J*P*X=",null,{"$error":"#DIV/0!"}]
[]
[null,null,"The sum of the numbers is:",{"$nulls":5},{"$error":"#DIV/0!"}]
[null,null,"The above should equal W =",{"$nulls":5},0]
[]
[]
[null,"Miscellaneous Calculations: Solving for Additional Unknowns"]
[]
[{"$nulls":4},"This device solves for S"]
[{"$nulls":4},"A*(E+S)=B*K-Y"]
[{"$nulls":4},"S =",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for the above is =(B*K-Y-A*E)/A"]
[1,{"$nulls":3},{"$error":"#DIV/0!"}]
[{"$nulls":3},"Spreadsheet formula for above =ROUND(A*(E+S),Rd)=ROUND(B*K-Y,Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for T"]
[{"$nulls":4},"X+T+S=A*B*K-Y"]
[{"$nulls":4},"T=",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above =A*B*K-Y-X-S"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":3},"Spreadsheet formula for above =ROUND(X+T+S, Rd)=ROUND(A*B*K-Y, Rd)"]
[null,null,"`",null,"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":5},"This device solves for U"]
[{"$nulls":5},"ST-A=B+Z+U"]
[{"$nulls":5},"U=",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above =S*T-A-B-Z"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":3},"Spreadsheet formula for above =ROUND(S*T-A,Rd)=ROUND(B+Z+U,Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Q"]
[{"$nulls":5},"T+S-A  =  (S+Z+U+X)"]
[{"$nulls":9},"Q"]
[{"$nulls":4},"Q=",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above =(S+Z+U+X)/(T+S-A)"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":3},"Spreadsheet formula for above=ROUND(T+S-A, Rd)=ROUND(((S+Z+U+X)/Q),Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Aa "]
[{"$nulls":4},"T*S+X+Y+Z=U+Q+Aa "]
[{"$nulls":4},"Aa =",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above =(T*S+X+Y+Z)-(U+Q)"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":3},"Spreadsheet formula for above =ROUND(T*S+X+Y+Z, Rd)=ROUND(U+Q+Aa, Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Ba "]
[{"$nulls":4},"T*S+X+Y+Z=U+Q*Aa*Ba "]
[{"$nulls":4},"Ba =",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above =(T*S+X+Y+Z-U)/(Q*Aa)"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,null,"Spreadsheet formula for above=ROUND(T*S+X+Y+Z, Rd)=ROUND(U+Q+Aa*Ba, Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Ca "]
[{"$nulls":4},"Ca*(X+Y+Z)=U+Q+Aa*Ba "]
[{"$nulls":4},"Ca=",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above=(U+Q+Aa*Ba)/(X+Y+Z)"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,null,"Spreadsheet formula for above =ROUND(Ca*(X+Y+Z), Rd)=ROUND(U+Q+Aa*Ba, Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Da "]
[{"$nulls":4},"U*Q=U+Q+Aa*Ba+Da "]
[{"$nulls":4},"Da=",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above =U*Q-(U+Q+Aa*Ba)"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,null,"Spreadsheet formula for above =ROUND(U*Q,Rd)= ROUND(U+Q+Aa*Ba+Da, Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Ea "]
[{"$nulls":4},"X+Y+Z= Ea*(U+Q+Aa*Ba+Da+Ca) "]
[{"$nulls":4},"Ea =",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above =(X+Y+Z)/(U+Q+Aa*Ba+Da+Ca)"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,null,"Spreadsheet formula for above  =ROUND(X+Y+Z, Rd)=ROUND(Ea*(U+Q+Aa*Ba+Da+Ca), Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Fa "]
[{"$nulls":4},"A*(Fa+X+Y+Z)= Ea+U+Q+Aa*Ba+Da+Ca "]
[{"$nulls":4},"Fa =",{"$error":"#DIV/0!"}]
[{"$nulls":3},"Spreadsheet formula for above=((Ea+U+Q+Aa*Ba+Da+Ca)/A)-(X+Y+Z)"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above =ROUND(A*(Fa+X+Y+Z), Rd)=ROUND(Ea+U+Q+Aa*Ba+Da+Ca, Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Ga "]
[{"$nulls":4},"A*(Aa+Ba+Ca+Da+Ea+Fa+U+Q) =X+Y+Z+Ga  "]
[{"$nulls":4},"Ga =",{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above=A*(Aa+Ba+Ca+Da+Ea+Fa+U+Q)-(X+Y+Z)"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,null,"Spreadsheet formula for above=ROUND(A*(Aa+Ba+Ca+Da+Ea+Fa+U+Q), Rd)=ROUND(X+Y+Z+Ga, Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[null,"Miscellaneous Calculations Solving for trigonometric Unknowns"]
[]
[{"$nulls":4},"This device solves for Angle_A in radians "]
[{"$nulls":4},"Tan(Angle_A)=Y/X"]
[{"$nulls":4},"Tan(Angle_A) =",null,null,{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above = Y/X"]
[{"$nulls":4},"Angle_A=",null,{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above = =ATAN(Y/X)"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":3},"Spreadsheet formula for above =ROUND(TAN(Angle_A), Rd)=ROUND(Y/X, Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":3},"This device solves for Tan(Angle_B), and Angle_A in radians"]
[{"$nulls":4},"Tan(Angle_B)=X/Y"]
[{"$nulls":4},"Tan(Angle_B) =",null,null,{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above  =X/Y"]
[{"$nulls":4},"Angle_B=",null,{"$error":"#DIV/0!"}]
[{"$nulls":4},"Spreadsheet formula for above =ATAN(X/Y)"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[{"$nulls":3},"Spreadsheet formula for above =ROUND(TAN(Angle_B), Rd)=ROUND(X/Y, Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Ja"]
[{"$nulls":4},"Ja+Sin(Angle_A)+Cos(Angle_A)=Tan(Angle_B)+A+B "]
[{"$nulls":4},"Ja =",{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above=TAN(Angle_B)+A+B-(SIN(Angle_A)+COS(Angle_A))"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above=ROUND(Ja+SIN(Angle_A)+COS(Angle_A), Rd)=ROUND(TAN(Angle_B)+A+B, Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Ka"]
[{"$nulls":4},"Ka*(Ja+Sin(Angle_A)) = Tan(Angle_B)+A+B+X "]
[{"$nulls":4},"Ka =",{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above=(TAN(Angle_B)+A+B+X)/(Ja+SIN(Angle_A))"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above=ROUND(Ka*(Ja+SIN(Angle_A)), Rd)=ROUND((TAN(Angle_B)+A+B+X), Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for La"]
[{"$nulls":4},"La+Cos(Angle_A)=Tan(Angle_B)+Sin(Angle_A)"]
[{"$nulls":4},"La=",{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above=TAN(Angle_B)+SIN(Angle_A)-(COS(Angle_A))"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above=ROUND(La+COS(Angle_A),Rd)=ROUND(TAN(Angle_B)+SIN(Angle_A), Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Ma"]
[{"$nulls":4},"Ma+La*Sin(Angle_A)=Tan(Angle_B)+A+K+D"]
[{"$nulls":4},"Ma =",{"$error":"#DIV/0!"}]
[null,null,"Spreadsheet formula for above =TAN(Angle_B)+A+K+D-(La*SIN(Angle_A))"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above=ROUND(Ma+La*SIN(Angle_A),Rd)=ROUND(TAN(Angle_B)+A+K+D, Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Na"]
[{"$nulls":4},"D+Na*Sin(Angle_A) = Tan(Angle_A)+Ma+La+Ma "]
[{"$nulls":4},"Na =",{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above=(TAN(Angle_A)+Ma+La+Ma-D)/(SIN(Angle_A))"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above =ROUND(D+Na*SIN(Angle_A), Rd)=ROUND(TAN(Angle_A)+Ma+La+Ma, Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[{"$nulls":4},"This device solves for Pa"]
[{"$nulls":4},"Pa+Cos(Angle_B)=Tan(Angle_B)+Sin(Angle_B)-A-M"]
[{"$nulls":4},"Pa=",{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above =TAN(Angle_B)+SIN(Angle_B)-(COS(Angle_B))-A-M"]
[{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"Spreadsheet formula for above =ROUND(Pa+COS(Angle_B),Rd)=ROUND(TAN(Angle_B)+SIN(Angle_B)-A-M,Rd)"]
[{"$nulls":4},"TRUE = NO Errors for this calculation"]
[{"$nulls":4},"FALSE = ERROR no result for the numbers you entered."]
[]
[]
[]
[]
[null,"CREATED BY:  David@TechForText.com ©2010  To contact the author use the email address on the left. "]