...be set as a default setting. The data is to be returned into a table must have the following features (see ref link) - Fixed headers, Horizontal scroll, Resizable columns, Zebra striped rows, Sortable columns, Searchable columns, Formatting must be as per tables shown in reference. Table format refernce ([kirjaudu nähdäksesi URL:n])
I have an excel tool that shows daily, week to date and period to date data for our locations. In the Power Pivot Data Model the "RegionArea" Tab is outdated. I want to update this with the tab "Alignment" but would want this data in Power Pivot replacing "RegionArea". You would have to change relationships in PowerPivot as well. This should be a ...
The requirement is to create a macro on an excel data set. The macro should be able to do the following tasks: 1. Should do minor data corrections with the click of a button 2. Identify the trending of data 3. Generate graphs based on certain logic These are high level requirements. Details will be shared once confirmation received.
Hello, i need a table with filter/search / edit functionality from front end just like this one : [kirjaudu nähdäksesi URL:n] my server is classic shared hosting php+mysql (cpanel). PLease visit thelink before contacting me thank you
Need a developer to make an excel macro. The excel macro when run should do the following: 1. Download closing prices of a family of stocks (NSE/BSE India) from the internet 2. Update them in excel automatically 3. For each stock, perform exponential regression, calculate ATR, 100 day EMA, and if there is more than a 15% gap in prices in the past
I need to compáre data and provide trend analysis on a monthly basis. I will provide the data but need to understand how to do the comparison pulling different areas of sheer
I need a three figures to be used in a short article in a trade magazine to be created and formatted nicely. See attached document.
...Dashboard: The indicator will scan all currency pairs across all timeframes to spot where divergence exist between momentum indicators (RSI & MACD combo) and Price at the major pivot levels (confluence of daily, weekly and/or monthly) then display the result in form of a dashboard which is scrollable and sortable by candle age, currency pair, or timeframe
I have a set of Excel spreadsheets that builds out graphs on stock market data, but a while back, Yahoo Finance cut off it's free download API and I am not able to get the stock market data. I just need someone to program the macro to: 1. Download the data for the symbol that I put in up to the maximum years back per the data vendor 2. Put the weekly
I need two tables and a query built. One with the amazon product taxonomy created (breadcrumbs also: Clothing->Tops->Shirts... etc). Second table would be one where I can add a product attached to a particular taxonomy item. The query would be to select a taxonomy level with all the products attached to that level and its child levels. (example user
I'm looking to achieve something along the lines of this: [kirjaudu nähdäksesi URL:n] (scroll down to the table) - the data is embedded from [kirjaudu nähdäksesi URL:n] in an attractive format that is responsive on all viewports. Using an iframe and css isn't achieving what I'm after.
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
...two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned
i have an excel out put from an app which i want to paste it into excel on one sheet and then have another sheet on the master file which pulls key data from the pasted file and then i want to click on a macro button to copy the new manipulated sheet and create a new sheet without the manipulator in it. i also want the new excel file to retain its
I was creating a wordpress plugin and i need somebody help me in it...the plugin i able to list out the values from database in wp list table ..but i am not sure how to create a edit screen of that listed items. The database values are coming from forntend contact form 7 form submission.
I want to get assistance in a PowerPoint presentation to present in company. Extract some information from pivot tables / graphs in Excel to be included in Maximum 10 slides with good animations and transitions. Freelancer must know how to include my edited video visuals autoplay in slideshow. It is required urgent. More info and file in Chat.
I need help with economics. Three projects to be finished in a timely manner. Masters in economics is preferred.
We have a financial modelling calculator that is having issues when transferring data in from an external source (CSV file). The original programmer is no longer available to trouble shoot. We are in need of a programmer going forward so there may be more work to follow if this task is completed to our satisfaction. ASAP Update: AUS/NZ preferred
I would like to automate a report based on a series of questions my empoyees fill out out. I need a way to auto generate a sample phrase into a word document based on a yes no question. So the employee checks of yes or no on a form. If it is no then then word will generate a response. If the employee checks yes they will have the options to check a/b for an answer and that will generate an answe...
...populate CSV / DB Preferrred. Datasource to be used Yahoo, AlphaVantage, EOD Historical Data. ex. Download data from Datasource, if error, try another datasource. Check if filepath exists, if not create it . If file doesnt exist, save data to file, If file exist, load from csv . 2. For each Stock Ticker calculate Pivot Points 3. Create Dataframe
I need you to develop some software for me. I would like this software to be developed for Windows.
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
We currently are measuring campaign response and reporting campaign response via a multi-tab Excel spreadsheet that relies on Pivot Tables and Vlookups to take a list of results and measure and track program success. We are seeking to streamline this process and build something that can grow with our project. We have 15 different clients feeding one
I have a spreadsheet with 7,000+ entries, with a column (column D in attached) which has mixed up date format (some a...it reverses some of the dates, which provides incorrect data. I need the dates to be correct, in the English (U.K.) format (DD-MM-YY), so that I can export them into a pivot table. I need the work to be completed within 60 minutes.
Database includes 4 tables, from these four table complete the following and submit the result sets along with the SQL scripts and Pivot table created.: 1. Select details of all patients aged less than 18 years on the visit date who were seen in more than one department in calendar year 2017. The result set should have ONLY one record for each patient
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
I need to convert a tradingview script into python ! To use it as indicator and backtests on Price chart. Here IS the script: //@version=3 strategy("Pivot Reversal Strategy", overlay=true) // === BACKTEST RANGE === FromMonth = input(defval = 2, title = "From Month", minval = 1) FromDay = input(defval = 1, title = "From Day", minval = 1) FromYear
Manufacturing business wants to take a daily download excel file from GE Appliance website and create a Macro/VBA tool for non-excel users. The tool would look up our internal part number and box count from a table and output a pick sheet for shipping with customer part number, our part number and number of boxes. Should be able to select time range
I have a very complex macro which takes a csv of all our orders and put it in a neat printable html format. It isnt doing one of the things its supposed to properly so I need that fixing and I also need to give it some extra functionality.