tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 686419d1594614654-sum-with-multiple-non-continuous-criteria-and-non-continuous-sum-ranges-array-formula-sample1baa
Sheet: Sheet1

Values | Data1 | Data2
2 | Yes | Yes
1 | Yes | No
4 | No | No
4 | No | Yes
4 | No | No
2 | Yes | Yes
Other info1
3 | No | No
1 | No | Yes
5 | No | No
2 | Yes | Yes
Other info2
1 | No | No
4 | No | Yes
2 | No | No
8 | Yes | Yes
Spreadsheet: 65363d1266035025-work-daily-schedule-work-daily-schedule
Sheet: Sheet1

NAMES | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00
[NAME] | 7a-7
[NAME] | 11a-11
MARY | 7p-7
JACK | 7a-7
[NAME] | 7a-3
2010-01-01 00:00:00 | 7a-11 | 11a-3 | 3p-7 | 7p-11 | 11p-3 | 3a-7p
 | [NAME] | [NAME] | [NAME] | [NAME] | MARY | MARY
 | JACK | [NAME] | [NAME] | MARY
 | [NAME] | JACK | JACK
 |  | [NAME]
Spreadsheet: a89aed3e-203b-473e-ba45-8059e3119f0b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8464 | 56517 | Martin | Schulz | GER | 0 | 00:06:23 | 00:04:19 | [NAME] | 00:00:59 | 00:15:20 | 1 | 01:01:40
8464 | 47904 | Lars | [NAME] | GER | 0 | 00:09:22 | [NAME] | 00:35:58 | 00:00:59 | 00:16:34 | 2 | 01:06:50
8464 | 27264 | [NAME] | [NAME] | AUT | 0 | 00:10:09 | 00:03:49 | 00:33:45 | 00:00:59 | 00:18:14 | 3 | 01:06:58
8464 | 47903 | [NAME] | Hueppe | GER | 0 | 00:11:35 | 00:03:31 | 00:36:40 | 00:00:59 | 00:17:03 | 4 | 01:09:49
8464 | 18492 | Olaf | [NAME] | GER | 0 | [NAME] | [NAME] | 00:41:29 | 00:00:59 | 00:21:55 | 5 | 01:19:40
Spreadsheet: 169262d1342758557-count-sick-day-occurrences-based-on-dates-and-the-duration-of-each-occurrence-in-hours-sick-day-incidents-test
Sheet: Sheet1

EE IDN | Sick Date | Sick Hours on Sick Date | # incidents (manual) | # hours in that incident (manual) | Help1 | Help2 | Workday | Incident | Test |  |  | to count the number or sick occurences per employee #
33567 | 2012-03-19 00:00:00 | 7.5 | 1 |  | Monday | not weekend - 1 separate occurrenc
33567 | 2012-03-22 00:00:00 | 7.5 | 0 |  | Thursday |  |  |  |  |  |  | one sick occurrence equals consecutive sick days off work
33567 | 2012-03-23 00:00:00 | 7.5 | 1 |  |  | a new separate occurrence |  |  |  |  |  | one sick occurrence could be separated by 2 days (a weekend) off work, usually a Friday and Saturdy
54321 | 2011-07-20 00:00:00 | 7.5 | 1 |  |  |  |  |  |  |  |  | for each occurrence for each emmployee, count the # hours in each occurrence
54321 | 2011-10-03 00:00:00 | 7.5 | 1 |  |  |  |  |  |  |  |  | I have tried this formula to get a count of occurrences per employee #:
54321 | 2011-10-18 00:00:00 | 7.5 | 0 |  | no weekend |  |  |  |  |  |  | =IF(AND(A3=A2,(OR(B3=B2+1,B3=B2+3))),0,1)
54321 | 2011-10-19 00:00:00 | 7.5 | 0 |  | no weekend |  |  |  |  |  |  | But I now need to count the duration in #hours of each occurrence for each employee
54321 | 2011-10-20 00:00:00 | 4 | 0 |  | no weekend
54321 | 2011-10-21 00:00:00 | 7.5 | 1 |  | no weekend
55448 | 2011-08-15 00:00:00 | 7.5 | 0
55448 | 2011-08-16 00:00:00 | 7.5 | 1
55448 | 2011-08-29 00:00:00 | 2 | 1 |  |  |  |  |  |  |  | Row Labels | Sum of Sick Hours on Sick Date | Sum of Incident
67894 | 2011-07-21 00:00:00 | 7.5 | 0 |  |  |  |  |  |  |  | 33567 | 22.5 | 2
67894 | 2011-07-22 00:00:00 | 7.5 | 0 |  | Friday | weekend - count within 1 occurrence |  |  |  |  | 54321 | 41.5 | 3
67894 | 2011-07-25 00:00:00 | 7.5 | 0 |  | Monday | weekend - count within 1 occurrence |  |  |  |  | 55448 | 17 | 2
67894 | 2011-07-26 00:00:00 | 3.5 | 0 |  |  |  |  |  |  |  | 67894 | 48.5 | 1
67894 | 2011-07-27 00:00:00 | 7.5 | 0 |  |  |  |  |  |  |  | 99544 | 59 | 3
67894 | 2011-07-28 00:00:00 | 7.5 | 0 |  |  |  |  |  |  |  | Grand Total | 188.5 | 11
67894 | 2011-07-29 00:00:00 | 7.5 | 1
99544 | 2011-10-04 00:00:00 | 7.5 | 0
99544 | 2011-10-05 00:00:00 | 7.5 | 1
99544 | 2011-12-06 00:00:00 | 7.5 | 1
99544 | 2012-01-12 00:00:00 | 7.5 | 0
99544 | 2012-01-13 00:00:00 | 6.5 | 1 |  |  |  |  |  |  | <<Check this one.
99544 | 2012-01-16 00:00:00 | 7.5 | 0
99544 | 2012-01-17 00:00:00 | 7.5 | 0
99544 | 2012-01-18 00:00:00 | 7.5 | 1
I need to count the number of CONSECUTIVE days to = 1 indicident
If there is a Friday & Monday sick, then this is still 1 consecutive incident even though there is a gap in the dates
I need to also add up the total # hours in each incident
Spreadsheet: 24fca820-b77f-4fd2-bcbe-5548cad81bf2
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-02-23 09:05:59.940000
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.375 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.25 | 101.865 | 101.74 | 101.615 | 101.24
4.125 | 101.455 | 101.33 | 101.205 | 100.83 |  | Note: | Refer To Price [NAME]
4 | 100.987 | 100.862 | 100.737 | 100.362 |  |  | For all Price Adjs
3.875 | 100.122 | 99.997 | 99.872 | 99.247
3.75 | 99.407 | 99.282 | 99.157 | 98.532
3.625 | 98.941 | 98.816 | 98.691 | 98.066
 |  |  |  |  |  | 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
3.75 | 102.076 | 101.951 | 101.826 | 101.451
3.625 | 101.788 | 101.663 | 101.538 | 101.163
3.5 | 101.448 | 101.323 | 101.198 | 100.823
3.375 | 100.907 | 100.782 | 100.657 | 100.282
3.25 | 100.26 | 100.135 | 100.01 | 99.385
3.125 | 99.645 | 99.52 | 99.395 | 98.77
3 | 99.302 | 99.177 | 99.052 | 98.427 |  | 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-03-08 09:05:59.940000
30 DAY | 2012-03-23 09:05:59.940000
45 DAY | 2012-04-07 09:05:59.940000
60 DAY | 2012-04-22 09:05:59.940000
90 DAY | 2012-05-22 09:05:59.940000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 150773d1334677164-how-to-insert-checkboxes-or-checkmarks-autocheckbox1
Sheet: marlett

 | There's not a checkmark here
 | There's not a checkmark here | Double Click in Column A to get a check
a | There's a check mark here | A marlett check is equivalent to the letter "a" if you look at the IF formula in B
a | There's a check mark here | Right click on tab and "view code" to view code
a | There's a check mark here
a | There's a check mark here
a | There's a check mark here
a | There's a check mark here
[NAME] | There's not a checkmark here
a | There's a check mark here
Spreadsheet: 89937d1289685135-changing-rows-to-columns-rows-to-columns
Sheet: Sheet1

TITLE | INITIALS | SURNAME | PERSNO | ELEMENTNAME | OLDAMOUNT | New Amount
Mrs | L | Scully | P2274 | Pre 97 Excess | 439.44 | 539.44
Mrs | L | Scully | P2274 | Post 88 GMP | 223.6 | 323.6
Mrs | L | Scully | P2274 | Post 97 Excess | 641.16 | 741.16
Mrs | S | [NAME] | P6175 | Pre 97 Excess | 2324.01 | 2424.01
Mrs | S | [NAME] | P6175 | Post 88 GMP | 609.44 | 709.44
Mrs | S | [NAME] | P6175 | Post 97 Excess | 1087.5 | 1187.5
Mrs | R | [NAME] | P6178 | Pre 97 Excess | 4912.49 | 5012.49
Mrs | R | [NAME] | P6178 | Pre 88 GMP | 1342.64 | 1442.64
Mrs | R | [NAME] | P6178 | Post 88 GMP | 2017.08 | 2117.08
 |  |  |  |  |  | Press Alt-F8 and run the ReformatData macro
Spreadsheet: 148753d1333548216-excel-2007-sum-conditions-trp-aging-report-v2-excel-forum-formatted
Sheet: Count of TRPs

 | Column Labels
 | Assigned | In Progress | New | Ready for Retest | (blank) | Grand Total
Count of * TPR Status | 92 | 40 | 5 | 251 |  | 388
Days 0-7
Days 8-14
Days 15-21
Days 21+
Spreadsheet: 807235d1669814750-transfer-of-data-from-a-master-sheet-to-other-sheets-quest-2-1-
Sheet: cash in Bank

Helper |  | Date | Description | Debit | Credit | Debit | Credit |  | Bank
Spreadsheet: 793169d1661348033-new-rolling-total-for-points-scored-in-last-3-games-rolling-total-for-points-scored-in-last-3-games
Sheet: Totals

Name 22 |  |  |  | 3
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Name 21
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Spreadsheet: 356407d1415103793-over-under-2-5-goals-book1
Sheet: Sheet2

COUNTRY | LEAGUE | TEAM | OVERALL FORM |  |  |  |  |  | OVERALL VALUE | COUNTRY | LEAGUE | TEAM | HOME FORM |  |  |  |  |  | HOME VALUE | COUNTRY | LEAGUE | TEAM | AWAY FORM
England | English League 1 | Preston | U 2.5 | U 2.5 | O 2.5 | U 2.5 | U 2.5 | O 2.5 |  |  |  |  | U 2.5 | O 2.5 | U 2.5 | O 2.5 | U 2.5 | O 2.5 |  |  |  |  |  | O 2.5 | U 2.5 | O 2.5 | U 2.5 | U 2.5
Spreadsheet: 763868d1642437001-working-out-rate-taking-off-additions-percentage-removal-example-workbook-charge-rate-errors-v2
Sheet: Sheet1

 |  | Current Working Showing Pay Rate to Charge Rate after Additions |  |  |  |  | Issues with this section - returning the value when the pay rate is not known using the same Fee and Pension values which remain fixed
 |  | Pay Rate | Pension Contribution (% of Pay inc WTD) | Fee | Charge Rate |  | Charge Rate | Pension Contribution (% of Pay inc WTD) | Fee | Pay Rate |  | Expected Result
 |  | 21 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 21
 |  | 22 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 22
 |  | 23 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 23
 |  | 24 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 24
 |  | 25 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 25
 |  | 26 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 26
 |  | 27 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 27
 |  | 28 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 28
 |  | 29 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 29
 |  | 30 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 30
 |  | 31 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 31
 |  | 32 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 32
 |  | 33 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 33
 |  | 34 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 34
 |  | 35 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 35
 |  | 36 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 36
 |  | 37 | 0.03 | 2.5 |  |  |  | 0.03 | 2.5 |  |  | 37
Spreadsheet: 807568d1669948195-text-to-column-formula-text-to-column-formula-ridho
Sheet: Sheet1

[NAME] FBA15G9R2TFN 20.0% S 4 2.50 10.00
UK Prep Fee FBA15G9R2TFN 20.0% S 66 0.50 33.00
UK Bundle Prep FBA15G9R2TFN 20.0% S 18 0.70 12.60
BUNDLE 4+ FBA15G9R2TFN 20.0% S 20 0.80 16.00
Box Charge # FBA15G9R2TFN # 20.0% S # 4 # 2.5 # 10
UK Prep Fee # FBA15G9R2TFN # 20.0% S # 66 # 0.5 # 33
UK Bundle Prep # FBA15G9R2TFN # 20.0% S # 18 # 0.7 # 12.6
BUNDLE 4+ # FBA15G9R2TFN # 20.0% S # 20 # 0.8 # 16
Spreadsheet: mary_fischer__25637__31T
Sheet: E18YTD.XLS

ENRON CORP AND CONSOLIDTED SUBSIDIARIES
COMPANY # 031T
ANALYSIS OF RESERVE ITEMS
FOR THE YEAR ENDED 12-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
 |  | 12-31-2000 Balance |  | ADDITIONS  DR (CR) |  |  |  | DEDUCTIONS  DR (CR)
 |  | DR. (CR) |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | DR. (CR)
[NAME] |  | BEGINNING BALANCE |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | ENDING BALANCE |  | COMMENTS/EXPLANATIONS
Allowance for Doubtful Accounts
(MUST TIE TO HYPERION LINE 0065)
Asset/Expense Accts:  DR/(CR)  Same signs as Hyperion
Reserve for Regulatory Issues - Current
(MUST TIE TO HYPERION LINE 0641)
Income Accts:  DR/(CR)  Reverse signs from Hyperion
Reserve for Regulatory Issues - Long Term
(MUST TIE TO HYPERION LINE 0815)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Other Reserves - Other
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
(MUST TIE TO HYPERION LINE 0840)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Hyperion Line #   and Description of Other Reserves   (not listed above)
Total Other Reserves  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
Spreadsheet: 693620d1599059327-calculate-extra-earnings-per-week-test-file_extra-earnings_ceara
Sheet: Sheet1

Employee Number | Scheduled Hours per Week | [NAME] | Date | Total Hours Worked per Week
10 | 21 | 48.38 | 2020-01-02 00:00:00 | 7.5
20 | 30 | 25.95 | 2020-01-12 00:00:00 | 7.5
10 | 21 | 48.38 | 2020-01-03 00:00:00 | 7.5
20 | 30 | 25.95 | 2020-01-13 00:00:00 | 7.5
10 | 21 | 48.38 | 2020-01-04 00:00:00 | 7.5
20 | 30 | 25.95 | 2020-01-15 00:00:00 | 7.5
10 | 21 | 48.38 | 2020-02-02 00:00:00 | 7.5
20 | 30 | 25.95 | 2020-01-16 00:00:00 | 7.5
10 | 21 | 48.38 | 2020-02-03 00:00:00 | 7.5
10 | 21 | 48.38 | 2020-02-05 00:00:00 | 7.5
20 | 30 | 25.95 | 2020-01-17 00:00:00 | 7.5
10 | 21 | 48.38 | 2020-02-06 00:00:00 | 7.5
20 | 30 | 25.95 | 2020-02-04 00:00:00 | 7.5
Spreadsheet: 78617d1278979872-vlookup-with-nested-if-functions-excel-dp-csc-mastertemplate-1-
Sheet: Sheet2

COURSE SCHEDULE CHANGE
Warner Pacific College/ADULT DEGREE PROGRAM
Name: |  |  |  |  | Student ID: |  |  | Cohort:
Date: |  |  |  |  | Date of Determination:
Comments:
COURSE SCHEDULE CHANGE
 |  | Includes permanent cohort change? |  |  |  | New Cohort: |  |  |  | Effective on:
 |  | Anticipated graduation ceremony
 |  | Days out of attendance great than 35? |  |  |  |  | yes |  | no
 |  | Course # | Course Title | Group $
 | Add
 | Add
 | Add
 | [NAME]
 | [NAME]
 | [NAME]
FUTURE BREAKS IN ATTENDANCE GREATER THAN 35 / POSSIBLE LOA’S
 | Dates |  |  |  | to
 | Dates |  |  |  | to
 |  |  |  |  |  |  | Total LOA days:
Please note:
 | The CSC form and any accompanying documents must be received by the ADP staff within five business days of the date on the form or it will be voided and all appropriate charges and academic policies will be applied.
 | To request a refund of textbook charges or to return unused books, please contact the ADP Bookstore at [PHONE] or download the form from the ADP website at www.adp.warnerpacific.edu.
 | Course changes and withdrawals may affect your Financial Aid; please consult with your Financial Aid Counselor.
 | Reference “Change of Student Status” and “ADP Refund Policy” in the ADP Bulletin for information regarding course withdrawals.
I have read and understand the Educational Policies as stated in the ADP Bulletin and agree to pay all charges resulting from this schedule change.
Student Signature: |  |  |  |  |  |  |  |  | Date:
For Office Use:
 | AC:
 | SS:
 | Changed AGD? New AGD: |  |  |  |  |  |  |  |  | Revised 7/7/10
Spreadsheet: 857365d1706382373-display-multiple-values-in-different-cells-if-values-between-two-numbers-display-multiple-values-in-diferent-cells-if-values-between-two-numbers
Sheet: Sheet1

Values I will choose | result expected  if I chose 1 - 1,5 I need excel to find all the values in colum D which are next to a value betwen 1 - 1,5  same If I chose 3,5 - 4 or any other interval from  he column H |  |  |  |  |  | IF(A1<>"";OFFSET(Trss;MATCH(A1&"*";Trss;0)-1;;COUNTIF(Trss;A1&"*");1);Trss)
1 - 1,5 | ACETIC ACID |  | ISOPENTANAL | 1.201 |  |  | OFFSET(Tr;0;0;COUNTA(TrS);1)
 | ACETONE |  | FURFURAL | 3.79 |  |  | Tr ; [NAME] ; [NAME]
 | ACETATE ETHYL |  | ACETIC ACID | 1.45
 | ISOPENTANAL |  | [NAME] 36 | 2.15 |  |  | Column1 | Column2
1,5 - 2 | ETHYL ACETATE |  | ACETATE ETHYL | 1.49 |  |  | 1 - 1,5 | 1
 | ETHYL PROPIONATE |  | ETHYL ACETATE | 1.6 |  |  | 1,5 - 2 | 2
 | ACETALDEHYDE DIETHYL ACETAL |  | RHO VALERIQUE | 1.68 |  |  | 2 - 2,5 | 3
 | ETHYL BUTYRATE ISO |  | ACETATE BUTYLE | 3.8 |  |  | 2,5 - 3 | 4
 | ACETALDEHYDE DIETHYL ACETAL |  | ACETOINE | 1.58 |  |  | 3 - 3,5 | 5
 | HEPTANE n |  | ETHYL PROPIONATE | 1.9 |  |  | 3,5 - 4 | 6
 | ETHYL PROPIONATE |  | RHO C6 (HEXANAL) | 2.49 |  |  | 4 - 4,5 | 7
 | ACETOINE |  | HEPTANE n | 1.8 |  |  | 4,5 - 5 | 8
 | RHO VALERIQUE |  | PRENOL | 2 |  |  | 5 - 5,5 | 9
3,5 - 4 | FURFURAL |  | ACETALDEHYDE DIETHYL ACETAL | 1.64 |  |  | 5,5 - 6 | 10
 | [NAME] 14 |  | ETHYL BUTYRATE ISO | 1.86 |  |  | 6 - 6,5 | 11
 | ETHYL LACTATE |  | PRENOL | 2 |  |  | 6,5 - 7 | 12
 | [NAME] 13 |  | TOLUENE | 2.3 |  |  | 7 - 7,5 | 13
 | [NAME] 43 |  | ACETALDEHYDE DIETHYL ACETAL | 1.64 |  |  | 7,5 - 8 | 14
 | ACETATE BUTYLE |  | LIMEDIENE | 2.45 |  |  | 8 - 8,5 | 15
2 - 2,5 | [NAME] 36 |  | ETHYL BUTYRATE | 2.23 |  |  | 8,5 - 9 | 16
 | LIMEDIENE |  | [NAME] 43 | 3.6 |  |  | 9 - 9,5 | 17
 | ETHYL BUTYRATE |  | [NAME] 13 | 3.9 |  |  | 9,5 - 10 | 18
 | TOLUENE |  | ACETONE | 1.379 |  |  | 10 - 10,5 | 19
 | RHO C6 (HEXANAL) |  | ETHYL LACTATE | 3.68 |  |  | 10,5 - 11 | 20
 | PRENOL |  | ETHYL PROPIONATE | 1.9 |  |  | 11 - 11,5 | 21
 | RHO C6 (HEXANAL) |  | [NAME] 14 | 3.99 |  |  | 11,5 - 12 | 22
 |  |  |  |  |  |  | 12 - 12,5 | 23
 |  |  |  |  |  |  | 12,5 - 13 | 24
 |  |  |  |  |  |  | 13 - 13,5 | 25
 |  |  |  |  |  |  | 13,5 - 14 | 26
 |  |  |  |  |  |  | 14 - 14,5 | 27
 |  |  |  |  |  |  | 14,5 - 15 | 28
 |  |  |  |  |  |  | 15 - 15,5 | 29
 |  |  |  |  |  |  | 15,5 - 16 | 30
 |  |  |  |  |  |  | 16 - 16,5 | 31
 |  |  |  |  |  |  | 16,5 - 17 | 32
 |  |  |  |  |  |  | 17 - 17,5 | 33
 |  |  |  |  |  |  | 17,5 - 18 | 34
 |  |  |  |  |  |  | 18 - 18,5 | 35
 |  |  |  |  |  |  | 18,5 - 19 | 36
 |  |  |  |  |  |  | 19 - 19,5 | 37
 |  |  |  |  |  |  | 19,5 - 20 | 38
 |  |  |  |  |  |  | 20 - 20,5 | 39
 |  |  |  |  |  |  | 20,5 - 21 | 40
 |  |  |  |  |  |  | 21 - 21,5 | 41
 |  |  |  |  |  |  | 21,5 - 22 | 42
 |  |  |  |  |  |  | 22 - 22,5 | 43
 |  |  |  |  |  |  | 22,5 - 23 | 44
 |  |  |  |  |  |  | 23,5 - 24 | 45
 |  |  |  |  |  |  | 24,5 - 25 | 46
Spreadsheet: 086b34a4-2b11-456f-9286-cac10ccbea32
Sheet: Solicitud 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nº
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fecha:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Incidente/Orden:
 |  |  |  |  |  | Anexo 106 - |  |  |  |  |  |  | Solicitud de Suspensión por Robo, [NAME] o Pérdida de Equipo
 |  |  |  |  |  |  |  |  |  |  |  |  | Solicitud de Reconexión de Equipo por recuperación
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V106
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. Suspensión |  |  |  |  |  |  |  |  |  |  | 2. Reconexión |  |  |  |  |  |  |  |  |  | (solo marcar 1 opción)
 |  | Persona
 |  | DNI/CE |  |  |  |  |  |  |  |  |  | RUC |  |  |  |  |  |  |  |  |  | Primer Nombre |  |  |  |  |  |  |  |  |  |  |  |  |  | Segundo Nombre
 |  | Apellido Paterno |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apellido Materno
 |  | Empresa
 |  | RUC |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Número de Nextel |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Código de Bloqueo de Equipo ([NAME] solo para reconexiones)*
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | *Solo es obligatorio en caso la solicitud sea presentada por el usuario
 |  | Uso interno de Nextel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Firma del usuario:
 |  | Observaciones:
 |  | Asesor de Servicios: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nombre: |  |  |  |  |  |  |  |  |  |  |  |  | DNI:
 |  | Firma del representante legal: |  |  |  |  |  |  |  |  |  |  |  |  | Única |  |  |  |  | Conjunta
 |  | Nombre: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DNI: |  |  |  |  |  |  |  |  |  | Nombre: |  |  |  |  |  |  |  |  |  |  |  |  | DNI:
 |  | V001-05Ene12
Spreadsheet: 149733d1334097348-return-name-based-on-2-criteria-test-functions
Sheet: SUMMARY

 |  | RETURN NAMES FROM DATA WORKSHEET
EXTERNAL |  | >50% | 0.5 | 0.5
ACCELLION, INC. | 1 | Return name from DATA when [NAME] RANGE(DATA A2:A6) & if SHARE is > 50% (From Data | Return name from DATA when [NAME] RANGE(DATA A2:A6) & if SHARE is = 50% (From Data | Return name from DATA when [NAME] RANGE(DATA A2:A6) & if SHARE is = 50% & not = to name in  D6
AETNA US HEALTHCARE | 2 | Return name from DATA when [NAME]:A6) & if SHARE is > 50% (From Data | Return name from DATA when [NAME]:A6) & if SHARE is = 50% (From Data | Return name from DATA when A7  MATCHES RANGE(DATA A2:A6) & if SHARE is = 50% & not = to name in  D7
[NAME] | 3 | Return name from DATA when [NAME] RANGE(DATA A2:A6) & if SHARE is > 50% (From Data | Return name from DATA when [NAME] RANGE(DATA A2:A6) & if SHARE is = 50% (From Data | Return name from DATA when A7  MATCHES RANGE(DATA A2:A6) & if SHARE is = 50% & not = to name in  D8
Spreadsheet: 176196d1345753103-what-is-the-best-solution-to-merge-two-spreadsheets-vlookup
Sheet: Data Sheet

address | city | state | Past Orders | hair | first |  | height | weight | birthday
123 Main | NY | NY | 12 | blonde | [NAME] | Smith | 5'8" | 160 | 1999-01-03 00:00:00
458 Center | Chicago | IL | 2 | brunette | [NAME] | Tanner | 5'2" | 110 | 1998-02-05 00:00:00
222 West | New Orleans | LA | 4 | brunette | [NAME] | [NAME] | 5'4" | 124 | 1982-10-15 00:00:00
14 East | Houston | TX | 11 | blonde | [NAME] | [NAME] | 5'9" | 158 | 1988-05-12 00:00:00
147 South | Seattle | WA | 17 | red | [NAME] | [NAME] | 6'1" | 215 | 1991-06-22 00:00:00
Spreadsheet: 598989d1542813648-if-formula-help-amortization-formulas-50
Sheet: Help

HELP
[NAME] |  | © 2005-2018 Vertex42 LLC
[NAME]
 | PMT(r,N,L)
 | NPER(r,p,L)
 | CUMIPMT(r,N,L,1,n,0)
 | CUMPRINC(r,N,L,1,n,0)
 | NewBalance = L(1-((1+r)^n-1)/((1+r)^N-1)
 | r : Monthly Interest Rate
 | n : Number of Months
 | N : Total Number of Months
 | L : Loan Amount
 | p : Monthly Payment
 | Note: CUMIPMT & CUMPRINC require the Analysis ToolPak add-in
Additional Help
 | The link at the top of this worksheet will take you to the web page on vertex42.com that talks about this template.
 | REFERENCES
SEE ALSO | Vertex42.com: Loan Amortization Schedule
SEE ALSO | Vertex42.com: Home Mortgage Calculator
TIPS | Vertex42.com: [NAME]
Spreadsheet: 776761d1649889476-time-sheet-calculating-the-hours-worked-and-splitting-them-in-overtime-using-3-variables-cost_price_services_a03
Sheet: Parameters

Years | Months | Days | Weekend | Time | Quarter hr
2021 | January | 1 | No Weekend | 00:00:00 | 00:00:00
 | February | 2 | Sat & Sun | 01:00:00 | 00:15:00
 | March | 3 | Sun & Mon | 02:00:00 | 00:30:00
 | April | 4 | Mon & Tue | 03:00:00 | 00:45:00
 | May | 5 | Tue & Wed | 04:00:00
 | June | 6 | Wed & Thu | 05:00:00
 | July | 7 | Thu & Fri | 06:00:00
 | August | 8 | Fri & Sat | 07:00:00
 | September | 9 | Mon Only | 08:00:00
 | October | 10 | Tue Only | 09:00:00
 | November | 11 | Wed Only | 10:00:00
 | December | 12 | Thu Only | 11:00:00
 |  | 13 | Fri Only | 12:00:00
 |  | 14 | Sat Only | 13:00:00
 |  | 15 | Sun Only | 14:00:00
 |  | 16 |  | 15:00:00
 |  | 17 |  | 16:00:00
 |  | 18 |  | 17:00:00
 |  | 19 |  | 18:00:00
 |  | 20 |  | 19:00:00
 |  | 21 |  | 20:00:00
 |  | 22 |  | 21:00:00
 |  | 23 |  | 22:00:00
 |  | 24 |  | 23:00:00
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31