WE DO HAVE A WORKBOOK TEMPLATE THAT WE USE TO STORE DATA - -Ability to pull off a the PDF MCM Rprt for All encounters that headers get changed according to the encouter information entered on the demographic sheet for those encounters. - Ability to pull off a PDF MCM rprt per encounter now it is pulling only from encounter No1. it is not changing to pull from Encounter No 2 ,3 4 etc... - MCM rprt now pulls information from 2 sheets calls and other activities sheets notes section however do want to add a column on each of those sheets NAME it Rprt as dropdownlist R/NR - default it to R. if user choose NR this line of notes should not show up on the MCM rprt. - add a button function Generate VOB - where the user can generate a PDF letter that fill in information from various sheet of the workbook and email it with standard email body text we provide. - we issue now invoice from this workbook the invoice print area need to be fixed as it should expand according to the number of lines filled in automatically. - Billing we need a VBA Formula fix the current call formula to bill by 6 minutes increment the current formula is not doing so if the calls are total of 7 minutes it is billing 6 minutes but it should have billed 12 minutes. -Add a billing set up console for Admin to set up the billing rules based on total claims total savings and billed amount UTD. if the user exceed that setting it should create a pop up window everytime someone open the case and then admin or biller can override it once override it the regular billing can proceed. -Make fields on savings and Demographics mandatory so users do not forget to enter. -Make new line of records as standard row that will show on other activities sheet once a workbook is assigned to a new case. ( add automatically those lines) -NDA MUST BE SIGNED -MUST BE ABLE TO CONDUCT A SHARE SCREEN SESSION THRU SKYPE OR VIDEO SESSION TO ASSESS THE WORKBOOK PROJECT ONCE ASSIGNED ONLY THEN THE WORKBOOK WILL BE SHARED. - WE NEED THIS DONE IN 24 HOURS TURN AROUND TIME FROM TIME OF ASSIGNMENT.
Advanced AR Headset Development Category: Android, Game Development, IPhone, Matlab And Mathematica, Mobile App Development Budget: ₹500000 - ₹1000000 INR