Subscribe:      
 

What-If analysis using SharePoint 2010 Excel Services

Written By: Siddharth Mehta -- 8/25/2011 -- join -- contribute -- (4125) comments -- printer friendly version

Rating: Rate --

Categories: Design, Excel Services, Integration with other products , SharePoint 2010

< Prev - 1 | 2 | - Next > | Become a paid author

Problem

Excel workbooks are published on SharePoint and viewed using the Excel Web Access web part. But the workbook is available in read-only mode when viewed using this web part. A configured Excel workbook can be very well used for developing applications to facilitate a what-if analysis. In this tip we will explore one of the ways to facilitate what-if analysis.

Solution

Excel is generally programmed by business users using formulas to derive / calculate values on pre-existing data. This calculation is based on a set of parameters that drive the calculation. Let us try to create an Excel spreadsheet with some data and calculated fields.

Step 1: Using Excel, create a new workbook. Create two fields with the names Value 1 and Value 2 and populate it with some numeric data.

Step 2: Right-click on a column and select "Define name", and name it "Operator". Our intention is to get a calculated value in a field named "Result" based on the selected operator.



Step 3: For the Result field, add the formula as shown in the screenshot below.



< Prev - 1 | 2 | - Next >



Learn more about SharePoint



Sponsor Information




Copyright (c) 2010-2017 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | contribute | feedback | about
Some names and products listed are the registered trademarks of their respective owners.


MSSharePointTips.com | MSSQLTips.com