Excel vba data conversionprá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í.
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
...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...
...slijedecim koracima: Template: Dodatna literatura (koga interesira)
...requirements through influence, facilitation, and communication. The individual will gain an understanding of the customers, identify business problems that need to be solved, and document the current state drivers of those problems. The individual will need to map process flows, capture data requirements, create user stories, and document findings in a format understandable to all stakeholders. The Functional Business Analyst 2- RTB will serve as a liaison among IT, business partners, product owners, architects, data analysts, quality assurance analysts, project managers, executives, and software vendors in the evaluation, design, development, and implementation of solutions. The individual must be able to adapt their messaging to the audience and bridge the communication...
I need a professional with proven experience in converting email images to HTML that works smoothly in Microsoft Outlook. This task is urgent, requiring completion within one week, so please consider this timeframe before bidding. Key Project Details: - The project currently as test involves 1 email image. - These images must be accurately converted into HTML following specific style guidelines that I will provide. - The final product should render perfectly when viewed in Outlook and any other email services. Ideal Skills and Experience: - Proficiency in HTML/CSS - Experience in converting images into HTML especially for email templates - Familiarity with Outlook's HTML compatibility - Ability to adhere to design guidelines and recreate styles from images - Usage of Figma (is a ...
...specific MLB data. Essential parts of this data include game statistics, player performance, and team standings. The spreadsheet should be organized in a user-friendly way as mentioned below: 1. Date Range: The spreadsheet must cover a specified date range, which I'll provide upon hiring. 2. Included Players/Teams: The spreadsheet should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on which pitcher is better, and predictions on which team will win. The ideal candidate will have a strong background in data manipulation, particularly in Excel or...
I need a freelancer proficient with both Excel and Photoshop for two primary tasks. Excel Work: - Conduct data analysis and create visualizations, leveraging skills in updating and organizing data Photoshop Work: - Provide graphic design and photo editing services Ideal candidate should have solid experience in both platforms and a keen eye for details. Understanding my needs in data management and visual design will be a key success factor.
...audience includes adult women and men's clothing. - Referral System: We also need a referral structure where individuals can earn a commission for referring our products. This system should be integrated into our website and social media platforms. Ideal skills and experience: - Proven track record in social media marketing, particularly for e-commerce brands. - Experience with lead generation and conversion-focused strategies. - Familiarity with referral marketing and setting up commission systems. - A creative and engaging approach to content creation. - Understanding of the demographic and how to target them effectively on social media. If you have experience in these areas and can help us achieve our goal of increasing brand visibility and generating leads, I'd ...
I have a collection of 15 PDF and mixed Word documents that require conversions and substantial edits. The services I need include: • Reformatting the PDFs to editable Microsoft Word files • Major content overhaul where entire sections need rewriting The ideal freelancer for this job should have a strong background in editing and rewriting content. They should also have good experience with PDF and Word conversions and reformatting. As I haven't specified the nature of formatting changes required, freelancers with a keen eye for detail and overall document aesthetics will have an edge.
...of the Saarey Music app store listing on Google Play Store. The current Store Listing Conversion Rate is 30%. The goal is to be >60%. See: The engaged freelancer must: - Enhance the existing app description with more captivating and engaging text which aligns well with the audience of South Asian classical music. - Create new, exciting promotional banners, graphics that illustrate the essence of Saarey Music and South Asian classical music. - Redesign the app screenshots, making them more attractive and appealing to capture the interest of potential users. - Make any other changes necessary to achieve the >60% conversion target. A reference listing is:
I'm in need of an expert who can quickly convert my Laravel website into a Progressive Web App (PWA). You should be well-versed in both Android and iOS optimization and have a deep understanding of how to make a web app feel native on both platforms. Although I am unsure about the offline functionality, I'm hoping to have a detailed discussion to determine its implementation based on your professional suggestion. This project will require you to convert the entirety of my website into a PWA, not just selected pages or specific functionalities. Ideal Skills: - Laravel Framework Proficiency - Experience in PWA development - Knowledge of Android and iOS optimization - Understanding and Experience in native app development. This will be a challenging project, yet rewarding fo...
...who can build an email marketing service website focused on building brand awareness specifically tailored to small businesses. The website's foundational feature should be built around: * Easily accessible subscription form * Analytics dashboard * Template creation tool Despite these functionalities being optional, I'd highly prefer incorporating them to potentially maximize engagement and conversion rates. The ideal candidate for this project will have: * A strong portfolio of similar projects * Knowledge in email marketing trends and strategies * Experience working with small businesses * Proven understanding of UI/UX principles * Advanced web development skills including HTML, CSS, JavaScript and SEO principles In summary, this website should work seamlessly as...
I'm in search of a professional with proven expertise in utilizing various platforms such as social media, food blogs, and influencer marketing platforms to promote a pricing plan targeting food businesses, restaurant owners, and food bloggers. Key requirements include: - Demonstra...promoting products, services, or pricing plans across social media, food blogs, and influencer marketing platforms. - Understanding of the food influencer market and ability to target food businesses, restaurant owners, and food bloggers effectively. - Focus on generating leads and conversions, in addition to building brand awareness. This job is for an expert who has a solid track record of conversion- and lead- driven results. If this sounds like the perfect opportunity for you, please don...
...work with engineering team on event labeling and providing necessary data for platforms. Job: We are looking for a Email Automation Pro, a strategic thinker with the technical proficiency to impact our marketing success. The person will utilize their expertise in marketing automation platforms to design and execute targeted campaigns that nurture leads, drive engagement, and maximize conversions. They will use their design and user knowledge to optimize conversion flows. From creating automated workflows to personalizing customer journeys, their skills will help us deliver relevant and timely messaging across Email channels. Your responsibilities will include: - Interacting with diverse platforms to extrapolate data. - Developing a smart automation str...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
hello everyone we have a CRM which allows us to manage our customers, a CRM entirely coded by us in html php and javascript. we have started to integrate a function which allows us to insert customers into our CRM using an excel file, but I don't have the time to finish that. It must be ready before the end of the day, today! mandatory deadline. if we are satisfied we will entrust you with many other missions on this brand new CRM
...turning the conceptual designs into functional, dynamic modules. Delivery Expectations: Bricks Widget Creator JSON Output: Provide the JSON output from the Bricks Widget Creator for integration and further customization. Details will be sent in the next message. WordPress Plugin with the Static Modules: Package the static modules into a WordPress plugin, ready for deployment and activation. Conversion to Dynamic Modules: Lastly, transform these static modules into dynamic ones, enabling them to fetch and display content dynamically within WordPress environments. Your Profile: Creative and technically skilled in web development. Proficient with Bricks Builder, WordPress, HTML, CSS (with a focus on REM units), and PHP Experienced in converting Figma designs to fully functional ...
I'm looking for a professional with a unique vision and the ability to create engaging, product promotion layouts for my upcoming website. My project includes: - Content structuring across 10 or so pages specifically focused on promoting hair products. - Effectively displaying content in a way that encourages user interaction and leads conversion. - Collaboration on aesthetic choices to ensure a unified and impactful web presentation. Ideal for freelancers with: - Proven experience in custom layout designs, especially with product promotion and engagement pages. - An understanding of user experience and interface that drives interactions. Looking forward to turning my vision into an exceptional web experience for my customers. All content will be provided.
I'm looking to create a create a backup of our existing static website and migrate the site to a WordPress CMS. Key Requirements: - Theme Selection: I haven't finalized a WordPress theme yet, and I'm open to both custom development and pre-made themes. - Main Purpose: The primary function of the site is informational and blog-oriented. Skills and Experience: - Proficient in both static site migration and WordPress CMS. - Knowledge and experience with creating backups of static sites. - Ability to suggest and select appropriate themes based on my site's needs. - Experience in developing custom themes or adapting pre-made themes to meet the specific requirements of a site. - Familiarity with best practices for SEO and user experience in a blog/informational site contex...
I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.
I'm looking for a qualified Google Ads expert to set up and manage a campaign aimed at driving more traffic to my website. The primary focus will be local customers interested in professional services. Below is a rundown of the specifications: - T...is local customers. - The campaign will promote professional services. The ideal freelancer for this job will have: - Comprehensive knowledge of Google Ads, particularly in driving website traffic. - Proven track record in engaging local customers. - Familiarity with promoting professional services on Google Ads. This project offers an opportunity to showcase effective local targeting and conversion strategies. The successful candidate will hopefully establish a long-term working relationship with us. Looking forward to your b...
...skilled in presentation design and web development to turn a PowerPoint presentation into an interactive web presentation. On my Wix site. See for my first draft attempt. Key Project Details: 1. **Video Embedding**: Include embedded videos in the web presentation. The video content will primarily be long-form speaker narratives, exceeding 10 minutes in length. 2. **PowerPoint Conversion**: The chosen freelancer will work on converting the existing PowerPoint presentation into an equivalent online version, maintaining the look and feel while ensuring seamless functionality. The ideal candidate for this project would have: • Experience with web development and designing presentations • Good understanding and experience of incorporating and embedding video content into ...
...Requirements: - Must demonstrate a deep understanding of , and fonts. - Must have experience with SVG and JavaScript. - Proven track record with or similar library usage. Ideal candidates can deliver high-quality work, adhere to deadlines, and communicate effectively. About 80% of the work is already done but the last details (for example correct position after conversion) need to be developed. There are even more features we like to implement in the future. What already works: - Converting any font to paths using What's not working: - Keeping the exact position of the text when it was converted - Sometimes kerning seems to be a problem - Multiline, rotation, skewing Fixing that probably needs a deep understanding of and the concept of
As a vendor, I have three excel sheets containing product numbers and corresponding data. Both sheets are error-free and completely filled in, but the second sheet has its entries in a mixed order. I need a freelancer who is adept in working with Excel to match the data in the sheets based on product I.D number using the product numbers and or product name (TRS Direct Sheet) to match the size dimensions in the other sheets as highlighted via colored columns (must match colors) Sheet format cannot be moved or changed or altered in the cells already published on the 2 sheets as listed only the DATA MASTA it effects the upload process. area highlight pink no information or changes to be made or added please scroll through to observe existing pink cells. Her...
...the store for effective marketing campaigns. Key tasks include: - Configuring Shopify store: The successful candidate should be adept in customizing Shopify stores, ensuring a seamless purchase journey for customers. - Integrating Facebook Pixel: I require the freelancer to link my Shopify store with Facebook Pixel. This will involve installing the Pixel, creating custom audiences, setting up conversion tracking, and ensuring that the integration is correctly implemented. Ideal applicants should have: - Proven experience in Shopify web design and development, particularly in configuring stores for optimal performance. - Proficiency in setting up and integrating Facebook Pixel on Shopify platforms. - A strong understanding of e-commerce and digital marketing will be a definite a...
...using IP and Port. This stream needs to be converted to HLS, and it has to include the SCTE tags for ad insertion. Key Requirements: - Convert live video with SCTE 35 markers from UDP to HLS - Ensure the SCTE markers are maintained in the HLS stream for ad insertion The HLS stream will be delivered to both web browsers and Smart TVs. As for the programming language or framework for the HLS conversion, I'm open to suggestions. You can use any language or framework that you're comfortable with. Ideal Skills: - Experience with video streaming technologies - Proficiency in programming languages like Python, JavaScript, or Ruby - Familiarity with SCTE 35 ad insertion - Ability to work with UDP and HLS protocols This project is time-sensitive, so I'm looking for so...
I need an expert in Google Ads, who can effectively manage ads on both desktop and mobile platforms. I aim to boost my product sales to an international audience. Here's what I am looking for:...Google Ads, who can effectively manage ads on both desktop and mobile platforms. I aim to boost my product sales to an international audience. Here's what I am looking for: - Proficiency in Google Ads management across platforms - Ability to research and target international markets - Experience with e-commerce or sales-focused campaigns - Knowledge of strategies to improve click-through and conversion rates - Monitoring and reporting on campaign performance Using Google Ads to improve profit margins is my goal. If you can deliver results and have the necessary skills, I would lo...
I'm in need of an adept hydraulic or fluids engineer to create a PVC pipe gold trap tailored specifically for high water flow. Key components for this project would be: - Efficiency: The design should excel in gold particle collection, regardless of particle size - from less than 0.5mm to 2mm. - Adaptability: The trap will be utilized in a sandy soil environment. - Durability: The trap should possess a high erosion resistance to exceed in everyday wear and tear in mining operations. Your expertise in fluid mechanics, material selection and applying scientific principles to practical application would make you an excellent fit for the task. An understanding of the gold mining process would be a plus but isn't necessary. I'm looking forward to discussing your ideas an...
...compliance with GDPR and other data protection regulations. **Additional Requirements:** - Provide training or documentation for website management. - Implement tracking codes for Google Analytics and other marketing tools. - Conduct user acceptance testing (UAT) and resolve any issues. - Offer post-launch support for bug fixing. **Key Skills Required:** Proven experience in developing corporate websites (preferably for marketing agencies) Proficiency in HTML, CSS, JavaScript, and relevant web development frameworks Strong understanding of WordPress or other CMS platforms Familiarity with SEO best practices Ability to create modern, responsive, and accessible designs **Preferred Qualifications:** Portfolio showcasing similar projects Experience with conversion o...
I have a series of PDF files in English that need to be converted to Word format. The PDFs are relatively simple in terms of formatting, requiring straightforward text translation. Ideal Candidates: - Proficient in English for accurate conversion - Experience with PDF to Word type conversions - Detail-oriented to ensure no content is missed Please note that no images are present in these PDFs, so the task is limited to text conversion.
I'm in need of a UTM tracking expert to help me monitor the effectiveness of my campaigns and optimize them for better conversion rates. The campaign will be running on Stann App. Key requirements include: - Setting up UTM parameters to track campaign effectiveness within the Stann App - Measuring and analyzing website traffic generated from these campaigns The ideal freelancer for this project should have: - Strong experience in UTM tracking and campaign analysis - Previous work on tracking app-generated website traffic - Proven ability to optimize campaigns for better conversion rates Please let me know if you have experience with UTM tracking for mobile apps, especially Stann App.
...reliable and affordable suppliers. - SEO Content Creation: To ensure that the products are effectively marketed and attract the right audience, I need an individual who can create compelling SEO content for the product listings. Proficiency in keyword research and SEO strategies is a must. Page Design and Listing: The overall appearance and layout of my store are crucial for user experience and conversion. The selected freelancer should be adept at listing products and enhancing the aesthetics of the store through thoughtful page design. The target audience for my Shopify store is all genders. Therefore, I need someone who can curate the product selection and design the store to appeal to a broad demographic. Please reach out if you have proven experience in product sourcing,...
...improve the discoverability of my store via effective SEO practices and innovative marketing strategies. Ideal candidates would have a keen eye for design and proficiency in SEO. Experience with Shopify store management would be advantageous. I'm looking for someone who can measurably improve my store and its visibility online. Your strategies and concepts should encourage increased traffic and conversion rates. If you're innovative and results-driven, I'd be happy to consider your bid....
...user interactions. Additionally, we aim to implement the Google Ads Conversion Tracking to precisely monitor and optimize our Google Ads campaigns. This will allow us to effectively measure the impact of our advertising efforts and adjust strategies to maximize return on investment. The scope of this project includes the setup of a new GTM container, implementation of the necessary data layers on our website, and the definition of variables and event triggers. We will also set up and configure Google Ads Conversion Tags within GTM to ensure that all conversions from Google Ads are accurately tracked. This includes mapping out the user journey from ad click to purchase, ensuring that each step is properly tagged for conversion tracking. The project recipient i...
I have a series of PDF files in English that need to be converted to Word format. The PDFs are relatively simple in terms of formatting, requiring straightforward text translation. Ideal Candidates: - Proficient in English for accurate conversion - Experience with PDF to Word type conversions - Detail-oriented to ensure no content is missed Please note that no images are present in these PDFs, so the task is limited to text conversion.
As your client, I'm looking for a specialist having a proficient knowledge of Microsoft Excel to achieve a simple data manipulation project. The task involves predictive analysis of data, heavily leveraging date and time functions. Key Responsibilities: - Manipulating data using simple Excel functions. - Predictive analysis using Excel based on the manipulated data. Ideal Candidate: - Sufficient proficiency in Microsoft Excel, with specialised expertise in date and time functions. - Strong attention to detail and accuracy in data entry and analysis. - Superior skills in organising and ability to handle increasing complexity when required.
I am in need of a sophisticated landing page for my website offering a unique service. The landing page should be high-functioning and include elements such as a call-to-action (CTA), a lead magnet feat...sell a service - Master the implementation of lead magnets to capture user emails and automatically send a market research report - Be grounded in setting up subscription functionalities via Stripe and "Buy Now" options The chosen professional should have a creative mind to design an appealing and user-friendly interface. Prior experience in similar projects and excellent knowledge of sales conversion strategies will be highly advantageous. Full instructions document available Can either use existing page as starting point or create from new
I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.
I'm in need of an expert who can proficiently convert a 12-page Excel document into an editable PDF while maintaining its original layout. Key requirements: - Preserve the current layout of the Excel document in the converted PDF. - Ensure the PDF is editable not a read-only. - Important: There are links and media embedded in the Excel document that must remain functional in the PDF. Ideal skills to have: - Strong experience with Excel and PDF conversions. - Attention to details especially concerning layout preservation and media functionality. - Excellent communication skills to address any clarifications promptly. This project requires specific expertise, and the exact replication of the Excel layout is critical. If you feel suited for this ...
I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table. Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.
