Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Marksman Building?
#31
It's in xlsx form so some people won't be able to read it.
Sheet 1 is individual rows coloured, Sheet 2 is the thing as a whole.

I can post the code for it though.
Code:
cell B5
=IF($A5-B$1>=0,IF(10+$A5-B$1>40,"x",(($D$4*$J$4*(1+B$2/100*0.9)/2+$F$4)/100*($H$4+B$3))*($B$4/100+(41+FLOOR(($A5-B$1)/2,1))/100*(100+IF($A5-B$1>0,110+$A5-B$1,0))/100)),"x")

[Image: seboostpointer.png]
If you enter the top 3 rows and first column to match like that (atk/mastery of Boost, and point counts) then that's pretty much all you need to reproduce the whole thing.
Just stick the above code into B5 and then copy it across and down to make the 30x60 grid.
I added a multiplier column so if people know what that is for Marksmen they can change it.

The colouring is just conditional formatting (I made a macro for it to speed up the process)
Reply


Messages In This Thread
Marksman Building? - by Cyanne - 2009-02-19, 03:46 AM
Marksman Building? - by Dusk - 2009-02-19, 04:16 AM
Marksman Building? - by Kevvl - 2009-02-19, 05:08 AM
Marksman Building? - by Lifis - 2009-02-19, 11:40 AM
Marksman Building? - by Beaner - 2009-02-19, 12:53 PM
Marksman Building? - by ChaosCorpse - 2009-02-19, 02:59 PM
Marksman Building? - by Dusk - 2009-02-19, 04:30 PM
Marksman Building? - by Cyanne - 2009-02-19, 08:31 PM
Marksman Building? - by Kevvl - 2009-02-19, 08:44 PM
Marksman Building? - by Dusk - 2009-02-19, 09:11 PM
Marksman Building? - by cooldog67 - 2009-02-20, 12:55 AM
Marksman Building? - by Cyanne - 2009-02-20, 01:25 AM
Marksman Building? - by Kevvl - 2009-02-20, 04:08 AM
Marksman Building? - by Mark - 2009-02-20, 04:37 AM
Marksman Building? - by Typhoon - 2009-02-20, 03:44 PM
Marksman Building? - by ArbalistMaster - 2009-02-20, 04:10 PM
Marksman Building? - by Icedfire - 2009-02-20, 04:11 PM
Marksman Building? - by Russt - 2009-02-20, 08:28 PM
Marksman Building? - by Cyanne - 2009-02-20, 09:00 PM
Marksman Building? - by Stereo - 2009-02-20, 09:35 PM
Marksman Building? - by Dusk - 2009-02-20, 09:35 PM
Marksman Building? - by Russt - 2009-02-20, 09:37 PM
Marksman Building? - by Technolink - 2009-02-21, 12:34 AM
Marksman Building? - by ArbalistMaster - 2009-02-21, 01:56 AM
Marksman Building? - by Cyanne - 2009-02-21, 03:27 AM
Marksman Building? - by Chameleonic - 2009-02-21, 04:02 AM
Marksman Building? - by Typhoon - 2009-02-21, 12:53 PM
Marksman Building? - by tzk221 - 2009-02-21, 03:58 PM
Marksman Building? - by Stereo - 2009-02-21, 04:23 PM
Marksman Building? - by Shidoshi - 2009-02-21, 05:07 PM
Marksman Building? - by Stereo - 2009-02-21, 05:33 PM
Marksman Building? - by Cyanne - 2009-02-21, 06:23 PM
Marksman Building? - by Russt - 2009-02-21, 06:56 PM
Marksman Building? - by Cyanne - 2009-02-21, 08:41 PM
Marksman Building? - by tzk221 - 2009-02-21, 11:20 PM
Marksman Building? - by Kevvl - 2009-02-22, 12:05 AM
Marksman Building? - by Hotshot - 2009-02-23, 03:17 PM
Marksman Building? - by WayOfTime - 2009-02-25, 07:22 PM
Marksman Building? - by Russt - 2009-02-25, 11:15 PM
Marksman Building? - by tzk221 - 2009-02-26, 12:36 AM
Marksman Building? - by Beaner - 2009-02-26, 12:38 AM
Marksman Building? - by WayOfTime - 2009-02-26, 06:43 AM
Marksman Building? - by alwzn4vr - 2009-02-26, 02:30 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)