Aspen hysys distillation column designpekerjaan

I'm currently working with two Excel sheets for inventory data. I need help with applying VLOOKUP functions to these sheets. I need the correct formula to lookup the Sheet 1 Column A data, in Sheet 2 Column B, and apply Sheet 2 Column B data in Sheet 1 Column B - please see attached. Key Requirements: - Understand and implement VLOOKUP formula to connect data between the two sheets. - Ensure the VLOOKUP function is working correctly and efficiently. Ideal Skills and Experience: - Proficiency in Excel functions, particularly VLOOKUP. - Prior experience working with Inventory data is a plus. - Attention to detail and accuracy in data manipulation. Please reach out if you're confident in your Excel skills and can assist with this project.

I have a spreadsheet of ~2100 gas stations in the state of New York. The data includes a station ID, last known brand, and street address. For each address, I need you to find the most recent but not past November 2023 (month and year shown in the corner, most should have images in 2023 available) Google Streetview images and save a screenshot of the price advertising sign for each o...screenshot, the filename should be the station id of that station from the spreadsheet. In the spreadsheet, I need you to also log some variables based on the image: if the sign is a digital display, the type of sign according to an attached style reference sheet, etc. NOTE: Some stations have changed brand, so it may be listed as a BP, but could be an Exxon now. This change can be logged in the NOTES c...

Amend table column. (Add/remove) And some issue example: Delete data immediately remove (need to refresh)

...need of a professional who can extract data from my searchable text PDF files and input them into Excel. The PDF files contain complex data layouts, including tables and images. Key Requirements: - Extract and organize the text, tables, and images from the PDF files into Excel - Maintain correct data alignment and structure - Apply basic Excel formatting, such as font styles, cell borders, and column width adjustments You are expected to: - Have experience with PDF to Excel conversions, particularly with complex layouts - Be proficient in handling searchable text PDFs - Demonstrate knowledge in basic Excel formatting techniques I'm looking for a freelancer who can efficiently convert these PDFs into Excel without compromising the data integrity and layout. If you have exp...

...on main page) where I can add notifications of changes to my companies products and new features. The blog page must fit inside the header/footer of the existing site so it is an integrated part of the web site. There will not be many blog entries - two or three a month maybe. Very few entries will have images and most will not need a “read more” button. I want a minimalist 2 column blog page ( one being the sidebar on left side ) looking something like: The main blog page: Will be minimalist like: On the sidebar, I’d like a search button, popular posts, archive and sharing entries on social media. Accessing the Blog Page: The blog page will be accessed in 3 ways: Via a "Latest News" link from the main page footer menu. ...

...name: "cola based soda with no sugar"; or "sugarless cola based soda"; or "cola soda, no sugar, fizzy drink"; etc. Combinations are endless. Our bot must identify all these possible descriptions and name the product to how we name it "Diet Coke". Dataset: Attached with dummy products (I'll share the official one after awarding). It's 735 entries two-column dataset where the first column contains the 'company's products names'. The second column contains many different descriptions. For descriptions associated with 'n/a' in the dataset, indicating the absence of a corresponding product in our portfolio. Language: the dataset is in spanish. GUI: final POV most have graphic interface -- not...

I am in need of someone to construct a power automate flow for a SharePoint Document library. I wish to add a 'last viewed' column, specifically to boost document management. I want this column to display the respective 'username' of the last viewer. Ideal candidates will: - Have experience creating Power Automate flows. - Be familiar with SharePoint Document libraries. - Possess a good understanding of document management strategies. - Know how to capture and display 'username' data in a SharePoint library.

I am looking for a Google App Script specialist to design a dependent dropdown list on Google Sheets. Your responsibility will be coding an application that enables: - Cross-referencing of data through the dropdown list - This feature should specifically be applicable to certain columns only Please make sure to link the dropdown list to column headers labeled 'Customer Name' and 'Project Name'. An ideal freelancer for this role will have experience in working with Google App Scripts and Excel, or other equivalents, and is meticulous and detail-oriented. Proficiency in managing and organizing data is equally important.

...datos: pgsql Error de solicitud de acceso a la base de datos: SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext, date_creation, tms, fk_user_creat, fk_user_modif FROM llx_categorie WHERE rowid = 457 Código de error de solicitud de acceso a la base de datos: DB_ERROR_NOSUCHFIELD Información del error de solicitud de acceso a la base de datos: ERROR: 42703: column "tms" does not existnLINE 1: ...r, fk_soc, visible, type, ref_ext, date_creation, tms, fk_us...n ^nLOCATION: errorMissingColumn, parse_relation.c:3293 We need to solve this issue. The best price and the most expert person will be selected to solve that error....

I need assistance with a very specific task: transposing customer list data from an existing Excel spreadsheet into a business plan. The format should arrange the data in a column arrangement within the business plan document. Specific elements required from the customer list include: - Telephone number - Email - Personal information Ideal candidates for this project should have experience with: - Excel spreadsheets - Business plan designing - Data transfer and organization Let me know if you need any further information to complete this task.

... The ideal person for the job is quick, efficient, and meticulous, with a keen eye for detail. The ability to understand and work efficiently with large datasets is a must. Proficiency in Excel is expected and prior experience with similar projects would be highly advantageous. DETAILED DESCRIPTION OF JOB: On the attached spreadsheet: Remove all of the accounts that are exempt from work comp (column R shows who is exempt) Remove all columns except for Business name, address, city, state zip. Then I want it broken into 4 separate spreadsheets based on Work Comp x-dates. Q1 (Jan, Feb, March), Q2 (April, May, June), Q3 (July, Aug, Sept), Q4 (Oct, Nov, Dec) Be careful when looking at expiration dates, the bond expiration date is on there, but I want these categorized by Work Comp e...

All of a sudden, the slideshow at is showing all of the slides at once, instead of one at a time. So the slideshow is the full width of the site instead of just in the right column. The slideshow should be directly below where it says "Upcoming Events"

I require a professional to write a script for Google Sheets, specifically to make Column E a "write once" column. This column will involve a choice from a dropdown menu. It's essential that once data is entered in this column, it cannot be rewritten. Ideal Skills and Experience: - Proficient in creating Google Sheets Scripts - Expert understanding of coding for writing scripts in google sheets - Experience in writing "write once" scripts Application Requirements: Please include examples of past work, especially those relevant to Google Sheets Scripts manipulation. Show me how you've solved similar challenges in past projects to make a strong case.

As a client, I am in search of a skilled Python developer with experience in XML parsing and handling database operations. I require a Python utility program to parse Talend jobs and determine source and target column details. Key Requirements: * Parse XML files - The Talend mapping file will be supplied in XML format. We're in need of someone fluent with Python's XML parsing libraries. * Extract information - The utility must be able to extract critical information including source and target table columns, as well as source and target databases. * Dynamic Output format - The extracted information must be formatted in CSV or potentially other formats. It should be flexibly designed as we will use this data to load into a database. * Database expertise - An understanding...

I am on the hunt for someone highly skilled using excel. The selected freelancer will process data from a CSV file, apply exact match criteria, then enter these matched results into another CSV file. It...removed or merged. Prior experience in data matching and a strong understanding of CSV files is highly desirable. Please ensure you can: - Handle large CSV files - Apply exact match criteria - Combine values of a column to replicate a formula - 16 columns of data combining to output a pre determined formula - match the formula across entries on another spreadsheet - 800 rows Let's maximize data accuracy and efficiency together. output formula should be as so - a:[‘number of options’]:{option values separated by ‘;’ } then inputted and matched to a...

I need to import data from multiple files that have roughly the same products in them, but it needs to show me in alphabetical order the product name in the first column and the best prices from each client in the next columns (from largest to smallest). Probably i need macros and i can`t figure them out

...messages (Messages related to SME - Small and Medium Enterprises services) 8. Airway Bill messages (Messages related to Airway bills which don't fit #2, #3 or #4 above) 9. DHLLKS messages (Messages where the sender ID in Column E says "DHLLKS") 10. DHLAAA messages (Messages where the sender ID in Column E says "DHLAAA") 11. All other messages (All other messages which do not fit into the category above but have the sender ID in Column E marked as either "DHLEXP" or "DHLLKS" or "DHLAAA") 12. Discard all other messages - You can delete any messages which have any other sender ID in Column E other than those mentioned in Point #11. What we are looking for - Your ideal skills and experience: - Excellent atte...

NEEDS TO BE COMPLETED IN 10 HOURS FROM NOW........ TOPIC- Multi-cloud approaches will lead to a breakdown of barriers between providers. - Formatted using the IEEE Conference Style Template in two column mode (Note: It is not required to create your report using LaTeX, but the report must be as per the IEEE Template). The IEEE LaTeX and Microsoft Word RTF templates can be found at: - Between 6 to 10 pages in length depending on the scope you cover. The report is quite flexible and open-ended; it defines the technologies that support and advance this trend and includes your opinions and observations about it. You are also free to provide instances of these deployments from the actual world. It is recommended that you employ several

I am in need of a highly skilled and experienced freelancer who can help me implement a new component in Aspen Plus simulation software. The specific component to be implemented is a thermodynamic property package. I have chosen the NRTL RK package. Key Requirements: - Expertise in Aspen Plus simulation software - Proficiency in implementing thermodynamic properties - Experience with the NRTL RL package and equations - Strong understanding of component property This project is focused on the Co2 capture process. The successful implementation of the EEPMA is crucial in achieving the desired outcome. The ideal freelancer for this project would have a background in chemical engineering, process optimization, or environmental studies. the graphs and data have already been tran...

Add new column to users table. Link field with another table

I have designed a medical oxygen concentrator that has a pressure swing adsorption (PSA) system for 5L/min,10L/min, and 20L/min capacity. The system works, but there are errors in the PSA system design of the system that I designed. I could not make the column pressure balance, PSA loop structure, cycle time software, and orifice design at an optimal level in my system. because of these reasons, I cannot permanently get 95.6% pure oxygen output in the system. (The system reaches 93.3% purity up to 3 liters, but drops to a value between 75-85% above 5 liters.) My wish is to optimize the PSA system of the oxygen concentrator that I designed and obtain 95.6% pure oxygen permanently over 5 liters.

Hello , I have simple job for PHP & JS Expert. I want to upload Text file and want to store text file data into database . you will have to split setance with ( dot ) and store into different column , while storing you will have connect document id , so later we can identify that data via search , its large documents ( txt ) file mainly. Bid you have expertise and experience for same I can pay 1000 INR for this job, i will share current source code and database , Further i will share FTP to upload task and make it run. I need to finish this task in 2 - 3 hrs or let me know how quick you can finish Regard

I'm seeking expert assistance with functionality enhancement in Spotfire. The primary task involves converting or standardizing table column names across multiple (more than 10) Spotfire dashboards and tabs. The goal is to produce more user-friendly names employing a mapping configuration excel workbook (db friendly name & user friendly names), ultimately facilitating data analysis and improving data visualization. The project needs to be finished ASAP. Key Skills & Experience sought: - Proficiency in Spotfire - Knowledge in Data Visualization - Advanced Excel Skills, specifically with data mapping. - Excellent understanding of database structure & nomenclature - Ability to work under a tight deadline.

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.

Create a web dashboard with analytics and login capabilities that can curd using php, mysql, css, tailwindcss. Create a web dashboard with analytics capabilities that can be curd using php, mysql. The mysql table should be configured as follows vaivo_users → table to store user information vaivo_data → table to store data for each user. It should contain a (user_id) column. vaivo_kits → table to configure curd. (user_id) column should be included.

...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 experience: - Expertise in Excel: A deep understanding of Excel's functionality and the ability to customize it to meet specific requirements. - VBA programming: Experience with VBA programming is a plus as it will be needed to create the...

...is displayed. Does the amount of available information from Wi-Fi networks to which you are not connected surprise you? Scroll back to the first column of information. Under SSID, is there a service set identifier for each network? Why would an SSID not appear? Does disabling the broadcast of the SSID name give any enhanced level of security? Why or why not? Note the value under the column MAC Address. How could a threat actor use this information? Under RSSI, the signal strength is displayed. (Lower numbers indicate a stronger signal.) The Frequency column displays the frequency on which the network is transmitting, and the Channel column gives the corresponding channel. Click Channel to sort the channels. Is there any channel overlap? How coul...

I have two Line and Clustered Column Charts (Chart A and Chart B) in my Power BI project and I want to merge them into one. The other requirement I have is to create a slicer that would allow me to toggle between displaying Chart A and Chart B data on the merged chart. I need this project completed as soon as possible.

I have a 96-page document that I'd like to turn into an e-book. I'm looking for a freelancer who can assist with the following: - Convert my 96-page document into an e-book - Must be able to install it on my WordPress site - E-book should have a single column layout - Include a clickable table of contents - Integrate embedded multimedia (videos, audio) Ideal Skills and Experience: - Experience in e-book conversion and creation - Proficiency in WordPress - Able to implement multimedia elements within the e-book - Strong attention to detail for formatting and layout - Familiarity with embedding multimedia in e-books is a plus Please let me know if you have experience with similar projects and can help me bring this document to life as an engaging e-book. I can provide fi...

I am in need of a PE in the State of Mississippi to review, modify if necessary and stamp this set of drawings for this single family home. Your main task will be to conduct a comprehensive review and provide a stamp for the column foundation structure design of the project. Key Responsibilities: - Conduct an in-depth assessment of the overall concrete structure design. - Provide recommendations for design improvement where necessary. - Provide a professional stamp upon completion of the review. Thank you, Bill Tabbert 419 902 6023

I am in need of a PE in the State of Mississippi to review, modify if necessary and stamp this set of drawings. Your main task will be to conduct a comprehensive review and provide a stamp for the column foundation structure design of the project. Key Responsibilities: - Conduct an in-depth assessment of the overall concrete structure design. - Provide recommendations for design improvement where necessary. - Provide a professional stamp upon completion of the review. Thank you, Bill Tabbert 419 902 6023

We have a quick project f...project for a Google Sheets / Excel Expert We have a Google Sheet that we need to filter and match customer names up to a sales rep. Essentially it needs to work like this: - Master customer data will go in sheet 1. This contains a list of customer names in column 1, and the corresponding sales rep in column 2. - Each week, we create a new sheet with payment data. - The payment data contains the payment and customer name. - we need the filter to match the customer name in the new sheet with the rep and insert the sales rep name in a new column. This will probably need to be done with a scrip - we need a proficient and experienced person to do this. If you have the experience, please message and I'll give you a loom video explainin...

I would like someone to add a phone number to a button in main menu Remove an element on the home page and replace it with a widget from Sourcr (instructions provided) Ensure the CSS is correct on footer as its overlapping Remove “Recaptcha label” from contact form its only on one page/contact us. The contact column in the footer on the pages needs to be aligned. Website is built using Wordpress/Astra theme/Elementor

I am seeking for a skilled PowerPoint designer to aid in the creation of a captivating, high-quality presentation. The content I will supply involves text ...captivating, high-quality presentation. The content I will supply involves text and categories. Please see the attached. Each or can be 1 slide or rows with the same categories can be combined, based on how it looks. Titles are in bold within the content (3rd column). Has to be CEO level of design & professional feel Key Responsibilities: - Layout design, formatting and image/graphic - Develop a professional and engaging visual narrative Ideal Skills: - Proven experience in PowerPoint presentation design - Strong creativity and design skills - Understanding of corporate needs and executive ...

...repetitive tasks to increase efficiency - Creating custom macros to fulfill specific needs - Developing interactive forms, enhancing our team’s productivity The Word document essentially consists of tables. The tables have different numbers of rows and two columns. The first column should only contain text. There should be a checkbox in the second column. The checkboxes should initially be hidden. The checkboxes should only become visible when you activate the “Show all” function. If the check box is selected, the text in column 1 should have a specific target style assigned to it. If the check box is cleared, the text should be mapped to another style that is defined to have the text hidden. If I deactivate the "Show all" function ag...

...17:15 1832.7 1832 31/05/2023 17:20 1833.1 1832.5 31/05/2023 17:25 1832.9 1832.3 31/05/2023 17:30 1833.1 1832.4 31/05/2023 17:35 1832.7 1832.3 31/05/2023 17:40 1833.3 1832.7 31/05/2023 17:45 1833.3 1832.9 31/05/2023 17:50 1833 1832.5 31/05/2023 17:55 1834.3 1832.8 31/05/2023 18:00 1834.5 1834.1 End_time To calculate Long_trade you need to use High column to return the highest profit for Long_trade  and the low column for a Long_trade_stop_loss Starting with the first row of the "time-frame" (17:05), we need to define verifiables: Open_range_high = 1833 Open_range_low = 1831.5 Long_entry_stop_loss = 1831.5 Open_range = 1.5 Then we move to the next row (17:10) and check whether High in this row is greater than Open_range_high if not, we...

...include 10-14 pages of text and 15 related photos. The successful freelancer will be tasked with: - Formatting the text and images into a single column layout, given the skipped preference - Skillfully integrating the 15 images within the document without disrupting the natural flow of the text - Adhering to a professional and clean aesthetic throughout the document If you can change that to work in pdf I have 15 pages written up like that While answering the following questions and ensuring their skills align with the tasks at hand, freelancers applying for this project should clearly state: - Their prior experience with PDF formatting and document design - Specific instances where they've worked on similar projects, ideally involving legal documents For this pr...

The project comprises three main components: OpenAI Operations: This phase involves managing all OpenAI-related tasks. UI and Settings Page: Development of a user interface for prompt control, addition of API keys, and integration of a new column into the existing PHP page. Implementation of error handling and secure password protection is also included. Zoho Integration: Execution of Zoho API operations, encompassing all necessary steps from zapier

$10- Task - We are looking for a developer to help fix our Zappier Currently we have a functioning webpage where images are uploaded processed through OCR and the data is then sent to via Zappier. We need someone to do the below: - Fix the problem, stopping the data being sent to (Only one column, which is the issue) Components: - Webpage its hosted- Godaddy - Zappier zap functioning sending data to

Looking for someone who can assign the correct number of leads column to the right number in the zip code column. I have a video here instructing exactly what I need. Essentially, we have two lists of zip codes and we need the first list of zip codes align to the number of leads we have assigned to list #2 of zip codes.

Check and solve issue. Add a new column into table and API

Check and solve issue. Add a new column into table and API

I'm looking for someone experienced with Ansys or similar CFD software to design an extruder die that can create a multiple revolution helix. The perfect freelancer for this project will have a solid background in Computational Fluid Dynamics (CFD) and expert-level knowledge of Ansys or equivalent and some plastic extrusion understanding. Some critical aspects to consider in the modelling are: - High dimensional accuracy, while managing a linear velocity gradient across the width of the extrusion - A flat bottom and side walls, perhaps using co-extrusion as a way of delivering this - Some insight and design of tooling for handling the extrudate from the die as it solidifies into the helical column. Overall, this project requires a creative intuition a...

...simulations, finalizing Process Flow Diagrams (PFDs), and determining the essential equipment list for a LNG project. Key Responsibilities included: - Developing accurate and detailed PFDs - Creating a comprehensive equipment list - Conducting rigorous simulations Experience & Skills: - Extensive experience in the oil & gas industry, with prior work on LNG projects - Proficient in using Aspen HYSYS, ChemCAD, ProMax for running simulations and other relevant tasks - Strong knowledge in evaluating complex systems in the industry Timeline: Although project timeline may vary according to the scope, I expect consistent professionalism and commitment throughout the project lifecycle. Candidates demonstrating a strong track record in similar roles in the oil...

...buildings. The primary task features the comprehensive design of the structure. The successful freelancer should be able to provide: - Proven experience in designing residential structures - Exceptional knowledge in compliance with building codes - Excellent design skills, maintaining the integrity and safety of the structure This is focused on concrete column, beam, post tensioned cast in place concrete. Standard dimensions length and width will be in the 35 to 40 feet for routine stressing of tendons. The cast in place will be within a stay in place precast concrete wall system, which serves as the finished wall service, exterior and interior. Most standard materials are eliminated, creating simplicity and economy. My preferred design is a pe...

I require an expert in Google Sheets and ChatGPT to create a system where column A holds factual statements, and column B generates a unique ChatGPT response based on the statement in column A. The prompt will remain constant, with only the input from column A changing the outcome. Ideal Skills: - Google Sheets proficiency - Experience with OpenAI's ChatGPT or similar AI based conversation models - Strong understanding of how to integrate API-based response generators into spreadsheets - Ability to execute tasks seamlessly without creating duplicates or errors. Experience: - Past projects involving integration of AI chat models and spreadsheet software will be advantageous. Note: There is no need for verification of the uniqueness of responses, so you...

Hello I have excel file with many products link in side by side and product serial number in column 1 can you make alll links into rows as per there respective serial number?

...select the bill image from their disk. Step 3: Utilize an OCR (Optical Character Recognition) plugin to extract data from the selected image. This extracted data is then compared with existing data in the PostgreSQL database. A popup will display the mapped data and additional information. Unmapped data will require user intervention for mapping. Step 4: The bill image may have variable column structures, such as vendor information followed by product details like a product grid and total discount/net amount information. The system dynamically reads and processes these columns. It identifies potential matches for the products and flags unmatched data for user mapping. Step 5: After reviewing and confirming the mapped data, the user can proceed by clicking an �...

I need a skilled WordPress developer, with experience in Bookly Plugin customization, to modify my invoice form with an additional drop-down column showing payment method options. This drop-down column should include but not be limited to: PayNow, HitPay, and Bank Transfer. A deep understanding of payment integration is vital for this role. The goal is to provide a range of payment options for the convenience of our users. The freelancer should also have a keen attention to detail to ensure the changes seamlessly fit with the established design and functionality.

...colors and fonts into the design of the template. Design: Create a layout that adapts well to different screen sizes, including desktop and mobile devices. : Ensure the template is accessible and complies with accessibility standards. 6,Cross-Client Compatibility: Test the template across various email clients, with particular focus on Outlook versions. : Provide documentation or guidelines for using and customizing the template in popular email marketing platforms, if applicable. Deliverables: -Fully functional HTML template compatible with Outlook. -Documentation or guidelines for using and customizing the template. -Any necessary assets or resources used in the development of the template. Key Requirements: - Design concept: The template should