Excel macro to hide columns based on criteriapráce

pasar informacion a excel. pasar informacion a excel

Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.

Znalost JavaSE/EE a relačních databází. Angular znát není třeba, stačí vůle se ho naučit. Min. 3 roky zkušenost s komerčním vývojem. Znalost automatických testů. Dovednost domluvit se s kolegy anglicky (min B1). Java, Spring, Maven, Hibernate, RabbitMQ, Angular 2, JSP + další webové technologie, Relační databáze + SQL, JavaScript, jQuery, REST, XML a XSLT, JUnit / TestNG, Mockito nebo PowerMock, GIT, základy linuxového skriptování (Bash), Google Analytics / Google Tag Manager, testování zabezpečení webu

Znalost JavaSE/EE a relačních databází. Angular znát není třeba, stačí vůle se ho naučit. Min. 3 roky zkušenost s komerčním vývojem. Znalost automatických testů. Dovednost domluvit se s kolegy anglicky (min B1). Java, Spring, Maven, Hibernate, RabbitMQ, Angular 2, JSP + další webové technologie, Relační databáze + SQL, JavaScript, jQuery, REST, XML a XSLT, JUnit / TestNG, Mockito nebo PowerMock, GIT, základy linuxového skriptování (Bash), Google Analytics / Google Tag Manager, testování zabezpečení webu

Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.

hello sir ji

Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.

Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.

Vytváříme personalizované dřevěné předměty a potřebujeme zvýšit povědomí o značce, o produktech, zvýšit followers.

datae

datae

Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl

mise en forme

Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket

Napraviti Excel VBA program

Zdravím, měl bych nabídku na dlouhodobější projekt (vývoj standalone aplikace, ne webové) a v případě zájmu pošli více informací.

I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting ...

I'm seeking a creative designer to develop a uniquely captivating, text-based logo design for a new project. My vision is firmly defined and I am in pursuit of a professional who can translate it into a crisp, unforgettable logo. Key Requirements: - Develop a text-based logo - Follow predefined color schemes and visual elements - Strong attention to detail to incorporate the specific elements I have in mind Ideal Skills & Experience: - Extensive experience in Logo Design - Ability to work with defined color schemes and visual elements - Excellent communication to ensure a firm understanding of project details I am excited to collaborate on this project and look forward to the creativity and expertise you wi...

...business on AmazonUK and currently conducts activities in the UK. As per the update by Amazon in 2024, we need to appoint a UK resident director to continue our operations on AmazonUK. This position will be purely nominal and the director will not be involved in active management. Job Details: Our company, operating wholesale trade on AmazonUK, is seeking a director residing in the UK. The director position will remain purely nominal, with no involvement in the active management of the company. A fixed monthly payment of $125 will be provided for serving as a visible director on behalf of the company. If company director want, our all returned products will be send director's return address monthly (we have global branded inventory) We ...

I'm looking for a skilled developer to design and build a website that will facilitate crypto funding rounds using the Solana network. This project involves creating a website that can transact with investors and distribute tokens at the end of all the funding rounds. Key elements of this project include: - Developing a site with the following features: Crypto funding rounds, Transaction capability, Token distribution - Using a Solana-based solution - Integrating the site with Crypto wallets - Writing secure Solana Smart Contracts Preferred Platform: ReactJS but open to suggestions Design: A design has already been prepared for the site as in Images and wording but the pages etc need to be setup. Ideal candidates for this project should have: - Profici...

IOT is being used a lot these days to provide functions that were being done before manually. We are also embarking on the same journey and looking for a potential person who can help us with our proposed system. Thank you

...functionalities: - Room Booking: The app should allow guests to browse and book available rooms. - Payment Processing: The app should be capable of handling payment processing for the room booking as well as for other services provided during the stay. This should be included in the check-out bill. - Check-in & Check-out Process: I'm looking for a clear and easy-to-understand check-in process, making it a seamless experience for guests. - Room Display & Offers: The app should display different room types along with their charges. It should also showcase any available offers. The ideal candidate for this project should have: - Prior experience in developing hotel management or booking apps, particularly for Android. - Strong skills in UI/UX design to...

I'm looking for a skilled developer to create a basic matchmaking website. This website is intended to connect users based on specific criteria. Key Features: - **User Profiles**: User should be able to create profiles. These profiles must capture the user's name, age, specific pricing details for using and providing the service. - **Matching Algorithm**: This is the core functionality of the website. I need a matching algorithm that can match users based on the information they provide in their profiles. The algorithm should be efficient and accurate. - **Messaging System**: The website should have a messaging system that enables users to communicate. I'd like this system to include both chat messages an...

I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.

I need an experienced and reliable Java developer to build the backend for a user registration page. The functionalities and specific requirements include: - Implementing basic user registration features requesting name and email. There should not be any social media integrations or two-factor authentication involved. - Ensuring secure data handling and privacy of users' information. Ideal skills and experiences include: - Proficiency in Java and in building user registration modules. - Experience in ensuring data privacy and security. Your extensive experience in creating swift and secure registration processes is crucial for this project.

German Male only. We are looking for German Natives for a short voice recording project. You need to read and record 235 short sentences in our app and pay is 20$ When applying: Make sure you are a German native of Germany Have not participated in this project before You need to submit one ID proof that shows you are native German(you can hide sensitive information) Payment is 20$ for all 235 approved sentences and in checking it might take up to 4 weeks.

I'm in need of an Excel expert who can help me compile a detailed file for the merger of PVR and INOX. The document should contain two main sections: - Financial Data: - I require you to list the revenue, expenses, and profit/loss figures. These should be clearly presented in a way that allows easy comparison. - Merger Details: - You will also need to include specific merger details. This includes the merger date, the terms of the merger, and the name of the merged company. The ideal candidate for this project is an experienced Excel user, with a proven track record in data analysis and a keen eye for detail. You should be comfortable working with financial data and able to present complex information in a clear and insightful manner. ...

...estate program for my company's real estate agents. It is a program for internal use, that is, it will only be used by our real estate agents. Key Features: - Property management: the program should be able to efficiently manage a number of properties between 100 and 1000. - Advanced Property Search: An easy-to-use interface that allows real estate agents to search for properties seamlessly, filtering based on various criteria. - Sales Report Generation: The program should be able to generate complete sales reports for our properties. - CRM integrated with AI: the CRM component must be able to understand and address the client's property search needs through the use of Artificial Intelligence, providing personalized pro...

is a start up company Requirements: 1. Company name 'Zeena' so logo needed without .ai word 2. Need source files (SVG, Vector file format(illustrator), PSD) 4. High resolution image files are needed 5. Horizontal and vertical designs Additional requirements/nice to have: Letterhead with logo

I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensat...

...experienced Marketing Manager based in Uzbekistan for my crypto lottery operator. The marketing strategies will be multi-faceted: - Social Media Marketing: Focusing on Telegram. Experience with crypto communities on this platform is highly desired. - Email Marketing: Crafting engaging email campaigns to reach and engage our audience. - Influencer Marketing: Identify, engage and manage influencers within the crypto and gambling space. The ideal Marketing Manager should: - Have a deep understanding of the crypto space and have prior experience working with crypto projects. - Be skilled in creating and executing effective social media marketing and email marketing campaigns. - Have a track record in influencer marketing, specifically within the crypto or gambl...

...developer to successfully extract numerical information from images and convert it into text format. This text shall be useful as input data for another system I run. Key aspects of the task include: - Recognizing numerical data within images using advanced AI techniques. - Converting the identified numbers into text format suitable for another system's input requirements. The ideal freelance candidate for this project would be exceptionally well-versed and experienced with: - AI and Machine Learning methodologies, particularly in image processing. - Available tools and software for effective number recognition from images. - Text conversion from recognized image data. Your input will be an integral part of a crucial system we are running, and therefore accuracy and att...

I am looking for a REMOTE personal trainer VIA ZOOM who can help me improve my overall fitness at h...can help me improve my overall fitness at home. I would like someone who can assist me 5 or more days a week. Preferred Skills and Experience: - Extensive experience in personal training, ideally with a focus on overall fitness improvement. - Knowledge in structuring comprehensive home-based workouts. - Ability to create diverse workout plans to avoid monotony. - Experience in motivating clients to attain their fitness goals. This is an excellent opportunity for trainers who have a knack for pushing their clients towards their best and are capable of providing a personalized approach to fitness-building. Please ensure your proposal details your a...

I'm in need of an experienced software developer to finish a web-based e-signature app already in progress. This app should offer all-inclusive features such as handwritten signature input, text-to-signature conversion, and the ability to upload images as signatures. A significant aspect of this project is ensuring that all e-signatures are secure, thus requiring advanced encryption with digital certificates. Here are the key points about the project: - Platform: Web - E-Signature Features: - Handwritten signature input - Text-to-signature conversion - Image upload as signature - Required Security Level: Advanced encryption with digital certificates The ideal applicant would be well versed in web-development and has expertise in building s...

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to du...

I am looking for a consumer researcher to visit 3 stores in ROUEN. The project in a nutshell: -All information will be captured via our company's App that has to be downloaded by way of a link emailed to the successful candidate. -Visit 3 supermarkets in Rouen, addresses will be provided. -Around 42 products in total not per a store. – Assess packaging of products for our client, products include baby diapers, feminine hygiene products, kitchen paper and toilet paper. -10 samples per a product has to be assessed. E.g Product A is baby diapers, 10 of these will have to be looked at closely for defects. -If samples are good no photos are required, if samples have defects photos are required showing the defect clearly. -No products need to...

...and a good understanding of TradingView's indicator functionalities. The main task is to build a custom indicator that includes Bollinger Bands, Exponential Moving Averages (EMA), and Relative Strength Index (RSI). Key Requirements: - Apply two EMA's within the main window. - Bollinger Bands should also be displayed in the main window. - Integrate Stochastic Oscillators with the above-mentioned two EMAs and RSI below main window This script should also allow specific customization aspects: - Setting the EMA period. - Modifying the Bollinger Bands period. - Adjusting the Bollinger Bands standard deviation. -adjusting %K&D,slowing,price field,method&level -adjusting RSI period,apply to weigh close HLCC/4 Ideal skills: - Proficient in c...

I'm seeking a top-notch freelancers with expertise in Laravel PHP to design my business-oriented payment gateway website. Ideal candidates should have a deep understanding of e-commerce platforms and a proven track record of delivering reliable and secure payment solutions. The final product should enable hassle-free transactions for businesses and ensure a seamless user experience. Key Requirements: - High proficiency in PHP, particularly Laravel - Familiarity with business-oriented platforms - Experience in integrating multi-currency support - Mobile wallet integration expertise - Proven ability in creating detailed transaction reporting systems - Deep understanding of security protocols - Excellence in UI/UX for a seamless user experience By evidenced past work, this task...

I'm looking for a skilled data analyst to help me with a comprehensive statistical analysis of a survey I conducted with roughly 100 participants. Key Requirements: - Proficiency in Descriptive, Inferential, and Correlation data analysis techniques - Experience in interpreting survey data to identify trends and patterns - Ability to test hypotheses and make inferences - Knowledge of how to determine relationships between variables - Excellent skills in Excel and/or other statistical software or python for data manipulation and analysis Ideal Candidates: - A data analyst with a proven track record of handling survey data - Someone who can derive meaningful insights from the data - Excellent communication skills to explain the results in a c...

As my project deals intricately with WordPerfect, I'm in search of an experienced freelancer who knows the ins and outs of this software. - **Expertise Required**: In-depth knowledge of WordPerfect is a must. Your task will include document formatting, template designing, and macro automation. - **Application Criteria**: Please include proof of your expertise in WordPerfect in your application, such as a detailed description of a project you have worked on or a list of tasks performed using WordPerfect. Show me why you're the best candidate for this task! - **Note**: This project strictly requires WordPerfect skills only. Additional software expertise is not necessary for this particular project. Your exclusive proficiency in WordPerfect will be vital fo...

I am developing a Docker-based federated learning solution for industrial predictive maintenance to greatly enhance machine downtime prediction. The purpose of this system is to more accurately anticipate necessary maintenance and reduce unexpected downtime in industrial machinery by analysing operational data such as speed, temperature, equipment running time, and so on. Prospective freelancers must have skills and experience in the following areas: - Docker, for providing the backbone of our decentralized system - Federated Learning, to collectively improve our model's performance without sharing raw data - Working with and analyzing operational data - Implementing predictive models, in this case a 3-layer feed-forward neural network and stochasti...

I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data ar...

I am looking for a professional and experienced Hindi voice artist for an audiobook project targeted towards Adults. Key Criteria: - The audiobook is extensive, more than 300 pages - Proficiency in Hindi and an understanding of teenage dialogue would be highly valued - Past experience with Hindi Audible or audiobook narration is necessary Required Skills: - Voice Acting - Audiobook Production - Audio Editing - Experience with teenage-targeted narratives Please provide samples of your previous work along with your bid. I look forward to hearing your captivating voices that can truly bring this story to life for our teenage audience.

As a client looking to develop a project centered on image recognition on Handwriting Character Recognition, I require a proficient Deep Learning Engineer who has expertise in Python programming. The core of the deployment involves: - The development of an effective image recognition system - Efficient use and application of PyTorch as the preferred platform The ideal candidate for this project exhibits the following skills and experiences: - Significant knowledge and experience in Python - Extensive understanding of PyTorch - Prior experience with image recognition projects Please ensure you have a strong grasp of the above-mentioned skills before bidding on this project. I look forward to meeting a dedicated professional who can deliver on...

...a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ide...

K zobrazení podrobností se zaregistrujte nebo přihlaste.

As a client looking to develop a project centered on image recognition on Handwriting Character Recognition, I require a proficient Deep Learning Engineer who has expertise in Python programming. The core of the deployment involves: - The development of an effective image recognition system - Efficient use and application of PyTorch as the preferred platform The ideal candidate for this project exhibits the following skills and experiences: - Significant knowledge and experience in Python - Extensive understanding of PyTorch - Prior experience with image recognition projects Please ensure you have a strong grasp of the above-mentioned skills before bidding on this project. I look forward to meeting a dedicated professional who can deliver on...

We're in the market for a chatbot expert to guide us to the right chatbot solution for our website and help us implement it. Here's what we're looking for: • Chatbot Recommendations: We don't have a specific chatbot platform in mind yet, so we'll need your advice to help us pick a solution that is well-matched with our website's needs. • Multi-Purpose Chatbot: The chatbot's main purpose will be answering customer queries, but we'd also like for it to filter requests to specific emails and capture leads. • Request Routing: We want the chatbot to filter and direct requests to specific emails based on certain criteria or questions. Ideal Skills: • Proficiency ...

I need a web platform designed, specifically dedicated to user registration. The key information required during the registration process will be the user's username and email address. Uniquely, I do not need validation for these inputs, providing the user with a smoother and hastened sign-up process. Ideal skills and experience: - Proven web development experience - Proficient in creating user-friendly interfaces - Knowledge of maintaining database integrity without input validation

Live demo needed with source code using your api accnts and server to show that automatic reply of my customers on Twitter reply/direct message using chatgp from source cudtum file and support Arabic with images understanding. Freelancer job description : As someone who's well-versed with both Twitter and ChatGp APIs, I'm looking for a skilled professional to integrate these APIs for a specific purpose. Key requirements: 1. **Automating social media interactions:** I want to automatically reply to tweets on Twitter based on certain triggers or criteria. This integration should be able to handle various scenarios and response types. Skills and experience required: - Proficiency in Twitter API - Proficiency i...