Suljettu

GoogleSheet detailed formula assistance

I have a requirement please based on the following website:

[login to view URL]

to have this generated in a Google Sheets file.

You will see from this spreadsheet, that you can input any one piece of data, hit calculate and the rest of the figures will be populated.

You will see it is based on the current Australian Tax Rate table:

[login to view URL]

Low | High | Rate

0 | 18,200 | 0%

18,201 | 45,000 | 19%

45,001 | 120,000 | 32.5%

120,001 | 180,000 | 37%

180,001+ | 45%

So, I would need the same ability in a Google Sheet, to:

Enter any data point as per the link above

And have the data populate

With the option to ‘clear’ all data and start again

The website : [login to view URL] is great but slightly incorrect with it’s calculation, but the following Google Sheets calculator is correct:

[login to view URL]

As you will see, based on an income of $80,000 entered in D4, the result in D13 : $17,547.00 is the tax result I would need in the spreadsheet (based on the official tax rates table / link provided above.

I have tinkered with the Goal Seek feature in Google Sheets, but (I think) I would need to call the goal seek function via script which I don’t have the advanced knowledge for (or a Macro?)

Further to this, I have put together the following explanatory video for your review:

[login to view URL]

(you might need to download to view in HD)

Here are the websites referenced:

[login to view URL]

[login to view URL]

[login to view URL]

Deliverables

FYI - one of our older suppliers worked on this previously, but is unfortunately now away until the end of the month (and we need it done this week) - he put together the following video showing how he had it complete the requirements, just with formulas, no script:

reverse tax calculator explanation video : [login to view URL]

(you might need to download the video to view in HD)

Can you please review and advise if you can do the same?

Please review and let me know, thanks in advance!

Taidot: Google Sheets

Näytä lisää: design dynamic calculation formula, spring calculation formula, morgage payment calculation formula, loan repayments calculation math formula software, javascript formula calculation adobe, excel formula max drawdown calculation, i am looking for a t-shirt design that would fit on the front of a t-shirt and could be used on the back as well, write a dilogue within 100 words on the need to ban the use of animals like tighers and lions as circus attractions hints wild a, write a report freelance to the sho regarding the frequent kidnapping cases in and around the area with suggestions and as a rem, escrow made in china com secured trading services sts as the independent trusted third party holds and disburses the payment dep, freelancing as a copy editor, how to get started as a copy writer london, work online as a copy writer, As posting copy paste, how to get a job as a copy editor, how do you clear contents of excel and not lose formula, what is the latest article that you read and influenced your work as a product manager and why, which eva formula 's are the most valuable to project managers and why, install jquery with major and minor versions as 3 and 4 respectively, create a formula to calculate the total cost based on price and quantity.

Tietoa työnantajasta:
( 1 arvostelu ) Băilești, Romania

Projektin tunnus: #29440722

4 freelanceria on tarjonnut keskimäärin $299 tähän työhön

aruls1962

I am engineer with a lot of of experience in the manufacturing industry. I have been developing systems from the ground up in Google Sheets for the last 7 years. You can read about the complete Human Resource Manageme Lisää

$500 USD 7 päivässä
(6 arvostelua)
3.1
saidc

Hi, I’m a Computer Scientist, with knowledge of Electronics, and programming microcontrollers. I have experience creating code with C/C++ , Python, Java,Nodejs, Unity, JavaScript. I have experience creating projects li Lisää

$247 USD 7 päivässä
(2 arvostelua)
2.0
matyiasjavier

Hi! I'm Javier a  Software Engineer, I read carefully the requirements,  it could be done in google sheets, but also it will be done with a Web App like the JAW's Oz Tax Calculator. I'm free to start as soon as possibl Lisää

$250 USD 7 päivässä
(0 arvostelua)
0.0
FutureNOWPK

Interesting goal. I'll prep a googlehseet with the required functions. I do work on JS for Google sheets like I did for Gmail based mail merge with attachments. would like to keep in touch. cheers

$200 USD 7 päivässä
(0 arvostelua)
0.0