{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["گانت چارت"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"گانت چارت","index":0,"n_rows":35,"n_cols":66,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,10,0,30],[4,2,4,4],[3,17,3,23],[3,10,3,16],[3,2,3,4],[4,17,4,23],[4,10,4,16],[3,24,3,30],[4,24,4,30],[3,31,3,37],[4,31,4,37],[3,59,3,65],[4,59,4,65],[4,38,4,44],[3,45,3,51],[4,45,4,51],[3,38,3,44],[3,52,3,58],[4,52,4,58]]}
["[نام پروژه] زمانی‌بندی پروژه ",null,null,null,null,null,null,null,null,null,"گانت چارت با تقویم شمسی © 2020 Excelut.com"]
["[نام شرکت]",null,null,null,null,null,null,null,null,null,{"$f":"J_ADDDAY(J_SUBDAY(C4,J_WEEKDAY(C4),1),7*(H4-1),1)","v":"1399/11/18"},{"$f":"J_ADDDAY($K$5,1,1)","v":"1399/11/19"},{"$f":"J_ADDDAY($K$5,2,1)","v":"1399/11/20"},{"$f":"J_ADDDAY($K$5,3,1)","v":"1399/11/21"},{"$f":"J_ADDDAY($K$5,4,1)","v":"1399/11/22"},{"$f":"J_ADDDAY($K$5,5,1)","v":"1399/11/23"},{"$f":"J_ADDDAY($K$5,6,1)","v":"1399/11/24"},{"$f":"J_ADDDAY($K$5,7,1)","v":"1399/11/25"},{"$f":"J_ADDDAY($K$5,8,1)","v":"1399/11/26"},{"$f":"J_ADDDAY($K$5,9,1)","v":"1399/11/27"},{"$f":"J_ADDDAY($K$5,10,1)","v":"1399/11/28"},{"$f":"J_ADDDAY($K$5,11,1)","v":"1399/11/29"},{"$f":"J_ADDDAY($K$5,12,1)","v":"1399/11/30"},{"$f":"J_ADDDAY($K$5,13,1)","v":"1399/12/01"},{"$f":"J_ADDDAY($K$5,14,1)","v":"1399/12/02"},{"$f":"J_ADDDAY($K$5,15,1)","v":"1399/12/03"},{"$f":"J_ADDDAY($K$5,16,1)","v":"1399/12/04"},{"$f":"J_ADDDAY($K$5,17,1)","v":"1399/12/05"},{"$f":"J_ADDDAY($K$5,18,1)","v":"1399/12/06"},{"$f":"J_ADDDAY($K$5,19,1)","v":"1399/12/07"},{"$f":"J_ADDDAY($K$5,20,1)","v":"1399/12/08"},{"$f":"J_ADDDAY($K$5,21,1)","v":"1399/12/09"},{"$f":"J_ADDDAY($K$5,22,1)","v":"1399/12/10"},{"$f":"J_ADDDAY($K$5,23,1)","v":"1399/12/11"},{"$f":"J_ADDDAY($K$5,24,1)","v":"1399/12/12"},{"$f":"J_ADDDAY($K$5,25,1)","v":"1399/12/13"},{"$f":"J_ADDDAY($K$5,26,1)","v":"1399/12/14"},{"$f":"J_ADDDAY($K$5,27,1)","v":"1399/12/15"},{"$f":"J_ADDDAY($K$5,28,1)","v":"1399/12/16"},{"$f":"J_ADDDAY($K$5,29,1)","v":"1399/12/17"},{"$f":"J_ADDDAY($K$5,30,1)","v":"1399/12/18"},{"$f":"J_ADDDAY($K$5,31,1)","v":"1399/12/19"},{"$f":"J_ADDDAY($K$5,32,1)","v":"1399/12/20"},{"$f":"J_ADDDAY($K$5,33,1)","v":"1399/12/21"},{"$f":"J_ADDDAY($K$5,34,1)","v":"1399/12/22"},{"$f":"J_ADDDAY($K$5,35,1)","v":"1399/12/23"},{"$f":"J_ADDDAY($K$5,36,1)","v":"1399/12/24"},{"$f":"J_ADDDAY($K$5,37,1)","v":"1399/12/25"},{"$f":"J_ADDDAY($K$5,38,1)","v":"1399/12/26"},{"$f":"J_ADDDAY($K$5,39,1)","v":"1399/12/27"},{"$f":"J_ADDDAY($K$5,40,1)","v":"1399/12/28"},{"$f":"J_ADDDAY($K$5,41,1)","v":"1399/12/29"},{"$f":"J_ADDDAY($K$5,42,1)","v":"1399/12/30"},{"$f":"J_ADDDAY($K$5,43,1)","v":"1400/01/01"},{"$f":"J_ADDDAY($K$5,44,1)","v":"1400/01/02"},{"$f":"J_ADDDAY($K$5,45,1)","v":"1400/01/03"},{"$f":"J_ADDDAY($K$5,46,1)","v":"1400/01/04"},{"$f":"J_ADDDAY($K$5,47,1)","v":"1400/01/05"},{"$f":"J_ADDDAY($K$5,48,1)","v":"1400/01/06"},{"$f":"J_ADDDAY($K$5,49,1)","v":"1400/01/07"},{"$f":"J_ADDDAY($K$5,50,1)","v":"1400/01/08"},{"$f":"J_ADDDAY($K$5,51,1)","v":"1400/01/09"},{"$f":"J_ADDDAY($K$5,52,1)","v":"1400/01/10"},{"$f":"J_ADDDAY($K$5,53,1)","v":"1400/01/11"},{"$f":"J_ADDDAY($K$5,54,1)","v":"1400/01/12"},{"$f":"J_ADDDAY($K$5,55,1)","v":"1400/01/13"}]
[]
[null,"تاریخ شروع پروژه","1399/11/19",null,null,null,"هفته",1,null,null,{"$f":"J_DIFF(J_SUBDAY($C$4,J_WEEKDAY($C$4),1),K5)/7+1","v":1},null,null,null,null,null,null,{"$f":"K4+1","v":2},null,null,null,null,null,null,{"$f":"R4+1","v":3},null,null,null,null,null,null,{"$f":"Y4+1","v":4},null,null,null,null,null,null,{"$f":"AF4+1","v":5},null,null,null,null,null,null,{"$f":"AM4+1","v":6},null,null,null,null,null,null,{"$f":"AT4+1","v":7},null,null,null,null,null,null,{"$f":"BA4+1","v":8}]
[null,"سرپرستی پروژه",null,null,null,null,null,null,null,null,{"$f":"K2","v":"1399/11/18"},null,null,null,null,null,null,{"$f":"R2","v":"1399/11/25"},null,null,null,null,null,null,{"$f":"Y2","v":"1399/12/02"},null,null,null,null,null,null,{"$f":"AF2","v":"1399/12/09"},null,null,null,null,null,null,{"$f":"AM2","v":"1399/12/16"},null,null,null,null,null,null,{"$f":"AT2","v":"1399/12/23"},null,null,null,null,null,null,{"$f":"BA2","v":"1399/12/30"},null,null,null,null,null,null,{"$f":"BH2","v":"1400/01/07"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(K2,2)","v":"18"},{"$f":"RIGHT(L2,2)","v":"19"},{"$f":"RIGHT(M2,2)","v":"20"},"21","22","23","24","25","26","27","28","29","30","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","01","02","03","04","05","06","07","08","09","10","11","12","13"]
["ردیف","فعالیت","سرپرستی","PREDECESSOR","شروع","پایان","روزها","% انجام",null,null,"ش","ی","د","س","چ","پ","ج","ش","ی","د","س","چ","پ","ج","ش","ی","د","س","چ","پ","ج","ش","ی","د","س","چ","پ","ج","ش","ی","د","س","چ","پ","ج","ش","ی","د","س","چ","پ","ج","ش","ی","د","س","چ","پ","ج","ش","ی","د","س","چ","پ","ج"]
["1","[رده‌ی فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E8),\" - \",IF(G8=0,E8,E8+G8-1))","v":" - "}]
["1.1","[فعالیت]","[نام]",null,"1399/11/27",{"$f":"IF(ISBLANK(E9),\" - \",IF(G9=0,E9,J_SUBDAY(J_ADDDAY(E9,G9,1),1,1)))","v":"1399/12/14"},18,0.5]
["1.2","[فعالیت]",null,null,"1399/12/17",{"$f":"IF(ISBLANK(E10),\" - \",IF(G10=0,E10,J_SUBDAY(J_ADDDAY(E10,G10,1),1,1)))","v":"1399/12/21"},5,0.6]
["1.3","[فعالیت]",null,null,"1399/12/1",{"$f":"IF(ISBLANK(E11),\" - \",IF(G11=0,E11,J_SUBDAY(J_ADDDAY(E11,G11,1),1,1)))","v":"1399/12/04"},4,0]
["1.4","[فعالیت]",null,null,"1399/11/15",{"$f":"IF(ISBLANK(E12),\" - \",IF(G12=0,E12,J_SUBDAY(J_ADDDAY(E12,G12,1),1,1)))","v":"1399/11/18"},4,0.75]
["1.4.1","[زیر-فعالیت]",null,null,"1399/11/22",{"$f":"IF(ISBLANK(E13),\" - \",IF(G13=0,E13,J_SUBDAY(J_ADDDAY(E13,G13,1),1,1)))","v":"1399/11/29"},8,0.5]
["1.4.2","[زیر-فعالیت]",null,null,"1399/12/12",{"$f":"IF(ISBLANK(E14),\" - \",IF(G14=0,E14,J_SUBDAY(J_ADDDAY(E14,G14,1),1,1)))","v":"1400/01/03"},22,0.25]
["1.5","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E15),\" - \",IF(G15=0,E15,J_SUBDAY(J_ADDDAY(E15,G15,1),1,1)))","v":" - "},null,0]
["1.6","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E16),\" - \",IF(G16=0,E16,J_SUBDAY(J_ADDDAY(E16,G16,1),1,1)))","v":" - "},null,0]
["1.7","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E17),\" - \",IF(G17=0,E17,J_SUBDAY(J_ADDDAY(E17,G17,1),1,1)))","v":" - "},null,0]
["2","[رده‌ی فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E18),\" - \",IF(G18=0,E18,J_SUBDAY(J_ADDDAY(E18,G18,1),1,1)))","v":" - "}]
["2.1","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E19),\" - \",IF(G19=0,E19,J_SUBDAY(J_ADDDAY(E19,G19,1),1,1)))","v":" - "},null,0]
["2.2","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E20),\" - \",IF(G20=0,E20,J_SUBDAY(J_ADDDAY(E20,G20,1),1,1)))","v":" - "},null,0]
["2.3","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E21),\" - \",IF(G21=0,E21,J_SUBDAY(J_ADDDAY(E21,G21,1),1,1)))","v":" - "},null,0]
["2.4","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E22),\" - \",IF(G22=0,E22,J_SUBDAY(J_ADDDAY(E22,G22,1),1,1)))","v":" - "},null,0]
["2.5","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E23),\" - \",IF(G23=0,E23,J_SUBDAY(J_ADDDAY(E23,G23,1),1,1)))","v":" - "},null,0]
["3","[رده‌ی فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E24),\" - \",IF(G24=0,E24,J_SUBDAY(J_ADDDAY(E24,G24,1),1,1)))","v":" - "}]
["3.1","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E25),\" - \",IF(G25=0,E25,J_SUBDAY(J_ADDDAY(E25,G25,1),1,1)))","v":" - "},null,0]
["3.2","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E26),\" - \",IF(G26=0,E26,J_SUBDAY(J_ADDDAY(E26,G26,1),1,1)))","v":" - "},null,0]
["3.3","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E27),\" - \",IF(G27=0,E27,J_SUBDAY(J_ADDDAY(E27,G27,1),1,1)))","v":" - "},null,0]
["3.4","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E28),\" - \",IF(G28=0,E28,J_SUBDAY(J_ADDDAY(E28,G28,1),1,1)))","v":" - "},null,0]
["3.5","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E29),\" - \",IF(G29=0,E29,J_SUBDAY(J_ADDDAY(E29,G29,1),1,1)))","v":" - "},null,0]
["4","[رده‌ی فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E30),\" - \",IF(G30=0,E30,J_SUBDAY(J_ADDDAY(E30,G30,1),1,1)))","v":" - "}]
["4.1","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E31),\" - \",IF(G31=0,E31,J_SUBDAY(J_ADDDAY(E31,G31,1),1,1)))","v":" - "},null,0]
["4.2","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E32),\" - \",IF(G32=0,E32,J_SUBDAY(J_ADDDAY(E32,G32,1),1,1)))","v":" - "},null,0]
["4.3","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E33),\" - \",IF(G33=0,E33,J_SUBDAY(J_ADDDAY(E33,G33,1),1,1)))","v":" - "},null,0]
["4.4","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E34),\" - \",IF(G34=0,E34,J_SUBDAY(J_ADDDAY(E34,G34,1),1,1)))","v":" - "},null,0]
["4.5","[فعالیت]",null,null,null,{"$f":"IF(ISBLANK(E35),\" - \",IF(G35=0,E35,J_SUBDAY(J_ADDDAY(E35,G35,1),1,1)))","v":" - "},null,0]