Excel refresh query column order change jobs
I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.
...advantage. The data available for this project includes some scanned exam files. The output I need requires cropped images from the required coordinates so that each different question is saved into different folder, and the name of the files are given as the number of questions. For example: "Math_14", "Math_15". So the most important text that is required to be accurately read is the number/order of questions. Very close example of what I've tried so far is the following. It did not work well with the examples I used but the methodology should be something similar: I am also attaching some pdf files as I've mentioned. I also have a draft code which does not work as accurate but I can share
I have an excel file, need add product categorie on a column - budget 100€
Hi there! I'm in need of a talented graphic designer to help create eye-catching images for my Twitter account. I have a character that I'll provide, and I need images that incorporate this char...detail and the ability to follow specific guidelines Availability to provide 2-3 images daily on a long-term basis Good communication skills and the ability to take feedback constructively If you're passionate about graphic design and interested in working on this exciting project, please submit your proposal along with samples of your previous work showcasing your design skills and creativity. I ORDER TO START THE WORK I NEED YOU TO PROVIDE ME AND IMAGE AS AN EXAMPLE !!! PLEASE ISPIRE FROM THIS TWITEER ACCOUNT AS AN EXAMPLE : Looking forward to collaborating with you!
I'm looking for someone who can secure orders for affordable men's and women's leather handbags and backpacks. Ideal Skills and Experience: - Previous experience in leather goods sales or procurement is a plus. - Good network in the bag industry, especially with suppliers of affordable leather goods. - Excellent negotiation and communication skills to secure orders with the desired price range in mind. - Understanding of the current trends in bag and fashion industry is a plus. I need someone who can efficiently work to secure these orders so I can focus on other aspects of my business. Please reach out if you think you're a good fit for this project.
I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables,...
Project 1: You should write a program implementing the calculator's functionality. Interface appearance use graphic buttons (this may be the simplest graphic with a color change), the result of the operation can be presented in the form of binary, octal hexadecimal (additional buttons), enter the history button: opening a new window with information about the actions taken since the application was started, showing the actions in the following lines of the list. Project 2. Create a Music MP3 player mobile application in Flutter or in Android Studio that recommends its users the local area popular songs based on their GPS location. Submit the source code and the apk file as Task2.zip. Project 3. Create a Mobile Application for a Cafe Restaurant to receive orders from its Cus...
Hello, I need complet the Amazon categories catalogue excel in french
...assist in fixing existing and add new back-end functionality. Our platform allows parents to book their children's lunch boxes for selected schools, offering multiple choices for the boxes. Parents can select the school and timings through dropdown menus. We receive the details on our dashboard and print stickers to be pasted on the boxes. Currently, we are facing issues with obtaining accurate order details, leading to mismanagement and manual intervention. We also want to integrate a monthly subscription feature for parents. The ideal candidate should have a strong understanding of PHP and be able to create clean, efficient, and scalable code. As a PHP Developer, you will be responsible for implementing new features, improving existing functionality, and ensuring seamles...
I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.
...and Canada. I am a dual citizen of Canada and the USA, having obtained my US citizenship in 2020. Due to a recent move to Arizona and plans to sponsor my wife for her green card, I have discovered the need to file my Canadian taxes with the USA. I require an experienced and licensed accountant who specializes in both US and Canadian tax laws, particularly for dual citizens, to get my taxes in order promptly. Responsibilities: File Canadian tax returns for the years since obtaining US citizenship in 2020. Ensure compliance with both Canadian and US tax laws and regulations. Provide accurate and timely filing of all necessary documents. Assist with any additional tax-related queries or issues that may arise during the process. Provide guidance and support for the green card spon...
...automated order processing and menu synchronization. Key Features: - The system should be able to automatically process orders received through Swiggy and Zomato. This should eliminate the need for manual intervention, ensuring a streamlined and efficient order management process. - Menu synchronization between the POS system and Swiggy/Zomato is crucial. This means that any changes made to the menu on the POS system should be reflected on the online platforms and vice versa. Skills and Experience: - Experience with integrating POS systems with external platforms, particularly in the food industry, would be highly beneficial. - Proficiency in building robust, real-time data synchronization systems is key. - Prior experience with Swiggy and Zomato APIs and understand...
...non-professional freelancer. Unfortunately, after less than a week, the system has stopped working. I found out recently he has installed the application in Centos 7 (Linux) instead of Windows against my guidelines. In light of this, I am seeking a highly skilled professional to help me reinstall the system from the copy to the Window Server 2016 environment. The job involves the following steps: 1) Change the OS from Linex to Windows Server 2016 or Higher Use the copies of the site and desktop (will be uploaded when you accept the job) 2) Download Windows Server 2016 II, Office 2019, , .NET Framework 4.7 or 4.8, Visual FoxPro 9 Executable. And it should be Configured to the present environment. 3) The on-line application should be connected to the desktop version and tested. 4...
...design is must to choose font, color and other style elements. So I need the design and develop both skills. Please start your proposal with world "confident" so that I filter out random bids. I will provide text content for image, gif you have to use copyright free assets from internet. Task - Change the menu options and their styling to fit with the landing page - Header and Footer - Landing Page --- Vertical slider of 4 pages, paging enabled. When scroll up and down complete page should change. In left side I want the page number indicator too. Each lider will have different background color and background gif for animation. --- Static section --- Static section with decent animations --- Static section --- Static section My budget for this is limited to I...
...skilled developer to create a customized inventory management app using Google AppSheet and MySQL. The app will cater to a user base of less than 50, but it needs to be designed and optimized for scalable growth. It should be intuitive, easy to use, and have a professional interface. Key features that need to be incorporated into the app include: - Real-time inventory tracking - Sales and purchase order management - Product barcode scanning As the app will be handling crucial data for my business, security and reliability are of utmost importance. The developer should have experience in creating and integrating secure databases, as well as a track record of building robust, scalable applications. The successful freelancer should have: - Proficiency in Google AppSheet and MyS...
I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.
I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.
I'm seeking a talented DJ/audio engineer who can remix and transform four audio clips into a 2-5 minute piece of high-quality sound. The project involves: - Improving voice clarity and power: The original voice is a bit unclear, and I need it to be more distinct and commanding. - Adding a unique touch: I'm looking for someone who can bring their own creativity and uniqueness ...particularly with voice enhancement. - A creative and innovative approach to audio production. - The ability to work with various audio genres and styles to create a cohesive and engaging final product. This project is perfect for an experienced audio engineer looking to showcase their skills in a challenging and creative environment. The name of the song is Midnight Drive. The uploaded clips are in ...
...success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into actionable website goals. Selling Solutions: You'll present our web design packages with confidence, highlighting the value we br...
I'm in ...While experience with Zoho Creator is not a strict requirement, it would be beneficial. The main goal of this project is to develop an ERP system that will handle inventory management and sales/order processing. We will need to connect for already created ERP system first. Key aspects of this project will include: - Developing a customized ERP solution from scratch - Implementing inventory management features - Integrating sales and order processing functionalities Ideal candidates should have: - Proven experience in developing ERP systems - Strong understanding of inventory management and sales/order processing - Proficiency in Zoho Creator (or any other ERP system if not Zoho Creator) This is an urgent requirement, so please only apply if you are av...
...integrating 2 instances of Unleashed. The primary goal is to optimize 3pl, ordering and inventory management by streamlining the process across both instances. Must be able to get Unleashed platform to talk to our clients unleashed account. Providing live stock updates order from one to another live and automating all this. This will need to be completed this week and no later as we have a tight deadline to achieve this. Flow Chart, Shopify Order > Unleashed > (Updates stock levels on clients unleashed as well as our own)> Send order to clients unleashed. Client uploads new stock > updates our unleashed account. Key Tasks: - Inventory Management: Ensure that inventory data is synchronized in real-time between the two instances of Unleashed. This wi...
...functionalities of Tally. The portal should have the following main features: - Accounting Features - Inventory Management Features - Sales Management Features In terms of the accounting features, I require: - General Ledger - Accounts Receivable - Accounts Payable For the inventory management features, it's essential that the portal includes: - Inventory Tracking - Stock Alerts - Purchase Order Management Given the complexity of the project, I am looking for a professional with prior experience in creating similar online portals. Proficiency in both back-end and front-end development is crucial. A good understanding of accounting and inventory principles is a bonus, as this will help in making the portal more intuitive and user-friendly. Please provide examples of yo...
I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of conditional formatting and ot...
I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula
I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks
I am seeking a proficient editor to correct the grammar and punctuation in my short story. The story is written in the genre of literary fiction and hence an appreciation for this genre of storytelling would be beneficial. While I want to retain the originality of the story, necessary changes are welcomed in order to correct errors that may distract from the narrative. The ideal freelancer for this project would have: - A strong grasp of grammar and punctuation rules - Experience in editing literary fiction - Ability to maintain the original voice of the author - Keen attention to detail I look forward to working with you to refine my story and enhance its literary quality.
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I need a skilled programmer for a crucial task: changing all website links and references from . to .au. The project is intended for an existing business site. Additionally, we will require the professional to update SEO settings in all lines of code to reflect the .au domain replacing . Key Responsibilities: - Convert all references of . to .au throughout the entire website - Update SEO settings to accommodate the new domain - Ensure smooth transition without any loss of data or functionality Ideal Candidate: - Proficient in web development and coding - Extensive experience with SEO and domain migration - Attention to detail to ensure no broken links or missing references - Excellent communication skills to provide updates and seek clarification - Familiarity with the business context ...
I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...
Looki...Networking related deck. Need some info-graphics designed and built as required for some slides. Looking for someone who has experience in designing and building highly Technical yet creative PPT slide decks. Someone who can act quickly and deliver the project ASAP. Prefer someone who can showcase their portfolio of similar work. We will share the color scheme and some guidelines to be followed in-order to work on this project. Would prefer a professional who can stick to the guidelines and be creative accordingly and maintain a very clear prompt communication on the requirements and progress of the project. If the work and the professionalism is something that aligns with us, we will continue to give more similar work in the future. We are looking for a long-term engage...
I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...
Simple, user make a purchase on site A then is redirected to site B to make the payment and then is redirected to site A again I am looking for a skilled developer with experience in cloaking payment gateways, specifically Stripe. The project involves cloaking both transaction details, payer information, and order info. Requirements: - Expertise in cloaking payment gateways, specifically Stripe - Ability to cloak both transaction details and payer information and order info.
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 logical conditions for accurate and efficient data arrangement. - Po...
...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...
...expected value (EV) bets within the sports betting market and also arbitrage bets, live positive EV bets and live arbitrage bets on the websites specified in the attached file. The formulas for Positive EV bets can be found on the following website. The software needs to compare the odds to the odds of , obviously following the adding of the vig (pinnacle's profit margin) to the odds, in order to receive the true odds: The software needs to run as a website that only I can access, with a similar layout to that of , as seen on the picture attached. I will also need you to send me the source code following the completion of the project. With betfair both the sportsbook and exchange odds should be taken into consideration
I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...
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 have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it
I need to modify the software of the speedometer and DVD touch screen in my Honda Grace 2018 EX. Both are currently in Japanese, and I'd like them to be changed to English. The main tasks for the project include: - Changing the speedometer language from Japanese to English - Modifying the software of the DVD touch screen, also from Japanese to English Since I don't have the necessary tools or software for these modifications, I'm looking for a professional who can provide the expertise and tools required to complete this task. Ideal skills and experience for this job: - Proficient in software modification for car devices - Experience in Honda car systems is a plus - Ability to provide the necessary tools and software for the modification.
I require professional assistance to transition the property deed, currently under an individual's name, to a trust. The property in question is a residential one in renton, wahsington state. - Transfer of Deed: Need to transfer residential property deed from an individual's name to a trust. - Deed expertise: Familiarity with property law, especially related to the transfer and change of deeds is crucial. The ideal applicant for this task would have a proven track record in handling such transitions with a deep understanding of the legal implications and process involved. Legal background and previous experience in real estate law are a must.
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.
To integrate my Elmo alarm system with openHAB through bi-directional binding, I need a developer with openHAB and Elmo experience. The binding should be developed...my Elmo alarm system with openHAB through bi-directional binding, I need a developer with openHAB and Elmo experience. The binding should be developed for E-connect, Elmo's cloud integration model. The features I'm after are: - Arm/Disarm functionality - Real-time status updates - Alarm event notifications - Sensing and sending sensor status to openHAB items. Anytime there's an event, status change, or a sensor goes on/off, I need the binding to provide immediate updates. Your skills in openHAB binding, Java, and IoT integrations will be essential for this project. The same project is just written in...
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.
I'm looking for an innovative designer who can create a multi-step order form for my Food Delivery service. The form should include essential fields such as customer information, payment details, and order customisation options. Key responsibilities: - Designing a user-friendly multi-step order form - Including customer information, payment details, and order customisation options - Presenting order customisation options using dropdown menus and checkboxes Ideal skills for this project include: - Proficiency in UI/UX design - Experience with form design - Strong attention to detail - Ability to create a seamless user experience
I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...
...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 inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the ch...
I'm the owner of a WordPress website and have administrative access. I'm looking for a skilled developer to help me change the admin email without altering the username, password, or other settings. The primary reason for this change is to ensure that the contact information displayed is up-to-date. Key requirements include: - Updating the admin email: The new email address will be provided to the selected freelancer. - Maintaining username and password: It's crucial that these details remain unchanged. - Preserving other settings: The current configurations, including security measures and other account settings, should not be affected. Ideal skills and experience for this job: - Proficiency in WordPress: The ideal candidate should have a strong background ...
...currently leveraging several Zoho applications including CRM, Books, Inventory, People, Recruit, Shifts, Project, Survey, and Forms. I am seeking a skilled freelancer who can effectively integrate these applications with our existing ERP system. Key project aims include: - Customer data synchronization: Ensuring consistent, accurate customer information across platforms. - Order management integration: Streamlining order processes for increased business efficiency. - Inventory management synchronization: Maintaining real-time, synchronized inventory data between Zoho and ERP. With 11-50 users expected to utilize this integrated system, the ideal freelancer should not only possess strong experience with Zoho One and ERP integrations but also have a deep understand...
