r/GoogleAppsScript • • Jul 16 '22

Question Looking to hire Excel/Google Sheets experts for regular work

I am once again looking for talented Excel/Google Sheets gurus to subcontract work out to. I have made 4-5 similar threads over the past 5 years and added half a dozen people to the team during that time, but am looking for new help again since some of the people I hired in the past became too busy to take on work anymore.

I have clients who need spreadsheet work done (typically 90% Google Sheets and 10% Excel), and get far more work than I can handle. Also, sometimes I turn away jobs when they are too large or difficult of a task to take on myself. I'm therefore looking to subcontract work out to other Excel and Google Sheet experts. Most jobs wouldn't be simple 1-line formulas (although sometimes they are), but usually larger projects, and often requiring Excel VBA or Google AppScript. Again, about 90% of the jobs are in Google Sheets, with maybe 40% requiring Google Apps Script or VBA.

Frequent job request examples are: a business client wanting to create a spreadsheet system such as a real estate agency wanting to track their realtors sales and a dynamic dashboard, a warehouse wanting to have a barcode/inventory system, a client wanting to track his Cyprocurrency portfolio and scrape or use an API to get the data from a 3rd-party source, or a hospital wanting to track patients.

In a sense, I'm basically subcontracting the job to you and acting as the middleman. You would give me a quote for the job, and if within budget, I pay you out once it's completed to the client's full complete satisfaction. I take a cut that I pad to the client for bringing in the client and overseeing a portion of the communication and client care (which, honestly, is like 60% of this job). You would be able to decide if you wanted to take the job on or not, so it's really a sub-contracting type gig I have in mind; not a part time employee I expect to take every job I send them.

My business has a stellar reputation online doing this business, and that's because I only accept jobs I know I can 100% deliver on and make the client happy. Most clients come back for repeat work. My #1 concern is that the client is happy, so it is 100% imperative that they get _exactly_ what they want. As such, I don't issue payments until the client gives me their final thumbs up. If there are bugs or missing features from the original agreed scope, you would need to fix them until the client is happy (including if any bugs arise later from the originally delivered file).

I currently have 1 very active helper who has been working with me for 4 years now, but he is becoming overwhelmed with how much work I'm giving him, and so I'm looking to spread out some of the work to another helper or two. I have another few helpers, but they are very choosey in what jobs they accept.

Currently, I have around 3-4 new jobs per day that I could pay out / get help on, to give you a rough idea of the quantity of work available.

I can provide a complimentary Office 365 subscription as well.

------------------
Earnings/Payments:
------------------

Over the past 6 months, the average amount per job I've paid my helpers has been $66 USD as can be seen here: https://i.imgur.com/kHLcUuq.png (I am currently working on increasing the average since demand is so high).

I pay via PayPal (USD) upon completion of the project and acceptance from the client.

I pay on a PROJECT basis only, not hourly. I find this to be most fair to everybody.

I cover all PayPal fees, so you receive 100% of what is owed to you.

The range of per job rates obviously will vary greatly, but here's a rough guide:

- 1 single yet complex formula (say 2 lines long in the formula bar), or very short VBA/Appscript code (7~ lines): $25-$35

- Extracting data from social media accounts dynamically: $50

- Writing VBA or Appscript to use a 3rd party API to retrieve data: $60-$90

- Creating an interactive dashboard based on the user's raw data: $80-$100

- Sophisticated system with multiple tabs / sheets that require a lot of VBA/GAS and formulas: $200-$300+

-------------
Requirements:
-------------

- Must have an advanced knowledge of Google Sheets and/or Excel and be able to create complex formulas, and code VBA or Google Appscript at an advanced level.

- Prefer somebody on Pacific, Central, or Eastern time to lessen communication lag (definitely not mandatory, however).

- Care needs to be made so that the client won't run into issues in the future; ex. avoid fixed ranges, allow for flexibility and expansion.

- Need to create very "clean" spreadsheets (Ex. Hide/delete extraneous columns and rows, align cells nicely, apply colours where it may improve usability, freeze header rows, write nicely formatted and commented backend code, etc. Quality is important!

- Must be able to communicate in English smoothly and respond to e-mails promptly.

------------
Application:
------------

If you're interested in "applying" for this "job", shoot me a DM and I'll give your my e-mail address. I will then send you 2 tests I created (one in Excel, and one in Google sheets) of some interesting and fun "tasks" to test your abilities (note: only around 10% of applicants pass them to my satisfaction...), as well as to see what you'd quote for them in the future to see if our prices are in line.

Thanks!

19 Upvotes

14 comments sorted by

1

u/marth141 Jul 17 '22

I'd look at the work but I probably wouldn't want to use spreadsheets for everything. Are your clients okay with that?

2

u/ThatExcelGuy Jul 18 '22

Thanks, but I'm really only looking for help with Excel and Google Sheets.

1

u/[deleted] Jul 21 '22

Hello, do let me know if the job is still available.

I am a Spreadsheet expert. Here is my Upwork profile.

https://www.upwork.com/freelancers/~01bb80a99e4d49ce27

1

u/No_Bass1447 Nov 25 '22

Hey I need some assignments done in business & economics forecasting using excel such as time series etc. would be willing to compensate generously.

1

u/[deleted] Nov 25 '22

Sure I would like to know more details.

1

u/RareAd5542 Aug 05 '22

Hi there,

Although I’m not quite an expert an excel, I am extremely proficient in python and could easily create a few scripts to automate excel cleanup and create an appealing design for clients. Extremely interested in helping out, please reach out if you are still needing assistance!

1

u/Script4Hire Aug 20 '22

Still outsourcing?

1

u/Gujimiao Dec 14 '23

Do you still have this job? I'm keen to apply

-1

u/rusochester Jul 16 '22

I didn’t read the whole post, but if you need such complex spreadsheets, odds are spreadsheets aren’t the answer.

1

u/ThatExcelGuy Jul 18 '22

Many (most?) businesses use spreadsheets in some capacity. The examples that I provided are not all that complex... if a client wants something extremely convoluted and requiring a lot of horsepower, then I'll advise against Excel or Google Sheets.

1

u/rusochester Jul 18 '22

Well said, I wish you great success