Dear Dan, Thanks for your interest. We are processing the payment of health claims. This involves application of pricers from CMS and so many other calculations depending on contract with contracted (In-network) providers/hospitals, which varies case-to-case. Also deduction of copayment/coinsurance etc. We are using Database program to keep track of claims, members, etc. But I think Database program will not suit our calculation requirements. If you can suggest a way to use filters effectively with keyboard shortcut keys that will be fine.
Thanks Venkat Asst. Manager Process Refinement Team. e4e Tel India : +91 (44) 22681240 - Extn. 164 email: [email protected] www.e4e.com e4e Healthcare Business Services is ISO 9001:2008 & SAS 70 certified company. -----Original Message----- From: Dan Lewis [mailto:[email protected]] Sent: Monday, April 18, 2011 10:56 AM To: [email protected] Subject: [users] Re: Filtering options in Calc [email protected] wrote: > > Dear All, > > I introduce myself as Asst. Manager in my company which is handling > huge data files of Healthcare Providers. > > The problem my team encounters while using Calc are as follows: > > 1. As we are handling huge data, using mouse will hinder the speed of > operation. There is no alternative keyboard shortcut available for > Alt+Down arrow as in Excel to quickly select the filtered data. > > 2. There is an option in Excel Ctrl+G --> _S_pecial, which allows me > to fill the blanks with the text/number above referred by pressing > Ctrl+Enter. I do not find an alternative in Calc Navigator. > > I will be grateful if you can help me to overcome the above. > > Thanks > *Venkat* > > Asst*. *Manager > > Process Refinement Team. > > Is there any particular reason why you are not using Base instead of Calc? Huge data files seem to lend themselves to databases instead of spreadsheets. The tables of the database would contain the data, and queries can be used to access this information in whatever form you needed. I personally think a database would fit your needs Dan -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain confidential and privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure,dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender and destroy all copies of this communication and any attachments. 'e4e Healthcare Business Services is an ISO 9001:2008 & SAS 70 certified company'. -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
