{"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]
["10",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C20&\"'!\"&\"b36\"),\"\")","v":""}]
["11",null,null,null,null,""]
["12",null,null,null,null,""]
["13",null,null,null,null,""]
["14",null,null,null,null,""]
["15",null,null,null,null,""]
["16",null,null,null,null,""]
["17",null,null,null,null,""]
["18",null,null,null,null,""]
["19",null,null,null,null,""]
["20",null,null,null,null,""]
["21",null,null,null,null,""]
["22",null,null,null,null,""]
["23",null,null,null,null,""]
["24",null,null,null,null,""]
["25",null,null,null,null,""]
["26",null,null,null,null,""]
["27",null,null,null,null,""]
["28",null,null,null,null,""]
["29",null,null,null,null,""]
["30",null,null,null,null,""]
["31",null,null,null,null,""]
["32",null,null,null,null,""]
["33",null,null,null,null,""]
["34",null,null,null,null,""]
["35",null,null,null,null,""]
["36",null,null,null,null,""]
["37",null,null,null,null,""]
["38",null,null,null,null,""]
["39",null,null,null,null,""]
["40",null,null,null,null,""]
["41",null,null,null,null,""]
["42",null,null,null,null,""]
["43",null,null,null,null,""]
["44",null,null,null,null,""]
["45",null,null,null,null,""]
["46",null,null,null,null,""]
["47",null,null,null,null,""]
["48",null,null,null,null,""]
["49",null,null,null,null,""]
["50",null,null,null,null,""]
["51",null,null,null,null,""]
["52",null,null,null,null,""]
["53",null,null,null,null,""]
["54",null,null,null,null,""]
["55",null,null,null,null,""]
["56",null,null,null,null,""]
["57",null,null,null,null,""]
["58",null,null,null,null,""]
["59",null,null,null,null,""]
["60",null,null,null,null,""]
["61",null,null,null,null,""]
["62",null,null,null,null,""]
["63",null,null,null,null,""]
["64",null,null,null,null,""]
["65",null,null,null,null,""]
["66",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C76&\"'!\"&\"b36\"),\"\")","v":""}]
["67",null,null,null,null,""]
["68",null,null,null,null,""]
["69",null,null,null,null,""]
["70",null,null,null,null,""]
["71",null,null,null,null,""]
["72",null,null,null,null,""]
["73",null,null,null,null,""]
["74",null,null,null,null,""]
["75",null,null,null,null,""]
["76",null,null,null,null,""]
["77",null,null,null,null,""]
["78",null,null,null,null,""]
["79",null,null,null,null,""]
["80",null,null,null,null,""]
["81",null,null,null,null,""]
["82",null,null,null,null,""]
["83",null,null,null,null,""]
["84",null,null,null,null,""]
["85",null,null,null,null,""]
["86",null,null,null,null,""]
["87",null,null,null,null,""]
["88",null,null,null,null,""]
["89",null,null,null,null,""]
["90",null,null,null,null,""]
["91",null,null,null,null,""]
["92",null,null,null,null,""]
["93",null,null,null,null,""]
["94",null,null,null,null,""]
["95",null,null,null,null,""]
["96",null,null,null,null,""]
["97",null,null,null,null,""]
["98",null,null,null,null,""]
["99",null,null,null,null,""]
["100",null,null,null,null,""]
["101",null,null,null,null,""]
["102",null,null,null,null,""]
["103",null,null,null,null,""]
["104",null,null,null,null,""]
["105",null,null,null,null,""]
["106",null,null,null,null,""]
["107",null,null,null,null,""]
["108",null,null,null,null,""]
["109",null,null,null,null,""]
["110",null,null,null,null,""]
["111",null,null,null,null,""]
["112",null,null,null,null,""]
["113",null,null,null,null,""]
["114",null,null,null,null,""]
["115",null,null,null,null,""]
["116",null,null,null,null,""]
["117",null,null,null,null,""]
["118",null,null,null,null,""]
["119",null,null,null,null,""]
["120",null,null,null,null,""]
["121",null,null,null,null,""]
["122",null,null,null,null,""]
["123",null,null,null,null,""]
["124",null,null,null,null,""]
["125",null,null,null,null,""]
["126",null,null,null,null,""]
["127",null,null,null,null,""]
["128",null,null,null,null,""]
["129",null,null,null,null,""]
["130",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C140&\"'!\"&\"b36\"),\"\")","v":""}]
["131",null,null,null,null,""]
["132",null,null,null,null,""]
["133",null,null,null,null,""]
["134",null,null,null,null,""]
["135",null,null,null,null,""]
["136",null,null,null,null,""]
["137",null,null,null,null,""]
["138",null,null,null,null,""]
["139",null,null,null,null,""]
["140",null,null,null,null,""]
["141",null,null,null,null,""]
["142",null,null,null,null,""]
["143",null,null,null,null,""]
["144",null,null,null,null,""]
["145",null,null,null,null,""]
["146",null,null,null,null,""]
["147",null,null,null,null,""]
["148",null,null,null,null,""]
["149",null,null,null,null,""]
["150",null,null,null,null,""]
["151",null,null,null,null,""]
["152",null,null,null,null,""]
["153",null,null,null,null,""]
["154",null,null,null,null,""]
["155",null,null,null,null,""]
["156",null,null,null,null,""]
["157",null,null,null,null,""]
["158",null,null,null,null,""]
["159",null,null,null,null,""]
["160",null,null,null,null,""]
["161",null,null,null,null,""]
["162",null,null,null,null,""]
["163",null,null,null,null,""]
["164",null,null,null,null,""]
["165",null,null,null,null,""]
["166",null,null,null,null,""]
["167",null,null,null,null,""]
["168",null,null,null,null,""]
["169",null,null,null,null,""]
["170",null,null,null,null,""]
["171",null,null,null,null,""]
["172",null,null,null,null,""]
["173",null,null,null,null,""]
["174",null,null,null,null,""]
["175",null,null,null,null,""]
["176",null,null,null,null,""]
["177",null,null,null,null,""]
["178",null,null,null,null,""]
["179",null,null,null,null,""]
["180",null,null,null,null,""]
["181",null,null,null,null,""]
["182",null,null,null,null,""]
["183",null,null,null,null,""]
["184",null,null,null,null,""]
["185",null,null,null,null,""]
["186",null,null,null,null,""]
["187",null,null,null,null,""]
["188",null,null,null,null,""]
["189",null,null,null,null,""]
["190",null,null,null,null,""]
["191",null,null,null,null,""]
["192",null,null,null,null,""]
["193",null,null,null,null,""]
["194",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C204&\"'!\"&\"b36\"),\"\")","v":""}]
["195",null,null,null,null,""]
["196",null,null,null,null,""]
["197",null,null,null,null,""]
["198",null,null,null,null,""]
["199",null,null,null,null,""]
["200",null,null,null,null,""]
["201",null,null,null,null,""]
["202",null,null,null,null,""]
["203",null,null,null,null,""]
["204",null,null,null,null,""]
["205",null,null,null,null,""]
["206",null,null,null,null,""]
["207",null,null,null,null,""]
["208",null,null,null,null,""]
["209",null,null,null,null,""]
["210",null,null,null,null,""]
["211",null,null,null,null,""]
["212",null,null,null,null,""]
["213",null,null,null,null,""]
["214",null,null,null,null,""]
["215",null,null,null,null,""]
["216",null,null,null,null,""]
["217",null,null,null,null,""]
["218",null,null,null,null,""]
["219",null,null,null,null,""]
["220",null,null,null,null,""]
["221",null,null,null,null,""]
["222",null,null,null,null,""]
["223",null,null,null,null,""]
["224",null,null,null,null,""]
["225",null,null,null,null,""]
["226",null,null,null,null,""]
["227",null,null,null,null,""]
["228",null,null,null,null,""]
["229",null,null,null,null,""]
["230",null,null,null,null,""]
["231",null,null,null,null,""]
["232",null,null,null,null,""]
["233",null,null,null,null,""]
["234",null,null,null,null,""]
["235",null,null,null,null,""]
["236",null,null,null,null,""]
["237",null,null,null,null,""]
["238",null,null,null,null,""]
["239",null,null,null,null,""]
["240",null,null,null,null,""]
["241",null,null,null,null,""]
["242",null,null,null,null,""]
["243",null,null,null,null,""]
["244",null,null,null,null,""]
["245",null,null,null,null,""]
["246",null,null,null,null,""]
["247",null,null,null,null,""]
["248",null,null,null,null,""]
["249",null,null,null,null,""]
["250",null,null,null,null,""]
["251",null,null,null,null,""]
["252",null,null,null,null,""]
["253",null,null,null,null,""]
["254",null,null,null,null,""]
["255",null,null,null,null,""]
["256",null,null,null,null,""]
["257",null,null,null,null,""]
["258",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C268&\"'!\"&\"b36\"),\"\")","v":""}]
["259",null,null,null,null,""]
["260",null,null,null,null,""]
["261",null,null,null,null,""]
["262",null,null,null,null,""]
["263",null,null,null,null,""]
["264",null,null,null,null,""]
["265",null,null,null,null,""]
["266",null,null,null,null,""]
["267",null,null,null,null,""]
["268",null,null,null,null,""]
["269",null,null,null,null,""]
["270",null,null,null,null,""]
["271",null,null,null,null,""]
["272",null,null,null,null,""]
["273",null,null,null,null,""]
["274",null,null,null,null,""]
["275",null,null,null,null,""]
["276",null,null,null,null,""]
["277",null,null,null,null,""]
["278",null,null,null,null,""]
["279",null,null,null,null,""]
["280",null,null,null,null,""]
["281",null,null,null,null,""]
["282",null,null,null,null,""]
["283",null,null,null,null,""]
["284",null,null,null,null,""]
["285",null,null,null,null,""]
["286",null,null,null,null,""]
["287",null,null,null,null,""]
["288",null,null,null,null,""]
["289",null,null,null,null,""]
["290",null,null,null,null,""]
["291",null,null,null,null,""]
["292",null,null,null,null,""]
["293",null,null,null,null,""]
["294",null,null,null,null,""]
["295",null,null,null,null,""]
["296",null,null,null,null,""]
["297",null,null,null,null,""]
["298",null,null,null,null,""]
["299",null,null,null,null,""]
["300",null,null,null,null,""]
["301",null,null,null,null,""]
["302",null,null,null,null,""]
["303",null,null,null,null,""]
["304",null,null,null,null,""]
["305",null,null,null,null,""]
["306",null,null,null,null,""]
["307",null,null,null,null,""]
["308",null,null,null,null,""]
["309",null,null,null,null,""]
["310",null,null,null,null,""]
["311",null,null,null,null,""]
["312",null,null,null,null,""]
["313",null,null,null,null,""]
["314",null,null,null,null,""]
["315",null,null,null,null,""]
["316",null,null,null,null,""]
["317",null,null,null,null,""]
["318",null,null,null,null,""]
["319",null,null,null,null,""]
["320",null,null,null,null,""]
["321",null,null,null,null,""]
["322",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C332&\"'!\"&\"b36\"),\"\")","v":""}]
["323",null,null,null,null,""]
["324",null,null,null,null,""]
["325",null,null,null,null,""]
["326",null,null,null,null,""]
["327",null,null,null,null,""]
["328",null,null,null,null,""]
["329",null,null,null,null,""]
["330",null,null,null,null,""]
["331",null,null,null,null,""]
["332",null,null,null,null,""]
["333",null,null,null,null,""]
["334",null,null,null,null,""]
["335",null,null,null,null,""]
["336",null,null,null,null,""]
["337",null,null,null,null,""]
["338",null,null,null,null,""]
["339",null,null,null,null,""]
["340",null,null,null,null,""]
["341",null,null,null,null,""]
["342",null,null,null,null,""]
["343",null,null,null,null,""]
["344",null,null,null,null,""]
["345",null,null,null,null,""]
["346",null,null,null,null,""]
["347",null,null,null,null,""]
["348",null,null,null,null,""]
["349",null,null,null,null,""]
["350",null,null,null,null,""]
["351",null,null,null,null,""]
["352",null,null,null,null,""]
["353",null,null,null,null,""]
["354",null,null,null,null,""]
["355",null,null,null,null,""]
["356",null,null,null,null,""]
["357",null,null,null,null,""]
["358",null,null,null,null,""]
["359",null,null,null,null,""]
["360",null,null,null,null,""]
["361",null,null,null,null,""]
["362",null,null,null,null,""]
["363",null,null,null,null,""]
["364",null,null,null,null,""]
["365",null,null,null,null,""]
["366",null,null,null,null,""]
["367",null,null,null,null,""]
["368",null,null,null,null,""]
["369",null,null,null,null,""]
["370",null,null,null,null,""]
["371",null,null,null,null,""]
["372",null,null,null,null,""]
["373",null,null,null,null,""]
["374",null,null,null,null,""]
["375",null,null,null,null,""]
["376",null,null,null,null,""]
["377",null,null,null,null,""]
["378",null,null,null,null,""]
["379",null,null,null,null,""]
["380",null,null,null,null,""]
["381",null,null,null,null,""]
["382",null,null,null,null,""]
["383",null,null,null,null,""]
["384",null,null,null,null,""]
["385",null,null,null,null,""]
["386",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C396&\"'!\"&\"b36\"),\"\")","v":""}]
["387",null,null,null,null,""]
["388",null,null,null,null,""]
["389",null,null,null,null,""]
["390",null,null,null,null,""]
["391",null,null,null,null,""]
["392",null,null,null,null,""]
["393",null,null,null,null,""]
["394",null,null,null,null,""]
["395",null,null,null,null,""]
["396",null,null,null,null,""]
["397",null,null,null,null,""]
["398",null,null,null,null,""]
["399",null,null,null,null,""]
["400",null,null,null,null,""]
["401",null,null,null,null,""]
["402",null,null,null,null,""]
["403",null,null,null,null,""]
["404",null,null,null,null,""]
["405",null,null,null,null,""]
["406",null,null,null,null,""]
["407",null,null,null,null,""]
["408",null,null,null,null,""]
["409",null,null,null,null,""]
["410",null,null,null,null,""]
["411",null,null,null,null,""]
["412",null,null,null,null,""]
["413",null,null,null,null,""]
["414",null,null,null,null,""]
["415",null,null,null,null,""]
["416",null,null,null,null,""]
["417",null,null,null,null,""]
["418",null,null,null,null,""]
["419",null,null,null,null,""]
["420",null,null,null,null,""]
["421",null,null,null,null,""]
["422",null,null,null,null,""]
["423",null,null,null,null,""]
["424",null,null,null,null,""]
["425",null,null,null,null,""]
["426",null,null,null,null,""]
["427",null,null,null,null,""]
["428",null,null,null,null,""]
["429",null,null,null,null,""]
["430",null,null,null,null,""]
["431",null,null,null,null,""]
["432",null,null,null,null,""]
["433",null,null,null,null,""]
["434",null,null,null,null,""]
["435",null,null,null,null,""]
["436",null,null,null,null,""]
["437",null,null,null,null,""]
["438",null,null,null,null,""]
["439",null,null,null,null,""]
["440",null,null,null,null,""]
["441",null,null,null,null,""]
["442",null,null,null,null,""]
["443",null,null,null,null,""]
["444",null,null,null,null,""]
["445",null,null,null,null,""]
["446",null,null,null,null,""]
["447",null,null,null,null,""]
["448",null,null,null,null,""]
["449",null,null,null,null,""]
["450",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C460&\"'!\"&\"b36\"),\"\")","v":""}]
["451",null,null,null,null,""]
["452",null,null,null,null,""]
["453",null,null,null,null,""]
["454",null,null,null,null,""]
["455",null,null,null,null,""]
["456",null,null,null,null,""]
["457",null,null,null,null,""]
["458",null,null,null,null,""]
["459",null,null,null,null,""]
["460",null,null,null,null,""]
["461",null,null,null,null,""]
["462",null,null,null,null,""]
["463",null,null,null,null,""]
["464",null,null,null,null,""]
["465",null,null,null,null,""]
["466",null,null,null,null,""]
["467",null,null,null,null,""]
["468",null,null,null,null,""]
["469",null,null,null,null,""]
["470",null,null,null,null,""]
["471",null,null,null,null,""]
["472",null,null,null,null,""]
["473",null,null,null,null,""]
["474",null,null,null,null,""]
["475",null,null,null,null,""]
["476",null,null,null,null,""]
["477",null,null,null,null,""]
["478",null,null,null,null,""]
["479",null,null,null,null,""]
["480",null,null,null,null,""]
["481",null,null,null,null,""]
["482",null,null,null,null,""]
["483",null,null,null,null,""]
["484",null,null,null,null,""]
["485",null,null,null,null,""]
["486",null,null,null,null,""]
["487",null,null,null,null,""]
["488",null,null,null,null,""]
["489",null,null,null,null,""]
["490",null,null,null,null,""]
["491",null,null,null,null,""]
["492",null,null,null,null,""]
["493",null,null,null,null,""]
["494",null,null,null,null,""]
["495",null,null,null,null,""]
["496",null,null,null,null,""]
["497",null,null,null,null,""]
["498",null,null,null,null,""]
["499",null,null,null,null,""]
["500",null,null,null,null,""]
["501",null,null,null,null,""]
["502",null,null,null,null,""]
["503",null,null,null,null,""]
["504",null,null,null,null,""]
["505",null,null,null,null,""]
["506",null,null,null,null,""]
["507",null,null,null,null,""]
["508",null,null,null,null,""]
["509",null,null,null,null,""]
["510",null,null,null,null,""]
["511",null,null,null,null,""]
["512",null,null,null,null,""]
["513",null,null,null,null,""]
["514",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C524&\"'!\"&\"b36\"),\"\")","v":""}]
["515",null,null,null,null,""]
["516",null,null,null,null,""]
["517",null,null,null,null,""]
["518",null,null,null,null,""]
["519",null,null,null,null,""]
["520",null,null,null,null,""]
["521",null,null,null,null,""]
["522",null,null,null,null,""]
["523",null,null,null,null,""]
["524",null,null,null,null,""]
["525",null,null,null,null,""]
["526",null,null,null,null,""]
["527",null,null,null,null,""]
["528",null,null,null,null,""]
["529",null,null,null,null,""]
["530",null,null,null,null,""]
["531",null,null,null,null,""]
["532",null,null,null,null,""]
["533",null,null,null,null,""]
["534",null,null,null,null,""]
["535",null,null,null,null,""]
["536",null,null,null,null,""]
["537",null,null,null,null,""]
["538",null,null,null,null,""]
["539",null,null,null,null,""]
["540",null,null,null,null,""]
["541",null,null,null,null,""]
["542",null,null,null,null,""]
["543",null,null,null,null,""]
["544",null,null,null,null,""]
["545",null,null,null,null,""]
["546",null,null,null,null,""]
["547",null,null,null,null,""]
["548",null,null,null,null,""]
["549",null,null,null,null,""]
["550",null,null,null,null,""]
["551",null,null,null,null,""]
["552",null,null,null,null,""]
["553",null,null,null,null,""]
["554",null,null,null,null,""]
["555",null,null,null,null,""]
["556",null,null,null,null,""]
["557",null,null,null,null,""]
["558",null,null,null,null,""]
["559",null,null,null,null,""]
["560",null,null,null,null,""]
["561",null,null,null,null,""]
["562",null,null,null,null,""]
["563",null,null,null,null,""]
["564",null,null,null,null,""]
["565",null,null,null,null,""]
["566",null,null,null,null,""]
["567",null,null,null,null,""]
["568",null,null,null,null,""]
["569",null,null,null,null,""]
["570",null,null,null,null,""]
["571",null,null,null,null,""]
["572",null,null,null,null,""]
["573",null,null,null,null,""]
["574",null,null,null,null,""]
["575",null,null,null,null,""]
["576",null,null,null,null,""]
["577",null,null,null,null,""]
["578",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C588&\"'!\"&\"b36\"),\"\")","v":""}]
["579",null,null,null,null,""]
["580",null,null,null,null,""]
["581",null,null,null,null,""]
["582",null,null,null,null,""]
["583",null,null,null,null,""]
["584",null,null,null,null,""]
["585",null,null,null,null,""]
["586",null,null,null,null,""]
["587",null,null,null,null,""]
["588",null,null,null,null,""]
["589",null,null,null,null,""]
["590",null,null,null,null,""]
["591",null,null,null,null,""]
["592",null,null,null,null,""]
["593",null,null,null,null,""]
["594",null,null,null,null,""]
["595",null,null,null,null,""]
["596",null,null,null,null,""]
["597",null,null,null,null,""]
["598",null,null,null,null,""]
["599",null,null,null,null,""]
["600",null,null,null,null,""]
["601",null,null,null,null,""]
["602",null,null,null,null,""]
["603",null,null,null,null,""]
["604",null,null,null,null,""]
["605",null,null,null,null,""]
["606",null,null,null,null,""]
["607",null,null,null,null,""]
["608",null,null,null,null,""]
["609",null,null,null,null,""]
["610",null,null,null,null,""]
["611",null,null,null,null,""]
["612",null,null,null,null,""]
["613",null,null,null,null,""]
["614",null,null,null,null,""]
["615",null,null,null,null,""]
["616",null,null,null,null,""]
["617",null,null,null,null,""]
["618",null,null,null,null,""]
["619",null,null,null,null,""]
["620",null,null,null,null,""]
["621",null,null,null,null,""]
["622",null,null,null,null,""]
["623",null,null,null,null,""]
["624",null,null,null,null,""]
["625",null,null,null,null,""]
["626",null,null,null,null,""]
["627",null,null,null,null,""]
["628",null,null,null,null,""]
["629",null,null,null,null,""]
["630",null,null,null,null,""]
["631",null,null,null,null,""]
["632",null,null,null,null,""]
["633",null,null,null,null,""]
["634",null,null,null,null,""]
["635",null,null,null,null,""]
["636",null,null,null,null,""]
["637",null,null,null,null,""]
["638",null,null,null,null,""]
["639",null,null,null,null,""]
["640",null,null,null,null,""]
["641",null,null,null,null,""]
["642",null,null,null,null,{"$f":"IFERROR(INDIRECT(\"'\"&$C652&\"'!\"&\"b36\"),\"\")","v":""}]
["643",null,null,null,null,""]
["644",null,null,null,null,""]
["645",null,null,null,null,""]
["646",null,null,null,null,""]
["647",null,null,null,null,""]
["648",null,null,null,null,""]
["649",null,null,null,null,""]
["650",null,null,null,null,""]
["651",null,null,null,null,""]
["652",null,null,null,null,""]
["653",null,null,null,null,""]
["654",null,null,null,null,""]
["655",null,null,null,null,""]
["656",null,null,null,null,""]
["657",null,null,null,null,""]
["658",null,null,null,null,""]
["659",null,null,null,null,""]
["660",null,null,null,null,""]
["661",null,null,null,null,""]
["662",null,null,null,null,""]
["663",null,null,null,null,""]
["664",null,null,null,null,""]
["665",null,null,null,null,""]
["666",null,null,null,null,""]
["667",null,null,null,null,""]
["668",null,null,null,null,""]
["669",null,null,null,null,""]
["670",null,null,null,null,""]
["671",null,null,null,null,""]
["672",null,null,null,null,""]
["673",null,null,null,null,""]
["674",null,null,null,null,""]
["675",null,null,null,null,""]
["676",null,null,null,null,""]
["677",null,null,null,null,""]
["678",null,null,null,null,""]
["679",null,null,null,null,""]
["680",null,null,null,null,""]
["681",null,null,null,null,""]
["682",null,null,null,null,""]
["683",null,null,null,null,""]
["684",null,null,null,null,""]
["685",null,null,null,null,""]
["686",null,null,null,null,""]
["687",null,null,null,null,""]
["688",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]