Combustion calculations natural gas excel jobs

Please Sign Up or Login to see details.

I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.

I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.

I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.

I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex data set...

I'm looking for an experienced blockchain developer, specifically with a skilled background in Chainlink Oracle Smart Contract development. - The task involves creating a custom Chainlink Oracle Smart Contract tailored to manage financial data feed. - You'll be working with APIs to retrieve financial data on an hourly basis. - Unlike most projects, no calculations are required on the incoming data before returning it. Ideal skills: - Prior experience with Blockchain development - Deep understanding of Chainlink Oracle Smart Contracts - Proficiency in API data management - Knowledge and experience with financial data.

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

Looking for a talented drone cinematographer to capture an enchanting natural landscape. The footage will be used for commercial purposes, making it crucial to create a vibrant, and colorful visual experience that embodies the pure beauty of nature. Key requirements: - Exceptional skills in drone operations, focusing on outdoor and nature cinematography - Proven experience in capturing vibrant and lively aesthetics through drone footage - Strong knowledge of editing and post-production process The right candidate will have experience with commercial projects, an eye for detail and a knack for capturing the vibrant hues of nature in their work.

...Calculation: The engineer should be capable of conducting thorough wind calculations, considering the specific environmental factors associated with a coastal setting. - Structural Integrity: The aim is to guarantee that the shelter design can withstand the maximum wind conditions expected in the location, maintaining its integrity and safety over time. Ideal Skills and Experience: - Engineering Background: The ideal candidate should have a strong background in structural engineering, particularly in the context of building design. - Experience with Wind Analysis: Prior experience in wind load calculations, especially in coastal areas, is highly desirable. - Attention to Detail: The ability to perform precise calculations and ensure the accuracy of the results is c...

...machine learning, natural language processing, or computer vision into mobile apps. Familiarity with RESTful APIs and third-party libraries for seamless app integration. Ability to work collaboratively in a team environment and communicate effectively. candidate must have the knowledge of facial recognition and facial expression with AI or machine learning. A passion for learning and staying updated with emerging technologies. If you are a skilled Android/Flutter developer with a passion for AI and are excited about working on innovative projects, we would love to hear from you. Please submit your resume and portfolio showcasing your relevant experience. Features: Cloud-Based AI Services: Reinforcement Learning: Speech Recognition and Synthesis Computer Vision Natural ...

I'm aiming to build an enhanced e-learning platform that integrates artificial intelligence at its core. My vision is focused on three special features: Gamification, interactive quizzes, and progress tracking capabilities. This would effectively make learning fun, engaging, and easily monitored. The core functionalities I require include virtual tutors, natural language processing for student-teacher interaction, sophisticated robotics, and an advanced learning process. All these aspects and more should contribute towards fostering optimal communication and facilitating superior understanding and learning. I'm at the helm of an exciting Artificial Intelligence technology startup, and we're keen to grab a visionary investor who's aware of the AI landscape. Our p...

I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the new budget as w...

I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on in the past.

I'm looking for a talented video editor who can enhance my YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency in creativity and storytelling,...not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation and excel in video editing, this could be an exciting o...

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

I'm seeking an experienced AI developer, proficient in data analysis, a variety of machine learning model development, and natural language processing to bring an image recognition project to life. Specifically, I'm looking for your contributions to: - Thoroughly analyze large quantities of data and draw insightful conclusions from it - Develop advanced machine learning models to fulfill our needs - Apply natural language processing techniques for improved project outcomes - Design and develop AI models to meet project requirements - Convert AI/ML models into APIs that other developers can use - Perform statistical analysis on big data sets - Manage project infrastructure and the development of AI models and projects - Work with other machine learning engineers, d...

I'm looking for a skilled Photoshop expert to create realistic and stylish room settings for a variety of products including homeware, gifts, ornaments, and art. The goal is to display these items in a way that looks natural and appealing, suitable for use in social media posts and advertising. Key Requirements: - Photoshop Expertise: The ideal candidate should be an expert in Photoshop, capable of creating realistic backgrounds and integrating products seamlessly into them. - Creative Vision: A good eye for design and an understanding of how to create aesthetically pleasing room settings. - Fast Turnaround: I'm hoping to complete this project within a month, so the ability to work efficiently is crucial. Your responsibilities will include: - Designing homeware, gifts, ...

I'm in search of a skilled drone operator with experience in film production. The work involves capturing footage in natural landscapes with a high-resolution drone camera. Key requirements: - Experience in film production: The ideal candidate must have a background in operating drones for film production, understanding shot composition and movement. - Strong drone control: The landscapes can be challenging, so a high level of drone control and precision is crucial. - High-resolution camera experience: The drone needs to have a high-resolution camera, which the operator must be familiar with using to capture cinematic quality footage. Please provide examples of your previous work in film production if possible.

i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.

For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized datasets. This analyst should prioritize accuracy, prec...

...facing deployment errors. Your expertise in both troubleshooting and deployment is crucial for this project. Key Tasks: - Identify and fix the smart contract's functionality issues - Resolve any deployment errors that are preventing successful deployment While I didn't specify a particular optimization goal, I'm open to suggestions on how the contract could be optimized. This could include reducing gas fees, improving transaction speed, and enhancing security measures. Feel free to provide your own insights and recommendations in this area. Ideal Skills and Experience: - Proficient in Solidity programming language - Extensive experience in working with smart contracts - Strong debugging skills to identify and resolve functionality issues - Prior experience in de...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and excellent communication skills will be hugely ben...

I'm looking for a professional to convert 1000 + questions I have in Word format into Ailken format. The main reason for this i...and automated checks. Key Responsibilities: - Convert 1000 questions from Word to Ailken format - Source answers for all questions using Chat GPT or similar tools - Verify the correctness of the answers through a combination of manual review and automated checks -Need to source question and answers from an online workbook. Ideal Skills: - Proficient in Ailken format - Experience working with natural language processing tools like Chat GPT - Strong research skills - Ability to verify correctness of information Your work will be crucial in the successful creation of a quiz that I'm planning, and I'm looking for someone who can commit to acc...

I'm looking for someone to set up an FTP server for us. This server will act as a central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP ser...

Hi, Job Title: Senior Developer - SQ...for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits. Developer has to be at the ON SITE Dubai office.  - Work Location -  Dubai - Number of Working Days - 6 days ( Monday to Friday ) - Number of Working Hours -  10hrs per day - N...

I have a need for a spreadsheet that allows me to calculate total price based on numerous factors: Various products with different prices per user and minimum sale prices Total Price based on a calculation of User Count (factoring a minimum that mus...calculation that can be manually changed Key Requirements: - Data Entry: I will manually input sales data into the spreadsheet. - Calculation: The spreadsheet should be able to calculate unit prices and margins based on the sales data provided. Ideal Skills: - Advanced Excel skills: Proficiency in creating complex formulas for unit price and margin calculations is essential. - Data Analysis: Ability to present the calculated data in a clear and understandable format. - Attention to Detail: Ensuring the accuracy of the calc...

...need a professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistical analysis - Prior e...

I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.

I need a data scraping tool to pull business names and addresses from Google and Google Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills ...Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques. - Experience working with Google and Google Maps APIs. - Ability to organize and structure data effectively. - Data to be compiled in an excel spreadsheet - Prior knowledge of extracting business information from online sources is a plus. Looking forward to your ...

I'm urgently in need of a Python specialist to accomplish an assignment using Jupyter Notebook. The task involves reading and merging multiple Excel sheets, and subsequently creating visual representations for the collated data. Key requirements are: - Deep knowledge of Python for data analysis - Proficiency in creating Bar Charts, Scatter Plots, and Line Graphs. - Strong skills in Excel data manipulation. Required libraries/packages expertise: - Matplotlib - Seaborn - pandas Your responsibility will be to decode the problems presented, manipulate provided Excel data accordingly, and present the output in an understandable visual format. Previous experience in similar tasks will be highly regarded. Will show the work on zoom and will connect and probably do ...

I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via macro automation.

Artificial Intelligent developer required ChatGTP-4 SAP experience required API developer Odata and REST skills SAP Integration required Must be an expert with XML -Authorizations -Risk Management -Process Controls I required a chatGTP bot created and data should be extracted and presented i...preferences or needs - Guide customers through risk management processes Although I am open to suggestions, my preferred platform is Chat. This project calls for a skilled developer, ideally with previous experience in designing AI customer service chatbots. You should be conversant with SAP systems and understand the nuances of risk management. Additionally, the chatbot should be powered by natural language processing capabilities to ensure accurate, and effective interaction with ...

... for example [India fillings search]() [quick company company search]() [MCA portal]() However, these don't allow bulk input. I want users to be able to input a large list of company names and receive an output in a downloadable Excel sheet. Although I initially explored utilizing an [API from ](), I encountered difficulties with downloading data or obtaining an API key, possibly due to issues with their website. but was able to find [this csv file on kaggle]() containing

I'm in search of an SEO professional who can generate natural editorial backlinks to boost my search engine rankings. The specifics are: • Backlink Strategy: Build only natural editorial links. Spammed or self-created non-editorial ones are absolutely not acceptable. • Purpose of Backlink: The main objective is to improve my website's search engine rankings. • Niche Targeting: Unfortunately, I had to skip this question. However, your expertise and advice will be appreciated to determine the most suitable niche for my backlinks. Skills and Experience Required: • Proven track record in effectively building high-quality, natural editorial backlinks. • Solid understanding of SEO, specifically in relation to backlink strategies. • C...

I need an experienced Power BI developer to revamp my existing dashboard. I have a few specific requirements I need to meet, and I'm on a tight deadline. - **DAX Calculations**: I need some DAX calculations to be added in the dashboard. Specifically, I require help with Time Intelligence and Aggregations. - **Neatening the Dashboard**: The visual elements in the dashboard need to be reorganized for better clarity and user experience. I need the dashboard to look clean, organized, and easy to understand for the end user. - **Drill-through Feature**: I require a drill-through feature that allows the user to navigate from a summary level to more detailed data. This is an important functionality that needs to be implemented in the dashboard. Please note that this is an u...

...of text data. Prior experience with this data type is a definite advantage. - Goal: The main objective of this project is to perform in-depth data analysis. I need the freelancer to assist in developing metrics and calculations for the data. - Deliverables: The final output should be presented in a report format. Ideal skills for this project would include expertise in Python, data analysis, experience with text data, and the ability to create comprehensive reports. I want to write a python code for the following calculation of Code Synchronization adoption rate: I've 4 excel files, 2 Jira extracts and 2 solman extracts. 1 for Jira Support state(support user stories & bugs) and 1 for Solman Support state(Support CRs). Other would be same Jira & SolMan ex...

...the past for some amount. From 20 euros to hundreds of thousands of euros, and they stopped a year or more ago. The purpose of the conversation is to check whether the company still exists, whether it is still in the field and why they stopped purchasing. We have prepared a dedicated link for filling in the results of the conversation. I am attaching the excel file with the records, the script of the conversation. Translate it into the appropriate language for the country you will be speaking with) The conversation must not be mechanical, the script is only for illustration. I have prepared several questions and answers in case it comes up in the conversation. For the purpose of the conversation, you work at Vista System Norway. Some of the records include

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

I am in need of a skilled data entry operator to assist with the transfer of input of text data. Your main task is to take text data from an online database and accurately enter it into an Excel spreadsheet. Requirements: - Ability to accurately enter text data - Proficient in Excel - Experience sourcing data from online databases - Diligent and detail-oriented to ensure no errors are made during data transfer - Strong English language skills to ensure effective communication The ideal freelancer for this project is someone with proven data entry experience, excellent Excel skills, and vast familiarity with online databases. Being a detail-oriented person with great concentration skills will be a huge plus.

...multiple Excel slicers into one for our data analysis needs. The requirement is, I want to use same Slicer for multiple data. Detailed description is as follows: I have a accounting sheet. Where in one separate sheet I have captured Incomes along with the date and amount and other sheet I have put Expenses along with Date and amount. Now in summary sheet I am using Income pivot table, where I am using Slicer on Date (Merged for Months and Years). I want the same slicer to be used for Expense pivots as well. The ideal freelancer for this job should be proficient in: - Excel - Slicers and PivotTables - User experience design - Data analysis techniques Your input and expertise in this project can help streamline our data manipulation process and enhance the overall usa...

I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Y...

...only one week Only the corresponding screen can be viewed Approximately 300-400 new businesses expected to be registered each month: Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from step 3...

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

I need a skilled photo editor, particularly someone with experience in working with boxing sport portraits, to help me with a project. Requirements: - Background Remo...any damage to the original photo. - Color Correction: Basic color correction is needed to enhance the overall appearance of the portraits. Level of Editing: - Creative Editing: I am looking for a professional who can add creative filters and effects to the portraits. Please note that the portraits are in need of a high level of attention to detail. It is important that the final result looks natural and professional. Ideal Skills: - Proficient in Photoshop or a similar software - Experience with portrait editing - A keen eye for detail and creativity - Ability to deliver high-quality work within the specified...

Dear Candidate, As described in the title, this task requires that you reasearch medical centres (also called general practice medical centres, family physician clinics, clinics) and find out who the owners of these clinics are are using internet research. You will have to be fluid with excel, online reasearch tools. This is a posting for a long-term VA who can perform various forms of online research and other tasks. Personal attributes required: 1. Speed and efficiency in online research. 2. Attention to detail and complete accuracy in all tasks. 3. Punctuality and ability to meet deadlines. 4. Ability to read/follow instructions carefully with attention to detail. Successful candidates will be required to complete two test works before the project is awarded. 1. Watching i...

Looking for someone to go to a few sites and make me an excel sheet with all the listings on the site . Must speak fluent English

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

I require a photo retoucher to enhance and edit 27 images of a 61-year-old woman. The process will involve: - Wrinkle removal - Skin tone correction...retoucher to enhance and edit 27 images of a 61-year-old woman. The process will involve: - Wrinkle removal - Skin tone correction on various parts of the body such as face, legs, and arms where necessary. Not all images will require full body retouching; just some of them. - Authentic, natural enhancement to ensure the final product is as organic as possible, not too overdone or unnatural looking. An ideal candidate would have experience in professional photo retouching and the ability to maintain a natural, authentic look in the final product. Realistic skin tone correction and nuanced wrinkle removal will be critical skil...

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to duplication and missing entries in da...