How we use custum in data validation in excel jobs

Hi, I have done it as discussed.

...Property Management Platform that helps landlords, property managers, and staff streamline every aspect of property oversight. This project extends beyond basic property/tenant management, incorporating advanced financial accounting, invoicing, document management, automated notifications, staff/vendor management, analytics, data import/export, and robust security measures. Initially, we’ll focus on a web-based solution using React (front-end) and Node.js + PostgreSQL (back-end). We also plan to future-proof the system for possible expansions to desktop and mobile platforms. If you have experience building complex, secure, and scalable SaaS/web apps, we’d love to see your proposal! Key Features & Modules 1. Property & Unit Management • Track pr...

I'm looking for someone skilled in Excel to help me with a data transfer task. I need to pull information from one spreadsheet and add it to a column in another. Key Requirements: - Transfer of text data between two simple spreadsheets (comprising simple rows and columns) - Matching of data based on an exact match in a single column Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks

EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected items (check box) w...

I need help organizing confidential client data in an Excel spreadsheet. The data is currently in one column and needs to be split into appropriate columns for First Name, Last Name, Phone number, Email, Birthdate, Mortgage start date, mortgage term, and Client Birthday. - Required Skills: Intermediate level Excel proficiency, with experience in using formulas to manipulate data in Excel. - Platform: The session will take place on Microsoft Teams, where I will share my screen. - Data Format: The data is currently organized in an Excel Spreadsheet. Due to the confidential nature of this data, I am unable to share it via email. The ideal freelancer for this job would be able to work sw...

We are looking for skilled developers to demonstrate their ability to integrate PAX payment terminals into Android applications using the POSLink SDK. The goal is to assess your understanding of the integration process, ability to troubleshoot, and overall proficiency in creating a reliable and secure solution. Requirements: Application Functionality: - Implement basic connectivity with a PAX terminal using the POSLink SDK. - Using Android Studio's Kotlin/Java - Process a test transaction (e.g., sale or refund) with a user-defined amount. - Display the transaction result (e.g., success or error) on the app’s UI. Code Quality: - Ensure modular, maintainable, and well-documented code. - Use best practices for error handling and logging. Security: - Adhere ...

I'm in need of a doors and windows-based software that can generate production drawings and quotations based on my cost estimations. I've laid out the algorithm in Excel files, which will be provided for this project. As a developer, your responsibilities will include: - Creating a user-friendly interface (UI) that allows easy access to the software's functions. - Implementing the cost estimation and production drawing generation features. The ideal candidate for this project should have robust experience in: - Java with JavaFX: This is my preferred programming language and framework for this project. - Software development for Windows: The software needs to be compatible with this platform. - UI design: The software should have a simple, intui...

I have a small excel file. I need to convert in excel VBA. The project will be completed by Spanish language. The file and more details will be shared via chat box. Thanks!

...websites in under 60 seconds, without data storage. Scope of Work Performance Analysis Analyze the current scraper code for performance bottlenecks, focusing on areas such as network latency, processing delays, and inefficient code structures. Implementation of Parallel Processing Integrate asynchronous processing using libraries such as asyncio and aiohttp for non-blocking HTTP requests. Explore multiprocessing or threading to handle 20 websites in parallel efficiently, ensuring resource utilization is optimized. Code Optimization Optimize the scraper code to reduce the processing time per site to 1 second or less, focusing on efficient parsing and minimal overhead. Ensure proper error handling and retry mechanisms for failed requests to maximize throughpu...

...seeking a skilled Excel expert to create a reconciliation tool for comparing two payment datasets. The first dataset comes from our internal ledger (Genie Ledger), and the second from our payment provider (Payment Gateway Data). Key Tasks: - Identify important data fields for reconciliation, considering factors like Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a tool that compares the two datasets, showing all workings on a dedicated front cover sheet. - Identify any reconciliation discrepancies and highlight them on the front cover sheet. The ideal candidate should have: - Extensive experience in using Microsoft Excel, particularly with macros - Strong analytical skills - Attention to detail and abili...

I'm looking for two, 15-30 second, 2D animated, casual tone, "how to" commercials for my company. The animations casual style but keep in mind that our company is a foundation giving to the elderly in the society, conveying the ease and fun of using our products or services. Ideal skills and experience for the job include: - Proficiency in 2D animation - Experience in creating casual content - Ability to deliver within the specified timeframe - Prior work with "how to" commercials is a plus.

I'm in need of an auditing company to provide a professional financial report and statement on a football club. The report should cover the last two fiscal years. A stamp from the auditing company is necessary for validation. Specific requirements: - Comprehensive financial report - Covering the last two fiscal years - Compliance with International Financial Reporting Standards (IFRS) Ideal skills and experience: - Certified auditing firm - Expertise in sports financial audits - Proficient in IFRS Please reach out if you have the necessary qualifications and experience.

I require assistance with developing a macro in Excel. The macro needs to interact with local Excel files and perform specific functionality. The details of the functionality will be provided after the initial discussion. Ideal skills and experience for the job include: - Proficiency in Excel, particularly in macro development - Experience with automating tasks in Excel - Ability to understand and implement specific instructions - Good communication skills for discussing project details

I'm looking to develop a multiuser website for collecting school ID card data and capturing photos. Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: Users should be able to upload photos from their devices and also utilize real-time camera capture. The website should NOT include editing tools such as cropping. - Data Collection: ID card data will be uploaded via CSV/Excel files. Ideal Skills: - Full-stack web development - Experience with real-time photo capture integration - Proficiency in handling CSV/Excel uploads - Knowledge in developing multiuser platforms Please provide examples of similar projects you have completed.

We are looking for experienced freelance link builders to help us secure high-quality backlinks for our website, , through ABC link exchanges. The ideal candidate should have experience with outreach, strong negotiation skills, and a proven track record of securing authoritative backlinks. You will be responsible for finding relevant websites, reaching out to webmasters, and securing links in exchange for links from the websites we provide. Responsibilities: Identify niche-relevant websites for link exchange. Outreach to website owners, editors, or managers to negotiate ABC link exchanges. Provide regular reports on progress, including sites contacted, agreements made, and live links secured. Ensure high-quality and niche-relevant links (no spammy or unrelated sites)...

I'm seeking a beginner-level assistant for my regular work. Your primary tasks will involve conducting research and creating simple PowerPoint presentations on given topics. Key Responsibil...my regular work. Your primary tasks will involve conducting research and creating simple PowerPoint presentations on given topics. Key Responsibilities: - Researching topics and creating simple PPTs - Hiring and interviewing team members - Managing existing team and content in excel Skills and Experience: - Strong communication skills English/Hindi - Proficiency in Excel and PPT Ideal Candidate: - A college student with a working computer - Looking for long-term work - Flexible with working hours Please note: - We will connect over a call on Saturdays or ...

...intuitive interface for data entry, monitoring, and reporting. GIS Module: Geospatial data visualization. Integration of PostGIS for spatial queries. Mobile App: Offline data collection with synchronization. Support for Android and iOS. Dashboard: Real-time analytics and visualizations using libraries like D3.js or Chart.js. Interoperability Layer: Enable integration with external systems Data Storage: PostgreSQL for structured data. PostGIS extension for spatial data. Hosting: Cloud-based for scalability (AWS, Azure, or GCP). Use Docker containers for easy deployment and environment consistency. 2. Data Flow Design Input Sources: Mobile app: Real-time or batched data uploads. Manual entries via the MIS. Processing: Data...

I need an expert in Excel automation and API integration to help me in calculating GHG emissions, specifically Carbon dioxide (CO2). The primary data source for the calculations will be an API, so experience with API integration is crucial. The project involves: - Automating the process in Excel for GHG emissions calculation - Using API for manual data entry - Focusing on Carbon dioxide (CO2) emissions The final output of the project should be in the form of a dashboard visualization. Therefore, experience in creating dashboard visualizations is essential.

I'm looking for help with rewriting and transferring some Excel tables for financial reporting. The tasks are straightforward and primarily involve basic data transfer without the need for specific formulas or calculations. Standard formatting is acceptable, so no specific formatting guidelines need to be followed. Ideal skills for this project: - Proficiency in Excel - Attention to detail - Basic understanding of financial data - Good data transfer skills

I need my intricate Excel sheet transformed into a PHP web application, complete with a MySQL database. The Excel file consists of 10 interconnected tabs, filled with VBA functions and classes. Key Requirements: - Replicate data calculations and transformations in PHP - Create user input forms and validations - Implement user authentication system with multiple roles - User roles should include: - Admin: Full control and oversight - Editor: Able to modify content - Viewer: Restricted to observation only Ideal Skills: - Proficiency in PHP and MySQL - Extensive experience with Excel VBA - Strong understanding of user authentication systems - Ability to replicate complex data processes in web applications Please only bid...

We are looking for someone to help us enhance our existing dataset by adding publicly available email addresses. Source of Dataset: The dataset is provided in Excel format. Size: There are 11,817 entries requiring email addresses to be added. Data Type: The emails must be entered into the same spreadsheet. Important Guidelines: All email addresses must be sourced from publicly available information in compliance with GDPR and other applicable data protection regulations. The methodology used to locate these email addresses is at your discretion, provided it adheres to legal and ethical standards. Each email entry should be accompanied by a URL or source reference to verify its public availability. Ideal Candidate: E...

...values aren't displayed on the graph bars. For better visualisation, I need the numerical values to appear inside the graph bars as text. Add Averages to Reports: In the report section, include an average of the survey results. This should be visible both on screen and in the exported .xlsx file. Skills Required: PHP MySQL JavaScript (for graph enhancements) Experience with data processing and performance optimization Deliverables: Improved CSV import functionality with faster processing and guaranteed file availability. Graphs with displayed values inside bars. Averages displayed in both on-screen reports and exported Excel files. Additional Notes: Please ensure the changes are thoroughly tested before delivery. Let me know if you require acc...

Project Description: We are looking for an experienced developer to integrate multiple social media platforms into our application. The goal is to enable seamless access to influencer data and campaign metrics for our users. This integration will support automated data fetching and provide insights for influencer marketing campaigns.

...100 10 Cork 25 35 65 85 105 10 Galway 22 32 62 82 102 10 ... (Repeat for all 26 counties but different pricing per county excel be provided) Fastway Note: If all items are Fastway-eligible, apply a flat €10 delivery rate. Product that this applies too already done (and live like this) SIte already has fastways setup done, plust there is enquiry only about products which can't be ordered on the site. We expanding the setup to have 5 weight classes with each state/county (26 of them) having their own pricing for each weight class. However the surcharges for extra items in the basket be same across the 26 counties Logic for Multiple Items in Basket Base Price: Use the highest-tier item's delivery price as the base. Additional Items...

...publishes data from Excel, specifically bond characteristics. The pages will include: Main, Bonds Selector, Indices, About Us, and an additional Bonds page. A Figma layout is provided and the task is to replicate it accurately. Key Features: - The website does not need to be responsive or mobile-friendly - Users will only view, not interact with or upload, Excel data Design Expectations: - A minimalistic and clean aesthetic, as opposed to modern or overly sleek designs - Corporate and professional styling is not required, but a clear understanding of minimalistic design is crucial Ideal skills for this project include: - Proficiency in front-end web development - Experience with Figma to web replication - Strong understanding of minimalistic design ...

I'm looking for someone to help me with creating a data entry form . The Excel template is provided by me. This will be a simple form that I can add my projects data to a spreadsheet also I can edit the Data. The Excel rows should be added automatically once a new project has been added .

Position Summary: We are looking for a rigorous and competent data entry professional to ensure the entry, processing and management of data in our systems. The ideal candidate will be proficient in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or ...

Looking for a detail-oriented data entry specialist for product catalog management. (~1,500 products) Key responsibilities: Manual data entry of product information into Excel/Google Sheets Accurately copying product image URLs from provided online sources Following provided guidelines for data organization Requirements: Strong attention to detail Proficiency in Excel/Google Sheets Reliable internet connection Ability to handle repetitive tasks with accuracy We provide full training and ongoing support throughout the project. Part-time/flexible hours available. Please share your relevant experience and availability to get started.

Hello, We are seeking an experienced developer to create specific functionalities for our WordPress site using HivePress and its extensions. ■ Request Case List ShortCode Task Description: Please create a shortcode to display the following content: ■ A Single Page in the REQUEST Extension Task Description: Display the following content: Sample made by AI PHP for SNIPPET → Please click here CSS → Please click here Preview: Link Page: Where did you write code? " " Place: CHILD THEME > > ■ Matched Tasks List (Incomplete) ShortCode Task Description: When a user A makes a request and another user B makes an offer and they match, create a shortcode to: Display a list of matches for user B. Show t...

Project Brief: eCommerce Data Analysis and Visualization Objective: To leverage data analytics tools to enhance decision-making, improve sales performance, and optimize customer experience within an eCommerce platform. Key Contributions: Excel: Cleaned, organized, and processed large datasets to ensure accuracy and consistency. Conducted advanced analyses using pivot tables, VLOOKUP, HLOOKUP, and data validation techniques. Developed dynamic dashboards for real-time tracking of sales, inventory, and customer metrics. Power BI: Designed interactive dashboards to visualize KPIs like revenue growth, cart abandonment rates, and customer acquisition. Connected multiple data sources to create unified reports, providing actionable insights for stakeh...

I'm looking for a freelancer to help me link my Excel file containing employee names and shifts to another file. The data is personal and related to roster information. Ideal skills for this job include: - Proficiency in Excel - Experience with data linking - Understanding of personal data handling and privacy - Attention to detail

I'm seeking an Excel specialist to help me create a sophisticated dashboard and tracking tool for compliance data. Key Responsibilities: - Automating processes with macros to streamline compliance tracking - Assisting in the design and development of a user-friendly dashboard - Automated email system which track the due dates and triggers the email to the respective email addresses. Ideal Skills: - Proficiency in Excel with a strong focus on automation - Experienced in complex formula creation and data analysis - Prior experience in designing dashboards and tracking tools - Familiarity with compliance tracking is a plus Please provide examples of previous Excel projects you've completed, particularly those involvi...

I'm looking for an expert in data management and Excel/CSV manipulation. The project involves merging multiple CSV files with custom combination rules. Key Responsibilities: - Analyze and understand the structure of the provided CSV files. - Implement custom rules to merge specific data from those files. Ideal Skills: - Proficiency in handling and merging CSV files. - Excellent understanding of Excel and its data manipulation capabilities. - Ability to understand and apply custom rules for data combination. - Strong attention to detail. Experience with data science or data analysis is a plus.

I am seeking an experienced web designer to create a professional, informative, and business-oriented website. The project will be executed in a methodical, phase-by-phase manner to ensure quality, attention to detail, and a cohesive end product. As I do not currently have a defined brand style or color scheme, I will require guidance in establishing these elements as part of the design process. Project Phases and Requirements: Phase 1: Brand Identity & Home Page Design Collaborate to establish a cohesive brand identity, including color scheme, typography, and visual elements that align with the business's values and goals. The Home Page should be designed to reflect the newly developed brand style and serve as an intuitive entry point for visitors, with clear navig...

I need assistance creating custom metaobject definitions in Shopify, specifically for product data. Key Requirements: - Define metaobjects for product attributes: Dimensions and weight, Material and color, Warranty and instructions - Implement specific validation rules for each attribute Ideal Skills: - Extensive experience with Shopify - Proficient in creating and defining metaobjects - Able to implement custom validation rules

I'm seeking an Excel specialist to design a financial dashboard for monitoring investments. The dashboard will primarily display financial data and needs to be tailored to track investment metrics. Ideal Skills: - Advanced Excel skills - Data visualization - Financial analysis - Dashboard creation Your proposals should reflect your experience with similar projects.

I am looking for a skilled developer with proven experience in building complex and interactive admin dashboards, ideally for applications related to transport, logistics, or systems requiring real-time tracking. This project must strictly adhere to the following: Fixed Budget: €500 - €1,000 Deadline: Maximum of 2 weeks. The dashboard will be used to: Monitor real-time activity (drivers, passengers, and trips). Analyze performance using KPIs. Generate detailed historical reports. Provide a user-friendly and ergonomic interface, optimized for desktop and mobile screens. Budget and Deadline (Please Read Carefully): Budget: €500 - €1,000 (Fixed). Deadline: 2 weeks maximum. Applications exceeding the budget or timeline will not be considered. Key Features: Real-...

I'm seeking a dedicated Virtual Assistant with a strong focus on data validation and cleaning, specifically using Google Sheets. I need a professional who can help streamline my workload and tackle a variety of administrative tasks. Key Responsibilities: - Data validation and cleaning using Google Sheets - Potentially managing emails and scheduling appointments - Handling spreadsheets and other administrative support Ideal Candidate: - Detail-oriented with strong organizational skills - Experienced in data entry and administrative tasks - Proficient in using Google Sheets - Committed to providing timely and reliable task completion I look forward to discussing how you can help me save time and focus on growing my business.

...for my Excel file "Report1". Here's the functionality I need: - When the user clicks the "Select File" button in the Excel file, they should be able to choose the Word document (e.g., "SampleForm1"). The macro should transfer the text fields from the Word file to the corresponding columns in the Excel report. - Additional clicks on "Select File" should add a new row for each new entry. - The Word file uses legacy forms, which may complicate things, but this needs to be handled. Considerations: - The software versions in use are Office 365. - Text fields from the Word file should match with the columns in the Excel file by field name. - If a field from the Word file does not exi...

I'm seeking a diligent data entry professional to help with manual data entry from printed documents into Microsoft Excel. Key Responsibilities: - Manually transcribing data from printed documents into an Excel spreadsheet. - Ensuring accuracy and attention to detail during the data entry process. Ideal Skills and Experience: - Proficient in Microsoft Excel, including knowledge of basic functions. - Prior experience with manual data entry. - Excellent attention to detail and ability to maintain focus over extended periods. Please only apply if you have experience in manual data entry and can maintain high levels of accuracy.

I am looking for an Excel professional with strong problem-solving and analytical skills to assist with data analysis. Ideal candidate should be: - Well-known in the field of Excel - Proficient in data analysis - Excellent at problem-solving - Able to create complex formulas - Skilled in data visualization

...Develop test strategies, test plans, and test cases for the Baidu Click and Filtering System, ensuring that the system meets the expected functionality and performance in data collection, real-time detection, and offline analysis. **Automation Testing & Tool Development** - Develop and maintain automation testing scripts and tools for modules such as click data monitoring, anti-fraud detection, and machine learning models. - Build an automated testing framework integrated with the CI/CD process to ensure continuous testing and prompt feedback. - Create Python-based tools for automated testing, ensuring secure handling of data and incorporating encryption/decryption functionalities as needed. **Test Environment Setup & Attack Simulation** - Create...

...The application can be created completely in this technology, or can only be used for back-end, eg in the form of web API. Even so, the project must meet the conditions of use of MVC, multilayer architecture, object programming. Also, the SQL code line must not appear in the web project to separate the web page and database code (the exception is the call of SQL procedures - but make sure you know what "SQL procedure" and "call SQL procedures"! Creating a multilayer application, ie. At least the layers of presentation, Application, Infrastructure and Domain must be included. All functionality must be created and used using services (Services). In the presentation layer there must be no direct use of infrastructure layers (ex...

*Job Overview* : We are seeking an experienced STATA Analyst to conduct advanced econometrics statistical analysis on firm-level microdata. The ideal candidate will have expertise in working with panel data, applying econometric models, and generating actionable insights to support research and decision-making. *Key Responsibilities* : - Perform data cleaning, preparation, and validation for panel data. - Conduct econometric analyses using STATA, such as fixed-effects, random-effects, and difference-in-differences models. - Interpret and report results with clear, concise summaries and visualizations. - Collaborate with the team to refine research objectives and provide data-driven recommendations. - Ensure compliance with data...

I am looking for an Excel expert who can create a shortest distance freight matrix for me using Australia's NHVR route planning tool. The matrix will be based on specific truck combinations that I will provide. Initially, I will supply a list of origins and destinations, but I need the matrix to be easily expandable for future use. Key Requirements: - Creation of a simple distance-only freight matrix - Integration of a user-friendly Excel form to add new locations - Incorporation of specific truck combinations into the route planning I am not familiar with programming or VBA, and I would like to know if this project is feasible before awarding it. Please, check the NHVR API tool link: Ideal candidates should have

Job Title: Create Excel/Google Sheets by Extracting Data from Instagram Profile Description: I am looking for someone to analyze my Instagram profile and create an Excel or Google Sheets file based on publicly available data. The file should contain 3 separate sheets with the following information: Followers: A list of all followers. Likes: A list of all users who liked a specific post. Comments: A list of all users who commented (only the names of the commenters). Platform: Instagram only Data Scope: Approximately 320 individuals total (for all three categories). No additional data will be provided. All information can be extracted directly from my public Instagram profile. Deliverable: A clear and organized Excel or Google Sheets file wi...

We are seeking an experienced CAD freelancer with a mechanical engineering background to assemble and create technical drawings for a standard bearing unit project. Only applicants with knowledge of bearing operation and mechanical systems should apply. Architectural or animation-focused designers are not suitable for this task. Key Tasks: Assemble all provided parts (in .STEP format) into a functional unit, ensuring proper constraints and alignment (e.g., bearings, seals, housing, screws). Modify one part: the housing, by extending its top curve slightly to meet updated specifications. Create accurate technical 2D drawings (.dwg or .dxf) with standard views (front, section, details) and a complete Bill of Materials (BOM). The assembly includes only 4 non-sta...

I'm in need of a high voltage power supply, akin to the Gambetti LF-500. This project has two phases: initially creating a laboratory version for testing and validation, and subsequently designing a board-level version for a new product. The AC output of this power supply will be utilized to generate a plasma discharge in an aerated water mixture. Key tasks include: - Developing a usable laboratory version of the power supply - Designing a board-level version for product integration - Ensuring the AC output is suitable for plasma generation The initial laboratory version will need to meet the exact specifications of the LF-500. Safety features are crucial, with both overload and short-circuit protection required. Ideal candidates for this project should have...

I'm looking for a freelancer to help with data entry of approximately 1500 products into Zoho. The product information includes: - Product descriptions - Prices and SKUs - Inventory levels The data is available for copy and paste on a per product basis. I require basic data entry with no elaborate validation checks needed. A keen attention to detail is important to ensure all data is entered accurately. Ideal skills for this job include: - Proficiency in Zoho - Excellent data entry skills - Attention to detail

Please Sign Up or Login to see details.