![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Excel sheet
- or -
Post a project like this1090
£20(approx. $26)
- Posted:
- Proposals: 40
- Remote
- #3327309
- Awarded
Website Developer, Graphic Designer, Transcriber, Content writer, CAD Expert, Python Developer, Photo Editor, Web Scrapper, JAVA developer, Android developer, Wix/Shopify Expert,
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
WordPress Expert✮Shopify Expert✮Graphic Designer✮AutoCAD 2D & 3D✮CV Writer & Designer✮Fullstack developer
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Full Stack Web and App Designer and Developer*WordPress*Shopify*React*Graphic Design*
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Excel Expert |WordPress| Google Sheets |VBA & Google App Script | Woocommerce
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
20827025437783636573227480423854365623148278297738867403059921495741917882906102071
![Robert A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/208270_70x70.jpg)
![Sarim I.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/b5eafae363adb498a4905c7fba43cabc_70x70.jpg)
![MUHAMMAD Kashif M.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/f981574739dc1a7143168aea431b1393_70x70.jpg)
![MD A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/8e2676d862b77b471d96ae079f6b0c17_70x70.png)
Description
Experience Level: Entry
I wanted help to create a simple excel sheet please.
Our current process.
We download a list of names and invoices into a csv file
paste them into an excel sheet.
Then check them to each individually to ensure the person has paid.
If the person has not paid we manually copy the payment to another sheet
We total the amount.
add this total to to another sheet in the workbook.
manually calculate for the first £500/day earnt we pay 45% and for the amount above we pay 50%.
then we have a list of deduction.
Problems
- too many sheets within work book as we have 8-10 individuals each requiring 2 sheets
- not many of the calculations are automated
-too many cells open for errors to occur
can you help design an updated sheet which is more automated.
Our current process.
We download a list of names and invoices into a csv file
paste them into an excel sheet.
Then check them to each individually to ensure the person has paid.
If the person has not paid we manually copy the payment to another sheet
We total the amount.
add this total to to another sheet in the workbook.
manually calculate for the first £500/day earnt we pay 45% and for the amount above we pay 50%.
then we have a list of deduction.
Problems
- too many sheets within work book as we have 8-10 individuals each requiring 2 sheets
- not many of the calculations are automated
-too many cells open for errors to occur
can you help design an updated sheet which is more automated.
![Nikesh C.](https://www.peopleperhour.com/imgs/default_avatar_light_70x70.png)
Nikesh C.
100% (28)Projects Completed
39
Freelancers worked with
36
Projects awarded
41%
Last project
27 Jun 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