MicrosoftExcel has proven to be an important application in the litigationprocess for most of the federal judges. Given that Microsoft Excelhas many uses, this paper confines itself to the use of MicrosoftExcel in compilation of lists of different types of offenses that areperceived to be civil in nature yet received criminal sanctions,compilation of the relevant statistics and development of the way topresent those statistics in a simplistic manner to the entire jointcommission.
Whenin need to compile lists of different types of offenses that areperceived to be civil in nature yet received criminal sanctions,Microsoft Excel comes in handy. One of the functions that will becritical in ensuring that there is a distinction made for the casesthat are perceived to be civil in nature yet received the criminalsanctions is the “IF” function. The “IF” function is alogical function that gives a response of true or false depending onthe set condition. Also when compiling the list, the judge can usethe MATCH function that will ensure that return on the relativeposition of an item in the array is given that matches certainparticular value. The judge can also depend on the sort data tool tohelp in the easy analysis of data. Through this, the data can bearranged a list of names in a given order. In this case, it is a listdepending on the type of offenses. Through sorting of data, one caneasily visualize and comprehend the data better and quickly locatethe data that they need to help them make very efficient decisions(Salkind, 2016).
MicrosoftExcel is significant to the judges as it can be used in thecompilation of different and relevant statistics. A case in point isthe use of Excel in the determination of case valuations. Theapplication is critical in the tabulation of damages for thedifferent types of legal claims that are made. This application is abetter used in the multi-plaintiff case where different line itemsare subjected to various final calculations or in situations, thatamount of damages can vary depending on different issues such as theinterest rates, the fees of an attorney or even the time passage.Using the Excel function one can add the probability column to everyrow in a damages calculation and come up with the best calculator forthe practical value of a case. Having this kind of data, the federaljudge would know the odds of success and monetary damages and on theother side know the liability exposure that defendant is likely toface. When deciding a case and the judge has to decide on dates anddeadlines, Excel can be used as calculator and calendar given thataccuracy level that it exhibits(Svider, Kovalerchik, Mauro, Baredes & Eloy, 2013).For instance, when a judge is to give a conclusive answer within 21days after the serving of complaint, the parties involved may requesta deadline extension, but the court has to enter an order for theextension to be guaranteed. Using the manual calendar can bemisleading as the count is likely to be physical. To avoid miscountor start on a wrong day, Excel function can be used.
MicrosoftExcel is essential in the presentation of the statistics in asimplistic manner to the entire joint commission. The simplisticpresentation can be done through the use of different graphs that canvisualize the collected statistics(Delehanty, Llanes, Rath & Sheff, 2014).Graphs of the number of undocumented entry into the United States(U.S) or even the number of illegal drugs can be compared to othercrimes for ease of analysis and decision-making(Delehanty et al., 2014).Therefore, Microsoft Excel plays critical role in compilation oflists of different types of offenses that are perceived to be civilin nature yet received criminal sanctions compilation of therelevant statistics and development of the way to present thosestatistics in a simplistic manner to the entire joint commission.
Delehanty,J., Llanes, Y., Rath, R., & Sheff, D. (2014). EnhancingEfficiencies in the Appellate Process through Technology. J.App. Prac. & Process, 15,77.
Salkind,N. J. (2016). Statisticsfor People Who (Think They) Hate Statistics: Using Microsoft Excel2016.Sage Publications.
Svider,P. F., Kovalerchik, O., Mauro, A. C., Baredes, S., & Eloy, J. A.(2013). Legal liability in iatrogenic orbital injury. TheLaryngoscope, 123(9),2099-2103.