{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["My Needs, Offerings","Partners' Needs, Offerings","ID Power Partnerships","MESO- Ex.","ScoringSystem- Ex. CEO Hire","Calculator","Reference"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":5,"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":"My Needs, Offerings","index":0,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,8],[33,1,33,2]]}
["Step 1- Identifying My Needs, Offerings, and Partners "]
[null,"Me","Objective/Goal","My Core Needs","How Can I Meet My  Needs","Partner","My Current Offerings","Potential New Offerings (Solutions)","New Partners"]
["1)","Rescue Cat Café","Stay in Business\n(Business Sustainability)","Increase Revenue",null,"Customers","Cute Cats"]
[null,null,null,null,null,null,"Declicious Craft Coffee"]
[null,null,null,null,null,null,"Tasty Pastries"]
[null,null,null,null,"Convince current customers to pay more",null,"Welcoming Environment "]
[null,null,null,null,"Convince current customers to buy more",null,"Friendly/Attentive Staff"]
[null,null,null,null,"Attract new customers",null,"Reliable Wi-Fi","Faster Wi-Fi"]
[null,null,null,null,null,null,"Advertising on bulletin Board","Advertising on Website","Local Businesses w/in 20 mile radius"]
[null,null,null,null,null,null,"Daily Specials","Holiday Specials (unique menu)"]
[null,null,null,null,"Create new revenue streams",null,"Bottomless cups of Coffee","Loyalty Programs/Discounts","Veterinarians, University, Influencers"]
[null,null,null,null,null,null,"Small cat accessories (Stickers, cute toys, etc.)","Sell cat food ","Petco/PetSmart/Fancy Feast Supplier"]
[null,null,null,null,null,null,null,"Sell craft coffee making accessories (cat face themed)","Next door art store"]
[null,null,null,null,null,null,"Mostly empty storage room","Extra space as subleased unit","Supplier? \nPerson looking for office space?"]
[null,null,null,"Reduce Costs","Reduce COGS (ingredients)","Supplier","Steady business ","Bulk Discounts"]
[null,null,null,null,"Reduce labor/turnover costs","Employees","Ability to develop a relationship w/customers","Employee Retention Program= \na. Leadership & Professional Development\nb. Cafe entrepreneurship program","University /Landlord/Mentors Group"]
[null,null,null,null,null,null,null,"Free Pastries"]
[null,null,null,null,"Reduce cost of serving each customer",null,"Employee Training ","Mobile Table Management Software \na. Reduces wait time\nb.  Mobile ordering ","Customers "]
[null,null,null,null,"Reduce rent costs","Landlord ","Paying Rent","Joint Management Training Program"]
[null,null,null,"Protect the Cats","Provide safe space free of dangerous people and weather","Animals","Café & Private Room for Animals"]
[null,null,null,null,"Provide healthy environment for cats and customers",null,"Café"]
[null,null,null,null,"Care for more cats",null,null,"Cat Sponsorship Program","Animal Hospitals (Veterinarians) "]
[null,null,null,null,null,null,null,null,"Animal Shelters"]
[null,null,null,null,"Video Podcast for animal rights advocacy and marketing my café",null,null,null,"Pet influencers\nPet sponsors\nAnimal Activists "]
[null,null,null,"Help the Community","Improve neighborhood security (for both animals and people)",null,null,"Beautify the Environment (i.e., broken window theory)\n"]
[null,null,null,null,null,null,null,"a. Neighborhood watch","Neighborhood community"]
[null,null,null,null,null,null,null,"b. Pet Lover Volunteers","Animal Shelters, Online communities"]
[null,null,null,null,null,null,null,"c. Artist collaborations","Artists"]
[null,null,null,null,"Alleviate local poverty",null,null,"Donate leftover food","Homeless/Animal Shelters"]
[null,null,null,null,null,null,null,"\"End of Day\" Discounts at affordable rates"]
[null,null,null,null,"Provide Jobs",null,null,null,"University students, homeless, volunteers"]
[null,null,null,null,"Discover new ways to support the community"]
[]
[null,"*Reference for Steps 1-5- Adapted from:"]
[null,"Gunia, B. C. (2019). The bartering mindset: A mostly-forgotten framework for mastering your next negotiation. Toronto; Buffalo; London: University of Toronto Press."]

{"sheet":"Partners' Needs, Offerings","index":1,"n_rows":77,"n_cols":4,"rows_kept":77,"cut":false,"hidden":false,"merged":[[77,0,77,3],[53,0,53,3],[56,0,56,3],[60,0,60,3],[65,0,65,3],[69,0,69,3],[72,0,72,3],[50,0,50,3],[18,0,18,3],[14,0,14,3],[0,0,0,3],[2,0,2,3],[27,0,27,3],[43,0,43,3],[46,0,46,3]]}
["Step 2: Identifying Transaction Partners + Step 3: Identify their Needs & Offerings"]
[null," Partners","Their Needs ","Their Offerings "]
["Current Partners"]
[1,"Customers","(Entertainment) Cute Cats\na. More cats may attract new or more diverse customers","Revenue (i.e., current spending at café)"]
[null,null,"Declicious Craft Coffee","Revenue and Referrals"]
[null,null,"Tastier Pastries/food","Higher Margins= More $$"]
[null,null,"Welcoming Environment ","Repeat Customer= Increased Customer Lifetime Value= Increased Spending"]
[null,null,"Friendly/Attentive Staff","Repeat customer"]
[null,null,"Reliable Wi-Fi","More time at café and potentially more spending"]
[null,null,"Advertising on bulletin Board","Advertising revenue"]
[null,null,"Daily Specials","Revenue & repeat customers"]
[null,null,"Bottomless cups of Coffee","Revenue, buying more items"]
[null,null,"(Souvenirs) Small cat accessories (Stickers, cute toys, etc.)","Revenue, increased brand awareness"]
[null,null,"Status & Recognition ","a. (Marketing) User Generated Content via Social Media Mentions\nb. Volunteers?"]
[]
[2,"Employees","Employment","Work"]
[null,null,"Career Advancement Opportunities\na. Can help with employee retention","Work better and harder, stay w/company longer "]
[null,null,"Free/Discounted Food"]
[]
[3,"Suppliers","Steady Business","Ingredients"]
[null,null,null,"volume/bulk discounts"]
[null,null,"Additional storage space","Subleasing revenue?"]
[]
[4,"Landlord","Timely Rent","Building"]
[null,null,"Good Managers for growing Rental Business ","Rent Relief"]
[null,null,null,"Subleasing Approval"]
[]
["Potential Partners"]
[5,"Influencers","Attention","Marketing (User Generated Content-UGC) + Revenue + Referrals "]
[null,null,"Good Location for Content"]
[null,null,"Picture/Content Corner"]
[]
[6,"Artists","Art Exposure for Art Sales","Decorate walls\na. Influencer Collaborations?"]
[null,null,"Venue\na. Display/Sell their art\nb. Art shows?","New revenue\na. Percentage of art sales?\nB. Art show tickets\nc. Art show food sales"]
[null,null,"Affordable meals","Revenue"]
[]
[7,"Podcasters","Attention/Listeners","Marketing (User Generated Content-UGC) + Revenue + Referrals "]
[null,null,"Good Location for Video Content","Collaborations- Influencers + Artists"]
[null,null,"Picture/Content Corner","Podcast co-producers"]
[null,null,"Affordable meals","Partnership with café to start their own podcast"]
[]
[8,"Grocery Store","New inventory--> Delicious local food items\na. Pastries?\nB. Craft coffee? ","New/expanded customer base\na. Increase sales\n"]
[null,null,"More customers\na. Repeat customers\nb. Prevent big brand store encroachment ","Increased brand exposure (Marketing)\na. Sign Advertising Café on Window"]
[]
[9,"Movie Theater","More customers","Referrals"]
[null,null,null,"On-screen advertising"]
[]
[10,"Farmers Market","Coffee","New revenue source"]
[null,null,"Delicious food items (new inventory)","Free Advertising"]
[null,null,"More customers"]
[]
[11,"Police Officers","Discounts","Watch Neighborhood (i.e., presence patrol while in café)"]
[null,null,null,"Revenue"]
[]
[12,"Neighboring Towns","New food items","New revenue"]
[null,null,"New entertainment venue"]
[]
[13,"Animal Shelters","Pet Food","Safe space for animal rescues"]
[null,null,"Donations"]
[null,null,"Pet Adoptions","Pets for adoption"]
[]
[14,"Homeless Shelters","Food","Poverty/Hunger alleviation"]
[null,null,"Donations","Tax Break for donations"]
[null,null,"Employment Opportunities for Homeless Individuals","Potential Employees (ESG)"]
[null,null,null,"Goodwill (ESG)"]
[]
[15,"Support Groups\na. Veterans\nb. AA","Meeting space","Pet Therapy "]
[null,null,"Therapy space","Community Goodwill"]
[null,null,"Food & drink for meetings","Revenue"]
[]
[16,"Real Estate Agent","Subleased Space","Subleasing revenue"]
[null,null,null,"New revenue from client meetings at café?"]
[]
[17,"Local Schools\na. Universities","Affordable meals & study space (w/lots of charging stations)","Revenue + Referrals "]
[null,"b. High Schools","Entertaining venue for kids to play while parents eat/drink","Revenue + Marketing (kid pics)"]
[null,"c. Elementary School","Field trip venue ","Revenue"]
[null,null,"Animal rights education","Goodwill + Advocacy collaborations"]

{"sheet":"ID Power Partnerships","index":2,"n_rows":91,"n_cols":11,"rows_kept":91,"cut":false,"hidden":false,"merged":[[81,5,81,6],[29,5,29,7],[0,4,11,4],[27,4,34,4],[20,5,20,7],[24,5,24,7],[52,5,52,7],[48,5,48,7],[45,5,45,7],[42,5,42,7],[37,5,37,7],[33,5,33,7],[49,4,79,4],[79,5,79,7],[2,5,2,7],[71,0,71,3],[74,0,74,3],[79,0,79,3],[0,5,0,7],[62,0,62,3],[67,0,67,3],[0,0,0,3],[55,5,55,7],[74,5,74,7],[71,5,71,7],[67,5,67,7],[62,5,62,7],[58,5,58,7],[0,9,0,12],[1,9,1,12],[2,9,2,12],[3,9,3,12],[6,9,6,12],[7,10,7,12],[48,0,48,3],[52,0,52,3],[55,0,55,3],[58,0,58,3],[20,0,20,3],[29,0,29,3],[45,0,45,3],[8,10,8,12],[9,10,9,12],[10,10,10,12],[11,10,11,12],[12,10,12,12],[13,10,13,12]]}
["Step 2: Identifying Transaction Partners + Step 3: Identify their Needs & Offerings",null,null,null,null,"Step 4: Identify Most Powerful Partnerships",null,null,null,"Questions to Ask"]
[null," Partners","Their Needs ","Their Offerings ",null,"How to fulfill MY needs with THEIR Offerings","How to fulfill THEIR needs with MY offerings","Benefit/Cost",null,"1. What would trade/deal actually look like?"]
[null,null,null,null,null,"Current Partners",null,null,null,"2. How well would it satisfy both of our core needs?"]
[1,"Customers","(Entertainment) Cute Cats\na. More cats may attract new or more diverse customers","Revenue (i.e., current spending at café)",null,"More revenue from repeat customers","\"Hire\" more cats",null,null,"3. How expensive would it be to implement?"]
[null,null,"Declicious Craft Coffee","Revenue and Referrals",null,"More revenue from loyal repeat customers","a. Create Customer Loyalty program\nb. Create Customer Referral Program"]
[null,null,"Tastier Pastries/food","Higher Margins= More $$",null,null,"Diversified Menu"]
[null,null,"Welcoming Environment ","Repeat Customer= Increased Customer Lifetime Value= Increased Spending",null,null,"Create study corner",null,null,"Power Partner Legend"]
[null,null,"Friendly/Attentive Staff","Repeat customer",null,null,null,null,null,"Color","Description"]
[null,null,"Reliable Wi-Fi","More time at café and potentially more spending",null,"Cost- Buy High speed wifi packages","Offer High speed WiFi packages",null,null,"Red","Low Benefit/HIgh Cost to Me"]
[null,null,"Advertising on bulletin Board","Advertising revenue",null,null,"Offer small business ad space on website or onsite bulleting board",null,null,"Yellow","Low Benefit/Low Cost to Me"]
[null,null,"Daily Specials","Revenue & repeat customers",null,"More revenue","a. Holiday Specials\nb. Themed Menu Items (Paw-print cookies…)",null,null,"Light Green","High Benefit/High Cost to Me"]
[null,null,"Bottomless cups of Coffee","Revenue, buying more items",null,null,"Offer for a fixed fee",null,null,"Dark Green","High Benefit/Low Cost to Me"]
[null,null,"(Souvenirs) Small cat accessories (Stickers, cute toys, etc.)","Revenue, increased brand awareness",null,"Medium cost= seasonal offerings (left over inventory costs?)","Holiday Specials?",null,null,"Light Purple","Potential Power Partner"]
[null,null,"Status & Recognition ","(Marketing) User Generated Content via Social Media Mentions",null,"+ New and repeat customers\n- Labor Costs from Volunteers\n+ Community Engagement ","a. Create Influencer Corner\nb. Create Volunteer Program",null,null,"Dark Purple","Selected/Chosen Power Partner"]
[]
[2,"Employees","Employment","Work",null,"Benefit= reduced employee turnover costs","Employee recognition program"]
[null,null,"Career Advancement Opportunities\na. Can help with employee retention","Work better and harder, stay w/company longer ",null,"Reduced employee turnover","Co-create management training program with Landlord"]
[null,null,"Free/Discounted Food",null,null,"Employee retention","Offer free or leftover pastries at end of morning/lunch shift"]
[null,null,null,null,null,null,"Create Part-time Education Program"]
[null,null,null,null,null,"Increased Revenue & Retention","Provide Sales Training"]
[]
[3,"Suppliers","Steady Business","Ingredients",null,"(Cost) buy better ingredients ","Purchase pricier ingredients"]
[null,null,null,"volume/bulk discounts",null,null,"Guaranteed Purchase Level"]
[null,null,"Additional storage space","Subleasing revenue?",null,"Revenue for sublease","Offer Storage Space for a fee"]
[]
[4,"Landlord","Timely Rent","Building",null,null,"Pay rent on time"]
[null,null,"Good Managers for growing Rental Business ","Rent Relief",null,"Employee retention","Train and offer employees for management program"]
[null,null,null,"Subleasing Approval",null,"Sublease revenue","Offer to sign a longer term lease"]
[]
[null,null,null,null,null,"Potential Partners"]
[5,"Influencers","Attention","Marketing (User Generated Content-UGC) ",null,"+ Revenue + Referrals + Brand Awareness","Create Influencer Corner"]
[null,null,"Good Location for Content",null,null,null,"Offer Discount for social media mentions"]
[null,null,"Picture/Content Corner",null,null,null,"Offer option to rent content corner for a fee"]
[]
[6,"Artists","Art Exposure for Art Sales","Decorate walls\na. Influencer Collaborations?",null,"+ Revenue + Referrals + Brand Awareness","Display art work\na. create artist/influencer collabs"]
[null,null,"Venue\na. Display/Sell their art\nb. Art shows?","New revenue\na. Percentage of art sales?\nB. Art show tickets\nc. Art show food sales",null,"New revenue\na. Percentage of art sales\nB. Art show tickets\nc. Art show food sales","Host art shows"]
[null,null,"Affordable meals","Revenue"]
[]
[7,"Podcasters","Attention/Listeners","Marketing (User Generated Content-UGC) + Revenue + Referrals ",null,"'+ Revenue + Referrals + Brand Awareness","Create/host podcast space"]
[null,null,"Good Location for Video Content","Collaborations- Influencers + Artists"]
[null,null,"Picture/Content Corner","Podcast co-producers",null,null,"Collab with podcasters"]
[null,null,"Affordable meals","Partnership with café to start their own podcast",null,"Help Launch our own podcast: Rescue Café Pod","Offer Podcast/listener discounts"]
[]
[8,"Grocery Store","New inventory--> Delicious local food items\na. Pastries?\nB. Craft coffee? ","New/expanded customer base\na. Increase sales\n",null,"Enter new market/customer base\na. Increased sales\n","Provide Pastries/coffee"]
[null,null,"More customers\na. Repeat customers\nb. Prevent big brand store encroachment ","Increased brand exposure (Marketing)\na. Sign Advertising Café on Window",null,"Host Café sign on website and/or storefront ","Print Coupon on bottom of our receipts"]
[]
[9,"Movie Theater","More customers","Referrals",null,"+customers + referrals","Advertise on social media/website/café flyer"]
[null,null,null,"On-screen advertising",null,"(High cost to them) "]
[]
[10,"Farmers Market","Coffee","New revenue source",null,"'+ Revenue + Referrals + Brand Awareness","Provide coffee"]
[null,null,"Delicious food items (new inventory)","Free Advertising",null,null,"Provide pastry options"]
[null,null,"More customers",null,null,null,"Provide Kitty employees to the market"]
[]
[11,"Police Officers","Discounts","Watch Neighborhood ",null,"Safer neighborhood and community","Conduct presence patrol while in café (low benefit to them)"]
[null,null,null,"Revenue",null,"+ Revenue + Referrals ","Create public servant discount program (low benefit to them?)"]
[]
[12,"Neighboring Towns","New food items","New revenue",null,"+ Customers + Revenue","Lease and operate a food truck"]
[null,null,"New entertainment venue"]
[]
[13,"Animal Shelters","Pet Food","Poverty/Hunger alleviation ",null," + Community Goodwill ","a. Create customer pet food sponsorship program\nb. Donate any leftover pet food "]
[null,null,"Donations","Safe space for animal rescues",null,"a. (Benefit) Marketing content, increased goodwill= + brand power= + customer loyalty and sales= +revenue\nb. (Cost) Donation & labor hours to track donations (or purchase software to manage donations)","a. Put up sign in café about Animal Shelter needs and donations\nb. Make a donation \nc. Offer % of every sale to support (i.e., 5% of every purchase goes to Support the Animal Shelter, etc.)"]
[null,null,"Pet Adoptions","Pets for adoption",null,"+ Protecting the cats by helping them find forever homes","a. Make customer referrals \nb. Make landing page on website for pet adoptions \nc. Host a cat in need of adoption in the café for limited time (i.e., 2 weeks to find their forever homes)"]
[]
[14,"Soup Kitchen","Food","Poverty/Hunger alleviation ",null,"+ Costs + Community Goodwill ","a. Offer leftover pastries/coffee after each morning/Lunch shift\nb. Create Buy One, Give One (BOGO) Program"]
[null,null,"Donations","Tax Break for donations",null,"a. (Benefit) Marketing content, increased goodwill= + brand power= + customer loyalty and sales= +revenue\nb. (Cost) Donation & labor hours to track donations (or purchase software to manage donations)","a. Put up sign in café about Soup Kitchen donations\nb. Make a donation \nc. Offer % of every sale to support (i.e., 5% of every purchase goes to the Soup Kitchen, etc.)"]
[null,null,"Employment Opportunities for Homeless Individuals","Potential Employees (ESG)",null,"a. - New Empoyee Recruitment costs\nb. + Employee retention = - turnover and new training costs","Create partnership/hire-local program"]
[null,null,null,"Goodwill (ESG)",null,"+ Customers","Make referrals "]
[]
[15,"Support Groups\na. Veterans\nb. AA","Meeting space","+ Revenue (food/coffee purchases)",null,"+ Revenue \n+ Referrals\n- Potential brand damage from \"stigma\" associated with support groups (negative spillage)","a. Offer regular meeting space\n"]
[null,null,"Therapy space","Take a cat/pet home with them?",null,"+ Community Goodwill\n+ Helping the cats find forever homes\n+ Helping relieve Stress and/or Veteran PTSD","a. Partner w/ a therapist to conduct weekly Pet Therapy sessions\nb. Introduce Veterans to a potential forever friend (i.e., new pet cat)"]
[null,null,"Food & drink for meetings","Revenue",null,"+ Revenue \n+ CLV from repeat customers","Offer food discounts "]
[]
[16,"Real Estate Agent","Subleased Space","Subleasing revenue",null,"+ Rent revenue ","Provide storage room as office space"]
[null,null,null,"New revenue from client meetings at café?",null,"+ Referals \n+ Purchases","Offer discounted food for meeting clients"]
[]
[17,"Local Schools\na. Universities","Affordable meals & study space (w/lots of charging stations)","Revenue + Referrals ",null,"+ revenue\n+ referrals \n- renovation costs?","a. Designated study space\nb. Student discounts "]
[null,"b. High Schools","Entertaining venue for kids to play while parents eat/drink","Revenue + Marketing (kid pics)",null,null,"Offer kids corner (playground, petting zoo)"]
[null,"c. Elementary School","Field trip venue ","Revenue"]
[null,null,"Animal rights education","Goodwill + Advocacy collaborations",null,"+ Goodwill \n+ Finding forever homes for some cats\n+ community animal rights awareness","Partner or prepare workshop \na. animal rights?\nB. proper pet care?\nC. Help find new pets"]
[]
[]
[null,null,null,null,null,"Data Analysis- Insights for Negotiation Strategy"]
[null,null,null,null,null,"Power Partners to Reach out by Priority","Overlapping Solutions to Implement"]
[null,null,null,null,null,"Grocey Store","Build Multi-function Content Corner "]
[null,null,null,null,null,"Influencers","Create Customer Loyalty program"]
[null,null,null,null,null,"Local University","Create Customer Referral Program"]
[null,null,null,null,null,"Landlord","Offer Discounts"]
[null,null,null,null,null,"Real Estate Agent","Create & Leverage Partnerships"]
[null,null,null,null,null,"Employees","Create Training Programs"]
[null,null,null,null,null,"Animal Shelter","Create Volunteer Program"]
[null,null,null,null,null,"Podcasters","Launch Rescue Pod"]

{"sheet":"MESO- Ex.","index":3,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,15],[6,19,6,21],[1,18,1,21],[2,19,2,21],[3,19,3,21],[4,19,4,21],[5,19,5,21],[2,3,2,6],[2,7,2,8],[2,14,2,15],[1,0,1,15],[2,10,2,13],[31,3,31,6],[31,7,31,8],[31,10,31,13],[31,14,31,15],[10,0,10,15],[11,3,11,6],[11,7,11,8],[11,10,11,13],[11,14,11,15],[21,0,21,15],[22,3,22,6],[22,7,22,8],[22,10,22,13],[22,14,22,15],[30,0,30,15]]}
["Step 5- Cultivate Power Partnerships Using MESOs"]
["Option A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Legend"]
[null,null,null,"Trade",null,null,null,"Me",null,null,"Trade",null,null,null,"You",null,null,null,"Color","Description"]
[null,"Partner","Role","Item/Issue","Quantity ","Unit","Unit Cost ($)","Total Costs ($)","Benefits","Role","Item/Issue","Quantity ","Unit","Unit Cost ($)","Total Costs ($)","Benefits",null,null,"Yellow","Variable Data"]
["1)","Grocery Store","Café Owner to Grocer","Pastries",600,"Day",0.3,{"$f":"E5*G5","v":180},{"$f":"O5-H5","v":120},"Grocer to Café Owner","Pastry Payment",600,"Item",0.5,{"$f":"L5*N5","v":300},"Attract new customers",null,null,"Light Green","Constant Data"]
[null,null,null,"Coupons on Receipts",100,"Day ",0.1,{"$f":"E6*G6","v":10},{"$f":"O6-H6","v":6.6666666666666679},null,"Printing Fee",null,"Month",500,{"$f":"500/30","v":16.666666666666668},"Advertisement",null,null,"Dark Green","Agreed Upon Value (Deal)"]
[null,null,null,null,null,null,null,null,null,null,"Café Sign Placement","Largest","Window",null,"Ad Space","Customer Referrals ",null,null,"Red","Deal Breaker"]
[null,null,null,null,null,null,"Totals",{"$f":"SUM(H5:H7)","v":190},{"$f":"SUM(I5:I7)","v":126.66666666666667},null,null,null,null,"Totals",{"$f":"SUM(O5:O7)","v":316.66666666666669},{"$f":"SUM(P5:P7)","v":0}]
[]
[]
["Option B"]
[null,null,null,"Trade",null,null,null,"Me",null,null,"Trade",null,null,null,"You"]
[" #","Partner","Role","Item/Issue","Quantity ","Unit","Unit Cost ($)","Total Costs ($)","Benefits","Role","Item/Issue","Quantity ","Unit","Unit Cost ($)","Total Costs ($)","Benefits"]
["1)","Grocery Store","Café Owner to Grocer","Pastries",625,"Day",0.3,{"$f":"E14*G14","v":187.5},{"$f":"O14-H14","v":125},"Grocer to Café Owner","Pastry Payment",{"$f":"E14","v":625},"Item",0.5,{"$f":"L14*N14","v":312.5},"Attract new customers"]
[null,null,null,"Coupons on Receipts",100,"Day ",0.1,{"$f":"E15*G15","v":10},{"$f":"O15-H15","v":6.6666666666666679},null,"Printing Fee",null,"Month",500,{"$f":"500/30","v":16.666666666666668},"Advertisement"]
[null,null,null,null,null,null,null,null,null,null,"Café Sign Placement","Medium","Window",null,"Ad Space","Customer Referrals "]
[null,null,null,null,null,null,"Totals",{"$f":"SUM(H14:H16)","v":197.5},{"$f":"SUM(I14:I16)","v":131.66666666666666},null,null,null,null,"Totals",{"$f":"SUM(O14:O16)","v":329.16666666666669},{"$f":"SUM(P14:P16)","v":0}]
[]
[]
[]
[]
["Option C"]
[null,null,null,"Trade",null,null,null,"Me",null,null,"Trade",null,null,null,"You"]
[" #","Partner","Role","Item/Issue","Quantity ","Unit","Unit Cost ($)","Total Costs ($)","Benefits","Role","Item/Issue","Quantity ","Unit","Unit Cost ($)","Total Costs ($)","Benefits"]
["1)","Grocery Store","Café Owner to Grocer","Pastries",450,"Day",0.3,{"$f":"E25*G25","v":135},{"$f":"O25-H25","v":146.25},"Grocer to Café Owner","Pastry Payment",{"$f":"E25","v":450},"Item",0.625,{"$f":"L25*N25","v":281.25},"Attract new customers"]
[null,null,null,"Coupons on Receipts",100,"Day ",0.1,{"$f":"E26*G26","v":10},{"$f":"O26-H26","v":6.6666666666666679},null,"Printing Fee",null,"Month",500,{"$f":"500/30","v":16.666666666666668},"Advertisement"]
[null,null,null,null,null,null,null,null,null,null,"Café Sign Placement","Largest","Window",null,"Ad Space","Customer Referrals "]
[null,null,null,null,null,null,"Totals",{"$f":"SUM(H25:H27)","v":145},{"$f":"SUM(I25:I27)","v":152.91666666666666},null,null,null,null,"Totals",{"$f":"SUM(O25:O27)","v":297.91666666666669},{"$f":"SUM(P25:P27)","v":0}]
[]
[]
["Data Analysis- Insights for Negotiation Strategy"]
[null,null,null,"Trade",null,null,null,"Me",null,null,"Trade",null,null,null,"You"]
[" #","Partner","Role","Item/Issue Priority","QTY Max (Ceiling)","Unit","QTY Min (Anchor)","Value of Bargaining Zone",null,"Role","Item/Issue Priority","QTY Max (Ceiling)","Unit","QTY Min (Anchor)","Value of Bargaining Zone"]
["1)","Grocery Store","Café Owner to Grocer","Coupons on Receipts",100,"Day",null,null,null,"Grocer to Café Owner","Printing Fee",null,"Month",500]
[null,null,2,"Pastries",625,"Day",450,{"$f":"E35-G35","v":175},null,2,"Pastry Payment",{"$f":"N25","v":0.625},"item",{"$f":"N14","v":0.5},{"$f":"L35-N35","v":0.125}]
[null,null,3,null,null,null,null,null,null,3,"Café Sign Placement",{"$f":"L27","v":"Largest"},"Window",{"$f":"L16","v":"Medium"},"Med-Large"]
[null,"BATNA"]

{"sheet":"ScoringSystem- Ex. CEO Hire","index":4,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[40,0,40,1],[43,6,43,9],[48,0,48,1],[56,0,56,1],[19,6,19,9],[24,0,24,1],[25,6,25,9],[31,6,31,9],[32,0,32,1],[37,6,37,9],[16,0,16,1],[0,0,0,1],[1,6,1,9],[7,6,7,9],[8,0,8,1],[13,6,13,9]]}
["Salary",null,null,"Min",{"$f":"SUM(B3,B11,B19,B27,B35,B43,B51,B59)","v":-8400},null,"Issues","Weight","Points","Score",null,"Actual Deal","Scoring System Points"]
["Options","Points",null,"Max",{"$f":"SUM(B7,B15,B23,B31,B39,B47,B55,B63)","v":13200},null,"Salary (27.8%)",null,null,null,null,86000,{"$f":"VLOOKUP(L2,G3:J7,4,FALSE)","v":20.833333333333336}]
[90000,-6000,null,"Range",{"$f":"E2-E1","v":21600},null,90000,0.27777777777777779,50,{"$f":"H3*I3","v":13.888888888888889},null,"15 Days",{"$f":"VLOOKUP(L3,G9:J13,4,FALSE)","v":13.888888888888888}]
[{"$f":"A3-2000","v":88000},-4500,null,null,null,null,{"$f":"G3-2000","v":88000},0.27777777777777779,65,{"$f":"H4*I4","v":18.055555555555557},null,"Plan E",{"$f":"VLOOKUP(L4,G15:J19,4,FALSE)","v":14.814814814814813}]
[{"$f":"A4-2000","v":86000},-3000,null,null,null,null,{"$f":"G4-2000","v":86000},0.27777777777777779,75,{"$f":"H5*I5","v":20.833333333333336},null,"Priority E",{"$f":"VLOOKUP(L5,G27:J31,4,FALSE)","v":11.111111111111111}]
[{"$f":"A5-2000","v":84000},-1500,null,null,null,null,{"$f":"G5-2000","v":84000},0.27777777777777779,85,{"$f":"H6*I6","v":23.611111111111111},null,"2025-07-01",{"$f":"VLOOKUP(L6,G21:J25,4,FALSE)","v":8.3333333333333321}]
[{"$f":"A6-2000","v":82000},0,null,null,null,null,{"$f":"G6-2000","v":82000},0.27777777777777779,100,{"$f":"H7*I7","v":27.777777777777779},null,0.08,{"$f":"VLOOKUP(L7,G33:J37,4,FALSE)","v":4.8148148148148149}]
[null,null,null,null,null,null,"Vacation Time (18.5%)",null,null,null,null,"Busan",{"$f":"VLOOKUP(L8,G39:J43,4,FALSE)","v":5.5555555555555554}]
["Vacation Time",null,null,null,null,null,"25 Days",0.18518518518518517,50,{"$f":"H9*I9","v":9.2592592592592595},null,1,{"$f":"VLOOKUP(L9,G45:J49,4,FALSE)","v":1.8518518518518516}]
["Options","Points",null,null,null,null,"20 Days",0.18518518518518517,65,{"$f":"H10*I10","v":12.037037037037036},null,"Total Score",{"$f":"SUM(M2:M9)","v":81.203703703703695}]
["25 Days",0,null,null,null,null,"15 Days",0.18518518518518517,75,{"$f":"H11*I11","v":13.888888888888888}]
["20 Days",1000,null,null,null,null,"10 Days",0.18518518518518517,85,{"$f":"H12*I12","v":15.74074074074074}]
["15 Days",2000,null,null,null,null,"5 Days",0.18518518518518517,100,{"$f":"H13*I13","v":18.518518518518519},null,"Min",{"$f":"SUM(J3,J9,J15,J21,J27,J33,J39,J45)","v":50.000000000000007}]
["10 Days",3000,null,null,null,null,"Insurance Coverage (14.8%)",null,null,null,null,"Max",{"$f":"SUM(J7,J13,J19,J25,J31,J37,J43,J49)","v":100.00000000000001}]
["5 Days",4000,null,null,null,null,"Plan A",0.14814814814814814,50,{"$f":"H15*I15","v":7.4074074074074066}]
[null,null,null,null,null,null,"Plan B",0.14814814814814814,65,{"$f":"H16*I16","v":9.6296296296296298}]
["Insurance Coverage",null,null,null,null,null,"Plan C",0.14814814814814814,75,{"$f":"H17*I17","v":11.111111111111111}]
["Options","Points",null,null,null,null,"Plan D",0.14814814814814814,85,{"$f":"H18*I18","v":12.592592592592592}]
["Plan A",0,null,null,null,null,"Plan E",0.14814814814814814,100,{"$f":"H19*I19","v":14.814814814814813}]
["Plan B",800,null,null,null,null,"Starting Date (11.1%)"]
["Plan C",1600,null,null,null,null,"2025-06-01",0.1111111111111111,50,{"$f":"H21*I21","v":5.5555555555555554}]
["Plan D",2400,null,null,null,null,"2025-06-15",0.1111111111111111,65,{"$f":"H22*I22","v":7.2222222222222214}]
["Plan E",3200,null,null,null,null,"2025-07-01",0.1111111111111111,75,{"$f":"H23*I23","v":8.3333333333333321}]
[null,null,null,null,null,null,"2025-07-15",0.1111111111111111,85,{"$f":"H24*I24","v":9.4444444444444446}]
["Starting Date",null,null,null,null,null,"2025-08-01",0.1111111111111111,100,{"$f":"H25*I25","v":11.111111111111111}]
["Options","Points",null,null,null,null,"Job Priorities (11.1%)"]
["2021-06-01",0,null,null,null,null,"Priority A",0.1111111111111111,50,{"$f":"H27*I27","v":5.5555555555555554}]
["2021-06-15",600,null,null,null,null,"Priority B",0.1111111111111111,65,{"$f":"H28*I28","v":7.2222222222222214}]
["2021-07-01",1200,null,null,null,null,"Priority C",0.1111111111111111,75,{"$f":"H29*I29","v":8.3333333333333321}]
["2021-07-15",1800,null,null,null,null,"Priority D",0.1111111111111111,85,{"$f":"H30*I30","v":9.4444444444444446}]
["2021-08-01",2400,null,null,null,null,"Priority E",0.1111111111111111,100,{"$f":"H31*I31","v":11.111111111111111}]
[null,null,null,null,null,null,"Bonus (7.4%)"]
["Job Assignment",null,null,null,null,null,0.1,7.407407407407407E-2,50,{"$f":"H33*I33","v":3.7037037037037033}]
["Options","Points",null,null,null,null,0.08,7.407407407407407E-2,65,{"$f":"H34*I34","v":4.8148148148148149}]
["Division E",-2400,null,null,null,null,0.06,7.407407407407407E-2,75,{"$f":"H35*I35","v":5.5555555555555554}]
["Division D",-1800,null,null,null,null,0.04,7.407407407407407E-2,85,{"$f":"H36*I36","v":6.2962962962962958}]
["Division C",-1200,null,null,null,null,0.02,7.407407407407407E-2,100,{"$f":"H37*I37","v":7.4074074074074066}]
["Division B",-600,null,null,null,null,"New Café Location (South Korea) (5.6%)"]
["Division A",0,null,null,null,null,"Itaewon, Seoul",5.5555555555555552E-2,50,{"$f":"H39*I39","v":2.7777777777777777}]
[null,null,null,null,null,null,"Gagnam, Seoul",5.5555555555555552E-2,65,{"$f":"H40*I40","v":3.6111111111111107}]
["Bonus",null,null,null,null,null,"Pyongtaek ",5.5555555555555552E-2,75,{"$f":"H41*I41","v":4.1666666666666661}]
["Options","Points",null,null,null,null,"Jeju Island",5.5555555555555552E-2,85,{"$f":"H42*I42","v":4.7222222222222223}]
[0.1,0,null,null,null,null,"Busan",5.5555555555555552E-2,100,{"$f":"H43*I43","v":5.5555555555555554}]
[0.08,400,null,null,null,null,"Moving Expenses (3.7%)"]
[0.06,800,null,null,null,null,1,3.7037037037037035E-2,50,{"$f":"H45*I45","v":1.8518518518518516}]
[0.04,1200,null,null,null,null,0.9,3.7037037037037035E-2,65,{"$f":"H46*I46","v":2.4074074074074074}]
[0.02,1600,null,null,null,null,0.8,3.7037037037037035E-2,75,{"$f":"H47*I47","v":2.7777777777777777}]
[null,null,null,null,null,null,0.7,3.7037037037037035E-2,85,{"$f":"H48*I48","v":3.1481481481481479}]
["Location",null,null,null,null,null,0.6,3.7037037037037035E-2,100,{"$f":"H49*I49","v":3.7037037037037033}]
["Options","Points"]
["New York",0]
["Boston",300]
["Chicago",600]
["Atlanta",900]
["San Francisco",1200]
[]
["Moving Expenses"]
["Options","Points"]
[1,0]
[0.9,200]
[0.8,400]
[0.7,600]
[0.6,800]

{"sheet":"Calculator","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Founder/Recruiter Points Calculator"]
["Category","Value","Points"]
["Salary",86000,{"$f":"VLOOKUP(B3,Reference!S:T,2,FALSE)","v":-3000}]
["Vacation Time","15 Days",{"$f":"VLOOKUP(B4,Reference!G:H,2,FALSE)","v":2000}]
["Insurance","Plan E",{"$f":"VLOOKUP(B5,Reference!P:Q,2,FALSE)","v":3200}]
["Job Priority","Priority E",{"$f":"VLOOKUP(B6,Reference!D:E,2,FALSE)","v":0}]
["Starting Date","2021-07-01",{"$f":"VLOOKUP(B7,Reference!J:K,2,FALSE)","v":1200}]
["Bonus",0.08,{"$f":"VLOOKUP(B8,Reference!A:B,2,FALSE)","v":400}]
["Location","Busan",{"$f":"VLOOKUP(B9,Reference!V:W,2,FALSE)","v":1200}]
["Moving Expense",1,{"$f":"VLOOKUP(B10,Reference!M:N,2,FALSE)","v":0}]
[null,"Current Deal",{"$f":"SUM(C3:C10)","v":5000}]
[]
[null,"Max Points",{"$f":"(Reference!W9)","v":13200}]
[null,"Bargaining Zone",{"$f":"C13-C11","v":8200}]

{"sheet":"Reference","index":6,"n_rows":9,"n_cols":23,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,18,0,19],[0,21,0,22],[0,0,0,1],[0,3,0,4],[0,6,0,7],[0,9,0,10],[0,12,0,13],[0,15,0,16]]}
["Bonus",null,null,"Job Priority",null,null,"Vacation Time",null,null,"Starting Date",null,null,"Moving Expenses",null,null,"Insurance Coverage",null,null,"Salary",null,null,"Café Location"]
["Options","Points",null,"Options","Points",null,"Options","Points",null,"Options","Points",null,"Options","Points",null,"Options","Points",null,"Options","Points",null,"Options","Points"]
[0.1,0,null,"Priority A",-2400,null,"25 Days",0,null,"2021-06-01",0,null,1,0,null,"Plan A",0,null,90000,-6000,null,"Itaewon, Seoul",0]
[0.08,400,null,"Priority B",-1800,null,"20 Days",1000,null,"2021-06-15",600,null,0.9,200,null,"Plan B",800,null,{"$f":"S3-2000","v":88000},-4500,null,"Gagnam, Seoul",300]
[0.06,800,null,"Priority C",-1200,null,"15 Days",2000,null,"2021-07-01",1200,null,0.8,400,null,"Plan C",1600,null,{"$f":"S4-2000","v":86000},-3000,null,"Pyongtaek ",600]
[0.04,1200,null,"Priority D",-600,null,"10 Days",3000,null,"2021-07-15",1800,null,0.7,600,null,"Plan D",2400,null,{"$f":"S5-2000","v":84000},-1500,null,"Jeju Island",900]
[0.02,1600,null,"Priority E",0,null,"5 Days",4000,null,"2021-08-01",2400,null,0.6,800,null,"Plan E",3200,null,{"$f":"S6-2000","v":82000},0,null,"Busan",1200]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Points",{"$f":"SUM(W7+T7+Q7+N7+K7+H7+E7+B7)","v":13200}]