Refresh web query excel macro punët
Create a database and CREATE TABLE statements for all tables in your ERD (Part A) including primary and foreign keys. 2. INSERT INTO statements for populating the database i. Insert five rows of (made-up) data into each table. Make sure that the data you enter in these tables should be sufficient to return at least one row for each query in Task 3. AL should hold at least 5 bottles of Penfold Grange 2010 in some branch or other
Hi Ahmed I can pay you here for that work on the 2 small excel projects
I am in need of an Excel form that will track data and facilitate scheduling. This will primarily be used by our administrative staff, so ease of use and clarity are paramount. Key Requirements: - The form will need to provide a user-friendly interface for entering data. This should be intuitive and easy for administrative staff to use without any advanced knowledge of Excel. - The form should also be capable of performing calculations based on the data input. These calculations are central to the purpose of the sheet, so they must be accurate and reliable. - Data should be stored across multiple tabs for organizational purposes. This will help ensure that the data remains clear and easy to access as the form is used over time. Ideal Skills: - Strong Excel proficienc...
...securely and maintaining user privacy is necessary. - Search Functionality: The website should include essential features such as Full-Text Search, Faceted Search, and Auto-complete/Suggestions powered through Elastic Search. The capacity to execute comprehensive indexation, accurate retrieval, and fast query processing is crucial. - Responsive Design: The site must be mobile-friendly and capable of rearranging its layout based on the user device screen size. Design Style: - Modern: The web design should align with the modern style. Minimalism, adaptive grids, and scalable graphics are what I'm looking for. The design should be functional yet aesthetically pleasing and user-friendly. Your experience in integrating Elastic Search with Django and your keen eye for m...
...document to be converted into an Excel table. The layout is moderately complex. Here are some additional details: - **Task**: The primary purpose of this conversion is data entry. As such, the Excel table must be an accurate representation of the information in the PDF. - **Layout**: The PDF contains multiple columns of text which need to be correctly mapped to the appropriate cells in the Excel spreadsheet. - **Verification**: After the conversion, manual review and correction are required to ensure that the data has been accurately transcribed. Ideal skills and competencies for this project include: - **Strong attention to detail**: Given the manual verification needed, an eye for detail is crucial. - **Excel proficiency**: A good understanding of Exc...
Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet
I'm in need of an expert who can assist with entering text data into an Excel spreadsheet. Key Responsibilities: - The primary task is to accurately input text data into the designated cells of an Excel file. Ideal Skills and Experience: - Proficiency in Excel, especially in handling text data. - Attention to detail and accuracy in data entry. - Previous experience in similar projects will be an added advantage. Looking forward to your bids. My typing speed is 55wpm
I am seeking a proficient CBP Entry Data Specialist for a part-time position of approximately 10-20 hours per week. The suitable candidate should efficiently perform tasks including: - Accurate Data Entry - Rigorous Record Keeping - Document Verification The role will require expertise in using tools such as Microsoft Excel and specialized Data Entry Software for smoother execution. Prior familiarity with the Customs and Border Protection database will be a significant advantage, although it's not a mandatory requirement. Excellent attention to detail, accuracy, and organizational skills would make you an ideal candidate for this role.
I'm looking for a meticulous freelancer to help with entering text data into an Excel sheet. My project entails copying texts verbatim from multiple online sources, there's no need for any sort of editing. Here's what you should bring to the project: - Proven experience in data entry - Proficiency in Excel - Ability to handle large volumes of text data - Strong attention to detail to ensure accuracy - Ability to work independently and adhere to deadlines Prior experience with copying data from online sources will be a major plus. Let's put your data entry skills to work in this project!
I need a proficient VBA professional who can help develop an Excel recruitment tracker dashboard. Key components should include: - Display recruitment data in visually engaging formats including bar charts, pie charts and tables. - Incorporate dropdowns using macros form control for flexible data querying. - Capture essential data points such as candidate name, the position applied for and the application status. - Provide tracking capabilities for application status reflecting stages like pending, shortlisted, and interview scheduled. -Should have recruitment metrics like Time to hire, recruitment funnel and other key metrics The ideal candidate should have robust skills in VBA and Excel, particularly in creating dynamic and interactive dashboards. Experience in human r...
...record in creating, managing or implementing cloud-based robo calling systems and also conversational AI calls that is good with asian language, especially Bahasa Indonesia. the subject of the research must have : telephony (SIP/VOIP) a working AI model or open to integrations with AI Basic Telco Services features such as, Campaign Calls, scheduler, call recorder) Wide system integration capability Macro/logic/script editing(for robo caller,pre recorder or AI generated TTS) white label ready or not. KPI analysis The Goal of this research is to figure which or what is the best system/platform/Integration to use that gives the right combination so it result in cost effective, work effiency, best call per minute or per second tariff etc etc, feel free to do your own custom setup...
In need of a meticulous freelancer to undertake a copy-pasting project. Your primary task will be to copy-paste text content into an Excel spreadsheet. Key Responsibilities: - Accurately copy text content. - Efficiently paste the content into a structured Excel database. Ideal Skills: - Proficiency in working with Excel. - Strong attention to detail for error-free work. - Ability to maintain structured and organized data. - Prior experience with copy-pasting tasks a plus. Your effort will be critical in maintaining an accurate and reliable database. I am looking forward to seeing your applications and working with you on this project.
I'm in need of someone to assist me with typing text data into an Excel sheet. The data will be provided in a digital format (PDF, Word, etc.). Key requirements: - Accurate and fast typing skills - Proficiency in Excel for proper data entry - Familiarity with using specific fonts and sizes for consistent formatting - Experience with data sorting and filtering in Excel Your attention to detail and ability to follow formatting guidelines is crucial. The ideal candidate will be organized, efficient, and able to deliver high-quality work within the agreed timeframe.
I'm seeking a highly skilled Excel expert to develop a versatile, either fully or semi automatic, Excel formula or action algorithm that can handle specific data manipulation tasks. This Excel tool must be able to automatically select data from a certain type of table. Hence flexibility is essential. Likewise, it should be able to arrange this selected data against particular types of rows. The formula should be customizable to adapt to various row types. The main aim is to create a solution which allows for selection and rearrangement of data based on multiple potential criteria, whether by column header, row label, or specific values even though I have not specified them at this point. Therefore, excellent comprehension of Excel data manipulation,...
I need an expert in web scraping, specifically in Python, to extract text data from a particular website. The scraping is a one-time task, not requiring routine updates, and the extracted data needs to be saved in an Excel file (or CSV). This will be hidden behind a login wall - so I suggest that the Python script will go to the website and then wait one minute, where I will manually log in. Ideal Skills and Experiences: - Proficiency in Python for web scraping - Experience with scraping text specifically - Ability to deliver the required output in a CSV format
...editors such as Elementor, Gutenberg, DIVI, WP Bakery, Classic. and very strong in coding such as HTML, CSS, JS for frontend, PHP. Experience in multi-store, product and service booking, multi-language sites, multi-currency, catalogs, ticketing, e-commerce (stripe integration), SMS/Email integration and automation is important. For this particular project, there is a need to: 1, Update and refresh brand and product content in WordPress. (Strong coding skills required) 2. Integration of e-commerce payment gateway (Stripe) 3. Module Integration: I want to integrate several systems to amplify site functionality. These systems include a SMS system for improved order tracking, updates and communicate offers. 4. Bring back to life a domain that is not working 5. Site Redesi...
...geological tools. Key deliverables: - Icons representing various geological tools, specifically: - Wind Rose Diagram - Bore Log - Water Strike - Groundwater Level - Lithology - Field Data Collection - Data Import - Data Export - Data Exchange - Modifications of existing logos to icons to use to indicate integration within the App. Excel (for an Excel export) GWSDat ProUCL AGS Ideal Skills and Experience: - Proficiency in Material Design and minimalistic design styles. - Demonstrable experience in iconography and digital design. - Familiarity with geological graphics would be
As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.
I NEED THIS ANALYSIS TO BE MADE IN MAXIMUM 4 HOURS. IT NEEDS TO FOLLOW THE SAME ( OR VERY SIMILAR) STYLE OF THE LINK BELOW... : - Generate a report based on selected financial ratios; specifically, liquidity, profitability, and solvency ratios. - Assess and include the following liquidity ratios in the report: current ratio, quick ratio, and cash ratio. - Evaluate and incorporate these profitability ratios: gross profit margin, net profit margin and return on assets. Ideal candidate: - A proficient user of Excel. - Strong mathematical and analytical reasoning abilities. - A deep understanding of financial statements and financial ratios. - Ability to deliver under a tight schedule. Looking forward to your prompt bids. Thanks!
...appears that the model() function within is not being triggered. Expected Outcome: The successful candidate will diagnose the problem, ensure that CSV imports result in new contacts being added as expected, and address any issues related to the modifications made to the original extension. Technical Skills Required: Expertise in Laravel and Laravel Nova. Experience with the Maatwebsite Excel package. Familiarity with debugging and troubleshooting Laravel applications. Ability to work with modified third-party extensions. Collaboration Tools: Screen Sharing: Due to a private GitHub repository containing sensitive information, we prefer to work through screen sharing for code review and collaboration. We are open to using Teamviewer, Discord screen share, or similar tools where ...
I need an efficient and detail-oriented freelancer to populate a database with information about my customers. The project involves collecting, inserting and cleaning the following data of around 12,000 rows of ...management tasks would be analyze, identify and delete duplicates, and the main data to be collected would be only: - Customer Name - Email Address These data points will be provided, and your task is to efficiently and accurately compile this information into our database. Experience in data entry, database management, and customer service will be beneficial to complete this project. Knowledge of Excel and other data management tools is essential. The freelancer must be meticulous and trustworthy as they will be handling sensitive customer information. Thank you. Kin...
Creating a fillable PDF form with specific functionalities drop-down boxes, auto printing, auto-saving to a server, and inserting pictures if possible The data is in Excel format, ready to go.
I'm in need of a freelancer who is skilled in designing both process and workflow flowcharts via Microsoft Visio, as well as project management checklist forms in Excel. The checklist should be of an intermediate level complexity, incorporating features such as drop-downs and validation. Prior experience in constructing Visio flowcharts and Excel forms is imperative to understand the project's need thoroughly. Proficiency in Excel functionalities would make tackling this task comparatively easier.
...scheduler on my website. Your mission will be to set up API calls to request data specifically for certain resources. Key Skills/Knowledge required: - Familiarity with API integration - Experience working with DevExtreme scheduler - Strong understanding of data request and retrieval The job requirements are as follows: - To be able to query the api for scheduler data and present it. The API is already available and I can modify it at any time. I simply need to query it and present the 3 consts (tasks, appointments and assignees). Kindly note, the type of data to be retrieved and the presentation style for this data in the scheduler are yet to be defined. Your input and suggestions during this phase would be highly appreciated. Please place your bid and let's di...
You will be given 5 articles, submit each of the articles to 10 High DA (60+) websites. You create accounts on 50 High DA (60+) Websites with our email address (hello@MandarinNu com) We will own these accounts, log in and modify articals in the future. If you need assistance in the regi...own these accounts, log in and modify articals in the future. If you need assistance in the registration process, like to get verify code in the account registration email, we will be here to help. We agree to be using the following tool to verify DA score, links from low DA websites will not be counted. 【Hand-In】 You need to submit me an excel file specifying 50 links of the articles that we can check, with account/password of those websites.
...distinct user-level roles need to be created, each with specific permissions and access rights. These roles will include capabilities such as creating new logins, granting access permissions, and other administrative functions. Technical Specifications: - The project requires a freelancer with experience in PDF generation/manipulation, data extraction from Excel files, and implementing role-based access control systems. - Knowledge in web development languages/frameworks (specify if you have a preferred stack), experience with script fonts in PDFs, and a solid understanding of backend development for user management is essential. Deliverables: 1. A fully functional Instructor section as per the described specifications. 2. An integrated role-based access control system w...
I am in need of a simple Excel sheet for my pastry shop. It will be used for workers to log and track their daily production. Specific Information & Organization: - The table should be organized around daily production. - The information to be included in the table should encompass: - Flavors (10-15 in total) - Locations - Amount produced in each batch - Day of production At the end of production, employees press submit button and the data is transferred into Google Sheets with saved information while the form gets cleared and ready for next submission. Ideal Skills: - Proficiency in Excel; ability to create user-friendly and easy-to-understand tables - Experience in creating similar tracking or production sheets a plus - Understanding of basic bakery or food ...
Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.
This task requires a dedicated portal using Flexbox and CSS....dedicated set of elements on a dedicated new subdomain, which will only contain these products in a nice Flexbox CSS design. Key aspects of the job: - Design based on the current design. - Products listing: Upload and import products from an Excel sheet - Each product should have a sub-page where details of the product are mentioned and listed - Approx 10 types of attributes are to be handled centrally for the products and filtering should also be possible Specific requirements: - The imported data from the Excel sheet should be updated on the portal - existing products to be updated - The products are listed as Flexbox Other requirements: - Work based on a full price offer, invoice to EU company is needed
The project comprises 6 regression models (linear, logistic, and moderation) based on a set of dependent and independent variables. I need someone with good knowledge of statistics to operate a dataset, make log transformations in the data, and give me the regression analysis results in an Excel spreadsheet.
Wir stellen in unserem Unternehmen unsere Dokumente um. Hierzu sollten die Dokumente, die im spezifischen Apple-Format erstellt sind wieder in die Microsoft-Formate umgewandelt werden: Pages -> Word Numbers -> Excel Keynote -> PowerPoint. Es sind gut 100 Dokumente, die umgewandelt werden müssen. Dabei sollen die Dokumente in den Microsoft-Formaten nachbearbeitet werden: - SIlbentrennung aktivieren - Seitenumbrüche prüfen und ggf. korrigieren. Die/ der Freelancer:in muss die detusche Sprache beherrschen.
I'm looking to update our current logo to better reflect the modern and professional nature of our business. Key requirements: - Refresh the design elements: The current design elements of our logo are a bit outdated. We need someone to modernize and refresh them. - Redesign the typography: Our current logo's typography doesn't align with the professional audience we are targeting. We need a new, modern typography treatment that feels sleek and sophisticated. Ideal skills and experience: - Proven experience in logo design, particularly for professional audiences. - Strong understanding of modern design trends and how to apply them to a brand identity. - Proficiency in typography and the ability to create a custom, modern type treatment. - The ability to bala...
Need to enter 1000 entry in my database, throw our website. Excel will be provided.
hi evryone simple project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible by usuing formula in excel or use some VBA code
Creación de una base de datos en excel. Los orígenes de datos serán diversos: . otros excels. . webs diversas . documentos word . etc Las tareas son: 1. Búsqueda de información, e incorporación de la misma al excel 2. Cribado / limpiado del excel 3. Completado de información para aquellos campos incompletos. Este es un trabajo de aproximadamente dos meses. El entregable final será un excel filtrado y ordenado.
I'm looking for a detail-oriented individual to input a combination of text and numbers into Excel. Below are the specific requirements for this task: - Data type: It will involve both text and numbers. - Data organization: The data should be entered line for line, from one cell to another, and from top to bottom. - Cell arrangement: Each line should be inserted into a separate cell. The ideal freelancer for this project should have a keen eye for detail, a solid understanding of Excel, and be comfortable working with text and numerical data. Accuracy and speed will be key to delivering this project effectively. the lines are as below: icd report *Upcoming Vessels* *11.04.2024* *TPA Terminal II* *01. MAERSK PHUKET 39* (E.T.A 13.04.2024) Loca...
based on an existing chromeAddon . I need to keep same functionality hiding some information and automatically refresh or update some records on local storage
I need a web scraping tool that can collect data from tables on a daily basis and present them in an Excel file. Key Requirements: - The tool should be able to scrape data from tables on websites. - The output of the scraping process should be presented in an Excel file format. - The tool needs to be set up to run daily and update the data accordingly. Ideal Skills: - Proficient in web scraping techniques. - Experience with extracting data from tables. - Ability to program automated data extraction tools. - Strong proficiency in Excel or similar spreadsheet software. - Time management skills to ensure daily automated runs. The scraping tool should be working on the backend of my Wordpress Site () The members of the site will be putting their URL's...
My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing software with a new automated invoicing system. I look forward...
I have a document that I need to be converted into MS Excel format. - The document is currently in Excel and needs to be replicated into multiple sheets. - Specific formatting requirements will be provided. - The number of excel sheets will be determined by the content of the text. Ideal Skills: - Proficiency in MS Excel - High accuracy in data entry - Ability to follow specific formatting instructions - Attention to detail. Looking forward to working with you.
I have an Excel workbook. I would like to expand that workbook and add an inventory aspect to the workbook. I am looking for a developer with extensive experience with VBA script and custom functions in Microsoft Excel 365. If the first job goes well we will have more consistent work (other jobs) to be done.
I am looking for a detail-oriented freelancer to help convert my existing Excel spreadsheet data into a database format. Requirements: - Import and convert Text Data from Excel Spreadsheets to Database format - Accurate and efficient data entry skills required - Prior experience with Excel and database formatting is a must - The candidate should have an eye for detail and be well-versed in data management By the end of the project, I expect all data from the Excel spreadsheet to be neatly structured and readily accessible in the new Database.
I require assistance in compiling a notably detailed list of retailer's contact information. Specifically, I need comprehensive details fo...information. Specifically, I need comprehensive details for approximately 15 retailers (with 6 departments of each retailerso far I just) in the sales department. this project will include both men and women's departments. It's approximately 100 contacts (15 retailers X 6 departments X 2) Deliverables: - Company name - Buyer's name - Telephone number - Email I am expecting the final output to be an excel spreadsheet, organized and easy to navigate. This project requires precision, strong research abilities, and good organizational skills. If you have previous experience in data compilation and a keen attention to detai...
I have existing logos that r... 2. Logos: I want my logos revamped and spiced up. The look of the logos should be nested within modern design concepts yet maintain a recognition of the original layouts. 3. Business Cards: The new design should also be reflected in the business cards. The information on the card should be presented cleanly and crisply, ensuring its readability and attractiveness. Ideal candidates should excel in modern graphic design and Photoshop. A keen sense of color blending and typography understanding is crucial. Previous work with logo and business card design will be an added advantage. Replicating an existing design style while introducing fresh concepts is paramount. Remember, the goal is to enhance, not change radically. Can't wait to see your st...
I am in need of a web developer to create a website for my finance company. The main purpose of the website will be to provide a platform for security analysis and charts on financial data. Key Features: - Real-time data updates: I need the platform to display real-time data updates to allow our clients to stay informed. - Interactive charts with zoom and pan functionality: The platform should have interactive charts with the ability to zoom in and out and pan. - Customizable indicators and overlays: Our clients should be able to customize the indicators and overlays on the charts based on their preferences. - Data entry by user: The platform should also allow users to input their own data, which can then be analyzed and displayed on the charts. - API integration - Database...
...experienced web developer to build an eCommerce website on the WordPress platform using WooCommerce. The website will be a compliment to to a physical boutique that opened 6 months ago for which my client now desires to sell the physical apparel items online. The estimate is 90 to 100 items that will need to be added / configured for the online store. I will provide the theme selection chosen by my clients, and CSS skills will be needed to customize the site to fit color's of my client's brand, and other CSS modifications that will be needed. Key Responsibilities: - Designing and building a fully functioning eCommerce site on WordPress - Configuring products with SKU number, brief product descriptions, size availability, initial inventory levels, pricing (I will supp...
I require a skilled freelancer to type more than 100 handwritten notes into an Excel sheet. The notes solely consist of text, no numbers or dates. Key Skills and Experience: - Proficient in data entry - Exceptional attention to detail - Highly skilled in Excel - Previous experience in typing handwritten notes would be advantageous - Strong understanding of English language to ensure accurate transcription The success of the project will rely heavily on your focus, precision and commitment to quality. Please bid only if you're confident in your ability to transcribe and organize handwritten text accurately into Excel.
I need an EXPERIENCED Javascript developer to write me a custom React fetching mechanism. Use the Tanstack library to write me a custom hook that can fetch data and cache it too. These features should be implemented: - Assume API call always returns an array of data. - I can pass a modifiedFrom query param which is just a string ISO date. 1. Fetch the data using the cached lastFetched date for that key/api call 2. Mutate the result in the stored cache and updated the lastFetched date in cache 3. Allow data to be cleared from cache after an x time
...the project owner, I'm searching for an expert in Excel who can create a simplified schedule for me. The main task will be focused on data entry, particularly incorporating dates and times. Key Requirements: - Ability to set up an Excel schedule that facilitates uncomplicated entry of dates and times - Prior background in creating Excel spreadsheets for time and date-related data - An easy-to-navigate layout that allows for smooth and systematic data entry Ideal Skillset Required: - Display proficiency in Microsoft Excel - Show effectiveness in data entry - Have strong attention to detail Please note that this project does not require the implementation of formulas to calculate differences or durations between dates and times. The Excel ...
