data from text files depend on user inputs and get data in proper format and then create charts from that data..
I need the total number for each repeated word in each column .( Sector – Rank- Hospital Referred to – Specialty- Mode of Transportation - From Service Type (IP -OP) - Requested Service Type – STATUS). (Monthly, quarterly, yearly count). (NEED a CHART)
I need to know why a single hospital is rejecting more specialty than specialty but accepting more of other specialty. In addition, to know the STATUS of each SPECIALTY in Each HOSPITAL with the result (never accepted, some accepted, always accepted). (NEED A CHART)
EXCEL and WORD FILE ATTACHED.
WORD FILE - I put lines to compare for periodic Display in the BOX .I need all measured by total number of patient (per month, Quarterly or yearly) or by Hospital. or by specialty or by response.
Attached a file about the recent work that was with minimal knowledge and effort.
I need an automated file that makes this CHARTS AUTOMATICALLY GENERATED upon Data entry. (if possible the days and time will placed in the DATES FIELDS Easily .
Please connect files Spread Sheets and sheets to charts or any other made table to Generate the Charts (for automatic Counting and calculation)