Getting data as400 using excel vbapráce

Hello. I need to extract the values from this website in a spreadsheet (CSV or XLSX) in an automated way and every 10 minutes: . Must be with a VBA Macro and no required nothing special, only plain text in rows and columns (see attached). You will notice that it corresponds to a website with information about sports betting. The fields to be extracted are ALL the ones you can see per game. For example: - Sport - Country - Championship - Date and time of the event - Equipment - Type of bet (Home/Away, Over/Under 2.5, Final result, etc.) - Etc. Also note that "surebets" with 2 and 3 results appear, depending on the nature of the bet. If you have any doubt, ask me. Look at next examples of 2 results, but 3 results is seemed, adding more columns at the

I'm seeking a freelancer proficient at data entry for impending tasks. The job involves entering both numerical and textual data. Details: - You will need to enter a mixture of numeric and textual data. - Accuracy is crucial to ensure the quality of data entry. - The finalized data should be provided in an Excel spreadsheet. Skills and Experience: - Proficient in data entry. - Strong attention to detail. - Experience using and formatting Excel spreadsheets.

I have two excel files. In the file, I want you to color code cells from B2:E2 to the end of the columns with text as either green, yellow, orange, red for how closely the text in one cell matches in another. Green - perfect or near perfect match Yellow - most of it is good Orange - less than 70% match Red - poor match or no match I roughly counted there are about 2000 cells.

I'm looking to hire someone proficient with Excel to reconstruct a spreadsheet using a template that I will provide. The new version should replicate the original as closely as possible, without any added functionalities. Key requirements: - The spreadsheet should have exactly the same type of data as the original one. - You will not need to incorporate functionalities such as formulas, calculations, data validation or conditional formatting as they were skipped in the requirements. I want to ensure that my project is in good hands, therefore, your experience is crucial to me. During your application, kindly detail relevant experiences you've had recreating or working with spreadsheet templates. Looking forward to finding a trustworthy and knowled...

I am seeking an Excel expert who can provide in-person training on ‘Budgeting and profit and loss projections’ for one person. I already has an intermediate understanding of Excel and we need further training on: - Basic Excel Functions: The trainer would be expected to reiterate on the basic functions to ensure a strong foundation for the subsequent practical sessions. - Creating Formulas: The ability to create and manage formulas is the next skill we wish to hone. This includes all the necessary functions to perform complex calculations for our projects. The spreadsheet has already been created, it needs to be corrected a little but can be explained further in the training session. This training should be tailored to suit individuals with intermediate ...

I urgently require a meticulous and professional proofreader, well-versed in Japanese, to refine four not-safe-for-work (NSFW) lan...not mandatory. Ideal Candidate: - Proven track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Japanese. You will be provided 6 landing pages that you will need to open with a browser language set to Japanese. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is highly val...

Hi there! I'm Sourabh Dhos a detail-oriented individual with a knack for data entry. I thrive in fast-paced environments where accuracy is key. Proficient in ( Excel,ms word,I ensure data integrity while meeting deadlines.

Microsoft Outlook Mac Version 16.78.3 2019 Personal Computer and email on - thank you for being here? 1 email is the problem Getting these SYNC ERRORS there is one email and "need to keep this one email" ERROR The total attachment size exceeds the limit. Try removing one or more attachments before saving or sending. Where is this trying to sync ? When going to Window/Sync Errors - it is seen that 6 of them come each day? How can I stop these as they get annoying? CAN WE SHARE SCREENS? NOT SURE HOW TO SOLVE THIS WITHOUT SHARING SCREENS? ANY CHANCE YOU CAN HELP ME PLEASE ? Thank you Kindly in Advance There is hope you can give your “best” price; unemployed, and have cancer with bills backing up, $10 possible? Please note $10 is the max total that ...

Looking for an individual to accurately transfer numerical information and tables from PDF to Excel. Previous experience in data entry will be advantageous. Ideal skills and qualifications: - Beginner level experience in data entry or similar roles - Proficient in Microsoft Excel - Excellent attention to detail - Ability to interpret and analyze data Example attached.

The aim is to build a comprehensive business plan for my IT Service, consulting tech...attract investment. To this end, I need a professional who can effectively portray my business and future prospects through this plan. Key Requirements: - Incorporation of financial projections for more than 5 years into an Excel sheet. - Strong understanding of the technology service industry. - Experience in developing business plans specifically for investment purposes. Skills and Experience: - Excellent financial modeling skills. - Profound knowledge of the technology industry. - Experience in preparing business plans for fundraising purposes. - Proficiency in Excel. By effectively portraying my business strategy and financial future, you'd provide the key tool I need to secu...

I am seeking a skilled R programmer to develop code to create interaction matrices. The code will need to read in data from 80+ Excel sheets, create interaction matrices, and link in ID numbers from a separate document. Ideal Skills: - Mastery of R programming - Experience with scientific research data - Strong skills in data analysis

...environments. We want to have a high available solution which is also fail tolerant to destination processing systems Strong expertise on Kafka and how to read data from one system, parse this data reliably with options to debug later and finally post data to the destination system What is not required: - HA solutions of kafka - high load - failsave Budget? will not be disclosed, place your best bid to get considered What is next? We will share you a NDA and afterwards a paid test task. Payment? - you estimate in a WBS (optimistic, expected, pessimistic, where optimistic < expected < pessimistic) after getting the task - we discuss about clearances and effort - we mutually agree to effort - we assign you the task after mutually ...

I'm searching for an individual specialized in data mining and web scraping who can help me extract specific product information from an e-commerce website. Key Responsibilities: - Locate and extract specified data from the selected e-commerce site - Ensure collected data is reliable and structured properly Ideal Candidate: - Has in-depth knowledge in Web Scraping and Data Mining - Is familiar and proficient with Excel as the required output format is an Excel file This project aims to support a larger market research initiative, thus accuracy and attention to detail is critical. Only professionals with proven experience in similar projects need apply.

I'm experiencing an issue with my pbix file. Despite the fact that my data is neatly structured on a single worksheet with multiple tables in Excel, it is not refreshing in the pbix file when expected. Given the nature of this problem, it's clear that an expertise in data management with Excel and Power BI is necessary for this project. Proficiency in troubleshooting Power BI related issues is also a must. The primary tasks will include: - Analyzing the pbix file and the associated Excel worksheet - Pinpointing the cause behind the failure to refresh data - Implementing a fix to ensure smooth data refresh in the future The preferred freelancer should be experienced with: - Power BI (especially .pbix files) - Excel dat...

Using a provided theme and WPBakrey, take the content, text, images, logo provided. Following the instructions provided in the document, put the content into the website making changes for colours as indicated.

I have a specific goal for this project, which involves web scraping and organizing data into a comprehensive Excel spreadsheet database of UK care homes. The work scope includes: - Extracting contact details (both phone numbers and emails) of each care home - Categorizing the extracted data based on care home location The ideal freelancer for this job should hold the following skills and experience: - Proficient in web scraping - Knowledge of categorizing or sorting data - Excel spreadsheet expertise Accuracy and attention to detail is crucial in this task. This project is suitable for individuals who have previously demonstrated efficiency and success in similar roles. Resource could be

...operations. Primarily, I need a skilled Python developer to integrate the Angel Smart API with Microsoft Excel. Areas of concern include: - Developing data retrieval and analysis functionality: This involves retrieving and analyzing stock prices. - Option chain data management: I am specifically looking for functionalities like real-time option chain data retrieval, historical option chain data retrieval, and sophisticated analysis and visualization of the gathered data. - Creating an automated reporting system: In order to keep track of market conditions, an automated system for generating reports is essential. The ideal candidate should be expert in Python, comfortable with Excel, and have experience working with Angel Smart API. A...

...professional in Excel to develop an automated dashboard for my business. The system will need to manage data entry, data analysis, and reporting - all automated. Key tasks will include: - Setting up a dashboard connected to Excel files with automation functionality. - Automating cleaning up and processing of data for analysis. - Developing reports with automatic generation feature. Regarding data visualization, the dashboard should be capable of generating pie charts, line graphs, and bar graphs as per the data analyzed. You should be proficient in Excel and familiar with data visualization techniques. Experience in automation and connecting Excel with other data sources will also be an advantage. I have att...

I'm seeking a proficient data specialist who can successfully convert a CSV file into an XLSX Excel format. This conversion needs to be done meticulously to ensure optimal usability for sharing data with others. Key responsibilities will include: - Converting a CSV file into an XLSX format - Checking data integrity post-conversion - Ensuring the final layout is easy to understand and use for sharing with others The ideal freelancer for this job has extensive experience with Microsoft Excel and, more specifically, with CSV to Excel conversions. This is a one-off project, but I'm interested in a flawless output. Accuracy and meticulous attention to detail are critical for this task.

I urgently require a meticulous and professional proofreader, well-versed in Italian, to refine four not-safe-for-work (NSFW) landin...but not mandatory. Ideal Candidate: - Proven track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Dutch. You will be provided 6 landing pages that you will need to open with a browser language set to Dutch. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is highly val...

I am in need of a professional who can create a detailed 3D model of an home for interior design planning. Home is 175 m2. (2 kids room, 1 office room, open kitchen, dinning room, salon, parents room, 2 x bathroom) Required Skills: - Proficiency in 3D modeling software (such as Blender, SketchUp, or AutoCAD) - Experience in Interior Design - Attention to detail and precision Expectations: - The model should accurately represent the apartment's layout (style of home: family warm interior) - The house will be renovated, but we want to keep furtnitures like kitchen now. I will send scan plan of house + real photo of home inside. - While I have not decided on a specific style or color scheme, flexibility and creativity will be appreciated. Feel free to make suggestions. - Here is...

I have a requirement for an advanced Excel specialist to develop a structured Gantt chart. More details will be provided to shortlisted candidates.

I am in need of an expert who can get my online Shopify e-commerce store ap...crucial as I plan to run Google ads for my business. Here's what I bring to the table: - An existing Shopify store for my pet-focused e-commerce business - A product feed in the form of an Excel spreadsheet that is ready to sync The ideal freelancer for this project will: - Have significant experience with Google Merchant Center and its approval process - Be skilled in working with Shopify and its plugins - Understand how to effectively use Excel product feed for Google Merchant Center - Possess a proven track record of successful Google Merchant Center store approvals Your job will be to guide me in getting the store approved so we can move forward with our Google ad campaigns. Ap...

...ensuring users can easily find what they are looking for. • The user registration process needs to be seamless and as frustration-free as possible. • Page load times must be minimized to keep users engaged and prevent them from leaving the site. In addition, I want to include interactive menus to further enhance user experience. The menus should be visually appealing, easy-to-use, and efficient in getting the user where they need to be. Ideal candidates for this project have a proven track record in UX/UI design, are proficient in development for optimizing websites, and have experience with creating interactive elements. I need someone who can approach this task with a user-centered mindset and an eye for detail. Let's create a more enjoyable user journey toge...

K zobrazení podrobností se zaregistrujte nebo přihlaste.

I am in need of an Excel operator to assist with data entry tasks. Ideal candidates would have extensive experience in Excel and be confident in their data entry abilities. Skills and Requirements: - Proficient in Excel data entry - Attention to detail - Experience with Excel formulas is a plus Application Details: Applicants should include their Excel experience details in their application. Please provide information about past related work, specifically focusing on data entry tasks in Excel. Tasks to be Performed: - Input various data points into Excel spreadsheet accurately - Handle high volumes of data entry - Maintain the integrity and accuracy of the data If this sounds like someth...

I'm looking for an experienced copywriter who specializes in crafting compelling business proposals. My aim is to pitch my public relations services to pote...clients, so a rich understanding of PR and a knack for persuasive, professional language is key. Key Tasks: - Scribe business proposals to potential clients. - Polish my value proposition to a potential client in the PR industry. Ideal Skills/Experience: - Solid background in crafting business proposals. - Strong understanding and experience in public relations. - Proven track record in getting results from business proposals. - Excellent writing, grammatical, and proofreading skills. - Ability to communicate complex information persuasively and succinctly. If you have the relevant expertise, I look forward to he...

...developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and possess knowledge of APIs like GPT. Familiarity with Excel and handling large...

...developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and possess knowledge of APIs like GPT. Familiarity with Excel and handling large...

I need a proficient translator for a document that's less than 1000 words from Spanish and French into English. Furthermore, the translation will need to be inputted into Microsoft Excel. Key responsibilities: - Translate document from Spanish and French to English - Data entry into Microsoft Excel Ideal Skills and Experience: - Fluent in English, Spanish and French - Previous translation experience - Proficiency in Microsoft Excel - Strong attention to detail - Ability to maintain confidentiality I am looking for a translator that can deliver accurate, high-quality translation and data entry with a sharp eye for detail. Please submit your bids with past related works and expected delivery timeline.

I'm...aiming for a modern aesthetic and it's crucial that you're capable of creating designs in this style. - Translating Concepts into Design: These designed shirts will be part of my marketing effort. I want to convey specific themes and messages, so you have to be adept in incorporating concepts into design. - Delivering Print-Ready Files: Ultimately, I require these designs to be print-ready. To excel in this job, you need: - Proven experience in graphic design, especially in modern styles. - An impressive portfolio showcasing your talent. - Strong understanding of how to design for print. - The ability to work collaboratively, take direction, and incorporate feedback. - Great communication and time management skills. I can't wait to see your portfolios ...

I require a skilled data entry specialist to handle an Excel sheet that involves the aid of typing in a combination of different data forms: Numbers, Text, and Dates. - The sheet you'll be working with houses 10 - 50 columns and rows, so attention to detail is paramount. Ideal skills include: - Excellent knowledge and experience in Excel - Ability to accurately and swiftly handle data entry - Proficiency in handling multiple data types This project focuses strictly on data entry alone and does not require any data analysis skills.

I am seeking a highly experienced .NET 8 trainer with advanced level expertise, capable of providing live online training. I was a full stack .Net...coding for 6-7 yrs. I am aware of the basic concepts but rusty at the moment so need to brush up the concepts. So, the training needs to be ground up. Ideal Skills and Experience: - Profound knowledge in C# programming language - Experience with .Net Core - In-depth understanding of APIs and Microservices - IIS hosting - CD via Team City and Octopus This is a fantastic opportunity for those who excel in making complex information easy to understand and engaging. If you are up for the task, connect with me and let's take this further. Please include references of your previous trainings as they will be considered during the sel...

...production planning schedules, reduce wastage, and increase productivity. - Purchase Order Management: The platform needs a feature that simplifies purchase order creation and management. User Scale: - The MRP system will be used by less than ten users. Consequently, it needs to be user-friendly and intuitive, requiring minimal technical knowledge for daily operations. Optional: - We are currently using Excel to do Materials Requirement Planning, so a similar operation logic would be good. Your background should ideally include significant exposure to MRP system development, cloud-based platforms creation, and a keen understanding of inventory management, production planning, and purchase order management. Strict adherence to best practices in software development, a hi...

I am looking for an exper...looking for an experienced Arduino programmer who can help design and develop embedded code for an Arduino project based on sensor data collection. As I have skipped on specifying the type of sensors and exact data to be gathered, the freelancer should have broad knowledge across various sensors and be adaptable. Key requirements: - Create code to collect data from various unspecified sensors - Experience with a wide range of sensors is beneficial - Knowledge of Arduino programming and sensor data collection - Problem-solving skills and adaptability - Ability to recommend various sensors based on different use cases Please note, the specific sensors and data to be collected haven't been defined currently, thus I require...

As an organisation, we're currently utilizing Excel 365 and have compiled sales figures by product that we'd like to further analyse. We're in need of an expert in Power BI who can help us convert our Excel data into meaningful Power BI visualizations. In essence, our main objective is to analyze our sales data comprehensively. Key Tasks: - Convert our Excel 365 sales data into Power BI - Design intuitive and interactive dashboards - Provide insights based on the data analysis Successful candidates should have: - Proven experience with Power BI and Excel 365 - An ability to create interactive visualizations - Strong analytical skills, particularly in sales data analysis

...Milestones: MS1: extract transcription of the voices (0..n voices) we will share you testing videos and audios MS2: create a new video based on the json and add the transcription as a overlay to the video Budget? will not be disclosed, place your best bid to get considered Payment? - you estimate in a WBS (optimistic, expected, pessimistic, where optimistic < expected < pessimistic) after getting the task - we discuss about clearances and effort - we mutually agree to effort - we assign you the task after mutually agreed - you provide us a delivery date - you implement, test and deliver - you provide also unit /integration tests to ensure code is always working - you document each required step to make interaction of systems to work - we test on our premise (you maybe ...

I'm seeking a highly efficient individual to conduct in-depth interviews of 30 project manager candidates, with the end goal of selecting the best 5. Ideal Candidate's Skills and Experie...Candidate's Skills and Experience: - Proficient in interviewing techniques and selection processes - Background in IT is highly preferred - Understanding and knowledge in project management - Familiarity with leadership, communication, and technical aspects of a project manager role - Experience in handling software development projects This task is quite significant as it plays a crucial role in getting the right people for my team. Hence, I need someone who's not only good at interviewing but also has a deep understanding of the IT industry, project management, including ...

I am currently looking to make alterations to an existing VBA Skyline chart. Specifically, I need assistance with: - Adding dates to the Form Labels. The dates in question will be the Plan Date, Actual Date, and Forecast Date. - Adjusting axis labels. - Changing the chart's color scheme. The ideal freelancer for this project should have substantial experience in working with VBA Skyline Charts and data labels modifications. They should also have a keen eye for aesthetic details such as color schemes.

I'm looking for a proficient Excel expert with a strong background in production planning and forecasting. The task at hand involves revising and enhancing an existing production schedule, enabling it to track more complex parameters and deliver insightful reports. In particular, the freelancer will need to: - Incorporate production milestones into the schedule, with these milestones determined by both booked work values and forecasted values. - Integrate a system for tracking production based on specific booked work values, as well as forecasted values. - Use parameters such as Steel in Tons and kg, and Pipe fabrication in Diameter inch for forecasting production. The ideal candidate will have: - Profound knowledge and experience in Excel and its more advanced featur...

I'm in need of skilled developers to create a web and mobile application for my log sheet management system. The applications need to cater to data entry, approval, storage, and controlled access to records. Records should be accessible in PDF files, Excel, and Word formats, in a particular layout that I'll provide. Files and data to be stored in our own server which can be accessed via internet. Sample file format attached Key Features: * Compatibility: The mobile application must be compatible with Android devices. * User Roles: The application will host three user types - Data Entry Operator, Record Manager, and System Administrator. Each role has distinct responsibilities and access within the application that I’ll explain further down the l...

Hi, I am a backend developer experienced in data extraction, web scraping, and automation. I guarantee: - Quality and Quantity - Fast delivery For more details, don't hesitate to get in touch with me. Thanks for your time. Cheers, Amr E.

I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. ...

I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. ...

...an experienced industrial engineer proficient in Excel to develop the capacity requirement component for a Manufacturing Resource Planning (MRP) system. The project involves integrating the capacity requirement section with the existing material requirements planning (MRP) part, creating a cohesive manufacturing resource planing MRPII system in Excel. Key Requirements: 1. Develop the capacity requirement component in Excel. 2. Integrate it seamlessly with the existing material requirements planning part. 3. Create a user-friendly interface for easy navigation. 4. Implement backstage functionality to simplify user interaction. Project Timeline: Completion within two days. Budget: Maximum budget is $100. If you are confident in your Excel skills and can ...

I require an Excel expert with in-depth knowledge in VBA for developing a comprehensive invoicing system. I have my qr scanner when I scan product it's shows products details automatically. I attached 5 list of products. Your Task: * Create VBA macros to automate system functionalities * Design invoice templates that encapsulate professionalism * Implement automation for data entry tasks Purpose: The overarching purpose of the invoicing system is to streamline the tracking of sales and payments, automatically calculate finance-related aspects, and generate professional invoices that accurately represent our company. Required Features: * Ability to generate insightful reports on business financial trends * Functionality to send automated reminders for pa...

...specific website and save the data into a .xlsx file. I want three different scripts to scrape different sections of content from the same domain. See attached example for each of the three inputs and outputs required. Key skills required: - Excellent command over Python programming, especially for web scraping - Experience with Libraries like BeautifulSoup, Scrapy - Familiarity with xlsx file operating in Python - Strong understanding of web automation and bots Please make sure you: - Have a good grasp of exception handling to make sure the scraping script can handle errors and won't crash. - Can design the script in a way that it respects the terms of the website and avoids the potential of getting blocked. - Are meticulous and careful in ensuring the accuracy ...

I require an experienced data entry specialist to convert a substantial volume of physical documents into an organized format in Excel. The job is significant, involving more than 1000 entries. This task necessitates the following: - Proficiency in Excel and its various functions - Experience with high-volume data entry projects - Excellent attention to detail - Ability to convert physical documents into digital data accurately Additionally, a strong understanding of maintaining data privacy and confidentiality would be advantageous.

I require a talented professional who is well-experienced in ArchiCAD, for 3D rendering services. The project revolves around producing realistic 3D designs and stunningly lifelike renders that would catch the eye. Though prior experience with detailed and realistic 3D rendering is essential, those who showcase exceptional portfolio are highly encouraged to bid. Ideal Skills: - Expertise in ArchiCAD - Proven track record of Realistic 3D rendering - Attention to detail Experience: - Prior experience with realistic 3D rendering on ArchiCAD - A compelling portfolio showcasing 3D renditions

I will provide the freelancer with a formatted template in Excel. I will also provide the freelancer with 5-7 different excel documents that are micro reports. The freelancer will pull the data/information from the 5-7 different excel documents and format them inside of the template, keeping the same colors and conditions. The template includes a pivot table. The freelancer will need to replace the information on the pivot table with the new data from the 5-7 different Excel documents.