
Formatting data to bring number values
- or -
Post a project like this$90
- Posted:
- Proposals: 19
- Remote
- #3213374
- Expired
WordPress Expert✮Shopify Expert✮Graphic Designer✮AutoCAD 2D & 3D✮CV Writer & Designer✮Fullstack developer

WEBSITE DEVELOPMENT & DESIGN ! WORDPRESS ! JAVA ! PHP ! JAVASCRIPT ! GRAPHIC DESIGN | VIDEO | EXCEL VBA & MACRO EXPERT

Cloud (GCP/Azure) | ETL | Spark (PySpark/Scala) | Python | Data Science | Machine Learning
Data entry|Translation| Product listing(uploading) to different platforms| Graphic Design |Online research| Mathematical work |File conversion| Typing
527048856324675643264363657325610663091106318174712373831789616532951243491535561411
Description
Experience Level: Entry
What I need to do is write a formula for multiple criteria.
The raw data is in the DATA tab that houses all of the information that is being imported for an exported sheet into the DATA tab in column A thru L. On the data table I added columns M thru R to be able to tell me information like is the intervention true or false, does the time of day meet the night/weekend criteria, this may not be needed.
Column R is where I would like the score to be displayed based on the criteria being met.
Ultimately what I need to do is score the following criteria: on the Data Tables I have what the criteria is and the score it shall receive
1. if Column J (Intervention Text) is True then Column I (Mitigation) must have text in it and Column G (Condition) must be safe for a score of 10 pts.
2. Column J (Intervention Text) is True and Column I (Mitigation) is blank for a score of 0 pts.
3. Column G (Condition) is at risk for a score of 5 pts ; no matter what the other cells have in it. The at risk condition gives it a score of 5.
The raw data is in the DATA tab that houses all of the information that is being imported for an exported sheet into the DATA tab in column A thru L. On the data table I added columns M thru R to be able to tell me information like is the intervention true or false, does the time of day meet the night/weekend criteria, this may not be needed.
Column R is where I would like the score to be displayed based on the criteria being met.
Ultimately what I need to do is score the following criteria: on the Data Tables I have what the criteria is and the score it shall receive
1. if Column J (Intervention Text) is True then Column I (Mitigation) must have text in it and Column G (Condition) must be safe for a score of 10 pts.
2. Column J (Intervention Text) is True and Column I (Mitigation) is blank for a score of 0 pts.
3. Column G (Condition) is at risk for a score of 5 pts ; no matter what the other cells have in it. The at risk condition gives it a score of 5.
Shana E.
91% (7)Projects Completed
5
Freelancers worked with
8
Projects awarded
50%
Last project
13 Apr 2021
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