I have a spreadsheet with 7,000+ entries, with a column (column D in attached) which has mixed up date format...format, 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
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'm looking for a Data Analyst for a small project. The right candidate should be familiar with data analysis with advanced experience in microsoft excel, able to give outputs (pivot tables, heatmaps, comparison chats etc) examples of previous work done will be required. thanks.
- Updating of pivot tables to ensure that numbers change when cells are updated - Advanced filtering - Having a data entry sheet and using VBA to transfer the new data to the bottom of the existing data set - Improve user experience by making future data entry convenient
This project involves the use of Excel pivot table/chart and some basic accounting and finance knowledge. Specific instruction is given in red in the "Questions" spreadsheet in the file provided below. Follow the instruction and solve the 5 questions.
Detail Oriented Coder in C# Or Python or Tableau Designer Sample Input [kirjaudu nähdäksesi URL:n] Output Format Tableau or Pivot Style Format in Excel Description 1. Create Sheets and Dashboards calculating Output based on grouping of "Categories" and "SubCategories" of "Parameters" 2. Rank and find the best Combination of th...
...AlphaVantage. 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 with Technical Indicators and Plot 4. Clean and Normalize Data. 5. Using Machine Learning, and
... 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 with Technical Indicators and Plot 4. Clean and Normalize Data. 5. Using Machine Learning, and
Hi Kristine. I did a search for statistician and your name ...most efficient use of farmland to feed as many people as possible. This is all part of the bigger picture of reversing climate change and saving our planet. I was thinking pivot tables might do the job but it might be more complicated than that. Perhaps you can help advise me. Thanks.
...sheets and the Power Pivot Data Model. The challenge with the tool is its very large - +15MB. I am wanting to have a way that once the generate report updates, it selects "Yesterdays" business data in each slicer (or a connected slicer) and then export the unhidden sheets with keeping their values (I'm ok if its a PDF or excel) so that I can email our
Pivot Productions is starting a new division called "Lean Restoration" and needs a logo that compliments/leverages design elements of the Pivot logo (see attached). The logo should communicate: 1. Leaning on each other for support 2. Efficient, cost-effective, minimalist
I need to take the DrFirst metrics report, the OptimizeRX report and run a pivot table comparison report. Example report included. NO STATE LEVEL details needed. just clicks, session time, impressions. Matched up against the SOW and campaign reports.
Looking for a highly skilled excel expert. High level skills with formulas and arrays. Please refer to attached document for details of the 4 charts required. Please provide a fixed price and a time frame for completion.
Hello everyone, We need an Excel expert to build us a few complex Excel workbooks including dashboards, VBA, pivot tables and so on. (financial knowledge would be helpful) This workbooks will be used by executives and small business owners, so it is important that it looks quite sleek and professional. This job opening is for the first workbook: Basically
I need a logo designer for design my pivot profile logo. I will add my pivot profile's URL. So I want design it 3D version and that image is a bit-coin. Here is my profile URL :- [kirjaudu nähdäksesi URL:n] If you interest for this work then please click the link and sign up + install the app. Then you can see my profile in your follow list. Note for
I need an Android developer for fix a little bug. I already use pivot application. It has a little bug. After send another to my URL it can open in browser and sign up. After sign up it said for withdrew money , download the pivot app. After install it can't login using google account in the app. It say 'permission has been denied' please anyone able
First ...we are from pivot team. My name is smith (pivot developer). So our website have a some bugs. That main bug is some time can't sign up. Here is the sign up section :- [kirjaudu nähdäksesi URL:n] If you interest for this work then please click the link and see it. After that if you can fix this bug then please contact us. Thanks you. (Pivot team)
First we would like to tell you we are from pivot team. My name is smith (pivot developer). So we were decide change our main logo & some graphics. Our development team decided join 500+ graphics designer to our website from Freelancer. So don't be miss your chance. Now you have a little task. we will add our website under the description. Then you
Need a developer to build a "Write-back" application for excel pivot tables through VBA preferably. Power Pivot will be pulling from several other excel workbooks that act as "databases". We want to be able to change any line-item data(values & text) within the pivot table, and it update the original raw data. We want to stay away from any...
I'd like to create a dashboard at a Team level, then also rep level too from various KPIs to be defined. The data at the moment is one (perhaps 2) table linked to a local free sql . We can control/update the table/view so calculations can be done at source if required by etl process or in excel The tables contain all the information we should need
Hello Dear,...share the project you awarded and i have an experience in Microsoft Excel for more than 07 years. so i think that i can do well and can give you the completed project with in your time limit. A good grip on excel such as excellent formatting. Pivot Table working and sorting and analysis. ageing and comparison. demand is negotiable
We are a new entrant t...trend. To develop our sales pipeline, we are targeting a competitor's re-seller list and need basic data entry services to transcribe information from their website to a pivot-ready Excel document. sorry for advance milestone . payment - payment after the client approval fix budget 10 to 25$. plz dont bid if not agree. thanks'
...based on common file name attributes (add new data to existing sheets via copy paste). 2) Create new spreadsheet with all data on one tab, and pivot table on new tab. 3) Create 3rd tab with a copy paste of pivot table data so that 3rd sheet is static, not pivot table dynamic. 4) A GUI interface is needed to allow the user to select input and out put
I currently have 20 excel worksheets that record 5 data points on 18 different items for the last 10 years. From there I have 125 different columns of information per day. Some are calculations and some are simply true and false. Then I use pivot tables to create reports. It has become too burdensome doing this with spreadsheets. I would like
I need some excel expert who can help me build some analytics report for analysing trades. Person should have expertise in pivot table etc. He would be guilding me [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions]
We are a new entrant to a fast-growing packed food trend. To develop our sales pipeline, we are targeting a competitor's re-seller list and need basic da...trend. To develop our sales pipeline, we are targeting a competitor's re-seller list and need basic data entry services to transcribe information from their website to a pivot-ready Excel document.
Need a excel pivot and conditional formatting
...accomplish the "End Result" with the use of a formula only - and NO helper columns. - Array formulas are also fine. ** I don't want to use macros ** ** I don't want to use pivot tables ** ** I don't want to use filters ** I just want a formula or array formula to transform the dataset, into the End Result as shown in the example. I have colour coded
...follows 5 rules when displaying each stock.. currently 3/5 correct ) Summary sheet grouped by Stock... and stock trades can be retrieved by date format filter.. Sheet has pivot table .+ vb a macros.. 5 rules should be followed ( see pic for 1 to 5 ) for summary sheet ... (however summary sheet should follow rule 5 to 1 in order to display stocks
I want to be able to take the information displayed on "raw" tab to the information shown in "complete file" so that I can easily pivot off data and do analysis The "raw" tab will have up to 200-300 more clients when normally being used. I only need to see the doctors name, inventory ID, description, total units and amount billed.
...Appointment book with POS *Touch screen interface reduces staff training time *Resource (Service Staff) management *Commission to service staff *Inventory and Service Management *User defined security system *Graphical reports for quick analysis *Easy capture of customer data at POS *Customer Loyalty with reward points management
...follows 5 rules when displaying each stock.. currently 3/5 correct ) Summary sheet grouped by Stock... and stock trades can be reterived by date format filter.. Sheet has pivot table .+ vba macros.. 5 rules should be followed ( see pic for 1 to 5 ) for summary sheet ... (however summary sheet should follow rule 5 to 1 in order to display stocks correctly
I need someone to take approximately 64 tables and build them into a functional pivot table to be used as a dynamic software compatibility matrix. Approximately 5 hours of work.
I have some work, in an Excel spreadsheet.
Mysql server is running in my desktop, to be connected to my remote PC using teamviewer and mysql view to be created as below: Current table is like this: Branch Month Code_A code_B a 1 100 200 b 1 150 300 a 2 75 20 Mysql View to be created such that output should be like thi...
URGENT (in 4 hours) excel work - report - pivot stuff - data presentation