For loop in excel formuladela

...script which presently downloads data from Yahoo and adjusts for inflation. The script needs to be able to adjust for inflation on a specified date, rather than the current date. Key Modifications: - Allow manual input for the date used for inflation adjustment. - Add two new columns to the dataset: 1. A column for the inflation ratio (%), calculated based on the market value and the adjusted value. 2. A column that calculates the result of the formula R=ax+by+cz, with a, b, c being arbitrary constants and x, y, z being data pulled from the current row. I've attached the current script and my attempts at modification. The script will be validated and tested in Jupyter Notebook. Ideal skills for this job include: - Pro...

...We are seeking an experienced Financial Modeling Consultant with in-depth knowledge of affordable housing development, specifically in the state of Florida. The ideal candidate will have expertise in affordable housing underwriting models, including the integration of grants, subsidies, and funding programs, and will guide us in improving our financial models and making strategic financial decisions. Responsibilities: Review and refine our existing underwriting model for affordable housing projects. Develop a new financial model, if necessary, tailored to our project needs. Analyze grant programs, subsidies, and other funding mechanisms relevant to affordable housing in Florida. Provide insights into compliance requirements for state an...

I'm in need of a skilled Excel VBA developer to create a macro that transfers numerical data from one Excel workbook to a second one on a daily basis. The macro should be designed to bring over all data from the source workbook. In addition, I would appreciate written instructions on how to recreate the macro in the event of a break. This project requires a clear understanding of Excel, VBA programming, and the ability to write clear and concise instructional material. Must speak good english as best we do a zoom / teams meet to review workbooks.

Prosimo, vpišite se ali se prijavite za več podrobnosti.

...We are seeking an experienced Financial Modeling Consultant with in-depth knowledge of affordable housing development, specifically in the state of Florida. The ideal candidate will have expertise in affordable housing underwriting models, including the integration of grants, subsidies, and funding programs, and will guide us in improving our financial models and making strategic financial decisions. Responsibilities: Review and refine our existing underwriting model for affordable housing projects. Develop a new financial model, if necessary, tailored to our project needs. Analyze grant programs, subsidies, and other funding mechanisms relevant to affordable housing in Florida. Provide insights into compliance requirements for state an...

I have a data sheet ready for a Monte Carlo Simulation assignment. An Excel expert is needed to input the formulas into the sheet and complete the assignment. A formula sheet and instructions will be provided. Key Requirements: - Intermediate level complexity for the Monte Carlo Simulation - Use of Random Sampling technique - Results presentation in both tables and charts Ideal Skills/Experience: - Proficient in Excel - Experience with Monte Carlo Simulations - Able to present data in a clear and concise manner

I'm seeking an expert in Google Sheets who can create a formula for me. The formula needs to: - Add a margin to the product price, calculated as a percentage of the cost. - Include the credit card surcharge, which is a percentage of the total. - Calculate HST (Harmonized Sales Tax) for a final grand total. Ideal candidates should have a deep understanding of Google Sheets and experience with financial calculations. Please provide previous examples of similar projects you've completed. I've attached a screen shot of what I've created so far (which isn't much) I'm having trouble with material margin, credit card surcharge which won't be applicable every time and HST to give me a total of all 3 based off the subtotal pri...

I'm in need of an Excel expert who can assist with a complex spreadsheet designed for data analysis. Key Responsibilities: - Help with analysing data using %tile rank - Potentially adding additional features to the spreadsheet Ideal Skills: - Proficient in Excel with a deep understanding of its functions and formulas - Experience in data analysis - Able to implement automation with macros, create visualizations with charts, and use conditional formatting if needed I am open to suggestions for additional features that could improve the functionality of the spreadsheet. Please provide a comprehensive proposal outlining how you would approach this project.

I need a freelancer to help with maintaining my Excel files. My datasets typically range from 1,000 to 10,000 rows. Ideal Skills: - Proficiency in Excel 365 - Data cleanup and organization - Troubleshooting formulas and functions - Macro creation and automation Experience with large datasets and Excel 365 is essential. Tasks may include data organization and cleanup. I look forward to your proposals.

I require a Microsoft Excel expert to assist with data analysis and visualization. The data is currently in an Excel spreadsheet and needs to be analyzed using descriptive statistics. Your tasks will primarily include: - Interpreting data and providing meaningful insights - Creating visual representations of the data Ideal skills and experience for the job include: - Proficiency in Microsoft Excel - Experience in data analysis and visualization - Strong understanding of descriptive statistics

...comments (and their associated data). In doing so, we ask that you create an Excel spreadsheet, a folder with video downloads, and a folder of Word documents that include the comments on each video. We provide a detailed description below. 1. Excel Spreadsheet: Please create an excel spreadsheet with the following columns. Column A: Label: “Video title” In this column, please provide the video title to match the title of the video download. For example, if you look at this TikTok video (@returnhomenor/video/7164090596796157230?lang=en), you would label the cell in this column: “Allow us to introduce ourselves!” Column B: Label: “Hashtags” In this column, please provide all of the hashtags inclu...

I am looking for a program developed to extract certain info from the body of emails arriving in a specfic mailbox, this information whould then be analysed and inserted in a excel spread sheet. The emails to be analysed will come from our customers providing a list of available haulage collections/deliveries. The emails will be in a general inbox which will also contain non transport related emails and these should be ignored. The emails are all in different formats for each customer but all should contain collection location, collection date, delivery location and delivery date. Due to every email being in a different format I am looking for an intelligent solution that can analyse the email, decide if its offering u...

We are seeking a skilled bookkeeper to assist with the conversion of our business bank and credit card statements from PDF format to Excel. This is essential for the preparation of our financial statements for tax filing purposes. There are around 290 statements, containing around 1000 pages. The ideal candidate should be detail-oriented and proficient in accounting software. Experience with financial reporting and knowledge of tax regulations will be needed. We are looking to have this done ASAP, preferably by the end of the day this week on Wednesday. If you have a strong background in bookkeeping and are comfortable working with various file formats, we would love to hear from you.

I need assistance with reformatting my spreadsheet to improve its layout and visual appeal. Additionally, I require help with performing some statistical analyses, specifically calculating means, medians, standard deviations, and variances. Ideal candidates should have: - Proficient skills in Excel or similar spreadsheet software - Experience with data formatting - Strong understanding of statistical functions and analysis

Proposed Topic for Individual Project – Development and Presentation Masters Degree Clinical Psychology Theme: Development of a data management application for didactic processes, based on a topic of your choice. The individual project consists of two modules (files): • A descriptive module (a word-processed document) • A calculation module (developed in a data processing application) The project should generally follow the structure below, tailored to the specifics of your specialization: 1. Formulation of the theme/topic, including the objectives/requirements proposed for the project. 2. Specification of the studied characteristic(s), data volume/sample size, etc. 3. Data collection (miniaturized), with sources indicated (e.g., yearbooks, surve...

...both a Word and also an Excel format. Word Format The export format contains all of the data which I have collated in my iPhone report into a lengthy and detailed report, complete with photographs illustrating each defect which I have identified and listing remedial work which I have deemed is necessary. What I require as far as Word is concerned is the following: A Macro, triggered on the click of a button, to ensure that the report is modified to suit the attached example of how I would like the report to look after triggering the Macro. All the remedial information (which is already mentioned within the report underneath each defect) is then grouped together at the end of the report (see raw data example) which I have then deleted as it is too much information fo...

Automated Position Copying on MEXC: Looking for a Developer to Create a copying Bot We are two friends who want to automate copying our positions on the MEXC platform. Below are the project details and the requirements for the bot we are seeking: Account Structure Main Account A (my account) → Secondary Account B (friend's account) Main Account C (friend's account) → Secondary Account D (my account) **Each main account could potentially have multiple secondary accounts as needed. How the System Should Work When a position is opened on the main account, it should be copied to the secondary account(s) quickly and precisely. Criteria to Follow Entry Price: Must be executed as a market order. Exit Price: Must be executed as a market order. Leverage: Use...

I'm looking for someone to handle high volume calls, assist with administrative tasks, and help solve customer issues. im looking for someone who can do and will do what we expect of them to do. Key Responsibilities: - Picking up high volume customer calls - Assisting with admin tasks (specifics are not defined yet) - Troubleshooting billing/payment problems - Offering technical support for mobile app users. - Providing product/service information for new sales and closing them. - Scheduling appointments. Ideal Skills: - Excellent communication skills - in english and be very fluent in english. - Problem-solving skills - Experience in customer service and must be able to be super friendly with customers. - Familiarity with VoIP s...

Hi there - I'll help you create a database for your invetor's information in Excel workbook. Thanks for your work!

...about creativity, sustainability, and innovation. As we expand, we’re looking for a highly organized Data Assistant to help us make sense of our numbers and stay ahead of the game. Role Overview: We’re seeking someone detail-oriented and data-savvy to gather and analyze key performance metrics across our platforms. If you have a knack for spotting trends in analytics, SEO, and social media stats, this is the perfect role for you. Key Responsibilities: Collect and organize data from Google Analytics, SEO tools, social media platforms, and email marketing platforms. Track and report on KPIs, including website traffic, social engagement, and newsletter performance. Create easy-to-digest reports and visualizations for the team. Analyze trends...

I am seeking a Zoho CRM Report expert. The task involves building a Lead Status Report and a Deal Pipeline sheet, like an excel sheet, these sheets must be able to filter by seller, will be based on data from Zoho CRM data reports and will need to be AUTOMATICALLY updated daily (access to Zoho will be granted upon hiring). The Lead Status Report should include the concepts shown in the reference screenshots. The ideal candidate will have: - Proficiency in Excel and data visualization - Proven experience with Zoho CRM - Ability to set up automated reporting systems is A MUST - Strong attention to detail - Excellent communication skills to explain the data clearly.

I'm looking for a skilled freelancer to set up a Mac and create an automated daily report from stock broker accounts. This project involves: - Using Python to extract and analyze stock data - Integrating with the broker API (specific API to be determined) - Incorporating volatility indicators (to be specified) - Ensuring the final product can be easily imported into Excel The ideal candidate should be detail-oriented and accurate in data reporting. Proficiency in Python and Excel is essential, as is experience in financial data analysis. If you can deliver reliable reports, I would love to hear from you.

I need to have my Bosch Rexroth drive ...programmed. This will involve utilizing a closed circuit feedback loop for a pump control system. The pressure sensor will be used for the feedback loop, and the control algorithm will be a PID control. Key Requirements: - Programming of Bosch Rexroth drive - Implementation of closed circuit feedback loop - Use of pressure sensor for feedback - Application of PID control algorithm Hardware: - Please note that I already have the necessary hardware for this project. Ideal Skills and Experience: - Extensive experience with Bosch Rexroth drives - Strong knowledge of closed circuit feedback loops - Proficient in programming PID control algorithms - Familiarity with using pressure sensors in...

I need an expert in Artificial Intelligence, ChatGPT, Python, Machine Learning: can be expert in any of them The job is to collect data from the internet (NOT from one particular website, but from the worldwide web in general) and populate an Excel sheet that I provide The data is about businesses, and will be used on a business website

I have a matrix where it computes the sum over some zip codes and regions and a time filter and the values are correct but also I have a second sheet where I have a bar plot but you can select a month and a region using bookmark and the sum is not correct. There might be some something small or formula to fix IN the second sheet I created some measure and the issue might be there. To work in this task it is required to use any desk.

...hit percentages for specific prop types (e.g., assists, points, rebounds, threes), and updates Airtable with the results. This program will run locally on my computer and will be delivered as an executable file .exe for windows. Key Deliverables: - A working Python script or executable that: - Retrieves data from the Odds API (player name, prop category, odds, and line value). - Filters the data based on a specific odds threshold (-400 to -1200). - Checks Airtable to avoid duplicate records (player name, prop category, and line value). - Inserts the data into Airtable if the combination of player, prop, and line doesn't already exist. - Retrieves totals for the relevant prop category (e.g., assists, points, rebounds, threes) from Airtable. - Calculates hit per...

I have suppliers I have user and password to log in then I get my special discounted prices. I want a scrpit to download detials whenever required of the all items in excel or CSV format like item code, item detials and description, item price, item stock with differnt color options mentioned.

Already i check the Attachments excel sheet and i agree client timeline and budget $15.

Same as previous jobs, payment released after all corrections

...skilled Python programmer to help me automate the order placement on Interactive Brokers. Key Requirements: - Automate the placement of Market orders, Limit orders, and Stop orders - Strong proficiency in Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my b...

I'm looking for someone to help me with a Google Sheets project. The task involves pulling mixed data (both text and numerical) from an existing worksheet and setting it up so the data is automatically pulled and sorted into a new one within the same workbook. The original date is in worksheet as an example, and I need it automatically pulled and sorted in the same format as New worksheet. I need this to be a formula so New Sheet automatically populates and sorts based on the data in worksheet. The specific requirements are: - Extracting both text and numerical data - Cleaning the data by eliminating unnecessary spaces - Listing the dates in a specified format (MM/DD/YYYY) Ideal candidates for this project should have: - Profici...

...a freelancer to build a banking NEFT challan for paying bulk transfers and payrolls in Excel Macros. Ideal Skills and Experience: - High level excel macros and VBA experience is required... Project scope: Prepare a banking Neft challan for bulk transfers and payrolls. 1. A database for vendor banking details ( infinite data feed required) 2. A database for employee banking details (infinite data feed required) 3. A payroll database , ( considering attendance , ESI & PF calculations, Salary advance, other deductions, Allowances, HRA, Salary) 4. Banking NEFT challan for vendor - button for creating print page in A5/A4 data on a company letter head based on data size 5. Banking NEFT challan for Payr...

My Excel file, which I use daily for financial data management, has become heavy and unorganized. I need it to be cleaned up and made more efficient. Key Focus Areas: - Data Organization: The main issue is the disorganization of data. It needs to be structured in a more logical and user-friendly way. - Formula Optimization: While not an explicit focus, if there are formulas that can be simplified or improved, I would appreciate your expertise. Ideal Candidate: - Extensive experience with Excel and data management - Proven track record with financial data - Skills in data organization and formula optimization - Ability to enhance the visual layout and formatting of the file - Excellent attention to detail and commitment to quality I upda...

i have a html page that has a form in it, need to create a react form similar to html. Also need to deploy the same form to my webaddress and get the inputs in the excel.

I have a rough draft of a scientific paper intended for a medical journal that requires final edits. The paper needs content restructuring, particularly in the Methods and Results and Discussion and Conclusion sections. In addition, I need assistance updating some data from an Excel spreadsheet into the paper. - Content Restructuring: Primarily in the Methods and Results, and Discussion and Conclusion sections. - Data Updating: Help needed to accurately incorporate information from an Excel spreadsheet. Ideal skills for this project include: - Strong background in scientific writing and editing - Familiarity with medical journal standards - Proficient in data handling and updating from Excel - Excellent content restr...

θέλω να δημιουργηθεί μία λίστα σε excel με τα στοιχεία από κέντρα λογοθεραπείας, εργοθεραπείας, ψυχοθεραπείας που υπάρχουν στην Ελλάδα. Η λίστα αυτή θα έχει &...

I'm in need of a proficient data entry professional who can assist with online mixed data entry. The ideal candidate should be skilled in handling both text and numerical data, and capable of sourcing the data from file uploads (e.g., PDFs, Excel). Key Responsibilities: - Accurately inputting mixed data (text and numerical) from various online file uploads into designated platforms. - Ensuring data integrity and confidentiality at all times. Ideal Skills: - Exceptional attention to detail to ensure data accuracy. - Proficiency in handling both text and numerical data. - Experience with online data entry and file uploads, particularly PDFs and Excel. - Ability to maintain data integrity and confidentiality.

I'm looking for a seasoned professional who can create a top-tier PowerPoint presentation for an upcoming investor pitch. This presentation should highlight our financial performance and incorporate expert-level Excel support and formatting. Key Requirements: - Proficiency in PowerPoint and Excel - Experience creating executive-level presentations - Ability to convey complex financial data in an easily digestible format - Understanding of investor expectations and presentation styles Please note that while specific chart types haven't been requested, your ability to create compelling visual data representations is crucial. The ideal candidate will have a keen eye for detail and the ability to present our financial performance ...

I'm seeking a skilled software developer to convert my current Excel cost estimation workbook into a fully functional, user-friendly web-based estimating software. Key Functions: - The software must perform all cost estimation tasks that the Excel workbook currently does. Additional Features: - Robust reporting capabilities: The software should be able to generate comprehensive reports on various aspects of the cost estimations. - Data export options: I need the ability to export data in different formats for further analysis or record-keeping. Ideal Skills: - Proficiency in web-based software development. - Experience with cost estimation tools is a plus. - Strong understanding of reporting systems and data export functionalities. I look forwa...

...SEO strategies. Are you looking to prioritize specific niches for your blog posts to enhance SEO outcomes? I have extensive experience in developing WordPress sites tailored for content publishing, with a strong focus on SEO optimization. My background includes successfully creating PBN sites that drive traffic and improve rankings. I am proficient in integrating essential plugins, such as SEO and social sharing tools, to boost visibility. Additionally, I excel in writing engaging, SEO-optimized content that resonates with target audiences. I ensure that every aspect, from site design to regular content updates, aligns with your overall objectives. Let’s collaborate to build a PBN that sets your content apart. I’m available for...

Make an invitation card (animated gif): 10 seconds ...daktion/ambiente/2025/images/ 2. The first 3 seconds should show this image (while the mp4 is running in the background): ambiente-date-2025.webp.1920.jpg. Replace "SAVE THE DATE" by "YOU ARE INVITED". Included the dates. 3. The next 4 seconds show the logos (while the mp4 is still running in the background) 4 The first 3 seconds should show this image (while the mp4 is running in the background): ambiente-date-2025.webp.1920.jpg. Replace "SAVE THE DATE" by "WELCOME TO OUR BOOTH HALL 8.0 D19" HALL 8.0 D19 in fat script. the date can still be mentioned. Do NOT include the dates. 5. Must be infiinite loop Supply 4 files: 1. animated gif small (for at...

I need a selenium-style program that extracts data from regarding past odds from Bet365, Unibet, and Betway. The data must be formatted in XML before I convert it into an Excel file. Data Requirements: - Odds history - Match results - Betting trends Sports: - Football Ideal Skills and Experience: - Proficiency in Python and Selenium - Previous experience in web scraping, particularly from betting sites - Familiarity with XML formatting - Understanding of football betting data. Please note, I can manually download the necessary pages. Your task is to write a program that automates the data extraction process.

...almacenarse y ser accesibles para los administradores. Funcionalidad del administrador: Los administradores deben poder visualizar y gestionar los horarios de entrada y salida de todos los empleados, agregar nuevos usuarios y modificar los permisos de cada uno. La parte de configuración con las terminales debe ser lo mas simple posible. También deben poder exportar los datos en un formato compatible con Excel. Funcionalidad del empleado: Los empleados deben poder modificar su perfil (nombre, foto, avatar) y consultar un resumen de sus horas trabajadas (diarias y mensuales). Requisitos adicionales: La interfaz debe ser amigable, visualmente atractiva y funcional, utilizando principalmente iconos para facilitar la navegación. Debe incluir un panel de contro...

...store that sells white-label AI SaaS products for estate agents is a strategic and exciting venture. Here’s a step-by-step guide on how to get started: 1. Define Your Product Offering • Identify Core Products: Decide which AI-powered tools are most valuable to estate agents (e.g., property valuation tools, lead generation systems, chatbots, CRM systems, virtual tour solutions). • Customization: Ensure the products are white-labeled, allowing clients to brand them as their own. • Subscription Plans: Offer tiered subscription plans to cater to different business sizes and needs. 2. Platform Development • Choose a Platform: Use a scalable e-commerce platform like Shopify, WooCommerce, or custom development using frameworks like Laravel or Node.js f...

We require CFD simulations to analyse the performance of a soda lime CO2 absorber, which is used to scrub CO2 from exhaled breath in a closed breathing loop. This one-time project aims to improve our understanding of the absorber's performance and lifespan by addressing airflow dynamics, pressure loss, and chemical reactivity. CAD geometry will be provided.

I'm in need of a professional data scraper who can extract text content and images from a specific website and save it into a CSV file. This is a one-time project with no need for data processing or cleaning before saving. Ideal Skills: - Web scraping - Data extraction - CSV formatting - Image handling Please note, I require the raw data to be saved without any modifications. please save; URL LINKS and all item information into columns / tabs in a csv excel file, or google spreadsheets file. we are scraping from here; in Japanese. CARDLIST｜ONE PIECEカードゲーム公式サイト｜ワンピース

أبحث عن مساعد افتراضي بسيط، نصف دوام، في دولة ناطقة باللغة العربية. يجب أن يكون لديه خبرة في التعامل مع Monday و Excel.

I'm looking for a data entry expert to manually input data from printed documents into Excel sheets. Requirements: - Proficient in Excel - Excellent attention to detail - Able to work with printed documents Your task will primarily focus on manual data entry, requiring a high level of accuracy and efficiency. Ideal candidates will have prior experience with data entry and a proven track record of meeting deadlines.

i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. ...ANY CRYING OR ABUSE WILL NOT BE TOLERATED ALL I AM AFTER IS FAST HIGH QUALITY WORK FROM A PROFESSIONAL. IF U CANT DO IT DONT APPLY. REMEMBER IM HIRING YOU COS I DONT HAVE THE TIME TO DO IT MYSELF. I CAN DO THESE IN MAX 3 HOURS PER SHEET. 1 SHEET ON AVERAGE SHOULD TAKE 3 HOURS. LATE WORK WILL BE PAID AT A REDUCED RATE AND ALSO ANY MISTAKES MUST BE ELEMENTARY. WORK MUST BE ALMOST PERFECT ON FIRST DRAFT AND PERFECT ON SECOND DRAFT OR PAY WILL BE REDUCED. DO NOT DEMAND PAY FOR WORK FULL OF ERRORS IF I SAY THE WORK IS POOR THE WORK IS POOR. I NEED SPEED AND ACCURACY IF YOU ARE UP FOR THE JOB AND HAVE A POSITIVE RESPECTF...

I'm looking for a Python Colab specialist who can assist with automating report generation which include external APIs connection. This project primarily revolves around producing doc/ Excel reports. Key Requirements: - Expertise in Python and Google Colab - Proven experience with automation tasks and connection of external APIs - Proficient in generating Doc/Excel reports Your role will involve automating the process of report generation in Python Colab, specifically creating Doc/Excel reports. Ideal candidates will have a keen eye for detail and the ability to streamline this process for efficiency.