tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 329706d1404388496-calculate-duration-from-effort-calculation-example
Sheet: Sheet1

Name | Week number | Base Availability | Adjusted Availability | Week Start Date | Week End Date | Day
[NAME] | 1 | 1 | 0.6 | 2014-06-30 00:00:00 | 2014-07-04 00:00:00 | 2014-06-30 00:00:00
[NAME] | 1 | 1 | 0.6 | 2014-06-30 00:00:00 | 2014-07-04 00:00:00 | 2014-07-01 00:00:00
[NAME] | 1 | 1 | 0.6 | 2014-06-30 00:00:00 | 2014-07-04 00:00:00 | 2014-07-02 00:00:00
[NAME] | 1 | 0 | 0 | 2014-06-30 00:00:00 | 2014-07-04 00:00:00 | 2014-07-03 00:00:00 |  |  | Running total of adjusted availability
[NAME] | 1 | 0 | 0 | 2014-06-30 00:00:00 | 2014-07-04 00:00:00 | 2014-07-04 00:00:00 |  | [NAME] starts here as start date is 4th July
[NAME] | 2 | 1 | 0.6 | 2014-07-07 00:00:00 | 2014-07-11 00:00:00 | 2014-07-07 00:00:00
[NAME] | 2 | 1 | 0.6 | 2014-07-07 00:00:00 | 2014-07-11 00:00:00 | 2014-07-08 00:00:00
[NAME] | 2 | 1 | 0.6 | 2014-07-07 00:00:00 | 2014-07-11 00:00:00 | 2014-07-09 00:00:00
[NAME] | 2 | 1 | 0.6 | 2014-07-07 00:00:00 | 2014-07-11 00:00:00 | 2014-07-10 00:00:00
[NAME] | 2 | 1 | 0.6 | 2014-07-07 00:00:00 | 2014-07-11 00:00:00 | 2014-07-11 00:00:00
[NAME] | 3 | 1 | 0.6 | 2014-07-14 00:00:00 | 2014-07-18 00:00:00 | 2014-07-14 00:00:00
[NAME] | 3 | 1 | 0.6 | 2014-07-14 00:00:00 | 2014-07-18 00:00:00 | 2014-07-15 00:00:00 |  | Ends here for [NAME] as 4.2 >= 4 days estimated effort
[NAME] | 3 | 1 | 0.6 | 2014-07-14 00:00:00 | 2014-07-18 00:00:00 | 2014-07-16 00:00:00
[NAME] | 3 | 1 | 0.6 | 2014-07-14 00:00:00 | 2014-07-18 00:00:00 | 2014-07-17 00:00:00
[NAME] | 3 | 1 | 0.6 | 2014-07-14 00:00:00 | 2014-07-18 00:00:00 | 2014-07-18 00:00:00
[NAME] | 1 | 1 | 1 | 2014-06-30 00:00:00 | 2014-07-04 00:00:00 | 2014-06-30 00:00:00
[NAME] | 1 | 1 | 1 | 2014-06-30 00:00:00 | 2014-07-04 00:00:00 | 2014-07-01 00:00:00
[NAME] | 1 | 1 | 1 | 2014-06-30 00:00:00 | 2014-07-04 00:00:00 | 2014-07-02 00:00:00
[NAME] | 1 | 1 | 1 | 2014-06-30 00:00:00 | 2014-07-04 00:00:00 | 2014-07-03 00:00:00
[NAME] | 1 | 1 | 1 | 2014-06-30 00:00:00 | 2014-07-04 00:00:00 | 2014-07-04 00:00:00 |  | [NAME] starts here as start date is 4th July
[NAME] | 2 | 1 | 1 | 2014-07-07 00:00:00 | 2014-07-11 00:00:00 | 2014-07-07 00:00:00 |  | Ends here for [NAME] as 2 >= 2 days estimated effort
[NAME] | 2 | 1 | 1 | 2014-07-07 00:00:00 | 2014-07-11 00:00:00 | 2014-07-08 00:00:00
ticket | assigned to | effort | Start Date | estimated complete date |  |  |  | [NAME] as
TKT-1 | [NAME] | 4 | 2014-07-04 00:00:00 | ????? |  |  |  | 2014-07-15 00:00:00
TKT-1 | [NAME] | 2 | 2014-07-04 00:00:00 | ????? |  |  |  | 2014-07-07 00:00:00
Spreadsheet: 216093d1361578676-vlookup-formula-issue-fishing-orders
Sheet: States

Name | Abbreviation | Region | Region#
ALABAMA | AL | SE |  |  |  | Region Numbers
ALASKA | AK | W |  |  |  | SE | 2
ARIZONA | AZ | SW |  |  |  | W | 5
ARKANSAS | AR | SE |  |  |  | SW | 4
CALIFORNIA | CA | W |  |  |  | NE | 1
COLORADO | CO | W |  |  |  | MW | 3
CONNECTICUT | CT | NE
DELAWARE | DE | NE
DISTRICT OF COLUMBIA | DC | NE
FLORIDA | FL | SE
GEORGIA | GA | SE
HAWAII | HI | W
IDAHO | ID | W
ILLINOIS | IL | MW
INDIANA | IN | MW
IOWA | IA | MW
KANSAS | KS | MW
KENTUCKY | KY | SE
LOUISIANA | LA | SE
MAINE | ME | NE
MARYLAND | MD | NE
MASSACHUSETTS | MA | NE
MICHIGAN | MI | MW
MINNESOTA | MN | MW
MISSISSIPPI | MS | SE
MISSOURI | MO | MW
MONTANA | MT | W
NEBRASKA | NE | MW
NEVADA | NV | W
NEW HAMPSHIRE | NH | NE
NEW JERSEY | NJ | NE
NEW MEXICO | NM | SW
NEW YORK | NY | NE
NORTH CAROLINA | NC | SE
NORTH DAKOTA | ND | MW
OHIO | OH | MW
OKLAHOMA | OK | SW
OREGON | OR | W
PENNSYLVANIA | PA | NE
RHODE ISLAND | RI | NE
SOUTH CAROLINA | SC | SE
SOUTH DAKOTA | SD | MW
TENNESSEE | TN | SE
TEXAS | TX | SW
UTAH | UT | W
[NAME] | VT | NE
VIRGINIA | VA | SE
WASHINGTON | WA | W
WEST VIRGINIA | WV | SE
WISCONSIN | WI | MW
WYOMING | WY | W
Spreadsheet: 868769d1715447576-how-to-work-out-time-when-passed-24-hours-time-sheet-blayde-
Sheet: Sheet1

 |  |  |  |  |  | Time Start | Time Finish | Time Spent
 |  |  |  |  |  | 09:00:00 | 09:15:00
 |  |  |  |  |  | 09:15:00 | 09:20:00
 |  |  |  |  |  | 09:20:00 | 09:22:00
 |  |  |  |  |  | 09:30:00 | 10:00:00
 |  |  |  |  |  | 10:05:00 | 10:15:00
 |  |  |  |  |  | 10:30:00 | 10:40:00
 |  |  |  |  |  | 12:00:00 | 12:10:00
 |  |  |  |  |  | 12:00:00 | 12:40:00
 |  |  |  |  |  | 12:15:00 | 12:25:00
 |  |  |  |  |  | 14:30:00 | 14:50:00
 |  |  |  |  |  | 15:30:00 | 15:40:00
 |  |  |  |  |  | 17:30:00 | 18:20:00
 |  |  |  |  |  | 16:30:00 | 16:45:00
 |  |  |  |  |  | 18:30:00 | 18:40:00
 |  |  |  |  |  | 19:30:00 | 19:35:00
 |  |  |  |  |  | 18:30:00 | 19:10:00
 |  |  |  |  |  | 19:15:00 | 19:30:00
 |  |  |  |  |  | 22:00:00 | 22:05:00
 |  |  |  |  |  | 22:10:00 | 22:15:00
 |  |  |  |  |  | 22:15:00 | 22:30:00
 |  |  |  |  |  | 22:30:00 | 01:30:00
Spreadsheet: 766178d1643792996-averaging-values-based-on-multiple-conditions-copy-of-sample-10-
Sheet: Sheet1 (2)

 |  | 1 | 2 | 3 | 4 | 5 |  | SUM | COUNT |  |  | Start row | 3 |  | 3
A | 1 | 78 |  |  |  |  |  |  |  |  |  | Start column | C |  | 3
A | 2 | 99 |  | 83 |  |  |  |  |  |  |  | End row | 5 |  | 5
A | 3 | 72 | 93 |  | 79 | 85 |  |  |  |  |  | End Column | E |  | 5
A | 4 | 83 | 89 |  |  | 75
B | 1 | 89 |  | 82 |  |  |  |  |  |  | INDIRECT formula
B | 2 |  |  |  | 93 | 96
B | 3 | 81 |  | 72 |  |  |  |  |  |  | OFFSET formula
B | 4 |  |  |  |  | 91
C | 1 | 77 |  |  |  |  |  |  |  |  |  | C-G need 1,2,3
C | 2 |  | 91 | 79 |  |  |  |  |  |  |  | B need 2,3,4
C | 3 |  |  |  | 89 |  |  |  |  |  |  | A need A
C | 4 | 92 |  | 84 | 78
Spreadsheet: 552792d1513778240-data-dependent-drop-down-query-excel-forum-data-dependant-drop-down-validation
Sheet: Sheet1

 |  |  |  |  | Size | Thickness | Pressure
Select size | 10 |  |  |  | 10 | 1 | 120
Select Thickness | ??? |  |  |  | 10 | 1.5 | 130
Pressure | Retrieve pressure value based |  |  |  | 10 | 2 | 140
 | on Size and Thickness |  |  |  | 10 | 2.5 | 150
 |  |  |  |  | 10 | 3 | 160
 |  |  |  |  | 12 | 1 | 110
 |  |  |  |  | 12 | 1.5 | 120
 |  |  |  |  | 12 | 2 | 130
 |  |  |  |  | 12 | 2.5 | 140
 |  |  |  |  | 12 | 3 | 150
 |  |  |  |  | 16 | 1 | 90
 |  |  |  |  | 16 | 1.5 | 100
 |  |  |  |  | 16 | 2 | 110
 |  |  |  |  | 16 | 2.5 | 120
 |  |  |  |  | 16 | 3 | 130
Spreadsheet: vkaminski__40795__Enron SAP Timesheet
Sheet: ENRON

Enron SAP Time Sheet
Full Name: |  |  | Time Period     From:
Personnel #: |  |  | To:
Company #
 |  |  |  |  |  |  | Enter appropriate dates in boxes below
Rec. CCtr | WBS element (new projects) | Rec. Order | Network | Oper./act. | Legacy Codes | [NAME] | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD | MM DD
A/A | Absence/Attendance Types | A/A | Absence/Attendance Types | A/A | Absence/Attendance Types |  |  |  |  |  |  |  |  | Emp Sign
AHTP | Addtional Hrs to Projects | FNP | Family Time Off No Pay | POD | Paid Off Duty
APL | Adoption/Paternity Leave | FWP | Family Time Off With Pay | REG | Regular Work Time
[NAME] | Bereavement | HNP | Holiday No-Pay | SCK | Sick Time
CCN | Company Car Use | HOD | Discretionary Holiday | SHF1 | Shift 1
CDN | Civic Duty without Pay | HOL | Company Observed Holiday | SHF2 | Shift 2
CDP | Civic Duty with Pay | INJ | Injury Time | SNOP | Suspension No-Pay
CMPT | Comp Time Taken | LTP | Loss Time w/pay | SPN | Suspension With Pay
CMPW | Comp Time Worked | MIL | Military Leave | [NAME] | Standby Time
DML | Decision Making Leave | MTP | Moving Time w/Pay | TRVL | Travel Time
DRV | Driving Time (DOT) | PER | Personal Time with Pay | UPG | Upgrade
FMLA | Family Medical Leave Act | PLN | Personal Time off w/o Pay | VAC | Vacation
Spreadsheet: 744144d1629017076-find-missing-hours-within-a-day-sample-57-ans
Sheet: MISSING TIME

Hours |  | Need to get this missing Hours | FORMULA
2021-08-14 00:00:00 |  | 2021-08-14 02:00:00 |  | To enter ARRAY formula
2021-08-14 01:00:00 |  | 2021-08-14 03:00:00 |  | Copy and paste the formula in cell
2021-08-14 05:00:00 |  | 2021-08-14 04:00:00 |  | Press F2
2021-08-14 06:00:00 |  | 2021-08-14 13:00:00 |  | Press Ctrl+Shift+Enter together
2021-08-14 07:00:00 |  | 2021-08-14 16:00:00 |  | Excel covers the formula with {}.
2021-08-14 08:00:00 |  | 2021-08-14 19:00:00
2021-08-14 09:00:00
2021-08-14 10:00:00
2021-08-14 11:00:00
2021-08-14 12:00:00
2021-08-14 14:00:00
2021-08-14 15:00:00
2021-08-14 17:00:00
2021-08-14 18:00:00
2021-08-14 20:00:00
Spreadsheet: 150355d1334465868-how-to-pull-multiple-values-examplev2
Sheet: Sheet1

Project Name | Project Function | Consultant | 2012-04-06 00:00:00
Y | PD | AS | A | A | A | A | A
 | PM | SB | A | A | A | A | A
 | SPC | DS | A | A | L | L | A | A
X |  | CC | A | A | A | A | A | A | A
 |  | KB | A | A | A | A | A | A | A
 |  | SS | A | A | A | A | A | L | L
Z |  | AS |  |  |  |  |  | A | A | L | L | L | A
 |  | SB |  |  |  |  |  | A | A | A | A | A | A
 |  | DS |  |  |  |  |  | O | A | A | A | A | A
 |  | CC |  |  |  |  |  |  |  | A | A | A | A
 |  | KB |  |  |  |  |  |  |  | A | A | A | A
 |  | SS |  |  |  |  |  |  |  | A |  | A | A
Spreadsheet: 776748d1649880177-adding-starting-ticket-number-to-raffle-ticket-tracking-raffle_drawing
Sheet: Sheet1

 | Total Tickets Sold
 | 54
 | Winning Number
 | 21
 | Winner
 | [NAME]
Name | Tickets | Lookup
Anne | 5 | 0 | 1,2,3
[NAME] | 5 | 5 | 4,5,6,7,8
[NAME] | 12 | 10 | 9,10,11,12,13,14,15,16,17,18,19,20
[NAME] | 7 | 22 | 21,22,23,24,25,26,27
[NAME] | 8 | 29 | 28,29,30,31,32,33,34,35
Fran | 2 | 37 | 36,37
George | 5 | 39 | 38,39,40,41,42
[NAME] | 3 | 44 | 43,44,45
Ida | 5 | 47 | 46,47,48,49,50
[NAME] | 2 | 52 | 51,52
 |  | 54 | << make sure you extend this formula one row below the names, as shown
Spreadsheet: 33245d1229544775-nested-if-functions-copy-of-roman-3e-tableb
Sheet: Sheet4

 |  | width of blind |  | 1430
 |  | drop of blind |  | 1700 |  |  |  |  |  | [NAME] of headrail |  |  | 1420
 |  |  |  |  |  |  |  |  |  | drop of blind |  |  | 1700
 |  | Hardware allowance | Batten | 45 |  |  |  |  | Timber |  |  |  | 1420 | [NAME]
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 1400 | [NAME]
 |  | no. Of pockets |  | 7.5 |  |  |  |  | Acorn |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | Cleat |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | Cord connector |  |  |  | #N/A
 |  |  | 1 | 265.6666666666666 |  | [NAME] |  |  | China Barrels |  |  |  | #N/A
 |  |  | 2 | 486.3333333333333 |  |  |  |  | [NAME] |  |  |  | #N/A
 |  |  | 3 | 706.9999999999999 |  |  |  |  | Brackets |  |  |  | #N/A
 |  |  | 4 | 927.6666666666665 |  |  |  |  | Screws |  |  |  | #N/A
 |  |  | 5 | 1148.333333333333 |  |  |  |  | string |  |  |  | #N/A
 |  |  | 6 | 1369 |  |  |  |  | string |  |  |  | #N/A | mtr
 |  |  | 7 | 1589.666666666667
 |  |  |  |  |  |  |  |  | spool/ barrel positions |  |  | #N/A | 70
 |  |  | 1/2    pocket | 110.3333333333333 |  | [NAME] |  |  | in mm from end |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  | Customer | HW |  |  |  |  |  | Customer | HW |  | #N/A | #N/A
 |  | Client | [NAME] |  |  |  |  |  | Client | [NAME] |  | #N/A | #N/A
 |  | Order No. | 12345 |  |  |  |  |  | Order No. | 12345 |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Spreadsheet: 884609d1733840235-report-number-of-instances-in-another-sheet-based-on-variable-conditions-tool-order-tracking-development
Sheet: User10

Main | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received
Order Date | 2024-12-03 00:00:00
 | Bag | Technics Polyester Pouch 300mm x 130mm x 195mm | 20.68 | N
Total
Spreadsheet: 116387d1311793905-list-generation-from-lookup-of-values-from-columns-then-rows-stock-disposals-test-case-3-
Sheet: Input sheet

MBR - Inner London - 042
Spreadsheet: 855116d1704808012-search-for-exact-value-from-bottom-on-different-collum-new-microsoft-excel-worksheet-2-
Sheet: Sheet1

Value from bottom | 3
Collum X | Collum Y
A | 1
B | 2 | Wrong
C | 3
D | 2 | Right
E
F | 2 | Wrong
G | 4
=XLOOKUP(TAKE(TAKE(FILTER(B3:B9,B3:B9<>0),-B1),1,),B3:B9,A3:A9,,,-1)
Result
=XLOOKUP(TAKE(TAKE(FILTER(B3:B9,B3:B9<>0),-B1),1,),B3:B9,A3:A9)
Result
How do I lookup for Right result (Which is D) ?
Spreadsheet: 494842d1482799764-comparing-two-cells-to-provide-lowest-number-but-samplegolf
Sheet: Summary

 |  |  |  | Played | Expected | Times | Chance of
VERSUS |  |  |  |  | Result > | Beaten | Beating
Lav |  |  |  |  | 4
Skip |  |  |  |  | 16
Skins |  |  |  |  | 14
Marto |  |  |  |  | 6
Times Beaten = count how many lowest scores (not tied) 'Macca' had if the other player played on the same day
Spreadsheet: 147623d1332885600-sum-column-3-based-on-only-unique-values-in-columns-1-and-2-using-an-array-formula-test
Sheet: Sheet1

Item | Blanket PO# | Remaining Contract QTY | Total Qty Ordered
72227 | 0 | 0 | 0
72231 | 0 | 0 | 0
72234 | 0 | 0 | 0
72559 | 307761 | 262128 | 262168
02298 | 307825 | 971712 | 917712
02303 | 0 | 0 | 0
02313 | 307788 | 290039 | 1540039
02313 | 307788 | 290039 | 1540039
02313 | 307915 | 1250000 | 1540039
02313 | 307915 | 1250000 | 1540039
02327 | 0 | 0 | 0
02347 | 307934 | 50000 | 50000
02350 | 307915 | 50000 | 50000
02360 | 0 | 0 | 0
02378 | 307915 | 50000 | 50000
02397 | 307854 | 50000 | 50000
02400 | 307854 | 457072 | 457072
02402 | 307895 | 150000 | 150000
02405 | 307895 | 200000 | 200000
02416 | 307869 | 50000 | 50000
02417 | 0 | 0 | 0
Spreadsheet: 225234d1364930284-show-column-1-titles-when-filtering-table-tooling-proj
Sheet: Sheet1

Job # | Op # | Hours
job 1
 | Milling | 15
 | wire | 20
job 2
 | Milling | 5
 | Wire | 15
 | EDM | 3
 | Turning | 8
job 3
 | Milling | 10
 | EDM | 11
 | Turning | 4
Spreadsheet: 144029d1330690753-excel-2007-military-time-and-count-if-question-response-time-summary
Sheet: Logsheet

Date | Incident # | Dispatch | Enroute | Onscene | Total Response Time | PMD Level | PA Unit
2012-02-09 00:00:00 | 2042 | 08:08:00 | 08:08:00 | 08:13:00 | 00:05:00 | D | 1
2012-02-09 00:00:00 | 2047 | 09:56:00 | 09:56:00 | 10:02:00 | 00:06:00 | A | 1
2012-02-09 00:00:00 | 2051 | 10:48:00 | 10:48:00 | 10:56:00 | 00:08:00 | A | 1
2012-02-09 00:00:00 | 2054 | 12:03:00 | 12:04:00 | 12:08:00 | 00:05:00 | C | 1
2012-02-09 00:00:00 | 2058 | 12:55:00 | 12:55:00 | 12:58:00 | 00:03:00 | D | 1
2012-02-09 00:00:00 | 2062 | 14:08:00 | 14:09:00 | 14:13:00 | 00:05:00 | D | 1
2012-02-09 00:00:00 | 2067 | 14:49:00 | 14:49:00 | 14:58:00 | 00:09:00 | A | 1
2012-02-09 00:00:00 | 2073 | 16:42:00 | 16:42:00 | 16:43:00 | 00:01:00 | D | 1
2012-02-09 00:00:00 | 2077 | 17:21:00 | 17:21:00 | 17:34:00 | 00:13:00 | C | 1
2012-02-09 00:00:00 | 2044 | 08:26:00 | 08:26:00 | 08:32:00 | 00:06:00 | B | 2
2012-02-09 00:00:00 | 2046 | 09:27:00 | 09:28:00 | 09:33:00 | 00:06:00 | A | 2
2012-02-09 00:00:00 | 2050 | 10:41:00 | 10:41:00 | 10:48:00 | 00:07:00 | D | 2
2012-02-09 00:00:00 | 2055 | 12:10:00 | 12:11:00 | 12:15:00 | 00:05:00 | A | 2
2012-02-09 00:00:00 | 2066 | 14:39:00 | 14:39:00 | 14:43:00 | 00:04:00 | C | 2
2012-02-09 00:00:00 | 2071 | 15:51:00 | 15:52:00 | 16:03:00 | 00:12:00 | O | 2
2012-02-09 00:00:00 | 2072 | 16:25:00 | 16:25:00 | 16:28:00 | 00:03:00 | A | 2
2012-02-09 00:00:00 | 2078 | 17:40:00 | 17:40:00 | 17:47:00 | 00:07:00 | O | 2
2012-02-09 00:00:00 | 2039 | 06:54:00 | 06:57:00 | 07:12:00 | 00:18:00 | A | 3
2012-02-09 00:00:00 | 2041 | 08:05:00 | 08:06:00 | 08:14:00 | 00:09:00 | C | 3
2012-02-09 00:00:00 | 2045 | 09:15:00 | 09:15:00 | 09:21:00 | 00:06:00 | C | 3
2012-02-09 00:00:00 | 2049 | 10:29:00 | 10:29:00 | 10:36:00 | 00:07:00 | C | 3
2012-02-09 00:00:00 | 2057 | 12:53:00 | 12:53:00 | 12:56:00 | 00:03:00 | C | 3
2012-02-09 00:00:00 | 2060 | 14:37:00 | 14:38:00 | 14:43:00 | 00:06:00 | O | 3
2012-02-09 00:00:00 | 2069 | 15:27:00 | 15:27:00 | 15:34:00 | 00:07:00 | C | 3
2012-02-09 00:00:00 | 2075 | 17:01:00 | 17:01:00 | 17:09:00 | 00:08:00 | B | 3
2012-02-09 00:00:00 | 2074 | 16:54:00 | 16:54:00 | 17:01:00 | 00:07:00 | A | 4
2012-02-09 00:00:00 | 2078 | 18:16:00 | 18:16:00 | 18:20:00 | 00:04:00 | C | 4
2012-02-09 00:00:00 | 2087 | 21:24:00 | 21:24:00 | 21:29:00 | 00:05:00 | B | 4
2012-02-09 00:00:00 | 2056 | 12:13:00 | 12:14:00 | 12:18:00 | 00:05:00 | A | 5
2012-02-09 00:00:00 | 2064 | 14:25:00 | 14:26:00 | 14:28:00 | 00:03:00 | D | 5
2012-02-09 00:00:00 | 2070 | 15:29:00 | 15:29:00 | 15:33:00 | 00:04:00 | C | 5
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
Spreadsheet: 39804d1238079973-vlookup-match-concatenate-example
Sheet: Sheet1

QA515Q
AH047009YUKU
AH0470V52UKU
AH047060HUKU
AH023050H01
AH023050HUKU
AH023082XUKU
AH023038WKU
AH023038W01
AH020625X01
AH020682X01
AH020638W01
AH020582X01
AF720038WUKU
AF720082XUKU
QA0830B02
QA263Y01
QA515C
QA515D
QA515E
QA515F
QA103L
QA208C
QA249D
QA310D01
QA310D
QA312F01
QA312F
QA313P
QA317Q
QA421P
QA427H
QA509L
QA509W
QA509X
QA510E
QA510EB01
[NAME]
QA513A
QA513B
QA513C
QA513D
QA513E
QA513F
QA513G
QA513H
QA513J
QA513K
QA514W
QA514X
QA514Y
QA514Z
QA515B
QA514K
QA514C
QA514D
QA514E
QA514F
[NAME]
QA514H
QA514J
QA514K
QA514L
QA514M
QA514N
QA514P
QA514U
QA514V
QA514A
QA514B
QA513Z
QA316D
QA515A
QA311R
QI0261
QI0208
QA376P
AF130067XUKU
AF130067XSP
AF130067XIT
AF130067XPG
AF130067XFN
Spreadsheet: 702699d1604489161-returning-the-latest-status-example
Sheet: Sheet1

Service ID | DTL-Invoice line item | [NAME] service start date | [NAME] service end date | dtl - service status |  |  |  | Service ID | Status | [NAME] service start date | [NAME] service end date
Broadband |  | 2018-03-23 00:00:00 |  | #MULTIVALUE |  |  |  | Broadband | Active | 2017-12-27 00:00:00
T.V |  | 2018-03-23 00:00:00 |  | #MULTIVALUE |  |  |  | Broadband | Ceased | 2018-03-23 00:00:00 | 2018-03-23 00:00:00
Landline |  | 2020-07-10 00:00:00 |  | #MULTIVALUE |  |  |  | T.V | Active | 2017-04-18 00:00:00
Mobile |  | 2020-07-09 00:00:00 |  | #MULTIVALUE |  |  |  | T.V | Ceased | 2018-03-23 00:00:00 | 2018-03-23 00:00:00
Alarm |  | 2020-07-10 00:00:00 |  | #MULTIVALUE |  |  |  | Landline | Active | 2020-07-10 00:00:00
 |  |  |  |  |  |  |  | Landline | Ceased | 2017-07-02 00:00:00 | 2017-07-02 00:00:00
 |  |  |  |  |  |  |  | Mobile | Active | 2020-07-09 00:00:00
 |  |  |  |  |  |  |  | Mobile | Ceased | 2018-05-01 00:00:00 | 2018-05-01 00:00:00
 |  |  |  |  |  |  |  | Alarm | Active | 2020-07-10 00:00:00
 |  |  |  |  |  |  |  | Alarm | Ceased | 2018-05-01 00:00:00 | 2018-05-01 00:00:00
Spreadsheet: 879109d1726567404-time-intelligence-calculation-formula-for-prepaid-and-income3
Sheet: Workings

 | FY Period | 2024-2025
Item amount | From Date | To Date | No.of Days | Reporting Date |  |  |  |  |  |  |  |  |  |  |  |  | Total | Pre (or) Post FY | Matching
12000 | 2024-04-10 00:00:00 | 2024-10-20 00:00:00 |  | 2024-05-01 00:00:00
24000 | 2024-08-31 00:00:00 | 2025-03-31 00:00:00 |  | 2024-06-01 00:00:00
36000 | 2024-02-15 00:00:00 | 2026-03-31 00:00:00 |  | 2024-10-01 00:00:00
48000 | 2024-08-11 00:00:00 | 2025-03-31 00:00:00 |  | 2024-04-01 00:00:00
60000 | 2024-07-15 00:00:00 | 2025-04-29 00:00:00 |  | 2024-05-01 00:00:00
185000 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 2024-05-01 00:00:00
191590 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 2024-05-01 00:00:00
33425 | 2021-11-01 00:00:00 | 2021-12-31 00:00:00 |  | 2024-05-01 00:00:00
200000 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  | 2024-05-01 00:00:00
200000 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 2024-05-01 00:00:00
60890 | 2022-08-27 00:00:00 | 2022-12-31 00:00:00 |  | 2024-06-01 00:00:00
175000 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 2024-06-01 00:00:00
60890 | 2022-08-27 00:00:00 | 2022-12-31 00:00:00 |  | 2024-06-01 00:00:00
175000 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 2024-06-01 00:00:00
150000 | 2021-11-01 00:00:00 | 2021-12-31 00:00:00 |  | 2024-06-01 00:00:00
150000 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  | 2024-06-01 00:00:00
150000 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 2024-06-01 00:00:00
1734885 | 2024-03-01 00:00:00 | 2024-05-31 00:00:00 |  | 2024-07-01 00:00:00
Spreadsheet: 660516d1580482925-multiple-match-with-counta-index-match-match-191011-cars-roster
Sheet: Sheet1

 | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday
Driver 1 |  |  | hk |  |  |  |  |  |  | hk | hk
Driver 2 | hk |  |  |  |  | hk |  |  |  | hk
Driver 3 |  | hk |  |  |  |  |  |  |  | hk |  |  |  |  |  |  |  |  |  | hk
Driver 4 |  |  |  |  |  |  | hk |  |  |  |  |  |  |  |  |  | hk
Driver 5 |  |  |  |  |  |  |  | hk |  |  |  |  |  |  |  |  | hk
Driver 6 |  | hk |  |  |  |  |  |  |  |  |  | hk
Driver 7 |  |  | hk |  |  |  |  |  |  | hk |  |  |  |  |  |  |  |  |  | b
Driver 8 |  | hk |  |  |  |  |  |  |  | hk |  |  |  |  |  |  |  |  | hk
Driver 9 |  | hk |  |  |  |  |  | hk |  |  |  |  |  |  |  |  | hk
Driver 10
Driver 11 |  |  | hk |  |  |  |  |  |  | hk |  |  |  |  |  |  |  |  |  | b
Driver 12 |  |  |  | hk |  |  | hk |  |  |  |  |  |  |  |  |  | hk
Driver 13 |  |  |  |  |  |  |  |  | hk |  |  |  |  |  |  |  | hk
Driver 14
Driver 15
Driver 16
Driver 17
Driver 18
Driver 19 |  |  | hk | hk | hk | hk | hk |  |  | hk | hk | hk | hk | hk |  |  | hk | hk | hk | hk
Synthese
 | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday
Driver 1
Driver 2
Driver 3
Driver 4
Driver 5
Driver 6
Driver 7
Driver 8
Driver 9
Driver 10
Driver 11
Driver 12
Driver 13
Driver 14
Driver 15
Driver 16
Driver 17
Driver 18
Driver 19
Spreadsheet: 745790d1630212583-function-to-find-given-set-of-numbers-set-numbers
Sheet: Sheet1

DATA | set1 | set2 | set3 |  | set1 | 129 |  | Given values are in Set1,Set2,Set3
12579 | 129 |  |  |  | set2 | 56 |  | Column has 3 to 7 digits numbers
123789 | 129 |  |  |  | set3 | 48
134589 |  |  | 48 |  |  |  |  | Find if Column A has numbers shown in Set 1, Set2 and Set3 , if found populate in column B, C or D
1237
45678 |  | 56 | 48 |  |  |  |  | current method used: data filter and manually written
12467
23578 |  |  |  |  |  |  |  | all numbers are descending orders
156789 |  | 56
124789 | 129 |  | 48
13468 |  |  | 48
123478 |  |  | 48
245678 |  | 56 | 48
12358
123567 |  | 56
25789
123578
1357
13568 |  | 56
1348 |  |  | 48
Spreadsheet: 3f53ca0f-7855-4e9d-8510-294afa702858
Sheet: Sheet1

Instructions: | Unnamed: 1
1 | Save a copy of Earnings Release into Current quarter folder
2 | Fill in the variables in the light blue cells below.
3 | Refresh the smartview.
4 | Fill in prior quarter YTD information for rounding purposes into the green cells.
5 | Update the missing variables in the yellow cells.
6 | Round YTD information as needed.
7 | Copy and paste the "values only" of the smartview pages and hide these pages.
8 | Remove the coloring of the cells
To copy and paste the values and format into a new spreadsheet
1 | Highlight the entire sheet
2 | Ctr C
3 | Open a blank workbook
4 | Edit, paste special
5 | Click "Values only" target
6 | Edit, paste special
7 | Click "Formats" target
8 | Reset the print areas
Variables:
Quarter Number.  Example "Q1", "Q2", "Q3"
Q3
Current Year. Example "2008" or "2009"
2008
Sep
September 30,
NINE MONTHS ENDED
9