{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["الصفحة الرئيسية","حساب قيمة العملية","المستلزمات","فتح الغرفة","الاقامة ","جهاز الاشعة"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":3,"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":"الصفحة الرئيسية","index":0,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,9,1,11],[2,7,2,9]]}
[]
[null,null,null,null,null,null,null,null,2018]
[null,null,null,null,null,null,null,"الصفحة الرئيسية",null,null,{"$f":"NOW()","v":43350.146967592591}]

{"sheet":"حساب قيمة العملية","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,0,9,1]]}
["البيان",null,"القيمة","مدة الإقامة"]
["قيمة المستلزمات ",null,{"$f":"IF(المستلزمات!$Q$38=0,\"\",المستلزمات!$Q$38)","v":""}]
["فتح غرفة العمليات",null,{"$f":"IFERROR(VLOOKUP(B3,'فتح الغرفة'!$A$5:$B$100,2,0),\"\")","v":""}]
["الاقامة ",null,{"$f":"IFERROR(VLOOKUP(B4,'الاقامة '!$B$6:$C$240,2,0)*D4,\"\")","v":""}]
["الإجمالى",null,{"$f":"IF(AND(C2=\"\",C3=\"\",C4=\"\"),\"\",SUM(C2:C4))","v":""}]
["14% ضريبة",null,{"$f":"IF(C5=\"\",\"\",C5*14%)","v":""}]
["الاجمالى بعد الضريبة",null,{"$f":"IF(AND(C5=\"\",C6=\"\"),\"\",C5+C6)","v":""}]
["الدمغة",null,{"$f":"IF(C7=\"\",\"\",IF($C$7<=1000,10,IF(AND($C$7>1000,$C$7<=1500),15,IF(AND($C$7>1500,$C$7<=2000),20,IF(AND($C$7>2000,$C$7<=2500),25,IF(AND($C$7>2500,$C$7<=3000),30,IF(AND($C$7>3000,$C$7<=3500),35,IF(AND($C$7>3500,$C$7<=4000),40,IF(AND($C$7>4000,$C$7<=4500),45,IF(AND($C$7>4500,$C$7<=5000),50,IF(AND($C$7>5000,$C$7<=5500),55,60)))))))))))","v":""}]
["جهاز الاشعة ",null,{"$f":"IFERROR(VLOOKUP(B9,'جهاز الاشعة'!$A$7:$B$110,2,0),\"\")","v":""}]
["الاجمالى الكلي ",null,{"$f":"IF($C$7=\"\",\"\",SUM(C7:C9))","v":""}]

{"sheet":"المستلزمات","index":2,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,2],[37,16,37,17]]}
[]
[]
[]
[]
["الصنف","عدد","السعر","القيمة","الصنف","عدد","السعر","القيمة","الصنف","عدد","السعر","القيمة","الصنف","عدد","السعر","القيمة"]
["كاب وماسك",null,3,{"$f":"B6*C6","v":0},"حقنة بلاستيك 3سم",null,1,{"$f":"F6*G6","v":0},"انترفال ",null,115,{"$f":"J6*K6","v":0},"محلول ملح",null,12,{"$f":"N6*O6","v":0}]
["قفازات جراحية",null,5,{"$f":"B7*C7","v":0},"حقنة بلاستيك 5سم",null,1,{"$f":"F7*G7","v":0},"ديبريفان",null,60,{"$f":"J7*K7","v":0},"رينجر",null,13,{"$f":"N7*O7","v":0}]
["ماكنتوش",null,4,0,"حقنة بلاستيك 10سم",null,1,0,"س.كولين",null,5,0,"بافيلون",null,10,0]
["بيتادين 100 سم",null,9,0,"حقنة بلاستيك 20سم",null,2,0,"بروستجمين سم",null,13,0,"تراكريام 25",null,20,0]
["كحول 100سم",null,3,0,"حقنة بلاستيك 50سم",null,3,0,"بروستجمين امبول",null,10,0,"سيفوبيد",null,51,0]
["سيدكس 1000 سم",null,4,0,"قسطرة نيلاتون ",null,2,0,"أتروبين",null,5,0,"جراميسين",null,6,0]
["جلايسين",null,39,0,"قسطرة فولى ",null,12,0,"ماركين فيال سم",null,1,0,"كانولا",null,4,0]
["محلول ملح",null,12,0,"قسطرة سيليكون",null,88,0,"ماركين أمبول         ",null,11,0,"جهاز وريد",null,4,0]
["ماء مقطر",null,28,0,"قسطرة حالب ",null,15,0,"زيلوكين",null,1,0,"انبوبة تخدير",null,14,0]
["ماء اكسجين",null,4,0,"انبوبة حرف T",null,6,0,"هالوثان",null,3.25,0,"ممر هوائي",null,6,0]
["ك يوجيل",null,7,0,"كيس بول",null,4,0,"ايزوفلورين",null,2,0,"ابرة بنج نصفى ",null,40,0]
["شاش 5*5",null,3,0,"دياثرمي",null,18,0,"غاز اكسجين",null,7,0,"ترايديل سم",null,2,0]
["شاش 10 * 10 ",null,4,0,"يد دياثرمي",null,18,0,"دورميكام",null,18,0,"سيفوبيد",null,51,0]
["فوطة بطن 30 * 30 ",null,6,0,"فاكريل ",null,25,0,"فنتاتيل",null,7,0,"سولباسيف",null,53,0]
["غيار دريسينج 1*1",null,1,0,"برولين ",null,14,0,"بثدين",null,2,0,null,null,null,0]
["غيار دريسينج 1*2",null,2,0,"كرومك",null,14,0,"مورفين ",null,1,0,null,null,null,0]
["غيار دريسينج 18*35",null,5,0,"خيط حرير",null,12,0,"بريمبران",null,3,0,null,null,null,0]
["رباط شاش صغير",null,5,0,"شاش 10*10 معقم",null,4,0,"سولوكورتيف",null,55,0,null,null,null,0]
["رباط شاش كبير",null,5,0,"مفرش سرير",null,6,0,"ديكادرون ",null,15,0,null,null,null,0]
["رباط ضاغط كبير 15سم",null,10,0,"ريدى فاك ( درنقة )",null,42,0,"ادرينالين",null,6,0,null,null,null,0]
["فارما بور 10*10",null,2,0,"رايل ",null,4,0,"لازكس 20 جم",null,6,0,null,null,null,0]
["فارما بور 10*15",null,3,0,"جوانتى فايروس",null,16,0,"سنتوسينون 10 وحدة",null,7,0,null,null,null,0]
["فارما بور 10*20",null,4,0,"شاش فازلين ( استرباد)",null,4,0,"مترجين",null,2,0,null,null,null,0]
["فارما بور 10*25",null,4,0,"وير عظام",null,25,0,"كيناكورت",null,10,0,null,null,null,0]
["فارما بور 10*30",null,5,0,"دباسة ",null,115,0,"امينوفللين",null,6,0,null,null,null,0]
["فارما بور 10*35",null,5,0,"صوف بان ( سبان )",null,8,0,"كالسيوم",null,6,0,null,null,null,0]
["بلاستر حرير بالمتر",null,6,0,"وصلة ثلاثية",null,5,0,"فولتارين",null,8,0,null,null,null,0]
["قطن 250 جم",null,20,0,null,null,null,0,"افدرين",null,5,0,null,null,null,0]
["مشرط",null,2,0,null,null,null,0,"فنتالين",null,7,0,null,null,null,0]
["بكرة حرير كاملة ",null,31,0,null,null,null,0,"نالوفين",null,7,0,null,null,null,0]
[null,null,null,0,null,null,null,0,"فورتاكورتين",null,5,0,null,null,null,0]
[]
["الإجمالى",null,null,{"$f":"SUM($D$6:$D$36)","v":0},null,null,null,{"$f":"SUM($H$6:$H$36)","v":0},null,null,null,{"$f":"SUM($L$6:$L$36)","v":0},null,null,null,{"$f":"SUM($P$6:$P$36)","v":0},{"$f":"D38+H38+L38+P38","v":0}]

{"sheet":"فتح الغرفة","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
["تصنيف العمليات ","فتح الغرفة العمليات"]
[]
[]
["عملية كشك ",130]
["عملية صغرى",200]
["عملية متوسطة",275]
["عملية كبرى",375]
["عملية ذات مهارة",440]
["عملية ذات طابغ خاص",715]

{"sheet":"الاقامة ","index":4,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"رقم الغرفة ","سعر الاقامة "]
[null,401,120]
[null,402,120]
[null,403,300]
[null,404,300]
[null,405,150]
[null,406,120]
[null,407,120]
[null,408,120]
[null,409,120]
[null,501,120]
[null,502,120]
[null,503,300]
[null,504,300]
[null,505,150]
[null,506,120]
[null,507,120]
[null,508,120]
[null,509,120]

{"sheet":"جهاز الاشعة","index":5,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
["عملية صغرى",190]
["عملية متوسطة",190]
["عملية كبرى",290]
["عملية ذات مهارة",350]
["عملية ذات طابع خاص",540]