Joel WhiteNov 14, 20231 min100 Thoughts on Pricing: #77Optimizing for T&Ms: Hourly retainers can be made nonrefundable. The shorter the engagement, the more you should insist on these terms....
Joel WhiteNov 13, 20231 min100 Thoughts on Pricing: #76Moving on from pricing tools to T&Ms (hourly contracts)... Optimizing for T&Ms: If you're going to charge by the hour, at least bill for...
Joel WhiteNov 10, 20231 min100 Thoughts on Pricing (Tools): #75I recently mentioned conditional formatting as perhaps the Excel functionality I've most increased my use of it in pricing tools. The...
Joel WhiteNov 9, 20231 min100 Thoughts on Pricing (Tools): #74Here are some of the most common VBA/macro coding problems I find in Excel pricing tools: direct cell references (e.g., cell "E5") that...
Joel WhiteNov 8, 20231 min100 Thoughts on Pricing (Tools): #73Despite the drawbacks of macros in Excel pricing tools, what are some of the navigation improvements they work well for? for complex...
Joel WhiteNov 7, 20231 min100 Thoughts on Pricing (Tools): #72I view Excel VBA macros in pricing tools as the last-ditch option for functionality that simply cannot be programmed through normal Excel...
Joel WhiteNov 6, 20231 min100 Thoughts on Pricing: #71Here's how I typically structure the Excel VBA code for client exports: turn off screen flickering so the user doesn't see the screen fly...
Joel WhiteNov 2, 20231 min100 Thoughts on Pricing: #70Excel based pricing tools also suffer from lack of workflow automation, data analytics, and continuous integration with other company...
Joel WhiteNov 1, 20231 min100 Thoughts on Pricing: #69Excel based pricing tools certainly have their disadvantages compared to web based tools, chief among those information security. Any...