If statement with vlookup and hlookup jobs

I'm seeking qualified expertise for dealing with auto electrical systems specific to AHS trucks. Responsibilities: • Diagnosis and repair of system problems • Installation of new components • Upgrading the existing electrical system The ideal freelancer will have extensive experience in auto electrical systems, particularly as applied to trucks. Familiarity with advanced diagnostic tools and equipment is a must-have. Please, share your similar past projects, skills, and applicable qualifications.

...is to create a compelling capability statement that showcases my longstanding and substantial experience in the AHS & auto electrical sector targeting large corporations. The document should be engaging enough to attract potential clients and deliver an in-depth view of my credentials. Key areas of focus should include: - Years of Industry Experience: Stress the length and breadth of my experience in AHS & Auto Electrical. Provide case studies or instances that show how this experience translates into high quality service delivery. - Track Record with Large Corporations: Highlight any previous successful engagements I've had with large corporations. These can help potential corporate clients understand my ability to handle large...

I posted this job before and the freelancer who took it gave many assurances but unfortunately could not fulfill them. So here is the project again. It is a MasterStudy LMS that needs UI and UX enhancement. The aim is to make it more user-friendly, enhance the course management features, and boost its performance. It is not complicated. If you wish to bid more than $200 for this job, don't. I am happy to give 50% additional bonus on job completion if the changes are done correctly and the LMS features function as intended.

We have various miscellaneous small jobs that need done. SOP (Statement of project) is defined in attachment. Please see attachment in whole & then respond. Thank you.

...banking website. This platform is centered around giving users a convenient way to manage their accounts and perform transactions. Key Features: - Fund Transfer: Ability to perform intra and inter bank transfers. - Statement Requests: Users should be able to request and view bank statements. - Bill Payments: Provision for utilities and other bill payments directly from user accounts. - Miscellaneous Services: Additional features include capabilities for debit, credit, transaction history viewing, email notifications, and real-time account balance displays. Security Features: - The site should be protected with a two-layered authentication system, which includes both username with password and pin. Ideal Candidate: - Mu...

Detailed overall drawings will be provided ① Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - Expression of floor level difference between the 2nd and 6th floors above ground - Expression of external finish ② Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Preparation of fin...

Detailed overall drawings will be provided ① Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - Expression of floor level difference between the 2nd and 6th floors above ground - Expression of external finish ② Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Prepa...

I'm seeking an experienced and reliable accountant to assist me with my accounting needs on a weekly basis. Key Responsibilities: - Bookkeeping: This includes keeping track of all financial transactions, such as purchases, sales, receipts, and payments. - Financial Statements Preparation: You'll be responsible for preparing my financial statements, including my balance sheet, income statement, and cash flow statement. - Tax Preparation: You should be well-versed in tax laws and regulations, and be able to prepare and file my taxes in a timely manner. Additional Details: - Accounting Software: I'm currently using QuickBooks. Proficiency in this software is required for this role. - Frequency: Your services will ...

...identity and setting the tone for my business. Key Details: - The logo should be designed with a maximum of 2 colors that are eye-catching and convey a sense of comfort. - As for font, I'm looking for something clear and easy to read. - I have attached a sample logo for your reference, which should give you a sense of the style I'm aiming for. However, please note that I'm looking for a unique design, not a replica of the attached file. Deliverables: - I'll need the source file of the final logo, and it should include all the fonts and elements used. This will be important for future branding and marketing efforts. If you have any questions or need further clarifications, please don't hesitate to messag...

...new clients through my unique, innovative solutions that specifically boost efficiency metrics. In the capability statement I am focusing on: - Demonstrating proven success in providing innovative solutions, keenly designed to jumpstart and sustain efficiency rates. - Showcasing extensive experience in Mechanical Fixed Plant operations, special emphasis on efficiency advancements. The ideal freelancer will have: - Demonstrated skills and experience in capability statement construction, preferably for plant operations. - A deep understanding of plant efficiency metrics and the tactics to bolster it. - A creative approach to presenting innovative solutions in an impactful and easy-to-understand manner. - An ability to showcase the value of t...

...industry. The main focus is to help me secure funding, hence it should be well-structured and detailed. Key elements to include: - Clear, succinct executive summary - Detailed market analysis of the transport industry, focusing on current trends and future projections - Competitor analysis with a clear understanding of how we differentiate - Financial projections including a profit and loss statement, balance sheet, and cash flow forecast. - A solid marketing plan that showcases our approach to acquiring and retaining customers - A SWOT analysis, identifying any potential risks and how we plan to mitigate them. I am seeking someone with previous experience in writing business plans for the transport industry and ...

...the initial framework that informs and engages a growing audience. Job Description: The Junior Crypto Content Specialist will research trending cryptocurrency topics, write and edit compelling articles, and collaborate with technical experts to ensure accuracy. Additionally, you'll be responsible for SEO optimization to enhance article visibility and engagement. A significant part of your role will also involve building and maintaining an AI dataset database to streamline content creation processes. Mission: Your mission is to produce insightful and engaging content that highlights our crypto products and services, enhancing our audience's understanding and driving their interest. Success will be measured by cont...

I'm looking to bring my new restaurant to life with a captivating 3D design. The theme I've chosen is Retro, so the design should reflect that era. The project mainly involves the dining area and the entrance/facade, and the dining capacity will be less than 50. Key Components: - 3D Design: The primary focus is on creating a detailed, immersive 3D design that perfectly captures the Retro theme. - Dining Area: The design should emphasize the seating arrangement, decor, and overall ambience for a small group of diners. - Entrance and Facade: The first impression is key, so I need a design that makes a bold statement and sets the tone for the rest of the restaurant. Ideal Freelancer: - Extensive Experience: I'm looking for a f...

...clients signing up with my accounting firm. The ideal candidate will have experience in legal writing and an understanding of accounting industry practices and terminology. I would ideally prefer a template that can be easily adjusted and worked with for multiple clients across various industries Key Requirements: - The engagement letter should cover tax preparation, financial statement preparation, and bookkeeping services and other accounting activities relating to the scope of a CPA firm - The document should be delivered in a Word format. - Confidentiality clause is a must to protect client information. A clear understanding of legal requirements around client confidentiality is essential. The letter should be clear, concis...

At present, we manage all our revenues and expenditures through multiple bank accounts. For different types of expenses, we use different cards - for instance, the card ending in 1234 is used for fixed expenses, while the card ending in 0123 is for non-fixed expenditures. All our receipts are sent to Receipt-Bank, which is synced with XERO. - reconcile bank accounts each month - setup inventory management - loan interest - P/L statments - Setup up reconciliation rules Must be finished by 10th of each month Approx 300-400 receipt/bank statement rows need reconciling each month. In XERO, every transaction must be matched with a receipt from Receipt-Bank or reconciled from a bank statement row.

...iconic team and bring it back to life through unique and innovative designs. I'm seeking talented graphic designers to create eye-catching, one-of-a-kind variations of Hartford Whalers t-shirts that will resonate with fans and make a statement. **The Vision:** Forever Hartford is a brand that goes beyond mere nostalgia. It's about remembering the past, fighting for the dream, and keeping the spirit of the Whalers alive and kicking. We're not just selling t-shirts; we're igniting a movement that celebrates the team's legacy and inspires a new generation of fans. **Your Role:** As a graphic designer, you'll have the opportunity to create original, high-quality designs that capture the essence of the ...

Problem Statement Create a ms projects (Preferably 2019 version)that creates a future project on creation of an artisanal organic jam production (strawberry flavored) : 1. With at least 32 tasks; 2. The project has to have codependencies between tasks; 3. The project has to have fixed costs and variable costs, as well resource allocation. In addition, the project needs a 500 word write up on the execution of the project. I want to emphasize that ms projects has to be used for the assignment A 500 word write up about the project

I have an assignment and I'm looking for a finance professional to assist with a comprehensive analysis of a company's financial statements. Task Summary: Three years have passed since initial financial assessments were made, and it is now critical to evaluate the company's performance over this period. Your main objectives will be to: 1. Calculate the following ratio for each of the last 3 years. 2. Analyze the firm's performance over the last 3 years. You should pay attention to all 16 ratios shown in Part A. Identify any strengths or weaknesses, in terms of positive or negative trends. 3- Analyse the firm's performance in comparison to industry averages for each of the ratios. Identify any strengths or weaknesses. 4- Summarise the...

I'm in need of someone experienced in business strategy who can create an eff...strategic plan template. The main aim is to track our progress towards strategic goals effectively. This one-page strategy should include: * A Vision Statement * A Mission Statement * Up to 4 Values * 5 Pillars * 1 to 2 Goals under each pillar * 2 to 3 Key Strategies under each goal (if this doesn't fit or look professional, happy to keep it at the level of goals) * A dedicated space to add an image (can be a partial image) The ideal candidate should have proven experience in business strategy development and template design, and have a deep understanding of Strategic Objectives and Key Performance Indicators. A strong attention to detail and layou...

As an artist, I am seeking your expertise to bring to life a medium-si...medium-sized (16x20 inches) pastel or watercolour painting of a portrait based on an already existing photo with 2 people. - Style: The painting should be realistic. The quality of the final piece should highlight your ability to capture the detail and essence of the people in the photo. - Background: The background should be minimal, focussing the viewer's attention on the subjects. Essential Skills: - Proficiency in pastel or watercolour mediums. - Proven capability in delivering realistic art. - Exceptional attention to detail. Experience in portrait art is highly beneficial but not mandatory. I look forward to viewing your portfolio alongside your proposal. Make this a statement pi...

...transactions and account types - Generating separate sheets for final accounts immediately after creation of ledgers. - Computing balances and totals automatically, providing real-time financial tracking and analysis. In terms of data input, the Excel should comfortably accommodate both manual input by the user and importing data from external sources. Finally, the dynamic tool should be capable of creating financial statements, including a Balance Sheet, Profit and Loss Statement, and Cash Flow Statement. Ratio analysis etc. Relates to accounting Ideal candidates for this role are well versed in advanced Excel functions, have a strong understanding of financial accounts, and experience in automation of financial process...

Please Sign Up or Login to see details.

I'm in need of a highly skilled graphic designer who can transform my sketch into an elegant and sophisticated logo, perfect for both digital and print use. Key Requirements: - Your portfolio should demonstrate a strong sense of elegance and sophistication in your previous work. - Experience in logo design is essential, especially in creating versatile designs suitable for both print and digital platforms. - You should be familiar with working in monochrome, creating impactful designs that don't rely on color to make a statement. If you feel you're the right fit for this project, I'd love to see your portfolio and discuss how you can bring my vision to life.

...audience is both men and women. Key Elements: - Bold Typography: The design should incorporate striking typography to make a statement. - Minimalist: The overall feel should be clean and minimal, focusing on simplicity. - Abstract Patterns: You'll be required to design unique and eye-catching abstract patterns to make the collection stand out. - Pop Culture References: Knowledge of current pop culture trends and the ability to incorporate these in a fresh and exciting way is crucial. Ideal Skills: - Strong background in streetwear design - Proficient in Adobe Illustrator and Photoshop - Ability to create unique and marketable designs - Excellent knowledge of popular culture and trends - Good understanding of typogra...

...system: 1. It has to be completely offline (no online solutions will be accepted); 2. System has to be integrated with LLM (Llama or similar); 3. LLM must be capable on answering questions (via chatbot interface on GUI) on: a. DP’s; and b. Text it read while it was scanning the PDF and looking for DP’s; c. Previously read documents related to the same client. 4. DP’s are to be saved to SQL table; 5. We need a dashboard, to train the engine on finding DP’s in the document. Current problems: A. Large part of documents are scanned, but regardless if the document is scanned or not, it’s all in digital form format. It just so happens that some forms were populated digitally, printed, and scanned; B. As such, scanned documents ...

I require a doctor or medical intern who can create a handwritten medical certificate that complies with the legal system of India. Specific requirements must be met, which will be discussed upon project award. The certificate should include a statement affirming that the student has met with an accident and has a fracture. Please have prior experience in creating medical documents, a keen understanding of legal requirements for medical certificates in India, and an ability to write clearly and professionally.

Hi everybody, We need a full time data organizer who will be putting out bank ...need a full time data organizer who will be putting out bank statements into a proper excel format (which we will give). Please note that you will 70-90% of monthly work and you can keep taking other projects as well but we will give you full time pay of USD 500 and you have to remain available to us We have access to Able2Extract and can provide you a proper converted excel statement. However, in some cases, bank statements could be a scanned copy and hence you may need to manually enter data. This is a full time job and budget is reasonably fixed. Require an excel expert pro as there has to be a lot of data shuffling and data organizing into different folder...

Develop client portal, With below minimum functionality 1. Security – it should be a secure system as it involves Customer information. This security should apply to data in motion and the rest. 1.1 use of SSL certificates 1.2 controlled user and administration access to the Loan System Management administration page and hosting environment. 1.3 Backup 1.4 Other security features – please propose. 2. Audit trail – the customer portal must have record all user transactions or activities and allow for retrieval when necessary (activity history). 3. Scalable – they customer portal must be scalable to accommodate new products that may be introduced. 4. Integration – the client portal must have the capability to integrate with...

...candidate will have a knack for gathering and analyzing data, attention to detail, and the ability to deliver accurate and timely reports. Strong communication skills and the capability to present findings in a clear and concise manner are essential. If you have a proven track record in delivering high-quality research, we'd love to hear from you! Requirement; 1. Filled Verification form with Sign and Stamp along with verifier details. 2. 5-6 geotagged photos in which name board of Issuing Authority is visible. 3. In-case of refusal, I need written refusal statement with Sign and Stamp along with detail of person i.e. name, designation, email and phone number. Ideal skills and...

I'm seeking a fashion-oriented graphic designer with a wide range of styles including, but not limited to, abstract, vintage, and typography for t-shirt print designs. This project involves: - Creating 5-10 diverse t-shirt designs for kids that make a statement. - Designing unique prints for fabric printing. - Writing detailed tech packs for garment production of Baby/toddler/Kids clothing. The ideal freelancer for this project would have experience in fashion design, textile print design and technical garment manufacturing specifications. Your work will significantly contribute to the distinctiveness of the statement our t-shirts aim to make. Ensure your portfolio showcases your versatility in different design styles.

I'm urgently seeking an experienced developer proficient in and Payload CMS. Your task will be to create a user-friendly Institution profile listing/rating platform. Primary Features: - Search functionality: Allows users to easily search for institutions - Institution profile creation: A space for institutions to create comprehensive profiles Institution Profile Contents: - Name and logo of the institution - Contact information such as address, phone number, and email - Clear and compelling institution’s mission statement and description - Visual content: Photos and videos demonstrating institutional environment and facilities - A detailed section on programs and courses offered - User reviews and rating sy...

I need to create an Accessibility Statement (VPAT) for some custom browser-based applications. These are custom browser-based applications, with the purpose of the accessibility statement being to demonstrate compliance with legal requirements, specifically the U.S. Section 508 standards. Key responsibilities include: - Understanding the Section 508 standards and how they apply to the design and functionality of the custom browser-based application - Creating a comprehensive VPAT that clearly outlines the level of conformance with the Section 508 standards. The ideal freelancer for this project would have: - Expertise in Section 508 standards and requirements, as well as practical experience in creating VPATs - A background in w...

...modern, minimalist, and vibrant, icon-based logo. The logo should be able to stand alone as an icon, and still represent my brand effectively. Key Requirements: - Icon-based Design: The logo should be primarily an icon, rather than text-based. It should be simple, yet unique and memorable. - Modern and Minimalist Style: The design should adhere to a clean, modern and minimalist aesthetic. It should be simple, yet powerful. - Bright and Vibrant Colors: The color scheme of the logo should be bright and vibrant, helping it to stand out and make a bold statement. Ideal Freelancer: - Experienced in logo design, with a strong portfolio of modern, minimalist, and vibrant work. - Skilled in creating effective icon-ba...

I'm in need of a creative and skilled designer who can bring my clothing brand to life through a minimalist, text and symbol-based logo. I want the logo to make a statement in black and white. Prowess in minimalist design is essential and previous experience with clothing brand logos would be a major plus. Your task will be: - Creating a logo that combines text and symbols - Integrating black and white shades meticulously used for clothing NEEDING FEW DIFFERENT LIGOS TO CHOOSE FROM

I need a proficient financial expert to develop detailed annual financial statements for my business from my bank account information. The expected deliverables are an income statement, balance sheet, and a cash flow statement. Expectations: - Categorize all transactions specifically. - Compile accurate, detailed final statements. Skills and Experience: - Solid understanding and experience in financial accounting and bookkeeping. - Attention to detail. - Ability to meet strict deadlines. - Confidentiality and professionalism. - Proven track record in similar projects.

I require an accomplished auditor to undertake a complete audit of my company's finance and accounting operations. This will entail examining all segments of our finance and accounting processes and providing a comprehensive evaluation. After the audit, I will require an audit of the Balance Sheet and Income Statement. The ideal candidate should have: - Extensive experience in finance and accounting audits - Knowledge and understanding of balance sheets and income statements - Keen attention to detail and strong analytical skills - CPA qualification would be beneficial

Please Sign Up or Login to see details.

...presentation is to engage potential partners and secure their interest in the project. Key components that should be included in the pitch deck are: - Problem statement: A clear explanation of the problem my project aims to solve. - Solution description: A detailed overview of how my project addresses the identified problem. - Market analysis: An analysis of the target market, highlighting its size, trends, and potential for growth. I'm seeking a designer who has a strong background in developing pitch decks for startups, preferably within the technology industry. Your experience in crafting engaging narratives, using visuals effectively, and understanding the language of investors will be crucial. If you believe you can help bring my project ...

...strings within another dataset that includes complete sentences. Currently, our method of loading the first set into memory as a set variable (ensuring no duplicates) and each string from the second dataset as a separate string variable is proving inefficient. Problem Statement: Iterating through the first dataset to look up each value in the second dataset has been excessively time-consuming. We require a more efficient algorithm to enhance the speed and effectiveness of these exact match lookups. Project Objectives: Develop a Python script that can perform exact match lookups quickly and accurately. Ensure the integrity and accuracy of the lookups to maintain database cleanliness. Key Requirements: Efficiency: The algorithm must reduce the time co...

I'm in need of an experienced accountant who can assist with monthly bookkeeping and the preparation of financial statements. Key Requirements: - Proficiency in QuickBooks: You should have extensive experience using this software to ensure smooth operations. - Bookkeeping Skills: You'll be responsible for maintaining accurate records of financial transactions. - Financial Statement Preparation: You should be able to prepare monthly financial statements. Please note: We're seeking a professional who can commit to a monthly schedule for a long-term basis. The ideal candidate should be detail-oriented, organized, and have a proven track record in providing high-quality accounting services.

I urgently require versatile help with my bookkeeping tasks. This includes meticulously meeting demands relating to: - Data entry - Bank reconciliation - Financial statement Preparation Proficiency in using the tally software is a prerequisite as it's the accounting software I'm currently working with. As for the volume of transactions, I have less than 50 on a weekly basis so, detail-orientation is key. An ideal candidate is one who has a solid foundation in bookkeeping and a proven track record working with a similar volume of transactions. This is a recurring job set to span on a weekly basis.

I'm in need of a skilled developer to assist with some intermediate level formulas and calculations on Google Sheets. I'm struggling to automate some repetitive tasks and I need someone with experience in this area to help me out. Key skills required include: - Proficiency with Google Sheets, particularly with its various functions like VLOOKUP, SUMIF, COUNTIF and others. - Understanding of how to automate tasks in Google Sheets. Your mission, should you choose to accept it, is to bring automation to my Google Sheets tasks, helping me reduce manual labor and making my life a lot easier. If you have a penchant for problem solving, this could be the perfect job for you!

I'm in need of a Certified Professional Accountant (CPA) from Canada who can put their signature on my financial statements. The documents to be signed include: - Balance Sheet - Profit and Loss Statement - Cash Flow Statement There's no tight deadline for this project. You should have certified authority to sign these statements and you should be reliable and meticulous. I appreciate detailed and thorough work. Previous experience with these types of documents is a plus. Your availability should be flexible enough to complete the task at ease. Looking forward to working with a knowledgeable CPA professional!

I'm in need of a CPA to prepare complete financial statements for me. ...in need of a CPA to prepare complete financial statements for me. - Types of Statements: Specifically, I require an income statement, a balance sheet, and a cash flow statement. - Software Utilized: Presently, I am maintaining all my accounts and financial data in Excel. - Data Readiness: I have all essential data and records readily available for the preparation of these financial documents. Ideal Skills and experience: - Must have formal CPA certification - Proficiency in Microsoft Excel - Prior experience in preparing financial statements - Strong knowledge of accounting standards and regulations. Your detailed understanding of accounting principles...

...review and sign my company's already-prepared financial statements - encompassing the income statement, balance sheet, and cash flow statement. Key responsibilities include: - Rigorously reviewing the provided financial data - Signing off these statements post-review Note: All required financial data and records have been duly prepared and are readily available for review. Presumably, no particular statements necessitate special notes or disclosures as per the prevailing accounting regulations or my company policies. An ideal candidate must: - Be a Certified Public Accountant (CPA) - Boast significant experience and a keen eye for detail - Demonstrate a deep-seated understanding of financial statements - Possess a quick tur...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

...techniques in a Linux environment. Problem Statement In today's computing environments, efficient sorting algorithms play a crucial role in various applications, ranging from data processing tasks to system-level operations. The ability to sort large sets of data quickly and accurately is essential for optimizing performance and ensuring the smooth operation of software systems. The objective of this project is to develop a multithreaded program capable of sorting a list of numbers using different sorting algorithms. The program will be implemented in Java and will leverage the multithreading capabilities of the Java programming language. The project will specifically target a Linux environment, providing students with practical experience in dev...

... accuracy, and excellence in all our projects. As an Excel Specialist, you will play a crucial role in handling various tasks that require advanced knowledge and proficiency in Microsoft Excel. Job Description: Utilize Microsoft Excel to complete a variety of tasks and assignments. Manipulate data, perform calculations, and generate reports using advanced Excel functions. Analyze and interpret complex data sets to provide valuable insights. Develop and maintain Excel templates and spreadsheets for organizational use. Collaborate with team members to ensure timely completion of projects. Requirements: Proficiency in Microsoft Excel, including advanced functions such as VLOOKUP, INDEX-MATCH, and PivotTables. Strong a...

...whom it was sent. If clicking on the link will enter the login information of another user, in this case it should not proceed. Configure the correct redirect to the necessary sites * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices...

Im looking for a freelancer who can write a research paper on "Post-Pandemic Work Trends". The research paper should be ideally of about 2500 words. The research paper...research paper on "Post-Pandemic Work Trends". The research paper should be ideally of about 2500 words. The research paper should include content like Abstract Introduction Problem Statement Formulation of Objectives Scope of the Study Literature Review Setting of Hypothesis/Formulation of Problem Statement Research Methodology Data Presentation Data Analysis Summary of Findings Suggestion & Recommendations Conclusion All the data will be collected from your side & also I want citations for this research paper. Note: my budget for this would be between INR 600 to 800 only s...