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.
Microsoft Excel 2016 Microsoft Excel 2019 (with CB 11.1.2.4.900 only) 64-bit Microsoft Excel (for 32-bit Crystal Ball in emulation mode or 64-bit Crystal Ball): Microsoft Excel 2010 (64-bit). 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. How can I get the CrystalBall Add-in for Excel with the new Office 365 version? It used to be available in the Options / Add-ins on previous Excel versions. Oracle Crystal Ball does not work with cloud-based Excel. Classic Menu for Excel 2010. Features: - Easily deploy classic menu and toolbars in Classic Menu Manager; - Easily show or hide Classic Menu and toolbars in Excel 20-0; - The classic menu can stay at far right of Ribbon, or between 'File' and 'Home' tabs in Ribbon; - The Excel 2003 interface can be positioned along with the Ribbon of Excel 20-0 or you can completely overlay the latter. How can I get the CrystalBall Add-in for Excel with the new Office 365 version? It used to be available in the Options / Add-ins on previous Excel versions. Oracle Crystal Ball does not work with cloud-based Excel.
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.
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.
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.
TUCK TORNADO
SOLVER SENSITIVITY
Installation Instructions: Windows
- Download SolverSensitivity.zip. Create a directory in your My Documents folder and give it a meaningful name (e.g. Sensitivity) and save the file in that folder. Right click on the file and extract SolverSensitivity.xlam to the directory.
- Right-click on SolverSensitivity.xlam and click the Properties option. If there is a button on that menu marked Unblock then click that button and then click Apply.
- Check the security setting for your copy of Excel. Click File | Options | Trust Center | Trust Center Settings and then make sure the checkbox for Trust access to the VBA object model is checked. Click OK.
- Install Solver Sensitivity. Click File | Options | Add-Ins. At the bottom of the right pane is a dropdown box and Excel Add-ins is usually selected as the default, else select it. Click the Go... button. Click the Browse... button and navigate to where you stored SolverSensitivity.xlam. You will be asked if you would like to copy the file to your Addins folder, click No. Click OK.
- Restart Excel. Solver Sensitivity should now be available under the Sensitivity Toolkit submenu of your Add-Ins menu.
Installation Instructions: Macintosh
- Download SolverSensitivity.zip. Create a directory in your My Documents folder and give it a meaningful name (e.g. Sensitivity) and save the file in that folder. Right click on the file and extract SolverSensitivity.xlam to the directory.
- Check the security setting for your copy of Excel. Click Excel | Preferences | Security and then make sure the checkbox for Trust access to the VBA project object model is checked.
- Install Solver Sensitivity. Click Tools | Excel Add-ins.... Click the Browse... button and navigate to where you stored SolverSensitivity.xlam. You may be asked if you would like to copy the file to your Addins folder, if so, click No. Click OK.
- Restart Excel. Solver Sensitivity should now be available under the Sensitivity Toolkit submenu of your Add-ins menu. The Add-ins menu will be on the Workbook's menu line.
THE SENSITIVITY TOOLKIT (Legacy)
The Sensitivity Toolkit was first developed in 2002 and went through several revisions as a part of Tuck's curriculum. The Toolkit has always been Free software and in completely unprotected with full source code available so that users can modify the software.
Data Sensitivity creates a table and chart to show how an output cell varies with changes in one (or two) inputs. In Tornado Chart, a set of parameters is varied from low to high and the results for a single output cell are reported. Solver Sensitivity runs the optimization program Solver on a spreadsheet for a set of values for one (or two) parameters. Similarly, Crystal Ball Sensitivity runs the simulation program Crystal Ball on a spreadsheet for a set of values for one (or two) parameters.
We have continued to update Data Sensitivity, Tornado Chart, and Solver Sensitivity for both research and classroom use. We no longer have a license for Crystal Ball however, so that component of the Toolkit is unlikely to be functional.
Using the Sensitivity Toolkit
The Sensitivity Toolkit was created to bring the most powerful tools of sensitivity analysis to the spreadsheet. The Toolkit supports four different forms of sensitivity analysis:
Sensitivity Toolkit Support
Crystal Ball For Mac Excel 2016 Find And Replace
The Sensitivity Toolkit is free software, but we cannot offer any promise of support. We will try and answer questions about the Toolkit and give advice, but be advised that there may be a considerable delay before we can respond. Please direct all inquires to: sensitivity.toolkit@dartmouth.edu.