tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 806775d1669569951-cannot-properly-avg-column-heart-log
Sheet: Sheet1

[NAME] |  | DOB | 1949-10-06 00:00:00 |  |  | HEIGHT | 6' 2"
Date | Time | Sys | [NAME] | Pulse | Glucose | Weight | Notes
2022-10-05 00:00:00 | 900 | 110 | 83 | 60 | 86
2022-10-06 00:00:00 | 900 | 116 | 80 | 61 | 121
2022-10-07 00:00:00 | 900 | 131 | 79 | 72
2022-10-08 00:00:00 | 1000 | 118 | 86 | 67
2022-10-09 00:00:00 | 1100 | 136 | 97 | 66
 | 1105 | 133 | 91 | 64
2022-10-10 00:00:00 | 830 | 140 | 78 | 70
2022-10-11 00:00:00 | 930 | 145 | 74 | 65
2022-10-12 00:00:00 | 900 | 130 | 86 | 74
2022-10-13 00:00:00 | 1030 | 122 | 75 | 66
2022-10-14 00:00:00 | 900 | 125 | 75 | 59
2022-10-15 00:00:00 | 700 | 145 | 90 | 68
 | 730 | 111 | 70 | 74
2022-10-16 00:00:00 | 1030 | 126 | 77 | 64 | 130
2022-10-17 00:00:00 | 930 | 120 | 86 | 64 | 118
2022-10-18 00:00:00 | 900 | 123 | 85 | 68 | 121
2022-10-19 00:00:00 | 930 | 137 | 86 | 59 | 118
2022-10-20 00:00:00 | 1000 | 106 | 81 | 76 | 163
 | 1005 | 123 | 90 | 61 | 171
 | 1600 | 120 | 86 | 61 | 131
2022-10-21 00:00:00 | 1200 | 117 | 91 | 69 | 120
2022-10-22 00:00:00 | 930 | 122 | 78 | 59 | 105
2022-10-23 00:00:00 | 1300 | 130 | 76 | 71 | 120
2022-10-24 00:00:00 | 930 | 143 | 79 | 65
 | 1435 | 122 | 84 | 63
2022-10-25 00:00:00 | 1000 | 126 | 87 | 75 | 125
2022-10-26 00:00:00 | 700 | 123 | 77 | 61
2022-10-27 00:00:00 | 930 | 134 | 81 | 86 | 92
2022-10-28 00:00:00 | 1130 | 151 | 86 | 54
 | 1135 | 116 | 97 | 62 | 118
2022-10-29 00:00:00 | 800 | 115 | 88 | 72 | 115
2022-10-30 00:00:00 | 1000 | 124 | 84 | 61 | 98
2022-10-31 00:00:00 | 1000 | 124 | 86 | 69 | 134 | 229
2022-11-01 00:00:00 | 530 | 132 | 86 | 80 | 97
2022-11-02 00:00:00 | 1130 | 128 | 85 | 76 | 105
2022-11-04 00:00:00 | 830 | 112 | 82 | 67 | 94 | 228
2022-11-06 00:00:00 | 800 | 118 | 81 | 64 | 87
2022-11-08 00:00:00 | 900 | 102 | 71 | 79 | 129
2022-11-09 00:00:00 | 800 | 117 | 72 | 40
2022-11-10 00:00:00 | 800 | 117 | 83 | 71 | 118
 | 805 | 134 | 67 | 75 | 119
2022-11-11 00:00:00 | 800 | 194 | 88 | 81
 | 810 | 130 | 90 | 69 | 100
2022-11-12 00:00:00 | 800 | 112 | 74 | 77 | 129
2022-11-14 00:00:00 | 830 | 116 | 71 | 68 | 111
2022-11-16 00:00:00 | 800 | 110 | 82 | 138 | 183
 | 810 | 128 | 81 | 84 | 186
2022-11-17 00:00:00 | 1000 | 146 | 82 | 68 | 116 | 240
 | 1005 | 132 | 72 | 88
2022-11-18 00:00:00 | 1000 | 138 | 75 | 70 | 122
2022-11-19 00:00:00 | 900 | 134 | 83 | 64 | 120
2022-11-21 00:00:00 | 900 | 130 | 97 | 68
2022-11-24 00:00:00 | 900 | 141 | 86 | 56 | 88
2022-11-27 00:00:00 | 1000 | 123 | 85 | 61 | 113
 |  |  |  |  |  | 555
 |  |  |  |  | 222
Average |  | 127 | 82.25925925925925 | 69.07407407407408 | 122.9166666666667 | 313
Spreadsheet: 686850d1594833903-smarter-way-to-locate-different-rows-and-remove-blanks-excel-forum-presentational-sheet
Sheet: Presenational

Generic List |  |  |  |  |  |  | Specific Extractor |  | Fixed
Date | Thing | Payee | Amount | From Budget | From Account |  | Date | Thing | Payee | Amount | From Account
2020-02-11 00:00:00 | Clothes | H & M | 45 | Other | Current
2020-02-12 00:00:00 | Food | Walmart | 17.84 | Fixed | Current
2020-02-13 00:00:00 | Beer | Cost Co | 18.96 | Social | Current
2020-02-14 00:00:00 | Clothes | H & M | 50 | Other | Current
2020-02-15 00:00:00 | Office Supplies | Walmart | 36.57 | Sundries | Current
2020-02-16 00:00:00 | Food | Walmart | 18.3 | Food | Current
2020-02-17 00:00:00 | Rent | [NAME] | 450 | Fixed | Current
2020-02-17 00:00:00 | Water | Water Company | 45 | Fixed | Current
Spreadsheet: 698396d1601973358-auto-arrange-copied-elements-from-one-to-another-excel-table-book1
Sheet: Sheet1

 |  |  |  |  | TABLE 2
TABLE 1 |  |  |  |  | Report no. 1 |  |  |  | Report no. X
 | QUANTITY |  |  |  |  | QUANTITY |  |  |  | QUANTITY
ID | ACCOUNTING VALUE | REAL VALUE | DIFFERENCE |  | ID | ACCOUNTING VALUE | REAL VALUE | DIFFERENCE | ID | ACCOUNTING VALUE | REAL VALUE | DIFFERENCE
AM_00063 |  |  |  |  | A000000133 | 334 | 59 |  | xx | xx | xx | xx
A000000469 |  |  |  |  | A000000496 | 0 | 0 |  | xx | xx | xx | xx
AM_00041 |  |  |  |  | A000000515 | 11097 | 11087 |  | xx | xx | xx | xx
AM_00037 |  |  |  |  | A000000523 | 223.9 | 226.54 |  | xx | xx | xx | xx
A000000496 |  |  |  |  | AM_00017 | 55 | 143
AM_00017 |  |  |  |  | AM_00041 | 0 | 0
A000000133 |  |  |  |  | AM_00063 | 4500 | 5600
AM_00106 |  |  |  |  | AM_00071 | 339 | 18 |  | xx | xx | xx | xx
AM_00002 |  |  |  |  | AM_00087 | 13.45 | 2.54
AM_00012 |  |  |  |  | AM_00107 | 110 | 49.34
AM_00107 |  |  |  |  | AM_00435 | 113.09 | 128.37 |  | xx | xx | xx | xx
A000000523
AM_00087
AM_00435
A000000514
A000000516
A000000515
AM_00071
TABLE 3
Report no. 1 |  |  |  | Report no. X
 | QUANTITY |  |  | QUANTITY
ID | ACCOUNTING VALUE | REAL VALUE | DIFFERENCE | ACCOUNTING VALUE | REAL VALUE | DIFFERENCE
AM_00063 | 4500 | 5600 |  | xx | xx | xx
A000000469 |  |  |  | xx | xx | xx
AM_00041 |  |  |  | xx | xx | xx
AM_00037 |  |  |  | xx | xx | xx
A000000496
AM_00017 | 55 | 143
A000000133 | 334 | 59
AM_00106 |  |  |  | xx | xx | xx
AM_00002
AM_00012
AM_00107 | 110 | 49.34
A000000523 | 223.9 | 226.54
AM_00087 | 13.45 | 2.54
AM_00435 | 113.09 | 128.37
A000000514
A000000516
A000000515 | 11097 | 11087 |  | xx | xx | xx
AM_00071 | 339 | 18
Spreadsheet: 95148d1294824984-referencing-the-next-cell-in-an-array-that-is-not-a-particular-value-key-indexmatch
Sheet: Sheet2

SAMPLE | Value 1 | Value 2 | Value 3 |  | Total
Spreadsheet: 58009d1258319757-how-many-days-overlap-whycali2
Sheet: Sheet1

Start Date | 2010-01-04 00:00:00
End Date | 2011-01-02 00:00:00
Holidays | Start Date | End Date | Even Years
4th of July | 2010-07-03 00:00:00 | 2010-07-04 00:00:00 | Dad
Thanksgiving | 2010-11-24 00:00:00 | 2010-11-25 00:00:00 | Mom
Christmas | 2010-12-24 00:00:00 | 2010-12-25 00:00:00 | Dad
New Year's | 2010-12-31 00:00:00 | 2011-01-01 00:00:00 | Mom
Days with Mom | 182
Days with Dad | 182
Spreadsheet: 864627d1711722650-conditional-formatting-to-highlight-percentages-question
Sheet: Sheet1

 |  | Employees | Annual leave Entitlement | Annual leave used as of today |  |  |  | Annual leave entitlement | 50% | 75%
 |  | [NAME] | 25 | 14 |  |  |  | 25
 |  | [NAME] | 27 | 23 |  |  |  | 27
 |  | [NAME] | 30 | 10 |  |  |  | 30
Spreadsheet: 142949d1330101079-sumproduct-help-dummy-workbook
Sheet: Divisional Results

Company | YTD Values
Company Y | 263.4405978857999
Company T | 216.0899551914
Company M | 0
Company P | 47.50109191559997
Company G | 0
Company S | 3.316941976199999
Company 2 | 171.7879461059999
Company J | 125.7171791034
Company F | 0.6618459642000001
Company E | 0.1681125444
Company H | 80.6623952562
Company O | 0
Company B | 0
Company C | 236.6959942559999
Company I | 177.0655480548001
Company A | 0
Spreadsheet: joe_parks__14926__TXULSP Avail Cap Elec Gen 2
Sheet: available capacity

 |  |  |  | Today's Date:
 | Lone Star Pipeline
Estimated Available Capacity on the TXU Lone Star Pipeline system
Gas Day runs from 9:00 a.m. to 9:00 a.m.
All volumes are expressed in [NAME]/d
The data below is TXU Lone Star Pipeline's best estimate of available capacity based on current operational data.  The available capacity listed
at the various [NAME])  is subject to the nomination process and the operational conditions existing at the time a nomination is confirmed.
The volumes listed below do not represent individual point capacity availability.   All transportation service will be performed subject to the terms
and conditions of your Transportation Agreement.
Please contact TXU Lone Star Pipeline's Transportation Administration Department before scheduling any imbalance makeup.  When
nominating imbalance makeup, please indicate what portion of your nomination is intended as imbalance makeup.  For more information, please
contact your TXU Lone Star Pipeline Transportation Administrator.
Please visit our web site at www.txulsp.com for nomination information and for a list of Major Interconnect Points on our system.
 | Receipt Area Capacity
 | Gas Day | Gas Day
 | 2002-04-12 00:00:00 | 4-13-02 to 04-15-02
From the Waha Area | 125000
East of Waha to | 125000
to the Maryneal Compressor
East of Maryneal Compressor | 50000
[NAME] | 100000
(Waller and Ft. Bend Counties)
Line V (30") | 50000
(Ennis to [NAME])
Line L8A | 0
(Limestone and Freestone Cty)
Line  P | 15000
([NAME] Area - for local consumption only)
[NAME] and O (East Texas) | 25,000*
 | * Carthage Plant OK for 25,000
Spreadsheet: 823448d1679966871-excel-calendar-perpetual-events-monthly-calendar-sample
Sheet: NOVEMBER

NOVEMBER 2023
SUNDAY |  | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
 | 29 | 30 | 31 | 1 | 2 | 3 | 4
 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  |  |  |  |  |  | Veterans Day
 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 |  |  |  |  | Thanksgiving Day
 | 26 | 27 | 28 | 29 | 30 | 1 | 2
 |  |  | [NAME] born 11/25/1885 - 1972 ([NAME]) |  | [NAME] m [NAME] 11/30/1912 our direct ancestors
Notes: |  |  |  |  |  |  | © www.calendarlabs.com
Spreadsheet: 783774d1655133774-if-cell-equals-value-in-another-cell-calculate-sum-of-corresponding-cells-on-second-sheet-scdhd-report1
Sheet: Daily Performance Summary

Daily Key Performance Indicators
 | [NAME]
 | [NAME] |  |  |  |  |  | Exceptions:
 | OOH Calls |  |  |  |  |  | Impact:
 | OOH Abandon%
 | Total Calls
 | Overall Call Abandon%
 | [NAME]
 | [NAME]
 | OOH Webchats
 | OOH Webchats Abandon%
 | Total Webchats
 | Overall Webchat Abandon%
 | Staffing [NAME]
 | Service Level
Week Number (ISO) | [NAME]
 | [NAME]
 | OOH Calls
 | OOH Abandon%
 | Total Calls
 | Overall Call Abandon%
 | [NAME]
 | [NAME]
 | OOH Webchats
 | OOH Webchats Abandon%
 | Total Webchats
 | Overall Webchat Abandon%
 | Staffing [NAME]
 | Service Level
Spreadsheet: 770159d1645834508-replacing-offset-to-sum-up-to-max-value-from-specific-cell-offset-version
Sheet: Leads

Machine | 4103
Engineering DWG | 2800026-A-10-0000
Minutes | 120
Starting N-Block | N11
Helper Column
N-Block Value
Total N-Blocks
Ending N-Block
Total Time (min.)
Time Balance (min.)
Spreadsheet: 60929b3b-584a-4338-92ee-92115adf7523
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4848 | 8065 | [NAME] | Brockenbrough | USA | 0 | 00:32:32 | 00:02:38 | 01:17:26 | [NAME] | 00:55:13 | 1 | 02:49:30
4848 | 13354 | [NAME] | [NAME] | GBR | 0 | 00:29:17 | 00:03:35 | 01:21:39 | 00:01:36 | 01:09:57 | 2 | 03:06:03
4848 | 29893 | [NAME] | Leonard | USA | 0 | 00:31:12 | 00:03:02 | 01:23:50 | [NAME] | 01:20:23 | 3 | 03:21:11
4848 | 32814 | [NAME] (jo) | Ward | AUS | 0 | 00:44:12 | 00:04:41 | 01:25:33 | 00:03:32 | 01:03:43 | 4 | 03:21:42
4848 | 8052 | Alec | Hill | NZL | 0 | 00:31:27 | 00:03:27 | 01:28:51 | 00:03:17 | 01:16:08 | 5 | 03:23:08
4848 | 8059 | [NAME] | [NAME] | USA | 0 | 00:37:10 | 00:04:42 | 02:00:26 | 00:05:42 | 01:44:09 | 6 | 04:32:07
Spreadsheet: 792182d1660764854-calculate-the-penalty-amount-based-of-payment-date-penalty-charge-1
Sheet: Sheet1

Sr | BILL AMOUNT | DUE DATE | LATE PAYMENT CHARGES | PAYMENT DATE |  | LATE PAYMENT CHARGES DAYS | LATE PAYMENT CHARGE @ 15 % PER ANNUM | Calculation of column D is based on calculation of Column G and H
1 | 8743.140000000001 | 2020-09-07 00:00:00 | 0
2 | 3594.4 | 2020-09-25 00:00:00 | 0
3 | 8548.1 | 2020-10-29 00:00:00 | 0 | 2020-10-15 00:00:00
4 | 14506.26 | 2020-12-01 00:00:00 |  | 2020-11-27 00:00:00
5 | 6657.780000000001 | 2020-12-28 00:00:00 | 0
6 | 6906.080000000001 | 2021-01-12 00:00:00 | 0 | 2021-01-12 00:00:00
7 | 7817.9 | 2021-02-16 00:00:00
8 | 2976.68 | 2021-03-15 00:00:00 | 0 | 2021-03-14 00:00:00
 | >> in above example there are three bills due (Cell B2) 8743.14, (Cell B3) 3594.4, (Cell B4) 8548.1 on different dates as shown in Cell C2, [NAME] and C4 respectively. But payment of all three Bills are done on 15-10-2020. Now, Due Date of First bill is 07-09-2020 and Payment done on 15-10-2020 so Day difference in this case is (15-10-2020 – 07-09-2020 = 38 days). This bills amount is 8743.14, so late payment charge calculation will be doen as per below ((8743.14*15%)*38)/365 = [PHONE] Due Date of Second bill is 25-09-2020 and payment date is 15-10-2020 so day difference is (15-10-2020 – 15-10-2020 = 20 days). This bills amount is 3594.4, so late payment charge calculation will be done as per below ((3594.4*15%)*20)/365 = 29.5430137 Due date of third bill is 29-10-2020 and payment done date is 15-10-2020, which means on this bill late payment charges will not be levied since payment has been done prior to due date. So the late payment charge [PHONE] ([PHONE] + 29.5430137) will be recoverable with fourth bill amount. Due date of fourth bill is 01-12-2020 and payment was done on 27-11-2020, so in this case there is no Late payment charge since payment was done before due date. Payment of fifth and Sixth bill was done on 12-01-2021, in this case sixth bill was paid on due date so there is no Late payment charge for that bill. Due date of fifth bill was 28-12-2020 and payment date is 12-01-2021, Late payment charge will be levied on (12-01-2021 – 28-12-2020 = 15 Days) ((6657.78*15%)*15)/365 = 41.04110959 Which will be recoverable with seventh bill.
Spreadsheet: 850083d1700479900-marks-away-from-next-score-marks-away-from-next-score
Sheet: Sheet1

Name | Score | Mark | Marks away from next score
Candidate 1 | 43 |  |  |  | Score | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
Candidate 2 | 67 |  |  |  | Mark | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Candidate 3 | 81
Candidate 4 | 23
Candidate 5 | 45
Candidate 6 | 33
Candidate 7 | 65
Candidate 8 | 19
Candidate 9 | 53
Candidate 10 | 42
Spreadsheet: 687494d1595251869-excel-keeps-turning-numbers-with-slashes-that-arent-fractions-into-dates-e-g-6-12-2020-07-20-oeldere-cwhit65-687175d1595007537-excel-keeps-turning-numbers-with-slashes-that-ar
Sheet: Sheet1

Answered vs. Total Questions |  | Correct vs. Total Questions
150 / 150 |  | 59 / 150
70 / 70 |  | 24 / 70
15 / 15 |  | 15^11^2020
30 / 30 |  | 30^12^2020
27 / 27 |  | 27^10^2020
26 / 26 |  | 26^6^2020
7^7^2020 |  | 7^3^2020
21 / 21 |  | 21^9^2020
10^10^2020 |  | 10^3^2020
80 / 80 |  | 35 / 80
18 / 18 |  | 18^10^2020
42 / 42 |  | 23 / 42
11^11^2020 |  | 11^4^2020
19 / 19 |  | 19^8^2020
Spreadsheet: 81092d1281364953-two-worksheets-auto-populating-each-other-po-request-080210_safe
Sheet: JDE_Codes

Code | Description | PO Total | Invoice 1 | Invoice 2 | Invoice 3 | Invoice 4 | Invoice 5 | Invoice 6 | Remaining Balance
110 | Author Grant / Fees / Expenses | If it finds the code in column AV on sheet PO_Requisition, then populate the Total from BR |  |  |  |  |  |  | SUM(C2)-D2:I2 - If nothing in C2, leave blank. If A negative balance, turn red
112 | Content Gathering / Creation | #N/A
210 | Development & Consulting
215 | Editorial / Content QA & Accuracy
220 | Honoria / Reviews
305 | MS Preparation / Keyboarding / Word Extraction
310 | Interior (or Interface) Design
320 | Copyediting
325 | Index Compilation
330 | Marketing-Related Copy / Watermarking
340 | Project Management
350 | Proofreading
355 | Software QA (External)
361 | Multimedia Production / Programming / Preview
362 | Multimedia Maintenance / Upgrade
370 | Video/Audio Recording
398 | [NAME]
402 | Art Editing / Art Management
410 | Image Permissions & Licensing Fees
420 | Art Rendering
425 | Art Alterations
470 | Labor for Permissions / Photo Research
510 | Text Permissions
520 | Composition / Page Markup
525 | Data Retrieval / Conversion / Archiving
550 | Composition Alterations
599 | Transfers to Author's Royalties
610 | Sample Pages
620 | Page Proofs / Photocopies
640 | Air Freight / Postage / Couriers
710 | Scanning / Camera Work
720 | Text Printer Preparation / File Activity
740 | File / Film Alterations
810 | Cover Permissions & Image Research
820 | Cover Design / Production
830 | Printer Cover Preparation
840 | Cover Production
911 | Disc & Printer Plates
920 | Miscellaneous
Spreadsheet: 33baf376-44c8-4f31-af39-1db46e8941f3
Sheet: Rankings - 2009

Player | Adjusted Rank | Adjusted Success rate (%) (90% CI) | Attempts
[NAME] | 1 | 88 (77-95) | 16
[NAME] | 2 | 87 (77-93) | 41
[NAME] | 3 | 86 (75-93) | 48
[NAME] | 4 | 83 (69-92) | 10
[NAME] | 5 | 81 (68-90) | 16
[NAME] | 6 | 77 (57-89) | 6
[NAME] | 7 | 76 (63-85) | 43
[NAME] | 8 | 75 (61-85) | 30
Lionel Beauxis | 9 | 74 (57-86) | 13
[NAME] | 10 | 74 (58-85) | 49
[NAME] | 11 | 73 (54-87) | 11
[NAME] | 12 | 73 (53-86) | 8
[NAME] | 13 | 72 (51-87) | 5
Toby Flood | 14 | 71 (51-85) | 12
[NAME] | 15 | 69 (52-82) | 16
[NAME] | 16 | 69 (48-85) | 6
[NAME] | 17 | 67 (48-82) | 10
[NAME] | 18 | 67 (50-80) | 28
[NAME] | 19 | 66 (47-81) | 12
Morgan Parra | 20 | 65 (47-80) | 23
[NAME] | 21 | 63 (45-78) | 21
[NAME] | 22 | 60 (41-76) | 13
Spreadsheet: 219153d1362674952-time-formatting-227-pilot-1-1-
Sheet: Sheet1

 | speaker | time in 1 | time out 1 | time in 2 | time out 2 | Time in 3 | Time out 3 | Start time 4 | End time 4 | Time in 5 | time out 5 | total time
 | Gingrich | 00:00:23 | 00:00:56 | 00:01:29 | 00:04:00 | 00:05:20 | 00:11:44 | 00:11:56 | 00:12:52 | 00:13:05 | 00:13:10
 | words | Well Let's Start | Next few years | speaker Boehnor | Republicans in 2014 | Now Conservative lawmakers | Win in 2014 | Last Question | across the planet | Alright former house | Great thank you
 | [NAME] | 00:00:22 | 00:01:05 | 00:01:38 | 00:01:49 | 00:02:46 | 00:04:45 | 00:10:10 | 00:11:56 | 00:00:00 | 00:00:00
 |  | Ambassador [NAME] thank | roman catholic church | let's talk for | be an american | well cardinal omahaly | the roman catholic church | last question | sure ya
 | [NAME] | 00:00:05 | 00:04:22 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
 |  | Join us now | Thank you [NAME]
 | Mahisha Dellinger | 00:00:20 | 00:01:05 | 00:01:49 | 00:02:39 | 00:02:48 | 00:03:18 | 00:07:04 | 00:08:40 | 00:09:13 | 00:10:13
 |  | Mahisha Thanks so much | epic Market | What about challeneges | that now | another challenge perhaps | be difficult | ok, well I also | yes absolutely | alright well it's an | Thank you so much
 | [NAME] | 00:00:20 | 00:07:37 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
 |  | Mr. [NAME] is | for the opportunity
 | [NAME] | 00:00:18 | 00:08:05 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
 |  | dr. Price it's | Take care
Spreadsheet: 82897d1282904329-another-if-function-problem-if-problem
Sheet: Sheet1

idno | Product | Value |  | 41 Negative?
1 | 4 | 1
1 | 5 | 1
1 | 11 | 1
1 | 14 | -8.25
1 | 16 | 0.575
1 | 17 | 0.675
1 | 21 | -9.75
1 | 25 | -9.75
1 | 27 | 0.675
1 | 29 | 0.425
1 | 30 | -9.75
1 | 36 | 0
1 | 41 | -9.75
4 | 11 | 1
4 | 12 | 0.375
4 | 14 | -6.75
4 | 17 | -0.75
4 | 19 | -1.75
4 | 20 | 1
4 | 23 | -2.75
4 | 27 | -2.25
4 | 28 | 1
4 | 34 | 1
4 | 36 | -0.75
4 | 41 | -9.75
4 | 42 | 0.925
5 | 3 | 0.725
5 | 5 | 1
5 | 7 | 1
5 | 9 | 0.325
5 | 10 | 1
5 | 29 | 0.525
5 | 33 | 1
5 | 36 | -3.25
5 | 37 | 1
5 | 38 | 1
5 | 41 | -7.25
5 | 43 | 0.725
5 | 45 | 1
Spreadsheet: 95059d1294762515-need-2-x-ticker-label-moving-text-from-right-to-left-linked-dynamically-to-dropdown-multilookup-sort-1-
Sheet: A

Sr.No | Policy Holders Name | POLICY NO | Date of  Comm | T-T | MOCE | NAME OF THE PLAN | Plan Type | SUM ASSURED | Current Pay-By Date | PREMIUM
1 | Arvind Deshmukh | 791787833 | 2003-01-14 00:00:00 | 48-25 | [NAME] | LIMITED PYMNT WITH PROFITS | Insurance | 100000 | 2011-01-14 00:00:00 | 5000
2 | Arvind Deshmukh | 792383786 | 2004-06-28 00:00:00 | 14-30 | SGL | ENBOWMENT  WITH BONUS | Insurance | 55000 | 2011-06-28 00:00:00 | 6000
3 | Arvind Deshmukh | 792383787 | 2004-06-28 00:00:00 | 14-31 | ECS | ENBOWMENT  WITH BONUS | Insurance | 55000 | 2011-06-28 00:00:00 | 7000
4 | Arvind Deshmukh | 792383788 | 2004-06-28 00:00:00 | 14-32 | [NAME] | ENBOWMENT  WITH BONUS | Insurance | 55000 | 2011-06-28 00:00:00 | 8000
5 | Arvind Deshmukh | 792997163 | 2005-02-15 00:00:00 | 169-22 | SGL | JEEVAN NIDHI WITH GUAR ADDTNS | Pension | 220000 | 2011-02-15 00:00:00 | 9000
6 | Arvind Deshmukh | 792969818 | 2005-02-15 00:00:00 | 173-70 | [NAME] | JEEVAN PLUS | ULIP+Risk | 50000 | 2011-02-15 00:00:00 | 10000
7 | Arvind Deshmukh | 792969819 | 2005-02-15 00:00:00 | 172-21 | [NAME] | FUTURE PLUS | ULIP | 50000 | 2011-02-15 00:00:00 | 11000
8 | Arvind Deshmukh | 792969820 | 2005-02-15 00:00:00 | 172-22 | [NAME] | FUTURE PLUS | ULIP | 50000 | 2011-02-15 00:00:00 | 12000
9 | Arvind Deshmukh | 792969821 | 2005-07-20 00:00:00 | 172-23 | [NAME] | FUTURE PLUS | ULIP | 50000 | 2011-07-20 00:00:00 | 13000
10 | Arvind Deshmukh | 792969822 | 2005-07-20 00:00:00 | 172-24 | [NAME] | FUTURE PLUS | ULIP | 50000 | 2011-07-20 00:00:00 | 14000
11 | Arvind Deshmukh | 792969823 | 2006-06-21 00:00:00 | 172-25 | [NAME] | FUTURE PLUS | ULIP | 50000 | 2011-06-21 00:00:00 | 15000
12 | Arvind Deshmukh | 792969824 | 2006-06-21 00:00:00 | 172-26 | [NAME] | FUTURE PLUS | ULIP | 50000 | 2011-06-21 00:00:00 | 16000
13 | Arvind Deshmukh | 792969825 | 2006-08-21 00:00:00 | 14-32 | [NAME] | ENBOWMENT  WITH BONUS | Insurance | 50000 | 2011-08-21 00:00:00 | 17000
14 | Arvind Deshmukh | 792969826 | 2008-06-27 00:00:00 | 14-32 | [NAME] | ENBOWMENT  WITH BONUS | Insurance | 50000 | 2011-06-27 00:00:00 | 18000
Spreadsheet: 682782d1592329058-multiple-if-conditions-in-array-formula-multiple-if-statement-array-formula-help
Sheet: Sheet1

 |  | Name | Activity 1 | Activity 2 | Activity 3 | Activity 4 | Activity 5 | Comment |  | [NAME] Should Be |  |  | Array Calculation | Comment |  | Array & Comment Combined
 |  | Participant 1 | 71 | 56 |  |  | 68 | enter formula |  | Pass
 |  | Participant 2 |  | 14 |  | 58 | 68 | enter formula |  | Fail
 |  | Participant 3 | 71 | 56 | 65 | 86 | 97 | enter formula |  | Pass
 |  | Participant 4 | 0 | 0 | 0 | 0 | 0 | enter formula |  | Fail
 |  | Participant 5 | 45 | 56 | 90 | 80 | 75 | enter formula |  | Fail
 |  | Participant 6 |  | 63 | 55 | 87 | 68 | enter formula |  | Pass
Spreadsheet: 672155d1586774803-calculate-date-time-last-saved-by-and-percentages-action-log-updated-with-comments
Sheet: Action Items

 | ACTION ITEMS |  | Last date and time saved: |  | 2020-04-13 11:31:43
 |  |  |  |  |  | The above only updates when you click on 'save'. Is there a way to do it so that you don't need to click on the above 'Save' button for the author, date and time to update.
 |  |  | Last modified by: | D Smith
 |  |  |  | Below ("5") doesn't work I'm afraid. It's counting ALL the queries unresolved but it should only be counting queries in January which doesn't have a tick in column I
 |  |  |  |  |  |  |  | Total number of January queries ranked 1 which were resolved and has a deadline of "MET" (as a percentage)
 | Works perfect, thanks! |  |  |  |  |  |  |  | Works perfect, thanks!
 | Total number of January queries |  |  | Total number of January queries unresolved |  |  |  |  | Can you add a highest percentage of potential of queries that could be met for March assigned dates? You will see that task 8 was set on 17/03/2020 but isn't due until 22/04/2020 which is in April. It will be good to have a highest percentage of tasks that could be met within the  set deadline.
 |  |  |  |  |  |  |  |  | Row 28 gives an example of the requirement
 | ACTION ITEM | RANK | PRIORITY | OWNER | ASSIGNED | DUE | Deadline | DONE | STATUS | NOTES
 | Task 1 | 1 | HIGH | [NAME] | 2020-01-02 00:00:00 | 2020-01-06 00:00:00 | Missed | √ | 1
 | Task 2 | 1 | HIGH | [NAME] | 2020-01-13 00:00:00 | 2020-01-14 00:00:00 | Missed | √ | 1
 | Task 3 | 3 | MEDIUM | Sue | 2020-01-14 00:00:00 | 2020-01-15 00:00:00 | Missed
 | Task 4 | 3 | MEDIUM | [NAME] | 2020-02-15 00:00:00 | 2020-02-22 00:00:00 | Missed
 | Task 5 | 1 | MEDIUM | [NAME] | 2020-01-16 00:00:00 | 2020-01-17 00:00:00 | Met | √ | 1
 | Task 6 | 1 | HIGH | [NAME] | 2020-03-15 00:00:00 | 2020-03-17 00:00:00 | Met | √ | 1
 | Task 7 | 3 | MEDIUM | [NAME] | 2020-03-19 00:00:00 | 2020-03-21 00:00:00 | Missed | √ | 1
 | Task 8 | 1 | HIGH | Dill | 2020-03-17 00:00:00 | 2020-04-22 00:00:00 | In progress |  | 0.75
 | Total number of March queries ranked 1 which were resolved and has a deadline of "MET" (as a percentage) | Answer returned should be something like 33.33% | Sorted. Thanks.
 | Total number of March queries ranked 1 which were resolved (in time so "Met") and can still be resolved in time (as a percentage) | Answer returned should be something like 66.66%