Saturday, February 24, 2024

PROJECT MANAGER Ver.1

                        Now Introducing a new Excel tool PROJECT MANAGER for managing the expenditure and progress of projects under various schemes in LSGI . The abstract of expenditure will automatically generated and so the progress of expenditure and current stage of project  can easily monitored by the higher officers in the Department. if this excel tool opened in a google sheet it is very useful for departmental officers. A file wrapper and monitoring report for completed projects are also included.  The balance amount available after the expenditure will be in Balance sheet and it is very useful for Project revision.
                      While opening the file you can see seven sheets namely Home, Projects, Progress Reports ,Abstact, File wrapper  Monitoring Report and Balance  . In Home sheet You will get a clear idea about this programme  Enter the Basic details such as Name of Office etc.  in Home Sheet 

                     In project sheet enter the project details which will get from the verification report in SULEKHA. Please see the video tutorial published in the you tube channel of Sahaayi dot com for more details. All the Columns are self explanatory and no need of explanation for filling the details . After entering the details of projects enter the corresponding serial No. at the space provided.  In progress Report sheet enter the Expenditure , stage of work or project etc.

                    This version is expanded for all implementing officers in Local Body. I extend my sincere thanks to Smt. Beena. A, Superintending  Engineer , Kollam Corporation who suggests so many corrections  in this tool.     Maximum care has been taken for the accuracy of calculations of data. Any how the user should satisfy himself for the accuracy of calculation and other details. If any discrepancy is noticed mail immediately  to pradeepenthulika@gmail.com and so we can correct the same in the next version. Your valuable comments will boost up my efforts to do more and more. For Downloading the Programme please CLICK HERE