pt/VBA
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity

Commit Graph

  • 94bc6e2b14 add shortcut keys and pricelist csv Trowbridge 2020-01-10 14:17:16 -0500
  • 07d66cc754 build login form Paul Trowbridge 2020-01-10 11:29:50 -0500
  • 9b14ba77f5 add function to test a string array for non numeric Paul Trowbridge 2020-01-10 11:08:51 -0500
  • fdd3ce6d93 add test for invalid numbers Trowbridge 2020-01-10 11:07:40 -0500
  • 4311b3b3e4 build price list functionality pt 2020-01-09 17:53:00 -0500
  • 787c2c736f dont quote column names pt 2020-01-09 17:51:26 -0500
  • 08a64f4592 handle adjustments with -0- basis Paul Trowbridge 2019-04-03 04:45:51 -0400
  • 111121a801 add version and iter to price_calc json build; deal with non-numeric input Paul Trowbridge 2019-03-25 16:41:56 -0400
  • c38e262733 clean up Trowbridge 2019-03-25 16:04:04 -0400
  • 830894ed5d list history of changes Trowbridge 2019-03-22 18:18:23 -0400
  • 1a09f55fb9 div 0 Trowbridge 2019-03-22 10:54:21 -0400
  • 6a5782035a div 0 Trowbridge 2019-03-22 10:54:05 -0400
  • d4daa4e460 add functionality for new basket Trowbridge 2019-03-22 04:56:39 -0400
  • 0be91dd6f8 deal with text box issues, div0 and escaping Trowbridge 2019-03-22 02:02:39 -0400
  • 7d0ff997c1 hide when loading, reset adjust boxes, allow backspace to clear value Paul Trowbridge 2019-03-21 17:43:15 -0400
  • 513e6e91b7 send the new part Trowbridge 2019-03-21 16:33:22 -0400
  • 70326aa1fb error handling for request Trowbridge 2019-03-21 02:58:47 -0400
  • f6207d0586 push new part arrays back to _month, force show Trowbridge 2019-03-21 02:40:28 -0400
  • c9fff3e27e json_build should accomodate new part schema Trowbridge 2019-03-21 02:29:36 -0400
  • 5a87acc876 add function to setup for a new part on top of base scenario Paul Trowbridge 2019-03-20 17:04:30 -0400
  • 90caea49f6 use current region functionality to get range Trowbridge 2019-03-20 17:03:55 -0400
  • c5f28a081b add individual part form Trowbridge 2019-03-20 17:03:17 -0400
  • 7d2e018388 presence of volume has no impact on price change Trowbridge 2019-03-20 13:03:58 -0400
  • ae5515a83e change basket print behaviour Trowbridge 2019-03-20 12:47:01 -0400
  • f5a60c7b7c refactor basket edits, div by zero, build new Trowbridge 2019-03-20 12:07:35 -0400
  • ddbc3d0fd2 set flag on config sheet Trowbridge 2019-03-20 12:06:37 -0400
  • cf36de40b4 form changes Trowbridge 2019-03-20 12:06:03 -0400
  • f9d5aaf782 number of updates for monthly Trowbridge 2019-03-20 01:43:18 -0400
  • dc6df26eba fix basket bugs Trowbridge 2019-03-19 16:46:56 -0400
  • a3d9512373 work on editing basket Trowbridge 2019-03-19 15:43:31 -0400
  • 6a34f3fcf4 get monthly changes working Paul Trowbridge 2019-03-19 10:57:56 -0400
  • 9b8a486981 add functionality to display basket Trowbridge 2019-03-19 01:03:43 -0400
  • e7071a777c setup calculation to plug sales Trowbridge 2019-03-18 15:29:40 -0400
  • d2a9549e77 clean up Paul Trowbridge 2019-03-15 16:42:58 -0400
  • 64cb03a975 fix a bunch of stuff Paul Trowbridge 2019-03-15 16:42:27 -0400
  • 5dce331355 add formatting and start work on calcing a grand total Paul Trowbridge 2019-03-15 15:53:32 -0400
  • a444e3a08b add button to drop to worksheet Trowbridge 2019-03-15 11:10:44 -0400
  • 4c73ab5f5c cascade price instead of populating with average Trowbridge 2019-03-15 11:10:33 -0400
  • 75af4275f2 add scenario to sheet Trowbridge 2019-03-15 10:44:45 -0400
  • 67ac7d9cff get things calcuating, need to do sales based adjust Paul Trowbridge 2019-03-14 17:13:25 -0400
  • 2f56c991a7 start work on calculating months schedule Trowbridge 2019-03-14 17:08:08 -0400
  • e3bf5bdcf5 update files Trowbridge 2019-03-14 14:44:23 -0400
  • 019c83c34f export v0.5 content Trowbridge 2019-03-14 14:42:10 -0400
  • 7f3f858744 save changes through forecast v0.5 Trowbridge 2019-03-14 13:52:41 -0400
  • 42fad8ab1a add logic to build json and call api Trowbridge 2019-03-06 06:29:20 -0500
  • 6794d8ff9a handle no month situation for sales plug Trowbridge 2019-03-06 05:02:35 -0500
  • 3447f9d48c initial rework of value calc Trowbridge 2019-03-06 04:44:08 -0500
  • bbf3d84e60 rebuild monthly controls Trowbridge 2019-03-06 04:25:25 -0500
  • 856c885c44 change so price and volume edited together Trowbridge 2019-03-06 01:19:50 -0500
  • 6ad0c69c33 update monthly button controls Trowbridge 2019-03-05 17:44:02 -0500
  • 699d0fbb2e update some monthly form controls Trowbridge 2019-03-05 17:10:08 -0500
  • 93a5086160 update monthly controls Trowbridge 2019-03-05 17:09:48 -0500
  • ba99264fb6 make a bunch of adjustments Trowbridge 2019-03-05 16:18:02 -0500
  • 85c3269bcc save work Trowbridge 2019-03-05 11:41:11 -0500
  • 678c0cafc9 form updates Trowbridge 2019-03-05 11:39:35 -0500
  • 878e691a55 update changes Trowbridge 2019-03-01 15:49:59 -0500
  • 5a2dfcdf27 save work Trowbridge 2019-02-28 01:47:56 -0500
  • 953bd3548f convert variant array to string to avoid a bunch of typing Trowbridge 2019-02-27 22:13:38 -0500
  • 46f834a985 update handler Trowbridge 2019-02-27 20:34:59 -0500
  • 77aa3c3366 update pivot interpreter Trowbridge 2019-02-27 19:50:49 -0500
  • cc7a4a7e08 forecast project files Trowbridge 2019-02-27 19:49:25 -0500
  • 0da2984907 reference parent position Paul Trowbridge 2019-01-16 14:48:19 -0500
  • 144c0f85db start work on building an sql filter for a pivot table selection Paul Trowbridge 2019-01-16 13:48:18 -0500
  • f546f7c7d1 don't quote cells that look like json objects themselves Paul Trowbridge 2018-10-11 14:24:59 -0400
  • 81e7bd3f07 remove commas from numeric inputs Paul Trowbridge 2018-05-25 11:35:56 -0400
  • b03218cd4d create full sql from selection Paul Trowbridge 2018-05-25 11:27:02 -0400
  • 4755ebba5b add functions to create a text file based on range Paul Trowbridge 2017-12-08 13:48:01 -0500
  • 6d6869dc60 include upload macros from SQL Uploader R2.xlsx Paul Trowbridge 2017-12-01 12:23:27 -0500
  • c2ab8b5a4b snap to current personal.xlsb Paul Trowbridge 2017-11-06 13:27:09 -0500
  • ac530a079f add auto fit & format pivot Paul Trowbridge 2017-11-06 13:26:33 -0500
  • 553ace8eb0 dont convert to date if string is less than 6 long, also start adding commas at iteration 0 Paul Trowbridge 2017-10-17 15:09:55 -0400
  • 30e20bc420 start from 0 position of array instead of 1 in main iteration Paul Trowbridge 2017-10-02 09:58:28 -0400
  • d2e3fc3cd8 add explicit cast-null to any empty cell or cells that evaluate to Paul Trowbridge 2017-09-29 17:15:21 -0400
  • 1b2cdf854b add functions to turn column number into letter, range to transposed string array, and build string array into sql values Paul Trowbridge 2017-09-29 11:40:14 -0400
  • d886dd0f0c markdown table has min len of 3 per col Paul Trowbridge 2017-09-28 14:34:55 -0400
  • c2fc14e50b reference main library instead of duplicating code Paul Trowbridge 2017-09-28 14:28:38 -0400
  • b0c229065a add markdown_from_table, markdown_whole_sheet, json_multirange Paul Trowbridge 2017-09-28 14:26:34 -0400
  • 949c561a13 add max long function Paul Trowbridge 2017-09-28 09:26:50 -0400
  • e947cb97d7 create function maxint to return a max given to args Paul Trowbridge 2017-09-27 12:57:10 -0400
  • 7c746f7e62 change name of mark_down_from_table, create min spacing of 3 Paul Trowbridge 2017-09-27 12:55:58 -0400
  • 12e466714f add function to take multiple selections and put them into json Paul Trowbridge 2017-08-24 00:01:53 -0400
  • 3a873c9fdb add variant array to json funtion Paul Trowbridge 2017-08-24 00:00:56 -0400
  • aab361bbf3 add function to copy selection table to markdown on clipboard Paul Trowbridge 2017-08-17 10:00:18 -0400
  • b311408659 add routine to cross join highlighted ranges Paul Trowbridge 2017-07-12 11:15:50 -0400
  • bbea1976a4 adjust array size depending on headers flag and initial starting point of indexer Paul Trowbridge 2017-07-12 11:15:28 -0400
  • 317324a342 extract_pnc - convert to write straight to csv fiels Paul Trowbridge 2017-07-07 17:42:47 -0400
  • e0a7c15cfe add csv writer Paul Trowbridge 2017-07-07 17:40:19 -0400
  • 51f35f9337 Update build SQL to have a select case for each data type and add as cast to date on null Paul Trowbridge 2017-04-11 11:52:38 -0400
  • 99a5318f4d Update buildinsertSQL to comment single quotes fleetside72 2017-04-11 11:24:28 -0400
  • 730b2667d3 Update FL.bas fleetside72 2017-04-05 09:53:14 -0400
  • 51164251a5 Add files via upload fleetside72 2017-04-04 13:50:28 -0400
  • d1de671066 Initial commit fleetside72 2017-04-04 13:37:57 -0400