{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["حاسبة القروض"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"حاسبة القروض","index":0,"n_rows":22,"n_cols":13,"rows_kept":22,"merged":[[1,1,1,3],[1,6,2,8],[1,11,2,12],[2,1,2,3],[6,5,6,6],[7,5,7,6],[10,2,10,5],[10,6,10,8],[10,9,10,12],[18,2,18,12]]}
[]
[null,"حاسبة",{"$nulls":4},{"v":50000,"d":"50000 ر.س.‏"},{"$nulls":4},"2011-05-10"]
[null,"قرض الكلية"]
[]
[null,"يقترح ألا يتجاوز إجمالي الأقساط الشهرية لقرض الطالب 8% من مرتبه في السنة الأولى."]
[]
[null,null,"القسط الشهري الحالي المركب هو:",null,null,{"$f":"CollegeLoans[[#Totals],[القسط الشهري الحالي]]","v":{"v":328.58590726058833,"d":"328.59 ر.س.‏"}},null,null,"القسط الشهري المجدول المركب هو:",{"$nulls":3},{"$f":"CollegeLoans[[#Totals],[القسط المجدول]]","v":{"v":328.58590726058833,"d":"328.59 ر.س.‏"}}]
[null,null,"نسبة الدخل الشهري:",null,null,{"$f":"CollegeLoans[[#Totals],[القسط الشهري الحالي]]/EstimatedMonthlySalary","v":{"v":0.07886061774254119,"d":"7.89%"}},null,null,"نسبة الدخل الشهري:",{"$nulls":3},{"$f":"CollegeLoans[[#Totals],[القسط المجدول]]/EstimatedMonthlySalary","v":{"v":0.07886061774254119,"d":"7.89%"}}]
[]
[]
[null,null,"التفاصيل العامة للقرض",{"$nulls":3},"بيانات تسديد القرض",null,null,"تفاصيل القسط"]
[null,null,"رقم القرض","المقرض","مبلغ القرض","معدل الفائدة السنوية","تاريخ البدء","المدة (سنة)","تاريخ الانتهاء","القسط الشهري الحالي","إجمالي الفائدة","القسط المجدول","القسط السنوي"]
[null,null,"10998M88","المقرض 1",{"v":10000,"d":"10000.00 ر.س.‏"},{"v":0.05,"d":"5.00%"},"2011-04-01",10,{"$f":"IF(AND(CollegeLoans[[#This Row],[تاريخ البدء]]>0,CollegeLoans[[#This Row],[المدة (سنة)]]>0),EDATE(CollegeLoans[[#This Row],[تاريخ البدء]],CollegeLoans[[#This Row],[المدة (سنة)]]*12),\"\")","v":"2021-04-01"},{"$f":"IF(AND(LoanStartLToday,COUNT(CollegeLoans[[#This Row],[مبلغ القرض]:[المدة (سنة)]])=4,CollegeLoans[[#This Row],[تاريخ البدء]]<TODAY()),PMT(CollegeLoans[[#This Row],[معدل الفائدة السنوية]]/12,CollegeLoans[[#This Row],[المدة (سنة)]]*12,-CollegeLoans[[#This Row],[مبلغ القرض]],0,0),\"\")","v":{"v":106.06551523907524,"d":"106.07 ر.س.‏"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[القسط المجدول]]*(CollegeLoans[[#This Row],[المدة (سنة)]]*12))-CollegeLoans[[#This Row],[مبلغ القرض]],\"\")","v":{"v":2727.8618286890287,"d":"2727.86 ر.س.‏"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[مبلغ القرض]:[المدة (سنة)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[معدل الفائدة السنوية]]/12,CollegeLoans[[#This Row],[المدة (سنة)]]*12,-CollegeLoans[[#This Row],[مبلغ القرض]],0,0))","v":{"v":106.06551523907524,"d":"106.07 ر.س.‏"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[القسط المجدول]]*12,\"\")","v":{"v":1272.7861828689029,"d":"1272.79 ر.س.‏"}}]
[null,null,"20987N87","المقرض 2",{"v":8000,"d":"8000.00 ر.س.‏"},{"v":0.05,"d":"5.00%"},"2011-05-01",10,{"$f":"IF(AND(CollegeLoans[[#This Row],[تاريخ البدء]]>0,CollegeLoans[[#This Row],[المدة (سنة)]]>0),EDATE(CollegeLoans[[#This Row],[تاريخ البدء]],CollegeLoans[[#This Row],[المدة (سنة)]]*12),\"\")","v":"2021-05-01"},{"$f":"IF(AND(LoanStartLToday,COUNT(CollegeLoans[[#This Row],[مبلغ القرض]:[المدة (سنة)]])=4,CollegeLoans[[#This Row],[تاريخ البدء]]<TODAY()),PMT(CollegeLoans[[#This Row],[معدل الفائدة السنوية]]/12,CollegeLoans[[#This Row],[المدة (سنة)]]*12,-CollegeLoans[[#This Row],[مبلغ القرض]],0,0),\"\")","v":{"v":84.85241219126019,"d":"84.85 ر.س.‏"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[القسط المجدول]]*(CollegeLoans[[#This Row],[المدة (سنة)]]*12))-CollegeLoans[[#This Row],[مبلغ القرض]],\"\")","v":{"v":2182.289462951223,"d":"2182.29 ر.س.‏"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[مبلغ القرض]:[المدة (سنة)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[معدل الفائدة السنوية]]/12,CollegeLoans[[#This Row],[المدة (سنة)]]*12,-CollegeLoans[[#This Row],[مبلغ القرض]],0,0))","v":{"v":84.85241219126019,"d":"84.85 ر.س.‏"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[القسط المجدول]]*12,\"\")","v":{"v":1018.2289462951222,"d":"1018.23 ر.س.‏"}}]
[null,null,"36785LM","المقرض 3",{"v":6000,"d":"6000.00 ر.س.‏"},{"v":0.045,"d":"4.50%"},"2012-03-01",10,{"$f":"IF(AND(CollegeLoans[[#This Row],[تاريخ البدء]]>0,CollegeLoans[[#This Row],[المدة (سنة)]]>0),EDATE(CollegeLoans[[#This Row],[تاريخ البدء]],CollegeLoans[[#This Row],[المدة (سنة)]]*12),\"\")","v":"2022-03-01"},{"$f":"IF(AND(LoanStartLToday,COUNT(CollegeLoans[[#This Row],[مبلغ القرض]:[المدة (سنة)]])=4,CollegeLoans[[#This Row],[تاريخ البدء]]<TODAY()),PMT(CollegeLoans[[#This Row],[معدل الفائدة السنوية]]/12,CollegeLoans[[#This Row],[المدة (سنة)]]*12,-CollegeLoans[[#This Row],[مبلغ القرض]],0,0),\"\")","v":{"v":62.18304525420918,"d":"62.18 ر.س.‏"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[القسط المجدول]]*(CollegeLoans[[#This Row],[المدة (سنة)]]*12))-CollegeLoans[[#This Row],[مبلغ القرض]],\"\")","v":{"v":1461.9654305051017,"d":"1461.97 ر.س.‏"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[مبلغ القرض]:[المدة (سنة)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[معدل الفائدة السنوية]]/12,CollegeLoans[[#This Row],[المدة (سنة)]]*12,-CollegeLoans[[#This Row],[مبلغ القرض]],0,0))","v":{"v":62.18304525420918,"d":"62.18 ر.س.‏"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[القسط المجدول]]*12,\"\")","v":{"v":746.1965430505102,"d":"746.20 ر.س.‏"}}]
[null,null,"765R43","المقرض 4",{"v":4000,"d":"4000.00 ر.س.‏"},{"v":0.05,"d":"5.00%"},"2012-05-01",5,{"$f":"IF(AND(CollegeLoans[[#This Row],[تاريخ البدء]]>0,CollegeLoans[[#This Row],[المدة (سنة)]]>0),EDATE(CollegeLoans[[#This Row],[تاريخ البدء]],CollegeLoans[[#This Row],[المدة (سنة)]]*12),\"\")","v":"2017-05-01"},{"$f":"IF(AND(LoanStartLToday,COUNT(CollegeLoans[[#This Row],[مبلغ القرض]:[المدة (سنة)]])=4,CollegeLoans[[#This Row],[تاريخ البدء]]<TODAY()),PMT(CollegeLoans[[#This Row],[معدل الفائدة السنوية]]/12,CollegeLoans[[#This Row],[المدة (سنة)]]*12,-CollegeLoans[[#This Row],[مبلغ القرض]],0,0),\"\")","v":{"v":75.48493457604374,"d":"75.48 ر.س.‏"}},{"$f":"IFERROR((CollegeLoans[[#This Row],[القسط المجدول]]*(CollegeLoans[[#This Row],[المدة (سنة)]]*12))-CollegeLoans[[#This Row],[مبلغ القرض]],\"\")","v":{"v":529.0960745626244,"d":"529.10 ر.س.‏"}},{"$f":"IF(COUNTA(CollegeLoans[[#This Row],[مبلغ القرض]:[المدة (سنة)]])<>4,\"\",PMT(CollegeLoans[[#This Row],[معدل الفائدة السنوية]]/12,CollegeLoans[[#This Row],[المدة (سنة)]]*12,-CollegeLoans[[#This Row],[مبلغ القرض]],0,0))","v":{"v":75.48493457604374,"d":"75.48 ر.س.‏"}},{"$f":"IFERROR(CollegeLoans[[#This Row],[القسط المجدول]]*12,\"\")","v":{"v":905.8192149125249,"d":"905.82 ر.س.‏"}}]
[null,null,"الإجماليات",null,{"$f":"SUBTOTAL(109,CollegeLoans[مبلغ القرض])","v":{"v":28000,"d":"28000.00 ر.س.‏"}},{"$nulls":4},{"$f":"SUBTOTAL(109,CollegeLoans[القسط الشهري الحالي])","v":{"v":328.58590726058833,"d":"328.59 ر.س.‏"}},{"$f":"SUBTOTAL(109,CollegeLoans[إجمالي الفائدة])","v":{"v":6901.212796707978,"d":"6901.21 ر.س.‏"}},{"$f":"SUBTOTAL(109,CollegeLoans[القسط المجدول])","v":{"v":328.58590726058833,"d":"328.59 ر.س.‏"}},{"$f":"SUBTOTAL(109,CollegeLoans[القسط السنوي])","v":{"v":3943.03088712706,"d":"3943.03 ر.س.‏"}}]
[null,null,"المتوسطات",null,{"$f":"AVERAGE(CollegeLoans[مبلغ القرض])","v":{"v":7000,"d":"7000.00 ر.س.‏"}},{"$f":"AVERAGE(CollegeLoans[معدل الفائدة السنوية])","v":{"v":0.04875,"d":"4.88%"}},{"$nulls":4},{"$f":"AVERAGE(CollegeLoans[إجمالي الفائدة])","v":{"v":1725.3031991769944,"d":"1725.30 ر.س.‏"}},null,{"$f":"AVERAGE(CollegeLoans[القسط السنوي])","v":{"v":985.757721781765,"d":"985.76 ر.س.‏"}}]
[]
[{"$nulls":10},"إجمالي الأقساط المدمجة لسداد القرض:",null,{"$f":"CollegeLoans[[#Totals],[مبلغ القرض]]+CollegeLoans[[#Totals],[إجمالي الفائدة]]","v":{"v":34901.21279670798,"d":"34901.21 ر.س.‏"}}]
[]
[{"$nulls":10},"الدخل الشهري المقدر بعد التخرج:",null,{"$f":"(EstimatedAnnualSalary/12)","v":{"v":4166.666666666667,"d":"4166.67 ر.س.‏"}}]