Excel connection odbcemplois

expert in centos web panel and google cloud my website doesnt display help,come anydesk Secure Connection Failed An error occurred during a connection to cleopatraserver.click. SSL received a record that exceeded the maximum permissible length. Error code: SSL_ERROR_RX_RECORD_TOO_LONG The page you are trying to view cannot be shown because the authenticity of the received data could not be verified. Please contact the website owners to inform them of this problem.

I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completion of this project co...

I am in need of an Excel guru to assist with my project involving fewer than 5 sheets. Help is needed to organize and format data effectively. Beyond just basic formatting, the project also requires the use of advanced formulas, specifically VLOOKUP and INDEX MATCH. The ideal freelancer for this task should have: - Expert knowledge in Excel formatting and data organization - Proven experience in creating and using advanced Excel formulas like VLOOKUP or INDEX MATCH - Strong attention to detail and focus on data accuracy - The ability to complete tasks efficiently and on time. Rest assured, if this project is successful, there could be more opportunities for similar jobs in the future. Looking forward to your bids.

I'm looking for a proficient Excel expert with extensive experience in data cleaning to assist with a key task. Your primary responsibilities will include: - Identifying and removing duplicate data entries in Excel, Data cleaning - Creating Pivot tables and data aggregations - Efficient dashboard and visuals that showcases trends and patterns via graphical data representation. Please only bid if you are seasoned in creating pivot tables, using Power query and generating visually appealing data insights. Precision and attention to detail are essential skills for this project.

For this project, I need a skilled developer to create a data visualization webpage, similar to Google Earth. Ideal candidates should have a strong background in JavaScript, Python, a...shared with the selected freelancer. - Data: The website's function will be to display GPS coordinates (latitude and longitude) alongside relevant site information when hovered over. This would include Site Name, Site Description, and Site Statistics. - Source: All required data is contained in an Excel sheet which I will provide. The ideal freelancer would have experience in data visualization, and expertise in the programming languages mentioned. Additionally, a proficiency in working with Excel data is necessary. Detailed requirements and design specifics will be shared upon commen...

...in gathering text data from online resources and flawlessly entering it onto a spreadsheet. Key Responsibilities: - Sourcing text data from specified online resources - Accurately entering data onto a spreadsheet with minimal errors - Ensuring data entries are formatted correctly and uniformly within the spreadsheet Ideal Skills and Experience: - Proficiency in using spreadsheets: Microsoft Excel or an equivalent is required - Strong attention to detail: This is crucial to avoid mistakes in data entry - Experience in online research: Being able to quickly and efficiently find reliable online resources - Previous experience in data entry: A strong foundation in data entry tasks is desired. This project requires speed, accuracy, and a commitment to meeting set deadlines. If...

Hi Lin F., you have completed a scraping job for me for the last two years, I need it done again. Please have a look and apply: https://www.freelancer.com/projects/excel/Scrape-data-from-unprotected-URL

I need an expert to masterfully apply and tweak formulas and functions across entire rows and columns within my Excel spreadsheet. Your tasks will be to: - Implement formulas and functions - Apply them to entire rows and columns Ideal skills and qualifications for this job would include advanced proficiency in Excel, especially in applying lookups and mathematical functions like SUM, AVERAGE, COUNT. Proven experience with similar projects is highly preferred.

I am in need of a dynamic Excel tool to perform data analysis tasks. The tool must be designed using autofill drop down list, and it will be utilised for: - Employee name selection - The drop down list should offer an autofill option for employee names. - Tallying Totals - The drop-down list selections should be capable of tallying totals. For this project, the ideal freelancer will have strong experience with Excel, particularly with creating and managing drop down lists. Experience with data analysis in Excel will be beneficial. Your task will be to create an easy to use, and automated system that can manage complex quantitative data.

I'm seeking to develop a unique PCB design for a product that will use the STM32H7 microcontroller series. The board will need to allow for specific external hardware interfaces including a USB interface, USB-...Power connector. Ideal candidates for this job will have experience with the hardware details of the STM32H7 series and be proficient in the design of PCB's that incorporate multiple hardware interfaces. Proficiency in the following areas is desired: - PCB design for manufacturing - Working with STM32H7 series - Incorporating USB, USB-C, MIDI and power interfaces into designs - Handling debugger connection in the design. The successful delivery of this project will provide a PCB design ready for manufacturing. I hope you will join me in turning this design into a...

I'm seeking an expert in data collection to gather email addresses from a list of retail shop websites I have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A sprea...have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A spreadsheet in either .xlsx or .csv format with the email contact for each retail shop. Desired Skills: - Data Collection - Data Entry - Attention to detail - Proficiency in Excel or similar spreadsheet software - Familiarity wit...

Looking for a skilled developer who can automate the process of extracting text content from RTF code and organizing it in a categorized structure in an excel spreadsheet. On github, I see someone has tried to some success. The file is located: To begin with I am interested in the English file Years Foundation to Year 10. English MRAC/2023/07/LA/ENG HTML RDF/XML JSON LD SPARQL You goal is to extract the hierarchy and structure as a usable document to teachers. Learning Area (English) --> Year Level --> Aspect of the Achievement Standard (A sentence) : it may then have General Capabilities

I have a jewellery shop and would like to have a website with about 6 subpages and a small shop connection to Shopify. preferably the site should be made via Wordpress. I already have the content, i.e. the text, the structure, some photos are also available, it should be a modern kind of website.

I am seeking a proficient Excel expert to enhance macros within an existing spreadsheet. My primary concern involves re-scripting macros for performance enhancement. On top of this, the spreadheet needs to have its calculation functions updated in certain areas. Hence, the ideal candidate should be comfortable in tweaking and improving formulas for better functionality. I also anticipate that some redundant aspects of the macros may be stripped off as we progress to streamline performance. Required Skills: - Proven Macro scripting and implementation in Excel - Solid understanding and experience in complex formula manipulation - Ability to optimize spreadsheet for improved performance and efficiency. Note: Specific deliverables relating to the calculation changes will be share...

Hi, we are looking for fluent English speakers with customer service experience to answer inbound calls. It's a work from home position. You need to be completely fluent in english. you need to have a good internet connection. And you need to be available for 8h a day. The pay is 300$ CAD a month.

A personal existing instance MISP virtual machine running on TrueNAS Core at home. To be configured remotely via SHH over an OpenVPN connection, over via screen sharing. You must possess extensive knowledge in both MISP and Virus Total API and ideally have previous experience with similar integrations. The successful freelancer should be capable enough to carry out this integration seamlessly using an existing API key. Please ensure you fully understand the specified requirements prior to bidding for the project. Demonstrated experience in threat intelligence platforms or cybersecurity would be a huge plus.

I need a data expert who can perform inferential analysis on a dataset that is less than 1000 rows and columns. This task requires absolute proficiency in Excel, including functions and formulas associated with inferential statistics. Your ability to draw meaningful insights from raw data is essential. Skills Required: - Excel proficiency - Familiarity with inferential analysis - Ability to handle small to medium-sized datasets Experience preferred: - Previous experience in Excel-based inferential data analysis - Proven track record of data interpretation and insights extraction

...knowledgeable in PHP and MySQL databases to build a custom PHP class. We are currently using an old PEAR class and need a custom class written so we do not need to edit all the calls through the entire application. I have attached an example of a query call so you can see exactly how it is handled. So the class would need to support running this code. This class will need the following operations: - Connection to the MySQL database - Execution of SQL queries - Reading, writing, modifying, and deleting data - Creating and dropping tables - Fetching query results - Handling errors and exceptions Your background should include not only experience in PHP and MySQL, but a deep understanding of database operations and SQL query execution. An ideal candidate can confidently handle err...

I'm currently experiencing unexpected routing issues on an OpenVPN site-to-site connection between two locations, managed by two OpnSense routers. I need an experienced network engineer to provide remote assistance and resolve these issues. Key details to consider: - The problem arose after changes to ISP WAN IP addresses on the second router. - The difficulty lies in maintaining a consistent OSPF route. - All routers involved run the same OSPF version, same OpnSense and same FRR. Relevant Skills and Experience: - OSPF routing knowledge - Familiarity with OpenVPN and OpnSense routers, OpnSense. - Ability to diagnose and resolve VPN routing problems - Proficency in remote assistance tools and techniques.

...organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. To excel in this role, you'll need to work approximately 6 hours a day, 6 days a week. This schedule is designed to ensure continuity in my operations while allowing flexibility for you. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. Your ability to harness the full potential of these tools is crucial. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Excep...

I'm in need of a skilled developer with expertise in AppSheet, Excel, and ERP systems. Your task will be multifaceted, involving various aspects such as: - Data analysis and visualization - Spreadsheet automation - Developing an AppSheet app designed for ERP, focusing on billing, data collection, and data management The main functionalities I am looking for are: - Ability to generate and track invoices - Data entry and validation capabilities - Incorporation of Google Maps API - Budgeting features - Ability to export data to Excel A strong understanding of ERP systems, proficiency in AppSheet, and advanced Excel skills are essential to this role. Experience with Google Maps API is a significant advantage. You should be able to understand the essence and p...

Hi everyone, I will need a computer network analyst (ideally with cisco certification) with experience in measuring network delays, calculate jitter (with tools povided), do some graphs in excel etc. Analytical specific requirements in chat Deadline: 4/4 Budget: $20 USD

I am in need of an advanced Excel spreadsheet that will help track and output several key performance indicators (KPIs) on a monthly basis. The KPI dashboard should integrate the following parameters: - Sales pipeline - Revenue - Over $2,000,000 Per month - Overheads Average 3.75% of revenue for month - Gross profit 12 % - Projects on time >90 % - Defects closed <20 working days - Customer Satisfaction - Employee Productivity - Health and Safety The desired freelancer should have: - Proficient skills in Excel including pivot tables, charts, and formulas - Experience in creating KPI dashboards - Strong understanding of business metrics Please note that the dashboard should be mapped to be updated monthly. The focus is on clarity and ease of interpretation of the...

I'm looking for a talented graphic designer to craft a playful, creative logo for my company, CreatorMap. Our mission is to bridge the gap between creators and brands. While we serve a diverse crowd including artists, designers, influencers, content creators, and businesses, the logo should encapsulate the essence of creativity and connection. Key Considerations: - Style: I prefer a playful and creative design. I want a logo that stands out and embodies the spirit of the creative industry. - Color: I'm open to color suggestions. Whether it's a vibrant hue that pops or a soothing palette, let your expert judgment decide what works best. - Audience Appeal: The logo should speak to our primary target audience - artists, designers, influencers, content creators, and busi...

I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essential.

We have a requirement to work with Excel Power Pivot, Power Query Editor and prepare a Report. Very normal report and can be completed within couple of hours by an expert. I can pay maximum of INR1500/2000 for this first project but I will ensure, all my future work will be assigned to you. Looking for someone whom I can bank on for future. Thank you!

...the incorporation of serpents/pythons in food, arts etc 2. The ways serpents/snakes are viewed across that many different African Traditional Religions with an emphasis on the Python. The sub categories include: a. ancestor identity and worship (some view serpents/pythons as embodiment of ancestors b. the general connection to serpents/pythons to deities c. various worship and rituals connected to serpents/pythons - this might include how serpent images are used d. the connection to serpents/pythons to magic, "witchcraft" shaman activity/natural healing methods, curses, prophecy, sorcery, and divination Any other useful information should be considered. However, this essay should not be repetitive, in the sense that it uses many words to state very little facts...

I'm looking to build a online bookstore application utilizing ASP.NET Core API, React frontend,Mvc, and MSSQL database. The application should possess main features which include: - User registration and login - Product search and listing - Shopping cart and checkout The application will incorporate different user roles and permissions: - Administrators with...users with appropriate limited access. To be successful in this job, Freelancers should showcase their past work on related projects along with a representation of their comprehensive abilities. Your past experience in building comprehensive, user-friendly online applications will be invaluable as you implement these essential features. Note- My project is almost ready but i am stuck with the connection of Mssql and...

...high-quality gamification features centered primarily around informative quizzes and points scoring system with rewards and loyalty center. The key features of the app will include: - Quizification: engaging, informative quizzes to raise awareness about climate change and sustainability. - Gamification: user engagement through points and rewards system to incentivize eco-friendly actions. - Connection with Insurance Companies: The app needs to integrate with insurance companies' systems using APIs, mainly to fetch insurance quotes and policy purchase options. The ideal candidate should have experience in: - Cross-platform app development to ensure a smooth and consistent user experience across iOS and Android platforms. - Creating engaging and educational gamification fea...

I am in need of an Excel specialist who can handle a large dataset of over 51,000 records. The data centers around employee contributions to political candidates. Specifically, I require detailed analysis on: - Contribution patterns - Candidate preferences - Employee demographics As an Excel expert, you should be proficient in working with pivot tables and be able to identify trends within large sets of data. Your experience managing, analyzing, and interpreting datasets should be well demonstrated. In addition, there is a particular interest in providing a thorough analysis of contributions based on political parties. This will help to understand better the political leanings within the dataset. To apply, please highlight your relevant experience. I look forward to seein...

I urgently need proficient help with excel. The tasks to handle include but not limited to; - Data entry. - Data analysis using relevant tools. - Leverage advanced excel formulas and functions to streamline data processing. The data to handle resides within 1-5 sheets and contains both numeric and categorical data. Ideal skills for the job include; - Advanced proficiency in Excel. - Deep knowledge of data analysis methodologies. - Quick data entry skills. - Understanding of Excel functions and formulas. Experience in processing both numeric and categorical data on Excel is crucial.

I'm seeking a detail-oriented freelancer with strong skills in text data entry, Excel, and who is comfortable working with less than 500 pages of data. Key Requirements: - Proficiency in text data entry - Strong familiarity with Excel - Able to handle less than 500 pages of data The ideal freelancer should efficiently turn raw data into an organized Excel spreadsheet. Accuracy is vital in this job, as any mistake could lead to incorrect data analysis. Please provide evidence of your past experience in text data entry and working with Excel.

I am setting up new code from local host using Xampp, and move to a server with Directadmin panel. But i was failed when i migrate it to server...using Xampp, and move to a server with Directadmin panel. But i was failed when i migrate it to server The error in log is [Mon Apr 01 22:26:03.579055 2024] [proxy_fcgi:error] [pid 643251:tid 139908475770624] [client ] AH01067: Failed to read FastCGI header, referer: [Mon Apr 01 22:26:03.579121 2024] [proxy_fcgi:error] [pid 643251:tid 139908475770624] (104)Connection reset by peer: [client ] AH01075: Error dispatching request to : , referer: Thank you. My server specs : AMD EPYC™ 7402 RAM 64GB RAM Disk 80% Free I am using Apache and Nginx with proxy mode, php-fpm 8.1

...particular, the project involves connecting with potential small business owners to gauge their interest in selling their businesses for an attractive price. ***Bids without link to a call recording will not be considered*** Key Responsibilities: * Primarily targeting retail and manufacturing sectors and all variety of small businesses. * Focus on businesses in the local area. * Establish a genuine connection with potential business owners. * Identify potential leads and convert them into opportunities. Preferred Skills and Experience: * Proven experience as a telecaller or similar sales/customer service role. * Experience in Lead Generation within the retail and manufacturing sectors. * Strong understanding and experience in the small business market. * Excellent communicati...

For days I have been trying to migrate a database (MSSQL to MySQL) using ODBC Datasource Administrator unfortunately this is not successful I get error 1822 "Missing index for constraint". I'm just doing it as an exercise, it's not a business project. I wanted to know if anyone here could help me with this. I also tried with AWS the problem is the same (constraints), it doesn't work.

...exercise materials for Excel, with a particular focus on Excel Macros, Array formulae, forecasting, countif, if statements, and all LOOKUPs. All exercises should come from dataset or data files KEY REQUIREMENTS: - The labs should cover 10 advanced topics, including but not limited to Excel Macros. - For each topic, I need 5 well-thought-out lab exercises created with step-by-step answers. - The exercises must be suitably challenging for advanced-level Excel users. - Each exercise should come with a step-by-step questions and answers guide to aid understanding. IDEAL SKILLS: - Extensive knowledge of Excel, especially in Macros and VBA programming - Proven experience in developing training materials or lab exercises. - Familiarity with financial modeli...

I'm in need of an expertly designed Excel spreadsheet that will serve as a dynamic sales reporting template. This tool will play a significant role in tracking and analyzing data related to various aspects of sales. The successful candidate in this role will incorporate tracking capabilities for variables such as: - Product sales - Revenue by customer - Customer % of revenue Furthermore, the spreadsheet should provide robust reporting on seasonality, current month vs prior year, and fiscal year to date (FYTD) vs the prior year. This comparative analysis is crucial in understanding trends and informing strategic decision making. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating dynamic reporting tools - Understanding of sales data analysis - ...

This project entails creating a Power BI report that is linked to Excel spreadsheets for trend analysis purposes. The main user of this report will be the sales team. I'm seeking a professional with: - Expertise in Power BI and trend analysis - Proficiency in handling and linking Excel spreadsheets to Power BI - Familiarity with sales data and crafting useful reports for sales teams. Your primary objective will be to create a functional, insightful Power BI report, providing our sales team with meaningful trend analysis based on our historical data stored in Excel spreadsheets.

For Excel sheet data typing, you'd be looking for someone proficient in data entry and manipulation, preferably with experience in Excel. Here are the ideal skills and experience: Proficiency in Microsoft Excel Accurate and fast typing skills Attention to detail to ensure accurate data entry Familiarity with common data manipulation tasks in Excel such as formatting, sorting, and filtering Ability to handle large amounts of data efficiently Knowledge of basic formulas and functions in Excel for data analysis and manipulation Experience in working with different types of data formats and structures Strong organizational skills to manage and organize data effectively Ability to troubleshoot and resolve data entry issues Understanding of data privacy a...

Need to upgrade my existing excel macro, very simple project

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

Unify TXT files into Excel. (This data is good) This is a data merge project. Merge data from 3 txt files into excel. This is NOT a simply copy paste. The data needs merged. The data from 2 of the files will become columns of data in the 'master file' (see below) Download 2 files from here: Download 1 file from here: Note: This is public data it is completely permisable to use it. The files listed are: Deeds - don't use this file Owner: 1,817,424 lines. Step #1 for this file: Delete all rows that the aka pct_own is 0.000. This data will become columns of data in the master file ie: Owner 1 ln_num

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

...need an Excel VBA utility that is able to perform calculations, specifically advanced financial modeling for cost using VBA & Macros. I require complex projections for various scenarios to be calculated through this utility. This tool should enable me to: - Efficiently perform cost calculation for a project and financial based on inputs - Efficiently calculate the cashflows automatically based on the inputs. - Generate advanced financial projections incorporating different scenarios. Ideally, the freelancer taking this project on would have a robust background in both financial analysis and Excel VBA programming. Proficiency in financial modeling (Including Project cost calculation) and a solid understanding of finance principles is necessary. Experience with develo...

Necesito realizar la conexión de mi sistema POS-PHP por medio de un web service o API al software de un proveedor tecnológico colombiano que presta este servicio. Dejo adjunto el manual del webservice y un ejemplo del xml que debe generar mi programa para llamar la información.  I need to connect my POS-PHP system to the software of a Colombian technology provider that offers this service through a web service or API. I have attached the webservice manual and an example of the XML that my program must generate to call the information.

DEVELOPMENT STRATEGY AND EXECUTION MARKETING SON CAVALLS - HORSE ASSISTED COACHING ON MALLORCA We need somebody how talks English and German. Description of the business Son Cavalls in Mallorca for which we are seeking new clients in the form of corporate groups, individuals, and private groups. Son Cavalls, under the leade...their full potential. These coaching sessions are based on a holistic approach that incorporates body, mind, and soul. PRIVATE GROUP RETREATS Son Cavalls also offers group retreats that provide an intensive experience of personal transformation in a communal environment. These retreats offer the opportunity to connect with like-minded individuals, gain new perspectives, and establish a profound connection with nature. For more information, visit www.sonca...

...proficient with Blazor C#. Our project currently has few runtime error that needs a fix. Specifics about when and where this error occurs will be provided after we've started. There are only two pages that needs your fixing. 1. location page Show Message that data has been edited, saved or delete. When user clicks on specific item data to be loaded in textbox Search is not working Export data to excel with formatting 2. Login page Issue with adding new user (password not getting captured) Add roles and claims (department) When user click on user form the table it should Edit user details including email address Only admin user to have right to Add/edit this page. Other user can only view the details. Search is not working. When new user is create a Confirmation email shou...

FRONT-END DEVELOPER. This is for the development of a proof of concept dashboard, which is to display static data (no backend or connection to api needed). SPECIFICATIONS: [1] Create dashboard to match UI example (attached). [2] Add a drag-drop function to move sections around (). [3] Make mobile and browser responsive. [4] Add a bar-chart option. [5] Have a LIGHT and DARK mode (Dark theme = #01051d & Light theme = #ffffff) [6] Allow for a pie chart [7] Allow for a text-block To ensure you have read the requirements, please include the % of missed calls within the example UI at the beginning of your proposal.

I urgently require an adept designer with proficiency in graphic design, logo creation, and branding. Mastery in Adobe Illustrator will be beneficial to the successful completion of the project. Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organizat...Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organization. * Incorporate engaging animation effects. * Execute graphic design tasks including logo design and branding. Candidates with keen attention to detail, a commitment to meeting tight deadlines, and a background in corporate or formal PowerPoint presentation design will excel in this role. Immediate ability to start on the project is a ...

I need assistance with data collection from online databases, primarily working with customer data. This role involves gathering and organizing necessary information into a structured and usable format, and will require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer data - Verification skills to ensure data accuracy - Excellent understanding of data privacy standards Experience in similar projects will be highly appreciated. Knowledge of CRM systems will be a bonus, but is not mandatory. A successful partnership on this project could lead to long-term collaboration.