Tidy vba excel clean codeprá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.
..._statistic wp_learndash_pro_quiz_statistic_ref wp_learndash_pro_quiz_template wp_learndash_pro_quiz_toplist wp_learndash_user_activity wp_learndash_user_activity_meta wp_usermeta wp_users wp_wc_customer_lookup wp_wc_order_stats wp_woocommerce_order_itemmeta wp_woocommerce_order_items We migrated the site using a plugin, I created a backup using WP All in One WP migration, and restored it on a clean WordPress installation, that's how I created the staging site. The migration was made to change the theme and keep all functionalities. The live site has a custom made theme built by old developers who built as well the custom plugin connected with LearnDash and WooCommerce. We installed Divi theme of the staging site and rebuilt the whole website, we changed some plugins but mai...
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.
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.
Instalace šablony: (koupeno, připraveno k instalaci) Instalace modulu: (koupeno, připraveno k instalaci) Zobrazení výrobce a m.j. v detailu produktu a v quick view Help desk service: - pomoci vytvořit menu (který modul, jak editovat?) - dostat články - texty na home page - na HP je málo textu - upravit copy right v patičce na © 2015 Kopecký CZ, s.r.o. na svobodném SW PrestaShop™ - změnit v ccs cca 50% červených prvků webu na tmavě zelenou z loga (?) - prozatímně schovat výběr jazykových mutací - ostatní cca 4 hodiny Následně: Instalace šablony pro 2. eShop: (koupeno, připraveno k instalaci)
Instalace šablony: (koupeno, připraveno k instalaci) Instalace modulu: (koupeno, připraveno k instalaci) Zobrazení výrobce a m.j. v detailu produktu a v quick view Help desk service: - pomoci vytvořit menu (který modul, jak editovat?) - dostat články - texty na home page - na HP je málo textu - upravit copy right v patičce na © 2015 Kopecký CZ, s.r.o. na svobodném SW PrestaShop™ - změnit v ccs cca 50% červených prvků webu na tmavě zelenou z loga (?) - prozatímně schovat výběr jazykových mutací - ostatní cca 4 hodiny Následně: Instalace šablony pro 2. eShop: (koupeno, připraveno k instalaci)
...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 looking for coding of template for QuickCart. This template: template pay in "clean html" and pass the coding for QuickCart 6.2Alternatively. The result is a template for QuickCart 6.2 You can offer a similar custom template. Thank you for your offer and I apologize for my English
Details are provided in the attached files. Please read them all!
...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I require a proficient WPF developer to design and create a user-friendly desktop application with the functionality and design, on par with that of Visual Studio. My project would need your expertise in: - Data Binding: Connecting the software to a database for efficient processing and managing of information. - UI Design: As Visual Studio served as inspiration, the application must have a clean, intuitive user interface, prioritizing user experience. - Navigation and Control: Implement a logical, coherent system to smoothly navigate around the application. The ideal candidate should have experience developing desktop applications, data visualization tools, and creating user-friendly interfaces, particularly in WPF. Familiarity with Visual Studio's design is a plus.
I'm in need of a modern shirt design for my excavating company. - Key Requirement: The design should prominently feature the company name. - Style: Modern, with a focus on minimalistic and clean aesthetics. I'm open to other ideas, the shirt doesn't have to be that specific style. - Deadline: I require this project to be completed ASAP. I'm looking for a freelancer with a strong portfolio showcasing modern and minimalistic designs. Experience in creating corporate or industrial-themed designs would be a definite plus. The ideal candidate should be able to deliver a high-quality design in a short timeframe. I want this to be a high quality design with lots of thought. I want it to look like a well known brand. Not just another contractor with excavators on th...
...looking to update the software's aesthetic with a fresh, modern color palette. The colors should be easy on the eyes and enhance user experience. - Improving typography: The new design should feature refined typography that is both visually appealing and easy to read. This will help to give the software a more polished and professional look. Experience in software design and an eye for modern, clean aesthetics is a must. Previous experience working with JavaScript and Angular is preferred as the software is built using these technologies. A strong understanding of UX principles is also desirable. Your role will be to take the existing program and enhance its design elements, focusing on the color scheme and typography. I'm looking for someone who can bring creativit...
Hello, I have a dating app that was developed 4 years ago and is published on Google Play. It was made in JAVA, but now the version is depreciated on the market. What I want for this app is to rewrite the code using Kotlin or Flutter, because this app was made in Java 4 years ago. Within the app it has many functions. Apply for this project and tell me the price at which you would do it. and The estimated time. - Implement in the app (Membership - payment plan with Google)
My WordPress website is redirecting to unknown sites and showing signs of injected Javascript. I've experienced this issue despite keeping my WordPress and plugins up to date. Key Requirements: - Identify the malware and its entry point - Remove all malware and traces of injected Javascript - Restore website to its original, clean state - Provide recommendations to prevent future attacks I have full access to my website's hosting environment. Ideal candidates should have proven experience in malware removal for WordPress sites and possess a strong understanding of web security best practices. Please share your approach and experience in your bid.
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
I'm looking for a skilled graphic designer who can create a minimalist logo for my candle company, "Daniel's Candles". This business is deeply personal to me as it is in honour of my son, Daniel, who was stillborn. The design should be simple and elegant, primarily featuring neutral colors, specifically gray, white, and beige. Key Requirements: - Minimalist Style: I envision a clean and uncluttered design that conveys the essence of my brand in a simple, yet impactful manner. - Neutral Color Palette: The logo should primarily incorporate gray, white, and beige, reflecting a sense of calm, serenity, and purity. - Symbolism of Stars: I would like the logo to include stars, which hold a special significance for me in remembering my son. The stars should be integra...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...
Need a solution A barcode app to print and track our inventory. (Barcode&QR desirable)Online - Webbased. ProductCode/SupplierCode/Category/SubCategory/Batch/Colour/Size/Expiry/Selling PriceA/X/X/X/X/X/XX/XX/XXXX/XXXXXX.00Item description must print on the lable More details: We wish to use this app to count our inventory using bar code scanners Also when items are placed in a box to transfer between two shops, we need it to be able to use the scanner and count accuracy. Is this project for business or personal use? For an existing business What information should successful freelancers include in their application? Experience How soon do you need your project completed? ASAP
I'm in need of a skilled UI/UX designer who can use Figma to redesign my current app. Here's a little more detail about what I'm looking for: ...specific layouts in mind that I'd like you to integrate into the new design. I will provide those examples of other apps and drawings to you. I will also give you access to the current assets we have for our mobile and desktop app now in Figma. The ideal candidate for this project would have: - Expertise in UI/UX design for both iOS and Android - Proficiency in Figma - A portfolio showcasing sleek, clean, and intuitive mobile app designs - Experience in advanced app design would be a plus I'd love to see how you can turn my vision into a visually appealing and user-friendly reality. I believe I need 9 screens fo...
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
I need a comprehensive HTML/CSS solution for my report pages. it must be clean code with easy names class and id's not generated with ai Key Requirements: 5 pdf files not just this one . - Create inputs: I'm in need of a web developer to build inputs that can be used to create a real report. - Input types: The report inputs should include text, number, and date inputs, as well as checkboxes and tables. - Layout: The layout of the report pages should be exactly as shown in the sample page I will provide. Ideal skills for this job include: - Proficiency in HTML, CSS, and JavaScript. - Experience with form creation and layout design. - Attention to detail to ensure the layout is replicated accurately. i have x5 reports needed to be done not just this 3
...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...
...Agent Directory: A directory showcasing our team of experienced real estate agents. About Us: A page outlining our company's mission, values, and team expertise. Blog (optional): A blog section with informative articles related to the real estate market, home buying/selling tips, and local community updates (optional). Design Requirements Modern and User-Friendly: The design should be modern, clean, and user-friendly, providing a seamless browsing experience for visitors. Responsive Design: The website should be fully responsive and optimized for all devices (desktops, tablets, and smartphones). High-Quality Visuals: The use of high-quality property photos and visuals is essential to showcase properties in the best light. Branding Consistency: The design should be consiste...
I'm looking for a talented graphic designer to create a modern and minimalistic design for a set of scripture cards. These cards will be used as gifts for friends and family, so I'm aiming for a design that is simple and elegant. Key Requirements: - Modern and minimalistic design: The style of the cards should be clean, contemporary, and uncluttered. - Experience with typography: Prior experience with text design would be highly advantageous. - Understanding of gifting culture: A keen understanding of what makes a gift special in the eyes of the receiver, and how design can contribute to that, will be a big plus. Deliverables: I'm open to suggestions on the format for the scripture cards. I'm looking for your expertise on the most suitable format for these kind...
I'm seeking a skilled microcontroller programmer for translating our control strategy into a code compatible with a dsPIC microcontroller. This code should be able to handle inputs of both voltage and current. The key features of this project include: 1. Control Strategy: Implementing a Proportional-Integral (PI) controller into the dsPIC microcontroller. 2. Input signals of the system include voltage and current. Being proficient in handling such systems is paramount. 3. Beyond written code, you should provide thoughtful documentation and comments so we can understand your strategies and algorithms. I am not specific about setpoints for voltage and current, so the approach should be adaptable. Ideal freelancers should possess the following skills and experienc...
...successfully at the other end without being flagged as PROXY IP users. Currently, we utilize web proxies, primarily residential proxies, for various purposes. However, we encounter frequent failures when the receiving system identifies our requests as originating from PROXY IPs. Challenges: 1. IP Score Impact: We’ve observed that IP scores play a significant role in request success. While requests from CLEAN or LOW Spam Score IP addresses often pass, those from HIGH SPAM score IPs face rejection. 2. Recognition as PROXY IP: Our solution must not only allow requests to pass but also prevent them from being recognized as PROXY IPs by the recipient system. Project Objectives: 1. Effective IP Masking: Develop a solution that effectively conceals our original IP address during r...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...
...project's interface. Your primary tasks will include: - Enhancing the overall visual design of the interface, keeping in mind the latest design trends. - Improving the navigation to ensure a smooth and intuitive user experience. - Streamlining the dashboard layout to make it more user-friendly and efficient. Incorporating a Modern, Minimalist, Vibrant, and Colorful design is essential. It should be clean and professional, to achieve a visually appealing, yet functional interface. You will also be required to implement Data visualization and analytics features to our dashboard. This requires a good understanding of how to visually represent complex data in a clear and understandable manner. Ideal skills and experience for this job include: - Proficient in React and UI/...
In our wordpress website we get a redirect to a spam website. Hope someone can help us now.
I'm launching a new tech business called PASIF and I'm in need of a logo that truly encapsulates my brand's essence. Similar to the one attached, I would like to have a similar design and colour just with the monolines been in the shape of a P instead of a T. Key Requirements: - The logo should be modern and minimalist in style. I envision a clean and sleek design that speaks to the cutting-edge nature of the technology sector. - I strongly prefer cool tones, particularly blues and greens, though other colors that convey a sense of innovation and professionalism would also be considered. I'm looking for a skilled and experienced graphic designer who has a solid track record of creating logos for technology brands. A strong portfolio showcasing modern, minimal...
...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...
...for MetaMatch, a cutting-edge betting platform that integrates real-world sports events with blockchain technology. This project will involve designing the user interface from scratch on Figma, focusing on incorporating web3 features such as cryptocurrency wallet integration and web3 registration. Drawing inspiration from Sorare and notable Figma community files, the goal is to design a modern, clean interface with a gaming visual that supports the functionality of a betting app. This interface should ensure a seamless and engaging user experience for blockchain enthusiasts, accommodating the buying, management, and trading of NFTs, as well as providing detailed fighter statistics. Specific Requirements: - Web3 Features: Design must integrate blockchain-specific elements such a...
I need a logo and a set of 3 icons for the website. Style: The design should be in white and red and have a serious, modern, and confident style. I aim for a professional look, so please don't use comic-like or cheesy elements. The icons should be simple, clean, and sharp, aligning with the overall design. The image should consist of the logo itself and the website title. Details will be given later in private messages. Image size: width 289px height 100px. Image format: .png Additionally, I need 3 icons in the same style. Icon size on the website will be 50*50px. Icon format: .png
We are looking for a freelancer with strong web scraping experience for an exciting and challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of HTML, C...
...sleek, minimalist packaging for our screen wipes. The packaging should be designed to box dimensions of 6.3 x 2.5 x 5.2 cm. Key Requirements: - The preferred color scheme for the packaging should predominantly be white with the option to use up to 3 additional colors. Black/Grey's may be used but not be the dominant. - The main design element should revolve around the product's purpose which is to clean screens of electronic devices like phones, laptops, and tablets. - Visual elements you should incorporate are images of electronic devices and screens or screen icons. Ideal Skills: - Proficiency in packaging design, particularly for small boxes. - Strong grasp of minimalist design principles. - Experience in creating visually appealing designs for electronic products....
