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) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
안녕하세요, 소셜 쇼핑몰 사이트에 판매하기 위해 상품 상세페이지 작업을 하던 도중 담당 디자이너가 개인적인 사정으로 일을 마무리하지 못한 상태로 연락이 끊겨버렸습니다. 아래 첫번째 첨부 화일 '슬리폰즈상세페이지(초안)'을 보면 알 수 있다시피 전체적인 프레임과 컨텐츠는 거의 잡혀있는 상태입니다, ping화일이다보니 새로 만들어야 하겠지요. 하지만 여기에 쓰인 이미지 대부분을 psd화일로 제공할 수 있습니다. 위 링크 페이지에서 커서를 중간 쯤 내리면 Download Images제목 밑으로 작업에 쓸 이미지 다 있습니다. 하지만 원활한 작업을 위해 이메일로 일일이 해당 이미지를 보내드릴 것입니다.참고: 아래 첨부 화일---> SPs 소셜사이트 담당 MD가 소셜쇼핑 디자인가이드 방침에 맞지않는 부분을 몇가지 지적했기에 수정할 부분이 있으므로 그러한 내용을 숙지하고 적용해서 제작하면 되는 것입니다. 물론 그것도 저희가 다 알려드립니다. 구체적으로 예를 들어 열거해보겠습니다. - 시안에서는 "선택A-1,2,3 B-1,2"로 했으나 "선택1~선택5"로 바꾸기. - 맨 첫 이미지에 있는 우측 세줄의 홍보문구는 없이 만들기. - 38% 61,500 모두 필요없고 "쿠팡가 39,800원"으로 통일. - Hotdeal 박스--->작업할 필요 없음 - 맨 아래 아마존 피드백 모음도 안집어넣으면 되고요 그 아래 사진도 올리지 않고 다른 이미지로 업로드할 겁니다. -............
I need a skilled PHP developer for a project that requires merging multiple images into a single template. The primary task is to overlay images on top of a template, creating a final image that is a combination of all the images. Key requirements include: - Merging multiple images: This project involves overlaying several images on top of each other to create a final composite image. - Positioning and Size: The ability to adjust the positioning and size of the images being overlaid is essential. While I prefer a simple drag and drop tool to adjust these parameters, the output should be precise. - Output Formats: The final image should be available in both JPEG and PNG formats. Ideal skills and experience for this job include: - Strong proficiency in PHP: Since this project...
Monthly, we populate a spreadsheet with the over time of the technical team, and the weekend / night shifts of the tehnicians working outside the business hours. We have a template that we want to improve. 2 categories: 1. Managers doing overtime (regular / night / weekend) and being oncall. 2. 24h shifts: complement to the salary based on night / weekend hours we should be able to calculate monthly the amount to be added to the fixed salary attached template (with complicated formulas and errors)
...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
AUTO-BIDS WILL BE REMOVED. I'm in search of an experienced developer skilled in Zendesk API integration for a project related to airline claim forms. I will provide you parts of the template and you will add the form, calculations, API integration and ticket creations. The website should be built in Laravel or secure platform. If you know about EC261 claims it makes it way easier to choose you. You will do the following: - Create a form which is predefined through parameters and questions. - Add airline and airport database and organize the data with live search preview. - Calculations based on airport distance and claim form. - Zendesk ticket creation along with correct ticket numer and relevant information. - Multilingual form (Swedish and English). Need someone to...
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I'm in search of an experienced developer skilled in Zendesk API integration for a project related to airline claim forms. I will provide you parts of the template and you will add the form, calculations, API integration and ticket creations. The website should be built in Laravel or secure platform. If you know about EC261 claims it makes it way easier to choose you. You will do the following: - Create a form which is predefined through parameters and questions. - Add airline and airport database and organize the data with live search preview. - Calculations based on airport distance and claim form. - Zendesk ticket creation along with correct ticket numer and relevant information. - Multilingual form (Swedish and English). Need someone to start ASAP.
Estoy buscando alguien que pueda ayudarme a mejorar el diseño de mi web hecha en wordpress. Estoy usando actualmente el tema wprentals. (Tengo muchas funciones editadas del tema, entonces es necesario trabajar en el, no pretender cambiar de template)
I'm looking for a proficient developer who can add a page to my website that interfaces smoothly with my MySQL database. The website already has formatting etc, so I'm not looking for that. The database stores a variety of exercise data, and the webpage needs to display this data in an intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from ...
...higher. Key responsibilities include: - Managing my inbox and responding to emails - Handling various administrative tasks - Conducting research on different topics - Organizing information in Excel - Scheduling appointments and managing my calendar The ideal candidate should: - Be able to dedicate between 10-20 hours per week to this role. - You can make calls and videocalls and mantain fluid communication. - Possess strong organizational and time management skills. - Have a background in real estate is valued but not mandatory. Tecnic requisites Internet connection between 50mp-100mp of download y 10mp of upload. Hardware: 8GB de RAM Mínimum processor Intel Core i5 or equivalent. Solid-state drive (SSD) as the main storage Please respond with your releva...
I am in need of an experienced freelancer who can help me create an iOS storyboard for my p...touch will be extremely necessary and appreciated. Key Requirements: - Interpretation and utilisation of the provided specifications to create a user-friendly storyboard. - Generate unique, intuitive and compelling ideas for the storyboard. - Experience in iOS development and designing. - Critical thinking and problem-solving skills. - Proven ability to work effectively within deadlines. Please download the attachment for the project details. Your application should clearly showcase your relevant experience and past projects you've handled. Also, I hope to find someone who can understand and effectively use the specific features I have in mind for my storyboard. Thanks for consider...
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...
Hi, we need to create a picclick similar site that uses the feed of our 2 websites The site will automatically download the products by comparing and redirecting them and showing the offers of the two stores.
...mobile app is crucial for ease of use. Additional info: I am doing preliminary feasibility for a store in Chelsea Massachusetts. This project should blend with a newly opened robotic fulfillment center newly built in Tewksbury, Massachusetts. The store is in nearby Chelsea, Massachusetts. The initiative is from the store, that is why we have no feasibility study budget. A preliminary template has already been built by an Ai assisted feature of Microsoft 360. Nobody has any real spreadsheet acumen to go any further, but our data series and needed parameters are ready. I've been hired to work in the new robotics center due to my past technical background and current Home Depot store merchandising and shrink knowledge. My time frame is 4 weeks as our data streams...
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
Create an app and software that allows users to view their recorded game play footage. Hardware at sport facilities will record game play, controllers will be programmed to post recorded footage to servers. app needs to be developed so that this game play can be accessible for users to view/download etc. please review information before bidding, as well as budget. specified budget is maximum if your bid is higher please dont bid
...Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient data flow throughout the application. Frontend Development: Design and develop a user-friendly e-commerce website where customers can browse and purchase generated images. Database Management: Set up a database to manage user data, transaction details, and maintain ass...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...
...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...
We have a number of PSDs we use for news articles - where we paste in a person's photo and another photo. These are essentially templates. Some have designs, some are simple, etc. I need some more of these made - 5 for $35 Samples available to qualified bidders.
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...on the new WordPress. The problem is, I don't want to use the guy's raw PHP as the page template because it causes a bunch of errors and differences in my header and page style. Besides, there are problems with mobile. So, I'd like to use this structure that's already working great but use pages created within the Divi theme so it doesn't break the style... For example, I want to list the offices of a state within a page created in my own Divi theme, so the header stays standard and nice according to the site's style... Then, when the user clicks on an office, they should go to the information page also in the same style, using the default template of the Divi theme, and not a new raw PHP template from the guy... As this is assista...
Tasks : 1. Construct a queueing model that replicates a week of collecting and processing DNA samples. a. First develop a flow diagram of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use me...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accura...
I'm in need of a skilled email template designer to create a responsive email template that fits the Zoho CRM. Key Requirements: - The email template needs to be compatible with Zoho CRM. - It should be responsive, ensuring that it displays correctly on various email clients, including Gmail, Outlook, and Yahoo Mail. Application Requirements: - Please include your experience in designing email templates.
I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Id...
Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.
Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!
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.
Hi We are launching an upcoming case battles website and require a designer. We are looking to design about 30 cases to start then 1-3 a month. We have a base case template designed added then we will provide a theme for each case. This project is for the first case then we will look to do the remaining 29. The budget is $10 per case The first case theme is for a creator called Riiski you can see his theme is green and also with a crocodile which we would like to use. so we want the case to be themed for Riiski and also a title given to the case called the Riiski Creator Case Riiski twitter : Ill attach the croc and the twitter header so you get an idea of theme. Remember we still want to see the CASE elements so it still looks like a case just apply
I'm in need of an experienced backend developer to create a mail parser with the following specifications: - **Email Protocol:** The mail parser should support SMTP, so proficiency in this area is a must. - **Primary Goal:** The primary function of this mail parser should be storing emails in a MySQL database. If you have experience with database integration, this would be a big plus. This project requires expertise in backend development, specifically with an understanding of how SMTP works. You should also be familiar with MySQL and have experience in integrating databases into applications. Please provide examples of similar projects you've worked on in your proposal. Thank you.
Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you
I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.
...information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is crucial to ensure accuracy. - Data Organization: Good data organization skills are also important to present
I need a VA with Wix store experience, a keen eye for detail, and proficiency in spreadsheet management. You'll be tasked with: - Keyword Optimization: Adjust the product titles on my Wix store to ensure they are optimized for search engines. Experience with SEO would be beneficial for this. - Database Creation: Develop a comprehensive database for all my products. This will include attributes like Product names, Product prices, and Product URLs. - Formatting: The database should contain separate columns for each product attribute. Strong organizational skills and experience with data entry would be ideal. Ultimately, the goal is to streamline the management of my product listings for a smoother business operation. Prior experience with Wix and creating pro...
...code book - best practices for development (code level documentation, common patterns, OOP as possible) - best practices for agreed and choosen libs/frameworks - classes are reusable for later extensions and reuse options (after MS4) Deliveries? - in our on premise git (access will be granted to you) - full sources (NO! Jupyter Notebook) - multiple samples of videos will be shared via URL to download - bash to build & run your code - poetry build - latest stable python version - libs, need prior confirm and we prefer to use mostly latest stable versions - your code is working on our end too - your code passes our CI build (with provided maven can be checked) - you may require to help us here on setup - we require, depending on availability and on complexity 2-4 weeks test t...
I'm in need of a skilled professional to create an Instagram filter for my use. Th...text that needs to appear very slowly over a duration of 7 seconds. Key Requirements: - Animation Duration: The text should be fully visible after 7 seconds, appearing asynchronously slow. - Text Style: The text needs to have a bold and modern font style. - Special Effects: The only special effect needed is a slow asynchronous fade in. No other effects are required. Please note that I have a template available for this project which can be shared with the chosen freelancer. Ideal Skills: - Proficiency in Spark AR Studio or similar software. - Experience in creating Instagram filters. - Creative design and animation abilities. - Strong attention to detail to achieve the desired slow appearan...
I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...
I have a project that requires the creation of a website on Webflow, populating it with text content only from a Word Document. The site structure will consist of 6 pages, which will need to be built out with an existing Webflow template – Sunshine Mind (). The pages are already made, just need to input the content. Landing page already created - Populate text content from Word Document into the given Webflow template. - Build out the following pages: Services Overview, Individual Service Pages, and About Us.
I need an experienced graphic designer who can help me enhance the design of basic ID cards for my organization's 44 employees. Key Requirements: - I will provide an Excel file with detailed employee information. This should be included in the design. - Each ID card should include the employee's Name, Employee ID Number, Date of Birth, Emergency Contact Number, and the Company Address. - The design should be professional and visually appealing. I'm looking for someone who can take on this task urgently and provide high-quality work within a short timeframe. Your past experience in designing functional and aesthetically pleasing ID cards will be a huge advantage.
...project is to develop the Minimum Viable Product (MVP) for using the Bubble platform, incorporating the capabilities of the Perfect AI Software Template. This MVP will validate the concept by offering essential functionalities such as AI-driven funding opportunity matching, interactive user profiling through an intelligent quiz, and efficient application assistance. Scope of Work: The project encompasses the following key tasks: Template Customization: Adapting the AI SaaS Dashboard template to fit the unique branding and functional requirements. Database Integration: Configuring and linking an external Airtable database to import and regularly update a directory of funding opportunities. User Authentication and Profile Setup: Developing secure lo...
