Vbscript update excel pivot tabledela
...and calculate completion percentages. - Data sorting and filtering functionalities are a must. I want to be able to sort my tasks by due date, priority or completion status. - Conditional formatting is also needed. I'd like the cells to change color based on task status (e.g., incomplete, complete, overdue). Platform and Updating: - I prefer the use of Google Sheets for this project. - I plan to update the spreadsheet manually. This means that the sheet should be user-friendly and easy to navigate, with clear headings and sections that I can easily edit and add to. Ideal Skills: - Proficiency in Google Sheets and advanced knowledge of its functionalities. - Experience in creating automated spreadsheets with features like automatic calculations, data sorting/filtering, and ...
I am in need of a skilled Excel professional who can create a comprehensive Excel dashboard focused on data analysis. The dashboard will integrate with various Excel files to provide real-time data updates. Key Requirements: - Create an Excel dashboard that primarily focuses on data analysis - Integrate the dashboard with multiple Excel files - Ensure that the data updates are in real-time Ideal Skills: - Proficiency in Excel - Experience in creating complex and dynamic dashboards - Knowledge of data analysis techniques - Familiarity with real-time data integration This project is ideal for an Excel expert who can not only design a visually appealing dashboard but also ensure that it is highly functional for data analysis purposes.
...a project of enhancing the visual appeal of an existing Excel spreadsheet. This entails more than just a simple makeover, but applies a professional visual identity to the spreadsheet. The spreadsheet is a database to show service times and the parts required for that service. I need it to be easy to read and professional. You can use our logo. Key Responsibilities: - I would like customized fonts and formatting integrated throughout. This isn't limited to a specific area, so use your judgment to decide what gets modified. It's essential that the spreadsheet no longer resembles a generic 'Excel' one. - I want the spreadsheet to look and feel intuitive, maintaining the professional aesthetic. Preferred Skills: - Mastery of Excel and its vari...
...goal of the website is to attract clients. It should reflect my professional style and offer a clear insight into my achievements and capabilities. - **Content:** I want to include various types of projects on the website, anything from design projects to software development. This means, the website should be designed in a way that can accommodate different types of visuals and content. - **Update Frequency:** While the core content might remain the same, I plan on updating the website with new achievements quarterly. Hence, the site should be designed in a way that allows for easy and regular updates. The ideal freelancer for this project should have a strong portfolio in web design, and a good understanding of user experience and client attraction. A good grasp of SEO and o...
We seek an Excel expert with experience in developing Bill of Materials (BOM) and Inventory management solutions tailored for small home businesses. The focus is on simplicity and functionality without the need for a commercial product presentation. **Key Features Needed:** - A user-friendly Excel workbook that manages electronic components, their stock levels, and inventory updates post-sales efficiently. - BOM creation from inventory items with an ability to incorporate "other costs" into each assembly. - Stock purchase entries should automatically update inventory quantities and costs. - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system should a...
I'm seeking an individual who is well-versed with Excel for data entry tasks. This primarily involves typing and organizing data. Here's what you'll be doing: - Typing out data and organizing it in Excel spreadsheets - Ensuring accuracy and efficiency in data entry Applications should include: - Examples of past work, particularly those related to data entry and Excel Ideal freelancers for this job are those who: - Have prior experience in data entry - Are proficient in using Excel - Possess strong attention to detail, ensuring accuracy in their work.
I am in need of a skilled web developer who can help me build a Wordpress website. The site will serve as a content management system with a few specific features integrated into it. Key features I need: - Content Management System: The main purpose of the site is to manage and update content. - WhatsApp Button: I'd like to have a WhatsApp button integrated on the site for easy communication. - Inquiry Form: The site should have a built-in inquiry form for user engagement. - Easy Content and Picture Change: The site should allow for easy, user-friendly content and picture updates. Requirements: - Proficiency in Wordpress: The developer should be experienced in building websites in Wordpress. - Front-end Development Skills: A good understanding of front-end development will...
...developing and maintaining desktop applications using ElectronJS, building and managing user interfaces with ReactJS, and implementing OpenCV and TensorFlow. Additionally, the role requires the ability to read and manipulate Excel files using ExcelJS. The candidate should be proficient in JavaScript and have a strong understanding of its ecosystem. They should possess extensive experience with ElectronJS for building cross-platform desktop applications. Familiarity with OpenCV and TensorFlow is essential, as is experience with ExcelJS or similar libraries for handling Excel files. This project aims to develop a desktop application using that allows users to create custom OMR (Optical Mark Recognition) sheets with questions and multiple-choice options. The applicatio...
I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.
I'm in need of a skilled individual who can scrape data from various websites for the purpose of lead generation. The data should be delivered in Excel or CSV format. Key Requirements: - Proficient in web scraping - Experience with lead generation - Ability to deliver data in Excel/CSV Ideal Skills: - Proficiency in Python/R for web scraping - Previous experience in similar projects - Strong understanding of lead generation techniques If you have experience in web scraping and lead generation, I'd love to hear from you.
saya among dan saya bisa mengoperasikan excel dan saya siap bekrjasama.
I'm seeking a video creator to produce a 1-3 minute promotional video for our esteemed "Postgraduate Diploma in Counselling Psychology" program. The video will target career changers specifically. Key requirements and details: - The video should effectively highlight the program's three main selling points: its course recognition by Singapore Association of Counselli...platforms. The ideal candidate for this job will have: - Proven experience in creating promotional videos, ideally for educational programs or courses - A solid understanding of the psychology of career changers and how to appeal to this specific audience - Excellent storytelling and video editing skills to bring our program's unique strengths to life If this project sounds like something you'...
...need of a Python expert who can develop a content spinning tool for me. The tool should be capable of automatically generating unique variations of basic text, like blog posts and articles. Key Requirements: - I'm looking for a tool that can automatically generate spun content from existing text, without any manual input needed. - File upload option - If I upload an Excel sheet, the tool spin content in that sheet and export excel sheet with spin content. - It needs to be able to handle the text complexity level of blog posts and articles, 50-500 words - THe purpose of this tool is to rewrite content to make content ZeropGPT free Ideal Skills: - Proficiency in Python programming. - Prior experience in developing content spinning tools. - Knowledge of natural langu...
...and interpersonal skills. - Self-motivated and able to work independently. - Strong organizational and time management skills. Lead Generation: - We envision the BDR primarily finding and identifying new leads through online research. This means you should know how to navigate online platforms, professional networks, and industry groups to find potential clients and opportunities. - Maintain and update our CRM with new leads and client information. - Schedule meetings and follow up with leads to move them through the sales pipeline. Cold Outreach Platforms: - You'll be expected to utilize LinkedIn, Facebook, and Email for cold outreach. Your understanding of these platforms and how to leverage them for business development is key to the success of this project. If you ar...
...an Excel table. The icons are for various amenities that will be listed on a real estate website. Responsibilities: • Search for icons on that match the list of amenities provided. The premium version of Flaticon may be used. • Ensure each icon matches the style and aesthetic suitable for a modern real estate website (in the style as attached files). • Document each icon in an Excel table with two columns: Title and Classname. List of Amenities: • See attached file. Requirements: • Experience with and familiarity with downloading and organizing icons. • Proficiency in Excel. • Attention to detail to ensure the icons are correctly matched to the amenity titles. • Ability to deliver the task within a specif...
I'm in need of meticulous and organized professional who can effectively manage data entry, document organization, and scheduling tasks. The scope of the project includes: - Streamlining data entry processes - Organizing and managing key documents, specifically financial statements - Handling a dynamic schedule effectively The ideal candidate should be proficient with Microsoft Excel and Google Suite (Docs, Sheets, Calendar). Your expertise will help us improve our administrative operations efficiently and effectively.
I need a freelancer to convert a series of simple, text-based PDF documents into Word. Your job is to ensure that the text in the Word documents is fully editable, and that the original formatting is preserved. Key Responsibilities: - Con...errors or omissions. - Preserve the original formatting of the documents in the Word version. Ideal Candidate: - Proven experience in PDF to Word conversion, especially with multiple documents. - Proficient in software for text extraction and formatting preservation. - Attention to detail and ability to meet deadlines. Please note that the documents are text-only, so no experience with image or table conversion is required. This is a project with a potential for ongoing work, so a freelancer with good communication and reliability is highly ...
I have an Excel file that needs to be formatted with some basic arithmetic formulas. Key Requirements: - I need the data in the cells to be formatted to phone number style. - Basic arithmetic formulas are required for this project. The level of statistical analysis you'd need to provide is basic, such as mean, median, or mode. Ideal Skills/Experience: - Proficiency in Excel and formulas is a must. - Experience with basic statistical analysis is preferred. Please get in touch with your credentials and prior work samples. Thank you.
I'm looking to update the design of my website, www.comansservices.com.au. The current design is a bit outdated, so I'm keen to give it a more modern and sleek look. Key aspects of the project include: - **Visual Overhaul**: The primary goal is to refresh the visual elements to align with modern aesthetics. This will involve a complete redesign of the website's look and feel while keeping the existing content and functionality intact. - **Parallax Scrolling**: I'm interested in incorporating parallax scrolling into the design. This will help make the website more interactive and engaging for visitors. It already has some scrolling effects applied I want to keep them or improve them. - **Content and Picture Update:** I have a design brief which includes...
i need a web scraper for get the info of , i need some spepecific info (payments transactions) and put this info in a table in mysql. please fell free to ask
Prosimo, vpišite se ali se prijavite za več podrobnosti.
I need a detailed spreadsheet of information taken from public meetings. The content I'm seeking to compile involves: - Date of the meeting - Detailed descriptions of action items that were voted on, including the specific amounts. In this assignment, precision, attention to detail, and understanding of meeting notes is crucial. Mastery of Excel and experience handling similar tasks is required. Familiarity with action items and the voting process in public meetings will be a plus.
I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.
This is the variant table with these fields CREATE TABLE ( id varchar(255) NOT NULL DEFAULT uuid_generate_v4(), name_lang json NOT NULL DEFAULT '{}'::json, data_area varchar(255) NULL, description json NULL DEFAULT '{}'::json, "type" bit(1) NULL, active bool NULL, created_by varchar(128) NOT NULL DEFAULT 'system'::character varying, created_on timestamp NOT NULL DEFAULT now(), updated_by varchar(128) NOT NULL DEFAULT 'system'::character varying, updated_on timestamp NOT NULL DEFAULT now(), CONSTRAINT category_pkey_1 PRIMARY KEY (id) ); this is the variant data table with these fields CREATE TABLE public.variant_data ( id varchar(255) NOT NULL DEFAULT uuid_generate_v4(), name_lang json NO...
I need a tool that can scrape text content and tables from LinkedIn quickly and efficiently into an Excel format. The tool needs to be able to: - Extract text content and tables from LinkedIn - Export the scraped information into Excel format - Operate quickly and efficiently to meet a tight deadline The ideal candidate should have: - Experience in web scraping, particularly with LinkedIn - Proficiency in Excel - Ability to develop a tool that can operate quickly and effectively Given the urgency of this project, I need someone who can start ASAP and deliver the tool in a timely manner. Experience with rapid tool development would be a huge plus.
I need an experienced video editor/content creator to produce three short video adds I want to use to announce...Proficient in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro) - Experienced in creating content for various social media platforms, particularly Facebook, TikTok, and YouTube - Highly creative with a strong visual aesthetic - Knowledge of copyright laws and usage of royalty-free music - Strong communication skills to understand and execute my vision If this sounds like a project you'd excel at, I'd love to see some examples of your previous work preferably a college home coming event or alumni reunion event announcement teaser video. I will provide longer version videos of past events. You'll need to use shorter clips from the long video...
...skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong bac...
...this project is a web application. The chosen individual will need to be proficient in Angular to build a smooth and responsive user interface. - **API Development**: In addition to the web app, you'll need to create a backend API that communicates with the database. This API should serve the required data to the Angular frontend. - **Real-time Status Updates**: The application should be able to update the user in real-time with the latest trade and progress data. This will require good understanding of data streaming and Angular's capabilities in handling real-time data. - **Data Visualization**: The app will also need a data visualization component, like charts or graphs, for displaying the provided data. Experience with data visualization libraries in Angular or s...
...that needs to be adjusted and extended to match the specifications outlined in my requirements sheet. This project involves updating the current design to enhance usability, functionality, and aesthetics based on detailed requirements. Key Responsibilities: Review the existing UI/UX design of the POS system. Analyze the requirements sheet to understand the specified enhancements and extensions. Update and extend the current design to align with the specified UI/UX requirements. Ensure the new design improves user experience, accessibility, and functionality. Collaborate with me to iterate on design changes and incorporate feedback. Deliver high-quality design assets and documentation. Requirements: Proven experience in UI/UX design, specifically for POS systems or similar appl...
I have a user profile with Buddypress and need 4 single posts added to the user profile page. These single posts are already created. They should follow the same template for all users. Key Requirements: - Custom code development for Buddypress to add 4 single posts to user profiles. - These single posts should update dynamically based on users' activity. - Activities that should trigger updates include user posting a new article or comment, and when the user updates their profile information. Ideal Freelancer: - Proficient in Buddypress development and customization. - Skilled in PHP and WordPress to create custom codes. - Experience in integrating dynamic content based on user activity. - Familiarity with handling user interaction triggers for content updates. - Good unders...
...developer with a solid understanding of event-driven architecture. The project involves developing a web application with certain key functionalities. Key Functionalities: - User Authentication and Authorization: The application should have a secure and robust user management system with authentication and authorization features. - CRUD Operations: The developer needs to implement Create, Read, Update, and Delete operations for the application's data. Requirements: - Profound knowledge in Event-Driven Architecture: Understanding of event-driven architecture is essential for the successful implementation of this project. - REST API Development: Extensive experience in developing REST APIs is necessary. - Web Development: The target platform for this project is the web; hen...
I'm currently looking for a talented designer to create a compelling banner for my website. The aim of the project is to enhance the branding of the site and attract more visitors. Your responsibilities would include: - Crafting a banner with unique, photographic imagery that ties cohesively into the c...be 1280px x 320px - I just want to convert this poster that is attached into a banner, nothing different Ideal candidates should have: - Proven graphic design skills with a strong portfolio - Experience in creating branded banners - Experience with photography-based design - Attention to detail - A keen eye for aesthetics and visual details I'm excited to see what ideas you can bring to the table, so please feel free to show your creativity. Let's create somet...
...communicating. Add options—color, trendlines, legend, other? Calculate the mean, median, mode, and standard deviation of the adjusted daily closing stock price. Put answers of calculations in table format. Write several sentences explaining the process by which you calculated these statistics. Calculate the mean, median, mode, and standard deviation of the stock volume. Put in table format for easy review. Write a sentence explaining the process by which you calculated these statistics. Ideal freelancers for this project would be those experienced in statistical analysis and data visualization. Skills in using tools like Excel. If this sounds like your kind of project, get in touch and showcase your skills. The information to use is attached...
I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus
I've been running BLOG site for about 6-12 months with a daily content update schedule. I've been disapproved by Adsense 3 times and need someone to solve and get it approved. Key points: - I specialize in textual articles/blogs. - New content is added daily. - The site is well-established, but I've been unsuccessful in getting Adsense approval. - I'm looking for someone with a proven track record of getting Adsense approvals for similar sites. - Experience with Adsense policies and guidelines is a must. - Good communication skills are a plus, as I prefer being kept informed about the process. If you have prior proof of success getting rejected sites approved, show me, and you get the job.
I need a structural engineer to update existing plans for an interior home remodel to submit to the City of Henderson, NV for an owner/builder permit. MUST be able to STAMP the plans and be licensed in NEVADA, USA. The city wants drawings from an engineer mainly for the following: (complete plans to be discussed if you are interested in this assignment) -replacement of two windows to two larger windows with new header to carry load of second floor above -replacement of a double front door with glass block sidelights to a single pivot door with larger glass sidelights with new header to carry load of second floor above. Window and door manufacturer to supply engineering specs to engineer -removal of upstairs fireplace and replace with wall and new opening to primary bath (n...
I need a professional PHP developer to update my current PHP script. The script currently uses PHP mailer to send emails using normal login (Less Secure Apps) authentication. The new Gmail security measures will require the use of Oauth for authentication. The ideal candidate should have: - Strong PHP skills and experience with PHP 7 - Expertise in PHPMailer and setting up email services, specifically Gmail - Solid understanding of OAuth authentication - Experience with updating scripts to accommodate new security measures - Good problem-solving skills to ensure the script remains fully functional post-update
I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.
I'm looking for an interior designer to completely transform my living room into a minimalist haven. My living room is less than 40 square mt and I am interested in a simple yet sophisticated aesthetic. Key tasks include: * Analyzing the current state of the room and suggesting improvements * Developing a new layout plan * Providing a minimalist design concept that m...small spaces effectively Your bid should include design plan, sourcing furnishings and accessories, and implementation oversight. The room will be completely empty because the couch and other furniture will be removed. The flooring will stay the same bevande I would like to valorize it. Things that are mandatory to fit in the living room are: - smaller but a little darker couch - TV - dining table - vertic...
I'm looking for a WordPress expert to help with crucial updates on my website. The project consists primarily of content updates, along with special focus on updating various plugins. Key Responsibilities: • Updating content as per provided instructions • Updating and troubleshooting three specific plugins: Yoast SEO, WooCommerce, and Contact Form 7 Ideal Skills: • Strong expertise in WordPress • Prior experience with Yoast SEO, WooCommerce, and Contact Form 7 plugins • Attention to detail for subtle content updates. Let's enhance my website together!
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add ...
I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.
The target is to write a Java, console program (public static void main) that will generate a docx Word file. Program needs to use docx4j library () Programm needs to generate many parts: Heading1, Heading2, Heading3, every with some content (lorem ipsum) Make a table of contents (showing on which page is a given Heading1, Heading2, Heading3 - not hard coded, but detected) Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 In the text put links to a concrete Headings, eg. "read in Heading2 - abc (page 4)" - it should be link to this section and "(page 4)" should Make a footer showing the number of page and first Heading on the
...focused on managing a restaurant's operations. The UI should be user-friendly and ideally suited for a restaurant environment. Key Features: - Order Management: I need the UI to include order tracking and menu customization features. I also require the ability to visualize the restaurant's floor layout to manage the orders efficiently. - Table Management: The UI must allow for table reservations, status updates, and merging. It should help in optimizing table assignments and order efficiency. - Inventory Management: The UI should support managing the restaurant's inventory to streamline operations and track costs. - Staff Management: I need a simple way to manage staff - from assigning tables, tracking orders, and ensuring smooth service. Ideal Cand...
...responsible for keeping track of both pricing and product availability. A high level of accuracy is essential. Update frequency should be configurable. This script should be written in an efficient language. As I have no specific preference, I trust your judgement on choosing a language that is effective for the required task. Ideal requirements: - Proven experience in developing similar scripts - Knowledge of and experience with eCommerce website structures - Accurate and detail-oriented developers are highly essestial. Your proposal should include the language you intend to use and why you think it would be the most suitable. Please also mention how frequently the script will update the information. Start your bid with "Tracker Guru" to help me filter ou...
I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.
I am seeking a talented architect/interior designer to conceptualize a small capacity (up to 50 people) e-sport arena. This space should be multi-purpose, with areas for table top and card games, "video game tables", as well as adaptable space for B2B events or co-working. Key project elements: - The e-sport gaming area is the central focus. - A comfortable and homey interior design style is preferred. - Despite the diverse usage, the space should flow naturally and cohesively. - Incorporate dining areas where players can eat while engaging in video games. - The design should be flexible to also accommodate B2B events or transform into a co-working environment when needed. Ideal candidates should have: - Prior experience in architectural design of gaming or recreati...
...am seeking an experienced, talented individual to create an accurately measured floor plan based on a sketch, and perhaps 3d renderings if we align on the 2d. This project will require the inclusion of the following primary facilities: - 4-6 Treatment rooms - Sauna or steam area and day spa space - single-stall showers, changing areas, bathrooms - 1 yoga studio - Mixed use lounge with communal table, lounge area, and hidden AV - front desk - Spa Retail area - lockers - back office area for laundry, storage, and staff break If you have innovative and creative ideas beyond my sketch to further enhance the floor layout to attract more customers, they are more than welcome! You will be working closely with me to design a floor plan that truly captures the essence and objectives of...
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
