I have a spreadsheet (Source Spreadsheet) where I can populate latest data, need the data to be automatically updated to a pivot table (Pivot Table Spreadsheet) whenever the source spreadsheet is updated. The pivot data information is needed to populate another tracking spreadsheet (Tracking). Tracking spreadsheet must have the flexibility to merge
Main Tasks: 1. Preprocessing of databases. 2. Connection of databases - solution (partially solved). 3. Create a scalable, easy to update data warehouse, with all connected databases (MySQL, Oracle etc.) 4. Data visualization (construction of web application or use of Powerbi, Tableau etc.) Before collaboration, a phone call or Hangouts meeting is needed so that we discuss further details and c...
I need an excel database that manages and stores test engineering data, is able to generate charts of selected sample data, and provides basic statistical analysis of the collected data. The database must have an input form (separate to the data spreadsheet) and a report generation functionality, so that the stored data can be searched using selected
...erstwhile Wincor-Nixdorf (current Diebold-Nixdorf) Proview Data structures fully well. 2) Idea is to build an alert & service management app (workflow) on top of the these two database schemas to have a common app for service or cash outage. Alert should come out in different ways: a) Net Cash volume remaining in the dispensers being (10-25%) threshold
...the macro, MS Access will export summary report in excel format and exit open 1st excel and copy data form particular sheet and range open 2nd and past data in required raw or column or end of the previous data refresh pivot table and formula select a fixed range data and copy form 2nd excel open outlook new mail and past on the mail body
Pivot Table Reminders 1. Create a pivot table in excel or google sheet. 2. I have got around 10 sheets of data with various client details which includes fup date. 3. When the FUP date is due I want the entries to be separately displayed in the pivot table for 1 week and after that when I click finish the entry should expire. 4. I should be able edit
...hired from this site, I setup a dedicated centos linux 7.5 web host with cpanel/whm and setup whm/cpanel for 12 domains. I need help for troubleshooting ftp issues, MySQL Database issues, rvsite and rvsitebuilder issues for my cent os 7 dedicated server and check for general maintenance to find out whether there are other errors. I estimate two hours
...directions. 2. The mobile app needs to have the functionality of OSMTracker built in with slight modifications to allow for dog specific buttons. 3. The mobile app needs to have a database of resources, other rescues, vets, emergency clinics, etc. 4. The mobile app needs to have a comprehensive dog sound creator, from puppy cries to angry barks, etc. 5. The
I need you to build a website for my small business.