Considering the current discussion around damage scaling, here is a chart I made to compare the damage output of caster and archer classes (these I thought were the most comparable because they both throw packets). This chart allows you to change assumptions and see how that affects the results (the google sheet is set to allow others to comment only; I think you should be able to make a copy of the sheet if you want to change assumptions; let me know if that doesn't work)
The parameters you can change are as follows:
Battles Per Logistics Period - Number of battles in each logistics period. A battle is assumed to last short enough that a CA batch will extend through the entire battle. Thus each "battle" can be a whole battle or a 10-minute period of a longer battle.
Arrows Used Per Battle - Number of arrows an archer uses in each battle (or each 10 minute period of a longer battle)
Arrow Hit Rate - Fraction of arrows that hit.
Spell/Wand Hit Rate - Fraction of spell/wand charges that hit (this is generally higher than the arrow hit rate, since spell/wand charges can't be blocked by shields or weapons but arrows can)
Effective Takeout Damage - Maximum health of a typical monster, such that doing this much damage to the monster is effectively a takeout. Damage dealt in excess of this in one attack is assumed to be ineffective (e.g. a 200-point slay is not any better than a 100-point slay, if the monsters have 100 hit points) and a takeout effect such as Prison counts as this much damage.
Scroll/Arrow Cost Multiplier: Multiplier of production cost that scrolls/arrows can be acquired at.
Prison Use Fraction: Scholars are normally assumed to use only the evocation bolts, but it is assumed that this fraction of the 9th level spells are Prisons rather than evocation bolts. This represents the fact that scholars have takeout effects that they can use instead of damage. For simplicity this spreadsheet only models Prisons; in the real game there are takeouts other than Prison (this makes takeouts more effective), but also monsters might be able to rip free or resist some takeouts (which makes them less effective).
Potency Use Fraction: Fraction of the spells cast at a time that a scholar has a Potency ritual active.
The different classes modeled are as follows:
Column Caster - Celestial scholar who buys nothing but spell columns. (Note this assumes 1 spell column per 25 build; the calculation may be slighhtly inaccurate below 100 build because you can't actually have 3 or fewer full spell columns)
Burst Caster - Celestial scholar who buys 4 spell columns, then switches to just buying formal levels and putting everything into Elemental Burst.
Prof/CA Archer - Archer who buy just Profs and CAs. He starts buying profs until it is no longer efficient to buy profs and then switches to buying CAs, then he goes back to buying profs again once he is getting close to having more CAs than he can use (because even using a 10 CA batch every battle won't use up all his CAs)
Slay/Evi Archer - Archer who buys the maximum amount of Slays and Eviscerates. He buys Improved Slay up to the point where the extra slay damage would be superfluous (because it would exceed the "Effective Takeout Damage").
Note that in order to model the fact that archers need to use arrows but casters don't, this spreadsheet calculates the cost of the arrows the archer would use and assumes that the caster is spending the same amount of money on 5th level damage scrolls (thus, the comparison is between archers and scholars who are spending the same amount on production items; the archer is spending it on arrows while the scholar is spending it on damage scrolls)
Spreadsheet is here:
https://docs.google.com/spreadsheets/d/13uJmXxREqozCx1hzwS4LdFLRdr9pBNEBPQ7UCOYgdT0/edit?usp=sharing
The parameters you can change are as follows:
Battles Per Logistics Period - Number of battles in each logistics period. A battle is assumed to last short enough that a CA batch will extend through the entire battle. Thus each "battle" can be a whole battle or a 10-minute period of a longer battle.
Arrows Used Per Battle - Number of arrows an archer uses in each battle (or each 10 minute period of a longer battle)
Arrow Hit Rate - Fraction of arrows that hit.
Spell/Wand Hit Rate - Fraction of spell/wand charges that hit (this is generally higher than the arrow hit rate, since spell/wand charges can't be blocked by shields or weapons but arrows can)
Effective Takeout Damage - Maximum health of a typical monster, such that doing this much damage to the monster is effectively a takeout. Damage dealt in excess of this in one attack is assumed to be ineffective (e.g. a 200-point slay is not any better than a 100-point slay, if the monsters have 100 hit points) and a takeout effect such as Prison counts as this much damage.
Scroll/Arrow Cost Multiplier: Multiplier of production cost that scrolls/arrows can be acquired at.
Prison Use Fraction: Scholars are normally assumed to use only the evocation bolts, but it is assumed that this fraction of the 9th level spells are Prisons rather than evocation bolts. This represents the fact that scholars have takeout effects that they can use instead of damage. For simplicity this spreadsheet only models Prisons; in the real game there are takeouts other than Prison (this makes takeouts more effective), but also monsters might be able to rip free or resist some takeouts (which makes them less effective).
Potency Use Fraction: Fraction of the spells cast at a time that a scholar has a Potency ritual active.
The different classes modeled are as follows:
Column Caster - Celestial scholar who buys nothing but spell columns. (Note this assumes 1 spell column per 25 build; the calculation may be slighhtly inaccurate below 100 build because you can't actually have 3 or fewer full spell columns)
Burst Caster - Celestial scholar who buys 4 spell columns, then switches to just buying formal levels and putting everything into Elemental Burst.
Prof/CA Archer - Archer who buy just Profs and CAs. He starts buying profs until it is no longer efficient to buy profs and then switches to buying CAs, then he goes back to buying profs again once he is getting close to having more CAs than he can use (because even using a 10 CA batch every battle won't use up all his CAs)
Slay/Evi Archer - Archer who buys the maximum amount of Slays and Eviscerates. He buys Improved Slay up to the point where the extra slay damage would be superfluous (because it would exceed the "Effective Takeout Damage").
Note that in order to model the fact that archers need to use arrows but casters don't, this spreadsheet calculates the cost of the arrows the archer would use and assumes that the caster is spending the same amount of money on 5th level damage scrolls (thus, the comparison is between archers and scholars who are spending the same amount on production items; the archer is spending it on arrows while the scholar is spending it on damage scrolls)
Spreadsheet is here:
https://docs.google.com/spreadsheets/d/13uJmXxREqozCx1hzwS4LdFLRdr9pBNEBPQ7UCOYgdT0/edit?usp=sharing