top

The Algebraic Calculator for Three Unknowns

To contact the author use the above email address, or

left click on these words for a website communication form.

This website provides a free calculation device, called the Algebraic Calculator for Three Unknowns, available in the JavaScript and spreadsheet formats.  This Calculator solves three equations simultaneously, for three unknowns (for AX+BY+KZ=M, DX+EY+FZ=N, and GX+HY+JZ=W, for X, Y, and Z).

The JavaScript version of the Algebraic Calculator for Three Unknowns functions online and it is embedded in this webpage, below the instructions.  If you want the spreadsheet version, or additional information, scroll all the way down beneath the online Calculator.

Instructions for the Algebraic Calculator for Three Unknowns

The Algebraic Calculator for Three Unknowns solves three equations for X, Y, and Z.  The equations must be similar to AX+BY+KZ=M, DX+EY+FZ=N, and GX+HY+JZ=W, such as the following examples

2X+3Y+5Z=10, 1X+4Y+7Z=18, 9X-4Y+6Z=22

-X+2Y-9Z=24, 8X+6Y+12Z=33, 2X+9Y+14Z=36

77X+56Y+45Z=130, 66X+34Y+19Z=68, 35X+32Y+21Z=88

2X+3Y+4Z=0, 1X-6Y-9Z=6, 3X+2Y-7Z=-4

If the equations you want to solve do not look like the above, try to algebraically rearrange them to make them similar to: AX+BY+KZ=M, DX+EY+FZ=N, and GX+HY+JZ=W.

To use the Algebraic Calculator for Three Unknowns enter TWELVE numbers in the twelve white input boxes, for A, B, K, M, D, E, F, N, G, H, J, and W.  (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.

Note: If less than 12 numbers are entered the Algebraic Calculator for Three Unknowns may not function properly.  The Calculator has a number of error-checking devices that may display error messages while entering numbers, which may continue until all 12 numbers have been entered.

If you entered a set of numbers that do not satisfy all of the equations in the Algebraic Calculator for Three Unknowns, you may get error messages that relate to one or more specific equations.

For a printer friendly version of the Calculator left click here.  (If you print the version presented below, everything on this webpage will be printed.)

The Online Algebraic Calculator for Three Unknowns

 Algebraic Calculator for Three Unknowns AX+BY+KZ=M, DX+EY+FZ=N, GX+HY+JZ=W Error checking and input boxes for AX+BY+KZ = M Accuracy % A= X + Error % B= Y + AX+BY+KZ = K= Z + (AX+BY+KZ) - M = M= = M Z = Above, right is a representation of the equation you entered. If an equation has numbers with more than four digits, look at the vertical representation of the equation, (right side of input boxes, blue numbers and letters) Error checking and input boxes for DX+EY+FZ = N Accuracy % D= X + Error % E= Y + DX+EY+FZ = F= Z + (DX+EY+FZ) - N = N= = N Z = Above, right is a representation of the equation you entered. If an equation has numbers with more than four digits, look at the vertical representation of the equation, (right side of input boxes, blue numbers and letters) Error checking and input boxes for GX+HY+JZ = W Accuracy % G = X + Error % H = Y + GX+HY+JZ = J = Z + (GX+HY+JZ) - W = W = = W Z = Above, right is a representation of the equation you entered. If an equation has numbers with more than four digits, look at the vertical representation of the equation, (right side of input boxes, blue numbers and letters) The Multiple-Algebraic Calculator has a number of error-checking devices (above and below). These devices check the calculations and the numbers you entered to determine if they satisfy the equations. These devices provide feedback in words or numbers. The calculations for all of the error-checking devices are rounded to decimal places. You can change this, 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. Note: The number of zeros displayed is not affected by the blue number. The Calculated Results, for X, Y, and Z are Displayed below ( for AX+BY+KZ=M, DX+EY+FZ=N, GX+HY+JZ=W ) X = Y = Z = Spreadsheet formula for X is =(M-(B*Y+K*Z))/A Spreadsheet formula for Y is =(A*N+D*K*Z-A*F*Z-D*M)/(A*E-D*B) Spreadsheet formula for Z is =((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) Displayed below are calculated values for X, Y and Z that have been rounded to specified number of decimal places Calculated results on this list are rounded to decimal places. You can change this, by deleting the blue number above, and entering the number of decimal places you prefer. X = Y = Z = CREATED BY: David@TechForText.com ©2010 To contact the author use the email address on the left.

Software Requirements for

The Algebraic Calculator for Three Unknowns,

The Software You Need for the

Algebraic Calculator for Three Unknowns

The spreadsheet versions of the Algebraic Calculator for Three Unknowns require either Microsoft Excel, or the free OpenOffice.org software package, (available from www.OpenOffice.org).  In addition, Microsoft Windows is required for the spreadsheet versions.

The JavaScript version of the Algebraic Calculator for Three Unknowns can run on any operating system that has JavaScript support, but I only tested it with Microsoft Windows.  In addition, the JavaScript version requires a browser that supports JavaScript.  Almost all modern operating systems and browsers support JavaScript.

If you want the Algebraic Calculator for Three Unknowns in the Microsoft Excel format, left click on these words.

If you want the Algebraic Calculator for Three Unknowns in the newer 2007 Microsoft Excel format, left click on these words.  Note, this requires Microsoft Excel 2007 or newer additions of Excel.

If you want the spreadsheet version of the Algebraic Calculator for Three Unknowns that was used to create the JavaScript version left click on these words. (This is in Microsoft Excel format).

If you want the Algebraic Calculator for Three Unknowns in the OpenOffice Calc format, left click on these words.  This requires the free OpenOffice.org software package.

If you want the online JavaScript Algebraic Calculator for Three Unknowns in a printer friendly format, left click on these words.

If you want the JavaScript Algebraic Calculator for Three Unknowns, that was embedded in this webpage, left click on these words.

If you want the Algebraic Calculator for Three Unknowns in all of the above formats, in a zip folder, left click on these words.

Services Offered by the Author

This website was designed to maximize efficiency and ease-of-use (usability, user-friendliness).  The text is presented with large fonts.  The paragraphs are relatively short, and the sentence structure and wording were written to maximize *comprehension.  The website has a very simple layout, on a single page.  This makes it easy to navigate intuitively, by scrolling down or up.  All the links for downloads and other websites are also written with large fonts, and clearly marked as links, such as with the following words: left click on these words.

*Note: The material on this website and the Algebraic Calculator for Three Unknowns is technical.  A background in mathematics and spreadsheet software is required for maximum comprehension.  However, most individuals, without the technical background, will probably understand most of the material, if they have studied algebra.

Services Offered by the Author David@TechForText.com

I design and build user-friendly software based calculation devices for arithmetic, accounting, currency exchange rates, algebra, trigonometry, correlations, calculus, and databases with built-in calculation devices.  I also create attractive online calculation devices, and web communication forms for websites.  This includes website forms with built-in calculation devices.

I generally make these devices in the Microsoft Excel, OpenOffice Calc, and the JavaScript formats, but I can work with other spreadsheet formats besides the above.

I write instructions for the devices I build.  I can also write instructions for software and computer devices created by others.  In addition, I can write advertising for your websites, products and services.

For a list of all the services I offer see www.TechForText.com

For a list of all my websites see www.David100.com

My resume is online at: www.David100.com/R

I can provide the services mentioned above on a fee-for-service basis, or possibly based on temporary or permanent employment.  If you are interested in my services, and want additional contact information or more data on the services I offer, you can email me at David@TechForText.com or use a website communication form, by left clicking on these words.

I am located in the USA.  If you are a great distance from my locality or are in another country, this is not important.  I can provide these services worldwide, because the software and websites I make can be delivered through the Internet to any locality, providing there are no governmental restrictions.

To return to the top of this website left click on these words