{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["דוח ביצועים","הגדרות"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"דוח ביצועים","index":0,"n_rows":25,"n_cols":20,"rows_kept":25,"merged":[[1,1,1,17],[2,1,2,17],[4,3,4,4],[4,8,4,9],[4,10,4,11],[4,12,4,13],[4,14,4,17]]}
[{"$nulls":18},"הגדרות"]
[null,"ביצועי פרוייקט"]
[null,"דוח"]
[]
[{"$nulls":3},"תקציב",null,"מזוכה","בפועל",null,"עלות",null,"לוח זמנים",null,"מדד ביצועים",null,"תחזית"]
[]
[null,"מס' סידורי","תיאור פריט","ת.ב.ע. כולל (₪)","ע.מ. (₪)","ע.ז. (₪)","ע.ב. (₪)","מ.ז.ב. (₪)","ס.ע. (₪)","ס.ע. (%)","ס.ת. (₪)","ס.ת. (%)","מ.ב.ע.","מ.ב.ל.","ה.ל.","ה.ב.ס.","ס.ב.ס. (%)","ס.ב.ס. (₪)","מדד ממוצע","מצב"]
[null,"א","תוכנית א",{"$f":"SUM(D9,D13)","v":489},{"$f":"SUM(E9,E13)","v":254},{"$f":"SUM(F9,F13)","v":225},{"$f":"SUM(G9,G13)","v":266},null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-41,"d":"-41 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.16141732283464566,"d":"-16%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-29,"d":"-29 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.1141732283464567,"d":"-11%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.8458646616541353,"d":"0.85"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.8858267716535433,"d":"0.89"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":312.1066666666667,"d":"312"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":578.1066666666667,"d":"578"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.18222222222222226,"d":"-18%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-89.10666666666668,"d":"-89 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":0.8658457166538394,"d":"0.87"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"כתום"}]
[null,"א.1","פרוייקט 1",{"$f":"SUM(D10:D12)","v":186},{"$f":"SUM(E10:E12)","v":93},{"$f":"SUM(F10:F12)","v":90},{"$f":"SUM(G10:G12)","v":100},null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-10,"d":"-10 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.10752688172043011,"d":"-11%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-3,"d":"-3 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.03225806451612903,"d":"-3%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.9,"d":"0.90"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.967741935483871,"d":"0.97"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":106.66666666666666,"d":"107"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":206.66666666666666,"d":"207"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.11111111111111106,"d":"-11%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-20.666666666666657,"d":"-21 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":0.9338709677419355,"d":"0.93"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"כתום"}]
[null,"א.1.1","תוצר 1",100,55,50,60,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-10,"d":"-10 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.18181818181818182,"d":"-18%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-5,"d":"-5 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.09090909090909091,"d":"-9%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.8333333333333334,"d":"0.83"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.9090909090909091,"d":"0.91"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":60},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":120},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.2,"d":"-20%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-20,"d":"-20 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":0.8712121212121212,"d":"0.87"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"כתום"}]
[null,"א.1.‏2","תוצר 2",28,13,14,18,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-4,"d":"-4 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.3076923076923077,"d":"-31%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":1},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.07692307692307693,"d":"8%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.7777777777777778,"d":"0.78"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":1.0769230769230769,"d":"1.08"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":18},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":36},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.2857142857142857,"d":"-29%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-8,"d":"-8 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":0.9273504273504274,"d":"0.93"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"כתום"}]
[null,"א.1.‏3","תוצר 3",58,25,26,22,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":4},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.16,"d":"16%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":1},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.04,"d":"4%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":1.1818181818181819,"d":"1.18"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":1.04},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":27.076923076923073,"d":"27"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":49.07692307692307,"d":"49"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":0.1538461538461539,"d":"15%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":8.923076923076927,"d":"9"}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":1.1109090909090908,"d":"1.11"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"ירוק"}]
[null,"א.2","פרוייקט 2",{"$f":"SUM(D14:D16)","v":303},{"$f":"SUM(E14:E16)","v":161},{"$f":"SUM(F14:F16)","v":135},{"$f":"SUM(G14:G16)","v":166},null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-31,"d":"-31 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.19254658385093168,"d":"-19%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-26,"d":"-26 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.16149068322981366,"d":"-16%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.8132530120481928,"d":"0.81"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.8385093167701864,"d":"0.84"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":206.57777777777778,"d":"207"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":372.5777777777778,"d":"373"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.22962962962962966,"d":"-23%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-69.57777777777778,"d":"-70 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":0.8258811644091896,"d":"0.83"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"אדום"}]
[null,"א.2.‏1","תוצר 1",180,92,80,100,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-20,"d":"-20 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.21739130434782608,"d":"-22%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-12,"d":"-12 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.13043478260869565,"d":"-13%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.8,"d":"0.80"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.8695652173913043,"d":"0.87"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":125},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":225},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.25,"d":"-25%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-45,"d":"-45 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":0.8347826086956522,"d":"0.83"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"אדום"}]
[null,"א.2.‏2","תוצר 2",45,35,20,30,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-10,"d":"-10 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.2857142857142857,"d":"-29%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-15,"d":"-15 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.42857142857142855,"d":"-43%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.6666666666666666,"d":"0.67"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.5714285714285714,"d":"0.57"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":37.5,"d":"38"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":67.5,"d":"68"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.5,"d":"-50%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-22.5,"d":"-23 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":0.6190476190476191,"d":"0.62"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"שחור"}]
[null,"א.2.‏3","תוצר 3",78,34,35,36,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-1,"d":"-1 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.029411764705882353,"d":"-3%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":1},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.029411764705882353,"d":"3%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.9722222222222222,"d":"0.97"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":1.0294117647058822,"d":"1.03"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":44.22857142857143,"d":"44"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":80.22857142857143,"d":"80"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.02857142857142856,"d":"-3%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-2.2285714285714278,"d":"-2 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":1.0008169934640523,"d":"1.00"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"ירוק"}]
[null,"ב","תוכנית ב",{"$f":"SUM(D18,D22)","v":705},{"$f":"SUM(E18,E22)","v":363},{"$f":"SUM(F18,F22)","v":405},{"$f":"SUM(G18,G22)","v":430},null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-25,"d":"-25 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.06887052341597796,"d":"-7%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":42},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.11570247933884298,"d":"12%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.9418604651162791,"d":"0.94"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":1.115702479338843,"d":"1.12"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":318.5185185185185,"d":"319"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":748.5185185185185,"d":"749"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.061728395061728336,"d":"-6%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-43.518518518518476,"d":"-44 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":1.028781472227561,"d":"1.03"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"ירוק"}]
[null,"ב.1","פרוייקט 1",{"$f":"SUM(D19:D21)","v":375},{"$f":"SUM(E19:E21)","v":148},{"$f":"SUM(F19:F21)","v":210},{"$f":"SUM(G19:G21)","v":225},null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-15,"d":"-15 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.10135135135135136,"d":"-10%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":62},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.4189189189189189,"d":"42%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.9333333333333333,"d":"0.93"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":1.4189189189189189,"d":"1.42"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":176.78571428571428,"d":"177"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":401.7857142857143,"d":"402"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.07142857142857141,"d":"-7%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-26.785714285714278,"d":"-27 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":1.176126126126126,"d":"1.18"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"ירוק"}]
[null,"ב.1.1","תוצר 1",250,55,125,150,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-25,"d":"-25 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.45454545454545453,"d":"-45%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":70},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":1.2727272727272727,"d":"127%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.8333333333333334,"d":"0.83"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":2.272727272727273,"d":"2.27"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":150},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":300},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.2,"d":"-20%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-50,"d":"-50 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":1.5530303030303032,"d":"1.55"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"ירוק"}]
[null,"ב.1.‏2","תוצר 2",100,82,70,65,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":5},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.06097560975609756,"d":"6%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-12,"d":"-12 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.14634146341463414,"d":"-15%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":1.0769230769230769,"d":"1.08"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.8536585365853658,"d":"0.85"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":27.85714285714286,"d":"28"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":92.85714285714286,"d":"93"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":0.07142857142857138,"d":"7%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":7.142857142857139,"d":"7"}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":0.9652908067542214,"d":"0.97"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"כתום"}]
[null,"ב.1.‏3","תוצר 3",25,11,15,10,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":5},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.45454545454545453,"d":"45%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":4},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.36363636363636365,"d":"36%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":1.5,"d":"1.50"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":1.3636363636363635,"d":"1.36"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":6.666666666666668,"d":"7"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":16.666666666666668,"d":"17"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":0.33333333333333326,"d":"33%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":8.333333333333332,"d":"8"}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":1.4318181818181817,"d":"1.43"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"ירוק"}]
[null,"ב.2","פרוייקט 2",{"$f":"SUM(D23:D25)","v":330},{"$f":"SUM(E23:E25)","v":215},{"$f":"SUM(F23:F25)","v":195},{"$f":"SUM(G23:G25)","v":205},null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-10,"d":"-10 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.046511627906976744,"d":"-5%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-20,"d":"-20 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.09302325581395349,"d":"-9%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.9512195121951219,"d":"0.95"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.9069767441860465,"d":"0.91"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":141.92307692307696,"d":"142"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":346.92307692307696,"d":"347"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.0512820512820514,"d":"-5%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-16.923076923076962,"d":"-17 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":0.9290981281905841,"d":"0.93"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"כתום"}]
[null,"ב.2.‏1","תוצר 1",90,55,60,50,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":10},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.18181818181818182,"d":"18%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":5},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.09090909090909091,"d":"9%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":1.2,"d":"1.20"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":1.0909090909090908,"d":"1.09"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":25},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":75},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":0.16666666666666666,"d":"17%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":15},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":1.1454545454545455,"d":"1.15"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"ירוק"}]
[null,"ב.2.‏2","תוצר 2",90,60,50,45,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":5},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.08333333333333333,"d":"8%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-10,"d":"-10 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.16666666666666666,"d":"-17%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":1.1111111111111112,"d":"1.11"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":0.8333333333333334,"d":"0.83"}},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":36},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":81},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":0.1,"d":"10%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":9},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":0.9722222222222223,"d":"0.97"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"כתום"}]
[null,"ב.2.‏3","תוצר 3",150,100,85,110,null,{"$f":"ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.ב. (₪)]]","v":{"v":-25,"d":"-25 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ע. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.25,"d":"-25%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]-ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-15,"d":"-15 "}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ת. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":{"v":-0.15,"d":"-15%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":0.7727272727272727,"d":"0.77"}},{"$f":"IFERROR(ביצועים[[#This Row],[ע.ז. (₪)]]/ביצועים[[#This Row],[ע.מ. (₪)]],0)","v":0.85},{"$f":"IFERROR(ביצועים[[#This Row],[ה.ב.ס.]]-ביצועים[[#This Row],[ע.ב. (₪)]],0)","v":{"v":84.11764705882354,"d":"84"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]/ביצועים[[#This Row],[מ.ב.ע.]],0)","v":{"v":194.11764705882354,"d":"194"}},{"$f":"IFERROR(ביצועים[[#This Row],[ס.ב.ס. (₪)]]/ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]],0)","v":{"v":-0.2941176470588236,"d":"-29%"}},{"$f":"IFERROR(ביצועים[[#This Row],[ת.ב.ע. כולל (₪)]]-ביצועים[[#This Row],[ה.ב.ס.]],0)","v":{"v":-44.117647058823536,"d":"-44 "}},{"$f":"IFERROR((ביצועים[[#This Row],[מ.ב.ל.]]+ביצועים[[#This Row],[מ.ב.ע.]])/2,0)","v":{"v":0.8113636363636363,"d":"0.81"}},{"$f":"LOOKUP(ביצועים[[#This Row],[מדד ממוצע]],מצב[מגבלת ערך תחתון],מצב[מצב])","v":"אדום"}]

{"sheet":"הגדרות","index":1,"n_rows":18,"n_cols":10,"rows_kept":18,"merged":[[1,1,1,8],[2,1,3,8]]}
[{"$nulls":9},"דוח"]
[null,"ביצועי פרוייקט"]
[null,"הגדרות מדדים"]
[]
[null,"מס' סידורי","מדד","ראשי תיבות","תיאור","נוסחה/ערך",null,"מצב","תיאור","מגבלת ערך תחתון"]
[null,1,"תקציב בעת סיום","ת.ב.ע.","העלות הבסיסית של הפרוייקט",null,null,"שחור","מחייב עצירה או שחזור",{"v":0,"d":"0.00"}]
[null,2,"עלות בפועל","ע.ב.","סך כל העלויות שנגרמו בהשלמת העבודה במהלך פרק זמן נתון",null,null,"אדום","דורש התייחסות מיידית",0.65]
[null,3,"ערך מזוכה","ע.ז.","העבודה הפיזית שהושלמה במהלך פרק זמן נתון",null,null,"כתום","חורג במעט מלוח הזמנים/התקציב",0.85]
[null,4,"ערך מתוכנן","ע.מ.","העבודה הפיזית שמתוזמנת להשלמה במהלך פרק זמן נתון",null,null,"ירוק","מתקדם כמתוכנן",{"v":1,"d":"1.00"}]
[null,5,"סטיית עלות","ס.ע.","עודף העלויות במהלך פרק זמן נתון","ע.ז.-ע.ב."]
[null,6,"מדד ביצועי עלות","מ.ב.ע.","יחס כדאיות","ע.ז./ע.ב."]
[null,7,"סטיית תזמון","ס.ת.","סטיית תזמון במהלך פרק זמן נתון","ע.ז.-ע.מ."]
[null,8,"מדד ביצועי לוח זמנים","מ.ב.ל.","יחס יעילות תזמון","ע.ז./ע.מ."]
[null,9,"הערכה לסיום","ה.ל.","עלות נוספת צפויה שנדרשת","ה.ב.ס.-ע.ב."]
[null,10,"הערכה בעת סיום","ה.ב.ס.","עלות כוללת צפויה","ת.ב.ע./מ.ב.ע."]
[null,11,"סטייה בעת סיום","ס.ב.ס.","עודף העלויות המשוער בסיום הפרוייקט","ת.ב.ע.-ה.ב.ס."]
[null,12,"מצב","לא זמין","הממוצע של מ.ב.ע. ושל מ.ב.ל.","(מ.ב.ע.+מ.ב.ל.)/2"]
[null,13,"מתוכנן, מזוכה, בפועל","מ.ז.ב.","מתוכנן, מזוכה ובפועל יחד עם תרשים זעיר"]