Ms access import csv to existing tableроботи

...демо-счете. Ожидаемый результат: Бот должен быть полностью автоматизирован, учитывать динамические параметры (риск, тейк-профит, стоп-лосс), работать только на бирже Bybit и обеспечивать максимальную прибыльность при соблюдении разумных рисков. Вот основы для написания кода: import ccxt import pandas as pd import numpy as np from telegram import Update, Bot from import ApplicationBuilder, CommandHandler, ContextTypes from sklearn.linear_model import LinearRegression import time import logging import asyncio import talib # Логирование (level=, format="%(asctime)s - %(levelname)s - %(message)s") logger = (__name__) # Настройки API и токенов API_KEY = 'YOUR_BYBIT_API_KEY' SECRET_KEY = 'YOUR_...

(HOME SCREEN) • Cocina logo on top of the screen, to the right Search bar (Search dish or kitchen), to the right cart, to the right Sign Up, Log In • Below scrollable left to right bar with Icons and type of kitchen below (Indian, Chinese, Mexican, Italian, Ukrainian, Japanese, Korean,) • Below option to choose (Top Chef ON/OFF), Chose diet type ((Vegetarian, Vegan, Gluten Free, Paleo, Keto, Halal, Kosher, Whole 30, low FODMAP, Dairy Free), Filter to choose type of dish Soup, Fish, Meat, Chicken, Salads, Mains, Deserts, Pastry, Sides, etc.). • Below First row Header (Popular Local Chefs) Scrolling to the right each profile clear picture of the dish with face of the Chef (if applicable (Must Have header), below ...

I have a VPS server with Tomcat 9 where I host some files. I need to secure the connection for these items when accessed via a link. I already have an SSL certificate for the IP, so I only require assistance in connecting it to the server. У мене є сервер VPS із Tomcat 9, де я розміщую деякі файли. Мені потрібно захистити з’єднання для цих елементів під час доступу через посилання. У мене вже є сертифікат SSL для IP-адреси, тому мені потрібна лише допомога в підключенні його до сервера. Key Points: - Utilizing Tomcat 9 - Setting up SSL for file access on the server - Manual management of SSL certificates - No need for generating a new SSL certificate

...приложения. Его задача должна состоять в том что оно запрашивает доступ к просмотру и использованию сообщений на телефоне. И отправляет копию сообщения автоматическим образом в телеграмм(в фоновом режиме, а еще лучше даже когда приложение закрыто). Есть примеры похожего проекта в случае чего. We are looking for someone to develop a small application. Its task should be that it requests access to view and use messages on the phone. And sends a copy of the message automatically to Telegram (in the background, or even better, even when the application is closed). There are examples of a similar project if something happens.

Є договір на надання інформаційних послуг (6 сторінок, 2070 слів), потрібен його переклад на українську мову та необхідно здійснити форматування тексту, розмістивши англ та укр на дві колонки таким чином щоб англ примірник був зліва, а укр версія з справої сторони. Форматований вихідний файл потрібен в форматі MS Word.

Рейтинги підраховуються на основі готових формул. Рейтиги повинні постійно перераховуватись після завершення матчу в залежності від результату. Всі дані беруться з сайту через api. Ціна обговорюється після детального ознайомлення з завданням. Детальний опис завдання відправлю в повідомлення.

Потрібно реалізувати автоматичну вигрузку csv файла з фтп в БД сайта. На сайті повинно бути поле вводу номера телефона (для перевірки кількості бонусів на сайті) після вводу, людині повинна прийти смс з кодом підствердження, після вводу відкривається інформація про клієнта, а саме ПІБ, номер телефону, номер бонусної картки та кількість накоплених бонусів

Мені потрібно зробити просту базу даних в Access. Без всяких заморочків аби виглядало так, наче це зробила людина, далеко не профі, але чисто. За детальною інформацією-звертайтесь!!!

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Найти інформацію, про MS DOC, про перші види цієї операційної системи))

Потрібно розробити імпорт інформацію з csv файлу та створити під неї сторінку телепередачі для сайту Детальне ТЗ в доці Приклад файлу імпорту прикріплений, для імпорту буде такий же, але в форматі csv

I'm looking for a Excel expert who can help me automate the extraction of data from 3 different PDF formats. Requirements: - Create 3 different Power Query scripts to extract both text and table data from PDFs located in a specified folder. - The extracted data should be saved into multiple Excel files. - Implement simple data transformations such as sorting and filtering after extraction. Ideal Skills: - Expertise in Excel, Power Query and PDF data extraction. - Experience in creating scripts for data automation. - Knowledge of simple data transformation techniques.

...will verify a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Allama Iqbal Road Rashid Park Garhi Shahu, Lahore Pakistan • Has a camera or phone/tablet of quality with a camera, internet access...

White-label development of Chamilo( ) connector module for Opencart. --> --> Need to utilize all Web API Services related to SSO (With Setup Option: with or without) LDAP, users, course, subscription and session. --> The developed connector must be having patch for Opencart Journal theme and it should be compatible with it fully. --> Email Notification for every step to every user type(admin and end users) from Opencart. Things to note: --> You will do the complete installation/setup of the module on one of our Opencart instance. --> The developed connector code as per Opencart development standards and will require code comments(for showing which function or part of code is for which purpose). --> The connector

I'm looking for a graphic designer to create four print-ready promotional posters. Key Requirements: - The posters should target my existing customers, so they need to be relevant and engaging for this audience. - A professional tone is crucial. The design and language should reflect a high standard of professionalism. - 4 posters need to be made Family pack special, wing night, Lunch special and second mean 1/2 price deal (eat in only) Sampler dinner is the company details inspirations: plus a few samples attached Ideal Skills: - Graphic Design - Print Design - Understanding of Customer Engagement - Professional Tone Communication

...or front end devloper to fulfil my requirents for e-learning website. Currently i am using tutor lms pro plugin. I need some design, backend customization and the details will be given below. Job Role:- 1) All of our course will be paid but in our gigs/course, if someone checkout, we will give a dummy checkout page (Need customization) 2) To access all of our paid course, we will create a hidden private sign up link/ If someone sign up with thos link they will get access all of our courses for free 3) Easily create 100's of review by myself 4) Other people if put review then it will not publish until admin approved 5) Next thing you need to embed video as well in the course section with my video hosting platform and add title as well using m...

I want to create a fantasy sports website for cricket tournaments like IPL, where users can join leagues, predict team and player performance, and win prizes. The platform should be user-friendly and support thousands of participants in each league." 2. Key Features I Need: User Registration & Login: Users should sign up with email, phone number, or social media. OTP verification for secure login. League System: Each league will have 1,000-2,000 participants. Users pay an entry fee of 200-250 INR to join a league. After the tournament, the top 5 or 10 participants win prizes. Team & Player Selection: Users select 2 teams out of 10 available teams. They choose 6 players (from both selected teams). Prediction Feature: Users will predict: Total runs their selected...

I'm seeking a professional to write an educational booklet aimed at teachers, with a focus on curriculum planning. The booklet should be engaging, informative, and practical, providing teachers with useful strategies and insights. Key Responsibilities: - Research and write a comprehensive, well-structured booklet on curriculum planning - Convert the booklet into a QR code format for easy access Ideal Skills and Experience: - Proven experience in educational writing, particularly for teachers - Strong understanding of curriculum planning - Skills in digital content creation and QR code generation Please bid if you have the relevant experience and can deliver a high-quality product.

...looking for a developer to build a professional, functional WordPress website for my company hosted on Bluehost. The primary purpose of the site is to serve as a client portal where clients and admins can log in to access specific files, manage accounts, and control permissions. The website needs to be built using WordPress for easy management and scalability. Key Features and Requirements: 1. User Roles and Permissions: Admin Role: Ability to create, edit, and delete client accounts. Control file access permissions for each client. Manage files, folders, and access settings through an intuitive admin dashboard. Client Role (Subscribers): Each client should only see and download the files that have been specifically assigned to...

I am seeking a talented designer and mobile app developer to create an interactive sport application tailored for teenagers. This app will make training engaging and accessible, utilizing vibrant and colorful UI/UX designs. Key Features: - A comprehensive library of training exercises in video format, all in portrait orientation. - User registration and login system to track progress. - A game-like logic where users need to complete previous exercises to unlock new ones. Users will earn awards by reaching set objectives. - Two access tiers: a free version with limited content and an annual subscription model for full access. - An offline mode that allows users to download specific videos for offline viewing. - Tag Logic Video Organization: ...

...strategy Ideal candidates will have: - A strong background in graphic design, particularly in food packaging - Knowledge of FDA labeling requirements - Experience in creating designs for branding purposes - Attention to detail to ensure all required information is included and accurate. Technical info: Packaging size - 3.5 oz (100gr) Size: 190x255mm Product Name: Turkish coffee Product name description : roasted and ground coffee Barcode: to be provided to winner Backside of final packaging (sides of template) will include preparation and cooking instructions. Nutrition table attached. Attached example and template of other design. What is more important is front design and professional knowledge of FDA labeling requirements. Must provide actual ...

...site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) BARWA COMMERCIAL AVENUE, DOHA - QATAR • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the att...

I want to create a web application that I will use for online training sessions with my clients. Here are the specifications and required functionalities for the application: --- **Guidelines for Developing a Web Application (Condensed Version)** 1. **User Accounts** - Registration and login with different access levels (trainers, clients, administrators). 2. **Personalized Profiles** - Entry and updating of personal information, photos, short bios, and preferences. 3. **Communication** - Chat system with notifications, potentially including group conversations. 4. **Training Program Management** - Creation, review, and updating of training plans; tracking client progress. 5. **Scheduling and Calendar** - Appointment entries, reminders, and a s...

I'm looking to transform my current site into a polished corporate site. The primary goal is to showcase our products effectively. Key Requirements: - A sleek, user-friendly design that aligns with corporate standards - A dedicated section for product display featuring: - An image gallery - Detailed product descriptions Ideal Skills: - Strong background in product website development - Proficiency in UX/UI design - Experience with e-commerce site features is a plus

...best possible light. I am looking to elevate my new Airbnb listing by incorporating lifestyle photography that goes beyond the standard property shots. By adding images of people, pets, and other elements that highlight the active use of the spaces, I aim to create an emotional connection with potential guests and drive bookings. THIS IS PROJECT #1 OF MANY TO COME AS WE NEED FOR OUR ENTIRE PORTFOLIO OF RENTAL HOMES! What I'm Looking For: I’m seeking a talented freelance photographer and/or photo editor with expertise in lifestyle photography and image editing. Your role will be to use my existing property photos and seamlessly incorporate lifestyle elements into them to tell a compelling story. This might include: Families enjoying ...

...company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) MOO 9, KOH LAK SUBDISTRICT, MUEANG DISTRICT, PRACHUAP, KHIRI KHAN PROVINCE 77000 THAILAND • Has a camera or phone/tablet of quality with a camera, inte...

We are looking to develop a cutting-edge real estate platform tailored for golf course properties. This website will offer AI-driven property descriptions, integrate immersive golf course virtual tours, and provide unique real-time data, making it the top destination for golf enthusiasts interested in buying homes on or near golf courses. The project will require building a user-friendly front-end and robust back-end with AI-powered features, multimedia integrations, and real-time data. Complete website, meta tagged and SEO ready, APP for Android/iOS Project Requirements Breakdown: Core Features of the Platform: 1. AI-Powered Property Descriptions Objective: Automatically generate dynamic and personalized descriptions for golf course properties. Details: Use AI to create u...

Subject: Need a Commercial Ad for M Brand Rice I’m looking to create a 30-second commercial ad for my rice brand, M Brand Rice. The goal is to highlight the premium quality of the product, its authenticity, and how it brings families together through delicious meals. Key Details for the Ad: 1. Concept: • Showcase the journey of the rice: • From lush green fields where it’s grown. • Through modern, hygienic processing methods. • To the dining table where families enjoy it together. • Emphasize the themes of purity, tradition, and togetherness. 2. Scenes to Include: • Aerial shots of golden rice fields. • Farmers harvesting rice, followed by modern packing processes. • Families enjoying meals...

Enhance SQL Server trigger on the UserProfile table to correctly handle scenarios where RoleId changes for a given UserId (via UI or direct query) and log them appropriately in the UserProfileHistory table.

I'm looking to enhance our website with a client diary. Its main function will be to schedule appointments, but I also want it to have a few additional features for convenience and efficiency, for both clients and non clients. Key Features: - Appointment Scheduling: The primary goal of the client diary is to facilitate scheduling of appointments. - Automated Reminders: I want the system to send automated reminders for upcoming appointments to help reduce no-shows ( email & text messages) - Calendar Integration: The client diary should seamlessly integrate with popular calendar services to allow for easy tracking of scheduled appointments. Access: - The client diary should be accessible to both clients and staff. It nee...

I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.

Description: I am looking for an experienced and creative UI designer to design the interface for our new app. No teams, agencies, or middlemen, please – I am exclusively seeking an individual designer. This project does not involve any programming; it is strictly for the design of the landing page and the app’s frontend. Our app will be a platform for creators, enabling them to monetize their digital content effortlessly. The functionality will be similar to the competitor app SnapSell. Your goal is to create a modern, intuitive, and visually appealing design that highlights the core features and provides an exceptional user experience. Requirements: Design an attractive and clear landing page. Create a user-friendly frontend design for the app....

...authenticity of M Brand Rice, showcasing its journey from farm to table and emphasizing its role in bringing families together over delicious meals. Ad Script: Scene 1 (0–5 sec) • Visual: Drone shots of golden rice fields swaying in the wind, with a soft sunrise in the background. • Voiceover/Text: “Grown with care, nurtured by nature.” • Music: Gentle and soothing instrumental track. Scene 2 (6–15 sec) • Visual: Farmers handpicking rice, close-ups of the grains. Transition to modern, hygienic machinery cleaning and packing the rice. • Voiceover/Text: “M Brand Rice – combining tradition with modern technology to ensure purity in every grain.” • Music: Soft rhythm picking up pace....

I need a skilled freelancer to scrape product information from a specific website. The task involves extracting a total of 841 entries accurately and efficiently. The data fields required include product name and price, product description and images, and product specifications and reviews. The ideal candidate should have experience with web scraping tools and techniques, ensuring clean and organized data output in CSV format. Key Requirements: - Web scraping expertise, preferably with Python - Attention to detail for data accuracy - Ability to deliver results in a timely manner - Providing the code used for the scraping task

...and video meetings but has connection issues that need debugging and fixing. Tech Stack: Frontend: React 18, TypeScript Backend: Supabase Video Integration: State Management: React Query UI Components: Shadcn/UI Real-time Updates: Supabase Realtime Current Issues: Meeting connection failures Token creation errors Room URL validation issues Device permission handling problems Key Files to Work With: src/components/ src/components/ supabase/functions/manage-daily-room/ src/components/ Required Skills: Strong experience with React and TypeScript Experience with WebRTC or video conferencing integrations Knowledge of API Familiarity with Supabase or similar backend-as-a-service Understanding of real-time communications

We are seeking a creative and experienced interior designer to develop a comprehensive design proposal for our Table Tennis Association facility. The project aims to create a vibrant and functional space that reflects our passion for table tennis while being welcoming to players and spectators alike. The designer should incorporate elements that enhance the overall experience, including seating arrangements, lighting, and decor. Please provide a portfolio showcasing relevant work in sports or recreational facilities.

I'm looking for a skilled developer to create an automated script that scrapes products from an eCommerce site. The script should capture comprehensive product details and export them into a CSV file via Excel. Key Requirements: - The script needs to operate automatically, without manual intervention. - It should meticulously gather: - Photos and text - Price and description - Category and SKU Ideal skills include web scraping, Python or similar programming language expertise, and experience with data handling in Excel and CSV formats. Please ensure your proposal includes relevant past projects, as well as your approach to this task.

I'm looking to develop a cross-platform mobile application (iOS and Android) similar to Easy Dinner. The app should allow users to reserve tables and book entertainment tickets online. Key Features Include: - A table reservation system with real-time availability, multiple payment options, and user reviews - An entertainment ticket booking system primarily for concerts and theater shows Ideal Skills and Experience: - Expertise in cross-platform mobile app development - Proven experience in developing similar reservation and ticket booking apps - Knowledge of integrating real-time databases and payment gateways - Experience with user review systems

Good morning, We have a product which is OBD2 diagnostic interface for passenger vehicles, the existing design is shown in the photos in attachment, as well as the STP file. Unfortunately, I do not have the exact .STP file for this specific model, but I do have an .STP file for a very similar device. Please note that the OBD2 port must remain unchanged, as you most probably know. However, the top section of the device can be freely modified to suit your creative vision. This product is very popular, but its design is already 10 years old, so we would like to refresh and modernize it. Requirements: 1. In this campaign we are focusing mainly on the design of the external look; 2. OBD port is a standard, we cannot change it; 3. Final file format should be in .STP for...

...Option Trading in NSE and BSE Objective: To develop an automated trading system for stock and options trading in NSE (National Stock Exchange) and BSE (Bombay Stock Exchange) based on our proprietary trading methods and rules. The system should integrate with multiple brokers, execute trades as per predefined conditions, and provide real-time analytics and reports. Scope of the Project: Trading Strategies: Automate trades based on the following methodologies: Candlestick Patterns: Identify and act on specific candlestick formations. Fibonacci Levels: Recognize retracement and extension levels for trade entries/exits. RSI (Relative Strength Index): Execute trades based on overbought/oversold conditions. Elliott Wave Theory: Use pattern recognition to identify wave counts ...

I'm looking for a ta...clients and various car auction sites. Key Features of the Project: - The application will utilize provided credentials to grant clients access to multiple car auction sites. - Clients will register and authenticate themselves on our platform. - Bidding will be the only restricted functionality on the auction sites. Clients should be able to view everything else freely, but without the ability to place bids. Ideal candidates for this project should have: - Extensive experience in desktop application development, particularly for Windows. - A solid understanding of creating user authentication systems. - Familiarity with car auction sites would be a plus. - Capability to implement restrictions on certain functionalities...

Job Title: Fiscal Representative for VAT & EORI Registration (Germany) Description: We are seeking a Germany-based fiscal representative to assist a Georgian Individual Entrepreneur (IE) with registering for German VAT and EORI numbers. The business imports goods from China to a warehouse in Germany and sells across multiple EU countries, including the UK. Responsibilities: • Register the business for German VAT and EORI numbers • Advise on VAT compliance, reporting obligations, and import VAT (19%) • Clarify whether monthly VAT filings are required and assist with compliance • Provide guidance on the One-Stop-Shop (OSS) scheme for EU-wide sales • Ensure proper VAT payments and compliance for imported goods and EU distribut...

...description: Introduction This proposal outlines the development plan for a comprehensive Nursery Management Web Application. The application is designed to meet the needs of nursery owners, parents, and administrators by providing essential functionalities such as child management, attendance tracking, billing, and more. Technology Stack** • Front-end: React and • Backend: PHP (Laravel framework) • Database: MySQL Deliverables 1. Main Application Account • Dashboard • Customizable with widgets and graphical elements. • Client Account Management • Create, suspend, delete client accounts. • Access Control • Give access rights to certain features. • Billing with Deposits and Discounts • Implement basic ...

I'm running a multivendor site using Dokan, and I need to integrate Shiprocket as the courier service. Currently, I don't have a management system in place for shipments. Key Requirements: - Integration of Shiprocket courier service into the website. - Implement features for sellers including: - Ability to pay for their own pickups. - Option to generate commissions for pickups. - A seller dashboard for managing pickups. - Configure the above with the Dokan plugin. - Allow sellers to process multiple orders in bulk for shipping. - Enable sellers to print shipping labels directly from their dashboard. - Automate shipment tracking updates for both sellers and buyers. - Add options for sellers to import and export shipment data via ...

I'm seeking a skilled developer to create a comprehensive online casino platform. The project should include: - Gaming Platforms: The casino should feature slots and table games. - Payment Integration: The platform must support a variety of payment methods, namely Credit/Debit cards, Cryptocurrency, and E-wallets. - User Authentication: A robust user authentication system is crucial for the platform's security and user-friendliness. This should include Email and password logins, as well as Social media login capabilities. The ideal candidate for this project should have extensive experience in developing online gaming platforms, with a particular focus on integrating diverse payment methods and implementing secure user authentication systems. A portfolio showcas...

...for a designer to assist with our PDF tariff document. This PDF includes company details, a tariff table (with vehicle types, sizes/capacity, prices, and minimum charges per mile), our logo, and a footer with contact details and a website link. We do not require a redesign of the PDF; rather, we need to link the PDF to an Excel spreadsheet, so that when we update vehicle details, prices, or other information in Excel, the changes will automatically reflect in the PDF. The final deliverables should include the existing PDF document, a linked Excel file, and clear instructions on how to update the file efficiently. The goal is to streamline the updating process without requiring manual edits in Adobe, making it easier for all team members ...

...top-tier data entry services to clients across various industries. To ensure the highest quality of service, I am seeking experienced Data Entry Specialists to join my team on a project basis. The ideal candidates should exhibit the following: - Proven experience in data entry with a keen eye for detail and accuracy. - Proficiency in MS Office Suite, Google Suite, and other data processing tools. - Excellent typing speed and the ability to handle large volumes of data. - Strong understanding of data confidentiality principles. - Ability to meet tight deadlines and manage tasks effectively. As part of my team, you will receive clear guidelines and expectations for each project to ensure client satisfaction. If you have the skills and exp...

...looking for site admin and ASP.NET MVC developer to set-up a simple single temporary landing page on GoDaddy with ASP.NET MVC project and one page. The page will contain 1 image, and the text "Welcome to the Sports Fiction game development project. This site will be updated in the Spring/Summer 2025. Thanks for visiting" Hosting already purchased: GoDaddy - Windows Ultimate (Plesk) Domain: Required work 1) Let me know a bit about yourself and provide any useful advice 2) Suggest low cost SSL certificate option (not yet purchased) to work with GoDaddy page in HTTPS. £100 maximum price. Do you know any good options. 3) Request temporary GoDaddy login (or actions to perform) 4) Set up the SSL certificate and HTTPS access for the sit...

I need a Linux/CentOS expert to help me set up a second SFTP account on my Amazon hightail server. This needs to be done over screenshare. The specifics are as follows: - The second SFTP account needs to have 'Read and Write' access. - The server is running CentOS 8. - The SFTP account should support both 'Password' and 'SSH key' authentication methods. Please, only bid if you're comfortable with screensharing and have relevant experience.

...directory permissions related to the maildrop folder, which has resulted in repeated failures of the Postfix integrity check. Despite multiple attempts to adjust permissions and configurations, the issue persists. Additionally, we require assistance in configuring email rerouting to ensure that emails from our domains are seamlessly accessed via Gmail as the primary client while maintaining our hosted mail server on the Plesk panel. Scope of Work: Resolve Postfix Configuration Issues: Investigate and fix the recurring scan_dir_push: open directory maildrop: Permission denied error. Ensure proper permissions and ownership settings for all required directories, including /var/spool/postfix/maildrop. Verify the integrity of Postfix configuration files and adjust as n...