tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 68655d1269255508-look-up-cs
Sheet: Comparison

 |  |  |  |  |  |  |  |  |  |  |  | 1 | Fails Criteria
 |  |  |  |  |  |  |  |  |  |  |  | 2 | Needs Improvement
 |  |  |  |  |  |  |  |  |  |  |  | 3 | Meets Criteria
 |  |  |  |  |  |  |  |  |  |  |  | 4 | High Meets Criteria
Consultant Selection Scorecard |  |  |  |  |  |  |  |  |  |  |  | 5 | Exceeds criteria
Consultancy | Language Requirements | Location | Cost | Approach | Industry Experience | Industry knowledge | Political Experience | Total Solution | Totals |  | MIN | Totals
test co | 2 | 4 | 3 | 4 | 4 | 4 | 2 | 2 | 25 | 1 | Language Requirements | 1 to 23 | Does not meet sufficient criteria
test co 1 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A | 24 - 30 | Meets Criteria
test co 2 | 3 | 2 | 3 | 3 | 4 | 3 | 4 | 5 | 27 | 1 | Location | 31- 40 | [NAME]
test co 3 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
test co 4 | 3 | 4 | 5 | 3 | 5 | 5 | 5 | 4 | 34 | 1 | Language Requirements
test co 5 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
test co 6 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
test co 7 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
test co 8 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
test co 9 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
test co 10 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
test co 11 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
test co 12 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
test co 13 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
 |  |  |  |  |  |  |  |  | 0 | 0 | #N/A
 |  |  | Top Ranking bids
 |  |  | Consultancy | Score | Weakest Point
 |  |  | test co 4 | 34 | Language Requirements
 |  |  | test co 2 | 27 | Location
 |  |  | test co | 25 | Language Requirements
Spreadsheet: 797467d1663911901-date-calculation-error-date-error
Sheet: Sheet1

[NAME] | [NAME] | [NAME] | manual cell | manual cell | manual cell | manual cell | manual cell
A | B | C | E | F | G | H | I
 |  |  | 2022-11-22 00:00:00 | 2022-07-30 00:00:00 | 2022-07-27 00:00:00 | 29/08/2022 | 2022-01-08 00:00:00
 |  |  | 2022-07-21 00:00:00 | 2022-07-21 00:00:00 | 2022-08-03 00:00:00 | 2022-02-08 00:00:00 | 2022-03-08 00:00:00
 |  |  | 2022-07-21 00:00:00 | 2022-07-21 00:00:00 | 2022-08-03 00:00:00 | 2022-02-08 00:00:00 | 2022-03-08 00:00:00
Spreadsheet: 329431d1404309552-calculating-percentage-attendance-from-symbols-example-register
Sheet: Sheet1

Date | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Week | Reasons for absence
Time | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
2013-09-02 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1 |  | / | Attended
2013-09-09 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1 |  |  | Educated offsite
2013-09-16 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1 |  | E | Explained absence
2013-09-23 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1 |  | U | Unauthorised Absence
2013-09-30 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1 |  | A | Authorised Absence
2013-10-07 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1 |  | L | Late
2013-10-14 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1 |  |  | Holiday
2013-10-21 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2013-10-28 00:00:00
2013-11-04 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2013-11-11 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2013-11-18 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2013-11-25 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2013-12-02 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2013-12-09 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2013-12-16 00:00:00 | A | / |  |  |  |  |  |  | / | / | 0.75 | Planning meeting
2013-12-23 00:00:00
2013-12-30 00:00:00
2014-01-06 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-01-13 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-01-20 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-01-27 00:00:00 | / | A |  |  |  |  |  |  | / | / | 0.75 | Medical appointment
2014-02-03 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-02-10 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-02-17 00:00:00
2014-02-24 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-03-03 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-03-10 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-03-17 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-03-24 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-03-31 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-04-07 00:00:00 | / | / |  |  |  |  |  |  | / | / | 1
2014-04-14 00:00:00
2014-04-21 00:00:00
2014-04-28 00:00:00 | / | A | / | / | / | / | / | / | / | / | 0.9 | Hospital appointment
2014-05-05 00:00:00 |  |  | / | / | / | / | / | / | / | / | 1
2014-05-12 00:00:00 | / | / | / | / | / | / | / | / | / | / | 1
2014-05-19 00:00:00 | / | / | / | / | / | / | / | / | / | / | 1
2014-05-26 00:00:00
2014-06-02 00:00:00 | / | / | / | / | / | / | / | / | / | / | 1
2014-06-09 00:00:00 | / | / | / | / | / | / | / | / | / | / | 1
2014-06-16 00:00:00 | / | / | / | / | / | / | / | / | / | / | 1
2014-06-23 00:00:00 | / | / | / | / | / | / | / | / | / | / | 1
2014-06-30 00:00:00 | / | / | / | / | / | A |  |  |  |  |  | Medical appointment
2014-07-07 00:00:00
2014-07-14 00:00:00
2014-07-21 00:00:00
2014-07-28 00:00:00
 |  |  |  |  |  |  |  | Total Attendance
Spreadsheet: 814373d1674323663-need-to-sum-in-a-different-sheet-using-titles-in-current-sheet-to-choose-other-sheets-test
Sheet: CLAIM MANAGEMENT 2023FY

APR |  | 3
 |  | 14
 |  | 84
 |  | 90
 |  | 74
MAY |  | 2
 |  | 56
 |  | 34
 |  | 1
 |  | 2
 |  | 3
 |  | 49
 |  | 100
Jun |  | 91
 |  | 98
Spreadsheet: 38707d1236856530-1-bar-and-2-lines-or-a-better-solution-offered-print-runs
Sheet: Chart Data

 | Date | Daily Print Runs | Daily Print Runs not complete by 12.30pm | Daily Error Print Runs
 | 18th July 2008 | 60 | 12
 |  | 60 | 5
 |  | 60 | 5
 |  | 60 | 8
 | 24th July 2008 | 60 | 6
 |  | 60 | 5
 |  | 60 | 2
 |  | 60 | 11
 | 30th July 2008 | 60 | 1
 |  | 60 | 37
 |  | 60 | 2
 |  | 73 | 1
 | 5th Aug 2008 | 99 | 3
 |  | 70 | 2
 |  | 65 | 0
 |  | 73 | 2
 | [NAME] 2008 | 97 | 0
 |  | 52 | 1
 |  | 92 | 0
 |  | 41 | 0
 | 15th Aug 2008 | 37 | 0
 |  | 31 | 0
 |  | 23 | 0
 |  | 15 | 1
 | 21st Aug 2008 | 15 | 1
 |  | 11 | 0
 |  | 20 | 0
 |  | 14 | 0
 | 28th Aug 2008 | 16 | 0
 |  | 10 | 0
 |  | 16 | 13
 |  | 30 | 3
 | 3rd Sept 2008 | 21 | 8
 |  | 18 | 2
 |  | 15 | 15
 |  | 31 | 31
 | 9th Sept 2008 | 50 | 0
 |  | 16 | 0
 |  | 12 | 0
 |  | 1 | 0
 | 15th Sept 2008 | 28 | 0
 |  | 23 | 0
 |  | 10 | 0
 |  | 17 | 0
 | 19th Sept 2008 | 12 | 0
 |  | 28 | 0
 |  | 18 | 0
 |  | 17 | 0
 | 25th Sept 2008 | 23 | 0
 |  | 25 | 0
 |  | 27 | 27
 |  | 18 | 2
 | 1st Oct 2008 | 25 | 0
 |  | 25 | 0
 |  | 24 | 0
 |  | 14 | 0
 | 7th Oct 2008 | 18 | 0
 |  | 19 | 0
 |  | 26 | 0
 | 10th Oct 2008 | 40 | 0
 |  | 28 | 20
 |  | 19 | 11
 | 15th Oct 2008 | 16 | 1
 |  | 11 | 0
 |  | 21 | 0
 | 20th Oct 2008 | 20 | 3
 |  | 18 | 0
 |  | 14 | 0
 | 23rd Oct 2008 | 15 | 0
 |  | 19 | 17
 |  | 18 | 0
 | 28th Oct 2008 | 18 | 0
 |  | 14 | 0
 |  | 8 | 0
 | 31st Oct 2008 | 13 | 0
 |  | 14 | 0
 |  | 10 | 0
 | 5th Nov 2008 | 12 | 0
 |  | 13 | 0
 |  | 13 | 0
 | 10th Nov 2008 | 8 | 0
 |  | 14 | 0
 |  | 11 | 0
 | 13th Nov 2008 | 12 | 12
 |  | 9 | 0
 |  | 10 | 10
 | 18th Nov 2008 | 12 | 0
 |  | 12 | 0
 |  | 11 | 0
 | 21st Nov 2008 | 7 | 0
 |  | 11 | 0
 |  | 11 | 0
 | 26th Nov 2008 | 11 | 11
 |  | 9 | 0
 |  | 9 | 0
 | 1st Dec 2008 | 7 | 0
 |  | 12 | 0
 |  | 7 | 0
 | 4th Dec 2008 | 10 | 0
 |  | 13 | 0
 |  | 8 | 7
 | 9th Dec 2008 | 15 | 0
 |  | 11 | 0
 |  | 10 | 0
 | 12th Dec 2008 | 8 | 0
 |  | 10 | 0
 |  | 11 | 0
 | 17th Dec 2008 | 7 | 7
 |  | 8 | 0
 |  | 9 | 0
 | 22nd Dec 2008 | 14 | 1
 |  | 13 | 0
 |  | 11 | 0
 | 29th Dec 2008 | 12 | 0
 |  | 12 | 0
 |  | 4 | 0
 | 2nd Jan 2009 | 5 | 0
 |  | 4 | 0
 |  | 4 | 0
 | 7th Jan 2009 | 9 | 0
 |  | 10 | 0
 |  | 8 | 0
 | 12th Jan 2009 | 9 | 0 | 9
 |  | 10 | 0 | 0
 |  | 14 | 0 | 0
 | 15th Jan 2009 | 9 | 0 | 0
 |  | 3 | 3 | 3
 |  | 8 | 0 | 0
 | 19th Jan 2009 | 11 | 0 | 0
 |  | 8 | 0 | 8
 |  | 11 | 0 | 0
 | 22nd Jan 2009 | 9 | 0 | 0
 |  | 11 | 0 | 0
 |  | 10 | 0 | 0
 | 27th Jan 2009 | 11 | 0 | 0
 |  | 10 | 0 | 0
 |  | 9 | 0 | 0
 | 30th Jan 2009 | 8 | 0 | 0
 |  | 9 | 0 | 0
 |  | 13 | 0 | 0
 | 4th Feb 2009 | 9 | 0 | 0
 |  | 13 | 0 | 0
 |  | 12 | 0 | 0
 | 9th Feb 2009 | 9 | 0 | 9
 |  | 8 | 0 | 0
 | 11th Feb 2009 | 11 | 0 | 0
 |  | 17 | 0 | 0
 |  | 10 | 1 | 1
 | 16th Feb 2009 | 10 | 0 | 0
 |  | 12 | 0 | 0
 |  | 9 | 0 | 9
 | 19th Feb 2009 | 11 | 0 | 0
 |  | 15 | 0 | 0
 |  | 8 | 0 | 0
 | 24th Feb 2009 | 12 | 0 | 0
 |  | 8 | 0 | 0
 |  | 17 | 0 | 0
 | 27th Feb 2009 | 9 | 0 | 0
 |  | 9 | 0 | 9
 |  | 14 | 0 | 0
 | 4th March 2009 | 10 | 10 | 10
 |  | 10 | 0 | 0
 |  | 9 | 0 | 0
 | 9th March 2009 | 13 | 0 | 0
 |  | 14 | 0 | 14
 | 11th March 2009 | 8 | 0 | 0
Spreadsheet: 26ccd1f0-919e-4a06-bc0c-1b5760b4aa03
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 13. LENDING FINANCE SEASONAL FACTORS, BY PURPOSE
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial finance for fixed loan facilities ; |  |  | Original | A2433160J | 1985-01-01 00:00:00 | 2012-08-01 00:00:00 | 332 | Number | FACTOR | Month | 1
Commercial finance for revolving credit facilities ; |  |  | Original | A2433161K | 1985-01-01 00:00:00 | 2012-08-01 00:00:00 | 332 | Number | FACTOR | Month | 1
Total lease finance commitments ; |  |  | Original | A2433163R | 1985-01-01 00:00:00 | 2012-08-01 00:00:00 | 332 | Number | FACTOR | Month | 1
Personal finance for fixed loan facilities ; |  |  | Original | A2433157V | 1985-01-01 00:00:00 | 2012-08-01 00:00:00 | 332 | Number | FACTOR | Month | 1
Personal finance for revolving credit facilities ; |  |  | Original | A2433158W | 1985-01-01 00:00:00 | 2012-08-01 00:00:00 | 332 | Number | FACTOR | Month | 1
Investment housing, Construction of dwellings for rent and resale ; |  |  | Original | A2434908R | 1985-01-01 00:00:00 | 2012-08-01 00:00:00 | 332 | Number | FACTOR | Month | 1
Investment housing, Purchase for rent/resale by individuals ; |  |  | Original | A2434909T | 1985-01-01 00:00:00 | 2012-08-01 00:00:00 | 332 | Number | FACTOR | Month | 1
Investment housing, Purchase for rent/resale by others ; |  |  | Original | A2434910A | 1985-01-01 00:00:00 | 2012-08-01 00:00:00 | 332 | Number | FACTOR | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 84857d1284961889-selecting-entries-from-a-data-base-vegas-test-pay-sheet
Sheet: List

Rep | Pod | 1st TO | 2nd TO
[NAME] | [NAME] | [NAME] | [NAME]
Coy Smile | [NAME] | Coy Smile | Coy Smile
Debroa Barker | [NAME] | Debroa Barker | Debroa Barker
[NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
Spreadsheet: 837389d1690123782-using-if-index-match-index-match-1-aligw
Sheet: Sheet1

 |  | looking for response=2650(D8)
Im looking for the value in the below table based on A4 which needs to match $B$6,$C$6,or $[NAME] and A5 needs to match an item in column A9:A17
4
Adults 12 and up, Adults 12 and up, Adults 12 and up, Spouse, Invitee, Adults 12 and up
Adults 12 and up, Adults 12 and up, Adults 12 and up, Spouse, Invitee
Adults 12 and up, Adults 12 and up, Adults 12 and up,  Invitee
 | 3 | 2 | 4
[NAME] individually | 1600 | 1350 | 1850
Invitee | 1200 | 2150 | 2650
Guest | 1200 | 2150 | 2650
Spouse | 1200 | 2150 | 2650
Adults 18+ | 750 | 500 | 1000
Adults 12 and up | 750 | 500 | 1000
Child 0 – 3 years | 0 | 0 | 0
Child 4 – 12 years | 550 | 400 | 650
extra room | 450 | 300 | 600
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 601189 | 623742
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 573990 | 562583 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 778154 | 817529
500293 | 262347 | 362939
500302 |  | 6768
500303 | 160874 | 200728
500305 | 612076 | 798448
500307 | 76701 | 84892
500313 |  | 1886
500314
500655 | 408046
500657 | 89074 | 98949
INDEX
2001-07-31 00:00:00 |  |  | -131785.95
2001-08-18 00:00:00
CBS Volume
 |  |  | -81746
Spreadsheet: 161524d1339535964-dates-calulations-between-rows-work-log-logbook
Sheet: DOE

 |  |  |  |  |  |  | Work Package Status -- 05/16/11
 |  |  |  |  |  |  | DOE Review
 | Package # |  |  |  | Description |  | Type |  |  |  | Planner | Owner | Status
CNS-FWP-3140 |  |  |  |  | E1/G1 Cold & Dark Electrical Isolations |  | 1 |  |  |  | Ciullo
CNS-FWP-1119 |  |  |  |  | Troubleshooting & Repair of Minor Electrical Work (encompasses [NAME]) |  | C |  |  |  | Gross
CNS-FWP-1202 |  |  |  |  | Relocate [NAME] from H2 Building South Side |  | 1 |  |  |  | Gross
CNS-FWP-1203 |  |  |  |  | Troubleshooting & Repair of Minor Mechanical Work |  | C |  |  |  | Gross
CNS-FWP-1206 |  |  |  |  | Installation of Intrinsically Safe Relays on [NAME] |  | 1 |  |  |  | [NAME]
CNS-FWP-0110 |  |  |  |  | Miscellaneous Equipment & Vehicle Repair & Maintenance |  | C |  |  |  | Lohre
CNS-FWP-1121 |  |  |  |  | Miscellaneous Construction |  | C |  |  |  | Lohre
CNS-FWP-1115 |  |  |  |  | ES & TR-RP-1 Relocation |  | 1 |  |  |  | Lohre
CNS-FWP-1225 |  |  |  |  | Prepare for snow removal/north fence |  | 1 |  |  |  | Fulkerson
CNS-FWP-1220 |  |  |  |  | Snow Removal 2010-11 |  | C |  |  |  | Gardner
CNS-FWP-1025 |  |  |  |  | Move Heavy Equipment from [NAME] |  | 1 |  |  |  | Reed
CNS-FWP-0106 |  |  |  |  | Winterize Excavator |  | 1 |  |  |  | Reed
CNS-FWP-1134 |  |  |  |  | Assemble Crane |  | 1 |  |  |  | Ciullo
CNS-FWP-1207 |  |  |  |  | Retrieve Radioactive Sample Container |  | 1 |  |  |  | Gardner
H2V-FWP-1122 |  |  |  |  | Tank Vault Extended Layup |  | 1 |  |  |  | Reed
CNS-FWP-0103 |  |  |  |  | G2 Characterization |  | 1 |  |  |  | Reed
TYP1-002 |  |  |  |  | Set-Up Back-Up Generator |  | 1 |  |  |  | Ciullo
TYP1-004 |  |  |  |  | G2 Re-Entry |  | 1 |  |  |  | Reed
TYP1-005 |  |  |  |  | Packaging & Repackaging RCRA Waste |  | 1 |  |  |  | Lohre
CWP-007 |  |  |  |  | Move Aerial Lift off of Pad |  | C |  |  |  | Ciullo
CWP-008 |  |  |  |  | Install block heaters |  | C |  |  |  | Ciullo
CWP-009 |  |  |  |  | Prepare D&D Mock-Up |  | C |  |  |  | Gross
CWP-010 |  |  |  |  | Torque breakers in Heat Skids and Opposite Ends in PDP-1 & PDP-2 |  | C |  |  |  | [NAME]
CWP-011 |  |  |  |  | Install heaters in Big Top Tent |  | C |  |  |  | Fulkerson
CWP-012 |  |  |  |  | [NAME] in HSD Pump |  | C |  |  |  | Reed
[NAME] |  |  |  |  | Fix Stairs |  | 1 |  |  |  | Mailhot
CWP-014 |  |  |  |  | Decon HCA in Big Top Tent |  | 1 |  |  |  | Mailhot
TYP1 016 |  |  |  |  | NCR 13--Ferrule Wires |  | 1 |  |  |  | [NAME]
CWP-017 |  |  |  |  | Emergency Power for Heat Skids |  | 1 |  |  |  | Yorke
 | TYP1-033 |  |  |  | [NAME] Excavation |  | 1 |  |  |  | Yorke | Cejka | Received comments.
 | TYP1-027 |  |  |  | Remove interferances |  | 1 |  |  |  | Bannister | Mastriona | Received comments.
Spreadsheet: 1f89586a-f622-437d-b99a-ec5fccedfb80
Sheet: Sheet1

First Name or Business Legal Name | M.I. | Last Name | SSN or EIN | Address 1 | Address 2 | City | State Abrv. | ZIP CODE | 1099 Amount | 1099 Type Choose only one from Below
 |  |  |  |  |  |  |  |  |  | MISC, INT, DIV, LTC, OID, A, B, C, L, G, S
[NAME] | Q | SAMPLE | 123-44-0987 | 444 MAIN STREET | UNIT 123 | ANYWHERE | CA | 12345 | 1412 | MISC   (SAMPLE)
SAMPLE |  |  | 01-0841768 | 5555 ANY STREET | SUITE 678 | ANYWHERE | AZ | 55555 | 2200.99 | MISC   (SAMPLE)
Spreadsheet: 145651d1331675268-index-match-formula-return-n-a-error-phys-class-scrub
Sheet: Actual-Class

 |  | Specialty
 |  | Status
 |  | EBITDA
 |  | Current
 |  | TOT_PHYS
 |  | FY12
 |  | Actual
 |  | YearTotal |  |  |  | Abbr. Yr | Abbr. Market Status | Master
0004 | C2010_New | 1358.07 | C2010 | New | 4 | 2010 | N | #N/A
0031 | C2010_New | -209.18 | C2010 | New | 31 | 2010 | N | #N/A
0055 | C2010_New | -31985.08 | C2010 | New | 55 | 2010 | N | #N/A
0281 | C2010_New | 5872.36 | C2010 | New | 281 | 2010 | N | #N/A
0288 | C2010_New | -5571.090000000011 | C2010 | New | 288 | 2010 | N | #N/A
0291 | C2010_New | 1428.639999999992 | C2010 | New | 291 | 2010 | N | #N/A
0362 | C2010_New | 396.2599999999929 | C2010 | New | 362 | 2010 | N | #N/A
0366 | C2010_New | -29.15 | C2010 | New | 366 | 2010 | N | #N/A
0367 | C2010_New | -39081.45 | C2010 | New | 367 | 2010 | N | #N/A
0368 | C2010_New | -53632.53 | C2010 | New | 368 | 2010 | N | #N/A
0376 | C2010_New | -22362.57 | C2010 | New | 376 | 2010 | N | #N/A
0389 | C2010_New | -14822.06 | C2010 | New | 389 | 2010 | N | #N/A
0586 | C2010_New | -45285.01 | C2010 | New | 586 | 2010 | N | #N/A
Spreadsheet: 887585d1737825155-generating-1-column-of-data-into-a-calendar-reviews-calendar-test_3
Sheet: Family Calendar

 | Treatment Plan Reviews |  |  | 2025
 | Important Dates
birthday | Next Review Date | Client Name | Event Type
2000-01-29 00:00:00 |  | Spiderman |  | G |  | Set the First Day of the Week
2000-02-05 00:00:00 |  | Iron Man |  | H
2000-02-05 00:00:00 |  | Black Widow |  | G
1999-02-26 00:00:00 |  | Captain America |  | G |  | Sunday
1998-01-28 00:00:00 |  | Hawkeye |  | I
1997-01-29 00:00:00 |  | Hulk |  | G
1996-02-12 00:00:00 |  | Antman |  | G |  | Name up to 5 event categories
1995-01-28 00:00:00 |  | Red Guardian |  | I
1994-02-12 00:00:00 |  | [NAME] |  | G
1993-02-26 00:00:00 |  | Storm |  | G |  |  | Past Events
1992-03-12 00:00:00 |  | Deadpool |  | H |  |  | State Holiday
1991-01-28 00:00:00 |  | Wolverine |  | G |  |  | Other Major Events
 |  |  |  |  |  |  | G
 |  |  |  |  |  |  | H
 |  |  |  |  |  |  | I
 |  | New Year's Day |  | State Holiday
 |  | MLK jr Day |  | State Holiday
 |  | Presidents Day |  | State Holiday
 |  | Lincoln Day |  | State Holiday
 |  | Truman Day |  | State Holiday
 |  | Memorial Day |  | State Holiday
 |  | Juneteenth |  | State Holiday
 |  | Independence Day |  | State Holiday
 |  | [NAME] |  | State Holiday
 |  | Veteran's Day |  | State Holiday
 |  | Thanksgiving |  | State Holiday
 |  | Christmas |  | State Holiday
Spreadsheet: 0c90ed0e-8fda-4c9d-91de-1e3c99ccb80e
Sheet: 2012 Top Deals

 |  |  |  |  |  | PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Full Year 2012 - Largest Venture Capital Investments
Qtr | Company | City | State | Industry | Stage of Development | Investment Sequence | Amount | Business Description | Investors
1 | SquareTrade, Inc. | San Francisco | CA | Consumer Products and Services | Later Stage | 4 | 238000000 | Provides extended warranty service for consumer electronics and appliances. | Bain Capital LLC,Bain Capital Ventures
3 | Square, Inc. | San Francisco | CA | IT Services | Expansion | 7 | 200000000 | Square, Inc. provides mobile payment services. | Citi Ventures,Rizvi Traverse Management LLC,Undisclosed Firm
4 | [NAME], Inc. | Hayward | CA | Biotechnology | Later Stage | 9 | 155898000 | [NAME], Inc. operates as a biopharmaceutical company. | Alta Partners,Farallon Capital Management LLC,New Enterprise Associates, Inc.,New Leaf Venture Partners,Undisclosed Firm,Undisclosed Firm,Venrock, Inc.
2 | Fisker Automotive, Inc. | Anaheim | CA | Industrial/Energy | Later Stage | 13 | 147599000 | Fisker Automotive, Inc. designs and manufactures electric vehicles. | Kleiner Perkins Caufield & Byers,New Enterprise Associates, Inc.
1 | Sapphire Energy, Inc. | San Diego | CA | Industrial/Energy | Early Stage | 7 | 139000000 | Sapphire Energy, Inc. develops algae-based green crude oil. | ARCH Venture Partners,Monsanto Corporation,Undisclosed Firm,Venrock, Inc.
1 | Fisker Automotive, Inc. | Anaheim | CA | Industrial/Energy | Later Stage | 12 | 129720000 | Fisker Automotive, Inc. designs and manufactures electric vehicles. | Kleiner Perkins Caufield & Byers,New Enterprise Associates, Inc.
3 | Box, Inc. | Los Altos | CA | Software | Expansion | 10 | 125000200 | Box, Inc. provides a secure content sharing platform. | Bessemer Venture Partners,Draper Fisher Jurvetson International Inc,General Atlantic LLC,New Enterprise Associates, Inc.,SAP Ventures,Scale Venture Partners,The Social+Capital Partnership,Undisclosed Firm
1 | [NAME] | [NAME] | TX | Software | Later Stage | 2 | 116832000 | Provides online data and tools to the oil and gas industry. | Battery Ventures LP,Eastern Advisors Private Fund, L.P.,Insight Venture Partners
2 | Harvest Power, Inc. | Waltham | MA | Industrial/Energy | Expansion | 6 | 112000200 | Provides organic waste management services. | Duff Ackerman & Goodrich LLC,Generation Investment Management LLP,Kleiner Perkins Caufield & Byers,True North Venture Partners, L.P.,Undisclosed Firm,Undisclosed Firm
3 | Elevance Renewable Sciences, Inc. | Woodridge | IL | Biotechnology | Later Stage | 5 | 104360000 | Focused on producing renewable specialty chemicals. | Total Energy Ventures International SAS,Undisclosed Firm
 | Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 883948d1732751482-lambda-and-xlookup-issue-excel-sumif-let-riddle-6-
Sheet: Sheet1

 | Raw data |  |  |  |  |  |  |  | Named ranges
 | Fruits | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 |  |  | References | Name
 | Apples | 2229 | 2366 | 2623 | 2878 | 3001 |  |  | A3:F4 | tblData
 | Pears | 700 | 849 | 1140 | 1294 | 1568 |  |  | B3:G13 | tblDataBody
 | [NAME] | 0 | 0 | 0 | 0 | 0 |  |  | A4:A14 | lstFruits
 | Bananas | 176 | 184 | 219 | 224 | 226 |  |  | C2:G2 | lstMonths
 | Peaches | 7 | 8 | 9 | 10 | 10 |  |  | A18:D20 | tblBundles
 | Cherries | 296 | 207 | 205 | 217 | 222 |  |  | A18:A20 | lstBundles
 | Tomatoes | 155 | 158 | 161 | 164 | 168
 | Dates | 383 | 390 | 397 | 444 | 451
 | Nuts | 0 | 23 | 46 | 35 | 89
 | Raspberries | 4511 | 5622 | 7732 | 8966 | 11132
 | Strawberries | 11877 | 12088 | 15770 | 16041 | 18154
 | Bundles
 | Name | Includes
 | Red | Strawberries | Raspberries | Cherries | Tomatoes
 | Yellow | Pears | Apples | Peaches | Bananas
 | Dry | Nuts | [NAME] | Dates
 | Reports
 | Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- This solution works great enough, but I am looking to simplify it even more.
 | Red |  |  |  |  | =SUM(SUMIFS(B$4:B$14,lstFruits,FILTER(tblBundles,lstBundles=$A25,0)))
 | Yellow |  |  |  |  | Look in January data,in the list of fruits and sum if fruit is included in the bundle filtered to the bundle color.
 | Dry
 | Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- I'd love to have a clean LET function, pass the ranges for months and bundle names to a LAMBDA function
 | Red |  | 18075 | 23868 |  | and spill the values in the table. I banged my head on the SUMIF only accepting ranges issue for days…
 | Yellow | 3112 | 3407 | 3991 |  | Can I use the same FILTER approach, and use a LAMBDA to SUM all the XLOOKUP values for each fruit?
 | Dry | 383 | 413 | 443 |  | I've failed so far…
 | 3 month all table output |  |  |  |  | <- It updates the table correctly (I ca format the dates later), but the main calc seems to havethe same issue.
 |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00
 | Red | 16839 | 18075 | 23868
 | Yellow | 3112 | 3407 | 3991
 | Dry | 383 | 413 | 443
 | [NAME] exploration
 |  |  | Raspberries | Cherries | Tomatoes