AI Generation
Viete uses advanced AI to understand your natural language descriptions and transform them into professional Excel spreadsheets with formulas, formatting, and structure.
How AI Generation Works
When you describe what you need, the AI processes your request through several steps:
- Natural language understanding to interpret your requirements
- Intelligent structure planning for optimal spreadsheet organization
- Formula generation with appropriate functions and references
- Formatting application based on best practices and your preferences
- Data relationship mapping for multi-sheet workbooks
Writing Effective Prompts
The quality of your results depends on how well you describe what you need. Here are some tips for writing effective prompts:
Be Specific About Structure
Instead of "Create a budget spreadsheet", try:
"Create a monthly budget with income categories (salary, freelance, investments), expense categories (housing, utilities, food, transportation, entertainment), and a savings summary. Include monthly totals and a year-to-date column."
Describe Calculations
Be explicit about the calculations you need:
"Calculate the percentage variance between budget and actual spending. Show the running total of expenses and highlight cells where spending exceeds budget by more than 10%."
Request Visualizations
If you need charts or visual elements:
"Add a pie chart showing expense distribution by category and a line chart tracking monthly spending trends over the year."
AI Capabilities
The AI can generate a wide range of spreadsheet elements:
Formulas
SUM, AVERAGE, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF statements, nested formulas, and array formulas.
Formatting
Cell styles, colors, borders, number formats, conditional formatting, and data validation rules.
Charts
Bar charts, line graphs, pie charts, scatter plots, combo charts, and pivot charts.
Structure
Multiple sheets, named ranges, tables, pivot tables, and data relationships.
Best Practices
- Describe the purpose of your spreadsheet first
- List the main sections or sheets you need
- Specify column headers and data types
- Explain any specific formulas or calculations
- Mention formatting preferences (colors, fonts, styles)
- Request charts or visualizations if needed