Spreadsheet: 88415d1288245211-how-to-count-duplicates-incrementally-and-compare-to-reference-value-nvcharcreator
Sheet: Sheet1

Fallout: New Vegas Character Creator Sheet |  |  |  |  |  |  |  | by nuclearsean
SPECIAL | Initial | Final |  |  | Trait | Benefit |  |  | Penalty |  |  |  |  | Level | Perk | Rank | Req | Benefit |  | Trait | Benefit | Penalty |  | Level req | Name | Other requirements | Ranks | Benefit
Strength | 4 | 5 |  |  | Wild Wasteland | Adds 'wackier' versions of existing content |  |  | Adds 'wackier' versions of existing content |  |  |  |  | 2 | [NAME]/Confirmed Bachelor | 1 |  | +10% damage to the same sex and unique dialogue options with certain characters. |  | Built to Destroy | +3% critical hit chance | Condition decays 15% faster
Perception | 6 | 7 |  |  | Small Frame | +1 Agility |  |  | Fragile Limbs |  |  |  |  | 4 | Educated | 1 | IN 4 | You gain two more skill points every time you advance in level. |  | Fast Shot | +20% rate of fire with guns/energy weapons | -20% accuracy with guns/energy weapons |  | 2 | Black Widow/[NAME] |  | 1 | +10% damage to the opposite sex and unique dialogue options with certain characters.
Endurance | 7 | 8 |  |  |  |  |  |  |  |  |  |  |  | 6 | Comprehension | 1 | IN 4 | You gain one additional skill point for reading books and double the skill points for reading magazines. |  | Four Eyes | +1 Perception while wearing glasses | -1 Perception without wearing glasses |  | 2 | [NAME]/Confirmed Bachelor |  | 1 | +10% damage to the same sex and unique dialogue options with certain characters.
Charisma | 1 | 1 | Yes |  | Skill | Tag | Base | Desired | Needed | Added | Current | Limit |  | 8 | [NAME] | 3 |  | You can put a single point into any of your SPECIAL attributes. |  | [NAME] | +5 to speech, medicine, repair, science, barter | -5 to all weapon skills |  | 2 | Friend of the Night | PE 6, Sneak 30 | 1 | Your eyes adapt quickly to low-light conditions
Intelligence | 9 | 10 |  |  | [NAME] |  | 9 | 30 | 5 |  | 9 | 14 |  | 10 | [NAME] | 3 |  | You can put a single point into any of your SPECIAL attributes. |  | Heavy Handed | [NAME]/unarmed do more damage | [NAME]/unarmed do less critical hit damage |  | 2 | Heave, [NAME]! | ST 5, Explosives 30 | 1 | All thrown weapons fly farther and faster for you.
Agility | 4 | 5 |  |  | Energy Weapons | Yes | 36 | 100 | 48 |  | 36 | 84 |  | 12 | [NAME] | 3 |  | You can put a single point into any of your SPECIAL attributes. |  | Kamikaze | +10 Action Points | [NAME] |  | 2 | [NAME] | Survival 30 | 1 | In combat, you do 75% more critical damage against animals and mutated animals.
Luck | 9 | 10 | 43 |  | Explosives |  | 21 | 100 | 67 |  | 21 | 88 |  | 14 |  |  |  |  |  | Loose Cannon | Thrown weapons fly 30% faster | Thrown weapons have 25% less range |  | 2 | [NAME] |  | 10 | You can put a single point into any of your SPECIAL attributes.
 | 3 points available |  |  |  | Guns |  | 17 | 50 | 17 |  | 17 | 34 |  | 16 |  |  |  |  |  | Small Frame | +1 Agility | Fragile Limbs |  | 2 | Rapid Reload | AG 5, Guns 30 | 1 | All of your weapon reloads are 25% faster than normal.
 |  |  |  |  | [NAME] |  | 21 | 100 | 63 |  | 21 | 84 |  | 18 |  |  |  |  |  | [NAME] | +20% accuracy with guns and energy weapons | -20% rate of fire with guns/energy weapons |  | 2 | Retention | IN 5 | 1 | [NAME] have a longer duration
Statistic | Level | 30 |  |  | Medicine |  | 27 | 100 | 57 |  | 27 | 84 |  | 20 |  |  |  |  |  | Wild Wasteland | Adds 'wackier' versions of existing content | Adds 'wackier' versions of existing content |  | 2 | Swift Learner | IN 4 | 3 | You gain an additional 10% whenever experience points are earned.
HP | 260 |  |  |  | [NAME] |  | 17 | 50 | 13 |  | 17 | 30 |  | 22 |  |  |  |  |  |  |  |  |  | 4 | Cannibal |  | 1 | When you're in Sneak mode, you gain the option to eat a human corpse to regain hit points, but lose [NAME].
SP/Level | 17 |  |  |  | Repair | Yes | 42 | 100 | 42 |  | 42 | 84 |  | 24 |  |  |  |  |  |  |  |  |  | 4 | Comprehension | IN 4 | 1 | You gain one additional skill point for reading books and double the skill points for reading magazines.
Total Skill Points | 502 |  |  |  | Science | Yes | 42 | 100 | 38 |  | 42 | 80 |  | 26 |  |  |  |  |  |  |  |  |  | 4 | Educated | IN 4 | 1 | You gain two more skill points every time you advance in level.
[NAME] | 200 |  |  |  | Sneak |  | 17 | 50 | 17 |  | 17 | 34 |  | 28 |  |  |  |  |  |  |  |  |  | 4 | Entomologist | IN 4, Survival 45 | 1 | You do an additional 50% damage every time you attack a mutated insect.
AP | 80 |  |  |  | Speech | Yes | 24 | 100 | 60 |  | 24 | 84 |  | 30 |  |  |  |  |  |  |  |  |  | 4 | [NAME] | Survival 70 | 1 | The more irradiated you are, the bigger the bonus to your healing.
Crit Chance | 0.1 |  |  |  | Survival |  | 23 | 50 | 11 |  | 23 | 34 |  |  |  |  |  |  |  |  |  |  |  | 4 | Run 'n Gun | Guns 45 or Energy Weapons 45 | 1 | Reduces accuracy penalties with one-handed ranged weapons while walking or running.
Laser Crit % | 0.1 |  |  |  | Unarmed |  | 23 | 50 | 11 |  | 23 | 34 |  |  |  |  |  |  |  |  |  |  |  | 4 | Travel Light | Survival 45 | 1 | While wearing light armor or no armor, you run 10% faster.
[NAME] | 0.1 |  |  |  |  | Too many tagged skills |  | 53 points to spend |  | 502 points to spend |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Bloody Mess |  | 1 | +5% overall damage, more violent death animations.
[NAME] | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Demolition Expert | Explosives 50 | 3 | +20% damage with explosives
Poison Resistance | 0.35 |  |  |  | Books | Available | Read |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME] | CH 6 | 1 | When you drop below 50% HP, companions gain DT.
[NAME] | 0.14 |  | 0 |  | [NAME] | 4 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME] | LK 5 | 1 | Considerably more bottle caps will be found in stockpiles.
Fire Resistance | 0 |  | 1 |  | Energy Weapons | 4 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Gunslinger |  | 1 | More accuracy in V.A.T.S. with one-handed weapons.
 |  |  | 2 |  | Explosives | 3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Hand Loader | Repair 70 | 1 | When using [NAME], you are more likely to recover cases and hulls. You also have all hand load recipes unlocked at any reloading benches.
Implants |  |  | 3 |  | Guns | 4 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Lead Belly | EN 5 | 1 | -50% radiation taken from food and water sources.
Strength | Yes |  | 4 |  | [NAME] | 4 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Shotgun Surgeon | Guns 45 | 1 | When using shotguns, regardless of ammunition used, you ignore an additional 10 points of a target's damage threshold.
Perception | Yes |  | 5 |  | Medicine | 4 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | The Professional | Sneak 70 | 1 | Your sneak attack criticals with revolvers, pistols, and submachine guns (guns and energy weapons) all inflict an additional 20% damage.
Endurance | Yes |  | 6 |  | [NAME] | 5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Toughness | EN 5 | 2 | +3 DT permanently
Charisma |  |  | 7 |  | Repair | 4 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME] | Science 70 | 1 | When using Energy Weapons, you are more likely to recover drained ammunition. You also have more efficient recycling recipes available at workbenches.
Intelligence | Yes |  | 8 |  | Science | 5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Commando |  | 1 | More accuracy in V.A.T.S. with two-handed weapons.
at what level? | 1 |  | 9 |  | Sneak | 4 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Cowboy | Guns 45, Melee 45 | 1 | Increases damage done by dynamite, hatchets, knives, revolvers, and lever-action guns.
Agility | Yes |  | 10 |  | Speech | 4 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Living Anatomy | Medicine 70 | 1 | Shows health and [NAME] of any target. +5% bonus to damage against humans and non-feral ghouls.
Luck | Yes |  | 11 |  | Survival | 4 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Pack Rat | IN 5, [NAME] 70 | 1 | Items with a weight of two pounds or less now weigh half as much
Sub-Dermal Armor | Yes |  | 12 |  | Unarmed | 4 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | [NAME] | AG 5 | 1 | Makes weapon equipping and holstering 50% faster.
[NAME] |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | [NAME] | EN 5, Survival 40 | 1 | +25% Radiation Resistance permanently.
 | 0 implants left |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Scrounger | LK 5 |  | Considerably more ammo in stockpiles.
 |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Stonewall | ST 6, EN 6 | 1 | +5 DT against melee and unarmed attacks and cannot be knocked down during combat.
 |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Strong Back | ST 5, EN 5 | 1 | +50 [NAME].
 |  |  | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Super Slam | ST 6, [NAME] 45 | 1 | All melee (except thrown) and unarmed attacks have a chance of knocking your target down.
 |  |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Terrifying Presence | Speech 70 | 1 | Can intimidate foes through dialogue; closing dialogue results in the foe fleeing for 5 seconds.
 |  |  | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Here and Now |  | 1 | You instantly level up again.
 |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Animal Friend | CH 6, Survival 45 | 2 | On 1st rank, hostile animals become friendly. On 2nd rank they come to your aid against enemies except against other animals.
 |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Finesse |  | 1 | +5% Critical Chance
 |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Math Wrath | Science 70 | 1 | Reduces all AP costs by 10%
 |  |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Miss Fortune | LK 6 | 1 | Chance that Miss [NAME] will finish off a target in VATS.
 |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Mister [NAME] | Sneak 60 | 1 | Can instantly kill a sleeping NPC, and earns bonus XP
 |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | [NAME] | LK 6 | 1 | Chance that the Stranger will finish off a target in VATS.
 |  |  | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Nerd Rage! | IN 5, Science 50 | 1 | +15% DT and [NAME] increased to 10 whenever health is 20% or lower
 |  |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Night Person |  | 1 | +2 Intelligence and +2 Perception between 6:00 P.M. and 6:00 A.M.
 |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | [NAME] | Energy Weapons 70 | 1 | AP costs for all plasma weapons are reduced by 10%.
 |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Fast Metabolism |  | 1 | +20% Hit Points restored with stimpaks.
 |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Ghastly Scavenger | Cannibal perk | 1 | When you're in Sneak mode, you gain the option to eat a super mutant or feral ghoul corpse to regain hit points, but lose [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Hit the Deck | Explosives 70 | 1 | + 50% DT against explosives.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Life Giver | EN 6 | 1 | +30 hit points.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Long Haul | EN 6, [NAME] 70 | 1 | Being over-encumbered no longer prevents you from using fast travel.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Piercing Strike | Unarmed 70 |  | All your unarmed and melee attacks negate 15 points of DT.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Pyromaniac | Explosives 60 | 1 | +50% damage with fire-based weapons.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Robotics Expert | Science 50 | 1 | +25% damage to robots, can shut down robots by sneaking up on them
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Silent Running | AG 6, Sneak 50 | 1 | Running no longer factors into a successful sneak attempt.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Sniper | PE 6, AG 6 | 1 | More likely to hit the target's head in V.A.T.S.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Splash Damage | Explosives 70 | 1 | Explosives have a 25% larger area of effect.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Unstoppable Force | ST 7, [NAME] 90 | 1 | You do additional damage through enemy blocks with melee and unarmed attacks,
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | [NAME] |  | 1 | Damage taken by limbs reduced by 50%.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | Center of Mass | Guns 70 | 1 | In VATS., you do an additional 15% damage when targeting the torso.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | Chemist | Medicine 60 | 1 | Chems last twice as long,
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | Jury Rigging | Repair 90 | 1 | Repair any item using a roughly similar item.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | Light Step | PE 6, AG 6 | 1 | Floor traps or mines will not be set off.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | Purifier |  | 1 | You do 50% extra damage with melee and unarmed weapons against centaurs, nightstalkers, spore plants, spore carriers, deathclaws, super mutants, and feral ghouls.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | Action Boy/Action Girl | AG 6 | 2 | +15 Action Points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | Better Criticals | PE 6, LK 6 | 1 | +50% damage with critical hits
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | Chem Resistant | Medicine 60 | 1 | Half as likely to get addicted.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | Meltdown | Energy Weapons 90 | 1 | Foes killed by your Energy Weapons emit a corona of harmful energy.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | Tag! |  | 1 | Fourth "tag" skill: +15 points to that skill.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | Weapon Handling | ST < 10 | 1 | Weapon ST requirements are now 2 points lower than normal for you.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | Computer Whiz | IN 7, Science 70 | 1 | Can hack a locked down terminal with four more chances.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | Concentrated Fire | Energy Weapons 60, Guns 60 | 1 | More accuracy in V.A.T.S. with every attack on a given body part queued.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | Infiltrator | PE 7, [NAME] | 1 | Can pick a broken lock with one more bobby pin.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | Paralyzing Palm | Unarmed 70 | 1 | Can paralyze an enemy for 30 seconds with a V.A.T.S. unarmed attack.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | Explorer |  | 1 | All locations are marked on your map.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | [NAME] Sprint |  | 1 | A kill in V.A.T.S. restores 20 AP immediately.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | Ninja | [NAME] 80, Sneak 80 | 1 | +15%( 15 luck skill) critical chance with melee and unarmed weapons, +25% damage with sneak attack criticals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | Solar Powered | EN 7 | 1 | +2 Strength and +1 HP every 10 seconds while outside, from 6:00 A.M. to 6:00 P.M.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | Laser Commander | Energy Weapons 90 | 1 | You do an extra 15% damage and have a 10% extra chance to critically hit with any laser weapon.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | [NAME] | Science 90 | 1 | Unlocks special Nuka-Cola recipes at the Workbench.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | Spray ‘n Pray |  | 1 | Your attacks do much less damage to companions.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | Slayer | AG 7, Unarmed 90 | 1 | The speed of all your melee and unarmed attacks is increased by 30%.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | Nerves of Steel | AG 7 | 1 | Faster AP regeneration.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | Rad Absorption | EN 7 | 1 | -1 Rad every 20 seconds.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rad Absorption |  | EN 7 | 1