Generate interactive revenue projection tables with Gemini 3 Pro | Alpha | PandaiTech

Generate interactive revenue projection tables with Gemini 3 Pro

Creating an interactive financial table for revenue projections and using the 'Ask Gemini' feature to generate a CFO report and scenarios.

Learning Timeline
Key Insights

Verification of AI Math

While Gemini 3 Pro performed the calculations correctly in this instance, it is best practice to cross-reference AI-generated financial math with a spreadsheet or a second AI tool to ensure accuracy.

Utilizing Suggested Features

Use the 'Ask Gemini' button or feature suggestions. The AI often generates useful follow-up actions (like 'Generate CFO Report') that are not explicitly requested in the initial prompt.
Prompts

Revenue Projection Prompt

Target: Gemini
Create an interactive table to show 24 month revenue projections based on some simple assumptions.

Formatting Correction Prompt

Target: Gemini Chat Sidebar
Fix the formatting of this function.
Step by Step

Generating Interactive Revenue Tables

  1. Enter a prompt requesting a '24-month revenue projection based on simple assumptions' into the main text input field.
  2. Submit the prompt to generate the initial table.
  3. Verify interactivity by clicking on the assumption cells and modifying the values to see live updates in the projection.
  4. Locate and click the 'Ask Gemini' feature button (often represented by a sparkle icon or specific button near the artifact).
  5. Select the suggested example prompt provided within the 'Ask Gemini' menu (or copy-paste the suggestion to create a business model scenario).
  6. Click the newly generated 'Generate CFO report' option/button that appears in the interface.
  7. Review the generated report for formatting consistency.

Troubleshooting Formatting via Chat

  1. Identify specific sections in the generated report where text or function formatting is broken.
  2. Navigate to the chat interface located on the left side of the screen.
  3. Type a correction command targeting the specific issue (e.g., 'Fix the formatting of this function').
  4. Submit the command to have the AI regenerate the artifact with corrected formatting.

More from Boost Productivity & Research with AI

View All