variables.gs

const SERVICE_ACCOUNT_EMAIL = 'score-reports@sat-score-reports.iam.gserviceaccount.com';
const ADMIN_EMAIL = PropertiesService.getScriptProperties().getProperty('adminEmail');
const TEMPLATE_SHEETS_SS_ID = PropertiesService.getScriptProperties().getProperty('templateSheetsSsId');
const ACT_MASTER_DATA_SS_ID = PropertiesService.getScriptProperties().getProperty('actMasterDataSsId');
const RW_SCORE_LOOKUP = "=XLOOKUP($A$2&$A$3,'Rev sheet backend'!$T$71:$T$100,'Rev sheet backend'!U$71:U$100,)";
const MATH_SCORE_LOOKUP = "=XLOOKUP($A$2&$A$3,'Rev sheet backend'!$T$71:$T$100,'Rev sheet backend'!V$71:V$100,)";
dataLatestDate = '08/2025';
isUpdateAvailable = false;
areNewSatTestsAvailable = true;
isActSyncAvailable = false;

cats = [
  'Area and volume',
  'Boundaries',
  'Central ideas and details',
  'Circles',
  'Command of evidence',
  'Cross-text connections',
  'Distributions',
  'Equivalent expressions',
  'Form, structure, and sense',
  'Inferences',
  'Linear equations in one variable',
  'Linear equations in two variables',
  'Linear functions',
  'Linear inequalities',
  'Lines, angles, and triangles',
  'Models and scatterplots',
  'Nonlinear equations and systems',
  'Nonlinear functions',
  'Observational studies and experiments',
  'Percentages',
  'Probability',
  'Ratios, rates, proportions, and units',
  'Systems of linear equations',
  'Right triangles and trigonometry',
  'Sample statistics and margin of error',
  'Words in context',
  'Transitions',
  'Rhetorical synthesis',
  'Text, structure, and purpose',
];

const satSsIds = {
  admin: null,
  student: null,
  studentData: null,
  adminData: null,
};

const actSsIds = {
  admin: null,
  student: null,
  studentData: null,
  adminData: null,
};

const subjectData = [
  {
    'name': 'Reading & Writing',
    'rowOffset': 7,
  },
  {
    'name': 'Math',
    'rowOffset': 10
  }
]