My SNES ascii pad. I LOVE that thing!!
My SNES ascii pad. I LOVE that thing!!
Blowing on cartridges since 1987
One of my favorites WAS my Viewtiful Joe bobblehead that I got for pre-ordering the game. A few years ago my cat(who is sitting next to me right now), knocked it off my entertainment center and busted it wide open. I was so pissed at him for like a week or two. I even remember kind of wishing he had broken my Spirited Away figurine that I spent $80 on at Disney World instead of Joe haha.
I don't collect very much memorabilia, but I do have a few things here and there. I really like my imported Super Castlevania IV soundtrack. I also have a cool Link and Epona(plastic) figurine and a Samus bobblehead that I'm pretty proud of.
Me blog, Halcyon GamingI'm just a simple man trying to make my way in the universe.
Me Youtube, Captain Natron
One thing comes to mind within all my stuff..I have this Metal Gear Solid(PS)Army type Hat and Dog Tags hanging up that I forget where it came from..
I used to wear the dog tags back in the..
Get the Reference
Probably my 24" Donkey kong plushy stuffed animal thing.
MY YOUTUBE CHANNEL:
http://www.youtube.com/user/atarileaf
Originally Posted by Natty Bumppo
Wow. How on Earth did you manage to make Hexagons in Excel?!
Happy retirement. I certainly know that I have more than enough retro games and other neat-o projects to delve into than the number of hours in the average remaining life-span (even without my day job). So much to do, so little time....
My favorite thing is my Revolution X arcade cabinet that I converted into a storage unit for all my video games with shelves in the side of the cabinet and drawers in the coin return doors.
“The world has, forever and always, been brimming with shit-heads.” - Dana Gould
We are going to breakfast in a few minutes so I can't go into it right now - but I can describe it to you in more detail later - you have to really manipulate things but it is possible. And like so many things in excel once you modify the spreadsheet fully (column and row widths) and create a few hexes it goes pretty quickly since you just copy things adnauseum.
The hexes aren't perfect but they are pretty darn close. You can really only make one size on the spreadsheets but you can print out whatever size you want (I prefer 11x17 size printouts) depending on your printer.
I love excel! (I Like Lotus a lot better but that is a story for another day.)
Thanks - I am really looking forward to retirement - so many games, books and movies to plow through. So much yard work and home improvment projects (we just paid off the house so that has free up inceome for these).
When I come home from a long day in Hell, there's nothing I'd rather reach for than a fire-brewed bottle of Styx Beer. Made from the filthiest waters from our own River Styx. Styx Beer is a third more toxic than any other regular beer. The worst beer - the filthiest beer - the deadliest beer. It's Styx Beer!
The model of the R-9 that came with R-Type Command (Tactics in Japan) on PSP for those that pre-ordered, or often even if you did not.
Even if you didn't like R-Type Command, the model and the CG intro were worth the price of entry alone. Think of the game itself as a bonus. I loved it though.
Last edited by parallaxscroll; 10-20-2013 at 09:46 AM.
The first thing you need to do is change your column widths (you will wind up with three columns for each hex). the first column should be 1, the second should be 1.43. Repeat ad nauseum till you have enough. (There is a command that allows you to repeat column width patterns - makes it a lot easier.) The rows should be set at 14.5 height. You will need two rows for each hex on the edge of your map.
There is another commmand that allows you to change the orientation of the grid lines. The first cell should be set up so the grid line (not a text entry) should be /. the next should be the normal line at the top of the cell. the third should be \.
The middle (larger) cell immediately below will form the bottom half of the hex. Set your grid to look like this: \___/.
Once you have the first hex done, simply copy to make however many you want downwards.
Then copy that group of hexes over the third (a small width) column (shifting down one row) and you have the next set of hexes. Then copy those two groups and repeat until you have enough for your needs.
I like to keep a blank map with the grids at the start of the workbook - then you can just create a new one for each sheet that you create in the workbook as you go along. Helps to name them too so they are to reference them when you want to.
------------------------------------------------------------
Assuming this all worked right - it takes a bit of practice but once you have your first two columns (of hexes - not columns on excel) you are pretty much home free for that part of the project.
You hexes will have four cells that be colored or patterned as cells normally are. You can add letters or numbers in the middle upper cell and the lower cell of each hex - you can also orient then at an anlge if you wish - I did this in the dark wizard maps for the towns and castle names and made a legend on the edge of the map (in regular cells, not hexed ones). For dark wizard for the shrines and secret places I used two colors - the middle upper cell was one color and the other 3 were another. Made a pretty neat looking hex that had a triangular patch on the top half of the hex. I also added those to the legend at the side of the map.
You can copy the filled cells that you have created over - I did have some trouble with artifacting occurring when I copied filled hexes - grid lines would sometimes disappear and some portions of hexes would wind up the wrong color. I found it easier to fix them immediately as they occurrred - just basically recopying just the cells I needed to fix rather than the whole hex.
You can add roads and bridges by using the shape commands and using their lines. I don't like the way they are set up on the menu plus they are cumbersome to use and you can't really copy them - you have to create a new one for each road segment (you are pretty much stuck with straight lines - you can kinda draw them freehand but I couldn't get them to look decent at all. Maybe I am just not artistic enough.
You are pretty much stuck with one size hex on the worksheets - trying to increase the sizes on the cells/columns/rows didn't seem to look very good to me - but you can of course increase the size of your maps when you print them - I prefer mine on 11x17 - but 8x11s are nice because you can fit them in a loose leaf binder.
(Since you are using a lot of memory here, the printing can take a while.)
That is about it from what I can remember - I haven't had to make a new sheet in awhile since I just take an exisiting blank one and modify it as I need for new maps. Plus I haven't had the time to start a new project.
Last edited by Natty Bumppo; 10-20-2013 at 02:12 PM.
When I come home from a long day in Hell, there's nothing I'd rather reach for than a fire-brewed bottle of Styx Beer. Made from the filthiest waters from our own River Styx. Styx Beer is a third more toxic than any other regular beer. The worst beer - the filthiest beer - the deadliest beer. It's Styx Beer!
Mine would have to be this:
"What is a man? A miserable little pile of secrets! But enough talk... Have at you!"
My feedback thread: http://www.digitpress.com/forum/showthread.php?t=93213
one of my favs but not the fav....
wireless 2600 joysticks....
because the wires weren't long enough apparently....fuck yea
Hmm, probably my Rival Schools standee. I got it in the late '90s from an Electronics Boutique that had it on display. I was friends with the guys there and just asked them if I could have it when they were done with it. The manager surprised me and said I could have it that night!
I'd say my Lego Lord of the Rings store standee as well as my Dragon Quest 25th anniversary book in Japanese and my DQ 25th anniversary 950-piece jigsaw puzzle containing the series' bestiary. I'm at work, so I can't take pics, but here are images of the two DQ items in question:
http://www.akadot.com/dragon-quest-2...o-p-37286.html
http://www.amazon.com/Dragon-anniver.../dp/B0078IY7T2
Wow that is cool,I have good memories of playing Rival Schools on the Ps1,not as good as as my Lunar Rescue arcade game knitting pattern thoughHmm, probably my Rival Schools standee. I got it in the late '90s from an Electronics Boutique that had it on display. I was friends with the guys there and just asked them if I could have it when they were done with it. The manager surprised me and said I could have it that night!
YES. Seeing your Samurai Showdown machine blew me away and inspired me to hunt one down myself. Such an awesome, functional collection piece.
Some of my favorites that aren't a game.
Videogame themed slot machines. Also got a couple more based on other NeoGeo franchises (Metal Slug, King of Fighters, Fatal Fury, etc)
Sonic the Hedgehog Pachinko machine:
Ghosts n Goblins, Ghouls n Ghosts and Super Dodgeball boardgames:
King of Fighters and Street Fighter Alpha 2 store display standees
.
__________________________________________________ ___
[ Severely Outdated Game Collection Pics ]
[ My Multi-screen MADNESS!! ]
Posting Permissions
FTC Disclosure Notices:
This site contains affiliate links for which I may be compensated. As an eBay Partner, I may be compensated if you make a purchase.
As an Amazon Associate I earn from qualifying purchases.
Similar agreements apply to other advertising or affiliate programs such as those from Google, etc.
Copyright © 1991 - Present Digital Press. All rights reserved.
Reply With Quote
