fbpx

Projets Ingénieurs

#PI²4 Automation of Closing Inventory Tasks



PI²4 2021-2022: Industrial Innovation Project for the 4th year of the engineering curriculum ESILV ► https://bit.ly/2NtRKuL

Each year, the inventory team must conduct the closing inventory at the end of December. To do this, they must complete the various steps of the process in less than two weeks. Most of them are done manually and the goal is to make as few mistakes as possible.

Our mission is to automate Excel files with VBA. In the long run, the goal was to automate all actions taken, such as importing and harmonizing data or correcting erroneous data.

We were separated to work on different tasks. We had to do as many tasks as possible, but we knew very little about VBA at the beginning. The partner provided us with computers and created a team, where we could easily communicate, ask questions and present our work. We could approach them at any time, even outside the Tuesday morning slot, if needed.

Quality was prioritized over quantity: our code had to be complete, clear, robust, usable, and error-free, and we included a user guide in all our files. Each file we were working on was validated by the team after acceptance. Finally, we have automated about ten Excel files, and there are still others to be processed.

Learn more about ESILV:

Facebook : http://facebook.com/esilvparis
Instagram : https://www.instagram.com/esilv_paris/?hl=fr
Twitter : http://twitter.com/esilvparis
Linkedin : http://bit.ly/25WVOCa
TikTok : https://www.tiktok.com/@esilv.ingenieurs

http://www.esilv.fr


  • Projets

    Une sélection de projets d'études, en prépa intégrée ou en cycle ingénieur, à l'ESILV, école d'ingénieurs généraliste au coeur des technologies numériques

    Voir tous les projets

  • Categories

  • Archives



Contact us
Apply now

    Need information ?

    Contact us and we will help you