{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["月度大學預算","chart_calcs"],"not_rendered":{"charts":4,"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"月度大學預算","index":0,"n_rows":73,"n_cols":17,"rows_kept":73}
[null,"每月"]
[{"$f":"\"\"","v":""},"大學預算"]
[""]
[""]
["",{"$f":"chart_calcs!$D$6","v":"年度 收入:"},{"$nulls":3},{"$f":"chart_calcs!$D$7","v":"年度 支出:"},{"$nulls":7},{"$f":"chart_calcs!$D$8","v":"年度 現金流:"}]
["",{"$f":"\" \"&chart_calcs!$F$6","v":" ¥72,750"},{"$nulls":3},{"$f":"\" \"&chart_calcs!$F$7","v":" ¥66,990"},{"$nulls":7},{"$f":"\" \"&chart_calcs!$F$8","v":" ¥5,760"}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[]
[]
[]
[]
[null,"1月"," 選取第一個預算月份"]
[{"$nulls":16},{"$f":"SelectedPeriod","v":"3 月 "}]
[null,"扣除支出後每月現金",null,{"$f":"FirstMonth","v":"1月"},{"$f":"NextMonth","v":"2 月 "},"3 月 ","4 月 ","5 月 ","6 月 ","7 月 ","8 月 ","9 月 ","10 月 ","11 月 ","12 月 ","年度  ","% INC "]
[null,"現金流",null,{"$f":"D38-D73","v":{"v":5070,"d":"5,070 "}},{"v":2070,"d":"2,070 "},{"v":5760,"d":"5,760 "},{"v":5970,"d":"5,970 "},{"v":6120,"d":"6,120 "},{"v":-23130,"d":"(23,130)"},{"v":3720,"d":"3,720 "},{"v":4620,"d":"4,620 "},{"v":-21630,"d":"(21,630)"},{"v":3270,"d":"3,270 "},{"v":1020,"d":"1,020 "},{"v":-1830,"d":"(1,830)"},{"$f":"SUM(D29:O29)","v":{"v":-8970,"d":"(8,970)"}},{"$f":"INDEX($D29:$P29,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.07917525773195876,"d":"7.9%"}}]
[null,"累積現金流",null,{"$f":"SUM($D$29:D$29)","v":{"v":5070,"d":"5,070 "}},{"$f":"SUM($D$29:E$29)","v":{"v":7140,"d":"7,140 "}},{"$f":"SUM($D$29:F$29)","v":{"v":12900,"d":"12,900 "}},{"$f":"SUM($D$29:G$29)","v":{"v":18870,"d":"18,870 "}},{"$f":"SUM($D$29:H$29)","v":{"v":24990,"d":"24,990 "}},{"$f":"SUM($D$29:I$29)","v":{"v":1860,"d":"1,860 "}},{"$f":"SUM($D$29:J$29)","v":{"v":5580,"d":"5,580 "}},{"$f":"SUM($D$29:K$29)","v":{"v":10200,"d":"10,200 "}},{"$f":"SUM($D$29:L$29)","v":{"v":-11430,"d":"(11,430)"}},{"$f":"SUM($D$29:M$29)","v":{"v":-8160,"d":"(8,160)"}},{"$f":"SUM($D$29:N$29)","v":{"v":-7140,"d":"(7,140)"}},{"$f":"SUM($D$29:O$29)","v":{"v":-8970,"d":"(8,970)"}}]
[]
[null,"總收入",null,{"$f":"FirstMonth","v":"1月"},{"$f":"NextMonth","v":"2 月 "},"3 月 ","4 月 ","5 月 ","6 月 ","7 月 ","8 月 ","9 月 ","10 月 ","11 月 ","12 月 ","年度   ","% INC "]
[null,"財務補助 (補助金、獎學金、貸款) 支付",null,0,0,{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"v":22500,"d":"22,500"},{"$f":"SUM(D33:O33)","v":{"v":225000,"d":"225,000 "}},{"$f":"INDEX($D33:$P33,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.30927835051546393,"d":"30.9%"}}]
[null,"稅後工作薪資",null,{"v":13500,"d":"13,500"},{"v":13500,"d":"13,500"},{"v":13500,"d":"13,500"},{"v":13500,"d":"13,500"},{"v":13500,"d":"13,500"},{"v":13500,"d":"13,500"},{"v":13500,"d":"13,500"},{"v":13500,"d":"13,500"},{"v":16500,"d":"16,500"},{"v":10500,"d":"10,500"},{"v":10500,"d":"10,500"},{"v":10500,"d":"10,500"},{"v":156000,"d":"156,000 "},{"$f":"INDEX($D34:$P34,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.18556701030927836,"d":"18.6%"}}]
[null,"家庭財務資助",null,{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":30000,"d":"30,000"},{"v":10500,"d":"10,500"},{"v":10500,"d":"10,500"},{"v":10500,"d":"10,500"},{"v":10500,"d":"10,500"},{"v":10500,"d":"10,500"},{"v":10500,"d":"10,500"},{"v":10500,"d":"10,500"},{"v":10500,"d":"10,500"},{"v":10500,"d":"10,500"},{"v":136500,"d":"136,500 "},{"$f":"INDEX($D35:$P35,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.41237113402061853,"d":"41.2%"}}]
[null,"存款提領",null,{"v":15000,"d":"15,000"},{"v":10500,"d":"10,500"},{"v":4500,"d":"4,500"},0,0,0,0,0,0,0,0,0,{"v":30000,"d":"30,000 "},{"$f":"INDEX($D36:$P36,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.061855670103092786,"d":"6.2%"}}]
[null,"其他 (育兒津貼、公共補助、禮物等)",null,{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":27000,"d":"27,000 "},{"$f":"INDEX($D37:$P37,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.030927835051546393,"d":"3.1%"}}]
[null,"總收入",null,{"$f":"SUM(D33:D37)","v":{"v":36750,"d":"36,750 "}},{"v":32250,"d":"32,250 "},{"v":72750,"d":"72,750 "},{"v":48750,"d":"48,750 "},{"v":48750,"d":"48,750 "},{"v":48750,"d":"48,750 "},{"v":48750,"d":"48,750 "},{"v":48750,"d":"48,750 "},{"v":51750,"d":"51,750 "},{"v":45750,"d":"45,750 "},{"v":45750,"d":"45,750 "},{"v":45750,"d":"45,750 "},{"v":574500,"d":"574,500 "},{"$f":"INDEX($D38:$P38,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":1,"d":"100.0%"}}]
[]
[null,"月支出",null,{"$f":"FirstMonth","v":"1月"},{"$f":"NextMonth","v":"2 月 "},"3 月 ","4 月 ","5 月 ","6 月 ","7 月 ","8 月 ","9 月 ","10 月 ","11 月 ","12 月 ","年度  ","% INC "]
[null,"食宿",null,{"$f":"SUM(D42:D44)","v":{"v":16950,"d":"16,950 "}},{"v":16950,"d":"16,950 "},{"v":16950,"d":"16,950 "},{"v":16950,"d":"16,950 "},{"v":16950,"d":"16,950 "},{"v":16950,"d":"16,950 "},{"v":16950,"d":"16,950 "},{"v":16950,"d":"16,950 "},{"v":16950,"d":"16,950 "},{"v":16950,"d":"16,950 "},{"v":16950,"d":"16,950 "},{"v":16950,"d":"16,950 "},{"$f":"SUM(D41:O41)","v":{"v":203400,"d":"203,400 "}},{"$f":"INDEX($D41:$P41,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.2530228392297358,"d":"25.3%"}}]
[null,null,"房租、貸款或宿舍",{"v":9450,"d":"9,450"},{"v":9450,"d":"9,450"},{"v":9450,"d":"9,450"},{"v":9450,"d":"9,450"},{"v":9450,"d":"9,450"},{"v":9450,"d":"9,450"},{"v":9450,"d":"9,450"},{"v":9450,"d":"9,450"},{"v":9450,"d":"9,450"},{"v":9450,"d":"9,450"},{"v":9450,"d":"9,450"},{"v":9450,"d":"9,450"},{"$f":"SUM(D42:O42)","v":{"v":113400,"d":"113,400 "}},{"$f":"INDEX($D42:$P42,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.14106583072100312,"d":"14.1%"}}]
[null,null,"食物 (雜貨或餐點費)",{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"$f":"SUM(D43:O43)","v":{"v":72000,"d":"72,000 "}},{"$f":"INDEX($D43:$P43,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.08956560680698612,"d":"9.0%"}}]
[null,null,"水電費 (暖器、水、電)",{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"$f":"SUM(D44:O44)","v":{"v":18000,"d":"18,000 "}},{"$f":"INDEX($D44:$P44,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.02239140170174653,"d":"2.2%"}}]
[]
[null,"學費和手續費",null,{"$f":"SUM(D47:D48)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":22500,"d":"22,500 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":19500,"d":"19,500 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":19500,"d":"19,500 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(D46:O46)","v":{"v":61500,"d":"61,500 "}},{"$f":"INDEX($D46:$P46,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.33587102552619796,"d":"33.6%"}}]
[null,null,"實付學費",0,0,{"v":15000,"d":"15,000"},0,0,{"v":15000,"d":"15,000"},0,0,{"v":15000,"d":"15,000"},0,0,0,{"$f":"SUM(D47:O47)","v":{"v":45000,"d":"45,000 "}},{"$f":"INDEX($D47:$P47,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.2239140170174653,"d":"22.4%"}}]
[null,null,"實付手續費",0,0,{"v":7500,"d":"7,500"},0,0,{"v":4500,"d":"4,500"},0,0,{"v":4500,"d":"4,500"},0,0,0,{"$f":"SUM(D48:O48)","v":{"v":16500,"d":"16,500 "}},{"$f":"INDEX($D48:$P48,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.11195700850873265,"d":"11.2%"}}]
[]
[null,"書籍和用品",null,{"$f":"SUM(D51:D52)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":9750,"d":"9,750 "},{"v":600,"d":"600 "},{"v":600,"d":"600 "},{"v":9750,"d":"9,750 "},{"v":300,"d":"300 "},{"v":300,"d":"300 "},{"v":12000,"d":"12,000 "},{"v":450,"d":"450 "},{"v":450,"d":"450 "},{"v":450,"d":"450 "},{"$f":"SUM(D50:O50)","v":{"v":34650,"d":"34,650 "}},{"$f":"INDEX($D50:$P50,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.14554411106135243,"d":"14.6%"}}]
[null,null,"教科書",0,0,{"v":6750,"d":"6,750"},0,0,{"v":8250,"d":"8,250"},0,0,{"v":9750,"d":"9,750"},0,0,0,{"$f":"SUM(D51:O51)","v":{"v":24750,"d":"24,750 "}},{"$f":"INDEX($D51:$P51,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.10076130765785939,"d":"10.1%"}}]
[null,null,"學校用品",0,0,{"v":3000,"d":"3,000"},600,600,{"v":1500,"d":"1,500"},300,300,{"v":2250,"d":"2,250"},450,450,450,{"$f":"SUM(D52:O52)","v":{"v":9900,"d":"9,900 "}},{"$f":"INDEX($D52:$P52,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.04478280340349306,"d":"4.5%"}}]
[]
[null,"交通",null,{"$f":"SUM(D55:D58)","v":{"v":6720,"d":"6,720 "}},{"v":5220,"d":"5,220 "},{"v":5220,"d":"5,220 "},{"v":6570,"d":"6,570 "},{"v":5220,"d":"5,220 "},{"v":5220,"d":"5,220 "},{"v":8220,"d":"8,220 "},{"v":6570,"d":"6,570 "},{"v":5220,"d":"5,220 "},{"v":5220,"d":"5,220 "},{"v":6720,"d":"6,720 "},{"v":8070,"d":"8,070 "},{"$f":"SUM(D54:O54)","v":{"v":74190,"d":"74,190 "}},{"$f":"INDEX($D54:$P54,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.07792207792207792,"d":"7.8%"}}]
[null,null,"瓦斯、維修費用",900,900,900,{"v":2250,"d":"2,250"},900,900,900,{"v":2250,"d":"2,250"},900,900,900,{"v":2250,"d":"2,250"},{"$f":"SUM(D55:O55)","v":{"v":14850,"d":"14,850 "}},{"$f":"INDEX($D55:$P55,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.013434841021047918,"d":"1.3%"}}]
[null,null,"車輛支出",{"v":3870,"d":"3,870"},{"v":3870,"d":"3,870"},{"v":3870,"d":"3,870"},{"v":3870,"d":"3,870"},{"v":3870,"d":"3,870"},{"v":3870,"d":"3,870"},{"v":3870,"d":"3,870"},{"v":3870,"d":"3,870"},{"v":3870,"d":"3,870"},{"v":3870,"d":"3,870"},{"v":3870,"d":"3,870"},{"v":3870,"d":"3,870"},{"$f":"SUM(D56:O56)","v":{"v":46440,"d":"46,440 "}},{"$f":"INDEX($D56:$P56,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.057769816390506046,"d":"5.8%"}}]
[null,null,"轉帳費用",450,450,450,450,450,450,450,450,450,450,450,450,{"$f":"SUM(D57:O57)","v":{"v":5400,"d":"5,400 "}},{"$f":"INDEX($D57:$P57,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":6.717420510523959E-3,"d":"0.7%"}}]
[null,null,"假期旅行",{"v":1500,"d":"1,500"},0,0,0,0,0,{"v":3000,"d":"3,000"},0,0,0,{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"$f":"SUM(D58:O58)","v":{"v":7500,"d":"7,500 "}},{"$f":"INDEX($D58:$P58,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"選擇性",null,{"$f":"SUM(D61:D66)","v":{"v":2070,"d":"2,070 "}},{"v":2070,"d":"2,070 "},{"v":5070,"d":"5,070 "},{"v":11070,"d":"11,070 "},{"v":12570,"d":"12,570 "},{"v":13320,"d":"13,320 "},{"v":12570,"d":"12,570 "},{"v":12570,"d":"12,570 "},{"v":11820,"d":"11,820 "},{"v":11820,"d":"11,820 "},{"v":12570,"d":"12,570 "},{"v":14070,"d":"14,070 "},{"$f":"SUM(D60:O60)","v":{"v":121590,"d":"121,590 "}},{"$f":"INDEX($D60:$P60,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.07568293775190327,"d":"7.6%"}}]
[null,null,"存款",0,0,0,{"v":1500,"d":"1,500"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":24000,"d":"24,000 "},{"$f":"INDEX($D61:$P61,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,"手機、網路、有線電視",{"v":2070,"d":"2,070"},{"v":2070,"d":"2,070"},{"v":2070,"d":"2,070"},{"v":2070,"d":"2,070"},{"v":2070,"d":"2,070"},{"v":2070,"d":"2,070"},{"v":2070,"d":"2,070"},{"v":2070,"d":"2,070"},{"v":2070,"d":"2,070"},{"v":2070,"d":"2,070"},{"v":2070,"d":"2,070"},{"v":2070,"d":"2,070"},{"v":24840,"d":"24,840 "},{"$f":"INDEX($D62:$P62,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.03090013434841021,"d":"3.1%"}}]
[null,null,"捐款",0,0,0,0,0,750,0,0,0,0,0,{"v":1500,"d":"1,500"},{"v":2250,"d":"2,250 "},{"$f":"INDEX($D63:$P63,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,"零食、外出用餐",0,0,{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":30000,"d":"30,000 "},{"$f":"INDEX($D64:$P64,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.04478280340349306,"d":"4.5%"}}]
[null,null,"置裝費",0,0,0,{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":13500,"d":"13,500 "},{"$f":"INDEX($D65:$P65,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,"娛樂費 (電影、約會、音樂會)",0,0,0,{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":27000,"d":"27,000 "},{"$f":"INDEX($D66:$P66,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"其他開支",null,{"$f":"SUM(D69:D71)","v":{"v":5940,"d":"5,940 "}},{"$f":"SUM(E69:E71)","v":{"v":5940,"d":"5,940 "}},{"v":7500,"d":"7,500 "},{"v":7590,"d":"7,590 "},{"v":7290,"d":"7,290 "},{"v":7140,"d":"7,140 "},{"v":6990,"d":"6,990 "},{"v":7740,"d":"7,740 "},{"v":7890,"d":"7,890 "},{"v":8040,"d":"8,040 "},{"v":8040,"d":"8,040 "},{"v":8040,"d":"8,040 "},{"$f":"SUM(D68:O68)","v":{"v":88140,"d":"88,140 "}},{"$f":"INDEX($D68:$P68,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.11195700850873265,"d":"11.2%"}}]
[null,null,"保險 (汽車、保健、租屋)",{"v":3690,"d":"3,690"},{"v":3690,"d":"3,690"},{"v":3690,"d":"3,690"},{"v":3690,"d":"3,690"},{"v":3690,"d":"3,690"},{"v":3690,"d":"3,690"},{"v":3690,"d":"3,690"},{"v":3690,"d":"3,690"},{"v":3690,"d":"3,690"},{"v":3690,"d":"3,690"},{"v":3690,"d":"3,690"},{"v":3690,"d":"3,690"},{"$f":"SUM(D69:O69)","v":{"v":44280,"d":"44,280 "}},{"$f":"INDEX($D69:$P69,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.05508284818629646,"d":"5.5%"}}]
[null,null,"貸款、信用卡費用",0,0,{"v":1560,"d":"1,560"},{"v":1650,"d":"1,650"},{"v":1350,"d":"1,350"},{"v":1200,"d":"1,200"},{"v":1050,"d":"1,050"},{"v":1800,"d":"1,800"},{"v":1950,"d":"1,950"},{"v":2100,"d":"2,100"},{"v":2100,"d":"2,100"},{"v":2100,"d":"2,100"},{"$f":"SUM(D70:O70)","v":{"v":16860,"d":"16,860 "}},{"$f":"INDEX($D70:$P70,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.02328705776981639,"d":"2.3%"}}]
[null,null,"其他",{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"$f":"SUM(D71:O71)","v":{"v":27000,"d":"27,000 "}},{"$f":"INDEX($D71:$P71,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.03358710255261979,"d":"3.4%"}}]
[]
[null,"總支出",null,{"$f":"SUM(D41,D46,D50,D54,D60,D68)","v":{"v":31680,"d":"31,680 "}},{"v":30180,"d":"30,180 "},{"v":66990,"d":"66,990 "},{"v":42780,"d":"42,780 "},{"v":42630,"d":"42,630 "},{"v":71880,"d":"71,880 "},{"v":45030,"d":"45,030 "},{"v":44130,"d":"44,130 "},{"v":73380,"d":"73,380 "},{"v":42480,"d":"42,480 "},{"v":44730,"d":"44,730 "},{"v":47580,"d":"47,580 "},{"$f":"SUM(D73:O73)","v":{"v":583470,"d":"583,470 "}},{"$f":"INDEX($D73:$P73,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":1,"d":"100.0%"}}]

{"sheet":"chart_calcs","index":1,"n_rows":40,"n_cols":20,"rows_kept":40,"hidden":true}
["***此工作表會隱藏***"]
[]
[{"$nulls":3},{"$f":"IFERROR(LOWER(TEXT(VALUE(SelectedPeriod&\" 1\"),\"mmmm\")),\"年度\")","v":"年度"}]
[]
[{"$nulls":3},"動態圖表標題"]
[{"$nulls":3},{"$f":"D3&\" 收入:\"","v":"年度 收入:"},null,{"$f":"TEXT(INDEX(月度大學預算!$D$38:$P$38,,SelectedPeriodColumn),\"¥#,###\")","v":"¥72,750"}]
[{"$nulls":3},{"$f":"D3&\" 支出:\"","v":"年度 支出:"},null,{"$f":"TEXT(INDEX(月度大學預算!$D$73:$P$73,,SelectedPeriodColumn),\"¥#,###\")","v":"¥66,990"}]
[{"$nulls":3},{"$f":"D3&\" 現金流:\"","v":"年度 現金流:"},{"$f":"INDEX(月度大學預算!D29:P29,ScrollBarValue)","v":5760},{"$f":"TEXT(E8,\"¥#,###\")","v":"¥5,760"}]
[]
[]
[]
[{"$nulls":3},{"$f":"LOWER(月度大學預算!D28)","v":"1月"},{"$f":"LOWER(月度大學預算!E28)","v":"2 月 "},{"$f":"LOWER(月度大學預算!F28)","v":"3 月 "},{"$f":"LOWER(月度大學預算!G28)","v":"4 月 "},{"$f":"LOWER(月度大學預算!H28)","v":"5 月 "},{"$f":"LOWER(月度大學預算!I28)","v":"6 月 "},{"$f":"LOWER(月度大學預算!J28)","v":"7 月 "},{"$f":"LOWER(月度大學預算!K28)","v":"8 月 "},{"$f":"LOWER(月度大學預算!L28)","v":"9 月 "},{"$f":"LOWER(月度大學預算!M28)","v":"10 月 "},{"$f":"LOWER(月度大學預算!N28)","v":"11 月 "},{"$f":"LOWER(月度大學預算!O28)","v":"12 月 "},{"$f":"LOWER(月度大學預算!P28)","v":"年度  "}]
[null,null,"轉軸值： ",3]
[null,null,"現金流圖： ",{"$f":"IF(SelectedPeriod=月度大學預算!D$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!E$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!F$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":5760},{"$f":"IF(SelectedPeriod=月度大學預算!G$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!H$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!I$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!J$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!K$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!L$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!M$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!N$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!O$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!P$32,IF(月度大學預算!$D$29:$P$29>=0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,"累計： ",{"$f":"IF(SelectedPeriod=月度大學預算!D$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!E$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!F$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!G$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!H$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!I$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!J$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!K$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!L$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!M$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!N$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!O$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod=月度大學預算!P$32,IF(月度大學預算!$D$29:$P$29<0,月度大學預算!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},null,null,1]
[]
[]
[null,null,"收入圖表資料"]
[null,null,"財務補助 (補助金、獎學金、貸款) 支付",{"$f":"月度大學預算!Q33","v":{"v":0.30927835051546393,"d":"30.9%"}}]
[null,null,"稅後工作薪資",{"$f":"月度大學預算!Q34","v":{"v":0.18556701030927836,"d":"18.6%"}}]
[null,null,"家庭財務資助",{"$f":"月度大學預算!Q35","v":{"v":0.41237113402061853,"d":"41.2%"}},{"$nulls":15},"¥"]
[null,null,"存款提領",{"$f":"月度大學預算!Q36","v":{"v":0.061855670103092786,"d":"6.2%"}}]
[null,null,"其他 (育兒津貼、公共補助、禮物等)",{"$f":"月度大學預算!Q37","v":{"v":0.030927835051546393,"d":"3.1%"}}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"IF(SelectedStartMonth=\"1月\",\"JAN\",IF(SelectedStartMonth=\"2月\",\"FEB\",IF(SelectedStartMonth=\"3月\",\"MAR\",IF(SelectedStartMonth=\"4月\",\"APR\",IF(SelectedStartMonth=\"5月\",\"MAY\",IF(SelectedStartMonth=\"6月\",\"JUN\",IF(SelectedStartMonth=\"7月\",\"JUL\",IF(SelectedStartMonth=\"8月\",\"AUG\",IF(SelectedStartMonth=\"9月\",\"SEP\",IF(SelectedStartMonth=\"10月\",\"OCT\",IF(SelectedStartMonth=\"11月\",\"NOV\",IF(SelectedStartMonth=\"12月\",\"DEC\",))))))))))))","v":"JAN"},{"$f":"ByNextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC "]
[]
[]
[]
[{"$nulls":3},{"$f":"IF(SelectedStartMonth=\"1月\",\"JAN\",IF(SelectedStartMonth=\"2月\",\"FEB\",IF(SelectedStartMonth=\"3月\",\"MAR\",IF(SelectedStartMonth=\"4月\",\"APR\",IF(SelectedStartMonth=\"5月\",\"MAY\",IF(SelectedStartMonth=\"6月\",\"JUN\",IF(SelectedStartMonth=\"7月\",\"JUL\",IF(SelectedStartMonth=\"8月\",\"AUG\",IF(SelectedStartMonth=\"9月\",\"SEP\",IF(SelectedStartMonth=\"10月\",\"OCT\",IF(SelectedStartMonth=\"11月\",\"NOV\",IF(SelectedStartMonth=\"12月\",\"DEC\",))))))))))))","v":"JAN"},{"$f":"ByNextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC "]
{"$rows_empty":7}
[{"$nulls":3},{"$f":"IF(SelectedStartMonth=\"1月\",\"JAN\",IF(SelectedStartMonth=\"2月\",\"FEB\",IF(SelectedStartMonth=\"3月\",\"MAR\",IF(SelectedStartMonth=\"4月\",\"APR\",IF(SelectedStartMonth=\"5月\",\"MAY\",IF(SelectedStartMonth=\"6月\",\"JUN\",IF(SelectedStartMonth=\"7月\",\"JUL\",IF(SelectedStartMonth=\"8月\",\"AUG\",IF(SelectedStartMonth=\"9月\",\"SEP\",IF(SelectedStartMonth=\"10月\",\"OCT\",IF(SelectedStartMonth=\"11月\",\"NOV\",IF(SelectedStartMonth=\"12月\",\"DEC\",))))))))))))","v":"JAN"},{"$f":"ByNextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC "]