{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ورقة1","ورقة2","ورقة3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"ورقة1","index":0,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,4,0,14],[1,4,1,14]]}
[null,"01/01/1442",null,null,"تم تفكيك المعادلة علي أعمدة لغرض الإيضاح"]
[null,"تاريخ الفاتورة","عدد الأشهر","تاريخ الإنتهاء","أعمدة حسابية يمكن إخفائها",null,null,null,null,null,null,null,null,null,null,"تاريخ الإنتهاء ( نص )"]
[null,{"$f":"$B$1","v":"01/01/1442"},0,{"$f":"B3+(C3*29.5)","v":{"$error":"#VALUE!"}},{"$f":"TEXT(B3,\"[$-1970000]B2TT/MM/JJJJ;@\")","v":"01/01/1442"},{"$f":"VALUE(MID(E3,4,2))","v":1},{"$f":"VALUE(RIGHT(E3,4))","v":1442},{"$f":"C3/12","v":0},{"$f":"INT(H3)","v":0},{"$f":"H3-INT(H3)","v":0},{"$f":"J3*12","v":0},{"$f":"F3+K3","v":1},{"$f":"IF(L3>12,L3-12,L3)","v":1},{"$f":"IF(L3>12,1,0)","v":0},{"$f":"G3+I3+N3","v":1442},{"$f":"LEFT(E3,2)&\"/\"&TEXT(M3,\"00\")&\"/\"&TEXT(O3,\"0000\")","v":"01/01/1442"},{"$f":"greg_date(P3)","v":{"$error":"#NAME?"}}]
[null,{"$f":"$B$1","v":"01/01/1442"},1,{"$f":"B4+(C4*29.5)","v":{"$error":"#VALUE!"}},{"$f":"TEXT(B4,\"[$-1970000]B2TT/MM/JJJJ;@\")","v":"01/01/1442"},{"$f":"VALUE(MID(E4,4,2))","v":1},{"$f":"VALUE(RIGHT(E4,4))","v":1442},{"$f":"C4/12","v":8.3333333333333329E-2},{"$f":"INT(H4)","v":0},{"$f":"H4-INT(H4)","v":8.3333333333333329E-2},{"$f":"J4*12","v":1},{"$f":"F4+K4","v":2},{"$f":"IF(L4>12,L4-12,L4)","v":2},{"$f":"IF(L4>12,1,0)","v":0},{"$f":"G4+I4+N4","v":1442},{"$f":"LEFT(E4,2)&\"/\"&TEXT(M4,\"00\")&\"/\"&TEXT(O4,\"0000\")","v":"01/02/1442"},{"$f":"greg_date(P4)","v":{"$error":"#NAME?"}}]
[null,"01/01/1442",2,{"$error":"#VALUE!"},"01/01/1442",1,1442,0.16666666666666666,0,0.16666666666666666,2,3,3,0,1442,"01/03/1442",{"$error":"#NAME?"}]
[null,"01/01/1442",3,{"$f":"B6+(C6*29.5)","v":{"$error":"#VALUE!"}},"01/01/1442",1,1442,0.25,0,0.25,3,4,4,0,1442,"01/04/1442",{"$error":"#NAME?"}]
[null,"01/01/1442",4,{"$error":"#VALUE!"},"01/01/1442",1,1442,0.33333333333333331,0,0.33333333333333331,4,5,5,0,1442,"01/05/1442",{"$error":"#NAME?"}]
[null,"01/01/1442",5,{"$error":"#VALUE!"},"01/01/1442",1,1442,0.41666666666666669,0,0.41666666666666669,5,6,6,0,1442,"01/06/1442",{"$error":"#NAME?"}]
[null,"01/01/1442",6,{"$error":"#VALUE!"},"01/01/1442",1,1442,0.5,0,0.5,6,7,7,0,1442,"01/07/1442",{"$error":"#NAME?"}]
[null,"01/01/1442",7,{"$error":"#VALUE!"},"01/01/1442",1,1442,0.58333333333333337,0,0.58333333333333337,7,8,8,0,1442,"01/08/1442",{"$error":"#NAME?"}]
[null,"01/01/1442",8,{"$error":"#VALUE!"},"01/01/1442",1,1442,0.66666666666666663,0,0.66666666666666663,8,9,9,0,1442,"01/09/1442",{"$error":"#NAME?"}]
[null,"01/01/1442",9,{"$error":"#VALUE!"},"01/01/1442",1,1442,0.75,0,0.75,9,10,10,0,1442,"01/10/1442",{"$error":"#NAME?"}]
[null,"01/01/1442",10,{"$error":"#VALUE!"},"01/01/1442",1,1442,0.83333333333333337,0,0.83333333333333337,10,11,11,0,1442,"01/11/1442",{"$error":"#NAME?"}]
[null,"01/01/1442",11,{"$error":"#VALUE!"},"01/01/1442",1,1442,0.91666666666666663,0,0.91666666666666663,11,12,12,0,1442,"01/12/1442",{"$error":"#NAME?"}]
[null,"01/01/1442",12,{"$error":"#VALUE!"},"01/01/1442",1,1442,1,1,0,0,1,1,0,1443,"01/01/1443",{"$error":"#NAME?"}]
[null,"2013-12-14",5,"2014-05-10T12:00:00","11/02/1435",2,1435,0.41666666666666669,0,0.41666666666666669,5,7,7,0,1435,"11/07/1435",{"$error":"#NAME?"}]

{"sheet":"ورقة2","index":1,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,4,0,14],[1,4,1,14]]}
[null,null,null,null,"تم تفكيك المعادلة علي أعمدة لغرض الإيضاح"]
[null,"تاريخ الفاتورة","عدد الأشهر","تاريخ الإنتهاء","أعمدة حسابية يمكن إخفائها",null,null,null,null,null,null,null,null,null,null,"تاريخ الإنتهاء ( نص )"]
[null,"2014-10-16",48,{"$f":"B3+(C3*29.5)","v":"2018-09-01"},{"$f":"TEXT(B3,\"[$-1970000]B2dd/mm/yyyy;@\")","v":"dd/00/yyyy"},{"$f":"VALUE(MID(E3,4,2))","v":0},{"$f":"VALUE(RIGHT(E3,4))","v":{"$error":"#VALUE!"}},{"$f":"C3/12","v":4},{"$f":"INT(H3)","v":4},{"$f":"H3-INT(H3)","v":0},{"$f":"J3*12","v":0},{"$f":"F3+K3","v":0},{"$f":"IF(L3>12,L3-12,L3)","v":0},{"$f":"IF(L3>12,1,0)","v":0},{"$f":"G3+I3+N3","v":{"$error":"#VALUE!"}},{"$f":"LEFT(E3,2)&\"/\"&TEXT(M3,\"00\")&\"/\"&TEXT(O3,\"0000\")","v":{"$error":"#VALUE!"}}]
[null,"2013-12-02",24,{"$f":"B4+(C4*29.5)","v":"2015-11-10"},{"$f":"TEXT(B4,\"[$-1970000]B2dd/mm/yyyy;@\")","v":"dd/00/yyyy"},{"$f":"VALUE(MID(E4,4,2))","v":0},{"$f":"VALUE(RIGHT(E4,4))","v":{"$error":"#VALUE!"}},{"$f":"C4/12","v":2},{"$f":"INT(H4)","v":2},{"$f":"H4-INT(H4)","v":0},{"$f":"J4*12","v":0},{"$f":"F4+K4","v":0},{"$f":"IF(L4>12,L4-12,L4)","v":0},{"$f":"IF(L4>12,1,0)","v":0},{"$f":"G4+I4+N4","v":{"$error":"#VALUE!"}},{"$f":"LEFT(E4,2)&\"/\"&TEXT(M4,\"00\")&\"/\"&TEXT(O4,\"0000\")","v":{"$error":"#VALUE!"}}]
[null,"2013-12-03",48,"2017-10-19","dd/00/yyyy",0,{"$error":"#VALUE!"},4,4,0,0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"2013-12-16",12,{"$f":"B6+(C6*29.5)","v":"2014-12-05"},"dd/00/yyyy",0,{"$error":"#VALUE!"},1,1,0,0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"2013-12-14",24,"2015-11-22","dd/00/yyyy",0,{"$error":"#VALUE!"},2,2,0,0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"2013-12-06",48,"2017-10-22","dd/00/yyyy",0,{"$error":"#VALUE!"},4,4,0,0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"2013-12-07",48,"2017-10-23","dd/00/yyyy",0,{"$error":"#VALUE!"},4,4,0,0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"2013-12-08",48,"2017-10-24","dd/00/yyyy",0,{"$error":"#VALUE!"},4,4,0,0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"2013-12-09",480,"2052-09-15","dd/00/yyyy",0,{"$error":"#VALUE!"},40,40,0,0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"2013-11-10",48,"2017-09-26","dd/00/yyyy",0,{"$error":"#VALUE!"},4,4,0,0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"2013-12-11",24,"2015-11-19","dd/00/yyyy",0,{"$error":"#VALUE!"},2,2,0,0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"2013-12-12",24,"2015-11-20","dd/00/yyyy",0,{"$error":"#VALUE!"},2,2,0,0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"2013-12-13",12,"2014-12-02","dd/00/yyyy",0,{"$error":"#VALUE!"},1,1,0,0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"2013-12-14",5,"2014-05-10T12:00:00","dd/00/yyyy",0,{"$error":"#VALUE!"},0.41666666666666669,0,0.41666666666666669,5,5,5,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"ورقة3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}