We wanted to create something simple that would be useful and easy to use for anyone who isn't too familiar with coding.
What it does
All of the items and their quantities are put into the excel sheet. Then, when a person wants to check out an item, they put their name, psu email, date and quantity of the item(s) they are checking out into the correct cell. Finally, the program will let them know if the items can be checked out or not depending on the availability of the resource.
How we built it
We made a small list of a few items, input their quantities, and wrote formulas. We have basic addition formulas and a formula to show if there are more items left to be checked out or not.
Challenges we ran into
We ran into a challenge when we wanted to write the =IF function because we had too many arguments for one cell and the final product wasn't showing up.
Accomplishments that we're proud of
We are proud that our =IF function worked nicely at the end.
What we learned
We learned more about excel and its tricks. Specially that =IF functions can't have too many arguments for one cell. We also learned that inventories can be difficult to organize.
What's next for SpreadSheet Inventory
We need to improve the way people who can check out items are organized, we currently only have a max of three people that can check out items. We would also want to link our excel inventory list to another program that would clean up the whole presentation. Users could be able to chose an item from a dropdown box, there could be a time limit for checking out certain items. We can also work on printing barcodes for each item as they are put into the inventory list, these codes will be organized and sent to the excel sheet which will be linked to the other cleaner user-friendly program. The LLPSLO could get a barcode scanner so users who want to check out items wouldn't have to write the item name, they could just scan the barcode and swipe their PSU ID card.