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.
C28 -> C28 a e f v
E28 -> E28 a e f v
C41 -> C41 a e f v
C13 -> C13 a e f v
C40 -> C40 a e f v
C12 -> C12 a e f v
C39 -> C39 a e f v
E12 -> E12 a e f v
E39 -> E39 a e f v
C11 -> C11 a e f v
C38 -> C38 a e f v
E11 -> E11 a e f v
E38 -> E38 a e f v
C24 -> C24 a e f v
E24 -> E24 a e f v
G24 -> G24 a e f v
C10 -> C10 a e f v
C37 -> C37 a e f v
E10 -> E10 a e f v
E37 -> E37 a e f v
C23 -> C23 a e f v
E23 -> E23 a e f v
G23 -> G23 a e f v
C9 -> C9 a e f v
C36 -> C36 a e f v
E9 -> E9 a e f v
E36 -> E36 a e f v
C22 -> C22 a e f v
E22 -> E22 a e f v
G22 -> G22 a e f v
C8 -> C8 a e f v
C35 -> C35 a e f v
E8 -> E8 a e f v
E35 -> E35 a e f v
C21 -> C21 a e f v
E21 -> E21 a e f v
G21 -> G21 a e f v
C7 -> C7 a e f v
C34 -> C34 a e f v
E7 -> E7 a e f v
E34 -> E34 a e f v
C20 -> C20 a e f v
E20 -> E20 a e f v
G20 -> G20 a e f v
C6 -> C6 a e f v
C33 -> C33 a e f v
E6 -> E6 a e f v
E33 -> E33 a e f v
C19 -> C19 a e f v
E19 -> E19 a e f v
G19 -> G19 a e f v
C32 -> C32 a e f v
E32 -> E32 a e f v
C31 -> C31 a e f v
E31 -> E31 a e f v
C30 -> C30 a e f v
E30 -> E30 a e f v
C29 -> C29 a e f v
E29 -> E29 a e f v
C42 -> C42 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 -> "PED of Milk"
B21 -> "Total Revenue (N#) coffee"
D11 -> "CPED tea with Coffee"
B31 -> "Corporation Tax for GROWERS (stable, increase, decrease) working area"
D21 -> "Total Revenue (N#) milk"
B41 -> "contst corp tax"
D31 -> "const demand (tea)"
F21 -> "Total Revenue (N#) tea"
B10 -> "Harvest conditions for growers (stable, good, poor)"
B20 -> "Quantity coffee"
D10 -> "PES of Tea"
B30 -> "Advertsing Budget (stable, increase, decrease) working area"
D20 -> "Quantity milk"
B40 -> "contst advert"
D30 -> "conts CPED milk"
F20 -> "Quantity tea"
B9 -> "Corporation Tax for GROWERS (stable, increase, decrease)"
B19 -> "Price (N#) coffee"
D9 -> "PED of Tea"
B29 -> "Income Tax (stable, increase, decrease) working area"
D19 -> "Price (N#) milk"
B39 -> "contst income tax"
D29 -> "const supply (milk)"
D39 -> "Original TR - tea"
F19 -> "Price (N#) tea"
B8 -> "Advertsing Budget (stable, increase, decrease)"
D8 -> "YED of Coffee"
B28 -> "World Income (stable, increase, decrease) working area"
B38 -> "contst world income"
D28 -> "const demand (milk)"
D38 -> "Original Quantity - tea"
B7 -> "Income Tax (stable, increase, decrease)"
B17 -> "Coffee Market"
D7 -> "PES of Coffee"
B27 -> "Working Area - DO NOT CHANGE !!!!!"
D17 -> "Milk Market"
B37 -> "const supply"
D37 -> "Original Price - tea"
F17 -> "Tea Market"
B6 -> "World Income (stable, increase, decrease)"
D6 -> "PED of Coffee"
B36 -> "const demand"
D36 -> "Original TR - milk"
B5 -> "Input Area"
B15 -> "Output Area"
B35 -> "Original TR"
D35 -> "Original Quantity - milk"
B24 -> "Change in Total Revenue (%) coffee"
B34 -> "Original Quantity"
D24 -> "Change in Total Revenue (%) milk"
D34 -> "Original Price - milk"
F24 -> "Change in Total Revenue (%) tea"
B13 -> "CPED Coffee with Milk"
B23 -> "Change in Quantity (%) coffee"
B33 -> "Original Price"
D23 -> "Change in Quantity (%) milk"
D33 -> "const CPED tea"
F23 -> "Change in Quantity (%) tea"
B2 -> "Interrelationship between Markets"
B12 -> "PES of Milk"
B22 -> "Change in Price (%) coffee"
D12 -> "PED for Adverting (coffee)"
B32 -> "Harvest conditions for growers (stable, good, poor) working area"
D22 -> "Change in Price (%) milk"
B42 -> "contst harvest"
D32 -> "const supply (tea)"
F22 -> "Change in Price (%) tea"
This is the result of running the spreadsheet.
A | B | C | D | E | F | G | |
1 | |||||||
2 | Interrelationship between Markets | ||||||
3 | |||||||
4 | |||||||
5 | Input Area | ||||||
6 | World Income (stable, increase, decrease) | stable @ a e f | PED of Coffee | 0.8 @ a e f | |||
7 | Income Tax (stable, increase, decrease) | stable @ a e f | PES of Coffee | 0.5 @ a e f | |||
8 | Advertsing Budget (stable, increase, decrease) | stable @ a e f | YED of Coffee | 1.6 @ a e f | |||
9 | Corporation Tax for GROWERS (stable, increase, decrease) | stable @ a e f | PED of Tea | 0.8 @ a e f | |||
10 | Harvest conditions for growers (stable, good, poor) | stable @ a e f | PES of Tea | 0.5 @ a e f | |||
11 | PED of Milk | 0.7 @ a e f | CPED tea with Coffee | 1.8 @ a e f | |||
12 | PES of Milk | 1.3 @ a e f | PED for Adverting (coffee) | 1.5 @ a e f | |||
13 | CPED Coffee with Milk | -0.8 @ a e f | |||||
14 | |||||||
15 | Output Area | ||||||
16 | |||||||
17 | Coffee Market | Milk Market | Tea Market | ||||
18 | |||||||
19 | Price (N#) coffee | 108.46153846153845 @ a e f | Price (N#) milk | 14.115384615384613 @ a e f | Price (N#) tea | 364.5384615384615 @ a e f | |
20 | Quantity coffee | 74.23076923076923 @ a e f | Quantity milk | 28.349999999999998 @ a e f | Quantity tea | 186.26923076923075 @ a e f | |
21 | Total Revenue (N#) coffee | 8051.1834319526615 @ a e f | Total Revenue (N#) milk | 400.17115384615374 @ a e f | Total Revenue (N#) tea | 67902.29881656803 @ a e f | |
22 | Change in Price (%) coffee | 4.2553190454354385E-7 @ a e f | Change in Price (%) milk | -2.7247956547444495E-6 @ a e f | Change in Price (%) tea | 1.055074068017914E-8 @ a e f | |
23 | Change in Quantity (%) coffee | 7.979649166413698E-4 @ a e f | Change in Quantity (%) milk | -1.2531617914640217E-14 @ a e f | Change in Quantity (%) tea | -1.6518701042120677E-8 @ a e f | |
24 | Change in Total Revenue (%) coffee | -5.879668514870715E-10 @ a e f | Change in Total Revenue (%) milk | -3.8445114526813784E-8 @ a e f | Change in Total Revenue (%) tea | -5.054272687401756E-9 @ a e f | |
25 | |||||||
26 | |||||||
27 | Working Area - DO NOT CHANGE !!!!! | ||||||
28 | World Income (stable, increase, decrease) working area | 0.0 @ a e f | const demand (milk) | 120 @ a e f | |||
29 | Income Tax (stable, increase, decrease) working area | 0.0 @ a e f | const supply (milk) | 10 @ a e f | |||
30 | Advertsing Budget (stable, increase, decrease) working area | 0.0 @ a e f | conts CPED milk | 5 @ a e f | |||
31 | Corporation Tax for GROWERS (stable, increase, decrease) working area | 0.0 @ a e f | const demand (tea) | 100 @ a e f | |||
32 | Harvest conditions for growers (stable, good, poor) working area | 0.0 @ a e f | const supply (tea) | 4 @ a e f | |||
33 | Original Price | 108.461538 @ a e f | const CPED tea | 5 @ a e f | |||
34 | Original Quantity | 74.2301769 @ a e f | Original Price - milk | 14.115385 @ a e f | |||
35 | Original TR | 8051.183432 @ a e f | Original Quantity - milk | 28.35 @ a e f | |||
36 | const demand | 91 @ a e f | Original TR - milk | 400.171154 @ a e f | |||
37 | const supply | 20 @ a e f | Original Price - tea | 364.5384615 @ a e f | |||
38 | contst world income | 20 @ a e f | Original Quantity - tea | 186.2692308 @ a e f | |||
39 | contst income tax | 20 @ a e f | Original TR - tea | 67902.29882 @ a e f | |||
40 | contst advert | 20 @ a e f | |||||
41 | contst corp tax | 20 @ a e f | |||||
42 | contst harvest | 10 @ a e f |
This is the spreadsheet in formula view.
A | B | C | D | E | F | G | |
1 | |||||||
2 | Interrelationship between Markets | ||||||
3 | |||||||
4 | |||||||
5 | Input Area | ||||||
6 | World Income (stable, increase, decrease) | "stable" @ a e v | PED of Coffee | 0.8 @ a e v | |||
7 | Income Tax (stable, increase, decrease) | "stable" @ a e v | PES of Coffee | 0.5 @ a e v | |||
8 | Advertsing Budget (stable, increase, decrease) | "stable" @ a e v | YED of Coffee | 1.6 @ a e v | |||
9 | Corporation Tax for GROWERS (stable, increase, decrease) | "stable" @ a e v | PED of Tea | 0.8 @ a e v | |||
10 | Harvest conditions for growers (stable, good, poor) | "stable" @ a e v | PES of Tea | 0.5 @ a e v | |||
11 | PED of Milk | 0.7 @ a e v | CPED tea with Coffee | 1.8 @ a e v | |||
12 | PES of Milk | 1.3 @ a e v | PED for Adverting (coffee) | 1.5 @ a e v | |||
13 | CPED Coffee with Milk | -0.8 @ a e v | |||||
14 | |||||||
15 | Output Area | ||||||
16 | |||||||
17 | Coffee Market | Milk Market | Tea Market | ||||
18 | |||||||
19 | Price (N#) coffee | (C36+C38+(C28*E8)+C39+(C29*E8)+(E12*C30)+C40+-C37+-C42+C32+C41+C31/E6+E7) @ a e v | Price (N#) milk | (E28+(C13*C19)+E30+-E29/C11+C12) @ a e v | Price (N#) tea | (E31+(C19*E11)+-E32/E9)+E10 @ a e v | |
20 | Quantity coffee | C37+(C19*E7)+-C31+C32 @ a e v | Quantity milk | E29+(C12*E19) @ a e v | Quantity tea | E32+(E10*G19) @ a e v | |
21 | Total Revenue (N#) coffee | (C19*C20) @ a e v | Total Revenue (N#) milk | (E19*E20) @ a e v | Total Revenue (N#) tea | (G19*G20) @ a e v | |
22 | Change in Price (%) coffee | ((C19+-C33/C33)*100) @ a e v | Change in Price (%) milk | ((E19+-E34/E19)*100) @ a e v | Change in Price (%) tea | ((G19+-E37/G19)*100) @ a e v | |
23 | Change in Quantity (%) coffee | ((C20+-C34/C34)*100) @ a e v | Change in Quantity (%) milk | ((E20+-E35/E20)*100) @ a e v | Change in Quantity (%) tea | ((G20+-E38/G20)*100) @ a e v | |
24 | Change in Total Revenue (%) coffee | ((C21+-C35/C35)*100) @ a e v | Change in Total Revenue (%) milk | ((E21+-E36/E21)*100) @ a e v | Change in Total Revenue (%) tea | ((G21+-E39/G21)*100) @ a e v | |
25 | |||||||
26 | |||||||
27 | Working Area - DO NOT CHANGE !!!!! | ||||||
28 | World Income (stable, increase, decrease) working area | IF((C6="increase"),4,IF((C6="decrease"),-3,0.0)) @ a e v | const demand (milk) | 120 @ a e v | |||
29 | Income Tax (stable, increase, decrease) working area | IF((C7="increase"),-5,IF((C7="decrease"),6,0.0)) @ a e v | const supply (milk) | 10 @ a e v | |||
30 | Advertsing Budget (stable, increase, decrease) working area | IF((C8="increase"),5,IF((C8="decrease"),-4,0.0)) @ a e v | conts CPED milk | 5 @ a e v | |||
31 | Corporation Tax for GROWERS (stable, increase, decrease) working area | IF((C9="increase"),5,IF((C9="decrease"),-5,0.0)) @ a e v | const demand (tea) | 100 @ a e v | |||
32 | Harvest conditions for growers (stable, good, poor) working area | IF((C10="good"),10,IF((C10="poor"),-10,0.0)) @ a e v | const supply (tea) | 4 @ a e v | |||
33 | Original Price | 108.461538 @ a e v | const CPED tea | 5 @ a e v | |||
34 | Original Quantity | 74.2301769 @ a e v | Original Price - milk | 14.115385 @ a e v | |||
35 | Original TR | 8051.183432 @ a e v | Original Quantity - milk | 28.35 @ a e v | |||
36 | const demand | 91 @ a e v | Original TR - milk | 400.171154 @ a e v | |||
37 | const supply | 20 @ a e v | Original Price - tea | 364.5384615 @ a e v | |||
38 | contst world income | 20 @ a e v | Original Quantity - tea | 186.2692308 @ a e v | |||
39 | contst income tax | 20 @ a e v | Original TR - tea | 67902.29882 @ a e v | |||
40 | contst advert | 20 @ a e v | |||||
41 | contst corp tax | 20 @ a e v | |||||
42 | contst harvest | 10 @ a e v |
Compile | Decompile | Upload |