I need a spreadsheet based on the tables on pages 3, 4 and 5 of the attached document.
The tables are divided into "Alvenaria" (Masonry, page 3), "Mista" (mixed, page 4) and "Madeira" (wood, page 5).
After choose the correct table, the first field "Idade do prédio" is the age of the building (minimum and maximum), based on this data line should be chosen for multiplication, the column is chosen based on the titles "Alto" (high), "normal" (normal), "simples" (simple) or "popular".
With these data (the user chooses the table, the age of the building and construction), the spreadsheet should get the multiplier (eg 1.3), multiply by another user input call CUB and multiply the result by another entry user called "building area".
The result should be added to a user's entry called "value of the land".
In summary, the user must enter the following information:
a) age of the land
b) construction type
c) CUB value
d) Building area
e) Value of Land
the letters "a " and "b"should be used to find the multiplication factor that must be multiplied by "c" and by "d" and the result added to the "e".
I am available to answer all questions