Excel merge data setsmunkák
Link, telefonszám, cím legyűjtése a megadott paraméterek alapján ingatlan értékesítő részére. Mennyiség, munkadíj megbeszélés alapján. Kölcsönös elégedettség esetén rendszeres lehetőség. Csak excel alap ismerete szükséges.
Olyan webscrapping expertet keresek aki statisztikai oldalakról tudna letölteni adatokat Excel fileba. Fontos lenne hogy a kód havonta le tudja tölteni a friss adatokat is. Az adatokból statisztikai valószínűség számítás lesz a következő lépés.
SAP-bol auto-exportalt xls adatfajlokhoz kellene vba makrokat szerkeszteni melyek szinten automatizaltan lennenek futtatva. Mintafajl mukodo makroval rendelkezesre all egy bizonyos celra mar, a metodustendszert kell duplikalni mas adatokra. Szoval nem nullarol kell kitlalnod az egeszet. Nem kell durvan erteni a makrok irasahoz. ha record funkcioval, es belenyulkalassal eligazodsz, az mar eleg lehet - en is igy irtam az eddigieket. ~Muveletek: fajlok nyitasa, mentese, zarasa, munkalapok valtasa, kepletezes, ezek lehuzasa, filter, adattipusok es stilus formazasa, vlookup xls fajlok kozott, chart frissites. Ennel sokkal bonyolultabb dolgokkal nem kell nagyon számolni. 4 fo elemunk van: 1, adatfajl letrehozasa es formazasa friss sap adatexport alapjan, kepletezes, osszegzes 2, nem s...
Nyomtató által létrehozott csv / vagy xml. fájlból kellene automatikus kimutatást készíteni. A csv-ben szereplő adatokból a "Media" tipusokat paraméterezni kell beviteli mezőben megadott árral. Az "ink" úgyszintén paraméterezendő az árral. Tervezett kb végeredmény a pdf-ben.
Szia Angela, egy pdf formatumu konyvem van, amibol az adatokat egy excel fajlba kellene atvinni. A pdf magyar nyelvu, es a profilod alapjan nekem ugy tunik, hogy nagyon jol el tudnad vegezni a feladatot. Ha erdekel a munka, akkor szolj, es tovabbi reszleteket tudok kuldeni. A munka nagyobb hordereju, a $10 csak azert szerepel, mert valamit meg kellett adnom a kapcsolatfelvetelhez. Koszonom!
Kedves Krisztina, szuksegem lenne valakire, aki egy szkennelt pdf-ben levo informaciot excel tablaba tesz at. Ugy latom, hogy Krisztina szuper lenne erre a feladatra, mert tud magyarul (a pdf magyarul van), tud gepirni, es preciz is (a profiljarol igy tunik). A munka egy nagyobb munka, a $10-t csak azert allitottam be, mert a kapcsolatfelvetelhez valamilyen osszeget be kell allitani. Ha erdekli Krisztinat a munka, kerem jelezze, es tudunk a reszletekrol beszelni. Koszonom!
Kedves Angela H.! A profilja alapján Önnek szeretném felajánlani a projektem. Sürgős határidővel, pár napon belül lenne szükségem a következő feladatra: Körlevél megszerkesztése (a pontos leírását el tudom küldeni a feladatnak) Powerpoint prezentáció elkészítése (ennek is a leírása egy fájlban van) Excel adatbevitel Mindhárom feladat egyenként kb 1-2 órát vesz igénybe, tehát összesen kb. 3-6 óra legfeljebb. A kérdésem, hogy el tudná e vállalni ezt a projektet pénteki határidővel? Óránként nettó ...
Excel munka elvégzése Excel táblák és grafikonok készítése
Magyar nyelvű weboldalakról a csatolt minta file oszlopaiból hiányzó adatok kigyűjtése, táblázatba beírása. Kb. 540 sorból kb. 100 komplett, a többiben hiányzó adatok vannak.
Van egy kis feladatom egy Excel munkafüzettel kapcsolatban.
Excel munka elvégzése Munkafüzeteken számolótáblák hozhatók létre formázott adatokat lehet bevinni. Az adatok alapján végezhetők a számítások készíthető rájuk számos típusú diagram és kimutatás.
Program utasításainak fordítása Excel táblázatban (minta mellékelve). Nagyrészt informatikai és pénzügyi kifejezések.
Adatok elemzese, adatbevitel, kereses az interneten
Helló! Cégünknek van egy letölthető excel megrendelőlapja. Ennek a macro funkcióit kéne helyrerakni (pl: küldés, üres sorok törlése stb) Szeretnék egy könnyen használható, biztonságos megrendelőlapot egy-két macro funkcióval és felhasználóbarát külsővel. Mellékeltem az excel fájlt, ebből kéne kiindulni. Köszi Gergő
1) Üzleti folyamat specifikáció alapján és a kész termékre vonatkozó elvárások megértését követően az alkalmazás Excel frontend és funkcionalitások tervezése. A megrendelő és a fejlesztő közösen alakítja ki a koncepciót. Becsült munkaóra (BMó): 40 2) A működési koncepció implementálása Excel/VBA/.NET VB környezetek felhasználásával. BMó: 60 3) Fejlesztői kód dokumentáció. BMó: 20 4) Teszt esetek kidolgozása a megrendelővel közösen, azok végrehajtása, dokumentálása. BM...
Szia! Van egy lista excelben facebook felhasználókról. 11.000 sor. Magyar keresztnevek szerint kellene szűrni a listát úgy, hogy minden keresztnév és annak becézett formái, beleértve az ékezet mentesen rosszul megadott neveket is, egy külön munkalapon legyenek. Kérlek jelezd vissza, hogy tudnád e vállalni a munkát. Köszönöm!
Szia! Van egy lista excelben facebook felhasználókról. 11.000 sor. Magyar keresztnevek szerint kellene szűrni a listát úgy, hogy minden keresztnév és annak becézett formái, beleértve az ékezet mentesen rosszul megadott neveket is, egy külön munkalapon legyenek. Kérlek jelezd vissza, hogy tudnád e vállalni a munkát. Köszönöm!
A projekt: Valós idejű szegmentáció megvalósítása egy online felületen Excel algoritmus alapján. Webes felület létrehozása, melyre a partner kutatócégek továbbíthatják a kutatásban részt vevő kérdőív kitöltőket. Az oldalunkra továbbítva a kitöltőknek meg kell válaszolnia néhány kérdést, majd a válaszokon egy Excel alapú algoritmust lefuttatva különböző szegmensekbe soroljuk őket és ezután a kutatócég kérdőívéhez visszairányítjuk ezzel az információval. Mivel eddig a szegme...
QAWFafAFafsaffgsgfsagfsafsa vdklmnásldknsad'nksa;dl dfb'lsa bks b'ls bvlk;SBVKsbvSBVSnb'sBKL SA B SAB SA BDSA B SAB ASDBADSB BDSA SA DS SD BDS dsfbsB
Vállalok adatrögzítést Excel táblázatba, Word-be. Másolásokat, írásokat. Diagram készítést, tanácsadást magyarul a segítséget kérőknek.
Adatfeltöltés, táblázatkezelés, függvények, kimutatások, statisztikák és diagramok közzététele. Teljes körű Excel ismeret.
Adatfeltöltés, táblázatkezelés, függvények, kimutatások, statisztikák és diagramok közzététele. Teljes körű Excel ismeret.
Gyorsan gépelek tízujjas vakírással ismerem az excel táblázatot és gyorsan tudok adatokat is a táblázatba vinni. Másolási feladatokat is szintén gyorsan el tudom végezni. I type fast familiar with the Ten Thumbs blank face and quickly excel spreadsheet data can be carried over to the table. I can also quickly perform copying tasks.
Gyorsan gépelek tízujjas vakírással ismerem az excel táblázatot és gyorsan tudok adatokat is a táblázatba vinni. Másolási feladatokat is szintén gyorsan el tudom végezni.
Otthon elvégezhető távmunka. Információ gyűjtés, adatok bevitele a táblázatba, keresés az interneten, Excel táblázat készítése, segítés az ügyfélszolgálat munkájában.
I need STL files of an adapter combined with a mixing nozzle so I can 3d print it. I have 2 hoses that will be side by side. The hoses are 6cm across when flatted (See images). I need an adapter to connect to the end of the hoses, and then merge into a static nozzle. In one hose there will be Part A of a expanding PU foam, and in the other, Part B. The idea is that when both parts flow down the hoses, it flows through the static mixing nozzle to thoroughly combine both parts to activate the expanding PU foam. The mixing nozzle should be between 3 and 4cm squared. The part must be as small as possible, while performing its main task of combining both Part A and Part B together thoroughly. Delierable: - STL file of the part. It may need to be 3D printed in 3 separate pieces (Top, ...
...relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in the Australian Time Zone (NSW) 4pm to 1am (1hr OR 2 x 30min unpaid lunch or dinner break) Monday to Friday / possible weekend work. Personality traits for this role is someone who has a high value on the following: - very organised and likes following processes to complete a task - Someone who cares about strong atte...
Bald Eagle, Magpie, Golden Pheasant, Crow, Cracked egg phases.
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I am in need of an excellently crafted web form that can ...various services provided by my business. - Calculation logic: Addition is the primary calculation required. The system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal Candidate: - Proven experience in designing excel forms with integrated calculation logic. - Ability to design a user friendly interface. - Eye for detail, as the calculator must produce very accurate results. - Strong knowledge of Excel features and data calculation techniques. - Excellent communication skills to understand...
...- The script should be robust and reliable, able to handle a large number of files efficiently. Ideal Skills and Experience: - Proficient in Google Apps Scripting - Experience with Google Drive API - Strong understanding of file management on Google Drive - Familiarity with skip tracing methodologies - Ability to write robust, efficient code - Experience with handling and processing large sets of data Please note that the handling of files that already exist in the specified folder will need to be discussed with me directly. I will provide more information on this when the project begins....
I'm launching a new fashion business and am seeking a talented freelancer to help me create and revamp both my fashion line and packaging. I have some ideas for themes and styles but need assistance in honing in on my targe...appealing to the defined target market. - Design innovative and sustainable packaging that complements the fashion items and stands out in the market. - Provide guidance on branding strategy to ensure consistency across all designs and packaging. The ideal candidate should have experience in fashion design, packaging design, and market research, with a portfolio that demonstrates an ability to merge creativity with market trends. I'm looking for someone who can not only execute my vision but also provide strategic insights to position my brand effect...
I'm seeking a proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to the chosen freelan...
I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addresses is crucial. - Time manag...
I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting that this tool will enhance ...
I am seeking a creative and talented photoshop artist who can help turn my vision into a reality. I have two pictures; one picture is of a suit of armor that I want incorporated onto a hamster from a second picture. ...reality. I have two pictures; one picture is of a suit of armor that I want incorporated onto a hamster from a second picture. This unique design will be a medium-sized, black and white tattoo, placed on the front of my left shoulder/upper srm. The ideal freelancer for this project should: - Have exemplary photshop design skills - Be experienced in black and white designs - Understand how to merge designs seamlessly - Be able to tailor details to the tattoo's size and location I look forward to collaborating with you and can't wait to see this remarkable ...
I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.
QCon LabTech Solutions is on the lookout for a proficient freelancer to develop a dynamic online portal to manage trainee folders and facilitate client access to potential candidates. This innovative platform will serve as a central hub for storing trainee information, including skill sets, training matrices, videos, and personal details. As the chosen freelancer, your responsibilities will include designing and implementing a user-friendly interface that allows for easy navigation and efficient organization of trainee folders. Integration of features such as secure login systems, customizable user profiles, and search functionalities will be crucial to ensure smooth user experience. Moreover, you'll be tasked with creating a client portal where prospective employers can brow...
I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unl...
I'm looking for a creative graphics designer experienced in creating eye-catching YouTube thumbnails. The primary theme of the channel's content is 'Self-Improvement'. What sets these thumbnails apart is, it must incorporate elements of personal growth visuals to underline the development aspect effectively. Design Expectations: • Make use of personal growth visuals that elevate the core theme. • Striking images to engage viewer curiosity. • Balancing aesthetics and uniqueness for a catchy visual. Ideal Candidate: • Fluent in visual storytelling focused on personal development. • Experience creating compelling YouTube thumbnails. • Demonstrates creativity in using personal growth visuals. • Open to feedback and collaboration...
I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues...
I'm looking for a skilled data analyst to help me with a comprehensive statistical analysis of a survey I conducted with roughly 100 participants. Key Requirements: - Proficiency in Descriptive, Inferential, and Correlation data analysis techniques - Experience in interpreting survey data to identify trends and patterns - Ability to test hypotheses and make inferences - Knowledge of how to determine relationships between variables - Excellent skills in Excel and/or other statistical software or python for data manipulation and analysis Ideal Candidates: - A data analyst with a proven track record of handling survey data - Someone who can derive meaningful insights from the data - Excellent communication skills to explain the ...
I'm looking for a skilled developer to create a custom Tibia 8.6 server th...MMORPGs like Tibia. - Proficiency in programming languages and tools necessary for implementing custom features and systems in the game. I also expect the selected freelancer to assist in setting up a website and shop for the server, and to help configure donation options for 500+ players. This project hinges on the developer's ability to craft a compelling and engaging Tibia experience that sets my server apart from others. The successful candidate will have a proven track record of delivering high-quality game development work, particularly in the context of MMORPGs. I'm also looking for someone who can bring creative ideas to the table, enhancing the overall player experience and ensur...
I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are successfully retrieved and...
I would like to have a routine to change font size without opening a word file. Also to be able to merge severall doc files into a single one.
...knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong under...
