Extjs datagrid rowJobs

...environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate, and provide it as well. Start the search from most recent and search backwards in time. Once you find 30 sea-related

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 point where the last row of data was successfully extracted. Scraper Functions Function: list_category_tree Input: competitor_name(astro | sayurbox | segari), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocomplete place from google maps API), ca...

I require a skilled Excel VBA developer to create a dynamic syst...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-frien...

Here is a brief of my requirement. What I want is when I am creating a collection page, the way ...page, the way I can actually sort the product is either through best selling item, 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...

Design and implement one page website. The website shall have a design simi...party libraries or APIs. Something like bootstrap + vanilla JS would be ideal, or bootstrap + jQuery. The website shall have a small database usage feature, in which every time the page is loaded, a new row is added to "leads" table with the following information: 1) Visitor's browser agent string, 2) Visitor's IP address, 3) 0 or 1 depending whether user is using a mobile device, 4) User's name, email, phone number and message if they fill up the contact form and click the "Send" button. Note: In case user send the form multiple times, then this data is overwritten in the same table row. After I accept your bid, you will get server access to the server that h...

...with expertise in the Twitter API and JavaScript for Google Sheets. I require assistance in setting up the Twitter API and need a custom script written for Google Sheets. Here are the specific requirements for the project: Project Objectives: 1. Script Functionality: - Automatically fetch Arabic text from a specified Twitter account and insert it into Column B of a Google Sheet, starting from Row 2. - Retrieve and insert links for images and videos associated with the tweets into Columns C, D, E, and F respectively. 2. Automation and Updates: - The data retrieval process should be automatic and occur in real-time, ensuring the Google Sheets document is updated continuously, irrespective of whether it is currently open. - Include functionality to fetch tweets within ...

I have a google sheet with 400 exercises. I need to copy them all over to a notion document with a slightly different format. Here is the google sheet — columns are not as important but if you could also select them that would be great. If there is equipment clearly used then select it from the dropdown, it is likely to only be Dumbbell, Barbell, Bench or Resistance band The first sheet separates out the exercises by “movement type”, many of these coincide with the movementPatterns columns. The exception to this is the “Core Work” row. Each row there has a header that coincides with a movementPattern. If it is clear what to select then also select this from the dropdown, if it is not clear then just leave it.

Project Duration: 1 Hour Project Type: Python Script Modification Project Level: Normal Server Type: Ubuntu 22.04 Number of Changes Required: 1 Project Overview: We have an existing Python script that allows us to upload a CSV with two columns: Prompt Output The script th...existing Python script that allows us to upload a CSV with two columns: Prompt Output The script then submits each “Prompt” to the OpenAI API, inserts the output into the “Output” column. We would like one change made to the existing script. Change Required: We would like to add one more column to the CSV file, “Id”, it will be the first column. We use “Id” as our own reference number for the row This column and its value should be retained in the outp...

...not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to select 4 tariffs. These blocks with tariffs should be disabled and adjusted from the admin panel For the selected tariff, pdf invoices should be generated (the form will be provided) with the calculation of the invoice amount depending on the day of the month when the tariff wa...

Input:- You will get an excel file as input. Step1- Sort the Excel file by site name and place data in sheet 1 Step2- Sort the Excel file by site address and place the data in sheet 2 Step3- Sort the Excel file by latlong and place the data in sheet 3. After Sorting and creating 3 different sheet, we need to apply... Step3- Sort the Excel file by latlong and place the data in sheet 3. After Sorting and creating 3 different sheet, we need to apply the logic to find exact duplicate and high match. Example - means in sort by site name we will find exact duplicate and high match site(75%) match and print exact duplicate/ partial match. Then for exact duplicate and partially match we are going to compare all row and need to print what is matching like site city, site state, site c...

I need an experienced Python developer with solid skills in webscraping to gather data from the Premier League's stats page (). The required task involves capturing all available statistics and organizing them into rows and columns within a single CSV file: every season is a row, with different statistics as columns. Applicants should be able to provide the following: - Evidence of past work, particularly related to webscraping. - Their robust experience in Python language and relevant industries. - Detailed project proposals outlining strategy and timeline. Given specified needs, Python is the preferred programming language for this project. Previous experience in similar webscraping projects is desirable, demonstrating your ability to

i want 3-5 minutes (both timeframe) candle data into excel sheet. data like date, time, open, high, close, volume of each candle. (check image for refrence) data should be updating in realtime, no delay, next candle data in new row. add instruction, so that i can edit code my self and chsnge stock symbol to get data for desired stock. easy to use and record all day data, even if i open excel at the day end or reopen thw whole day data should be recorded.

...not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to select 4 tariffs. These blocks with tariffs should be disabled and adjusted from the admin panel For the selected tariff, pdf invoices should be generated (the form will be provided) with the calculation of the invoice amount depending on the day of the month when the tariff wa...

Scrape license data from the FL DBPR website and deliver into an excel spreadsheet. Two counties: Osceola and Polk. Two license types: Vacation Rental - Dwelling and Vacation Rental - Condo. In the attached spreadsheet the required fields t...Condo. In the attached spreadsheet the required fields to identify the license type and county are shown in screenshots and the second tab as an example. The extracted data is then to put into tabs for each county and license type. Multiple rental locations for a primary name should have multiple entries (rows) with the license details repeated and only the rental location being different each row. There maybe some dynamic features in the website that complicates data extraction. Website:

...have enough spacing between fields or elements for a clean look (header height should be equal to the height of header in "About US" page. 4. Styling changes : a) The look at feel needs to be improved - (see screenshot) a). Set background color to f5f5f5 (should be set in a common css or scss file and reused as a variable in all pages) b) When you see the results in list view (one item per row) the logo for Walmart seems to go off the screen/item box, it should be within the item box and have some spacing around it - screenshot will be provided. c) The text that slides in the home page on mobile is not working correctly, the two statements : "Find the best laptop" and "your money can buy" need to be one line and also slightly bolder font, curre...

I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your bid. I appreciate your time a...

I'm looking for a skilled Python developer to create an Ant Colony Optimization (ACO) algorithm that can read numbers in a matrix to calculate the shortest distance and its respective cost. Key Features: - The algorithm should respect origin and destination points, which will be indicated by specific row and column numbers. - Ideally, the code should be able to parse a .xlsx file format. Desired Skills: - Proficiency in Python programming language - Experience with optimization algorithms, particularly the Ant Colony Optimization algorithm. - Familiarity with .xlsx file parsing. I already have a basic code and can provide it to you as reference material; however, I need someone to improve and expand on this code to meet the requirements. It is essential for the proposed so...

...pagination, allowing users to navigate through the data in chunks. The data for the grid will be provided through an existing API, so the successful candidate will need to have a solid understanding of API integration. User interaction is another key aspect of this project. I expect the grid to support the following interactions: - **Click on rows to view details**: Users should be able to click on a row to view more detailed information about that entry. - **Edit data directly in the grid**: The grid should allow users to modify the data directly within the grid and update the database accordingly. - **Select multiple rows for batch actions**: Users should be able to select multiple rows to perform batch actions, such as deleting or updating multiple entries at once. Ideal ...

...have two formulas in conditional formatting. I thought making a cell in the below row for the date was the only option - any other options to achieve this? Column A, Row 3 contains Client Name (code), Columns B-K, Row 3 contains the course 14 x units. Column A, Rows, 5 - 19 contains student names. The cells in Columns B-N, Row 5 will include the submission options with a drop down menu or alternatively. The 5 different grading options are: Not yet started Not yet submitted Submitted for marking Partially Complete - More work to submit Competent Each cell and submission option will be selected from a drop down list and needs to have a different fill colour (#b4c6e7, #ffd966, #ffff00, #fff2cc, #92d050). The row directly below the cell will show t...

I require a skilled Excel VBA developer to create a dynamic syst...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-frien...

I'm in need of a developer to create a dynamic list system for my dealership website. This system will display users' offers for cars, ranking them from high to low based on offer amounts. Key Features: - List should be displayed in a table format, with each row representing a user's offer. - The list should auto-update in real-time as new offers are submitted, providing a seamless and dynamic user experience. - Each row should contain the username of the user, their offer amount, the car model and year of the offer, and the date and time the offer was submitted. Skills and Experience: - Experience with dynamic, real-time web applications - Proficiency in front-end development for creating a table format display - Knowledge of back-end technologies for real-...

I require a skilled Excel VBA developer to create a dynamic syst...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-frien...

...currently have a database setup in Airtable. It has all the data that I need for my dashboard inside. But special formulas will be needed to calculate certain aspects of the dashboard. Example: I receive a total of 4 individual payments from a vendor. I initially receive 3 of the 4 payments a week after the sale, but I don't receive the 4th payment until ~a month later. Each payment is a separate row in Airtable, but the grouped payments all use the same SAN#. Therefore, I need Airtable to think, "Okay, I've received the $120, $70, and $35/$45 payment for SAN# 12345, but I haven't received the $20 payment yet." The $120, $70, and $20 are always the same value. The $35 sometimes could be $45. Then the dashboard would show me which sales do not hav...

I am on the lookout for an imaginative and skilled illustrator that can transform a promotional photo into a glamourous illustration. We have a promotional photo that we need to stylize to look illustrated. This photo has 9 people in it. The base photo is provided in this bri...glamour in illustrative work. Deliverables will include the Photoshop or Illustrator files in print quality. I've included an example of the type of styling that we are trying to achieve. It borders on cartoon and stylized photo. We are after glamour, sparkles and bling in the resultant image. I would propose that for the first milestone, we concentrate on one of the girls sitting in the front row to settle and agree on the style. From there we can apply that style to the others in the shot and t...

...with Match-3 Puzzle Mechanics - Experience with Dog-Themed Games Please provide examples of similar games you've developed in the past. game requirements include but are not limited to: The game should be based on the idea of Candy Crush, however, using a dogs theme Gameplay: - Match-3 Mechanics: The core gameplay revolves around matching three or more dog treats of the same color and shape in a row or column. Players can swap adjacent treats to create matches. - Objectives: Each level in has specific objectives that players must complete to progress. Objectives may include reaching a target score, clearing a certain number of treats, or achieving a special pattern on the game board. - Obstacles: As players progress through the game, they encounter various obstacles that ...

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.

I need a freelancer with proficiency in data collection and Excel to handle a minor task for me. The project is straightforward, with only 28 rows of data that need to be collected. I'll need the following information included in each row: - 12 columns of data - Each row will contain Text, Dates, Phone numbers, Links, etc. - Other miscellaneous data related to my project requirements that need to be captured. The ideal candidate for this position is skilled in Excel, organized, and pays great attention to detail. Prior experience in data mining will be a huge plus.

...not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will be able to select 4 tariffs. These blocks with tariffs should be disabled and adjusted from the admin panel For the selected tariff, pdf invoices should be generated (the form will be provided) with the calculation of the invoice amount depending on the day of the month when the tariff wa...

...help create the file management system that will speed up our workflow. I am a general IT and live video production person who lacks the development knowledge to pick a platform and put the development out to bid. Here is a preview of the development objectives if it helps you decide if this is something you want to talk about. Steps: 1-Generate a table where each file requests exists as a row of data and the columns contain supporting information entered in advance as well as empty fields to be populated later. . 2-User interface to drag submitted files onto a field within each file request which would rename it and file it in a pre-designated folder structure. It would update the record to show the file was submitted. It would update the record each time a replacement fil...

Need an Excel VBA expert to do automate a workflow of flagging the date of the first non-zero value in a row. I'm looking for a freelancer with the following skills: - Proficient in VBA programming. - Previous experience in developing Excel automation scripts. - Able to deliver the project as soon as possible.

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

I have a very simple three js project in a website that I want to be worked on. I will supply a google sheet with 8 co-ordinates per shape, the co-ordinates are given...will supply a google sheet with 8 co-ordinates per shape, the co-ordinates are given as (X,Y,Z) The first co ordinate is made up of 3 columns named (1X), (1Y) and (1Z) they have a number in the column for shape 1 you must use those 3 numbers to generate the first co-ordinate. Then repeat for (2X), (2Y) AND (2Z) up to the final cordinate (8X), (8Y) and (8Z). Each shape is given along the same row in the google sheet, and has a hexcode colour. The shape should be filled with the hexcode colour in the hexcode colour column. If new rows are added to the google sheet the three js project should add more shapes to th...

I have a very simple three js project in a website that I want to be worked on. I will supply a google sheet with 8 co-ordinates per shape, the co-ordinates are given...will supply a google sheet with 8 co-ordinates per shape, the co-ordinates are given as (X,Y,Z) The first co ordinate is made up of 3 columns named (1X), (1Y) and (1Z) they have a number in the column for shape 1 you must use those 3 numbers to generate the first co-ordinate. Then repeat for (2X), (2Y) AND (2Z) up to the final cordinate (8X), (8Y) and (8Z). Each shape is given along the same row in the google sheet, and has a hexcode colour. The shape should be filled with the hexcode colour in the hexcode colour column. If new rows are added to the google sheet the three js project should add more shapes to th...

...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, versatility, and a deep understanding of Excel’s inbuilt functions and scripting in VBA are crucial for this project. Proficiency in creating user...

I want to create a form using google forms where: - the answers are exported into google sheets (this is done by default), each answer in a row. - the answers are exported into google sheets, but I want each answer in a new tab, and in a column (instead of in a row). The tab will have one column with the questions, one column with the answers, and one columns where I will make comments. - the answers are exported into google docs, in a chart. (for instance a chart with 3 columns, where the 1st column are the questions, the second the answers, and the third is empty and I will write comments once the answers are there.) Each answer has to be added in a new page at the top.

I have a project that involves entering text data from an Excel file into a Notion table. Key responsibilities: - Extract text data from existing Excel file or Google Sheet [3 specific cells per row. 361 rows total] - Accurately input data into a SINGLE designated field in a Notion table [361 rows total] , with each word separated by a comma. [most words already separated by a comma. This can be done with a "find and replace-all" type command] - Ensure consistency and correctness of data entries Ideal skills and experiences: - Proficient with Notion and [Google Sheets or Excel] - Excellent attention to detail - Previous experience with data entry projects.

I need a proficient web developer or software engineer, ideally someone with an understanding of Google Sheets API, to create an app script code for me. This tool will connect Buganizer to Google Sheets, pulling desired data such as: - Bug titles - Assignees - Status - Descriptions and other fields as per requirements The data should be displayed in a clear, row-based format. Experience with similar projects integrating third-party bug tracking tools (like Jira, Bugzilla, Trello, etc) into Google Sheets will be beneficial. This should allow me to efficiently track, analyze, and visualize bug metrics from Buganizer directly in Google Sheets.

I need a solution that will allow me to create a google docs file that is auto-populated from a Google Sheets file, transforming each row of data into a separate page in Google Docs. Key requirements: - Changes in the Sheets file (such as adding, deleting or updating data) should automatically update the related Google Docs file. - The solution should be designed to handle data discrepancies between the Sheets and Docs file. Although I am unsure whether I want to overwrite Docs data with Sheets information, keep both and highlight conflict, or manually resolve each discrepancy, your expertise and recommendations will be much appreciated. Ideal Skills: - Familiar with Google Apps Script - Experience with database integration - Strong problem solving abilities I'm looking...

...of products to add to this order. Each customer from an SQL table called 'customers' has its own price class 'customerPriceClass' When the user selects the number of products, the page updates and adds rows for each product with a dropdown menu where the choices are fetched from another table called 'products'. The user selects the product and enters the number of units. NEEDED: STEP1 For each row of products the corresponding price from the table 'prices' should be fetched that is associated with the customers price class 'customerPriceClass' from the first step. It should be updated next to the product number. STEP2 Upon hitting 'Submit' at the bottom of the form the number of units for each product should be corre...

am looking for an experienced Airtable consultant And Wordpress for (at the click of a button) create dynamically designed page for all others also same design - ( post or page ) Embedding data from an airtable row For each customer line in the airtable (ID), I will have the option to recreate (with the click of a button) the same page with its unique data (name, age , address, time, etc...) this page is for Digital birthday invitation . The difference between customer and customer in my website WordPress will be in the suffix for example: With a click from airtable , a message will be sent to the customer (Green api) with a link to a page that he can share. and will only open only on mobile Knowledge of WordPress, Airtable, and Make example :

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.

See the attached File. Simple project here. If any of the words in column A, sheet 2 are in column D, Sheet 1, then delete the entire row (in Sheet 1) (Delete the entire row, not just the cell) No macros Likely conditional formatting, new rule is the best. This will be used on multiple files so it needs to be quickly applied. New words will be added to the list to filter for. The filter list can be added to each new file. No Macros Type :Sponge Bob" in your bid (to sort through the spammers) This should be a very low cost bid and delivered today.

...writing) - and for both of them to be the same across all pages (and on other screen sizes) *'handcrafted, organic oils for hair and skin' written above hero image in same size, colour and font as title. *the favicons for 'holistic' and 'ethical' to be on the other side of the words for the larger screens only (to make it symmetrical - it is fine the way it is when it is listed straight down in a row for mobile) *the benefits words (holistic, ethical, organic, sustainable) to be in #476456 *newsletter to take a larger chunk of space in the middle at the bottom (roughly same size as one of the 'reasons' with same sized spacing as between 'reasons' and hero image) *'sign up to our newsletter!' in #476456. no border...

...data should be CSV files for each option contract's each day seperately segregated. For the data sources, I can find this data available on currently. => I am looking for you to find better, easier sources to scrape this which could be correct and more reliable. Please include that in your proposal icharts sub-link where i find it: Eg. Output Row I need Date Open High Low Close OI Volume Fri Apr 05 2024 09:15:00 GMT+0530 (India Standard Time) 140 144.95 99.15 117.05 4546450 4724550 Fri Apr 05 2024 09:20:00 GMT+0530 (India Standard Time) 117.05 122.75 106.8 122.05 5314100 2964700 Skills and experience ideal for accomplishing this task: - Expertise in data extraction from financial databases. - Proficient in web scraping if required. - Strong

...custom formulas based on my requirements. Key Requirements: - Automation of specific tasks: I need to reduce manual work and save time by automating repetitive tasks. - Custom formulas: I need new formulas developed to perform calculations and analysis that are not covered by Excel's standard functionality. Autocalculation Trigger: - I want the autocalculation to be triggered every time the Row is highlighted with sold green color. I have ten different columns with hundred of rows with specific beginning text "spect". When user fills a background color assume its solid green on a cell of a particular column the function should autocalculate the complete column and report the count in the dashboard the sample file for problem solving. Ideal skills and experie...

...Basic email lacks many privacy features. However, settings are available that allow users to encrypt and control emails. In this project, you will configure Google Gmail to send and open confidential emails. Launch your Gmail email account. Click Compose to open the New Message screen to create a new email message. In the To field enter the address of someone who also has a Gmail account. In the row of icons at the bottom of the New Message screen, click the icon that represents Turn confidential mode on/off (you can hover your mouse over the icons to display their functions). The Confidential mode dialog box will open. Click learn more and read about sending and opening confidential emails. Return to the Confidential mode dialog box. Under Set expiration, click the down ar...

I...my free time. 1. The links are in the spreadsheet highlighted in yellow. The script must also be easy to understand and allow me to add new tables in the future. 2. Create a macro that will extract the table from each of the links and into Excel. Because the table statistics change every day, currently, I copy and paste manually, so I want to automate it. 3. The details start from the R - Team row. 4. Compulsory for basketball to extract data in Columns B to J, and for Soccer Columns B to I 5. Only programmers with successful scraping demos will be considered. 6. The fastest who can show me a successful demo will be prioritised. 7. Looking to finish the job over the weekend. 8. All the tables must be refreshed. There is a second project after the successful completion o...

At present, we manage all our revenues and expenditures through multiple bank accounts. For different types of expenses, we use different cards - for instance, the card ending in 1234 is used for fixed expenses, while the card ending in 0123 is for non-fixed expenditures. All our receipts are sent to Receipt-Bank, which is synced with XERO. - reconcile bank accounts each month - setup invent...to Receipt-Bank, which is synced with XERO. - reconcile bank accounts each month - setup inventory management - loan interest - P/L statments - Setup up reconciliation rules Must be finished by 10th of each month Approx 400 receipt/bank statement rows need reconciling each month. In XERO, every transaction must be matched with a receipt from Receipt-Bank or reconciled from a bank statement ...

...OUTSIDE OF THE FREELANCER CHAT SYSTEM. UNSOLICITED EMAILS WILL BE IGNORED AND REPORTED *** We're experiencing problems with duplicate results when using a SELECT query in the context of retrieving data from multiple tables in MySQL. I require assistance getting this resolved. The query selects data against two tables. The selection must compare Invoice Details with PO Details to return a single row of data for each Invoice Detail record that matches the LATEST po line item within the same ITEM and SHIP TO CITY. The current SQL is generating duplicate records because it is matching against multiple PO details instead of the LATEST (newest) PO detail for that Item/Ship To City match. FILES INCLUDED: SQL File For Table/Data Query File for SELECT Statement Excel spreadsheet ...

Hello there, I need to scrape website products. Required data: title, description, specifications, product images The exported data needs to be in CSV or Excel and every product with related data in separate row. Example: title, description, specifications, image name 1, image name 2, etc. Having a background in data mining and being proficient in Python or relevant scraping tools would be beneficial. Accuracy is a top requirement.