tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 823617d1680038405-if-statements-multiple-parameters-tipsheet-wip
Sheet: Master

 | HT Totals | HT am | HT pm
Total Sales:
Total CC Tips |  |  |  |  | Pool $$ | Bartender | Backserver |  |  |  |  | Kickfin Count | Servers | Bartenders | Barbacks | Backservers | Full | Mid | FR
Total Cash Tips |  |  |  |  | HT am |  |  |  |  |  |  | HT am
Gross Total Tips: |  |  |  |  | HT pm |  |  |  |  |  |  | HT pm
Server Net
Bartender Net
Support Net
TOTAL STAFF TIPS:
SERVERS | Alcohol Sales | Total Sales | Shift | Credit Tips | Cash Sales | Total Cash Collected | Cash Tips | Gross Total Tips | Tip-out to Bartenders | Tip-out to Backservers | Net Total Tips | Kickfin
 | 0 | 0 |  | 0 | 0 | 0
SERVER 1 | 400 | 500 | HT pm | 500 | 1000 | 2000
SERVER 2 | 900 | 1000 | HT am | 1000 | 1000 | 999
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
BARTENDERS | Food Sales | Total Sales | Shift | Credit Tips | Cash Sales | Total Cash Collected | Cash Tips | Gross Total Tips | Tip-out to Backservers | Pool Share | Net Total Tips | Kickfin | Hours Worked
 | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
BARTENDER 1 | 500 | 500 | HT am | 500 | 500 | 550 |  |  |  |  |  |  | 1
BARTENDER 2 | 500 | 500 | HT pm | 500 | 400 | 500 |  |  |  |  |  |  | 1
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
BACKSERVERS | Shift | Hours Worked | Kickfin
BCKSVR 1 | HT am | 1
BCKSVR 2 | HT am | 0.5
BCKSVR 3 | HT am | 0.25
BCKSVR 4 | HT pm | 1
BCKSVR 5 | HT pm | 0.5
BCKSVR 6 | HT pm | 0.25
BARBACKS | Shift | Hours Worked | Kickfin
BARBACK 1 | HT am | 1
BARBACK 2 | HT pm | 1
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 97454d1296628888-excel-2007-cannot-open-xslx-file-new-item-list-2011
Sheet: Others

REQUEST ITEM 2011
Column1 | Column2 | Column3 | Column4 | Column5 | Column6
STATIONERY MISC 2011
NO. | [NAME] | RE-ORDER | SECTION | SUPPLIER | UNIT PRICE (RM)
1 | Book Trolleys | 10 units | IHSIS
2 | Promotional Stands (latest) | 2 units
3 | Paper Cutter (Biggest) | 1 unit | LIS
4 | Flat Trolleys | 1 unit
5 | Information Board | 1 unit | DLS
6 | Others (As attached)
7 | [NAME] (A4 size) | 20 units
8 | [NAME] | 3 rolls
9 | Key Chain | 2 boxes | CFS NILAI
10 | Hot-wire polystrene foam cutter | 1 unit
11 | Flat Trolleys | 3 units
12 | Step Ladder (5ft) | 1 unit
13 | [NAME] | 3 rolls
14 | Key Chain | 2 boxes
15 | Hot-wire polystrene foam cutter | 1 unit | CFS PJ
16 | Flat Trolleys | 3 units
17 | Laminate Machine | 1 unit
18 | Step Ladder (5ft) | 1 unit
19 | Book Trolleys | 5 units | AQS
20 | Cable Tight (White & Black Colour) | 100 pcs | TAS
21 | Others (As attached)
22 | White board for PG | 1 unit
23 | [NAME] | 1 unit | SSIS
24 | Book Trolleys | 10 units
25 | Carpet for fp room | 1 set
26 | Thinner | 1 bottle
27 | Book Trolleys | 5 units | STIS
28 | Promotional Stands (latest) | 2 units
29 | Book Trolleys | 4 units | CAT
30 | Scotch Tape Dispenser (large) | 3 units
31 | Steel rubbish [NAME] with cover | 4 units
32 | Wall clock | 8 units | ISTAC
33 | Horse Hair Brush (10"x4") | 6 units
34 | Hot Water pot (7 litres) | 1 unit
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 95354d1294946446-data-distribution-issue-random9by3draw
Sheet: Sheet1

Time | Court1 |  |  | Court2 |  |  | Court3 |  |  |  | Players | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00
09:00:00 | E | A | G | C | I | B | H | F | D |  | A | 0.7775865225420429 | 0.09658372257211334 | 0.7010264268622437 | 0.04699273593733766 | 0.5223096824933571
09:30:00 | C | H | B | F | D | E | G | I | A |  | B | 0.3791173867575716 | 0.7553197533486855 | 0.6324561694881092 | 0.4540811113267309 | 0.6552467588592509
10:00:00 | I | D | A | E | B | C | H | F | G |  | C | 0.5824360456864965 | 0.884611106471769 | 0.6065404117052032 | 0.0949175004297107 | 0.4211406503282722
10:30:00 | I | D | B | H | G | E | C | F | A |  | D | 0.03732416900808966 | 0.5609603742816636 | 0.8457718140832174 | 0.5931722258105975 | 0.1308932676735219
11:00:00 | I | G | E | F | H | B | A | C | D |  | E | 0.9386855104589196 | 0.1753211141502462 | 0.6960030267366941 | 0.2599570774259694 | 0.8876575507245145
 |  |  |  |  |  |  |  |  |  |  | F | 0.1074013282997063 | 0.6781191486822455 | 0.1428572348851984 | 0.06411936228019344 | 0.7100410953122233
 | 14027 |  | 1 |  |  |  |  |  |  |  | G | 0.5904078632856358 | 0.1471810586450052 | 0.1128789050714138 | 0.3062662020106688 | 0.9154152220975637
 | 14029 |  | 1 |  |  |  |  |  |  |  | H | 0.2682912728369644 | 0.8520854602261693 | 0.5600533445719463 | 0.3838031930440544 | 0.6876061237308856
 | 14178 |  | 1 |  |  |  |  |  |  |  | I | 0.4589487814843985 | 0.118475489934516 | 0.9670661484197723 | 0.686734165061089 | 0.9382041124402755
 | 14309 |  | 1 |  | Instructions
 | 15131 |  | 1 |  | Press F9 to recalculate the random draw
 | 14174 |  | 1 |  | Untl there are all 1's in the column
 | 14285 |  | 1 |  | to the left.  This insures no duplicate
 | 13606 |  | 1 |  | 3 person teams.
 | 14986 |  | 1 |  | Copy and Paste - Values Only to another
 | 14440 |  | 1 |  | place on the sheet to save draw results.
 | 14708 |  | 1
 | 14595 |  | 1
 | 15125 |  | 1
 | 13614 |  | 1
 | 13338 |  | 1
Spreadsheet: 728523d1618496147-minimum-array-if-2-conditions-min_distance_below
Sheet: Blad1

Paal | X | Y | s/Drechts
1 | 0 | 0
2 | 0 | 2
3 | 0 | 4
4 | 2 | 0
5 | 2 | 2
6 | 2 | 5
7 | 4 | 1
8 | 4 | 2
9 | 4 | 4
Spreadsheet: 0230e880-b1c7-4c47-bdb7-7dedefde3b33
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
2012-09-11 00:00:00 | State Senate Dist. 9 - Democratic
 | Nyquist, d | Hawkins, r | Kenney, r | Sanborn, r | [NAME]
Bedford | 934 | 1 |  | 1 | 6
Dublin | 179
[NAME] | 176
[NAME] | 124
Hancock | 293 |  |  |  | 1
[NAME] | 332 |  |  |  | 4
Lyndeborough | 97 |  |  |  | 1
[NAME] | 189 |  |  | 1 | 1
New Boston | 399 |  |  |  | 1
Peterborough | 724 |  |  |  | 1
Richmond | 101 |  |  |  | 2
[NAME] | 44
Temple | 128
Troy | 98 |  |  |  | 1
Totals | 3818 | 1 |  | 2 | 18
 | State Senate District 10 - Democratic
 | Kelly, d | Foote, r | [NAME]
Alstead | 178
Chesterfield | 258 | 1
Gilsum | 47
Harrisville | 223
Hinsdale | 172
[NAME] | 156 |  | 2
[NAME] | 413 | 4 | 1
[NAME] 3 | 359
[NAME] | 402 | 1 | 2
[NAME] | 444 | 8
Marlborough | 221 | 1 | 1
[NAME] | 105
Roxbury | 29
[NAME] | 62 | 1
[NAME] | 85 | 1
Swanzey | 394 | 7 | 3
Walpole | 344 | 1
Westmoreland | 190
Winchester | 224 | 1
Totals | 4306 | 26 | 9
 | State Senate District 11 - Democratic
 | Dyke (w-in) | Dokmo (w-in) | Bragdon, r | [NAME]
Amherst | 91 | 48 | 2 | 38
Merrimack | 52 |  | 9 | 23
Milford | 35 |  | 1 | 7
[NAME] | 28 |  |  | 18
Totals | 206 | 48 | 12 | 86
Spreadsheet: 31528bcf-fa06-48de-b1db-da4db31c9e7a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FHRIN | Test | FHRIN | Heroin Analysis, [NAME] | Heroin Analysis, Blood | Immunoassay (IA) Gas Chromatography-Mass Spectrometry (GC/MS) | Gray-Top Tube (Potassium Oxalate/Sodium Fluoride): GryPOSF |  |  | 10 | mL | Draw blood in a grey-top NaF/oxalate tube(s). Send 7 mL of NaF/oxalate whole blood refrigerated. | 2 mL | Specimens other than	Whole blood Anticoagulants other than	Sodium fluoride/potassium oxalate Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | This specimen was screened by Immunoassay. Any positive result is confirmed by Gas Chromatography with Mass Spectrometry (GC/MS). The following threshold concentrations are used for this analysis:   Drug                  Screening Threshold         Confirmation Threshold ---------------------------------------------------------------------------------------------- Heroin                                  10 ng/mL  Morphine                                                                       10 ng/mL 6-acetylmorphine                                                             6 ng/mL     Test Performed By:  Medtox Laboratories, Inc.                               402 W. County Road D                               St. Paul, MN  55112 | Varies | 10 days | 12-14 days | 1 | 80101 |  |  |  |  | Medtox Laboratories, Inc
FHRIN | [NAME] | WBNAFL | [NAME] NaFl-KOx |  |  |  | Refrigerated
FHRIN | Result | Z1208 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHRIN | Result | Z1066 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHRIN | Result | Z1067 | 6-Acetylmorphine, Confirmation | 6-Acetylmorphine, Confirmation | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FHRIN | Result | Z1068 | [NAME], unconjugated Confirm | [NAME], unconjugated Confirm | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 219187d1362679444-automatically-updating-multiple-sheets-to-a-master-sheet-master-test
Sheet: Summary

Test |  |  |  |  |  |  | Target |  | Actual |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014
Activity | Core | Stream | Task | Milestone | Accountable | External | Start | End | Actual | Actual End Date | Status | Funding | Notes/Location | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1 | Main Header 1.0
Spreadsheet: 477914d1472568688-tough-problem-how-can-i-average-different-columns-based-on-student-names-monthly-mastery-tracker_example
Sheet: Spelling Data

September |  |  |  | October |  |  |  | November |  |  |  | December |  |  |  | January |  |  |  | February |  |  |  | March |  |  |  | April |  |  |  | May |  |  |  | June
Name | OSIS # | Spelling |  | Name | OSIS # | Spelling |  | Name | OSIS # | Spelling |  | Name | OSIS # | Spelling |  | Name | OSIS # | Spelling |  | Name | OSIS # | Spelling |  | Name | OSIS # | Spelling |  | Name | OSIS # | Spelling |  | Name | OSIS # | Spelling |  | Name | OSIS # | Spelling
Student x | 1 | 7 |  | Student x | 1 | 1 |  | Student x | 1 | 2 |  | Student x | 1 | 3 |  | Student x | 1 | 4 |  | Student x | 1 | 5 |  | Student x | 1 | 6 |  | Student x | 1 | 7 |  | Student x | 1 | 8 |  | Student x | 1 | 9
Student y | 2 | 8 |  | Student y | 2 | 1 |  | Student y | 2 | 2 |  | Student y | 2 | 3 |  | Student y | 2 | 4 |  | Student y | 2 | 5 |  | Student y | 2 | 6 |  | Student y | 2 | 7 |  | Student y | 2 | 8 |  | Student y | 2 | 9
Student z | 3 | 9 |  | Student z | 3 | 1 |  | Student z | 3 | 2 |  | Student z | 3 | 3 |  | Student z | 3 | 4 |  | Student z | 3 | 5 |  | Student z | 3 | 6 |  | Student z | 3 | 7 |  | Student z | 3 | 8 |  | Student z | 3 | 9
Spreadsheet: 137759d1327346742-copy-paste-values-to-the-cell-next-to-a-matched-cell-inventory-sample
Sheet: 1.23.12

 |  |  |  | total
 | 0 | 0 | 0
#1 | 0 | 0 | 0 | 75
#10 | 0 | 0 | 0 | 69
#2 | 0 | 0 | 0 | 45
#3 | 0 | 0 | 0 | 36
#4 | 0 | 0 | 0 | 100
#5 | 0 | 0 | 0
#6 | 0 | 0 | 0
#7 | 0 | 0 | 0 | 50
#8 | 0 | 0 | 0 | 50
#9 | 0 | 0 | 0
0008BW | 0 | 0 | 0
010-2 | 0 | 0 | 0
011-16 | 0 | 0 | 0
011-3 | 0 | 0 | 140
013-1 | 0 | 0 | 0
013-13 | 0 | 0 | 0
014-12 | 0 | 0 | 8
0143S | 0 | 0 | 0
015-14 | 0 | 0 | 0 | 9
015-5 | 0 | 0 | 0 | 70
016-14 | 0 | 0 | 0
016-15 | 0 | 0 | 0
016-15-2 | 0 | 0 | 0
016-M | 0 | 0 | 0
017-14 | 0 | 0 | 0
Spreadsheet: 873768d1720336297-how-to-find-total-of-working-hours-from-a-single-cell-2024
Sheet: ΚΥΡΙΑΚΕΣ 2024 (2)

 | ΙΟΥΝΙΟΣ |  |  |  |  |  | ΙΟΥΛΙΟΣ |  |  |  |  |  | ΑΥΓΟΥΣΤΟΣ |  |  |  |  |  | ΣΕΠΤΕΜΒΡΙΟΣ
 | ΣΚΦ |  |  | ΦΑΙΔΡΑ |  |  | ΣΚΦ |  |  | ΦΑΙΔΡΑ |  |  | ΣΚΦ |  |  | ΦΑΙΔΡΑ |  |  | ΣΚΦ |  |  | ΦΑΙΔΡΑ
 | 2024-06-02 00:00:00 | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ |  | 2024-06-02 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ |  | 2024-07-07 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  | 2024-07-07 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 2024-06-02 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  | 2024-06-09 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ |  | 2024-07-07 00:00:00 | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ
 | 2024-06-09 00:00:00 | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ |  | 2024-06-16 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 2024-06-09 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  | 2024-06-23 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 2024-06-16 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  | 2024-06-30 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 2024-06-16 00:00:00 | YAKIMIDI OLESSYA
 | 2024-06-16 00:00:00 | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ
 | 2024-06-23 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ
 | 2024-06-23 00:00:00 | YAKIMIDI OLESSYA
 | 2024-06-30 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ
 | 2024-06-30 00:00:00 | YAKIMIDI OLESSYA
 | 2024-06-30 00:00:00 | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ
 | ΚΥΡΙΑΚΕΣ ΠΟΥ ΔΟΥΛΕΨΑΝΕ |  |  | ΚΥΡΙΑΚΕΣ ΠΟΥ ΔΟΥΛΕΨΑΝΕ |  |  | ΚΥΡΙΑΚΕΣ ΠΟΥ ΔΟΥΛΕΨΑΝΕ |  |  | ΚΥΡΙΑΚΕΣ ΠΟΥ ΔΟΥΛΕΨΑΝΕ
 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ |  |  | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ |  |  | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ |  |  | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  |  | YAKIMIDI OLESSYA |  |  | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  |  | YAKIMIDI OLESSYA
 | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ |  |  |  |  |  | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ
 | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ |  |  |  |  |  | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ
 | YAKIMIDI OLESSYA |  |  |  |  |  | YAKIMIDI OLESSYA
Spreadsheet: 486094d1477322028-variable-lookup-of-data-across-different-tabs-while-skipping-blanks-sample-box-numbering-for-multi-station-process-10-23-16
Sheet: Station B

Station B
Product | Quantity | Expiration Date | Box B1 | [NAME] | [NAME] | Box B4 | [NAME] | [NAME] | [NAME] | [NAME] | Box B9 | [NAME]
SKU1 | 15
SKU2 | 15
SKU3 | 15
[NAME] | 15
[NAME] | 15
Spreadsheet: 828118d1683229638-return-value-based-on-date-time-format-shift-test-book
Sheet: Sheet1

1st shift End | 15:00:00
Load Time | Shift | Desired Result
2023-05-02 17:42:47 |  | 2
2023-05-02 17:23:50 |  | 2
2023-05-02 17:18:46 |  | 2
2023-05-02 17:13:24 |  | 2
2023-05-02 17:09:34 |  | 2
2023-05-02 17:05:53 |  | 2
2023-05-02 17:02:52 |  | 2
2023-05-02 16:57:41 |  | 2
2023-05-02 16:52:37 |  | 2
2023-05-02 16:49:40 |  | 2
2023-05-02 16:42:09 |  | 2
2023-05-02 16:37:47 |  | 2
2023-05-02 16:34:28 |  | 2
2023-05-02 16:29:34 |  | 2
2023-05-02 14:56:26 |  | 2
2023-05-02 14:14:15 |  | 2
2023-05-02 13:56:37 |  | 2
2023-05-02 13:47:57 |  | 2
2023-05-02 13:43:52 |  | 2
2023-05-02 13:37:51 |  | 2
2023-05-02 13:34:44 |  | 2
2023-05-02 13:28:52 |  | 2
2023-05-02 13:25:53 |  | 2
2023-05-02 13:23:16 |  | 2
2023-05-02 13:16:59 |  | 2
2023-05-02 13:13:54 |  | 2
2023-05-02 13:09:29 |  | 2
2023-05-02 13:05:44 |  | 2
2023-05-02 13:00:28 |  | 2
2023-05-02 12:58:46 |  | 1
2023-05-02 12:55:23 |  | 1
2023-05-02 12:53:33 |  | 1
2023-05-02 12:44:43 |  | 1
2023-05-02 12:40:39 |  | 1
2023-05-02 11:57:30 |  | 1
2023-05-02 11:53:27 |  | 1
2023-05-02 11:47:27 |  | 1
2023-05-02 11:43:27 |  | 1
2023-05-02 11:39:38 |  | 1
2023-05-02 11:37:33 |  | 1
2023-05-02 11:27:47 |  | 1
2023-05-02 11:23:30 |  | 1
2023-05-02 11:05:08 |  | 1
2023-05-02 11:02:54 |  | 1
2023-05-02 10:56:43 |  | 1
2023-05-02 10:54:09 |  | 1
2023-05-02 10:50:22 |  | 1
2023-05-02 10:48:40 |  | 1
2023-05-02 10:39:06 |  | 1
2023-05-02 10:34:37 |  | 1
2023-05-02 10:28:19 |  | 1
2023-05-02 10:26:00 |  | 1
2023-05-02 10:19:33 |  | 1
2023-05-02 10:12:52 |  | 1
2023-05-02 09:56:25 |  | 1
2023-05-02 09:50:17 |  | 1
Spreadsheet: 870433d1716952570-show-value-blank-or-please-select-slicers-when-some-of-slicer-not-selected-example
Sheet: Sheet1

 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | الثانية
 |  |  | الثانية
 |  |  | الثالثة
 |  |  | الثالثة
 |  |  | الرابعة
 |  |  | الرابعة
 |  |  | الخامسة
 |  |  | الخامسة
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | الثامنة
 |  |  | الثامنة
 |  |  | التاسعة
 |  |  | التاسعة
 |  |  | العاشرة
 |  |  | العاشرة
 |  |  | الحادية عشر
 |  |  | الحادية عشر
 |  |  | الثانية عشر
 |  |  | الثانية عشر
 |  |  | الثالثة عشر
 |  |  | الثالثة عشر
 |  |  | الرابعة عشر
 |  |  | الرابعة عشر
 |  |  | [NAME]
 |  |  | الثاية
 |  |  | الثالثة
 |  |  | الرابعة
 |  |  | الخامسة
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | الثمانة
 |  |  | التاسعة
 |  |  | العاشرة
 |  |  | الحادية عشر
 |  |  | الثانية عشر
 |  |  | الثالثة عشر
 |  |  | الرابعة عشر
Spreadsheet: 700295d1603119184-want-to-count-information-in-visable-rows-after-sorting-sample_v2-joseph
Sheet: Sheet1

Date | ID#
2020-01-02 00:00:00 | 1
2020-01-02 00:00:00 | 19
2020-01-02 00:00:00 | 114
2020-01-03 00:00:00 | 1
2020-01-03 00:00:00 | 1
2020-01-03 00:00:00 | 1
2020-01-03 00:00:00 | 1
2020-01-03 00:00:00 | 1
2020-01-03 00:00:00 | 67
2020-01-03 00:00:00 | 81
2020-01-03 00:00:00 | 93
2020-01-03 00:00:00 | 105
2020-01-03 00:00:00 | 126
2020-01-03 00:00:00 | 144
2020-01-03 00:00:00 | 154
2020-01-03 00:00:00 | 166
2020-01-03 00:00:00 | 195
2020-01-03 00:00:00 | 243
2020-01-03 00:00:00 | 266
2020-01-03 00:00:00 | 327
2020-01-03 00:00:00 | 337
2020-01-03 00:00:00 | 366
2020-01-06 00:00:00 | 1
2020-01-06 00:00:00 | 1
2020-01-06 00:00:00 | 1
2020-01-06 00:00:00 | 1
2020-01-06 00:00:00 | 1
2020-01-06 00:00:00 | 1
2020-01-06 00:00:00 | 1
2020-01-06 00:00:00 | 1
2020-01-06 00:00:00 | 1
2020-01-06 00:00:00 | 1
2020-01-06 00:00:00 | 120
2020-01-06 00:00:00 | 126
2020-01-06 00:00:00 | 133
2020-01-06 00:00:00 | 161
2020-01-06 00:00:00 | 180
2020-01-06 00:00:00 | 201
2020-01-06 00:00:00 | 208
2020-01-06 00:00:00 | 243
2020-01-06 00:00:00 | 268
2020-01-06 00:00:00 | 328
2020-01-06 00:00:00 | 337
2020-01-06 00:00:00 | 349
2020-01-07 00:00:00 | 14
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
2020-01-07 00:00:00 | 1
 |  |  | Summary | Results |  | The correct answer Im looking for if I filter to remove "1" in the ID column
 |  |  | 2020-01-02 00:00:00 |  |  | 2
 |  |  | 2020-01-03 00:00:00 |  |  | 14
 |  |  | 2020-01-06 00:00:00 |  |  | 12
 |  |  | 2020-01-07 00:00:00 |  |  | 1
Spreadsheet: 733949d1621929649-copy-and-transpose-formula-auto-reformat
Sheet: Payables

I kindly asking for a formula which can automatically transpose data from Auto sheet to Payables  sheet as shown in the desired outcome.
DESIRED OUTCOME
1 | ST 002 | Net Salaries
 | Receipt | Invoice | Debit | Credit | Cumulative Balance
2021-01-01 00:00:00 | 7 | 2 | 0 | 0 | 0
2021-01-25 00:00:00 | 0 | January |  | 185503.5 | -185503.5
2021-01-26 00:00:00 | 16 | 5 | 6581 |  | -178922.5
2021-01-26 00:00:00 | 17 | 5 | 5793 |  | -173129.5
2021-01-26 00:00:00 | 18 | 5 | 4461 |  | -168668.5
2021-01-26 00:00:00 | 19 | 5 | 7913 |  | -160755.5
2021-01-26 00:00:00 | 20 | 5 | 4953 |  | -155802.5
2021-01-26 00:00:00 | 21 | 5 | 4043 |  | -151759.5
2021-01-26 00:00:00 | 22 | 5 | 4584 |  | -147175.5
2021-01-26 00:00:00 | 23 | 5 | 11043 |  | -136132.5
2021-01-26 00:00:00 | 24 | 5 | 3399 |  | -132733.5
2021-01-26 00:00:00 | 25 | 5 | 4580 |  | -128153.5
2021-01-26 00:00:00 | 26 | 5 | 11134 |  | -117019.5
2021-01-26 00:00:00 | 27 | 5 | 4107 |  | -112912.5
2021-01-26 00:00:00 | 28 | 5 | 4359 |  | -108553.5
2021-01-26 00:00:00 | 29 | 5 | 7929 |  | -100624.5
2021-01-26 00:00:00 | 30 | 5 | 10480 |  | -90144.5
2021-01-26 00:00:00 | 31 | 5 | 9370 |  | -80774.5
2 | ST 003
 | Receipt | Invoice | Debit | Credit | Cumulative Balance
2021-01-01 00:00:00 | 2 | 2 | 0 | 0 | -1983.41
 | 0 | January
2021-02-25 00:00:00 | 0 | february |  |  | -5950.23
2021-03-25 00:00:00 | 0 | march |  |  | -7933.64
2021-03-31 00:00:00 | 136 | 136 |  |  | -2.273736754432321e-13
2021-04-25 00:00:00 | 0 | April |  |  | -30183.13
3
 | Receipt | Invoice | Debit | Credit | Cumulative Balance
2021-01-01 00:00:00 | 1 | 1 | 0 | 0 | -4054.46
 | 0 | January
2021-02-25 00:00:00 | 0 | february |  |  | -12163.26
2021-03-25 00:00:00 | 0 | March |  |  | -16217.66
2021-03-31 00:00:00 | 140 | 140 |  |  | -0.06000000000040018
Spreadsheet: 093532a8-0569-45ce-b52e-45010cfeeb5c
Sheet: 3.3 Research Equipment

Institution
Indicator 3: Physical Resources
Table 3.3: Instructional/ Research Equipment and Facilities Acquired /AY 2010-11
Please enter major instructional/ research equipment and facilities acquired during the academic year
Major Instructional/ Research Equipment and Facilities Acquisition
 | AY 10-11
Equipment or Facility Name | Math & Science Lab Renovation - New equipment
Purchase Cost | 73818
Number of Units | 1 lot
Purpose | update science labs
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Equipment or Facility Name
Purchase Cost
Number of Units
Purpose
Notes:
0
Spreadsheet: 698825d1602189559-how-to-match-cells-that-have-numbers-and-text-and-arent-exact-matches-server-and-sn-comparison-old-servers-10-7-20-v2
Sheet: Server & SN List

Server | sn
ABC1 | 2M200123456A
[NAME] | 2M200123456Bbb
ABC3 | 2M200123457C
[NAME] | 2M200123456D
ABC5 | 2M200123457E
ABC6 | 2M200123456Fff
ABC7 | 2M200123457G
ABC8 | 2M200123456H
ABC9 | 2M200123456I
ABC10 | 2M200123456Jjj
Spreadsheet: 3360d7f7-36a9-4c48-8ce2-39f4757e00a5
Sheet: Sheet1

 | Safety Razor | Atra (current razor) | Straight Razor and Strop
Days per blade | 7 | 7 | -
Price per blade | 0.0829 | 0.4788 | -
New Razor | 35 | - | 150
Blade price per day |  |  | -
$ Saved per day
Days to make back price |  | -
Years to make back price |  | -
$ Saved per year
Blades per year |  |  | 0
Cost per year |  |  | 0
Spreadsheet: 848176d1698947575-extract-and-separate-text-split_data
Sheet: Sheet1

 | 5 Happy Soul | 8/1 b |  |  | 5 Happy Soul | 8/1 |  |  | 8/1
 | 11 Watch This [NAME] 12/1 | L |  |  | 11 Watch This [NAME] | 12/1 |  |  | 12/1
 | 4 Music Festival 10/1 | L |  |  | 4 Music Festival | 10/1 |  |  | 10/1
 | 12 Perfect Prankster | 15/1 |  |  | 12 Perfect Prankster | 15/1 |  |  | 15/1
 | 7 Workislife 20/1 |  |  |  | 7 Workislife | 20/1 |  |  | 20/1
 | 13 Take Time to Dream 3/1 L |  |  |  | 13 Take Time to Dream | 3/1 |  |  | 3/1
 | 3 Icicles 6/1 Lb |  |  |  | 3 Icicles | 6/1 |  |  | 6/1
 | 1 Crushed Ice 8/1 L |  |  |  | 1 Crushed Ice | 8/1 |  |  | 8/1
 | 2 Devil Blue Dress | 9/2 [NAME] |  |  | 2 Devil Blue Dress | 9/2 |  |  | 9/2
 | 6 Three Polks 4/1 L |  |  |  | 6 Three Polks | 4/1 |  |  | 4/1
 | 10 Honky Tonk Highway10/1 |  |  |  | 10 Honky Tonk Highway | 10/1 |  |  | Highway10/1
 | 9 Surf City | 8/1 |  |  | 9 Surf City | 8/1 |  |  | 8/1
 | 8 Let's Go Mark | 30/1È |  |  | 8 Let's Go Mark | 30/1 |  |  | 30/1