Column websitecông việc

Hi, i have this query currently that queries for mem usage from a database. I also used the UNPIVOT to set them as columns instead of rows. My question is, how can I add a new column that would have values for the cities? For example hou_mem_usage_bytes would have the new column value of HOU and lax_mem_usage_bytes would have a new column value of LAX.

I'm looking to convert a Unix timestamp column in AWS Athena to Thailand/Bangkok time, in the YYYY-MM-DD HH:MM:SS format as a new column (keep the original UCT timestamp as well). The timestamp column currently is in the UTC timezone, and I would like this to be adjusted according to daylight savings. Therefore, I need someone who can figure out how to code this conversion so that I can paste it into a Select statement. Deliverable will be the code. Project will be finishes when I have assured that the code gives the correct result. I have attached a database sample

I have a file which will have stocks information such as price, estimated value and ranking. The VBA program will ingest the data and generate a comprehensive list that includes each sector along with its corresponding column values, which are derived based on the provided Logic as shared with the document. This is just a starting and few more will be provided whom I select for final project. Please read through the file and quote accordingly.

...task in azure machine studio classic. I have about 20 questions and I can pay $50. I’m a very beginner in azure machine learning studio classic. I m working on a project and I just have few questions. So I have may be 25 questions. I can pay $50 if you can answer my questions. For example : I have a dataset that has data that I want to train the model to study and then I have results in the same column. How can I tell the model to study these rows and the answers are in these rows. These are the types of questions. I just started using azure and I don’t have enough time to take a complex course....

...names. Your job is to open each website, search for the necessary information, and input the data into an Excel spreadsheet. The required data includes: Column 1 - Company name as it appears on the website Column 2 - Link to the company's homepage that opens when clicked Column 3 - Contact email for the company's headquarters (if not listed on the website, but a web contact form is available, insert the link to the page with the web form so it opens when clicked). Note: if the company is not an engineering or construction firm, leave Column 3 and subsequent columns empty. Column 4 - Company branches or personnel (if the company has branches or lists names and emails of managers, enter them in Column 4, with each n...

I am looking for an experienced and skilled freelancer to scrape tabel with data and links from a specific webpage into an XLSX file. The goal is to capture both column data and links, as well as any extra metadata associated with each link. Your output should contain an exact replica of the data and links found on the source page, along with full formatting that helps distinguish between the two. If you can provide quality results in a timely manner and have experience with this type of task, I look forward to hearing from you! The page to scrape:

I need a macro that will take a 5 digit number from column A and inbed it into formulas referencing file locations in three columns. This needs to repeat for all row with a number inputted. The formulas will be different in each column and therefore the macro will need to find the number string and replace it for every row. It should only act when a 5 digit number has been inputted. Some rows in column A wont have a number and therefore currently this is account for in the formulas. It needs to unprotect and reprotect the worksheet. An example file has been attached.

...Month Total Budget January 829'444 February 1'073'000 March 270'000 You can also see the data of the pdf file. I have tried different formulas below but none of them worked: Total Budget = SUMX( UNION( ADDCOLUMNS('Budget 2021', "Budget 1", Budget 2021), ADDCOLUMNS('Budget 2022', "Budget 2", Budget 2022) ), [Budget] ) (I don't understand when the errors says that "ADDCOLUMNS" can not add the column "Budget 2" because it already exists) SUMX( UNION( ADDCOLUMNS('Budget 2021', "Budget 1", Budget 2021), ADDCOLUMNS('Budget 2022', "Budget 2", Budget 2022) ), SUM('Budget 2021'[Budget 1]) + SUM('Budget 2022'[Budget 2]) ) And I have tried ot...

...- - - 88% 360s - - - - - 20:06 - - - - - 30,241.36 - - - - - Below - - - - - 64% 480s - - - - - 20:08 - - - - - 30,264.37 - - - - - Above - - - - - 78% 540s - - - - - 20:09 - - - - - 30,268.83 - - - - - Above - - - - - 69% 600s - - - - - 20:10 - - - - - 30,242.14 - - - - - Below - - - - - 71% 660s - - - - - 20:11 - - - - - 30,262.95 - - - - - Above - - - - - 87% *You may NOT include the second column nor the "-" signs IMPORTANT NOTE: THE EXACT VALUE IS NOT THAT IMPORTANT, BUT, IF THE VALUE AT ANY FORECAST TIME WILL BE ABOVE OR BELOW VS. THE VALUE AT REQUEST TIME. Considering this note, please provide the accuracy you will have OVERALL, not predicting exact values but predicting if the forecast value will be above or below Vs. the value at request time? Your data outp...

I am looking for a translator for a solitaire collection app (120 solitaire types) into Serbian/Croatian/Bosnian (Latin + Cyrillic). Total word count: 11,300. Though there are many similar/repeating sentences in the game, like "Into an empty column you can only put a King or a stack with a King at its base". Because most of those solitaire types are quite similar. The bulk of the text is rules of different solitaire variants. It's all in a CVS file which you'll need to edit in Excel and put translations into cells. Some lines have tokens which should not be translated or changed because the game replaces them in runtime with numbers or special words. For example: Can't put the card here. Wrong suit: {WRONG_SUIT} Needed suit: {ALLOWED_SUIT} In runtime {WR...

I am looking for a translator for a solitaire collection app (120 solitaire types) into Polish. Total word count: 11,300. Though there are many similar/repeating sentences in the game, like "Into an empty column you can only put a King or a stack with a King at its base". Because most of those solitaire types are quite similar. The bulk of the text is rules of different solitaire variants. It's all in a CVS file which you'll need to edit in Excel and put translations into cells. Some lines have tokens which should not be translated or changed because the game replaces them in runtime with numbers or special words. For example: Can't put the card here. Wrong suit: {WRONG_SUIT} Needed suit: {ALLOWED_SUIT} In runtime {WRONG_SUIT} can be replaced with Diamon...

I am looking for a translator for a solitaire collection app (120 solitaire types) into German (Germany). Total word count: 11,300. Though there are many similar/repeating sentences in the game, like "Into an empty column you can only put a King or a stack with a King at its base". Because most of those solitaire types are quite similar. The bulk of the text is rules of different solitaire variants. It's all in a CVS file which you'll need to edit in Excel and put translations into cells. Some lines have tokens which should not be translated or changed because the game replaces them in runtime with numbers or special words. For example: Can't put the card here. Wrong suit: {WRONG_SUIT} Needed suit: {ALLOWED_SUIT} In runtime {WRONG_SUIT} can be replaced w...

I am looking for a translator for a solitaire collection app (120 solitaire types) into Portuguese (Brazil and Portugal versions). Total word count: 11,300. Though there are many similar/repeating sentences in the game, like "Into an empty column you can only put a King or a stack with a King at its base". Because most of those solitaire types are quite similar. The bulk of the text is rules of different solitaire variants. It's all in a CVS file which you'll need to edit in Excel and put translations into cells. Some lines have tokens which should not be translated or changed because the game replaces them in runtime with numbers or special words. For example: Can't put the card here. Wrong suit: {WRONG_SUIT} Needed suit: {ALLOWED_SUIT} In runtime {WRON...

I am looking for a translator for a solitaire collection app (120 solitaire types) into French (France). Total word count: 11,300. Though there are many similar/repeating sentences in the game, like "Into an empty column you can only put a King or a stack with a King at its base". Because most of those solitaire types are quite similar. The bulk of the text is rules of different solitaire variants. It's all in a CVS file which you'll need to edit in Excel and put translations into cells. Some lines have tokens which should not be translated or changed because the game replaces them in runtime with numbers or special words. For example: Can't put the card here. Wrong suit: {WRONG_SUIT} Needed suit: {ALLOWED_SUIT} In runtime {WRONG_SUIT} can be replaced wi...

I am looking for a translator for a solitaire collection app (120 solitaire types) into Spanish (Spain). Total word count: 11,300. Though there are many similar/repeating sentences in the game, like "Into an empty column you can only put a King or a stack with a King at its base". Because most of those solitaire types are quite similar. The bulk of the text is rules of different solitaire variants. It's all in a CVS file which you'll need to edit in Excel and put translations into cells. Some lines have tokens which should not be translated or changed because the game replaces them in runtime with numbers or special words. For example: Can't put the card here. Wrong suit: {WRONG_SUIT} Needed suit: {ALLOWED_SUIT} In runtime {WRONG_SUIT} can be replaced wi...

I am looking for a translator for a solitaire collection app (120 solitaire types) into Japanese. Total word count: 11,300. Though there are many similar/repeating sentences in the game, like "Into an empty column you can only put a King or a stack with a King at its base". Because most of those solitaire types are quite similar. The bulk of the text is rules of different solitaire variants. It's all in a CVS file which you'll need to edit in Excel and put translations into cells. Some lines have tokens which should not be translated or changed because the game replaces them in runtime with numbers or special words. For example: Can't put the card here. Wrong suit: {WRONG_SUIT} Needed suit: {ALLOWED_SUIT} In runtime {WRONG_SUIT} can be replaced with Diam...

...explain. Attached `` , from which, you can understand that we have already working Excel import feature. Now we need 1 more radio button for New format of excel import Attached : Excel will have same data, we have to verify if that data does Not, we have to insert (if data exist, do Nothing) Attached `` : 1) We have to hide checkbox in Note column. 2) We have to hide Responsible Account dropdown. No functionality change. We have to make Bold, Times New Roman Font Attached `` 1) We have to give Multiple selection of Account Group (filter) 2) Currently it displays Only Balance as per To Date , we have to display balance Before From Date (View Opening, Closing, Both) 3) Remove Site filter 4) Debit in Red, Credit in Blue

Import Excel Doc with Domains or IP addresses in 'A' Column - "" Remove duplicate entries Export results in a new tab within the same excel document. If the list contains a domain: URL - From Excel Document Domain Date Created - from Domain Date expires - from Age of the domain - from virustotal URL community score - From IP address of the domain - From Registrar Name - From Country URL is registered in Location of server (Based on IP) - From

I have a current WordPress website and need the following items done: 1. Update the theme design to feel more modern 2. Convert homepage from “blog listing” to a custom page that allows for a feature article and 2 column layout of articles. 3. Update Link list to be a dropdown or move to a new page. Also remove duplicates. 4. Add an About page 5. Add a Classes page

Its Very Easy Task. We need Tamil Typewriters. We give Excel sheet. Total Number of entries minimum 10000 Nos. My budget is low. Per Row I offer 35 Pisa. From My excel One column Input data there. The data Format is also Tamil. I need output data in next column. The output data format ( TAU_ Marutham Font) The font also I give you. Name, Father Name, Address. I have attached sample Image and font also. Please check and note your bid. where you from. we never give directly. we offer only via freelancer. Thanks Arun Panneerselvam Abblecrass Staffing private Limited chennai

...Ionic framework Please read this carefully and make sure you are proficient with GitLab or you will not be able conclude the task!!! We have DOZENS of small bugs in the functionality of AGGRID that we want to correct. Examples: 1) If we goto a column header and create a sort/filter of the data in that column and then refresh the data, Aggrid should stay at the same place in the grid showing the same information but there is a bug so the current sort/filter order is changed and the page goes to a different location in the grid. 2) The column header data types and filter types (data, date, larger than, contains etc) are incorrect so we must change several of the header types. 3) Automatic cell data refresh-> the data in a cell is not automatically refreshe...

We are looking for a data research manager who can help supplement the SaaS companies' database from open sources with: 1. CEO columns - email, phone number, LinkedIn link 2. CTO columns - email, phone number, LinkedIn link 3. Enterprise tariff plan availability column - "+" or "-" Total companies to work with - 20k File format: Google Spreadsheet

I have purchased a template but cant get it to work properly to breakdown my expenses I think its because my bank has a debit and credit column

...and place in columns against the manufacturer part number column. This will involve the script using its best method to match Manufacturer part number to the equivalent ASIN (some margin of error is expected as MPN to ASIN may not always match up) but this is why we will also use eBay as a pricing tool to get price data for new / used per Manufacturer part number. I am open to the method the freelancer would use to execute such a task (phyton, excel vb script, desktop app etc) but the goal is a script of some kind to process a CSV full of manufacturer part numbers and find the cheapest new and used prices from Amazon and eBay (UK market places required only). Script has to handle around 1000 manufacturer part numbers in one column in CSV format and be able to populate the...

I am looking for a translator for a solitaire collection app (120 solitaire types) into Chinese (Simplified). Total word count: 11,300. Though there are many similar/repeating sentences in the game, like "Into an empty column you can only put a King or a stack with a King at its base". Because most of those solitaire types are quite similar. The bulk of the text is rules of different solitaire variants. It's all in a CVS file which you'll need to edit in Excel and put translations into cells. Some lines have tokens which should not be translated or changed because the game replaces them in runtime with numbers or special words. For example: Can't put the card here. Wrong suit: {WRONG_SUIT} Needed suit: {ALLOWED_SUIT} In runtime {WRONG_SUIT} can be replac...

...id and based on the tracking id; the program will find all the associated SKUs. A tracking ID may be associated with multiple SKUs. Once the user scans a tracking ID, the program will output the details of all the SKUs associated with the tracking ID. These details will include the quantity of products in SKU and the image of the product. Alongside these outputs, the program will have an input column to enter the status of the SKU such as received or issue. In case the user enters issue in this input, then the user should be able to insert a comment. All these information should be stored in an excel sheet which can be downloaded at any time. There should be an alternate interface to include new SKUs into the software through an interface. The details of the SKU to be inserted in...

...and account number exist in a single cell. This data must be automatically parsed and incorporated into the email. (b) The report contains the amount that is owed and the time period since it was first due (current, 30 days, 60 days, 90 days or >120 days) (c) This amount, and if I choose at the time, the time period since it was first due, can be incorporated into the body of the email. (d) one column of the statement report may contain comments that are added on. These comments can be incorporated into the email text. I am not sure if everything is quite clear. I will be pleased to answer any questions. Please do NOT propose a cost of the project and then negotiate. Make your proposal genuine. I will reject any attempts to renegotiate the cost beyond the initial proposal. T...

...expert who can create a Normal Distribution Chart for my data. The chart should have the following features: I have an excel file that I need to make Normal/bell/gaussian Distribution curve for. Columns from A to M are just general information about my test specimen, and column W is their actual results. the lower limit for the specimen is in column N, the upper limit is in column O, and the aim is in column P. So, the results will be acceptable if the value in W is between N and O. the graph should be dynamic when filtering column E "Steel Grade". Meaning, when filtering a steel grade, its corresponding normal distribution curve should appear. The area under the curve should be filled, and a vertical line from the lower limit, upper limit, ...

Hi, I need someone to do browser automation using python selenium. Why python? because I am a python expert which is why I want it in python. Why can't I do it myself? I don't have time and I am not very comfortable in automating the logging process. The work: get list of st...python? because I am a python expert which is why I want it in python. Why can't I do it myself? I don't have time and I am not very comfortable in automating the logging process. The work: get list of stocks login to using google authentication and get some financial data for the specific stocks create a excel file, create a sheet for every stocks and put the data under each column for each year column headers year, revenue, eps etc Please let me know if you are interested in d...

This is a specialist society for Greek orthopaedic surgeons in the UK. I would like the orthopaedic tree to be an olive tree in blue and this can be supported by an ancient Greek column attached to the trunk of the tree with a band which will be a combination of a British and Greek flags

Regarding the Excel product list, can you add an additional column with color, for example if yellow or blue or red is in the description, which is automatically filled from the description or from the article name column if red, yellow, blue or green is contained in it?

...(which should allow a user to either enter numeric values, check boxes or text depending on the field) - Name of property - No. of rooms - No. of beds and bed types (Single, double, king, super king, single bunk, double bunk) - No. of bathrooms (Toilet only, Bath and toilet, Shower and toilet, Toilet and sink, Complete bathroom) - Kitchen - Lounge - Dining room - Other rooms (This feature adds a column to the db if a room is missing, which may feature in future properties , ie - Sauna) - Wifi - Notes The database should be able to allow me to update or add new properties, as well as filter through the database also have the ability to add additional fields if needed There should also be a secondary db which links to each property stored, where I could report maintenance tasks o...

I have a database with a column that contains timestamps in bigint format. The timestamps are in UTC time zone. I need a piece of code to insert in a SELECT statement in Athena that converts the timestamp data to Thailand/Bangkok time and also converts it into the columns ‘date’ and ‘time’ (based on the Bangkok time). I am a beginner in SQL and can’t figure out how to do this. Small-size database attached.

Based on the existing python script & screenshot shared by client in this project https://www.freelancer.com/projects/python/scarping-website-another-part-python/details, the requirement is to scrap the Pools/Matched field for VIC column only. The new field will be added to the XML output.

Build Power BI dashboard from two datasource and filter data based on one column

Hello, I need the attached PDF turned into one spreadsheet. This means you'll have to add a column for "Type" and indicate if the row is under the "Carrier" "Agency" "Non Member Agency" or "Service Provider." Otherwise, keep the columns that are there. I'll need this delivered within the next eight hours. I will pick a bidder with good feedback who is not new. In order to win this bid, please end your bid with the number one. For example, instead of bidding ten dollars, bid eleven instead. This will prove to me that you can read and understand directions carefully. Please also start your message to me with "Dear Douglas." This will prove to me that you are reading all the way through and understand. Good luck and...

...can provide both a plan and advice according to the particular needs of the project. Experienced structural engineer required to calculate the thinnest height steel beam for an opening on an external bungalow wall - double brick skin. Currently has a smaller opening of 2m using a n 180mm concrete lintel . I want to expand the opening to 3.5m opening. Looking for thinnest height like a universal column 152mm or as thin as possible. The wall and current opening also supports a flat roof extension of 3.5m 6x2 timber and felted roof. A roof lantern of 1m x 2m could be added but not guaranteed but the weight could be factored in? Roof shape is a pyramid with dreadnaught clay tiles. Wall heigh to eves is 2.5m and attic height to internal ridge height is 3m. Satellite and close up ...

I need a Matlab code to modify a .csv There is a column from 1 to 403, but some of these numbers are missing. You have to add them. That's it.

Hi Everbody, please create a Excel-sheet and VBA Modules (programm-file). We need the following fuctions: 1. separate Sheet with credentials in programm-file. As we got serveral Clients, the credentials have to be organized in rows per client. column 2 shows the client-specific-data-file (csdf) name in the same folder as program file 2. authorize at Amazon with Selling Partner API 3. get the GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE from Amazon 4. save the result to csdf sheet "settlementreport" 5. ensure not report are duplicates. ensure we got all report in the timeline, not timeperiod is missing same for a VAT-Report from AMAZON. Report name willl be delivered later to you. Save result to CSDF sheet "VAT-Transaction-Report". Be sure it is complete and no dup...

I am looking to keep tracking of my sports card submissions on google sheets. I have a drop down menu on the possible grades. I am looking to have each selection be indivually totaled into another cell. I.E., if I select (10) four times, the total should show up as 4 instead of 40. I ...of my sports card submissions on google sheets. I have a drop down menu on the possible grades. I am looking to have each selection be indivually totaled into another cell. I.E., if I select (10) four times, the total should show up as 4 instead of 40. I am looking to do that for 3 individual drop down selections I also am looking for a formula for when I automatically enter a card title into a column, it automatically updates the card totals. So when I add cards from B12 through B16, the total come...

I have a Study Skills and Character Development manual for Adolescents written as a word document. I want the content transferred into an editable and interesting ebook in Canva design. I want a beautiful layout and a few interesting graphics in each chapter. Probably a two column easy to read layout.

I'm looking for an experienced coder to write code in both R and Python to read a csv file with column name in json structure. The coder needs to write the code from scratch and ensure that the code returns the desired Requirements : There is a csv file. This file need to be converted into dataframe(R and pandas) - But this csv file doesn't have column header. - We need to get a column name from another file. -> this file contains column name in json structure. -> You need to extract column names in json structure. -> and change a column-names in existing dataframe. Output - R script to create data frame "df01". - Python script to create pandas dataframe "df01" My price would...

I am trying to create a flow that will take an excel file from a sharepoint site and the create a column that will be used to calculate the results of other columns and then mark exception based on that result. Those exception will then be emailed to certain recipients.

...reviewer, as every student puts his/her number in as the reviewer and the number of the presenter. -Import all Excel-Files in the Import-Directory into a Dataframe. Only relevant cells should be kept! Convert the x on the categorical scale (-- - 0 + ++) to the corresponding value on a numeric scale centered on 0 (-2 -1 0 1 2). One row of the data frame should correspond to one excel-File with one column per relevant cell. - For each student, a PDF report is created (see attachment). The first page contains Meta-Information about the presentation, coming from the Meta-File. Additional scores are displayed, showing how many forms the student filled out and to what degree those forms were complete (%). The second page contains 8 Histogram-Plots, using the numeric feedback on the s...

hi i have a csv file with delimited comma and i want to return it to their original status, no bar bettween column just commma (simple csv file). i accedentily change it to with delimited comma!

I have a spreadsheet of data that lists various Films which will be playing at various cinemas at certain times of the day over the course of 10 days. I want to visualise this data so that I can more clearly see what films are playing where and when and for how long on each day. Ideally, Column A lists the cinemas and Row 1 the time of day, going up in increments of 5 mins e.g. B2 = 8:30, B3=8:35 etc. Then drawing from my data in another tab, I want this sheet to be automated in showing what films are playing at what cinemas at what times. E.g. X film is playing at cinema 1 at 9:00, X film is playing at Cinema 2 at 11:00 etc. Ideally as well, I want to use the run times of films to help display how long a film is playing for in this spreadsheet, rounded to the nearest 5 mins and...

Write a report upon the cyber posture and cyber position of a company or organisation. The report uses the early part of the NIST Framework. Select any large organisation of your choice. It should be well known and visible in terms of its corporate behaviour. Look for an organisation which has an outwardly public facing view. In your report you should use the column “A” of the NIST framework to perform your organisational evaluation. See attachment for further details

We pull monthly excel sheets with phone numbers that have a ton of different formatting. So every month we manually search and replace ( , ) , + , + , - , and finally a space. We replace them with nothing so then all phone numbers in the column look like this 8554347483 instead of (855)-434-7483. Would like to speed up this process.

...starts with everything in one column in an identifiable pattern. What I need is for each Question and matching answer to be on a row. I am manually editing, but it is taking too long. The spreadsheet attached shows clearly what I need. It starts as "Copied and pasted" and what I need is "Transformed". The key here for a speedy turnaround, otherwise I might as well carry on doing it manually! By way of explanation: The format is: Question#, Q, {question], A, {answer} 7 Q Is osmosis passive or active? A Passive 8 Q Define active transport A The movement of molecules from an area of low concentration of that molecule to an area of high concentration of that molecule. This movement requires ATP I need these transferred into a separate, but corresponding ...

Hello! I'm in need of immediate help with a small adjustment to an existing spreadsheet. I have some specific instructions and guidance to provide, and I need this to be done as soon as possible. I'm looking for someone experience...be fairly straightforward and should be a quick solution. If you think you have the skills and available time to help me out, I'd love to hear from you. Thanks! I've attached a screenshot to demonstrate my problem. Basically I am trying to find a formula that will map postcodes to the required zone. The postcodes and ranges are in column A, the zoning value is in column B. I simply want to be able to enter in a postcode, and get the correct zone from column B. See screenshot. The issue is that the hyphenated values ...