Read classmates post and respond with 150-words:

The coding systems that will be encounted are ICD-10-CM, CPT, and HCPCS. CPT describes procedures and treatments the healthcare provider performs (Pepper, 2020). This focuses on services that the provider can provide. HCPCS, on the other hand, deals in services and supplies not handled by the provider (Pepper, 2020). This means that ambulance rides and braces are covered through this coding system. This is very important for elderly patients that need supplies such as walkers and patients involved in serious events that result in an ambulance ride. ICD-10-CM coding describes the diagnosis of a patient (Pepper, 2020). This is very important to have in the Superbill. They are all equally important and are used together to ensure proper billing occurs. HCPCS is not always needed depending on the circumstances, but the CPT and ICD-10-CM are typically always utilized. The more specific the code the better. Vague codes are not considered to be valid.

Payroll Lab

You will be taking in a file (payroll.txt) which details a number of departments (at least 1) and in each department are a set of employees (each department will have at least 1 employee or it would not appear on the payroll sheet). Your job is to read the file in separate out each employee and calculate the total values (hours, salary, number of employees) for each department and in each category (F1, F2, F3, F4). In your final submission please include the .cpp file which should work for any kind of payroll file I supply (which will naturally match the format of the examples below). Be sure to indicate in your submission text if you have attempted any of the bonus points .

An example file:

The IT Department
Bill 8 7 8 9 7 F1
Bob 205103 0.08 F3
Betty 8 8 7 8 8 F2
Brandon 10 10 9 6 9 F2
Brad 9 8 10 9 9 4 1 F4

The Sales Department
Kyle 88840 0.105 F3
Tyler 105203 0.085 F3
Konner 8 6 7 6 9 F2
Sam 309011 0.045 F3
Kent 9 8 9 9 9 0 0 F4
EOF

An additional example file:

The Sales Department
Mike 5 6 1 3 5 F1
Mark 98103 0.115 F3
Jill 8 8 8 8 8 F2

Frank 106101 0.095 F3

Mark 76881 0.091 F3

Department of Records
Konner 8 6 7 6 9 F2
Tammy 7 3 7 2 8 F1

Anika 8 8 8 8 8 F2

Marta 1 0 0 5 2 F1
Kent 9 8 9 9 9 0 0 F4
EOF

Last in the row after the hours comes the pay grade (F1, F2, F3, F4). The number of hours recorded is based on the pay grade of the employee. F1 and F2s will have 5 numbers for their hours. F3s are commission based where a sales amount and a commission percentage is given. F3s are also assumed to work 30 hours if their commission is 10% or below and 40 hours if their commission is above 10%. F4s will have 7 numbers (as they are on-call during the weekend). Each of the pay grades will also have different pay calculations which are as follows:

F1 = The total number of hours * 11.25
F2 = (The total number of hours – 35) * 18.95 + 400
F3 = The total sales amount * the commission rate
F4 = The first 5 hourly totals * 22.55 + Any weekend hourly totals (the last 2) * 48.75

Your output to the screen should start with the department name, followed by the total pay for all of the employees, then the total number of hours, and the total number of employees. After that you should have a breakdown of each category of employee: F1 total pay and total hours, F2 total pay and total hours…

Each department will have at least 1 employee and each department will contain the word “Department.”

The IT Department
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##
Roster: Bill, Bob, Betty, Brandon, Brad 

F1:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F2:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F3:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F4:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

The Sales Department
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##
Roster: Kyle, Tyler, Konner, Sam, Kent

F1:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F2:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F3:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F4:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

Before coding your solution, take the time to design the program. What are the possible things that the file can have that you need to anticipate? What are the actions that you need to take (read the file, add up hours…)? Are those actions things that could be placed in separate functions? What about the function – can you guess some of the things that will happen? Such as, using substring to pull out part of a line in the file maybe using stoi to convert a string to an integer to add it to the total or creating variables to hold the employee type you find before passing it to another function. Finally, how are these functions called, what is the order and what information is passed to and from? 

Scoring Breakdown

25% program compiles and runs
30% program reads in and calculates the figures for output
10% the program is appropriately commented
35% outputs the correct information in a clear format 

5% bonus to those who can output the F# responses in a columned output like that shown above.

5% order the employees in the roster according to their F status, F1’s first, then F2’s and so on.
5% bonus to those who do a chart comparing the data at the end to show the relation between the pay grades and the amount of salary spent in each (they style of chart is up to you and more points may be given for more difficult charts (like a line chart):

B Department
F1 – 00000000
F2 – 000000
F3 – 00000
F4 – 000000000000 

K Department
F1 – 0
F2 – 0000
F3 – 0000000000
F4 – 0000000 

Or event something like this instead:

0
0 0
0 0 0
0 0 0 0
0 0 0 0
F1 F2 F3 F4

The American Community Survey of New York data describe a family’s economic, housing, and demographic information such as yearly incomes, family type (married, female head, male head, etc), number of people, number of children, if the family is living on FoodStamp (1=Yes, 0=No), number of people who are currently employed, etc. Use this data set to answer the following questions:

Questions:
1. Choose an appropriate model to determine if there is family income (i.e., FamilyIncome in the data set) difference among different types of families (i.e., FamilyType in the data set) in the state of New York?

2. Choose an appropriate model to determine if there is family income (FamilyIncome) difference between families with kids and families without kids? (Note: There is currently no column holding data about whether a family has kids. You may want to use the with() function in R to create a new column to hold the binary answers.)

Click Here for How to Use the with() Function.

3. Choose an appropriate model, and use FamilyIncome, NumChildren, NumPeople, NumWorkers to predict the probability that a family is living on FoodStamp.

(Note: please ignore the warning message such as glm.fit: fitted probabilities numerically 0 or 1 occurred if you see one)

Please save the screenshots of the data analysis results and your interpretations of the results into a Word document, and name it as “MyAssignment1”. Thank you!

 Use the web or other resources to research at least two criminal or civil cases in which  recovered files played a significant role in how the case was resolved. 

Exp19_Excel_Ch01_ML1_Rentals

Project Description:

You manage a beach guest house in Ft. Lauderdale containing three types of rental units. Prices are based on peak and off-peak times of the year. You need to calculate the maximum daily revenue for each rental type, assuming all units are rented. In addition, you need to calculate the discount rate for off-peak rental times. Finally, you will improve the appearance of the worksheet by applying font, alignment, and number formats.

Start   Excel. Download and open the file named Exp19_Excel_Ch01_ML1_Rentals.xlsx. Grader has automatically   added your last name to the beginning of the filename.

You want to format the main   title to have a consistent appearance to other documents and spreadsheets.
 
  Apply the Heading 1 cell style to the range A1:G1.
 

  Hint: Cell Styles is on the Home tab.

You want to apply a similar,   complementary style to the date, which is below the main title.
 

  Apply the 20% – Accent1 cell style to the range A2:G2.

The Peak Rentals heading is   centered over the related data in columns C and D. You want the Off-Peak   Rentals heading to be centered over its related data.
 

  Merge and center Off-Peak Rentals   in the range E4:G4.
 

  Hint: Merge and Center is on the Home tab.

To help other people know that   the Off-Peak Rentals heading is related to three columns of data, you want to   apply a fill color to that heading. You will choose a different color to   distinguish these data columns from the fill color used for the Peak Rentals   heading.
 

  Apply Blue fill color (the eighth color below Standard Colors) and White,   Background 1 font color to cell E4.
 

  Hint: Fill Color and Font Color are on the Home tab.

Three headings (Maximum Revenue,   Maximum Revenue, and Discount Rate) do not fully display on the fifth row.   Instead of widening the columns, you want to wrap the headings within their   respective cells. This will enable you to maintain the column width   appropriate for the data below the headings.
 

  Center and wrap the headings on row 5.
 

  Hint: Use the Home tab.

You are ready to calculate the   Peak Rentals Maximum Revenue that can be earned. The maximum revenue is the   total revenue if all rental units are rented.
 

  In cell D6, enter a formula that calculates the Peak Rentals Maximum Revenue.
 

  Hint: Formula is: No. of Units*Daily Rate

The Discount Rate is the   percentage off of the Peak Rentals Per Day Rate used to calculate the   Off-Peak Rentals Per Day rate. The Studio Apartment rents for $120 Off-Peak,   which is 80% of the $149.95 Peak rate. Therefore, the Discount Rate for the   Off-Peak Per Day rate is 20%.
 

  In cell G6, enter a formula that calculates the Discount Rate for the   Off-Peak rental price per day.
 

  Hint: Formula is: 1-(Off-Peak Rentals Daily Rate/Peak Rentals Daily Rate)

You created formulas for the   Peak Rentals Maximum Revenue and the Discount Rate for the Off-Peak Rentals   for the Studio Apartment rental type. Now you want to copy the formulas to   the remaining rental types so that you don’t have to create formulas again.
 

  Copy the formula in cell D6 to cells D7:D8. Copy the formula in cell G6 to   cells G7:G8.
 

  Hint: Use the fill handle.

The values in the columns are   hard to read with varying number of decimal points. The Accounting Number   Format will align the decimal points and display dollar signs to improve the   appearance of the monetary values.
 

  Format the range C6:F8 with Accounting Number Format.
 

  Hint: Accounting Number Format is on the Home tab.

The Discount Rate formula   results are displayed as decimal points. However, formatting the values as   percentages will align decimal points and clearly indicate the percentages.
 

  Format the range G6:G8 in Percent Style with one decimal place.
 

  Hint: Look in the Number group on the Home tab.

You applied a solid blue to the   Off-Peak Rentals heading, so you will apply a complementary lighter blue fill   color to the data below that heading.
 

  Apply Blue, Accent 1, Lighter 80% fill color to the range E5:G8.
 

  Hint: The Fill Color palette contains an option for selecting more colors to   customize.

A solid red fill is applied to   the Peak Rentals heading. You will select a complementary custom fill color   for the data below that heading.
 

  Select the range C5:D8 and apply a custom fill color with Red 242, Green 220,   and Blue 219.
 

  Note, Mac users, in the Colors dialog box, click the Color Sliders tab and   then select the RGB Sliders.
  Hint: On the Home tab, in the Font group, click Fill Color, and then click More   Colors.

Answer the first question below   the worksheet data. Apply Yellow highlight color to the correct answer in   either cell A16, A17, or A18.

Answer the second question below   the worksheet data. Apply Yellow highlight color to the correct answer in   either cell A22, A23, or A24.

Answer the third question below   the worksheet data. Change XX.X% to   the correct percentage in cell A28.

Now that the worksheet contains   formulas and is formatted, you are ready to apply Page Setup options to   prepare the worksheet to be printed, if needed.
 

  Select Landscape orientation, center the data horizontally on the page, and   apply the setting to fit to one page.
 

  Hint: The Page Layout tab contains options needed.

It is important to provide   identification information in a footer of the worksheets. In particular, the   textbook series name, the worksheet name, and the file name help identify the   worksheet.
 

  Insert a footer with the text Exploring Series on the left side, the sheet name code in the   center, and the file name code on the right side.
 

  Hint: Use the Insert tab or the Page Layout tab to insert a footer.

To preserve the original data,   you make a copy a worksheet so that you can manipulate the data or if you   want to review the formulas.
 

  Create a copy of the Rental Rates worksheet, place the new sheet to the right   side of the original worksheet, and rename the new sheet as Formulas.
 

  Hint: Display a shortcut menu from the sheet tab.
 

You want to display the formulas   and set print options so that it will be easier to read and interpret the   rental formulas on a printout, if needed.
 

  On the Formulas worksheet, display cell formulas, and set options to print   gridlines and headings.
 

  Hint: Use the Formulas tab on the ribbon.

Exp19_Excel_Ch09_Cap_Housecleaning_Service

Project Description:

You manage a housecleaning service. As manager, you schedule the cleaners with clients, provide cleaning supplies, and insure the cleaners. You pay the cleaners for their time and mileage reimbursement. You set up a monthly workbook with one worksheet per week to enter the dates, mileage to each house, and start and stop times. You then calculate the hours worked. You are ready to calculate weekly totals and the monthly totals.

Start   Excel. Download and open the file named Exp19_Excel_Ch09_Cap_HouseCleaners.xlsx. Grader has automatically added   your last name to the beginning of the filename.

The title and column labels in   the Week 1 worksheet are formatted with cell styles. You want to apply this   formatting.
 

  Group the Week 1, Week 2, Week 3, and Week 4 worksheets. Select the range   A1:B1 on Week 1 and fill formats only across the other weekly worksheets.

Now you want to fill the formatting   and contents to the other worksheets.
 

  With the four weekly worksheets still grouped, select the range A11:E11 and fill   both content and formatting across the other weekly worksheets.

You want to unlock the   data-entry cells on the weekly worksheets.
 

  With the worksheets still grouped, select the range A12:D40 and unlock the   cells.

You want to create a data   validation rule to control data entry.
 

  Ungroup the weekly sheets, select the range D12:D40 in the Week 1 sheet, and   then create a data validation rule with these specifications:
  • Allow Time greater than cell C12.
  • Enter the input message title: End Time.
  • Enter the input message: Enter the end time. (including the period).
  • Select the Stop error alert style.
  • Enter the error alert title: Incorrect End Time.
  • Enter the error message: The end time must be later than the start time. (including the period).

You want to duplicate the data   validation rule on the other worksheets.
 

  Select the range D12:D40 (if needed) and click Copy. Click the Week 2 sheet   tab and group Week 2, Week 3, and Week 4 sheets. Select the range D12:D40,   click the Paste arrow on the Home tab, select Paste Special, click Validation   in the Paste Special dialog box, and then click OK. Ungroup the sheets.
 

  Note: Paste Special validation is not available on Excel for Mac. Excel for   Mac users need to repeat Step 5 to create validations on the Week 2, Week 3,   and Week 4 worksheets.

Display the Week 2 sheet and   insert a split bar between rows 22 and 23.

Although the data validation will prevent future errors in data   entry, it did not correct errors in the existing data.
 

  Display the Week 1 sheet. Circle invalid data to identify cells containing   invalid end times. Display the Month sheet. In cells H4 and H5, indicate the   name of the cells (e.g., A1) that contained the errors (do not enter a   formula). Display the Week 1 sheet again. Change the first incorrect end time   to 11:00 AM. Change the second end time to 4:15   PM.

The hourly rate you charge   clients, the hourly wage you pay your housecleaners, and the mileage   allowance are stored in a separate workbook. You will create links to those   inputs to perform calculations in the weekly worksheets.
 

  Open Exp19_Excel_Ch09_Cap_HouseInput.xlsx.   Arrange the two open workbooks vertically to display both workbooks at the   same time. Display the Exp_Excel_Ch09_Cap_HouseCleaners   workbook and group the four weekly worksheets. In cell B5, multiply the Total   Hours that is stored in cell B4 by the Customer Cost per Hour that is stored   in cell B3 in the Exp_Excel_Ch09_CapHouseInput   workbook.

In cell B6, multiply the Total   Hours that is stored in cell B4 by the Cleaner’s Pay per Hour that is stored   in cell B4 in the Exp_Excel_Ch09_Cap_HouseInput   workbook.

In cell B7, multiply the Mileage   that is stored in cell B3 by the Cleaner’s Mileage Reimbursement that is   stored in cell B5 in the Exp_Excel_Ch09_CapHouseInput   workbook.
 

  Ungroup the worksheets, close Exp19_Excel_Ch09_Cap_HouseInput,   and maximize Exp19_Excel_Ch09_Cap_HouseCleaners.

The Month worksheet was created   to calculate the totals for the month. You will insert functions with 3-D   references to add data from each worksheet.
 

  Display the Month worksheet. In cell B3, insert a SUM function that uses a   3-D reference to add the mileage from the four weekly worksheets.

Copy the function from cell B3 to the range B4:B8. Use the Auto Fill   button to Fill Without Formatting to preserve the original formatting in the   range.

Now you are ready to calculate   the weekly charge for Week 1.
 

  In cell E3 in the Month worksheet, create a formula with a 3-D reference to   display the contents of cell B5 from the Week 1 worksheet.

You are ready to enter similar   formulas with 3-D references to display the total weekly charges for the   other three weeks.
 

  In cell E4 in the Month worksheet, insert a formula with a 3-D reference to   display the contents of cell B5 from the Week 2 worksheet.
 

  In cell E5 in the Month worksheet, insert a formula with a 3-D reference to   display the contents of cell B5 from the Week 3 worksheet.
 

  In cell E6 in the Month worksheet, insert a formula with a 3-D reference to   display the contents of cell B5 from the Week 4 worksheet.

You want to create hyperlinks   from the Month sheet to the cells containing the total weekly client charge   for each week.
 

  In cell D3 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 1 sheet. Include   the ScreenTip text: Total client charges for Week 1 (no period).
 

Now you will insert hyperlinks   to the second weekly worksheet.
 

  In cell D4 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 2 sheet. Include   the ScreenTip text: Total client charges for Week 2 (no period).

Now you will insert hyperlinks   to the third weekly worksheet.
 

  In cell D5 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 3 sheet. Include   the ScreenTip text: Total client charges for Week 3 (no period).

You are ready to insert the last   hyperlink.
 

  In cell D6 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 4 sheet. Include the ScreenTip text: Total client   charges for Week 4   (no period).

Create a footer on all   worksheets with your name on the left side, the sheet name code in the   center, and the file name code on the right side. 

Protect each worksheet so that   others can select the default cells but not make any changes.

Mark the Workbook as Final.
 

  Note: Mark as Final is not available in Excel for Mac. Instead, use Always   Open Read-Only on the Review tab.

1. WEB ANALYTICS MEASUREMENT MODEL FOR GOOGLE MERCHANDISE STORE 

GO19_AC_CH01_GRADER_1G_AS – Open Houses 1.0

#GO19_AC_CH01_GRADER_1G_AS – Open Houses 1.0

#GO19 AC CH01 GRADER 1G AS – Open Houses 1.0

  In this project, you will create database objects to track the open  houses for the Health Professions departments at a college. You will  create a table and import data from Excel to create a second table. You  will use a database template to enter data into the Events table. You  will create a simple query, a form, and a report.

Start   Access. Open the downloaded file named Student_Access_1G_Open_Houses_AS.accdb, enable the content, and then   close the Event List multiple-items form that automatically opened. Open the   Navigation Pane.

In Datasheet view, create a new   table. Beginning in the second  column of the table and using the data type of   Short Text, create the Department Name, Contact Last Name, Contact First Name, Campus, Phone, and Department Email fields (in that order). In the eighth column,   using the Currency data type, create the Special Pay field.

Change the data type of the ID   field to Short Text, rename the ID field to Department ID.

Starting in the Department ID   field, add the following three records to the new table:

HIT 

Health Information Technology

Lynneff 

Deborah 

Northwest 

(512) 555-6185

[email protected]

40 

LPN 

Licensed Practical Nursing

Gilbert 

Thomas 

Northwest 

(512) 555-1551

[email protected]

25 

PLB 

Phlebotomy 

Woodward 

Jean 

Northwest 

(512) 555-9012

[email protected]

30 

Save the table as Departments, and then close the table.

Append the records from the   downloaded Excel file a01G_Departments.xlsx   to the Departments table.

In the Navigation Pane, organize   the objects by Tables and Related  Views. Open the Departments table (the   table has 14 records). Close  the Navigation Pane.

Switch the Departments table to   Design view. Delete the Campus field. For the Department ID field, enter a   description of Enter one to five characters for the Department ID and then change the field size   to 5. Enter a description of Payment for   each open house event   for the Special Pay field. Save the table.

Switch to Datasheet view, apply   Best Fit to all of the fields in the table, save the table, and then close   the table.

Import the records from the   downloaded Excel file a01G__Rooms.xlsx   into the database as a new table named Rooms. Designate the first row as column headings and   the Room ID field as the primary key.

Open the Navigation Pane, open   the Rooms table in Datasheet view  (the table has 10 records). Apply Best Fit   to all of the fields in the  table, save the table, and then close the table.

Based on your Departments table,   use the Query Wizard to create a  simple query. Add the Department Name,   Department Email, Phone,  Contact Last Name, and Contact First Name fields (in   that order). Keep  the default name of Departments   Query, click Finish to display the query results, and then close the   query.

Based on your Rooms table, use   the Form tool to create a form for the table. Save the form as Room Form, display the form in Form view,   and then close the form.

Based on your Departments table,   use the Report tool to create a  report. Delete the Contact Last Name, Contact   First Name, and Special  Pay fields from the report. Save the report as Departments   Report.

Sort the Department Name field   in ascending order. Set the width of the Phone and Department Email fields to   1.75 inches. Delete the page number   from the report, save the report, and then close the report.

Open the Event List form, and   then close the Navigation Pane. In  the Event List multiple-items form, enter   the following record (the  Start Time   and End Time data will reformat automatically):
 

  Title: LPN   Open House   Start Time: 1/16/22 11a End Time: 1/16/22 12p Description: Program   Overview   Location: MW112

In the Event List form, click   New Event, and in the Event Details  single-record form, enter the following   record (the Start Time and End  Time data will reformat automatically):
 

  Title:  HIT Open House Start Time: 1/16/22 2p
   End Time: 1/16/22 3p Description: Scholarship Applications Location: MN110

Close the Event Details   single-record form. Close all database  objects, open the Navigation Pane, and   then exit Access. Submit the  database as directed.

1. What are the colors of mold when water gets into a mobile device, and what do the colors signify. 
2. What is the primary efficacy of ultrasonic cleaning?
3. Discuss the best ways to use drying boards
4. In retrieving evidence, discuss how you would handle a device that was exposed to saltwater for weeks, and why? 
5. What is JTAG as it relates to mobile forensics?

i need help for this error show me in andriod studio java Use JsonReader.setLenient(true) to accept malformed JSON at line 1 column 11 path $  

what problem and how solve that