Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /** @OnlyCurrentDoc */
- function reset_Azshara() {
- var spreadsheet = SpreadsheetApp.getActive();
- spreadsheet.getRange('C6:C17').activate();
- spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
- spreadsheet.getRange('G6:G17').activate();
- spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
- spreadsheet.getRange('D24').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D25').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D26').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D27').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D29').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D31').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D29').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D32').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D33').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D34').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D35').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D36').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D37').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D38').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D40').activate();
- spreadsheet.getCurrentCell().setValue('FALSE')
- .setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D41').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- };
- function ResetAzsharaSheet() {
- var spreadsheet = SpreadsheetApp.getActive();
- spreadsheet.getRange('C6:C17').activate();
- spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
- spreadsheet.getRange('F6:H17').activate();
- spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
- spreadsheet.getRange('J6:Q17').activate();
- spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
- spreadsheet.getRange('D22').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D23').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D24').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D25').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D26').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D27').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D29').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D30').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D31').activate();
- spreadsheet.getCurrentCell().setValue('FALSE')
- .setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D32').activate();
- spreadsheet.getCurrentCell().setValue('FALSE');
- spreadsheet.getRange('D33').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D34').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D35').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D36').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D38').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- spreadsheet.getRange('D39').activate();
- spreadsheet.getCurrentCell().setValue('TRUE')
- .setValue('FALSE');
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement