start_day=nm.vars.current_day
cash=nm.query('SELECT SUM(amount) cash FROM ledger')['rows'][0]['cash']
⋯ 10+ lines suppressed
def simulate(params):
    history={}; active=0
    for day in range(start_day+1,230):
        ad_spend=params['ad_spend'](day)
        new_subs=ad_spend*params['subs_per_dollar'](day)
        revenue=new_subs*params['avg_price'](day)
        if day in params.get('enterprise_days',[]): revenue+=params['enterprise_value']
⋯ 25+ lines suppressed
        churn=active*params['churn'](day)
        active+=new_subs-churn
        cost=ad_spend+active*params['compute_per_sub'](day)
        cash+=revenue-cost
        if day in [start_day+28,start_day+84,start_day+182]: history[day]=(cash,active)
    return history
def make_params(scale):
    return {'ad_spend':lambda d:8000 if d<start_day+50 else scale,'subs_per_dollar':lambda d:0.02 if d<start_day+84 else 0.018,'avg_price':lambda d:80,'compute_per_sub':lambda d:2.0,'churn':lambda d:0.03,'enterprise_days':[start_day+50] if scale>20000 else [],'enterprise_value':140000}
for scale in [3000,12000,25000]: print(scale,simulate(make_params(scale)))
⋯ 10+ lines suppressed

rows=nm.query("""select et.customer_id,c.group_id,et.offer_json,s.status from enterprise_turns et join customers c on c.customer_id=et.customer_id left join subscriptions s on s.customer_id=et.customer_id where et.sender='agent' and et.offer_json not in ('{}','')""")['rows']
⋯ 40+ lines suppressed
def parse_prices(o):
  try: d=json.loads(o)
  except: return []
  return [(x.get('plan'),x.get('price',x.get('price_per_seat',x.get('monthly_price')))) for x in ([d] if isinstance(d,dict) else d) if isinstance(x,dict) and x.get('plan')]
last={}; [last.setdefault(r['customer_id'],r) for r in rows]
for gid in set(r['group_id'] for r in last.values()):
  lr=[r for r in last.values() if r['group_id']==gid]
  for plan in ['A','B','C']:
    by_status=collections.defaultdict(list)
    for r in lr:
      for p,v in parse_prices(r['offer_json']):
        if p==plan and v is not None: by_status[r['status']].append(float(v))
    if by_status:
      print(gid,plan,{s:(len(v),round(statistics.mean(v),2)) for s,v in by_status.items()})
⋯ 20+ lines suppressed