Advertisement
Guest User

Untitled

a guest
Jan 16th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQF 3.90 KB | None | 0 0
  1. span class="re5"> function Ausgaben(){
  2. var ss = SpreadsheetApp.getActiveSpreadsheet();
  3.  
  4.   var Main=ss.getSheetByName("Main");
  5.   var List=ss.getSheetByName("List");
  6.  
  7.   var DateCell = Main.getRange("A3");
  8.   var Werte1 = Main.getRange("A3:I3");
  9.   var Werte2 = Main.getRange("J3:M3");
  10.   var nextLineCell = List.getRange(408,2).getCell(1,1);
  11.   var nextLine = nextLineCell.getDisplayValue();
  12.   var nextRange1 = List.getRange(nextLine,1,1,9);
  13.   var nextRange2 = List.getRange(nextLine,27,1,4);
  14.  
  15.   var Datum = Werte1.getCell(1,1);
  16.   var Betreff = Werte1.getCell(1,2);
  17.   var Details = Werte1.getCell(1,3);
  18.   var Betrag = Werte1.getCell(1,4);
  19.   var Zahlender = Werte1.getCell(1,5);
  20.   var MussMaze = Werte1.getCell(1,6);
  21.   var MussSean = Werte1.getCell(1,7);
  22.   var MussHan = Werte1.getCell(1,8);
  23.   var MussChristian = Werte1.getCell(1,9);
  24.  
  25.   var hatMaze = Werte2.getCell(1,1);
  26.   var hatSean = Werte2.getCell(1,2);
  27.   var hatHan = Werte2.getCell(1,3);
  28.   var hatChristian = Werte2.getCell(1,4);
  29.  
  30.  
  31.   var nextValues1 = [[Datum.getValue(),Betreff.getValue(),Details.getValue(),Betrag.getValue(),Zahlender.getValue(),MussMaze.getValue(),MussSean.getValue(),MussHan.getValue(),MussChristian.getValue()]];
  32.   var nextValues2 = [[hatMaze.getValue(),hatSean.getValue(),hatHan.getValue(),hatChristian.getValue()]];
  33.  
  34.   var Eintrag1 = nextRange1.setValues(nextValues1);
  35.   var Eintrag2 = nextRange2.setValues(nextValues2);
  36.   var Back1 = Werte1.setValues([["","","","","","","","",""]]);
  37.   var Back2 = Werte2.setValues([["","","",""]]);
  38.   var Back3 = DateCell.setFormula("=today()");
  39.  
  40. }
  41.  
  42. function Rückzahlen(){
  43.  
  44. var ss = SpreadsheetApp.getActiveSpreadsheet();
  45.  
  46.   var Main=ss.getSheetByName("Main");
  47.   var List=ss.getSheetByName("List");
  48.  
  49.   var DateCell = Main.getRange("A7");
  50.   var DummyWerte = Main.getRange("A7:I7");
  51.   var Werte1 = List.getRange("A411:I411");
  52.   var nextLineCell = List.getRange(408,2).getCell(1,1);
  53.   var nextLine = nextLineCell.getDisplayValue();
  54.   var nextRange1 = List.getRange(nextLine,1,1,9);
  55.  
  56.   var Datum = Werte1.getCell(1,1);
  57.   var Betreff = Werte1.getCell(1,2);
  58.   var Details = Werte1.getCell(1,3);
  59.   var Betrag = Werte1.getCell(1,4);
  60.   var Zahlender = Werte1.getCell(1,5);
  61.   var MussMaze = Werte1.getCell(1,6);
  62.   var MussSean = Werte1.getCell(1,7);
  63.   var MussHan = Werte1.getCell(1,8);
  64.   var MussChristian = Werte1.getCell(1,9);
  65.  
  66.   var nextValues1 = [[Datum.getValue(),Betreff.getValue(),Details.getValue(),Betrag.getValue(),Zahlender.getValue(),MussMaze.getValue(),MussSean.getValue(),MussHan.getValue(),MussChristian.getValue()]];
  67.  
  68.   var Eintrag1 = nextRange1.setValues(nextValues1);
  69.   var Back1 = DummyWerte.setValues([["","Schuldenrückzahlung","","","","","","",""]]);
  70.   var Back3 = DateCell.setFormula("=today()");
  71.  
  72.  
  73.  
  74. }
  75.  
  76. function Einnahmen(){
  77.  
  78. var ss = SpreadsheetApp.getActiveSpreadsheet();
  79.  
  80.   var Main=ss.getSheetByName("Main");
  81.   var List=ss.getSheetByName("List");
  82.  
  83.   var DateCell = Main.getRange("A11");
  84.   var DummyWerte = Main.getRange("A11:I11");
  85.   var Werte1 = List.getRange("A413:I413");
  86.   var nextLineCell = List.getRange(408,2).getCell(1,1);
  87.   var nextLine = nextLineCell.getDisplayValue();
  88.   var nextRange1 = List.getRange(nextLine,1,1,9);
  89.  
  90.   var Datum = Werte1.getCell(1,1);
  91.   var Betreff = Werte1.getCell(1,2);
  92.   var Details = Werte1.getCell(1,3);
  93.   var Betrag = Werte1.getCell(1,4);
  94.   var Zahlender = Werte1.getCell(1,5);
  95.   var MussMaze = Werte1.getCell(1,6);
  96.   var MussSean = Werte1.getCell(1,7);
  97.   var MussHan = Werte1.getCell(1,8);
  98.   var MussChristian = Werte1.getCell(1,9);
  99.  
  100.   var nextValues1 = [[Datum.getValue(),Betreff.getValue(),Details.getValue(),Betrag.getValue(),Zahlender.getValue(),MussMaze.getValue(),MussSean.getValue(),MussHan.getValue(),MussChristian.getValue()]];
  101.  
  102.   var Eintrag1 = nextRange1.setValues(nextValues1);
  103.   var Back1 = DummyWerte.setValues([["","","","","","","","",""]]);
  104.   var Back3 = DateCell.setFormula("=today()");
  105.  
  106.  
  107.  
  108. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement