ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Enter your values in BLUE cells:
(Ctrl C to clear)
2
3
DescriptionValue
4
4 window / 1 roof````
5
4 window / 0 roof
6
3 window / 1 roof
7
3 window / 0 roof
8
2 window / 1 roof
9
2 window / 0 roof
10
1 window / 1 roof
11
1 window / 0 roof
12
Total Rooms0
13
`
14
Total Land
15
Total # of Roofs
16
Total # of Windows
17
Total # of Floors
18
19
Team's calculated Net Profit or (Loss)
20
21
Building ConfigurationTypeTotal IncomeTotal ExpenseNet Inc (loss)
22
4 window / 1 roofIncome#VALUE!#VALUE!#VALUE!
23
4 window / 0 roofIncome0.000.00 0.00
24
3 window / 1 roofIncome0.000.00 0.00
25
3 window / 0 roofIncome0.000.00 0.00
26
2 window / 1 roofIncome0.000.00 0.00
27
2 window / 0 roofIncome0.000.00 0.00
28
1 window / 1 roofIncome0.000.00 0.00
29
1 window / 0 roofIncome0.000.00 0.00
30
LandExpense0.00 0.00
31
Floor TaxExpense0.00 0.00
32
Total #VALUE!#VALUE!#VALUE!
33
Penalty#VALUE!
34
Final Team Score#VALUE!
35
Daily CostValue
# of Land Units
36
Land400
37
Roof10N/A
38
Window5N/A
39
# of Floors = Tax % of land50.00%
40
41
42
43
Per Room
44
PremiumPotentialTotal #TotalWindowRoofTotal
45
BaseCharge# Windows# roof Incomeof RoomsIncomeExpenseExpenseExpenseNet $
46
4 window / 1 roof$200$10041$600````#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
47
4 window / 0 roof$140$9040$500$000$0$0
48
3 window / 1 roof$150$5031$300$000$0$0
49
3 window / 0 roof$145$3530$250$000$0$0
50
2 window / 1 roof$140$3021$200$000$0$0
51
2 window / 0 roof$125$2520$175$000$0$0
52
1 window / 1 roof$130$2011$150$000$0$0
53
1 window / 0 roof$125$010$125$000$0$0
54
55
56
57
0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100