Records sorting removing duplicate fields excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus
business profit loss reporting excel(Jan, Feb & March)
...professional and dexterous home assistant and sitter who can competently handle a number of responsibilities. It’ll be 6 days a week. And 3-5 hours per day. Tasks and Responsibilities: - Able to follow instructions. - Computer literacy. - Manage home. Home Management: In addition to the above, the successful candidate will assist with household inventory management, maintaining comprehensive records and ensuring that everything is in its rightful place. Ideal Skills and Experience: - Demonstrated experience in home sitting and assistance. - Exceptional organizational and management skills. - An eye for detail, especially when dealing with inventories. - Good communication skills. - Ability to follow orders. This is a demanding job that requires a flexible, depe...
...Adobe Pro expert who excels in creating and manipulating contracts. The ideal candidate will have the following skills and abilities: - Proficiency in Adobe Pro specifically on Windows OS. - Ability to create E-signatures. - Capability to design document templates in line with my company's predefined style. - Know-how to devise fillable forms, as part of the contract. - Competence to add permanent fields and signatures in documents. The freelancer should have a good eye for detail ensuring that each contract adheres to the predefined company style and standards. The understanding and application of industry-specific formats will also be a key aspect of the task. High-level proficiency in Adobe Pro and contract design and modification is a must, as the project will majorly ...
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static...
My goal is to craft a captivating online platform that will serve as a gallery to exhibit a multitude of a...exhibit a multitude of art pieces. This webpage will principally serve the following functions: * Display more than 20 works of art * Present an artist's biography * Feature various interview videos Ideal Project Executor: - A freelancer with a keen eye for aesthetics, who can create an attractive and immersive user experience. - Experience in website development that focuses on art or related fields. - Proficiency in efficiently organizing large volumes of content in a neat, user-friendly manner. - Expertise in embedding video content into websites. - A deep understanding of my goals for this project. Looking forward to potential collaborations to imbue life int...
I won't respond to any bids unnecessar...cover, the Personalized High School Diploma for Homeschools is an official document to honor your grad! Homeschool Diploma The product must be customizable with text and adornments that the customer chooses. The most important part is that the customization choices will show on the picture in real time. In other words, the picture will change each time a customization is added. If you could duplicate the product on this page exactly as it is, I would be very happy. I do not need the review section on the bottom of page, only the product. Key Requirements: - Ensure the page is easy for me to update and maintain Please let me know if you've had experience with similar projects and how you plan to ensure that the final product me...
...data must be verified using third-party tools before submission. Only verified records will be accepted, and payment will only be issued for data that is verified to be accurate. Verification Process: After you have submitted the verified data, we will also be verifying the data ourselves to ensure the accuracy of the data. We will verify the email addresses through Zero Bounce, the phone numbers through Tele sign, the addresses through USPS Address Lookup, and will test all URLs and links to ensure they are accurate as well. Payment / Replacement Data: Once the data is verified, we will then release final payment, and if any of the contact details come back as invalid, we will request replacement data records. If this project is successful, we will have many more proj...
...commitment to transparency and professional service. Key Features: - The template needs to have individual fields for 'Client Name', 'Financial Summary', and 'Tax Advice Tips' & a 'performance graph'. - The design should embody a modern and minimalist aesthetic, reflecting our firm's expertise and reliable standing. - We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receives a personalised brochure. It is a tax summary page, with tax saving tips, performance graphs, overall tax positions, etc. - The main thing is having fields we can populate with our financial ...
I am in search of a freelancer who can assist me in verifying the employment history and qualifications of potential candidates in Switzerland. This is crucial for me to ensure the accuracy of their past employment and to validate their qualifications. Key Respo...This is crucial for me to ensure the accuracy of their past employment and to validate their qualifications. Key Responsibilities: - Conducting thorough employment verification checks - Ensuring the accuracy of job titles and employment history - Verifying qualifications and past experiences - Providing detailed reports on your findings Ideal Skills: - Experience in HR, recruitment, or similar fields - Strong investigative and research skills - Excellent attention to detail - Understanding of Swiss employment laws and...
...search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities will include: - Implementing new search criteria: Specifically, I need the addition of a new category search criterion using the Smyles Plugin on the back-end. - Ensuring a smooth integration: You must make sure that all changes and additions are fully integrated with the existing system without causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional se...
I need a skilled professional to install Mail-in-a-Box on my RackNerd server. You should set up all the necessary DNS records and ensure the installation is fully secured by implementing a Secure Connection SSL / STARTTLS. Key Requirements: - Installation of Mail-in-a-Box on RackNerd server - Setting up all necessary DNS records - Implementing Secure Connection SSL / STARTTLS Ideal Skills and Experience: - Proven experience with Mail-in-a-Box installations - Strong understanding of DNS management - Expertise in SSL/TLS configuration - Prior experience with RackNerd servers The primary purpose of this project is for educational/nonprofit use, so your help in ensuring the security and functionality of this setup is crucial. Please only apply if you have relevant experience a...
As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...
I'm in need of a skilled Pinescript developer who can perform a thorough clean-up of my codebase. Your primary task will be to remove any unwanted functions or variables from the existing code. Key Responsibilities: - Removing these unwanted elements from the Pinescript code without adding any new features or adding anything Please respond with final offer.
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
I am seeking a skilled web developer to create a dedicated real estate website focused exclusively on houses and rooms for rent. The website should be responsive and user-friendly ...under each listing allowing users to express interest in a property. Upon clicking the "React" button, the user's interest should be sent directly to our email, including details about the specific listing and the user. Search Functionality: An intuitive and easy-to-use search option for users to find properties based on various criteria (location, price range, property type, etc.). Filters and sorting options to enhance the search experience. Admin Dashboard: A backend dashboard for managing listings, user accounts, and tracking user interactions. Ability to add, edit, and delete prope...
I am in need of a professional who can create customizable paper price tags for the Delaware Hot Tub Company. The tags should be designed in a landscape format with editable fields to allow for easy price adjustments. Requirements: - Creation of paper-based price tags - Landscape format - Editable fields for MSRP, sale price, cash rebate and monthly payments Ideally, the tags should have a professional and appealing design that aligns with the branding of our hot tub company. Skills and experience required: - Proficiency in Microsoft Word for the creation of the price tags - Graphic design skills to ensure the tags are visually appealing - Experience in designing retail or product pricing materials is preferred
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
I am looking for a skilled developer to create an engaging Employee Pre-Verification system. This system will focus on Background check and Referral check. Key Functionalities: - **Background Check**: This system should have the ability to conduct background checks on potential employees. This can involve checking criminal records, credit history, and other relevant information. - **Referral Check**: The system should also incorporate a referral check system. This can help verify the authenticity of the references provided by the employee. User Interface: - The UI of this system should be interactive and engaging. This will ensure that the system is not only functional but also user-friendly. Reporting System: - The system should generate reports in two ways: - **Downloadable ...
I am looking for a local and experienced landscaper to transform my yard by removing the current 1000sq ft of grass and replacing it with artificial turf and paving stones. The main objective of this project is to amplify the visual appeal of my yard. Although I have decided on a specific pattern for the stones, I am open to creative suggestions. Freelancers in Calgary only please, I need boots on the ground. Thank you! Project Requirements: - Remove grass from my yard - Install artificial turf and paving stones - Provide creative suggestions for stone placement Key Competencies: - Proven experience in landscaping - Demonstrated ability to work with paving stones - Creativity in design Budget: - My budget for this project falls within $2000-$5000. Kindly note, I will provid...
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
I'm looking for an experienced WHMCS developer to help improve an already developed financial history graph. I had a developer from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start of the database, right now it only goes back 3 years because that is ...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...
I need a CRM solution designed around the latest version of Odoo, O...designed around the latest version of Odoo, Odoo 13 or Zoho. I'm looking for developers with specific skills and experience customizing Odoo CRM or Zoho Creator (CRM). Key features I need to integrate: - Contact management - Management of the Contracted Services pipeline - Customer support tickets - Agenda management with confirmations via automation via email and Whatsapp - Patient Medical Records - Integration and Management of WhatsApp messages - Built-in video calling appointments Additionally, the project requires specific design and branding elements that will be explained in more detail during the selection process. An eye for detail and a creative mindset are required to meet the specifics of the p...
...com/ Base Website Custom Design: Includes up to 4 unique page designs. Responsive Layout: Mobile-friendly design that adapts to various screen sizes and devices. CMS Integration: WordPress installation and setup, allowing for easy content management. Content Strategy Session: Session to outline the site’s content needs and SEO goals. Contact Form: Integration of a basic contact form which stores records in the CMS system. Google Analytics Setup: Integration of Google Analytics for tracking website traffic. Security Plugins: Installation of security plugins to help protect the website from common threats. The following pages are included in the base design package. • Home • About • Travelers • Clients Additional Page Development Creation of additional web...
...security of all plugins and scripts. 4. Identify and remove malware to clean up the website, which is currently flagged on up to 8 malware sites. 5. Address and resolve any 3rd party malware reports. 6. Provide ongoing WordPress maintenance and security support post-migration. Qualifications: 1. Proven experience in WordPress website development and migration. 2. Expertise in identifying and removing malware from websites. 3. Strong understanding of WordPress security best practices. 4. Experience with updating and securing WordPress core and plugins. 5. Ability to troubleshoot and resolve website issues quickly and effectively. 6. Excellent communication skills and ability to work under tight deadlines. Project Details: 1. Immediate start upon acceptance of the offer. 2. We ...
...Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsof...
I'm seeking a skilled data entry specialist to assist with removing duplicates from spreadsheets comprising various datasets. The primary goal of this task is to ensure that our data is clean and free of any redundant information. The spreadsheets will be provided for you to analyze and clean accordingly. Ideal candidate must have: - Proven experience in data entry, particularly data cleaning and deduplication. - Proficiency in working with spreadsheets. - Attention to detail and high level of accuracy. - Ability to understand and follow provided data cleaning guidelines. If you fit the criteria and are ready to undertake this task, I look forward to seeing your proposal.
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
I'm seeking an AI developer to create an AI Resume Creator. The primary focus of this project is to take a normal CV / Resume and format it into our company format. It's quite a simple process, populated some fields, removing personal details and then coping the rest of the text into our format. We would want to be able for the AI to use the template we create and it check it each time to make sure we havent updated anything. We would drop the resume / CV into one folder then it would be added to another folder formatted. Ideal Skills and Experience: - Strong background in AI and Machine Learning - Experience in NLP and chatbot development - Proficiency in creating customizable sections for user-friendly interfaces - Understanding of how to analyze user's s...
