How was the LBT born?
By AMO
In 2019, a former colleague, Xavier, reached out to me.
He remembered that on the Ifremer project, I had personal tools. One tool extracted payroll categories, and another was capable of reconstructing the hierarchy of a category.
Having since joined a client teams, he needed a similar tool to get ready to migrate towards HR4You: together, we built what would become the LBT, the Technical White Book.
For Xavier, the LBT allowed him to approach the project preparation phase, to identify what he wanted to see discontinued, harmonized, or continued. He was able to identify obsolete categories by comparing the LBT with a count of categories from the PRDB by year.
In 2021, during a necessary “pause” phase, I remembered the second part, the one capable of reconstructing the hierarchy. I redeveloped it, this time in VBA Excel, to be compatible with any client situation.
In early 2023, Xavier, in the midst of project kickoff, reached out to me again: he needed help. I provided it to him, and I also gave him the VBA version of the LBT. We enhanced this tool with the functionalities presented here: automated impact study (with criteria meaningful to a payroll manager), comparison of delivered regulations, association of configuration with valued elements.
We turned it into a productivity tool.