PhilRunninger
86225ea7e5
Get pounds to update for each forecast adjustment.
...
Lots of cleanup here too, removing large swaths of code that are no
longer needed. Many improvements the Excel workbook, which is kept in
Teams, not git. These changes may or may not have had accompanying VBA
changes.
2023-04-27 16:54:37 -04:00
Paul Trowbridge
ef8a21d319
update rebuild script
2023-03-08 08:48:02 -05:00
Paul Trowbridge
5e7ad3b208
swap everything for a 2109 baseline
2023-03-07 16:45:55 -05:00
Paul Trowbridge
6f88ed618d
include all foreast since the piece labeled actuals actually forms a current year forecast
2023-03-07 15:44:25 -05:00
Paul Trowbridge
d79feebaa5
dont load anything to staged forecast that has "actuals" in it
2023-03-07 15:27:33 -05:00
Paul Trowbridge
0ae9f604c1
change version to b23
2023-03-07 12:39:30 -05:00
Paul Trowbridge
a0c5482f6c
update convert pool to target osmfs in its current state
2023-03-07 11:44:22 -05:00
PhilRunninger
bd8aa18208
Merge branch 'dev' of github.com:The-HC-Companies/forecast_api into dev
2023-03-01 18:00:18 -05:00
PhilRunninger
ed5975daf7
Switch source table from rlarp.itemmv to "CMS.CUSLG".itemm
2023-03-01 17:55:30 -05:00
Paul Trowbridge
fd4079cb17
clean up
2023-03-01 16:32:52 -05:00
Paul Trowbridge
e5db7372a1
repoint snaps
2023-03-01 16:07:36 -05:00
Paul Trowbridge
7d901e7f42
new forecast baseline dates
2023-03-01 16:01:32 -05:00
Paul Trowbridge
68aa1c219a
updates
2023-02-24 19:28:14 -05:00
Paul Trowbridge
e73d69ad65
include pool ddl
2023-02-15 14:21:49 -05:00
Paul Trowbridge
a66ec61aaf
increment iteration name to reflect period
2021-08-03 13:33:37 -04:00
Paul Trowbridge
2253d65047
group by percentage of row to keep, and filter out -0-
2021-08-03 08:26:05 -04:00
Paul Trowbridge
752aeffa06
add notes and create an adjustment based on a percentage for lines where not all is pullforward
2021-08-02 15:46:43 -04:00
Paul Trowbridge
fc8f9592b8
incrememnt periods
2021-08-02 15:45:27 -04:00
Paul Trowbridge
b2147b0a02
increment snapshot period
2021-07-30 08:15:48 -04:00
Paul Trowbridge
f8bf1518f9
exclude the 'actual' iteration from the output forecast since it only exists for the benefit of osm_pool review
2021-07-15 16:53:48 -04:00
Paul Trowbridge
b831dfc35e
incraease range and modify pull-forward logic to operate off an explicit overlap period
2021-07-15 16:53:21 -04:00
Paul Trowbridge
6e7f45a010
isolate and remove pull-forward as an iteration
2021-07-14 15:46:58 -04:00
Paul Trowbridge
e50113f825
comment out debug selections
2021-07-14 15:45:39 -04:00
Paul Trowbridge
8e8cd605b2
revert back to old dates on rolling and start working on pull-forward removal
2021-07-12 17:55:13 -04:00
Paul Trowbridge
7de60f37ce
include plan all the way back from 2021
2021-07-12 15:54:10 -04:00
Paul Trowbridge
0e3e1205df
comments and version name
2021-07-12 15:37:52 -04:00
Paul Trowbridge
1c5b17daa0
update pool component to reset the log file and sequence for a new forecast
2021-07-12 15:34:50 -04:00
Paul Trowbridge
a5dc4aaa85
group the actuals so the timestamp on the update is excluded
2021-07-12 14:48:31 -04:00
Paul Trowbridge
652257fbf0
revised for new rolling forecast approach
2021-07-12 14:32:03 -04:00
Paul Trowbridge
df12babf00
update approach and date range
2021-07-12 14:31:22 -04:00
Paul Trowbridge
c9d87ffccb
rename script
2021-07-12 14:28:28 -04:00
Paul Trowbridge
39dc65ab9c
immediately insert the forecast pool to the live pool
2021-07-12 14:27:05 -04:00
Paul Trowbridge
391e6bf09a
rename files to reflect intent
2021-07-12 11:32:52 -04:00
Paul Trowbridge
3393136148
move inquiries to their own folder
2021-07-12 10:52:25 -04:00
Paul Trowbridge
1a6121d564
get rid of more old one-off scripts
2021-07-12 10:46:40 -04:00
Paul Trowbridge
a498b79630
get rid of old approach scripts
2021-07-12 10:30:39 -04:00
Paul Trowbridge
7c7f5b581c
get rid of old scripts, or even slightly old scripts
2021-07-12 10:26:38 -04:00
Paul Trowbridge
b9c6c64764
back to original stage file
2021-07-09 16:18:01 -04:00
Paul Trowbridge
7f8ed574c5
work on 1+11
2021-07-09 16:14:29 -04:00
Paul Trowbridge
f3f7b7a177
work on a new forecast approach
2021-07-09 00:54:44 -04:00
Paul Trowbridge
f8a96d6df2
work on 1+11 forecast
2021-07-06 09:33:58 -04:00
Paul Trowbridge
11f6ae2e42
work on making sales adjustments
2021-06-25 09:36:35 -04:00
Paul Trowbridge
08e768eb22
update target range latest forecast
2021-06-02 09:00:25 -04:00
Paul Trowbridge
d129e5d0f6
add a column for the tag
2021-05-17 14:44:40 -04:00
Paul Trowbridge
4f33136a15
style code was not getting set as part of the item master snap
2021-05-13 13:54:42 -04:00
Paul Trowbridge
032736f0e9
convert script to live db and do rounding on final build
2021-05-03 12:33:34 -04:00
Paul Trowbridge
f2b6686f3e
insert directly into the pool and igonore net cost amount as a filter
2021-05-03 09:09:21 -04:00
Paul Trowbridge
e79c0d5bb4
round before removing, keep any rows that have a qty, value, or cost
2021-04-30 11:25:44 -04:00
Paul Trowbridge
36d80dd296
relable actuals later as copy so it is considered part of the baseline
2021-04-29 18:25:09 -04:00
Paul Trowbridge
8de3ee5717
fiscal period was blank cause rows not to net to -0- with merge, iteration name incorrect for baseline
2021-04-29 16:12:54 -04:00