Vba macro count sheet työt
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
...the Qr code - Each scanned QR code will be recorded in the database along with the timestamp. - The application will maintain a count of how many times each unique QR code is scanned. 2. Barcode Scanning (Y Person): - Y person will have the ability to scan barcodes of outer cartons using their mobile device's camera. - Each scanned barcode will be linked with the corresponding QR code in the database. - The application will generate reports based on the QR codes linked with the scanned barcodes, providing insights into the frequency of scans for each QR code. 4. Reporting: - The application will generate reports that display: - Total count of scans for each unique QR code. - Frequency of scans for each unique QR code over a specified time p...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
...talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Featu...
I require assistance with building financial reports specifically targeting balance sheets within SAGE Intacct. The perfect freelancer for this project would possess the following skills and experience: - Deep understanding of SAGE Intacct software, - Proficiency in designing financial reports, - Solid knowledge in standard balance sheets creation. The final product should be a standard balance sheet report that can integrate seamlessly into my workflow. Individuals with keen attention to detail are highly preferred.
As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...
I am seeking an experienced academic editor to thoroughly review and revise my social work PhD dissertation. The word count exceeds 25,000 words, so meticulous attention to detail is crucial. Key Tasks: - Detailed editing and restructuring where necessary - Intensive focus on the Literature Review section - Maintain proper academic formatting and citation style Ideal Freelancer: - Previous experience in academic editing, particularly dissertations - Familiarity with social work or similar disciplines - Exceptional proficiency in English and academic writing conventions Needless to say, respectful handling of sensitive research content is expected, along with maintaining the confidentiality of the work shared.
This is a personal project questing for an adept software engineer or system administrator to create a multiboot machine. Ideally, this machine will be configured with both Windows 10 ISO and Ubuntu 22.04...theme. The purpose of the multiboot configuration is to provide a platform where I can experiment with different operating systems. Please ensure the optimal setup is achieved such that I can independently manage the system with ease. Your experience with setting up multiboot machines will be key to the project's success. Please note, while I have some prior experience with multiboot machines, I count on you to provide expert guidance throughout the process. Your patience and clear explanations will be much appreciated. I look forward to seeing your bids and kick-starti...
I'm urgently in need of a technical artist who possesses an exceptional command of Maya, Blender, and 3ds Max. Your responsibilities would primarily include: - Conceptualising and developing models for 3D printing - Leveraging your expertise in the mentioned tools to deliver top-grade, perfectly crafted mod... Blender, and 3ds Max. Your responsibilities would primarily include: - Conceptualising and developing models for 3D printing - Leveraging your expertise in the mentioned tools to deliver top-grade, perfectly crafted models The project commences ASAP, so time-crucial delivery is key. Proficiency in modeling is a prerequisite while experience in conceptualisation for 3D printing would greatly count in your favor. I look forward to your swift responses and potential worki...
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, s...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 manipulate pivot tables. - Macros: The project involves basic macro creation and execution. - Conditional Formatting: You should be able to apply conditional formatting to present data in a more user-friendly manner. If you believe you have the right skill set for this project, pleas...
We need a freelancer to carry out a simple task. It is about verifying that a shipment matches against a packing list. The Freelancer must go to the factory or warehouse where the shipment is located, count the products and take photos according to a manual that we will send; stay in the factory or warehouse until the containers are filled out and take pictures of the loading process according to the manual we would provide
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 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.
...to automate the process of sending student data to school coordinators via WhatsApp. The task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number. The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single school. WhatsApp Integration: Th...
I have an Excel sheet with construction project data that I'd like to convert into a Power BI report. This sheet includes data from various projects of different types in a mix-use development setting. Key requirements: - Convert the Excel sheet data to a visually appealing and informative Power BI report - Create a Power BI report that can be easily updated with new data and link with Excel sheets - Ensure the report is user-friendly and can be navigated easily - Internal Links within Power BI to enhance user interaction Ideal skills and experience: - Proficient in Power BI, with a portfolio that showcases similar projects - Experience in working with construction project data, preferably mix-use developments - Excellent data visualization and report creatio...
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accurate data entry. - Abil...
Please read the attached instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be c...
I'm seeking a skilled academic writer with a deep understanding of EEG data, Autism, and Deep Learning. Key Project Details: - Word Count: 7000-10000 words - Objective: To write an academic paper based on our proposed method and offered results Your main responsibilities for this project will include: - Crafting a comprehensive academic paper on the relationship between EEG data, Autism, and Deep Learning. - Writing a literature review that underpins our proposed method and results. - Ensuring the paper adheres to academic standards, including proper citation and referencing. Ideal Skills and Experience: - Proven track record in academic writing in the EEG data, Autism, and Deep Learning domain. - Strong understanding of academic research methodologies. - Knowledge of deep ...
EN Project with the intention of reducing the time for creating cutting files and eliminating errors in saving. Aplication Area: Engineering and manufacturing Automation of saving cutting files and manipulation of drawings, 1 - Save cutting files, considering the file type and correct naming. There is a file with several layers categorized in a standard way, these layers should be separated and saved in different files with specific names according to the layer. 2 - Save steel cutting files and possibly make changes/cuts (e.g., Slide). PT Projeto com intenção reduzir tempo de criação de arquivos de corte e eliminar erros no salvamento. Area: Engenharia e manufatura Automatização de salvamento de arquivos de corte e manipulaçã...
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.
...professional presentation sheets for our martial arts school. These sheets will be used in sales conversations to visually convey the specific benefits of our training program to potential members. **Objective:** Each sheet should visually highlight a specific benefit of our training program: 1. Boosting Self-Confidence 2. Development of Defense Skills 3. Physical and Mental Balance **Format and Software:** - Size: 20x30 cm - Software: Photoshop or PowerPoint - The final files should be editable to allow later insertion of photos. **Design Requirements for Each Sheet:** **Sheet 1: Boosting Self-Confidence** - Title: "Stärkung des Selbstvertrauens durch Kampfsport" (Boosting Self-Confidence Through Martial Arts) - Main Elements: Before-and-after im...
I need help with scraping specific information from urls (we will provide). The key details I need are the company name and contact information. Website Phone Email Brand Country Of Origin Total Entries: 1704 No research required, you just need to copy paste information from the fields onto a google sheet.
...suppliers + Rotation Link to change the IP of the port. + Validity of proxy - can be edited + User Management: The ability to add, remove and modify user accounts. +Billing and Subscription Management: Tracking customer payments, subscriptions, and related data. Proxy Status Monitoring: Real-time monitoring of proxy status. Customer dashboard: + Dashboard to overview: APIKey, APIkey count, account balance, Change Password of proxy + Buy 4G Mobile proxies - product variants + Top Up: top up using USDT, Btc, ltc + Setting menu: update user profile, change password, show action history, balance history Ideal skills for this project include: - Proficiency in web development, particularly dashboard creation. - Experience in user management system design. - Kno...
Have two parameters: one for sheet ID and and one for collection. When you run the script, it extracts all data from that collection and puts it into a sheet tab with DateTime as tab name.
I'm seeking a skilled writer to compose informative articles that fall within the 500-1000 words range. The ideal candidate will have: - Proven experience in writing high-quality, engaging and informative articles. - Excellent research skills to deliver fact-checked, accurate content. - Proficiency in following guidelines and sticking to the word count. Stellar grammar, punctuality on deadlines, and the capacity to consistently deliver error-free work are must-have qualities. Please provide your related article writing samples upon bidding.
Project Title: Experienced Translator Needed: Translate Italian Company Balance Sheet to English Project Description: I am seeking an experienced translator to translate the balance sheet of my company from Italian to English. The balance sheet contains important financial information that needs to be accurately translated for business purposes. Project Details: Document Length: The balance sheet consists of 38 pages. Deadline: The translation must be completed by next week, asap. Expertise Required: I prefer a translator who has experience in financial or business translation, particularly with balance sheets. Technical Terminology: The balance sheet may contain technical financial terminology, so familiarity with such terminology is essential. Requ...
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.
I'm looking for a freelancer who can compile a 12-month dataset on social media accounts. The dataset should cover key metrics, including follower count, engagement rate, and post frequency. Your proposal should specifically address your approach to compiling this data. Ideal candidates for this project should have: - Strong experience in data collection from social media platforms - Knowledge of data analysis and metrics - Excellent research skills - Ability to organize and present data in a clear, concise manner
I have a document that needs to be typed up. It's scanned, so you must be able to read and type from scanned documents. The document is in English, so fluency in English is essential. The final document should be in plain text format. Ideal Skills and Experience: - Fast and accurate typing skills - Experience in copy typing, particularly scanned documents - Proficiency in English language - Familiarity with converting documents to plain text format.
I'm in need of an expert who can assist with financial analysis and create a 5-year sales and expenses forecast for my startup. I'm specifically looking for a professional who can: - Perform a comprehensive financial analysis for my start...forecast using customizable templates. - Include a detailed cash flow analysis in the forecast. The ideal candidate for this project should have: - Proven experience in financial analysis and forecasting. - Proficiency in creating customized financial templates. - Strong expertise in conducting cash flow analysis. - Ability to deliver high-quality work within a reasonable time frame. Example sheet attached below (it's reference purpose, not editable) I'm looking forward to receiving bids from highly skilled and experience...
I require a writer who can craft well-researched, engaging articles spanning various topics. The ideal candidate will be able to write in a way that's accessible to the general public. Key Points: - The article should be comprehensive and well-structured - The target word count is 1500 - 2000 words - Topics will include Technology, Health, and Travel The writer should ideally have: - Demonstrated experience in writing for a non-specialist audience - Strong research skills and the ability to translate complex topics into easily understood content - A portfolio of previous work that demonstrates their ability to write in a variety of subject areas
I require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.
Please read the attached instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be c...
...confirming their details, and their current role and skills; identifying the industry or industries they can work in; and, hopefully, bringing them back to the organisation as an active candidate to place. The role will include: - Cold calling to candidate data provided based on the script provided - Gathering and confirming information based on the script provided - Updating the information in the sheet provided - Returning regular updates on progress, highlighting any active candidates open to exploring opportunities Once the initial project is completed, we may have further project requirements, to be determined....
Objective: Develop a robust vehicle counting application optimized for the NVIDIA Jetson Nano. The application should accurately count cars passing through multiple cameras using RTSP live streams. Key Requirements: Modular Design: The software should have a configurable region of interest (ROI). This will allow customization of the tracking area for different camera setups. The system should support settings for either two-way or single direction vehicle detection, selectable per camera. Multi-Camera Support: The application must handle live feeds from at least three cameras simultaneously without frame skipping. Ensure seamless capturing, detecting, and tracking across all cameras, maintaining high accuracy and performance. Error Handling: Implement robust error handling to ensu...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
I am currently seeking a virtual assistant to help me with my job hunting in the technology sector. The role of the virtual assistant will primarily involve: - Job application submissions: The ideal candidate should be proficient in submitting job applications o...senior-level positions in the technology industry. This includes customizing cover letters to match job descriptions and ensuring that all required documents are submitted. Sharable resources: - resume - guide doc. Salary: $25 per week Responsibilities: - open job board platform accounts with my profile - apply for 200 proper jobs matching my profile every weekday - record them in the google sheet. Requirements: - fluent English is a must - prior experience working on similar stuff - software engineering knowledge is a...
...Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge ...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearanc...
We need a freelancer to carry out a simple task. It is about verifying that a shipment matches against a packing list. The Freelancer must go to the factory or warehouse where the shipment is located, count the products and take photos according to a manual that we will send; stay in the factory or warehouse until the containers are filled out and take pictures of the loading process according to the manual we would provide
Create an executable scraper in Python that can extract the SKU (product) list from the following Indonesian online grocery apps: - Astro - Sayurbox - Segari The scraper must be IP-block tolerant, meaning if the scraper gets blocked, execution can be continued from the poi...Scraper code and unit tests - README file for running and deploying the scraper - Output of all SKUs from the 3 online grocery apps specified above Project Acceptance Testing The scraper output will be manually verified within 24 hours of submission and SKU list must be 95% accurate. The SKU list is the most important aspect of the scraper output. Variations in other data for each SKU like stock count, popularity index and prices may vary and higher levels of discrepancy (~25%) during manual verification is a...
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 interfaces for Excel.
I need a unique and engaging book report written within a week. It should be between 500-1000 words and written in a creative/narrative style on the book "The ultimate Digital Marketing Playbook for Dominating your Local Area" by Krista Mashore Key Requirements: - Complete a book report within a week - Word count between 700-1000 - Writing style should be creative/narrative I'm looking for a writer who can deliver an exceptional and captivating book report that will hold the reader's interest. The book will be provided to the selected freelancer. Ideal Skills: - Proficiency in English - Experience in creative writing - Ability to meet tight deadlines - Understanding of narrative writing techniques Please provide samples of your previous work in your proposa...
Here is a brief of my requirement. What I want is when I am creating a collection page, the way I can actually sort the product is either through best selling item, product title,...product title, highest price or lowest price, new best oldest and manually. Now we have thousands of product in a collection at the moment hundreds of them. What we want to do is instead of the regular product filter which is available on Shopify, we want to have a custom one with the logic on the basis of either row as or basis on the conversion rate. So we can actually connect this with the Google sheet or we can actually have an identifier in terms of how the product would change their, how would product would look on the collection page in terms of where they are on the collection page basis of an id...
