|
|
5ec3f1d9c1
|
put target rebuild in a proc
|
2025-09-08 08:50:28 -04:00 |
|
|
|
581224dad8
|
wrap in transaction
|
2025-09-06 15:59:51 -04:00 |
|
|
|
af4c7c4853
|
change visibility level of target calculation
|
2025-09-05 08:48:42 -04:00 |
|
|
|
abac006970
|
work on filter before row number
|
2025-09-04 15:04:30 -04:00 |
|
|
|
a5a746c005
|
change visibility levels to hide target price details
|
2025-09-04 13:37:31 -04:00 |
|
|
|
fd930c9969
|
change guidance to limit to last price paid
|
2025-09-04 13:37:03 -04:00 |
|
|
|
7596038b54
|
remove price drop
|
2025-09-03 09:35:09 -04:00 |
|
|
|
1b7ec3635b
|
testing
|
2025-08-30 08:56:15 -04:00 |
|
|
|
ca2e9ea3be
|
add approval columns to quote review
|
2025-08-30 08:55:48 -04:00 |
|
|
|
a8d83cc042
|
revised run times
|
2025-08-28 09:32:32 -04:00 |
|
|
|
ad6d3d60f0
|
break our approval versus guidance logic in postgres
|
2025-08-28 09:08:51 -04:00 |
|
|
|
2cc7204c7f
|
update guidance logic to be the shown price which is great of target or last price but capped at list
|
2025-08-28 00:19:27 -04:00 |
|
|
|
e047e7f39b
|
mirror guidance logic
|
2025-08-27 23:06:59 -04:00 |
|
|
|
c5532cd2dd
|
convert to factor and clarify the logical steps
|
2025-08-27 23:06:08 -04:00 |
|
|
|
a7945999a2
|
initial rework of last price so it is clearer to review
|
2025-08-27 22:41:39 -04:00 |
|
|
|
37fead59ff
|
Merge branch 'new_targets'
|
2025-08-27 20:26:36 -04:00 |
|
|
|
42c5900efe
|
huge increase in run times
|
2025-08-27 20:06:02 -04:00 |
|
|
|
c61729e017
|
point target source to new target tables
|
2025-08-27 15:08:50 -04:00 |
|
|
|
ce77ad7de3
|
flip the labels on last quote and last sale
|
2025-08-27 15:08:33 -04:00 |
|
|
|
9a410b82d1
|
break out base target table with proper index, and create separate refresh script
|
2025-08-27 15:07:57 -04:00 |
|
|
|
6bb0172c2d
|
label parameters and adjust last to 5%
|
2025-08-27 10:45:55 -04:00 |
|
|
|
3c854ed0a4
|
repoint postgres targets to new targets
|
2025-08-27 10:31:37 -04:00 |
|
|
|
d653917c8b
|
point view to new target math
|
2025-08-27 09:53:03 -04:00 |
|
|
|
993a476bea
|
expand core targets and populate
|
2025-08-26 16:31:57 -04:00 |
|
|
|
59a28591bd
|
example with detaillevel key
|
2025-08-26 16:31:31 -04:00 |
|
|
|
a79a6d973f
|
change last price window to 18 months
|
2025-08-26 09:51:59 -04:00 |
|
|
|
11b1a3a2e4
|
only work off of actual sales, not quotes
|
2025-08-26 09:50:05 -04:00 |
|
|
|
3675b8541f
|
introduce a new key-value pair in the ui json that indicates level of visibility to various roles
|
2025-08-25 21:05:13 -04:00 |
|
|
|
2a699e8f83
|
only use actual sales for last price info in the evaluation process
|
2025-08-25 17:35:19 -04:00 |
|
|
|
f19bd138e3
|
gate the row_number function so that only target rows are processes Actuals for sales and Quotes for quotes
|
2025-08-25 17:31:37 -04:00 |
|
|
|
8974095341
|
expand the new target definition into a complete listing
|
2025-08-25 17:05:15 -04:00 |
|
|
|
6e2e806f9b
|
add sample build of new target logic
|
2025-08-21 15:35:20 -04:00 |
|
|
|
e9bd81f352
|
new table to store target price components
|
2025-08-21 15:30:08 -04:00 |
|
|
|
c77a6643b2
|
add commented out price build call
|
2025-08-21 12:01:08 -04:00 |
|
|
|
c02f7ef765
|
include base item so calculation works
|
2025-08-21 12:00:49 -04:00 |
|
|
|
1d2c2741b1
|
create function that does not compound pricing
|
2025-08-21 11:57:38 -04:00 |
|
|
|
0fdf2e9775
|
formatting
|
2025-08-21 11:08:06 -04:00 |
|
|
|
11e3f419f6
|
formatting
|
2025-08-21 11:07:14 -04:00 |
|
|
|
7067f3d1fa
|
update to reflect shown detail level
|
2025-08-18 14:36:48 -04:00 |
|
|
|
7f5994a40d
|
handle nulls
|
2025-08-18 14:36:33 -04:00 |
|
|
|
379e6a5160
|
change to 15% price reduction
|
2025-08-18 14:35:22 -04:00 |
|
|
|
b3635695e6
|
line ending or other non impact
|
2025-08-18 14:34:28 -04:00 |
|
|
|
d2f56fcafa
|
examples
|
2025-08-18 14:33:38 -04:00 |
|
|
|
f1d4d8a60b
|
cap at ceiling not working becuase _eff list was being set to null
|
2025-08-14 03:30:25 -04:00 |
|
|
|
ccf50036ca
|
work on guidance logic output text and parameterize caps and floors
|
2025-08-14 02:32:01 -04:00 |
|
|
|
c46d4c25d7
|
link in cost, rounding, target for last price should be based on last price qty
|
2025-08-14 01:50:57 -04:00 |
|
|
|
23b3962313
|
join in cost and volume, fix last price cross join
|
2025-08-14 00:50:31 -04:00 |
|
|
|
3cc82d14c0
|
last price normalization and refactor
|
2025-08-13 23:23:35 -04:00 |
|
|
|
49748383ff
|
return last part code; factor last qty into normalization, better notes on the last price sourcing
|
2025-08-13 22:23:08 -04:00 |
|
|
|
7f990ab611
|
commit: 2025-08-12 23:08:02
|
2025-08-12 23:08:02 -04:00 |
|
