Running excel vba macro sql server jobs

I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.

I'm in need of an experienced Linux programmer to update my current SMTP server code and add new routines. Key requirements: - Revise and improve the sending efficiency of the server - Add new functionalities to the existing code The ideal freelancer for this project should be well-versed in Linux programming and have a solid understanding of SMTP server architecture. Your proposal should include a detailed plan on how you aim to achieve the project requirements.

...and smoothies. A key expectation is for the freelancer to help incorporate these offerings seamlessly into the shop's workflow. - The target audience for this establishment is wide, catering to adults, children, and all age groups. It is important that the shop's design and services reflect this inclusivity. - I need someone experienced in the food retail industry, especially in setting up and running a donut shop. Knowledge of the local market and shopping mall culture is a big plus. - Design skills are also valuable as I'd like the freelancer to help in creating a welcoming and appealing atmosphere for the shop. - The ideal freelancer would have prior experience in food and beverage ventures, particularly in the realm of donut shops. They should also be able to ...

...an "Internal Server Error" on my Apache server and urgently require professional assistance to resolve it. Unfortunately, I do not have specific fixes in mind but it could potentially involve tasks such as updating the .htaccess file, modifying the Apache configuration file or adjusting permissions for my web directory. This job demands expertise in Apache server maintenance and problem-solving skills as it needs to be completed as soon as possible. Familiarity with best practices for handling server errors would also be ideal. This is the error: In the error log it states that the PHP script did not return a valid set of HTTP headers before the script finished execution. Upon checking the fpm logs I noticed the error, "[19-Apr-2024 06:18:36] ...

I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.

I'm in need of a skilled developer who is proficient in a variety of programming languages and can work on two key areas of my website. - Basket Featur...registration, the user remains on the registration page. This is not the intended behavior, and I need a solution that will ensure that users are correctly redirected to their profile page post-registration. . This video helps what im trying to say. Ideal candidates for this project should have a strong command of HTML, JavaScript, CSS, PHP, and SQL. In addition, experience with Stripe payment integration and troubleshooting registration processes on websites is highly desirable. Please note that these two tasks are interdependent, and hence, need to be addressed simultaneously.

I'm currently experiencing a peculiar issue on my CentOS server. The process /usr/sbin/mariadbd is showing 109% CPU usage in the WHM task manager, although the server load is stable and I haven't made any recent changes. Your primary task would be to diagnose and resolve this problem. No error messages or warning signs have appeared, making the source of the issue somewhat inscrutable. Access will be provided via AnyDesk or a remote desktop connection for swift and efficient troubleshooting. Your expertise in the following areas would be invaluable: - Proficiency in CentOS server administration - Expertise in WHM and server task management - Experience in identifying and resolving high CPU usage issues - Strong communication skills to work collab...

I am currently facing an issue with my website - when a user registers on the site, instead of being redirected to their profile page ...redirected to their profile page or login page, the system keeps them on the same page. Furthermore, upon this failure to redirect, it shows it is successful when registering but doesn't take to another page. I need someone with strong proficiency in HTML, CSS, JavaScript, PHP, and SQL to diagnose the problem and implement a solution so that after successful registration, users are seamlessly taken to their profile page. The ideal candidate should have: - Significant experience in PHP, HTML, CSS, JavaScript, and SQL. - Proven track record in troubleshooting and rectifying website issues. - Firm understanding of user authentication a...

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...

I'm running a cafe and brewery named The Belson and need a simple, yet stylish logo that can represent my brand. Key Aspects: - Focus: I'm looking for a minimalistic design - nothing too elaborate or busy. - Color Scheme: I'm thinking a color scheme of black or white, with no additional colors. - Style: The logo should represent my brand as a cafe and brewery. - the building is a restored Queenslander styled building with a rustic, manly fitout Ideal Skills & Experience: - Experience with minimalistic logo design - Understanding of color psychology - Experience in creating logos for cafes or breweries (preferred, not mandatory) I'm excited to see your creative ideas! Thank you.

As someone on the exciting business path of running a virtual tour service, a top-notch, engaging, and eye-catching website design is critical for my venture. Key Features: * Virtual Tour Gallery: An area where potential clients can easily explore the existing virtual tours I offer. This should be visually engaging, innovative, and user-friendly. * Contact Form: A simple yet effective way for interested visitors to reach out. This communication tool should be designed for clarity and ease-of-use. Primary Goal: The website is not just a display platform, it is designed to showcase my virtual tours and attract customers to my business. I envision a design that puts my virtual tours front and center, captivating visitors to become clients. The design should place a priority on nav...

... All the tables are fed from the main large table (secondly rate table - real time table). Details about the models: ML Model Development: Anomaly Detection Model: Develop a model using Random Forest algorithms to detect unusual patterns in energy usage. SARIMA Forecasting Model: Implement SARIMA models to forecast daily energy requirements, considering seasonal variations. Database: A cloud SQL real time database is preferred. Front end: After analyzing the data, I want to display the results to the user in Flutter with a very simple UI. I want to display: - Total energy consumption. - A graph for the total energy consumption by hour. - Energy consumed for each device. - Energy consumption compared to yesterday's. - Estimated energy consumption by end of the month. - Re...

For the game Dead by Daylight, I would like someone to create an equalizer to isolate the sound of a specific character, and amplify that sound so its easier to hear while im gaming. Ideally Peace Equalizer running in the back that i can switch on and off. The sound is comparable to breathing but is more like a distinct grunting sound. There will be 3 different equalizers, with 3 different sounds at the base. The end goal would be 3 files for peace equalizer I can download. I will provide all the input, so I can send all the audio files required to make the EQs. Looking for a developer who knows how to utilize programs to translate sounds into Hz ranges & into eq's + ideally other advanced techniques I dont know about.

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.

I am looking to fill a longterm editor position for multiple projects for my agency. I am running a short-format content agency that edits videos for various coaches, businesses and podcasts. *The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging.* *I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth.* *You will be paid 7usd for every video-edit.* *The process is super streamlined.* *All videos are tailored by me -> you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple thumbnail that fits t...

I need an expert in SQL Server Report Builder 3.0 to help rejuvenate some lab reports. I require some amendments to be made to the current reports I have. Key Tasks: - Altering the way data is presented within the reports - Incorporating new fields to the current reports In the end, I need the same data results but with improved visibility and understanding. Ideal Skills: - Appropriate familiarity with SQL Server Report Builder 3.0 - Strong grasp of data visualization principles - Detail-oriented and precise to ensure report data remains accurate. Individuals that can deliver these changes precisely and quickly are highly preferred.

This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.

Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancemen...

...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...

I'm in need of a freelancer skilled in Windows server administration and virtualization technology, specifically VMware. Your task will be to set up a VPN server on my existing Windows virtual machine. Key tasks include: - Installing and configuring OpenVPN on the Windows server - Ensuring the VPN setup is secure and functions properly You should have deep knowledge and experience with Windows Server, VMware, and OpenVPN protocols. I'm expecting the project to be done efficiently and timeously without compromising on the server's security measures.

I'm looking for a marketing professional who can run a targeted Facebook Pay Per Call campaign. Specifically, I want someone who can reach Spanish-speaking individuals and drive them to call our service for debt settlement. Key Requirements: - Experience: I need someone who has a proven track record in Pay Per Call campaigns, preferably in the financial or debt settlement sector. Proficiency in running campaigns with a bilingual focus would be a strong advantage. - Language: Fluency in Spanish is a must. The ability to convey complex financial information effectively in Spanish is critical. - Strategy: The ideal candidate should be able to customize ad content and targeting to resonate with our specific audience, encouraging them to take the desired action of making a phone ca...

I am seeking a skilled Network Administrator to convert my computer into a gaming server. My interest lies in hosting multiplayer strategy games, therefore, the professional should have a strong understanding of server setup specific to these game types. Important considerations for this project are: - Support for multiple game sessions running concurrently. - Capable of handling a maximum of 50 concurrent players. The ideal candidate will demonstrate proven experience in similar projects and possess detailed knowledge in network administration, particularly in gaming server setups. Please express your expertise in your bid proposal.

...What went wrong: Execution failed for task ':app:compileFlutterBuildDebug'. > Process 'command '/home/beemo/dev/flutter/bin/flutter'' finished with non-zero exit value 1 * Try: > Run with --stacktrace option to get the stack trace. > Run with --info or --debug option to get more log output. > Run with --scan to get full insights. * Get more help at BUILD FAILED in 20s Running Gradle task 'assembleDebug'... 21.0s Error: Gradle task assembleDebug failed with exit code 1...

...create a T-shirt design for an annual outing event. PLEASE READ THE LINES BELOW AND ONLY SUBMIT YOUR DESIGN IF YOU ARE CAPABLE OF DELIVERING WHAT IS NEEDED. I already ran this contest on this platform, chose a winner but was deceived by the quality of files provided. They were absolutely useless. I've had success finding great designers in in the past and for that reason only, I'm running the same contest again. Please prove I'm not wrong in trusting this platform. Only vector images will be accepted to award prize. Refrain from delivering bitmap images, JPEG, GIF, PNG, we don't want them, we don't need them. Only vector format files generated with CorelDraw or Illustrator will be accepted. This is what we need designed. T-shirt design for our annual...

As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...

I'm looking for a 3D designer specializing in Unity to create and animate characters for my upcoming game. Here's an outline of what I need: Main Game Character: - Create a realistic design - Animate the character for the following actions: Idle, Running, Punching, Knife stabbing, Shooting, Pistol shooting, Dying Enemy Character: - Also a realistic design - Animate for Idle, Running, Shooting, Pistol shooting, Dying Ideal Skills and Experience: - Proficient in 3D character design - Experience with animation, particularly in the context of games - Expert in Unity game engine - Ability to create realistic character designs - Portfolio demonstrating similar work

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

I am looking for an SPSS expert who can help me with running Case-Control Matching analysis on my dataset. Key Requirements: - Advanced SPSS skills, particularly in Case-Control Matching. - Ability to troubleshoot and resolve errors efficiently. Your primary role will be to help me run the Case-Control Matching analysis and ensure it is correctly applied to my data.

I am running amazon store in UAE and i am looking for someone who can help me product sourcing for my amazon store. Note: i don't want to source my product in Alibaba because the shipping cost is very costly for me Also, the seller have good experince in UAE market. Thanks

...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...

...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...

Excel Automation of my project and data visualization

I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...

I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.

1) Integrate Xproxy Server into the prebuilt web dashboard as discussed. 2) Admin N Customer dashboard 3) Load demo $ in the customer account and he buys the proxy Proxy gets assigned to the customer from the server with details like http, socks and user pass , and option to change auth from user?ass to IP auth With API button, he can change the user?ass from his dashboard.

...ability to work promptly to resolve issues. Notability, this project is needed ASAP due to the ongoing loss of website functioning. The successful candidate will ideally begin immediately upon acceptance. Please note that your approach to solving the issue and estimated completion time will contribute to my decision making. I look forward to seeing your proposals and getting my site back up and running again. Cooperation, timely execution, and efficient communication are highly appreciated....

...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...

I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...

I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities

...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...

As we're in the development stage of building a decentralized application, I'm looking for a skilled Solana developer to join the project. The main focus of the project is on building a decentralized application. Therefore, the ideal candidate should have experience with smart contract development and blockchain integration. Skills and experience required: - Proven experience in smar...experience in smart contract development and blockchain integration - Strong knowledge of Solana and Rust programming - Experience in deploying decentralized applications The ideal developer will be able to work closely with our team to bring our decentralized application project into reality. The project is already in its development phase, so we are searching for an expert who can hit the gr...

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

...frame. #Requirements: - Extensive experience as a Data Engineer, Database Architect, or similar role with a strong focus on rapid project execution. - Expertise in handling tight deadlines and delivering complex projects quickly. - Strong understanding of API integrations and experience with RESTful services. - Proficient in relational database design and development, preferably with experience in SQL and NoSQL databases. - Experience with ETL tools and processes under strict time constraints. - Familiarity with CRM and MAP platforms like Salesforce and HubSpot. - Capable of creating detailed entity-relationship diagrams and data flow diagrams quickly. - Excellent problem-solving skills and ability to work independently in a fast-paced environment. - Fluent in English with outst...

I'm looking for a skilled Codeigniter developer to help me with a specific task. - The Purpose: I've already got a Codeigniter project up and running but I'm looking to expand it by adding new modules. - The Module: Specifically, I need help with integrating a new Fees Payments system. - Payment Gateway: The system will need to process Credit Card and Cash Payments. - Skills: I'm looking for someone with a strong understanding of Codeigniter framework, and experience with the aforementioned payment methods. If you have the expertise required, I would love to hear from you.

...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...

I'm in search of a skilled sports writer specializing in cricket. I need 3 articles per week, each running between 1250 and 1500 words. The articles must be: - AI Free (AI detection score must be 5% or below) - Plagiarism 0% - Professional tone and quality content. Payment Criteria: - Initial payment will be for the first article, then, weekly for 3 articles. - 10 NZD/Article (1250-1400 words) (Fixed, not hourly) - Weekly 30 NZD - You can work as long as you want meeting our requirements. The ideal candidate for this role has: - A passion for cricket - Proven experience in sports writing, particularly cricket (Must show samples in this niche). - Strong research and analytical skills - The ability to produce high-quality, engaging content on a regular basis If you're p...