{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Prepaid Exp. Settlement"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":24,"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":"Prepaid Exp. Settlement","index":0,"n_rows":13,"n_cols":34,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,2,1,3],[12,2,12,3]]}
[]
["البيـــــــــــان",null,"الفترة",null,null,"رصيد\nأول المدة","إضافات\nخلال العام",null,"2012-01-01",{"$f":"I2+I3","v":"2012-02-01"},{"$f":"J2+J3","v":"2012-03-01"},"2012-04-01","2012-05-01","2012-06-01","2012-07-01","2012-08-01","2012-09-01","2012-10-01","2012-11-01","2012-12-01",{"$f":"T2+T3","v":"2013-01-01"},"2013-02-01",{"$f":"V2+V3","v":"2013-03-01"},{"$f":"W2+W3","v":"2013-04-01"},"2013-05-01","2013-06-01","2013-07-01","2013-08-01","2013-09-01","2013-10-01","2013-11-01","2013-12-01",null,"الرصيد"]
[null,null,null,null,null,null,null,null,{"$f":"DATEDIF(I2,DATE(YEAR(I2),MONTH(I2)+1,1),\"d\")","v":31},{"$f":"DATEDIF(J2,DATE(YEAR(J2),MONTH(J2)+1,1),\"d\")","v":29},{"$f":"DATEDIF(K2,DATE(YEAR(K2),MONTH(K2)+1,1),\"d\")","v":31},30,31,30,31,31,30,31,30,31,31,28,{"$f":"DATEDIF(W2,DATE(YEAR(W2),MONTH(W2)+1,1),\"d\")","v":31},{"$f":"DATEDIF(X2,DATE(YEAR(X2),MONTH(X2)+1,1),\"d\")","v":30},{"$f":"DATEDIF(Y2,DATE(YEAR(Y2),MONTH(Y2)+1,1),\"d\")","v":31},{"$f":"DATEDIF(Z2,DATE(YEAR(Z2),MONTH(Z2)+1,1),\"d\")","v":30},{"$f":"DATEDIF(AA2,DATE(YEAR(AA2),MONTH(AA2)+1,1),\"d\")","v":31},{"$f":"DATEDIF(AB2,DATE(YEAR(AB2),MONTH(AB2)+1,1),\"d\")","v":31},{"$f":"DATEDIF(AC2,DATE(YEAR(AC2),MONTH(AC2)+1,1),\"d\")","v":30},{"$f":"DATEDIF(AD2,DATE(YEAR(AD2),MONTH(AD2)+1,1),\"d\")","v":31},{"$f":"DATEDIF(AE2,DATE(YEAR(AE2),MONTH(AE2)+1,1),\"d\")","v":30},{"$f":"DATEDIF(AF2,DATE(YEAR(AF2),MONTH(AF2)+1,1),\"d\")","v":31}]
["وثيقة تأمين السيارة المرسيدس",null,"2012-01-01","2012-07-22",null,9275,0,null,{"$f":"IF($C4>I$2+I$3-1,0,IF($C4>=I$2,IF($D4<=I$2+I$3-1,$D4-$C4,IF($D4>I$2+I$3-1,I$2+I$3-$C4,$D4-I$2)),IF(AND(I$2>$C4,$D4>I$2+I$3-1),I$3,IF(I$2<=$D4,$D4-I$2+1,0))))*SUM($F4:$G4)/($D4-$C4+1)","v":1409.436274509804},{"$f":"IF($C4>J$2+J$3-1,0,IF($C4>=J$2,IF($D4<=J$2+J$3-1,$D4-$C4,IF($D4>J$2+J$3-1,J$2+J$3-$C4,$D4-J$2)),IF(AND(J$2>$C4,$D4>J$2+J$3-1),J$3,IF(J$2<=$D4,$D4-J$2+1,0))))*SUM($F4:$G4)/($D4-$C4+1)","v":1318.5049019607843},1409.436274509804,1363.9705882352941,1409.436274509804,1363.9705882352941,1000.2450980392157,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM($F4:$G4)-SUM($I4:$AF4)","v":0}]
["وثيقة التأمين الطبى",null,"2012-01-01","2012-10-31",null,35650,0,null,{"$f":"IF($C5>I$2+I$3-1,0,IF($C5>=I$2,IF($D5<=I$2+I$3-1,$D5-$C5,IF($D5>I$2+I$3-1,I$2+I$3-$C5,$D5-I$2)),IF(AND(I$2>$C5,$D5>I$2+I$3-1),I$3,IF(I$2<=$D5,$D5-I$2+1,0))))*SUM($F5:$G5)/($D5-$C5+1)","v":3623.4426229508199},3389.6721311475408,3623.4426229508199,3506.5573770491801,3623.4426229508199,3506.5573770491801,3623.4426229508199,3623.4426229508199,3506.5573770491801,3623.4426229508199,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM($F5:$G5)-SUM($I5:$AF5)","v":0}]
["سداد قيمة عقد صيانة ماكينة تصوير المستندات",null,"2012-02-01","2013-01-31",null,null,{"$f":"660","v":660},null,0,52.295081967213115,55.901639344262293,54.098360655737707,55.901639344262293,54.098360655737707,55.901639344262293,55.901639344262293,54.098360655737707,55.901639344262293,54.098360655737707,55.901639344262293,55.901639344262293,0,0,0,0,0,0,0,0,0,0,0,null,0]
["وثيقة تأمين السيارة المرسيدس",null,"2012-07-23","2013-07-22",null,null,{"$f":"11670","v":11670},null,0,0,0,0,0,0,287.75342465753425,991.15068493150682,959.17808219178085,991.15068493150682,959.17808219178085,991.15068493150682,991.15068493150682,895.23287671232879,991.15068493150682,959.17808219178085,991.15068493150682,959.17808219178085,703.39726027397262,0,0,0,0,0,null,0]
["وثيقة تأمين السيارة المرسيدس",null,"2012-01-01","2012-07-22",null,9275,0,null,1409.44,1318.5,1409.44,1363.97,1409.44,1363.97,1000.24,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($F8:$G8)-SUM($I8:$AF8)","v":0}]
["وثيقة التأمين الطبى",null,"2012-01-01","2012-10-31",null,35650,0,null,3623.44,3389.67,3623.44,3506.56,3623.44,3506.56,3623.44,3623.44,3506.56,3623.44,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($F9:$G9)-SUM($I9:$AF9)","v":1.0000000002037268E-2}]
["سداد قيمة عقد صيانة ماكينة تصوير المستندات",null,"2012-02-01","2013-01-31",null,null,{"$f":"660","v":660},null,0,52.3,55.9,54.1,55.9,54.1,55.9,55.9,54.1,55.9,54.1,55.9,null,null,null,null,null,null,null,null,null,null,null,null,null,55.900000000000091]
["وثيقة تأمين السيارة المرسيدس",null,"2012-07-23","2013-07-22",null,null,{"$f":"11670","v":11670},null,0,0,0,0,0,0,287.75,991.15,959.18,991.15,959.18,991.15,null,null,null,null,null,null,null,null,null,null,null,null,null,6490.4400000000005]
[]
["الإجمالى",null,null,null,null,{"$f":"F4+F5+F6+F7","v":44925},{"$f":"G4+G5+G6+G7","v":12330},null,{"$f":"SUM(I4:I7)","v":5032.8788974606241},4760.4721150755386,5088.7805368048867,4924.6263259402122,5088.7805368048867,4924.6263259402122,4967.3427849918326,4670.4949472265889,4519.8338198966985,4670.4949472265889,1013.2764428475185,1047.052324275769,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AH4:AH7)","v":0}]