This website requires JavaScript.
95cc855722
current state personal macrobook
Paul Trowbridge
2024-09-24 11:40:58 -0400
7d0b38e46a
current state of Core List
Paul Trowbridge
2024-09-24 11:40:04 -0400
3a83430fc2
shift columns
Paul Trowbridge
2024-09-24 11:39:22 -0400
ec9d2f380a
shift
Paul Trowbridge
2024-09-24 11:37:08 -0400
acfef56c16
copy from personal macrobook
Paul Trowbridge
2024-09-24 11:35:18 -0400
5fe9056aac
updates
Paul Trowbridge
2024-09-24 09:29:02 -0400
40b02b2bc5
merge latest updates
Paul Trowbridge
2024-03-05 08:36:02 -0500
faf78de0c5
vault backup: 2024-02-19 10:59:47
Paul Trowbridge
2024-02-19 10:59:47 -0500
e2533d2c45
vault backup: 2024-02-19 10:59:09
Paul Trowbridge
2024-02-19 10:59:09 -0500
758f35cecd
handle empty diretories and point to new server
Paul Trowbridge
2023-09-19 12:00:34 -0400
da1df9337c
only close the workbook if there are no more tabs left
Paul Trowbridge
2023-05-22 15:36:18 -0400
0f7b5db8b8
include currency in name of full code file
Paul Trowbridge
2023-05-22 12:07:26 -0400
015f2679f9
convert fullcode to pdf
Paul Trowbridge
2023-05-22 11:41:09 -0400
414c044fc0
updates
Paul Trowbridge
2023-05-05 12:57:57 -0400
4e5cf05396
getcsv
Paul Trowbridge
2023-05-05 12:54:02 -0400
0b8e18e666
updates
Paul Trowbridge
2023-04-27 07:36:19 -0400
4f45a6b3f3
point to new server, and use new function formula2r1c1
Paul Trowbridge
2023-01-05 14:13:29 -0500
220116c67d
latest forms
Paul Trowbridge
2022-12-20 10:13:36 -0500
9fb5ad9c93
pivot table shortcuts
Paul Trowbridge
2022-12-20 10:13:26 -0500
87f42ff5fd
update ports
Paul Trowbridge
2022-12-20 10:13:08 -0500
2d5e32b123
unknown
Paul Trowbridge
2022-12-20 10:12:38 -0500
56e00d7d5c
update ports
Paul Trowbridge
2022-12-20 10:09:55 -0500
d75cb849e8
update ports
Paul Trowbridge
2022-12-20 10:07:03 -0500
8d339f6361
update price level UI
Paul Trowbridge
2022-08-04 16:47:57 -0400
a55b719e94
update issues upload to merge and to target db2
Paul Trowbridge
2022-08-04 16:47:39 -0400
24b91e4fb5
adjust page breaks based on row heights, export to pdf
Paul Trowbridge
2022-06-29 17:12:00 -0400
48670f9ca7
change logo source and update list filters to include protective packaging
Paul Trowbridge
2022-06-16 10:34:34 -0400
7bc46ca5d9
add tabs per segment if selected
Paul Trowbridge
2022-06-09 15:11:52 -0400
e377d8287b
make a checkbox to format customer list as numeric
Paul Trowbridge
2022-06-01 16:32:23 -0400
edcd42947f
add user-defined Excel function and add function to parse strings into arrays
Paul Trowbridge
2022-06-01 15:24:29 -0400
e277b326c7
formatting and add checkboxes to form
Paul Trowbridge
2022-05-27 00:26:36 -0400
efd470bce3
clean up
Paul Trowbridge
2022-05-20 13:12:21 -0400
69af558e8b
clean up and move code to core list file
Paul Trowbridge
2022-05-20 12:38:56 -0400
a788a91424
fullcode layout changes
Paul Trowbridge
2022-05-19 11:46:05 -0400
c66e05c29e
build full code list
Paul Trowbridge
2022-05-18 12:58:40 -0400
1c6a6cc848
create page breaks for notes and dont do coloring. manually set all the page breaks
Paul Trowbridge
2022-05-17 16:26:20 -0400
aee26ac1a3
work on price lists
Paul Trowbridge
2022-05-17 10:33:24 -0400
8034d1859f
adjust to simple grouping operation
Paul Trowbridge
2022-05-12 17:40:49 -0400
b1a4d149d3
currency, save file, and eff date
Paul Trowbridge
2022-05-12 17:39:53 -0400
b96be55725
include print setup for price list build. filter out -0- for plcore upload
Paul Trowbridge
2022-05-12 13:41:12 -0400
22af739ffb
more formatting
Paul Trowbridge
2022-05-12 12:38:56 -0400
261aece1ad
turn of screen updating for test; start work on building price list file
Paul Trowbridge
2022-05-12 10:09:53 -0400
ed4c795a40
clear page breaks
Paul Trowbridge
2022-05-12 10:07:54 -0400
e2315d3a16
add json and skip regex for ranged sql building
Paul Trowbridge
2022-05-06 16:38:33 -0400
06990fd7dd
add new parameter for handling empty cells
Paul Trowbridge
2022-05-05 13:48:16 -0400
b4b3b7a25a
cat empty to null depending on new flag
Paul Trowbridge
2022-05-05 09:38:13 -0400
1020edb0e3
add variable declaration
Paul Trowbridge
2022-04-29 08:22:33 -0400
44555a7f13
resource price list info
2022-04-28 13:00:02 -0400
050eb881cb
include another new column for compatable items
Paul Trowbridge
2022-04-11 08:43:56 -0400
b1c21d57ea
work on core price list
Paul Trowbridge
2022-04-07 12:39:00 -0400
4dc88d8faf
plcore upload, and in-spreadsheet evaluation (Extract)
Paul Trowbridge
2022-04-01 16:31:23 -0400
eb630686aa
create new isolated module for working with price lists
Paul Trowbridge
2022-03-31 17:39:08 -0400
3ce9b371ca
include a new data type flag to prevent running regex on special characters that should be retained instead of removed
Paul Trowbridge
2022-03-31 12:35:18 -0400
283e79714b
utilize new sql function
Paul Trowbridge
2022-02-09 10:56:13 -0500
061dcbd9f4
add function
Paul Trowbridge
2022-02-09 10:55:59 -0500
a448efe0b1
shift everything to the right to accommodate weight, include postgres only merge for testing
Paul Trowbridge
2021-11-08 16:40:50 -0500
33c49f3463
accomodate an update to the stored proc that returns accessories list
Paul Trowbridge
2021-10-14 09:50:59 -0400
0f8a560b4b
work with target price generation
Paul Trowbridge
2021-10-07 18:28:15 -0400
539a966e1c
convert input box on cross joining to range selector
Paul Trowbridge
2021-08-16 09:17:52 -0400
945863353e
customized ribbon
Paul Trowbridge
2021-08-16 09:16:55 -0400
79443856c5
increment PW
Paul Trowbridge
2021-08-13 11:01:28 -0400
d78f665533
upload product groups
Paul Trowbridge
2021-08-13 11:01:12 -0400
34984de260
updates to nursery regional parsing
Paul Trowbridge
2021-08-13 10:34:20 -0400
c80e5296d1
add 2 subroutines and SQL formatting
Paul Trowbridge
2021-06-16 09:03:23 -0400
0101b45e8a
set header values, wrap the sql in a commit block, close the connection
Paul Trowbridge
2021-03-15 16:02:45 -0400
b1328fac50
load table pcore from sheet contents
Paul Trowbridge
2021-03-15 15:41:44 -0400
fac0a38977
optional param for pre-determined column types to be supplied instead of guessing
Paul Trowbridge
2021-03-15 15:40:43 -0400
605a1e95b0
update price list to just pull description columns
2020-12-02 11:53:21 -0500
0143a891bb
rework the coloring a bit
2020-11-06 14:48:49 -0500
9dcf8ac310
get rid of suffix column and include use accs instead of kit
Paul Trowbridge
2020-10-28 11:22:14 -0400
cc4bd12720
updates
Paul Trowbridge
2020-09-15 13:02:06 -0400
4c0ceb334e
add another iteration of the price list logic
Paul Trowbridge
2020-07-14 16:06:44 -0400
d10a15f113
live check of price list against lgdat records to test if inbound charges are new or update
Paul Trowbridge
2020-06-25 16:58:13 -0400
c14ba755f8
ignore
Paul Trowbridge
2020-06-23 15:44:20 -0400
17b974a940
move colors to columns, and update the highlighting
Paul Trowbridge
2020-06-23 15:41:59 -0400
64c7be2587
finalize to get 1.5 done
2020-03-13 17:31:48 -0400
7182502669
list of parts to change not wrapped in an array if only one row
2020-03-06 00:33:24 -0500
19021da028
price volume colors
2020-03-06 00:32:12 -0500
7e57d4621f
add a new route for swapping out parts
2020-03-05 01:08:10 -0500
f569e6238d
version 1.4
2020-03-03 23:22:13 -0500
043c7264bf
various changes
2020-02-25 10:56:18 -0500
1ca398bb8e
minor updates
2020-02-19 23:03:48 -0500
8e467677c4
add customized ribbon
2020-02-19 11:44:29 -0500
988f72996a
accomodate tagging
2020-02-18 17:04:03 -0500
ce6461007a
loop thorugh each month line to add the tag/comment to the doc
2020-02-18 02:56:37 -0500
501fa5f4e6
monthly comments and tags
2020-02-18 02:07:38 -0500
3b3785dbd8
add undo and comments
2020-02-14 17:24:02 -0500
3932e224f0
lot of changes
2020-02-14 02:27:01 -0500
3c646b3a8d
add rounding, increment year, dont hardcode plan
2020-02-13 02:23:13 -0500
44ef2f5dc5
add characters
2020-02-13 02:19:15 -0500
4b6d0c744d
accomodate new sql builder parameters, and test for presence of price sheet
2020-01-29 13:31:32 -0500
99905a9341
use regex to better parse data for SQL loading
2020-01-29 13:30:53 -0500
022240f8d3
update price list build to include status and stocked
2020-01-15 17:17:07 -0500
b4291d15e7
rework logic to hook off of color indicator supplied instead of using first 11
2020-01-15 11:41:19 -0500
79e3c24a37
utf-8 was causing strange characters in CMS, should make a param
2020-01-13 17:26:32 -0500
35f5b04a1d
use unit of measure to translate volume breaks, change default upload function to add
2020-01-13 17:25:22 -0500
56bb03ce7d
default action is 1
2020-01-13 17:24:24 -0500
aa88dbc9e7
upper bound was wrong
2020-01-13 17:23:39 -0500
f825c61b62
add some array handling
2020-01-10 14:17:57 -0500
733d65881e
build pricelist csv
2020-01-10 14:17:29 -0500
Paul Trowbridge
pt
Trowbridge