Excel 2010 power programming with vba mr spreadsheets bookshelfprá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.
Zpracování manažerských reportů pomocí POWER BI, analýza zadání, identifikace datových zdrojů, tvorba reportů a dashboardů. Rozsah projektu cca 2 měsíce. U klienta 3 dny v týdnu.
Two years ago, I had a plugin created to calculate the price of pencil printing. After updating the woocommerce, my files were probably overwritten - the price with the print on the product page, in the cart and others is not displayed. You will need a good knowledge of the core of woocommerce and programming Link for example : input quantity 100 - select "potisk předmětu - online kalkulačka" click "zvolte technologii" select "tamponový tisk" click "Upřesněte technologii" select "jednobarevný potisk" click vypočítat cenu potisku ... now see only NaN Kč... Nan - It should be the sum of the price of the products + the price of the print Multiple files need to be modified for functionality
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í.
doing encryption programminng in java
...Náš malý tým BI konzultantů potřebuje posilu. Baví vás: Příprava datových výstupů - např. Excel, Databáze (Couchbase), Power BI Tvorba dashboardů v Power BI - získávání dat z datového úložiště příprava potřebných vizualizací (vyžaduje znalost DAX expressions) A po získání vhledu do problematiky možnost designování dashboardů? Pokud jste odpověděli ano, ozvěte se. Do týdne vám dáme zpětnou vazbu. Pohovor bude probíhat u nás v kanceláři na Malé Straně a k pohovoru budeme vybírat kandidáty: Znalé základních st...
Dobrý den, začínám nový projekt ohledně nabíjecích krytů pro všechny druhy iPhonů. V příloze zasílám fotografii produktu, abyste měli představu, jak produkt vypadá. Co potřebuji, je produkové video. Produktové video, které přesně ukáže, jak produkt funguje a jaké má výhody. Výhody vám napíši, abyste s tím neměli starosti. Toto video se bude používat pro placenou reklamu na sociálních sítích facebook a instagram. Rád bych tedy člověka, který má zkušenosti s natáčením produktů pro reklamní účely. Hezký den.
Nx 10 modeling &programming master cam delcam 10pro
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
...science, business or media informatics or comparable areas with several years of experience in Perl development. Good knowledge in database programming (MySQL) are part of your skill set as well as a basic knowledge of Linux. Ideally you are familiar with the ticketing system OTRS. Moreover, you are a team player with excellent analytic and conceptual skills in combination with good language skills in English and ideally German. What we offer Innovative business model Financially sound company with solid long-term financing Responsibility for your own field of work from day 1 Flat hierarchies, friendly working atmosphere and diverse tasks in a strongly growing company The possibility to choose the technology you want to work with...
Jedná se o společnost věnující se výrobě technologií SLS = laserové sintrování), laicky řečeno 3D tisku pro B2B. Dokážeme vytisknout = vyrobit jakýkoliv tvar bez omezení. Název společnosti je One3D s.r.o., jsme tedy jedineční. Naše výrobky jsou unikátní zakázková - prototypová výroba, vysoké kvality, dodáno v malém časovém rozmezí. Motto společ...jakýkoliv tvar bez omezení. Název společnosti je One3D s.r.o., jsme tedy jedineční. Naše výrobky jsou unikátní zakázková - prototypová výroba, vysoké kvality, dodáno v ...
...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...
Hledáme člověka na MEDIA RELATIONS. Pracujeme teď na úplně novém, inovativním online projektu, který by měl významným způsobem zasáhnout do hledání bydlení v ČR. A hledáme člověka, který nám pomůže ...online projektu, který by měl významným způsobem zasáhnout do hledání bydlení v ČR. A hledáme člověka, který nám pomůže zbořit mediální prostor a vytáhnout naši službu na výsluní. Vykopnutí plánujeme nejdřív za měsíc, ale už teď hledáme člověka, který nám pomůže, naplánuje a zaštítí vykopnutí v medi&i...
...experience by integrating flight and hotel booking functionality. A freelancer with expert-level knowledge in API integration, specifically with , or is required to: - Ensure flawless integration of both flight and hotel booking features from Amadeus / API. - Set up the system to display and process real-time flight information and booking. - Seamlessly incorporate hotel information and booking functionality. The ideal candidate will bring their previous experience with API integration, preferably in the travel industry, to tackle the complexities of our project. Ultimately, our goal is to deliver an upgraded travel website that affords our users an effortless booking experience. Programming language for backend: Java Front end: JavaScript, JQuery or re...
I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.
As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you ha...
I'm looking for a talented freelancer with specialized experience in Schneider Electric product lines, particularly Ecostruxure Building Operation (A/C) and Ecostruxure Security Expert. Key responsibilities include: - Programming: Your primary task will involve programming for our Ecostruxure Building Operation project. - Graphics Design: You'll also need to work on the graphical elements for the project. - System Integration: Your expertise in system integration will be crucial for a successful project completion. While I skipped the specific programming languages/tools in the questionnaire, please note that proficiency in relevant software tools and languages for building automation projects will be essential. Ideal Skills and Experience: - Exper...
I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.
...models in Coppeliasim - Proficient in programming languages required for the task, particularly Python and lua - Write efficient control code for the robotic arms - Identify, troubleshoot, and fix any simulation errors that may arise Ideal candidates should have: - Proven experience in working with Coppeliasim - Proficiency in Python and lua - Strong understanding of robotic arms and their control mechanisms - Ability to troubleshoot and resolve simulation errors quickly - Excellent problem-solving skills and attention to detail. Your expertise will be crucial in the success of this project, and I welcome your input in optimizing the robotic arms simulation and control. If you have a keen eye for detail and are excited about the prospect of working with robotic ar...
I need a proficient...a proficient software developer to build an offline multiple-choice question (MCQ) exam software compatible with Windows operating system. The primary purpose of this software is to conduct exams for learning institutions. Key Features Required: - The software should have a score tracking feature that effectively keeps track of students' exam progress and results. Ideal Candidate: The perfect match for this job should have substantial experience in software development, particularly in developing educational tools. An extensive understanding of the Windows operating system is crucial. Proficiency in programming languages like Java, Python or C# would be beneficial. Familiarity with creating scoring algorithms and a good grasp of user-interf...
I'm seeking a proficient freelancer to model a battery energy storage system using MATLAB/Simulink. The system is intended to serve as a backup power supply for a large industrial facility. Key Project Details: - Intended Use: The primary function of the battery energy storage system is to serve as a reliable backup power source. - Scale: I'm looking for a model that's specifically tailored for a large industrial facility. This involves understanding the energy consumption patterns of such an environment and designing a system that adequately meets the facility's energy needs during power outages. - Software Preference: Due to the complexity of the project, the ideal candidate should have a strong background in MATLAB/Simulink. This tool is essen...
I'm looking for an expert in Excel data entry to assist me with a project. The job primarily involves: - Text data entry: Entering textual information into Excel. Accuracy is crucial, as even minor errors can greatly affect the output. - Data categorization: Organizing the entered data into different categories within the sheet. The ability to understand and sort data effectively is key. - Basic data visualization: I'd like the data to be presented visually. The freelancer should be able to create and include simple charts or graphs to represent the categorized data effectively. Ideal Skills: - Proficiency in Excel: A deep understanding of Excel and its functions is essential. - Data Entry: Previous experience in data entry is highly preferred....
I'm in need of a skilled WordPress developer who can address the issues on our website that have arisen after recent updates. Key Responsibilities: - Fixing bugs and issues that have appeared post updates - Addressing any programming needs for new pages I'm seeking a freelancer who's well-versed in: - WordPress - Elementor Ideally, you have experience in troubleshooting and fixing errors that may arise from plugin or theme compatibility issues. Your familiarity with the backup and programming of our website is crucial. Your ability to address these issues in a timely manner is highly appreciated.
I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.
I am currently facing an issue with the packaging of my Streamlit app, specifically error messages related to dependencies. My app does RAG or Retrieval Augmented Generation. However, I am stuck with this bug. Any freelancer planning to undertake this project should be: - Skilled in Python programming - Familiar with Packaging methodologies like PyInstaller, PyIodide, Stlite - Experienced in debugging dependency issues The main tasks will include: - Understand existing errors in the packaging process - Debug the dependency-related issues - Ensure the final version of the packaged app works seamlessly with no errors in multiple hosts I invite freelancers with prior experience in handling similar tasks to place their bids. This project has the p...
...problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protecti...
I need a meticulous freelancer to help with my data entry task. The specific requirements are as follows: - The primary task is entering textual information from scanned documents into an Excel sheet. This includes typing out the text exactly as it appears on the scanned document. Applicants should have: - Proficiency in data entry, especially text-based information - A keen eye for detail and accuracy - Experience working with scanned documents - Proficiency with Excel This is a straightforward project, but attention to detail is crucial. I will provide the scanned documents, and I expect the data to be entered accurately and efficiently.
I'm seeking a skilled Java developer to work on an action game project that I need completed as soon as possible. - The project involves game development in Java, focused on creating an immersive action game. - The game needs to be optimized for the PC platform, ensuring seamless performance and user experience. The ideal candidate will have: - Strong Java programming skills - Experience in game development - Ability to deliver quality work under tight deadlines Please share your relevant experience, and provide insight into your approach for this project.
I need a tech-savvy freelancer to create a custom thank you page for my WooCommerce website. The page should have a particular focus on: - Presenting order details effectively. These details must be displayed within a detailed table, allowing for a comprehensive overview of the purchase made. Ideal skills and experience: - Experience in programming and website development. - Familiarity with WooCommerce and creating custom pages. - A knack for clean, efficient code and attention to detail. - Knowledge in creating user-friendly, intuitive layouts and designs. Please note the client has opted not to include any interactive elements within the detailed table on the thank you page. Therefore, ensuring factual accuracy and perfect presentation of order details is paramount.
...3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software Development: Prior experience in developing CAD software, particularl...
Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in condition...
I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if...
More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is
I have some data that requires entry from spreadsheets into a database. I specifically need: - A meticulous professional who understands the importance of data accuracy. - Someone who can efficiently convert the data on these spreadsheets into a structured format suitable for database management. Your responsibilities include: - Transferring data from spreadsheets into our database system while ensuring data integrity. - Performing data cleaning and verification to maintain high quality and accuracy. Ideal candidates will possess: - A proven track record in data entry, especially from spreadsheets. - Experience with database management and understanding of data cleaning and verification. - Strong attention to detail and ability to deliver high-qual...
I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.
I am in need of an experienced LabVIEW ...purposes. TASKS INCLUDE: - Developing and implementing a robust data acquisition system in LabVIEW to monitor signal frequency. - Designing and deploying control systems. - Regular monitoring and analysis of collected data. RECOMMENDED SKILLS: - Prior experience with LabVIEW programming is essential. - Expertise in the creation and usage of data acquisition and control systems. - Knowledgeable in signal frequency monitoring and analysis. - Solid background in automation and process control. My ideal candidate is detail-oriented with a strong understanding of LabVIEW, particularly in the context of signal frequency data collection and monitoring. It would be beneficial if you have worked on similar projects in the past. I l...
... Specific Features: • Real-time scanning: The antivirus software should continuously check on the system files to detect/deal with threats promptly. • Firewall Features: An inclusive firewall feature aimed at facilitating additional system protection. Ideal Skills/Experience: • Extensive experience in antivirus application development, specifically for Windows OS. - Expertise in Windows Kernel Driver Development. - Proficiency in high-level programming with C++/C/C#/Qt, Java, and Python. - Developing apps in C/C++/C#/Qt - In-depth knowledge of low-level operations with X86/ARM Assembly Language. • Knowledge in system security and safe programming practices. • Demonstrated ability to meet tight project deadline...
I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable for this project.
