Advanced Google Sheets Calculations
Budget: $30 – $250 AUD
I need a skilled expert in Google Sheets who can assist me with some specific tasks revolving around formulas and calculations. Below are the specifics of my project:
- The main task will involve working with an AVERAGE function that receives three inputs from the ADF indicator ranging from -1, 0, and 1.
- You'll need to create three different averages based on the first input, namely: -1 = 40/60 (Perpetuals/Oscillators) 0 = 50/50 and 1= 60/40 (Perpetuals/Oscillators).
Id then like to visually represent the average in one gauge chart not multiple charts.
Skills and Experience:
- Proficient in Google Sheets.
- Strong knowledge of advanced formulas.
- An understanding of methods to manipulate and calculate averages.
Please be aware, these tasks are not basic or intermediate but require advanced knowledge of formulas and calculations in Google Sheets.
- The main task will involve working with an AVERAGE function that receives three inputs from the ADF indicator ranging from -1, 0, and 1.
- You'll need to create three different averages based on the first input, namely: -1 = 40/60 (Perpetuals/Oscillators) 0 = 50/50 and 1= 60/40 (Perpetuals/Oscillators).
Id then like to visually represent the average in one gauge chart not multiple charts.
Skills and Experience:
- Proficient in Google Sheets.
- Strong knowledge of advanced formulas.
- An understanding of methods to manipulate and calculate averages.
Please be aware, these tasks are not basic or intermediate but require advanced knowledge of formulas and calculations in Google Sheets.