Programming in excel 2013 jobs
Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33781462503. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would gre...
I'm looking for a developer skilled in python and Pytest who can focus on unit testing for my project. Primarily, the focus is to test the M2 application deployment and environment creation processes. The ideal candidate can delve into the codebase, understand the required specifics, and conduct the testing procedures in a systematic, efficient manner. Key tasks: - Developing and executing unit tests using Pytest - Zeroing in on testing M2 application deployment - Assuring quality of environment creation functionality - Evaluating and analyzing results of the tests Skills and Experience: - Proficiency in Python programming language - In-depth working knowledge of Pytest - Sound understanding of the software testing lifecycle - Prior experi...
I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.
I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data ty...
I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete these tasks in a t...
...a robust background in social media management spanning over 5 years, I am confident in my ability to drive engagement and elevate your online presence effectively. Throughout my career, I have honed my skills in creating compelling content, implementing strategic campaigns, and fostering meaningful connections with audiences across various platforms. My experience extends to crafting tailored strategies based on analytics insights, ensuring optimal performance and ROI. I excel in staying abreast of emerging trends and algorithm updates, enabling me to adapt strategies swiftly and capitalize on growth opportunities. Moreover, my strong communication skills and a keen eye for detail empower me to maintain brand consistency and uphold the highest stand...
I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.
I require a freelancer to update sales quantities, prices and dates in an Excel document on a weekly basis. This project will not require any specific formatting or layout, so you'll have the freedom to set it up in a way that's most efficient for recurring updates. Ideal Skills and Experience: - Proficiency with Excel - Attention to detail - Experience with sales data analysis - Consistency and reliability to perform weekly updates
...finance and production advice. I'm in need of a talented web designer to create an engaging informational website specifically for Australian agriculture broad acre farmers. The site should serve as a detailed resource, highlighting key aspects of our work and organization. Key Features: -A professional look and feel `-Wordpress based - A comprehensive "About Us" page to outline our mission, goals, and team. - A clear display of our contact information on every page. - Easliy updated by ourselves with graphics based on data collected and stored in MS Excel -Potential for client login The perfect candidate for this job would be an individual with a keen eye for modern web design, experience building informational websites, and ideally some knowledg...
I'm looking for an Excel expert to help me clean up a dataset. I have a large dataset that contains both text and numeric data that needs to be cleaned up. The specific issues I'm facing are: - Text Data: There's a need to find and remove any duplicated values, missing values, and correct any formatting issues. - Numeric Data: The numeric data in the dataset has inconsistent decimal places and a few outliers that need to be identified and adjusted. Ideal skills for this project include: - Proficiency in Excel, particularly in data cleaning and data analysis. - Experience in handling both text and numeric data. - Strong attention to detail to identify and rectify issues within the dataset. Please, only apply if you have experien...
I am in need of a skilled Python developer to create a scraper for me. The primary task of this scraper will be to extract website content. Here are the specifics of the project: - Data Extraction: The scraper should be able to collect data from a specific website. This data will be in the form of text and images. - Update Frequency: I require the data to be updated once. This means that the scraper should be designed to pull the data once and not re-visit for updates. - Data Format: The extracted data should be saved in a CSV file. This is the preferred format for the end result of the scraping process. Ideal Skills and Experience: - Proficiency in Python: A strong background in Python programming is essential. - Web Scraping Experience: Previ...
...project. Here's a glimpse of what I have in mind: Primary Responsibilities: - Appropriate implementation of chosen Flask framework. - Contributing with innovative ideas to enhance the project's effectiveness. Necessary Skill Set: - Strong command over Python programming language with expertise in Flask. - Experience in developing & managing complex Python applications. - Advanced Python coding skills are needed, as experience matters most in this kind of project. Although I haven't decided on specific tasks or functionalities yet, your advice and suggestions would be highly appreciated. There could be future opportunities for web scraping, data analysis, and automation ahead. Interested parties, kindly share your portfolios of r...
I'm in need of a skilled typist for a data entry project. The task involves entering data into an Excel spreadsheet. Requirements: - Excellent typing speed and accuracy. - Previous experience with data entry. - Proficiency in Excel. - Ability to follow instructions precisely. Ideal Candidate: - Proven track record in data entry tasks. - Strong attention to detail. - Reliable and able to meet deadlines. - Good communication skills. If you have the right skills and experience for the job, I look forward to receiving your bid.
I'm looking for a skilled professional who can assist me in entering text data into our project reports. Ideal Skills and Experience: - Experience working with project reports - Proficient in digital data entry - Attention to detail The reports will be provided in digital format, such as Excel or Word. The main task will be to ensure all text data is accurately entered. Additionally, the ideal candidate should be able to ensure the report maintains a professional and consistent format throughout. You may be asked to apply company branding or use specific fonts and sizes. The ability to work with minimal supervision and meet deadlines is a plus.
I need a freelancer to enter numeric data into Excel from digital sources. Key Requirements: - Proficient in data entry - Expertise in working with Excel - Attention to detail The task is straightforward and simply requires the accurate transfer of numeric information into a pre-existing Excel template. I will provide the data in digital format (Excel, CSV) and expect it to be entered systematically according to the format provided.
I have a PDF document that is a mix of scanned and text-based content that I need converted into an editable Word or Excel format. I need this completed as soon as possible. The output needs to be fully editable, meaning that the text should be recognized and convertible to a format where I can change, add or remove text as needed. This means the scanned parts should be OCR-ed accurately.
I'm seeking an experienced freelancer for a data entry project. The task involves converting PDF files containing mixed data, both textual and numerical, into Excel. Ideal Expertise: - Proven experience in data entry - Proficiency in Excel and PDF conversion - Accuracy and attention to detail Please ensure all data in the PDF files is correctly transferred to the specified Excel format. I'm looking to post this project up to 100 Rupees. If you have the skills and can handle this type of work, I encourage you to bid.
...least one real user active in that league. There are 10 leagues in my database. Nothing should happen if there is no active user linked to a league/team. Now, here's the exciting part. Every match should be generated at 00:00 with certain random variables. So, for example, if a player is in League 1, I want all matches in that league to be generated. I've created an example of how I want to visually present this to the user. Check out the example here: Online Soccer Game Example. Choose Ajax and Feyenoord, and start the match for a preview. Changes must be for More details: What programming language is your script currently written in? PHP What information should successful freelancers include in their application? Past w...
I have a small set of textual data that needs to be typed into an Excel sheet. The purpose of this project is to prepare the data for analysis. Key responsibilities: - Type less than 100 rows of textual data into an Excel sheet. - Ensure data accuracy and consistency. Ideal skills for this project include: - Experience with data entry. - Proficiency in Excel. - Attention to detail to avoid errors. The successful freelancer will need to deliver the Excel sheet with the data accurately typed within the given timeframe.
I need a Python 3 script developed that continuously operates with the Lauterbach Trace32 system. This s...Python 3 script developed that continuously operates with the Lauterbach Trace32 system. This script must perform automated actions which include: - Reading data: It must access and read global variables from Lauterbach Trace32. - Modifying data: It should also make changes to the data in the Trace32 system as required. Ideal skills and experience: - Strong knowledge of Python 3 programming essential - Good understanding of Lauterbach Trace32 to ensure seamless integration. - Experience with scripts that operate in real time or continuously. Looking forward to working with skilled and experienced developers. Creating this intricate continuous script will great...
I'm looking for an expert in Odoo who can develop for me sample module to show how Odoo works. I am NOT new to programming, but I am new to Odoo. Some background information (not part of this project), my original task is that I need to convert some existing modules to Odoo. So I need to learn the structure, constructs, building blocks and architecture of Odoo. So, this project is a small learning assignment is for me to understand how the things are in Odoo. You need to build them and transfer the knowledge to me about how you have built it. I know ABC of python, so will not be a headache for you (hopefully). I want: Part 1: - Two new modules Classes and Students in Odoo. - Classes Module will have properties Class (String) and Room (String) - Student...
...consistently produce high-quality fashion and lifestyle content, all while engaging with followers in a way that feels authentic and human-like. Key Responsibilities: - Developing and programming an AI influencer that can create and share posts on Instagram - Ensuring that the content created aligns with my brand's vision and aesthetic - Implementing features that allow for audience engagement and interaction - Monitoring and managing the AI's performance and adjusting strategies accordingly Key Skills and Experience: - Proficiency in AI and machine learning - Experience in social media content creation and management - Understanding of the fashion and lifestyle industry and trends - Proven track record in developing successful social medi...
I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need ...
I'm looki...handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus. The role demands strong organizational skills and attention to detail. A sound understanding of database principl...
The project entails accurate entry of numerical data into an MS Excel spreadsheet, with a focus on report generation. The ideal freelancer should be well-versed with basic Excel functionalities, such as simulations and formulas, to ensure efficient data processing. Key responsibilities would include: - Accurate and efficient numerical data entry - Setting up Excel to run basic simulations and formulas - Generating effective and accurate reports from entered data The freelancer should have strong attention to detail to maintain data accuracy and proficiency in MS Excel, specifically in creating basic simulations and formulas. Previous experience in data entry and report generation is highly preferred.
In need of a skilled professional who can effectively handle data entry tasks online. The project revolves around entering basic data, primarily names, emails, etc., into Google Sheets. Ideal freelancer will have: * Prior experience with online data entry * Proficiency in Google Sheets * Attention to detail with entering data * Ability to enter data quickly and accurately This job does not require any complex calculations, formulas, or programming – just straightforward data entry.
I'm experiencing an issue with my ESP32 software, written in C++, where it consistently hangs on the first screen. I need a developer to dissect and fix the root cause of this problem. The ESP32 runs a program that allows users to control levels of a gas coming through a tube. I mixes 100% CO2 with room air. When the machine starts up it goes through a calibration process and gives a message saying "Don't put on the Mask". After the calibration process then it allows user to adjust the time/session duration. After editing some code it is getting stuck on the "Don't Put on the Mask" message during calibration and not getting to the next screen. When my other developer compiles the code on his computer it works fine on the same device. However wh...
...specific use: an SMS marketing campaign. Key Requirements: - Configuration/Programming: I'm not just looking for someone who can install RapidPro, but someone who can configure it for a specific purpose. - SMS Marketing: The main goal for this configuration is to set up an SMS marketing campaign. - Scheduled SMS Blasts: I expect the system to be able to send scheduled SMS blasts to a subscriber list. - Integrations: I need the campaign to integrate smoothly with Social media platforms and Analytics tools. Ideal Skills: - Expertise in RapidPro and SMS marketing tools - Strong programming and configuration skills - Experience in integrating systems with Social media platforms and Analytics tools - Previous experience in setting up similar SMS mark...
I require a professional with a keen understanding of both Excel and iOS Numbers to convert a single-sheet Excel spreadsheet into an iOS Numbers document. The converted document will need to retain multiple functionalities including: - Basic calculations - Data visualization - Conditional formatting No data interdependency or connectivity with other aspects is required in this case. The ideal candidate should have significant experience with data conversion between these two platforms and a solid grasp of maintaining functionalities in iOS Numbers. Familiarity with creating visually engaging spreadsheets will be highly regarded. I would like to have conversation with someone to make sure I am asking for something reasonable and to clarify exactly whats neede...
Python programming and machine learning in 2 to 3 days. It requires data pre-processing and data cleaning. The machine learning model will need to be developed. And a relevant report will need to be completed, in 2 to 3 days. The data and details will be provided
I want to rank in the top three google results on average for the following keyword phrases Target Country is USA 1 - Accident Lawyers 2 - Truck Accident Lawyers 3 - Car Accident Lawyers 4 - Boat Accident Lawyers 5 - Construction Accident Lawyers 6 - Lyft Accident Lawyers 7 - Uber Accident Lawyers 8 - Pool Accident Lawyers 9 - Personal Injury Lawyers 10 - Motor Vehicle Accident Lawyers 11 - Personal Injury Lawyer Near Me 12 - Lawyer For Car Accident 13 - Personal Accident Lawyer 14 - Car Lawyer Accident 15 - Attorney Personal Injury Near Me 16 - Accident Lawyers Car 17 - Personal Injury Lawyer Attorney 18 - Car Accident Attorney Lawyer 19 - Accident Lawyer Near Me 20 - Lawyer For Auto Accident This is for the website The ranking must hold for 1 month before escrow
...live in Eastern Europe or Latin America and be at least 16 years old and . ✻ NO EXPERIENCE REQUIRED ✻ You do not need any experience whatsoever, but you must be clever and eager to learn. No. I am *not* being charitable. I am being practical. ✻ PAYING YOU TO LEARN ✻ No. You aren't dreaming. I value intelligence and problem-solving ability over experience. I'd prefer to work with someone who is clever and learns quickly rather than someone experienced but is not very intelligent and/or does not solve problems scientifically. Would I hire an Isaac Newton or an Albert Einstein even if he had no programming experience? Of course I would. ✻ TESTS ✻ You must pass several difficult logic tests to work with me. The first logic test you complete for me will be an...
I need a skilled developer to create a custom indicator for my Tradeovate trading platform. Key Requirements: - I require a 'bar-to-bar' indicator. This means that the indicator should be able to display the comparison of some high/low/close values on four consecutive bars. Ideal Skills and Experience: - Proficient in Tradeovate trading platform - Expertise in creating custom indicators - Strong understanding of bar-to-bar indicators - Experience with programming high/low/close comparisons Please reach out if you have the necessary skills and are able to deliver accurate, efficient and reliable code.
...a baseline construction schedule built already; it has around 1000 activities, the schedule is cost & resource loaded. I will provide the update in excel (actual start, actual finish, actual cost), the monthly activities that needed to be updated (actual date & Cost) around 100 activities every month. Please note sometimes I need to provide you comments on the schedule update, so you need to fix the comments. I need you to update the start/finish date and insert the actual cost monthly (once every month). Plus, prepare small narrative report including some P6 PdF. I have the P6 layouts I will share with you. I have the report and layout built in already and I will share it with you. Finally, send me XER file, and Narrative report every month. It is very i...
I am looking for a freelancer to set up the layout for my edirectory website. Layout Preferences: - I prefer a professional and elegant l...my edirectory website. Layout Preferences: - I prefer a professional and elegant layout design. Color Scheme: - Although I don't have specific colors in mind, I would prefer cool/warm tones for the website. Reference Websites: - I have reference sites that I would like the freelancer to take inspiration from. Ideal Skills and Experience: - Experience in web design and layout setup - Proficiency in HTML, CSS, and other relevant programming languages - Creativity in designing a professional and elegant layout - Ability to incorporate cool/warm tones into the color scheme - Understanding of user experience...
I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.
I'm in need of an experienced developer to build an undefined banking algorithm. Unfortunately, I can't specify the functionalities that the algorithm must have, or the programming language it should be written in. However, whatever decision you make should serve a main goal that is yet to be defined. Due to this, it's important that you're adaptable, can make informed assumptions, and work under minimal supervision. For this job, you must have: - Expertise in Python, Java, or C++ - Experience in banking algorithms - Understanding of potential functionalities like fraud detection, risk assessment, and loan approval - Skills in either improving efficiency, increasing security, or optimizing resource allocation. Since the main goa...
I'm in need of a skilled website designer who can help me with some critical changes on my website. The main tasks involve changing my phone number, password, and Gmail address. These changes are needed across multiple pages of the website. Key tasks include: - Updating the phone number on multiple pages - Changing the password consistently across the entire site - Implementing a new Gmail address in place of the current one The ideal candidate for this job should have: - Proven experience in web design and development - Proficient in HTML, CSS, and other necessary programming languages - Ability to make consistent changes across a large website - Good communication skills - Attention to detail and the ability to ensure all changes are made accura...
...it, is to create a compelling proposal essay for my professional/technical writing class. The challenge at hand is the housing discrimination faced by people on parole. The crux of the issue, as I see it, is the bias encountered during rental applications. This keeps parolees stuck in a cycle of inconsistency, making it harder for them to re-integrate into society. This paper should aim to construct a new method to tackle this problem. Your proposed solution should predominantly aim to reduce discrimination in the housing sector. How we plan to achieve this is through community awareness programs. You need to build a case for educating the public and reducing prejudices, arguing that information and understanding can be a powerful tool against discrimination. Your ...
I'm in need of an Excel expert who can help me create a sophisticated formula for data analysis. The data I'm working with is moderately complex, involving multiple variables. It's all housed in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, with a focus on complex data analysis - Experience in creating advanced formulas for data manipulation - Strong understanding of data structures in Excel and how to work with multiple variables - Previous projects involving statistical analysis would be an advantage I'm looking for someone who can not only create this formula, but also explain its function and how to adjust it for future data sets. Please provide examples of similar project...
I'm in need of a Java developer to create a standalone application for a small school. The application will be used to manage student records, various school resources, and facilitate communication with parents. Key Features: - Student Records: The application should be able to manage and track student progress through interactive line charts. - School Resources: The app should also help in handling school resources such as time, costs, and salaries. - Parent Communication: There should be a feature to enable communication with parents in a structured and efficient way. Ideal skills for this project include: - Proficiency in Java development - Experience in creating standalone applications - Knowledge of building HTTP connections - Strong underst...
...an intricate Excel model to calculate a cumulative threshold commission scheme, tailored to three varying levels of seniority: Junior, Mid-level, and Senior. The model needs to be exceptionally flexible and versatile to allow for easy manipulation and scenario planning. Key Requirements: - Create a multi-level commission scheme: The model should have different commission percentages for each level of seniority. - Cumulative Threshold Calculation: Incorporate a mechanism to calculate cumulative thresholds. - Revenue Generation Calculation: Develop an accurate formula that calculates the revenue generated. - Flexibility in Threshold Percentage: Ensure that the threshold percentage can be flexed. - Cash Retained in the Business: The final model should account for cas...
...need an expert in Excel spreadsheet and dashboard creation to help me with a project related to the management of properties. The project involves the following tasks: - Data analysis - Formulas and calculations - Data visualization The data to be used in this project will mainly revolve around a situation room containing property under management status and updates. Specifically, the dashboard should track and monitor the following key metrics: - Rent collection and payout status - Tenant and business complaints - Contacts details - Contracts status - Property profits - Property location - Owner notes - Comments If possible to have it as geolocation kml as a copy I'm looking for someone with strong experience in creating dashboards and spreads...
...expertise in using Python for backend development, JavaScript and HTML for frontend. Key Components: - Backend programming using Python - Frontend programming implemented with JavaScript and HTML Key Functionalities: - Database Integration: The software developer should be able to create a seamless link to an existing database and enable secure data exchanges. there is already excel .xlsx file in the folder - API Integration: The project includes integration of specific APIs to provide essential functionality for the Web Application. Purpose of the Project: - The main goal for this project is to develop a functional web application and host it either on a server or GitHub. The application isn’t static and employs IT-technical features. Idea...
I'm seeking a seasoned developer experienced in implementing AI chatbot functionalities for my project. I want to design a chatbot-based resume builder, and here's what I need: - Ability to create personalized, professional templates. This is integral - each resume it creates should have its unique touch but maintain a professional stance fitting for the IT industry. - The chatbot should have a comprehensive understanding of the technology field. It needs to provide users with suitable skills and experience suggestions fitting for various roles in the IT sector. - Prior proven experience in building similar chatbots is appreciated. A robust portfolio in the same line of work will be an added advantage. By landing a hand in this project, you�...
I have the attached images , I need it to be in excel form.
I need a correctly working sample code in Python showing how to use the Freelancer API to list all my projects and bidders. Requirements: - Expertise in Python programming. - Strong knowledge of working with APIs, especially the Freelancer API. - Ability to write clean, efficient, and well-documented code. There is documentation here:
I'm trying to write a simple Hello World to list the contents of an AWS S3 bucket, using the Nim programming language () and the disruptek/atoz library. To reproduce the issue, please install Nim on your machine, then execute `nimble init` to create a project and then run `nimble install -y `. I have attached a Dockerfile, for developers who prefer to use Docker. If you don't like Docker, please ignore the Dockerfile. The `docker build` will produce the exact same error I got on my machine: I am getting this Error: Cannot satisfy the dependency on npeg 0.27.0 and npeg 1.2.2 Your job is to reproduce this error and then modify the code to fix the error. This is apparently a problem with the atoz library itself, so you may have to fork
