tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116311d1311743083-excel-2007-countifs-to-gather-data-from-multiple-sheets-based-on-multiple-criteria-ratings-of-surveys
Sheet: Recruitment Survey

 | RECRUITMENT FEEDBACK SURVEY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Strongly Disagree
 | HR POC NAME | Date of Submission | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | Q14 | Q15 | Q16 | Q17 | Q18 | Q19 | Q20 | [NAME] | Q22 | Remarks- for open ended data |  | 1
 | [NAME] |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 0 | 2 | 3 | 4 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | 1 | 2 | 3 |  |  | Somewhat Disagree
 | [NAME] |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 0 | 2 | 3 | 4 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | 1 | 2 | 3 |  |  | 2
 | [NAME] |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 0 | 2 | 3 | 4 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | 1 | 2 | 3 |  |  | Somewhat Agree
 | [NAME] |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 0 | 2 | 3 | 4 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | 1 | 2 | 3 |  |  | 3
 | [NAME] |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 0 | 2 | 3 | 4 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | 1 | 2 | 3 |  |  | Strongly Agree
 | [NAME] |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 0 | 2 | 3 | 4 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | 1 | 2 | 3 |  |  | 4
 | [NAME] |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 0 | 2 | 3 | 4 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | 1 | 2 | 3
 | [NAME] |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 0 | 2 | 3 | 4 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | 1 | 2 | 3
 | [NAME] |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 0 | 2 | 3 | 4 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | 1 | 2 | 3
 | [NAME] |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 0 | 2 | 3 | 4 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | 1 | 2 | 3
Spreadsheet: 729819d1619369422-index-and-filter-functions-workaround-to-sort-filter-and-format-within-array-example
Sheet: Source Data 

Risk | Potential | Performance How-Behavior | Performance What-Results | Top Talent | Move time ( Yrs) | Mobile (Y/N) | Successors for this role (Internal and/or External | Readiness of Successor | Gender | Person of Color | Group | Gender / POC
Low | Accelerating | Low | Low | - | Ready Now | Yes |  | Emergency | F | Non-POC | Leadership Team | F/Y
Medium | Achieving | Medium | Medium | Yes | Ready in 1-2 | No |  | Ready Now | M | POC | Top Talent Not on LT | F/N
High | Developing | High | High |  | Ready in 2-3 |  |  | Ready in 1-2 | U | - | Not applicable | F/-
 | Plateauing |  |  |  | Ready 3+ |  |  | Ready in 3-5 | - |  |  | M/Y
 |  |  |  |  |  |  |  |  |  |  |  | M/N
 |  |  |  |  |  |  |  |  |  |  |  | M/-
Spreadsheet: 699286d1602520254-fill-down-ignoring-hidden-rows-fill-down-ignoring-hidden-rows
Sheet: DOE Factors-Levels

 | Design Of Experiments |  | Assumptions |  |  | Number of Runs required |  |  |  | Lookup table | [NAME] | Unit
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -1
 | Factor Name | Factor Letter | Unit | Low Setting | High setting | Controllable? |  |  |  |  |  |  |  | -1
 | Tack |  | 1 |  |  | Y |  |  |  |  |  |  |  | -1
 | Rot |  | ° | 0 | 90 | Y
 | Linear |  | [NAME] |  |  | Y |  |  |  | Lookup table | Hi | Unit
 | Holding pressure |  | [NAME] |  |  | Y |  |  |  |  |  |  |  | 1
 | Face |  | ° |  |  | Y |  |  |  |  |  |  |  | 1
 | Arc |  | [NAME] |  |  | Y |  |  |  |  |  |  |  | 1
 | Cold |  | [NAME]/min | 300 | 15200 | Y |  |  |  |  |  |  |  | 1
 | Pos |  | RPM | 0.2 | 11 | Y |  |  |  |  |  |  |  | 1
 | Weld |  | ° |  |  | Y
 | Control |  | pulses/s | 0.5 | 300 | Y
 | Volt |  | V |  |  | Y
 | Travel |  | [NAME]/min |  |  | Y
 | Jog |  | [NAME]/min |  | 760 | Y
 | Torch |  | [NAME] | 0 | 6 | Y
 | Wire |  | ° | 20 | 45 | Y
 | Humidity |  | °C |  |  | N
 | Temperature |  | °C |  |  | N
 | Design Of Experiments |  | Assumptions |  |  | Number of Runs required
 |  |  | Parts are correct fit and correct thickness
 |  |  | No Joint Misalignment
 | Factor Name | Factor Letter | Unit | Low Setting | High setting | Controllable?
 | Tack |  | 1 | 5 | 6 | Y
C | Rot |  | ° | 0 | 90 | Y
C | Linear |  | [NAME] |  |  | Y
C | Holding pressure |  | [NAME] |  |  | Y
C | Face |  | ° |  |  | Y
C | Arc |  | [NAME] |  |  | Y
 | Cold |  | [NAME]/min | 295 | 15200 | Y
 | Pos |  | RPM | 0.2 | 11 | Y
C | Weld |  | ° |  |  | Y
 | Control |  | pulses/s | 0.5 | 300 | Y
C | Volt |  | V |  |  | Y
C | Travel |  | [NAME]/min | 300 | 500 | Y
C | Jog |  | [NAME]/min |  | 760 | Y
C | Torch |  | [NAME] | 0 | 6 | Y
 | Wire |  | ° | 20 | 45 | Y
C | Humidity |  | °C |  |  | N
C | Temperature |  | °C |  |  | N
C | Torch Standoff distance |  | [NAME]
Spreadsheet: e0990afb-11ca-4a97-a7a1-70f61d24e8f9
Sheet: Sheet1

Colorado Department of XXXXXXXXXXXXXX | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
FY 2010-11 Budget Cycle
FY 2008-09 Divisional Personal Services Detail
(1) Division of _______________
 |  |  | FY 2007-08 |  | FY 2008-09
 |  |  | FTE | Expenditures | FTE | Expenditures |  | Source
 | Appropriated Amount Related to Personal Services |  | 0 | 0 | 0 | 0 |  | Sum of Position and Object Code Reports by line item for the Division (Personal Services only)
 | Allocation of POTS funding to Division |  |  | 0 |  | 0 |  | Schedule 8 allocation of agency totals to Division
 | Total Spending Authority in Division for Personal Services |  | 0 | 0 | 0 | 0 |  | Total
 | Full- and Part-Time Employee Expenditures                                                                           (including [NAME] and Performance-based Pay) |  | 0 | 0 | 0 | 0 |  | CPPS for FTE; COFRS for expenditures / Position and Object Code Reports by line item
 | PERA and Medicare Costs |  |  | 0 |  | 0 |  | COFRS / Position and Object Code Reports by line item
 | State Temporary Staff |  |  | 0 |  | 0 |  | COFRS / Position and Object Code Reports by line item
 | Sick and Annual Leave Payouts |  | 0 | 0 | 0 | 0 |  | CPPS for FTE; COFRS for expenditures / Position and Object Code Reports by line item
 | Contract Services |  |  | 0 |  | 0 |  | COFRS / Position and Object Code Reports by line item
 | Other Expenditures |  |  | 0 |  | 0 |  | COFRS / Position and Object Code Reports by line item
 | Total Temporary, Contract, and Other Expenditures |  | 0 | 0 | 0 | 0 |  | Subtotal
 | POTS Expenditures                                                                           (excluding [NAME] and Performance-based Pay) |  |  | 0 |  | 0 |  | COFRS (1360, 1510, 1610, 1511, 1611, 1512, 1612, 1513, 1613, 1524, 1624, 1525, 1625)
 | Roll Forwards |  |  | 0 |  | 0 |  | COFRS / Position and Object Code Reports by line item
 | Total Expenditures for Division |  | 0 | 0 | 0 | 0 |  | Total
 | Amount Under/(Over) Expended |  | 0 | 0 | 0 | 0 |  | [NAME]
Spreadsheet: mary_fischer__25717__Consolidated of 890 20Q 20R 1572
Sheet: April

Enron Energy Services
MTM Summary
Company 890
 |  |  |  | Beginning |  |  |  | Ending
Date |  | Account MSA/SAP |  | Balance |  | Change |  | Balance
2001-04-01 00:00:00 |  | 1740-310/2106-0000 |  | 50493145 |  |  |  | 36132290
2001-04-01 00:00:00 |  | 1860-310/2510-0000 |  | 587035369 |  |  |  | 728126711
2001-04-01 00:00:00 |  | 1860-330/2510-0100 |  | -55096987 |  |  |  | -102143036
2001-04-01 00:00:00 |  | 1860-320/2510-0200 |  | 831595 |  |  |  | -24387752
2001-04-01 00:00:00 |  | 2420-310/3030-0000 |  | -448393114 |  |  |  | -543156803
2001-04-01 00:00:00 |  | 2530-310/3310-0000 |  | -115116482 |  |  |  | -278732888
 |  |  |  |  |  | Ending
Date |  | Account |  |  |  | Balance
2001-04-01 00:00:00 |  | 4923-999/4200-0000 |  |  |  | 183915004
 |  | Difference
Spreadsheet: 598605d1542625259-formula-used-in-weekly-reduction-of-work-hours-test-workbook-tms-v2
Sheet: SGA

 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
DS Authorized Hours |  |  |  |  |  |  |  |  | 1
DS Billable Hours
[NAME] Authorized |  |  |  |  |  |  |  |  | 1
[NAME]
[NAME]
[NAME]
[NAME]
CSO Authorized |  |  |  |  |  |  |  |  | 11
CSO Billable Hours
CSO Non-Billable Hours
CSO Billable OT
CSO Non-Billable OT
Burn Rate
 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
[NAME] Authorized |  |  |  |  |  |  |  |  | 1
[NAME]
[NAME]
[NAME]
[NAME]
CSO Authorized |  |  |  |  |  |  |  |  | 6.5
CSO Billable Hours
CSO Non-Billable Hours
CSO Billable OT
CSO Non-Billable OT
Burn Rate
 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
[NAME] Authorized |  |  |  |  |  |  |  |  | 1
[NAME]
[NAME]
[NAME]
[NAME]
CSO Authorized |  |  |  |  |  |  |  |  | 12.5
CSO Billable Hours
CSO Non-Billable Hours
CSO Billable OT
CSO Non-Billable OT
Burn Rate
Spreadsheet: 548126d1510880517-barcodes-for-inventory-inventory-test
Sheet: Bin List

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
SA
SB
SC
SD
SE
SF
SG
SH
SI
SJ
SK
SL
SM
SN
SO
SP
SQ
SR
SS
ST
SU
SV
SW
SX
SY
SZ
S1
S2
S3
[NAME]
S5
S6
S7
S8
S9
S10
S11
S12
S13
S14
S15
S16
S17
S18
S19
S20
Spreadsheet: 05fe99ce-2e3e-4653-8480-92c54b45c2f3
Sheet: 2. Key Stats

 |  | FY 2012 Federal Real Property Charts
 |  | Federal Real Property Key Statistics†
 |  |  | FY 2011 |  |  | FY 2012
 |  |  | Owned** | Leased | Total | Owned** | Leased | Total
 | Buildings | Total Number | 312644 | 56489 | 369133 | 306166 | 55152 | 361318
 |  | Total GSF | 2752533221.22 | 556789143.802 | 3309322365.022 | 2755557168.839 | 546169917.58 | 3301727086.419
 |  | Total Annual Operating Costs | 15218985676.046 | 8810308899.262001 | 24029294575.308 | 15776457592.822 | 8805185191.179 | 24581642784.001
 | Structures | Total Number | 448670 | 16965 | 465635 | 468989 | 16877 | 485866
 |  | Total Annual Operating Costs | 7533161529.043 | 396446772.272 | 7929608301.315001 | 7798090158.616 | 429675452.633 | 8227765611.249001
 | Land*** | Total Acres | 32684751.2 | 1545158.791 | 34229909.991 | 42069449.614 | 1576907.048 | 43646356.662
 |  | Total Annual Operating Costs | 128573076.11 | 72673555.95 | 201246632.06 | 156359736.82 | 75176979.862 | 231536716.682
 | AOC | Total Annual Operating Costs (Buildings, Structures, Land) | 22880720281.199 | 9279429227.484001 | 32160149508.683 | 23730907488.258 | 9310037623.674 | 33040945111.932
 |  | † All real property data from the CFO Act agencies required to submit data to the FRPP
 |  | **includes federal government owned, foreign government owned, museum trust, and state government owned
 |  | ***includes federal government owned, foreign government owned, museum trust, state government owned, withdrawn land, and leased.  DOES NOT INCLUDE PUBLIC DOMAIN LAND
Spreadsheet: 679802d1590640998-changing-daily-value-in-cell-test
Sheet: Sheet1

 |  |  |  | daily change
 |  |  |  | 55
 |  | 2020-05-28 00:00:00 | 2020-05-29 00:00:00 | 2020-05-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00
 |  | 55 | 65 | 67 | 89 | 3 | 5 | 7
Spreadsheet: 726604d1617311967-index-indirect-match-function-issue-indirect-invoice-total
Sheet: 48-000046549

Client ID | Client Name | Account | Name | Group Name | Invoice No | Description Total | Charge Type | Random | Random | Random | Random | Random | Random | Random | Random | Random | CCY | Invoice Charge
46547 | Example |  |  |  | 46549 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | USD | 65497.14
Spreadsheet: 811623d1672696702-sales-pace-by-month-sales-pace
Sheet: Sheet1

 |  |  |  | Date
 |  |  |  |  |  |  |  |  | Days Remaining
 |  | Store 1 |  | Unit [NAME] |  | Current Volume |  |  | % To Goal |  | Monthly Pace |  | Units/Week To Goal
 |  |  | Person 1 | 25 |  | 1
 |  |  | Person 2 | 15 |  | 0
 |  |  | Store | 30
 |  | Store 2
 |  |  | Person 1 | 25 |  | 3
 |  |  | Person 2 | 10 |  | 1
 |  |  | Store | 20
Spreadsheet: 494069d1482161146-cant-sum-cells-book1_etaf
Sheet: Sheet1

319756 | STYLIST WEAR & POSITION VERIFICATION | 2 | MC | TM |  |  | 0:12 | 0:00
319755 | T&E 5-6 31XXN PARK BRAKE TENSIONER VERIFICATION & CALIBRATION | 2 | MC | TM |  |  | 1:00 | 0:00
1736 | T&E 1-1 A/C LEAK DETECTOR PER DAY CHECK | 0 | EL | EL |  |  | 0:36 | 0:00
3002 | T&E 10-1 DYNAMIC BALANCER PER SHIFT ELECTRICAL | 2 | EL | EL |  |  | 0:30 | 0:00
318329 | T&E 15-1 ROLL/BRAKE TEST MACHINE #1 - 4 | 2 | EL | EL | TECH [NAME] | TRADESMAN | 0:30 | 0:00
1383 | T&E 15-4 WHEEL ALIGNMENT PER SHIFT ELECTRICAL | 0 | EL | EL |  |  | 0:30 | 0:00
1309 | T&E 1-1 AC FILL PIPING PM | 0 | MC | PF |  |  | 0:06 | 0:00
1309 | T&E 1-1 AC FILL PIPING PM | 0 | MC | PF |  |  | 0:06 | 0:00
1309 | T&E 1-1 AC FILL PIPING PM | 0 | MC | PF |  |  | 0:06 | 0:00
1477 | T&E 10-1 BALANCER DAILY CHECK PIPING | 2 | MC | PF |  |  | 0:12 | 0:00
1477 | T&E 10-1 BALANCER DAILY CHECK PIPING | 2 | MC | PF |  |  | 0:12 | 0:00
1676 | T&E 10-5 TIRE SOAPER PER SHIFT PIPING | 2 | MC | PF |  |  | 0:12 | 0:00
3049 | T&E 10-5 WHEEL SOAPER PER SHIFT PIPING | 2 | MC | PF |  |  | 0:12 | 0:00
1254 | T&E 13-1 RADIATOR FILL DAILY PIPING CHECK | 0 | MC | PF |  |  | 0:12 | 0:00
3129 | T&E 15-10 CASTER / CAMBER DRILL DAILY PIPING | 2 | MC | PF |  |  | 0:12 | 0:00
320428 | APD PORTABLE UNIT INSPECTION | 2 | MC | PF |  |  | 0:18 | 0:00
1487 | T&E 5-3 BRAKE EVAC AND FILL DAILY PIPING | 2 | MC | PF |  |  | 1:00 | 0:00
3102 | T&E 8-2 FUEL FILL SYSTEM DAILY PIPING CHECK | 2 | MC | PF |  |  | 0:12 | 0:00
6002 | CM GENERIC | 2 | MC | TRAC |  |  | 0:00 | 0:00
4122 | (OBS) PPE - GLOVE INSPECTION AND CERTIFICATION REMINDER | 2 | SP | SUPV | ENGINEERING | Engineering Personnel | 2:00 | 0:00
6002 | CM GENERIC | 2 | MC | TM | TECH [NAME] | TRADESMAN | 3:00 | 0:00
Spreadsheet: 875980d1722612539-logging-and-calculating-half-day-absences-in-spreadsheet-dummy-sickpay-halfdays-august-2024-julaboyce-
Sheet: Sheet1

 |  |  |  |  | Startdate | Year service
 |  |  |  |  | 2023-06-01 00:00:00
Name: | Employee |  |  | [NAME] entitlement
Number of working hours | 25.5 |  |  | Start 12 Mnth Period
Number of  Working days per week | 4
Working  days | Monday/Tuesday/Wednesday/Thursday |  |  |  |  |  | Number of weeks Full Pay | Number of weeks half Pay
End Date of last sickness |  |  |  |  |  | Less Than 6 months service | SSP | SSP | 0
No of Sick Days in  12 month Period |  |  |  |  |  | Less than 1 year servcie | 1 | 1 | 0.5
Number of sick [NAME] |  |  |  |  |  | One to two years' service: | 2 | 2 | 1
 |  |  |  |  |  | Two to three years’ service: | 4 | 4 | 2
 |  |  |  |  |  | Three years service and above | 6 | 6 | 3
First Day of Absence | Last Day of Absence | Number of Days off | Reason for Absence | Days of Week off
2024-01-09 00:00:00 | 2024-01-21 00:00:00 |  |  |  |  | Total Days Entitelment
2024-07-29 00:00:00 | 2024-08-01 00:00:00 |  | Half day
2023-07-24 00:00:00 | 2023-07-27 00:00:00
 |  |  |  |  |  | Days Entitlement used
Spreadsheet: 599555d1543190336-list-of-sundays-and-holidays-feste
Sheet: Foglio1

2018-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Giorno | Mese | Data | Ricorrenze
 |  |  |  |  |  |  |  |  |  | 1 | 1 |  | Capodanno
 |  |  |  |  |  |  |  |  |  | 6 | 1 |  | Epifania
 |  |  |  |  |  |  |  |  |  |  |  |  | Pasqua
 |  |  |  |  |  |  |  |  |  |  |  |  | Lunedì d.A
 |  |  |  |  |  |  |  |  |  | 25 | 4 |  | Liberazione
 |  |  |  |  |  |  |  |  |  | 1 | 5 |  | 1°Maggio
 |  |  |  |  |  |  |  |  |  | 2 | 6 |  | Festa Rep.
 |  |  |  |  |  |  |  |  |  | 15 | 8 |  | Ferragosto
 |  |  |  |  |  |  |  |  |  | 1 | 11 |  | Tutti i Santi
 |  |  |  |  |  |  |  |  |  | 8 | 12 |  | Immacol. C.
 |  |  |  |  |  |  |  |  |  | 25 | 12 |  | Natale
 |  |  |  |  |  |  |  |  |  | 26 | 12 |  | S.Stefano
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 10b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 1948002 | 613614 | 873793 | 5898490 | 533622 | 127490 | 385577 | 10380588
Cross-Currency Fixed-Fixed | 61532 | 54180 | 41324 | 240785 | 9605 | 28391 | 31919 | 467736
Cross-Currency Fixed-Float | 137770 | 45461 | 65182 | 332076 | 52513 | 16847 | 648189 | 1298038
TOTAL | 2147304 | 713255 | 980299 | 6471351 | 595740 | 172728 | 1065685 | 12146362
Spreadsheet: 883242d1731795411-data-in-multiple-rows-need-to-add-data-added-to-1-row-data-in-mltiple-rows-need-to-add-data-added-to-1-row
Sheet: Sheet1

 |  | Current data |  |  |  |  |  |  | would like to look like this
Name | Low | high | critical | non critial | date | time | combine |  | Name | Low | high | critical | non critial | date | time | combine | new [NAME] | new column2 | new column3 | new column4 | new column5 | new [NAME] | new column7 | new column8
demo1 |  |  |  |  | x | x | Missing = low |  | demo1 |  |  |  |  | x | x |  | Missing = low | Missing = crital | missing = non critical | Missing = High
demo1 |  |  |  |  | x | x | Missing = crital |  | [NAME] | x | x | x |  | x | x |  | Missing = critical
demo1 |  |  |  |  | x | x | missing = non critical |  | [NAME] |  | x | x | x |  |  |  | Missing = low
demo1 |  |  |  |  | x | x | Missing = High |  | demo4 |  |  |  |  |  |  |  | Missing = low | Missing = crital | missing = non critical | Missing = High | Missing = critical | Missing = date | Missing = Time | Missing = High
[NAME] | x | x | x |  | x | x | Missing = critical |  | demo5 | x | x |  | x | x | x |  | Missing = crital | Missing = date
[NAME] |  | x | x | x |  |  | Missing = low |  | demo6 |  | x | x | x | x | x |  | Missing = low | Missing = Time | missing = non critical
demo4 |  |  |  |  |  |  | Missing = low
demo4 |  |  |  |  |  |  | Missing = crital
demo4 |  |  |  |  |  |  | missing = non critical
demo4 |  |  |  |  |  |  | Missing = High
demo4 |  |  |  |  |  |  | Missing = critical
demo4 |  |  |  |  |  |  | Missing = date
demo4 |  |  |  |  |  |  | Missing = Time
demo4 | x |  | x | x | x | x | Missing = High
demo5 | x | x |  | x | x | x | Missing = crital
demo5 | x | x | x | x |  | x | Missing = date
demo6 |  | x | x | x | x | x | Missing = low
demo6 | x | x | x | x | x |  | Missing = Time
demo6 | x | x | x | x | x | x | missing = non critical
Spreadsheet: 50057d1249470826-a-problem-with-serial-numbers-in-cells-fill
Sheet: Sheet1

name | product | serial
[NAME] | Product A | 00101 | 00101
[NAME] | Product B |  | 00101
[NAME] | Product A |  | 00101
[NAME] | Product B |  | 00101
fed amith | prod 1 | 5678 | 5678
fed amith | prod 2 |  | 5678
fed amith | prod 3 |  | 5678
fed amith | prod 4 |  | 5678
fed amith | prod 5 |  | 5678
fed amith | prod 6 |  | 5678
[NAME] | Product A | 3245 | 3245
[NAME] | Product A
[NAME] | Product A
[NAME] | Product A
[NAME] | Product A
[NAME] | Product A
[NAME] | Product A
Spreadsheet: 3542849f-7213-4450-afdf-1bdb1cb90e44
Sheet: WI

CARA PENGISIAN FORMULIR UPDATE DATABASE PEGAWAI
[NAME]
TAHUN 2013
Field | Kolom | [NAME]
NIP | 1 | Untuk PNS yang NIPnya [NAME], ganti dengan NIP sesuai SK Konversi NIP (lampirkan fotocopy SK Konversi NIP bagi [NAME]CPNSnya sebelum Th. 2009)
GELAR1 | 2 | Bagi PNS yang GELAR DEPANNYA belum tercantum/[NAME], isikan gelar depan  sesuai dengan tingkat pendidikan terakhir (dilampirkan fotocopy Ijazahnya [NAME] Keterangan Penggunaan Gelar untuk yang Ijin belajar)
NAMA | 3 | Bagi PNS yang [NAME], harap dilampirkan fotocopy SK CPNS
GELAR2 | 4 | Bagi PNS yang GELAR BELAKANGNNYA belum tercantum/[NAME], isikan gelar depan  sesuai dengan tingkat pendidikan terakhir (dilampirkan fotocopy Ijazahnya [NAME] Keterangan Penggunaan Gelar untuk yang Ijin belajar)
UNIT KERJA1 | 5 | Bagi PNS yang tidak sesuai dengan UNIT KERJA1, langsung diganti dengan unit kerja1 terbaru
UNIT KERJA2 | 6 | Bagi PNS yang tidak sesuai dengan UNIT KERJA2, langsung diganti dengan unit kerja2 terbaru
ESELON | 7 | Bagi PNS struktural [NAME], ganti dengan [NAME] (lampirkan fotocopy SK Pelantikan)
[NAME] | 8 | Bagi PNS struktural [NAME] [NAME], ganti dengan nama [NAME] (lampirkan fotocopy SK Pelantikan), untuk staf abaikan.
NAMA JABATAN FUNGSIONAL | 9 | Bagi PNS fungsional [NAME] jabatan fungsional tidak sesuai, ganti dengan nama [NAME] sesuai
[NAME] | 10 | Abaikan
[NAME] | 11 | Bagi PNS yang keterangan jabatannya salah, [NAME] [NAME] [NAME] ([NAME])
GOL | 12 | Bagi PNS [NAME], [NAME] dengan golongan terbaru (dilampirkan fotocopy SK Kenaikan Pangkat)
TINGKAT PENDIDIKAN AKHIR | 13 | Bagi PNS yang tingkat pendidikan [NAME], [NAME] [NAME] terakhir (dilampirkan fotocopy SK Ijazah)
TGL IJAZAH | 14 | Bila tanggal ijasah tidak sesuai, isikan tanggal ijazah dengan tanggal yang tertera pada [NAME] bersangkutan
[NAME] STRUKTURAL | 15 | Bila kolom nama diklat struktural [NAME] atau [NAME], isikan nama diklat struktural [NAME] (lampirkan fotocopy sertifikat diklat struktural terakhir)
TANGGAL SERTIFIKAT | 16 | Bila tanggal sertifikat tidak sesuai, isikan tanggal sertifikat dengan tanggal yang tertera pada [NAME]
Pengiriman data [NAME], jadi dari data [NAME] difilter perlokasi.
Perubahan [NAME] dengan huruf warna [NAME].
[NAME] personel yg pensiun, maka satu baris nama tersebut di [NAME].
[NAME] personel yg belum tercatat, silahkan tulis [NAME] warna [NAME] paling bawah.
Spreadsheet: 841322d1693503971-find-most-occuring-value-and-sort-the-top-3-book2
Sheet: Sheet1

WO Description | Start Date | Finish date | Total Downtime | Work Type
BRAKE SYSTEM FIXED | 2022-04-15 10:00:00 | 2022-04-15 13:00:00 | 3 | BD |  |  |  | 3
SAFETY INSPECTION | 2022-04-18 08:10:00 | 2022-04-18 09:10:00 | 0.9999999999417923 | INS |  |  |  | 6
SAFETY INSPECTION | 2022-05-02 10:30:00 | 2022-05-02 11:30:00 | 0.9999999999417923 | INS
HEAD [NAME] REPLACED | 2022-05-04 15:05:00 | 2022-05-04 15:43:00 | 0.6333333334769122 | BD
REAR BRAKE FIXED | 2022-05-09 13:00:00 | 2022-05-09 16:00:00 | 3 | BD
SAFETY INSPECTION &REAR BRAKE REPAIRED | 2022-05-21 11:00:00 | 2022-05-21 14:00:00 | 3 | INS |  |  |  | Below is the result I am trying to have based on the result of cell I4
INSPECTION+BRAKE SYSTEM REPAIR | 2022-06-13 07:50:14 | 2022-06-13 11:50:14 | 3.999999999941792 | INS
SAFETY INSPECTION | 2022-09-05 09:00:00 | 2022-09-05 10:00:00 | 0.9999999999417923 | INS |  |  | INS | INSPECTION+BRAKE SYSTEM REPAIR | 3.999999999941792
SAFETY INSPECTION | 2022-09-19 10:00:00 | 2022-09-19 11:30:00 | 1.5 | INS |  |  | INS | SAFETY INSPECTION &REAR BRAKE REPAIRED | 3
 |  |  |  |  |  |  | INS | SAFETY INSPECTION | 1.5
Spreadsheet: 484236d1476185149-updating-holiday-planner-for-this-year-proposed-holiday-planner-based-on-2015-16
Sheet: DEC

 |  | Days
1
 |  | Entitlement | Taken | Remaining
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
Entering '1' in the relevant row/column represents 0.5 of a day