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) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
For the game Dead by Daylight, I would like someone to create an equalizer to isolate the sound of a specific character, and amplify that sound so its easier to hear while im gaming. Ideally Peace Equalizer running in the back that i can switch on and off. The sound is comparable to breathing but is more like a distinct grunting sound. There will be 3 different equalizers, with 3 different sounds at the base. The end goal would be 3 files for peace equalizer I can download. I will provide all the input, so I can send all the audio files required to make the EQs. Looking for a developer who knows how to utilize programs to translate sounds into Hz ranges & into eq's + ideally other advanced techniques I dont know about.
I want to make a browser-based epub/pdf/text viewer that supports annotations For the first step, I need a dev to make a nodejs script that can convert epubs, pdfs, and txt files to static html files. I want 1 file for each chapter. The scr...want to make a browser-based epub/pdf/text viewer that supports annotations For the first step, I need a dev to make a nodejs script that can convert epubs, pdfs, and txt files to static html files. I want 1 file for each chapter. The script should produce a that links to all chapter files. If a file has no chapters, break the book into 4000 words chapters Also it should produce a table of contents .json file. The file lists all the chapter files. Link to a similar project in your bid if you have it. Thanks for bidding
I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.
I'm looking for a freelancer to assist me with data input tasks. The data to be inputted is sourced online, and it must be accurately and efficiently inputted into our system. Following data entry, the data will be used to update our database. Data Type: - Images - Text Requirements: - Min. 200 Full Described Entities per Week - Proficient in data input, especially sourcing from online databases - Skilled in database updating - Attention to detail to ensure data accuracy - Efficient and timely completion of tasks - Previous experience in similar roles would be beneficial
I'm looking for a skilled PowerPoint designer who can create a visually appealing presentation based on a PDF paper summary for a topic (Why people use VPN). The main goal of this project is to present key findings, provide visual summaries, and enhance understanding through a minimalist and visual approach. - The presentation should include 10-20 slides - Each slide should be designed in a minimalist style with a strong emphasis on visual content - Design should be focused on delivering key findings and summaries in a clear and concise manner To take on this project successfully, you should have a strong background and experience in: - PowerPoint presentation design - Infographics and chart creation - Understanding of visual communication and information design Pl...
I'm seeking a highly skilled freelancer to assist with in-depth Android application security assessment. Skills in the...Volatility, APKTool, and Ghidra Intermediate level of experience in Android application security assessment. Ideal Skills and Experience: Demonstrated experience in Android application security assessment, vulnerability identification, and mitigation advice. Specific expertise with Volatility, APKTool, and Ghidra. Ability to provide comprehensive project proposals including the following structure: Table of Contents Abstract Abbreviations List of Figures Introduction Conclusion References Note: I have an existing codebase for analysis and will provide it as a sample. Please include your previous work samples and detailed project proposals in your applicat...
...filter settings, but they can't make any changes and can't see any other modules at all, what they can do is just view NSC module, use the search, filter, or print(if available) features, also, please instruct us how to create this specific users. - Co-ordinator in project/Task can also edit the project/task/so/sales/quotation / purchase order and all custom modules we created - Additional five Project list reports, just use the existing one and change the fields, add one combine report and one button or dropdown list then generate that. - Task, one click to update or add, create buttons in the task, then each button can copy the certain fields data from project to the certain fields in task? For example, click button one can copy project name and dates fields to...
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
...QR code will be recorded in the database along with the timestamp. - The application will maintain a count of how many times each unique QR code is scanned. 2. Barcode Scanning (Y Person): - Y person will have the ability to scan barcodes of outer cartons using their mobile device's camera. - Each scanned barcode will be linked with the corresponding QR code in the database. - The application will generate reports based on the QR codes linked with the scanned barcodes, providing insights into the frequency of scans for each QR code. 4. Reporting: - The application will generate reports that display: - Total count of scans for each unique QR code. - Frequency of scans for each unique QR code over a specified time period. - Summary s...
I'm currently in need of a proficient engineer who can handle an intermediate level task on Cadence Virtuoso. This complex project requires a mixture of analog and digital circuit designs. Here's what you'll need to bring to the table: - Proven experience with Cadence Virtuoso - Capability to work on intermediate level complexity designs - Understanding of both analog and digital circuit designs, as the project involves mixed-signal circuit designing You don't need to have Cadence Virtuoso on your PC, as you can access my system remotely via AnyDesk to complete the task. Looking forward to working with someone who can meet these requirements for a successful project completion.
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
Create Engaging YouTube Ai Video upto 4 minute
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...
The objective of this project is to develop a modern, user-friendly website for our home services company, offering a comprehensive range of plumbing, heating, cooling, and other home services. The websit...clear and accessible contact information, including a contact form, phone number, and email address, for customers to easily reach out to Domino Home Services for inquiries or support. We'd prefer to use Wordpress but if you think that another platform is better, we can consider that. You'll need to provide: - the design - the content: we'll provide you with all the information you would need to create the pages. Please start your bid with "I'll be a great fit for this project because". Provide examples of websites you have created that would give...
...how many types of churners there are and the size of those types. This involves dividing the churners into segments. Task b (Profiling): Profile and appropriately name the identified types of churners based on the values of their shared characteristics, i.e. variables. Your submission ought to include: 1. Orange workflow1 containing the k-Means clustering analysis of segments and profiles. 2. Summary file (max. 600 words; in PDF format) presenting the segments (Task a) and their profiles (Task b)....
Application code to implement Roomio as a web application in python. You will use the table definition posted at the end of this document.
Searching for a creative partner to produce compelling videos for an established psychology and mental health focused YouTube channel. Here's what the ideal candidate brings to the table: • Expertise in YouTube algorithm for channel monetization • Capabilities to generate content on a wide range of topics - Depression and anxiety, Self-help and personal growth, Relationship advice and any subject related to psychology and mental health. • Insight into audiences of all ages • Ability to produce and upload new videos as frequently as possible, with a minimum commitment of twice a week. Ideal Skills: • Proficient in video creation and editing. • Strong understanding of YouTube algorithm, SEO, and techniques to drive viewer engagement. • In-dept...
...identified. Details about the data: I want to have 3 tables: Real time data table: The data will be captured directly from sensors at the form of columns, for example, Device 1, device 2 , device 3, and rows are time captured at growing rate of 1s. the value of the row is the energy consumed of that device at that exact second. This will be a large table. Hourly Data Table: Aggregate data hourly to feed into the anomaly detection model, stored in the 'Hourly' table, to identify significant deviations. Daily Data Table: Summarize daily data for use with the SARIMA model, aiding in long-term consumption predictions and trends analysis. All the tables are fed from the main large table (secondly rate table - real time table...
I am looking for a professional developer to create a comprehensive real estate website using React. As the client has not specified a particular function, it is anticipated that the website will provide common real estate features such as property searches, property listings, and a contact form. Moreover, the website would ideally cater to a range of purposes, from displaying property listings to generating leads and providing company information. Ideal Skills and Experience: - Proficiency in web development with React - Past experience in real estate website creation - Understanding of lead generation mechanisms - Strong aesthetic sense for creating intuitive, user-friendly design What to Include in your Application: - Samples of past work, especially of previous real estate we...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements with...
I'm looking for a skilled designer who can help in creating a strong iden...would be someone who is not only creative but also has a deep understanding of the principles of design and the technical implications of their decisions. You should be able to come up with innovative and original ideas, but also be able to execute these ideas in a way that is practical and effective. As I'm open to suggestions, I'm looking for a designer who can bring their expertise to the table and help me shape this project in a way that is both unique and impactful. If you think you have what it takes to deliver this comprehensive design project, I'd love to hear from you. Please provide a portfolio of your previous work that showcases your skills in the areas of Identity design,...
I need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file
We have an existing app with a me...standard dropdown. Right now we have 26 cities that have to be included The backend CMS work both for android and iOS Ideal skills for this project include: - App design experience, particularly with menu systems - A good understanding of user interaction and interface design - The ability to balance creativity with practicality We're looking for a freelancer who can bring fresh ideas to the table while also respecting the existing structure of the app. The goal is to improve usability without introducing unnecessary confusion. You can search the app on google it is online' Looking forward to hearing from you
***MUST HOLD PE LICENSE IN WISCONSIN, USA*** In this project, I'm looking for a Professional Engineer based in Wisconsin to perform a field evaluation of several luminaires for installation in a home remodel. Key Responsibilities: - Identify changes neces...changes necessary to make luminaires comply with safety requirements. - Evaluate final version, write a report explaining that they comply with safety requirements, write up any installation instructions for mounting, and apply PE stamp. Necessary Skills and Experience: - Certified Professional Engineer status in Wisconsin. - Understanding of electrical safety standards relating to luminaires. In summary, your task is to assist me in ensuring that the luminaires in question meet the necessary safety criteria in the WI e...
...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 Hf...
I'm urgently looking for a professional who can create a customizable resume builder for me. It needs to be a simple and effective tool that allows users to easily input their information and then customize which sections and responsibilities they want to include in their resume. As I have experience in multiple industries and blended roles (i.e. Human Resources and Safety), I need to be able to select the responsibilities or accomplishments I wish to include for each past employer. I need to reduce my 5 page resume and tailor each resume for each employer. Currently spending an hour or more to tailor each resume. Key features: - Customizable sections - Ability to choose responsibilities to add for each employer from a list of responsibilities that can be added to. - The fol...
...entrepreneur in the boutique industry, I'm looking for an experienced business plan writer to craft a comprehensive plan that appeals to a general audience. Specific knowledge or experience within the boutique or retail sector would be highly beneficial for this project. The business plan should be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projec...
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 am used to creating logo designs that are set in the company and it has become my daily work and if you are willing to ask for a logo by me then I will give you the best logo.
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 wan...
I'm seeking a seasoned developer well-versed in C# and Selenium to create a bot to facilitate automation on Facebook Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, 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 ...
...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...
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.
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.
Hello, I want to create a Car Rental website with online reservation.
...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...
...creation. We have few film projects in the works. Once we confirm we can work with you, there will be many AI film projects. To make sure we are a good fit. I want to show you a 30 sec. AI film clip for a project we would like to hire you to work on: A few shots are missing between the two scenes. (Starting from 12 sec) if you can show that you can create a prompt image or video that matches this scene for continuity, then we would like to invite you to work with us. We can work out the payment details once confirmed. Thank you. Here is the first page of the script. ***part is the missing part. Looking forward for your reply. I appreciate your interest. FADE IN: INT. THOMAS’S APARTMENT - MASTER BEDROOM - NIGHT Dark. Quiet. THOMAS HAHN (early 40s
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...
Looking for a Google Cloud Platform (GCP) expert who can assist with Cloud Functions and Vision API integration and deploy function on google cloud - Your main focus will be integrating Vision API for images batch processing and setting up Cloud Functions. The urls of images will be in excel file in google cloud. The parse result to be placed in columns next to url column. - The data primarily processed with text detection. Ideal Candidate: - Proficient in GCP services, specifically Cloud Functions and Vision API. - Experienced in setting up GCP services for one function. - Skilled in implementing Vision API for image processing. - Strong understanding of data processing in GCP.
We need to create a plugin that will handle the matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship 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: Abi...
