SMILE.COM Hepar Excel Application

The engine.
Post Reply
jdtoellner
Posts: 71
Joined: Mon Aug 01, 2016 9:45 pm

SMILE.COM Hepar Excel Application

Post by jdtoellner »

Thanks for posting SMILE.COM. I like having the ability to access a network through Excel.

I created a sample spreadsheet application that accepts evidence for the Hepar network.
Hepar.zip
(73.26 KiB) Downloaded 384 times
The Visual Basic code is in ThisWorkbook and in the Worksheets called Jon D Doe and Jane P Doe. I tried my best to comment the code.

This spreadsheet is open for anyone to use. I'd love feedback if you discover issues or things I could have done better.
jdtoellner
Posts: 71
Joined: Mon Aug 01, 2016 9:45 pm

Re: SMILE.COM Hepar Excel Application

Post by jdtoellner »

I found something interesting with this architecture, where Excel is used as a front end to smile. All the evidence for the Hepar network is stored in Excel worksheets. When you load a worksheet evidence is propagated into the network. The network serves as a template, which captures the logic for how probabilities are associated. The Excel spreadsheet contains the evidence, similar to GeNie cases.

The Hepar spreadsheet contains a couple of worksheets for individual patients. You can create as many of those as you like.
Post Reply