Problem solving microsoft excel jobs

I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in ...Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue" on th...

...support to the upper management team Requirements: * Must be a strong English communicator (both written and spoken) * Proven experience as a Virtual Assistant or similar role * Excellent organizational and time-management skills * Proficiency in Google Suite, MS Office, and other relevant software * Ability to work independently and prioritize tasks effectively * Attention to detail and problem-solving skills * High level of professionalism and confidentiality Preferred Qualifications: * Certificate in Business Administration or related field would be a bonus * Experience working in a similar role supporting upper management * Knowledge of project management tools and software Duration and Hours: We are looking for an individual that is capable of being flexible in the...

I am facing a persistent issue with my WordPress WooCommerce platform where the order origin consistently appears as unknown. I haven't been able to troubleshoot this problem effectively, hence require the services of an experienced WordPress/WooCommerce specialist. Key Responsibilities: - Identify the root cause of the unknown order origin issue. - Implement a reliable solution to ensure the correct order origin is always displayed. Ideal Skills and Experience: - Significant experience with WordPress and WooCommerce - Proven ability to debug and fix similar issues - Excellent analytical and problem-solving skills In your application, even though I skipped this point, it will be beneficial if you include your past similar work experience and detailed project pr...

I am in need of an experienced professional who can work hand in hand with me in exporting my old MySQL database into my new Node.js website. There are a f...comfortable providing remote assistance through anydesk, and maintaining open communication over a call throughout the duration of the task. I will personally guide you through the necessary steps and the specific level of accessibility that should be set for the new database. Ideal skills and experience: - Solid understanding of MySQL - Experience in Node.js website development - Exceptional problem-solving abilities - Excellent communication skills - Ability to follow instructions Please note that this is a hands-on project that requires a professional who is available and committed to working directly with me to en...

...with form submissions. Currently, when customers enter their details in a HubSpot native form, if they have previously submitted information, they are not connected to a particular deal. I need a solution that will fix this problem. Key Requirements: - Expertise in HubSpot: You should have a deep understanding of how HubSpot works, especially in relation to form submissions and deal creation. - Previous Experience: It would be ideal if you have tackled a similar issue in your previous projects. - Problem-Solving Skills: The ability to identify the root cause of the problem and provide a viable solution is crucial. - Attention to Detail: The fix needs to be meticulously implemented to ensure that all future form submissions are tracked correctly. Your task w...

I'm looking for proficient freelancers who can effectively input both text and numerical data into Excel from physical documents. The task does not require any formulas or calculations, but attention to detail is crucial to ensure the accuracy of data. Key tasks include: - Manual entry of text and numbers from physical documents into Excel - Ensuring accurate data entry and quality checks Ideal freelancers should: - Have experience in data entry tasks, particularly with Excel - Be detail-oriented to ensure accuracy - Have strong organizational and time management skills.

I require the expertise of a part-time remote accountant who can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely...can commit to less than 20 hours a week. The core tasks involve: - Bookkeeping: Systematically recording and organising my financial transactions. - Payroll: Managing payroll functions to ensure that employees are paid in a timely and accurate manner. - Financial analysis: Monitoring, identifying and interpreting financial trends. The ideal candidate should have a good command of QuickBooks and Excel spreadsheets. Familiarity with these tools is crucial for performing tasks efficiently and a...

I'm looking for an expert in Excel who can help me with applying conditional formatting and creating complex formulas that involve multiple conditions. Please watch this video for what i need Key Requirements: - Applying Conditional Formatting: The Excel file will require conditional formatting to visually represent data based on specific criteria. - Creating Complex Formulas: The project includes creating formulas that are not limited to basic arithmetic, and instead, involve multiple conditions. Ideal Skills and Experience: - Proven expertise in Excel: The ideal candidate should have a strong background in working with Excel and creating complex formulas. - Understanding of Conditional

...The primary goal of this tool is for automated testing. It should be able to solve TikTok Captcha puzzles efficiently and accurately. - The ultimate use will be for it to be overlayed on TikTok, which is where the captchas are to be solved. Ideal Skills and Experience: - Solid experience with Android development, understanding of how to work with rooted devices through Magisk. - Proficient in solving captchas, especially puzzle slide captchas. - Prior experience with automated testing and integrating tools with other systems. - A good communicator, as we'll need to discuss the tool's progress and potential modifications as the project moves forward. Please include your relevant experience, expertise, and any innovative approaches you might have for tackling this chal...

I'm seeking a professional who can help me to enhance the speed of my AI image generation process. Key Requirements: - Current image generation dur...image quality is important, the primary goal is to significantly speed up the image generation process. Ideal Candidate: - A proven track record in AI image generation, particularly in optimizing the process for speed. - Proficiency with AI image generation tools and techniques. - Strong understanding of the trade-offs between speed, quality, and cost in AI image generation. - Excellent problem-solving and analytical skills. If you have experience in AI image generation and optimization, especially in improving speed without compromising quality, I'd love to hear from you. Please include any relevant experience or...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

As a forward-thinking company, we are looking to refactor our Sass built with jQuery into a modern stack. Although the project specific...modern stacks - Ability to determine best stack for reengineering the current setup - Experience in refactoring code with minimal disruption - Plan, manage, and execute the migration process Although specifics about the current functionalities and objectives were not provided, the ideal candidate would be experienced in many areas across web development, proficient in troubleshooting and problem-solving, and possess a thorough understanding of improving performance, enhancing user experience and scalability. Your expertise will be instrumental in taking this project to the next level. We are eager to collaborate with you on this excitin...

I'm currently seeking an individual who is not only proficient in VHDL coding but also in Quartus design implementation. Key Responsibilities: - Work on specific tasks related to VHDL coding - Implement design using Quartus While the overall aim of the project and the timeline aren't specified yet, I am eager to work with someone who is flexible and can adapt as per project needs. Th...related to VHDL coding - Implement design using Quartus While the overall aim of the project and the timeline aren't specified yet, I am eager to work with someone who is flexible and can adapt as per project needs. The ideal candidate for this role should be based in Pakistan, knowledgeable in FPGA programming, dependable, efficient, and proactive when it comes to troubleshooting an...

...a strong background in digital forensics who can assist in recovering deleted content from a PDF file. I do not have the original file for comparison, and I am not aware of the specific content that has been deleted. Key Requirements: - Proven experience in digital forensics, specifically with PDF files - Ability to recover deleted content without access to the original file - Excellent problem-solving skills to investigate and identify potential content deletion - Comprehensive report providing the recovered content and the changes made to the file. Ideal Candidate: - Holds a degree in computer science, cyber security or related field - Has handled similar projects in the past proficient in digital forensic software and tools - Communicates effectively - Maintains con...

I am looking for an efficient data entry expert to assist me in entering textual, numerical, and image-based data. The project involves a medium amount of data that needs to be meticulously transferred to an Excel file. Your responsibility will include, but is not limited to: - Inputting textual data while maintaining accuracy. - Adding numerical data precisely. - Uploading images correctly. An ideal freelancer for this job would have a keen eye for detail, substantial experience with Excel, and the ability to handle different types of data. Prior knowledge in image uploading and handling is a plus. You should also pride yourself on accuracy and efficiency. In your proposal, please share a brief summary of your experience, including one to two data entry projects you hav...

Automated report using dashboard in Excel The report interface should be similar look to the pic attached. The Excel file for data source should be able to be used for Power BI. Two dashboards: 1- for multiple project management status reporting 2- for ad-hoc task management The data source is in an Excel sheet with a manual entry

I'm seeking a skilled professional to enter 100-500 text entries for me. Key Responsibilities: - Entry of primarily textual data - Handling 100-500 entries Ideal Skills: - Proficient with Microsoft Excel - Excellent attention to detail - Strong typing and data entry skills. Experience in similar projects will be highly appreciated. I look forward to your bids for an efficient data entry task.

I need a freelancer to accurately convert a text-only PDF file into a word document, while maintaining the original formatting. Key Requirements: - Convert text-only PDF to Word - Preserve original formatting - Ensure the final format is editable Ideal Candidate: - Experience with PDF to Word conversion - Strong attention to detail - Proficient in Microsoft Word - Able to complete the task within 7 days

My Magento 2.4 website urgently needs assistance with bug fixes and a design overhaul. I'm encountering various limitations and menu alterations that need to be sorted and also experiencing design-related issue...need to be sorted and also experiencing design-related issues. Key Tasks: - Tackle site bugs, specifically concerning menu changes - Address design-related issues around aesthetics and functionality - Improve overall site design besides fixing bugs I'm keen to partner with someone who has: - Profound experience with Magento 2.4 - A keen eye for design and details - Proven track record in problem-solving for e-commerce sites. If you are adept at both examining beneath the surface to solve technical bugs and enhancing websites' visual appeal, then I...

I'm looking for a skilled software engineer. THis task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements. Thanks :

I need an experienced developer to finish up an e-commerce website that is partially done. The main purpose of this website is to sell products online. The platform used is not spec...- Development and implementation of a search function that can promptly and accurately yield results, even with this high number of products. Skills & Experience Required: - Proven track record in setting up and managing high-capacity, e-commerce websites - Proficiency in e-commerce platforms such as WooCommerce, Shopify, or Magento - Experience in data management - Excellent problem-solving capabilities The goal is to have a seamless shopping experience for the user and robust back-end management capabilities for the owner. Let's discuss your previous work and how you pl...

I'm looking for a skilled developer with experience building Web3 and DeFi websites from scratch. As I have not defined specific functionalities or a primary purpose yet, I need someone who can give advice in these areas. The same goes for the design; I need a design expert who can create a uniq...someone who can give advice in these areas. The same goes for the design; I need a design expert who can create a unique and eye-catching design. Ideal skills and experience for this job: - Advanced coding skills and experience in various programming languages - Experience with blockchain technology and understanding of how DeFi works - Knowledge and experience in web design - Excellent problem-solving skills - Good communication skills, as I will need advice and guidanc...

I have a large Word document (57 pages / 8,046 words) that requires a meticulous conversion to HTML. It's imperative that this conversion maintains the document's original presentation. ...Key aspects for this project include: - The HTML output must mimic the original Word document's structuring and formatting. - Special attention has to be given to making it match exactly to the Word document. This includes font type, size and spacing. note there are images as well to be included. - It will need to be mobile friendly as such. - An excellent understanding of HTML, CSS and Microsoft Word is vital. - Strong experience in converting documents from Word to HTML is desired. Applicants should be proficient in working with detailed documents and exhibit a keen eye...

2 pages of data sheet need to be recreated with zero mistakes and dito copy i am attaching the 2 pages i need to be recreated same to same, the top logo will change which i will provide you the screw picture and the text i am attaching with this for your review the sheets should be totally editable either make in word or excel or it should be edited in PDF the lowest quote below the price of $15 will be awarded the project thank you

When replying, reply with the text: "Forensic 4 Project"...qualifications you have? 7) If you have any experience in working in Singapore financial projects do highlight those as well. 8) What do you understand of the SIBOR / SOR / LIBOR scandal and how could it have affected borrowers? Work scope: Go through letter of offers and loan statements, find the faults, calculate the excess paid, calculate damages All works should be done in Google Sheets or Microsoft Excel with formulas to prevent any calculation errors. Your output should clearly show what was charged, what should have been charged, difference and damages. Need someone who has a decent amount of time available, if you do not have alot of time to spare, this may not be ideal as this will take some tim...

We're on the lookout for skilled animators adept at infusing life into our milkbag persona through captivating and witty Instagram Reels and animated content. Our ideal candidate possesses a solid grasp of animation principles and ...caliber of content we're aiming for. We aspire to achieve a similar level of ingenuity and amusement in our mascot character Instagram Reels. How to Apply: If you're passionate about animation and possess a talent for crafting entertaining Instagram Reels and understand cryptocurrencies and trading we're eager to hear from you! Please include your portfolio and a brief statement outlining why you'd excel in this role in your application. Additionally, feel free to share any relevant experience or ideas on bringing our mascot c...

I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.

I'm seeking a professional who can help me to enhance the speed of my AI image generation process. Key Requirements: - Current image generation dur...image quality is important, the primary goal is to significantly speed up the image generation process. Ideal Candidate: - A proven track record in AI image generation, particularly in optimizing the process for speed. - Proficiency with AI image generation tools and techniques. - Strong understanding of the trade-offs between speed, quality, and cost in AI image generation. - Excellent problem-solving and analytical skills. If you have experience in AI image generation and optimization, especially in improving speed without compromising quality, I'd love to hear from you. Please include any relevant experience or...

I need a dedicated professional to assist with a crucial data entry project. The work involves: - Encoding textual data sourced from digital documents. - Delivering accurately encoded data into an Excel spreadsheet. This task requires keen attention to detail to ensure the absolute accuracy of the data entry. The ideal candidate must have extensive experience handling textual data and an aptitude for meticulous data entry work. Proficiency in Excel and working with digital documents is also vital.

I'm in need of a seasoned Apache Solr professional to help me implement search functionality for my project. The ideal candidate has excellent expertise in Apache Solr and can effectively optimize search functionality for text documents. Key responsibilities: - Upgrade from Apache Solr 3.6 to a version supporting wildc...wildcard search, Windows server - Multi cores with replication - bulk import via CSV - core creation/deletion across master and slaves Ideal skills and experience: - Prior experience implementing Apache Solr for search functionality - Proficiency in data indexing and faceted navigation with Apache Solr - Strong understanding of optimization techniques for search functionality - Excellent problem-solving and analytical skills - Good communication and c...

I'm looking for a math expert who can help me solve calculus problems related to electrical circuit analysis. The ideal candidate should have a good understanding of calculus, particularly in the context of electrical circuits. Key Requirements: - Proficiency in solving calculus problems - Understanding of electrical circuit analysis - Comfort working with circuits involving capacitors and inductors Experience with advanced calculus and electrical engineering is a plus. Your job will be to solve complex calculus problems within the context of circuits with capacitors and inductors. If you have experience or knowledge in this area, please don't hesitate to bid.

I have a data transcription and cleaning/validation project that requires a skilled individual. All data will be provided in Excel and PDF formats. Key Responsibilities: - Transcribing data accurately from multiple sources - Cleaning and validating the data to ensure accuracy - Working primarily within Microsoft Excel Skills/Experience Required: - Proficiency in data entry, transcription, and data cleaning - Strong command over Microsoft Excel - Attention to detail and accuracy are key I am looking for a detail-oriented individual with relevant experience to help me complete this task efficiently and accurately. Please include examples of similar projects you have completed in your proposal.

I'm in need of a professional who is experienced with Microsoft Azure and can assist me in deploying a .net framework webform application as an azure web app

I'm looking for an Excel expert to help me refine some of my current templates. The ideal candidate will have experience with building templates for dashboards, organizing data, generating reports, and analyzing various types of data including sales, financial, customer, and inventory data. Key Requirements: - Experience in building templates for dashboards is a must. - Adept at organizing and analyzing complex sets of data. - Ability to translate data into clear and visually appealing reports. - Proficiency in working with various types of data, including sales, financial, customer, and inventory data. - Understanding of creating customizable templates in Excel. - A keen eye for design with a focus on clean and simple layouts would be appreciated. The project involves...

I'm seeking a proficient PowerPoint expert to fine-tune my presentation. The task...primary task will be to format the slides to enhance readability and visual appeal. - Slide layout designing: You'll be in charge of creating a layout that effectively communicates the information and is visually engaging. - Working with color schemes: I need your expertise in choosing and applying color schemes that align with the presentation's theme and mood. Ideal Skills: - Proficiency in Microsoft PowerPoint - Strong understanding of color theory - Creativity and an eye for design - Experience in corporate presentations Style Guide: The overall theme should be 'Professional and Corporate', thus it's essential that it maintains a level of professionalism, con...

I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.

I'm looking for an Excel expert to help me create a comprehensive tool that will serve as a project scheduler, lead manager, and accounts system. Specifically, I'd like the tool to have the following features: - **Project Scheduler** - Task tracking: I need to be able to input tasks and track their progress. - Gantt chart: Visualization of tasks and their timelines. - Resource allocation: The ability to allocate resources to tasks and track their usage. - **Lead Manager** - Lead tracking: The tool should allow me to input and track leads. - Contact management: I need to be able to store and manage lead contact information. - Sales pipeline: Visualization of the sales pipeline, including lead progression and conversion rates. - **Accounts Management** - Ex...

I'm seeking a freelancer who can help me convert my Microsoft PowerPoint presentation to Google Slides, while maintaining a corporate design theme. Ideal Skills and Experience: - Proficiency in both Microsoft PowerPoint and Google Slides - Strong understanding of corporate design principles - Ability to ensure that the converted slides maintain their original design integrity Feel free to reach out if you have any further questions or need more details to make a bid. Thank you.

I'm in search of a versatile full stack developer to assist in the completion of a project. Although I have not set specific tasks, I'm looking for someone who can handle both front-end and back-end development tasks, as well as database management. The ideal candidate should have a strong bac...strong background in all the skills required for full stack development. The project will involve creating a website or building a web application, and possibly require some mobile app elements. Key skills and experience required include: - Proficient in JavaScript, Python, and/or Ruby - Ability to handle both front-end and back-end development - Experience with database management - Strong problem-solving skills. If you're a full stack developer looking for an in...

...am not aware of any recent surge in website traffic that could explain this sudden spike in PHP-FPM processes. - The problem lies in the custom extensions I'm using on the Magento 2 platform. Required Skills and Experience: - Expertise in Magento 2 is essential, as the issue seems to be rooted within the platform. - Previous experience in troubleshooting PHP-FPM process overloads is highly preferred. - Familiarity with CentOS 7 and cPanel is a plus, to ensure a comprehensive understanding of the server setup. - Ability to assess, diagnose, and resolve issues with custom Magento extensions. - Strong problem-solving skills and the ability to effectively communicate the problem and solution to a non-technical audience. Your task would involve identifying...

...desktop application. This tool will structure reports from user inputs and is required to be fully compatible with Microsoft Excel. Therefore, proficiency in Excel-integrated application development is essential. Key Tasks and Specifications include: - Designing and coding a desktop application for report generation - Ensuring the application can accurately convert user input data into structured reports - Implementing compatibility with Microsoft Excel for the accessible and seamless transfer of data The ideal freelancer for this project has a strong background in software development, particularly with creating desktop applications and working with Excel. Experience with coding Excel-integrated apps and understanding of user-friendly ...

I'm in need of an Excel Expert to create a functional and visually cohesive form for my company. The form should have various action buttons and cell locking features to ensure data integrity. Key Features Required: - Action Buttons: The form needs to have a 'Submit' button for data submission and a 'Clear' button for form reset. - Time Store Function: This unique feature should automatically calculate time spent on the form, store time values in a specific cell, and generate a report of time spent. Its implementation should be seamless and user-friendly. - Cell Locking: Certain cells in the form must be locked to prevent accidental changes. This is crucial for the form's operational integrity. Design Requirements: - The form should be designed using...

...system functionality - Connect the online version to the desktop. The online version has a function called chemplan online. When the user click this option, desktop version should become active. The freelancer installed the system says he is busy for few days and can not do it now Skills and Experience: - Experience with data analysis and reporting systems - Strong troubleshooting and problem-solving skills - Proficiency in system maintenance and debugging - Excellent communication to provide updates and explanations throughout the process. If you are interested, I can provide the hosting company, user name and password. Key Issues: - User Registration: This functionality has ceased to work properly. - Database Connection: The application is no longer connecting t...

You will get a solid consultation for developing a project from scratch or even an idea. In the Consultation you will receive: 1. Clarity in your thought process✅ 2. Knowledge about the design procedure✅ 3. Answers to your questions which are not letting you sleep✅ 4. Practical approach towards every problem solving✅ 5. Quick Support over call

I am seeking a Machine Learning engineer with proficiency in Python. You should be able to apply your skills to solve a classification problem with a text dataset. Key Responsibilities: - Develop and implement a suitable ML model for the text classification problem - Conduct detailed data analysis and preprocessing Ideal Skills & Experience: - Extensive Python programming experience - Wide understanding and experience in Machine Learning, specifically in classification problems - Experience in working with text datasets - Familiarity with popular Python libraries used in ML such as scikit-learn, pandas, and numpy If you have a strong grasp of Machine Learning techniques, particularly in text classification using Python, then this is for you!

I'm in need of a website that is secure and provides my clients with ...clients with the ability to register and login. The key features of the site should be: - User registration - User login - User profile creation My clients should also be able to access an Excel file on our Onedrive cloud and extract pricing information from there. Finally, they should be able to submit their orders directly to us via email. This includes order details such as description, price, and delivery instructions. Additionally, clients should be able to attach relevant files to their orders. The ideal candidate for this project would have vast experience in secure website development, Microsoft Onedrive integration, and email integration. Familiarity with order processing systems would al...

I'm in need of an expert to resolve an intermittent email access problem on my Google Domains account. The issue seems to be related to the name server. Key Project Details: - I'm experiencing error messages when accessing my email on Google Domains. - The problem surfaces primarily when receiving emails. - The issue occurs once a day. The ideal candidate should have: - Profound knowledge of Google Domains, particularly in regards to email access and name server functionality. - Experience with identifying and resolving intermittent issues. - The ability to troubleshoot and fix email problems effectively. - Good communication skills for providing updates and potentially explaining the solution.

...tasks primarily centered around Excel and Word. - Excel: The emphasis will be on crafting sophisticated formulas and performing financial projections. I need someone with an understanding of finance and the ability to manipulate data in Excel. A depth of knowledge in Excel formulas, calculations, and data analysis is crucial. - Word & PDF: Apart from Excel work, there is a need for expert formatting and layout design skills in Word, as well as converting Word documents to PDF format. Finally, I am seeking someone who can apply a professional design to a CV. The style I want to embody is professional, and therefore a good understanding of professional layout design and typography will be beneficial. Ideal candidates should have proficient ex...

My furniture website is experiencing JavaScript-related problems. Page elements are not displaying correctly across all browsers, impacting our user experience. Your mission, should you choose to accept, is to diagnose and fix this rendering problem. I'll require a zoom call and screen-share for collaborating on this. A robust knowledge and practical experience in JavaScript, CSS, and HTML are essential. Proficient in debugging and error removal skill is a plus. Your solution should ensure the site runs smoothly and efficiently across all browsers after the fix.

I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data