Reformat excel spreadsheet database format Jobs
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be ...
...answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of columns for answers may vary depending on the format of the exa...
Follow directions in video. Maidstone and Unity - Janessa and Kenzie Turtleford/Shellbrook/North Battleford - Juan David and Eduardo Meadow Lake - Cody/Tristan
I have a logo that I'd like to enhance for my company's headed paper. I'm specifically looking for a professional touch and the improvement of its color palette. Key Requirements: - Professional Color Enhancement: The logo should be improved to look more polished and suitable for professional documents. - File Format: The final version of the logo should be in PNG format. Ideal Freelancer: - Graphic Design Experience: A background in graphic design is essential to understand color theory and the professional enhancement of logos. - Attention to Detail: The chosen freelancer should be able to make subtle, yet impactful changes to the color scheme to elevate the logo's professional appearance.
I need an experienced graphic designer to replace the current headshot on my business card with four new headshots. All images will be provided in JPEG format. Key Requirements: - Replace existing headshot with 4 new images (4 separate business cards) - Ensure seamless integration of new images into the current design - Be able to work with JPEG format - No text changes are required, only the headshot needs updating Ideal Skills: - Graphic design experience - Proficiency with image editing tools - Attention to detail and accuracy - Strong understanding of file formats, especially JPEG I will provide all necessary files for the project. Please let me know your experience with similar tasks and your estimated turnaround time.
I have a PowerPoint presentation that I would like to convert into a video. The purpose of this is to put it into website and use for promotional purposes. The output format for the video needs to be MP4. Additionally, I'm looking to enhance the video by having a professional voice-over added. The voice-over should be clear, engaging, and professional. You can use Ai voice over Ideal skills and experience for this job: - Proficiency in PowerPoint and video editing software. - Experience in creating engaging voice-overs. - Ability to deliver high-quality, professional work. - Prior experience in creating videos for social media and promotional purposes would be a plus.
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
We are academic researchers interested studying visit patterns to Museums, Aquariums, and Zoos, in the United States. We are seeking assistance in collecting reported visit counts for the year 2019 from 500 museums, 100 zoos, and 100 aquariums across the United States. We will send you an excel spreadsheet with the name and state of each location we would like visits counts for. Note that these ~700 locations have been pre-selected. **NOTE: THIS PROJECT MUST BE COMPLETED BY HAND - NO WEBSCRAPING** Task: - Search the internet for reported visits to each location in 2019 - If you can find the number of visits, please enter that number in the "visits" column AND paste the link to the website / source from which you obtained that number in the "link" ...
...include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share with you upon commencement of the project. 2. Car Make & Model List: - The second spreadsheet requires the creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able to undertake data entry tasks with accuracy and speed. Experience with Excel data manipulatio...
I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.
I have a list of contacts in an excel file, and I need someone to find their email addresses. - The main task will be to locate and verify the email addresses of these contacts. It is crucial that the emails provided are accurate. - The purpose of this exercise is for personalized outreach to these individuals and not for mass email marketing or research purposes. The ideal freelancer for this job is someone with excellent research skills, an ability to meticulously verify information, and experience in email marketing or personalized outreach. A high level of proficiency with Excel is also required. Files: There are lots of entries that need to be completed. you will need to add the email address of
We are looking for a highly skilled Technical Support Specialist to join our team remotely. As a Technical Support Specialist, you will be responsible for providing excellent customer service and technical assistance to our clients. Your main duties will include troubleshooting hardware and software issues, managing device configurations, and providing account support. To excel in this role, you should have a strong technical background, excellent problem-solving skills, and the ability to communicate effectively with customers. Skills required: - Technical troubleshooting - Device management - Account support - Customer service - Communication skills
I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all the data is ente...
I am looking for an expert who can convert PDF files into Word files. They need to be compatible with both .doc and .docx formats. The converted Word files must match the exact format as the PDF including any images, charts, tables, or special characters present. Key skills and aptitudes for this job include: - Expertise in Microsoft Word - Strong attention to detail - Ability to accurately reproduce formats, images, charts, tables, and special characters - Familiarity with both .doc and .docx formats. Your main task will be to efficiently and accurately convert the files, preserving the format, images, charts and so on, to be exactly as they are in the PDF files. Please provide evidence of your past work in this field with your bid.
I am looking for a skilled Alteryx expert who can take on a project involving data blending from complex Excel spreadsheets. The project specifically involves: - Utilizing Alteryx for blending data from multiple sheets in Excel - Handling complex data structures within the Excel spreadsheets, including nested tables and formulas. Ideal candidates will have: - Proven experience with Alteryx, particularly in handling data blending tasks - Strong understanding of complex data structures, like those found in nested tables and formulas in Excel This project requires a high level of attention to detail and proficiency in data manipulation, so please only apply if you have the necessary expertise.
I am urgently seeking an experienced typist to help prepare a large Word document. Key details include: - The job involves over 100 pages that need typing. - The document is in Word format. - Turnaround time was not specified, but quicker turnaround times will be preferred. Ideal freelancers for this opportunity should have: - Speedy typing skills and high accuracy. - Proficiency and experience in Microsoft Word. - Availability to start working immediately, and dedicate a substantial amount of time to the project. - Strong attention to detail to minimize errors. This is an important job, so experienced typists only, please. Thank you for understanding.
I'm looking for someone to convert a PDF site layout drawing into a DWG drawing with some modifications. The ideal candidate should have experience with CAD software. Key tasks include: - Converting a PDF to DWG format - Changing the name shown at the top - Adjusting dimensions as needed - Adding or removing features as necessary The DWG drawing will be used for site layout purposes, so it's crucial that the final output remains entirely accurate to the PDF. The dimensions and scale should match those provided in the original document. Ideal skills and experience include: - Proficiency in CAD software - Experience working with PDF and DWG files - Attention to detail, especially in maintaining accuracy of the original drawing - Ability to communicate effectively to clari...
I have a series of Malayalam entertainment audio files that need to be transcribed into SRT format. The project requires detailed timestamps at every speaker change. Ideal Skills and Experience: - Proficiency in Malayalam language - Experience in transcription work - Familiarity with SRT format - Ability to provide detailed timestamps - Attention to detail and accuracy - Timely delivery of transcribed files Please let me know if you're able to take on this project.
I am in need of someone skilled in survey designs to create four separate variations of an existing survey. - The base survey: You'll be working from an already designed survey, Version A. - Required format: These should be online versions to ensure ease of data collection and interpretation. - Unique aspect: Each version needs to have different instructions. The ideal freelancer should have proficiency in designing online surveys and an understanding of survey methodology. Your task will be to create unique and clear instructions for each survey version while keeping the questions identical. It is crucial to ensure data is kept separate for each version for individual analysis. Any experience in social or market research or a similar field will be a great advanta...
...state objectively and develop clear solution requirements through influence, facilitation, and communication. The individual will gain an understanding of the customers, identify business problems that need to be solved, and document the current state drivers of those problems. The individual will need to map process flows, capture data requirements, create user stories, and document findings in a format understandable to all stakeholders. The Functional Business Analyst 2- RTB will serve as a liaison among IT, business partners, product owners, architects, data analysts, quality assurance analysts, project managers, executives, and software vendors in the evaluation, design, development, and implementation of solutions. The individual must be able to adapt their messaging to the...
I'm in need of an experienced legal professional to draft a complaint for a speedy trial violation. This complaint will be filed in a Federal court, thus requires a strong understanding of Federal laws and legal writing. Key Requirements: - The complaint should be in a hybrid format, encompassing both a narrative style and legal arguments. - It is imperative that this complaint includes references to specific federal statutes and case law. - The candidate should have a demonstrated and proven track record in legal writing and an understanding of the complexities involved in such complaints. Ideal Candidate: - A qualified lawyer with experience in Federal court cases. - Proficient in legal research and drafting complaints. - Familiar with the procedural aspects of a speedy t...
...goal is to automate daily updates of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your approach to automating da...
...compiling a comprehensive spreadsheet featuring specific MLB data. Essential parts of this data include game statistics, player performance, and team standings. The spreadsheet should be organized in a user-friendly way as mentioned below: 1. Date Range: The spreadsheet must cover a specified date range, which I'll provide upon hiring. 2. Included Players/Teams: The spreadsheet should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on which pitcher is better, and predictions on which team will win. The ideal candidate will have a strong backgroun...
I need a freelancer proficient with both Excel and Photoshop for two primary tasks. Excel Work: - Conduct data analysis and create visualizations, leveraging skills in updating and organizing data Photoshop Work: - Provide graphic design and photo editing services Ideal candidate should have solid experience in both platforms and a keen eye for details. Understanding my needs in data management and visual design will be a key success factor.
...professional who can smoothly transition my old database into the new one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MySQL, data merging, and database...
I am looking for someone to transcribe an interview spoken in Mongolian into English. The final file will need to be a properly timestamped .srt that can be input into video editing software. You must be fluent in both languages and know how to properly format a .srt file with precise timing. I have provided a short clip of the interview to help you gauge your ability to understand the language. I will ask you to provide a sample of your work using this clip to be considered for the project. The full interview is 1 hour and 13 minutes long. The audio clarity is mostly good, although a few parts may be challenging to interpret. Throughout the interview, there are many pauses where a rough, verbal translation is given. You do not need to include any transcription during these porti...
I am seeking a detail-oriented freelancer with demonstrable experience in data collection to gather texts, images, numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in precisely what data I need to be gathered. The free...instructions, which will include 1 to 5 photographs, will guide you in precisely what data I need to be gathered. The freelancer will be expected to: * Carefully collect the specified data from the website * Ensure all text, images, numbers, and table-based data are meticulously compiled * Consolidate all the collected data into a neat Excel spreadsheet Your experience in data collection should be highlighted in your application. Experience in using Excel for data organization ...
I'm in need of a graphic designer to create a professional, monochrome logo for my company. Key project responsibilities are: - Incorporating the company name into the design - Creating a design that conveys a sense of professionalism - Delivering the final design in a m...scheme The ideal freelancer for this project would have: - Proven experience in graphic design, particularly logo design - A keen eye for aesthetics and detail - A portfolio displaying a knack for professional, monochrome designs - Excellent communication and interpretation skills to grasp and deliver on specific project needs. Your deliverables will include the final logo in high-resolution format and source files. Your creativity and expertise will be critical in helping establish my brand's...
...access. This could include live walkthroughs of the apartments, guest interviews, or behind-the-scenes looks at the area. We have moe than 3,000 photos from the apts recently taken which we will make available for the job. Key Requirements: - Develop a modern and minimalist visual style for the posts - Create engaging content that will resonate with young adults - Utilize Canva to design and format each post in a way that is visually appealing and consistent with the established style Ideal Skills and Experience: - Proficiency in Canva and graphic design tools - Understanding of social media engagement strategies - Experience in creating content for young adult audiences - Strong portfolio of modern and minimalist design The successful freelancer will help me establish a con...
Bitte melde dich an oder Loge dich ein um Details zu sehen.
We need a Logo for our product brand "THUMB INDEX" which is created for E-Commerce Online Shopping. We recommend the Logo Context is that the Thumb & Index finger holding right tick. I have attached a sample logo for your reference. Also recommend placement of Logo in between the brand name " THUMB INDEX" . (EX: THUMB (Logo) INDEX) Need Source fi...Context is that the Thumb & Index finger holding right tick. I have attached a sample logo for your reference. Also recommend placement of Logo in between the brand name " THUMB INDEX" . (EX: THUMB (Logo) INDEX) Need Source file with all the FONTS & ELEMENTS. Please share the logo with 3 different colors like one in WHITE , One in Black and One in our recommended Color Combination in the PNG ...
hello everyone we have a CRM which allows us to manage our customers, a CRM entirely coded by us in html php and javascript. we have started to integrate a function which allows us to insert customers into our CRM using an excel file, but I don't have the time to finish that. It must be ready before the end of the day, today! mandatory deadline. if we are satisfied we will entrust you with many other missions on this brand new CRM
I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.
I'm looking for someone with Google App Script expertise to help me automate tasks ...Generating Reports from Google Sheets Data: - The script should be able to pull specific data from my Google Sheets and generate reports automatically. 2. Sending Automated Emails based on Conditions: - I need the script to send out emails based on specific conditions. For example, if a certain cell in a Google Sheet reaches a certain value, an email should be triggered. 3. Updating Spreadsheet Data based on Email Responses: - The script should be able to read emails and update the corresponding Google Sheet based on the content of the email. Please provide examples of similar projects you have worked on in the past. I'd love to see how you've approached similar automatio...
Summary The requirement is to complete an existing Google Sheets spreadsheet with formula that automates the creation of search URL's for popular car sales websites. The websites are Autotrader, eBay, Gumtree and Facebook Marketplace. The URL's show vehicle prices which meet defined criteria. For example, the search criteria could be Fiat 500, 2012 model year, petrol, year of manufacture 2012, search radius of within 50 miles of the postcode G11EB. The core requirement is to make it quick and easy to get vehicle prices from Autotrader, eBay, Gumtree and Facebook Marketplace. Without a tool such as this a manual search would have to be performed on each website which is much more time consuming. Examples Here are sample links showing search results for criteria si...
As a vendor, I have three excel sheets containing product numbers and corresponding data. Both sheets are error-free and completely filled in, but the second sheet has its entries in a mixed order. I need a freelancer who is adept in working with Excel to match the data in the sheets based on product I.D number using the product numbers and or product name (TRS Direct Sheet) to match the size dimensions in the other sheets as highlighted via colored columns (must match colors) Sheet format cannot be moved or changed or altered in the cells already published on the 2 sheets as listed only the DATA MASTA it effects the upload process. area highlight pink no information or changes to be made or added please scroll through to observe existing pink cells. Here's a det...
...relational database design. The primary goal is to deepen my understanding and skills in E-R modeling, functional dependency theories, and database norms, particularly: * Identifying entities and relationships * Applying E-R modeling and normal forms for a well-designed relational database. The chosen candidate should be proficient in the aforementioned areas, plus have the capability to clarify how to use these skills to identify performance issues, validate data integrity, and evaluate scalability. The project scope encompasses E-R modeling, identifying entities and relationships, and applying normal forms. Ideal Skills: * Advanced knowledge in RDBMS * Proficiency in E-R modeling * Understanding of functional dependency theories * Experience in applying normal...
I'm in need of an adept hydraulic or fluids engineer to create a PVC pipe gold trap tailored specifically for high water flow. Key components for this project would be: - Efficiency: The design should excel in gold particle collection, regardless of particle size - from less than 0.5mm to 2mm. - Adaptability: The trap will be utilized in a sandy soil environment. - Durability: The trap should possess a high erosion resistance to exceed in everyday wear and tear in mining operations. Your expertise in fluid mechanics, material selection and applying scientific principles to practical application would make you an excellent fit for the task. An understanding of the gold mining process would be a plus but isn't necessary. I'm looking forward to discussing your ideas an...
I am in need of a website primarily meant to provide valuable information with a professional tone, catering specifically to industry professionals. The website must include key functionalities such as: - Invoke trust and credibility among the specific professional community. - Efficient contact forms ensuring easy communication with our team. Ideal freelancers would possess: - Extensiv...Efficient contact forms ensuring easy communication with our team. Ideal freelancers would possess: - Extensive experience in web design, specifically with websites targeting industry professionals. - Knowledge on incorporating interactive and efficient contact forms within the site's structure. - A solid understanding of developing sites that provide a wealth of information in an easy-to-navigate...
I am seeking a PHP developer who is experienced in frontend development, and an expert in PHP frameworks and MySQL database integration. The focal point of the project is database management. • Main responsibility of the PHP developer will be to build new databases, thus experience in this is essential. • A background working with PHP frameworks and MySQL is crucial for success in this role. • The role also entails some front-end development tasks. Successful applicants will illustrate these skills throughout their portfolio in relation to past projects. If you are a self-starter with a penchant for database management, I look forward to receiving your bid.
I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.
Based on the attached files, create a Subway-map-style of Walt Disney world Transportation. Use the file "map full" as reference but only use the lines mentioned in the file "edited". Use the colors from the file "colors". file needs to be delievered in a editable vector format. Auto-applications will be declined.
Hello Ritziov, I hope you are doing well. I have a new job for you if you are interested. The job is to change the "Huts" in "HappyHuts" to "Tots" for me? New logo name should say "HappyTots" and still use the tent shape as an A. I need it in the file format of JPEG, PNG, SVG, PDF and AI. All Versions please, with the circle surrounding it, square surrounding it, and plain. All Versions with ™ and ® and no symbol. Looking forward to hearing from you! Best, Øystein
I have a series of PDF files in English that need to be converted to Word format. The PDFs are relatively simple in terms of formatting, requiring straightforward text translation. Ideal Candidates: - Proficient in English for accurate conversion - Experience with PDF to Word type conversions - Detail-oriented to ensure no content is missed Please note that no images are present in these PDFs, so the task is limited to text conversion.
I have a series of PDF files in English that need to be converted to Word format. The PDFs are relatively simple in terms of formatting, requiring straightforward text translation. Ideal Candidates: - Proficient in English for accurate conversion - Experience with PDF to Word type conversions - Detail-oriented to ensure no content is missed Please note that no images are present in these PDFs, so the task is limited to text conversion.
As your client, I'm looking for a specialist having a proficient knowledge of Microsoft Excel to achieve a simple data manipulation project. The task involves predictive analysis of data, heavily leveraging date and time functions. Key Responsibilities: - Manipulating data using simple Excel functions. - Predictive analysis using Excel based on the manipulated data. Ideal Candidate: - Sufficient proficiency in Microsoft Excel, with specialised expertise in date and time functions. - Strong attention to detail and accuracy in data entry and analysis. - Superior skills in organising and ability to handle increasing complexity when required.
I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.
