Your Submission to Google Docs add-ons: PreAngel Captable Manager

Hello,

Thanks for submitting your add-on!

After reviewing your add-on, we think the idea is interesting and that it will be useful for users. There are a few improvements to the add-on’s functionality and design that we would like you to make before we can publish it.

Please find our review and comments on this Google Doc:

https://docs.google.com/document/d/1dspJEXY1XhVFgiynrjhH1T-########Au7_Jeenpm-7U/edit?usp=drivesdk

It contains our suggestions, as well as some resources for implementing these improvements. Feel free to make comments directly in the Google Doc (select any text > right click > select “comment”).

In your Developer’s Dashboard, your add-on’s status will now display as “Rejected”. This is a normal part of the process and not a reflection of the add-on’s eligibility. This status change will allow you to update and republish a new version of the add-on.

Once you have addressed all of the outstanding issues, please republish the updated version of the add-on. We appreciate your cooperation.

If you have any questions or comments, please contact us by replying to this email. We look forward to seeing your improvements!

Sincerely,

Ben The Google Docs Add-ons Team

DEVELOPER INFO DEVELOPER NAME OR COMPANY: DEVELOPER CONTACT EMAIL: zixia@zixia.net ADD-ON NAME: PreAngel Captable Manager PROTOTYPE LINK: DEVELOPER DESCRIPTION: PreAngel is a fund focus on the initial financing for Mobile Internet startups. It normally invests 10K to 20K USD in each deal for 2% - 5% of its equity. So the problem is: we have hundreds of portfolios to manage, that means we have to face hundreds of cap tables. How to manage the cap tables and summary them into one place easily? PreAngel Portfolio Captable Manager(PPCM) is born to do this. What this addon could do for you: 1. create a clean easy to use cap table template(sheet) for each portfolio. just fill it with the right numbers, and name the sheet to the portfolio name; 2. get a new custom function: PF(). PF() means Portfolio(), with 3 parameters: sheetName(portfolio name), properties(useful portfolio information, such as valuation of the last round), and round. This powerful custom function would help you summary portfolios cap table information very convenience. What this addon could NOT do for you: 1. It is not the right cap table for your CFO. PPCM is designed to summary many cap tables data to one table, and easy to update and manage. so it might leak of some detail information that seems not very important for us. 2. It could not run without google spreadsheet. also I don't know if google spreadsheets addon could support offline access. The best practice for me to use PPCM is: 1. create a new cap table sheet for every portfolio 2. create a sheet named "Portfolios", fill all portfolios' name(sheet name) to the first column. 3. use PF() function to show whatever you want to summary in the table. That's it. Hope it could be helpful to you.

ADD-ON FEEDBACK REVIEW Thank you for submitting your add-on for publication review. Your add-on has been examined by a Google Docs Add-on Advisor, who has compiled the following feedback for you.

This feedback outlines any significant technical or style issues we have discovered which prevent your add-on from providing the best possible user experience. These issues will need to be addressed before we can publish your add-on publicly in the store.

Each of these concerns must be addressed prior to the publication of your add-on, unless it is specifically marked as OPTIONAL. Please make comments directly in this Google Doc after implementing our suggestions. If you have questions about a specific issue, please place those questions in the comments of this document as well.

When you have addressed all the issues, let us know via email so we may continue the publication review.

FEEDBACK SUMMARY

We have divided the specific issues we found into one of these areas: 1) Technical Functionality 2) User Experience

1 TECHNICAL FUNCTIONALITY

I’m having some trouble using the Create Capitalization dialog: When I click ‘New Investor’ it automatically moves on to the next step. The user should have control over when they proceed. When I click ‘finish’ it returns an error message in a js alert and doesn’t complete. Unable to proceed. Please avoid using js alerts. Instead please display error messages either in dialogs or the sidebar (if it is already open).

2 USER EXPERIENCE

Post-install tip: Current: Open PreAngel Captable Manager from Add-ons, then you could create new captable by click "New capitalization table" “you could create” should probably be “you can create”. Also add a period at the end! A handful of issues with the Create… dialog: Consider using a sidebar instead of a dialog. There’s more vertical space there, which may make it easier. Currently displays a y-scrollbar when first opened, although there’s no apparent reason for it. There’s no method for completing step 1 - it just happens automatically. Please put this under user control. This currently prevents the user from adding more than 1 founder or removing any of the existing ones. Would be clearer to not display both steps in the same display. Would be nicer to put each step on its own page, so the user could focus on one at a time. The ‘money’ fields could be formated better. For example, could include a currency symbol and proper commas. Ie ‘90000’ → ‘$90,000’ Please improve the buttons: Labels should be verbs, to help communicate their actions. For example, instead of ‘New founder’, ‘Add founder’. ‘Finish’ can be more specific too, as it doesn’t provide information about the action it triggers. ‘Create Table’ perhaps? Please avoid displaying more than one colored button at a time. I’d recommend using default grey buttons for most actions, except the ones that proceed to the next step (‘finish’).

NEXT STEPS

Before we can publish your add-on, you will need to correct or otherwise address each of the issues outlined above. Make sure to make your changes to the prototype document that you shared when you submitted the add-on for review, so that the Add-on Advisor can see the results of your corrections. Also make sure you’ve checked all the items off of our Development Checklist, and that none of your recent changes breaks these guidelines. When all of the issues have been addressed, alert the Add-on Advisor reviewing your add-on. At that point, the Add-on Advisor will examine the effect of your changes.

Be aware that it is possible that there will be multiple rounds of review, as the Add-on Advisor locates additional issues in the add-on or new ones develop. Only when all the issues have been sufficiently addressed will the Add-on Advisor start the final publication procedure. This will involve an initial, contained publication and one last round of review. Once your add-on passes, it will be published to the world!

As the review process continues, you can help speed up the publication process by creating the following items (if you have not done so already):

1 POST-INSTALL TOOLTIP All published add-ons require a post-install tooltip. The post-install tooltip is a sentence or two that pops up immediately after a user installs an add-on; this text is meant to direct the user to the very first step they should take to use your add-on after installation. Refer to our UI Style Guide for more on what an effective tooltip looks like.

2 ADD-ON STORE OVERVIEW TEXT The Overview Text is displayed in the store, and is used to tell users what the add-on does and what problems it solves. This text should focus on the add-on; avoid talking at length about related services or the developer. It is important that this text be clear, accurate and concise -- otherwise users may not install or use your add-on at all.

3 GRAPHICAL ASSETS For publication, you’ll need at minimum 3 specific assets: a 128px × 128px icon, a 1280px × 800px screenshot, and a 440px x 280px tile image. These graphics are used in the web store to display and advertise your add-on, so make them look good! Refer to our asset guide at https://developers.google.com/apps-script/add-ons/style#in_the_store

In addition, you may want to consider producing a short YouTube video, which can be embedded in the web store listing.

See our branding guidelines for more information.

4 HELP WEB PAGES During publication, you can provide a URL that will be connected to the "Help" menu item for your add-on. A good add-on will have a well-designed, well-maintained web page describing its use and purpose in detail.

RESOURCES We have a number of resources to help you improve the code, the usability, and the overall quality of your add-on:

Google+ Community for Docs Add-ons Google+ Community for Google Apps Scripts Stack Overflow for Google Apps Scripts

Visit our Apps Scripts Support page for more information.

We look forward to seeing your improved add-on!

Comments (1)