Vlookup data files työt
This is a one of project; I'm looking for an Excel expert to develop a workbook enabling data analysis of multiple bank and credit card statements. This workbook must have the ability to run multiple functions/reports - Implementation of SUM and COUNT functions. - Utilization of VLOOKUP or HLOOKUP. - Creation of Pivot Tables and informative Charts. The ideal candidate would be someone with prior experience in financial analysis or data engineering, who can ensure that the workbook provides the insights needed. Ability to ensure accuracy and relevancy within the formulas and functions is essential. Attached is a sample data file. This is a pdf to excel conversion. Prior to submission, the conversion data will be sanity checked and verified. If ...
I need an expert Django Python developer who is able to handle the sophisticated demands of my project. You're the perfect fit if you have advanced skills in backend API development and can handle up to 50,000 concurrent requests. Your main tasks will be: 1. PDF Report Generation: Build a feature to add PDF report generation using WeasyPrint. You should be able to create multiple PDF reports swiftly and efficiently. 2. Backend API Optimisation: Improve the existing API. It should efficiently handle high concurrent requests without lagging. 3. Email Support and Audit Logs: Implement a system that supports emails and maintains in-depth audit logs. These logs should record detailed send/receive information, errors, events, and user activities within the email system. Previous experien...
In need of a graphic designer to make the JPG file. We need 60 JPG images of same logo. Need it for Android boot up logo,(it will show at the time of startup instead of android). Attached 60 images we already have but those are in Vertical, however we need it in Horizontal. If you see the attached 60 images the shades changing towards dark at last pictures and each images has different rotating circle, Loading... Note: You can submit 2-3 images and after i award the project then you can send all the 60 images. Resolution 800 x 1280. Type JPG Need 60 images. i will decide the winner in 1 day. Attached: 60 images in Vertical (but we need Horizontal), now you can Example image just for ref of the look. ESPA LOGO AI editable format. Might work together in future.
...create QR code images from uploaded CSV files containing text data. Post scanning, these QR codes should display the text information incorporated while creating the codes. Furthermore, the software needs to house an Excel Workbook, which should be updated through manual uploads. The Workbook will be responsible for printing the necessary details derived from the CSV file. In addition, the software should also be engineered to retrieve cellular data upon scanning the QR code. Ideal Skills: - Proficiency in developing web-based software - Extensive knowledge in handling CSV files - Expertise in QR code generation and functionality - Experience in managing Excel Workbooks - Able to incorporate manual uploads - Experience with cellular data ...
I'm looking for a freelancer who can create a simple, yet effective, VBA macro to combine a set of between 10 to 50 small CSV files. These files all share the same column headers, and the macro should merge the data in these CSVs while maintaining the column sequence as provided. This task is straightforward and should not take much time for an experienced freelancer. A successful completion of this task will certainly result in a 10-star rating from me. See the uploaded document that details what needs to be done. I will provide the coder that I choose with several sample small csv files to combine.
I need a set of high-detail CAD files developed to support the prototyping of a product. These files will be used to create a prototype out of plastics. Key Requirements: - The CAD files should be highly detailed and encompass all functional and aesthetic features of the product. - The files should be compatible with the prototyping phase, and it's essential that the final result is in plastics. Ideal Skills and Experience: - Proficient in CAD software, with a significant background in creating detailed files suitable for prototyping. - Prior experience with plastic prototyping is highly preferred. - Strong understanding of the manufacturing process and the role of CAD files in prototype creation.
I'm looking for a freelancer to design and format a document for me. The document will be used for reviewing our company's procedures. The key requirements for this project: - The document should be a mix of both editable (in Word) and fixed (in PDF) content. - The design should be of medium detail, with some infographics and charts to make the content more visually engaging. - The focus should be on clarity and simplicity, making it easy to read and understand. I'm open to suggestions and creativity in enhancing the design, so any prior experience in document design, quality process review, or similar would be a plus. Skills: - Proficiency in document design - Experience with quality process review - Strong in visual content creation (infographics, charts) - Ability...
Deliver excel files like one sent for demo to Tarek.
I need an experienced C# programmer who can help create an indexing solution for large XML files, aimed specifically at improving search performance. Key tasks for this project will include: - Developing an indexing method for XML files - Ensuring the indexing solution offers quick and efficient data retrieval Please find the attached document for more specific details of the project. I will place a 50%/50% milestone payment, where 50% will be released once the Indexer / Index Reader has been demonstrated on the supplied 100GB file. I will then release the remaining 50% once the speed optimizations have been added to the code. As always, never ask for more money than your bid amount, the answer will always be no. Only bid what you are willing to do the job fo...
I am in need of a quality document to be created, targeted at our internal employees. The focus of this document is to design and develop new quality processes. These processes are of moderate complexity and require thorough documentation to ensure all necessary steps are captured. Ideal candidates for this project should possess the following skills and experience: - Proficiency in creating comprehensive quality documents. - Previous experience with process development and design. - Familiarity with Visio for process flow creation. - Ability to understand and work with moderately complex processes. - Strong communication skills to ensure the document is user-friendly and easily understood by internal stakeholders.
I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.
I have to download everyday +- 3000 invoices (PDF files) from a server to my computer. I already have this task semi-automated in an Excel macro, but I want to do it easier. I need a tool (also in Excel/VB/Macro) where: - I'll write the day, month and year - I'll write the first invoice number and last invoice number that I want your tool to search - I'll hit a button "START" and your tool will search and download to my computer every invoices from that range that were issued on that specific day from an specific URL. The URL for these files is a standard URL. It's always an URL like this: The only part that changes is day, month, year and invoice number. Example: if I want to download any available invoices between numbers 5000
We're dividing assets into fractions. We have .sol files related to smart contracts (ERC20 on Ethereum with a bridge on Gnosis). We're in search of an expert who can review these files and determine their functionality for deployment. Should this collaboration proceed smoothly, we're open to establishing a long-term partnership for technical support.
I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.
I want to make a browser-based epub/pdf/text viewer that supports annotations For the first step, I need a dev to make a nodejs script that can convert epubs, pdfs, and txt files to static html files. I want 1 file for each chapter. The script should produce a that links to all chapter files. If a file has no chapters, break the book into 4000 words chapters Also it should produce a table of contents .json file. The file lists all the chapter files. Link to a similar project in your bid if you have it. Thanks for bidding
I just need someone to open these files in 3ds max and save them as max2021, nothing else. I'll consider it a favor. Thanks in advance.
I'm in need of a professional who can create DXF files for laser cutting on acrylic material. The designs are focused on geometric patterns. Key requirements: - Creation of DXF files for laser cutting on acrylic material - Designing geometric patterns. Ideal skills and experience: - Proficient in CAD software, particularly in creating DXF files. - Previous experience in designing geometric patterns. - Understanding of material-specific design considerations for acrylic.
I'm in need of a skilled graphic designer with expertise in various design fields to help me create high-quality images for my upcoming project. This is an exciting opportunity to showcase your creativity and design skills.
I need all these files recreated so that they are print ready for a 3 feet tall x 5 feet wide banner Files must be high resolution so they can be printed on banners
I'm seeking an experienced freelancer to transform my physical logo design into a digital format - specifically, PDF. Key tasks include: - Scanning or recreating the paper logo - Ensuring the quality and integrity of the logo are maintained throughout the digitization process - Delivering the final product in PDF format Ideal Skills: - Graphic design - Experience with image editing software - Familiarity with logo design - Attention to detail Experience with digitizing physical artwork will be considered an advantage.
Need to import views, floor plans and cross sectons from Archicad 24 file. For some reason cannot get it in the program. Als oneedot save settings in the PLA file for a future use
...a qualified developer or data engineer to create a pipeline utilizing DBT and SQLITE. The goal is to process a multitude of json files housed in a particular folder. Please refer to the assignment document for detailed instructions Step 1. Initial Setup: ● Use DBT and SQLite to create a pipeline that processes files from a folder structure. You can access the folder here Step2: Adaptation for Continuous File Deliveries: ● Adjust the pipeline to handle continuous file deliveries, where new folders with JSON files are added over time. For example: Step 3: Data Quality Assurance: ● Create a suite of data checks to ensure the data is clean and add a DBT command to run these checks. ● Suggest additional information or metrics that could be ...
I'm seeking a skilled freelancer to create an AI solution that effectively removes text content from Word files. The primary goal is for the AI to reduce the score to zero, ensuring that none of the original text remains. A strong understanding of AI is key, along with experience in creating or manipulating Word files. Specific job requirements include: - Experience in text manipulation using AI - Familiarity with Microsoft Word files - Ability to effectively reduce text content to nil - Solutions-focused thinker who can anticipate potential challenges - Rigorous tester to ensure successful implementation - Strong communicator for collaborative workflow The end product should successfully remove all text content from a given Word file, bringing the AI score to z...
I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.
As the project owner, I am looking for a talented individual who can handle two crucial tasks in Excel: 1. Adding advanced functionality with IF, VLOOKUP, and INDEX MATCH formulas. 2. Implementing conditional formatting. To be successful in this project, you should have: • Proficiency in Excel's advanced functions and calculations • Experience with customizing Excel using conditional formatting • Attention to detail and the ability to execute tasks accurately. Your primary task will be to help me improve Excel's current functionality by implementing the advanced functions mentioned and customizing my Excel using conditional formatting. Your deep understanding of Excel will be crucial to successfully carrying out these tasks.
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.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
Our business has jumped from 500 files to 0ver one thousand. we have no idea how to stop misplacing files. We know we need more prepares to handle the flow.
Need an expert to help with this The Adobe Creative Cloud “conflicted copy” file problem has accelerated, and the studio (Robin, Jenna, Cameron (host) and Bill) have a lot of duplicate files. I think it’s duplicate inDesign files mostly. We are finding it too time consuming (and dangerous) to manually delete files, and direct support from Adobe has not solved the problem. It has taken a sudden sharp increase lately and we have no idea why. There was a theory that upgrading Jenna’s computer would solve the issue but it has not. We need to know how to test for solutions between our studio members. Unable to sync SEED Pre-trip Planning Guide because the file is locked. Please close this file in any open applications and ensure you have write...
I'm seeking a skilled transcriber to transform 15 audio interviews into written Word documents. Each session runs between 30 and 60 minutes. Key Requirements: - Deliver the transcriptions in Word document format - Include time stamps only for speaker changes - Capture non-verbal cues like significant pauses and emotions, and exclude all others Ideal Candidate: - Proficient transcriber with experience working on interview materials - Strong attention to detail to ensure accurate transcriptions - Ability to capture and interpret non-verbal cues effectively - Familiarity with delivering transcriptions in Word format Please provide a quote based on the volume of work and your experience in similar projects. Your bid should include the estimated time needed for completion and any releva...
I am looking for a skilled professional who can take a PDF file and convert it into a transparent .PNG file and an .AI file with 300 P...professional who can take a PDF file and convert it into a transparent .PNG file and an .AI file with 300 PSI resolution. These converted files will be used for printing purposes, so maintaining high quality throughout the conversion process is essential. Ideal Skills and Experience: - Proficient with file conversion tools and formats - Experience in creating print-ready files - Knowledge of image manipulation and vector graphics - Attention to detail and accuracy It is important that the final outputs are of high quality, particularly when printed. The original PDF file does not have specific dimensions that need to be maintained in the...
I'm looking for a skilled Python developer to combine around 1000 XLSX files into a single one. I need this new file to contain all the data from the original files. The Excel files have a structure where each file contains data for a different entity. The end goal is to have all this data centralized into a single document for easier management and analysis. The successful freelancer for this project should have: - Proficiency in Python, particularly in working with Excel files. - Experience in data manipulation and consolidation. - Strong attention to detail to ensure that all data is accurately captured and combined without loss. Please provide examples of your previous work in Python, particularly relating to da...
I need STL files for a decorative object displayer and its necessary supports. These should be simple in design, efficiently facilitating 3D printing. Here's what the project entails: - Ornament Displayer: This should accommodate a variety of decorative objects. - Supports: The design needs to be sturdy and practical, ensuring the displayer holds objects securely. - Style: A simple design preferred to facilitate easy 3D printing without compromising stability. Ideal skills for this job would be those with a solid experience in 3D modeling and understanding of 3D printing parameters. A keen eye for detail and great design skills would be a bonus.
I need an auditor or an Excel expert to help me with my tax report. The report contains 3600 transactions that need to be accurately calculated. Ideal Skills and Experience: - Proficient with Excel and complex calculations - Understanding of tax reporting - Attention to detail and accuracy
I'm seeking a proficient Mechanics Expert to divide assembly STP file into individual component's STP File. Key tasks this project will involve: - The creation of a dll and library. - Integration in...framework. - Enhancing current software performance. The principal feature of this STP File Analyzer must include: - An assembly structure analysis functionality that can effectively map the part-tree structure of an STP file. Ideal skills necessary for this project: - Proven experience in C#/C++ with a strong emphasis on dll and library building. - Understanding and hands-on experience with STP files and structure analysis. - Knowledge of software integration and performance enhancement. Please only bid on this project if you are confident in your abilities to meet the ou...
Hi, I need to migrate big WP site via SSH It is too big or I would have done it with a plugin myself. I've been using plugins for migrations on over 300 sites and it is NOT POSSIBLE WITH THIS SITE (I tried 7 different plugins and settings in 2 days) I have SSH creds ready for both servers
I'm currently working with two Excel sheets for inventory data. I need help with applying VLOOKUP functions to these sheets. I need the correct formula to lookup the Sheet 1 Column A data, in Sheet 2 Column B, and apply Sheet 2 Column B data in Sheet 1 Column B - please see attached. Key Requirements: - Understand and implement VLOOKUP formula to connect data between the two sheets. - Ensure the VLOOKUP function is working correctly and efficiently. Ideal Skills and Experience: - Proficiency in Excel functions, particularly VLOOKUP. - Prior experience working with Inventory data is a plus. - Attention to detail and accuracy in data manipulation. Please reach out if you're confident in your Excel skills ...
I'm looking for a skilled freelancer who can help in entering text data from PDF files and images. There are 60 rows of text, I need to add columns that contain the details from PDF files. This needs to be done now immediately. I will provide an example.
I'm seeking a proficient C#/C++ expert to build a dll and library with a specific purpose - to integrate into an STP File Analyzer. Key tasks this project will involve: - The creation of a dll and...framework. - Enhancing current software performance. The principal feature of this STP File Analyzer must include: - An assembly structure analysis functionality that can effectively map the part-tree structure of an STP file. Ideal skills necessary for this project: - Proven experience in C#/C++ with a strong emphasis on dll and library building. - Understanding and hands-on experience with STP files and structure analysis. - Knowledge of software integration and performance enhancement. Please only bid on this project if you are confident in your abilities to meet the outline...
I'm currently in need of an expert in Google Sheets proficient in utilizing the Vlookup formula to match and compare data between two columns in a simple table with rows and columns. Key Tasks: • Apply Vlookup to compare and match data • Simplify and present result in an understandable format • Assure accuracy of matched results Ideal skills and experience: • Proven experience with Google Sheets • Strong understanding of the Vlookup formula • Exceptional attention to detail • Ability to deliver accurate results promptly. Please present examples of similar work in Google Sheets applying the Vlookup formula.
As an immediate requirement, I need an expert in Excel who is well-versed with an array of formulas and functions. The key tasks required for this project are as follows: - The application of Vlookup and Hlookup, Logical functions (IF, AND, OR) and Arithmetic operations (SUM, AVERAGE, MIN, MAX) - Conducting Data analysis using Pivot tables and creating various scenarios in the Scenario Manager - Ability to work with multiple worksheets - Organising the spreadsheet using Grouping & Outlines and employing advanced Excel functions - The project also involves the creation and handling of intricate elements such as Worksheet Linking/Workbook features, the usage of Header and Footer and providing a touch of Creativity & Originality Structure-wise, the project involves a com...
We would like to automate the extraction, transformation and loading of health standard language 7 (HL7) files into a MySQL database hosted on a Microsoft Windows server. The files are sent to the Microsoft Windows server every 5 minutes and we have to load them and once processed move them to a different folder. I have attached our database structure and an example of the HL7 file (dummy) and MySQL database structure. Our HL7 file is for one patient and have one or more OBR per patient. You will have to install Mirth on our server and configure it to automatically process an HL7 file every 3rd minutes. Thank you!
I need someone to take a photo and make spec sheets and submittal sheets for all my projects.
This text file is too large for my pc to handle. You will open this text file, and then save it into 10 excel files and send the excel files to me. The data needs to all be in the correct format. Find the file here: (this is public data) Click 'Real Property Data' Then open the real_acct file. This is the file I need divided up and sent to me at 10 excel files. So each file will contain about 10% of the big file. All data needs to be captured. You will send me a test file with 100 rows of data to see if it is correct. Your bid is your bid. Do not bid and then ask me 'what my budget is?' Read the requirements and follow them. type 'sunshine' in your bid.
More details: What type of assistance do you need with your existing Tableau visualizations? Design improvement, Dashboard creation What specific design improvements do you want for your Tableau visualizations? Tableau Layouts using figma Which data sources will the visualizations be based on? Flat files Note : need improvements for my existing tableau dashboards
The project is an excel test. The attached file contains the test. It requires medium level skills. All the details are in the file More details: What specific calculations do you need to perform in Excel? Formulas to consider using - IF, VLOOKUP, SUMIF, SUMIFS, INDEX How familiar are you with using Excel formulas? Intermediate (comfortable with commonly used formulas) Which Excel features beyond basic formulas are you interested in incorporating? Pivot Tables, Conditional Formatting
I created an educational app which consists on SAT / ACT / TOEFL tests and I'm currently in the need of creating more tests for the app. I already started creating the tests, which consist of 5 questions and 4 possible answers each, and are stored in txt file format. I need a data entry person to help me enter that tests from the txt files into a "Test Loader" web form (that I've created myself). For the moment I'll create 50 tests (but I could add more later, maybe 100) , and your work will be mostly copy and paste, so it's very easy, but your work will be divided into two parts, entering and checking. You will have to install my app and once you have created a new test you will immediately have to open the app and load that test to ensure ...
Hello I do sales for a tobacco company and I need to enter all my sales for January February March. I need three different Excel files. All it is is the name of the store the amount that I sold and the address.
I am seeking a knowledgeable expert in Azure files, AVD and Azure Active Directory to help me overcome specific challenges. These obstacles include accurate licensing cost calculations and guiding in configuring this service to work effectively within my project. As the ideal consultant for this task, you should: - Have significant experience with Azure Active Directory configurations. Evidence of previous projects in this area will bolster your application considerably. - Demonstrate a keen understanding of software licensing costs and pricing structures related to Azure services. - Be an experienced troubleshooter, capable of identifying and rectifying issues promptly and efficiently. In your application, please focus primarily on your past work - particularly projects involvi...
