Vlookup in data validation listPekerjaan
I'm seeking a professional who can compile a precise B2B mail/email list for local small businesses in my city. Looking for someone to create me a mailing & email list of businesses within specific postcodes of Australia (there will be 20 postcodes) I'm not interested in an outdated existing list.. i want someone to do the work of collating a current list. List headers will include..... Business Name Business Principal contact (if obtainable) Business Email Business Phone number Business registered mailing address Business industry Business registration date
...candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a good understanding of how general contractors operate and think about costs. A background in construction estimation might help but is not crucial. I...
I'm looking for someone to help me create a list of 2000 business contacts from specific websites, particularly names, company names, position, location information, event information, number of events, current events, past events in 2024, and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling a list of business contacts - Ensuring all email addresses are verified and duplicates removed. Note: The focus should be on getting accurate, up-to-date information.
I need a Python program to parse a JSON file and format it correctly to be JSON compliant. Key Requirements: - Input Data: The input data is in JSON format. - Output Data: The JSON output should be properly formatted and adhere to a specific schema or structure. Skills and Experience Required: - Proficiency in Python programming. - Strong understanding of JSON parsing and formatting. - Experience in adhering to specific JSON schemas or structures. Please let me know your experience in similar projects and any relevant information that would make you a strong candidate for this job. You will pass the name of the input file as an argument and the output file should be the same file name with the .output extension. The input file is att...
...calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, instead of getting 19.88%, the result I am seeing is 1987.95%...
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g...
I'm looking for someone to help me create a list of 2000 business contacts from specific websites, particularly names, company names, position, location information, event information, number of events, current events, past events in 2024, and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling a list of business contacts - Ensuring all email addresses are verified and duplicates removed. Note: The focus should be on getting accurate, up-to-date information.
I'm in need of a skilled LAMP programmer who can complete various form activation tasks and make minor improvements to our UI. This project has a strict deadline, and must be completed within a single day. Your main responsibilities will be focused on form activation, including validation, submission, and integration. Dashboard view and Notification and reports. We need these actions to be seamless, reliable, and in accordance with industry standards. For the UI design, we're looking for someone with an eye for detail to refine the layout and color scheme. The improvements should be subtle yet effective, enhancing the overall user experience. Successful candidates should: - Have extensive experience working with LAMP stack, particularly in form d...
...The primary purpose of this admin section is to manage content, so I'm particularly interested in revamping the forms and input fields. Key requirements include: - Update of the existing admin interface to Bootstrap 4 admin theme - Focus on enhancing the forms and input fields - Implementation of data validation within the forms The ideal candidate for this project should have: - Proficient in PHP and Bootstrap - Prior experience in revamping website admin interfaces - Strong understanding of data validation techniques - A good eye for user-friendly design Your task will be to seamlessly integrate the Bootstrap 4 admin theme and ensure that the forms are updated to include relevant data validation functionalities. Pl...
I have a dataset of images and I'm looking for someone experienced in U-Net algorithm. Project description: - Write PyTorch U-Net training model on top of provided base code (, , , ). - Train the model until achieving a validation dice score of min. 0.875. - Deliver source code and trained model until Wednesday 10 pm (Vietnam time zone).
...section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is on target. * Data validation for entry consistency: Ensuring that data is entered correctly, preventing errors. *Eligible to insert in google sheets with same formatting The ideal freelancer for this project should have: - Proficiency in Excel formulas and functions for tracking project progress. - Experience in...
I am in need of a comprehensive list of British service providers who do not currently have a website. This list is intended to be used for direct marketing purposes, so it should be well-organized and easy to understand. IMPORTANT: This means if I google the business name an city, I should not be able to find a website on Google. Facebookpages etc are ok, but no www. The list should include basic contact information for each business, such as the name, phone number, and email address if available. Ideal Skills: - Proficiency in online research - Data entry and organization - Familiarity with UK businesses and service providers - Direct marketing experience Looking forward to your proposals.
I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus
I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.
I'm looking to compile a comprehensive list of e-mail addresses from various companies. This list will serve as our contact database for marketing outreach purposes. The ideal candidate for this task should have the following qualifications: - Proficiency in internet research and data mining. - Previous experience in compiling e-mail lists for marketing purposes. - Strong organizational skills to categorize the e-mail addresses by company name. - Ability to cross reference collected e-mail addresses against our existing list of company names to ensure no duplication. The e-mail addresses should be those of general contacts within the companies, rather than specific executive or departmental level personnel.
I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in...
...where my website isn't opening in a secured connection. I require a proficient software developer who can address this problem by fitting the: - SSL certificate - Firewall settings - HTTPS redirect I've identified these elements as potential causes for the issue. The platform my website utilizes is WordPress, and the SSL certificate in current use is Extended Validation (EV). Ideal skills and expertise for the project would be: - Extensive experience in web security, particularly WordPress platforms - Familiarity with HTML, CSS, JavaScript – particularly, comfort with altering WordPress settings related to these languages - Ability to perform cybersecurity audits and suggest improvements - Hands-on experience with SSL certificates, specif...
...properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface. Skills Required: - Proficiency in HTML, CSS, JavaScript
Validation of Sample implementation of One Loan product (Business Loan) created by Transdigital team. - Help Transdigital team in End to end testing of the system after product configuration - Creation of Roles and Users - Generation of Reports - Conducting on the job training for Trasdigital Business Analysts
...don't have high tech background in mind, ensuring it is simple and intuitive. Context: We are a social ecommerce platform that uses an in-house inventory, order, warehouse management systems built by our tech team. Our goal is to move to ERPNext because it's easier to scale there. And also to be able to have our accounting team work there. The goal is separated on multiple phases but the first one and the most important is to build our dashboard on ERPNext by copy pasting what we have in the in-house built dashboard and creating DocTypes. After that, we'll create a new request for the other phases. Key features: - Custom field creation: The ability to create custom fields tailored to our specific needs. The system should allow for various ...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I'm in need of a comprehensive marketing list for Charlotte, NC that specifically targets businesses, particularly within the following industry sectors: dentist offices, chiropractor offices, restaurants, gyms, warehouses, lawyer offices, and doctor offices. Key requirements include: - Contact name - Phone number - Email address - Address The ideal freelancer for this job would: - Have experience in compiling marketing lists. - Possess excellent data research and mining skills. - Demonstrate attention to detail for accuracy. - Understand the importance of GDPR and data protection.
Am doing a project using a simple shell and tube heat exchanger design and I have a problem with Ansys fluent validation. I already drew the shell and tube heat exchanger, simple design. However, the problem is that am unable to get similar results as the actual value when it comes to pressure drop. for flow rate 1 am getting it correct, but mass flow rate 0.5 and 2 kg/s are different and far from the actual values for the pressure drop of the shell outlet. I need someone that can fix the issue achieve at least 6% or less error compared to the actual value.
I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.
...over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that whi...
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my install...Information:** - Columns for customer name, address, and account number. 4. **Summary:** - A summary section that provides totals for jobs completed and payments owed for easy reference. **Additional Features:** - The ability to filter and sort jobs by date, installer, or customer. - An input form for easily adding new job entries. **Skills Required:** - Proficiency in Microsoft Excel, including formulas and data validation. - Experience creating user-friendly and automated Excel sheets. **Deliverables:** - A fully functional Excel sheet as described. - Instructions for use and any nece...
I have a project that was initially built in HTML and now need to be replicated in Vue.js. The main functionality I need is interactive forms that integrate with CRM (Customer Relationship Management) systems. Key Details: - The main task is to convert the HTML forms to Vue.js, ensuring they are interactive and user-friendly. - These forms should be integrated into CRM systems, allowing for seamless data transfer and management. - Form validation should be handled client-side only. Ideal Skills for this Project: - Proficient in Vue.js and HTML - Experience with integrating forms into CRM systems - Strong knowledge of client-side form validations A successful freelancer for this project will be able to replicate the existing HTML forms in Vue.js...
I'm looking for a data sourcing and CRM expert to help me build a targeted lead list for prospecting. The ideal candidate will have experience in: • Identifying relevant data sources for lead generation based on an Ideal Customer Profile (ICP). • Sourcing high-quality contact information (emails, phone numbers) for 100-200 potential customers. • Data cleansing and validation to ensure accuracy. • Uploading the cleaned data into HubSpot CRM. Project Goals The goal of this project is to establish a foundation for targeted email marketing campaigns. This will be achieved by: • Creating a targeted lead list based on my ICP. • Uploading the lead list into HubSpot for easy campaign management. Your ...
...Danish, English). Contact Form: Implement validation, translations, CAPTCHA, and backend management. Multilanguage Support: Set up inputs for Swedish, Danish, and English without auto-translation. Articles and Blogs: Improve layout, image handling, and formatting consistency. Search Function: Enhance search to include titles and body text. Main Picture: Add functionality to change the main picture with size guidelines. Home and About Pages: Ensure consistent formatting and editable content. DNS and Email Setup: Correct domain pointers and enable email functionality on server. Proven experience with Django web development and multilingual websites. Strong knowledge of HTML, CSS, and JavaScript. Familiarity with backend systems and database management in Django. Please refe...
I'm in the process of developing a new power electronics product for industrial use. The current stage of development is in the prototype phase. For this project, I need a skilled professional who can help me with the following: - PCB Prototyping: I require assistance with the creation of the PCB for this new product. This includes the manufacturing of the board itself. - Creation of Test Plans: I need an expert who can help me create comprehensive test plans for this new product. This includes both hardware and software testing. Experience in creating test plans for electronics, would be highly beneficial. - Final Testing & Validation: Once the PCBs are produced and the test plans are in place, I would need a professional who can assist me ...
I'm in need of a professional web developer to create a basic website for managing workplace shift schedules. It is enough that this project has the qualifications to do the job. I am leaving a few photos so that you can have general information about the project design. It is sufficient that at least the texts that will be seen in the UI be in Turkish. Key Features: - Employee login and registration - Comprehensive shift scheduling and management tools - Facility to view and edit shift details - User access restrictors based on roles The web platform should be designed with a professional and corporate aesthetic, ensuring it's not only functional but visually appealing to users. Ideal Skills and Qualifications: - Proficiency in web development, pa...
...used on a list of URLs provided. The software should be able to handle up to 1000 URLs at a time and run specifically on Windows. Key requirements include: - Extracting scripts: The software should be able to seamlessly access the provided URLs and list the scripts used on each page. - Bulk processing: The software should be capable of handling a significant amount of URLs, up to 1000 at once. - Windows compatibility: It is essential that the software is designed to run on Windows OS. Website Accessibility: - Restricted access: Websites that require restricted access or login should be identified and reported separately. The software should skip such pages and indicate them as inaccessible. Ideal candidates should possess: - Proficiency in software development an...
I'm in need of someone to help with building a Java code for my project. The main task will be developing a code for input validation. Key Requirements: - Experience in Java programming - Proficiency in coding for input validation - Ability to work efficiently and deliver results in a timely manner This project will require someone with a good understanding of Java programming and the ability to create effective input validation. If you have a track record of successfully delivering such functionalities, I'd like to hear from you.
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.
I'm in a situation where I need assistance in creating an XML file and validating it with an XSD file. I am trying to work with and XSD files but hitting roadblocks. The result I'm seeking is an XML file which encapsulates transaction data. This specific data will be gathered from a database, making database management skills essential for this project. Key things I require guidance on include: - XML element creation for transactional data pieces - Using a database for XML data source - Validating the XML with an XSD file The successful freelancer for this project will need a high degree of proficiency with XML and XSD files. They will need the ability to explain complex concepts in an easy-to-understand manner as this project ...
I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageo...
I'm in need of an AI developer to create a sophisticated algorithm. This algorithm will assess specific symptoms related to hormonal imbalances and provide tailored recommendations accordingly. Key Features: - The AI algorithm should be able to assess the following symptoms --> FOR WOMEN : Fatigue, Weight gain/loss, Mood swings, Sweats, Menstrual irregularities, Premenstrual Problems, Acne, Libido decline, Hair loss, Hirsutism, Menstrual Migraine, and Sleep --> FOR MEN : Lowered libido, weight gain, mood changes, sweating The recommendations should be individualised and based on the symptoms identified. A sleek and intuitive user interface I'm looking for a freelancer with expertise in AI development and a proven track record in hea...
I'm looking for a proficient C programmer to undertake testing of a specific software module on a desktop application. The module under focus is centered around input validation, file handling, and memory management. As a freelancer for this project, you should be skilled in: - C programming, with a focus on testing - Evaluating input validation, file handling, and memory management techniques - Conducting various forms of software testing—functional, performance, and security are all needed. Experience with desktop software testing will be a significant added advantage. Accurate and comprehensive reporting is an absolute must. I look forward to entering a productive, successful partnership with you. Let's enhance the functionality, performance, and...
I'm looking for a Kubernetes expert to help me create a custom validation using Common Expression Language (CEL). While I didn't specify the precise purpose or type of data the validation will apply to, the primary goal is to enforce specific rules or criteria related to data. Key Requirements: - Proficiency in Kubernetes and custom resource definitions (CRDs) - Strong knowledge of Common Expression Language (CEL) - Ability to create robust custom validations to enforce data rules Please reach out if you feel you have the necessary expertise for this project.
I'm in need of a data entry clerk who will be working with text data and will organize it by category. The data doesn't require validation or verification, just simple categorization. Ideal candidate should: - Possess excellent attention to detail - Be proficient in data entry - Have experience working with text data - Be able to categorize information effectively This is a fairly straightforward task that requires precision and organization. I'm looking forward to working with someone who is reliable and meticulous in their work.
...Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system features. - An understanding of data reporting and analysis. A successful candidate should also demonstr...
...library into my project in full. I have integrated demo vesrion only. The primary goal is to improve the user experience by allowing for drag and drop functionality for file uploads. Key Requirements: - Implementation of drag and drop functionality using DropzoneJS - Ensuring DropzoneJS supports multiple file uploads at once - Do not need integration within the existing project structure. PHP Upload script working just fine. - Adherence to best practices for user interface design and user experience Ideal Skills and Experience: - Proficiency in JavaScript and relevant libraries, particularly DropzoneJS - Proven experience with front-end development and UI/UX design - Ability to integrate new functionalities to existing codebase Validation: - Start your quote wi...
I have a large set of data in Excel that requires thorough cleaning and organizing. - Tasks include: - Removing duplicates - Standardizing data formats - Data validation and verification - Identifying and correcting errors - Sorting and categorizing data Ideal Skills: - Proficiency in Excel or similar data management tools - Experience with data cleaning and organization - Strong attention to detail and accuracy The volume of data is significant, so I'm looking for someone who can work efficiently without compromising the quality of the work.
...Authentication logic with two roles: user and admin o Forget / Reset password logic required • /home o Accessible to logged-in users only o Displays bot updates and useful links o Updates data retrieved from the database • /profile o Accessible to logged-in users only o Contains a user profile data form o Displays database data upon form submission • /subscription o Contains one disabled “Buy now” component with Free plan • /admin o Table of users with 3 fields (email, name, phone) and pagination All features should be implemented with server and client side input data validation, adhering to best practices for security, performance, and extensibility. Key Requirements: - Strong proficiency in Pyth...
I'm looking for a Laravel expert to help me fix some bugs in my website. - The primary issue that needs to be addressed is fixing functions within the system. - These issues might be related to a range of functionalities, from file uploads to data validation and email sending, though I'm open to including other functions you think might need attention. Ideal candidates should have: - A strong background in Laravel development and debugging - Ability to troubleshoot and resolve a range of issues - Attention to detail and a proactive approach to problem-solving - Experience with fixing functions, file upload, data validation, and email sending would be a huge plus, though not mandatory. If you're a skilled Laravel developer wit...
I'm working on a project using Ignition 8.1.31 and need a feature implemented. The goal is to have a dropdown list in the perspective view that allows the user to select files from a specified directory. Key Points: - The dropdown should be populated with the file names upon the user clicking a perspective View button. - The Load button should be located on the perspective view. The ideal freelancer for this job should have experience with Ignition 8.1.31 and familiarity with creating dropdown lists that are dynamically populated based on user interactions.
...seeking a data-savvy individual with experience in compiling email lists to help me create a targeted list of small businesses in Australia for my email marketing campaigns. I will provide the business types I'm interested in: retail stores, restaurants, and service providers. Key Responsibilities: - Research and compile a comprehensive email list of small businesses across Australia, specifically in the retail, restaurant and service provider sectors. - Ensure the list is accurate, up-to-date, and segmented according to the provided business types. Ideal Candidate: - Experience in creating targeted email lists, particularly for small businesses. - Familiarity with Australian small business landscape. - Attention to ...
I'm looking for a freelancer to help me with email scraping to build a targeted email list in the education sector. Specifically, I'm interested in parents who are seeking tuition services for their children. Key Responsibilities: - Conducting research online to identify and extract email addresses of parents seeking tuition services for their children - Organizing the list in an easily accessible format that I can utilize for email marketing campaigns Skills and Experience: - Proficiency in email scraping and list-building - Prior experience in targeting the education sector is desirable - Understanding of lead generation and email marketing best practices
