SC2Mapster Wiki
Explore
Main Page
All Pages
Interactive Maps
navigation
Main page
Community portal
Recent changes
Random page
Help
SC2MAPSTER
News
Maps
Assets
Teams
Authors
Forums
Paste
Gamepedia
Gamepedia support
Report a bad ad
Help Wiki
Contact us
FANDOM
Fan Central
BETA
Games
Anime
Movies
TV
Video
Wikis
Explore Wikis
Community Central
Start a Wiki
Don't have an account?
Register
Sign In
Sign In
Register
SC2Mapster Wiki
1,003
pages
Explore
Main Page
All Pages
Interactive Maps
navigation
Main page
Community portal
Recent changes
Random page
Help
SC2MAPSTER
News
Maps
Assets
Teams
Authors
Forums
Paste
Gamepedia
Gamepedia support
Report a bad ad
Help Wiki
Contact us
Editing
Tutorials/Simplified Heatmaps using Excel
(section)
Back to page
Edit
VisualEditor
View history
Talk (0)
Edit Page
Tutorials/Simplified Heatmaps using Excel
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
===Create a spreadsheet document=== Create a spreadsheet document. I am using Excell 2003, but you can probably use OpenOffice or similar. From inside the document, open the textfiles. You might have to change the filetype to "any" to find the .txt files. During importing there are two things to do: Pic8. Designating a tab delimiter. I'm using the swedish version, but you hopefully get the idea. 1. Set the tab delimiter marker to semicolon [;] (or the delimiter you decided to use in the editor). Pic9. If I set the settings to "Allmänt" which means "common" or "default", the importer tells me that it will convert textfields with "number" letters into number values. 2. Try to make sure the columns that contain numbers, such as coordinates, are imported as number values. When it looks ok, import. To double check that the import went well: try to sum up to value cells. If the result is calculated, then they are numbers. If not, you will need to convert the values from text type into value types. Search online if you don't already know how to do this. Once you have the file imported and numbers interpreted as numbers, repeat this step for all the debug files.
Summary:
Please note that all contributions to the SC2Mapster Wiki are considered to be released under the CC BY-NC-SA
Cancel
Editing help
(opens in new window)
Follow on IG
TikTok
Join Fan Lab