tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0ffcc14d-e4fe-4c61-bb27-f00d29fb4ad4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-07-11 10:29:18.570000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.946 | 101.821 | 101.696 | 101.321
3.75 | 101.533 | 101.408 | 101.283 | 100.908 |  | Note: | Refer To Price [NAME]
3.625 | 101.09 | 100.965 | 100.84 | 100.465 |  |  | For all Price Adjs
3.5 | 100.519 | 100.394 | 100.269 | 99.644
3.375 | 99.679 | 99.554 | 99.429 | 98.804
3.25 | 98.803 | 98.678 | 98.553 | 97.928
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.121 | 101.996 | 101.871 | 101.496
3.25 | 101.549 | 101.424 | 101.299 | 100.924
3.125 | 101.221 | 101.096 | 100.971 | 100.596
3 | 100.91 | 100.785 | 100.66 | 100.285
2.875 | 100.327 | 100.202 | 100.077 | 99.452
2.75 | 99.715 | 99.59 | 99.465 | 98.84
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-07-25 10:29:18.570000
30 DAY | 2012-08-09 10:29:18.570000
45 DAY | 2012-08-24 10:29:18.570000
60 DAY | 2012-09-08 10:29:18.570000
90 DAY | 2012-10-08 10:29:18.570000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 685692d1594143162-increase-a-columns-content-value-when-other-columns-content-reach-certain-value-soap-bar-stock-report-july-2020
Sheet: Soap Bar

SOAP BAR STOCK
1 carton = 4 packs X 12 pcs
TGL | INITIAL STOCK |  |  | IN |  |  | OUT |  |  | ENDING STOCK
 | ctn(s) | pack(s) | pc(s) | ctn(s) | pack(s) | pc(s) | ctn(s) | pack(s) | pc(s) | ctn(s) | pack(s) | pc(s)
 |  | when value reach 4, it shld increase the ctn(s) value to 1 | when value reach 12, it shld increase the pack(s) value to 1 |  |  |  |  |  |  |  | when value reach 4, it shld increase the ctn(s) value to 1 | when value reach 12, it shld increase the pack(s) value to 1
2020-07-01 00:00:00 | 5 | 2 | 10 |  | 3 | 4
TOTAL
UOM |  |  |  | ctn(s) | pack(s) | pc(s) | ctn(s) | pack(s) | pc(s)
Spreadsheet: 772472d1647290542-rotating-lookup-value-sample_data
Sheet: Sheet1

[NAME] | EmployeeSSN | EmployeeDOB | Address | City | State | Zip | SpouseName | SpouseDob | SpouseGender | Child1Name | Child1DOB | Child1Gender | Child2Name | Child2DOB | Child2Gender | Child3Name | Child3DOB | Child3Gender | Child4Name | Child4DOB | Child4Gender | Child5Name | Child5DOB | Child5Gender
[NAME] | 123-45-6789 | 1980-01-01 00:00:00 | 123 Main St | Anytown | GA | 12345 | [NAME] | 1985-01-01 00:00:00 | F | Junior Doe | 2010-01-01 00:00:00 | M
[NAME] | 987-65-4321 | 1995-01-01 00:00:00 | 99 Ways | Smalltown | GA | 11111 | [NAME] | 1995-01-01 00:00:00 | F
[NAME] | 555-44-3333 | 1970-01-01 00:00:00 | PO Box 123 | Wherever | GA | 35454 | [NAME] | 1975-01-01 00:00:00 | F | [NAME] | 2005-01-01 00:00:00 | M | [NAME] | 2007-01-01 00:00:00 | F | [NAME] | 2010-01-01 00:00:00 | M
Desired Results
Classification | Name | DOB
E
S
D
E
S
E
S
D
D
D
Spreadsheet: 727412d1617888424-create-not-combine-a-master-sheet-from-several-sheets-example-master
Sheet: Master

Site | Date Data | Drop down Data | More Data | Some more info
Location 3 | 2021-04-07 00:00:00 | Here | Is | Data
Location 1 | 2021-04-08 00:00:00 | Here | Etc | Wow
Location 2 | 2021-04-08 00:00:00 | More | More | Thanks
Location 1 | 2021-04-09 00:00:00 | There | again | mmm
Location 1 | 2021-04-10 00:00:00 | Everywhere | good | fab
Location 2 | 2021-04-10 00:00:00 | [NAME] | Near | Great
Location 3 | 2021-04-11 00:00:00 | There | Is | Loads
Location 3 | 2021-04-14 00:00:00 | Thank | You | All
Location 2 | 2021-04-14 00:00:00 | Around | Far | Hello
Spreadsheet: 117843d1313156817-formula-for-different-conditions-and-summaries-excel-example
Sheet: Sheet1

January
Orthopaedics |  |  |  |  |  |  |  |  |  |  |  | User Satisfaction
Name | Hosp no. | Psy no. | IP/OP code | Referral received date | Opt in date | Appt date | Outcome of Assessment | IP waiting time (weeks) | OP waiting time (weeks) | Discharge date | Action | Sent | Received
[NAME] |  |  | IP | 2011-05-29 00:00:00 |  |  |  | 10.71428571428571
BOB |  |  | OP | 2011-06-25 00:00:00 | 2011-07-13 00:00:00 |  |  |  | 4.285714285714286
SARAH |  |  | OP | 2011-08-01 00:00:00 | 2011-08-03 00:00:00 | 2011-08-27 00:00:00 |  |  | 3.428571428571428
DAVE |  |  | IP | 2011-05-08 00:00:00 | 2011-06-08 00:00:00 | 2011-08-28 00:00:00 |  | #N/A
Spreadsheet: 138094d1327510608-lookup-table-according-to-rank-number-entered-copy-of-ranking-question
Sheet: Ranking

 | US | Canada | Brazil | UK
Company 1
Company 2 |  |  | 1 | 10 |  | Ranking | US | Canada | Brazil | UK
Company 3 |  |  |  |  |  | 1
Company 4 |  |  |  |  |  | 2
Company 5 |  |  | 2 | 9 |  | 3
Company 6 | 2 |  |  | 8 |  | 4
Company 7 | 1 | 10 | 3 |  |  | 5
Company 8 | 3 |  | 4 |  |  | 6
Company 9 |  |  | 5 |  |  | 7
Company 10 |  | 9 | 6 | 7 |  | 8
Company 11 | 4 | 8 |  | 6 |  | 9
Company 12 |  | 7 |  | 5 |  | 10
Company 13 |  |  | 7
Company 14 |  | 6 | 8
Company 15 |  | 5 | 9 | 4
Company 16 | 5 | 4 | 10 | 3
Company 17 | 6 | 3 |  | 2
Company 18
Company 19 | 7 | 2
Company 20 | 8
Company 21 |  |  |  | 1
Company 22 | 9
Company 23 | 10
Company 24 |  | 1
Company 25
Spreadsheet: 54704d1254761406-restaurant-inspections-most-recent-date-date-example
Sheet: Sheet1

This is how the data is arranged now
Restaurant Name | Inspection Date
Annie’s Cupcake Factory | 2009-09-08 00:00:00
Burger King | 2005-05-26 00:00:00
Chevy's | 2009-03-01 00:00:00
Chevy's | 2006-04-24 00:00:00
KFC | 2007-02-08 00:00:00
KFC | 2004-05-20 00:00:00
KFC | 2001-06-03 00:00:00
Tacos-a-go-go | 2006-10-05 00:00:00
Tacos-a-go-go | 2004-11-14 00:00:00
Tacos-a-go-go | 2001-08-30 00:00:00
This is how I would like it to look:
Restaurant Name | Inspection Date
Annie’s Cupcake Factory | 2009-09-08 00:00:00
Burger King | 2005-05-26 00:00:00
Chevy's | 2009-03-01 00:00:00
KFC | 2007-02-08 00:00:00
Tacos-a-go-go | 2006-10-05 00:00:00
Spreadsheet: 720793d1614288168-formula-curve-combi
Sheet: down

Steps | Numbers | Range | A: Hor. Asymptote | B: Shape huperbola | C: Vert. Asymptote
1 |  | 800 | 190 | -600 | 2
2
3
4
5
6
7
8 |  | 240
9
10
11
12
13
14
15
16
17
18
19
20 |  | 200
Solver:
Set target cell: F24 (cell with [NAME]() fuction)
Select:Min
By Changing: D2:F2
Spreadsheet: 846467d1697647958-populate-worksheet-based-on-checkboxes-example-workbook
Sheet: DATA

 | Internal Code | Product | Course type | Price (£)
 | P1-OP | P1 | Operation | 50
 | P1-AD | P1 | Administration | 25
 | P1-DI | P1 | Diagnostics | 25
 | [NAME] | P2 | Operation | 50
 | P2-AD | P2 | Administration | 25
 | [NAME] | P2 | Diagnostics | 25
 | P3-AD | P3 | Administration | 30
 | P4-AD | P4 | Administration | 30
 | P5-AD | P5 | Administration | 25
 | P6-AD | P6 | Administration | 30
 | P6-DI | P6 | Diagnostics | 30
Spreadsheet: 69047d1269549258-combobox-property-match-required-has-no-apparent-effect-misbehaving-combobox
Sheet: Sheet1

 | Abidal
 | Babouin
 | Daddy |  |  |  |  |  | [NAME] | You can refer to this field if you need it in a formula
 | Grasiz
 | [NAME]
 | Mic |  |  | "Match Required" property is set to True but I can still enter any value
 | Michlen
 | Mikayil
 | [NAME]
 | Naiboum
 | Nani
 | Nick
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Sasha
Spreadsheet: 701968d1604020248-calculating-a-blended-rate-example-1-
Sheet: Sheet1

 |  | Total # [NAME] | 0 | 2000 | 4000 | 6000 | 8000 | 10000 | >10,000
 |  | Monthly Price Fees | 0 | 200 | 180 | 160 | 140 | 120 | 100
 |  | Total # of Feeds | 700 | 1750 | 2750 | 3500 | 10100
 |  | Total Cost
Spreadsheet: 194007d1353008198-i-need-some-help-with-financial-graphs-spreadsheet
Sheet: Summary

 | PLS Store Number:
Forecasted Tax Revenue
Forecasted  # Checks Cashed
Forecasted Expense Budget
Weekly Summary | # Checks Cashed | Total Deposit Amount | Check Cashing Revenue | Effective Rate | % of Forecast Revenue | Expenses
2011-01-14 00:00:00 | 93 | 5000 | 500 | 0.1 |  | 50
2011-01-21 00:00:00
2011-01-31 00:00:00
2011-02-07 00:00:00
2011-02-14 00:00:00
2011-02-21 00:00:00
2029-02-01 00:00:00
2011-03-07 00:00:00
2011-03-14 00:00:00
2011-03-21 00:00:00
2011-03-31 00:00:00
2011-04-07 00:00:00
2011-04-14 00:00:00
2011-04-21 00:00:00
2011-04-30 00:00:00
TOTAL | 93 | 5000 | 500 | 0.1 |  | 50
Spreadsheet: 213520d1360553167-date-range-to-calendar-holidaycalendarsol4
Sheet: FirstSolWithBasicEC

 | Holiday Sheet
 | Year | 2013-01-01 00:00:00
 | Month | 1900-07-01 00:00:00
 |  | m/d/yyyy-mm/dd/yyyy | <---MUST be in 1or2 character month (ie- 1/01 for jan)/1or2Character day (ie 1/01 for the first)/4 character year (2013, NOT 13) followed by a space(" "), a dash("-"), a space(" "), then  1or2 character month (ie- 1/01 for jan)/1or2Character day (ie 1/01 for the first)/4 character year (2013, NOT 13)
1900-01-01 00:00:00 | Name | Dates Off | Type
1900-02-01 00:00:00 | Person 1 | 5/9/2013 - 5/17/2013 | PTO
1900-03-01 00:00:00 | Person 2 | 08/28/2013 - 08/30/2013 | PTO
1900-04-01 00:00:00 | Person 3 | 09/11/2013 - 09/13/2013 | PTO
1900-05-01 00:00:00 | Person 4 | [NAME] | PTO
1900-06-01 00:00:00 | Person 5
1900-07-01 00:00:00 | Person 6
1900-08-01 00:00:00 | Person 7
1900-09-01 00:00:00 | Person 8
1900-10-01 00:00:00 | Person 9
1900-11-01 00:00:00 | Person 10
1900-12-01 00:00:00 | Person 11
 | Person 12
2000-01-01 00:00:00 | Person 13
2001-01-01 00:00:00 | Person 14
2002-01-01 00:00:00 | Person 15
2003-01-01 00:00:00
2004-01-01 00:00:00
2005-01-01 00:00:00
2006-01-01 00:00:00
2007-01-01 00:00:00
2008-01-01 00:00:00
2009-01-01 00:00:00
2010-01-01 00:00:00
2011-01-01 00:00:00
2012-01-01 00:00:00
2013-01-01 00:00:00
2014-01-01 00:00:00
2015-01-01 00:00:00
2016-01-01 00:00:00
2017-01-01 00:00:00
2018-01-01 00:00:00
2019-01-01 00:00:00
Spreadsheet: 727950d1618228403-extract-records-between-dates-on-multiple-condition-sample-file
Sheet: Sheet1

Table1 |  |  |  |  |  | Records |  | Result for the date | 2020-03-31 00:00:00 | <<<< Result Date
Docno | Originate | Responded |  |  |  |  | Docno | Originate | Responded
345 | 2019-12-07 00:00:00 | 00:00:00 |  |  |  |  | 345 | 2019-12-07 00:00:00 | 00:00:00
378 | 2020-01-08 00:00:00 | 00:00:00 |  |  |  |  | 378 | 2020-01-08 00:00:00 | 00:00:00
482 | 2020-03-04 00:00:00 | 2020-04-14 00:00:00 |  |  |  |  | 482 | 2020-03-04 00:00:00 | 2020-04-14 00:00:00
627 | 2020-05-16 00:00:00 | 2020-06-08 00:00:00 |  |  | [NAME] I used >>>> |  |  | {=IF(ROWS($H$7:H7)>$H$2,INDEX($A$4:$A$10,SMALL(IF($B$4:$B$10<=$J$2,IF($C$4:$C$10=0,IF($C$4:$C$10>$J$2,ROW($C$4:$C$10)-ROW($C$4)+1))),ROWS($H$7:H7))))}
848 | 2020-12-07 00:00:00 | 2021-01-01 00:00:00
1023 | 2021-03-04 00:00:00 | 2021-03-31 00:00:00
1238 | 2021-03-04 00:00:00 | 2021-04-04 00:00:00
 |  |  |  |  |  |  |  | Result for the date | 2021-03-31 00:00:00 | <<<< If I change result date to 31/03/2021 then
 |  |  |  |  |  |  | Docno | Originate | Responded
 |  |  |  |  |  |  | 345 | 2019-12-07 00:00:00 | 00:00:00
 |  |  |  |  |  |  | 378 | 2020-01-08 00:00:00 | 00:00:00
 |  |  |  |  |  |  | 1238 | 2021-03-04 00:00:00 | 2021-04-04 00:00:00
Spreadsheet: 599257d1542930117-match-zipcodes-across-2-sheets-zipcodes-example
Sheet: Sheet1

 | Full Zipcode List
 | 2021
 | 2022
 | 2023
 | 2024
 | 2025
 | 2026
 | 2027
 | 2028
 | 2029
 | 2030
 | 2031
 | 2032
 | 2033
 | 2034
 | 2035
 | 2036
 | 2037
 | 2038
 | 2039
 | 2040
 | 2041
 | 2042
 | 2043
 | 2044
 | 2045
 | 2046
 | 2047
 | 2048
 | 2049
 | 2050
 | 2055
 | 2057
 | 2059
 | 2060
 | 2061
 | 2062
 | 2063
 | 2064
 | 2065
 | 2066
 | 2067
 | 2068
 | 2069
 | 2070
 | 2071
 | 2072
 | 2073
 | 2074
 | 2075
 | 2076
 | 2077
 | 2079
 | 2080
 | 2081
 | 2082
 | 2083
 | 2084
 | 2085
 | 2086
 | 2087
 | 2088
 | 2089
 | 2090
 | 2092
 | 2093
 | 2094
 | 2095
 | 2096
 | 2097
 | 2099
 | 2100
 | 2101
 | 2102
 | 2103
 | 2104
 | 2105
 | 2106
 | 2107
 | 2108
 | 2109
 | 2110
 | 2111
 | 2112
 | 2113
 | 2114
 | 2115
 | 2116
 | 2117
 | 2118
 | 2119
 | 2120
 | 2121
 | 2122
 | 2123
 | 2124
 | 2125
 | 2126
 | 2127
 | 2128
 | 2130
 | 2131
 | 2132
 | 2133
 | 2134
 | 2135
 | 2136
 | 2137
 | 2138
 | 2140
 | 2141
 | 2142
 | 2143
 | 2144
 | 2145
 | 2146
 | 2147
 | 2148
 | 2150
 | 2151
 | 2152
 | 2153
 | 2154
 | 2155
 | 2156
 | 2157
 | 2158
 | 2159
 | 2160
 | 2161
 | 2162
 | 2163
 | 2164
Spreadsheet: gerald_nemec__11391__CostEstimateCarbonBlack
Sheet: FD Costs

ENA TECHNICAL SERVICES
PROJECT COST ESTIMATE ANALYSIS
 | CUSTOMER COMPANY NAME:
 | PROJECT NAME:
 | W.O. NUMBER:
 | PROJECT ENGINEER: |  |  | FILE NAME:
 | REVISION NUMBER:
 | PLANNER / MARKETER:
FIELD DIRECT COSTS
 |  |  |  |  |  |  | W.O.A. | W.O.A. | W.O.A.
 |  |  |  | Est. | Est. | W.O.A. | COST | CONTINGENCY | CONTINGENCY
 |  |  |  | Quantity | Unit | Unit Cost | ESTIMATE | ESTIMATE | EXPLANATION
 |  |  |  |  |  |  | (2/28/2000)
CONSTRUCTION SUPPORT:
 | SURVEY (Preliminary and As-Built) |  |  | 0 | Days | 720 |  | 0
 | FIELD INSPECTION :
 |  | - Construction - 1 Chief Insp. |  | 0 | Days | 330 |  | 0
 |  | - Construction - 1 Craft Insp. |  | 0 | Days | 295 |  | 0
 |  | - Construction - QA Insp. |  | 0 | Days | 0 |  | 0
 |  | - Contruction Management |  | 1 | Days | 480 |  | 0
 | [NAME] |  |  | 1 | Day | 800 |  | 0
 |  | CONSTRUCTION SUPPORT SUB TOTAL
CONTRACT INSTALLATION:
Special Project Team (Labor & Equipment) |  |  |  | 1 | Lp Sum | 6000 |  | 0
Contract Labor & Equipment |  |  |  | 1 | Lp Sum | 500 |  | 0
Special Project Team |  |  |  | 4 | Days | 240 |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  | CONTRACT INSTALLATION SUB TOTAL
FIELD DIRECT SUB TOTAL
CONTINGENCIES
FIELD DIRECT SUB TOTAL WITH CONTINGENCIES
TOTAL INSTALLED COST (Labor + Material)
CONTINGENCIES
TOTAL INSTALLED COST (Labor + Material) WITH CONTINGENCIES
Spreadsheet: 288831d1389310442-sort-mfmfmfm-instead-of-mmmfff-copy-of-seating-plan
Sheet: Register

10EH
Name | Gender |  | SEN/FSM | Target | Sort
[NAME] | f | 1 | Sen | A
[NAME] | m | 2 | Sen | B
Gemma | f | 3 |  | C
[NAME] | m | 4 |  | A
[NAME] | f | 5 |  | D
[NAME] | m | 6 |  | C
[NAME] | f | 7 | Sen | B
[NAME] | m | 8 |  | D
George | f | 9 | FSM | E
[NAME] | m | 10 |  | A
Penny | f | 11 | Sen | D
Freddie | m | 12 | FSM | B
Emily | f | 13 |  | A
[NAME] | m | 14 |  | C
[NAME] | f | 15 | FSM | B
[NAME] | m | 16 |  | E
[NAME] | f | 17 |  | C
[NAME] | m | 18 |  | E
Emma | f | 19 |  | D
[NAME] | m | 20 |  | A
Georgie | f | 21 |  | C
Jonny | m | 22 |  | B
Jasmine | f | 23 |  | D
[NAME] | m | 24 |  | B
[NAME] | f | 25 | Sen | E
Derek | m | 26 |  | C
Zoe | f | 27 |  | B
Mattias | m | 28 |  | C
Danielle | f | 29 |  | A
Tobias | m | 30 |  | D
[NAME] | f | 31 |  | B
Rachel | f | 33 |  | A
Spreadsheet: 772451d1647279088-match-fields-and-return-more-than-1-result-example
Sheet: Data sheet

 | Company | Services offered 1 | Services offered 2 | Location covered 1 | Locationcovered 2
 | Blount | Sweeping | Bake | Greensboro | [NAME]
 | Severson | Dusting | Clean | Las Vegas | [NAME]
 | Dever | Paint | [NAME] | Omaha | New York
 | [NAME] | [NAME] | Prep | New York | Southingford
 | Higa | laundry | Build | Las Vegas | Factby
 | Swink | Meals | [NAME] | Santa Ana | West Lunview
 | [NAME] | Paint | [NAME] | Cleveland | West Greenside
 | Blair | Dusting | Clean | Montgomery | Summercaster
 | Doering | Sweeping | Bake | Greensboro | [NAME]
 | Mares | Vacuuming | Clean | Huntington | [NAME]
 | Cosgrove | Paint | [NAME] | New York | Passland
 | Halliday | Paint | Prep | New York | Southingford
 | Vannoy | laundry | Build | Las Vegas | Factby
 | [NAME] | Meals | [NAME] | Santa Ana | West Lunview
 | [NAME] | Paint | [NAME] | Cleveland | West Greenside
 | [NAME] | Dusting | Clean | Las Vegas | Summercaster
 | [NAME] | Sweeping | Build | Greensboro | [NAME]
 | Cavazos | laundry | Clean | Huntington | Passland
 | Mattox | Meals | Prep | Omaha | Southingford
 | Early | Vacuuming | Bake | New York | Factby
Spreadsheet: 94481d1294278813-excel-2007-formula-based-on-condition-across-sheets-book4
Sheet: Sheet1

 |  |  |  |  | 12345 | a | aa | aaaa
 |  |  |  |  | 12346 | b | bb | bbbb
 |  |  |  |  | 12347 | c | cc | cccc
 |  |  |  |  | 12348 | d | dd | dddd
 |  |  |  |  | 12349 | e | ee | eeee
 |  | f | ff | ffff | 12350
 |  | g | gg | gggg | 12351
 |  | h | hh | hhhh | 12352
 |  | i | ii | iiii | 12353
 |  | j | jj | jjjj | 12354
 |  | k | kk | kkkk | 12355
Spreadsheet: 605760d1547251528-populate-name-vacation-date-information-into-calendar-format-in-separate-tab-ef159_vacation_calendar
Sheet: Leave_booker

Ref | Date | Name | Leave_type
 | 2013-01-02 00:00:00 | Sean | v |  | [NAME] in column A already copied down to A300 - copy further as required
 | 2013-01-02 00:00:00 | [NAME] | v
 | 2013-01-02 00:00:00 | CJ | v
 | 2013-01-02 00:00:00 | Adam | v
 | 2013-01-02 00:00:00 | Erin | v
 | 2013-01-02 00:00:00 | [NAME] | v
 | 2013-01-02 00:00:00 | [NAME] | v
 | 2013-01-02 00:00:00 | Mark | v
 | 2013-01-02 00:00:00 | [NAME] | v
 | 2013-01-02 00:00:00 | Trinny | v
 | 2013-01-02 00:00:00 | Yelena | s
 | 2013-01-02 00:00:00 | [NAME] | s
 | 2013-01-01 00:00:00 | HOLIDAY | v
 | 2013-01-21 00:00:00 | HOLIDAY | v
 | 2013-02-18 00:00:00 | HOLIDAY | v
 | 2013-03-29 00:00:00 | HOLIDAY | v
 | 2013-05-27 00:00:00 | HOLIDAY | v
 | 2013-07-04 00:00:00 | HOLIDAY | v
 | 2013-09-02 00:00:00 | HOLIDAY | v
 | 2013-11-28 00:00:00 | HOLIDAY | v
 | 2013-12-25 00:00:00 | HOLIDAY | v
 | 2013-01-07 00:00:00 | [NAME] | v
 | 2013-01-08 00:00:00 | [NAME] | v
 | 2013-01-04 00:00:00 | [NAME] | v
Spreadsheet: 66275d1266968314-vlookup-data
Sheet: Week1

Type | Amount
1 | 51
2 | 69
3 | 82
4 | 47
5 | 52
6 | 60
7 | 30
8 | 20
9 | 10
10 | 11
Spreadsheet: 877454d1724286966-pull-data-from-multiple-columns-pull-data-from-multiple-columns
Sheet: Sheet1

Provided | Provided | [NAME] | [NAME] | [NAME] | Manual | Desired Result
Vendor | Description | Vendor Provided | Vendor based on vendor name | Vendor based on invoice | Vendor based on manual search | Desired Result
This Works | Payment | This Works | #N/A | #N/A |  | This Works
 | Accrual for ABC Consulting |  | ABC Consulting | #N/A |  | ABC Consulting
 | Payment in July for Invoice 123 |  | #N/A | Right Time Corporation |  | Right Time Corporation
 | Payment in February for Invoice 456 |  | #N/A | Best in Class LLC |  | Best in Class LLC
 | Payment in January Invoice 789 |  | #N/A | Right Time Corporation |  | Right Time Corporation
 | [NAME] paid for XYZ Technologies |  | XYZ Technologies | #N/A |  | XYZ Technologies
 | [NAME] paid for Anything Consulting LLC |  | Anything Consulting LLC | #N/A |  | Anything Consulting LLC
 | Accrual for Number 1 Consultants |  | Number 1 Consultants | #N/A |  | Number 1 Consultants
 | Payment Rejected |  | #N/A | #N/A | Ok Consultants | Ok Consultants
 | #N/A resulted from [NAME] but can be deleted
Spreadsheet: mary_fischer__25618__42D
Sheet: E4.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  42D
COMPANY NAME  Enron Facility Services
ANALYSIS OF MERCHANT AND OTHER INVESTMENTS
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY: Sonya City
EXTENSION: 39690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-4
 |  | 12-31-2000 Balance |  | Cash Activity |  |  |  |  |  | Income Statement Activity |  |  |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Received - |  | Return of Principal |  | Cash Paid - |  | Realized Gain/(loss) |  | [NAME]) |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | Proceeds  (CR.) |  | (CR.) |  | Additions  DR. |  | DR. / (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Merchant Investment - Non Current:
 |  | 0
Total  (Hyperion Line 0269)
Asset/Expense Accts:  DR/(CR)
Total Notes Receivable - Non Current:
 |  | 0
Total  (Hyperion Line 0270)
Asset/Expense Accts:  DR/(CR)
Total Other Investments:
 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total  (Hyperion line 0280)
Asset/Expense Accts:  DR/(CR)
Hyperion lines 0269 and 0280 are the only accounts needed to prepare this schedule.
Spreadsheet: 90091d1289845819-find-top-5-most-popular-test
Sheet: Month1

 |  |  |  | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mrs. [NAME] | Total taught
 |  |  | Maths1 | 36 | 73
 |  |  | Maths2 | 43 | 21
 |  |  | Maths3 | 53
 |  |  | English1 | 39
 |  |  | English2 | 49
 |  |  | English3 | 34
 |  |  | Science1 |  | 36
 |  |  | Science2 |  | 63
 |  |  | Science3 |  |  | 86
 |  |  | History1 |  |  | 77
 |  |  | History2 |  |  |  | 34
 |  |  | History3 |  |  |  | 76
Spreadsheet: 198625d1354831668-excel-populating-a-calendar-excel-help-upload-6-dec-2012
Sheet: Calendar

 | Week Commencing | 2012-12-10 00:00:00
 |  | Sales Samples Order |  |  |  |  | Sales Samples Manufacture Start |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Samples Ship |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Sales Samples Test/Sell |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Bulk Order 1 Manufacture Start |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
Spreadsheet: 710269d1608816302-counting-weeknum-without-helper-column-weeknum-count
Sheet: Sheet1

Date of Monitoring | Weeknum_helper | Output
2020-11-02 00:00:00 |  |  | <--Expected Output weeknum 1
2020-11-02 00:00:00 |  |  | <--Expected Output weeknum 2
2020-11-02 00:00:00 |  |  | "
2020-11-02 00:00:00 |  |  | "
2020-11-02 00:00:00 |  |  | "
2020-11-02 00:00:00
2020-11-02 00:00:00
2020-11-02 00:00:00
2020-11-02 00:00:00
2020-11-02 00:00:00
2020-11-03 00:00:00
2020-11-03 00:00:00
2020-11-03 00:00:00
2020-11-03 00:00:00
2020-11-03 00:00:00
2020-11-03 00:00:00
2020-11-03 00:00:00
2020-11-03 00:00:00
2020-11-03 00:00:00
2020-11-03 00:00:00
2020-11-05 00:00:00
2020-11-05 00:00:00
2020-11-05 00:00:00
2020-11-05 00:00:00
2020-11-05 00:00:00
2020-11-05 00:00:00
2020-11-05 00:00:00
2020-11-05 00:00:00
2020-11-05 00:00:00
2020-11-05 00:00:00
2020-11-09 00:00:00
2020-11-09 00:00:00
2020-11-09 00:00:00
2020-11-09 00:00:00
2020-11-09 00:00:00
2020-11-09 00:00:00
2020-11-17 00:00:00
2020-11-17 00:00:00
2020-11-17 00:00:00
2020-11-17 00:00:00
2020-11-17 00:00:00
2020-11-17 00:00:00
2020-11-17 00:00:00
2020-11-17 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-11-18 00:00:00
2020-12-01 00:00:00