tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 76684d1277210166-find-top-15-zip-codes-in-column-zip-sheet
Sheet: Sheet4

Count of Zip Code
Zip Code | Total
98122 | 21
98102 | 20
98103 | 15
98105 | 15
97405 | 10
98908 | 10
97401 | 9
98006 | 9
98502 | 9
97201 | 8
97217 | 8
97330 | 8
98034 | 8
98109 | 8
98801 | 8
99004 | 8
Grand Total | 174
Spreadsheet: 79750d1279926974-returning-items-variable-months-book1
Sheet: New Patients 1

 | Returning every (in months) |  | 3 | Need
 | Times Returning |  | 10
 | % Returning |  | 1
 | Total Items |  | 21 | 28 | 30 | 26 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21
 | 2009-01-31 00:00:00
 | 2009-02-28 00:00:00
 | 2009-03-31 00:00:00
 | 2009-04-30 00:00:00
 | 2009-05-31 00:00:00
 | 2009-06-30 00:00:00
 | 2009-07-31 00:00:00
 | 2009-08-31 00:00:00
 | 2009-09-30 00:00:00
 | 2009-10-31 00:00:00
 | 2009-11-30 00:00:00
 | 2009-12-31 00:00:00
Spreadsheet: 1a6dcb05-665d-450e-96e9-1f4b1ce6e1d1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 45. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413770V | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413771W | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413772X | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413773A | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413774C | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413775F | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413776J | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413778L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413779R | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413780X | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 89785d1289512251-today-line-on-a-graph-seankosmann-data-point-flag-in-chart-not-working
Sheet: Monthly Graph

Month | Materials Required | Scheduled Install | Actual Install | Scheduled Commission | Actual Commission | Scheduled Verification | Actual Verification | Opportunities | Today
2010-09-01 00:00:00
Month | [NAME] | Opportunity
September 2010
October 2010
November 2010
December 2010
January 2011
February 2011
March 2011
April 2011
May 2011
June 2011
July 2011
August 2011
September 2011
October 2011
November 2011
December 2011
Spreadsheet: 746665d1630941495-calculate-number-of-nights-excel-forum-number-of-nights
Sheet: Number of Nights

Calculate the number of nights correctly while identifying different nights on previous dates
 |  | Raw Data |  |  |  |  |  |  |  | [NAME]
 |  | Date |  | Name | Location | Type | House or Hotel | # of Rooms | Rooms | HelpNewAcc |  | Gapfree Cities | Gapfree Acoomodatons | Type | Gapfree Rooms | HelpNights | Help Nights | HelpNights2 | Nights | CountHouse | CountHotel |  |  |  | I want the formula to calculate the correct number of nights per destination and House (the concatenate could look for something else). The [NAME] should recognize that each visit is unique (even if the person goes to the same location twice during the whole trip)
 | 1 | 2022-08-20 00:00:00 | 2022-08-22 00:00:00 | House | New York | NewHome | House | 1 | Roomcategory: 2x [NAME] with Breakfast | 1
 | 2 | 2022-08-21 00:00:00 |  | House | New York | NewHome | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 3 | 2022-08-22 00:00:00 |  | House | New York | NewHome | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 4 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00 | House | Philadephia | PhiliHouse | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 5 | 2022-08-24 00:00:00 | 2022-08-25 00:00:00 | House | Washington | DCPlaza | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 6 | 2022-08-25 00:00:00 | 2022-08-26 00:00:00 | Hotel Awesomesauce | Baltimore | Hotel Awesomesauce | Hotel | 1 | Zimmerkategorie: 2x Classic Doppelzimmer Breakfast
 | 7 | 2022-08-26 00:00:00 | 2022-08-27 00:00:00 | House | Baltimore | [NAME] | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 8 | 2022-08-27 00:00:00 |  | House | Baltimore | [NAME] | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 9 | 2022-08-28 00:00:00 | 2022-08-29 00:00:00 | House | Washington | DCPlaza | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 10 | 2022-08-29 00:00:00 |  | House | Washington | DCPlaza | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 11 | 2022-08-30 00:00:00 | 2022-08-31 00:00:00 | House | Baltimore | Baltimouse | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 12 | 2022-08-31 00:00:00 | 2022-09-01 00:00:00 | House | Baltimore | [NAME] | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 13 | 2022-09-01 00:00:00 |  | House | Baltimore | [NAME] | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 14 | 2022-09-02 00:00:00 | 2022-09-03 00:00:00 | House | Washington | DCPlaza | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 15 | 2022-09-03 00:00:00 | 2022-09-04 00:00:00 | House | Philadephia | HeatHouse | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 16 | 2022-09-04 00:00:00 |  |  | New York
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
Spreadsheet: 734812d1622515344-formula-finds-the-max-number-of-consecutive-times-and-the-total-of-consecutive-values-forum-ask-0601-1-
Sheet: Sheet1

department | KPI | Amount |  |  | department | KPI | Amount
Marketing Department | 0 | 32091 | 0 | 0 | Marketing Department | 3 | 38974
Marketing Department | 0 | 28259 | 0 | 0 | Sales Department | 6 | 193058
Marketing Department | 0 | 7343 | 0 | 0
Marketing Department | 0 | 48809 | 0 | 0
Marketing Department | 0 | 19240 | 0 | 0
Marketing Department | 1 | 15749 | 1 | 15749
Marketing Department | 0 | 18879 | 0 | 0 | The maximum number of consecutive times in the marketing department is 3, and Total amount 38974
Marketing Department | 1 | 7854 | 1 | 7854 | The sales department's maximum consecutive times of 6, and Total amount 193058
Marketing Department | 0 | 47999 | 0 | 0
Marketing Department | 1 | 5182 | 1 | 5182
Marketing Department | 1 | 6315 | 2 | 11497
Marketing Department | 1 | 27477 | 3 | 38974
Marketing Department | 0 | 19365 | 0 | 0
Marketing Department | 0 | 31293 | 0 | 0
Marketing Department | 1 | 4497 | 1 | 4497
Marketing Department | 1 | 7762 | 2 | 12259
Sales Department | 0 | 22528 | 0 | 0
Sales Department | 0 | 32876 | 0 | 0
Sales Department | 1 | 34223 | 1 | 34223
Sales Department | 0 | 45126 | 0 | 0
Sales Department | 1 | 9950 | 1 | 9950
Sales Department | 1 | 9625 | 2 | 19575
Sales Department | 1 | 47277 | 3 | 66852
Sales Department | 1 | 32016 | 4 | 98868
Sales Department | 1 | 49575 | 5 | 148443
Sales Department | 1 | 44615 | 6 | 193058
Sales Department | 0 | 6158 | 0 | 0
Sales Department | 0 | 37453 | 0 | 0
Sales Department | 1 | 31615 | 1 | 31615
Sales Department | 1 | 39354 | 2 | 70969
Sales Department | 1 | 43922 | 3 | 114891
Sales Department | 1 | 19675 | 4 | 134566
Sales Department | 0 | 24900 | 0 | 0
Sales Department | 0 | 10318 | 0 | 0
Spreadsheet: 94e40048-92c2-4f70-a591-1e73be2d4ddc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Bežné výdavky - Osobné
 |  | [NAME] projektu
 |  | Registračné číslo projektu
 |  | Zodpovedný riešiteľ / žiadateľ
 | Č. prac. balíka | [NAME], priezvisko, tituly | Počet osôb (1) | Pozícia v projekte | Popis činnosti (2) | Počet osobodní celkom za projekt / [NAME] | [NAME] sadzba        (v eur) / sadzba za výkon  (v eur) | Celková suma  (v eur) (3) |  | Celková suma spolu (v eur)
 |  |  |  |  |  |  |  | Štátny rozpočet | Vlastné [NAME]
 | Spolu (v eur)
 | (1) | V prípade ak odmeny dostanú viacerí ľudia, v rovnakej pozícii a vykonávajúci rovnakú činnosť a nie je možné ich dopredu identifikovať
 | (2) | [NAME] popis činnosti, za ktorú bude osoba honorovaná v rámci projektu
 | (3) | Vrátane odvodov
Spreadsheet: 356457d1415116585-excel-sorting-excel-help-ndm-v2
Sheet: Sheet1

This is what I copy from my online banking
Date | Ref/ Check | Description/ Memo (Category) | Debit/ Withdrawal
2014-10-17 00:00:00 |  | 071729 INTERNET TRANSFER TO STATEMENT SAVING 1557981 ON 10/17/14 AT 0:16 | 100
2014-10-20 00:00:00 |  | 080522 INTERNET TRANSFER TO STATEMENT SAVING 1557981 ON 10/17/14 AT 19:33 | 2100
2014-10-31 00:00:00 |  | 177867 INTERNET TRANSFER TO STATEMENT SAVING 1557981 ON 10/31/14 AT 0:43 | 100
2014-10-21 00:00:00 |  | [PHONE] Nissan Auto Loan | 350
2014-10-06 00:00:00 |  | 57020 PURCHASE MCDONALD'S F6693 PORT ALLEN LA 548141 427900077 | 12.59
2014-10-06 00:00:00 |  | 668414 PURCHASE REDBOX *DVDRESERVATION [PHONE] IL [PHONE] | 2.62
2014-10-24 00:00:00 |  | 52173 PURCHASE USA*SNACK SODA VENDING BREAUX BRIDGE LA 548081 429 | 1.1
2014-10-24 00:00:00 |  | 52172 PURCHASE USA*SNACK SODA VENDING BREAUX BRIDGE LA 548141 429 | 1.5
2014-10-28 00:00:00 |  | 63912 PURCHASE WALGREENS #15366 PORT ALLEN LA 548131 430100028 | 3.49
2014-10-22 00:00:00 |  | 367287 PURCHASE WALGREENS PORT ALLEN LA 480355 00064877 | 10.47
2014-10-20 00:00:00 |  | 199469 PURCHASE WAL-MART #0402 BREAUX BRIDGE LA 720943 00354078 | 32.43
2014-10-28 00:00:00 |  | 653874 PURCHASE WAL-MART SUPER CENTER PORT ALLEN LA [PHONE] | 23.93
2014-10-01 00:00:00 |  | [PHONE] WF HOME MTG AUTO PAY | 1300
2014-10-27 00:00:00 |  | 111337 WITHDRAWAL 123 LOBDELL HWY. PORT ALLEN LA 054699 00020117 | 61.75
2014-10-27 00:00:00 |  | 293459 WITHDRAWAL 222 HWY 415 PORT ALLEN LA 053186 00014330 | 42.5
This is how I'd like to sort it……..
2014-10-06 00:00:00 |  | 57020 PURCHASE MCDONALD'S F6693 PORT ALLEN LA 548141 427900077 | 12.59
2014-10-06 00:00:00 |  | 668414 PURCHASE REDBOX *DVDRESERVATION [PHONE] IL [PHONE] | 2.62
2014-10-24 00:00:00 |  | 52173 PURCHASE USA*SNACK SODA VENDING BREAUX BRIDGE LA 548081 429 | 1.1
2014-10-24 00:00:00 |  | 52172 PURCHASE USA*SNACK SODA VENDING BREAUX BRIDGE LA 548141 429 | 1.5
2014-10-28 00:00:00 |  | 653874 PURCHASE WAL-MART SUPER CENTER PORT ALLEN LA [PHONE] | 23.93
2014-10-20 00:00:00 |  | 199469 PURCHASE WAL-MART #0402 BREAUX BRIDGE LA 720943 00354078 | 32.43
2014-10-22 00:00:00 |  | 367287 PURCHASE WALGREENS PORT ALLEN LA 480355 00064877 | 10.47
2014-10-28 00:00:00 |  | 63912 PURCHASE WALGREENS #15366 PORT ALLEN LA 548131 430100028 | 3.49
Spreadsheet: 04424cc0-e15e-41e7-aa0f-559b44776de2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 77. Value of Building Approved, Chain Volume Measures, Original - Queensland
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total houses ;  New ; |  |  | Original | A590497K | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total other residential building ;  New ; |  |  | Original | A590498L | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  New ; |  |  | Original | A590499R | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590500L | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590501R | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590502T | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590503V | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2009
Spreadsheet: 683389d1592687108-transpose-from-columns-to-rows-with-power-query-pq-transform-rows-to-columns-aligw
Sheet: from

DATE | B00 000 01 01 | B00 000 01 02 | B00 000 01 03 | B00 000 01 04 | B00 000 01 05 | B00 000 01 06 | B00 000 01 07 | B00 000 01 08 | B00 000 01 09 | B00 000 01 10 | B00 000 01 11 | B00 000 01 12 | B00 000 01 13 | B00 000 01 14
2020-01-01 00:00:00 | 1 | 23 | 34 | 45 | 47 | 49 | 51 | 53 | 55 | 57 | 59 | 61 | 63 | 65
2020-01-02 00:00:00 | 2 | 23 | 34 | 89 | 91 | 93 | 95 | 97 | 99 | 101 | 103 | 105 | 107 | 109
2020-01-03 00:00:00 | 3 | 23 | 34 | 133 | 135 | 137 | 139 | 141 | 143 | 145 | 147 | 149 | 151 | 153
2020-01-04 00:00:00 | 4 | 23 | 34 | 177 | 179 | 181 | 183 | 185 | 187 | 189 | 191 | 193 | 195 | 197
2020-01-05 00:00:00 | 5 | 23 | 34 | 221 | 223 | 225 | 227 | 229 | 231 | 233 | 235 | 237 | 239 | 241
2020-01-06 00:00:00 | 6 | 23 | 34 | 265 | 267 | 269 | 271 | 273 | 275 | 277 | 279 | 281 | 283 | 285
2020-01-07 00:00:00 | 7 | 23 | 34 | 309 | 311 | 313 | 315 | 317 | 319 | 321 | 323 | 325 | 327 | 329
2020-01-08 00:00:00 | 8 | 23 | 34 | 353 | 355 | 357 | 359 | 361 | 363 | 365 | 367 | 369 | 371 | 373
2020-01-09 00:00:00 | 9 | 23 | 34 | 397 | 399 | 401 | 403 | 405 | 407 | 409 | 411 | 413 | 415 | 417
2020-01-10 00:00:00 | 10 | 23 | 34 | 441 | 443 | 445 | 447 | 449 | 451 | 453 | 455 | 457 | 459 | 461
2020-01-11 00:00:00 | 11 | 23 | 34 | 485 | 487 | 489 | 491 | 493 | 495 | 497 | 499 | 501 | 503 | 505
2020-01-12 00:00:00 | 12 | 23 | 34 | 529 | 531 | 533 | 535 | 537 | 539 | 541 | 543 | 545 | 547 | 549
2020-01-13 00:00:00 | 13 | 23 | 34 | 573 | 575 | 577 | 579 | 581 | 583 | 585 | 587 | 589 | 591 | 593
2020-01-14 00:00:00 | 14 | 23 | 34 | 617 | 619 | 621 | 623 | 625 | 627 | 629 | 631 | 633 | 635 | 637
2020-01-15 00:00:00 | 15 | 23 | 34 | 661 | 663 | 665 | 667 | 669 | 671 | 673 | 675 | 677 | 679 | 681
2020-01-16 00:00:00 | 16 | 23 | 34 | 705 | 707 | 709 | 711 | 713 | 715 | 717 | 719 | 721 | 723 | 725
2020-01-17 00:00:00 | 17 | 23 | 34 | 749 | 751 | 753 | 755 | 757 | 759 | 761 | 763 | 765 | 767 | 769
2020-01-18 00:00:00 | 18 | 23 | 34 | 793 | 795 | 797 | 799 | 801 | 803 | 805 | 807 | 809 | 811 | 813
2020-01-19 00:00:00 | 19 | 23 | 34 | 837 | 839 | 841 | 843 | 845 | 847 | 849 | 851 | 853 | 855 | 857
2020-01-20 00:00:00 | 20 | 23 | 34 | 881 | 883 | 885 | 887 | 889 | 891 | 893 | 895 | 897 | 899 | 901
2020-01-21 00:00:00 | 21 | 23 | 34 | 925 | 927 | 929 | 931 | 933 | 935 | 937 | 939 | 941 | 943 | 945
2020-01-22 00:00:00 | 22 | 23 | 34 | 969 | 971 | 973 | 975 | 977 | 979 | 981 | 983 | 985 | 987 | 989
2020-01-23 00:00:00 | 23 | 23 | 34 | 1013 | 1015 | 1017 | 1019 | 1021 | 1023 | 1025 | 1027 | 1029 | 1031 | 1033
2020-01-24 00:00:00 | 24 | 23 | 34 | 1057 | 1059 | 1061 | 1063 | 1065 | 1067 | 1069 | 1071 | 1073 | 1075 | 1077
2020-01-25 00:00:00 | 25 | 23 | 34 | 1101 | 1103 | 1105 | 1107 | 1109 | 1111 | 1113 | 1115 | 1117 | 1119 | 1121
Spreadsheet: 297870d1392636631-conditional-formatting-help-sales-comparison-new-outlets-2012
Sheet: Main Sheet

 |  |  |  |  |  |  |  |  |  |  | HIDDEN
Region | Sl. No. | Outlet /  Branch | Outlet Opening Date | Sale YTD 31st Dec, 2012 (AED) | 2012 Estimated Sale (AED) | Area Manager [NAME] (Month) (AED) | Area Manager [NAME] (Yearly) (AED) | Area Manager [NAME] (Date of opening to 31st Dec, 2012) | Variance (Value) [Actual Sale Less Est. Ams TGT] | Variance (Perc.%) | [NAME]. Tgt. Month Onwards | Sales Target (2012) Total | Sales Targets Starting Month | [NAME]. Perc. (%)
Bahrain | 1 | [NAME] | 2012-01-05 00:00:00 | 961025.53 |  |  | 708000 |  |  |  | 961026 | 966485.93 | 2012-01-01 00:00:00
 | 2 | [NAME] | 2012-04-24 00:00:00 | 910340.79 |  |  | 532356 |  |  |  | 773049.09 | 921375 | 2012-06-01 00:00:00
 | 3 | [NAME] | 2012-09-03 00:00:00 | 233239.99 |  |  | 2340000 |  |  |  | 186257.66 | 448500 | 2012-10-01 00:00:00
Oman | 4 | Lulu Hypermarket - Darsait (Oman) | 2012-03-02 00:00:00 | 476952.13 |  |  | 514080 |  |  |  | 418354.68 | 769500 | 2012-04-01 00:00:00
 | 5 | Lulu Hypermarket-Buraimi | 2012-06-27 00:00:00 | 424373.25 |  |  | NA |  |  |  | 262753.71 | 533900 | 2012-09-01 00:00:00
 | 6 | Sur-2 | 2012-07-09 00:00:00 | 431676.13 |  |  | 1596000 |  |  |  | 259264.92 | 642200 | 2012-09-01 00:00:00
 | 7 | [NAME] | 2012-11-03 00:00:00 | 84262.58 |  |  | 513000 |  |  |  | 0 | 0 | NA
Qatar | 8 | [NAME] | 2012-08-12 00:00:00 | 216935.35 |  |  | 996000 |  |  |  | 150931.69 | 260000 | 2012-10-01 00:00:00
Abu Dhabi | 9 | Bain Al Jasrain Co-operative Society | 2012-12-02 00:00:00 | 60312 |  |  | 1800000 |  |  |  | 0 | 0 | NA
RAK-FUJERAH | 10 | Fujairah City Centre | 2012-04-04 00:00:00 | 991726 |  |  | 1500000 |  |  |  | 991726 | 1165000 | 2012-04-01 00:00:00
 | 11 | [NAME] | 2012-04-26 00:00:00 | 252444.25 |  |  | 1170000 |  |  |  | 168994.75 | 550000 | 2012-07-01 00:00:00
 | 12 | Mannar Mall 2 | 2012-03-23 00:00:00 | 823344.48 |  |  | Re-location |  |  |  | 798521.73 | 1231760 | 2012-04-01 00:00:00
 | 13 | [NAME] (Kiosk) | 2012-08-01 00:00:00 | 176557.75 |  |  | Closed Now |  |  |  | 176557.75 | 840000 | 2012-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | * Figures / values in AED
Spreadsheet: 756792d1637779419-replace-sumproduct-with-sumifs-replace-sumproduct-with-sumifs
Sheet: Report

 | Report | 2017 |  |  |  |  |  |  |  |  |  |  |  | 2018 |  |  |  |  |  |  |  |  |  |  |  | 2019 |  |  |  |  |  |  |  |  |  |  |  | 2020 |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 | Material 1
 | Material 2
 | Material 3
 | Material 4
 | Material 5
 | Material 6
 | Material 7
 | Material 8
 | Material 9
 | Material 10
 | Material 11
 | Material 12
 | Material 13
Spreadsheet: 120899d1315611142-cell-reads-other-cells-from-another-sheet-nfl-football-schedule-2011-2012
Sheet: Week 17

Sunday, January 1, 2011
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Carolina Panthers
New Orleans Saints
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Buffalo Bills
New England Patriots
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Chicago Bears
Minnesota Vikings
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New York Jets
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
San Francisco 49ers
St. Louis Rams
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Detroit Lions
Green Bay Packers
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Tampa Bay Buccaneers
Atlanta Falcons
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Baltimore Ravens
Cincinnati Bengals
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Pittsburgh Steelers
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Dallas Cowboys
New York Giants
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Washington Redskins
Philadelphia Eagles
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Indianapolis Colts
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Tennessee Titans
Houston Texans
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
[NAME]
Arizona Cardinals
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Kansas City Chiefs
Denver Broncos
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
San Diego Chargers
Oakland Raiders
Teams on Bye
Spreadsheet: 692759d1598541599-assigning-the-same-occurrence-count-to-listed-items-that-have-been-multiplied-assigning-the-same-occurrence-count-to-listed-items-that-have-been-multiplied
Sheet: Sheet1

Original list | Original count |  | Items from original list multiplied with multiplier given in cell H1 | Adjusted count |  | Multiplier: | 3
Apples |  |  |  | 1
Oranges | 1 |  | Apples | 1
Oranges | 2 |  | Apples | 1
Pears | 1 |  | Oranges | 1
Grapes | 1 |  | Oranges | 1
Grapes | 2 |  | Oranges | 1
Grapes | 3 |  | Oranges | 2
 |  |  | Oranges | 2
 |  |  | Oranges | 2
 |  |  | Pears | 1
 |  |  | Pears | 1
 |  |  | Pears | 1
 |  |  | Grapes | 1
 |  |  | Grapes | 1
 |  |  | Grapes | 1
 |  |  | Grapes | 2
 |  |  | Grapes | 2
 |  |  | Grapes | 2
 |  |  | Grapes | 3
 |  |  | Grapes | 3
 |  |  | Grapes | 3
Spreadsheet: 724594d1616251879-identify-the-missing-sequence-missing-numbers-ans
Sheet: Sheet1

1000
1007
1010
10101
10102
10103
10104
10105
10106
1011
1012
1013
1014
1015
1016
1017
1022
1023
1027
1029
1031
1033
1034
1038
1041
1044
1045
1046
1050
Spreadsheet: 158446d1338246708-is-this-possible-reading-data-exception-tracking-2012
Sheet: Aug by Shift

AUDIT DESCREPANCIES BY SHIFT AUGUST
 | AUGUST
AUDIT DESCREPANCIES / EXCEPTIONS | DAY | SWING | GRAVE
Illegible or missing signature/ badge number
Any void not completed properly
Improper Error Corrections
Inconsistent Key Return
Incorrect/ Missing Information/ Totals
Missing Time Stamp/ Manual Date
Paperwork not received in Audit
Compliance Exceptions
Totals
Total Audit Exceptions
Total Compliance Exceptions
THESE ARE THE AUDIT DISCREPANCIES RECEIVED IN AUGUST!
THE GOAL FOR SEPTEMBER IS A 10% REDUCTION. |  |  |  | SEPTEMBER GOAL
Spreadsheet: 886459d1736481870-process-time-in-minutes-and-hour-sampe-case-time
Sheet: Sheet1

 |  |  |  |  |  |  | Unload Finish |  | Posted
 |  |  |  |  |  |  | Date | Time | Date | Time | Total Process Time  (Hr Minutes)
 |  |  |  |  |  |  | 2025-01-03 00:00:00 | 13:38:00 | 2025-01-04 00:00:00 | 02:30:00
 |  |  |  |  |  |  | 2025-01-03 00:00:00 | 13:38:00 | 2025-01-04 00:00:00 | 21:30:00 |  | correct
 |  |  |  |  |  |  | 2025-01-05 00:00:00 | 22:30:00 | 2025-01-07 00:00:00 | 20:00:00