The SQL Server Customer Advisory Team (SQLCAT) published a whitepaper about the installation of PowerPivot for SharePoint on a single server SharePoint farm.
Installing PowerPivot for Microsoft SharePoint on a new single server SharePoint farm is the simplest way to setup your PowerPivot server. The step-by-step procedure presented in this paper should ensure that you are up and running in less than an hour.
The whitepaper describes step-by-step how to create a new environment with the following setup:
– Windows Server 2008 with Service Pack 2 (SP2)
– SQL Server 2008 R2
– SharePoint Server 2010
– PowerPivot for SharePoint
Click here for the whitepaper