Unknown column clause työt

I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. Looking forward to se...

I'm currently in need of a skilled engineer with experience in structural analysis, particularly with steel structures, to help optimize the design of my project. Project involves suggesting furnace column, beams , plates etc sizes as per Australian standard, and material sizes available in Australian market. Key Responsibilities: - Conduct a comprehensive structural analysis of the steel structure - Analyze and interpret the results for optimization recommendations - Make design suggestions based on the analysis - Ensure the structural integrity of the steel structure Ideal Skills: - Proficiency in AutoCAD - Previous experience in structural analysis and design - Knowledge of steel structures - Ability to provide actionable design suggestions based on analysis - Strong anal...

I'm in need of a marketing specialist to help with a B2B product marketing project. The main objectives for this campaign are: - Increasing brand awareness - Generating leads - Boosting sales Your focus should be on creating an strategy with clear execution steps and compelling content to update the website...barriers enabling Issuers (private companies and funds) to find the perfect investor match within seconds. Investors can now source the most exciting opportunities whether they are private companies, funds or even other Investors, for their primary and secondary share sales. Financial Advisors and Broker-Dealers can now gain access to issuers and investors from anywhere in the world who are unknown to them, to close their deals faster, or grow their busine...

I'm in need of a structural engineer or a person with a relevant background in load-bearing support. The project involves the use of I beam sections, particularly an ISMB-300 beam acting as a column and another ISMB-300 beam acting as a beam. Specific Details: - The ISMB-300 beam will connect to the web of an ISMB-500 column. - The ISMB-300 beam will connect to the flange of the ISMB-500 column. - The connection will be executed by 3 - 20mm diameter bolts. - The I beam sections will be put to use in an industrial environment. - The load anticipated for these I beam sections is a medium load, ranging from 5 to 15 tons. Ideal candidates for this project should have a strong understanding of load-bearing support structures, and experience in designing and impleme...

...necessary, but ensure a master sheet includes all fixtures. 3. **Time Conversion:** - Convert match start times to both UK and New Zealand time zones. 4. **Stadium Information:** - Include the stadium name and city where each match is being played. - Use the provided Google Maps link to determine the distance from Sidcup, UK, to each stadium. - Include this distance in the relevant column. 5. **Google Sheets Setup:** - Create a well-structured and easy-to-navigate Google Sheets document. - Ensure all columns are labeled clearly and the data is sorted correctly. - Share the final document with [Your Email Address]. **Deliverables:** - A Google Sheets document containing the complete cricket schedule. - The sheet must be shared with edit access to [Your Ema...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specifically adjac...

Hi! About Us: Harmonic Homes is a visionary company dedicated to empowering individuals to build their ...Design -Product Design -Rendering Budget: We’re budgeting approximately $120-$200 for the entire project. Application Process: Express your interest in the job by replying to this posting. Send a quick message to introduce yourself. If interested, please redesign and submit 1- 3 of the following slides: Page 3: “Problem” slide Page 5: “Unknown Cost” slide Page 6: “Solution” slide Note: if you choose to submit just one slide, please do the "unknown cost" slide. Upon receiving your submission, I’ll review and follow up if you are a good fit for us to work together on the full project. Thank you for consid...

...“1- A Court before which a dispute is brought in a matter covered by an arbitration agreement, shall declare the inadmissibility of the action, if the defendant has raised such plea before submitting any request or defence on the substance of the case, and unless the Court finds that the arbitration agreement is void or incapable of being performed. 2- Where an action referred to in the preceding Clause has been brought, the arbitration proceedings may nevertheless be commenced or continued, and an arbitral award may be made”. This provision is parallel to Article 8 of the Model Law which provides that “(1) A court before which an action is brought in a matter which is the subject of an arbitration agreement shall, if a party so requests not later than when subm...

As the project owner, I'm seeking a professional skilled in Pine Script with experience in retrieving code from private scripts on Trading view. The key objectives of this project include: - Extracting the Pine Script code from a specific invite-only script (the script name will be shared privately upon project commencement). Unfortunately, it's currently unknown which specific script to be used, but clarity will be provided as the project progresses. - Discern the implemented functions within the script. The functionalities mainly centered around recognizable trading indicators like Moving averages, Pivots, Fibonacci and MACD. - The code extraction should consider compatibility with variable timeframes. Whilst exact timeframes aren't specified yet, flexibility sho...

I have an excel file, need add product categorie on a column - budget 100€

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential for automation: I'm not entirely sure if I want the macro to automaticall...

...for an expert to help me fix an error on my website. The site is not specified as to what the problem is and I would need a thorough diagnosis and resolution. Additionally, I'm experiencing some uncertainty with my Google Merchant Center listings, but I'm not sure of the details. Key Responsibilities: - Diagnosing and fixing errors on my website - as the specifics of the issue are currently unknown, an analytical approach and problem solving skills will be required. - Troubleshooting and correcting any issues in my Google Merchant Center listings - this may involve identifying missing products, incorrect prices, or discrepancies in product descriptions. Ideal Skills and Experience: - Proven experience in website troubleshooting and error resolution. - A thorou...

...for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell. The excel file has 5 columns: 1st columns is for Brand 2nd column is for Model 3rd column is for Color 4th column is for Price 5th colums is for Quantity in Stock We want to realize a simple php page with a form to send an email with the chosen products. We need that someone just fill the database wkth the data we have in excel file (about 350 lines) To access the page we need a login page. We need 2 levels: 1 level: administrator 2nd level: agents One...

...exist in Excel, create it 2. When a record exist in Excel and Access (based on field: EL_NO, UPDATED ALL FIELDS FROM EXCEL AND OVERWRITE ACCESS FIELDS except THOSE FIELDS IN Access starting with FINAL_ and user data entries. 3. In excel files there it is possible to exist duplicate entries (based on field EL_NO). In that case remove duplicated and leave the record which has a value (<>NULL) in column TEL1. If none has, then leave any of those. In Microsoft Access will exist the following tables: 1. Voters (the subscribers – this will be the main database) (ID is autonumber, EL_NO is unique – no duplicates. See access file attached). 2. User (usernames and passwords, for the users to be able to login locally) 3. User_data (the data that each user will enter for ...

I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're

...to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking

...(Solidity/ERC721) to specifics cryptocurrency markets; I think of a good system and its subsequent easy management; a lot of material needs to be reorganized, offered in English, with a sober and professional style, similar on every website, with the option of being available in every language (Wordpress); the basic contents and plan in matrix at the bottom in (first column general info, each others column basic contents on specific websites/patent); ...not need easy migration (traslation) !!! Please: present clearly your offer better; ...how many days do you need ? ...what kind of trace/flow do you think ? *all my easy action, now start from === old asset - new asset; Aruba / Italia ...next to Hostinger / Lituania .

Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1　Background】 This technology pertains to a system that utilizes mobile devices in vehicles. Specifically, it combines a smart key system with Ultra-Wideband (UWB) wireless communication to authenticate the mobile device with the vehicle and precisely detect the location of the device. Based on this location, the system determines whether to allow or deny vehicle operations. This aims to enhance security and service quality. However, since UWB communication uses high-frequency bands, co...

Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1　Background】 This technology pertains to a vehicle control system designed to enable specific operations on a vehicle. Traditionally, there has been a smart system utilizing electronically authenticated keys through wireless communication with the vehicle. However, a new method using sound authentication with a device worn on the user's ear has been proposed. While this device offers a novel way to authenticate with the vehicle, using standard communication protocols allows authen...

I'm looking for an intermediate Online Reputation Management Assistant to help with a variety of tasks. Key Responsibilities: - Removal of negative content: The ideal candidate should be able to successfully remo...Video Calls: Communication will be done primarily through video calls. Expectations: - Improve overall online reputation: The primary goal of the project is to enhance our overall online reputation. - Work on Client Projects: You'll be expected to handle online reputation management for our various projects. - Agree to Confidentiality: As part of the job, you'll need to agree to a confidentiality clause. I'm seeking someone with intermediate experience in online reputation management. Please apply if you're well-versed in these areas and can ...

Hello, I need mapping a CSV that contains many information and put all words in each column

...for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery info, Number of cartons/units, Total ADR. The data is sorted using the “Mode of delivery” information, which allows deliveries to be grouped by truck. During the day&#...

I'm currently using a Python scraping bot for my project, but I need to make some adjustments. Key Requirements: - The primary modification involves segmenting the scraped data by day. To achieve this, I would like to have a timestamp column added that differentiates data on a daily basis. This will allow me to have a better understanding of the data collected each day. Your Proposal: In your application, please provide a detailed project proposal. I'm interested in freelancers who can clearly articulate how they will approach this task and ensure its successful implementation. Ideal Skills and Experience: - Proven experience in Python scraping bot modification - Familiarity with data segmentation and timestamping

Need to convert text file to a clean page and remove the colums showing passwords.

I'm seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that co...

I need a simple, single-column WordPress site set up with the following requirements: - The site will need to be built from a provided WP demo content folder, including plugins and theme. - The main content will be of a standard, text and image-based nature. - The site design should be a straightforward single column layout. For this project, you would need: - Proficient skills in WordPress - Experience with SCSS - The ability to set up a local site - Familiarity with migrating WordPress sites Please ensure you can work with the provided WP demo content folder as the basis for the site.

...focus is on expenses. Here is what I require: - Just the expenses data extracted from the Excel file and made available for the creation of a pivot table. - You'll need to determine the format of the data in the Expenses column. Your skills and experience: - Advanced knowledge of Microsoft Excel, especially in working with different types of data. - Proven experience in handling financial data, specifically expenses. - Ability to interpret varying formats of data on Excel. - Good problem-solving abilities, given that the specific format of the data in the Expenses column wasn't provided. If interested, please provide a portfolio showcasing your past work relating to Excel and financial data management. Your ability to deliver quality and accurate work will b...

Please make wordpress site as atteched image. 1 column and respoinsive design.※If possible,bootstrap design. Anything is include dummy text and dummy images. I make inquiry and faq,sitemap page by myself and send you wordpress login details. Required Pages:Top page,fx,crypto-ex page,1 currency detail page Please make within $120(absolute requirement) and delivery within about 2 weeks and give me a progress report every about 4 days. I think only the table part is a little more challenging.

I need a competent translator who can translate text from Polish to English. The content of the text is non-technical and non-legal in nature, falling under the general category. - Unknown Word Count: The exact word count isn't clear, so please be prepared for flexibility in this regard. - Page Range: The text that needs translating is estimated to be between 1-5 pages in length. The ideal candidate will be a native English speaker who is also proficient in Polish, with experience in translation work. Reliability and commitment to deliver quality work are also important.

...-if you mess up, that is OK, but then you must edit the video. (there is no negative to a video with many edits/cuts) If you rehearse it 2X and then record, it takes about 11 minutes. Total time to perform is approximately 35 minutes... So less than 1 hour Here is the google sheet that is a "conceptual guide". For each row, it tells you how many signs are needed for that row (See” count" column).... (many are done with LEFT and RIGHT hand). In some cases signs are moving vs static and it shows you the "States" of the specific sign. Again, this is a conceptual guide but the example video is what you want to use as a reference. https://docs.google.com/spreadsheets/d/14PJe9FmxsQXvaq-Rm7r1MjD0AjMEfFHocKeVYDtQTDg/edit#gid=10251319 More import...

Heading into a sponsorship agreement, I'm in need of a knowledgeable attorney. Your role is to draft a robust corporate sponsorship contract that addresses my major concerns: - Exclusivity Clause: The agreement must ensure that the sponsor will not sponsor similar ventures during our partnership period. - Termination Clause: A straightforward exit strategy if either party needs to back out. - Payment Terms Clause: Clear, concise provisions detailing all aspects of financial compensations. The contract needs to delineate a 6-month term. Lastly, it should expound on the sponsors' obligations, mainly focusing on financial support and promotional services. Suitable candidates have a deep knowledge of corporate law and experience in contract negotiation and dra...

...and converting it into JSON format. The PDFs, such as the example provided here, vary in format and column structure based on their categories. The solution should not require downloading the PDFs manually. Sample URLs Requirements: - Develop a tool or API endpoint for extracting data from PDF files located at given extracted PDF table data into JSON format. - Handle various PDF formats with different column structures. - Preferred tech stack: PHP (Laravel), Node.js, or Python. - Ensure robust error handling

Fix related issue in the module. Authentication, column view issue. Able to follow to fix one by one and with ftp

I'm looking for a HubSpot consultant to help me with migtation and mapping from pipe drive, i could use the inetgration to map but emal not showing up and i also need them to map/migrate the special column/field from pipedrive to hubspot, IF YOUR NOT A PRO DONT CONTACT ME . I NEED DONE TONIGHT

...url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highlight that G) If the MSRP is appearing for variation, then it should fetch and enter that number. It is very easy and simple work. Bid only if you can do within next 24 hours. See the attached excel file for the sample of what I need For end solution, i should be abl...

I have a large file from my old website, saved in an unknown format (likely HTML, CSV, or XML). Key Points: - The file is from my old website, saved in an unknown format. - I have access to the old website's database or server files. - The main goal is to retrieve the articles and media from the old website to publish them on a new website. - The exact format of the file is unknown. It will be a TAR file and it is rather large file (5.9 gb) Ideal Skills and Experience: - Proficient in web development and file parsing. - Experienced in handling legacy website data. - Strong problem-solving skills for dealing with unknown file formats. - Ability to extract, organize, and migrate content effectively. This project requires someone who can navigate legacy sy...

Hi, I am new to react. If I click open panel a panel opens. if I drag the item from the panel to column2 it should add to the table and simulataneously it should add to column 1. same way if I add to column 1 it should add to column 2 table two. I am able to achieve for column 1 but not inside column 2 table. can you lee me know how to fix it. Providing my code and fiddle link below. ,src%,src%2FApp.jsx&terminal=dev import { useState } from 'react'; import reactLogo from './assets/'; import viteLogo from '/'; import './'; import { DragDropContext, Droppable, Draggable } from 'react-beautiful-dnd'; function App() { const [panelOpen, setPanelOpen] = useState(false); const [columns, setColumns]

I stumbled upon an instrumental track in an online video but I can't seem to pinpoint its origin. Requirements: - Identify the unknown song and artist from an online video - No lyrics in the instrumental track - You will be provided with a link to the video Ideal Skills: - Experience in music identification - Proficient in instrumental music recognition - Attention to detail and patience Let me know if you think you can help and I'll send you the link. If you're able to identify the song and the artist, Thank you!

The specific goals and scope of this project are currently unknown as the initial questions have been skipped. The target audience is also undecided. We are open to professionals with a wide range of skills willing to collaborate on this venture. In proceeding, please be aware that further information on the project will only be provided during the interview stage.

...formwork plan over the ground floor • Plate reinforcement plan over the ground floor • Formwork plan and beam reinforcement over the ground floor • Formwork plan and ground floor pillar reinforcement • Formwork plan and ladder reinforcement • Plate formwork plan over the floor • Plate reinforcement plan over the floor • Formwork plan and beam reinforcement above the floor • Formwork plan and floor column reinforcement • wood Frame/ roof plan • wood Frame / roof details - **Sanitary and Thermal Installations Design**: In addition, I require a dedicated engineer with expertise in sanitary and thermal installations. This professional will be responsible for creating the necessary technical designs and providing detailed installatio...

I'm looking for a professional who can proficiently split Column D in my Excel spreadsheet into columns E, F, G, H . This data must remain on the same sheet post-split progression. I have provided an example in row 2 Key requirements: - Excel proficiency with experience in splitting columns - Ability to deliver quality work in a timely manner - Must respect data privacy Any freelancer applying for this project should include their relevant Excel experience to demonstrate their skill. This task needs to be completed quickly and correctly, so I need someone who knows their way around Excel. Let me know if you're up for it, I'm eager to get started on this as soon as possible.

As the owner of a coupon codes website, I am in desperate need of improved search engine rankings. Our current SEO state is quite poor and needs significant enhancement to better cater to our audience who are avid discount seekers. - Our website is unknown for its ranking and thus our main goal is to enhance visibility in search engine results. This will in turn increase traffic, conversions and ultimately, revenue. - Unfortunately, the primary audience for our website was not specified. Despite this, we trust that you as the SEO expert will leverage suitable strategies to pull in diverse audiences, until a main demographic is determined. - Ideal Skills and Experience: - Proven SEO experience - Understanding of performance marketing, conversion and online customer acqu...

I am new to Power Automate. I have already built several relatively complex Flows, but I am facing a few issues related to dynamic UI elements and how to stop a loop. I am looking for someone with a strong grasp of Power Automate to help me solve these issues. 1. How to stop a loop based on a Python GUI counter. 2. How to pick a link in a table based on the right column (in Salesforce). 3. How to click a download link that always has a different CSS identifier. 4. ...might be an additional question that arises. Note that autodesk is not allowed on my work computer but I can provide very detailed information with screenshot from Power Automate to help you understand the issues.

I need a simple code that can send a purchase transaction for tokens in python or rust The code should have two statements: #3 - Associated Token Account Program: Create #4 - : Unknown for - 6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P CLI program input: privateKey, mint, amount_in output (print): tx sig, status

I need help creating a custom loan agreement. This agreement must be primarily in English but suitable for use in Thailand. While the document does not need to be translated into Thai, it should be compliant with local Thai law. Key components of the agreement: - Interest rate clause - Annual repayment of loan at 10% of each year's capital and at end of year 5 repayment of capital Plus the removal of management fees on both Ardan and RL360 accounts also While drafting experience would be beneficial, a deep understanding of lending law, particularly as it applies in Thailand, is necessary for this project. I'm expecting the work to be thorough, professional and legally sound. Clear communication skills in English are a must too, as we will be discussing complex, te...

...excel file Pictures must be saved with their code. f.e. (code is in column A). If in Column F there are more than 1 pictures, then save 2nd, 3rd etc. pictures like: , adiddv0318_4.jpg... Always in Column F (URL's for download), pictures without _a, _b... are the main picture (therefore must be saved like ). Pictures with _a, b.. etc. must be save as 2nd, 3rd ... (, ). If in Column F there is no picture without _a, then use the picture with _a as main picture and save it as ; If in Column A there are not valid characters (like / ), replace them with _ Tackle4Allitems excel

I am new to react I need to move the item from the column 3 to column 1. Initially I developed static code. then I used react-beautiful-dnd and splice logic to move item from source to destination I even debugged by putting console.log. console not printing, Providing my code below. Can you let me know how to fix it, even needed to be added to table rows when added and integrate in my codebase later can you fix the code in my stackblitz ,src%,src%2FApp.jsx&terminal=dev

I need assistance transferring data between Excel sheets Key requirements: - Data transfer: I'm unsure if this needs to be a manual or automatic process. I'm open to suggestions that will make the process efficient and error-free. - Randomising 'Task Types': This column needs to be randomized each time data is transferred. The 'Task Types' should be selected from a specific range of values. Ideal skills for this job: - Proficiency in Excel )

I'm working with an existing Excel spreadsheet that contains date data. I need help with sorting and filtering these dates. PROBLEM: I have different data set (mm/dd/yyyy and dd/mm/yyyy) in the same column exchanging every 100rows or so...data set is about 70000rows I dont want a solution I want you to teach me how to resolve this because this is something ill do for some time now and i need to know how i can do it by myself. Key Requirements: - Sorting and filtering the dates in the spreadsheet effectively. - Ensuring the sorted and filtered data can be used for additional calculations within the same spreadsheet. Ideal Skills and Experience: - Advanced proficiency in Excel, with a strong understanding of date functions. - Previous experience working with large data sets a...