Roll20 Tips and Tricks (Innovative Solutions to Common Problems)

Walrus said:
Holy Crap, Keith! This is awesome.

keithcurtis said:

cargo cultist of scripters.

Doug E. said:

Keithcurtis the Tricksomancer. 

Invisible Tokens - The Notes Token (API version)

OPTIONAL FOOTER
My personal Info tokens always have a footer at the bottom which gives me more options by calling a few more scripts. The footer is an option in Supernotes. (note: the screen shots below are from an older version of the script, but the upshot is the same.)

What do the script do?
The upshot of adding this script is that when you call the notes token, you will get this:

Clicking the "Bio to GM" link sends this (abbreviated for length in the screen shot):
Clicking the "To players" button sends the same info to the players instead.

Invisible Tokens - The Control Token

Description
The ceiling of this chamber is filled with numerous holes through which the goblins can rapidly empty a cistern of acid into the room below.
Detection
The holes are cunningly disguised and require a specific DC 15 Investigation roll to be discovered. Any character proceeding more than ten feet into the room will trigger the trap and have gallons of acid poured upon them, covering the floor with several feet of the substance.
Damage
Once the trap is triggered, any character in the area can take half damage with a DC15 Dexterity saving throw. Failure deals [[6d6]] acid damage.
Any character who ends their turn in the resulting pool of acid will need to make a DC15 Con save or also take [[6d6]] points of acid damage. In either case, success indicates half damage.
[REVEAL ACID PIT](!token-mod --ids -LC7WuFLtQAzi5Y3R6_B --ignore-selected --set layer|map)
[HIDE ACID PIT](!token-mod --ids -LC7WuFLtQAzi5Y3R6_B --ignore-selected --set layer|gmlayer)

Controlling an unselected object

Some of these tricks work on tokens that are on other layers, the map layer for example. The token mod examples in the code work on the token id, shown by the --ids option. To get the token id of any graphic, just select it and run @{selected|token_id} in the chat panel. It will return the token id that you can past into your macro. Remember to get the beginning hyphen—that's part of the code.

Just remember, anything you can do with a script call, you can put into a control token.

keithcurtis said:

Anthony, is that the OGL template? I'm not familiar enough with it to know what the formatting is supposed to look like. One of the problems looks like hard line breaks. I'm assuming this was written in another editor and pasted into Roll20? PM me your edited code for GM note and the text for the token, and I'll pop into my test OGL game tonight and check them out.

URIError: URI malformed
    at decodeURIComponent (<anonymous>)
    at _.chain.map.reject.reject.each.o (apiscript.js:8190:79)
    at Function._.each._.forEach (/home/node/d20-api-server/node_modules/underscore/underscore.js:182:9)
    at _.(anonymous function) [as each] (/home/node/d20-api-server/node_modules/underscore/underscore.js:1635:39)
    at apiscript.js:8185:24
    at eval (eval at <anonymous> (/home/node/d20-api-server/api.js:151:1), <anonymous>:65:16)
    at Object.publish (eval at <anonymous> (/home/node/d20-api-server/api.js:151:1), <anonymous>:70:8)
    at /home/node/d20-api-server/api.js:1634:12
    at /home/node/d20-api-server/node_modules/firebase/lib/firebase-node.js:93:560
    at hc (/home/node/d20-api-server/node_modules/firebase/lib/firebase-node.js:39:147)

on('ready',()=>{

    const blockElements = [
        'p', 'h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'ol', 'ul', 'pre', 'address',
        'blockquote', 'dl', 'div', 'fieldset', 'form', 'hr', 'noscript', 'table','br'
    ];
    const rStart=new RegExp(`<\\s*(?:${blockElements.join('|')})\\b[^>]*>`,'ig');
    const rEnd=new RegExp(`<\\s*\\/\\s*(?:${blockElements.join('|')})\\b[^>]*>`,'ig');

    const getLines = (str) => 
        (rStart.test(str)
            ? str
                .replace(/[\n\r]+/g,' ')
                .replace(rStart,"\r$&")
                .replace(rEnd,"$&\r")
                .split(/[\n\r]+/)
            : str
                .split(/(?:[\n\r]+|<br\/?>)/)
            )
            .map((s)=>s.trim())
            .filter((s)=>s.length)
            ;
    const cmdRegex = /^!(w?)gmnote(?:-(.*))?$/i;

    on('chat:message',(msg) => {
        if('api' === msg.type && cmdRegex.test(msg.content) && playerIsGM(msg.playerid) ){
            let match=msg.content.match(cmdRegex),
                output = match[1].length ? '/w gm ' : '',
                regex;

            if(match[2]){
                regex = new RegExp(`^${match[2]}`,'i');
            }
                                
            _.chain(msg.selected)
                .map( s => getObj('graphic',s._id))
                .reject(_.isUndefined)
                .reject((o)=>o.get('gmnotes').length===0)
                .each( o => {
                    if(regex){
                        let lines = _.filter(
                            getLines(unescape(o.get('gmnotes'))),
                            (l) => regex.test(l.replace(/<[^>]*>/g,''))
                        ).join('<br>');
                        sendChat(o.get('name'), `${output}${lines}`);
                    } else {
                        sendChat(o.get('name'), `${output} &{template:spell}}{{name=${unescape(o.get('gmnotes')).replace(/(?:[\n\r]+|<br\/?>)/g,'<br>')} }}`);
                    }
                });
        }
    });
});

Inivisible Tokens — The Door Control

Invisible Tokens - Invisible Creatures

!token-mod --set currentside|1
!token-mod --set showplayers_name|yes

Anthony V. said:

Random Images (AKA special Dice Images)

I realized today while responding to another thread that this trick, originally by Silvyre I believe, hasn't made it into the thread yet (at least I don't think it has).

This trick takes a little prep work, but it allows you to display images corresponding to a dice roll in chat. You could replicate this with a straight table roll:

/r 1t[table-with-images]

but this requires you to use the slash command syntax for the image to display, which is not very stylish in my opinion; and requires setup of a rollable table which requires you to be a GM.

This method displays much nicer than doing it via rollable table would. Additionally, rollable tables can't display images when rolled inline.

1. Upload your images somewhere that the image can be accessed via a direct link. The Roll20 Library (although difficult to work with), imgur, giphy, using rawgit to access github hosted images, or something similar.
2. Next we need a link shortening site that allows custom names. Tinyurl or bit.do as examples
3. I'm going to use these four images: 1 2 3 4. The short url for which is http://tiny.cc/image_swap_demo_#
4. Then make your macro:

[Image[[](http://tiny.cc/image_swap_demo_[[1d4]]#.gif)

The double open brackets in the image title (i.e. [image[[]) are there to force the dice roll to display as plain text so that the link works correctly.

This will give you an image based on your die roll:

*Images are from Paizo's Starfinder rule books (Alien Archive and Pact Worlds). Used for demonstration purposes only. Paizo retains all rights

I've done it with .png's here, but it works with .gifs as well (and in fact, you can see that is what I used as the file type extension in the link (i.e. #.gif). As an added bonus, this method means that you just need to copy your macro between games instead of having to deal with recreating a rollable table in the new game, or having to ask your GM to setup a rollable table for you.

Very clever. What do you use this for in play? I can see that it might be a way to roll custom dice faces in chat, or randomly display weather graphics.

Weather and setting images for random maps is what I've typically used it for. The thread that reminded me I needed to add this was looking for a way to show a random gif for spell effects (e.g. fireball 1, fireball 2, etc).

Pretty cool Scott! :D

Access the Old Library Management Tool

After the Art Library Rework Update in July 2016, the external access to our libraries disappeared from the main site. The update did make in game library management much better, but sometimes you just need to access your library or do some bulk management. In these cases, I was always wishing that the external management tool was still available. The secret is that it is still available, although no longer officially supported. You can access the external view of your art library at this link:

https://marketplace.roll20.net/library/

There are some caveats, which are also blatantly noted when you access the external view:

• The external view is deprecated and no longer supported - It is possible that some future update will cause this to no longer interact properly with your actual in game library
• Roll20 has already officially said that the external view is no longer available, so this may disappear without notice

It appears the trick for the line breaks has been removed from the Map Names, although I have yet to try turning the

• Map<br>Name

into a

• Map<br />Name

Blue64 said:

It appears the trick for the line breaks has been removed from the Map Names, although I have yet to try turning the

• Map<br>Name

into a

• Map<br />Name

When you've got something concrete (and the editor dust has settled, maybe shoot a PM at OldSchoolChris so they can edit their post.

Poltergeisha's Roll20 Like A Boss

I've spent way too many hours tweaking and perfecting my Roll20 setup to flow like a symphony during my D&D 5e games. I hope that the documentation here will help you also become a Master of Roll20, so the inordinant amount of time I've spent on this isn't a complete waste.

Here you can learn how to organize your macros and how best to distribute them to players, as well as all of the scripts and macros I use and how I use them.

Forum Link

Thanks Poltergeisha. I put it in with the other "sources of tips and tricks", like the Aaron's Roll20 Enhancement Pack.

Poltergeisha said:

Poltergeisha's Roll20 Like A Boss

I've spent way too many hours tweaking and perfecting my Roll20 setup to flow like a symphony during my D&D 5e games. I hope that the documentation here will help you also become a Master of Roll20, so the inordinate amount of time I've spent on this isn't a complete waste.

Here you can learn how to organize your macros and how best to distribute them to players, as well as all of the scripts and macros I use and how I use them.

Click Here

I would like to point out that Standard 5e Rule Set says that you only recover "up to half of your Hit Dice" so the math for that would actually be something along the lines of

• [[ (floor( @{target|Long Rest|hd|max} /2) ) + @{target|Long Rest|hd} ]]

Might wanna double check your Macros Page and make sure that the Hit Dice is working correctly

Also, you forgot to disclaimer before your Link that most of those use the API Scripts, which is not a Free User perk.

Also, /emas is a GM/DM Tier Command, any Player using it will receive the same error as /desc you should look into changing it to /em which is available to Players.

Hmm. Poltergeisha, since your tip is actually a very complex set of interlocking ideas that already has a dedicated forum page, could you change your post to have the link go to that thread rather than directly to the GIthub page? It will keep all of your feedback in one place and preserve the focus of the Stupid Tricks thread.

Quick Play: Room Specific Music

Using a couple of already available API scripts and a simple Macro, I am able to play room specific songs from links directly on the map. For example if I use a pre-built module many of the rooms have numbered tokens sitting on the GM Layer of the map. I am able to click the token number for the room and play a specific song/track quickly. 

Requires: Roll20 AudioMaster API and Bump API . Both are available in the scrip library. 

1. Create a macro that uses Roll20 AudioMaster to play a track. The very basic macro might look like this:" !roll20AM --play|@{selected|token_name}"  Note I use an"@selected|token_name" in place of the "AUDIO TRACK" to be played. Be sure to select Show as Token Action on the macro.

Roll20 AudioMaster script allows control of the jukebox via the chat interface and expands upon the standard jukebox functionality with some additional commands.

2. Drop a new token or use an existing token that has No Name onto the GM Layer. Enter the name of the Audio Track from your JukeBox as the name of the Token. For example: Roll20 - Chase  by Kruggly

3. Use BUMP API script  to make the Token interactive for the GM from the Token Layer. The token will still be invisible to players  even though it sits on the GM Layer. There are a lot of other uses for BUMP so if you haven't check it out for sure. THANKS to @The Aaron for all his work. 

Bump provides a way to invisibly manipulate tokens on the GM Layer from the Objects Layer, and vice versa.
When a token is added to Bump a slave token is created that mimics everything about to master token. The slave token is only visible to the GM and has a color on it to show if the master token is on the GM Layer or the Objects layer. Moving the slave token will move the master token and vice versa. The slave token represents the same character as the master token and changes on the slave token will be reflected on the master token

4. When you are playing all you have to do is select the token and hit the PlayRooomMusic Token Action Button. The script reads the name of the Toke and the Song/Track to play.  I also use other Macros to stop,change, or do other controls on music so be sure to check out the Roll20 AudioMaster API for sure. 

here's one that would be useful with the previous Trick:

Pre-Linked Tokens

Sometimes you'll want a Token that is re-usable, that has a specific set of abilities, or access to a specific set of Macros, such as the Ability to change the Music Track, or perhaps the Circle of Shepherd Druid's Spirit Totem's Aura, or even something as simple as a Torch. You are capable of setting up a Token, linking it to a Character Sheet as a Default Token, and then simply Dragging it out to the Map whenever you need it.

In the case of the Room Specific Music mentioned in the previous Tip, you'd leave the Name Blank (or something that is easy to load/stop) and set it up when you place the Token, but the Character Sheet would have the "Ability" Macro for changing the Music, this allows you to generate the desired effect for only the Tokens you want it to appear for, without clogging up the GUI for the other Tokens that would have no use for it, as well as streamlining the process.

in the case of the Circle of the Shepherd Druid's Spirit Totem Token, it affects a specific Radius, for a specific amount of Time, and can be moved, so, you simply need to assign a Token (I use a Rollable Table Token to represent the Type of Totem used) the appropriate Radius Aura, and you can set it's respective "HP Bar" (I use Bar 3) to 10/10, this allows the Players to track the length of Time which the Totem lasts.

Note: I didn't say I linked it's HP Bar to it's HP Stat on the Character Sheet, I purposefully leave this unlinked! This reasoning becomes more apparent when you are using it for things such as Torches which can be difficult to track individually, with this method, you simply set the Torch's HP Bar at 600/600 and subtract 1 each Round. I combine this trick with Control flames to track how fast it burns through the Torch (Homebrew ruling on the Spell affecting the Flame Source)

You can also Set the Current Token "Health" with 1 less for these Tokens depending on how you measure the timing of the Effects. For example, a Torch might get placed with 599/600 instead of 600/600 because you might want to count the ignition round against it's Hour, whereas the Spirit Totem would start at 9/10 allowing you to streamline the whole process.

P. S. It should be noted that doing this too much has the potential to generate Lag, as it does actually generate a Character Sheet for each one of these that you do, so, just a heads up, in excess you might cause lag, even when you Archive it, it's still loaded. (this was mentioned elsewhere in this same thread) also, this trick was briefly discussed earlier in this thread, although not quite as in depth: Link.

Also, the previous Tip had an alternative mention earlier in this thread in a different format & context, but generally the same tip: Link.

Thanks Ye'Olde DM  and Blue64. Good additions. For anyone trying Roll20AM, be aware that the latest version soon to be released to One-Click has a slightly changed syntax. The command from two posts above will become: 

!roll20AM --audio,play|@{selected|token_name}

Blue64 said:

I would like to point out that Standard 5e Rule Set says that you only recover "up to half of your Hit Dice" so the math for that would actually be something along the lines of

• [[ (floor( @{target|Long Rest|hd|max} /2) ) + @{target|Long Rest|hd} ]]

Might wanna double check your Macros Page and make sure that the Hit Dice is working correctly

Also, you forgot to disclaimer before your Link that most of those use the API Scripts, which is not a Free User perk.

Also, /emas is a GM/DM Tier Command, any Player using it will receive the same error as /desc you should look into changing it to /em which is available to Players.

I'm actually a bit confused about which macro you're talking about with the hit dice! As for the second thing, thanks for catching that! I'll take a look and make changes.

Poltergeisha said:

Blue64 said:

I would like to point out that Standard 5e Rule Set says that you only recover "up to half of your Hit Dice" so the math for that would actually be something along the lines of

• [[ (floor( @{target|Long Rest|hd|max} /2) ) + @{target|Long Rest|hd} ]]

Might wanna double check your Macros Page and make sure that the Hit Dice is working correctly

Also, you forgot to disclaimer before your Link that most of those use the API Scripts, which is not a Free User perk.

Also, /emas is a GM/DM Tier Command, any Player using it will receive the same error as /desc you should look into changing it to /em which is available to Players.

I'm actually a bit confused about which macro you're talking about with the hit dice! As for the second thing, thanks for catching that! I'll take a look and make changes.

I posted an Issue Tracker on your GitHub about it, but it was specifically the Long Rest section, I'm not sure how the API Script handles it, but your descriptive Text, from what I can tell, implies that it's restoring all of the Hit Dice, when it's supposed to be half rounded down.

Simple Way to have a "Handout" without a Journal Entry or Actually Making a Handout

I've been using this method a lot recently to show handouts based on what they see in a room or somewhere on the map. I've done this a lot for books, journals, mystic scripts and alchemy recipe books among other things.

Step 1: Use photoshop or GIMP to create an image with as much text as you want to display (In my instances I've used a high-res images of aged parchment and aged open books showing text on both pages.)

Step 2: Upload the image to your Roll20 Library. I have a folder for things like this:

Step 3: Place the image on the map somewhere as a token at a location you want the party to find and read the content of the book/scroll/etc. It will show up filling a full unit (Default 70 x 70 pixels) and look a too large or out of place so right click on the token and select "Advanced --> is Drawing" then shrink it down to an appropriate level and possibly rotate it to make it look more organic. Mine looks like this:

Step 4: Once they are in the room and say "I want to read the Journal" or "I want to see what the scroll says", etc etc. select the journal token then press SHIFT+Z this will show it to all players. You see how small that journal looks on the table? This is what the players see after pressing SHIFT-Z

Doing all this lets you add readable books, scrolls, mystic script, notes, alchemy recipes, tactics or fighting treatise / instructions among many other things without having to create a Handout and having it as a "single use handout". Having these littered around your dungeon or cave or any area with intelligent / semi-intelligent creatures helps with world building and makes for a nice change of pace to just "Walk in room, see 4 orcs, kill orcs, take treasure, move on to next room."

I have a long list of things like this I do to break the monotony of just combat encounters when in some stronghold or dungeon scenario.

Kastion said:

Simple Way to have a "Handout" without a Journal Entry or Actually Making a Handout

I've been using this method a lot recently to show handouts based on what they see in a room or somewhere on the map. I've done this a lot for books, journals, mystic scripts and alchemy recipe books among other things.

Step 1: Use photoshop or GIMP to create an image with as much text as you want to display (In my instances I've used a high-res images of aged parchment and aged open books showing text on both pages.)

Step 2: Upload the image to your Roll20 Library. I have a folder for things like this:

Step 3: Place the image on the map somewhere as a token at a location you want the party to find and read the content of the book/scroll/etc. It will show up filling a full unit (Default 70 x 70 pixels) and look a too large or out of place so right click on the token and select "Advanced --> is Drawing" then shrink it down to an appropriate level and possibly rotate it to make it look more organic. Mine looks like this:

Step 4: Once they are in the room and say "I want to read the Journal" or "I want to see what the scroll says", etc etc. select the journal token then press SHIFT+Z this will show it to all players. You see how small that journal looks on the table? This is what the players see after pressing SHIFT-Z

Doing all this lets you add readable books, scrolls, mystic script, notes, alchemy recipes, tactics or fighting treatise / instructions among many other things without having to create a Handout and having it as a "single use handout". Having these littered around your dungeon or cave or any area with intelligent / semi-intelligent creatures helps with world building and makes for a nice change of pace to just "Walk in room, see 4 orcs, kill orcs, take treasure, move on to next room."

I have a long list of things like this I do to break the monotony of just combat encounters when in some stronghold or dungeon scenario.

Very Cool!

Cool indeed, Kastion. There are a lot of uses for this.

@Kastion 

I've used this method on larger maps to show an exploded view of the map, notes and info placed on tabletops, and GM-only(gm-layer) for notes/room description for dungeons/maps. Sometimes I'll place "thumbnails" in the vtt's margins and use as a "gallery" to show player's as the story develops.

Vince said:

@Kastion 

I've used this method on larger maps to show an exploded view of the map, notes and info placed on tabletops, and GM-only(gm-layer) for notes/room description for dungeons/maps. Sometimes I'll place "thumbnails" in the vtt's margins and use as a "gallery" to show player's as the story develops.

If you don't want the players to see the thumbnail, that part of the VTT can be obscured by basic fog of war, as in this trick. Before I developed my NPC gallery macro, I did this all the time, or hid them behind already existing walls of dynamic lighting.

Kastion said:

Simple Way to have a "Handout" without a Journal Entry or Actually Making a Handout

I've been using this method a lot recently to show handouts based on what they see in a room or somewhere on the map. I've done this a lot for books, journals, mystic scripts and alchemy recipe books among other things.

Step 1: Use photoshop or GIMP to create an image with as much text as you want to display (In my instances I've used a high-res images of aged parchment and aged open books showing text on both pages.)

Step 2: Upload the image to your Roll20 Library. I have a folder for things like this:

*snip*

Step 3: Place the image on the map somewhere as a token at a location you want the party to find and read the content of the book/scroll/etc. It will show up filling a full unit (Default 70 x 70 pixels) and look a too large or out of place so right click on the token and select "Advanced --> is Drawing" then shrink it down to an appropriate level and possibly rotate it to make it look more organic. Mine looks like this:

*snip*

Step 4: Once they are in the room and say "I want to read the Journal" or "I want to see what the scroll says", etc etc. select the journal token then press SHIFT+Z this will show it to all players. You see how small that journal looks on the table? This is what the players see after pressing SHIFT-Z

*snip*

Doing all this lets you add readable books, scrolls, mystic script, notes, alchemy recipes, tactics or fighting treatise / instructions among many other things without having to create a Handout and having it as a "single use handout". Having these littered around your dungeon or cave or any area with intelligent / semi-intelligent creatures helps with world building and makes for a nice change of pace to just "Walk in room, see 4 orcs, kill orcs, take treasure, move on to next room."

I have a long list of things like this I do to break the monotony of just combat encounters when in some stronghold or dungeon scenario.

Do you by chance have a Template which we'd be able to use for a Scroll/Book in case we desire to create our own versions? this actually reminds me of a Tip that has yet to be mentioned here! This is actually a Double Tip!

Resizing Images to Scale: Quick & Easy!

Smoother Resized Images!

When you go to upload a desired Image, it can be a pain to get everything scaled properly, especially a Raw (unscaled, unsquared, unedited) image, & when you edit it, sometimes it comes out Choppy, Blurry, Fuzzy, or just plain Odd; But, fret not! For there are a few simple & easy methods for fixing this:

• 1: if you are familiar with the classic Excel Spreadsheets, you likely know that they had a command for figuring out when 2 numbers would eventually meet if you kept adding the original number.
  
  Nowadays though, Microsoft holds that Program & asks for money, although there is a Freeware variant known as "OpenOffice Calc" as a part of the OpenOffice package of Text Editors (Link: Their Download Page)
  
  For example:
  Key:
  $x "Do not Change x in Copy/Paste"
  = "Formula"
  

• 2: if you are unable/unwilling to use the above formula (only needs the 3x1 area on Row 2, the rest is explanatory & entirely optional), you can still do it using 1 or 2 Calculators.
  
  You can spend time adding it all together, finding the lowest possible combination, or, you can take a shortcut:
  (A*B) = (C) = (B*A)
  (C/A) = (B)
  (C/B) = (A)
• 3: This can be used to figure out how Small you want to make something as well! in the Table above, you will notice I have a formula called "LCM()", this can be used with up to 30 numbers to find out their "Least Common Multiple", for example:
  =LCM(70;140;512)
  shows they all share the number 17,920 so you know what you want to resize the image to in order to create a smooth picture, This is useful for Maps which do not follow the standard Grid Size (I have not yet figured out how it works it's math tho).

A lot of Resizing Methods use "Blending" or "Anti-aliasing" to force the Square Peg into the Round Hole, this way you can smoothly make the entire image Fit, without needing to lose out on quality, although, fair warning, you are going to want to have a good amount of RAM to make an image that large, as even a 7,000 x 7,000 Pixel Image can easily need half a Gig (512 MB) of RAM, and you'll still need to Shrink it afterwards to a more reasonable size (3,500 x 3,500 = 50 x 50 Units)

Not sure what the gist of the post is. Are you giving a formula for proportional scaling vs. anamorphic? If the difference is slight, you shouldn't see a big difference in final quality. Also, at what point are you scaling your graphic? If you are doing it in Roll20, you aren't gaining anything, since the graphic is already in the library—Roll20 makes it's own scaled images internally as needed. If it's in an image editor, most (all as far as I know) of them have controls to force a proportional scale.

I've had to do this in the past with Maptool. It's just also a lot easier to bring the images in at 70 pix per square too. I've always used this spreadsheet.

It Scales the image, yes, but I'm sure you are aware of the horrible Scaling Issues that it suffers from, as well as the blurring that can occur.

My tip was a method to get a crisp image without taking too much time to tweak the Image every time you use it, it requires beefy hardware since it can easily reach half a gig of RAM dedicated to just the Image, but, it bypasses ALL of the potential blur that might occur, it's actually a very old school method, however, it's not the optimal approach, as I'm fully aware that there is a viable combination around the 7k Pixel Range for 512 to 70, but I'm not very familiar with the Spreadsheet functions, however the LCM function is pretty good considering it's beyond my comprehension off hand of how it came to the answer of 17,920.

The optimal approach involves lots of Cross Referencing between Columns A & B as the numbers climb (although I used a Calculator, not a Spreadsheet), or a Spreadsheet function I'm unawares of.

Manually increasing then decreasing the size ensures quality, requires zero blending of any sort, since it's a Pixel for Pixel expansion, if you want to really make sure, you want something along the lines of (B*(4*X)) B being the starting number, and the same Equation for A, the Target Number, and X being how many times to multiply the Base Number out by (times 4 for ultra pristine quality).

The Blending Method was invented to lower the Hardware Requirements for image Resizing, it was truly a revolutionary invention, many were flabbergasted by the efficacy.

Edit: apparently some Error occurred when I was posting this, error code: 908197796e8d4ecbb2ab22e712e66653