tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 870876d1717342751-trying-to-populate-a-cell-with-value-from-a-range-based-on-criteria-in-another-range-lotto-bingo2
Sheet: List

A | 5 | 11 | 20 | 26 | 30 | 37 | 40 | 50 | 53 | 59
B | 3 | 9 | 11 | 14 | 15 | 29 | 31 | 39 | 44 | 58
C | 7 | 18 | 27 | 28 | 29 | 34 | 37 | 43 | 48 | 55
D | 5 | 6 | 9 | 15 | 37 | 38 | 39 | 42 | 52 | 58
E | 8 | 10 | 19 | 29 | 31 | 39 | 44 | 47 | 51 | 57
F | 5 | 12 | 16 | 21 | 22 | 27 | 30 | 43 | 53 | 55
G | 3 | 4 | 11 | 14 | 20 | 24 | 44 | 45 | 52 | 57
H | 5 | 12 | 20 | 22 | 23 | 29 | 30 | 38 | 54 | 56
I | 3 | 10 | 11 | 24 | 33 | 37 | 42 | 46 | 55 | 59
J | 4 | 7 | 11 | 15 | 21 | 26 | 31 | 33 | 34 | 43
K | 8 | 14 | 19 | 21 | 35 | 49 | 51 | 54 | 56 | 59
L | 9 | 12 | 23 | 33 | 34 | 36 | 38 | 40 | 54 | 55
M | 6 | 11 | 17 | 23 | 27 | 29 | 35 | 38 | 48 | 57
N | 2 | 6 | 14 | 20 | 23 | 24 | 29 | 37 | 47 | 49
O | 9 | 11 | 16 | 21 | 23 | 25 | 29 | 52 | 56 | 59
P | 2 | 3 | 7 | 8 | 18 | 26 | 30 | 31 | 36 | 53
Q | 2 | 5 | 16 | 18 | 19 | 26 | 49 | 54 | 55 | 59
R | 12 | 14 | 15 | 16 | 28 | 40 | 42 | 49 | 51 | 52
S | 4 | 7 | 12 | 21 | 28 | 34 | 39 | 42 | 47 | 52
T | 8 | 12 | 17 | 26 | 33 | 34 | 35 | 36 | 38 | 59
U | 1 | 8 | 10 | 42 | 43 | 47 | 56 | 57 | 58 | 59
V | 4 | 8 | 28 | 31 | 39 | 41 | 43 | 44 | 45 | 58
W | 6 | 8 | 12 | 16 | 20 | 32 | 52 | 56 | 57 | 58
X | 7 | 10 | 22 | 23 | 31 | 38 | 41 | 42 | 54 | 57
Y | 2 | 7 | 13 | 14 | 16 | 19 | 25 | 51 | 54 | 59
Y | 3 | 11 | 28 | 29 | 32 | 34 | 42 | 47 | 54 | 58
Z | 6 | 8 | 13 | 27 | 40 | 44 | 45 | 46 | 55 | 58
Z | 2 | 6 | 12 | 14 | 15 | 24 | 30 | 32 | 44 | 45
AA | 4 | 6 | 10 | 11 | 23 | 24 | 42 | 43 | 52 | 58
AA | 8 | 15 | 16 | 18 | 20 | 32 | 33 | 49 | 53 | 57
Spreadsheet: ed8d9b34-dab9-4aba-b207-f7fbaaef6af4
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
REPII | Test | REPII | Rabbit Epithelium, IgE | Rabbit Epithelium, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. and 8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/ 1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
REPII | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
REPII | Result | REPII | Rabbit Epithelium, IgE | Rabbit Epithelium, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6223-2
Spreadsheet: 270527d1381513693-trying-to-cross-reference-agains-a-whole-workbook-priority-new-product
Sheet: Priority

Supplier | [NAME] | Product Needed | Requested by | Date Requested | Comments
Vendor 1 | 12345 | all | myself | 2013-10-11 00:00:00 | Priority
Vendor 2 | 23456 | all | myself | 2013-10-11 00:00:00 | Priority
Vendor 3 | 34567 | all | myself | 2013-10-11 00:00:00 | Priority
Vendor 4 | 45678 | all | myself | 2013-10-11 00:00:00 | Priority
Spreadsheet: chris_germany__1889__Transco_Doyle_confirms_May_2001
Sheet: Sheet2

ENRON POWER MARKETING INC.
PROJECTED BURN RATES
DOYLE
GAS NOMINATIONS
 |  | GAS | GAS
 | DATE | NOMINATED | REQUIREMENT
 |  | via TRANSIT | ESTIMATE | LONG / SHORT | BALANCE
 |  |  |  |  | 0 | estimate
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
GAS FLOW ESTIMATES
 |  |  | ESTIMATED | ESTIMATED
 |  | TOTAL EST | TOTAL FLOW | HRLY RATE | ESTIMATED
 | DATE | FLOW HRS | QUANTITY | MMMBTU/HOUR | FLOW HRS (CST)
 |  | 0 |  | 0 | 9:00am - noon
 |  | 0 |  | 0 | 11:45am - 9:00pm
 |  | 0 |  | 0 | 7:00pm - 9:00pm
 |  | 0 |  | 0 | 9:00am - 11:00am
 |  | 0 |  | 0 | 10:45am - 3:00pm
 |  | 0 |  | 0 | 4:00pm - 6:00pm
 |  | 0 |  | 0 | 9:00am - 11:00am
 |  | 0 |  | 0 | 10:45am - 3:00pm
 |  | 0 |  | 0 | 4:00pm - 6:00pm
CONTACT:    [NAME] |  |  | [PHONE]  office |  | DATE / TIME
 |  |  | [PHONE]  pager
Jason Crawford |  |  | [PHONE]  office |  | Generation Control Room (24 Hour)
 |  |  | [PHONE]  pager |  |  | [PHONE]
Spreadsheet: 36494d1234373171-sports-league-table-defining-positions-1st-2nd-etc-sports-scores
Sheet: Sheet1

Name | points 1 | points 2 | points 3 | points 4 | points 5 | points 6 | points 7 | Total | Place
[NAME] | 3 | 4 | 5 | 6 | 7 |  |  |  | 1st Place
[NAME] | 5 | 3 | 7 | 2 | 3 |  |  |  | 2nd Place
[NAME] | 1 | 3 | 5 | 2 | 8 |  |  |  | 3rd Place
if you put the points in, then select the range A1:I4 and sort by total,Largest to smallest
the place will line up because they were not selected.
Spreadsheet: 156532d1337338002-vlookup-match-not-100-sure-sample
Sheet: Sheet2

100 | 2010-03-01 00:00:00 | 2010-03-28 00:00:00 | 247.26
103 | 2012-03-19 00:00:00 | 2012-03-25 00:00:00 | 98.89
104 | 2012-03-12 00:00:00 | 2012-03-25 00:00:00 | 103.85
107 | 2012-03-24 00:00:00 | 2012-04-01 00:00:00 | 42.16
Spreadsheet: 7df768c2-7c18-4063-8244-34d4613a47e0
Sheet: Sheet1

CDBG Missing Data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
GRESHAM OR
Data as of 06/01/2009
Act ID | Status | [NAME] | Matrix CD | Prop Accomp MA04 | Actual [NAME] | Total [NAME] CDBG08 | Create FT Jobs CDBG11 | Create FT Jobs LM CDBG11 | Create PT Hours CDBG11 | Create PT Hours LM CDBG11 | Retain FT Jobs CDBG11 | Retain FT Jobs LM CDBG11 | Retain PT Hours CDBG11 | Retain PT Hours LM CDBG11 | Assist Type CDBG11 | [NAME] CDBG13 | [NAME] CDBG13 | Num Very Low Incm CDBG13 | Units Start CDBG14 | Units [NAME] CDBG14 | Units Occ LM Start CDBG14 | Units Exp CDBG14 | Units [NAME] CDBG14 | Units Occ LM Exp CDBG14 | LMA % CDBG07
267 | 4 | LMH | 13 | 0
Spreadsheet: e0d6f0de-0a84-42f3-9a91-a499e3967619
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 15 | 8727 | 8113 | 7596 | 6834
15 - 65 | 46834 | 42936 | 39024 | 35959
65 und mehr | 18136 | 18368 | 19310 | 19832
Insgesamt | 73697 | 69417 | 65930 | 62625
%
unter 15 | 11.84173032823588 | 11.68733883630811 | 11.52131048081298 | 10.9125748502994
15 - 65 | 63.54939821159613 | 61.85228402264575 | 59.19005005308661 | 57.41956087824352
65 und mehr | 24.60887146016799 | 26.46037714104614 | 29.28863946610041 | 31.66786427145708
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 18.63389844984413 | 18.89556549282653 | 19.46494464944649 | 19.00497789148753
Altenquotient | 38.7240039287697 | 42.77995155580398 | 49.48236982369824 | 55.15170054784616
Gesamtquotient | 57.35790237861382 | 61.67551704863052 | 68.94731447314473 | 74.15667843933369
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 268577d1380700245-how-do-i-auto-populate-a-bookings-sheet-using-date-references-bookings-sheet
Sheet: Bookings Register

Name | Appointment Type | Date | Time | Year | Month | Day
[NAME] | Induction | 2013-11-04 00:00:00 | 13
[NAME] | Failed To Attend | 2013-11-04 00:00:00 | 13
[NAME] | Unsuitable For Course | 2013-11-04 00:00:00 | 13
[NAME] | Induction | 2013-11-05 00:00:00 | 14
[NAME] | One to One | 2013-11-11 00:00:00 | 13.3
[NAME] | Induction | 2013-11-11 00:00:00 | 13
Kirsty king | Failed To Attend | 2013-11-11 00:00:00 | 13
Kirsty Horn | Unsuitable For Course | 2013-11-11 00:00:00 | 13
[NAME] | Failed To Attend | 2013-11-18 00:00:00 | 13
[NAME] | Unsuitable For Course | 2013-11-18 00:00:00 | 13
Kirsty king | One to One | 2013-11-19 00:00:00 | 11.15
[NAME] | Induction | 2013-11-19 00:00:00 | 14
I need the bookings sheet to auto fill as the Month and the Year are selcted into the relvent dates, any dates outside of the selected, but still within the month need to be listed in the Yellow Highlighted Section as they are entered into the list above.
The bookings sheet needs to ignore any items listed in the appointment type other than, Induction, Failed to Attend and Unsuitable for Course. If there is any easier way of getting the date information into the drop down listst I would be most appreciative.
Spreadsheet: 5f7d9f66-4e24-40e0-80d0-532d5e7d1138
Sheet: Corporate VC Sectors

Total Venture Capital and Corporate Venture Capital by Sector  - Last Year
01/01/2012-12/31/2012
MoneyTree Sector | Total # Sector Deals | Average $M Per Deal | Total $M Invested in that Sector by All VC Types | # Deals with CVC Participation | Avg. CVC investment in Those Rounds Participated In | $ CVC Investment | % of CVC Investment $ | % of Deals with CVC Involvement | CVC % of $ In Sector
Biotechnology | 467 |  | 4150.0895 | 91 |  | 454.2522
Business Products and Services | 36 |  | 98.0716 | 1e-16 | 0 | 1e-05
Computers and Peripherals | 48 |  | 453.0271 | 9 |  | 13.4768
Consumer Products and Services | 158 |  | 1205.5068 | 10 |  | 13.6292
Electronics/Instrumentation | 50 |  | 240.295 | 7 |  | 22.0755
Financial Services | 45 |  | 283.816 | 3 |  | 9.4667
Healthcare Services | 44 |  | 310.2121 | 8 |  | 44.1115
Industrial/Energy | 244 |  | 2792.367 | 50 |  | 245.0245
IT Services | 313 |  | 1989.1956 | 42 |  | 242.345
Media and Entertainment | 393 |  | 1871.6993 | 58 |  | 112.748
Medical Devices and Equipment | 316 |  | 2467.4768 | 40 |  | 180.7888
Networking and Equipment | 38 |  | 315.8961 | 7 |  | 23.5206
Other* | 28 | 0 | 52.7599 | 1 |  | 5 | 0 |  | 0
Retailing/Distribution | 59 |  | 498.2438 | 9 |  | 52.2112
Semiconductors | 108 |  | 926.3511 | 18 |  | 110.3325
Software | 1274 |  | 8291.4814 | 195 |  | 604.5987
Telecommunications | 94 |  | 581.3562 | 17 |  | 44.8246
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 873928d1720530077-calculating-business-days-in-a-month-with-a-twist-gti182-business-days-by-year-aligw
Sheet: Sheet1

 |  | Business Days
 | Year
 | 2020
 | 2021
 | 2022
 | 2023
 | 2024
Spreadsheet: 57764d1257972145-automatically-make-new-tables-doctor
Sheet: Total books

 |  | Nr. Boekjes | Datum | Bedrag
 |  | 09*0102 | 2009-12-01 00:00:00 | 95
 |  | 09*0103 | 2009-12-02 00:00:00
 |  | 09*0104
 |  | 09*0105
 |  | 09*0106
 |  | 09*0107
 |  | 09*0108
 |  | 09*0109
 |  | 09*0110
 |  | 09*0111
 |  | 09*0112
 |  | 09*0113
 |  | 09*0114
 |  | 09*0115
 |  | 09*0116
 |  | 09*0117
 |  | 09*0118
 |  | 09*0119
 |  | 09*0120
 |  | 09*0121
 |  | 09*0122
 |  | 09*0123
 |  | 09*0124
 |  | 09*0125
 |  | 09*0126
 |  | 09*0127
 |  | 09*0128
 |  | 09*0129
 |  | 09*0130
 |  | 09*0131
 |  | 09*0132
 |  | 09*0133
 |  | 09*0134
 |  | 09*0135
 |  | 09*0136
 |  | 09*0137
 |  | 09*0138
 |  | 09*0139
 |  | 09*0140
 |  | 09*0141
 |  | 09*0142
 |  | 09*0143
 |  | 09*0144
 |  | 09*0145
 |  | 09*0146
 |  | 09*0147
 |  | 09*0148
 |  | 09*0149
 |  | 09*0150
 |  | 09*0151
 |  | 09*0152
 |  | 09*0153
 |  | 09*0154
 |  | 09*0155
 |  | 09*0156
 |  | 09*0157
 |  | 09*0158
 |  | 09*0159
 |  | 09*0160
 |  | 09*0161
 |  | 09*0162
 |  | 09*0163
 |  | 09*0164
 |  | 09*0165
 |  | 09*0166
 |  | 09*0167
 |  | 09*0168
 |  | 09*0169
 |  | 09*0170
 |  | 09*0171
 |  | 09*0172
 |  | 09*0173
 |  | 09*0174
 |  | 09*0175
 |  | 09*0176
 |  | 09*0177
 |  | 09*0178
 |  | 09*0179
 |  | 09*0180
 |  | 09*0181
 |  | 09*0182
 |  | 09*0183
 |  | 09*0184
 |  | 09*0185
 |  | 09*0186
 |  | 09*0187
 |  | 09*0188
 |  | 09*0189
 |  | 09*0190
 |  | 09*0191
 |  | 09*0192
 |  | 09*0193
 |  | 09*0194
 |  | 09*0195
 |  | 09*0196
 |  | 09*0197
 |  | 09*0198
 |  | 09*0199
 |  | 09*0200
 |  |  |  | 95
Spreadsheet: 791157d1660178132-sumproduct-with-date-11-8-2021-test
Sheet: CALCS

 | TIME
 | START | END | TOTAL TIME | ENTRIES | < ENTRIES | AVE PRICE | TRADED %
 | 08:00:00 | 08:29:59
 | 08:30:00 | 08:59:59
 | 09:00:00 | 09:29:59
 | 09:30:00 | 09:45:59
 | 09:46:00 | 10:29:59
 | 10:30:00 | 11:29:59
 | 14:00:00 | 15:59:59
 | PRICE
 |  |  | ENTRY | ENTRY | ENTRY | POINTS | POINTS
 | LOW | HIGH | SUMIFS | COUNTIFS | AVERAGE | SUMIFS | AVERAGE
 | 0 | 3
 | 3 | 5
 | 5 | 7
 | 7 | 10
 | 10 | 15
 | 15 | 20
 | 20 | 25
 | 25 | 30
 | 30 | 1000
 | CALCULATION DAYS
 | All
 | Reduced
 | SELLING |  | [NAME] | % of Shares
 | GAIN PRICE 1 |  | 0.2 | 0.25
 | GAIN PRICE 2 |  | 1 | 0.25
 | COMM, FEES, & TAX
 |  | Gain | Tax
 | Gross
 | Net
 | MTM | N
 | Comm | 3.5
 | Per Share | 0.0007
 | FROM | RATE | CUMLATIVE
 | 0 | 0.1 | 0
 | 19900 | 0.12
 | 81050 | 0.22
 | 172750 | 0.24
 | 329850 | 0.32
 | 418850 | 0.35
 | 628300 | 0.37
 | CALCULATION DAYS
 | All
 | Reduced
 | COMM, FEES, & TAX
 |  | Gain | Tax
 | Gross
 | Net
 | MTM | N
 | Comm | 3.5
 | Per Share | 0.0007
 | FROM | RATE | CUMLATIVE
 | 0 | 0.1 | 0
 | 19900 | 0.12
 | 81050 | 0.22
 | 172750 | 0.24
 | 329850 | 0.32
 | 418850 | 0.35
 | 628300 | 0.37
Spreadsheet: 860894d1708910728-how-to-pull-up-all-data-from-the-same-value-of-1-column-project-selection-and-shows-information
Sheet: Data

Projects | Start Date | End Date | Activity
A | 2023-12-01 00:00:00 | 2023-12-05 00:00:00 | Workshop and Walkthrough
A | 2023-12-06 00:00:00 | 2023-12-07 00:00:00 | Policy Review
A | 2023-12-08 00:00:00 | 2023-12-12 00:00:00 | Process Creation
A | 2023-12-12 00:00:00 | 2023-12-13 00:00:00 | Process Alignment with Operations, Performance Analytics
B | 2023-12-14 00:00:00 | 2023-12-14 00:00:00 | Process Approval
B | 2023-12-15 00:00:00 | 2023-12-22 00:00:00 | Training
B | 2023-12-18 00:00:00 | 2023-12-18 00:00:00 | Go Live and KMS Updating
B | 2024-01-12 00:00:00 | 2024-01-15 00:00:00 | EG, SG and RPA Stakeholders alignment
C | 2024-01-16 00:00:00 | 2024-01-22 00:00:00 | DCM, Inventory Accounting and PAL Alignment
C | 2024-01-17 00:00:00 | 2024-01-18 00:00:00 | Updating of Policies, Guidelines and Process
C | 2024-01-19 00:00:00 | 2024-01-22 00:00:00 | [NAME] and WI Approval
C | 2024-01-22 00:00:00 | 2024-01-22 00:00:00 | RPA Finalization
D | 2024-01-25 00:00:00 | 2024-02-08 00:00:00 | Training
D | 2024-02-09 00:00:00 | 2024-02-09 00:00:00 | Go Live and KMS Updating
D | 2024-01-15 00:00:00 | 2024-01-16 00:00:00 | Process and Material Gathering and Discovery
Spreadsheet: 875156d1721731745-sum-column-data-in-arrays-from-multiple-sheets-ef1650_sum_multi_sheet
Sheet: 2

151-26 | 150-66 | 150-74 | 153-11 | 150-19 | 153-14 | 152-16 | 153-20 | 153-19 | 152-14 | 153-18 | 153-23
281 | 325 | 642 | 190 | 204 | 263 | 852 | 137 | 19 | 542 | 732 | 97
25 | 513 | 638 | 596 | 652 | 173 | 426 | 506 | 811 | 584 | 627 | 136
787 | 334 | 699 | 806 | 852 | 707 | 213 | 198 | 687 | 728 | 9 | 529
636 | 476 | 799 | 351 | 488 | 10 | 109 | 393 | 182 | 93 | 811 | 46
270 | 399 | 965 | 378 | 945 | 498 | 753 | 995 | 821 | 551 | 465 | 495
221 | 365 | 2 | 516 | 241 | 233 | 97 | 419 | 781 | 986 | 216 | 482
345 | 589 | 873 | 565 | 707 | 32 | 934 | 90 | 995 | 854 | 814 | 133
184 | 836 | 25 | 997 | 572 | 570 | 395 | 69 | 251 | 677 | 518 | 476
569 | 526 | 732 | 103 | 865 | 720 | 547 | 781 | 295 | 335 | 243 | 191
92 | 503 | 864 | 712 | 254 | 514 | 325 | 312 | 666 | 91 | 976 | 291
464 | 391 | 10 | 590 | 307 | 448 | 805 | 490 | 477 | 253 | 78 | 460
669 | 534 | 965 | 812 | 852 | 148 | 783 | 290 | 230 | 204 | 8 | 74
509 | 822 | 616 | 500 | 266 | 811 | 37 | 687 | 1 | 704 | 285 | 921
954 | 819 | 979 | 905 | 198 | 796 | 893 | 135 | 925 | 333 | 61 | 289
906 | 241 | 136 | 406 | 473 | 257 | 17 | 9 | 40 | 919 | 867 | 977
Spreadsheet: 782733d1654211765-converting-decimal-time-to-whole-minutes-timeconversion
Sheet: Sheet1

HOURS | EXTRACT DECIMAL MINUTES | CONVERT TO MINUTES
20458.6 |  |  | OK
30197.11
30245.11
24246.2 |  |  | OK
19220.43
3831.509999999999
29546.01 |  |  | OK
220.9799999999988
15936.91
32439.51
31445.88
6040.159999999999
5322.699999999999 |  |  | OK
21310.05
Spreadsheet: 21375d1208869120-summarizing-multiples-tab-onto-1-tab-example
Sheet: Summary

 | Employee Number | Employee Name | Contract Number
 |  |  |  |  | 10001 | 10002 | 10003
[PHONE] | 30000001 | A Smith | 10001 |  | 300 | 0 | 0
[PHONE] | 30000002 | A Jones | 10001 |  | 400 | 0 | 0
[PHONE] | 30000003 | A [NAME] | 10001 |  | 500 | 0 | 0
[PHONE] | 30000004 | A White | 10002 |  | 0 | 350 | 0
[PHONE] | 30000005 | A Black | 10002 |  | 0 | 450 | 0
[PHONE] | 30000006 | A [NAME] | 10002 |  | 0 | 550 | 0
[PHONE] | 30000001 | A Smith | 10003 |  | 0 | 0 | 100
[PHONE] | 30000003 | A [NAME] | 10003 |  | 0 | 0 | 200
[PHONE] | 30000005 | A Black | 10003 |  | 0 | 0 | 300
Spreadsheet: 356963d1415259979-need-to-link-text-in-column-b-with-a-corresponding-number-from-column-a-but-theres-more-sample-1
Sheet: Sheet1

1
8
4
6
25
1
9
30
5
1
9
Spreadsheet: 846732d1697874260-sum-up-the-daily-requirements-to-match-the-total-objective-target-book1-21-10-2023
Sheet: Chart

 |  |  |  | WEEK / WEEKEND DAYS PERFORMANCE TY VS LY.
AVG.TRAN. | AVG.QTY |  |  | [NAME] | DAY GONE | B.DAY | DAY SUM AED |  | AVG VPT | AVG.PPT
 |  |  |  | SATURDAY
 |  |  |  | SUNDAY
 |  |  |  | MONDAY
 |  |  |  | TUESDAY
 |  |  |  | WEDNESDAY
 |  |  |  | THURSDAY
 |  |  |  | FRIDAY
 |  |  |  | TOTAL:
AVG.TRAN. | AVG.QTY
 |  |  |  |  |  |  |  |  |  |  |  | Balance | 435021.46
 |  |  |  |  |  |  |  |  |  |  |  | Sales Target | 800000 | % | B. Days
 |  |  |  |  |  |  |  |  |  |  |  | Achieved | 364978.54 | 0.456223175 | 11
 |  |  |  |  | Balance D
 |  |  |  |  | Current W |  |  | 2023-10-21 00:00:00
Target | 800000 |  |  |  | W# | WEEK # 1 | WEEK # 2 | WEEK # 3 | WEEK # 4
1st Week |  | W# |  | D.SALE | TARGET MEASUREMENT CHART
 |  | WEEK # 1 | 2023-10-01 00:00:00 | 49194.06 | W# | WEEK # 1 | WEEK # 2 | WEEK # 3 | WEEK # 4
 |  | WEEK # 1 | 2023-10-02 00:00:00 | 14076.98 | WS
 |  | WEEK # 1 | 2023-10-03 00:00:00 | 17037.85 | MT
 |  | WEEK # 1 | 2023-10-04 00:00:00 | 4435.96 | WT |  |  |  |  | =
 |  | WEEK # 1 | 2023-10-05 00:00:00 | 6911.66 | WP
 |  | WEEK # 1 | 2023-10-06 00:00:00 | 28089.29 | %P | 0.25
 |  | WEEK # 1 | 2023-10-07 00:00:00 | 36281.92000000001 | WRD
2nd Week |  | WEEK # 2 | 2023-10-08 00:00:00 | 21802.55 | WDT
 |  | WEEK # 2 | 2023-10-09 00:00:00 | 13668.1
 |  | WEEK # 2 | 2023-10-10 00:00:00 | 48380.53
 |  | WEEK # 2 | 2023-10-11 00:00:00 | 15478.68
 |  | WEEK # 2 | 2023-10-12 00:00:00 | 14927.88
 |  | WEEK # 2 | 2023-10-13 00:00:00 | 4346.19
 |  | WEEK # 2 | 2023-10-14 00:00:00 | 9459.28
3rd Week |  | WEEK # 3 | 2023-10-15 00:00:00 | 16644.77
 |  | WEEK # 3 | 2023-10-16 00:00:00 | 438.1
 |  | WEEK # 3 | 2023-10-17 00:00:00 | 20778.47
 |  | WEEK # 3 | 2023-10-18 00:00:00 | 3135.72
 |  | WEEK # 3 | 2023-10-19 00:00:00 | 32396.54
 |  | WEEK # 3 | 2023-10-20 00:00:00 | 7494.01
 |  | WEEK # 3 | 2023-10-21 00:00:00
4th Week |  | WEEK # 4 | 2023-10-22 00:00:00
 |  | WEEK # 4 | 2023-10-23 00:00:00
 |  | WEEK # 4 | 2023-10-24 00:00:00
 |  | WEEK # 4 | 2023-10-25 00:00:00
 |  | WEEK # 4 | 2023-10-26 00:00:00
 |  | WEEK # 4 | 2023-10-27 00:00:00
 |  | WEEK # 4 | 2023-10-28 00:00:00
 |  | WEEK # 4 | 2023-10-29 00:00:00
 |  | WEEK # 4 | 2023-10-30 00:00:00
 |  | WEEK # 4 | 2023-10-31 00:00:00
Spreadsheet: louise_kitchen__24100__Org Chart
Sheet: Assets

 |  |  |  |  |  |  |  |  | ENA Assets
 |  | Development |  |  |  | QF |  |  | Asset Marketing |  |  | Technical Services |  |  | ECR |  |  | HPL/Other
 |  | Special Projects
 |  | [NAME] |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME], Jr.
 |  | Director |  |  |  | Director |  |  | Director |  |  | Sr Director |  |  | Vice President |  |  | Sr Director
 |  | x36173 |  |  |  | x58957 |  |  | x37493 |  |  | x35353 |  |  | [NAME] |  |  | x35346
 |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
[NAME] |  |  | [NAME] |  |  | Director |  |  | Director |  |  | Sr Director |  |  | Vice President
Director |  |  | Director |  |  | x36027 |  |  | x35629 |  |  | x34648 |  |  | x36332
x35406 |  |  | x39298
 |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
[NAME] |  |  | [NAME] |  |  | Manager |  |  | Manager |  |  | Director |  |  | Sr Director
Manager |  |  | Manager |  |  | x57994 |  |  | x36337 |  |  | x54682 |  |  | x33152
x34205 |  |  | x30433
 |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
[NAME] |  |  | [NAME] |  |  | Manager |  |  | Associate |  |  | Director |  |  | [NAME]
Manager |  |  | Spec Sr Legal |  |  | x53827 |  |  | x33890 |  |  | x58805 |  |  | x39511
X36075 |  |  | x53386
 |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Analyst |  |  | Director |  |  | Sr Geophysicist
 |  |  |  |  |  |  |  |  | x57368 |  |  | x39408 |  |  | x36909
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Director |  |  | Manager
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | x39082
Spreadsheet: 330581d1404806570-plotting-year-wise-maximum-value-and-occurance-date-the-input-date-is-in-text-format-plotting-year-wise-maximum-value-and-date-
Sheet: analysis

Yearwise | [NAME]. Value | [NAME]. Date | [NAME]. Day | Min. Value | Min. Date | Min. Day
2007
2008
2009
2010
Answer for cross verification
2007 | 345.6 | 20070504 |  | 239.55 | 20070203
2008 | 387.35 | 20080702
2009 | 347.15 | 20091231
2010 |  | 20101111
Spreadsheet: 202164d1356372351-automatic-copy-cell-to-another-sheet-if-populated-rehospitalization-tracking-1-
Sheet: May 2013

Client | Facility | Date | Meeting Attendance | Was follow-up appointment made by previous LOC/kept per standard? | Was [NAME] used per standard? | Was follow-up phone call made by previous LOC per standard? | Audit Tool Used | Readmit Avoidable? | If avoidable, did non-compliance with standards contribute? | Notes: | Action Items
Follow up from last meeting
federal government- UTI follow up
Spreadsheet: 719472d1613674236-sumifs-formula-not-valid-value-hh_job_-template_2021-1-
Sheet: Start

Feedlot: | (Enter Customer Name Here) |  |  | Corn |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Crop) | Corn | Silage
Date: | 2020-09-30 00:00:00
Tractors & Loaders | Hrs. | $$/Hr. | Rate Total | Fuel |  |  |  | Invoiced Rate | Invoiced Rate/Hr. | Invoiced Rate/Bu. | Tractors & Loaders | Employee | Bonus Hours
 |  |  |  | Gallons | $$/Gallon | Total | Gal/Hr.
[NAME] 624J #11 | 12 |  |  |  |  |  |  |  |  |  |  | Chad N | 11.5
JD #13 | 45 |  |  |  |  |  |  |  |  |  |  | [NAME] | 11.5
Total
WHO #18 Corn | 12
WHO #21Corn | 12
Total
Grand Total |  |  |  |  |  |  |  |  | Rate Total
 |  |  |  |  | Average Fuel Cost: | 3
 |  |  |  |  | Base Rate: | 3 |  |  | 'Gross Income' less 'Rate Total'
 |  |  |  |  | [NAME]: |  |  |  | Percent Gain or Loss
 |  |  |  |  | Total Gallons:
 |  |  |  |  | Total Surcharge:
Gross Income |  |  |  |  | Total W/Fuel:
Spreadsheet: 126064d1319499631-code-numbers-so-they-display-as-words-vlookupexample
Sheet: Sheet1

Number | Word |  |  | Lookup List
2 | South |  |  | Number | Word
3 | East |  |  | 1 | North
5 |  |  |  | 2 | South
0 |  |  |  | 3 | East
4 | West |  |  | 4 | West
^^Put a number above