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) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.
I have two PDF files that contain about 150 records each that I need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - A...need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - Attention to detail - Familiarity with spreadsheet software (such as ...
I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.
I'm looking for an experienced data miner or online researcher who can compile a comprehensive contact list consisting of both industrial business owners and industrial property owners in the Charlotte market. The data points that you need to scrape are the following: For Business/tenant contacts: * Property address * Property city * Property size (square footage) * Business/tenant name * Business owner/executive contact name * Business owner/executive contact phone number * Business owner/executive contact email address * Business website (if any) For Property owners: * Property address * Property city * Property size (square footage) * Owner business name (unless individual owner) * Owner name * Owner phone number * Owner email address * Owner website (if a...
I'm seeking a UK-based freelancer who is familiar with the electronics market in the country. As I venture into the dropshipping industry, your expertise will help guide our operations and ensure we target the right products to the right audience. Key Tasks: - Market analysis to identify potential electronics products for dropship - Provide insights into the competitive landscape in the UK electronics market Ideal Skills: - Detailed knowledge and understanding of the UK market - Familiarity with the electronics industry - Previous experience in dropshipping or eCommerce is a plus but not strictly necessary. Your knowledge of the UK market is what will set you apart.
I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.
I'm seeking an expert data scraper to compile a comprehensive list of small to medium enterprises (SMEs) across Victoria, NSW, North Queensland, and South Australia. The scope of businesses should focus on restaurants and retail stores. The information needed for each business is as follows: - Business Name - Address - Phone Number - Website - Email Ideal candidate should have robust experience in data collection and validation to ensure the information provided is current and accurate. Proficiency in navigating Australian business directories and databases will be a valuable asset. Your scrupulous attention to detail and commitment to data integrity are critical for this task.
I need a database where we can store our sales transactions. The database will be manually updated by our staff. I would also like to have reports generated on our sales. Key Requirements: - Develop a database to store sales transactions - Enable manual data entry by staff - Implement a reporting system that can generate sales reports Ideal Skills: - Proficiency in database development - Experience with manual data input systems - Ability to create custom reporting features Please provide examples of previous similar projects you've worked on.
I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strategies in terms of customer se...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.
I am seeking researchers in Boston, USA to conduct market research for a retail audit. The ideal candidate should have good communication skills and access to a smartphone and be able to complete the project in 2 weeks. You will visit 30 bars in the city of Boston, USA and the payment for this project is €420. For this project, the product cost and materials needed to assess the product will be reimbursed. Specific requirements for the project include: - Conducting a retail audits in Boston, USA - Collecting data on consumer behavior and preferences Skills and experience needed for this project: - Strong analytical skills - Excellent communication skills - Ability to finish the project by a specific deadline - Flexible schedule Please get in contact if you are interested in...
I'm looking for a capable .NET developer to create a WebAPI using the Visual Studio template "WebApi Net core (Minimal api)". It needs to have Authentication and Authorization in place, using the X-API-Key. Key Requirements: - Authentication and Authorization: You need to enable X-API-Key based authentication and authorization for this WebAPI. - Data Model: The WebAPI will manage a simple 'City' table, performing basic CRUD operations. Expectations: - The X-API-Key should be hardcoded in the application. - The WebAPI should be developed using .NET 8.0 and the Visual Studio template "WebApi Net core (Minimal api)". - Data access should be implemented using EFCore. - Authorization should be handled through middleware. Ideal Skills and Experien...
...Familiarity with the York Region, Ontario, Canada area is a plus Your main tasks would include: - Researching and identifying potential clients in York Region - Contacting clients via email, phone calls, or in person (door-to-door) - Convincing clients to book our residential window cleaning services - Keeping track of and reporting on client acquisition progress Free Trial Opportunity: As part of our hiring process, we're offering a free trial period to assess your ability to generate recruited houses effectively. During this trial period, you'll be tasked with acquiring 2 new clients closed and scheduled for a minimum of $200 each. If you have trouble quoting or providing an estimate to a client you can contact me for help on giving that estimate. If you can...
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth anal...
...- Valuation: A comprehensive evaluation of the company's worth. - Business summary: A concise overview of the company's operations and key strengths. - Risks: Identification and analysis of potential risks the company faces. - Industry analysis: Understanding the company's position and performance in the context of its industry. - Reach format report with 10k words, charts and infographics. - Excel modeling and native file is part of the deliverable. Ideal candidate would have: - Proven track record in financial analysis - Strong understanding of financial principles and methodologies - Previous experience in company valuation - Ability to present findings in a clear, concise and actionable format - Attention to detail and high analytical skills Please provide ...
...team. - **Method**: I'm open to various methods for reaching potential customers, from traditional cold calling to any other approach you are comfortable with. However, I'm not interested in online advertising. - **Requirements**: The houses you recruit must be in the York region. Additionally, each recruited house should provide a minimum of $200 in business. Free Trial Opportunity: As part of our hiring process, we're offering a free trial period to assess your ability to generate recruited houses effectively. During this trial period, you'll be tasked with generating two recruits per hour that meet our criteria and can be closed for a minimum of $200 each. If you can do this for 3 hours, you have passed. If you accomplish this goal, we'll con...
...seeking a skilled researcher to conduct a detailed economic feasibility study across a selection of cities. The study is intended for my internal team and entails comprehensive analysis of 8-10 critical factors that will inform our decision on which location to choose for our business. Key Requirements: - Conducting a thorough analysis: You will need to explore the economic environment of each city in detail, with a focus on the factors impacting the feasibility of our business in that location. - Detail-oriented research: The study should be in-depth, with a range of data sources cited to ensure the accuracy and reliability of the findings. - Written Report: The end deliverable should be a comprehensive written report, well-structured and easy to comprehend by team members who...
Looking for a talented Java developer to build a to-do list application with a focus on Object-Oriented Programming (OOP). The application will be simple yet effective, featuring offline usage capability which is crucial for productivity in various environments. Key Requirements: • Application Compatibility: The app must be compatible with Windows, Mac and Android platforms. • Offline Functionality: The app should allow users to continue using without a constant internet connection. Skills and Experience: • Proficient in Java OOP. • Extensive experience developing applications for different platforms. • Good understanding of implementing offline capabilities in applications. Application Guidelines: • Freelancers are required to provide detailed...
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
Es ist eine Aufgabe die in Excel gemacht werden muss, bzw Excel Solver bis 10.05
La tarea sera la gestión completa de cuentas para los anfitriones de distintas pl...de propiedades. Necesitamos especialistas en atención al cliente que puedan encargarse de las tareas administrativas y la gestión de cuentas. Los requisitos para el solicitante incluyen gran atención a los detalles, título universitario, acceso al correo electrónico y conocimiento del uso de un dispositivo (computadora o teléfono), herramientas de software básicas (Microsoft Office - Word y Excel). Necesitamos miembros rápidos, precisos y especializados. Es obligatorio aprobar una prueba corta/terminar una tarea, que podría durar entre 2 y 4 horas, con posibilidad de extenderse hasta 1 semana, si el candidato está inv...
I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behind in My expectat...
...professional and engaging approach towards potential clients. Free Trial Opportunity: As part of our hiring process, we're offering a free trial period to assess your ability to generate leads effectively. During this trial period, you'll be tasked with generating two leads per hour that meet our criteria and can be closed for a minimum of $200 each. If you can do this for 3 hours, you have passed. If you successfully accomplish this goal, we'll consider offering you a permanent position with our team. The leads must be generated in the area of Canada, Ontario more specifically York Region. Leads must be generated from the following cities: - Markham - Richmond Hill - Vaughan - Woodbridge - Scarborough - Newmarket - Aurora - King City - Stouffv...
We are seeking a dynamic freelancer to lead the promotion of our Android money SMS app in various markets. Our app offers innovative solutions for earning money by receiving SMS messages, providing users with a simple and convenient way to generate income. Project Overview: Our primary objective is to obtain 50 real users per country. Once you sign up you will receive a referral code. You will be paid 1USD per APP downloaded with your referral code.
...create a custom informational site with a user-friendly To-Do List plugin. The site is aimed at the general public, for informational purposes currently and visually appealing. Key Requirements: - Wordpress Development: Proficiency in creating and customizing websites on the Wordpress platform is a must. - To-Do List Plugin: The plugin should allow task assignment to users. That can sync with an App Based client. i'll let developer suggest such a good program to utilize. It will give push notifications and support moving the date/time and allow re-occurring tasks, and assigning the task to users. Your Responsibilities: - Design: I need a simple, clean and modern design that will appeal to a wide audience. - Functionality: The to-do list should be easy to use,...
I'm looking to create a dynamic social media platform that allows users to select their own country upon registration. This will be a platform for creating and sharing substantial posts, each of which can be up to 10,000 words long and must contain pictures. Users are encouraged to engage with each other by giving likes to posts. Key Features: - Users must register to access exclusive content, interact with other users and customize their profiles - Ability to create and publish posts of up to 10,000 words along with pictures - Users can like posts - All users receive an email notification when a post receives over 100,001 likes Ideal Skills: - Proficiency in web development with experience in creating social media platforms - Experience in incorporating user registration and...
...instructor to help me pass my upcoming driving test. The successful tutor needs their own vehicle that I can use for the practical test at the DMV, and take me to the DMV on the test day. I have not scheduled my test day yet, but I prefer to take it before May 20. I will pay $25/hr. Requirements: - Offer both weekday and weekend lessons - Approximately 2 hours of teaching. I used to drive in my country so I am familiar with driving. - Ability to instruct on parallel parking, highway driving, and defensive driving - Experience in preparing students for the driving test Ideally, I would like a flexible, patient instructor who is skilled at teaching. Knowledge of local DMV expectations for the driving test would be a significant bonus. Your lessons will help me to not only pas...
...provided libraries is a plus Attached are all the files you will need to test the old working template and to update to the newest libraries. Instructions: 1. The "" video snippet shows a working template using the old "" and "" javascript libraries. When you type a telephone number inside the input field (tonumber), the full number with country code (tonumberfull) automatically displays beside the input field inside the "div". This old working code is listed in "". 2. Attached is a non-working update attempt "" which uses the latest "" and "" javascript libraries. As you will see, when you type a telephone number inside the input field, the full number does
We're seeking a talented 3D artist capable of producing captivating photorealistic renders and videos for a range of products. The ideal candidate must excel in rendering techniques, possess meticulous attention to detail, and have the ability to breathe life into products through stunning visual representations. Responsibilities: Create photorealistic 3D models of products. Develop high-quality textures and materials. Render product images and videos using industry-standard software. Collaborate closely with the creative team to ensure alignment with brand guidelines. Optimize renders and videos for various platforms. Requirements: Demonstrated expertise in 3D rendering, modeling, texturing, and lighting. Proficiency in industry-standard 3D software. A strong portfolio sho...
As a representative of Belize at United Nations Climate Change conferences, I've highlighted the specific difficulties of climate change our country faces. These include: - Rising sea levels - Coastal erosion - Extreme weather events To combat these difficulties, the solutions I aim to see demonstrated through this project require expertise and experience in: - Development of coastal protection measures - Implementation of renewable energy projects - Adoption of climate-resilient agricultural practices It is expected that these initiatives will lead to the: - Reduction of vulnerability to climate change impacts - Enhancement of resilience to extreme weather events Therefore, professionals with experience in environmental conservation, renewable energy projects, and climat...
I'm a self-employed professional looking for hands-on assistance in New York City to set up my business email on Microsoft Outlook. This job requires a tech expert well-versed with Outlook setup and management. Here are some of the tasks I need assistance with: - Set up my Outlook email account successfully - Simplify the way I organize and manage my emails - Provide step-by-step guidance on how to maintain the setup in the future Preferred Skills: - In-depth knowledge of Microsoft Outlook - Previous experience in email account setup - Excellent communication and tutorial skills - Ability to solve technical issues - Based in, or able to commute to New York City If you can help me streamline my email management in Outlook, I'd love your expert gu...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE ...
...and Technical SEO. My primary objective is to enhance my website's visibility to a business audience. Redesign website to reflect our commercial services of Facilities Maintenance, Signage and Lighting. Create more of a simplified feel (somewhere between Mom & Pop and large group, want to feel like a less expensive option and hometown.) Would like page to be dynamic, if possible, to morph to the city of the searcher. I would like specific landing pages to target the market of LED parking lot lights and Sign work, later I would like to add our facilities arm of Plumbing, Electric, General, HVAC. I would further like to be number 1 for searches in the state of Florida for commercial signage, Parking lot lighting and Facilities Maintenance. I don’t know if this is...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm looking for an experienced freelancer to tackle data entry. The focus is on text data, which needs to be accurately inputted into a structured database. While attention to detail is important, issues checking for spelling or grammar errors will not form part of the job scope. In line with this, the ideal candidate should: - Have a proven track record with data entry projects - Have expertise in structured databases - Be able to work accurately with text data - Have the ability to complete tasks effectively within the given timeline.
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are conf...
I have a completed project of a wooden fence on a concrete retaining wall. I require a thorough assessment of seismic wind load analysis for the fence. The purpose of this analysis is to check for code compliance, specifically to meet the standards required by the El Cajon city due to the height of the fence. The ideal candidate would be proficient in: - Seismic wind load analysis - Code compliance for the city of El Cajon - Assessing fences on concrete retaining walls Your analysis will help ensure the fence meets the expected regulatory standards. I've attached a photo of the fence at its highest point.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
I am looking for a database website that serves as a customer form. This form will be used by customers to fill in various fields. Upon submitting the form, they will automatically receive a comprehensive response based on the information they provided. Key Requirements: - The customer form should include fields for Name, Contact information, Address, Location, Product or Service details, Width and Height, Dimensions, and Vertical or Horizontal preference. - The form should have an inbuilt auto-calculation feature that computes the Total cost, based on the area calculated, and any additional amount based on the customer's requirements. Delivery of Reverted Information: - The system should trigger an automated response to the customer. This can be in the form of an Email, a We...
I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.
