{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":14,"n_cols":24,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,8],[1,10,1,23],[2,20,2,23]]}
[]
["المعطيات",null,null,null,null,null,null,null,null,null,"النتائج"]
[null,"العميل1",null,null,null,null,"العميل2",null,null,null,null,"العميل1",null,null,null,null,"العميل2",null,null,null,"العناصر المتشابهه بين جدول عميل1+2"]
["التاريخ","رقم الفاتورة","مدين","دائن",null,"التاريخ","رقم الفاتورة","مدين","دائن",null,"التاريخ","رقم الفاتورة","مدين","دائن",null,"التاريخ","رقم الفاتورة","مدين","دائن",null,"التاريخ","رقم الفاتورة","مدين","دائن"]
["2018-01-01",123,100,null,null,"2018-01-01",123,200,null,null,"2018-01-01",{"$f":"INDEX($B:$B,INDEX(5^11-LARGE((INDEX(COUNTIF($G5:$I$11,$B5:$D$11),)=0)*(5^11-ROW($B5:$D$11)),ROW(L4)-ROW(L$4)+1),0))","v":123},{"$f":"INDEX($C:$C,INDEX(5^11-LARGE((INDEX(COUNTIF(G5:$I$11,B5:$D$11),)=0)*(5^11-ROW(B5:$D$11)),ROW(M4)-ROW(M$4)+1),0))","v":100},{"$f":"INDEX($D:$D,INDEX(5^11-LARGE((INDEX(COUNTIF(G5:$I$11,B5:$D$11),)=0)*(5^11-ROW(B5:$D$11)),ROW(N4)-ROW(N$4)+1),0))","v":0},null,"2018-01-01",{"$f":"INDEX($G:$G,INDEX(5^11-LARGE((INDEX(COUNTIF($B5:D$11,$G5:I$11),)=0)*(5^11-ROW($G5:I$11)),ROW(Q4)-ROW(Q$4)+1),0))","v":123},{"$f":"INDEX($H:$H,INDEX(5^11-LARGE((INDEX(COUNTIF($B5:D$11,$G5:I$11),)=0)*(5^11-ROW($G5:I$11)),ROW(R4)-ROW(R$4)+1),0))","v":200},{"$f":"INDEX($I:$I,INDEX(5^11-LARGE((INDEX(COUNTIF($B5:D$11,$G5:I$11),)=0)*(5^11-ROW($G5:I$11)),ROW(S4)-ROW(S$4)+1),0))","v":0},null,"2018-01-03",{"$f":"IF(B5&C5&D5=G5&H5&I5,B5:$B$11,\"\")","v":""},{"$f":"IF(B5&C5&D5=G5&H5&I5,$C5:C$11,\"\")","v":""},{"$f":"IF(B5&C5&D5=G5&H5&I5,$D5:D$11,\"\")","v":""}]
["2018-01-02",456,200,null,null,"2018-01-02",666,200,null,null,"2018-01-02",{"$f":"INDEX($B:$B,INDEX(5^11-LARGE((INDEX(COUNTIF($G6:$I$11,$B6:$D$11),)=0)*(5^11-ROW($B6:$D$11)),ROW(L5)-ROW(L$4)+1),0))","v":456},{"$f":"INDEX($C:$C,INDEX(5^11-LARGE((INDEX(COUNTIF(G6:$I$11,B6:$D$11),)=0)*(5^11-ROW(B6:$D$11)),ROW(M5)-ROW(M$4)+1),0))","v":200},{"$f":"INDEX($D:$D,INDEX(5^11-LARGE((INDEX(COUNTIF(G6:$I$11,B6:$D$11),)=0)*(5^11-ROW(B6:$D$11)),ROW(N5)-ROW(N$4)+1),0))","v":0},null,"2018-01-02",{"$f":"INDEX($G:$G,INDEX(5^11-LARGE((INDEX(COUNTIF($B6:D$11,$G6:I$11),)=0)*(5^11-ROW($G6:I$11)),ROW(Q5)-ROW(Q$4)+1),0))","v":666},{"$f":"INDEX($H:$H,INDEX(5^11-LARGE((INDEX(COUNTIF($B6:D$11,$G6:I$11),)=0)*(5^11-ROW($G6:I$11)),ROW(R5)-ROW(R$4)+1),0))","v":200},{"$f":"INDEX($I:$I,INDEX(5^11-LARGE((INDEX(COUNTIF($B6:D$11,$G6:I$11),)=0)*(5^11-ROW($G6:I$11)),ROW(S5)-ROW(S$4)+1),0))","v":0},null,"2018-01-10",{"$f":"IF(B6&C6&D6=G6&H6&I6,B6:$B$11,\"\")","v":""},{"$f":"IF(B6&C6&D6=G6&H6&I6,$C6:C$11,\"\")","v":""},{"$f":"IF(B6&C6&D6=G6&H6&I6,$D6:D$11,\"\")","v":""}]
["2018-01-03",789,300,null,null,"2018-01-03",789,300,null,null,"2018-01-20",{"$f":"INDEX($B:$B,INDEX(5^11-LARGE((INDEX(COUNTIF($G7:$I$11,$B7:$D$11),)=0)*(5^11-ROW($B7:$D$11)),ROW(L6)-ROW(L$4)+1),0))","v":657},{"$f":"INDEX($C:$C,INDEX(5^11-LARGE((INDEX(COUNTIF(G7:$I$11,B7:$D$11),)=0)*(5^11-ROW(B7:$D$11)),ROW(M6)-ROW(M$4)+1),0))","v":0},{"$f":"INDEX($D:$D,INDEX(5^11-LARGE((INDEX(COUNTIF(G7:$I$11,B7:$D$11),)=0)*(5^11-ROW(B7:$D$11)),ROW(N6)-ROW(N$4)+1),0))","v":300},null,"2018-01-20",{"$f":"INDEX($G:$G,INDEX(5^11-LARGE((INDEX(COUNTIF($B7:D$11,$G7:I$11),)=0)*(5^11-ROW($G7:I$11)),ROW(Q6)-ROW(Q$4)+1),0))","v":555},{"$f":"INDEX($H:$H,INDEX(5^11-LARGE((INDEX(COUNTIF($B7:D$11,$G7:I$11),)=0)*(5^11-ROW($G7:I$11)),ROW(R6)-ROW(R$4)+1),0))","v":0},{"$f":"INDEX($I:$I,INDEX(5^11-LARGE((INDEX(COUNTIF($B7:D$11,$G7:I$11),)=0)*(5^11-ROW($G7:I$11)),ROW(S6)-ROW(S$4)+1),0))","v":300},null,"2018-08-05",{"$f":"IF(B7&C7&D7=G7&H7&I7,B7:$B$11,\"\")","v":789},{"$f":"IF(B7&C7&D7=G7&H7&I7,$C7:C$11,\"\")","v":300},{"$f":"IF(B7&C7&D7=G7&H7&I7,$D7:D$11,\"\")","v":0}]
["2018-01-10",895,null,200,null,"2018-01-10",895,null,200,null,"2018-02-15",{"$f":"INDEX($B:$B,INDEX(5^11-LARGE((INDEX(COUNTIF($G8:$I$11,$B8:$D$11),)=0)*(5^11-ROW($B8:$D$11)),ROW(L7)-ROW(L$4)+1),0))","v":753},{"$f":"INDEX($C:$C,INDEX(5^11-LARGE((INDEX(COUNTIF(G8:$I$11,B8:$D$11),)=0)*(5^11-ROW(B8:$D$11)),ROW(M7)-ROW(M$4)+1),0))","v":0},{"$f":"INDEX($D:$D,INDEX(5^11-LARGE((INDEX(COUNTIF(G8:$I$11,B8:$D$11),)=0)*(5^11-ROW(B8:$D$11)),ROW(N7)-ROW(N$4)+1),0))","v":400},null,"2018-02-15",{"$f":"INDEX($G:$G,INDEX(5^11-LARGE((INDEX(COUNTIF($B8:D$11,$G8:I$11),)=0)*(5^11-ROW($G8:I$11)),ROW(Q7)-ROW(Q$4)+1),0))","v":753},{"$f":"INDEX($H:$H,INDEX(5^11-LARGE((INDEX(COUNTIF($B8:D$11,$G8:I$11),)=0)*(5^11-ROW($G8:I$11)),ROW(R7)-ROW(R$4)+1),0))","v":0},{"$f":"INDEX($I:$I,INDEX(5^11-LARGE((INDEX(COUNTIF($B8:D$11,$G8:I$11),)=0)*(5^11-ROW($G8:I$11)),ROW(S7)-ROW(S$4)+1),0))","v":688},null,null,{"$f":"IF(B8&C8&D8=G8&H8&I8,B8:$B$11,\"\")","v":895},{"$f":"IF(B8&C8&D8=G8&H8&I8,$C8:C$11,\"\")","v":0},{"$f":"IF(B8&C8&D8=G8&H8&I8,$D8:D$11,\"\")","v":200}]
["2018-01-20",657,null,300,null,"2018-01-20",555,null,300,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B9&C9&D9=G9&H9&I9,B9:$B$11,\"\")","v":""},{"$f":"IF(B9&C9&D9=G9&H9&I9,$C9:C$11,\"\")","v":""},{"$f":"IF(B9&C9&D9=G9&H9&I9,$D9:D$11,\"\")","v":""}]
["2018-02-15",753,null,400,null,"2018-02-15",753,null,688,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B10&C10&D10=G10&H10&I10,B10:$B$11,\"\")","v":""},{"$f":"IF(B10&C10&D10=G10&H10&I10,$C10:C$11,\"\")","v":""},{"$f":"IF(B10&C10&D10=G10&H10&I10,$D10:D$11,\"\")","v":""}]
["2018-08-05",159,null,500,null,"2018-08-05",159,null,500,null,"تتم المقارنه عن طريق رقم الفاتورة والمبلغ سواء مدين او دائن",null,null,null,null,"بهذا الجدول يتم المقارنه عن طريق رقم الفاتورة والمبلغ",null,null,null,null,null,{"$f":"IF(B11&C11&D11=G11&H11&I11,B11:$B$11,\"\")","v":159},{"$f":"IF(B11&C11&D11=G11&H11&I11,$C11:C$11,\"\")","v":0},{"$f":"IF(B11&C11&D11=G11&H11&I11,$D11:D$11,\"\")","v":500}]
[null,null,null,null,null,null,null,null,null,null,"من الجدول عميل 1 لرقم الفاتورة والمبلغ بجدول عميل2",null,null,null,null," مدين او دائن لجدول عميل1 مع بيانات جدول عميل 2"]
[null,null,null,null,null,null,null,null,null,null,"ما يكتب في هذا الجدول هو العناصر الغير موجودة  او مختلفة",null,null,null,null,"ما يكتب في هذا الجدول العناصر الغير موجودة او مختلفة مع جدول1"]
[null,null,null,null,null,null,null,null,null,null,"مع جدول 2"]