Results 1 to 9 of 9

Sample Data missing also

This is a discussion on Sample Data missing also within the MrExcel's Products: Books, CDs, Podcasts forums, part of the MrExcel Products category; I bought your book "Power Pivot Data Crunching (2007)". The sample data in the downloads for chapter 3 do not ...

  1. #1
    New Member
    Join Date
    Oct 2012
    Posts
    3

    Default Sample Data missing also

    I bought your book "Power Pivot Data Crunching (2007)". The sample data in the downloads for chapter 3 do not match up with the examples in the book. I was able to follow the beginning exercises in chapter 2 using the demo.txt file. It seems like the downloadable file is the end result of a completed chapter. Is there an area to find the sample data for the beginning of the chapter, so I can work along with the book?

    Please advise.

  2. #2
    New Member
    Join Date
    Oct 2012
    Posts
    3

    Default Re: Sample Data missing also

    This is actually a followup to my first post. Forgive me if this is not the proper procedure.

    Chapters 3-4-5-7-8 all have sample files that do not match the examples in the book. chapter 6 is missing. All the files do look like an end result of the chapter. If the starting file is supposed to be created by the user, that is not stated, and clarity is missing as to what fields should be used to create the start file. These are, as noted in the book, large files. The direction given, for a teaching book, is glaringly missing.

    Is there another link where the beginning files can be found?

    Please advise.

    Thx.

  3. #3
    New Member
    Join Date
    Oct 2012
    Posts
    3

    Default Re: Sample Data missing also

    Is this board monitored? My request is from 10-15, with no response.

  4. #4
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    24,743

    Default Re: Sample Data missing also

    I'm just a volunteer on the forum and don't have anything to do with MrExcel shop/products as such.
    However, I have checked and the 'powers that be' are aware of your problem.
    Hope this helps, good luck.
    Peter

    - Read: Posting Guidelines, Forum Rules & FAQs
    - Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste (To test: Test Here)
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker

  5. #5
    Board Regular
    Join Date
    Dec 2005
    Location
    Basingstoke (UK)
    Posts
    1,999

    Default Re: Sample Data missing also

    For the benefit of others, the book title is "Pivot Table Data Crunching for Microsoft Office Excel 2007".

    Register the book and you may be able to download the files from the Publisher's web site.

    I think that the data is (almost all) there in the files but may not be exactly as used in the (final) print version.

    I was able to create Figure 3.1 using data in worksheet "Sample Dataset" in PT2007Chap3.xlsx - the workbook already contains the 'pivot cache' from which the pivot table on worksheet "Sheet4" was created.

    Figure 6.1 can be created using the "Sample Dataset" in PT2007Chap4.xlsx by ignoring "Business_Segment" and using "Revenue" instead of "Sales_Amount". In this case "Business_Segment", and perhaps "Sales Amount", will be found in the dataset in other workbooks but you may find that the values are different.
    Never give way to anger - otherwise in one day you could burn up the wood that you collected in many bitter weeks.

  6. #6
    Board Regular
    Join Date
    Dec 2005
    Location
    Basingstoke (UK)
    Posts
    1,999

    Default Re: Sample Data missing also

    Looking further, I believe that the dataset in the "Sample File" at the top of the file list ("Click here to download the sample file used in most chapters. This should be the dataset used in Chapters 1, 2") will give you what you need to exactly create Figure 6.1
    Never give way to anger - otherwise in one day you could burn up the wood that you collected in many bitter weeks.

  7. #7
    New Member
    Join Date
    Nov 2012
    Posts
    2

    Default Re: Sample Data missing also

    I'm having a similar situation where the sample code files don't match perse to the book. Which is not the end of the world, the page numbers in the sample code files are only off by a few pages, but it's a little annoying. I was wondering if there is an updated set of files somewhere that I could download. Other than that I'm quite grateful for these files. Thanks peeps!

  8. #8
    Board Regular
    Join Date
    Dec 2005
    Location
    Basingstoke (UK)
    Posts
    1,999

    Default Re: Sample Data missing also

    Hello and welcome to the Board.
    The latest files should always be available from the Publisher's web site.
    You will find several (currently 20) reviews there so you may find help there.
    Not sure what the problem is with page numbers unless you are using a PDF/Kindle version - I have seen that some people have problems with them, particular where the font/page size on the Kindle has been changed.
    Never give way to anger - otherwise in one day you could burn up the wood that you collected in many bitter weeks.

  9. #9
    New Member
    Join Date
    Nov 2012
    Posts
    2

    Default Re: Sample Data missing also

    Derek,
    Thank you for your quick answer. I must confess that I went on to the publishers website and I couldn't find a link to download the help files, only places to buy the book...but I already have the book (the paper copy not e-book). I would imagine that they wouldn't make them freely available on the site, perhaps it's a hidden page and I have to have a specific link?

    Any direction/help is greatly appreciated.

    Thanks!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com