This guide provides a step-by-step process for utilizing Google AI's Gemini 1.5 to quickly compare
Symbility HLX estimates with Xactimate estimates. It’s important to note that AI may not be able
to do our work for us, but it will make it easier for us to identify line item changes efficiently.
● Rename the document file accordingly; it should be “RF estimate” & “INS estimate”
1. Create a new prompt.
2. Upload both documents so that Gemini 1.5 can analyze them.
3. To enable Gemini to identify the line items in the estimates.
a. Add the prompt “Create a side-by-side comparison of both files. Outlining the
description and quantity in columns.”
4. If Gemini’s output still doesn’t show the proper columns for easy cross-referencing, try to
create a different prompt.
a. You can try using this prompt: “The columns should be INS estimate description,
quantity, RF estimate description, and quantity.”
5. Since this is an AI, it may miss some items in the estimates, as the initial prompt covers the
entirety of the documents. We have to check the categories in the estimate to identify which
one to cross-reference it with.
a. You can use this prompt to specify the category in the estimates: “Make a
side-by-side comparison of both files focusing on the roof plan/roof. Outlining the
description and quantity in columns.”
6. At this point, you should be able to identify the line items per estimate. Here’s the outcome
that we’re looking for: