ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TO CALCULATE, DOWNLOAD EXCEL FILE AND ADD RESPECTIVE VALUES
2
Saving Calculation sheet_ solar BOOT project under Net Metering ,in Maharashtra
3
Site NameTEST SITE13874346.75
4
Capacity (kWp)1000.00
5
Estimated Specific Generation from Solar Plant in 1st year 1387kWh/kWp
6
Expected Generation from Solar Plant in 1st year 13.87Units in Lacs
7
Actual Consumption from Solar in 1st year (Units in Lacs)13.87
8
Derating of plant(% )0.7%Per annum
9
Day time Variable tariff of DISCOM (Rs. per Unit)7.50as per e-bill copy
10
Discom Escalation (per annum)0.3%Expected
11
Offered solar power tariff(RS./Unit)4.50offered tariff structure
12
Escalation in solar tariff (per annum)0.0%
13
Holidays/non-operational days of the facility(Days)0Assumed only 100% solar power will utilised directly on holidays
14
15
16
Consumer BenefitsProject Year123456789101112131415
17
Discom cost (Rs. per Unit) 7.50 7.52 7.54 7.56 7.58 7.59 7.61 7.63 7.65 7.67 7.69 7.71 7.73 7.75 7.77
18
Solar cost (Rs. per Unit) 4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50 4.50
19
Savings per unit (Rs. per Unit) 3.0 3.0 3.0 3.1 3.1 3.1 3.1 3.1 3.2 3.2 3.2 3.2 3.2 3.2 3.3 198.16 19,815,838.66
20
Expected Generation (lakh units per yr.) 13.87 13.77 13.68 13.58 13.49 13.39 13.30 13.20 13.11 13.02 12.93 12.84 12.75 12.66 12.57 1511.985009 151,198,500.95
21
Banking charges in terms of unit adjustment(lakh units) - - - - - - - - - - - - - - - 891.7127399 89,171,273.99
22
Effective Consumption 13.87 13.77 13.68 13.58 13.49 13.39 13.30 13.20 13.11 13.02 12.93 12.84 12.75 12.66 12.57 62,027,226.96
23
Gross savings (Rs. Lakhs) 41.6 41.6 41.5 41.5 41.5 41.4 41.4 41.4 41.3 41.3 41.2 41.2 41.2 41.1 41.1
24
Cumulative savings (Rs. Lakhs) 41.6 83.2 124.7 166.2 208 249 291 332 373 415 456 497 538 579 620
25
Annual CO2 Savings (Tonne) 1,137 1,129 1,121 1,114 1,106 1,098 1,090 1,083 1,075 1,068 1,060 1,053 1,045 1,038 1,031
26
Cumulative CO2 Savings (Tonne) 1,137 2,267 3,388 4,502 5,608 6,706 7,796 8,879 9,954 11,022 12,082 13,135 14,180 15,218 16,249
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100