blackretina

proposedformatting.gs

Jun 26th, 2013
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function onEdit() {
  2.   var ss = SpreadsheetApp.getActiveSpreadsheet();
  3.   var All_Sheet = ss.getSheetByName('All');
  4.   var Legacy_Sheet = ss.getSheetByName('Legacy');
  5.  
  6.   var r_All_armorratio = All_Sheet.getRange('b2:b');
  7.   var r_All_damage = All_Sheet.getRange('c2:c');
  8.   var r_All_rangemodifier = All_Sheet.getRange('d2:d');
  9.   var r_All_cycletime = All_Sheet.getRange('e2:e');
  10.   var r_All_penetration = All_Sheet.getRange('f2:f');
  11.   var r_All_killaward = All_Sheet.getRange('g2:g');
  12.   var r_All_maxplayerspeed = All_Sheet.getRange('h2:h');
  13.   var r_All_clip_size = All_Sheet.getRange('i2:i');
  14.   var r_All_weaponprice = All_Sheet.getRange('j2:j');
  15.   var r_All_range = All_Sheet.getRange('k2:k');
  16.   var r_All_fullauto = All_Sheet.getRange('l2:l');
  17.   var r_All_flinchvelocitylarge = All_Sheet.getRange('m2:m');
  18.   var r_All_flinchvelocitysmall = All_Sheet.getRange('n2:n');
  19.   var r_All_spread = All_Sheet.getRange('p2:p');
  20.   var r_All_inaccuracycrouch = All_Sheet.getRange('q2:q');
  21.   var r_All_inaccuracystand = All_Sheet.getRange('r2:r');
  22.   var r_All_inaccuracyfire = All_Sheet.getRange('s2:s');
  23.   var r_All_inaccuracymove = All_Sheet.getRange('t2:t');
  24.   var r_All_inaccuracyjump = All_Sheet.getRange('u2:u');
  25.   var r_All_inaccuracyland = All_Sheet.getRange('v2:v');
  26.   var r_All_inaccuracyladder = All_Sheet.getRange('w2:w');
  27.   var r_All_recoverytimecrouch = All_Sheet.getRange('x2:x');
  28.   var r_All_recoverytimestand = All_Sheet.getRange('y2:y');
  29.   var r_All_recoilanglevariance = All_Sheet.getRange('z2:z');
  30.   var r_All_recoilmagnitude = All_Sheet.getRange('aa2:aa');
  31.   var r_All_recoilmagvariance = All_Sheet.getRange('ab2:ab');
  32.   var r_All_spreadalt = All_Sheet.getRange('ad2:ad');
  33.   var r_All_inaccuracycrouchalt = All_Sheet.getRange('ae2:ae');
  34.   var r_All_inaccuracystandalt = All_Sheet.getRange('af2:af');
  35.   var r_All_inaccuracyfirealt = All_Sheet.getRange('ag2:ag');
  36.   var r_All_inaccuracymovealt = All_Sheet.getRange('ah2:ah');
  37.   var r_All_inaccuracyjumpalt = All_Sheet.getRange('ai2:ai');
  38.   var r_All_inaccuracylandalt = All_Sheet.getRange('aj2:aj');
  39.   var r_All_inaccuracyladderalt = All_Sheet.getRange('ak2:ak');
  40.   var r_All_recoilanglevariancealt = All_Sheet.getRange('al2:al');
  41.   var r_All_recoilmagnitudealt = All_Sheet.getRange('am2:am');
  42.   var r_All_recoilmagvariancealt = All_Sheet.getRange('an2:an');
  43.   var r_All_bullets = All_Sheet.getRange('ao11:ao14');
  44.  
  45.   var r_Legacy_armorratio = Legacy_Sheet.getRange('b2:b');
  46.   var r_Legacy_damage = Legacy_Sheet.getRange('c2:c');
  47.   var r_Legacy_rangemodifier = Legacy_Sheet.getRange('d2:d');
  48.   var r_Legacy_cycletime = Legacy_Sheet.getRange('e2:e');
  49.   var r_Legacy_penetration = Legacy_Sheet.getRange('f2:f');
  50.   var r_Legacy_killaward = Legacy_Sheet.getRange('g2:g');
  51.   var r_Legacy_maxplayerspeed = Legacy_Sheet.getRange('h2:h');
  52.   var r_Legacy_clip_size = Legacy_Sheet.getRange('i2:i');
  53.   var r_Legacy_weaponprice = Legacy_Sheet.getRange('j2:j');
  54.   var r_Legacy_range = Legacy_Sheet.getRange('k2:k');
  55.   var r_Legacy_fullauto = Legacy_Sheet.getRange('l2:l');
  56.   var r_Legacy_flinchvelocitylarge = Legacy_Sheet.getRange('m2:m');
  57.   var r_Legacy_flinchvelocitysmall = Legacy_Sheet.getRange('n2:n');
  58.   var r_Legacy_spread = Legacy_Sheet.getRange('p2:p');
  59.   var r_Legacy_inaccuracycrouch = Legacy_Sheet.getRange('q2:q');
  60.   var r_Legacy_inaccuracystand = Legacy_Sheet.getRange('r2:r');
  61.   var r_Legacy_inaccuracyfire = Legacy_Sheet.getRange('s2:s');
  62.   var r_Legacy_inaccuracymove = Legacy_Sheet.getRange('t2:t');
  63.   var r_Legacy_inaccuracyjump = Legacy_Sheet.getRange('u2:u');
  64.   var r_Legacy_inaccuracyland = Legacy_Sheet.getRange('v2:v');
  65.   var r_Legacy_inaccuracyladder = Legacy_Sheet.getRange('w2:w');
  66.   var r_Legacy_recoverytimecrouch = Legacy_Sheet.getRange('x2:x');
  67.   var r_Legacy_recoverytimestand = Legacy_Sheet.getRange('y2:y');
  68.   var r_Legacy_recoilanglevariance = Legacy_Sheet.getRange('z2:z');
  69.   var r_Legacy_recoilmagnitude = Legacy_Sheet.getRange('aa2:aa');
  70.   var r_Legacy_recoilmagvariance = Legacy_Sheet.getRange('ab2:ab');
  71.   var r_Legacy_spreadalt = Legacy_Sheet.getRange('ad2:ad');
  72.   var r_Legacy_inaccuracycrouchalt = Legacy_Sheet.getRange('ae2:ae');
  73.   var r_Legacy_inaccuracystandalt = Legacy_Sheet.getRange('af2:af');
  74.   var r_Legacy_inaccuracyfirealt = Legacy_Sheet.getRange('ag2:ag');
  75.   var r_Legacy_inaccuracymovealt = Legacy_Sheet.getRange('ah2:ah');
  76.   var r_Legacy_inaccuracyjumpalt = Legacy_Sheet.getRange('ai2:ai');
  77.   var r_Legacy_inaccuracylandalt = Legacy_Sheet.getRange('aj2:aj');
  78.   var r_Legacy_inaccuracyladderalt = Legacy_Sheet.getRange('ak2:ak');
  79.   var r_Legacy_recoilanglevariancealt = Legacy_Sheet.getRange('al2:al');
  80.   var r_Legacy_recoilmagnitudealt = Legacy_Sheet.getRange('am2:am');
  81.   var r_Legacy_recoilmagvariancealt = Legacy_Sheet.getRange('an2:an');
  82.  
  83.   var All_armorratio = r_All_armorratio.getValues();
  84.   var All_damage = r_All_damage.getValues();
  85.   var All_rangemodifier = r_All_rangemodifier.getValues();
  86.   var All_cycletime = r_All_cycletime.getValues();
  87.   var All_penetration = r_All_penetration.getValues();
  88.   var All_killaward = r_All_killaward.getValues();
  89.   var All_maxplayerspeed = r_All_maxplayerspeed.getValues();
  90.   var All_clip_size = r_All_clip_size.getValues();
  91.   var All_weaponprice = r_All_weaponprice.getValues();
  92.   var All_range = r_All_range.getValues();
  93.   var All_fullauto = r_All_fullauto.getValues();
  94.   var All_flinchvelocitylarge = r_All_flinchvelocitylarge.getValues();
  95.   var All_flinchvelocitysmall = r_All_flinchvelocitysmall.getValues();
  96.   var All_spread = r_All_spread.getValues();
  97.   var All_inaccuracycrouch = r_All_inaccuracycrouch.getValues();
  98.   var All_inaccuracystand = r_All_inaccuracystand.getValues();
  99.   var All_inaccuracyfire = r_All_inaccuracyfire.getValues();
  100.   var All_inaccuracymove = r_All_inaccuracymove.getValues();
  101.   var All_inaccuracyjump = r_All_inaccuracyjump.getValues();
  102.   var All_inaccuracyland = r_All_inaccuracyland.getValues();
  103.   var All_inaccuracyladder = r_All_inaccuracyladder.getValues();
  104.   var All_recoverytimecrouch = r_All_recoverytimecrouch.getValues();
  105.   var All_recoverytimestand = r_All_recoverytimestand.getValues();
  106.   var All_recoilanglevariance = r_All_recoilanglevariance.getValues();
  107.   var All_recoilmagnitude = r_All_recoilmagnitude.getValues();
  108.   var All_recoilmagvariance = r_All_recoilmagvariance.getValues();
  109.   var All_spreadalt = r_All_spreadalt.getValues();
  110.   var All_inaccuracycrouchalt = r_All_inaccuracycrouchalt.getValues();
  111.   var All_inaccuracystandalt = r_All_inaccuracystandalt.getValues();
  112.   var All_inaccuracyfirealt = r_All_inaccuracyfirealt.getValues();
  113.   var All_inaccuracymovealt = r_All_inaccuracymovealt.getValues();
  114.   var All_inaccuracyjumpalt = r_All_inaccuracyjumpalt.getValues();
  115.   var All_inaccuracylandalt = r_All_inaccuracylandalt.getValues();
  116.   var All_inaccuracyladderalt = r_All_inaccuracyladderalt.getValues();
  117.   var All_recoilanglevariancealt = r_All_recoilanglevariancealt.getValues();
  118.   var All_recoilmagnitudealt = r_All_recoilmagnitudealt.getValues();
  119.   var All_recoilmagvariancealt = r_All_recoilmagvariancealt.getValues();
  120.  
  121.   var Legacy_armorratio = r_Legacy_armorratio.getValues();
  122.   var Legacy_damage = r_Legacy_damage.getValues();
  123.   var Legacy_rangemodifier = r_Legacy_rangemodifier.getValues();
  124.   var Legacy_cycletime = r_Legacy_cycletime.getValues();
  125.   var Legacy_penetration = r_Legacy_penetration.getValues();
  126.   var Legacy_killaward = r_Legacy_killaward.getValues();
  127.   var Legacy_maxplayerspeed = r_Legacy_maxplayerspeed.getValues();
  128.   var Legacy_clip_size = r_Legacy_clip_size.getValues();
  129.   var Legacy_weaponprice = r_Legacy_weaponprice.getValues();
  130.   var Legacy_range = r_Legacy_range.getValues();
  131.   var Legacy_fullauto = r_Legacy_fullauto.getValues();
  132.   var Legacy_flinchvelocitylarge = r_Legacy_flinchvelocitylarge.getValues();
  133.   var Legacy_flinchvelocitysmall = r_Legacy_flinchvelocitysmall.getValues();
  134.   var Legacy_spread = r_Legacy_spread.getValues();
  135.   var Legacy_inaccuracycrouch = r_Legacy_inaccuracycrouch.getValues();
  136.   var Legacy_inaccuracystand = r_Legacy_inaccuracystand.getValues();
  137.   var Legacy_inaccuracyfire = r_Legacy_inaccuracyfire.getValues();
  138.   var Legacy_inaccuracymove = r_Legacy_inaccuracymove.getValues();
  139.   var Legacy_inaccuracyjump = r_Legacy_inaccuracyjump.getValues();
  140.   var Legacy_inaccuracyland = r_Legacy_inaccuracyland.getValues();
  141.   var Legacy_inaccuracyladder = r_Legacy_inaccuracyladder.getValues();
  142.   var Legacy_recoverytimecrouch = r_Legacy_recoverytimecrouch.getValues();
  143.   var Legacy_recoverytimestand = r_Legacy_recoverytimestand.getValues();
  144.   var Legacy_recoilanglevariance = r_Legacy_recoilanglevariance.getValues();
  145.   var Legacy_recoilmagnitude = r_Legacy_recoilmagnitude.getValues();
  146.   var Legacy_recoilmagvariance = r_Legacy_recoilmagvariance.getValues();
  147.   var Legacy_spreadalt = r_Legacy_spreadalt.getValues();
  148.   var Legacy_inaccuracycrouchalt = r_Legacy_inaccuracycrouchalt.getValues();
  149.   var Legacy_inaccuracystandalt = r_Legacy_inaccuracystandalt.getValues();
  150.   var Legacy_inaccuracyfirealt = r_Legacy_inaccuracyfirealt.getValues();
  151.   var Legacy_inaccuracymovealt = r_Legacy_inaccuracymovealt.getValues();
  152.   var Legacy_inaccuracyjumpalt = r_Legacy_inaccuracyjumpalt.getValues();
  153.   var Legacy_inaccuracylandalt = r_Legacy_inaccuracylandalt.getValues();
  154.   var Legacy_inaccuracyladderalt = r_Legacy_inaccuracyladderalt.getValues();
  155.   var Legacy_recoilanglevariancealt = r_Legacy_recoilanglevariancealt.getValues();
  156.   var Legacy_recoilmagnitudealt = r_Legacy_recoilmagnitudealt.getValues();
  157.   var Legacy_recoilmagvariancealt = r_Legacy_recoilmagvariancealt.getValues();
  158.  
  159.   var numRows = r_All_armorratio.getNumRows();
  160.  
  161.   for (var i = 0; i <= numRows -1; i++){
  162.     var n = i + 2;
  163.     if (parseFloat(All_armorratio[i]) > parseFloat(Legacy_armorratio[i])){Legacy_Sheet.getRange('b'+n).setFontColor('#FF0000');}
  164.     if (parseInt(All_damage[i]) > parseInt(Legacy_damage[i])){Legacy_Sheet.getRange('c'+n).setFontColor('#FF0000');}
  165.     if (parseFloat(All_rangemodifier[i]) > parseFloat(Legacy_rangemodifier[i])){Legacy_Sheet.getRange('d'+n).setFontColor('#FF0000');}
  166.     if (parseFloat(All_cycletime[i]) > parseFloat(Legacy_cycletime[i])){Legacy_Sheet.getRange('e'+n).setFontColor('#38761D');}
  167.     if (parseInt(All_penetration[i]) > parseInt(Legacy_penetration[i])){Legacy_Sheet.getRange('f'+n).setFontColor('#FF0000');}
  168.     if (parseInt(All_killaward[i]) > parseInt(Legacy_killaward[i])){Legacy_Sheet.getRange('g'+n).setFontColor('#FF0000');}
  169.     if (parseInt(All_maxplayerspeed[i]) > parseInt(Legacy_maxplayerspeed[i])){Legacy_Sheet.getRange('h'+n).setFontColor('#FF0000');}
  170.     if (parseInt(All_clip_size[i]) > parseInt(Legacy_clip_size[i])){Legacy_Sheet.getRange('i'+n).setFontColor('#FF0000');}
  171.     if (parseInt(All_weaponprice[i]) > parseInt(Legacy_weaponprice[i])){Legacy_Sheet.getRange('j'+n).setFontColor('#38761D');}
  172.     if (parseInt(All_range[i]) > parseInt(Legacy_range[i])){Legacy_Sheet.getRange('k'+n).setFontColor('#FF0000');}
  173.     if (parseInt(All_fullauto[i]) > parseInt(Legacy_fullauto[i])){Legacy_Sheet.getRange('l'+n).setFontColor('#000000');}
  174.     if (parseFloat(All_flinchvelocitylarge[i]) > parseFloat(Legacy_flinchvelocitylarge[i])){Legacy_Sheet.getRange('m'+n).setFontColor('#38761D');}
  175.     if (parseFloat(All_flinchvelocitysmall[i]) > parseFloat(Legacy_flinchvelocitysmall[i])){Legacy_Sheet.getRange('n'+n).setFontColor('#38761D');}
  176.     if (parseFloat(All_spread[i]) > parseFloat(Legacy_spread[i])){Legacy_Sheet.getRange('p'+n).setFontColor('#38761D');}
  177.     if (parseFloat(All_inaccuracycrouch[i]) > parseFloat(Legacy_inaccuracycrouch[i])){Legacy_Sheet.getRange('q'+n).setFontColor('#38761D');}
  178.     if (parseFloat(All_inaccuracystand[i]) > parseFloat(Legacy_inaccuracystand[i])){Legacy_Sheet.getRange('r'+n).setFontColor('#38761D');}
  179.     if (parseFloat(All_inaccuracyfire[i]) > parseFloat(Legacy_inaccuracyfire[i])){Legacy_Sheet.getRange('s'+n).setFontColor('#38761D');}
  180.     if (parseFloat(All_inaccuracymove[i]) > parseFloat(Legacy_inaccuracymove[i])){Legacy_Sheet.getRange('t'+n).setFontColor('#38761D');}
  181.     if (parseFloat(All_inaccuracyjump[i]) > parseFloat(Legacy_inaccuracyjump[i])){Legacy_Sheet.getRange('u'+n).setFontColor('#38761D');}
  182.     if (parseFloat(All_inaccuracyland[i]) > parseFloat(Legacy_inaccuracyland[i])){Legacy_Sheet.getRange('v'+n).setFontColor('#38761D');}
  183.     if (parseFloat(All_inaccuracyladder[i]) > parseFloat(Legacy_inaccuracyladder[i])){Legacy_Sheet.getRange('w'+n).setFontColor('#38761D');}
  184.     if (parseFloat(All_recoverytimecrouch[i]) > parseFloat(Legacy_recoverytimecrouch[i])){Legacy_Sheet.getRange('x'+n).setFontColor('#38761D');}
  185.     if (parseFloat(All_recoverytimestand[i]) > parseFloat(Legacy_recoverytimestand[i])){Legacy_Sheet.getRange('y'+n).setFontColor('#38761D');}
  186.     if (parseInt(All_recoilanglevariance[i]) > parseInt(Legacy_recoilanglevariance[i])){Legacy_Sheet.getRange('z'+n).setFontColor('#38761D');}
  187.     if (parseInt(All_recoilmagnitude[i]) > parseInt(Legacy_recoilmagnitude[i])){Legacy_Sheet.getRange('aa'+n).setFontColor('#38761D');}
  188.     if (parseInt(All_recoilmagvariance[i]) > parseInt(Legacy_recoilmagvariance[i])){Legacy_Sheet.getRange('ab'+n).setFontColor('#38761D');}
  189.     if (parseFloat(All_spreadalt[i]) > parseFloat(Legacy_spreadalt[i])){Legacy_Sheet.getRange('ad'+n).setFontColor('#38761D');}
  190.     if (parseFloat(All_inaccuracycrouchalt[i]) > parseFloat(Legacy_inaccuracycrouchalt[i])){Legacy_Sheet.getRange('ae'+n).setFontColor('#38761D');}
  191.     if (parseFloat(All_inaccuracystandalt[i]) > parseFloat(Legacy_inaccuracystandalt[i])){Legacy_Sheet.getRange('af'+n).setFontColor('#38761D');}
  192.     if (parseFloat(All_inaccuracyfirealt[i]) > parseFloat(Legacy_inaccuracyfirealt[i])){Legacy_Sheet.getRange('ag'+n).setFontColor('#38761D');}
  193.     if (parseFloat(All_inaccuracymovealt[i]) > parseFloat(Legacy_inaccuracymovealt[i])){Legacy_Sheet.getRange('ah'+n).setFontColor('#38761D');}
  194.     if (parseFloat(All_inaccuracyjumpalt[i]) > parseFloat(Legacy_inaccuracyjumpalt[i])){Legacy_Sheet.getRange('ai'+n).setFontColor('#38761D');}
  195.     if (parseFloat(All_inaccuracylandalt[i]) > parseFloat(Legacy_inaccuracylandalt[i])){Legacy_Sheet.getRange('aj'+n).setFontColor('#38761D');}
  196.     if (parseFloat(All_inaccuracyladderalt[i]) > parseFloat(Legacy_inaccuracyladderalt[i])){Legacy_Sheet.getRange('ak'+n).setFontColor('#38761D');}
  197.     if (All_recoilanglevariancealt[i] > Legacy_recoilanglevariancealt[i]){Legacy_Sheet.getRange('al'+n).setFontColor('#38761D');}
  198.     if (All_recoilmagnitudealt[i] > Legacy_recoilmagnitudealt[i]){Legacy_Sheet.getRange('am'+n).setFontColor('#38761D');}
  199.     if (All_recoilmagvariancealt[i] > Legacy_recoilmagvariancealt[i]){Legacy_Sheet.getRange('an'+n).setFontColor('#38761D');}
  200.    
  201.     if (parseFloat(All_armorratio[i]) < parseFloat(Legacy_armorratio[i])){Legacy_Sheet.getRange('b'+n).setFontColor('#38761D');}
  202.     if (parseInt(All_damage[i]) < parseInt(Legacy_damage[i])){Legacy_Sheet.getRange('c'+n).setFontColor('#38761D');}
  203.     if (parseFloat(All_rangemodifier[i]) < parseFloat(Legacy_rangemodifier[i])){Legacy_Sheet.getRange('d'+n).setFontColor('#38761D');}
  204.     if (parseFloat(All_cycletime[i]) < parseFloat(Legacy_cycletime[i])){Legacy_Sheet.getRange('e'+n).setFontColor('#FF0000');}
  205.     if (parseInt(All_penetration[i]) < parseInt(Legacy_penetration[i])){Legacy_Sheet.getRange('f'+n).setFontColor('#38761D');}
  206.     if (parseInt(All_killaward[i]) < parseInt(Legacy_killaward[i])){Legacy_Sheet.getRange('g'+n).setFontColor('#38761D');}
  207.     if (parseInt(All_maxplayerspeed[i]) < parseInt(Legacy_maxplayerspeed[i])){Legacy_Sheet.getRange('h'+n).setFontColor('#38761D');}
  208.     if (parseInt(All_clip_size[i]) < parseInt(Legacy_clip_size[i])){Legacy_Sheet.getRange('i'+n).setFontColor('#38761D');}
  209.     if (parseInt(All_weaponprice[i]) < parseInt(Legacy_weaponprice[i])){Legacy_Sheet.getRange('j'+n).setFontColor('#FF0000');}
  210.     if (parseInt(All_range[i]) < parseInt(Legacy_range[i])){Legacy_Sheet.getRange('k'+n).setFontColor('#38761D');}
  211.     if (parseInt(All_fullauto[i]) < parseInt(Legacy_fullauto[i])){Legacy_Sheet.getRange('l'+n).setFontColor('#000000');}
  212.     if (parseFloat(All_flinchvelocitylarge[i]) < parseFloat(Legacy_flinchvelocitylarge[i])){Legacy_Sheet.getRange('m'+n).setFontColor('#FF0000');}
  213.     if (parseFloat(All_flinchvelocitysmall[i]) < parseFloat(Legacy_flinchvelocitysmall[i])){Legacy_Sheet.getRange('n'+n).setFontColor('#FF0000');}
  214.     if (parseFloat(All_spread[i]) < parseFloat(Legacy_spread[i])){Legacy_Sheet.getRange('p'+n).setFontColor('#FF0000');}
  215.     if (parseFloat(All_inaccuracycrouch[i]) < parseFloat(Legacy_inaccuracycrouch[i])){Legacy_Sheet.getRange('q'+n).setFontColor('#FF0000');}
  216.     if (parseFloat(All_inaccuracystand[i]) < parseFloat(Legacy_inaccuracystand[i])){Legacy_Sheet.getRange('r'+n).setFontColor('#FF0000');}
  217.     if (parseFloat(All_inaccuracyfire[i]) < parseFloat(Legacy_inaccuracyfire[i])){Legacy_Sheet.getRange('s'+n).setFontColor('#FF0000');}
  218.     if (parseFloat(All_inaccuracymove[i]) < parseFloat(Legacy_inaccuracymove[i])){Legacy_Sheet.getRange('t'+n).setFontColor('#FF0000');}
  219.     if (parseFloat(All_inaccuracyjump[i]) < parseFloat(Legacy_inaccuracyjump[i])){Legacy_Sheet.getRange('u'+n).setFontColor('#FF0000');}
  220.     if (parseFloat(All_inaccuracyland[i]) < parseFloat(Legacy_inaccuracyland[i])){Legacy_Sheet.getRange('v'+n).setFontColor('#FF0000');}
  221.     if (parseFloat(All_inaccuracyladder[i]) < parseFloat(Legacy_inaccuracyladder[i])){Legacy_Sheet.getRange('w'+n).setFontColor('#FF0000');}
  222.     if (parseFloat(All_recoverytimecrouch[i]) < parseFloat(Legacy_recoverytimecrouch[i])){Legacy_Sheet.getRange('x'+n).setFontColor('#FF0000');}
  223.     if (parseFloat(All_recoverytimestand[i]) < parseFloat(Legacy_recoverytimestand[i])){Legacy_Sheet.getRange('y'+n).setFontColor('#FF0000');}
  224.     if (parseInt(All_recoilanglevariance[i]) < parseInt(Legacy_recoilanglevariance[i])){Legacy_Sheet.getRange('z'+n).setFontColor('#FF0000');}
  225.     if (parseInt(All_recoilmagnitude[i]) < parseInt(Legacy_recoilmagnitude[i])){Legacy_Sheet.getRange('aa'+n).setFontColor('#FF0000');}
  226.     if (parseInt(All_recoilmagvariance[i]) < parseInt(Legacy_recoilmagvariance[i])){Legacy_Sheet.getRange('ab'+n).setFontColor('#FF0000');}
  227.     if (parseFloat(All_spreadalt[i]) < parseFloat(Legacy_spreadalt[i])){Legacy_Sheet.getRange('ad'+n).setFontColor('#FF0000');}
  228.     if (parseFloat(All_inaccuracycrouchalt[i]) < parseFloat(Legacy_inaccuracycrouchalt[i])){Legacy_Sheet.getRange('ae'+n).setFontColor('#FF0000');}
  229.     if (parseFloat(All_inaccuracystandalt[i]) < parseFloat(Legacy_inaccuracystandalt[i])){Legacy_Sheet.getRange('af'+n).setFontColor('#FF0000');}
  230.     if (parseFloat(All_inaccuracyfirealt[i]) < parseFloat(Legacy_inaccuracyfirealt[i])){Legacy_Sheet.getRange('ag'+n).setFontColor('#FF0000');}
  231.     if (parseFloat(All_inaccuracymovealt[i]) < parseFloat(Legacy_inaccuracymovealt[i])){Legacy_Sheet.getRange('ah'+n).setFontColor('#FF0000');}
  232.     if (parseFloat(All_inaccuracyjumpalt[i]) < parseFloat(Legacy_inaccuracyjumpalt[i])){Legacy_Sheet.getRange('ai'+n).setFontColor('#FF0000');}
  233.     if (parseFloat(All_inaccuracylandalt[i]) < parseFloat(Legacy_inaccuracylandalt[i])){Legacy_Sheet.getRange('aj'+n).setFontColor('#FF0000');}
  234.     if (parseFloat(All_inaccuracyladderalt[i]) < parseFloat(Legacy_inaccuracyladderalt[i])){Legacy_Sheet.getRange('ak'+n).setFontColor('#FF0000');}
  235.     if (parseInt(All_recoilanglevariancealt[i]) < parseInt(Legacy_recoilanglevariancealt[i])){Legacy_Sheet.getRange('al'+n).setFontColor('#FF0000');}
  236.     if (parseInt(All_recoilmagnitudealt[i]) < parseInt(Legacy_recoilmagnitudealt[i])){Legacy_Sheet.getRange('am'+n).setFontColor('#FF0000');}
  237.     if (parseInt(All_recoilmagvariancealt[i]) < parseInt(Legacy_recoilmagvariancealt[i])){Legacy_Sheet.getRange('an'+n).setFontColor('#FF0000');}  
  238.    
  239.     if (parseFloat(All_armorratio[i]) == parseFloat(Legacy_armorratio[i])){Legacy_Sheet.getRange('b'+n).setFontColor('#000000');}
  240.     if (parseInt(All_damage[i]) == parseInt(Legacy_damage[i])){Legacy_Sheet.getRange('c'+n).setFontColor('#000000');}
  241.     if (parseFloat(All_rangemodifier[i]) == parseFloat(Legacy_rangemodifier[i])){Legacy_Sheet.getRange('d'+n).setFontColor('#000000');}
  242.     if (parseFloat(All_cycletime[i]) == parseFloat(Legacy_cycletime[i])){Legacy_Sheet.getRange('e'+n).setFontColor('#000000');}
  243.     if (parseInt(All_penetration[i]) == parseInt(Legacy_penetration[i])){Legacy_Sheet.getRange('f'+n).setFontColor('#000000');}
  244.     if (parseInt(All_killaward[i]) == parseInt(Legacy_killaward[i])){Legacy_Sheet.getRange('g'+n).setFontColor('#000000');}
  245.     if (parseInt(All_maxplayerspeed[i]) == parseInt(Legacy_maxplayerspeed[i])){Legacy_Sheet.getRange('h'+n).setFontColor('#000000');}
  246.     if (parseInt(All_clip_size[i]) == parseInt(Legacy_clip_size[i])){Legacy_Sheet.getRange('i'+n).setFontColor('#000000');}
  247.     if (parseInt(All_weaponprice[i]) == parseInt(Legacy_weaponprice[i])){Legacy_Sheet.getRange('j'+n).setFontColor('#000000');}
  248.     if (parseInt(All_range[i]) === parseInt(Legacy_range[i])){Legacy_Sheet.getRange('k'+n).setFontColor('#000000');}
  249.     if (parseInt(All_fullauto[i]) == parseInt(Legacy_fullauto[i])){Legacy_Sheet.getRange('l'+n).setFontColor('#000000');}
  250.     if (parseFloat(All_flinchvelocitylarge[i]) == parseFloat(Legacy_flinchvelocitylarge[i])){Legacy_Sheet.getRange('m'+n).setFontColor('#000000');}
  251.     if (parseFloat(All_flinchvelocitysmall[i]) == parseFloat(Legacy_flinchvelocitysmall[i])){Legacy_Sheet.getRange('n'+n).setFontColor('#000000');}
  252.     if (parseFloat(All_spread[i]) == parseFloat(Legacy_spread[i])){Legacy_Sheet.getRange('p'+n).setFontColor('#000000');}
  253.     if (parseFloat(All_inaccuracycrouch[i]) == parseFloat(Legacy_inaccuracycrouch[i])){Legacy_Sheet.getRange('q'+n).setFontColor('#000000');}
  254.     if (parseFloat(All_inaccuracystand[i]) == parseFloat(Legacy_inaccuracystand[i])){Legacy_Sheet.getRange('r'+n).setFontColor('#000000');}
  255.     if (parseFloat(All_inaccuracyfire[i]) == parseFloat(Legacy_inaccuracyfire[i])){Legacy_Sheet.getRange('s'+n).setFontColor('#000000');}
  256.     if (parseFloat(All_inaccuracymove[i]) == parseFloat(Legacy_inaccuracymove[i])){Legacy_Sheet.getRange('t'+n).setFontColor('#000000');}
  257.     if (parseFloat(All_inaccuracyjump[i]) == parseFloat(Legacy_inaccuracyjump[i])){Legacy_Sheet.getRange('u'+n).setFontColor('#000000');}
  258.     if (parseFloat(All_inaccuracyland[i]) == parseFloat(Legacy_inaccuracyland[i])){Legacy_Sheet.getRange('v'+n).setFontColor('#000000');}
  259.     if (parseFloat(All_inaccuracyladder[i]) == parseFloat(Legacy_inaccuracyladder[i])){Legacy_Sheet.getRange('w'+n).setFontColor('#000000');}
  260.     if (parseFloat(All_recoverytimecrouch[i]) == parseFloat(Legacy_recoverytimecrouch[i])){Legacy_Sheet.getRange('x'+n).setFontColor('#000000');}
  261.     if (parseFloat(All_recoverytimestand[i]) == parseFloat(Legacy_recoverytimestand[i])){Legacy_Sheet.getRange('y'+n).setFontColor('#000000');}
  262.     if (parseInt(All_recoilanglevariance[i]) == parseInt(Legacy_recoilanglevariance[i])){Legacy_Sheet.getRange('z'+n).setFontColor('#000000');}
  263.     if (parseInt(All_recoilmagnitude[i]) == parseInt(Legacy_recoilmagnitude[i])){Legacy_Sheet.getRange('aa'+n).setFontColor('#000000');}
  264.     if (parseInt(All_recoilmagvariance[i]) == parseInt(Legacy_recoilmagvariance[i])){Legacy_Sheet.getRange('ab'+n).setFontColor('#000000');}
  265.     if (parseFloat(All_spreadalt[i]) == parseFloat(Legacy_spreadalt[i])){Legacy_Sheet.getRange('ad'+n).setFontColor('#000000');}
  266.     if (parseFloat(All_inaccuracycrouchalt[i]) == parseFloat(Legacy_inaccuracycrouchalt[i])){Legacy_Sheet.getRange('ae'+n).setFontColor('#000000');}
  267.     if (parseFloat(All_inaccuracystandalt[i]) == parseFloat(Legacy_inaccuracystandalt[i])){Legacy_Sheet.getRange('af'+n).setFontColor('#000000');}
  268.     if (parseFloat(All_inaccuracyfirealt[i]) == parseFloat(Legacy_inaccuracyfirealt[i])){Legacy_Sheet.getRange('ag'+n).setFontColor('#000000');}
  269.     if (parseFloat(All_inaccuracymovealt[i]) == parseFloat(Legacy_inaccuracymovealt[i])){Legacy_Sheet.getRange('ah'+n).setFontColor('#000000');}
  270.     if (parseFloat(All_inaccuracyjumpalt[i]) == parseFloat(Legacy_inaccuracyjumpalt[i])){Legacy_Sheet.getRange('ai'+n).setFontColor('#000000');}
  271.     if (parseFloat(All_inaccuracylandalt[i]) == parseFloat(Legacy_inaccuracylandalt[i])){Legacy_Sheet.getRange('aj'+n).setFontColor('#000000');}
  272.     if (parseFloat(All_inaccuracyladderalt[i]) == parseFloat(Legacy_inaccuracyladderalt[i])){Legacy_Sheet.getRange('ak'+n).setFontColor('#000000');}
  273.     if (parseInt(All_recoilanglevariancealt[i]) == parseInt(Legacy_recoilanglevariancealt[i])){Legacy_Sheet.getRange('al'+n).setFontColor('#000000');}
  274.     if (parseInt(All_recoilmagnitudealt[i]) == parseInt(Legacy_recoilmagnitudealt[i])){Legacy_Sheet.getRange('am'+n).setFontColor('#000000');}
  275.     if (parseInt(All_recoilmagvariancealt[i]) == parseInt(Legacy_recoilmagvariancealt[i])){Legacy_Sheet.getRange('an'+n).setFontColor('#000000');}
  276.    
  277.     }
  278. };
  279.  
  280. /**
  281.  * Adds a custom menu to the active spreadsheet, containing a single menu item
  282.  * for invoking the readRows() function specified above.
  283.  * The onOpen() function, when defined, is automatically invoked whenever the
  284.  * spreadsheet is opened.
  285.  * For more information on using the Spreadsheet API, see
  286.  * https://developers.google.com/apps-script/service_spreadsheet
  287.  */
  288. function onOpen() {
  289.   var sheet = SpreadsheetApp.getActiveSpreadsheet();
  290.   var entries = [{
  291.     name : "Read Data",
  292.     functionName : "readRows"
  293.   }];
  294.   sheet.addMenu("Script Center Menu", entries);
  295. };
Advertisement
Add Comment
Please, Sign In to add comment