Excel vba update data connection sql仕事
I need an expert in Excel to assist me in merging two files. The task involves transforming the data in these files before the merge. Ideal Skills: - Proficient in Excel, particularly in data transformation techniques - Experience with data merging - Attention to detail for accurate data handling
I'm in need of an experienced AWS DevOps Engineer to assist in setting up our API Gateway and configuring a WebSocket connection for our chat application. Key Responsibilities: - Setting up API Gateway - Configuring a WebSocket connection (WSS) - Integrating with Lambda - Implementing authentication using API Gateway authorizer Ideal Skills and Experience: - Hands-on expertise in AWS services - Deep understanding of API Gateway, Lambda, DynamoDB, IAM, and WebSocket protocols - Prior experience with real-time chat applications Please note: We specifically need help with setting up the authentication for the WebSocket connection using API Gateway authorizer.
I need an experienced Magento developer to update my current Magento site to the latest version and install reCAPTCHA v3. Key Requirements: - Install reCAPTCHA v3 on the site - Update the site to the latest Magento version Post Update Tests: - Test the payment gateway for functionality after the update - No need to test the product catalog or user accounts No New Features Required: - The update should not include any new features or extensions. Ideal Skills and Experience: - Extensive experience with Magento - Prior knowledge of installing reCAPTCHA - Familiarity with testing payment gateways on Magento - Ability to perform site updates without adding new features.
I have 6 excel spreadsheets containing attendee information for some small upcoming events. I need the data sorted into groups by age and other specific requests. Additionally, I need some standard data cleaning to be done, specifically standardizing phone numbers and removing duplicates. Ideal skills for this project include: - Strong proficiency in Excel - Attention to detail - Good understanding of data sorting and cleaning techniques Please bid if you can assist with this task.
...bedtime -the app has the option to start a meditation playlist if you need to get relaxed before going to bed, you need to be able to choose a playlist. If the user has a smart watch the heart rate is monitored and if it is still high before sleeping the app can recommend specific meditation -custom product: smart sleep earplugs Design for connecting earplugs and seeing battery percentage and connection status -reschedule user bed time and on the bed time alert there is the option to extend all actions by half an hour each time. When the user sleeps later or sleeps bad there is the option since we have the user's calendar that the user can select that the app automatically delays the wake up time so the user keeps having a minimum of 8 hours of sleep. -Also since we trac...
I'm seeking a solution to expedite job posting updates on Clasified website. I refresh my page every minute but still miss listings. I need a faster, more reliable way to track job if i update the browser every appears new ad appears for example with this message "posted 8 minutes ago"
I'm looking for a professional to update and enhance my LinkedIn profile. Key Areas: - Revamping my professional summary to reflect my career and aspirations in a clear and impactful way. - Updating my work experience with specifics about my job titles, responsibilities, achievements and metrics, as well as company descriptions and roles. The tone of the revised professional summary should be 'Professional and formal'. Ideal Skills: - Expertise in professional resume/LinkedIn profile writing - Understanding of LinkedIn algorithms - Excellent command over English language - Attention to detail - Ability to portray information in a compelling manner
I have a PDF flyer that needs a simple email update. The contact email on the flyer should be changed from reservations # to guestservice # nisade.com. ( I was not able to put the @ sign in this descirption ) Additionally, there is some text content that needs to be changed, though I cannot specify what changes are required at this moment. Please send over pdf and high and low res jpg image too You can download the pdf here !AtrP9hCmu-3vjZxPN0cTE9eu5Km_LQ?e=JJxtAp
Are you a creative designer looking for your next challenge? We’re seeking a stunning, professional cover photo design to kick off our podcast, Elevate & Explore. Hosted by Aaron Baker & Ryan Bailey, this podcast explores self-development, happiness, connection with the outdoors, and making the world a better place. Requirements: 1. Title and Hosts: Include the podcast title Elevate & Explore prominently, along with the hosts' names, Aaron Baker & Ryan Bailey. 2. Inspiration from Eramos Outdoor Gear: Use the design aesthetic of our outdoor gear company, Eramos Outdoor Gear (see attached logo for reference). 3. Incorporate Elevation Lines: Integrate elevation lines into the design for an outdoors-inspired, modern feel. 4. Style: Clean, elegant, and profess...
I need help with reworking an existing venture capital excel model for a new investment. The model should provide accurate financial returns for this investment. Specific Sections: - Revenue projections - Expense forecasts - Return calculations Assumptions to Update: - Market growth rate - Cost of goods sold - Operating expenses New Financial Metrics to Incorporate: - Internal Rate of Return (IRR) Ideal Skills: - Expertise in Excel and financial modeling - Understanding of venture capital and investment analysis - Strong analytical and problem-solving skills Experience: - Prior experience reworking venture capital models - Proven track record of accurate financial forecasting I'm looking for a freelancer who is detail-oriented and can deliver a robust model ...
I'm looking for a dynamic, resourceful Marketing Manager who can take charge of our marketing strategies and execute them to boost sales and expand our brand reach. You should be ready to explore new, perhaps unfamili... particularly content marketing - Ultimately, driving an increase in sales through effective strategies. This a monthly job that for a predetermined work that must be accomplished on a daily weekly basis like emailing using HUBSPOT and other platforms weekly from our BLOG. Another example, post on FB/IG/ SMM and post blogs. ANother one would be create video, flyers and marketing materials, update pages, add web pages and optimized the site. Manage leads that comes in. If you're up for the challenge and ready to make a significant impact, I look forwa...
We are looking for an experienced freelancer to update product descriptions on our Shopify store for approximately 200,000 products. The task involves enhancing existing descriptions to improve clarity, SEO optimization, and overall appeal to customers. You should be proficient in Shopify and have a keen eye for detail. Familiarity with e-commerce best practices is essential. This is a large-scale project that requires efficient communication and timely completion.
I'm looking for a designer to subtly update my logo. The primary focus is to change the writing style to a modern one, while keeping the overall layout of the original logo. this is a very basin job and should take less than 5 minutes. I need the writing 'Designer Collection' to be in a modern unique Italics type font. Paying $10 AUD
...(PoC) on Microsoft Fabric data ingestion/engineering. The PoC should be visually represented through slides and Visio diagrams. The project involves ingesting data from Snowflake and Azure SQL Server into MS Fabric, performing transformations, and provisioning data for end users. Key Aspects to Cover: - Data Ingestion: Demonstrating how data is sourced and imported into the system. - Data Transformation: Illustrating the processes and techniques used to manipulate the data. - Data Provisioning: Showcasing how the processed data is made available to end users. Visual Elements: The proof of concept slides should include: - Data Flow Diagrams: Depicting the journey of data throughout the system. - Process...
...consulting firm seeking to execute a dedicated marketing campaign aimed at generating leads. Target Audience: - The primary focus of this campaign is targeting small to medium size businesses. Marketing Channels: - The campaign will predominantly leverage social media platforms along with business development avenues for stimulating referral sources -In conjunction with the campaign we need to update/elevate our website to be interactive, displaying our menu of services Additionally, we would like to create collateral material for local referral sources including a menu of services Ideal Skills and Experience: - Proven experience in lead generation, particularly in the accounting or finance sector. - Expertise in social media marketing with a track record of successful campa...
I'm looking for a seasoned developer to create a simple and clean web application using C# and Blazor, integrated with an existing Azure SQL database via ASP.NET and Entity Framework. Key Requirements: - The web application should primarily handle data entry and management. - A straightforward user interface that is simple and clean. Essential Skills: - Proficiency in C#, Blazor, ASP.NET, and Entity Framework. - Experience with Azure SQL databases. - Ability to create simple and clean user interfaces. The project does not require advanced data validation or error handling, just basic validation. We have a working design (rough) to use as a design brief.
My business listings on DuckDuckGo and Bing need an update with new contact information, business hours, and media. All updated information is prepared, but I require assistance from the freelancer for verification purposes. Ideal skills for this job include: - Proficient understanding of online business directories - Experience with DuckDuckGo and Bing - Excellent attention to detail - Strong communication skills for verification assistance Please note that all information is ready and will be provided.
I'm in need of a professional who can assist YCC - Youth Centres of Calgary, a growing charitable youth centre, with updating our existing brand elements and creating new brand elements. This is a comprehensive branding project that encompasses a website redo, video production, brochure and flyer design. Ideal Skills & Experience: - Extensive branding experience - Website redesign expertise - Video production skills - Graphic design for brochures and flyers - Understanding of brand consistency across different mediums We are a grassroots organization and our branding needs to keep this feel. It's critical that you have a strong portfolio that showcases previous brand updates and redesign projects you've worked on. Your ability to create a cohesive brand experience acr...
Platform Overview: Oasis is a web-based platform connecting users with local businesses and events, while rewarding engagement with a points-based system. Key Features: • User profiles to track points, rewards, and interactions. • Search and discovery of businesses with filters • Map view for where users can explore what badges/businesses are avaible around them • Points system for earning rewards through engagement (e.g., Scanning QR codes, attending events, checking in at locations). • Business dashboard for listings, promotions, and analytics. • Responsive design optimised for desktop and mobile. Please send me a message to request the current Figma wireframes Goals: • Drive economic growth and community engagement. • Support local...
...statements for each account have already been converted to excel format. You must go through the transactions for each year and properly itemize each transaction and creat the Businesses Financial Statements (PNL & BS) for tax filing purposes. This role also involves reviewing my personal bank account statements to identify any business-related transactions made that should be included such as making a payment for a business credit card, owner investments, and Etc. I need this to be completed ASAP perferably by the end of this week if possible. Key Responsibilities 1. Organize and Classify Transactions: Review and categorize all business-related transactions from each accounts transactions that have already been converted to excel from the PDF statements, including: ...
I need a Data Entry Specialist, preferably with an engineering background, for a 3-hour task. This project involves: - Transferring mixed data (numerical and textual) from a PDF document into an Excel spreadsheet. - Organizing the data by categories or sections in a clear and user-friendly format. - Applying both totals and averages using basic Excel functions or formulas. The ideal candidate for this task must: - Have a strong proficiency in Excel. - Possess keen attention to detail and accuracy. - Be able to complete the task within 3 hours. Given the nature of the task, an engineering background would be beneficial due to the need for precision, analytical skills, and a structured approach.
The mobile app should create a token using the Stripe SDK for mobile platforms ( Stripe iOS/Android SDK) this is for an update
...development partner to design and implement a secure and user-friendly online platform for managing and sharing information. The system will streamline the process of requesting info, notifying parties, and securely sharing info details with third parties. Key features include: Automated workflows for info requests, reminders, and submissions. A secure dashboard for users to view and manage info update statuses. Integration of encryption for secure sharing of details with designated recipients. Use of advanced natural language processing (NLP) to summarize reference content. Role-based access controls and immutable record-keeping for enhanced security and trust. The solution must prioritise security, scalability, and user experience, adhering to relevant compliance standards (e...
...messages. Multimedia file sharing. Secure audio calls. Peer-to-peer communication only (no intermediate servers). Implementation of advanced end-to-end encryption. 3. Anonymous and Secure Network: Integration with anonymous networks like TOR to ensure maximum anonymity. Connection obfuscation to prevent tracking or localization. 4. Advanced Security Measures: Each device will have a unique identification code. Communication allowed only between authenticated devices. No data or metadata storage on servers. Mechanisms for data self-destruction in case of compromise. 5. Security Testing: The system must be robust against network attacks, hacking, and breaches. Project Goals: 1. Ensure maximum security and privacy for communications. 2. Develop a user-friendly sys...
I need assistance pulling all followers from my business Instagram account. Specifically, I'm looking for their username, email, and name (if available). Ideal skills for this project include: - Proficiency in data extraction and web scraping - Familiarity with Instagram's platform and its data privacy rules - Experience in data presentation using Excel or CSV formats Please bid only if you can deliver the data as a neatly organized spreadsheet (Excel, CSV).
El proyecto "Servicios Personalizados en Excel" consiste en ofrecer trabajos a medida en Microsoft Excel, donde el cliente especifica sus requerimientos y yo me encargo de realizar el trabajo correspondiente. Este enfoque garantiza que cada proyecto se adapte a las necesidades unicas de cada cliente, asegurando satisfacion y resultados optimos. Objetivos del Proyecto: 1. Atención Personalizada: Escuchar y comprender las necesidades del cliente para diseñar soluciones efectivas. 2. Ejecución Rápida y Eficiente: Realizar los trabajos solicitados en un tiempo razonable, manteniendo altos estándares de calidad. 3. Diversidad de Servicios: Ofrecer una variedad de servicios que incluyen automatización de procesos, análisis...
...seeking a skilled app developer to create an interactive brain simulation app for both iOS and Android platforms. Key Features: - The app will allow users to tap on different parts of a realistic 3D brain model. - Upon selection of a specific brain area, the app should display that area's primary function and how it influences certain emotions. - The primary goal is to educate users on the connection between different parts of the brain and their everyday feelings. - Enable users to track their learning progress and revisit specific brain areas. - Offer the app in english and arabic. - Include information on common brain diseases and disorders in the simulation that have to do in that specific area in the brain. - Add audio explanations and narrations for each brain area...
I'm in need of a comprehensive spreadsheet to track various employee absences. The types of absences I want to monitor include sick leave, call-o...spreadsheet should capture the date and time, the reason for the absence, whether the employee gave late notice or not, and the number of "attendance points". - Identification: Employees should be identifiable by their full name. Here are some links to tutorial for similar trackers: Ideal Skills: - Proficiency in Excel or Google Sheets. - Experience in creating tracking spreadsheets. - Understanding of HR metrics would be a plus. Please ensure that the spreadsheet is user-friendly and can be easily updated on a regular basis. Looking forward to your bids.
I have two Excel files detailing my wine collection - one is from 2023 and the other is an update. I'm looking for someone to identify the differences between the two files. Specifically, I need to see: - Changes in item quantities - Any addition or deletion of items After the comparison, I would like the results to be compiled into a summary report. Additionally, if possible, a visual chart illustrating the differences would be appreciated. Ideal candidates should have extensive experience with Excel and data analysis. Familiarity with inventory management and wine collections would be a plus.
I'm seeking an experienced developer with a strong background in implementing user authentication, E-commerce with Stripe integration, and API integration with Appwrite. This project involves working with some design guidelines and branding material I have, so an eye for design would be beneficial. Key Responsibilitie...payments integration - Familiarity with Appwrite - Strong understanding of user authentication systems - Design sensibility and experience working with design guidelines - Excellent communication skills for remote collaboration Please share your portfolio or examples of your past work. This opportunity includes the potential for a full-time position. Candidates must have a reliable internet connection and a capable laptop to work efficiently in a remote envi...
I'm in need of a trading card game (TCG) card template for a modern battle-themed card game. The template should... Your task will be to adapt and enhance the provided design into a fully functional card template. Note: the logo in the guide is sample only, and not the actual logo that I'll use. If you can design the logo will be appreciated too. Note2: You can suggest other placement for the elements of the cards as you see fit. I want an easy to edit template. Will accessible font. I want to just update the text, replace the photo for each artwork. Keep the artwork in the card large, and don't open small window for the artwork like older TCGs. Ideal skills for this project include graphic design, experience with TCGs, and the ability to create engaging, ...
About Us: We are seeking a skilled Azure Data Engineer Technical Trainer/Tutor to deliver high-quality training to our clients. The ideal candidate will have extensive experience in Azure data engineering and a passion for teaching. Responsibilities: Design and deliver comprehensive training programs on Microsoft Azure data services, including Azure Data Factory, Azure Databricks, Azure SQL Database, and Azure Synapse Analytics. Develop course materials, hands-on labs, and tutorials tailored to various skill levels. Stay updated with the latest developments in Azure data engineering to ensure training content is current. Assess learners' knowledge and provide constructive feedback to facilitate improvement. Offer individualized instruction a...
I require an excel sheet that tracks and analyzes the changes in open interest data of the NIFTY index. This sheet should be able to provide insights into market sentiment based on this data. Key Requirements: - The excel sheet should continuously update the data every minute. - The sheet should be able to provide a text summary of inferences about market sentiment from the open interest data. Ideal Skills: - Proficiency in Excel with experience in financial data analysis. - Understanding of open interest and its implications on market sentiment. - Ability to create an automated Excel sheet that updates data every minute. Please note that I'm looking for a freelancer who can deliver a high-quality, reliab...
I need a mobile app that allows for the update of media content on my website(s). Many sub domains will be used by users so a database will be needed. The app should facilitate the uploading, editing, and targeting of media files (images/videos) to specific destination files on the site, with the ability to set limitations on changes and incorporate ad-based content. Key Features: - Upload new media: The app should provide a user-friendly interface for uploading new media files to the website. - Edit existing media: Users should be able to make changes to current media content. - Target destination files: The app should allow users to specify where on the website the media should be placed. - Limitations to changes: The app should have a feature that restricts the number of daily ...
I need a excel sheet (some columns protected), as soon as date are entered in Sheet 1 on a specific column the entire row needs to more to tab2, same at tab 2 as soon as date entered the row needs to move automatically to tab 3, same to tab 4, 5, 6. (All the rows are protected, can not be deleted, they will only move between tabs as the project runs) - Production Job Tracking report I would like to do the project together with the freelancer on teams (within the next hour is possible) I assume the project will take maximum an hour
I'm looking for an Excel developer to create an inventory management system. While specifics on the functions of the system haven't been detailed yet, the system will need to track stock levels and generate reports. As such, the ideal freelancer for this project should have prior experience in developing similar systems on Excel. Skills and experience required: - Advanced knowledge of Excel - Prior experience in developing inventory management systems - Ability to generate and interpret detailed reports - Excellent understanding of tracking stock levels
...and warrior status. He wears medieval-style armor, sometimes adorned with intricate patterns and runes representing his connection to the divine and his bravery. Toma’s posture is strong and confident, holding a sword or shield, with intense, focused eyes that reflect his readiness for battle. Symbolism: Bravery, strength, nobility, warrior spirit. --- 3. Noble Wolf (A Symbol of Protection) Appearance: The noble wolf is often depicted with sleek silver or white fur, symbolizing purity and the connection to the natural world. Its eyes glow with intensity and wisdom, often reflecting its loyalty and protective nature. The wolf stands proud and strong, showing its connection to the divine and its role as a protector of the good forces. Its stance is alert, ...
We’re seeking an experienced SEO professional to improve our website’s search engine rankings, organic traffic, and overall online visibility. Scope of Work Audit & Strategy: Perform an SEO audit and create a tailored strategy. Keyword Research: Identify high-potential keywords. - On-Page Optimization: Update titles, meta descriptions, and fix technical issues. - Off-Page SEO: Build quality backlinks and improve domain authority. - Monthly Reports: Provide updates on keyword rankings and traffic. Requirements - Proven experience with SEO (share case studies or examples). - Familiarity with tools like Google Analytics, SEMrush, or Ahrefs. - Knowledge of the latest SEO trends and algorithms. - Details to Include in Your Proposal - Examples of websites you’ve op...
I'm seeking a professional with experience in Magento Open Source and Easyship for seamless integration on my Cloudways server. Additionally, I need assistance updating the Porto theme on my eCommerce site. Key Requirements: - Install and integrate Easyship with my existing Magento Open Source platform on a Cloudways server. - Update the Porto theme on my eCommerce site. About Easyship: - I already have an Easyship account. - Standard integration without specific customizations is required. Your expertise will help me enhance my shipping process, making it more efficient and user-friendly.
...part numbers and costs from a supplier's website into an Excel spreadsheet. This spreadsheet contains makes and models for every vehicle listed in the UK. Key Responsibilities: - Accurately input part numbers and costs from a supplier's website into designated columns of an Excel spreadsheet. - Follow specific formatting and column header requirements as detailed below. Specific Columns and Formatting: - The data needs to be entered under specific column headers in a predefined order: makes, models, costs, part numbers. - Conditional formatting or color-coding will need to be applied at times according to supplied guidelines. Ideal Skills: - Familiarity with Excel and its data entry requirements. - Attention to detail to ensure all data...
I need a comprehensive dataset prepared for Tableau that encompasses a variety of data types including sales, customer, and financial information. The data is currently in Excel/CSV format. Key Requirements: - Transform and clean various data types (sales, customer, financial) from Excel/CSV for Tableau - Prepare the dataset to allow for a variety of analyses and insights, including but not limited to sales trends over time, customer demographics, and expense versus revenue tracking. Ideal Skills: - Proficiency in Excel/CSV data handling - Expertise in data preparation for Tableau - Strong analytical skills to understand and anticipate necessary data transformations for desired insights Please note that the final dataset sho...
I'm in need of a professional graphic designer who can breathe new life into my classic-style logo. The update should incorporate some added graphics and my business name. Key Requirements: - Transform the logo to include: - Icons or symbols - Lines or shapes - Textures or patterns - Use of Bold and Vibrant colors Ideal Skills: - Proficient in graphic design software - Strong understanding of classic design principles - Ability to blend modern elements into a classic style - Excellent color theory knowledge - Creative and innovative thinking
Looking for a Developer We are seeking a skilled programmer with expertise in Ionic, Node.js, and SQL to help us enhance our existing application. The app is already developed and fully functional, but we need to implement the following features: 1. Multi-language support: Add the ability to switch between different languages throughout the app. 2. Chat translation: Integrate a system to automatically translate chat messages into multiple languages in real time. If you have experience in these technologies and are ready to contribute to a growing project, please reach out to us with your portfolio or previous work.
I'm looking for an Excel expert to design a template for tracking my total monthly/yearly sales. This template should also allow for comparison over time. Key Features: - Total sales tracking - Comprehensive data visualization features: Bar charts, Pie charts, Line graphs - User-friendly manual data input Ideal Skills: - Advanced Excel skills - Experience in data visualization - Knowledge in sales data tracking
I need an experienced developer to connect the ActiveNet API to my WordPress website. The website posts classes as custom post types. The integration should allow the ActiveNet API to create and delete classes on the website as they are updated in ActiveNet. Specific Requirements: - Connect class schedules and class details from ActiveNet. - Update existing class information on WordPress as it changes in ActiveNet. - Evaluate the need for custom fields or specific attributes in class posts. Ideal Skills: - Proficiency in WordPress and WordPress custom post types. - Extensive experience with API integration, particularly ActiveNet. - Ability to assess and implement necessary custom fields. Time is of the essence, so I would appreciate it if this could be done as soon as possible...
I'm looking for a web developer to help me update my website. The main goals are: - Making the site more adaptable for various devices, particularly ensuring easy navigation on mobile devices. - Updating the design to feature larger images and a modernized layout. - Ensuring the site displays correctly on both PCs and mobile devices. The ideal candidate will be experienced in responsive web design, have a strong understanding of modern web aesthetics, and be able to work with larger images to create a visually appealing site. A portfolio demonstrating these skills would be highly beneficial. Thank you!
I'm seeking a freelancer to update my existing CV into a modern styled Word document. - Convert my current CV into a sleek, modern design - Deliver the final product in a Word document format Ideal skills for this task include: - Proficiency in Microsoft Word - Graphic design skills to create a modern aesthetic - Excellent understanding of CV best practices
