Build a three-point dashboard fed by 3 spreadsheets (2 external)
- or -
Post a project like this391
£60(approx. $75)
- Posted:
- Proposals: 11
- Remote
- #3878735
- Awarded
Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.
Dhaka
Creative Hacking | Marketing Management | Funnel Building | Traffic Tracking | Campaigns Optimization | Automation | GOOGLE EXPERT
Dubai
Experienced Graphics designer |Experienced WordPress Full Stack|SharePoint Expert|Data Entry Team |flyer/business card/Brochure||2DAnimation||Photoshop work|
Islamabad
|BPR|Research|Marketing|Translations|Design|Technical Support|Assistance|more... much more...
Quilmes
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
Rawalpindi
Data Consultant (Expert in Excel, VBA/Macros, Google Sheets, Fillable Pdf services, Data Entry)
Zwota
19467142105103231792823598252454441315100555831127026817835974987226738914301
Description
Experience Level: Entry
I am trying to build a three-point dashboard fed by 3 spreadsheets (2 external).
I would like to RAW MATERIAL STOCK file to supply data to feed columns I and J of the "Copy of Production Plan Aid- 09.03.23" -"copy of Bom Pull out" Sheet. I have tried doing this with a Vlookup but it does not like me. If the item is in-stock "column I" should show the stock amount. for the components (green highlight) If in stock, the about should also show in Column I.
I would like the Blue cells of the "Copy of Production Plan Aid- 09.03.23" -"copy of Bom Pull out" Sheet to be filled by totalling the instances of each item. The green highlighted components should auto-calculate. I initially thought it should be a Vlookup + sumif + importrange but that is not working for me.
For the dashboards, I have added in the headers I would like.
For what we can make,
I want the sheet to show what item codes are in stock and ready to go in Dark green - this will be fed from "Copy of Production Plan Aid- 09.03.23" -"copy of Bom Pull out" Sheet (column G of the blue highlights). for items where we have enough components ( green highlights ("Copy of Production Plan Aid- 09.03.23" -"copy of Bom Pull out", columnA) I would like them to show in Pale green. If we do not have enough stock, I would like it to show in the Amber and Red part of the dashboard.
Amber & Red
I would like any missing componentry to show in this dashboard. I would like it Colour coded to show products missing 1-2 components in orange and items missing more in red.
Bulk Formula
In "Copy of Production Plan Aid- 09.03.23" -"copy of Bom Pull out" Sheet i have added the formulas about the ingredients that make them up, Is it possible to scan the sheet and have it continuously calculate any formulas below safety stock level ( shown "Raw Material Sheet" column AQ) and add them to the dashboard in pale green? Again any formulas that cannot be made would be shown in the Amber & Red dashboard - the Bulk one would only show orange or red depending on how many component ingredients are missing.
I hope i have explained it well, Please let me know if more is needed.
I would like to RAW MATERIAL STOCK file to supply data to feed columns I and J of the "Copy of Production Plan Aid- 09.03.23" -"copy of Bom Pull out" Sheet. I have tried doing this with a Vlookup but it does not like me. If the item is in-stock "column I" should show the stock amount. for the components (green highlight) If in stock, the about should also show in Column I.
I would like the Blue cells of the "Copy of Production Plan Aid- 09.03.23" -"copy of Bom Pull out" Sheet to be filled by totalling the instances of each item. The green highlighted components should auto-calculate. I initially thought it should be a Vlookup + sumif + importrange but that is not working for me.
For the dashboards, I have added in the headers I would like.
For what we can make,
I want the sheet to show what item codes are in stock and ready to go in Dark green - this will be fed from "Copy of Production Plan Aid- 09.03.23" -"copy of Bom Pull out" Sheet (column G of the blue highlights). for items where we have enough components ( green highlights ("Copy of Production Plan Aid- 09.03.23" -"copy of Bom Pull out", columnA) I would like them to show in Pale green. If we do not have enough stock, I would like it to show in the Amber and Red part of the dashboard.
Amber & Red
I would like any missing componentry to show in this dashboard. I would like it Colour coded to show products missing 1-2 components in orange and items missing more in red.
Bulk Formula
In "Copy of Production Plan Aid- 09.03.23" -"copy of Bom Pull out" Sheet i have added the formulas about the ingredients that make them up, Is it possible to scan the sheet and have it continuously calculate any formulas below safety stock level ( shown "Raw Material Sheet" column AQ) and add them to the dashboard in pale green? Again any formulas that cannot be made would be shown in the Amber & Red dashboard - the Bulk one would only show orange or red depending on how many component ingredients are missing.
I hope i have explained it well, Please let me know if more is needed.
A N.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
50%
Last project
6 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
-
What is the expected timeline for the completion of the dashboard?
A N.12 Mar 2023Hi,
I was hoping for a day or two at most. Does that work? If it will take longer I will have to update the team as soon as possible.Milon H.12 Mar 2023Okay, I can do it
1053224
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