Difference between revisions of "Sandbox"

From energypedia
***** (***** | *****)
m
***** (***** | *****)
m
Line 1: Line 1:
−
{{#ask:[[Category:CES Country]]  
+
 
−
| ?CES Country Coordinates
+
{| border="0" cellpadding="0" width="95%" style="width:95.0%;" align="center"
−
|format=openlayers
+
|-
−
|limit=200
+
|
−
|center=Chad
+
OCS Version
−
|zoom=2  
+
 
−
|height=350
+
| style="width:110px;" |
−
|markercluster=on
+
Corrected by
−
|mainlabel=-
+
 
−
|control=zoom
+
|
−
|polygons={{CES Regions MainPage}}
+
Bug Name
−
}}
+
 
 +
| style="width:110px;" |
 +
Checked by
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.01
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Watt SHS - wrong calculation Bug - Watt SHS - wrong calculation]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.02
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Wrong fomula for total number of systems / connections in overview sheet Bug - Wrong fomula for total number of systems / connections in overview sheet]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.03
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - EnDev 1 and EnDev 2 / RBF outcomes on the Overview Bug - EnDev 1 and EnDev 2 / RBF outcomes on the Overview]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.04
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Excel omits all columns except A when re-opening Bug - Excel omits all columns except A when re-opening]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.05
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Datastorage Stovey AY currency format to % Bug - Datastorage Stovey AY currency format to percentage]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.06
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - Delete not used columns Feature - Delete not used columns]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.07
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Data Entry "pull-out" regions - crucial data macro Bug - Data Entry "pull-out" regions - crucial data macro]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.08
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Negative EnDev 2 figures Bug - Negative EnDev 2 figures]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.09
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - Translate the one page manual into english Feature - Translate the one page manual into english]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.10
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Cost Efficiency Formula Bug - Cost Efficiency Formula]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.11
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - EnDev 1 Total Costs (PicoPV + Stoves) Bug - EnDev 1 Total Costs (PicoPV + Stoves)] - critical change! change of column "Accountable people"
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.12
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - RBF + non RBF projects : Sum of expenditures still red even if 100 percent Bug - RBF + non RBF projects : Sum of expenditures still red even if 100 percent]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.13
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
correction of 15.12.04
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.14
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - Seperate RBF Overview Feature - Seperate RBF Overview] see 15.12.20
 +
 
 +
| style="height:16px;" |
 +
-
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.14 b
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - Seperate RBF Overview Feature - Seperate RBF Overview] see 15.12.20
 +
 
 +
| style="height:16px;" |
 +
-
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.15 b
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
correction of 15.12.07 (incl. RBF makro)
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.16
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - Standardization of SI types (dropdown) Feature - Standardization of SI types (dropdown)]
 +
 
 +
| style="height:16px;" |
 +
|-
 +
| style="height:16px;" |
 +
15.12.17
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Mixing W and kW Bug - Mixing W and kW]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.18
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - Improve new Sheets: Global Leverage, RBF and Job Creation Feature - Improve new Sheets: Global Leverage, RBF and Job Creation]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.19
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - PicoPV Datastorage - Add a column for people per system Feature - PicoPV Datastorage - Add a column for people per system]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.20
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - Seperate RBF Overview Feature - Seperate RBF Overview]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.21
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - PSL negative value Bug - PSL negative value]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.22
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - Overview Outcome includng/without RBF Feature - Overview Outcome includng/without RBF]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.23
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - Delete Global Leverage sheet Delete Global Leverage sheet]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.24
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Job creation calculation Bug - Job creation calculation] (Please check exactly whether this is what we need to report this indicator)
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.25
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - Move EnDev 1 stove baseline from Sheet Selection to Basic Data Feature - Move EnDev 1 stove baseline from Sheet Selection to Basic Data]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.26
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
tiny format fixing
 +
 
 +
| style="height:16px;" |
 +
-
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.27
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - CO2 calculation - Allow "0" value Feature - CO2 calculation - Allow "0" value]
 +
 
 +
| style="height:16px;" |
 +
Gunnar Wegner
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.28
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Calculation of electrical capacity installed should not include grid Bug - Calculation of electrical capacity installed should not include grid]
 +
 
 +
| style="height:16px;" |
 +
|-
 +
| style="height:16px;" |
 +
15.12.29 - <u>Used for Blueprint</u>
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
changes according to feedback during kick off
 +
 
 +
| style="height:16px;" |
 +
not needed
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.30
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
formatting RBF KPI sheet
 +
 
 +
| style="height:16px;" |
 +
not needed
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.31
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Object variable or With block variable not set Bug - Object variable or With block variable not set]
 +
 
 +
| style="height:16px;" |
 +
Andi Michel
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.32
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - Grid - Data Entry - not all limited values have constraints Bug - Grid - Data Entry - not all limited values have constraints]
 +
 
 +
| style="height:16px;" |
 +
Andreas Michel
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.33
 +
 
 +
| style="height:16px;" |
 +
Jonas & Tim
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - HH size smaller than PicoPV HH Database Bug - HH size smaller than PicoPV HH Database]
 +
 
 +
| style="height:16px;" |
 +
Andreas Michel
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.34
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - RBF KPI - Multiple deployed technologies - sum not possible Bug - RBF KPI - Multiple deployed technologies - sum not possible]
 +
 
 +
| style="height:16px;" |
 +
Andreas Michel
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.35
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - RBF KPI - wrong calculation of PSL Bug - RBF KPI - wrong calculation of PSL]
 +
 
 +
| style="height:16px;" |
 +
Andreas Michel
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.36
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Feature - CO2 calculation - Biogas Feature - CO2 calculation - Biogas]
 +
 
 +
| style="height:16px;" |
 +
Andreas Michel
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.37
 +
 
 +
| style="height:16px;" |
 +
Andreas Michel
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - correction of 15.12.32 ( Bug - Grid - Data Entry - not all limited values have constraints) Bug - correction of 15.12.32]
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.38
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - RBF - wrong calculation of PSL Bug - RBF - wrong calculation of PSL]
 +
 
 +
| style="height:16px;" |
 +
Andreas Michel
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.39
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
[http://endev.energypedia.info/Bug - RBF KPI - second project wrong links Bug - RBF KPI - second project wrong links]
 +
 
 +
| style="height:16px;" |
 +
|-
 +
| style="height:16px;" |
 +
15.12.39b
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
formatting improvement to 15.12.35
 +
 
 +
| style="height:16px;" |
 +
not needed
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.39c
 +
 
 +
| style="height:16px;" |
 +
Tim Raabe
 +
 
 +
| style="height:16px;" |
 +
CO2 calculation: Methane emission factor (kg CH4/animal/year) BD changed from 31 to 1
 +
 
 +
| style="height:16px;" |
 +
not needed
 +
 
 +
|-
 +
| style="height:16px;" |
 +
15.12.39d
 +
 
 +
| style="height:16px;" |
 +
Andreas Michel
 +
 
 +
| style="height:16px;" |
 +
RBF KPI&nbsp; - B11,28,45 format restricted to Dezimal between 0 and 100
 +
 
 +
| style="height:16px;" |
 +
not needed
 +
 
 +
|}
 +
<div style="clear:both;"></div>

Revision as of 13:53, 1 November 2018

OCS Version

Corrected by

Bug Name

Checked by

15.12.01

Tim Raabe

- Watt SHS - wrong calculation Bug - Watt SHS - wrong calculation

Gunnar Wegner

15.12.02

Tim Raabe

- Wrong fomula for total number of systems / connections in overview sheet Bug - Wrong fomula for total number of systems / connections in overview sheet

Gunnar Wegner

15.12.03

Tim Raabe

- EnDev 1 and EnDev 2 / RBF outcomes on the Overview Bug - EnDev 1 and EnDev 2 / RBF outcomes on the Overview

Gunnar Wegner

15.12.04

Tim Raabe

- Excel omits all columns except A when re-opening Bug - Excel omits all columns except A when re-opening

Gunnar Wegner

15.12.05

Tim Raabe

- Datastorage Stovey AY currency format to % Bug - Datastorage Stovey AY currency format to percentage

Gunnar Wegner

15.12.06

Tim Raabe

- Delete not used columns Feature - Delete not used columns

Gunnar Wegner

15.12.07

Tim Raabe

- Data Entry "pull-out" regions - crucial data macro Bug - Data Entry "pull-out" regions - crucial data macro

Gunnar Wegner

15.12.08

Tim Raabe

- Negative EnDev 2 figures Bug - Negative EnDev 2 figures

Gunnar Wegner

15.12.09

Tim Raabe

- Translate the one page manual into english Feature - Translate the one page manual into english

Gunnar Wegner

15.12.10

Tim Raabe

- Cost Efficiency Formula Bug - Cost Efficiency Formula

Gunnar Wegner

15.12.11

Tim Raabe

- EnDev 1 Total Costs (PicoPV + Stoves) Bug - EnDev 1 Total Costs (PicoPV + Stoves) - critical change! change of column "Accountable people"

Gunnar Wegner

15.12.12

Tim Raabe

- RBF + non RBF projects : Sum of expenditures still red even if 100 percent Bug - RBF + non RBF projects : Sum of expenditures still red even if 100 percent

Gunnar Wegner

15.12.13

Tim Raabe

correction of 15.12.04

Gunnar Wegner

15.12.14

Tim Raabe

- Seperate RBF Overview Feature - Seperate RBF Overview see 15.12.20

-

15.12.14 b

Tim Raabe

- Seperate RBF Overview Feature - Seperate RBF Overview see 15.12.20

-

15.12.15 b

Tim Raabe

correction of 15.12.07 (incl. RBF makro)

Gunnar Wegner

15.12.16

Tim Raabe

- Standardization of SI types (dropdown) Feature - Standardization of SI types (dropdown)

15.12.17

Tim Raabe

- Mixing W and kW Bug - Mixing W and kW

Gunnar Wegner

15.12.18

Tim Raabe

- Improve new Sheets: Global Leverage, RBF and Job Creation Feature - Improve new Sheets: Global Leverage, RBF and Job Creation

Gunnar Wegner

15.12.19

Tim Raabe

- PicoPV Datastorage - Add a column for people per system Feature - PicoPV Datastorage - Add a column for people per system

Gunnar Wegner

15.12.20

Tim Raabe

- Seperate RBF Overview Feature - Seperate RBF Overview

Gunnar Wegner

15.12.21

Tim Raabe

- PSL negative value Bug - PSL negative value

Gunnar Wegner

15.12.22

Tim Raabe

- Overview Outcome includng/without RBF Feature - Overview Outcome includng/without RBF

Gunnar Wegner

15.12.23

Tim Raabe

- Delete Global Leverage sheet Delete Global Leverage sheet

Gunnar Wegner

15.12.24

Tim Raabe

- Job creation calculation Bug - Job creation calculation (Please check exactly whether this is what we need to report this indicator)

Gunnar Wegner

15.12.25

Tim Raabe

- Move EnDev 1 stove baseline from Sheet Selection to Basic Data Feature - Move EnDev 1 stove baseline from Sheet Selection to Basic Data

Gunnar Wegner

15.12.26

Tim Raabe

tiny format fixing

-

15.12.27

Tim Raabe

- CO2 calculation - Allow "0" value Feature - CO2 calculation - Allow "0" value

Gunnar Wegner

15.12.28

Tim Raabe

- Calculation of electrical capacity installed should not include grid Bug - Calculation of electrical capacity installed should not include grid

15.12.29 - Used for Blueprint

Tim Raabe

changes according to feedback during kick off

not needed

15.12.30

Tim Raabe

formatting RBF KPI sheet

not needed

15.12.31

Tim Raabe

- Object variable or With block variable not set Bug - Object variable or With block variable not set

Andi Michel

15.12.32

Tim Raabe

- Grid - Data Entry - not all limited values have constraints Bug - Grid - Data Entry - not all limited values have constraints

Andreas Michel

15.12.33

Jonas & Tim

- HH size smaller than PicoPV HH Database Bug - HH size smaller than PicoPV HH Database

Andreas Michel

15.12.34

Tim Raabe

- RBF KPI - Multiple deployed technologies - sum not possible Bug - RBF KPI - Multiple deployed technologies - sum not possible

Andreas Michel

15.12.35

Tim Raabe

- RBF KPI - wrong calculation of PSL Bug - RBF KPI - wrong calculation of PSL

Andreas Michel

15.12.36

Tim Raabe

- CO2 calculation - Biogas Feature - CO2 calculation - Biogas

Andreas Michel

15.12.37

Andreas Michel

- correction of 15.12.32 ( Bug - Grid - Data Entry - not all limited values have constraints) Bug - correction of 15.12.32

Tim Raabe

15.12.38

Tim Raabe

- RBF - wrong calculation of PSL Bug - RBF - wrong calculation of PSL

Andreas Michel

15.12.39

Tim Raabe

- RBF KPI - second project wrong links Bug - RBF KPI - second project wrong links

15.12.39b

Tim Raabe

formatting improvement to 15.12.35

not needed

15.12.39c

Tim Raabe

CO2 calculation: Methane emission factor (kg CH4/animal/year) BD changed from 31 to 1

not needed

15.12.39d

Andreas Michel

RBF KPI  - B11,28,45 format restricted to Dezimal between 0 and 100

not needed

Retrieved from "https://energypedia.info/index.php?title=Sandbox&oldid=275374"