Why should you register with NGO-Darpan?

The benefits of registration with NGO-Darpan for Voluntary Organisations (VOs) and Non-Governmental Organizations (NGOs)

About Ngo-Darpan

NGO-DARPAN is a platform that provides an interface between Voluntary Organisations (VOs) / Non-Governmental Organizations (NGOs) and key Government Ministries / Departments / Government Bodies. Later it is proposed to cover all Central Ministries / Departments / Government Bodies.

NITI Aayog invites all VOs / NGOs to sign up on the Darpan Portal. VOs / NGOs play a major role in the development of the nation by supplementing the efforts of the government. 

This NGO-DARPAN portal enables VOs / NGOs to enroll centrally and thus facilitates creation of a repository of information about VOs / NGOs, Sector/State wise. The Portal facilitates VOs / NGOs to obtain a system generated Unique ID, as and when signed. 

The Unique ID is mandatory to apply for grants under various schemes of Ministries/Departments/Governments Bodies.

Currently more than 1,50,000 NGOs are registered with Darpan. More than 50 government departments are participating in it.

Benefits of signing up with NGO-DARPAN

• Completing the NGO Darpan Registration online can help NGOs receive timely and essential updates regarding government grants and other benefits. 
• The portal provides basic information on the NGO. Further NGO database can be searched.
• By obtaining a unique ID the credibility and trustworthiness of an NGO improves when seeking funds from trusts and corporate bodies. This unique online identity is useful specifically for small NGOs in getting visibility. 
• NGOs can present the Darpan Identification Number if they seek FCRA registration for getting foreign funding, though it is made optional now. 

Apple India's sales hit a record in September Qtr2

Ramsar Sites in India

India, on its 75th year of Independence (15th August), achieved a milestone of 75 Ramsar sites. 

It recently added 11 more wetlands to the list of Ramsar sites to make total 75 Ramsar sites covering an area of 13 lakh 26 thousand 677 Hectare in the country. 

I have created an interactive map. Kindly visit the map at https://andybandra.github.io/ramsar_india/ You can see and click the map shown below.

On the map you may click an icon to get the name and state of a site, and its area in hectares.  

India is one of the Contracting Parties to Ramsar Convention, signed in Ramsar, Iran in 1971. India signed it on 1st February 1982. These are wetlands deemed to be of "international importance" under the Ramsar Convention.

What is RAMSAR Wetland Sites

The Ramsar Convention is an international treaty for the conservation and sustainable utilization of wetlands, recognizing the fundamental ecological functions of wetlands and their economic, cultural, scientific, and recreational value.

Tamil Nadu has the highest number of Ramsar Sites in India with 14 Ramsar Sites. The largest site is marked in blue icon. It is the Sundarbans National Park a national park, tiger reserve and biosphere reserve in West Bengal,

The list is available at https://en.wikipedia.org/wiki/List_of_Ramsar_sites_in_India.

75 Ramsar India Sites

CSR-Dashboard

The Benefits of Digital Dashboards for Corporate Social Responsibility

Updated on April 3, 2024

Introduction

Corporate Social Responsibility (CSR) is a self-regulating business model that helps a company be socially accountable. In this digital age, dashboards have become a significant tool in managing CSR activities effectively. Let's delve into the benefits of digital dashboards for CSR.

Real-Time Data

Digital dashboards provide real-time updates and insights, enabling companies to make immediate decisions based on current data. This is particularly useful in CSR initiatives where timely response is crucial.

Improved Transparency

With digital dashboards, companies can share their CSR progress with stakeholders and the public in a transparent manner. This can enhance the company's reputation and build trust among its stakeholders.

Efficient Resource Allocation

Digital dashboards allow companies to see which CSR initiatives are performing well. This can help them allocate resources more efficiently, ensuring that their CSR efforts have the greatest impact.

Let's begin:

I have developed a very simple and easy to understand spend dashboard for corporate social responsibility. it is intended for senior CSR executives such as CSR committee members.

How is this dashboard organised?

On the left hand side, you have the KPIs. and on the right hand side, you have the respective spend shown in percentage of the total. In KPIs, you have the yearly spend, spend by domain (such as education), spend by location ( e.g. state), spent by NGO. It quickly gives a bird eye view of the spend. By choice, it's a static dashboard. It can be updated and customised as often as required. It can be put in conference room, in the reception area for communicating the progress of CSR spend.

Reading the dashboard:

Let's say you want to know the spend on Domain – health. It is shown as 27% as a numeral as well as a corresponding darkened arc in a circle. The arc starts from equivalent position of 9 o'clock on the clock face. Any progresses clock wise. Showing the data in percentages of the total, helps in getting a grasp of the size of the proportion. Let's take another example. We want to know the spend on the top NGO as a percentage of the total. It is shown as 35%. This will help you take an executive decision such as reducing the spend on the top NGO.

How is this dashboard made?

It is drawn using 100% Visual Basic For Applications (VBA). It is customisable in so many different ways. Sustainable Development Goals (SDGs) can also be linked. Similarly you can add photos, logos, other art clippings. 

The concept can be extended to cover other functions namely Sustainability, Marketing, Social Media, Sales, Admin. And many more.

It is not using chars from excel and pasting it in Dashboard. It uses native shape objects of PowerPoint. 

But it uses excel for data and necessary calculations. The VBA code resides in Excel. You may put your actual data. Such static visualisations have great impact in corporate conference room discussions. 

Conclusion

Digital dashboards offer numerous benefits for managing CSR initiatives. By providing real-time data, improving transparency, and aiding in resource allocation, they can help companies make a significant social impact.

Hope you like it. Please do give your suggestions. 

 

Public Cloud revenue 2022 to 2026

#vba

#excel

#powerpoint

Organising data in spreadsheets

The guide is designed so that you may down load it and keep it handy with you for a reference.

For a detailed explanation, please click the blog post.

The below guide explains how to organise data in spreadsheets.

 

Nifty50_index

Nifty50_Index: Rs 2 trillion AUM mark has been breached by ETFs and Index funds tracking the Nifty 50 Index

• April_2022: AUM reaches Rs 2 trillion
• Aug_2020: AUM reaches Rs 1 trillion
• Dec 2001: First ETF linked to Nifty50 - launched

Indian_Unicorns_by_2025

 India could have 250 unicorns by 2025.

Growth of Indian Unicorns

#vba

#powerpoint

#excel

#India