A new tool in the fight against disability and workers’ compensation fraud is open source investigations. The use of this technology is becoming more widely recognized and accepted.

• Crystal Ball For Mac Excel 2016 How To Format Data In A Chart
• Crystal Ball For Mac Excel 2016
• Crystal Ball For Mac Excel 2016 Vba Editor

Individuals continue to post more and more about their lives on a host of social media platforms. Instagram is overtaking Facebook as one of the most popular places to post photos and videos. Twitter also continues to be a favourite tool.

Posting all aspects of our daily lives makes us feel part of a global community. What does this mean for disability claim managers and those in the human resources profession? They have an unprecedented look into an individual’s public life.

How many times have you seen a doctor’s note that states that the individual is totally disabled, or unfit for modified duties, sitting or standing for longer periods, etc.? In the past, you would have to conduct a costly surveillance to determine the individual’s level of activity. Today, you may be a few clicks away from validating your concerns.

1. Jun 18, 2004 I've never used Crystal Ball, but I find that it is very easy to code up Monte Carlo simulations in perl. Excel is a great tool, but it crashes easily with large and complicated spreadsheets. An external tool like perl allows you to bypass the unstable window-dressing and get down to some hardcore number crunching.
2. For 32-bit Crystal Ball: Microsoft Excel 2007 with Service Pack 3 Microsoft Excel 2010 with Service Pack 2 Microsoft Excel 2013 Microsoft Excel 2016 For 64-bit Crystal Ball: Microsoft Excel 2010 with Service Pack 2 (64-bit) Microsoft Excel 2013 (64-bit) Microsoft Excel 2016 (64-bit) Office 365 (see Note 5) Note 1.

A picture is worth a thousand words. Do you realize how much data a photo reveals? Often we can obtain the exact location, date of the photo and when it was uploaded. All this information can become a part of your investigation. We had a case where an individual requested time away from work, and it was denied. The employee subsequently submitted a WSIB’s claim and got the requested time. The employee then posted photos on social media. Our investigators extracted data that placed the subject in Romania.

Crystal Ball (standard edition) is the easiest way to perform Monte Carlo simulations in your Excel spreadsheets and models. Crystal Ball automatically calculates thousands of different 'what if' cases, saving the inputs and results of each calculation as individual scenarios. To use Crystal Ball with Windows Vista or Microsoft Excel 2007 or later must download and install the English version of Crystal Ball 7.3. If you are using this version on an English operating system with non-English regional settings.

Crystal Ball For Mac Excel 2016 How To Format Data In A Chart

If the Internet is an iceberg, social media is only the tip. What lies below the surface is massive. A skilled investigator can easily harvest open source data. We recently had a case where a female employee was a part-time yoga instructor, outside of work. At the time of her claim, she turned on her privacy settings to avoid detection. Her only mistake was being showcased in a Yoga studio newsletter that was harvested using search techniques. Despite increased privacy settings, many apps disregard it and provide data the subject thought was hidden.

Can you do these types of investigations yourself? The short answer is yes. However without the necessary skills, you often won’t find what you need. It is also recommended that an independent third party gathers the information and later testify and present the evidence. The data is harvested in an ethical way to ensure privacy has not been violated and formulated into a structured admissible report.

An open source investigation is non-intrusive without any risk of being exposed. Using proxy servers allows investigators to collect data undetected without leaving any digital footprints.

If you have a claim that is under suspicion, maybe it’s time to have a peek.

Annoying isn’t it? Excel 2016 is installed (or Office 365), but that doesn’t count as 2007 or higher. Jokes about Office upgrades aside, this shouldn’t be a problem, but you can’t install.

One solution is to uninstall Office 2016, install Office 2013, then install Office 2016 again. Not great, especially as Office 2013 takes up a lot of disk space and uninstalling it can cause problems with file associations and jump lists.

The problem is caused by the way that Dashboards try to detect the presence of Excel. It’s not enough to just check that there is ‘some’ application associated with xls and xlsx, it needs to be proper Excel. The way that Dashboard does this is to search the registry for certain values.

Everything that follows is unofficial and unsupported.

The values to search for are stored in a file called ‘product.seed.xml’. It’s stored in ‘dunitproduct.xcelsius-4.0-core-32’. If you open this in an editor (I prefer Notepad++ as it handles the formatting well), you’ll see a section that starts:

Followed by several entries similar to this:

Crystal Ball For Mac Excel 2016

In English, it’s just telling the installer to search the registry to see if Excel 10 is installed. The following entries are for later versions of Excel. You’ll see the last two entries are for 64 bit Excel – don’t get excited, they’re just to throw an error about 64 bit Excel!

My original plan had been to create a new entry to search for Excel 2016. Problem is, I have Office 365 installed which appears to have a different structure in the registry.

Solution: delete the section!

First backup the file. Then, starting from <prerequisite, delete everything up to and including the </prerequisite> tag after the final Excel entry. In my editor, that’s line 74 up to line 130.

Now run the installer again. If you’ve made an error, the install will very quickly fail. Restore your backup file and do the edit again.

If it’s worked, you’ll see:

Crystal Ball For Mac Excel 2016 Vba Editor

Keep pressing Next, then your licence key, you’re good to go.