System guru inc jobs

We need a complete design of sand separation system using cyclones to separate sand under 150 microns including air blower - feeding capacity 45 tons/hour of sand. Max cyclone dia 1.2m

I need a React developer to build a frontend for a Student Management System. Key Project Details: - Two Types of Users: The system will have both admin and normal user functionalities. - Entities: The project involves five main entities: students, admin, class, exam, hall, and scheduling. - CRUD Operations: The system should allow for Create, Read, Update, and Delete operations for the mentioned entities. Admin User Features: - Access Control: The admin user should have the ability to control user access and manage permissions. - Reports Generation: The system should be able to generate exam scheduling reports. I will provide you with the Swaggy API list for this project. The deadline for this project is Saturday night. Ideal skills and experience: - Pr...

I'm looking for a talented developer to build a web-based POS system with a focus on insightful daily sales reporting. Key Features: - Web-based POS system: The system should be accessible through the website itself, offering an intuitive interface for easy use. - Daily Sales Reporting: It's crucial that the system provides detailed and comprehensive daily sales reports. These reports should be easy to read and interpret. - Customization: The system should allow for future customization and integration of additional features, as the business grows. Ideal Skills: - Proven experience in developing POS systems, particularly web-based. - Strong understanding of sales reporting and data analysis. - Ability to create user-friendly interfaces. Plea...

I'm looking to create a binding within Openhab for an Elmo alarm system. The binding needs to enable the following functionalities: - Remote arming and disarming of the alarm system. - Monitoring the status of individual sensors and zones. - Sending sensor states to OpenHAB items. I do have a similar project that was written in Python for Home Assistant which I can provide as reference and guidance. Ideal Skills: - Strong experience with Openhab binding. - Proficiency in Python programming. - Familiarity with the Elmo alarm system will be a plus.

...existing ERP system. Key project aims include: - Customer data synchronization: Ensuring consistent, accurate customer information across platforms. - Order management integration: Streamlining order processes for increased business efficiency. - Inventory management synchronization: Maintaining real-time, synchronized inventory data between Zoho and ERP. With 11-50 users expected to utilize this integrated system, the ideal freelancer should not only possess strong experience with Zoho One and ERP integrations but also have a deep understanding of business processes, data management, and system admin work. Proficiency in managing user access and associated entity relationship is a plus. This endeavor aims to create a seamless workflow between Zoho and...

I'm seeking an experienced developer proficient in Node.js to create an online booking system for my hotel. Key Tasks: - Developing a booking system with easy-to-use interfaces for single rooms only. - Building an efficient room availability calendar. It is crucial for visitors to be able to easily check room availability and make immediate online reservations. Ideal Skills and Experiences: - Extensive experience in Node.js. Please provide proof of previous similar projects. - UI/UX design. The system should not only work efficiently but also be user-friendly and visually appealing. - Previous experience in building hotel reservation systems is a definite advantage. The goal is to streamline the process and increase my bookings. Please refer to the tasks a...

...customized CRM system specifically tailored for financial services and their freelancers. This system should be able to: - Track leads: The application should have a robust lead tracking system in place, allowing us to monitor and manage leads effectively. - Manage deals: Deal management is a crucial part of our business. The CRM system needs to support this feature to ensure smooth deal handling. - Provide performance metrics: It's important for us to evaluate the performance of our team. This CRM system should include tools to generate and present performance metrics. Additional features requested for this CRM system include: - Email integration: Seamless integration with email services to streamline communication and data management...

I'm looking for a ready-made ERP cloud accounting system like that offers these key features: - Inventory Management - Sales and Purchase Tracking - Financial Reporting I'm specifically seeking a system that has a: - Modern and sleek design I plan to integrate this ERP system with other software via API. Ideal Skills and Experience: - Experience with ERP cloud accounting system development - Proficiency in UI/UX designing - Proven ability in API integration with other tools - Familiarity with inventory management, sales tracking, and financial reporting systems. I want similar to

I need a skilled developer to integrate our custom in-house software with Oracle TimeCard. This is to allow for automated time entry. Key Requirements: - The integration should allow for automatic time entry from our custom in-house software to Oracle TimeCard. - The system should also enable the creation, updating, and deletion of timecard information in Oracle TimeCard. Ideal Skills: - Proficiency in Oracle TimeCard integration. - Experience with automated data transfer between systems. - Strong understanding of custom software integration.

I'm looking to sell a residential solar photovoltaic (PV) system that stands out for its energy storage capabilities and off-grid independence. The estimated space for installation is a medium-sized residence (1,000 - 2,000 sq ft). Ideal skills include: - Expertise in solar panel design and installation - Knowledge of battery energy storage systems - Understanding of off-grid solar systems - Experience with residential projects - Ability to estimate solar power needs based on space size Offer your skills to make this solar PV system stand out in the residential market.

I'm in need of a skilled and experienced Microsoft Project specialist to create a comprehensive project plan for my upcoming project. Key Deliverables: - The primary requirement is to focus on the Requirements Gathering phase. This should be treated with utmost attention and detail. Goal of the Project Plan: - The main objective of the project plan is to outline the project's timelines. This is crucial for our team to have a clear understanding of the deadlines and the flow of the project. Desired Level of Detail: - The project timeline should be detailed and broken down by week. This will allow for a more structured and easily trackable plan. Ideal Skill Set: - An expert in MS Project tool is a must. - Strong project planning and scheduling skills. - Proven experience in cr...

I'm in need of a simple, clean logo for my remodeling company. The logo should be: - Minimalistic in style - Primarily gray in color It will be used across various platforms including: - Online (websites, social media) - Print (business cards, flyers) - Merchandise (apparel, mugs) The ideal candidate should have: - Experience in logo design - A portfolio that demonstrates capability in creating simple, yet impactful logos - An understanding of how logos translate across various mediums, especially digital and print - Strong communication skills to understand my brand and translate it into a visual identity.

...client base! Here's the Game Plan: - Target: Verified US companies (1-500 employees) actively seeking top talent for their remote positions. - Become an Expert: Deep dive into the hiring needs and challenges of industries embracing remote work. Master the art of tailoring our recruitment solutions (traditional, RaaS, Staff Leasing) to meet the unique needs of small businesses. - Lead Generation Guru: Craft targeted prospecting and outreach strategies to generate high-quality leads. - Relationship Rockstar: Build and nurture long-term, trust-based relationships with key decision-makers at potential clients. Who You Are: - A proven lead generation and business development champion in the recruitment industry. - A deep thinker who understands the challenges and needs of remot...

I'm looking for a graphic guru who is able to create mini web banners that will be utilized for promoting a product. bid only if you can start right away

...ASTPP/Freeswitch developer to create an Interactive Voice Response (IVR) system for my project. The primary goal of this IVR system is to Play a pre-recorded message when a customer calls a DID, then route the call according to any routing rules configured on the dialplan. This means that the system needs to be designed to handle customer queries and direct calls to the appropriate department. Ideal Skills: - Proficient in ASTPP/Freeswitch - Experience in IVR system development - Strong understanding of customer support processes - Ability to design system for call routing The project is expected to be completed within a reasonable timeframe. A successful candidate will be able to understand the nuanced requirements of the system and devel...

I am seeking an experienced freelancer to code for an Industrial Automation System specifically focusing on manufacturing process control. Key Tasks: - Develop efficient code for my Industrial Automation System. - The code should aim at automating the manufacturing process control. - Testing the code for effectiveness and making necessary improvements. Skills and Experience: - Strong experience with IoT devices, especially industrial automation systems. - Exceptional coding skills, particularly in an industrial background. - Experience in manufacturing process control. - Ability to work quickly and effectively, as the project is needed ASAP. Experienced with Microsoft Azure Timeframe: The project should be completed as soon as possible. Applicants should have immediate...

I'm in need of a professional who can help with my private limited company's annual compliance tasks. Key Tasks: - Filing Annual Financial Statements - Conducting an Audit - Updating Statutory Registers Key Requirements: A. Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). B. Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). C. Assistance & Documents Preparation for Company's Current Bank Account. D. Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, and Director's Report. E. Preparation & Filing of Extract of Annual Returns & Financial Statements (Unlimited Transactions). F. Preparation & Filing of Annual Returns Form AOC - 04 (Financials Related Annual R...

Your Responsibilities: System Monitoring and Maintenance You will monitor system health, proactively respond to monitoring alerts, and inspect application and system logs to take appropriate action in case of error conditions. Development and Implementation You will support in defining and implementing Kubernetes deployments and provide consultation in creating Kubernetes manifests for custom deployments. Software Audits and Disaster Recovery You are responsible for software updates, VM configurations, and the system's disaster recovery. • general VM updates and configuration through ours to be built IaC definitions (Terraform, Ansible and Kubernetes) • inspecting newer container images and software versions • planning and executing updates on infr...

Hi, Um getting an error at my website: Warning: Creating default object from empty value in /home/chezluis/public_html/wp-content/plugins/canteen-essential/inc/framework/ReduxCore/inc/ Need desapear this from homepage...

...control of ventilation systems. The ability to work across multiple platforms is essential as the application needs to be compatible with iOS and Android devices, as well as Windows computers. Primary Features: - Timer scheduling - Remote control of ventilation systems - Monitoring parameters including temperature, humidity, twilight, and weather - Real-time notifications and alerts - Scheduling system actions - Support for multiple users simultaneously Given the sensitive nature of the data and operations, the application must be secure. Your work will involve implementing advanced encryption to safeguard our communications and data. The ideal candidate for this project should be proficient in mobile and desktop application development, with a deep understanding of systems�...

I'm seeking to build a comprehensive Pension Fund Administrative Management System tailored for my fund with 500 members. The system should incorporate the following key features and functionalities: - Workflow Tracking: The system should be capable of monitoring and managing internal workflows, ensuring tasks are assigned to specific users, with set deadlines and progress tracking. - Contribution Tracking: The system should accurately record and manage the contributions made by each member. - Investment Tracking: The system should include a functionality that tracks the investments made by the fund. In addition to the above, the system should have a Loan Management Module that allows the fund to offer loans to its members. The Loan Manageme...

It’s online hotel booking management job! Not a developer job! I am looking for a full-stack staff with experience in managing online hotel system. Key Features: - Reservation Management: manage reservation on different includes a calendar view to visualize and manage bookings. - Claim Handling: be responsive handling of customer issues. -adhoc task upon discussed Ideal Experience: - Prior experience in managing hotel management systems or similar online management platforms is highly desired. - Good communication in English if you can speak mandarin it is an advance point. Please submit your proposal. If you're confident please provide a short introduction about yourself.

I am looking for a proficient software developer to build an all-inclusive student fee management software. Key Features: • Ability to track multiple types of student fees • Capability to generate detailed fee reports • An automated reminder system. The software must smoothly integrate with our existing systems which include the school management system, attendance system, and our accounting software. Ideal Skills: • Experience in educational software development • Strong background in systems integration • Skilled in automation and report generation.

...a ticket reservation system to help manage vehicle bookings at my car repair workshop. Key Features: - Customers should be able to specify the type of repairs they need by describing it in a text field. - The system should capture this information, along with the basic details like their name, contact information, and the time they'd like to come in for the repair. Skills and Experience Required: - Experience in building ticketing systems, ideally for a service-oriented business like a workshop or a customer support center. - Familiarity with implementing text fields for user input. - Good understanding of user experience and interface design for a seamless customer journey. - Knowledge in database management to store and retrieve customer information. The s...

...Reference information] ([1] and [3] are for reference only) 【1　Background】 This technology pertains to a system that utilizes mobile devices in vehicles. Specifically, it combines a smart key system with Ultra-Wideband (UWB) wireless communication to authenticate the mobile device with the vehicle and precisely detect the location of the device. Based on this location, the system determines whether to allow or deny vehicle operations. This aims to enhance security and service quality. However, since UWB communication uses high-frequency bands, communication may become challenging depending on the device's location and surrounding environment. Therefore, this technology aims to provide a system that facilitates reliable high-frequency communication betwe...

...Python to help me build a robust CRM system. The project calls for a quick turnaround - I need it to be completed ASAP. Key Features: - Sales Pipeline Management: The system should help me track my sales process from lead generation to conversion. - Customer Interaction Tracking: I want to record all interactions with my customers, including emails, calls, and meetings. - Integrated Email Marketing: The CRM should have seamless integration with my email marketing tools so I can easily communicate with my customers. - Scheduling: I need the system to have scheduling capabilities to help me manage my time effectively. Primary Goals: - Improve Customer Satisfaction: The CRM should help me provide better service to my clients. - Increase Sales: The system shoul...

As part of my urgent project, I'm looking for an AI developer proficient in automatic scoring and evaluation with a strong understanding of the IELTS exam format. The aim is to build a comprehensive system capable of: - Precisely grading the speaking and writing sections of the IELTS exam - Identifying areas of improvement for each test-taker - Providing detailed individual feedback - Including evaluations for reading and listening sections For success in this project, familiarity with Natural Language Processing (NLP), Machine Learning, language testing, and proficiency in various AI programming languages is essential. Previous experience in educational AI software development such as automated grading systems will be highly regarded. Required Skills: - AI development - ...

...technology pertains to a vehicle control system designed to enable specific operations on a vehicle. Traditionally, there has been a smart system utilizing electronically authenticated keys through wireless communication with the vehicle. However, a new method using sound authentication with a device worn on the user's ear has been proposed. While this device offers a novel way to authenticate with the vehicle, using standard communication protocols allows authentication from a distance, which could lead to risks of unauthorized access by third parties. Therefore, the goal of this technology is to provide an improved vehicle control system that reduces the risk of such unauthorized manipulations.【2　Technology Description】 This technology involves a system...

I'm in need of a proficient individual who can help me set up my NAS System running openSUSE, including the configuration of a Docker system. I already have the hardware for the NAS system, so the primary focus would be on the software setup. Key Requirements: - Installation and configuration of a NAS System on openSUSE - Setting up a Docker system on the NAS - Configuring the NAS to run Web applications, Database services and a Media server - Ensuring the system is capable of supporting connectivity for less than 10 devices Ideal Candidate: - Proficient in setting up NAS Systems on openSUSE - Experienced in Docker system setup and configuration - Knowledgeable in configuring NAS Systems to support various applications - Skilled in en...

I'm seeking an experienced professional to set up a karaoke system with a main focus on installing a professional-grade audio mixer. An existing venue has been arranged for the setup. The ideal candidate will have a deep understanding of professional audio equipment and bring expertise in acoustic setup to ensure optimal sound quality in the space. Familiarity with karaoke systems and proven ability to work effectively within the constraints of the venue is required. A site visit to see the available equipments is preferred before the installation day.

I am facing an issue with incorrect message structures within my C# windows service application. - Problem: At present, our application is producing improperly structured messages - an anomaly that we are keen on rectifying. - Solution: I am in search of a proficient C# developer with significant experience in handling message logging, particularly with event loggers. You will be required to add the event logger and figure out what is causing our issues. - Timeline: The task is quite urgent, so I need someone who can begin immediately and deliver as soon as possible – I'm counting on your efficiency. Skills and experience: - Advanced knowledge of C#, especially in creating and troubleshooting windows service applications - Experience with event loggers, from implementation...

I'm in need of a proficient Simulink designer to assist me with a PID Control System Design project. The focus is on Position Control System. The project requires the following: - Expertise in Simulink and control system design - Knowledge of PID control development and its application in Position Control System and Car suspension Skills & Requirements: - Proficiency in Matlab and Simulink - Advanced knowledge in Control System Design - Prior experience with Position Control Systems and Car suspension - Extensive experience with PID control and electrical actuator Your task would be: - Design a PID control for a position control system - Implement this design in Simulink - Test and refine the system to ensure accurate and opti...

I'm currently seeking a marketing specialist with extensive experience promoting female oriented, high fashion apparels. Key Responsibilities: - Devise marketing strategies targeting women interested in modest fashion - Implement promotional campaigns focusing on high fashion apparel -social media marketing inc. ads management -influencer outreach and management -SEO capabilities on social media and website Ideal Candidate: - Experience in promoting women's fashion - Familiarity with marketing high-end, fashion-forward apparel - Proficient in trend spotting and fashion aesthetics - Excellent understanding of the fashion industry and specifically high fashion brands If you fit this profile and are passionate about fashion, I invite you to submit your proposal.

...tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamlessly integrates...

I'm looking for a talented graphic designer to modify a picture I have on hand. Key tasks include: - Adjusting color and lighting of the image - Altering the color scheme to remain simple, favoring neutral tones, particularly grey, I do like the yellow in it already - Changing the text to read "The Concrete Company Inc." - Adding a minimalistic and modern rook crown, or its equivalent, to the top Ideally, the successful candidate will have a strong background in photo-editing, with a particular emphasis on color correction and graphic design. Their portfolio will demonstrate their ability to create simple, yet visually impactful designs.

I need a comprehensive web-based content management system (CMS) which allows users to upload multimedia content. Key requirements include: - A secure, user-friendly interface for uploading and managing multimedia content (videos/photos). - Role-based access control for different users within the organization. - Automated content moderation and filtering to maintain quality standards. - An intuitive search and tagging system for efficient content retrieval. - Scalable architecture to accommodate a growing volume of content and users. Ideal Skills: - Proficiency in web development and CMS solutions. - Experience in designing and implementing multimedia content systems. - Strong understanding of user experience (UX) design principles. - Knowledge of security best practices in...

I'm looking for a creative designer to create a logo for my organization, Sierra Leone Community Social Organization Inc. The logo needs to feature the full name in a cycle or circular design. Key requirements and information: - Color preferences: Blue, Green, and white, . These colors should be used creatively to make the logo visually appealing and representative of the organization. - Concept and message: The logo should convey the themes of Unity, Community, and Growth. It needs to be a visual representation of these ideas, while also being a professional and memorable design. - Usage: The logo will primarily be used on print materials, so it needs to be versatile and suitable for this purpose. Ideal skills and experience for the job: - Experience in logo design, prefera...

...with Divi. I'm looking to create an online appointment booking system for an eye clinic. I need this system to have a range of features that will make it more convenient for our patients and staff. Key Features: - Online Payment: The system should support online payment through Stripe. This will allow patients to pay for their appointments in advance. - Swedish Payment Provider: Integration with the Swedish payment provider Swish is important, as many of our customers prefer to pay using this method. - Video Conferencing: The system should enable the setup of online meetings. These meetings should be conducted via video conferencing. This feature will be useful for remote consultations and follow-ups. - Calendar Booking: The system should have a...

have anyone can help me to install the Laravel system which buy from themeforest, thanks i will provide the domain and also the login of the hosting, thanks

I need a Student Information Management System developed with SharePoint and PowerApps. This will be a comprehensive tool for tracking attendance, storing documents, and managing information from contact details to medical records. Key components should include: **Attendance Tracking** - The system should enable manual entry by teachers. **Student Profiles** - Each student should have an individual profile displaying personal details, contact information and medical details. - Student details and parent details will be collected using Office 365 Forms and the replies should write directly into the student management system. **Document Storage** - A document storage section is required for maintaining relevant records and resources. Including student documents like...

I need an access control system that's structured based on the roles my users have, similar to the old system. Key Requirements: - I need the system to manage user permissions on an individual basis. This means that each user should have unique permission settings. - The system doesn't need to have options for temporary or time-based access permissions. Ideal Skills and Experience: - Strong background in access control systems. - Experience implementing role-based access control is essential. - Proficiency in customizing user permissions on an individual basis in a system.

...looking for a developer who can create a cashier system specifically for my coworking space business with a coffee bar. The system should be able to handle cash transactions and support cashier functions efficiently. What i expect from the system : - Expenses and income with easily generated reports - Stock management (track coffee and material usage) using raw materials and compound materails Ex. I add 100 gram of espresso and 1 liter of milk to stock When i sell 4 Late (20 espresso 200 milk) I will have left 20 espresso and 200 milk in stock - in my busieness the payement is only after you check-out so everymember should have his own profile with his payments and reciepts - when you check in you have to tell the staff to check you-in so the system start...

I'm in need of a proficient video editor who can bring a modern, edgy style to my social media videos, enhancing their appeal on platforms such as TikTok. URGENT URGENT URGENT!!! • Video Type: I require the editing of social media videos. • Editing Style: I'm searching for an individual who has a knack for creating modern and edgy editing styles that will capture viewers' attention and boost engagement. • Platforms: The final masterpieces will be primarily published on TikTok, so I'd prefer if they align with the platform's trending styles and fit within the preferred video length. • Ideal Skills: Proficiency in video editing software is a must, and previous experience with creating viral content for TikTok would be a game-changer. Do...

I'm seeking an expert Python Django developer to work on an ERP system for a lubricant oil manufacturing business. The main aim is to improve efficiency through exquisite control and management of different sectors. Key Features: - Inventory management - Sales tracking - Production planning - Finance handling - Logistics User Access: - The system must provide different access control for each department, allowing for optimal rights distribution and responsive control. The ideal freelancer will have proven experience in Python Django and a keen understanding of ERP systems in the manufacturing sector. Expertise in sector-specific challenges such as inventory management, sales tracking, and production planning is highly desirable.

I'm in need of a skilled CRM Developer to create a custom CRM system with a variety of functionalities and stringent data security measures. Key Functionalities Needed: - Contact Management: The CRM should be able to store and manage client information, including their contact details. - Sales Pipeline Tracking: It should track and monitor the stages of our sales process, helping us identify areas for improvement and potential bottlenecks. - Customer Support Ticketing: The system should provide a platform for our customer support team to manage and resolve client issues efficiently. - Job Sheet Tracking: I also require functionality to track repair/service jobs for various items like phones, PCs, cars, bikes, ACs, etc. Platform and Device Support: - The CRM should be a...

I'm seeking an experienced developer to create a minimum viable product (MVP) of a rent payment system with a reward component. The project involves building a user app, a landlord app, and an admin portal. Specifically, the user app should: - allow tenants to make rent payments through the app - provide a reward system for timely payments The landlord app should include: - functionality for managing rent payments - tools for monitoring the reward system The admin portal must have: - user management features - landlord management capabilities - transaction tracking functionality I'm looking for a developer who is not only skilled in app development, but also understands the dynamics of rent payment systems and reward programs. Experience with both front-...

I am seeking a skilled software developer to create a rental system CRM application with specific functionalities. Key Features Required: - Customer Management: The application should be capable of managing customer details, their rental history, and other related information. - Inventory Tracking: An efficient inventory tracking system should be in place to monitor the available and rented items in real-time. - Rental Scheduling: The ability to schedule rentals, track them, and send reminders to customers is crucial for this project. Platform Compatibility: The software should be compatible with various platforms including Windows, MacOS, iOS, and Android. Essential Functionalities: - User Authentication: The system should validate the users based on their login c...

...defense project of an IT software system to support their engineering and aftersales processes. Here's what is needed: - A keen understanding of user needs and expectations to meticulously improve engineering data and consumption downstream. This expectations involve tailoring to both aesthetic and functionality aspects for the customer. Ideal Skills and Experience: - Proven background in system design with a strong portfolio showcasing previous works. -Teamcenter and engineering data and Database solutions - Experience in user testing, user interface design, and usability testing. - Strong knowledge of UI design principles and techniques. - Proficiency in design and prototyping tools. I need a professional who can bring significant improvements to our system...

I'm looking for a freelancer with experience in setting up and customizin...looking for a freelancer with experience in setting up and customizing SafetyCulture auditing system. Key Requirements: - Inclusion of OHS, Fire, and Equipment Safety aspects - Setup for 1-10 users - No integration with other systems needed Ideal Candidate: - Proficient in SafetyCulture auditing system - Experience with safety aspects like OHS, Fire Safety, and Equipment Safety - Ability to customize for a small user group - strong communication skills for clear understanding of needs and providing assistance. We will be working with SafetyCulture to be able to provide assistance in the setup, and support. I will also be providing a specification document with all requirements t...

I'm seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula ...