{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Pub Plan","Contract Request"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":37,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pub Plan","index":0,"n_rows":40,"n_cols":30,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,3,1,12],[3,3,3,4],[2,3,2,9]]}
[]
[null,"Title",null,"Somebody Telling Somebody Else: Toward a Rhetorical Poetics of Narrative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type"]
[null,"Series",null,"Theory and Interpretation of Narrative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Creative Writing"]
[null,"Type",null,"Average",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Average"]
[null,"Wordcount",null,113589,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Complex"]
[null,"Pages",null,310]
[null,"Trim",null,"6x9",null,null,null,null,"Print for Stock GM",null,{"$f":"(K14+K16)/(K8+K16)","v":0.6583621642729911},null,null,null,null,null,"POD GM",{"$f":"(R14+R16)/(R8+R16)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Cloth","Paper",null,null,null,"Total revenues",null,{"$f":"SUM(Y17,Y18)","v":23965.989599999997},null,null,null,null,null,null,{"$f":"SUM(Y17,Y18)","v":23965.989599999997}]
[null,"Copies printed",null,65,1200]
[null,"Frees",null,5,50,null,null,null,"Inflated costs",null,{"$f":"(D16+D17+E16+E17)*1.02","v":7054.8899760000004},null,null,null,null,null,null,{"$f":"(F16+D17+G16)*1.02","v":{"$error":"#VALUE!"}}]
[null,"Price",null,99.95,29.95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pb var royalty rate",{"$f":"IF(E13=0,0,IF(E13>E27+E28+E29,(((E13-E27-E28-E29)*B30)+(E29*B29)+(E28*B28)+(E27*B27))/E13,IF(E13>E27+E28,(((E13-E27-E28)*B29)+(B28*E28)+(B27*E27))/E13,IF(E13>E27,((((E13-E27)*B28)+(E27*B27))/E13),B27))))","v":4.3333333333333335E-2}]
[null,"Discount",null,"Short","Short",null,null,null,"Total royalties",null,{"$f":"SUM(Y17*V21,Y18*V13)","v":1132.7988419999999},null,null,null,null,null,null,{"$f":"SUM(Y17*V21,Y18*V13)","v":1132.7988419999999},null,null,"Pb ser royalty rate",{"$f":"IF(ISBLANK(D3),0,VLOOKUP(D3,$X$28:$AD$40,7))","v":0.01},null,null,null,1,"Short",0.72729999999999995,{"$f":"SUM(AB12+0.2727)","v":1}]
[null,"Projected Sales",null,60,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pb royalty rate",{"$f":"SUM(V11:V12)","v":5.3333333333333337E-2},null,null,null,2,"Trade",0.55700000000000005,{"$f":"AB13+0.443","v":1}]
[null,null,null,null,null,"HC POD","Paper POD",null,"Contribution",null,{"$f":"K8-K10-K12","v":15778.300781999995},null,null,null,null,null,null,{"$f":"R8-R10-R12","v":{"$error":"#VALUE!"}}]
[null,"Unit Cost",null,{"$f":"IF(ISERROR(D16/D9),\"\",D16/D9)","v":11.322153846153848},{"$f":"IF(ISERROR(E16/E9),\"\",E16/E9)","v":2.4925000000000002},{"$f":"IF(D9=\"\",\"\",IF(D7=\"7x10\",6+(D6*0.02),6+(D6*0.015)))","v":10.649999999999999},{"$f":"IF(E9=\"\",\"\",IF(E9<100,0.9*(6+(D6*0.015)),IF(E9<250,0.85*(6+(D6*0.015)),IF(E9<500,0.75*(6+(D6*0.015)),\"Use Offset\"))))","v":"Use Offset"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Cloth discount",{"$f":"IF(ISBLANK(D11),0,VLOOKUP(D12,AA12:AB13,2))","v":0.72729999999999995}]
[null,"Manufacturing",null,735.94,2991,{"$f":"IF(ISERROR(F15*D13),\"\",F15*D13)","v":638.99999999999989},{"$f":"IF(ISERROR(G15*E9),\"\",G15*E9)","v":""},null,"Subsidy",null,null,null,null,null,null,null,null,null,null,null,"Paper discount",{"$f":"IF(ISBLANK(E11),0,VLOOKUP(E12,AA12:AB13,2))","v":0.72729999999999995}]
[null,"Non-manufacturing costs",null,{"$f":"IF(D6=\"\",\"\",IF(D4=\"Creative Writing\", (D6*5.12)+(((D5/250)*2)*1.15)+H18, IF(D4=\"Average\", (D6*4.66)+(((D5/250)*2)*1.15)+H18, (D6*6.34)+(((D5/250)*2)*1.15)+H18)))","v":3189.6188000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cloth revenues",{"$f":"(D13)*D11*V15","v":4361.6180999999997}]
[null," Copyediting:",null,{"$f":"IF(D5=\"\",\"\",(((D5/250)*2)*1.15))","v":1045.0187999999998},"Typesetting:",{"$f":"IF(D6=\"\",\"\",IF(D4=\"Creative Writing\",D6*5.12,IF(D4=\"Average\",D6*4.66,D6*6.34)))","v":1444.6000000000001},"Design:",700,"To reach 65%",null,{"$f":"IF(K7<0.65,((K10+K12)*(1/(1-0.65)))-K8-K16,0)","v":0},null,null,null,null,null,null,{"$f":"IF(R7<0.65,((R10+R12)*(1/(1-0.65)))-R8-R16,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Paper revenues",{"$f":"(E13)*E11*V16","v":19604.371499999997}]
[null,null,null,"Royalties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cl var royalty rate",{"$f":"IF(D13=0,0,IF(D13>E21+E22+E23,((D13-E21-E22-E23)*B24+(E23*B23)+(E22*B22)+(E21*B21))/D13,IF(D13>E21+E22,((D13-E21-E22)*B23+(B22*E22)+(B21*E21))/D13,IF(D13>E21,(((D13-E21)*B22+(E21*B21))/D13),B21))))","v":0}]
[null,"Cloth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cl ser royalty rate",{"$f":"IF(ISBLANK(D3),0,VLOOKUP(D3,X28:AD40,6))","v":0.02}]
[null,0,null,"on the first",200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cl royalty rate",{"$f":"SUM(V19:V20)","v":0.02},"Cloth",{"$f":"CONCATENATE(\"CLOTH: \",IF(ISBLANK(B21),\"\",CONCATENATE(B21*100,\"% on the first \",E21,\" copies sold, \")),IF(ISBLANK(B22),\"\",CONCATENATE(\"rising to \",B22*100,\"% on the next \",E22,\" copies sold, \")),IF(ISBLANK(B23),\"\",CONCATENATE(\"rising to \",B23*100,\"% on the next \",E23,\" copies sold, \")),IF(AND(ISBLANK(B21),ISBLANK(B22),ISBLANK(B23),NOT(ISBLANK(B24))),CONCATENATE(B24*100,\"% on all copies sold.\"),\"\"),IF(AND(ISBLANK(B21),ISBLANK(B22),ISBLANK(B23),ISBLANK(B24)),\"No royalties.\",\"\"),IF(AND(NOT(ISBLANK(B24)),NOT(ISBLANK(B21))),CONCATENATE(\"and \",B24*100,\"% on all copies sold thereafter.\"),\"\"))","v":"CLOTH: 0% on the first 200 copies sold, and 2% on all copies sold thereafter."}]
[null,null,null,"on the next",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paper",{"$f":"CONCATENATE(\"PAPER: \",IF(ISBLANK(B27),\"\",CONCATENATE(B27*100,\"% on the first \",E27,\" copies sold, \")),IF(ISBLANK(B28),\"\",CONCATENATE(\"rising to \",B28*100,\"% on the next \",E28,\" copies sold, \")),IF(ISBLANK(B29),\"\",CONCATENATE(\"rising to \",B29*100,\"% on the next \",E29,\" copies sold, \")),IF(AND(ISBLANK(B27),ISBLANK(B28),ISBLANK(B29),NOT(ISBLANK(B30))),CONCATENATE(B30*100,\"% on all copies sold.\"),\"\"),IF(AND(ISBLANK(B27),ISBLANK(B28),ISBLANK(B29),ISBLANK(B30)),\"No royalties.\",\"\"),IF(AND(NOT(ISBLANK(B30)),NOT(ISBLANK(B27))),CONCATENATE(\"and \",B30*100,\"% on all copies sold thereafter.\"),\"\"))","v":"PAPER: 2% on the first 200 copies sold, and 5% on all copies sold thereafter."}]
[null,null,null,"on the next",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electronic",{"$f":"CONCATENATE(\"ELECTRONIC: \",IF(ISBLANK(B33),\"\",CONCATENATE(B33*100,\"% on the first \",E33,\" copies sold, \")),IF(ISBLANK(B34),\"\",CONCATENATE(\"rising to \",B34*100,\"% on the next \",E34,\" copies sold, \")),IF(ISBLANK(B35),\"\",CONCATENATE(\"rising to \",B35*100,\"% on the next \",E35,\" copies sold, \")),IF(AND(ISBLANK(B33),ISBLANK(B34),ISBLANK(B35),NOT(ISBLANK(B36))),CONCATENATE(B36*100,\"% on all copies sold.\"),\"\"),IF(AND(ISBLANK(B33),ISBLANK(B34),ISBLANK(B35),ISBLANK(B36)),\"No royalties.\",\"\"),IF(AND(NOT(ISBLANK(B36)),NOT(ISBLANK(B33))),CONCATENATE(\"and \",B36*100,\"% on all copies sold thereafter.\"),\"\"))","v":"ELECTRONIC: 10% on all copies sold."}]
[null,0.02,null,"thereafter"]
[]
[null,"Paper",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Series",null,null,null,null,"cloth","pb"]
[null,0.02,null,"on the first",200,null,null,null,null,null,null,null,null,null,null,null,null,"POD",null,null,"POD Trims",null,0,"No Series",null,null,null,null,0,0]
[null,null,null,"on the next",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Black Performance and Cultural Criticism",null,null,null,null,0.02,0.01]
[null,null,null,"on the next",null,null,null,null,null,null,null,null,null,null,null,null,"Small","Pgs","Cover","Page",null,null,2,"Classical Memories/Modern Identities",null,null,null,null,0.02,0.01]
[null,0.05,null,"thereafter",null,null,null,null,null,null,null,null,null,null,null,null,null,"18-46",1.48,null,"small","6x9",3,"Contemporary Latino Writers and Directors",null,null,null,null,0.01,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"48-106",2.2999999999999998,null,"large","7x10",4,"Early Modern Drama Texts",null,null,null,null,0.01,0.01]
[null,"Electronic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"108+",0.9,1.2999999999999999E-2,"small","6.14x9.21",5,"Interventions",null,null,null,null,0.02,0.01]
[null,null,null,"on the first",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",6,"Literature, Religion, and Postsecular Studies",null,null,null,null,0.01,0.01]
[null,null,null,"on the next",null,null,null,null,null,null,null,null,null,null,null,null,"Large","18-46",2.09,null,null,null,7,"Studies in Comics and Cartoons",null,null,null,null,1.4999999999999999E-2,7.4999999999999997E-3]
[null,null,null,"on the next",null,null,null,null,null,null,null,null,null,null,null,null,null,"48-106",3.24,null,null,null,8,"Studies in Germanic Linguistics",null,null,null,null,0.01,7.4999999999999997E-3]
[null,0.1,null,"thereafter",null,null,null,null,null,null,null,null,null,null,null,null,null,"108+",1.3,1.7999999999999999E-2,null,null,9,"Text and Context",null,null,null,null,0.02,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Theoretical Developments in Hispanic Linguistics",null,null,null,null,0.01,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Theory and Interpretation of Narrative",null,null,null,null,0.02,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Transoceanic Series",null,null,null,null,1.4999999999999999E-2,1.4999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Victorian Critical Interventions",null,null,null,null,0.02,0.01]

{"sheet":"Contract Request","index":1,"n_rows":26,"n_cols":27,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,3,23,9],[25,3,25,9],[14,3,14,9],[16,3,16,9],[0,0,0,10],[12,3,12,9],[8,3,8,9],[10,3,10,4],[4,3,4,9],[2,3,2,4],[2,6,2,7],[2,9,2,10]]}
["CONTRACT REQUEST FORM"]
[]
[null,"Author(s)' full name, address(es), and SSN(s) (if known)",null,"James Phelan\nOhio State University\n164 W. 17th Ave.\nColumbus, Ohio \n43210-1370 \n614/292-6065, \n614/292-6669\nphelan.1@osu.edu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completion"]
[null,"Title",null,{"$f":"IF(ISBLANK('Pub Plan'!D2:M2),\"\",'Pub Plan'!D2:M2)","v":"Somebody Telling Somebody Else: Toward a Rhetorical Poetics of Narrative"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard"]
[null,"Contingent on"]
[]
[null,"Series",null,"Theory and Interpretation of Narrative"]
[]
[null,"Delivery",null,"2016-10-28"]
[]
[null,"Length",null,"No more than 113,000 words and 12 halftone illustrations."]
[]
[null,"Royalties",null,{"$f":"CONCATENATE('Pub Plan'!X21,CHAR(10),'Pub Plan'!X22,CHAR(10),'Pub Plan'!X23)","v":"CLOTH: 0% on the first 200 copies sold, and 2% on all copies sold thereafter.\nPAPER: 2% on the first 200 copies sold, and 5% on all copies sold thereafter.\nELECTRONIC: 10% on all copies sold."}]
[]
[null,"Advance"]
[]
[null,"Comp copies",null,10," if cloth"]
[null,null,null,5," if paperback"]
[null,null,null,2," cloth if simultaneous pb"]
[null,null,null,8," paper if simultaneous pb"]
[]
[null,"Additional contract provisions"]
[]
[null,"Notes"]