|
|
Posted by larry on 12/19/06 22:42
Ok I am re-coding our apps in PHP and am looking for ways to make parts
easily updateable, One of the challenges in my field (non-rpofit) are
various lookup tables (for incomes etc).
An example table would be something like a rate lookup, where you
travel down the family size column and when you reach the right income
you look for the rate. An example here:
RATE - FAM2 -FAM3 - FAM4 - FAM5
100 - 1200 - 1300 - 1375 - 1380
123 - 1220 - 1320 - 1387 - 1392
143 - 1242 - 1342 - 1400 - 1412
So if it were a family of 3 with 1322 the rate would be 123.
To make this into a DB for lookup is a cinch, but for someone to
enter/update this compact table into a lookup DB is a pain.
Is there any libraries out there already to read a text file like the
above (more likely CSV) or a similarly formatted spreadsheet, or one
that presents a table entry method to expidite the entry of a table
like this?
Larry
Navigation:
[Reply to this message]
|