tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 153642d1335983553-need-help-with-sumifs-multiple-criteria-sample-excel
Sheet: Sheet1

Forecast Date and Time | Volume Date | Name | Volume1 | Volume2
2012-04-11 09:22:44 | 2012-04-09 07:00:00 | ABC | 27508 | 613
2012-04-02 10:08:45 | 2012-04-09 07:00:00 | ABC | 32500 | 724
2012-04-09 14:47:21 | 2012-04-09 07:00:00 | ABC | 27508 | 613
2012-04-11 16:20:54 | 2012-04-09 07:00:00 | ABC | 27508 | 613 |  |  | Date | ABC | XYZ
2012-04-11 09:22:44 | 2012-04-10 07:00:00 | ABC | 28938 | 444 |  |  | 2012-04-09 00:00:00
2012-04-02 10:08:45 | 2012-04-10 07:00:00 | ABC | 34189 | 525 |  |  | 2012-04-10 00:00:00
2012-04-09 14:47:21 | 2012-04-10 07:00:00 | ABC | 28938 | 444 |  |  | 2012-04-11 00:00:00
2012-04-11 16:20:54 | 2012-04-10 07:00:00 | ABC | 28938 | 444 |  |  | 2012-04-12 00:00:00
2012-04-11 09:22:44 | 2012-04-11 07:00:00 | ABC | 30330 | 825 |  |  | 2012-04-13 00:00:00
2012-04-02 10:08:45 | 2012-04-11 07:00:00 | ABC | 35835 | 973 |  |  | 2012-04-14 00:00:00
2012-04-09 14:47:21 | 2012-04-11 07:00:00 | ABC | 30330 | 825
2012-04-11 16:20:54 | 2012-04-11 07:00:00 | ABC | 30330 | 825 |  |  | Want sum of Volume1 and Volume2 by Volume Date for the Latest Forecast Date and Time.
2012-04-11 09:22:44 | 2012-04-12 07:00:00 | ABC | 29919 | 351
2012-04-02 10:08:45 | 2012-04-12 07:00:00 | ABC | 35349 | 415 |  |  | Highlighted the Expected Rows of Data
2012-04-09 14:47:21 | 2012-04-12 07:00:00 | ABC | 29919 | 351
2012-04-11 16:20:54 | 2012-04-12 07:00:00 | ABC | 29919 | 351
2012-04-11 09:22:44 | 2012-04-13 07:00:00 | ABC | 27311 | 711
2012-04-02 10:08:45 | 2012-04-13 07:00:00 | ABC | 32266 | 777
2012-04-09 14:47:21 | 2012-04-13 07:00:00 | ABC | 27311 | 711
2012-04-11 16:20:54 | 2012-04-13 07:00:00 | ABC | 27311 | 711
2012-04-11 07:01:21 | 2012-04-09 07:00:00 | XYZ | 353 | 6
2012-04-02 07:22:13 | 2012-04-09 07:00:00 | XYZ | 353 | 6
2012-04-11 13:58:57 | 2012-04-09 07:00:00 | XYZ | 353 | 6
2012-04-11 07:01:21 | 2012-04-10 07:00:00 | XYZ | 374 | 7
2012-04-02 07:22:13 | 2012-04-10 07:00:00 | XYZ | 374 | 7
2012-04-11 13:58:57 | 2012-04-10 07:00:00 | XYZ | 374 | 7
2012-04-11 07:01:21 | 2012-04-11 07:00:00 | XYZ | 347 | 7
2012-04-02 07:22:13 | 2012-04-11 07:00:00 | XYZ | 347 | 7
2012-04-11 13:58:57 | 2012-04-11 07:00:00 | XYZ | 347 | 7
2012-04-11 07:01:21 | 2012-04-12 07:00:00 | XYZ | 355 | 5
2012-04-02 07:22:13 | 2012-04-12 07:00:00 | XYZ | 355 | 5
2012-04-11 13:58:57 | 2012-04-12 07:00:00 | XYZ | 355 | 5
2012-04-11 07:01:21 | 2012-04-13 07:00:00 | XYZ | 325 | 8
2012-04-02 07:22:13 | 2012-04-13 07:00:00 | XYZ | 325 | 8
2012-04-11 13:58:57 | 2012-04-13 07:00:00 | XYZ | 325 | 8
2012-04-11 07:01:21 | 2012-04-14 07:00:00 | XYZ | 177 | 0
2012-04-02 07:22:13 | 2012-04-14 07:00:00 | XYZ | 177 | 0
2012-04-11 13:58:57 | 2012-04-14 07:00:00 | XYZ | 177 | 0
Spreadsheet: 215926d1361544070-rounding-number-but-not-as-you-would-expect-book1
Sheet: Sheet1

1
1.02
1.05
1.06
1.45
1.5
1.54
1.6
1.8
1.9
1.95
1.99
2
2.02
2.05
2.06
2.45
2.5
2.54
2.6
2.8
2.9
2.95
2.99
3
3.02
3.05
3.06
3.45
Spreadsheet: 122400d1316782326-default-cell-format-is-date-messing-up-pivot-table-example
Sheet: Data

Report to CC | Date | A | B | C | D | Qtr Month | Period |  |  | Qtr Month | (All)
Atlanta | 2010-08-02 00:00:00 | 00:00:00 | 1900-01-02 00:00:00 | 00:00:00 | 00:00:00
Atlanta | 2010-09-01 00:00:00 | 00:00:00 | 00:00:00 | 1900-01-02 00:00:00 | 00:00:00 |  |  |  |  | Sum of A | Column Labels
Seattle | 2010-10-01 00:00:00 | 00:00:00 | 1900-01-08 00:00:00 | 1900-01-04 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | Row Labels | 1 2011 | 10 2010 | 11 2010 | 12 2010 | 2 2011 | 3 2011 | 4 2011 | 5 2011 | 6 2011 | 7 2011 | 8 2010 | 8 2011 | 9 2010 | Grand Total
Philadelphia | 2010-11-01 00:00:00 | 1900-01-09 00:00:00 | 00:00:00 | 1900-01-21 00:00:00 | 1900-01-02 00:00:00 |  |  |  |  | Atlanta |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 1900-01-02 00:00:00 | 00:00:00 | 1900-01-02 00:00:00
Philadelphia | 2010-12-01 00:00:00 | 1900-01-07 00:00:00 | 1900-01-02 00:00:00 | 1900-01-06 00:00:00 | 1900-01-08 00:00:00 |  |  |  |  | Boston | 1900-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-13 00:00:00
Boston | 2011-01-03 00:00:00 | 1900-01-13 00:00:00 | 1900-01-09 00:00:00 | 1900-02-01 00:00:00 | 1900-02-11 00:00:00 |  |  |  |  | Detroit |  |  |  |  |  | 1900-01-08 00:00:00 |  |  |  |  |  |  |  | 1900-01-08 00:00:00
Seattle | 2011-02-01 00:00:00 | 1900-01-07 00:00:00 | 1900-01-04 00:00:00 | 1900-01-19 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | Hawaii |  |  |  |  |  |  |  |  | 1900-01-02 00:00:00 |  |  |  |  | 1900-01-02 00:00:00
Detroit | 2011-03-01 00:00:00 | 1900-01-08 00:00:00 | 1900-01-02 00:00:00 | 1900-01-01 00:00:00 | 1900-01-03 00:00:00 |  |  |  |  | Los Angeles |  |  |  |  |  |  | 1900-01-04 00:00:00 |  |  | 00:00:00 |  |  |  | 1900-01-04 00:00:00
Los Angeles | 2011-04-01 00:00:00 | 1900-01-04 00:00:00 | 00:00:00 | 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | Philadelphia |  |  | 1900-01-09 00:00:00 | 1900-01-07 00:00:00 |  |  |  |  |  |  |  |  |  | 1900-01-16 00:00:00
Seattle | 2011-05-02 00:00:00 | 00:00:00 | 1900-01-06 00:00:00 | 1900-01-06 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | Seattle |  | 00:00:00 |  |  | 1900-01-07 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 1900-01-07 00:00:00
Hawaii | 2011-06-02 00:00:00 | 1900-01-02 00:00:00 | 00:00:00 | 1900-01-01 00:00:00 | 00:00:00 |  |  |  |  | Grand Total | 1900-01-13 00:00:00 | 00:00:00 | 1900-01-09 00:00:00 | 1900-01-07 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 | 1900-01-04 00:00:00 | 00:00:00 | 1900-01-02 00:00:00 | 00:00:00 | 00:00:00 | 1900-01-02 00:00:00 | 00:00:00 | 1900-02-21 00:00:00
Los Angeles | 2011-07-01 00:00:00 | 00:00:00 | 1900-01-02 00:00:00 | 00:00:00 | 1900-01-02 00:00:00
Atlanta | 2011-08-01 00:00:00 | 1900-01-02 00:00:00 | 00:00:00 | 1900-01-04 00:00:00 | 00:00:00
Spreadsheet: 233800d1367933221-take-certain-data-from-invoice-xls-and-show-on-different-sheet-april-2013-wex-invoice-solution
Sheet: APR

 | Group | APR
 |  | Card Number | Vehicle Card Department | Customer Vehicle ID | Transaction Date | Transaction Time | Unit Cost | Fuel Cost | Net Cost (=)
 | 1 | 0302 - 1 | DAIRY | 805 | 2013-04-19 00:00:00 | 08:25:02 | 3.4 | 61.27 | 57.97
 | 2 | 0302 - 1 | DAIRY | 805 | 2013-04-04 00:00:00 | 13:46:40 | 3.5 | 9 | 8.53
 | 3 | 0302 - 1 | DAIRY | 805 | 2013-04-16 00:00:00 | 08:30:39 | 3.4 | 61.1 | 57.81
 | 4 | 0302 - 1 | DAIRY | 805 | 2013-04-25 00:00:00 | 15:34:33 | 3.17 | 55.95 | 52.72
 | 5 | 0302 - 1 | DAIRY | 805 | 2013-04-23 00:00:00 | 06:09:41 | 3.17 | 61.71 | 58.15
 | 6 | 0302 - 1 | DAIRY | 805 | 2013-04-14 00:00:00 | 16:18:00 | 3.48 | 59.72 | 56.58
 | 7 | 0302 - 1 | DAIRY | 805 | 2013-04-29 00:00:00 | 10:05:22 | 3.2 | 52.85 | 49.83
 | 8 | 0302 - 1 | DAIRY | 805 | 2013-04-30 00:00:00 | 14:44:00 | 3.36 | 57.6 | 54.46
 | 9 | 0295 - 1 | DIR | 798 | 2013-04-29 00:00:00 | 14:49:15 | 3.3 | 21.46 | 20.27
 | 10 | 0295 - 1 | DIR | 798 | 2013-04-26 00:00:00 | 12:28:00 | 3.34 | 44.85 | 42.39
 | 11 | 0295 - 1 | DIR | 798 | 2013-04-01 00:00:00 | 13:40:06 | 3.5 | 26.03 | 24.67
 | 12 | 0295 - 1 | DIR | 798 | 2013-04-18 00:00:00 | 15:12:23 | 3.26 | 36.11 | 34.08
 | 13 | 0295 - 1 | DIR | 798 | 2013-04-24 00:00:00 | 09:44:00 | 3.36 | 43.05 | 40.71
 | 14 | 0295 - 1 | DIR | 798 | 2013-04-16 00:00:00 | 15:45:57 | 3.3 | 32.37 | 30.57
 | 15 | 0302 - 1 | DAIRY | 805 | 2013-04-25 00:00:00 | 06:57:00 | 0 | 0 | 0
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
Spreadsheet: 8cb1e853-e1f7-4a31-bf3c-6da3f34f55c8
Sheet: Data Valid

Budget |  |  | Inst. - Salaries (0100) |  |  | Capitalized Equipment (0730)
[NAME] |  |  | Inst. - Employee Benefits (0200) |  |  | Non-Capitalized Equipment (0735)
Annual Financial Report |  |  | Inst. - Purchased Professional & Technical Services (0300)
 |  |  | Inst. - Other Purchased Services (0500)
Project 1-Year 1 |  |  | Inst. - Travel, Registration and Entrance (0580)
Project 2-Year 1 |  |  | Inst. - Supplies (0600)
Project 3-Year 1 |  |  | Support - Salaries (0100)
Project 4-Year 1 |  |  | Support - Employee Benefits (0200)
Project 5-Year 1 |  |  | Support - Purchased Professional & Technical Services (0300)
Project 1-Year 2 |  |  | Support - Other Purchased Services (0500)
Project 2-Year 2 |  |  | Support - Travel, Registration and Entrance (0580)
Project 3-Year 2 |  |  | Support - Supplies (0600)
Project 4-Year 2
Project 5-Year 2
Project 1-Year 3
Project 2-Year 3
Project 3-Year 3
Project 4-Year 3
Project 5-Year 3
Spreadsheet: 187e3ca8-750a-4cf4-8ede-b816c09241f0
Sheet: External Node Economic Charge

Day Ahead Net Commitment Period Compensation Settlement Summary Report
SR_DANCPCSTLSUM_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT
Trading Interval | External Node ID | External [NAME] Name | Total External Node Day Ahead Economic NCPC Credits | NCPC Credit Type | Participant External Node Day Ahead Load Obligation | Total External Node  Day Ahead Load Obligation | Participant External Node Day Ahead Generation Obligation | Total External Node Day Ahead Generation Obligation | Participant External Node Day Ahead Economic NCPC Charge
Hour End | Number | String | $ | String | MWh | MWh | MWh | MWh | $
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: WebofScience

Web of Science (Thomson)
2010-2011
COUNTER-Compliant?: | Yes
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 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 | 2010-2011 Price | Price per unit
BIOSIS Previews
Sessions | 14 | 17 | 93 | 266 | 60 | 38 | 20 | 43 | 90 | 45 | 30 | 29
Queries | 28 | 66 | 410 | 1263 | 198 | 130 | 129 | 164 | 316 | 99 | 84 | 102 |  | 0
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 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
CrossSearch
Sessions | 674 | 568 | 1004 | 1193 | 1140 | 727 | 583 | 921 | 1105 | 996 | 761 | 869
Queries | 356 | 578 | 910 | 873 | 1416 | 722 | 658 | 623 | 666 | 838 | 634 | 521
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 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
Web of Knowledge
Sessions | 1358 | 1017 | 1680 | 1756 | 1569 | 1228 | 1280 | 1650 | 1482 | 1608 | 1289 | 1623
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 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 | 2010-2011 Price | Price per unit
Web of Science
Sessions | 1105 | 803 | 1299 | 1195 | 1194 | 950 | 1054 | 1315 | 1116 | 1260 | 1013 | 1302
Queries | 3297 | 3348 | 3747 | 3423 | 4674 | 2889 | 2855 | 4062 | 3693 | 3560 | 3208 | 4251 |  | 0
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 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
[NAME]
Logins | 9 | 0 | 6 | 1 | 16 | 6 | 0 | 1 | 9 | 3 | 7 | 14
New Users | 0 | 0 | 4 | 0 | 10 | 0 | 0 | 4 | 0 | 0 | 5 | 0
New References | 3 | 0 | 12 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 9
Exports | 5 | 2 | 3 | 3 | 4 | 0 | 0 | 2 | 19 | 11 | 3 | 4
Imports | 0 | 0 | 5 | 0 | 16 | 0 | 0 | 2 | 0 | 2 | 21 | 32
Searches | 13 | 0 | 2 | 1 | 56 | 0 | 0 | 0 | 0 | 0 | 0 | 10
[NAME] | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0
CWYW [NAME] | 10 | 0 | 1 | 0 | 49 | 0 | 0 | 0 | 0 | 0 | 0 | 7
CWYW Traveling Library | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Pages Served | 40 | 2 | 34 | 5 | 154 | 6 | 0 | 9 | 28 | 16 | 43 | 76
Spreadsheet: kate_symes__18750__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-28 00:00:00 |  | 210.95 | 35888 | 157.73 | 17224
 | 2001-02-27 00:00:00 |  | 212.87 | 43088 | 151.44 | 17224
 | 2001-02-26 00:00:00 |  | 213.28 | 12320 | 160.3 | 8024
 | 2001-02-25 00:00:00 |  |  |  |  |  | 160.3 | 24072
 | 2001-02-24 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-23 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-22 00:00:00 |  | 253.56 | 46656 | 179.33 | 2824
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
 | 2001-02-19 00:00:00 |  | 288.65 | 24912 | 233.15 | 15840
 | 2001-02-18 00:00:00 |  |  |  |  |  | 283.43 | 35232
 | 2001-02-17 00:00:00 |  | 326.1 | 15872 | 283.43 | 12024
 | 2001-02-16 00:00:00 |  | 437.9 | 29440 | 370.12 | 17208
 | 2001-02-15 00:00:00 |  | 437.9 | 29440 | 370.34 | 18008
 | 2001-02-14 00:00:00 |  | 319.81 | 40656 | 284.13 | 14112
 | 2001-02-13 00:00:00 |  | 284.75 | 33888 | 247.23 | 14448
 | 2001-02-12 00:00:00 |  | 252.44 | 33552 | 233.02 | 14640
 | 2001-02-11 00:00:00 |  |  |  |  |  | 233.02 | 43920
 | 2001-02-10 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-09 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-08 00:00:00 |  | 274.83 | 37456 | 223.07 | 17808
 | 2001-02-07 00:00:00 |  | 251 | 44352 | 218.57 | 14240
 | 2001-02-06 00:00:00 |  | 201.06 | 29952 | 192.99 | 12024
 | 2001-02-05 00:00:00 |  | 180.21 | 10352 | 164.84 | 1008
 | 2001-02-04 00:00:00 |  |  |  |  |  | 166.31 | 4200
 | 2001-02-03 00:00:00 |  | 211.99 | 15456 | 193.3 | 7832
 | 2001-02-02 00:00:00 |  | 215.28 | 26256 | 190.89 | 11032
 | 2001-02-01 00:00:00 |  | 280.34 | 28432 | 276.27 | 13400
 | 2001-01-31 00:00:00 |  | 333.27 | 24800 | 306.35 | 12400
 | 2001-01-30 00:00:00 |  | 314.59 | 22400 | 287.77 | 12784
 | 2001-01-29 00:00:00 |  | 286.67 | 15600 | 277.58 | 9504
Spreadsheet: 377033d1423773430-several-issues-at-once-helpmeexcel
Sheet: Vendor 3

Item Number | Distributor | Description | UM | Size | Case Qty | Cost/ea | Cost/UM | Cost/Case | Type | Use | Frequency | Not Applicable
1 | v3 | Cleaner 8 oz Can | can | 8 | 12 |  |  | 200.19 | [NAME] | Expendable | 2
2 | v3 | Nitrile Glove | box | 100 | 10 |  |  | 50.87 | Glove | Expendable | 1
3 | v3 | Paper 800ft | roll | 800 | 4 |  |  | 40.01 | Towel | Expendable | 3
4 | v3 | 55 gallon thick | roll | 25 | 10 |  |  | 34.75 | [NAME] | Expendable | 1
5 | v3 | Lobby broom plastic | ea | 1 | 1 |  |  | 5.68 | Broom | Non-Expendable | 0
6 | v3 | 20 gallon [NAME] | roll | 50 | 10 |  |  | 34 | [NAME] | Expendable | 1
Spreadsheet: 796601d1663396086-summing-based-on-criteria-2022-09-17-oeldere-passi-excel-test-data
Sheet: Sheet1

 | Group | Grp A | Grp B | Grp C | 187 | 190 | 125 | 102 | 421 | 854 | 223 | 859 | 124 | 365 | 741 |  |  | NR | Group
 |  | 125421741102 | 854365 | 187190223859124 |  | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |  |  | 102 | A
 | salaries |  |  |  | 451 | 68 | 984 | 251 | 548 | 458 | 14 | 487 | 54 | 879 | 254 |  |  | 124 | C
 | consumables |  |  |  | 54 | 69 | 78 | 14 | 87 | 25 | 65 | 5 | 45 | 65 | 12 |  |  | 125 | A
 | freight |  |  |  | 65 | 5 | 45 | 65 | 12 | 45 | 6 | 84 | 25 | 84 | 14 |  |  | 187 | C
 | overheads |  |  |  | 7 | 8 | 7 | 45 | 48 | 64 | 1 | 88 | 98 | 45 | 1 |  |  | 190 | C
 | fuel |  |  |  | 12 | 54 | 65 | 84 | 12 | 56 | 5 | 8 | 7 | 1 | 0 |  |  | 223 | C
 | testing exp |  |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 8 | 8 | 4 | 5 |  |  | 365 | B
 | travel |  |  |  | 1 | 8 | 0 | 0 | 0 | 45 | 12 | 52 | 6 | 4 | 3 |  |  | 421 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 741 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 854 | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 859 | C
Spreadsheet: 843840d1695668465-get-date-value-based-on-contents-of-another-cell-book2
Sheet: Sheet1

HIGH VALUE
 | 2023-08-01 00:00:00 | 2023-07-06 00:00:00 | 2023-04-06 00:00:00 | 2023-01-30 00:00:00 | 2023-01-19 00:00:00 | 2023-01-19 00:00:00
HIGH DATE
LOW VALUE
LOW DATE
RESULTS | 40 | 30 | 33 | 33 | 47 | 51
HIGH DATE
SHOULD BE
47   - (CELL F9)
VALUE 1/19/2023
LOW DATE
SHOULD BE
30 - (CELL C9)
VALUE = 7/6/2023
Spreadsheet: 114679d1310409192-creating-a-running-total-for-a-budget-budgetexample-07-11-11
Sheet: Budget

Date | Check Number | Description | Balance | Reconcile ü | Tax  Deductable ü | Expense FOF | Expense Insurance | Expense Mortgage | Expense Parking | Expense Utilities | Expense Gas
2011-07-05 00:00:00 |  | Beginning Bal |  |  |  | 50 | 40 | 510 | 40 | 360 | 200
2011-07-06 00:00:00 |  | FOF |  |  | ü | -50 | 0 | 0 | 0 | 0 | 0
 |  | Charity
2011-07-06 00:00:00 |  | Mortgage |  |  |  | 0 | 0 | 200 | 0 | 0 | 0
 |  | Extra pmt |  |  |  | 0
2011-07-07 00:00:00 |  | Deposit |  |  |  | 0 | 0 | 0 | 0 | 0 | 100
 |  | Increase in gas |  |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0
Spreadsheet: 854583d1704401474-c2-c4-then-c5-c7-dragging-book
Sheet: Sheet1

Date | A | B | C
2024-01-01 00:00:00 |  | 1.8 | 1.78
2024-01-01 00:00:00 | 0.014 | 1.72 | 1.71
2024-01-01 00:00:00 |  | 1.68 | 1.65
2024-01-02 00:00:00 |  | 1.74 | 1.72
2024-01-02 00:00:00 | 0.015 | 1.68 | 1.64
2024-01-02 00:00:00 |  | 1.6 | 1.56
2024-01-03 00:00:00 |  | 1.72 | 1.7
2024-01-03 00:00:00 | 0.014 | 1.69 | 1.73
2024-01-03 00:00:00
2024-01-04 00:00:00 |  | 1.65 | 1.6
2024-01-04 00:00:00 | 0.015 | 1.68 | 1.63
2024-01-04 00:00:00 |  | 1.76 | 1.74
2024-01-05 00:00:00 |  | 1.68 | 1.66
2024-01-05 00:00:00 | 0.014 | 1.74 | 1.77
2024-01-05 00:00:00 |  | 1.79 | 1.82
2024-01-06 00:00:00 |  | 2.12 | 2.1
2024-01-06 00:00:00 | 0.014 | 2.05 | 2.01
2024-01-06 00:00:00
2024-01-07 00:00:00 |  | 1.78 | 1.76
2024-01-07 00:00:00 | 0.014 | 1.84 | 1.81
2024-01-07 00:00:00 |  | 1.91 | 1.93
2024-01-08 00:00:00 |  | 1.87 | 1.85
2024-01-08 00:00:00 | 0.015 | 1.63 | 1.6
2024-01-08 00:00:00 |  | 2.02 | 2.07
2024-01-09 00:00:00 |  | 2.17 | 2.12
2024-01-09 00:00:00 | 0.015 | 2.05 | 2.01
2024-01-09 00:00:00 |  | 2.02 | 2.04
2024-01-10 00:00:00 |  | 2 | 1.98
2024-01-10 00:00:00 | 0.015 | 2.02 | 2.04
2024-01-10 00:00:00 |  | 1.91 | 1.94
2024-01-11 00:00:00 |  | 1.91 | 1.94
2024-01-11 00:00:00 | 0.015 | 1.99 | 2.01
2024-01-11 00:00:00 |  | 2.2 | 2.17
2024-01-12 00:00:00 |  | 2.06 | 2
2024-01-12 00:00:00 | 0.015 | 1.98 | 1.96
2024-01-12 00:00:00 |  | 1.93 | 1.9
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 57

कार्यक्रम PROGRAM |  |  | REFRESHER PROGRAM FOR INSPECTING OFFICERS | PROG CODE
 |  |  |  | IT 1906
तर्षर् समूह/JOB FAMILY |  |  | INTERNAL CONTROL, INSPECTION & RISK MANAGEMENT
उद्देश्य/OBJECTIVE |  |  | REFRESHER PROGRAM FOR INSPECTING OFFICERS
लतक्षि समूह/TARGET GROUP |  |  | INSPECTING OFFICERS
अर्तध/DURATION |  |  | 2 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Role   of   IOs   in   conducting   Investigation,   Important   aspects/ techniques  of  Audit,  Spot  rectification  and  its  related  aspects, concurrent audit, snap audit, IS Audit, Quality Audit, Legal Audit and Critical analysis of previous [NAME] report
 | II | Objective  Reporting  -  Latest  RBIA  matrix  as  per  Basanth  Seth Committee,  Web  Based  Inspection  package  (DARPAN)  –  Various modules, features, Menus etc.
 | III | Credit related matters –MSME/AGRI/General, consortium, corporate accounts  including  LBA  accounts,  Balance  sheet  analysis/Credit Appraisal from IO point of view.
 | IV | Fraud detection / Comment on RFA / EWS detection, Frauds modus operandi  and  Vigilance angle  –  reporting  system.  Income  leakage, Income audit Special Report, critical analysis of part B and carried over observations, critical analysis of RBIA Report already submitted by IOs
Day 2 | I | FCR  –ROI-Linking  to  MCLR/RRLR,  Repayment  Schedules,  Security linking, Rating updations, Concept of RPA and AOD, Remittances to loan  a/c.  FCR  –  overall  agricultural  advances  (DND  Concepts). Checking  of  GL  Transactions  and  other  Mandatory  reports.  FEX  – basics from inspection angle, FEX – latest updations & developments including FEMA amendments/ Inspection of Overseas branches/ FD/ designated branches & ECGC cover,etc.
 | II | Legal  Aspects,  Documentation,  Mortgage,  EMT,  [NAME],  CERSAI, BHOOMI, CIBIL and Stamp Act, NPA, Recovery, Restructuring, Write off, SARFESI, DRT, CGTMSE, CGFMU and Insolvency code, etc.
 | III | Inspection Policy, Latest guidelines related to ITIO / GTZI, Analysis of Miscellaneous aspects e.g. Cash/Security/Nomination /KYC/HRMS/Deposit Accounts etc. from IO point of View.
 | IV | PIDPI  Resolution,  Role  of  IO’s  in  conducting  enquiries,  Ethics  and Governance, Forensic audit Overview.
Spreadsheet: 717244d1612540539-recurring-dates-expressed-as-a-fraction-of-a-month-sample-book
Sheet: Sheet1

 | Start Date | Times in Future | My [NAME] calculating the distance between B1 and dates in column C
 | 2020-12-31 00:00:00 | 2021-02-01 00:00:00
 |  | 2021-02-02 00:00:00
 |  | 2021-02-03 00:00:00
 |  | 2021-02-04 00:00:00
 |  | 2021-02-05 00:00:00
 |  | 2021-02-06 00:00:00
 |  | 2021-02-07 00:00:00
 |  | 2021-02-08 00:00:00
 |  | 2021-02-09 00:00:00
 |  | 2021-02-10 00:00:00
 |  | 2021-02-11 00:00:00
 |  | 2021-02-12 00:00:00
 |  | 2021-02-13 00:00:00
 |  | 2021-02-14 00:00:00
 |  | 2021-02-15 00:00:00
 |  | 2021-02-16 00:00:00
 |  | 2021-02-17 00:00:00
 |  | 2021-02-18 00:00:00
 |  | 2021-02-19 00:00:00
 |  | 2021-02-20 00:00:00
 |  | 2021-02-21 00:00:00
 |  | 2021-02-22 00:00:00
 |  | 2021-02-23 00:00:00
 |  | 2021-02-24 00:00:00
 |  | 2021-02-25 00:00:00
 |  | 2021-02-26 00:00:00
 |  | 2021-02-27 00:00:00
 |  | 2021-02-28 00:00:00
Spreadsheet: 871321d1717696319-sla-business-hours-calculation-isolated-date-issue-jamessullivan88-
Sheet: Sheet1

 |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | Input
 | Open | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 00:00:00 | 00:00:00 |  | 2024-06-03 09:30:00
 | Closed | 18:00:00 | 18:00:00 | 18:00:00 | 18:00:00 | 18:00:00 | 00:00:00 | 00:00:00
 | SLA | 48 |  |  |  |  |  |  |  | Expected
 | The formula must calculate 24 hours from the input point but only take into account
 | the actual working hours, this means deducting 8.5hrs from mon, 8.5hrs for tues, and |  |  |  |  |  |  |  |  | Actual
 | 7hrs for Wednesday giving us the expected value.
Spreadsheet: 676577d1588874007-how-to-add-number-to-the-general-format-add-number-to-general-format
Sheet: Sheet1

M-AB-001 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 130954d1322668417-re-arrange-a-worksheet-range-to-a-pivot-friendly-table-forumquestion-xytabletopivotfriendlytable
Sheet: Sheet7

Row | Column2 | Column1 | Column | Value
40876.[PHONE]@Task A |  |  | Robb | 6
40876.[PHONE]@Task A |  |  | Sansa | 4
40876.[PHONE]@Task A |  |  | [NAME] | 5
40876.[PHONE]@Task A |  |  | Arya | 8
40876.[PHONE]@Task A |  |  | [NAME] | 9
40877.[PHONE]@Task B |  |  | Robb | 8
40877.[PHONE]@Task B |  |  | Sansa | 6
40877.[PHONE]@Task B |  |  | [NAME] | 9
40877.[PHONE]@Task B |  |  | Arya | 8
40877.[PHONE]@Task B |  |  | [NAME] | 4
40880.[PHONE]@Task A |  |  | Robb | 5
40880.[PHONE]@Task A |  |  | Sansa | 6
40880.[PHONE]@Task A |  |  | [NAME] | 7
40880.[PHONE]@Task A |  |  | Arya | 9
40880.[PHONE]@Task A |  |  | [NAME] | 4
DELETE COLUMN A