From
Mr. SharePoint, LLC
Ryan Clark
6457 S. Kimbark Ave
Unit 1S
Chicago, IL 60637
US
To
Lindemann Miller LLP
233 S Wacker Dr.
Suite 8400
Chicago, IL 60606
US
Date
February 12, 2021
Estimate Number
12227
Expiration Date
March 14, 2021
Estimate Total
$8,280.00
  1. Task
    Rate
    Qty
    Amount

    Bucket of hours for current discovery and planning. This time will be needed to look at Relativity and the provided xml data export and file export in closer detail.

    $115
    6
    $690
  2. Create a SharePoint Online site collection to store migrated and future content. Also, I will need to create a document library for Acorn files to be moved to during this project as well as add/configure the ~35 required metadata columns (will be provided by the client).

    $115
    6
    $690
  3. Upload Acorn files (~30GB) into SharePoint Online. This data will be provided by the client, which I can migrate at about 4GB per hour.

    $115
    8
    $920
  4. Based on the data discovery, I will create a Power Automate process that can take in an XML file provided by Relativity and then loop within the documents in the Acorn document library and populate the metadata according to the XML file. Each file has an ID (primary key) that will be used to find the correct file in the Acorn document library within each loop iteration. I will need to manipulate and format the XML file to work with Power Automate.

    This workflow can be slightly modified to work with future data imports from Relativity to SharePoint Online.

    $115
    40
    $4,600
  5. Create written documentation and a video recording that explains the solution in a way that someone else could re-use this automation for future imports.

    Written documentation: 3 hours
    Video recording: 1 hour

    $115
    4
    $460
  6. Bucket of time for testing, troubleshooting, training, and initial support.

    $115
    8
    $920
Subtotal $8,280.00
Total $8,280.00

Notes

This project will take ~2 weeks to finish from the official date the project has started.

Terms

We do expect payment within 30 days, so please be sure to process payment within that timeframe. There will be a 1.5% interest charge per month on late invoices.

Status Update
February 12, 2021 @ 3:48 pm

Status changed: Draft to Pending.

Updated
February 12, 2021 @ 3:50 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:50 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:51 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:51 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:51 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:51 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:52 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:52 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:53 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:53 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:55 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:55 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:55 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:55 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:57 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:57 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:58 pm

Estimate updated by Ryan.

Updated
February 12, 2021 @ 3:58 pm

Estimate updated by Ryan.

Updated
February 18, 2021 @ 12:18 pm

Estimate updated by Ryan.

Updated
February 18, 2021 @ 12:18 pm

Estimate updated by Ryan.