Excel query access database일자리
The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
...this. For example, we can see book cover image at (http protocol) but cannot at (https protocol) The goal of the project is making the protocol of S3 image server for https. So we can see the book cover image at the main https://www.bookoob.co.kr. You should work through Team Viewer or Anydesk to access my AWS console. I think the proper budget for this project is under 100$ and 2~3 hours. Thanks for your showing intersts on this task. https:// 에서 도서관 서비스를 제공하고 있는데, 그 안에 http:// 서버에서 이미지를 불러오는 과정에서 크롬에서는 이미지가 보이지 않습니다. 예를 들어, 에서 표지이미지인 가 안보입니다. 는 이미지 서버로 사용하고 있는 AWS S3 에 연결되어있는
...order! Are you a science journalist or scientist with a great idea still in the beginning stages? Or are you stuck closer to the finish line, unsure what you need to do to get your paper up to commercial or academic publishing standards? I can help! I am a widely published writer of nonfiction, journalism, and science research with a wide variety of publications under my belt. I especially excel in first-person investigative journalism, memoir and biography, mainstreaming science for press releases and articles, and polishing scientific papers pre-publication (especially mechanical engineering, biomedical engineering, Sports science, Ergonomics, Biomechanics). I can advise on a wide variety of styles from mass market to specialist publications and especially enjoy 'punc...
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
I want to create a website similar to another. The new site doesn't need to be the same interface but do all the functions. I don't have the the id or password to access the server database but only user account to access the data via web service.
[] Only open to those who are resident in Korea and must be able to communicate in either Korean <--> English or Korean <--> Japanese. I sell children's clothes in Japan I would like to purchase children's clothes in Korea, but lots of businesses do not ship to Japan I am looking for a purchasing agent, that can ship to Japan for me. Work Details. You will need to access sites I indicate selling children's clothes, register on that site. After registration, please advise me of the ID and password. After that, you will be required to purchase the clothes I choose, and send them to Japan. The item costs and postage will be paid via PayPal. Remuneration From registration to delivery of the items to Japan USD20 From the second purchase...
I'm seeking a data entry professional for a long-term project. The specifics of the work will be discussed further, but the ideal candidate would be able to handle various types of data entry tasks with efficiency and attention to detail. Skills and experience that would be beneficial include: - Proficiency in Excel and other data management software - Prior experience in data entry - Excellent attention to detail - Ability to meet deadlines - Strong organizational skills Please note that specifics of the data and the source will be disclosed during the interview process.
...takeaways and compile a compelling article from the interviews. Ensure a professional and high-quality video interview experience. Requirements: Experience in journalism, content writing, or business interviews. Strong communication and interviewing skills. Ability to summarize and present insights in a clear, engaging manner. Professionalism and discretion in dealing with high-level executives. Access to high-quality video recording equipment for a professional interview setup. ...
I need an iPhone app that is designed for field work. This app will capture real-time data, including GPS and weather data. It will also allow for customized data entry via numerous drop-down choices and text fields. Key Features: - Real-time Data Capture: The app should be able to capture both GPS and weather data in real-time. - Customized Data Entry: The app should have numerous d...reports from app data - Experience with auto-fill functionality in apps Please provide examples of similar projects you have completed in the past. The app should have offline capabilities for data capture, allowing users to work without internet connectivity. The app should have a simple and functional user interface design. The app should sync data with cloud storage for backup and easy a...
...limits. Ensure security best practices, including token management and user data protection. Provide documentation for API implementation and app functionality. Technical Requirements: Frontend (User Interface) React Native (Preferred) or Flutter (Cross-platform mobile app development) UI frameworks: TailwindCSS, Material UI, or Shadcn/ui WebView integration for platforms with limited API access OAuth 2.0 authentication for secure logins Responsive and dynamic UI/UX implementation Backend (API & Server-Side Logic) Node.js with (Preferred) or Python Django/FastAPI MongoDB, PostgreSQL, or Firebase (for user data storage & token management) Secure API integration with YouTube, Reddit, Twitter, Facebook, Instagram Background cron jobs to periodically fetch new ...
I need a skilled video creator to pla...creator to plan, shoot, and edit 30 engaging Instagram reels each month. The primary goal of these reels is to enhance brand awareness. Key Responsibilities: - Collaborate with our team to conceptualize, plan, and execute 8-10 engaging content pieces per week. - Stay updated with the latest video editing trends and tools to enhance content quality. - Maintain and organize video files for easy access and future use. Ideal Skills: Proficiency in video recording and editing, with a strong portfolio showcasing past work. Must own an iPhone for video recording and editing. Creative eye for detail, storytelling, and visual aesthetics. Strong time management skills to meet tight deadlines. Ability to work both independently and collaboratively wit...
...marketing and content execution. Please ensure to track social media engagement as a key performance indicator. We are looking for candidates with mid-level experience. We are looking for entry-level candidates. The content should primarily be promotional. The company focuses on the technology sector. The primary goal for the digital marketing efforts is to increase brand awareness. Applicants should excel in content creation. Remote candidates are welcome to apply. educational products and services Expertise in social media management is highly preferred....
...streaming (all codecs) - multi gpu support - create/userpass for watch http stream/rtmp streams /lock to ip not able to view from other ips. - show current connected connections by username/connected channels/country flag - show users/ online/offline / disable users/ kick connection user (disconnect all connections)/ban user - create stream bouqets /categorys, add streams to categories, user limit access to wach selected stream categories. - advanced export playlists mutli option ( rtmp,rtsp,rtp,rtmpe, udp,http,mpegts,ts,hls,dash all protocols) - it should be used with nginx for serving streams. - stream checker auto restart stream after x seconds option if stream disconnect try reconnect, possible to add multiple stream sources (if first stream disconnects auto connect s...
...Features:** - **Real-Time Bus Tracking:** Display live locations of buses on a city map. - **Route Planning:** Allow users to input start and end points to receive optimal bus routes and schedules. - **Notifications:** Send alerts for bus arrivals, delays, and schedule changes. - **Offline Access:** Provide access to schedules and routes without an internet connection. Technical Requirements: - Platform: Android - Backend: Robust backend system to handle real-time data and user interactions. - Database: Efficient database management for schedules, routes, and user data. - APIs: Integration with existing transportation data APIs, if available. **Design Preferences:** - **User Interface:** Clean, intuitive, and accessible design tailored for a diverse user ...
Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.
I'm seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.
I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.
Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.
we need a skilled...reducing loading times. Technical Details: - Platform: The website is built on Squarespace CMS. - VPN Requirement: The developer must use a German VPN for access and testing to ensure localized performance. Deliverables: - A fully optimized Squarespace website - A brief report detailing the changes made and the resulting performance improvements. Deadline: The project must be completed within 24 hours. Preferred Candidate: - Proven experience in Squarespace performance optimization is essential. - Familiarity with tools for speed analysis and enhancement is a must. - Ability to work efficiently under tight deadlines is crucial. - Access to a German VPN or proficiency in using one is required. If you have the necessary expertise and can meet the deadli...
I'm looking for an experienced react native developer to create a simple UI call recording app for android. This app is intended for business use and should have the following features: - Automatic Call Recording: The app should automatically record all incoming and outgoing calls. - In-app Playback & Downloadable Files: Users should be able to access their recorded calls within the app itself, as well as have the option to download them for external use. Ideal skills for this project would include proficiency in Android app development, experience with call recording applications and a thorough understanding of user interface design to make in-app playback seamless. Goal of the app is to work on 90% of android devices with exception some exceptions. Over all app should...
...bot development. - In-depth knowledge and experience with the Binance API. - Ability to design a bot capable of managing automated trading. - Implementation of robust error handling and retry mechanisms. - Comprehensive logging of all trading activities for transparency and auditing. - Scalability to handle increased trading volumes efficiently in the future. The bot will require trade access to my Binance account. It does not need to implement any particular trading strategies; its sole purpose is to perform copy trading. The specific order types it should support have not been predetermined, so flexibility and adaptability are key. Ideal candidates for this project should have: - A solid history of developing successful trading bots. - Comprehensive understanding ...
I'm looking for a highly skilled tutor in Excel and KoboToolBox to teach me data collection/visualization/evaluation. Excel: - Help me improve my data analysis skills - Explain complex concepts in an easy-to-understand manner, provide practical examples, and guide me through various data analysis tasks KoboToolBox: - Creating surveys - Teach me how to collect, visualize, and evaluate data Ideal Candidate: - Strong background in data analysis, proficient in Excel, and highly experienced in using KoboToolBox for data collection. - Excellent teaching skills, patience, and the ability to adapt to my learning pace.
I'm looking to implement a day trading strategy using an automated trading setup in Excel with the Shoonya Finvasia broker. This setup will focus on trading options. Key Requirements: - The system must be capable of automated order execution. This is crucial as it will allow for timely responses to market movements. - The system should have a backtesting feature to test trading strategies on historical data. Ideal Skills and Experience: - Proficiency in Excel and experience with creating trading systems within it. - Familiarity with day trading strategies, specifically in options trading. - Understanding of automated order execution systems and their integration within Excel. - Prior experience with the Shoonya Finvasia broker would be a significant advantage. ...
I'm in need of an Excel Macro specialist who can assist in extracting tables from multiple PDF files into Excel. Budget - 20 Max Key Requirements: - Expertise in Excel Macro development - Experience in data extraction from PDF files, particularly tables - Ability to deliver a quick turnaround Ideal Skills: - Proficient in Excel and Excel Macro - Skilled in handling and processing PDF files - Fast and reliable with a strong attention to detail. Please note, the task involves multiple PDF files, so the ability to handle bulk data and automate the process efficiently is crucial. I look forward to your bid and your proposed timeline for completion.
My React-Native iOS app is hitting roadblocks during build creation. I'm looking for an experienced developer who can troubleshoot and resolve these issues. Key Issues: - The build is failing with configuration errors during final build packaging. - I also need help fixing the In-App-Purchase implementation. Ideal Skills: - Extensive experience with React-Nativ...In-App-Purchase implementation. - Ability to deliver quick turnaround on build fixes. Please provide examples of similar projects you've worked on. The project needs to be completed within 2 weeks. Please also help updating any outdated dependencies or libraries used in the app. Focus on debugging and resolving current issues with the In-App-Purchase implementation. Access to project files will be provided th...
...Centre), Cert Cognitive Behaviour Therapy (Cairn Millar Institute), Certificate IV in Assessment and Workplace Training (Centre for Adult Education) Rapid Transformational Therapist (Marisa Peer), Cert Animal Communication (Faye Rogers, NZ) Clinical Hypnotherapist. Number of courses offered: 6 name of the course and its url along with price and Duration and lecture count. save all this to text and excel file. Ideal skills for this project include: - Web scraping - Data extraction - Proficient in Python or similar programming languages - Familiarity with Udemy platform Please ensure the tool is efficient and can handle large amounts of data. The tool should automatically run on a schedule....
I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.
I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.
...browsing and purchasing habits. Key Features: - AI-driven personalized recommendations to enhance user experience and engagement. - Robust AI content moderation for images, text, and videos to ensure a safe and appropriate platform. - User interface targeted primarily at buyers, but with potential for seller access in the future. - Advanced search filters to refine user searches for better accuracy and satisfaction. - AI-powered chatbot assistance for instant customer support and query resolution. - Enhanced security features, including two-factor authentication and fraud detection, to protect users. - Automated price suggestions based on market trends and item condition to help sellers price their items competitively. - Mobile app integration to ensure a seamless experi...
I need a seasoned ethical hacker to assess vulnerabilities in my satellite and mobile networks. Key focus areas include: - Signal interception and jamming: Understanding the network's resilience against potential disruptions and unauthorized access attempts. - Data encryption and integrity: Evaluating the robustness of our encryption methods and the overall integrity of data transmission. - Access control and authentication: Checking the effectiveness of our current access control measures and authentication processes. - Firewall assessment: Analyzing the effectiveness of firewall rules and configurations in protecting the network. - Intrusion detection systems: Evaluating the performance and accuracy of intrusion detection systems within the network. Your exper...
...want to target specific job titles within various industries, focusing primarily on the technology sector. Target Job Titles: - CEO/Founder - Technology head - Instrumentation head - Quality head - Digitization manager - Methods and process excellence The primary focus of this project is on gathering phone numbers of these targeted users. However, the deliverable should also include a CSV or Excel file with validated data points such as names, job titles, company details, and contact information. Along with this, a brief report detailing the scraping methods used would be appreciated. Your proposal should include your budget and an estimated timeline for project completion. Essential skills include: - Proficiency with web scraping tools - Experience with LinkedIn and Crunchba...
I'm seeking an Excel expert proficient in creating complex formulas. The task involves working with financial data. The project is a test for a Financial Planning and Analysis (FP&A) profile, consisting of three questions. The formulas need to generate accurate financial projections.
...data untuk kebutuhan sales pipeline, segmentasi pasar, serta enrichment data ICP dan buying committee. 3. Membantu penyusunan laporan metrik kampanye, revenue, serta administrasi program awareness dan demand generation. 4. Kerja 4 Jam Sehari, Mulai dari jam 13.00-17.00 WIB secara online, wajib responsive Yang Saya cari: 1. Pengalaman dalam riset data, analisis, dan tools seperti Google Sheets/Excel. Familiar dengan teknologi CRM (LinkedIn, Salesforce, HubSpot, dll) jadi nilai plus. 2. Familiar dalam menggunakan tools dan teknologi seperti ChatGPT, Google Advance Search, Metabase, dan AI lainnya. 3. Detail-oriented, bisa kerja mandiri, dan mampu memenuhi tenggat waktu. 4. Kemampuan komunikasi baik, terutama dalam menyajikan data secara jelas dan terstruktur. Email to (Removed b...
I'm looking for an Excel specialist who can help me compare three files containing inventory data. Specifically, I need to identify quantity discrepancies and item mismatches. Key Responsibilities: - Compare data across three Excel files - Identify quantity discrepancies and item mismatches - Create a separate summary sheet highlighting these differences Ideal Skills: - Proficiency in Excel with extensive experience in data analysis - Detail-oriented with a knack for spotting discrepancies - Ability to organize data in a clear and concise manner
I need an Excel expert to design a spreadsheet for me that includes various charts and graphs for data visualization. The project specifically requires the creation of bar charts and pie charts. Ideal Skills: - Proficiency in Microsoft Excel - Experience in designing custom Excel spreadsheets - Ability to create clear, effective data visualizations Please note, the main purpose of the Excel file has not been defined yet, hence flexibility and adaptability will be key in this project.
...information could be useful for our customers who are purchasing eSIM cards for their travels. 4. Payment Gateway API: This API will ensure secure and smooth financial transactions by integrating with popular payment gateways. The APIs will need to interact with: - **Product Listings**: Keeping our product offerings fresh and relevant. - **Checkout Process**: Ensuring that our customers have access to the most accurate and up-to-date information at the point of purchase. - **User Dashboardand product delivery **: Personalizing the user experience and providing relevant data based on their purchase history and api to deliver product to customers. - **Live Travel Stats**: A section of our site will need to display live travel statistics using the Travel API. Ideal skills
...data to CSV/Excel for reporting purposes. See statistics about user sign-ups, including total users, active/inactive members, etc. 5. Data Security: All user data must be securely stored (preferably using encryption for sensitive data such as passwords). User passwords should be hashed and not stored in plaintext. Admin should have access to manage user data but should only view sensitive information when necessary. 6. Design & UX: Responsive Design: The website should be responsive and work well on both desktop and mobile devices. The user interface should be simple, clean, and intuitive for both users and administrators. 7. Tech Stack: Frontend: HTML, CSS, JavaScript (React, Angular, or Vue preferred) Backend: Node.js, Python (Django/Flask), or PHP (Laravel, CodeIgni...
I'm looking for a skilled Excel Macro specialist to automate the importing of data from PDF files into my Excel spreadsheet. Fixed Pay - $20 Key Responsibilities: - Create an Excel Macro to automate data entry from PDF files into Excel. Ideal Skills and Experience: - Proven experience with Excel Macros. - Proficiency in data manipulation and automation. - Familiarity with importing data from PDF files. - Excellent problem-solving skills.
Budget: $30.00 – 50.00 USD Bidding Ends in 7 Days Description: I’m in need of a seasoned DevOps professional to assist with setting up a DigitalOcean server for my web application. Key Responsibilities: 1. Server Setup: Configure a new DigitalOcean server, deploy the application code and database backups, while Dockerizing the application. 2. Integration: Fix the web server to eliminate 502 errors, ensuring seamless interaction with Cloudflare (already configured). 3. Security: Eliminate unauthorized access, fortify the server’s security, and set up necessary backups and monitoring systems. The ideal candidate for this job should have: • Extensive experience with DigitalOcean and Docker. • Proficiency in server management and security. &bu...
...Use drone footage (provided) of the RV storage yard. Integrate stock video (provided or sourced by you, if needed). Blend miscellaneous footage (may include interior/exterior shots). Text Overlays & Graphics Add clean, bold text animations to highlight key selling points: "Secure. Convenient. Reliable." "Spacious RV & Self-Storage Solutions" "24/7 Monitored Security" "Easy Online Registration & Access" "Ideal for RVs, Boats & Equipment Storage" Incorporate Super Center Storage’s branding elements (logo, colors, fonts). Pacing & Transitions Keep it smooth, engaging, and professional. Well-paced edits that maintain attention but don’t feel rushed. Loop seamlessly for continuous playback at the trade...
Do you have an IMDb ( movie database ) Pro account and can you fix my account? Then it’s your job. I need there my Profi Picture.
I'm seeking a professional website and mobile application developer to create a platform for Homestay hosts and prospective guests. Key Features: - Monthly subscription model for users, allowing access to respond to inquiries only if they're subscribed. - Creation of host-specific profiles with detailed information about the property, the host's biography and the booking availability. - An intuitive, user-friendly interface for both hosts and the eventual guest user. - Implementation of a review system for hosts and guests to rate their experience. - Integration with a secure payment gateway for subscription fees and bookings. - Advanced search filters to help guests find properties that match their criteria. - Capacity for hosts to upload and manage a photo gallery ...
I'm seeking a proficient developer to create an AI agent for me. The agent's primary function will be to locate fitness-related businesses in multiple specific regions. The collected data will need to be organized into an Excel table, including details such as: - Name and website of the business - Location and contact details - Person name and job title An example of the task would be finding all personal trainers in Redcliffe, Australia, Postcode 4020. Ideal Skills and Experience: - AI and machine learning development - Data mining and web scraping - Proficient in Excel and data organization - Understanding of fitness industry would be a plus
I'm looking for someone to help me create a financial model in Excel focused on budgeting. The primary task will be filling in the blanks with the appropriate formulas. Ideal Skills: - Proficient in Excel - Experience in financial modeling - Knowledgeable in budgeting processes Please ensure your proposal highlights relevant experience and skills.
...company logo which i would like on the page somewhere. also i would like the following writing on it. Hunter Valley Care & Assistance Our Mission: To provide exceptional support and care, helping individuals achieve their goals and maintain independence with a positive attitude. Services Offered - Support Work: Personalized assistance tailored to individual needs. - Participation in Community Access: Encouraging community involvement and engagement. - Personal Care: Compassionate care focusing on personal well-being. - Community Nursing Care: Professional nursing services for comprehensive health support. - Household Tasks: Including cleaning, housekeeping, and yard maintenance. Our Approach - Holistic Support: Working closely with both young and older participants. - Mento...
I'm seeking an experienced network engineer to assist with configuring NAT on a Cisco router. The primary goal is to enable internal devices to access the internet after NAT translations. Key Tasks: - Implementing PAT (Port Address Translation) on the router - Providing guidance on whether specific ports need translation or if all ports should be translated - Troubleshooting any issues that arise during the configuration process Ideal Skills: - Extensive experience with Cisco routers - Strong understanding of NAT and PAT - Ability to explain technical concepts in simple terms - Networking certification (CCNA, CCNP, etc.) would be a plus.
I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .
I need an experienced developer to set up a comprehensive, secure sign up and login system for my CRM. The system should include: - Authentication through email and password, social media logins (Google, Facebook, LinkedIn) and Two-Factor Authentication for heightened security. - A user role management system with different roles and permissions, enhancing access control and data security. Ideal candidates for this project should have extensive experience with CRM systems, user authentication, and role management. Proficiency in integrating third-party services is crucial, as well as a deep understanding of security protocols to implement Two-Factor Authentication effectively. This project is not just about setting up a login system; it’s about creating a robust, secure, a...
My vending machine business in Newcastle NSW Australia needs an expansion. Currently, I have 2 machines in industrial buildings with around 30 employees in Thornton. I'm looking for more similar sites, ideally within a 20 km radius of my existing machines. Criteria for new locations: - Open 24 hours or at least until 9-10pm - Housing 30+ employees - Relatively easy access to the site - Primarily manufacturing facilities Key Features: - High foot traffic - Extended operating hours Ideal Skills: - Location scouting - Understanding of vending machine business - Knowledge of local industrial areas Experience: Previous work in site scouting for vending machines or similar businesses would be highly advantageous. Please only apply if you have a good understanding of the criter...
