Macro filling spreadsheetpráce
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
I'm in search of an experienced data entry specialist to assist in filling out more than 200 online forms. Key Responsibilities: - Filling out online forms with accuracy and efficiency. - Ensuring that all fields are correctly and completely filled out. Ideal Skills: - Proficiency in data entry and online form filling. - Attention to detail to ensure accuracy. - Excellent time management skills to handle a large volume of forms. - Experience in completing similar tasks will be a plus. Looking for someone who can deliver quality work within an agreed timeline. Please provide any relevant experience or examples of similar projects you have completed.
I'm searching for a skilled Virtual Assistant (VA) to manage a small inventory of less than 100 entries. Your responsibilities will include: - Data entry: Accurately inputting necessary information into our system. - Spreadsheet management: Expertly organizing and managing our inventory data in Excel. - Reporting: Creating clear, concise, and actionable reports based on the inventory data. To execute these tasks proficiently, you should be well-versed in the SUMIF and Pivot Tables functions in Excel. Prior experience in managing small to medium-sized inventories will prove beneficial. Your ability to pay attention to detail, demonstrate excellent problem-solving skills, and deliver results in a timely manner will be important for success in this role.
I'm looking for a skilled individual to develop a custom Google script spreadsheet to cater for my company's specific needs in the area of sure betting/matched betting and accounting functionality. This project is of high significance and is strictly for in-house usage. Ideal Spreadsheet Functions: - Sure betting/matched betting analysis: Essential for calculating sure bets and providing comprehensive insights. - Accounting functions: Streamlined tracking of profits, bets, balances and expenses. - Identity management: Essential for identifying our partners, keeping track of their ownership share based on gain, withdrawals, and deposits to the company. - Sequential betting tracking: We would need this for a detailed record of sequential bets. We can explain further...
I'm in need of a proficient data entry specialist to assist with a substantial volume of data entry work. This is a very basic task, a lead scraping website doesn't allow me to export data. So we will copy and paste from one website to a google sheet. There are 2,241 entries needed This project will take ~20 hours I am attaching a screenshot of the picture of the website and of the spreadsheet
Hello I need an experienced programmer willing to take a project that requires attention to detail and precise understanding of the subject matter. I can give extensive details about the ideal functioning of the spreadsheet I need done, however, this is an overwview: Track all gross/net profits track all account balances track all bank balances track all ongoing and completed bets on each account track across futile types of bet single and sequenced (this will require custom logic) as well as more basic things. im looking of a single place for everything to happen and for the right person to create it. No work will need to be done with external API this is only an internal management and accounting system.
...experienced Python programmer to design a program that analyzes the data from 7-8 spreadsheets and generates a discrepancy report. The project will require: - Strong proficiency in Python - Expertise in data visualization - Ability to compare categories within a large dataset - Comprehension of CSV format Specifically, the core functions of this Python program should include: - Analyzing spreadsheet data - Comparing various categories - Visualizing these comparisons to spot discrepancies - Exporting the results in CSV file format Ideal candidates should have extensive programming experience, particularly in the field of data analysis, and be able to demonstrate a solid understanding of data visualization techniques. They should also be familiar with handling large datas...
I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a...ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue" on th...
I need a meticulous data entry professional to help me convert printed documents into a digital spreadsheet with the utmost accuracy. Key responsibilities include: - Typing data from printed documents into a spreadsheet - Ensuring that the data is entered with a very high level of accuracy. To be a successful candidate for this project, you should have experience in high-accuracy data entry. Previous work in a legal or scientific setting would be highly preferred. You should be detail-oriented and skilled in data entry. Your goal will be to ensure that the information is accurately transcribed and organized into the digital format. If you're confident in your skills and can guarantee a very high level of accuracy, I'd like to hear from you.
Necesito combinar un archivo excel que lo extraigo de un programa extranjero (1r archivo), y que debe añadir de otro archivo (plantilla proveedores) un dato para obtener una excel final (plantilla). El programa debe permitir insertar el archivo inicial, que consulte otro excel para añadir su CIF (el software es extranjero i no lo incluye) i transformarlo en el final (plantilla). Lo suyo sería, inserte archivo inicial, para extraer el archivo final
I need a dedicated professional to assist with a crucial data entry project. The work involves: - Encoding textual data sourced from digital documents. - Delivering accurately encoded data into an Excel spreadsheet. This task requires keen attention to detail to ensure the absolute accuracy of the data entry. The ideal candidate must have extensive experience handling textual data and an aptitude for meticulous data entry work. Proficiency in Excel and working with digital documents is also vital.
Need a proficient individual who can efficiently handle online form filling tasks. Ideally, you should have: - Strong attention to detail - Proficiency in using internet platforms - Experience with simple data input forms Although the forms involved do not call for complex entries and are fairly straightforward, it's crucial that the information is precise and accurate, as these will serve as foundation for undetermined purposes. The ability to adhere to instructions and meet deadlines will highly be appreciated.
I need assistance transferring my handwritten notes into a digital spreadsheet. Ideal skills and experience include: - Proficiency in data entry - Ability to decipher handwritten text - Expertise in spreadsheet software, such as Excel or Google Sheets
...for a professional who can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming - Strong background in data analysis and visualization - Exper...
I'm seeking a Python developer who's proficient in web scraping to help me extract data from social media platforms. Key Responsibilities: - Develo...extract data from social media platforms. Key Responsibilities: - Develop and implement a Python script for web scraping data from social media channels. Deliverable: - The scraped data should be compiled and delivered in an Excel spreadsheet for further analysis. Ideal Candidate: - Proficient in Python with a strong background in web scraping techniques. - Prior experience in scraping data from social media platforms will be a big plus. - Ability to deliver the end results in an organized, neat and easily accessible format, such as an Excel spreadsheet. Please reach out if you think you're the right f...
I'm in need of a comprehensive contact list for Queensland-based mine sites. I'd like the list to include: - Company name and contact details - Mine site location and address - Contact person and title I'm looking for a high volume of entries, so ideally more than 50 mine sites should be included. The final deliverable should be an Excel spreadsheet. Ideal freelancers for this project should be experienced in data mining and collection. You should be thorough and detail-oriented to ensure all information is accurate. Knowledge of Queensland's mining industry would be a plus.
I'm looking for an experienced Excel professional to help me set up a SUMIFS formula in an Excel spreadsheet with the following requirements: - The SUMIFS function needs to work with numeric matching criteria. - The source for the data is an Excel spreadsheet. - The most crucial aspect for this project is that the SUMIFS formula needs to be dynamic. It should update automatically as new data is added to the spreadsheet. Ideally, you should have: - Proven experience working with Excel SUMIFS functions, especially with numeric matching criteria. - The ability to create dynamic formulas that update with changes in the source data. - Strong attention to detail to ensure the formula is implemented correctly and efficiently. If you're confident in your Excel ski...
I need a professional data entry specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. ...
I need a professional data entry specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. ...
...help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be delivered in the next 2 days. If you have prior experience in creat...
I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of columns for answers ...
Project Description: We are seeking an experienced Microsoft Word specialist to create a one-page template designed for low-vision clien...Integrate fillable fields where information can be entered by the user. Users should be able to navigate through fields using the keyboard TAB key. Accessibility: Ensure the template is fully accessible to screen readers by adding appropriate titles and tags. Use Word’s Accessibility Checker to ensure compliance and address any issues. Document Protection: Restrict editing to allow only form filling in the designated fields. Deliverables: The final product should be delivered as a Word Template (.dotx). Additional Notes: Experience with creating accessible documents is highly preferred. Please provide examples of similar projects you h...
We are academic researchers interested studying visit patterns to Museums, Aquariums, and Zoos, in the United States. We are seeking assistance in collecting reported visit counts for the year 2019 from 500 museums, 100 zoos, and 100 aquariums across the United States. We will send you an excel spreadsheet with the name and state of each location we would like visits counts for. Note that these ~700 locations have been pre-selected. Task: - Search the internet for reported visits to each location in 2019 - If you can find the number of visits, please enter that number in the "visits" column AND paste the link to the website / source from which you obtained that number in the "link" column - If you cannot find an official reported figure for 2019 after som...
I am in need of a freelancer who can swiftly handle two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share with you upon commencement of the project. 2. Car Make & Model List: - The second spreadsheet requires the creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able to undertake ...
I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.
...Email, using Pulover Macro and AHK where needed. Requirements include: - Automating a series of tasks in Microsoft Excel. This includes data manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and independent management. Ideal skills and experience for this role would include: - Advanced and proven experience in Pulover ...
...can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all the data is entered correctly. Ideally, the fr...
I'm looking for freelance recruiters who have a deep understanding of the marketing industry. The ideal freelancers should be able to source, screen, and recommend entry-level marketing candidates. Key requirements:...understanding of the marketing industry. The ideal freelancers should be able to source, screen, and recommend entry-level marketing candidates. Key requirements: - Strong communication and interpersonal skills. - Understanding of sales and marketing universe. - Ability to attach candidates to different programs - Proficiency in using various recruitment tools and platforms. The positions you will be filling are temporary, and the main goal is to identify and onboard promising entry-level marketing candidates. If you have prior experience in a similar role, p...
...savvy professional who appreciates the finer details of Major League Baseball (MLB). You'll be tasked with compiling a comprehensive spreadsheet featuring specific MLB data. Essential parts of this data include game statistics, player performance, and team standings. The spreadsheet should be organized in a user-friendly way as mentioned below: 1. Date Range: The spreadsheet must cover a specified date range, which I'll provide upon hiring. 2. Included Players/Teams: The spreadsheet should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on wh...
I am seeking a detail-oriented freelancer with demonstrable experience in data collection to gather texts, images, numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in pr...numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in precisely what data I need to be gathered. The freelancer will be expected to: * Carefully collect the specified data from the website * Ensure all text, images, numbers, and table-based data are meticulously compiled * Consolidate all the collected data into a neat Excel spreadsheet Your experience in data collection should be highlighted in your application. Experience in using Excel for data organization will be a key ...
I am looking for a person who can help me in applying jobs online, specifically on LinkedIn and other online platforms. If you have some understanding in online job application processes and can help with applying jobs based on resume/profile. I will provide the resume and logins for the profile.
I'm looking for someone with Google App Script expertise to help me automate tasks ...Generating Reports from Google Sheets Data: - The script should be able to pull specific data from my Google Sheets and generate reports automatically. 2. Sending Automated Emails based on Conditions: - I need the script to send out emails based on specific conditions. For example, if a certain cell in a Google Sheet reaches a certain value, an email should be triggered. 3. Updating Spreadsheet Data based on Email Responses: - The script should be able to read emails and update the corresponding Google Sheet based on the content of the email. Please provide examples of similar projects you have worked on in the past. I'd love to see how you've approached similar automatio...
I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclu...the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening...
I'm looking for someone with proficient data entry skills and bonus if they have unique formatting capabilities. The task concerns entering text data into a spreadsheet software. Although I don't have a specific format or template, creativity and organization are welcome. Key skills include: - Data entry - Familiarity with spreadsheet software - Excellent attention to detail - Ability to select a clear, logical format While previous experience in data entry is preferred, it's not essential as long as you're ready to take on this task with maximum precision. If you believe you're the right fit, I'd love to hear your approach on how you would tackle this particular project. Let's create a well-structured data paradigm together.
Social Studio Analytics is implementing a digital transformation project for a legal aid charity based in Jerusalem and is seeking an ERPNext/Frappe developer to help fulfill a core project milestone. The ERPNext/Frappe developer is expected to develop a dynamic form-filling applications platform that is dynamic and versatile since the Society offers around 11 different applications with different requirements and specifications. For the users, the application process (filling in the information) should be as easy as can be, and for the Society, the applicants’ input should be neatly filled out in legal documents and applications that have a pre-defined format. _ _ _ _ _ _ The detailed job description is included in the following Google Drive link:
I am looking for a data scraper to extract information from the JazzCash agent locator list available on their website (). Key Requirements: - I need the data to be delivered in an Excel spreadsheet format. - The specific details that I require for each Jazz locator are the Name and Address, along with the Services offered. - The scraping needs to be done only once; it will not be recurring. Ideal Skills and Experience: - Proficiency in web scraping, particularly using tools like Python's Beautiful Soup or Scrapy. - Experience in extracting data from websites with dynamic content. - Strong attention to detail to ensure accurate data extraction. - Previous experience with similar data scraping projects will be an advantage. I am particularly interested
I'm in need of a comprehensive business owner database specifically in Tamilnadu, Chennai. The database should include detailed information of business owners Contact number, Email ID from various industries like GST Filling Database, Distributors, Industries, Dealership and more
I'm in need of a macro for MS Word that can automate repetitive tasks. - The ideal trigger for this macro would be a custom button integrated into the ribbon. - The macro should be designed to work solely within Word - The key goal is to automating tasks that I frequently perform. I'm looking for a professional who's experienced in creating MS Word macros. The ability to understand the nuances of my workflow and translate that into an efficient and reliable macro is crucial.
I require a professional data scraper to scrape multiple websites. Key tasks include: - No limitation on type of data scraped as this was not specified. - Scraping must be done across multiple websites, specifics will be provided upon project commencement. - All data should be delivered in Excel spreadsheet format. Ideal skills and experience: - Prior experience in web scraping across multiple diverse websites. - Proficient in using different scraping tools. - Strong understanding of Excel and data parsing. - Attention to detail and commitment to high quality, error-free work.
As a real estate investor based in the USA, I'm in search of an intermediate-level cold caller who can help expand my business operations. I need someone to contact 103 given individuals, secure their interest about selling their homes, and update the same in an Excel spreadsheet. Key Requirements: - Prior experience in real estate cold calling - Skilled at telephone communication - High attention to detail for note-taking during calls - Ability to ignite interest in property owners about selling The focus during each call should primarily revolve around gauging the property owner's interest in selling their home. Information about the property or pricing doesn't need to be discussed. I expect the freelancer to adapt to the flow of the conversation, as I do not have...
I am in need of an administrative assistant who can help with data entry tasks, particularly in managing spreadsheets. The ideal candidate should: - Have experience in data entry, specifically managing spreadsheets. - Be able to update and manage data efficiently and accurately. - Assist in additional admin tasks as needed.
...proficient in creating dynamic and functional spreadsheets. This project involves designing a new Excel sheet that handles both numerical and text data. You would need to: - Set up the sheet, capable of performing multiple features such as automated calculations and conditional formatting rules. - Configure simple calculations for GP indicators basing on specific cost prices. - Ensure the spreadsheet can efficiently process a mix of numeric and text data. Strong skills in Excel and data management are essential for this project. Familiarity with advanced Excel functions and an ability to provide quick, efficient solutions to data processing problems would also be very beneficial. A good understanding of GP indicators and cost price calculations is a plus. I am looking for a de...
I'm seeking a professional with a strong background in Excel to develop a keyword search tool for an Excel database. This tool will primarily be used for filtering data and linking to articles hosted on a network. Key Requirements: - E...able to create new searchable keywords on the database page and have them populate and be searchable on the main page. I would like to be able to enter multiple search terms into the search box to narrow the results. Project extension - If it's possible, I would also like to create a search box on the main page that searches the articles but this is not essential. I have attached an excel spreadsheet as a layout reference and the video at the following address is similar to what I want this database to achieve.
I'm in need of a skilled proofreader who is familiar with APA citation style to review and edit my 1200-word essay on the 2005 Avatar: The Last Airbender series. The task involves fixing grammatical errors, ensuring coherence, and most importantly, filling in the blank spaces with proper APA style citations. A deep understanding of the show would be an added advantage. Or Writing a 1600-1800 word argumentative essay on either student loan debt and cost of education or low minimum wage. You may pick which topic and must be written with 4-5 sources 2 of which I will provide as it must come from my schools online library and cited in APA format. Key Requirements: - Proofreading skills - Proficiency in APA citation style
I need this to be done IMMEDIATELY! - Extract data in a specified format. - Transfer data from the price listing PDF to an Excel spreadsheet. - Input details such as SKU, Name, Description, Brand, Cost Price, Length, Width, Height, and Weight, which are highlighted in blue. - If any title or heading is not mentioned in the details provided in item #3, add it to columns U-Z. - Ensure all data is formatted correctly, with names in proper case and prices as numerical values. I'm in need of a proficient data entry freelancer to help convert a scanned image PDF to an Excel spreadsheet. Key Details: - The PDF contains less than 50 pages. - The data in the PDF is in the form of scanned images, making it crucial that the freelancer has experience in handling this ...
We are looking for ideas on how to have a small flat plastic container (approx 85mm x 55 mm x 4mm) fold in half to dispense fluid from a dropper nozzle (at the seam) that gets exposed when container is folded in half. The challenge, and specifically what w...drop of fluid from the now exposed nozzle. Ideally the hinge would allow fluid to pass while still keeping the internal volume constant until fully folded to squeeze out drop. (we don't want to suck in air or squeeze out fluid during the opening process). We are looking at using Low Density Polyethylene (LDPE) plastic for the bottle perhaps varying the thickness in parts to achieve result. For filling could be anywhere for now, as we could weld the seam. The idea would be to produce via Blow Fill Seal (BFS) if this helps g...
I am seeking a detail-oriented freelancer with demonstrable experience in data collection to gather texts, images, numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in pr...numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in precisely what data I need to be gathered. The freelancer will be expected to: * Carefully collect the specified data from the website * Ensure all text, images, numbers, and table-based data are meticulously compiled * Consolidate all the collected data into a neat Excel spreadsheet Your experience in data collection should be highlighted in your application. Experience in using Excel for data organization will be a key ...
I'm in need of a freelancer who can automate my Excel spreadsheet to increase efficiency and accuracy in data entry and analysis. Key Duties: - Automate data input, validation, and manipulation - Perform calculations and formulas automatically - Generate reports and summaries for the data Ideal Skills: - Proficiency in Excel - Excel input form design - Previous experience in automating data entry processes - Understanding of data manipulation
I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Googl...my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'...
