Mar
26
2009
1

Improve the Ogilvie Calculator!

Could THIS be the elusive Ogilvie formula?

Could THIS be the elusive Ogilvie formula?

So, here’s the deal:  I want to build the absolute most comprehensive suite of calculators and tools for workers’ compensation professionals. [1]  I also want your help to making them better.

In the last few days several people have sent me questions about the Ogilvie DFEC workers’ compensation calculator:[2]

  1. Is it possible to get an Ogilvie DFEC adjusted whole person impairment above 100%?
    • I believe it might be theoretically possible to achieve an adjusted whole person impairment above 100% using the Ogilvie DFEC formula.  I could easily include a small variation on the calculation that would prevent it from exceeding 100, but I have not done so because I wanted to replicate the the formulas set forth in Ogilvie as exactly as possible.
  2. Why can’t I use post-injury earnings of $0.00?  What if they have no earnings at all?
    • That’s an extremely valid point.  If you try to use a post-injury earnings of “zero”, it will cause division by “zero” which is not a mathematically legal operation.  Try post-injury earnings of $1.00 or $0.01.  Doing so will give you an answer VERY close to what you need. [3]
  3. When do you round each calculation when performing the Ogilvie DFEC calculation?
    • The WCAB en banc in Ogilvie rounds to three decimal places at one step and to four decimal places at a second step.  The only way we know what they actually did is by extrapolating from the examples in the decision – they never actually state “round to four significant digits here, round to three significant digits there.”  I have rounded exactly as they did in their examples.
    • At the end of the day, there are two ways to perform the Ogilvie DFEC calculation:  the exact way the WCAB did it (sometimes four, sometimes three decimal places) and the way they probably intended to do it (four decimal places until the end).  I made the judgment call to use the formula as they performed it, warts and all.
    • Why did I choose to round as the WCAB did?  I think it is more defensible to calculate exactly as the Board did, rather than as I think the Board should have calculated.
  4. How do you put the Ogilvie DFEC adjusted whole person impairment into the rating calculator?
    • At this point, you can’t use a different FEC Rank or an Ogilvie DFEC adjustment factor in the 2005 PDRS rating calculator on this site.  In order to accomodate this, I would need to either rewrite the entire calculator or write a new calculator.  One other possibility is that I could modify the Ogilvie DFEC calculation to provide one extra line of information – where it “runs the FEC numbers backwards.”
    • Let’s take this example:  Suppose the body part FEC rank is 1 and whole person impairment is 10.  The normal FEC adjusted whole person impairment would be 11.  Let’s suppose after applying the Ogilvie DFEC formula it turns out you should have an FEC rank of 8 instead.  This would give you an Ogilvie DFEC adjusted whole person impariment of 14%.  I could write a modification of the current Ogilvie DFEC calculator to put 14% into the FEC Rank chart and look up what whole person impairment you would need with an FEC rank of 1 to arrive at 14%.  Would you find this a helpful interim fix?  Please let me know by sending me an e-mail.
  5. Jay, why in the world did the Ogilvie DFEC calculator reference “standard disability”?  Shouldn’t it say “whole person impairment”?
    1. You’re totally correct.  I’ve fixed this.  Mea culpa.

Here’s my request for your help.  In order to make an Ogilvie calculation valid, you need to put in valid post-injury earnings of similarly situated employees.  The WCAB in Ogilvie suggests several possible sources:[4]

What do you use for post-injury earnings of similarly situated employees?  If I had a better idea where people were looking it is possible that I might be able to automate the inclusion of this informaiton as well.  Please drop me a line and let me know.   If there is a general consensus, I’ll look into the possiblity of having this informaiton automatically imported from an external website.

  1. Why?  Some people have wacky hobbies.  Maybe you build hockey arenas out of toothpicks.  I build workers’ compensation calculators and give them away for free.  If it will put you at ease, I hope to make money from advertising in the future. []
  2. Photo courtesy of nerissa’s ring []
  3. I know it has a less than friendly error message about this. I’ll see what I can do about fixing that. []
  4. I’ve copied the links directly from Ray Frost‘s Ogilvie spreadsheet/calculator.  Ray has been kind enough to allow me the use of his extensive work restrictions lists.  So, thanks Ray! []
Feb
09
2009
0

Ogilvie DFEC Rebuttal Calculator – Ask for access

How to build a calculator: Its like smashing a calculator - only in reverse

How to build a calculator: It's like smashing a calculator - only in reverse

I’m going to delay the launch of the Ogilvie DFEC rebuttal calculator for a day or two. [1]  I believe it works just fine, but I would like to test it a little more.  This said, I will grant anyone who is interested access to this calculator.

Why the delay?  Well…

The interesting thing about taking apart a set of calculations is that you find all sorts of “hidden steps” to the calculation.  The majority in Ogilvie does a respectible job of going through the steps of this new formula and even gives several examples.

When performing most calculations one will need to round numbers at some point.  However, rounding almost invariably takes place at the very end.  In the case of the Ogilvie calculations, it appears that the WCAB rounds various figures throughout the calculation.

Even though the DFEC rebuttal calculator was giving correct answers, the fourth or fifth decimal places on some intermediary figures occasionally did not coming out right.  It took me a little while to track down all the spots where the WCAB was implicitly rounding their figures (and to what decimal place!).

I am fairly confident the calculator will work without a hitch, but I’m going to test it a little more before I make it available to the public.  If you’re interested in testing this Ogilvie DFEC rebuttal calculator, please drop me a line and let me know.

If you’re not a registered user for this website, its free to sign up and free to use all the workers’ compensation calculators.  Seriously, free as in free!

  1. Photo courtesy of mhuang []
Oct
24
2008
0

WordPress Update to v2.6.3

Wordpress Upgrade

Wordpress Upgrade

Quick Update

or those of you keeping score at home, I’ve updated to WordPress v2.6.3 last night. [1]  This version was released as a security fix.  Unlike other WordPress upgrades, this one took only a few seconds.

Less Quick Updates

Admittedly, prior updates probably only take about 10 minutes, max.  This 10 minutes includes roughly 9 minutes of backing the website and database up and 1 minute of actually uploading the new version.  Since the 9 minutes of backing up is essentially all processing/downloading time, there’s nothing for me to monitor which makes the whole process very painless.

Upcoming Updates

The kind folks over at WordPress have been hard at work on the version 2.7. [2]  If you scan through the above link, you’ll get to see what the new WordPress 2.7 control panel/dashboard is supposed to look like.

Best Thing About WordPress

(If you just can’t wait, skip down two paragraphs.)  Regular readers have heard me go on and on about the virtues of WordPress. [3]  The interesting thing about new versions of WordPress is that any upgrades would be seamless to a website visitor. [4]

A website that is easy to read is a function of the author

Website content is really all that matters to a website visitor.  Visitors don’t care about what software a website owner is using – just as long as the content is useful. [5]

A website that is easy to write is a function of the program

The single best thing about WordPress is that this program makes maintaining a website a breeze.  I would recommend WordPress to absolutely anyone interested in creating a website.  For the novice, the program makes it easy to write, edit, and delete single pages or the entire website without any knowledge of programming.  For the tech-minded, the program makes it easy to install, upgrade, and personalize a website.

If you know a little PHP, MySQL, and javascript you could do some c-r-a-z-y things with WordPress. [6][7][8]

  1. Talk about unnecessary decimal places. []
  2. I call them “kind” since a lot of these people are working for free. []
  3. You know, you three should really form some kind of support group for people who read unnecessarily nerdy and self-referential blogs. []
  4. I think its interesting, anyhow. []
  5. If they don’t care about what kind of software, they sure as heck don’t care its version 2.6.3. []
  6. You could even put together your own workers compensation calculators and EAMS search engines! []
  7. Am I going overboard with these footnotes? []
  8. The answer is “No, I’m not going overboard.”  In the immortal words of Ferris Bueller, “You can never go too far.” []

Use of this site constitutes agreement to its Terms of Use, Privacy Policy and Legal Disclaimer.
Copyright 2007 - 2017 - PDRater – PD calculators and Jay Shergill
Powered by WordPress | Aeros Theme | TheBuckmaker.com WordPress Themes