Vba combine data columnงาน

Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100

1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง

...style and incorporate a combination of feathers and scales. It should be walking on two legs with large spinosaurus-like arms and a small sail on its back. With mostly scales, light fur on its back and slight feathers. Yellow eagle-like eyes. Dark greenish skin. Sharp claws. Slight horns on its head. Also curved quills sticking out from the back of it neck. Specifications: - The creature should combine features of the following… African wild dog Polar bear and Kodiak bear Hippopotamus Golden Eagle Velociraptor (Jurassic Park III specimen) Tyrannosaurus (Sue specimen) Spinosaurus (Jurassic Park III specimen) Utahraptor Saltwater crocodile Chimpanzee Collared Lizard Allosaurus Carnotaurus Tabby cat Shrew - A realistic interpretation of this hybrid dinos...

...enclose the dry kitchen from the wet kitchen and stairs, keeping the spaces flexible and easily adjustable. 3. Wet Kitchen Design • Propose a New Design: • Reimagine the wet kitchen with a focus on efficient use of space while maintaining a sleek and modern aesthetic. • Include ample storage, modern appliances, and easy-to-clean surfaces for a practical yet stylish cooking environment. 4. Column Designation • Important Columns: • columns are mark in red for easy identification. Other columns, walls can be redesigned. Please use current doors, sliding doors and windows unless absolutely necceseary to relocate or replace them. • Incorporate these columns into the design creatively, perhaps by turning them into design features (e.g., with custom...

I'm seeking an experienced React JS developer to create a waterfall chart that pulls data from an API endpoint. Key Requirements: - Custom column widths - Unique headers for each column - Text displayed above each column and inside Ideal skills for this project include proficiency in React JS, experience with data visualization, and a strong understanding of interactive web elements. The ability to interpret and implement API data and create a user-friendly, visually appealing chart is crucial. Please provide examples of previous similar projects in your bid.

I'm looking for a BOLD, modern and sleek logo for my clothing brand, "Eternal_Us". The design should intricately combine two elements: 1. An initials icon featuring the letters "EUS" uniquely intertwined with each other. 2. A globe with criss-crossing Saturn rings passing through it. The initials 'EUS' should be emphasized boldly within the globe or the rings. The final file needs to be an Adobe Illustrator vector file. Ideal candidates for this project should have: - A strong portfolio of modern and sleek designs. - Experience in creating clothing brand logos. - Proficiency in Adobe Illustrator. Please ensure your bid reflects your ability to deliver a high-quality, unique design that meets these requirements.

...and contractors, and support client management. Work independently on tasks such as document creation and organization using G-Suite, Microsoft Office (Word, Excel, PowerPoint). Organization and Reliability: Stay organized, meet deadlines, and provide dependable support with minimal supervision. Additional Expertise (Preferred but not required): Experience with SuiteDash, advanced Excel (e.g., VBA, financial modeling), QuickBooks, Etsy, web design, and graphic design is a plus. Requirements: Language Skills: Excellent verbal and written communication in English. Proficiency in additional languages (e.g., Spanish) is a plus. Tech Skills: Proficient in G-Suite, Microsoft Office, Canva, and social media platforms. Reliable internet connection for seamless communication and ...

About the business - Lilac Massage Therapy is a sanctuary for relaxation and healing, offering a holistic approach to well-being. We specialize in a variety of massage therapies and energetic treatmen...well-being. We specialize in a variety of massage therapies and energetic treatments that cater to the mind, body, and spirit. Our mission is to create a tranquil environment where clients can rejuvenate and restore balance. Logo Design Goals - Reflect the brand's essence of relaxation and healing. - Incorporate lilac imagery or color tones to connect with the name and evoke a sense of calm. - Combine modern sophistication with a natural, holistic feel to represent our therapeutic offerings. - Create a design that feels inviting, professional, and memorable for both new and ret...

...transformative power. Consider faith-based imagery like a dove, light breaking through clouds, or a glowing path. Include a sense of calm and renewal, such as a serene landscape or abstract elements evoking breath and peace. Color Palette Soft blues, golds, or gentle whites to represent peace, spirituality, and divine connection. Typography Modern yet elegant fonts for the title and tagline. Combine bold serif or sans-serif fonts for the title with clean, minimal fonts for the tagline. Back Cover (Optional) Space for a note or testimonial, such as: “In just two minutes a day, this habit can transform your life forever. Start your journey now!” Include room for a QR code to promote the Bible Launch app. What We’re Looking For A cover that grabs attention onlin...

...to create a web scraping program compatible with a MAC M2 processor. The specifics of the data to be scraped, the target websites, and the ultimate use of the data are currently undetermined. Therefore, flexibility and adaptability will be key to this project. Project: Setting in the program where it is possible to store and change login information Website Spamzilla Login information and password Website Ubersuggest Login information and password When clicking on ”start to extract from Spamzilla” button following will happen Login to a Spamzilla Extract predefine filters and make them choicble in the program as a dropdown list When chosen a predefined filter the program began to extract data from the website and import it to Mac program numbers...

Looking for an agency or team for our project. We're seeking an experienced AI/VR artist and developer to collaborate on cutting-edge art projects that combine artificial intelligence, virtual reality, and creativity. The ideal candidate will have expertise in AI-powered art tools, VR art studios, and innovative art experiences. Responsibilities: 1. Create AI-generated artwork using tools like DALL·E or DeepDream. 2. Develop immersive VR art experiences using tools like Tilt Brush or Gravity Sketch. 3. Design and implement interactive art installations that combine AI and VR. 4. Collaborate with artists and designers to create innovative art projects. 5. Experiment with new AI and VR technologies to push the boundaries of art and creativity. Requir...

I need a skilled WordPress developer to create a bespoke WordPress theme for my blog. The layout should be a simple single column style. Key requirements: - Proficiency in WordPress theme development - Strong understanding of single column layouts - Experience in creating user-friendly, visually appealing themes Max 6-8 Pages , Will share the reference site upon request. Please note, I didn't specify certain features such as a subscription form, comment section or social media sharing. However, if you have suggestions for essential blog features that could enhance user engagement, I'd be open to hearing them.

I am currently working on a research project focused on developing a Predictive Modeling-Based Non-Invasive System for Myeloproliferative Neoplasms Detection via Peripheral Blood Sampling. I have a CSV dataset containing 412 samples of healthy individuals and MPN patients, including gene expression data, sex, and age. I am seeking your expertise to assist with the following tasks: 1. Organizing and Harmonizing the Data: - Ensure all gene identifiers under the ID_ref column, such as (1007_s_at) and (TC04002953.hg.1), are consistent and harmonized across the dataset, and document each gene’s actual meaning before harmonizing them, I need to know what each new gene identifier reference to. - Properly label and organize the dataset to distinguish healthy samp...

...cutting-edge nature of the EdTech industry. - **Simplicity:** Create a clean and minimalist design for easy recognition. - **Versatility:** Ensure adaptability across various platforms (web, mobile, print). - **Memorability:** Make the logo stand out and leave a lasting impression. --- ### **2. Updated Tagline Focus** - **"Tech-Driven Education"** highlights the brand's mission to combine technology with learning. The tagline will align with the core design elements to emphasize innovation and progress. --- ### **3. Color Palette** - **Primary Colors:** - **Blue (#1E90FF):** Symbolizes trust, technology, and professionalism. - **Orange (#FFA500):** Represents energy, creativity, and accessibility. - **Secondary Colors:** - **Dark Gr...

...desktop management to manage our maintenance logbook. The database will be a spreadsheet in a shared OneDrive folder. Key Features: - Automatically assigned Job Numbers and Dates. - Staff inputting data such as issue descriptions, locations (from a dropdown list), their names (from a dropdown list), estimated and actual completion dates (using a date picker), maintainer's names (from a dropdown list), and notes (in a text box). - A checkbox for staff confirming job completion. Ideal skills for this project include: - Mobile application development, specifically for Android - excel development in VBA - Experience with creating user-friendly interfaces - Familiarity with integrating applications with OneDrive - Knowledge in using dropdown lists, date pickers and chec...

...cannibalization at any cost. You can use Ubersuggest, Ahrefs or Semrush Keyword Magic. We will require a detailed colour spreadhseet containing the search terms and data in easy to understand format, each column should list the keyword, searches per month, cost per click. Please bid reasonably and in your bid tell us the list of tools you will utilize. We also need the time required. If you have read this and are willing to do the trial research, please mention "keywordsend" in your bid. In your bid, please provide the exact budget for 10 niches - 3000 keywords per niche Please note that your files need to be absolutely presentable with data from various sources (sources clearly mentioned) that can be cross-verified. We have a project for upto 300 we...

I'm seeking a talented audio engineer/musician to create a mashup of two songs for a wedding first dance. Key Requirements: - Combine songs into what almost sounds like a duet between the two songs. Going out of one song into the other. - Final product should be within a 3 to 5 minute length Ideal Skills: - Proficiency in audio editing software - Strong understanding of music theory and song structure - Experience with creating song mashups - Ability to deliver high-quality audio suitable for professional use

I'm looking for a skilled Photoshop expert who can combine several personal photos into one. The final image will be a gift or keepsake, so it needs to look professional and heartfelt. The main task will involve adding someone to a specific photo. I would like to have the sword removed from his hand if possible. Ideal Skills and Experience: - Proficient in Adobe Photoshop - Experience in photo manipulation and editing - Able to create a visually appealing final product - Understanding of creating emotionally resonant images.

I'm seeking an experienced professional to create a compelling pitch deck for my digital media business. The primary goal of this deck is to attract potential sponsors of an online social column that I hope to publish from my coverage of local events in my community. It will have elements of a traditional society column but will also highlight important causes. I hope to attracted multi-tiered sponsorship from local businesses, mostly geared toward higher-income earners. I have attached a draft business plan but am still trying to figure out what I'm seeking, in terms of sponsorship. I'm thinking in the neighbourhood of $60-$80K. Key Requirements: - Deep understanding of the digital media landscape - Proven experience in creating investor pitch decks - Strong...

I need a professional designer to combine two images and create a modern-style cover for my fiction book. The cover should be suitable for soft cover publication and optimized for Amazon KDP. Key Requirements: - Combine two provided images seamlessly. - Design a modern, visually appealing cover. - Incorporate the book title into the cover design. Ideal Skills and Experience: - Previous experience designing book covers, especially for KDP. - Strong graphic design skills. - Excellent understanding of modern design aesthetics. - Ability to create visually appealing and professional designs. Deliver it as a pdf so I can test it.

I'm looking for a freelancer with experience in Leadpages and web design to revamp our thank you page into a fun and vibrant style. The page needs to accommodate an embedded Product Demo video, and showcase three purchasing options in a side by side column layout. Key requirements: - Proficient in Leadpages - Web design experience - Creative with a knack for fun and vibrant designs Please provide examples of similar projects you've completed.

...skilled Python developer with experience in Raspberry Pi, I2C communication, and MLX90640 thermal camera modules. This project involves developing a Python library to enable the continuous and parallel operation of four thermal cameras, capturing data at a minimum frequency of 8Hz per camera, without the use of a multiplexer. Key Requirements: 1. Python Library Development: - Create a custom Python library for MLX90640 thermal camera modules. - Enable continuous data capture for all pixels (24x32 resolution) for four cameras, saving the data into CSV files. 2. Communication Setup: - Establish custom I2C buses for each camera using predefined Raspberry Pi pins (rearrangements possible but limited). - If a more optimal way of communicating wit...

...brokers. The platform will combine the best features of and while introducing new, superior functionalities. Our goal is to build an informative, interactive, and trustworthy platform for the global trading community. --- II. Project Objectives 1. Provide Comprehensive Information: Offer in-depth reviews of forex brokers, including regulation, reputation, and services. 2. Facilitate Trader Decisions: Help traders choose suitable brokers through feature comparisons and user reviews. 3. Build Trust: Emphasize transparency with accurate and up-to-date data. --- III. Expected Features The website will combine features from and along with innovative new capabilities: 1. Detailed Broker Profiles: - Regulatory data (licenses, regulatory authorities

I'm looking for a skilled video editor who can transform our 2023 summer vacation footage into a vibrant, emotional, and family-friendly 4-6 minute video. Key Responsibilities: - Organize video clips and photos from our travels to Albufeira, Oeste, and Sintra. - Select and incorporate 2-3 upbeat, family-friendly songs. - Combine clips and photos with fast cuts and dynamic transitions. - Use effects like slow-motion and color grading to enhance the visuals. - Add text labels for locations (e.g., "Albufeira - Algarve Coast"). - Focus on candid moments and natural family interactions. - Synchronize transitions and clips to the music’s rhythm. Final Deliverables: - A joyful 4-6 minute video highlighting the best moments of our summer vacation. - Rendered in 4K res...

I have a simple CSS modification task that should only take around an hour. I need a freelancer who can help me adjust the layout and positioning of the main content on my site. Specific tasks will include: - Adjusting column sizes - Repositioning elements Ideal candidates will have: - Proficiency in CSS - Experience with layout and positioning modifications - Ability to work efficiently to meet the 1-hour time frame

I'm looking for a professional who can create a detailed 3D architecture model of a residential building in Revit. The project involves: - Adding Rebars in slab, one beam and one column - Incorporating various detailing, objects and features such as a parapet, boundary wall, lawn, roads, and furniture The ideal candidate should have a strong background in architecture and engineering, with extensive experience in using Revit and Navisworks. You will need to perform a professional 4D simulation in Navisworks. Additionally, I would need you to provide: - Rendered Images - A walkthrough/flythrough animation that includes enough detailing such as furniture and other necessary objects for the project. Your bid will be assessed on your portfolio showcasing similar past projects...

I need a skilled photo editor to combine 2-3 individual photos into one cohesive family photo. The purpose of this project is to create a unique family gift. Need a photo of all four of us, it may be easiest to impose groom into image 2197. Your bid should be on project completion. Lighting is within one hour in same location for all photos. Key Requirements: - Proficient in Adobe Photoshop - Able to seamlessly blend individual photos into one - Capable of maintaining consistent lighting and color balance across photos The individual photos should be combined using the existing background. Your creative touch and technical skills will be crucial in making this family photo look as natural and beautiful as possible.

...very simple always a "register" button that will ask name, tel#, eMail ; location, location will be a drop down filled from the database, appt number. This page will have 2 buttons one contact us e one create a budget. The main page of the site will contain location (a drop down filled by the database) and appt number. From the appt number the column will be calculated for example appt 3309 is column 9 of location 1. The combination of location plus column is the key for tyhe main table db info A next button, if the appt number is viable (a table will contain all the viable appt numbers for each location) the next page will open. In the next page will be displayed an image (the plans of the appt that is stored in the main db table that is accessed by the...

I am on the lookout for a dedicated sales executive with expertise in the ceramic tile industry to help boost our presence in Malaysia. Your primary focus will be on engaging wholesale distributors. Key Responsibilities: - Lead Generation: Identifying potential wholesale distributors and cultivating rela...Client Follow-ups: Ensuring consistent communication with distributors to maintain strong relationships. Essential Skills: - Negotiation Skills: Ability to negotiate favorable terms and conditions. - Relationship Building: Proven track record of establishing and maintaining professional relationships. - Market Knowledge: In-depth understanding of the Malaysian ceramic tile market. Your ability to combine these skills will be pivotal for this role. I look forward to seeing your ...

Hi there - I'll deliver the file as we've discussed by VBA in Excel. Thanks for your trust!

We are a ex...Competitive Compensation: We value expertise and are open to flexible negotiations. • Long-Term Partnership: Join us in building a future-proof platform with global impact. Why Work With Us? • Collaborate on a platform with strong foundations and a clear market presence. • Be part of an exciting growth journey with opportunities to shape the future of our business. • Work on projects that combine innovation, practicality, and scalability. Submit Your Proposal If you are a visionary developer, market expert, or business strategist ready to take on a challenge and bring fresh ideas to a thriving platform, we’d love to hear from you. Share your insights, expertise, and vision to help us redefine the future of package delivery a...

...for trading operations Fetch stock quotes, manage positions, and refresh daily instrument data 5. Webhooks & Real-Time Updates Real-time data access through WebSocket Notifications for orders and trades via webhooks Tools and Technologies: Frontend: Flutter (cross-platform development) Backend: Node.js Database: PostgreSQL Real-Time Data: WebSocket API --- Phase 2: Automated Investment Strategies Development Objective: Automate investment strategies for real-time stock trading and backtesting using APIs, including buy low/sell high, swing trading, and more, with full automation for execution. Strategies to Implement in Phase 2: 1. Buy Low Sell High Strategy Use historical data & indicators like RSI and Bollinger Bands 2. Shar...

I'm looking for a skilled video editor/software developer who can generate a single MP4 video from two input videos. The final product should have a 9:16 aspect ratio, with the first video positioned on the top half and the second video on the bottom half. Key Requirements: - Create a generator that is able to combine any 2 videos - The top video should be closed captioned with text derived from its audio. - The captions should use customizable fonts similar to those trending on social media platforms. Ideal Skills and Experience: - Able to create a software algorithm - Proficient in video editing software and MP4 format. - Experience with creating closed captions. - Ability to replicate trending social media fonts Please see my PDF attachment for details

I'm seeking a developer experienced with the QuickBooks Online API to assist in generating order status reports. The primary purpose of this proje...delays in fulfillment The ideal freelancer for this project will have a strong background in working with APIs, particularly the QuickBooks Online API, and will be able to deliver a solution that will save me time and help me manage my orders more effectively. One File show the orderplan today in excel we like to list all order Estimate and then show the green where is the order in trello. every column with green is a list in trello. we need set up trello connection and what list we should list up in orderplan. We have building a system and doing the connection to trello and QB. we need someone take over and finish the orderplan...

Only give commission to referral for every order made by customer. Work with ftp only. Immediately. NO CHANGES IN DATABASE. ALL COLUMN ALREADY CREATED

I'm looking for a skilled video editor/software developer who can generate a single MP4 video from two input videos. The final product should have a 9:16 aspect ratio, with the first video positioned on the top half and the second video on the bottom half. Key Requirements: - Create a generator that is able to combine any 2 videos - The top video should be closed captioned with text derived from its audio. - The captions should use customizable fonts similar to those trending on social media platforms. Ideal Skills and Experience: - Able to create a software algorithm - Proficient in video editing software and MP4 format. - Experience with creating closed captions. - Ability to replicate trending social media fonts Please see my PDF attachment for details

I need an ETABS model to calculate the loads on a basic structure. The design of the primary structure columns will be provided by me. Your task will be to input all relevant details into the ETABS model as per our structure's columns and beams. Key Responsibilities: - Use the provided basic structure column designs to enter into the ETABS model - Calculate load using the ETABS model - Produce a load report in a Word Document The model should take into account: - Dead loads - Live loads Ideal candidates for this project should have: - Proficiency in using ETABS - Experience with structural analysis and load calculation - Ability to produce clear and concise reports in Word Document format Please note that the ETABS model is primarily intended for load calculation.

I'm looking for a modern-style logo that incorporates both text and an icon. The logo should primarily convey a sense of professionalism, as it represents my proprietorship company. - Style: The logo should be modern, so clean lines, minimalism, and a contemporary aesthetic are key. - Elements: The design should cleverly combine text and an icon. The icon should be relevant and complementary to the text. - Message: Above all, the logo should project professionalism. It should be suitable for a business setting and convey a sense of trustworthiness and competence. Ideal skills and experience for this job include graphic design, branding, and a strong portfolio of modern logo designs. Good communication skills are also essential, as I will be providing inputs throughout the de...

I need a skilled photo editor to combine elements from two pictures. The final composite image will be used for personal purposes. Key Requirements: - Remove a person from one picture and add them to another. - Ensure the person blends seamlessly into the existing background. - Perform color correction to ensure all elements in the final image match. Ideal Skills: - Proficient in photo editing software (e.g., Adobe Photoshop). - Strong understanding of color theory and photo composition. - Experience with creating composite images. Please provide examples of similar work in your bid.

I'm in the process of launching a new enterprise - SNARF, a unique app tailored for pet owners. SNARF delivers customized weekly feeding menus for dogs and cats based on the pet's specifics like age, activity level, breed and so forth. The meals consist of fresh ingredients that pet owners combine to create nutritious meals. Our mission is clear: to simplify the process of providing tailored, fresh food recipes that promote the health of companion animals. I need a logo that encapsulates this mission and reflects the brand identity of SNARF. I've attached a color palette for the brand that should be taken into account. The logo should communicate the essence of our brand - easy, healthy, and tailored pet nutrition. In your application, please include your past work ...

...necessary code to dynamically compile XML files containing database data and posting them via a Webservice. This will involve creating two small modal popups with dropdown selections for the user to choose a recipient address. Successful transactions should be logged in a database table while keeping the user on the same page. 2) Setting up an SFTP listener or cron job to search for ZIP files on an SFTP server. This task includes unzipping the files, parsing an XML file, and saving selected data into database tables. Any PDF files found should be stored in corresponding S3 buckets. The contents of the SFTP server should be deleted after each successful sweep and database update. All steps, file formats, database tables, and column names are clearly outlined in an...

I need a skilled photo editor to combine 2-3 individual photos into one cohesive family photo. The purpose of this project is to create a unique family gift. Need a photo of all four of us, it may be easiest to impose groom into image 2197? Key Requirements: - Proficient in Adobe Photoshop - Able to seamlessly blend individual photos into one - Capable of maintaining consistent lighting and color balance across photos The individual photos should be combined using the existing background. Your creative touch and technical skills will be crucial in making this family photo look as natural and beautiful as possible.

2023 summer vacation, we captured many wonderful moments with the kids through videos and photos. Now, we want to relive these memories in a cool, vibrant, and emotional video that will let us revisit the joy of this summer over and over again. Your Mission, Should You Choose to Accept It We’re looking for a talented video editor to: • Create a compelling narrative with a happy, fresh vibe. • Combine video clips and photos seamlessly with transitions, rhythm, and creativity. • Include 2–3 commercial songs (see examples in the shared folder below) to guide the flow and energy of the video. Feel free to explore upbeat, family-friendly tracks from artists like Bruno Mars, Coldplay, and others. • Optionally, add cool and original stock footage to en...

I am in need of a highly skilled professional for an urgent task involving the merging of two faces. The main purpose of this project is to seamlessly combine two faces without compromising the quality or integrity of the final image. Ideal candidates should possess: - Extensive experience in facial editing and merging - Proficiency in using advanced photo editing software - A keen eye for detail and aesthetics Please refrain from contacting me if you do not meet these qualifications.

...demonstrating high-quality motion graphics work - Experience creating social media content, particularly Instagram Reels - Excellence in typography animation and text overlays - Ability to create professional, contemporary designs - Understanding of social media engagement strategies Project Scope: - Development of multiple customizable template files for Instagram Reels - Templates will combine stock footage with animated text and graphic overlays - Creation of engagement-focused templates (e.g., competitions, promotional content) - All source files must be provided and organized for easy future modifications - Initial project will focus on promotional template design with potential for ongoing work Deliverables: - Editable project files (After Effe...

I'm seeking assistance to update an Excel she...specified date. If an employee worked multiple shifts on the same date, a new column should be added to record the additional shift. If the employee code from the notes is not found in the Excel sheet, a new row must be created to include the employee code, name, and the shift details for the specified date. Key details: - The handwritten notes are in photographs - The employee codes and names are consistent between the notes and the Excel sheet - The dates are formatted as DD/MM/YYYY in both the notes and the Excel sheet Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Attention to detail to ensure accurate updates - Ability to create new rows and columns as needed - Experience with data entry ...

...the mobile footer ( identify the specific CSS classes used for footer text in the mobile view & update the color properly in the CSS. 3) Add a fourth column to footer ( mobile & web based sites) . Need to update footer layout to include four columns: MVP BOXING, HELP, LEGAL, INITIATIVES …will need to modify the HTML, structure to add the 4th column. 4) Ensuring the ‘Even Spacing’ of columns in mobile footer. REVISION NUMBER TWO: Display five boxing & mma training videos in a single column . Will need to adjust the homepage with HTML structure to arrange the videos horizontally & need to update the CSS to format the videos in one column….for example, 2) Will need to replace five training pictures with embedded...

I'm looking for a modern-style logo that incorporates both text and an icon. The color scheme should lean towards neutral and muted tones. Key Requirements: - Design a minimalist yet impactful modern logo - Combine both text and an icon in the design - Utilize a neutral and muted color palette The ideal freelancer for this project would have a strong background in modern design principles, a knack for minimalist aesthetics, and proven experience in corporate branding.

I'm in need of a bot that can take info from an Excel spreadsheet and cross-reference it with another spreadsheet to calculate job pricing. The bot needs to ...a bot that can take info from an Excel spreadsheet and cross-reference it with another spreadsheet to calculate job pricing. The bot needs to handle: - Mixed data: The spreadsheets will contain both numeric and text data. The bot should notify me by: - Directly updating a new spreadsheet with the calculated job pricing. The bot should perform the tasks: - On-demand: I should be able to trigger the calculations whenever needed. Ideal skills for the job include: - Proficiency in Excel and understanding of spreadsheet functions. - Experience in creating automation bots for Excel. - Programming skills, prefer...

...for time-series data. The task involves complex calculations to eliminate the need for Python loops, ensuring the solution is efficient and fast. --- ### DataFrame Details: The DataFrame contains the following columns: - `used_res` (Resource Used) - `res_cap` (Resource Capacity) - `qty` (Quantity) --- ### Algorithm Requirements: 1. **Step 1: Calculate Desired Quantity** - Compute the percentage: `percent_used = used_res / res_cap` - If `percent_used > target_value` (a static threshold variable), calculate `desired_qty` using the formula: ```python desired_qty = ceil(qty * (percent_used / target_value)) ``` - Store the result in a new column: `desired_qty`. 2. **Step 2: Update Quantities Based on Conditions** - Create another ...