function syncWithPublicSheet() 
  var public = SpreadsheetApp.openById("PUBLIC_SHEET_ID");
  var private = SpreadsheetApp.openById("PRIVATE_SHEET_ID");
  var publicData = public.getSheetByName("Arcs").getDataRange().getValues();
  private.getSheetByName("Arcs").clear();
  private.getSheetByName("Arcs").getRange(1,1,publicData.length,publicData[0].length).setValues(publicData);

One Pace Spreadsheet Better

Fans and researchers use these spreadsheets for various purposes:

Keep a local SQLite database or Airtable with: One Pace Spreadsheet BETTER

Sync it with the public sheet weekly using Google Apps Script: Fans and researchers use these spreadsheets for various

function syncWithPublicSheet() 
  var public = SpreadsheetApp.openById("PUBLIC_SHEET_ID");
  var private = SpreadsheetApp.openById("PRIVATE_SHEET_ID");
  var publicData = public.getSheetByName("Arcs").getDataRange().getValues();
  private.getSheetByName("Arcs").clear();
  private.getSheetByName("Arcs").getRange(1,1,publicData.length,publicData[0].length).setValues(publicData);

Trigger weekly → You now have a self-healing, personalized One Pace database. Sync it with the public sheet weekly using

---

The "One Pace Spreadsheet" is a tool created by fans for fans of the "One Piece" series. It is designed to track and analyze the bounty, also known as the "Wanted" or "Bounty" of characters throughout the series. The spreadsheet can contain detailed information about each character's known bounties, including the amount and the point in the storyline when it was issued or changed.