reservedesign.xlsx

	A	B	C	D	E	F	H	I	J	K	L	M
1	PUID	SELECTED	COST	SPEC1	SPEC2	SPEC3	spname	total	target	amount held	target gap	target met
2	1	0	347	0	0	0	1	1337	267.4	0	267.4	NO
3	2	0	52	0	0	0	2	1256	251.2	0	251.2	NO
4	3	0	985	0	0	1	3	1215	243	0	243	NO
5	4	0	207	0	0	0
6	5	0	276	89	0	12
7	6	0	821	30	48	0	Summary information
8	7	0	122	69	4	9
9	8	0	404	0	0	0	SUM COST		0
10	9	0	300	0	0	0	TARGET GAP		761.6
11	10	0	681	0	0	91
12	11	0	813	0	0	0
13	12	0	537	0	0	0
14	13	0	931	0	0	0
15	14	0	653	0	0	0
16	15	0	919	71	43	12
17	16	0	826	99	0	1
18	17	0	455	0	0	0
19	18	0	983	17	0	0
20	19	0	731	0	0	35
21	20	0	875	31	0	0
22	21	0	247	0	0	0
23	22	0	462	55	40	0
24	23	0	287	0	0	0
25	24	0	988	0	2	27
26	25	0	85	70	0	0
27	26	0	736	37	0	56
28	27	0	681	0	0	0
29	28	0	479	0	0	33
30	29	0	459	0	41	0
31	30	0	615	54	0	0
32	31	0	378	0	0	0
33	32	0	986	80	8	0
34	33	0	887	0	47	0
35	34	0	392	0	0	0
36	35	0	526	0	78	0
37	36	0	783	0	0	87
38	37	0	224	66	0	38
39	38	0	149	0	0	0
40	39	0	268	0	0	0
41	40	0	90	0	91	0
42	41	0	977	0	0	0
43	42	0	74	0	0	73
44	43	0	53	0	60	0
45	44	0	390	25	79	0
46	45	0	619	0	0	0
47	46	0	773	11	0	8
48	47	0	952	0	0	0
49	48	0	738	0	0	0
50	49	0	897	0	0	0
51	50	0	580	0	0	53
52	51	0	969	76	34	0
53	52	0	76	0	90	0
54	53	0	147	0	84	0
55	54	0	870	0	0	82
56	55	0	350	0	72	26
57	56	0	543	0	0	0
58	57	0	607	0	0	21
59	58	0	375	58	0	0
60	59	0	903	0	0	0
61	60	0	790	0	54	59
62	61	0	729	75	0	60
63	62	0	492	0	0	0
64	63	0	303	0	0	0
65	64	0	289	0	0	0
66	65	0	490	0	0	0
67	66	0	599	0	0	0
68	67	0	407	91	0	0
69	68	0	651	0	0	57
70	69	0	709	0	42	97
71	70	0	365	0	0	7
72	71	0	571	0	0	0
73	72	0	931	0	37	0
74	73	0	353	0	0	0
75	74	0	64	0	0	0
76	75	0	955	0	0	0
77	76	0	950	0	0	0
78	77	0	855	0	0	0
79	78	0	886	0	23	0
80	79	0	840	0	41	0
81	80	0	598	81	0	37
82	81	0	422	0	0	12
83	82	0	252	0	0	0
84	83	0	941	0	0	0
85	84	0	152	0	53	24
86	85	0	353	0	72	0
87	86	0	123	93	0	0
88	87	0	716	0	0	0
89	88	0	587	0	23	59
90	89	0	346	0	0	0
91	90	0	318	0	0	0
92	91	0	682	0	0	0
93	92	0	891	11	0	0
94	93	0	815	0	14	50
95	94	0	818	0	0	0
96	95	0	726	0	0	88
97	96	0	372	0	0	0
98	97	0	197	0	0	0
99	98	0	89	48	0	0
100	99	0	417	0	0	0