Excel extract combine data jobs
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.
I want you create similar logo , to the attached one . More modern and clean Design: Combine the runes Fehu and Sowilo in a stylized lighthouse design. could be designed so that the structure itself takes the shape of the Fehu rune, while the light of the lhouse represents the Sowilo rune. • Colors: Use blue and gray tones for the lighthouse to symbolize professionalism and trust, with a bold yellow or gold for the light, radiating warmth and success. • Font: Choose a modern, clear font for the company name, placed below or beside the company
...proficient script writer to extract specific business data from an online directory, specifically Myagedcare.gov.au. This project will need a freelancer that possesses: • Significant knowledge and experience in data scraping technology • An understanding of the structure and functioning of online directories • Keen attention to detail The successful freelancer will carry out: 1. Extraction of business data: I require accurate extraction of contact details and business names from businesses listed on the directory. 2. Specific Directory Focus: The targeted directory for this exercise is Myagedcare.gov.au. The end goal is to create a clean and organized database of businesses in the aged care sector. Prior experience with online directori...
I'm in need of an expert who can efficiently extract text data from about 160 unstructured PDFs and enter it into a database. Key Responsibilities: - Extracting unstructured text data from PDF files - Accurately entering this data into a database Ideal Skills: - Proficiency in data entry - Experience handling unstructured data - Attention to detail The work will require a computer, a stable internet connection, and the ability to commit to accurate and efficient data entry. Experience with unstructured data is highly preferred.
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and...
...- Valuation: A comprehensive evaluation of the company's worth. - Business summary: A concise overview of the company's operations and key strengths. - Risks: Identification and analysis of potential risks the company faces. - Industry analysis: Understanding the company's position and performance in the context of its industry. - Reach format report with 10k words, charts and infographics. - Excel modeling and native file is part of the deliverable. Ideal candidate would have: - Proven track record in financial analysis - Strong understanding of financial principles and methodologies - Previous experience in company valuation - Ability to present findings in a clear, concise and actionable format - Attention to detail and high analytical skills Please provide ...
I'm looking for a skilled professional to automate the task of entering data from specific Outlook emails into a structured format. The ideal candidate will have experience in: - Automating data entry tasks, and particularly from emails. - Working with Outlook's API or related tools. - Developing scripts or software to extract and categorize email content based on specific criteria. Key requirements include: - Extracting and processing data from emails based on criteria like sender's identity and keywords. - Ensuring the data is accurately transcribed and structured according to a predefined format. - Ensuring the process runs smoothly and efficiently, with the ability to handle a large volume of emails. - Providing a user-friendly soluti...
...scan the website/document for relevant data, and then interact with an AI model to retrieve information from the scanned website. The application will also include a chatbot feature that can be easily integrated into other websites as a microservice. Additionally, the application will support payment methods for premium features. Requirements: Website / Document Scanning Functionality: * Users should be able to input any website URL or document into the application. * The application should scan the website and extract relevant data for processing. * Extracted data should be stored in a database for future reference. AI Model Integration: * The application should integrate with an AI model capable of answering questions based on the scanned website data...
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behind in My expectat...
The individual report (~4000 words) carrier's 40% weighting in the Transportation Studies module and will be assessed by an individual report submitted via canvas. In your report you would need to include the experimental and the model results of your selected noise barriers. You will be judged on how you have been innovative in your conceive, design and how you improved the performance rating of your noise barrier. Assessment Criteria 1) Conceive (research noise barriers) = weight age (10%) 2) Project 1: Performance of reflective/absorbing noise barriers = weight age (40%) 3) Project 2: Traffic noise mapping = weight age (40%) 4) Modelling of noise barrier = weight age (10%) Project Details: Project Description: We are seeking a skilled freelancer to assist with a project that ...
I need a professional web scraping expert to scrape information from medical service providers directories that are publically available from the providers' websites. Requirements: - Extract data including name, address, phone, and location from the directories - Ensure the information is accurate and up-to-date I'm looking for a freelancer who: - Has extensive experience in web scraping - Can deliver high-quality results quickly - Has excellent attention to detail The project is urgent so I require someone who can work on it immediately and complete it as soon as possible.
1 have 1500 company names and i want to find their related instagram accounts. Key Responsibilities: - Conduct market research on Instagram to extract relevant data Ideal Candidate: attentive to details Location: Dubai Data collection: google sheets
...individual components within the diptube assembly. This will help visualize how everything fits together and identify any potential issues with spacing or accessibility. Mechanical Drawings: Produce detailed drawings of each component, highlighting dimensions, tolerances, and material specifications. These drawings will serve as the basis for creating the 3D model in AutoCAD. Assembly Drawings: Combine the individual component drawings into assembly drawings that show how they come together to form the complete diptube structure. Prototype Blueprints: Translate the design into preliminary blueprints using AutoCAD. These blueprints should provide a clear representation of the diptube design, including all necessary views (e.g., top, side, front) and dimensions. Annotations: In...
...looking for an expert who can integrate data from three platforms into my Laravel PHP ERP system. These platforms include Xero, and Sage accounting. Given these specific platforms, a freelancer with experience in working with them would be ideal. Additionally, PHP Laravel framework familiarity is essential. Requirements include: - Real-time synchronization: All data updated in any of these accounting software should reflect on my ERP system instantly. - Automatic data updates: An ability to schedule regular automated updates. - Custom Reporting: Tailored reports based on the data received from the platforms. - Error handling and Data Validation: Ensuring data is validated with robust error handling procedures. Given that I skipped indicating t...
...skilled professional who can help me scrape text data from e-commerce sites for data analysis. Key Requirements: - Data Scraping: The primary task is to extract text data from various e-commerce websites. This includes product descriptions, reviews, and any other relevant textual information. - Data Cleaning: Ensure the scraped data is accurate, clean and ready for analysis. - Data Analysis: This project is focused on data analysis, so experience in this area is a must. The ability to extract meaningful insights and trends from the scraped text data is crucial. Ideal Skills and Experience: - Proficiency in Web Scraping: A strong background in web scraping and working with text data is essential. - D...
We're seeking a talented 3D artist capable of producing captivating photorealistic renders and videos for a range of products. The ideal candidate must excel in rendering techniques, possess meticulous attention to detail, and have the ability to breathe life into products through stunning visual representations. Responsibilities: Create photorealistic 3D models of products. Develop high-quality textures and materials. Render product images and videos using industry-standard software. Collaborate closely with the creative team to ensure alignment with brand guidelines. Optimize renders and videos for various platforms. Requirements: Demonstrated expertise in 3D rendering, modeling, texturing, and lighting. Proficiency in industry-standard 3D software. A strong portfolio sho...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and dat...
I am in need of an experienced electronics technician with a thorough understanding and hands-on experience with scientific measurement equipment. Specifically, I require a professional who can: • Revamp the current configuration for improved compatibility. • Extract maximum functionality from existing resources. Key skills and experience: • Expertise in equipment modification. • Proficient in mechatronics (electronics, electrical and mechanical). Skills that are a plus: • Software programming. • Reverse engineering. • Pneumatics. • Drawing using CAD. We encourage under-grad students from UH, Rice, etc., to apply as an Intern. Requirements: • Must work at East End (near Second Ward) area in Houston. The project timeline is immediat...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are conf...
I'm looking for a proficient Python developer to create a script that can ef...proficient Python developer to create a script that can efficiently scrape active IPs from a text file I will provide. The following specifics are required in this project: - The Skill-set: Strong Python programming skills, experience in IP scraping and working with text files would be an advantage. - Task Details: You need to extract the 'Activity Data' from these IPs. Profound knowledge in network protocols is a must-have. - Output Handling: The activity data extracted should directly be written to a text file. A clear understanding of FileIO operations in Python would be crucial. A successful completion of this project might lead to more future collaborations. I'...
As someone needing assistance with managing data in an Excel sheet, my ideal freelancer would be highly proficient in Excel and able to work accurately and efficiently. The role includes: - Adding new entries to the Excel sheet including the fields: Name, Email, and Phone number - Updating existing entries with the same data fields - Removing any outdated entries The data should be organized into separate columns for each field for straightforward visibility and access. Besides Excel work, this role involves effective email management related to this data. The ability to multitask while maintaining a sharp eye for detail will be vital for this project. Experience in data management and email handling will be advantageous.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex ...
I need a skilled designer to create a versatile logo for my brand, which should combine text with a visually appealing icon. Additionally, I require a minimalist style website, with an included blog section. Key Requirements: - Create a unique and versatile logo design - Design a minimalist style website - Implement a user-friendly blog section -Develop visuals and generate content for social platforms, while overseeing marketing initiatives and trials. Ideal Skills: - Proficient in logo and web design - Experienced in creating minimalist aesthetics - Familiarity with user-friendly blog integration - Strong portfolio demonstrating past logo and website projects, particularly those with a minimalist style. - Strong proficiency in content writing and Social media management. Plea...
I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the new budg...
I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've wor...
I'm looking for a talented video editor who can enhance my YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency in creativity and storytelling,...not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation and excel in video editing, this could be an exciting o...
Research Assistant for a Research Project Project Duration: [ 3 months] Overview: We are seeking a highly skilled and motivated Research Assistant to support a significant research project led by a University. The ideal candidate will possess a strong background in financial databases, data analysis, and academic research, with proven expertise in using Stata for data organization and analysis. Responsibilities: ï‚·Download and extract data from financial databases and annual reports as well as others as required. ï‚·Efficiently merge and manage datasets from multiple sources to ensure consistency and accuracy. ï‚·Conduct thorough literature reviews in finance and related fields to support research objectives. ï‚·Utilize Stata to analyze complex datasets, perform econom...
I'm looking for an experienced data scraper who can extract text data from marketing websites for subsequent data analysis.
I have a few wedding videos that I'd like to combine and edit professionally. In particular, I'm looking for someone who can add modern, animated titles to the footage. Key Requirements: - Edit and combine multiple wedding videos into one cohesive video - Add modern, animated titles that match the wedding theme - Enhance the overall visual appeal of the videos Ideal Skills and Experience: - Proven experience in video editing, especially wedding videos - Proficiency in using tools for adding animated titles - Ability to work with a modern design aesthetic - Strong attention to detail for a polished final product If you have a portfolio or previous work in similar projects, please share them - it would be greatly helpful.
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.
I am searching for a dedicated WordPress developer to step in and complete my partially finished website. The task involves several tweaks, ensuring a fresh, and easy-to-navigate user experience. Roles involve: - Website Layout Adjustments: I need someone capable of rearranging elements on the site and i...coordination. - Add Additional Functionalities: Your input on how we could boost user interaction through new functionalities will be highly appreciated. Please, only individuals with proven WordPress experience and a portfolio showcasing previous design work should bid. Also, be prepared to review the current website and provide a brief strategy on your approach. The finalized site should combine aesthetics with seamless functionality. Let's collaborate to bring this ...
For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized d...
I need a professional to scrape specific details from a ...scrape specific details from a website directory for a one-time project. - Specifics: The data of interest includes the company names, their URLs, and their expertise. This information is laid out in rows on the website. - I wish for the freelancer to carefully extract this data, ensuring no errors or omissions are made. - The final output is essential to be in a CSV file format. I require this scraping to be done just once, and I do not foresee a need for ongoing scraping after this initial task. As the data is crucial for my business development, I am seeking someone who can deliver accurate and complete results in a timely fashion. Prior experience with web scraping and proficiency in dat...
I'm looking to create a 5-minute video presentation for my personal project. I already have some initial parts of the video, which I will provide, and I'd like you to extract the contents from a very detailed website and mockup graphics. Key Requirements: - The video should follow a specific style of presentation (details will be provided). - The final video should be around 5 minutes long. - Some parts of the video are already completed and will be shared with you to integrate with the new materials. Target Audience: I will share detailed information about the target audience via messages. Ideal Freelancer: - Experience in creating engaging presentations - Proficiency in video editing and animation - Ability to work with mockup graphics
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and ...
...central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP servers and familiar with Filezilla - Experience with network security and data ...
...Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits. Developer has t...
...professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistic...
I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.
I need a data scraping tool to pull business names and addresses from Google and Google Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques. - Experience working with Google and Google Maps APIs. - Ability to organize and structure data effectively. - Data to be compiled in an excel spreadsheet - Prior knowledge of extracting business information from online sources is a plus. Looking forward to your proposals.
