Jump to content


NEED HELP WITH WOWP API


  • Please log in to reply
45 replies to this topic

pigeon_kicker #41 Posted 02 April 2017 - 03:47 PM

    Second Lieutenant

  • Open Beta Tester
  • 20011 battles
  • 1,418
  • [SF] SF
  • Member since:
    08-04-2013

Also, if you can give all of the *1's a specific string name that would be better.

But it looks ok.


If you want to make god laugh, tell him about your plans for survival..

Lead developer for the NACCW web site. Author of the Pigeon Pak Mod Installer

www.team-sf.com

 

 


pigeon_kicker #42 Posted 02 April 2017 - 03:48 PM

    Second Lieutenant

  • Open Beta Tester
  • 20011 battles
  • 1,418
  • [SF] SF
  • Member since:
    08-04-2013

Block Quote

SICK RATING = (((Assists*1)+(Kills*1)+(Ground Targets/2))/Battles)*((Average Tier*1))*(Wins/Battles*1.11)*(Survived/Battles*1.05)

 

If you want to make god laugh, tell him about your plans for survival..

Lead developer for the NACCW web site. Author of the Pigeon Pak Mod Installer

www.team-sf.com

 

 


pigeon_kicker #43 Posted 02 April 2017 - 03:50 PM

    Second Lieutenant

  • Open Beta Tester
  • 20011 battles
  • 1,418
  • [SF] SF
  • Member since:
    08-04-2013

Block Quote

 SICK RATING = (((Assists*1)+(Kills*1)+(Ground Targets/2))/Battles)*((Average Tier*1))*(Wins/Battles*1.11)*(Survived/Battles*1.05)

 

Block Quote

 SICK RATING = (((Assists*1)+(Kills*1)+(Ground Targets/2))/Battles)*(Average Tier*1))*(Wins/Battles*1.11)*(Survived/Battles*1.05)

 

Correct formula =  SICK RATING = (((Assists*1)+(Kills*1)+(Ground Targets/2))/Battles)*(Average Tier*1))*(Wins/Battles*1.11)*(Survived/Battles*1.05)


Edited by pigeon_kicker, 02 April 2017 - 03:51 PM.

If you want to make god laugh, tell him about your plans for survival..

Lead developer for the NACCW web site. Author of the Pigeon Pak Mod Installer

www.team-sf.com

 

 


pigeon_kicker #44 Posted 02 April 2017 - 03:55 PM

    Second Lieutenant

  • Open Beta Tester
  • 20011 battles
  • 1,418
  • [SF] SF
  • Member since:
    08-04-2013

Tested this formula, working, Now you just need to create 10 formulas, Tier 1 thru 10, get formula answers for each one, then average them out.

This will allow for correct tier span math.

 

PK


If you want to make god laugh, tell him about your plans for survival..

Lead developer for the NACCW web site. Author of the Pigeon Pak Mod Installer

www.team-sf.com

 

 


MARS_REVENANT #45 Posted 02 April 2017 - 04:14 PM

    Major

  • Member
  • 33822 battles
  • 7,004
  • [SICK] SICK
  • Member since:
    01-26-2012

View Postpigeon_kicker, on 02 April 2017 - 10:44 AM, said:

 

You have a square endian after survived

 

 

I am using Microsof Power BI.  The formula in there works, the square endian was left over from copy pasting it to the forums to simplify how it works for everyone.  Within the program, it lists table names and column names, that is where the square came from.

 

 

View Postpigeon_kicker, on 02 April 2017 - 10:55 AM, said:

Tested this formula, working, Now you just need to create 10 formulas, Tier 1 thru 10, get formula answers for each one, then average them out.

This will allow for correct tier span math.

 

PK

 

The average tier is already calculated, the calculation isnt shown in the chart or the equation, only the result.  I have it calculated in another hidden table and then brought the results into the final table and used them in the formula.

 

Here is how I got it.

 

Battles in Tier 1 * 1

Battles in Tier 2 * 2

Battles in Tier 3 * 3

Battles in Tier 4 * 4

Battles in Tier 5 * 5

Battles in Tier 6 * 6

Battles in Tier 7 * 7

Battles in Tier 8 * 8

Battles in Tier 9 * 9

Battles in Tier 10 * 10

 

I took the total of that number and divided by the total battles played which gave me an overall average tier for a specific UserID.  I dont want to get into bonus/penalty for specific tiers, I just want to use the overall average tier as a multiplier as the game results should receive a bonus the higher up you are playing.

 

Thanks for the tips.


I never lose; either I win or I learn.


MARS_REVENANT #46 Posted 04 April 2017 - 04:56 PM

    Major

  • Member
  • 33822 battles
  • 7,004
  • [SICK] SICK
  • Member since:
    01-26-2012

Project complete.  Even created an "if" formula that notes the rank depending on a members SICK RATINGtm

 

SOJO will be posting a recruiting/Ranking thread shortly.  Thanks all for your help.

 

This thread is now closed.


I never lose; either I win or I learn.





1 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users