/// <summary>
/// Gets the base dollar value of the given factor
/// </summary>
/// <param name="tbl"></param>
/// <returns></returns>
public static double GetFactorBaseValue(AmericanFactorTables tbl)
{
DebtXml = DebtXml ?? XmlDocXrefIdentifier.GetEmbeddedXmlDoc(US_PERSONAL_DEBT,
Assembly.GetExecutingAssembly());
WealthXml = WealthXml ??
XmlDocXrefIdentifier.GetEmbeddedXmlDoc(US_PERSONAL_WEALTH, Assembly.GetExecutingAssembly());
var xmlDoc = tbl == AmericanFactorTables.CreditCardDebt || tbl == AmericanFactorTables.HomeDebt ||
tbl == AmericanFactorTables.VehicleDebt || tbl == AmericanFactorTables.OtherDebt
? DebtXml
: WealthXml;
var tblName = Enum.GetName(typeof(AmericanFactorTables), tbl);
var tblXPath = $"//table[@name='{tblName}']";
var tblNode = xmlDoc.SelectSingleNode(tblXPath) as XmlElement;
if (string.IsNullOrWhiteSpace(tblNode?.Attributes?["value"]?.Value))
{
return(0.0D);
}
if (!double.TryParse(tblNode.Attributes["value"].Value, out var dblOut))
{
return(0.0D);
}
return(dblOut);
}
/// <summary>
/// Get a random value for the given <see cref="factor"/> table.
/// </summary>
/// <param name="factor"></param>
/// <param name="factorMultiplier"></param>
/// <param name="stdDevAsPercent"></param>
/// <param name="assignedBase">
/// Optional value to directly assign a factor table's base value, defaults to
/// the value from <see cref="GetFactorBaseValue"/>
/// </param>
/// <returns></returns>
public static double GetRandomFactorValue(AmericanFactorTables factor, double factorMultiplier,
double stdDevAsPercent, double?assignedBase = null)
{
var baseValue = assignedBase.GetValueOrDefault(GetFactorBaseValue(factor));
baseValue = Math.Round(baseValue * factorMultiplier, 2);
var randValue = Math.Round(
Etx.RandomValueInNormalDist(Math.Round(baseValue, 0), Math.Round(baseValue * stdDevAsPercent, 0)), 2);
return(randValue);
}
/// <summary>
/// Gets the mean of the factors based on the criteria.
/// </summary>
/// <param name="tbl"></param>
/// <param name="edu"></param>
/// <param name="race"></param>
/// <param name="region"></param>
/// <param name="age"></param>
/// <param name="gender"></param>
/// <param name="maritalStatus"></param>
/// <returns>
/// A scalar factor above or below the national average(s) based on the given criteria
/// </returns>
/// <remarks>
/// src https://www2.census.gov/programs-surveys/demo/tables/wealth/2013/wealth-asset-ownership/wealth-tables-2013.xlsx
/// https://www2.census.gov/programs-surveys/demo/tables/wealth/2011/wealth-asset-ownership/debt-tables-2011.xlsx
/// </remarks>
public static double GetFactor(AmericanFactorTables tbl, OccidentalEdu edu, NorthAmericanRace race,
AmericanRegion region, int age, Gender gender, MaritalStatus maritalStatus)
{
DebtXml = DebtXml ?? XmlDocXrefIdentifier.GetEmbeddedXmlDoc(US_PERSONAL_DEBT,
Assembly.GetExecutingAssembly());
WealthXml = WealthXml ??
XmlDocXrefIdentifier.GetEmbeddedXmlDoc(US_PERSONAL_WEALTH, Assembly.GetExecutingAssembly());
var xmlDoc = tbl == AmericanFactorTables.CreditCardDebt || tbl == AmericanFactorTables.HomeDebt ||
tbl == AmericanFactorTables.VehicleDebt
? DebtXml
: WealthXml;
var tblName = Enum.GetName(typeof(AmericanFactorTables), tbl);
var eduName = GetXmlEduName(edu);
var raceName = Enum.GetName(typeof(NorthAmericanRace), race);
var regionName = Enum.GetName(typeof(AmericanRegion), region);
var genderName = Enum.GetName(typeof(Gender), gender);
var tblXPath = $"//table[@name='{tblName}']";
var factorCount = 0D;
var sum = 0.0D;
var hash = new Dictionary <string, string>
{
{ "Edu", eduName },
{ "Race", raceName },
{ "Region", regionName },
};
foreach (var factor in hash.Keys)
{
var xmlElem =
xmlDoc.SelectSingleNode($"{tblXPath}/factor[@name='{factor}']/add[@name='{hash[factor]}']") as
XmlElement;
var factorVal = xmlElem?.Attributes["value"]?.Value;
if (string.IsNullOrWhiteSpace(factorVal))
{
continue;
}
if (double.TryParse(factorVal, out var dblOut))
{
sum += dblOut;
factorCount += 1;
}
}
var ageNode = maritalStatus == MaritalStatus.Married || maritalStatus == MaritalStatus.Remarried
? xmlDoc.SelectSingleNode($"{tblXPath}/factor[@name='Age']/factor[@name='Married']")
: xmlDoc.SelectSingleNode($"{tblXPath}/factor[@name='Age']/factor[@name='{genderName}']");
factorCount = factorCount <= 0 ? 1 : factorCount;
if (ageNode == null)
{
return(Math.Round(sum / factorCount, 5));
}
foreach (var anode in ageNode.ChildNodes)
{
var ageElem = anode as XmlElement;
if (ageElem == null)
{
continue;
}
var minAge = ageElem.Attributes["min"]?.Value;
var maxAge = ageElem.Attributes["max"]?.Value;
if (string.IsNullOrWhiteSpace(minAge) || string.IsNullOrWhiteSpace(maxAge))
{
continue;
}
if (!int.TryParse(minAge, out var min) || !int.TryParse(maxAge, out var max))
{
continue;
}
var isInRange = age >= min && age <= max;
if (!isInRange || string.IsNullOrWhiteSpace(ageElem.Attributes["value"]?.Value))
{
continue;
}
var factorVal = ageElem.Attributes["value"].Value;
if (double.TryParse(factorVal, out var dblOut))
{
sum += dblOut;
factorCount += 1;
}
}
return(Math.Round(sum / factorCount, 5));
}
