Advanced Excel Spreadsheet for Product Database and Order Management

I am looking for a freelancer who can create an advanced Excel spreadsheet for our product database and order management. The ideal candidate will have strong skills and experience in Excel, specifically in data management and automation. Specific Features: - Data validation and conditional formatting: We need the spreadsheet to have validation rules to ensure accurate data entry, as well as conditional formatting to highlight any errors or discrepancies. - Formulas and functions: The spreadsheet should include formulas and functions to perform calculations and automate tasks. - Macros and automation: We would like the spreadsheet to have macros and automation capabilities to streamline our order management process. - Product Database: Which will include all the information of any design created by our designer. Fields will include: Product ID or SKU: <Unique><alphanumeric> Product category: <String> dropdown menu list will be provided and need to expandable. Picture: <jpeg> Collection: <String> Design Number: <number> Content: <string> Fibre test: Yes or No. If Yes then test result: <string> Colour: <String> Reed: <Number> Weight: <Number> grams Max width possible: <Number> cms Wash care: - Order Management: We have 14 stages for any order to be completed. I want manage and overview of all the stages. Stage 1: PI generation. Enter the number SKU in the order. Generate an unique order ID for internal purpose. Stage 2: Advance/guarantee Received status. If yes, then enter number of days to complete the order. Stage 3: Raw material order or yarn order. If Yes, then enter the date of order. Stage 4: Dye of yarns, If yes, then enter the date of dyeing. Stage 5: Warp status. One SKU have One Warp. Date when the warp was prepared and name of the weaver. Stage 6: Date when Weaving start. For every SKU Diff or same. Stage 7: Date when Weaving ends. For each SKU Stage 8: Fringes knotting date. For each SKU Stage 9: Washing date. For each SKU Stage 10: Ironing Date. For each SKU Stage 11: Stitching Date: For each SKU Stage 12: Packing Date: For each SKU Stage 13: Dispatch Date. And name for Tempo Stage 14: Logistics. Name of the logistics provider. - For every Order ID I want to calculate the cost for producing and my Net profit from the order. Some what like a ledger. Cost of raw materials Weaving Iron and washing Packing material Tempo shipping Advance received for the order Balance payment. - As for the design specifics, I expect a customized design UI or a popup menu to input Product data into the database. - Search functionality: Search by product id to show all the details of the product. Search by design number to show all the product ID with the same design. Search by collection to show all the product in a collection - If possible, I want to make a pdf of search results like a report. We are manufacturer of fabrics with different designs so we need to organise our Design and product efficiently. Update Frequency: - Weekly: The spreadsheet will need to be updated on a weekly basis to reflect new product information and order updates. Overall, we are looking for a freelancer who can create a comprehensive and efficient Excel spreadsheet that will serve as our product database and streamline our order management process. Above are the specification required for the project more information will be provided after candidate selection.