Excel Gurus ?

[Baloo]

Are there any Excel Gurus here ? I'm trying to tidy up the PYMPS Tracker so that it's fairly easy to add Rounds and what not.

I've got the basic calculations working in what can only be decribed as a convoluted ugly 3yo scribble. If anyone thinks they can help, I'll happily sponsor you for $2 every time Richmond wins.

Here's an example of the code I am using (yes, it's repeated as I am halfway through trying to add a weighting for wins.......)

=IF(I5>1,(SUM(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,2)=1,$D5,0)+(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,3)=1,$C5,0))+(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,4)=1,$E5,0))+(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,5)>0,(VLOOKUP($B5,Rd1!$B$3:$H$47,5))*$F5,0))+(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,6)=1,$G5,0))+(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,7)>0,(VLOOKUP($B5,Rd1!$B$3:$H$47,7))*$H5,0)))*I5),SUM(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,2)=1,$D5,0)+(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,3)=1,$C5,0))+(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,4)=1,$E5,0))+(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,5)>0,(VLOOKUP($B5,Rd1!$B$3:$H$47,5))*$F5,0))+(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,6)=1,$G5,0))+(IF(VLOOKUP($B5,Rd1!$B$3:$H$47,7)>0,(VLOOKUP($B5,Rd1!$B$3:$H$47,7))*$H5,0))))

 

[Baloo]

wow, didn't realise that was possible......

The above post was asking for any Excel Gurus who would be kind enough to look at the PYMPS Spreadsheet and clean it up / make it more manageable. I posted an example of the formula and it killed the entire post. That's how toxic and convoluted the formula is........

Any way, if anyone is willing and able to have a look, I'll gladly sponsor you for $2 every Richmond win in PYMPS.

 

[Rosy]

I was about to ask how you get a post to show nothing.

 

[Streak]

I was about to ask how you get a post to show nothing.

There are plenty of experts on here who can show you how to make a post say nothing, not of any value anyway :hihi