Forum Widgets
Latest Discussions
I'm looking for a practical way to calculate Pakistan salary income tax in Excel.
The goal would be to enter a monthly salary and have the spreadsheet estimate the applicable tax and resulting take-home amount. Ideally, the calculation should be easy to update when the applicable tax slabs or salary-related rules change. For someone building this in Excel, would you recommend keeping the tax slabs in a separate lookup table and using formulas against that table, rather than hard-coding the rates into one large formula? I'm particularly interested in approaches that make the spreadsheet easier to maintain when tax rules change.Keep Excel. Add Intelligence.
For years, I watched larger players in data, analytics, and reporting downplay Excel. The message was often: “Are you still using Excel for analytics and reporting? It is time to switch to our platform.” But I discovered the value of Excel early in my career. Excel remains popular for a simple reason: it is familiar, flexible, accessible, and deeply embedded in how business teams work. For many HR and compensation professionals, the spreadsheet is not the problem. The real challenge is turning spreadsheet data into reliable insights and actionable decisions. After leaving one of those large technology companies—somewhat involuntarily—I decided to build something based on a different philosophy: Keep Excel. Add intelligence. I created a suite of compensation modules that uses Excel files as the starting point. Organizations can upload employee-level data—including compensation, performance, job, market, and budget information—and use the modules to support: Salary benchmarking Pay equity analysis Merit planning Budget distribution Compensation audits Job leveling The system analyzes the uploaded data, identifies patterns and risks, and produces findings that compensation and HR teams can review and act upon. Results can also be exported in familiar formats, including Excel, CSV, and PDF. The goal is not to replace the tools people already understand. It is to help them get more value from those tools. Sometimes innovation does not require abandoning what works. It means building intelligence around it. Learn more about NorCal AI Solutions: https://norcalaisolutions.net #Excel #DataAnalytics #Compensation #HumanResources #ArtificialIntelligence #FutureOfWorkWhat's the simplest way to make a genuinely random name selection system using Microsoft tools?
For example, suppose I have a list of participants in Excel and want to randomly select one winner without manually choosing from the list. Would you use RAND/RANDBETWEEN in Excel, Power Automate, or another Microsoft 365 approach? I'm also interested in preventing the same person from being selected twice when several winners are needed. I'd appreciate an approach that's easy for someone without much Excel or Power Automate experience to understand.
Group Column Data, With Values (Bypassing Blanks)
For an eventual home in a SharePoint List and in turn, a PowerApp, I'm looking to combine the contents of potentially many columns (maybe hundreds of potentials) with only a few having values. Given the fact that I'm not sure how many columns I may stick the formula/code in to the 300th column (assuming the number of columns caps well under 300). I'm less concerned about exactly where as I can copy and paste code in to whatever column. I'm just clueless on the actual formula/macro. From there, I would import the excel to a SharePoint List and eventually pull data from a dropdown in a PowerApp. I've attached a file for reference. Any insight would be appreciated.
HELP!! Combinations have me so confused
So I found a website last year that did all this for me when I was trying to do it, but I cannot for the life of me remember what I googled to find this so I am starting from scratch because every thing I am coming across is not helping. I have a list of 22 people (11 guys and 11 girls). I need to find all the possible combinations of making 11 couples out of these 22 people. Andrew Asia Brett Bria Cam Cali Dan Jasmine Kwasi Kayla Lewis Kenya Moe Lauren Shamoy Maria Tevin Morgan Tomas Nutsa Zak Samantha so I was able to use a formula to determine how many possible couples there are (which is 247) BUT what I really need is to find all the possible ways to arrange these couples into 11 possibilities using each of the 22 people if that makes sense. If you have ever seen the show Are You The One, this is for that show. They take 11 guys and 11 girls and stick them in a house and it is up to those 22 people to figure out which is the correct combination of couples to where everyone is paired with their perfect match. But this is giving me a headache trying to remember how I found all the possible combinations of 11 couples last year!! PLEASE HELP!
