Excel data search programprá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í.
Hledáme programátora, který umí pracovat s RabbitMQ. Náplní práce je tvorba systému pro komunikaci s OTE pro obchodování na snitrodenním trhu s elektrickou energií. V příloze se nachází požadavky OTE pro podobu takéhoto systému.
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
Mám pokladní systém který načítá produkty čtečkou čárovým kódem. Potřebuji vytvořit další, vedlejší program, který při načítání kódu balení (více kusů) - zvukově hlásí počet kusů. Z pokladní systém budu exportovat XML soubor, kde obsahuje EAN kód a pokud je to balení - počet kusů. Od toho by mohl program získat informace.
Zjistěte, zda číslo zadané ze vstupu je čtverec. A odsimulujte ve spimu.
Pozdrav druze, meni trebaju uradjena 3 kratka Visual Basic zadatka za ispit, znaci samo code nikakav dizajn. Evo saljem ih na uvid. Poz.
tražim programera koji će mi napraviti jedan program novac nije problem uplata može biti preko banke ili westerunior nebitno HITNOOOOOOOOOOOOO!!!!!!!!!!!!!!!!
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Le...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...ecommerce/employee hiring grants They MUST have a proven strong track record of total grants submitted vs approvals in the last year within Canada. They are responsible for finding funding opportunities for our organization and writing polished proposals to earn Ontario & Federal government grant money. The Grant Writer will identify, define and develop funding sources to support existing and planned program activities as well as lead the development, writing, and submission of grant proposals to the Ontario/Canadian Federal Government. Primary responsibilities include preparation of proposals and grant applications, and performance of responsible professional and administrative work in researching, identifying, developing and responding to Ontario/Canadian grant opportun...
...able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual representations of data. - ...
The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of...spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate, and provide it as well. Start the search from most recent and search backwards in time. Once you find 30 sea-related records, you can stop (+ include a link to the last record you searched).
...our front-end with MongoDB Atlas to create a live search bar for machine parts. Key Responsibilities: - Connect framework with MongoDB Atlas to enable real-time data retrieval for live search functionality. - Implement a user-friendly, intuitive search bar that allows for quick and efficient product searches. - Develop a product display page that showcases detailed information about the machine parts. Ideal candidates for this position should: - Be proficient in JavaScript and have prior experience working with Next.js. - Possess a solid understanding of MongoDB Atlas or a similar NoSQL database. - Have a keen eye for design and UX to ensure a seamless user experience. - Prior experience with e-commerce or product search functionality would be a hu...
...experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. *...
...Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automati...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight meas...for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of sto...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and ...
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
...Features**: While all necessary features such as e-commerce, contact forms, and user registration are present, they require a fresh, modern touch. Your role will be to redesign and optimize them for user experience. - **Content and SEO**: I also require assistance with enhancing the website's content and SEO. This will involve reviewing and potentially rewriting content for better engagement and search engine visibility. Ideal Skills and Experience: - Proven experience in WordPress web development, with a strong portfolio showcasing website redesigns and feature enhancements. - Proficiency in SEO best practices and content optimization. - Strong eye for design and usability, with the ability to create a modern, visually appealing layout. This project is a great opportunity...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly i...
tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...
...Friday and 2 working Saturday - Increase website traffic - Improve search engine rankings - Amplify social media engagement The target audience for this campaign is aged between 30 and 45. Your work should focus on building brand awareness. The ability to attract, engage, and create loyal customers out of this age group is essential. Ideal Skills: - Proven digital marketing experience - Solid knowledge of SMO and SEO - Proficient in content creation, especially for Instagram - A record of successfully enhancing brand awareness on social platforms - Able to engage the 30-45 age demographic effectively Your role will entail planning and executing digital marketing campaigns that resonate with our target audience, using data to make informed decisions and adjustments. I...
The app is supposed to: - Search for specific product and add it in the cart with all needed information: delivery location, accessories, quantity. (Example: HP laptop with 14in size) - Compare the product price and service quality in the platforms and give results of the comparison. ( example: price in Amazon for the laptop is 1000$, delivery time is 3 days, the reviews are 4 star. Same for other platforms) - Direct the user to the selected platform to complete the purchase. (Example: to purchase the laptop from Amazon)
Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...
Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm
...in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel docu...
I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.
I have a series of PDFs with text that needs to be typed into an Excel sheet. The data is mainly textual in nature. Key Requirements: - Data Entry: You'll be responsible for accurately inputting the text from PDFs into the corresponding cells in Excel. Ideal Skills: - Proficiency in Excel: You should be comfortable using Excel and have experience with data entry. - Typing Skills: Fast and accurate typing skills are essential. - Attention to Detail: The data needs to be entered accurately to ensure the integrity of the information. - Familiarity with PDFs: Experience working with PDFs is beneficial. Please note, there are no specific formatting requirements beyond accurate data entry.
I need someone to create social media profile on FB and Insta, manage the social media handles, generate leads for business, run webinars. One part is managing social media handles. Another part is cre...One part is managing social media handles. Another part is create leads. The target audience are small & medium scale businessmen who are looking for branding solutions, business consultancy, brand consultancy. Businessmen who wants to make their brands big and noticeable which will bring growth on business. More details: Which digital marketing channels are you currently using? Social media, Search engine optimization (SEO) What are your primary marketing goals? Generate leads, Drive website traffic Who is your target audience for your digital marketing efforts? B2B (busines...
I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.
As part of my project, I require a thorough analysis of the Sequential Search algorithm. Key Requirements: - An understanding and calculation of the time complexity under all cases: worst, average, and best. - Assessment of the algorithm when working with all types of list: sorted, unsorted, and randomized. The ideal candidate should possess strong problem-solving abilities, excellent mathematical skills, and a deep knowledge of algorithm efficiency. Proficiency in the use of mathematical induction to prove the correctness of algorithms is highly desirable. Your task will revolve around the comprehensive evaluation of the Sequential Search algorithm, making this role perfect for those seeking to apply and grow their knowledge in computer science and algorithm analysis.
...rentals. This marketplace needs to be user-friendly with an emphasis on a smooth, easy to navigate interface. Key features of this project include: - Online Rental Transactions: The platform must support online payments, therefore familiarity with popular payment gateways is essential. - User Profiles: Ability to create and manage user profiles for owners and renters. - Search and Filter: Renters should be able to easily search and filter through available rentals based on various criteria. - Ratings and Reviews: A system for rating and reviewing both vehicles and renters will need to be incorporated. - Security: As this platform will handle confidential user information and monetary transactions, a strong understanding of cybersecurity is essential. The ideal candid...
I'm looking for a skilled developer who can integrate Typesense search functionality into my ASP.NET Core web application. Key Requirements: - Proficiency in ASP.NET Core: It's essential that you're well-versed in ASP.NET Core as this is the primary framework being used in the application. - Experience with Typesense: Prior experience in integrating Typesense search functionality will be a huge plus. Your responsibilities will include: - Understanding the existing application structure and data models. - Implementing the Typesense search functionality seamlessly. - Ensuring the integration is efficient and doesn't compromise the existing functionality of the web application. This project requires a great deal of precision and attention to...
I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.
I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good ...
I'm looking for a professional who can help me revamp my LinkedIn profile to make it more appealing and engaging. I need assistance in various aspects, such as my profile summary, work experience descriptions, and skills and endorsements. Key Points: - Profile Summary: I n...accomplishments and milestones, as well as the impact and results I have achieved throughout my career. - Skills and Endorsements: I need help in optimizing this section to make sure it reflects my expertise. The ideal freelancer for this project should have: - Proven experience in LinkedIn profile optimization. - Strong writing skills and the ability to create engaging content. - Understanding of search optimization and the use of keywords. - Experience in highlighting achievements and results in a profe...
I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.
Desenvolvi uma planilha de excel mas estou a necessitar de ajuda para criar duas novas formulas.
