Google sheets
- or -
Post a project like this£10/hr(approx. $12/hr)
- Posted:
- Proposals: 12
- Remote
- #3114077
- Expired
WEBSITE DEVELOPMENT & DESIGN ! WORDPRESS ! JAVA ! PHP ! JAVASCRIPT ! GRAPHIC DESIGN | VIDEO | EXCEL VBA & MACRO EXPERT
New Delhi
Top rated PHP Web Development | WordPress | Magento | Drupal | OpenCart | PrestaShop | Joomla
Leicester
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
Bay Minette
256106614970601050754171158614634861642492126446349333775297401491951551184715034107
Description
Experience Level: Entry
I have a client who is running franchise website and is charging its chain of takeaways percentages for the sales and a fee for each card transactions.
He also charges the takeaways franchise fees and other fixed fees i.e., admin etc.
The client also pays for some of the services to third party for managing the orders, card fees etc.
When a customer places an order for food, they pay (if its a card payment) for the order online and the payments come to third party account and then to my client. My client deducts his fees and refund the rest to respected takeaways at the end of the week.
Based on the above the client wants have a sheet where one tab is filled, and the rest of the tabs filled in.
The client has a basic idea and have started this into google sheet but struggling to complete it.
There are VLOOKUP’s and some addition formulas but I am sure they can be enhanced i.e.; he would prefer the VLOOKUPs are are pointed at the name of the column rather than the number of columns this is if he ever delete or add any column the rest of the tabs are not affected.
The main problem is that when he enters the details in the main tab, the current tabs are filled with information okay, but for the following weeks he has to override this information to update the rest of the tabs or copy and paste the main tab, which is not what he wants.
Realistically, you may need a formula or two to achieve this, so shouldn’t be too long too complicated.
We can share the sheet with you to modify or you can create a new sheet, as long as it’s presentable and easy to understand.
If you can do this, lets discus how long this will take you to finish.
We need this completed by Thursday this week latest.
He also charges the takeaways franchise fees and other fixed fees i.e., admin etc.
The client also pays for some of the services to third party for managing the orders, card fees etc.
When a customer places an order for food, they pay (if its a card payment) for the order online and the payments come to third party account and then to my client. My client deducts his fees and refund the rest to respected takeaways at the end of the week.
Based on the above the client wants have a sheet where one tab is filled, and the rest of the tabs filled in.
The client has a basic idea and have started this into google sheet but struggling to complete it.
There are VLOOKUP’s and some addition formulas but I am sure they can be enhanced i.e.; he would prefer the VLOOKUPs are are pointed at the name of the column rather than the number of columns this is if he ever delete or add any column the rest of the tabs are not affected.
The main problem is that when he enters the details in the main tab, the current tabs are filled with information okay, but for the following weeks he has to override this information to update the rest of the tabs or copy and paste the main tab, which is not what he wants.
Realistically, you may need a formula or two to achieve this, so shouldn’t be too long too complicated.
We can share the sheet with you to modify or you can create a new sheet, as long as it’s presentable and easy to understand.
If you can do this, lets discus how long this will take you to finish.
We need this completed by Thursday this week latest.
Projects Completed
103
Freelancers worked with
100
Projects awarded
57%
Last project
3 May 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies