tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9f231d66-8bc9-49c0-a482-bb3ab0d2c2ee
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: |  |  | 2011-07-25 09:14:07.020000
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.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.19 | 101.065 | 100.94 | 100.565
4.625 | 100.226 | 100.101 | 99.976 | 99.601 |  | Note: | Refer To Price [NAME]
4.5 | 99.749 | 99.624 | 99.499 | 99.124 |  |  | For all Price Adjs
4.375 | 99.126 | 99.001 | 98.876
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.654 | 101.529 | 101.404 | 101.029
4 | 101.334 | 101.209 | 101.084 | 100.709
3.875 | 100.933 | 100.808 | 100.683 | 100.308
3.75 | 100.335 | 100.21 | 100.085 | 99.71
3.625 | 99.315 | 99.19 | 99.065
 |  |  |  |  |  | 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 | 2011-08-08 09:14:07.020000
30 DAY | 2011-08-23 09:14:07.020000
45 DAY | 2011-09-07 09:14:07.020000
60 DAY | 2011-09-22 09:14:07.020000
90 DAY | 2011-10-22 09:14:07.020000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 699732d1602746096-formula-to-get-name-corresponding-to-highest-value-book1
Sheet: Sheet1

Call | date | Agent | Client | Call Reason
1 | 2020-10-12 00:00:00 | Agent 1 | FR | General information
1 | 2020-10-14 00:00:00 | Agent 2 | FR | Instruction
1 | 2020-10-12 00:00:00 | Agent 1 | PT | General information
1 | 2020-10-14 00:00:00 | Agent 1 | FR | General information
1 | 2020-10-12 00:00:00 | Agent 3 | PT | Support
1 | 2020-10-12 00:00:00 | Agent 2 | PT | Services
1 | 2020-10-12 00:00:00 | Agent 1 | FR | General information
1 | 2020-10-14 00:00:00 | Agent 3 | PT | Support
1 | 2020-10-14 00:00:00 | Agent 1 | FR | Services
1 | 2020-10-15 00:00:00 | Agent 3 | PT | Support
1 | 2020-10-12 00:00:00 | Agent 3 | FR | Support
1 | 2020-10-14 00:00:00 | Agent 1 | PT | Support
1 | 2020-10-15 00:00:00 | Agent 3 | FR | Instruction
1 | 2020-10-12 00:00:00 | Agent 1 | FR | Services
1 | 2020-10-15 00:00:00 | Agent 2 | FR | Instruction
1 | 2020-10-12 00:00:00 | Agent 1 | FR | Services
Call Top Reason | Agent 1
1 | "Call Reason" 1
2 | "Call Reason" 2
3 | "Call Reason" 3
Spreadsheet: 57860d1258057332-exclude-specific-parameters-in-a-column-while-using-sumifs-book2
Sheet: Sheet1

Date of Check/ Check Request | Quarter | Vendor | Line of Business | Department | Cost | Month | Notes | Shipping | Receiving
2009-01-07 00:00:00 | 1st - 2009 | Co 1 | Shipping | Dep 1 | 30
2009-01-07 00:00:00 | 1st - 2009 | Co 1 | Receiving | Dep 2 | 48
2009-01-14 00:00:00 | 1st - 2009 | Co 2 | Shipping | Dep 1 | 454
2009-01-14 00:00:00 | 1st - 2009 | Co 2 | Shipping | Dep 3 | 124
2009-01-14 00:00:00 | 1st - 2009 | Co 2 | Receiving | Dep 3 | 784
2009-01-14 00:00:00 | 1st - 2009 | Co 2 | Receiving | Dep 2 | 954
2009-01-14 00:00:00 | 1st - 2009 | Co 3 | Receiving | Dep 4 | 32
2009-01-14 00:00:00 | 1st - 2009 | Co 3 | Shipping | Dep 2 | 41
2009-01-14 00:00:00 | 1st - 2009 | Co 3 | Receiving | Dep 3 | 78
2009-01-23 00:00:00 | 1st - 2009 | Co 1 | Receiving | Dep 1 | 12
Spreadsheet: 767081d1644276083-need-help-on-spreadsheet-do-i-need-to-use-vlookup-hlookup-index-match-2022-law-dogs-standings
Sheet: Capos

Capo Crimini
Wk# | Opponent | W | L | PF | PA | MARGIN
1 | Thundermutts
2 | King of Queens
3 | Cajun Coonasses
4 | Wet Farts
5 | Mudcats
6 | [NAME]
7 | Muckdogs
8 | Gator Dawgs
9 | Sharks
10 | Pics Hitmen
11 | Deadbirs
12 | Muckdogs
13 | [NAME]
14 | Deadbirs
15 | Pics Hitmen
16 | Mudcats
17 | Wet Farts
18 | Sharks
19 | Gator Dawgs
20 | Cajun Coonasses
21 | King of Queens
22 | Thundermutts
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2 |  |  |  |  |  | [NAME] |  | Pecos Del |  |  |  | Imbalance
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  | Month | Measured | Scheduled | Measured | Scheduled | Imbalance | Index | Amount
1 | -39508 | 217 |  | -39867 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -355592 | 0 | -350072 |  | 8.26
2 | -28824 | 217 |  | -29867 |  |  |  |  |  | 2001-02-01 00:00:00 | -609189 | -341536 | -52379 | -306771 |  | 5.62
3 | -29526 | 217 |  | -29867 |  |  |  |  |  | 2001-03-01 00:00:00 | -1830618 | -794902 | -918 | -1033307 |  | 5.03
4 | -30161 | 217 |  | -15867 |  |  |  |  |  | 2001-04-01 00:00:00 | -3230259 | -1322613 |  | -2164184 |  | 4.99
5 | -37240 | 217 |  | -50976 |  |  |  |  |  | 2001-05-01 00:00:00 | -3482702 | -2020658 | -252797 | -1732396 |  | 4.01
6 | -28035 | -1757 |  | -26019 |  |  |  |  |  | 2001-06-01 00:00:00 | -3938526 | -3382042 |  | -1643833 |  | 3.51
7 | -41922 | -5885 |  | -34934 |  |  |  |  |  | 2001-07-01 00:00:00 | -3894744 | -2543771 | -671221 | -1981645 |  | 2.94
8 | -54425 | 217 |  | -54667 |  |  |  |  |  | 2001-08-01 00:00:00 | -4170940 | -3265860 | -1648101 | -2554228 |  | 2.85
9 | -59844 | -9648 |  | -49867 |  |  |  |  |  | 2001-09-01 00:00:00 | -3023464 | -2576525 | -92729 | -544473 |  | 1.96
10 | -59937 | -9648 |  | -49867 |  |  |  |  |  | 2001-10-01 00:00:00 | -2576641 | -1740603 | -37750 | -877765 |  | 2.15
11 | -60137 | -9648 |  | -49867 |  |  |  |  |  | 2001-11-01 00:00:00 | -2598109 | -1780898 | -233298 | -1038459 |  | 2.07
12 | -64055 | -33560 |  | -29867 |  |  |  |  |  | 2001-12-01 00:00:00 | -1166081 | -133483 |  | -1006789 |  | 2.26
13 |  |  |  |  |  |  |  |  |  | 2002-01-01 00:00:00
14
15
16
17
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -591014.35
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2002-01-31 00:00:00 |  |  | 9867
 |  |  |  | 2002-02-11 00:00:00
 | CBS Volume
 |  |  |  | 32476
 |  |  |  |  |  |  | 179468
 |  |  |  |  |  |  | 82546
Spreadsheet: 699228d1602494718-countif-for-single-cells-not-in-a-range-countif-example-
Sheet: Sheet1

VEHICLE TYPES | CONTACT
CAR | Y
CAR
BICYCLE | Y
UNICYCLE | Y
SCOOTER
VAN
TRUCK
BICYCLE | Y
SCOOTER
CAR | Y
TOTAL CONTACT
VEHICLE TYPE SUMMARY | QUANTITY | NO OF CONTACTS PER TYPE
CAR | 3
BICYCLE | 2
UNICYCLE | 1
SCOOTER | 2
VAN | 1
TRUCK | 1
Spreadsheet: 274006d1382980435-combine-2-worksheets-and-do-multiple-column-vlookups-ex_combine-and-vlookup-multiple-columns
Sheet: EX_B

PR ID | AR - Device Problem Code 4
262888 | NV - Catheter hub friction
262888 | NV - Catheter, coil jammed
262893 | NV - Catheter has difficulty tracking over guidewire
262896 | NV - Stent delivery catheter friction
262896 | NV - Stent failed/unable to deploy
262896 | NV - Patient Complications
262904 | NV - Guidewire proximal section kinked/bent
262918 | NV - Patient Stroke
262918 | NV - Patient Complications
263158 | NV - Coil in catheter friction
263158 | NV - Coil delivery wire kinked/bent
263161 | NV - Power supply does not power on after sleep mode
263162 | NV - Coil proximal contact kinked/bent
263186 | NV - Coil proximal contact kinked/bent
263187 | NV - Coil in catheter friction
263189 | NV - Stent partial deployment
263189 | NV - Stent failed/unable to deploy
263192 | NV - Stent failed/unable to deploy
263192 | NV - Stent deployed prematurely during use
263192 | NV - Stent delivery catheter friction
263196 | NV - Stent failed/unable to deploy
263200 | NV - Stent deployed prematurely during preparation
263205 | NV - Stent failed/unable to deploy
263205 | NV - Stent deployed prematurely during use
263207 | NV - Stent failed/unable to deploy
263218 | NV - Guidewire distal tip kinked/bent
263339 | NV - Stent stabilizer kinked/bent
263339 | NV - Stent stabilizer/guidewire friction
264064 | NV - Patient Stroke
264064 | NV - Patient Thrombosis(treated vessel)
264216 | NV - Coil introducer sheath kinked/bent
264298 | NV - Embolus
265224 | NV - Main coil difficulty inserting
265224 | NV - Coil introducer sheath friction
265317 | NV - Device foreign matter
265675 | NV - Main coil protrusion
265675 | NV - Coil broken/fractured
265675 | NV - Device interaction with another device
266260 | NV - Guidewire distal tip detached/separated
266313 | NV - Device problem unknown/unclear
266376 | NV - Catheter hub broken/fractured
266378 | NV - Coil in catheter friction
266877 | NV - Coil in catheter friction
266879 | NV - Patient Hemorrhage, Blood Loss with Sequelae
266880 | NV - Patient Hemorrhage, Blood Loss with Sequelae
266881 | NV - Patient Hemorrhage, Blood Loss with Sequelae
267149 | NV - Coil in catheter friction
267511 | NV - Patient Thrombosis(treated vessel)
267511 | NV - Patient Death
267694 | NV - Main coil failed/unable to detach
267694 | NV - Device interaction with another device
267801 | NV - Main coil stretched
267801 | NV - Main coil friction
267804 | NV - Balloon RO marker band not visible under fluoroscopy
Spreadsheet: 16a93b4e-5757-45e3-afe3-1dbd7df830bb
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
 | 8731.0 Building Approvals, Australia
 | TABLE 80. Value of Building Approved, Chain Volume Measures, Original - Tasmania
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
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total houses ;  New ; |  |  | Original | A590527L | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total other residential building ;  New ; |  |  | Original | A590528R | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  New ; |  |  | Original | A590529T | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590530A | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590531C | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590532F | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Tasmania ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590533J | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 10a

Product1 | Cleared2 | Uncleared | TOTAL
Cross-Currency Basis | 0 | 14601927 | 14601927
Cross-Currency Fixed-Fixed | 0 | 421156 | 421156
Cross-Currency Fixed-Float | 0 | 1304057 | 1304057
TOTAL | -
Spreadsheet: 681439d1591572907-index-match-on-non-adjacent-columns-index-match-question
Sheet: Sheet1

 | Index(Match) Question
 | How do I use column B & D in an Index(Match) formula?
 | I don't know what to insert in the shaded cells, B37 and B38.
 | Date | Col 1 | Col 2
 | 2019-01-31 00:00:00 | 110800 | 52000
 | 2019-02-28 00:00:00 | 111255 | 50000
 | 2019-03-31 00:00:00 | 112544 | 51000
 | 2019-04-30 00:00:00 | 110585 | 52500
 | 2019-05-31 00:00:00 | 114200 | 56000
 | 2019-06-30 00:00:00 | 106500 | 58000
 | 2019-07-31 00:00:00 | 108600 | 60000
 | 2019-08-31 00:00:00 | 115900 | 62000
 | 2019-09-30 00:00:00 | 115700 | 58000
 | 2019-10-31 00:00:00 | 109200 | 56000
 | 2019-11-30 00:00:00 | 108500 | 54000
 | 2019-12-31 00:00:00 | 107300 | 52000
 | Solved for Column C
 |  | Last Closing Value
 |  | [NAME]
 |  | Delta of the Max Closing Value and the last Closing Value
 |  | Date of the highest Closing Value
 |  | Nearest Closing Value to current Closing Value
 |  | Date of nearest [NAME] to current Closing Value
 |  | Weeks between last Closing Value and nearest [NAME]
 | Solved for Column D
 |  | Last Closing Value
 |  | [NAME]
 |  | Delta of the Max Closing Value and the last Closing Value
 |  | Date of the highest Closing Value
 |  | Nearest Closing Value to current Closing Value
 |  | Date of nearest [NAME] to current Closing Value
 |  | Weeks between last Closing Value and nearest [NAME]
Spreadsheet: 295246d1391629409-help-transferring-series-of-cells-from-worksheet1-to-worksheet2-to-act-as-a-running-log-example1_alkey
Sheet: Sheet1

ID | Client Name | Date | Status | Comments
101 | [NAME] | 2014-01-02 00:00:00 | 1 | Commets
102 | [NAME] | 2014-01-03 00:00:00 | 2 | Approved
103 | [NAME] | 2014-01-02 00:00:00 | 3 | Regected
104 | Nick | 2014-01-03 00:00:00 | 4 | n/a
105 | [NAME] | 2014-01-02 00:00:00 | 5 | Approved
106 | [NAME] | 2014-01-03 00:00:00 | 5 | Regected
Spreadsheet: 56597d1256756075-counting-blanks-based-on-criteria-in-another-column-book1-1-
Sheet: Sheet4

 |  | Data
Employer | Name | Count of x | Count of e-mail
[NAME] | Goodall | 1 | 1
 | [NAME] | 1 | 1
 | Lyons | 1 | 1
 | [NAME] | 1 | 1
 | Tariq | 1
Ashley Total |  | 5 | 4
[NAME] | Branch | 1 | 1
 | [NAME] | 1 | 1
 | Egbuna | 1
 | Halpin | 1 | 1
 | Jones | 1 | 1
 | Nikolov | 1
 | [NAME] | 1
 | Oakley | 1 | 1
 | [NAME] | 1 | 1
 | [NAME] | 1 | 1
 | Standing | 1 | 1
Chris Total |  | 11 | 8
(blank) | (blank)
(blank) Total
Grand Total |  | 16 | 12
Spreadsheet: 862309d1710061243-dynamic-formula-to-calculate-ordinary-time-overtime-based-on-day-of-week-and-day-night-maggie-090324-query
Sheet: HOURS

[NAME] | Date of Shift | Start Time | End Time | Break Time | Total Hours | Ordinary Hours | Double Time |  |  |  |  |  | 8 | 0
DAY | 3/1/2024 | 7:00:00 | 15:30:00 | 30 | 8 |  |  |  |  |  |  |  | 8
Night | 2/29/2024 | 7:00:00 | 17:30:00 | 30 | 10 |  |  |  | Wrong
shift | 2/27/2024 | 7:00:00 | 16:30:00 | 30 | 9 |  |  |  | Wrong
DAY | 2/27/2024 | 7:00:00 | 15:30:00 | 30 | 8
DAY | 2/28/2024 | 7:00:00 | 15:30:00 | 30 | 8
DAY | 2/27/2024 | 7:00:00 | 17:00:00 | 30 | 9.5 |  |  |  | Correct
DAY | 3/1/2024 | 7:00:00 | 15:30:00 | 30 | 8
DAY | 2/28/2024 | 7:00:00 | 15:30:00 | 30 | 8
DAY | 2/29/2024 | 7:00:00 | 15:30:00 | 30 | 8
Spreadsheet: 659407d1579867142-grouping-consecutive-days-consec-days-v2
Sheet: Output

Employee Number | Sickness Dates | Sick Days
10000 | 01/02/2019 - 06/02/2019 | 3
10000 | 25/02/2019 | 1
10000 | 15/04/2019 - 16/04/2019 | 2
10000 | 19/06/2019 | 1
10000 | 16/09/2019 | 1
10000 | 14/10/2019 | 1
10000 | 04/11/2019 - 06/11/2019 | 3
10000 | 19/11/2019 | 1
Spreadsheet: 863440d1710934488-how-to-index-from-an-array-if-a-cell-matches-a-different-array-how-to-index-from-an-array-if-a-cell-matches-a-different-array
Sheet: Mock-up

Name | Reference | Applicable to | Reference | R-H |  | R-XR |  | A-C
1240.pdf |  | R-H | C001 | N/A | N/A | N/A | N/A | N/A | N/A
 | C006 |  | C002 | some random text 1240.pdf | G | some random text 8213.pdf | G | some random text 7202.pdf | A
 | C007 |  | C003 | N/A | N/A | N/A | N/A | N/A | N/A
 |  |  | C004 | N/A | N/A | N/A | N/A | N/A | N/A
8213.pdf |  | R-XR | C005 | N/A | N/A | N/A | N/A | N/A | N/A
 | C006 |  | C006 | some random text 1240.pdf | G | some random text 8213.pdf | G | some random text 807.pdf | G
 |  |  | C007 | some random text 1240.pdf | G | some random text 201.pdf | G | N/A | N/A
201.pdf |  | R-XR | C008 | N/A | N/A | N/A | N/A | N/A
 | C010 |  | C009 | N/A | N/A | N/A | N/A | some random text 7202.pdf | G
 |  |  | C010 | N/A | N/A | some random text 201.pdf | G | N/A | N/A
7202.pdf |  | A-C
 | C009
807.pdf |  | A-C
Spreadsheet: 010431b2-fb8c-4cf5-acf7-f48a4f0ace3f
Sheet: Sheet1

AMERICAN INSTITUTE OF PHYSICS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
One Physics Ellipse, College Park, MD  20740-3843
AMEX CORPORATE ACCOUNT, TRAVEL EXPENSE VOUCHER
NAME |  |  |  |  | DATE
Address |  |  |  |  | PHONE
 |  |  |  |  | ACCT Name
 |  |  |  |  | ACCT NO.
Purpose of Travel (include person(s) visited and/or nature of visit or meeting)
[NAME]
 | [NAME] | From\To | From\To | From\To | From\To | From\To | From\To
Line |  | Date | Date | Date | Date | Date | Date
No. | DATE |  |  |  |  |  |  | Line
1A | Personal Car Mileage (by Day) |  |  |  |  |  |  | Total
1B | Personal Car (miles x.56 rate) | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | Air/Rail Fare |  |  |  |  |  |  | 0
3 | Car Rental |  |  |  |  |  |  | 0
4 | Parking/Tolls |  |  |  |  |  |  | 0
5 | Cab/Metro Fares |  |  |  |  |  |  | 0
6 | Lodging |  |  |  |  |  |  | 0
7 | Meals |  |  |  |  |  |  | 0
8 | Telephone |  |  |  |  |  |  | 0
9 | Miscellaneous |  |  |  |  |  |  | 0
TOTALS ----------> |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Remarks (Include line no.)
 |  |  |  | 10 | Less: Travel Advance |  |  | 0
 |  |  |  | 11 | Less AmEx Charges |  |  | 0
 |  |  |  | 12 | Amount Due Claimant (Amount Due AIP) |  |  | 0
 |  |  |  | 13
Date | Description (Corporate AMEX) |  | Amount | Date | Description (AMEX)
 |  |  |  |  | Total AMEX Charges -----> |  |  | 0
I certify that the above charges, incurred by me, are correct and proper.
CLAIMANT'S SIGNATURE |  | DATE |  | APPROVED |  |  |  | DATE
Spreadsheet: 703578d1605065693-how-to-detect-the-language-version-of-excel-with-a-formula-not-using-vba-book1
Sheet: Sheet1

ENGLISH | SPANISH |  | a | 1
ABS | ABS |  | b | 2
ADDRESS | DIRECCION |  | c | 3
AND | Y |  |  |  |  |  | [NAME] | Language
AVERAGE | PROMEDIO
AVERAGEIF | PROMEDIO.SI
AVERAGEIFS | PROMEDIO.SI.CONJUNTO
BAHTTEXT | TEXTOBAHT
BIN2DEC | BIN.A.DEC
BIN2HEX | BIN.A.HEX
CEILING | MULTIPLO.SUPERIOR
[NAME] | CARACTER
CHOOSE | ELEGIR
CODE | CODIGO
COLUMN | COLUMNA
COLUMNS | COLUMNAS
CONCATENATE | CONCATENAR
COUNT | CONTAR
COUNTA | CONTARA
COUNTBLANK | CONTAR.BLANCO
COUNTIF | CONTAR.SI
COUNTIFS | CONTAR.SI.CONJUNTO
DATE | FECHA
DATEVALUE | FECHANUMERO
DAY | DIA
DEC2BIN | DEC.A.BIN
DEC2HEX | DEC.A.HEX
EOMONTH | FIN.MES
EVEN | REDONDEA.PAR
EXACT | IGUAL
FACT | FACT
FIND | ENCONTRAR
FLOOR | MULTIPLO.INFERIOR
HEX2BIN | HEX.A.BIN
HEX2DEC | HEX.A.DEC
HLOOKUP | BUSCARH
HYPERLINK | HIPERVINCULO
IF | SI
IFERROR | SI.ERROR
INDEX | INDICE
INDIRECT | INDIRECTO
INFO | INFO
INT | ENTERO
ISBLANK | ESBLANCO
ISERROR | ESERROR
ISEVEN | ES.PAR
ISNA | ESNOD
ISNONTEXT | ESNOTEXTO
ISNUMBER | ESNUMERO
ISODD | ES.IMPAR
ISTEXT | ESTEXTO
LARGE | [NAME]
LEFT | IZQUIERDA
LEN | LARGO
LOOKUP | BUSCAR
LOWER | MINUSC
MATCH | COINCIDIR
MAX | MAX
MEDIAN | MEDIANA
MID | EXTRAE
MIN | MIN
MOD | RESIDUO
MODE | MODA
MONTH | MES
N | N
NA | ND
NETWORKDAYS | DIAS.LAB
NOT | NO
NOW | AHORA
ODD | REDONDEA.IMPAR
OFFSET | DESREF
OR | O
PERCENTILE | PERCENTIL
PI | PI
PROPER | NOMPROPIO
QUARTILE | CUARTIL
RAND | ALEATORIO
RANDBETWEEN | ALEATORIO.ENTRE
RANK | [NAME]
REPLACE | REEMPLAZAR
REPT | REPETIR
RIGHT | DERECHA
ROMAN | NUMERO.ROMANO
ROUND | REDONDEAR
ROUNDDOWN | REDONDEAR.MENOS
ROUNDUP | REDONDEAR.MAS
ROW | FILA
ROWS | FILAS
SEARCH | HALLAR
SMALL | K.ESIMO.MENOR
STDEV | DESVEST
SUBSTITUTE | SUSTITUIR
SUM | SUMA
SUMIF | SUMAR.SI
SUMIFS | SUMAR.SI.CONJUNTO
SUMPRODUCT | SUMAPRODUCTO
TEXT | TEXT
TODAY | HOY
TRANSPOSE | TRANSPONER
TRIM | ESPACIOS
UPPER | MAYUSC
VLOOKUP | BUSCARV
WEEKDAY | DIASEM
WEEKNUM | NUM.DE.SEMANA
YEAR | AÑO
True | VERDADERO
Spreadsheet: 93149d1292687618-sumif-with-various-criteria-distributed-monthly-distribution-of-hours
Sheet: Sheet1

 |  |  |  |  |  | MONTH
HOURS |  | TOTAL |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
SOW | EW | HOURS |  | START | BEGINS | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | TOTAL | CHECK
231 | 620 | 851 |  | 1 | 260 | 260 | 260 | 260 | 71 |  |  |  | 851 | 1
0 | 242 | 242 |  | 2 | 242 |  | 242 |  |  |  |  |  | 242 | 1
120 | 484 | 604 |  | 1 | 150 | 150 | 260 | 194 |  |  |  |  | 604 | 1
186 | 605 | 791 |  | 4 | 260 |  |  |  | 260 | 260 | 260 | 11 | 791 | 1
620 | 605 | 1225 |  | 2 | 90 |  | 90 | 260 | 260 | 260 | 260 | 95 | 1225 | 1
310 | 363 | 673 |  | 3 | 50 |  |  | 50 | 260 | 260 | 103 |  | 673 | 1
124 | 363 | 487 |  | 1 | 80 | 80 | 260 | 147 |  |  |  |  | 487 | 1
186 | 847 | 1033 |  | 2 | 250 |  | 250 | 260 | 260 | 260 | 3 |  | 1033 | 1
28 | 315 | 343 |  | 6 | 120 |  |  |  |  |  | 120 | 223 | 343 | 1
42 | 540 | 582 |  | 4 | 100 |  |  |  | 100 | 260 | 222 |  | 582 | 1
42 | 540 | 582 |  | 5 | 200 |  |  |  |  | 200 | 260 | 122 | 582 | 1
20 | 35 | 55 |  | 1 | 55 | 55 |  |  |  |  |  |  | 55 | 1
 |  | 7468 |  |  |  |  |  |  |  |  |  |  | 7468 | 1
 |  |  |  | 1.  [NAME] from G5 to M16
 |  |  |  | 2.  It is assume each month is 260MHRS per person.
 |  |  |  | 3.  Some people start in the middle or towards the end of the month that's why the column begins is created.
Spreadsheet: 109428d1306281988-excel-2007-countifs-help-report
Sheet: Summary

 | All Tickets |  |  |  |  | test
Technicians | High | Medium | Low | Total |  | High | Medium | Low | Total |  | Sensitive | Pending | In Progress | Assigned | Resolved |  | New Hires | Exiting Employees
test 1
test 2
test 3
test 4
test 5
test 6
test 7
test 8
test 9
test 10
test 11
test 12
 | [NAME] |  |  | % |  |  | Ticket Age (Days) |  |  | Missed SLM
 | In Process |  |  |  |  |  | 2
 | Missed Goal |  |  |  |  |  | 5
 | Pending |  |  |  |  |  | 10
 | Warning |  |  |  |  |  | 15
 | Attached |  |  |  |  |  | 20
 | Detached |  |  |  |  |  | 30
 |  |  |  |  |  |  | over 30
 | Operational Categorization
 | Laptop
 | Upgrade Laptop
 | Laptop's Accessories
 | Mailbox
 | File store. Backup and File Recovery
 | Battery
 | Antivirus/Firewall
 | Oracle
 | Printer
 | User Account
 | Video Conferencing
 | Softphone
 | Office applications
 | [NAME] and [NAME]
 | Distribution List
 | VPN Client
 | LAN Administration