Hide rows işler

Hello, I have a set ...(For example Name: Mission Avenue / From: Main Street / To: Broadway). I also have a larger polyine shapefile with the same fields as the excel however, the excel From and To extend beyond a single polyine in the shapefile. For Example in the excel the fields would say: Name: Mission Avenue / From: Main Street / To: Broadway In the Shapefile this would encompass multiple segments (ie multiple rows of data) for example: Name: Mission Avenue / From: Main Street / To: 1st Ave , Mission Avenue / From: 1st Ave / To: 2nd St, Name: Mission Avenue / From: 2nd St / To: Broadway. Im looking for someone to show me if there is an easy way to join the 2 datasets or at least select the data in the shapefile easily to add a field and label the ones that i need for my...

I am seeking a skilled professional who can help me convert a Google Sheet data file into a JSON schema. This project has a dual objective: to enable data integration with other systems, and to enhance data accessibility. To provide a sense of scale, the Google Sheet data file consists of 25-35 parameters (Columns) for 950 different items (Rows). Key Requirements: - Although there are 2-5 sheets (tabs) in the Google Sheet file, I believe only one (with the scale described above) may need to be converted. - I am not sure about the exact JSON structure needed for the output. Therefore, I'm looking for a freelancer who can provide guidance on this and deliver a structure that suits the purpose of the data integration and accessibility. Ideal Skills and Experience: - Proficiency ...

...attached). This is mandatory. I will be able to change these at conveniance by updating new files (show me how). The icon and favicon will also be updateable in the same way. - Delivery period of the website after having been awarded will be 3 days. Tabs (in this order): - About us: background pictures of your selection and a text read from a file (no copy-paste). - Team: a matrix of 2 cols and 10 rows: * col1 = pictures read from a file (no copy-paste). * col2 = a text read from a file (no copy-paste). - Domains: a text read from a file (no copy-paste) - Projects: carousel of pictures (see attachment): free download from - Careers: one text read from a file (no copy-paste). - Contact: one text read from a file (no copy-paste). - Customer area: fake, it will

Project Duration: 1 Hour Project Type: Data Processing Project Level: Standard Project Overview: We have a CSV file with 2000 rows. We want all content after the last </p> in each cell removed 5* FEEDBACK WILL BE LEFT FOR YOU

...strike source) Requirements: 1. Basic map (level) ( attached). 2. Basic minimap in the top left. 3. FPS Camera with gun and arm models (both the gun and the character model will be sent to you). 4. Basic movement (WASD), mouse movement, jump & crouch. 5. Collision. 6. Press esc to show mouse and a basic pause screen (don't pause the game, just show an overlay) and press esc again to hide mouse/menu. 7. Ability to shoot & show ammo ui to show how many bullets you have left. 8. Ability to reload (no animation, just lower the gun and then raise the gun after 2 seconds). 9. Bullet collisions when you shoot at a wall (just use a grey square for this). 10. Friction so that when the player releases a movement key, it will slowly grind to a halt instead of instantly stoppin...

I have a spreadsheet with approx 1600 rows. One of the cells on each row has a block of text content that I would like rewritten using ChatGPT. There are also 2 other cells in the spreadsheet that contain a few words that needs to be included in the new text output. You can either do this manually, or a better way would be to use the ChatGPT API to complete this task (in a matter of minutes!) I know this can easily be done via the API and how quickly it can complete this task, but I just do not know how to do it, so please bid accordingly.

1. Record call 2 side 2. Work in android 13, 14 3. Get histroy call and contacts 4. Save calls and send to sftp or ssl or .... 5. Clear record calls auto after send 6. Hide in menu

I need a professional to edit captions into my short 1:11 TikTok video. - The captions are already written and need t...up now, get down now get up yeah Up get up now, get down now get up yeah take it outside yeah we send em to the moon and we knock em out southpaw takin all their shoes and the other guys don’t know how to make a move so were gonna cook em up and make chicken noodle soup oh that dude he just run around smooth but then who can even fool him? baby not you and maybe you can try but baby you can’t hide the truth oh no he be lookin right through you old school fresh old school fresh old school fresh old school old school fresh old school fresh old school fresh old school old school fresh old school fresh old school fresh old school old school fresh don&r...

Hello, I am looking for an experienced MS Excel programmer to enhance and automate an existing Excel spreadsheet. The primary goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you have completed. I am loo...

Hi, I have an excel file that contains 190 rows and 6 columns. I need someone to sort the data for me in a text file based on a specific required. Needs to be done now, in a short time frame. Type EXCEL at the beginning of your proposal if you understand the above. Proposals without it will be ignored.

I need assistance with categorizing and aligning 300K rows of course offerings by diff schools into two following items: 1- assign the courses to their appropriate categories (i will provide) 2-few courses are missing description, which needs to be filled out. please see attached screenshot for over understanding.

I'm looking for an Excel expert to assist me with data cleaning tasks and applying conditional formatting in my Excel spreadsheet. Key Tasks: - Remove blank rows and columns: The spreadsheet has some unnecessary empty rows and columns that I need to be removed to make it more concise and easy to manage. Ideal Skills and Experience: - Proficiency in Excel: Expertise in Excel 2010, 2013, 2016 or later versions is a must. - Data Cleaning: Experience in data cleaning tasks, particularly removing blank rows and columns, is highly desired. - Conditional Formatting: Ability to set up conditional formatting to help me visually identify and manage data more effectively.

...we aim to enhance the frontend UI design to achieve a cleaner, more professional look with improved user-friendliness. The primary focus is on making the UI responsive and ensuring seamless API integration for enhanced user experience. Scope of Work: Frontend UI Enhancement: Improve the design of List page with a datatable layout, including features such as Search Sorting Filters Grouping Show/hide columns Column Adjustment Horizontal, Vertical Scroll Create Sub Task from List view Column wise field edit Task reordering Task & Sub Task Expand collapse function Multiselect option Enhance the detail page design with inline edit functions Responsiveness: Ensure that the frontend UI is responsive across various devices and screen sizes for optimal user experience. API Int...

I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish. it is difficult job dont come for Money you should waste y...

I have around 600 scanned images of receipts that need to be ranscribted into a Google Sheet or Excel document. Either manual work or OCR. Key Requirements: - Absolutely must : The data should be categorized into 3 sections (EAN, price and discount to the price), most of the rows are duplicates same prices but different eans. All receipts have no more than 10 rows. Might be a few receips on the photo. Might be duplicated on photos (I can have it duplicated on the spreadsheet it is not a problem). - Nice to have / recommneded: date of the receipt with the total sum as per receipt I will send a link to google drive with all the jpgs (as a viewer). I WILL ALSO DO AN EXAMPLE. Ideal Skills and Experience: - Proficient in OCR (Optical Character Recognition) software to effici...

...and aligning with the new cladding. - Apply contemporary style metal cladding in a light colour to the roof and outside walls lending the building a modern and minimalistic flair. - Add other materials to balcony, soffits etc to complement the metal cladding - choose alternative material on balcony walls to complement and contrast the metal cladding. - Garage walls to match garage door cladding to hide the garage door. -Add guttering and downpipes to complete the design - Adjust design as necessary to enhance it’s architectural appeal. The freelancer for this job should preferably have: - Advanced skills in Revit Architecture - Extensive experience with contemporary building designs - Proficiency in architectural cladding implementation, especially with metal materials. ...

I'm in search of a proficient Shopify developer who can enhance my e-commerce website with a pincode-based product display feature. - Develop a feature that can display products based on a customer's pincode. - The system should hide products unavailable for a specific pincode, and customize the product display based on the customer's pincode. Skills and experience in Shopify development, API integration, and e-commerce platforms are key. The successful freelancer must be able to work independently to deliver a seamlessly integrated and user-friendly product display system.

I require a front-end web developer to create a basic consultancy website for Industry and software topics. There will be no database nor payment functionalities. There will be just one language. Tabs: - About us: 2 cols and 2 rows: col1 = pictures, col2 = text - Team: 2 cols and 10 rows: col1 = pictures, col2 = text, email and linkedin - Domains: 2 cols and 10 rows: col1 = pictures, col2 = text - Projects: carousel of pictures (left, center, right) with arrow left and right to move; text only below center-image. - Careers: 2 rows (job1 and job2) - Contact: 1 row (a description and a email address: opens user mail client) - Customer area: (fake: it will be visible but grayed-out = disabled) Texts and images: - The website reads texts, jobs and pictures from ...

I have 73 PDFs that I need to be converted into separate Excel sheets. The Excel sheets need to follow a specific format, which is in table form with specific columns. Key Requirements: - Convert 73 PDFs into rows of an Excel sheet - The Excel needs to follow a pre-defined format, which I will provide. - The pre-defined format is in the form of tables with specific columns The Excel sheets should contain all the data as shown in the template with a separate summary tab with the following: - Average and standard deviation for each part - Average and standard deviation parts total by invoice - Average and standard deviation trip charge - Average and standard deviation Material markup % - Average and standard deviation Hours - Average and standard deviation Installation labor - Aver...

I'm seeking an expert in R programming and Linear Algebra to analyze a large dataset comprising more than 10,000 rows. As a skilled professional, you'll need to: - Apply your knowledge of Linear Algebra to tackle data analysis. - Perform descriptive statistics to understand the characteristics of the dataset. - Employ regression analysis tools to establish relationships within the data. - Visualize data trends and patterns employing advanced R techniques. The ideal candidate should have substantial experience in data analysis with R and a solid understanding of Linear Algebra. Your portfolio demonstrating similar projects will place you ahead.

I'm currently facing some challenges with my vue.js project. The problem seems to be with how the data is retrieved and displayed in Es-Select components with multiple rows. I'm looking for an expert in Vue.js who can help me resolve these issues. Key requirements: - Strong Vue.js background - Proven ability to troubleshoot data retrieval/display bugs - Experience in working with user-entered data in Vue.js applications Your main task would be to diagnose why this functionality is failing and implement a robust solution that will restore normal operation. Your valuable input could include changes to code or data handling methods. Being able to effectively troubleshoot and resolve this issue is paramount.

...conventional calendar. - Option for users to select their location, with the flexibility to change it as needed. - Enhanced visualization by displaying the names of planetary rulers alongside logos. - Addition of the current day (Monday, Sunday, etc.) with its corresponding planetary ruler and Islamic name. - Division of each day into two sections: Day and Night, with each section divided into 12 rows. -Incorporation of detailed data for each hour, including the ruler, Islamic ruler, start and end times, status, description, and warnings. Sample Data Format: Hour;Ruler;Ruler Islamic;Start;End;Status;Description;Warning 1;Mars;Zuhre;8:10;8:59;Good;Nice to dance; 2;Moon;Merih;8:59;9:43;Bad;Bad for new starts;Warning Message No3 Additional Features: Dynamic color changes in column...

I am looking for a skilled JavaScript developer to help me with some script additions. I have been making a JS Game that needs 3 more functions: #1) On Pause Hide the UFO. #2) On Explosion Count the times the Explosion Happens. #3) Set a time to control the game stops. #4) Make the Page Responsive. The game is just a single page of JS with little html, 2 sound files, 2 image files. $8 for each completed function ... if these goals can all be met is $32. Thanks for looking

..." If on or before "3rd Extension", send to "Webhook 4." If extensions are missing, the script auto-extends deadlines by 2 days to ensure flexibility. The date being input in 1st, 2nd and 3rd Extension is again from Third Party Form, hence DATE IS IN TEXT FORMAT..The date is being added to the google sheet automatically Error Handling and Logging: The script needs to handle Empty rows properly and only check rows with data in them (Column A to D will always be populated whenever someone enters data using the third party form).. so this might help Expected Outcomes 1. Automated Task Management: The script should automate data send to webhooks based on predefined conditions. 2. Reduced Manual Intervention: By auto-extending deadlines and sending da...

Project Description: I am seeking an experienced Wix developer to customize the product pages of our existing Wix store. Our business operates on a B2B model across various countries, each with unique pricing policies. Currently, our website is set up more like a B2C store with visible pricing, which does not suit our business model. Key Requirements: Hide all pricing information on product pages. Modify pages to include a "Contact for Quote" link instead of the price. Ensure that the pricing remains hidden across all product pages without affecting the site's overall functionality and design. Previous experience with similar tasks on Wix websites is highly desirable. Objective: The main goal is to transform our product pages into a format that aligns with our B2B...

I will go ahead and hide the default status bar from the WebView of the application so it will act as a full screen application.

...Customizable home screen: The home screen needs to be user-selectable, allowing them to choose their preferred apps. - Quick search functionality: Implementation of a quick search feature is crucial for user accessibility. Additional Features: - Closing an App after certain time spent in it: The app should be able to close other apps after a user-defined time. - Notifications: The launcher should hide notifications and only display them upon the user's request. - Pop-up messages: Ability to show pop-up messages while the user is in other apps. Ideal Skills: - Proficiency in Java and Google Firebase - Experience in developing Android launcher apps - Strong understanding of Android permissions and management - Prior work on GUI and elegant view design - Ability to implement ...

I'm seeking a skilled PowerAutomate expert to assist in the weekly extraction of both text and numeric data from PDF files. The extracted data will then need to be arranged in a specific format in an Excel sheet. Key Responsibilities: - Extract both text and numeric data from PDF files - Perform the data extraction on a weekly basis - Arrange the extracted data in specific columns and rows in Excel Ideal Candidate: - Proficient in using PowerAutomate for data extraction - Experience working with PDF files and Excel - Attention to detail for correct formatting of data - Ability to meet weekly deadlines - Strong communication skills to verify data accuracy Please find attached pdf (extract) example (there is 5 different templates to use) & excel (input). Looking forward ...

At present, we manage all our revenues and expenditures through multiple bank accounts. For different types of expenses, we use different cards - for instance, the card ending in 1234 is used for fixed expenses, while the card ending in 0123 ...instance, the card ending in 1234 is used for fixed expenses, while the card ending in 0123 is for non-fixed expenditures. All our receipts are sent to Receipt-Bank, which is synced with XERO. - reconcile bank accounts each month - setup inventory management - loan interest - P/L statments - Setup up reconciliation rules Must be finished by 10th of each month Approx 300-400 receipt/bank statement rows need reconciling each month. In XERO, every transaction must be matched with a receipt from Receipt-Bank or reconciled from a bank stat...

...Customizable home screen: The home screen needs to be user-selectable, allowing them to choose their preferred apps. - Quick search functionality: Implementation of a quick search feature is crucial for user accessibility. Additional Features: - Closing an App after certain time spent in it: The app should be able to close other apps after a user-defined time. - Notifications: The launcher should hide notifications and only display them upon the user's request. - Pop-up messages: Ability to show pop-up messages while the user is in other apps. Ideal Skills: - Proficiency in Java and Google Firebase - Experience in developing Android launcher apps - Strong understanding of Android permissions and management - Prior work on GUI and elegant view design - Ability to implement ...

I am seeking a highly organized and detail-oriented freelancer who can beautifully manage the task of entering a significant amount of data ranging from text documents, spreadsheets, to data from forms. The volume of the data will fall approximately between 100 to 500 pages/rows which will require meticulous attention. Skills and Experience needed: - Proven experience in Data Entry - Proficiency in dealing with multiple types of data - Accuracy and fast typing skills - Basic comprehension of PDF format The final delivery file should be precisely formatted in PDF and needs to mirror the original data seamlessly. Only bid if you possess the right skills to perform this task efficiently and meet the quality standards.

I'm in need of a PHP developer who can create a MySQL database from a small CSV file with less than 1000 rows of data. The structure of the new database should replicate that of the CSV file. Rest assured, the file contains no sensitive information. Key skills needed for this job include PHP, SQL, and database design. The successful freelancer will have experience with both CSV file manipulation and MySQL database creation. Client uploads av csv file, then open a website, then, automatic creation of mysql database on a button click First row in csv file is the column names Table name should be the csv file name truncated to the last 16 numbers in the csv file. UTF-8 Varchar 255 PHP 8.3 running

We're working with Pivot grid, and it's a good library, but no longer supported and my team has no real ReactJS skills or time to learn. As such I'm in need of a proficient ReactJS Developer who can make some specific modifications to the library, including nice and automatic resizing of rows and columns based on the data contained, as well as handling dynamic resizing of column width by the user.. Your responsibility will primarily be: - Updating the Pivot grid library to include a column resizing feature - Updating to automatically wrap / detect content sizing between data cells and row cells - Ensuring compatibility with the latest version of ReactJS as we wish to keep our resources contemporarily adept. Your experience and skills should ideally include: ...

I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish. it is difficult job dont come for Money you should waste y...

I am seeking a highly organized and detail-oriented freelancer who can beautifully manage the task of entering a significant amount of data ranging from text documents, spreadsheets, to data from forms. The volume of the data will fall approximately between 100 to 500 pages/rows which will require meticulous attention. Skills and Experience needed: - Proven experience in Data Entry - Proficiency in dealing with multiple types of data - Accuracy and fast typing skills - Basic comprehension of PDF format The final delivery file should be precisely formatted in PDF and needs to mirror the original data seamlessly. Only bid if you possess the right skills to perform this task efficiently and meet the quality standards.

I need an expert to transfer influencer data including names, Instagram handles, and emails from Modash to Google Sheets. This includes: - Opening Instagram accounts listed on the Modash platform - Copy-pasting the 3 pieces of specified data to their respective columns in Google Sheets N.B. The project involves the gathering of 500 rows of above information. Given the nature of the project, speed and a thorough attention to detail is required. The candidate will also need an Instagram account, to be able to search for profiles, and Instagram installed on their phone, for accounts where email can only be accessed on the phone app. Modash account login will be provided. This job will suit a freelancer who is detail-oriented, organized, and experienced in data transfer activities ...

...continuing execution, if the scraper stopped or got IP blocked) Output: CSV of SKUs with the following columns (category, sub_category, brand, sku_name, description, competitor_name, datetime, location, url, nsp, psp, stock_count (if available), popularity_index (if available), weight (if available). If one SKU is contained in more than one category/sub_category, present the same SKU in different rows. Unit tests The scraper must include unit tests that cover main and error test cases, including optional parameters Submission The following must be submitted: - Scraper code and unit tests - README file for running and deploying the scraper - Output of all SKUs from the 3 online grocery apps specified above Project Acceptance Testing The scraper output will be manually verified...

for my online bookstore, I need: in admin part in order details need to add two columns and hide few other

I'm in need of a skilled sales person to help me secure appointments with small businesses in the restaurant industry. This role involves pitching our web design and development services specifically tailored for restaurants. A script and 100 rows of data will be supplied. Key Responsibilities: - Cold calling small businesses. - Convincing restaurant owners or managers to book an appointment. - Ideal Skills and Experience: - Very good English - Proven track record in sales, particularly cold calling. - Experience with B2B sales is a plus. - Familiarity with web design and development industry. - Prior experience selling to restaurants preferred but not mandatory.

...shared (we will share the calculation algorithm) from the database the said calculations need to be done and then pushed for visualization, we will create multiple visualization which need to be dynamics basis parameters selected to view the data. See Some examples of how the platform modules might look like in the attached deck. Database will be huge given the size of data – appx 2 million rows every year. Please come back to me with some information on the technology for creating this platform, any other tech considerations, cloud storage and rough estimate....

...to improve user engagement, meet local market demands, and increase our global conversion rates by implementing advanced location-based customization features on our Shopify site. Objectives: Geolocation Implementation: Integrate a robust geolocation system that identifies the customer's country, state, or province in real time. Dynamic Content Customization: Develop functionality to show or hide products, collections, and content based on the customer’s location. This includes the ability to display certain items in specific regions if required. Key Deliverables: Custom Geolocation Feature: A fully functional geolocation feature that can accurately detect and respond to a user’s location. Dynamic Display System: A dynamic system that alters the avail...

I am in need of a professional who can help build me an advanced cloaker for my ads. I am looking to not only hide my ads from competitors, but also to boost their overall performance and click-through rates. - What I mean by cloaking here is that the process should completely hide the true destination of my site. - In addition to that, it should also help to bypass any potential website access restrictions. - Also, the cloaking solution must ensure overall site protection against detection. As for the nature and types of websites this solution would need to be compatible with, I am unsure at this point so your expertise and advice would be invaluable. Ideal candidates will have: - Solid experience & expertise in ad cloaking. - Understanding of website restrictions ...

I need a freelancer with a deep understanding of Excel ,data management and social media to extract info from profile list that we have . As the project involves organizing approximately 20,000 rows of data, proficiency in handling large datasets will get you far in this task. Key Project Details: - Data Type: The data primarily comprises email addresses and phone numbers. - Links in Profile - Other profiles in the profile - Formatting: The data files contain labels, so you'll need to distinguish this information keenly. Ideal Skills: - Proficient in Excel - Expertise in data management - Data Scraper

1. Dynamic block should generate array of rectangles with dimension of w x h. 2. Input values are : w= width of rectangle, h= height of rectangle, C=number of columns, R= number of rows, A= space between columns, B = space between rows. 3. Each rectangle has the same multiline text attached. Position and size of text is given in sample file. TExt is same for every rectangle, will be edited manually later. Since lots of people don't read this easy description i will save my time and ask you why sky is blue, on which you have to reply : because I have read the description. That means that you understand the project fully and can start working on it. Version ACAD 2007

I am seeking a PowerBI expert to incorporate Row Level Security (RLS) to specific column (and not rows )in a PowerBI table depending on who is signed in. Will share details with interested freelancers. Should be done within a few hours.

...statement data and inject that data into an Excel worksheet. Key Requirements: - The program should be able to access Fidelity Brokerage website. - It should grab financial statement data and inject it into Excel. - Specifically, the program should insert this data row by row into a Microsoft Excel Worksheet. - Each stock symbol which the program should enact on will be in one column - The data rows should be organized by having one row per stock symbol. Ideal Skills: - Experience in API and data extraction. - Strong proficiency in Python, VBScript or other programming languages suitable for this task. - Prior experience in creating Excel macros or programs that interact with Excel. - Knowledge of financial statement data and the ability to accurately capture and ...

... I need to update code to my system. I need to collect live data from the web and candle stick, I have attached the document for data collection from web. Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Please view the attach file. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish. it is difficult job dont co...

I am seeking an Excel expert capable of preparing a comprehensive document comprising more than 10000 rows and columns. The scope of the project involves processing substantial data sets, namely: Organizing Scanned documents and extracting the data, organizing the data in different corporations by department and years. Be able to extract a P/L and AR for all companies. Project is to be done in stages - Text - Numerical data - Date Information The ideal candidate for this job should have: - Expert knowledge of Excel and related functionalities. - Strong attention to detail. - Proven experience of data entry in large volumes. - Familiarity with basic mathematical operation functions within Excel. The deliverable will be a well-structured Excel document crafted with an underst...

I am seeking a professional with strong...understanding of automating tasks in Excel Further Details: - The primary purpose of the project is to send API requests with image URLs listed in column A of the Excel file. Upon receiving the API response, the relevant data should be extracted and placed in column D and B/C/E to be populated. - The setup should be easy to execute when needed by click of few buttons and automatically looping until all rows in excel are submitted by API. - The final deliverable should be in .xlsx format. ATTACHED: - Partial response of JSON API shown in attached screen shot - Format of excel file which shows how the image urls listed on column and other columns to populate. Please submit your bid if you have a strong background in this area.

...Implementing anomaly detection techniques to flag any irregular or unexpected behavior in our system. - Providing actionable recommendations for energy optimization based on the patterns and anomalies identified. Details about the data: I want to have 3 tables: Real time data table: The data will be captured directly from sensors at the form of columns, for example, Device 1, device 2 , device 3, and rows are time captured at growing rate of 1s. the value of the row is the energy consumed of that device at that exact second. This will be a large table. Hourly Data Table: Aggregate data hourly to feed into the anomaly detection model, stored in the 'Hourly' table, to identify significant deviations. Daily Data Table: Summarize daily data for use with the SARIMA model,...