Closed

Very simple online inventory spreadsheet

I need someone to code and then put online (as the access to this tool will be via on online admin) a very simple inventory tool. This online admin inventory tool will be very similar to an Excel spread sheet (6 columns and thousands of rows, filters and lists).

See attached example.

----

A few people within our company will need to log into this online admin inventory tool in order to daily modify the inventory. Each person will have their own Login and password.

There will be 6 columns of data:

. References: References will start at 500. Only references will information should appear.

. Gem variety: selection from a pre-defined list

. Weight (no pre-entered information). It will be a figure with two decimals such as 15.86, 4.67.

. Location of the product: selection from a pre-defined list (shop A, shop B, shop C, office, etc)

. Date: this will indicate the item's last location (a pre entered calendar with days/months/year similar to calendar's used online when purchasing a plane ticket for instance)

. User

Note that the system will need to record the items' various changes (ex: reference 500 was located in shop A on Jan 1 2013, then in Shop B on Feb 15 2013 then sold on March 2 2013 etc). The last location (for reference 502 for example = sold) will appear by default.

Note that the Admin should be able to:

. add Locations (Shop D, Shop E etc)

. add Users (X, Y, Z etc)

. add Gem varieties

I hope I was clear... The attached spreadsheet is very useful as it is more or less what I want to achieve (except that it will be online).

Skills: Excel

See more: Inventory spreadsheet, online inventory spreadsheet, want excel spread sheet, online daily code, code shop online, online spread sheet, x-plane, excel inventory, excel ex, add a very simple, code columns excel access, daily inventory sheet, excel sheet calendar items, sheet online, spreadsheet columns, excel selection list, inventory spreadsheet example, excel log log spreadsheet, excel weight, excel date selection, ticket office system, excel inventory record, weight excel, excel order system, excel sheet data inventory

About the Employer:
( 1 review ) Paris, France

Project ID: #4380801

8 freelancers are bidding on average $99 for this job

seaanddream

Hi, your excel vba expert here. let us have your job achieved by a top freelancer. regards,

$75 USD in 3 days
(13 Reviews)
3.6
sac18

shall we start

$203 USD in 2 days
(0 Reviews)
0.0
bryanpiczon

I am interested with your project, I can do it within 4 hours, I will do this: "Members should login with their separate account and edit the inventory file online, members can view and edit the inventory, members can More

$45 USD in 0 days
(0 Reviews)
0.0
popescudaniel

Hello, I am very interested in your project. Please send me more information via a private message. Expect an answer as soon because I want to start working as soon as possible. Thank you

$30 USD in 1 day
(0 Reviews)
0.0
Analyticsguy67

Yes Sir, I understand your requirement. You are very clear; let me know when can we start.

$140 USD in 3 days
(0 Reviews)
0.0
jess21sharma

I Can make this in php. Thanks

$110 USD in 7 days
(0 Reviews)
0.0
Vinayasilk

Can understand the description [url removed, login to view] ready to start. Please clarify the work load and also see PMB.

$50 USD in 3 days
(0 Reviews)
0.0
shaundtsl

Good day. Please see PM with my proposal.

$140 USD in 3 days
(0 Reviews)
0.0
vsubha2002

HI I have good team with 10 seaters . I am ready to work with you . Please send a details. Thanking You Your regards [url removed, login to view]

$140 USD in 3 days
(0 Reviews)
0.0