Advertisement
Guest User

iPad Storage Values

a guest
Jul 19th, 2018
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function myFunction() {
  2.   var sheet = SpreadsheetApp.getActiveSheet();
  3.   var data = sheet.getDataRange().getValues();
  4.   for (var i = 0; i < data.length; i++) {
  5.     if (data[i][7] < 16)
  6.     {
  7.       sheet.appendRow(['16 GB']);
  8.     }
  9.     else if (data[i][7] < 32)
  10.     {
  11.       sheet.appendRow(['32 GB']);
  12.     }
  13.     else if (data[i][7] < 64)
  14.     {
  15.       sheet.appendRow(['64 GB']);
  16.     }
  17.     else if (data[i][7] < 128)
  18.     {
  19.       sheet.appendRow(['128 GB']);
  20.     }
  21.     else if (data[i][7] < 256)
  22.     {
  23.       sheet.appendRow(['256 GB']);
  24.     }
  25.     else if (data[i][7] < 512)
  26.     {
  27.       sheet.appendRow(['512 GB']);
  28.     }
  29.     else if (data[i][7] < 1024)
  30.     {
  31.       sheet.appendRow(['1 TB']);
  32.     }
  33.     else
  34.     {
  35.       sheet.appendRow(['ERROR']);
  36.     }
  37.   }
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement