{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["عام","تصفية النقل","النقل منتهي"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"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":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["م","الرقم ","الاســـــــــــــــــــــم","الشركة","الادارة","الوظيفة","من حقول","الى حقول","تاريخ بدايه النقل","تاريخ انتهاء النقل","استلام العمل فى","مده النقل","حالة النقل","وضع النقل - باليوم","ملاحظات","الحالــة"]
[1,1773,"احمد محمد احمد","خالدة","الاداريه","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02",{"$f":"IF(OR(I5=\"\",J5=\"\",K5=\"\"),\"\",TEXT(MONTH(J5-I5),\"00\")&IF(OR(MONTH(J5-I5)=1,MONTH(J5-I5)>10),\"شهر\",\"أشهر\"))","v":"05أشهر"},{"$f":"IF(L5<>\"\",IF(J5<NOW(),\"النقل منتهي\",\"النقل ساري\"),\"\")","v":"النقل منتهي"},{"$f":"IF(L5<>\"\",IF(J5>NOW(),\"باقي على انتهاء النقل \"&(ROUND((J5-NOW())+1,0))&\" يوم\",\"انتهت فترة النقل من \"&(-ROUND((J5-NOW())+1,0))&\" يوم\"),\"\")","v":"انتهت فترة النقل من 863 يوم"},"A","S"]
[2,1801,"أحمد إبراهيم حسين","خالدة","الصيانة","مدير إدارة","طارق","سلام","2017-06-01","2017-12-31","2017-06-01",{"$f":"IF(OR(I6=\"\",J6=\"\",K6=\"\"),\"\",TEXT(MONTH(J6-I6),\"00\")&IF(OR(MONTH(J6-I6)=1,MONTH(J6-I6)>10),\"شهر\",\"أشهر\"))","v":"07أشهر"},{"$f":"IF(L6<>\"\",IF(J6<NOW(),\"النقل منتهي\",\"النقل ساري\"),\"\")","v":"النقل منتهي"},{"$f":"IF(L6<>\"\",IF(J6>NOW(),\"باقي على انتهاء النقل \"&(ROUND((J6-NOW())+1,0))&\" يوم\",\"انتهت فترة النقل من \"&(-ROUND((J6-NOW())+1,0))&\" يوم\"),\"\")","v":"انتهت فترة النقل من 771 يوم"},"B","S"]
[3,144,"محمد احمد","سمبتكو","الادارية","مدير ادارة","طارق","كلابشه","2017-01-01","2018-01-01","2013-01-01","12شهر","النقل منتهي","انتهت فترة النقل من 770 يوم","C","S"]
[4,144,"محمد احمد علي","سمبتكو","الادارية","مدير ادارة","طارق","كلابشه","2017-08-01","2018-01-01","2013-01-01","06أشهر","النقل منتهي","انتهت فترة النقل من 770 يوم","A","S"]
[5,2065,"عطيه كامل","خالدة","الادارية","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02","05أشهر","النقل منتهي","انتهت فترة النقل من 863 يوم","B","S"]
[null,null,"dd1","خالدة","الادارية","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02",{"$f":"IF(OR(I10=\"\",J10=\"\",K10=\"\"),\"\",TEXT(MONTH(J10-I10),\"00\")&IF(OR(MONTH(J10-I10)=1,MONTH(J10-I10)>10),\"شهر\",\"أشهر\"))","v":"05أشهر"},{"$f":"IF(L10<>\"\",IF(J10<NOW(),\"النقل منتهي\",\"النقل ساري\"),\"\")","v":"النقل منتهي"},{"$f":"IF(L10<>\"\",IF(J10>NOW(),\"باقي على انتهاء النقل \"&(ROUND((J10-NOW())+1,0))&\" يوم\",\"انتهت فترة النقل من \"&(-ROUND((J10-NOW())+1,0))&\" يوم\"),\"\")","v":"انتهت فترة النقل من 863 يوم"},"B","S"]
[null,null,"dd2","خالدة","الادارية","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02","05أشهر","النقل منتهي","انتهت فترة النقل من 863 يوم","B","S"]
[null,null,"dd2","خالدة","الادارية","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02","05أشهر","النقل منتهي","انتهت فترة النقل من 863 يوم","B","S"]
[null,null,"dd1","خالدة","الادارية","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02",{"$f":"IF(OR(I13=\"\",J13=\"\",K13=\"\"),\"\",TEXT(MONTH(J13-I13),\"00\")&IF(OR(MONTH(J13-I13)=1,MONTH(J13-I13)>10),\"شهر\",\"أشهر\"))","v":"05أشهر"},{"$f":"IF(L13<>\"\",IF(J13<NOW(),\"النقل منتهي\",\"النقل ساري\"),\"\")","v":"النقل منتهي"},{"$f":"IF(L13<>\"\",IF(J13>NOW(),\"باقي على انتهاء النقل \"&(ROUND((J13-NOW())+1,0))&\" يوم\",\"انتهت فترة النقل من \"&(-ROUND((J13-NOW())+1,0))&\" يوم\"),\"\")","v":"انتهت فترة النقل من 863 يوم"},"B","S"]

{"sheet":"تصفية النقل","index":1,"n_rows":11,"n_cols":30,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1]]}
["الرقم",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الرقم ","الشركة","الادارة","تاريخ بدايه النقل","تاريخ بدايه النقل","حالة النقل",">=42856","<=42856",null,"خالدة","النقل منتهي","الاداريه"]
["الشركة",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">=42856","<=42856",null,null,null,null,"سمبتكو","النقل ساري","الصيانة"]
["الادارة",null,null,null,null,null,null,"من","2017-05-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ابو الغراديق",null,"المعمل"]
["حالة النقل",null,null,null,null,null,null,"الي","2017-05-01"]
["م","الرقم ","الاســـــــــــــــــــــم","الشركة","الادارة","الوظيفة","من حقول","الى حقول","تاريخ بدايه النقل","تاريخ انتهاء النقل","استلام العمل فى","مده النقل","حالة النقل","وضع النقل - باليوم","ملاحظات","الحالــة"]
[1,1773,"احمد محمد احمد","خالدة","الاداريه","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02","05أشهر","النقل منتهي","انتهت فترة النقل من 863 يوم","A","S"]
[5,2065,"عطيه كامل","خالدة","الادارية","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02","05أشهر","النقل منتهي","انتهت فترة النقل من 863 يوم","B","S"]
[null,null,"dd1","خالدة","الادارية","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02","05أشهر","النقل منتهي","انتهت فترة النقل من 863 يوم","B","S"]
[null,null,"dd2","خالدة","الادارية","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02","05أشهر","النقل منتهي","انتهت فترة النقل من 863 يوم","B","S"]
[null,null,"dd2","خالدة","الادارية","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02","05أشهر","النقل منتهي","انتهت فترة النقل من 863 يوم","B","S"]
[null,null,"dd1","خالدة","الادارية","مدير إدارة","طارق","سلام","2017-05-01","2017-09-30","2017-05-02","05أشهر","النقل منتهي","انتهت فترة النقل من 863 يوم","B","S"]

{"sheet":"النقل منتهي","index":2,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["م","الرقم ","الاســـــــــــــــــــــم","الشركة","الادارة","الوظيفة","من حقول","الى حقول","تاريخ بدايه النقل","تاريخ انتهاء النقل","استلام العمل فى","مده النقل","حالة النقل","وضع النقل - باليوم","ملاحظات","الحالــة"]