Holey, holey, holey, or Spreadsheet Meets Shopsmith

Forum for people who are new to woodworking. Feel free to ask questions or contribute.

Moderators: HopefulSSer, admin

Post Reply
User avatar
rutpoule
Gold Member
Posts: 25
Joined: Thu May 28, 2015 10:59 am
Location: Rochester, MN

Holey, holey, holey, or Spreadsheet Meets Shopsmith

Post by rutpoule »

I got commissioned by my sons' science teacher to create some bed-of-nails balloon poppers for their class. It's a board with a bunch of holes you can put different patterns of nails into and then see what arrangements pop the balloon sooner or later, and how much force it takes. When the teacher showed me the one she had and asked if I could make 8 more, my first thought was, "That's a lot of holes!". I needed to come up with an accurate but quick setup. I started by printing a spreadsheet with gridlines at the spacing I needed. I just went to the formatting options and set the row height and column width to my hole spacing, and set inside and outside borders on the cells. I then set the print options to print empty cells and printed out one page. I taped this to the table and aligned it with the original kit the science teacher gave me and marked the spreadsheet where the corner of board would be to drill the first hole.
0822151708.jpg
0822151708.jpg (195.2 KiB) Viewed 8719 times
I used the fence to keep the first row of holes aligned.
0822151710.jpg
0822151710.jpg (212.71 KiB) Viewed 8719 times

By moving the board over to the next row of the spreadsheet, I got a line of holes, as precisely spaced as I needed them.
0822151711.jpg
0822151711.jpg (203.84 KiB) Viewed 8719 times
I used some spacers against the fence to move to the next row.
Picture.jpg
Picture.jpg (203.15 KiB) Viewed 8719 times
And so on for the grid.
0822151707.jpg
0822151707.jpg (212.71 KiB) Viewed 8719 times
Because the rows were offset, I decided to do them by setting up two overlapping grids. I just re-positioned the paper the same way to do the grid for the offset holes.
0822151737.jpg
0822151737.jpg (210.8 KiB) Viewed 8719 times
8 sets for 816 holes in all, including the larger ones.
0822152043.jpg
0822152043.jpg (141.5 KiB) Viewed 8719 times
POP! Goes the balloon
0822152100.jpg
0822152100.jpg (166.83 KiB) Viewed 8719 times
Mike907
Platinum Member
Posts: 548
Joined: Fri Nov 09, 2012 2:02 am
Location: Anchorage, AK

Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith

Post by Mike907 »

Ingenious!

Mike
User avatar
JPG
Platinum Member
Posts: 34648
Joined: Wed Dec 10, 2008 7:42 pm
Location: Lexington, Ky (TAMECAT territory)

Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith

Post by JPG »

Use the first as a pattern for all the rest? - Or drill them all at once? ;)




SPOILER ALERT!!!!!



A 'pattern' of a single nail pops easiest!
╔═══╗
╟JPG ╢
╚═══╝

Goldie(Bought New SN 377425)/4" jointer/6" beltsander/12" planer/stripsander/bandsaw/powerstation /Scroll saw/Jig saw /Craftsman 10" ras/Craftsman 6" thicknessplaner/ Dayton10"tablesaw(restoredfromneighborstrashpile)/ Mark VII restoration in 'progress'/ 10
E[/size](SN E3779) restoration in progress, a 510 on the back burner and a growing pile of items to be eventually returned to useful life. - aka Red Grange
User avatar
Bruce
Platinum Member
Posts: 884
Joined: Sun Aug 27, 2006 10:31 pm
Location: Central MO

Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith

Post by Bruce »

Mike907 wrote:Ingenious!

Mike
Ditto!
User avatar
rjent
Platinum Member
Posts: 2121
Joined: Fri Mar 14, 2014 3:00 pm
Location: Hot Springs, New Mexico

Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith

Post by rjent »

Outstanding! :cool:
Dick
1965 Mark VII S/N 407684
1951 10 ER S/N ER 44570 -- Reborn 9/16/14
1950 10 ER S/N ER 33479 Reborn July 2016
1950 10 ER S/N ER 39671
1951 jigsaw X 2
1951 !0 ER #3 in rebuild
500, Jointer, Bsaw, Bsander, Planer
2014 Mark 7 W/Lift assist - 14 4" Jointer - DC3300
And a plethora of small stuff .....

"The trouble with quotes on the Internet is that you can never know if they are genuine." - Benjamin Franklin
User avatar
dusty
Platinum Member
Posts: 21371
Joined: Wed Nov 22, 2006 6:52 am
Location: Tucson (Wildcat Country), Arizona

Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith

Post by dusty »

Mike907 wrote:Ingenious!

Mike
Ingenious is an understated to say the least. I just have to ponder this to see how many other ways there might be to approach this sort task.

Now then - getting something printed that matches a specific spacing pattern might be a computer/printer chore. I have not had good luck getting scaled drawings printed on my printer. It is easy to creat the pattern using Sketchup. Getting that pattern to pring to scal - I have had no success.

But I say again - absolutely super ingenious.
"Making Sawdust Safely"
Dusty
Sent from my Dell XPS using Firefox.
User avatar
nuhobby
Platinum Member
Posts: 2334
Joined: Fri Sep 21, 2007 4:34 am
Location: Indianapolis

Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith

Post by nuhobby »

I, too, love this post! Wow, now I'm thinking of one of those engine-turned metal (damaskeened) jobs....

Chris
User avatar
peterm
Platinum Member
Posts: 576
Joined: Mon Jan 18, 2010 2:52 pm
Location: Dartmouth, NS, Canada

Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith

Post by peterm »

Well done and excellent explanation!
User avatar
tdubnik
Platinum Member
Posts: 545
Joined: Wed Nov 12, 2008 8:04 am
Location: Talmo, GA

Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith

Post by tdubnik »

dusty wrote:
Mike907 wrote:Ingenious!

Mike
Ingenious is an understated to say the least. I just have to ponder this to see how many other ways there might be to approach this sort task.

Now then - getting something printed that matches a specific spacing pattern might be a computer/printer chore. I have not had good luck getting scaled drawings printed on my printer. It is easy to creat the pattern using Sketchup. Getting that pattern to pring to scal - I have had no success.

But I say again - absolutely super ingenious.
Dusty,

Check out this http://www.ozbotz.org/print-actual-size-in-sketchup/ to print to scale from Sketchup. I print to scale quite often when I make turning templates and it works every time.
User avatar
dusty
Platinum Member
Posts: 21371
Joined: Wed Nov 22, 2006 6:52 am
Location: Tucson (Wildcat Country), Arizona

Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith

Post by dusty »

Thanks. It works perfectly.
"Making Sawdust Safely"
Dusty
Sent from my Dell XPS using Firefox.
Post Reply