Rx Note

Introduction At times, some works (especially statistics reporting) are not difficult, but just too tedious to do it. Hence, we hope all report things can be auto-calculated with each new data entry. Here are some useful Microsoft Excel tricks that you should learn up to make it not a mission impossible. Ctrl + Shift to Select To quickly select a dataset, you can click in the first cell that you want to use and hold down Ctrl+Shift , then hit Down arrow or Up arrow to get all the data below or above in the column. Left arrow or Right arrow to get the data in the row (to the left or right respectively). Separate Line within a Cell and Wrap Text In Microsoft Excel , pressing ALT+Enter creates a new line within a cell. This just to make the data to be presented in a neater manner. An example is as below. Wrap Text Option under the Home tab automatically resize the row or column so that the text re-wraps to fit. Use AutoFilter The AutoFilter feature is such a useful feature when de...

Introduction Wistify.app is a mobile application developed by My Pharmacist House and his team. It aims to help us to convert your existing spreadsheet into a mobile application without coding. How to Start Creating NOTE: By enabling Custom Sort option in Apps Design , it allows the data output to be displayed according to data grid sequences. If not, the data output layout will follow the alphabetical order of the headers. Pros As a whole, Wistify. app offers few remarkably interesting and important features. Freemium plan (i.e. a free plan with basic or limited feature) available. Easy to use. Can be installed for offline use. Can be password-protected. Integrated with notice board. Image and PDF upload via File Manager Cons Some features are only available in the premium plan. For the FREE basic package , there is a limit of 2 wists, maximum of 1800 data rows and 1 GB monthly user downloads. Also, 1 GB of space is provided for file manager feature with 10 GB bandwidth per mo...

Introduction Open As App is a no-code paltform that lets people turn calculations, lists and forms in a spreadsheet into mobile and web apps. To create a functional calculator app, you have to be familiar with Microsoft Excel . A detailed step-by-step on app creation guide is available here . Strengths Make mobile application creation more accessible. Check for update feature - Users can always manually click "Check For Updates" to sync the latest database changes. Pop up notification of new database will appear if a new Excel file is uploaded to the Open As App Cloud. Ability to change source file storage from Open As App Cloud to One Drive, Dropbox or Google Sheet. To do this, navigate to "Update data source" and click "Edit URL" Calculator app using Excel formulas can be designed easily (This is not feasible in AppSheet , Mdict or Wistify.app ). Can be installed for offline use . Weaknesses Limitations of free Plan You can only create 1 app . It is ...

Introduction When I was a provisional registered pharmacist in TDM rotation, I found that pharmacokinetics calculation is a repetitive task and sometimes, the calculation results are just an aid in dosage adjustment. Hence, I decided to create TDM calculator using Microsoft Excel . The initial design of the TDM calculator spreadsheet is One sheet for each drug Able to accommodate different scenarios Allowing users to decide on which population pharmacokinetics equations to be used Clinical Pharmacokinetics Pharmacy Handbook, 2019 is used as the main reference. Excel Sheet The final Excel sheet (last updated 1 Jan 2022) can be opened using Microsoft Office for both desktop and mobile phones. Patient Profile Aminoglycosides Carbamazepine Digoxin Phenobarbitone Phenytoin Sodium valproate Vancomycin If you would like to verify the equations or make some self-modifications, you may remove the protection from editing. Go to Review tab, click Unprotect Sheet and Unprotect Workbook . *No...