Excel and SQL

$10-30 AUD

Completed

Posted

over 8 years ago

$10-30 AUD

Paid on delivery

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.

Project ID: 9073282

About the project

8 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 1 day

0.0

(0 reviews)

0.0

8 freelancers are bidding on average $48 AUD for this job

@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 in 1 day

5.0

(2 reviews)

3.3

@dinomarinic

A proposal has not yet been provided

$15 AUD in 2 days

5.0

(2 reviews)

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 in 2 days