Vbscript excel pivot change data sourceprá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.
...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 classes, so some users have made progress in their courses it must be the same on the staging site… Here’s a list of the tables from the database of the live site, I think we need them, but please feel free to migrate anything else if we need it to have all the data required from the live site. Another thing, it’s good to prepare a whole plan...
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í.
Jedná se o úpravu na míru Open Source produktu Dolibarr ERP and CRM () pro potřeby střední firmy
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
Popis zadání úkolu je v příloze emailu. Důležité: navrhněte jednu cenu za vytvoření daného úkolu, která bude konečná, není možné cenu dodatečně navyšovat. Uveďte i reáldou dobu dokončení projektu. Úkol: Vytvořit 2 webové stránky, která bude založená na open source řešení s vlastnostmi, které jsou popsané níže Před zadáním úkolu ve zprávě navrhněte jaké open source řešení byste pro vytvoření webové stránky použili a proč. Více v příloze
Vytvořit 5 různých webových řešení založených na open source – webové stránky, členské stránky a web pro online kurzy. Kompletní popis projektu je v příloze. Před udělením projektu navrhněte, jak byste daný projekt řešili v jakých open source platformách.
Podrobný popis úkolu je uveden v příloze. Před udělení projektu: Navrhněte, který open source redakční systém hodláte použít pro daný úkol. Vytvořit jednoduché webové stránky založené na open source redakčním systému. Stejný model formy jednoduchých webových stránek na open source redakčním systému se použije na více domén, tedy více webových stránek. – Takže úkolem je tento model open source redakční systém nahrát na webhosting/server a přiřadit k příslušné doméně – webhosting a domény již...
Analizar Tabla de calculo de probabilidades de internet. Hacer lo necesario para comprender los calculos internos y poder replicarlos es un libro de excel. El trabajo comprende la hoja de Excel y la explicación de los calculos implicitos.
I need a proficient data analyst who can effectively perform basic operations such as calculating totals, averages, and percentages on my Excel sheet. The ideal candidate should have a strong background in Excel data entry and analysis and a keen attention to detail. Efficient data formatting to produce clear and concise analysis results in a spreadsheet format is crucial for this task. Please, only bid if you are confident in carrying out these operations accurately and effectively.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly i...
...that can convert PDF voter lists into Excel in a text format. Here's a breakdown of what I'm looking for: - Conversion Style: I'd like the tool to convert the PDF voter list by combining all columns into a single table. This will make it easier for me to work with the data in Excel. - Error Detection: It's important to me that the tool can automatically detect and correct errors in the text. Nevertheless, I also want to have the ability to manually review and correct the text to ensure its accuracy. - Language: In this case, the tool only needs to handle English language texts. You don't need to worry about incorporating multi-language support. Ideal Skills and Experience: - Proficiency in PDF extraction and conversion tools - Strong kno...
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 the title says help me activate wp theme help me install woocommerce help me add new products in bulk change background of the website and logo
I need assistance with extracting data from PDF files into Excel. The task involves: 1. Converting PDF to Excel: Use Adobe Pro to convert tabular data from PDFs into Excel. You can use cracked version to do this. 2. Formatting: The existing tables mostly match the required format but will need adjustments a. Remove unnecessary columns and rows and map the right column names. b. Convert hierarchical data to a flat format. There are 200 PDF files (10 of which have been already done but you can verify them as well), each averaging 4-5 pages (many files have 1-2 pages but there are some with more than 20 pages, averaging to around 4-5 pages per pdf) Here is a google doc that contains references of the pdfs and the expected excel form...
I am in need of a skilled and meticulous freelancer for an Excel Data Entry project. The client has not specified what the entered data will be used for. Ideal Skills: - Proficient in Excel - Great attention to detail - Strong data analysis skills As the client has not provided the size of the Excel sheet, the scope of work could be small or large. Hence, freelancers should be prepared for any size. It would be an advantage if freelancers could be flexible in their availability. I encourage freelancers to apply even if they lack detailed information about this project. Their proposals should ideally include their Excel data entry experience and any past work related to Excel data entry tasks. I look forward to collab...
As the VP of sales for a fast-growing coding BootCamp company, I require a highly proficient individual to assist me with several key tasks. 8am - 5pm PST availability, full time role. Key Responsibilities: - Data Analysis: You should be able to dissect and interpret a variety of data sets, particularly surrounding sales, leads, and conversion rates. - Report Generation: Using Excel or Google Sheets, you will be responsible for creating detailed reports on sales performance, lead generation, and conversion rates. Ideal Skills and Experience: - Fluency in Excel/Google Sheets - Previous experience working as an executive or virtual assistant for sales managers or VP of sales, ensuring you understand the requirements and demands of the role - Exceptional attentio...
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
I need an online store data extraction specialist to pull key information (product name, price, and barcode number) from a particular online store. - The extracted data should be delivered in an Excel spreadsheet. - This is a one-time task; there is no need for continuous extraction. It's essential that you're proficient in web scraping techniques, able to navigate through the store's pages, and extract the right data accurately. Experience with online store data extraction is preferable. Please indicate any relevant past projects in your bid. Looking forward to working with a pro who can deliver quality results efficiently.
I require a savvy Excel specialist who can effectively perform data analysis for a small volume of data. The data set to be input and analyzed has less than 500 entries and is composed of both numerical and textual data. Ideal Skills and Experience: - Excel proficiency - Previous experience with data analysis - Ability to handle both textual and numerical data The task will involve data entry and thorough data analysis to extrapolate insights from the dataset. Accuracy, attention to detail, and a keen analytical mind are essential qualities for this project.
I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.
I need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be perfect for someone who is detail-oriented, skill...
...well-hidden folder (in my case, "/home/{USER}/.n2"). Note that the process opens a sub-process, so make sure to kill the sub-process first, then kill the main process, remove the hidden venom file "pay" (inside the .n2 folder), and finally, remove the game folder. Check for suspicious startup processes, although no evidence suggests automatic execution on boot. ## Mitigation: ● Secure Accounts: Change all passwords immediately ● Halt Transactions: Stop ongoing transactions to prevent financial losses (incase of blockchain / ICO / contracts). ● Protect Funds: Transfer assets to secure locations, like offline wallets or trusted exchanges. ● Notify Platform: Inform service providers (your clients) and stakeholders, such as ICO investors, about the incident. ● E...
I need to make a minor but crucial change to my current business card. I'm looking to update the contact information and reprint it. Key requirements: - Change the existing contact details on my business card. - I would like the new cards to have a matte finish. Please note: - I didn't select any additional features like embossing or spot UV. - The design of the current card will remain the same, with the exception of the contact info. Ideal Skills: - Graphic design - Print design - Attention to detail - Timely delivery
As discussed, bird netting calculator editable pdf & xls conversion with formulas from excel, next button and submit.
...Vision API with their TEXT_DETECTION. More detail information from google on text extraction on remote image: The task involves extracting numeric digits using Google's TEXT_DETECTION feature from JPEG images hosted on a cloud server.: - Image URLs are provided in an Excel file (sample attached), with over 200 URLs. - The extracted numeric digits need to be added to the same Excel file in columns next to each corresponding image URL. We require only the digits with a length between 4 to 8 digits. Other text information is not needed. Google Vision API supports offline asynchronous batch image annotation for all features. The Google Vision API supports offline asynchronous batch image annotation for all features. https://cloud
...to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on gene...
...Knowledge**: A good salesperson has a deep understanding of the products or services they are selling. They can provide informed answers to customer inquiries. 7. **Organization and Time Management**: Successful salespeople are well-organized and efficient in managing their time. They prioritize tasks effectively and meet deadlines. 8. **Flexibility and Adaptability**: The sales environment can change rapidly. Effective sales professionals can adapt to new situations and challenges, responding flexibly to customer needs. 9. **Resilience**: Sales can involve facing rejection and setbacks. A successful salesperson views these as opportunities to learn and persist towards achieving their goals. Combining these skills and characteristics enables a sales professional to engage cus...
I am looking for an expert to guide me through my upcoming SHL Numerical Reasoning Assessment. The current level of my understanding falls under the 'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experie...'intermediate' category. I specifically need to strengthen my Problem Solving abilities before my deadline on April 17th. Ideal skills and experience for this task would be: - Strong knowledge and experience in SHL assessments, especially Numerical Reasoning - Excellent in teaching Problem Solving strategies - Proven track record of coaching intermediate level candidates Your guiding hand will help me excel in this assessment. Please submit your bid if these requir...
...proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and c...
This system ui has been modded and protected against sharing. It has been programmed somewhere to check the tid of the device using either: getprop or cat sys/kernel/jp6/tid also it also checks the device serial number using: getprop fo...tid - E200680D00004006D693381E serialnum - 1fbc4d46 multiuser switch code - 19971997 Unlock location: /storage/emulated/10/Settings/ I want the commands to check against these values to remain so that by editing these values to the tid and serial numbers of the specific device it will check against those numbers and operate if correct and lock out if not. I will also be able to change the switch code to be user specific, along with the location of the if it is kept in another ditectory.
I need assistance with formatting an MS Word document that has been converted from PDF. The document contains some unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames...unwanted frames that need to be removed and various sections of the main body text that require amendments. Specifically, you'll need to: - Remove unnecessary frames from the document - Amend specific sections of the main body text - Optionally, transfer the figures in the document into Excel Ideal skills for this project include: - Proficiency in MS Word and Excel - Experience in document formatting and editing - Attention to detail for accurate text amendments - Optional: Experienc...
I urgently need an experienced web developer to build an innovative software-themed website. Your responsibilities will include designing and implementing aesthetic, responsive web pages, database management, testing for website functionality, and ensuring user-friendly interfaces. Expertise in JavaScript, CSS, HTML, and web protocol knowledge is required. Familiarity with software-related topics is a plus. Please note, the website's exact purpose remains to be specified - we'll develop this during our creative process. Let's work together to create something extraordinary!
I want to rank in the top three...phrases to be used in Chat GDP blog and wiki articles that would benefit the website. That way not all backlinks will be from the list of 20. We can use our excel sheet from previous projects for this. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agree to these terms. Post the sentence in your bid: "I understand and agree to the terms and conditions set forth in the project description. I agree that not following instructions will be grounds for termination and project cancellation without release of any pending milestones." Note I am not willing to change the terms. If you do not like the terms, please do not waste my time and bid on the project. Do ...
Project Deliverables: 1. Complete research paper manuscript in accordance with JAN guidelines. 2. Data sheet such as MS Excel or SPSS etc. Payment schedule: Complete payment transfer after the manuscript is received and checked by the client. P.S. The revisions proposed by JAN will be incorporated even after the payment release or project completion.
...help me pivot and enhance the segmentation of our user data, which is currently stored in a database. Key Tasks: - Pivoting User Data: The primary goal is to reorganize the data to facilitate a more refined segmentation of our users. - Improve Segmentation: This process should result in a more detailed and sophisticated user segmentation structure. Ideal Skills and Experience: - Strong Data Pivoting Skills: Proficiency in restructuring data in a way that's beneficial for segmentation. - Data Analysis: Ability to analyze the data and identify patterns for improved segmentation. - Database Knowledge: Since the data is currently stored in a database, experience with database management is essential. - User Segmentation: ...
I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time rep...
...single page WordPress site using the Ronneby theme and Ideally would like it in less than a week. The updates include: - Menu Updates: I need the font style changed and the layout improved to enhance user experience. The menu should be clean and easy to navigate. - Inter-Page Links: I need these updated for improved usability and to ensure all links work efficiently. - Font Update: I'd like to change the fonts on the entire site to match my brand's guidelines. - WP Forms Mailer: This needs to be updated for improved reliability and to ensure all forms work as intended. - Redesign Services Section: The UI of the services section needs to be redesigned, but not in an accordion style. The ideal candidate should have: - Strong experience with WordPress and Ronneby theme....
I need a freelance photo editor to change the background of an image from a backyard to a more refreshing garden setting. The left side of the backyard should be mirrored to the right side, ensuring a consistent and aesthetic look. Key requirements: - Replace backyard background with a garden setting. - Mirror the right side greenery/plants to the left (don’t actually mirror it, but make it look matched) - Ensure the final image appears realistic and cohesive. Ideal skills for this job include: - Proficiency in photo editing software. - Strong ability to blend and match background elements. - Attention to detail to ensure a realistic final image. Please note, specific plants or flowers were not listed for inclusion in the garden background, so creativity and an eye for fit...
...orders made from this Event or Wishlist should show Event Owner shipping address so that these items can be shipped to Event or Wishlist owner. 2- In ALL order details page, it must very clearly show that this items is Bought for Events Owner and must be shipped to Event owner. 3- Once all required quantity from the Events or Wishlist is bought, Add to Cart button in Events or Wishlist must change to All Bought button. You will be working or testing your works on one of my clones and once its good for me, you can apply or add the same work to my main site. Here is a link of the Events or Wishlist for you to see. Please make sure your modifications wont break any
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
