Page 1 of 1

Holey, holey, holey, or Spreadsheet Meets Shopsmith

Posted: Tue Aug 25, 2015 8:25 pm
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 8751 times
I used the fence to keep the first row of holes aligned.
0822151710.jpg
0822151710.jpg (212.71 KiB) Viewed 8751 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 8751 times
I used some spacers against the fence to move to the next row.
Picture.jpg
Picture.jpg (203.15 KiB) Viewed 8751 times
And so on for the grid.
0822151707.jpg
0822151707.jpg (212.71 KiB) Viewed 8751 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 8751 times
8 sets for 816 holes in all, including the larger ones.
0822152043.jpg
0822152043.jpg (141.5 KiB) Viewed 8751 times
POP! Goes the balloon
0822152100.jpg
0822152100.jpg (166.83 KiB) Viewed 8751 times

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

Posted: Tue Aug 25, 2015 8:45 pm
by Mike907
Ingenious!

Mike

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

Posted: Tue Aug 25, 2015 8:57 pm
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!

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

Posted: Tue Aug 25, 2015 9:15 pm
by Bruce
Mike907 wrote:Ingenious!

Mike
Ditto!

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

Posted: Tue Aug 25, 2015 10:32 pm
by rjent
Outstanding! :cool:

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

Posted: Wed Aug 26, 2015 3:51 pm
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.

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

Posted: Wed Aug 26, 2015 3:57 pm
by nuhobby
I, too, love this post! Wow, now I'm thinking of one of those engine-turned metal (damaskeened) jobs....

Chris

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

Posted: Thu Aug 27, 2015 9:51 am
by peterm
Well done and excellent explanation!

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

Posted: Fri Aug 28, 2015 5:46 am
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.

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

Posted: Fri Aug 28, 2015 8:00 am
by dusty
Thanks. It works perfectly.