Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save adgooroo/61a9836522cc5d18a2a1bf21cba34657 to your computer and use it in GitHub Desktop.
Save adgooroo/61a9836522cc5d18a2a1bf21cba34657 to your computer and use it in GitHub Desktop.
Формула использует несколько функций TSM
max(min(dbmarket,ifgt(dbmarket,1.33*dbhistorical,dbhistorical,dbmarket),ifgt(dbhistorical,0,2*max(dbregionmarketavg,dbregionhistorical),max(dbregionmarketavg,dbregionhistorical)),iflte(max(dbregionmarketavg/dbregionhistorical,dbmarket/dbhistorical),0.99,min(max(dbrecent,(dbmarket/dbhistorical)*dbmarket),dbmarket)),20*dbregionsaleavg),vendorsell)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment