Subject: Request for Building a Modern Website for Auckland Heat Pumps Dear Mehedi, I trust this email finds you in good health. My name is Mike Plain, and I am reaching out to you from Auckland, New Zealand. I am the proprietor of Auckland Heat Pumps, a business that has proudly served our community by exclusively dealing with Daikin Heat Pumps for the past 20 years. I am contacting directly as I was recommended by a colleague, Laurie Lowther whom you have done some work with prior and has recommend your work. As we contemplate the sale of our business, we recognise the pivotal role a contemporary, user-friendly website plays in showcasing our services and facilitating communication with potential customers. With this in mind, I am seeking your expertise in developing a new w...
I'm seeking an expert in Excel who can efficiently merge two sets of numerical data sourced from different spreadsheets. Key tasks include: - Cleaning similar columns to create a unique identifier for perfect merging - Conducting statistical analysis on the merged data to find the mean, median, mode Ability to analyze data meticulously, professional experience in using Excel and familiarity with advanced statistical functions are essential for this project. Stringent attention to details is appreciated, as the data to be handled is delicate and the outcomes crucial. An understanding of data cleaning techniques in Excel would be an added bonus.
Saludos, busco un experto en vba excel para la solución o complementación de un proyecto. Adjunto dejo una imagen del userform que funcionará cómo buscador y modificador de una base de datos en excel, la principal necesidad es lograr que el listbox genere la data con sus respectivas columnheads cómo se muestra en imagen, y que a su vez en el apartado del buscador, se pueda filtrar por el campo requerido y se genere correctamente la nueva fuente de datos. El error que se me ha presentado es que por usar el método .rowsource para mantener los encabezados, no me permite utilizar el método .additem.
Proyecto de automatización con sharepoint, Excel, power automate y power bi
I need a highly functiona...highly functional workbook for evaluating, comparing and making informed purchasing decisions. Key Features: - I want to input multiple quotes for comparison side by side. - The workbook should automatically calculate the total cost of each quote for a clear view on price points. - Comparison charts are necessary for a visual understanding of the differences between the quotes. RFQ Packages: - The workbook should handle RFQ packages where each has its own tab. - These RFQ packages need to roll up to a project procurement summary. - The possibility to add and delete RFQ packages should be facilitated. Ideal candidate will have a strong background in building robust spreadsheets with advanced formulas and an understanding of ...
I am seeking an Excel expert capable of preparing a comprehensive document comprising more than 10000 rows and columns. The scope of the project involves processing substantial data sets, namely: Organizing Scanned documents and extracting the data, organizing the data in different corporations by department and years. Be able to extract a P/L and AR for all companies. Project is to be done in stages - Text - Numerical data - Date Information The ideal candidate for this job should have: - Expert knowledge of Excel and related functionalities. - Strong attention to detail. - Proven experience of data entry in large volumes. - Familiarity with basic mathematical operation functions within Excel. The deliverable will be a well-structured ...
En busca de un analista de datos freelance, estamos emocionados de ofrecer una oportunidad única para aquellos apasionados por la analítica y el crecimiento continuo en el dinámico mundo del Multinivel (MLM). Si te entusiasma generar reportes precisos, limpiar y administrar tablas de datos, y tienes un sólido entendimiento de Excel, DAX, PowerPivot y tablas dinámicas, ¡este podría ser el proyecto perfecto para ti! Necesitamos un analista junior que no solo posea habilidades en análisis de datos, sino que también tenga experiencia comprobada en el análisis de datos específicos de empresas de MLM. Es crucial que puedas interpretar planes de compensación y entender profundamente los volúmenes de ...
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 i...
I need expert help with formatting documents across Microsoft Word, Excel, and PowerPoint. The key tasks include: - Formatting text: Ensuring consistency, readability, and visual appeal for all text elements. - Tables and charts: Skillfully organizing and presenting data in tables and charts. - Page layout and design: Creating visually engaging and professional layouts. - Resume: Crafting a creative resume with a professional touch. Ideal candidates should have: - Proficiency in Microsoft Office suite, with a focus on Word, Excel, and PowerPoint. - Proven experience in text formatting, table/chart creation, page design, and resume formatting. - A keen eye for detail, design, and visual presentation. - Ability to work efficiently and meet deadlines. - Familiarity with...
In need of an Excel whizz to immediately help in cleaning up my spreadsheet which has become cluttered and confusing. The main task will be: - Formatting cells and columns: Your experience in making spreadsheets intuitive, organized, and easy-to-read will be key. Expertise in creating visually appealing and easy-to-navigate cell and column formats is crucial. Though the specific type of cell and column formatting was not specified, the ability to quickly adapt and modify to different formatting styles would be a plus. Please note, this task is time-sensitive and requires prompt completion. If you have a proven track record of quick turnaround times on similar projects, don't hesitate to apply. Your efficiency and attention ...
I'm in need of a programmer skilled in pine scripts (tradingview). I am looking for someone who can create an alert in my script that is triggered when all specified conditions (Multiple conditions) are met. The c...when all specified conditions (Multiple conditions) are met. The conditions were not delineated in the planning phase. The key task for this project is that for example when the first condition met should keep a record of that value and then use that value to another condition to trigger the alert. The ideal freelancer would: - Have experience in building complex alert systems - Understand and be able to work with the existing code - Be able to complete this task within the given time frame - Have great attention to detail and exce...
I'm seeking an Excel specialist who can help automate the process of managing my inventory. The main task includes creating a function that calculates and displays the number of pieces in boxes on pallets. This project mainly revolves around calculative automation and descriptive statistics. Key responsibilities: - Developing an Excel function that calculates the number of items in the boxes on pallets - Automating descriptive statistics to make the process more efficient An expert with profound knowledge in Excel and a strong background in performing operations associated with calculation automation and descriptive statistics would be the ideal fit for this task. Your role will revolve around simplifying my procedures and making my work a lot more m...
I am looking for an experienced Power BI developer to transform my Excel spreadsheets into an interactive sales performance tracking dashboard. Key Responsibilities: - Utilize Power BI to create a visually appealing dashboard from Excel data. - Ensure the dashboard accurately reflects sales performance. - Develop the dashboard to provide a static report for easy viewing. Ideal candidate should have: - Proficient in Power BI to effectively transform Excel data to a user-friendly dashboard. - Strong analytical and visualization skills to accurately represent sales data. - Excellent attention to detail for accurate tracking and data representation.
...for a freelancer to create a pricing spreadsheet based on the specific website, which is Format and Structure: I am open to suggestions and would like the freelancer to recommend one that is suitable for the project. Desired Functionality of Spreadsheet: I would like 3 input fields product width, height, and product quantity. The spreadsheet should output the price of the product with tiered discounts based on quantity. The desired outcome would function like but on a spreadsheet. ***A future project will integrate this spreadsheet into a website for live front end pricing.** Ideal Skills and Experience: - Proficiency in spreadsheet software such as Microsoft Excel or Google Sheets
I am seeking an expert with proficiency and accuracy in data cleaning and data entry. The project involves handling a significant dataset of more than 1000 records. The data, currently in Excel spreadsheets, needs proper cleaning—deleting duplicates, handling missing entries—and subsequent entry into a new, streamlined database. Ideal Skills: * Expertise in Excel and spreadsheet management * Proficiency in data cleaning techniques * High-speed data entry with attention to detail Experience: * Experience handling large data sets * Previous work in data cleaning and data entry operations With your help, this project will result in accurate, well-organized, and easily-accessible data, which will make an enormous difference in how we run future analys...
I'm looking for a skilled Excel expert to help prepare a company operations sheet. The project involves: to Prepare a Small Company Operations Sheet My Budget is fixed . 1000 Rupees I want an auto-calculated Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Exce...
CONTEST INSTRUCTIONS: -Please do not use an AI to generate some random image. -Please use the included story and image to give me an example of how you would format a few pages of the book. I will give 1 stars otherwise. Thank you! I need expert assistance with designing and formatting my children's chapter book in a hardcover portrait layout. The book will target the 6-8 years age group and will include 13 illustrations: 11 single, 2 spots, 1 Front Cover, and minor elements. The interior will be used for hardcover, softcover, and ebook. THE BOOK WILL BE 8 X 10. Here are my requirements: - Layout design: The layout must be in portrait format, integrating the 13 illustrations with the text. - Format: The final design should be formatted for hardcover & Softcov...
...Python, Excel VBA, and API integration. The primary task is to extract specific data from the API response, and populate it into a designated column in an Excel file. Key Requirements: - Experience in Python programming - Proficiency in Excel VBA - Demonstrable experience with API integration - Ability to parse specific data from an API response from Google Server - Good understanding of automating tasks in Excel Further Details: - The primary purpose of the project is to send API requests with image URLs listed in column A of the Excel file. Upon receiving the API response, the relevant data should be extracted and placed in column D and B/C/E to be populated. - The setup should be easy to execute when needed by c...
Presupuesto 9 dólares Realizar una hoja de calculo que me arroje el puntaje y la posicion de una oferta respecto a las otras deacuerdo a unas formulas que asignan puntaje deacuerdo al valor que oferten
I need an Excel workbook that incorporates customer contact information, sales volumes, and insightful visualizations for better decision-making. Key Features Needed: - **Customer Contact Information**: The workbook should include customer names 2 contact info fields (email & phone). Data Representation: - **Sales Data & Customer Slicing**: There should be 3 sheets within the workbook with sales volumes. Users should be able to use a pivot table to filter and slice data by branch and year. - **Customer Variances Year-over-Year**: I need the workbook to show customer variances year-over-year. This should include both percentage change and absolute difference. Visualization: - **Top 10 Customers**: The workbook should contain an Excel table th...
I'm looking for an SEO freelancer to help me optimize my new website for a global audience. The primary focus of this project is on-page SEO. This includes, but is not limited to: - Keyword research and implementation - Meta tags optimization - Content creation and optimization - Internal linking strategy - Improving user experience - Mobile-friendliness The ideal candidate should be able to demonstrate: - Proven experience in on-page SEO - Understanding of global SEO best practices - Strong communication skills - Ability to work collaboratively Primarily, the goal is to increase the visibility and ranking of the website on search engines for a global audience, which will ultimately drive more organic traffic and conversions.
I'm in need of an Excel VBA expert to assist me in my project. I require assistance in writing new code, as well as debugging existing code. Specifically, the VBA code is intended for various purposes: - Automating repetitive tasks - Performing data analysis and manipulation - Creating custom functions and macros I specifically have to macros that I've started working on and need debugging: - Replacing references to cell/range addresses in formulas by their name - Implementing Montecarlo simulations (with automatic creation of histograms and data output) The ideal freelancer would have proven expertise in Excel VBA, with a strong track record of writing efficient, maintainable code. It's crucial that the code is robust, error-free, and...
...am seeking a professional who is adept at data entry and copywriting. This project will require: - Online form filling using data from existing digital documents. Attention to detail and accuracy is of utmost importance. Skills in data entry and experience with handling digital documents will be essential. - Copy writing for blog and articles. I am looking for someone with experience in crafting engaging, informative, and high-quality content related to my industry. Expertise in blog and article writing is a must, as well as a strong command of English language and grammar. The perfect candidate will possess Excel skills for the data entry part of the project, and should have a track record of creating enticing blog posts that keep the reader's interest. Yo...
PRODUCT CATALOG BROCHURE IN MICROSOFT PUBLISHER Hello, we create at the moment self in Microsoft Publisher (easy for us as Indesign and another) a new Product Catalog. Can you help us to finish the layout and more than ? Please let us know when you have graphic expierence and Publisher experience and send us a reference from your publisher works via private message here.
I'm in need of a data analysis and visualisation expert, particularly in R. The ideal candidate will be experienced in Excel, STATA, and SPSS as well. The main tasks include performing data analysis, creating engaging data visualisations, and building data models. Key Responsibilities: - Performing thorough data analysis using tools like STATA, SPSS, and Excel - Proficient in R for creating engaging data visualisations - Building data models to support the provided data Ideal Skills and Experience: - Proven experience in data analysis - Expertise in R and other relevant tools like Excel, STATA, and SPSS - Ability to create engaging data visualisations, preferably in the form of stacked bar charts - Strong understanding of data models and related co...
...opciones); 3) hace cuanto le hizo la última limpieza (1 semana, 2 semanas, 3 semanas, 1 mes, 2 meses y hace más de 3 meses) y 4) Tres cajas de texto para que ingrese el Correo Electrónico, Nombre completo y Número de Celular. Con todos estos datos el cliente puede dar clic en el botón para estimar/calcular el precio del servicio (Estos precios de servicio los tenemos calculados en una tabla de Ms-Excel). Tener en cuenta que los datos ingresados deben ser capturados y almacenados. Nota: Cuando el cliente de clic en el botón estimar o calcular, la multimedia 1) le muestra el precio del servicio y una animación que indique que es "afortunado en conseguir estos precios", luego le muestra al potencial cliente las opciones ...
I need your help in creating an automated script or formula that can run multiple find-&-replace functions, at the same time, on an Excel spreadsheet that could regularly include 1,000 to 5,000+ records. Specifically, I will run this routine on the physical address column of data (not on the Company Name or City or State columns). In the attached .xlsx file, I would run the routine for all of a Column B. Here are the 20 specific tasks involved: 1. If a cell contains the word "Ave" or "Ave.", it should be replaced with "Avenue". 2. If a cell contains the word "Blvd" or "Blvd.", it should be replaced with "Boulevard". 3. If a cell contains the word "Ct" or "Ct.", it should be replaced with ...
I have a set of scanned images in PDF format that I need converted into an Excel sheet. The job is purely data entry - you are to copy the content from the scanned images into an Excel sheet. The freelancer should have excellent typing skills and attention to detail to ensure that no data is missed or entered incorrectly. Ideal Skills: - Proficiency in Excel - Fast and accurate typing skills - Detail-oriented - Experience with data entry, especially from scanned images - Excellent communication to ensure any questions about the data are clarified before entry
...REVIEWING THE SCOPE THOROUGHLY. ANY AUTOMATIC RESPONSES WILL BE AUTOMATICALLY DISQUALIFIED. I am looking for an expert in financial modeling to create a detailed and sophisticated financial model for a real estate project. The model should be able to assess and analyze the cash flow and investment potential of the property. The key requirements for the project are: - An advanced level of complexity: As the financial model will be utilized in the real estate sector, it should be able to handle complex calculations and scenarios. - Specialized industry knowledge: Experience in the real estate industry is a must, as the model should be tailored to its specific requirements. - Analysis of cash flow: The model should include a comprehensive cash flow a...
Very simple project - need an excel wiz who can remove some duplicate entries & total up some columns. Only bid if you are an excel wiz & very experiened in excel
I'm looking for a skilled Excel expert to help prepare a company operations sheet. The project involves: to Prepare a Small Company Operations Sheet My Budget is fixed . 3000 Rupees I want an auto-calculated Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator...
I need a one-time extraction of specific data from into an Excel spreadsheet. The task involves extracting all data for each date as far back as 1 January 2020. The end product is a long table in Excel also capturing the date of release. Key Requirements: - Extract earnings data that surpasses expectations from a specific website. - Transfer the extracted data into an Excel spreadsheet. Ideal Candidate: - Proficient in web scraping tools and techniques. - Experience in data extraction and manipulation. - Strong skills in Microsoft Excel.
I need a software developed urgently that can generate playlists on Apple Music. I can provide the Apple music song URLs in a Excel file as follows: ... I need to import the playlist into my Apple music player
I'm looking to enhance my website's SEO ranking through the strategic implementation of internal links. Key objectives: - Increased SEO ranking: The primary goal is to improve my website's search engine ranking by strengthening its internal linking structure. - Enhanced user experience: While the primary goal is SEO, I still want the user experience to be as seamless as possible. I currently have between 1 and 50 pages on my website, and I do not have a specific method in mind for how these pages should be linked. Ideal skills/experience: - SEO expertise: A strong understanding of SEO principles, especially in relation to internal linking, will be essential. - Web design: Experience in web design with a focus on user experience...
Exciting opportunity for an excel whizz! I urgently require assistance with embedding photos into an excel sheet. Key Responsibilities: - Insert Photos: You'll be in charge of seamlessly integrating photos into an excel sheet. you should keep the same resolution Skills and Experience: - Excel Proficiency: Strong excel skills are a must. - Attention to Detail: Aligning photos properly within the sheet is critical. - Quick Turnaround: This project needs to be completed ASAP. Get in touch if you've got the passion and experience to deliver this project swiftly!
I am in need of a highly proficient Excel VBA developer who can implement and automate complex data analysis, and generate reports from large volumes of data. Key Tasks: - Implementing intricate data analysis using Excel VBA scripts. - Automating repetitive data management tasks. - Designing and developing report generation tools. This program will be used by a mix of both internal and external users. Therefore, the created solution should be intuitive, user-friendly and reliable. Essential skills: - Proven experience in Excel VBA programming, dealing with large complex sets of data. - Strong understanding of data analysis techniques. - Capable of designing user-friendly interfaces for report generation. This is a challenging and vital project that requires a c...
I need immediate assistance with converting 50 invoices into an Excel sheet. The information to be transcribed includes the following columns: Date, CIF, Company Name, and Amount. Ideal Skills: - Proficiency in Excel - Attention to detail - Fast and accurate data entry skills The project has to be completed within 1 day. No specific formatting requirements are needed at this time. Once completed, I will review the Excel file.
I'm immediately needing a skilled computer operator who could expertly man...entry tasks, file management, and maintain our database. You must be proficient in utilizing Microsoft Excel, Google Sheets, and QuickBooks. Key Duties: - Accurate Data Entry - Efficient File Management - Consistent Database Maintenance Preferred Skills and Experience: - Proficiency in Microsoft Excel, Google Sheets, QuickBooks - Fast yet accurate typing skills - Strong knowledge in File Management and Database Maintenance - Good time management skills Your ability to deliver quickly is essential as I require this project to be completed ASAP. Please provide proof of your skills in your proposal so I can make an informed decision. I greatly appreciate your interest and look forw...
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
I'm looking for an expert in Excel data handling and financial analysis with special attention to franchising businesses. The end-goal is to develop a user-friendly, dynamic Excel document for cross-comparison of various franchisor fees, charges, and costs. Key Tasks: 1. Data Entry: Populate the document with the provided profit and loss data. 2. Categorization: Organize costs by frequency of occurrence (monthly, yearly, etc.). 3. Analysis Tools: Implement features to run various cost analysis scenarios with a focus on comparing costs between different franchisors. A back ground document that I can change that clearly show in $ cost the difference and in visual Competitive analysis comparison document Ideal freelancers should have an understanding...
I'm after a specialist to do multiple 3D pool and landscaping designs for our swimming pool company. Project requires completion within 3 weeks. We like to transform outdoor spaces into a relaxing escape zone. The project's foremost goal is making it ideal for recreation, family time and relaxation. I'm particularly interested in: 1. Landscaping Design: Incorporating decorative plants and outdoor furniture into the overall design, aiming for a harmonious blend that will complement the swimming pool. Usually includes a alfresco area or undercover area of some form linking the house to the outdoor area. 2. Plant Selection: This entails choosing a variety of themed plants that pair well with each pool design. This could range from formal, hedging...
I'm in need of a highly proficient Excel specialist who will perform a series of tasks for me. Specifically, these include: - Data Analysis: Probing and evaluating a medium-size dataset (between 100-1000 rows) to derive meaningful insights. - Spreadsheet Formatting: Improving aesthetic appeal and readability of my spreadsheets. - Formula Creation: Establishing useful formulas to automate computations and functions. The entire project needs to be undertaken in Excel 2016 or later, therefore familiarity with this version is essential. Experience in data analysis and spreadsheet management is also expected. If you're an Excel whiz, I'd be eager to hear from you.
I have code for login trading accound and fetch token data. I need to update code I need to collect live data from the web and candle stick, I have attached the document for data collection from web. Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Please view the attach file. I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire y...
I need a freelancer to assist me with a small financial calculations task in Excel. - The work is focused on financial calculations, so experience in this area would be highly beneficial. - The task isn't extensive, but I need someone who is detail-oriented and can ensure accuracy in the calculations. - I'm open to seeing examples of your past work, particularly if you've done similar tasks. Please apply with your relevant experience and a brief explanation on how you would approach this task. Need it by today
We are currently seeking a freelancing creative graphic designer or a team or a design studio for a long-term engagement to assist with our projects. Design work needs: 30-60 design works per month. Over time, the need would increase. Variety of design tasks: Our need includes both static and motion/animated video designs. Mostly static and motion banners for social media It would vary depending on our customers needs but all of them are operating in the gaming/gambling/IT industries Software: Proficiency in Adobe Creative Suite, including Illustrator, Photoshop, InDesign, After Effects, and Premiere Pro. Additional skills: Experience with presentation design using Google Slides and Microsoft PowerPoint would be a significant advantage.
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 need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.
We are currently seeking a freelancing creative graphic designer or a team or a design studio for a long-term engagement to assist with our projects. Design work needs: 30-60 design works per month. Over time, the need would increase. Variety of design tasks: Our need includes both static and motion/animated video designs. Mostly static and motion banners for social media It would vary depending on our customers needs but all of them are operating in the gaming/gambling/IT industries Software: Proficiency in Adobe Creative Suite, including Illustrator, Photoshop, InDesign, After Effects, and Premiere Pro. Additional skills: Experience with presentation design using Google Slides and Microsoft PowerPoint would be a significant advantage.
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
