The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
...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...
1st. we need space for upload K-Contents(Korean TV show, pop and etc), 2nd. We need space for many amateurs from various culture fields can sign up to upload and evaluate their work. 3rd. We need ads likes Google Ad-Sense. It can be posted for their work, and this is how we and that amateurs shar...various culture fields can sign up to upload and evaluate their work. 3rd. We need ads likes Google Ad-Sense. It can be posted for their work, and this is how we and that amateurs share profits. 4nd. We need a global community board. Global community board must be translated into English, Japanese, Chinese, Korean, French, German, Turkish, Portuguese, and Russian. Each translation shall be automatically translated according to the language set by each user. P.S. We will provide desi...
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
I urgently need a skilled developer who is proficient in and Prisma for my website's development. The site will not only require user registration and login functionality but also a search function. Furthermore, the site must include the creation of forms for project tracking and form filling. Key features will include: - Simple input fields. - File upload capabilities. - Dropdown menus for easy option selection. - PDF generation from form data. Your proficiency in similar projects and strong understanding of these technologies will be a crucial contribution to the project. The completion deadline is urgent, so exceptional project management skills are required.
I'm looking for a skilled professional to help with organizing my personal finances for the past year. Key Requirement...Spreadsheet records for data classification Additional Details: - I'm interested in obtaining both monthly summaries and a comprehensive yearly report summarizing my financial activities for the past year. Ideal Skillset: - Proficiency in financial analysis and classification - Experience in personal finance management - Ability to work with large data sets - Strong spreadsheet skills, particularly in Excel - Ability to provide detailed and organized reports I'm aiming for a freelancer who can provide me with a clear and insightful overview of my spending and income patterns over the past year, and who can deliver this information in a timely...
I need an expert in CURL scripting who can help me retrieve specific account information from the Schwab API. The project is on an ASAP timeline and involves accessing the API endpoints for Account Information and Transaction History. I'm mostly stuck on automatically retrieving and maintaining authentication keys
I'm in need of a skilled developer to create a web-based accounting app mimicking functionalities of excel for my business. Key Features: - Accounting functionality: This app must allow me to insert product details and their price, record the amount they were sold for, and at each day's end, it must generate a profit and loss table. - Inventory tracking: The application should effectively manage my inventory, keeping a track of products, their quantities, and changes over time. - Customer Database: The app should store customer information in an organized and easily accessible manner. - Invoice Generation: It should also have the capability to generate invoices for customers. Design Aesthetics: The preferred design is minimalistic. It must be clean, clear and use...
...professional to develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. ...
I'm in need of a database designed to organaize companies for Italian regions the data are not well organized, there are 927 companies with different address and region and they need to be divided by north west, north , north east etc - - Customer Information Management: The database should be structured in such a way that it allows categorizing companies according to their respective regions. Ideal freelancers for this job should possess robust skills in database design and management. A keen understanding of categorizing/mapping data based on geographical regions will be considered a huge advantage. Efficient, accurate, and secure data manipulation and storage is essential for this project.
J'ai un travail en continu concernant notre projet précédent ' connect a database and form'
J'ai un travail en continu concernant notre projet précédent ' connect a database and form'
I'm seeking a professional with exceptional data management and customer after-sales support skills. The selected candidate will be expected to perform the following... Data Entry Tasks: - Data cleaning and organization. - Creating and managing spreadsheets. - Conducting data verification and quality control on all data sets. After-Sales Support: - Managing product troubleshooting. - Overseeing and tracking customer orders. - Handling customer returns and exchanges. Tools Utilized: - Excel for data handling. - Communication via WhatsApp and Facebook for customer support services. The ideal candidate should be proficient in Excel and comfortable using social media platforms such as WhatsApp and Facebook. Previous experience in data entry and customer support roles a...
I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA scripts...
...skilled web developer who can help me make several improvements on my website. - Address Design/Layout Issues: I need the homepage to be redesigned. I have an alternative template in mind, and I'd like you to switch to this new layout. - Implement Stripe Payment Split: I need a feature where payments made on the website are automatically divided between the admin and the service providers. This feature should also generate reports. - Duration and Blocking Times: I want to add a feature that allows me to assign a duration to all categories and block times as per the set duration. - Front-end Control: You will be required to provide full front-end control for elements like the menu bar, footer, banner, etc. - Pujari Registration: I need a front-end feature that enables...
We are currently looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn job posting. While the tasks themselves are relatively straightforward, it is important to note that this will be ongoing, daily work for the foreseeable future. If you have a proven track record of delivering high-quality work, and maintaining consistent performance, we encourage you to apply. Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheets. - Demonstrated reliability and consistency in previou...
As discussed I have delivered the excel workbook. Thanks!
I am in need of an individual to help me gather information from residential properties in a specific location on a popular property portal. The desired information includes the property description, price, number of bedrooms, bathrooms, images, videos (if available), floorplans (if available), and location. This data should be compiled and organized into a spreadsheet for easier analysis...ensure the project's success Please note that the accuracy and completeness of the extracted data are of utmost importance. The successful freelancer will help me in making informed decisions regarding property investments in the specified location. Thank you. To ensure you have read this description fully, please start your bid with the words Willy Wonka, otherwise your bid will be deleted au...
...the password for an Excel Workbook. It was prepared by an employee who has since left the firm. Note that I am not seeking to have someone recreate this Workbook without the password, but to have the password itself. There are several videos on YouTube about this, but I've had no luck: I've attached the spreadsheet if you want to try. The first person to provide the password will get paid. Just let me know if have it, I'll hire you, and you supply it. PLEASE DO NOT ACCEPT THE PROJECT UNLESS YOU HAVE THE PASSWORD FROM THE ATTACHED SHEET. Key Project Requirements: - Password Recovery: The primary task is to recover the password for an Excel Workbook. Ideal Skills and Experience: - Expertise in Excel Password Recovery - Flexibility
I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generation - Strong communication skills and a good understanding of client nee...
...wish list feature involves setting up a wishlist system, configuring Shopify's product management system, and custom coding for seamless integration. Comprehensive Product Customiser with Dynamic Pricing: Technical Details: Develop a comprehensive product customiser that includes options for adding a gift box and personalisation on the back of the product. When selected, these options should automatically update the total price. Additionally, consider a feature for building custom gift boxes with dynamic pricing updates. Email Marketing Automation and Personalization: Technical Details: Integrate a system for personalising emails based on customer data, such as birthdays, and use wishlist items to generate unique promotions. This involves setting up advanced segmentation a...
I'm looking for a versatile Excel professional. Key Requirements: - Restrict Sheet Access and Hide for specific users - Changes made in the master sheet should be automatically displayed on specific sheet. - When a change is made on the master sheet, the cell should automatically be highlighted in red color. and also reflected in the specific sheet. I am looking for a good english professional . Automatic bidders will be blocked . If you are here type in salut at your beggining of the bid.
...who can integrate a cloud-based database into my project. Ideal Skills: - Strong proficiency in Java - Prior experience with database integration - Specifically, experience with cloud-based databases, Microsoft Azure in particular, is a big plus The Project: - Your primary task will be to integrate Microsoft Azure, a cloud-based database, into an existing Java project. - The project already has a well-defined structure and the database will serve as a key component. - The database integration should be secure, efficient, and scalable, meeting the highest standards. - There will be no need for user authentication or API integration, as this project is solely focused on database integration. Please only apply if you have good experience with...
I'm looking for an experienced freelancer capable of developing 2 AI filters for Instagram which automatically detect the user's face and apply makeup effects. One filter will focus on eyeliner, while the other on lipstick. Key Requirements: - Development of 2 AI filters for Instagram - Automatic face detection for makeup effect application - One style only for each filter (eyeliner and lipstick) Ideal Skills and Experience: - Prior experience in developing AI filters for Instagram is highly preferred - Strong understanding of image processing and face detection algorithms - Proficiency in designing and implementing makeup effects - Aesthetic sense to ensure the filters meet industry standards
As an online publisher, I am looking for a unique WordPress plugin development that will create and manage a comprehensive glossary, aiding in the improvement of site's SEO. Here's what I need: - A glossary plugin designed primarily to enhance the SEO of search terms. - Once glossary terms are defined, this plugin should be able to creatively use these terms to automatically create multiple posts. - To add an innovative and dynamic edge, I'd like these posts to be generated using a GPT-4 language model. - These generated posts will be interlinked, hence when a user clicks a term in the glossary, they get redirected to the respective post. Ideal candidates for this project should have: - Expertise in WordPress plugin development - Understanding of SEO princi...
I'm looking for a skilled developer to create a custom solution for me. I want to automatically publish my RSS feed on a range of social media platforms. Specifically, I'd like the content to be shared on Facebook, Twitter, LinkedIn, Pinterest, and Instagram. - The content should be posted daily on these platforms. - The system should be automated and require minimal maintenance. - The solution should be reliable and robust. I'd prefer if you have a good understanding of social media APIs, RSS feeds, and have experience with similar custom development projects. Your proposal should include details of how you would approach this task, your relevant experience and any similar projects you've worked on in the past.
Tengo un software de facturación al que se le pueden importar facturas en lote subiendo un Excel con un formato concreto de filas y columnas para que sea capaz de reconocerlo y generar las facturas de forma correcta. Necesito poder hacer esto de forma automática, es decir, teniendo un archivo de origen xls en un formato, poder extraer los datos para montar otro archivo xls con el formato que necesita el software de facturación para leerlo correctamente.
...Metadata below 2, Each of the sectors will have 1 or more than 1 sector responders 3, KMS admin can upload the document, but the status is Draft. 4, KMS admin needs to assign at least the sector and document type of the uploaded document. then will request approval from the sector responders. once the document is approved, the status will change to Approved, Then the document number will be automatically generated, and the review date will for 2 years after the document is approved. 5, In any document library users can post by a power automate script (a form that at least has "the sector" and "document type") their document or PDF to KMS, then the file will be copied to KMS as a Draft, then an email approval will be sent Sector responder 6, KMS admin can tri...
We are an Ecommerce company dealing with variety products and we are looking for a...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...
...in payment gateway integrations. - Prior experience in designing registration forms. I need help with the following things I need assistance with setting up four events and integrating them into the form flow. Here’s the detailed process: 1. Event Creation: Create four distinct events. 2. Event Selection: Allow users to select one of the four events within the form. 3. Event Confirmation: Automatically save the selected event and display it on the next page of the form. Users can then fill in additional required details. 4. Details Review: On the subsequent page, users should be able to review all the details they have entered. 5. Payment Integration: Finally, guide the users to a payment gateway integration page where they can complete their purchase to enroll in the se...
I'm requiring a proficient Java developer for a college project. The main task will be building a web application along with database integration. I'll need you to implement vital functionalities, such as: - A user registration panel - A user login page - Fee structure - Contact us section - Admin as well as user registration option - Subjects and courses - Basic website navigation functions For the front end, HTML and CSS skills are necessary to render a clean and minimalist design. It's vital you're experienced in these domains and can provide examples of your past work. Looking forward to your proposals.
Need to develop a script or program that automates the process of updating the Microsoft Edge WebDriver. The program will perform the following tasks automatically on a daily basis (time and date can be controlled): It should be delivered as an executable(.exe) file that can be installed on multiple computers. There should be an on/off option: 1. Check Current Microsoft Edge Version: • The program will first determine the current version of Microsoft Edge installed on the user's system. 2. Download Correct Version of Microsoft Edge WebDriver to match with Microsoft Edge version: 3. Extract WebDriver and Rename: • Once the WebDriver is downloaded, the program will extract the msedgedriver file from the downloaded ZIP archive. • It will then rename the extracted...
...experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the project is intermediate, focusing on tasks like joins and subqueries. Ideal candidates will have: - Extensive experience with MySQL databases - Strong SQL querying, schema design and query optimization skills - Proficiency in working with relational databases - Expe...
...envisioned app should ultimately facilitate smooth online transactions, assuring users of their data security. This project may require further maintenance and updates, thus a long-term professional relationship is considered beneficial. A simple description of the app is to introduce lettre in form of text or imported letter to a maximum 2 A4 letter format. This will include an address , from adress to. No adress verification is needed. A selection of a country, and a post code. A price will be generated according to the country. A letter preview will be viewable , on the acceptation, ot will triger a payment , then a secured email sent to a hiden email address. A user interface will be available to view the historical, with a email verification module....
As someone in need of a specific tool, I'm seeking a proficient Python programmer to create a desktop tool for auto cropping bulk TIFF scanned images. The key features I'm requiring are: - Auto Cropping: The tool should be capable of automatically cropping large amounts of TIFF images, simplifying the process and saving time. - Image Quality Adjustment: After auto cropping the images, I should be able to adjust their quality within the same tool. - Maintain TIFF Format: The cropped and quality-adjusted images should remain in TIFF format. A freelancer with great proficiency in Python and past experience in image processing software or similar would be ideal for this project. Understanding of image formats, specifically TIFF, and quality adjustment is essential.
I am in need of a one-time service to clean out my email database of invalid email addresses that generates too much soft bounce and hard bounce (and spam trap emails). Key Points: - **Objective**: The main goal of this project is to remove outdated or incorrect email addresses from the email database. - **Frequency**: This is a one-time project, not requiring ongoing maintenance. - **Current Platform**: I use Brevo as my email platform Ideal Freelancer Skills: - Experience with email marketing and database management - Familiarity with Brevo or similar email platforms - Proficient in identifying and removing invalid email addresses - Proven track record of improving email deliverability and marketing campaign results. I supply email addresses in CSV or XLS files
...specializes in web scraping to gather and compare rental prices from leading car rental websites like DiscoverCars, AutoEurope, DoYouSpain, and others. The name of the app is PriceBook Key Features: Real-time Data Collection: Our software continuously scrapes data from various car rental websites, ensuring that users have access to the most up-to-date pricing information. Price Comparison: The app automatically compares rental prices from multiple providers, highlighting the best deals and most favorable rental conditions. Customization: Users can tailor their search based on specific criteria such as location, rental period, and vehicle type, providing a personalized search experience. User-Friendly Interface: The app features an intuitive and easy-to-use interface, making i...
You need to build a power app for a business process of onboarding, offboarding customers. There is a database of the customers with specific users db that has access and approve a checklist. We need it on a sharepoint portal and emails are automated for every action. It is a simple process of adding a user, give them a checklist, customer completes all actions, there is an internal admin who confirms the checklist and there is a progress to track. Will provide a dummy of excel sheet, expect 3-5 screens across onboarding, offboarding, admin and customer login. Ideal Skills: - Proficiency in Power Apps, Microsoft Power Automate. - Expereince in MS dataverse, power platform - Ability to grasp business processes and convert them into efficient digital solutions.
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.
We are seeking a Business Data Analyst for our team who is willing to work with... Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Required skills: - Strong analytical and problem-solving skills - Proficiency in data analysis tools such as Excel, SQL, or Python - Experience with data visualization tools such as Tableau or Power BI - Excellent communication and presentation skills This is a great opportunity for individuals who are new to the field of business data analysis and are looking to gain practical experience in a supportive en...
...rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Fast - Critical Thinker - Proficiency in using Instagram for business research - Experience in lead generation - Bonus: Familiar with the nightlife industry...
...proficient Excel expert to build a multifunctional sales proposal tool. The core functions include: - Entering Data: The tool should accommodate efficient and easy data entry from multiple source files. If this can be automated that would be preferable. - Sales Calculations: The tool must have the ability to perform various sales calculations and convert source files from multiple currencies to GBP - Templates: I require outputs to integrate into existing Excel templates for generating client proposals, producing invoices, and confirming projects. - Automation: Desired features include automatic data sorting and automated calculations to streamline and simplify tasks. - I have example files I can share which can form basis of design. Ideal candidates will have experienc...
...with the PBX and enable the functionality to automatically answer calls so that they are recorded by Milestone. Project Scope Development of the SIP Client: Implement a SIP client that can be integrated as a plugin into the Milestone software using the provided SDK. Ensure the compatibility of the SIP client with current and future versions of the Milestone software. SIP Client Configuration: Add a user interface in Milestone to configure the SIP client. Configuration parameters should include: SIP server address. Connection port. Username. Password. Additional options such as preferred audio codec and NAT options. Call Automation: Implement the functionality to automatically answer calls. Ensure that when the call is answered, it is automatically recorde...
Hello! I need to build a module or functionality to the ServiceGo - Multi Vendor On-Demand Service & Handyman Booking Marketplace system for vendors. The module (functionality) should be the following, subscription model for vendors. In this subscription model, there should be a limit on how many listings (job services) a given vendor can publish and how many customers it can respond to. P.S. The above mentioned functionality is important to us, but even if you can't offer us such a solution we are also looking for the functionality of only registering as a vendor to pay a fee again, which should be per subscription. Link to the system:
I'm seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to work with complex data sets. The project will require attention to detail and a high level of accuracy. If you have the r...
I need to extract text and tables from a series of PDFs and convert them into an Excel file. The main requirements for this project include: - Extracting text: The texts from the PDF files need to be carefully extracted and placed into the corresponding cells in the Excel sheet. - Tables: There are some tables within the PDFs that need to be accurately reproduced in Excel. The Excel file must preserve the original formatting of the text and tables, so as to maintain the integrity of the data. The PDFs are only in English, so no complex multilingual extraction is required. Ideal Skills: - Proficiency in PDF to Excel conversion - Strong attention to detail - Ability to preserve original formatting in Excel - Excellent English language understa...
Rework an existing logo and make it 3d for presentation
I'm in need of a skilled professional who can help me generate leads. Unfort...some important details in the initial questions. - I'm open to both B2B and B2C leads, so I need someone who can handle both categories effectively. - The industry I target is quite broad, including but not limited to Technology, Healthcare, and Real Estate. Hence, I need a freelancer who is experienced in lead generation across various sectors. - Lastly, the leads should be provided in an Excel spreadsheet. This is crucial for my further processing and follow-up. Your previous experience in generating and categorizing quality leads across different industries will be a huge advantage. Proficiency in understanding both B2B and B2C lead generation methodologies is also important. Looking f...
