Home › Forums › Excel Utility › School Management Utility
- This topic is empty.
-
AuthorPosts
-
February 14, 2013 at 10:43 am #68486
Dear Mr. Nemo & Mr.Som babu,
I have prepared a school Management Utility for the Govt. aided Schools. The Heads of the Institutions may use it and modify according to their need. The file is password protected- Please open it by using 1963. Please send your suggestions.
Thanking you.
Debabrata Paul. Headmaster, ATBATI ANNAPURNA VIDYAMANDIR( H.S).February 14, 2013 at 12:17 pm #76921thanks mr. paul.
I think it will be helpful for everyone.
let’s see what others say.
thanks once again.February 14, 2013 at 3:50 pm #76923Sir, khub bhalo hoyechhe. Kichhu jaygay problem hochhe. jemon planning page ta te madhyamik click korle kichhu aschhe na. higher secondary page ti te 123 diye kibhabe modify korbo bujhte parchhi na. ektu guide korben please.
February 15, 2013 at 10:24 am #76928Mr.Ambarasish babu,
Unprotectet the page first by using password 123 and then go to object , choose pdf file of your choice and insert. Protect the Sheet again. There is virtually no matter on that page. Down load the Academic Calendar from the Board’s Website and save it in any drive of your choice. After that insert the said file following the above mentioned steps. Its very easy. In case of H.S. there is no need of modification at present.After the expiry of the Session the pdf file will have to be deleted first and next calender be inserted in the same way.In Planning Page you may write your task as per your planning. You may un protect the sheet by using password dp.
Debabrata Paul.February 16, 2013 at 4:09 pm #76944@debabrata babu, the utility is good but there are so much which are not needed by (like non HS school and non vocational ) many schools. But that can not be deleted as the sheets are protected. Please provide some unprotected .xlsm. Otherwise it is bulky enough to work with normal secondary school. Again in the staff info page the D.O.B. can’t be modified as it is protected. There are so many are useless unless unprotected.
Lastly thanks for the utility provided by you.February 17, 2013 at 4:45 am #76952I have download management utility from ur attached file.then can’t open it .please supply correct password thoughemail:sajmathematics@gmail.com
February 17, 2013 at 4:52 am #76953Re: SCHOOL MANEGEMENT UTILITY.
The password is 1963
Unprotected the page first by using password 123February 18, 2013 at 9:02 am #76959DearMr.Chanchal Babu,
Thanks for your letter. Right Click at the bottom of the unnecessary Sheets and then delete.
Debabrata Paul.February 19, 2013 at 3:12 am #76975EDITTING PROBLEM
sir,
some where editing problem by using password,like as drop down list (designation colm to click on it then show -Head master,asst.teacher etc,but does not show librarian)my query how to add “librarian” in drop drop down list.pls suggest me.
thank you very much sir.February 19, 2013 at 6:20 am #76977Re: EDITTING PROBLEM
Dear Mr. Sajmal,
Thanks for your letter.There is no problem in editing the data. The Staff info page is protected but you can easily insert your data in the columns provided. In the School info page drop down list is provided at the bottom. Change or modify the disignation of your choice.
Debabrata Paul.February 20, 2013 at 3:02 am #77001Dear D.B. Sir,
I have downloaded your attach file. But lac of knowledge I couldn’t modify :confused: the utility such as Teacher’s Inf. Please suggest me as soon as possible. :rolleyes:
Thanking You.February 26, 2013 at 4:25 am #77064SCHOOL MANEGEMENT UTILITY
MR.DEBABRATO,
CAN PRESERVE SCHOOL MANAGEMENT UTILITY YEAR BY YEAR? ONE PROBLEM ARISE FOR EDIT IN PAY CERTIFICATES SHEET:EMP NO
WRIGHT 2 ,BUT NO CHANGE NAME OF EMPLOYEE(PREVIOUS NAME).
WHAT HAPPEN? PLEASE GUIDE ME SIR,February 26, 2013 at 3:25 pm #77083Dear Sajmal,
Same problem arises for me. I got a solution.. All the links are created from staff info. First look the row in the Staff info sheet for the employee who is needed pay sleep. Now in the pay certificates sheet just find and replace process( If you aware of excel you must know the process). Like if previous employee id was 12 and your present required employee id is 18 then find 12 first and replace all 12 by 18 that’s all. But there are also some mistakes. In the Gross pay and net salary there are some formulas so some times problem will arise. In that two portions you have to put the correct sum formula.March 3, 2013 at 12:05 pm #77147Respected Debabrata Sir, Page unprotect karar password ki?
March 10, 2013 at 7:40 am #77290Mr. Paul,
I can’t edit/input the data in staff information sheet and can’t unlock by 123 press. Please reply me how I can input the data like Headmistress, Asstt.Headmistress, Librarian and how i add new row.March 12, 2013 at 4:28 pm #77345Mr. Paul,
I can’t edit/input the data in staff information sheet and can’t unlock by 123 press. Please reply me how I can input the data like Headmistress, Asstt.Headmistress, Librarian and how i add new row.March 19, 2013 at 2:07 pm #77433can’t modify protected pages by inserting password 123……..please help me. Is the password correct?
April 4, 2013 at 5:08 pm #77623To, Mr. Paul,
I can’t put any data to input sheet.Macro can’t be enable.
what is mean by drop down list?Where the payroll.xlsm?
how i start to put data ie, in which page?
nabadwipSeptember 10, 2013 at 2:03 pm #78645Sir,
I downloaded your school management excel utility. This is good one.I can not understand how data will transfer
automatically to data base.I think it is not completed.I want to get Individual salary report for a financial year.How can
I get this report using your School Management Utility.Please say something about this.
With regards……………… SubirSeptember 10, 2013 at 4:30 pm #78651IN INPUT TAB I DO NOT ADD TO DATA BASE CAN U TELL THE NAMES YOU ENTERED COMES FROM WHERE??????????
-
AuthorPosts
- You must be logged in to reply to this topic.