Write excel macro sql server stored procedure jobs
...devices and browsers Integrate third-party APIs and services as needed Conduct thorough testing to identify and resolve any bugs or issues Provide ongoing support and maintenance for the website and plugins Requirements: Proficiency in WordPress development, including theme and plugin development Strong understanding of PHP, HTML, CSS, and JavaScript/jQuery Experience with MySQL databases and SQL queries Familiarity with version control systems such as Git Knowledge of WordPress security best practices Ability to troubleshoot and debug issues effectively Excellent communication and collaboration skills Attention to detail and a commitment to delivering high-quality work Duration: This is initially a one-month project with the possibility of extension based on project needs and...
I'm in need of a PHP developer who can help me update my current system. The goal is to unencode emails with 'Content-Type: text/html; charset=utf-8' and 'Content-Transfer-Encoding: base...save the body, along with the subject, sender, recipient, and date into my existing MySQL database. Key Requirements: - Use PHP to unencode the email and save the content into MySQL - Omit attachments from this process - Ensure the subject, sender, recipient, date, and body are accurately stored in the database Ideal Skills: - Proficiency in PHP and MySQL - Experience with email parsing and decoding - Knowledge of email headers and MySQL schemas - Attention to detail to ensure all data is correctly stored NOTE: Files will be passed back and forth using Freelancer'...
I'm seeking an advanced Excel professional to create a dynamic Excel tool that possesses several automatic functionalities. The Excel should be capable of: - Creating ledgers automatically based on the input of transactions and account types - Generating separate sheets for final accounts immediately after creation of ledgers. - Computing balances and totals automatically, providing real-time financial tracking and analysis. In terms of data input, the Excel should comfortably accommodate both manual input by the user and importing data from external sources. Finally, the dynamic tool should be capable of creating financial statements, including a Balance Sheet, Profit and Loss Statement, and Cash Flow Statement. Ratio analysis etc. Relates to accounting...
I'm looking to set up a high-definition video streaming server, dedicated to hosting and broadcasting user-generated content. Key Requirements: - Configuration for HD video streaming: The server should support High Definition (HD) quality video streaming, ensuring a seamless playback experience for viewers. - User-generated content management: The server must be capable of managing and broadcasting user-generated content. This includes the ability to upload new content, schedule broadcasts, and manage the video library efficiently. Ideal Candidate: - Experience in setting up and managing streaming servers: I'm seeking a professional with proven experience in configuring streaming servers, particularly those designed for HD video content. - Familiarity wit...
I'm in need of a professional in data visualization specific to Excel. Tasks include: - Translating complex data into easy to understand, static visualizations It's imperative that you have extensive knowledge of and experience with MS Excel. A background in statistical modeling will be beneficial, ensuring the ability to embrace and effectively illustrate our data.
The following features are important for the Smart Thermostat Valve: -There must be temperature and humidity sensors. -For double-sided communication between the thermostat and GateWay, it must be provided with RF 433 MHz communication protocol. -Must be powered by AAA or AA batteries. -Communication between devices should be enc...security. -It should have low power consumption. -All source files must be shared at the end of the project. The Software Gateway requires the following: -Must be able to connect to the internet via Wi-Fi protocol via a Gateway. -The product must be controllable via mobile application. -It should include various automation modes. -The data in the sensors must be tracked during the time they are stored. -All source files must be shared at the end of th...
I have a recent backup from 4/1/24 on a hard drive attached to my new computer. My previous computer died, the motherboard went out and somehow my SQL Server data was not saved on the original hard drive. I need to pull the data from a ".DATA" file, or find the missing SQL Server backup files and copy them into my existing program for use. Can anyone help?
I'm looking for a skilled Perl expert to help me remove duplicates in an Excel dataset. The removal process should be based on multiple columns, ensuring a thorough cleanup. Ideal Skills & Experience: - Strong proficiency in Perl programming - Proficiency in data analysis - Expertise in Excel and handling large datasets - Prior experience in removing duplicates from Excel based on multiple columns Communication: I prefer to have project updates through video calls, so please be comfortable with this form of communication. Your ability to walk me through the process will be highly appreciated.
...AWS experience and I am available right now to help." Thanks! --- Comments below are from AI -- I am in urgent need of AWS server administrator to resolve critical issues with my EC2 and RDS services. The server is currently experiencing performance degradation, database connection errors, and server downtimes, all of which are critical in nature and require immediate resolution. Ideal candidates for this project should have: - Profound experience in AWS server administration, with a specific focus on EC2 and RDS services. - Proven track record of quickly and effectively troubleshooting and resolving server performance issues, database connection errors, and server downtimes. - Ability to work under pressure and provide immediate assis...
I'm seeking someone to install and setup TokenLite script on my web server. The script is already purchased from Envato. Key responsibilities: - Review and understand the specifications of the script. - Successfully install the script on the Web Server. Ideally, you will have: - Proficiency in web servers. - Experience in installing scripts - Excellent problem-solving skills. Your proposal should include a brief description of your experience with TokenLite and the process you'll use for this installation. Estimated time to complete the project is highly appreciated.
...on prices from local stores or average costs. Technologies: Frontend: Vue.js or React for a dynamic and responsive user interface. Backend: Python with Flask or Django, using machine learning libraries like TensorFlow or Scikit-Learn for AI functionalities. APIs: Integrate with APIs for nutritional data (like Spoonacular or Edamam) and possibly grocery prices from online retailers. Database: Use SQL (like PostgreSQL) for structured data storage of user profiles, meal plans, and feedback. Machine Learning: Implement machine learning algorithms to personalize meal recommendations and learn from user feedback. The developer should be passionate about creating user-friendly experiences and should have a keen eye for detail to ensure seamless functionality of our application....
Hello, We are seeking a freelancer to undertake a project involving a database of 3,905 online games, primarily available on Steam. The task involves researching and providing valid EAN numbers for each downloadable game version listed in our Excel file. The current file includes titles and other relevant details, but lacks the EANs, which are crucial for our inventory management and logistics processes. Your task will be to fill this gap by identifying the correct EANs for these digital products. This project has the potential to expand in the future to include more games and other platforms. Therefore, we are looking for someone who can perform this work efficiently and accurately. If you have experience in retrieving specific data for digital products and a keen interest in v...
I am looking for an expert in Excel spreadsheet design to create a comprehensive and user-friendly accounts receivables sheet for my business. Key Features: - Calculation of total receivables - Aging analysis of receivables - Customer-wise summary of receivables - Report by department - Aging report - Total Sales - VAT report - Report by month Specific Formulas and Calculations: - Sum - Average - Count - Xlookup Data Organization: - By customer name - By invoice date - By payment due date - By month - By department Ideal Skills: - Proficiency in Excel and experience in creating complex spreadsheets - Strong understanding of accounting principles and reporting - Attention to detail to ensure accuracy in formulae and data organization - Ability to design a user-friendly in...
Urgently require a proficient Excel whizz who can efficiently perform financial calculations and analysis, especially pertaining to crypto sales and purchases. Aside from these, I require assistance in creating bespoke reports and summaries that will aid in decision-making among other business aspects. - **Financial Analysis**: Ability to perform rigorous financial analysis is crucial for this project. This includes but not restricted to calculations of various crypto sales and purchases. - **Report Generation**: Need customized, detail-oriented reports and summaries of all crypto activities in a coherent, easy-to-understand manner. Ideal candidates should have: - Extensive experience and knowledge in managing and analyzing financial data using Excel - Familiarity with c...
I have a project where I need someone to extract data from PDF files and input it into an Excel spreadsheet. Key Requirements: - Extracting data from PDF files - Inputting the extracted data into an Excel spreadsheet Ideal Skills and Experience: - Proficiency in data entry - Experience with data extraction from PDF files - Advanced Excel skills - Attention to detail and accuracy
...Objectives for the system: 1. It has to be completely offline (no online solutions will be accepted); 2. System has to be integrated with LLM (Llama or similar); 3. LLM must be capable on answering questions (via chatbot interface on GUI) on: a. DP’s; and b. Text it read while it was scanning the PDF and looking for DP’s; c. Previously read documents related to the same client. 4. DP’s are to be saved to SQL table; 5. We need a dashboard, to train the engine on finding DP’s in the document. Current problems: A. Large part of documents are scanned, but regardless if the document is scanned or not, it’s all in digital form format. It just so happens that some forms were populated digitally, printed, and scanned; B. As such, scanned documents are: a. T...
...need of a highly skilled MS Excel professional who can deliver moderate complexity tasks within a tight deadline of 10 days. The project consists of 72 individual tasks involving: - Data visualization - Spreadsheet formulation - Creation and implementation of advanced formulas and macros I am looking for someone who works efficiently, pays attention to detail and is highly skilled in all aspects of MS Excel. A proficient understanding of data analysis and visual representation is definitely a plus. The job demands the combined ability to work rapidly without compromising on quality. The ideal candidate should be ready to start as quickly as possible, adhering to the constraint of a strict timescale for completing all the subtasks. Speed and proficiency in Excel...
...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Ski...
...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Ski...
I need to scrape base salary information from Glassdoor for about 2000 companies. Key project requirements: - Scraping Glassdoor for base salary and range info only for every job function/title. - Compiling this data into an Excel spreadsheet Ideal skills include: - Proficient in web scraping techniques - Experience with data analysis Website: (it is free but need to register and complete the profile to see the information)
Feel free to ask any questions for clarity. Need assistance to connect my ESP32-2432 microcontroller to my Windows system. With an intermediate level experience, I need guidance and walkthrough for the overall process. The final goal is to create software able to: - Load PDF files stored locally on the microcontroller - View these PDFs - Provide annotation capabilities to these PDFs The ideal freelancer: - Is proficient with ESP32-2432 microcontrollers - Has extensive knowledge in software development for embedded systems, particularly with PDF viewer development - Strong understanding of memory management on these devices - Excellence in explaining technical details and instructions in a simple, clear fashion.
I'm in need of a skilled professional to create a Standard Operating Procedure (SOP) for our radiation therapy department. Key Components: - **Purpose:** This SOP should primarily focus on ensuring consistency within our operations. It is crucial that all staff members, especially new employees, follow the same set of guidelines. - **Primary Audience:** The SOP will be used by all radiation therapists in the department. Therefore, the language and content should be tailored to this specific audience. Specific Inclusions: - **Machine Downtime:** One of the crucial areas that this SOP should cover is what to do if a treatment machine goes down. This is a critical aspect of our operations, and we need a clear, concise set of steps to be taken in such events. In the rare occu...
Hi guys, we have an excel contact list. In that list we have persons & companies with their contact details. We coded an script wich monitors an gmail inbox. When emails are sent from specific mails to this inbox the python script should read the body and depending on the request in mail syript should send requested Excel back. There are 8 different excel saved locally wich the script can take and send back. So depending on the contect of the mail script should choose the right excel file and send this with an text like "here your requested Contact List Periskop in attachment. kind regards" If its help. in attachmend an little python script we wrote to send back an mail
I'm in need of an experienced SQL professional to assist me with data warehouse. The ideal candidate is someone who has: - Proven experience in designing data warehouses - Advanced SQL skills - Excellent understanding of data volumes and the implications for data warehousing If you are interested in this project, please provide details of your experience in similar projects. Thank you.
As an entrepreneur, I'm swamped with a ton of tasks and need a hand to get things done efficiently. I'm on the lookout for a professional virtual assistant who is not only fluent in English but also skilled in email management, appointment scheduling, light accounting, and spreadsheet tasks. Here's what the job entails: - Managing my emails and scheduling appoint...- Proven experience in similar roles - Exceptional command over English - Strong skills in using spreadsheet and email tools You should expect to work around 10-20 hours a week. This job requires professional-level English fluency given the nature of the tasks at hand. Excellent organizational skills and an eye for detail would be a big plus for this role. If this sounds like a role you can excel in, I...
I'm seeking a proficient Excel expert to create a master file for our NDT inspection reports. This master file will centralize all our reports and serve as a robust tool for analysis and reporting. Key Task Requirements: - Integrate worksheets from a master worksheet using advanced Excel formulas and functions, ensuring seamless data pulling. - Design needed features including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in designing vis...
i have a few functions that need to be done. you will have to load a excel doc to get everything to work but most aren't horrible.
I'm in need of an experienced legal consultant, specializing in US copyright laws, for a civil case involving copyright infringement. Key Details: - I'm specifically dealing with copyright infringement and need assistance regarding the proper legal procedure to follow. - My preferred method of communication is online chat. I expect frequent and prompt responses to my inquiries. - I've already collected evidence pertaining to the infringement that I can provide to you. Ideal Candidate: - A legal consultant with extensive experience in US copyright laws - Excellent communication skills, particularly in online chat - Proven track record in handling copyright infringement cases.
...the Plot. The castle should be raised up a minimum of 10 feet from ground level. The ceiling height from the floor should not be lower than 10 feet on each floor. All rooms and common areas are to have grey carpet as shown in the photos, except bathrooms and the main entrance and rear entrance of the property which should be tiled. Water is to be supplied from boreholes and water is purified and stored on the roof of the property, solar water heater, and pump, and septic tank are to be dug out for human waste, rain water harvester, and 2x waster storage tanks on the roof. The outer wall should have a gatehouse with a draw bridge, a draw bridge to be raised by the 2x electrical motors but a manual way to raise the bridge is essential in cases of motor failure. security cameras t...
I'm looking for an expert in data entry to help me with a particular task. - This will include rearranging the columns or just retyping into a new speadsheet. Super easy, I just don't have the time. Using the Fedex Fissler spreadsheet information, and inputting only the necessary informatio...have the time. Using the Fedex Fissler spreadsheet information, and inputting only the necessary information in the format provided on the second spreadsheet called Fissler Spreadsheet corrected. We only need to capture; Name, Address, city, state, zip, service type and actual weight. This project requires a meticulous eye for detail and an ability to work efficiently with data. Experience with Excel or Google Sheets is a must. Please get in touch if this sounds like a job you...
I am in need of a freelancer who can help me gather contact details from a couple of websites and organize them neatly in an Excel sheet. Key Details: - Websites: I have a couple of websites I need information from. The information is public and doesn't require any special access. - Information Needed: I'm interested in contact details such as phone numbers and email addresses. - Excel Organization: I want the contact details to be listed in a single list without any specific categorization. Skills and Experience: - Web Scrapping: You should have experience in web scrapping to efficiently extract the contact information required. - Data Entry: Proficient in Excel and attentive to detail to ensure the information is accurately documented. - Proficient in ...
I'm in need of an experienced Excel programmer to create a customized program for data analysis. The primary purpose of the program is to assist in data analysis. Thus, it should help in organizing and interpreting large sets of data. The program will need to handle data from two main sources: - Text files (CSV, TXT) - Manual input The ideal freelancer for this job should have a strong background in Excel programming and data analysis, with specific experience in handling various data types and creating efficient, user-friendly Excel programs. Key Skills: - Proficient in Excel programming - Skilled in data analysis - Experience working with text files and manual input - Ability to create user-friendly applications - Understanding of data organiza...
...another account in Zerodha. Functionality – 1) Login: Take credentials from excel like username, password ,API key , secret code, totp key and totp from authenticator for all accounts (master and child both) (basically after generating token) - all these on a single click on starting python file. 2) Order Punch: Copy all orders including NRML (SL-M , SL – limit) and MIS (SL-M , SL – limit) GTT, and trades (only completed- not rejected) from the main account to child accounts 3) Order Modification: If we cancel/modify any order on price and quantity, the cancellation/modify should also be cancelled/modified in all accounts 4) Primary account selection : Should have functionality of changing the primary account in excel , we can have predefined criteria for...
I'm looking for a professional to help in setting up an SQLite database which will store and manage moderate data with multiple attributes. Key requirements: - The database should be optimized for storing and retrieving moderate data, such as an inventory system with multiple attributes. - No complex data analysis is necessary, just a user-friendly system for managing and retrieving stored data. - Basic search and filter functionalities are required. Ideal skills for the job include: - Proficiency in SQLite database design and management. - Experience in setting up databases for inventory systems or similar systems. - Ability to implement basic search and filter functionalities.
I have a challenging case study that requires a thorough analysis of sales data and survey data. I'm looking for an expert who is well-versed in Excel to help me with this task. Key tasks and requirements: - You'll need to perform trend analysis on the sales data. - You'll also be required to visualize the sales and survey data. This will include a detailed geographical analysis. - The data visualization should be able to provide clear insights and comparisons between different variables. Ideal Skills & Experience: - Proficiency in Excel, including advanced data analysis features. - Experience with trend analysis and data visualization. - Previous experience with geographical analysis is a plus.
I have a photo that contains a mix of text, tables, charts, and images that need to be converted into Excel and Word formats. The key requirements are: - The data in the photo must be completely editable in both Excel and Word. This includes all text, tables, charts, and images. - The photo contains a mix of content, including text, tables, charts, and images. It's important that the freelancer is able to accurately capture and translate all of this information into the Excel and Word formats. Ideal skills and experience for this job include: - Proficiency in data entry and extraction. - Advanced skills in using Microsoft Excel and Word. - Experience in handling mixed content (text, tables, charts, images), and the ability to accurately represent this ...
...consultant who can assist me in setting up a three-tier SharePoint 2019 server. I am migrating from a previous version and require professional guidance in choosing the best server configuration for my needs. Primary tasks include: - Set up a three-tier SharePoint 2019 server - Assist in migrating my current data - Optimise the server for document management Ideal Skills: - Expertise in SharePoint 2019 - Experience in server setup and data migration - Knowledge in document management systems - Excellent communication and consultancy skills Your responsibility would be to guide me throughout the process, ensuring a smooth transition while minimising data loss. Your expert advice will also aid me in optimising the new server for document manage...
I require an Excel expert to help me create and modify spreadsheets. Specifically, I need assistance in incorporating certain functions and features in the spreadsheet, as well as handling various types of data. Key Requirements: - Spreadsheet Creation and Modification: I need someone who is proficient in Excel and can help me set up and adjust spreadsheets to my specifications. - Data Visualization: The ability to create charts, graphs, and other visual representations of the data is crucial for my project. - Automated Reports: I'm seeking assistance in automating certain processes in my spreadsheet to generate reports efficiently. - Conditional Formatting: I will also need help with setting up conditional formatting in the spreadsheet. Data Types: - The spreadsheet w...
I'm looking for a software developer who can create a custom audio player for Windows. The main features of this software include: - Play MP3 audio files: The software should be able to play audio files that are stored in cache memory. It's crucial that the player has a smooth and user-friendly interface for easy playback. - Auto-update from an online source: I would like the software to be capable of periodically updating the audio tracks from an online source. The method of update can be the most convenient for you to implement. I do not need features for managing the audio tracks (e.g., playlists, adjusting track order, or deleting tracks). The primary focus is on the playability and auto-updating of the tracks. The ideal developer for this project should have: - E...
I'm on the hunt for a creative designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-...designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-catching, yet minimalist packaging. - Proven track record – please include examples of your past work in your application. If you excel in minimalist design and have a passion for creating str...
... transactions using Pipedream, a workflow automation platform. Data Source: API request Project Steps: Data Capture: Upon receiving a API request, Pipedream will extract the following information: Order number Customer name Email address Order date Mobile number Pickup address Drop address Google Sheet Integration: The captured data will be automatically stored in a designated Google Sheet for record-keeping and future reference. Multi-Channel User Confirmation: SMS Notification: Pipedream will trigger an SMS confirmation using and , notifying the customer about their order details. WhatsApp Notification (Official API): will be integrated to send a WhatsApp confirmation through the official WhatsApp Business API, providing
I need assistance in setting up a mail merge (publipostage) in Excel to report information from the Excel sheet into a Word template. Key requirements: - Excel Data Analysis: You should have experience in data analysis using Excel. - Mail Merge: Proficiency in creating mail merge documents in Excel advanced - Word Template Populating: Understanding of how to populate Word templates with data from Excel. It's important that only the text information from the Excel file should be included in the Word template. Ideal skills and experience: - Proficiency in Excel and Word - Experience in data analysis - Familiarity with mail merge functionality - Previous experience in setting up similar Excel-Word integrations. Please...
Hi everybody, We need a full time data organizer who will be putting out bank statements into a proper excel format (which we will give). Please note that you will 70-90% of monthly work and you can keep taking other projects as well but we will give you full time pay of USD 500 and you have to remain available to us We have access to Able2Extract and can provide you a proper converted excel statement. However, in some cases, bank statements could be a scanned copy and hence you may need to manually enter data. This is a full time job and budget is reasonably fixed. Require an excel expert pro as there has to be a lot of data shuffling and data organizing into different folders. Need someone who can start immediately Thak you.
...create an API "spend manager", the system have to do: Web -login -CRUD users -CRUD projects -CRUD category spend -CRUD spend (with option to upload 2 images optional). -Option for assign users with a projects. -Report to see spends with filters project and category App (ionic angular) -login - create and modify spends. -for upload images there are 2 options, with camera or with a image file stored in the device. -list of projects - some users only can see the proyects that they have assign. Database tables: users, projects, category, spends, user_project. spend_image, images Ideal Skills: - Proficiency in Laravel and PHP -Proficiency using Ionic Angular or other language for app android. - Experience in developing CRUD applications - Strong understanding of rel...
...project. I now need a skilled developer to assist me in implementing a WebSocket server that will facilitate real-time data broadcasting and chat messaging service. Key Responsibilities: - Implementing a WebSocket server on my VPS - Ensuring that the server is compatible with a Laravel 9.x or newer project - Enabling the server to handle real-time data broadcasting - Facilitating chat messaging service within the WebSocket server Ideal Skills and Experience: - Proven experience in setting up WebSocket servers specifically on Nginx - Strong grasp of Laravel, particularly versions 9.x and above - Proficient in real-time data broadcasting and chat messaging service integration - Ability to troubleshoot and optimize server performance for smooth r...
I am looking for someone to assist me with data entry and related tasks in Excel and Word. I need some typing, copy and paste type of data, that needs to be entered in systematic way. Skills and Experience: - working in Excel/Word - Attention to detail - Experience with data entry or typing - Ability to follow instructions and work independently Preferred Format or Template: While I don't have a specific format or template in mind, I have a rough idea of how I would like the data to be arranged. I am open to suggestions and willing to collaborate on finding the most useful format for the data. If you have experience in data entry and are comfortable working with Excel and Word, please submit your proposal and include any relevant experience. Thank you!
...based experienced Golang Developer to build a robust and secure Go program that manages updates for another Go executable. This project requires creating a system that monitors GitHub to automate the process of updating, running, and, if necessary, rolling back an executable in a restricted Linux environment. Responsibilities: Develop a program that checks for new versions of an executable stored on GitHub and updates the running executable accordingly. Implement functionality to run the updated executable and perform startup tests to ensure its stability. Design a rollback mechanism to revert to the previous stable version if the new version fails at startup. Incorporate signature verification for each new executable to maintain security and authenticity. Enable ...
