Find Jobs
Hire Freelancers

Equivalent MYSQL output but using Google Sheets (script) or Microsoft Excel (macro) to do the query command

$30-250 USD

Completed
Posted over 7 years ago

$30-250 USD

Paid on delivery
Equivalent MYSQL output but using Google Sheets (script) or Microsoft Excel (macro) (must work with MacOS) to do the equivalent query command.. Existing MySQL structure: Two tables (Activity & Allocations) Activity - Fields: credit_card type trans_date post_date description amount cost_center Activity - Current Sample content: "id","credit_card","type","trans_date","post_date","description","amount","cost_center" 67,"Chase","Sale","9/1/16","9/1/16","Transaction A",100.00,"N" 68,"Chase","Sale","9/2/16","9/2/16","Transaction B",200.00,"B" 85,"Chase","Sale","9/19/16","9/19/16","Transaction S",1900.00,"D" 86,"Chase","Sale","9/20/16","9/20/16","Transaction T",2000.00,"E" 87,"Chase","Sale","9/21/16","9/21/16","Transaction U",2100.00,"M" 88,"Chase","Sale","9/22/16","9/22/16","Transaction V",2200.00,"B" 89,"Chase","Sale","9/19/16","9/19/16","Transaction S",1900.00,"D" 90,"Chase","Sale","9/19/16","9/19/16","Transaction S",1900.00,"D" 91,"Chase","Sale","9/2/16","9/2/16","Transaction C",200.00,"B" 92,"Chase","Sale","9/2/16","9/2/16","Transaction D",200.00,"B" Allocations - Fields: cost_center underlying_cost_company allocation Allocations - Current Sample content: "id","cost_center","underlying_cost_company","allocation" 1,"A","Company A",1.0000 2,"B","Company B",1.0000 3,"C","Company C",1.0000 4,"D","Company D",1.0000 7,"E","Company E",1.0000 9,"F","Company F",1.0000 10,"G","Company G",1.0000 11,"H","Company H",1.0000 12,"I","Company I",1.0000 13,"J","Company J",1.0000 14,"K","Company K",1.0000 15,"L","Company L",1.0000 16,"M","Company M",0.5000 17,"M","Company N",0.5000 18,"N","Company O",0.2711 19,"N","Company Q",0.7289 Concept being that a cost center can have multiple underlying_cost_company so it is repeated until the sum is 1. (done manually) Query being ran: SELECT credit_card, `type`, trans_date, description, amount, Activity.cost_center, underlying_cost_company, allocation, round((amount * allocation),2) AS allocated_amount FROM Activity JOIN Allocations ON Activity.cost_center=Allocations.cost_center ORDER BY underlying_cost_company ASC Query output: "credit_card","type","trans_date","description","amount","cost_center","underlying_cost_company","allocation","allocated_amount" "Chase","Sale","9/2/16","Transaction B",200.00,"B","Company B",1.0000,200.00 "Chase","Sale","9/22/16","Transaction V",2200.00,"B","Company B",1.0000,2200.00 "Chase","Sale","9/2/16","Transaction C",200.00,"B","Company B",1.0000,200.00 "Chase","Sale","9/2/16","Transaction D",200.00,"B","Company B",1.0000,200.00 "Chase","Sale","9/19/16","Transaction S",1900.00,"D","Company D",1.0000,1900.00 "Chase","Sale","9/19/16","Transaction S",1900.00,"D","Company D",1.0000,1900.00 "Chase","Sale","9/19/16","Transaction S",1900.00,"D","Company D",1.0000,1900.00 "Chase","Sale","9/20/16","Transaction T",2000.00,"E","Company E",1.0000,2000.00 "Chase","Sale","9/21/16","Transaction U",2100.00,"M","Company M",0.5000,1050.00 "Chase","Sale","9/21/16","Transaction U",2100.00,"M","Company N",0.5000,1050.00 "Chase","Sale","9/1/16","Transaction A",100.00,"N","Company O",0.2711,27.11 "Chase","Sale","9/1/16","Transaction A",100.00,"N","Company Q",0.7289,72.89 The above query, grabs all of the requeted data via a select command. Pairs it with its corresponding cost_center, then multiplies the amount by the allocation.. Overall objective to move the Excel or Google Sheets is to have each Table above be its own sheet and have the output of the query be its own sheet allowing the amount to have a $ included.. the allocation is just a decimal value. It is in effect a pivot table of a pivot table but one that creates a new line per query the way it works in MySQL
Project ID: 11890250

About the project

13 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

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:
User Avatar
Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (with both formulas and macros) and i've never had a single problem. Also i've successfully completed many SQL projects (with both MySQL and Oracle databases). If you are interested message me and i believe i can complete this macro for you in couple of hours (and yes it will work for both Mac and Windows OS's). As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Thanks, Milan
$45 USD in 0 day
5.0 (169 reviews)
5.8
5.8
13 freelancers are bidding on average $105 USD for this job
User Avatar
Hi, I have more than 14 years of Excel macro/VBA exp and I am expert in this kind of work. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 USD in 3 days
4.9 (116 reviews)
6.1
6.1
User Avatar
Hi, i can create a macro for you to get this output as your SQL query. even for the cost center i can create that function too, i hate manual work :)
$60 USD in 1 day
5.0 (7 reviews)
4.3
4.3
User Avatar
Hello, I am VBA programmer Excel expert Have got bachelor degree in finance I can do whatever you like very fast and for a cheaper price So, feel free to contact with me and ask any questions you have. I made average bid just to reach to you so we can discuss details in private chat
$155 USD in 3 days
5.0 (2 reviews)
1.6
1.6
User Avatar
A proposal has not yet been provided
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We are into software development from the last 3 years, we have completed more than 50 projects successfully...we may new to freelancer but we have vast experience outside
$105 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
because this is what I will be working on
$100 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$77 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a bachelor degree from the National University of Rwanda, and many trainings in Project Management, Business administration, ICT,…with 13 years of experience in Data Entry services.I am a Translator consultant and Data Entry Specialist with main activities in Project design, Agricultural engineering, Horticulture, Agribusiness, Religions, Sciences, social sciences, Business Plan and Strategic Plan, Impact Assessment of projects/Programs, ICT,… I have done many translations and data Entry services where I work closely with Public, Private, international institutions, Banks and other institutions (World Bank, UN/FAO, MINAGRI, PSF, Churches, NGOs, DAY TRANSLATIONS, , TRAVOD, USADF/USAID,...) I have also a high knowledge in ICT: M. Word, M. Excel, , M. Power Point, M. Publisher, MSTATC, SPSS for Windows, Business in Box, Epi-data, Internet skills, accounting software (Sage 50 accounts, Tally, ...). My speed level is 60 words per minute (40 WPM).
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SPAIN
beaverton, Spain
4.9
3
Payment method verified
Member since Jun 11, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.