Excel macro data extractPekerjaan
Buenas tardes tengo un Excel de facturación y cobranza , incluye devoluciones y transferencias de productos . Deseo que se traslade tal cual como funciona a un sitio web con usuarios , permisos
I am urgently looking for an experienced Python expert with exceptional web scraping skills to extract text content from various sites. Your proficiency in data extraction and handling is paramount for this project. Specifics of the types of websites to be targeted will be discussed later. Ideally, you should have: 1. Proven experience in Python based web scraping. 2. Strong understanding of different types of websites and their structures. 3. Availability to start and complete the job ASAP. Please ensure your bid reflects your strong standing experience and your immediate availability to commence the task. Expect more details upon assignment. Let's get started!
I'm seeking a proficient Zapier expert who can develop a Zap that automates several tasks when a new PDF is added to my Google Drive folder. Key Requirements: - Flatten the PDF: The Zap should flatten the new PDF file upon detection. - Extract Each Page as .tiff File: After flattening, the PDF pages need to be extracted individually as .tiff files. - Email Notification: Notify me via email once the process is complete. It's essential that the successful candidate is well-versed in Zapier and PDF handling. Familiarity with API would be an added advantage, although not necessary as I do have an API key if it's needed. Your role will be pivotal in streamlining my workflow and ensuring efficient management of PDF files. If you possess the requisite skills and can deli...
...leverage AI to organize and extract personal information. The platform should be user-friendly and compatible with web browsers and mobile devices. Key Features: - Personal Information Organization: The platform should be able to organize personal information in a coherent and easily accessible manner. - AI Integration: The software should leverage AI to efficiently process and categorize the data. - FB and LI Profile Extraction: With the user's permissions, the platform should have the ability to extract relevant data from their Facebook and LinkedIn profiles. User Interface Customization: - I'm looking for a platform with user-friendly pre-designed templates. The level of customization should be sufficient for users to feel in control o...
I need help browsing the web for text data and organizing it in Excel. - The text data is to be organized in Excel by name and other relevant information. - No specific Excel functions or formulas need to be used, you will simply need to look at the page and type the information into the spreadsheet. Ideal skills: - Proficiency in web browsing - Be very quick - Strong attention to detail - Familiarity with Excel - Time management skills The task is straightforward, but attention to detail, accuracy, and the ability to work efficiently are crucial. Please submit your daily rate.
I'm seeking an individual with a good command of English, as well as a basic understanding of social media and the ability to use Google Drive Sheets and Docs. Familiarity with chat GPT (AI) is a must. - Conduct online research on Facebook and Google - Locate specific products and offers - Gather and summarize overall reviews - Compile ...and Docs. Familiarity with chat GPT (AI) is a must. - Conduct online research on Facebook and Google - Locate specific products and offers - Gather and summarize overall reviews - Compile and deliver the summaries in Google Sheets Ideal candidates should be detail-oriented, able to work independently, and have excellent communication skills in English. A demonstrated ability to work with data and extract relevant information from rev...
...am looking for an Excel expert who can help me create a dynamic and visually appealing Trend chart that can effectively communicate data composition over time. Key Requirements: - The chart must be able to clearly represent data changes over a period of time, showcasing the shifting proportions of different components. - The data for the chart will be provided in an Excel file. The freelancer will need to effectively structure this data to make it compatible for chart creation. - The chart should be designed with the latest Excel standards to ensure compatibility and ease of use. Ideal Candidate: - Strong proficiency in Excel, with a focus on chart creation. - Experience in creating dynamic and interactive charts in Excel...
...a financial analysis project through Microsoft Excel and require assistance with data structuring specifically for pivot tables. I aim to feed this data into a comprehensive dashboard. The Excel spreadsheet encompasses multiple periods of financial data. Key Aspects: - Data included in the pivot tables are dates of financial periods, types of financial information, and identifiers such as multiple General Ledger accounts, categories and subcategories. - The task involves transforming this spreadsheet data into an appropriate format suitable for creating a pivot table and consequent dashboard. Skills and Experience: - Proficiency in Microsoft Excel, particularly in the handling of complex data and pivot tables. - Experien...
I need help with Excel It is advance level so please be careful when you apply. Thanks.
Cuento con datos operacionales en Excel de mi trabajo, y necesito transformar esa data a dashboards y procesar data en un ambiente web. I have operational data in Excel from my work, and I need to transform that data into dashboards and process data in a web environment.
Extract the industry data from the IBIS reports and populate the Excel template
I need an Excel sheet that will empower me to manage my call center effectively by providing me with real-time insights into the number of agents needed per hour. Key Requirements: - The sheet should offer a graphical representation of the data, enabling me to quickly understand the changes in agent demand. - It must calculate and display the total call duration per agent,hourly agent demand, and the average wait time for callers. Data should be updated on a daily basis to ensure the most current and accurate information is available. Ideal Skills: - Proficiency in Excel and ability to create dynamic tables and graphs. - Experience in designing forecasting models would be a plus. - Strong understanding of call center operations and key metrics. The ide...
I have a Power BI file that is insanely slow and unusable. It has some glitch that has drastically slowed it down and cannot be resoled. So I need this file to be recreated in a superfast and fully efficient Excel by using formulas and VBA codes. More details to be share with winner.
I need a skilled Excel specialist to handle the automation of tasks in my daily-updated Excel file. Key Responsibilities: - Develop basic macros to automate tasks: I need macros to simplify and speed up the daily operations in the Excel file. Ideal Skills and Experience: - Proficiency in Excel: You should be very familiar with Excel tools and functions, especially in the area of macro creation. - Experience in automation: Previous experience in automating tasks in Excel, especially on a daily basis, would be highly beneficial. - Detail-oriented: The tasks are basic but they need to be carried out consistently and accurately on a daily basis. - Time management: You should be able to create a system that keeps up with the daily updates. ...
I am looking for a meticulous freelancer who can extract both textual and numeric data from PDFs and images sourced online. Skills and Experience required: - Proficiency in performing web research - Acute attention to detail for accurate data extraction - Experience in handling both textual and numeric data - Expertise in data entry from PDFs or images Responsibilities: - Scout for relevant online sources - Extract and organize textual and numeric data from selected PDFs and images. This task requires precision, as the information needs to be accurate without room for error. If you have the necessary skills and experience, I'd love to hear from you.
...and my sample resume and you have to tailor it according to the role. It should be ATS-friendly and should have a score of a minimum of 85 % in resume worded. I have ready chatbot prompt to make your task easier so that each application resume will take less than 10 minutes. I just need the resume and its score's screenshot, I will add the job link in an Excel sheet so that it is organized properly. You will add resume's link in the same excel sheet, you could upload resume in folders on google drive. Is this task doable for you? Below is a sample job description -: "Position: Site Reliability/Observability Engineer (SREs). Location: Johnston, RI or Phoenix, AZ (4 - 5 days onsite). Duration: FTE Objectives of this role: Run the production environment ...
...to help with my Excel automation tasks and creating a set of macros. Key Requirements: Need to extract data from pdf in a way which I want - The primary task involves the automation of Excel processes. - The developer is expected to create macros that will streamline and simplify certain operations within the Excel sheets. - The primary automation requirement is extracting data from different types of PDF documents. Further Details: - The VBA developer should be able to extract data from text-based PDFs, scanned PDFs, and password-protected PDFs. - The extracted data needs to be accurately transferred to Excel. Ideal Skills: - Proficient in VBA and Excel; - Experience with data extraction from diffe...
I'm in need of a freelancer who is proficient in Tally ERP9, particularly the Silver Edition and Excel. The task involves specifically handling bank transactions. Key Responsibilities: - Transcribing bank transactions into Tally ERP9 Silver Edition - Organizing and managing the data accurately in Excel - Ensuring all data is updated in a timely and accurate manner Ideal Freelancer: - Proficient in Tally ERP9 Silver Edition - Strong experience in data entry - Skilled in Excel, particularly in data organization - Detail-oriented and accurate in data management Communication: I prefer updates and feedback to be sent via email. Clear communication and prompt responses are highly valuable to me.
We are a Premier Online Coaching Platform, evidence-driven, thriving to build an unbreakable mindset. This is also India's first website that calculates the exact number of calories with detailed macro nutrient distribution for a particular person based on their bio feedback. The website is absolute new, and nothing has been done yet apart from creating the entire thing as of now. There are a few tweaks and updates along with SEO that I need on the website to make it more human, interactive, responsive, fast & user friendly both in terms of desktop and mobile. These are the detailed requirements as of now: 1. Forms, Thank You pages upon submitting forms, making purchases and email responses. 2. Replace contact button from the home page and menu with a simple white band
As a WordPress expert with a deep understanding in PHP and AI programming, I'm looking to give my website a much-needed overhaul. What's urgently needed are: - An enhanced user interface to improve the overall aesthetics and user experience....times - A user feedback analysis mechanism to address customer grievances - Food image recognition to classify food items accurately - Recipe Generation for unique cooking ideas - Predictive inventory management to avoid food wastage - Nutritional analysis for healthier meal choices - Personalized recommendations to provide a unique user experience. Freelancers bidding on this project should excel in WordPress, PHP development and AI programming, with a proven portfolio in building complex websites with excellent UX and int...
...developer who can handle automation tasks related to ETL pipeline, data extraction from Snowflake, and a dbt environment. Key Requirements: - You should be proficient in Python programming. - Be familiar with the Window Task Scheduler. - Have experience with ETL pipeline development. - Know how to extract data from Snowflake and a dbt environment. The Purpose: - The ETL pipeline is crucial for handling data analysis, reporting, and data integration tasks. - The data size to be processed in the ETL pipeline is medium, up to 10 GB. Ideal Candidate: - You should have prior experience in handling similar tasks. - A strong understanding of data handling and automation through Python and ETL tools. - Proven expertise in data extract...
I'm seeking a skilled Kotlin developer to extract text content, images etc from a website. Details will be provided upon selection.
I'm in need of a freelancer who is proficient in Tally ERP9, particularly the Silver Edition and Excel. The task involves specifically handling bank transactions. Key Responsibilities: - Transcribing bank transactions into Tally ERP9 Silver Edition - Organizing and managing the data accurately in Excel - Ensuring all data is updated in a timely and accurate manner Ideal Freelancer: - Proficient in Tally ERP9 Silver Edition - Strong experience in data entry - Skilled in Excel, particularly in data organization - Detail-oriented and accurate in data management Communication: I prefer updates and feedback to be sent via email. Clear communication and prompt responses are highly valuable to me.
Presupuesto 9 dólares Realizar una hoja de calculo que me arroje el puntaje y la posicion de una oferta respecto a las otras deacuerdo a unas formulas que asignan puntaje deacuerdo al valor que oferten
I'm seeking expert support in the field of AI to guide me through CONSULTANCY focusing on the content processing of business & marketing materials. Key Responsibilities: - Provide Consultancy on use of such AI content comprehension tool, which extract useful & relevant information with AI content creation/elaboration according to questions asked, based on existing text content in English & Chinese primarily, - Provide guidance & sample demonstration on the execution process (could be access to subscribed account of some AI tool if needed, but the tool itself must be codeless and ready to use) Specifics: - Primarily working with Business & Marketing materials - The target audience for these materials is B2B. Ideal Candidate: - Proven experience in AI con...
I'm in need of a comprehensive Excel workshop system that can handle all the necessary features, including open job cards, inventory templates, dashboards, bills, estimations, and work orders. Here's what I'm looking for: - **Open Job Cards:** The system should be equipped with a section for open job cards where I can easily manage and keep track of ongoing tasks. - **Inventory Management:** I prefer a manual entry for inventory items. The system should facilitate the creation and maintenance of inventory templates in an easy and efficient manner. - **Dashboards:** The dashboards should be highly customizable and provide me with a detailed overview of all the key metrics that I need to monitor regularly. The level of customization should be advanced, allowing me ...
I need a capable hand to create an AI tool for an Android game that's similar to Subway Surfers. This tool should be built to perform at an intermediate level, hence, it shouldn't struggle with achieving basic tasks but doesn't have to excel at the hardest ones. The ideal freelancer for this job should have experience a deep understanding of artificial intelligence. Key Requirements: - AI Character Movement: The tool must automate the character's movements throughout the game. - Collecting Power-Ups: The AI tool should be clever enough to identify and collect power-ups. - Dodging Obstacles: It is essential that the tool ensures the character constantly avoids obstacles to prolong gameplay. Please note, it's crucial that the tool works seamlessly on Andr...
financial modeling of a project real estate with excel
Tenho em base de dados a localização de imóveis (POLYGON) - com vários pontos de coordenadas. Pretendo efetuar zonamentos e associar um valor para a localização destes imóveis que tenho em base de dados para posteriormente trabalhar números em folha de excel.
I have a PDF file with text & tabular data (unstructured) inside it. We need to extract it and save it in csv
I'm looking for an expert in data scraping to effectively extract text data from online databases. Primarily, I am interested in customer details. This data will be pivotal to my operations. Key tasks include but are not limited to: - Extracting textual data from specified online databases - Focusing on customer details during extraction - Organizing the extracted data in an easily accessible format The ideal candidate is proficient in data scraping and has a deep understanding of online databases. Proficiency in using tools and scripts for scraping is necessary. Previous experience with customer data extraction will be a plus. A rigid approach to data privacy and ethical scraping standards is imperative. Accuracy, effi...
I require a skilled native Japanese transcriber to convert my audio recordings to text format. The nature of these audio files primarily involves conversations, and the sound quality is high with minimal background noise. To excel in this task, you should: - Have proficiency in Japanese language and transcription techniques. - Be capable of identifying different speakers during the conversations. - Ensure all transcriptions are returned with excellent grammar and spelling. Preferably, you'll have experience with transcription software and can provide evidence of your skills and experience in such projects. Your attention to detail and commitment to the agreed timelines will be paramount in this engagement.
Confectionner unemodélisation financière d'un projet immobilier sur excel
...is to extract specific job-related data from websites based on input parameters such as job title and location. Key Responsibilities: Review and refine existing Python code for web crawling to ensure robust and efficient data extraction. Develop and implement a user-friendly GUI that allows users to input search criteria easily. Ensure the application can parse and extract data accurately from various webpage structures. Output the extracted data into a structured spreadsheet format. Test the application to ensure its reliability and accuracy under different use cases. Requirements: Strong experience in Python and familiar with libraries like BeautifulSoup, Scrapy, or similar for web scraping. Proficiency in GUI frameworks such as Tkinter, Py...
I'm looking for a skilled German translator to translate a large volume of content from English to German. The content is related to accounting and POS software. The source material is in Excel format and contains over 10,000 words. Ideal Skills and Expertise: - Fluent in both English and German - Proven experience in translation, particularly related to technical or software content - Proficient in working with Excel files Please note that the translation must be accurate and precise to ensure that the technical terms are properly translated. Your familiarity with accounting and POS software terminology is highly desirable. The software is up to 90% translated, we need translator for correction and addition.
...following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highlight that G) If the MSRP is appearing for variation, then it should fetch and enter that number. It is very easy and simple work. Bid only if you can do within next 24 hours. See the attached excel...
...to develop a comprehensive sales dashboard on Excel. The purpose of this project is to streamline our sales data for easy comparison and analysis on a daily, monthly, and quarterly basis. Key Features Required: - The ability to compare daily sales with last day's and last year's sales. - Monitor monthly actual vs budget vs last year. - Track quarterly sales performance. - Special attention should be given to the revenue growth metric. Ideal Experience and Skills: - Excel mastery - Proven experience in creating interactive dashboards - Knowledge in sales data analysis - Ability to create a user-friendly interface where data can be manually input efficiently and effectively Your role will heavily involve the organization of complex sales ...
I need an innovative Android app developer who will create an app to extract interaction chains from another app. This is for research purposes. The main focus is to analyze the types of interactions within the targeted app. Specifically, the app should record detailed chains of user interaction. Ideal skills for this job would include extensive experience in Android app development, a deep understanding of data extraction methods, as well as a good grasp of user behavior analysis. In addition to these skills, experience in data driven research would be highly advantageous. Your role will not be limited to just creating an app, but to bring a research tool to life. This project is more than creating an app; it's an exploration into understanding users better.
I'm in need of a skilled branding professional ...versions can be used. - Typography Guidelines: Detailed information about the fonts and typography style that should be used in all our communications. - Merch Guides: Design suggestions and guidelines for any promotional or merchandise items that we may produce. - Store Design: Guidance on the color scheme, logo placement, and overall aesthetic that should be maintained in our physical store. To excel in this project, you should have a proven track record of creating brand guidelines. Proficiency in graphic design, branding, and an understanding of the pet grooming industry would be advantageous. Your work should be detailed, professional, and easy to understand. A great attention to detail and a strong sense of creativity are...
...skilled professional who can set up an Azure data storage account to store Excel data, particularly with the following key features in mind: - **Data Type and Source**: The data I'm working with is primarily Excel based, so having experience with managing structured data storage in Azure is a must. - **Frequency of Updates**: The data will be updated on a weekly basis, so the storage solution needs to seamlessly accommodate this. - **Purpose of Storage**: The primary purpose of storing this data in Azure is for data analysis. While not the only use, ensuring that the storage solution allows for easy and efficient data analysis is crucial. The ideal candidate should have prior experience with Azure ...
...information into an Excel sheet. There would be a subsequent function for field extraction to compile a final report. - Desired Skills and Experience: • Proficiency in OCR technology for handwriting detection • Experience in custom software development • Excel programming expertise for auto-consolidation of data • Knowledge of report generation mechanisms within software Successful execution of this task would drastically streamline data processing in my start-up. To increase accuracy, the OCR program needs to be trainable, in order to recognize unique handwriting styles of different individuals. To provide you a sense of the variety, samples of these handwriting styles will be made available. I am seeking a freelancer who understan...
I am looking for an expert in web scraping who can efficiently extract business leads. While the primary purpose of the project was not specified, it is undeniable that these leads will play a pivotal role in marketing efforts, like sales lead generation, market research, and contact information collection. Although I did not mention a specific source site, note that the target is business owners, and their revenue and contact information. Therefore, having experience in scraping from professional networking and business directory websites such as LinkedIn or Yellow Pages would be welcomed. Lastly, the exact number of leads that I need hasn't been defined, so I am open to both small and large-scale operations. Ultimately, their quality is of more importance than mere numeric...
I have a simple flowchart in Excel that I need converted to DrawIO format. The purpose of this flowchart is for internal ISO 9001 documentation , so it needs to be clear, easy to understand, and look somewhat formal, so Font style and Color scheme should be appropriately chosen. I'm looking for a freelancer with experience in graphic design, particularly flowchart creation and DrawIO, who can give this flowchart a clean, professional look. The excell file will be provided to you, so you can copy/paste the text. I do not expect you to change the content. There might be additional flowcharts in the future, so potentially repeat business. When bidding, let me know whether or not you have experience with ISO documentation drafting, which might be a plus.
I'm requiring assistance with a meticulous task of transferring text data from a website. The data on the site is neatly arrayed in table format, and I need someone to manually sift through and copy the specific fields of 'Name', 'Date', and 'Description' into an Excel file. Ideal candidate would have: - Excellent attention to detail - Proven experience with manual data entry - Proficient in Excel - Understanding of structured web content This task requires patience, a keen eye for detail, and expertise in transforming web data into organized Excel entries. Interested freelancers need to commit to high levels of accuracy to ensure all data transferred is error-free.
I am looking for Excel experts who can assist me with creating formulas and functions within a week. I have wholesale mobile shop. I want excel works for example desboard in one sheets and custumer sheets which contain debit credit ,describtion and total amount one more important all costumer name on desboard and if debit or credit amount also show on desboard please also look for attect excel file
I require an expert in Excel financial calculations to design a spreadsheet to calculate commission on sales. The main purpose is to drive commission payments based on a tiered structure. It will be used to manage commission payments linked to sales figures above a specified target. Ideal Skills: - Extensive experience in Excel spreadsheet design, particularly with financial calculations - Experience in tiered commission structure calculations - Strong understanding of financial data management. Responsibilities: - Design and implement Excel spreadsheet for commission calculations - Ensure accuracy of calculations based on the tiered commission structure.
I want someone who can help me with figuring out how to extract which sim I received my sms on in kitkat flavour. I use dual sim, due to this I am facing problem figuring out which sim is receiving the sms. to summarize everything i want to differentiate sms received based on sim slot
Hi Ishaq. Can you have a look at this app for us. We want to convert it from a commend line batch file to a GUI app in Python. We had one of our team build the app in C# a few years ago, but he has left and we have the source code. The app will extract an image from an excel spread sheet based on the column ref and put the image into a nominated directory with the imaged named as per another column in the source excel spreadsheet. I can send yu a full demo of the app. regards Rob
...primary criterion, and collating the data of various companies into the excel spreadsheet I will provide. Key Tasks: - Browse the provided website and search explicitly based on geolocation. - The geolocations of interest are predetermined and are stated within my excel sheet. Data Collection: - Oddly, I do not require some common fields like company name, address, or phone number. - Ensure accuracy and completeness of data collated into the excel spreadsheet. Ideal Skills and Experience: - Proficiency in advanced web research and data entry. - Working knowledge of geolocation-based search - Attention to detail and a keen eye for accuracy Applications: - Please include details of your past work experience. Showcasing relevant proje...
I am in need of a skilled developer to integrate Adobe Sign into my website which is built with CSCart Multivendor. The primary objective is to pull specific elements from CSCart into a template PDF form for e-signatures. This form needs to be signed, then a read-only version made accessible to those parties. Requirements: - Utilize the CSCart Multivendor API to extract customer information. - Include fields such as Name, Email, Address, and Phone Number in the Customer Information section of the PDF. - Enable e-signatures via mouse-written, upload or typed signatures. - Embed this within into the website. - Acroform and signature pad Ideal Skills: - Proficiency in CSCart & Adobe Sign API. - Experienced in API integration - Clear communication