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...
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
...Technologies)는 비트코인 하드웨어를 제작하며 이를 바탕으로 글로벌 금융 시장에 진출하려는 신생 기술 기업입니다. 이번 프로젝트는 엡실론의 로고를 디자인하고 웹 사이트를 디자인, 개설하는 프로젝트입니다. 총체적인 브랜드의 이미지를 고려하여 심플하고 아름다운 로고와 이를 바탕으로 한 효과적인 반응형 웹사이트를 개설하는 것이 주요 업무입니다. 웹 사이트가 신생기업의 야망(?)과 신 기술을 선도한다는 미래 지향적인 이미지를 심어줄 수 있으면 좋겠습니다. 웹사이트에 들어갈 내용은 그다지 많지 않기 때문에 아마 디자인 측면이 상당히 중요할 것으로 생각됩니다. Epsilon Technologies is a bitcoin technology company (hardware manufacturing, in particular) based in Seoul, Korea, aspiring to be a global leader in future finance industry. This project will be to design a brand logo and design and build a website. The purpose of the website is mainly for informative purposes(what technologies we have and our vision, blog posts, etc.). We would like to have a clear, simple design and website should be intutitive and very easy-to-us...
I'm in need of a talented developer to create a robust and user-friendly ERP system tailored for my school. The...generate student report cards efficiently. - **Parent Communication Portal**: A secure platform through which parents can access important information about their children's academic performance and school activities. This portal should also facilitate two-way communication between parents and teachers. Ideal Skills and Experience: - Proficiency in developing comprehensive ERP systems, with a particular focus on school management. - Experience in integrating and implementing the specified features, particularly student attendance tracking, gradebook generation, and parent communication portals. - Ability to deliver a scalable system capable of handling a large...
I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.
I'm looking for a skilled analyst to examine and arrange a substantial set of numerical data using Excel. The primary purpose of this project is to facilitate thorough data analysis. However, the data's arrangement or layout has yet to be defined, and I'm open to suggestions from the freelancer on how best to structure the data for optimal analysis. Ideal Skillset: - Strong background in data analysis and numerical data - Proficient in Excel, including its advanced functions - Ability to suggest and implement data arrangement strategies in Excel This project will require strict attention to detail and excellent organizational skills. So, if this project is up your alley, don't hesitate to bid.
I need assistance in a data entry project. The task involves inputting numerical and textual data from digital documents into an Excel sheet. Skills and Experience: - Proficient in Excel - Must have accurate and fast typing skills - Prior experience in data entry jobs This job requires the utmost precision and accuracy, as the entered data will be used for important business processes. A keen eye for detail and a high degree of data accuracy are important for this role. The successful candidate should have the ability to read, understand, and input data efficiently.
I'm currently looking to create a coworking platform for a brand named Soko. Despite skipping some prior questions, the direction for this project hasn't changed. What I'm looking for is: - A smart, flexible coworking platform: It should be capable of managing various functionalities. Though I haven't specified particular ones, functionalities such as booking and reservation systems, member directory, and a feature to show the space availability status can be considered. - Applicants: While I miss mentioning the specific application requirements, I do expect applicants to have substantial knowledge in creating similar platforms. Having a portfolio that showcases your past work, an overview of your experience, and a detailed project proposal would potentially pla...
I need some help with ...need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the lines on the Stock ...
We're in need of an experienced Data Science Engineer. The ideal candidate should have a strong background in data science, machine learning, and data analysis. Key responsibilities: - Data cleaning: The candidate should be able to clean and preprocess large datasets. - Data analysis: The candidate should be proficient in analyzing data and extracting actionable insights. - Machine learning modeling: The candidate should have experience in building and implementing machine learning models. Although specific programming language requirements were not provided, proficiency in Python, R, or Java would be a strong advantage. This project does not specify a particular industry domain, but any prior experience in Healthcare, Finance, or R...
I'm seeking an experienced modder to create a comprehensive Minecraft mod encompassing custom creatures, weapons, tools, and world generation. The key features include: 1. **New Creatures**: Mythical, Jurassic, and Alien creatures, with emphasis on mythical creatures. Particular mythical creatures include Dragons, Unicorns, Phoenixes, and even more such as Minotaurs, Gryphons, Hydras, Krakens, and many more from global folklore. A feature to turn creatures on and off is required. 2. **Custom Weapons and Tools**: Ranging from unique swords, bows, wands to hammers and more. Exceptional equipment from fiery axes, and immortal gems, to celestial bows are some of the expected creations. 3. **Improved World Generation**: I envisage unique dimensions including The Ethereal Realm, T...
See...programmer adept in WordPress for custom coding work and form layout adjustments. Requires proficiency in backend management, specifically relating to data capture, viewing, and exporting in Excel format. A highlight of the project entails the customization of our existing WordPress theme and the integration of new, unspecified features. Lack of detailed request emphasizes the need for a freelancer capable of intuitive problem solving. Primary tasks include: - WordPress custom coding - PDF form adjustments - Data capture and export to Excel Ideal candidate should have knowledge and experience in custom coding, WordPress navigation, and form data handling. Exceptional problem-solving skills are highly appreciated. Undefined project elements call fo...
I'm urgently requiring a resourceful developer to create a tailor-made HR dashboard for our company. The developer should ideally have extensive experience in HR dashboard creati...prominently feature recruitment metrics and performance evaluations. Recruitment Metrics Include: - Time-to-hire - Cost-per-hire Performance Evaluations Indicators: - Retention rate The dashboard should present these metrics in a clear, accessible format, preferably utilizing visually-pleasing graphs and charts. To excel at this project, the developer should have significant experience working on similar projects, a keen eye for design, and a knack for turning complex data into easy-to-understand visuals. A truly comprehensive understanding of HR metrics and how to effectively display them...
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.
I am seeking a detail-oriented freelancer who can expertly transfer text data from PDF files into a database. The ideal candidate should possess the following skills and experience: - Proficiency in working with PDF files - Expertise in data entry tasks - Experience in formatting and structuring databases - Excellent attention to detail Suitable candidates need to handle copious amounts of text data, accurately convert the text-containing PDF files into a structured and organized database. This includes careful validation to ensure no data is lost or misrepresented during the data entry process.
Hi Ashish, this is for the tasks I emailed about.
Looking for someone to gather public email address of recruiters in Linkedin/Indeed/Glassdoor. Need to find the name of the recruiter, company name and their valid email address. Key Responsibilities: - Need to be Linkedin Sales Navigator Please note, strict confidentiality of all personal information provided is imperative.
I'm looking for a detail-oriented freelancer to help me with an Excel data entry project. The task primarily involves typing text from scanned documents into my Excel sheet. **Key Requirements:** - Accurate typing of text from scanned documents into Excel - Organizing the data into tables and lists **Skills Needed:** - Proficient in Microsoft Excel - Attention to detail to ensure accuracy - Experience in data entry, ideally with scanned documents - Ability to organize data into tables and lists The ideal candidate should be comfortable working with scanned documents, have a knack for accuracy and attention to detail in typing, and be able to organize the data effectively into tables and lists in Excel.
I'm in need of an expert who ...develop a risk assessment model for Cmbs SASB. The main goal of this project is to identify and analyze risks associated with my investments. Key Project Details: - The primary focus will be creating a risk model for Cmbs SASB. - I will provide third-party analytics data which you will need to integrate into the model. - The development and implementation of this model will be done using Excel. Ideal Candidate: - Prior experience in financial risk assessment, ideally involving Cmbs SASB. - Proficiency in Excel is a must, as this will be the main tool for developing the model. Please provide any relevant past work or experience that you think aligns well with this project. We can discuss further details and expectatio...
I have a set of printed documents that need to be transcribed into an Excel sheet for easy access and analysis. The data is primarily textual, composed of various types of written information. Requirements: - Expertise in data entry, particularly with Excel. - Proficient in English to accurately interpret the text. - Experience with printed document transcription is preferred, but not required. The ideal candidate must be detail-oriented and meticulous, as the accuracy of the data entry is crucial.
I have a project which involves transferring text data from PDF documents into an Excel sheet. The data is purely text-based and will need to be accurately inputted. The ideal freelancer for this project would: - Have experience with Excel data entries, especially involving text - Be proficient in working with PDF documents - Have previous experience in data import from different formats Your job will largely involve: - Importing data from PDF files into Excel accurately - Ensuring correct data input without losing any details - Maintaining the original structure and formatting wherever necessary Please ensure the completion of this project in a timely and precise manner.
I'm searching for a detail-oriented freelancer with extensive experience working with Excel. - This task involves typing text data into an Excel spreadsheet. - The data entered will be a mixture of both structured and random entries. Thus, a keen eye for detail and the ability to maintain organization amidst complexity is key. - As a crucial aspect of this project, I require error checking to ensure the highest quality of work. The ideal candidate should have experience and knowledge in Excel data validation. - For successful completion of this project, accuracy and attention to detail are paramount. Candidates with previous background in similar tasks will be highly regarded.
We have a website where the homepage currently loads slowly due to multiple API calls. Despite implementing asynchronous API calls, the page load time is still not meeting our target. We are looking for a skilled developer to optimize the homepage to load within 1 second. we need some one who can : ...currently loads slowly due to multiple API calls. Despite implementing asynchronous API calls, the page load time is still not meeting our target. We are looking for a skilled developer to optimize the homepage to load within 1 second. we need some one who can : Optimized homepage that loads within 1 second. Cron job implementation for fetching and updating api data of tokens price/5%/24%//etc basically - i want to load data everything from DB only , rather than multiple ...
I am looking for...Oracle DBA with experience in both Oracle RAC (Real Application Clusters) and standalone Oracle databases. The primary goal of this project is performance tuning. Ideal Skills and Experience: - Proven experience with Oracle RAC - Proven experience with standalone Oracle databases - Specialization in performance tuning - Familiarity with Oracle Database 19c Key Responsibilities: - Implementing performance tuning strategies - Monitoring and optimizing database performance - Troubleshooting issues related to performance - Ensuring the smooth operation of both RAC and standalone Oracle databases The ideal candidate should have a deep understanding of Oracle databases and be able to provide tailored solutions for enhancing performance on both Oracle RAC and s...
I require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.
...skilled developer who can build a customized matchmaking database for my internal use. The database will primarily focus on matching investors to investment opportunities. Key Features: - Storing Match Preferences: The database should be able to store various match preferences including minimum/maximum investment, minimum/maximum funding amount, geographical preference, and the type of funding. - User Authentication: As this database will be for internal use only, the user authentication should be secure and limited to specific staff members. No external user authentication is required. - Search Criteria: The database should have search functionality based on the geographic location. Ideal Skills: - Proficiency in database...
I have an unfinished Flutter app that requires a skilled individual to handle its database connection. The app is designed and now, I need help connecting it to a MySQL database using an API. Key Responsibilities: - Complete the database connection for my Flutter app - Utilize MySQL to store the following data types: user profiles and authentication, transactional records, content and multimedia files Ideal candidate: - Proficient in Flutter and experienced in developing Flutter apps - Skilled in MySQL and API integration - Familiar with handling user data and transaction records securely - Strong background in data storage and retrieval for content and multimedia files This project is not for a business, but rather a personal venture. Your exp...
Pl...your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel or images (provided twice by us)has got duplicates 4) If the images are not clear as per the 900 X 700... YOU shall consider the image from the website. we will share you the link for your understanding if you requir...
I have a specific vision for a residential pool that needs an experienced pool engineer to bring to life. - The pool should have a custom shape, not the typical rectangular or freeform. The specific design will be discussed more in-depth once the project commences. - The pool should include particular features I desire such as pool lighting and a sun ledge. Ideally, the freelancer should have vast experience in designing and engineering residential swimming pools, specifically those of custom shapes. A strong understanding of pool lighting and sun ledge installation is also necessary for this project. Together, let's make this vision a reality.
I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.
I urgently require a capable designer to create a...urgently require a capable designer to create an engaging and appealing logo for our homeschool cooperative, known as the Homeschool Education and Learning Program (HELP). We strongly believe in the motto "It takes a village", emphasizing on collaboration between families, kids, and their tutor to create the best learning environment. We are a Tk-12 program. While I have not explicitly specified a particular feeling or color scheme for the logo, I'm certainly open to your creative interpretations. The ideal logo is: - unique and original - on brand with our ideology integrated into design - creative and imaginative, reflecting family, education, and cooperation - NO graduation hats please I look forward to seeing...
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good ...
I am in search of German writers for my health and wellness content. Your primary responsibilities will involve article writing and copywriting, with a focus on the nutrition subcategory. Key Responsibilities: - Writing articles that are engaging and informative, focusing on the health and wellness industry - Creating compelling copy for our health and wellness materials, specifically related to nutrition Ideal Candidate: - Native German speaker with exceptional writing skills in German - Previous experience in article writing and copywriting - A strong understanding of the health and wellness industry, with a particular focus on nutrition - Ability to create original, well-researched and high-quality content - Excellent communication skills and attention to detail If you&...
I'm seeking a proficient individual for constructing an Access database for my project. The principal requirements include: - Experience with Access, as that's the selected database management system. - Expertise in data storage and retrieval is essential. - The database will be storing textual and numerical data. Experience in handling these types of data is crucial. Ideal skills would include an in-depth understanding of Access, database design, data storage/retrieval techniques and knowledge in handling both textual and numerical data. This should make for a streamlined and efficient process. I'm excited for us to kickstart this project together!
...Google like "Plumbers Minneapolis, Minnesota" or "Carpenters Charlotte, North Carolina." Then I will run the script(s) you created for me. The script(s) you create will save the Google search results in a .csv file. That is trivial and straightforward. The script(s) will also open the websites associated with the search results. That is also trivial and straightforward. The main challenge lies in locating and filling out contact forms on these websites with my first name, last name, email address, phone number, etc. Most search results will include a link to the company’s website. For example, when I search on Google for… Jake The Plumber Minneapolis, MN … I see a link to Jake The Plumber’s website. Your scr...
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Le...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ...Comprehensive knowledge of research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Exce...
I'm in need of a comprehensive business plan that would help me secure a dealership allocation for Sea-Doo and all BRP models for ATV/UTV/Watercrafts. The plan should focus on securing funding from investors with a solid elaboration on how the dealership will operate, grow and sustain itself. In particular, I'm looking for: - A detailed plan that proves the viability and potential of this venture. - A strategic approach to engaging investors and securing their financial backing. - A clear explanation of how the dealership will target and capture the ATV/UTV/Watercrafts market. - An analysis of the competitive landscape and a strategy for differentiating the dealership. - Projections for growth, revenue, and profitability over the next 3-5 years. Ideal Skills and Experien...
I require a data report which focuses primarily on the tracking of conversion actions on a monthly and yearly basis. In particular, the report should include: - Detailed analysis of our conversion tracking data - Breakdown of the converted actions recorded throughout each period To take on this project, you must: - Have experience in analyzing conversion data - Have an understanding of key performance indicators (KPIs) - Be proficient at creating detailed, clear, and action-oriented reports Ultimately, I'm aiming to examine and understand the sequences leading up to conversion actions, in hopes of enhancing strategies to further boost conversions.
...able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual representations of data. - ...
The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate
We would like to hire a freelancer expert in development of Postgres Database and Synchronization of Data from our Headquarter to our Multiple Area Office (10 No.) and to Multiple Local PC (Around 300 Nos.) locations available in Network.
We have attached the details we need to sync our data from Headquarter to Area Office and than to local PCs and back again. for RFID based application.
...our front-end with MongoDB Atlas to create a live search bar for machine parts. Key Responsibilities: - Connect framework with MongoDB Atlas to enable real-time data retrieval for live search functionality. - Implement a user-friendly, intuitive search bar that allows for quick and efficient product searches. - Develop a product display page that showcases detailed information about the machine parts. Ideal candidates for this position should: - Be proficient in JavaScript and have prior experience working with Next.js. - Possess a solid understanding of MongoDB Atlas or a similar NoSQL database. - Have a keen eye for design and UX to ensure a seamless user experience. - Prior experience with e-commerce or product search functionality would ...
I'm looking for a skilled Facebook marketer to help promote my digital products to professionals and businesses. Key Tasks: - **Increasing Brand Awareness**: The primary goal of this campaign is to increase the visibility of my digital products in this particular market segment. I need someone who can effectively communicate the unique value propositions and features of my products to this audience. - **Generating Leads**: In addition to spreading awareness, I want to turn this visibility into tangible leads. The ideal candidate should be able to implement strategies to convert engagement with our brand into potential customers. - **Driving Sales**: Ultimately, the end goal of this campaign is to drive sales for my digital products. Experience in crafting compelling sales c...
...experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. *...
