{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["גנט","אודות"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"גנט","index":0,"n_rows":34,"n_cols":64,"rows_kept":34,"merged":[[1,8,1,11],[1,13,1,16],[1,18,1,21],[1,23,1,26],[1,28,1,31],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,1,4,7]]}
["צור תרשים גנט בגליון עבודה זה.\nהזן את הכותרת של פרוייקט זה בתא B1. \nכותרת המקרא נמצאת בתא I1.\nמידע אודות אופן השימוש בגליון עבודה זה, כולל הוראות לקוראי מסך ולמחבר של חוברת עבודה זו מופיע בגליון העבודה 'אודות'.\nהמשך לנווט במורד העמודה A לשמיעת הוראות נוספות.","כותרת הפרוייקט",{"$nulls":6},"מקרא:"]
["הזן את שם החברה בתא B2.\nמקרא נמצא בתאים I2 עד AC2.","שם החברה",{"$nulls":6},"מתקדם כמתוכנן",{"$nulls":4},"סיכון נמוך",{"$nulls":4},"סיכון בינוני",{"$nulls":4},"סיכון גבוה",{"$nulls":4},"ללא הקצאה"]
["הזן את השם של מנהל הפרוייקט בתא B3. הזן את תאריך ההתחלה של הפרוייקט בתא F3 או אפשר לנוסחה לדוגמה למצוא את ערך התאריך הקטן ביותר מטבלת נתוני גנט.  \nהתווית 'תאריך ההתחלה של הפרוייקט:' נמצאת בתא D3.","מנהל הפרוייקט",null,"תאריך ההתחלה של הפרוייקט:",null,{"$f":"IFERROR(IF(MIN(Milestones[התחלה])=0,TODAY(),MIN(Milestones[התחלה])),TODAY())","v":"2018-07-07"}]
["מרווח גלילה נמצא בתא F4. \nחודשים עבור התאריכים בשורה 5 מוצגים החל מהתא I4 עד תא BL4.\nאל תשנה תאים אלה. הם מתעדכנים באופן אוטומטי בהתבסס על תאריך ההתחלה של הפרוייקט בתא F3.",null,null,"מרווח גלילה:",null,0,null,null,{"$f":"TEXT(I5,\"mmmm\")","v":"יולי"},{"$nulls":6},{"$f":"IF(TEXT(P5,\"mmmm\")=I4,\"\",TEXT(P5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W5,\"mmmm\")=P4,TEXT(W5,\"mmmm\")=I4),\"\",TEXT(W5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD5,\"mmmm\")=W4,TEXT(AD5,\"mmmm\")=P4,TEXT(AD5,\"mmmm\")=I4),\"\",TEXT(AD5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK5,\"mmmm\")=AD4,TEXT(AK5,\"mmmm\")=W4,TEXT(AK5,\"mmmm\")=P4,TEXT(AK5,\"mmmm\")=I4),\"\",TEXT(AK5,\"mmmm\"))","v":"אוגוסט"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR5,\"mmmm\")=AK4,TEXT(AR5,\"mmmm\")=AD4,TEXT(AR5,\"mmmm\")=W4,TEXT(AR5,\"mmmm\")=P4),\"\",TEXT(AR5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY5,\"mmmm\")=AR4,TEXT(AY5,\"mmmm\")=AK4,TEXT(AY5,\"mmmm\")=AD4,TEXT(AY5,\"mmmm\")=W4),\"\",TEXT(AY5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF5,\"mmmm\")=AY4,TEXT(BF5,\"mmmm\")=AR4,TEXT(BF5,\"mmmm\")=AK4,TEXT(BF5,\"mmmm\")=AD4),\"\",TEXT(BF5,\"mmmm\"))","v":""}]
["תאים I5 עד BL5 מכילים את מספר היום בחודש עבור החודש המיוצג בבלוק התא מעל לכל תא תאריך, ומחושבים באופן אוטומטי.\nאל תשנה תאים אלה.\nהתאריך של היום מסומן בצבע אדום (ערך הקסדצימאלי ‎#AD3815) מהתאריך של היום בשורה 5, דרך עמודת התאריך כולה ועד לסוף לוח הזמנים של הפרוייקט.",{"$nulls":7},{"$f":"IFERROR(התחלת_הפרוייקט+הגדלת_גלילה,TODAY())","v":"2018-07-07"},{"$f":"I5+1","v":"2018-07-08"},{"$f":"J5+1","v":"2018-07-09"},"2018-07-10","2018-07-11","2018-07-12","2018-07-13",{"$f":"O5+1","v":"2018-07-14"},{"$f":"P5+1","v":"2018-07-15"},"2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20",{"$f":"V5+1","v":"2018-07-21"},{"$f":"W5+1","v":"2018-07-22"},"2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27",{"$f":"AC5+1","v":"2018-07-28"},{"$f":"AD5+1","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03",{"$f":"AJ5+1","v":"2018-08-04"},{"$f":"AK5+1","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10",{"$f":"AQ5+1","v":"2018-08-11"},{"$f":"AR5+1","v":"2018-08-12"},"2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17",{"$f":"AX5+1","v":"2018-08-18"},{"$f":"AY5+1","v":"2018-08-19"},{"$f":"AZ5+1","v":"2018-08-20"},"2018-08-21","2018-08-22","2018-08-23","2018-08-24",{"$f":"BE5+1","v":"2018-08-25"},{"$f":"BF5+1","v":"2018-08-26"},{"$f":"BG5+1","v":"2018-08-27"},"2018-08-28","2018-08-29","2018-08-30","2018-08-31"]
["פס גלילה נמצא בתאים I6 עד BL6. המרווח עבור הדפדוף בנתונים מוגדר כ- 2 עמודים בכל פעם, וניתן לקבוע את תצורתו בהגדרות עבור סרגל הבקרה. \nכדי לדלג קדימה או אחורה בציר הזמן, הזן ערך 0 או גבוה יותר בתא F4.\nערך של 0 מעביר אותך לתחילת התרשים."]
["שורה זו מכילה כותרות עליונות עבור לוח הזמנים של הפרוייקט שמתחת. \nנווט מ- B7 עד BL7 כדי לשמוע את התוכן. האות הראשונה של כל יום בשבוע עבור התאריך שמעל לכותרת זו, החל מתא I7 וכלה בתא BL7.\nכל נתוני התרשים של ציר הזמן של הפרוייקט נוצרים באופן אוטומטי בהתבסס על הקטגוריה, תאריך ההתחלה ומספר הימים שהוזן בטבלת אבני הדרך.","תיאור אבן דרך","קטגוריה","מוקצה ל","התקדמות","התחלה","מס' ימים",null,{"$f":"LEFT(TEXT(I5,\"ddd\"),5)","v":"שבת"},{"$f":"LEFT(TEXT(J5,\"ddd\"),5)","v":"יום א"},"יום ב","יום ג","יום ד","יום ה","יום ו","שבת","יום א","יום ב","יום ג","יום ד","יום ה","יום ו","שבת","יום א","יום ב","יום ג","יום ד","יום ה","יום ו","שבת","יום א","יום ב","יום ג","יום ד","יום ה","יום ו","שבת","יום א","יום ב","יום ג","יום ד","יום ה","יום ו","שבת","יום א","יום ב","יום ג","יום ד","יום ה","יום ו","שבת","יום א","יום ב","יום ג","יום ד","יום ה","יום ו","שבת","יום א","יום ב","יום ג","יום ד","יום ה","יום ו"]
["אין למחוק שורה זו. שורה זו מוסתרת כדי לשמר נוסחה המשמשת לסימון היום הנוכחי בלוח הזמנים של הפרוייקט. "]
["הזן מידע אודות הפרוייקט החל מתא B9 וכלה בתא G9. \nנתונים לדוגמה נמצאים בתאים B9 עד G33.\nהזן תיאור אבן דרך, בחר קטגוריה מהרשימה הנפתחת, הקצה מישהו לפריט, הזן את ההתקדמות, את תאריך ההתחלה ומספר הימים לביצוע המשימה כדי להתחיל ביצירת התרשים.\nההוראה הבאה מופיעה בתא A34.","כותרת 1",{"$nulls":6},{"$f":"IF(AND($C9=\"מטרה\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"אבן דרך\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"מטרה\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"אבן דרך\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"מטרה\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"אבן דרך\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"מטרה\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"אבן דרך\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"משימה 1","מטרה","שם",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-08-01"},3,null,{"$f":"IF(AND($C10=\"מטרה\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"אבן דרך\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 2","אבן דרך",null,null,{"$f":"TODAY()+5","v":"2019-08-06"},1,null,{"$f":"IF(AND($C11=\"מטרה\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"אבן דרך\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 3","סיכון נמוך",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-07-29"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 4","אבן דרך",null,null,{"$f":"F10+20","v":"2019-08-21"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 5","סיכון בינוני",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-08-07"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"כותרת 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 1","סיכון גבוה",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-08-07"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 2","מתקדם כמתוכנן",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-08-09"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 3","סיכון נמוך",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-08-14"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 4","אבן דרך",null,null,{"$f":"F18+2","v":"2019-08-16"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 5",{"$nulls":3},{"$f":"F19+1","v":"2019-08-17"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"כותרת 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 1","מתקדם כמתוכנן",null,null,{"$f":"F10+15","v":"2019-08-16"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 2","סיכון בינוני",null,null,{"$f":"F22+3","v":"2019-08-19"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 3","מתקדם כמתוכנן",null,null,{"$f":"F23+15","v":"2019-09-03"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"מטרה\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"אבן דרך\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"מטרה\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"אבן דרך\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"משימה 4","מטרה",null,null,{"$f":"F19+22","v":"2019-09-07"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"מטרה\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"אבן דרך\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 5","סיכון נמוך",null,null,{"$f":"F14","v":"2019-08-07"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"כותרת 4",{"$nulls":6},{"$f":"IF(AND($C27=\"מטרה\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"אבן דרך\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 1",{"$nulls":3},{"$f":"F25+3","v":"2019-09-10"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 3","אבן דרך",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"משימה 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["זוהי שורה ריקה",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["שורה זו מסמנת את סוף נתוני אבן הדרך של גנט. אל תזין דבר בשורה זו. \nכדי להוסיף פריטים נוספים, הוסף שורות חדשות מעל לשורה זו.","כדי להוסיף נתונים נוספים, הוסף שורות חדשות מעל לשורה זו"]

{"sheet":"אודות","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["אודות תבנית זו"]
["תבנית זו מספקת דרך פשוטה ליצירת תרשים גנט אשר יעזור לך להציג פרוייקט ולנהל אחריו מעקב. הזן את תיאור המשימות, בחר קטגוריה של מטרה, אבן דרך, התקדמות כמתוכנן, סיכון נמוך, סיכון בינוני, סיכון גבוה, התקדמות כאחוז השלמת המשימות, תאריך התחלה ומספר הימים להשלמת המשימה. תרשים גנט מתמלא ומקודד לפי צבעים כדי לעזור לך להבחין בין הקטגוריות השונות. פס גלילה מאפשר לך לגלול בציר הזמן. הוסף משימות חדשות על-ידי הוספת שורות חדשות.\n"]
["מדריך לקוראי מסך"]
["חוברת עבודה זו כוללת 2 גליונות עבודה. \n\nתרשים גנט\nאודות\n\nההוראות עבור כל גליון עבודה מפורטות בעמודה A החל מתא A1 של כל גליון עבודה. הן נכתבו עם טקסט מוסתר. כל שלב מנחה אותך לגבי המידע בשורה זו. כל אחד מהשלבים הבאים ממשיך בתא A2,‏ A3 וכן הלאה, אלא אם ניתנה הוראה אחרת באופן מפורש. לדוגמה, טקסט ההוראה עשוי להיות \"המשך לתא A6\" עבור השלב הבא. \n\nהטקסט המוסתר לא יודפס.\n\nכדי להסיר הוראות אלה מגליון העבודה, פשוט מחק את עמודה A."]
["זוהי ההוראה האחרונה בגליון עבודה זה."]