tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 96928d1296164312-excel-2007-getting-only-selcted-rows-to-transfer-to-a-new-sheet-for-printing-sample-sheet
Sheet: june

Last Name | First Name | MI | Address | City | State | Zip | Phone | FAX | E-Mail | Salary | Insurance | 401K
Mickeley | [NAME] | M | 503 [NAME] Dr. | Auburndale | FL. | 33823 | 8637984545 | 8636825214 | [EMAIL] | 25500 | No | Yes
[NAME] | George | J | 206 Lake St. | Auburndale | FL. | 33823 | 8637956565 | 8636829874 |  | 65500 | Yes | Yes
Samson | [NAME] | J | 405 Liberty St. | Auburndale | FL. | 33823 | 8637998653 | 8636665452 | [EMAIL] | 60000 | Yes | Yes
Gremsley | Lovey | C | 225 Edgewood St. | Auburndale | FL. | 33823 | 8636879630 | 8636593407.1694 | [EMAIL] | 65500 | No | No
[NAME] | [NAME] | M | 1631 Monterey Ave. | Auburndale | FL. | 33823 | 8636889512 | 8636588353.47939 | [EMAIL] | 58500 | No | Yes
[NAME] | [NAME] | B | 616 Alamo Dr. | Auburndale | FL. | 33823 | 8637984455 | 8636583299.78938 |  | 55600 | Yes | Yes
Washington | [NAME] | W | 1260 Pipkin Ave. | Auburndale | FL. | 33823 | 8637998855 | 8636542870.26934 | [EMAIL] | 59600 | Yes | Yes
Spreadsheet: 732395d1620926580-formula-to-transfer-data-to-another-sheet-without-blanks-copy-of-test-register-2021
Sheet: Overstay

Surname | Arrive Date | Note 1 | Note 2
Spreadsheet: 34934d1232391849-extracting-rows-of-data-datafromrowex
Sheet: Data

ID | Month | Name | Calls | Sales | Revenue
JanuaryJoe | January | [NAME] | 254 | 134 | 20000
januaryFred | january | Fred | 165 | 97 | 5000
[NAME] | january | [NAME] | 102 | 26 | 1008
januaryAndrew | january | [NAME] | 358 | 214 | 28000
[NAME] | january | Colette | 247 | 152 | 1800
FebruaryJoe | February | [NAME] | 365 | 280 | 22230
FebruaryFred | February | Fred | 145 | 83 | 4000
FebruaryJuliette | February | [NAME] | 352 | 205 | 18000
FebruaryAndrew | February | [NAME] | 85 | 3 | 1750
FebruaryColette | February | Colette | 135 | 98 | 4215
MarchJoe | March | [NAME] | 280 | 102 | 1400
MarchFred | March | Fred | 172 | 75 | 3500
MarchJuliette | March | [NAME] | 46 | 14 | 2750
MarchAndrew | March | [NAME] | 39 | 8 | 2000
MarchColette | March | Colette | 263 | 152 | 23000
Spreadsheet: 023240bb-5454-4908-b69a-a91196a986cb
Sheet: Sheet1

Supports and Services Authorization Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Participant: |  |  |  | MID#:
Agency Name | Procedure Code | Start Date | Stop Date | Units | Unit Cost | Frequency (x365, x52, x12, etc.) | Annual Cost | Annual Units | IPA #- Dept. use only
 |  |  |  |  |  |  | 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
 |  |  |  | Annual Total
 |  |  |  | Calculated Budget Amount:
 |  |  |  | +/- Medicaid Budget Total |  |  | 0
 |  |  |  | Final Plan Amount: ________________
Spreadsheet: 24059d1214071414-formula-help-multiple-sheets-calculating-of-instances-of-partic-result-w-in-range-dcount
Sheet: Sheet1

Result |  |  | Result | Result
30 |  |  | >=30 | <50
40 |  |  | Result
25 |  |  | >=50
26 |  |  | Result
45 |  |  | <30
29
65
54 |  | <30 | 3
 |  | >=30<50 | 3
 |  | >50 | 2
Spreadsheet: 525986d1499073321-averageif-help-operational-reporting-analyst-test-2
Sheet: Summary

 | Service Overview - OPEN roles
 | Current Open Roles |  |  |  |  |  | CHART 1 Open Roles by Department
 | [NAME]. days open
 | % Ageing Roles
 | Open Roles by Region
 | APAC
 | EMEA
 | LATAM
 | USA
 | Service Overview - FILLED roles
 |  | Financial Year 2014 |  |  |  | Financial Year 2015 |  |  |  | Financial Year 2016 |  |  |  | Financial Year 2017
 |  | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
 | APAC
 | EMEA
 | LATAM
 | USA
 | Total Rolles Filled
 | Avg. Time to [NAME]
 | Source of [NAME] FY17 |  |  |  |  | Filled Roles by Region FY17
 | CHART2 (Pie chart) Number of filled role by billing type FY17 only! |  |  |  |  | CHART 3 Filled Roles by Region FY17 only!
Spreadsheet: 266679d1379696087-formula-to-alphabetize-names-when-ties-occur-formula-for-alphabetizing
Sheet: By Word

Name | Rank | Score | Tie Break |  | Rank | Name | Score
MIL |  | 2
CRI |  | 2
COM |  | 5
DEN |  | 19
WHI |  | 1
FEA |  | 2
WOR |  | 3 |  |  |  |  |  |  | Trying to automate the alphabetizing of the names that have tie scores
SUE |  | 2
APP |  | 3
BAN |  | 14
CJS |  | 60
MED |  | 2
Spreadsheet: sara_shackleton__36379__Inapa
Sheet: Ticket

Paper/Pulp Deal Ticket
ERMS Deal Ticket Number: |  |  |  |  | (to be completed by [NAME])
 |  | Month |  | Day |  | Year
Deal Date:
ECT B/S
ECT Trader |  |  |  |  | Other:
Counterparty |  |  |  |  |  |  | Other: | Papeis Inapa, S.A.
Counterparty Contact |  | [NAME] |  |  |  |  | Phone | 00 351 65 23 05 01 |  |  | Fax | 00 351 65 70 05 11
Broker |  |  |  |  |  | Commission
Deal Type
Transaction Type |  |  |  |  | Other: |  |  |  |  |  | Linked trade
Option Style |  |  |  |  | Other:
 |  |  |  |  |  | Physical Prem |  |  |  | (ex: OCC11 - Official Board Markets)
Commodity |  |  |  |  |  | Storage
 |  |  |  |  |  | Other
 |  |  |  |  |  | Total
Pricing Reference | Commodity |  |  |  |  | Location |  | Low/High/Avg |  |  |  | Publication
Other: | [NAME], Eucalyptus |  |  |  |  |  |  | Low |  |  | France
Calculation Period |  |  |  |  |  |  | Payment/Settlement Date
 |  |  |  |  |  |  |  | Business Days After Price is Known
Other: |  |  |  |  |  | Note:
Fall Back Pricing:
 | Commodity |  |  |  |  | Location |  | Low/High/Avg |  |  |  | Publication |  |  |  |  | Spread
Other: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -60
Trade Terms |  |  |  |  |  |  |  |  |  |  |  |  |  | Conditional
 |  |  |  |  |  |  |  |  |  | Option only |  |  |  | Swap Only |  |  | Physical Only
Short/Metric | Monthly Vol. |  |  | Start Date |  | End Date |  | Fixed Price |  | Strike |  | Premium |  | [NAME] |  |  | Storage | Transport
 |  | 1666.666666666667 |  | 1999-08-01 00:00:00 |  | 2000-01-31 00:00:00 |  | 495
Currency
Note:
Note:
This trade is done between ECT London and Counterparty.  Then the back to back trade will be between ECT London and ECT.
Spreadsheet: 583577d1532516853-rework-a-template-in-order-to-create-a-weekly-calendar-2018_07_24__kalender
Sheet: Tabelle3

2018-08-01 00:00:00 | 1 | 8 | 2018 | Bla 1 | Blub 1 | Blabla 1
2018-08-02 00:00:00 | 2 | 8 | 2018 | Bla 2 | Blub 2 | Blabla 2
2018-08-03 00:00:00 | 3 | 8 | 2018 | Bla 3 | Blub 3 | Blabla 3
2018-08-04 00:00:00 | 4 | 8 | 2018 | Bla 4 | Blub 4 | usw. usf
2018-08-05 00:00:00 | 5 | 8 | 2018 | Bla 5 | Blub 5 | usw. usf
2018-08-06 00:00:00 | 6 | 8 | 2018 | Bla 6 | Blub 6 | usw. usf
2018-08-07 00:00:00 | 7 | 8 | 2018 | Bla 7 | usw. usf | usw. usf
2018-08-08 00:00:00 | 8 | 8 | 2018 | Bla 8 | usw. usf | usw. usf
2018-08-09 00:00:00 | 9 | 8 | 2018 | Bla 9 | usw. usf | usw. usf
Spreadsheet: 161697d1339601009-grouping-of-time-slots-in-excel-2010-everyfive
Sheet: Sheet1

Date Value |  |  | 0
2012-04-04 00:00:35 | 1
2012-04-04 00:01:35 | 2
2012-04-04 00:02:35 | 3
2012-04-04 00:03:35 | 2
2012-04-04 00:04:35 | 3
2012-04-04 00:05:35 | 1
2012-04-04 00:06:35 | 4
2012-04-04 00:07:35 | 5
2012-04-04 00:08:35 | 1
2012-04-04 00:09:35 | 2
2012-04-04 00:10:35 | 3
Spreadsheet: 163072d1340184066-need-help-whit-a-graph-fo-usage-bourbon-front
Sheet: Sheet1

FO Consumption Bourbon  Front
Month: | June
Operation | Time Start | Time Stop | Time | Fuel start (m3) | Fuel Stop (m3) | Vær | Engine load | Speed (Knots) | Engines used | Fuel Used (m3) | Fuel (m3) Used per Houre
Moored | 17:30:00 |  |  | 107.2 |  | Bra vær | 20 | 0 | 1 |  |  |  |  |  |  |  |  | Bra vær | Litt vær | Mye vær | Uvær
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Steaming
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dp Operation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Moored
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January |  |  | Harbor gen.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
ME1 |  | ME2 |  | ME3 |  | M4 |  | Harbor Gen. |  |  | Total fuel consumption per houre (Lieters)
Total Houres | Total Fuel con. | Total Houres | Total Fuel con. | Total Houres | Total Fuel con. | Total Houres | Total Fuel con. | Total Houres | Total Fuel con. |  | Me1 | Me2 | Me3 | Me4 | Harbor gen.
1955 | 332334 | 2687 | 539892 | 1948 | 321954 | 2877 | 468723
Spreadsheet: 268295d1380556380-return-text-when-values-dont-match-copy-of-hb-finished-goods-stock-review-23-september-2013
Sheet: OTHER

Commodity Code | Comm. Lng Desc | Pallet Number | Location | Classification | Qty | Receipt date | [NAME] | Comm. Group Code | Group 1 | Group 2 | Date | ACTION
39213-066 | ORBIS MULTI SENSOR 39213-066 A | 29183N1 | JM023G | 31 | 4500 | 130625 | 13/0021/1/26 | PACK | APOL |  | 25/06/13
51442 | HOME DECORATION TUB | 27648N15 | JR036C | 31 | 1875 | 121119 | 19/0022/1/45 | PACK | FRAN |  | 19/11/12
51442 | HOME DECORATION TUB | 27648N16 | [NAME] | 31 | 1875 | 121120 | 19/0022/1/45 | PACK | FRAN |  | 20/11/12
1VA1ZC61B | 1VA1ZC61B | 29193N1 | JH014B | 31 | 1000 | 130429 | 13/0576/1/1 | LIFT | REM |  | 29/04/13
[NAME] | MPE DRAIN TRAY + LID *TOOL O/S* | 26941N1 | JK020C | 31 | 30 | 120717 | 12/0833/1/1L | LIFT | ROCK |  | 17/07/12
[NAME] | SELDINGER LID | 24843N1 | JM018F | 31 | 420 | 111216 | 11/1042/2/1L | LIFT | ROCK |  | 16/12/11
ZTRAY035 | SELDINGER TOP TRAY | 24844N1 | JM017F | 31 | 460 | 111216 | 11/1042/2/1T | LIFT | ROCK |  | 16/12/11
[NAME] | MPE DRAIN TRAY + LID *TOOL O/S* | 26940N1 | JH041B | 31 | 30 | 120717 | 12/0833/1/1T | LIFT | ROCK |  | 17/07/12
[PHONE] | CLAM 8 Y1027 (330054) | 28577N1 | JD041D | 31 | 1000 | 130206 | 13/0139/1/2 | LIFT | SEC |  | 06/02/13
[PHONE]. | CLAM 8 Y1027 (330054) | 29944N1 | JD059E | 31 | 1000 | 130627 | 13/0139/2/1 | LIFT | SEC |  | 27/06/13
[PHONE]. | CLAM 10 y1022 (330056) | 29978N1 | JM026C | 31 | 1000 | 130627 | 13/0891/1/1 | LIFT | SEC |  | 27/06/13
PRETDELUXEBASE | PRET BASE - SINGLE STACK PLTS | 0529243 | JM008D | 31 | 8000 | 130507 | 12/0585/9/1 | PACK | TAIK |  | 07/05/13
PRETDELUXEBASE | PRET BASE - SINGLE STACK PLTS | 0529244 | JM008D | 31 | 8000 | 130507 | 12/0585/9/1 | PACK | TAIK |  | 07/05/13
PRETDELUXEBASE | PRET BASE - SINGLE STACK PLTS | 0529245 | JN042F | 31 | 8000 | 130507 | 12/0585/9/1 | PACK | TAIK |  | 07/05/13
Spreadsheet: 678275d1589805218-formula-to-get-unique-data-excel-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 500 | Expenses Airfare Aug-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 2500 | Expenses Airfare Jul-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 800 | Expenses Airfare Jun-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 500 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 350 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 450 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 550 | Expenses Airfare Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 650 | Expenses Airfare Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 750 | Expenses Airfare Sep-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50100 | 350 | Expenses Airfare Sep-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30100
Spreadsheet: 182775d1348599822-pivot-table-grouping-columns-together-and-obtaining-a-subtotal-groupingpivottables
Sheet: Sheet2

Year | (All)
Row Labels | Sum of Jan-Hours | Sum of Jan-Overtime | Sum of Feb-Hours | Sum of Feb-Overtime
1 | 369.2 | 37.90000000000001 | 369.2000000000001 | 62.39999999999999
A | 38 | 0.4 | 32.8 | 7.600000000000001
B | 34 | 9.1 | 39.6 | 6.600000000000001
C | 39.2 | 1.4 | 36.4 | 9.3
D | 35.6 | 4.7 | 38.8 | 3.4
E | 36.4 | 4.100000000000001 | 36.8 | 1.7
F | 36.8 | 2.3 | 38 | 7.5
G | 38.8 | 2.2 | 38.8 | 6.4
H | 36.4 | 3.5 | 34.8 | 3.5
I | 36.8 | 8 | 33.6 | 7.5
J | 37.2 | 2.2 | 39.6 | 8.9
2 | 330.4 | 44.1 | 334.8000000000001 | 59.2
K | 39.2 | 1.4 | 36.4 | 8.700000000000001
L | 39.2 | 8.200000000000001 | 39.6 | 4
M | 33.6 | 4.5 | 38.8 | 6.800000000000001
N | 40 | 8.5 | 32 | 5.9
O | 35.2 | 6.4 | 36.8 | 0.1
P | 37.2 | 1.4 | 38.8 | 9.700000000000001
Q | 34 | 6.100000000000001 | 40 | 8.5
R | 34.8 | 4.2 | 39.6 | 8.3
S | 37.2 | 3.4 | 32.8 | 7.2
Grand Total | 699.6000000000001 | 82.00000000000001 | 704 | 121.6
Spreadsheet: phillip_m_love__31192__Columbia Gas
Sheet: Sheet1

LONG TERM PHYSICAL DEALS WITH COLUMBIA GAS
Columbia Gas of Kentucky
none
Columbia Gas of Maryland
none
Columbia Gas of Ohio
Tagg | Sitara | Type of Deal | Start | Stop
NY7046 | 394747 | Physical, Gas Daily Option | 2001-12-01 00:00:00 | 2002-02-28 00:00:00
Columbia Gas of Pennsylvania
none
Columbia Gas of Virginia
none
Spreadsheet: 841018d1693273680-display-tables-based-on-drop-down-pull-history-and-highlight-from-conditional-format-dontation-list
Sheet: SELECTOR SHEET

 |  |  | CAT NUMBER: |  | 100 (laundry & Personal Care) |  |  |  |  |  | MACRO BUTTON HERE |  |  | (this button would pull the contact info (email) and generate a predefined email body asking if the charity would like to receive a donation)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | After selecting the "Cat number" above, I would like to display the entire table here. (pull table from the matching sheet) |  |  |  |  |  |  |  |  |  | Once the table is displayed, I'd like some conditional formatting that will highlight charities that have been previously donated to. |  |  |  |  |  |  |  |  |  |  |  |  | CAT NUMBER | [NAME]
 |  |  |  |  |  |  |  |  |  |  | More than a month ago would be Yellow, less than a month ago would be red(ish), not donated to at all would be Green |  |  |  |  |  |  |  |  |  |  |  |  | 100 | laundry & Personal Care
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200-A | General Food
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200-B | Chips
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 / 800 | Electronics
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500-A | General Pet Supplies
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500-C | Cat supplies
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500-D | Dog Supplies
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 | Cleaners
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | ALL
Spreadsheet: 80227d1280418328-take-data-from-1-list-and-put-with-match-in-another-help
Sheet: Info

Code | Entry # |  |  |  |  | Entry #
577LL | 895598 |  |  |  |  | 895598
5558L5 | 789887 |  |  |  |  | 465441
5899LL | 55588 |  |  |  |  | 65487
5785LL | 595897 |  |  |  |  | 8775
55887LL | 8775 |  |  |  |  | 5321
5757LL | 57987 |  |  |  |  | 13214
59799LL | 588975 |  |  |  |  | 789887
8558LL | 7587575 |  |  |  |  | 89742
77978LL | 79895585 |  |  |  |  | 632154
 |  |  |  |  |  | 57987
 |  |  |  |  |  | 24651
 |  |  |  |  |  | 7587575
 |  |  |  |  |  | 79895585
Spreadsheet: 777109d1650176587-count-no-of-cases-based-on-a-given-date-range-excelforum_countnocase-2-1-
Sheet: Defect

 | S/No | Car | Defect | WO/JR No. | Since | Status | Clear | >3 | No of Case | >7
 | 1 | 28 |  | NA | 2021-12-01 00:00:00 | Pending Investigation | 2021-12-10 00:00:00
 | 2 | 16 |  | NA | 2021-12-08 00:00:00 | Pending Investigation | 2021-12-31 00:00:00
 |  | 5 |  |  | 06-12-21
Spreadsheet: 733621d1621666576-get-remarks-value-base-on-the-code-no-and-unique-no-for-asking-2021-0522
Sheet: Data

NAME | NO. | CODE NO. | MARKS
TEST_001 | 1 | 111-221 | o
TEST_001 | 1 | 111-222 | o
TEST_001 | 1 | 111-223
TEST_001 | 1 | 111-224
TEST_001 | 1 | 111-225
TEST_001 | 2 | 111-225
TEST_001 | 3 | 111-225
TEST_001 | 1 | 111-226
TEST_001 | 2 | 111-226
TEST_001 | 1 | 111-227
TEST_001 | 2 | 111-227
TEST_001 | 3 | 111-227
TEST_001 | 4 | 111-227
TEST_001 | 5 | 111-227
TEST_001 | 6 | 111-227
TEST_001 | 1 | 111-228
TEST_001 | 2 | 111-228
TEST_001 | 3 | 111-228
TEST_002 | 1 | 111-221
TEST_002 | 1 | 111-222
TEST_002 | 1 | 111-223
TEST_002 | 1 | 111-224
TEST_002 | 1 | 111-225 | o
TEST_002 | 2 | 111-225 | x
TEST_002 | 3 | 111-225 | x
TEST_002 | 1 | 111-226 | o
TEST_002 | 2 | 111-226 | o
TEST_002 | 1 | 111-227
TEST_002 | 2 | 111-227
TEST_002 | 3 | 111-227
TEST_002 | 4 | 111-227
TEST_002 | 5 | 111-227
TEST_002 | 6 | 111-227
TEST_002 | 1 | 111-228
TEST_002 | 2 | 111-228
TEST_002 | 3 | 111-228
TEST_003 | 1 | 111-221
TEST_003 | 1 | 111-222
TEST_003 | 1 | 111-223
TEST_003 | 1 | 111-224
TEST_003 | 1 | 111-225
TEST_003 | 2 | 111-225
TEST_003 | 3 | 111-225
TEST_003 | 1 | 111-226
TEST_003 | 2 | 111-226
TEST_003 | 1 | 111-227 | o
TEST_003 | 2 | 111-227 | o
TEST_003 | 3 | 111-227 | x
TEST_003 | 4 | 111-227 | x
TEST_003 | 5 | 111-227 | x
TEST_003 | 6 | 111-227 | o
TEST_003 | 1 | 111-228 | x
TEST_003 | 2 | 111-228 | x
TEST_003 | 3 | 111-228 | o
Spreadsheet: 600315d1543599083-capturing-more-than-one-match-in-an-array-sample-1
Sheet: Sheet1

DATE | DAY | [NAME] | FRANK | JOE | AHMED | AMANDA | EMIL
2019-01-07 00:00:00 |  | DAY (WAREHOUSE) | annual leave | DAY (OFFICE) |  |  | DAY (WAREHOUSE)
2019-01-08 00:00:00 |  | DAY (WAREHOUSE) | annual leave | DAY (OFFICE) |  | DAY (OFFICE)
2019-01-09 00:00:00 |  | DAY (OFFICE) | DAY (WAREHOUSE) | DAY (OFFICE) | sick leave | DAY (WAREHOUSE)
2019-01-10 00:00:00 |  |  |  | DAY (OFFICE) | sick leave | DAY (OFFICE) | DAY (WAREHOUSE)
2019-01-11 00:00:00 |  |  | meeting |  | DAY (WAREHOUSE) |  | DAY (WAREHOUSE)
2019-01-12 00:00:00 |  |  | DAY (WAREHOUSE) |  | DAY (OFFICE)
2019-01-13 00:00:00 |  | DAY (WAREHOUSE) |  | DAY (WAREHOUSE) |  |  | meeting
this will extend for 2 years' worth
STAFF ON-SITE (DAY) |  |  | (BELOW IS THE DATA REQUIRED FROM THE ABOVE ROSTER)
2019-01-07 00:00:00 |  | [NAME] | [NAME]
2019-01-08 00:00:00 |  | [NAME] | [NAME] | Amanda
2019-01-09 00:00:00 |  | [NAME] | [NAME] | [NAME] | Amanda
2019-01-10 00:00:00 |  | [NAME] | Amanda
2019-01-11 00:00:00 |  | Ahmed | Emil
2019-01-12 00:00:00 |  | [NAME] | Ahmed | Emil
2019-01-13 00:00:00 |  | [NAME] | [NAME]
Spreadsheet: 80087d1280313470-report-to-show-duplications-example-duplicate
Sheet: Sheet1

 | Address | Type | [NAME]. | Contractor | Value
 | 1 New Street | [NAME] | 1 | A | 2000
 | 2 New Street | Kitchen | 2 | B | 2400
 | 3 New Street | Bathroom | 3 | C | 1600
 | 1 Old Street | [NAME] | 4 | A | 2000
 | 2 Old Street | Kitchen | 5 | B | 2400
 | 3 Old Street | Bathroom | 6 | C | 1600
 | 4 New Street | [NAME] | 7 | A | 2000
 | 5 New Street | Kitchen | 8 | B | 2400
 | 6 New Street | Bathroom | 9 | C | 1600
 | 5 Old Street | [NAME] | 10 | A | 2000
 | 5 Old Street | Kitchen | 11 | B | 2400
 | 6 Old Street | Bathroom | 12 | C | 1600
 | 1 New Street | [NAME] | 13 | A | 2000
 | 1 New Street | Kitchen | 14 | B | 2400
 | 4 Old Street | Bathroom | 15 | C | 1600
 | 2 Old Street | [NAME] | 16 | A | 2000
 | 3 New Street | Kitchen | 17 | B | 2400
 | 2 New Street | Bathroom | 18 | C | 1600
 | 3 Old Street | [NAME] | 19 | A | 2000
 | 3 Old Street | Bathroom | 17 | A | 1681
Spreadsheet: 756367d1637479951-excel-consistency-check-across-different-row-and-column-values-based-on-common-value-book2
Sheet: Sheet1

Destination | Travel type | Customer id | Customer phone number | customer Address | Customer place | Customer city | Customer country | Status | reserved
 |  | 1234 | a | a | a | a | a
 |  | 1234 | b | a | b | b | b
 |  | 567 | b | b | b | b | b
 |  | 890 | b | b | b | b | b
 |  | 1234 | b | c | b | b | b
 |  | 3321 | b | b | b | b | b
 |  | 1234 | b | c | b | b | b
 |  | 890 | b
Spreadsheet: 872844d1719290732-rawdata-to-generate-graph-testrawdata_to_graph
Sheet: RawDataMemSwap

00:00:00 freemem freeswap
00:20:00 2951184 96822196
00:40:00 2981182 97442457
01:00:00 3002291 97825983
01:20:00 2970774 97446553
01:40:00 2735218 93959317
02:00:00 2532972 90832974
02:20:00 2538462 90914152
02:40:00 2350363 86074993
03:00:01 2479756 88864011
03:20:00 2477401 89304228
03:40:00 2496131 89973290
04:00:00 2505303 90175280
04:20:00 2543135 90775366
04:40:00 2574726 91263036
05:00:00 2515715 90339290
05:20:00 2506949 90206897
05:40:00 2506761 90224474
06:00:00 2502256 90146146
06:20:00 2494187 89950392
06:40:00 2483268 89736753
07:00:01 2493251 89725414
07:20:00 2520707 90134135
07:40:00 2490967 89624723
08:00:00 2490748 89584515
08:20:00 2467003 89196654
08:40:00 2449015 88895312
09:00:00 2449018 88916184
09:20:00 2463263 89152909
Spreadsheet: 373970d1422616804-conditional-formatting-begins-with-certain-number-cf-rules
Sheet: Summary

 |  |  |  | T Accounts Total (Sum Last Row) |  |  |  |  |  |  | "Check" T Accounts (Sum Product Line Items) |  |  |  |  | Data Sheet | Check Data1 |  |  | Data 2 Sheet | Data 2 Sheet |  | Data 2 Sheet | Data 2 Sheet |  |  | Data Sheet 3 | Check Data3 |  |  | Total | Week 5 | Period Balance |  | Week 7 | Settlement Balance
 |  | GL | GL Count | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | Check Total | Check Data1 |  |  | Check Db | s/b Zero |  | [NAME] | s/b Zero |  |  | Check Total | Check Data3
 |  | 213000 | 36 | 3354453.97 | 115.64 | 0 | 0 | 0 | 0 |  | 3354453.97 | 115.64 | 0 | 0 |  | 3354338.33 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 |  |  | 3354338.33 | -2912138.3 | 442200.0299999998 |  | -442200.0099999999 | 0.01999999990221113
 |  | 672000 | 2 | 0 | 3770301.73 | 0 | 0 | 0 | 0 |  | 0 | 3770301.73 | 0 | 0 |  | -3770301.73 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 |  |  | -3770301.73 | 2912138.3 | -858163.4300000002 |  | 858522.5400000002 | 359.109999999986
 |  | 500000 | 45 | 5132897.29 | 8392265.93 | 0 | 0 | 0 | 0 |  | 5132897.29 | 8392265.93 | 0 | 0 |  | -3259368.639999999 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 |  |  | -3259368.64 | 8763.67 | -3250604.97 |  | 0 | -3250604.97