tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 264964d1379024099-looping-through-data-and-finding-cells-that-meet-criteria-test
Sheet: Santa

Supplier # | Supplier | SSR | Discrepancy Type | PO # | PO Date | Stuff | P/n | P/n | Total Order Qty | Received | Total Due | Cost | Balance | Now | Here | When | Ack Qty 1 | Country | Mexico | Canada | Taiwan | Part | Cuba
f | Rudolph | Santa | Past Due Ack | y | ? |  | 18516 | 18516 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Past Due Ack | y | ? |  | 18517 | 18517 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Past Due Ack | y | ? |  | 18518 | 18518 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Past Due Ack | y | ? |  | 18519 | 18519 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Past Due Ack | y | ? |  | 18520 | 18520 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Past Due Ack | y | ? |  | 18521 | 18521 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Past Due Ack | y | ? |  | 18522 | 18522 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Past Due Ack | y | ? |  | 18523 | 18523 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Past Due Ack | y | ? |  | 18524 | 18524 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Past Due Ack | y | ? |  | 18525 | 18525 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Blank Ack Date | y | ? |  | 18526 | 18526 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Blank Ack Date | y | ? |  | 18527 | 18527 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
f | Rudolph | Santa | Blank Ack Date | y | ? |  | 18528 | 18528 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
Spreadsheet: sally_beck__33739__Metrics 0727
Sheet: New Products

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | GRM New Products
Results based on Activity through July 27, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 4
 |  | Weekly Summary - 2Q00 through 2Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-07-07 00:00:00
Postings Rollforward:
Beginning |  | 5
+ Entrances |  | 0 | 0 | 0 | 0
- Exits |  | 0 | 0 | 2 | 0
- Executions |  | 0 | 0 | 0 | 0
Ending
Postings Rollforward:
Beginning
+ Entrances
- Exits
+/- [NAME]
- Executions
Ending
Average Deal Size
 |  | Quarterly Summary ($ millions)
 |  |  |  |  |  |  |  | Forward Quarters
 | YTD |  |  | Current Quarter |  | Per |  |  |  |  | Total Year
 | 2000 |  |  | 3Q00 |  | Hot List |  | 4Q00 |  |  | 2000 |  |  | 1Q01 |  |  | 2Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0
DPR/MPR |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 0
Postings |  |  |  | 1 | 0.75 |  |  | 1 | 10 |  |  |  |  | 1 | 7.5 |  | 0 | 0
Identified Margin
Budget |  | 7.712
$ Coverage
Spreadsheet: 856240d1705563064-formula-help-tester-rank
Sheet: RFA Tables

 | Growth Allowance
 | Growth | Scope Growth | Cost
 | Increase in Quantities | 4000
 |  | Growth – Total
 | Table 5.1 Commercial Pricing Summary
 | Ref. | Description | Budget | A | B | C | D
 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 |  | Total Amount
 |  | Pricing Rank
 | Table 5.2 Budget and Price Comparison - Recommended Contractor
 | A | Total Award Value
 | B | Growth Allowance
 | C | TOTAL VALUE (A+B)
 | D | Total Budget
 | E | Budget Gain/Loss (D-C)
 | Table 5.3 Forecast and Price Comparison - Recommended Contractor
 | A | Total Award Value
 | B | Growth Allowance
 | C | TOTAL VALUE (A+B)
 | D | Total Forecast
 | E | Forecast Gain/Loss (D-C)
Spreadsheet: 773441d1647866544-sumif-from-another-worksheet-dept-mth
Sheet: Data

Dept | 2022-03-01 00:00:00 | 2022-03-02 00:00:00 | 2022-03-03 00:00:00 | 2022-03-04 00:00:00 | 2022-03-05 00:00:00 | 2022-03-06 00:00:00 | 2022-03-07 00:00:00 | 2022-03-08 00:00:00 | 2022-03-09 00:00:00 | 2022-03-10 00:00:00 | 2022-03-11 00:00:00 | 2022-03-12 00:00:00 | 2022-03-13 00:00:00 | 2022-03-14 00:00:00 | 2022-03-15 00:00:00 | 2022-03-16 00:00:00 | 2022-03-17 00:00:00 | 2022-03-18 00:00:00 | 2022-03-19 00:00:00 | 2022-03-20 00:00:00 | 2022-03-21 00:00:00 | 2022-03-22 00:00:00 | 2022-03-23 00:00:00 | 2022-03-24 00:00:00 | 2022-03-25 00:00:00 | 2022-03-26 00:00:00 | 2022-03-27 00:00:00 | 2022-03-28 00:00:00 | 2022-03-29 00:00:00 | 2022-03-30 00:00:00 | 2022-03-31 00:00:00
BDC07
BDC05 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | 3
BDC07
[NAME]
BDC05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.75
[NAME]
BDC07 |  |  |  |  |  |  |  |  |  |  | 0.5
BDC05
BDC07
BDC07
BDC07
[NAME]
[NAME]
BDC05
BDC05 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
BDC07
BDC05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.5
BDC07 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 8
BDC05 |  |  |  |  |  |  |  |  |  |  | 0.5 |  |  | 8
BDC07
BDC05 |  |  |  |  |  |  |  |  |  |  | 4
BDC05
BDC07 |  |  |  |  |  |  |  |  |  |  | 1
BDC07
[NAME]
BDC07
BDC07
BDC05 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 0 | 3
BDC07
BDC05
BDC05 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  | 5.5
BDC05
BDC06 |  |  |  |  |  |  |  |  |  |  | 2.75
BDC03
BDC06 |  |  |  |  |  |  |  |  |  |  | 4.5
BDC03
BDC03
BDC06
BDC06 |  |  |  |  |  |  |  |  |  |  | 3.5
BDC06 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 3
BDC06
BDC06 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 0.5
BDC03
BDC06
BDC03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
BDC06 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5
BDC06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
BDC06 |  |  |  |  |  |  |  |  |  |  | 3
BDC03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
BDC06 |  |  |  | 0.5
BDC03
BDC06 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5
BDC06
BDC06 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.25
Spreadsheet: 681107d1591357044-2-lookup-values-between-two-dates-book12
Sheet: Sheet1

Purchase Date | Name | Output |  | List | Type | Date Added | Date Removed
2019-06-05 00:00:00 | JPMORGAN |  |  | ALPHA FINANCE | Exclusive | 2019-01-05 00:00:00
2018-01-05 00:00:00 | BNP |  |  | BANK VONTOBEL | Exclusive | 2018-02-05 00:00:00
2018-02-06 00:00:00 | MACQUARIE |  |  | BMO CAPITAL MARKETS | Exclusive | 2019-08-05 00:00:00 | 2020-06-05 00:00:00
2019-07-07 00:00:00 | CREDIT SUISSE |  |  | BOFA MERRILL LYNCH | Exclusive | 2019-08-06 00:00:00
2018-01-08 00:00:00 | BPI |  |  | EXANE BNP PARIBAS | Exclusive | 2019-08-07 00:00:00
2020-01-09 00:00:00 | ICRA LIMITED |  |  | CREDIT SUISSE | Exclusive | 2019-08-08 00:00:00
2017-01-10 00:00:00 | ICRA LIMITED |  |  | ICRA LIMITED | Exclusive | 2019-08-09 00:00:00
2018-01-11 00:00:00 | ICRA LIMITED |  |  | JMP SECURITIES | Exclusive | 2019-08-10 00:00:00
2018-01-12 00:00:00 | ICRA LIMITED |  |  | KEPLER CHEUVREUX | Exclusive | 2019-08-11 00:00:00
 |  |  |  | ICRA LIMITED | Exclusive | 2019-08-12 00:00:00
 |  |  |  | LIBERUM CAPITAL | Exclusive | 2019-08-13 00:00:00
 |  |  |  | MORGAN STANLEY | Exclusive | 2019-08-14 00:00:00
 |  |  |  | NORDEA MARKETS | Exclusive | 2019-08-15 00:00:00
 |  |  |  | BANCO SANTANDER | Exclusive | 2019-08-16 00:00:00
 |  |  |  | ICRA LIMITED | Exclusive | 2019-08-17 00:00:00
 |  |  |  | ICRA LIMITED | Exclusive | 2019-08-18 00:00:00
 |  |  |  | WILLIAM BLAIR & COMPANY | Exclusive | 2019-08-19 00:00:00
Spreadsheet: 57827d1258040049-embedding-a-spread-sheet-within-a-spread-sheet-cameraexample
Sheet: Sheet2

8.218756419983206 | 4.570991796818076 | 1.567897541246968 | 3.035279257021504 | 1.276792460564353
3.178653889778831 | 7.926113849878826 | 2.089257484674967 | 3.085851576400653 | 4.273836519790546
2.942863310670925 | 3.742091859674528 | 5.568926086475088 | 6.287982213618704 | 1.997475832526403
8.358146195579385 | 3.31525044058937 | 8.497742984811545 | 3.433391819425653 | 8.070101508189742
3.734312934332449 | 7.528879677256537 | 7.197535809236317 | 3.601108269093283 | 3.295436041954547
6.959471975209013 | 4.244493419002035 | 5.195297824609169 | 6.495047491928365 | 2.222662104476587
1.298094626781578 | 3.721516891332444 | 3.707621466269482 | 1.968770520882508 | 6.741959654634528
2.365806241807737 | 6.470209151402102 | 4.707568539589655 | 122 | 1.618852093917564
3.664727875599487 | 3.361302928528356 | 5.288900012735509 | 4.247012844922551 | 0.857851263540681
7.997570680649249 | 0.2398581014169832 | 8.712357701180801 | 6.748941530690198 | 4.056338969509583
5.052661894086157 | 1.776939820739398 | 6.115102784910846 | 6.591906334829396 | 6.175373513217304
Spreadsheet: 79417d1279675543-cumulative-totals-cumulative-totals
Sheet: Sheet1

I want to be able to click on c6,(automatically copying it) then on m12(automatically pasting it), placing the (start  0) in that position. All of the calculations
will start from that point. Then, click on the 42(c10 copy it) click on L12, M11, L11, M10, L10,(in that order, pasting) cumulatively adding 42 to each one that is clicked on.
Then, click on the 17(c8) then on m12, then n12,o12,p12,q12,r12. Hopefully you have the idea. The colors are for illustrative purposes, but would be nice to incorporate into the formula too.
Also, of the numbers accumulated, I need a conditional format of some sort to flag cells that are within 7 or less apart from each other.
These numbers represent milliseconds in the delay pattern of a blast.
 |  | 0  start
 |  | 9
 |  | 17 |  |  |  |  |  |  |  |  | End result (without the arrows )
 |  | 25 |  |  | 404 | 413 | 422 | 431 | 440 | 449 | 458 | 467 | 476 | 485 | 494 | 503 | 512 | 521
 |  | 42 |  |  | 395 | 295 | 278 | 261 | 244 | 227 | 210 | 168 | 185 | 202 | 219 | 236 | 253 | 278
 |  | 100 |  |  | 311 | 211 | 194 | 177 | 160 | 143 | 126 | 84 | 101 | 118 | 135 | 152 | 169 | 194
 |  |  |  |  | 227 | 127 | 110 | 93 | 76 | 59 | 42 | 0  start | 17 | 34 | 51 | 68 | 85 | 110
 |  |  |  |  |  |  |  |  |  |  |  | start here with the first one
Spreadsheet: 149860d1334164016-index-and-match-doesnt-return-sum-of-multiple-instances-index-and-match-issue
Sheet: Detail & Billing

Project | Activity | Current Month Time | Prior Month  Adjustment | Total Time | Rate | Total Staff Cost | Contractor Total | Total Billing Cost
project1 | Execution Activities | 6 |  | 6 | 92.75 | 556.5 | 82.02 | 556.5
project2 | Execution Activities | 9 |  | 9 | 90 | 810 | 267.18 | 810
project3 | Execution Activities | 9 |  | 9 | 90 | 810 | 309.42 | 810
[NAME] | Execution Activities | 11.25 |  | 11.25 | 90 | 1012.5 | 1001.43 | 1012.5
 |  |  |  |  |  |  | 1660.05
The formula doesn't total multiple instances of the same project/activity.
Spreadsheet: 158220d1338068053-turn-multiple-rows-into-a-single-column-sample-excel-sheet
Sheet: Sheet1

ID | IV1 | IV2 | IV3 | IV4 | IV5 | IV6 | IV7 | IV8 | IV9 | IV10 | IV11 | IV12 | IV13 | IV14 | IV15 | IV16 | IV17 | IV18 | IV19 | IV20 | IV21 | IV22 | IV23 | IV24 | IV25 | IV26 | IV27 | IV28
1 | 1 | 1 | 7 | 7 | 7 | 1 | 1 | 1 | 1 | 1 | 7 | 1 | 1 | 7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7 | 4 | 7 | 7 | 1 | 1 | 4
2 | 1 | 5 | 2 | 1 | 1 | 3 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 1 | 7 | 7 | 6 | 7 | 6 | 6 | 4
3 | 1 | 3 | 3 | 1 | 1 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 4 | 5 | 1 | 1 | 3 | 1 | 3 | 4 | 3 | 3 | 4 | 5 | 3
4 | 1 | 4 | 1 | 1 | 7 | 4 | 4 | 3 | 1 | 1 | 1 | 1 | 1 | 3 | 1 | 1 | 5 | 3 | 4 | 4 | 4 | 4 | 1 | 7 | 5 | 1 | 3 | 1
What I want it to look like
ID | Variable | Rating
1 | IV1 | 1
1 | IV2 | 1
1 | IV3 | 7
1 | IV4 | 7
1 | IV5 | 7
1 | IV6 | 1
1 | IV7 | 1
1 | IV8 | 1
1 | IV9 | 1
1 | IV10 | 1
1 | IV11 | 7
1 | IV12 | 1
1 | IV13 | 1
1 | IV14 | 7
1 | IV15 | 1
1 | IV16 | 1
1 | IV17 | 1
1 | IV18 | 1
1 | IV19 | 1
1 | IV20 | 1
1 | IV21 | 1
1 | IV22 | 7
1 | IV23 | 4
1 | IV24 | 7
1 | IV25 | 7
1 | IV26 | 1
1 | IV27 | 1
1 | IV28 | 4
2 | IV1 | 1
2 | IV2 | 5
2 | IV3 | 2
2 | IV4 | 1
2 | IV5 | 1
2 | IV6 | 3
2 | IV7 | 1
2 | IV8 | 1
2 | IV9 | 1
2 | IV10 | 2
2 | IV11 | 1
2 | IV12 | 1
2 | IV13 | 2
2 | IV14 | 1
2 | IV15 | 1
2 | IV16 | 2
2 | IV17 | 1
2 | IV18 | 2
2 | IV19 | 1
2 | IV20 | 1
2 | IV21 | 1
2 | IV22 | 7
2 | IV23 | 7
2 | IV24 | 6
2 | IV25 | 7
2 | IV26 | 6
2 | IV27 | 6
2 | IV28 | 4
3 | IV1 | 1
3 | IV2 | 3
3 | IV3 | 3
3 | IV4 | 1
3 | IV5 | 1
3 | IV6 | 3
3 | IV7 | 3
3 | IV8 | 1
3 | IV9 | 1
3 | IV10 | 1
3 | IV11 | 1
3 | IV12 | 1
3 | IV13 | 1
3 | IV14 | 1
3 | IV15 | 1
3 | IV16 | 4
3 | IV17 | 5
3 | IV18 | 1
3 | IV19 | 1
3 | IV20 | 3
3 | IV21 | 1
3 | IV22 | 3
3 | IV23 | 4
3 | IV24 | 3
3 | IV25 | 3
3 | IV26 | 4
3 | IV27 | 5
3 | IV28 | 3
4 | IV1 | 1
4 | IV2 | 4
4 | IV3 | 1
4 | IV4 | 1
4 | IV5 | 7
4 | IV6 | 4
4 | IV7 | 4
4 | IV8 | 3
4 | IV9 | 1
4 | IV10 | 1
4 | IV11 | 1
4 | IV12 | 1
4 | IV13 | 1
4 | IV14 | 3
4 | IV15 | 1
4 | IV16 | 1
4 | IV17 | 5
4 | IV18 | 3
4 | IV19 | 4
4 | IV20 | 4
4 | IV21 | 4
4 | IV22 | 4
4 | IV23 | 1
4 | IV24 | 7
4 | IV25 | 5
4 | IV26 | 1
4 | IV27 | 3
4 | IV28 | 1
Spreadsheet: 687971d1595511816-return-sheet-name-when-value-is-found-on-that-sheet-students-example
Sheet: Torben

Torben
 | 2020-02-07 00:00:00
 | [NAME] akkoorden op [NAME]
 | Timing oefening
 | Triads
 | toepassen op Wish you were here
 | apprentus
 | Totaal aantal lessen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Impro over Space Oddity? | Sweet child o mine? |  | Sweet child o mine?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pentatonic opbouwen
 | Timing | Barré | Triads | penta | noten dikke snaren |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nobody's wife
 | Songwriting | CAGED? | Little sister? | Solo (hey you?) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ritme klappen?
 | Do i wanna know | Space oddity / strumming | Akkoorden mag het iets meer zijn |  |  |  |  |  |  |  |  |  |  |  |  |  |  | my girl? |  |  |  | [NAME] nog [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Miss you
 | 30 |  | maand |  |  |  | [EMAIL] |  |  |  |  |  |  |  |  |  |  | triads
 |  | Januari |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hey jude met triads
 |  | Februari |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beide comf numb solos
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apache? | Apache?
 |  | april |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sweet home alabama
 |  | mei |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pulp fiction??
 |  | juni
 |  | [NAME]
 |  | augustus
 |  | september
 |  | oktober
 |  | november
 |  | december
 | cash
Spreadsheet: 104014d1301640802-compare-and-fill-from-two-workbooks-example
Sheet: Workbook #2

home | window | M589405725 | J5725 | Manhattan Jaguar/NYC | USA | (212) 459-9400 | [NAME] | [NAME] | [NAME] | 834949
home | window | M589405683 | J5683 | The Great Britains | USA | (215) 443-5900 | Nicola | Azzara | Nicola Azzara | 137933
home | window | M589405616 | J5616 | Jaguar Scarborough | USA | (207) 883-0161 | [NAME] | Babb | [NAME] | 854211
home | window | M589405727 | J5727 | Crest Jaguar of Woodbridge | USA | (203) 389-7100 | [NAME] | Bacon | [NAME] | 1023353
home | window | M589400609 | J0609 | Jaguar of Great Neck/Roslyn | USA | (888) 263-4121 | [NAME] | [NAME] | [NAME] | 692475745
home | door | M589405381 | [NAME] | Jaguar Albany | USA | (518) 250-5996 | [NAME] | [NAME] | [NAME] | 910715
home | window | M589405774 | J5774 | Jaguar Westside | USA | (216) 351-9999 | Geoff | [NAME] | [NAME] | 908321
home | door | M589405684 | [NAME] | Bergen Jaguar | USA | (201) 444-7900 | [NAME] | Bakker | [NAME] | 93907
home | door | M589405684 | [NAME] | Bergen Jaguar | USA | (201) 444-7900 | [NAME] | Baloga | Phillip Baloga | 79189
home | 81 | M589405498 | J5498 | Jaguar Woburn | USA | (339) 645-2421 | [NAME] | [NAME] | [NAME] | 79
home | 81 | M589405774 | J5774 | Jaguar Westside | USA | (216) 351-9999 | Patra | [NAME] | Patra [NAME] | 942690
home | 81 | M589405598 | J5598 | Jaguar Norwood | USA | (781) 619-9000 | [NAME] | Baptiste | [NAME] | 1034728
home | 81 | M589405725 | J5725 | new york | USA |  | [NAME] | Barros | [NAME] | 887567
home | 81 | M589405616 | J5616 | california | USA |  | [NAME] | [NAME] | [NAME] | 114876
home | 81 | M589405670 | J5670 | florida | USA |  | Jaswant | Basuta | Jaswant Basuta | 398566
home | 81 | M589405445 | J5445 | new york | USA |  | [NAME] | Stymest | [NAME] | 236433
home | 81 | M589405725 | J5725 | texas | USA |  | [NAME] | Beck | [NAME] | 835514
home | 81 | M589405684 | [NAME] | new jersey | USA |  | [NAME] | Becker | [NAME] | 105039
home | 81 | M589405774 | J5774 | florida | USA |  | [NAME] | Tibbo | [NAME] | 965478
home | 81 | M589405445 | J5445 | new york | USA |  | Ann-Marie | Bell | Ann-Marie Bell | 170676
home | 81 | M589405670 | J5670 | texas | USA |  | [NAME] | [NAME] | [NAME] | 876586
home | 81 | M589405775 | J5775 | new york | USA |  | [NAME] | [NAME] | [NAME] | 831639
home | 81 | M589403937 | J3937 | florida | USA |  | Kristen | [NAME] | [NAME] | 116249
home | 81 | M589403937 | J3937 | florida | USA |  | [NAME] | [NAME] | [NAME] | 102357
home | 81 | M589405471 | [NAME] | new york | USA |  | Tyler | Bent | [NAME] | 857581
home | 81 | M589405774 | J5774 | california | USA |  | [NAME] | [NAME] | [NAME] | 324353
home | 81 | M589405744 | [NAME] | new jersey | USA |  | Kenny | Berini | [NAME] | 101797
home | 81 | M589405744 | [NAME] | california | USA |  | [NAME] | [NAME] | [NAME] | 939718
home | 81 | M589405774 | J5774 | california | USA |  | Kelly | [NAME] | [NAME] | 341343
home | 81 | M589405774 | J5774 | california | USA |  | [NAME] | Bernon | [NAME] | 840272
Spreadsheet: 69904d1270575570-hyperlinking-book2
Sheet: ONE

a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
aa
bb
cc
dd
ee
ff
gg
hh
ii
jj
kk
ll
[NAME]
nn
oo
pp
qq
rr
ss
tt
uu
vv
ww
xx
yy
zz
Spreadsheet: 37960d1236075148-random-input-random2
Sheet: generator

childs name | task 1 | task 2 | task 3
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A |  | then click a day to save
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
Spreadsheet: 101284d1299444552-nested-vlookup-and-match-testdata
Sheet: Final

Final Table
ID | Desc
1 | yes
1 | na
2 | no |  |  | Desc values from data tab goes here
3 | 2010-12-31 00:00:00
3 | part
4 | [NAME]
5 | 2011-01-01 00:00:00 |  | Matched IDs goes Here
6 | no
7 | yes
7 | sold
8 | 2011-01-05 00:00:00
9 | 2011-01-06 00:00:00
10 | 2011-01-07 00:00:00
Spreadsheet: 812483d1673185755-formula-to-overcome-ref-reference-error-paste-reference-error
Sheet: Sheet1

0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00
0 |  |  |  |  | 0 | 0 | 0.00
0 | 0 | 0 | 43566 | 43566 | 0 | 0 | 0.00
 | 0 |  |  |  | 0
6300 | 526.3 | 0 | 2028.59 | 0 | 0 | 0 | 10142.94
1288.05 | 43579 | 64143 |  |  | 0 | 0 | 64143.00
0 | 0 | 0 | 43573 | 43580 | 0 | 0 | -54000.06
 | 0 |  | 0 | 60 | 0
27000 | 887.3 | 0 | 7514.71 | 0 | 0 | 0 | 37573.56
2171.55 | 43612 | 37573.56 |  |  | 0 | 54000 | -16426.44
0 | 0 | 0 | 43603 | 43612 | 0 | 0 | -0.06
 | 0 |  | 0 | 60 | 0
29700 | 1808.8 | 0 | 8983.9 | 0 | 0 | 0 | 44919.50
4426.8 |  |  |  |  | 0 | 0 | 0.00
0 | 0 | 0 | 43636 | 43643 | 0 | 0 | 44919.44
 | 0 |  | 0 | 60 | 0
27000 | 8532.24 | 0 | 13777.19 | 0 | 0 | 0 | 68885.93
19576.5 | 43668 | 113139 |  |  | 0 | 0 | 113139.00
0 | 0 | 0 | 43666 | 43675 | 0 | 0 | 666.37
 | 0 |  | 0 | 60 | 0
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 154063 | 164544 |  | -3485 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 160904 | 166793 |  | -6970 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 157686 | 163447 |  | -6970 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2002-02-28 00:00:00 |  |  |  | -16139
 | 2002-03-03 00:00:00
 | CBS Dollars
 |  |  |  | -493766
Spreadsheet: 821970d1679022457-compare-number-list-and-range-number
Sheet: Sheet1

numbers | matches | num list
1 |  | 1
2 |  | 2
3 |  | 10
4 |  | 11
5 |  | 12
6 |  | 13
7 |  | 14-15
8 |  | 16
9 |  | 17
10 |  | 18-19
11 |  | 20-22
12 |  | 31-32
13 |  | 35-37
14 |  | 39-41
15 |  | 51
16 |  | 53
17 |  | 58
18 |  | 65
19 |  | 69-73
20 |  | 75
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
Spreadsheet: sara_shackleton__37339__Raptor Asset List 0913
Sheet: Asset List

ENA Asset Listing
Raptor Hedge Candidates
Raptor I
 |  |  | Notional |  |  |  |  | Notional
Asset Name |  |  | Value |  | Asset Name |  |  | Value
Privates |  |  |  |  | Privates
 |  |  |  |  |  |  | Proof:
 |  |  |  |  | **36.12% of the gross value of the following assets:
 |  |  |  |  | Mariner Equity, [NAME]
Publics (as of 8/3/00)
Chewco SLP
 |  | Proof:
*36.12% of the gross value of the following assets:  [NAME], [NAME], [NAME], 3TEC Warrants, [NAME] Place Resources
***The Notional Amount of the Merlin Credit Derivative is subject to change.
Spreadsheet: 750967d1633751185-help-recalculating-a-group-of-numbers-to-equal-a-specific-number-book1-help
Sheet: Sheet1

Name |  | % Of Shots Made | [NAME] | Total Shots Made | % Of Shots Made MAX | % Of Shots Made MIN
Player A |  | 0.95 | 70 |  | 0.98 | 0.68
Player B |  | 0.84 | 70 |  | 0.92 | 0.55
Player C |  | 0.58 | 70 |  | 0.77 | 0.42
Player D |  | 0.16 | 70 |  | 0.41 | 0.05
Total
Need To Be |  | 2.82 |  | 199
Each Player cant have more than 70 shots that stays the same