excel automation off worksheets

1. I need help I have 2 excel worksheets macro enabled worksheet.xlsm and a excel binary worksheet.xlbs. I need to connect them. The form should take the information from it and transfer to the tracking sheet first tab.

 

2 When the form is filled out and sumbitted I need it to transfer the (raw data) to the tracking sheet and summarize all the data as the tracking sheet has. Once the sheet is submitted it will automatically clear the data entered and be ready to enter another audit.

 

3. I need a how to guide (a step by step guide) on how to connect to worksheet and have it automatically transfer the data from the audit sheet to the tracking sheet. How to automate excel sheets to one another with the click of the submit button and it clears on its own and ready for the next audit.

 

 

I have the macro codes on the audit form but there is something I am missing, its not connecting to the tracking sheet.

GEN 499 FINAL PAPER

 

Prepare: The topic of your essay needs to be a global societal problem from the following list: adult illiteracy, funding for General Education vs STEM in primary and secondary schools, minimum wage, oceans desertification, overcoming the digital divide, refugee (escaping persecution, war, or death) crises, species extinctions (modern), tax havens, Transatlantic Trade and Investment Partnership (TTIP), universal statement of human rights (pick one), airport security, or wealth disparity. Review this GEN499 Sample Final Paper Guide for additional guidance on the expectations of this assignment.

Reflect: Based on the topic that you have chosen, you will need to use critical thinking skills to thoroughly understand how this topic can be a global societal problem and determine some logical solution(s) to the problem.

Write: This Final Argumentative Essay will present research relating the critical thinker to the modern, globalized world. In this assignment, you need to address the following items in separate sections with new headings for each:

  • Identify the global societal problem within the introductory paragraph and conclude with a thesis statement that states your proposed solution(s) to the problem. For guidance on how to construct a good introduction paragraph, please review the Introduction Paragraph Guideline from the Ashford Writing Center.
  • Describe background information on how that problem developed or came into existence. Show why this is a societal problem, and provide perspectives from multiple disciplines or populations so that you fully represent what different parts of society have to say about this issue.
  • Construct an argument supporting your proposed solution(s). Be sure to consider multiple disciplines or populations so that your solution shows that multiple parts of society will benefit from this solution. Provide evidence from multiple scholarly sources as evidence that your proposed solution is viable.
  • Interpret statistical data from at least three, peer-reviewed scholarly sources. Do this by discussing the validity, reliability, and any biases; identifying the strengths and weaknesses of these sources; and pointing out limitations of current research and attempting to indicate areas for future research. You may even use visual representations such as graphs or charts to explain statistics from sources. Evaluate the ethical outcomes that result from your solution. Be sure to provide at least one positive ethical outcome as well as at least one negative ethical outcome that could result from your solution, and explain at least two ethical issues related to each of those outcomes. It’s important to consider all of society.
  • Develop a conclusion as the last paragraph(s) of the essay, starting with rephrasing your thesis statement and then presenting the major points of the topic and how they support your argument. For guidance on how to write a good conclusion paragraph, please review the Conclusion Paragraph Guideline from the Ashford Writing Center.

The Final Argumentative Essay

  • Must be 3,300 – 3,900 words in length (approximately between 10 – 12 pages; excluding title and reference pages) and formatted according to APA style as outlined in the Ashford Writing Center.
  • Must include a separate title page with the following:
    • Title of paper
    • Student’s name
    • Course name and number
    • Instructor’s name
    • Date submitted
    • Running header with page numbers
  • Must include in-text citations from at least 10 scholarly sources. Be sure to integrate your research rather than simply inserting it.
  • Must document all sources in APA style as outlined here and here.
  • Must have no more than 15% quoted material in the body of your essay based on the Turnitin report. Reference list will be excluded from the Turnitin originality score.
  • Must include a separate reference page that is formatted according to APA style as outlined in the Ashford Writing Center.
  • Source Document Requirements:
    • Multimedia sources (such as videos) may be used, but no more than two such sources may be used. If multimedia sources are used, they must be authored and distributed by credible sources, such as universities, law schools, medical schools, or professors, or found in the Ashford University Library.
    • Government sources may be used, but no more than two such sources may be used. Examples include whitehouse.gov, state.gov, usa.gov, cdc.gov, etc. These websites can be used to make a stronger point about your proposed soluation within the argument.
    • Where print documents are used for source materials, those must be peer-reviewed, scholarly journal articles, and academically published books. Popular media sources (e.g., newspapers, magazines, television and radio shows, etc.) must not be used. Materials from advocacy groups (e.g., Greenpeace, Human Rights Campaign, National Organization for Women, etc.) must not be used.
    • Sites such as ProCon.org and Wikipedia must not be used.
    • Religious texts must not be used.

Good Critical Thinking Tips:

  • Your paper should include academic sources that explain multiple sides of the issue.
  • Your interpretations of the evidence should be objective and state the conclusions and theses presented in the evidence clearly and fairly.
  • Your paper should place the various forms of evidence in relation to one another and demonstrate why one form or perspective is stronger than the other positions that one could take on the issue.
  • Your paper should point out the limitations of current evidence and attempt to indicate areas for future research.
  • Writing Tools:
    • Before you submit your written assignment, you are encouraged to review the The Grammarly Guide: How to Set Up & Use Grammarlytutorial, set up a Grammarly account (if you have not already done so), and use Grammarly to review a rough draft of your assignment. Then carefully review all issues identified by Grammarly and revise your work as needed.

Case Study

Read the Waste Management Case Study.
After reviewing the case and studying Chapter 3, respond to the following four questions in an essay (introduction, body, and conclusion) format. Grading will be based on your ability to incorporate core ideas from the textbook and your ability to respond to each question in a detailed and structured manner.

Case Study Questions

Note: Minimum word count for each question is 350 to 400 words.

1. List and explain three key lessons you have learned based on the review of the Waste Management Case Study and 
Chapter 3 of the textbook.
2. Conduct an external environmental analysis of this case. List and explain the general and specific factors found in the 
case, and provide an example for each type.
3. An increasing interest in recycling on behalf of consumers and companies is an example of changing sociocultural and 
political and legal views in relation to the general environment. Based on the details of the case, the high cost of 
collecting and sorting recyclable materials means that Waste Management loses money when it recycles the items. What 
can the company do to meet increased customer expectations on one hand, while still earning a profit on high cost 
recycled materials?
4. To improve its public image, how should Waste Management deal with advocacy groups? If you were given the 
opportunity, what two recommendations would you make to Waste Management’s management on this topic?

 

Waste Management

Introduction to the Case

Americans generate a quarter billion tons of trash a year, or 4.5 lb. of trash per person per day.

Thanks to nearly 9,000 curbside recycling programs, one third of that is recycled. However, that

still leaves 3 lb of trash per person, per day to be disposed. In the past, trash was incinerated,

often in local neighborhoods.  

Waste Management, Inc., is the largest waste‐handling company in the world.  It has 20 million

customers, 273 municipal landfills, 91 recycling facilities, and 17 waste‐to‐energy facilities.  

Waste Management  generates 75%of its profits from 273 landfills, which can hold 4.8 billion

tons of trash. But even as it dominates its industry, Waste Management faces serious changes in

its environment. Both corporations and consumers are reducing the amount of waste they

generate and increasing the amount of goods they recycle. Over the past few years, has been an

overall gradual change in the sociocultural, political, and legal thinking of society has occurred in

reference to waste management. These trends challenge Waste Management because the high

cost of collecting and sorting recyclable materials means that Waste Management loses money

when it recycles them. Discussed below are some of the key challenges faced by Waste

Management, Inc.

Changing External Environment

External environments are the forces and events outside a company that have the potential to

influence or affect its stability. As discussed in the textbook, organizations are influenced by two

kinds of external environments: the general environment, which consists of economic,

technological, sociocultural, political, and legal events and trends, and the specific environment,

which consists of customers, competitors, suppliers, industry regulators, and advocacy groups.

The sociocultural component of the general environment refers to the demographic

characteristics, general behavior, attitudes, and beliefs of people in a particular society.

Sociocultural changes and trends influence organizations in two important ways.  First, changes

in demographic characteristics, such as the number of people with particular skills or the growth

or decline in particular population segments (marital status, age, gender, or ethnicity), affect

how companies staff their businesses.  Second, sociocultural changes in behavior, attitudes, and

beliefs also affect the demand for a business’ products and services.

Subaru of America, for instance, has a zero‐landfill plant in West Lafayette, Indiana, that hasn’t

sent any waste to a landfill since 2004. None! Subaru isn’t in the only company to seek to be a

zero‐landfill company. Walmart, the largest retailer in the world, has also embraced this goal,stating, “Our vision is to reach a day where there are no dumpsters behind our stores and clubs,

and no landfills containing our throwaways.” Like leaders at Subaru and Walmart, corporate

leaders worldwide are committed to reducing the waste produced by their companies.  

Recycling

Another significant change for Waste Management is that not only are  customers reducing the

waste they send to its landfills, they’re also wanting what is sent to landfills to be sorted for

recycling and reuse. For instance, food waste, yard clippings, and wood—all organic materials—

account for roughly one‐third of the material sent to landfills. Likewise, demand is growing  for

waste companies to manage and recycle discarded TVs, computer monitors, and other

electronic waste that leaks lead, mercury, and hazardous materials when improperly disposed

of. However, the high cost of collecting and sorting recyclable materials means that Waste

Management loses money when it recycles them.  

Traditionally, recycling has been a breakeven or low profit business.  The challenge for Waste

Management and CEO David Steiner is to focus on sustainability services and be highly

profitable.  The question, of course, is how.  The answer, he believes, is technology.  Says

Steiner, “We don’t want to play just in the picking up and delivering.  We want to own

conversion, too.  We want to own the technology.”  Consequently, Waste Management has

gone on an acquisition spree, purchasing companies with the technologies it believes can make

it highly profitable in recycling.    

For instance, Waste Management purchased Garick, a Texas‐based company that can turn a ton

of food waste, which traditionally had no value, into $40 or $50 of compost and mulch.  It also

invested in Harvest Power, a Massachusetts‐based firm that turns waste into high‐quality

compost which can then be burned to generate electricity at a payoff of $60 to $80 per ton.  

Waste Management also bought Glacier Recycle, based in the state of Washington, which

recycles construction materials into recycled wood products and biomass fuel.  Finally, Waste

Management has invested in Terrabon, another Texas‐based firm that makes so‐called “green

gasoline” from waste paper and chicken manure.   

Perception, Image Issues, and Advocacy Groups  

Advocacy groups are an example of a specific environment as discussed above. Advocacy groups

are groups of concerned citizens who band together to try to influence the business practices of

specific industries, businesses, and professions. For example, groups such as the Sierra Club

have been critical of Waste Management’s landfill practices.

The members of these groups generally share the same point of view on particular issues. For

example, environmental advocacy groups might try to get manufacturers to reduce smokestack

pollution emissions. Unlike the industry regulation component of the specific environment,

advocacy groups cannot force organizations to change their practices. Nevertheless, they canuse a number of techniques to try to influence companies, including public communications,

media advocacy, Web pages, blogs, and product boycotts.

For Waste Management as a company, the most common technique for responding to the

criticisms of advocacy groups is to assertively and quickly counter their claims with factual

evidence that demonstrates that the company is not acting unethically, as claimed by the

advocacy groups.  Often, that just leads to more intense accusations.  Waste Management,

however, has taken the unique strategy of working directly with advocacy groups to address

criticisms of how it does business.  One of the largest criticisms of Waste Management is that its

273 landfills represent tens of thousands of acres of contaminated waste land.   

To address that criticism, it began working with the Wildlife Habitat Council (WHC), a nonprofit

organization, which works with “with corporations and other landowners to create tailored

voluntary wildlife habitat enhancement and conservation education programs on corporate

facilities and in the communities where they operate.”  The WHC works with corporations to

independently certify that their recovered lands are now suitable and sustainable for wildlife.  

To achieve the WHC’s certification with waste‐filled landfills is no small task.  But, in 2007, CEO

Steiner announced that Waste Management’s goal was to achieve the WHC’s certification at

100 sites amounting to over 25,000 acres by 2020.  Debbie Figueras‐Cano, who runs the Wildlife

Habitat Council program at Waste Management, said, “I honestly thought at that point in time

that getting to 100 of them would be a challenge, just because it’s not a simple thing to do to

get WHC certified.  There’s a lot of work that goes into getting these certifications.”  The WHC

had only certified 19 sites in the previous 7 years.   Furthermore, said Scott Kilkenny, chairman

of the WHC, “No single company has ever received 30 certifications in one year, and no other

company has more than 100 certified programs.”   

Nonetheless, today, just 3 years after setting its goal, Waste Management has 100 WHC sites

protecting more than 25,000 acres.  Of the 100 sites, 97 are former landfills.  Waste

Management’s Kirby Canyon site, for example, has 600 acres for wildlife use that includes

grasslands where two threatened species, the bay checkerspot butterfly and the California red‐

 

legged frog, are now thriving. 

GEN499 Week 2 Discussion 2

Ashford 3: – Week 2 – Discussion 2

Your initial discussion thread is due on Day 3 (Thursday) and you have until Day 7 (Monday) to respond to your classmates. Your grade will reflect both the quality of your initial post and the depth of your responses.

 
Ethics and Moral Development
  Prepare: In preparing for this discussion, you should first review the Week Two required resources that focus on ethics and morals. This will help assist you in examining your own development of ethical and moral responsibilities.  
  Reflect: Take a deeper look at your own life and determine which experiences have inspired ethical and moral reasoning. Were there any huge influences in this process?  
  Write: For this discussion you will address the following prompts:

  • Explain what it means to be ethical as it relates to personal, academic, and professional growth.
  • Provide at least one ethical dilemma you have encountered and describe how the issue was resolved.
  • Describe how your general education courses have influenced your ethical values.
  • Explain why a college-educated person might have different duties to society than someone not as educated.

Your initial post should be at least 250 words in length, which should include a thorough response to each prompt. You are required to provide in-text citations of applicable required reading materials and/or any other outside sources you use to support your claims. Provide full reference information of all sources cited at the end of your response. Please use correct APA format when writing in-text citations  and references

 
  Respond to Peers: Review your classmates’ posts, and respond to at least two of your peers by Day 7. In each response, provide comments that prompt further critical thinking and insight on your classmate’s perspective on ethical values as they relate to their personal, academic, and professional lives. Each participation post should be a minimum of 75 words.  
 

Carefully review the Discussion Forum Grading Rubric for the criteria that will be used to evaluate this Discussion Thread.

 

HIS104 Assignment

Assignment 2.1: Liberty Challenged in Nineteenth Century America Thesis and Outline
Due Week 7 and worth 50 points

America became a free independent nation. With the signing of the Treaty of Paris in 1783, the former mother country, England, recognized that its children, the colonies, were now on their own. A constitutional republic was birthed, thus the challenges began. Slavery, the “Peculiar Institution,” was a monumental issue facing the country. Would it die or would it survive and possibly take a nation divided with it? This sectionalism followed Americans up into the Civil War. Dissect this crisis by addressing parts I and II below.

For the next part of this assignment you will create an outline of the main points you want to address in this paper. This will serve as the basis for your Assignment 2.2 Final Draft. (Note: Please use the Purdue Owl Website to assist you with this assignment; this website can be accessed at: https://owl.english.purdue.edu/engagement/2/2/55/

Part 1:

1.     Write a thesis statement that is one to two (1-2) sentences long in which you:

a.      State your thesis on the significance of this slavery issue, as exemplified in your research. Justify your response.

For the first part of this assignment you will create a thesis statement. A thesis statement is usually a single sentence somewhere in your first paragraph that presents your main idea to the reader. The body of the essay organizes the material you gather and present in support of your main idea. Keep in mind that a thesis is an interpretation of a question or subject, not the subject itself. (Note: Please consult the Purdue OWL Website with tips on how to construct a proper thesis; the website can be found at: https://owl.english.purdue.edu/owl/resource/545/01/

Part 2: 
For the next part of this assignment you will create an outline of the main points you want to address in this paper. This will serve as the basis for your Assignment 2.2 Final Draft. (Note: Please use the Purdue Owl Website to assist you with this assignment; this website can be accessed at: https://owl.english.purdue.edu/engagement/2/2/55/

2. Write a one to two (1-2) page outline in which you:

a.      Describe two (2) outcomes of the 3/5ths Compromise, Missouri Compromise of 1820, Compromise of 1850, Kansas-Nebraska Act, and the Dred Scott Decision. Note: Be sure to provide two (2) outcomes for each legislation.

b.     Suggest three (3) reasons why slavery was and is incompatible with our political and economic system.

c.      List three to five (3-5) driving forces that led to the Civil War.

d.     Use at least three (3) academic references besides or in addition to the textbook. Note: Wikipedia and other Websites do not qualify as academic resources.

 Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

 

  • Recognize the main factors that led to America’s early development.
  • Identify and discuss the different ways that the heritages of slavery, the Civil War, and Reconstruction have shaped America’s history.
  • Summarize and discuss the ways that formal policies of government have influenced the direction of historical and social development in the United States.
  • Examine how changes in social and economic conditions and technology can cause corresponding changes in the attitudes of the people and policies of the government.
  • Specify ways that women and minorities have responded to challenges and made contributions to American culture.
  • Use technology and information resources to research issues in American History to 1865.
  • Write clearly and concisely about American History to 1865 using proper writing mechanics.

HIS104 Discussion

  • Go to Section 3 of this week’s reading titled, “Lives of Slaves” and review the videos shown in the section. https://www.youtube.com/watch?v=Ajn9g5Gsv98
  • Briefly summarize the day-to-day activities of a typical slave’s daily life. Using resources from this section and House of Bondage: Realities of Slavery found at http://docsouth.unc.edu/neh/albert/albert.html
  • Determine three (3) differences in experiences between slaves then suggest two (2) reasons why the experiences may have differed.