Excel vba function return arrayprá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.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
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í.
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
...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...
Nastavení vytvořených Facebook účtu podle parametrů zadaných v excelu - změna jména, skrytí privatních informací (skrýt zeď pouze přátelé, skrýt kamarády pouze pro přátelů), pohlaví, pohlaví a nastavení nějakých like stránek z Czech Republic. atd. Já pošlu Excel po dohodnutí se na zakázce. První zadání je úprava 300 FB účtů.
Hello, Your Request I create a simple application that will communicate with the server. Function application is simple. - User logs (as opposed to server notified) - Key track position (at adjustable intervals Applications sent by gps coordinates to server. I make API that assumes the dates and stored in the database) - START background (applications are minimized, but still sends location information) - Shut down button (Applications will be turned off) The application therefore has access to the Internet and GPS. nothing more
I need a program that will notify you when the sound pops authenticate using captcha systems. One of the boot program, which must function at the server
I need help with my accounting and auditing tasks, including bookkeeping, financial statements preparation, and internal control evaluation. I'd like to include 1 year of financial data in the statements. I require a professional with the following skills: - Proficiency in QuickBooks, Xero, and Excel spreadsheets - Experience in bookkeeping - Preparing financial statements - Evaluating internal controls Your role will be crucial in ensuring that my financial records are accurate and compliant with accounting standards.
I'm seeking a skilled app developer to create a VPN service app for both Android and Apple phones. The app should primarily function by offering multiple server locations to our users. Here are some key requirements: - User Interface: - The app should have a minimal and intuitive interface. The user login screen should be the first and only screen the user sees upon opening the app. - The login process should be straightforward with users entering their username and password only. - VPN Server Locations: - The app needs to support multiple server locations for the VPN service. These locations should be easily accessible for the users to connect to. - The VPN to be developed should be based on SSH and V2Ray protocols. The ideal candidate for this project should ...
We need a list of all stores in US & Canada that fall under any of the following categories/keywords: Watch Store Watch Repair Shop Jewelry Store Jewelry Repair Shop Fashion Boutique Outdoor Goods Store Sporting Goods Store Electronics Store Mobile Phone Repair Shop You will have to scrape these websites: Yelp, Yellow Pages, Google Maps I have provided an Excel template to follow.
Our project is to create a comprehensive website that can serve in three ways; a platform to sell touring packages, providing hospital contacts for an array of treatment options, and assisting prospective candidates with university applications in the US and Portugal. This website will be developed in Wordpress and should have the potential to convert into an application. Sections to Include: 1. Touring Packages: This section is our primary focus, offering travel package sales to individuals, families, and group tours. Detailed information about each package should include itinerary, price, photos, and other relevant details. 2. Hospital Contacts And Treatment: A space to share contacts of hospitals and clinics specializing in various treatments, along with a feature that allo...
...entries and MS Excel billing work. The ideal candidate should be well-versed in both Tally and MS Excel, as well as have a strong attention to detail and a high level of accuracy. Key responsibilities include: - Data entry: You will be responsible for entering a wide variety of data into Tally, including processing of invoices, bank statements, and other financial records. - Account reconciliation: Regular reconciliation of Tally entries against bank statements and other financial records is crucial to ensure accuracy in our financial data. - Inventory management: Tracking and updating inventory records in Tally is another essential task that needs to be performed regularly. For the MS Excel billing work: - Creating invoices: You will be responsible for creatin...
THIS IS AN URGENT PROJECT. I NEED SOMONE THAT CAN DO THIS TODAY AND PLEASE PLACE FINAL BIDS. I dont have time to negotiate. I'm looking for a competent Wordpress developer to create a blog filter page on my website. The user profile's custom fields should function as filters for this page. Im using UserPro custom fields where people can select their interests and content preferences so I need these to filter the blog archive/feed. post I also have search and filter pro that may be able to do the filter work but I need help to set this up so when a user is logged in they see a filtered page based on their tag interests. Skills & Experience Required: - Excellent knowledge of WordPress and custom fields - High creativity
I’m in need of a Shopify expert to assist me with online store. All details about the changements by message. Code and design changements. I have 7 small changements in design and function that need to be done very fast so we can finish the project soon. Have more projects in future so looking for long time support and good price. Deadline is asap, 1-2 days max.
I need a pretty simple Excel spreadsheet. It is for a used car dealership. I need a row to imput the vehicle, one for the purchase price of the vehicle, one for the cost to prepare the vehicle for sale, one for the sale price, and one for the profit or loss on the sale. I would like it setup with tabs at the bottom for months and years
I am seeking a dedicated academic writer with firm knowledge in technology, especially in machine learning and its application in diagnosing lung diseases. Your roles include: - Reviewing existing literature on digital pulmonary function tests using machine learning approaches. - Synthesizing information and formulating articulate, objective discussions. - Creating a comprehensive review paper. The ultimate aim is to have a clear, detailed understanding of how machine learning can be leveraged for diagnosing lung diseases. Ideal candidate should have prior experience in academic writing and a keen interest in the technology-medicine intersection. Familiarity with terms and current trends in artificial intelligence, machine learning, and medical diagnostics is a plus.
I'm looking for a proficient Excel expert to create a comprehensive, automated meeting minutes template for Excel 2016. Key Features: - Auto-fill dates and participant names - Automatic calculation of meeting duration - Dynamic agenda item addition - 15 task owners fields - Core areas discussed: Process, People, Technology, System Ideal Skills: - Advanced Excel skills - Strong knowledge of Excel 2016 - Experience in creating automated templates - Eye for detail to ensure the tool works flawlessly The goal is to streamline our meeting minute creation process and ensure accuracy in documenting key points discussed and task assignments. Delivering a user-friendly tool that requires minimal manual input is key.
...seamlessly combine front-end and back-end capacities will be crucial to the success of this project. The project encompases 3+ websites, new logo design, testing, and hosting capabilities. Key Requirements: - Mastery of Wordpress or similar. - A minimum of 5 years experience in full stack development. - Expert in UX/UI. - Integration of chat function. - Integration of ticketing system. - Integration of chat function. - Integration of advertising banner function. - A proven record in deploying and maintaining functional, secure and high-quality applications. - Experience in building a forum or blog. Ideal candidates should detail their extensive experience with similar projects. Please highlight any accolades, milestone achievements, or particularly challenging u...
We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distribute picklists to employees (Generate a picklist and have employees confirm Picking them) - Picked parts must be scanned out of inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Invento...
I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.
I am seeking for property manager who have strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools (Microsoft Office - Word & Excel). Responsibilities • Gathering data from one source (Google Drive) to enter into document management (databases or partner websites by case) • Checking and reviewing documents for accuracy and completion • Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data Data Management: Your job also includes maintaining basic property data such as address and size. The ability to organize, update, and retrieve this in...
Description: Are you a freelance sales professional with a knack for closing deals and a passion for helping others succeed in their careers? Our startup is seeking an experienced freelancer to join our sales team and drive growth for our mock interview services. As an independent contractor, you'll have...and interpersonal skills, with the ability to tailor your pitch to different audience groups. - Self-motivated and results-driven, with a strong desire to achieve and exceed sales targets. If you're a freelancer looking for an exciting opportunity to leverage your sales skills and make a meaningful impact on the careers of others, we want to hear from you! Join us in empowering individuals to excel in their job interviews and achieve their professional goals. DM your d...
I am seeking a skilled interior designer to transform my flat into a modern, elegant, and sophisticated living space. The aesthetic should resonate with a coherent design philosophy and tastefully blend all elements of the flat's interior. Key Project Details: - Design Style: Modern. The design should project a modern style that unifies function and aesthetic, emphasizing simplicity, clean lines, and minimalism. - Colors: As I have not specified a color scheme, I am open to suggestions. Ideally, the designer will suggest a color palette that aligns with a modern, elegant, and sophisticated theme. - Atmosphere: Aim to create an elegant and sophisticated ambiance. The design should incorporate elements and details that make the flat evoke a feeling of refinement and exclusive...
I am looking to create a robust webinar platform capable of hosting up to 2000 participants with the ability to live stream and record webinars. This platform should also feature a live chat function for real-time interaction during the event. Additionally, I require an associated booking website with the following functionalities: - A calendar feature to select webinar dates - A registration form for participant sign up - The option for participants to pay booking fees directly within the site - Capability to add registered participants to a WhatsApp group and send links directly after registration - An integrated follow up board for direct group additions Ideal candidates for this project should have experience in webinar platform development and website design, with proficienc...
Description: Are you a freelance sales professional with a knack for closing deals and a passion for helping others succeed in their careers? Our startup is seeking an experienced freelancer to join our sales team and drive growth for our mock interview services. As an independent contractor, you'll hav...and interpersonal skills, with the ability to tailor your pitch to different audience groups. - Self-motivated and results-driven, with a strong desire to achieve and exceed sales targets. If you're a freelancer looking for an exciting opportunity to leverage your sales skills and make a meaningful impact on the careers of others, we want to hear from you! Join us in empowering individuals to excel in their job interviews and achieve their professional goals. DM your de...
I'm seeking an Excel expert to provide a comprehensive training session for my team of 11-20 individuals. We're at a beginner level and need someone capable of teaching us the basics and showing us how to optimally utilize data analysis and reporting features. - The training should cover: - Basic Excel functions and formulas - Data analysis - Reporting techniques The perfect fit for this project would be someone with an extensive background in Excel, ideally as a trainer or educator. Experience with teaching groups is a must, and the ability to break down complex topics into digestible, understandable parts is essential. Our goal is to increase our productivity and data handling capabilities through this training, so if you have a track recor...
I submitted a wordpress plugin to wordpress plugin directory and they asked for minor code quality edit. I want you to implement those edit. These are the things they mentioned to improve: * No GPL-compatible license declared * Data Must be Sanitized, Escaped, and Validated * Generic function/class/define/namespace/option names * Allowing Direct File Access to plugin files The plugin is functional without any problem and it's a simple plugin. I just need the code standard match with the wordpress plugin repository's guidelines.
I'm looking for an Excel expert who can create an automated template for a financial renewal analysis dashboard. The dashboard should include basic descriptive statistics functions such as mean, median, mode, standard deviation, correlation, and regression. Key Requirements: - The dashboard needs to focus on the renewal status of our products/services. - It should be able to track the renewal status by product/service type. - The dashboard should be able to automatically update renewal statuses. Ideal Skills and Experience: - Proficiency in Excel and its advanced functions. - Experience in creating automated dashboards. - Understanding of financial data analysis, particularly in the context of renewals. - Strong communication skills to understand our specific needs and...
I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a ro...
...to be delivered to a specific address at a fixed cost. Group B: Item 3 & Item 4 to be delivered to a different address at a fixed cost. Final Outputs: After executing the call, I need the checkout URL and cart tokens to be returned for user redirection. The solution should include: GraphQL queries/mutations: To manage the cart creation and assign items to delivery groups. JSON Array: Fully formed, showcasing all fields and attributes relevant to the Cart Delivery Group and Cart Delivery Option as defined in the API. I do not have a public-facing site yet, but I am working in a development environment. While I have successfully implemented various other API interactions, the documentation on delivery groups has been challenging to navigate. Shopify has n...
I am seeking a professional who can help me deploy my mobile application on the Google Play Console. Key Requirements: - Experience with Google Play Console and app deployment - Knowledge of mobile application development and deployment practices Please note, specific details about the primary function of the app and its compatibility platforms have not been provided. I will share these details with the selected freelancer. This is an ideal project for a freelancer with experience in mobile application deployment and a good understanding of the Google Play Console guidelines.
...close as possible, though it does not have to be exact. GoDaddy current functionality does not permit subscription pricing. I'm launching a new service that people can buy via the website that involves a recurring subscription, pause/cancel anytime. There will be three pricing tiers. I should have the ability to edit the content and function of this new page easily. Proficiency in WordPress, payment gateways, and website migration is wished for. Function testing of the website should be included. The ideal candidate would have: * Strong experience in WordPress * Sound understanding of subscription pricing models * Familiarity with website migrations/replications The ultimate aim is to offer seamless functional improvements to the current site, making it more...
...help me fix a few issues with my CodeIgniter website. The website is running slow and throwing error messages, with several key features not working properly. Time is of the essence, so I need someone who can jump on this ASAP. Your responsibilities will include: - Resolving the error messages that are appearing - Fixing the login feature and ensuring it works as designed - Restoring the search function to full functionality - Repairing the payment processing feature and ensuring it functions correctly Ideal candidates should have: - Proficiency in CodeIgniter with a proven track record of successfully repairing websites on this platform - Strong debugging and problem-solving skills - Excellent understanding of website functions and features - Strong time management skills and ...
I'm looking for an experienced WordPress developer proficient in theme customization, dealing with plugin conflicts, and fixing HTML/CSS bugs. This role requires expertise in deciphering and remedying possible conflicting plugins, though I have not yet identified which specific plugins are causing issues. Overall, your task is to ensure the seamless function of my WordPress site by: • Identifying problematic plugins • Resolving theme customization issues • Debugging HTML/CSS bugs Ideal candidates should have: • Extensive experience with WordPress development • Strong problem-solving skills • A keen eye for detail to identify potential conflicts and bugs.
I have a need for a meticulous freelancer with solid web research and data entry skills. The project involves researching company details and the necessary data should be accurately entered into an Excel sheet. Key Responsibilities: - Detailed online research to gather specific company data. - Accurate data entry of information into Excel, adhering to specific guidelines. Ideal Candidate Skills: - Strong web research ability. - Very accurate data entry skills. - High proficiency in Excel. - Able to meet deadlines. - Excellent attention to details.
I'm in need of a skilled freelancer with proficient online research and data entry skills. Responsibilities: - Conduct online research to collect necessary data - Expertise in entering numerical data precisely - Compile, verify accuracy and organize the information into a Excel spreadsheet Desired skills/experience: - Attention to detail - Experience in data entry - Excellent knowledge of MS Excel - Strong ability in online researching
I am running an App Campaign on Meta and I want to redirect users on a specif screen based on ads they click, so I want a deferred value. I have implemented FacebookSdk and using this function '' but always getting null. For DDL, I tried entering URL, Custom Schema and DDL from a third party but nothing worked out. Note: You don't need to implement it, I just need your assistance in implementing if you have any prior experience working with the same issue.
...01 Signup Form with Phone, Email, Address Step 02 A chat box would open up with basic questions as; • Date for Booking • Time Period for Booking Step 03; Within the chat box the next question would be regarding the work profile Users can text to match profiles. Example: I want Bamboo Artisans Step 04: The Chat box will show all profiles for Bamboo Artisans as in the Directory or excel file Excel would be as simple as Skill Set, Profesional Profile Step 05: The User will select the profile they want and the next would be followed to payment gateway. Step 06. Post payment a confirmation message would be sent with contact details Service Provider Interface Step 01 Signup Form Step 02 Detailed Profile Step 03 View Bookings, View Amount which will b...
I'm looking to build a live dashboard that will display the results of both the Presidential and Local elections in real-time. Key Requirements: - I need the dashboard to be able to pull data from reliable sources(officials in polling station in an excel form) and refresh the data in real-time. This will facilitate the display of accurate and up-to-date results. - The design of the dashboard should be clean,animated,interactive, intuitive and easy to understand for users. It needs to be able to show data for both elections simultaneously with the help of a switcher between the two pages. - The dashboard should be mobile responsive, so that it can be viewed on various devices with ease. - The security of the data is paramount, so it's important that the dashboard is develo...
... expert that will help me take my existing website to the next level. The aim is to enhance functionality and enrich content to offer a more dynamic and appealing user experience. Key Tasks: - Customize website templates in line with our brand image. - Create dynamic web pages that offer a smooth and interactive user experience. Content Addition: - The revamped website will include an array of content types for the most meaningful interaction. This includes blog articles for knowledge sharing, product listings for sales purposes, a portfolio showcase to display our achievements, and Learner Management System (LMS) integration for imparting e-learning. Ideal Skills: - Proficiency in - Experience working with dynamic web pages - Expertise in customizing templates - Familiarit...
As a start up, we're in need of an Android app developer able to create an e-commerce function: Key Requirements: • Develop an Android application • Incorporate e-commerce functionality • Ambiguity about support for international clientele • Balancing quality with cost-efficiency in mind Ideal Candidate: • Proficient in Android app development • E-commerce implementation experience • Comfortable handling uncertainty of international support • Experience in budget-friendly solutions.
I'm in need of an Expert Excel programmer to help design a user-friendly Excel sheet focusing on stock and ledger management. Specifically, I'm interested in: - Incorporating Automatic Calculations: The ideal candidate should be able to create a system that automates complex calculations based on data inputs. - Dropdown menus: The sheet should offer an easy interface with dropdown menu options for hassle-free data inputs and editing. - Linking Stock and Sales: The sheet should be designed in such a way where the inventory updates automatically from sales data. So, a keen understanding of Excel's data integration and interconnection capabilities is necessary. - Essential Data Fields: My Excel sheet needs to include specific data fields like stock name, q...
I just need a list of employees from Linkedin Recruiter.. I will get in a google-meet or zoom meet with you, and I give instructions. _We need to find the list of 'Open to Work' People from a particular Company in India. The re...Work' People from a particular Company in India. The reason for doing that is, We want to look for employees, who are considering Job switch from this company. _we will together log into your Linkedin Recruiter account _We will look for 'open to work' candidates _we will export the list (around 313 people) in CSV or Excel or PDF format. _If exporting the list is costly, in that case, I will simply take screenshots of the List (of candidates), and will later convert that into excel sheet. **The Task will take maximum of 1...
