Just extract to Doom 3 base folder. Works only with retail doom 3 and steam doom 3, I don't know how to make it work with BFG Doom nor RoE.
I haven't created any mod, I set them properly with help from Doom3World tutorial from luke3000 (http://www.doom3world.org/phpbb2/viewtopic.php?t=24864) and merging the latest (as of june 06 2013) Sikkmod and Wulfen texture pack. Also you'll find Trent Reznor's sound pack and Monoxead's texture pack.I take absolutely no credit for anything, all credit due were they're due to their respective authors accordingly:
1. sikkmod v1.2
2. Sikkpin's patch for glprogs folder
3. Monoxead's high-res texture pack
4. Wulfen's high-res texture pack
5. Trent Reznor's sound pack
6. Luke3000's post in doom3world.
7. iD software for Doom 3 and idtech4 engine.
Thanks and have fun.