Extract data excel 2008projekty
I have an Excel data set that encompasses 5-10 sheets. I need support in: - Data entry: Entering new information into the existing sheets. - Data cleaning: Checking and correcting any errors in the data, removing redundancies. - Data analysis: Conducting basic analysis of data. Ideal applicants should have beginner proficiency in these tasks. Your experience working with Excel data files, especially handling entry, cleaning, and analysis tasks, will greatly benefit this project.
I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfa...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
I'm in need of a professional proficient in Excel and data entry to support two key tasks: data analysis and spreadsheet management. Here are the tasks in detail: - Data Analysis & Visualization: I've collected customer feedback data which need to be efficiently analysed and visualized. - Spreadsheet Creation & Management: The data mentioned above should be incorporated into comprehensible spreadsheets. In terms of analysis, the focus should be on customer segmentation. Ideal candidates should have: - Advanced proficiency in Excel for data analysis and visualization - Strong understanding of data cleaning and formatting to ensure accurate analysis - Experience with customer segmentation based on feedbac...
...looking for an experienced data analyst who possesses expert skills in Excel and/or Google Sheets and a proficient understanding of Football, Basketball, and Baseball data. Ideally, someone who is skillful with analyzing and interpreting commercial level sports data into the form a betting model that understands, quantifies, and predicts based on specific metrics. The key characteristics of the models are: - Focus on the following sports: Football, Basketball, Baseball - Analyze the following data: Team performance, Player statistics and Game score projections to forecast point spread, totals, and moneyline bets. I have historical data ready to be applied to these models. This is a project where being communicative, organized, and kno...
...dedicated freelancer to conduct research and data scrapping on various high-end fashion websites. The focus of the task is to gather detailed product descriptions, specifically the materials and styles and photos of clothing items. This project will exclude accessories or any other items. Paying AUD$2 for 100 products research Ideal Skills and Experience: - Proficient in data scrapping and web research. - Prior experience in the fashion industry or knowledge of fashion terminology would be advantageous. - Attention to detail, especially in regard to product specifications. Your Role: - Visit a list of specified fashion websites - Extract and collate detailed product descriptions of clothing items, focusing on the material used. - Deliver the data in a com...
as per communication, transfer data from DPF to excel.
I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.
I'm looking for a skilled developer to create a Firefox extension (add-on) that will use both simple scraping and Chat GPT API in order to send customized prompts (based on the scraped elements) and receive responses. The workflow will be very simple: 1. The user will come to a website and start the extension, which will extract 5 different text elements (these will be pre-selected). 2. After that, the extension will automatically modify the prompt (input the extracted data to the template prompt) and then send it to Chat GPT API. 3. It will display the response from Chat GPT API.
...from Excel sheet to What's app Number (At certain condition and without opening the internet browser). Ideal Candidate: - Strong experience in integrating Excel with external systems. - Proficiency in WhatsApp and Excel automation. - Ability to create a reliable and efficient sync process. - Understanding of data processing security and privacy. So, If you're able to send notifications into my what's app number from excel sheet, Then; You're welcome and this contest is for you. Details: I'm engineer, Working for an industrial company and really want to handle the spare parts with the inventory and purchasing managements for assuring that all spare parts available with certain quantities all the time. Requirements: **Data...
I'm looking for a skilled freelancer who can create an automated Excel spreadsheet calculation for me. I need this spreadsheet to perform calculations based on cumulative data, specifically organized by date. You will need to be adept at Excel and have experience in creating automated spreadsheets. Knowledge of data organization and basic statistics would be a plus. I'm looking for a quick turnaround on this project. Please watch my videos for more details on what exactly is required.
...construction firm, we have accumulated vast financial data that requires thorough analysis. Our motivation to perform this task is to better understand what the data says about our operations and ultimately enable us to make strategic project decisions. Details - The task involves analyzing complex financial data associated with our road construction projects. - We need to focus on key financial metrics, including project costs, ROI, profit margins and forecasting future financial scenarios. Skills and Experience - Proficiency in Excel at an advanced level - Background in finance, ideally with a focus in project finance. - Experience in construction sector would be an advantage. - Ability to analyze and interpret complex financial data and present i...
I'm looking for an Excel expert to automate various tasks relating to our tracking system and create an intuitive dashboard. The tasks will involve automation of formula calculations and report generation, to streamline our data processing workflow, and reduce human error. Key tasks include: - Automate formula calculations: Efficiently automate intricate excel formula calculations. - Automatic report generation: Create a mechanism for generating immediate, error-free reports that highlight key aspects. - Dashboard creation: Design a user-friendly dashboard displaying information based on Automatic report Generation. The ideal freelancer for this job should have: - A deep understanding of Excel's advanced features; - Previous experience with automatio...
I am looking for a skilled developer to create a Telegram chatbot that can extract text from PDF, PPTX, and Text files and generate Multiple Choice Questions (MCQs) from the extracted content using AI. The generated MCQs should be automatically submitted to a Google Form. Key requirements: - Extract text from PDF, PPTX, and Text files. - Utilize AI to generate Multiple Choice Questions. - Directly submit the generated MCQs into a Google Form make quiz with score. All is using automation platform Skills and experience needed: - Proficiency in Telegram bot development. - Strong background in AI and Natural Language Processing. - Experience with extracting text from various file formats. - Understanding of Google Form API for automation.
Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet
I'm looking for a proficient developer with expertise in React.js and Node.js to ...and others. - Generate search parameters primarily based on keywords, plus an additional layer incorporating combination match words such as 'fraud', "charge" etc. - Develop an intelligent AI web scraping feature to extract text and info based on search results. - Consider additional features such as search parameters that can be controlled via data sources, sorting options and language filters. Ideal candidates must wield a strong proficiency in Node.js, React.js and be experienced in integrating search APIs and building AI-powered functionalities. Knowledge in working with data is essential. Creativity and an innovative mindset are appreciated as this project...
I need a Python expert who can quickly extract text data from JSON and pickle files and deliver it in a format that's convenient for me. The extracted data should be: - In a format that's easy for me to read and work with - Ready for further analysis or processing I prefer the work to be done as quickly as possible. Experience with data manipulation, file handling, and Python is a must.
...well-versed in the sidereal time system to create an Excel sheet that provides the planetary positions in Vedic Astrology of Sun, Moon, Mercury, Venus, Mars, Jupiter, Saturn, Rahu, and Ketu. The final deliverable should have the planetary positions presented in degrees, minutes, and seconds format and zodiac placement of planet and if the planet is retrograde or not. Successful applicants should provide examples of their past work in Vedic astrology, especially on planetary positioning. A detailed project proposal would also be well appreciated. Ideal skills and experience for the job include: - Programming skills of C, C++, Python or Java and a bit of Vedic astrology knowledge, particularly on planetary positions - Proficiency in Excel - Experience in presenting comp...
I have printed documents that need to be typed into an Excel sheet. The final spreadsheet must also be formatted according to specific requirements. Ideal Skills and Experience: - Proficiency in data entry with high accuracy - Strong understanding of Excel, including: - Use of formulas - Conditional formatting - Data sorting and filtering - Attention to detail to ensure accurate data entry and formatting
Set up a Monte Carlo Simulation model to optimize the reduction of fatalities at roadway work zones using Excel with a Monte Carlo simulation add-on. The objective is to reduce crashes involving fatalities. Variables can include work zone speed limit, work area length, duration of work being done, time of day work is done, traffic volumes, work signs/flaggers present, etc. Expert knowledge in Monte Carlo simulations and risk engineering modeling. Limited time available to create model. More information available upon request.
Develop financial modelling in excel spreadsheets based on information supplied. This may lead to a long-term ongoing assignment(s) depending on your skill level and capabilities
Looking to setup forms in SharePoint (365). The forms will be basic drop down and redial buttons. Answers will need to be collected in a Excel sheet. Approx. 150 forms need to be created to begin with in the next 6 weeks. Possibly ongoing creation, modification and management required.
I'm looking for a Python expert who can develop a script that can take an image URL as input and return the OCR text response. The purpose is to extract numbers with a minimum of 4 digits from images, using only Free OCR tools. The desired output should be a JSON object. The script must support the JPEG and PNG formats. It's unclear how many digits the numbers in the images could have, so the code should be robust enough to handle variable digit lengths. Experience in optical character recognition (OCR) and handling JSON objects are crucial for this project. Specific requirements: - Python coding experience - Knowledge in OCR - Proficiency in handling JPEG and PNG formats - Experience in managing JSON objects Please see the attached images for a better understanding o...
...with OOP (classes and lists) - Familiarity with JSON output format. Milestones: MS1: detect a single color checker board on a video (from first to last frame) extract coords positions of color checker board, and video position (frame+time) we will share you testing videos along with the timecodes there the color cards are to be expected per video 2 modes required (demo mode with showing the video and the detected area, and performance mode, which may skip that step) MS2 detect multiple color checker board on mulitple videos. Each video can have 0..n color cards MS3 extract angles of rotation of the checker board MS4: extract sharpnes / blurry factor of color card too to get the best frame(s) of the color card(s) Budget? will not be disclosed, place your bes...
I'm looking for an Excel expert to handle a set of 10 company accounts from 2014 to 2024. Key Responsibilities: - Data Entry and Organization: The successful freelancer will be responsible for ensuring that all company account data is correctly input into Excel. - Financial Analysis and Forecasting: I need someone with the ability to perform in-depth financial analysis and create accurate forecasts based on the data provided. - Data Visualization and Reporting: You should be able to create professional and easy-to-understand visualizations, graphs, and reports. - Audit and Dashboard: The final deliverables should include an audit of the accounts and a dashboard that provides a clear overview of the financial health of each company. The acco...
I'm in need of an experienced developer or programmer who can create a modified bar graph for me. The project will require: - The modified bar graph should have basic text labels on the vertical axis. - The design should be clean and professional, ensuring a good user experience. Ideal applicants should have: - Proven experience in creating bar graphs. - Excellent knowledge of the technology needed to implement such a graph. - Strong attention to detail to ensure the labels are correctly aligned and clearly legible.
I have a project that involves converting text from txt format into an Excel spreadsheet. Key Requirements: - I need someone who is meticulous and efficient at data entry. Your responsibilities: - Convert text from provided txt file into an Excel spreadsheet. - Ensure accuracy and maintain proper formatting. Ideal Skills: - Proficient in Excel. - Strong attention to detail. Sample is attached.
We are seeking a skilled web scraping expert to scrape html pages and convert them into a pdf file. The selected candidate will be responsible for creating a web scraper script that can automatically extract and organize data from various websites. The data should be neatly formatted into a pdf document for easy accessibility. The website is in which there are various links - section - 1, section - 2, etc. The text which is present when a link is opened is to be scraped. There may be an odd number as well, like section - 5A. Also, there are pages which will give more links/sections (there are upto 93 pages). When the section is opened, there may be footnotes. The text when the footnote is opened is to be scraped if possible.
I am in need of an expert in Excel to assist with data entry and organization. The work involves entering both numerical and textual data into Excel, and then organizing it by category. In addition, I require the use of data validation functions to ensure the accuracy and integrity of the data. Key Responsibilities: - Inputting both numerical and textual data into an Excel spreadsheet - Organizing the data by category - Implementing data validation to maintain data quality Ideal Skills: - Proficiency in Excel - Experience with data entry and organization - Familiarity with data validation functions - Strong attention to detail This project is ideal for someone who is meticulous, organized,...
As someone unfamiliar with the specific version of Microsoft excel I'm using, I am seeking a proficient freelancer in handling Excel Automation. To successfully take on this project, you need to demonstrate: 1. Proficiency in Data Entry, Calculation, Analysis and overall Data Manipulation using Excel. 2. Good knowledge across different versions of Excel, since I'm uncertain of the specific version I am currently using. 3. Responsiveness and good communication skills. While the turnaround time for the task isn't defined, I appreciate a quick and efficient service. However, quality should not be compromised. Experience in working across various Excel versions will be an added advantage. I look forward to receiving your bids.
...Managers up to 60 Projects). Output > Requirement 2 > Overarching Gantt Chart showing all projects to create an easy way for executives to see where projects are at in the stages and when the projects are expected to be complete. Requirement 3 & 4 will provide me with an overarching program/portolio view They should cater to a variety of project information, covering: Requirement 1 (Open to Excel or Word Formatting) Individual Project Reports should 1. Project Name and Brief Description, Project Manager/Lead Name 2. Project Stage and Project Type (i would like to choose from a selection/list ) 2. Status Indicators- Overall, Financial, Schedule, Risk and Issue 3. Risks and Issues Details 4. Critical Dependencies 5. Upcoming Milestones 6. Exceptions 7. Start, Fi...
I need a detail-oriented and focused individual who excels in manual data entry to convert data from my physical documents into a spreadsheet. Requirements include: - Transferring data from paper formats into a computer system - Strong typing speed and accuracy - Experience with MS Excel or similar spreadsheet software - Ability to maintain confidentiality when handling sensitive information. Accuracy is absolutely critical for this project, so keen attention to detail is a must. Previous experience with similar projects will be highly regarded.
...minimal viable product (MVP) for an extraction web application. Here's what I need: - Extract key performance indicators (KPIs) from specific tables in a database. - The tables to focus on are those related to Agrofood data, particularly those providing comprehensive details on KPIs. - The extracted data should be organized and prepped for the generation of action plans and export. Ideal Skills and Experience: - Extensive experience in database management and data extraction. - Knowledge of Agrofood data and related KPIs. - Capability to design an extendible MVP for further developments. - Proficiency in web application development. To be successful in this role, you need to produce accurate and useful data that will help steer strate...
I require the expertise of a Python developer to convert an excel file for automated task execution. The primary purpose of this project is to automate certain data manipulation tasks, specifically the application of formulas and calculations within the dataset. The chosen freelancer should demonstrate a proficient understanding of both Excel operations and Python programming in order to seamlessly translate the existing manual processes into an autonomous, error-free script. Your application should include any previous experience with similar data manipulation or automation tasks.
...website data that I need to consolidate into a single Excel spreadsheet for my project. The main goal is to have all the information in one place to ease the decision-making process. I'm looking for a freelancer who can help me with this project and provide ideas on how to make this work. Key Points: - The data is spread across a large PDF and a website, and I need it all extracted and combined into a single Excel spreadsheet. - I need product decision, finish, list price, cast Qty, Master Qty, weight, length, and similar details extracted from both sources. - The extracted data should be organized in the Excel spreadsheet with each data point in a separate column. Ideal Skills and Experience: - Proficiency in data extracti...
I'm seeking a meticulous freelancer to assist in Excel sheet data entry. The project involves analysis and entry of both text and numbers. Ideal Skills: - Proficiency in Excel - Excellent data entry skills - Strong analytical abilities Your application should include past work that demonstrates your experience with similar projects. The data entry task is more complex than simple copy-paste, so I'm particularly interested in freelancers who have experience with data analysis and entry.
Hi A bit of fun this one ! The English national football league is very close to an end. The 4 bottom sides will get relegated. That might include my beloved York city !! I want simulate how likely this is given my predictions of the probability of outcomes of the remaining games. The bbc website shows the table and the remaining fixtures. The only way it can happen is if the 3 sides lower than York all over take York. York and Woking only have one game left. Borehamwood and ebbsfleet have 2, one of which is against each other. Rankings are conventional. 3 pts fir a win 1 fir a draw, 0 fir defeat. If points totals are equal the different between goals scored and conceded is considered. If that is also equal - quite possible - total scored decides it. I can supply my judgem...
I am on the search for a professional who has proficiency in Excel. The main task of this project involves automating the process of conditional formatting in Excel based on cell content, which can help streamline and simplify my workflow. Skills and Experience Required: - Strong knowledge of Excel functionalities - Experience in automating conditional formatting - Ability to build scripts based on cell content Your expertise will help me ensure that my data is formatted accurately and consistently, saving me time and increasing efficiency. Please place your bid if you possess the necessary skills and experience, and we can discuss further details.
I'm seeking a meticulous freelancer to assist in Excel sheet data entry. The project involves analysis and entry of both text and numbers. Ideal Skills: - Proficiency in Excel - Excellent data entry skills - Strong analytical abilities Your application should include past work that demonstrates your experience with similar projects. The data entry task is more complex than simple copy-paste, so I'm particularly interested in freelancers who have experience with data analysis and entry.
...about digital products, the ability to creatively and effectively highlight said products is essential. Note: Selling of products is not a requirement for this project. This is purely an informational portal. However, experience in crafting e-commerce websites will be appreciated though, as it could offer valuable insights into how to best showcase products. If this sounds like a project you can excel in, I’d love to hear from you. Let's create an amazing digital platform together!...
**Project Description: Database Creation with GPT Assistance in Excel** **Overview:** The aim of this project is to leverage the capabilities of OpenAI's GPT (Generative Pre-trained Transformer) model to assist in the creation of a comprehensive database using Microsoft Excel. The database will serve as a centralized repository of structured information, facilitating efficient data management and analysis. **Objectives:** 1. Develop a structured database architecture suitable for the organization's requirements. 2. Utilize GPT to automate data entry, validation, and enhancement processes. 3. Ensure data integrity, accuracy, and consistency throughout the database. 4. Enable seamless data retrieval and reporting functionalities. 5. Facil...
...specific applications and tracks changes over time. System Administrators will use the script to identify current and historical versions of important software. The script would be executed locally as a scheduled task. Use Cases • User specifies applications for which to monitor version information • User schedules script to run at the desired interval • User analyzes report generated by script using Excel Inputs • The script should take a file with an application name to be tracked on each line • The script should require Administrator privileges Outputs • The script should output a CSV file in the $WINDIRTempSVT folder that contains the software version report • Each line in the software version report should include: o Computer Name o Soft...
Looking for a proficient photo editor to breathe vibrant life into some photographs. We're primarily focused on profound color correction and a creative replacement of the background. The specifics of the project include: - Color Correction: uplift the overall appearance and balance the tones. - Background Removal: extract the existing background deliberately without compromising the focus on the primary subject. Desired Skills: - High proficiency in Photoshop or similar photo editing software. - In-depth understanding of color theory and background editing. - Acute eye for detailing and aesthetic sense to choose the replacement images. - Ability to understand the project's style and adhere to it. Prior experience in similar photo editing tasks will be highly appreciate...
I am seeking an expert in data visualization to create a pivot chart that can accurately represent my organization’s financial data. The focus of this pivot chart will be on expense analysis. Key requirements: - Ability to categorize expenses by department, project, and type of expense - Clear knowledge of financial data manipulation - Proficiency in Excel or any similar data visualization tool Ideal Skills: - Strong background in data visualization, particularly pivot charts - Proficiency in financial data interpretation - Detail orientation to ensure all categories of expense are correctly entered and represented This project will help us understand our cost drivers better and make informed budgeting decisions. Freelancers wit...
I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.
I am looking for a skilled freelancer to assist me in organizing my Excel sheet data. The purpose of this organization is to pave the way for comprehensive statistical analysis. Key Responsibilities: - Organizing data in a user-friendly format - Ensuring that data is accurately inputted and maintained - Setting up the Excel sheet for further statistical analysis Ideal Skills and Experience: - Proficiency in Excel and data entry - Strong organizational skills - Understanding of statistical analysis - Previous experience with data organization for statistical purposes
need an expert in a multi-project task tracking Gant chart multi suppliers provide document control he must be an expert in MS excel and need to provide a solution for tracking ad document control by excel or another software he is an expert in it we can use later
I'm looking for a professional with advanced skills in data mining and excel to extract specific text information from a website into an excel spreadsheet. This job requires an understanding of website data scraping. The successful candidate should have: - Proven experience with Web Scraping. - Expert knowledge in Data mining and Excel. - The ability to handle large sets of information efficiently and effectively. - Accuracy and attention to detail. - Knowledge of and web scraping ethics. The task primarily involves text data mining, here are the specifics: - Extract exact information from a website. - The exact text data to be mined will be communicated to the successful candidate. This opportunity is ideal fo...
I am seeking an experienced Excel expert to create a functional timeline sheet. As the project specifics were not indicated, the freelancer must be capable of handling a wide range of tasks including but not limited to designing tasks description, start and end dates, and task dependencies. The sheet needs to be well-organized, potentially categorized by project phases or team members, or put in chronological order. This can be further discussed as the project progresses. It's crucial that the timeline offers a clearly visible trajectory of tasks, milestones, or a high-level overview of the project timeline. It will be helpful if the freelancer possesses: - Expertise in Excel - Strong attention to detail - Understanding of project management processes - Ability to wo...
