Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function CurrentValue(id) {
- /*
- if (typeof id != 'number') {
- return null;
- }
- */
- return 1000;
- }
- function DepreciationRate(code) {
- var spreadsheet = SpreadsheetApp.getActive();
- var categoriesSheet = spreadsheet.getSheetByName('Categorie');
- var i = 1;
- while (true) {
- var c = categoriesSheet.getRange(i, 1).getValue();
- if (!c) {
- return 0;
- }
- if (c==code) {
- return categoriesSheet.getRange(i, 3).getValue()
- }
- i++;
- }
- return 0;
- }
- // jsmacro2017
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement