Excel form capture data macroprá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.
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
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 pokračující práci vztahující se k předchozímu projekturemote Upload videos form server to youtube'
I'm in search of a talented graphic designer who can bring my digital promotional content to life. This involves designing a range of materials such as flyers, posters, digital content reels, and social media postings. Key Tasks: - Crafting engaging flyers and posters aimed at boosting advertising efforts. - Creating dynamic digital content reels to capture the attention of a professional audience. - Developing visually appealing and on-brand social media postings. Ideal Skills and Experience: - Proven experience in graphic design, ideally with a focus on digital promotion. - A creative eye for design that resonates with professionals aged 21+. - Proficiency in creating compelling social media content that drives engagement. If you're passionate about designing for digi...
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 ...
...Make numbers 11,12,13 look opposite 4 Colors include four shapes - triangle -square -circle -Heart Name of cards: THE H CARDS Attached is a simple example, but i need a professional product I am seeking a highly skilled graphic designer to create a set of custom-designed playing cards with an Arabian style. This project requires expertise and knowledge in Arabian patterns and symbolism to capture the unique charm and sophistication of this culture. Key Duties: - Develop unique designs for each card while maintaining a cohesive overall theme. - Incorporate Arabian design elements into the artwork. - Use color schemes and patterns that align with the Arabian theme. The ideal candidate would possess: - Aesthetic skills and understanding of Arabian culture and design. - Expe...
...flirting with the borders of abstract drama. There won't be any lines or narration, just pure expressive performance. Key Requirements: - The video must prominently feature activities such as punching and stomping on pillows. - The setting should be exclusively indoors. Feel free to choose rooms that will enhance the theatric and dramatic quality of the video. - Inject drama into the video to capture viewers' attention. Ideal Skills: - You should have a knack for direction, to precisely manifest my vision. - Experience in dramatic filming or a related artistic field would be beneficial. - Ability to create engaging, non-verbal storytelling through the video. - Knowledge in video editing will be beneficial to make the video more compelling and dramatic. Looking f...
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.
** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportuni...opportunities; * Comprehensive knowledge of research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Exce...
I'm looking to capture my family history in a unique and timeless way. This will involve creating a comprehensive documentation of our family history. Additionally, I'd like to have an exact replica of a cherished family T-shirt, which holds sentimental value. Key Requirements: - Replication of Family T-Shirt: I'm in need of a skilled individual who can recreate an exact duplicate of a special family t-shirt. The ideal candidate should be able to produce a high-quality replica with a strong attention to detail. - Skilled in garment replication or fashion design - Attention to detail and ability to recreate a piece accurately Please let me know if you're interested and have the necessary skills for this unique project.
...ATV/UTV/Watercrafts. The plan should focus on securing funding from investors with a solid elaboration on how the dealership will operate, grow and sustain itself. In particular, I'm looking for: - A detailed plan that proves the viability and potential of this venture. - A strategic approach to engaging investors and securing their financial backing. - A clear explanation of how the dealership will target and capture the ATV/UTV/Watercrafts market. - An analysis of the competitive landscape and a strategy for differentiating the dealership. - Projections for growth, revenue, and profitability over the next 3-5 years. Ideal Skills and Experience: - Proficiency in Business Plan Writing: Experience in creating successful business plans that have resulted in securing funding....
...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. - ...
...smirking and pensiveness among others. - Platform: Though the primary deployment platform isn't specified, a PNG format that can openly be edited and used across varied platforms is required. Ideal Skills: - Graphic Design: Expertise in designing refined, elegant, and vibrant PNG emojis. - Creativity: Ability to bring intuitive and refreshing ideas to the table. - Attention to detail: Capability to capture and design nuanced facial expressions accurately. A proven track-record on similar projects or in creating personalized emojis will be highly beneficial. This project demands a keen eye for detail and a knack for understanding and channeling emotions into graphic design. If this intrigues you, place your bid and let's explore the uniqueness together. MUST HAVE BUBB...
...be modern, easily recognizable, and scalable for use on various platforms and sizes. Color Scheme: We are looking for a color palette that stands out yet feels intrinsic to both the digital nature of blockchain and the dynamic energy of sports. Suggestions include, but are not limited to, combinations of blues, greens, or metallic tones to represent technology, alongside vibrant accents that capture the excitement of sports. Typography: The typeface should be clean, contemporary, and easily legible. It should work well on both digital interfaces and physical merchandise. Iconography: Consider incorporating elements that reflect both the sports and technology aspects of our company, possibly through subtle cues or abstract representations. Deliverables: - Final logo design in...
I am looking for an experienced wedding photographer who excels in traditional style photography for capturing every crucial moment of my special day. The project involves: • Pre-wedding photography. • Capturing the wedding ceremony. • Coverage of the reception. Key requirements include: • Excellent traditional photography skills. • Ability to capture in multiple settings. • A keen eye for capturing every potential memorable moment. Your portfolio of past weddings captured in the traditional style would help me make the decision. Please detail your experience and your ability to document the entire day comprehensively.
...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. *...
I'm seeking an experienced and creative writer specialized in the fantasy genre. Key elements to be included in this webnovel are: - Intriguing magic systems - Mythical creatures that enrich the world - Epic battles that capture reader's attention The story will revolve around a compelling hero or heroine. It's important for this character to be well-developed and relatable as they embark on their journey. Expertise required include: - Proven track record of writing in the fantasy genre - Solid understanding of character development - Ability to weave intricate, immersive worlds - Proven experience in creating engaging battle sequences This project requires a creative yet structured way of thinking, tailoring a captivating narrative that aligns with these key ele...
...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 a...
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 have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NOT bid. budget is $35
I'm in search of a skilled photographer and videographer with an artistic edge to capture my live music concert. Key Requirements: - You should have a strong portfolio demonstrating your ability to capture unique angles and offer creative visions in both photography and videography. - The final output should be raw footage. Post-production editing will not be necessary as we'll be handling that in-house. Ideal Skills and Experience: - Proven experience in capturing live music performances. - Strong artistic sense and innovative approach to photography and videography. - Ability to work well under pressure and in fast-paced live environments. If you're passionate about music and have a talent for capturing performances in an artistic and captivating way, I...
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 am looking for a talented graphic designer to create eye-catching, bold and vibrant labels for large plastic bottles (over 16 oz). The design should be able to capture consumers attention quickly, while providing essential information clearly. The label should include: - My logo and product name - Ingredients and usage information - Company contact information Ideal freelancer for this project should: - Have a good eye for color and visual arrangements - Have a portfolio that includes similar tasks - Be detail-oriented to ensure accuracy of information on label - Be communicative and open to feedback - Have experience in packaging design, preferably in plastic bottles. I look forward to seeing your proposals and working together to create a label that truly represents my pro...
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.
I am in need of a personal semi-realistic illustration. I would like to have my friend's face in place of the Burger King king's face, like in the attached picture. I can supply a picture of my friend upon acceptance. Finally, I would like the Burger King logo on the crown and on the necklace amulet to say "Derg...need to be hyper-realistic but should have some degree of detail and depth. - The illustration is for personal, non-commercial use, so the focus is on aesthetic quality rather than specific branding or marketing goals. Ideal Skills and Experience: - Proficiency in illustration, particularly in a semi-realistic style. - A strong portfolio that showcases similar work in the past. - Ability to capture and translate the client's vision into a beautiful...
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...
I'm seeking a skilled designer to create a professional 8.5" x 11" printable policy form. The final deliverables should be in PDF format and a compatible Google Docs version. Key details: - The design should be clean and neat with a consistent font and sizing. - Please keep in mind, I have a rough idea and verbiage for the form. PLEASE DO NOT EXACTLY DUPLICATE THE ROUGH IDEA EXAMPLE OR YOUR ENTRY WILL BE REJECTED. Ideal skills and experience: - Expert in Graphic Design - Experience with Google Docs and PDF - Detail-oriented Please note, I'm looking to get this project completed as soon as possible.
I'm looking for an experienced copywriter to create engaging content for a radio advertisement, specifically targeting young adults aged between 18-34. The primary goal of this copywriting project is to capture the attention and interest of this demographic. Key Requirements: - Proficient in copywriting with a portfolio of previous radio copywriting experience. - Strong understanding of the psychology of young adults (18-34) and how to engage with them effectively. - Ability to create captivating, concise, and persuasive content in a radio-friendly format. - Excellent command of the English language with a knack for creative writing. If you have the skills and experience to deliver compelling and engaging copy, I'd love to hear from you. Please include samples of your pr...
I'm looking for a seasoned video editor to help create thrilling, less than one minute, adventure-themed travel videos for Instagram. Editing needs are basic - clipping, trimming, merging footage. The finalized video should feel ex...Instagram. Editing needs are basic - clipping, trimming, merging footage. The finalized video should feel exciting, embodying the spirit of adventure. Requirements: - Experiences in video editing, specifically in basic edits - Ability to convey an adventurous tone through video editing - Background in editing short Instagram videos is a major plus - Quick turnaround time expected. Your ability to capture the essence of exploration in a short, under a minute clip is highly desired. You're the right fit if you have a knack for storytelling t...
...Freelance Architect Job Description: We are seeking a freelance architect to assist with various architectural tasks including site visits, drafting plans in AutoCAD, taking images and photographs, creating photoplans, SDRs (Site Development Reports), and generating reports. Responsibilities: Conduct site visits to assess project requirements and gather necessary data. Produce drafts and plans using AutoCAD software. Capture images and photographs of sites and relevant details. Create photoplans and SDRs as required. Generate comprehensive reports based on site visits and project specifications. Requirements: Proven experience as an architect or similar role. Proficiency in AutoCAD and other relevant software. Strong attention to detail and ability to adhere to project...
I'm seeking a skilled book designer who can both capture the relevance of my non-fiction work and create a layout that complements the narrative. Tasks: * Cover design: Use your creativity and expertise to design an impactful cover with an illustrative approach. * Interior layout: Ensure a reader-friendly layout that retains the reader's attention and aids in a smooth read. Ideal Skills: * Previous experience in book design, specifically non-fiction. * Ability to translate my ideas into a visually compelling book cover. * Mastery of interior layout design to make the text inviting and accessible. Your portfolio showcasing similar projects will strongly support your application. I look forward to seeing your vision come to life in my project. Looking for an artistic ...
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...
I am seeking an experienced Sage X3 user to help create and customize sales order, purchase order, and invoice forms in my business's system. This project r...my business's system. This project requires a deep understanding and experience with Sage X3, specifically version 12. Key tasks: - Develop and design a sales order form - Develop and design a purchase order form - Develop and design an invoice form Skills and Experience: - Previous work with Sage X3 version 12 - Previous work with Crystal Reports version 2020 - Extensive knowledge in form creation and customization - Experience in Sales Order, Purchase Order, and Invoice process and form design When making a bid, I would like to know more about your experience with Sage X3, particu...
I'm in need of an experienced individual who can assist me in creating a system to prefill application forms on a website. Here are the specifics: - You'll be working on automating the prefilling of the application forms. The form type in question are specifically application forms. - The prefilled information will be sourced from user inputs on a previous page. This is essential for seamless user experience. Ideal candidates for this project will have: - Proficiency in web development and form automation - Experience in working with application forms prefills - A keen attention to detail for accuracy in prefilling - Excellent problem solving skills to address any unforeseen issues Please reach out if you're confident in your abilities to deliver on this pro...
I require an experienced photographer to help me update my business's headshots and capture some shots for our YouTube channel. The style of photography I'm seeking is artistic, with unique angles and lighting. It's crucial that the photos stand out and possess a creative touch. The photo shoot will be conducted indoors. It's important that the photographer has the knowledge and equipment to manage lighting and other indoor challenges to ensure top-quality shots. - Experienced with both headshot and YouTube photography - Possess an artistic and creative approach - Skilled in working with indoor lighting - Familiar with creating images for a business context Please provide a portfolio of your previous work that demonstrates your ability in these specific area...
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'm looking for a professional photographer to help capture our used car inventory. This will be used for our online platform and listings. Key Responsibilities: - Photographing under 50 used cars - Ensuring that the photos are of high quality, showcasing the cars in the best light - Editing the photos to make them suitable for our online inventory Ideal Skills and Experience: - Proven experience in photography, especially with cars or products - Proficiency with photo editing software - Understanding of e-commerce and online inventory needs - Attention to detail and an eye for aesthetics Please provide a portfolio of previous work, especially related to car photography, when applying.
