equations of 6-10 variables in microsoft excel
Budget: €30 – €250 EUR
We need to solve an equation in excel so that the whole file and plan is correct. It is not working today and we need to fix it. Please read carefully the following details before applying. This is the challenge:
D138 PROBLEM
There is a serie of incomes and other of expenses fro 2022 up to 2035.
The value of Incomes I by 2035 (R130) must equal that of expenses E (R154) also at 2035 point. so I=E by 2035.
Expenses are formed by adding to type of expenses, Fixed F (R153) and variables V (R152) so that F+V=E
Variable expenses depend on 3 series, X (row138),Y (row139) and Z(row140), with internal depencies among them and with users U adoption (row7).
Series X,Y,Z series depend on their first value (D138, D139 y D140) and the decay value D (D137)
D139 and D140 depend on D138
Relation among X,Y,Z series is defined by 3 values a (E137), b(F137), c(G137) and U so that aXU+bYU+cZU=V
We must calculate D138 so that by 2035 Incomes R130 equal Expenses R154 so that I=E as a total of the serie accumulated at 2035.
D138 PROBLEM
There is a serie of incomes and other of expenses fro 2022 up to 2035.
The value of Incomes I by 2035 (R130) must equal that of expenses E (R154) also at 2035 point. so I=E by 2035.
Expenses are formed by adding to type of expenses, Fixed F (R153) and variables V (R152) so that F+V=E
Variable expenses depend on 3 series, X (row138),Y (row139) and Z(row140), with internal depencies among them and with users U adoption (row7).
Series X,Y,Z series depend on their first value (D138, D139 y D140) and the decay value D (D137)
D139 and D140 depend on D138
Relation among X,Y,Z series is defined by 3 values a (E137), b(F137), c(G137) and U so that aXU+bYU+cZU=V
We must calculate D138 so that by 2035 Incomes R130 equal Expenses R154 so that I=E as a total of the serie accumulated at 2035.