Question

Hello, I am using Microsoft 365 Excel to formulate a Gantt Chart. I was doing OK until I needed to insert the "Duration" data into the chart. I have viewed numerous Youtube videos and it appea...

Hello, I am using Microsoft 365 Excel to formulate a Gantt Chart. I was doing OK until I needed to insert the "Duration"

data into the chart. I have viewed numerous Youtube videos and it appears those are older versions of Excel. Can you

help? Unfortunately, your service does not allow me to send all my data at once. So, I will attempt to send it piecemeal.

Thanks,

Dianne Morefield

Shoreline Stadium Case
START DATE END DATE DESCRIPTION DURATION (days)
7/3/2017 10/10/2017 Clear Stadium Site 70
10/11/2017 11/21/2017 Demolish Building 30
11/22/2017 4/3/2001 Set Up Construction Site 70
4/4/2018 9/28/2018 Drive Support Piling 120
10/1/2018 3/25/2019 Pour Lower Concrete Bowl 120
4/1/2019 9/18/2009 Pour Main Concourse 120
4/1/2019 8/6/2019 Install Playing Field 90
3/28/2020 9/17/2020 Construct Upper Steel Bowl 120
9/18/2020 4/8/2021 Install Seats 140
9/18/2020 1/29/2021 Build Luxury Boxes 90
9/18/2020 10/30/2020 Install Jumbotron 30
9/18/2020 3/11/2021 Stadium Infrastructure 120
4/9/2021 7/28/2021 Construct Steel Canopy 75
4/9/2021 5/21/2021 Light Installation 30
4/4/2018 8/13/2018 Build Roof Supports 90
8/14/2018 5/2/2019 Construct Roof 180
7/29/2021 12/6/2021 Install Roof Tracks 90
12/7/2021 4/10/2022 Install Roof Tracks 90
4/25/2022 5/23/2022 Inspection 20
0 0
Add a comment Improve this question Transcribed image text
Answer #1

I have applied the formula and calculated the duration for you

Book1 Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in Cut Copy Σ AutoSum . A Gerneral B 1 u, 1. 2. CondiBook1 Excel 2 HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 7 Sign 2 AutoSum A Fill Arial Gerneral Copy в 1 u, 1. 2. Cond

Please comment if any doubt

Rate me

Thanks

Add a comment
Know the answer?
Add Answer to:
Hello, I am using Microsoft 365 Excel to formulate a Gantt Chart. I was doing OK until I needed to insert the "Duration" data into the chart. I have viewed numerous Youtube videos and it appea...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Hello, I am doing a WACC project of Apple, Inc and trying to follow the instruction...

    Hello, I am doing a WACC project of Apple, Inc and trying to follow the instruction below, but I do not think it is clear enough for me to follow. Calculating the Weighted Average Cost of Debt Find the market value of each bond issue. To do this find the number of bonds and then multiply by the price of the bond (remember that bond prices are quoted in 100s, but are really 1000s). If there is no bond price,...

  • This is all of the information I have for this problem. The Depr, and Acc Depr...

    This is all of the information I have for this problem. The Depr, and Acc Depr are a guess for the first one 3 Existential Products started business in July 1, 2012 with the following purchases: Residual value Depr. Method 6 Land 7 Building 8 Parking Lot, Lighting & Fencing 9 Processing Equipment 10 Office Equipment Useful life $225,000 Indefinite $1,155,000 40 years $56,800 15 years $198,000 10 years $56,000 5 years $175,000 Straight Line $6,580 Double Declining Balance $19,800...

  • i think it's ok. i needed to understand which i did. thank you anyway. P9-3A Mazlin...

    i think it's ok. i needed to understand which i did. thank you anyway. P9-3A Mazlin Limited purchased a machine on account on April 2, 2018, at an invoice price of $360,000. On April 4, it paid $2,000 for delivery of the machine. A one-year, $4,000 insurance policy on the machine was purchased on April 5. On April 18, Mazlin paid $8,000 for installation and testing of the machine. The machine was ready for use on April 30. Mazlin estimates...

  • I just need the excel formula of C27 to C66 Question 1 (40 marks) Refer to...

    I just need the excel formula of C27 to C66 Question 1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with “?” in column C such that formula could be copied and pasted into columns D, and E using Microsoft Excel without further editing. There is no need to explicitly write the Excel formula for cells marked with “Copy & paste”. Label each formula clearly with cell reference position. In many country towns of...

  • I need Help with section three and for section 1 and 2 to be looked over. I think I have the write answers just needing...

    I need Help with section three and for section 1 and 2 to be looked over. I think I have the write answers just needing help. Capital Budgeting Assignment – Part 1 CAPITAL BUDGETING CASE STUDY ANALYSIS ACME Inc. is a multinational conglomerate corporation providing a wide range of goods and services to its customers. As part of its budgeting process for the next year, it has several projects under consideration so it must decide which projects should receive capital...

  • i need help with number 4, preparing the income statement, retained earnings statement, and the balance...

    i need help with number 4, preparing the income statement, retained earnings statement, and the balance sheet. this is the information that i have. Accounting Cycle Project (Group) ACCT3303 Spring 2020 Assignments Required: 1) Making journal entries for each transaction in chronological order. 2) Posting to the general ledger and prepare trial balance before adjustment. 3) Making adjusting entries and prepare adjusted trial balance. 4) Prepare Income Statement, Retained Earnings Statement, and Balance Sheet 5) Making closing entries. 6) Put...

  • I just completed the Journal Entries and according to the comment the next step is the...

    I just completed the Journal Entries and according to the comment the next step is the trial balance. Can you please help me with this. journal Entries are attached. If there are any mistakes in the General Journal please let me know. Victoria Co. Balance Sheet As of December 31, 2019 Cash Notes Receivable Accounts Receivable Less: Allowance for Doubtful A/Cs Inventories Office Supplies Prepaid Insurance Prepaid Rent Total Current Assets Long-term Investments Investments in securities Land for future development...

  • program an 8-to-1 multiplexor using verilog output of time table from 1 - 2047 For example...

    program an 8-to-1 multiplexor using verilog output of time table from 1 - 2047 For example output should look like.... --------- [Start of table] ---------------------------- [End of table] ---------- Here is example of 4x1 Multiplexor ... Just need code for 8x1 Multiplexor module DecoderMod(s, o); input [1:0] s; output [0:3] o; wire [1:0] inv_s; not(inv_s[1], s[1]); not(inv_s[0], s[0]); and(o[0], inv_s[1], inv_s[0]); and(o[1], inv_s[1], s[0]); and(o[2], s[1], inv_s[0]); and(o[3], s[1], s[0]); endmodule module MuxMod(s, d, o); input [1:0] s; input [0:3]...

  • JOHNSON & JOHNSON AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF EARNINGS (Dollars and Shares in Millions Except Per...

    JOHNSON & JOHNSON AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF EARNINGS (Dollars and Shares in Millions Except Per Share Amounts) (Note 1)* 2016 71,890 21,789 50.101 20,067 9.143 29 Sales to customers Cost of products sold Gross profit Selling, marketing and administrative expenses Research and development expense In-process research and development Interest income Interest expense, net of portion capitalized (Note 4) Other (income) expense, net Restructuring (Note 22) Eamings before provision for taxes on income Provision for taxes on income (Note 8)...

  • JOHNSON & JOHNSON AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF EARNINGS (Dollars and Shares in Millions Except Per...

    JOHNSON & JOHNSON AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF EARNINGS (Dollars and Shares in Millions Except Per Share Amounts) (Note 1)* 2016 71,890 21,789 50.101 20,067 9.143 29 Sales to customers Cost of products sold Gross profit Selling, marketing and administrative expenses Research and development expense In-process research and development Interest income Interest expense, net of portion capitalized (Note 4) Other (income) expense, net Restructuring (Note 22) Eamings before provision for taxes on income Provision for taxes on income (Note 8)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT