Can combine contents excel spreadsheets spreadsheetprá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.
Who is the Czech who can help me translate the language from English into Czech?Kdo je dáma, která mi může pomoci přeložit jazyk z angličtiny do češtiny?
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
I want to make a browser-based epub/pdf/text viewer that supports annotations For the first step, I need a dev to make a nodejs script that can convert epubs, pdfs, and txt files to static html files. I want 1 file for each chapter. The script should produce a that links to all chapter files. If a file has no chapters, break the book into 4000 words chapters Also it should produce a table of contents .json file. The file lists all the chapter files. Link to a similar project in your bid if you have it. Thanks for bidding
I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.
I urgently need an experienced web scraper who can extract data efficiently from multiple websites. Applicants' guidelines are as follows: 1. Websites for Scraping: Due to security concerns, the websites to be scraped will only be shared with the selected freelancer. 2. Application Contents: I didn't explicitly mention what I want freelancers to include in their applications. However, demonstrating your skills, experience, and past work related to web scraping will surely be a significant advantage. 3. Project Deadline: I require this project to be completed as soon as possible. Please include your estimated completion date in your proposal. Ideal Skills & Experience: - Proven experience in web scraping - Knowledge of Python, Selenium or other scraping tools...
I'm seeking a highly skilled freelancer to assist with in-depth Android application security assessment. Skills in the following a...APKTool, and Ghidra Intermediate level of experience in Android application security assessment. Ideal Skills and Experience: Demonstrated experience in Android application security assessment, vulnerability identification, and mitigation advice. Specific expertise with Volatility, APKTool, and Ghidra. Ability to provide comprehensive project proposals including the following structure: Table of Contents Abstract Abbreviations List of Figures Introduction Conclusion References Note: I have an existing codebase for analysis and will provide it as a sample. Please include your previous work samples and detailed project proposals in your applicat...
...skilled in several modules. - Portal users can only visit National Skills Competition module for view only, and have their own filter settings, but they can't make any changes and can't see any other modules at all, what they can do is just view NSC module, use the search, filter, or print(if available) features, also, please instruct us how to create this specific users. - Co-ordinator in project/Task can also edit the project/task/so/sales/quotation / purchase order and all custom modules we created - Additional five Project list reports, just use the existing one and change the fields, add one combine report and one button or dropdown list then generate that. - Task, one click to update or add, create buttons in the task, then each button c...
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator eng...
I'm in need of an expert in Excel, Access or similarly powerful programs to handle a large spreadsheet task. Although the specific tasks that need to be handled were not decided upon, proficient data organization skills are essential as we may need to restructure large data sets. The ideal freelancer for this job should: - Have expert skills and proficiency in Excel and Access. Knowledge of other data organization tools will be considered a plus. - Showcase notable experience, specifically in dealing with large data sets and complex spreadsheets. - Since the specific tasks to perform were not mentioned, a flexible approach and ability to adapt with regard to potential data analysis and data entry tasks will be greatly appreciated. With your application, ...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
I am looking for a LinkedIn specialist who can help me with the following tasks: • Data research: You will need to research and find the best prospects for my business based on their profile, industry, location, and other criteria. You will need to use sales navigator and other tools to conduct effective data research. • Profile research: You will need to analyze and evaluate the profiles of the prospects you find and determine their level of interest, need, and fit for my business. You will need to use sales navigator and other tools to conduct thorough profile research. • Data filtering: You will need to filter and sort the data you collect based on the most relevant and important criteria. You will need to use sales navigator and other tools to perform accura...
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements with...
I need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file
Monthly, we populate a spreadsheet with the over time of the technical team, and the weekend / night shifts of the tehnicians working outside the business hours. We have a template that we want to improve. 2 categories: 1. Managers doing overtime (regular / night / weekend) and being oncall. 2. 24h shifts: complement to the salary based on night / weekend hours we should be able to calculate monthly the amount to be added to the fixed salary attached template (with complicated formulas and errors)
...Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communication skills. I need someone who can articulate updates and issues clearly and professionally. - Prefer if you can speak Arabic; however, it is not mandatory. This role is perfect for a self-motivated individual who wants to con...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have don...
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I'm seeking a talented designer who can craft a minimalistic logo for my brand. I have played with GPT and came out with some logos ideas that I would like to combine into one final logo Key Responsibilities: - Develop a minimalistic, sleek yet eye-catching logo design following the guidelines recommendations I have generated with GPT - Provide iterations based on feedback until satisfactory conclusion Ideal Freelancer Should: - Showcase past work demonstrating design abilities, particularly in minimalistic logo design - Have experience in logo and graphics design - Have a knack for color coordination and branding Looking forward to sculpting a powerful, minimalistic logo inspiring brand recognition.
I'm looking for a proficient developer who can add a page to my website that interfaces smoothly with my MySQL database. The website already has formatting etc, so I'm not looking for that. The database stores a variety of exercise data, and the webpage needs to display this data in an intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from a drop-down list. The...
My website video needs a professional edit. It should provide information about my website in an engaging way. I prefer a smooth and p...should provide information about my website in an engaging way. I prefer a smooth and professional style for the video. Note that I want text overlays included, and I'd like viewers to be able to toggle sounds on and off. The video will be created by using various video clips that will be meshed together seamlessly. Key skills and experience: - Professional video editing skills - Ability to combine video clips creatively - Experience in creating engaging informational videos - Expertise in adding text overlays - Understanding of sound toggle options in video playback. Please share examples of your previous work that demonstrate these ski...
...that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel...
...research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sens...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create...
...talented article writer who can help me create engaging, detailed biographies around net worth analysis. The articles will need to cover different individuals and their professional and personal journeys. Key requirements: - Ability to research and compile engaging biographical content - Experience in analyzing net worth, and presenting it in an accessible way - Strong writing skills, with the capacity to deliver both professional and personal tones - Quality sources to back up the net worth and biography analysis The ideal candidate will have a mix of a journalist's curiosity and a financial analyst's precision. This project will offer an opportunity to craft insightful pieces on successful individuals, and delve into the financial aspect of their lives. If you c...
...for a store in Chelsea Massachusetts. This project should blend with a newly opened robotic fulfillment center newly built in Tewksbury, Massachusetts. The store is in nearby Chelsea, Massachusetts. The initiative is from the store, that is why we have no feasibility study budget. A preliminary template has already been built by an Ai assisted feature of Microsoft 360. Nobody has any real spreadsheet acumen to go any further, but our data series and needed parameters are ready. I've been hired to work in the new robotics center due to my past technical background and current Home Depot store merchandising and shrink knowledge. My time frame is 4 weeks as our data streams refresh every two weeks. and I will have two complete sets by then. After that, 30 days of testi...
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
I'm looking for a talented graphic designer to create a logo for my new property management company. This logo should stand out yet be minimalist in style. Key Specifics: - Ideal colors are warm and bold, such as peach, mild orange, and dark reds/burgundy. - The logo can incorporate a building silhouette. Or even an abstract building. - I prefer the logo not be too tall or too wide. More of a block shape. The ideal freelancer for this job is experienced in modern, minimalist logo design and is able to combine abstract ideas with strong design elements. Color sense is crucial for this task. I look forward to viewing your portfolios and working with a creative mind to bring my vision to life.
...2. I want to learn a language in which we write a code once and can compile for any platform. 3. One possible answer to my questions is JavaScript. We can build server side apps in JS using Node.js & Next.js. Javascript can be embedded in HTML on client side too. We can build desktop apps in JS using Electron and we can make mobile apps in JS using react & angular. But in javascript will code be exactly same for all platforms ? 4. Another option is Flutter (Dart). 5. Which is better out of these 2 ? or can you suggest any other option apart of these 2 6. As of now I want to develop a web app for visual DBMS quite similar to ms access. It will look like a spreadsheet but will have capabilities of both Google sheets / MS excel...
...and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient data flow throughout the application. Frontend Development: Design and develop a user-friendly e-commerce website where customers can browse and purchase generated images. Database Management: Set up a database to manage user data, transaction details, a...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generat...
...Maker - Model - Year - RoofType Their relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific ...
I'm seeking a freelancer to assist me with entry-level data entry tasks in the comforts of my home. Key Responsibilities: - Handling simple data entry tasks. - Ensu...Responsibilities: - Handling simple data entry tasks. - Ensuring accuracy and attention to detail. Ideal Skills: - Basic understanding of data entry procedures and systems. - Familiarity with spreadsheets and online forms. - Excellent typing skills. Experience: - While I require a beginner level of experience, any past exposure to data entry tasks will be considered beneficial. Submission: - Your tasks will be submitted via email, so a good grasp of communication through this medium is important. This opportunity would be perfect for someone who's looking for an entry-level data entry role that can...
...gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of HTML, CSS, and JavaScript to understand the structure of web pages. Ability to work independently and meet established deadl...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure...
