I know not with what weapons World War III will be fought, but World War IV will be fought with sticks and stones.
-Albert Einstein
Greetings Ranked War Freaks!
I have created a Google Sheet to help you and your faction with Ranked Wars!
You can give feedback or get support on my official Torn.com forum post.
This post is updated frequently as I roll out newer versions.

To use it you will have to make a copy of the most recent version RW Helper V1.5.
****Previous versions****
Version 1.5When you have the copy of the most recent version you can start setup of the sheet.
PLEASE NOTE: This sheet will only work while you are matched waiting to start or while you are in a RW already.
So with that being said lets just get to it....
1. Fill in your PUBLIC API Key in the red box on the top left.
After you enter your Key in the red box it will turn green...

2. Click the button to get Faction IDs....

3. You will have to auth the sheet to allow it to run the scripts...

4. Chose your Gmail account to use....

5. Click Advanced...

6. Click on the name of the sheet to allow it.
This will be Copy of RW Helper V1.5 assuming you haven't renamed it already...

7. Then click allow...
This allows the scripts in the sheet to run.

8. Click the button again to get Factions IDs.....
This retrieves yours and your enemies faction id's.

9. Click the button below that button to get all data on your current RW...
This will fill in all data for both of your Factions on your current RW.

Once you have gotten to this point the sheet is ready for use.
You can use the buttons below the BLACK bar to update in real time all the data on the sheet.
Each button updates something different and are labeled above the buttons as to what they update.
In the Members column on either side is the name of the member and a link to their profile.
In the Attack column is the link to load the loader to attack that member in the enemy Faction.

This sheet is reusable for another war.
All you have to do when you are matched up for the next war is click the button to clear all data.
This will clear the page and you can start from the beginning of setup
again to get the new Faction IDs and use it on your next war!
This will not remove your API key.

Credits:
mrdanger2001 [2238421] for all the help on layout and ideas.
Zelda-Gold [2197756] for testing and input on layout ideas.