1

Topic: Filling of the table of the decision of system of the non-linear equations (it is desirable without VBA)

Day kind the respected. Help to solve a problem please.
The task.
1. It is necessary to solve system of the linear equation (3 the order) and to fill the table with values R1 R2 R3, thus that one coefficient beta = from 15 to 360 with step 15 changes only, remaining constants except Mkr it accepts 2 values 320 and 0 accordingly 2 tables
In screenshots the formula and the table which already has been filled earlier, at me should it turns out the same values and the same table. It not course or the thesis, and real calculations for the Marking plan of a binding of a tower crane to inhabited houses, the wife asked to make, it the engineer naturally I could not tell that I will not cope Excel.
That made
While solved system for one value beta=15 a reciprocal matrix method. For one value beta it was required to involve a heap of cells (a matrix, a reciprocal matrix and unknown persons), mind I will not put as to organize the decision in a cycle if it is possible without VBA if there is no who the ready decision, in  generally in any way can suggest to help.
Screenshots

2

Re: Filling of the table of the decision of system of the non-linear equations (it is desirable without VBA)


The second screen was not interposed

3

Re: Filling of the table of the decision of system of the non-linear equations (it is desirable without VBA)

Timuridze wrote:

system of the linear equation (3 the order)

Perhaps system from 3 linear equations? 3rd order is a fig not the "linear" equations...

Timuridze wrote:

how to organize the decision in a cycle if it is possible without VBA

If the equations  linear - so the formula becomes "on time", analytically such system dares easily.