tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 23635d1213205915-rolling-time-periods-rolling-periods
Sheet: Sheet1

Date | ABC | DEF | GHI |  |  | Expected Results
2008-01-17 00:00:00 | 1.000815836187266 | 0.9995677115584582 | 0.9988026582404036 |  |  | ABC | DEF | GHI
2008-01-18 00:00:00 | 0.9975455286519219 | 1.001519508146901 | 1.001553444888173 |  | 1-week | -0.001134793708986614 | -0.001023718072610036 | -0.0007616366929382723
2008-01-19 00:00:00 | 0 | 0 | 0 |  | Month | -0.01133319031709545 | -0.001023718072610036 | -0.0007616366929382723
2008-01-20 00:00:00 | 0 | 0 | 0
2008-01-21 00:00:00 | 0.995291910483763 | 1.000677799721869 | 1.00031178917383
2008-01-22 00:00:00 | 0.9993627028579634 | 1.002849501921078 | 1.001537208231502
2008-01-23 00:00:00 | 1.001014936633823 | 1.002736599396783 | 1.002150202996138
2008-01-24 00:00:00 | 1.006164199192463 | 1.004738235704 | 1.004397046991234
2008-01-25 00:00:00 | 0.9986088445383773 | 1.005987331823015 | 1.003675101363934
2008-01-26 00:00:00 | 0 | 0 | 0
2008-01-27 00:00:00 | 0 | 0 | 0
2008-01-28 00:00:00 | 0.9973659621802002 | 0.9991374055459075 | 0.9988735508336424
2008-01-29 00:00:00 | 1.002533926962232 | 1.001519476931577 | 1.000420268131068
2008-01-30 00:00:00 | 0.9988252360652529 | 0.9994942761252356 | 0.9997619481046868
2008-01-31 00:00:00 | 0.9969170728230167 | 1.000954461821527 | 1.000889405568939
2008-02-01 00:00:00 | 0.9948876078115922 | 1.001608400445757 | 1.00048978792183
2008-02-02 00:00:00 | 0 | 0 | 0
2008-02-03 00:00:00 | 0 | 0 | 0
2008-02-04 00:00:00 | 1.003231597845601 | 1.002639272834829 | 1.001691423162056
2008-02-05 00:00:00 | 1.000286327845383 | 1.001701934532252 | 1.000437776650522
2008-02-06 00:00:00 | 1.0006887791613 | 1.001347907345529 | 1.000555663601256
2008-02-07 00:00:00 | 0.9950656571525625 | 0.9992308040360165 | 0.999000360980757
2008-02-08 00:00:00 | 0.9997664328000214 | 1.001596178228582 | 1.000910303805209
2008-02-09 00:00:00 | 0 | 0 | 0
2008-02-10 00:00:00 | 0 | 0 | 0
2008-02-11 00:00:00 | 1.004084478089501 | 1.0013411473008 | 1.001619713435315
2008-02-12 00:00:00 | 1.001290678629922 | 1.001541941946448 | 1.000891475011057
2008-02-13 00:00:00 | 0.9980887020064183 | 1.003843301193446 | 1.001436136792029
2008-02-14 00:00:00 | 1.001371644370024 | 1.001656815332258 | 1.001875331802732
2008-02-15 00:00:00 | 0.9990038068808481 | 0.9985582726094148 | 0.997859792310392
2008-02-16 00:00:00 | 0 | 0 | 0
2008-02-17 00:00:00 | 0 | 0 | 0
2008-02-18 00:00:00 | 1.000124127780684 | 0.9979174131135793 | 0.9996617003355381
2008-02-19 00:00:00 | 0.9993971684648187 | 1.000448802818482 | 1.000158847458095
2008-02-20 00:00:00 | 0.9942430344264765 | 0.9993270977726936 | 0.99848773616175
2008-02-21 00:00:00 | 0.9984208272367153 | 1.000819248984356 | 1.000096820819242
2008-02-22 00:00:00 | 1.005370530887255 | 1.002523015508135 | 1.002178257532276
2008-02-23 00:00:00 | 0 | 0 | 0
2008-02-24 00:00:00 | 0 | 0 | 0
2008-02-25 00:00:00 | 1.002542590607475 | 1.000211550666385 | 1.000413186147246
2008-02-26 00:00:00 | 0.9975257148916616 | 0.9983970077477958 | 0.998705884782444
2008-02-27 00:00:00 | 0.9950391552390064 | 0.997034162875747 | 0.997849536478616
Spreadsheet: 47997d1247169996-how-to-pull-info-in-column-c-when-a-and-b-match-certain-criteria-sap-log-audit-template-07-09-09-fs
Sheet: 2W - SF

Name | Advocate | Beginning of Year Goals | Mid-Year Updates | End of Year Updates | TOTAL | Student Snapshots TOTAL
Spreadsheet: 377468d1424012030-uniforms-distribution-desired-result
Sheet: Sheet1

BOYS |  |  |  |  |  | GIRLS
ITEM | SIZE | PCS | RATE | AMOUNT | NURSERY | ITEM | SIZE | PCS | RATE | AMOUNT |  | Ratio | Boy | Girl
T Shirt | 22 | 34 | 472 |  |  | T Shirt | 22 | 26 | 472 |  |  | Nursery | 17 | 13
[NAME] | 12 | 34 | 200 |  |  | Skirts | 12 | 26 | 390 |  |  | LKG | 52 | 38
Socks | 1 | 34 | 35 |  |  | Socks | 1 | 26 | 35 |  |  | UKG | 12 | 8
Total |  |  |  |  |  | Total |  |  |  |  |  | 1 | 12 | 8
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 9 | 6
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 9 | 6
ITEM | SIZE | PCS | RATE | AMOUNT | LKG | ITEM | SIZE | PCS | RATE | AMOUNT |  | 4 | 9 | 6
T Shirt | 24 | 104 | 482 |  |  | T Shirt | 24 | 76 | 482 |  |  | 5 | 9 | 6
[NAME] | 12 | 104 | 200 |  |  | Skirts | 12 | 76 | 390 |  |  | Total
Socks | 2 | 104 | 35 |  |  | Socks | 2 | 76 | 35 |  |  | Two sets for each student
Total |  |  |  |  |  | Total
ITEM | SIZE | PCS | RATE | AMOUNT | UKG | ITEM | SIZE | PCS | RATE | AMOUNT
T Shirt | 24 | 24 | 482 |  |  | T Shirt | 24 | 16 | 482
[NAME] | 13 | 24 | 200 |  |  | Skirts | 13 | 16 | 400
Socks | 3 | 24 | 40 |  |  | Socks | 3 | 16 | 40
Total |  |  |  |  |  | Total
ITEM | SIZE | PCS | RATE | AMOUNT | Grade 1 | ITEM | SIZE | PCS | RATE | AMOUNT
T Shirt | 26 | 24 | 493 |  |  | T Shirt | 26 | 16 | 493
[NAME] | 14 | 24 | 221 |  |  | Skirts | 14 | 16 | 410
Socks | 4 | 24 | 40 |  |  | Socks | 4 | 16 | 40
Total |  |  |  |  |  | Total
ITEM | SIZE | PCS | RATE | AMOUNT | [NAME] | ITEM | SIZE | PCS | RATE | AMOUNT
T Shirt | 28 | 18 | 503 |  |  | T Shirt | 28 | 12 | 503
[NAME] | 14 | 18 | 221 |  |  | Skirts | 14 | 12 | 410
Socks | 4 | 18 | 40 |  |  | Socks | 4 | 12 | 40
Total |  |  |  |  |  | Total
ITEM | SIZE | PCS | RATE | AMOUNT | [NAME] | ITEM | SIZE | PCS | RATE | AMOUNT
T Shirt | 30 | 18 | 514 |  |  | T Shirt | 28 | 12 | 503
[NAME] | 16 | 18 | 242 |  |  | Skirts | 16 | 12 | 420
Socks | 4 | 18 | 40 |  |  | Socks | 4 | 12 | 40
Total |  |  |  |  |  | Total
ITEM | SIZE | PCS | RATE | AMOUNT | [NAME] | ITEM | SIZE | PCS | RATE | AMOUNT
T Shirt | 32 | 18 | 525 |  |  | T Shirt | 30 | 12 | 514
[NAME] | 16 | 18 | 242 |  |  | Skirts | 16 | 12 | 420
Socks | 5 | 18 | 45 |  |  | Socks | 4 | 12 | 40
Total |  |  |  |  |  | Total
ITEM | SIZE | PCS | RATE | AMOUNT | Grade 5 | ITEM | SIZE | PCS | RATE | AMOUNT
T Shirt | 34 | 18 | 545 |  |  | T Shirt | 32 | 12 | 525
[NAME] | 32 | 18 | 326 |  |  | Skirts | 17 | 12 | 440
Socks | 6 | 18 | 45 |  |  | Socks | 5 | 12 | 45
Total |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  | Discount RS | 50 | 220
 |  |  |  |  |  |  |  | Net Total
 |  |  |  |  |  |  |  | Transport Extra
Spreadsheet: 224446d1364572445-pulling-nth-date-from-large-dataset-test
Sheet: BFA Project Status

Grant Number | Start Date | End Date | # Days to 1st DR | # Days to 2nd DR | Date of last DR | Number of days since last DR
1976 | 2009-07-06 00:00:00 | 2012-03-31 00:00:00
1980 | 2009-07-07 00:00:00 | 2012-03-31 00:00:00
1981 | 2009-07-07 00:00:00 | 2012-03-31 00:00:00
1982 | 2009-07-07 00:00:00 | 2012-03-31 00:00:00
1985 | 2009-07-07 00:00:00 | 2012-03-31 00:00:00
1986 | 2009-07-06 00:00:00 | 2012-03-31 00:00:00
2005 | 2009-07-14 00:00:00 | 2014-09-30 00:00:00
2018 | 2009-07-20 00:00:00 | 2012-01-31 00:00:00
2023 | 2009-07-23 00:00:00 | 2012-09-30 00:00:00
2065 | 2009-07-23 00:00:00 | 2014-09-30 00:00:00
2066 | 2009-09-01 00:00:00 | 2012-01-31 00:00:00
2130 | 2010-04-02 00:00:00 | 2012-06-30 00:00:00
2132 | 2010-04-02 00:00:00 | 2012-06-30 00:00:00
2156 | 2010-05-10 00:00:00 | 2012-06-30 00:00:00
2157 | 2010-05-10 00:00:00 | 2012-06-30 00:00:00
2183 | 2010-06-16 00:00:00 | 2012-06-30 00:00:00
2190 | 2010-06-21 00:00:00 | 2012-06-30 00:00:00
2212 | 2010-07-19 00:00:00 | 2012-09-30 00:00:00
2262 | 2010-09-20 00:00:00 | 2012-09-30 00:00:00
2303 | 2010-11-24 00:00:00 | 2012-12-31 00:00:00
2334 | 2011-02-11 00:00:00 | 2013-09-30 00:00:00
2383 | 2011-05-06 00:00:00 | 2014-06-30 00:00:00
2431 | 2011-07-19 00:00:00 | 2014-09-30 00:00:00
2434 | 2011-07-14 00:00:00 | 2013-09-30 00:00:00
2463 | 2011-08-25 00:00:00 | 2013-09-30 00:00:00
2543 | 2011-09-12 00:00:00 | 2013-09-30 00:00:00
2552 | 2011-09-15 00:00:00 | 2013-09-30 00:00:00
2553 | 2011-09-14 00:00:00 | 2013-09-30 00:00:00
2604 | 2012-03-15 00:00:00 | 2014-03-31 00:00:00
2613 | 2012-03-29 00:00:00 | 2014-03-31 00:00:00
2655 | 2012-06-06 00:00:00 | 2015-06-30 00:00:00
2703 | 2012-07-24 00:00:00 | 2016-09-30 00:00:00
2721 | 2012-08-24 00:00:00 | 2014-09-30 00:00:00
2728 | 2012-09-04 00:00:00 | 2014-09-30 00:00:00
2733 | 2012-09-04 00:00:00 | 2014-09-30 00:00:00
2788 | 2012-09-14 00:00:00 | 2015-09-30 00:00:00
2821 | 2013-02-13 00:00:00 | 2016-03-31 00:00:00
Spreadsheet: 729760d1619323703-formula-to-count-absences-based-on-criteria-and-matching-dates-updated
Sheet: Sheet1

Employee | Date | Hours Type | Code
[NAME] | 2021-02-01 00:00:00 | LA | #
[NAME] | 2021-02-02 00:00:00 | RF | TS
[NAME] | 2021-02-03 00:00:00 | RF | #
[NAME] | 2021-02-04 00:00:00 | RF | TS
[NAME] | 2021-02-04 00:00:00 | LS | #
[NAME] | 2021-02-08 00:00:00 | RF | TS
[NAME] | 2021-02-09 00:00:00 | RF | #
[NAME] | 2021-02-10 00:00:00 | OS | #
[NAME] | 2021-02-01 00:00:00 | LA | #
[NAME] | 2021-02-02 00:00:00 | RF | #
[NAME] | 2021-02-03 00:00:00 | RF | #
[NAME] | 2021-02-04 00:00:00 | RF | TS
[NAME] | 2021-02-04 00:00:00 | LS | #
[NAME] | 2021-02-08 00:00:00 | RF | TS
[NAME] | 2021-02-09 00:00:00 | RF | TS
[NAME] | 2021-02-10 00:00:00 | OS | #
Spreadsheet: kam_keiser__17824__bookentrytemplate_blank
Sheet: Field Constraints

Field Name | Type | Required? | MaxSize | Values | Notes
BOOKID | Text | Yes | 20 | No spaces | Must be unique
Portfolio Type Code | Text | Yes | 1 | From BookRequest Form/as defined in ERMS
Book Code | Text | Yes | 1 | From BookRequest Form/as defined in ERMS
Book Type Code | Text | Yes | 1 | From BookRequest Form/as defined in ERMS
Region Code | Text | Yes | 15 | From BookRequest Form/as defined in ERMS
Database ID | Text | Yes | 15
Trading Location | Text | Yes | 30 | See dropdown list
Administrator | Text | Yes | 10 | Valid user ID
Book Flag | Text | No | 1 | <blank>, Y, N | Special Validation - see below
Commodity Code | Text | No | 4 | From BookRequest Form/as defined in ERMS
Book Purpose | Text | No | 1 | <blank>, T,h,t,y, from Book Request form/as defined in ERMS
Group ID | Text | No | 15 | GAS, POWER
Benchmark ID | Text | No | 15 | From BookRequest Form/as defined in ERMS
Portfolio Code | Text | No | 10 | From BookRequest Form/as defined in ERMS
Book Comments | Text | No | 128 | Optional user notes about the book
Special Validation
If the Book Type Code is M or Y, then the Book Flag field must have a value (either Y or N)
If the Book Type Code is NOT M or Y, then the Book Flag field must be left empty <blank>
TradingLocation Selection List |  | GROUPLIST | BOOKPURPOSE | BOOKTYPE
AUS POWER |  | GAS | h | D
CAD GAS |  | POWER | t | P
CAD POWER |  |  |  | I
CONTINENTAL PWR |  |  |  | M
EURO STEEL |  |  |  | Y
JAPAN GLOBAL PRODUCTS
PORTLAND GENERAL ELECTRIC
SA GAS
SA POWER
SING GLOBAL PROD
UK COAL
UK EBS
UK GAS
UK GLOBAL PROD
UK PAPER
UK POWER
UNKNOWN
US BRIDGELINE
US COAL
US EBS
US EES GAS
US EES POWER
US EMISSIONS
US ENOVATE
US FINANCIAL
US FREIGHT
US GAS CENTRAL
US GAS CLEBURNE
US GAS WEST
US GAS CENTRAL
US GAS TEXAS
US GAS EAST
US ENOVATE
Spreadsheet: 715835d1611874916-multiple-if-and-statement-with-left-formula-not-working-book2
Sheet: Sheet1

Install | Material | Diameter |  | Answer should be: |  | LEFT Function Formula Only - All correct
Yes | 200OD Test1 |  |  | 15
0 | 25OD Test2 |  |  | 25
Yes | 55ODTest3 |  |  | 10
0 | 99ODTest4 |  |  | 99
Yes | 126OD Test5 |  |  | 15
0 | 12OD Test6 |  |  | 12
0 | 75OD Test7 |  |  | 75
Yes | 10ODTest8 |  |  | 6
Yes | 130ODTest9 |  |  | 15
Spreadsheet: mary_fischer__25617__37D
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 037D
COMPANY NAME     Artemis Fair Value
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY: Sonya City
EXTENSION: 39690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2006 |  | 12-31-2011 |  | 12-31-2016 |  | 12-31-2021 |  | after 12-31-2021 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 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 |  | 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 |  | 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 |  | 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 |  | 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
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: 181170d1347953190-help-with-personal-finance-template-fianance-spreadsheet
Sheet: sept12

September 2012
 | Commbank Credit Card |  | Start Bal: |  |  |  |  | This Months Budget
 | Date | Description | In/Out | Balance | Type | More Info |  | Item | Actual | Allocated
 | 2012-09-03 00:00:00 | xx | 1049.95 |  | Payment |  |  | ATM
 | 2012-09-06 00:00:00 | xx | -30 |  | Petrol |  |  | Accomodation
 | 2012-09-08 00:00:00 | xx | -172.79 |  | Travel |  |  | Clothing | 0
 | 2012-09-10 00:00:00 | xx | -13.9 |  | Food |  |  | Ebay | 0
 | 2012-09-11 00:00:00 | xx | -8.97 |  | Travel |  |  | Entertainment
 | 2012-09-11 00:00:00 | xx | -304 |  | Travel |  |  | Fees
 | 2012-09-11 00:00:00 | xx | -15 |  | Parking |  |  | Food
 | 2012-09-11 00:00:00 | xx | -131.07 |  | One-off |  |  | Misc | 0
 | 2012-09-11 00:00:00 | xx | -4.95 |  | One-off |  |  | One-Off
 | 2012-09-12 00:00:00 | xx | -1.27 |  | Fees |  |  | Parking
 | 2012-09-12 00:00:00 | xx | -43.06 |  | Accomodation |  |  | Petrol
 | 2012-09-13 00:00:00 | xx | -25.01 |  | Petrol |  |  | Travel
 | 2012-09-13 00:00:00 | xx | -7.5 |  | One-Off
 | 2012-09-13 00:00:00 | xx | -0.3 |  | Fees |  |  | TOTAL
 | 2012-09-13 00:00:00 | xx | -20 |  | ATM
 | 2012-09-14 00:00:00 | xx | -40 |  | Entertainment
 | 2012-09-14 00:00:00 | xx | 151 |  | Payment
 | 2012-09-15 00:00:00 | xx | -18 |  | Entertainment
 | Date | Description | Cash Out | Balance | Type | More Info
 | Totals
Spreadsheet: 682320d1592002597-indexing-entire-tables-from-multiple-sheets-in-one-excel-sheet-file-anxious-
Sheet: NOVEMBER 

 | Particulars | AMOUNTS(SHS) | AMOUNTS(SHS)
 | Revenue | 111111
 | Revenue from shows | 222222
 | Gardens | 220000
 | Total revenue | 293333.333333333
 | OPERATING EXPENSES | 347777.833333333
 | Kitchen expenses | 1400500
 | Coffee bar expenses | 1122185.27777778
 | Sauna expenses | 1319240.87301588
 | Accommodation expenses | 1516296.46825397
 | Water expenses | 1713352.06349207
 | Cosmetology expenses | 1910407.65873016
 | Armani Dance troupe expenses | 2107463.25396826
 | Gardens maintenance | 2304518.84920635
 | TOTAL OPEERATING EXPENSES | 2501574.44444445
 | GENERAL EXPENSES | 2698630.03968254
 | Purchase of OVCs food | 2895685.63492064
 | Payment to yak a OVCs home | 3092741.23015873
 | Advance payments | 3289796.82539683
 | Office equipment(Rota trim and files) | 3486852.42063492
 | Firewood expenses | 3683908.01587302
 | Office  equipment maintenance | 3880963.61111111
 | [NAME] to garden cleaner | 4078019.20634921
 | Expense on kitchen stock added | 4275074.8015873
 | Electricity maintenance | 4472130.3968254
 | Payment to labor services | 4669185.9920635
 | SUBTOTAL | 4866241.58730159
 | NET OPERATING EXPENSES | 5063297.18253969
 | NET PROFITS | 5260352.77777778
Spreadsheet: 809842d1671370944-how-to-only-show-data-on-page-soa-mo-10-lf-there-is-data-in-gl-mo-10-oktober-2022-nuut-01
Sheet: SOA MO 9

Statement of Activity
 | Cash Beginning of Period
 | Revenue:
 |  | Total Revenue:
 | Expenses:
 |  | Total Expenses:
 | Net : Income Gain / (Loss)
 | Cash End of Period |  |  |  |  | 4729.26
Spreadsheet: 870286d1716825164-modifying-table-to-be-more-dynamic-book2-1-
Sheet: lepingud

Number | Name | [NAME] | Üürilepingu kood | Code | Kinnistu aadress | Kinnistu piirkond | Client | Kap.komp | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044 | Rem.komp | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044
5 | Name5 |  |  | SEEMNE200 |  |  | Client1 |  |  | 54154.07999999999 | 51154.07999999999 | 53154.07999999999 | 51154.07999999999
6 | Name6 |  |  | PURAVIKU4 |  |  | Client2 |  | 47182.16 | 48182.16 | 49182.16 | 50182.16 | 49182.16
Spreadsheet: 864309d1711534603-booking-document-need-help-booking-ramadhan-ballroom
Sheet: SALES

Guest Names | Number of guests | Term of Payment | Booking Date Code (hhbbtt) | Type of Discount (if any ) | Price per pax | Total in IDR
Spreadsheet: 4410e68b-336c-4bb1-a628-fe3c5ea49b96
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Fig. 5.1.6 - Value added (millions of current euro) and employees in the trade sector. Veneto - Years 2001-2008
 | Source: processing by [NAME] on Istat and Ministry for Economic Development data and estimates
 | Value added (millions of current euro) and employees in the trade sector. Veneto - Years 2001-2008
 |  |  | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
 | Value added |  | 13518 | 13142 | 13600 | 14729 | 14680 | 14876 | 15137 | 15029.19530140505
 | Employees |  | 318347.8622 | 321107.7318 | 329354.7687 | 330450.0098 | 329787.4944 | 335885.922 | 337833 | 336419.1658
 | Source: processing by [NAME] on Istat and Ministry for Economic Development data and estimates
Spreadsheet: 707892d1607525756-powerquery-extracted-data-from-website-not-populating-in-designated-cells-excelforum1334778tennispq17with-ranking
Sheet: Tennis Data

Carpet |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money | ATP/WTA ranking
Timea babos |  | Timea babos | 27 | 357 | 628 | 271 | 0.9 | Carpet | 0.9 | 7243755 | 115
[NAME] |  | [NAME] | 27 | 313 | 499 | 186 | 0.6543 | Clay | 0.6719 | 479742 | 140
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 44045 | 39043
2 | 48392 | 43656
3 | 60040 | 58397
4 | 52770 | 47992
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
2001-06-30 00:00:00 |  |  |  |  | 193992
2001-07-04 00:00:00
Spreadsheet: 600081d1543451381-search-for-text-and-list-in-separate-tabs-based-on-result-sample
Sheet: Data

Transaction ID | Order No | Order date | Status | Due | Contact Name | Comments
4E9CRN | 344497574 | 2018-11-11 15:07:59 | Open | 2018-11-30 15:15:00 | Customer 1 | Comment:[NAME] dealing. Please include free gift
4EG967 | 344325480 | 2018-11-13 09:17:09 | Open | 2018-11-27 09:15:00 | Customer 2 | Comment: [NAME] receipt required
4EGLOR | 344936933 | 2018-11-13 10:40:26 | Open | 2018-11-30 10:45:00 | Customer 3 | Comment:[NAME] dealing. Customer callback required.
4EHHE2 | 344988265 | 2018-11-13 13:05:02 | Open | 2018-11-18 13:15:00 | Customer 4 | Comment:[NAME] arranged free delivery
4F1KAZ | 336148109 | 2018-11-18 13:39:33 | Open | 2018-11-24 13:45:00 | Customer 5 | Comment:Billy has agreed to offer further discount
4F4NW8 | 346388566 | 2018-11-19 12:26:13 | Open | 2018-12-09 12:30:00 | Customer 6 | Comment:Customer complaint
4F9RZC | 161846719 | 2018-11-20 11:36:28 | Open | 2018-11-22 11:45:00 | Customer 7 | Comment: Manager referral. Please send to [NAME].
4FHN2J | 347169192 | 2018-11-21 18:30:12 | Open | 2018-12-04 18:30:00 | Customer 8 | Comment:next advisor to take over complaint
4FEK69 | 346988207 | 2018-11-21 09:56:10 | Open | 2018-11-28 10:00:00 | Customer 9 | Comment: christmas gift
Spreadsheet: 102715d1300698684-unique-max-excelforum
Sheet: Sheet1

Groups | Values | Group Max | Required
A | 1 | 1 | 0
A | 1 | 1 | 0
A | 1 | 1 | 0
B | 1 | 2 | 2
B | 1 | 2 | 2
B | 2 | 2 | 2
C | 1 | 2 | 0
C | 2 | 2 | 0
C | 2 | 2 | 0
D | 2 | 3 | 3
D | 2 | 3 | 3
D | 3 | 3 | 3
Spreadsheet: 478749d1473035578-excel-formula-to-convert-data-range-to-columns-convert-data-to-columns-3-
Sheet: Sheet1

Employee | Work Centre# | Bonus |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre#
[NAME] | 1 | 253 |  | 1 |  |  | 2 |  |  | 3 |  |  | 4
[NAME] | 2 | 255
[NAME] | 3 | 277 |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus
[NAME] | 4 | 244 |  | [NAME] | 258 |  | [NAME] | 255 |  | [NAME] | 287 |  | [NAME] | 259
Duanne Busch | 6 | 256 |  | [NAME] | 253 |  | [NAME] | 122 |  | [NAME] | 277 |  | [NAME] | 244
[NAME] | 6 | 277 |  |  |  |  |  |  |  | [NAME] | 261
Ingrid Jones | 5 | 288 |  | Work Centre# | Employee | Sum of Bonus |  |  |  | [NAME] | 166
[NAME] | 5 | 211 |  | 1 | [NAME] | 258
[NAME] | 7 | 166 |  |  | [NAME] | 253
[NAME] | 3 | 287 |  | 1 Total |  | 511
[NAME] | 3 | 261 |  | 2 | [NAME] | 255
[NAME] | 4 | 259 |  |  | [NAME] | 122
[NAME] | 1 | 258 |  | 2 Total |  | 377
[NAME] | 6 |  |  | 3 | [NAME] | 564
[NAME] |  |  |  |  | [NAME] | 261
Ingrid Jones | 7 | 299 |  |  | [NAME] | 166
[NAME] |  |  |  | 3 Total |  | 991
[NAME] | 2 | 122 |  | 4 | [NAME] | 259
[NAME] | 3 | 166 |  |  | [NAME] | 244
 |  |  |  | 4 Total |  | 503
 |  |  |  | 5 | Ingrid Jones | 288
 |  |  |  |  | [NAME] | 211
 |  |  |  | 5 Total |  | 499
 |  |  |  | 6 | [NAME] | 277
 |  |  |  |  | Duanne Busch | 256
 |  |  |  |  | [NAME]
 |  |  |  | 6 Total |  | 533
 |  |  |  | 7 | Ingrid Jones | 299
 |  |  |  |  | [NAME] | 166
 |  |  |  | 7 Total |  | 465
 |  |  |  | Grand Total |  | 3879
Spreadsheet: 882951d1731426950-calculating-non-overlapping-days-from-2-sets-of-2-dates-dates
Sheet: Sheet1

Arrival Start Date 1 | Departure Date 1 | Arrival Start Date 2 | Departure Date 2 | [NAME] | Departure Date 3 | Arrival Start Date 4 | Departure Date 4 | Visa 1 Start Date | Visa 1 End Date | Visa 2 Start Date | Visa 2 End Date
2023-04-24 00:00:00 | 2023-05-04 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2023-04-24 00:00:00 | 2023-05-03 00:00:00 | 00:00:00 | 00:00:00