Random Wizard's Spell Tables (D&D3.5E)

Using the poll results at the EN World Forum
and an assumption such that "the probability of a spell is propotional to the number of vote for the spell", I made random wizard's spell tables.  I hope this would be useful for DM to generate NPC wizards.

Typical number of spells are based on  WotC's Tome and Blood Web Enhancement.

1 Level Spells

d100
 Spell
(Typical number of spells: Wiz1=5, Wiz2-20=7)
01 Alarm
02-03 Burning Hands
04-07 Charm Person
08-11 Color Spray
12-14 Comprehend Languages
15 Detect Secret Doors
16 Disguise Self
17 Endure Elements
18-20 Enlarge Person
21-23 Expeditious Retreat
24-26 Feather Fall
27-30 Grease
31-37 Identify
38-49 Mage Armor
50-63 Magic Missile
64-65 Magic Weapon
66 Mount
67-68 Obscuring Mist
69-71 Protection from Chaos/Evil/Good/Law
72-75 Ray of Enfeeblement
76-82 Shield
83 Shocking Grasp
84 Silent Image
85-90 Sleep
91-92 Summon Monster I
93-94 True Strike
95 Unseen Servant
96-00 / 01-09 Animate Rope
96-00 / 10-23 Cause Fear
96-00 / 24-32 Chill Touch
96-00 / 33-41 Detect Undead
96-00 / 42-47 Erase
96-00 / 48-51 Floating Disk
96-00 / 52-64 Hold Portal
96-00 / 65-68 Hypnotism
96-00 / 69-79 Jump
96-00 / 80-81 Magic Aura
96-00 / 82-89 Reduce Person
96-00 / 90-00 Ventriloquism

2 Level Spells

d100
 Spell
(Typical number of spells: Wiz3=2, Wiz4=4, Wiz5=5, Wiz6-18=6, Wiz19-20=7)
01-05 Acid Arrow
06-13 Alter Self
14-17 Bear's Endurance
18-21 Bull's Strength
22-25 Cat's Grace
26-27 Eagle's Splendor
28-29 Fox's Cunning
30-31 Owl's Wisdom
32-34 Blindness/Deafness
35-37 Blur
38 Darkness
39-40 Flaming Sphere
41-43 Hideous Laughter
44-57 Invisibility
58-62 Knock
63 Minor Image
64-72 Mirror Image
73-76 Resist Energy
77-80 Rope TRick
81-89 Scorching Ray
90-98 See Invisibility
99 Summon Monster II
00 Touch of Idiocy

3 Level Spells

d100
 Spell
(Typical number of spells: Wiz5=2, Wiz6=4, Wiz7=5, Wiz8-18=6, Wiz19-20=7)
01-03 Arcane Sight
04 Blink
05 Clairaudience/Clairvoyance
06-23 Dispel Magic
24-26 Displacement
27-40 Fireball
41-53 Fly
54 Gaseous Form
55-66 Haste
67-68 Hold Person
69 Invisibility Sphere
70-73 Lightning Bolt
74-75 Magic Circle Against Chaos/Evil/Good/Law
76 Magic Weapon, Greater
77-79 Protection from Energy
80-85 Slow
86-87 Stinking Cloud
88 Suggestion
89-90 Summon Monster III
91 Tongues
92 Vampiric Touch
93 Tiny Hut
94 Heroism
95 Nondetection
96 Wind Wall
97-00 / 01-02 Daylight
97-00 / 03-08 Deep Slumber
97-00 / 09-20 Explosive Runes
97-00 / 21-32 Flame Arrow
97-00 / 33-34 Gentle Repose
97-00 / 35-36 Halt Undead
97-00 / 37-38 Illusory Script
97-00 / 39-44 Keen Edge
97-00 / 45-50 Major Image
97-00 / 51-52 Phantom Steed
97-00 / 53-58 Rage
97-00 / 59-70 Ray of Exhaustion
97-00 / 71-72 Secret Page
97-00 / 73-74 Sepia Snake Sigil
97-00 / 75-76 Shrink Item
97-00 / 77-88 Sleet Storm
97-00 / 89-00 Water Breathing

4 Level Spells

d100
 Spell
(Typical number of spells: Wiz7=2, Wiz8=4, Wiz9=5, Wiz10-18=6, Wiz19-20=7)
01-08 Black Tentacles
09-12 Charm Monster
13-15 Confusion
16-17 Detect Scrying
18-32 Dimension Door
33-38 Enervation
39-41 Globe of Invulnerability, Lesser
42-56 Invisibility, Greater
57-58 Phantasmal Killer
59-69 Polymorph
70-71 Resilient Sphere
72-77 Scrying
78-79 Secure Shelter
80-81 Stone Shape
82-91 Stoneskin
92-94 Summon Monster IV
95-97 Wall of Fire
98-99 Wall of Ice
00 / 01-45 Bestow Curse
00 / 46-60 Contagion
00 / 61-75 Enlarge Person, Mass
00 / 76-90 Hallucinatory Terrain
00 / 91-00 Shout

5 Level Spells

d100
 Spell
(Typical number of spells: Wiz9=2, Wiz10=4, Wiz11=5, Wiz12-19=6, Wiz20=7)
01-03 Balefule Polymorph
04-06 Break Enchantment
07-11 Cloudkill
12-15 Cone of Cold
16 Dismissal
17-19 Dominate Person
20 Fabricate
21-25 Feeblemind
26-33 Hold Monster
34 Interposing Hand
35 Mage's Private Sanctum
36-37 Magic Jar
38 Mind Fog
39 Overland Flight
40 Passwall
41-42 Permanency
43 Prying Eyes
44-45 Sending
46 Shadow Evocation
47-50 Summon Monster V
51-53 Telekinesis
54-55 Telepathic Bond
56-75 Teleport
76-77 Transmute Rock to Mud
78-92 Wall of Force
93-94 Wall of Stone
95-96 Waves of Fatigue
97-00 / 01-07 Animal Growth
97-00 / 08-10 Blight
97-00 / 11-24 Contact Other Plane
97-00 / 25-27 Dream
97-00 / 28-30 False Vision
97-00 / 31-33 Mage's Faithful Hound
97-00 / 34-40 Major Creation
97-00 / 41-43 Mirage Arcana
97-00 / 44-46 Nightmare
97-00 / 47-53 Persistent Image
97-00 / 54-60 Planar Binding, Lesser
97-00 / 61-63 Secret Chest
97-00 / 64-70 Seeming
97-00 / 71-83 Symbol of Pain
97-00 / 84-86 Symbol of Sleep
97-00 / 87-00 Transmute Mud to Rock

6 Level Spells

d100 Spell
(Typical number of spells: Wiz11=2, Wiz12=4, Wiz13=5, Wiz14-19=6, Wiz20=7)
01 Acid Fog
02-09 Antimagic Field
10-15 Chain Lightning
16-26 Contingency
27-39 Disintegrate
40-57 Dispel Magic, Greater
58-59 Flesh to Stone
60 Freezing Sphere
61-64 Globe of Invulnerability
65 Heroism, Greater
66 Mage's Lucubration
67 Permanent Image
68 Planar Binding
69-70 Shadow Walk
71-72 Stone to Flesh
73-74 Summon Monster VI
75 Transformation
76-90 True Seeing
91 Undeath to Death
92-94 Wall of Iron
95-00 / 01-14 Bear's Endurance, Mass
95-00 / 15-28 Bull's Strength, Mass
95-00 / 29-41 Cat's Grace, Mass
95-00 / 42-51 Circle of Death
95-00 / 52-54 Eagle's Splendor, Mass
95-00 / 55-57 Eyebite
95-00 / 58-60 Fox's Cunning, Mass
95-00 / 61-73 Mislead
95-00 / 74-76 Owl's Wisdom, Mass
95-00 / 77-90 Suggestion, Mass
95-00 / 91-00 Veil

7 Level Spells

d100 Spell
(Typical number of spells: Wiz13=2, Wiz14=4, Wiz15=5, Wiz16-19=6, Wiz20=7)
01 Arcane Sight, Greater
02-03 Banishment
04-06 Delayed Blast Fireball
07 Ethereal Jaunt
08-12 Finger of Death
13-20 Forcecage
21 Grasping Hand
22-23 Hold Person, Mass
24 Invisibility, Mass
25-40 Limited Wish
41-44 Mage's Magnificent Mansion
45-47 Mage's Sword
48-49 Plane Shift
50 Power Word Blind
51-56 Prismatic Spray
57 Project Image
58-62 Reverse Gravity
63-65 Scrying, Greater
66-74 Spell Turning
75-78 Summon Monster VII
79-92 Teleport, Greater
93-95 Waves of Exhaustion
96-00 / 01-13 Control Undead
96-00 / 14-26 Control Weather
96-00 / 27-33 Insanity
96-00 / 34-40 Instant Summons
96-00 / 41-43 Phase Door
96-00 / 44-50 Sequester
96-00 / 51-64 Shadow Conjuration, Greater
96-00 / 65-71 Simulacrum
96-00 / 72-84 Statue
96-00 / 85-87 Symbol of Stunning
96-00 / 88-90 Symbol of Weakness
96-00 / 91-93 Teleport Object
96-00 / 94-00 Vision

8 Level Spells

d100 Spell
(Typical number of spells: Wiz15=2, Wiz16=4, Wiz17=5, Wiz18-19=6, Wiz20=7)
01 Antipathy
02-04 Charm Monster, Mass
05-06 Clenched Fist
07-11 Clone
12 Create Greater Undead
13-14 Dimensional Lock
15-19 Discern Location
20-29 Horrid Wilting
30 Incendiary Cloud
31-32 Iron Body
33-38 Irresistable Dance
39-43 Maze
44-56 MInd Blank
57-59 Moment of Prescience
60-61 Planar Binding, Greater
62-63 Polar Ray
64-72 Polymorph Any Object
73-76 Power Word Stun
77-79 Prismatic Wall
80-83 Protection from Spells
84 Prying Eyes, Greater
85 Shadow Evocation, Greater
86-90 Summon Monster VIII
91 Sunburst
92 Symbol of Insanity
93 Telekinetic Sphere
94-95 Temporal Stasis
96-97 Trap the Soul
98-00 / 01-08 Binding
98-00 / 09-16 Demand
98-00 / 17-24 Scintillating Pattern
98-00 / 25-47 Screen
98-00 / 48-70 Shout, Greater
98-00 / 71-92 Symbol of Death
98-00 / 93-00 Sympathy

9 Level Spells

d100 Spell
(Typical number of spells: Wiz17=2, Wiz18=4, Wiz19-20=6)
01 Astral Projection
02-05 Dominate Monster
06-07 Energy Drain
08-10 Foresight
11-18 Gate
19 Hold Monster, Mass
20-21 Imprisonment
22-29 Mage's Disjunction
30-35 Meteor Swarm
36-39 Power Word Kill
40-41 Prismatic Sphere
42 Shades
43-59 Shapechange
60-61 Summon Monster IX
62-83 Time Stop
84-86 Wail of the Banshee
87 Weird
88-98 Wish
99-00 / 01-29 Crushing Hand
99-00 / 30-58 Teleportation Circle
99-00 / 59-72 Etherealness
99-00 / 73-86 Freedom
99-00 / 87-93 Refuge
99-00 / 94-00 Soul Bind