{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sheet1","المصروفات","البداية","التقرير","محمد عبد الناصر","احمد عبد العظيم محمد السيد"],"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":"Sheet1","index":0,"n_rows":40,"n_cols":29,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,6,37,6],[35,5,37,5],[35,3,37,3],[35,4,37,4],[0,1,0,2],[1,1,1,2],[2,0,2,2],[35,0,37,1],[35,2,37,2]]}
["اسم المريض",{"$f":"البداية!B6","v":0}]
["رقم موبايل المريض",{"$f":"البداية!B7","v":0}]
["تعاملات المريض خلال الشهر",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,"الــسنــة"]
["تاريخ اليوم","التشخيص","المبلغ الكلي المدفوع","حساب المعمل","الاجمالي","الطبيب المعالج","اجمالي نسبة الطبيب ","اجمالي الربح",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"البداية!C8","v":"2020"},"شهر",{"$f":"البداية!B8","v":"4"}]
[{"$f":"IF(ROWS($AB$3:AB3)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB3)))","v":"2020-04-01"},null,null,null,{"$f":"C5-D5","v":0},null,{"$f":"IF(E5>0,E5*40%,\"\")","v":""},{"$f":"IF(E5>0,E5-G5,\"\")","v":""},{"$f":"IF(B5>0,$B$1,\"\")","v":""},{"$f":"IF(C5>0,$B$2,\"\")","v":""}]
[{"$f":"IF(ROWS($AB$3:AB4)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB4)))","v":"2020-04-02"},null,null,null,{"$f":"C6-D6","v":0},null,{"$f":"IF(E6>0,E6*40%,\"\")","v":""},{"$f":"IF(E6>0,E6-G6,\"\")","v":""},{"$f":"IF(B6>0,$B$1,\"\")","v":""},{"$f":"IF(C6>0,$B$2,\"\")","v":""}]
[{"$f":"IF(ROWS($AB$3:AB5)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB5)))","v":"2020-04-03"},null,null,null,{"$f":"C7-D7","v":0},null,"",{"$f":"IF(E7>0,E7-G7,\"\")","v":""},{"$f":"IF(B7>0,$B$1,\"\")","v":""},""]
[{"$f":"IF(ROWS($AB$3:AB6)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB6)))","v":"2020-04-04"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB7)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB7)))","v":"2020-04-05"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB8)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB8)))","v":"2020-04-06"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB9)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB9)))","v":"2020-04-07"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB10)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB10)))","v":"2020-04-08"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB11)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB11)))","v":"2020-04-09"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB12)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB12)))","v":"2020-04-10"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB13)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB13)))","v":"2020-04-11"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB14)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB14)))","v":"2020-04-12"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB15)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB15)))","v":"2020-04-13"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB16)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB16)))","v":"2020-04-14"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB17)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB17)))","v":"2020-04-15"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB18)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB18)))","v":"2020-04-16"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB19)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB19)))","v":"2020-04-17"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB20)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB20)))","v":"2020-04-18"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB21)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB21)))","v":"2020-04-19"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB22)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB22)))","v":"2020-04-20"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB23)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB23)))","v":"2020-04-21"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB24)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB24)))","v":"2020-04-22"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB25)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB25)))","v":"2020-04-23"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB26)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB26)))","v":"2020-04-24"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB27)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB27)))","v":"2020-04-25"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB28)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB28)))","v":"2020-04-26"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB29)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB29)))","v":"2020-04-27"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB30)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB30)))","v":"2020-04-28"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB31)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB31)))","v":"2020-04-29"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB32)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB32)))","v":"2020-04-30"},null,null,null,0,null,"","","",""]
[{"$f":"IF(ROWS($AB$3:AB33)>DAY(EOMONTH(DATE($AA$4,$AC$4,1),0)),\"\",DATE($AA$4,$AC$4,ROWS($AB$3:AB33)))","v":""},null,null,null,0,null,"","",""]
["اجمالي الكل",null,{"$f":"SUM(C5:C35)","v":0},{"$f":"SUM(D5:D35)","v":0},0,{"$f":"SUM(F5:F35)","v":0}]
[]
[]
[null,null,null,null,{"$f":"C39-D39","v":0}]
[null,null,null,null,0]

{"sheet":"المصروفات","index":1,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,1],[3,0,3,2]]}
[]
[]
[]
["مصروفات عيادة الاسنان خلال الشهر"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
["الاجمالي",null,{"$f":"SUM(B5:B21)","v":0}]

{"sheet":"البداية","index":2,"n_rows":8,"n_cols":38,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,1,5,2],[6,1,6,2]]}
[null,null,null,{"$f":"LEN(B6)","v":0},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,null,null,null,null,null,null,null,{"$f":"B6","v":0},{"$f":"B7","v":0}]
[]
[]
[]
[]
["اسم المريض"]
["رقم الموبايل"]
["التاريخ","4","2020"]

{"sheet":"التقرير","index":3,"n_rows":698,"n_cols":13,"rows_kept":698,"cut":false,"hidden":false,"merged":[[3,12,7,12],[8,0,8,12],[3,11,7,11],[0,7,4,7],[0,8,4,8],[6,1,6,2],[0,1,0,2],[1,1,4,1],[5,1,5,2],[7,1,7,2]]}
[1,"اجمالي الربح بدون الخصومات",null,{"$f":"SUM(F11:F698)","v":18600}]
[2,"اسم الطبيب","احمد"]
["3",null,"حاتم"]
[4,null,"رنيا"]
[5,null,"محمد"]
["6","اجمالي حساب المعمل",null,{"$f":"SUM(G11:G700)","v":3600}]
[null,"المصروفات",null,{"$f":"المصروفات!C49","v":0}]
[7,"اجمالي المتبقي",null,{"$f":"D1-D2-D3-D4-D5-D6-D7","v":15000}]
["كشف باسماء وتعاملات المرضى خلال الشهر"]
["م","اسم المريض","رقم الموبايل","التاريخ","التشخيص","اجمالي البلغ","حساب المعمل","المتبقي","الطبيب المعالج","اجمالي نسبة الطبيب 40%","الربح","حالة المريض","السبب ان وجد"]
[1,"محمد عبد الناصر","01090895624","2020-04-01","تركيب درس",5000,1500,3500,"حاتم",1400,2100]
[2,"محمد عبد الناصر","01090895624","2020-04-05","حشو عصب",800,100,700,"احمد",280,420]
[3,"محمد عبد الناصر","01090895624","2020-04-08","تركيب سنة",2000,500,1500,"محمد",600,900]
[4,"محمد عبد الناصر","01090895624","2020-04-22","تنظيف",400,null,400,"احمد",160,240]
[5,"محمد عبد الناصر","01090895624","2020-04-30","تقويم",2000,500,1500,"حاتم",600,900]
[6,"احمد عبد العظيم محمد السيد","01212154899","2020-04-02","تركيب درس",5000,500,4500,"احمد",1800,2700]
[7,"احمد عبد العظيم محمد السيد","01212154899","2020-04-05","خلع اسنان",400,null,400,"احمد",160,240]
[8,"احمد عبد العظيم محمد السيد","01212154899","2020-04-08","ليزر رانيا",1000,null,1000,"رانيا",400,600]
[9,"احمد عبد العظيم محمد السيد","01212154899","2020-04-16","تقويم",2000,500,1500,"احمد",600,900]
[null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C20&\"'!\"&\"b36\"),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C76&\"'!\"&\"b36\"),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C140&\"'!\"&\"b36\"),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C204&\"'!\"&\"b36\"),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C268&\"'!\"&\"b36\"),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C332&\"'!\"&\"b36\"),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C396&\"'!\"&\"b36\"),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C460&\"'!\"&\"b36\"),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C524&\"'!\"&\"b36\"),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C588&\"'!\"&\"b36\"),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C652&\"'!\"&\"b36\"),\"\")","v":""}]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[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,""]
[null,null,null,null,null,""]

{"sheet":"محمد عبد الناصر","index":4,"n_rows":40,"n_cols":30,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,4,37,4],[35,5,37,5],[35,6,37,6],[35,7,37,7],[0,1,0,2],[1,1,1,2],[2,0,2,2],[35,0,37,1],[35,2,37,2],[35,3,37,3]]}
["اسم المريض","محمد عبد الناصر","محمد عبد الناصر"]
["رقم موبايل المريض","01090895624","01090895624"]
["تعاملات المريض خلال الشهر",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,null,"الــسنــة"]
["تاريخ اليوم","التشخيص","المبلغ الكلي المدفوع","حساب المعمل","الاجمالي","الطبيب المعالج","اجمالي نسبة الطبيب ","اجمالي الربح",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"البداية!C8","v":"2020"},"شهر",{"$f":"البداية!B8","v":"4"}]
[{"$f":"IF(ROWS($AC$3:AC3)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC3)))","v":"2020-04-01"},"تركيب درس",5000,1500,{"$f":"C5-D5","v":3500},"حاتم",{"$f":"IF(D5>0,E5*40%,\"\")","v":1400},{"$f":"IF(E5>0,E5-G5,\"\")","v":2100},null,{"$f":"IF(B5>0,$B$1,\"\")","v":"محمد عبد الناصر"},{"$f":"IF(C5>0,$B$2,\"\")","v":"01090895624"}]
[{"$f":"IF(ROWS($AC$3:AC4)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC4)))","v":"2020-04-02"},null,null,null,{"$f":"C6-D6","v":0},null,{"$f":"IF(D6>0,E6*40%,\"\")","v":""},{"$f":"IF(E6>0,E6-G6,\"\")","v":""},null,{"$f":"IF(B6>0,$B$1,\"\")","v":""},{"$f":"IF(C6>0,$B$2,\"\")","v":""}]
[{"$f":"IF(ROWS($AC$3:AC5)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC5)))","v":"2020-04-03"},null,null,null,0,null,"",{"$f":"IF(E7>0,E7-G7,\"\")","v":""},null,"",""]
[{"$f":"IF(ROWS($AC$3:AC6)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC6)))","v":"2020-04-04"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC7)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC7)))","v":"2020-04-05"},"حشو عصب",800,100,700,"احمد",280,420,null,"محمد عبد الناصر","01090895624"]
[{"$f":"IF(ROWS($AC$3:AC8)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC8)))","v":"2020-04-06"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC9)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC9)))","v":"2020-04-07"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC10)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC10)))","v":"2020-04-08"},"تركيب سنة",2000,500,1500,"محمد",600,900,null,"محمد عبد الناصر","01090895624"]
[{"$f":"IF(ROWS($AC$3:AC11)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC11)))","v":"2020-04-09"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC12)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC12)))","v":"2020-04-10"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC13)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC13)))","v":"2020-04-11"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC14)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC14)))","v":"2020-04-12"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC15)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC15)))","v":"2020-04-13"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC16)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC16)))","v":"2020-04-14"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC17)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC17)))","v":"2020-04-15"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC18)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC18)))","v":"2020-04-16"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC19)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC19)))","v":"2020-04-17"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC20)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC20)))","v":"2020-04-18"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC21)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC21)))","v":"2020-04-19"},null,null,null,0,null,{"$f":"IF(E23>0,E23*40%,\"\")","v":""},"",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC22)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC22)))","v":"2020-04-20"},null,null,null,0,null,{"$f":"IF(E24>0,E24*40%,\"\")","v":""},"",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC23)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC23)))","v":"2020-04-21"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC24)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC24)))","v":"2020-04-22"},"تنظيف",400,null,400,"احمد",160,240,null,"محمد عبد الناصر","01090895624"]
[{"$f":"IF(ROWS($AC$3:AC25)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC25)))","v":"2020-04-23"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC26)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC26)))","v":"2020-04-24"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC27)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC27)))","v":"2020-04-25"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC28)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC28)))","v":"2020-04-26"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC29)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC29)))","v":"2020-04-27"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC30)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC30)))","v":"2020-04-28"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC31)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC31)))","v":"2020-04-29"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC32)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC32)))","v":"2020-04-30"},"تقويم",2000,500,1500,"حاتم",600,900,null,"محمد عبد الناصر","01090895624"]
[{"$f":"IF(ROWS($AC$3:AC33)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC33)))","v":""},null,null,null,0,null,"","",null,""]
["اجمالي الكل",null,{"$f":"SUM(C5:C35)","v":10200},{"$f":"SUM(D5:D35)","v":2600},7600,0]
[]
[]
[null,null,null,null,0]
[null,null,null,null,0]

{"sheet":"احمد عبد العظيم محمد السيد","index":5,"n_rows":40,"n_cols":30,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,4,37,4],[35,5,37,5],[35,6,37,6],[35,7,37,7],[0,1,0,2],[1,1,1,2],[2,0,2,2],[35,0,37,1],[35,2,37,2],[35,3,37,3]]}
["اسم المريض","احمد عبد العظيم محمد السيد","احمد عبد العظيم محمد السيد"]
["رقم موبايل المريض","01212154899","01212154899"]
["تعاملات المريض خلال الشهر",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,null,"الــسنــة"]
["تاريخ اليوم","التشخيص","المبلغ الكلي المدفوع","حساب المعمل","الاجمالي","الطبيب المعالج","اجمالي نسبة الطبيب ","اجمالي الربح",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"البداية!C8","v":"2020"},"شهر",{"$f":"البداية!B8","v":"4"}]
[{"$f":"IF(ROWS($AC$3:AC3)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC3)))","v":"2020-04-01"},null,null,null,{"$f":"C5-D5","v":0},null,{"$f":"IF(E5>0,E5*40%,\"\")","v":""},{"$f":"IF(E5>0,E5-G5,\"\")","v":""},null,{"$f":"IF(B5>0,$B$1,\"\")","v":""},{"$f":"IF(C5>0,$B$2,\"\")","v":""}]
[{"$f":"IF(ROWS($AC$3:AC4)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC4)))","v":"2020-04-02"},"تركيب درس",5000,500,{"$f":"C6-D6","v":4500},"احمد",{"$f":"IF(E6>0,E6*40%,\"\")","v":1800},{"$f":"IF(E6>0,E6-G6,\"\")","v":2700},null,{"$f":"IF(B6>0,$B$1,\"\")","v":"احمد عبد العظيم محمد السيد"},{"$f":"IF(C6>0,$B$2,\"\")","v":"01212154899"}]
[{"$f":"IF(ROWS($AC$3:AC5)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC5)))","v":"2020-04-03"},null,null,null,{"$f":"C7-D7","v":0},null,"",{"$f":"IF(E7>0,E7-G7,\"\")","v":""},null,{"$f":"IF(B7>0,$B$1,\"\")","v":""},""]
[{"$f":"IF(ROWS($AC$3:AC6)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC6)))","v":"2020-04-04"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC7)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC7)))","v":"2020-04-05"},"خلع اسنان",400,null,400,"احمد",160,240,null,"احمد عبد العظيم محمد السيد","01212154899"]
[{"$f":"IF(ROWS($AC$3:AC8)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC8)))","v":"2020-04-06"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC9)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC9)))","v":"2020-04-07"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC10)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC10)))","v":"2020-04-08"},"ليزر رانيا",1000,null,1000,"رانيا",400,{"$f":"IF(E12>0,E12-G12,\"\")","v":600},null,"احمد عبد العظيم محمد السيد","01212154899"]
[{"$f":"IF(ROWS($AC$3:AC11)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC11)))","v":"2020-04-09"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC12)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC12)))","v":"2020-04-10"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC13)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC13)))","v":"2020-04-11"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC14)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC14)))","v":"2020-04-12"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC15)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC15)))","v":"2020-04-13"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC16)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC16)))","v":"2020-04-14"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC17)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC17)))","v":"2020-04-15"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC18)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC18)))","v":"2020-04-16"},"تقويم",2000,500,1500,"احمد",600,900,null,"احمد عبد العظيم محمد السيد","01212154899"]
[{"$f":"IF(ROWS($AC$3:AC19)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC19)))","v":"2020-04-17"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC20)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC20)))","v":"2020-04-18"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC21)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC21)))","v":"2020-04-19"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC22)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC22)))","v":"2020-04-20"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC23)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC23)))","v":"2020-04-21"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC24)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC24)))","v":"2020-04-22"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC25)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC25)))","v":"2020-04-23"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC26)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC26)))","v":"2020-04-24"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC27)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC27)))","v":"2020-04-25"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC28)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC28)))","v":"2020-04-26"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC29)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC29)))","v":"2020-04-27"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC30)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC30)))","v":"2020-04-28"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC31)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC31)))","v":"2020-04-29"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC32)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC32)))","v":"2020-04-30"},null,null,null,0,null,"","",null,"",""]
[{"$f":"IF(ROWS($AC$3:AC33)>DAY(EOMONTH(DATE($AB$4,$AD$4,1),0)),\"\",DATE($AB$4,$AD$4,ROWS($AC$3:AC33)))","v":""},null,null,null,0,null,"","",null,""]
["اجمالي الكل",null,{"$f":"SUM(C5:C35)","v":8400},{"$f":"SUM(D5:D35)","v":1000},7400,0]
[]
[]
[null,null,null,null,0]
[null,null,null,null,0]