[RESOLVED] Converting 2-d array into array of objects.
I have the following in a withholding tax calculation page:
Code:
var EXEMPT = 3800; // May change in later years, see Publication 15, Circular E, Employer's Tax Guide from the IRS
var STable = [ // Define Single Table
[ 0, 0, 0], // Range, base, percentage
[ 2150, 0, .10],
[ 10850, 870.00, .15], // With >= 10850 & < 37500, tax is $870.00 + 15% of the amount over $10850
[ 37500, 4867.50, .25],
[ 87800, 17442.50, .28],
[180800, 43482.50, .33],
[390500, 112683.50, .35] // Note: no comma at end
];
......................................
for (var exmp=0; exmp < 8; exmp++) {
var WkAmt = AnnAmt - EXEMPT * exmp;
for (i=0; (i < (STable.length - 1)) && (WkAmt > STable[i+1][0]) ; i++) ; //Search Singles table for proper bracket.
var AnnTax = STable[i][1] + (WkAmt - STable[i][0]) * STable[i][2];
document.tax2012.elements[TableSub++].value = Nformat(AnnTax / NoPeriods);
}
The 2nd subscript indicates what field is used and is always constant. How can I change this into a one dimension table of objects with three fields/properties? TIA
<script type="text/javascript">
var STable = [ // Define Single Table
[ 0, 0, 0], // Range, base, rate
[ 2150, 0, .10],
[ 10850, 870.00, .15], // With >= 10850 & < 37500, tax is $870.00 + 15% of the amount over $10850
[ 37500, 4867.50, .25],
[ 87800, 17442.50, .28],
[180800, 43482.50, .33],
[390500, 112683.50, .35] // Note: no comma at end
];
// To allows alert (which call a toString() function) with object like with tables
Object.prototype.toString=function(){var i,c='\n';for (i in this) c+='\nkey '+i+' => value '+this[i];return c}
// A constructor
function Obj(range,base,rate){this.range=range;this.base=base;this.rate=rate;}
// A loop to build an unidimensional Array of objects
var STableObj=[];
for (var i=0;i<STable.length;i++) STableObj[STableObj.length]=new Obj(STable[i][0],STable[i][1],STable[i][2]);
// The result
alert(STableObj)
// this table seems to use like this
var amount=40000,availableBracket=STableObj.length-1;
while (availableBracket && amount<STableObj[availableBracket].range) availableBracket--;
alert(availableBracket)
tax = STableObj[availableBracket].base+(amount-STableObj[availableBracket].range)*STableObj[availableBracket].rate
alert(tax)
</script>
For creating a custom object with that data, this works.
Or are you looking for code that does the conversion? (e.g., you are forced to receive the information as a 2D array but prefer to work with an single array of objects instead?
Code:
<script>
function taxTable(range,base,percentage){
this.range = range;
this.base = base;
this.percentage = percentage;
}
arrSTable = new Array();
arrSTable[0] = new taxTable("0","0","0");
arrSTable[1] = new taxTable("2150","0",".10");
arrSTable[2] = new taxTable("10850","870.00",".15");
arrSTable[3] = new taxTable("37500","4867.50",".25");
arrSTable[4] = new taxTable("87800","17442.50",".28");
arrSTable[5] = new taxTable("180800","43482.50",".33");
arrSTable[6] = new taxTable("390500","112683.50",".35");
for (i=0; i<arrSTable.length;i++){
document.write ("<p>Range: " + arrSTable[i].range + ", Base: " + arrSTable[i].base + ", Percentage: " + arrSTable[i].percentage + "</p>");
}
</script>
I've never worked with objects except in a "class" and this is a first chance to plunge in. The tables don't change for a year so I can use any method that works to load them. A 2-d table makes sense when each element contains the same type of data.
Plenty of food for thought--thanks people for looking into it.
Bookmarks