excel notes

md claude

  • VS Code (free) — open the file there and hit Cmd/Ctrl+Shift+V for a live markdown preview. Tables and formatting render cleanly.
  • Typora, Obsidian, or Mark Text — dedicated markdown editors that show it beautifully by default, no toggling needed.

  • Paste into Notion or Google Docs — both will auto-format markdown-ish text reasonably well (Notion especially, since it natively understands markdown).
    • orange دوشنبه 16 شهریور 1405 ساعت 07:34
    0 نظر

    فرمول درست

    =LET( lastRow, MAX(FILTER(ROW('Daily Report'!B:B), 'Daily Report'!B:B<>"")), _startRow, lastRow - 27, _numRows, 28, campaign,  CHOOSEROWS('Daily Report'!B:B, SEQUENCE(_numRows, 1, _startRow)), date,      CHOOSEROWS('Daily Report'!C:C, SEQUENCE(_numRows, 1, _startRow)), impression,CHOOSEROWS('Daily Report'!E:E, SEQUENCE(_numRows, 1, _startRow)), click,     CHOOSEROWS('Daily Report'!F:F, SEQUENCE(_numRows, 1, _startRow)), downloading,CHOOSEROWS('Daily Report'!G:G, SEQUENCE(_numRows, 1, _startRow)), downloaded,CHOOSEROWS('Daily Report'!H:H, SEQUENCE(_numRows, 1, _startRow)), install,   CHOOSEROWS('Daily Report'!I:I, SEQUENCE(_numRows, 1, _startRow)), panel_cpi, ARRAYFORMULA(IFS( campaign="Prime", 15000, campaign="SearchAds", 10000, campaign="SmartAds", 15000, campaign="SearchAds - Branded", 10000, TRUE, 0 )), cost, MAP(install, panel_cpi, LAMBDA(ins, cpi, ins * cpi)), cvr, MAP(install, impression, LAMBDA(ins, imp, IFERROR(ins / imp, 0))), data, HSTACK(campaign, date, cost, impression, click, downloading, downloaded, install, panel_cpi, cvr), data )

    orange شنبه 3 مرداد 1405 ساعت 10:57
    0 نظر

    این غلط کار میکرد و 31 تیر را نذاشته بود

    =LET( lastRow, MAX(FILTER(ROW('Daily Report'!B:B), 'Daily Report'!B:B<>"")), _startRow, lastRow - 27, _numRows, 28, campaign,  CHOOSEROWS('Daily Report'!B:B, SEQUENCE(_numRows, 1, _startRow)), date,      CHOOSEROWS('Daily Report'!C:C, SEQUENCE(_numRows, 1, _startRow)), impression,CHOOSEROWS('Daily Report'!E:E, SEQUENCE(_numRows, 1, _startRow)), click,     CHOOSEROWS('Daily Report'!F:F, SEQUENCE(_numRows, 1, _startRow)), downloading,CHOOSEROWS('Daily Report'!G:G, SEQUENCE(_numRows, 1, _startRow)), downloaded,CHOOSEROWS('Daily Report'!H:H, SEQUENCE(_numRows, 1, _startRow)), install,   CHOOSEROWS('Daily Report'!I:I, SEQUENCE(_numRows, 1, _startRow)), panel_cpi, ARRAYFORMULA(IFS( campaign="Prime", 15000, campaign="SearchAds", 10000, campaign="SmartAds", 15000, campaign="SearchAds - Branded", 10000, TRUE, 0 )), cost, MAP(install, panel_cpi, LAMBDA(ins, cpi, ins * cpi)), cvr, MAP(install, impression, LAMBDA(ins, imp, IFERROR(ins / imp, 0))), data, HSTACK(campaign, date, cost, impression, click, downloading, downloaded, install, panel_cpi, cvr), QUERY(data, "select *", 0) )

    orange شنبه 3 مرداد 1405 ساعت 10:51
    0 نظر

    24سطر اخیر -دکترتو

    =LET( lastRow, MAX(FILTER(ROW('Daily Report'!B:B), 'Daily Report'!B:B<>"")), _startRow, lastRow - 27, _numRows, 28, campaign,  CHOOSEROWS('Daily Report'!B:B, SEQUENCE(_numRows, 1, _startRow)), date,      CHOOSEROWS('Daily Report'!C:C, SEQUENCE(_numRows, 1, _startRow)), impression,CHOOSEROWS('Daily Report'!E:E, SEQUENCE(_numRows, 1, _startRow)), click,     CHOOSEROWS('Daily Report'!F:F, SEQUENCE(_numRows, 1, _startRow)), downloading,CHOOSEROWS('Daily Report'!G:G, SEQUENCE(_numRows, 1, _startRow)), downloaded,CHOOSEROWS('Daily Report'!H:H, SEQUENCE(_numRows, 1, _startRow)), install,   CHOOSEROWS('Daily Report'!I:I, SEQUENCE(_numRows, 1, _startRow)), panel_cpi, ARRAYFORMULA(IFS( campaign="Prime", 15000, campaign="SearchAds", 10000, campaign="SmartAds", 15000, campaign="SearchAds - Branded", 10000, TRUE, 0 )), cost, MAP(install, panel_cpi, LAMBDA(ins, cpi, ins * cpi)), cvr, MAP(install, impression, LAMBDA(ins, imp, IFERROR(ins / imp, 0))), data, HSTACK(campaign, date, cost, impression, click, downloading, downloaded, install, panel_cpi, cvr), QUERY(data, "select *", 0) )

    orange یکشنبه 28 تیر 1405 ساعت 11:15
    0 نظر

    124 سطر اخیر

    =LET(

      lastRow, MAX(FILTER(ROW('Daily Report'!B:B), 'Daily Report'!B:B<>"")),

      _numRows, 124,

      _startRow, lastRow - _numRows + 1,


      campaign, CHOOSEROWS('Daily Report'!B:B, SEQUENCE(_numRows, 1, _startRow)),

      date, CHOOSEROWS('Daily Report'!C:C, SEQUENCE(_numRows, 1, _startRow)),

      impression, CHOOSEROWS('Daily Report'!E:E, SEQUENCE(_numRows, 1, _startRow)),

      click, CHOOSEROWS('Daily Report'!F:F, SEQUENCE(_numRows, 1, _startRow)),

      downloading, CHOOSEROWS('Daily Report'!G:G, SEQUENCE(_numRows, 1, _startRow)),

      downloaded, CHOOSEROWS('Daily Report'!H:H, SEQUENCE(_numRows, 1, _startRow)),

      install, CHOOSEROWS('Daily Report'!I:I, SEQUENCE(_numRows, 1, _startRow)),


      panel_cpi,

        ARRAYFORMULA(

          IFS(

            campaign="Prime", 15000,

            campaign="SearchAds", 10000,

            campaign="SmartAds", 15000,

            campaign="SearchAds - Branded", 10000,

            TRUE, 0

          )

        ),


      cost, MAP(install, panel_cpi, LAMBDA(ins, cpi, ins * cpi)),

      cvr, MAP(install, impression, LAMBDA(ins, imp, IFERROR(ins / imp, 0))),


      data,

        HSTACK(

          campaign,

          date,

          cost,

          impression,

          click,

          downloading,

          downloaded,

          install,

          panel_cpi,

          cvr

        ),


      QUERY(data, "select *", 0)

    )

    orange یکشنبه 28 تیر 1405 ساعت 11:12
    0 نظر