new microsoft excel worksheet.xlsx

Upload: yuvarajyuvaraj

Post on 09-Mar-2016

217 views

Category:

Documents


0 download

TRANSCRIPT

  • To be paid details listExpenditure Amount TotalPanchayat Tax 106000

    106000 106000Salary Teaching Staff upto Sep- 15 4120432Non Teaching Staff upto Dec - 15 110104Admin & Supporting Staff upto Dec-15 253277Relieved Staff 2210277

    6694090 6694090Book SuppliersA.R.Publications 5544Global Publishers 54022G.Balaji Publishers 34690Sri Krishan Hitech Publishing 57506Anuradha Publisations 7980Sri Dhanam Publishers 11532Ashir Amirtham Publications 15200VRB Publishers 46260Sri Maruthi Publishers 33533Dhanam Publications 28380

    294647 294647Equipment Suppliers

    Megatronics 443286Mighty Electronics Euipments Corporation 785339Mindpower Engineering Solutions Pvt Ltd 108750Supreme Scientific Corporation 188812TMC Engineering Pvt Ltd 249131Tamilnadu Engineering Works - Henri 252500

    2027818 2027818HostelVysya Hostel upto June - 15 2534650

    2534650 2534650Otherspassed out Students Refund - Tuition Fee 137900passed out Students Refund - Caution Depo 888900Vodafone 41683Scholarship - BC / MBC 22770Private Loan 703781Private Loan - Mrs.Sakthimohan 19000

    1814034 1814034Consultancy Charges2015 - 2016 consultancy 307400Justin 5000Amarnath 20000

    332400 332400

  • Grand Total 1E+007

  • 25.01.16Income15-16 balance College Fees - UG 192185015-16 balance College Fees - PG 50000FG 360000SC / ST 15 - 16 7500000

    Bihar 09831850 9831850

    Income 9831850Expenses 13803639

    Shortage -3971789

  • Salary pending list for the year of 2014 - 2015Sl.No Name Mar April May June July

    1 Principal2 Angurajsiva.J3 Arockiadoss.A4 Arunkumar.A5 Balamurugan.P 0 0 0 06 Balamurugan.T 0 0 0 0 07 Dhinakaran.R 0 0 0 0 08 Balusamy.R9 Barkathulla

    10 Chinnadurai.R11 Devasagayam.M12 Divya.K13 Eswaran.P 0 0 0 0 014 Gayathri.D15 Gobinath.M 15355 17000 1700016 Jagadeshan.G17 John Bosco.P18 Kanagaraj.S19 Kavipriya.M20 Manikandan.N 0 0 0 0 021 Nataraj.G 0 0 0 022 Nithya Devi.P 0 0 0 0 023 Parthiban.R24 Parasakthi.V25 Premkumar.S26 Raja.K27 Rajasekaran.G28 Rangasamy.P29 Saravanamoorthi.A 0 0 0 0 030 Sakthivel.C31 Santhiya.C32 Sellappan.C 0 0 2000033 Seralathan.V 41000 41000 41000 41000 4100034 Suganya.R35 Thailan.V 0 0 0 2800036 Thendral.R37 Velusamy.K 16258 18000 1800038 Venkatesan.M39 Venkatesan.J.M 16258 0 0 0 18000

    88871 41000 41000 76000 142000

    Sl.No Name July.15 August .15Sept.15 15-Oct 15-Nov1 Prabakaran.V 9500 95002 Sudakar.G 5000 50003 Sugumar.G 0 0 40004 Kamala.G 5056 5323 5225 55005 Malendha 6500 6500 65006 Silambarasan.K.S 5000 5000 5000 5000 50007 Karthik.P

    Total 10056 16823 26225 10000

    Sl.No Name June.15 July.15 Augu.15 Sept.15 15-Oct1 Sivakumar.D 30000 30000 30000 30000 0

  • 2 Yuvaraj.T3 Varadharajan.S4 Periyasamy .K 80005 Karthick.G6 Subramani.K7 Saravanan.R8 Vijayasarathy.K 7000 6548 0 09 Vijaya

    10 Veerammal .P11 Shanthi .S12 Kalaivani13 Perumayee14 Shanthi.K15 Rasaathi.P16 Lakshmi.V 101617 Poonkodi18 Radha 817 019 Arunachalam20 Shanmugam21 Chellamma22 Mariyamma 0

    Total 30000 37000 36548 30817 9016

  • Salary pending list for the year of 2014 - 2015Aug Sep Oct Dec Jan Feb March April May

    0 0 0 90000 90000 90000 90000

    0 7467 80000 8000

    0 0 12000 12000 12000 12000 12000 120000 0 11613 10839 11226 12000 12000 120000 0 0

    0 0 15000

    0 0 12000

    0 0 0 9000 8710 9000 9000

    0 17000 17000 17000 17000 17000 17000 17000 17000

    0 0 13000 13000 130000 12000 12000 12000

    0 80000 0 0 0 0 10468 106450 17000 17000 16452 17000 17000 17000 16717 170000 0 20000 20000 20000 20000 20000 20000

    0 0 0 7733

    0 0 25000 250000 0 0 30000 30000 30000

    0 20000 20000 20000 20000 20000 20000 20000 2000041000 41000 41000 41000 41000 41000 41000 41000 41000

    0 28000 28000 24839 28000 28000 28000 28000 280000 0 0 10000 10000

    0 18000 18000 18000 18000 18000 18000 18000 18000

    0 18000 18000 18000 18000 18000 18000 18000 1800041000 159000 170613 198130 202226 290000 367178 406917 453645

    15-Dec Total Advance Balance4750 23750 3000 207502500 12500 0 125002000 6000 4500 15002750 23854 2000 218546500 26000 260002500 27500 27500

    0 0 0119604 9500 110104

    15-Nov 15-Dec Total Advance Balance30000 30000 180000 14000 166000

  • 0 11000 11000 0 110004750 4750 100 4650

    0 8000 0 80000 7500 7500 75000 8000 8000 2000 60000 8000 8000 0 80000 0 13548 6047 7501

    467 0 467 0 4673689 3689 500 31893145 3145 1500 16453266 3266 0 32663508 3508 500 30083750 3750 1500 22502823 2823 500 2323

    0 1016 0 10163161 3161 0 3161

    0 817 0 8176000 6000 0 60002903 2903 29035081 5081 0 5081

    0 0 500 -50030467 106576 280424 27147 253277 0

  • Salary pending list for the year of 2014 - 2015June July August Sept Total Advance Balance90000 90000 90000 90000 720000 78500 641500

    11613 11613 0 23226 7113 161137600 7484 7097 6400 44048 7500 365484533 8000 7742 7733 36008 36008

    12000 12000 12000 11400 119400 11000 10840012000 12000 11613 10800 116091 21513 94578

    0 0 015000 15000 14032 11500 70532 500 70032

    15000 15000 30000 8484 215160 0 0 40 -40

    12000 12000 12000 12000 60000 43000 1700012000 12000 24000 6500 17500

    0 6387 9000 9000 60097 5500 5459711613 11600 23213 6513 16700

    17000 17000 17000 17000 253355 5355 2480000 0 14500 14500 9000 5500

    9967 13000 13000 13000 87967 22000 6596712000 12000 12000 10200 82200 16500 65700

    7733 7742 2667 26142 11242 149009717 9935 8433 49198 5935 43263

    17000 17000 17000 16433 202602 8500 19410220000 20000 20000 18333 198333 30000 168333

    7419 10000 17419 10500 691912000 11600 23600 6500 17100

    12000 12000 6500 55006667 7742 7733 29875 29875

    3870 14516 18386 16000 238625000 25000 23387 0 123387 500 12288730000 28548 26613 29500 204661 21248 183413

    0 500 -50012000 12000 24000 6600 17400

    20000 20000 20000 20000 260000 23347 23665341000 41000 41000 41000 738000 24000 714000

    11806 12000 23806 6500 1730624267 27067 300173 32500 267673

    9667 10000 9677 9833 59177 2500 5667718000 18000 18000 18000 268258 11258 257000

    0 332 -33218000 18000 18000 18000 250258 0 250258

    439151 440999 494934 541248 4593912 473480 4120432

  • Salary pending list for the year of 2014 - 2015

  • Staff's Name 2013Sl.No Teaching Staffs April May June July Aug Sep Oct

    1 Alaguvel.M 0 0 0 0 0 0 02 Ashokkumar.R 0 0 0 0 0 0 03 Bakkiaraj.D 30000 19000 29500 28548 0 0 04 Balakrishnan.M 0 0 0 0 0 0 05 Balasuganya.B 0 0 0 0 0 0 06 Bharathi.S 0 0 0 0 0 0 07 Dhivakaran.S 0 0 0 0 0 0 08 Dineshkumar.T 0 0 0 0 0 0 09 Gayathri.K 0 0 0 0 0 0 0

    10 Gopinathan.P 0 0 0 0 0 0 011 Govindaraj.M 0 0 0 0 0 0 012 Jayanthi. 0 0 0 0 8226 9000 677413 Kalaivani.R 0 0 8000 5806 0 0 014 Karthik.R 0 0 0 0 0 0 015 Mahaboob John.Y.M 0 0 0 0 0 0 016 Maheswaran.N.R 0 0 0 0 0 0 017 Manikandan.M 0 0 0 0 0 0 018 Manivannan.D 0 0 0 0 0 0 019 Moorthi.K 0 0 0 0 0 0 020 Muniyappan.S 0 17000 17000 13161 0 0 021 Nithya.P 0 0 0 0 0 0 022 Palanisamy.A 0 0 0 0 0 0 023 Praveen.V 0 0 0 0 0 0 024 Rajesh.A 0 0 0 0 0 0 025 Ramesh.V 0 0 0 0 0 0 026 Rameshkumar.V 0 0 0 0 0 0 027 Ranjithkumar.M 0 0 0 0 0 0 028 Sathyanarayanan.R 0 0 0 0 8855 8700 900029 Shanmuga Sundaram.P 0 0 0 0 0 0 030 Shanthi.S 0 0 0 0 0 0 031 Sivakumar.R 0 0 0 0 0 0 032 Srinivasan.K 0 0 0 0 0 0 033 Sundaresan.N 0 0 0 0 0 0 034 Suresh.R 0 0 0 0 0 0 035 Thiagarajan.C.K 0 0 0 0 0 0 036 Timple Dhivya.P 0 0 0 0 0 0 037 Umarani.M 0 0 0 0 0 0 1200038 Vandhiya Devan.P.M 0 0 0 0 0 0 039 Velmurugan.A 0 0 0 0 0 0 040 Vignesh.N.P 0 0 0 0 0 0 1496841 Vijayakumar.P 0 0 0 0 0 0 042 Vinodh.S 0 0 0 0 0 0 0

    Non Teaching Staffs 0 0 0 0 0 0 01 Rajasekaran.C 0 0 0 0 0 0 0

  • 2 Manikandan.R 0 0 0 0 0 0 0

  • 2013 2014Nov Dec Jan Feb March April May June July Sep Oct Dec

    0 0 0 0 0 20000 20000 20000 20000 18667 18710 187100 0 0 8000 7484 8000 8000 8000 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0

    8550 7403 9000 7875 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 21722 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 11323 0 11742 11700 12581 13000 13000 119520 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 10000 9677 00 0 0 0 0 0 0 0 0 0 0 119520 0 0 0 46037 0 0 0 0 0 0 00 0 0 0 6194 8000 4516 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 17251 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 35082 0 0 0 0 0 0 00 12000 12000 12000 10452 12000 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 45529 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 12000 10452 12000 12000 0 0 0 0 0

    7800 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 16839 0 18000 18000 18000 17700 17710 180000 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 11200 12000 11600 11806 00 0 0 0 0 0 0 0 0 0 8000 80000 0 0 0 0 0 0 0 0 0 7984 7839

    12000 11613 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0

    15467 14452 16000 16000 13935 16000 0 0 0 0 0 00 0 0 0 0 0 0 23500 23500 23500 22742 170000 0 0 0 15677 16500 15097 10200 1161 17100 0 00 0 0 0 0 0 0 0 0 0 0 0

    11000 11000 11000 11000 0 0 0 0 0 0 0 0

  • 0 0 0 0 0 5500 5500 5133 0 0 0 0

  • 2015Jan Feb March April May June July August Sept Total Advance

    20000 19286 20000 20000 20000 0 0 0 235373 00 0 0 0 0 0 0 0 39484 00 0 0 0 0 0 0 0 107048 30000

    24194 25000 25000 25000 0 0 0 0 99194 741940 0 0 0 0 0 0 0 32828 20000 10000 9194 10000 10000 0 0 0 39194 29194

    8000 8000 7613 4533 0 0 0 0 28146 40000 0 0 0 0 0 0 0 21722 00 0 0 0 0 0 7419 9677 5333 22429 5000 9643 9677 10000 10000 5333 0 0 44653 25333

    12371 13000 13000 13000 12371 11267 0 0 160307 00 0 0 0 0 0 0 0 24000 33330 0 0 0 0 0 0 0 13806 00 0 0 0 0 0 0 0 19677 5000

    12581 13000 12581 13000 0 0 0 0 63114 00 0 0 0 0 0 0 0 46037 00 0 0 0 0 0 0 0 18710 0

    10000 10000 10000 7333 0 0 0 0 37333 00 0 0 0 0 0 0 0 17251 00 0 0 0 0 0 0 0 47161 00 0 0 0 0 0 0 0 35082 00 0 0 0 0 0 0 0 58452 00 0 8000 7733 8000 0 0 0 23733 00 0 0 0 0 0 0 0 45529 00 9899 9581 10633 11000 8067 9403 0 58583 00 0 0 0 8000 7733 8000 0 23733 135300 0 0 0 0 0 0 0 46452 00 0 0 0 0 0 0 0 34355 44350 8000 8000 8000 8000 0 0 0 32000 00 0 0 0 0 6000 19032 17419 42451 37451

    18000 18000 18000 18000 18000 17100 18000 16548 265897 350012000 11571 12000 12000 12000 12000 12000 12000 95571 37500

    0 0 0 8850 9000 8850 5081 0 31781 109800 0 0 0 0 0 0 0 46606 5000

    8000 10000 10000 10000 0 0 0 0 54000 50009000 8679 8565 9000 7258 0 0 0 58325 0

    0 0 0 0 0 0 0 0 35613 011613 12000 12000 12000 12000 12000 0 0 71613 410008000 8000 7742 6667 0 0 0 0 30409 0

    0 0 0 0 0 0 0 0 106822 100000 3643 0 0 0 0 0 0 113885 00 0 0 0 0 0 0 0 75735 00 0 0 0 0 0 0 0 2504094 3419500 0 0 0 0 0 0 0 44000 12000

  • 0 0 0 0 0 0 0 0 16133 0Total 2564227 353950

  • Balance

    235373394847704825000308281000024146217222192919320

    160307206671380614677631144603718710373331725147161350825845223733455295858310203464522992032000

    5000262397

    580712080141606490005832535613306133040996822

    11388575735

    216214432000

  • 161332210277

    Sheet1Pending salaryRelieved