Patient History Template Excel

Why record of patient history is important ? As patients get older it is always better to keep their health related information. It saves a lot of time and during emergencies it can be really helpful. Following are the general contents of medical records Surgical history,Obstetric history,Medications and medical allergies,family and social history,Immunization history,Growth chart for teenagers.user has to fill in the related data such as has the patient ever had any surgery or been hospitalized?/ family history and  any problem…

Read More

List of hospitals India Excel

Download list of hospitals in India along with city ,address,main branch,pincode and std and phone details. A list of around 5347 hospitals and nursing homes. Watch list     Cashless insurance hospitals list. Following are the list of hospitals where cashless facility of health insurance is provided by ICICI pru life and the other one is ok TTK healthcare, TPA/PPN hospitals list for cashless facility. TTK healthcare https://goo.gl/W58yoO ICICI Pru life https://goo.gl/rVZ22C New India insurance http://goo.gl/u4qsJn Bajaj Allianz http://goo.gl/r0DeD3

Read More

Office Relocation Timetable

It can be considered as example sheet to track and manage the dates while moving your office. User can define their major tasks and avoid unnecessary hiccups. We know that there is lots of things to do and you can’t remember every thing as when and what will be the process of shifting. Generally it takes around 4- 6 months to completely move an office,depending on your staff and the type of work that you used to do. Every office…

Read More

Delete All Hidden Worksheets Excel

Why we need macro to do it? It sometimes become cumbersome to find and delete hidden tabs in a worksheet or hidden worksheets in a workbook so we are providing you straight forward method to do so.   Remove hidden worksheets macro : make sure that you have a backup copy of this workbook just in case.       Found this one on mrexcel here this macro will delete all sheets except the one you want to keep. Here…

Read More

Refresh cell value in Excel Using VBA MACRO

This VBA MACRO can help you to refresh selected cells. If you are working on a large and complex data then macros come handy.I found this one from a forum for my friend he used to work for a company where they have to crunch large workbooks. He had to refresh a particular cell or a group of cells again and again.   Here is the code. You have to place error handling near the ‘Set rng’ line. Here is…

Read More

SOLVE #DIV/0! Errors

First of all one should know why this error occurs. It is one of the common errors in spreadsheet programs in which user tries to insert formulas with division operations. We know that we can’t divide a number by zero or a cell that contains no value as it would give error. It returnss #DIV/o!. user have to recheck the values and try to find the problem. How to correct error first of all press ctrl+~ to view the formulas…

Read More

4 Sample Proforma invoice template

It is an estimated invoice sent by seller of goods to buyer before the shipment or delivery of goods. This template consist details regarding the type and qty of goods along with other information such as type,code,weight, fragile or not and other information.   1) Very simple proforma budget sample : It consist only important stuff ,more like a pdf template.One could take a print out. 2) This Pro Forma Invoice sheet comes with macros,user can fill in the exporter,shipper…

Read More

( ͡° ͜ʖ ͡°) How To Plot Correlation In A Graph?

For those who want to practice correlation in excel here is an excellent spreadsheet with data and other examples :  User can explore various aspects of the correlation coefficient. There are various tabs under which different sheets are available the extreme sheet allows user to learn how to handle the extreme cases of positive and negative correlation. The another sheet i.e patterns sheet  show that the same summary statistics will fit many different bivariate patterns. Correlation sheets shows how the correlation coefficient changes as…

Read More

Printable Employee Weekly Attendance Excel Sheet

Easy to manage spreadsheet for excel users. One can fill in their companies name on the top then necessary information such as address and contact information. One can manage a single employee on a single tab so if you want to manage multiple employees you have to copy this sheet in other tabs. How to do it ? Simple press ctrl+~ sign this will show every formula of the sheet now press ctrl + A and then in another tab…

Read More

Correlation In Excel 2007 / Excel 2010

You need internet connection for this.You have to first load the analysis toolpak. To do this you have got to file tab and choose the options from the left column. Click on Add-in category located on the left side of screen.Now you will be able to see the various Add-ins that are already selected in a drop down list.In the manage box you have to choose analysis Toolpak and then click on go button.   Now the add-in dialog box…

Read More