tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 766378d1643879408-risk-assessment-with-multiple-likelihood-and-consequence-inputs-risk-assessment-templatev2
Sheet: Risk Register

 |  |  | RISK ASSESSSMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RISK MANAGEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RISK MONITORING
Category | Item | Risk Title | Causes Triggers Indicators | Impacts Consequences | Existing Controls |  | Operational Safety | Financial Loss | Operational Capability | WHS | Governance | Stakeholders | Environment | Highest Likelihood | Operational Safety | Financial Loss | Operational Capability | WHS | Governance | Stakeholders | Environment | Highest Consequence | Rating |  | Additional Controls Required/Implemented | Operational Safety | Financial Loss | Operational Capability | WHS | Governance | Stakeholders | Environment | Highest Likelihood | Operational Safety | Financial Loss | Operational Capability | WHS | Governance | Stakeholders | Environment | Highest Consequence | New Rating | Risk Owner | Due Date
Ref. |  | Risk Description |  |  |  |  | Likelihood |  |  |  |  |  |  |  | Consequence |  |  |  |  |  |  |  |  |  |  | Likelihood |  |  |  |  |  |  |  | Consequence
A | Due Diligence
A | 1 | RISK EXAMPLE |  |  |  |  | Almost Certain | Likely | Remote | Possible | [NAME] |  |  |  | Catastrophic |  | Major |  | Minor | Moderate |  |  |  |  |  | Almost Certain | Likely | Possible | [NAME] | Remote |  |  |  | Catastrophic |  | Moderate | Minor | Insignificant
Spreadsheet: 48733d1248010693-updating-a-master-spreadsheet-from-other-spreadsheets-unit2
Sheet: Sheet1

 | P1 | P2 | P3 | P4 | P5 | P6 | M1 | M2 | M3 | D1 | D2 | D3 |  | Result
[NAME] | x | x | x | x |  | x | x | x | x | x | x | x |  | Fail
Pie Face | x | x | x | x |  | x | x | x | x | x | x | x |  | Fail
Rik | x | x | x | x |  | x | x | x | x | x | x | x |  | Fail
Spreadsheet: robin_rodrigue__33265__CAN$1100
Sheet: NewDeals

Enron Canada Corp.
 | West Term
 | EOL Book
 |  | December new deals
 |  |  | Price (733713) |  |  | 1155365
 |  |  | Index |  |  | 0
 |  |  | Annuity |  |  | 0
 |  | Winter new deals
 |  |  | Price (733710) |  |  | 185455
 |  |  | Index |  |  | 0
 |  | Houston FX |  |  |  |  | 0
 |  | Remainder |  |  |  |  | 0
 |  |  | Price
 |  |  | Index |  |  |  | 0
 |  |  | Other |  |  |  | 0
 |  |  | Other |  |  |  | 0
 | West Term
 |  |  | Price |  |  | 920404
 |  |  | Index |  |  | -990
 |  |  |  |  |  |  | 0
 |  |  | Houston FX |  |  |  | 0
 |  |  | Other origination adjustment |  |  |  | -1175
 |  |  | Other |  |  |  | 0
 |  |  | Other |  |  |  | 0
 |  |  |  |  |  |  | 0
 | TOTAL NEW DEALS - EOL and WEST TERM
 |  |  |  |  |  | Check
 |  |  |  |  |  |  |  | EOL
 |  |  |  |  |  | Total new deals |  | 1289192
 |  |  |  |  |  | Index |  | 0
 |  |  |  |  |  | Price FX deals (options or EOL)
Spreadsheet: 675079d1588152329-populating-a-straight-line-depreciation-annual-table-expense-schedule-simple-sl-depreciation-schedule
Sheet: Sheet1

Simple Straight Line Depreciation Schedule
Account: | Home Improvement's
Purchase Date | Item Desc. | Cost | Yr.'s Service | End Date | Salvage Value | Net SL Depreciation | Days of Service | Daily Charge | 1st Year Deprc | [NAME]. Deprc |  | Year | AC Unit | Solar System | Home Remodel | Fence Replacement | Total
2018-03-24 00:00:00 | AC Unit | 10640 | 15 |  | 0
2019-07-10 00:00:00 | Solar System | 29408.4 | 20 |  | 0
2019-07-25 00:00:00 | Home Remodel | 7885.51 | 10 |  | 0
2020-04-22 00:00:00 | Fence Replacement | 3760 | 15 |  | 0
Spreadsheet: 806513d1669358823-match-partial-or-complete-text-and-match-in-another-column-to-extract-index-value-help-4-ans
Sheet: INDEX-MATCH1

 |  |  | need to match partial title and chn and bring value from index column
 | Employee |  |  | =INDEX(F$7:F$11,MATCH(TRUE,ISNUMBER(SEARCH(B$6:[NAME]))
 | title | chn | index value | current formula I have | lookup data
 | [NAME] |  |  |  | index value | chn
 | Siyan |  |  |  | Kaisi | AAA
 | Farq E |  |  |  | siyani | GGG
 | Habs Ep |  |  |  | farq | AAA
 | magar |  |  |  | habs | AAA
 | [NAME] |  |  |  | agar | GGG
 | [NAME]
 | [NAME]
Spreadsheet: 164073d1340640042-lookup-or-if-formula-when-cell-is-between-a-range-ship-weight-example
Sheet: Sheet2

Weight | Ship Cost
0 | NA
0.06 | 2.95
0.13 | 2.95
0.19 | 2.95
0.25 | 2.95
0.31 | 3.95
0.38 | 3.95
0.44 | 3.95
0.5 | 3.95
0.56 | 4.95
0.63 | 4.95
0.69 | 4.95
0.75 | 4.95
0.81 | 5.95
0.88 | 5.95
0.99 | 5.95
1 | 6.9316
2 | 7.69184
3 | 8.161399999999999
4 | 8.69804
5 | 9.04462
6 | 9.25704
7 | 9.49182
8 | 9.670700000000002
9 | 9.87194
Spreadsheet: 713638d1610852975-using-averageif-statement-with-or-roundavgifor-help-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | PACE | FINAL
 |  | RACE # | F | Distance | Conditions |  | PACE # | FINAL # | PACE PAR | FINAL PAR | DIFFERENCE | DIFFERENCE
 |  | 1 | f | 6f | 20K |  | 99 | 98 | 96 | 96 | 3 | 2
 |  | 2 | f | 6f | 16KN3L |  | 98 | 92 | 100 | 100 | -2 | -8
 |  | 3 | f | 6f | sMSW |  | 92 | 101 | 102 | 102 | -10 | -1
 |  | 4 | 0 | 5.5 | 6250 |  | 101 | 103 | 98 | 98 | 3 | 5
 |  | 5 | 0 | 1m | [NAME] |  | 103 | 112 | 96 | 96 | 7 | 16
 |  | 6 | 0 | 1.0625 | AO502X |  | 112 | 108 | 101 | 101 | 11 | 7
 |  | 7 | f | 1.0625 | MSW |  | 108 | 106 | 106 | 106 | 2 | 0
 |  | 8 | 0 | 5.5 | Als10 |  | 106 | 107 | 101 | 101 | 5 | 6
 |  | 9 | 0 | 1m | 8000 |  | 107 | 97 | 102 | 102 | 5 | -5
 |  | 10
 |  | 11
 |  | 12
 |  |  |  |  |  |  |  |  |  | SPRINT PACE VARIANT | -3 |  | Average | -0.2 | -0.2
 |  |  |  |  |  |  |  |  |  | SPRINT FINAL VARIANT | -2
 |  |  |  |  |  |  |  |  |  | ROUTE PACE VARIANT
 |  |  |  |  |  |  |  |  |  | ROUTE FINAL VARIANT
Spreadsheet: 216036d1361564384-permutations-3-columns-permuation-sheet
Sheet: Sheet1

1
Cum: | 64 | 16 | 4
Count: | 4 | 4 | 4
 | Item1 | Item2 | Item3
 | HL1 | DL1 | DL1.1
 | HL2 | DL2 | DL2.1
 | HL3 | DL3 | DL3.1
 | HL4 | DL4 | DL4.1
# | Permutations
1 | HL1 | DL1 | DL1.1
2 | HL1 | DL1 | DL2.1
3 | HL1 | DL1 | DL3.1
4 | HL1 | DL1 | DL4.1
5 | HL1 | DL2 | DL1.1
6 | HL1 | DL2 | DL2.1
7 | HL1 | DL2 | DL3.1
8 | HL1 | DL2 | DL4.1
9 | HL1 | DL3 | DL1.1
10 | HL1 | DL3 | DL2.1
11 | HL1 | DL3 | DL3.1
12 | HL1 | DL3 | DL4.1
13 | HL1 | DL4 | DL1.1
14 | HL1 | DL4 | DL2.1
15 | HL1 | DL4 | DL3.1
16 | HL1 | DL4 | DL4.1
17 | HL2 | DL1 | DL1.1
18 | HL2 | DL1 | DL2.1
19 | HL2 | DL1 | DL3.1
20 | HL2 | DL1 | DL4.1
21 | HL2 | DL2 | DL1.1
22 | HL2 | DL2 | DL2.1
23 | HL2 | DL2 | DL3.1
24 | HL2 | DL2 | DL4.1
25 | HL2 | DL3 | DL1.1
26 | HL2 | DL3 | DL2.1
27 | HL2 | DL3 | DL3.1
28 | HL2 | DL3 | DL4.1
29 | HL2 | DL4 | DL1.1
30 | HL2 | DL4 | DL2.1
31 | HL2 | DL4 | DL3.1
32 | HL2 | DL4 | DL4.1
33 | HL3 | DL1 | DL1.1
34 | HL3 | DL1 | DL2.1
35 | HL3 | DL1 | DL3.1
36 | HL3 | DL1 | DL4.1
37 | HL3 | DL2 | DL1.1
38 | HL3 | DL2 | DL2.1
39 | HL3 | DL2 | DL3.1
40 | HL3 | DL2 | DL4.1
41 | HL3 | DL3 | DL1.1
42 | HL3 | DL3 | DL2.1
43 | HL3 | DL3 | DL3.1
44 | HL3 | DL3 | DL4.1
45 | HL3 | DL4 | DL1.1
46 | HL3 | DL4 | DL2.1
47 | HL3 | DL4 | DL3.1
48 | HL3 | DL4 | DL4.1
49 | HL4 | DL1 | DL1.1
50 | HL4 | DL1 | DL2.1
51 | HL4 | DL1 | DL3.1
52 | HL4 | DL1 | DL4.1
53 | HL4 | DL2 | DL1.1
54 | HL4 | DL2 | DL2.1
55 | HL4 | DL2 | DL3.1
56 | HL4 | DL2 | DL4.1
57 | HL4 | DL3 | DL1.1
58 | HL4 | DL3 | DL2.1
59 | HL4 | DL3 | DL3.1
60 | HL4 | DL3 | DL4.1
61 | HL4 | DL4 | DL1.1
62 | HL4 | DL4 | DL2.1
63 | HL4 | DL4 | DL3.1
64 | HL4 | DL4 | DL4.1
Spreadsheet: 845449d1696961251-calculating-total-sum-of-item-within-a-date-range-gites
Sheet: Contrat

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Entre nom du client | 4 Régis Legoff
 |  |  |  |  | CONTRAT DE LOCATION
Entre le propriétaire |  |  |  |  | Et le locataire
Le Pressoir, 30 bis avenue [NAME], |  |  |  |  |  | Nom :
34450, Vias |  |  |  |  |  | E-Mail :
E-Mail : [EMAIL] |  |  |  |  |  | Tel :
Web : www.giteslepressoir.com |  |  |  |  |  | Nbre d'adultes : |  |  |  | Nbre d'enfants :
Pour la location
No. et nom du gite : |  |  |  |  |  | Surface : |  | m² |  | Nbre de chambres :
[NAME] : | 3 clés |  |  |  |  | Nombre de lits : | 2 pers : | 2 |  | 1 pers :
Adresse complète : | 28 avenue [NAME], 34450, Vias |  |  |  |  | [NAME] |  | personnes
Tél : | 06 87 25 35 06 - Sébastien
 | 06 18 26 14 91 - Iain |  |  |  | Pour votre confort, tous les draps sont fournis
 | 06 88 36 31 97 - Vanessa
Le propriétaire loue :
Du : |  | à | 14 | heures - au |  | à | 10 | heures
Pour un montant total de |  |  |  | € net pour l'ensemble du séjour, charges comprises.
Services annexes en option, à régler sur place (à cocher [NAME]):
 | Linge de toilette |  | 5 | [NAME] |  | [NAME] :
 | Ménage classique |  | 30
 | Ménage intensif |  | 60
Attention, si aucune option ménage n'est prise, le gîte doit être restitué dans l'état identique de votre arrivée (Article 5).
Taxe de séjour perçue pour le compte de la commune en supplement : 1 € /jour/[NAME] ans, à régler à votre arrivée
Cette location prendra effet si je reçois à mon adresse avant le
- Un exemplaire du présent contrat daté et signé avec la mention "[NAME] et approuvé",
- Un acompte [NAME] |  |  |  |  | (25%)
 |  |  |  | Et avant le
- Le solde de la location [NAME] montant de |  |  |  |  | (75%)
à régler par:
 | Chèque libellé à [NAME] |  |  |  | Chèques vacances |  |  |  | Chèques vacances Connect
 | Virement  bancaire |  |  | IBAN - FR76   1350   6100   0085   1178   1526   407 |  |  |  |  | BIC - AGRIFRPP835
Au-delà de cette date, cette proposition sera annulée et [NAME] location à ma convenance.
Le présent contrat est établi en deux exemplaires. |  |  |  |  |  |  |  |  |  |  | J'ai pris connaissance des condition générales de location précisées au verso
Le |  | à | Vias |  |  | Le |  |  | à
Le Propriétaire |  |  |  |  |  | Le Locatiare
Spreadsheet: 783165d1654620848-conditional-formatting-based-on-a-list-eg-file
Sheet: Sheet1

 |  |  | data validation - indirect(C6) |  |  |  |  |  |  |  |  |  |  |  | For reference
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product | Min Price
 |  | Specified Product | Colour | Unit Price |  |  |  |  |  |  |  |  |  |  | Pen | 0.29
 |  | Pencil |  | 0.28 | << how do I get this to highlight red if lower than column Q? |  |  |  |  |  |  |  |  |  | Pencil | 0.3
 |  | Pencil |  | 0.29 |  |  |  |  |  |  |  |  |  |  | Sharpener | 1
 |  | Sharpener | Red | 0.99 |  |  |  |  |  |  |  |  |  |  | Notepad | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Defined names in [NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pen | Pencil | Sharpener | Notepad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red | HB | Yellow | Big
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blue | 2B | Red | Medium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pink |  | Green | Small
Spreadsheet: 268211d1380504510-conditional-formatting-example
Sheet: Sheet1

Date of Arrival | Reviewer | Completion Date | By When | [NAME]
2013-07-31 00:00:00 | [NAME] | 2013-08-06 00:00:00 | 2013-08-14 00:00:00 | 2013-08-08 00:00:00
2013-07-31 00:00:00 | [NAME] | 2013-08-06 00:00:00 | 2013-08-13 00:00:00 | 2013-08-06 00:00:00
2013-07-30 00:00:00 | [NAME] | 2013-08-07 00:00:00 | 2013-08-14 00:00:00 | 2013-08-08 00:00:00
2013-08-02 00:00:00 | [NAME], Safety, Maint | 2013-08-26 00:00:00 | 2013-08-16 00:00:00 | 2013-08-26 00:00:00
2013-07-31 00:00:00 | [NAME] | 2013-08-10 00:00:00 | 2013-08-14 00:00:00 | 2013-08-14 00:00:00
2013-08-19 00:00:00 | [NAME] | 2013-08-31 00:00:00 | 2013-09-02 00:00:00 | 2013-08-31 00:00:00
2013-08-19 00:00:00 | [NAME] | 2013-08-31 00:00:00 | 2013-09-02 00:00:00 | 2013-08-31 00:00:00
2013-08-19 00:00:00 | Shane Dunn | 2013-08-29 00:00:00 | 2013-09-02 00:00:00 | 2013-08-29 00:00:00
2013-08-21 00:00:00 | [NAME] | 2013-09-06 00:00:00 | 2013-09-04 00:00:00 | 2013-09-06 00:00:00
2013-08-20 00:00:00 | [NAME] | 2013-09-02 00:00:00 | 2013-09-02 00:00:00 | 2013-09-02 00:00:00
2013-09-02 00:00:00 | [NAME] | 2013-09-16 00:00:00 | 2013-09-17 00:00:00 | 2013-09-16 00:00:00
2013-09-16 00:00:00 | [NAME] |  | 2013-10-10 00:00:00
Spreadsheet: 823682d1680090207-sumif-formula-to-calculate-cells-in-between-sheets-based-on-cell-dropdown-r-and-ft-template-2-
Sheet: Res 2024

 | RESOURCE TRACKER - YYYY
 | Date | Forecast Days (At Strategise/Shape) | Forecast Days (At Initiate) | Change Requests |  | TOTALS
 |  |  |  | Reference | Days
 | TOTALS
 | RESOURCES |  |  |  |  |  | MONTHLY ALLOCATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
 | Name | Business Area | [NAME] | Resource Requested Until | Resource Confirmed Until | Unit Amount | 2024-01-01 00:00:00 |  | 2024-02-01 00:00:00 |  | 2024-03-01 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-05-01 00:00:00 |  | 2024-06-01 00:00:00 |  | 2024-07-01 00:00:00 |  | 2024-08-01 00:00:00 |  | 2024-09-01 00:00:00 |  | 2024-10-01 00:00:00 |  | 2024-11-01 00:00:00 |  | 2024-12-01 00:00:00
 |  |  |  |  |  |  | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | TOTAL FORECAST | TOTAL FORECAST  TO DATE | TOTAL ACTUALS | TOTAL ACTUALS COST | [NAME]
 |  |  | BA Team Managers | JUN | APR | 500 | 2 | 1.2 | 0.5 | 0.7 | 2 | 2.4 | 1.25 | 0.4 | 1 |  | 1 |  | 1
 |  |  | BI Life |  |  |  | 1 | 1.3 | 1 | 1.3 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Automation test |  |  |  | 2 | 2.4 | 1 | 1.2 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | BillingCenter |  |  |  | 1 | 1.3 | 1 | 1.3 | 0.5 | 0.7 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Project Manager |  |  |  | 1 | 1.2 | 2 | 2.4 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | MI Tester |  |  |  | 1 | 1.3 | 1 | 1.3 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Technical Service Owner |  |  |  | 1 | 1.2 | 0.5 | 0.7 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | MDM |  |  |  | 1 | 1.3 | 1 | 1.3 | 0.5 | 0.7 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Print ISIS Papyrus |  |  |  | 0.5 | 0.7 | 1 | 1.2 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Test WSL |  |  |  | 1 | 1.3 | 0.5 | 0.7 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 | TOTALS DAYS
 | TOTALS IN £s
Spreadsheet: 221296d1363457101-need-to-find-text-and-output-corresponding-number-sample-workbook
Sheet: Sheet1

 | Expected Opponent Points |  | Expected Opponent Points |  | Opponent
a Manchester United | 0.2142857142857143 | v Manchester United | 0.5714285714285714 |  | a West Brom
a Manchester City | 0.4285714285714285 | v Manchester City | 0.7857142857142857 |  | v. Manchester City
a Tottenham | 0.7142857142857143 | v Tottenham | 1.133333333333333 |  | v. Arsenal
a Chelsea | 0.7142857142857143 | v Chelsea | 1.071428571428571 |  | a Sunderland
a Arsenal | 0.6428571428571429 | v Arsenal | 1.214285714285714 |  | v. [NAME]
a Liverpool | 0.8 | v Liverpool | 1.285714285714286 |  | a Norwich
a Everton | 0.6428571428571429 | [NAME] | 1.285714285714286 |  | v. Stoke
a West Brom | 0.9333333333333333 | v West Brom | 1.857142857142857 |  | v. Reading
a Swansea | 0.8571428571428571 | v Swansea | 1.666666666666667 |  | a Everton
a Fulham | 1.285714285714286 | v Fulham | 1.714285714285714 |  | v. Newcastle
a Stoke | 0.8571428571428571 | v Stoke | 2 |  | a Chelsea
a West Ham | 1.142857142857143 | v West Ham | 2.071428571428572 |  | v. [NAME]
a Newcastle | 1.266666666666667 | v Newcastle | 2.071428571428572 |  | a Swansea
a Norwich | 1 | [NAME] | 1.928571428571429 |  | a Tottenham
a Sunderland | 1.428571428571429 | v Sunderland | 1.866666666666667 |  | v. Southampton
a Southampton | 1.428571428571429 | v Southampton | 1.933333333333333 |  | a West Ham
a Aston Villa | 1.785714285714286 | v Aston Villa | 1.733333333333333 |  | v. [NAME]
a [NAME] | 2 | v [NAME] | 1.857142857142857 |  | v. Fulham
a Reading | 1.4 | v Reading | 2.5 |  | a Stoke
a QPR | 1.666666666666667 | v QPR | 2 |  | a QPR
Spreadsheet: 823113d1679715637-summarizing-a-workbook-lego-replacement-parts
Sheet: Set # 7647

Checked | Qty | Part# | Colour | Description
 | 1 | 7647stk01 |  | Sticker sheet
 | 1 | 4514845 | Black | Plate 1 x 12
 | 1 | 4520863 | Green | Wave Rounded Straight with Bar End and [NAME] (Castle Dragon Flame / Seaweed / Water)
 | 3 | 4114505 | [NAME] | Rock 1 x 1 Jewel 24 Facet
Spreadsheet: 847071d1698163451-reorganizing-two-columns-to-have-comma-separated-values-be-transposed-instead-sample-to-organize-data
Sheet: Sheet1

Starting Point |  |  |  | Needed End Result |  |  | Column1 | Value
Column1 | Column2 |  |  | ABC-02 | BRQ-3 |  | ABC-02 | BRQ-3
ABC-02 | BRQ-3,BRQ-1,BRQ-55 |  |  | ABC-02 | BRQ-1 |  | ABC-02 | BRQ-1
ABC-03 | BRQ-2 |  |  | ABC-02 | BRQ-55 |  | ABC-02 | BRQ-55
ABC-04 | [NAME], BRQ-11 |  |  | ABC-03 | BRQ-2 |  | ABC-03 | BRQ-2
 |  |  |  | ABC-04 | [NAME] |  | ABC-04 | [NAME]
 |  |  |  | ABC-04 | BRQ-11 |  | ABC-04 | BRQ-11
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
Sheet: 02 March 20 - 07 March 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-03-02 00:00:00 | 2020-03-03 00:00:00 | 2020-03-04 00:00:00 | 2020-03-05 00:00:00 | 2020-03-06 00:00:00 | 2020-03-07 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 02/03/2020 - 07/03/2020
Dameon | ✓ | AWAY | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | AWAY | AWAY |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Nathan |  | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Nathan | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Tyson | ✓
Will | ✓ | ✓ | AWAY | AWAY | AWAY |  |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | ✓ | AWAY | ✓ | ✓ |  |  | 1 |  |  | ✓
 | ✓ | ✓ | ✓ | ✓ | AWAY |  |  | 1 |  |  | ✓
 | AWAY | ✓ | AWAY | ✓ | ✓ |  |  | 1 |  |  | ✓
Edge Protection [NAME] |  |  | 02/03/2020 - 07/03/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 02/03/2020 - 07/03/2020
8 Cable Street |  |  | Spoke to [NAME] - he said he will complete when he goes there Monday |  |  |  |  |  |  | Dameon | ✓
Bascik |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
Canterbury Linen Services |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | ✓
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ✓
 |  |  |  |  |  |  |  |  |  |  | ✓
 |  |  |  |  |  |  |  |  |  |  | ✓
Spreadsheet: 782359d1654002100-determine-in-which-month-sample-data-will-pass-limit-based-on-monthly-average-sample-data
Sheet: sample data

ID | Minimum of Start Date | Sub Item End Date | % Plan Limit Used | Apr Total | Limit | [NAME] | Feb Total | Jan Total
name1 | 2020-12-22 00:00:00 | 2023-12-21 00:00:00 |  | 73739491.24 | 200000000 | 68512823.37 | 63266824.26 | 58987145.31
[NAME] | 2022-01-01 00:00:00 | 2025-12-31 00:00:00 |  | 5159467.67 | 90000000 | 3801557.75 | 2606521.21 | 5813334.08
name3 | 2021-09-13 00:00:00 | 2022-09-12 00:00:00 |  | 2043229.1 | 2500000 | 1770563.2 | 1494093.83 | 1231223.69
name4 | 2021-06-22 00:00:00 | 2022-06-21 00:00:00 |  | 78748.03 | 150000 | 38826.14 | 32646.76 | 32646.76
name5 | 2021-05-24 00:00:00 | 2022-05-23 00:00:00 |  | 48331029.8 | 41666666.7 | 44803503.51 | 37910673 | 32728463.08
Question | In which month will ID (name1, etc) pass the Limit based on monthly average usage
Question 2: Identify if it will be past the Sub item end date
Spreadsheet: af388265-b83f-4c93-ae65-541a9b31491b
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 12/10/2013 12:28:54 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
[NAME] | 56811 | 56811
Steele | 848 | 848
Traill | 3411 | 3411
TOTAL | 61070 | 61070
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 796923d1663628716-count-with-both-column-and-row-criteria-inventory-abc-example
Sheet: Sheet1

 | Irrelevant | Previous | Previous | Previous | Previous | Previous | Previous | Last | Last | Last | Last | Last | Last
Item Code | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00
ABC | 0 | 0 | 0 | 360 | 466 | 315 | 194 | 373 | 348 | 305 | 354 | 309 | 260
DEF | 229 | 188 | 228 | 230 | 264 | 127 | 151 | 196 | 271 | 207 | 244 | 213 | 221
GHI | 263 | 166 | 179 | 217 | 248 | 217 | 105 | 124 | 0 | 0 | 0 | 0 | 0
JKL | 238 | 190 | 208 | 226 | 266 | 171 | 143 | 215 | 256 | 169 | 209 | 199 | 175
MNO | 184 | 134 | 159 | 162 | 214 | 85 | 105 | 0 | 0 | 0 | 0 | 0 | 0
PQR | 235 | 154 | 178 | 217 | 182 | 0 | 114 | 169 | 183 | 0 | 0 | 174 | 194
STU | 191 | 124 | 0 | 0 | 0 | 128 | 110 | 172 | 168 | 0 | 203 | 175 | 169
Expected answers:
 | Last | Previous
ABC | 6 | 4
DEF | 6 | 6
GHI | 1 | 6
JKL | 6 | 6
MNO | 0 | 6
PQR | 4 | 5
STU | 5 | 3
Spreadsheet: 35359d1232976760-copying-hyperlinks-december-2008-excel-forum-daily-accts
Sheet: 4

 |  |  |  |  |  | 4
Total Money in the accounts
at the beginning of  23 Jan.  2009
Name of Company | Money X | Money Y | Total
Вагриус | 985.4199999999983 | 0 | 985.4199999999983 |  |  | B17 | B134 | B16 |  | C17 | C134 | C16
Вагриус книги | 61238.7 | 0 | 61238.7 |  |  | B18 | B150 | B32 |  | C18 | C150 | C32
Вагриус правда | 6124.930000000008 | 0 | 6124.930000000008 |  |  | B19 | B166 | B48 |  | C19 | C166 | C48
Вагриус минус | 628.08 | 0 | 628.08 |  |  | [NAME] | B182 | B64 |  | C20 | C182 | C64
Плюс-минус | 2982.36 | 0 | 2982.36 |  |  | B21 | B198 | B80 |  | C21 | C198 | C80
Издательство Вагриус | 444.69 | 0 | 444.69 |  |  | B22 | B114 | [NAME] |  | C22 | C114 | C96
Вагриус плюс-минус | 0 | 0 | 0 |  |  | B23 | B230 | B112 |  | C23 | C230 | C112
Grand Total | 72404.18000000001 | 0 | 72404.18000000001
Spreadsheet: 02ab93e7-6c8d-4089-9af7-54c7a9ee5f02
Sheet: Number SErved

 | IDHW, DBH, Region 1 | IDHW, DBH, Region 2 | IDHW, DBH, Region 3 | IDHW, DBH, Region 4 | IDHW, DBH, Region 5 | IDHW, DBH, Region 6 | IDHW, DBH, Region 7 | Statewide Month Totals
AMH Clients Served July | 1636 | 1409 | 2683 | 2673 | 1250 | 1514 | 3126 | 14291
CMH Clients Served July | 64 | 67 | 70 | 121 | 45 | 54 | 165
19 2524 Assessments | 3 | 1 | 19 | 22 | 10 | 11 | 15 | 81
Spreadsheet: 86837d1286809836-how-can-i-compare-graph-data-loan-graph
Sheet: Sheet1

 | Title | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00
 | Total Loan Portfolio | 2353162.49 | 2408010.2 | 2438359.59 | 2344688 | 2269460 | 2214212.2 | 2134904.14 | 2111438.11 | 2096520.6 | 2097126.89 | 2107095.97 | 2054523.21
 | Title | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00
 | Total Loan Portfolio | 2046569.94 | 2100778.67 | 2114325.16 | 1999116.75 | 1959855.86 | 1899040.64 | 1876900.12 | 1855027.57 | 1830799.83 | 1843748.3 | 1798441.43 | 1767807.69