Johco Excel add-in
Written instructions
AI reads the request and returns checked instructions. Johco functions perform the calculations. The worksheet previews below show the values that spill from the selected cell.
Johco.Cashflow_aiMakes one or more monthly cash-flow rows. It can combine flat, bell, growing, falling, ramp, and Weibull shapes with stages, delays, dates, percentages, caps, floors, retainage, escalation, interest, and linked rows.
=Johco.Cashflow_ai("Spend $240k evenly over 12 months")| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
Johco.Absorptions_aiMakes sales, starts, and closing schedules from lot count, pace, stick size, build time, escrow time, product names, and seasonality.
=Johco.Absorptions_ai("48 lots selling at 4 per month")| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |
Direct formulas
These functions perform calculations directly. The examples use small inputs so the complete spill range is visible.
Johco.Absorptions.SalesCreates a sales schedule from pace and total lots.
=Johco.Absorptions.Sales(4,10)| A | B | C | |
|---|---|---|---|
| 1 | 4 | 4 | 2 |
Johco.Absorptions.StartsAligns sales to construction stick packs. Without a stick schedule, it returns the sales schedule.
=Johco.Absorptions.Starts({4,4,2},{6,4})| A | B | C | |
|---|---|---|---|
| 1 | 6 | 4 | 0 |
Johco.Absorptions.ClosingsPlaces closings when both the sale and completed start are available, using build and escrow months.
=Johco.Absorptions.Closings({4,4,2},{6,4,0},2,1)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 0 | 0 | 6 | 4 | 0 |
Johco.Absorptions.CumulativeChanges periodic values into running totals.
=Johco.Absorptions.Cumulative({1,2,3,4})| A | B | C | D | |
|---|---|---|---|---|
| 1 | 1 | 3 | 6 | 10 |
Johco.Absorptions.DecumulativeChanges running totals back into periodic values.
=Johco.Absorptions.Decumulative({1,3,6,10})| A | B | C | D | |
|---|---|---|---|---|
| 1 | 1 | 2 | 3 | 4 |
Johco.Absorptions.SeasonalizeApplies a repeating 12-month seasonal pattern while preserving the total.
=Johco.Absorptions.Seasonalize({1,1,1,1,1,1,1,1,1,1,1,1},6,0.5)| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.33 | 0.60 | 0.97 | 1.37 | 1.67 | 1.79 | 1.67 | 1.37 | 0.97 | 0.60 | 0.33 | 0.33 |
Johco.Cashflow.Scheduled_spendPlaces stated values at zero-based period positions and fills the periods between them with zero.
=Johco.Cashflow.Scheduled_spend({200,300,500},{0,2,4})| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 200 | 0 | 300 | 0 | 500 |
Johco.Cashflow.Bell_curveSpreads a total across a bell-shaped schedule with selectable slope and center.
=Johco.Cashflow.Bell_curve(5,1000,0.5,3)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | $51.97 | $243.88 | $408.30 | $243.88 | $51.97 |
Johco.Cashflow.Tailed_curveSpreads a total across a straight-sided rise and fall with a selectable peak.
=Johco.Cashflow.Tailed_curve(5,1000,0.5)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | $0 | $250 | $500 | $250 | $0 |
Johco.Cashflow.Linear_curveSpreads a total across a linear ramp.
=Johco.Cashflow.Linear_curve(5,1000,0.5)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | $100 | $150 | $200 | $250 | $300 |
Johco.Cashflow.Exponential_curveSpreads a total across an exponential growth or reversed decay schedule.
=Johco.Cashflow.Exponential_curve(5,1000,0.5)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | $39.90 | $74.55 | $139.27 | $260.19 | $486.10 |
Johco.Cashflow.Logarithmic_curveSpreads a total across a fast-rising schedule that tapers over time.
=Johco.Cashflow.Logarithmic_curve(5,1000,0.5)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | $0.00 | $166.26 | $236.58 | $281.85 | $315.30 |
AI can misread timing, units, signs, names, or links. Data may be late, incomplete, or wrong. Check inputs, totals, dates, formulas, and source records before using an output in a decision.