Vba comparing data setspekerjaan
Saya memerlukan servis untuk designkan interface system. System ini menggunakan microsoft excel VBA. Cod Macro sudah ada, just untuk tukar design sahaja
Membuat dokumen list kertas A3 Membuat template dokumen laporan harian Menggunakan kertas ncr Membuat template dokumen laporan mingguan kertas legal Membuat tenplate dokumen laporan bulanan / rekap kertas legal Membuat template dokumen RAP Membuat template curva s Intinya membuat template dokumen Antara sheet dan sheet terhubung antara 1 dan lainnya menggunakan rumus atau vba dan menggunakan pivot
Melakukan sejumlah pekerjaan Excel Mampu mengoperasikan Ms Excel Mampu mengoperasikan Ms Word Mampu mengoperasikan Adobe Photoshop ++Design Grafis,membuat logo pada Adobe Photoshop dan Corel Draw ++mengoperasikan Ms Excel dan menguasai VBA project dan formula pada excel.
Membuat aplikasi VBA- excell untuk tracking portofolio saham dengan ketentuan sbb: 1. Menggunakan Real time data (1-5 min) 2. Update data saham secara otomatis ke portofolio saham 3. Dapat melakukan penambahan dan pengurangan transaksi saham pada portfolio 4. Dapat melaklukan sorting berdasarkan Nama saham, keuntungan (jumlah atau %), berdasarkan tanggal masuk 5. Record data tiap transaksi pada portofolio
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
...existing web crawler code to include specific features I require. This includes the ability to extract and filter data from multiple websites. - **Data Management:** I expect the total scale of the data to be relatively small, so the freelancer should have experience handling data sets of this size. - **Data Analysis:** After the information is extracted, I intend to use it primarily for data analysis. The freelancer should have a good understanding of how to structure data for this purpose. Ideal Skills & Experience: - Proven experience in customizing web crawlers and managing data. - Proficient in data analysis and structuring for insights. - Familiarity with handling small scale data sets. - Stro...
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
...create a bold and dynamic YouTube intro and outro for my channel. Here's what I have in mind: - **Style**: Bold and dynamic. It should grab the viewer's attention right from the start. - **Elements**: - Animated Logo: I'd like my logo to be creatively integrated into the intro and outro. - Custom Music/Sound Effects: I want a unique audio accompaniment that complements the visuals and sets the tone for my content. - Social Media Call-to-Action: The outro should include a clear and engaging call-to-action encouraging viewers to subscribe, like, and follow my social media. - **Duration**: The intro and outro should be between 5-10 seconds long. Ideal candidates for this project would have: - Proven experience in creating engaging YouTube intros and ...
I'm in need of an expert statistician, preferably with a background in medical data analysis. Your task will comprise of comparing survival rates within a set of medical patient data. This will include, but isn't limited to: - Conducting survival analysis, with a primary focus on comparing survival rates among different groups. - Your output should highlight significant differences and present the findings in detail. - The analysis needs to include detailed and easy-to-understand graphs, illustrating the comparative survival rates. Skills with statistical software and a comprehensive understanding of survival analysis are necessary for this task. Ideally, you also hold experience within the medical field.
I'm on the hunt for a skillful coder proficient in web scraping, specifically for Website A. The goal of this project is for obtaining valuable and significant data for analysis, competitive intelligence, and price comparison. While there's no explicit mention of the type of data to be scraped, I anticipate that a capable offering will cater to a variety of needs such as: - Text content - Image content - Metadata Ideal Experience and Skills: - Proven experience with web scraping - High proficiency in handling large data sets - Comfort in navigating Website A - Ability to collect comprehensive data categories Looking forward to a potential collaboration to achieve this goal!
...with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the ta...
I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro...the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...
...Write recursive solution. • Test both programs for different input sizes and compare their performance. Task 2: Parallelize the algorithms for the second and third recursive equations obtained from the 1 practical selection test, and also parallelize second and third algorithms obtained from the 4 practical task selection test. Ensure that the programs correctly synchronizes the threads by comparing the final results of the sequential and parallel versions of the programs. • Analyze the sequential and parallel algorithms and determine their computational complexity using both Big O and Omega notations. • Measure and compare the execution time of the sequential and parallel versions of the programs and identify any potential differences in performance as the inp...
I'm looking for a reliable virtual assistant who can help me with flight bookings. Your primary responsibilities will be: - Researching various flight options - Comparing prices across different airlines - Booking flights based on the best available deals I don't have a preference for specific airlines or alliances, so you'll have the freedom to explore various options. It is important that you are comfortable with managing flexible travel dates as I am open to flying within a week of my intended travel date. The ideal candidate for this job should possess: - Strong research skills - Experience in booking flights and comparing prices - Flexibility with travel dates ONLY EXPERIENCED TRAVEL VAs Please provide details of any relevant experience you have in ...
I am seeking the expertise of a professional engineer to create 2 sets of stamped engineering plans for a 7-10k elevator boat lift. The desgin should incorporate: - 20 degree angle lift secured to a seawall, indicating a balance of strength and flexibility. - Weight capacity between 5,000 - 10,000 lbs, to cater to a diverse range of boats. The ideal candidate should have: - Extensive experience in marine engineering - A proven track record with designing boat lifts - Familiarity with the local codes and regulations in Pasco County. For a smooth working relationship, the ability to respond promptly to queries and meet deadlines is crucial. Detailed and clear communication is also essential.
...website quicker and incredibly user friendly. Key Requirements: - I need the website to have a clean, professional look that accurately reflects the informative content. - It should be user-friendly and intuitive to navigate, focusing on providing a seamless user experience. - The design should incorporate a consistent color scheme and typography that aligns with the overall branding. Ideal Skill Sets: - Strong understanding of user experience and user interface design. - Proficiency in graphic design software and tools. - Prior experience in designing and developing informational websites. - Excellent communication skills to ensure that the design aligns with the content and goals of the site. If you have proven experience in designing and developing similar websites and can...
I’m seeking a data science expert, who specializes in machine learning, specifically with predictive analytics. The main goal of this project is to build a robust predictive model that can handle a yet-to-be-determined type of data. However, rest assured we have labeled data ready for model training. The perfect candidate would, therefore, have a strong background in: - Data science and predictive modeling - Machine learning application - Handling different sets of data, structured or unstructured. If you possess these skills and are able to rise to the challenge, kindly submit your proposal. I look forward to crafting a smarter future with your help!
...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, Statistical Formulas, or Macros/VBA would be...
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.
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 Requir...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 issue...
I am in need of a proficient and savvy business planner who can develop an engaging and informative plan for my men's mental health health & wellness not for profit business. The prime target audience for this business will be adults between the ages of 20 and 60. This project involves: - Creating a high level business plan and presentation concept that sets us apart. We have some concept notes that need to be distilled into an easy to read presentation and plan with an execution timeline. - Optional - Initial development of financial forecasting model and budgets. The ideal freelancer for this project will have a strong background in business plan writing, with specific experience in the health & wellness sector. Strong understanding of market trends among adults age...
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.
...dashboard will display custom data. - The dashboard should have data filters that allow users to interact with the data, specifically in the form of dropdown menus. - Charts should be easy to understand and navigate. Ideal Skills and Experience: - Proficiency in Tableau: The ideal candidate should have a strong background in creating Tableau dashboards with complex data sets and interactive elements. - Data Visualization: A good understanding of how to present data in a visually appealing way is crucial. The ability to communicate complex data effectively is a plus. - User Experience (UX) Design: A good understanding of how the end user will interact with the dashboard is key. The freelancer should be able to design a user-friend...
...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and...
I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on the image.
I'm seeking a skilled professional well-versed in MAXQDA software and data analysis to assist with my upcoming project. The work will involve the analysis of multiple sets of data - primarily surveys, interviews, and focus groups. Key tasks involved: • Coding data sets on MAXQDA • Analyzing coded data • Delivering insightful interpretations of results The job will involve approximately 40 surveys, 12 interviews, and 2 focus groups. It's therefore crucial that the successful individual or team is able to perform this task efficiently, maintaining high-quality data analysis throughout. Having previous experience in a similar job, and professional knowledge of Windows operating system, is highly desirable. There...
Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code
I have 33x sets of product data in a spreadsheet. I need each product's specifications to be created in a standardized PDF format. The level of detail should include everything detailed on the spreadsheet. The data on the spreadsheet is broken down into the following sections, which must be reflected on the product specifications. - Production Information - Packaging - Pallet Configuration - Physical Data - Chemical & Microbiological Tolerances - Storage - Labeling You will be responsible for: - Creating individual product specifications from provided data. - Ensuring all specifications are formatted consistently in PDF format and include our company logo provided. - Include all the information provided in each product specification. Ideal ski...
vmix (video production) expert needed for a couple of online consultations in videocall. topics: titles, vmix virtual sets, audio inputs. thank you.
I'm seeking a skilled market researcher to provide a comprehensive analysis of the potential market for a school discovery platform in the UAE. Project Title: Comprehensive Market Research for School Discovery Platform in UAE Overview: Our startup operates a school directory platform specifically designed to assist UAE families in finding and comparing schooling options for their children. We are committed to providing innovative solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broader industry landscape, and our competitive...
Project Title: Comprehensive Market Research for School Discovery Platform Overview: Our startup operates a school directory platform specifically designed to assist UAE families in finding and comparing schooling options for their children. We are committed to providing innovative solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broader industry landscape, and our competitive positioning. Scope of Work: Market Statistics: Collect up-to-date statistics on the UAE education sector, including details on student enrollments, enroll...
...Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integration &...
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized ...
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
...SPARK VISION. Data Collection: Extract detailed information from the competitors' websites, focusing on: Price Features Customer Support Compatibility Cost Type of Subscription What is included in each type of subscription 3D Modeling Costs: Gather information about the costs associated with 3D modeling for new products, including the data required for the modeling process. Requirements: Pricing Comparison: Compile accurate, up-to-date pricing details, including different subscription plans and any additional fees. Feature Analysis: Evaluate and compare the capabilities of each 3D planner, including customization options and integration capacities. Visual Representation: Create a comprehensive table and visually appealing graphics to clearly compare the data. ...
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue(&quo...
I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your b...
I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.
I'm in need of a professional logo designer who can create a logo that not only reflects my brand but also sets it apart in terms of recognition. Key Requirements: - The logo should primarily focus on brand recognition and creating a unique identity. - A minimalist approach is preferred, but I'm open to other creative styles as well. Ideal Freelancer: - A seasoned logo designer with a strong portfolio of past work that demonstrates a deep understanding of brand recognition. - Experience in crafting logos that are both minimalist and distinctive. - Strong communication skills to understand and translate the brand values into a visual identity. The name of the real estate group is House Trained Realty Group We have a strong passion with helping animals (primarily dogs ...
I need a data studio expert to create a comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversions per key word The report should cover the last 30 days. I prefer a report that represents data in tables and numbers rather than through charts and graphs. Skills required: - Proficiency in Google Data Studio - Strong understanding of Google Ads and meta data - Ability to work with large data sets and visualize information effectively in tables and numbers - Strong analytical skills to draw insights from the data presented
in need of a skilled photoshop designer who can create Facebook and Google ad sets for my med spa. The main goal of these campaigns is to generate leads. Please upload as samples for each treatment below and making sure all ads would be compliant to Facebook and google guidelines I will need 1 ad per treatment for our med spa for the following services. Once hired we will need 5 color variations for each ad. Key Treatments: - The ad sets will focus on a range of treatments, including Morpheus8, tri-Lift, Vampire Facials, and PRF Microneedling. - The ads should highlight the benefits of these treatments and why they are the perfect solution for anti-aging. Target Audience: - The target audience for these ads are individuals looking for anti-aging solutions. - They ar...
I'm on the lookout for experienced professionals to build a comprehensive ecommerce platform for my services. We'll have to move quickly, as I need this project completed as soon as possible. Here are some specifics: - The platform will be primarily used for selling services. - Since I opted to skip the question about service categories, I am open to any skill sets you might bring to the table with regards to diverse service offerings. - Rapid response and fast development timelines are crucial for this project. Ideal candidates for this job should have: - A strong background in ecommerce development, specifically focused on service platforms. - Proven track record of delivering projects within tight timelines. - Flexible problem-solving skills and adaptability to mee...
Hi! I am in need of a skilled Data Analyst who can transform some critical district nutrition data into easily understandable infographics and pie charts. The mission is as follows: - Perform statistical analysis on yearly district nutrition data - Generate engaging infographics and pie charts to visualize and interpret the data accurately - Provide detailed descriptive statistics Potential applicants should have a strong understanding of data preprocessing, data visualization, and statistical analysis. Experience in designing infographics and interpreting complex data sets is a must. Prior experience with nutrition or health data is strongly valued. Let's make this data speak!
I'm in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities fo...in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities for large ...
I'm looking for an experienced designer to create engaging and visually appealing banners and ad sets for my Web3 project. The main aim of this project is to drive traffic to my website. Key Requirements: - The banners and ads will be used across various platforms, including social media, search engines, and partner websites. Hence, they should be tailored to suit these different platforms. - The target audience for this project is primarily between the ages of 18-44, so the designs should be attractive and relevant to this demographic. Ideal Skills and Experience: - Previous experience in creating web banners and ads, particularly for diverse platforms and audiences. - A good understanding of Web3 projects and the ability to design with the aim of driving website traffic. - ...
I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more opportun...
I am in need of a creative and attractive logo for my technology-based website. I am looking for a designer who can bring my brand to life through a logo that is both meaningful and visually striking. Key Requirements: - A logo that embodies the essence of a technology focused business - A design that is unique and sets my brand apart - The logo should be visually appealing and memorable Ideal skills and experience for the job: - Proven track record in creating logos for technology companies - Experience in brand building through design - Strong portfolio of creative and meaningful logo designs - Proficient in various design software for logo creation.
...skip), and generates a total score. In the attached image, I entered this data manually in Columns G and used a basic formula in column H. It is columns G and H that I am looking to automate based on user data entered in column F (which will initially start off blank). I need to replicate this formula 125x, and so would also like you to walk me through the formulas. This task requires a good understanding of data manipulation within Excel. Skills and experience ideal for this project include: - Advanced proficiency in Excel formulas and functions - Experience in data manipulation and analysis - Attention to detail and ability to execute complex instructions - Ability to work efficiently and effectively with data sets A successful freelanc...
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized ...
