Oshchypok Akhil

Oh, I remember struggling with this when I first started in the lab! There's actually a pretty straightforward way using Excel's built-in functions. What worked for me was using the LOGEST function combined with some manual calculations. Basically, you need to:- Transform your concentration data using log10- Plot % inhibition vs. log(concentration)- Use LINEST to get the slope and intercept- Then calculate IC50 using: =10^((50-intercept)/slope)Pro tip: Make sure your response values are normalized between 0-100% for this to work properly. The hardest part is getting good quality data - if your points are all over the place, no calculation will give you accurate results!

As a QuickBooks ProAdvisor, I'd approach this a bit differently than the previous answer. The key is maintaining clear audit trails!Here's my method:Setup:- Create a Other Current Liability account named "PPP Loan Payable"- Create a Other Income account named "PPP Loan Forgiveness Income"Recording the loan:- When funds hit your bank, categorize the deposit to the PPP Loan Payable accountTracking expenses:- Use tags or classes like "PPP-eligible" for every relevant transaction- Keep detailed payroll records showing the 8-24 week covered periodForgiveness journal entry:- Debit: PPP Loan Payable (to reduce the liability)- Credit: PPP Loan Forgiveness Income (to recognize the income)Quick tip: QuickBooks Online has actually added some specific features for PPP tracking - check their help section for "COVID-19 relief" tools that might automate some of this process for you!

From my perspective as a hospital pharmacy director, I see major differences between well-trained and poorly-trained techs. Here's what I recommend for the best preparation:Essential knowledge areas:- Medical terminology - especially related to medications and conditions- Basic anatomy and physiology - understand how drugs work in the body- Pharmacy law and ethics - this is huge on certification exams- Dosage calculations - be comfortable with math!Beyond the basics:- Consider specializing later in areas like IV compounding or oncology- Develop soft skills - communication, attention to detail, empathy- Learn about different pharmacy settings - hospital, retail, mail-order, etc.The best techs in our hospital usually come from ASHP-accredited programs and do externships in multiple settings. Don't just aim to pass the exam - aim to truly understand the why behind what you're doing. Patient safety depends on it!