What if the AzurePrediction... doesn't show up in Automation Servers?


Windows 10 - followed video directions - added to both Framework and Framework64 - but Excel doesn't show it ... ideas?



neerajkh wrote Jun 28, 2015 at 4:12 PM

Are you using Excel 32-bit or 64-bit (not OS but excel version)? If 64-bit, try one of the following:
  1. Download the zip file to C:\installs\AMLExcel then unzip it. Click on each file, go to properties, and if necessary unblock it before installing. Then, run regasm (steps mentioned in documentation) from an elevated (administrator) cmd prompt (your directory and version may differ):
  2. rerun regasm with c:\Windows\Microsoft.NET\Framework64\v4.0.30319>regasm /codebase <Path to DLL file>\AzureMLPrediction.dll /tlb:<Path to tlb file>\AzureMLPrediction.tlb
Also, just a FYI, now we support similar function as a macro that doesn't require any installation - https://azure.microsoft.com/en-us/documentation/articles/machine-learning-consuming-from-excel/

JimGaleForce wrote Jun 28, 2015 at 6:44 PM

ok, it works now - is 64bit - I believe I must have missed the elevation and any OS messages to that were hidden in the output. thank you.

sidenote: what's a good algo for predicting events based on other factors? like predicting a chance of thunderstorms based on numerous other inputs? thx

neerajkh wrote Jun 28, 2015 at 8:17 PM

Start with any of two-class boosted decision tree.