How to enable data validation in excel jobs

I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditio...

I need a skilled Vue3 developer to write unit tests for a few components in my existing project. Key requirements: - Proficient in Vue3 and Vue test utils - Experience in writing unit tests for Vue components - Attention to detail to ensure all scenarios are covered - Ability to work under a tight deadline The project requires you to write unit tests for: - Navbar component - Search functionality - Form validation This project is time-sensitive so I need someone who can get started immediately and deliver high quality results quickly.

I am in search of a skilled developer to create a web dashboard using Python with Django framework. The purpose of the dashboard is to monitor a specific service. Admin can create new services or update / delete Ability to add commands to start a service if it crashes by using the commands and notify on successful execution. As well as provide web dashboard for visibility . If this service crashes, the dashboard should send notifications via email and then restart the service. Key Requirements: - Develop a Python-based web dashboard using the Django framework. - Implement a monitor for a specific service. - Configure email notifications to be sent out to a designated email address upon service crash. - Enable the dashboard to...

I urgently need an Excel whiz capable of converting Word documents, PDF files, and other document files into Excel, as soon as possible. There are no specific formatting requisites for the Excel files post-conversion. Ideal Skills: - Proficiency in Word, PDF, and other file formats - Excellent Excel skills, with ability to handle any type of conversion - High attention to detail - Strong commitment to speed and accuracy - Readily available for immediate start Experience in similar rapid file conversion projects will be highly advantageous. Plese ensure you can fulfil the requirement for immediate turnaround before placing your bid.

I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to lif...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I'm a BCA student with proficient skills in Microsoft Office, Access, Oracle & my SQL. I'm currently seeking a freelancer with advanced data entry proficiency to assist with data entry tasks. Specifically, I need help with: - Entering data into a document - Ensuring that the document has advanced formatting requirements, including tables, charts, and images Ideal skills and experience for this job include: - Proficiency in MS Office Suite (Word, Excel, PowerPoint, Access) - Experience with advanced document formatting - Attention to detail - Ability to work with data accurately and efficiently Please note that while my project is mainly focused on data entry, a background in database ma...

I'm needing a skilled Wix developer to build a membership website for our association. This project encompasses numerous features: - Member Registration: Design an accessible registration process for new members. - Payment Processing: Implement a seamless and secure system for processing recurring membership subscriptions. - Member Login & Account Management: Enable members to login using their email and password in order to manage their own account details. Prior experience in executing similar projects and knowledge in payment gateways is preferred. The website should be user-friendly, guaranteeing our members a smooth and intuitive experience. Your expertise in building Wix websites will be instrumental to the suc...

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup pro...

I need a proficient WordPress designer to revamp my company's website. You will be working primarily on the landing page and integrating a small WooCommerce store. Here's a brief breakdown of my needs: Landing Page: - Ensure a minimalist and modern design theme - Must include: - A hero image/slider - Our company logo and tagline - "About Us" section - Showcases on why to choose us - Detailed "Meet the Team" section - A "Collaborations/Companies" section - A user-friendly contact form WooCommerce Store: - Enable a functional product search feature - Load some demo products as an example. I will upload my products afterward. Ideal skills for this task include: - Proficiency in Wor...

I need an experienced system administrator with a strong background in security to help me address a specific vulnerability on my dedicated server. The identified issue is that the remote SSH server is configured to allow/support weak key exchange (KEX) algorithms. I would like the freelancer to: - Conduct a thorough investigation to identify all weak KEX algorithms present on the server - Implement the necessary fixes to remove these weak KEX algorithms Additionally, I'd like the system admin to upgrade the Nginx server on my Linux operating system to enable Transport Layer Security (TLS) 1.2. Ideal skills and experience for this job include: - Proficiency in Linux system administration and security - Strong kno...

I have a PDF file that I need converted into a Word document. The purpose of this conversion is to enable editing of the contents within the file. The layout of the PDF file is quite complex as it contains various images and tables. I would appreciate if the Word document could be formatted in a standard business format. Ideal Candidate: - Proficient in converting PDFs to Word - Experience with complex layout conversions - Attention to detail in formatting - Understanding of standard business formatting

I'm seeking a proficient freelancer to assist in a straightforward yet critical task. The project involves: - Data Entry: You will be required to input simple text or numbers into an Excel sheet. - Data Collection: Sourcing of data forms part of the project. This encompasses the need to gather the necessary information for the task. The ideal candidate for this role should have: - Strong Excel Skills: Proficiency in Excel is a must. You should be comfortable with data entry and basic functions. - Attention to Detail: Accuracy is paramount in this task. - Research Skills: The ability to efficiently source and collect the required data. Candidates with a track record of com...

...am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Project...

I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the for...

Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I'm in need of an expert who can create a custom education and training platform that mirrors the functionalities and user experience of platforms like Udemy. Basic programming language php laravel.11 Key Features: - Course Creation Tools: I need the system to have user-friendly tools to enable easy content creation and updating. - Student Progress Tracking: Implementation of tools that monitor and track the progress of the students as they move through the courses. - Discussion Forum: A forum that allows students to interact with each other, ask questions, and discuss topics related to the course material. Content Offered: - Video Courses: The platform will have video lectures. - Text-based Courses: Supporting materials in text form...

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow a...

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup pro...

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It shou...

I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.

business profit loss reporting excel(Jan, Feb & March)

Please Sign Up or Login to see details.

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the othe...

I'm in need of a skilled WP Job Manager/Smyles Plugin expert to make some changes and additions to both the back-end and front-end of my website. The primary focus of this project is to modify the back-end using the Smyles Plugin. Key requirements: - Expertise in WP Job Manager/Smyles Plugin: You should have proven experience with these plugins and be able to implement the necessary changes competently. - Back-end Development: You will be tasked with adding new search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities will include: - Implementing new se...

...assistance to improve my Excel workbook used for estimates and bids. The ideal 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 contrac...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

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 extens...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I'm in need of a proficient web designer who can help create a user-friendly website to promote my business. The business revolves around organizing and promoting various types of events, including business conferences, social gatherings, and live performances. Key Requirements: - Aesthetic appeal: The website should have an attractive layout, capable of engaging visitors and driving attendance for our events. - User-friendly interface: Ease of navigation is crucial. Visitors should find it easy to explore our upcoming events. - Robust features: The website should enable promotional activities such as ticket sales, event schedules, event descriptions, and a gallery for previous events. Required Skills: - Experienced in web development and design -...

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can de...

I'm in need of a skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. You...

...experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward ...

I am seeking an experienced Excel expert to help resolve an issue with a percentage 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.8...

I'm in need of a skilled website designer to create a portfolio website that focuses on building brand awareness of my work. The website is currently on Wix and needs to be moved to WordPress and re-created on there to make it more dynamic. Key Features: - Image gallery: This is crucial to showcase a variety of my work. The images should be displayed in an appealing and interactive manner. - Contact form: The website needs to have a user-friendly contact form to enable potential clients to get in touch with me easily. Ideal Skills: - Proficiency in web design, with a sharp eye for aesthetics and user experience. - Experience in creating portfolio websites with image galleries that ar...

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 • Performanc...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

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, particul...

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**...

...developer to update my current PHP website admin interface to utilize the Bootstrap 4 admin theme. 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 t...

...developer experienced in working with the Solana network and trading bots, with a mandatory requirement of being knowledgeable about the Pumpfun platform. Responsibilities: Create a bot/tool to manage trading from multiple wallets on the Pumpfun platform. Enable the bot to generate multiple wallets. Configure Solana quantities to buy per wallet. Develop an auto buy and sell bot to make a project appear legitimate with many sales and buys, thereby boosting projects. Ensure speed execution on the first buys to avoid snipers. The initial buys will be made from different wallets in varying quantities, with all transactions going through simultaneously or with a few seconds' difference. Allow for auto-tipping and prioritization ...

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

Thank you!

...financial plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do no...

I need a freelancer with web scraping skills who can extract product prices and models from my 17 competitors. Ideally, the freelancer should be able to: Extract information accurately and comprehensively. Upload all the extracted information into an Excel sheet. Create a simple online website to facilitate this process. I have hosting and a domain. Enable me to update the extracted information with a single click. Complete this task within a maximum of 48 hours. Please include detailed proposals in your application on how you would approach this project.

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).

I'm in need of an experienced app developer to create a mobile application for catering services on the Android platform. Key Features: - Menu Display: The app should allow users to browse through our catering services menu. - Order Placement: It should facilitate users in placing orders directly through the app. - Payment Integration: The app must have a secure payment gateway to enable seamless transactions. Ideal candidate would have: - Proven experience in Android app development - Prior experience in developing e-commerce or service based apps - Familiarity with integrating payment gateways into mobile applications - Strong communication skills to ensure a smooth collaboration and understanding of requirements. I ...