tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139911d1328542835-ongoing-time-sheet-problem-book1
Sheet: Site 1

 |  |  |  |  |  |  |  |  |  | Pay Period: Jan 29th - Feb 11th, 2012 |  |  |  |  |  |  |  |  |  |  | Date
EMP# | NAME | Su | Mo | [NAME] | We | Th | Fr | Sa | REG HRS | OT HRS | UNWRK STAT HRS | TOT WKLY HRS | Su | Mo | [NAME] | We | Th | Fr | Sa | REG HRS | OT HRS | UNWRK STAT HRS | TOT WKLY HRS | TOT BIWKLY HRS |  | Site 1 |  | 1900-01-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-08 00:00:00
 |  | 1900-01-29 00:00:00 | 1900-01-30 00:00:00 | 1900-01-31 00:00:00 | 1900-02-01 00:00:00 | 1900-02-02 00:00:00 | 1900-02-03 00:00:00 | 1900-02-04 00:00:00 |  |  |  |  | 1900-02-05 00:00:00 | 1900-02-06 00:00:00 | 1900-02-07 00:00:00 | 1900-02-08 00:00:00 | 1900-02-09 00:00:00 | 1900-02-10 00:00:00 | 1900-02-11 00:00:00 |  |  |  |  |  |  | Anywhere Street, Somewhere City |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | M | T | W | T | F | S | Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | M | T | W | T | F | S | Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Employee 1 | 19:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Employee 1 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Employee 2 | 13:00:00 | 19:00:00 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Employee 2 |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 00:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 00:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Employee 3 |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 23:59:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00 | 23:59:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Employee 4 | 00:01:00 | 13:00:00 |  |  |  |  |  |  |  |  |  |  | 00:30:00 | 09:00:00 |  |  |  |  |  |  |  |  |  | 00:01:00 | 13:00:00 |  |  |  |  |  |  |  |  |  |  | 00:30:00 | 09:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Employee 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 | 19:00:00
Spreadsheet: 862063d1709842326-subtract-a-certain-number-when-a-certain-box-is-ticked-in-a-cell-online-accountability
Sheet: Data

 | Cultivars | Team Lead | Event | Grow Room | Location
 | Black Jelly | [NAME] | Pinch | 1 | Single Room
 | [NAME] | [NAME] | 1st Touch | 2 | DD - Upstairs
 | Cosmic Cream | [NAME] | 2nd Touch | 3 | DD - Downstairs
 | [NAME] | Lilia | 3rd Touch | 4
 | Equiposa | Sadie | 4th Touch | 5
 | Farm Gas | Derek | Final Defol | 6
 | [NAME] | [NAME] |  | 7
 | LA Confidential | Colton |  | 8
 | Luminarium | MPIC |  | 9
 | Pink Diesel '71 | N/A |  | 10
 | Placeholder |  |  | 11
 | Ponderosa Pine |  |  | 12
 | Rex |  |  | 13
 | Sedamen |  |  | 14
 | Sourdough |  |  | 15
 | Stellio |  |  | 16
 | Valour |  |  | 17
 | [NAME]
 | OC23T382
 | OC23T344
 | OC23T787
 | OC23T418
 | OC23T549
Spreadsheet: 716408d1612197650-sum-values-with-criteria-sample
Sheet: PAYDAY 31st Aug

Week: | Hours: | Pay: | Notes: |  |  | Break Down: |  |  |  |  |  |  | WEEKLY PAY: | DAILY PAY: | HOURLY:
BASIC: |  | 2000
ADDITION: |  | 183 |  |  |  | Natwest:
OTHER BONUS: |  | 250.67 |  |  |  | Entertainment:
 |  |  |  |  |  | Car:
[NAME]: |  | 0 |  |  |  | Loan:
 |  |  |  |  |  | Phone:
Est Tax: |  |  |  |  |  | Credit Improver:
Est NI: |  |  |  |  |  | Rent:
Total: |  |  |  |  |  | Credit Card:
 |  |  |  |  |  | Total:
Total Est Pay Before Tax:
Total Est Pay After Tax: |  |  |  |  |  | Monzo:
Actual Pay: |  | 1767.06 |  |  |  | Predicted: |  |  | Actual:
 |  |  |  |  |  | Amount L/O |  |  | Amount L/O
Deductions: |  |  |  |  |  | Days till next pay | 28 |  | Days till next pay | 28
Rent |  | 120 |  |  |  | Budget |  |  | Budget
Fuel |  | 160
Car Insurance |  | 181.68
Phone |  | 15
Loan |  | 130.08
ISA
Credit Improver |  | 12
OVERDRAFT |  | 402.03
Other
CAR TAX |  | 160
Budget: |  | 320 |  |  |  | NI Calculator:
Total: |  |  |  |  |  | PA: | 793.03
 |  |  |  |  |  | BT - PA:
Total Est Left On 31st Aug:
Total Acc Left On 31st Aug: |  |  |  |  |  | Total:
 |  |  |  |  |  | Tax Calculator:
 |  |  |  |  |  | PA: | 954.18
 |  |  |  |  |  | BT - PA:
 |  |  |  |  |  | Est Tax:
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: 4

 | Oct 19 |  | Oct 26 |  | Nov 2 |  | Nov 9
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated net notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, cleared and uncleared.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 705606d1606221028-match-value-in-text-string-to-list-and-return-result-based-on-date-sample-data
Sheet: Sheet1

Names | Dates | Score |  |  |  | Students | 2020-11-11 00:00:00 | 2020-11-12 00:00:00 | 2020-11-13 00:00:00
[NAME], [NAME], Polly Planter | 2020-11-11 00:00:00 | 90 |  |  |  | [NAME]
[NAME],Polly Planter | 2020-11-12 00:00:00 | 95 |  |  |  | [NAME]
[NAME] | 2020-11-13 00:00:00 | 100 |  |  |  | Polly Planter
Spreadsheet: b876e504-718b-4b1b-9d5e-76f385871e44
Sheet: TTM Recon Q3FY12

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended December 31, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Amortization of debt discount |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Licensed Intellectual Property Commitment (COGS) |  | Gain on Strategic Investments |  | Restructuring and other |  | Stock-based compensation |  | Income tax adjustments |  | Non-GAAP Results
Net revenue | 3865 |  | 0 |  | 0 |  | 339 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4204
Cost of revenue | 1552 |  | -28 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -1 |  | 0 |  | 1523
Gross profit | 2313 |  | 28 |  | 0 |  | 339 |  | 0 |  | 0 |  | 0 |  | 1 |  | 0 |  | 2681
Operating expenses:
Marketing and sales | 825 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -23 |  | 0 |  | 802
General and administrative | 335 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -37 |  | 0 |  | 298
Research and development | 1256 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -106 |  | 0 |  | 1150
Acquisition-related contingent consideration | 16 |  | -16 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 50 |  | -50 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 16 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -16 |  | 0 |  | 0 |  | 0
Total operating expenses | 2498 |  | -66 |  | 0 |  | 0 |  | 0 |  | 0 |  | -16 |  | -166 |  | 0 |  | 2250
Operating income (loss) | -185 |  | 94 |  | 0 |  | 339 |  | 0 |  | 0 |  | 16 |  | 167 |  | 0 |  | 431
 | 2498 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Gain on strategic investments | -185 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0.92
Interest and other income (expense), net | -9 |  | 0 |  | 9 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Income (loss) before provision for (benefit from) income taxes | -194 |  | 94 |  | 9 |  | 339 |  | 0 |  | 0 |  | 16 |  | 167 |  | 0 |  | 431
Provision for (benefit from) income taxes | -21 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 141 |  | 120
Net income (loss) | -173 |  | 94 |  | 9 |  | 339 |  | 0 |  | 0 |  | 16 |  | 167 |  | -141 |  | 311
Spreadsheet: 705199d1605915545-convert-time-series-ohlc-data-frequency-from-daily-to-weekly-ohlc-data
Sheet: Daily

Date | Open | High | Low | Close | Volume | OI | Weekday | Week | Year
2014-11-30 00:00:00 | 376.57 | 381.99 | 373.32 | 373.34 | 1145566.61 | 0
2014-12-01 00:00:00 | 376.4 | 382.31 | 373.03 | 378.39 | 2520662.37 | 0
2014-12-02 00:00:00 | 378.39 | 382.86 | 375.23 | 379.25 | 2593576.46 | 0
2014-12-03 00:00:00 | 379.25 | 383 | 374.23 | 376.67 | 2998357.92 | 0
2014-12-04 00:00:00 | 376.67 | 378.99 | 360.01 | 365.2 | 3297896.46 | 0
2014-12-05 00:00:00 | 365.2 | 377.89 | 363.99 | 374.95 | 3331762.49 | 0
2014-12-06 00:00:00 | 374.95 | 376.99 | 371.31 | 375.07 | 861748.71 | 0
2015-11-29 00:00:00 | 356.78 | 373.15 | 354.45 | 371.04 | 2798580.83 | 0
2015-11-30 00:00:00 | 371.48 | 383 | 367.11 | 377.98 | 6688039.27 | 0
2015-12-01 00:00:00 | 376.7 | 379 | 354.56 | 362.95 | 5610058.11 | 0
2015-12-02 00:00:00 | 363.06 | 363.06 | 348.64 | 359.97 | 4282488.25 | 0
2015-12-03 00:00:00 | 359.11 | 370.53 | 356.21 | 361.32 | 4394915.48 | 0
2015-12-04 00:00:00 | 361.48 | 364.3 | 355.92 | 362.3 | 3573289.38 | 0
2015-12-05 00:00:00 | 363.62 | 389.89 | 363 | 384.67 | 6173704.59 | 0
Spreadsheet: 859915d1708128519-multi-return-lookup-from-2d-array-2d-multi-return-lookup
Sheet: Sheet1

Fruit |  | Part of which combos?
Apple |  | Red bounty | Orange treats
[NAME] |  | Yellow bonanza
Jujubees |  | Red bounty | Yellow bonanza | Orange treats
Blueberries |  | ^A formula that looks up a fruit in the "combo ingredients" array and returns all Combos which have that Fruit.
Peach
[NAME]
Tomato
Lemon
Orange
Combos |  | Combo ingredients
Red bounty |  | Apple | Tomato | Jujubees | [NAME]
Yellow bonanza |  | [NAME] | Jujubees | Lemon
Orange treats |  | Apple | Peach | Orange | Jujubees
Spreadsheet: 874523d1721122829-paste-a-text-file-in-excel-to-draw-totals-to-correct-place-and-category-lourika-work-sheet-pq-aligw
Sheet: Merge1

Region | Code | Price | Region All
NORTH | FC1011 | 12
 | FC1021 | 50
 | FC1031 | 33
 | FC1041 | 0
 | NC1051 | 360
 | VC1061 | 4
 | VC1071 | 39
 | 0001 | 220
 | 0002 | 99
 | 110003 | 72
 | 120004 | 54
NORTH WEST | FC1011 | 109
 | FC1021 | 760
 | FC1031 | 20
 | FC1041 | 300
 | NC1051 | 129
 | VC1061 | 256
 | VC1071 | 56
 | 0001 | 156
 | 0002 | 61
 | 110003 | 79
 | 120004 | 90
SOUTH | FC1011 | 126
SOUTH | FC1011 | 49
 | FC1021 | 58
 | FC1031 | 81
 | FC1041 | 98
 | NC1051 | 165
 | VC1061 | 40
 | VC1071 | 78
 | 0001 | 235
 | 0002 | 52
 | 110003 | 72
 | 120004 | 0
SOUTH WEST | FC1011 | 91
 | FC1021 | 68
 | FC1031 | 125
 | FC1041 | 59
 | NC1051 | 44
 | VC1061 | 75
 | VC1071 | 45
 | 0001 | 63
 | 0002 | 90
 | 110003 | 100
 | 120004 | 120
SOUTH SOUTH WEST | FC1011 | 14
 | FC1021 | 120
SOUTH SOUTH WEST | FC1031 | 63
 | FC1041 | 0
 | NC1051 | 190
 | VC1061 | 61
 | VC1071 | 90
 | 0001 | 0
 | 0002 | 45
 | 110003 | 106
 | 120004 | 123
Spreadsheet: 167180d1341922736-selection-from-dropdown-to-generate-new-table-information-donations
Sheet: School Sponsorship

School Sponsorship
First | Last | Street | City | State | Zip | Amount | Paypal Fee | Total Donation | Date | Type | Check # | Fund | [NAME]
Youth Ministries | Church | Z | Z | Z | 30022 | 500 |  | 500 | 2012-01-04 00:00:00 | Check | 984 | School Sponsorship | [EMAIL]
[NAME] | Hadsell | A | A | A | 30062 | 150 |  | 150 | 2012-01-04 00:00:00 | Paypal |  | School Sponsorship
[NAME] | Day | K | K | K | 31525 | 50 |  | 50 | 2012-03-26 00:00:00 | Check | 5077 | School Sponsorship
[NAME] | [NAME] | M | M | M | 30062 | 1000 |  | 1000 | 2012-04-09 00:00:00 | Check |  | School Sponsorship
 |  |  |  |  |  | 1700 | 0 | 1700
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: C8

Local 8
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-09 00:00:00
[NAME]: | 10
Réservé:
Prix: | 100
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 668307d1584728409-extracting-a-list-of-unfulfilled-orders-for-the-week-example
Sheet: All Orders

Order Number | Required | Shop
1 | 2020-03-01 00:00:00 | Yellow
2 | 2020-03-05 00:00:00 | Blue
3 | 2020-03-12 00:00:00 | Green
4 | 2020-03-15 00:00:00 | Red
5 | 2020-03-16 00:00:00 | Yellow
6 | 2020-03-17 00:00:00 | Blue
7 | 2020-03-18 00:00:00 | Green
11 | 2020-03-17 00:00:00 | Red
9 | 2020-03-20 00:00:00 | Yellow
10 | 2020-03-19 00:00:00 | Blue
8 | 2020-03-22 00:00:00 | Green
17 | 2020-03-23 00:00:00 | Red
13 | 2020-03-25 00:00:00 | Yellow
14 | 2020-03-26 00:00:00 | Blue
15 | 2020-03-19 00:00:00 | Green
16 | 2020-03-30 00:00:00 | Red
12 | 2020-03-05 00:00:00 | Blue
18 | 2020-03-16 00:00:00 | Green
19 | 2020-03-17 00:00:00 | Red
20 | 2020-03-18 00:00:00 | Green
Spreadsheet: 127243d1320251897-count-values-in-a-range-that-appear-for-specific-dates-test-sheet
Sheet: Sheet1

Data Collation
 |  | [NAME] |  | Area2 |  | Area3 |  | Area4 |  | Area5 |  | Area6 |  | Area7
 |  | No. | Hours | No. | Hours | No. | Hours | No. | Hours | No. | Hours | No. | Hours | No. | Hours
Yesterday
Now
Expected
Spreadsheet: 144900d1331200948-changing-an-exsisting-chart-to-percentages-example1
Sheet: Sheet2

5. I know what is expected of me at work
Agree
Agree
Agree
Agree |  | Row Labels | Count of 5. I know what is expected of me at work
Strongly Agree |  | Strongly Agree | 19
Agree |  | Agree | 18
Agree |  | (blank)
Strongly Agree |  | Grand Total | 37
Agree
Agree
Strongly Agree
Strongly Agree
Agree
Agree
Agree
Agree
Strongly Agree
Strongly Agree
Strongly Agree
Strongly Agree
Strongly Agree
Agree
Strongly Agree
Agree
Strongly Agree
Strongly Agree
Strongly Agree |  | Example 1
Strongly Agree
Strongly Agree
Strongly Agree
Agree
Strongly Agree
Agree
Agree
Strongly Agree
Agree
Strongly Agree
Spreadsheet: 594772d1539960276-extracting-data-to-a-new-sheet-based-on-dates-test
Sheet: ICiMS Flow

 |  |  | Grounds attendant |  |  | bell attendant |  |  | character |  |  | concierge |  |  | team lead |  |  | supervisor |  |  | area supervisor |  |  | operations supervisor
 | 2019 |  | Apps | New Apps |  | Apps | New Apps |  | Apps | New Apps |  | Apps | New Apps |  | Apps | New Apps |  | Apps | New Apps |  | Apps | New Apps |  | Apps | New Apps
 | 2018-10-12 00:00:00 |  | 23 | 12
 |  |  | 25 | 22
 |  |  | 2 | 1
 |  |  | 4 | 2
 |  |  | 5 | 2
 |  |  | 3 | 3
 |  |  | 4 | 4
 |  |  | 6 | 2
 |  |  | 10 | 1
Spreadsheet: 731334d1620296478-find-the-correct-row-find-the-relevant-rows
Sheet: Renewal

Customer | [NAME] | Premium | Turnover | Vlookup premium | [NAME] turnover
Customer 1 | 2020-12-31 00:00:00 | 15000 | 85000000
Customer 1 | 2019-12-31 00:00:00 | 15000 | 85000000
Customer 1 | 2021-12-31 00:00:00 | 15000 | 85000000
Customer 2 | 2020-12-31 00:00:00 | 857321.9999999999 | 34709400000
Customer 2 | 2018-12-31 00:00:00 | 800000 | 31187900000
Customer 2 | 2019-12-31 00:00:00 | 800000 | 32438000000
Customer 2 | 2021-12-31 00:00:00 | 867000 | 19 320 500 000
Customer 3 | 2020-12-31 00:00:00 | 15000 | 75000000
Customer 3 | 2021-12-31 00:00:00 | 15000 | 75000000
Customer 4 | 2020-12-31 00:00:00 | 32000 | 160000000
Customer 4 | 2019-12-31 00:00:00 | 25600 | 115000000
Customer 4 | 2021-12-31 00:00:00 | 23000 | 128000000
Customer 5 | 2020-12-31 00:00:00 | 34908 | 120000000
Customer 5 | 2019-12-31 00:00:00 | 32000 | 110000000
Customer 5 | 2021-12-31 00:00:00 | 33455 | 115000000
Customer 6 | 2020-12-31 00:00:00 | 5000 | 15000000
Customer 6 | 2021-12-31 00:00:00 | 5000 | 18000000
Customer 7 | 2021-02-28 00:00:00 | 8000 | 30000000
Customer 7 | 2020-02-29 00:00:00 | 8000 | 165000000
Customer 8 | 2019-10-31 00:00:00 | 7499.999999999999 | 165000000
Customer 9 | 2021-09-01 00:00:00 | 39000 | 30000000
Customer 10 | 2020-11-30 00:00:00 | 20000 | 30000000
Customer 10 | 2021-11-30 00:00:00 | 20000 | 30000000
Customer 11 | 2018-12-31 00:00:00 | 13315.06849315068 | 20000000
Customer 11 | 2019-12-31 00:00:00 | 20700 | 135000000
Customer 11 | 2020-12-31 00:00:00 | 20700 | 135000000
Customer 11 | 2021-12-31 00:00:00 | 13800 | 135000000
Spreadsheet: 167720d1342077911-cut-and-paste-calculation-example-excel-file
Sheet: Ingredient

compoundID | Ingredient name | amount
1 | Ingredient #1 | 25gm
1 | Ingredient #2 | 10gm
1 | Ingredient #3 | 30gm
2 | Ingredient #4 | 50gm
2 | Ingredient #5 | 100gm
3 | Ingredient #6 | 20gm
3 | Ingredient #7 | 35gm
3 | Ingredient #8 | 40gm
3 | Ingredient #9 | 70gm
Spreadsheet: benjamin_rogers__1192__test model from Erin
Sheet: ENA-144A Comparison

50 MW Block NOT Taken OutNo ENA Fees Taken Out
 |  | ENA | Non-Investment Grade
Term
Treasury Rate |  |  | 0.065
Spread Over Treasuries
Interest Rate
Financing Fee
Average Life
FCF NPV@ | 0.12
Equity IRR
Spreadsheet: 147923d1333036413-pull-in-a-number-based-on-an-answer-that-falls-in-different-ranges-pull-in-a-number
Sheet: Sheet1

Hourly rate | 90 |  |  |  |  |  |  | 25
Mileage | 43.9 |  |  |  |  |  |  | 75
Speed | 48.5 |  |  |  |  |  |  | 197
L/D time | 0.75 |  |  |  |  |  |  |  |  | 4
T & T |  | 50
Quantity | 50
Toll rate | -
Per unit rate |  | 4.61
Load rate |  | 230.43 | b6xb8
Material cost | 10
Profit | 1.5
Tax rate | 7.75
Price per unit |  | 16.11 | $
Sub total |  | 805.43 | $ | 13x5
Grandtotal |  | 867.85 | $
Split total |  | 808.18 | $
COD 26.5 ton |  | 459.96 | $
Spreadsheet: 708349d1607746897-help-calculating-figures-using-multiple-arguments-summing-filtered-columns-tdfrench-
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2020-12-08 00:00:00 | 2020-12-09 00:00:00 | 2020-12-10 00:00:00 | 2020-12-11 00:00:00 | 2020-12-12 00:00:00 | 2020-12-13 00:00:00 | 2020-12-14 00:00:00 | 2020-12-15 00:00:00 | 2020-12-16 00:00:00 | 2020-12-17 00:00:00
 |  |  |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday
 | Helper | Code |  | Rev | Cost
 |  | 1 |  | 10 | 5 |  |  | 1 | 2 |  |  | 6 | 6 | 6
 |  | 2 |  | 10 | 5 |  |  |  | 3 |  |  |  |  | 5
 |  | 1 |  | 10 | 5 |  |  |  | 4 | 5 | 5
 |  | 2 |  | 10 | 5 |  |  |  |  |  | 6 |  |  |  | 4 |  | 4
 |  | 1 |  | 10 | 5 |  |  |  | 3 | 3 | 3
 |  | 2 |  | 10 | 5 |  |  |  | 3
 |  | 1 |  | 10 | 5 |  |  | 2 | 3
 |  | 2 |  | 10 | 5 |  |  |  |  | 3
 |  | 1 |  | 10 | 5 |  |  |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 3
 |  | 2 |  | 10 | 5 |  |  |  |  |  |  |  |  | 3 | 3 | 3
 |  | 1 |  | 10 | 5 |  |  |  | 6 | 6 | 5 | 4 | 4 | 3
 |  |  |  |  |  |  | Rev
 |  |  |  |  |  |  | Cost
 |  |  |  |  |  | Opt 2 | Rev
 |  |  |  |  |  |  | Cost
Spreadsheet: 744044d1628876862-lookup-data-with-3-criteria-one-of-them-in-merged-cell-lookup-report
Sheet: Report

 | Area 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Area 3
 | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 8 | Material 9 | Material 10 | Material 11 | Material 12 | Material 13 | Material 14 | Material 15 | Material 16 | Total |  | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 8 | Material 9 | Material 10 | Material 11 | Material 12 | Material 13 | Material 14 | Material 15 | Material 16 | Total |  | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 8 | Material 9 | Material 10 | Material 11 | Material 12 | Material 13 | Material 14 | Material 15 | Material 16 | Total
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Spreadsheet: 170759d1343395905-excel-2007-conditional-formatting-request-for-help-test
Sheet: Daily Deposits

STORE # | 101
90006
DATE | ENVELOPE RECEIVED ON
Prior Month | 2012-07-19 00:00:00
2012-07-01 00:00:00 | 2012-07-19 00:00:00
2012-07-02 00:00:00 | 2012-07-19 00:00:00
2012-07-03 00:00:00 | 2012-07-19 00:00:00
2012-07-04 00:00:00
2012-07-05 00:00:00 | 2012-07-19 00:00:00
2012-07-06 00:00:00 | 2012-07-19 00:00:00
2012-07-07 00:00:00 | 2012-07-19 00:00:00
2012-07-08 00:00:00 | 2012-07-19 00:00:00
2012-07-09 00:00:00 | 2012-07-19 00:00:00
2012-07-10 00:00:00 | 2012-07-19 00:00:00
2012-07-11 00:00:00 | 2012-07-19 00:00:00
2012-07-12 00:00:00 | 2012-07-19 00:00:00
2012-07-13 00:00:00
2012-07-14 00:00:00
2012-07-15 00:00:00
2012-07-16 00:00:00
2012-07-17 00:00:00 | 2012-07-27 00:00:00
2012-07-18 00:00:00 | 2012-07-27 00:00:00
2012-07-19 00:00:00 | 2012-07-27 00:00:00
2012-07-20 00:00:00
2012-07-21 00:00:00
2012-07-22 00:00:00
2012-07-23 00:00:00
2012-07-24 00:00:00
2012-07-25 00:00:00
2012-07-26 00:00:00
2012-07-27 00:00:00
2012-07-28 00:00:00
2012-07-29 00:00:00
2012-07-30 00:00:00
2012-07-31 00:00:00
Unknown Variance
STORE # | 101
 | Capital One Bank Statement
 | [NAME]
 | Deposits
RMS Sales Amount | 11275.91
Capital One Bk Stmnt | 11557.03
[NAME] | -281.1199999999972
Deposits in Transit | 510.23
Current Over/Short | -8.1099999999999
Prior Over/Short | 0
Total Over/Short | -8.1099999999999