Spreadsheet excel joomla formulasεργασίες

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 that presents the top 1...

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 easy to under...

I 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 an...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. Your bidding should reflect experience and skills ...

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 concepts If you...

...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

...in advanced financial modeling, preferably within the real estate industry. - Strong analytical skills and attention to detail. - Excellent knowledge of financial principles and real estate market dynamics. - Proficiency in relevant software for financial modeling, such as Excel or specialized real estate software. - Ability to deliver high-quality work within the agreed timeline. Please note: I have a very simple existing base model I want to build on. There will be a few steps toward an aggregated spreadsheet modeling multiple projects: 1. Get one working layer in what will ultimately be a model that aggregates a view across multiple projects. Have a single input section on the project layer for key variables controlling the model. 2. That view should be b...

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 Excel Template Contractor ...

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'm seeking a skilled data scientist with experience in handling structured data to help create a machine learning model. Details of the project is available as an attachment .Data record will shared later on acceptance of proposal . Key Respons...your expertise in ML modeling, - A detailed project proposal outlining your approach to developing the model, including the specific techniques and algorithms you plan to use. - Any relevant experience you have with similar projects or industries. Ideal Skills and Experience: - Strong background in data science and machine learning - Proficiency in handling structured data, particularly in spreadsheet format - Experience with customer churn prediction models is a plus - Excellent communication skills and ability to explain complex...

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

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 manage data 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 forward to p...

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 of financial managem...

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 you and release the pa...

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

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.

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

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

I'm in need of an expert in Excel, Access or similarly powerful programs to handle a large spreadsheet task. Although the specific tasks that need to be handled were not decided upon, proficient data organization skills are essential as we may need to restructure large data sets. The ideal freelancer for this job should: - Have expert skills and proficiency in Excel and Access. Knowledge of other data organization tools will be considered a plus. - Showcase notable experience, specifically in dealing with large data sets and complex spreadsheets. - Since the specific tasks to perform were not mentioned, a flexible approach and ability to adapt with regard to potential data analysis and data entry tasks will be greatly appreciated. With your application, please ...

I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.

...in system with multiple users. - Integration of Hawksoft CMS and Marketing 360 CRM into the platform. - A document signer with the ability for electronic signatures and document tracking. - A calculator that includes formulas for interest and payment schedules. Ideal Skills: - Proficiency in CMS and CRM integration, particularly with Hawksoft CMS and Marketing 360 CRM. - Experience in developing document signing features with elements such as electronic signatures and document tracking. - Strong background in building calculators with advanced financial formulas, particularly those related to interest and payment schedules. - UI/UX design skills, to create a user-friendly interface that seamlessly integrates all these features. If you have experience in...

...business. You will need to use sales navigator and other tools to conduct thorough profile research. • Data filtering: You will need to filter and sort the data you collect based on the most relevant and important criteria. You will need to use sales navigator and other tools to perform accurate data filtering. • Data collecting: You will need to collect and organize the data you find in a spreadsheet or a database. You will need to use sales navigator and other tools to ensure data quality and consistency. • Sending personalized messages: You will need to send personalized messages to each prospect you find, inviting them to connect with me and introducing them to my business. You will need to use sales navigator and other tools to craft engaging and effecti...

This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.

Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancemen...

I need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file

Monthly, we populate a spreadsheet with the over time of the technical team, and the weekend / night shifts of the tehnicians working outside the business hours. We have a template that we want to improve. 2 categories: 1. Managers doing overtime (regular / night / weekend) and being oncall. 2. 24h shifts: complement to the salary based on night / weekend hours we should be able to calculate monthly the amount to be added to the fixed salary attached template (with complicated formulas and errors)

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if...

Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas

...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...

...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...

Excel Automation of my project and data visualization

I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be requ...

...for a store in Chelsea Massachusetts. This project should blend with a newly opened robotic fulfillment center newly built in Tewksbury, Massachusetts. The store is in nearby Chelsea, Massachusetts. The initiative is from the store, that is why we have no feasibility study budget. A preliminary template has already been built by an Ai assisted feature of Microsoft 360. Nobody has any real spreadsheet acumen to go any further, but our data series and needed parameters are ready. I've been hired to work in the new robotics center due to my past technical background and current Home Depot store merchandising and shrink knowledge. My time frame is 4 weeks as our data streams refresh every two weeks. and I will have two complete sets by then. After that, 30 days of testi...

I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.

I need an expert to help me select the most suitable all i...using Electron and we can make mobile apps in JS using react & angular. But in javascript will code be exactly same for all platforms ? 4. Another option is Flutter (Dart). 5. Which is better out of these 2 ? or can you suggest any other option apart of these 2 6. As of now I want to develop a web app for visual DBMS quite similar to ms access. It will look like a spreadsheet but will have capabilities of both Google sheets / MS excel & a DBMS (DataBase Management System) 7. I am very familiar with C & C++. So I would prefer to use similar syntax. 8. Can C++ be answer to my 1 & 2 point ? You should have: - Profound understanding of various programming languages - Significant experience in build...

I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated uniq...

...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...

...gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of HTML, CSS, and JavaScript to understand the structure of web pages. Ability to work independently and meet established deadl...

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...