Compile | Decompile | Upload |
This is the MM source of your spreadsheet, listing the variables ("attributes"), and the equations relating them. Just after you have decompiled the spreadsheet, the attributes will have the same names as the cells, but you can rename them. You can also ask MM to guess their names by looking at adjacent labels.
These are the cell addresses of the attributes.
C11 -> C11 a e f v
C21 -> C21 a e f v
C31 -> C31 a e f v
F11 -> F11 a e f v
C10 -> C10 a e f v
C20 -> C20 a e f v
C30 -> C30 a e f v
F10 -> F10 a e f v
C9 -> C9 a e f v
C19 -> C19 a e f v
C29 -> C29 a e f v
C8 -> C8 a e f v
B28 -> B28 a e f v
C18 -> C18 a e f v
F8 -> F8 a e f v
C7 -> C7 a e f v
B27 -> B27 a e f v
C17 -> C17 a e f v
C6 -> C6 a e f v
C16 -> C16 a e f v
C15 -> C15 a e f v
C34 -> C34 a e f v
C23 -> C23 a e f v
C33 -> C33 a e f v
C22 -> C22 a e f v
C32 -> C32 a e f v
These are the addresses and contents of text cells that don't take part in the calculations. Just after you have decompiled the spreadsheet, there will be none of these, because MM starts by assuming all cells do take part. However, you can ask it to guess which cells are annotations.
B11 -> "Costs per Unit (excl advertising) (N#)"
B21 -> "New Costs (incl of Advertising) (N#)"
B31 -> "Final Advertising (N#) working area"
E11 -> "Change in Advertising (%)"
B10 -> "Original Price (N#)"
B20 -> "Original Costs (incl of Advertising) (N#)"
B30 -> "Initial Quantity (Q) working area"
E10 -> "AED set by user"
B9 -> "Final Quantity (Q)"
B19 -> "New Total Revenue (N#)"
B29 -> "Intital Advertising (N#) working area"
B8 -> "Final Adervtising (N#)"
B18 -> "Original Total Revenue (N#)"
E8 -> "Use these inputs ? (yes / no)"
B7 -> "Initial Quantity (Q)"
B6 -> "Intital Advertising (N#)"
B16 -> "Description"
B15 -> "AED"
B25 -> "Working Area"
B4 -> "Input"
B34 -> "Costs per Unit (working area) (N#)"
B13 -> "Output Area"
B23 -> "New Profit (N#)"
B33 -> "Original Price (N#) working area"
B2 -> "Advertising Elasticity of Demand"
B22 -> "Original Profit (N#)"
B32 -> "Final Quantity (Q) working area"
This is the result of running the spreadsheet.
A | B | C | D | E | F | |
1 | ||||||
2 | Advertising Elasticity of Demand | |||||
3 | ||||||
4 | Input | |||||
5 | ||||||
6 | Intital Advertising (N#) | 100 @ a e f | ||||
7 | Initial Quantity (Q) | 100 @ a e f | ||||
8 | Final Adervtising (N#) | 120 @ a e f | Use these inputs ? (yes / no) | no @ a e f | ||
9 | Final Quantity (Q) | 150 @ a e f | ||||
10 | Original Price (N#) | 20 @ a e f | AED set by user | 0.8 @ a e f | ||
11 | Costs per Unit (excl advertising) (N#) | 7 @ a e f | Change in Advertising (%) | 5 @ a e f | ||
12 | ||||||
13 | Output Area | |||||
14 | ||||||
15 | AED | 5/2 @ a e f | ||||
16 | Description | -> change in advertising shifts demand for the good to the right @ a e f | ||||
17 | -> relatively elastic. A 1% increase in advertisng causes a larger than 1% increase in the quantity demanded @ a e f | |||||
18 | Original Total Revenue (N#) | 2000 @ a e f | ||||
19 | New Total Revenue (N#) | 3000 @ a e f | ||||
20 | Original Costs (incl of Advertising) (N#) | 800 @ a e f | ||||
21 | New Costs (incl of Advertising) (N#) | 1170 @ a e f | ||||
22 | Original Profit (N#) | 1200 @ a e f | ||||
23 | New Profit (N#) | 1830 @ a e f | ||||
24 | ||||||
25 | Working Area | |||||
26 | ||||||
27 | -> change in advertising shifts demand for the good to the right @ a e f | |||||
28 | -> relatively elastic. A 1% increase in advertisng causes a larger than 1% increase in the quantity demanded @ a e f | |||||
29 | Intital Advertising (N#) working area | 100 @ a e f | ||||
30 | Initial Quantity (Q) working area | 100 @ a e f | ||||
31 | Final Advertising (N#) working area | 105 @ a e f | ||||
32 | Final Quantity (Q) working area | 104.0 @ a e f | ||||
33 | Original Price (N#) working area | 20 @ a e f | ||||
34 | Costs per Unit (working area) (N#) | 7 @ a e f |
This is the spreadsheet in formula view.
Compile | Decompile | Upload |