{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["INTRO","MASTER","GA79"],"not_rendered":{"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"INTRO","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"merged":[[0,0,16,0],[0,1,0,3],[1,1,1,2],[1,3,17,3],[2,1,2,2],[4,1,4,2],[11,2,15,2],[17,0,17,2]]}
[]
[null,"First Declaration (GA-79) EXCEL UTILITY "]
[null,"HOW TO USE   "]
[null,null,"राज्य कार्मिकों के स्थाईकरण उपरांत आने वाले मार्च माह से राज्य बीमा कटौती हेतु प्रथम घोषणा पत्र  बाबत इस UTILITY का प्रयोग किया जा सकता है ।  किसी प्रकार की तकनीकी कमी पाए जाने पर नीचे दिये गए EMAIL द्वारा अवगत कराने का श्रम करावे।(PLEASE USE LATEST VERSION OF THAT IS  OFFICE 2010 AND ABOVE FOR BEST RESULT)"]
[null,"   1. Install Krutidev 010 Hindi font in your computer for view "]
[null,"1. Master Sheet :-","इस शीट में कार्मिक के नाम ,पद ,नियुक्ति तिथि इत्यादि के साथ मार्च माह का बिल न व दिनांक   की एंट्री करनी है।"]
[null,"2. GA-79  SHEET","यह AUTOGENERATED है केवल बिल न दिये गए बॉक्स मे अंकित करना  है और प्रिंट लेकर बिल के साथ लगाना है।"]
[]
[null,"Disclaimer: -","All care has been taken to keep the information upto date and correct and is for educational purpose only. You are encouraged to consult your Accountant or Advisor before taking any decesion based on this calculator"]
[]
[null,null,"                                  सुधार हेतु सुझाव  आमंत्रित  है "]
[]
[]
[]
[]
[]
[null,null,"                                         joshihansraj72@gmail.com"]

{"sheet":"MASTER","index":1,"n_rows":15,"n_cols":11,"rows_kept":15,"merged":[[1,2,1,10],[3,2,3,3],[3,4,3,5],[3,9,3,10],[5,2,7,2],[5,3,7,3],[5,4,7,4],[5,5,7,5],[5,6,7,6],[5,7,7,7],[5,8,7,8],[5,9,5,10],[6,9,7,9],[6,10,7,10]]}
[]
[null,null,"dk;kZy; jktdh; mPp ek/;fed fo|ky; 13Mhvks,y] ftyk&Jhxaxkuxj "]
[]
[null,null,"Deparment-",null,"Education Department",{"$nulls":3}," Treasury-","Sri Ganganagar "]
[]
[null,null,"S.NO","NAME","DESIGNATION","DATE OF PERMANENT APPOINTMENT","MONTHLY PAY","MOTHLY PREMIUM REALISED","REMARKS","First deduction"]
[{"$nulls":9},"Pay Bill No (March)","Date"]
[]
[null,{"$f":"IF(J9=\"\",\"\",J9&\"_\"&COUNTIF($J$9:$J9,J9))","v":"1_1"},{"$f":"IF(D9=\"\",\"\",1)","v":1},"SAUDAGAR SINGH","TEACHER ","2018-07-28",33800,3000,"-",1,"2020-04-01"]
[null,{"$f":"IF(J10=\"\",\"\",J10&\"_\"&COUNTIF($J$9:$J10,J10))","v":"1_2"},{"$f":"IF(D10=\"\",\"\",C9+1)","v":2},"RAJENDER SINGH","TEACHER","2018-10-01",33800,2200,"-",1]
[null,{"$f":"IF(J11=\"\",\"\",J11&\"_\"&COUNTIF($J$9:$J11,J11))","v":"1_3"},{"$f":"IF(D11=\"\",\"\",C10+1)","v":3},"KULVEER SINGH","TEACHER","2018-05-18",34800,3000,"-",1]
[null,{"$f":"IF(J12=\"\",\"\",J12&\"_\"&COUNTIF($J$9:$J12,J12))","v":"2_1"},4,"LAKHAN LAL","SENIOR TEACHER","2018-09-29",37800,2200,"-",2]
[null,{"$f":"IF(J13=\"\",\"\",J13&\"_\"&COUNTIF($J$9:$J13,J13))","v":""},""]
[null,{"$f":"IF(J14=\"\",\"\",J14&\"_\"&COUNTIF($J$9:$J14,J14))","v":""},""]
[null,{"$f":"IF(J15=\"\",\"\",J15&\"_\"&COUNTIF($J$9:$J15,J15))","v":""},""]

{"sheet":"GA79","index":2,"n_rows":21,"n_cols":17,"rows_kept":21,"merged":[[0,1,0,14],[1,1,1,14],[2,1,2,14],[3,1,3,11],[3,13,3,14],[4,1,4,14],[5,1,5,14],[6,1,6,3],[6,4,6,6],[6,8,6,11],[6,12,6,14],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,5,9,5],[7,6,9,6],[7,7,9,7],[7,8,9,8],[7,9,7,12],[7,13,9,13],[7,14,9,14],[8,9,8,12],[17,1,17,14],[18,1,18,4],[18,6,18,8],[18,11,18,12],[20,1,20,14]]}
[]
[null,{"$f":"MASTER!C2","v":"dk;kZy; jktdh; mPp ek/;fed fo|ky; 13Mhvks,y] ftyk&Jhxaxkuxj "}]
[null,"GOVERMENT OF RAJASTHAN"]
[null,"Statement of first deduction on account of Insurance Premium for the month of  March ",{"$nulls":10},2021,"Schedule-B"]
[null,"Classification-R- Unfunded Debt - Other Accounts"]
[null,"       State Goverment Insurance Fund",{"$nulls":14},"BILL NO"]
[null,"Deparment-",null,null,{"$f":"MASTER!E4","v":"Education Department"},{"$nulls":3},"    Treasury- ",{"$nulls":3},{"$f":"MASTER!J4","v":"Sri Ganganagar "},{"$nulls":3},1]
[null,"S.NO","S.NO","NAME","DESIGNATION","DATE OF PERMANENT APPOINTMENT","MONTHLY PAY","MOTHLY PREMIUM REALISED","REMARKS","FOR INSURANCE DEPARMENT USE",{"$nulls":3},"INITIALS","REMARKS"]
[{"$nulls":9},"ADJUSTED TOWARDS"]
[{"$nulls":9},"PREMIUM","POLICY NO","SUSPENCE","DECL.NO"]
[null,1,{"$f":"IF(D11=\"\",\"\",1)","v":1},{"$f":"IFERROR(INDEX(MASTER!$D$9:$D12,MATCH('GA79'!$Q$7&\"_\"&B11,MASTER!$B$9:$B12,0)),\"\")","v":"SAUDAGAR SINGH"},{"$f":"IFERROR(INDEX(MASTER!$E$9:$E12,MATCH($Q$7&\"_\"&$B11,MASTER!$B$9:$B12,0)),\"\")","v":"TEACHER "},{"$f":"IFERROR(INDEX(MASTER!$F$9:$F12,MATCH($Q$7&\"_\"&$B11,MASTER!$B$9:$B12,0)),\"\")","v":"2018-07-28"},{"$f":"IFERROR(INDEX(MASTER!$G$9:$G12,MATCH($Q$7&\"_\"&$B11,MASTER!$B$9:$B12,0)),\"\")","v":33800},{"$f":"IFERROR(INDEX(MASTER!$H$9:$H12,MATCH($Q$7&\"_\"&$B11,MASTER!$B$9:$B12,0)),\"\")","v":3000},{"$f":"IFERROR(INDEX(MASTER!$I$9:$I12,MATCH($Q$7&\"_\"&$B11,MASTER!$B$9:$B12,0)),\"\")","v":"-"},"-","-","-","-","-","-"]
[null,2,{"$f":"IF(D12=\"\",\"\",C11+1)","v":2},{"$f":"IFERROR(INDEX(MASTER!$D$9:$D13,MATCH('GA79'!$Q$7&\"_\"&B12,MASTER!$B$9:$B13,0)),\"\")","v":"RAJENDER SINGH"},{"$f":"IFERROR(INDEX(MASTER!$E$9:$E13,MATCH($Q$7&\"_\"&$B12,MASTER!$B$9:$B13,0)),\"\")","v":"TEACHER"},{"$f":"IFERROR(INDEX(MASTER!$F$9:$F13,MATCH($Q$7&\"_\"&$B12,MASTER!$B$9:$B13,0)),\"\")","v":"2018-10-01"},{"$f":"IFERROR(INDEX(MASTER!$G$9:$G13,MATCH($Q$7&\"_\"&$B12,MASTER!$B$9:$B13,0)),\"\")","v":33800},{"$f":"IFERROR(INDEX(MASTER!$H$9:$H13,MATCH($Q$7&\"_\"&$B12,MASTER!$B$9:$B13,0)),\"\")","v":2200},{"$f":"IFERROR(INDEX(MASTER!$I$9:$I13,MATCH($Q$7&\"_\"&$B12,MASTER!$B$9:$B13,0)),\"\")","v":"-"}]
[null,3,{"$f":"IF(D13=\"\",\"\",C12+1)","v":3},{"$f":"IFERROR(INDEX(MASTER!$D$9:$D14,MATCH('GA79'!$Q$7&\"_\"&B13,MASTER!$B$9:$B14,0)),\"\")","v":"KULVEER SINGH"},{"$f":"IFERROR(INDEX(MASTER!$E$9:$E14,MATCH($Q$7&\"_\"&$B13,MASTER!$B$9:$B14,0)),\"\")","v":"TEACHER"},{"$f":"IFERROR(INDEX(MASTER!$F$9:$F14,MATCH($Q$7&\"_\"&$B13,MASTER!$B$9:$B14,0)),\"\")","v":"2018-05-18"},{"$f":"IFERROR(INDEX(MASTER!$G$9:$G14,MATCH($Q$7&\"_\"&$B13,MASTER!$B$9:$B14,0)),\"\")","v":34800},{"$f":"IFERROR(INDEX(MASTER!$H$9:$H14,MATCH($Q$7&\"_\"&$B13,MASTER!$B$9:$B14,0)),\"\")","v":3000},{"$f":"IFERROR(INDEX(MASTER!$I$9:$I14,MATCH($Q$7&\"_\"&$B13,MASTER!$B$9:$B14,0)),\"\")","v":"-"}]
[null,4,"",{"$f":"IFERROR(INDEX(MASTER!$D$9:$D15,MATCH('GA79'!$Q$7&\"_\"&B14,MASTER!$B$9:$B15,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$E$9:$E15,MATCH($Q$7&\"_\"&$B14,MASTER!$B$9:$B15,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$F$9:$F15,MATCH($Q$7&\"_\"&$B14,MASTER!$B$9:$B15,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$G$9:$G15,MATCH($Q$7&\"_\"&$B14,MASTER!$B$9:$B15,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$H$9:$H15,MATCH($Q$7&\"_\"&$B14,MASTER!$B$9:$B15,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$I$9:$I15,MATCH($Q$7&\"_\"&$B14,MASTER!$B$9:$B15,0)),\"\")","v":""}]
[null,5,"",{"$f":"IFERROR(INDEX(MASTER!$D$9:$D16,MATCH('GA79'!$Q$7&\"_\"&B15,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$E$9:$E16,MATCH($Q$7&\"_\"&$B15,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$F$9:$F16,MATCH($Q$7&\"_\"&$B15,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$G$9:$G16,MATCH($Q$7&\"_\"&$B15,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$H$9:$H16,MATCH($Q$7&\"_\"&$B15,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$I$9:$I16,MATCH($Q$7&\"_\"&$B15,MASTER!$B$9:$B16,0)),\"\")","v":""}]
[null,6,"",{"$f":"IFERROR(INDEX(MASTER!$D$9:$D16,MATCH('GA79'!$Q$7&\"_\"&B16,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$E$9:$E16,MATCH($Q$7&\"_\"&$B16,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$F$9:$F16,MATCH($Q$7&\"_\"&$B16,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$G$9:$G16,MATCH($Q$7&\"_\"&$B16,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$H$9:$H16,MATCH($Q$7&\"_\"&$B16,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$I$9:$I16,MATCH($Q$7&\"_\"&$B16,MASTER!$B$9:$B16,0)),\"\")","v":""}]
[null,7,"",{"$f":"IFERROR(INDEX(MASTER!$D$9:$D16,MATCH('GA79'!$Q$7&\"_\"&B17,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$E$9:$E16,MATCH($Q$7&\"_\"&$B17,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$F$9:$F16,MATCH($Q$7&\"_\"&$B17,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$G$9:$G16,MATCH($Q$7&\"_\"&$B17,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$H$9:$H16,MATCH($Q$7&\"_\"&$B17,MASTER!$B$9:$B16,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(MASTER!$I$9:$I16,MATCH($Q$7&\"_\"&$B17,MASTER!$B$9:$B16,0)),\"\")","v":""}]
[null,"NOTE- This from is to be used only for officials in regard to whom recoveries are to be made for the first time. "]
[null,"Certified that recoveries amounting to",{"$nulls":3},{"$f":"SUM(H11:H17)","v":{"v":8200,"d":"₹ 8,200.00"}},"have been made from pay bill no.",null,null,{"$f":"Q7","v":1},"DATED",{"$f":"INDEX(MASTER!K9:K12,MATCH('GA79'!Q7,MASTER!J9:J12,0))","v":"2020-04-01"}]
[]
[null,"Date-                                                                                                 Signature Of Drawing Officer                                                                                 Verified\n                                                                                                                          Designation                                                                                               Treasury Officer\n"]