# The Feud: Items in a Junk Drawer \[Game Over\] **URL:** \ **Category:** The Game Room\ **Created:** [May 20, 2009, 2:53pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069 "2009-05-20T14:53:34Z")\ **Posts on this page:** 20\ **Page:** 3
**Author:** ![Munch](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/munch/32/5281_2.png) [@Munch](https://boards.straightdope.com/u/Munch)\ **Post date:** [May 20, 2009, 7:18pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/41 "2009-05-20T19:18:12Z")
> [@Rebo](#): > > I think the easiest way (for me) will be to do it by hand. The problem is tracking who said what, while stripping away the numbering. I’ve got an idea or two… Easy. Get everything into a new excel sheet, numbers and all. Next to each and every entry, put their name. So take this list, plug it into Excel: NOT AN ENTRY: 1. dead hookers 2. elephants 3. big rig truck 4. The Astrodome 5. The Pyramids at Giza 6. Abe Vigoda 7. Empire State Building 8. Sadness 9. gold dubloons 10. a pirate Next to every entry, put my name, so it looks like this: ```auto 1. dead hookers Munch 2. elephants Munch 3. big rig truck Munch 4. The Astrodome Munch 5. The Pyramids at Giza Munch 6. Abe Vigoda Munch 7. Empire State Building Munch 8. Sadness Munch 9. gold dubloons Munch 10. a pirate Munch ``` Now, highlight the column of answers. The first goal is to eliminate any double spaces after periods (for those who still do that out of habit), but maintain the spaces in phrases like “Empire State Building”. So do a find of " " (two spaces) and replace it with " " (one space). Then do a search of ". " (period and a space) and replace it with nothing. That column should now look like this: 1dead hookers 2elephants 3big rig truck 4The Astrodome 5The Pyramids at Giza 6Abe Vigoda 7Empire State Building 8Sadness 9gold dubloons 10a pirate Now you (after making sure no entries use numbers as part of the actual answer) just go through and delete the numbers doing a find and replace. We’ll work on the pivot part later. ---
**Author:** ![Rebo](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/rebo/32/13005_2.png) [@Rebo](https://boards.straightdope.com/u/Rebo)\ **Post date:** [May 20, 2009, 7:38pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/42 "2009-05-20T19:38:16Z")
Ok - that’s easy enough. The first part is what I do already. The stripping away the numbers is easy enough. Thanks. What’s next? (I have to leave in two hours, and I don’t know when I’ll get back online. Probably tomorrow sometime - but I’m taking a vacation day tomorrow and it’s my hubby’s birthday. I don’t know my schedule.) ---
**Author:** ![MsWhatsit](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@MsWhatsit](https://boards.straightdope.com/u/MsWhatsit)\ **Post date:** [May 20, 2009, 7:42pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/43 "2009-05-20T19:42:42Z")
1. batteries 2. string 3. scissors 4. tape 5. paper clips 6. rubber bands 7. can opener 8. envelopes 9. pencils/pens 10. battery chargers ---
**Author:** ![Ellen\_Cherry](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/ellen_cherry/32/3600_2.png) [@Ellen\_Cherry](https://boards.straightdope.com/u/Ellen_Cherry)\ **Post date:** [May 20, 2009, 7:42pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/44 "2009-05-20T19:42:46Z")
1. scissors 2. tape 3. rubber bands 4. twist-ties 5. coins 6. screws 7. scratch paper 8. broken toys 9. glue 10. pens ---
**Author:** ![Munch](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/munch/32/5281_2.png) [@Munch](https://boards.straightdope.com/u/Munch)\ **Post date:** [May 20, 2009, 7:57pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/45 "2009-05-20T19:57:46Z")
> [@Rebo](#): > > What’s next? 1. Give the columns headings (Items, Doper). 2. I copied the list and repeated it, making a list of 20, and gave the new 10 your name, just to make this work better. I also changed Dolores’ “a pirate” to “a ninja”. 3. Highlight the two columns. 4. Go to “Data” in the toolbar, click “PivotTable and PivotChart Report…” 5. Click “Next”, “Next”, “Layout”. 6. Click and drag “Items” over to the “ROW” section. 7. Click and drag “Doper” over to the “DATA” section (should now read “Count of Doper”). 8. Click “OK” and then “Finish”. You should now have a list that looks like this: Count of Doper Items Total a ninja 1 a pirate 1 Abe Vigoda 2 big rig truck 2 dead hookers 2 elephants 2 Empire State Building 2 gold dubloons 2 Sadness 2 The Astrodome 2 The Pyramids at Giza 2 (blank) Grand Total 20 From this point on, I’m not really sure how you do your scoring. Let me know if you got this far, or if I can clarify something. ---
**Author:** ![Miller](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/miller/32/481_2.png) [@Miller](https://boards.straightdope.com/u/Miller)\ **Post date:** [May 20, 2009, 8:20pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/46 "2009-05-20T20:20:15Z")
1. Scissors 2. Tape 3. Batteries 4. Tape 5. Take-out menus 6. Glue 7. Rubber bands 8. Random screws and nails 9. Old keys 10. String ---
**Author:** ![Arachne](https://avatars.discourse-cdn.com/v4/letter/a/3ec8ea/32.png) [@Arachne](https://boards.straightdope.com/u/Arachne)\ **Post date:** [May 20, 2009, 8:23pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/47 "2009-05-20T20:23:30Z")
– ---
**Author:** ![palindromemordnilap](https://avatars.discourse-cdn.com/v4/letter/p/db5fbb/32.png) [@palindromemordnilap](https://boards.straightdope.com/u/palindromemordnilap)\ **Post date:** [May 20, 2009, 8:27pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/48 "2009-05-20T20:27:46Z")
1. pen 2. rubber bands 3. screwdriver 4. paper clips 5. coins 6. scrap paper 7. key ---
**Author:** ![Rebo](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/rebo/32/13005_2.png) [@Rebo](https://boards.straightdope.com/u/Rebo)\ **Post date:** [May 20, 2009, 8:37pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/49 "2009-05-20T20:37:59Z")
> [@Munch](#): > > 1. Give the columns headings (Items, Doper). > 2. I copied the list and repeated it, making a list of 20, and gave the new 10 your name, just to make this work better. I also changed Dolores’ “a pirate” to “a ninja”. > 3. Highlight the two columns. > 4. Go to “Data” in the toolbar, click “PivotTable and PivotChart Report…” > 5. Click “Next”, “Next”, “Layout”. > 6. Click and drag “Items” over to the “ROW” section. > 7. Click and drag “Doper” over to the “DATA” section (should now read “Count of Doper”). > 8. Click “OK” and then “Finish”. > > You should now have a list that looks like this: > > Count of Doper > Items Total > a ninja 1 > a pirate 1 > Abe Vigoda 2 > big rig truck 2 > dead hookers 2 > elephants 2 > Empire State Building 2 > gold dubloons 2 > Sadness 2 > The Astrodome 2 > The Pyramids at Giza 2 > (blank) > Grand Total 20 > > From this point on, I’m not really sure how you do your scoring. Let me know if you got this far, or if I can clarify something. Ok - thanks! I’ll have to get to it tomorrow. I’m sure I’ll have some time over the next five days. I start a mini-vacation in less than an hour. Yay! Oh jeez - I have Office 2007. Now I’ll have to translate all the commands… I’m sure I can figure it out though. I want to do this, because it will be a different kind of game - not a Feud. We’ll call it Top Ten or something… 😃 ---
**Author:** ![Munch](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/munch/32/5281_2.png) [@Munch](https://boards.straightdope.com/u/Munch)\ **Post date:** [May 20, 2009, 8:48pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/50 "2009-05-20T20:48:40Z")
Oooh, Office 2007… I have that at home. I’ll try to translate everything tonight for you. ---
**Author:** ![Sternvogel](https://avatars.discourse-cdn.com/v4/letter/s/bc79bd/32.png) [@Sternvogel](https://boards.straightdope.com/u/Sternvogel)\ **Post date:** [May 20, 2009, 8:48pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/51 "2009-05-20T20:48:44Z")
1. Rubber bands 2. Paper clips 3. Pencils and pens 4. Loose change 5. Scrap paper 6. Loose buttons 7. Twistie ties 8. Photos 9. Refrigerator magnets 10. Coupons Not sure how this is going to be scored, but I’ll defer to whichever method the Feudmistress selects… ---
**Author:** ![tarragon918](https://avatars.discourse-cdn.com/v4/letter/t/d26b3c/32.png) [@tarragon918](https://boards.straightdope.com/u/tarragon918)\ **Post date:** [May 20, 2009, 9:03pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/52 "2009-05-20T21:03:35Z")
1. scissors 2. thread 3. deck of cards 4. sewing needle 5. stamps 6. pens 7. pencils 8. note paper 9. magnets 10. junk mail LOL Fun! ---
**Author:** ![swampbear](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/swampbear/32/467_2.png) [@swampbear](https://boards.straightdope.com/u/swampbear)\ **Post date:** [May 20, 2009, 9:07pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/53 "2009-05-20T21:07:46Z")
1. Scissors 2. Tape 3. Ink pens 4. Screw driver 5. Paper clips 6. Rubber bands 7. Keys 8. Miscellaneous nuts, bolts and screws 9. Postits or other note paper 10. Glue The other miscellaneous items in the swampjunk drawer include return addess labels, a wrench, a thermometer, a refrigerator magnet shaped like a man’s naughty parts, and what appears to be either the hope diamond or a glass doorknob. No I do not know why I have a diamond/doorknob in there. I just do. I treasure it. ---
**Author:** ![Sternvogel](https://avatars.discourse-cdn.com/v4/letter/s/bc79bd/32.png) [@Sternvogel](https://boards.straightdope.com/u/Sternvogel)\ **Post date:** [May 20, 2009, 9:09pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/54 "2009-05-20T21:09:51Z")
> [@Miller](#): > > 1. Tape > > 2. Tape Hedley Lamarr: You said “tape” twice. **Miller** : [I like tape.](http://www.youtube.com/watch?v=7Zby1-1ylD0) ---
**Author:** ![notfrommensa](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@notfrommensa](https://boards.straightdope.com/u/notfrommensa)\ **Post date:** [May 20, 2009, 9:41pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/55 "2009-05-20T21:41:27Z")
> [@Sternvogel](#): > > Hedley Lamarr: You said “tape” twice. > > **Miller** : [I like tape.](http://www.youtube.com/watch?v=7Zby1-1ylD0) Charming ---
**Author:** ![Fretful\_Porpentine](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/fretful_porpentine/32/2873_2.png) [@Fretful\_Porpentine](https://boards.straightdope.com/u/Fretful_Porpentine)\ **Post date:** [May 20, 2009, 10:37pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/56 "2009-05-20T22:37:37Z")
1. rubber bands 2. twist-ties 3. magnets 4. pens 5. paper clips 6. stamps 7. screws 8. lip balm 9. tape 10. loose change ---
**Author:** ![anyrose](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@anyrose](https://boards.straightdope.com/u/anyrose)\ **Post date:** [May 20, 2009, 11:47pm UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/57 "2009-05-20T23:47:31Z")
1. rubber bands 2. twist ties 3. matchbooks 4. paperclips 5. grocery receipts 6. emery boards 7. unused chopsticks 8. plastic spoons 9. packets of sugar 10. old keys ---
**Author:** ![De\_La\_Rue](https://avatars.discourse-cdn.com/v4/letter/d/d07c76/32.png) [@De\_La\_Rue](https://boards.straightdope.com/u/De_La_Rue)\ **Post date:** [May 21, 2009, 1:28am UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/58 "2009-05-21T01:28:16Z")
1. A roll of tape 2. A screwdriver 3. Washers 4. Tacks 5. Those soft pads you stick to things so they won’t scratch surfaces 6. String 7. Scissors 8. Nail clippers 9. Wire 10. Coins ---
**Author:** ![mshar253](https://avatars.discourse-cdn.com/v4/letter/m/6de8d8/32.png) [@mshar253](https://boards.straightdope.com/u/mshar253)\ **Post date:** [May 21, 2009, 1:34am UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/59 "2009-05-21T01:34:40Z")
1. Pen 2. Pencil 3. Stapler 4. Tape 5. Notepad 6. Coupons 7. Business cards 8. Ruler 9. Rubber bands 10. Glue ---
**Author:** ![Baker](https://avatars.discourse-cdn.com/v4/letter/b/bb73d2/32.png) [@Baker](https://boards.straightdope.com/u/Baker)\ **Post date:** [May 21, 2009, 1:43am UTC](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069/60 "2009-05-21T01:43:03Z")
1. Pencils 2. Rubberbands 3. Paper clips 4. Batteries 5. Twist ties 6. Pens 7. Pencil sharpeners 8. Deck of cards 9. Scissors 10. Ruler [Previous page](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069.md?page=2) [Next page](https://boards.straightdope.com/t/the-feud-items-in-a-junk-drawer-game-over/497069.md?page=4)