{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["inputsheet","working","Proceedings","Enface","100","Bill_form"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"inputsheet","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Name","Thiru KALVIGURU"]
["Designato","teacher"]
["GPF No","158698/EDN"]
["Basic Pay",15000]
["Loan Purpose","His own medical treatment"]
["Previous Loan Amount",51600]
["Previous Aggrigating",201600]
["Loan Current Installment",6]
["Loan Total Installment",36]
["Loan Regular Installment",5600]
["Previous Refernce","R No.   109/2013-14 Dt : 07.02.2014"]
["Previous Loan Reason","His own medical treatment"]
["Recovery Month","Dec'14"]
["DOB","1980-06-01"]
["DOR",{"$f":"IF(DAY(B14)=1,DATE(YEAR(B14)+58,MONTH(B14),0),DATE(YEAR(B14)+58,MONTH(B14)+1,0))","v":"2038-05-31"}]
["Name of the DDO","Headmaster, Govt. High School, Thellar"]
["Do Code","SB5D4"]
["Name of the HM","GOVINDASAMY C"]
["Qualification of the HM","M.Sc., M.Ed., M.Phil.,"]
["Sanction No","R No. 100/2014 "]
["Sanction Date","10.11.2014"]
["Bill No","25/2014-15 Dt :  20.11.2014"]
["Treasury","Sub Treasury, Vandavasi"]
["District Treasury","Tiruvannamalai"]
["kht£l«","ÂUt©zhkiy"]
["Account Slip Year","2014-15"]

{"sheet":"working","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,6,33,7],[1,5,1,7],[2,5,2,7],[29,6,29,7],[30,6,30,7],[31,6,31,7],[33,1,33,5],[29,1,29,5],[28,1,28,5],[26,6,26,7],[27,6,27,7],[28,6,28,7],[26,1,26,5],[27,1,27,5],[30,1,30,5],[31,1,31,5],[32,1,32,5],[32,6,32,7],[0,0,0,8],[3,4,3,6],[22,6,22,7],[23,6,23,7],[25,6,25,7],[22,1,22,5],[23,1,23,5],[25,1,25,5],[24,1,24,5],[24,6,24,7],[2,2,2,3],[2,8,2,9],[22,8,22,9]]}
["tU§fhy it¥ò ãÂ Fé¥Ãš CÂa¥Ão¤j« bjhl®ghd étu«"]
["bga®",null,{"$f":"inputsheet!B1","v":"Thiru KALVIGURU"},null,null,"tU§fhy it¥òãÂ fz¡F v©",null,null,{"$f":"inputsheet!B3","v":"158698/EDN"}]
["Ãwªj njÂ",null,{"$f":"inputsheet!B14","v":"1980-06-01"},null,null,"XŒÎ bgW« njÂ",null,null,{"$f":"inputsheet!B15","v":"2038-05-31"}]
["t.v©","khj«","it¥òãÂ khj rªjh","K‹ gz Ão¤j«","jtiz v©",null,null,"bkh¤j«","fê¡f nt©oa bjhif"]
[1,"Mar'14",3000,5600,2,"/",36,{"$f":"SUM(C5:D5)","v":8600}]
[2,"Apr'14",3000,5600,3,"/",36,{"$f":"SUM(C6:D6)","v":8600}]
[3,"May'14",3000,5600,4,"/",36,8600]
[4,"Jun'14",3000,5600,5,"/",36,8600]
[5,"Jul'14",3000,5600,6,"/",36,8600]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C5:C20)","v":15000},{"$f":"SUM(D5:D20)","v":28000},null,null,null,43000,0]
[]
[null,"it¥ò ãÂ m¿¡ifæ‹ go ãfu ÏU¥ò",null,null,null,null,29853]
[null,"nk‰bfh©L brY¤ÂaJ",null,null,null,null,{"$f":"H21","v":43000}]
[null,"bkh¤j«",null,null,null,null,{"$f":"SUM(G23:H24)","v":72853}]
[null,"fê¡fnt©oaJ",null,null,null,null,{"$f":"I21","v":0}]
[null,"Ï‹iwa njÂ¥go ãfu ÏU¥ò",null,null,null,null,{"$f":"G25-G26","v":72853}]
[null,"ãYit fl‹ bjhif",null,null,null,null,{"$f":"(inputsheet!B9-inputsheet!B8)*inputsheet!B10","v":168000}]
[null,"jFÂah K‹gz¤ bjhif(75%)",null,null,null,null,{"$f":"ROUND(G27*0.75,0)","v":54640}]
[null,"nfhU« K‹gz¤ bjhif",null,null,null,null,53760]
[null,"x‹W nr® bjhif",null,null,null,null,{"$f":"G30+G28","v":221760}]
[null,"bkh¤j jtiz",null,null,null,null,36]
[null,"khj jtiz",null,null,null,null,{"$f":"FLOOR(G31/G32,10)","v":6160}]
[null,"K‹ gz¤ bjhif",null,null,null,null,{"$f":"G33*G32-G28","v":53760}]

{"sheet":"Proceedings","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[29,5,29,8],[15,5,15,8],[17,0,17,8],[26,0,26,2],[27,0,27,2],[26,3,26,4],[27,3,27,4],[26,5,26,6],[27,5,27,6],[22,1,22,5],[23,1,23,5],[25,0,25,8],[19,1,19,5],[18,1,18,5],[20,1,20,5],[21,1,21,5],[8,0,8,8],[9,0,9,8],[12,0,12,3],[11,0,11,3],[13,0,13,8],[0,0,0,8],[1,0,1,8],[3,2,4,8],[6,2,6,8],[7,0,7,8]]}
[{"$f":"\"PROCEEDINGS OF THE \" &inputsheet!B16","v":"PROCEEDINGS OF THE Headmaster, Govt. High School, Thellar"}]
[{"$f":"\" PRESENT:- \" &inputsheet!B18&inputsheet!B19","v":" PRESENT:- GOVINDASAMY CM.Sc., M.Ed., M.Phil.,"}]
[{"$f":"inputsheet!B20","v":"R No. 100/2014 "},null,null,null,null,null,{"$f":" \"Date : \"&inputsheet!B21","v":"Date : 10.11.2014"}]
[null,null,{"$f":" \"Sub:- General Provident Fund-\" &inputsheet!B1 & \"  \"  & inputsheet!B2& \" Advance of Rs.\" &working!G34 &\"/-\"& \" Sanction Regs\"","v":"Sub:- General Provident Fund-Thiru KALVIGURU  teacher Advance of Rs.53760/- Sanction Regs"}]
[]
[]
[null,null,"Ref:- Individual’s Application Dated 28.04.2014"]
[{"$f":"\"    Sanction is hereby accorded under Rule 14(i)a(ii)&c(iii) GPF (Tamil Nadu) Rules for the grant of a Temporary advance of  Rs \" &working!G34 &\"/-  \" & inwords(working!G34) & \"to \" & inputsheet!B1 &\"  \" & inputsheet!B2 & \" and his GPF Ac No.\" & inputsheet!B3 & \" to enable to defray expenses of  \" & inputsheet!B5","v":"    Sanction is hereby accorded under Rule 14(i)a(ii)&c(iii) GPF (Tamil Nadu) Rules for the grant of a Temporary advance of  Rs 53760/-   RUPEES FIFTY THREE THOUSAND  SEVEN HUNDRED AND SIXTY ONLY to Thiru KALVIGURU  teacher and his GPF Ac No.158698/EDN to enable to defray expenses of  His own medical treatment"}]
[{"$f":"\"A Sum of Rs. \"&inputsheet!B7&\"/- out of advance of Rs. \"& working!G28 &\"/- Sanctioned and paid to him/her in\"&inputsheet!B11&\" has not been recovered as on date. This amount to gather with the advance now sanctioned aggregating Rs. \"&working!G31& \"/-  \" & inwords(working!G31)  & \" will be recovered in \" & working!G32&\" Installments\"","v":"A Sum of Rs. 201600/- out of advance of Rs. 168000/- Sanctioned and paid to him/her inR No.   109/2013-14 Dt : 07.02.2014 has not been recovered as on date. This amount to gather with the advance now sanctioned aggregating Rs. 221760/-   RUPEES TWO LAKH TWENTY ONE THOUSAND  SEVEN HUNDRED AND SIXTY ONLY  will be recovered in 36 Installments"}]
[{"$f":"\"Monthly installment of  Rs. \" &working!G33&\"/-\" & \" each commencing from \" &inputsheet!B13","v":"Monthly installment of  Rs. 6160/- each commencing from Dec'14"}]
["The expenditure is debatable to"]
["\"8009-State Provident Fund-01-Civil"]
["General Provident Fund –S A-16\""]
[".Cetified that this advance is sanctioned after the expiry for six month from the date of Sanction of Previous advance"]
[]
[null,null,null,null,null,{"$f":"inputsheet!B16","v":"Headmaster, Govt. High School, Thellar"}]
[]
["Annexure"]
[1,"Basic Pay",null,null,null,null,{"$f":"inputsheet!B4","v":15000}]
[2,"Balance at Credit of the Subscriber as on   Date",null,null,null,null,{"$f":"working!G27","v":72853}]
[3,{"$f":"\"Balance as per the latest Account slip Furnished by the Account Gereral \" &inputsheet!B26","v":"Balance as per the latest Account slip Furnished by the Account Gereral 2014-15"},null,null,null,null,{"$f":"working!G23","v":29853}]
[4,"Add. Subsequent and refunds of Withdrawals                 ",null,null,null,null,{"$f":"working!H21","v":43000}]
[5,"Deduct subsequent withdrawals if any                   ",null,null,null,null,{"$f":"working!I21","v":0}]
[6,"Balance as on date",null,null,null,null,{"$f":"working!G27","v":72853}]
[]
[" Amount of advances outstanding in any and the purpose for which advance was taken."]
["Amount Sanctioned",null,null,"Purpose for which Sanctioned",null,"Amount Pending recovery"]
[{"$f":"\"Rs. \"&inputsheet!B6&\" Rs.\"&inputsheet!B7&\" (Aggrigating)\" & \" Sanctioned\" &inputsheet!B11","v":"Rs. 51600 Rs.201600 (Aggrigating) SanctionedR No.   109/2013-14 Dt : 07.02.2014"},null,null,{"$f":"inputsheet!B12","v":"His own medical treatment"},null,{"$f":"\"Rs. \"& working!G28","v":"Rs. 168000"}]
[]
[null,null,null,null,null,{"$f":"F16","v":"Headmaster, Govt. High School, Thellar"}]
["Copy to",{"$f":"\"1.\"&inputsheet!B23","v":"1.Sub Treasury, Vandavasi"}]
[null,"2. Individual"]
[null,"3. Office File"]

{"sheet":"Enface","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,1],[3,0,10,0],[3,1,10,1],[3,2,10,2]]}
["ENFACEMENT SLIP"]
[{"$f":" \"Drawing Officer : \" &inputsheet!B16","v":"Drawing Officer : Headmaster, Govt. High School, Thellar"},null,{"$f":" \" D.O. Code :\" & inputsheet!B17","v":" D.O. Code :SB5D4"}]
["Head of Account","DP Code","Amount"]
["8009-State Profident Fund - 01 Civil General Provident Fund - SA -15A","800900101AA0108",{"$f":"working!G34","v":53760}]
[]
[]
[]
[]
[]
[]
[]
["`","Deduction",0]
[null,"Net",{"$f":"C4-C12","v":53760}]

{"sheet":"100","index":4,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,1],[18,6,18,7],[4,0,4,7],[5,0,5,7],[6,0,6,3],[7,0,10,3],[7,4,10,7],[11,0,11,3],[11,4,11,7],[12,0,12,3],[12,4,13,7],[14,4,14,7],[15,4,15,7],[16,0,17,7],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7]]}
[{"$f":"\"Bill No \" &inputsheet!B22","v":"Bill No 25/2014-15 Dt :  20.11.2014"}]
[{"$f":"\" Sub Treasury \"&inputsheet!B23","v":" Sub Treasury Sub Treasury, Vandavasi"}]
["jäœehL fUñy éÂ bjhF¥ò  got« v© 100"]
["(16-M« fUñy éÂæ‹ 2(11) Jiz éÂia¡ fh©f)"]
["gz« tH§F« mYty®fŸ fUñy§fëš gz« nfhU« nfhç¡iffSl‹ Ïiz¤J bršy nt©oa Ó£L"]
["(fUñy mYtyuhš _y¢Ó£^ ÂU¥Ã mD¥g¥gLjš nt©L«"]
[]
["bgUªjiy¥ò                                                                 fz¡F ÁW jiy¥ò (m) c£jiy¥ò                               ãÂ xJ¡Ñ£o‹ c£jiy¥ò                            Kªija bryÎ                                                      ehsJ tiuæYkhd bryÎ",null,null,null,{"$f":"Enface!A4 & \"  DP Code \" &Enface!B4","v":"8009-State Profident Fund - 01 Civil General Provident Fund - SA -15A  DP Code 800900101AA0108"}]
[]
[]
[]
[{"$f":"\" bgWe®                                                                   fUñy mYty®, \"&inputsheet!B25","v":" bgWe®                                                                   fUñy mYty®, ÂUt©zhkiy"},null,null,null,"fUñy¤jhš ãu¥g¥gl nt©oaJ                                                       bgWe®"]
["gzkh¡Ftj‰fhf, g£oæ‹ fUñy¢ bryÎ¢ Ó£o‹ v©izÍ« ehëidÍ« bjçé¡fÎ«",null,null,null,"Ñœ g¡f¤Âš F¿¥Ã£lthW................. v‹w v©â£l ehë£l fUñy¢ bryÎ¢ Ó£L ÂU¥Ã mD¥g¥gL»wJ"]
[]
["ifbah¥g« ",null,null,null,"ifbah¥g«"]
["gz« vL¡F« mYty®",null,null,null,"fUñy mYty®"]
[{"$f":"inputsheet!B1 & \" GPF Temp Advance\"","v":"Thiru KALVIGURU GPF Temp Advance"}]
[]
["bkh¤j« ",null,{"$f":"Enface!C4","v":53760},"Ão¤j«",{"$f":"Enface!C12","v":0},"ãfu«",{"$f":"Enface!C13","v":53760}]

{"sheet":"Bill_form","index":5,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[32,8,32,11],[35,0,35,11],[31,0,31,2],[32,0,32,2],[33,0,33,2],[30,5,30,6],[31,5,31,6],[27,0,27,7],[28,0,28,7],[28,8,28,11],[29,0,29,9],[31,8,31,11],[0,0,19,0],[20,0,20,11],[21,0,21,11],[22,0,22,11],[23,1,23,3],[23,4,23,5],[23,7,23,8],[0,1,0,11],[1,1,1,11],[2,1,2,11],[3,1,3,11],[4,1,4,11],[5,3,6,4],[5,5,6,5],[24,0,24,10],[25,0,25,10],[26,0,26,11],[27,8,27,11],[5,6,6,6],[5,7,5,9],[13,7,14,11],[13,1,14,3],[8,3,8,4],[9,3,9,6],[10,4,10,5],[5,10,6,10],[5,11,6,11],[7,3,7,4],[5,1,6,1],[5,2,6,2]]}
[{"$f":"\"Claim Under Rs.\" & I11+1&\"/-\"&inwords(I11+1)","v":"Claim Under Rs.53761/- RUPEES FIFTY THREE THOUSAND  SEVEN HUNDRED AND SIXTY ONE ONLY "},{"$f":"\"Payable at \" &inputsheet!B23","v":"Payable at Sub Treasury, Vandavasi"}]
[null,"Madras Treasury Code Form No 40-A"]
[null,"(See Instuctions 4(i) to (iii) under Treasury Rule- 17)"]
[null,"Bill for Withdrawal From General and Other Provident Funds(Madras)"]
[null,{"$f":" \"District \"  & inputsheet!B24& \" Sub Account  SA15 Voucher No...................................of \" &YEAR(TODAY()) & \" State Provident Fund General Provident Fund Rupee Branch Bill for with drawing Advance with drawls from the General Provident Fund of\" & inputsheet!B1& \"  \" & inputsheet!B2& \" for the month of \" &TEXT(NOW(),\"mmm\")& \"-\" & YEAR(TODAY())","v":"District Tiruvannamalai Sub Account  SA15 Voucher No...................................of 2016 State Provident Fund General Provident Fund Rupee Branch Bill for with drawing Advance with drawls from the General Provident Fund ofThiru KALVIGURU  teacher for the month of May-2016"}]
[null,"Sno","Name and Designation of Scubscriber","Pay",null,"Fund account number","Number and date of sanction letter of authority","Nature of withdrawal",null,null,"Acquittance","Remarks"]
[null,null,null,null,null,null,null,"Part Final Payment","Advance","Others"]
[null,1,{"$f":"inputsheet!B1&\" \" &inputsheet!B2","v":"Thiru KALVIGURU teacher"},{"$f":"inputsheet!B4","v":15000},null,{"$f":"inputsheet!B3","v":"158698/EDN"},{"$f":"Proceedings!A3& \"  \" & Proceedings!G3","v":"R No. 100/2014   Date : 10.11.2014"},null,{"$f":"'100'!G19","v":53760},"-"]
[null,null,null,null,null,null,"Total"]
[null,null,null,"Deduct amount short drawn in this bill",null,null,null,"-","-"]
[null,null,null,null,null,null,"Net Amount",null,{"$f":"I8","v":53760}]
[null,"Particular of Amount Refunded:-"]
[null,"Sno","Name and Designation of Scubscriber","Fund account number","Date of Drawal","Particulars of amount drawn","Amount now refunded",{"$f":" \"Net amount Required for payment \" &\"Rs.\"&I11&\"/-\"","v":"Net amount Required for payment Rs.53760/-"}]
[null,"Nil",null,null,null,null,null,{"$f":"inwords(I11)","v":" RUPEES FIFTY THREE THOUSAND  SEVEN HUNDRED AND SIXTY ONLY "}]
[null,null,null,null,"Total"]
[null,null,null,null,null,null,null,"Signature of Drawing Officer_______________"]
[null,null,null,null,null,null,null,"Designation"]
[null,"Station : ",null,null,null,"Content received",null,null,"Please pay to Individual ECS Account"]
[]
[null,"Date  ",null,null,null,"Signature of messenger",null,null,"Signature___________________"]
[{"$f":"\" 1.  Certified that I have satisfied myself that all sums included in bill(Form No. 40A) drawn on month/two months three months previous to this date if favour \" & inputsheet!B1 & \" Account No \" & inputsheet!B3 &  \" with the exception of those detailed\" & \"(of which the total has been refunded by deduction in this bill) have been disbursed to the proper persons acquaintance have been taken and filled in my office with receipt stamps duly cancelled for every payment excess Rs. 20/-\"","v":" 1.  Certified that I have satisfied myself that all sums included in bill(Form No. 40A) drawn on month/two months three months previous to this date if favour Thiru KALVIGURU Account No 158698/EDN with the exception of those detailed(of which the total has been refunded by deduction in this bill) have been disbursed to the proper persons acquaintance have been taken and filled in my office with receipt stamps duly cancelled for every payment excess Rs. 20/-"}]
["2.    Certified that the balance in the fund at the credit of the subscriber on the date of withdrawal covers the sum drawn in the bill"]
["3.   Certified that the policies detailed below has/have already been assigned in favour of the Governor of Tamilnadu and forwarded to the Accounts officer for safe custed the details of the policy /proposed to be taken up have been communicated to and accepted by Accounts officer in his letter no. …………. Dated……………..."]
["SNo","Name of the subscriber with provident Fund Account Number",null,null,"Number of Policy",null,"Name of the Company","Amount of Premium",null,"Due date of Premium","Stock Number"]
["01.  Certified that the amount claimed in this bill was not drawn and paid previously"]
["02.  Certified that the advance sanctioned after the expiry of for six month from the date of sanction of previous advance"]
["4.    Certified that in respect of withdrawals made in bills (Form No. 40A one month/two months/three months previous to this date towards payments of insurance premium.  Original Premium receipt have been with in one month of the date of with drawl for warded to the Accountant general Madras for security with the exception to those relating to ………………………….. for Rs. ……………… and the necessary endorsement have been made one the receipts to the effect no abatement of income tax is  admissible"]
["5 a. Certified that number of policies financed from the provident  fund does not exceeded four",null,null,null,null,null,null,null,"Signature ________________________"]
["5 b. Or certified that the number of policies financed from the provident Fund which exceed four were already accepted prior st October 1953",null,null,null,null,null,null,null,"Pay Rs__________________________"]
["6 a. Certified that this amount drawn in this bill is for payment of the first premium to take up a frees police Rupees"]
[null,"Rs.",null,null,null,"Accountant (For use in Audit Office)",null,null,"Treasury"]
["Admitted………..",null,null,null,null,"Item……………. Of……………",null,null,"…………………office"]
["Objected………….",null,null,null,null,null,null,null,"Accounts Details of objection, if any"]
["Total……………"]
[null,null,null,"Auditor",null,null,null,"Accountant"]
["Note: The bills for withdrawal of advances final withdrawal should be supported by a duly certified copy of the sanction in the proper from the letter of authority issued by the audit office.  In the case of non gazeeted govt servant the copy should be attedter by the head of the office.  In the case of bills fot withdrawal for payment of insurance premia reference to the lette of authority issued by tha Audit officer permitti"]