Tally using microsoft excel jobs
As the project lead, I am in urgent need of a self-driven and detail-oriented freelancer who specializes in online data entry. This project's volume isn't specifically set, but the selected individual should be prepared to handle a potentially large amount of data entry tasks. Tasks will include but are not limited to: - Prompt and accurate entry of data into our online system. Ideal candidates for this job should have the following skills and experience: - Proven online data entry experience, with references or portfolio to back it - Dedication to efficiency and accuracy - Ability to work under unknown volume pressure - Availability to start immediately would be an advantage Unfortunately, we have not yet established a definitive deadline, so freelancers with some de...
I am looking for a skilled data analyst who can proficiently use Excel to perform text matching between two different Excel files for the purpose of matching the most appropriate description given to a medical service code . No significance testing is needed in this project, it is purely a direct comparison task. I have particular requirements pertaining to "Data set A". Your role will be primarily centred around: - Matching text in one Excel sheet to another. - Consolidating data based on text matches. - Focusing specifically on "Data set A". Ideal candidates should be experienced in Excel, data consolidation and comparison. Knowledge on data set handling would be a plus. Please bid accordingly, ensuring your capabilities in these areas ar...
I'm looking for an experienced data manipulator who can efficiently reformat my data according to CRM-specific requirements. Specifically, I need the address and names in my data to be split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split...split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split 'Names' into two separate columns: 'First Name' and 'Last Name'. This does not require any data entry, just an understanding of data structures, and layout according to CRM needs. Ideal freelancer should h...
I am setting up a new business, selling Moodle courses online. I will be using EKM as my website / payments platform. I will need to automate the following 1) Customer order in EKM Trigger = new customer order. Automate the entry of key data into a Google Sheet or Excel File 2) Customer details added to Google Contacts 3) Integration with Moodle - Creating a new Moodle account (if a new customer) - Giving access to the particular Moodle course that the customer has purchased I am still in the set up phase, so can design my processes / workflow to make automation easier (i.e. this is, relatively speaking, a blank piece of paper). I am seeking an expert who is proficient in Zapier automation. My project revolves around streamlining the user enrollment process. Project b...
As a booming brand on Instagram, Facebook a...compelling Meta ads and formulating innovative strategies. *Key Areas of Focus:* 1. **Strategy Development:** Demonstrated experience in creating strategies to increase engagement on social media. 2. **Meta Ads Expertise:** Proven ability in leveraging Meta ads effectively. Experience creating captivating ads that drive engagement is key. 3. **Cross-Platform Proficiency:** Ideal candidate should excel in Instagram, Facebook, and YouTube; ability to create cohesive strategies across all platforms. Our perfect fit would be someone who is a pro at researching, understanding and connecting with our audience, inciting genuine interactions to foster a deeper relationship with our brand. Think you can make this happen? Then we can't wa...
I have a simple Excel VBA macro file (attached). The file shows up an additional toolbar on my personal PC, but does not show toolbar on client's PC. NOTE: The client can still run the macro code using the button placed on the grid. I just need to know the right group policy that needs to be setup correctly.
I am seeking an experienced data entry clerk for the task of entering data offline into a Microsoft SQL Server database system. Key Tasks: - Entering large amounts of data consistently and accurately - Ensuring all offline data is represented accurately in our SQL Server system Ideal Skills and Experience: - Proven offline data entry experience; accuracy and attention to detail are crucial - Hands-on experience with Microsoft SQL Server - Knowledge of database structure and data principles - Excellent time management skills to meet deadlines. Prior experience with large databases is highly beneficial. The successful candidate should be familiar with SQL Server, familiar with offline data entry, and have a keen eye for detail.
I'm seeking a proficient Excel user who can deftly analyze my amalgamation of patient's research data. The data in question comprises of medical histories, treatment outcomes, and demographic information. Further, I need an in-depth exploration of the correlation between investigations and treatment outcomes. The ideal candidate will need to: - Process and analyze lab test results, heart rate, and temperature records. - Correlate these factors with treatment outcomes. - Extract meaningful insights from medical histories and demographic data. Experience with health-related research data is a plus. Your analytical skills, attention to detail and knowledge of Excel are paramount.
As the client, I'm seeking a skilled Excel VBA macro specialist who can create an automated system for a repetitive task in our operation. The task in question involves a data entry form consisting of Product, Quantity and Price fields that needs to be automated. As a professional with deep knowledge in Excel VBA, automation and data entry, you have: - Proven experience in crafting Excel VBA macros. - Proficiency in automating repetitive tasks. - Extensive understanding of data manipulation. - Excellent knowledge of Excel formulas and functions. Your main job will be to create a macro to automate this data entry form. This will involve auto-filling data into the respective form fields where necessary. This efficiency-generating macro should serve to eli...
I am looking for an individual experienced in AI, preferably with knowledge of Microsoft Azure or a similar platform. The task requires the conversion of a dual-language book, found at the following link - into a .tmx file format through the use of AI. Essentials for this project are: - Knowledge and experience with AI, ideally with Microsoft Azure - Proficiency in English and some knowledge of German language - Ability to convert a book into .tmx format This is a personal project, however, it's associated with an NGO. It is beneficial if prospective freelancers have experience working on similar projects. There is the potential for recurrent work, contingent on the successful execution of this task. Due to the nature of the project, a commitment to quality and timeli...
I'm on the hunt for a proficient Facebook ad expert who will drive our digital agency forward on the basis of lead generation and sales. The successful candidate must: - Be knowledgeable and experienced in generating leads and sales through Facebook ad campaigns - Excel at developing and implementing ads targeted towards our tailored audience - Be proficient in designing and promoting compelling video ads Having a background in digital agencies would be highly advantageous. It's paramount for the candidate to be results-driven and have a track record of successful lead generation.
I need someone to build me 3 different deepfake detection models trained on DFD Challenge dataset by Kaggle
I need an Excel expert to customize specific features in my existing utility. The chosen freelancer will focus on the following: User interface modifications: I have a preference for a minimalistic design. The interface should be clean, intuitive and not cluttered for easy navigation. Formula automation: I want to automate various tasks like data validation rules, calculation automation and data sorting and filtering. You should be able to craft these tasks to improve efficiency in data administration. Data analysis enhancements: Lastly, I want to enhance the data analysis functionalities to help with strategic decision-making. The ideal person for this project should have in-depth experience with excel and particularly in building and customizing excel utiliti...
I am looking for an expedient and detail-oriented freelancer who can perform data entry tasks for my project within 1 to 2 weeks. The task will involve entering a mix of numeric and textual data accurately into an Excel spreadsheet. Requirements would include: - Proficiency in Excel for efficient data entry - Excellent attention to detail to ensure data accuracy - Ability to meet strict deadlines to complete the task within the agreed timeframe - Prior experience in data entry, specifically with mixed data types Preferred Skills: - Proficiency in Excel - Attention to detail - Time management skills - Experience with handling mixed data types This job will entail the completion of data entry requirements with attention to detail, speed, and accuracy. Please submi...
I'm currently facing issues with updating files from SVN repository on SharePoint 2016 Server. After opening a file in Word and attempting to save, I keep receiving the error message "Upload Failed. We are sorry this does not work". Key Duties: - Diagnosis of Tortoise SVN and SharePoint 2016 server integration issue - Solving the aforementioned file updat...and SharePoint 2016 server integration issue - Solving the aforementioned file update failure error - Implementing a solution to ensure future effective versioning and file saving Ideal Skills: - Proficiency in SharePoint 2016 Server - Extensive knowledge of Tortoise SVN software - Exceptional troubleshooting skills - Understanding of repository management and versioning - Ability to work with Microsoft Word and...
I need expert guidance to optimize and integrate our in-house applications built on Django. Our applications range from AI chatbots for consultants to excel mapping. Django has already been installed, a main APP has been created, each application is intended to run as an API. Here's where you come in: - Optimize Application Performance: Help us enhance the speed and efficiency of our apps. - Integrate with External APIs: Guide us on how to effectively link our applications with external APIs. - AI Application Development: We want to create AI apps in a more efficient manner. Your insights will be valuable. I expect freelancers applying to this project to have: - Experience: relevant experience in Django and AI application development, and API integration. To make an inf...
As someone with a keen eye for detail and a knack for keeping things organized, I’m seeking an expert freelancer who is proficient in Excel for some important data entry work. Main responsibilities: - Entering mixed type data (both numerical and text) on an Excel sheet - Ensuring accuracy and precision in data entry - Clear understanding and implementation of data verification/validation rules during the process The ideal candidate should have: - A solid 4-5 years of experience in a similar role, preferably in freelancing - Competence in Excel and general data entry tasks - Ability to work efficiently and effectively without compromising on quality Kindly submit bids with proven track record and specific previous project details. Applications without this may ...
...need a professional to retype business documents. - The documents include text with accompanying images. No charts or diagrams are involved, but the freelancer should be adept at handling text/image combinations. - The documents do not require any specific formatting. Please retype them as they are, maintaining the original layout. - The ideal freelancer for this project would be competent in Microsoft Word or a similar application, and have a strong attention to detail to ensure no typographical errors. - Experience in retyping business documents will also be a great advantage. - Your work will revolve mainly around typing, so touch typing skills with a fast typing speed will be highly appreciated. Your ability to maintain confidentiality of these business documents will b...
I am on the look-out for skilled individuals who excel in the spheres of web creationn and social media marketing to join my agency. The primary goal of our agency is to increase brand awareness for diverse businesses, our target audience. Required Skills and Experience: - Expertise in web creation: Being able to create user-friendly and visually appealing websites is crucial. You should also be adept at responsive design to ensure the sites function well on varying devices. - Proficiency in social media marketing: Proven expertise in developing and executing social media strategies to boost brand visibility and engagement is needed. Familiarity with marketing analytics to monitor and adjust strategies as required would be advantageous. Past experience working with businesses and ...
hi, i found a php script that is not working anymore, it was used to send notifications to single devices using but this system seems to be down.. I have the certificate updated and ready in .pem and .p8 format and the old function looks like this: function sendNotificationToPushService($certificate, $passphrase, $body, $deviceToken){ $ctx = stream_context_create(); stream_context_set_option($ctx, 'ssl', 'local_cert', $certificate); stream_context_set_option($ctx, 'ssl', 'passphrase', $passphrase); $fp = stream_socket_client('tls://', $err, $errstr, 60, STREAM_CLIENT_CONNECT, $ctx); if ($fp){ $payload = json_encode($body); $msg = chr(0) . pack('n', 32) . pack('H*', $deviceToken) . pack('n', strlen($pay...
I need a diligent and efficient worker to help with data entry into an Excel sheet. The scope of work will be entering simple text entries. Requirements: * Reliable and fast typing skills * Prior experience in data entry * Ability to pay attention to details * Deliver on-time and with accuracy Application: In your application, kindly include your past work related to Excel data entry. I am interested to review your related experiences and proficiency. This assignment could lead to an ongoing partnership if your work is of high quality. Thank you in advance for your interest in this project.
I'm looking for a detail-oriented professional capable of typing data from a variety of sources, including online databases and software outputs, into Excel. The objective is to conduct data analysis. Though the typical size of each data entry has not been specified, a flexible approach to handle varying volumes of data will be beneficial. Ideal Skills: - Strong data entry skills - Proficient in Excel - Strong understanding of data analysis - Capable of adapting to varying data volumes - Experience with online databases and different software outputs.
I am seeking a proficient freelancer with solid Excel skills who can help me populate my Excel sheets. While no specific type of data is mentioned, good typing skills and attention to detail will be beneficial due to the nature of the project. The work would require timely and accurate typing of any kind of information whether it's text, numbers, or dates into Excel sheets. Since no further specific details were provided, showing an array of competencies, from past experience to detailed project proposals, in your application would set you apart. Ultimately, the main intent here is to organize information effectively without a specific analytical or reporting goal in mind.
...accurate, high-quality transcriptions from original academic articles, converting them into a digital, editable format. -The transcribed documents need to be formatted in Microsoft Word, maintaining the original layout and content structure of the articles. Attention to detail and typing accuracy are crucial. -The ideal freelancer for this job should have a strong command of the English language, including grammar and punctuation, as well as experience in academic writing or transcription. Familiarity with technical or scientific jargon is a bonus. Your task will include delivering the transcription in a Microsoft Word format, maintaining the substance and organization of the original articles. You should be able to provide error-free work and respect tight deadlines...
I need a professional who is skilled in Excel data analysis. The project revolves around typing text data from an Excel sheet for the purpose of analyzing it. Here’s what you have to do: - The data to be typed is text data. - The data needs to be in tabular format. - You should be experienced in typing and data analysis. The ideal freelancer should know Excel inside out, be highly efficient in data typing, and have a strong track record in data analysis. Being detail-oriented and having strong organizational skills will be a plus.
I am on the search for a capable PART TIME virtual assistant to manage tasks for my small website company. The successfu...primarily through email communication. The following set of responsibilities are expected: - Conducting efficient email management. - Effectively managing calendar schedules. - Carrying out regular data entry tasks. Primarily, the assistant will be in charge of: - Scheduling essential meetings. - Assigning tasks and deadlines. - Keeping track of progress and deliverables. Ideal candidates should excel in project management, have strong attention to detail, be adept at multitasking, and possess excellent interpersonal and written communication skills. Previous experience in a similar role or in the midst of a team would be highly valued. Looking forward to ...
Dear Swati G, As a seasoned virtual assistant from Kenya, I specialize in telemarketing and online appointment scheduling, offering 10-20 hours weekly to ensure your administrative tasks are managed with utmost precision. Proficient in Microsoft Office and Google Workspace, I adeptly handle email management, calendar organization, and data entry. My experience extends to social media handling, where I maintain engagement and manage communications effectively. Equipped with reliable calling platforms for seamless US interactions, I bring a detail-oriented and organized approach to multitasking in a virtual setting. My commitment to excellence is unwavering, and I am confident in delivering high-quality service that aligns with your project’s needs. I look forward to the oppo...
I want to get a website developed in CakePHP 5 or Laravel 10 having following features: Admin (Using Authentication) 1.) Login, logout, roles (ACL if available in build) 2.) Users section with list, add, edit, delete, active and inactive user. Use ajex to check duplicate user email while adding and updating user. 3.) Categories and sub-categories 4.) Blogs (List, add, edit, delete, active and inactive), Meta title, Meta keywords, Meta description 5.) Page Manager 6.) Contact us list (With email) 8.) Export an excel having blog title, number of views, date created, user name columns and in last total of columns. Front-end: 1.) Landing page showing featured blogs and having menu of categories and sub-categories. 2.) Categories list page showing number of sub-categories of...
I'm seeking a talented designer to create a new, minimalistic design for my website's front page. The task involves transforming the current design on Wix to suit a minimalistic style utilizing Envato Elements. Key aspects to be redesigned are creating this website as is using new template People with experience in minimalistic design, preferably with Envato Elements, are the most sought after for this project. If you have a keen eye for aesthetics and an understanding of envato elements, this is for you
...kinds of expenses for my business. This should include: - An understanding of how to categorize expenses into staff salaries, subbie payments, materials, and individual staff hours on a daily basis. - The ability to record relevant information for each expense entry, such as the date, description, amount, payment method, as well as individual employee details including dates and times. - Advanced excel skills and experience in financial data management will be ideal for this task. You will be building a tool that will be central to my business's financial tracking, so an attention to detail and understanding of financial data is key. - Experience in creating similar tracking spreadsheets will be highly valued. Please include details of similar projects in your proposal. A p...
Looking for an expert to assist in creating exceptional academic presentations focusing on Business Strategy and Financial Reports. This project will also involve Excel, PPT and word related work, so proven experience in data analysis using these softwares is crucial. The data will be provided by me, but I shall require assistance in making the reports and presentation look and feel professional, intuitive and inimitable. Key Requirements: - Proven experience in designing academic presentations - Expertise in using Microsoft office (or any other software, however the final product needs to be in word documents) - Proficiency in Excel for data analysis The ideal candidate should be able to convey complex financial and business strategies concepts visuall...
I'm looking for a guide on how to display medium-resolution (0.5m-2m) ECW image using GeoServer and Leaflet. This image will be serving the purpose of analyzing geographic data. The expected level of interaction is a static display with zooming and panning functionality. • Skills and Experience: A deep working knowledge of GeoServer and Leaflet is required. Previous experience with geographic data analysis and working with ECW images would be a real asset. • Project Goals: Achieve robust static display of a medium resolution ECW image. Develop zooming and panning capabilities to allow detailed analysis. • Deliverable: A step-by-step guide detailing the process of achieving this task.
I need virtual assistant, easy work just copy paste. More discusse with freelance chat...
...charges in bid for this project For this project, I'm looking for a talented programmer who is highly-experienced in working with MySQL and Excel VBA. Your task will be to create a MySQL table with 3 columns. This table will be used in conjunction with Excel VBA to import data. Here are some specifics about the project: - The Excel sheet contains similar data types in a single sheet. - The data type is primarily text strings. - We need a VBA process to export these Excel data strings into our newly created MySQL table. Ideal Skills and Experience: - Expert knowledge in MySQL and Excel VBA. - Proven experience in data import/export between Excel and MySQL. - Detail-oriented and accurate in data handling. - Focused on meeting project ...
I'm seeking a skilled Python programmer to develop a software module that can retrieve and process data from an Excel file. This bespoke software needs to display the data like a railway station scroller, strictly text-based. Key functionalities required include: * Picking data: The tool should extract data from the Excel file and output each row sequentially. * Sorting: While the display should be row by row, the order should be according to a certain criterion, instead of the original Excel sequence. Ideal Python programmer would bring: * Proficiency in Python programming, particularly in handling excel files and data sorting. * Previous experience or knowledge of creating text-based scrollers would be a plus. * Understanding of data presentation and...
As an applicant for US EB1A green card, I need a quantitative perc...of my citation record vs. my peers in the field of 1) membrane science or 2) polymers & plastics. I need the freelancer to: - Extract citation data using OpenAlex in 2014-2023. - Compare my citation record (212 times, per Google Scholar, ) and h-index (8, per Google Scholar) with other researchers in the field of 1) membrane science or 2) polymers & plastics. The ideal candidate for this project should have: - Proficiency with OpenAlex or similar tools. - A strong background in citation metrics. The output from the analysis should be similar to 3 charts in the attached Microsoft Word attachment (ignore the name on the top, just focus on the curve and table)
I'm in need of a proficient data entry operator experienced with Tally ERP 4.1. The successful freelancer will undertake the following responsibilities: - Enter purchasing records and financial transactions within the Tally ERP system. - Expected workload will be between 100-500 records and transactions. Ideal skills include: - Previous experience with Tally ERP 4.1. - Strong data entry skills. - Emphasis on accuracy and attention to detail. - Understanding of purchasing records and financial transactions. Please, prepare your bid taking these requirements into account. Thank you.
I'm seeking a highly proficient data entry specialist to handle an extensive project. Your primary tasks will be to populate databases and spreadsheets, complete online forms, and organize documents and files. To be successful, you'll need to be proficient in the following areas: - Mastery of Microsoft Excel and Google Sheets for extensive input and data organization - Experience in dealing with online forms and ensuring accurate data transfer - Capability to handle large volumes of data - the project involves more than 500 entries Attention to detail and efficiency are paramount for this project, along with maintaining data confidentiality. Previous experience working with a large dataset would be advantageous.
My project requires a proficient programmer familiar with Excel VBA and MySQL integrations. I'm seeking a solution that incorporates: - Database creation, modification, and updating - Data import and export via Excel VBA The VBA code should be capable of following tasks: - Reading data from the MySQL database - Writing data to the database - Updating existing data - Deleting data I'll be working with various kinds of data, including: - Text data - Numeric data - Date and time data - Binary data Knowledge of Excel VBA programming and MySQL database management forms the crux of this project. Experience in handling different data types and proficiency in database operations will be of paramount significance.
...in gathering emails of a list of companies I already have at hand. The job entails the following: - Extracting emails of the listed companies. Key job requirements include: - Proven experience in web scraping, data mining and Excel - High attention to detail and accuracy - Familiarity with email gathering processes The purpose of these emails is for sales and marketing purposes; thus, discretion and adherence to GDPR and other privacy laws are of utmost importance. The list I'll provide is in Excel format, therefore a good understanding and efficiency in Excel would be greatly beneficial. Please note that the turnaround time for this project is also very crucial, so your ability to work effectively within a given time frame is key. Please only bid if ...
I have a registration system where players sign up for a sports event. These entries are in Wordpress and when they register the data gets pushed to a different system. There are about 200 records that did not sync and I need someone to manually go through and resync these. I'll provide an Excel file of the records that need to be resynced. To do this: 1. Login to Wordpress 2. Go to: Forms > Entries > Choose 'Spring 2024 Flag Football Registration' 3. Search for the players last name 4. Hover over their entry and click 'Resend' 5. Wait for it to process, then do the next one 6. Here is a video of the process: 7. You need to wait for each to finish to start the next, but you can 'resync' multiple at a time
I'm seeking an experienced professional to assist in migrating our application data and databases to Microsoft Azure from our current on premise system. Job Overview: - Migrate less than 1 TB of data to the cloud. Ideal Candidate should have: - Extensive experience with Microsoft Azure. - Proven track record in data migration particularly application data and databases. - Excellent problem solving skills should issues arise during the migration process.
I'm planning to start a business and need an extensive research to be completed. I need data from US cities to be gathered, analyzed and published so the public can learn. Key Deliverables: - Collection of various data points such as population demographics, crime...the source, etc. - Starting point will be surveys published that will be provided to you on topics such as "Best place to retire in the US." Ideal freelancers for this project should have: - Experience in market research and data analysis. - Understanding of the U.S. regions and cities. - Ability to meet strict deadlines. - Clear and concise reporting skills. - Provide your research in an MS Excel document This project will require a keen eye for detail and the ability to present data in an understand...
We're on the lookout for self-motivated sales reps ready to roll up their sleeves and boost their earnings with our natural herbal products. With a proven track record and satisfied customers, our products offer a lucrative opportunity for those willing to put in the effort. Responsibilities: Drive sales of our natural herbal products to prospective cus...profit-sharing opportunity. As you contribute to our products' success, you'll share in the profits generated. If you're hungry for success and eager to boost your earnings through hard work, this is the opportunity for you! Join us in spreading the benefits of our natural herbal products far and wide. Ready to seize this opportunity? Submit your application detailing your drive and determination to excel in...
Hello, I have around 400 Postcodes in the UK, and out of those 300 are already done, so you need to search for the remaining postcodes on a website, I will provide you with all the ...remaining postcodes on a website, I will provide you with all the details along with a video tutorial + other details I will provide through WhatsApp messaging and calls. You will know about taking screenshots, I have a free Chrome tool, and I will provide it. it's a Very Urgent Project, so if you can start work Immediately and finish within the next 24 hours, then only apply. You should know the Excel and web-based copy/paste knowledge. This is a challenging job, and who can handle the pressure, the right candidate can get regular work. Hindi-speaking people will get preference. Happy B...
I'm in need of a specialist in Microsoft Advertising (formerly Bing Ads) to implement and set up the Universal Event Tracking (UET) tag on my Shopify store. The main aim of this project is to accurately track customer's behaviors, focusing specifically on completed purchases. Ideal Skills and Experience: - Proven experience working with Microsoft Advertising and UET tags. - Comprehensive understanding of Shopify's platform - Strong background in web analytics and tracking customer behaviors. - Practical experience in tracking conversion metrics, specifically for completed purchases.
I need a professional with experience in Power Automate, setting up an automated flow to a SHARED mailbox, saving the files to Dropbox. Potential renaming of these attachments will be an added advantage. Advanced skills with Microsoft 365, Dropbox, and automated flows are imperative for this role.
I'm in need of a proficient individual with strong data extraction skills and a good knowledge of Excel. The task is focused on extracting both text and image data from 1-2 websites. It is essential for the freelancer to have capabilities in: • Website data extraction • Handling of both text and image data • Organizing and managing the extracted data in Excel. An eye for detail and a knack for organization would be key for this project. Experience in similar projects is also a great advantage. This task requires utmost accuracy and adherence to deadlines, thus a freelancer with a track record for prompt delivery would be ideal.
I am in search of a proficient freelancer who can guide me through the process of learning and constructing coding frameworks for advanced energy demand forecasting methodologies to analyze the linear and non-linear trends of weather, urbanization, GDP & price with energy demand. My focus is on leveraging statistical and machine learning techniques for a trio of applications: energy demand(consumption ) forecasting and production/imports gap. Key Elements of the Project: - Introduction to and code development for ARIMAX, SARIMA, MARS, Random Forest, and XGBOOST models. - Application of these models to energy production/imports demand analysis, with a specific eye on predicting energy consumption and forecasting demand. - Utilization of diverse data sets including historical energy con...