Spreadsheet: 220560d1363193845-trying-to-retrieve-information-from-worksheet-to-a-form-workbook2-jacc
Sheet: WIP

 | List of projects currently handled as of 30th Oct 2012:revised Feb 13 2013 |  |  |  |  | Work in Progress Statement
 | Sl # | Customer | Customer Division | Job Code | ISBN | Customer Contact | Project Name | Date of Receipt | In-house / Freelance | [NAME] | Date of Outsourcing | Expected date of completion | Cengage Estimated Value | Estimated Value | Outsourcing Contract Value | Outsourcing Cost % | % of Work Completion | Type of Design Service | Partial Billing | Date | Partial Billing | Date | [NAME] | Date | NOTES
19 |  | Pearson | BC | 85 | 9780312814265 | [NAME] | Sarikas, Visual Anatomy & Physiology | 2011-09-20 00:00:00 | In-house | NA | NA | 2012-08-01 00:00:00 | 6250 |  |  |  | 0.8 | interior |  |  |  |  |  |  | will inquire into design status
 |  | CUP | India |  |  | [NAME] | ENGLISH Cover | 2012-05-15 00:00:00 | Freelance + In-house | [NAME] | 2012-05-23 00:00:00 | 2012-08-30 00:00:00 |  | 800 |  |  | 0.75 | cover |  |  |  |  |  |  | NEW PROJECT: OAK to bill PDY
1 |  | Pearson | BC | 146 | 9780321838995 | [NAME] | Morgan&Carter, Investigating Biology Lab Manual | 2012-07-23 00:00:00 | In-house | N/A | NA | 2012-12-01 00:00:00 |  | 7250 |  |  | 0.75 | interior | 1650.00. | Nov 2012 | 1825 + 1850. | Mar 2013 |  |  | IE has a separate ISBN--bill when project is complete / Stages 1, 2 & 4 complete. Stage 3 to come later. $925 + $1000.00 yet to bill.
2 |  | Pearson | PHNJ | 651 | 9780132162302 | [NAME] | Gordon/Intermediate Accounting, 1e | 2012-09-21 00:00:00 | In-house | N/A | na | 2013-03-01 00:00:00 |  | 4480 | 0 | na | 0.75 |  | 1650 | Nov 2012 | 1825 | Feb 2013 |  |  | $925. 00 yet to bill.
3 |  | Pearson | PHNJ | 649 | 9780133251036 | [NAME] | Horngren/Introduction to Financial Accounting, 11e | 2012-08-21 00:00:00 |  | N/A | na | 2013-03-01 00:00:00 |  | 1200 | 0 | 0 | 1 | interior | 950 | Sept 2012 |  |  | Billing is complete. FBS = $950.00. | Mar 2013 | FMRM was designed by composer. Job is complete.
 |  | CUP | India |  | 9781107028647 | [NAME] | LCPD Cover | 2012-09-05 00:00:00 | Freelance + In-house | TBD |  | 2013-03-01 00:00:00 |  | 800 | 0 |  | 0.5 | cover
4 |  | Pearson |  |  | tbd |  | CJ Series Design |  | inhouse | [NAME] | na | 2013-06-01 00:00:00 |  | 12500 |  | na | 0.25 | interior |  |  |  |  |  |  | freelance cost not determined yet.
5 |  | BSM |  |  | 9780312631352 | [NAME] | [NAME] |  | Freelance | [NAME] |  | 2013-06-01 00:00:00 |  |  |  |  | 0.1 |  |  |  |  |  |  |  | [NAME] when designer's work is complete, or half complete.
6 |  |  |  |  | tbd |  | NatGeo ELT Paging |  | Freelance | [NAME] |  | 2013-06-01 00:00:00 |  |  |  |  | 0.1
7 |  | Cengage | cenmas |  | 9781285187624 | [NAME] | Boone&Kurtz, CM16e UPDATE | 2012-11-01 00:00:00 | inhouse | N/A | na | 2013-12-02 00:00:00 |  |  |  | na | 0.5
8 |  | Cengage | CENMAS | 671 | 9781285433370 | [NAME] | Kloppenborg | 2012-11-19 00:00:00 | freelance | [NAME] |  | 2013-12-02 00:00:00 | 900 |  |  |  | 0.5 | Interior Design, Adaptation PAL stylesheet (-)
 |  | Cengage | CENMAS | 671 | 9781285433370 | [NAME] | Kloppenborg | 2012-11-19 00:00:00 | inhouse | N/A | na | 2013-12-02 00:00:00 | 300 |  | 0 | na | 0.5 | 4. IDM Adaptation, PAL
 |  | Cengage | CENMAS | 671 | 9781285433370 | [NAME] | Kloppenborg | 2012-11-19 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 1500 |  |  |  | 0.5 | 16. CD Moderate - Core Book
 |  | Cengage | CENMAS | 671 | 9781285433370 | [NAME] | Kloppenborg | 2012-11-19 00:00:00 | inhouse | N/A | na | 2013-12-02 00:00:00 | 300 |  | 0 | na | 0.5 | 12. CM Adaptation, Moderate - Core Book
 |  | Cengage | CENMAS | 671 | 9781285433370 | [NAME] | Kloppenborg | 2012-11-19 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 200 |  |  |  | 0 | 20. Mechanical - Core Book |  |  |  |  |  |  | India will do
 |  | Cengage | CENMAS | 671 | not available yet | [NAME] | Kloppenborg ISE | 2012-11-19 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 100 |  |  |  | 0 | 17. CD AIsE/ISE or non-templated Ancillary
 |  | Cengage | CENMAS | 671 | not available yet | [NAME] | Kloppenborg ISE | 2012-11-19 00:00:00 | inhouse | N/A | na | 2013-12-02 00:00:00 | 120 |  | 0 | na | 0 | 10. CM Templated Series Pickup and Modify
 |  | Cengage | CENMAS | 671 | not available yet | [NAME] | Kloppenborg ISE | 2012-11-19 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 100 |  |  |  | 0 | 21. Mechanical (IE, ISE, AISE, ADV, Splits) |  |  |  |  |  |  | India will do
9 |  | Cengage | CENMAS |  | 9781285734293 | [NAME] | Carroll/Buchholtz | 12./18/12 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 1500 |  |  |  | 0.5 | Interior Design, Adaptation PAL stylesheet
 |  | Cengage | CENMAS |  | 9781285734293 | [NAME] | Carroll/Buchholtz | 12./18/12 | inhouse | na | na | 2013-12-02 00:00:00 | 300 |  | 0 | na | 0.5 | Interior Design Management Adaptation PAL
 |  | Cengage | CENMAS |  | 9781285734293 | [NAME] | Carroll/Buchholtz | 12./18/12 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 1500 |  |  |  | 0.5 | Cover Design Moderate
 |  | Cengage | CENMAS |  | 9781285734293 | [NAME] | Carroll/Buchholtz | 12./18/12 | inhouse | na | na | 2013-12-02 00:00:00 | 300 |  | 0 | na | 0.5 | Cover Design Management Moderate Core Book
 |  | Cengage | CENMAS |  | 9781285734293 | [NAME] | Carroll/Buchholtz | 12./18/12 |  | N/A |  | 2013-12-02 00:00:00 | 200 |  |  |  | 0 | 20. Mechanical - Core Book |  |  |  |  |  |  | india will do
 |  | Cengage | CENMAS |  | 9781285734323 | [NAME] | Carroll/Buchholtz ISE | 12./18/12 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 100 |  |  |  | 0 | Cover Design ISE
 |  | Cengage | CENMAS |  | 9781285734323 | [NAME] | Carroll/Buchholtz ISE | 12./18/12 | inhouse | na | na | 2013-12-02 00:00:00 | 120 |  | 0 | na | 0 | Cover Management-Templated Series ISE
 |  | Cengage | CENMAS |  | 9781285734323 | [NAME] | Carroll/Buchholtz ISE | 12./18/12 |  | N/A |  | 2013-12-02 00:00:00 | 100 |  |  |  | 0 | 21. Mechanical (IE, ISE, AISE, ADV, Splits) |  |  |  |  |  |  | India will do
10 |  | Cengage | CENMAS |  | 9781285429786 | [NAME] | [NAME] | 2013-12-31 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 500 |  |  |  | 0.25 | Cover Design Moderate |  |  |  |  |  |  | kill fee: project delayed one year
 |  | Cengage | CENMAS |  | 9781285429786 | [NAME] | [NAME] | 2013-12-31 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 100 |  | 0 | na | 0.25 | Cover Design Management Moderate Core Book |  |  |  |  |  |  | kill fee: project delayed one year
 |  | Cengage | CENMAS |  | 9781285429786 | [NAME] | [NAME] | 2013-12-31 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 0 |  | 0 |  | 0 | 20. Mechanical - Core Book |  |  |  |  |  |  | kill
 |  | Cengage | CENMAS |  | 9781285431543 | [NAME] | [NAME] ISE | 2013-12-31 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 0 |  |  |  | 0 | Cover Design ISE |  |  |  |  |  |  | kill
 |  | Cengage | CENMAS |  | 9781285431543 | [NAME] | [NAME] ISE | 2013-12-31 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 0 |  | 0 | na | 0 | Cover Management-Templated Series ISE |  |  |  |  |  |  | kill
 |  | Cengage | CENMAS |  | 9781285431543 | [NAME] | [NAME] ISE | 2013-12-31 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 0 |  | 0 |  | 0 | 21. Mechanical (IE, ISE, AISE, ADV, Splits) |  |  |  |  |  |  | kill
11 |  | Cengage | CENMAS |  | 9781285063003 | [NAME] | [NAME] | 2013-01-18 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 500 |  |  |  | 0 | 25. ID Adaptation, PAL Stylesheet
 |  | Cengage | CENMAS |  | 9781285063003 | [NAME] | [NAME] | 2013-01-18 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 300 |  | 0 | na | 0 | Interior Design Management Adaptation PAL
 |  | Cengage | CENMAS |  | 9781285063003 | [NAME] | [NAME] | 2013-01-18 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 1500 |  |  |  | 0 | Cover Design Moderate
 |  | Cengage | CENMAS |  | 9781285063003 | [NAME] | [NAME] | 2013-01-18 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 300 |  | 0 | na | 0 | Cover Design Management Moderate Core Book
 |  | Cengage | CENMAS |  | 9781285063003 | [NAME] | [NAME] | 2013-01-18 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 200 |  | 0 |  | 0 | 20. Mechanical - Core Book |  |  |  |  |  |  | India will do
 |  | Cengage | CENMAS |  | 9781285062945 | [NAME] | [NAME] ISE | 2013-01-18 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 100 |  |  |  | 0 | Cover Design ISE
 |  | Cengage | CENMAS |  | 9781285062945 | [NAME] | [NAME] ISE | 2013-01-18 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 120 |  | 0 | na | 0 | 10. CM Templated Series Pickup and Modify
 |  | Cengage | CENMAS |  | 9781285062945 | [NAME] | [NAME] ISE | 2012-11-19 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 100 |  | 0 |  | 0 | 21. Mechanical (IE, ISE, AISE, ADV, Splits) |  |  |  |  |  |  | India will do
12 |  | Cengage | CENMAS |  | 9781285427041 | [NAME] | Schaffer | 2012-12-19 00:00:00 | Freelance | Rae Grant |  | 2013-12-02 00:00:00 | 1250 |  |  |  | 0.25 | Cover Design Simple
 |  | Cengage |  |  | 9781285427041 | [NAME] | Schaffer | 2012-12-19 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 225 |  | 0 | na | 0.25 | Cover Design Management simple Core Book
13 |  | Cengage | CENNY |  | 9781285053127 | [NAME] | Daniels | 2013-01-22 00:00:00 | inhouse | NA | NA | 2013-12-02 00:00:00 | 1250 |  |  |  | 0.25 | Cover Design Simple |  |  |  |  |  |  | additional ISBN: [PHONE]
14 |  | Cengage | CENMAS |  | 9781285189741 | [NAME] | Moyer | 2013-01-24 00:00:00 | Freelance | [NAME] | 2013-02-26 00:00:00 | 2013-12-02 00:00:00 | 1500 |  | 810 |  | 0 | 25. ID Adaptation, PAL Stylesheet
 |  | Cengage | CENMAS |  | 9781285189741 | [NAME] | Moyer | 2013-01-24 00:00:00 | In-house | N/A |  | 2013-12-02 00:00:00 | 300 |  | 0 | na | 0 | 4. IDM Adaptation, PAL
 |  | Cengage | CENMAS |  | 9781285189741 | [NAME] | Moyer | 2013-01-24 00:00:00 | Freelance | [NAME] | 2013-02-26 00:00:00 | 2013-12-02 00:00:00 | 1250 |  |  |  | 0 | Cover Design Simple
 |  | Cengage | CENMAS |  | 9781285189741 | [NAME] | Moyer | 2013-01-24 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 225 |  | 0 | na | 0 | Cover Design Management Simple Core Book
 |  | Cengage | CENMAS |  | 9781285189741 | [NAME] | Moyer | 2012-11-19 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 200 |  | 0 |  | 0 | 20. Mechanical - Core Book |  |  |  |  |  |  | India will do
 |  | Cengage | CENMAS |  | 9781285198866 | [NAME] | Moyer ISE | 2013-01-24 00:00:00 | Freelance | [NAME] | 2013-02-26 00:00:00 | 2013-12-02 00:00:00 | 100 |  |  |  | 0 | Cover Design ISE
 |  | Cengage | CENMAS |  | 9781285198866 | [NAME] | Moyer ISE | 2013-01-24 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 120 |  | 0 | na | 0 | Cover Management-Templated Series ISE
 |  | Cengage | CENMAS |  | 9781285198866 | [NAME] | Moyer ISE | 2012-11-19 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 100 |  | 0 |  | 0 | 21. Mechanical (IE, ISE, AISE, ADV, Splits) |  |  |  |  |  |  | India will do
15 |  | Cengage | CENBEL |  | 9781285458397 | [NAME] | [NAME] | 2013-01-25 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 1500 |  |  |  | 0 | 2. IDM Adaptation, Moderate - Core Book |  |  |  |  |  |  | I have requested an increase
 |  | Cengage | CENBEL |  | 9781285458397 | [NAME] | [NAME] | 2013-01-25 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 750 |  | 0 | na | 0 | 2. IDM Adaptation, Moderate - Core Book
 |  | Cengage | CENBEL |  | 9781285458397 | [NAME] | [NAME] | 2013-01-25 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 1250 |  |  |  | 0 | 15. CD Simle - Core Book
 |  | Cengage | CENBEL |  | 9781285458397 | [NAME] | [NAME] | 2013-01-25 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 225 |  | 0 | na | 0 | 11. CM Adaptation, Simple - Core Book
 |  | Cengage | CENBEL |  | 9781285458397 | [NAME] | [NAME] | 2013-01-25 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 200 |  |  |  | 0 | 20. Mechanical - Core Book |  |  |  |  |  |  | India will do
 |  | Cengage | CENBEL |  | 9781285458717 | [NAME] | [NAME] | 2013-01-25 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 100 |  |  |  | 0 | 17. CD AISE/ISE or non-templated Ancillary
 |  | Cengage | CENBEL |  | 9781285458717 | [NAME] | [NAME] | 2013-01-25 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 120 |  | 0 | na | 0 | 10. CM Templated Series Pickup and Modify
 |  | Cengage | CENBEL |  | 9781285458717 | [NAME] | [NAME] | 2013-01-25 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 100 |  |  |  | 0 | 21. Mechanical (IE, ISE, AISE, ADV, Splits) |  |  |  |  |  |  | India will do
16 |  | Cengage | CENBEL |  | 9780495809135 | [NAME] | Belknap | 2013-01-15 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 1250 |  |  |  | 0 | 15. CD Simle - Core Book
 |  | Cengage | CENBEL |  | 9780495809135 | [NAME] | Belknap | 2013-01-15 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 225 |  | 0 | na | 0 | 11. CM Adaptation, Simple - Core Book
 |  | Cengage | CENBEL |  | 9780495809135 | [NAME] | Belknap | 2013-01-15 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 200 |  | 0 |  | 0 | 20. Mechanical - Core Book |  |  |  |  |  |  | India will do
 |  | Cengage | CENBEL |  | 9780495811619 | [NAME] | Belknap ISE | 2013-01-15 00:00:00 | Freelance | [NAME] |  | 2013-12-02 00:00:00 | 100 |  |  |  | 0 | 17. CD AIsE/ISE or non-templated Ancillary
 |  | Cengage | CENBEL |  | 9780495811619 | [NAME] | Belknap ISE | 2013-01-15 00:00:00 | inhouse | na | na | 2013-12-02 00:00:00 | 120 |  | 0 | na | 0 | 10. CM Templated Series Pickup and Modify
 |  | Cengage | CENBEL |  | 9780495811619 | [NAME] | Belknap ISE | 2013-01-15 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 100 |  | 0 |  | 0 | 21. CD Mechanical (IE, ISE, AISE, ADV, Splits) |  |  |  |  |  |  | India will do
17 |  | Cengage | CENMAS |  | 9781285423715 | [NAME] | Ferrell/Frederich/Ferrell | 2013-01-22 00:00:00 | Freelance | [NAME] | 2013-02-26 00:00:00 | 2013-12-02 00:00:00 | 1500 |  |  |  | 0 | 23. ID Adaptation, Simple Core Book
 |  | Cengage | CENMAS |  | 9781285423715 | [NAME] | Ferrell/Frederich/Ferrell | 2013-01-22 00:00:00 | In-house | N/A | na | 2013-12-02 00:00:00 | 325 |  | 0 | na | 0 | 1. IDM Adaptation, Simple - Core book |  |  |  |  |  |  | design launch meeting on 2/14 will determine costs
 |  | Cengage | CENMAS |  | 9781285423715 | [NAME] | Ferrell/Frederich/Ferrell | 2013-01-22 00:00:00 | Freelance | [NAME] | 2013-02-26 00:00:00 | 2013-12-02 00:00:00 | 1250 |  | 675 |  | 0 | 15. CD Simle - Core Book
 |  | Cengage | CENMAS |  | 9781285423715 | [NAME] | Ferrell/Frederich/Ferrell | 2013-01-22 00:00:00 | In-house | N/A | na | 2013-12-02 00:00:00 | 225 |  | 0 |  | 0 | 11. CM Adaptation, Simple - Core Book
 |  | Cengage | CENMAS |  | 9781285423715 | [NAME] | Ferrell/Frederich/Ferrell | 2013-01-22 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 200 |  | 0 |  | 0 | 20. Mechanical - Core Book |  |  |  |  |  |  | India will do
 |  | Cengage | CENMAS |  | 9781285425139 | [NAME] | Ferrell/Frederich/Ferrell ISE | 2013-01-22 00:00:00 | Freelance | [NAME] | 2013-02-26 00:00:00 | 2013-12-02 00:00:00 | 100 |  | 54 |  | 0 | 17. CD AIsE/ISE or non-templated Ancillary
 |  | Cengage | CENMAS |  | 9781285425139 | [NAME] | Ferrell/Frederich/Ferrell ISE | 2013-01-22 00:00:00 | in house | N/A | na | 2013-12-02 00:00:00 | 120 |  | 0 | na | 0 | 10. CM Templated Serues Pickup and Modify
 |  | Cengage | CENMAS |  | 9781285425139 | [NAME] | Ferrell/Frederich/Ferrell ISE | 2013-01-22 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 100 |  | 0 |  | 0 | 21. Mechanical (IE, ISE, AISE, ADV, Splits) |  |  |  |  |  |  | India will do
18 |  | Cengage | CENMAS |  | 9781285428222 | [NAME] | Meiners | 2013-02-11 00:00:00 |  |  |  | 2013-12-02 00:00:00 | 1500 |  |  |  | 0 | 25. ID Adaptation, PAL Stylesheet |  |  |  |  |  |  | design launch meeting on 2/28 will determine costs.
 |  | Cengage | CENMAS |  | 9781285428222 | [NAME] | Meiners | 2013-02-11 00:00:00 |  |  |  | 2013-12-02 00:00:00 | 300 |  |  |  | 0 | 4. IDM Adaptation, PAL
 |  | Cengage | CENMAS |  | 9781285428222 | [NAME] | Meiners | 2013-02-11 00:00:00 |  |  |  | 2013-12-02 00:00:00 | 1250 |  |  |  | 0 | 15. CD Simple - Core Book
 |  | Cengage | CENMAS |  | 9781285428222 | [NAME] | Meiners | 2013-02-11 00:00:00 |  |  |  |  | 225 |  |  |  | 0 | 11. CM Adaptation, Simple - Core Book
 |  | Cengage | CENMAS |  | 9781285428222 | [NAME] | Meiners | 2013-02-11 00:00:00 |  | N/A |  | 2013-12-02 00:00:00 | 200 |  |  |  | 0 | 20. Mechanical - Core Book |  |  |  |  |  |  | India will do
 |  | Cengage | CENMAS |  | 9781285435992 | [NAME] | Meiners IE | 2013-02-11 00:00:00 |  |  |  | 2013-12-02 00:00:00 | 100 |  |  |  | 0 | 21. Mechanical (IE, ISE, AISE, ADV, Splits) |  |  |  |  |  |  | India will do
 |  | BSM | Bedford | 101H | [PHONE] | [NAME] | Braziller, The Bedford Guide to [NAME] | 2013-03-05 00:00:00 | In-house | N/A | na | 2013-03-15 00:00:00 |  | 800 | na | na | 0 | design revisions v7 & v8