Đã Đóng

linked excel sheet

What I need is and AP or business excel sheet that I can use on an android or tablet for the running of my business. I would like the date, time and time taken recorded for each machine that is serviced. I would also like to have it linked to my home pc so if I have an employee restocking machines I can see where he is up to, what stock sold, monies have been taken etc.

Multiple linked excel sheets for a small drink and snack vending business.

I will be needing to be able to write the name of the site, columns with drop down selector boxes for the date, Machine Stock, drop down boxes so I can select the required number (M/C Stock, is stock in the storage compartment of the machine).

I require drop down boxes so I can select what stock is available to be sold and a drop down box under this box so I can select what stock is sold.

I then need a column so I can select what monies were in the machine and then a column that automates what should have been in the machines. (For each machine I will be able to select what price items are and this will all be linked in all the excel sheets) There should also be a running total for what the machine has sold and monies taken.

I also need another linked page for receipts of purchases of drinks, chips, chocolates and snacks, sundries and all other expenses. Will need to see what receipts and expenses I have for the whole business or for single items as in drinks or the chips/crisps. At any time or period I want to be able see the balance of the business or profit and loss sheet. I want to see this for the whole business or individual items.

(I have provided some pictures of how I have been re-stocking machines) I would like to simplify this...

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Excel, Thiết kế đồ họa

Xem thêm: small android tablet, need employee business, linked on, linked n, linked it, linked i, graphic tablet, balance graphic design, android tablet price, android selector, time sheet, stocking, snack, sheet, price excel, linked, want employee, need graphic design android, drinks on, design machines, balance sheets, ap design, android ap, multiple excel, multiple select box

Về Bên Thuê:
( 0 nhận xét ) Mel, Australia

Mã Dự Án: #1745977

3 freelancer đang chào giá trung bình $177 cho công việc này

mzahid32

Hi, I am willing to help you out in this project

$80 AUD trong 2 ngày
(1 Đánh Giá)
1.0
roshanjo

i understand this job. i can do data entry very well. i can do excel, word, power point, copy past, & all type of data entry. u can hope me. i ll do my best. i ll finished the job by the time. i m presently working Thêm

$50 AUD trong 2 ngày
(0 Đánh Giá)
0.0
nani2186143

i will do this job

$400 AUD trong 10 ngày
(0 Đánh Giá)
0.0