Excel and SQL

$10-30 AUD

Finalizat

Data postării:

peste 8 ani în urmă

$10-30 AUD

Plata la predare

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.

ID-ul proiectului: 9073282

Despre proiect

8 propuneri

Proiect la distanță

Activ: 8 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

Acordat utilizatorului:

@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 în 1 zi

0,0

(0 recenzii)

0,0

8 freelanceri plasează o ofertă medie de $48 AUD pentru proiect

@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 în 1 zi

5,0

(2 recenzii)

3,3

@dinomarinic

A proposal has not yet been provided

$15 AUD în 2 zile

5,0

(2 recenzii)

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 în 2 zile