OVERVIEW: Indicators data entry grid

Overview: indicators data entry grid

  1. Introduction
  2. Columns of the data entry grid
  3. Example
  4. Where to input data?

Introduction

The Data entry grid allows you to enter actual, progress and target values for yout indicators. To access it, access your Logframe by clicking either on the logframe option in the left menu or the logframe tab when you're in your project dashboard. 

Once you're in your logframe in the top right corner you will see a tab called "Data entry." Click on it in order to access the data entry view. 


Once in the data entry tab, you will see several different sections depending on the number of indicators that your project has, their frequency and the length of your project.


Columns of the data entry grid

The data entry grid contains the following information (or data entry fields):

Column Explanation
INDICATOR Name (title) of the indicator
BASELINE
  • Date: baseline date
  • Value: baseline value
PAST
  • Progress: the progress of the indicator in the last period.
  • Cumulative: the overall value of the indicator at the end of the last period.
CURRENT
  • Progress: the progress of the indicator in the current period.
  • Cumulative: the overall value of the indicator at the end of the current period.
  • Progress target: the progress that was expected for the current period.
  • Cumulative target: the expected overall value of the indicator at the end of the current period.
  • Notes: comment that can be added
FUTURE
  • Progress target: the progress that is expected for the next period.
  • Cumulative target: the expected overall value of the indicator at the end of the next period.
FINAL TARGET
  • Cumulative: the current (actual) value of the indicator.
  • Rate: the % accomplished towards the target. (ie. if you have a baseline of 7 and a target of 12: if the actual value is 9, then the rate will be 40%)

Please note that you can hide some of the columns you don't need and this change will be "remembered" by LogAlto. (when you go back to this interface, the columns you do not want to see will still be hidden). To do so, please refer to the "Hide columns in the data entry grid" article.


Where to input data?

The most important columns are the CURRENT-Progress and the CURRENT-Overall cumulative columns. That is where you will enter the values of the indicators for the current period.

Depending on how the indicator was configured, there may be 3 scenarios:

  • Most common: You will be able to EITHER enter the progress OR the cumulative value. (ie. at the end of the last quarter, the value was 30 trainings done. If you have done 5 more trainings, you can either enter 5 in the "progress" column or enter 35 in the "cumulative" column.)
  • Or your indicator may have been configured in a way that only lets you enter the progress.
  • Or your indicator may have been configured in a way that only lets you enter the cumulative value.
Progress column: enter the values that were achieved during that period (Month, Quarter, Year etc)
Overall cumulative: enter the values if you have them from the beginning of the project's life. 
If you have selected a dependent type of relationship for your indicator, and you have entered values in progress then the system will automatically calculate the cumulative values and viceversa. 

Example

So for example if you have a project that just started, you will not see the "Past" section. 

In the image below, in the section to the left, you see the indicator creation panel (this is in the logframe design section, when you're creating your indicator) 

As you can see, the indicator has a baseline and target values. You can see these will appear in the data entry section as well in the Baseline and the Target sections. 

Right click on the image below and select "Open image in new tab" to see an enlarged version.