Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit() {
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var All_Sheet = ss.getSheetByName('All');
- var Legacy_Sheet = ss.getSheetByName('Legacy');
- var r_All_armorratio = All_Sheet.getRange('b2:b');
- var r_All_damage = All_Sheet.getRange('c2:c');
- var r_All_rangemodifier = All_Sheet.getRange('d2:d');
- var r_All_cycletime = All_Sheet.getRange('e2:e');
- var r_All_penetration = All_Sheet.getRange('f2:f');
- var r_All_killaward = All_Sheet.getRange('g2:g');
- var r_All_maxplayerspeed = All_Sheet.getRange('h2:h');
- var r_All_clip_size = All_Sheet.getRange('i2:i');
- var r_All_weaponprice = All_Sheet.getRange('j2:j');
- var r_All_range = All_Sheet.getRange('k2:k');
- var r_All_fullauto = All_Sheet.getRange('l2:l');
- var r_All_flinchvelocitylarge = All_Sheet.getRange('m2:m');
- var r_All_flinchvelocitysmall = All_Sheet.getRange('n2:n');
- var r_All_spread = All_Sheet.getRange('p2:p');
- var r_All_inaccuracycrouch = All_Sheet.getRange('q2:q');
- var r_All_inaccuracystand = All_Sheet.getRange('r2:r');
- var r_All_inaccuracyfire = All_Sheet.getRange('s2:s');
- var r_All_inaccuracymove = All_Sheet.getRange('t2:t');
- var r_All_inaccuracyjump = All_Sheet.getRange('u2:u');
- var r_All_inaccuracyland = All_Sheet.getRange('v2:v');
- var r_All_inaccuracyladder = All_Sheet.getRange('w2:w');
- var r_All_recoverytimecrouch = All_Sheet.getRange('x2:x');
- var r_All_recoverytimestand = All_Sheet.getRange('y2:y');
- var r_All_recoilanglevariance = All_Sheet.getRange('z2:z');
- var r_All_recoilmagnitude = All_Sheet.getRange('aa2:aa');
- var r_All_recoilmagvariance = All_Sheet.getRange('ab2:ab');
- var r_All_spreadalt = All_Sheet.getRange('ad2:ad');
- var r_All_inaccuracycrouchalt = All_Sheet.getRange('ae2:ae');
- var r_All_inaccuracystandalt = All_Sheet.getRange('af2:af');
- var r_All_inaccuracyfirealt = All_Sheet.getRange('ag2:ag');
- var r_All_inaccuracymovealt = All_Sheet.getRange('ah2:ah');
- var r_All_inaccuracyjumpalt = All_Sheet.getRange('ai2:ai');
- var r_All_inaccuracylandalt = All_Sheet.getRange('aj2:aj');
- var r_All_inaccuracyladderalt = All_Sheet.getRange('ak2:ak');
- var r_All_recoilanglevariancealt = All_Sheet.getRange('al2:al');
- var r_All_recoilmagnitudealt = All_Sheet.getRange('am2:am');
- var r_All_recoilmagvariancealt = All_Sheet.getRange('an2:an');
- var r_All_bullets = All_Sheet.getRange('ao11:ao14');
- var r_Legacy_armorratio = Legacy_Sheet.getRange('b2:b');
- var r_Legacy_damage = Legacy_Sheet.getRange('c2:c');
- var r_Legacy_rangemodifier = Legacy_Sheet.getRange('d2:d');
- var r_Legacy_cycletime = Legacy_Sheet.getRange('e2:e');
- var r_Legacy_penetration = Legacy_Sheet.getRange('f2:f');
- var r_Legacy_killaward = Legacy_Sheet.getRange('g2:g');
- var r_Legacy_maxplayerspeed = Legacy_Sheet.getRange('h2:h');
- var r_Legacy_clip_size = Legacy_Sheet.getRange('i2:i');
- var r_Legacy_weaponprice = Legacy_Sheet.getRange('j2:j');
- var r_Legacy_range = Legacy_Sheet.getRange('k2:k');
- var r_Legacy_fullauto = Legacy_Sheet.getRange('l2:l');
- var r_Legacy_flinchvelocitylarge = Legacy_Sheet.getRange('m2:m');
- var r_Legacy_flinchvelocitysmall = Legacy_Sheet.getRange('n2:n');
- var r_Legacy_spread = Legacy_Sheet.getRange('p2:p');
- var r_Legacy_inaccuracycrouch = Legacy_Sheet.getRange('q2:q');
- var r_Legacy_inaccuracystand = Legacy_Sheet.getRange('r2:r');
- var r_Legacy_inaccuracyfire = Legacy_Sheet.getRange('s2:s');
- var r_Legacy_inaccuracymove = Legacy_Sheet.getRange('t2:t');
- var r_Legacy_inaccuracyjump = Legacy_Sheet.getRange('u2:u');
- var r_Legacy_inaccuracyland = Legacy_Sheet.getRange('v2:v');
- var r_Legacy_inaccuracyladder = Legacy_Sheet.getRange('w2:w');
- var r_Legacy_recoverytimecrouch = Legacy_Sheet.getRange('x2:x');
- var r_Legacy_recoverytimestand = Legacy_Sheet.getRange('y2:y');
- var r_Legacy_recoilanglevariance = Legacy_Sheet.getRange('z2:z');
- var r_Legacy_recoilmagnitude = Legacy_Sheet.getRange('aa2:aa');
- var r_Legacy_recoilmagvariance = Legacy_Sheet.getRange('ab2:ab');
- var r_Legacy_spreadalt = Legacy_Sheet.getRange('ad2:ad');
- var r_Legacy_inaccuracycrouchalt = Legacy_Sheet.getRange('ae2:ae');
- var r_Legacy_inaccuracystandalt = Legacy_Sheet.getRange('af2:af');
- var r_Legacy_inaccuracyfirealt = Legacy_Sheet.getRange('ag2:ag');
- var r_Legacy_inaccuracymovealt = Legacy_Sheet.getRange('ah2:ah');
- var r_Legacy_inaccuracyjumpalt = Legacy_Sheet.getRange('ai2:ai');
- var r_Legacy_inaccuracylandalt = Legacy_Sheet.getRange('aj2:aj');
- var r_Legacy_inaccuracyladderalt = Legacy_Sheet.getRange('ak2:ak');
- var r_Legacy_recoilanglevariancealt = Legacy_Sheet.getRange('al2:al');
- var r_Legacy_recoilmagnitudealt = Legacy_Sheet.getRange('am2:am');
- var r_Legacy_recoilmagvariancealt = Legacy_Sheet.getRange('an2:an');
- var All_armorratio = r_All_armorratio.getValues();
- var All_damage = r_All_damage.getValues();
- var All_rangemodifier = r_All_rangemodifier.getValues();
- var All_cycletime = r_All_cycletime.getValues();
- var All_penetration = r_All_penetration.getValues();
- var All_killaward = r_All_killaward.getValues();
- var All_maxplayerspeed = r_All_maxplayerspeed.getValues();
- var All_clip_size = r_All_clip_size.getValues();
- var All_weaponprice = r_All_weaponprice.getValues();
- var All_range = r_All_range.getValues();
- var All_fullauto = r_All_fullauto.getValues();
- var All_flinchvelocitylarge = r_All_flinchvelocitylarge.getValues();
- var All_flinchvelocitysmall = r_All_flinchvelocitysmall.getValues();
- var All_spread = r_All_spread.getValues();
- var All_inaccuracycrouch = r_All_inaccuracycrouch.getValues();
- var All_inaccuracystand = r_All_inaccuracystand.getValues();
- var All_inaccuracyfire = r_All_inaccuracyfire.getValues();
- var All_inaccuracymove = r_All_inaccuracymove.getValues();
- var All_inaccuracyjump = r_All_inaccuracyjump.getValues();
- var All_inaccuracyland = r_All_inaccuracyland.getValues();
- var All_inaccuracyladder = r_All_inaccuracyladder.getValues();
- var All_recoverytimecrouch = r_All_recoverytimecrouch.getValues();
- var All_recoverytimestand = r_All_recoverytimestand.getValues();
- var All_recoilanglevariance = r_All_recoilanglevariance.getValues();
- var All_recoilmagnitude = r_All_recoilmagnitude.getValues();
- var All_recoilmagvariance = r_All_recoilmagvariance.getValues();
- var All_spreadalt = r_All_spreadalt.getValues();
- var All_inaccuracycrouchalt = r_All_inaccuracycrouchalt.getValues();
- var All_inaccuracystandalt = r_All_inaccuracystandalt.getValues();
- var All_inaccuracyfirealt = r_All_inaccuracyfirealt.getValues();
- var All_inaccuracymovealt = r_All_inaccuracymovealt.getValues();
- var All_inaccuracyjumpalt = r_All_inaccuracyjumpalt.getValues();
- var All_inaccuracylandalt = r_All_inaccuracylandalt.getValues();
- var All_inaccuracyladderalt = r_All_inaccuracyladderalt.getValues();
- var All_recoilanglevariancealt = r_All_recoilanglevariancealt.getValues();
- var All_recoilmagnitudealt = r_All_recoilmagnitudealt.getValues();
- var All_recoilmagvariancealt = r_All_recoilmagvariancealt.getValues();
- var Legacy_armorratio = r_Legacy_armorratio.getValues();
- var Legacy_damage = r_Legacy_damage.getValues();
- var Legacy_rangemodifier = r_Legacy_rangemodifier.getValues();
- var Legacy_cycletime = r_Legacy_cycletime.getValues();
- var Legacy_penetration = r_Legacy_penetration.getValues();
- var Legacy_killaward = r_Legacy_killaward.getValues();
- var Legacy_maxplayerspeed = r_Legacy_maxplayerspeed.getValues();
- var Legacy_clip_size = r_Legacy_clip_size.getValues();
- var Legacy_weaponprice = r_Legacy_weaponprice.getValues();
- var Legacy_range = r_Legacy_range.getValues();
- var Legacy_fullauto = r_Legacy_fullauto.getValues();
- var Legacy_flinchvelocitylarge = r_Legacy_flinchvelocitylarge.getValues();
- var Legacy_flinchvelocitysmall = r_Legacy_flinchvelocitysmall.getValues();
- var Legacy_spread = r_Legacy_spread.getValues();
- var Legacy_inaccuracycrouch = r_Legacy_inaccuracycrouch.getValues();
- var Legacy_inaccuracystand = r_Legacy_inaccuracystand.getValues();
- var Legacy_inaccuracyfire = r_Legacy_inaccuracyfire.getValues();
- var Legacy_inaccuracymove = r_Legacy_inaccuracymove.getValues();
- var Legacy_inaccuracyjump = r_Legacy_inaccuracyjump.getValues();
- var Legacy_inaccuracyland = r_Legacy_inaccuracyland.getValues();
- var Legacy_inaccuracyladder = r_Legacy_inaccuracyladder.getValues();
- var Legacy_recoverytimecrouch = r_Legacy_recoverytimecrouch.getValues();
- var Legacy_recoverytimestand = r_Legacy_recoverytimestand.getValues();
- var Legacy_recoilanglevariance = r_Legacy_recoilanglevariance.getValues();
- var Legacy_recoilmagnitude = r_Legacy_recoilmagnitude.getValues();
- var Legacy_recoilmagvariance = r_Legacy_recoilmagvariance.getValues();
- var Legacy_spreadalt = r_Legacy_spreadalt.getValues();
- var Legacy_inaccuracycrouchalt = r_Legacy_inaccuracycrouchalt.getValues();
- var Legacy_inaccuracystandalt = r_Legacy_inaccuracystandalt.getValues();
- var Legacy_inaccuracyfirealt = r_Legacy_inaccuracyfirealt.getValues();
- var Legacy_inaccuracymovealt = r_Legacy_inaccuracymovealt.getValues();
- var Legacy_inaccuracyjumpalt = r_Legacy_inaccuracyjumpalt.getValues();
- var Legacy_inaccuracylandalt = r_Legacy_inaccuracylandalt.getValues();
- var Legacy_inaccuracyladderalt = r_Legacy_inaccuracyladderalt.getValues();
- var Legacy_recoilanglevariancealt = r_Legacy_recoilanglevariancealt.getValues();
- var Legacy_recoilmagnitudealt = r_Legacy_recoilmagnitudealt.getValues();
- var Legacy_recoilmagvariancealt = r_Legacy_recoilmagvariancealt.getValues();
- var numRows = r_All_armorratio.getNumRows();
- for (var i = 0; i <= numRows -1; i++){
- var n = i + 2;
- if (parseFloat(All_armorratio[i]) > parseFloat(Legacy_armorratio[i])){Legacy_Sheet.getRange('b'+n).setFontColor('#FF0000');}
- if (parseInt(All_damage[i]) > parseInt(Legacy_damage[i])){Legacy_Sheet.getRange('c'+n).setFontColor('#FF0000');}
- if (parseFloat(All_rangemodifier[i]) > parseFloat(Legacy_rangemodifier[i])){Legacy_Sheet.getRange('d'+n).setFontColor('#FF0000');}
- if (parseFloat(All_cycletime[i]) > parseFloat(Legacy_cycletime[i])){Legacy_Sheet.getRange('e'+n).setFontColor('#38761D');}
- if (parseInt(All_penetration[i]) > parseInt(Legacy_penetration[i])){Legacy_Sheet.getRange('f'+n).setFontColor('#FF0000');}
- if (parseInt(All_killaward[i]) > parseInt(Legacy_killaward[i])){Legacy_Sheet.getRange('g'+n).setFontColor('#FF0000');}
- if (parseInt(All_maxplayerspeed[i]) > parseInt(Legacy_maxplayerspeed[i])){Legacy_Sheet.getRange('h'+n).setFontColor('#FF0000');}
- if (parseInt(All_clip_size[i]) > parseInt(Legacy_clip_size[i])){Legacy_Sheet.getRange('i'+n).setFontColor('#FF0000');}
- if (parseInt(All_weaponprice[i]) > parseInt(Legacy_weaponprice[i])){Legacy_Sheet.getRange('j'+n).setFontColor('#38761D');}
- if (parseInt(All_range[i]) > parseInt(Legacy_range[i])){Legacy_Sheet.getRange('k'+n).setFontColor('#FF0000');}
- if (parseInt(All_fullauto[i]) > parseInt(Legacy_fullauto[i])){Legacy_Sheet.getRange('l'+n).setFontColor('#000000');}
- if (parseFloat(All_flinchvelocitylarge[i]) > parseFloat(Legacy_flinchvelocitylarge[i])){Legacy_Sheet.getRange('m'+n).setFontColor('#38761D');}
- if (parseFloat(All_flinchvelocitysmall[i]) > parseFloat(Legacy_flinchvelocitysmall[i])){Legacy_Sheet.getRange('n'+n).setFontColor('#38761D');}
- if (parseFloat(All_spread[i]) > parseFloat(Legacy_spread[i])){Legacy_Sheet.getRange('p'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracycrouch[i]) > parseFloat(Legacy_inaccuracycrouch[i])){Legacy_Sheet.getRange('q'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracystand[i]) > parseFloat(Legacy_inaccuracystand[i])){Legacy_Sheet.getRange('r'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracyfire[i]) > parseFloat(Legacy_inaccuracyfire[i])){Legacy_Sheet.getRange('s'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracymove[i]) > parseFloat(Legacy_inaccuracymove[i])){Legacy_Sheet.getRange('t'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracyjump[i]) > parseFloat(Legacy_inaccuracyjump[i])){Legacy_Sheet.getRange('u'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracyland[i]) > parseFloat(Legacy_inaccuracyland[i])){Legacy_Sheet.getRange('v'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracyladder[i]) > parseFloat(Legacy_inaccuracyladder[i])){Legacy_Sheet.getRange('w'+n).setFontColor('#38761D');}
- if (parseFloat(All_recoverytimecrouch[i]) > parseFloat(Legacy_recoverytimecrouch[i])){Legacy_Sheet.getRange('x'+n).setFontColor('#38761D');}
- if (parseFloat(All_recoverytimestand[i]) > parseFloat(Legacy_recoverytimestand[i])){Legacy_Sheet.getRange('y'+n).setFontColor('#38761D');}
- if (parseInt(All_recoilanglevariance[i]) > parseInt(Legacy_recoilanglevariance[i])){Legacy_Sheet.getRange('z'+n).setFontColor('#38761D');}
- if (parseInt(All_recoilmagnitude[i]) > parseInt(Legacy_recoilmagnitude[i])){Legacy_Sheet.getRange('aa'+n).setFontColor('#38761D');}
- if (parseInt(All_recoilmagvariance[i]) > parseInt(Legacy_recoilmagvariance[i])){Legacy_Sheet.getRange('ab'+n).setFontColor('#38761D');}
- if (parseFloat(All_spreadalt[i]) > parseFloat(Legacy_spreadalt[i])){Legacy_Sheet.getRange('ad'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracycrouchalt[i]) > parseFloat(Legacy_inaccuracycrouchalt[i])){Legacy_Sheet.getRange('ae'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracystandalt[i]) > parseFloat(Legacy_inaccuracystandalt[i])){Legacy_Sheet.getRange('af'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracyfirealt[i]) > parseFloat(Legacy_inaccuracyfirealt[i])){Legacy_Sheet.getRange('ag'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracymovealt[i]) > parseFloat(Legacy_inaccuracymovealt[i])){Legacy_Sheet.getRange('ah'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracyjumpalt[i]) > parseFloat(Legacy_inaccuracyjumpalt[i])){Legacy_Sheet.getRange('ai'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracylandalt[i]) > parseFloat(Legacy_inaccuracylandalt[i])){Legacy_Sheet.getRange('aj'+n).setFontColor('#38761D');}
- if (parseFloat(All_inaccuracyladderalt[i]) > parseFloat(Legacy_inaccuracyladderalt[i])){Legacy_Sheet.getRange('ak'+n).setFontColor('#38761D');}
- if (All_recoilanglevariancealt[i] > Legacy_recoilanglevariancealt[i]){Legacy_Sheet.getRange('al'+n).setFontColor('#38761D');}
- if (All_recoilmagnitudealt[i] > Legacy_recoilmagnitudealt[i]){Legacy_Sheet.getRange('am'+n).setFontColor('#38761D');}
- if (All_recoilmagvariancealt[i] > Legacy_recoilmagvariancealt[i]){Legacy_Sheet.getRange('an'+n).setFontColor('#38761D');}
- if (parseFloat(All_armorratio[i]) < parseFloat(Legacy_armorratio[i])){Legacy_Sheet.getRange('b'+n).setFontColor('#38761D');}
- if (parseInt(All_damage[i]) < parseInt(Legacy_damage[i])){Legacy_Sheet.getRange('c'+n).setFontColor('#38761D');}
- if (parseFloat(All_rangemodifier[i]) < parseFloat(Legacy_rangemodifier[i])){Legacy_Sheet.getRange('d'+n).setFontColor('#38761D');}
- if (parseFloat(All_cycletime[i]) < parseFloat(Legacy_cycletime[i])){Legacy_Sheet.getRange('e'+n).setFontColor('#FF0000');}
- if (parseInt(All_penetration[i]) < parseInt(Legacy_penetration[i])){Legacy_Sheet.getRange('f'+n).setFontColor('#38761D');}
- if (parseInt(All_killaward[i]) < parseInt(Legacy_killaward[i])){Legacy_Sheet.getRange('g'+n).setFontColor('#38761D');}
- if (parseInt(All_maxplayerspeed[i]) < parseInt(Legacy_maxplayerspeed[i])){Legacy_Sheet.getRange('h'+n).setFontColor('#38761D');}
- if (parseInt(All_clip_size[i]) < parseInt(Legacy_clip_size[i])){Legacy_Sheet.getRange('i'+n).setFontColor('#38761D');}
- if (parseInt(All_weaponprice[i]) < parseInt(Legacy_weaponprice[i])){Legacy_Sheet.getRange('j'+n).setFontColor('#FF0000');}
- if (parseInt(All_range[i]) < parseInt(Legacy_range[i])){Legacy_Sheet.getRange('k'+n).setFontColor('#38761D');}
- if (parseInt(All_fullauto[i]) < parseInt(Legacy_fullauto[i])){Legacy_Sheet.getRange('l'+n).setFontColor('#000000');}
- if (parseFloat(All_flinchvelocitylarge[i]) < parseFloat(Legacy_flinchvelocitylarge[i])){Legacy_Sheet.getRange('m'+n).setFontColor('#FF0000');}
- if (parseFloat(All_flinchvelocitysmall[i]) < parseFloat(Legacy_flinchvelocitysmall[i])){Legacy_Sheet.getRange('n'+n).setFontColor('#FF0000');}
- if (parseFloat(All_spread[i]) < parseFloat(Legacy_spread[i])){Legacy_Sheet.getRange('p'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracycrouch[i]) < parseFloat(Legacy_inaccuracycrouch[i])){Legacy_Sheet.getRange('q'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracystand[i]) < parseFloat(Legacy_inaccuracystand[i])){Legacy_Sheet.getRange('r'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracyfire[i]) < parseFloat(Legacy_inaccuracyfire[i])){Legacy_Sheet.getRange('s'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracymove[i]) < parseFloat(Legacy_inaccuracymove[i])){Legacy_Sheet.getRange('t'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracyjump[i]) < parseFloat(Legacy_inaccuracyjump[i])){Legacy_Sheet.getRange('u'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracyland[i]) < parseFloat(Legacy_inaccuracyland[i])){Legacy_Sheet.getRange('v'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracyladder[i]) < parseFloat(Legacy_inaccuracyladder[i])){Legacy_Sheet.getRange('w'+n).setFontColor('#FF0000');}
- if (parseFloat(All_recoverytimecrouch[i]) < parseFloat(Legacy_recoverytimecrouch[i])){Legacy_Sheet.getRange('x'+n).setFontColor('#FF0000');}
- if (parseFloat(All_recoverytimestand[i]) < parseFloat(Legacy_recoverytimestand[i])){Legacy_Sheet.getRange('y'+n).setFontColor('#FF0000');}
- if (parseInt(All_recoilanglevariance[i]) < parseInt(Legacy_recoilanglevariance[i])){Legacy_Sheet.getRange('z'+n).setFontColor('#FF0000');}
- if (parseInt(All_recoilmagnitude[i]) < parseInt(Legacy_recoilmagnitude[i])){Legacy_Sheet.getRange('aa'+n).setFontColor('#FF0000');}
- if (parseInt(All_recoilmagvariance[i]) < parseInt(Legacy_recoilmagvariance[i])){Legacy_Sheet.getRange('ab'+n).setFontColor('#FF0000');}
- if (parseFloat(All_spreadalt[i]) < parseFloat(Legacy_spreadalt[i])){Legacy_Sheet.getRange('ad'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracycrouchalt[i]) < parseFloat(Legacy_inaccuracycrouchalt[i])){Legacy_Sheet.getRange('ae'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracystandalt[i]) < parseFloat(Legacy_inaccuracystandalt[i])){Legacy_Sheet.getRange('af'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracyfirealt[i]) < parseFloat(Legacy_inaccuracyfirealt[i])){Legacy_Sheet.getRange('ag'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracymovealt[i]) < parseFloat(Legacy_inaccuracymovealt[i])){Legacy_Sheet.getRange('ah'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracyjumpalt[i]) < parseFloat(Legacy_inaccuracyjumpalt[i])){Legacy_Sheet.getRange('ai'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracylandalt[i]) < parseFloat(Legacy_inaccuracylandalt[i])){Legacy_Sheet.getRange('aj'+n).setFontColor('#FF0000');}
- if (parseFloat(All_inaccuracyladderalt[i]) < parseFloat(Legacy_inaccuracyladderalt[i])){Legacy_Sheet.getRange('ak'+n).setFontColor('#FF0000');}
- if (parseInt(All_recoilanglevariancealt[i]) < parseInt(Legacy_recoilanglevariancealt[i])){Legacy_Sheet.getRange('al'+n).setFontColor('#FF0000');}
- if (parseInt(All_recoilmagnitudealt[i]) < parseInt(Legacy_recoilmagnitudealt[i])){Legacy_Sheet.getRange('am'+n).setFontColor('#FF0000');}
- if (parseInt(All_recoilmagvariancealt[i]) < parseInt(Legacy_recoilmagvariancealt[i])){Legacy_Sheet.getRange('an'+n).setFontColor('#FF0000');}
- if (parseFloat(All_armorratio[i]) == parseFloat(Legacy_armorratio[i])){Legacy_Sheet.getRange('b'+n).setFontColor('#000000');}
- if (parseInt(All_damage[i]) == parseInt(Legacy_damage[i])){Legacy_Sheet.getRange('c'+n).setFontColor('#000000');}
- if (parseFloat(All_rangemodifier[i]) == parseFloat(Legacy_rangemodifier[i])){Legacy_Sheet.getRange('d'+n).setFontColor('#000000');}
- if (parseFloat(All_cycletime[i]) == parseFloat(Legacy_cycletime[i])){Legacy_Sheet.getRange('e'+n).setFontColor('#000000');}
- if (parseInt(All_penetration[i]) == parseInt(Legacy_penetration[i])){Legacy_Sheet.getRange('f'+n).setFontColor('#000000');}
- if (parseInt(All_killaward[i]) == parseInt(Legacy_killaward[i])){Legacy_Sheet.getRange('g'+n).setFontColor('#000000');}
- if (parseInt(All_maxplayerspeed[i]) == parseInt(Legacy_maxplayerspeed[i])){Legacy_Sheet.getRange('h'+n).setFontColor('#000000');}
- if (parseInt(All_clip_size[i]) == parseInt(Legacy_clip_size[i])){Legacy_Sheet.getRange('i'+n).setFontColor('#000000');}
- if (parseInt(All_weaponprice[i]) == parseInt(Legacy_weaponprice[i])){Legacy_Sheet.getRange('j'+n).setFontColor('#000000');}
- if (parseInt(All_range[i]) === parseInt(Legacy_range[i])){Legacy_Sheet.getRange('k'+n).setFontColor('#000000');}
- if (parseInt(All_fullauto[i]) == parseInt(Legacy_fullauto[i])){Legacy_Sheet.getRange('l'+n).setFontColor('#000000');}
- if (parseFloat(All_flinchvelocitylarge[i]) == parseFloat(Legacy_flinchvelocitylarge[i])){Legacy_Sheet.getRange('m'+n).setFontColor('#000000');}
- if (parseFloat(All_flinchvelocitysmall[i]) == parseFloat(Legacy_flinchvelocitysmall[i])){Legacy_Sheet.getRange('n'+n).setFontColor('#000000');}
- if (parseFloat(All_spread[i]) == parseFloat(Legacy_spread[i])){Legacy_Sheet.getRange('p'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracycrouch[i]) == parseFloat(Legacy_inaccuracycrouch[i])){Legacy_Sheet.getRange('q'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracystand[i]) == parseFloat(Legacy_inaccuracystand[i])){Legacy_Sheet.getRange('r'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracyfire[i]) == parseFloat(Legacy_inaccuracyfire[i])){Legacy_Sheet.getRange('s'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracymove[i]) == parseFloat(Legacy_inaccuracymove[i])){Legacy_Sheet.getRange('t'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracyjump[i]) == parseFloat(Legacy_inaccuracyjump[i])){Legacy_Sheet.getRange('u'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracyland[i]) == parseFloat(Legacy_inaccuracyland[i])){Legacy_Sheet.getRange('v'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracyladder[i]) == parseFloat(Legacy_inaccuracyladder[i])){Legacy_Sheet.getRange('w'+n).setFontColor('#000000');}
- if (parseFloat(All_recoverytimecrouch[i]) == parseFloat(Legacy_recoverytimecrouch[i])){Legacy_Sheet.getRange('x'+n).setFontColor('#000000');}
- if (parseFloat(All_recoverytimestand[i]) == parseFloat(Legacy_recoverytimestand[i])){Legacy_Sheet.getRange('y'+n).setFontColor('#000000');}
- if (parseInt(All_recoilanglevariance[i]) == parseInt(Legacy_recoilanglevariance[i])){Legacy_Sheet.getRange('z'+n).setFontColor('#000000');}
- if (parseInt(All_recoilmagnitude[i]) == parseInt(Legacy_recoilmagnitude[i])){Legacy_Sheet.getRange('aa'+n).setFontColor('#000000');}
- if (parseInt(All_recoilmagvariance[i]) == parseInt(Legacy_recoilmagvariance[i])){Legacy_Sheet.getRange('ab'+n).setFontColor('#000000');}
- if (parseFloat(All_spreadalt[i]) == parseFloat(Legacy_spreadalt[i])){Legacy_Sheet.getRange('ad'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracycrouchalt[i]) == parseFloat(Legacy_inaccuracycrouchalt[i])){Legacy_Sheet.getRange('ae'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracystandalt[i]) == parseFloat(Legacy_inaccuracystandalt[i])){Legacy_Sheet.getRange('af'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracyfirealt[i]) == parseFloat(Legacy_inaccuracyfirealt[i])){Legacy_Sheet.getRange('ag'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracymovealt[i]) == parseFloat(Legacy_inaccuracymovealt[i])){Legacy_Sheet.getRange('ah'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracyjumpalt[i]) == parseFloat(Legacy_inaccuracyjumpalt[i])){Legacy_Sheet.getRange('ai'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracylandalt[i]) == parseFloat(Legacy_inaccuracylandalt[i])){Legacy_Sheet.getRange('aj'+n).setFontColor('#000000');}
- if (parseFloat(All_inaccuracyladderalt[i]) == parseFloat(Legacy_inaccuracyladderalt[i])){Legacy_Sheet.getRange('ak'+n).setFontColor('#000000');}
- if (parseInt(All_recoilanglevariancealt[i]) == parseInt(Legacy_recoilanglevariancealt[i])){Legacy_Sheet.getRange('al'+n).setFontColor('#000000');}
- if (parseInt(All_recoilmagnitudealt[i]) == parseInt(Legacy_recoilmagnitudealt[i])){Legacy_Sheet.getRange('am'+n).setFontColor('#000000');}
- if (parseInt(All_recoilmagvariancealt[i]) == parseInt(Legacy_recoilmagvariancealt[i])){Legacy_Sheet.getRange('an'+n).setFontColor('#000000');}
- }
- };
- /**
- * Adds a custom menu to the active spreadsheet, containing a single menu item
- * for invoking the readRows() function specified above.
- * The onOpen() function, when defined, is automatically invoked whenever the
- * spreadsheet is opened.
- * For more information on using the Spreadsheet API, see
- * https://developers.google.com/apps-script/service_spreadsheet
- */
- function onOpen() {
- var sheet = SpreadsheetApp.getActiveSpreadsheet();
- var entries = [{
- name : "Read Data",
- functionName : "readRows"
- }];
- sheet.addMenu("Script Center Menu", entries);
- };
Advertisement
Add Comment
Please, Sign In to add comment