{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["WORKSHEET","EXAMPLES"],"read":"whole","date_system":"1900"}

{"sheet":"WORKSHEET","index":0,"n_rows":20,"n_cols":7,"rows_kept":20,"merged":[[0,0,0,5],[13,3,17,5],[17,0,17,1],[18,0,18,1],[19,0,19,1]]}
["PMI Portland Chapter\nBASIC EVENT PRICING WORKSHEET",{"$nulls":5},"KEY:  "]
[{"$nulls":6},"Mandatory"]
["1.  DATES  (No Overlaps!)","Enter Info Here",null,null,"RESULTS - Do not edit this area",null,"Optional"]
["Date Range for EARLYBIRD Registration (optional)  Fill in #3",{"$nulls":5},"Optional"]
["Date Range for REGULAR Registration (REQUIRED)  Fill in #2",null,null,"Earlybird Period (optional)","Regular Period","Late Period (optional)","Do not enter here"]
["Date Range for LATE Registration (optional)  Fill in #4",null,null,{"$f":"IF(B4=\"\",\"NONE\",B4)","v":"NONE"},{"$f":"B5","v":0},{"$f":"IF(B6=\"\",\"NONE\",B6)","v":"NONE"}]
["2.  PRICING BY MEMBERSHIP TYPE (During REGULAR Reg period)",null,null,"Earlybird Pricing","Regular Pricing","Late Pricing"]
["Non-Members",null,null,{"$f":"IF($B$14=\"\",\"\",B8-$B$14)","v":""},{"$f":"B8","v":{"v":0,"d":"$0"}},{"$f":"IF($B$16=\"\",\"\",B8+$B$16)","v":""}]
["Chapter Members",null,null,{"$f":"IF($B$14=\"\",\"\",B9-$B$14)","v":""},{"$f":"B9","v":{"v":0,"d":"$0"}},{"$f":"IF($B$16=\"\",\"\",B9+$B$16)","v":""}]
["Chapter Student Members",null,null,"",{"v":0,"d":"$0"},""]
["Board (Board and VPs)",null,null,"",{"v":0,"d":"$0"},""]
["Directors (Asst VPs/Directors/Asst. Dirs)",null,null,"",{"v":0,"d":"$0"},""]
["3.  DISCOUNT DURING EARLYBIRD PERIOD (optional)"]
["EARLYBIRD - Enter one $ DISCOUNT from the price in #2 above.  Same discount applies to everyone.",null,null,"1.  Fill in all the Mandatory fields\n2.  Fill in the Green fields if you offer an Earlybird discount.\n3.  Fill in the Yellow fields if you charge a Late fee.\n4.  Review the Results area to be sure a) dates are correct and b) pricing is correct.\n5.  Fill out the online form using this information."]
["4.  FEE  DURING LATE PERIOD (optional)"]
["LATE - Enter one $ FEE added to the price in #2 above.  Same fee  applies to everyone. "]
[]
["This worksheet is designed to support the online Event  Registration/Payment Form as part of Chapter Event Setup.  \nhttp://pmi-portland.org/index.php?option=com_content&view=article&layout=edit&id=738  "]
["This worksheet is for your own use to be sure you have pricing set as needed, before filling out the Online form.  \n1.  Our system allows different pricing for these groups:  Non-members, Chapter Members, Chapter Student Members, Board and Directors.  You must provide a price for each group (can be same or different).   This is considered Regular pricing.\n2.  There are only 3 registration periods - regular (above), earlybird, and late.   We can apply one $discount during the earlybird pricing period and/or one $late fee during the late pricing period.  Both are optional.\n3.  The discount/late fees apply across the board to every group and cannot be different for different groups.  "]
["There are other ways to configure pricing besides the basics  (one fee based on membership type and date of registration).  We can add fees (or discounts) based on choices made during registration such as meal, parking pass, etc etc.  There are places in the Online form to indicate these.  "]

{"sheet":"EXAMPLES","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,0,0,5],[13,3,14,5],[30,3,31,5]]}
["PMI Portland Chapter\nBASIC EVENT PRICING WORKSHEET",{"$nulls":5},"KEY:  "]
[null,"EXAMPLE #1",{"$nulls":4},"Mandatory"]
["1.  DATES  (No Overlaps!)","Enter Info  Here",null,null,"RESULTS - Do not edit this area",null,"Optional"]
["Date Range for EARLYBIRD Registration (optional)  Fill in #3","APRIL 5 - May 1",{"$nulls":4},"Optional"]
["Date Range for REGULAR Registration (REQUIRED)  Fill in #2","May 2 - June 15",null,"Earlybird Period (optional)","Regular Period","Late Period (optional)","Do not enter here"]
["Date Range for LATE Registration (optional)  Fill in #4","June 16-June 20",null,{"$f":"IF(B4=\"\",\"NONE\",B4)","v":"APRIL 5 - May 1"},{"$f":"B5","v":"May 2 - June 15"},{"$f":"IF(B6=\"\",\"NONE\",B6)","v":"June 16-June 20"}]
["2.  PRICING BY MEMBERSHIP TYPE (During REGULAR Reg period)",null,null,"Earlybird Pricing","Regular Pricing","Late Pricing"]
["Non-Members",{"v":500,"d":"$500"},null,{"$f":"IF($B$14=\"\",\"\",B8-$B$14)","v":{"v":450,"d":"$450"}},{"$f":"B8","v":{"v":500,"d":"$500"}},{"$f":"IF($B$16=\"\",\"\",B8+$B$16)","v":{"v":575,"d":"$575"}}]
["Chapter Members",{"v":400,"d":"$400"},null,{"$f":"IF($B$14=\"\",\"\",B9-$B$14)","v":{"v":350,"d":"$350"}},{"$f":"B9","v":{"v":400,"d":"$400"}},{"$f":"IF($B$16=\"\",\"\",B9+$B$16)","v":{"v":475,"d":"$475"}}]
["Chapter Student Members",{"v":200,"d":"$200"},null,{"v":150,"d":"$150"},{"v":200,"d":"$200"},{"v":275,"d":"$275"}]
["Board (Board and VPs)",{"v":100,"d":"$100"},null,{"v":50,"d":"$50"},{"v":100,"d":"$100"},{"v":175,"d":"$175"}]
["Directors (Asst VPs/Directors/Asst. Dirs)",{"v":400,"d":"$400"},null,{"v":350,"d":"$350"},{"v":400,"d":"$400"},{"v":475,"d":"$475"}]
["3.  DISCOUNT DURING EARLYBIRD PERIOD (optional)"]
["EARLYBIRD - Enter one $ DISCOUNT from the price in #2 above.  Same discount applies to everyone.",{"v":50,"d":"$50"},null,"Early, regular and late pricing for this event.\nRegistration opens April 5 and closes June 20.\n"]
["4.  FEE  DURING LATE PERIOD (optional)"]
["LATE - Enter one $ FEE added to the price in #2 above.  Same fee  applies to everyone. ",{"v":75,"d":"$75"}]
[]
[]
[null,"EXAMPLE #2"]
["1.  DATES  (No Overlaps!)","Enter Info Here",null,null,"RESULTS - Do not edit this area"]
["Date Range for EARLYBIRD Registration (optional)  Fill in #3","12/15/16 - 1/31/17"]
["Date Range for REGULAR Registration (REQUIRED)  Fill in #2","Feb 1 - March 5",null,"Earlybird Period (optional)","Regular Period","Late Period (optional)"]
["Date Range for LATE Registration (optional)  Fill in #4",null,null,{"$f":"IF(B21=\"\",\"NONE\",B21)","v":"12/15/16 - 1/31/17"},{"$f":"B22","v":"Feb 1 - March 5"},{"$f":"IF(B23=\"\",\"NONE\",B23)","v":"NONE"}]
["2.  PRICING BY MEMBERSHIP TYPE (During REGULAR Reg period)",null,null,"Earlybird Pricing","Regular Pricing","Late Pricing"]
["Non-Members",{"v":350,"d":"$350"},null,{"$f":"IF($B$31=\"\",\"\",B25-$B$31)","v":{"v":230,"d":"$230"}},{"$f":"B25","v":{"v":350,"d":"$350"}},{"$f":"IF($B$33=\"\",\"\",B25+$B$33)","v":""}]
["Chapter Members",{"v":189,"d":"$189"},null,{"$f":"IF($B$31=\"\",\"\",B26-$B$31)","v":{"v":69,"d":"$69"}},{"$f":"B26","v":{"v":189,"d":"$189"}},{"$f":"IF($B$33=\"\",\"\",B26+$B$33)","v":""}]
["Chapter Student Members",{"v":456,"d":"$456"},null,{"v":336,"d":"$336"},{"v":456,"d":"$456"},""]
["Board (Board and VPs)",{"v":220,"d":"$220"},null,{"v":100,"d":"$100"},{"v":220,"d":"$220"},""]
["Directors (Asst VPs/Directors/Asst. Dirs)",{"v":175,"d":"$175"},null,{"v":55,"d":"$55"},{"v":175,"d":"$175"},""]
["3.  DISCOUNT DURING EARLYBIRD PERIOD (optional)"]
["EARLYBIRD - Enter one $ DISCOUNT from the price in #2 above.  Same discount applies to everyone.",{"v":120,"d":"$120"},null,"Early and Regular pricing only.\nRegistration opens Dec 15 and closes march 5.\n"]
["4.  FEE  DURING LATE PERIOD (optional)"]
["LATE - Enter one $ FEE added to the price in #2 above.  Same fee  applies to everyone. "]