Freelancing for data analysis jobs

...looking for a skilled Python developer to combine around 1000 XLSX files into a single one. I need this new file to contain all the data from the original files. The Excel files have a structure where each file contains data for a different entity. The end goal is to have all this data centralized into a single document for easier management and analysis. The successful freelancer for this project should have: - Proficiency in Python, particularly in working with Excel files. - Experience in data manipulation and consolidation. - Strong attention to detail to ensure that all data is accurately captured and combined without loss. Please provide examples of your previous work in Python, particularly relating to d...

I am in search of a proficient data fusion expert to create an advanced algorithm for detecting stress levels in individuals. This will require the fusion of video, sensor, and audio data modalities. The project (should not have any plagiarism) specifically requires: 1. Development of an algorithm for the web platform. 2. Effective use of all three modalities: - Video data: The algorithm should accurately analyze changes in facial expressions. - Sensor data: It needs to detect and interpret irregularities in sensor data. - Audio data: Should be capable of identifying distortions or anomalies in audio data, which may indicate stress. Ideal freelancers for this project would be those with prior experience in ...

Need help of research writer / rewriter to rewrite the content of paper The style of the paper seems incoherent and uneven due to the contribution of multiple authors. You should be able to create a logical link between...expert, you must understand the above-mentioned requirements in bullets that represent the required outcome.  Use of AIs (ChatGPT, Wordtune…) is allowed until it's not detectable (As AI generated) by plagiarism detection software. *** You will not get paid if the content is caught for AI and/or plagiarism.  References should be retained in place and the ideas, concepts and analysis must not get distorted, changed or transformed. Word Count: 7000 Pages: 25 Budget: $100 ** You MUST be available for a short test / trial before ...

...TikTok is a critical element of our sales strategy. Your role will include: - Setting up the TikTok shop, ensuring it's streamlined, user-friendly, and reflective of our brand. - Managing product listings with an eye for attractive presentation and accurate product information. - Optimizing our sales strategy on TikTok for the young adult demographic to maximize reach and conversion rates. - Developing an affiliate program and promotions to incentivize regular customer interaction and shopping. - Driving sales growth through actionable strategies, regular performance analysis, and improvements. The perfect candidate will have in-depth knowledge of e-commerce sales optimization on social media platforms, particularly TikTok. Experience in affiliate marketing, ...

My company's system, , is designed for data analysis and reporting. The system was set up less than a month ago and was functioning as expected. However, 10 days ago, it suddenly stopped loading properly, without any changes being made to it or its environment. The primary issue to be resolved is the system not loading. It's crucial that this is fixed promptly to restore our ability to analyze and report data effectively. Furthermore, you must connect the online version to the desktop version residing in server. In other words, when the user clicks the online top, the desktop version starts working including all the functionalities. (local printer .......) Key requirements include: - Identifying the root cause of the loading issue - Resolving th...

I am looking for an experienced Data Entry Operator for a specific task. The main purpose of this task is to help organize our customer database. Apart from entering data, the operator should ensure that sensitive customer details are properly handled with care and confidentiality. To apply: * Present a detailed project proposal that shows you have fully understood the requirements of the job. Ideal Skills and Experiences: * Proven data entry work experience. * Sensitive to data privacy issues. * Strong attention to detail. * Proficient with Microsoft Office and data programs. Please note: data migration or data analysis is not needed for this role. The focus is on data organization. Let’s ma...

I'm in need of a capable finance professional with expertise in preparing financial statements to create both an income st...basis. The statements should conform to the International Financial Reporting Standards (IFRS). Key Responsibilities: - Develop an income statement and balance sheet for the quarter in line with IFRS requirements Ideal Skills and Experience: - Strong background in finance and accounting - Previous experience with IFRS and financial statement preparation - Detail-oriented and proficient in financial analysis and reporting - Ability to meet stringent deadlines and deliver high-quality work Please provide evidence of similar work completed in the past. I am looking for someone who can meticulously organize my financial data into clea...

I'm looking for a comprehensive research and writing expert in the field of fusion energy. I need this project to cover a range of specific areas within this topic, including current research and development, potential applications and an overview of companies and supply chain companies related to fusion energy. Key deliverables include: - A minimum of 10 research papers and articles that showcase the current state of fusion energy research and development - Analysis of these findings with a focus on key insights and future outlooks - An in-depth review of the potential applications of fusion energy Ideal skills and experience for this job include: - Strong background in physics, ideally with a focus on energy - Prior experience in scientific research and writin...

I'm in need of a compiler designed for Java with an emphasis on semantic analysis. I'm looking to have this compiler generate executable code. Key Points: - Programming Language: The compiler should be designed for Java. This means it should be capable of processing Java code and generating the corresponding executable code. - Semantic Analysis: The primary focus of the compiler should be on semantic analysis. It needs to be able to analyze the meaning of the code rather than just its syntax. - Output Format: The final output of the compiler should be executable code. This means that the compiler should be able to translate the Java code into machine-readable instructions that can run on a computer. Ideal Skills and Experience: - Proficiency ...

I need an expert who can perform a detailed competitor analysis for me. I need the Moz domain authority of 395 URLs in a CSV file. Key requirements: - Calculate Moz domain authority for 395 URLs - Deliver the data in a CSV file - Provide a detailed competitor analysis Skills and experience needed: - Strong understanding of SEO and competitor analysis - Proficiency in using tools like Moz Pro, SEMrush, or any other suitable tools for this task - Ability to deliver actionable insights based on the data gathered The ideal candidate should be able to provide me with a comprehensive overview of my competitors based on the domain authority of their URLs. Please include any relevant experience you have in your bid.

Chemical Regression Analysis of Chemical Molecules to predict the molecules charges.

I'm looking for a proficient academic statistician to help design my dissertation on Behavioral Science - specifically focusing on the mediating effect of shame. Requirements: - General understanding of Social Sciences - Excellent methodology design - Able to work and deliver assistance ASAP Responsibilities: - Support in project design, ensuring that the proposed study tackles the main research question effectively. - Offer critical feedback and recommendations on theory application, methodology, and data analysis plans. Ideal Qualifications: - Proven experience in academia or research production, preferably within Behavioral and Social Sciences. - Expertise in analyzing human behaviors, decision-making processes, and reactions such as shame desired but not a...

Hi hassanarshad92, You did a nice job on that last project and I was wondering if you were interested in a Book Analysis report? I can send you details if you'd like.

I need a skilled data analyst to work on a large dataset in Excel. Key Responsibilities: - Sorting and filtering data: The dataset contains over 10,000 rows, so the analyst must be adept at handling large data sets. - Creating pivot tables: Organizing data is a key step in our data cleaning process. - Performing Statistical Analysis: Appropriate statistical analysis will be crucial for accurate data cleaning and preparation. Ideal Skillset: - Proficiency in Excel: The freelancer must have extensive experience working with advanced Excel features and handling large datasets. - Data Analysis Skills: The individual should be well-versed in data analysis techniques, including statistical analysis...

I'm seeking a skilled individual to assist me with interpreting a statistics paper that involves mixed methods data. Ideal qualifications: - Intermediate level of expertise in statistics - Proven experience with data interpretation - Familiarity with mixed methods data analysis - Ability to effectively communicate statistical concepts The project involves: - Analyzing and interpreting data from various sources - Identifying key trends and patterns in the data - Clarifying complex statistical ideas and methods - Potentially providing some guidance on enhancing the paper Your help in breaking down the data into understandable insights will be crucial to my project's success. Looking forward to working with you on this.

I'm seeking a professional to help me enhance the organic traffic on my Ecwid-based website. Th...professional to help me enhance the organic traffic on my Ecwid-based website. This project involves a comprehensive SEO analysis, targeting the following areas: - Identifying and fixing technical issues for optimal SEO performance. - Enhancing on-page SEO through effective content optimization. - Improving off-page SEO by boosting backlinks. - Optimizing technical SEO elements including site structure and mobile responsiveness. Ideally, you should have experience with Ecwid, proven expertise in SEO analysis, and a successful track record in enhancing organic traffic for websites. Your attention to detail and ability to recommend and implement actionable stra...

I have expertise on spss and statistical analysis.

Hello, i will attach one file which shows what needs to be done. last digit for student code is 4 Obviously i have 4 samples with how work should be done. Which can be provided if you want

I am in need of an Excel form that will track data and facilitate scheduling. This will primarily be used by our administrative staff, so ease of use and clarity are paramount. Key Requirements: - The form will need to provide a user-friendly interface for entering data. This should be intuitive and easy for administrative staff to use without any advanced knowledge of Excel. - The form should also be capable of performing calculations based on the data input. These calculations are central to the purpose of the sheet, so they must be accurate and reliable. - Data should be stored across multiple tabs for organizational purposes. This will help ensure that the data remains clear and easy to access as the form is used over time. Idea...

...freelancer for my project, I need someone who can competently carry out data entry tasks from both image and PDF files into MS Word and Excel. I prefer someone who can guarantee timely submissions without compromise on quality. The tasks will entail re-writing the data according to a custom layout where you'll provide your unique approach to input. Yet, you will also be required to maintain the data's integrity. Moreover, your service should extend to performing basic data analysis after the data entry process. You will need to understand the data, conduct rudimentary analysis, and provide meaningful insights. Ideal Skills and Experience: - Proven experience in data entry tasks - Proficiency in MS Word and Exce...

Need help of research writer / rewriter to rewrie the content of paper The style of the paper seems incoherent and uneven due to the contribution of multiple authors. You should be able to create a logical link between consecutive para...grammatically correct,  and stylistically appropriate. As a language expert, you must understand the above-mentioned requirements in bullets that represent the required outcome.  Use of AIs (ChatGPT, Wordtune…) is allowed until it's not detectable (As AI generated) by plagiarism detection software. *** You will not get paid if the content is caught for AI and/or plagiarism.  References should be retained in place and the ideas, concepts and analysis must not get distorted, changed or transformed. Word Count: 7000 P...

...professional to conduct a detailed weekly analysis of our cash flow statements. We value expertise and a keen understanding of financial trends. Here's what we're looking for: - Weekly financial analysis provided in the form of Powerpoint presentation or via virtual meetings - Analytical focus on cash flow patterns specifically, with an emphasis on identifying areas where overspending may be occurring - A proactive approach, where you take the initiative in suggesting strategies to optimize cash flow Required skills and experience: - Strong background in financial analysis - Proficient in Powerpoint and virtual presentations - Excellent understanding of cash flows - Ability to spot overspending patterns in financial statements - Ability to mak...

...assist me with setting up and optimizing Freshbooks for first-time use, especially in the areas of expenses tracking, subcontractors, clients and projects management. Also, to ensure that the system is fully interoperable with my invoicing process and can generate a detailed P&L report. Here's a breakdown of what I need: - Configuration of Freshbooks to effectively manage expenses, subcontractors, clients, and projects. - Integration of the system with my invoicing process to allow for revenue burn rate tracking. - Monthly cleanup and categorization of expenses to generate a detailed P&L report. Ideal Skills and Experience: - Extensive experience in setting up and optimizing Freshbooks for small businesses. - Proficiency in configuring systems for...

...meeting Scottish dietary goals and mental health scores, using data from the Scottish Health Survey. I need this critical project completed within 3 days, demanding your ability to work efficiently without compromising quality. Key Tasks: - Conduct a thorough analysis of the given data - Determine whether adhering to Scottish dietary goals influences mental health scores - The mental health score is calculated via Wembys and GHQ12 in the said survey. Ideal Skills and Experience: - Previous experience with health-related data analysis is an advantage - Strong understanding of different statistical methods. There wasn't a specific preference, but demonstrating capability in Correlation Analysis, Regression Analysis, and/or T-Test ...

Details are provided in the attached files.

I'm looking to boost the organic traffic to my website, which primarily consists of product pages. My main goal is to achieve a higher ranking on search engines and enhance overall online visibility. To achieve this, I am specifically focusing on off-page SEO strategies. Key Responsibilities: - Conduct a thorough analysis of my current off-page SEO performance. - Develop and implement a comprehensive off-page SEO strategy that aligns with my goals. - Use a range of techniques like link building, social media marketing, and influencer partnerships to drive traffic. - Monitor and report on the performance of the off-page SEO efforts, making adjustments as needed. Ideal Skills and Experience: - Proven experience in off-page SEO and improving organic traffic. - Strong knowledge o...

I am looking for a freelancer to assist me in collecting quantitative data for academic research. I have a list of specific sources that I would like the data to be collected from. Skills and Experience: -Experience in data collection and analysis for academic research.

I'm on the hunt for a highly skilled Pine Script developer who can design an exceptional custom indicator with a backtesting capability. This project is quite straightforward: Key Aspects: - Need to develop a Pine Script-based custom indicator. - Must incorporate a backtesting capability into the script. Specific Task: - The custom indicator should identify "breaker candle" specifically based upon candlestick patterns. A tool such as this requires someone proficient in Pine Script development with a keen understanding of candlestick pattern analysis. Anyone with prior experience in such a task will be a highly favored candidate. Bring your expertise and let's introduce an innovative way to identify breaker candles.

I'm looking for a seasoned Project Designer with a strong understanding of options to conduct an intensive research. Expertise working on softwares, call center, robocaller and conversational AI outbound calls for call center. The ideal candidate should have a proven track record in creating, managing or implementing cloud-based robo calling systems and also conversational AI calls that is good with asian language, especially Bahasa Indonesia. the subject of the research must have : telephony (SIP/VOIP) a working AI model or open to integrations with AI Basic Telco Services features such as, Campaign Calls, scheduler, call recorder) Wide system integration capability Macro/logic/script editing(for robo caller,pre recorder or AI generated TTS) white label ready ...

...include surgical interventions, normal prosthetics, and wheelchair use. This project aims to offer a comprehensive outlook on how these resources can be best utilized, and what impact their allocation might have on patient outcomes and overall healthcare delivery. Ideal candidates for this project should possess: - Proven expertise in health modelling and forecasting - Experience working with healthcare data; particularly surgical interventions, prosthetics, and wheelchair use - Strong skills in statistical analysis and predictive modelling - A robust understanding of Markov decision processes - Flexibility in approach, with a focus on reliability and accuracy The final model should not only forecast potential outcomes but also enable us to understand the effect...

I am in search of a diligent and proactive Operations & CRM Manager who can ...ideal candidate should have: - Mid-level experience in Operations and CRM management. - Proven track record in managing daily operations in a fast-paced environment. - Excellent aptitude for customer support and relationship management. - A knack for streamlining processes to increase efficiency and performance. - Strong data analysis skills and inventory management expertise. This position requires a keen eye for detail, an enthusiastic problem-solving attitude, and a determination to enhance customer satisfaction. If you can balance multiple tasks in a fast-paced environment, then you are the ideal fit for this role. Apply now and join our mission in streamlining...

I require an expert in ANSYS Mechanical proficient in structural analysis. The quintessential project involves a steel structure that needs analysis under static and dynamic loads. Key areas we will be looking at include: - Using ANSYS Mechanical for comprehensive simulation - Handling steel structures, with emphasis on their unique properties - Evaluating the structure against static and dynamic loads to measure resistance Ideal skills will include a deep understanding of Structural Analysis, ANSYS Mechanical, Static Loads, Dynamic loads, and Steel as material. Familiarity with the properties of steel and its behavior under different conditions will be important. Past experience in similar project execution will be advantageous.

I'm looking to acquire a financial model that evaluates the purchase of an energy plant in India. The model should effectively: - Produce a Return on Investment (ROI) analysis. - Calculate future profitability using the Internal Rate of Return (IRR), Net Present Value (NPV), and Cash flow forecast. The cash flow forecast should cover a 40-year timespan. Freelancers bidding should have - Extensive experience in financial modeling and analysis, - Knowledge about energy sector investments. - Familiarity with Indian tax and energy regulations.

...behavior analysis using SPSS. Being a Likert scale analysis, the project's primary focus is to comprehend the behavioral tendencies in aggressive driving, particularly self-reported accidents. Here is what will be required: Objective - The project's main aim is to examine aggressive driving dispositions with the primary focus on self-reported accidents in the framework of Likert scale analysis. Criteria for Analysis - The analysis will mainly focus on aggressive driving behaviors, allowing a comprehensive understanding of underlying issues in self-reported accidents. Seeking Experts with: - Proficiency in SPSS software and data analysis. - Experience in conducting likert scale studies. - A background in behavioral psyc...

Objective: We are seeking an individual or company skilled in neural networks and Keras to develop a predictive model. This model will forecast the occurrence of a phenomenon based on historical data. Requirements: Data Acquisition: Historical data required for training the model will be fetched via an API from our comprehensive database, which is updated multiple times weekly. Data Processing: All retrieved data will be processed to facilitate effective model training. This includes Exploratory Data Analysis (EDA) to identify impactful data, outlier detection for data quality, and feature engineering to determine the final model inputs. Model Development: Train two types of models using Deep Neural Network (DNN...

I'm in need of a Python expert who can help me with statistical data analysis. The data in question is from our internal company records. It's crucial that you're proficient in data analysis using Python, particularly with a focus on statistical methods. Experience with internal company data is a plus. Key requirements include: - Strong understanding of Python, particularly for data analysis - Proven ability in statistical analysis - Prior experience working with internal company data Your work will be pivotal in helping us gain meaningful insights from our data, which will contribute greatly to our decision making processes. Prior experience in similar projects will be highly regarded.

...looking for a talented data researcher who can scour government databases to identify Pension variables. The data you'll be researching will be at the heart of the project, so it's pivotal that you are efficient, detailed, and reliable. Key Duties: - Methodically research and compile comprehensive data from government databases - Focus on economic indicator data - Ensure accuracy of collected data Ideal Skills & Experience: - Strong research skills, particularly in government databases - Background in economics, with a solid understanding of economic indicators - Keen attention to detail, ability to interpret and organize complex information effectively - Previous experience in data collection or analysis roles is a...

I have an Azure-hosted web application that I would like to deploy, I am looking for an entry-level freelancer who can handle this task. Key Requirements: - Deployment on Azure: The freelancer needs to have basic cloud computing knowledge and a decent understanding of Azure's services. - Web Development Understanding: While this is not a web development project per se, having a basic understanding of web applications would be beneficial. - Entry-Level Experience: I'm specifically looking for someone who is relatively new to freelancing, but who has some experience working with cloud services. Ideal Skills and Experience: - Basic understanding of cloud computing - Experience with Azure would be a plus - Some knowledge of web development - Entry-level experie...

Looking for a skilled Python freelancer to tackle uncertainty in machine learning models. The project focuses on enhancing ML models to handle uncertainty effectively. We require expertise in processing large datasets, with over 5 million rows, ensuring accuracy and efficiency in every analysis. If you’re ready to dive into the world of uncertainty estimation and large-scale data processing, join me on this exciting journey

I'm seeking a professional who can develop a custom GPT-enabled chatbot, tailored for a product description matching app. Key Tasks: - The chatbot's core purpose will be to perform keyword analysis and category matching, which means it must be capable of scrutinizing and comparing product descriptions effectively. Crucial Skills and Experience: - Custom GPT based on existing commercial offers - Natural Language Processing (NLP) - Keyword Analysis - Category Matching The right freelancer for this project will have a strong understanding of chatbot development and relevant experience with GPT models. Experience in using these technologies for product matching purposes will be highly advantageous. Demonstration of past successful projects of s...

...expert to integrate a data analytics tool to my app. Currently, I'm not using any specific tool. I am seeking a solution that can deliver: - Data Visualization: The ability to represent app data graphically for easy analysis. - Real-time Analytics: The tool must analyze data in real time to provide an ongoing insight into the app performance. - Predictive Analytics: The tool should be able to predict user behavior based on current and historical data. In terms of specific functionalities, I am looking for a tool capable of: - Dashboard Creation: This will enable a convenient overview of app metrics. - Customizable Visualizations: To tailor representations to specific data sets. - Data Filtering and Sorting: ...

I'm in need of a Business Development Manager with a proven track record in the tech industry. The ideal candidate will have a strong background in market research and sales strategy planning. Key Responsibilities: - Conduct thorou...and internationally - Drive revenue generation through innovative sales strategies and strong business development practices Ideal candidate should possess: - Proven experience as a Business Development Manager in the tech industry - Strong analytical and strategic planning skills - Excellent communication and negotiation abilities - A solid understanding of market research techniques and data analysis - A track record of successful partnership building and customer acquisition - A results-driven mindset with a focus on achieving and excee...

I'm looking for someone well-versed in Indian history, particularly the Medieval period, to create comprehensive notes for me. The notes should primarily focus on major events of the time, offering a detailed analysis. However, I'm most interested in an emphasis on important figures of the era and their key contributions. Key Requirements: - Strong knowledge of Indian history, specifically the Medieval period - Ability to provide a detailed analysis of major events - Prior experience in creating comprehensive notes - Structuring the notes around important figures and their contributions Your understanding of this time period is crucial, as the notes should be accurate, informative and well-organized. The ability to make complex historical events a...

...skilled data analyst who can provide a thorough and insightful analysis of various data sources. Key Points: - I require a comprehensive analysis covering descriptive, predictive, and prescriptive aspects of the data. - The primary objective of this analysis is to identify trends and patterns within the data. The data sources that will be involved in this project are: - Social media data - Sales data - Website traffic data The ideal candidate should have a strong background in data analysis, particularly in the areas of descriptive, predictive, and prescriptive analytics. The ability to synthesize insights from multiple sources of data will be crucial, as the goal here is to uncover pat...

...quickly as shown in the video. • Data Collection: The bot needs to collect and store Name & Phone number (and email which you can add from the code provided by the Youtuber) for future interactions, enhancing personalization over time. • Complex Interaction Capability: The chatbot should be capable of providing comprehensive replies to complex inquiries using the technical data sheets of my product (household/car cleaning products), advancing beyond simple text responses. The ideal candidate has a strong background in Python, chatbot development, AI, and machine learning. Familiarity with GPT (Generative Pre-trained Transformer) models will be highly advantageous. Your experience in conversation analysis and natural language processing (NLP) w...

I'm looking for a professional who can swiftly teach a computer to comprehend human language using Python or any other suitable programming language. Key Responsibilities: - Implementing text classification, sentiment analysis, and named entity recognition within the NLP model - Developing an effective teaching method that enables the computer to interpret and respond to human language inputs Experience and Skills: - Proven expertise in Natural Language Processing (NLP) and machine learning - Proficiency in Python or another programming language commonly used for NLP - Strong ability to develop and implement text classification, sentiment analysis, and named entity recognition algorithms - Demonstrated experience in creating and training NLP models - Exce...

I am seeking a skilled developer to create a platform th...a skilled developer to create a platform that accommodates both professional and client users. Key areas of focus include: - Integrating dual login functionality, allowing both professionals and clients to access, manage their profiles, and post jobs seamlessly. This should be a high-priority feature. - Implementing a robust credit system for bidding on jobs. Privacy is paramount until a job has been accepted. - The platform should be optimized for mobile use. This is crucial as professionals and clients must receive real-time notifications regardless of where they are. Proficiency in UX/UI design, database management, web security, and mobile app development is desired. Previous experience in building similar pl...

I am seeking an experienced...with a strong understanding of economics and political insurance to pen an insightful thought leadership piece. This is for my existing business, the targeted audience are industry professionals. The writer should focus on: - Risk Management Strategies: Simplify complex concepts, inform the audience about different approaches to managing risks in the political insurance sector. - Current Trends and Forecasts: Inform on the evolving landscape, highlighting the most compelling trends and forecasts. Ideal candidates will have an extensive background in economics, risk management, political insurance, and excellent writing skills. This project not only requires critical analysis but exceptional ability to present complex information in a clear, c...

...in need of expertise in Power BI for effective visualization and reporting of my operational data, with the aim of enhancing my understanding and decision making. Tasks to be accomplished: - Configure data visualization tools in Power BI - Build reports from the operational data Ideal freelancer qualifications: - Rich experience in Power BI and data visualization - Background in operational data analysis - Strong understanding in converting complex data into easy-to-understand reports - Detail-oriented and meticulous in report generation Please, be informed that the third question concerning customer data insights was skipped intentionally because the project centers mainly around operational data...

I NEED THIS ANALYSIS TO BE MADE IN MAXIMUM 4 HOURS. IT NEEDS TO FOLLOW THE SAME ( OR VERY SIMILAR) STYLE OF THE LINK BELOW... BEFORE TO SEND ME MESSAGE PLS READ THE ATTACHED SPREADSHEET TO SEE WHAT IS NEEDED PLEASE DONT WASTE MY TIME , I WANT SOMEONE THAT KNOWS THE JOB AND CAN GURANTEE TO DO IT IN 4 / 5 HOURS. NOT JUST TO TRY !!! I need a skilled and detail-oriented financial analyst to complete a comprehensive analysis of a listed company within a timeframe of 4 hours. This is a time-sensitive task requiring accuracy and diligence. Key Responsibilities: - Generate a report based on selected financial ratios; specifically, liquidity, profitability, and solvency ratios. - Assess and include the following liquidity