equations migrated to excel formulas
Budget: €30 – €250 EUR
we have a problem in one calculation of our excel file. It works but does not respect maximum limit so we need an expert that can Identify where the problem is. this is the problem:
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.