Piloting And Gunnery Visual Charts And Tables From Your Mwo Stats

Update OVER TIME version 2016-05-27:

Which Mechs do you best pilot for survival, kills, and experience?
Which weapons do you best use to inflict damage, and at which ranges?
How has your performance improved over time?

Preview of visuals, instructions, and blank spreadsheet available from:
https://drive.google...ZWc&usp=sharing

Import your profile stats and refresh this spreadsheet to see!

Save this Excel 2016 spreadsheet with PowerView file to your Windows 7 or Windows 10 computer:
MWO_stats PVot 2016-05-27 - Blank.xlsx

Export your profile stats
From these Web pages (for the Weapon stats, both the Current and Archived):
https://mwomercs.com...stats?type=mech
https://mwomercs.com...ats?type=weapon

Import your profile stats

Copy and paste only the data rows for each mech and weapon into their respective worksheets, append into the second column starting from the second row:
- Mech Stats
- Current Weapon Stats
- Archived Weapon Stats
Then add the correct dates into the first column for each appended row in each of those worksheets.

Sort each of those worksheets, starting with Archives Weapon Stats

Select and highlight all the pasted columns
Left click on the DATA ribbon tab
Left click on the SORT menu option
Select the first named column (Mech or Weapon) for sorting
Select Sort on Values
Select Sort order A to Z
Left click the OK button

Verify current data for Mechs and weapons

Left click on Mech Data worksheet
Verify that each Mech listed in the Mech Stats worksheet is also listed in the Mech Data worksheet. If not, insert a data row for it.
Left click on Weapon Data worksheet
Verify that each weapon listed in the Weapon Stats worksheet is also listed in the Weapon Data worksheet. If not, insert a data row for it.

Refresh Data and Queries

Left click on the DATA ribbon tab
Left click on the Refresh All menu option
Left click on the Refresh All menu selection
Left click on Show Queries menu option in the DATA ribbon tab
Right click on qPiloting in the Workbook Queries area
Left click on Refresh
Right click on qGunnery in the Workbook Queries area
Left click on Refresh

Left click on File

Left click on Save As
Use the File Save As dialog window to save the updated spreadsheet

View Item Details

In each report, mouse over each report or chart item to view a pop-up detail for that item.

View your Mech Piloting

Left click on the Piloting worksheet
Scroll through the Mech tonnage classes by using the horizontal slider along the bottom of the chart.
Restrict or filter which Mechs appear in the report by using Left Click or CTRL Left Click in the Faction and Class slicer filter selection along the left. Restrict or filter which Mechs appear in the report by using Left Click or CTRL Left Click in the Date slicer filter selection along the left. To clear them all, mouse over until the Clear Filter icon appears then Left Click on that.

View your Weapon Gunnery

Left click on the Gunnery worksheet
Scroll through the Gunnery and Prosecution tables by using their vertical sliders.
To view Prosecution table information for a specific weapon, Left Click on its clustered bar data in the Gunnery table. To again view Prosecution table information for all weapons, left click in the list of weapons in the Gunnery table.
Restrict or filter which Weapons appear in the report by using Left Click or CTRL Left Click in the Faction and Weapon Type slicer filter selection along the left. Restrict or filter which Mechs appear in the report by using Left Click or CTRL Left Click in the Date slicer filter selection along the left. To clear them all, mouse over until the Clear Filter icon appears then Left Click on that.

View your Mech Piloting Over Time

Left click on the MPoT worksheet
Scroll through the Mech tonnage classes by using the horizontal slider along the bottom of the chart.
Restrict or filter which Mechs appear in the report by using Left Click or CTRL Left Click in the Faction, Class, Tons, and Mech slicer filter selections along the left. To clear them all, mouse over until the Clear Filter icon appears then Left Click on that.
View a specific date in this report by using Left Click on the date along the bottom of the main chart. View all dates in this report again by using Left Click another time on the date along the bottom of the main chart.
Begin and resume viewing an animation of Mech Piloting Over Time by using Left Click on the play button immediately to the right of "Date" at the lower-left of the main chart. Pause the viewing an animation of Mech Piloting Over Time by using Left Click on the pause button immediately to the right of "Date" at the lower-left of the main chart.

View your Weapon Gunnery Over Time

Left click on the WGoT worksheet
Scroll through the Gunnery and Prosecution tables by using their vertical sliders.
To view Prosecution table information for a specific weapon, Left Click on its clustered bar data in the Gunnery table. To again view Prosecution table information for all weapons, left click in the list of weapons in the Gunnery table.
Restrict or filter which Weapons appear in the report by using Left Click or CTRL Left Click in the Faction, Weapon Type, and Weapon slicer filter selections along the left. To clear them all, mouse over until the Clear Filter icon appears then Left Click on that.
View a specific date in this report by using Left Click on the date along the bottom of the main chart. View all dates in this report again by using Left Click another time on the date along the bottom of the main chart.
Begin and resume viewing an animation of Weapon Gunnery Over Time by using Left Click on the play button immediately to the right of "Date" at the lower-left of the main chart. Pause the viewing an animation of Weapon Gunnery Piloting Over Time by using Left Click on the pause button immediately to the right of "Date" at the lower-left of the main chart.

Original TIME SLICE version 2016-05-21 (still available):

Which Mechs do you best pilot for survival, kills, and experience?
Which weapons do you best use to inflict damage, and at which ranges?

Preview of visuals, instructions, and blank spreadsheet available from:
https://drive.google...ZWc&usp=sharing

From there, save this Excel 2016 spreadsheet with PowerView file to your Windows 7 or Windows 10 computer:
MWO_stats PV 2016-05-21 Blank.xlsx

Import your profile stats and refresh this spreadsheet to see!

Export your profile stats
From these Web pages (for the Weapon stats, both the Current and Archived):
https://mwomercs.com...stats?type=mech
https://mwomercs.com...ats?type=weapon

Import your profile stats

Copy and paste only the data rows for each Mech and weapon into their respective worksheets, into the first column starting from the second row:
Mech Stats
Current Weapon Stats
Archived Weapon Stats

Sort each of those worksheets, starting with Archives Weapon Stats

Select and highlight all the pasted columns
Left click on the DATA ribbon tab
Left click on the SORT menu option
Select the first named column (Mech or Weapon) for sorting
Select Sort on Values
Select Sort order A to Z
Left click the OK button

Import combined Current and Archived Weapon Stats into Weapon Stats

Left click on the Current Weapon Stats worksheet tab to return to it
Copy from (H2:N[end of data])
Left click on Weapon Stats worksheet tab
Left click in to cell A2
Paste as Values all that data

Verify current data for Mechs and weapons

Left click on Mech Data worksheet
Verify that each Mech listed in the Mech Stats worksheet is also listed in the Mech Data worksheet. If not, insert a data row for it.
Left click on Weapon Data worksheet
Verify that each weapon listed in the Weapon Stats worksheet is also listed in the Weapon Data worksheet. If not, insert a data row for it.

Refresh Data and Queries

Left click on the DATA ribbon tab
Left click on the Refresh All menu option
Left click on the Refresh All menu selection
Left click on Show Queries menu option in the DATA ribbon tab
Right click on qPiloting in the Workbook Queries area
Left click on Refresh
Right click on qGunnery in the Workbook Queries area
Left click on Refresh

Save your updated file

Left click on File
Left click on Save As
Use the File Save As dialog window to save the updated spreadsheet

View your Mech Piloting

Left click on the Piloting worksheet
Scroll through the Mech tonnage classes by using the horizontal slider along the bottom of the chart.
Restrict or filter which Mechs appear in the report by using Left Click or CTRL Left Click in the Faction and Class slicer filter selection along the left. To clear them all, mouse over until the Clear Filter icon appears then Left Click on that.

View your Weapon Gunnery

Left click on the Gunnery worksheet
Scroll through the Gunnery and Prosecution tables by using their vertical sliders.
To view Prosecution table information for a specific weapon, Left Click on its clustered bar data in the Gunnery table. To again view Prosecution table information for all weapons, left click in the list of weapons in the Gunnery table.
Restrict or filter which Weapons appear in the report by using Left Click or CTRL Left Click in the Faction and Weapon Type slicer filter selection along the left. To clear them all, mouse over until the Clear Filter icon appears then Left Click on that.

Edited by SedHurtYa, 28 May 2016 - 06:19 PM.

Piloting And Gunnery Visual Charts And Tables From Your Mwo Stats

#1 Sniper Behind Ya

#2 Granimal

#3 Triordinant

#4 Sniper Behind Ya

#5 Sniper Behind Ya

#6 Davegt27

#7 Sniper Behind Ya

#8 Koniving

#9 JediPanther

#10 Sniper Behind Ya

#11 Sniper Behind Ya

#12 Angel of Annihilation

#13 Sniper Behind Ya

#14 A Man In A Can

1 user(s) are reading this topic

HOME

GAME

MEDIA

COMMUNITY

SUPPORT