PGR_GuildBattle.xlsx

	A	B	C	D	I	J	K	L	M
1	HP Bars	Current HP	1,2% of current HP	1,2% of lost HP
2	100	16000000	192000	0
3	99	15840000	190080	1920
4	98	15680000	188160	3840	Max. HP:	16,000,000	<-	Change this cell to your Boss' Max. HP value
5	97	15520000	186240	5760	0,8% of max. HP:	128000
6	96	15360000	184320	7680	Regular Zone fixed damage:	60000
7	95	15200000	182400	9600
8	94	15040000	180480	11520	How to Read:
9	93	14880000	178560	13440	Look for the line with your Boss' current HP or HP Bar amount, then check the corresponding value on columns C and D
10	92	14720000	176640	15360
11	91	14560000	174720	17280	For Regular Zone Stages (Blue, Left Side):
12	90	14400000	172800	19200	ALWAYS run DND-03 (third from top) if Boss is at x24 or lower
13	89	14240000	170880	21120	If column C is highlighted, run DND-01 (top, 1,2% of remaining HP)
14	88	14080000	168960	23040	Otherwise, run DND-02 (second from top, fixed 60k dmg)
15	87	13920000	167040	24960
16	86	13760000	165120	26880	For Special Stages (Uniframes, Red, Right Side):
17	85	13600000	163200	28800	If column D is highlighted, run GND-02 (second from top, 1,2% of lost HP)
18	84	13440000	161280	30720	Otherwise, run GND-01 (top, 0,8% of max. HP)
19	83	13280000	159360	32640
20	82	13120000	157440	34560	If boss has already been defeated, you can run DND-04 and GND-03 (bottom both sides, 10k command points)
21	81	12960000	155520	36480
22	80	12800000	153600	38400	Reminder that you can also attack the center and that you can attack once on the right, once on the left and once in the center for a total of 3 attacks.
23	79	12640000	151680	40320
24	78	12480000	149760	42240
25	77	12320000	147840	44160
26	76	12160000	145920	46080
27	75	12000000	144000	48000
28	74	11840000	142080	49920			Lv.6
29	73	11680000	140160	51840		Contribution	UAP	Merit	Cogs
30	72	11520000	138240	53760		3000	24	10	3000
31	71	11360000	136320	55680		6000	24	10	3500
32	70	11200000	134400	57600		9000	24	10	4000
33	69	11040000	132480	59520		12000	36	15	4500
34	68	10880000	130560	61440		15000	36	15	5000
35	67	10720000	128640	63360
36	66	10560000	126720	65280		Self Points	UAP	Contrib.	Guild EXP
37	65	10400000	124800	67200		100k	24	48	140
38	64	10240000	122880	69120		200k	24	48	140
39	63	10080000	120960	71040		300k	24	48	140
40	62	9920000	119040	72960		400k	36	72	210
41	61	9760000	117120	74880		500k	36	72	210
42	60	9600000	115200	76800
43	59	9440000	113280	78720		Remaining HP	UAP	Merit	Guild EXP
44	58	9280000	111360	80640		75%	36	10	140
45	57	9120000	109440	82560		50%	36	10	140
46	56	8960000	107520	84480		25%	36	10	140
47	55	8800000	105600	86400		0%	36	10	140
48	54	8640000	103680	88320
49	53	8480000	101760	90240
50	52	8320000	99840	92160
51	51	8160000	97920	94080
52	50	8000000	96000	96000
53	49	7840000	94080	97920
54	48	7680000	92160	99840
55	47	7520000	90240	101760
56	46	7360000	88320	103680
57	45	7200000	86400	105600
58	44	7040000	84480	107520
59	43	6880000	82560	109440
60	42	6720000	80640	111360
61	41	6560000	78720	113280
62	40	6400000	76800	115200
63	39	6240000	74880	117120
64	38	6080000	72960	119040
65	37	5920000	71040	120960
66	36	5760000	69120	122880
67	35	5600000	67200	124800
68	34	5440000	65280	126720
69	33	5280000	63360	128640
70	32	5120000	61440	130560
71	31	4960000	59520	132480
72	30	4800000	57600	134400
73	29	4640000	55680	136320
74	28	4480000	53760	138240
75	27	4320000	51840	140160
76	26	4160000	49920	142080
77	25	4000000	48000	144000
78	24	3840000	46080	145920
79	23	3680000	44160	147840
80	22	3520000	42240	149760
81	21	3360000	40320	151680
82	20	3200000	38400	153600
83	19	3040000	36480	155520
84	18	2880000	34560	157440
85	17	2720000	32640	159360
86	16	2560000	30720	161280
87	15	2400000	28800	163200
88	14	2240000	26880	165120
89	13	2080000	24960	167040
90	12	1920000	23040	168960
91	11	1760000	21120	170880
92	10	1600000	19200	172800
93	9	1440000	17280	174720
94	8	1280000	15360	176640
95	7	1120000	13440	178560
96	6	960000	11520	180480
97	5	800000	9600	182400
98	4	640000	7680	184320
99	3	480000	5760	186240
100	2	320000	3840	188160