generating an excel spreadsheet with javascript to help me play fallout: new vegas better

excel 2000 with dog clippy (rocky), showing a spreadsheet with my character build in yellow along the top (special 2, 10, 2, 3, 3, 10, 10, followed by my skills). below that, there’s a table of all of the base game regular perks, with how much more (or less) i need for each stat, a sum column that helps sort the list, and an ok column that says whether i am eligible. the three easiest perks i can become eligible for are “Rapid Reload”, “Friend of the Night”, and “Travel Light”.

left: code for perks.html that parses a perks table in tsv format, and outputs a tsv with a column for each numeric stat requirement. right: the output of that program, ready to paste into an excel spreadsheet, showing stat values and formulas.

so i started writing a tool for fallout: new vegas that can tell me what perks i’m eligible for or nearly eligible for, sorted by how attainable they are.

anyway it’s an excel spreadsheet generated by javascript that parses a table i scraped from the fallout wiki :3

shuppy (@delan) — [archived] 2023-12-18T04:30:37.374Z

i will play the game at some point i swear

fallout perks spreadsheet showing only S-tier and A-tier perks, now taking into account that i’m currently on level 8. for example, while i’m short by 29 medicine for “Chemist”, i’m also short by 6 levels, so the overall difficulty to get the perk is 69 (nice) (6 × (10 + 3/2)). in other words, i need 69 more skill points, at least 29 of which must go towards medicine.

added the tiers by /u/Nazbowling11 on reddit, and now i take my current level into account, so the ΣΔ score for each perk is

1000 × sum of insufficient specials
+ max(
(10 + intelligence/2) × insufficient levels,
sum of insufficient skills)