Excel vba sql server jobs

I'm looking for a seasoned Data Scientist to analyze my structured financial dataset. This project entails identifying patterns and correlations that can be used to establish conditional fil...identifying potential investment opportunities. Key Responsibilities: - Examine a structured dataset primarily focused on the financial and investment sector. - Identify recurring patterns and correlations within the data. - Develop conditional filtering criteria based on your findings. Ideal Skills and Experience: - Proficiency in data analysis tools and programming languages such as Python, R, SQL, etc. - Proven experience in financial data analysis. - Strong ability to identify trends and correlations within large datasets. - Prior experience in developing conditional filtering crit...

You will get a high-end and robust calendar based entirely on Excel! I have over ten years of experience in automating tasks in Excel using formulas and VBA code, and I know that a few automations at the right spots can simplify your daily routine, save you dozens of hours, and boost your performance while focusing on what matters! In the delivered calendar, you will have the option to customize the categories/personnel that will be assigned the tasks or appointments. Based on the selected version, more features are available, like customizing colors, attaching documents, exporting to PDF, and more.

I'm looking for a Kolkata-based professional with extensive experience in Linux server management, PHP, and blockchain development to help me create a robust email marketing server. This server's primary function will be to send bulk emails. Key Requirements: - Expertise in Linux server management - Proficient in PHP and blockchain development - Experience in setting up email marketing servers Please note that this is a face-to-face (F2F) project in Kolkata.

I'm seeking a data analyst with experience in SQL and Crystal Reports. The task involves creating a crystal report to generate monthly Intrastat declarations derived from our sales data. This data is stored in a SQL database and needs to be transformed into Excel format for the reports. Key components of the reports: - Sales data fields: Product information, Transaction value, Date, Invoice No, Customer Name, Item Description, Quantity, Item Amount Value, Nominal Code, SIC, Weight Each, Line Weight Amount, Gross Amount Value, Type, Customer VAT No. - Customer-based segmentation for the reports. Ideal skills: - Proficiency in SQL and Crystal Reports. - Experience with sales data analysis. - Ability to segment data by customer. - Excel expertise for ...

I'm looking for a professional with extensive experience in MS-Access and VBA to help me fine-tune my existing database. This database tracks the stays (assignments = Ents) of school members (participants = Tln) who are doing internships or foreign courses at specific locations (hosting organizations = AO). Ideal expertise: - MS-Access (2016) proficiency - VBA scripting skills - Data integration troubleshooting - Report generation optimization The project involves: - Modifying the existing forms and layouts - Improving the data integration between tables - Enhancing report generation Most of the tables, forms, queries, and reports are already set. However, some integration points need to be adjusted, and this is where your expertise will come in handy. An extensive do...

I'm seeking a professional with experience in deploying Node.js and Angular projects to assist in hosting my project on my server. Ideal skills and experience: - Proficiency in working with Node.js and Angular - Prior experience in project deployment - Familiarity with server management - Understanding of web hosting principles Please note that I've skipped some questions regarding the server type, setup of specific environments or services, and domain name. Your expertise in assessing and addressing these aspects will be crucial.

wordpress 404 error for the plesk server i have tried to resave the perminany Link seems not working may anyone can help, thanks

I'm seeking a proficient English typist to assist with transcribing scanned images into PDF documents. The tasks will include: - Typing documents from scanned images - Data entry into MS Excel - Copy and paste tasks Ideal candidates should have exceptional typing skills with a knack for accuracy and speed. Proficiency in MS Word and MS Excel is a must, as well as experience with data entry. If you're capable of delivering high-quality work in a timely manner, I look forward to your proposal.

I'm in need of a seasoned IT professional who can deploy and configure both physical and virtu...and configure both physical and virtual servers (specifically Ubuntu and CentOS on Linux). Key responsibilities will include: - Installing and maintaining server hardware, storage, and backup systems. - Configuring system software, applications, and security updates. - Working exclusively with rack-mounted servers. The ideal freelancer will have extensive experience with: - Server installation and configuration (especially on Linux distributions). - Working with rack-mounted server hardware. - Regular server maintenance and updates. I'm looking for someone who is proactive, detail-oriented and can ensure the smooth operation of my server infrastr...

My Apache James mail server is functioning well for receiving emails but I'm encountering a significant issue when sending. All SMTP servers are rejecting delivery of emails from my server. I need an expert to diagnose and rectify this issue, and complete the setup so that my server can deliver emails to all SMTP servers successfully. Issues: - All outgoing emails are being blocked by spam filters. - I am primarily sending personal emails, but I need to ensure that the server can handle a variety of email types. - Currently, I only have a TXT record set up for my domain. Your task: - Investigate the cause of the rejections and rectify the issues. - Implement necessary authentication methods like SPF, DKIM, and DMARC. - Optimise the server...

I need a freelancer to transcribe a research questionnaire into an Excel spreadsheet and populate it with 500 dummy data entries. Key Requirements: - The questionnaire consists of 60 questions, most of them in a Likert scale format and focused on collecting demographic and behavioural data. - The final Excel file should simulate 500 responses to the questionnaire, based on criteria provided Ideal Skills: - Proficiency in Excel - Experience with data entry and data simulation - Familiarity with Likert scale and behavioral research. Please ensure that your proposal includes relevant experience and a brief outline of your approach to this task. Include the word 'Ninja' in your PM.

We need to install server RDP on a Ubuntu Desktop 22.04.1 ISO. We need to connect to this Linux from Windows RDP. Access to Linux to install server RDP may be by Anydesk

Need help organizing messy Excel data ? I'm here to assist! With expertise in Excel, I offer professional services to clean, format, merge, and split data, ensuring your files are organized and ready for use. Services Provided: Data Cleaning: Eliminate duplicates, fix errors, and maintain data integrity. Data Formatting: Apply consistent styles, format dates, and more. Data Merging: Combine data from multiple sheets or files seamlessly. Data Splitting: Separate data into categories or individual sheets. Custom Solutions: Tailored services to meet your specific needs. Why Choose My Services? Experienced: Skilled in Excel with a focus on accuracy and efficiency. Timely Delivery: Committed to meeting your deadlines. Client-Centric: Your satisfaction is my priority...

I'm seeking a professional with experience in Linux server and Postfix SMTP server software to install an SMTP server for me. The primary purpose of the server is to handle marketing campaigns. Ideal Skills: - In-depth knowledge and experience with Linux operating system - Proficient in Postfix SMTP server software - Experience in setting up servers for email marketing Please note that the SMTP server is intended for marketing purposes. Therefore, the freelancer should ensure that the server is configured to handle bulk email delivery and comply with necessary protocols to minimize the risk of emails being flagged as spam.

I need assistance with installing and configuring Postfix SMTP on my Linux server. The server has a specific domain that I would like to configure the SMTP server with. Ideal Skills & Experience: - Extensive experience with Linux operating systems - Proficient in installing and configuring Postfix SMTP - Knowledgeable in domain configuration with SMTP - Excellent problem-solving skills - Good communication skills for updates and clarifications

I'm seeking a dedicated, detail-oriented, part-time Laravel deve...implementing new features on our clients' projects and working directly with our project manager. Key Responsibilities: - Attend daily scrum meetings. - Work autonomously, at your own pace and time. - Implement new features. Ideal Skills: - Proficient in coding and debugging. - Strong front-end development skills. - Experienced with API integration. - Knowledgeable in version control systems and SQL & Databases. - Excellent analytical thinking. Please, individual freelancers only, with at least 20 hours a week to dedicate. Companies, kindly refrain from bidding. When applying, specify your proficiency level in each relevant skill. A willingness to be on video calls and strong communication skills ar...

I'm looking for an efficient Executive Assistant who can help me manage my daily workflow. The primary focus will be on data management and organization. Key Responsibilities: - Manage and organize data using Microsoft Excel and Google Sheets - Sync my calendar with existing calendar apps Ideal Skills: - Proficiency in Microsoft Excel and Google Sheets - Experience in data management and organization - Excellent coordination and communication skills Good communication skills Good English spoken as well as written

I'm seeking a PHP developer to create a simple, form-based web application for sports team fixturing. Key Requirements: - Implement a fixturing system for 20-30 teams from 12-15 clubs, across various ladders (A, B, C grade, etc.). - En...ladders (A, B, C grade, etc.). - Ensure all teams play each other twice, with equal distribution of home and away matches. - Adhere to club hosting limitations on match nights. The application should allow for: - Printable fixtures - Manual adjustments to fixtures - Adding non-play dates (e.g. holidays) The data will be sourced from a SQL database, with basic information provided for development. Ideal Skills: - Proficiency in PHP - Experience with SQL databases - Web application development - Knowledge of sports league and fixtur...

I'm looking for an experienced web developer to create an ASP.NET C# SQL Server web application primarily focused on data management. Key Features: - Data Entry Forms: The app should include user-friendly forms for entering data. - User Authentication: The app will require user authentication to access the data entry forms. Ideal Skills: - Proficiency in ASP.NET, C#, and SQL Server - Experience in developing data management web applications - Knowledge of implementing secure user authentication systems

Hi, I am interested in completing your Oracle database project. Given the detailed requirements, my quote is for: Installing & verifying Oracle DB Answering all questions with explanations Providing required SQL queries & execution results Capturing screenshots for all tasks Creating a well-structured PDF report Recording and submitting a work output video Estimated delivery: 7 hours Looking forward to your response. Best regards, Abhay Kumar

About this Gig: "Is your data messy or not organized? I can help!" With my skills in data cleaning, processing, merging, and splitting, I will turn your raw data into a clean, organized d...I will combine data from multiple sources (spreadsheets, CSV files, databases) into a unified, comprehensive dataset, ensuring smooth integration. Splitting: I will split large datasets into smaller, more manageable segments or break down columns into multiple categories, improving clarity and usability for better decision-making. Why To Choose My Services? : Skilled in Excel, Python and MySQL & Detail: I pay close attention to every aspect of your data to ensure its error-free and well-structured. Pricing: Professional data services at a competitive rate

I'm a skilled professional to design a Power BI dashboard that analyzes various Human Resource trends. The dashboard will effectively track metrics such as attrition rate, average salary, and retention rate. Key Requirements: - Proficiency in Power BI and Excel - Experience with HR analytics - Ability to visualize complex data and trends clearly The dashboard will utilize public datasets alongside our internal data to create a comprehensive view of our HR trends. The primary users of this dashboard will be our HR managers, so the design should cater to their specific needs and decision-making processes. The ultimate goal of this project is to empower our HR team to understand attrition trends and make informed decisions with 100% accuracy. A specific focus will be on how sa...

...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...

Plesk Server Error make all the wordpress website broken

I'm seeking a proficient English typist to assist with transcribing scanned images into PDF documents. The tasks will include: - Typing documents from scanned images - Data entry into MS Excel - Copy and paste tasks Ideal candidates should have exceptional typing skills with a knack for accuracy and speed. Proficiency in MS Word and MS Excel is a must, as well as experience with data entry. If you're capable of delivering high-quality work in a timely manner, I look forward to your proposal.

I'm looking for an Excel script that can automate the checking of my SKUs against a consolidated list that includes URLs and titles. The script will need to perform the following tasks: - Check against a consolidated list with URLs and titles - Download images - Rename files according to the SKU The SKU list is located in an Excel file and the consolidated list with URLs and titles is also provided in an Excel file. Ideal skills and experience for this job include: - Proficiency in Excel and Excel scripting - Ability to create scripts that can automate repetitive tasks

...(VAPT) on my application. Application Details: The application is an executable (.exe) file. On execution, it opens a website that runs on localhost. The website interacts with backend services locally. Scope of Work: Perform a comprehensive security assessment of the application. Identify vulnerabilities in the executable and the localhost web application. Test for common security threats like SQL Injection, XSS, CSRF, Privilege Escalation, and other OWASP Top 10 vulnerabilities. Identify potential privilege escalation and system access risks. Assess security loopholes in network communication and local storage. Provide a detailed vulnerability report with risk levels and mitigation recommendations. Preferred Skills & Experience: Experience in penetration testing and ethica...

I need assistance in converting a multi-tab Excel file into a detailed table for record-keeping purposes. The data should be organized in the table by category. Key details: - The table should only contain raw data, with no specific calculations or summaries needed. - The ideal freelancer for this project should have strong Excel skills and experience in data organization.

I'm looking for a professional who can design an Excel spreadsheet tailored to my specifications. The primary purpose of this spreadsheet will be analyzing sales data, with a specific focus on product performance. Ideal Skills and Experience: - Proficient in Excel and its advanced features - Experience in designing spreadsheets for data analysis - Understanding of sales metrics and product performance tracking

...reliable working relationships, clarifying rights and responsibilities, and minimizing potential disputes. To simplify this crucial process for you and provide professional support, I am here to offer freelance contract development services. Areas of Expertise: Understanding your business and industry is my priority. I provide tailored solutions for contract development in online platforms, Word or Excel documents, in both English and Turkish. Whether it's a general template or a customized contract, I can address all sorts of contract requirements. Diverse Industry Experience: From capital corporations to real estate sectors, construction projects to business relationships, I can assist you with creating contracts that cater to specific needs across various industries. T...

I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...

...data entry. The task involves entering specific sales data into Excel and tracking transactions in Tally Prime. Key Responsibilities: - Data Entry: Inputting sales invoices and summaries from Tally Prime into a standard Excel format. - Tally Prime: Manage and track all sales data in Tally Prime. Requirements: - Proficiency in Excel: Familiarity with the standard Excel format is necessary, as you will be expected to use this for all data entry. - Experience with Tally Prime: Prior experience working with Tally Prime is crucial, as this will be the primary platform for tracking sales data. - Attention to Detail: Precision is key, as data accuracy is critical for this task. Ideal skills for the job include: - Data Entry - Excel - Tally Prime - Attenti...

I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...

As a class 11 commerce student, I'm seeking a dedicated tutor specializing in Accountancy, specifically Financial Accounting. Key Requirements: - Expertise in teaching Financial Accounting - Previous experience with 11th grade curriculum - Patience and ability to explain concepts clearly - Flexi...I'm seeking a dedicated tutor specializing in Accountancy, specifically Financial Accounting. Key Requirements: - Expertise in teaching Financial Accounting - Previous experience with 11th grade curriculum - Patience and ability to explain concepts clearly - Flexible schedule for tutoring sessions Your role will primarily involve conducting tutoring sessions aimed at helping me understand and excel in Financial Accounting. Please provide your tutoring approach and availabili...

I'm looking for a freelancer who can assist in gathering the details of company directors from a list of data centres. The project involves finding information for 100 plus data centres. Key Requirements: - Full Name, Title, Email Address, and Phone Number of the directors are required. - Experience wit...and research is crucial. - Prior experience in sourcing business contacts is a plus. - Directors' LinkedIn Profiles are required for validation. - Please include the directors’ specific company roles in your search. Your bid should reflect your ability to provide this information accurately and efficiently. Looking forward to your proposals. The gathered information should be organized in an Excel spreadsheet format. Please include the directors’ specific c...

...website and data storage is being hosted on the single(same) server. So we want configuration something like where the front facing server should host the website and the rest of the servers should store the data. As of now, the website is being hosted through xampp server. Nginx is acting as a reverse proxy in front of the xampp server. Additionally we also use cloudflare for security purposes. Along with this, we are also looking for the replication of the same configuration for load balancing and fault tolerance. So for this setup, we want a highly scalable and completely secured solution. Whatever is needed we will be here to provide you everything in terms of hardware. Servers details are : - Dell Poweredge R740 XD2 Rack Server Dual Xeon ...

I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...

I'm in need of an Excel worksheet It is already in a wook book split into 3 parts with a total of 32 questions. The questions are designed for a beginner level course, so they're not overly complex. Key Requirements: you are a financial analyst at a large corporation responsible for managing and analyzing the company's product reports and financial data. Your goal is to set up a dashboard to display the needed information. Ideal Skills: - Proficiency in Excel - Experience in creating educational materials - Competence in trend analysis - Ability to work with financial data Heres the Project: You are a financial analyst at a large corporation responsible for managing and analyzing the company's product reports and financial data. The company deals w...

Config correctly mail server on AApanel.

I'm seeking a professional to install Hexabot AI, an open-source chatbot builder, on my Ubuntu server using Docker. Installation documentation is available, and no custom configurations or modifications are needed beyond the default setup. Key Requirements: - Proficient in server management, specifically Ubuntu - Extensive experience with Docker - Familiarity with Hexabot AI and its installation procedures - Ability to follow provided documentation accurately Please note that Docker is already installed on the server, and there's no need for support with deploying any specific languages or frameworks with Hexabot AI.

I need a proficient Excel developer to create an interactive dashboard that will help visualize work accomplished from different Excel sheets. Each sheet has slightly different data points but shares common elements like quantities completed on specific days and the number of additions per day. The dashboard should also incorporate some aging aspects of the efforts on each sheet. Key Requirements: - Proficient in Excel with experience creating dashboards - Skills in data visualization using line charts, bar charts, and pie charts - Ability to perform and display calculations including sum of quantities, count of entries, and difference between start and end values The dashboard must include: - Data visualization through number fields (count, sum, difference) - Abilit...

Looking to create the views in mariadb required for a calculation system to process sales data and automatically determines commissions based on various metrics. Category-based calculations Flexible rule implementation Experience with Excel/MariaDB Strong analytical skills Experience with business calculation systems Ability to implement complex business logic Looking for clean, maintainable code with proper documentation.

I need someone to transfer data from an Excel spreadsheet to a Word file, following a provided template, and then save it as a PDF. Ideal Skills and Experience: - Proficiency in Microsoft Excel and Word - Attention to detail (this is a must) - Ability to follow instructions accurately - Experience with data entry and document formatting Data Types: - The data consists of a mix of both text and numbers. Task Specifics: - A template will be provided for the Word file, which will require simple formatting (e.g., bold, italics, headings). - Instructions will be provided on how to organize the data in the Word file.

I am looking for a professional developer to create an e...Pending, Delivered, Rejected, In Warehouse ✅ Smart Scanning: Drivers can scan packages using a camera or scanner ✅ Warehouse Management: Accept and process incoming shipments ✅ API Integration: Connect with other courier companies in Albania and North Macedonia ✅ Reports & Analytics: Generate reports for orders, drivers, and sellers ✅ Order Printing: Print orders in A4 format and label prints ✅ Excel Import: Bulk order registration for higher efficiency Preferred Technologies: ✅ Laravel / Node.js for Backend ✅ React / Vue.js for Frontend ✅ MySQL / PostgreSQL for Database ✅ Mobile App (Optional) ? If you have experience in logistics platform development and can build a stable, fully functional system, contact me!

...with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical disposables and device parts used in our facilities. • Each row represents a unique item that must be mapped to both EMDN & UNSPSC. • You will add four new columns to this sheet: • EMDN Code (from reference sheet) • EMDN Name (from reference sheet) • UNSPSC Code (from reference sheet) • UNSPSC Name (from reference sheet) 2. “Global Item ” (Reference Data for Mapping) • Contains official EMDN & UNSPSC codes in two separate sheets. • You will use these sheets to correctly classify each item from our inventory. ✅ Requirements & Skills ✔ Experience in medical device classification & inventor...

...with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical disposables and device parts used in our facilities. • Each row represents a unique item that must be mapped to both EMDN & UNSPSC. • You will add four new columns to this sheet: • EMDN Code (from reference sheet) • EMDN Name (from reference sheet) • UNSPSC Code (from reference sheet) • UNSPSC Name (from reference sheet) 2. “Global Item ” (Reference Data for Mapping) • Contains official EMDN & UNSPSC codes in two separate sheets. • You will use these sheets to correctly classify each item from our inventory. ✅ Requirements & Skills ✔ Experience in medical device classification & inventor...

Project we talked about

Web Hosting Server Expert needed to reconfigure our server so it loads the OpenCart 3.0.3.7 website faster and connection issues. We have a Cloudflare Pro now (before we had free) but not sure if we need it. Server we use is Apache 2.4.62, 10.6.21-MariaDB, Linux, Perl Version 5.26.3 (big enough for the site we have)   1. Server times-out. Speed is slow as well and we need to re-calibrate it. We have extension installed - that supposed to speed the site up but they cannot connect to our server since it is keep blocking it. We whitelisted 4 IP (Nitros) they gave us, but still no connection. We need Nitro to be connected to our site so server does not block it. Nitro people worked on it but they said it is from server site. (we have ...

...in need of a skilled back-end developer to complement my web app's front end. The primary function of this back end will be focused on data storage and retrieval and transactions. Key Responsibilities: - Develop a robust back end that can handle transactional data. - Design and implement an efficient SQL database (preferably PostgreSQL) to store and manage this data. Ideal Skills and Experience: - Proven experience in back-end development, particularly with web apps. - Strong expertise in SQL, specifically PostgreSQL. - Ability to design and implement efficient data storage solutions. - Experience in handling transactional data. Your role will be crucial in ensuring the smooth, efficient operation of the web app. If you have the necessary skills and experience, I ...

I can write code in VBA for moving rows (orders) from one sheet to the next upon entering specific data in a cell or any other event. Client will explain the rules for moving data in each particular sheet.