Excel macros open internetงาน
I have two Excel files detailing my wine collection - one is from 2023 and the other is an update. I'm looking for someone to identify the differences between the two files. Specifically, I need to see: - Changes in item quantities - Any addition or deletion of items After the comparison, I would like the results to be compiled into a summary report. Additionally, if possible, a visual chart illustrating the differences would be appreciated. Ideal candidates should have extensive experience with Excel and data analysis. Familiarity with inventory management and wine collections would be a plus.
I'm seeking an experienced developer with a strong background in implementing user authentication, E-commerce with Stripe integration, and API integration with Appwrite. This project involves working with some design guidelines and branding material I have, so an eye for design would be beneficial. Key Res...with Stripe payments integration - Familiarity with Appwrite - Strong understanding of user authentication systems - Design sensibility and experience working with design guidelines - Excellent communication skills for remote collaboration Please share your portfolio or examples of your past work. This opportunity includes the potential for a full-time position. Candidates must have a reliable internet connection and a capable laptop to work efficiently in a remote envi...
I require an excel sheet that tracks and analyzes the changes in open interest data of the NIFTY index. This sheet should be able to provide insights into market sentiment based on this data. Key Requirements: - The excel sheet should continuously update the data every minute. - The sheet should be able to provide a text summary of inferences about market sentiment from the open interest data. Ideal Skills: - Proficiency in Excel with experience in financial data analysis. - Understanding of open interest and its implications on market sentiment. - Ability to create an automated Excel sheet that updates data every minute. Please note that I'm looking for a freelancer who can deliver a high-quality, reliable tool for tracking and int...
I need a excel sheet (some columns protected), as soon as date are entered in Sheet 1 on a specific column the entire row needs to more to tab2, same at tab 2 as soon as date entered the row needs to move automatically to tab 3, same to tab 4, 5, 6. (All the rows are protected, can not be deleted, they will only move between tabs as the project runs) - Production Job Tracking report I would like to do the project together with the freelancer on teams (within the next hour is possible) I assume the project will take maximum an hour
I'm looking for an Excel developer to create an inventory management system. While specifics on the functions of the system haven't been detailed yet, the system will need to track stock levels and generate reports. As such, the ideal freelancer for this project should have prior experience in developing similar systems on Excel. Skills and experience required: - Advanced knowledge of Excel - Prior experience in developing inventory management systems - Ability to generate and interpret detailed reports - Excellent understanding of tracking stock levels
I'm looking for a skilled professional to set up an open source business accounting application, , to help me transition off of Quicken/QuickBooks. Key Tasks: - Set up for my business needs - Input Charts of Accounts - Configure expense tracking and financial reporting features - Enable syncing with bank accounts - Set up split payments based on amortization schedules The ideal candidate should have experience with , and a strong background in accounting to ensure the application is set up correctly. They should also be able to provide assistance with the initial use of the software after setup.
...freelancer who can assist me with entering part numbers and costs from a supplier's website into an Excel spreadsheet. This spreadsheet contains makes and models for every vehicle listed in the UK. Key Responsibilities: - Accurately input part numbers and costs from a supplier's website into designated columns of an Excel spreadsheet. - Follow specific formatting and column header requirements as detailed below. Specific Columns and Formatting: - The data needs to be entered under specific column headers in a predefined order: makes, models, costs, part numbers. - Conditional formatting or color-coding will need to be applied at times according to supplied guidelines. Ideal Skills: - Familiarity with Excel and its data entry requirements. - Attention to...
I am looking for an SEO specialist with a proven track record of boosting online sales for e-commerce sites. My main goal is to increase sales through improved search engine rankings and increased organic traffic. Ideal Skills: - Deep understanding of e-commerce SEO strategies...increase sales through improved search engine rankings and increased organic traffic. Ideal Skills: - Deep understanding of e-commerce SEO strategies - Proven experience in increasing online sales through SEO - Proficiency in keyword research and on-page optimization - Knowledge of link-building techniques and off-page SEO - Technical SEO skills to ensure website is search-engine friendly I am open to suggestions on which specific aspects of SEO we should focus on, so your expertise in this area will be i...
I need a comprehensive dataset prepared for Tableau that encompasses a variety of data types including sales, customer, and financial information. The data is currently in Excel/CSV format. Key Requirements: - Transform and clean various data types (sales, customer, financial) from Excel/CSV for Tableau - Prepare the dataset to allow for a variety of analyses and insights, including but not limited to sales trends over time, customer demographics, and expense versus revenue tracking. Ideal Skills: - Proficiency in Excel/CSV data handling - Expertise in data preparation for Tableau - Strong analytical skills to understand and anticipate necessary data transformations for desired insights Please note that the final dataset should be versatile enough to facilitate a wi...
...interface. It must support full-duplex communication, meaning it should also be able to receive responses. Logic Explanation: Based on the attached specifications: 1. Logic 0 ("Space"): Current: Between 0 mA (Minimum) and 2 mA (Maximum). 2. Logic 1 ("Mark"): Current: Between 42.75 mA (Minimum) and 47.25 mA (Maximum). The current loop operates at a nominal 45 mA ±5%. The voltage for the open-loop supply must be between 12V DC (Minimum) and 42V DC (Maximum). Requirements: The designed circuit must handle current regulation for transmitting the appropriate logic levels (0 and 1). It should interface seamlessly with an ESP32's GPIO pins for sending and receiving signals. Protection against exceeding the voltage limit is essential. Ensu...
------------------------------------------------------------------- Project Update Thank you for your interest in my project! I have a few updates to the initial requirements: SaaS Model: The system is designed to operate as a SaaS platform, supporting multiple users with secure account separation and subscription-based access. Payment Gateway Integr...paid campaigns. Lead management system to collect and track leads from campaigns. Questions for Candidates What technologies would you recommend for this project, and why? How long do you estimate the development of the MVP will take? Do you have experience with similar projects or API integrations? Can you share examples of relevant past work? Budget The budget is flexible based on milestones. Open to hourly rates or fixed-price ag...
I'm looking for an Excel expert to design a template for tracking my total monthly/yearly sales. This template should also allow for comparison over time. Key Features: - Total sales tracking - Comprehensive data visualization features: Bar charts, Pie charts, Line graphs - User-friendly manual data input Ideal Skills: - Advanced Excel skills - Experience in data visualization - Knowledge in sales data tracking
...descriptions and visuals. E-Commerce Essentials: Setting up payment gateways, shipping options, and optimizing the checkout process. Mobile responsiveness: ensuring the store looks great and functions smoothly on all devices. SEO and Performance: Basic SEO setup and ensuring the store loads quickly. Advice on Shopify apps for marketing, analytics, or enhancing user experience. Budget: ₹600–₹1500 Timeline: Open to discussion, but I’d like to launch the store as soon as possible. If this sounds like a project you’d be excited to work on, please share: A link to your portfolio or examples of Shopify stores you’ve developed. Your approach to this project and how you’ll help bring my vision to life. Your estimated time for completion. I’m looking...
We are looking for an experienced developer to design and implement a Shopify payment application that allows merchants to accept REEF token payments on the Reef Chain. This application aims to deliver a smooth payment experience for customers while empowering merchants with compl...- Clear deployment instructions and maintenance documentation Proposal Instructions In your proposal, please include: 1. Your experience in Shopify app development 2. Previous projects involving cryptocurrency payment integration 3. Your strategy for developing extensible applications 4. Your approach to managing real-time payment verification 5. Your proposed timeline and availability We are open to establishing a long-term relationship with the right candidate as we continue to enhance the app's...
I am in need of a freelancer with expertise in data scraping and automation tools to help me streamline my real e...my existing spreadsheets. Key Responsibilities: - Automate the gathering of real estate property data from multiple websites into my current spreadsheets - Ensure the data collection process is accurate and efficient Ideal Skills: - Proficiency with data scraping and automation tools - Experience with real estate data is highly preferred - Ability to improve workflow through automation I am open to suggestions regarding websites, types of data to be gathered, as well as the automation tools or programming languages to be used. The primary goal is to enhance the efficiency of my data collection process. If you have a proven record in this area, I would love to hear...
I'm seeking a creative video editor to enhance my Tamil YouTube vlogs with humor and engaging meme clips. Key Responsibilities: - Edit my vlog videos with a comedic twist - Integrate suitable and trending internet meme clips from movies and shows - Make the content engaging and entertaining for viewers Ideal Candidate: - Experience in video editing, particularly for comedic content - Familiarity with Tamil culture and internet memes - Ability to meet deadlines and work on a long-term basis The project can start immediately and we can discuss terms for a long-term collaboration.
I'm experiencing significant internet lag while gaming on my PC, and I need a professional to analyze my PingPlotter data to identify the cause. The primary goal of this analysis is to pinpoint the source of the lag. Ideal Skills and Experience: - Proficient in network analysis and troubleshooting - Experience with PingPlotter - Understanding of online gaming network requirements - Ability to provide clear and actionable insights
I'm looking for a skilled web developer to create a WordPress website for my transportation business, hosted on Bluehost. The site should mirror the professional appeal and functionality of a comparable competitor's site. I am open to rate negotiations and prefer a flat-rate payment structure with no hidden costs. Key Requirements: - Extensive experience with WordPress and Bluehost - Ability to design a corporate/professional style website that embodies my business's transportation theme - Strong understanding of e-commerce and business website creation - Capacity for transparent and fair negotiations I look forward to working with a freelancer who values honesty and transparency as much as I do.
...kompetisi profesional. Game adalah aktivitas rekreasi yang melibatkan aturan, tujuan, dan interaksi, baik secara fisik maupun virtual. Game dapat dimainkan secara individu atau bersama orang lain, dengan tujuan utama untuk menghibur, mendidik, atau mengembangkan keterampilan. Jenis Game 1. *Game Online*: Game yang dimainkan melalui internet, seperti MMORPG (Massively Multiplayer Online Role-Playing Game). 2. *Game Offline*: Game yang dimainkan tanpa koneksi internet. 3. *Game Konsol*: Game yang dimainkan di konsol seperti PlayStation, Xbox, dan Nintendo. 4. *Game PC*: Game yang dimainkan di komputer pribadi. 5. *Game Mobile*: Game yang dimainkan di perangkat seluler. 6. *Game Edukasi*: Game yang dirancang untuk mendidik dan mengembangkan keterampilan. 7. *Game Strategi*:...
I'm in need of a reliable freelancer skilled in Excel and SQL database management. Key Responsibilities: - Regular data entry and updating in Excel. - Managing and maintaining a SQL database. Ideal Skills: - Proficiency in Excel for data entry and updating. - Experience with SQL database management. - Attention to detail for accurate data handling.
have a open ai python code that explicitly says statements in a search return and offers related topic suggestions, so basic functionality works great but needs to be improved. want to develop so if you search this bar () with the word Monetary Policy, the prompt that is expressed currently says Results presented for "1. **Monetary Policy**: The actions of central banks to control the money supply and interest rates in an economy." to the left. then it says Certainly! here are related topics that might interest you: and then these weir lists with gaps and ** and numbers, i want that to become more appealing/conversational ..... and be replaced with Ive presented results to the left on Monetary Policy which are <def>The actions of central
I am looking for a skilled web developer to create a financial website for me. The website should include the following features: - Budgeting tools - Investment calculators - Stock market news I am open to suggestions for the color scheme and design style of the website. However, I would prefer a clean and professional look. I need the project to be completed as soon as possible. Therefore, I am looking for a developer who can work efficiently and meet tight deadlines. Ideal skills and experience for this job include: - Proficiency in web development languages such as HTML, CSS, and JavaScript - Experience in designing and developing financial websites - Knowledge of budgeting tools and investment calculators - Familiarity with stock market news APIs If you meet these requirem...
...dependents. The app will have two user roles: employees and employers. Key Features: Employee Login: Enter Employee ID to access the app. Display Details: Show the employee's name and their dependents. Admission Form: Select the person to admit (employee or dependent). Input fields for hospital name and admission date. Submit Button: Sends the data to a backend. Employer Dashboard: Generate an Excel sheet with all admission records....
I'm currently facing difficulties deploying an open-source web app on my dedicated Linux server using Docker. This issue seems to stem from the server setup. I'm seeking a professional to assist me in troubleshooting and resolving this issue. Key Requirements: - Expertise in server setup, particularly for dedicated Linux servers - Proficiency in Docker configuration - Experience with deploying web apps from source code - Ability to collaborate and communicate effectively Please note that I am open to providing more details and collaborating as needed. Your role will primarily be to help me diagnose and fix the server setup issues that are preventing the successful deployment of the app.
...the possibility of supporting macOS in the future). Technical Requirements: - Programming Language: Preferably Python with a GUI framework (e.g., PyQt or Tkinter). - Database: SQLite or any lightweight local database. - File Storage: Files should be saved to local directories specified in the application settings. - Offline Functionality: All features must work locally without requiring an internet connection. Additional Notes: - Preference will be given to developers with previous experience in similar projects. - Please include a price quote along with the expected delivery timeline. - The application must follow a clear and modular architecture, with proper separation of concerns to facilitate future development. Inline code comments and a brief overview of the project st...
...want a clean, uncluttered design that embodies minimalist principles. - Monochrome Palette: The brand colours are strictly monochrome - black, white, and grey. - Timeless Design: Ensure that the design maintains a timeless quality and does not follow fleeting trends. Design Requirements: - Non-Typographic: The logo should not simply be the letter "A" or the word "Artixanz" in a basic font. We are open to typography logo's but they must be truly unique or combine typography with unique framing or design elements. - Versatile: The design should be suitable for various applications, including apparel like hoodies or hats, as it will represent a lifestyle brand. Think Hands. Think tools. Think Gallery. Think crafts. Think art. Think building. Think creating...
...Gestion des Réseaux Sociaux : - Créer, planifier et publier du contenu engageant sur Facebook et Instagram. - Interagir avec notre communauté, répondre aux commentaires et messages. - Analyser les performances des publications et ajuster la stratégie en conséquence. 2. Veille Internet : - Suivre les tendances et les discussions autour du bien-être. - Identifier les opportunités de collaboration et de partenariat. - Mettre à jour les Agendas de la profession (fichier fourni) 3. Gestion du Site Internet : - Mettre à jour les contenus du site pour refléter les événements à venir, les voyages et les publications. - Optimiser le site pour le réf&eacu...
Transform Excel Sheet Data to Charts and Stats using Power BI, we need interpretation for each chart.
I am seeking a highly experienced circuit design engineer with expertise in digital and analog electronics, proficient in using Eagle for PCB design. The ideal candidate will have a strong background in signal conditioning, low-noise circuit design, and power management for compact, low-po...power management for compact, low-power applications. Familiarity with integrating multiple sensors, including PPG, glucose, HRV, and electrolytes, into electronic systems is a significant advantage. The role requires exceptional problem-solving skills, attention to detail, and the ability to deliver efficient, production-ready designs, including schematics, PCB layouts, and prototypes. If you excel in creating innovative circuit solutions and thrive in challenging projects, I would love to hear...
Hi, Statistics is my favorite subject and will be glad to help. I have skills in Data Processing, Statistics, R Programming Language, SPSS, Tableau and Excel. Hire me for your methodology and data analysis chapters for your dissertation.
I'm looking for a freelancer who can create a AI platform which will create a list of all active companies in India by scouring the internet and then create and update database. Post which the platform will run analytics of all active companies in India. This includes Small and Medium Enterprises (SMEs), Large Corporations, and Startups across various sectors such as Technology, Manufacturing, Healthcare, Etc. Key Requirements: - The database should include, but not be limited to, the following details: * Revenue data * Industry classification * Company Titles * City * State * Website * Sector - The freelancer should have experience in data collection, creation, analytics, platforms and AI . Familiarity with Indian companies is a plus.
I'm seeking a proficient Excel Solver expert to help me analyze my inventory data. The tasks involve moving averages, Mean Absolute Deviation (MAD) calculations, and time series forecasting. Key Tasks: - Help with moving average calculations - Calculate MAD - Apply time series analysis for forecasting Ideal skills for this project include: - Advanced Excel skills, especially with Solver - Strong understanding of inventory data analysis - Proficiency in time series forecasting methods
I'm looking for a Shopify expert who ...improvements on my store, focusing primarily on the product page, cart page and the overall design/layout. Ideal Skills: - Proven experience with Shopify - Strong understanding of e-commerce design principles - Excellent UI/UX design skills - Ability to implement currency/country settings Product Page: While the specific aspects of the product page that need to be improved haven't been detailed, I am open to suggestions on how to enhance the layout and design to boost user experience and ultimately, sales. Cart Page: The cart page needs some design/layout changes. The goal is to make it more user-friendly and visually appealing. Experience with Shopify's design tools and a portfolio of successful Shopify store enhancements...
Dear SFYGMOS Team, I am excited to propose my services for creating a professional and impactful logo design for your company, SFYGMOS. As a dedicated logo designer, I specialize in crafting visual identities that effectively communicate a brand's vision, values, and uniqueness. My approach invol...creative concepts, refining selected ideas, and delivering a final design that reflects the innovative and professional nature of SFYGMOS. I am confident that the logo I create will serve as a strong foundation for your brand’s recognition and growth. Let’s work together to bring SFYGMOS’s vision to life with a logo that truly represents its essence. I look forward to collaborating with you and am open to discussing your specific needs further. Best regards, Mu...
...currently using an Excel template to visually represent all our projects in a Gantt chart. I need an expert to enhance this template for me by adding a sales target function. This function should calculate and sum up the revenue for each job based on the percentage of the job completed in each month. - Example: For a $100k job with 75% of the work days in January and 25% in February, the system should automatically allocate $75k to January and $25k to February, and sum up all the jobs for each month. The work days are automatically calculated by the existing template. The only adjustment needed is the division of revenue by month and the presentation of this in total. I have an example of the desired output, just built manually. Ideal skills and experience: - Proficiency in ...
Web Development Project: Custom Shirt Sales Website We are a team of IT professionals seeking a skilled web developer to build a robust, mobile-first eCommerce website for selling customisable shirts. The site should be modern, user-friendly, and optimised for performance and SEO. While we are open to using CMS platforms like WordPress or Shopify, the final decision will depend on your expertise and recommendations. Project Requirements Key Features: Custom Shirt Configurator: Allow users to customise shirts based on size, shape, material, and other options. Dynamic visual previews of the custom shirt. Seamless integration with the shopping cart and checkout process. E-Commerce Functionality: Display various shirt styles with clear, detailed descriptions. Support for multiple pay...
Task Completed: - Created a complete Virtual Private Cloud (VPC) using Terraform. - Configured Load Balancer (ALB/ELB) for high availability and traffic distribution. - Set up NAT Gateway (NAT IGW) for secure internet access within the VPC. - Deployed EC2 instances and ensured proper security group configuration. - Implemented SSL certificates via Certbot and linked to a custom domain. - Utilized Vault for secure storage and management of sensitive secrets. - Automated IAM user creation and permissions using Terraform for centralized management. - Configure EBS mounted volume with EC2
...and engagement through Google Ads and social media campaigns. Provide a detailed proposal outlining how the goals will be achieved and recommendations for continuous improvement. Payment Structure Google Ads & Social Media Campaigns: Budget to be discussed based on scope and performance expectations. Monthly Maintenance: $20-$40/month for ongoing SEO, reporting, and updates. Additional Updates: Open to additional charges for significant updates or new features as needed. My target audience primarily includes primary school children from diverse cultural backgrounds, such as Middle Eastern, European (e.g., Serbian, Russian), Asian (e.g., Chinese, Vietnamese), Indian, African, and Egyptian communities. I’ve observed that children from Caucasian Australian backgrounds tend...
...Visualization and Reporting: - Create interactive dashboards using tools like Power BI or Tableau. - Provide meaningful visualizations such as charts, graphs, and heatmaps for easy interpretation. - Prepare a detailed final report with actionable recommendations. Requirements: - Proficiency in Python, R, or other statistical programming languages. - Experience with tools like Excel, Power BI, or Tableau for visualization. - Strong understanding of statistical methods and data modeling. - Ability to communicate insights effectively. Project Timeline: Expected completion within 3 days from the project start date. If you have the required skills and can deliver high-quality results within the timeline, we’d love to hear from you. Please include e...
...les entreprises de la catégorie 3 - Fournir les informations suivantes pour le bénéficiaire majoritaire : - Nom complet - Genre - Adresse postale Rédiger : - 3 bullet points personnalisés sur le bénéficiaire majoritaire ou l’entreprise. - 2 paragraphes personnalisés (3 lignes maximum chacun) sur l’entreprise. Une structure de texte sera fournie pour guider la rédaction. Livrables attendus - Un excel complet classant chaque entreprise dans l’une des trois catégories, avec les informations spécifiques pour les entreprises de la catégorie 3. Les textes rédigés devront être en français et respecter le format demandé. Profil recherché : Comp...
...styled in accordance with a provided corporate identity image. The specific tasks involved are: - Modifying the Dealer Information Form: Some fields in the form are already grouped, while others need to be newly created. I would also like to have a red line added to indicate the grouped fields. - Updating the link behavior for the "Portals" sub-menu: I need all sub-menu links under "Portals" to open in a new window when clicked. - Creating a new "Portals" page: This page should match a provided design. I will provide the design for you to replicate. - Styling the website's menu: The menu should be made to look like an attached image which reflects our corporate identity. Ideal candidates for this project should have: - Strong Wordpress develop...
...must. - Detailed Access Logs: A system that provides comprehensive logs of user access will be necessary for security and monitoring purposes. Ideal Skills: - Proficiency in HomeAssistant and TTLock integration. - Experience in developing custom user management features. - Strong understanding of security systems and access control. - Ability to create detailed logging systems. Please note, I'm open to advice if you think there are other relevant features that could be beneficial. Your insights and expertise will be highly valued in this project. Currently the only supports keymaster integration I would need to either enhance to support the https://github
...I'm looking for an expert in Excel and astrology software integration. The primary task involves data import/export between the two platforms (excel and software). Please note, the data to be transferred/extracted encompasses specific fields from the astrolog software. Ideal Skills: - Proficiency in Excel and creating macros - Experience with software or with any astrology software that uses swiss ephemeris - Data management skills - programming skills to pull out data from () - be able to connect data from excel and the astrology software I will be placing dates and times into excel, and then I want to click a button and extract out info from software and paste it into the excel worksheet. The data I want
...Collection:** - Use tools like Lusha, , and any additional necessary platforms. - Identify target companies and their main subsidiaries across the specified regions. - Gather detailed contact information, including **personal emails and phone numbers** of CEOs, CFOs, and key decision-makers. 2. **Data Organization and Delivery:** - Structure the information in an Excel sheet or database, ensuring it includes company details, locations, and contact hierarchy. - Deliver contacts progressively for quality verification and catalog integration. 3. **Verification:** - Cross-check all collected data for accuracy, reliability, and completeness. **Requirements:** - Expertise in tools like Lusha, , and other B2B data platforms. - Strong skills
Hi there! I'm often working in Google Sheet and Microsoft Excel and need a formula or some random tips and advice on how to make my sheet better, make my formulas cleaner, or macros written. It's not a full time job, or even consistent work. I'm looking for something like a co-pilot, preferable on Slack that I message any time. There might be weeks or even months where I don't need the help, but I know there is someone to help on hand when needed.
I'm looking for an experienced Flutter developer to help me build an APK for an Android application. The project doesn't currently include e-commerce, social networking, or utility features, but I'm open to your suggestions and expertise on how to make the app engaging. Key Requirements: - Proficiency in Flutter is a must, along with a strong portfolio showcasing Android applications. - Prior experience with the APK build and release process. - Creative thinking to suggest and implement engaging app features. - Excellent communication skills for regular project updates and discussions. Please note that this project is in its early stages, and I have yet to finalize the specific functionalities, target audience, or a completion deadline. Your expertise and insights w...
I'm looking for a data-savvy professional to assist me with analyzing and processing some wine investment fund data. Key Responsibilities: - Data entry: You'll be entering data from Excel spreadsheets into other required formats or systems. - Financial Analysis: You'll need to interpret the data and provide insights into trends, valuations, and potential investment opportunities. - Investment Research: I need you to conduct thorough research on possible investment opportunities within the wine market. Skills and Experience: - Proficient with Excel and other data processing tools. - Strong understanding of basic finance and investment concepts. - Prior experience in analyzing financial data and conducting investment research is a plus. - A passion for wine or...
