Ok, after figuring out how to use that google sheet, looks like I need to use the high ping 3 ammo roatation. I only needed to rework 3 melds on my gear to max out materia according to the priority list suggested (wd, dex, crit, direct, det, speed). I am now sitting at the following stats:

WD - 101, Dex - 2816, Crit - 1936, Dir - 1634, Det - 1064, Spd - 1196. (This was accomplished with the eureka gun, full tome gear, and a sigmascape NM ring). Now to undo years worth of muscle memory and try to figure out how to layout the rotation on my controller bar...