AronGahagan / cpt-dev

Code repository for the ClearPlan Toolbar
https://www.ClearPlanConsulting.com
3 stars 1 forks source link

cptFiscal - fix EVT Analysis and speed up Export #300

Closed AronGahagan closed 1 year ago

AronGahagan commented 1 year ago

Problem:

  1. The FiscalPeriods formula does not fill all the way down if there is a missing (i.e., Non-LOE) EVT.
  2. The Fiscal Calendar export is too slow.

Solution:

  1. Base lngLastRow on last row of UID not EVT.
  2. Just drop the ListBox.List into the worksheet, no loops required.

Todo:

AronGahagan commented 1 year ago

Export time starting benchmark: between 4-5 seconds. Improved to <1 second.