Column splitter jqgrid jobs
...efficiency and save time by eliminating manual work. Ideal Skills and Experience: - Strong knowledge and experience in Microsoft Excel, specifically in creating custom scripts and formulas - Proficiency in Office Script in Excel - Excellent problem-solving skills and attention to detail Requirements: - Develop a custom script formula that adjust rows dynamically according to the last row pasted into column A pasted into the worksheet. For example. If active sheet has new rows pasted onto it, it should automatically delete all previous data below the last row. Then this new data should populate connecting sheets the same way (delete old rows underneath) I will provide the file that the data is to be pasted from. and the file it is going to. - Script must be compatible w...
...Digital Ocean as well. DESIGN CHANGES: - When you click the color picker you can get off of it by clicking off screen. - Be able to change the color or column names and titles. - Remove footer border radius. - Column side borders should be only on the inside width at least 10px side padding. - Add side border color option. - Column use accordion should reflect on front-end. - Font size should change but only when they preview as we don’t want to mess up the UI. - Delete sub-menu use accordion. - Social media text needs Capital letter. - Logo float bottom, needs to be inside the container. - Footer preview needs to stay within view. - Delete column size. - Text Align needs to align all items Video Link for better understanding: I want
Hi all I'm looking to search roughly 500 to 1000 URL's that i would input manually, for about 1000 different words that are contained in a column for an Excel spreadsheet through code in Python. I would like the results of the search to show the URL address that it matches and the row of of data that is matched in the column of the excel spreadsheet. Thank you in advance
...number, then the corresponding columns, that need to be placed under the user defined headings. That are Details, Amount and Date, listing the current imported column headings letter. (As in example) As I would like every file import to be loaded on ether the “Data” or “Transactions” Tab as “A” Details, “B” Amount, and “C” column as Date. Then all I need to do is add new Tcode to the imported “Transaction” column, as long as the date goes under the Date_1 heeding and Amount under Amount heading on the “Transaction” tab all should work from there. If the program just checks the list of account numbers only and import to the column order listed it should be job done. ...
I need someone to input data into an Excel sheet after verifying links. The data will consist of both numbers and text, and there will be less than 10 columns and 50 rows. I require basic formatting such as column headers and proper alignment. Ideal skills and experience for this job include proficiency in Excel and attention to detail.
This is not project for junior. If you are junior please do not apply for this project. I am seeking a skilled professional with expertise in P...will change. -FC example: Include ALL ROWS where FC except: 1010E, 4143, 3057 -GL example: Include ONLY ROWS where GL in RANGE 30000->99999 AND ROWS where GL = 23400 -PC example: Include ONLY ROWS where PC = 0 -AF example: Include ONLY ROWS where AF in RANGE (one of 26 RANGES) Sheet TLR: col A -> D: Values you need to filter by col J -> M: Evaluation that needs to be evaluated of every column filter 1=INCLUDE, 0=EXCLUDE col N: FINAL EVALUATION that needs to be evaluated = means if any of col J->M = 0 then 0, else 1 Blackmailing proposals and communication will be rejected with any further notice and future cowork. P...
Hi, I need a Windows/mac database that will allow browse and view the Dicom folder from a library using a Dicom viewer application (Horos or Osirix); choose Dicom images from a folder and store the selected image (one for each cell) in separate folders for each column with a new name for the image based on the row name and column name.
...• Tracks – e.g. Bairnsdale, Ipswich…Bankstown…Addington..Warrnambool on 01/05/2023, etc • Races – e.g. Bairnsdale Race 1, 2, 3, 4, 5, 6, 7, 8 and 9, etc, and so on I have included an example of the output file I would like and the data I want collected. I have included an example of one race from 01/05/2023 from each of the three racing codes. The last column in the main table (BSP v Tote % Better) is unnecessary. I do not need that column. I can calculate it myself should I wish but you can include that data should you wish. The last row/s below the main table sometimes contains “scratchings” (see Bairnsdale Race 2 on 01/05/2023 for an example). I am not interested in this data. It is irrelevant. If it is easy to collect,...
i want to convert information from several ODBC connections and display it on a shareable website with some basic column header filter choices. This data would need to refresh itself every 5-10 minutes and have some field include some background calculations on some of them.
I have 142 companies, need to look at their web profile (click link in column A) and transfer 7 fields of data to XLS for each listing.
I have 2 google sheets with live population of data from 2 different google forms. I have 2 people counting stock and I would like to check if the data is correct. Create a formula for me to compare 2 sheets of data to each other. First find the match in the fourth column of each sheet. Then find the match of the fifth column in each sheet. Only if both the fourth columns and both the fifth columns match, then only must the sixth column be compared. If the sixth column does not match, an ERROR message must be shown. An email must be sent to me if data does not match. The sheets are always live as they are responses to google forms
...need the subscription is include the status of subscription First if the company is sign up is select the package in interview outportal then the company should be to pay via paypal to change the status of subscription from new to preparing then in preparing the superadmin should be to contact to the company by appear the contact info in manage subscription filtered the subscription by status column then the superadmin take all the api keys to activate the services and help the company to start and work fine then superadmin is click in action activate to change the status of subscription activate then the company is can to cancel the subscription and the superadmin to reject the company and the superadmin is can to make the company is preparing from new because he have another p...
Take a list of values in one column and match it to the best category in another column. Essentially you are building a lookup list.
...the horse So Si Bon This horse recent runs are shown in full detail The data I need is listed below through my explanation of each column and as shown in the Excel attachment which has the information I copied from So So Bon’s career record. If it is easier to scrape all of what is published that is fine as I can delete extra information I do not need. Column 1 Race Result Column 2 Track where race took place Column 3 Date ( I prefer the order year, month, date i.e, If March 4 2023 I would like 230304) Column 4 Distance of race Column 5 Track Condition (how dry or wet the track is) Column 6 Race Name If an important or rich race will be in CAPITALS Column 7 Class (the class of the race where Group 1 is the best and Ma...
Looking for someone to copy across website page and post content to a new WP website using WPBakery Page Builder (Salient Theme). The current website is using ACF fields. Overall front-end design and column layout needs to be converted to Page Builder modules including: - Rows and Columns - Buttons - Images - Content Carousels (sliders) - Etc Original Website: New Website: Content to be copied/migrated: - Menu Structure - ACF Field Content - WP Posts (72) Keep URLs - WP Pages (87) Keep URLs - WP Media Library I will provide access to MySQL database, SFTP credentials and wordpress administrator login. Process: Migrate a couple of posts and pages for approval and checking layout of block modules.
Scrape idealista using Python and output the results in a data-frame (CSV works). Each row is a listing, and each column a feature: price, # of bedrooms, sq m, location, etc.
I am looking for a freelancer who can help me generate an Excel file from Gravity Forms entries using the Microsoft Graph API. The ideal candidate should have experience wor...from Gravity Forms entries using the Microsoft Graph API. The ideal candidate should have experience working with both Gravity Forms and Microsoft Graph API. As I have a Microsoft 365 account, I would prefer to use it for this project. I will require advanced level of customization for the Excel file, which involves complex data manipulation. We need that excel file still editable in other column and can be also updated from Gravity submission. If you have experience with both Gravity Forms and Microsoft Graph API, and can deliver an advanced level of customization for the Excel file, please get in touc...
Data Visualization and...data visualization tool that can generate a PDF report. The ideal candidate should possess the following skills and experience: - Proficient in Python programming languages - Ability to work with numerical data and create bar/column charts - Familiarity with data visualization libraries such as Matplotlib, Seaborn, or Plotly - Experience in generating PDF reports using Python libraries such as ReportLab - Ability to customize the tool based on my specific requirements The project requires creating a custom Python solution for visualizing numerical data using bar/column charts. The tool should also generate a PDF report based on the visualized data. As I have a specific reporting tool in mind, I require a freelancer who can provide a customized solut...
I am seeking a skilled professional with expertise in PowerBI, PowerQuery, and SQL to complete a project for me. Please carefully review the project documentation before applying. Candidates who do not demonstrate a thorough understanding of the project requirements or fail to provide adequate...then it is not RANGE but 1 value only = Code -FC example: Include ALL ROWS where FC except: 1010E, 4143, 3057 -GL example: Include ONLY ROWS where GL in RANGE 30000->99999 AND ROWS where GL = 23400 -PC example: Include ONLY ROWS where PC = 0 -AF example: Include ONLY ROWS where AF in RANGE (one of 26 RANGES) Sheet TLR: col A -> D: Values you need to filter by col J -> M: Evaluation of every column filter 1=INCLUDE, 0=EXCLUDE col N: FINAL EVALUATION = means if any of col J-&g...
...Digital Ocean as well. DESIGN CHANGES: - When you click the color picker you can get off of it by clicking off screen. - Be able to change the color or column names and titles. - Remove footer border radius. - Column side borders should be only on the inside width at least 10px side padding. - Add side border color option. - Column use accordion should reflect on front-end. - Font size should change but only when they preview as we don’t want to mess up the UI. - Delete sub-menu use accordion. - Social media text needs Capital letter. - Logo float bottom, needs to be inside the container. - Footer preview needs to stay within view. - Delete column size. - Text Align needs to align all items Video Link for better understanding: I want
...List and Table: For each user role (two exactly), provide a list of proposed requirements and specify which ones have been implemented. Create a table that includes the following columns: ● Requirement ID (e.g., R-01) ● Requirement Name (e.g., User Registration) ● User Role (e.g., Customer) ● Implementation Status (Implemented, Partially Implemented, Not Implemented) ● Manager’s Note (leave this column empty) After presenting the table, list (only) implemented requirement with a clear name and provide a brief explanation. (b) (3+3 pts) For each user role, provide the use case diagram with all the use cases and actors. (c) (3+3 pts) Describe in detail two use cases using the activity diagram. Choose the most complex use cases. (d) (6 pts) Software qualities: Correctness, Tim...
I am looking for a Freelancer took look at the 1,900 entries I have in a PDF Document (5 of them). Find the entry in the Excel document by Name of Item and Room then look up the price of the item on a large vendor website (Amazon, Walmart, Target, ...) and report the price in the Cost to Replace Pre-Tax (each) Column.
I am looking for a Drupal developer who can help me fix a misalignment issue, its not a css problem. Somehow they made a change in the admin area and School Name moved to the next row, ill post a screenshot of what it should look like and the wrong look. I will give you access to the dev site.... But afterwards, I will need to make the same fix on the live site... looking for a developer who can start working on it today, its a small job and shouldn't take too long.
We are looking for a backgrounddesign for our new liquid detergent column. The detergent is sold in bottles which are refillable. The refillable detergent is stored in a transparent column. Find the picture attached (). The background of this column should cover the philosophy of the product, the zero-waste sign (see attached) and maybe parts of the wasolo logo (see attached). The board could have a contour-cut and does not have to be rectangular. Dimensions of the column: Hight: 113 cm Width: 13,5 cm Dimensions of the desired wall: Hight: 150 - 200 cm Width: 30 - 50 cm Information about the detergent: WASOLO PROVIDES SUSTAINABILITY IN FOCUS Through domestic production short transport routes, a 100% biological concentrate and the reuse of bottles, a sustai...
I want an excel file with two columns and 1500 rows The first column is an explicit text consisting of one, two or three words The second column is the ciphertext of the first column using the Blowfish encryption algorithm Note / I can give you a website that you use to encrypt the ciphertext Duration of work / one or two days only
...work hours/ Specifically, I am looking for someone who is proficient in using conditional formatting. I have times on the y-axis of my spreadsheet, ranging from 8:00 AM to 2:00 AM, and dates of the month on the x-axis frozen atop my spreadsheet. I enter the hours I worked with regard to the time and day. If I work a 2-hour shift at 4 pm on May 6th, I put, in a cell two cells before 4 pm in the column that says May 6 at the top, "UP (2.00 h)", which means 2 hours unpaid. I then highlight from the cell parallel to 4 pm to the cell parallel to 6 pm a colour, and put two cells under the 6 pm the total I earned from those hours. I want to be able to enter the hours I worked, "UP (2.00 h)", and have it automatically highlight the cells proportionate to the number of...
I need someone to merge two Excel sheets with different column headers and automate the process using Python. The final output should be in a new Excel file. The merged data will be used for reports. Ideal skills for this project include proficiency in Python and experience working with Excel. I am familiar with working with python and even take halped from GPT but I don't have that time for it
...script that reads 5 different types of csv files and saves to a Postgres database as binary (bytes), column data and enums, but the script is not working 100% as expected. You will have to: 1) re-create on your computer the Postgres DB with the script I attach in this zip folder 2) run the "insert_marg.m" script to read all the files of the Zip below 3) check the DB to see if the data has been inserted correctly 4) In "RalusRaws" databse table: - check that column MSGID and RECTIME hold correct data (and are not interchanged: compare with the text file) - check that each of the 3 files write data in the correct columns and missing columns in each file are left empty in the databse - substring column names in data field for files *.stk and *.tcr ...
I would like create a python scraper that works on MAC that would allow me to select a list of urls from a csv input file and check each url to one after other to find contact information such as: Address Phone Number Email The output file should contain the original url list in column A as well as the address, phone, email in separate columns. See example attached. Tips: The URLs in the list are all e-commerce websites so the contact info is typically found in the bottom footer, top header or even on a contact us page. It may also be possible to grab some contact info information directly from the tags in the code. Thank you!
Powerscript Developer Needed to Send Emails from CSV File I am seeking a skilled Powerscript developer to create a script that can send emails from a CSV file. The ideal candidate will have...- The CSV file will contain the necessary information to send the emails. - The script should be able to handle errors and provide clear error messages if necessary. Here is the sequence of the execution Lauch script Credentials / password are promted; user must entered for Prompts the user for body of the email looks to a specified location for a csv file with at least one column named emailadd Sends email If you have the necessary skills and experience to complete this project, please submit a proposal with your relevant experience and estimated timeline for completion. Thank you.
...Beds, Baths, Square Feet, Longitude & Latitude, a URL for the main picture, etc. This will be used to create a Google Product List for Real Estate homes so we will be using their template. - From each of the URL's that were scraped and listed in the Google Sheet - each URL must be visited and information regarding the type above ie. MLS #, Address, Home Price etc must be entered into the proper column. - The longitude and latitude may need the Google Maps API to determine based on the address - however, I do believe that information is on the URL page source code so can be located with some advanced targeting. - Lastly, you will install the FB Pixel codes needed to track the content_types and content_ids () We do have access to https://www
Look up a list of 450 companies from a particular country and sector from a website and find former general managers on linkedin from those companies (we estimate there may be 1-3 former managers of each). Put the name in an excel and a link to the linkedin profile in a column.
...CHANGES: - Hover over the tab on main screen animation and hand icon. - Hover over elements needs to be present. - Make column on the left smaller in width and column on the right bigger, by 15px each. - The ‘Add Menu Item’ tab needs to be able to be Link, Text or Image. - When you bring up the link box, it needs to have Shopify built it Autosearch. - The Menu drag function is not good - this needs to be more fluid and understandable for the user. - All menu tabs need to be able to move. - Logo box needs to show default 150px width. - All text needs to be the same. Title needs to be bold and bigger. - When you slide down the Footer preview box needs to stay within view. - Column hide or show should work like it does in the Mobile view. Video Link for be...
Woocommerce customisation (some custom functions, some form customisations), wp store-front css customisation to meet t...(like under all selected goods with sentence "Valitud Sündmus:" + selected event. Also the events, what are "overbooked" must be shown in the dropdown list red-colored and in italic and the events in the dropdown menu must have stock quantity what are not used as product names if You preferre woocommerce stock as a product name And the final is to modifie the css to line up the colums (price column is not the same ordered) Please no "plugin masters" bids! Only WooCommerce longtime developers Also the bid must include 15 day cosmetic "bug fix" support, like we need to see some value in the order form, confirmation ...
Hi! I am looking to fetch and integrate the price and market cap data and some other column information of all crypto coins which are in the market into Google Sheets using coinmarketcap APIs. I require the technical expertise to get this large amount of data accurately and quickly into a few google spreadsheet tabs. I need to track the current prices and market capitalization of each coin. This information will be used to produce reports on the performance of the coins and the overall market performance. So, if you are an experienced programmer who understands how to use Crypto APIs to gain access to market data then please do apply to this project. please read the brief below- google sheets link -
SSH@ICX7550-48P Switch#sh cpu tasks top - 00:50:04 up 2 days, 5:22, 1 user, load average: 2.26, 2.29, 2.33 T...0 0.4 0:00.00 S `- itc 1708 root -18 0 109.9m 15.2m 0.0 0.4 0:00.00 S `- ZMQbg/0 1709 root -18 0 109.9m 15.2m 0.0 0.4 0:00.00 S `- ZMQbg/1 2154 root 21 1 757.1m 438.6m 57.1 11.2 2687:34 R `- appl Above is the CPU task output Task: ====== Need to write python script to read column 7(%CPU) in above output and put them into list except the CPU values mapped to appl, top process in last column. compare values between all float values, get the highest (%CPU) value mapped process eg, watchdog. Insert the process output to below command cpu_sample_task_name_output = ssh_conn.send_command('dm cpu...
First task: There is an existing plugin enhancing purchase overview with column of number of invoices. After moving to another hosting provider the value of invoice number in column remains empty Second task: Backend only works correctly in Firefox. Using Chrome or Edge causes problemns leaving the backend unusable. Third task: Prepare shop for using emoticons in url, should be an htaccess issue Fourth task: There is an existing Exit Intent Popup, unfortunately it is not working like it is supposed to be. E.g. not (always) shown after defined rules. Give it some short testing and you`ll see immediately Fivth task: Please summarize solutions in a short description for each and illustrate technical solution / changes
Need someone to consolidate my idea into a mechanically optimized drawing. I'd like it to be as compact as possible, use as few pieces as possible, and have it look like a professionally drawn system. The piece that moves up and down should travel 5-6 inches, with a 2" diameter hole. 3 degree draft on parts. Default position should be at the top of the column. I've been able to make it travel the full 6" with only 1/4 turn. If it can be less, even better. Anyway to design it so that it returns to the default position slowly?
I am seeking a freelancer who can assist me with an Excel project. The data is currently organized with each group id in a separate column. I need the freelancer to compute the percentage value for each group id. No additional data processing or analysis is required, only the percentage calculation. The final output should be percentage values in a new column.
I am looking for a p...Banknifty wnd Finnifty) to command prompt when the script is run. The main task of the script is to running a query against the NSE API to pull NSE Option chain data. The timing should be set to continuously refresh the output dataset. The data required should be the complete option chain data set. The output data should be presented in a structure as suggested in the attached file (especially the column titles). The very reason for fetching the option chain is to perform analyses like volatility skew etc, so data should be easy to manipulate and analyze. Accuracy and effectivess and ease of use of the code are kf essence. I look forward to seeing what can be accomplished with this script, so please let me know if you think this is something that you can ...
...ONLY We worked with a previous developper and after many hours, he couldn't do the job and broke our site several times. We have an image gallery on a page, and we want it to show the thumbnails with their good quality. Here is the CSS code : .mh-gallery-square .et_pb_gallery_item img { position: absolute; height: 100%; bottom: 0; object-fit: cover; } When we use object-fit: cover; the grid (column and lines) is perfect, but the quality of the thumbnail is bad. And we use object-fit: contain, the quality of the images are good but each thumbnail have a different size and then the gallery is very ugly. See attached file We need the good display of the grid (thumbnails should be the same size) + good quality (its ok if the images are cut ! We don't want them to be co...
I...2x15).tif". I need Cell B1 to auto populate with "12.2" and Cell C1 to auto populate "15". The goal is to list image file names in column A, these image file names always include the size in parentheses in this format: _(BxC). I want column B to return the first numeral and column C to return the second numeral. Some of the sheets will have just a few file names and others will have hundreds of file names. I do not know how to write this formula. The consistent will always be a file name in column A with the size in parentheses. The information always needs to come from between the _(BxC), where B in this example is placed in column B and C is placed in column C. In some files their may be other parentheses but no...
We are looking for a PowerApps application, that * has a user frontend, for users to query the database table (Dataverse possibly) for data * has a manager frontend to put data into the database table * has a moderator frontend to query and manage the data in the table (moderator view) Details: * The database part is ...frontend should allow the manager to enter new rows into the table, * the moderator frontend should act in a similar way as the user frontend, with the difference that on the result page, the referenced rows should be changeable / deletable. We currently anticipate the following columns in the database table: * id : bigint, primary-key * name : varchar(500) * reference : bigint -> references id-column * reference_type : varchar(1000) * type : int * comment : v...
Hi there, We need a CSS expert. We have an image gallery on a page, and we want it to show the thumbnails with their good quality. Here is the CSS code : .mh-gallery-square .et_pb_gallery_item img { position: absolute; height: 100%; bottom: 0; object-fit: cover; } When we use object-fit: cover; the grid (column and lines) is perfect, but the quality of the thumbnail is bad. And we use object-fit: contain, the quality of the images are good but each thumbnail have a different size and then the gallery is very ugly. See attached file We need the good display of the grid (thumbnails should be the same size) + good quality (its ok if the images are cut ! We don't want them to be compressed, reduced or enlarged).
I have a list of 217 hospice names and addresses in the UK. I also have a map of the UK showing the 42 Integrated Care Boards. I need someone to determine which Integrated Care Board each hospice falls under based on its address. I have two columns for the hospice, Name and Address. The third column, "Which Board," needs to be filled out after matching the address to the board map. If you understand the project, please start your bid with "UK Healthcare." Only 217 entries need to be matched. The budget for this project is tight: AUD 10. No exceptions, please!
Scenario: A laptop shop buys laptops/computers from manufacturers and sells it to various customers which may be individuals or companies. Orders for computers can be placed for the manufacturers. Likewise, customers can place orders for c...information about the laptop is as follows: { Razer Blade, Razer, $2000, 20, i7 7th Gen, GTX 3060 XPS, Dell, $1976, 15, i5 9th Gen, GTX 3070 Alienware, Alienware, $1978, 24, i5 9th Gen, GTX 3070 Swift 7, Acer, $900, 12, i5 9th Gen, GTX 3070 Macbook Pro 16, Apple, $3500, 10, i5 9th Gen, GTX 3070 *1st column contains the name of the laptop, 2nd column contains name of brand, 3rd column contains the price of laptop, 4th column contains the quantity available, 5th column contains the processor details, 6th column c...
Hello, I'm looking for a designer to assist with an electrical/solar design. Gerges Electrical has been engaged to design and construct a street light powered by solar panel. The solar panels are positioned approximately 50m away from the street light. The streetlight column will be fixed to a concrete block, and a stainless steel IP56 box to house the batteries, charge controller, inverter, etc. The design scope includes the following: - safety in design report - electrical schematics and single line diagrams (including any protection required) - electrical calculations This project is located in Sydney. The designer must have local knowledge of standards and requirements for electrical design. Please let me know your thoughts and if able to assist. Much apprecia...
Exact requirement is program should read each row of txt data and when it matches the name we require it copies the value of data from column B of the text file. and then it paste that data to a required cell in the Excel file.
