def test_gorr_royalty(self):
pr = ProcessRoyalties()
leaserm = DataStructure()
calc = DataStructure()
monthly = DataStructure()
well_lease_link = DataStructure()
rtp_info = DataStructure()
monthly.ProdVol = 100.0
monthly.ProdHours = 10.0
monthly.TransRate = 0.1234
leaserm.TransDeducted = "All"
leaserm.Gorr = "fixed,0,.02"
well_lease_link.PEFNInterest = 1.0
rtp_info.Percent = 100.0
calc.RoyaltyPrice = 200.0
calc.TransGorralue = 0.0
calc.GorrRoyaltyValue = 0.0
calc.TransGorrValue = 0.0
pr.calc_gorr(leaserm, calc, monthly, well_lease_link, rtp_info)
self.assertEqual(400.0, calc.GorrRoyaltyValue)
self.assertEqual(0.25, calc.TransGorrValue)
monthly.ProdVol = 100.0
rtp_info.Percent = 50.0
calc.TransGorrValue = 0.0
pr.calc_gorr(leaserm, calc, monthly, well_lease_link, rtp_info)
self.assertEqual(200.0, calc.GorrRoyaltyValue)
self.assertEqual(0.12, calc.TransGorrValue)
def test_calc_sask_oil_prov_crown_deductions(self):
pr = ProcessRoyalties()
calc = DataStructure()
calc.TransBaseValue = 0
calc.BaseRoyaltyRate = 0.1
m = DataStructure()
m.TransRate = 0.123
m.ProdVol = 150.0
lease_royalty_master = DataStructure()
lease_royalty_master.TransDeducted = "All"
lease_royalty_master.CrownMultiplier = 1.0
fn_interest = 1.0
rp_interest = 100.0
# Note: this is a round even situation... it's questionable
self.assertEqual(
1.84, pr.calc_sask_oil_prov_crown_deductions(m, fn_interest, rp_interest, lease_royalty_master, calc)
)
lease_royalty_master.CrownMultiplier = 0.9
fn_interest = 0.8
rp_interest = 90.0
self.assertEqual(
1.2, pr.calc_sask_oil_prov_crown_deductions(m, fn_interest, rp_interest, lease_royalty_master, calc)
)
def test_calc_sask_oil_iogr_subsection2(self):
pr = ProcessRoyalties()
self.assertEqual(pr.calc_sask_oil_iogr_subsection2(70), 7)
self.assertEqual(pr.calc_sask_oil_iogr_subsection2(100), 12)
self.assertEqual(pr.calc_sask_oil_iogr_subsection2(170), 26.6)
self.assertEqual(pr.calc_sask_oil_iogr_subsection2(200), (24 + 0.26 * (200 - 160)))
self.assertEqual(pr.calc_sask_oil_iogr_subsection2(2000), (round(24 + 0.26 * (2000 - 160), 6)))
def calculate():
from src.calc.calcroyalties import ProcessRoyalties
pr = ProcessRoyalties()
print("We are in the calculate thing..... for ", request.args)
db = config.get_database()
for monthly in db.select('Monthly',
ExtractDate=int(request.args.get('ExtractDate')),
ProdMonth=int(request.args.get('ProdMonth')),
Entity=request.args.get('Entity'),
EntityId=int(request.args.get('EntityID'))):
try:
print("about to calculate...")
pr.process_one(monthly.ExtractDate, monthly.Entity,
monthly.EntityID, monthly.ProdMonth,
monthly.Product)
except Exception as e:
print("We have an error")
traceback.print_exc(file=sys.stdout)
tb = traceback.format_exc()
return "<h2>Error displaying worksheet for " + monthly.Entity + " %s</h2><br>" % monthly.EntityID + \
str(e) + '<plaintext>' + \
tb + '</plaintext>'
# print(e)
# return 'Something went wrong during calculation for %s, %s, %i, %s:<br />%s' % \
# (monthly.Entity, monthly.EntityID, monthly.ProdMonth, monthly.Product, str(e))
return "Processing complete."
def test_calc_sask_oil_iogr_subsection3(self):
pr = ProcessRoyalties()
self.assertEqual(pr.calc_sask_oil_iogr_subsection3(79.9), 7.99)
self.assertEqual(pr.calc_sask_oil_iogr_subsection3(150), 22)
self.assertEqual(pr.calc_sask_oil_iogr_subsection3(500), 112.4)
self.assertEqual(pr.calc_sask_oil_iogr_subsection3(800), 191)
self.assertEqual(pr.calc_sask_oil_iogr_subsection3(200), 24 + 0.26 * (200 - 160))
self.assertEqual(pr.calc_sask_oil_iogr_subsection3(2000), 189 + 0.4 * (2000 - 795))
def calculate():
from src.calc.calcroyalties import ProcessRoyalties
pr = ProcessRoyalties()
well_id = int(request.args.get('WellId'))
try:
pr.process_one(well_id, get_proddate_int(), 'Oil')
return 'Calculation successful for %s, %i, %s' % (well_id, get_proddate_int(), 'Oil')
except Exception as e:
print(e)
return 'Something went wrong during calculation for %s, %i, %s:<br />%s' % \
(well_id, get_proddate_int(), 'Oil', str(e))
def test_determine_commencement_period(self):
pr = ProcessRoyalties()
self.assertEqual(pr.determine_commencement_period(201501, date(2014, 12, 1)), 0.08)
self.assertEqual(pr.determine_commencement_period(201501, date(2014, 12, 31)), 0)
self.assertEqual(pr.determine_commencement_period(201501, date(2014, 1, 1)), 1)
self.assertEqual(pr.determine_commencement_period(201501, date(2010, 11, 30)), 4.09)
self.assertEqual(pr.determine_commencement_period(201501, date(2010, 1, 1)), 5)
self.assertEqual(pr.determine_commencement_period(201501, date(2010, 1, 31)), 4.92)
self.assertEqual(pr.determine_commencement_period(201501, date(2010, 1, 1)), 5.0)
self.assertEqual(pr.determine_commencement_period(None, None), 5)
self.assertEqual(pr.determine_commencement_period(201501, datetime(2003, 1, 1)), 12.01)
return
def test_determineRoyaltyPrice(self):
m = DataStructure()
m.SalesPrice = 221.123456
m.TransRate = 2.123455
m.ProcessingRate = 0.123455
pr = ProcessRoyalties()
self.assertAlmostEqual(pr.determine_royalty_price("ActSales", m), 221.123456)
m.WellHeadPrice = 225
m.TransRate = 3
m.ProcessingRate = 1
self.assertAlmostEqual(pr.determine_royalty_price("ActSales", m), 221.123456)
def test_determineCommencementPeriod(self):
pr = ProcessRoyalties()
self.assertEqual(pr.determine_commencement_period(201501, datetime(2015, 1, 1)), 0)
self.assertEqual(pr.determine_commencement_period(201501, datetime(2014, 12, 1)), 0.08)
self.assertEqual(pr.determine_commencement_period(201501, datetime(2014, 11, 15)), 0.13)
self.assertEqual(pr.determine_commencement_period(201501, datetime(2014, 1, 1)), 1)
self.assertEqual(pr.determine_commencement_period(201501, datetime(2014, 1, 1)), 1)
self.assertEqual(pr.determine_commencement_period(201501, datetime(2010, 1, 1)), 5)
self.assertEqual(pr.determine_commencement_period(201501, datetime(2009, 12, 1)), 5.09)
self.assertEqual(pr.determine_commencement_period(201501, None), 5)
def test_process_monthly(self):
db = config.get_database()
dbu = DatabaseUtilities()
dbu.delete_all_tables()
dbu.create_some_test_well_royalty_masters()
dbu.create_some_test_lease_royalty_masters()
dbu.create_some_test_leases()
dbu.create_some_test_well_lease_link()
dbu.create_some_test_monthly()
dbu.create_some_test_econdata()
dbu.create_some_test_rtp_info()
dbu.create_calc()
pr = ProcessRoyalties()
pr.process_one(4, 201501, "OIL")
# Check to see if the oper record exists
self.assertEqual(2, db.count("calc"))
pr.process_all()
self.assertEqual(3, db.count("calc"))
def test_calcSupplementaryRoyaltiesIOGR1995(self):
reference_price = {
"Pigeon Lake Indian": 24.04,
"Reserve no.138A": 25.37,
"Sawridge Indian": 25.13,
"Stony Plain Indian": 24.64,
}
pr = ProcessRoyalties()
# calc = DataStructure()
self.assertEqual(
pr.calc_supplementary_royalties_iogr1995(3.5, 228, 80, 60, reference_price["Pigeon Lake Indian"]), 2039.6
)
self.assertEqual(
pr.calc_supplementary_royalties_iogr1995(5, 200, 90, 40, reference_price["Reserve no.138A"]), 4365.75
)
self.assertEqual(
pr.calc_supplementary_royalties_iogr1995(4, 221.123456, 100, 50, reference_price["Sawridge Indian"]),
4899.84,
)
self.assertEqual(
pr.calc_supplementary_royalties_iogr1995(0.2, 180, 80, 35, reference_price["Stony Plain Indian"]), 3495.6
)
self.assertEqual(
pr.calc_supplementary_royalties_iogr1995(6, 228, 80, 60, reference_price["Pigeon Lake Indian"]), 2996.5
)
self.assertEqual(
pr.calc_supplementary_royalties_iogr1995(5.5, 200, 90, 40, reference_price["Reserve no.138A"]), 6391.38
)
self.assertEqual(
pr.calc_supplementary_royalties_iogr1995(8, 221.123456, 100, 50, reference_price["Sawridge Indian"]), 7192.5
)
self.assertEqual(
pr.calc_supplementary_royalties_iogr1995(15, 180, 80, 35, reference_price["Stony Plain Indian"]), 5101.88
)
def test_calc_royalties(self):
dbu = DatabaseUtilities()
dbu.delete_all_tables()
dbu.create_some_test_econdata()
pr = ProcessRoyalties()
well = DataStructure()
royalty = DataStructure()
calc = DataStructure()
monthly = DataStructure()
well_lease_link = DataStructure()
rtp_info = DataStructure()
monthly.Product = "OIL"
monthly.ProdMonth = 201501
monthly.ProdVol = 100
monthly.ProdHours = 744
monthly.SalesPrice = 210.0
royalty.RoyaltyScheme = "SKProvCrownVar"
royalty.OverrideRoyaltyClassification = None
royalty.ValuationMethod = "ActSales"
royalty.CrownModifier = None
royalty.MinRoyaltyRate = None
royalty.CrownMultiplier = 1.0
royalty.MinRoyaltyDollar = None
royalty.TransDeducted = None
well.CommencementDate = date(2015, 1, 22)
well.RoyaltyClassification = "Old Oil"
well.Classification = "Other"
well.SRC = 0.0
well_lease_link.PEFNInterest = 1.0
rtp_info.Percent = 100.0
calc.SuppRoyaltyValue = 0.0
calc.GorrRoyaltyValue = 0.0
calc.TransGorrValue = 0.0
pr.calc_royalties(well, royalty, calc, monthly, well_lease_link, rtp_info)
royalty.RoyaltyScheme = "IOGR1995"
pr.calc_royalties(well, royalty, calc, monthly, well_lease_link, rtp_info)
royalty.RoyaltyScheme = "IOGR1995,GORR"
royalty.Gorr = "fixed,0,.02"
pr.calc_royalties(well, royalty, calc, monthly, well_lease_link, rtp_info)
def test_calcSaskOilIOGR1995(self):
m = DataStructure()
# m.WellHeadPrice = 221.123456
m.SalesPrice = 221.123456
m.TransRate = 2.123455
m.ProcessingRate = 0.123455
m.ProdVol = 70
m.ProdMonth = 201501
calc = DataStructure()
calc.BaseRoyaltyValue = 0.0
calc.CommencementPeriod = 0
calc.BaseRoyaltyVolume = 0.0
calc.RoyaltyPrice = 0.0
crown_multiplier = 1.2
fn_interest = 0.25
rp_interest = 100
pr = ProcessRoyalties()
# all tests for SaskWellHead
pr.calc_sask_oil_iogr1995(
datetime(2015, 1, 1), "SaskWellHead", crown_multiplier, fn_interest, rp_interest, m, calc
)
self.assertEqual(464.36, calc.BaseRoyaltyValue)
self.assertEqual(calc.CommencementPeriod, 0)
self.assertEqual(calc.BaseRoyaltyVolume, 7)
self.assertEqual(calc.RoyaltyPrice, 221.123456)
m.ProdVol = 100
crown_multiplier = 0.25
fn_interest = 3
rp_interest = 100
pr.calc_sask_oil_iogr1995(
datetime(2015, 4, 2), "SaskWellHead", crown_multiplier, fn_interest, rp_interest, m, calc
)
self.assertEqual(calc.BaseRoyaltyValue, 1990.11)
m.ProdVol = 170
crown_multiplier = 1.0
fn_interest = 1
rp_interest = 100
pr.calc_sask_oil_iogr1995(
datetime(2015, 5, 1), "SaskWellHead", crown_multiplier, fn_interest, rp_interest, m, calc
)
self.assertEqual(calc.BaseRoyaltyValue, 5881.88)
m.ProdVol = 79.9
crown_multiplier = 3
fn_interest = 2
rp_interest = 100
pr.calc_sask_oil_iogr1995(
datetime(2010, 1, 1), "SaskWellHead", crown_multiplier, fn_interest, rp_interest, m, calc
)
self.assertEqual(calc.BaseRoyaltyValue, 10600.66)
m.ProdVol = 150
crown_multiplier = 2
fn_interest = 4
rp_interest = 100
pr.calc_sask_oil_iogr1995(
datetime(2009, 7, 3), "SaskWellHead", crown_multiplier, fn_interest, rp_interest, m, calc
)
self.assertEqual(calc.BaseRoyaltyValue, 38917.73)
m.ProdVol = 500
crown_multiplier = 1
fn_interest = 5
rp_interest = 100
pr.calc_sask_oil_iogr1995(
datetime(2007, 8, 2), "SaskWellHead", crown_multiplier, fn_interest, rp_interest, m, calc
)
self.assertEqual(calc.BaseRoyaltyValue, 124271.38)
m.ProdVol = 800
crown_multiplier = 5
fn_interest = 0.1
rp_interest = 100
pr.calc_sask_oil_iogr1995(
datetime(2008, 9, 9), "SaskWellHead", crown_multiplier, fn_interest, rp_interest, m, calc
)
self.assertEqual(calc.BaseRoyaltyValue, 21117.29)
m.ProdVol = 800
crown_multiplier = 5
fn_interest = 0.1
rp_interest = 50
pr.calc_sask_oil_iogr1995(
datetime(2008, 9, 9), "SaskWellHead", crown_multiplier, fn_interest, rp_interest, m, calc
)
self.assertEqual(calc.BaseRoyaltyValue, 10558.65)
def test_calcGorrPercent(self):
pr = ProcessRoyalties()
gorr = "bad string,0,2"
self.assertRaises(AppError, pr.calc_gorr_percent, 400, 10, gorr)
self.assertRaises(AppError, pr.calc_gorr_percent, None, 10, gorr)
gorr = None, "0,2"
self.assertRaises(AttributeError, pr.calc_gorr_percent, 400, 10, gorr)
gorr = "dprod,250,.02,300,.03,400,.04,500,.05,0,.06"
self.assertEqual(
pr.calc_gorr_percent(600, 10, gorr),
(0.02, "dprod = mprod / 30.5 days; 19.67 is > 0.0 and <= 250.0 for a RoyRate of 2.00%"),
)
self.assertEqual(
pr.calc_gorr_percent(8235, 3, gorr),
(0.03, "dprod = mprod / 30.5 days; 270.00 is > 250.0 and <= 300.0 for a RoyRate of 3.00%"),
)
self.assertEqual(
pr.calc_gorr_percent(10065, 4, gorr),
(0.04, "dprod = mprod / 30.5 days; 330.00 is > 300.0 and <= 400.0 for a RoyRate of 4.00%"),
)
self.assertEqual(
pr.calc_gorr_percent(13725, 5, gorr),
(0.05, "dprod = mprod / 30.5 days; 450.00 is > 400.0 and <= 500.0 for a RoyRate of 5.00%"),
)
self.assertRaises(TypeError, pr.calc_gorr_percent, None, 10, gorr)
gorr = "mprod,250,.02,300,.03,400,.04,500,.05,0,.06"
self.assertEqual(
pr.calc_gorr_percent(200, 10, gorr), (0.02, "mprod = 200 is > 0.0 and <= 250.0 for a RoyRate of 2.00%")
)
self.assertEqual(
pr.calc_gorr_percent(300, 4, gorr), (0.03, "mprod = 300 is > 250.0 and <= 300.0 for a RoyRate of 3.00%")
)
self.assertEqual(
pr.calc_gorr_percent(350.6, 1, gorr), (0.04, "mprod = 350.6 is > 300.0 and <= 400.0 for a RoyRate of 4.00%")
)
self.assertEqual(
pr.calc_gorr_percent(410, 2, gorr), (0.05, "mprod = 410 is > 400.0 and <= 500.0 for a RoyRate of 5.00%")
)
self.assertEqual(
pr.calc_gorr_percent(10000, 17, gorr), (0.06, "mprod = 10000 is > 500.0 for a RoyRate of 6.00%")
)
gorr = "hprod,250,.02,300,.03,400,.04,500,.05,0,.06"
self.assertEqual(
pr.calc_gorr_percent(200, 10, gorr),
(0.02, "hprod = mprod / hours; 20.00 is > 0.0 and <= 250.0 for a RoyRate of 2.00%"),
)
gorr = "fixed,0,.02"
self.assertEqual(pr.calc_gorr_percent(200, 10, gorr), (0.02, "fixed for a RoyRate of 2.00%"))
self.assertEqual(pr.calc_gorr_percent(10000, 4, gorr), (0.02, "fixed for a RoyRate of 2.00%"))
self.assertEqual(pr.calc_gorr_percent(None, 10, gorr), (0.02, "fixed for a RoyRate of 2.00%"))
def test_calc_sask_oil_prov_crown_royalty_volume_value(self):
pr = ProcessRoyalties()
m = DataStructure()
m.ProdVol = 100
lease_rm = DataStructure()
lease_rm.MinRoyaltyRate = 0.0
lease_rm.MinRoyaltyDollar = 0.0
lease_rm.CrownMultiplier = 1
lease_rm.ValuationMethod = "ActSales"
lease_rm.CrownModifier = None
calc = DataStructure()
calc.BaseRoyaltyRate = 0.25
calc.BaseRoyaltyCalcRate = 0.25
calc.RoyaltyPrice = 210
calc.BaseRoyaltyVolume = 0.0
calc.BaseRoyaltyValue = 0.0
m.SalesPrice = 223.370366
m.TransRate = 2.123455
m.ProcessingRate = 0.123455
fn_interest = 1.0
rp_interest = 100.0
pr.calc_sask_oil_prov_crown_royalty_volume_value(m, fn_interest, rp_interest, lease_rm, calc)
self.assertEqual(calc.BaseRoyaltyVolume, 0.0)
self.assertEqual(calc.BaseRoyaltyValue, 5584.26)
calc.BaseRoyaltyCalcRate = -0.01
calc.BaseRoyaltyRate = -0.01
lease_rm.MinRoyaltyRate = None
pr.calc_sask_oil_prov_crown_royalty_volume_value(m, fn_interest, rp_interest, lease_rm, calc)
self.assertEqual(calc.BaseRoyaltyRate, 0)
calc.BaseRoyaltyCalcRate = -0.01
calc.BaseRoyaltyRate = -0.01
lease_rm.MinRoyaltyRate = 0.02
pr.calc_sask_oil_prov_crown_royalty_volume_value(m, fn_interest, rp_interest, lease_rm, calc)
self.assertEqual(calc.BaseRoyaltyRate, 0.02)
self.assertEqual(calc.BaseRoyaltyValue, 446.74)
lease_rm.MinRoyaltyDollar = 500.0
pr.calc_sask_oil_prov_crown_royalty_volume_value(m, fn_interest, rp_interest, lease_rm, calc)
self.assertEqual(calc.BaseRoyaltyValue, 500.0)
lease_rm.MinRoyaltyDollar = None
lease_rm.MinRoyaltyRate = None
calc.BaseRoyaltyCalcRate = 0.35
lease_rm.CrownModifier = 0.02
calc.BaseRoyaltyRate = None
pr.calc_sask_oil_prov_crown_royalty_volume_value(m, fn_interest, rp_interest, lease_rm, calc)
self.assertEqual(calc.BaseRoyaltyRate, 0.37)
# Reset to normal again
lease_rm.CrownModifier = 0.0
calc.BaseRoyaltyCalcRate = 0.25
calc.RoyaltyPrice = 210
calc.BaseRoyaltyVolume = 0.0
calc.BaseRoyaltyValue = 0.0
pr.calc_sask_oil_prov_crown_royalty_volume_value(m, fn_interest, rp_interest, lease_rm, calc)
self.assertEqual(calc.BaseRoyaltyVolume, 0.0)
self.assertEqual(calc.BaseRoyaltyValue, 5584.26)
m.ProdVol = 100
rp_interest = 50.0
pr.calc_sask_oil_prov_crown_royalty_volume_value(m, fn_interest, rp_interest, lease_rm, calc)
self.assertEqual(calc.BaseRoyaltyVolume, 0.0)
self.assertEqual(calc.BaseRoyaltyValue, 2792.13)
m.ProdVol = 100
rp_interest = 50.0
fn_interest = 0.5
pr.calc_sask_oil_prov_crown_royalty_volume_value(m, fn_interest, rp_interest, lease_rm, calc)
self.assertEqual(calc.BaseRoyaltyVolume, 0.0)
self.assertEqual(calc.BaseRoyaltyValue, 1396.06)
def process_royalties():
from src.calc.calcroyalties import ProcessRoyalties
pr = ProcessRoyalties()
pr.process_all()
def test_calcSaskGasBaseRoyaltyCalcRate(self):
econ_string_data = """
CharMonth,ProdMonth,G4T_C,G4T_D,G4T_K,G4T_X,G3T_C,G3T_K,G3T_X,GNEW_C,GNEW_K,GNEW_X,GOLD_C,GOLD_K,GOLD_X
Sept.,201509,0.1185,2.96,24.39,1578,0.1434,33.10,1910,0.1593,36.77,2121,0.2062,47.59,2745
"""
th = TestHelper()
econ_gas_data = DataStructure()
th.load_object_csv_style(econ_gas_data, econ_string_data)
pr = ProcessRoyalties()
royalty_calc = DataStructure()
self.assertEqual(
pr.calc_sask_gas_prov_crown_royalty_rate(royalty_calc, econ_gas_data, "Fourth Tier Gas", 0, 0, "GasWells"),
0,
)
self.assertEqual(
pr.calc_sask_gas_prov_crown_royalty_rate(royalty_calc, econ_gas_data, "Fourth Tier Gas", 30, 0, "GasWells"),
0.595,
)
self.assertEqual(
pr.calc_sask_gas_prov_crown_royalty_rate(
royalty_calc, econ_gas_data, "Fourth Tier Gas", 200, 0, "GasWells"
),
16.5,
)
self.assertEqual(
pr.calc_sask_gas_prov_crown_royalty_rate(royalty_calc, econ_gas_data, "Fourth Tier Gas", 0, 0, "OilWells"),
0,
)
self.assertEqual(
pr.calc_sask_gas_prov_crown_royalty_rate(
royalty_calc, econ_gas_data, "Fourth Tier Gas", 220, 0, "OilWells"
),
17.217273,
)
self.assertEqual(
pr.calc_sask_gas_prov_crown_royalty_rate(royalty_calc, econ_gas_data, "Third Tier Gas", 100, 0.75, None),
13.59,
)
self.assertEqual(
pr.calc_sask_gas_prov_crown_royalty_rate(royalty_calc, econ_gas_data, "Third Tier Gas", 200, 1, None), 22.55
)
self.assertEqual(
pr.calc_sask_gas_prov_crown_royalty_rate(royalty_calc, econ_gas_data, "New Gas", 50, 2.25, None), 5.715
)
self.assertEqual(
pr.calc_sask_gas_prov_crown_royalty_rate(royalty_calc, econ_gas_data, "New Gas", 130, 0.75, None), 19.704615
)
self.assertEqual(
pr.calc_sask_gas_prov_crown_royalty_rate(royalty_calc, econ_gas_data, "Old Gas", 20, 1, None), 3.124
)
self.assertEqual(
pr.calc_sask_gas_prov_crown_royalty_rate(royalty_calc, econ_gas_data, "Old Gas", 150, 0.5, None), 28.79
)
self.assertRaises(
AppError,
pr.calc_sask_gas_prov_crown_royalty_rate,
royalty_calc,
econ_gas_data,
"Fourth Tier Gas",
20,
1,
"Bad String",
)
self.assertRaises(
AppError,
pr.calc_sask_gas_prov_crown_royalty_rate,
royalty_calc,
econ_gas_data,
"Bad String",
20,
1,
"GasWells",
)
def process_royalties():
pr = ProcessRoyalties()
pr.process_all()
def test_calcSaskOilBaseRoyaltyCalcRate(self):
econ_string_data = """
CharMonth,ProdMonth,HOP,SOP,NOP,H4T_C,H4T_D,H4T_K,H4T_X,H3T_K,H3T_X,HNEW_K,HNEW_X,SW4T_C,SW4T_D,SW4T_K,SW4T_X,SW3T_K,SW3T_X,SWNEW_K,SWNEW_X,O4T_C,O4T_D,O4T_K,O4T_X,O3T_K,O3T_X,ONEW_K,ONEW_X,OOLD_K,OOLD_X
Sept.,201509,162,210,276,0.0841,2.1,20.81,1561,20.46,472,26.48,611,0.1045,2.61,25.85,1939,31.57,729,38.54,890,0.1209,3.02,29.91,2243,36.08,833,40.79,941,52.61,1214
"""
# All this work so we don't need to read from the database. It's a way better test.
econ_oil_data = DataStructure()
th = TestHelper()
royalty_calc = DataStructure()
th.load_object_csv_style(econ_oil_data, econ_string_data)
pr = ProcessRoyalties()
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "Fourth Tier Oil", "Heavy", 24, 0), 0
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "Fourth Tier Oil", "Heavy", 100, 0),
0.0631,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(
royalty_calc, econ_oil_data, "Fourth Tier Oil", "Southwest", 100, 0
),
0.0784,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "Fourth Tier Oil", "Other", 130, 0),
0.12697,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "Fourth Tier Oil", "Heavy", 140, 0),
0.0966,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(
royalty_calc, econ_oil_data, "Fourth Tier Oil", "Southwest", 136.3, 0
),
0.11624028,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "Fourth Tier Oil", "Other", 150, 0),
0.14956667,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "Fourth Tier Oil", "Other", 0, 0), 0
)
self.assertRaises(
AppError,
pr.calc_sask_oil_prov_crown_royalty_rate,
royalty_calc,
econ_oil_data,
"Fourth Tier Oil",
"BadString",
120,
0,
)
self.assertRaises(
AppError,
pr.calc_sask_oil_prov_crown_royalty_rate,
royalty_calc,
econ_oil_data,
"Fourth Tier Oil",
"BadString",
140,
0,
)
self.assertRaises(
AppError,
pr.calc_sask_oil_prov_crown_royalty_rate,
royalty_calc,
econ_oil_data,
"Bad String",
"Heavy",
120,
0,
)
self.assertRaises(
AppError,
pr.calc_sask_oil_prov_crown_royalty_rate,
royalty_calc,
econ_oil_data,
"Bad String",
"Southwest",
120,
0,
)
self.assertRaises(
AppError,
pr.calc_sask_oil_prov_crown_royalty_rate,
royalty_calc,
econ_oil_data,
"Bad String",
"Other",
120,
0,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(
royalty_calc, econ_oil_data, "Third Tier Oil", "Heavy", 100, 0.0075
),
0.1499,
)
self.assertAlmostEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "New Oil", "Heavy", 100, 0.0075),
0.19620000,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "New Oil", "Heavy", 0, 0), 0
)
self.assertRaises(
AppError,
pr.calc_sask_oil_prov_crown_royalty_rate,
royalty_calc,
econ_oil_data,
"Third Tier Oil",
"Bad String",
120,
0,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(
royalty_calc, econ_oil_data, "Third Tier Oil", "Southwest", 120, 0
),
0.25495000,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "New Oil", "Southwest", 130, 0.0075),
0.30943846,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "New Oil", "Southwest", 0, 0), 0
)
self.assertRaises(
AppError,
pr.calc_sask_oil_prov_crown_royalty_rate,
royalty_calc,
econ_oil_data,
"New Oil",
"Bad String",
120,
0,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(
royalty_calc, econ_oil_data, "Third Tier Oil", "Other", 120, 0.0225
),
0.26888333,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "New Oil", "Other", 110, 0),
0.32235455,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "Old Oil", "Other", 100, 0.0075),
0.39720000,
)
self.assertEqual(
pr.calc_sask_oil_prov_crown_royalty_rate(royalty_calc, econ_oil_data, "Old Oil", "Other", 0, 0), 0
)
self.assertRaises(
AppError,
pr.calc_sask_oil_prov_crown_royalty_rate,
royalty_calc,
econ_oil_data,
"Old Oil",
"Bad String",
120,
0,
)
self.assertRaises(
AppError, pr.calc_sask_oil_prov_crown_royalty_rate, royalty_calc, econ_oil_data, "Old Oil", "Heavy", 120, 0
)
self.assertRaises(
AppError,
pr.calc_sask_oil_prov_crown_royalty_rate,
royalty_calc,
econ_oil_data,
"Old Oil",
"Southwest",
120,
0,
)
self.assertRaises(
AppError, pr.calc_sask_oil_prov_crown_royalty_rate, royalty_calc, econ_oil_data, None, None, 120, 0
)
return