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 trendlines trendlines 16 38 1 Print_Area trendlines!$A$1:$IV$65536 A1 Sheet_Title "trendlines" A1 d_then_r portrait iso_a4 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 (拿 farmer 那一題來參考, 當做抄改的出發點) ws me sb sc ts wb vp vs cs cm bb total profit 件 profit =B16-B17-sumproduct(B20:B26,$Q20:$Q26) =sumproduct(B14:L14,B15:L15) tag price 300 450 180 120 270 320 350 200 130 75 120 mm cost 160 150 100 60 120 140 175 160 60 40 90 constraints ws me sb sc ts wb vp vs cs cm bb total LHS RHS price/yard wool 3 2.5 =sumproduct(B$14:L$14,B20:L20) <= 45000 9 acetate 2 1.5 1.5 2 <= 28000 1.5 cashmere 1.5 <= 9000 60 silk 1.5 0.5 <= 18000 13 rayon 2 1.5 <= 30000 2.25 velvet 3 1.5 <= 20000 12 cotton 1.5 0.5 <= 30000 2.5 scrap_sb 1 -1 <= 0 scrap_cs 1 -1 <= 0 fad_vp 1 <= 5500 fad_vs 1 <= 6000 expensive 1 <= 4000 care_sb 1 <= 12000 care_sc 1 <= 15000 demand_ws 1 <= 7000 demand_wb 1 <= 5000 loyal_ws 1 >= 4200 loyal_wb 1 >= 3000 件 4200 4000 7000 15000 8066.67 5000 0 6000 0 60000 9244.44