function batchExtractPdfsFromFolder() {
  const folderId = "-------------------"; // Put your ID here
  const folder = DriveApp.getFolderById(folderId);
  const files = folder.getFilesByType(MimeType.PDF);
  const ss = SpreadsheetApp.getActiveSpreadsheet();


  while (files.hasNext()) {
    const file = files.next();
    Logger.log("Processing: " + file.getName());


    // 1. Create a new sheet tab for this file
    // We limit the name length to 30 chars (Sheets limit)
    let sheetName = file.getName().substring(0, 30);
    let sheet = ss.getSheetByName(sheetName) || ss.insertSheet(sheetName);
    sheet.clear(); // Clear existing data if sheet exists


    // 2. OCR Conversion (PDF to Temp Doc)
    const resource = {
      title: 'Temp_OCR_' + file.getName(),
      mimeType: file.getMimeType()
    };
    
    // Uses the Advanced Drive Service (ensure it is enabled in 'Services')
    const tempDocFile = Drive.Files.insert(resource, file.getBlob(), {ocr: true});
    
    // 3. Extract text from the temporary Doc
    const doc = DocumentApp.openById(tempDocFile.id);
    const textContent = doc.getBody().getText();
    
    // 4. Split text into rows and write to the sheet
    const rows = textContent.split('\n').map(row => [row]);
    if (rows.length > 0) {
      sheet.getRange(1, 1, rows.length, 1).setValues(rows);
    }


    // 5. Cleanup
    Drive.Files.remove(tempDocFile.id);
  }
  
  Logger.log("All files processed!");
}
___________________


function tidyAllAHKSheets() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheets = ss.getSheets();
  
  sheets.forEach(sheet => {
    const sheetName = sheet.getName();
    // Only process the raw year tabs (4 digits)
    if (sheetName.match(/^\d{4}$/)) {
      const targetName = sheetName + "b";
      let targetSheet = ss.getSheetByName(targetName);
      if (!targetSheet) {
        targetSheet = ss.insertSheet(targetName);
      }
      
      const range = sheet.getDataRange();
      const data = range.getValues();
      
      const cleanedData = data.map(row => {
        return row.map(cell => {
          // Convert everything to string for processing, then try to parse
          let val = String(cell).trim();
          if (val === "" || val === "-" || val === "null") return "";
          
          let isNegative = false;
          
          // Check for brackets: (1.000,00)
          if (val.indexOf('(') === 0 && val.indexOf(')') === (val.length - 1)) {
            isNegative = true;
            val = val.replace(/[\(\)]/g, '');
          } 
          // Check for standard minus sign
          else if (val.indexOf('-') === 0) {
            isNegative = true;
            val = val.substring(1);
          }
          
          // Tidy the number: Remove Greek thousands (.) and replace decimal (,) with (.)
          // We use a regex to remove all dots and then switch the comma.
          let numericCandidate = val.replace(/\./g, '').replace(',', '.');
          
          // Try to convert to a number
          let num = parseFloat(numericCandidate);
          
          // If it's a valid number and NOT just a year (like 2024), return formatted number
          // We check if it's a number and if the original string contained a comma or dot 
          // to avoid accidentally turning "Page 1" into "1"
          if (!isNaN(num) && /[\d,.]+/.test(val)) {
             return isNegative ? -num : num;
          }
          
          return cell; // Return original if it's text
        });
      });
      
      targetSheet.clear();
      targetSheet.getRange(1, 1, cleanedData.length, cleanedData[0].length).setValues(cleanedData);
      
      // Formatting the result
      const lastCol = targetSheet.getLastColumn();
      const lastRow = targetSheet.getLastRow();
      if (lastCol > 1) {
        targetSheet.getRange(1, 2, lastRow, lastCol - 1).setNumberFormat("#,##0.00");
      }
    }
  });
}