{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Detailed Input Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Detailed Input Sheet","index":0,"n_rows":332,"n_cols":14,"rows_kept":332,"cut":false,"hidden":false,"merged":[[220,2,220,3],[20,1,20,4],[284,1,284,2],[284,3,284,11],[283,1,283,5],[0,0,0,13],[2,0,2,13],[5,1,5,10],[9,1,9,3],[12,1,12,10],[15,1,15,10],[17,1,17,4],[54,3,54,13],[73,1,73,6],[74,2,74,9],[75,2,75,3],[75,4,75,5],[75,6,75,7],[75,8,75,9],[97,4,97,5],[98,4,98,5],[99,4,99,5],[100,4,100,5],[78,2,78,9],[101,4,101,5],[103,0,103,11],[105,1,105,3],[116,1,116,4],[122,1,122,4],[123,1,123,4],[126,1,126,4],[132,1,132,3],[138,1,138,3],[140,0,140,11],[142,1,142,3],[145,1,145,4],[147,1,147,4],[152,1,152,4],[155,1,155,4],[158,1,158,4],[169,0,169,11],[171,1,171,3],[167,1,167,4],[166,1,166,4],[165,1,165,4],[174,1,174,3],[174,4,174,5],[176,1,176,3],[178,1,178,3],[178,4,178,5],[180,1,180,3],[182,1,182,3],[186,1,186,3],[188,1,188,3],[189,1,189,3],[192,1,192,3],[193,1,193,3],[196,1,196,3],[204,1,204,5],[206,1,206,4],[207,1,207,3],[207,4,207,7],[208,1,208,3],[208,4,208,7],[209,1,209,3],[209,4,209,7],[210,1,210,3],[210,4,210,7],[211,1,211,3],[211,4,211,7],[213,1,213,3],[213,4,213,5],[219,1,219,5],[221,2,221,3],[222,2,222,3],[223,2,223,3],[224,2,224,3],[225,2,225,3],[226,2,226,3],[227,1,227,3],[229,1,229,3],[235,1,235,3],[241,1,241,3],[244,1,244,3],[257,0,257,11],[259,1,259,4],[259,5,259,6],[261,1,261,4],[263,1,263,4],[263,5,263,6],[265,1,265,4],[267,1,267,4],[267,5,267,6],[268,1,268,4],[268,5,268,6],[271,1,271,4],[273,1,273,4],[273,5,273,6],[274,1,274,4],[274,5,274,6],[277,1,277,4],[277,5,277,6],[278,1,278,4],[278,5,278,6],[281,1,281,4],[281,5,281,6],[285,1,285,11],[286,1,286,2],[286,3,286,11],[287,1,287,2],[287,3,287,11],[288,1,288,2],[288,3,288,5],[288,7,288,11],[289,1,289,2],[289,3,289,5],[289,7,289,11],[291,1,291,2],[291,3,291,4],[292,3,292,4],[293,3,293,4],[295,1,295,5],[295,6,295,7],[297,1,297,3],[308,1,308,4],[309,1,309,3],[309,4,309,7],[310,1,310,3],[310,4,310,7],[311,1,311,3],[311,4,311,7],[312,1,312,3],[312,4,312,7],[313,1,313,3],[313,4,313,7],[315,1,315,5],[321,1,321,3],[321,4,321,5],[283,13,288,14],[172,1,173,3],[331,1,331,3],[331,4,331,5],[54,1,55,1],[221,1,222,1],[223,1,224,1],[225,1,226,1],[54,2,55,2],[250,2,251,2],[302,2,303,2],[250,3,251,3],[302,3,303,3],[250,4,251,4],[302,4,303,4],[323,1,323,3],[323,4,323,5],[325,1,325,3],[325,4,325,5],[327,1,327,3],[327,4,327,5],[329,1,329,3],[330,1,330,3],[330,4,330,5]]}
["DATA INPUT SHEET (Self Help Group)"]
[]
["SECTION 1 - LIVELIHOOD AND PROFILE OF SHG MEMBERS"]
[]
[1,"Name of the Self Help Group"]
[]
[]
[2,"Year of SHG Formation"]
[]
[3,"Type of SHG\n(Mention Male, Female)"]
[]
[4,"Name of promoting institution/programme"]
[]
[]
["4.a","Add other details of the Promoting Institution"]
[]
[]
["4.b","Please select if associated with government rural development agency?\n(Mention NRLM, NABARD, NGOs, other Govt schemes )"]
["4.c","If not listed, enter the name and details"]
[]
["4.d","If NRLM Supported \n(Please mention Code assigned by SRLM)"]
[null,"Other Affiliation Details of the Self Help Group"]
[null,"Period of Active Engagement"]
[]
[5,"Details of President/Treasurer"]
[null,"Full Name","Gender\n(Mention Male/ Female/Transgender)","Designation","Date of Birth","Aadhar Card No.","Social Category\n(Mention SC/ST/OBC)","Phone Number"]
[]
[]
[null,"Summary"]
[null,"No of SC"]
[null,"No of STs"]
[]
[6,"Details of Other Members"]
[null,"S. No.","Gender \n(Mention Male/ Female/Transgender)","Full Name","Date of Birth","Aadhar Card No.","Social Category\n(Mention SC/ST/OBC)","Phone Number","Number of Members in Household"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,"Summary"]
[null,"No of SC"]
[null,"No of STs"]
[]
[]
[7,"S. No.","Full Name","Current Livelihood & Current Value Addition being done individually by the members either for bona fide livelihood or sale \nPlease mention (Yes/No)"]
[null,null,null,"Agriculture and Allied","Food processing and Sale","Animal Husbandry based","Dairying","Forestry","Minor Forest Produce Sale","Wage Labor (Local)","Wage Labor (Migration)","Service","Other Means of Livelihoods","Average Monthly Cash Income"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,"Summary - Number of Members engaged in this kind of livelihood"]
[]
[8,"Current Value Addition being done by the SHG Member \n(if more than a single sector/product applicable to each member)"]
[null,null,"Current Livelihood & Value Addition being done by individual members for sale "]
[null,null,"Agriculture",null,"Animal Husbandry",null,"Dairy",null,"Minor Forest Produce"]
[null,null,"Please choose the name of ODOP Product with highest production for your SHG and write it in the row below\n(Pick from the List of ODOP Products for your district or other districts in your State)","Please choose the name of ODOP product with second highest production for your SHG and write it in the row below \n(Pick from the List of ODOP Products for your district or other districts in your State)\n","Please choose the name of ODOP Product with highest production for your SHG and write it in the row below\n(Pick from the List of ODOP Products for your district or other districts in your State)","Please choose the name of ODOP product with second highest production for your SHG and write it in the row below \n(Pick from the List of ODOP Products for your district or other districts in your State)\n","Please choose the name of ODOP Product with highest production for your SHG and write it in the row below\n(Pick from the List of ODOP Products for your district or other districts in your State)","Please choose the name of ODOP product with second highest production for your SHG and write it in the row below \n(Pick from the List of ODOP Products for your district or other districts in your State)\n","Please choose the name of ODOP Product with highest production for your SHG and write it in the row below\n(Pick from the List of ODOP Products for your district or other districts in your State)","Please choose the name of ODOP product with second highest production for your SHG and write it in the row below \n(Pick from the List of ODOP Products for your district or other districts in your State)\n"]
[null,"Product Name\n(Left to Right) "]
[null,"Full Name of the SHG member \n(Top to Bottom)","Choose the kind of processing being done by each member for the product written in the Row above \n(Please choose from following acivities: Selling, Trading, Storage, Transportation, Washing, Grading, Sorting, Peeling, Cutting, Crushing, Grinding, Deseeding, Pulping, Cooking, Bottling, Canning, Heating, Packaging etc)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[9,"Bank Details of the SHG"]
[null,"Bank Name"]
[null,"Bank Account Number"]
[null,"IFSC Code"]
[null,"Current Bank Balance (Savings + Deposits)"]
[null,"Year of Opening Account"]
[]
["SECTION 2 - MICRO-CREDIT HISTORY OF THE SHG"]
[]
[10,"Whether the SHG is graded? \nMention Yes/No"]
[null,"If Yes, the Grade of the SHG (A, B or C)"]
[null,"Year of Grading "]
[null,"Name of the Bank and Branch"]
[]
[11,"Who maintains the Record / Books of SHG"]
[null,"Name"]
[null,"Designation"]
[null,"Paying Instition for his/her salary"]
[]
[12,"Regularity of Savings"]
[null,"In the last six months how many members have been providing their saving contribution into the SHG on an average ?"]
[]
[13,"Savings"]
[null,"What is the average total savings/corpus of the group?"]
[]
[14,"Credit Activity - Rotation of the common fund"]
[null,"How much have they internally lent, out of that corpus on an average every month for past six months?"]
[null,"In the last six months how many members have taken loan from the SHG Savings?"]
[]
[15,"Repayment of internal Loans"]
[null,"Out  of  the  above  mentioned  number, how  many  of  the total members have been regularly repaying their installments"]
[]
[16,"Existing/Current Bank Loan Details"]
[null,"Sr. No.","BANK / FI Name","Loan Type \n(Mention Loan to meet Lumpy Needs, Livelihood Needs, Credit Needs, Subsidy based Loans)","Loan Amount","Max Delayed Payment of Dues","No. EMI Served","Loan Status \n(Mention BT to be done, Current, Matured, To be closed, ≤ 3 emi's pdg, Foreclosed and  Moratorium)  ","Loan Outstanding"]
[null,1]
[null,2]
[null,"Total"]
[]
[17,"Loan History of SHG"]
[null,"Sr. No.","BANK / FI Name","Loan Type\n(Mention Loan to meet Lumpy Needs, Livelihood Needs, Credit Needs, Subsidy based Loans)","Loan Amount","Annual Interest Paid (In INR)","Loan Period in Years","Start Date of Loan","Total Interest","Loan End Date"]
[null,1]
[null,2]
[null,"Total"]
[]
["SECTION 3 - INSTITUTIONAL STRENGTH OF THE SHG"]
[]
[18,"Whether the SHG is part of a Federation\nMention Yes/No"]
[null,"If yes, Please specify the Federation Name"]
[]
[19,"Regularity of Group Meetings\nMention: Weekly, Fortnightly, Monthly"]
[null,"Number of Meetings in last 6 months"]
[null,"How many meetings in last six months were held on the day it was scheduled"]
[]
[20,"Attendance in the Meeting"]
[null,"Average attendance in the last six month"]
[]
[21,"Group Norms \nMention: Yes - Documented, Yes - Not Documented but members aware, No Norms"]
[]
[22,"Group Record Keeping"]
[null,"What all books/registers does the SHG maintain ?\nMention: Minutes Meeting Record Book, Savings Ledger, Loan Ledger, Cash Book, No Record Books"]
[]
[23,"Transparency"]
[null,"Are the members aware of the total group savings, loan taken from bank and outstanding (if any), how many members have taken loan from the SHG?\nMention No, if not applicable "]
[]
[24,"Banking Repayment Track of Loans taken by SHGs from banks"]
[null,"Peak Delay:"]
[null,"Average Delay:"]
[]
[25,"Trainings attended by the SHG"]
[null,"Training Organised by \nMention name of training organization : SRLM, DDUGKY, NABARD, NGO or others "]
[null,"Type of Training\nMention General Entrepreneurship/ Food Processing/ Micro Credit/ Others "]
[null,"If Others, enter details"]
[]
["SECTION 4 - DETAILS ABOUT THE EXISTING OPERATIONS OF THE SHG"]
[]
[26,"Nature of Business \nIf related to Food Processing Industry, Mention Yes/No"]
[null,"If No, enter the details of the business activity SHG is engaged in"]
[]
[27,"Classification of existing business related to Food Producing sector in terms of the kind of value addition being done\nMention Farm produce/ Food Produce/Others"]
[]
[28,"Are you actively engaged in processing of ODOP produce identified by State? \nMention Yes/No "]
[]
[29,"If Yes, Select the type of product being manufactured/traded\nAgriculture Produce, Food Product, Others, MFP (Minor Forest Produce)"]
[]
[null,"Product Manufactured/Traded same as ODOP identified by State for the district?\nMention Yes/No"]
[null,"If Not,"]
[null,"Please refer the ODOP list of MoFPI and mention the product"]
[null,"If not listed in the ODOP list of MoFPI, mention the product"]
[]
[]
[null,"Product being Manufactured/Traded same as ODOP identified by State for the district ?\nMention Yes/No"]
[null,"If Not,"]
[null,"Please refer the ODOP list of MoFPI and mention the product"]
[null,"If not listed in the ODOP list of MoFPI, mention the product"]
[]
[]
[null,"If MFP, please select the product being manufactured/Traded"]
[null,"If not listed above please write in the text box below"]
[]
[]
[null,"In case of Others, enter the name of the product being manufactured/Traded"]
[]
[30,"Details of the Infrastructure/Property of Self Help Group"]
[null,"Type of Infrastructure Available","If Applicable, please select the checkbox","Street Address","Village ","Panchayat","Taluk/Block","District","State","Pincode","Contact Number","Ownership of the Infrastructure of Self Help Group \nMention Owned/Leased/Rented ","Leasing/Renting Amount"]
[null,"Godown/ Storage facility"]
[null,"Trading Unit"]
[null,"Manufacturing Unit"]
[]
[31,"Total Number of Experience (In Years) of the relevant business in producing/manufacturing/trading the product/s"]
[]
[32,"Value added Product/s manufactured/traded \n(In case of multiple products, enter details in rows)"]
[null,"Product Name",null,null,"Product Description"]
[]
[]
[]
[]
[]
[33,"List of activities performed while preparing the product"]
[]
[34,"Production & installation capacity"]
[null,"In Quantity"]
[null,"In Amount"]
[]
[35,"Business turnover (Sales and Revenue) - Last 3 Years\n(In INR) "]
[null,"Particulars ","Product Name",null,"Year -1","Year - 2","Year - 3"]
[null,"Food Products"]
[]
[null,"Farm Produce "]
[]
[null,"Others"]
[]
[null,"Total"]
[]
[36,"Total Quantity sold - Last 3 Years\n(In units)",null,null,"Year -1","Year - 2","Year - 3"]
[null,"Food Products"]
[null,"Farm Produce"]
[null,"Other Business"]
[null,"Total"]
[]
[37,"Total Sales generated - Last 3 year\n(In INR)",null,null,"Year -1","Year - 2","Year - 3"]
[null,"Food Products"]
[null,"Farm Produce"]
[null,"Other Business"]
[null,"Total"]
[]
[38,"Net Profit - Last 3 year \n(In INR)",null,null,"Year -1","Year - 2","Year - 3"]
[null,"Total"]
[]
[39,"Current Investment in Plant and Machinery \n(In INR)",null,null,"Year -1","Year - 2","Year - 3"]
[null,"Manufacturing"]
[null,"Other Business"]
[null,"Total"]
[]
[40,"Number of Manpower Usage Details"]
[null,"Tenure of Worker \n(Left to Right)","Seasonal","Temporary","Permanent"]
[null,"Type of Worker \n(Top to Bottom)"]
[null,"Un-Skilled Worker"]
[null,"Skilled Worker"]
[null,"Total"]
[]
[]
["SECTION 5 - DETAILS ABOUT THE PROPOSED - NEW / UPGRADATION PLAN"]
[]
[41,"Classification of proposed business related to Food Producing sector in terms of the kind of value addition being done\nMention: Food products (Manufacturing), farm Produce (Trading), Others"]
[]
[42,"Are you planning to engage in processing of ODOP produce identified by State?\nMention Yes/No"]
[]
[43,"If Yes, select the type of product to be manufactured/traded\nMention: Agriculture Produce, Food Product, Others, MFP (Minor Forest Produce)"]
[]
[null,"Product Manufactured/Traded same as ODOP identified by State for the district?\nMention Yes/No"]
[null,"If Not,"]
[null,"Please refer the ODOP list of MoFPI and mention the product"]
[null,"If not listed in the ODOP list of MoFPI, mention the product"]
[]
[]
[null,"Product being Manufactured/Traded same as ODOP identified by State for the district ?\nMention Yes/No"]
[null,"If Not,"]
[null,"Please refer the ODOP list of MoFPI and mention the product"]
[null,"If not listed in the ODOP list of MoFPI, mention the product"]
[]
[]
[null,"If MFP, please select the product being manufactured/Traded"]
[null,"If not listed above please write in the text box below"]
[]
[]
[null,"In case of Others, enter the name of the product to be manufactured/traded"]
[]
[44,"Address of the proposed manufacturing/trading enterprise \n(if different from existing)"]
[null,"Street: "]
[]
[null,"Taluk/Block:"]
[null,"Village"]
[null,"District:",null,null,null,null,"Panchayat"]
[null,"State:",null,null,null,null,"Pin:"]
[]
[45,"Ownership of Proposed Property\nMention Owned/ Rented/ Leased"]
[null,"Rent/Lease Period"]
[null,"Rent/Leased Amount (Yearly)"]
[]
[46,"Is the proposed project an upgradation of existing business related to Food Processing or a new project? \n(Mention Upgradation of existing business/New Project )"]
[]
[47,"Proposed Production & Installation Capacity"]
[null,"In Quantity"]
[null,"In Amount"]
[]
[48,"Proposed Manpower Required Details"]
[null,"Tenure of Worker \n(Left to Right)","Seasonal","Temporary","Permanent"]
[null,"Type of Worker \n(Top to Bottom)"]
[null,"Un-Skilled Worker"]
[null,"Skilled Worker"]
[null,"Total"]
[]
[49,"Value added Product/s to be manufactured \n(In case of multiple products, enter details in rows)"]
[null,"Proposed Product Name",null,null,"Product Description"]
[]
[]
[]
[]
[]
[50,"Quotation Details for the proposed Machineries/Equipments \n(Upload the photocopy)"]
[null,"S.No.","Machinery Name","Rate (Amount)","Quantity","Quotation Number","Vendor Name","Date of Issue","Vendor Contact Number","Expected Month of Acquisition","Expected Month of Installation"]
[]
[]
[]
[]
[51,"Proposed Business turnover \n(Sales and Revenue, In INR) "]
[]
[52,"Proposed Total Quantity to be sold in a year\n(In units)"]
[]
[53,"Proposed Total Sales to be  generated in a year \n(In Values)"]
[]
[54,"Proposed Net Profit in a year \n(In INR)"]
[]
[55,"Contribution of the Self Help Group"]
[null,"Group Contribution \n(10% of Project Cost - In INR)"]
[null,"Margin Money for Working Capital \n(20% - In INR)"]