Compile Decompile Upload

Program

Source

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.

attributes <
  C6 // @ e f v
  C7 // @ e f v
  C8 // @ e f v
  C9 // @ e f v
  C10 // @ e f v
  C11 // @ e f v
  C12 // @ e f v
  C13 // @ e f v
  C19 // @ e f v
  C20 // @ e f v
  C21 // @ e f v
  C22 // @ e f v
  C23 // @ e f v
  C24 // @ e f v
  C28 // @ e f v
  C29 // @ e f v
  C30 // @ e f v
  C31 // @ e f v
  C32 // @ e f v
  C33 // @ e f v
  C34 // @ e f v
  C35 // @ e f v
  C36 // @ e f v
  C37 // @ e f v
  C38 // @ e f v
  C39 // @ e f v
  C40 // @ e f v
  C41 // @ e f v
  C42 // @ e f v
  E6 // @ e f v
  E7 // @ e f v
  E8 // @ e f v
  E9 // @ e f v
  E10 // @ e f v
  E11 // @ e f v
  E12 // @ e f v
  E19 // @ e f v
  E20 // @ e f v
  E21 // @ e f v
  E22 // @ e f v
  E23 // @ e f v
  E24 // @ e f v
  E28 // @ e f v
  E29 // @ e f v
  E30 // @ e f v
  E31 // @ e f v
  E32 // @ e f v
  E33 // @ e f v
  E34 // @ e f v
  E35 // @ e f v
  E36 // @ e f v
  E37 // @ e f v
  E38 // @ e f v
  E39 // @ e f v
  G19 // @ e f v
  G20 // @ e f v
  G21 // @ e f v
  G22 // @ e f v
  G23 // @ e f v
  G24 // @ e f v
>
where
  G22=((G19+-E37/G19)*100) // @ a f v
  G21=(G19*G20) // @ a f v
  G20=E32+(E10*G19) // @ a f v
  C19=(C36+C38+(C28*E8)+C39+(C29*E8)+(E12*C30)+C40+-C37+-C42+C32+C41+C31/E6+E7) // @ a f v
  C13=-0.8 // @ a f v
  C12=1.3 // @ a f v
  C11=0.7 // @ a f v
  C10="stable" // @ a f v
  G19=(E31+(C19*E11)+-E32/E9)+E10 // @ a f v
  E9=0.8 // @ a f v
  E8=1.6 // @ a f v
  E7=0.5 // @ a f v
  E6=0.8 // @ a f v
  E39=67902.29882 // @ a f v
  E38=186.2692308 // @ a f v
  E37=364.5384615 // @ a f v
  E36=400.171154 // @ a f v
  E35=28.35 // @ a f v
  E34=14.115385 // @ a f v
  E33=5 // @ a f v
  E32=4 // @ a f v
  E31=100 // @ a f v
  E30=5 // @ a f v
  E29=10 // @ a f v
  E28=120 // @ a f v
  E24=((E21+-E36/E21)*100) // @ a f v
  E23=((E20+-E35/E20)*100) // @ a f v
  E22=((E19+-E34/E19)*100) // @ a f v
  E21=(E19*E20) // @ a f v
  E20=E29+(C12*E19) // @ a f v
  C9="stable" // @ a f v
  C8="stable" // @ a f v
  C7="stable" // @ a f v
  C6="stable" // @ a f v
  E19=(E28+(C13*C19)+E30+-E29/C11+C12) // @ a f v
  E12=1.5 // @ a f v
  E11=1.8 // @ a f v
  E10=0.5 // @ a f v
  C42=10 // @ a f v
  C41=20 // @ a f v
  C40=20 // @ a f v
  C39=20 // @ a f v
  C38=20 // @ a f v
  C37=20 // @ a f v
  C36=91 // @ a f v
  C35=8051.183432 // @ a f v
  C34=74.2301769 // @ a f v
  C33=108.461538 // @ a f v
  C32=IF((C10="good"),10,IF((C10="poor"),-10,0.0)) // @ a f v
  C31=IF((C9="increase"),5,IF((C9="decrease"),-5,0.0)) // @ a f v
  C30=IF((C8="increase"),5,IF((C8="decrease"),-4,0.0)) // @ a f v
  C29=IF((C7="increase"),-5,IF((C7="decrease"),6,0.0)) // @ a f v
  C28=IF((C6="increase"),4,IF((C6="decrease"),-3,0.0)) // @ a f v
  C24=((C21+-C35/C35)*100) // @ a f v
  C23=((C20+-C34/C34)*100) // @ a f v
  C22=((C19+-C33/C33)*100) // @ a f v
  C21=(C19*C20) // @ a f v
  C20=C37+(C19*E7)+-C31+C32 // @ a f v
  G24=((G21+-E39/G21)*100) // @ a f v
  G23=((G20+-E38/G20)*100) // @ a f v

Addresses

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

Annotations

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"

Evaluated

This is the result of running the spreadsheet.

 ABCDEFG
1       
2 Interrelationship between Markets     
3       
4       
5 Input Area     
6 World Income (stable, increase, decrease)stable
@ a e f
PED of Coffee0.8
@ a e f
  
7 Income Tax (stable, increase, decrease)stable
@ a e f
PES of Coffee0.5
@ a e f
  
8 Advertsing Budget (stable, increase, decrease)stable
@ a e f
YED of Coffee1.6
@ a e f
  
9 Corporation Tax for GROWERS (stable, increase, decrease)stable
@ a e f
PED of Tea0.8
@ a e f
  
10 Harvest conditions for growers (stable, good, poor)stable
@ a e f
PES of Tea0.5
@ a e f
  
11 PED of Milk0.7
@ a e f
CPED tea with Coffee1.8
@ a e f
  
12 PES of Milk1.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#) coffee108.46153846153845
@ a e f
Price (N#) milk14.115384615384613
@ a e f
Price (N#) tea364.5384615384615
@ a e f
20 Quantity coffee74.23076923076923
@ a e f
Quantity milk28.349999999999998
@ a e f
Quantity tea186.26923076923075
@ a e f
21 Total Revenue (N#) coffee8051.1834319526615
@ a e f
Total Revenue (N#) milk400.17115384615374
@ a e f
Total Revenue (N#) tea67902.29881656803
@ a e f
22 Change in Price (%) coffee4.2553190454354385E-7
@ a e f
Change in Price (%) milk-2.7247956547444495E-6
@ a e f
Change in Price (%) tea1.055074068017914E-8
@ a e f
23 Change in Quantity (%) coffee7.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 area0.0
@ a e f
const demand (milk)120
@ a e f
  
29 Income Tax (stable, increase, decrease) working area0.0
@ a e f
const supply (milk)10
@ a e f
  
30 Advertsing Budget (stable, increase, decrease) working area0.0
@ a e f
conts CPED milk5
@ a e f
  
31 Corporation Tax for GROWERS (stable, increase, decrease) working area0.0
@ a e f
const demand (tea)100
@ a e f
  
32 Harvest conditions for growers (stable, good, poor) working area0.0
@ a e f
const supply (tea)4
@ a e f
  
33 Original Price108.461538
@ a e f
const CPED tea5
@ a e f
  
34 Original Quantity74.2301769
@ a e f
Original Price - milk14.115385
@ a e f
  
35 Original TR8051.183432
@ a e f
Original Quantity - milk28.35
@ a e f
  
36 const demand91
@ a e f
Original TR - milk400.171154
@ a e f
  
37 const supply20
@ a e f
Original Price - tea364.5384615
@ a e f
  
38 contst world income20
@ a e f
Original Quantity - tea186.2692308
@ a e f
  
39 contst income tax20
@ a e f
Original TR - tea67902.29882
@ a e f
  
40 contst advert20
@ a e f
    
41 contst corp tax20
@ a e f
    
42 contst harvest10
@ a e f
    

Formulae

This is the spreadsheet in formula view.

 ABCDEFG
1       
2 Interrelationship between Markets     
3       
4       
5 Input Area     
6 World Income (stable, increase, decrease)"stable"
@ a e v
PED of Coffee0.8
@ a e v
  
7 Income Tax (stable, increase, decrease)"stable"
@ a e v
PES of Coffee0.5
@ a e v
  
8 Advertsing Budget (stable, increase, decrease)"stable"
@ a e v
YED of Coffee1.6
@ a e v
  
9 Corporation Tax for GROWERS (stable, increase, decrease)"stable"
@ a e v
PED of Tea0.8
@ a e v
  
10 Harvest conditions for growers (stable, good, poor)"stable"
@ a e v
PES of Tea0.5
@ a e v
  
11 PED of Milk0.7
@ a e v
CPED tea with Coffee1.8
@ a e v
  
12 PES of Milk1.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 coffeeC37+(C19*E7)+-C31+C32
@ a e v
Quantity milkE29+(C12*E19)
@ a e v
Quantity teaE32+(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 areaIF((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 areaIF((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 areaIF((C8="increase"),5,IF((C8="decrease"),-4,0.0))
@ a e v
conts CPED milk5
@ a e v
  
31 Corporation Tax for GROWERS (stable, increase, decrease) working areaIF((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 areaIF((C10="good"),10,IF((C10="poor"),-10,0.0))
@ a e v
const supply (tea)4
@ a e v
  
33 Original Price108.461538
@ a e v
const CPED tea5
@ a e v
  
34 Original Quantity74.2301769
@ a e v
Original Price - milk14.115385
@ a e v
  
35 Original TR8051.183432
@ a e v
Original Quantity - milk28.35
@ a e v
  
36 const demand91
@ a e v
Original TR - milk400.171154
@ a e v
  
37 const supply20
@ a e v
Original Price - tea364.5384615
@ a e v
  
38 contst world income20
@ a e v
Original Quantity - tea186.2692308
@ a e v
  
39 contst income tax20
@ a e v
Original TR - tea67902.29882
@ a e v
  
40 contst advert20
@ a e v
    
41 contst corp tax20
@ a e v
    
42 contst harvest10
@ a e v
    
Compile Decompile Upload
#!void