Excel and SQL

$10-30 AUD

Teljesítve

Kiadva ekkor:

több mint 8 évvel ezelőtt

$10-30 AUD

Teljesítéskor fizetve

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.

Projektazonosító: 9073282

A projektről

8 ajánlat

Távolról teljesíthető projekt

Aktiválva: 8 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@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 1 napon belül

0,0

(0 értékelés)

0,0

8 szabadúszó adott átlagosan $48 AUD összegű árajánlatot erre a munkára

@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 1 napon belül

5,0

(2 értékelés)

3,3

@dinomarinic

A proposal has not yet been provided

$15 AUD 2 napon belül

5,0

(2 értékelés)

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 2 napon belül