←Back to Beyond Market Intelligence
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

bradford factor calculation across multiple rows

Our take

Calculating Bradford Factor scores manually can be time-consuming, especially when dealing with multiple instances of absence across rows. Fortunately, you can streamline this process in Excel with a formula that identifies and aggregates these instances. By squaring the total number of absences and multiplying it by the sum of the days absent, you can efficiently calculate each individual's score. This approach not only saves time but also enhances accuracy, allowing you to focus more on strategic HR initiatives rather than tedious calculations.

i’ve recently started a HR role where they calculate bradford factor scores by hand (if you don’t know bradford factor scores are a form of absence management that follow this formula: instances ² X days

they download a report and export it into excel. this puts each instance in a seperate row (so if a person has 3 instances of absence there will be 3 rows with their name in). there is then a column that has the days for each instance. at the moment we have to go through the whole document and calculate each persons score by hand

is there a formula i can apply that will be able to identify the multiple instances across rows, square the total and then multiply it by the sum of the days across those instances?

i have a basic understanding of excel so this is very out of my skill set. if i have explained it poorly please let me know and i can try again. TIA!

submitted by /u/LopsidedCan732
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#rows.com