Excel generate file vbapráce
Potřebovala bych sestavit v Excel nebo v jiném programu algoritmy na manuální zadání nebo načtení přes SD kartu 8mi výstupů z měření na váze Tanita (množství tuku, viscerální tuk, metabolický věk, množství vody, ...) tak, aby se tyto hodnoty převedly do grafické analýzy v podobě grafů, "koláčů" či obrázků zatížení tuku na těle (podobně jak výstup z GMON tanita nebo InBody softwaru). Účel je pro použití pro výstup pro klienty výživového poradce a pro ios systém (MacBook Air). Hledám cenově dostupnou varientu, klidně pro cenovou efektivitu jen v Excelu, ale zajímaly by mě mož...
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.
...Specter Interactive, Alexandra Horká - Support manager We are looking for creative individuals interested in creating an advertising video for our application, Working People. Video Objective: Introduce "Working People" as a useful tool for managers to easily and efficiently track employees' work on various projects and activities, work hours, vacations, and salaries. Showcase how the app helps generate clear reports and facilitates decision-making in personnel management. What the Video Should Look Like: Are you a manager struggling to keep track of employee work hours, vacations, and salaries? Don't worry! Introducing Working People, an easy-to-use app that simplifies employee management. In the video, you will see a frustrated manager facing ch...
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í.
Disassemble Freescale MPC5674F hex file to assembler. IDA PRO, winhex is a must!
I AM LOOKING FOR A CAD DESIGNER TO CREATE A LIGHT WEIGHT YET TRENDY PROTECTIVE CASE THAT SLIPS RIGHT OVER THE LATEST IPAD PRO. HERE IS A LINK FOR THE SPECIFICATIONS FOR THE IPAD PRO. PLEASE REFER TO SIZE AND WEIGHT SPECIFICATIONS FOR DESIGNING GUIDELINES. FORMATTING FOR THE CAD FILE MUST BE IN .STEP, .STP, .STL, .OBJ
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...
Nastavení vytvořených Facebook účtu podle parametrů zadaných v excelu - změna jména, skrytí privatních informací (skrýt zeď pouze přátelé, skrýt kamarády pouze pro přátelů), pohlaví, pohlaví a nastavení nějakých like stránek z Czech Republic. atd. Já pošlu Excel po dohodnutí se na zakázce. První zadání je úprava 300 FB účtů.
...strategic ad campaigns and keyword management. Responsibilities: Plan, execute, and manage paid search campaigns on Google Ads and other search platforms. Conduct keyword research and selection for campaigns to achieve targeted ROI. Write compelling ad copy and optimize landing pages for maximum conversion. Monitor and analyze campaign performance, making data-driven adjustments to improve results. Generate detailed performance reports and provide actionable recommendations. Stay updated on SEM best practices and search engine updates. Requirements: Proven experience in SEM with a strong portfolio of successful campaigns. Proficiency in Google Ads, Google Analytics, and other SEM tools. Strong analytical skills and attention to detail. Ability to manage budgets and deliver res...
I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!
1). I have a trading backtesting software, wherein I need to change n number of parameters for different instruments and different trade times and run the bac...software, wherein I need to change n number of parameters for different instruments and different trade times and run the backtest. 2). Any parameter if I need to change, I spend lot of time in changing those parameters for all; quite a repetitive task. 3). It would have been great if the whole portfolio could be exported in excel format, so that changes could be done via batch edit much faster and imported back. 4). Unfortunately presently export import is via some port file, which is encoded/encrypted and can't be read or batch edited. Requesting any developer to help with this and also some additional feat...
...environments. Primary User Journeys: Personal Users: Open the app and select apps to restrict. Set a restriction duration or use NFC to unlock apps on demand. Review restriction history and adjust app selections. Business Users: Access the dashboard to view analytics and employee profiles. Add or remove employees and enforce restrictions on company-provided devices. Monitor app usage trends and generate productivity insights. Goals: Individual Users: Enhance productivity by reducing distractions. Provide easy, secure app unlocking using NFC. Business Users: Improve workforce efficiency through app usage monitoring and restrictions. Provide actionable insights into productivity trends. This App, along with the purchase of the NFC tag can be used by individual consumers to res...
...845062255859375, "lon": 47.78010177612305 } API Logic: Check for an existing record in the Stores table using the mobile number as the primary key. If the mobile number does not exist, create a new record with the provided mobile number and store the location as a POINT. Generate a temporary link valid for 16 hours and respond with: { "messages": [], "data": { "url": "https//", "errorInfo": "", "storeCreated": true, "storeExists": true } } If the mobile number already exists, generate a temporary link valid for 16 hours and respond with: { "messages": [], "data": { "url": "https//", "errorInfo": ...
I'm seeking a seasoned expert in social media marketing, specifically for Instagram and Twitter, to help elevate my e-commerce business. Key Responsibilities: - Develop and implement engaging marketing strategies tailored for Instagram and Twitter. - Increase brand visibility, customer engagement, and sales through effective use of these platforms. Id...business. Key Responsibilities: - Develop and implement engaging marketing strategies tailored for Instagram and Twitter. - Increase brand visibility, customer engagement, and sales through effective use of these platforms. Ideal Candidate: - Proven experience in e-commerce marketing. - Strong understanding of Instagram and Twitter algorithms and advertising tools. - Creative, with the ability to generate captivating content...
...functionality (add/edit/delete users) - CSV file upload for customer record updates, replacing existing data User Interface: - Secure login system - Spreadsheet (table) style display of customer data - Search functionality by: account number, last name, or service address (partial or full matches) Style: - Professional, streamlined interface with a focus on readability - Color-coded search results for quick identification - Design with optimized layouts for desktop / laptop use Files Provided 'Customer ' - This is the export from our ERP. - File will be uploaded to the app you develop weekly by our staff. - New data will replace old data (removing any data not overwritten by new file). 'THCSD Customer Account ' - This is an excel base...
I need an engaging and effective WordPress landing page designed for my tutoring services. Key Requirements: - The primary goal of this landing page is to generate leads. It should be optimized to attract and convert potential clients, i.e. students. - The design and content should be appealing and relatable to students, as they are my target audience. - The landing page should have a clear and compelling call-to-action, encouraging students to contact a tutor. Ideal Skills: - Proficiency in WordPress and web design - Experience in creating lead-generating landing pages - Understanding of student-centric design and content - Strong knowledge in SEO and digital marketing strategies
I have an STL file for a 3D print and I need a latch to be moved 1mm up, maybe 2, we have to check after printing it. See attached picture. That's it! I do not have a STEP file, only the STL.
I'm seeking an experienced social media marketing professional to enhance our online presence across Facebook, Instagram, and LinkedIn, targeting the USA, UK, India, Singapore, and Australia. Key Responsibilities: - Content Creation: Write engaging content, focusing on IT industry insights, ou...ensure maximum reach and engagement. - Engagement: Foster a community around our brand, responding to comments and messages in a timely manner. Ideal Skills: - Proficiency in content creation and social media management. - Strong understanding of IT industry trends. - Experience in creating engaging multimedia content. - Excellent communication skills for audience interaction. Your ability to generate substantial engagement and interest in our IT services will be key to our success i...
i have the excel file you need to analyse the data and I want to you create advanced PowerPoint presentation presentation it need to be present to the big forums, primarily aimed to the top management. The presentation should reflect a professional and corporate style, with clear, concise content and well-structured slides. Ideal Skills and Experience: - Proficiency in PowerPoint - Experience in designing corporate presentations - Excellent understanding of corporate language and presentation etiquette - Ability to condense complex information into clear, digestible content - Creative approach to maintaining viewer engagement within a professional context.
...Responsibilities: 1. Lead Generation: Use online channels, social media, and networking to generate leads. 2. Telecalling: Reach out to potential students, explain our course offerings, and guide them through the admission process. 3. Target: Each employee is expected to secure 1 admission per day, contributing to the overall target of 50 admissions per day. 4. Sales Conversion: Effectively pitch our courses, discuss the benefits of our 100% placement guarantee, and close sales by helping students understand how they can benefit from our courses. Skills Required: Excellent communication skills (both written and verbal). Strong persuasion and negotiation abilities. Ability to independently generate leads and close sales. Basic understanding of social media and...
...press environment, I offer the following services: - Typing and document formatting using Microsoft Word - Data organization and spreadsheet creation in Microsoft Excel - Desktop publishing with Adobe PageMaker - Image editing and design with Adobe Photoshop I am dedicated, detail-oriented, and committed to delivering high-quality work that meets your specific needs. Ideal projects would involve typing, document creation and formatting, spreadsheet management, desktop publishing, or image editing. Skills and Experience: - Fluent in English with excellent typing speed (40 WPM) - Profound knowledge of Microsoft Office Suite (Word, Excel) - Proficient with Adobe PageMaker and Photoshop - A proven track record of 10 years in computer work related to printing press operation...
The project involves creating a mobile application for both Android and iOS platforms. The primary function of this app is to enable users to capture multiple photos in a single session, tag them with product SKU and quantity, and subsequently export this data into Excel and PDF formats. The app should also support date-wise search functionality to track the captured data over time. Key features include: - A user-friendly interface for capturing and tagging photos - Seamless integration with Excel and PDF for data export - Date-wise search capability Ideal candidates for this project should have: - Previous experience in mobile application development, particularly for Android and iOS - A strong understanding of data export functionalities - Excellent UI/UX design skills...
...of ERP solutions across businesses. Who Can Become a Channel Partner? IT consultants, software resellers, and system integrators. Business professionals with strong B2B networks. Companies or individuals with experience in enterprise software sales. Entrepreneurs looking for a high-growth business opportunity. Key Responsibilities: Promote and sell Tech Cloud ERP solutions to potential clients. Generate leads and build a strong customer base. Provide basic product demonstrations and consultations. Collaborate with our team for technical and sales support. Benefits of Partnering with Us: Access to a well-established and feature-rich ERP software. Strong backend support for sales, implementation, and customer service. High earning potential with recurring revenue opportunities. Exc...
I need a master Excel spreadsheet designed and populated with data from financial documents I will provide. This will include a master page produced from all the data on the separate tabs. - Data Types: The project primarily involves working with financial data, specifically tracking revenue and expenses. - Update Frequency: The data will need to be updated monthly. Ideal skills for this job include advanced Excel proficiency, experience with financial data, and the ability to create clear and comprehensive master spreadsheets. Please provide examples of similar projects you've completed in the past. Each sheet will total and feed into the master page. I would like reports ideally that can be run on total expenses or revenue in a time period as well as ratios to be ...
I'm seeking a skilled SEO blogger with a focus on the higher education sector. The primary goal of my blog is to generate leads, so a deep understanding of SEO techniques to increase visibility and attract potential clients is crucial. Key Responsibilities: - Create engaging, informative, and SEO-optimized blog posts centered around higher education. - Implement effective SEO strategies to enhance blog visibility and lead generation. - Research and stay up-to-date with trends in the higher education sector. Ideal Candidate: - Proven experience in SEO blogging, preferably within the education sector. - Strong understanding of higher education. - Excellent writing and research skills.
I'm seeking a Pinterest expert to enhance our brand presence and sales on the platform. The ideal candidate should have a s...brand's classic and timeless aesthetic. Key Responsibilities: - Create and schedule pins that resonate with our target audience and reflect our brand DNA. - Engage with our followers and respond to comments to build a strong community. - Analyze performance metrics to continually refine our approach and maximize impact. Goals: - The primary objective of this project is to grow our community and generate sales through Pinterest. The ideal freelancer for this project will have: - Proven experience with Pinterest marketing. - A strong background in women's fashion. - Excellent understanding of brand development. - Ability to work with a classi...
I'm seeking an expert excel/vba programmer. I'm using an existing vba macro excel program that needs to be upgraded. It was created to automate the process of building a single inventory list from multiple vendors feeds. The website is now using the Shopify platform and requires data to be imported into different column names and for more columns added. Summary of work required: 1. Need to change the import process to a single form, where feed can be added, vendor profile selected, map file column names to names in the program, save profile and import feed. 2. Adjust Export functionality to use similar template with different columns for different export options. 3. Data in compiled list needs to be read only unless enabled for in-line ed...
I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!
I'm seeking a dedicated digital marketing expert to help manage my advertising and SEO efforts across both Meta and Google platforms. Key Responsibilities: - Google Ads: Set up, manage, and optimize advertising campaigns to maximize reach and ROI. - Google Analytics: Track performance and generate insights to inform strategic decisions. - Google My Business: Ensure my business is properly represented and optimized on Google. - Meta Platforms (Facebook/Instagram): Similar setup and management as Google Ads. Tasks will primarily revolve around: - Campaign Setup and Management: Creating effective campaigns tailored to my business goals. - Performance Tracking and Reporting: Regularly assessing the success of campaigns and adjusting strategies accordingly. The ideal freelancer ...
Budget $25 I'm looking for a Python expert who can write a script for me. The script will open a list of URLs from an Excel spreadsheet and check for specific content. Requirements: - The script needs to check for text on the URLs. - If the content exists, it should create a new column in the spreadsheet with the status of each URL. Skills required: - Proficiency in Python programming. - Experience with working on Excel files. - Knowledge in web scraping techniques. - Ability to understand and implement URL content checking. Please only apply if you can demonstrate your ability to complete this task successfully -
I'm seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.
We are a professional VA agency seeking a skilled and dedicated Virtual Assistant to join our team. This is a full-time role supporting a New York-based real estate company Key Responsibilities: - Manage and optimize Hubspot CRM - Oversee and create content for all major social media platforms (Facebook, Instagram, LinkedIn, Twitter) - Cold call to generate leads and follow up with prospects professionally - Design graphics using Canva for social media posts, email marketing banners, and brochures and flyers Requirements: - Fluent in English (both spoken and written) - Proven experience with Hubspot CRM - Strong social media management skills across major platforms - Confident and professional demeanor for cold calling - Proficient in Canva or similar graphic design tools Familia...
Python Developer: Screenshot Cropping & OCR to Excel Description: Seeking a Python developer to automate data extraction from screenshots with two key tasks: Screenshot Cropping: Crop images to isolate data below column headers. Handle minor variations across screenshots. OCR & Excel Conversion: Use OCR (e.g., Tesseract) to extract text from cropped areas. Save data to Excel in structured columns. Requirements: Proficient in Python (Pillow, OpenCV, pytesseract). Experience with OCR and Excel handling (openpyxl, pandas). Strong problem-solving skills and attention to detail. Deliverables: Scripts for cropping and OCR-to-Excel conversion, reusable and future-proof. Notes: Focused on screenshots only—no web scraping (e.g., Selenium). Prov...
I need a comprehensive, user-friendly sales report spreadsheet designed for monthly data tracking. Key Data: - Revenue: The primary focus of the report - Sales Rep Tracking: This includes new business, contract renewals, and lost business Re...The primary focus of the report - Sales Rep Tracking: This includes new business, contract renewals, and lost business Required Functionalities: - Automated Calculations: To reduce manual input and errors - Data Visualization: Charts and graphs to provide visual insights into the data - Summary Sheet: A separate sheet that auto-populates with a summary of all data Ideal Skills: - Proficiency in Excel or Google Sheets - Experience with sales reporting - Skills in data visualization and analytics I plan to update this spreadsheet on a mont...
...Detection: Automatically detect events such as goals, passes, shots, etc. Implement logic to analyze possession time and calculate xG. 3) Output Data: Generate reports with average player positions, event summaries, and possession breakdowns. Include visual overlays on the video showing tracked objects and detected events. 4) Video Processing Pipeline: Efficiently process full match footage (90+ minutes). Ensure compatibility with common video formats. 5) Code Documentation: Provide clean, modular, and well-documented code for future updates or enhancements. I want to be able to upload footage captured by a Veo camera for example, and use this to generate stats for analysis. Please attach your estimated timeline and cost for the project. Any suggestions or improvements...
I run an e-commerce store and I'm looking for an expert to help boost my sales and generate leads. Currently, I'm primarily leveraging social media for this, particularly Instagram and Tik Tok. Skills and Experience: - Proven track record in e-commerce sales - Proficient in Instagram and Tik Tok marketing - Experience in lead generation - Creative and innovative approach to social media Your task will be to devise and implement a strategy that effectively increases my store's visibility, attracts potential customers, and ultimately drives sales.
I'm in need of an Administration Assistant with excellent document formatting skills. The primary task will be formatting policy documents to ensure they are consistent, aligned, and visually appealing. Key Requirements: - Proven experience with Microsoft Word and Excel. - Ability to work quickly without sacrificing quality. - Previous experience formatting policy documents is a plus. - Must provide government-issued photo ID and sign a Non-Disclosure Agreement (NDA). - Long-term work opportunity available for the right candidate. - No pay for work that is of poor quality Important Aspects of Formatting: - Consistent font styles and sizes - Use of headers and footers - Optimal spacing and alignment - Creation of 'beautiful' documents Aesthetic Elements Considered ...
I'm looking for a skilled digital marketer to create a compelling Meta (Facebook/Instagram) ad for me. The ad will promote a free PDF filled with step-by-step instructions on starting a catering business. Key goals of the ad: - Primarily, it should generate leads. I want to build a list of potential entrepreneurs interested in catering. - The ad should resonate with individuals aspiring to kick off a catering business. Ideal freelancer should have: - Experience with lead generation through social media. - Proven track record of crafting engaging ads targeted at specific audiences. - Skills in understanding and dissecting content for marketing purposes. Final files must be delivered in size and resolution that works best for Meta ads. The ad must be compliant with...
- The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of us
...should be designed to collect customer details, track sales transactions, and generate daily summaries. Key Requirements: - The form needs to be accessible offline at certain times. - It should accommodate various data inputs, including text fields, dropdown selections, numeric fields, and Yes/No choices. - Upon completion of the form, an email receipt should be automatically generated for each transaction. - The form should have the capability to produce daily summaries as well as summaries for specific sales events (avant summaries). Ideal Skills: - Proficient in Excel - Experience in creating forms for sales tracking - Knowledge of offline data collection methods - Skills in automating email receipts from Excel - Capable of designing a system for daily and eve...
...SketchUp model and the DWG file. -Update the SketchUp model according to the specified changes and ensure accuracy. -Once the model is updated, generate renders from the front, back, lateral, and perspective views.(LUMION) -Import these renders into AutoCAD and scale them to the correct dimensions. -Incorporate general and detailed measurements onto the AutoCAD file as indicated in the marked PDF. -Review the footing detail and make necessary adjustments as marked in the PDF. -Organize and deliver the final output in 5 separate folders: Folder 1: Contains the updated DWG file of the specifications. Folder 2: Contains a CAD block of the model in top view. Folder 3: Contains images (renders) Folder 4: Contains two PDFs Folder 5: Contains the updated Sket...
...tools such as SmartScout and Keepa (training provided if needed). Enter brand and product data into a basic spreadsheet with accuracy and consistency. Follow clear guidelines to meet weekly and monthly sourcing targets. Requirements: Familiarity with SmartScout and Keepa is a plus but not required; training will be provided. Strong attention to detail and accuracy in data entry. Basic knowledge of Excel or Google Sheets. Ability to work independently and meet deadlines. A positive attitude and willingness to learn new skills. What We Offer: Flexible working hours. Competitive pay structure. Weekly and monthly performance bonuses for meeting targets. Hands-on training and support to ensure your success. A straightforward workflow with no direct communication with suppliers or br...
