{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["績效報告","定義"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"績效報告","index":0,"n_rows":25,"n_cols":20,"rows_kept":25}
[]
[null,"專案績效"]
[null,"報告"]
[]
[{"$nulls":3},"預算",null,"實獲值","實際值",null,"成本",null,"排程時間表",null,"績效指標",null,"預測"]
[]
[null,"序號","貨品說明","整體 BAC (NT$)","PV (NT$)","EV (NT$)","AC (NT$)","PEA (NT$)","CV (NT$)","CV (%)","SV (NT$)","SV (%)","CPI","SPI","ETC","EAC","VAC (%)","VAC (NT$)","平均指數","狀態"]
[null,"A","方案 A",{"$f":"SUM(D9,D13)","v":14670},{"$f":"SUM(E9,E13)","v":7620},{"$f":"SUM(F9,F13)","v":6750},{"$f":"SUM(G9,G13)","v":7980},null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-1230,"d":"(1230)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.16141732283464566,"d":"-16%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-870,"d":"(870)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.1141732283464567,"d":"-11%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.8458646616541353,"d":"0.85"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.8858267716535433,"d":"0.89"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":9363.2,"d":"9363"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":{"v":17343.2,"d":"17343"}},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.18222222222222229,"d":"-18%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-2673.2000000000007,"d":"(2673)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":0.8658457166538394,"d":"0.87"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"ORANGE"}]
[null,"A.1","專案 1",{"$f":"SUM(D10:D12)","v":5580},{"$f":"SUM(E10:E12)","v":2790},{"$f":"SUM(F10:F12)","v":2700},{"$f":"SUM(G10:G12)","v":3000},null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-300,"d":"(300)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.10752688172043011,"d":"-11%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-90,"d":"(90)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.03225806451612903,"d":"-3%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.9,"d":"0.90"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.967741935483871,"d":"0.97"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":3200},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":6200},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.1111111111111111,"d":"-11%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-620,"d":"(620)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":0.9338709677419355,"d":"0.93"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"ORANGE"}]
[null,"A.1.1","交付項目 1",3000,1650,1500,1800,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-300,"d":"(300)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.18181818181818182,"d":"-18%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-150,"d":"(150)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.09090909090909091,"d":"-9%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.8333333333333334,"d":"0.83"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.9090909090909091,"d":"0.91"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":1800},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":3600},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.2,"d":"-20%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-600,"d":"(600)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":0.8712121212121212,"d":"0.87"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"ORANGE"}]
[null,"A.1.2","交付項目 2",840,390,420,540,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-120,"d":"(120)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.3076923076923077,"d":"-31%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":30},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.07692307692307693,"d":"8%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.7777777777777778,"d":"0.78"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":1.0769230769230769,"d":"1.08"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":540},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":1080},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.2857142857142857,"d":"-29%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-240,"d":"(240)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":0.9273504273504274,"d":"0.93"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"ORANGE"}]
[null,"A.1.3","交付項目 3",1740,750,780,660,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":120},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.16,"d":"16%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":30},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.04,"d":"4%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":1.1818181818181819,"d":"1.18"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":1.04},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":812.3076923076922,"d":"812"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":{"v":1472.3076923076922,"d":"1472"}},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":0.15384615384615394,"d":"15%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":267.69230769230785,"d":"268"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":1.1109090909090908,"d":"1.11"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"GREEN"}]
[null,"A.2","專案 2",{"$f":"SUM(D14:D16)","v":9090},{"$f":"SUM(E14:E16)","v":4830},{"$f":"SUM(F14:F16)","v":4050},{"$f":"SUM(G14:G16)","v":4980},null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-930,"d":"(930)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.19254658385093168,"d":"-19%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-780,"d":"(780)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.16149068322981366,"d":"-16%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.8132530120481928,"d":"0.81"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.8385093167701864,"d":"0.84"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":6197.333333333334,"d":"6197"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":{"v":11177.333333333334,"d":"11177"}},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.22962962962962968,"d":"-23%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-2087.333333333334,"d":"(2087)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":0.8258811644091896,"d":"0.83"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"RED"}]
[null,"A.2.1","交付項目 1",5400,2760,2400,3000,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-600,"d":"(600)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.21739130434782608,"d":"-22%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-360,"d":"(360)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.13043478260869565,"d":"-13%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.8,"d":"0.80"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.8695652173913043,"d":"0.87"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":3750},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":6750},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.25,"d":"-25%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-1350,"d":"(1350)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":0.8347826086956522,"d":"0.83"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"RED"}]
[null,"A.2.2","交付項目 2",1350,1050,600,900,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-300,"d":"(300)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.2857142857142857,"d":"-29%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-450,"d":"(450)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.42857142857142855,"d":"-43%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.6666666666666666,"d":"0.67"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.5714285714285714,"d":"0.57"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":1125},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":2025},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.5,"d":"-50%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-675,"d":"(675)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":0.6190476190476191,"d":"0.62"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"BLACK"}]
[null,"A.2.3","交付項目 3",2340,1020,1050,1080,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-30,"d":"(30)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.029411764705882353,"d":"-3%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":30},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.029411764705882353,"d":"3%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.9722222222222222,"d":"0.97"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":1.0294117647058822,"d":"1.03"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":1326.8571428571427,"d":"1327"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":{"v":2406.8571428571427,"d":"2407"}},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.028571428571428487,"d":"-3%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-66.85714285714266,"d":"(67)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":1.0008169934640523,"d":"1.00"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"GREEN"}]
[null,"B","方案 B",{"$f":"SUM(D18,D22)","v":21150},{"$f":"SUM(E18,E22)","v":10890},{"$f":"SUM(F18,F22)","v":12150},{"$f":"SUM(G18,G22)","v":12900},null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-750,"d":"(750)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.06887052341597796,"d":"-7%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":1260},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.11570247933884298,"d":"12%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.9418604651162791,"d":"0.94"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":1.115702479338843,"d":"1.12"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":9555.555555555555,"d":"9556"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":{"v":22455.555555555555,"d":"22456"}},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.06172839506172836,"d":"-6%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-1305.5555555555547,"d":"(1306)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":1.028781472227561,"d":"1.03"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"GREEN"}]
[null,"B.1","專案 1",{"$f":"SUM(D19:D21)","v":11250},{"$f":"SUM(E19:E21)","v":4440},{"$f":"SUM(F19:F21)","v":6300},{"$f":"SUM(G19:G21)","v":6750},null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-450,"d":"(450)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.10135135135135136,"d":"-10%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":1860},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.4189189189189189,"d":"42%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.9333333333333333,"d":"0.93"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":1.4189189189189189,"d":"1.42"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":5303.5714285714275,"d":"5304"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":{"v":12053.571428571428,"d":"12054"}},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.07142857142857134,"d":"-7%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-803.5714285714275,"d":"(804)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":1.176126126126126,"d":"1.18"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"GREEN"}]
[null,"B.1.1","交付項目 1",7500,1650,3750,4500,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-750,"d":"(750)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.45454545454545453,"d":"-45%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":2100},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":1.2727272727272727,"d":"127%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.8333333333333334,"d":"0.83"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":2.272727272727273,"d":"2.27"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":4500},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":9000},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.2,"d":"-20%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-1500,"d":"(1500)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":1.5530303030303032,"d":"1.55"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"GREEN"}]
[null,"B.1.2","交付項目 2",3000,2460,2100,1950,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":150},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.06097560975609756,"d":"6%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-360,"d":"(360)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.14634146341463414,"d":"-15%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":1.0769230769230769,"d":"1.08"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.8536585365853658,"d":"0.85"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":835.7142857142858,"d":"836"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":{"v":2785.714285714286,"d":"2786"}},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":0.07142857142857141,"d":"7%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":214.28571428571422,"d":"214"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":0.9652908067542214,"d":"0.97"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"ORANGE"}]
[null,"B.1.3","交付項目 3",750,330,450,300,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":150},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.45454545454545453,"d":"45%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":120},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.36363636363636365,"d":"36%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":1.5,"d":"1.50"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":1.3636363636363635,"d":"1.36"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":200},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":500},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":0.3333333333333333,"d":"33%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":250},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":1.4318181818181817,"d":"1.43"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"GREEN"}]
[null,"B.2","專案 2",{"$f":"SUM(D23:D25)","v":9900},{"$f":"SUM(E23:E25)","v":6450},{"$f":"SUM(F23:F25)","v":5850},{"$f":"SUM(G23:G25)","v":6150},null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-300,"d":"(300)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.046511627906976744,"d":"-5%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-600,"d":"(600)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.09302325581395349,"d":"-9%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.9512195121951219,"d":"0.95"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.9069767441860465,"d":"0.91"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":4257.6923076923085,"d":"4258"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":{"v":10407.692307692309,"d":"10408"}},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.051282051282051364,"d":"-5%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-507.69230769230853,"d":"(508)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":0.9290981281905841,"d":"0.93"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"ORANGE"}]
[null,"B.2.1","交付項目 1",2700,1650,1800,1500,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":300},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.18181818181818182,"d":"18%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":150},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.09090909090909091,"d":"9%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":1.2,"d":"1.20"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":1.0909090909090908,"d":"1.09"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":750},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":2250},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":0.16666666666666666,"d":"17%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":450},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":1.1454545454545455,"d":"1.15"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"GREEN"}]
[null,"B.2.2","交付項目 2",2700,1800,1500,1350,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":150},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.08333333333333333,"d":"8%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-300,"d":"(300)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.16666666666666666,"d":"-17%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":1.1111111111111112,"d":"1.11"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":0.8333333333333334,"d":"0.83"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":1080},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":2430},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":0.1,"d":"10%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":270},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":0.9722222222222223,"d":"0.97"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"ORANGE"}]
[null,"B.2.3","交付項目 3",4500,3000,2550,3300,null,{"$f":"tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[AC (NT$)]]","v":{"v":-750,"d":"(750)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[CV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.25,"d":"-25%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]-tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-450,"d":"(450)"}},{"$f":"IFERROR(tblPerformance[[#This Row],[SV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":{"v":-0.15,"d":"-15%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":0.7727272727272727,"d":"0.77"}},{"$f":"IFERROR(tblPerformance[[#This Row],[EV (NT$)]]/tblPerformance[[#This Row],[PV (NT$)]],0)","v":0.85},{"$f":"IFERROR(tblPerformance[[#This Row],[EAC]]-tblPerformance[[#This Row],[AC (NT$)]],0)","v":{"v":2523.5294117647063,"d":"2524"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]/tblPerformance[[#This Row],[CPI]],0)","v":{"v":5823.529411764706,"d":"5824"}},{"$f":"IFERROR(tblPerformance[[#This Row],[VAC (NT$)]]/tblPerformance[[#This Row],[整體 BAC (NT$)]],0)","v":{"v":-0.29411764705882365,"d":"-29%"}},{"$f":"IFERROR(tblPerformance[[#This Row],[整體 BAC (NT$)]]-tblPerformance[[#This Row],[EAC]],0)","v":{"v":-1323.5294117647063,"d":"(1324)"}},{"$f":"IFERROR((tblPerformance[[#This Row],[SPI]]+tblPerformance[[#This Row],[CPI]])/2,0)","v":{"v":0.8113636363636363,"d":"0.81"}},{"$f":"LOOKUP(tblPerformance[[#This Row],[平均指數]],tblStatus[下限值],tblStatus[狀態])","v":"RED"}]

{"sheet":"定義","index":1,"n_rows":18,"n_cols":10,"rows_kept":18}
[]
[null,"專案績效"]
[null,"衡量標準定義"]
[]
[null,"序號","衡量標準","縮寫","描述","公式 / 值",null,"狀態","描述","下限值"]
[null,1,"完工預算","BAC","基準專案成本",null,null,"BLACK","需要刪除或復原",{"v":0,"d":"0.00"}]
[null,2,"實際成本","AC","在特定期間內完成工作的總成本",null,null,"RED","需要立即注意",0.65]
[null,3,"實獲值","EV","在特定期間內完成的實際工作量",null,null,"ORANGE","稍微落後進度 / 預算",0.85]
[null,4,"計畫值","PV","在特定期間內計畫完成的實際工作量",null,null,"GREEN","符合進度",{"v":1,"d":"1.00"}]
[null,5,"成本偏差","CV","在特定期間內超過的成本","EV-AC"]
[null,6,"成本績效指標","CPI","成本效率比","EV/AC"]
[null,7,"進度偏差","SV","在特定期間內的落後時程","EV-PV"]
[null,8,"時程績效指標","SPI","時程效率比","EV/PV"]
[null,9,"未完工成本估算值","ETC","預期額外需要成本","EAC-AC"]
[null,10,"完工總成本預估值","EAC","預期總成本","BAC/CPI"]
[null,11,"預計完工成本差異","VAC","專案結束時預期超過成本","BAC-EAC"]
[null,12,"狀態","n/a","CPI 和 SPI 平均值","(CPI+SPI)/2"]
[null,13,"預期值、實獲值、實際值","PEA","預期值、實獲值、實際值以及走勢圖"]