O'Reilly logo

Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word by Michael P. Antonovich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

8.4. Defining Parameters for Your Excel Form

When you decide to publish a spreadsheet with Excel Services, you must decide which field(s) users would most likely need to manipulate. If you begin with the example of the simple interest calculation program mentioned earlier, you can quickly determine that the user only needs to vary three values:

  • The initial loan amount

  • The loan interest rate

  • The monthly payment

With these three pieces of information, you can calculate each month's payment, determining the portion that pays the interest due and the amount used to reduce the loan's principal amount. You can then create a running total of these two numbers to display by month the amount in interest you paid to the bank for the privilege of borrowing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required