| · APPLIED COMPUTE · WORKBOOK ·
Excel model, rendered
The supplied configurator workbook, shown as it is saved: 4 sheets, 1,680 cells, 377 formulas. The equations are written out below, and a parity table checks every output the tool reproduces against the workbook for the default deal.
How the workbook is laid out
- 01 Deal Setup. The inputs. Shaded cells are the only things to change: customer, model, cycles, throughput, costs, price, margin and the three approval gates.
- 02 Economics Capacity. All calculations. Rows 4–28 turn tokens into GPU-hours; rows 31–47 are the week-by-week capacity grid; rows 52–70 compare buying options; rows 73–85 are cost; rows 91–104 are price, margin and the status gate; rows 111–125 are optional production.
- 03 Offer and SOW. The customer-facing offer and SOW wording that the tool reproduces in its proposal and SOW documents.
- 04 Guide Assumptions. The guide and the assumption sources. The tool shows each input’s meaning and its workbook cell.
The equations, in order
Read top to bottom: each step uses the one before it. The formula column is the exact text saved in the workbook; the value column is what the workbook shows for the default deal.
| Step and meaning | Cell | Workbook formula | Saved value |
|---|---|---|---|
| Training GPU-hours Tokens the policy update needs, divided by what one GPU does per hour (throughput × proxy factor). |
02 Economics Capacity!B18 |
=IF('01 Deal Setup'!B43<=0,0,B13/('01 Deal Setup'!B43*B6)) | 1,280 |
| Total workload GPU-hours Policy, rollout and evaluation GPU-hours added together across all approved cycles. |
02 Economics Capacity!B21 |
=SUM(B18:B20) | 3,360 |
| Wall-clock hours per cycle Concurrent jobs overlap, so the slower of trainer or rollout sets the pace. Evaluation is always added on top. |
02 Economics Capacity!B27 |
=IF('01 Deal Setup'!B14="Concurrent",MAX(B22/B7,B23/B8),B22/B7+B23/B8)+B24/B9 | 143.3333 |
| Total programme weeks Readiness, plus one cadence block per cycle, plus handoff. |
02 Economics Capacity!B28 |
='01 Deal Setup'!B12+'01 Deal Setup'!B10*'01 Deal Setup'!B11+'01 Deal Setup'!B13 | 6 |
| Cheapest way to buy missing GPUs The lowest of the three quotes: pay-as-you-go, a one-week extension, or a new reservation. |
02 Economics Capacity!B61 |
=MIN(B58:B60) | 0 |
| Base delivery cost Engineering, graders, storage, platform and GPU compute, summed before rework. |
02 Economics Capacity!B82 |
=SUM(B77:B81) | 96,900 |
| Delivery COGS including rework Base cost plus the rework allowance (a percentage of base cost). This is the internal cost the price must cover. |
02 Economics Capacity!B84 |
=SUM(B82:B83) | 106,590 |
| RL cycle fee Cycles approved × fee per cycle × size-class factor (0.65× small, 1× standard, 2.5× large). |
02 Economics Capacity!B93 |
=B10*'01 Deal Setup'!B70*IF('01 Deal Setup'!$G$31=1,0.65,IF('01 Deal Setup'!$G$31=2,1,2.5)) | 72,000 |
| Margin-floor price COGS ÷ (1 − target margin). If the itemised price is below this, the workbook adds an adjustment (B99); the tool folds it into the phase fees. |
02 Economics Capacity!B98 |
=B84/MAX(0.01,1-'01 Deal Setup'!B76) | 193,800 |
| Quote Itemised price plus any margin-floor adjustment. This is the number the customer sees, split by phase. |
02 Economics Capacity!B100 |
=SUM(B97,B99) | 210,000 |
| Gross margin 1 − COGS ÷ quote. |
02 Economics Capacity!B101 |
=IF(B100=0,0,1-B84/B100) | 0.4924 |
| Status gate HOLD if an input is missing, the model is unverified, capacity is infeasible, the budget is exceeded or margin is under the floor. READY FOR REVIEW only when every check passes. |
02 Economics Capacity!B104 |
=IF(OR('01 Deal Setup'!B43<=0,'01 Deal Setup'!B44<=0,'01 Deal Setup'!B45<=0,'01 Deal Setup'!B98<=0,'01 Deal Setup'!B10<1,'01 Deal Setup'!B10>10,'01 Deal Setup'!B35<0,'01 Deal Setup'!B36<0,'01 Deal Setup'!B37<0,'01 Deal Setup'!B38<0,'01 Deal Setup'!B40<0,'01 Deal Setup'!B82<0,'01 Deal Setup'!B84<0),"HOLD - INPUT",IF('01 Deal Setup'!G30<>"QUALIFIED*","HOLD - MODEL",IF(B70<>"FEASIBLE*","HOLD - CAPACITY",IF(B103<0,"HOLD - BUDGET",IF(B101<'01 Deal Setup'!B77,"HOLD - MARGIN","READY FOR REVIEW"))))) | HOLD - MODEL |
Parity: the tool against the workbook
For the default deal, 95 mapped outputs are compared cell by cell: 95 match exactly, 0 documented deviations, 0 mismatch. The full 17-scenario check, recalculated in LibreOffice, is in PARITY.md.
| Output | Cell | Workbook | Tool | Status |
|---|---|---|---|---|
| Proxy throughput factor (benchmark required) | 02!B6 |
1 | 1 | match |
| Planning trainer GPUs | 02!B7 |
8 | 8 | match |
| Planning rollout GPUs | 02!B8 |
8 | 8 | match |
| Planning eval GPUs | 02!B9 |
4 | 4 | match |
| Policy update GPU-hours | 02!B18 |
1,280 | 1,280 | match |
| Rollout GPU-hours | 02!B19 |
1,920 | 1,920 | match |
| Evaluation GPU-hours | 02!B20 |
160 | 160 | match |
| Total workload GPU-hours | 02!B21 |
3,360 | 3,360 | match |
| Trainer GPU-hours per cycle | 02!B22 |
426.6667 | 426.6667 | match |
| Rollout GPU-hours per cycle | 02!B23 |
640 | 640 | match |
| Evaluation GPU-hours per cycle | 02!B24 |
40 | 40 | match |
| Baseline evaluation GPU-hours | 02!B25 |
40 | 40 | match |
| Peak GPU units in RL | 02!B26 |
8 | 8 | match |
| RL activity wall-hours / cycle | 02!B27 |
143.3333 | 143.3333 | match |
| Total planned weeks | 02!B28 |
6 | 6 | match |
| Weeks needing new GPUs | 02!B52 |
0 | 0 | match |
| First shortage week | 02!B53 |
0 | 0 | match |
| Last shortage week | 02!B54 |
0 | 0 | match |
| Peak additional GPU units | 02!B55 |
0 | 0 | match |
| New workload GPU-hours | 02!B56 |
0 | 0 | match |
| Existing assigned GPU-hours | 02!B57 |
3,360 | 3,360 | match |
| PayGo acquisition cost | 02!B58 |
0 | 0 | match |
| Weekly extension acquisition cost | 02!B59 |
0 | 0 | match |
| New reservation committed cost | 02!B60 |
0 | 0 | match |
| Cheapest incremental cash | 02!B61 |
0 | 0 | match |
| Selected purchase method | 02!B62 |
Existing | Existing | match |
| Cash cost of new capacity | 02!B63 |
0 | 0 | match |
| New GPU-hours paid / committed | 02!B64 |
0 | 0 | match |
| Unused new commitment hours | 02!B65 |
0 | 0 | match |
| Managerial allocation of existing | 02!B66 |
8,400 | 8,400 | match |
| Existing alternative-use value | 02!B68 |
0 | 0 | match |
| Economic decision cost (cash + opportunity) | 02!B69 |
0 | 0 | match |
| Capacity / schedule verdict | 02!B70 |
FEASIBLE* | FEASIBLE* | match |
| Forward deployed engineering | 02!B73 |
28,800 | 28,800 | match |
| ML research engineering | 02!B74 |
32,000 | 32,000 | match |
| Infrastructure engineering | 02!B75 |
10,200 | 10,200 | match |
| Delivery coordination | 02!B76 |
6,000 | 6,000 | match |
| Total attributable engineering | 02!B77 |
77,000 | 77,000 | match |
| Graders, sandboxes and external APIs | 02!B78 |
6,000 | 6,000 | match |
| Storage and networking | 02!B79 |
1,500 | 1,500 | match |
| Direct platform support | 02!B80 |
4,000 | 4,000 | match |
| GPU COGS (allocated + new cash) | 02!B81 |
8,400 | 8,400 | match |
| Base cost to deliver | 02!B82 |
96,900 | 96,900 | match |
| Expected rework / failure allowance | 02!B83 |
9,690 | 9,690 | match |
| Risk-adjusted expected COGS | 02!B84 |
106,590 | 106,590 | match |
| COGS + opportunity view | 02!B85 |
106,590 | 106,590 | match |
| Readiness / baseline | 02!B91 |
30,000 | 30,000 | match |
| Engineering and integration | 02!B92 |
78,000 | 78,000 | match |
| Authorized RL cycles | 02!B93 |
72,000 | 72,000 | match |
| Extra-cycle engineering | 02!B94 |
0 | 0 | match |
| Independent acceptance / handoff | 02!B95 |
30,000 | 30,000 | match |
| Negotiated discount | 02!B96 |
0 | -0 | match |
| Base customer proposal | 02!B97 |
210,000 | 210,000 | match |
| Target-margin price floor | 02!B98 |
193,800 | 193,800 | match |
| Transparent capacity / risk adjustment | 02!B99 |
0 | 0 | match |
| SUGGESTED CUSTOMER QUOTE | 02!B100 |
210,000 | 210,000 | match |
| Expected deal gross margin | 02!B101 |
0.4924 | 0.4924 | match |
| Budget ceiling | 02!B102 |
260,000 | 260,000 | match |
| Remaining approved budget | 02!B103 |
50,000 | 50,000 | match |
| Commercial approval status | 02!B104 |
HOLD - MODEL | HOLD - MODEL | match |
| Input + output equivalent tokens / month | 02!B111 |
20,000,000 | 20,000,000 | match |
| Variable serving demand GPU-hours | 02!B112 |
200 | 200 | match |
| Warm capacity floor GPU-hours | 02!B113 |
1,440 | 1,440 | match |
| Provisioned / allocated serving GPU-hours | 02!B114 |
1,440 | 1,440 | match |
| Serving GPU vendor COGS | 02!B115 |
5,745.6 | 5,745.6 | match |
| Expected monthly serving COGS | 02!B116 |
8,245.6 | 8,245.6 | match |
| Suggested monthly serving invoice | 02!B117 |
0 | 0 | match |
| Pre-adjustment serving gross margin | 02!B118 |
0 | 0 | match |
| Serving size / SLO validation | 02!B119 |
NOT SCOPED | NOT SCOPED | match |
| Peak vs current warm capacity | 02!B120 |
0.4167 | 0.4167 | match |
| Scaling / re-paper recommendation | 02!B121 |
NOT SCOPED | NOT SCOPED | match |
| Target-margin serving floor | 02!B122 |
0 | 0 | match |
| Visible production uplift | 02!B123 |
0 | 0 | match |
| SUGGESTED MONTHLY SERVING PRICE | 02!B124 |
0 | 0 | match |
| Expected production gross margin | 02!B125 |
0 | 0 | match |
| Total model parameters (B) | 01!B8 |
35 | 35 | match |
| Customer | 01!G5 |
210,000 | 210,000 | match |
| Workflow / task | 01!G6 |
106,590 | 106,590 | match |
| Selected open-weight model | 01!G7 |
0.45 | 0.45 | match |
| Total model parameters (B) | 01!G8 |
0.4924 | 0.4924 | match |
| Training method | 01!G9 |
3,360 | 3,360 | match |
| Approved maximum RL cycles | 01!G10 |
Existing | Existing | match |
| Cadence | 01!G11 |
0 | 0 | match |
| Readiness period | 01!G12 |
0 | 0 | match |
| Handoff period | 01!G13 |
50,000 | 50,000 | match |
| Baseline score | 01!G16 |
FEASIBLE* | FEASIBLE* | match |
| Target acceptance score | 01!G17 |
HOLD - MODEL | HOLD - MODEL | match |
| Minimum meaningful gain | 01!G18 |
NO RESULTS YET | NO RESULTS YET | match |
| Consecutive slow cycles | 01!G19 |
NOT IN SCOPE | NOT IN SCOPE | match |
| Include production proposal? | 01!G23 |
3 | 3 | match Workbook VLOOKUP returns 0 for blank active parameters; brief requires "Not verified", never 0. |
| Serving contract type | 01!G24 |
MoE | MoE | match |
| Monthly input tokens | 01!G25 |
Listed | Listed | match |
| Minimum warm replicas | 01!G28 |
Validate | Validate | match |
| Customer accountable owner | 01!G30 |
HOLD - BENCHMARK | HOLD - BENCHMARK | match |
| Hosting region | 01!G32 |
PROVISIONAL ESTIMATE | PROVISIONAL ESTIMATE | match |
Every sheet, cell by cell
Full contents as saved, for checking any single cell. Labels come from the row’s text.
01 Deal Setup · 491 cells, 41 formulas
| Cell | Label | Saved value | Formula |
|---|---|---|---|
A1 | DEAL CONFIGURATOR | ||
A2 | EDIT shaded inputs; selected model determines planning proxy, but do not issue quote until model/hardware/throughput gates clear. | ||
A4 | 1 CUSTOMER, SCOPE & APPROVAL | ||
F4 | 1 CUSTOMER, SCOPE & APPROVAL | LIVE DEAL OUTPUTS (AUTO-CALCULATED) | |
A5 | Customer | ||
B5 | Customer | Example Enterprise | |
C5 | Customer | text | |
D5 | Customer | Replace with customer legal/entity name. | |
F5 | Customer | Recommended quote | |
G5 | Customer | 210,000 | ='02 Economics Capacity'!B100 |
A6 | Workflow / task | ||
B6 | Workflow / task | Internal workflow automation | |
C6 | Workflow / task | text | |
D6 | Workflow / task | One defined use case; material changes require amendment. | |
F6 | Workflow / task | Forecast delivery COGS | |
G6 | Workflow / task | 106,590 | ='02 Economics Capacity'!B84 |
A7 | Selected open-weight model | ||
B7 | Selected open-weight model | Qwen3.6-35B-A3B | |
C7 | Selected open-weight model | model dropdown | |
D7 | Selected open-weight model | Named options from the supplied AC2 knowledge base. Training/serving eligibility may differ. | |
F7 | Selected open-weight model | Target margin | |
G7 | Selected open-weight model | 0.45 | =B76 |
A8 | Total model parameters (B) | ||
B8 | Total model parameters (B) | 35 | =IFERROR(IF(VLOOKUP(B7,'04 Guide Assumptions'!$F$26:$Q$55,2,FALSE)=0,"Not verified",VLOOKUP(B7,'04 Guide Assumptions'!$F$26:$Q$55,2,FALSE)),"Not verified") |
C8 | Total model parameters (B) | billion params | |
D8 | Total model parameters (B) | Automatically populated; total model weights, not compute cost or active parameters. | |
F8 | Total model parameters (B) | Expected deal margin | |
G8 | Total model parameters (B) | 0.4924 | ='02 Economics Capacity'!B101 |
A9 | Training method | ||
B9 | Training method | GRPO | |
C9 | Training method | ▼ select | |
D9 | Training method | Only GRPO uses current RL-loop cost logic; other methods trigger HOLD until re-costed. | |
F9 | Training method | Demand GPU-hours | |
G9 | Training method | 3,360 | ='02 Economics Capacity'!B21 |
A10 | Approved maximum RL cycles | ||
B10 | Approved maximum RL cycles | 3 | |
C10 | Approved maximum RL cycles | cycles | |
D10 | Approved maximum RL cycles | Contracted maximum; no unapproved experimentation. | |
F10 | Approved maximum RL cycles | Selected capacity method | |
G10 | Approved maximum RL cycles | Existing | ='02 Economics Capacity'!B62 |
A11 | Cadence | ||
B11 | Cadence | 1 | |
C11 | Cadence | weeks per cycle | |
D11 | Cadence | One cycle every week by default; one cycle forecast in a week. | |
F11 | Cadence | New GPUs at peak | |
G11 | Cadence | 0 | ='02 Economics Capacity'!B55 |
A12 | Readiness period | ||
B12 | Readiness period | 2 | |
C12 | Readiness period | weeks | |
D12 | Readiness period | Time to baseline, prepare evals, approve grader. | |
F12 | Readiness period | Procurement commitment | |
G12 | Readiness period | 0 | ='02 Economics Capacity'!B63 |
A13 | Handoff period | ||
B13 | Handoff period | 1 | |
C13 | Handoff period | weeks | |
D13 | Handoff period | Final independent eval, checkpoint handoff and signoff. | |
F13 | Handoff period | Customer budget headroom | |
G13 | Handoff period | 50,000 | ='02 Economics Capacity'!B103 |
A14 | RL jobs scheduled | ||
B14 | RL jobs scheduled | Sequential | |
C14 | RL jobs scheduled | Sequential / Concurrent | |
D14 | RL jobs scheduled | Sequential avoids overlap capacity; concurrent requires both fleets at once. | |
A15 | Success metric | ||
B15 | Success metric | Held-out pass rate | |
C15 | Success metric | ▼ select | |
D15 | Success metric | Only 0–1 scores with higher = better. Customer approves frozen eval and target. | |
F15 | Success metric | DEAL READINESS / DECISION SIGNALS | |
A16 | Baseline score | ||
B16 | Baseline score | 0.6 | |
C16 | Baseline score | % | |
D16 | Baseline score | Illustrative pre-training score; use reproducible baseline. | |
F16 | Baseline score | Schedule / availability | |
G16 | Baseline score | FEASIBLE* | ='02 Economics Capacity'!B70 |
A17 | Target acceptance score | ||
B17 | Target acceptance score | 0.8 | |
C17 | Target acceptance score | % | |
D17 | Target acceptance score | Target for recommendation to stop, not guaranteed research outcome. | |
F17 | Target acceptance score | Price / budget | |
G17 | Target acceptance score | HOLD - MODEL | ='02 Economics Capacity'!B104 |
A18 | Minimum meaningful gain | ||
B18 | Minimum meaningful gain | 0.01 | |
C18 | Minimum meaningful gain | absolute points | |
D18 | Minimum meaningful gain | Plateau threshold per cycle (1 pp = 0.01). | |
F18 | Minimum meaningful gain | Suggested stop action | |
G18 | Minimum meaningful gain | NO RESULTS YET | =IF(B21="Stop","STOP - CUSTOMER DECISION",IF(B20=0,"NO RESULTS YET",IF(INDEX(G37:G44,B20)>=B17,"REVIEW - TARGET REACHED",IF(B20>=B10,"REVIEW - CYCLE CAP",IF(AND(B20>=B19,INDEX(H37:H44,B20)<B18,INDEX(H37:H44,B20-1)<B18),"REVIEW - PLATEAU","CONTINUE; CUSTOMER APPROVAL"))))) |
A19 | Consecutive slow cycles | ||
B19 | Consecutive slow cycles | 2 | |
C19 | Consecutive slow cycles | cycles | |
D19 | Consecutive slow cycles | Review when 2 successive gains fall below threshold. | |
F19 | Consecutive slow cycles | Production quote (if Yes) | |
G19 | Consecutive slow cycles | NOT IN SCOPE | =IF(B23="Yes",'02 Economics Capacity'!B124,"NOT IN SCOPE") |
A20 | Cycles with scores entered | ||
B20 | Cycles with scores entered | 0 | =COUNT(G37:G44) |
C20 | Cycles with scores entered | completed | |
D20 | Cycles with scores entered | Score log right -> automatically counts entered outcomes. | |
A21 | Customer continuation decision | ||
B21 | Customer continuation decision | Pending | |
C21 | Customer continuation decision | Pending / Continue / Stop | |
D21 | Customer continuation decision | Customer is decision maker after each cycle; forecast is advisory. | |
A22 | Maximum deal approval budget | ||
B22 | Maximum deal approval budget | 260,000 | |
C22 | Maximum deal approval budget | $ | |
D22 | Maximum deal approval budget | Signals when quote needs scope/budget change. | |
F22 | Maximum deal approval budget | MODEL QUALIFICATION | REQUIRED BEFORE QUOTE | |
A23 | Include production proposal? | ||
B23 | Include production proposal? | No | |
C23 | Include production proposal? | Yes / No | |
D23 | Include production proposal? | Separate prospective monthly quote, not part of training value. | |
F23 | Include production proposal? | Active parameters (B) | |
G23 | Include production proposal? | 3 | =IFERROR(VLOOKUP($B$7,'04 Guide Assumptions'!$F$26:$Q$55,3,FALSE),"Not verified") |
A24 | Serving contract type | ||
B24 | Serving contract type | Dedicated | |
C24 | Serving contract type | Shared / Dedicated | |
D24 | Serving contract type | Shared usage minimum vs dedicated warm-replica subscription. | |
F24 | Serving contract type | Architecture | |
G24 | Serving contract type | MoE | =IFERROR(VLOOKUP($B$7,'04 Guide Assumptions'!$F$26:$Q$55,4,FALSE),"Not verified") |
A25 | Monthly input tokens | ||
B25 | Monthly input tokens | 20,000,000 | |
C25 | Monthly input tokens | tokens/month | |
D25 | Monthly input tokens | Forecast only; contract includes named allowances. | |
F25 | Monthly input tokens | RL training status | |
G25 | Monthly input tokens | Listed | =IFERROR(VLOOKUP($B$7,'04 Guide Assumptions'!$F$26:$Q$55,5,FALSE),"Not verified") |
A26 | Monthly output tokens | ||
B26 | Monthly output tokens | 10,000,000 | |
C26 | Monthly output tokens | tokens/month | |
D26 | Monthly output tokens | Outputs usually have higher serving cost. | |
F26 | Monthly output tokens | Serving status | |
G26 | Monthly output tokens | Listed | =IFERROR(VLOOKUP($B$7,'04 Guide Assumptions'!$F$26:$Q$55,6,FALSE),"Not verified") |
A27 | Peak / average traffic | ||
B27 | Peak / average traffic | 3 | |
C27 | Peak / average traffic | x | |
D27 | Peak / average traffic | Capacity planning proxy; benchmark peak latency before launch. | |
F27 | Peak / average traffic | Catalog evidence | |
G27 | Peak / average traffic | Model-named | =IFERROR(VLOOKUP($B$7,'04 Guide Assumptions'!$F$26:$Q$55,7,FALSE),"Not verified") |
A28 | Minimum warm replicas | ||
B28 | Minimum warm replicas | 2 | |
C28 | Minimum warm replicas | GPUs | |
D28 | Minimum warm replicas | Latency / availability floor independent of token volume. | |
F28 | Minimum warm replicas | GPU class to confirm | |
G28 | Minimum warm replicas | Validate | =IFERROR(VLOOKUP($B$7,'04 Guide Assumptions'!$F$26:$Q$55,9,FALSE),"Not verified") |
A29 | Availability target | ||
B29 | Availability target | 0.999 | |
C29 | Availability target | % | |
D29 | Availability target | Planning assumption, not an SLA until service order signed. | |
F29 | Availability target | Parameter source URL | |
G29 | Availability target | https://huggingface.co/Qwen/Qwen3.6-35B-A3B | =IFERROR(VLOOKUP($B$7,'04 Guide Assumptions'!$F$26:$Q$55,10,FALSE),"Not verified") |
A30 | Customer accountable owner | ||
B30 | Customer accountable owner | Customer product / SME lead | |
C30 | Customer accountable owner | owner | |
D30 | Customer accountable owner | Owns base model, grader, continue/stop and acceptance decisions. | |
F30 | Customer accountable owner | Model readiness | |
G30 | Customer accountable owner | HOLD - BENCHMARK | =IF($B$9<>"GRPO","HOLD - METHOD RE-SCOPE",IF(OR($B$33="Access pending",$B$33="Not available"),"HOLD - DATA ACCESS",IF(NOT(ISNUMBER($B$8)),"HOLD - PARAMETERS",IF($B$101<>"Yes","HOLD - BENCHMARK",IF($B$102<>"Yes","HOLD - ACCESS",IF($B$104<>"Yes","HOLD - SKU RATE",IF(AND($G$28="B300",$B$103<>"B300"),"HOLD - GPU FAMILY",IF(OR($G$25="Not listed",$G$25="Research only",$G$25="Legacy mention",$G$25="Family - verify",$G$25="Access required"),"HOLD - TRAINING ELIGIBILITY","QUALIFIED*")))))))) |
A31 | Applied Compute delivery owner | ||
B31 | Applied Compute delivery owner | AC engagement lead | |
C31 | Applied Compute delivery owner | owner | |
D31 | Applied Compute delivery owner | Builds, runs, measures, and recommends. | |
F31 | Applied Compute delivery owner | Planning proxy class | |
G31 | Applied Compute delivery owner | 2 | =IFERROR(VLOOKUP($B$7,'04 Guide Assumptions'!$F$26:$Q$55,8,FALSE),"Not verified") |
A32 | Hosting region | ||
B32 | Hosting region | US region TBD | |
C32 | Hosting region | region | |
D32 | Hosting region | Data residency and supply feasibility must be confirmed. | |
F32 | Hosting region | Model suitability | |
G32 | Hosting region | PROVISIONAL ESTIMATE | =IF(OR($G$25="Not listed",$G$25="Research only",$G$25="Legacy mention"),"TRAINING NOT CONFIRMED",IF($G$25="Family - verify","VARIANT ACCESS CHECK",IF($B$8="Not verified","PARAMETERS NEED VERIFICATION",IF($G$28="Multi-node","MULTI-NODE REVIEW","PROVISIONAL ESTIMATE")))) |
A33 | Data/access readiness | ||
B33 | Data/access readiness | Customer supplies by kickoff | |
C33 | Data/access readiness | ▼ select | |
D33 | Data/access readiness | Ready / validated or by kickoff are allowed; pending/unavailable block approval. | |
F33 | Data/access readiness | OPTIONAL: ENTER ACTUAL HELD-OUT EVALS EACH CYCLE | |
A34 | 2 DEMAND + GPU PERFORMANCE ASSUMPTIONS | ||
A35 | Policy-update tokens per cycle | ||
B35 | Policy-update tokens per cycle | 42,666,666.6667 | |
C35 | Policy-update tokens per cycle | tokens/cycle | |
D35 | Policy-update tokens per cycle | Training tokens; benchmark replaces heuristic. | |
A36 | Rollout attempts per cycle | ||
B36 | Rollout attempts per cycle | 4,000 | |
C36 | Rollout attempts per cycle | attempts/cycle | |
D36 | Rollout attempts per cycle | Include retries, sampled traces and intended exploration. | |
F36 | Rollout attempts per cycle | Cycle # | |
G36 | Rollout attempts per cycle | Actual score | |
H36 | Rollout attempts per cycle | Gain vs prior | |
I36 | Rollout attempts per cycle | Cycle status | |
A37 | Mean rollout input tokens | ||
B37 | Mean rollout input tokens | 12,000 | |
C37 | Mean rollout input tokens | tokens/attempt | |
D37 | Mean rollout input tokens | Estimate from a representative agent trace sample. | |
F37 | Mean rollout input tokens | 1 | |
H37 | Mean rollout input tokens | — | =IF(G37="","",G37-$B$16) |
I37 | Mean rollout input tokens | NOT RUN | =IF(G37="","NOT RUN",IF(G37>=$B$17,"TARGET HIT",IF(F37>=$B$10,"BEYOND SCOPE","CHECK CONTINUE"))) |
A38 | Mean rollout output tokens | ||
B38 | Mean rollout output tokens | 10,000 | |
C38 | Mean rollout output tokens | tokens/attempt | |
D38 | Mean rollout output tokens | Generation volume; avoid counting only successful rollouts. | |
F38 | Mean rollout output tokens | 2 | |
H38 | Mean rollout output tokens | — | =IF(G38="","",IF(G37="","",G38-G37)) |
I38 | Mean rollout output tokens | NOT RUN | =IF(G38="","NOT RUN",IF(G38>=$B$17,"TARGET HIT",IF(F38>=$B$10,"BEYOND SCOPE","CHECK CONTINUE"))) |
A39 | Input-token work factor | ||
B39 | Input-token work factor | 0.5 | |
C39 | Input-token work factor | equivalent/token | |
D39 | Input-token work factor | Simplified prefill weight relative to decode; benchmark required. | |
F39 | Input-token work factor | 3 | |
H39 | Input-token work factor | — | =IF(G39="","",IF(G38="","",G39-G38)) |
I39 | Input-token work factor | NOT RUN | =IF(G39="","NOT RUN",IF(G39>=$B$17,"TARGET HIT",IF(F39>=$B$10,"BEYOND SCOPE","CHECK CONTINUE"))) |
A40 | Evaluation cases / cycle | ||
B40 | Evaluation cases / cycle | 200 | |
C40 | Evaluation cases / cycle | cases/cycle | |
D40 | Evaluation cases / cycle | Held-out evaluation repeated at each checkpoint. | |
F40 | Evaluation cases / cycle | 4 | |
H40 | Evaluation cases / cycle | — | =IF(G40="","",IF(G39="","",G40-G39)) |
I40 | Evaluation cases / cycle | NOT RUN | =IF(G40="","NOT RUN",IF(G40>=$B$17,"TARGET HIT",IF(F40>=$B$10,"BEYOND SCOPE","CHECK CONTINUE"))) |
A41 | Baseline evaluation cases | ||
B41 | Baseline evaluation cases | 200 | |
C41 | Baseline evaluation cases | cases | |
D41 | Baseline evaluation cases | Run before training; included in the evaluation budget. | |
F41 | Baseline evaluation cases | 5 | |
H41 | Baseline evaluation cases | — | =IF(G41="","",IF(G40="","",G41-G40)) |
I41 | Baseline evaluation cases | NOT RUN | =IF(G41="","NOT RUN",IF(G41>=$B$17,"TARGET HIT",IF(F41>=$B$10,"BEYOND SCOPE","CHECK CONTINUE"))) |
A42 | Work-equivalent tokens / eval | ||
B42 | Work-equivalent tokens / eval | 20,000 | |
C42 | Work-equivalent tokens / eval | tokens/case | |
D42 | Work-equivalent tokens / eval | Simplified GPU work incl. judge inference; external graders separately. | |
F42 | Work-equivalent tokens / eval | 6 | |
H42 | Work-equivalent tokens / eval | — | =IF(G42="","",IF(G41="","",G42-G41)) |
I42 | Work-equivalent tokens / eval | NOT RUN | =IF(G42="","NOT RUN",IF(G42>=$B$17,"TARGET HIT",IF(F42>=$B$10,"BEYOND SCOPE","CHECK CONTINUE"))) |
A43 | Policy throughput (standard) | ||
B43 | Policy throughput (standard) | 100,000 | |
C43 | Policy throughput (standard) | tokens/GPU-hour | |
D43 | Policy throughput (standard) | Unverified benchmark for 32B-class configuration. | |
F43 | Policy throughput (standard) | 7 | |
H43 | Policy throughput (standard) | — | =IF(G43="","",IF(G42="","",G43-G42)) |
I43 | Policy throughput (standard) | NOT RUN | =IF(G43="","NOT RUN",IF(G43>=$B$17,"TARGET HIT",IF(F43>=$B$10,"BEYOND SCOPE","CHECK CONTINUE"))) |
A44 | Rollout throughput (standard) | ||
B44 | Rollout throughput (standard) | 100,000 | |
C44 | Rollout throughput (standard) | equiv tokens/GPU-hour | |
D44 | Rollout throughput (standard) | Unverified benchmark; input/output mix influences value. | |
F44 | Rollout throughput (standard) | 8 | |
H44 | Rollout throughput (standard) | — | =IF(G44="","",IF(G43="","",G44-G43)) |
I44 | Rollout throughput (standard) | NOT RUN | =IF(G44="","NOT RUN",IF(G44>=$B$17,"TARGET HIT",IF(F44>=$B$10,"BEYOND SCOPE","CHECK CONTINUE"))) |
A45 | Eval throughput (standard) | ||
B45 | Eval throughput (standard) | 100,000 | |
C45 | Eval throughput (standard) | equiv tokens/GPU-hour | |
D45 | Eval throughput (standard) | Unverified benchmark; grader APIs budgeted separately. | |
A46 | Policy GPUs (standard) | ||
B46 | Policy GPUs (standard) | 8 | |
C46 | Policy GPUs (standard) | GPUs | |
D46 | Policy GPUs (standard) | Illustrative 32B distributed training job size. | |
F46 | Policy GPUs (standard) | Stop rule | |
G46 | Policy GPUs (standard) | Target OR plateau OR cycle cap. Customer must approve the actual stop/continue decision. | |
A47 | Rollout GPUs (standard) | ||
B47 | Rollout GPUs (standard) | 8 | |
C47 | Rollout GPUs (standard) | GPUs | |
D47 | Rollout GPUs (standard) | Illustrative 32B rollout fleet size. | |
A48 | Evaluation GPUs (standard) | ||
B48 | Evaluation GPUs (standard) | 4 | |
C48 | Evaluation GPUs (standard) | GPUs | |
D48 | Evaluation GPUs (standard) | Illustrative GPU group for held-out eval. | |
A49 | 3 DIRECT DELIVERY COST ASSUMPTIONS | ||
A50 | FDE setup hours | ||
B50 | FDE setup hours | 40 | |
C50 | FDE setup hours | hours | |
D50 | FDE setup hours | One-off integration, workflow and harness scoping. | |
A51 | FDE hours per cycle | ||
B51 | FDE hours per cycle | 40 | |
C51 | FDE hours per cycle | hours/cycle | |
D51 | FDE hours per cycle | Direct delivery load scales with approved loops. | |
A52 | FDE loaded cost | ||
B52 | FDE loaded cost | 180 | |
C52 | FDE loaded cost | $/hour | |
D52 | FDE loaded cost | Illustrative loaded labor cost, not customer sell rate. | |
A53 | Research setup hours | ||
B53 | Research setup hours | 40 | |
C53 | Research setup hours | hours | |
D53 | Research setup hours | Baseline, grader and model selection support. | |
A54 | Research hours per cycle | ||
B54 | Research hours per cycle | 40 | |
C54 | Research hours per cycle | hours/cycle | |
D54 | Research hours per cycle | Training diagnostics and quality review. | |
A55 | Research loaded cost | ||
B55 | Research loaded cost | 200 | |
C55 | Research loaded cost | $/hour | |
D55 | Research loaded cost | Illustrative loaded labor cost. | |
A56 | Infra setup hours | ||
B56 | Infra setup hours | 12 | |
C56 | Infra setup hours | hours | |
D56 | Infra setup hours | Initial deployment, storage and capacity provisioning. | |
A57 | Infra hours per cycle | ||
B57 | Infra hours per cycle | 16 | |
C57 | Infra hours per cycle | hours/cycle | |
D57 | Infra hours per cycle | Runtime support and operational monitoring. | |
A58 | Infra loaded cost | ||
B58 | Infra loaded cost | 170 | |
C58 | Infra loaded cost | $/hour | |
D58 | Infra loaded cost | Illustrative loaded labor cost. | |
A59 | Delivery setup hours | ||
B59 | Delivery setup hours | 16 | |
C59 | Delivery setup hours | hours | |
D59 | Delivery setup hours | Customer milestones and coordinating approvals. | |
A60 | Delivery hours per cycle | ||
B60 | Delivery hours per cycle | 8 | |
C60 | Delivery hours per cycle | hours/cycle | |
D60 | Delivery hours per cycle | Status, review meeting, completion evidence. | |
A61 | Delivery loaded cost | ||
B61 | Delivery loaded cost | 150 | |
C61 | Delivery loaded cost | $/hour | |
D61 | Delivery loaded cost | Illustrative loaded labor cost. | |
A62 | Baseline graders / environments | ||
B62 | Baseline graders / environments | 1,500 | |
C62 | Baseline graders / environments | $ | |
D62 | Baseline graders / environments | One-time APIs, sandbox, human quality checks. | |
A63 | Grader / environment per cycle | ||
B63 | Grader / environment per cycle | 1,500 | |
C63 | Grader / environment per cycle | $/cycle | |
D63 | Grader / environment per cycle | Some judge and tool costs are NOT GPU based. | |
A64 | Storage / networking | ||
B64 | Storage / networking | 1,500 | |
C64 | Storage / networking | $ | |
D64 | Storage / networking | Illustrative checkpoint, transfer, logs and object storage. | |
A65 | Direct platform support | ||
B65 | Direct platform support | 4,000 | |
C65 | Direct platform support | $ | |
D65 | Direct platform support | Deal-specific operating cost, not corporate overhead. | |
A66 | Expected rework allowance | ||
B66 | Expected rework allowance | 0.1 | |
C66 | Expected rework allowance | % COGS | |
D66 | Expected rework allowance | Expected delivery variation; forecast, not booked accounting expense. | |
A67 | 4 CUSTOMER QUOTE + MARGIN POLICY | ||
A68 | Readiness fixed fee | ||
B68 | Readiness fixed fee | 30,000 | |
C68 | Readiness fixed fee | $ | |
D68 | Readiness fixed fee | Customer-facing fixed feasibility, baseline and grader design. | |
A69 | Engineering setup fee | ||
B69 | Engineering setup fee | 78,000 | |
C69 | Engineering setup fee | $ | |
D69 | Engineering setup fee | Customer-facing engineering/harness delivery across engagement. | |
A70 | RL cycle fee (standard) | ||
B70 | RL cycle fee (standard) | 24,000 | |
C70 | RL cycle fee (standard) | $/cycle | |
D70 | RL cycle fee (standard) | Customer fee per approved baseline-size cycle. | |
A71 | Included cycles before added labor | ||
B71 | Included cycles before added labor | 3 | |
C71 | Included cycles before added labor | cycles | |
D71 | Included cycles before added labor | Extra cycle also needs named incremental engineering allocation. | |
A72 | Added engineering fee / extra cycle | ||
B72 | Added engineering fee / extra cycle | 24,000 | |
C72 | Added engineering fee / extra cycle | $/cycle | |
D72 | Added engineering fee / extra cycle | Only for loops above included engineering scope. | |
A73 | Independent final validation fee | ||
B73 | Independent final validation fee | 30,000 | |
C73 | Independent final validation fee | $ | |
D73 | Independent final validation fee | Held-out results, reproducibility and model handoff. | |
A75 | Negotiated project discount | ||
B75 | Negotiated project discount | 0 | |
C75 | Negotiated project discount | % | |
D75 | Negotiated project discount | Discount reduces commercial margin; no hidden cost reduction. | |
A76 | Target engagement gross margin | ||
B76 | Target engagement gross margin | 0.45 | |
C76 | Target engagement gross margin | % | |
D76 | Target engagement gross margin | Illustrative policy to test, not company-provided target. | |
A77 | Minimum acceptable GM | ||
B77 | Minimum acceptable GM | 0.35 | |
C77 | Minimum acceptable GM | % | |
D77 | Minimum acceptable GM | Triggers warning in discount/underpricing scenario. | |
A78 | 5 GPU CAPACITY + PROCUREMENT | ||
A79 | Use compatible existing GPUs? | ||
B79 | Use compatible existing GPUs? | Yes | |
C79 | Use compatible existing GPUs? | Yes / No | |
D79 | Use compatible existing GPUs? | Existing must be spare and topology/region compatible. | |
A80 | New capacity acquisition | ||
B80 | New capacity acquisition | Auto | |
C80 | New capacity acquisition | Auto / PayGo / Extend / Reserve / Existing only / BYOC | |
D80 | New capacity acquisition | Auto minimizes modeled incremental vendor cash (not risk-adjusted opportunity). | |
A81 | Extra capacity can be obtained? | ||
B81 | Extra capacity can be obtained? | No | |
C81 | Extra capacity can be obtained? | Yes / No | |
D81 | Extra capacity can be obtained? | Supplier availability NOT verified; No blocks uncovered workloads. | |
A82 | PayGo unit price | ||
B82 | PayGo unit price | 3.99 | |
C82 | PayGo unit price | $/GPU-hour | |
D82 | PayGo unit price | Illustrative public H100 benchmark; not AC internal contracted price. | |
A83 | One-week extension unit price | ||
B83 | One-week extension unit price | 2.75 | |
C83 | One-week extension unit price | $/GPU-hour | |
D83 | One-week extension unit price | Illustrative; extensions must actually be available. | |
A84 | New reservation unit price | ||
B84 | New reservation unit price | 2.5 | |
C84 | New reservation unit price | $/GPU-hour | |
D84 | New reservation unit price | Illustrative price subject to 4-week minimum. | |
A85 | Minimum new reservation | ||
B85 | Minimum new reservation | 4 | |
C85 | Minimum new reservation | weeks | |
D85 | Minimum new reservation | Reservation cash paid even when unused. | |
A86 | Hours per scheduled week | ||
B86 | Hours per scheduled week | 168 | |
C86 | Hours per scheduled week | hours | |
D86 | Hours per scheduled week | Upper bound; operations/maintenance reduce usable hours. | |
A87 | Existing capacity allocation cost | ||
B87 | Existing capacity allocation cost | 2.5 | |
C87 | Existing capacity allocation cost | $/GPU-hour | |
D87 | Existing capacity allocation cost | Managerial COGS for already-paid GPU hours; not incremental cash. | |
A88 | Existing capacity opportunity value | ||
B88 | Existing capacity opportunity value | 0 | |
C88 | Existing capacity opportunity value | $/GPU-hour | |
D88 | Existing capacity opportunity value | Value lost from displacing real alternative; not accounting COGS. | |
A89 | New provisioning / setup | ||
B89 | New provisioning / setup | 0 | |
C89 | New provisioning / setup | $ | |
D89 | New provisioning / setup | Reserved to add one-off cluster integration fees. | |
A90 | 6 OPTIONAL PRODUCTION INFERENCE | ||
A91 | Shared minimum monthly | ||
B91 | Shared minimum monthly | 15,000 | |
C91 | Shared minimum monthly | $/month | |
D91 | Shared minimum monthly | Illustrative contracted minimum for managed shared inference. | |
A92 | Dedicated warm GPU fee | ||
B92 | Dedicated warm GPU fee | 6,000 | |
C92 | Dedicated warm GPU fee | $/GPU-month | |
D92 | Dedicated warm GPU fee | Illustrative capacity subscription; check utilization and SLA. | |
A93 | Input token overage rate | ||
B93 | Input token overage rate | 1.2 | |
C93 | Input token overage rate | $/1M tokens | |
D93 | Input token overage rate | Charge beyond included input token allowance. | |
A94 | Output token overage rate | ||
B94 | Output token overage rate | 4.5 | |
C94 | Output token overage rate | $/1M tokens | |
D94 | Output token overage rate | Charge beyond included output token allowance. | |
A95 | Included monthly input tokens | ||
B95 | Included monthly input tokens | 20,000,000 | |
C95 | Included monthly input tokens | tokens/month | |
D95 | Included monthly input tokens | Customer service-order threshold; overage beyond this. | |
A96 | Included monthly output tokens | ||
B96 | Included monthly output tokens | 10,000,000 | |
C96 | Included monthly output tokens | tokens/month | |
D96 | Included monthly output tokens | Customer service-order threshold; overage beyond this. | |
A97 | Serving engineering support | ||
B97 | Serving engineering support | 2,500 | |
C97 | Serving engineering support | $/month | |
D97 | Serving engineering support | Direct production support and observability forecast. | |
A98 | Serving throughput (standard) | ||
B98 | Serving throughput (standard) | 100,000 | |
C98 | Serving throughput (standard) | equiv tokens/GPU-hour | |
D98 | Serving throughput (standard) | Must benchmark SLO-compliant serving throughput. | |
A99 | Shared capacity share | ||
B99 | Shared capacity share | 0.35 | |
C99 | Shared capacity share | % | |
D99 | Shared capacity share | Allocated share of shared serving fleet; finance assumption. | |
A100 | MODEL AND HARDWARE APPROVAL GATES (scenario prices still calculate when No) | ||
A101 | AC workload benchmark confirmed? | ||
B101 | AC workload benchmark confirmed? | No | |
C101 | AC workload benchmark confirmed? | Yes / No | |
D101 | AC workload benchmark confirmed? | Includes measured trainer, rollout and eval throughput for selected model and GPU class. | |
A102 | Training access / licensing approved? | ||
B102 | Training access / licensing approved? | No | |
C102 | Training access / licensing approved? | Yes / No | |
D102 | Training access / licensing approved? | Customer + AC confirm weights, license and AC2 training access. | |
A103 | GPU accelerator planned | ||
B103 | GPU accelerator planned | H100 | |
C103 | GPU accelerator planned | H100 / B200 / B300 / Other | |
D103 | GPU accelerator planned | Existing capacity pools must be same SKU family or separately benchmarked. | |
A104 | GPU SKU-specific rate confirmed? | ||
B104 | GPU SKU-specific rate confirmed? | No | |
C104 | GPU SKU-specific rate confirmed? | Yes / No | |
D104 | GPU SKU-specific rate confirmed? | H100 starter rate must not silently price B200/B300; verify supplier cost and allocation rate. | |
A107 | 7 EXISTING CAPACITY | SUPPLY TYPE MUST MATCH GPU FAMILY IN B103 | ||
A108 | Pool / contract | ||
B108 | Pool / contract | Free GPU units | |
C108 | Pool / contract | Start week | |
D108 | Pool / contract | Expiry week | |
E108 | Pool / contract | Comment | |
F108 | Pool / contract | Region / fit | |
G108 | Pool / contract | GPU family | |
H108 | Pool / contract | ▼ Fit status | |
A109 | Prepaid cluster A | ||
B109 | Prepaid cluster A | 8 | |
C109 | Prepaid cluster A | 1 | |
D109 | Prepaid cluster A | 8 | |
E109 | Prepaid cluster A | Already paid; check topology | |
F109 | Prepaid cluster A | Compatible | |
G109 | Prepaid cluster A | H100 | |
A110 | Other pool B | ||
B110 | Other pool B | 0 | |
C110 | Other pool B | 3 | |
D110 | Other pool B | 5 | |
E110 | Other pool B | Optional second tranche | |
F110 | Other pool B | Compatible | |
G110 | Other pool B | H100 | |
A111 | Other pool C | ||
B111 | Other pool C | 0 | |
C111 | Other pool C | 5 | |
D111 | Other pool C | 8 | |
E111 | Other pool C | Optional third tranche | |
F111 | Other pool C | Compatible | |
G111 | Other pool C | H100 |
02 Economics Capacity · 530 cells, 307 formulas
| Cell | Label | Saved value | Formula |
|---|---|---|---|
A1 | DEAL ECONOMICS + GPU CAPACITY | ||
A2 | Automatic calculations - demand, feasible capacity, incremental cash, fully loaded delivery COGS, and recommended quote. | ||
A4 | 1 DEMAND -> GPU-HOURS | ||
F4 | 1 DEMAND -> GPU-HOURS | HOW TO INTERPRET THE COSTS | |
A5 | Selected model | ||
B5 | Selected model | Qwen3.6-35B-A3B | ='01 Deal Setup'!B7 |
F5 | Selected model | Demand | |
G5 | Selected model | Tokens, rollouts, evals | |
H5 | Selected model | Customer-controlled scope | |
A6 | Proxy throughput factor (benchmark required) | ||
B6 | Proxy throughput factor (benchmark required) | 1 | =IF('01 Deal Setup'!$G$31=1,2.5,IF('01 Deal Setup'!$G$31=2,1,0.5)) |
C6 | Proxy throughput factor (benchmark required) | x | |
F6 | Proxy throughput factor (benchmark required) | Performance | |
G6 | Proxy throughput factor (benchmark required) | Model-specific throughput | |
H6 | Proxy throughput factor (benchmark required) | Replace with measured benchmarks | |
A7 | Planning trainer GPUs | ||
B7 | Planning trainer GPUs | 8 | =MAX(1,ROUND('01 Deal Setup'!B46*IF('01 Deal Setup'!$G$31=1,0.5,IF('01 Deal Setup'!$G$31=2,1,2)),0)) |
C7 | Planning trainer GPUs | GPUs | |
F7 | Planning trainer GPUs | Capacity | |
G7 | Planning trainer GPUs | Peak GPUs and timing | |
H7 | Planning trainer GPUs | Availability is not GPU-hours alone | |
A8 | Planning rollout GPUs | ||
B8 | Planning rollout GPUs | 8 | =MAX(1,ROUND('01 Deal Setup'!B47*IF('01 Deal Setup'!$G$31=1,0.5,IF('01 Deal Setup'!$G$31=2,1,2)),0)) |
C8 | Planning rollout GPUs | GPUs | |
F8 | Planning rollout GPUs | New capacity cash | |
G8 | Planning rollout GPUs | What we must newly buy | |
H8 | Planning rollout GPUs | PayGo vs extension vs reservation | |
A9 | Planning eval GPUs | ||
B9 | Planning eval GPUs | 4 | =MAX(1,ROUND('01 Deal Setup'!B48*IF('01 Deal Setup'!$G$31=1,0.5,IF('01 Deal Setup'!$G$31=2,1,2)),0)) |
C9 | Planning eval GPUs | GPUs | |
F9 | Planning eval GPUs | Allocated existing | |
G9 | Planning eval GPUs | Already-paid GPU value | |
H9 | Planning eval GPUs | Gross-margin lens, not new cash | |
A10 | Authorized RL cycles | ||
B10 | Authorized RL cycles | 3 | ='01 Deal Setup'!B10 |
C10 | Authorized RL cycles | cycles | |
F10 | Authorized RL cycles | Opportunity | |
G10 | Authorized RL cycles | Lost alternative contribution | |
H10 | Authorized RL cycles | Economic choice, not accounting COGS | |
F11 | Input + output equivalent tokens / month | Customer quote | |
G11 | Input + output equivalent tokens / month | Itemized fee + explicit uplift | |
H11 | Input + output equivalent tokens / month | Margin target is a proposed policy | |
A12 | 2 TOTAL WORKLOAD (ALL APPROVED CYCLES) | ||
A13 | Policy update tokens | ||
B13 | Policy update tokens | 128,000,000 | ='01 Deal Setup'!B35*B10 |
C13 | Policy update tokens | tokens | |
A14 | RL rollout attempts | ||
B14 | RL rollout attempts | 12,000 | ='01 Deal Setup'!B36*B10 |
C14 | RL rollout attempts | attempts | |
F14 | RL rollout attempts | Supplier rates, GPU fit, commitment dates, and throughput are unverified sample inputs; DO NOT issue a live quote without checking them. | |
A15 | Rollout equivalent tokens | ||
B15 | Rollout equivalent tokens | 192,000,000 | =B14*('01 Deal Setup'!B37*'01 Deal Setup'!B39+'01 Deal Setup'!B38) |
C15 | Rollout equivalent tokens | equiv tokens | |
A16 | Total eval cases | ||
B16 | Total eval cases | 800 | ='01 Deal Setup'!B41+B10*'01 Deal Setup'!B40 |
C16 | Total eval cases | cases | |
A17 | Eval equivalent tokens | ||
B17 | Eval equivalent tokens | 16,000,000 | =B16*'01 Deal Setup'!B42 |
C17 | Eval equivalent tokens | equiv tokens | |
A18 | Policy update GPU-hours | ||
B18 | Policy update GPU-hours | 1,280 | =IF('01 Deal Setup'!B43<=0,0,B13/('01 Deal Setup'!B43*B6)) |
C18 | Policy update GPU-hours | GPU-hours | |
A19 | Rollout GPU-hours | ||
B19 | Rollout GPU-hours | 1,920 | =IF('01 Deal Setup'!B44<=0,0,B15/('01 Deal Setup'!B44*B6)) |
C19 | Rollout GPU-hours | GPU-hours | |
A20 | Evaluation GPU-hours | ||
B20 | Evaluation GPU-hours | 160 | =IF('01 Deal Setup'!B45<=0,0,B17/('01 Deal Setup'!B45*B6)) |
C20 | Evaluation GPU-hours | GPU-hours | |
A21 | Total workload GPU-hours | ||
B21 | Total workload GPU-hours | 3,360 | =SUM(B18:B20) |
C21 | Total workload GPU-hours | GPU-hours | |
A22 | Trainer GPU-hours per cycle | ||
B22 | Trainer GPU-hours per cycle | 426.6667 | =IF(B10=0,0,B18/B10) |
C22 | Trainer GPU-hours per cycle | GPUh / cycle | |
A23 | Rollout GPU-hours per cycle | ||
B23 | Rollout GPU-hours per cycle | 640 | =IF(B10=0,0,B19/B10) |
C23 | Rollout GPU-hours per cycle | GPUh / cycle | |
A24 | Evaluation GPU-hours per cycle | ||
B24 | Evaluation GPU-hours per cycle | 40 | =IF('01 Deal Setup'!B45<=0,0,'01 Deal Setup'!B40*'01 Deal Setup'!B42/('01 Deal Setup'!B45*B6)) |
C24 | Evaluation GPU-hours per cycle | GPUh / cycle | |
A25 | Baseline evaluation GPU-hours | ||
B25 | Baseline evaluation GPU-hours | 40 | =IF('01 Deal Setup'!B45<=0,0,'01 Deal Setup'!B41*'01 Deal Setup'!B42/('01 Deal Setup'!B45*B6)) |
C25 | Baseline evaluation GPU-hours | GPUh | |
A26 | Peak GPU units in RL | ||
B26 | Peak GPU units in RL | 8 | =IF('01 Deal Setup'!B14="Concurrent",B7+B8,MAX(B7,B8)) |
C26 | Peak GPU units in RL | GPUs | |
A27 | RL activity wall-hours / cycle | ||
B27 | RL activity wall-hours / cycle | 143.3333 | =IF('01 Deal Setup'!B14="Concurrent",MAX(B22/B7,B23/B8),B22/B7+B23/B8)+B24/B9 |
C27 | RL activity wall-hours / cycle | hours | |
A28 | Total planned weeks | ||
B28 | Total planned weeks | 6 | ='01 Deal Setup'!B12+'01 Deal Setup'!B10*'01 Deal Setup'!B11+'01 Deal Setup'!B13 |
C28 | Total planned weeks | weeks | |
A30 | 3 WEEK-BY-WEEK CAPACITY (WEEKS 1-16) | ||
B31 | Week | ||
C31 | Week | RL cycle? | |
D31 | Week | Policy GPUh | |
E31 | Week | Rollout GPUh | |
F31 | Week | Eval GPUh | |
G31 | Week | Total GPUh | |
H31 | Week | Peak GPUs | |
I31 | Week | Existing GPUs | |
J31 | Week | Need GPUs | |
K31 | Week | New GPUh | |
L31 | Week | Existing GPUh | |
M31 | Week | 1wk cost | |
N31 | Week | First wk helper | |
O31 | Week | Last wk helper | |
P31 | Week | Status | |
B32 | 1 | ||
C32 | 0 | =IF(AND(B32>'01 Deal Setup'!$B$12,B32<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B32-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D32 | 0 | =C32*$B$22 | |
E32 | 0 | =C32*$B$23 | |
F32 | 0 | =IF(B32='01 Deal Setup'!$B$12,$B$25,0)+IF(C32=1,$B$24,0) | |
G32 | 0 | =SUM(D32:F32) | |
H32 | 0 | =IF(C32=1,MAX($B$26,$B$9),IF(F32>0,$B$9,0)) | |
I32 | 8 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B32>='01 Deal Setup'!$C$109,B32<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B32>='01 Deal Setup'!$C$110,B32<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B32>='01 Deal Setup'!$C$111,B32<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J32 | 0 | =MAX(0,H32-I32) | |
K32 | 0 | =IF(C32=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I32)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I32-$B$8))*$B$22/$B$7,MAX(0,H32-I32)*SUM(D32:E32)/MAX(1,H32)),0)+IF(F32>0,MAX(0,$B$9-I32)*$F32/$B$9,0) | |
L32 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G32-K32) | |
M32 | 0 | =J32*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N32 | 999 | =IF(J32>0,B32,999) | |
O32 | 0 | =IF(J32>0,B32,0) | |
P32 | - | =IF(AND(J32>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C32=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G32=0,"-","PLANNED"))) | |
B33 | 2 | ||
C33 | 0 | =IF(AND(B33>'01 Deal Setup'!$B$12,B33<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B33-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D33 | 0 | =C33*$B$22 | |
E33 | 0 | =C33*$B$23 | |
F33 | 40 | =IF(B33='01 Deal Setup'!$B$12,$B$25,0)+IF(C33=1,$B$24,0) | |
G33 | 40 | =SUM(D33:F33) | |
H33 | 4 | =IF(C33=1,MAX($B$26,$B$9),IF(F33>0,$B$9,0)) | |
I33 | 8 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B33>='01 Deal Setup'!$C$109,B33<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B33>='01 Deal Setup'!$C$110,B33<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B33>='01 Deal Setup'!$C$111,B33<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J33 | 0 | =MAX(0,H33-I33) | |
K33 | 0 | =IF(C33=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I33)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I33-$B$8))*$B$22/$B$7,MAX(0,H33-I33)*SUM(D33:E33)/MAX(1,H33)),0)+IF(F33>0,MAX(0,$B$9-I33)*$F33/$B$9,0) | |
L33 | 40 | =IF('01 Deal Setup'!$B$80="BYOC",0,G33-K33) | |
M33 | 0 | =J33*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N33 | 999 | =IF(J33>0,B33,999) | |
O33 | 0 | =IF(J33>0,B33,0) | |
P33 | PLANNED | =IF(AND(J33>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C33=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G33=0,"-","PLANNED"))) | |
B34 | 3 | ||
C34 | 1 | =IF(AND(B34>'01 Deal Setup'!$B$12,B34<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B34-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D34 | 426.6667 | =C34*$B$22 | |
E34 | 640 | =C34*$B$23 | |
F34 | 40 | =IF(B34='01 Deal Setup'!$B$12,$B$25,0)+IF(C34=1,$B$24,0) | |
G34 | 1,106.6667 | =SUM(D34:F34) | |
H34 | 8 | =IF(C34=1,MAX($B$26,$B$9),IF(F34>0,$B$9,0)) | |
I34 | 8 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B34>='01 Deal Setup'!$C$109,B34<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B34>='01 Deal Setup'!$C$110,B34<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B34>='01 Deal Setup'!$C$111,B34<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J34 | 0 | =MAX(0,H34-I34) | |
K34 | 0 | =IF(C34=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I34)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I34-$B$8))*$B$22/$B$7,MAX(0,H34-I34)*SUM(D34:E34)/MAX(1,H34)),0)+IF(F34>0,MAX(0,$B$9-I34)*$F34/$B$9,0) | |
L34 | 1,106.6667 | =IF('01 Deal Setup'!$B$80="BYOC",0,G34-K34) | |
M34 | 0 | =J34*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N34 | 999 | =IF(J34>0,B34,999) | |
O34 | 0 | =IF(J34>0,B34,0) | |
P34 | PLANNED | =IF(AND(J34>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C34=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G34=0,"-","PLANNED"))) | |
B35 | 4 | ||
C35 | 1 | =IF(AND(B35>'01 Deal Setup'!$B$12,B35<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B35-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D35 | 426.6667 | =C35*$B$22 | |
E35 | 640 | =C35*$B$23 | |
F35 | 40 | =IF(B35='01 Deal Setup'!$B$12,$B$25,0)+IF(C35=1,$B$24,0) | |
G35 | 1,106.6667 | =SUM(D35:F35) | |
H35 | 8 | =IF(C35=1,MAX($B$26,$B$9),IF(F35>0,$B$9,0)) | |
I35 | 8 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B35>='01 Deal Setup'!$C$109,B35<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B35>='01 Deal Setup'!$C$110,B35<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B35>='01 Deal Setup'!$C$111,B35<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J35 | 0 | =MAX(0,H35-I35) | |
K35 | 0 | =IF(C35=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I35)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I35-$B$8))*$B$22/$B$7,MAX(0,H35-I35)*SUM(D35:E35)/MAX(1,H35)),0)+IF(F35>0,MAX(0,$B$9-I35)*$F35/$B$9,0) | |
L35 | 1,106.6667 | =IF('01 Deal Setup'!$B$80="BYOC",0,G35-K35) | |
M35 | 0 | =J35*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N35 | 999 | =IF(J35>0,B35,999) | |
O35 | 0 | =IF(J35>0,B35,0) | |
P35 | PLANNED | =IF(AND(J35>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C35=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G35=0,"-","PLANNED"))) | |
B36 | 5 | ||
C36 | 1 | =IF(AND(B36>'01 Deal Setup'!$B$12,B36<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B36-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D36 | 426.6667 | =C36*$B$22 | |
E36 | 640 | =C36*$B$23 | |
F36 | 40 | =IF(B36='01 Deal Setup'!$B$12,$B$25,0)+IF(C36=1,$B$24,0) | |
G36 | 1,106.6667 | =SUM(D36:F36) | |
H36 | 8 | =IF(C36=1,MAX($B$26,$B$9),IF(F36>0,$B$9,0)) | |
I36 | 8 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B36>='01 Deal Setup'!$C$109,B36<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B36>='01 Deal Setup'!$C$110,B36<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B36>='01 Deal Setup'!$C$111,B36<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J36 | 0 | =MAX(0,H36-I36) | |
K36 | 0 | =IF(C36=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I36)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I36-$B$8))*$B$22/$B$7,MAX(0,H36-I36)*SUM(D36:E36)/MAX(1,H36)),0)+IF(F36>0,MAX(0,$B$9-I36)*$F36/$B$9,0) | |
L36 | 1,106.6667 | =IF('01 Deal Setup'!$B$80="BYOC",0,G36-K36) | |
M36 | 0 | =J36*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N36 | 999 | =IF(J36>0,B36,999) | |
O36 | 0 | =IF(J36>0,B36,0) | |
P36 | PLANNED | =IF(AND(J36>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C36=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G36=0,"-","PLANNED"))) | |
B37 | 6 | ||
C37 | 0 | =IF(AND(B37>'01 Deal Setup'!$B$12,B37<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B37-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D37 | 0 | =C37*$B$22 | |
E37 | 0 | =C37*$B$23 | |
F37 | 0 | =IF(B37='01 Deal Setup'!$B$12,$B$25,0)+IF(C37=1,$B$24,0) | |
G37 | 0 | =SUM(D37:F37) | |
H37 | 0 | =IF(C37=1,MAX($B$26,$B$9),IF(F37>0,$B$9,0)) | |
I37 | 8 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B37>='01 Deal Setup'!$C$109,B37<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B37>='01 Deal Setup'!$C$110,B37<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B37>='01 Deal Setup'!$C$111,B37<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J37 | 0 | =MAX(0,H37-I37) | |
K37 | 0 | =IF(C37=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I37)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I37-$B$8))*$B$22/$B$7,MAX(0,H37-I37)*SUM(D37:E37)/MAX(1,H37)),0)+IF(F37>0,MAX(0,$B$9-I37)*$F37/$B$9,0) | |
L37 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G37-K37) | |
M37 | 0 | =J37*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N37 | 999 | =IF(J37>0,B37,999) | |
O37 | 0 | =IF(J37>0,B37,0) | |
P37 | - | =IF(AND(J37>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C37=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G37=0,"-","PLANNED"))) | |
B38 | 7 | ||
C38 | 0 | =IF(AND(B38>'01 Deal Setup'!$B$12,B38<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B38-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D38 | 0 | =C38*$B$22 | |
E38 | 0 | =C38*$B$23 | |
F38 | 0 | =IF(B38='01 Deal Setup'!$B$12,$B$25,0)+IF(C38=1,$B$24,0) | |
G38 | 0 | =SUM(D38:F38) | |
H38 | 0 | =IF(C38=1,MAX($B$26,$B$9),IF(F38>0,$B$9,0)) | |
I38 | 8 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B38>='01 Deal Setup'!$C$109,B38<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B38>='01 Deal Setup'!$C$110,B38<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B38>='01 Deal Setup'!$C$111,B38<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J38 | 0 | =MAX(0,H38-I38) | |
K38 | 0 | =IF(C38=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I38)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I38-$B$8))*$B$22/$B$7,MAX(0,H38-I38)*SUM(D38:E38)/MAX(1,H38)),0)+IF(F38>0,MAX(0,$B$9-I38)*$F38/$B$9,0) | |
L38 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G38-K38) | |
M38 | 0 | =J38*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N38 | 999 | =IF(J38>0,B38,999) | |
O38 | 0 | =IF(J38>0,B38,0) | |
P38 | - | =IF(AND(J38>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C38=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G38=0,"-","PLANNED"))) | |
B39 | 8 | ||
C39 | 0 | =IF(AND(B39>'01 Deal Setup'!$B$12,B39<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B39-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D39 | 0 | =C39*$B$22 | |
E39 | 0 | =C39*$B$23 | |
F39 | 0 | =IF(B39='01 Deal Setup'!$B$12,$B$25,0)+IF(C39=1,$B$24,0) | |
G39 | 0 | =SUM(D39:F39) | |
H39 | 0 | =IF(C39=1,MAX($B$26,$B$9),IF(F39>0,$B$9,0)) | |
I39 | 8 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B39>='01 Deal Setup'!$C$109,B39<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B39>='01 Deal Setup'!$C$110,B39<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B39>='01 Deal Setup'!$C$111,B39<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J39 | 0 | =MAX(0,H39-I39) | |
K39 | 0 | =IF(C39=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I39)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I39-$B$8))*$B$22/$B$7,MAX(0,H39-I39)*SUM(D39:E39)/MAX(1,H39)),0)+IF(F39>0,MAX(0,$B$9-I39)*$F39/$B$9,0) | |
L39 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G39-K39) | |
M39 | 0 | =J39*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N39 | 999 | =IF(J39>0,B39,999) | |
O39 | 0 | =IF(J39>0,B39,0) | |
P39 | - | =IF(AND(J39>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C39=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G39=0,"-","PLANNED"))) | |
B40 | 9 | ||
C40 | 0 | =IF(AND(B40>'01 Deal Setup'!$B$12,B40<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B40-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D40 | 0 | =C40*$B$22 | |
E40 | 0 | =C40*$B$23 | |
F40 | 0 | =IF(B40='01 Deal Setup'!$B$12,$B$25,0)+IF(C40=1,$B$24,0) | |
G40 | 0 | =SUM(D40:F40) | |
H40 | 0 | =IF(C40=1,MAX($B$26,$B$9),IF(F40>0,$B$9,0)) | |
I40 | 0 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B40>='01 Deal Setup'!$C$109,B40<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B40>='01 Deal Setup'!$C$110,B40<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B40>='01 Deal Setup'!$C$111,B40<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J40 | 0 | =MAX(0,H40-I40) | |
K40 | 0 | =IF(C40=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I40)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I40-$B$8))*$B$22/$B$7,MAX(0,H40-I40)*SUM(D40:E40)/MAX(1,H40)),0)+IF(F40>0,MAX(0,$B$9-I40)*$F40/$B$9,0) | |
L40 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G40-K40) | |
M40 | 0 | =J40*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N40 | 999 | =IF(J40>0,B40,999) | |
O40 | 0 | =IF(J40>0,B40,0) | |
P40 | - | =IF(AND(J40>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C40=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G40=0,"-","PLANNED"))) | |
B41 | 10 | ||
C41 | 0 | =IF(AND(B41>'01 Deal Setup'!$B$12,B41<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B41-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D41 | 0 | =C41*$B$22 | |
E41 | 0 | =C41*$B$23 | |
F41 | 0 | =IF(B41='01 Deal Setup'!$B$12,$B$25,0)+IF(C41=1,$B$24,0) | |
G41 | 0 | =SUM(D41:F41) | |
H41 | 0 | =IF(C41=1,MAX($B$26,$B$9),IF(F41>0,$B$9,0)) | |
I41 | 0 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B41>='01 Deal Setup'!$C$109,B41<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B41>='01 Deal Setup'!$C$110,B41<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B41>='01 Deal Setup'!$C$111,B41<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J41 | 0 | =MAX(0,H41-I41) | |
K41 | 0 | =IF(C41=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I41)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I41-$B$8))*$B$22/$B$7,MAX(0,H41-I41)*SUM(D41:E41)/MAX(1,H41)),0)+IF(F41>0,MAX(0,$B$9-I41)*$F41/$B$9,0) | |
L41 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G41-K41) | |
M41 | 0 | =J41*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N41 | 999 | =IF(J41>0,B41,999) | |
O41 | 0 | =IF(J41>0,B41,0) | |
P41 | - | =IF(AND(J41>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C41=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G41=0,"-","PLANNED"))) | |
B42 | 11 | ||
C42 | 0 | =IF(AND(B42>'01 Deal Setup'!$B$12,B42<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B42-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D42 | 0 | =C42*$B$22 | |
E42 | 0 | =C42*$B$23 | |
F42 | 0 | =IF(B42='01 Deal Setup'!$B$12,$B$25,0)+IF(C42=1,$B$24,0) | |
G42 | 0 | =SUM(D42:F42) | |
H42 | 0 | =IF(C42=1,MAX($B$26,$B$9),IF(F42>0,$B$9,0)) | |
I42 | 0 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B42>='01 Deal Setup'!$C$109,B42<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B42>='01 Deal Setup'!$C$110,B42<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B42>='01 Deal Setup'!$C$111,B42<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J42 | 0 | =MAX(0,H42-I42) | |
K42 | 0 | =IF(C42=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I42)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I42-$B$8))*$B$22/$B$7,MAX(0,H42-I42)*SUM(D42:E42)/MAX(1,H42)),0)+IF(F42>0,MAX(0,$B$9-I42)*$F42/$B$9,0) | |
L42 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G42-K42) | |
M42 | 0 | =J42*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N42 | 999 | =IF(J42>0,B42,999) | |
O42 | 0 | =IF(J42>0,B42,0) | |
P42 | - | =IF(AND(J42>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C42=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G42=0,"-","PLANNED"))) | |
B43 | 12 | ||
C43 | 0 | =IF(AND(B43>'01 Deal Setup'!$B$12,B43<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B43-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D43 | 0 | =C43*$B$22 | |
E43 | 0 | =C43*$B$23 | |
F43 | 0 | =IF(B43='01 Deal Setup'!$B$12,$B$25,0)+IF(C43=1,$B$24,0) | |
G43 | 0 | =SUM(D43:F43) | |
H43 | 0 | =IF(C43=1,MAX($B$26,$B$9),IF(F43>0,$B$9,0)) | |
I43 | 0 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B43>='01 Deal Setup'!$C$109,B43<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B43>='01 Deal Setup'!$C$110,B43<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B43>='01 Deal Setup'!$C$111,B43<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J43 | 0 | =MAX(0,H43-I43) | |
K43 | 0 | =IF(C43=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I43)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I43-$B$8))*$B$22/$B$7,MAX(0,H43-I43)*SUM(D43:E43)/MAX(1,H43)),0)+IF(F43>0,MAX(0,$B$9-I43)*$F43/$B$9,0) | |
L43 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G43-K43) | |
M43 | 0 | =J43*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N43 | 999 | =IF(J43>0,B43,999) | |
O43 | 0 | =IF(J43>0,B43,0) | |
P43 | - | =IF(AND(J43>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C43=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G43=0,"-","PLANNED"))) | |
B44 | 13 | ||
C44 | 0 | =IF(AND(B44>'01 Deal Setup'!$B$12,B44<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B44-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D44 | 0 | =C44*$B$22 | |
E44 | 0 | =C44*$B$23 | |
F44 | 0 | =IF(B44='01 Deal Setup'!$B$12,$B$25,0)+IF(C44=1,$B$24,0) | |
G44 | 0 | =SUM(D44:F44) | |
H44 | 0 | =IF(C44=1,MAX($B$26,$B$9),IF(F44>0,$B$9,0)) | |
I44 | 0 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B44>='01 Deal Setup'!$C$109,B44<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B44>='01 Deal Setup'!$C$110,B44<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B44>='01 Deal Setup'!$C$111,B44<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J44 | 0 | =MAX(0,H44-I44) | |
K44 | 0 | =IF(C44=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I44)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I44-$B$8))*$B$22/$B$7,MAX(0,H44-I44)*SUM(D44:E44)/MAX(1,H44)),0)+IF(F44>0,MAX(0,$B$9-I44)*$F44/$B$9,0) | |
L44 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G44-K44) | |
M44 | 0 | =J44*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N44 | 999 | =IF(J44>0,B44,999) | |
O44 | 0 | =IF(J44>0,B44,0) | |
P44 | - | =IF(AND(J44>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C44=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G44=0,"-","PLANNED"))) | |
B45 | 14 | ||
C45 | 0 | =IF(AND(B45>'01 Deal Setup'!$B$12,B45<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B45-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D45 | 0 | =C45*$B$22 | |
E45 | 0 | =C45*$B$23 | |
F45 | 0 | =IF(B45='01 Deal Setup'!$B$12,$B$25,0)+IF(C45=1,$B$24,0) | |
G45 | 0 | =SUM(D45:F45) | |
H45 | 0 | =IF(C45=1,MAX($B$26,$B$9),IF(F45>0,$B$9,0)) | |
I45 | 0 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B45>='01 Deal Setup'!$C$109,B45<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B45>='01 Deal Setup'!$C$110,B45<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B45>='01 Deal Setup'!$C$111,B45<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J45 | 0 | =MAX(0,H45-I45) | |
K45 | 0 | =IF(C45=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I45)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I45-$B$8))*$B$22/$B$7,MAX(0,H45-I45)*SUM(D45:E45)/MAX(1,H45)),0)+IF(F45>0,MAX(0,$B$9-I45)*$F45/$B$9,0) | |
L45 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G45-K45) | |
M45 | 0 | =J45*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N45 | 999 | =IF(J45>0,B45,999) | |
O45 | 0 | =IF(J45>0,B45,0) | |
P45 | - | =IF(AND(J45>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C45=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G45=0,"-","PLANNED"))) | |
B46 | 15 | ||
C46 | 0 | =IF(AND(B46>'01 Deal Setup'!$B$12,B46<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B46-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D46 | 0 | =C46*$B$22 | |
E46 | 0 | =C46*$B$23 | |
F46 | 0 | =IF(B46='01 Deal Setup'!$B$12,$B$25,0)+IF(C46=1,$B$24,0) | |
G46 | 0 | =SUM(D46:F46) | |
H46 | 0 | =IF(C46=1,MAX($B$26,$B$9),IF(F46>0,$B$9,0)) | |
I46 | 0 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B46>='01 Deal Setup'!$C$109,B46<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B46>='01 Deal Setup'!$C$110,B46<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B46>='01 Deal Setup'!$C$111,B46<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J46 | 0 | =MAX(0,H46-I46) | |
K46 | 0 | =IF(C46=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I46)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I46-$B$8))*$B$22/$B$7,MAX(0,H46-I46)*SUM(D46:E46)/MAX(1,H46)),0)+IF(F46>0,MAX(0,$B$9-I46)*$F46/$B$9,0) | |
L46 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G46-K46) | |
M46 | 0 | =J46*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N46 | 999 | =IF(J46>0,B46,999) | |
O46 | 0 | =IF(J46>0,B46,0) | |
P46 | - | =IF(AND(J46>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C46=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G46=0,"-","PLANNED"))) | |
B47 | 16 | ||
C47 | 0 | =IF(AND(B47>'01 Deal Setup'!$B$12,B47<='01 Deal Setup'!$B$12+'01 Deal Setup'!$B$10*'01 Deal Setup'!$B$11,MOD(B47-'01 Deal Setup'!$B$12-1,'01 Deal Setup'!$B$11)=0),1,0) | |
D47 | 0 | =C47*$B$22 | |
E47 | 0 | =C47*$B$23 | |
F47 | 0 | =IF(B47='01 Deal Setup'!$B$12,$B$25,0)+IF(C47=1,$B$24,0) | |
G47 | 0 | =SUM(D47:F47) | |
H47 | 0 | =IF(C47=1,MAX($B$26,$B$9),IF(F47>0,$B$9,0)) | |
I47 | 0 | =IF('01 Deal Setup'!$B$79="No",0,IF(AND(B47>='01 Deal Setup'!$C$109,B47<='01 Deal Setup'!$D$109,'01 Deal Setup'!$F$109="Compatible",'01 Deal Setup'!$G$109='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$109,0)+IF(AND(B47>='01 Deal Setup'!$C$110,B47<='01 Deal Setup'!$D$110,'01 Deal Setup'!$F$110="Compatible",'01 Deal Setup'!$G$110='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$110,0)+IF(AND(B47>='01 Deal Setup'!$C$111,B47<='01 Deal Setup'!$D$111,'01 Deal Setup'!$F$111="Compatible",'01 Deal Setup'!$G$111='01 Deal Setup'!$B$103),'01 Deal Setup'!$B$111,0)) | |
J47 | 0 | =MAX(0,H47-I47) | |
K47 | 0 | =IF(C47=1,IF('01 Deal Setup'!$B$14="Concurrent",MAX(0,$B$8-I47)*$B$23/$B$8+MAX(0,$B$7-MAX(0,I47-$B$8))*$B$22/$B$7,MAX(0,H47-I47)*SUM(D47:E47)/MAX(1,H47)),0)+IF(F47>0,MAX(0,$B$9-I47)*$F47/$B$9,0) | |
L47 | 0 | =IF('01 Deal Setup'!$B$80="BYOC",0,G47-K47) | |
M47 | 0 | =J47*'01 Deal Setup'!$B$86*'01 Deal Setup'!$B$83 | |
N47 | 999 | =IF(J47>0,B47,999) | |
O47 | 0 | =IF(J47>0,B47,0) | |
P47 | - | =IF(AND(J47>0,OR('01 Deal Setup'!$B$80="Existing only",'01 Deal Setup'!$B$81="No")),"UNFUNDED",IF(AND(C47=1,$B$27>'01 Deal Setup'!$B$86),"SLOW CYCLE",IF(G47=0,"-","PLANNED"))) | |
A49 | 4 EXISTING VS NEW CAPACITY ECONOMICS | ||
A52 | Weeks needing new GPUs | ||
B52 | Weeks needing new GPUs | 0 | =COUNTIF(J32:J47,">0") |
C52 | Weeks needing new GPUs | weeks | |
A53 | First shortage week | ||
B53 | First shortage week | 0 | =IF(B52=0,0,MIN(N32:N47)) |
C53 | First shortage week | week | |
A54 | Last shortage week | ||
B54 | Last shortage week | 0 | =MAX(O32:O47) |
C54 | Last shortage week | week | |
A55 | Peak additional GPU units | ||
B55 | Peak additional GPU units | 0 | =MAX(J32:J47) |
C55 | Peak additional GPU units | GPUs | |
A56 | New workload GPU-hours | ||
B56 | New workload GPU-hours | 0 | =SUM(K32:K47) |
C56 | New workload GPU-hours | GPU-hours | |
A57 | Existing assigned GPU-hours | ||
B57 | Existing assigned GPU-hours | 3,360 | =SUM(L32:L47) |
C57 | Existing assigned GPU-hours | GPU-hours | |
A58 | PayGo acquisition cost | ||
B58 | PayGo acquisition cost | 0 | =B56*'01 Deal Setup'!B82+IF(B55>0,'01 Deal Setup'!B89,0) |
C58 | PayGo acquisition cost | $ | |
A59 | Weekly extension acquisition cost | ||
B59 | Weekly extension acquisition cost | 0 | =SUM(M32:M47)+IF(B55>0,'01 Deal Setup'!B89,0) |
C59 | Weekly extension acquisition cost | $ | |
A60 | New reservation committed cost | ||
B60 | New reservation committed cost | 0 | =B55*MAX('01 Deal Setup'!B85,IF(B52=0,0,B54-B53+1))*'01 Deal Setup'!B86*'01 Deal Setup'!B84+IF(B55>0,'01 Deal Setup'!B89,0) |
C60 | New reservation committed cost | $ | |
A61 | Cheapest incremental cash | ||
B61 | Cheapest incremental cash | 0 | =MIN(B58:B60) |
C61 | Cheapest incremental cash | $ | |
A62 | Selected purchase method | ||
B62 | Selected purchase method | Existing | =IF('01 Deal Setup'!B80="BYOC","BYOC",IF(B55=0,"Existing",IF('01 Deal Setup'!B80="Auto",IF(B58<=MIN(B59,B60),"PayGo",IF(B59<=B60,"Extend","Reserve")),'01 Deal Setup'!B80))) |
A63 | Cash cost of new capacity | ||
B63 | Cash cost of new capacity | 0 | =IF(OR(B62="BYOC",B62="Existing only"),0,IF(B62="PayGo",B58,IF(B62="Extend",B59,B60))) |
C63 | Cash cost of new capacity | $ | |
A64 | New GPU-hours paid / committed | ||
B64 | New GPU-hours paid / committed | 0 | =IF(B62="Extend",SUM(J32:J47)*'01 Deal Setup'!B86,IF(B62="Reserve",B55*MAX('01 Deal Setup'!B85,IF(B52=0,0,B54-B53+1))*'01 Deal Setup'!B86,IF(B62="PayGo",B56,0))) |
C64 | New GPU-hours paid / committed | GPU-hours | |
A65 | Unused new commitment hours | ||
B65 | Unused new commitment hours | 0 | =MAX(0,B64-B56) |
C65 | Unused new commitment hours | GPU-hours | |
A66 | Managerial allocation of existing | ||
B66 | Managerial allocation of existing | 8,400 | =IF(B62="BYOC",0,B57*'01 Deal Setup'!B87) |
C66 | Managerial allocation of existing | $ | |
A67 | New capacity cash exposure | ||
B67 | New capacity cash exposure | 0 | =B63 |
C67 | New capacity cash exposure | $ | |
A68 | Existing alternative-use value | ||
B68 | Existing alternative-use value | 0 | =IF(B62="BYOC",0,B57*'01 Deal Setup'!B88) |
C68 | Existing alternative-use value | $ | |
A69 | Economic decision cost (cash + opportunity) | ||
B69 | Economic decision cost (cash + opportunity) | 0 | =B67+B68 |
C69 | Economic decision cost (cash + opportunity) | $ | |
A70 | Capacity / schedule verdict | ||
B70 | Capacity / schedule verdict | FEASIBLE* | =IF(AND('01 Deal Setup'!G28="B300",'01 Deal Setup'!B103<>"B300"),"HARDWARE MISMATCH",IF(B28>16,"EXTEND CALENDAR",IF(B27>'01 Deal Setup'!B86,"SCHEDULE RISK",IF(COUNTIF(P32:P47,"UNFUNDED")>0,"UNFUNDED CAPACITY","FEASIBLE*")))) |
A72 | 5 FULL DEAL COGS (MANAGERIAL COST VIEW) | ||
A73 | Forward deployed engineering | ||
B73 | Forward deployed engineering | 28,800 | =('01 Deal Setup'!B50+B10*'01 Deal Setup'!B51)*'01 Deal Setup'!B52 |
C73 | Forward deployed engineering | $ | |
A74 | ML research engineering | ||
B74 | ML research engineering | 32,000 | =('01 Deal Setup'!B53+B10*'01 Deal Setup'!B54)*'01 Deal Setup'!B55 |
C74 | ML research engineering | $ | |
A75 | Infrastructure engineering | ||
B75 | Infrastructure engineering | 10,200 | =('01 Deal Setup'!B56+B10*'01 Deal Setup'!B57)*'01 Deal Setup'!B58 |
C75 | Infrastructure engineering | $ | |
A76 | Delivery coordination | ||
B76 | Delivery coordination | 6,000 | =('01 Deal Setup'!B59+B10*'01 Deal Setup'!B60)*'01 Deal Setup'!B61 |
C76 | Delivery coordination | $ | |
A77 | Total attributable engineering | ||
B77 | Total attributable engineering | 77,000 | =SUM(B73:B76) |
C77 | Total attributable engineering | $ | |
A78 | Graders, sandboxes and external APIs | ||
B78 | Graders, sandboxes and external APIs | 6,000 | ='01 Deal Setup'!B62+'01 Deal Setup'!B63*B10 |
C78 | Graders, sandboxes and external APIs | $ | |
A79 | Storage and networking | ||
B79 | Storage and networking | 1,500 | ='01 Deal Setup'!B64 |
C79 | Storage and networking | $ | |
A80 | Direct platform support | ||
B80 | Direct platform support | 4,000 | ='01 Deal Setup'!B65 |
C80 | Direct platform support | $ | |
A81 | GPU COGS (allocated + new cash) | ||
B81 | GPU COGS (allocated + new cash) | 8,400 | =B66+B63 |
C81 | GPU COGS (allocated + new cash) | $ | |
A82 | Base cost to deliver | ||
B82 | Base cost to deliver | 96,900 | =SUM(B77:B81) |
C82 | Base cost to deliver | $ | |
A83 | Expected rework / failure allowance | ||
B83 | Expected rework / failure allowance | 9,690 | =B82*'01 Deal Setup'!B66 |
C83 | Expected rework / failure allowance | $ | |
A84 | Risk-adjusted expected COGS | ||
B84 | Risk-adjusted expected COGS | 106,590 | =SUM(B82:B83) |
C84 | Risk-adjusted expected COGS | $ | |
A85 | COGS + opportunity view | ||
B85 | COGS + opportunity view | 106,590 | =B84+B68 |
C85 | COGS + opportunity view | $ | |
A89 | 6 RECOMMENDED PRICE / GROSS MARGIN | ||
A91 | Readiness / baseline | ||
B91 | Readiness / baseline | 30,000 | ='01 Deal Setup'!B68 |
C91 | Readiness / baseline | $ | |
A92 | Engineering and integration | ||
B92 | Engineering and integration | 78,000 | ='01 Deal Setup'!B69 |
C92 | Engineering and integration | $ | |
A93 | Authorized RL cycles | ||
B93 | Authorized RL cycles | 72,000 | =B10*'01 Deal Setup'!B70*IF('01 Deal Setup'!$G$31=1,0.65,IF('01 Deal Setup'!$G$31=2,1,2.5)) |
C93 | Authorized RL cycles | $ | |
A94 | Extra-cycle engineering | ||
B94 | Extra-cycle engineering | 0 | =MAX(0,B10-'01 Deal Setup'!B71)*'01 Deal Setup'!B72 |
C94 | Extra-cycle engineering | $ | |
A95 | Independent acceptance / handoff | ||
B95 | Independent acceptance / handoff | 30,000 | ='01 Deal Setup'!B73 |
C95 | Independent acceptance / handoff | $ | |
A96 | Negotiated discount | ||
B96 | Negotiated discount | 0 | =-SUM(B91:B95)*'01 Deal Setup'!B75 |
C96 | Negotiated discount | $ | |
A97 | Base customer proposal | ||
B97 | Base customer proposal | 210,000 | =SUM(B91:B96) |
C97 | Base customer proposal | $ | |
A98 | Target-margin price floor | ||
B98 | Target-margin price floor | 193,800 | =B84/MAX(0.01,1-'01 Deal Setup'!B76) |
C98 | Target-margin price floor | $ | |
A99 | Transparent capacity / risk adjustment | ||
B99 | Transparent capacity / risk adjustment | 0 | =MAX(0,B98-B97) |
C99 | Transparent capacity / risk adjustment | $ | |
A100 | SUGGESTED CUSTOMER QUOTE | ||
B100 | SUGGESTED CUSTOMER QUOTE | 210,000 | =SUM(B97,B99) |
C100 | SUGGESTED CUSTOMER QUOTE | $ | |
A101 | Expected deal gross margin | ||
B101 | Expected deal gross margin | 0.4924 | =IF(B100=0,0,1-B84/B100) |
C101 | Expected deal gross margin | % | |
A102 | Budget ceiling | ||
B102 | Budget ceiling | 260,000 | ='01 Deal Setup'!B22 |
C102 | Budget ceiling | $ | |
A103 | Remaining approved budget | ||
B103 | Remaining approved budget | 50,000 | =B102-B100 |
C103 | Remaining approved budget | $ | |
A104 | Commercial approval status | ||
B104 | Commercial approval status | HOLD - MODEL | =IF(OR('01 Deal Setup'!B43<=0,'01 Deal Setup'!B44<=0,'01 Deal Setup'!B45<=0,'01 Deal Setup'!B98<=0,'01 Deal Setup'!B10<1,'01 Deal Setup'!B10>10,'01 Deal Setup'!B35<0,'01 Deal Setup'!B36<0,'01 Deal Setup'!B37<0,'01 Deal Setup'!B38<0,'01 Deal Setup'!B40<0,'01 Deal Setup'!B82<0,'01 Deal Setup'!B84<0),"HOLD - INPUT",IF('01 Deal Setup'!G30<>"QUALIFIED*","HOLD - MODEL",IF(B70<>"FEASIBLE*","HOLD - CAPACITY",IF(B103<0,"HOLD - BUDGET",IF(B101<'01 Deal Setup'!B77,"HOLD - MARGIN","READY FOR REVIEW"))))) |
A109 | 7 PRODUCTION INFERENCE - SEPARATE SERVICE ORDER | ||
A111 | Input + output equivalent tokens / month | ||
B111 | Input + output equivalent tokens / month | 20,000,000 | ='01 Deal Setup'!B25*'01 Deal Setup'!B39+'01 Deal Setup'!B26 |
C111 | Input + output equivalent tokens / month | equiv tokens | |
A112 | Variable serving demand GPU-hours | ||
B112 | Variable serving demand GPU-hours | 200 | =IF(OR('01 Deal Setup'!B98<=0,B6<=0),0,B111/('01 Deal Setup'!B98*B6)) |
C112 | Variable serving demand GPU-hours | GPU-hours | |
A113 | Warm capacity floor GPU-hours | ||
B113 | Warm capacity floor GPU-hours | 1,440 | ='01 Deal Setup'!B28*720*IF('01 Deal Setup'!B24="Shared",'01 Deal Setup'!B99,1) |
C113 | Warm capacity floor GPU-hours | GPU-hours | |
A114 | Provisioned / allocated serving GPU-hours | ||
B114 | Provisioned / allocated serving GPU-hours | 1,440 | =MAX(B112,B113) |
C114 | Provisioned / allocated serving GPU-hours | GPU-hours | |
A115 | Serving GPU vendor COGS | ||
B115 | Serving GPU vendor COGS | 5,745.6 | =IF(B62="BYOC",0,B114*'01 Deal Setup'!B82) |
C115 | Serving GPU vendor COGS | $ | |
A116 | Expected monthly serving COGS | ||
B116 | Expected monthly serving COGS | 8,245.6 | =B115+'01 Deal Setup'!B97 |
C116 | Expected monthly serving COGS | $ | |
A117 | Suggested monthly serving invoice | ||
B117 | Suggested monthly serving invoice | 0 | =IF('01 Deal Setup'!B23="No",0,IF('01 Deal Setup'!B24="Shared",MAX('01 Deal Setup'!B91,MAX(0,'01 Deal Setup'!B25-'01 Deal Setup'!B95)/1000000*'01 Deal Setup'!B93+MAX(0,'01 Deal Setup'!B26-'01 Deal Setup'!B96)/1000000*'01 Deal Setup'!B94),MAX('01 Deal Setup'!B91,'01 Deal Setup'!B28*'01 Deal Setup'!B92)+MAX(0,'01 Deal Setup'!B25-'01 Deal Setup'!B95)/1000000*'01 Deal Setup'!B93+MAX(0,'01 Deal Setup'!B26-'01 Deal Setup'!B96)/1000000*'01 Deal Setup'!B94)) |
C117 | Suggested monthly serving invoice | $ | |
A118 | Pre-adjustment serving gross margin | ||
B118 | Pre-adjustment serving gross margin | 0 | =IF(B117=0,0,1-B116/B117) |
C118 | Pre-adjustment serving gross margin | % | |
A119 | Serving size / SLO validation | ||
B119 | Serving size / SLO validation | NOT SCOPED | =IF('01 Deal Setup'!B23="No","NOT SCOPED",IF('01 Deal Setup'!G26<>"Listed","HOLD - SERVING ACCESS",IF('01 Deal Setup'!B101<>"Yes","HOLD - SERVING BENCHMARK",IF('01 Deal Setup'!B27>3,"BENCHMARK PEAK FIRST","BENCHMARK / SLO SIGNOFF")))) |
A120 | Peak vs current warm capacity | ||
B120 | Peak vs current warm capacity | 0.4167 | =IF(B113=0,0,B112*'01 Deal Setup'!B27/B113) |
C120 | Peak vs current warm capacity | x | |
A121 | Scaling / re-paper recommendation | ||
B121 | Scaling / re-paper recommendation | NOT SCOPED | =IF('01 Deal Setup'!B23="No","NOT SCOPED",IF(B120>=1,"AMEND CAPACITY / REPLICAS",IF(B120>=0.8,"START SCALE REVIEW","WITHIN PLANNING ENVELOPE"))) |
A122 | Target-margin serving floor | ||
B122 | Target-margin serving floor | 0 | =IF('01 Deal Setup'!B23="No",0,B116/MAX(0.01,1-'01 Deal Setup'!B76)) |
C122 | Target-margin serving floor | $ | |
A123 | Visible production uplift | ||
B123 | Visible production uplift | 0 | =MAX(0,B122-B117) |
C123 | Visible production uplift | $ | |
A124 | SUGGESTED MONTHLY SERVING PRICE | ||
B124 | SUGGESTED MONTHLY SERVING PRICE | 0 | =B117+B123 |
C124 | SUGGESTED MONTHLY SERVING PRICE | $ | |
A125 | Expected production gross margin | ||
B125 | Expected production gross margin | 0 | =IF(B124=0,0,1-B116/B124) |
C125 | Expected production gross margin | % |
03 Offer and SOW · 127 cells, 29 formulas
| Cell | Label | Saved value | Formula |
|---|---|---|---|
A1 | CUSTOMER OFFER + STATEMENT OF WORK | ||
A2 | Customer: Example Enterprise | Workflow: Internal workflow automation | ="Customer: "&'01 Deal Setup'!B5&" | Workflow: "&'01 Deal Setup'!B6 | |
A3 | PRELIMINARY - DO NOT SEND CUSTOMER: HOLD - MODEL | =IF('02 Economics Capacity'!B104="READY FOR REVIEW","DRAFT - commercial/legal review still required","PRELIMINARY - DO NOT SEND CUSTOMER: "&'02 Economics Capacity'!B104) | |
A4 | A COMMERCIAL ORDER: WHAT THE CUSTOMER PAYS | ||
A5 | Paid service | ||
B5 | Paid service | Quantity / unit | |
C5 | Paid service | Price ($) | |
D5 | Paid service | Customer receives | |
A6 | Readiness and baseline | ||
B6 | Readiness and baseline | Once | |
C6 | Readiness and baseline | 30,000 | ='02 Economics Capacity'!B91 |
D6 | Readiness and baseline | Workflow definition, model/eval plan, baseline score and feasibility gate | |
A7 | Engineering + integration | ||
B7 | Engineering + integration | Fixed engagement | |
C7 | Engineering + integration | 78,000 | ='02 Economics Capacity'!B92 |
D7 | Engineering + integration | Harness integration, grader implementation, research and infra support | |
A8 | Approved RL cycles | ||
B8 | Approved RL cycles | Cycles x proposed model rate | |
C8 | Approved RL cycles | 72,000 | ='02 Economics Capacity'!B93 |
D8 | Approved RL cycles | Scheduled train / rollout / measure / review cycles | |
A9 | Extra-cycle engineering | ||
B9 | Extra-cycle engineering | Additional cycles only | |
C9 | Extra-cycle engineering | 0 | ='02 Economics Capacity'!B94 |
D9 | Extra-cycle engineering | Incremental assigned engineers above included loop count | |
A10 | Final independent verification | ||
B10 | Final independent verification | Once | |
C10 | Final independent verification | 30,000 | ='02 Economics Capacity'!B95 |
D10 | Final independent verification | Holdout evaluation, checkpoint, report and handoff | |
A11 | Discount | ||
B11 | Discount | Once | |
C11 | Discount | 0 | ='02 Economics Capacity'!B96 |
D11 | Discount | Explicit negotiated discount | |
A12 | Proposed price adjustment* | ||
B12 | Proposed price adjustment* | If needed | |
C12 | Proposed price adjustment* | 0 | ='02 Economics Capacity'!B99 |
D12 | Proposed price adjustment* | *Requires explicit customer agreement; not an automatic surcharge. | |
A13 | TOTAL PROPOSED TRAINING FEE | ||
C13 | TOTAL PROPOSED TRAINING FEE | 210,000 | ='02 Economics Capacity'!B100 |
A15 | Selected model | ||
B15 | Selected model | Qwen3.6-35B-A3B | ='01 Deal Setup'!B7 |
D15 | Selected model | Total params: 35.0B; MoE. Exact hardware requires benchmark. | ="Total params: "&IF(ISNUMBER('01 Deal Setup'!B8),TEXT('01 Deal Setup'!B8,"#,##0.0")&"B","unverified")&"; "&'01 Deal Setup'!G24&". Exact hardware requires benchmark." |
A16 | Authorized RL cycles | ||
B16 | Authorized RL cycles | 3 | ='01 Deal Setup'!B10 |
A17 | Cycle schedule | ||
B17 | Cycle schedule | Every 1 week(s) | ="Every "&'01 Deal Setup'!B11&" week(s)" |
A18 | Planned duration | ||
B18 | Planned duration | 6 | ='02 Economics Capacity'!B28 |
C18 | Planned duration | weeks | |
A19 | Production inference | ||
B19 | Production inference | NOT INCLUDED | =IF('01 Deal Setup'!B23="Yes","OPTIONAL SEPARATE ORDER","NOT INCLUDED") |
A21 | B OPTIONAL SERVING COMMERCIALS (NOT IN TRAINING TOTAL) | ||
A22 | Service type | ||
B22 | Service type | Dedicated | ='01 Deal Setup'!B24 |
D22 | Service type | Shared usage minimum or dedicated replica commitment | |
A23 | Monthly serving proposal | ||
B23 | Monthly serving proposal | 0 | ='02 Economics Capacity'!B124 |
D23 | Monthly serving proposal | Zero when production option is No | |
A24 | Monthly input allowance | ||
B24 | Monthly input allowance | 20,000,000 | ='01 Deal Setup'!B95 |
D24 | Monthly input allowance | Excess charged per million input tokens | |
A25 | Monthly output allowance | ||
B25 | Monthly output allowance | 10,000,000 | ='01 Deal Setup'!B96 |
D25 | Monthly output allowance | Excess charged per million output tokens | |
A26 | Peak / replica assumption | ||
B26 | Peak / replica assumption | 2 | ='01 Deal Setup'!B28 |
D26 | Peak / replica assumption | Replicas and peak traffic must be benchmarked | |
A27 | Serving next step | ||
B27 | Serving next step | NOT SCOPED | ='02 Economics Capacity'!B121 |
D27 | Serving next step | Review at 80% of capacity; amendment to add GPUs/replicas | |
A28 | Serving capacity adjustment | ||
B28 | Serving capacity adjustment | 0 | ='02 Economics Capacity'!B123 |
D28 | Serving capacity adjustment | Any added committed capacity requires a separately approved order. | |
A29 | Serving performance gate | ||
B29 | Serving performance gate | NOT SCOPED | ='02 Economics Capacity'!B119 |
D29 | Serving performance gate | Load test and service levels must be approved before contracting. | |
A30 | C SCOPE: RESPONSIBILITY, ACCEPTANCE & PHASE GATES | ||
A31 | Phase + timing | ||
B31 | Phase + timing | Applied Compute delivers | |
C31 | Phase + timing | Customer owns / approves | |
D31 | Phase + timing | Evidence to accept | |
A32 | 0 · Readiness | ||
B32 | 0 · Readiness | Scope workflow, assess data quality, compare base model options and estimate capacity. | |
C32 | 0 · Readiness | Provides data, SME and decides initial base model and success metric. | |
D32 | 0 · Readiness | Signed workflow/eval charter; dataset sample; frozen baseline score and review findings. | |
A33 | 1 · Graders + harness | ||
B33 | 1 · Graders + harness | Build environment, grader version, rollout instrumentation and held-out evaluation. | |
C33 | 1 · Graders + harness | Approves graders, thresholds, privacy assumptions and success/stop rules. | |
D33 | 1 · Graders + harness | Versioned grader/harness, reproducible baseline run ID, acceptance signoff. | |
A34 | 2 · RL cycle (repeat) | ||
B34 | 2 · RL cycle (repeat) | Train checkpoint; sample rollouts; compute cost, reward and held-out score; investigate failures. | |
C34 | 2 · RL cycle (repeat) | Reviews score and research evidence; explicitly chooses Stop or Continue. | |
D34 | 2 · RL cycle (repeat) | Checkpoint/run ID, GPU and token ledger, graded metrics, failure samples, signed cycle decision. | |
A35 | 3 · Independent handoff | ||
B35 | 3 · Independent handoff | Evaluate untouched holdout; package checkpoint/weights, traces, config, results and runbook. | |
C35 | 3 · Independent handoff | Accepts delivery by checking objective artifacts, not guaranteed quality uplift. | |
D35 | 3 · Independent handoff | Reproducibility report, model registry/version, delivered files and signed handoff. | |
A36 | 4 · Inference pilot (opt.) | ||
B36 | 4 · Inference pilot (opt.) | Benchmark representative traffic, SLO throughput, warm replicas, cost and autoscale policy. | |
C36 | 4 · Inference pilot (opt.) | Approves traffic forecast, deployment posture, SLA and commercial service order. | |
D36 | 4 · Inference pilot (opt.) | Load-test results, capacity envelope and approved serving order before production. | |
A39 | D STOPPING RULES + DECISION AUTHORITY | ||
A40 | Success score required | ||
B40 | Success score required | 0.8 | ='01 Deal Setup'!B17 |
D40 | Success score required | A score threshold, plateau, cycle cap or budget limit triggers a review; only the customer authorizes continuing/ending work. | |
A41 | Plateau trigger | ||
B41 | Plateau trigger | <1.0% gain for 2 cycles | ="<"&TEXT('01 Deal Setup'!B18,"0.0%")&" gain for "&'01 Deal Setup'!B19&" cycles" |
A42 | Max preauthorized cycles | ||
B42 | Max preauthorized cycles | 3 | ='01 Deal Setup'!B10 |
A43 | Current review status | ||
B43 | Current review status | NO RESULTS YET | ='01 Deal Setup'!G18 |
A44 | Formal decision owner | ||
B44 | Formal decision owner | Customer product / SME lead | ='01 Deal Setup'!B30 |
A47 | E AMENDMENTS AND SCALE TRIGGERS | ||
A48 | New base model or method | ||
B48 | New base model or method | Re-benchmark model fit, memory, unit rates, training throughput and evaluator comparability. | |
A49 | More cycles / higher token volume | ||
B49 | More cycles / higher token volume | Written change order before exceeding the approved cycle count or compute allowance. | |
A50 | New workflow, data regime or grader | ||
B50 | New workflow, data regime or grader | Re-scope data rights, acceptance benchmarks, engineering and deadline. | |
A51 | Different region, isolation or GPU topology | ||
B51 | Different region, isolation or GPU topology | Reassess availability, security posture, commitments and price. | |
A52 | Production launch or SLA upgrade | ||
B52 | Production launch or SLA upgrade | Separate serving order with p95/p99 target, traffic envelope, availability, and minimums. | |
A53 | Production demand exceeds contracted envelope | ||
B53 | Production demand exceeds contracted envelope | Review at 80% capacity; amendment before adding replicas, GPUs or >20% contracted traffic / concurrency. | |
A54 | Customer pause / termination | ||
B54 | Customer pause / termination | Customer covers approved work and uncancelable new supplier commitments, net of reasonable redeployment. |
04 Guide Assumptions · 532 cells, 0 formulas
| Cell | Label | Saved value | Formula |
|---|---|---|---|
A1 | USER GUIDE + ASSUMPTION REGISTER | ||
A2 | The spreadsheet is an editable prototype of a deal-underwriting product; assumptions are explicitly illustrative, not disclosed company rates. | ||
A4 | HOW TO USE (UNDER 5 MINUTES) | ||
A5 | 1 · Start | ||
B5 | 1 · Start | 01 Deal Setup | |
C5 | 1 · Start | Edit orange/blue inputs for customer, model, cycles, demand and stop rules. | |
A6 | 2 · Capacity | ||
B6 | 2 · Capacity | 01 Deal Setup rows 78-111 | |
C6 | 2 · Capacity | Enter usable GPUs per contract, valid dates (week numbers), and acquisition choice. | |
A7 | 3 · Actual evals | ||
B7 | 3 · Actual evals | 01 Deal Setup score log | |
C7 | 3 · Actual evals | Enter scores in order, then record the customer's Stop/Continue decision. This updates guidance, NOT the signed commercial commitment. | |
A8 | 4 · Economics | ||
B8 | 4 · Economics | 02 Economics Capacity | |
C8 | 4 · Economics | Review GPU-hours, weekly shortage, cash/allocated/opportunity cost and margin. | |
A9 | 5 · Client documents | ||
B9 | 5 · Client documents | 03 Offer and SOW | |
C9 | 5 · Client documents | Use the offer + SOW as review drafts. If the customer stops early, any contractual credit or re-scope requires mutual approval. | |
A10 | 6 · Decision | ||
B10 | 6 · Decision | 01 Deal Setup summary | |
C10 | 6 · Decision | Do not send pricing if HOLD, supplier unconfirmed, or quality/throughput unbenchmarked. | |
A12 | KEY MODEL EQUATIONS (SIMPLIFIED) | ||
A13 | RL rollout work | ||
B13 | RL rollout work | Attempts x (input tokens x input weight + output tokens) | |
D13 | RL rollout work | Equivalent tokens, not raw token cost | |
A14 | GPU-hours | ||
B14 | GPU-hours | (training + rollout + eval work) / separate measured GPU throughput | |
C14 | GPU-hours | Training, rollouts and each-cycle evaluations use separate benchmark throughput. | |
D14 | GPU-hours | Model-size performance affects hours | |
A15 | Required capacity | ||
B15 | Required capacity | Peak GPUs x week availability; sequential jobs reduce peaks | |
D15 | Required capacity | GPU-hours alone do not prove feasibility | |
A16 | Incremental supplier cost | ||
B16 | Incremental supplier cost | Cheapest eligible PayGo / extension / reservation on uncovered capacity | |
D16 | Incremental supplier cost | Reserved contracts charge for idle time | |
A17 | Risk-adjusted delivery COGS | ||
B17 | Risk-adjusted delivery COGS | Labor + external graders + storage + platform + allocated GPU + new commitment + expected rework | |
D17 | Risk-adjusted delivery COGS | Opportunity cost shown separately | |
A18 | Suggested customer quote | ||
B18 | Suggested customer quote | MAX(itemized fees, forecast COGS / (1-target margin)) | |
C18 | Suggested customer quote | Uplift is a proposed revised fee; client must approve before billing. | |
D18 | Suggested customer quote | Client offer row 12 explicitly requires written approval. | |
A19 | Production COGS | ||
B19 | Production COGS | MAX(token work / SLO throughput, warm-replica floor) x GPU rate + direct support | |
D19 | Production COGS | Requires benchmark; separate service agreement | |
A22 | ASSUMPTIONS - DEFAULT, JUSTIFICATION AND REQUIRED EVIDENCE | ||
F22 | ASSUMPTIONS - DEFAULT, JUSTIFICATION AND REQUIRED EVIDENCE | DOCUMENTED MODEL OPTIONS | 2026-10-18 KB SNAPSHOT + PUBLIC MODEL SPECS (NOT LIVE AC2 INVENTORY) | |
A23 | Inputs / cells | ||
B23 | Inputs / cells | Default / key assumption | |
C23 | Inputs / cells | Why used | |
D23 | Inputs / cells | Replace with / source | |
A24 | Model + sizes · B7/B8 | ||
B24 | Model + sizes · B7/B8 | Named models, total/active B, eligibility | |
C24 | Model + sizes · B7/B8 | Parameters are factual when sourced; class factor is not a performance benchmark. | |
D24 | Model + sizes · B7/B8 | Guide F:Q has model-by-model provenance; AC2 sources list named models, not exhaustive live support. | |
F24 | Model + sizes · B7/B8 | Model selection | |
G24 | Model + sizes · B7/B8 | Total params (B) | |
H24 | Model + sizes · B7/B8 | Active params (B) | |
I24 | Model + sizes · B7/B8 | Architecture | |
J24 | Model + sizes · B7/B8 | RL training | |
K24 | Model + sizes · B7/B8 | Serving | |
L24 | Model + sizes · B7/B8 | Evidence | |
M24 | Model + sizes · B7/B8 | Proxy class | |
N24 | Model + sizes · B7/B8 | HW to qualify | |
O24 | Model + sizes · B7/B8 | Parameters source / URL | |
P24 | Model + sizes · B7/B8 | AC2 catalog / URL | |
Q24 | Model + sizes · B7/B8 | Qualification note | |
A25 | Method · B9 | ||
B25 | Method · B9 | GRPO (other methods selectable; require revised COGS before approval) | |
C25 | Method · B9 | The included rollout/policy/eval formulas describe GRPO only; non-GRPO cannot be quoted from unchanged assumptions. | |
D25 | Method · B9 | Document the selected method, optimizer, workloads and benchmarked GPU efficiency; then approve revised cost model. | |
A26 | Cycles/cadence · B10:B14 | ||
B26 | Cycles/cadence · B10:B14 | 3 weekly; 2-week readiness; 1-week handoff | |
C26 | Cycles/cadence · B10:B14 | Bounded change-control program; weekly units | |
D26 | Cycles/cadence · B10:B14 | Approved customer timeline and env/runtime plan | |
F26 | Cycles/cadence · B10:B14 | Qwen3.6-35B-A3B | |
G26 | Cycles/cadence · B10:B14 | 35 | |
H26 | Cycles/cadence · B10:B14 | 3 | |
I26 | Cycles/cadence · B10:B14 | MoE | |
J26 | Cycles/cadence · B10:B14 | Listed | |
K26 | Cycles/cadence · B10:B14 | Listed | |
L26 | Cycles/cadence · B10:B14 | Model-named | |
M26 | Cycles/cadence · B10:B14 | 2 | |
N26 | Cycles/cadence · B10:B14 | Validate | |
O26 | Cycles/cadence · B10:B14 | https://huggingface.co/Qwen/Qwen3.6-35B-A3B | |
P26 | Cycles/cadence · B10:B14 | https://docs.appliedcompute.com/platform/training/models | |
Q26 | Cycles/cadence · B10:B14 | Training & serving named; illustrative benchmark only | |
A27 | Stop/go · B15:B21 | ||
B27 | Stop/go · B15:B21 | Normalized 0–1, higher-is-better score; 60% baseline / 80% target / 1 pp plateau | |
C27 | Stop/go · B15:B21 | Permits multiple metric labels without changing stop rules; lower-is-better metrics need a model redesign. | |
D27 | Stop/go · B15:B21 | Frozen held-out dataset, signed rubric, human decision | |
F27 | Stop/go · B15:B21 | Qwen3.8-27B | |
G27 | Stop/go · B15:B21 | 27 | |
H27 | Stop/go · B15:B21 | 27 | |
I27 | Stop/go · B15:B21 | Dense | |
J27 | Stop/go · B15:B21 | Listed | |
K27 | Stop/go · B15:B21 | Listed | |
L27 | Stop/go · B15:B21 | Model-named | |
M27 | Stop/go · B15:B21 | 2 | |
N27 | Stop/go · B15:B21 | Validate | |
O27 | Stop/go · B15:B21 | https://www.alibabacloud.com/help/en/model-studio/newly-released-models | |
P27 | Stop/go · B15:B21 | https://docs.appliedcompute.com/platform/training/models | |
Q27 | Stop/go · B15:B21 | Text model; compare vision model license separately | |
A28 | Deal cap · B22 | ||
B28 | Deal cap · B22 | $260k | |
C28 | Deal cap · B22 | Illustrative customer approval budget | |
D28 | Deal cap · B22 | Confirmed purchasing authority | |
F28 | Deal cap · B22 | Qwen3.5-4B | |
G28 | Deal cap · B22 | 4 | |
H28 | Deal cap · B22 | 4 | |
I28 | Deal cap · B22 | Dense | |
J28 | Deal cap · B22 | Family - verify | |
K28 | Deal cap · B22 | Not listed | |
L28 | Deal cap · B22 | Family-only | |
M28 | Deal cap · B22 | 1 | |
N28 | Deal cap · B22 | Validate | |
O28 | Deal cap · B22 | https://huggingface.co/Qwen | |
P28 | Deal cap · B22 | https://docs.appliedcompute.com/platform/training/models | |
Q28 | Deal cap · B22 | Exact training catalog entry not established | |
A29 | Production · B23:B29 | ||
B29 | Production · B23:B29 | Optional; 20M in/10M out; 2 warm replicas | |
C29 | Production · B23:B29 | Shows fixed availability cost even with low tokens | |
D29 | Production · B23:B29 | Traffic traces, latency SLO, load test | |
F29 | Production · B23:B29 | Qwen3.5-9B | |
G29 | Production · B23:B29 | 9 | |
H29 | Production · B23:B29 | 9 | |
I29 | Production · B23:B29 | Dense | |
J29 | Production · B23:B29 | Family - verify | |
K29 | Production · B23:B29 | Not listed | |
L29 | Production · B23:B29 | Family-only | |
M29 | Production · B23:B29 | 1 | |
N29 | Production · B23:B29 | Validate | |
O29 | Production · B23:B29 | https://huggingface.co/Qwen | |
P29 | Production · B23:B29 | https://docs.appliedcompute.com/platform/training/models | |
Q29 | Production · B23:B29 | Exact training catalog entry not established | |
A30 | Policy tokens · B35 | ||
B30 | Policy tokens · B35 | 42.67M / cycle | |
C30 | Policy tokens · B35 | Illustrative 128M total at 3 cycles | |
D30 | Policy tokens · B35 | Measured training profiler and step configuration | |
F30 | Policy tokens · B35 | Qwen3.5-27B | |
G30 | Policy tokens · B35 | 27 | |
H30 | Policy tokens · B35 | 27 | |
I30 | Policy tokens · B35 | Dense | |
J30 | Policy tokens · B35 | Family - verify | |
K30 | Policy tokens · B35 | Not listed | |
L30 | Policy tokens · B35 | Family-only | |
M30 | Policy tokens · B35 | 2 | |
N30 | Policy tokens · B35 | Validate | |
O30 | Policy tokens · B35 | https://huggingface.co/Qwen | |
P30 | Policy tokens · B35 | https://docs.appliedcompute.com/platform/training/models | |
Q30 | Policy tokens · B35 | Exact training catalog entry not established | |
A31 | Rollout demand · B36:B39 | ||
B31 | Rollout demand · B36:B39 | 4k attempts; 12k in/10k out; prefill 0.5 | |
C31 | Rollout demand · B36:B39 | Covers agentic token shape and asynchronous rollout work | |
D31 | Rollout demand · B36:B39 | Representative task traces; benchmark engine throughput | |
F31 | Rollout demand · B36:B39 | Qwen3.5-35B-A3B | |
G31 | Rollout demand · B36:B39 | 35 | |
H31 | Rollout demand · B36:B39 | 3 | |
I31 | Rollout demand · B36:B39 | MoE | |
J31 | Rollout demand · B36:B39 | Family - verify | |
K31 | Rollout demand · B36:B39 | Not listed | |
L31 | Rollout demand · B36:B39 | Family-only | |
M31 | Rollout demand · B36:B39 | 2 | |
N31 | Rollout demand · B36:B39 | Validate | |
O31 | Rollout demand · B36:B39 | https://huggingface.co/Qwen | |
P31 | Rollout demand · B36:B39 | https://docs.appliedcompute.com/platform/training/models | |
Q31 | Rollout demand · B36:B39 | Exact training catalog entry not established | |
A32 | Eval demand · B40:B42 | ||
B32 | Eval demand · B40:B42 | 200 cases/cycle + 200 baseline; 20k equiv tokens | |
C32 | Eval demand · B40:B42 | Recurring tests run after each RL cycle; baseline test precedes training. | |
D32 | Eval demand · B40:B42 | Grader time, API tokens, eval profile | |
F32 | Eval demand · B40:B42 | Qwen3.5-122B-A10B | |
G32 | Eval demand · B40:B42 | 122 | |
H32 | Eval demand · B40:B42 | 10 | |
I32 | Eval demand · B40:B42 | MoE | |
J32 | Eval demand · B40:B42 | Family - verify | |
K32 | Eval demand · B40:B42 | Not listed | |
L32 | Eval demand · B40:B42 | Family-only | |
M32 | Eval demand · B40:B42 | 3 | |
N32 | Eval demand · B40:B42 | Multi-node | |
O32 | Eval demand · B40:B42 | https://huggingface.co/Qwen | |
P32 | Eval demand · B40:B42 | https://docs.appliedcompute.com/platform/training/models | |
Q32 | Eval demand · B40:B42 | Large model: topology/throughput must be benchmarked | |
A33 | Throughput · B43:B48 | ||
B33 | Throughput · B43:B48 | 100k work tokens/GPU-hour; 8/8/4 GPUs | |
C33 | Throughput · B43:B48 | Backsolves an illustrative 3,360 GPUh; NOT an AC measured rate | |
D33 | Throughput · B43:B48 | AC model+SKU-specific benchmark, cluster topology | |
F33 | Throughput · B43:B48 | Qwen3.5-397B-A17B | |
G33 | Throughput · B43:B48 | 397 | |
H33 | Throughput · B43:B48 | 17 | |
I33 | Throughput · B43:B48 | MoE | |
J33 | Throughput · B43:B48 | Family - verify | |
K33 | Throughput · B43:B48 | Not listed | |
L33 | Throughput · B43:B48 | Family-only | |
M33 | Throughput · B43:B48 | 3 | |
N33 | Throughput · B43:B48 | Multi-node | |
O33 | Throughput · B43:B48 | https://huggingface.co/Qwen | |
P33 | Throughput · B43:B48 | https://docs.appliedcompute.com/platform/training/models | |
Q33 | Throughput · B43:B48 | Large model: topology/throughput must be benchmarked | |
A34 | Engineer effort/rates · B50:B61 | ||
B34 | Engineer effort/rates · B50:B61 | FDE/ML/Infra/PM hours; $150-$200/hr | |
C34 | Engineer effort/rates · B50:B61 | Fully burdened, directly attributable delivery cost | |
D34 | Engineer effort/rates · B50:B61 | Staffing plan, finance labor rates | |
F34 | Engineer effort/rates · B50:B61 | Qwen3.5-9B-VL | |
G34 | Engineer effort/rates · B50:B61 | 9 | |
H34 | Engineer effort/rates · B50:B61 | 9 | |
I34 | Engineer effort/rates · B50:B61 | Dense | |
J34 | Engineer effort/rates · B50:B61 | Listed | |
K34 | Engineer effort/rates · B50:B61 | Not listed | |
L34 | Engineer effort/rates · B50:B61 | Model-named | |
M34 | Engineer effort/rates · B50:B61 | 1 | |
N34 | Engineer effort/rates · B50:B61 | Validate | |
O34 | Engineer effort/rates · B50:B61 | https://docs.appliedcompute.com/platform/training/vlm | |
P34 | Engineer effort/rates · B50:B61 | https://docs.appliedcompute.com/platform/training/vlm | |
Q34 | Engineer effort/rates · B50:B61 | Vision inputs add image/encoder cost not captured by token-only scenario | |
A35 | External costs · B62:B66 | ||
B35 | External costs · B62:B66 | $1.5k fixed + $1.5k/cycle; $1.5k storage; $4k support; 10% rework | |
C35 | External costs · B62:B66 | Avoids GPU-only undercount and prices uncertain rework | |
D35 | External costs · B62:B66 | Vendor API invoices, object storage, historical delivery | |
F35 | External costs · B62:B66 | Qwen3.6-35B-A3B-VL | |
G35 | External costs · B62:B66 | 35 | |
H35 | External costs · B62:B66 | 3 | |
I35 | External costs · B62:B66 | MoE | |
J35 | External costs · B62:B66 | Listed | |
K35 | External costs · B62:B66 | Not listed | |
L35 | External costs · B62:B66 | Model-named | |
M35 | External costs · B62:B66 | 2 | |
N35 | External costs · B62:B66 | Validate | |
O35 | External costs · B62:B66 | https://docs.appliedcompute.com/platform/training/vlm | |
P35 | External costs · B62:B66 | https://docs.appliedcompute.com/platform/training/vlm | |
Q35 | External costs · B62:B66 | Vision workload must be separately benchmarked | |
A36 | Quote rate card · B68:B75 | ||
B36 | Quote rate card · B68:B75 | $30k readiness; $78k eng; $24k/cycle; $30k handoff | |
C36 | Quote rate card · B68:B75 | Illustrative itemized fee totaling $210k for base 3 cycles | |
D36 | Quote rate card · B68:B75 | Approved commercial rate card + customer proposal | |
F36 | Quote rate card · B68:B75 | Qwen3.8-27B-VL | |
G36 | Quote rate card · B68:B75 | 27 | |
H36 | Quote rate card · B68:B75 | 27 | |
I36 | Quote rate card · B68:B75 | Dense | |
J36 | Quote rate card · B68:B75 | Listed | |
K36 | Quote rate card · B68:B75 | Not listed | |
L36 | Quote rate card · B68:B75 | Model-named | |
M36 | Quote rate card · B68:B75 | 2 | |
N36 | Quote rate card · B68:B75 | Validate | |
O36 | Quote rate card · B68:B75 | https://docs.appliedcompute.com/platform/training/vlm | |
P36 | Quote rate card · B68:B75 | https://docs.appliedcompute.com/platform/training/vlm | |
Q36 | Quote rate card · B68:B75 | Vision workload must be separately benchmarked | |
A37 | Target margin · B76:B77 | ||
B37 | Target margin · B76:B77 | 45% target; 35% warning floor | |
C37 | Target margin · B76:B77 | Explicit quote guardrail, not company-published policy | |
D37 | Target margin · B76:B77 | Internal policy, win/loss and expansion economics | |
F37 | Target margin · B76:B77 | Qwen3.8-Flash-Next | |
G37 | Target margin · B76:B77 | 125 | |
H37 | Target margin · B76:B77 | 6 | |
I37 | Target margin · B76:B77 | MoE | |
J37 | Target margin · B76:B77 | Not listed | |
K37 | Target margin · B76:B77 | Listed | |
L37 | Target margin · B76:B77 | Model-named | |
M37 | Target margin · B76:B77 | 3 | |
N37 | Target margin · B76:B77 | Multi-node | |
O37 | Target margin · B76:B77 | https://www.chels.ai/models | |
P37 | Target margin · B76:B77 | https://docs.appliedcompute.com/platform/serving/models | |
Q37 | Target margin · B76:B77 | Serving named, training NOT confirmed; parameters provisional secondary | |
A38 | Existing supply · B79,B109:D111 | ||
B38 | Existing supply · B79,B109:D111 | 8 compatible spare GPUs weeks 1-8 | |
C38 | Existing supply · B79,B109:D111 | Shows allocation economics instead of assuming all PayGo | |
D38 | Existing supply · B79,B109:D111 | Actual inventory/region/expiry/other demand | |
F38 | Existing supply · B79,B109:D111 | Qwen3-4B | |
G38 | Existing supply · B79,B109:D111 | 4 | |
H38 | Existing supply · B79,B109:D111 | 4 | |
I38 | Existing supply · B79,B109:D111 | Dense | |
J38 | Existing supply · B79,B109:D111 | Research only | |
K38 | Existing supply · B79,B109:D111 | Not listed | |
L38 | Existing supply · B79,B109:D111 | Research-only | |
M38 | Existing supply · B79,B109:D111 | 1 | |
N38 | Existing supply · B79,B109:D111 | Validate | |
O38 | Existing supply · B79,B109:D111 | https://www.appliedcompute.com/research/neural-cheat-sheets-learning-to-summarize-with-reinforcement-learning | |
P38 | Existing supply · B79,B109:D111 | See primary source | |
Q38 | Existing supply · B79,B109:D111 | AC research use does not establish current self-serve listing | |
A39 | Supply availability · B81 | ||
B39 | Supply availability · B81 | No (unverified) | |
C39 | Supply availability · B81 | Allows scenario calculations; not an actual quota or reservation | |
D39 | Supply availability · B81 | Cloud provider availability confirmation | |
F39 | Supply availability · B81 | Qwen3-8B | |
G39 | Supply availability · B81 | 8 | |
H39 | Supply availability · B81 | 8 | |
I39 | Supply availability · B81 | Dense | |
J39 | Supply availability · B81 | Research only | |
K39 | Supply availability · B81 | Not listed | |
L39 | Supply availability · B81 | Research-only | |
M39 | Supply availability · B81 | 1 | |
N39 | Supply availability · B81 | Validate | |
O39 | Supply availability · B81 | https://www.appliedcompute.com/research/staleness-in-fully-async-rl | |
P39 | Supply availability · B81 | See primary source | |
Q39 | Supply availability · B81 | Research only; requires availability/access check | |
A40 | GPU prices · B82:B85 | ||
B40 | GPU prices · B82:B85 | $3.99 PayGo; $2.75 extend; $2.50 reserve; 4 weeks | |
C40 | GPU prices · B82:B85 | Contrasts flexibility vs stranded commitment | |
D40 | GPU prices · B82:B85 | Provider quote; https://lambda.ai/pricing is proxy only | |
F40 | GPU prices · B82:B85 | Kimi K3 | |
G40 | GPU prices · B82:B85 | 2,800 | |
H40 | GPU prices · B82:B85 | 104 | |
I40 | GPU prices · B82:B85 | MoE | |
J40 | GPU prices · B82:B85 | Listed | |
K40 | GPU prices · B82:B85 | Listed | |
L40 | GPU prices · B82:B85 | Model-named | |
M40 | GPU prices · B82:B85 | 3 | |
N40 | GPU prices · B82:B85 | B300 | |
O40 | GPU prices · B82:B85 | https://arxiv.org/abs/2607.24653 | |
P40 | GPU prices · B82:B85 | https://docs.appliedcompute.com/platform/training/models | |
Q40 | GPU prices · B82:B85 | Serving catalog requires BYO weights; AC research uses B300 multi-node | |
A41 | Allocation/opportunity · B87:B88 | ||
B41 | Allocation/opportunity · B87:B88 | $2.50 allocation; $0 opp | |
C41 | Allocation/opportunity · B87:B88 | Keeps accounting cost separate from scarce capacity decisions | |
D41 | Allocation/opportunity · B87:B88 | Finance allocation + real alternative deal contribution | |
F41 | Allocation/opportunity · B87:B88 | Kimi K2.7 Code | |
G41 | Allocation/opportunity · B87:B88 | 1,000 | |
H41 | Allocation/opportunity · B87:B88 | 32 | |
I41 | Allocation/opportunity · B87:B88 | MoE | |
J41 | Allocation/opportunity · B87:B88 | Listed | |
K41 | Allocation/opportunity · B87:B88 | Not listed | |
L41 | Allocation/opportunity · B87:B88 | Model-named | |
M41 | Allocation/opportunity · B87:B88 | 3 | |
N41 | Allocation/opportunity · B87:B88 | Multi-node | |
O41 | Allocation/opportunity · B87:B88 | https://www.kimi.ai/resources/kimi-k2-7-code | |
P41 | Allocation/opportunity · B87:B88 | https://docs.appliedcompute.com/platform/training/models | |
Q41 | Allocation/opportunity · B87:B88 | Large multi-node model; verify license and serving eligibility | |
A42 | Serving charges · B91:B99 | ||
B42 | Serving charges · B91:B99 | $15k min; $6k warm replica; per-token overage | |
C42 | Serving charges · B91:B99 | Monthly price also has a visible target-margin safeguard; not official AC rates | |
D42 | Serving charges · B91:B99 | Load tests, infra billing, SLA and commercial approval | |
F42 | Serving charges · B91:B99 | Kimi K2.6 | |
I42 | Serving charges · B91:B99 | MoE | |
J42 | Serving charges · B91:B99 | Listed | |
K42 | Serving charges · B91:B99 | Not listed | |
L42 | Serving charges · B91:B99 | Model-named | |
M42 | Serving charges · B91:B99 | 3 | |
N42 | Serving charges · B91:B99 | Multi-node | |
O42 | Serving charges · B91:B99 | https://docs.appliedcompute.com/platform/training/models | |
P42 | Serving charges · B91:B99 | https://docs.appliedcompute.com/platform/training/models | |
Q42 | Serving charges · B91:B99 | Precise weights/active count unverified in supplied material | |
A43 | Existing pool compatibility · F109:F111 | ||
B43 | Existing pool compatibility · F109:F111 | Compatible | |
C43 | Existing pool compatibility · F109:F111 | Only models qualified capacity; no mixed/incompatible clusters | |
D43 | Existing pool compatibility · F109:F111 | SKU, interconnect, region, security verification | |
F43 | Existing pool compatibility · F109:F111 | GLM-5.3 | |
G43 | Existing pool compatibility · F109:F111 | 744 | |
H43 | Existing pool compatibility · F109:F111 | 40 | |
I43 | Existing pool compatibility · F109:F111 | MoE | |
J43 | Existing pool compatibility · F109:F111 | Listed | |
K43 | Existing pool compatibility · F109:F111 | Listed | |
L43 | Existing pool compatibility · F109:F111 | Model-named | |
M43 | Existing pool compatibility · F109:F111 | 3 | |
N43 | Existing pool compatibility · F109:F111 | Multi-node | |
O43 | Existing pool compatibility · F109:F111 | https://rohitghumare.com/guides/glm-5-3/ | |
P43 | Existing pool compatibility · F109:F111 | https://docs.appliedcompute.com/platform/training/models | |
Q43 | Existing pool compatibility · F109:F111 | Verify Z.ai first-party card before binding quote | |
A44 | Model + hardware qualification | ||
B44 | Model + hardware qualification | B7 model; B8 auto params; B101:B103 approval gates; G109:G111 actual GPU family | |
C44 | Model + hardware qualification | Avoid pricing giant MoE/vision models as 32B dense hardware. No unverified quote can be READY. | |
D44 | Model + hardware qualification | Require live AC2 access, license review, actual GPU topology and workload benchmarks. | |
F44 | Model + hardware qualification | GLM-5.2 | |
G44 | Model + hardware qualification | 744 | |
H44 | Model + hardware qualification | 40 | |
I44 | Model + hardware qualification | MoE | |
J44 | Model + hardware qualification | Listed | |
K44 | Model + hardware qualification | Not listed | |
L44 | Model + hardware qualification | Model-named | |
M44 | Model + hardware qualification | 3 | |
N44 | Model + hardware qualification | Multi-node | |
O44 | Model + hardware qualification | https://www.chels.ai/models | |
P44 | Model + hardware qualification | https://docs.appliedcompute.com/platform/training/models | |
Q44 | Model + hardware qualification | Parameter count secondary; confirm model card | |
F45 | GLM-5.3-Flash | ||
I45 | GLM-5.3-Flash | Unknown | |
J45 | GLM-5.3-Flash | Not listed | |
K45 | GLM-5.3-Flash | Listed | |
L45 | GLM-5.3-Flash | Model-named | |
M45 | GLM-5.3-Flash | 3 | |
N45 | GLM-5.3-Flash | Validate | |
O45 | GLM-5.3-Flash | https://docs.appliedcompute.com/platform/serving/models | |
P45 | GLM-5.3-Flash | https://docs.appliedcompute.com/platform/serving/models | |
Q45 | GLM-5.3-Flash | No reliable parameter count in supplied KB; do not fill with guess | |
A46 | WHAT THIS MVP DOES NOT AUTOMATE (IMPORTANT) | ||
F46 | WHAT THIS MVP DOES NOT AUTOMATE (IMPORTANT) | GLM-5.3-Flash-VL | |
I46 | WHAT THIS MVP DOES NOT AUTOMATE (IMPORTANT) | Unknown | |
J46 | WHAT THIS MVP DOES NOT AUTOMATE (IMPORTANT) | Listed | |
K46 | WHAT THIS MVP DOES NOT AUTOMATE (IMPORTANT) | Not listed | |
L46 | WHAT THIS MVP DOES NOT AUTOMATE (IMPORTANT) | Model-named | |
M46 | WHAT THIS MVP DOES NOT AUTOMATE (IMPORTANT) | 3 | |
N46 | WHAT THIS MVP DOES NOT AUTOMATE (IMPORTANT) | Validate | |
O46 | WHAT THIS MVP DOES NOT AUTOMATE (IMPORTANT) | https://docs.appliedcompute.com/platform/training/vlm | |
P46 | WHAT THIS MVP DOES NOT AUTOMATE (IMPORTANT) | https://docs.appliedcompute.com/platform/training/vlm | |
Q46 | WHAT THIS MVP DOES NOT AUTOMATE (IMPORTANT) | Vision throughput and weights require explicit benchmark | |
A47 | Model catalog coverage | ||
B47 | Model catalog coverage | 30 documented examples; live AC2 catalog is NOT exhaustively verified | |
C47 | Model catalog coverage | Training and serving lists differ; family names and research examples aren't confirmed product access. | |
D47 | Model catalog coverage | Reconcile guide F:Q with live AC2 catalog and customer license before quoting. | |
F47 | Model catalog coverage | GLM-5.1 | |
I47 | Model catalog coverage | Unknown | |
J47 | Model catalog coverage | Research only | |
K47 | Model catalog coverage | Not listed | |
L47 | Model catalog coverage | Research-only | |
M47 | Model catalog coverage | 3 | |
N47 | Model catalog coverage | Validate | |
O47 | Model catalog coverage | https://www.appliedcompute.com/case-studies/harvey | |
P47 | Model catalog coverage | See primary source | |
Q47 | Model catalog coverage | Harvey case study, not verified current catalog entry | |
A48 | Parameter interpretation | ||
B48 | Parameter interpretation | Total B != active B != throughput; MoE and VLM need special care | |
C48 | Parameter interpretation | Total B approximates weight storage; active B affects per-token ops; neither guarantees training GPU cost. | |
D48 | Parameter interpretation | Model supplier cards for parameters, AC2 benchmark for costs, validated GPU topology. | |
F48 | Parameter interpretation | Nemotron 3 Ultra | |
G48 | Parameter interpretation | 550 | |
H48 | Parameter interpretation | 55 | |
I48 | Parameter interpretation | MoE | |
J48 | Parameter interpretation | Listed | |
K48 | Parameter interpretation | Listed | |
L48 | Parameter interpretation | Model-named | |
M48 | Parameter interpretation | 3 | |
N48 | Parameter interpretation | Multi-node | |
O48 | Parameter interpretation | https://github.com/NVIDIA-NeMo/Nemotron/blob/main/usage-cookbook/Nemotron-3-Ultra-Base/README.md | |
P48 | Parameter interpretation | https://docs.appliedcompute.com/platform/training/models | |
Q48 | Parameter interpretation | Large model; topology, support, and licensing review | |
A49 | Model pricing proxies | ||
B49 | Model pricing proxies | Planning class 1/2/3 with 2.5x/1x/0.5x throughput | |
C49 | Model pricing proxies | Unverified demo scenario only; not derived from true MoE FLOPs, activation memory, or GPU kernel efficiency. | |
D49 | Model pricing proxies | Block deal approval until B101/B102/B104 and GPU family B103 reviewed. | |
F49 | Model pricing proxies | Nemotron 3.5 Lightning | |
G49 | Model pricing proxies | 30 | |
H49 | Model pricing proxies | 3 | |
I49 | Model pricing proxies | MoE | |
J49 | Model pricing proxies | Not listed | |
K49 | Model pricing proxies | Listed | |
L49 | Model pricing proxies | Model-named | |
M49 | Model pricing proxies | 2 | |
N49 | Model pricing proxies | Validate | |
O49 | Model pricing proxies | https://github.com/NVIDIA-NeMo/Nemotron/blob/main/docs/nemotron/lightning35/README.md | |
P49 | Model pricing proxies | https://docs.appliedcompute.com/platform/serving/models | |
Q49 | Model pricing proxies | Serving only in the KB snapshot | |
A50 | Capacity by GPU SKU | ||
B50 | Capacity by GPU SKU | Pool G109:G111 must match planned GPU type B103 | |
C50 | Capacity by GPU SKU | Old workbook counted any manually compatible pool; now checks region/fit and GPU family. | |
D50 | Capacity by GPU SKU | Check topology/interconnect and provider quota; week-level counts still approximate. | |
F50 | Capacity by GPU SKU | Nemotron 3 Super | |
I50 | Capacity by GPU SKU | Unknown | |
J50 | Capacity by GPU SKU | Not listed | |
K50 | Capacity by GPU SKU | Legacy mention | |
L50 | Capacity by GPU SKU | Legacy-only | |
M50 | Capacity by GPU SKU | 3 | |
N50 | Capacity by GPU SKU | Validate | |
O50 | Capacity by GPU SKU | https://www.appliedcompute.com/old-home | |
P50 | Capacity by GPU SKU | See primary source | |
Q50 | Capacity by GPU SKU | Mentioned in older homepage only; not in current list | |
A51 | Production model availability | ||
B51 | Production model availability | Serving option only when selected model listed, benchmarked | |
C51 | Production model availability | Some named models have serving-only support; AC2 training catalog differs. | |
D51 | Production model availability | Separate serving order, validated load test and SLO commitment. | |
F51 | Production model availability | MiniMax M2.7 | |
G51 | Production model availability | 230 | |
H51 | Production model availability | 10 | |
I51 | Production model availability | MoE | |
J51 | Production model availability | Listed | |
K51 | Production model availability | Not listed | |
L51 | Production model availability | Model-named | |
M51 | Production model availability | 3 | |
N51 | Production model availability | Multi-node | |
O51 | Production model availability | https://github.com/vllm-project/recipes/blob/main/models/MiniMaxAI/MiniMax-M2.7.yaml | |
P51 | Production model availability | https://docs.appliedcompute.com/platform/training/models | |
Q51 | Production model availability | Supplier serving hardware may not match training | |
F52 | DeepSeek-V4.1-Flash | ||
G52 | DeepSeek-V4.1-Flash | 552 | |
H52 | DeepSeek-V4.1-Flash | 8 in / 16 out | |
I52 | DeepSeek-V4.1-Flash | MoE | |
J52 | DeepSeek-V4.1-Flash | Not listed | |
K52 | DeepSeek-V4.1-Flash | Listed | |
L52 | DeepSeek-V4.1-Flash | Model-named | |
M52 | DeepSeek-V4.1-Flash | 3 | |
N52 | DeepSeek-V4.1-Flash | Multi-node | |
O52 | DeepSeek-V4.1-Flash | https://deepseek.com/en/news/deepseek-v4-1-flash/ | |
P52 | DeepSeek-V4.1-Flash | https://docs.appliedcompute.com/platform/serving/models | |
Q52 | DeepSeek-V4.1-Flash | Input/output activate different parameter counts | |
F53 | GPT-OSS 120B | ||
G53 | GPT-OSS 120B | 116.8 | |
H53 | GPT-OSS 120B | 5.1 | |
I53 | GPT-OSS 120B | MoE | |
J53 | GPT-OSS 120B | Not listed | |
K53 | GPT-OSS 120B | Listed | |
L53 | GPT-OSS 120B | Model-named | |
M53 | GPT-OSS 120B | 3 | |
N53 | GPT-OSS 120B | Validate | |
O53 | GPT-OSS 120B | https://openai.com/index/introducing-gpt-oss/ | |
P53 | GPT-OSS 120B | https://docs.appliedcompute.com/platform/serving/models | |
Q53 | GPT-OSS 120B | Inference support documented; RL training not documented | |
A54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | ||
F54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | pplx-decider-v1-27b | |
G54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | 27 | |
I54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | Decision head | |
J54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | Access required | |
K54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | Not listed | |
L54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | Access-gated | |
M54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | 2 | |
N54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | Validate | |
O54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | https://docs.appliedcompute.com/platform/training/decisions | |
P54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | https://docs.appliedcompute.com/platform/training/models | |
Q54 | DROPDOWN INPUTS | CHOOSE PREDEFINED OPTIONS | Decision model training requires AC access | |
A55 | Training method · B9 | ||
B55 | Training method · B9 | GRPO / SFT / OPSD / RMSD / Decision / Custom | |
C55 | Training method · B9 | Only GRPO has current cost logic; other choices HOLD the quote. | |
D55 | Training method · B9 | Confirm method-specific capacity and price before approval. | |
F55 | Training method · B9 | Other open-weight model (qualify) | |
I55 | Training method · B9 | Unknown | |
J55 | Training method · B9 | Not listed | |
K55 | Training method · B9 | Not listed | |
L55 | Training method · B9 | Custom / unverified | |
M55 | Training method · B9 | 3 | |
N55 | Training method · B9 | Validate | |
O55 | Training method · B9 | https://docs.appliedcompute.com/platform/training/configuration | |
P55 | Training method · B9 | See primary source | |
Q55 | Training method · B9 | May be viable via BYO weights, but no implied support or price | |
A56 | Eval metric · B15 | ||
B56 | Eval metric · B15 | Five normalized score types (higher = better) | |
C56 | Eval metric · B15 | Stop logic still compares actual scores to target and plateau. | |
D56 | Eval metric · B15 | For latency, loss, or cost metrics, redesign stop logic. | |
A57 | Data readiness · B33 | ||
B57 | Data readiness · B33 | Validated / due kickoff / pending / unavailable | |
C57 | Data readiness · B33 | Pending or unavailable prevents customer-ready approval. | |
D57 | Data readiness · B33 | Confirm customer evidence and data-access date. | |
A58 | GPU pool fit · F109:F111 | ||
B58 | GPU pool fit · F109:F111 | Compatible / needs verification / incompatible | |
C58 | GPU pool fit · F109:F111 | Only Compatible pools count toward existing capacity. | |
D58 | GPU pool fit · F109:F111 | Validate GPU family, interconnect, region and permissions. |