Format string excelpráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
Ahoj, Zabýváme se poskytováním vzdělávání v IT prostřednictvím online-videokurzů a máme za cíl tento format převést na novou úroveň - svěží, kvalitní a dostupný content. Hledáme do svého týmu FRONT-END developera, který bude schopný předat své znalosti lidem a pomoct jim dosáhnout úspěchu v tomto oboru. Hledáš práci s možností se neustále rozvíjet, chceš být součástí grandiozního projektu a dělat opravdu úžasné věci? Welcome! Co u nás budete dělat? 1) Záznam výukových lekcí 2) Pomáhat st...
...není UART bootloader dostupný. Bohužel ostatní piny jsou plně využité. Komunikace s PC je přes FTDI chip a USB jako standardní virtual Com port. Funkce bude standardní. Po restartu bootloader čeká na příkaz a pokud nepříjde (do cca 5s) jde rovnou na aplikaci. Pokud přijde čeká na poslání dat nového FW a po uspěšném zapsaní skočí na aplikaci. Je dán komunikační protokol, data jsou posílána jako string o pevné délce 19bytů - první dva byty jsou moje hlavička, pak je 16bytů dat a jeden byte jako konec. Uživatelskou aplikaci pro PC píšu já sám v Lazarus/Pascal, takže detaily posíl&a...
...main focus of the brand is to reduce waste from events and to use and work gently with materials and props. "Eventačka" offers 3 services: - Tailor made events for business partners, employees, or the public. (Family, Kids or sports day, Corporate events, Employee parties, Christmas parties, Opening events, Company anniversaries, Open days, Roadshow, Garden parties, Galaevenings and other new format that are not so known) - External cooperation with agencies. - Production of "Re-decoration" (decoration, props, upcycling material - reuse, remake, recycle system). Claim: TOGETHER we will transform your values INTO ACTION! (maybe there will only be Together into Action - I do not know yet). Concerning the logo, I do not have a specific idea so far. It shou...
1. Need to download product description 2. Need to transfer into plain text 3. Need to format H1, H2 and table result will be well formated text with proper HTML tags See below: FROM THIS ----------------------------------------------------- Popis výrobku Brusinkový čaj na močové cesty Bylinný čaj porcovaný v nálevových sáčcích. Brusinky obsahují antioxidanty, přispívají k normální funkci močové soustavy, podporují přirozenou obranyschopnost. Bříza, šípek a zlatobýl přispívají k normální funkci ledvin a močových cest. Kopřiva a přeslička podporují vylučování. Složen&...
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
Zdravim :o) Potrebujem preklady textov z SK/Cz do Rustiny U prekladov ide o XML, jednoduche.. priklad: <string name="">Vyberte slovo stejného, nebo podobného významu. Příklad: Primitivní, naivní, jednoduchý, hrubý je správná odpověď [b]primitivní[/b].</string> <string name="">Skvěle! Pokračujte</string> <string name="">Toto není správně</string> <string name="">Informace</string> <string name="">Vyberte si svůj trénink</string> Prvý dokument ma 231 takýchto riadkov....
Mame jednoduchy dokument - 4 (stvor) stranovu brozuru () v Adobe Indesigne velkost - format brozury je A5. Tlacime na papier A4 dve kopie dokumentu , brozury. Chceme vytlacit, mat vystup z tlaciarne ako je na obrazku ... teda po vytlaceni a rozrezani A4 papierov dostaneme dve finalne brozury pripravene na vazbu. Otazkou je: ako porgrame Indesign CS3, alebo CS6 nastavit tlac , collate funkciu, aby brozuru vytlacilo ako na ? Funkcne riesenie odmenime.
I'm in need of a professional who is fluent in Excel, PowerPoint, Weebly, and Microsoft Word. Your expertise would primarily be utilized for the following tasks: - Presentation Design: I have a marketing-focused presentation that needs to be polished and made visually appealing. As the target audience is the general public, your design should be engaging, clear, and persuasive. - Website Creation: The other significant task involves the creation of a website using Weebly. This website will largely serve as a platform for the marketing campaign outlined in the presentation. The ideal candidate should have a comprehensive understanding of: - Presentation Design: You should have a solid track record in creating engaging and effective presentations targeting a general audience....
I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.
I'm looking for a talented 3D artist who can create exceptionally detailed models of physical goods for product visualization. - Expertise in creating high-quality 3D models for close-up views - Experience in representing physical goods in a realistic and compelling m...physical goods for product visualization. - Expertise in creating high-quality 3D models for close-up views - Experience in representing physical goods in a realistic and compelling manner - Ability to accurately capture every facet of a product, down to the minutest detail My project requires a keen eye for detail and an understanding of how to make physical goods look appealing in a digital format. If you have a creative approach and an ability to bring products to life in a virtual space, I would love to...
...floor plan for a metal work project. This diagram will be used for construction planning, so it needs to be detailed and accurate, reflecting the specific requirements outlined in the provided drawing. Key requirements include: - 3D visualization of the structural layout - Conversion of the floor plan to a 3D model - Inclusion of basic labels and dimensions The final output is expected in SKP format, for easy integration with our existing systems. Ideal candidates for this project should have experience in: - 3D modeling, specifically for construction planning - Proficiency with SketchUp - Ability to translate 2D drawings to 3D models with accuracy - Familiarity with metal work projects would be an advantage. Your role in this project is critical, as the 3D diagram you cre...
I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into comprehensib...
I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature of this...
...color; } and in parser class (INTENSITY, ((), 0)); The problem is sometimes the Api giving the color value as string not as interger but only on on checkbox config we add and this already defined in java if(checkVariant is true) then consider it string and parse it what i have to do to fix my code based on that condition so i can parse the string value this way: updateProperties("color", ((), )); how i can solve this issue so in case checkVariant is true then parse it as string otherwise leave it as it is now which integer. can i do that only on parser or i need to change the Pojo class as well (colorWsDTO) who can do it in summery and short let em know
I need a SolidWorks STEP file converted to an editable format for design modification in SolidWorks. Need the full project zip every component seperated.
I'm looking for an experienced Python coder to tackle two key aspects of my project - data analysis and automation. Here's a breakdown of the requirements: - **Data Analysis**: The primary task involves analyzing datasets in CSV format. The selected candidate should be adept with NumPy, able to make sense of the data and derive meaningful insights. - **Automation**: The second crucial aspect is automation. I'm looking to automate certain processes in my project that involve database queries. Proficiency in Django will be necessary here. Ideal candidates for this project would have: - **Strong Python Skills**: You should be well-versed with working on data analysis and automation tasks using Python. - **Experience with NumPy & Django**: Proficiency in these fra...
I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong un...
I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.
...Requirements: - Modern Design: The 3D beauty bed design should be modern, sleek, and elegant. (I have a picture of how I would like it to be) - Color Variations: The beauty bed should be available in black, white, pink, and cream. These colors need to be vibrant and suitable for a beauty bed. - Urgent Delivery: I am looking to get this done as soon as possible. The final deliverable will need to be in a format that I can easily edit on Canva. Therefore, please ensure that the files are compatible and easy to work with. Ideal Skills and Experience: - Proficiency in 3D design, specifically for beauty products - Experience with modern design aesthetics - Ability to deliver high-quality, editable files I look forward to receiving your bids and working with you. I am going to b...
I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This will involve running s...
I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting.
...quotes, parts / inventory, archived jobs, and customer management. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down combo box eg. In-progress, waiting for collection, waiting on parts, not started, completed. - Ability to search by customer, PO number, job status, date, part on both acti...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
Develop macro-enabled Excel file to handle CSV
...Requirements Include: - Incorporating the name "Voilà" into the logo design - Conveying a sense of class and sophistication - Utilizing a color scheme of burgundy/champagne, or gold/ rose gold Skills and Experience: - Proficiency in color theory - Strong background in logo and brand design, especially for food-related businesses - Ability to capture the essence of a brand's identity in a visual format I look forward to seeing your portfolio and discussing potential designs for "Voilà". I have attached the logo I created, but I want something nicer, more catchy. I want to use my logo for Instagram profile, to add on my personal pastry photos, and also on stickers and packaging....
I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while main...
I'm seeking a skilled Python developer who can help me with a critical task: Translating PDFs. The challenge here is to make sure that the translated content in the PDFs maintains the exact same format and layout as the original documents, without any alterations. Key Requirements: - Translate both scanned and text-based PDFs/images: I need a professional who can handle both types of documents with equal proficiency. - Language Proficiency: The translation will be from English to a variety of languages. Your ability to work with any language from a dropdown menu is crucial. - High Accuracy: The translated content must retain the original meaning and context with 95+% accuracy. Ideal Skills and Experience: - Proficient in Python: You should have extensive experience using P...
I have...Change company name: The new name should be seamlessly integrated into the document, replacing the existing one. - Update contact information: The current contact details in the document need to be replaced with the new information provided. Skills and Experience Required: - Proficiency in PDF editing: Experience with editing text in scanned PDFs is necessary, as the document is not in its original format. - Attention to detail: It's essential that the changes are made accurately without affecting other parts of the document. - Familiarity with formatting: Although the user skipped a question regarding specific formatting changes, having a good eye for layout and design would be an added advantage. Please provide a brief summary of how you'll approach this proje...
...Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must use chinese to view it. table name/string partially e.g. "現金流量表" or "被投資公司名稱" or "資金貸與他人"or "轉投資大陸地區" or other name(later can be change). extract table based on table names/string. the table may not be there(depend on the html). If so just skip or single row blank. have to be easy to read and maintain in the future. .py file(source code) not .exe binary file (I think it's not very hard. I've wrote the code already. But only extract one file at a time, and unable to match specific table name/string only table number.) stack table i...
Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP
I have a significant number of handwritten documents that need to be typed. The typed content will be used for data analysis. Key Skills and Experience: - Proficiency in accurate typing - Experience in handling handwritten materials - Strong understanding of data analysis Your role will essentially involve transcribing the content from these handwritten documents into a digital format. It is crucial that the data is typed accurately and with minimal errors. The typed data will be used for analysis, so the freelancer should ensure that the content is easily readable and properly formatted for data analysis purposes. This project is ideal for someone who has experience with data entry, accuracy in typing, and understanding of the importance of clean data for analysis.
I'm looking to create a personal branding profile resume that can be used for various purposes including job applications, and online professional networking. Key Req...Requirements: - Transform my existing CV into a dynamic and well-designed profile resume. Ideal Skills and Experience: - Proficiency in and react js with tailwind CSS or bootstrap or Mui -use frame motion animations and dark and light theme - Proven track record in creating personal branding materials - Ability to translate traditional CV content into a more dynamic and engaging online format. Please note that due to the nature of this project, a solid understanding of personal branding and resume design for online profiles is crucial. check my cv at the attachment , one cv in details and other small on...
I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources
...in need of a Python expert, specializing in web scraping. I require someone who can proficiently extract data from various websites. The specifics of the data may vary from text content, images, links, to contact information. Your key responsibilities will include: - Writing effective and efficient Python scripts to scrape data - Ensuring the data is extracted accurately and in a structured format - Delivering the data in a timely manner The ideal candidate should have: - Proficient experience in Python and web scraping - A strong understanding of data extraction techniques - Proven experience in handling and parsing a variety of data types - Excellent communication skills and the ability to meet deadlines Please be prepared to provide examples of your previous work in web ...
We're seeking a detail-oriente...France. • Utilize various online resources, including: o Search engines (Google, Bing, etc.) o Social media platforms (Facebook, Instagram, LinkedIn) o Industry directories and publications (list specific resources if known) o Business databases (mention specific databases if known) • Gather and verify contact information (name, email, phone number) for each lead. • Compile lead data into a Excel format . Qualifications: • French reading and understanding - ONLY • Excellent research and data collection skills. • Proficiency in using online search tools and social media platforms. • Strong attention to detail and accuracy. • Ability to work independently and manage time effectively. • Familiari...
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displayed. -...
...old WordPress site to a new WordPress site and a new theme. The new theme is already installed with a base configuration that includes the footer/widgets and header/navigation, so the only content that needs to be moved is the body of each page. There are a total of 5 static pages. - Copy content from and format it nicely on the above page. - Reorganize the page; the balance is off, the row and section spacing is off, and the typesetting is not standardized. - Reorganize the page; the balance is off, the row and section spacing is off, and the typesetting is not standardized.
I have a 5-10 minutes MP3 file that needs to be transcribed urgently. I need the transcription to be accurate and in a sheet format. Ideal Skills and Experience: - Proven experience in audio transcription - Ability to deliver high-quality work under tight deadlines - Proficiency with sheet formatting - Strong attention to detail This is an urgent project, so I am looking for someone who can start right away and deliver the transcription quickly. If you have the required skills and can meet this deadline, please bid on this project.
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
I am on the hunt for a creative and talented freelancer to design an engaging company profile in PowerPoint format. This content rich profile will contain detailed information such as our company's history, mission and vision, and the products and services we offer. Given that the target audience is our potential customers, skills in marketing and great understanding of customer demographics will be highly regarded. Proficiency in PowerPoint is a must along with the ability to convey complex information in an easy-to-understand manner. A background in corporate storytelling or alike will be a significant plus. Ideal skills include: - Expertise in PowerPoint - Brilliant storytelling abilities - Understanding of customer demographics - Background in Marketing or related fiel...
I need a cabinet drawing created based on the attached detailed illustrations. Need to add some minor details (ventilation holes, eye bolt etc) to reflect the actual cabinet. The final deliverable should be as per attached example in PDF format. -Need done urgently by Today. -Final version to be provided in PDF format.
