Knowledge fuels change - Support energypedia!
For over 10 years, energypedia has been connecting energy experts around the world — helping them share knowledge, learn from each other, and accelerate the global energy transition.
Today, we ask for your support to keep this platform free and accessible to all. Even a small contribution makes a big difference! If just 10–20% of our 60,000+ monthly visitors donated the equivalent of a cup of coffee — €5 — Energypedia would be fully funded for a whole year.
Is the knowledge you’ve gained through Energypedia this year worth €5 or more?
Your donation keeps the platform running, helps us create new knowledge products, and contributes directly to achieving SDG 7.

Donate now and support open access to energy expertise
Thank you for your support, your donation, big or small, truly matters!

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://staging.energypedia.info/index.php?title=Sandbox&oldid=275374"