Advertisement
Guest User

Untitled

a guest
May 13th, 2019
246
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.20 KB | None | 0 0
  1. function myFunction() {
  2. var ss = SpreadsheetApp.getActiveSpreadsheet();
  3. var sheet1 = ss.getSheetByName("Character Sheet");
  4. var sheet2 = ss.getSheetByName("Marauder Abilities");
  5. var sheet3 = ss.getSheetByName("Warrior Abilities");
  6. var sheet4 = ss.getSheetByName("Dark Knight");
  7. var sheet5 = ss.getSheetByName("Gladiator");
  8. var sheet6 = ss.getSheetByName("Paladin");
  9. var sheet7 = ss.getSheetByName("Conjurer");
  10. var sheet8 = ss.getSheetByName("White Mage");
  11. var sheet9 = ss.getSheetByName("Arcanist");
  12. var sheet10 = ss.getSheetByName("Scholar");
  13. var sheet11 = ss.getSheetByName("Astrologian");
  14. var sheet12 = ss.getSheetByName("Pugilist");
  15. var sheet13 = ss.getSheetByName("Monk");
  16. var sheet14 = ss.getSheetByName("Lancer");
  17. var sheet15 = ss.getSheetByName("Dragoon");
  18. var sheet16 = ss.getSheetByName("Rogue");
  19. var sheet17 = ss.getSheetByName("Ninja");
  20. var sheet18 = ss.getSheetByName("Samurai");
  21. var sheet19 = ss.getSheetByName("Archer");
  22. var sheet20 = ss.getSheetByName("Bard");
  23. var sheet21 = ss.getSheetByName("Machinist");
  24. var sheet22 = ss.getSheetByName("Summoner");
  25. var sheet23 = ss.getSheetByName("Thaumaturge");
  26. var sheet24 = ss.getSheetByName("Black Mage");
  27. var sheet25 = ss.getSheetByName("Red Mage");
  28. var sheet26 = ss.getSheetByName("Garlean Pureblood");
  29.  
  30. var cell1 = sheet1.getRange('B5');
  31. var cell2 = sheet1.getRange('C5');
  32. var cell3 = sheet1.getRange('D5');
  33.  
  34. if (cell1.getValue() != "Marauder"||cell2.getValue() != "Marauder"||cell3.getValue() != "Marauder") {
  35. sheet2.hideSheet();
  36. }
  37.  
  38. if (cell1.getValue() == "Marauder"||cell2.getValue() == "Marauder"||cell3.getValue() == "Marauder") {
  39. sheet2.showSheet();
  40. }
  41.  
  42. if (cell1.getValue() != "Warrior"||cell2.getValue() != "Warrior"||cell3.getValue() != "Warrior") {
  43. sheet3.hideSheet();
  44. }
  45.  
  46. if (cell1.getValue() == "Warrior"||cell2.getValue() == "Warrior"||cell3.getValue() == "Warrior") {
  47. sheet3.showSheet();
  48. }
  49.  
  50. if (cell1.getValue() != "Dark Knight"||cell2.getValue() != "Dark Knight"||cell3.getValue() != "Dark Knight") {
  51. sheet4.hideSheet();
  52. }
  53.  
  54. if (cell1.getValue() == "Dark Knight"||cell2.getValue() == "Dark Knight"||cell3.getValue() == "Dark Knight") {
  55. sheet4.showSheet();
  56. }
  57.  
  58. if (cell1.getValue() != "Gladiator"||cell2.getValue() != "Gladiator"||cell3.getValue() != "Gladiator") {
  59. sheet5.hideSheet();
  60. }
  61.  
  62. if (cell1.getValue() == "Gladiator"||cell2.getValue() == "Gladiator"||cell3.getValue() == "Gladiator") {
  63. sheet5.showSheet();
  64. }
  65.  
  66. if (cell1.getValue() != "Paladin"||cell2.getValue() != "Paladin"||cell3.getValue() != "Paladin") {
  67. sheet6.hideSheet();
  68. }
  69.  
  70. if (cell1.getValue() == "Paladin"||cell2.getValue() == "Paladin"||cell3.getValue() == "Paladin") {
  71. sheet6.showSheet();
  72. }
  73.  
  74. if (cell1.getValue() != "Conjurer"||cell2.getValue() != "Conjurer"||cell3.getValue() != "Conjurer") {
  75. sheet7.hideSheet();
  76. }
  77.  
  78. if (cell1.getValue() == "Conjurer"||cell2.getValue() == "Conjurer"||cell3.getValue() == "Conjurer") {
  79. sheet7.showSheet();
  80. }
  81.  
  82. if (cell1.getValue() != "White Mage"||cell2.getValue() != "White Mage"||cell3.getValue() != "White Mage") {
  83. sheet8.hideSheet();
  84. }
  85.  
  86. if (cell1.getValue() == "White Mage"||cell2.getValue() == "White Mage"||cell3.getValue() == "White Mage") {
  87. sheet8.showSheet();
  88. }
  89.  
  90. if (cell1.getValue() != "Arcanist"||cell2.getValue() != "Arcanist"||cell3.getValue() != "Arcanist") {
  91. sheet9.hideSheet();
  92. }
  93.  
  94. if (cell1.getValue() == "Arcanist"||cell2.getValue() == "Arcanist"||cell3.getValue() == "Arcanist") {
  95. sheet9.showSheet();
  96. }
  97.  
  98. if (cell1.getValue() != "Scholar"||cell2.getValue() != "Scholar"||cell3.getValue() != "Scholar") {
  99. sheet10.hideSheet();
  100. }
  101.  
  102. if (cell1.getValue() == "Scholar"||cell2.getValue() == "Scholar"||cell3.getValue() == "Scholar") {
  103. sheet10.showSheet();
  104. }
  105.  
  106. if (cell1.getValue() != "Astrologian"||cell2.getValue() != "Astrologian"||cell3.getValue() != "Astrologian") {
  107. sheet11.hideSheet();
  108. }
  109.  
  110. if (cell1.getValue() == "Astrologian"||cell2.getValue() == "Astrologian"||cell3.getValue() == "Astrologian") {
  111. sheet11.showSheet();
  112. }
  113.  
  114. if (cell1.getValue() != "Pugilist"||cell2.getValue() != "Pugilist"||cell3.getValue() != "Pugilist") {
  115. sheet12.hideSheet();
  116. }
  117.  
  118. if (cell1.getValue() == "Pugilist"||cell2.getValue() == "Pugilist"||cell3.getValue() == "Pugilist") {
  119. sheet12.showSheet();
  120. }
  121.  
  122. if (cell1.getValue() != "Monk"||cell2.getValue() != "Monk"||cell3.getValue() != "Monk") {
  123. sheet13.hideSheet();
  124. }
  125.  
  126. if (cell1.getValue() == "Monk"||cell2.getValue() == "Monk"||cell3.getValue() == "Monk") {
  127. sheet13.showSheet();
  128. }
  129.  
  130. if (cell1.getValue() != "Lancer"||cell2.getValue() != "Lancer"||cell3.getValue() != "Lancer") {
  131. sheet14.hideSheet();
  132. }
  133.  
  134. if (cell1.getValue() == "Lancer"||cell2.getValue() == "Lancer"||cell3.getValue() == "Lancer") {
  135. sheet14.showSheet();
  136. }
  137.  
  138. if (cell1.getValue() != "Dragoon"||cell2.getValue() != "Dragoon"||cell3.getValue() != "Dragoon") {
  139. sheet15.hideSheet();
  140. }
  141.  
  142. if (cell1.getValue() == "Dragoon"||cell2.getValue() == "Dragoon"||cell3.getValue() == "Dragoon") {
  143. sheet15.showSheet();
  144. }
  145.  
  146. if (cell1.getValue() != "Rogue"||cell2.getValue() != "Rogue"||cell3.getValue() != "Rogue") {
  147. sheet16.hideSheet();
  148. }
  149.  
  150. if (cell1.getValue() == "Rogue"||cell2.getValue() == "Rogue"||cell3.getValue() == "Rogue") {
  151. sheet16.showSheet();
  152. }
  153.  
  154. if (cell1.getValue() != "Ninja"||cell2.getValue() != "Ninja"||cell3.getValue() != "Ninja") {
  155. sheet17.hideSheet();
  156. }
  157.  
  158. if (cell1.getValue() == "Ninja"||cell2.getValue() == "Ninja"||cell3.getValue() == "Ninja") {
  159. sheet17.showSheet();
  160. }
  161.  
  162. if (cell1.getValue() != "Samurai"||cell2.getValue() != "Samurai"||cell3.getValue() != "Samurai") {
  163. sheet18.hideSheet();
  164. }
  165.  
  166. if (cell1.getValue() == "Samurai"||cell2.getValue() == "Samurai"||cell3.getValue() == "Samurai") {
  167. sheet18.showSheet();
  168. }
  169.  
  170. if (cell1.getValue() != "Archer"||cell2.getValue() != "Archer"||cell3.getValue() != "Archer") {
  171. sheet19.hideSheet();
  172. }
  173.  
  174. if (cell1.getValue() == "Archer"||cell2.getValue() == "Archer"||cell3.getValue() == "Archer") {
  175. sheet19.showSheet();
  176. }
  177.  
  178. if (cell1.getValue() != "Bard"||cell2.getValue() != "Bard"||cell3.getValue() != "Bard") {
  179. sheet20.hideSheet();
  180. }
  181.  
  182. if (cell1.getValue() == "Bard"||cell2.getValue() == "Bard"||cell3.getValue() == "Bard") {
  183. sheet20.showSheet();
  184. }
  185.  
  186. if (cell1.getValue() != "Machinist"||cell2.getValue() != "Machinist"||cell3.getValue() != "Machinist") {
  187. sheet21.hideSheet();
  188. }
  189.  
  190. if (cell1.getValue() == "Machinist"||cell2.getValue() == "Machinist"||cell3.getValue() == "Machinist") {
  191. sheet21.showSheet();
  192. }
  193.  
  194. if (cell1.getValue() != "Summoner"||cell2.getValue() != "Summoner"||cell3.getValue() != "Summoner") {
  195. sheet22.hideSheet();
  196. }
  197.  
  198. if (cell1.getValue() == "Summoner"||cell2.getValue() == "Summoner"||cell3.getValue() == "Summoner") {
  199. sheet22.showSheet();
  200. }
  201.  
  202. if (cell1.getValue() != "Thaumaturge"||cell2.getValue() != "Thaumaturge"||cell3.getValue() != "Thaumaturge") {
  203. sheet23.hideSheet();
  204. }
  205.  
  206. if (cell1.getValue() == "Thaumaturge"||cell2.getValue() == "Thaumaturge"||cell3.getValue() == "Thaumaturge") {
  207. sheet23.showSheet();
  208. }
  209.  
  210. if (cell1.getValue() != "Black Mage"||cell2.getValue() != "Black Mage"||cell3.getValue() != "Black Mage") {
  211. sheet24.hideSheet();
  212. }
  213.  
  214. if (cell1.getValue() == "Black Mage"||cell2.getValue() == "Black Mage"||cell3.getValue() == "Black Mage") {
  215. sheet24.showSheet();
  216. }
  217.  
  218. if (cell1.getValue() != "Red Mage"||cell2.getValue() != "Red Mage"||cell3.getValue() != "Red Mage") {
  219. sheet25.hideSheet();
  220. }
  221.  
  222. if (cell1.getValue() == "Red Mage"||cell2.getValue() == "Red Mage"||cell3.getValue() == "Red Mage") {
  223. sheet25.showSheet();
  224. }
  225.  
  226. if (cell1.getValue() != "Garlean"||cell2.getValue() != "Garlean"||cell3.getValue() != "Garlean") {
  227. sheet26.hideSheet();
  228. }
  229.  
  230. if (cell1.getValue() == "Garlean"||cell2.getValue() == "Garlean"||cell3.getValue() == "Garlean") {
  231. sheet26.showSheet();
  232. }
  233.  
  234. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement