Access vba data excel spreadsheetprá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.
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
We run an app that needs a new FE in React or Vue.js The new UX has been prepared including a styleguide in Adobe XD. We are using REST API between FE and BE. We will be doing BE with our own team. We estimate this to 20-30 MD, about 200 hours. We will not consider any offers until we can review your code. Then we will provide access to the current application, user manuals and access to the new UX to prepare your estimate. We prefer someone for full time, but you can do this as a side job, however we expect 20h/week as a minimum commitment.
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
...Potřebujeme: - dlouhodobou spolupráci, - stálou údržbu databáze, která je 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...
Hello, Your Request I create a simple application that will communicate with the server. Function application is simple. - User logs (as opposed to server notified) - Key track position (at adjustable intervals Applications sent by gps coordinates to server. I make API that assumes the dates and stored in the database) - START background (application...application is simple. - User logs (as opposed to server notified) - Key track position (at adjustable intervals Applications sent by gps coordinates to server. I make API that assumes the dates and stored in the database) - START background (applications are minimized, but still sends location information) - Shut down button (Applications will be turned off) The application therefore has access to the Internet and GPS. no...
...eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing 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 simulta...
...for a competent mobile app developer to create an Android Internet Radio app that features a mix of content, including talk shows, music, and news and sports. This is what I require: - Development of the app solely for the Android platform - It would be a bonus if the app can support offline listening, but this is not a definitive requirement – I am open to discussion on this point. I provide access to my play store for the person to deploy the app. I will also submit the online radio link Ideal skills and experience: - Proven experience in mobile app development, especially in creating high-quality Android applications - Strong knowledge and experience with internet radio app creation would be highly advantageous - Exceptional understanding of the Android development...
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 don...
...Services Procurement Specialist to identify and engage with vendors and disability service companies that offer or require American Sign Language translation services. This role involves researching British Columbia and Federal Government procurement lists, as well as other relevant platforms, to gather contact information and assess potential partners for our consulting services. Responsibilities: Access and navigate various government procurement databases to locate vendors offering ASL translation and related accessibility services. Identify disability service companies across Canada that align with our service offerings. Compile detailed contact information and create a strategic rationale for outreach to each identified vendor or company. Maintain a structured database of ...
I'm in need of a variety of visual assets and elements for my upcoming content project centered around renowned franchises like WH40k, LOTR, Cyberpunk 2077, and The Elder Scrolls. Here's a detailed b...visual aesthetics and thematic elements of WH40k, LOTR, Cyberpunk 2077, and The Elder Scrolls. - Creative flair and the ability to translate complex themes (including Sci-fi, Fantasy, Cyberpunk, Horror, Machines & gears) into engaging visual content. A valid proposal should include drafts of what is required above. If your submission is awarded, we require full ownership of the work, as well as access to all source files for future edits if needed. If you have the skills and experience to bring these unique franchises to life through captivating visual elements, I...
DESCRIPTION = = = = We need a skilled developer to create a mod for a fu...of the killed player. - Deliverables: - Fully functional mod integrated into the Minecraft SMP server. - Clear documentation outlining the mod's functionality and installation instructions. - Timeline: Please provide an estimated timeline for completion. KEY POINTS = = = = We need a seamless transition between modes, with a toggle switch hidden from in-game messages. All players should have access to the toggle feature without entering creative mode. HOW TO APPLY = = = = If you have experience in Minecraft mod development and are interested in this project, please reach out to discuss further details and provide your estimated timeline and cost. We look forward to collaborating with you to bring th...
I need a web designer to have my website within the right theme, to match my main page pictures. WordPress. I'm seeking a skilled web designer to create a portfolio website that primarily showcases written content. The theme of the site should aesthetically align with the main page images....experience in graphic and web design. - Experience with portfolio web design, preferably with writer portfolios. - Intuitiveness and creativity in matching site aesthetics to given image themes. - Solid grasp of user experience to ensure optimal site navigation. The purpose of this website is to professionally showcase my written work. The design should therefore make it easy for site visitors to access, read, and engage with this content. Please include relevant examples of your work in...
I'm urgently looking for a professional who can create a customizable resume builder for me. It needs to be a simple and effective tool that allows users to easily input their information and then customize which sections and responsibilit...responsibilities to add for each employer from a list of responsibilities that can be added to. - The following sections are to be included: (1) Name/Contact information (2) Summary (3) Professional Experience (4) Technical Skills (5) Professional Designations (6) Education (7) Certifications. Export formats: - PDF - Word Not sure what format this would best be suited for. Could use Excel, Access, Word (as long as can select the data ie check box or something similar), or AI. The project is on a tight deadline, so I would a...
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
The task is to tag for deletion, the cases on my data sheet that are settled, and where they sold the property, so I can perfect my data in my CRM (Go High Level), so we prospect opportunities. To do this, you need to look up the case number and required you can access the sites from your country of origin either directly of through the use of a VPN. No exceptions! I have attached a sample file so you can see the scale. Only detail oriented, highly organised persons will be considered. Let's see if we are a fit!
I am seeking an experienced professional to assist in importing the current version 4.11 of OpenShift Container Platform (OCP) cluster into a new Advanced Cluster Manager (ACM). - Task Details: - The project primarily e...import of all resources and configurations from the current OCP cluster to the new ACM. - Once imported, the new ACM should only be accessible to selected users with Full Administrator rights. - Essential Skills: - Knowledge and proficiency in OpenShift Container Platform version 4.11. - Adequate understanding of Advanced Cluster Manager. - Familiarity with administration and user access management in an ACM environment. Please ensure to provide relevant experience and demonstrated ability with the requirements stated above before making an inf...
My WordPress website is redirecting to unknown sites and showing signs of injected Javascript. I've experienced this issue despite keeping my WordP...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 an...
I'm looking for a proficient developer who can add a page to my website that interfaces smoothly with my MySQL database. The website already has formatting etc, so I'm not looking for that. The database stores a variety of exercise data, and the webpage needs to display this data in an intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from a drop-...
...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 status of groups that are joined or already joined. For unjoined groups that we have searched for, you can auto join. - Can Auto Post to Facebook Group Each feature has Add, Filter, Combobox options, check, delete in the required places Create a License Key in Program For Access Application The ideal candidate for this job...
...from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. 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. ...
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 Tab...
...creation and administration of multiple choice tests. - User accounts: The website will require user accounts for exam takers. These should be simple and easy to create, but also secure. - Comprehensive dashboard: Both users and admins should have access to a comprehensive dashboard for tracking user progress and other key performance metrics. Ideal Skills: - Proficiency in web development, particularly with creating interactive websites - Experience with user account management and authentication - Prior work with dashboard development and data visualization - A background in education or e-learning platforms would be a plus This project has a potential for further growth and development down the line, making it a great opportunity for a skilled developer looking for ...
...particularly interested in a more minimalist and sleek design, as well as a transition from a sidebar menu to a bottom menu. I'll provide examples of interfaces that I like, which I'd like you to incorporate into the design. I have a few 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 tur...
...comprehensive warehouse inventory replenishment tracking system for our Fastener drawer at Home Depot. The system should have a focus on reporting and analytics, real-time bin shrink, and work with an electronic keypad and analog/digital interface. Key Features: - **Reporting and Analytics:** The system should provide insightful reports on inventory levels and trends. This will help us make data-driven decisions. - **Real-Time Bin Shrink:** I need to know if the quantity of items in the bin matches the recorded amount. - **Interface:** A mobile app interface will be ideal, making it easy for staff to work on the go. Inventory Tracking: - The system should involve manual entry for inventory tracking. The system should be user-friendly and easy to use for our staff. ...
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.
...swiftly and securely. Clients can upload documents, such as contracts, pleadings, and evidence, directly to their case file, eliminating the need for physical paperwork and reducing administrative burdens. Real-Time Case Updates: Clients can stay informed about the progress of their case through real-time updates and notifications. They can track milestones, receive alerts for upcoming deadlines, and access important documents anytime, anywhere, ensuring transparency and peace of mind throughout the legal process. Teleconference Appointments: Our platform integrates teleconferencing capabilities, allowing lawyers to schedule and conduct virtual appointments with clients effortlessly. Through video conferencing, clients can consult with their legal representatives, discuss case st...
I need an expert to help me select the most sui...apps in JS using Electron and we can make mobile apps in JS using react & angular. But in javascript will code be exactly same for all platforms ? 4. Another option is Flutter (Dart). 5. Which is better out of these 2 ? or can you suggest any other option apart of these 2 6. As of now I want to develop a web app for visual DBMS quite similar to ms access. It will look like a spreadsheet but will have capabilities of both Google sheets / MS excel & a DBMS (DataBase Management System) 7. I am very familiar with C & C++. So I would prefer to use similar syntax. 8. Can C++ be answer to my 1 & 2 point ? You should have: - Profound understanding of various programming languages - Significant experience i...
...Description: We are seeking a skilled Freelance Full Stack Developer with experience in AI technologies, web development, and data processing to build an automated pipeline for creating AI images. 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 AP...
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as ...
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, p...
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as ...
More details: What is the current DA (Domain Authority) and DR (Domain Rating) of your website? Above 30 Which strategies do you prefer I utilize to increase your DA and DR? Creating high-quality backlinks, Improving site content, Engaging more influential sites Are you willing to provide access to your website for on-page optimization? Yes
...matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship 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 produ...
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), Seleni...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...
...reaching out through this email to make another request. In this case, we have a very important client here in Spain, operating in the online product sales sector, very similar to TEMU. They are interested in having us develop a community site, very much like the following example: EXAMPLE They want their community, which currently exists as a WhatsApp group, to have access to profiles where they can comment on products, engage in forums, and build communities. The functionality required is as follows: An internal client area providing information about the user's account (already created on () but requiring additional information specific to this platform). Image galleries and sliders. Social functions such as social media sharing buttons, activity feeds
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
I'm seeking a talented developer to create an application where users can upload video reels. I need an artificial intelligence feature integrated into the app that can analyze thes... The app will let users upload revision notes with a point system and have a dashboard of how long they've spent doing it. I want to eventually make it into an app which teachers, parents and students can use to check their childs activity and help others. i want a spot for brands to post student discounts and eventually earn commision off it the app sould also have a pro subscripion which has access to the good features. Ideal candidate should have: - Expertise in mobile app development - Experience with AI integration - Knowledge in video reel handling - Good understanding of text re...
...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 analysi...
...efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Ideal Skills and Experience: - Strong experience in data analysis and visualization - Proficiency in integrati...
