tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 850655d1701066120-formula-to-pull-filtered-list-from-another-sheet-based-on-search-box-calculetor-copy
Sheet: Data

Item Name | Brand | Company 1 | Price | Company2 | Price2 | Compnay 3 | Price3
DAGI TALA CHABI |  | TYT/H
WATER BODY MEHRAN | GMB | TYT/H
CROSS NO 1 | CYB | TYT/H
CHMTA MEHRAN SP | SP555 | TYT/H
CHMTA MEHRAN RAP | RAP | TYT/H
CHABI SWITCH MEHRAN | CH | TYT/H
DISC XLI FRONT 2012 A73 | ASUKI | TYT/H
PISTON MEHRAN | NET | TYT/H
VALVE MEHRAN | SUPREM | TYT/H
RING MEHRAN | NPR | TYT/H
FRONT SHOCK | GABRIAL | TYT/H
FRONT SHOCK SPRING 7K | CH | TYT/H
FRONT SHOCK SPRING 8K | CH | TYT/H
FRY WHEEL RING | RAVI | TYT/H
MAIN BEGIAN 050 | THAI | TYT/H
[NAME]*204 | KOYO | TYT/H
[NAME] | HOS | TYT/H
[NAME] | LOC | TYT/H
DOOR KUNDA REAR BOLN | LOC | TYT/H
CONECTOR ROD KABLA W*N | KABLI | TYT/H
CORBORETOR JET 85NO | CH | TYT/H
CV JOINT MEHRAN INNER | BMX | TYT/H
HEAD TAKI 20 NUMBER | LOC | TYT/H
CLUMP 0 SIZE | CHI | TYT/H
EXCEL CONE RED KANARI | KOYO | TYT/H
EXCEL CONE SADA | KOYO | TYT/H
[NAME] | LOC | TYT/H
[NAME] | LOC | TYT/H
VALVE GUIDE | JPN | TYT/H
OIL PIMP MEHRAN (w) | RAVI | TYT/H
REVERSE SWITCH MEHRAN | TIW | TYT/H
WATER BODY CULTUS | GMB | TYT/H
BATTERY TERMINAL HAVI/D | F/BHARI | FN/H
PISTON [NAME] | ART | MN
RING WAGNOR | NPR | MN
MAIN BEGIAN WAGNOR | THI | MN
THIRS COLOR WAGNOR | PSGP | MN
OIL PUMP KIT WANOR | FUJI | MN
JAIN [NAME] COMPLET | CHI | MN
FAN BELT WAGNOR JPN | BANDO | MN
CLUTCH SET WAGNOR | PSGP | MN
WATER BODY WAGNOR | GMB | MN
CLUTCH BEARING WAGNOR | NTN | MN
RADIATIOR PIP LOHA WAGNOR |  | MN
WATER JACKET | PSGP | MN
BEARING 6002 | KOYO | MN
Spreadsheet: 799165d1664969901-create-new-value-if-certain-conditions-are-met-test-entitled-to-a-bundle-package-3-
Sheet: Desired outcome 

Account number | School name | School Type | School Region | Subscription 1 | Subscription 2 | Subscription 3 | Subscription 4 | Subscription 5 | Bundle package
1234 | St Marys School | Secondary | Birmingham | 0 | English | Maths | Science | 0 | Spanish and French
2345 | St Pauls School | High School | [NAME] | Science | 0 | 0 |  |  | Spanish and French
3456 | London Free School | All Through | London | Science | Maths
4567 | St Michaels School | Secondary | [NAME] | Science | Maths | English | History | Geography
5678 | Liverpool Academy | Secondary | Liverpool | 0 | Maths | 0 |  |  | Spanish and French
Spreadsheet: 65655d1266347931-selective-data-to-get-a-printed-report-budget-to-actual-expenditure-2010-slots
Sheet: 10

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimated Duty / Tax / Transport = |  | 0.45
 | Details |  |  |  |  | Quotation |  |  |  |  |  | Invoice |  |  |  |  |  |  |  | Local Duty, TAX & Local Transport
I / Q | # | Sequence # | Company | Discription |  | Quotation # | Quotation (Euro) | X rate | RSD | Date (processed) |  | Invoice # | Act invoice (Euro) | X rate | RSD | SHIP invoice | Difference % | Process (date) |  | Duty & Transport | Act invoice | Difference % | Paid (date) |  | Total cost (actual) | Special NOTES
 | 1 | 8 | WMS | 6 x WMS game conversions |  | 02/74/2010/SER | 7027.73 | 98.65 | 693285.5645 |  |  |  |  |  | 0 |  | -1 |  |  | 311978.504025 |  | 0 |  |  | 0 | 17,558,400 is in budget for the year 2010… divided in 4 quarters ------ (3 game conversions FREE)
 | 2 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 3 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 4 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 5 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 6 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 7 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 8 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 9 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 10 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 11 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 12 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 13 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 14 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 15 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 16 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 17 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 18 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 19 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 | 20 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0
 |  |  |  | Total = |  |  |  |  | 693285.5645 |  |  |  |  |  | 0 |  |  |  |  | 311978.504025 |  |  | Total spent = |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget total = |  | 518940
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining = |  | 518940
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % = |  | 1
Spreadsheet: 79277d1279560863-writing-a-recursive-function-example
Sheet: AFTER

 |  |  |  |  |  | MANUFACTURER |  | MODEL |  | SERIAL |  | STATUS |  | Location |  | ASSET TAG |  | COST |  | NOTES
 |  |  |  |  |  |  |  |  |  | NUMBER
Service |  | Interface
Spreadsheet: 391945d1-ecd3-4b4d-9c33-5bd768894c26
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42510642 | 2014-07-29 23:58:49 | AXIS | 1 | 6 | 2 | 1612655 | player1612655 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
42511735 | 2014-07-30 01:29:06 | ALLIES | 1 | 6 | 4 | 1009110 | HO-SA-KAI | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
42511973 | 2014-07-30 02:02:06 | AXIS | 0 | 4 | 6 | 1009110 | HO-SA-KAI | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
42512288 | 2014-07-30 02:28:26 | AXIS | 1 | 6 | 1 | 1612199 | [NAME] | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
Spreadsheet: 272192d1382265383-formula-to-determine-what-time-double-time-starts-and-ends-after-16-30-colstim-1-ans
Sheet: Sheet1

 |  |  |  |  |  |  | slight change
 |  |  |  |  |  |  | 0:00 to 06:00  double time |  |  |  |  |  | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 07:00:00 | 07:30:00 | 08:00:00
 |  |  |  |  |  |  | 06:00 to 08:00  one and half time |  |  |  |  |  | x2 | x2 | x2 | x2 | x2 | x1.5 | x1.5
 | hi this works from 00:00 to 16:30 |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 1.5 | 1.5
 |  |  |  |  |  |  |  | 00:00:00 |  |  |  |  | or thought about doing it like this and conditional formatting hrs worked
 |  |  |  |  |  |  |  |  |  |  |  |  | then adding up the separate totals
[NAME]fri 00:00 hrs to 16:30
 |  | [NAME] in | [NAME] | std | x1.5 | x2.0 | Total effective hours
 |  | 05:00:00 | 20:00:00 |  |  |  |  |  |  |  |  |  |  | 2.5 hrs@ double time
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1hr @time and half
 |  |  |  |  |  |  | E9: =MIN(HOUR(D9-C9), 8)
 |  |  |  |  |  |  | F9: =IF(HOUR(D9-C9)>8,MIN(HOUR(D9-C9)-8,1),0)
 |  |  |  |  |  |  | G9: =IF(HOUR(D9-C9)>9,HOUR(D9-C9)-9,0)
[NAME]fri 1630 to24:00
 |  | [NAME] in | [NAME] | std | x1.5 | x2.0
 |  | 16:30:00 | 23:00:00
 | can not get this to work from 16:30 to 24:00
 | 16:30 to 1900 =x1.5
 | 1900 to 24:00 =x2
Spreadsheet: 787736d1657992796-need-formula-to-filter-student-information-based-on-a-condition-of-getting-subject-mark-le-student-filter
Sheet: Sheet2

Range 1 |  |  |  |  |  |  |  |  |  | Range 3
Semester | First | Stage | Second |  |  |  |  |  |  | Name | Stage | Semester | Subject |  | Name | Stage | Semester | Subject
Name | Sub.1 | Sub.2 | Sub.3 | Sub.4 | Sub.5 |  |  |  |  | Student 1 | Second | First | sub.1
Student 1 | 45 | 67 | 66 | 51 | 47 |  |  |  |  | student 1 | Second | First | sub.5
Student 2 | 75 | 46 | 66 | 77 | 92 |  |  |  |  | student 2 | Second | First | sub,2
Student 3 | 35 | 55 | 60 | 51 | 43 |  |  |  |  | student 3 | Second | First | sub.1
Student 4 | 60 | 34 | 52 | 59 | 40 |  |  |  |  | student 3 | Second | First | sub,5
Student 5 | 55 | 60 | 55 | 59 | 69 |  |  |  |  | student 4 | Second | First | sub.2
Student 6 | 39 | 52 | 33 | 40 | 39 |  |  |  |  | student 4 | Second | First | sub.5
Student 7 | 71 | 65 | 68 | 77 | 59 |  |  |  |  | student 6 | Second | First | sub.1
Student 8 | 47 | 43 | 43 | 47 | 60 |  |  |  |  | student 6 | Second | First | [NAME]
 |  |  |  |  |  |  |  |  |  | student  6 | Second | First | sub.4
 |  |  |  |  |  |  |  |  |  | student 6 | Second | First | sub.5
Range 2 |  |  |  |  |  |  |  |  |  | student 8 | Second | First | sub.1
 |  |  |  |  |  |  |  |  |  | student 8 | Second | First | sub.2
Semester | Second | Stage | Second |  |  |  |  |  |  | student 8 | Second | First | [NAME]
Name | Sub.6 | Sub.7 | Sub.8 | Sub.9 | Sub.10 |  |  |  |  | student 8 | Second | First | sub.4
Student 1 | 34 | 50 | 66 | 45 | 67 |  |  |  |  | student 1 | Second | second | sub.6
Student 2 | 51 | 92 | 66 | 55 | 46 |  |  |  |  | student 1 | Second | second | sub.9
Student 3 | 59 | 43 | 60 | 57 | 55 |  |  |  |  | student 2 | Second | second | sub.10
Student 4 | 34 | 40 | 52 | 40 | 34 |  |  |  |  | student3 | Second | second | sub.7
Student 5 | 46 | 69 | 55 | 35 | 60 |  |  |  |  | student 4 | Second | second | sub.6
Student 6 | 76 | 39 | 55 | 65 | 52 |  |  |  |  | student 4 | Second | second | sub.7
Student 7 | 61 | 59 | 68 | 55 | 65 |  |  |  |  | student 4 | Second | second | sub.9
Student 8 | 88 | 60 | 43 | 57 | 43 |  |  |  |  | student 4 | Second | second | sub.10
 |  |  |  |  |  |  |  |  |  | student 5 | Second | second | sub.6
 |  |  |  |  |  |  |  |  |  | student 5 | Second | second | sub,9
 |  |  |  |  |  |  |  |  |  | student 6 | Second | second | sub.7
 |  |  |  |  |  |  |  |  |  | student 8 | Second | second | sub.8
 |  |  |  |  |  |  |  |  |  | student 8 | Second | second | sub.10
Spreadsheet: 75d79b17-b631-43ca-bb68-c631352acc49
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
BCYP | Test | BCYP | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BCYP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BCYP | Result | BCYP | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7272-8
Spreadsheet: 677364d1589314234-using-countif-effectively-countif-counter
Sheet: Sheet1

Start Date | End Date | Who |  |  |  |  | Total Submissions | 7
2020-05-01 00:00:00 | 2020-05-15 00:00:00 | [NAME] |  |  |  |  | Final Submissions | 5
 |  |  |  |  |  |  | Final Submissions in time* | 2
Who | [NAME] | Final Submission | Due Date | Exception |  |  | Final Submissions with [NAME]** | 2
[NAME] | 2020-01-31 00:00:00 | 2020-02-18 00:00:00 | 2020-02-20 00:00:00 |  |  |  | [NAME] | 2
[NAME] | 2020-04-23 00:00:00 | 2020-05-04 00:00:00 | 2020-05-25 00:00:00 |  |  |  | [NAME] in Time*** | 2
[NAME] | 2020-04-15 00:00:00 | 2020-05-05 00:00:00 | 2020-05-12 00:00:00
[NAME] | 2020-05-06 00:00:00 |  | 2020-06-29 00:00:00 |  |  |  | [NAME] | 2
[NAME] | 2020-05-06 00:00:00 |  | 2020-06-29 00:00:00 |  |  |  | [NAME] | 2
[NAME] |  | 2020-05-04 00:00:00 | 2020-05-12 00:00:00 | Y |  |  | [NAME] in time* | 2
[NAME] |  | 2020-05-05 00:00:00 | 2020-05-18 00:00:00 | Y |  |  | [NAME] with [NAME]** | 2
Julie |  | 2020-05-07 00:00:00 | 2020-06-08 00:00:00 |  |  |  | [NAME] | 0
 |  |  |  |  |  |  | [NAME] in Time*** | 0
 |  |  |  |  |  |  | *Final time requirement is 5 working days before Due Date and excluding Exceptions
 |  |  |  |  |  |  | **Final submissions with draft excluding Exceptions
 |  |  |  |  |  |  | ***Draft time requirement is 15 workind days before Due Date
Spreadsheet: 774583d1648556603-a-minus-b-minus-vowels-conso-balance
Sheet: Sheet1

AABDDLN | DLN | BD
AABDLNS | DLN | BS
AACDLNS | DLN | CS
AADDLNS | DLN | DS
AADGLNR | DLN | GR
AADGLNS | DLN | GS
AADLLLN | DLN | LL
Spreadsheet: 169559d1342949086-sort-list-range-of-number-with-special-characters-bookp
Sheet: Sheet1

 | code | part a | part b
 | 2/2012 | 2 | 2012
 | 2/201222 | 2 | 201222
 | 3/2012 | 3 | 2012
 | 3/201333 | 3 | 201333
 | 22/2012 | 22 | 2012
 | 22/2013 | 22 | 2013
 | 33/2012 | 33 | 2012
 | 99/2011 | 99 | 2011
 | 99/2012 | 99 | 2012
 | 100/2012 | 100 | 2012
 | 100/20122 | 100 | 20122
 | 2/2012 | 2 | 2012
Spreadsheet: daren_farmer__6358__CES Report Request
Sheet: Sheet1

Name of Report | Requestor Name | Extension | Time Period Requested | Optimum Date to Pull | Date to Refresh
New AP Subledger thru AcctYr/Mth | [NAME] | 3-6587 | 12/1999 Accounting | 2000-01-31 00:00:00
New AP Subledger thru AcctYr/Mth | [NAME] | 3-6587 | 2/2000 Accounting | 2000-03-15 00:00:00
Total Purchases / Sales | [NAME] | 3-6587 | 6/1999 - 12/1999 Production | 2000-03-15 00:00:00
Contract Status | [NAME] | 3-6587 | Most recent available | 2000-01-15 00:00:00
Spreadsheet: 802136d1666682091-calculate-minutes-between-dates-with-criteria-response-time-sample-1-2-
Sheet: Sheet1

Request Received | Time of Dispatch | Response Time | Response Time | Response Time
 |  | [NAME] WBD | [NAME] HD | [NAME]
2022-10-24 09:50:00 | 2022-10-24 16:00:00
2022-10-24 09:50:00 | 2022-10-24 17:30:00
2022-10-24 09:50:00 | 2022-10-25 09:00:00
2022-10-24 11:50:00 | 2022-10-25 09:00:00
2022-10-24 11:50:00 | 2022-10-25 18:00:00
2022-10-28 10:00:00 | 2022-10-31 09:00:00
2022-10-28 11:00:00 | 2022-10-31 11:00:00
2022-10-29 10:00:00 | 2022-10-31 09:00:00
2022-10-29 12:00:00 | 2022-10-31 11:00:00
2022-10-28 10:00:00 | 2022-10-29 10:00:00
2022-10-28 11:00:00 | 2022-10-29 12:00:00
2022-10-28 11:00:00 | 2022-10-31 17:30:00
2022-10-27 10:00:00 | 2022-10-28 18:00:00
2022-10-27 10:00:00 | 2022-10-29 10:00:00
2022-10-27 11:00:00 | 2022-10-28 18:00:00
2022-10-27 11:00:00 | 2022-10-29 10:00:00
Spreadsheet: 71636c8f-6adb-4f61-ac19-bb6e5a073b3b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
[NAME]
PA/KPA |  | : | [NAME]
K/L/D/I |  | : | KABUPATEN MANGGARAI TIMUR
SKPD |  | : | BAGIAN UMUM
PEKERJAAN |  | : | PENGADAAN GENSET KANTOR
LOKASI |  | : | LEHONG - BORONG
TAHUN ANGGARAN |  | : | 2013
 |  | :
No | [NAME] | Volume | Satuan | Spesifikasi Teknis
I. | [NAME] |  |  | - Power Output | : | 100Kva / 80 KW
 |  |  |  | - Engine Type | : | 1006 TG 2A
 |  |  |  | - No. Of Cylinder | : | 6
 |  |  |  | - Bore x stroke | : | 100 (mm) x 127 (mm)
 |  |  |  | - Piston Dipl | : | 6000 Liter
 |  |  |  | - Fuel consumption  (L/H) | :
 |  | 1 | UNIT | 75% load | : | 16.50 (L/H)
 |  |  |  | 100% load | : | 21.80 (L/H)
 |  |  |  | - Fuel Tank Capacity
 |  |  |  | - Oil Capacity | : | 16.2 Liter
 |  |  |  | - Silent Type
 |  |  |  | Approximate Dimension | : | P = 2.750 mm; L = 1.10 mm; T = 1.350 mm
 |  |  |  | Approximate Weight | : | 1.479 Kg
II. | PANEL AMF / ATS
 |  |  |  | - Box Panel 1800 x 600 x 600 plat 2mm free standing power coating
 |  |  |  | - Motorized COS 4P 400A  Socomec
 |  |  |  | - MCCB 3P Schineder electric
 |  | 1 | UNIT | - Batterey Charger 24 V /7,5 A Monicon
 |  |  |  | - AMF Module DSE4420 Deepsea
 |  |  |  | - Rele Omron MY2
 |  |  |  | - MCB 1P 6A Schneider Electric
 |  |  |  | - Metering ( CT, [NAME], [NAME] ) CIC
 |  |  |  | - Pilot Lamp, Push Botton
 |  |  |  | - Wiring Diagram dan Manual
[NAME]
PA/KPA |  | : | [NAME]
K/L/D/I |  | : | KABUPATEN MANGGARAI TIMUR
SKPD |  | : | BAGIAN UMUM
PEKERJAAN |  | : | PENGADAAN GENSET KANTOR
LOKASI |  | : | LEHONG - BORONG
TAHUN ANGGARAN |  | : | 2013
III. | PANEL SYNCRON
 |  |  |  | - Box Panel 2000 x 700 x 700 plat 2mm free standing powder coating
 |  |  |  | - Motorized MCCB 3P 400A STR22SE + UVT + Aux contact [NAME] electric
 |  |  |  | - Double Voltmeter GAE
 |  |  |  | - Zero Voltmeter GAE
 |  |  |  | - Double Frekwensi meter GAE
 |  | 1 | UNIT | - Voltmeter GAE
 |  |  |  | - Amperemeter GAE
 |  |  |  | - kW meter GAE
 |  |  |  | - Cos Phi meter GAE
 |  |  |  | - Synchronizing & Protection Modul DKG707 Datakom
 |  |  |  | - Speed adjust switch [NAME]
 |  |  |  | - Potensiometer Spectrol
 |  |  |  | - MCB 1P 6A
IV. | KABEL POWER | 1 | UNIT | NYY (4 x 50) 3 Phasa
V. | [NAME] | 1 | UNIT | NYY (4 x 6) 3 Phasa
Spreadsheet: 91936d1291635234-how-to-revise-average-formula-county-contractors-tender-register
Sheet: Tender Register

Enquiry  No. | Client | Project | Description | [NAME] | Estimator | [NAME] | Winning Bid | [NAME] | [NAME] | Finishing Position | Comments
25276 | Oxfam | Dorchester | Roofing | 2010-11-26 00:00:00 | LH | 11440 | 10998 | -442 | -0.03863636363636364 | 2
25275 | Priory Group | Brook House Thetford | F/F Bedroom refurbishment & G/f layout reconfiguration. | 2010-12-15 00:00:00 | MAB
25277 | Craegmoor | Olcote House Pontypridd | Refurbishment of main core and bungalows | 2010-12-10 00:00:00 | LH
25278 | BA Property Consultants | Units J6, H1 & H2 Gellihirion Ind Estate Pontypridd | Tenants dilapidations/refurbishment | 2010-12-06 00:00:00 | LH
25267 | Priory Group | [NAME] | Shower Room conversion. W.C refurb. | 2010-12-10 00:00:00 | LH
25270 | Avon & Wilts NHS Trust | Bath NHS House | Lifecycle & backlog works | 2010-12-10 00:00:00 | SP
25260 | RMG | Redhill  DO | New Enquiry Office & Other Alterations | 2010-12-15 00:00:00 | MAB
25262 | [NAME] | Fairmead Special School | Shower Room Refurbishments | 2010-12-15 00:00:00 | MW
25248 | [NAME] | Block 2 - Villa Rosa WSM | Replacement wall ties & lintols | 2010-12-16 00:00:00 | LH |  |  |  |  |  | [NAME] sent to consulant 19/11/10 seeking clarity re works
25254 | Oxfam | Tavistock | Refurbishment works | 2010-11-26 00:00:00 | DW | 36063 | 36063 | 0 | 0 | 1
25285 | RMG | Wimbourne | Planned maintenance of DO and Garage | 2010-12-20 00:00:00 | MW
25286 | RMG | Hedge End | Planned maintenance - internal & external | 2010-12-20 00:00:00 | MAB
25287 | Avon & Wilts NHS Trust | Fountain Way Hospital Salisbury | Refurbishment and life cycle works to rooms | 2010-12-21 00:00:00 | DW
25282 | RMG | [NAME] | Planned maintenance of Mail Centre | 2010-12-22 00:00:00 | WA
25290 | Oxfam | Queens Road Clifton | [NAME] | 2010-12-20 00:00:00 | DW
25291 | Oxfam | 232 High St Berhamsted | Acquisition & fit out | 2010-12-08 00:00:00 | LH
25288 | [NAME] | 56 Graig-y-Coed Swansea | [NAME] | 2010-12-14 00:00:00 | WA
 | Craegmoor | 14 Fairmoor Close Lydney | Repairs to boundary wall | 2010-12-17 00:00:00 | LH
25294 | Oxfam | 60 High St Totnes | Electrical Works | 2010-12-03 00:00:00 | LH | 1354 |  |  | #N/A
25295 | Oxfam | 1/1a [NAME] | Electrical Works | 2010-12-03 00:00:00 | LH | 1249 |  |  | #N/A
25289 | BANES | [NAME] | Internal Walls & Partitions | 2011-01-07 00:00:00 | MAB
25296 | South Wales Fire & Emergency Services | Llantrisant | Carpentry, Painting & Decorating | 2011-01-05 00:00:00 | SP
25297 | Cefn Hengoed School | Swansea | Painting & Decorating |  | SP
25253 | Bristol City Council | Longlands House | Refurbishment works | 2010-12-03 00:00:00 | MW | 16687 | 16687 | 0 | 0 | 1
25252 | Bristol City Council | [NAME] | Refurbishment works | 2010-12-03 00:00:00 | MW | 16687 | 16687 | 0 | 0 | 1
25299 | East Brent Village Hall Committee | East Brent Village Hall | Replacement of Internal Doors | 2010-12-23 00:00:00 | LH
Spreadsheet: 273705d1382870646-i-need-analysis-formula-resultanalysis
Sheet: Sheet1

GENDER | NAME | GRADE
F | ASHA | A |  |  | Row Labels | Count of NAME
F | AMINA | C |  |  | A | 1
F | [NAME] | C |  |  | B | 3
F | FATMA | F |  |  | C | 6
F | DIANA | D |  |  | D | 6
F | REHEMA | D |  |  | F | 3
F | NEEMA | B
F | TINA | D
M | ALLY | D
M | [NAME] | F
M | [NAME] | B
M | SELE | B
M | SAID | C
M | HASSAN | C
M | HUSSEN | F
M | BARAKA | C
M | MUSA | C
M | SUDI | D
M | MARCO | D
Spreadsheet: 792709d1661095350-how-to-lookup-data-by-date-and-time-and-get-a-range-of-data-lookup-and-get-a-range
Sheet: Sheet1

Data table(Source data)
Date | 2022-08-22 00:00:00 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00 | 2022-08-25 00:00:00
Time | 02:00:00 | 10:00:00 | 02:00:00 | 10:00:00
Subject Code-1 | 66451 |  | 66751 | 66751
[NAME] | 66751 |  | 67051 | 67051
Subject Code-3 | 67051 | 66751 | 67151 | 67151
Subject Code-4 | 67151 | 67051 | 66851 | 66851
Subject Code-5 | 66851 | 67151
Subject Code-6 | 68651 | 66851
Subject Code-7
Subject Code-8
(Input data)
Date input: | 2022-08-22 00:00:00
Time input: | 02:00:00
Subject Code (Required Output)
66451
66751 | 66751
67051 | 67051
67151 | 67151
66851 | 66851
68651 | 68651
Spreadsheet: 858778d1707332373-how-to-analyze-survey-text-data-multiple-answers-are-selected-expected-outcomeupdated
Sheet: Sheet2

Row Labels
Department Cardiovascular
123-4567
2020-0444
2020-0472
2020-1090
2023-1001
3456-1234
Department Investigational
nci0923434
2019-0001
alliance000114
Department Lymphoma
2024-2024
Department Myloma
2019-0335
2023-0444;
2022-0111;
Department Urology
2022-0234
Grand Total
Spreadsheet: 166682d1341716238-trouble-have-vlookup-recognize-unique-identifiers-from-different-spreadsheets-help-with-vlookup
Sheet: Sheet2

UNIQUE IDENTIFIER
740010 | 226.84 | 2012-05-11 00:00:00 | 39.4 | 224.88 | 2012-05-11 00:00:00 | 39.2 | 227.12 | 2012-05-11 00:00:00 | 40.2 | 678.84
740017 | 225.86 | 2012-05-11 00:00:00 | 36.4 | 224.87 | 2012-05-11 00:00:00 | 40.4 | 225.52 | 2012-05-12 00:00:00 | 39.4 | 676.25
740019 | 225.04 | 2012-05-12 00:00:00 | 46.9 | 226.62 | 2012-05-12 00:00:00 | 39.6 | 224.82 | 2012-05-12 00:00:00 | 34.7 | 676.48
740008 | 226.29 | 2012-05-11 00:00:00 | 38.5 | 224.45 | 2012-05-11 00:00:00 | 35.8 | 226.29 | 2012-05-11 00:00:00 | 41.2 | 677.03
740014 | 229.63 | 2012-05-11 00:00:00 | 41.8 | 225.01 | 2012-05-12 00:00:00 | 40.3 | 229.63 | 2012-05-12 00:00:00 | 51.4 | 684.27
740012 | 225.47 | 2012-05-12 00:00:00 | 39.4 | 231.65 | 2012-05-12 00:00:00 | 46.8 | 227.96 | 2012-05-12 00:00:00 | 41.8 | 685.08
740000 | 228.37 | 2012-05-11 00:00:00 | 41.2 | 227.54 | 2012-05-11 00:00:00 | 39.7 | 227.12 | 2012-05-11 00:00:00 | 41.3 | 683.03
740018 | 222 | 2012-05-11 00:00:00 | 33.8 | 225 | 2012-05-11 00:00:00 | 39.6 | 225.26 | 2012-05-11 00:00:00 | 39.1 | 672.26
740009 | 225.87 | 2012-05-12 00:00:00 | 36.8 | 225.01 | 2012-05-12 00:00:00 | 39.5 | 226.7 | 2012-05-12 00:00:00 | 42 | 677.5799999999999
740007 | 227.54 | 2012-05-12 00:00:00 | 39.5 | 229.19 | 2012-05-12 00:00:00 | 41.3 | 232.97 | 2012-05-12 00:00:00 | 40.8 | 689.6999999999999