{
  "author_attribution": "Marcus (anonymous, \u0027Public release of my fundamentals sheet\u0027, 2021)",
  "cross_sheet_dependencies": {
    "importrange_edges": [],
    "internal": [
      {
        "from": "fundamentals!B5",
        "occurrences": 14,
        "to": [
          "bs!C1",
          "cf!C1",
          "pl!C1",
          "is!C1",
          "profile!C1",
          "derived!C1",
          "derived!BH1"
        ],
        "via": "=UPPER(fundamentals!B5)"
      },
      {
        "from": "Setup!B23",
        "occurrences": 15,
        "to": [
          "bs!E1",
          "cf!E1",
          "pl!E1",
          "is!E1",
          "profile!E1",
          "derived!E1",
          "derived!BJ1",
          "diamondMining!E1"
        ],
        "via": "=Setup!B23"
      },
      {
        "from": "screener!B3",
        "to": [
          "diamondMining!C1"
        ],
        "via": "=UPPER(screener!B3)"
      },
      {
        "from": "profile!K3",
        "purpose": "CIK for SEC EDGAR deep links",
        "to": [
          "fundamentals!N1",
          "fundamentals!N3"
        ]
      }
    ]
  },
  "effort_rating": {
    "blockers": [],
    "estimated_writer_days": "2-3",
    "level": "medium",
    "rationale": "Clean cell topology, no IMPORTRANGE entanglements, lookup keys already match standardizer vocabulary, all live external endpoints (GOOGLEFINANCE, EDGAR, Google search) probe green. Work concentrated in one writer that pushes three standardizer DataFrames to a known cell grid.",
    "risks": [
      "secfsdstools field-name drift vs the FMP-style keys hard-coded in 514 VLOOKUPs - some may need a translation layer",
      "20-year history depth may exceed EDGAR coverage for some tickers (XBRL roughly 2009+)"
    ]
  },
  "error_count": 211,
  "external_dependencies": [
    {
      "endpoint": "fmpcloud.io/api/v3/balance-sheet-statement/",
      "replacement": "secfsdstools BalanceSheetStandardizer",
      "status": "dead_paid",
      "tab": "bs"
    },
    {
      "endpoint": "fmpcloud.io/api/v3/cash-flow-statement/",
      "replacement": "secfsdstools CashFlowStandardizer",
      "status": "dead_paid",
      "tab": "cf"
    },
    {
      "endpoint": "fmpcloud.io/api/v3/income-statement/",
      "replacement": "secfsdstools IncomeStatementStandardizer",
      "status": "dead_paid",
      "tab": "pl"
    },
    {
      "endpoint": "fmpcloud.io/api/v3/profile/",
      "replacement": "EDGAR submissions/CIK{cik}.json",
      "status": "dead_paid",
      "tab": "profile"
    },
    {
      "endpoint": "fmpcloud.io/api/v3/ratios/",
      "replacement": "compute locally from three standardizers",
      "status": "dead_paid",
      "tab": "derived"
    },
    {
      "endpoint": "financialmodelingprep.com/api/v3/income-statement/",
      "replacement": "secfsdstools IncomeStatementStandardizer",
      "status": "401",
      "tab": "is"
    },
    {
      "action": "keep",
      "endpoint": "sec.gov/cgi-bin/browse-edgar?CIK=",
      "status": "alive_200",
      "tab": "fundamentals"
    },
    {
      "action": "keep",
      "endpoint": "google.com/search?q=",
      "status": "alive",
      "tab": "fundamentals"
    },
    {
      "action": "keep_for_live_price_and_mktcap",
      "endpoint": "GOOGLEFINANCE",
      "status": "alive",
      "tab": "fundamentals"
    }
  ],
  "formula_count": 1826,
  "importrange_edges": 0,
  "name": "Copy of Public release of my fundamentals sheet",
  "named_ranges": 0,
  "purpose": "Single-ticker deep-fundamentals workbench: 20-year matrix of revenues, margins, balance-sheet quality, cash flows, DCF inputs, and ratio averages on a frozen-header summary tab, fed by hidden per-statement data tabs that fetch FMP endpoints.",
  "rehab_strategy": {
    "approach": "VPS Python writer pushes standardizer DataFrames directly into bs/pl/cf/derived/profile data tabs via Sheets API, replacing the dead IMPORTDATA chain. Existing lookup-key cell topology is preserved verbatim.",
    "edge_cases": [
      "is tab uses ImportJSON custom function; either feed it from same writer or repoint fundamentals!E7 lookup to pl (which also has weighted shares)",
      "diamondMining is screener-driven (screener!B3, separate ticker) - same fix, lower priority",
      "bs has six IMPORTHTML peer-comp tables at row 124 (cols Q/AG/AX/BO/CF/CW) - separate, optional",
      "dividendsPaid sign convention: FMP returns negative, sheet flips with *-1; secfsdstools also negative - keep the flip"
    ],
    "tabs_to_keep_live": [
      "GOOGLEFINANCE quote/name in fundamentals!B1:C3",
      "SEC EDGAR deep links fundamentals!N1/N3",
      "OpenInsider/SeekingAlpha/Nasdaq/TradingView link tiles"
    ],
    "tabs_to_rewrite_writer_side": [
      "bs",
      "pl",
      "cf",
      "is",
      "profile",
      "derived",
      "diamondMining"
    ],
    "writer_steps": [
      "Read fundamentals!B5 ticker, resolve to CIK via EDGAR ticker.txt",
      "Pull BalanceSheet, IncomeStatement, CashFlow standardizer DataFrames (annual + quarter)",
      "Compute simpleFreeCashFlow = operatingCashFlow + capitalExpenditure",
      "Compute derived ratios (bookValuePerShare, tangibleBookValuePerShare, roic, per-share metrics)",
      "Pull EDGAR submissions JSON for profile (CIK, sector via SIC code, description)",
      "Reshape each into wide year-across-columns layout matching the row-keyed VLOOKUP/HLOOKUP expectations",
      "Push to bs!A2:, pl!A2:, cf!A2:, derived!A2:, profile!A2: via Sheets API",
      "Delete the dead IMPORTDATA/ImportJSON formulas in row 2 of each data tab so refresh doesn\u0027t overwrite",
      "Leave Setup!B23 empty; remove API-key UI prompt"
    ]
  },
  "secfsdstools_mapping": {
    "BalanceSheetStandardizer": {
      "fields": {
        "cashAndCashEquivalents": "fundamentals!E23/E24",
        "shortTermDebt": "fundamentals!E24",
        "shortTermInvestments": "fundamentals!E23/E24",
        "totalAssets": "fundamentals!E22:X22",
        "totalCurrentAssets": "fundamentals!E23 (current-ratio test)",
        "totalCurrentLiabilities": "fundamentals!E23",
        "totalNonCurrentLiabilities": "fundamentals!E24 (Net Common Overhang)"
      },
      "target_tab": "bs"
    },
    "CashFlowStandardizer": {
      "fields": {
        "acquisitionsNet": "fundamentals!E46",
        "date": "header",
        "dividendsPaid": "fundamentals!E31 (sign-flipped *-1 in cell)",
        "netCashFlow": "fundamentals!E47",
        "operatingCashFlow": "fundamentals!E12 (CFO Avg3)",
        "simpleFreeCashFlow": "fundamentals!E43 - NOT NATIVE; compute writer-side as operatingCashFlow + capitalExpenditure"
      },
      "target_tab": "cf"
    },
    "IncomeStatementStandardizer": {
      "fields": {
        "EBITDA": "fundamentals!E33",
        "EPS": "fundamentals!E36",
        "Weightedaverageshsout": "fundamentals!E7:X7 (drop the LEFT/LEN-6 peel since standardizer outputs numeric)",
        "date": "fundamentals!E5:X5 (year header)",
        "grossProfit": "fundamentals!row 11/15",
        "grossProfitMargin": "fundamentals row 11",
        "revenue": "fundamentals!E8:X8"
      },
      "target_tab": "pl"
    },
    "computed_locally": {
      "fields": {
        "bookValuePerShare": "fundamentals!E25 - equity/shares",
        "per_share_metrics": "Revs/sh, Assets/sh, etc - divide by Weightedaverageshsout",
        "roic": "fundamentals!E13 - NOPAT/invested_capital",
        "tangibleBookValuePerShare": "fundamentals!E26 - (equity - intangibles)/shares"
      },
      "target_tab": "derived"
    },
    "edgar_submissions_json": {
      "fields": {
        "CIK": "profile!K3 (drives SEC EDGAR deep links at fundamentals!N1/N3)",
        "description": "fundamentals!D4",
        "sector": "fundamentals!B7"
      },
      "target_tab": "profile"
    }
  },
  "sheet_id": "1Nwb6PdSA-sojVcpsAOwLi-0oVbhF3i6MO4Juo6G-wDg",
  "slug": "marcus_fundamentals",
  "tab_count": 10,
  "tabs": {
    "Setup": {
      "errors": 0,
      "formulas": 0,
      "notes": "API key slot at B23 wired into every data tab via Setup!B23. Empty in this copy.",
      "role": "config",
      "rows": 26
    },
    "bs": {
      "errors": 9,
      "formulas": 409,
      "hidden": true,
      "role": "data_feed_balance_sheet",
      "rows": 200,
      "source": "fmpcloud.io/api/v3/balance-sheet-statement; also IMPORTHTML peer tables at row 124"
    },
    "cf": {
      "errors": 74,
      "formulas": 227,
      "hidden": true,
      "role": "data_feed_cash_flow",
      "rows": 94,
      "source": "fmpcloud.io/api/v3/cash-flow-statement"
    },
    "derived": {
      "errors": 7,
      "formulas": 22,
      "hidden": true,
      "role": "data_feed_ratios",
      "rows": 621,
      "source": "fmpcloud.io/api/v3/ratios"
    },
    "diamondMining": {
      "errors": 4,
      "formulas": 134,
      "hidden": true,
      "role": "data_feed_peer",
      "rows": 355,
      "source": "fmpcloud.io/api/v3/cash-flow-statement quarter"
    },
    "fundamentals": {
      "conditional_formats": 235,
      "errors": 78,
      "formulas": 964,
      "frozen_cols": 3,
      "frozen_rows": 8,
      "notes": "User-facing tab. B5 = ticker. Columns E:X = 20 historical years. Rows 7-48 = lookup-driven metrics.",
      "role": "summary_dashboard",
      "rows": 49
    },
    "is": {
      "errors": 1,
      "formulas": 4,
      "hidden": true,
      "role": "data_feed_income_statement_v2",
      "rows": 53,
      "source": "financialmodelingprep.com/api/v3/income-statement via ImportJSON (custom Apps Script, missing)"
    },
    "pl": {
      "errors": 34,
      "formulas": 55,
      "hidden": true,
      "role": "data_feed_income_statement",
      "rows": 87,
      "source": "fmpcloud.io/api/v3/income-statement"
    },
    "profile": {
      "errors": 1,
      "formulas": 4,
      "hidden": true,
      "role": "data_feed_company_profile",
      "rows": 3,
      "source": "fmpcloud.io/api/v3/profile; populates K3=CIK used by SEC EDGAR deep links"
    },
    "screener": {
      "errors": 3,
      "formulas": 7,
      "notes": "B3 = ticker for diamondMining peer feed.",
      "role": "secondary_input",
      "rows": 3
    }
  },
  "what_broken": [
    "All fmpcloud.io and financialmodelingprep.com IMPORTDATA calls dead - confirmed 401 Unauthorized in url_probe (paid-only since 2023)",
    "Setup!B23 API key slot empty in this copy",
    "is!A2 uses =ImportJSON which is a custom Apps Script not present in this copy",
    "211 error cells, all downstream of dead source feeds",
    "fundamentals!AE7:AF20 (3yr AVERAGE/STDEV columns) all #DIV/0! due to empty source rows",
    "1359 formulas evaluate to empty string - data-starved, not logic-broken"
  ],
  "what_works": [
    "GOOGLEFINANCE quote/name calls (9 occurrences) - alive",
    "Link tiles in fundamentals!1:3 - SEC EDGAR endpoint probed alive (200), Google search alive",
    "Formula discipline: 1311 IFERROR wrappers cause graceful degradation",
    "Lookup keys (revenue, totalAssets, bookValuePerShare, operatingCashFlow, EBITDA, EPS, etc.) already match GAAP/standardizer vocabulary",
    "Cell topology and 20-year column layout are clean and consistent across data tabs"
  ]
}