Vba compare data setsproiecte
Suntem o companie multinationala care presteaza servicii in industria automotive si cautam ingineri pe teritoriul Romaniei pentru testarea soft-ului auto. Se va lucra remote dupa perioada de training. Cunoasterea limbii germane este obligatorie, iar engleza reprezinta un plus. De preferat sa aiba cunostinte de Matlab / Simulink, VBA or Python.
Se da urmatorul scenariu: Incazari in data de x,y sau z la locatia x, y sau z cu un echipaj variabil de 1, 2, 3 sau mai multi. Am nevoie sa extrag(copiez) informatia si sa o pun la fiecare om din echipaj in sheet separat. am incercat cu filtre si macro dar imi copiaza doar informatia de la prima coloana de echipaj. se poate cu alta formula sau cu VBA (cod)
Am nevoie sa modific / imbunatatesc cateva fise Excel pe care le folosim zi de zi in munca noastra. Am nevoie de cineva cu cunaostinte foarte bune de programare in Excel sau VBA
Dezvoltare Aplicatie Excel/VBA prin dezvoltarea unor module noi conectabile la aplicatia deja existenta. Aplicatia in cauza gestioneaza activitatea de comenzi, pregatire, expediere si facturare marfa, intr-o companie mica.
I am Shubheem here given to you work Dezvoltare aplixatie -Excel- VBA pentru optimizarea, activitatii ,depozitare,gestiune see transport here work is Vrem sa optimizam si sa dezvoltam in continuare o aplicatie pe care of folosim pentru optimizarea activitatii in firma
Vrem sa optimizam si sa dezvoltam in continuare o aplicatie pe care o folosim pentru optimizarea activitatii in firma. Avem de nevoie de o persoana cu cunostinte de programare VBA . Aplicatia pe care o folosim lucreaza in tandem cu aplicatia WinMentor asa ca sunt necesare si anumite cunostinte despre acesta din urma.
● Python programming combines or individually, at least 6 of Facilities: - use of lists and dictionaries, including the necessary method; - use of sets and tuples, including the method required; - defining and calling functions; - use of conditional structures; - use of repetitive structures; - import a csv or json file into the pandas package; - accessing by place and place; - modification of the measures in the pandas package; - group functions; - treatment of missing values; - deleting columns and records; - statistical processing, grouping and aggregation of data in the pandas package; - processing of data sets with joining / joining; - graphic representation of the after with the matplotlib package; - use of the scikit-learning package (clustering, logisti...
Vreau sa creez o funcție (VBA) care sa convertească un fișier txt în Excel la apasarea unui buton. (function)In acelasi timp sa se poata Introduce manual calea de unde se ia fisierul txt respectiv, unde va pune fisierul excel, anumite informatii adaugate manual. Am anexat mai jos cum arata fisierele text (2 tipuri de format) si de asemenea cum trebuie sa arate pentru fiecare (example 1 si 2).
Buna ziua. Am un proiect personal, care implica realizarea unui tabel excel complex, (1000linii) si as dori sa filtrez aceste date, conform cerintelor mele. Se vor folosi macros si vba, deci am nevoie de cineva care chiar stie sa lucreze in excel. Cei care stiti sa faceti o comparare intre doua coloane, dar asemanarea sa fie de 85%, puteti sa ma contactati.
Salut Sergiu, Am gasit profilul tau pe Freelancer si am vazut la sectiunea Skills ca stii VBA si Excel. Am un proiect despre care as vrea sa discut cu tine. Ma poti contacta la adresa de email @
Buna ziua. Am un proiect personal, care implica realizarea unui tabel excel complex, (1000linii) si as dori sa filtrez aceste date, conform cerintelor mele. Se vor folosi macros si vba, deci am nevoie de cineva care chiar stie sa lucreze in excel. Cei care stiti sa faceti o comparare intre doua coloane, dar asemanarea sa fie de 85% ca si caractere, puteti sa ma contactati.
cod vba excel , sa copii valoare din pagina 2 in pagina 1 cu indeplinirea 3 criteri , vezi imaginele atasate
...servicii (in cazul nostru service-urile auto din Romania) cu potentialii clienti, persoane fizice sau juridice. Pentru studiu exemplificativ: rog contactare. Viziunea noastra este: Sa ajutam anual cel putin 10.000 poseserori auto sa identifice rapid ofertele service-urilor auto din aria lor de domiciliu; Clientii sa poata urmarii review-urile scrise de alti oameni cu experiente asemanatoare, sa compare preturile mai multor service-uri si in final sa aleaga in cunostinta de cauza service-ul auto cel mai potrivit nevoilor sale. Misiunea noastra va fi sa aducem laolalta prestatorii de servicii auto (in jur de 10.000 unitati) si posesorii celor aprox 6.000.000 autovehicule din Romania. Pentru indeplinirea misiunii noastre, suntem in cautarea unor oameni valorosi care sa ne aju...
...filtre. La site vor fi adaugate 3 module: unul de rezervare hotel, altul de rezervare localuri si altul de plata (oricine se inscrie sau face modificari in cont plateste o suma) Modul de expunere va fi in genul la Inscrierile pe site se fac separat pentru fiecare categorie. Sus sigla sitului. Jos va fi un baner de publicitate. Filtrele sa se retraga gen Trivago. Situl va avea si Compare unitati. La site as mai dori o aplicatie care sa permita inregistrarea comentariilor la unitatile turistice si evaluarea acestora. Totodata va avea Admin si Super Admin. Panou de adminstrare comenzi si tot ceeace implica un astfel de site. Situl doresc sa fie realizat in Drupal, deoarece e o platforma opensurce care rezista la situri extrem de mari. Va rog sa precizati cat va fi intre...
Buna seara, Doresc sa creez un site de prezentare unitati turistice. Caut programator cu experienta, web designer, graphic designer in vederea realizarii acestui site. De preferat programatori din Bucuresti. Mentionez ca acest site trebuie s...subcategorii care sa functioneze ca filtre. Modul de publicitate. Modul de rezervare hotel si localuri. Verificare disponibilitate camera – FILTRU in genul celui de pe situl – Sistem de rezervare restaurant in genul – VikRestaurants – joomla Modul de plata online pentru inscriere pe site. Bara de meniu. Iar modalitatea de afisare pe site sa fie in genul Filtre compare price, pret ascendent descendent, alegere inteligenta. Contoar utilizatori. Bugetul este de 1000 Euro. Astept oferta. Multumesc.
Am nevoie de cineva care sa ma ajute sa transcriu o problema de mecanica in VBA. Multumesc.
Enter data - Orders - Compare prices - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
caut un freelance din Romania care are experienta in "Compare Hotels Prices". ca model puteti testa va rog sa ma contactati numai daca esti capabil la asa un proiectul. de asemenea propuneri pentru cooperare si parteneriat cu parteneri in domeniul wab si web design. multumesc
Am un proiect neterminat, am nevoie de cineva care stie VBA Excel sa il poata incheia. Liciteaza doar daca ai experienta in VBA, proiectul nu este chiar usor de inteles si realizat, pentru cine are experienta insa dureaza f putin de incheiat.
te rog sa ma anunti daca esti disponibil in a ma ajuta intr-un project excel vba. e un singur elgoritm de corectat. chstie de cateva minute. mersi
Am un proiect aproape terminat si abandonat. Nu este foarte amplu, Am nevoie de cineva care il poate incheia. Este in Excel VBA si voi trimite specificatii pe mail celui interesat. Multumesc!
Locatia de realizare a proiectului: Brasov la sediu firmei Consultanta si suport pentru: Migrare aplicatie realizata din VBA in C# Migrare de la lucru cu tabele excel la tabele Access si SQL Realizare Interfata Profesionala in C# Realizare legatura intre Interfata relaizata in C# si tabele realizate in Access sau SQL Realizare strucura logica de organizare interna a datelelor din tabelele in Cccess sau SQL Relizarea "Relationships" intre tabele in access Teste
...should be accessible on both iOS and Android platforms. Key Features: - The app should collect information from various automobile insurance companies in one location which will help users to compare and choose the best option. - The ability to generate quotes from multiple insurance companies is a must. - It should also support claim reporting and policy management functionalities. Ideal Candidate: - Experience in developing insurance related mobile applications is desirable. - Must have previous experience creating apps for both iOS and Android. - Knowledge in integrating third-party APIs to fetch data. - An understanding of the insurance industry's standards and requirements is highly beneficial. I encourage interested and eligible freelancers with a proven trac...
I am in the process of starting a new enterprise and require a skilled web developer to create an airconditioner comparison website. This platform will serve as a space where different airconditioner models and brands can be compared. Key components of the website: - Airconditioner Comparison: The primary function of the website is to allow users to compare various airconditioner models and brands. This should be user-friendly, informative, and visually appealing. - Showroom Visit Assistance: Another crucial feature of the website is to offer personalized assistance to users who are interested in visiting authorised showrooms. This might include providing them with details about the showrooms, scheduling appointments, and offering recommendations based on their needs. Target Audi...
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.
...then overlay Renko And then use the indicator. Renko chat don't work, you know that Becareful don’t use Renko Renk is how I trade, but we are trying to autmate this So you are going to have to use Candlestick with Renko overlays and the indicator on the renko, overlays and trade off the Candlesticks with the signals. The renko is to show you the end result, how it is going to look So you have to compare your Candlesticks signals with how the renko signals with what I showed you work They have to match...
...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 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...
...to compute the next value in the sequence. 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 a...
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.
...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 separately. (For example the data displayed for betfair sportsbook should be named "betfair" and the data displayed for betfair exchange should be called "betfair exchange") Important
...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.
