Write excel macro sql server stored procedure jobs

I'm looking for a skilled software engineer well-versed in Progressive Web Applications (PWA), Microsoft Blazor, SQL Server, and Web Services. Your task will be to enhance our current application. Important details include: The ideal candidate should have a proven record of software enhancement, able to work on an hourly basis, flexible, and open to performing revisions if needed. Your robust knowledge of PWAs, Microsoft Blazor, SQL Server, and Web Services will be pivotal to the success of this project.

I have a number of JPEG images with text which I need to be transcribed into an Excel spreadsheet. The task should take around 2 - 3 hours to complete. Key Requirements: - Convert text from JPEG images to an Excel spreadsheet - Organize the data into categories as requested - Implement numeric data validation checks for accuracy Ideal Skills: - Proficient in data entry and data management - Familiarity with Excel and its functionalities - Strong attention to detail and accuracy - Experience in implementing data validation checks Please ensure that before submitting, you are confident in your ability to deliver an error-free and well-organized Excel spreadsheet.

I have a PDF catalogue that I need converted into an Excel spreadsheet. The PDF contains a mix of text and images which are crucial for the data. Key requirements: - Extract the data from the PDF and input into an Excel sheet. - Embed the images within the corresponding cells in the Excel file.

I require an accurate and efficient individual to input a combination of numeric and text data into a spreadsheet. This will involve less than 1000 entries. The primary task will be to input shipment data from Bills of Lading (BOLs) into an Excel file (.xlsx). The data must be organized based on specific categories found in the BOLs. Therefore, attention to detail and a keen eye for categorization is crucial. NOTE: BOL's shipped to the same location (multiple BOL's) must be added together on the same line. EXAMPLE: 1/1/2024 (5 Pallets) To Store #2595 2/1/2024 (4 Pallets) To Store #2595 NOTE: There are two types of BOL's a. Multiple Stop BOL"s. These will have 4-5 store location drops / entries to be made. b. Single Stop BOL's....

...track user-contributed tributes within the community. This means that the bot will need to provide the following functionalities: - User Registration: The bot should have a user registration functionality that allows members to sign up and start tracking their contributions. - Contribution Tracking: The main feature of the bot is to allow users to manually enter their contributions, which will be stored and displayed. - Leaderboard Tracking: The bot should also have a leaderboard tracking feature that ranks users based on their contributions. This can be done in real-time or on a scheduled basis. Additionally, the bot needs to have the ability to connect to the member's Twitter account, and automatically tweet their contributions. This is a key feature that should be integ...

I'm in need of a Laravel expert who can assist me with integrating Firebase with an SQL database. Key Requirements: - Proficient in Laravel: You should have a strong background in Laravel development and a good understanding of its architecture. - SQL Database Management: Experience in managing SQL databases is essential for this project. - Firebase Integration: Prior experience with integrating Firebase with other databases is a plus. - Problem-Solving Skills: Ability to troubleshoot and resolve issues that may arise during the integration process.

... provide constructive feedback, and ensure high code quality. - Help troubleshoot and resolve technical issues to maintain optimal performance. - Stay updated with emerging technologies and industry trends, suggesting innovative ideas for platform enhancement. Requirements: - Strong understanding of backend development principles and experience in JAVA. - Familiarity with database management (SQL or NoSQL) and RESTful API development. - Proficiency in web application frameworks and version control tools (e.g., Git). - Excellent problem-solving skills and attention to detail. - Effective communication and collaborative abilities within a team environment. Additional Skills (Preferred, but not required): - Experience with cloud platforms such as AWS, Azure, or Google Cloud. - Kn...

We are looking for freelancers for CMS setup, connection to domain name and results to display in the search at least the home page from our eshop.

Expert in MS excel for automation of sheets

I'm looking for a skilled freelancer to help me customize my Excel alerts with WAV files. - I have the specific sounds in mind for each type of alert, but I need someone who can skillfully integrate these into Excel's alert system. - You should have experience in both Excel and sound file manipulation, in order to create a seamless and professional system. - Please provide examples of past work to showcase your compatibility with this project.

...developer who is proficient in creating complex database queries, particularly in SQL. Even though the ideal candidate will mainly work on backend using Java, APIs, and cloud hosting, experience building front-end using technologies such as React, Angular or Vue.js is required. THIS IS BOTH BACKEND AND FRONT END PROJECT. The core responsibilities for this position involves: - Designing, coding, and debugging applications in Java. - Performance tuning, improvement, balancing, usability, automation using cloud hosting. - Being proficient in SQL for advanced database management and queries. For a successful application, please include: - Your past work and projects, especially those related to Java and SQL. - Detailed write-up about your role and responsib...

I need an experienced data scientist or AI specialist to assist with evaluating a Korean dataset using OpenAI API calls. my goal is to set up a good te... API example; deliverables; The test procedure as described and per our discussion to the format of the sample google doc. Set of scripts for JMeter configs, python for accuracy and inference test. (hopefully Colab) A working PC implementation to run the test, on a machine and VM (dockerized) to replicate the same testing environment repeatedly. A full documentation of test procedure, steps, screenshots, reference links, of running tests, and setups.

I am in need of a proficient developer to perform bug fixes on my ongoing project, primarily involving HTML, JavaScript, PHP, and SQL files. Key responsibilities: • Correcting a display issue present in my HTML file • Identifying any other existing bugs while ensuring that they do not interfere with the current functionality Skills and Experience: • Proficiency in HTML, JavaScript, PHP, and SQL • Experience with cross-browser compatibility testing and debugging • Proven track record of resolving bugs and improving webpage performance

I have an Excel file that I'd like to convert to a Google sheet. I need the Google sheet to keep all the formulas that are present in the Excel file. Key Requirements: - The Google sheet should have all the formulas intact from the original Excel file. - Include Data validation rules to ensure the data entered is accurate and meets certain criteria. - Implement Conditional formatting to visually highlight important information. - Custom scripts or functions to automate certain tasks and enhance the sheet's functionality. - Preserve font styles and retain cell borders from the original Excel file. - Maintain the column widths as in the original Excel file. Skills and Experience: - Proficiency in Excel and Google Sheets, including advanc...

**Scope of Work:** - **Features:** - Natural language processing to interpret user queries. - Conversion of interpreted queries into SQL statements. - Execution of SQL queries against the existing database. - Display of query results in a format that is easy to understand. - **Technology Stack:** - Backend: .NET Core (existing) - AI/NLP Model: Choice of suitable LLM (e.g., OpenAI's GPT model) - Database: Existing system database - Mobile: Flutter (existing) - Additional Tools: AI model training and integration tools (Python, PyTorch/TensorFlow) - **Deliverables:** - AI model capable of parsing and converting natural language to SQL. - Integration code for connecting AI model with the existing backend. - Updated mobile app (if necessary) to ...

I'm looking for a professional who can help me develop a comprehensive Excel workbook for RFQ analysis and purchasing. The primary goal of this tool is to streamline our purchasing process. Key Responsibilities: - Develop an Excel spreadsheet for RFQ analysis and purchasing. - Implement basic formulas and functions to automate data analysis. - Ensure the tool is user-friendly and easy to navigate. Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of its functions. - Experience in developing purchasing and analysis tools. - Ability to streamline processes through automation. This is an exciting opportunity for someone with a keen eye for detail and a strong understanding of purchasing processes. Looking forward to your proposals.

My Flask site is currently only reachable on domain:3000. Fix the nginx configuration so that the site is reachable under (right now, this displays the nginx welcome page)

I'm looking for a diligent researcher who can compile a list of tire processors across different US states and organize the information in an Excel spreadsheet. Key Responsibilities: - Conducting online research to identify tire processors in each state. - Collating specific information (company name, contact person, phone number) for each processor. - Inputting the data into an Excel spreadsheet with consistent formatting. The ideal candidate should have: - Proficiency in web research and data entry. - Excellent attention to detail. - Strong Excel skills, with knowledge of maintaining consistent formatting. - Prior experience in conducting similar research would be an added advantage. The final list should be organized by state, with each entry clearly indicat...

I am in need of a Senior Full Stack Developer with over 5 years of experience. The ideal candidate should demonstrate an expert proficiency in Python, Angular, HTML, CSS, Power BI, SQL (Snowflake, MSSQL), JavaScript, AWS Services, ORM, Linux, Git, Web Deployment, SSL, JWT, RESTful APIs, XML or JSON, TypeScript. Essential Skills and Experience: - 5+ years of experience in Full Stack Development - Proficiency in Python, Angular, HTML, CSS, JavaScript, TypeScript - Familiarity with Power BI and SQL (Snowflake, MSSQL) - Experience in AWS Services and Linux - Expertise in Web Deployment, SSL, JWT - Comprehensive knowledge of RESTful APIs, XML or JSON formats - Working experience with Git and ORM This highly challenging yet exciting role demands an individual able to work in...

I'm looking for an expert in data analysis to assist with a project in Excel. The data provided is well-structured and needs extensive examination to extract meaningful insights. Ideal Candidate Skills: - Proficient in Excel and its data analysis tools - Strong analytical abilities - Excellent understanding of data organization Deliverables: - Clear analysis of the structured data - Relevant insights extracted from the data - Detailed reporting on the findings This project is particularly suited to those with a keen eye for data and the ability to utilize Excel's functionalities efficiently. Thanks!

I am looking for a dedicated and detail-oriented data entry operator to assist with a large volume of data entry tasks. Key Responsibilities: - Typing, copying and pasting, data validation - Handling a large volume of entries Ideal Skills and Experience: - Proven experience in data entry - Expertise in handling large datasets - Proficiency with text documents (Word, PDF) and spreadsheets (Excel, Google Sheets) - Attention to detail and accuracy - Time management skills to handle large volumes of data

I'm looking for a database expert who can help me implement a masking technique for sensitive data in MySQL. Key Points: - Types of Sensitive Data: The solution should focus on masking Social Security Numbers, Credit Card Numbers, and Email Addresses. - Approach: I would like the data to be securely stored using a Hashing mechanism. - Database System: The project will involve working specifically with MySQL. The ideal candidate should have a deep understanding of database management, data security and Hashing techniques. Experience with data masking and MySQL is crucial. The project requires a meticulous and thorough approach to ensure that all sensitive data is properly masked and secured in the database.

I need an Excel spreadsheet that allows me to input a starting point's latitude and longitude, a heading (in degrees), and a distance (in kilometers), and then calculates the new latitude and longitude based on a rhumb line calculation. This tool will be primarily used for navigation purposes. Key Features: - Input fields for starting latitude, starting longitude, heading, and distance (all in kilometers) - Calculation of a new latitude and longitude based on the input - Utilization of the Rhumb line formula for the calculation Ideal Skills: - Advanced Excel proficiency - Understanding of geographical coordinate systems and navigation - Experience with mathematical calculations in Excel - Prior experience in developing navigation tools would be a plus This proj...

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

...with slow response times, long API process times, lower than desired overall performance, and a need for faster processing of new requests and server enhancement. I need an expert who can deep dive into the issues and provide solutions specifically in relation to: - MySQL normalization to enhance speed and efficiency - Optimization of all database queries - Enhancement of API endpoints to reduce process time - Streamlining the rendering of pages to increase speed - Prioritizing performance improvement for search functionality, data processing, and user authentication Key skills I need include: - Proficiency in MySQL - Strong experience with server optimisation - Familiarity with PHP Yii 1 Framework - Proven track record in database performance enhancement Thi...

I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing d...

need to websrapp amazon , flipkart and get current prices of sa list of laptop models on an excel sheet

...intuitive, comprehensive online exam system similar to that of IELTS. Key Features and Interface Requirements: - User registration and login: Prospective test-takers should be able to register themselves and log in independently. - Payment platform integration: Users should be able to pay directly on the website before taking the examination. -Ability to import questions and exam material from excel or csv - Exam result delivery: Post-exam, users must receive their scores directly presented as a percentage score on their screens and via email. Successful applications to work on this project should include past work that directly speaks to these requirements. Experience in developing online exam systems or similar educational platforms will be a strong advantage. A thorough...

...Brokerage website, grab financial statement data and inject that data into an Excel worksheet. Key Requirements: - The program should be able to access Fidelity Brokerage website. - It should grab financial statement data and inject it into Excel. - Specifically, the program should insert this data row by row into a Microsoft Excel Worksheet. - Each stock symbol which the program should enact on will be in one column - The data rows should be organized by having one row per stock symbol. Ideal Skills: - Experience in API and data extraction. - Strong proficiency in Python, VBScript or other programming languages suitable for this task. - Prior experience in creating Excel macros or programs that interact with Excel. - Knowledge of finan...

...the mobile device 1 A) Task 1. It should be an installer that will create a printer in the panel Windows devices as if it were a conventional printer. 2. It must be valid Windows/MAC 3. When it is sent to print a document a. The document that will be stored in a pre-defined folder b. The folder will read the xml configuration file. c. The document will be send to NFC Device d. The document will be send to Application hosted on cloud. 4. should accept any type of printing documents like PDF, Word, Excel, Crystal report, HTML and so on. 5. all text data should be saved into generated XPS file as readable data. 6. all data sent by print action into our printer should be printed into generated XPS file as is. 1 B) Specific Task – Prope...

I'm currently operating on a Linux server, but I want to transition my hosting over to Hostinger. There are 1 to 5 websites or applications hosted on my server that will need to be migrated successfully and efficiently, with minimal downtime. Skills and experience required: - Expertise in Linux server management - Profound knowledge about Hostinger - Deep understanding of website and application migration processes - Proven track record of successful server migrations with minimal disruptions. Your bid should include a strategy for ensuring all data is retained and remains intact through the migration process, as well as a plan for making the transition as seamless as possible.

Extract data from pdf documents into an excel template. No software needed for the job. This is a complex project that requires accuracy and being organised. Must have strong numeracy and proven track record of attention to detail. Knowledge of European languages an advantage. We have over 100 files that will be allocated depending on ability and capacity. If you are interested please get in touch. Work will begin in April.

I am pleased to report that the login issues with the VMware ESXi dedicated server hosted on OVHCloud have been successfully resolved. Access to the server management interface is now fully restored and functioning optimally.

...Linux-based barcode printing application that supports both QR codes and 1D barcodes. The application must also be capable of importing data from Excel/CSV files. Key Components: - A Linux-based application: The application should be specifically designed to run on Linux operating system. - QR Codes and 1D Barcodes: The barcode printing application should support both QR codes and 1D barcodes. - Excel/CSV data import: The application should be able to import data from Excel/CSV files for generating barcodes. Ideal Skills: - Proficiency in Linux application development. - Experience with barcode generation and printing. - Ability to work with Excel/CSV data import. - Understanding of QR codes and 1D barcodes. If you have prior experience in developing sim...

I am in need of a Python script that can read CSV files and push the data into SQL Server Management Studio database. Key Requirements: - The script should be versatile enough to handle multiple CSV files. - It should map the CSV file column names to the respective SQL Server database table columns. - I would like to have two versions - one for single CSV files and one for bulk import to optimize performance when dealing with a large volume of data. Key Skills: - Proficiency in Python to develop the script. - Familiarity with SQL Server Management Studio to manage the database. - Previous experience with CSV file handling and database import/export is a plus.

I'm seeking an academic writer with a strong understanding of economics, market structures, and legal disputes. This project requires: - Writing an economics paper focused on antitrust lawsuits against Apple. - Analysis and discussion should center on the economic impacts of these lawsuits. - The paper should delve into the potential macro and microeconomic consequences, including market effects, influenced by these legal actions. - Familiarity with economic principles and legal jargon is beneficial. - An objective perspective, academic referencing, and evidence-backed arguments should be adhered to. Please use 3 sources and cite them here are the requirements Apple Lawsuit Paper (Due 4/29) 4-5 Paragraphs 3+ Sources Topic: US Government vs. Apple lawsuit Intro - Summary...

I require a Laravel developer with profound knowledge of SQL - specifically for data manipulation - and Firebase handling real-time data. The successful candidate will not only have expertise in Laravel development but also have the ability to efficaciously manipulate data using SQL. The ability to store data into SQL from firebase real-time don Firebase. Ideal Skills & Experience: - Laravel Development - SQL (Data Manipulation) - Firebase (Real-time Data Management) The developer must have a solid understanding and experience with Laravel, SQL, and Firebase. Proven track record in these fields would be advantageous.

ERP Project Issue: After hosting, certain models within the ERP application are malfunctioning, likely due to registration or permission errors. Action Plan: Troubleshooting: Investigate the root cause of the model failures. Focus on registration issues and user permissions. Frontend Refresh: Enhance the application's visual appeal by integrating new frontend templates. Modify the user interface for a better look and feel.

I'm looking for an experienced programmer who understands MATLAB inside and out. Specifically, I need someone capable of optimizing a data analysis script. This script primarily uses arrays and matrices as its predominant data structures. It's crucial that you excel in: - MATLAB programming - Optimizing code for efficiency - Deep knowledge and understanding of working with arrays and matrices data structures If you are an expert with these requirements and have the know-how to streamline and optimize for speed and stability, your skills are highly valuable in this project. I look forward to reviewing your bid!

I'm seeking an expert in Excel who can efficiently merge two sets of numerical data sourced from different spreadsheets. Key tasks include: - Cleaning similar columns to create a unique identifier for perfect merging - Conducting statistical analysis on the merged data to find the mean, median, mode Ability to analyze data meticulously, professional experience in using Excel and familiarity with advanced statistical functions are essential for this project. Stringent attention to details is appreciated, as the data to be handled is delicate and the outcomes crucial. An understanding of data cleaning techniques in Excel would be an added bonus.

I'm in need of an experienced developer who's proficient in a range of technologies including HTML, CSS, JavaScript, Stripe, PHP, SQL, and XAMPP. Key Issues: - **Login Functionality**: I've encountered a problem where the user isn't being redirected to their profile page after logging in. This issue needs to be fixed promptly. - **Shopping Basket Functionality**: The project also involves fixing several aspects of the shopping basket. I need assistance in: - Ensuring a message is displayed when the same item is added to the cart again, thus preventing duplication. - Maintaining the cart products even after the page is reloaded. - Implementing a capability where the number of items in the cart icon increases on addition and decreases on removal. - Integr...

Proyecto de automatización con sharepoint, Excel, power automate y power bi

I am seeking an Excel expert capable of preparing a comprehensive document comprising more than 10000 rows and columns. The scope of the project involves processing substantial data sets, namely: Organizing Scanned documents and extracting the data, organizing the data in different corporations by department and years. Be able to extract a P/L and AR for all companies. Project is to be done in stages - Text - Numerical data - Date Information The ideal candidate for this job should have: - Expert knowledge of Excel and related functionalities. - Strong attention to detail. - Proven experience of data entry in large volumes. - Familiarity with basic mathematical operation functions within Excel. The deliverable will be a well-structured Excel document cr...

I am looking for an experienced writer with a sound understanding of TikTok and marketing tactics to pen a comprehensive book. The book will serve as a guide for individuals aiming to utilize TikTok for their marketing endeavors. The ideal candidate will: - Have an in-depth knowledge of TikTok and its features. - Be familiar with the best practices for content creation on TikTok. - Understand effective TikTok advertising strategies. - Be proficient in interpreting and utilizing TikTok analytics and measurements for optimum results. - Produce an engaging and easy-to-follow guide suitable for a versatile audience from small business owners to social media influencers. No specific writing samples have been requested for this project; however, showcasing your understanding of TikTok'...

I have to download everyday +- 3000 invoices (PDF files) from a server to my computer. I already have this task semi-automated in an Excel macro, but I want to do it easier. I need a tool (also in Excel/VB/Macro) where: - I'll write the day, month and year - I'll write the first invoice number and last invoice number that I want your tool to search - I'll hit a button "START" and your tool will search and download to my computer every invoices from that range that were issued on that specific day from an specific URL. The URL for these files is a standard URL. It's always an URL like this: The only part that changes is day, month, year and invoice number. Example: if I want to download any available invoices...

I need expert help with formatting documents across Microsoft Word, Excel, and PowerPoint. The key tasks include: - Formatting text: Ensuring consistency, readability, and visual appeal for all text elements. - Tables and charts: Skillfully organizing and presenting data in tables and charts. - Page layout and design: Creating visually engaging and professional layouts. - Resume: Crafting a creative resume with a professional touch. Ideal candidates should have: - Proficiency in Microsoft Office suite, with a focus on Word, Excel, and PowerPoint. - Proven experience in text formatting, table/chart creation, page design, and resume formatting. - A keen eye for detail, design, and visual presentation. - Ability to work efficiently and meet deadlines. - Familiarity with modern...

In need of an Excel whizz to immediately help in cleaning up my spreadsheet which has become cluttered and confusing. The main task will be: - Formatting cells and columns: Your experience in making spreadsheets intuitive, organized, and easy-to-read will be key. Expertise in creating visually appealing and easy-to-navigate cell and column formats is crucial. Though the specific type of cell and column formatting was not specified, the ability to quickly adapt and modify to different formatting styles would be a plus. Please note, this task is time-sensitive and requires prompt completion. If you have a proven track record of quick turnaround times on similar projects, don't hesitate to apply. Your efficiency and attention to detail will be prized.

...adds much cost, because I can manually manage with existing database tools) 2) Have a basic UI to login, have list of chats on left, text field/btns and messages on right like the chatgpt UI just more basic with existing framework elements. 3) Save chats in a many to many database (user, chat title, sent messages, received messages) 4) Interact with the chatgpt api using hardcoded or database stored credentials This is a personal project and I am familiar with laravel and php coding, so please do not submit overpriced bids. Be fair and reasonable. The right person would use mostly pre-existing codebase to achieve the desired solution. What determines which bid is chosen: 1) Price 2) Bid text 3) How long will take to complete If you submit a bid with what appears to be an...

I'm in need of a programmer skilled in pine scripts (tradingview). I am looking for someone who can create an alert in my script that is triggered when all specified conditions (Multiple conditions) are met. The conditions were not delineated in the planning phase. The key task for this project is that for example when the first condition met shou...this project is that for example when the first condition met should keep a record of that value and then use that value to another condition to trigger the alert. The ideal freelancer would: - Have experience in building complex alert systems - Understand and be able to work with the existing code - Be able to complete this task within the given time frame - Have great attention to detail and excel under limited supervision My...

Project Description: We are looking for an experienced server developer to set up an RTMPS live streaming server on an Ubuntu system. The main objective of this project is to enable live streaming with multiple bitrate options, ensuring a high-quality viewing experience across various devices and network conditions. Additionally, the streams will be delivered using MPEG-DASH (Dynamic Adaptive Streaming over HTTP) with CENC (Common Encryption) and must be compatible with PlayReady DRM for content protection. Responsibilities: 1) Install and configure the necessary software on an Ubuntu server for RTMPS live streaming. 2) Enable multiple bitrate streaming to adjust video quality dynamically based on the viewer's bandwidth. 3) Implement DASH CENC streaming to sec...