Alter Formula - Currently not working
Project details
I have a formula in my production planner that calculates the number of hours worked up to and including today to calculate a percentage but it currently isn’t working as it should. The figures aren’t correct on the day. I think the formula i have in is close in principal, just missing something. That being said im happy for whoever takes the project to use their own.
To summarise, the formula needs to calculate the percentage of hours worked against the total planned and show a percentage in Column D. Row 11 should currently be 100% as of today (03/05) but its showing 91%.
Skills: Excel
Awarded to:
Rahul -.
(5.0)
Project budget:
budget limits: £10-20 GBP
number of bids: 4
average bids: £16
Awarded to:
Rahul -.
(5.0)
Project budget:
budget limits: £10-20 GBP
number of bids: 4
average bids: £16
Project details
I have a formula in my production planner that calculates the number of hours worked up to and including today to calculate a percentage but it currently isn’t working as it should. The figures aren’t correct on the day. I think the formula i have in is close in principal, just missing something. That being said im happy for whoever takes the project to use their own.
To summarise, the formula needs to calculate the percentage of hours worked against the total planned and show a percentage in Column D. Row 11 should currently be 100% as of today (03/05) but its showing 91%.
To summarise, the formula needs to calculate the percentage of hours worked against the total planned and show a percentage in Column D. Row 11 should currently be 100% as of today (03/05) but its showing 91%.
Skills: Excel
skills of Rahul -.
| skill ? | level ? | projects ? | ||
|---|---|---|---|---|
| Microsoft Office |
|
187 | ||
| Excel |
|
623 | ||
| Word |
|
125 | ||
| Visual Basic |
|
311 | ||
| Excel Macros |
|
62 | ||
| Visual Basic for Apps |
|
62 | ||
| Payroll |
|
62 | ||
| Data Processing |
|
249 | ||
| Data Warehousing |
|
1 | ||
| Data Visualization |
|
1 | ||
|
|
62 | |||
| Data Entry |
|
311 | ||
| Data Analytics |
|
1 | ||
| Adobe Illustrator |
|
62 | ||
| Data Science |
|
1 | ||
| Data Analysis |
|
1 | ||
| Powerpoint |
|
62 | ||
| Illustration |
|
62 | ||
| Software Architecture |
|
62 | ||
| Data Mining |
|
1 | ||
| Microsoft |
|
1 | ||
| App Development |
|
1 | ||
| Design |
|
1 | ||
| Sign Design |
|
1 | ||
| Color Grading |
|
1 | ||
| Editing |
|
62 | ||
| Photoshop |
|
62 | ||
| Book Cover Design |
|
1 | ||
| Logo Design |
|
62 | ||
| Digital Design |
|
1 | ||
| Textile Design |
|
1 | ||
| Sticker Design |
|
1 | ||
| Poster Design |
|
1 | ||
| PHP |
|
62 | ||
| Packaging Design |
|
1 | ||
| Package Design |
|
1 | ||
| Label Design |
|
1 | ||
| Illustrator |
|
62 | ||
| Infographic and Powerpoint Slide Designing |
|
1 | ||
| Graphic Design |
|
125 | ||
| Software Development |
|
1 | ||
| eBook Design |
|
1 | ||
| Computer Graphics |
|
1 | ||
| Advertisement Design |
|
1 | ||
| Business Cards |
|
1 | ||
| Brochure Design |
|
1 | ||
| Banner Design |
|
1 | ||
| Invitation Design |
|
1 | ||
| Icon Design |
|
1 | ||
| Creative Design |
|
1 | ||
| Flyer Design |
|
1 | ||
Some Rahul -. projects
| Project Title | Skills required in the project |
|---|---|
| Excel Expert | Excel Microsoft Office |
| I need an expert in excel | Excel Microsoft Office |
| Make this into a working excel spreadsheet with my branding/colours/logo | Excel Graphic Design Illustrator Logo Design Photoshop |
| need to clean up a csv file | Data Entry Excel Word |
| Convert Document to writable PDF | Editing Graphic Design Microsoft Office PDF Word |
| Excel programme to automatically change structure of existing daily sheet | Data Processing Excel Software Architecture Visual Basic |
| Slide / illustration Editing | Adobe Illustrator Illustration Powerpoint |
| Calculation in Excel | Data Entry Excel Excel Macros PHP Visual Basic |
| Time sheet for cleaner | Data Entry Data Processing Excel Payroll |
| Help creating a VBA expression in MS Excel | Data Entry Data Processing Excel Visual Basic Visual Basic for Apps |
| Data cleansing | Data Entry Data Processing Excel Visual Basic |
| Excel lookup Expert | Excel Visual Basic |
