Create very simple finance sheet in existing Google spreadsheet (see example)
- or -
Post a project like this- Posted:
- Proposals: 1
- Remote
- #1231081
- Expired
Description
We'd like a new Finance sheet that pulls data and creates totals.
The most complicated formulae are:
1. One field will require a vlookup to determine which commision rate to apply.
2. Three totals will need to check only entries that match the appropriate month.
I have an example here. Please see comments in the cells for an explanation clarifying our requirements - https://docs.google.com/spreadsheets/d/1cNDzPaHat_IjaValwPRHpSZFdda61saTKHMAyPPjnH4/edit?usp=sharing
See also, the attached document which further details our requirements.
We would need to be able to add rows and coumns without breaking the form if possible.
PLEASE NOTE - THIS IS A LIVE FORM. ALL WORK WOULD NEED TO BE DONE ON A COPY, THEN COPIED ACROSS WHEN TESTED
Many Thanks and happy bidding!
Andy Y.
100% (63)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
when you are going to start project?
-
Hi Andy, can I ask some questions ?
Andy Y.28 Jul 2016Of course (I have attached a more detailed spec). By the way it's the Finance sheet that needs the funky formulae, and one column on the Joining Instructions sheet.
-
Hi Andy,
Although what you require is obviously doable, I was not able to find any comments in the sheet that relate to what you have asked for in the job. Can you provide clearer detail on what you require doing, to what sheets etc.
Regards,
JamesAndy Y.28 Jul 2016Hi James, the comments are in the Finance sheet, column H. I have also attached a more detailed spec document to the job. Please feel free to ask any questions
-
i have seen the example and i can hellp you what is the deadline?
Andy Y.28 Jul 2016Hi James, sorry - only just seen this message. I have attached a more detailed spec. I would like this up and running soon, but don't have a deadline as such.
Rukhsana I.28 Jul 2016what is the budget for this one?