How to sort large data in excel jobs
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve...
I'm looking for highly experienced and innovative professionals to design a Karate competition stage for a large indoor venue. The design should ideally account for a stage dimension of 12m x 12m x 500mm. I would like it 400mm off the ground. Wanting to build a karate stage thats lightweight, strong, easy to assemble and that will last Skilled 3D designers with a background in designing competition stages or sports facilities will be best suited for this project. Please, only bid if you can provide a portfolio of similar projects. Mindful planning of stage layout, capacity, visibility, and aesthetic appeals should be demonstrated. Knowledge of safety standards and compliance is of utmost importance. Let's create a stage that competes with the ...
I have an extensive .mbox mailbox file that I need to import into my existing Gmail account. Key Project Details: - The .mbox file is more than 5GB in size, so the job requires someone who is familiar with managing large data transfers. - The file was exported from Gmail, which means the importing process might have some intricacies that need to be navigated. Ideal Freelancer: - Proficient in working with .mbox mailbox files and Gmail. - Experienced with importing large data sets into Gmail without causing any issues. - Excellent problem-solving skills for potential roadblocks in the import process.
I have two photos where I need...two photos where I need the same location, same spot to have the addition of both large and spiderweb cracks. These should be a combination of subtle and prominent cracks, to create a realistic effect. Ideal skills and experience for this job include: - Proficiency in photo editing and manipulation software such as Adobe Photoshop or GIMP - Previous experience with creating realistic effects, such as scratches or cracks - A good eye for detail to ensure the cracks blend well with the original photos - Ability to understand and meet the client's need for a combination of subtle and prominent effects - Understanding the client's need for the photos to be used as a joke on a friend, and being able ...
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
I'm in need of a one-of-a-kind abstract high-resolution floral-botanical art print digital file. This digital file should be suitable for printing at sizes up to 48" x 48". Key Requirements: - The style of the art print should botanical, with no specific restrictions on the type of flowers or botanicals included. See photos. - The color scheme should be based on cool tones, specifically blues, greens ,but with pinks. These colors should be harmoniously blended to create a soothing and aesthetically pleasing piece. - The art print's primary motif should be a large scale floral design. This design should be striking and suitable for wall art in a home. Ideal Skills and Experience: - Proven experience in creating high-quality, or...
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
...a multilayer PCB design. A strong attention to detail and a good understanding of circuit board layout is crucial for this project. Key Requirements: - Proficiency in Altium Designer - Experience with multilayer PCB design with large PCB Boards - Ability to understand and implement complex circuit board layouts - Attention to detail Please provide examples of your previous PCB design work using Altium. A portfolio demonstrating your experience in multilayer PCB design will be highly regarded. This is an LED board which needs layout editing with adding few more components. Please Show your previous work with dense Layout with Noise and Heat Management of components and PCB. Please also specify your availability of work. Attaching few files ...
...for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that wi...
I have a large batch of text data in PDF files that needs to be copied and pasted into a specific format. Key Requirements: - Transfer text data from various PDF files - Ensure accuracy and precision in the copying - The time-sensitive nature of the task - The data must be transferred into a format that is easy to work with Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time constraints
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
You will take screenshots from various reddit subreddits and make a simple video similar to the format of these videos: @rSlash/videos You must be able to create a quick thumbnail similar to the above with each video. Can use ElevanLabs for voiceovers. -You have an eye for detail - no mistakes. -You are able to create a large quantity of videos, and you do not miss your deadline. Budget: $15 per long form video. They will be in batches, and this has potential to be long-term. If interested, please title your application "Video Editor for Faceless Youtube Channel." Add a link to your past editing samples + confirm that you edit in Adobe Premiere Pro. We will proceed with a short trial assignment.
Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to...
I am currently using R, specifically the ppcor package, to conduct partial correlations on a sizable dataset. Unfortunately, the process is slow and fails to address all columns efficiently. I'm seeking assistance to: - Improve the computation speed - Enhance the handling of columns within my dataset The ideal freelancer for this task should be proficient in R programming, with specific experience in working with the ppcor package or similar tools for statistical analysis. A background in optimizing code for large datasets would be highly beneficial.
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
A high resolution interior design (e.g using Vray) of our living room. We like natural materials. We will keep the...our living room. We like natural materials. We will keep the fireplace with black belgian hardstone. We will also keep the same wooden floor. We also plan to keep the large main eating table with the red lamps, but optionally would be open to different lamp colors there. We likely also would like to keep the one dark grey wall on which the TV is positioned as it was recently painted. If possible a Fen Shui aligned design. The windows in the picture are facing west. We are especially looking for design ideas for a new couch, accessories, living room table and lamp. As well as suggestions for where to place plants. Also where ...
I'm in need of an expert content creator to help build up my brand awareness targeting spiritual seekers. Your role will be to create an enticing E-book that will appease their spiritual curiosity and further concrete our brand in their minds. Requirements for this project: - Approximately 50 pages - page ratio 3:5 landscape - Exceptionally creative and outside the box thinker. - Experience creating lead magnet starter kits or creative ebooks. - Excellent content creation skills: you should be able to create an E-book that is both informative and engaging with the art direction of "Ancient Modern.". - A thorough understanding of non-religious spiritual and mindfulness practices: it's important to know what our audience is inte...
I am in need of a professional and experienced technical recruiter who can assist in filling multiple IT Project Manager positions in my company. The role will involve conducting interviews, assessing candidates' suitability, and supporting the hiring process until the positions are successfully filled. Key Responsibilities: - Conducting thorough interviews with potential candidates for the IT Project Manager role. - Assessing candidates' qualifications, skills, and suitability for the position. - Collaborating with the hiring team to shortlist and present the most qualified candidates. - Providing feedback and recommendations on potential hires. Ideal Skills and Experience: - Proven experience as a technical recruiter, particularly in IT-rela...
I need a skilled photographer to take a large number of high-quality images of industrial parts at specific location(s). Requirements: - Expertise in product photography, particularly with industrial parts. - Ability to shoot more than 50 photos. - Flexibility to work on-site at various locations. - Proficiency in lighting and composition. - Prior experience in studio or on-site product photography. Please provide a portfolio showcasing your past relevant work when applying.
...specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyw...
I need assistance with migrating my large WordPress website from GoDaddy to Hostinger. The site is over 100MB in size and includes both custom themes and plugins. Key Requirements: - Migrate large WordPress website (over 100MB) from GoDaddy to Hostinger - Ensure smooth transition of custom themes and plugins I do not require the migration of any email accounts associated with the website. It's crucial that the migration is done swiftly and accurately to avoid disruption to the live site. Ideal Skills and Experience: - Proven experience in large WordPress migrations - Expertise in handling custom themes and plugins - Strong understanding of GoDaddy and Hostinger hosting environments - Excellent communication to...
...freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add anothe...
...professional with expertise in deck design and drafting to create permit-ready prints for a large, more than 200 square feet, composite deck. The final deliverables should be ready-to-submit prints for deck build permit application. The candidate with a thorough understanding of composite materials, city codes, and permit requirements will be preferred. Skills and Experience: - Architectural Drafting - Deck Design - Knowledgeable in composite materials - Awareness of city codes and permit requirements Kindly note, the design is for a plain deck – no extra features like built-in seating, planters, or pergolas are required. I'm looking forward to working with someone who can deliver quality work on time. Please includ...
I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry...
...efficient data entry professional to handle an important task for my project. Your primary role will include: * Entering diverse types of data (both text and images) into a spreadsheet. * The data will be quite varied, so an ability to handle multiple data types effectively is fundamental. * An eye for detail is essential considering the diverse nature of data that will be input. The ideal candidate should possess advanced MS Excel skills and have considerable experience in data entry. Your ability to manage large amounts of data, and ensure it's correctly and promptly entered into the spreadsheet, will be critical to this role. Familiarity with different types of data (text ...
...strong skillset in both Python programming and data science, specifically with a focus on finance who can help complete a project within the next 7 days. Here are the key skills and qualifications I think might be required to successfully complete this project, although I am not experienced in Python so you might find this easier and possible to do well without using as much. > Python Proficiency, as it is the primary tool for this project. > Familiarity with essential Python libraries such as pandas, NumPy, (Matplotlib, Seaborn?), Scikit-learn > Data Science and Analysis: - Data Manipulation: Ability to clean, preprocess, and manipulate large datasets. Skills in visualizing and understanding data tre...
We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natur...
I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new
...for an experienced React + developer to optimize the loading times of my web application. Key Points: - The main issue with the current site seems to be the product pages, which need to have their loading times significantly improved. - Additionally, I suspect that large images or media files, inefficient code or algorithms, and server response times are also contributing to the overall slow performance. - Moreover, I need to update application packages, currently I am using nextjs 9.2.0 and some depreciated libraries. Ideal Candidate: - Proficient in React and to be able to efficiently refactor the code and optimize the loading times. - Experience with image and media optimization, as well as knowledge of best practi...
...storage of photos - Allowing the real estate agent to download the resulting photos via API - Everyone will see the photos they have permission to. He will be able to filter and sort them on a basic basis - Photographer rating system System users: - Broker ◦ Establishes a request for a photo shoot ◦ Selects the date and service ◦ Sees his orders including the resulting photos ◦ Evaluates - Photographer ◦ Sees assigned jobs with a schedule (calendar) of jobs ◦ Confirms the job ◦ Inserts the resulting photos ◦ Sees your historical orders as well Here is the necessary screens: ### 1. Login Screen - **Purpose:** Allow users (brokers and photographers) to log in. -...
We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existi...
I have a large set of handwritten notes that need to be accurately transcribed into digital format. I need someone who is meticulous and has a keen eye for detail, as the work needs to be done with no errors. Key Requirements: - Type of Job: Data Entry - Data Format: Handwritten notes - Level of Accuracy: Very High (no errors acceptable) Ideal Skills: - Proficient in typing - Detail-oriented - Experience in data entry, particularly with handwritten notes - Ability to follow instructions accurately and efficiently Your task is to convert these notes into a digital format, ensuring every detail is captured accurately. Your attention to detail and commitment to producing error-free work is crucial.
I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.
As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation
I am in need of a document management software that will be compatible with Windows& Mac. This software is intended for use by business professionals, so it should be user-friendly, efficient, and secure. Key Features: - The software should include a document scanning feature, making it easier for users to transfer physical documents into the digital realm. - It should also offer a filing system that is organized and intuitive, ensuring that users can easily locate and retrieve the documents they need. I require a freelancer who has experience in developing document management software, particularly for Windows. The software should be designed to handle a large volume of documents while maintaining high performance. A strong understanding of cyb...
I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dos...
...business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be c...
I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.
I need a reliable and methodical eBay spec...account management for over 100 items. Both physical and digital products are included, so it's essential for this role to be able to handle various types of merchandise. Key Responsibilities: - Accurate and efficient listing of products, ensuring all information is complete and presented attractively - Regularly reviewing, updating, and optimizing listings for improved visibility and increased sales, utilizing your understanding of SEO - Overseeing inventory management system to ensure product availability and prevent overselling Ideally, you'll have prior experience with managing large inventories on eBay and possess a keen understanding of the eBay SEO algorithms. Attention to detail and excelle...
I am looking for a skilled freelancer to help convert 12 simple floor plans into editable layouts suitable for creating evacuation maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on evacua...
I'm in need of a Power BI expert with solid experience in AI integration and advanced dashboard development. The project has multiple facets, including: - Data Cleaning and Transformation: The ideal candidate will have experience in working with large and complex databases. You should be able to clean and transform the data efficiently for integration into the dashboard. - Dashboard Design and Development: An eye for design is key. You will be creating a visually appealing and user-friendly dashboard, with the ability to customize as needed. - AI Model Integration: Extensive experience with AI integration is a must. You should be able to develop and integrate advanced AI models within the dashboard effectively. The main ...
I'm in need of a Python application that can connect around 200 Android and iPhone devices to a PC via USB cables, allowing me to perform various automated tasks and workflows on them. Key Requirements: - **Bulk Control**: The app should be able to interact with all connected phones simultaneously. I should be able to create and assign tasks to each phone individually, or define tasks that apply to all devices. - **Task Automation**: I need the app to automate several types of tasks, which include: - Web browsing or searches: The app should be able to instruct the phones to browse certain websites or perform specific searches. - App testing or usage: The app should be capable of launching and interacting with v...
...your offer with the word in the attachment, otherwise we dropp you out. We are looking for a database with websites, HAVING EMBEDDED YOUTUBE Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we hav...
I'm looking to hire a seasoned sales manager who can oversee one of our sellers. The ideal candidate will focus only on sales and supporting our seller with strategies and sales targets. Key Responsibilities: - Managing the sales the strategy of our sales. - Developing and implementing strategies to increase sales Requirements: - Proven experience in physical product sales - Excellent knowledge of different sales channels, particularly physical retail - Strong communication and negotiation skills - Ability to work independently and drive sales goals Since the role is concentrated on sales, there's no need to handle customer inquiries. So, the ideal candidate should be someone who excels at sales strategies and execution. We do sell food...
I'm looking ...talented designers who specialize in crockery design, specifically focusing on dinnerware and serveware. The design style should be predominantly modern. Key Requirements: - Design modern-style plates, bowls, and cups. - Provide conceptual plans and concrete design blueprints for mass production. - Experience in ceramics or glassware design is a plus. Ideal skills: - Strong creative and art skills - Knowledge of current design trends related to dinnerware and serveware. - In-depth understanding of materials utilized in production, predominantly ceramics - Ability to create designs suitable for large scale manufacturing. I am aiming to create a unified and appealing dinnerware and serveware collection, your exp...
...field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date ...
I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.
...able to understand ReactJS but also understand a large existing project with little help from me. We're looking for a full-time programmer who is hard working, honest, and enjoys learning. Are you the kind of person where your yes means yes and your no means no? Do you have several years of programming experience with all things ReactJS? Place, "ReactJS developer" on the top of your bid. This full-time position requires attention to detail - someone that understands spoken and written English, fluently. We have enough work for over a year. On the top, after "ReactJS developer", please tell me what was your most difficult ReactJS project you completed and why. Also, how many years of ReactJS experience do you have? Read this job des...
