Difference between macro and vba code in excelprá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.
...live site, the users purchases a woocommerce product to enrol in a course created in LearnDash… the products and courses are linked together by custom plugin… the custom pugin is migrated to the staging site and all functionalities working… when we started the development on the staging site, we duplicated the live site and restore it in the staging site, the development took 4 months, so in the last 4 months we don’t have the data on the staging site. That’s what we need to now migrate from LIVE to STAGING. We need to migrate Users, Users metadata, WooCommerce Orders, and anything related to users, and we need to migrate the learndash data which is the LMS plugin, and we have online ...
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.
We run an app that needs a new FE in React or Vue.js The new UX has been prepared including a styleguide in Adobe XD. We are using REST API between FE and BE. We will be doing BE with our own team. We estimate this to 20-30 MD, about 200 hours. We will not consider any offers until we can review your code. Then we will provide access to the current application, user manuals and access to the new UX to prepare your estimate. We prefer someone for full time, but you can do this as a side job, however we expect 20h/week as a minimum commitment.
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í.
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
Mám 2 programy (kódy pro mikroprocesor STELLARIS) a potřeboval bych jejich jednoduchou úpravu, podle zadání. Více info pošlu do zprávy.
Mám 3 programy (kódy pro mikroprocesor STELLARIS) a potřeboval bych jejich jednoduchou úpravu, podle zadání. Více info pošlu do zprávy.
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
I want few methods from objective c to java to be translated.
...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...
I'm seeking an expert who can assist me with the configuration of Zapier, to automate email to new leads acquired from Facebook. Here's what I need: - Configure Zapier to connect Facebook with Outlook. - The automated email should contain a collaboration proposal. - The focus of collaboration i...Zapier, to automate email to new leads acquired from Facebook. Here's what I need: - Configure Zapier to connect Facebook with Outlook. - The automated email should contain a collaboration proposal. - The focus of collaboration is specifically on business development. Ideal candidate should be proficient with Zapier, familiar with setting up workflows between Facebook and Outlook, and understanding of email marketing. Prior experience in setting simi...
... CSS, and JavaScript. While it functions perfectly on my local machine, I encounter issues once I upload it to the server. The server in question is hosted on Hostinger. I'm unsure if any changes have been made to the server configuration file. Key Points: - Troubleshoot the server upload issue - Resolve discrepancies between local and online versions - Clarify if server configuration files have been altered - Ensure the webpage functions as intended on the server Ideal Freelancer: - Experienced in HTML, CSS, and JavaScript - Proficient in server hosting with Hostinger - Skilled in server configuration file troubleshooting - Capable of identifying and correcting server-side programming discrepancies I'm seeking...
When importing customers via CSV file in ASTPP version 6.0, both postpaid and prepaid customers balance always uploads 0. The task is to find the corresponding php file/path on the server and correct it, so that the balance uploads correctly when uploading the customers on the ASTPP both for prepaid and postpaid customers. Positive balance must upload as positive balance. Negative balance must upload correspondingly. 0 uploads 0. You need to make a detailed document how to do that on any ASTPP server, so that someone without technical knowledge takes the document, follows it and gets the same working on the other ASTPP server. Example of the document: Someone from our side will try to upload customers on the provided server to make
As an online retailer, I need my Shopify store revamped to differentiate between products available for sale in Europe and other parts of the world. This system should work based on shipping restrictions, which I'll provide. Additional details: - Create clear and separate sections for products available in Europe and the rest of the world. - Organize with shipping restrictions in mind. - The system for product display within these sections isn't decided yet. Open to suggestions. Ideal freelancers for this task would be well-versed in Shopify and have experience in site organization and region-specific product differentiation. Familiarity with shipping regulations worldwide would be advantageous.
I need a pro...primary purpose of this conversion is to share the document with my collaborators who use Word exclusively. The document contains integrated tables, graphs, and images. Not all of them have to be editable in the Word format. The freelancer must ensure that: - The converted Word document maintains the same formatting as the Google document. - Some tables, graphs, and images are editable as per my instructions, while the rest remain static. Ideal freelancers for this job would possess the following skills and experience: - Proficiency in Microsoft Word and Google Docs. - Abilities in discerning between editable and non-editable elements in a document. - Attention to detail to keep the formatting intact...
so i have selfhosted this and i need something like this in between u just need to change style/css of radio form to look something like that package image
...reviews and generates a concise summary, encapsulating the main points in 300 words in multiple bullet points. Key Functions: - Extract data from a relational database via SQL queries. - The ability to process and analyze reviews from different platforms such as blogs, social media, and online stores. - Generate a coherent 300-word summary from a multitude of reviews. Required Skills and Experience: - Expert level understanding of Python programming. - Knowledge and experience in SQL querying is a necessity. - Experience with Natural Language Processing for summarization. - Familiarity in dealing with relational databases. - Prior experience with text summarization or related projects is a definite advantage. The task ...
I'm in need of a professional who can review and optimize my .net Core 6 codebase, enhance the software architecture, and bolster the database security. Key Responsibilities: - Conduct a comprehensive code review to identify inefficiencies, bugs, and areas for improvement in the .net Core 6 code. - Improve software architecture to ensure scalability, maintainability, and performance of the application. - Implement robust measures to enhance the database security, in line with industry best practices. Ideal Skills and Experience: - Extensive experience in .net Core 6 and Entity Framework. - Proven track record of conducting code reviews and optimizing codebases. - Expertise in so...
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 have documents that need to run code on Stata and need a proficient code writer. I will pay $400 for the contract
...sophisticated and elegant video flyer. Key Project Details: - Purpose: The primary goal of this video flyer is to announce an upcoming event with a sense of exclusivity and elegance. - Target Audience: The target demographic for this video is young adults, specifically between the ages of 18 to 30 years old. - Style: The video should exude sophistication and elegance, capturing the essence of the event in a refined manner. Ideal Skills and Experience: - Proficiency in video editing software. - Previous experience in creating promotional videos, particularly for events. - A keen eye for aesthetics and ability to deliver a sophisticated and elegant visual style. - Understanding of the preferences and tastes ...
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 looking for a skilled social media marketer with a proven track record in managing and optimizing Facebook ads campaign. The main objective of the campaign is to drive traffic to product pages on my website. Key Responsibilities: - Conceptualize and design engaging and compelling Facebook ads suitable for a young demographic aged between 18-24 - Continuously monitor, analyze and optimize the ads for maximum website traffic The ideal candidate should have: - Extensive experience in designing and managing Facebook Ads campaigns - A clear understanding of the interests and behavior of the youth demographic - Proven ability to drive website traffic through these campaigns.
I'm in need of a skilled professional to create a No-Code app on the Adilo platform or any other. It shall has three interface. 1. User Interface 2. Management Interface 3. Service Provider Interface App Idea: Chat based profile matching for Carpenters to work on hourly basis. User Interface Step 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, Pr...
...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 developed with necessary ...
I have a 3D dress designed in Clo3D and require a skilled 3D artist to square (retopologize) it for use in Blender. The final model will be utilized in a virtual fashion show, so it needs to be of high quality. Key Tasks: - Retopologize the 3D dress from Clo3D to Blender - Ensure the model is appropriately squared for optimal use in Blender Ideal Skills and Experience: - Proficiency in 3D modeling and retopology, particularly in Blender - Experience working with Clo3D and Unity - A portfolio showcasing similar projects in the virtual fashion, or gaming industry The successful freelancer will be able to strike a balance between efficiency and quality, delivering a squared 3D dress with high-resol...
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 t...
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 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 10-15 minute time. Re...
We are seeking a dedicated individual to assist in finding accurate answers to questions through Google search. The project aims to provide reliable information sourced from reputable websites such as Wikipedia, nursing educational websites, or general educational websites. Scope of Work: Task Description: The hired individual will be responsible for conducting Google searches to find answers to a set of questions provided by the client. Quantity of Questions: Currently, there are between 250-500 questions available for research. For the first 500 questions completed, the payment will be 1 AUD along with a 5-star rating. Upon completion of the first batch, there will be another 500 questions with an additional payment of 1 AUD and a 5-star rating. Total Number of Qu...
I have a project that involves the entry of data from Excel into a new system. The data entries are in Excel format, and I estimate the total number of entries required to be between 100-500. The task will involve a mix of text and numeric data. Ideal Skills: - Proficiency in Excel - Strong attention to detail - Efficient, accurate data entry - Previous experience with data entry projects of similar scale This is a straightforward task that requires someone who can work accurately and efficiently. Meeting the estimated entry count and maintaining data quality are key.
I need a well-versed writer who can deliver 11 original articles centered on LED display technology. These articles should be SEO optimized and should not be machine-generated. They will total approximately 15,000 words. Key topics to discuss: - Technical specifications of LED displays These articles are targeting readers with some knowledge on LED displays. Hence, the writing style should be semi-technical, striking a balance between in-depth details and general information. Ideal skills: - Proven experience in tech writing, preferably on LED technology - Excellent SEO writing skills - Unique content creation that can pass AI detection - Ability to communicate semi-technical information effectively.
...professional who can help me raise funds for a critical cause. We need to find a way to escape from Gaza, and your expertise in fundraising will be crucial. Key Tasks: - Develop a fundraising campaign: Your main responsibility will be to create an engaging and effective fundraising campaign. This campaign should be tailored specifically for individual donors. - Implement direct donation strategy: I'm looking for someone who can help me to manage the direct donation process. This could include setting up secure and reliable donation channels, and providing support for potential donors. Ideal Skills: - Proficiency in fundraising: You should have a strong background in fundraising, preferably in the humanitarian sector. - Und...
Need an extremely competent financial modeler in Excel who is capable of working with a lot of date math in formulas. You need to work on a working model template. NOTE: Do not apply if you are not genuinely capable of working with complex models. I am looking for help because I'm busy, not because I'm not capable! I make huge financial model templates on topics people don't model. I made a model on "ESOP" (Ownership structures for startups). ISSUE A client input dates in a way I didn't test and I realized I built in circular references I wasn't aware of. TASK Remove circular references (Need to change logic a bit to do it, which is not simple) Ideally break test to see how I messed up date math when dates are...
I require a specialist in running code that is based on AI/ML, specifically ResNet MobileNet, and other nature-inspired algorithms on my Windows laptop. The expertise required: - Extensive experience with Python, the programming language the code is written in. - Robust knowledge in machine learning and AI. - Familiarity and experience with Windows OS and optimization thereof for machine learning code execution. - Understanding of Predictive modelling, the primary outcome goal of the code. The goal of this project is to have the code successfully run and produce the expected Predictive modeling results. Be prepared for minor troubleshooting and optimization to make that happen within the Win...
I am in need of a robust and efficient inventory management system made in Excel. This project requires: - Tracking of product quantities and managing stock levels to ensure seamless operation - Cataloguing of each product's relevant information including its name, SKU/Part number, quantity, batch number and expiry date - Methods of updating system quantities should be manual entry and bar code scanning. Knowledge in these methods is required. Ideal candidates should have extensive experience in Excel and inventory management system creation, preferably with a sound understanding of retail or related sectors. They should also be adept at implementing bar code scanning into Excel syste...
...network in real time, ensuring interactive connectivity. - Private Messaging: Ensuring secure conversations between users. - Profile Customization: Allowing users to modify their profiles reflecting different characteristics and interests. - Request Management: Facilitators for creating, sending, receiving, and responding to requests for activities to ensure accurate matches and dynamic user interaction. The ideal developers should have comprehensive knowledge and proven experience in native languages for either or both platforms. Experience in developing interactive social networking applications is a must. Demonstrated ability to integrate robust functional features into the app will be highly viewed. Expertise in ensuri...
...Python developer to write a code for an Explainable AI project. I need the code to focus on making the AI understandable by humans, rather than just predicting outcomes. Key Responsibilities: - Create a Python script that implements Explainable AI techniques like Lime - Ensure the code is clean, well-commented, and efficient Your role will be crucial in enabling the AI to present its decisions and reasoning in a way that can be easily understood by non-experts. Notably, the model should be able to show its decision rationale, thus improving trust and interpretability to end-users or stakeholders. Ideal Skills and Experience: - Proficiency in Python - Experience in AI/ML particularly in Explainable AI ...
...looking for an Excel expert able to implement drop downs and inter sheet connections to manage my business ledger and stock updates on a weekly basis. Here are the project specifications: * There are currently less than 5 Excel sheets that need to be interconnected. * The primary intent of this interconnection is the cross-referencing of information. * The exchange of data to be implemented includes Inventory data, Financial data, and Sales data. The ideal candidate should possess advanced Excel skills, including knowledge and experience in cross-referencing various types of data across multiple sheets. Familiarity with business inventory, financials, and sales data is highly desirable. Please ensure your bid reflects...
Title: Sales Representative Specializing in the Meat Industry in UAE Location: Remote, UAE Job Type: Freelance with a potential for full-time engagement Description: We are seeking an experienced Sales Representative with expertise in the Meat Industry, specifically within the UAE market. Your role will involve intensive market research and lead generation, focusing on the importation and distribution of chilled lamb from Australia, Kenya, and South Africa. Responsibilities: Conduct thorough market research to identify and analyze the prices and competitors within the UAE meat market. Identify and reach out to at least 40 potential suppliers, including wholesalers and importers, to obtain competitive quotes on chill...
I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.
...looking for a proficient Android developer to create a user-friendly app for both our property owners and customers. Key Features: - Property Search: The app should provide an effective way for customers to search for properties based on various criteria. - Communication: A built-in feature to enable direct contact between customers and property owners. - Property Wishlist: A functionality that allows customers to save their preferred properties for easy access. Ideal Candidate: - Expertise in Android app development. - An understanding of the real estate industry or has developed similar applications will be a plus. - Excellent UI/UX design skills to ensure customer-friendly navigation. In summary, we need an app that seamlessly connect...
I'm seeking a mechanical design engineer with a background in material selection, mechanical system design, and safety and reliability analysis. The project revolves around designing a screw conveyor. This includes: - A comprehensive understanding and execution of both aspects of machine design mentioned above, coupled with proficiency in creating a Bill of Materials (BOM) that also includes an estimate. - The screw conveyor design must be medium-sized with a capacity between 1-10 tons/hour. Please note, experience in conveyor system design is vital. Eligible freelancers should demonstrate their ability to design reliable and efficient mechanisms that prioritize safety. A strong track record in similar projects will sign...
In my pursuit to propel the recognition of my brand to new heights, I'm seeking an innovative and experienced advertising expert. Objective: - The core aim of this project is to bolster the brand's recognition among working professionals aged between 25 and 50. Target Audience: - The focal point of our advertising will be working professionals aged 25-50, assuring that our brand resonates with them and aligns with their preferences. Medium: - We will majorly utilize online platforms for our campaign, including but not limited to social media channels and various websites relevant to our target demographic. Ideal skills for this role: - Strong understanding of brand positioning and strategy - Proven experience in digital...
