Как оставить ноли вначале цифрового значения в програме ексель (Excel)

Need to: Create a website – online store in Ukrainian (subsequently multilingual). The engine is not critical, the most important thing is that the admin panel is user-friendly.Consists of: - Main page- Catalog with categories, subcategories, and product cards (with the ability to add both categories and subcategories): - Blog- Text (purely informational) pages:“Who we are” or “ABOUT US”Payment and delivery, Exchange and returns, Privacy policy, Public offer, Warranty.Contacts+ Admin panel 2. Register hosting 3. Purchase and link a domain4. Install a favicon5. Register Google Analytics and add the website 6. Create and connect a Telegram chatbot for order notification. 7. SEO. It is necessary to provide fields for each category and product: HTML title, meta keywords, meta description, h1, SEO text. The design can be template-based.

We are looking for an experienced Full Stack developer or a small team to create an online tire store for the Norwegian company EasyTire. Important: the site will be fully developed in Norwegian (all texts will be provided, but they must be editable through the admin panel). What needs to be implemented Search for a car by license plate number. Automatic determination of the original tire and rim size. Ability to manually search by size if non-original wheels are installed. Display of suitable tires, rims, and wheel sets with current prices, stock, and delivery times. "Buy Now" and "Add to Cart" buttons. Calculation of the total order cost. Offer of installation and balancing services when purchasing tires. Online payment. Automatic creation of a paid order in Notion. Sending a notification about a new order in Telegram. A simple admin panel for managing prices, texts, photos, and SEO. Modern responsive design in the EasyTire corporate style. It is also necessary to develop a separate SEO page for services (installation, balancing, puncture repair, and seasonal wheel change) so that it can be promoted on Google for relevant search queries. Integration with the supplier We have a dealer account with NDI. We have already discovered the internal API requests of the site, through which the following can be obtained: car data by registration number; prices; availability; warehouse; delivery times. At the first stage, it is necessary to explore the existing internal APIs and determine the most reliable method of integration. If the use of internal APIs turns out to be impossible or unstable, an alternative solution should be proposed (for example, server automation or another technically justified option). In your response, please indicate experience in similar projects; proposed technology stack; how you envision the integration with NDI; estimated timelines; estimated cost; cost of further support. A complete technical specification will be provided to the selected contractor after preliminary project discussion.

It is necessary to develop an application or script that will automatically convert files from YML or JSON formats to XLS format, with subsequent generation of a link to the output XLS file for promotion. Requirements: Input data: A file in YML format (links will be provided) or A file in JSON format (links will be provided, JSON does not contain a category tree, but each product is in a separate array). Output data: A file in XLS format accessible via a direct link. The file must be updated automatically on a schedule, for example, daily. Functional requirements: The ability to specify the number of days for Availability on order for each input link. The application must operate reliably under resource-limited hosting conditions. An intuitive web interface for managing settings is desirable.

Refinement of the working landing page - configurator created in AI is required. Almost all visualizations and options have been created. We will provide the archive. Everything needs to work well, be displayed properly, and be adaptive for mobile and PC. A screenshot of the landing page is attached.

Description: I am looking for a specialist in end-to-end analytics. We have a business in transport branding, two websites on WordPress. Currently, advertising is running, there are applications, but we do not see which channel brings clients. This needs to be fixed. Our websites (please check before submitting a proposal): https://revoltbranding.com https://revolt.com.ua What we have: Two websites on WordPress (forms on Contact Form 7) CRM: KeyCRM Telephony: Binotel Advertising: Google Ads Application channels: calls, forms on the website, Telegram, Viber, OLX, email What needs to be done (final result):End-to-end analytics works on both websites, and each application goes into the CRM with the source from which the client came. Then one dashboard where the number of applications and their cost by each channel is visible. Specific tasks: Organize GA4 and Google Tag Manager on both websites (consolidate into one system, unified events) Set up call tracking in Binotel: number substitution depending on the channel (separate number for Google Ads, separate for organic), so that it is visible in the CRM where the call came from Set up the transfer of UTM tags from forms to KeyCRM (we will install the plugin for forms) Set up tracking of applications from Telegram and Viber Separate conversions in Google Ads so that real applications are counted, not clicks on buttons Gather a dashboard in Looker Studio: GA4 + Google Ads + application data Important: Experience specifically with KeyCRM is not mandatory, but you will need to understand it (documentation is available, integrations are built-in). Experience with GA4, GTM, call tracking, and setting up end-to-end analytics is mandatory It is preferable that all containers and codes are connected via GTM, rather than inserted directly into the website code We have a freelance front-end developer on our side who can be involved for code adjustments on the websites if needed Work format: one-time turnkey task. We will provide all access (websites, GA4, Google Ads, KeyCRM, Binotel). In your response, please write: Have you previously done end-to-end analytics with the connection of telephony + CRM Estimated time and cost A couple of examples of similar projects