Excel vba function return blank cellprojekty

...What You’ll Do: • Access the Funnelr platform to replicate: • Course structure and videos. • Email follow-up sequences. • Sales pages. • Recreate these elements in Go High Level, including: • Building the course structure. • Uploading videos. • Setting up email workflows and automation. • Rebuilding sales pages. • Test the system thoroughly to ensure: • Email sequences and workflows function correctly. • Sales pages and course delivery are error-free. • Provide a brief handover document for reference. What We’re Looking For: • Proven experience with Go High Level (course creation and automations). • Familiarity with migrating systems from other platforms like Funneler. • S...

I need a comprehensive financial model for a rental office building in northern Riyadh. The building has 3.5 levels with a grade in the basement. The model will cover a time span of 20 years and should contain: - Detailed Profit & Loss (P&L) statements - Cash Flow Projections - Return on Investment (ROI) calculations - Net Present Value (NPV) analysis - Sensitivity analyses to gauge potential variations in outcome - Debt/Equity The most crucial metric for this project is the Return on Investment. I do not have pre-existing data or projections, so the model must be developed from scratch. Ideal skills and experience for this project include: - Extensive understanding of financial modeling - Experience in real estate investment analysis - Proficiency in using finan...

I'm looking for a skilled developer to create a Telegram bot. This bot's main function will be to assist in creating sales orders directly within Telegram. Key Requirements: - The bot should be able to collect customer details and product details in the sales order creation process. - The bot will interact primarily with Telegram, as that is the platform for managing sales orders. - Experience with bot development on Telegram is a plus. - An understanding of sales order processes would be beneficial. Ideal Skills: - Proficiency in Python or Node.js (commonly used for Telegram bots) - Experience with Telegram Bot API - Knowledge in sales order systems

I'm in need of an Excel expert to assist me with a data transfer task. This involves pulling information from one spreadsheet and adding it to a column in another. Key Tasks: - Transfer of text data from one spreadsheet to another - Matching of data based on an exact match in a single column - Formatting of some data during the transfer The data in the spreadsheets is a mix of both specific categories and plain text columns, and there are more than 1000 rows that need to be transferred. Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks - Ability to perform basic data formatting and transformation

I'm in need of a very simple Java program that I can deliver in the next 5 hours. The program's primary function will be handling text files, specifically performing both reading and writing operations. Key Requirements: - The program must be able to read and write to text files. - The program should be designed based on slides I will provide. - Must be delivered within a strict 5 hour time frame. Ideal Skills: - Proficient in Java programming. - Experienced in file handling operations. - Able to work under tight deadlines.

I'm looking for a freelancer who can compile a comprehensive list of stock codes for all companies per year from the specified website - A spreadsheet should be created with a tab for each yea...from Yahoo finance. For example, where the company name is Apple, I would expect the code AAPL to be returned. The specific requirements are: - The stock codes should be taken from Yahoo Finance - The data should only include the stock codes, not historical data or current status. - The final deliverable should be in an Excel file. Ideal skills and experience for the job: - Familiarity with stock exchanges and their coding systems. - Proficiency in data compilation and Excel. - Attention to detail for ensuring accuracy of stock codes.

I'm seeking assistance to extract data from a conference website. The task involves gathering information on all attendees and their respective companies. Key Requirements: - Extract a list of attendees and their in...attendance (one column: Company). The data needs to be extracted from a publicly accessible section of the conference website. The task needs to be completed before noon EST on January 21st. I will make a decision on whom to select by 9:00pm EST on January 19th. Ideal Candidate: - Previous experience with data extraction and web scraping is preferred. - Proficient in using tools like Python, Excel, or any other data extraction software. - Attention to detail to ensure accurate data collection. Successful execution of this project may lead to future work on a...

I'm encountering multiple error messages when trying to access a Firebase Cloud Function from my web app. These errors appear when I attempt to call the function, and they vary depending on the implementation I'm trying. Ideal candidates for this project should have: - Extensive experience with Firebase and Firebase Cloud Functions - Strong debugging skills - Ability to simplify complex technical issues - Knowledge of common Firebase-related error messages - Experience with front-end web development

I have an Excel database consisting of 100,000 records of loan requests along with their acceptance status. I need a freelancer with strong expertise in Python, data manipulation and AI to develop an AI model that will evaluate new loan requests and predict their approval status based on the training from this dataset. Key aspects of the project: - Data Preprocessing: The data will require normalization, handling of missing values, and feature extraction. - Model Development: Using Python, you'll build an AI model to train on the database. - Prediction: The model will assess new loan requests and indicate if they should be accepted or rejected. The ideal candidate will have extensive experience with AI model development, and will be proficient in Python, and data manipulati...

Je evous contacte pour automatiser une tâche sous Excel. Celle ci n’est pas très complexe je pense ! J’ai un planning à tenir, avec des dates pour le projets initiales et je veux automatiser les dates de l’en-cours ! J’ai une date de départ, plusieurs actions a faire sur une pièce mécanique qui dure plus ou moins longtemps, de 1 jours à plusieurs semaines, avec 1 date intermédiaire qu’il me faut tout de suite définir puisque je dois réserver un équipement. Plus tôt il est réservé, mieux ça vaut. Les dates de l’en court peuvent changer régulièrement, en fonction de l’avancement réel contrairement au planning initial qui...

I'm looking for an expert in Excel to help me create a special spreadsheet that will collect and organize vital customer information. This project will involve detailed manual data entry. Key Requirements: - Collecting customer contact details (name, phone, email) and purchase history. - Organizing this data in an efficient and easy to understand manner in Excel. Ideal Skills: - Proficiency in Microsoft Excel. - Excellent attention to detail for data accuracy. - Experience with data entry and data organization. - Good understanding of customer data and purchase history. Please note, the data will need to be entered manually, so patience and diligence are essential for this task.

i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. call required before offering job to go over important details of the job NO EXCUSES POOR QUALITY WORK WILL NOT BE PAID 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 T...

El proyecto es para entregarse en dos horas no busco persona improvisando Presupuesto 8 dólares Hola. Necesito el apoyo para hacer una hoja de cotización funcional en excel, pero con el diseño de imagen corporativa .png / .jpg colocada como fondo. El diseño corporativo de la hoja membretada ya la tenemos y abierto a sugerencias para una mejor solución.

...Explore the methods and processes involved in the fabrication of nanomaterials and their implications for material science. - Mechanical properties of nanomaterials: Analyze the unique mechanical characteristics of nanomaterials and how they differ from their macro counterparts. - Types of optical nano biosensors: Identify and characterize various optical nano biosensors, discussing their design, function, and relevance to material science. Given the complexity of these topics, the report should provide an in-depth analysis rather than a high-level overview or intermediate depth discussion. Ideal Skills and Experience: - Extensive knowledge and background in material science and nanotechnology. - Proficiency in research and report writing, specifically in producing in-depth an...

I'm looking to build a comprehensive e-commerce site, ideally using a React.js Backend with a Tailwind front end, or PHP/Laravel. The site needs to have several key features including: - Shopping functionality - UPI payment integration - WhatsApp API integration - Ability to upload products via CSV/Excel sheets - User recommendation form connected through WhatsApp API for scheduling meetings I would prefer MySQL as the database for this project. The admin panel should specifically allow me to manage product inventory. User accounts will use standard email/password, social login authentication. New freelancers are welcome to bid, but you need to demonstrate your skills or provide a detailed plan on how you intend to execute this project. Please share any relevant projects yo...

I'm in need of a comprehensive database containing contact information for Real Estate Professionals (Agents and Brokers) associated with @properties, covering all cities they operate in. The data should be structured in an Excel spreadsheet and must include: - Name - Address - City - Email (Any email addresses available) - Phone number - Company name Key Requirements: - I'm looking for as many contacts as possible, ideally in the thousands. - The email addresses do not need to be verified, but any available email is acceptable. - Prior to engaging in further conversation, I would like to see at least 10 examples of the data you've gathered. Please note that this task may be straightforward for those experienced in data scraping. A successful completion of this pro...

...capturing consent, and storing anamnesis data. The app should be tailored for use in dermatology and cosmetic surgery primarily. Key Features: - Ability to save and compare before/after pictures from various angles side by side. - Digital forms that can be filled out, signed and saved in a patient-specific directory. - Local storage for patient data, ensuring confidentiality and security. - An email function to send signed documents and pictures to clients. - A modern, user-friendly, and responsive UI suitable for all tablet sizes. - An integrated backend for administration within the main app. - Simple username and password authentication for users. Ideal Skills and Experience: - Proven track record of developing cross-platform mobile apps. - Experience in creating secure, us...

I'm looking for a professional to create an Excel workbook that tracks inventory, allocated inventory and available to sell. I would like one page to be a dashboard with highlights and the other tab to be the details. Key Metrics: - Current stock levels for multiple products - Low Stock reorder alert - Inventory valuation - Allocated and available to sell Ideal Skills: - Advanced Excel skills - Experience in creating dashboards - Understanding of project tracking and inventory management This dashboard will assist me in managing my project's resources efficiently. Please only apply if you have the required skills and experience.

I'm looking for a skilled developer to extract the API from my Mobcash application and connec...Responsibilities: - Extract and connect the Mobcash API to a customer service bot. - Implement functionalities enabling the bot to provide account information, specifically transaction history and account status. Ideal Skills: - Strong experience in API integration. - Proficient in bot development for customer service. - Prior experience with financial transaction applications is a plus. The primary function of the bot will be to provide customer service. It should be able to supply users with specific account information including their transaction history and account status. This project will require a detail-oriented professional who can ensure the bot delivers accurate and time...

I'm looking for a proficient web developer to create a user-friendly, web-based portal for project collaboration, which will replace my current cumbersome Excel sheet system. The primary goal is to streamline the process, enhance collaboration and make the project management more efficient. Key Requirements: - The portal should replicate the collaboration and comments features from my Excel sheets. This involves creating a space for team members and clients to leave feedback, ask questions and contribute to the project. - Incorporate task assignment and tracking capabilities. I want to be able to delegate tasks and monitor their progress within the portal. - Implement an admin and user role access control system. As the project owner, I need to have full control over th...

Hi everyone! I’m working on a project for the Medical Education Technology Center (MITC), focusing on analyzing simulation events scheduled from 01.08.2023 to 31.01.2025. We’re using the “SimPlan” calendar to manage events, but I need help organizing a...instructor and venue utilization, including peak hours and percentage of usage. Understand student participation across different events and semesters. Compare growth in event frequency and duration between Fall 2023 and Fall 2024. Identify trends like most/least attended skill groups and time spent on events with keywords (e.g., “excursion,” “first aid”). If you have expertise in data analysis, Excel, or tools that can help process and visualize this type of information efficiently, I...

I'm in need of a professional who can assist with reformatting my bank transaction CSV file for QuickBooks import. Key Requirements: - Reorder columns of the CSV file to meet QuickBooks' requirements. - Ensure the final CSV includes D...in need of a professional who can assist with reformatting my bank transaction CSV file for QuickBooks import. Key Requirements: - Reorder columns of the CSV file to meet QuickBooks' requirements. - Ensure the final CSV includes Date, Description, and Amount columns. - Amounts must be appropriately sorted into separate columns for positive and negative amounts. Ideal Skills: - Proficiency in Excel is a must. - Previous experience with QuickBooks and CSV file formatting is highly preferred. - Attention to detail to ensure all data...

Acadmic Function

I'm in need of a professional who specializes in Excel VBA and Outlook email automation. I have made some experimental progress but I am currently stuck and would appreciate assistance in troubleshooting my existing code and learning basic coding concepts. The specific tasks required include: - Automating email generation from specified Excel worksheet cells on a schedule based on corresponding dates in other cells. - Incorporating specific types of content into the body of these emails, including text and hyperlinks. - Assisting me in understanding and learning basic coding concepts. Ideally, you would have extensive experience with Excel VBA and Outlook, and be able to explain concepts in a clear and understandable manner. Your role will not only...

I'm seeking a comprehensive list of 70 rent-a-car companies in Dubai, specifically their CEO and Managing Director contact details. The final deliverable should be an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data collection and research - Experience in creating comprehensive, accurate spreadsheets - Understanding of corporate hierarchies, particularly in the transport and rental sectors Please ensure the information is current and accurate, as this will be crucial for my project. Thank you.

I'm in need of a competent research article writer with proficient statistical analysis skills to help me compose a paper suitable for publication in a high-ranking Scopus journal. Key Requirements: - The article should focus on the field of Management - Expert knowledge of advanced statistical tools such as Cross-Correlation Function (CCF), regression, and Structural Equation Modeling (SEM) is a must - Ability to work with both primary and secondary data - Experience with writing for and publishing in highly reputed journals Ideal Skills and Experience: - Strong background in management research - Proficiency in using advanced statistical tools - Experience with both primary and secondary data - Prior experience with writing for Scopus journals The article is expected to b...

I'm experiencing an issue with a combobox in my MS Access database. It's directly bound t...experiencing an issue with a combobox in my MS Access database. It's directly bound to TableA and supposed to select entries from Column A. When an entry is found, it should concatenate Column A and Column B and insert the result into Column C in TableB. However, my VBA code keeps throwing an 'Entry Not Found' error, even though I have confirmed all entries are in TableA and all formats are correct. Key Tasks: - Troubleshoot the combobox issue - Optimize the AfterUpdate VBA code I need a freelancer with strong skills in MS Access and VBA, who can help fix this issue and ensure the combobox can correctly select entries from TableA. Please note, I am no...

My multi-function printer is experiencing issues with ink cartridges jamming. This problem occurs specifically when I am replacing the ink cartridges. I need an experienced professional who can diagnose the issue and provide a solution to prevent this from happening in the future. Skills in printer repair and maintenance, particularly with multi-function printers, would be ideal for this project.

I'm seeking a web developer to create a simple .org site for nonprofit organizations. The primary purpose of the website is to facilitate donations. Key Features: - A homepage that clearly presents our mission statement and goals. (gallery, articles) - A robust and user-friendly donation function with options for bank cards, paypal, stripe, cryprocurrencies (optional, but preferred) - A recurring donation option - Suggested donation amounts - A feature for sending personalized thank you messages (optional) - A small eCommerce section for T-shirts, and smaller fan articles (optional) Skills and Experience: - Proficiency in web development, specifically for nonprofit organizations - Experience in integrating secure and effective donation systems - Ability to cr...

I'm seeking a developer to design a comprehensive Point of Sale (POS) software suitable for both retail and wholesale businesses. The software needs to support both desktop and mobile platforms, with the desktop version specifically designed for Windows operating systems. Key requirements: - Cross-platform compatibility: The software should function seamlessly on both mobile and desktop platforms. The desktop version should be exclusively compatible with Windows. - Multi-payment method support: The software must support a range of payment methods, including Credit/Debit Cards, Cash, and Digital Wallets. Ideal candidates for this project should have extensive experience in software development with a strong emphasis on POS systems. A deep understanding of cross-platform compat...

Presupuesto 8 dólares Hola. Necesito el apoyo para hacer una hoja de cotización funcional en excel, pero con el diseño de imagen corporativa .png / .jpg colocada como fondo. El diseño corporativo de la hoja membretada ya la tenemos y abierto a sugerencias para una mejor solución.

I'm looking to create a dedicated website for publishing CSR (Corporate Social Responsibility) projects aimed at NGOs. This platform will function as an e-tender/RFP bid inviting site. Key Features: - Project Listing and Categorization: The primary function of the website will be to list various CSR projects. These listings need to be well-categorized to facilitate easy navigation and discovery for potential bidders. - User Roles: The website will cater to three distinct user roles - NGO Administrators (who can propose and manage CSR projects), Corporate CSR Managers (who can bid on projects), and General Public Viewers (who can monitor the proceedings). - User Authentication: Access to the website will require a simple email and password login. No complex authenticat...

...been able to solve part and need assistance in part 2 and 3. We will use the Dhan broker’s API to execute and manage trades and here is the there documentation link If you are unable to access I can share relevant information on your request through chat message. Here is the flow of how we need to build this code. Get the list of entries details from the exiting function. Prepare and send order details to dhan through API. From entry details we get the most of the details on what instrument to enter in to but price is something we need to cater realtime. For this we need to use api request and response. From the response we need to gather the best i.e. first sell price as ‘price’ to enter and calculate

I'm seeking a dedicated individual to filter and provide me a list of 2000 Instagram influencers. The goal is to identify suitable partners for a drop shipping venture who can make a promotional video of a product. Key Requirements: - Influencer...who can make a promotional video of a product. Key Requirements: - Influencers should have between 1,000 followers - The primary content category of these influencers should be related to drop-shipping. An ideal candidate for this project would be someone with a keen understanding of the drop shipping industry and experience in influencer marketing and expert in filling and filtering data in Excel. Skills in social media analysis and data filtering will be highly beneficial. Please be prepared to demonstrate your ability to meet ...

I'm looking for a professional who can assist me with updating my company's yearly requirements on the MCA Portal in India. This includes filing the Annual Return, submitting Compliance Certificates, and managing the change of a director. Key Tasks: - Update Annual Return Filing and Compliance Certificate on the MCA Portal - Change of director: replace the resigned director with a new one - Check and advise on Taxation requirements - Determine the type of Compliance Certificate to be submitted The ideal candidate for this project should have: - Extensive experience with the MCA Portal - Strong understanding of Indian corporate law and taxation requirements - Excellent attention to detail - Good communication skills to explain necessary procedures and requirements

Proposal and Proof of Work Requirements for Dynamic Excel Sheet Development We are seeking an experienced Excel developer to create a dynamic, visually appealing, and proprietary tool for our loan officers. This tool will enable our team to present purchase and refinance scenarios to clients, offering detailed calculations, comparisons, and insights. It should reflect Cohen Mortgage branding, include precise mortgage insurance premium calculations for different loan programs, and be protected to maintain its proprietary nature. Project Scope and Features: 1. User Data Entry Inputs: - Property address - Purchase price - Down payment percentage - Loan amount (calculated automatically) - Interest rate (fixed or adjustable options) - Loan term (e.g., 15, 20, 30 years) - Loan P...

I need an Excel Catalogue converted into a visually appealing, professional PDF Catalogue for customer showcase, print and online publication. Key Requirements: - Transforming an Excel Catalogue into a PDF - Designing a professional and formal layout - Incorporating product images, detailed descriptions, and pricing information - Image high resolution Ideal Skills: - Proficient in Excel and PDF design software - Excellent graphic design skills - Experience in creating product catalogues Please only apply if you can demonstrate a strong portfolio in similar projects. The file work on is in this google drive link: Please give me your best quote

I'm working on a fun project using a load cell to measure the weight of medium-sized objects (kilograms to tens of kilograms).

TRYING TO GET YOU PAID FOR THE WORK ALREADY DONE

Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.

I am looking for a Python developer who is also proficient in Pine Script, as I need the developer to create two Python functions. The first function is for BOS_CHOCH, and the second is for Order Block. These functions are derived from LuxAlgo's SMC Pine Script code. I will explain the details further in messages. Please bid only if you are familiar with Python, Pine Script, and the basics of Smart Money Concepts..

I'm seeking a beginner-level assistant for my regular work. Your primary tasks will involve conducting research and creating simple PowerPoint presentations on given topics. Key Responsibilities: - Researching topics and creating simple PPTs - Managing existing team, project and content in excel or in team management app Skills and Experience: - Proficiency in Excel and PPT and notion or project management software Ideal Candidate: - A college student with a working computer - Looking for long-term work - Flexible with working hours Please note: - We will connect over a call on Saturdays or Sundays for planning and learning sessions.

I'm seeking a Power BI expert to create a simple model from a small dummy dataset which will be provided. Need this completed as soon as possible. The model should generate reports for trial balance, cash flow, balance sheets, and P&L from a small dummy dataset in Excel which will be provided. Key Requirements: - Create visually appealing and informative reports using charts and tables. - Highlight specific metrics and KPIs, namely revenue growth, net income, and cash flow status. Ideal Skills and Experience: - Proficiency in Power BI, with a strong portfolio of similar projects. - Excellent understanding of financial metrics and reports. - Ability to create engaging visual elements.

Update the Products weight on my website from the Provided Excel file.

Excel VBA Macro Debugging - Compiler Error Fix I'm encountering a compiler error while running a macro in Excel VBA. The macro is primarily designed for data manipulation and includes various functions. I need assistance to diagnose and fix this issue so the code can run without errors. Ideal Candidate: • Extensive experience with Excel VBA and macros. • Strong troubleshooting skills to resolve compiler errors. • Proficiency in data manipulation using macros. • Ability to maintain existing code functionality while fixing errors. Important Instructions (Read Carefully): 1. To Be Considered: You must resolve the error and provide the complete, functional code. I will test the code, and payment will only be made if it work...

...harmony to visibly reduce the appearance of fine lines, wrinkles, and age spots. Your complexion will be left with a smooth, luminous finish that exudes timeless beauty. 4. Key Ingredients:- Golden Orchid Extract: Rich in antioxidants, this rare extract nurtures and revitalizes, leaving your skin feeling velvety soft and radiant. Botanical Stem Cells: Stem cells derived from rare plants help stimulate cell regeneration, promoting a youthful, refreshed appearance. Hyaluronic Acid: Infuses skin with intense moisture, creating a plump, dewy finish. 5. How to Use:- Gently apply a few drops to your face and neck after cleansing. Massage in upward motions for optimal absorption. For best results, use morning and night as part of your skincare routine. 6. Packaging:- Presented in a slee...

...harmony to visibly reduce the appearance of fine lines, wrinkles, and age spots. Your complexion will be left with a smooth, luminous finish that exudes timeless beauty. 4. Key Ingredients:- Golden Orchid Extract: Rich in antioxidants, this rare extract nurtures and revitalizes, leaving your skin feeling velvety soft and radiant. Botanical Stem Cells: Stem cells derived from rare plants help stimulate cell regeneration, promoting a youthful, refreshed appearance. Hyaluronic Acid: Infuses skin with intense moisture, creating a plump, dewy finish. 5. How to Use:- Gently apply a few drops to your face and neck after cleansing. Massage in upward motions for optimal absorption. For best results, use morning and night as part of your skincare routine. 6. Packaging:- Presented in a slee...

...create a sleek, modern and clean e-commerce website for selling physical products. This website should embody simplicity and sophistication, with an intuitive interface that enhances user experience. Key Features: - Product Reviews: The website should allow customers to leave reviews on products, fostering a sense of community and trust. - Search Functionality: An efficient and easy-to-use search function is crucial for helping customers find what they need quickly. - Shopping Cart: A seamless shopping cart experience is essential, ensuring customers can easily manage their purchases. Ideal Skills and Experience: - Proven experience in designing e-commerce websites. - Strong portfolio of modern, clean web designs. - Familiarity with implementing product review systems, search f...

I'm seeking a talented interior designer to help with the design of my entire new home. I have a strong preference for a modern style, characterized by clean lines, minimalism, and a keen attention to function and form. I like plane interior with wooden around. Ideal candidates should have: - Relevant experience in designing modern interiors, particularly for entire homes. - A portfolio of previous work that showcases their ability to balance aesthetics with practicality. - Excellent communication skills to understand and interpret my vision. - A knack for innovative and functional design solutions. I'm looking for a professional who can transform my new house into a stylish, modern home.

I'm in need of a follow-up assistant to call prospects we've quoted to see if they have reviewed the quote or have any questions as well as previously recently cancelled policies to help a small agency. A sales background, particularly in the insurance industry is a p...Prior experience in the insurance industry is a must, with a focus on commercial insurance being a plus. - Exceptional communication and persuasive skills - Ability to handle follow-ups in a professional & timely manner Your role will involve reaching out to potential clients, promoting our commercial general liability insurance offerings and working towards having cancelled previous policies return to quote & eventually re-writing those sales. Please showcase your relevant experience and or past...