How to force excel to open csv files with data arranged in columns jobs
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.
...before agreeing to this job. This is how my web query look, see the most right picture, the table doesn’t show up 3. In the Worksheet "Link 1", this contains a list of basketball league tables from several countries. I have only listed 1/10 of the full list for the purpose of testing the outcome of this job. 4. The link for each of the table is listed in the RED weblink. 5. Requirement- The requirement to copy from the "R" until the last row last string, such as W1 in the example. The data will be pasted in the cell right below the link, in this example is Cell B7. 6. Requirement- When the spreadsheet is opened, there should be an option if i want to refresh all the links, or remain as it ...
Looking for an expert in data 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 the data into an Excel sheet.
I am in dire need of an efficient, detail-oriented administrative assistant who can help me with a number of tasks that I am currently juggling. 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. ...
...Android developer to build a financial application for small businesses. Key aspects of the project include: - The app should majorly focus on providing high-quality financial reporting functionalities. - Simplicity, yet practicality is the driving force. The interface should be user-friendly, offering clear navigation and easy understanding even for non-financial business owners. - Privacy and security of financial data is critically important. Experience in encryption and data protection will be highly valued. Ideal Candidate: The perfect fit for this project will be someone who has professional experience in Android app development, expertise in integrating financial reporting tools, and a proven understanding of data protect...
...of my project centres on lead generation. 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 b...
...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 o...
...WANTED TO HAVE THE SAME THING I WOULD HAVE DONE IT MYSELF. USE YOUR FANTASY, AND PLEASE READ THE DESCRIPTION: NOBODY IS USING THE COLOR PALETTE. NBB: FOR THE WINNER, IF HE/SHE DOES A GOOD JOB, THERE ARE MORE PROJECTS THAT COULD BE DONE ON A HOURLY RATE. PLEASE DO NOT SUBMIT SOME NONSENSE, YOU'RE WASTING YOURS AND MY TIME. Project Overview: I need an infographic that visually represents the process and core components of our cloud-based technology solutions. The emphasis is on our "Insight Accelerator" approach as a catalyst, along with our interconnected services and cloud-native foundation. Infographic Structure: I attached a miro-concept. The idea is that the bottom is the foundation that's shared by all the services, the top (insight accelerator)...
I need a large volume of (Female) dating profiles with the following information: Name, age, bio, interests and pictures (min 2 per profile, but more is nice). Preferably in SQL or CSV. You can scrape them from other dating sites for exmaple, I need previews before buying. More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Experience How soon do you need your project completed? ASAP
I'm in urgent need of a web based application that 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 wor...
...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&#...
I’m experiencing a disk space issue on my Ubuntu VPS server due to MySQL binlog files. This problem emerged less than a month ago. My system is running MySQL version 8.0.32. It is deployed in a VPS Digital Ocean Droplet server. I need someone with technical expertise, especially dealing with binlog files. Your task will be to analyze and resolve this issue without disrupting the server’s operation. Skills Required • MySQL • Ubuntu • VPS Server Management • Disk Space Usage Optimization Wordpress
...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 ac...
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 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.
...offers the flexibility to work remotely from home. Responsibilities: 1. Conduct outbound calls to prospective clients in the education sector to promote our products and services. 2. Engage with leads effectively to understand their needs and recommend appropriate solutions. 3. Present product information, pricing, and benefits persuasively to potential customers. 4. Follow up on leads and inquiries promptly to ensure timely conversion and closure. 5. Achieve and exceed sales targets on a consistent basis. 6. Maintain accurate records of all sales activities and customer interactions in the CRM system. 7. Collaborate with the sales team to develop effective sales strategies and campaigns. 8. Stay updated on in...
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
As an entity constantly 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...
...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...
As an organization with multiple employees, we need an expert to perform a detailed audit of approximately 400 of our staff files with a keen eye for detail. Your task would involve verifying existing documents, ensuring that the necessary onboarding documents are present in each file, and noting where they are not, in an organized spreadsheet. The ideal freelancer for this task would have: - High attention to detail - Previous experience in Human Resources and Compliance - A working understanding of necessary onboarding and compliance documentation - previous audit skills are of benefit To be audited: each file should contain: - Employment contracts - Identification documents - Compliance documentation e.g. First Aid Cer...
...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, professional look, combined with a contemporary twist is what we're ...
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 o...
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 insi...
...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 ...
...business with moderate monthly transactions, I'm seeking a proficient professional to manage my administrative and accounting tasks. Responsibilities include: - Data entry: 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...
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 optio...
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 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...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�...
...before agreeing to this job. This is how my web query look, see the most right picture, the table doesn’t show up 3. In the Worksheet "Link 1", this contains a list of basketball league tables from several countries. I have only listed 1/10 of the full list for the purpose of testing the outcome of this job. 4. The link for each of the table is listed in the RED weblink. 5. Requirement- The requirement to copy from the "R" until the last row last string, such as W1 in the example. The data will be pasted in the cell right below the link, in this example is Cell B7. 6. Requirement- When the spreadsheet is opened, there should be an option if i want to refresh all the links, or remain as it ...
I am in need of a talented interior designer to add a modern twist to the midcentury styled bedroom, en suite and wardrobe in my home. The specific requirements for the job are: - Design knowledge: Having a deep understanding of midcentury design and an ability to incorporate modern elements within this design language is necessary. 2D plan is attatched. - Bedroom design: The bedroom is of medium size. The design should make optimal use of the available space and transform it into a relaxing sanctuary. Built in warderobe/closet or walk-in one. Pale wooden floor or carpet. - En suite design: a preferably micro cement bathroom in a beige/or light grey colour palette. All windows will be replaced to modern black aluminium o...
In this task, I need a freelancer to transform my Google Sheets data into a Microsoft Excel file. While I am unsure about the preservation of formatting during the file conversion process, I appreciate someone who could provide advice on this matter. I am not currently using any filters, so this will not be a concern. Finally, the total should be displayed in bold in the last row. Skills and Experience: - Proficient in Microsoft Excel. - Strong understanding of data conversion between Google Sheets and MS Excel. - An ability to suggest the best approach for formatting preservation could be advantageous.
I am seeking a skilled R programmer to develop code for comprehensive data analysis. The project revolves around analyzing scientific research data, with an emphasis on providing descriptive analysis of these data sets, particularly writing code to create interaction matrices that will be used for social network analysis. 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
...gathering data available online to paste onto an excel spreadsheet. Here's what I need: - Have the skills to conduct online research. - Extract company names, financial data, and the location of companies found during the research. - Have the ability to organize this information nicely in a spreadsheet. - I will give you the company names and where to find the information, so this is also about the ability to follow instructions I'm looking to get this done asap so speed vs cost is important to me. This is a very simple task. Ideal freelancers will have proficiency in web research, be organized and detail-oriented, and possess excellent data entry skills. Knowledge of finance and basi...
Objective: Develop an open-source Chat GPT application accessible through a web interface, designed to cater to a small team. This project encompasses server setup, test environment creation, and the development of an installation script for easy deployment. Phase 1: Requirements and Planning Provide requirements for a server vps, e. g. for hostinger. Phase 2: Test Environment Setup Provision Test VM: A virtual machine matching the above specifications will be provided for testing. This VM will be accessible to the developer m for deployment and testing purposes. Environment Setup: Install necessary dependencies: Docker, Docker-compose, Python, Git, and other dependencies required for running the Chat GPT model. Configuration for web access, including setti...
I need assistance with filtering data based on date ranges within SQL queries for a database that uses a DD-MM-YYYY format. The ideal candidate would possess: - Proficiency in writing and debugging SQL queries - Experience with implementing conditions in SQL queries - Strong understanding of date formatting and how to filter data based on a given date range. Deliverable: I have an excel sheet extracted from sql server I need a query to have the punch in and punch out on the same row note sometimes the punch in and punch out is not in the same date
I am looking for passionate and experienced Excel experts who can optimize my Excel Gantt Planner (Calculette Rollout v13 - ) through several adjustments: Formatting Improvements: - **Color Coding:** Implement my provided color palette to create a more visually intuitive and aesthetically pleasing spreadsheet. - **Macros corrections** - **Calendar translation** >>>>>> I need what is in the PPTX file that is attached with the project <<<<<<<< Any ideas, improvements are welcome. + There is another Excel table (Suivi ) and I need a nice looking GANTT planner to be added to it (Project 2 Gantt ). Please DO NOT CONTACT ME to ask for more money than the budget I can afford.
I'm seeking an experienced data visualisation expert for the creation of an interactive D3.js project. Key Requirements: - Prior expertise in creating visuals from numerical data. - Strong proficiency in D3.js for advanced - may need to do data manipulation ising excel or python to get the data tonthe right format for visualisation (not simple bar or pie charts alone) - visualisation to be used in website - Proven skill in creating interactive data visualisations. I am aiming for these visualizations to be very interactive, allowing viewers to engage with the data in a dynamic way. The successful freelancer would ideally present a portfolio evidencing simi...
I have a website i need transfering from a old host site to my host site. Im not sure what im doing. Yhere is 35k files and stops at like 12k files. Need help please. Will give access to what ever you need.
...developer to create a web-based NGO membership software with a mix of pre-made templates and custom design. Functionality is key, and the software needs to easily handle: • Member and staff registration and login • Import and Export Membership with CSV/Excel format • Features for alerts via email and mobile SMS • Payment management • Comprehensive communication tools • Leads and member follow-up capabilities • Appointments and call management • Document management for customers • Creation and dispatch of quotations & invoices • Expense tracking • Staff management features • In depth accounting reports • Catalog or service management features • Features for alerts...
I'm currently working on a book project that features 50 newspaper articles I've written. To ensure my work's credibility, accuracy, and ensure no copyright issues, I need assistance in tracing back the original source of each article. Key tasks will include: - Determining the original source of every article - Verifying the accuracy of the information in the articles - Identifying the newspaper title, publication date, and the URL of each original publication All the gathered information must be recorded in an Excel workbook. Experience in data research, data entry works, and strong proficiency with Excel would be crucial for this project. Knowledge of journalism, media law, and an understanding o...
...need a competent full stack developer to help with the creation of a language learning flashcard application that will be integrated into my Wordpress LearnPress site We have language learning courses, and we want to integrate the vocabulary from those courses into a flashcard application on our site. So I will be providing the flashcards, including text, audio and images. The flashcard application should work similar to Anki and Memrise (old Memrise) Key Features: - User is doing a lesson in our courses and clicks to add the vocabulary from that lesson to the flashcard application - User can go to the flashcard application. The first screen they will see is a dashboard with some basic statistics ("due cards", &...
I'm seeking a talented individual with strong data entry skills to digitize contact information from 125 business cards into an Excel spreadsheet immediately. Details: - Data to be entered includes: ENTER THESE FIELDS BUSINESS FIRST NAME LAST NAME POSITION PHONE CELL PHONE FAX EMAIL WEBSITE ADDRESS CITY STATE ZIP CODE Ideal Skills: - A keen eye for detail as accuracy is paramount - Prior experience with data entry projects - Proficiency in Excel - Excellent time management skills to ensure prompt project completion Note: Only bid if you can start immediately. I'm on a tight deadline and need this task completed posthaste.
...regression) to predict startup profits (). The following steps should be done and need to be explain the code using # comments 1. Read the dataset from the csv file and put input data in X and output data in Y. 2. Deal with missing and categorical data (Data cleansing, even if there are no missing data) . 3. Divide data into four subsets (X_training, Y_training, X_test, and Y_test). 4. Train the learning model using (Linear regression algorithm) 5. Make a list of predictions Y_pred and compare it with Y_test. Explain what do you remark? 6. Make a prediction for a given data sample. 7. Without using "predefined functions" Find the following: 7.1. Total deviation of the regressio...
I am looking for a professional who can efficiently extract and copy all information f...looking for a professional who can efficiently extract and copy all information from a PROTECTED Airtable sheet to Excel. No adjustments or specific arrangements on the data are required - I just need all the values intact and legible. Key responsibilities: - Extract all data from the PROTECTED Airtable sheet: - Copy data to Excel without any modifications This is a one-time task, so timeliness and accuracy are essential. Ideal freelancers are those who have extensive experience with both Airtable and Excel, as well as a deep understanding of data extraction principles. Strong attention to detail is an asset.
I’m looking for a freelancer with expertise in importing data from Google Sheets into Wordpress. I am launching a large new website on a new domain and I have information on 2,357 government programs in a Google Sheet. My Google Sheet is structured as follows: - Rows: There are 2,357 rows. Each row is a government program. - Columns: There are 21 columns. Thirteen of the columns contain text information on each government program; 8 rows contains tags for each government program. A sample of the Google Sheet is here (note: this is a sample of 100 rows. There are 2,357 rows in the complete sheet): You can see an example of how I want the post laid out here (I own this website and previously
I'm seeking a skilled Excel specialist to develop an efficient reporting system derived from our Core Banking System. Key Responsibilities: - Enable data extraction, both manual and automatic, for maximum flexibility. - Integrate fundamentals like Financial and Regulatory reports. - Incorporate functionality for Ad hoc reports based on unique user requirements. - Ensure the system is adept to update the aforementioned data on a daily basis. The freelancer best suited for this task will have exceptional skills in Excel, and experience developing similar banking or financial reporting systems. Appreciation for detail and understanding of financial and regulatory protocols are also desired.
I am in search of a skilled sales officer to join our team at Yes Bank, specifically within the credit card department. The ideal candidate will be responsible for: - Lead Generation: Creating a robust pipeline of potential customers. - Customer Acquisition: Successfully onboarding new clients to our credit card services. - Sales Target Achievement: Meeting and surpassing outlined sales targets regularly. The perfect fit for this role is an individual with the following qualifications and experience: - Sales Experience: Proven track record in a sales environment. - Excellent Communication Skills: Ability to engage effectively with potential customers. - Microsoft Excel: Proficient in using Excel for data managem...
