tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 151030d1334761556-excel-2007-pivot-table-calculation-with-formulas-book1_reply
Sheet: Sheet1

 | Data
 | Date | Attend. |  |  | 2012-04-01 00:00:00 | 2012-04-02 00:00:00
 | 2012-04-01 00:00:00 | Kiran |  | Kiran |  |  |  | < [NAME] (blue cells)
 | 2012-04-01 00:00:00 | Kiran |  | Madhu
 | 2012-04-01 00:00:00 | Madhu
 | 2012-04-02 00:00:00 | Kiran
 | 2012-04-02 00:00:00 | Madhu
 | 2012-04-02 00:00:00 | Madhu
Spreadsheet: 691278d1597604391-4-conditions-to-complete-to-reach-the-target-value-example1830
Sheet: Sheet3

↑ | B | C | D | Target |  |  | A | B | C | D | Target
>= | >= | <= | >= |  |  |  | 700 | 0.991 | 9 | 95
1000 | 0.97 | 20 | 90 | 2000 |  |  | 1000 | 1 | 15 | 95
800 | 0.985 | 15 | 92 | 1000 |  |  | 800 | 0.985 | 15 | 92
500 | 0.99 | 10 | 95 | 800
 |  |  |  |  |  |  |  |  |  |  | FINAL RESULT
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: BOA DGB20

Boambee DGB20
 | % Passing Sieve |  |  |  |  |  |  | % Passing | Passing Specification |  | Deviation | % Retained | [NAME] |  | Deviation
Sieve mm | 20mm Roadbase | Man Sand | Kingsbrae Criethons Pit | Kingsbrae Straight Blend | [NAME] | [NAME] | ROSA | Blend Result | Lower | Upper | Passing | Blend Result | Lower | Upper | Retained
26.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
19 | 99 | 100 | 96 | 100 | 99 | 100 | 100 | 99.3 | 95 | 100 | 0 | 0.7000000000000028
13.2 | 86 | 100 | 96 | 98 | 89 | 100 | 100 | 90.2 | 78 | 92 | 0 | 9.099999999999994 | 6 | 18 | 0
9.5 | 69 | 100 | 96 | 94 | 75 | 100 | 100 | 78.3 | 63 | 83 | 0 | 11.90000000000001 | 7 | 17 | 0
6.7 | 54 | 100 | 94 | 91 | 59 | 100 | 100 | 67.8 | 50 | 70 |  |  | 10 | 21
4.75 | 42 | 96 | 93 | 90 | 45 | 99 | 100 | 58.2 | 44 | 64 | 0 | 20.09999999999999 | 13 | 25 | 0
2.36 | 26 | 60 | 90 | 86 | 26 | 74 | 100 | 36.2 | 35 | 55 | 0 | 22 | 7 | 19 | 3
0.425 | 0 | 18 | 46 | 30 | 8 | 25 | 100 | 5.4 | 14 | 23 | -8.6 | 30.8 | 14 | 30 | 0.8000000000000043 |  | 14.91712707182321
0.075 | 0 | 8 | 11 | 10 | 3 | 10 | 100 | 2.4 | 7 | 14 | -4.6 | 3 | 6 | 13 | -3 |  | 44.44444444444444 | 0.4444444444444444
0.0135 | 0 | 0 | 0 | 0 | 1 | 2 | 40 | 0 | 3 | 7 | -3 | 2.4 | 3 | 8 | -0.6000000000000001 |  | 0
PI | 0 | 11 | 9 | 9 |  |  |  | 11 | 2 | 6 | 5
Ratio | 70 | 30 | 0 | 0 | 0 | 0 | 0 | 100
 |  | .
Spreadsheet: 9a900bb2-ba1e-48da-999b-0d9cfce62eb3
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
DRD3O | Test | DRD3O | Dopamine Receptor [NAME], Saliva | DRD3 Genotype, Saliva | Polymerase Chain Reaction (PCR)/Amplification with Allele-Specific Primer Extension (ASPE) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME] DNA Self-Collection Kit (Supply T651) |  |  | 4 | mL | Multiple saliva genotype tests can be performed on a single specimen after a single extraction. See Multiple Saliva Genotype Tests in Special Instructions for a list of tests that can be ordered together.   Container/Tube: [NAME] DNA Self-Collection Kit (Supply T651)  [NAME]: Full tube  Collection Instructions: 		 1. Fill tube to line.			 2. Send specimen in original container per kit instructions. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Wednesday; 8 a.m. | 2 days | 8 days | 1 | 81479 |  |  |  |  | Rochester
DRD3O | [NAME] | SALIVA | Saliva |  |  |  | Ambient
DRD3O | Result | 32977 | Reviewed by | Reviewed by | Numeric
DRD3O | Result | 32978 | DRD3 Genotype | DRD3 Genotype | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 87128d1287014479-create-sheets-data-from-master-sheet-excel-question-example
Sheet: Sheet1

Adult | Date | Transaction Description | Payment Amount | Deposit Amount | Dues | Trips | Fundraising | Popcorn | [NAME].
Doe, [NAME] | 2008-05-21 00:00:00 | opening balance |  | 0
Doe, [NAME] | 2008-05-21 00:00:00 | Mulch job 5/3/08 |  | 14.06 |  |  | 14.06
Doe, [NAME] | 2009-12-15 00:00:00 | Bushwack Patch | -7.5 |  |  |  |  |  | -7.5
Doe, [NAME] | 2010-04-08 00:00:00 | Mulch 2010 |  | 27.69 |  |  | 27.69
Doe, [NAME] | 2010-04-28 00:00:00 | Mulch 2010 |  | 20.54 |  |  | 20.54
Doe, [NAME] | 2010-05-17 00:00:00 | Mulch 2010 |  | 41.25 |  |  | 41.25
Doe, [NAME] | 2010-05-31 00:00:00 | Canoe/Kayak 2010 | -25 |  |  | -25
Doe, [NAME] | 2010-06-08 00:00:00 | Mulch 2010 |  | 11.25 |  |  | 11.25
Doe, [NAME] | 2008-05-21 00:00:00 | opening balance |  | 0
Doe, [NAME] | 2008-05-21 00:00:00 | Mulch job 5/4/08 |  | 23.68 |  |  | 23.68
Spreadsheet: 807006d1669712363-transfer-of-data-from-a-master-sheet-to-other-sheets-quest-2-
Sheet: cash in hand

Helper |  | Date | Description | Debit | Credit | Debit | Credit
Spreadsheet: errol_mclaughlin_jr__10104__Week 2
Sheet: Sheet1

2001 NFL POOL
WEEK TWO
VISITOR |  |  |  | HOME |  | POINTS
Sunday 9/16/01
Arizona |  | at |  | Washington |  | 7
Buffalo |  | at |  | Miami |  | 10
Cincinnati |  | at |  | Tennessee |  | 9
Dallas |  | at |  | Detroit |  | 5
Denver |  | at |  | Indianapolis |  | 1
Green Bay |  | at |  | NY Giants |  | 6
New England |  | at |  | Carolina |  | 12
Philadelphia |  | at |  | Tampa Bay |  | 2
San Francisco |  | at |  | New Orleans |  | 8
Atlanta |  | at |  | St. Louis |  | 13
Jacksonville |  | at |  | Chicago |  | 11
Kansas City |  | at |  | Seattle |  | 3
NY Jets |  | at |  | Oakland |  | 4
Cleveland |  | at |  | Pittsburgh |  | 14
Monday 9/17/01
Minnesota |  | at |  | Baltimore |  | 15
OPEN:
San Diego
Submit picks by 11:00 AM Sunday
15 Games:  Rank games 1 to 15 (Total Points = 120)
NAME:  Errol
Spreadsheet: 167548d1342022835-looking-up-values-in-multiple-rows-and-totaling-them-together-liquor-inventory-untitled-blank
Sheet: Counts

 |  |  |  | BAR INVENTORY
 |  |  |  |  |  | Mid Month |  |  |  |  |  |  |  |  | EOM
 |  |  |  | WEEK 1 | WEEK 2 | QTY | $ Sub total | WEEK 3 | WEEK 4 | WEEK 5 |  |  |  |  | QTY | $ Sub total
DISTRB. | ITEM | COST | PAR | ON HAND | ON Hand |  |  | ON HAND | ON HAND | ON HAND | MID | $$ | EOM | $$
Whiskey Bar
[NAME] | [NAME] | 10
 |  |  |  |  | Whisky Room Rails
 |  |  |  | Whisky Room Coolers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beer
 |  |  |  |  | Wine Room (Wine Racks)
 |  |  |  |  | Wine Room (Dry Storage)
 |  |  |  | Champaign Room Wall
 |  |  |  |  |  | Champaign Room Rails
 |  |  |  |  | Champaign Room Coolers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beer
 |  |  |  |  | Cool Storage Fridge
 |  |  |  |  | [NAME]
 |  |  |  |  | Lounge Bar Coolers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beer
 |  |  |  |  | Lounge Rails
 |  |  |  |  | Back Bar Wall
 |  |  |  |  | Back Bar Coolers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beer
 |  |  |  |  | Back Bar Rails
Mid Month
 | Liquor
 | Total
 | Beer
 | Bottle
 | Keg
 | Total
 | Wine
 | Total
 | Total - above L,B,W
End of Month
 | Liquor
 | Total
 | Beer
 | Bottle
 | Keg
 | Total
 | Wine
 | Total
 | Total - above L,B,W
 | Percent Change MOD v EOM
Spreadsheet: 476571d1471931282-displaying-top-cell-in-a-list-display-list
Sheet: Sheet1

 | apples | grapes | display this value in B under apples |  |  |  | when filtering by grapes the top cell under apples changes how to display in d2?
 | 2245 | green
 | 2112 | red
 | 2115 | red
 | 2116 | red
 | 2225 | red
 | 4567 | green
 | 2227 | red
 | 3333 | purple
 | 3334 | purple
 | 3335 | purple
 | 3336 | purple
 | 4444 | green
 | 4447 | green
 | 4448 | green
 | 4449 | green
 | 55559 | yellow
 | 55558 | yellow
 | 55557 | yellow
Spreadsheet: john_griffith__15931__11_14_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 20 | 45 | 65 | 61.2 | 72.3 | 0.9 | 2001-11-13 14:31:00
 | CL F2 | 20.5 | 265 | 268 | 56.7 | 57.4 | 0.74 | 2001-11-14 13:56:00
 | CL G2 | 20.5 | 365 | 380 | 54.2 | 56.4 | 0.71 | 2001-11-14 13:56:00
 | CL H2 | 20.5 | 415 | 445 | 51.2 | 54.9 | 0.68 | 2001-11-14 13:56:00
 | CL J2 | 20.5 | 465 | 490 | 50.2 | 52.9 | 0.66 | 2001-11-14 13:56:00
 | CL K2 | 20.5 | 510 | 530 | 49 | 51 | 0.64 | 2001-11-14 13:56:00
 | CL M2 | 20.5 | 540 | 550 | 47.9 | 48.8 | 0.62 | 2001-11-14 13:56:00
 | CL N2 | 20.5 | 550 | 580 | 45.1 | 47.6 | 0.6 | 2001-11-14 13:56:00
 | CL Q2 | 20.5 | 555 | 585 | 42.8 | 45.1 | 0.57 | 2001-11-14 13:56:00
 | CL U2 | 20.5 | 557 | 587 | 40.8 | 43 | 0.54 | 2001-11-14 13:56:00
 | [NAME] | 20.5 | 560 | 590 | 38.9 | 41 | 0.51 | 2001-11-14 13:56:00
 | CL X2 | 20.5 | 563 | 593 | 37.5 | 39.5 | 0.5 | 2001-11-14 13:56:00
 | [NAME] | 20.5 | 575 | 600 | 37 | 38.6 | 0.49 | 2001-11-14 13:56:00
 | CL M3 | 20.5 | 570 | 605 | 30.8 | 32.7 | 0.41 | 2001-11-14 13:56:00
 | CL Z3 | 20.5 | 570 | 605 | 27.3 | 29 | 0.36 | 2001-11-14 13:56:00
Spreadsheet: larry_campbell__21310__LFC0700V1
Sheet: BUG E

Pipeline | Status | ProdYear | ProdMonth | LDCMeter | ReadDate | ReadUnit | Quantity | BillFrom | BillTo | BTU |  | CustomerName
BUG | E | 2000 | 7 | SC17 |  | dth | 5332 | 2000-07-01 00:00:00 | 2000-07-31 00:00:00 |  |  | EES SC17 POOL (#[PHONE])
Spreadsheet: 772935d1647527460-is-it-possible-to-show-contents-of-one-column-horizontally-instead-of-vertically-book1-1-
Sheet: Sheet1

Company | Location | Product
Company 1 | New York | Product A
Company 1 | New York | Product B
Company 1 | New York | Product C
Company 2 | Los Angeles | Product C
Company 2 | Los Angeles | Product D
Company 3 | Llaregub | Product 3
Company 3 | Llaregub | Product 4
Spreadsheet: 0151aa22-9e58-474e-b201-4ea1c4aa56ae
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | January | February | March | April | May | June | July | August | September | October | November | December | Grant YTD Totals | 12 month Budget | Remaining Budget Fav/(Unfav)
Revenue
Source 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Source 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Source 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Total Revenues |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expenses
Payroll Costs
Employee 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Employee 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Employee 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Employee 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Employee 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Employee 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Benefits / Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Total Payroll Costs |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Operating Costs
Expense Category 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Expense Category 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Expense Category 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Expense Category 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Expense Category 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Expense Category 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Expense Category 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Expense Category 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Expense Category 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Expense Category 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Total Other Operating Costs |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Expense |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net Income (Loss) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 809536d1671133238-use-comma-separated-values-in-a-cell-as-source-for-lookups-iterateovercommaseperateddatainacell-1-
Sheet: Sheet1

Server | APPS |  | Expected result | Enhanced result | Enhanced result sorted by earliest date |  |  | Everithing in 1 go
S1 | app1 |  | 2021-12-10 00:00:00 | App1:10/12/21 | App1:10/12/21 |  |  |  | <<---
[NAME] | app2,app10 |  | 17/03/2022, 10/12/21 | App2:17/03/2022, app10:10/12/21 | App10:10/12/21, App2:17/03/2022 |  |  | app10: 10/12/2021, app2: 17/03/2022
S2
S6 | app6 |  | 2022-02-14 00:00:00 | App6:14/02/22 | App6:14/02/22 |  |  | app6: 14/02/2022
APPS | date
app1 | 2021-12-10 00:00:00 |  | Each server only appears once but and app can be on multiple servers.
app2 | 2022-03-17 00:00:00 |  | The removal date for an app is the same for all instances
app10 | 2021-12-10 00:00:00 |  | The server data will be on one worksheet and the app data on another
app6 | 2022-02-14 00:00:00 |  | Effectively I am looking for how to lookup things based on a previously textjoined list and possibly put in some extra data.
 |  |  | Office 365
Spreadsheet: 3f4ffe40-ef4b-4510-a226-baf2b6cbdf66
Sheet: Sheet1

Table 5--Corn: Food, seed, and industrial use (million bushels), 1/14/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Mkt year and qtr 1/ |  | High-fructose corn syrup (HFCS) | Glucose and dextrose | Starch | Alcohol for fuel | Alcohol for beverages and manufacturing | Cereals and other products | Seed | Total food, seed, and industrial use
2011/12 | Q1 Sep-Nov | 119.625 | 77.996 | 64.647 | 1265.728 | 33.302 | 50.732 | 0 | 1612.03
 | [NAME] | 114.982 | 73.408 | 62.037 | 1303.844 | 34.93 | 50.732 | 0 | 1639.933
 | [NAME] | 136.825 | 72.97 | 62.152 | 1243.296 | 36.586 | 50.531 | 23.565 | 1625.925
 | [NAME] | 141.939 | 72.374 | 65.177 | 1187.164 | 31.682 | 51.234 | 0.963 | 1550.533
 | MY Sep-Aug | 513.371 | 296.748 | 254.013 | 5000.032 | 136.5 | 203.229 | 24.528 | 6428.421
2012/13 | Q1 Sep-Nov | 123.067 | 70.399 | 63.98 | 1124.38 | 34.156 | 52.401 | 0 | 1468.383
 | [NAME] | 113.437 | 65.358 | 58.683 | 1109.854 | 35.826 | 52.286 | 0 | 1435.444
 | [NAME] | 126.318 | 72.48 | 62.195 | 1193.06 | 37.524 | 52.836 | 22.366 | 1566.779
 | [NAME] | 128.199 | 73.914 | 62.359 | 1221.159 | 32.494 | 52.896 | 2.215 | 1573.236
 | MY Sep-Aug | 491.021 | 282.151 | 247.217 | 4648.453 | 140 | 210.419 | 24.581 | 6043.842000000001
2013/14 | Q1 Sep-Nov | 113.429 | 71.108 | 60.806 | 1230.133 | 34.208 | 51.155 | 0 | 1560.839
 | MY Sep-Aug | 500 | 280 | 250 | 5000 | 140 | 205.35 | 24.65 | 6400
Errata: This table has been corrected to reflect an error in first-quarter (2013/14) corn for fuel ethanol use.  This correction changes previously reported estimates of Quarter 1 “Alcohol for Fuel” and Quarter 1 “Total food, seed and industrial use.”
1/ September-August.  Latest data may be preliminary or projected. Source: Calculated by USDA, Economic Research Service.
Date run: 1/15/2014
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 8109 | 7700 | 7524 | 8000 |  | 3500 | 5621 | 3500
2 | 7487 | 7700 | 8454 | 8000 |  |  | 5644 | 7000
3 | 7329 | 7700 | 8774 | 8000 |  |  | 5629 | 7000
4 | 7232 | 7700 | 8619 | 8000 |  |  | 6650 | 7000
5 | 7130 | 7700 | 8498 | 8000 | 1 |  | 6285 | 7000
6 | 8341 | 7700 | 8747 | 8000 |  |  | 5673 | 7000
7 | 9046 | 7700 | 5199 | 8000 |  |  | 1107
8 | 8490 | 7700 | 4470 | 8000
9 | 7931 | 7700 | 8850 | 8000
10 | 7777 | 7700 | 8458 | 8000
11 | 7673 | 7700 | 8800 | 8000 |  |  | 265
12 | 7457 | 7700 | 9083 | 8000 |  |  | 913
13 | 7123 | 7700 | 8979 | 8000
14 | 12291 | 7700 | 9160 | 8000 |  |  | 1482
15 | 11610 | 8000 | 9275 | 8700 |  |  | 23
16 | 13054 | 11000 | 9247 | 8700
17 | 10833 | 11000 | 9133 | 8700 |  |  | 101
18 | 12772 | 11000 | 9577 | 8700 |  |  | 499
19 | 12875 | 11000 | 9582 | 8700
20 | 12763 | 11000 | 8906 | 8700
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  | 18846.61
2002-02-20 00:00:00
CBS Volume
 |  |  | -118658
Spreadsheet: 215514d1361395338-transfer-data-between-worksheets-using-criteria-excelexample2
Sheet: Worksheet "2"

A | B | C | D | E | F | G | H | I | J | K | L | M | N
ABC123DEF456X | ABC123 | Yes | No | No | No | Yes | Yes | No | Yes | Georgia | 0 | 0 | 0
GHI789JKL123Z | GHI789 | No | Yes | No | No | No | Yes | No | No | Alaska | [NAME] | [PHONE] | ([EMAIL])
MNO456PQR789 | MNO456 | No | No | Yes | No | No | Yes | Yes | No | Missouri |  | [PHONE]
STU123VWX456 | STU123 | No | No | No | Yes | Yes | Yes | No | No | Nevada |  |  | ([EMAIL])
YZA789BCD123 | YZA789 | Yes | No | No | No | Yes | Yes | Yes | No | Florida | [NAME]
Spreadsheet: benjamin_rogers__1246__CIPCO model version 04-25-00
Sheet: Returns Analysis

RETURNS ANALYSIS
 | 0
('000 $) | Close
EBITDA | 0
Less Interest Payments | 0
Pre-Tax Cashflow
Less Cash Taxes | 0
Less Principal Payments | 0
Less Capex | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cashflow to Equity
Distribution to Equity | 1
Equity RROR | 0.14
Beginning Balance
RROR Target Coupon | 0
Actual Cash Flow
Equity Paydown | 0
Ending Balance
ENRON'S RETURNS ANALYSIS
Zero Residual Value
Equity Return
Actual Cash Flow
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
Spreadsheet: 876639d1723372885-formula-to-calculate-one-persons-contributions-map2
Sheet: Blad1

 | BOOTMAN BEWEGINGEN |  |  |  |  |  |  |  |  |  | Dit jaar:
 | Datum |  | [NAME] | Zaterdag | Weekend | Boatmen |  | Naam Schip | [NAME] | In/Uit | Aanvang | Einde | Van | Naar | Stand-by |  | Agent | [NAME] |  |  |  | Extra | Loodsen vervoer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Van | Tot |  | 1 | 2 | 3 | 4
1 | 2024-08-02 00:00:00 |  | x |  |  | 2 |  | ADHEMAR DE SAINT-VENANT |  | Canc. | 21:45 | 22:15 | K104 | Rede |  |  | Hmb | RW | AV |  |  | RW
2 | 2024-08-02 00:00:00 |  | x |  |  | 2 |  | ADHEMAR DE SAINT-VENANT |  | > | 23:45 | 23:55 | K104 | Rede |  |  | [NAME] | RW | AV |  |  | AV
3 | 2024-08-03 00:00:00 |  |  | x |  | 2 |  | MIDDELBURG |  | < | 18:20:00 | 18:50:00 | Rede | K206 |  |  | Hmb | BW | RW |  |  | BW
4 | 2024-08-04 00:00:00 | zo |  |  | x | 2 |  | ESVAGT MERCATOR |  | < | 17:45:00 | 18:45:00 | Rede | K603 |  |  | Vpo | BW | EV |  |  | EV
5 | 2024-08-05 00:00:00 | ma |  |  | x | 2 |  | MIDDELBURG |  | > | 0:20:00 | 0:50:00 | K205 | Rede |  |  | [NAME] | BW | RW |  |  | BW
6 | 2024-07-07 00:00:00 | zo |  |  | x | 2 |  | ESVAGT MERCATOR |  | < | 16:00 | 16:15 | Rede | K604 |  |  | Vpo | ED | AV |  |  | AV
7 | 2024-08-08 00:00:00 | ma |  |  |  | 2 |  | ESVAGT MERCATOR |  | > | 19:45 | 20:00 | K604 | Rede |  |  | [NAME] | AV | EV |  |  | AV
8 | 2024-08-13 00:00:00 | za |  | x |  | 2 |  | UAL LOBITO |  | < | 20:45 | 21:15 | Sl. Dem | K315 |  |  | Vpo | AV | EV |  |  | EV
9 | 2024-07-14 00:00:00 | zo |  |  | x | 2 |  | ANCHORAGE |  | < | 09:15 | 09:30 | Rede | K204 |  |  | Hmb | AV | EV |  |  | AV
10 | 2024-07-14 00:00:00 | zo |  |  | x | 2 |  | ANCHORAGE |  | > | 13:15 | 13:20 | K204 | Shift |  |  | Hmb | AV | EV |  |  | AV
 | The rows above are individual movements done by up to 4 boatmen. To report my own movements to the paying agency I need a table like the one above that only shows the row with my (BW) movements.  So if I fill in a row in the table above that contains my initials ''BW'', I would like that identical line to appear in the table below without the rows with the other initials, then I can simply take a print screen of that table and forward it.  Copying 'all'  rows automatically is no problem, but I have no idea how to copy the individual (BW) rows automatically to the table below.    in the lower table are the lines i would lik to see, altough they are now manually copied there by me...
1 | 2024-08-03 00:00:00 | 2024-08-03 00:00:00 |  | x |  | 2 |  | MIDDELBURG | 90 | < | 18:20:00 | 18:50:00 | Rede | K206 |  |  | Hmb | BW | RW |  |  | BW
2 | 2024-08-04 00:00:00 | zo |  |  | x | 2 |  | ESVAGT MERCATOR | 59 | < | 17:45:00 | 18:45:00 | Rede | K603 |  |  | Vpo | BW | EV |  |  | EV
3 | 2024-08-05 00:00:00 | ma |  |  | x | 2 |  | MIDDELBURG | 90 | > | 0:20:00 | 0:50:00 | K205 | Rede |  |  | [NAME] | BW | RW |  |  | BW
4
5
6
7
8
9
10
Spreadsheet: 84165d1284150720-billing-forecast-cash-flow-test-v3
Sheet: Spend Curve

 | ODD-11 | ODD-10 | ODD-09 | ODD-08 | ODD-07 | ODD-06 | ODD-05 | [NAME] | ODD-03 | ODD-02 | ODD-01 | ODD-0 | ODD+1 | ODD+2 | ODD+3 | ODD+4 | ODD+5
New Store | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.12 | 0.15 | 0.2 | 0.31 | 0.42 | 0.54 | 0.72 | 0.86 | 0.92 | 0.97 | 0.99 | 1
RCI / Emergency |  |  |  |  |  |  |  |  |  | 0.1 | 0.15 | 0.3 | 0.5 | 0.75 | 1
Minor Renovation |  |  |  |  |  |  |  |  |  |  | 0.15 | 0.3 | 0.5 | 0.75 | 1
RCI / Planned |  |  |  |  |  |  |  |  |  | 0.25 | 0.4 | 0.5 | 0.75 | 0.9 | 1
ATM |  |  |  | 0.05 | 0.07 | 0.1 | 0.2 | 0.25 | 0.3 | 0.35 | 0.4 | 0.45 | 0.6 | 0.8 | 1
Major [NAME] |  |  | 0.03 | 0.05 | 0.07 | 0.1 | 0.2 | 0.25 | 0.3 | 0.35 | 0.4 | 0.45 | 0.6 | 0.7 | 0.8 | 0.9 | 1
Non-Transition Signage |  |  |  |  |  |  |  |  |  | 0.25 | 0.4 | 0.5 | 0.75 | 0.9 | 1
ADA / Emergency |  |  |  |  |  |  |  |  |  | 0.25 | 0.4 | 0.5 | 0.75 | 0.9 | 1
Consolidation Cap Add |  |  |  |  |  |  |  |  |  |  | 0.15 | 0.3 | 0.5 | 0.75 | 1
FPP
Consolidation |  |  |  |  |  |  |  |  |  |  | 0.15 | 0.3 | 0.5 | 0.75 | 1
ADA Planned |  |  |  |  |  |  |  |  |  | 0.25 | 0.6 | 0.75 | 0.9 | 1
Lighting |  |  |  |  |  |  |  |  |  | 0.25 | 0.4 | 0.5 | 0.75 | 1
Spreadsheet: 108244d1305287249-race-results-spreadsheet-pmbar-results
Sheet: Sheet1

Team # | Team Name(s) | CP 1 | CP 2 | CP 3 | CP 4 | CP5 | Total CPs | Nickel? | Actual Time In | Official Finish Time
55 | Jones | 1 | 1 | 1 | 1 |  |  | Y | 16:15:00
73 | Smith | 1 | 1 | 1 | 1 |  |  |  | 17:25:00
56 | Poss | 1 | 1 | 1 | 1 | 1 |  |  | 14:23:00
12 | [NAME] | 1 | 1 | 1 | 1 | 1 |  | Y | 16:25:00
13 | Kee | 1 | 1 | 1 | 1 |  |  |  | 17:15:00
9 | [NAME] | 1 | 1 | 1 | 1 |  |  | Y | 18:15:00
18 | [NAME] | 1 | 1 | 1 |  | 1 |  |  | 19:27:00
17 | Hargroves |  | 1 | 1 | 1 |  |  | Y | 20:20:00
12 | [NAME] | 1 | 1 | 1 |  | 1 |  | Y | 21:11:00
Spreadsheet: 218590d1362505524-need-a-formula-to-explain-to-a-smaller-unit-sample
Sheet: Sample

DATA |  |  |  |  |  |  | REPORT
 |  |  | NETTO |  |  |  |  |  |  | NETTO
MENU | QTY |  | ML |  | OZ |  | MENU | QTY |  | BTL | OZ
A | 1 | = | 750 | = |  |  | A | 1000 | = | 1 | 10
B | 1 | = | 700 | = |  |  | B | 500 | = |  | 20
C | 1 | = | 630 | = |  |  | C | 1000 | = | 1 | 15
D | 1 | = | 500 | = |  |  | D | 1000 | = | 2
E | 1 | = | 800 | = |  |  | E | 1000 | = |  | 10
 |  |  |  |  |  |  | QUESTIONS
 |  |  |  |  |  | 1. | I need a function to automaticaly written on the Green area, as the explanation from QTY area
 |  |  |  |  |  | 2. | Is it possible to use Center Across Selection for a vertical text alignment? (in blue area)
 |  |  |  |  |  |  | Like horizontal text alignment that I used in the Yellow area