Excel sheet automation -- 2
Project details
We have a small excel sheet project. The current excel sheet needs to be converted to a value-assigned master sheet.
This is how is looks current excel sheet looks – attachment-1
We would like to convert this to an value-assigned excel sheet as seen below attachment-2. The colour of the cell content will decide the values. For e.g.
Yes (in green) –→ Yes, 120,
Yes (in black) –→ Yes, 100,
Yes (in red) –→ Yes, 90,
Yes (in blue) –→ Yes, 95
The font colour will decide the value. We need a designated area for e.g. another excel tab to design the colour rules for e.g. Black = 100, Red = 90, Green = 120, Blue = 95 etc. The admin should be able to change the colour and the value assigned dynamically.
N.B. – The first 3 columns e.g. Sl no, feature code and sub-features column can be ignored and excluded from this formula.
Awarded to:
Jean R.
(5.0)
Project budget:
budget limits: $10-30 USD
number of bids: 21
average bids: $23
Awarded to:
Jean R.
(5.0)
Project budget:
budget limits: $10-30 USD
number of bids: 21
average bids: $23
Project details
We have a small excel sheet project. The current excel sheet needs to be converted to a value-assigned master sheet.
This is how is looks current excel sheet looks – attachment-1
We would like to convert this to an value-assigned excel sheet as seen below attachment-2. The colour of the cell content will decide the values. For e.g.
Yes (in green) –→ Yes, 120,
Yes (in black) –→ Yes, 100,
Yes (in red) –→ Yes, 90,
Yes (in blue) –→ Yes, 95
The font colour will decide the value. We need a designated area for e.g. another excel tab to design the colour rules for e.g. Black = 100, Red = 90, Green = 120, Blue = 95 etc. The admin should be able to change the colour and the value assigned dynamically.
N.B. – The first 3 columns e.g. Sl no, feature code and sub-features column can be ignored and excluded from this formula.
This is how is looks current excel sheet looks – attachment-1
We would like to convert this to an value-assigned excel sheet as seen below attachment-2. The colour of the cell content will decide the values. For e.g.
Yes (in green) –→ Yes, 120,
Yes (in black) –→ Yes, 100,
Yes (in red) –→ Yes, 90,
Yes (in blue) –→ Yes, 95
The font colour will decide the value. We need a designated area for e.g. another excel tab to design the colour rules for e.g. Black = 100, Red = 90, Green = 120, Blue = 95 etc. The admin should be able to change the colour and the value assigned dynamically.
N.B. – The first 3 columns e.g. Sl no, feature code and sub-features column can be ignored and excluded from this formula.
Skills: ExcelExcel VB CapabilitiesExcel VBA
skills of Jean R.
| skill ? | level ? | projects ? | ||
|---|---|---|---|---|
|
|
93 | |||
| Microsoft Word |
|
23 | ||
| Electronic Forms |
|
23 | ||
| Word Processing |
|
23 | ||
| Word |
|
47 | ||
| Excel |
|
210 | ||
| Visual Basic |
|
117 | ||
| Data Processing |
|
140 | ||
| Data Warehousing |
|
1 | ||
| Data Visualization |
|
1 | ||
| Statistics |
|
23 | ||
| Coding |
|
23 | ||
| Data Analytics |
|
1 | ||
| Data Analysis |
|
1 | ||
| Data Science |
|
1 | ||
| PC Programming |
|
1 | ||
| Data Entry |
|
140 | ||
| Format and Layout |
|
23 | ||
| Statistics Tutoring |
|
1 | ||
| Accounting |
|
23 | ||
| Certified Public Accountant |
|
1 | ||
| Compensation and Benefits |
|
1 | ||
| Data Mining |
|
1 | ||
| Software Architecture |
|
23 | ||
| Finance |
|
23 | ||
| EBS Finance |
|
1 | ||
| Financial Accounting |
|
1 | ||
| Financial Consulting |
|
1 | ||
| Financial Crime |
|
1 | ||
| Financial Forecasting |
|
1 | ||
| Financial Planning |
|
1 | ||
| Financial Sales |
|
1 | ||
| Budgeting and Forecasting |
|
1 | ||
| Statistical Modeling |
|
1 | ||
| Executive Compensation |
|
1 | ||
| Reward |
|
1 | ||
| Python |
|
23 | ||
| Executive Reward |
|
1 | ||
| Financial Research |
|
1 | ||
| Financial Modeling |
|
1 | ||
| Financial Markets |
|
1 | ||
| Financial Analysis |
|
1 | ||
| Brochure Design |
|
1 | ||
| Computer Graphics |
|
1 | ||
| Color Grading |
|
1 | ||
| Business Cards |
|
1 | ||
| Infographic and Powerpoint Slide Designing |
|
1 | ||
| Book Cover Design |
|
1 | ||
| Icon Design |
|
1 | ||
| Graphic Design |
|
23 | ||
| Programming |
|
1 | ||
| Statistical Analysis |
|
1 | ||
| Creative Design |
|
1 | ||
| Design |
|
1 | ||
| Digital Design |
|
1 | ||
| eBook Design |
|
1 | ||
| Flyer Design |
|
1 | ||
| Invitation Design |
|
1 | ||
| Banner Design |
|
1 | ||
| Label Design |
|
1 | ||
| Logo Design |
|
1 | ||
| Package Design |
|
1 | ||
| Packaging Design |
|
1 | ||
| Poster Design |
|
1 | ||
| Sign Design |
|
1 | ||
| Sticker Design |
|
1 | ||
| Textile Design |
|
1 | ||
| Advertisement Design |
|
1 | ||
| Software Development |
|
1 | ||
Some Jean R. projects
| Project Title | Skills required in the project |
|---|---|
| New Client Questionnaire Form | Data Processing Electronic Forms Format and Layout Microsoft Word PDF Word Word Processing |
| excel expert | Data Entry Data Processing Excel Visual Basic |
| Excel coding | Coding Data Processing Excel Statistics Visual Basic |
| Excel Layout templates | Data Entry Data Processing Excel PDF Word |
| Calculate formulas in Excel using Python for a small project | Excel Python |
| Make Invoice Template On Excel | Data Entry Excel Graphic Design PDF |
| Build me a bookkeeping excel macro | Accounting Data Entry Excel Finance |
| Convert minutes into tenths | Data Entry Excel Visual Basic |
| Auto Generate PDF Invoices from Spreadsheet | Data Processing Excel PDF Visual Basic |
| Excel Lookup based on a number in other sheet and give data bacl | Data Entry Data Processing Excel Software Architecture Visual Basic |
