[POW ANALYST TEMPLATE V1.1] [Team] vs. [Team] [Map] [Round]
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
Map:XXXWINNER:XXXV1.1XXX = Must Be Filled In at minimum
MAKE A COPY, FILL IN [ITEMS]
Data stuff over Blank spaces to right of last entrySort final Heroes because I can't figure out a solutionXXX6666666666666618424:00:00OffenseDefense
2
Teams:XXXXXX<---- Fill out these Cells FIRSTTeam Dropdown Menu Auto-Populateshere -->XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!DefenseOffenseUbersheet Output (Non KotH)NAEUNAEUUbersheet Output (KotH)NAEU
3
Region:XXXXXXXXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Genji0000Genji00
4
Roster 1 ----------------------->XXXXXX<-------------- Roster 2In Stopwatch Situations, VOD End Time is when GG is calledXXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00McCree0000McCree00MapsKoth Sub Maps
Map Locations (Payload, 2CP)
5
XXXXXXXXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Pharah0000Pharah00Lijiang TowerGarden
King's Row First Point
6
XXXXXXXXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Reaper0000Reaper00NepalNight Market
King's Row Streets
7
XXXXXXXXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Soldier 760000Soldier 7600IliosControl Center
King's Row Second Point
8
XXXXXX11111111111111114#VALUE!00Tracer0000Tracer00
Volskaya Industries
Temple
King's Row Indoor Area
9
XXXXXXHero SummaryOffenseDefense11111111111111114#VALUE!00Bastion0000Bastion00
Temple of Anubis
Sanctum
King's Row Third Point
10
Side 1
Sub-Map (KotH only):
Do not touch these Cells ------------>Heroes Used
Time Spent on Hero
Percent of Match Time Spent on HeroWhere Hero was Swapped toHeroes Used
Time Spent on Hero
Percent of Match Time Spent on HeroWhere Hero was Swapped to11111111111111114#VALUE!00Junkrat0000Junkrat00HanamuraVillage
Volskaya First Point
11
OFFENSETeam:XXXXXXAny Time a Swap occurs, note the time and the swapXXX24:00:00#VALUE!XXX24:00:00#VALUE!11111111111111114#VALUE!00Hanzo0000Hanzo00King's RowRuins
Volskaya Second Point
12
PlayersHeroesSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwaps0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Mei0000Mei00HollywoodWell
Anubis First Point
13
XXXXXX<-----------
Fill out these Cells Only
0:00:00#VALUE!0:00:00#VALUE!Blank spaces to right of last entrySort final Heroes because I can't figure out a solution11111111111111114#VALUE!00Torbjorn0000Torbjorn00
Watchpoint: Gibraltar
Lighthouse
Anubis Second Point
14
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Widowmaker0000Widowmaker00Numbani
Hanamura First Point
15
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00D.va0000D.Va00Dorado
Hanamura Second Point
16
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX0:00:00XXX0:00:00XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Reinhardt0000Reinhardt00Route 66
Hollywood First Point
17
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX0:00:00XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Roadhog0000Roadhog00
Hollywood Roofs
18
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Winston0000Winston00
Hollywood Second Point
19
Match Time Event Occurred
XX:XX:XX0:00:00#VALUE!0:00:00#VALUE!XXX0:00:00XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Zarya0000Zarya00Hollywood Indoors
20
Location Event Occurred (Map Progress)Spawn0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Lucio0000Lucio00
Hollywood Third Point
21
FILL THESE OUT ----->
VERY IMPORTANT
XX:XX:XXXX:XX:XX#VALUE!0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Mercy0000Mercy00
Watchpoint First Point
22
VOD START TIMEVOD END TIMESide Length0:00:00#VALUE!0:00:00#VALUE!XXX6666666666666618424:00:0000Symmetra0000Symmetra00
Watchpoint Server Room Area
23
DEFENSETeam:XXXXXXAny Time a Swap occurs, note the time and the swap0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Zenyatta0000Zenyatta00
Watchpoint Second Point
24
PlayersDefense Starting LineupSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwaps0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!
Watchpoint Shuttle Room
25
XXXXXX<-----------
Fill out these Cells Only
0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!
Watchpoint Second -> Third Point
26
XXXXXX0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!
Watchpoint Third Point
27
XXXXXX0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!
Numbani First Point
28
XXXXXX0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!
Numbani First -> Second Point
29
XXXXXX0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!
Numbani Second Point
30
XXXXXX0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!
Numbani Second -> Third Point
31
Match Time Event Occurred
XX:XX:XX0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!
Numbani Third Point
32
Location Event Occurred (Map Progress)Spawn11111111111111114#VALUE!
Dorado First Arch
33
11111111111111114#VALUE!
Dorado Courtyard
34
11111111111111114#VALUE!
Dorado First Point
35
11111111111111114#VALUE!
Dorado Second Arch
36
11111111111111114#VALUE!
Dorado Second Point
37
11111111111111114#VALUE!Dorado Indoors
38
11111111111111114#VALUE!
Dorado Third Point
39
Also Fill out Team But not Region,
It auto-updates
11111111111111114#VALUE!
Route 66 First Arch
40
11111111111111114#VALUE!
Route 66 Big Earl's
41
11111111111111114#VALUE!
Route 66 First Point
42
VVVVVVVVVVVVVHero SummaryOffenseDefense11111111111111114#VALUE!
Route 66 Streets
43
Side 2
Sub-Map (KotH only):
Do not touch these Cells ------------>Heroes Used
Time Spent on Hero
Percent of Match Time Spent on HeroWhere Hero was Swapped toHeroes Used
Time Spent on Hero
Percent of Match Time Spent on HeroWhere Hero was Swapped toXXX6666666666666618424:00:00OffenseDefense
Route 66 Second Point
44
OFFENSETeam:XXXXXXAny Time a Swap occurs, note the time and the swapXXX24:00:00#VALUE!XXX24:00:00#VALUE!11111111111111114#VALUE!
Ubersheet Output (Non KotH)
NAEUNAEU
Ubersheet Output (KotH)
NAEU
Route 66 Indoors
45
PlayersHeroesSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwaps0:00:00#VALUE!0:00:00#VALUE!Blank spaces to right of last entrySort final Heroes because I can't figure out a solution11111111111111114#VALUE!00Genji0000Genji00
Route 66 Third Point
46
XXXXXX<-----------
Fill out these Cells Only
0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00McCree0000McCree00
47
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Pharah0000Pharah00
48
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Reaper0000Reaper00
49
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Soldier 760000Soldier 7600
50
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Tracer0000Tracer00
51
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Bastion0000Bastion00
52
Match Time Event Occurred
XX:XX:XX0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Junkrat0000Junkrat00
53
Location Event Occurred (Map Progress)Spawn0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Hanzo0000Hanzo00
54
FILL THESE OUT ----->
VERY IMPORTANT
XX:XX:XXXX:XX:XX#VALUE!0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Mei0000Mei00
55
VOD START TIMEVOD END TIMESide Length0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Torbjorn0000Torbjorn00
56
DEFENSETeam:XXXXXXAny Time a Swap occurs, note the time and the swap0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Widowmaker0000Widowmaker00
57
PlayersDefense Starting LineupSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwaps0:00:00#VALUE!0:00:00#VALUE!Blank spaces to right of last entrySort final Heroes because I can't figure out a solution11111111111111114#VALUE!00D.va0000D.Va00
58
XXXXXX<-----------
Fill out these Cells Only
0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Reinhardt0000Reinhardt00
59
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Roadhog0000Roadhog00
60
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Winston0000Winston00
61
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Zarya0000Zarya00
62
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Lucio0000Lucio00
63
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Mercy0000Mercy00
64
Match Time Event Occurred
XX:XX:XX0:00:00#VALUE!0:00:00#VALUE!XXX6666666666666618424:00:0000Symmetra0000Symmetra00
65
Location Event Occurred (Map Progress)Spawn11111111111111114#VALUE!00Zenyatta0000Zenyatta00
66
11111111111111114#VALUE!
67
11111111111111114#VALUE!
68
11111111111111114#VALUE!
69
11111111111111114#VALUE!
70
11111111111111114#VALUE!
71
011111111111111114#VALUE!
72
11111111111111114#VALUE!
73
11111111111111114#VALUE!
74
11111111111111114#VALUE!
75
011111111111111114#VALUE!
76
11111111111111114#VALUE!
77
11111111111111114#VALUE!
78
11111111111111114#VALUE!
79
11111111111111114#VALUE!
80
11111111111111114#VALUE!
81
Also Fill out Team But not Region,
It auto-updates
11111111111111114#VALUE!
82
11111111111111114#VALUE!
83
11111111111111114#VALUE!
84
VVVVVVVVVVVVVHero SummaryOffenseDefense11111111111111114#VALUE!
85
Side 3 (As Needed)
Sub-Map (KotH only):
Do not touch these Cells ------------>Heroes Used
Time Spent on Hero
Percent of Match Time Spent on HeroWhere Hero was Swapped toHeroes Used
Time Spent on Hero
Percent of Match Time Spent on HeroWhere Hero was Swapped toXXX666666666.0000000000006666618424:00:00OffenseDefense
86
OFFENSETeam:XXXXXXAny Time a Swap occurs, note the time and the swapXXX24:00:00#VALUE!XXX24:00:00#VALUE!11111111111111114#VALUE!
Ubersheet Output (Non KotH)
NAEUNAEU
Ubersheet Output (KotH)
NAEU
87
PlayersHeroesSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwaps0:00:00#VALUE!0:00:00#VALUE!Blank spaces to right of last entrySort final Heroes because I can't figure out a solution11111111111111114#VALUE!00Genji0000Genji00
88
XXXXXX<-----------
Fill out these Cells Only
0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00McCree0000McCree00
89
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Pharah0000Pharah00
90
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Reaper0000Reaper00
91
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Soldier 760000Soldier 7600
92
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Tracer0000Tracer00
93
XXXXXX0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Bastion0000Bastion00
94
Match Time Event Occurred
XX:XX:XX0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Junkrat0000Junkrat00
95
Location Event Occurred (Map Progress)Spawn0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Hanzo0000Hanzo00
96
FILL THESE OUT ----->
VERY IMPORTANT
XX:XX:XXXX:XX:XX#VALUE!0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Mei0000Mei00
97
VOD START TIMEVOD END TIMESide Length0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Torbjorn0000Torbjorn00
98
DEFENSETeam:XXXXXXAny Time a Swap occurs, note the time and the swap0:00:00#VALUE!0:00:00#VALUE!11111111111111114#VALUE!00Widowmaker0000Widowmaker00
99
PlayersDefense Starting LineupSwapsSwapsSwapsSwapsSwapsSwapsSwapsSwaps0:00:00#VALUE!0:00:00#VALUE!Blank spaces to right of last entrySort final Heroes because I can't figure out a solution11111111111111114#VALUE!00D.va0000D.Va00
100
XXXXXX<-----------
Fill out these Cells Only
0:00:00#VALUE!0:00:00#VALUE!XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX1XXX#VALUE!14XXX11111111111111114#VALUE!00Reinhardt0000Reinhardt00
Loading...