Excel PowerPivot Mileage Distance Calculation


I have a basic Excel 2010 model that uses a PowerPivot pivottable with hospital stats (revenue and bed count)--see attached. The model uses two pivottables to show a comparison between a subject hospital and a peer group of several hospitals. Using Excel 2010 slicers, a user can select a hospital in pivottable#1 to show a subject hospital and then compare that hospital's stats to a peer group that is selected in pivottable#2. The peer group will show average of all hospitals selected.

I have a slicer that allows peer group to be narrowed by states. In addition to this slicer, I need a slicer to narrow the peer group based upon mileage from selected subject hospital. This means that the slicer must be able to dynamically change based upon whatever subject hospital is selected (see attached file). The database includes latitude and longitude for every hospital, so please use these to calculate mileage. Also, this has to work on sharepoint server, so that means this slicer must be made without the use of an excel linked table to powerpivot (excel linked tables do not dynamically update on sharepoint server).

The excel formula calculation of mileage is as follows: =ACOS(COS(RADIANS(90-Lat1))*COS(RADIANS(90-Lat2))+SIN(RADIANS(90-Lat1))*SIN(RADIANS(90-Lat2))*COS(RADIANS(Long1-Long2)))*3958.756

File upload to freelancer.com is NOT WORKING. If you are interested in project, please let me know and I will email you file.

Квалификация: Excel

Показать больше excel mileage formula, latitude powerpivot, formula distance calculation excel 2010, distance latitude longitude powerpivot, powerpivot average selected, excel 2010 latitude distance, powerpivot excel uses, powerpivot distance latitude longitude, the select group, powerpivot excel 2010 latitude longitude, can powerpivot calculate distance, powerpivot hospitals, mileage formula, excel mileage distance formula, uses for excel, excel uses, work on excel, sin, sin cos, longitude

О работодателе:
( 6 отзыв(-а, -ов) ) Saint Charles, United States

ID проекта: #1495043

5 фрилансеров(-а) в среднем готовы выполнить эту работу за $42


Hello, I'm interesting on your project. I have created many similar macros and I'm sure I can do that using VBA and formulas in max 1 day. Could you please send me the spreadsheet? A few words about me: I'm very Больше

$40 USD за 1 день
(12 отзывов(-а))

I'm a newbie, but i ready to help you,, please call me.. thank's..

$50 USD за 2 дней(-я)
(0 отзывов(-а))

Hi Kindly email me the details for I am interested in the job. wil start work immediately. Regards

$40 USD за 2 дней(-я)
(0 отзывов(-а))

I am interested to bid your project. I am expert in utilizing Excel functions, pivot table, chart, database and macro.

$50 USD за 3 дней(-я)
(0 отзывов(-а))

I am ready

$30 USD за 1 день
(0 отзывов(-а))