superfrog
This is merely a joke.
I've had this linked in my signature for a while, but I've only made a handful of scattered posts about it on the forums, so here's a thread to point people to! I'll add FAQs in the OP here and I'd be glad to take suggestions on how to improve the sheet for general use.
To better understand how to use the spreadsheet, you should know how one of the prefilled links is built. Here's an example of a URL:
The gray parts are there in every URL for every game. The blue part tells the website which chat log to pull up, and the magenta part tells the website what Google Drawing to pull up.
To make the sheet go, you have to tell it the name of your game, and the URL of your Google Drawing. The spreadsheet then takes the specific information it needs and glues it all together with the gray parts into one cohesive URL.
How to Set Up and Share a Game
Troubleshooting
My friend can't see the Google Drawing or is getting an error.
Go to the sharing settings and make sure it's set up as "anybody with the link can edit".
It took me to a different map and chat than it was supposed to!
Just log out and try again. It happens sometimes, especially if you've been spectating other games.
Somebody else is trying to use the spreadsheet at the same time as me!
I'd suggest making a copy of this for your own personal use if you use it frequently.
Where do I get figures?
Go back to that Online Heroscape: Maps and Figures link. Every official unit, C3V unit, and SoV unit is there, as well as many C3G units. Just copy and paste them in.
To better understand how to use the spreadsheet, you should know how one of the prefilled links is built. Here's an example of a URL:
The gray parts are there in every URL for every game. The blue part tells the website which chat log to pull up, and the magenta part tells the website what Google Drawing to pull up.
To make the sheet go, you have to tell it the name of your game, and the URL of your Google Drawing. The spreadsheet then takes the specific information it needs and glues it all together with the gray parts into one cohesive URL.
How to Set Up and Share a Game
- Open heroscapers.com/ohs
- In another tab, find a map you'd like to play on from Online Heroscape: Maps & Figures
- Hit File > Make a copy and then close the original map
- In another tab, open the spreadsheet
- Copy and paste the URL of the map you're using into cell B1
- Copy and paste the Finished Google Doc String from cell E3 into the appropriate box on the OHS site
- Put in your username, leave the game name blank, and create the game.
- Copy and paste the Game Name from newly created game to cell B5 of the spreadsheet.
- At this point, cell B7 should be fully populated. It's now ready to copy and paste into a PM or Facebook message or email or discord server for anybody to enjoy.
Troubleshooting
My friend can't see the Google Drawing or is getting an error.
Go to the sharing settings and make sure it's set up as "anybody with the link can edit".
It took me to a different map and chat than it was supposed to!
Just log out and try again. It happens sometimes, especially if you've been spectating other games.
Somebody else is trying to use the spreadsheet at the same time as me!
I'd suggest making a copy of this for your own personal use if you use it frequently.
Where do I get figures?
Go back to that Online Heroscape: Maps and Figures link. Every official unit, C3V unit, and SoV unit is there, as well as many C3G units. Just copy and paste them in.
Last edited:
