Switch excel vb6 app use open sheet jobs
I require a freelancer who is proficient in extracting specific data points from a PDF document and translating it into a structured Excel or CSV file. The data is presented within paragraphs. Key Tasks: 1. Extract the following elements from the PDF: Names, dates, numerical values, lead location, phone number, email, US dollar value, status, date added. 2. Organise these elements in a structured format in an Excel or CSV file. Skills Required: - Attention to detail - Proficiency in data extraction - Strong knowledge of Excel or similar data management software - Ability to interpret information from paragraphs. Freelancer should assure accuracy as the correctness of extracted data is essential.
...information. -Ensure all guest details, including name, email, phone number, reservation number, booking period, and payment information, are promptly forwarded for record-keeping and follow-up purposes. Requirements: -Strong attention to detail and accuracy in task execution. -College degree or equivalent qualification preferred. -Proficiency in basic software tools, including Microsoft Office (Word & Excel). -Ability to operate electronic devices (computer or phone) proficiently. -Fast-paced and adaptable to changing priorities. -Ability to commit to 10-30 hours per week, approximately 2-4 hours per day. -Willingness to undergo a short trial test or task, lasting 2-4 hours, with the possibility of extension up to one week if necessary. Duration: The duration of the jo...
I am presently working on an extensive project involving several excel spreadsheets. These spreadsheets contain sentences for a book and I require a freelancer to help me color code the cells based on different categories. The color will represent different aspects of each category. The color coding will include: - More than 10 different categories - Existing color suggestions that need refining - Categorization that's based on multiple factors, going beyond the book chapters The ideal freelancer for this job should possess a good understanding of Excel and have a knack for good organization and attention to detail. Strong collaboration and communication skills are key, as I'll need to discuss and finalize the color scheme and the factors affecting categorization...
I'm in need of a proficient Excel expert who can proficiently apply formulas to my dataset. Here's what you'll be taking on: - Add 'Sum', 'Average' and 'Count' functions to the given data set. Your expertise in implementing these formulas will be highly valuable. - The dataset needs to be sorted based on validity. I'm not entirely certain whether ascending or descending order would work best, so I'm open to your professional advice. - Prioritization should be given to the most recent entries. They should appear at the top of the dataset after sorting. To succeed in this task, you must possess advanced understanding of Excel functionality and a keen eye for detail. An ability to work independently, make efficient...
Need nay type of data entry work
Hello, I and creating a 3-year business plan. I have the first-year projection but I need to calculate the subsequent years, both 2 and 3. I need to add 15% each year which I am using year one as a basis to calculate and add 15 percent each year.
...validate data from an excel file to a database. This function should be equipped with the following features: 1. Data Type Validation 2. Data Format Validation This task requires proficiency in database structures, data validation methods, and experience working with Excel file manipulation. The ideal candidate, consequently, should be able to display capabilities in these areas. Their experience in similar projects would be a bonus. Here is the main flow: 1. User upload excel file 2. System will check and validate the data 3. System saves record into multiple tables in a database 2 types of excel files involved. Please check attachments. 3 types of data will be stored into database 1. User profile 2. User farm 3. User plant Detailed flow: 1. User u...
...creating innovative solutions and possess a strong background in full stack development, we want to hear from you. Responsibilities: Collaborate with cross-functional teams to define, design, and ship new features. Develop front-end components using modern JavaScript frameworks such as React or Angular. Design and implement server-side logic using Node.js. Build reusable code and libraries for future use. Optimize applications for maximum speed and scalability. Implement security and data protection measures. Conduct code reviews and provide constructive feedback to team members. Requirements: Bachelor's degree in Computer Science, Engineering, or related field. 5+ years of experience in full stack JavaScript development. Proficiency in front-end technologies such as HTML...
...creating a Google Sheet template that will be used for blocking out time for bookings. We will call it a media blocking sheet. the first would be one based on days and the second would be based on weeks. The idea is to enter in the client name, enter the start date and end date then the amount of days would auto populate and then in that row, blocks would populate in for those dates. Also, we would need the template to match the calendar year - for example, this year there were 29 days in February. So having an ability to change the year somehow and then the sheet would update. The next tab would be a weekly blocking chart where we enter the client name, the start date and then fill in a value for the end date and with a week counter. This could be also done with on...
I am struggling with a VBA Excel file where the Macro is not running correctly, and I need someone proficient with VBA and debugging to fix it. The file is crashing frequently, which is causing significant delays and impacting efficiency. • **Macro Issue:** The macro is not running and I am unable to debug or fix it myself. I need an expert who can look into the problem, define what's wrong, and provide a solution that works flawlessly. • **Purpose of the Macro:** I will discuss this further with the successful applicant, but rest assured that your tasks will align with typical VBA Macro functions. Since the purpose of this macro hasn't been disclosed, I am expecting you to have experience with commonly used VBA functions like automated data entry, formatting d...
- Create VB Macro for pulling dates: This Month to Date, This Quarter to Date, This Year to Date and have dynamic calculations no matter what the date is OR allow user to have a custom Begin Date and As of Date. - Checking and savings accounts need to pul...unless you can write a SUMIF or other formula to pull the data without needing column S using the same requirements as above. - Owner’s Advance needs to pull transactions from “Transactions” worksheet, column T, unless you can write a SUMIF or other formula to pull the data without needing column T using the same requirements as above. - Create VB Macro associated with button to export Balance Sheet as an XLS <Note, this macro can be copied from the Invoice template> - Can there be a version to include Ow...
...to work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. While working on the main keywords, I expect additional keyword phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. If we need to create additional webpages to rank for these keywords, that is fine. Freelancer is to recommend what is needed in order to rank for these keywords. Ideally, I would like the home page to rank for these. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read...
I need a Google Apps script expert. This project involves creating a script that regularly saves specified column data from a Google Sheet as a static copy on a weekly basis. I have detailed and explained it on how it should be in the sheet with a final dashboard present as well with the required outputs. Link to sheet and how it should be : Requirements: - Expertise with Google Apps Scripts - Familiarity with Google Sheets environment and scripting Script Functionality: - Script should run weekly - Specific columns from the Sheet should be saved in the static copy - The range of these columns was not specified, additional information might be provided through direct communication
...so the history and mission of our company. Introduction of our individual team members is not necessary for this project. • Services Page: This page will enumerate and explain the consulting services we offer, providing potential clients with a detailed understanding of what we can offer. A Developer with a strong background in Wordpress and a good understanding of UI/UX best practices will excel in this project. Proficiency in both front-end and back-end development is paramount. Also, having a history with similar consulting websites will be a significant plus. In your proposal, please include examples of prior consulting websites you've created....
I am in need of an expert in Excel who can provide assistance in managing multiple sheets in an Excel file. The spreadsheet requires extensive data analysis, formula creation, and formatting. Key requirements include: - Ability to analyze complex data across multiple spreadsheets - Proficiency in creating advanced Excel formulas to automate processes - Expertise in formatting spreadsheets for ease of use and understanding While I have advanced proficiency in Excel, I need someone capable of handling these tasks efficiently. A background in data science or similar is desirable.
...want to refresh all the links, or remain as it is. 7. Requirement- Computation or refresh of the data should be within the Excel file itself, if an external programme is required, i can consider if it is not too complex. 8. Requirement- must be able to add to this list as it is not complete and there are always changes For 2nd link 3. In the Worksheet "Link 2", this is for the pasting of data from the weblink 4. The link for testing is , cell A2. 5. Requirement- There are a total of 5 tables needed for each weblink. All the web version of the tables are shown the right for reference. 6. Requirement- i am able to use web query to extract the 1st 4 tables, except for "Live Odds Comparison". it doesn’t show up in my web query. 7. Requirement...
...Romanian balance sheet denominated in the local currency (RON - Romanian Leu). The final deliverable will be an Excel spreadsheet that not only presents the translated information but also aligns the financial data with Italian accounting standards, ensuring clarity and compliance for stakeholders in Italy. Objectives 1. Translation Accuracy: To ensure the financial statements are accurately translated from Romanian to Italian, capturing all financial terminologies and nuances without loss of meaning. 2. Compliance with Italian Accounting Standards: To reclassify the financial data in accordance with Italian Generally Accepted Accounting Principles (GAAP), ensuring that the reclassified balance sheet reflects the formats and categorizations typical in Italy. ...
Looking for an expert in data extraction and management, specifically from Websites, APIs, and Databases. The project involves extracting numerical data daily and...extraction and management, specifically from Websites, APIs, and Databases. The project involves extracting numerical data daily and integrating the information smoothly into an excel sheet. Skills & Experience Required: - Expertise in data extraction. - Proficient in API integration. - Experience with database management. - Excellent skills in Excel data manipulation. Responsibilities: - Setup extraction from multiple data sources (Websites, APIs, Databases) using Zapier. - Ensure extraction of numerical data only. - Secure daily extraction and update of the information. - Seamless integration of t...
Craft an A4 sized glossy magazine for a special 50th birthday project, designed specifically with the receiver in mind. - Design Focus: The magazine is for a single reader, the person ce...Also able to review and update during process - End of day update regarding process - The project contains around 50 pages Cover, Index, Content Pages & Backcover - pages are added to separate folders so images and text are matched ( zipfile 208MB available throuh wetransfer ) - folder 00 needs to be the first content page ( there where it regards his partner. ) All other pages should be able to switch in order - Project deadline 25-03-2024 ( 12:00 CET ) Please note that while the design and layout are paramount, being able to bring a unique, personalized touch to the project is also g...
I am in dir...Your core responsibilities will include: - Data Entry: You should be familiar with Microsoft Excel, as a significant part of your job will be related to entering and managing data in a structured, orderly manner. - Email Management: Not only will you be tasked with responding to inquiries on my behalf, but you'll also be setting up automated responses to maximize efficiency and ensure no email goes unanswered. - Scheduling: You will also help in scheduling meetings. This will involve coordinating with multiple parties to find suitable times. Ideal candidates should have prior experience in administrative roles and should be proactive with excellent communication skills. Mastery of Microsoft Excel is a must, and previous experience with email management ...
Overview: We are seeking a skilled Python Developer with a strong background in finance to develop a comprehensive balance sheet optimisation model. This project aims to enhance our financial analysis, risk management, and strategic decision-making capabilities. The ideal candidate will have a solid understanding of financial principles and experience in applying Python for complex financial modeling and analysis. Key Responsibilities: Design and develop a balance sheet optimisation model using Python, focusing on linear and dynamic programming initially, and incorporating stochastic modeling in later phases. Work closely with our financial team to understand requirements and integrate financial data sources, ensuring accurate and efficient data processing. Develop and impl...
Th...To successfully meet the project's goals, I require a specialist in email scraping to obtain addresses for real estate agents across South Africa and the UK. The target website where these emails will be extracted from is Property24. Of utmost importance and unique to this project is the regional scope. It should cover all regions, without exclusions, within the two countries mentioned. To excel in this project, having the following skills/experience would be ideal: - Strong experience in email scraping - Familiarity with the Property24 platform - Sound understanding of real estate markets in South Africa and the UK - Ability to accurately segment data by region Your commitment to accuracy and attention to detail will strongly influence the success of our subsequent l...
I am looking for an experienced VBA developer to create a custom add-in for Excel. This project will require: - Developing custom functions to automate the generation of multiple types of charts in Excel, specifically pie charts, bar charts, and line charts. - These charts should be formatted according to our specific design requirements, including our house style and measurements. The ideal freelancer will have exceptional skills and experience in VBA and Excel add-in development. I expect a strong understanding of data analysis and an excellent ability to perform tasks accurately and efficiently. Furthermore, I value clear and regular communication so we can ensure the end result meets our expectations. Please only apply if you are confident you can deliver th...
I'm in urgent need of a web based applicat...transforms PDF files, largely bank statements, into Excel layouts. Key Features: - The application should have batch conversion support, allowing numerous files to be converted at the same time. - It needs to have OCR (Optical Character Recognition) capability for pinpointing and extracting info from scanned PDFs. - Its operation should be secure with user authentication and access control features to maintain data privacy. Ideal candidate skills: - Robust experience in web application development - Familiarity with OCR technology - Knowledge in building secure applications with user authentication and access controls - Ability to work under pressure to fulfill project needs ASAP P.S: Keep in mind, the goal is to produce files i...
Today, I need a professional with deep understanding of database creation and Excel data organization to produce a new, streamlined database from my current Excel one. Key Project Requirements: - Convert an Excel database with 1-10 sheets/tabs into a new database system. - Your task is to simplify and streamline the layout of the data for ease of use, without losing critical information. - While expertise in Excel is a must, experience with other database systems is also necessary, considering we might need a smoother platform than Excel. Ideal Candidate Skills: - Thorough experience working with Excel and other database systems. - Exceptional at delivering swiftly to meet today's deadline. - Excellent understanding of efficient da...
...freelancer to assist us in acquiring legal documents for the fine-tuning of a GPT-4 Turbo model. The data will be used to improve the model's understanding and generation of legal document content. Responsibilities: Identifying and gathering legal documents from reliable online sources. Ensuring the quality and relevance of the collected legal data. Organizing and structuring the data for effective use in fine-tuning the GPT-4 Turbo model. Collaborating with our team to understand the specific requirements for legal document data collection. Requirements: Strong research skills and ability to find relevant legal documents online. Attention to detail and ability to ensure the quality and accuracy of legal data. Familiarity with legal terminology and document formats. Abili...
Hi Nidhi M., I have new project for you called Open Banking. If you are interested, please accept the project, so I can send you further information.
I'm in need of a python script to automate counting views on Instagram reels. The source data is provided in an excel sheet, listing multiple user IDs and corresponding profile links. Required tasks: - Traverse through Instagram user profiles found in the excel sheet - Count the total number of views for reels posted within the last 7 days - No specific order on how to navigate the excel entries is needed - count the views of reels in the basic of hashtag (a common hashtag is used in reel of every user). - we need to scrap 5k to 10k per day and make sure that script will not get band. - also make a very basic level single page of UI so that it is easy to use (you can copy the UI from anywhere you wants to) Ideal skills and experience for the...
I need an experienced data scraper who can extract specific information from a horse racing website. Your task will be to gather data on past horse race records, focusing on: - Horse Names - Race Dates - Horse Positions - And the complete data from the table What I need is for this information to be extracted from the website and then outputted into an Excel file. Proficiency in Data Scraping tools and Excel is mandatory for this task. Prior experience with similar sports data scraping will be highly advantageous. Efficiency and accuracy are crucial in this project.
Job Title: Education Sector Telecalling Sales Expert (Work from Home) Position Overview: We are seeking a highly motivated and results-oriented individual. The ideal candidate will possess excellent communication skills, a proactive attitude, and a strong sales mindset. This p...experience in selling educational products or services. 2. Familiarity with online learning platforms and technology solutions in the education sector. 3. Additional language proficiency is a plus, especially in regions with diverse language demographics. This is a remote position offering competitive compensation with attractive incentives based on performance. If you have the skills and motivation to excel in a telecalling sales role within the education sector, we encourage you to apply and join our dyn...
...snippets, practice problems, and user discussions. Visualization: This is the heart of your website! Visualize how each algorithm works step by step. Iteration Animation: Show how data changes during each iteration (e.g., swapping elements in bubble sort). Allow users to: Toggle Visualization: Some learners prefer visualizations, while others prefer textual explanations. Provide an option to switch between the two. Play/Pause: Let users control the animation speed during visualization. Step-by-Step Mode: Allow users to move through each iteration manually. Quiz Mode: Test their understanding with interactive quizzes related to the algorithm they just learned 2. **Custom Input Section (Subscribed Members Only):** - Subscribed users can perform DSA ope...
I need an expert in MS Excel to finalize an advanced timeline schedule. It should consider different factors such as: - Variable work hours per day, - Weekends, - Overtime hours. It's crucial that the dynamic schedule intelligently adjusts to these factors, providing an accurate timetable for my team's workflows. Column M should focus on "Estimated Completion Time". Ideal candidate should possess: - Excellent knowledge and experience with Excel functions and dynamic formulas, - Attention to detail, - Adherence to specified conditions, - Familiarity with corporate scheduling norms will be a plus. Your insightful input to perfect this timeline tool would be highly appreciated.
I need an Magento 2 extension for free shipping, if an open order of the same xustomer exists. Details: *When a customer is in checkout, then check whether an open order already exists for the same customer that has not yet been dispatched. The check should be done by provided Email Adress, so its functional for guests too. *If Free Shipping is possible, then set the shipping method to "free shipping" and show the order number of the open order in the description text
...dealing with vast amounts of data, I need a proficient Excel VBA expert to assist in automating my reporting and dashboarding processes. An ideal candidate for this project should possess the following: Skills and Experience: • Extensive experience developing VBA Macros • Capability to generate reports automatically • Familiarity with handling data across multiple sheets Specific Tasks: • Developing macros to automate data retrieval from sources such as Excel workbooks and CSV files • Implementing these macros to streamline the process of report generation and dashboard updates By simplifying these tasks, this project will enhance our overall productivity and data management processes. It is crucial that the expert maintains an open line ...
I'm looking for a proficient data analyst with the ability to tackle complex data sources and deliver clear, actionable insights. Key Skills and Experience Required: • Exceptional statistical analysis abilities; • Strong data visualization and programming skills. Expected tasks: • Handle data from different sources such as Excel spreadsheets, SQL databases, and CSV files. • Analyze the acquired data meticulously and generate concise reports on your findings. Project Outcome: • Provide profound insights and recommendations based on the data analyzed. • Create comprehensive visualizations and reports to aid in decision making. • Develop predictive models derived from the data analysis. The ideal candidate for this project will have a notab...
As an marketing agency brand, we are seeking for a redesign of our current logo matching these specific sets of requirements: - Fresh Color Palette: We aren't restricting ourselves to a specific color scheme. We're open to any color scheme suggestions that can elevate and portray our brand's continual growth and evolution. - Reflect Professionalism: The revamped logo needs to embody utmost professionalism. We believe that a professional image plays a huge role in establishing trust and communicating the right message to our clientele. - Modern Design: In terms of style, we're attracted to sleek, modern design elements. Detail-oriented professionals, proficient in delivering modern and trendy outputs would be ideal for this job. Remember, a clean, professio...
I'm looking for a highly organized and meticulous freelancer to handle a numeric data entry task on Excel. Your task will encompass: - Entering simple numeric data into predetermined fields. - Color-coding the entries to ensure easy readability and data categorization. - Ensuring the data is entered accurately and double-checked for any potential errors. Prior experience with data entry, particularly numeric data, is highly advantageous. Proficiency in Excel, particularly with color-coding functionalities, is also a must. Attention to detail is key, as well as the ability to adhere to strict formatting guidelines. Hearing from candidates with a proven track record of delivering high-quality data entry work.
I need an expert in finance and Excel to provide oversight on my project. The Excel model you'll work with is tailored for financial forecasting. The main tasks include, but are not limited to: - Scrutinizing and validating existing formulas - Ensuring data accuracy and integrity - Identifying and promptly fixing any errors These tasks require a robust understanding of finance-related models, specifically in the realm of financial forecasting. Familiarity with investment calculations and risk assessment would also be beneficial, though not a primary requirement. The right professional for this job must have in-depth experience with Excel, its advanced features, and the finance industry. Your insights and expertise will help fortify this model and ensure its ...
...out new opportunities, I need an expert freelancer to beautify my Word document resume. I already possess the necessary content. What I need now is someone who can bring their creativity and sound formatting skills on board to make my resume not just stand out, but shine. Ideal applicants should: - Have prior experience with resume design, particularly in a corporate style and AtS compliant - Excel in the formal formatting of documents, specifically Word. Your duties would include but are not limited to: - Arranging my existing content into an elegant, eye-catching layout - Suggesting addition or removal of sections in order to increase clarity and cogency In your application, kindly elaborate on how you plan to approach this task, what would be the timeline, and how you c...
...Keeping track of all transactions and inputting them into my system accurately is the key. Mastery of Microsoft Excel is an absolute must as this is the platform used for managing this data. - Bookkeeping: I require someone who is well-versed in handling financial records. You will be responsible for keeping all the financial facts and figures in check. - Financial analysis: I expect a high level of accuracy and attention to detail in reviewing financial data for any irregularities. Your role will involve providing insights based on these analyses. Skillset: - Excellent Microsoft Excel skills: Proficiency in managing large sheets of data and adeptness with utilizing various Excel functions and formulas are prerogatives for this role. - Experience in bookkeepin...
I'm looking for an Excel specialist to integrate a user-friendly Graphical User Interface (GUI) into my existing price list spreadsheet for a complex software product line. The GUI should considerably simplify the selection process for our customers, offering the choice between software packages and a la carte ordering. Key functionalities to be included: - Package selection: The GUI should contain an interface allowing users to choose from various software packages. - A la carte ordering: For added flexibility, there must also be functionality for users to select individual software options independently of packages. - Option selection: A tool for detailed and specific software choices is necessary. For displaying the available packages and options, the use of checkb...
I am in need of a skilled Tally developer to customise my current system, specifically to improve our ways of exporting data. I am looking for an expert who can: - Modify our Tally system so it can export TDS deduction data to an Excel template format we use. - Include deductor's detail and deduction details in the data that is exported. - Seamlessly transition data from Tally to our IT PL BS format as well as CAOffice tb format. Experience working with these specific modules and formats will be highly valued. Your expertise should include understanding the requirements of data export and manipulating Tally to suit those needs.
I'm looking for a research guru who can help discover multiple global SMS providers that can cater to worldwide coverage and focus on delivering One-Time Password (OTP) services. -Skills Required- • Excellent research skills • Knowledge and understanding of the global SMS market • Good comprehension of OTP services -Task Overview- • Identify potential global SMS service providers • Analyze and list their ability for global coverage • Evaluate their proficiency in OTP services It will be a bonus if you have experience in telecommunications or related sectors. Looking forward to your well-informed bids.
This project seeks a skilled developer to create a web-based astrology software capable of delivering key features that I require. Key Features: 1. Planets positions 2. Cusp positions 3. Sun rise and set time Please apply if you have: - Prior experience in swiss ephemeris in PHP, C# or VB.Net - Knowledge or interest in astrology software - Familiarity with astrology algorithms, specifically natal chart calculations
I need a spreadsheet created from All of this information is updated and relevant. Once into excel, I need the postal mailing address for each organization. This will need to be found and verified via google.
As an employer, I require a capable freelancer who can create an efficient Excel attendance sheet for me. The ultimate goal is to track my employees' attendance on a daily basis by their work shift. Scope and Deliverables: - Design and implement an attendance sheet using Excel - Categorize the data according to different work shifts - The sheet should capture daily attendance data Ideal Candidate: - Must be proficient in Excel - Should have prior experience in HR systems or work schedule development. - Understanding of data categorization and visualization methods. - Attention to detail is key to perfectly capture the attendance data. Let's implement a tool to maintain an efficient, organized working environment. Hope to collabora...
...be a 0.96 inch OLED screen displaying temperature and time status. * The design should include push button control to start the skin warming and once the push bottom pressed again the program should quit off the warming cycle . * Using Normally closed temperature switch 45 deg. as safety feature Ideal candidates will possess: * Competence in electronics design * Familiarity with Arduino systems * A background in product design would be beneficial, as the device power source will be a battery and it's intended for handheld use. * Experience in interface design would also be useful due to the need for user-friendly LCD screen and button controls. We're looking for professionals who can incorporate safety considerations to avoid overheating or any other poten...
...want to refresh all the links, or remain as it is. 7. Requirement- Computation or refresh of the data should be within the Excel file itself, if an external programme is required, i can consider if it is not too complex. 8. Requirement- must be able to add to this list as it is not complete and there are always changes For 2nd link 3. In the Worksheet "Link 2", this is for the pasting of data from the weblink 4. The link for testing is , cell A2. 5. Requirement- There are a total of 5 tables needed for each weblink. All the web version of the tables are shown the right for reference. 6. Requirement- i am able to use web query to extract the 1st 4 tables, except for "Live Odds Comparison". it doesn’t show up in my web query. 7. Requirement...
