4
WorkbookView::show_horizontal_scrollbar
TRUE
4
WorkbookView::show_vertical_scrollbar
TRUE
4
WorkbookView::show_notebook_tabs
TRUE
4
WorkbookView::do_auto_completion
TRUE
4
WorkbookView::is_protected
FALSE
farmer
auto-company
farmer
6
8
1
Print_Area
farmer!$A$1:$IV$65536
A1
Sheet_Title
"farmer"
A1
d_then_r
portrait
iso_a4
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
AR PL KaitiM Big5
wheat
barley
total profit
acres
dollars
143
60
=sumproduct(B3:C3,B4:C4)
constraints
wheat
barley
total LHS
RHS
capital
120
210
=sumproduct(B$3:C$3,B7:C7)
<=
15000
storage
110
30
<=
4000
land
1
1
<=
75
auto-company
8
9
1
Print_Area
'auto-company'!$A$1:$IV$65536
A1
Sheet_Title
"auto-company"
A1
d_then_r
portrait
iso_a4
AR PL KaitiM Big5
f1
f2
f3
f4
total cost
cars
dollars
15
7
9
10
constraints
f1
f2
f3
f4
total LHS
RHS
material
3
6
5
4
<=
4000
labor
2
5
4
3
<=
3300
contract
1
>=
400
delivery
1
1
1
1
=
1000