Filter

My recent searches
Filter by:
Budget
to
to
to
Type
Skills
Languages
    Job State
    60,044 columns jobs found, pricing in CAD
    MS SQL code (T-SQL) and json 6 days left
    VERIFIED

    ..."folderId":"e1365655-fbe8-46b5-9568-f7b3edae02f2" }, { "questionCount":"1", "folderId":"c24fb55b-16e1-4158-9cd6-6404588ccc09" }, { "questionCount":"2", "folderId":"e1365655-fbe8-46b5-9568-f7b3edae02f2" } ] } Of course the "sections" array can contain many items (in the example just 3). I have the following table called [Folders] with 2 columns: NewID, OldID BF5C9C6C-00AC-467C-8F47-D1ACE582925A, c24fb55b-16e1-4158-9cd6-6404588ccc09 F44EEDC6-88FD-4886-AEF1-8314A1A11FC4, e1365655-fbe8-46b5-9568-f7b3edae02f2 Basically I need a T-SQL script that replaces in the json all old IDs with the new IDs. ...

    $37 (Avg Bid)
    $37 Avg Bid
    5 bids

    We have 122 files with same data field layout of approximately 300 fields totaling approx 2.5 million records when all combined. We want to merge into one file, delete fields from the file, and return file back as a .txt. Use of Python or other means to automatically perform actions. Can share sample file and of course the columns the will be deleted, leaving about 100 fields.

    $172 (Avg Bid)
    $172 Avg Bid
    36 bids

    ...managed to add my Pivot table in the "Data and Pivot" tab, but I am struck at the below step - request you to help. Adding "% pending" column as an additional column Note that I tried "Calculated Field" option, but since the "Completed" and "Pending" columns in the Pivot are not the actual columns themselves but are column cell values represented as columns, I am not able to add the "% Pending" column as "Calculated Field" I am able to "Show Value as" "% Row Total" But I need this percentage only for the % pending column and not all columns along with the "Pending" column which has value as well. Note that The pivot table has to be updated after refresh if ...

    $12 (Avg Bid)
    $12 Avg Bid
    14 bids

    Hello, I would like a word document with a drop down box option in 4 columns. I would like if I could have select a word from the options and when I select a word from the selection I get a preselected paragraph with text. I would then like instructions as to how to edit text when required. I have attached a word document as an example of what where i need the drop down control options.

    $112 (Avg Bid)
    $112 Avg Bid
    32 bids

    ...com/file/d/1cLckmEQzkZ2a26WTkOgGEU739-ryLojF/view?usp=sharing I have included the cities and content into the same csv but we can do 2 separate files for cities and content variables So before generating GPT3 : I want be able to add variables like [random1] so it will take randomly one cell from the colum with the header name [random1] then generate IA content We want to generate variables subjects from the csv columns before generating IA content We just dont want to duplicate titles for each generated page so we need that the IA takes randomly a cell from a column when I put [variable1, 2,3] in the choosen HTITLE or subtitle so for example one page will show as h2tag: "Find your teacher in Paris" (the generated content will be under it) the next page will show for ex...

    $96 (Avg Bid)
    $96 Avg Bid
    12 bids

    Greetings of the day! I have a project related to AI basic application, the function of this applicationis to read basic large number of PDF files (academic articles) and extract same data from them into table (Automated PDF Data Extraction). this table is basecally 15 - 20 columns. example of the extracted data; sample size of the study, country of the study, theories used in the study, summary of the findings.....etc. One of the outcomes will be the confidence level of the extracted data (from 0% to 100%). Also, as some of the trained data might not be highly accurate, I need to have the option of re-train the application in various dataset in future so i can add more column or delete them if i needed. *attached is excel screenshot for the expected data extraction and sample o...

    $153 (Avg Bid)
    $153 Avg Bid
    13 bids

    I have a folder with a lot of zip or binary files, the zip files contain the binary files. I want to look at each binary file wether in a zip or not and CRC32 the entire binary file. Using that CRC32 as a lookup in one of the spreadsheet fields I want to extract other information from the file. File Size, partial area checksum, end of data and fill in the information in the missing columns. Creating new rows if a row does not exist.

    $173 (Avg Bid)
    $173 Avg Bid
    19 bids

    I have setup remote temp readings that update in excel every second. When the internal temp reading in Col C equals the external temp in col E, the corresponding row in col G will highlight as a match and display the property and room where the match exists. I would like to know if it is possible for VBA code to be applied to do the followin...following: Scan/loop Column G and if the row is not blank to take the output and send via telegram as an alert system. As the temperature moves a lot I would only like to be alerted once every hour but would prefer to leave the possibility of having this as a variable setting eg. every 5,10,15.20 mins linked to the excel document should I wish to change it. Must be flexible if I was to add additional columns so that the overall code is not in...

    $42 / hr (Avg Bid)
    $42 / hr Avg Bid
    12 bids
    Excel Formula 6 days left

    I need support writing a formula in Excel. I need multiple VLookup columns. Currently I have it linked so that one of the lists is working. I cannot work out the formula to get the remainder working. See in the video; When I select 'Colour' it comes up with the 'description' from the V Lookup formula which is perfect! I am referring to Column 'I' When I select Charcoal as colour > Description > Code it is correct When I select Black, White or BBQ as the option, the 'Description' is correct, however the corresponding code does not appear

    $16 (Avg Bid)
    $16 Avg Bid
    7 bids

    I have two ...results and then people will click onto different pages like the For the it is reading a javascript file and automatically building the tables and header <h2> from an API, there needs to be 2 columns per tab which the first column will have anything that doesn't say General Classification in it and the second column to have anything with General Classification in it. All the tables need to be formated the following: - Rank (first column) needs to be justified to the left - Number needs to be centre - Name needs to be centre - time and gap columns are justified to the right but the headings need to be centered will also be replicated for a number of different html pages so needs to be easily changable. Also needs to be mobile friendly!

    $192 (Avg Bid)
    $192 Avg Bid
    44 bids

    As we have discussed below are the points: 1. List to store data has to be EXTERNAL. 2. List of values to fields where we have 'drop downs' has to be editable: User can add/remove/change the values 3. Columns' names to be configurable: let's move them into an internal list 4. User can configure which columns to be effectively used.

    $226 (Avg Bid)
    $226 Avg Bid
    1 bids
    Excel Formula 5 days left
    VERIFIED

    I need an excel formula that can help me automatically pull values from one sheet to another. I have a template where I normally need to pull data from another sheet. I don’t want to use vlook up every time I need to pull data. I want to be able to paste the source sheet somewhere and then it automatically pu...values from one sheet to another. I have a template where I normally need to pull data from another sheet. I don’t want to use vlook up every time I need to pull data. I want to be able to paste the source sheet somewhere and then it automatically pulls the data into the template. Note that the template and the sheet don’t always have the same column arrangement. Sometimes there are additional columns in the source sheet and not arranged the same way. See th...

    $29 (Avg Bid)
    $29 Avg Bid
    50 bids

    ...help with: • Update all the products on my site that is in the csv • Add the products that is in the csv file but not yet on our site • Remove old products from this supplier that is not in the csv file (only remove old products from this supplier!) • Scrape the suppliers site for category and also images? • Create API connection for suppliers stock status I have attached a example file of what columns that is needed in the csv file. NOTE! I have a lot of products on my site and it is very important that this work ONLY affect products and brands from this supplier I don't know what is the best to do? maybe its easier to just delete allt the products from this supplier and then scrape their complete site to upload on ours? I have WP all import / ...

    $257 (Avg Bid)
    $257 Avg Bid
    46 bids

    I need to build an HTML block that contains images with titles underneath it. See image as sample. > The layout must be neat and responsive. > Images and titles must have links. > Must be responsive for mobile, tablet and desktop - the number of columns must adjust on all devices. Source code must be provided. Must use CSS and HTML only.

    $32 (Avg Bid)
    $32 Avg Bid
    51 bids

    Make new colums to sheet and fetch data from another sheet to columns according to unique key values

    $28 (Avg Bid)
    $28 Avg Bid
    52 bids

    I'd like a simple yet very welll documented code to go through an excel file and create "word cloud" based on values of columns in that excel file and show word frequency in that excel file and filter rows

    $52 (Avg Bid)
    $52 Avg Bid
    7 bids

    I have 2 columns set up in Wp Bakery, the left column has right aligned text and the right column has left aligned text. It appears correctly on desktop, but when viewed on mobile it puts one column on top and the other on the bottom which is incorrect. I've added photos to show this. I need someone to fix it so that these text columns don't go on top of each other when viewed on mobile.

    $75 (Avg Bid)
    $75 Avg Bid
    21 bids

    write the required code (form/controller/model/route/blade) for creating displaying editing and storing dynamic MySQL multiple data pics, videos, articles from multiple options and responsively storing and displaying 9 pics and data per page (3 rows with 3 columns) with pagination for each of the option selected(Images/Video/Articles. HTML/CSS/Javascript code needs editing

    $35 (Avg Bid)
    $35 Avg Bid
    39 bids
    Excel data expert 4 days left
    VERIFIED

    I have created a martrix to organize a study I am making. I need to take the columns from my table into a new sheet, and be able to fill them in per group be simply selecting. A simply formula specialists will be able to resolve this quickly.

    $22 / hr (Avg Bid)
    $22 / hr Avg Bid
    140 bids

    Hy, i would need a List of Austrian (AUT) Hotels ! attached you see the example XLS Sheet to see which Columns are needed !

    $28 (Avg Bid)
    $28 Avg Bid
    74 bids

    Match the customer numbers in column D of the "Dec 2021 tax report' with the customer numbers in column A on the "Customers' Sheet. Move all info from that row in customer sheet (columns A - F) to the 'Dec 2021 tax report' sheet and put in E - J.

    $26 (Avg Bid)
    $26 Avg Bid
    99 bids
    wordpress website development 4 days left
    VERIFIED

    ...6WTkOgGEU739-ryLojF/view?usp=sharing I have included the cities and content into the same csv but we can do 2 separate files for cities and content variables So before generating GPT3 : I want be able to add variables like [random1] so it will take randomly one cell from the colum with the header name [random1] then generate IA content We want to generate variables subjects from the csv columns before generating IA content We just dont want to duplicate titles for each generated page so we need that the IA takes randomly a cell from a column when I put [variable1, 2,3] in the choosen HTITLE or subtitle so for example one page will show as h2tag: "Find your teacher in Paris" (the generated content will be under it) the next page will show for example " Yo...

    $242 (Avg Bid)
    $242 Avg Bid
    30 bids
    Product Utility 4 days left

    Hello, I need a C # programmer able to create a utility that can connect to the mssql database, take information from the db inerrent categories of articles, articles and display them in the form of buttons in a panel that must have the number of columns present in the chosen item category. The keyboard must be drag and drop to reposition the buttons and this action will have to rewrite the order immediately on the db. Furthermore, the keyboard must allow you to change one or more properties of the buttons (active, color, category, button image), to one or more buttons and save them on db. Categories with drag and drop will also need to be reordered. I would like a local project with a setup and a setting screen for connecting to the db. if better I have the possibility to use the A...

    $671 (Avg Bid)
    $671 Avg Bid
    12 bids

    ...CSV-file, must be loaded into another table. Likewise, the first column depicts the x-values, meaning there will be 51 columns overall. Table 2, at end of this subsection, schematically describes what structure is expected. After the training data and the ideal functions have been loaded into the database, the test data (B) must be loaded line-by-line from another CSV-file and – if it complies with the compiling criterion – matched to one of the four functions chosen under i (subsection above). Afterwards, the results need to be saved into another four- column-table in the SQLite database. In accordance with table 3 at end of this subsection, this table contains four columns with x- and y-values as well as the corresponding chosen ideal function and the related...

    $192 (Avg Bid)
    $192 Avg Bid
    20 bids

    Reviewing Store Procedure to Add new columns to SSRS report. Need help with find the Mapping of the new columns in the store procedure

    $25 / hr (Avg Bid)
    $25 / hr Avg Bid
    40 bids

    I need to build an analysis report of stocks based on NSE bhavcopy as per my requirement. I want to utilize PowerBI for analytics. When I am using calculated columns for my query it is getting crashed and telling "NOT ENOUGH MEMORY". I want someone who can build the analysis as per my requirement in PowerBI. The data varies from 1 million to 2 millions rows having more than 10 columns.

    $116 (Avg Bid)
    $116 Avg Bid
    12 bids

    Hello, The project includes completing a simple Excel file with the information found on the websit...Excel file with the information found on the website lectura-specs.com. This website lists different brands for heavy-duty equipment, we are only interested in the brand XGMA. The information needed is found on the Excel sheet with an example(XGMA XG6201P). In the cases where only partial information is found on the LECTURA-SPECS website, a simple google search can be done for the info needed (columns I-J-K). There is a separate box for this information to avoid confusion and inaccuracy. Please, see the documents attached. This is a simple task and should take a couple of hours. There are approx. 102 equipment listed under this brand on the website. More similar projects will be...

    $27 (Avg Bid)
    $27 Avg Bid
    58 bids

    Hello, The project includes completing a simple Excel file with the information found on th...Excel file with the information found on the website lectura-specs.com. This website lists different brands for heavy-duty equipment, we are only interested in the brand XGMA. The information needed is found on the Excel sheet with an example(XGMA XG6201P). In the cases where only partial information is found on the LECTURA-SPECS website, a simple google search can be done for the info needed (columns I-J-K). There is a separate box for this information to avoid confusion and inaccuracy. Please, see the documents attached. This is a simple task and should take a couple of hours. There are approx. 102 equipment listed under this brand on the website. More similar projects will be assigne...

    $25 (Avg Bid)
    $25 Avg Bid
    17 bids

    I have a plan I want to add columns, axis ..etc. just some structure stuff on it.

    $30 (Avg Bid)
    $30 Avg Bid
    17 bids
    Web application 4 days left
    VERIFIED

    A web application that represents the data extracted from the database in the form of the table with a possibility to hide/unhide selected columns and communicate with the already existing cloud-based database for both data extraction and data injection. The database can be connected via API. The web application also includes user signup/login, admin screen with the use statistics dashboard and three interactive calculators implementing pre-defined formulas Expected skills web app development: any of React.js/Node.js/Django/Flask and SQL Starting time – asap, expected time: up to 1 month

    $595 (Avg Bid)
    NDA
    $595 Avg Bid
    69 bids

    I need Excel VBA program to validate the cells within a worksheet at they are entered, to ensure that they do not exceed maximum lengths. Could this be done using a Worksheet_Change sub? I am not sure. I have provided a sample XLS that you can look at, which gives good visual understanding of what needs to be accomplished. The validation rules would apply to all columns other than "A", which would be a control column and not a data column. The logic needs to work as follows. Maximum cell lengths for each column are going to be provided from a row that contains a string value of "LENGTHS" in column A. If no such row is found, then validation has been disabled and we just exit the entire process. There is nothing to be done. Otherwise, suppose data is entered into ...

    $138 (Avg Bid)
    $138 Avg Bid
    31 bids

    Dear Freelancers a website is needed to presend Apartment for renting. Wordpress is prefered. An add-on for making bookings and syncing calendar with is needed. It can be one-page design. On top a slideshow with pictures, bellow some text (could be in columns) and booking option at the botom. It is a low budget project. Pictures etc can be later uploaded by me. I just need a functioning page.

    $64 (Avg Bid)
    $64 Avg Bid
    33 bids
    Mongo DB query 3 days left
    VERIFIED

    Hi, I am looking for one query where need to fetch, two columns and sort from the Mongo DB.

    $16 / hr (Avg Bid)
    $16 / hr Avg Bid
    4 bids
    MSsql and .net website 3 days left
    VERIFIED

    Hello, need to do some MS sql operations like deleting columns and adding new ones. I also have some problems with some functions on the website. Pleas contact me so we can discuss further

    $181 (Avg Bid)
    $181 Avg Bid
    68 bids

    Python expert python pptx is needed for change some format issues of Powerpoint Presentation automation code. Task: * Introduce new design of colors for some slides. * Align some margins of cover * Change column text width * Introduce new parameter to paste a "sample" sticker (.png) when parameter is set True. * Realocate abstract text to the cover *Divide metadata text into two separated columns.

    $191 (Avg Bid)
    $191 Avg Bid
    15 bids

    ...mention Wordpress. * Security question: What is the complementary color of yellow? * Security question: How much is 7*6 + 24? Project details: I create a lot of galleries. In the past I have used ImageMagick to crop the images to specific dimensions such as 1280x1280px or 1280x960px, square and 4:3 aspect ratio. In the frontend I use bootstrap grid/cells to display the images commonly with 3 or 4 columns. By pre-cropping the images they display perfectly uniformly on the frontend. I saw some articles that discuss being able to use CSS (and object-fit) to be able to create a view of an image. You can feed in a wide/landscape image and end up with a square view (from center) of the image. The posts explained this with a fixed dimension image like 400x400. That doesn't work...

    CSS
    $34 (Avg Bid)
    $34 Avg Bid
    11 bids
    Ebay file exchange -- 2 3 days left
    VERIFIED

    Hello, i need to update on ebay 3500 items, new price and description. I have already used file exchange and i have master file ready. Need just a freelancer that on the excel file change 2 columns data and i send on ebay for freelancer that have experience with Ebay file exchange. Thanks

    $175 (Avg Bid)
    $175 Avg Bid
    28 bids

    Good afternoon – we are looking for a excel specialist that can help us refine or rebuild/re-create a spreadsheet that will be used for an exterior remodeling company to pay salesperson commissions, pay sales tax, and provide infor...All paint costs to go into labor • Review formulas – • Discuss categories that add sales tax vs pd sales tax • Keep an Error categories that will deduct from salesperson commission Company Total Page • Add a % Profitability column and an amount column for this • Use this page to print salesperson commission sheets for payroll and look at year to date figures Sales tax Page • would like the columns to automatically transfer Include LMS in the same spreadsheet – this is the second attachment. Job ar...

    $1179 (Avg Bid)
    $1179 Avg Bid
    12 bids

    Hello, I would like to modify the spread sheet called “OMD vacation spread sheet” but only on the page labeled "OMD OO". The sheet works a job qualification tracker and lets me know how many people with the same job qualification requested...other vacation tracker sheet. I am not sure of the formulas that were used but they should be the same as the “Pat Utilities sheet”. So the “Pat Utilities” sheet works fine and can be used as an example of how the “OMD vacation” sheet needs to work. Its just one page on the OMD vacation spread sheet. I added a red arrow to indicate the sheet that needs to be modified. So basically, I need 4 columns added, and 4 rows added but I am not sure of the formulas used to make them work. The pa...

    $62 (Avg Bid)
    $62 Avg Bid
    4 bids

    Fill in the columns in yellow for 2000 records. (First 3 records are examples) Only the website of P0 (About 25% of the total) need to search contact info and most of them have already contact info. It means you will basically need to fill in 2 datas for 75% records (1500) and 3 datas for 25% records (500). Only very few of them need to search contact info. I will send you a guide once we start the project. It will be a long-term project if you do it well.

    $186 (Avg Bid)
    $186 Avg Bid
    50 bids

    I have a ready plan and I need to add a structured plan to it( columns and axis )

    $30 (Avg Bid)
    $30 Avg Bid
    20 bids

    Model two houses, so that we can easily visualize the finished product, We...overall thickness 250mm • Garage floor will be concrete, finished level 100mm above the ground level • Internal doors, width 900mm, Ht 2m • Windows to be standard off the shelf items, but with a 100mm wide frame around them • Much information can be inferred between each of the plans, eg window sizes etc. • I have included the exel spreadsheet, from which the PDFs were made, The grid created by the columns and lines on the spreadsheet are at 1m spacings • The floor plan of the existing house is shown on the exel spreadsheet (“Lyndas Version” page) I would like 4 high quality renders of the house, from the outside and a lower quality walk through video of the house s...

    $930 (Avg Bid)
    $930 Avg Bid
    109 bids

    ...for each cell or row / column. For eg I have a sheet of stock / inventory with columns - Product name, Quantity, Cost, Sale Price. Suppose I have 20 people on staff. I want to share that sheet with all of them but with different user rights for different people. Senior managers may view & edit all columns while sales managers may see all except Cost column but cannot edit any column except Sale Price. Similarly all other staff may only see Product name & Sale Price and edit none. (see attachment for a screenshot of this file) I can restrict editing with protect sheet & ranges option but how can I restrict viewing of certain cells ? Also I want to restrict editing & viewing of many cells & ranges (rows or columns) in whole workbook just by a sin...

    $10 / hr (Avg Bid)
    $10 / hr Avg Bid
    2 bids

    I need to have someone with the knowledge of JSON (API Integration) and DynamoDB (AWS) to Store the response (column format in DynamoDB). It is an easy integration where we need to store the response from few API's in the DynamoDB database and apart from this need to add few extra columns (flags) to check if the new data which will be added to DynamoDB already exists in the DynamoDB or not.

    $10 / hr (Avg Bid)
    $10 / hr Avg Bid
    4 bids

    I am looking to have neighbourhood information copied from 3 different websites and pasted a spreadsheet. No editing required, just copy/paste. There are 6 different columns to populate and 62 total neighbourhoods to pull the information for.

    $101 (Avg Bid)
    $101 Avg Bid
    30 bids

    ... And, we'll make the red Notifications bar ONLY display notifications with a done value of 0. This can be similar to our default getList function, like getNotifications() with a where condition that looks for done = 0. 4) Add a feature to the Edit User Account (Admin feature), which lets the Admin add multiple Org IDs to an input field that saves a string of Org IDs [1,2,3,4,5]. We have 2 columns in our Users table that save a string of values like [1,2,3,4,5], which represents Organization IDs and SubOrg IDs. So, I basically need 2 features that insert the OrgID values as a string into each field (ie input on the Edit User Account page). I already have a dropdown in the Edit User with the Orgs, but I think you may need to list them out as checkboxes so the Admin can s...

    $27 / hr (Avg Bid)
    $27 / hr Avg Bid
    34 bids

    Hi, I need a script to Adobe Indesign whitch will create blocks with price, name, desc, exactly as the example block, from xls file/text area, or text block inside indesign, and new bloks will appear as some array in this file. If script will work witch xls/csv (I preffer), every data will be in columns, and next price will be in rows, but if script will work with text it could be that way, that first line is the price, secound item, third name, fourt and other as description, and next price will be after some delimeter eg. ---

    $161 (Avg Bid)
    $161 Avg Bid
    8 bids

    ...for each cell or row / column. For eg I have a sheet of stock / inventory with columns - Product name, Quantity, Cost, Sale Price. Suppose I have 20 people on staff. I want to share that sheet with all of them but with different user rights for different people. Senior managers may view & edit all columns while sales managers may see all except Cost column but cannot edit any column except Sale Price. Similarly all other staff may only see Product name & Sale Price and edit none. (see attachment for a screenshot of this file) I can restrict editing with protect sheet & ranges option but how can I restrict viewing of certain cells ? Also I want to restrict editing & viewing of many cells & ranges (rows or columns) in whole workbook just by a sin...

    $4 / hr (Avg Bid)
    $4 / hr Avg Bid
    1 bids

    Find a value in intersecting rows and columns in my Google Sheets data base spreadsheet. The task is exactly the same as demonstrated in this youtube video, except using google sheets. My consultant needs to assist me complete the task. Here is a link to my google sheets database

    $16 / hr (Avg Bid)
    $16 / hr Avg Bid
    28 bids

    I'm looking for someone to build a spreadsheet (I'm open to other forms of outputs) which scrapes 11 columns of information / metrics for each equity listed on the JSE (South African stock exchange). I've attached an example of what I'd like the spreadsheet to look like however it would also need: - a button that refreshes the metrics to update to the latest information (source of information provided on attachment). - the columns must be able to be filtered. - it must be able to remove delisted stocks and add newly added stocks. If it works well I'd like to do the same for NYSE / ASX (Australia) / etc.

    $183 (Avg Bid)
    $183 Avg Bid
    41 bids

    Top columns Community Articles