Holey, holey, holey, or Spreadsheet Meets Shopsmith
Moderators: HopefulSSer, admin
Holey, holey, holey, or Spreadsheet Meets Shopsmith
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.
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. I used some spacers against the fence to move to the next row. And so on for the grid. 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. 8 sets for 816 holes in all, including the larger ones. POP! Goes the balloon
I used the fence to keep the first row of holes aligned.
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. I used some spacers against the fence to move to the next row. And so on for the grid. 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. 8 sets for 816 holes in all, including the larger ones. POP! Goes the balloon
Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith
Ingenious!
Mike
Mike
- 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
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!
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'/ 10E[/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
╟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'/ 10E[/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
Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith
Ditto!Mike907 wrote:Ingenious!
Mike
- 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
Outstanding!
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
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
- 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
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.Mike907 wrote:Ingenious!
Mike
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.
Dusty
Sent from my Dell XPS using Firefox.
Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith
I, too, love this post! Wow, now I'm thinking of one of those engine-turned metal (damaskeened) jobs....
Chris
Chris
Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith
Well done and excellent explanation!
Re: Holey, holey, holey, or Spreadsheet Meets Shopsmith
Dusty,dusty wrote: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.Mike907 wrote:Ingenious!
Mike
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.
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.
- 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
Thanks. It works perfectly.
"Making Sawdust Safely"
Dusty
Sent from my Dell XPS using Firefox.
Dusty
Sent from my Dell XPS using Firefox.