excel equations
Budget: €30 – €250 EUR
we have a very specific problem in excel. We need to correct a formula that is not working for different values to 1 for varibles a, b and c. We need a professional that can Unblock it inmediately. This is as approach to the problem we look for an expert at:
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.