Excel connect to sql server vba jobs
...timeline functionality. Primary Functions: - The app should allow users to create and manage profiles. This feature should be user-friendly and secure. - The app should provide a messaging platform that's intuitive and reliable. - The app should include timeline functionality, enabling users to post and interact with content in a structured manner. Additional Features: - User authentication is a top priority. Security is key for the app, so users' personal information and data should be thoroughly protected. - Social media integration is essential. The app should allow users to connect their profiles to popular social media platforms. - Push notifications are important for keeping users engaged with the platform. When it comes to me...
I'm seeking an experienced marketer to connect our coir doormats with the US and European markets. Our target audience is primarily commercial businesses, though we're also open to reaching homeowners. Key Responsibilities: - Generate high-quality leads in the home textiles, floor coverings, and home decor shop industries. - Utilize trade shows and local directories to effectively market our products. Ideal Skills and Experience: - Proven track record in B2B marketing targeting commercial businesses. - Strong connections in the home textiles, floor coverings, or home decor industries. - Experience with trade show setups and local directory listings. - Knowledge of the USA and European markets would be a plus. Please get in touch if you can help us...
I want a wordpress plugin to connect to the api booking manager mmk
Note: Applicants are required to submit answers (and proof with screenshots) to the following questions to be considered: How much experience do you have with Facebook ads? What are the highest daily budgets you have managed? Please provide examples campaign success (with screenshots ) (from the last year), which clearly shows amount spent, # of purchases, Cost per purchase, ROAS and campaign dates. Provide a brief overview of your preferred scaling strategy We are an e-commerce business that is in need of a full-time Facebook Media Buyer & Creative Director to be part of our push for even more growth! In our first 2 years, we closed off with nearly $10M. If you’re a Digital Media Buyer who can help make a difference, today! We prefer someone with a...
I am looking to significantly revamp my home's exterior in order to increase its curb appeal. The remodel should reflect a modern rustic style. The specific changes I intend to make include: - Window replacement: To maintain a unified style, the new windows should complement the modern rustic look. - Addition of front dormers: Designed to integrate seamlessly with the existing structure while adding to its visual appearance. - Stone and siding: Both these elements should be curated carefully to bring the essence of the modern rustic style to life. Experienced freelancers who excel in exterior home remodeling with proficiency in modern rustic designs would be ideal for this project. Critical abilities include an eye for d...
I'm looking for a professional who can help me generate contact information (name, email,...email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliver high-quality, targeted le...
I'm in search of a seasoned full stack app developer who could design a cutting-edge social networking app. Here are the specifics: - The main intention of the app is to facilitate social networking, allowing users to communicate and build connections. Key Features Expected: - A unique feature of 'Profile Sharing' must be integrated. This will allow users to share their profiles amongst each other. Profile Types: - The app should cater to extended user profiles that go beyond just names and profile pictures. It should include additional personal information, allowing users to better connect on the basis of shared personal characteristics and interests. Ideal skills and experience: - Proven experience in full stack development, es...
EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.
I'm in need of an expert server administrator with extensive experience in Plesk to assist with the configuration and troubleshooting of my server. Key Responsibilities: - Server Setup and Configuration: The server is already fully configured, but I'm facing some severe issues. Your role would be to assess the current setup, make necessary adjustments and ensure that the server is running optimally. - Troubleshooting: The primary issue I'm experiencing is a DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#' (Errcode: 2), query was: DESCRIBE `sessions`. Your expertise in diagnosing and resolving such issues will be crucial. Skills and Experience Required: - Proven ...
My Apache Web server is not loading pages, but there are no error messages. I have checked and it is running and accessible. All pages seem to load to the default server page. The pages are running on Apache in Docker containers I need a skilled freelancer to help me resolve this issue. Ideal Skills & Experience: - Proficient with Apache Web servers - Troubleshooting skills - Understanding of server configurations -Work done AnyDesk, no SSH! Paying $15 Please bid if you have relevant experience.
I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.
...programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Applicants with substantial experience are preferred as their expertise would contribute to the quality of the task execution. Any relevant cer...
Having problems with Docker and need configurations 1 - 3 current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management ...
I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.
...our Windows Server 2022 RDP server. I need an experienced professional to fix this problem and make sure it doesn't recur. Key Requirements: - Diagnose and Resolve: You should be able to diagnose the root cause of the issue and resolve it efficiently. - Windows Server 2022 Expertise: You must have proven experience working with Windows Server 2022 environments and a deep understanding of its functionalities. - Troubleshooting Skills: Your troubleshooting skills should be top-notch to identify any underlying issues that may be causing the problem. - User Profile Management: You should be skilled in managing user profiles effectively to ensure a smooth and error-free experience for all users. I've already tried restarting...
I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.
...expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: You must be able to easily navigate Google Sheets and efficiently use all its functionalities. - Experie...
...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation ...
I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of ...
Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.
I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the value. The da...
I'm in need of an expert in email security protocols (DMARC, DKIM, SPF) to set up proper configurations for my email domains. Key tasks include: - Implementing DMARC, DKIM, and SPF for my email domains. - Ensuring these protocols are correctly set up to enhance email deliverability. - Providing documentation and guidance on upkeep and maintenance post-configuration. I'll share the number of domains and email addresses involved when we connect. Experience in implementing email security protocols and excellent communication skills are essential for this job. Please provide details on your past experiences with similar projects.
Please Sign Up or Login to see details.
I am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial information in a clear, concise...
I'm seeking an expert in Windows Server licensing to clarify some key points. - I have a single Windows Server, specifically Windows Server 2019 or 2022. - 5000 user accounts will need to access this server concurrently and they will use web application on Blazor Server. - I need advice on the appropriate licensing model to accommodate this level of usage. Ideal candidates for this project are professionals with: - Profound knowledge of Windows Server licensing, preferably Windows Server 2019 or 2022 - Experience with large-scale user access scenarios and concurrent usage. - Ability to explain complex licensing models in simple, user-friendly terms. What is cheapest model for me to utilize. People...
...developer to create a REST API for my project. The ideal candidate should have experience in developing REST APIs and be proficient in C++ programming. Functionality: - The REST API should focus on data retrieval and manipulation. - User authentication and authorization are required for this project, using existing APIs Database: - Although I don't have an existing database, I have specifications for it. - The API should connect to the specified MySQL database based on the provided specifications. Timeline: - The expected timeline for the project is more than 3 weeks. Skills and Experience: - Proficiency in C++ programming language and POCO framework - Strong knowledge and experience in developing REST APIs. - Familiarity with MySQL database connectivity an...
...and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme to ensure it's on-brand. - User-Friendly Experience: As well as being visually appealing, the tracke...
I am in need of a skilled expert to develop and set up a computer vision program to process a batch of SD video cards. This program will undertake a couple of key tasks: - Image Classification - Object Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsof...
...from an Excel document to a website form on a daily basis. The tool should also facilitate the mapping of Excel columns to the corresponding fields in the website form through a user-friendly interface. Key requirements include: - Daily automated upload of data from Excel to the website form - A straightforward, user-friendly interface for mapping Excel columns to website form fields - Accurate and efficient transfer of text information - A secure and reliable tool that ensures data integrity Ideal candidates for this project should have: - A strong background in web development with experience in form automation - Proficiency in Excel, including working with data extraction and manipulation - Familiarity with creating use...
I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - ...
...inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling potentially complex website structures, and able to work wit...
...for a SEO specialist to help me to improve the traffic on my website. The focus is on local search engine optimization / onpage-seo. ## Note: - I need only an instruction excel - list. The language of the page is in german, but an online translation tool can be used. - No Plugin will be used, but other proven SEO - Tools are possible. Key Responsibilities: - On-page SEO analysis to identify the status of the page (one page, homepage) - You will send me your seo recommendations for onpage optimations - You will use a seo tool (we discuss which one is best) - I only need a written instructionfile what should be done at page, - start asap - Time: 2 hours a week for one month Ideal Candidate: - experience with on-page SEO for websites - Strong analytical ...
Hi Nadia A. The project is: Research and identify qualified 1,000 sign manufacturers /stores /sellers /suppliers (that sell signs) across Germany. Compile the leads data into a Excel format.
As a client, I hold a ready-to-launch ott App, specifically designed for movie streaming. I require an efficient freelancer to facilitate the process of uploading and publishing this app on the Apple App Store. All necessary files and account access will be provided. Ideal Skills and Experience: - Proven experience with uploading and publishing apps on the Apple App Store - Familiarity with Apple's App Store Connect and its requirements - Experience in troubleshooting any potential issues during the upload process - Familiarity with entertainment apps, particularly ones offering movie streaming While the app has already been fully developed and is ready for upload, a basic understanding of app functionality could be beneficial in ensuring a smooth transition on ...
...digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong organizational and data handlin...
I am looking for an experienced API Integration Specialist to help automate the sales of eSIM cards using on the GetYourGuide platform. The integration should be done via (formerly Integromat). **Project Requirements:** 1. **API Integration**: Connect the eSIM API from to GetYourGuide via Make.com. 2. **Automated Workflow**: Set up automated workflows to handle: - Order processing and fulfillment - Customer notifications and delivery of eSIM cards - Payment confirmation and reconciliation 3. **Testing and Validation**: Ensure the integration works seamlessly, handling all edge cases. 4. **Documentation**: Provide detailed documentation of the integration process and workflows for future reference. **Skills Required:** - Experience with
I have a website currently through that I need to be repurposed for a new business. I need a new modern logo design I need someone with high SEO skills to go optimize my website. SEO skills and mastery in Google Ads. Google Ad optimization Facebook Ads Facebook Ad optimization Weekly Facebook posts Connect my current domain to the new website Key elements needed in the design includes: * A captivating lead generation website. * A simple but powerful logo carrying my company name. Here is what I expect from this project: * A modern design that aligns with the latest trends to engage visitors effectively. * An SEO optimized website to improve visibility on search engines. * Expertise in Google Ads to maximize reach and effectiven...
I have a list of 2060 SKUs in an Excel sheet that I need corresponding images scraped from Website A. Each image should be saved with the SKU number as the filename (e.g., for SKU 32440). Key Requirements: - Scrape images from Website A for 2060 SKUs - Save each image as a high-resolution jpg with the SKU number as the filename Delivery: - I will provide you with the Excel sheet containing the list of SKUs via email. - You should deliver the images in a compressed file with 2060 images, each named according to the corresponding SKU. Ideal Skills and Experience: - Experience in web scraping, particularly image scraping - Proficient in Excel for managing SKU lists - Ability to deliver high-resolution images - Attention to detail to ensure...
ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)
i want to be data entry job use word, pdf , excel , PowerPoint , and any type of graphic design work . i have 3 years teaching experience with data collection , data entry , and graphics design . i have fully and wonderful experience in Microsoft office , excel, PowerPoint , photoshop , illustrator, CorelDRAW, filora
...Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate goal of this project is to use data effectively to inform business decisions regarding our customer base. If you find you have...
For this project, we need to consolidate customer data from multiple Excel files into one Excel sheet using macros. This will allow us to manage our data more efficiently. Key tasks include: - Creating a macro that can extract and merge customer data across several Excel files. - Managing the data in a way that it is grouped by Customer ID. Skills and Experience: - Extensive knowledge in Excel and proficiency in creating macros. - Prior work experience with data consolidation projects. - Exceptional attention to detail. - Ability to organize data effectively. - Knowledge of data management according to customer demographics.
I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.
I am looking for a skilled data analyst to compile and analyze raw ad spend data from Google Ads and Facebook Ads. This data will be used in correlation with sales data from Excel Sheets. The goal of this task is to determine if the presented ad spend had a significant impact on total sales or sales in our stores. The data spans from May 2016 to May 2024. Key Requirements: - Compile ad spend data from Google Ads and Facebook Ads, and sales data from Excel Sheets. - Perform trend analysis on the data sets to determine if any discernable impact exists between the ad spend and sales. - The focus should be on whether ad spend, regardless of platform, led to a measurable and discernable difference in sales. Ideal Skills: - Strong data a...
...am looking for help with a solidwork project. I want to build tuned pipe , expansion chamber for dirt bike. I do know all my dimensions lenght and diameters. I want to be able to draw a line wich will be my centerline and then on this line i want customize every lenght and diameter of each section. Then had radius in sections. I would like to to be able to divide each sections in strip section to be then cut on my plasma. I have included a YouTube video to show what i am looking for . I want to have a reference line that i can curve on every axis along the length required in order to follow the curved and straight section needed. - On that line I want to have adjustable point to be able to adj...
I'm seeking a talented designer to create captivating text-based and combination of text and symbol logos for my brand. Crafted logos will serve for branding and advertising, hence should connect to the audience and effectively communicate the brand. Ideal skills and expertise needed: - Expertise in graphic design - Experience in creating unique and memorable logos - Proficient in Adobe Illustrator or other design software Color scheme is open as I trust your ability to choose hues that best amplify the design's effectiveness. Your creativity will be highly appreciated.
Translation of two files, from English to Hebrew. File #1 contains 8 rows of text in Excel format, 119 English words. File #2 contains 85 rows of text in Excel format, 2,035 English words.
...project is to boost our loan volume, and in order to achieve this, we need to work together to synergize and utilize technical tools effectively. Key requirements: - A solid background in the retail banking industry, with a specific emphasis on unsecured loans. - Proficiency in Customer Relationship Management (CRM) software. Your responsibilities will include: - Collaborating with our team to identify potential areas for growth in our unsecured loan business. - Utilizing your expertise and the technical tools at your disposal to help us increase our loan volume. In summary, we aim to benefit from your experience and technical know-how to grow our business. If you have a strong background in retail banking and CRM software, w...
