Write excel macro sql server stored procedure jobs

I’m in need of someone experienced with Excel and product management to help me compile an organized sheet for auto parts dropshipping. Your task is to ensure accurate information on product descriptions and supplier details. Key Aspects: - Populate Excel spreadsheet with relevant fields: Product description and Supplier information. - Must be proficient in Excel and have prior experience in a similar role, proof of such experience is necessary. - Deliver the final product in Excel format (.xls or .xlsx) Knowledge in the auto parts industry will be a significant plus.

...skilled web scraper to extract text content and PDF documents from https://www.dell.com/en-us/dt/corporate/social-impact/advancing-sustainability/climate-action/product-carbon-footprints.htm#scroll=off&tab0=1 We are creating a database of all of the carbon offset metrics to be stored. there are 6 categories on that page: 1. Desktops 2. Laptops 3. Monitors 4. Client peripherals 5. Servers 6. Storage I want each of those category's products scraped and I want to save the pdf along with parse the PDF so the excel document has the following information Category Series Model Carbon Footprint Carbon Footprint Mean 95th Percentile Unit of Measure Use % Transportation Percentage EOL Percentage Manufacturing Percentage Then there is a break down of what the manufac...

I need assistance with a very specific task: transposing customer list data from an existing Excel spreadsheet into a business plan. The format should arrange the data in a column arrangement within the business plan document. Specific elements required from the customer list include: - Telephone number - Email - Personal information Ideal candidates for this project should have experience with: - Excel spreadsheets - Business plan designing - Data transfer and organization Let me know if you need any further information to complete this task.

I am looking for a seasoned freelancer to build an automated product uploader for eBay.co.uk. I have no specific preference over whether the uploader uses manual entry, CSV/Excel file or API integration methods to retrieve product information, so I am open to suggestions here. As for skills and experience: - Strong working knowledge of eBay's platform is crucial - Prior experience in building automated uploading systems is desirable - Familiarity with CSV/Excel file handling or API integration would be bonus points In your proposal, I would appreciate a brief overview of your past work, relevant experience and detailed explanation on how you plan to tackle this project. Looking forward to see your innovative bids.

I'm searching for a professional with advanced Excel skills to modify my spreadsheet. The tasks include: 1. Quartering: Split my dataset into four sections (Q1, Q2, Q3, and Q4). 2. Data Removal: Erase specific rows or columns as per provided instructions. The ideal person for the job is quick, efficient, and meticulous, with a keen eye for detail. The ability to understand and work efficiently with large datasets is a must. Proficiency in Excel is expected and prior experience with similar projects would be highly advantageous. DETAILED DESCRIPTION OF JOB: On the attached spreadsheet: Remove all of the accounts that are exempt from work comp (column R shows who is exempt) Remove all columns except for Business name, address, city, state zip. Then I want it broken in...

We have a wordpress website that we need to transfer to another domain today.

As the primary user of a Windows 11 Pro PC acting as a server for a SQL based car dealership software, EasyDeal, I require technical support to resolve my ongoing issue. The main problem I encounter is that various devices are struggling to maintain a connection to the software, indicating a "Connection Timeout" TCP errors, "could not locate server" error message. Key Tasks: * Troubleshoot and repair the connection issues on the server and other devices * Ensure stable, reliable connection between the devices and server Ideal Skills & Experience: * Proven experience with EasyDeal software * Excellent knowledge and skills in SQL and network troubleshooting * Familiarity with Windows 11 Pro and server management.

As a project owner, I am seeking a skilled individual to carry out data typing from scanned documents to a simple Excel table. Key Responsibilities: - Conversion of text data from scanned documents into an Excel sheet - Ensuring the accuracy of the data typed in Required skills and Experience: - Proficiency in MS Excel - Strong attention to detail - Experience in data entry tasks - Ability to interpret and input text data accurately. Looking forward to your bids!

I'm looking for someone proficient in SQL Server to help with my complex stored procedure. This task incorporates both performance optimization throughout and enhancements in specific areas. Required Skills and Experience: • Expertise in SQL Server. • Experience in performance optimization of stored procedures. • Tackling both overall and specific improvements. I have complete documentation of the current structure and logic of the procedure. This will aid in understanding what needs to be fixed and consequently expedite the completion of the project. Your role will include finalizing it and working according to the requirements. Do not bid for this unless you are free to work on this for the next 5 days, as thi...

...for AutoCAD: Interface for User Input: Create a simple interface (dialog boxes or command-line prompts) that asks the user for the number of divisions and for details about each division (type of room, area, and whether it has natural lighting). Data Storage: Use data structures to store the user's inputs. This can be lists or associative arrays (dictionaries) where each division's details are stored for processing. Room Suggestions: Include a predefined list of suggested room types for the user to choose from or add their own. Calculating Total Area: Provide a function to calculate the total area of the space based on user inputs, ensuring the sum of divisions does not exceed the total available area. Drawing Function: Implement a function to draw the divisions wi...

The purpose of this project is for an experienced data analyst to make sense of provided educational assessment data, specifically test scores. Annually we run an assessment of surgical technical skill for several distinct cohorts, based upon surgical specialty. They perform several procedures, which are assessed using procedure-specific assessment tools by 2 assessors. Initial reliability has been conducted (inter-item, inter-rater). Here's what is expected: - Conduction of G theory studies.

I'm looking for a professional who can assist me in setting up a Linux web server. The main purpose of this server will be to host an informational website that predominantly features educational content. Your expertise should ideally include: - Substantial understanding of Linux server setup - Previous experience in hosting informational websites - Ability to optimize servers for efficient operation You'll be providing the foundation for a website aiming to make an educational impact, so attention to detail and an understanding of best practices for informational site hosting are key for this project.

I need a specialist in data visualization and Excel to help me create graphs that illustrate quarterly operational data trends in a process plant context. The goal is to facilitate easier data interpretation and decision making. The project will particularly involve turning raw data into graphical representations. Key responsibilities: * Understand source data, which consists of process plant metrics such as temperature, pressure, flow rate, etc. * Create meaningful, easy to interpret graphical representations for these metrics * Ensure the graphs accurately display trends over quarterly periods. Ideal experience and skills: * Strong expertise in Excel * Familiarity with processing plant metrics * Solid experience in data visualization * Background in data analysis in an in...

Hi Milan S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm in need of a talented individual who is intimately familiar with Hubspot and Stripe for CRM integration. Your main task will be to coalesce these two systems to streamline my payment processing and manage customer subscriptions. - The main target is to import our current excel spreadsheet correctly into Hubspot (about 20 columns) with each field correctly displayed. (see attached sample). - To have each stripe payment correctly updating the right client, so we know if one is late on his subscription payment or not. Here's what I'm looking for: - Proficiency in both Hubspot and Stripe platforms - Proven expertise in CRM integration - Ability to optimize processes for ease and efficiency Your expertise in this field will directly enhance my team's workflo...

I'm seeking a detail-oriented freelancer to enter text data from PDF format into a spreadsheet. Your tasks would include: - Extracting and entering text data from PDF documents with high accuracy - Ensuring all entered data ...Your tasks would include: - Extracting and entering text data from PDF documents with high accuracy - Ensuring all entered data is correctly formatted and categorised according to my requirements Ideal skills and experience for the job: - Prior data entry experience, particularly with PDF to spreadsheet conversions - High attention to detail - Familiarity with spreadsheet software such as MS Excel or Google Sheets - Proficiency in English, as the text data to be entered is in this language. Feel free to reach out with any questions or clarific...

i need to build a Excel sheet very simple, its to manage employes holidays and shedules. Are only 10 employes, and just need a simple calendar in Excel to select labor by day or to count free days like holidays or ilness. I fill calendar and excel show me total days worked, or holidays days left by employee.

I want someone who can create a VBA macro to merge specified excel workbooks from different excel files in one click. More details: What specific tasks do you need the VBA Excel program to perform? Automate data entry What types of data will the VBA program need to handle while automating the data entry? Text data, Numeric data How will the VBA program receive the data that needs to be entered? Files

...charging. 2. Overcurrent protection to safeguard against excessive current flow. 3. Low voltage charging protection to prevent the battery from reaching dangerously low levels. 4. Charging status indication for the microcontroller **Key Responsibilities:** 1. Design a LiPo charger circuit incorporating overvoltage, overcurrent, and low voltage charging protection. 2. Develop a robust testing procedure to verify the circuit's reliability, efficiency, and safety. 3. Provide comprehensive documentation detailing the circuit design, component selection, and testing procedures. **Requirements:** 1. Proven experience in circuit design, particularly with LiPo battery charging circuits. 2. Expertise in implementing overvoltage, overcurrent, and low voltage charging protection mech...

...navigate the unique needs of a service enterprise. If you excel at cold calling, client meetings, and meticulous follow-ups, this might be the perfect project for you. Key Responsibilities: - Initiate cold calling to generate new business. - Set up and attend client meetings, perfectly representing our service-oriented business. - Tenaciously follow up on leads to convert them into clients. Software Skills Needed: - You must be adept at using Excel spreadsheets to keep track of sales leads and customer information. Ideal candidates should have a proven track record in sales, with particular expertise in cold calling and follow-ups. A service-minded approach and excellent communication skills are crucial. Past experience in maintaining Excel spreadsheets for custo...

I’m in need of a PDF to Excel converter that effectively processes Tamil and Sinhala languages. It’s crucial that this tool possess the following features: - Text Extraction: Ability to pull all text from documents cleanly and clearly. - Character Recognition: Must be able to identify individual characters and symbols for precise conversion. - Language Detection: The converter should automatically recognize the language of the text. I expect high accuracy in text extraction, to ensure the integrity of the original document is maintained in the converted output. Experience in Optical Character Recognition (OCR), and proficiency in Tamil and Sinhala language text processing, will be ideal for this project.

I require a capable professional to set up an SMTP server for less than 10,000 daily marketing emails. These emails will primarily be a combination of graphics and text. Ideal Skills and Experience: - Extensive knowledge and experience with SMTP server set up - Background in email marketing - Understanding of best practices for sending marketing emails in high volumes - Experience with incorporating both graphics and text into emails Key Task: - Ensure the server is capable and optimized for the daily volume of less than 10,000 emails - Provide guidance on best practices for minimizing bounce rates and spam flags. - Support in creating graphic and text-based emails that are compelling and engaging. This project demands attention to detail and a good understandin...

I’m in need of a PDF to Excel converter that effectively processes Tamil and Sinhala languages. It’s crucial that this tool possess the following features: - Text Extraction: Ability to pull all text from documents cleanly and clearly. - Character Recognition: Must be able to identify individual characters and symbols for precise conversion. - Language Detection: The converter should automatically recognize the language of the text. I expect high accuracy in text extraction, to ensure the integrity of the original document is maintained in the converted output. Experience in Optical Character Recognition (OCR), and proficiency in Tamil and Sinhala language text processing, will be ideal for this project.

❗️SOUTH AFRICA Hello, my name Kristina. I am looking for an assistant/purchasing manager for one-time tasks in South Africa. You will need to find certain items in the Chinese markets in Cape Town or Johannesburg. After you find these products, you will need to write down the supplier’s contacts in Excel. Thus, you will need to find more than 30 products and suppliers. One day of work (6-7 hours) - 100$. Example of products: - - - - - -

I am looking for an accomplished expert or team in Lineage 2 server setup to establish a Gracia Final version. Requirements: * Experience with setting up Lineage 2 servers, particularly the Gracia Final version. * Understanding of and experience with the mixed PvP/PvE server settings. * Capability to configure server for players to start at Level 1. * Native donations with auto inventory fills * Custom items, skills, quests, NPCs + This project requires a keen attention to details and exceptional knowledge of the mechanics of Lineage 2. Your expertise will ensure a smooth and efficient setup process.

I'm seeking a highly skilled Expert The project demands: - Proven expertise in Excel - A sound understanding of statistical analysis - At least intermediate experience in data analysis using Excel - Excellent attention to detail Responsibilities will include running statistical analyses on sets of data, interpreting and presenting results in a clear, comprehensible manner. I look forward to receiving bids from all suitably qualified freelancers. Thank you.

I'm seeking an experienced professional who is proficient in Arabic and English for a data entry project. You will be inputting simple data in Excel form, such as names and addresses. The data is currently stored in digital files. Required Skills: - Proficiency in Arabic and English languages - Experience in Excel data entry - Attention to detail Experience with similar data entry projects before would be ideal. The Task we have an excel sheet which has list of professors for a Kuwait University, and we have images of the updates professor list. We want you add in the table the missing people from the images. Attached the excel sheet and the images. What you will do is, open an image check which major it is, then apply major filter in the...

...and details regarding potential variability due to residual stress. Subsequently, the collected data will undergo processing using MATLAB to format it for seamless importation into ANSYS. this is objective of the project, its in different phases. i have done this part in MATAB but i need help with the writing of the methodology and detail explanation of results/ and discussion am struggling to write it Phase 2: Shell modelling and mesh validation This phase is to develop a shell finite element model of the entire tank geometry in ANSYS with adjusted shell element thicknesses and neutral axes based on the obtained ultrasonic thickness measurements. After materials properties and load conditions are applied, the aim will be to ensure the shell finite element mesh has converged and...

Need to do data entry from chatgpt I to excel spreadsheet. Need basic math and English skills

I am developing a question-answer chat bot based on GPT and my own subject-oriented knowledge base. Basic code for a question and answer bot based on LangChain. Text materials are broken into fragments, indexed using embeddings and stored in a vector database. Relevant documents are then retrieved from the database on demand and fed to the input of the GPT model. However, all this works with low accuracy. Right now I'm using a regular retriever that searches for 3 similar fragments in the text, but it performs poorly. The text is in Russian. Looking for someone who can implement a more accurate solution that takes into account context or synonyms. I am not well versed in this area. Ready to discuss details

...recognize text layers based on their names and map them to corresponding cells in the CSV table. Export Functionality: Implement features for exporting the populated CSV table to a downloadable file, compatible with Marketing Cloud templates. Template Management: Develop functionality for users to save and load templates, edit existing templates, and delete templates as needed. Templates should be stored locally within the plug-in for easy access. Specific Requirements: Proficiency in JavaScript and familiarity with Figma plug-in development. Experience with data manipulation and file exportation in CSV format. Strong understanding of Figma's API and ability to interact with Figma frames programmatically. Attention to detail and ability to implement user-friendly interfa...

I am looking for someone experienced in data entry, who can accurately transfer text, numbers, and dates from paper documents into an Excel file. The file contains less than 100 columns and rows, so attention to detail is essential. - Data Type: Text, Numbers, and Dates - Source: Paper Documents - Excel Capacity: Less than 100 rows and columns Ideal skills would be a fast typing speed, proficiency in Microsoft Excel, and previous experience in data entry from paper documents. Knowledge on handling and digitizing paper documents would be a significant advantage. Candidates who can ensure accuracy and efficiency in managing and formatting data are preferred.

I'm looking for an Excel expert to develop an algorithm for range breakouts trading. The specific breakout criteria will include price crossing above the high and below the low of a specified range. Even though no specific conditions or indicators to trigger the range breakout trade were indicated, I encourage you to apply your understanding of common trading triggers to offer suggestions on how to improve this system. The algorithm should also check for range breakout opportunities every minute. You might have the following skills and experience: - Extensive experience with Excel - Knowledge of algorithmic trading principles - Experience in programming Excel for algorithmic trading.

...phone a sentence in French with the Russian translation, a recording of the French sentence (to ensure correct pronunciation), a few grammatical indications and colors to clearly identify which French word corresponds to which Russian word. The aim is to enrich vocabulary and grammar. The sentences in French and Russian as well as the recordings would be created by me. In detail: - Phrases are stored in the user's personal space, so they can be reviewed and replayed at any time. - Next to each phrase, there's a button for sharing the phrase and its translation, but not the recording (to listen to the recordings, you need to be a subscriber). - Users can download sentences in PDF format from their personal space, but recordings are not downloadable (to prevent user...

Please give a viral and unique idea for a Minecraft server so that everyone will enjoy it and players will play for a long time

I am seeking a proficient HTML/Js coder with substantial experience in ZOHO Creator. The scope of the project requires the creation of an advanced Gantt chart with the following functionalities: - Drag and drop tasks: Make tasks movable, enhancing usability and adaptability. - Zoom in/out feature: An essential functionality to swiftly and seamlessly navigate between micro and macro views of the project timeline. - Task dependencies: Tasks should be linkable, illustrating the sequential or dependent nature of tasks. The Gantt chart should display task duration in 'Days'. Therefore, candidates with grasp of fine-tuned date and time handling in Js are preferred. Moreover, the chart should provide additional task details which include: - Assignment of tasks to specific t...

I'm seeking a professional with experience in bold and extravagant designs to help with my marketing and advertising project. Ideal Skills: - Experience in Marketing & Advertising design - Proven ability to create dynamic, out-of-the-box designs - Skills in produ...out-of-the-box designs - Skills in product oriented designing As the project requires a bold and extravagant style, I'd like applicants to showcase similar previous works. A strong track history in creating standout promotional materials will be highly regarded. Expectations: - Ability to work within deadlines - Open and active communication - Willingness to revise designs based on feedback If you excel in creating vivid and impactful designs, then this project is for you. Let's create some...

I'm seeking a highly skilled Excel enthusiast who can efficiently utilize its powerful data analysis functions. The focus here is specifically on basic descriptive statistics, not advanced predictive or inferential statistics. The project demands: - Proven expertise in Excel - A sound understanding of statistical analysis - At least intermediate experience in data analysis using Excel - Excellent attention to detail Responsibilities will include running statistical analyses on sets of data, interpreting and presenting results in a clear, comprehensible manner. I look forward to receiving bids from all suitably qualified freelancers. Thank you.

I'm in need of a proficient Excel expert who is well-versed in data analysis and creating complex formulas and functions. Key responsibilities: - Analyzing a medium-sized data set (100-1000 rows) - Managing and manipulating data, which involves creating intricate formulas and functions - Enhancing the data's ease of understanding and usability Ideal candidates should have: - A strong understanding and experience in Excel - Proficiency in data analysis, Excel formulas and functions - Excellent attention to detail and data accuracy - Capacity to handle medium-sized data sets - Ability to deliver results in a timely manner.

I'm seeking an experienced Server Management Specialist, who predominantly manages 35 servers and is skilled in Cassandra, Elastic Search, and MySQL (Jira docs). Comfort with Jenkins and Linux is critical. Ideally, our selected freelancer possesses strong communication skills and exhibits an ability to identify key infrastructure resources rapidly. The scope of tasks includes, but not limited to: - Routine maintenance and updates - Troubleshooting - Problem resolution - Installation and Configuration My project is focused on making frequent updates to resources found in Jira and app-status.ot. It is imperative that the freelancer is able to check emails regularly to stay current with any urgent alerts. Please consider this a long-term project opportunity if found s...

I'm an advanced user looking for in-depth, personal tutoring in Excel and VBA. The tutoring should focus on, but not limited to: - Writing VBA scripts - Database management in Excel - Advanced Excel functions - Automation - Data Entry Form - Result Page Additionally, guidance should be provided on automation of tasks including: - Data import/export - Data manipulation - Report generation The ideal candidate will have an extensive background in VBA and Excel, with a specific emphasis in automation and data management. They must be skilled in conveying complex processes and concepts in a clear, understandable manner.

Looking for a SQL Expert who is good with Transact SQL, stored procedure and expert with MS SQL server. Task is related to trigger and XML and should hardly take one day to complete

...expert Appium developer to create an iOS compiler that can work efficiently with Appium native and Flutter. Work to do(I assume it is something like this): 1. setup appium on a mac machine 2. install flutter and swift compilers 3. probably create a docker instance for each compilers from that MAC machine 4. enable so testing can be made after the app has been compiled and results can be stored into logs. The above should be done the same for Android Key Requirements: - Design and develop the iOS compiler. - Integrate the compiler with Appium native and Flutter. - Focus specifically on compiling function within the Flutter app. Ideal Skills: - Expert knowledge of Appium. - Proficient in Flutter. - Excellent iOS development and compiler conception skills. ...

I'm seeking a flexible and experienced Android app developer to create an application whose specifications are not yet defined. Key potential features may include ...seeking a flexible and experienced Android app developer to create an application whose specifications are not yet defined. Key potential features may include user registration and login, push notifications, and in-app purchases. The main purpose and design are yet to be determined, thus, a resourceful and adaptable approach to development is necessary. This project may be suitable for developers who excel in creating social networking, e-commerce, or educational apps with a diverse range of design styles: minimalist, colorful, clean, and modern. The project specifics will be finalized in collaboration with the suc...

With this project, I'm specifically looking for a detail-oriented and meticulous individual experienced in online data entry, ideally in an Excel environment. The selected freelancer will be responsible for: - Performing online data entry tasks. - Entering all data into an Excel spreadsheet. - Sorting and organizing the data in alphabetical order. It's crucial you have experience with Excel and an understanding of data structuring. Error-free work is a must, as well as a keen eye for details, to ensure the data's integrity. I'm counting on your expertise to deliver accurate and reliable results.

...proficient Android developer who can transform my existing Excel-based userforms into an enticing Android application. Specifically, the tasks will involve: Functionalities and Features Development: - While I've nailed down some functionalities, I would appreciate some guidance in further enhancing the app's features. Your ingenious input on potentially beneficial features and functionalities, based off our Excel prototype, would be welcomed. Data Interaction: - The app should be designed for data input tasks solely. Users should find it convenient to input data on the go, directly from their Android devices. External Data Syncing: - A critical feature of this app would be its capability to sync data effortlessly to an external Excel sheet. Hence, exp...

I have a webform developed in HTML5, PHP, SQL, and JavaScript. I'm looking for a developer to make a few key improvements. PRE-BUILT I have currently built a where the user selects a customer from a dropdown and selects the number of products to add to this order. Each customer from an SQL table called 'customers' has its own price class 'customerPriceClass' When the user selects the number of products, the page updates and adds rows for each product with a dropdown menu where the choices are fetched from another table called 'products'. The user selects the product and enters the number of units. NEEDED: STEP1 For each row of products the corresponding price from the table 'prices' should be fetched that is associated with t...

...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....

...servers on Linux systems. The primary goal is to streamline the game server setup process, reducing manual setup and configuration time. The script should handle the entire setup process, from initial server preparation to the final game server launch. Script Requirements: — Automated Deployment: Automatically download, install, and configure game server software. — Configuration Management: Scripts should read from config file — Compatibility: Must run on Ubuntu — Security: Incorporate basic security settings to protect the server. — Efficiency: Minimize resource usage during setup to not impact server performance. Skills Required: — Proficiency in Python or Bash scripting under Linux environments. — U...

I'm seeking an experienced professional who is proficient in Spanish and English for a data entry project. You will be inputting simple data in Excel form, such as names and addresses. The data is currently stored in digital files. Required Skills: - Experience in Excel data entry - Attention to detail Experience with similar data entry projects before would be ideal.