Formulas/Macros for Google Sheets (Excel)

TECHNICAL TASK (TT)for the development of a premium landing page“Purified Drinking Water”1. General Information about the Project Website type: One-page premium landing page with high conversion and the possibility of expanding into a full-fledged website with a blog/knowledge base. Goal: Attract leads (consultation requests), build trust in the brand through emotional visuals, scientific facts, and demonstration of the company's values. Platform: The contractor offers the optimal platform (Webflow or WordPress + Bricks Builder) with justification in the commercial proposal. Preference is given to solutions that provide clean code, high speed, and premium visuals without template solutions.2. Target Audience Families (especially with children) who care about health and quality of life. People who value thoughtful kitchen solutions, quality purified water, and long-term home solutions. Individuals aged 30–55, middle and upper income, looking for a reliable partner for installing a water purification system with service.3. Visual Style and Design (UI/UX) Reference: A reference layout is attached (image of a phone with a hero section and a “Values” block). The style should fully match this layout: clean, bright, premium lifestyle with warm accents. Color scheme: White and light gray background (cleanliness), elements of natural wood or warm accents, sunny orange/yellow CTA buttons, deep blue/anthracite for text. Images: Exclusively premium lifestyle. Lively emotional people (not looking at the camera), soft morning sunlight, natural colors. No artificial stock photos. Typography: Modern, readable, with sufficient line spacing and white space. Professional level without overload.4. Structure of the Landing Page (6 main blocks)BLOCK 1. Main Screen (Hero) Visual: Large bright photo covering the entire screen — a modern kitchen, mom, dad, daughter, and son drinking clean water from glass cups, smiling, soft morning sun. Headline: “Your health starts with a sip of purified drinking water.” Subheadline: Water purification systems with lifetime service for your family every day. CTA button: “Get Expert Consultation” (orange/yellow, noticeable).BLOCK 2. Our Values and Philosophy (Founder's Address) Visual: Professional photo of the owner (smart casual, open and trustworthy appearance). Text (from reference): OUR MISSION Personal address: CTA: “I want to be healthy” (scroll to Block 3 or form).BLOCK 3. Educational Course (Scientific Approach) Headline: Learn more about the water you drink! Format: Stylish interactive grid with 10 clickable blocks/cards. Each card leads to a separate article/video page (recommended for SEO) or a modal window with full text/video. Note: Texts/videos of articles are provided by the Client. The contractor ensures a convenient structure and attractive display.BLOCK 4. Purified Drinking Water Changes the Taste of Life! (Emotional Evidence) 4 premium cards in a grid or collage: Health: A girl drinks purified water. Text: “Restore your health sip by sip.” Borscht / Dishes: Macro shot of borscht with steam. Text: “Experience the rich taste of your dishes with purified drinking water.” Coffee / Tea: A father brews coffee, a grandmother with a cup of tea. Text: “Unleash the true aroma of coffee and enjoy fragrant tea.” Household / Appliances: A daughter irons a shirt with clean steam. Text: “Keep your appliances for years: perfect steam without scale.”BLOCK 5. Comprehensive Solution (Product) Visual: Aesthetic montage of a 5-stage reverse osmosis system under the sink (clean look, no chaos of pipes) + stylish separate faucet on the countertop. Text: Benefits through the end result for the client (cleanliness, taste, care for health). Offer: “Turnkey system + Professional installation + Lifetime service.”BLOCK 6. Trust Block (Social Proof and Guarantees) Main trigger: Large accent banner: “If you do not like the quality of the water — return the system within 60 days (0% risk).” Elements: Carousel of reviews (videos or screenshots of real correspondence). Gallery of real works “Before / After” installation. Logos / mentions (if any).5. Functional and Technical RequirementsForms and Lead Generation Consultation form with fields: Name, Phone, City/Region, “What water do you have now?” (or a short question). Integration with Telegram bot or CRM (at the Client's choice).Analytics and Marketing Google Analytics 4 + event on form submission. Meta Pixel (Facebook/Instagram). Conversion settings.Speed and SEO PageSpeed Insights ≥ 90 on mobile and desktop. Clean semantic markup, optimized images, lazy loading.Mobile Version Mobile-first design. Perfect display on iPhone and Android (reference — layout on phone).CMS and Articles Convenient system for adding and editing course articles (collection/posts).6. Stages of Execution and Approval (4 stages) Prototype (UX draft): Black-and-white layout scheme of blocks and buttons. Check logic and accents. Design concept (UI): Color layout of the first 3 blocks with approved photos. Check style, fonts, button colors. Full design: Visualization of all 6 blocks. Final adjustments to graphics. Layout and launch: Ready website on the chosen platform. Check speed, responsiveness, form functionality, analytics.7. Requirements for the Contractor Experience in creating premium landing pages for health, eco, technology, or lifestyle brands (portfolio with links is mandatory). Experience with Webflow or Bricks Builder (mandatory). Willingness to work in stages with interim approvals.8. What is Needed in the Commercial Proposal Recommended platform with justification (Webflow / WP + Bricks). Fixed cost with breakdown by stages (or fixed + possible adjustments). Execution timelines by stages. 2–3 relevant examples from the portfolio (links + short description). Support conditions after launch (first 1–3 months). Contact person and readiness for a call/meeting to discuss.9. Additional Information All text content (except reference phrases) is provided by the Client. Photos and visuals: The contractor creates, integrates, and optimizes. Domain and hosting: The Client provides or the contractor assists with the connection. Copyright: After full payment, all rights to the website transfer to the Client.

Good afternoon. I need to adjust the website launch and possibly the layout on WordPress. The website displays upon launch as shown in the screenshot. The freelancer who worked on it has disappeared and did not complete the job. We need to check the correctness of the layout and finish it. Both on desktop and mobile versions. The design is in Figma, and the design that needs to be done is also in the screenshots; it seems to be mostly done, but the correct display on different screen sizes is not completed.

There is a page on our website (waiting list) - https://onchainradar.ai It is overloaded and lagging too much. We need to fix this, slightly adjust the animations and some elements on mobile. The site is in HTML and CSS. Please estimate the implementation time and cost. We need this done today or tomorrow at the latest. Thank you.

Assistance is needed in customizing a WIX design template to fit our brand. Preferably specialists with experience working with Wix.

Design a letter for sending to clients (an example is attached), I will provide the text and the top image. This is just an example from GPT, could you make it more interesting?