{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Gantt","Névjegy"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Gantt","index":0,"n_rows":34,"n_cols":64,"rows_kept":34,"merged":[[1,8,1,13],[1,15,1,20],[1,22,1,27],[1,29,1,34],[1,36,1,41],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,1,4,7]]}
["Hozzon létre Gantt-diagramot ebben a munkafüzetben.\nÍrja be a projekt címét a B1 cellába. \nA jelmagyarázat címe a I1 cellában található.\nA Névjegy munkalapon találhatók a munkalap használatára vonatkozó információk, beleértve a képernyőolvasók utasításait és a munkafüzet szerzőjét.\nTovábbi utasításokat az A oszlopban lefelé navigálva hallgathat meg.","PROJEKT MEGNEVEZÉSE",{"$nulls":6},"Jelmagyarázat:"]
["A B2 cellában adhatja meg a cég nevét.\nA jelmagyarázat az I2 és AC2 közötti cellákban található.","Cég neve",{"$nulls":6},"Terv szerint",{"$nulls":6},"Alacsony kockázat",{"$nulls":6},"Közepes kockázat",{"$nulls":6},"Magas kockázat",{"$nulls":6},"Hozzárendelés nélküli"]
["Írja be a B3 cellába a projekthez tartozó érdeklődő nevét. Írja be a projekt kezdési dátumát az F3 cellába, vagy hagyja, hogy a képlet megkeresse a legkisebb dátumértéket a Gantt-adattáblából.  \nA projekt kezdési dátuma: a címke a D3 cellában van.","Projekt vezetője",null,"Projekt kezdési dátuma:",null,{"$f":"IFERROR(IF(MIN(Mérföldkövek[Kezdés])=0,TODAY(),MIN(Mérföldkövek[Kezdés])),TODAY())","v":"2018-07-07"}]
["A görgetési növekmény az F4 cellában van. \nAz 5. sor dátumaihoz tartozó hónapok az I4 és BL4 közötti cellákban jelennek meg.\nNe módosítsa ezeket a cellákat. A program automatikusan frissíti őket az F3 cellában lévő projekt kezdési dátum alapján.",null,null,"Görgetési növekmény:",null,0,null,null,{"$f":"TEXT(I5,\"hhhh\")","v":"július"},{"$nulls":6},{"$f":"IF(TEXT(P5,\"hhhh\")=I4,\"\",TEXT(P5,\"hhhh\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W5,\"hhhh\")=P4,TEXT(W5,\"hhhh\")=I4),\"\",TEXT(W5,\"hhhh\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD5,\"hhhh\")=W4,TEXT(AD5,\"hhhh\")=P4,TEXT(AD5,\"hhhh\")=I4),\"\",TEXT(AD5,\"hhhh\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK5,\"hhhh\")=AD4,TEXT(AK5,\"hhhh\")=W4,TEXT(AK5,\"hhhh\")=P4,TEXT(AK5,\"hhhh\")=I4),\"\",TEXT(AK5,\"hhhh\"))","v":"augusztus"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR5,\"hhhh\")=AK4,TEXT(AR5,\"hhhh\")=AD4,TEXT(AR5,\"hhhh\")=W4,TEXT(AR5,\"hhhh\")=P4),\"\",TEXT(AR5,\"hhhh\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY5,\"hhhh\")=AR4,TEXT(AY5,\"hhhh\")=AK4,TEXT(AY5,\"hhhh\")=AD4,TEXT(AY5,\"hhhh\")=W4),\"\",TEXT(AY5,\"hhhh\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF5,\"hhhh\")=AY4,TEXT(BF5,\"hhhh\")=AR4,TEXT(BF5,\"hhhh\")=AK4,TEXT(BF5,\"hhhh\")=AD4),\"\",TEXT(BF5,\"hhhh\"))","v":""}]
["Az I5-től BL5-ig terjedő cellák tartalmazzák az egyes dátum cellák felett megjelenő hónap napjának számát, automatikusan számítva.\nNe módosítsa ezeket a cellákat.\nA mai dátum piros színnel (hex #AD3815) kiemelve jelenik meg a mai naptól az 5. sorban a teljes dátum oszlopban a projekt ütemtervének végéig.",{"$nulls":7},{"$f":"IFERROR(Project_Start+Scrolling_Increment,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"]
["A görgetősáv az I6 és BL6 közötti cellákban található. Az adatokon keresztüli lapozás növelése egyszerre 2 lapban meghatározott, és konfigurálható a parancssáv beállításai között. \nAz idősoron előre vagy hátra ugráshoz írjon be egy 0-át vagy annál nagyobb értéket az F4 cellába.\nA 0-ás érték a diagram elejére visz."]
["Ez a sor azoknak a projekt ütemterveknek az élőfejeit tartalmazza, amelyek alattuk helyezkednek el. \nA tartalom meghallgatásához mozogjon a B7 és a BL7 között. A hét az adott fejléc feletti dátumhoz tartozó napjának első betűje az I7 cellánál kezdődik és a BL7-ig tart.\nMinden projekt idősávja automatikusan kerül létrehozásra a kategória, kezdési dátum és a mérföldkövek táblázatban szereplő napok száma alapján.","Mérföldkőleírás","Kategória","Felelős","Állapot","Kezdés","Napok száma",null,{"$f":"LEFT(TEXT(I5,\"nnn\"),3)","v":"Szo"},"V","H","K","Sze","Cs","P","Szo","V","H","K","Sze","Cs","P","Szo","V","H","K","Sze","Cs","P","Szo","V","H","K","Sze","Cs","P","Szo","V","H","K",{"$f":"LEFT(TEXT(AO5,\"nnn\"),3)","v":"Sze"},"Cs","P","Szo","V","H","K","Sze","Cs","P","Szo","V","H","K","Sze","Cs","P","Szo","V","H","K","Sze","Cs","P"]
["Ne törölje ezt a sort. Ez a sor el van rejtve, hogy megőrizze a projekt ütemtervén belül az aktuális nap kiemelésére szolgáló függvényt. "]
["Írja be a projektadatokat a B9 cellától a G9 celláig. \nA B9–G33 cellákban találhatók a mintaadatok.\nAdja meg a mérföldkő leírását, válasszon ki egy kategóriát a legördülő listából, rendeljen hozzá valakit az elemhez, adja meg a kezdési dátumot és a napok számát a diagram indításához.\nA következő utasítás az A34 cellában található.","Cím 1",{"$nulls":6},{"$f":"IF(AND($C9=\"Célkitűzés\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"Mérföldkő\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Célkitűzés\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"Mérföldkő\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Célkitűzés\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"Mérföldkő\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Célkitűzés\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"Mérföldkő\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"1. feladat","Célkitűzés","Név",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-08-01"},3,null,{"$f":"IF(AND($C10=\"Célkitűzés\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"Mérföldkő\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"2. feladat","Mérföldkő",null,null,{"$f":"TODAY()+5","v":"2019-08-06"},1,null,{"$f":"IF(AND($C11=\"Célkitűzés\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"Mérföldkő\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"3. feladat","Alacsony kockázat",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-07-29"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"4. feladat","Mérföldkő",null,null,{"$f":"F10+20","v":"2019-08-21"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"5. feladat","Közepes kockázat",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-08-07"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Cím 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"1. feladat","Magas kockázat",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-08-07"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"2. feladat","Terv szerint",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-08-09"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"3. feladat","Alacsony kockázat",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-08-14"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"4. feladat","Mérföldkő",null,null,{"$f":"F18+2","v":"2019-08-16"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"5. feladat",{"$nulls":3},{"$f":"F19+1","v":"2019-08-17"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Cím 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"1. feladat","Terv szerint",null,null,{"$f":"F10+15","v":"2019-08-16"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"2. feladat","Közepes kockázat",null,null,{"$f":"F22+3","v":"2019-08-19"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"3. feladat","Terv szerint",null,null,{"$f":"F23+15","v":"2019-09-03"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Célkitűzés\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"Mérföldkő\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Célkitűzés\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"Mérföldkő\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"4. feladat","Célkitűzés",null,null,{"$f":"F19+22","v":"2019-09-07"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"Célkitűzés\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"Mérföldkő\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"5. feladat","Alacsony kockázat",null,null,{"$f":"F14","v":"2019-08-07"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Cím 4",{"$nulls":6},{"$f":"IF(AND($C27=\"Célkitűzés\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"Mérföldkő\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"1. feladat",{"$nulls":3},{"$f":"F25+3","v":"2019-09-10"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"2. feladat",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"3. feladat","Mérföldkő",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"4. feladat",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Ez egy üres sor.","5. feladat",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Ez a sor jelöli a Gantt-mérföldkövek adatainak végét. NE írjon be semmit ebbe a sorba. \nHa további elemeket szeretne felvenni, szúrjon be új sorokat e fölé.",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Ha további adatokat szeretne felvenni, szúrjon be új sorokat e FÖLÉ."]

{"sheet":"Névjegy","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["A sablon ismertetése"]
["Ez a sablon egyszerű megoldást nyújt arra, hogy létrehozzon egy Gantt-diagramot projektje megjelenítéséhez és követéséhez. Egyszerűen írja be a feladatok leírását, válasszon egy kategóriát a Célkitűzés, Mérföldkő, Terv szerint, Alacsony kockázat, Közepes kockázat, Magas kockázat közül; egy Állapotot a tevékenység készültségi százaléka alapján, valamint egy Kezdési dátumot és a Napok számát a tevékenység elvégzéséhez. A Gantt-diagram kitölti, és színkódolással segíti a különféle kategóriák elkülönítését. A görgetősáv lehetővé teszi az idővonal görgetését. Adjon hozzá új feladatokat új sorok beszúrásával.\n"]
["Útmutatók képernyőolvasókhoz"]
["Ebben a munkafüzetben 2 munkalap található. \n\nGantt-diagram\nNévjegy\n\nAz egyes munkalapok utasításai az A oszlopban találhatók az A1 cellával kezdődően. Rejtett formázású szöveggel írtuk őket. Minden lépés végigvezeti az adott sorra vonatkozó információkon. Ettől kifejezetten eltérő utasítás hiányában a további lépések az A2, A3 stb. cellákban folytatódnak. Az utasítás szövegében például szerepelhet a következő: „lépjen az A6 cellába” a következő lépésért. \n\nA rejtett szöveg nyomtatásban nem lesz látható.\n\nHa a munkalapról el szeretné távolítani ezeket az utasításokat, egyszerűen törölje az A oszlopot."]
["Ezen a munkalapon ez az utolsó utasítás."]