tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2270589f-ed82-495c-b5ab-f013d0df847b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43907300 | 2014-11-06 20:53:34 | AXIS | 1 | 6 | 5 | 20796 | Titanos | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
43907592 | 2014-11-06 21:21:57 | ALLIES | 0 | 4 | 6 | 20796 | Titanos | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
43907979 | 2014-11-06 21:51:03 | AXIS | 1 | 6 | 3 | 29441 | w a r r i o r | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
43908338 | 2014-11-06 22:16:28 | ALLIES | 1 | 6 | 2 | 29441 | w a r r i o r | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44008275 | 2014-11-13 20:47:32 | ALLIES | 0 | 3 | 6 | 942409 | Cambrone40 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
44008506 | 2014-11-13 21:03:35 | AXIS | 1 | 6 | 3 | 942409 | Cambrone40 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
44010806 | 2014-11-13 23:50:13 | AXIS | 1 | 6 | 3 | 29441 | w a r r i o r | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44011059 | 2014-11-14 00:17:04 | ALLIES | 0 | 3 | 6 | 29441 | w a r r i o r | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
44109795 | 2014-11-20 21:54:34 | AXIS | 0 | 4 | 6 | 1670292 | Unrealik280 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44110122 | 2014-11-20 22:07:29 | ALLIES | 0 | 2 | 6 | 1670292 | Unrealik280 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44111101 | 2014-11-20 23:42:47 | ALLIES | 0 | 5 | 6 | 749869 | [NAME] | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
44111601 | 2014-11-21 00:08:57 | AXIS | 1 | 6 | 1 | 749869 | [NAME] | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
Spreadsheet: 138220d1327575017-help-with-extracting-data-from-table-sample
Sheet: table

 | data 1 | data 2 | data 3
1 | text 1 | 2012-01-01 00:00:00 | 12
2 | text 2 | 2012-01-01 00:00:00 | 14
3 | text 3 | 2012-01-03 00:00:00 | 12
4 | text 4 | 2012-01-20 00:00:00 | 13
2 | text 5 | 2012-02-03 00:00:00 | 16
4 | text 6 | 2012-02-05 00:00:00 | 28
3 | text 7 | 2012-02-16 00:00:00 | 10
1 | text 8 | 2012-02-16 00:00:00 | 2
1 | text 9 | 2012-03-03 00:00:00 | 25
5 | text 10 | 2012-03-10 00:00:00 | 22
6 | text 11 | 2012-03-15 00:00:00 | 10
5 | text 12 | 2012-03-16 00:00:00 | 13
Spreadsheet: 759798d1639737488-freeze-or-hide-columns-based-on-date-hide-columns
Sheet: Sheet1

Name | 2021-12-15 00:00:00 | 2021-12-16 00:00:00 | 2021-12-17 00:00:00 | 2021-12-18 00:00:00 | 2021-12-19 00:00:00 | 2021-12-20 00:00:00 | 2021-12-21 00:00:00 | 2021-12-22 00:00:00 | 2021-12-23 00:00:00 | 2021-12-24 00:00:00 | 2021-12-25 00:00:00 | 2021-12-26 00:00:00 | 2021-12-27 00:00:00 | 2021-12-28 00:00:00 | 2021-12-29 00:00:00 | 2021-12-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00
A | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
B | x | x | x | x | x | x | x | x | x |  | x | x | x | x | x |  | x
C | x | x | x | x |  | x | x | x | x | x | x | x | x |  | x | x | x
 | I want to hide columns when the date has passed.   These columns would be hidden today.  Also conditional format to grey where Column A has a value
Spreadsheet: 693360d1598948141-dynamic-count-on-pivot-table-sample-data
Sheet: Pivot

Year | (All)
Row Labels | Gender |  |  |  | Analyst | Intern | Professional | Teacher
Analyst |  |  |  | Male
D |  |  |  | Female
H
L
P
Intern
A
E
I
M
Professional
B
F
J
N
Teacher
C
G
K
O
Grand Total
Spreadsheet: 103684d1301414445-look-up-and-combine-like-this-maybe2
Sheet: Sheet2

1.3.2 | Catalog Manager
1.3.2 | Marketing Manager
1.3.3 | Pricing Manager
1.3.4 | Catalog Manager
1.3.4 | Marketing Manager
1.3.4 | Pricing Manager
1.3.8 | Catalog Manager
1.3.8 | Marketing Manager
1.3.8 | Pricing Manager
1.3.8 | Catalog Manager
1.4.9 | Marketing Manager
1.4.9 | Pricing Manager
1.3.8 | Catalog Manager 2
1.3.8 | Marketing Manager 2
1.5.1 | Pricing Manager
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Unknown Chemical 

Raw Material |  | Unknown Chemical
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 163
Total
Spreadsheet: 54974d1255015357-excel-2007-vlookup-and-filters-test1
Sheet: Data

Machine ID | Model | Cash In | Notes | Cash Out | Profit | Number Of Plays | Up Time Hours | Days Running | Cab Type | 10p Hopper | £1 Hopper | IOU | Refill
GW017510
Start Cash In | Start Notes | Start Cash Out | Start Number Of Plays | Start Up Time Hours | Start Days Running | Start IOU | Start Refill
End Start Cash In | End Notes | End Cash Out | End Number Of Plays | End Up Time Hours | End Days Running | End IOU | End Refill
Spreadsheet: 876700d1723435819-conditional-formatting-based-on-different-days-and-time-on-multiple-applications-appl_test
Sheet: Sheet1

00:00:00
845 |  |  |  |  |  |  |  |  | =IF(A1<=09:00,"TRUE","FALSE")
08:46:00
 |  |  |  | 03:00:00
 |  |  |  |  |  |  |  |  | [NAME]...
 |  |  |  |  |  |  |  |  | Activate the Fill tab.
Note 1 |  |  |  |  |  |  |  |  | Select orange.
Note 2 |  |  |  |  |  |  |  |  | Click OK, then click OK again.
Note 3
Note 4
System Available
Service Target Not Met
System Not Available
System Online (Report not available)
System Online (Report not available)
Spreadsheet: 865104d1712166921-multi-vlookup-formula-with-results-in-one-setting-and-set-out-in-paragraphs-mock-up-1-
Sheet: Sheet2

Column1 | Column2 |  | These options are in drop downs, the user selects an option that will be available to them
Option 1 | Two
Option 2 | Four
Option 3 | Six
Option 4 | Eight
Option 5 | Ten
 |  | In Cell A8 is the VLOOKUP formula - this goes to sheet 1, looks up the values selected above and populates the values. What I need the vlookup to do is put all the return values into merged cells A8-E30, in paragraph format as below.   Goodbye  Lard  Beyond  Issue  Figure
Lard
Beyond
Issue
Figure
Merged
Goodbye_x000D_ Lard_x000D_ Beyond_x000D_ Issue_x000D_ Figure
Spreadsheet: 477477d1472309863-count-values-from-cells-depending-on-drop-down-selection-copy-of-contracts-list
Sheet: Open

company name | Project # | installer | client ID | PS Amnt | signature Date | Assignment date | status | closed Date | [NAME] | Hrs spent |  | Description | Business partner | Delay Causes | Facets Case | Contact Details | Module
Mercury Federal CU |  | [NAME] |  |  | 2014-11-30 00:00:00 | 2015-04-06 00:00:00 |  |  | 80 |  |  | Upgrade migration |  |  |  |  | Upgrade Migration
Bank of Venus |  | [NAME] |  |  | 2014-12-01 00:00:00 | 2015-04-20 00:00:00 | Open |  | 31 |  |  | Inplace Upgrade |  |  |  | [NAME] <[EMAIL]> | Unity Client
Jupiter Credit Union |  | [NAME] |  |  | 2015-02-12 00:00:00 | 2015-04-16 00:00:00 | Open |  | 63.5 |  |  | Upgrade migration |  |  |  | [NAME] <[EMAIL]> | migration
First Bank of Uranus |  | [NAME] |  |  | 2015-04-27 00:00:00 | 2015-08-04 00:00:00 | Open |  | 66 |  |  | Signature Clips |  |  | 201509096666 |  | upgrade migration
Saturn Savings and Loan |  | [NAME] |  |  | 2015-01-20 00:00:00 | 2015-12-04 00:00:00 | open |  | 41 |  |  | Upgrade migration
Earth Savings Bank |  | [NAME] |  |  | 2015-08-19 00:00:00 | 2015-12-04 00:00:00 | open |  | 17 |  |  | Outlook Integration |  |  |  |  | Outlook integration
Mars FCU |  | [NAME] |  |  | 2013-12-03 00:00:00 | 2015-12-15 00:00:00 | Open |  | 52 |  |  | Inplace Upgrade |  |  |  |  | migration upgrade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Migration upgrade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | migration upgrade
 |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 201607024524
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 201607078972
Spreadsheet: 878684d1725944523-user-must-choose-from-a-dropdown-when-they-choose-certain-information-in-another-cell-sonniehoots-fy25-cmpa-financial-tracker-test-dv-spill-365-aligw
Sheet: CMPA

Status | CMPA Number | Submitter | Date | USER 1 | USER 2 | Department | Fund | Source Code | Function | Purpose | Project | Activity | Account Code | Purchased For [NAME] | Commodity Code | Vendor | Amount | Form Type | PS ID | OER | Description | GL Reconciliation Comments | PS Reconciliation Comments | Purchase Order # | Invoice # | Voucher # | PS Reference # | Payment Date | PS Reconcile Status | Supporting Docs | Supporting Docs2
 | CMP-25-0001 |  |  | CPADM |  |  |  |  |  |  |  |  |  | CPADM
 | CMP-25-0002 |  |  | CPADM |  |  |  |  |  |  |  |  |  | DGORG
 | CMP-25-0003 |  |  | CPADM |  |  |  |  |  |  |  |  |  | DGTAL
 | CMP-25-0004 |  |  | MKTNG
 | CMP-25-0005 |  |  | COMED
 | CMP-25-0006 |  |  | CPADM |  |  |  |  |  |  |  |  |  | COMED
 | CMP-25-0007
 | CMP-25-0008
 | CMP-25-0009
 | CMP-25-0010
 | CMP-25-0011
 | CMP-25-0012
 | CMP-25-0013
 | CMP-25-0014
 | CMP-25-0015
 | CMP-25-0016
 | CMP-25-0017
 | CMP-25-0018
 | CMP-25-0019
 | CMP-25-0020
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
Spreadsheet: 238583d1369636377-pulling-data-from-one-spread-sheet-into-another-retrieve-last-20-dates-of-data
Sheet: Sheet1

Date | [NAME] | data2 | data3 | data4 | data5 | [NAME] | data7 | data8 | data9 | data10 | data11 | data12 | data13 | data14 | data15 | data16 | data17 | data18 | data19 | data20 | data21
2013-06-27 00:00:00
Spreadsheet: 816801d1675846066-formula-help-need-for-a-table-for-customer-with-monthwise-sample-customer-details
Sheet: Summary

Date | Total Amount | Cash Receipt | Bank Deposit |  |  |  | Select Name |  |  |  |  |  |  |  |  |  | Name
2022-03-01 00:00:00 |  |  |  |  |  |  | A1 PET INDUSTRIES |  |  |  |  |  |  |  |  |  | A1 PET INDUSTRIES
2022-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A2 PET INDUSTRIES
2022-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A3 PET INDUSTRIES
2022-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G1 PET INDUSTRIES
2022-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H1 PET INDUSTRIES
2022-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J1 PET INDUSTRIES
2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K1 PET INDUSTRIES
2022-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L1 PET INDUSTRIES
2022-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T1 PET INDUSTRIES
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U1 PET INDUSTRIES
2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V1 PET INDUSTRIES
2023-02-01 00:00:00
Spreadsheet: 871549d1718007434-restrict-user-to-make-entry-in-a-column-gk-final-1-aligw
Sheet: Sheet1

 | C Index | C-Title | M-Index | M-Title | CM Index | CM Title
 |  | Area-1 |  | Topic-1 |  | Statement-1
 |  |  |  |  | MLO-1.1.2 | Statement-2
 |  |  |  |  | MLO-1.1.3 | Statement-3
 |  |  | Module - 1.2 | Topic-2 | MLO-1.2.1 | Statement-4
 |  |  |  |  | MLO-1.2.2 | Statement-5
 |  |  |  |  | MLO-1.2.3 | Statement-6
 |  |  |  |  | MLO-1.2.4 | Statement-7
 |  |  | Module - 1.3 | Topic-3 | MLO-1.3.1 | [NAME]
 |  |  |  |  | MLO-1.3.2 | Statement-9
 | Unit - 2 | Area-2 | Module - 2.1 | Topic-A | MLO-2.1.1 | Statement-10
 |  |  |  |  | MLO-2.1.2 | Statement-11
 |  |  |  |  | MLO-2.1.3 | Statement-12
 |  |  |  |  | MLO-2.1.4 | Statement-13
 |  |  | Module - 2.2 | Topic-B | MLO-2.2.1 | Statement-14
 |  |  |  |  | MLO-2.2.2 | Statement-15
 |  |  |  |  | MLO-2.2.3 | [NAME]
 |  |  |  |  | MLO-2.2.4 | Statement-17
 |  |  |  |  | MLO-2.2.5 | Statement-18
 |  |  |  |  | MLO-2.2.6 | [NAME]
 |  |  | Module - 2.3 | Topic-C | MLO-2.3.1 | Statement-20
 |  |  |  |  | MLO-2.3.2 | Statement-21
 |  |  |  |  | MLO-2.3.3 | Statement-22
 | Unit - 3 | Area-3 | Module - 3.1 | Topic-X1 | MLO-3.1.1 | Statement-23
 |  |  |  |  | MLO-3.1.2 | Statement-24
 |  |  |  |  | MLO-3.1.3 | Statement-25
 |  |  |  |  | MLO-3.1.4 | Statement-26
 |  |  |  |  | MLO-3.1.5 | Statement-27
 |  |  | Module - 3.2 | Topic-X2 | MLO-3.2.1 | Statement-28
 |  |  |  |  | MLO-3.2.2 | Statement-29
 |  |  |  |  | MLO-3.2.3 | Statement-30
 |  |  |  |  | MLO-3.2.4 | Statement-31
 |  |  | Module - 3.3 | Topic-X3 | MLO-3.3.1 | Statement-32
 |  |  |  |  | MLO-3.3.2 | [NAME]
 |  |  |  |  | MLO-3.3.3 | Statement-34
 |  |  |  |  | MLO-3.3.4 | Statement-35
 |  |  |  |  | MLO-3.3.5 | Statement-36
 |  |  |  |  | MLO-3.3.6 | Statement-37
 |  |  | Module - 3.4 | Topic-X4 | MLO-3.4.1 | Statement-38
 |  |  |  |  | MLO-3.4.2 | Statement-39
 |  |  |  |  | MLO-3.4.3 | Statement-40
 |  |  |  |  | MLO-3.4.4 | Statement-41
 |  |  |  |  | MLO-3.4.5 | Statement-42
 |  |  |  |  | MLO-3.4.6 | Statement-43
 | Unit - 4 | Area-4 | Module - 4.1 | Topic-A-1 | MLO-4.1.1 | Statement-44
 |  |  |  |  | MLO-4.1.2 | fdsafsd
 |  |  |  |  | MLO-4.1.3 | dfsdgdh
 |  |  |  |  | MLO-4.1.4 | fsdgd
 |  |  | Module - 4.2 | fdfdsgsdf | MLO-4.2.1 | fsdfsdgf
 |  |  |  |  | MLO-4.2.2 | ggsd
 |  |  |  |  | MLO-4.2.3 | gfd
 |  |  |  |  | MLO-4.2.4 | gdfg
 |  |  |  |  | MLO-4.2.5 | g
 |  |  |  |  | MLO-4.2.6 | fdg
 |  |  |  |  | MLO-4.2.7 | dfgd
 |  |  |  |  | MLO-4.2.8 | fg
 | Unit - 5 | [NAME] | Module - 5.1 | jfdsjjjfsd | MLO-5.1.1 | fdsf
 |  |  |  |  | MLO-5.1.2 | fadsf
 |  |  |  |  | MLO-5.1.3 | gasd
 |  |  |  |  | MLO-5.1.4 | g
 |  |  |  |  | MLO-5.1.5 | ssd
 |  |  |  |  | MLO-5.1.6 | gsdg
 |  |  |  |  | MLO-5.1.7 | dg
 |  |  |  |  | MLO-5.1.8 | sg
 |  |  |  |  | MLO-5.1.9 | fg
 |  |  |  |  | MLO-5.1.10 | sg
 |  |  | Module - 5.2 | dfdsfdsfds | MLO-5.2.1 | FGHJJ
 |  |  |  |  | MLO-5.2.2 | GFJHG
 |  |  |  |  | MLO-5.2.3 | FHJ
 |  |  |  |  | MLO-5.2.4 | FGHJJ
 | Unit - 6 | sdaffdsfas |  |  | MLO-6.2.5 | FHJ
 |  |  |  |  | MLO-6.2.6 | fsad
Spreadsheet: 766656d1643987486-nested-if-function-problem-book1-tms
Sheet: Sheet2

Name | ID | Scenario1 | Scenario2 | Scenario3 |  | Outcome
Some Name | 1 | Private Pay | Show | Yes |  | No Note
Some Name | 2 | [NAME] | No Show |  |  | No Note
 |  |  |  |  |  | Blank
Some Name | 4 | Self Pay | No Show | No |  | No Note
Some Name | 5 | Aetna | Show | Yes |  | Note
Some Name | 6 | No insurance |  |  |  | No Note
Some Name | 7 | OPT |  |  |  | No Note
Some Name | 8 | Anthem3 | Show | No |  | No Note
Some Name | 9 | Anthem2 | No Show | No |  | No Note
Spreadsheet: 882162d1730406313-dynamic-drop-down-using-tables-henighanhome-copy
Sheet: Receipts

 | Date | Purchase | Store | Amount | VAT | Total
 | 2024-10-26 00:00:00 | Screws,  [NAME], 2 handsaws, [NAME] | Toolstation | 118.54 | 23.71
 | 2024-10-28 00:00:00 | Screws | MCBS | 5.25 | 1.05
 | 2024-10-30 00:00:00 | Adhesive | MCBS | 4.49 | 0.9
 | 2024-10-30 00:00:00 | Foil Tape | MCBS | 5.02 | 1
Spreadsheet: sally_beck__36254__BO Assumps 0416
Sheet: Sheet2

BACK OFFICE | 2001-04-16 00:00:00 | Revision: 1
Valuation sheet | Prepared By: | [NAME]
Methodology | Probabilistic Discounted Cash Flow Model
Sources of value | - Per transaction fees for processing third party gas and power transactions
 | - Includes: Deal Setup, Confirmation, Settlement, Logistics, Volume Management
Not Considered Sources of Value | - Enron savings due to lower marginal costs for transactions
 | - Future process improvement savings not passed along to customer
 | [NAME] opportunities
 | - European market
 | - Commodities other than gas and power
Not Considered as Costs or Risks | - Increase in legal liability
 | - Disruption of service at implementation stage
 | - Unexpected setup costs
 | - Counterparties may not outsource Logistics
Discount Rate | 0.2
Revenue Related Assumptions
Estimated Market Spending | 419150000
[NAME] | 536 |  |  | based on ENE Gas & Power Counterparties
Market Growth | 5% / 20%
 | Range: beginning 2001 - ending 2011
 | P5 Case | P50 Case | [NAME]
Target Mkt Penetration | 0% - 10% | 2% - 36% | 5% - 65%
Customer Count | 0 - 54 | 11 - 193 | 27 - 348
Transaction Count | 0 - 169,805 | 33,961 - 611,297 | 84,902 - 1,103,731
% of Current Txn Volume | 0% - 18% | 4% - 64% | 9% - 116%
Profit Margin per Transaction | 0.53 | 0.68 | 0.75
Sales Revenue (Annual Average) | 6101000 | 23450000 | 44944000
Per txn revenue declining over time
Pricing per Transaction | 2001-12-31 00:00:00 | 2011-12-31 00:00:00 | (ENE Cost)
Physical Gas EOL | 126.2 | 84.13333333333334 | -31.55
Physical Gas OTC | 137.24 | 91.49333333333335 | -34.31
Financial Gas EOL | 24.88 | 16.58666666666667 | -6.22
Financial Gas OTC | 33.52 | 22.34666666666667 | -8.38
Power EOL | 26.4 | 17.6 | -6.6
Power OTC | 29.6 | 19.73333333333334 | -7.4
Cost Related Assumptions
(Annual Averages) | P5 Case | P50 Case | [NAME]
Core Transaction Processing | 2062000 | 7861000 | 14981000
$6 to 34 per transaction
 | 909000 | 1364000 | 1636000
IT Hardware
Upgrades as volume increases
 | 309000 | 1121000 | 2117000
IT Systems Maintenance
1 Mgr per 25 Cos.
Legal & Accounting
Legal: $10k/Co. + $50k start-up
Acct: $1k/Co., $20k/10 Cos. Audit
Customer Relations / Service
Rel: 1 Mgr per 50 Cos.
Svc: 1 Sr. Spec. per 10 Cos.
Mgmt, Marketing & Sales
[NAME]: 1 VP per 50 Cos.
Svc: 1 Mgr per 20 Cos.
Average Yearly Expense
Results
Average Annual EBITDA
NPV at Risk-Free Rate = | -1362272.275993884 | 32420174.5061877 | 68473446.40100609
Probabilistic NPV at 20% disc. rate = | 17998868.46217332
Spreadsheet: 34807d1232139781-highest-value-search-corresponding-month-return-sample
Sheet: Sheet1

Month | [NAME]
 | 2005 | 2006 | 2007 | 2008 | 2009
January | 1 | 4 | 5 | 2 | 0
Febuary | 4 | 2 | 6 | 2 | 0
March | 0 | 0 | 4 | 4 | 0
April | 10 | 2 | 5 | 0 | 0
May | 0 | 6 | 6 | 2 | 0
June | 3 | 0 | 2 | 1 | 0
July | 6 | 8 | 3 | 0 | 0
August | 2 | 0 | 0 | 0 | 0
September | 4 | 6 | 2 | 0 | 0
October | 0 | 0 | 7 | 0 | 0
November | 19 | 14 | 3 | 3 | 0
December | 6 | 8 | 5 | 0 | 0
Total | 55 | 50 | 48 | 14 | 0
 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009
Total Number of Visits in | 406 | 331 | 316 | 299 | 294
Highest Volume Month | March | November | November | October | September
Lowest Volume Month | November | February | February | March, Sept. | January
Spreadsheet: 275279d1383430361-need-to-copy-all-data-for-each-week-and-compile-to-one-sheet-for-year-to-date-data-consolodate-weeks-sheets-to-summary-sheet-1-
Sheet: YTD

Enter Start Date | 2013-10-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
Date | Employee# | Name | task | # of hour
 |  |  |  |  |  |  | 2013-10-28 00:00:00 | 1111 | Name1 | Task1 | 5
 |  |  |  |  |  |  | 2013-10-28 00:00:00 | 2222 | [NAME] | [NAME] | 10
 |  |  |  |  |  |  | 2013-10-28 00:00:00 | 3333 | Name3 | [NAME] | 15
 |  |  |  |  |  |  | 2013-10-29 00:00:00 | 1111 | Name1 | Task1 | 10
 |  |  |  |  |  |  | 2013-10-29 00:00:00 | 2222 | [NAME] | [NAME] | 5
 |  |  |  |  |  |  | 2013-10-29 00:00:00 | 3333 | Name3 | Task1 | 15
 |  |  |  |  |  |  | and so on
Spreadsheet: 761120d1640671312-income-by-location-sumproduct-pq_list_months
Sheet: Sheet1

Check In Date | Check Out Date | Rate Per Day | Room
2021-01-01 00:00:00 | 2021-02-12 00:00:00 | 50 | Room A
2021-02-01 00:00:00 | 2021-02-18 00:00:00 | 75 | Room B
2021-02-19 00:00:00 | 2021-04-19 00:00:00 | 50 | Room A |  | <- changed here to show 2 guests in room A in Feb
2021-04-01 00:00:00 | 2021-04-12 00:00:00 | 150 | Room C
2021-06-11 00:00:00 | 2021-06-23 00:00:00 | 60 | Room D
Spreadsheet: 268017d1380363470-counting-additions-removals-from-single-data-source-957762_byex0040
Sheet: Pivot

Key | PaymentType | Count of Key | Sum of PaymentAmount
Addition | A | 1 | 13 |  | Pivot uses Dynamic Named Range meaning when refreshed it will automatically pick up appropriate data range.
Addition Total |  | 1 | 13
Subtraction | A | 1 | 15 |  | See defined name: _PTData
 | B | 1 | 18
Subtraction Total |  | 2 | 33
Spreadsheet: 823865d1680180074-hilfe-bei-sverweis-sverweis
Sheet: Tabelle1

Auswahl | A
 | VLOOKUP | XLOOKUP
1 |  |  |  |  | have attached a sample. In the dropdown column B I select the value1 to be searched for Then rows 3 to 102 should be filled from the "Values" table. In addition, however, the SVWEIS is always set further by one.  I couldn't tell from your content
2 | 223 | 223
3 | 224 | 224
4 | 225 | 225
5 | 226 | 226
6 | 227 | 227
7 | 228 | 228
8 | 229 | 229
9 | 230 | 230
10 | 231 | 231
11 | 232 | 232
12 | 233 | 233
13 | 234 | 234
14 | 235 | 235
15 | 236 | 236
16 | 237 | 237
17 | 238 | 238
18 | 239 | 239
19 | 240 | 240
20 | 241 | 241
21 | 242 | 242
22 | 243 | 243
23 | 244 | 244
24 | 245 | 245
25 | 246 | 246
26 | 247 | 247
27 | 248 | 248
28 | 249 | 249
29 | 250 | 250
30 | 251 | 251
31 | 252 | 252
32 | 253 | 253
33 | 254 | 254
34 | 255 | 255
35 | 256 | 256
36 | 257 | 257
37 | 258 | 258
38 | 259 | 259
39 | 260 | 260
40 | 261 | 261
41 | 262 | 262
42 | 263 | 263
43 | 264 | 264
44 | 265 | 265
45 | 266 | 266
46 | 267 | 267
47 | 268 | 268
48 | 269 | 269
49 | 270 | 270
50 | 271 | 271
51 | 272 | 272
52 | 273 | 273
53 | 274 | 274
54 | 275 | 275
55 | 276 | 276
56 | 277 | 277
57 | 278 | 278
58 | 279 | 279
59 | 280 | 280
60 | 281 | 281
61 | 282 | 282
62 | 283 | 283
63 | 284 | 284
64 | 285 | 285
65 | 286 | 286
66 | 287 | 287
67 | 288 | 288
68 | 289 | 289
69 | 290 | 290
70 | 291 | 291
71 | 292 | 292
72 | 293 | 293
73 | 294 | 294
74 | 295 | 295
75 | 296 | 296
76 | 297 | 297
77 | 298 | 298
78 | 299 | 299
79 | 300 | 300
80 | 301 | 301
81 | 302 | 302
82 | 303 | 303
83 | 304 | 304
84 | 305 | 305
85 | 306 | 306
86 | 307 | 307
87 | 308 | 308
88 | 309 | 309
89 | 310 | 310
90 | 311 | 311
91 | 312 | 312
92 | 313 | 313
93 | 314 | 314
94 | 315 | 315
95 | 316 | 316
96 | 317 | 317
97 | 318 | 318
98 | 319 | 319
99 | 320 | 320
100 | 321 | 321