{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sheet2","Sheet1","Sheet4","Sheet3","Sheet6","Sheet7","Sheet8","Sheet5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Sheet2","index":0,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"بيان بفرق سعر الصرف المطلوب صرفة لشركة بي بي "]
[]
[null,null,"بيان ","المبلغ بالدولار ","سعر الصرف","المعادل بالمصري "]
[null,1,"المبلغ بسعر الصرف المطلوب صرفة ",28224493.48,18.149999999999999,{"$f":"D4*E4","v":512274556.66199994}]
[null,2,"المبلغ بسعر الصرف الذي تم",28224493.48,15.85,{"$f":"D5*E5","v":447358221.65799999}]
[null,null,"الفرق الواجب سدادة لشركة بي بي",{"$f":"F6/E6","v":3576657.5759779587},18.149999999999999,{"$f":"F4-F5","v":64916335.003999949}]
[]
[null,null,null,24647835.899999999,18.149999999999999,{"$f":"D8*E8","v":447358221.58499992}]
[null,null,null,3576647.58]
[]
[null,null,null,null,null,100]
[null,null,null,4703054537.6800003,2916585.43,{"$f":"E12/D12*100","v":6.2014705690373331E-2}]
[null,null,null,null,null,{"$f":"F11-F12","v":99.937985294309627}]
[]
[]
[]
[]
[null,null,100,{"$f":"SUM($C$18:C18)","v":100},360,590.54999999999995]
[null,null,200,{"$f":"SUM($C$18:C19)","v":300},460,454.65]
[null,null,300,{"$f":"SUM($C$18:C20)","v":600},70,208.65]
[null,null,500,{"$f":"SUM($C$18:C21)","v":1100},50,73.55]
[null,null,400,{"$f":"SUM($C$18:C22)","v":1500},100,93.1]
[null,null,150,{"$f":"SUM($C$18:C23)","v":1650},{"$f":"3*180","v":540},37.549999999999997]
[null,null,200,{"$f":"SUM($C$18:C24)","v":1850},{"$f":"3*165","v":495},15.55]
[null,null,150,{"$f":"SUM($C$18:C25)","v":2000},240,31.1]
[null,null,250,{"$f":"SUM($C$18:C26)","v":2250},{"$f":"SUM(E18:E25)","v":2315},53.1]
[null,null,500,{"$f":"SUM($C$18:C27)","v":2750},null,147.1]
[null,null,null,{"$f":"SUM($C$18:C28)","v":2750},null,{"$f":"SUM(F18:F27)","v":1704.8999999999994}]
[null,null,null,{"$f":"SUM($C$18:C29)","v":2750},null,204.58]
[null,null,null,{"$f":"SUM($C$18:C30)","v":2750}]
[null,null,null,{"$f":"SUM($C$18:C31)","v":2750}]

{"sheet":"Sheet1","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"ايرادات انتاج حقول",4110000002,"مصروفات الاتاوه المستحقه على الحقول",3360000003]
[null,null,"ايراد فائض الإسترداد النقدى ",4110000003,"ضريبة الشريك الأجنبى",3360000005]
[null,null,"ايرادات منح توقيع وتنميه وتدريب",4200000002,"مشتريات انتاج",3101000001]
[null,null,"ايرادات منح انتاج",4200000003,"مصروفات استرداد",3101000002]
[null,null,null,null,"مشتريات اتول",3101000003]
[]
[]
[null,null,"مبيعات تصدير غازمسال",4110000001,"مصروفات غاز تشغيل لدى الغير تصدير",3312000002]
[]
[null,null,125752.14]
[null,null,-193933.42]
[null,null,-107803.06]
[null,null,175872]

{"sheet":"Sheet4","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["المبلغ المسدد لصالح IPR  من الهيئة "]
[null,null,null,"الفاتورة ","المسدد","المتبقي"]
["2023-02-01","غاز طبيعى","2023-04-24",388287.17,{"$f":"D3","v":388287.17},{"$f":"D3-E3","v":0}]
["2023-02-01","غاز طبيعى","2023-04-24",125851.86,{"$f":"D4","v":125851.86},{"$f":"D4-E4","v":0}]
["2023-03-01","غاز طبيعى","2023-05-24",554881.26,{"$f":"D5","v":554881.26},0]
["ابريل2023","غاز طبيعى","2023-06-26",548862.42000000004,538293.56000000006,10568.859999999986]
["2023-02-01","متكثفات ","2023-04-10",92820.15,{"$f":"D7","v":92820.15},0]
["2023-02-01","متكثفات ","2023-04-10",29399.06,{"$f":"D8","v":29399.06},0]
["2023-03-01","متكثفات ","2023-05-09",137904.24,{"$f":"D9","v":137904.24},0]
["فروقQ4 2021 ، Q1,Q2,Q3 2022","متكثفات ","2023-05-16",10224.11,{"$f":"D10","v":10224.11},0]
["ابريل2023","متكثفات ","2023-06-12",143374.68,{"$f":"D11","v":143374.68},0]
[null,null,null,null,{"$f":"SUM(E3:E11)","v":2021036.09}]

{"sheet":"Sheet3","index":3,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,3],[4,0,4,2]]}
["تفاصيل سداد مبلغ ال 31 مليون دولار لشركة BP "]
["الحقل ","فاتورة ","إجمالي مبلغ الفاتورة ","المسدد من الفاتورة "]
["أتول ","2023-03-03",31167168.510000002,27850185.469999999]
["القطامية ","2023-03-03",3149814.53,{"$f":"C4","v":3149814.53}]
["الإجمالي ",null,null,{"$f":"D3+D4","v":31000000}]
[]
[]
[]
[]
[]
[null,null,3021570]
[null,0.75,2266177.5]
[null,null,{"$f":"C11-C12","v":755392.5},14284472.18]
[null,null,null,{"$f":"D13/C13","v":18.910000006619075}]
[]
[]
[null,"جنيه "]
[null,8662500,15.6,{"$f":"B18/C18","v":555288.4615384615}]
[null,null,null,90750]
[null,null,null,{"$f":"SUM(D18:D19)","v":646038.4615384615}]
[]
[null,8662500,30.03,{"$f":"B22/C22","v":288461.53846153844}]
[null,null,null,90750]
[null,null,null,{"$f":"SUM(D22:D23)","v":379211.53846153844}]
[]
[null,null,null,{"$f":"D20-D24","v":266826.92307692306}]

{"sheet":"Sheet6","index":4,"n_rows":33,"n_cols":1,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[1800000650]
[1800000674]
[1800000559]
[1800000534]
[1800000560]
[1800000651]
[1800000675]
[1800000558]
[1800000536]
[1800000557]
[1800000654]
[1800000554]
[1800000652]
[1800000676]
[1800000592]
[1800000653]
[1800000679]
[1800000555]
[1800000655]
[1800000656]
[1800000678]
[1800000548]
[1800000549]
[1800000659]
[1800000677]
[1800000540]
[1800000658]
[1800000671]
[1800000657]
[1800000680]
[1800000680]
[1800000551]
[1800000561]

{"sheet":"Sheet7","index":5,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,10000000]
[9200000]
[]
[null,1000000]
[null,5800000]
[null,2400000]
[]
[null,{"$f":"SUM(B4:B8)","v":9200000}]
[]
[]
[]
[null,null,null,"623,051.66-"]
[null,null,null,"718,804.20-"]
[null,null,null," 93,676.13-"]
[null,null,null,"600,980.88-"]

{"sheet":"Sheet8","index":6,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[-35144.58]
[-1851296.85]
[-78079.509999999995]
[-259269.54]
[-2099382.1]
[-19332.419999999998]
[-103340.43]
[-163775.13]
[-83649.39]
[-16012.64]
[-213584.04]
[-12437.88]
[-121939.27]
[-108332.61]
[{"$f":"SUM(A1:A14)","v":-5165576.3899999987}]

{"sheet":"Sheet5","index":7,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[45000000,null,"Doc No","Doc Date"]
[null,20000000,1900001494,"2023-10-01"]
[null,9000000,1900001557,"2023-10-04"]
[null,8000000,1900002148,"2023-10-29"]
[null,8000000,1900002621,"2023-11-28"]
[null,{"$f":"SUM(B2:B5)","v":45000000}]