Excel and SQL

$10-30 AUD

Đã hoàn thành

Đã đăng vào

hơn 8 năm trước

$10-30 AUD

Thanh toán khi bàn giao

I have a excel spread sheets currently that have Data in them. One is a Excel with a Macro. It contains SQL in them that is for a Internal Database. Please note, That there will be no access to this Database during the project. Not by Team viewer either I want to in one Excel Spreadsheet do the following. - Have one cell Count how many times a certain Text comes up in 1 Column over 14 Sheets - Count and sum of the total that is associated with that word string in the 14 sheets. - Create a bar graph (Preferably on the front page) that will measure how many bookings/Revenue has come in per hour. The data will come from the Column "MadeOn" and will have a timestamp one I amend the SQL code **BONUS** If you are able to put a section in the Excel Spreadsheet where I can enter a date that allows me to put in the day I want and when i run the refresh for the spreadsheet the SQL that i have written will pick up on that date and only run the data for that date. I can Supply the Query that I'm running for this part. I am more likely to choose the freelancer that can also do the bonus, But please only bid accordingly if you can do that.

Mã dự án: 9073282

Về dự án

8 đề xuất

Dự án từ xa

Hoạt động 8 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@sergioobici

I'm able to do also the 'BONUS'. Just one question that is important for understanding the complexity of the project. Have these 14 sheets a name that doen't change after running the SQL? Are there just this 14 sheets? They can be more or less than 14? Thank you.

$30 AUD trong 1 ngày

0,0

(0 nhận xét)

0,0

8 freelancer chào giá trung bình $48 AUD cho công việc này

@zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". Maybe you will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura

$166 AUD trong 1 ngày

5,0

(2 nhận xét)

3,3

@dinomarinic

A proposal has not yet been provided

$15 AUD trong 2 ngày

5,0

(2 nhận xét)

0,6

@imrohitaggarwal

Will help you with all the details ,have good hands on ms -excel .let me know so that we can start working and give you proper deliverable's on the time

$30 AUD trong 2 ngày