Excel Offer Tool for rental companys

[JoelJohanssonHostlov]

Hello! Ive made an offer software that i use in my small AV rental-company. My Idea was to sell it to others in my level and line of work. Instead of paying a monthly fee to softwares like Rentman. But ive come to grips with that the more correct way of doing this was to program it i C# as a windows forms application with an installation file, this might be a futureproject of mine. However, now I just feel like sharing it and open up for engagement and improvements.

The excel file is fairly straight forward. A bit ambivalent with use of language hehe, I mix swe and eng alot.

The excel file/app works across plattforms mac and pc.

As of now it has 3 main pages 1. offer page 2. inventory page 3. data page

1. offerpage
this page is for making your offer. Entering the relevant products and information. You can switch between adding products from inventory and adding custom products (often used during subrentals).

2. The inventory page is for adding new products into your existing categorys of products

3. the data page is for setting up you inventory categorys and setting you progressive discount factors, so perhaps youd like for day two the rental price is 1.8, day three factor 2, day 5 factor 3 and so on.

The admin passwords for both the admin state of the excel "app" and the vba code is: admin

This is a freeware, I keep the rights of the software I post here. Any adjustments an improvements and changes made to my excel file will make it an officially new excel software and I no longer hold either responsibilty or claim to that file. Any usage of my code for your own purposes is ok. I dont take responsibility for missusage of the software. If you don know how to forcebly stop an application if it freezes or goes into an eternal loopstage in the vba code then dont download this and experiment with it.

The reason for me to post this is more to share and maybe engage others in this weird little home project of mine.

Important note. There is some bugs. Maybe bugs I still havent discovered myself. Some code is written in a way that is "unsafe" that iteration loops can go forever if adjustments to endmarkings in the excelfile is made. This will cause excel to freeze and you will have to forcebly end the application. As of what I know, this will not happen with the version Ive attached, ive made as much "safe" code as possible. But it can be good to take in consideration.

Look forward to hear what you think of the "excel app" and maybe what you can do to improve it! Best regards.

Offertmall Beta 7 - DEMO.xlsm.zip