Google Sheets Developer Wanted (scripting and formulas)

Job ID: 30658912

Budget: $2 – $8 USD

I have the framework roughly designed for a mid level warehouse WMS system using Google Sheets. It's more than just in and out, but it's not a replacement for a proper WMS product.

Reason for trying Google Sheets is the ease of deployment, sharing, backups, offline mode.

I need a developer to be able to do some scripting and formulas to help with data entry and reporting.

I have created a share to my idea for you to see. It's probably not the most efficient so open to suggestions depending on the ability of enquiries received.

Prospective applicants please note;

I've been stung with poor candidates once on here before. We will be using the Freelancer system for payment after goals are met. That means I am not releasing a deposit to get started. The simple test will provide payment once completed.
The initial start will be low hours for a simple project, we can then move forward if suitable.
To weed out simple click responses who don't read, please respond with the value on sheet 'Lists', cell A12.
I ask for some previous examples of ability. I don't need to see data entry etc please.

https://docs.google.com/spreadsheets/d/1mMt0t9z9MF-ZSFMRy6ZzxAf2KvEfce6yRlKpE1IwTo0/edit?usp=sharing

Many thanks.
Related categories: Excel Excel VBA Excel Macros Google Sheets