Guidelines for entering data into the Vidatha Resource Center monitoring System.

Guidelines for entering data into the Vidatha Resource Center monitoring System.

 

1.          The monitoring system prepared for monitoring Vidatha Resource Center (VRC) activities through Google Sheets has been shared with your Google Drive. To access it, log in using the email address provided by the Vidatha Resource Center.

If the Google Sheet is not visible in the “Shared with me” folder of your Google Drive, send a message with your center’s name and email address to the WhatsApp number +94718061918.


1.      This Google workbook contains 11 sheets, such as VRC profile and Summary of the progress.

2.      VRC Profile sheet – Enter details relevant to your Vidatha Resource Center.

3.      Summary of the Progress sheet – Do not enter data here, as this sheet updates automatically.


1.      2.1 Ministry Finance TT Programme Sheet –

·         Enter the budgeted data for the 2025 Technology Transfer Programme funded by the Ministry into cells A5:L5.

·         After conducting the programme, enter related data into cells N5:W5.

·         In cell T5, enter the number of beneficiaries using the technology at the time of the final post-review (do not enter the date in this cell).

·         In cells U5 and V5, enter the maximum and minimum number of beneficiaries using the technology, according to pre- and post-reviews.

·         Additionally, open the Google Form linked in cell X3 and submits the same



 

1.      Non-Finance TT Programme Sheet

·         Enter details of Technology Transfer Programmes conducted without ministry funding.

·         Since row 4 cannot be edited, enter data starting from row 5.

·         As with the Finance TT sheet, open the Google Form link in cell N3 and submit the related data. These will also update the Island Progress sheet.

·         If existing rows are insufficient, contact 0718061918 (Ratnapura VRC) to add more rows.

2.      Enter data to other Programme Sheets

·         2.2 AW Programme

·         2.3 Promoting Zero-Plastics Programme

·         3. Promote Innovations

·         4. Conducting Research Activities

·         5. Science and Technology Popularization

·         6. Strengthening the Rural Community Economy

Enter relevant data into these sheets. If there is any unrelated information in your center’s sheet, please remove it.

3.      Programme Codes Sheet- Use the programme codes listed here for entering related programme data.

4.      If your Vidatha Resource Center conducts activities not mentioned in these sheets (e.g., Technical Evaluation Committee, Trade fare,  , entrepreneurial details), you may add a new sheet. 

To do this:

                                                        I.            Go to the last sheet tab.

                                                      II.            Click the “+” symbol as shown in the figure.

                                                    III.            A new sheet will be added for data entry.




Since each district’s and the entire island’s progress Google Sheets are updated based on the data you enter, please ensure data is entered as soon as possible after conducting a programme.

For any further issues, contact: W.M.R.R. Bandara  Science & Technology Officer – Ratnapura  0718061918  email : ratnapuravrc@gmail.com 

Thank you.

W.M.R.R. Bandara 

Science & Technology Officer – Ratnapura

District Progress as of 07/09/2025  


.scrollbox { height: 200px; /* Adjust desired height */ width: 100%; /* Adjust desired width or set to auto */ overflow: auto; /* This is crucial for enabling the scroll bar */ border: 1px solid #ccc; /* Optional: adds a border for visibility */ padding: 10px; /* Optional: adds padding inside the box */ }