LSJ Legend  Posts: 515 Joined: 8/17/2006 Location: Citrus Springs, FL  User Profile | Tom, I'm trying to understand all of this to see what it tells me. I added up the net gains from all 12 Bear Bear states and came up with 1,902,862. Looking at the Pivot Table output for Bear Bear the total is 9,096,448.114. I'm not sure why these are so far apart. My first assumption is that if I used the same data for the Port Sim and the pivot table that there should be close to the same result. Second, if through an analysis of the individual strategies I eliminated the negative performers and re-ran the Port Sim I should get a better result. By the same token I would expect a pivot table to verify that result with just minor differences. So, whatever is going on here I haven't completely grasped it. Seems like we're building railroad tracks from opposite ends and not meeting in he middle <:) Any light you can shed would be appreciated. | |
