tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 793701d1661658733-index-match-function-using-named-table-index-match-formula
Sheet: Tracking

Task | Budgeted hrs | Budgeted Cost | Budgeted Revenue | 5.00 | 6.00 | 7.00 | 8.00 | 9.00 | 10.00 | 11.00 | 12.00 | 13.00 | 14.00 | 15.00 | 16.00 | 17.00 | 18.00 | 19.00 | 20.00 | 21.00 | 22.00 | 23.00 | 24.00 | 25.00 | 26.00
Circuit | 600 | 8000 | 10000 | 0.01 | 0.02 | 0.03 | 0.05 | 0.06 | 0.06 | 0.06 | 0.08 | 0.1 | 0.18 | 0.18 | 0.18 | 0.01 | 0.12 | 0.12 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18
Circuitization | 800 | 2000 | 5000 | 0.03 | 0.02 | 0.03 | 0.05 | 0.06 | 0.06 | 0.06 | 0.08 | 0.1 | 0.18 | 0.18 | 0.18 | 0.01 | 0.12 | 0.12 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18
Data | 2000 | 3000 | 5000 | 0.06 | 0.02 | 0.03 | 0.05 | 0.06 | 0.06 | 0.06 | 0.08 | 0.1 | 0.18 | 0.18 | 0.18 | 0.01 | 0.12 | 0.12 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18
DMR | 3000 | 4000 | 6000 | 0.08 | 0.02 | 0.03 | 0.05 | 0.06 | 0.06 | 0.06 | 0.08 | 0.1 | 0.18 | 0.18 | 0.18 | 0.01 | 0.12 | 0.12 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18
Field sketch | 2000 | 5000 | 7000 | 0.05 | 0.02 | 0.03 | 0.05 | 0.06 | 0.06 | 0.06 | 0.08 | 0.1 | 0.18 | 0.18 | 0.18 | 0.01 | 0.12 | 0.12 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18
ISO | 180 | 6000 | 8000 | 0.06 | 0.02 | 0.03 | 0.05 | 0.06 | 0.06 | 0.06 | 0.08 | 0.1 | 0.18 | 0.18 | 0.18 | 0.01 | 0.12 | 0.12 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18
Metallurgy | 180 | 7000 | 9000 | 0.1 | 0.02 | 0.03 | 0.05 | 0.06 | 0.06 | 0.06 | 0.08 | 0.1 | 0.18 | 0.18 | 0.18 | 0.01 | 0.12 | 0.12 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18
PM | 180 | 8000 | 10000 | 0.12 | 0.02 | 0.03 | 0.05 | 0.06 | 0.06 | 0.06 | 0.08 | 0.1 | 0.18 | 0.18 | 0.18 | 0.01 | 0.12 | 0.12 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18
Systemization | 180 | 9000 | 11000 | 0.145 | 0.02 | 0.03 | 0.05 | 0.06 | 0.06 | 0.06 | 0.08 | 0.1 | 0.18 | 0.18 | 0.18 | 0.01 | 0.12 | 0.12 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18
Overall Project | 9120 | 52000 | 71000 | 0.05 | 0.07 | 0.08 | 0.09 | 0.105 | 0.118 | 0.131 | 0.144 | 0.157 | 0.17 | 0.183 | 0.196 | 0.209 | 0.222 | 0.235 | 0.248 | 0.261 | 0.274 | 0.287 | 0.3 | 0.313 | 0.326
Spreadsheet: 888433d1738929572-please-help-with-results-table-vlookup-match-index-functions-or-a-table-gymnastics-results-forum
Sheet: team

1 | TEAM 1 | BENCH |  | FLOOR |  | TOP 5 V+F
1 | Gymnast 1 | 7 |  | 6.5 |  |  |  | POINTS
2 | Gymnast 2 | 8 |  | 9 |  |  |  | POSITION
3 | Gymnast 3 | 9 |  | 8.7
4 | Gymnast 4 | 9.1 |  | 4.5 |  |  |  |  |  | = non scoring
5 | Gymnast 5 | 5 |  | 6 |  |  |  |  | TOP 5 GYMNASTS SCORES COUNT
6 | Gymnast 6 | 6.6 |  | 8 |  |  |  |  | TOP 3 INDIVIDUAL BENCH RESULT
 | TOTAL |  |  |  |  |  |  |  | TOP 3 INDIVIDUAL FLOOR RESULT
 |  |  |  |  |  |  |  |  | TOP 3 TEAMS FLOOR AND BENCH COMBINED SCORE
2 | TEAM 2 | BENCH |  | FLOOR |  | TOP 5 V+F |  |  | TOP INDIVIDUAL IN EACH TEAM VAULT "BEST IN TEAM"
7 | Gymnast 7 | 5.5 |  | 4 |  |  |  |  | TOP INDIVIDUAL IN EACH TEAM FLOOR "BEST I TEAM"
8 | Gymnast 8 | 6.8 |  | 6.5
9 | Gymnast 9 | 9.7 |  | 7 |  |  |  |  | BENCH |  | # duplicates | FLOOR |  | # duplicates
10 | Gymnast 10 | 4.5 |  | 9.8 |  |  |  |  | 1st |  |  | 1st
11 | Gymnast 11 | 6 |  | 6.9 |  |  |  |  | 2nd |  |  | 2nd
12 | Gymnast 12 | 7.5 |  | 8.8 |  |  |  |  | 3rd |  |  | 3rd
 | TOTAL
3 | TEAM 3 | BENCH |  | FLOOR |  | TOP 5 V+F |  |  | TEAM SCORES BY SCHOOL |  |  | SCORE
13 | Gymnast 13 | 8 |  | 4.5 |  |  |  | 1st |  |  |  |  | this needs to be in order highest to smallest, if posible?
14 | Gymnast 14 | 9 |  | 6 |  |  |  | 2nd
15 | Gymnast 15 | 7.5 |  | 9.8 |  |  |  | 3rd
16 | Gymnast 16 | 9.9 |  | 6 |  |  |  | 4th
17 | Gymnast 17 | 8 |  | 7.4
18 | Gymnast 18 | 6.5 |  | 8.9
 | TOTAL |  |  |  |  |  |  |  | INDIVIDUAL BENCH |  |  | SCORE | INDIVIDUAL FLOOR |  |  | SCORE
 |  |  |  |  |  |  |  |  | 1st | here should be gymnast names that have 9.9 scire on bench | and here the team name |  | 1st
4 | TEAM 4 | BENCH |  | FLOOR |  | TOP 5 V+F
19 | Gymnast 19 | 5.5 |  | 8
20 | Gymnast 20 | 6.5 |  | 9
21 | Gymnast 21 | 4.9 |  | 8 |  |  |  |  | 2nd | same with9.7 and so on |  |  | 2nd
22 | Gymnast 22 | 8 |  | 8.5
23 | Gymnast 23 | 9 |  | 8.9
24 | Gymnast 24 | 6 |  | 7
 | TOTAL |  |  |  |  |  |  |  | 3rd |  |  |  | 3rd
 |  |  |  |  |  |  |  |  | BEST IN TEAM
 |  |  |  |  |  |  |  |  | TEAM NAME | GYMNAST NAME  BENCH |  | GYMNAST NAME FLOOR
 |  |  |  |  |  |  |  |  |  | here the top scorer bench routine, gymnast name |  | here the top scorer floor routine, gymnast name
Spreadsheet: 0486da76-a5c3-415e-b877-2657d24aef5c
Sheet: Sheet1

Australian Bureau of Statistics | Unnamed: 1 | Unnamed: 2
64270DO010_201209 Producer Price Indexes, Australia, Sep 2012
Released at 11:30 am (Canberra time) Wed 7 Nov 2012
 | Contents
 | Tables
 | 1 | Stage of Production, index numbers, percentage changes and conversion factors (Tables 1, 2, 3, 4 and 10)
 | 2 | Input to the [NAME] mining industry, index numbers, percentage changes and conversion factors (Table 11)
 | 3 | Output of the Manufacturing industries, division index numbers and percentage changes and index numbers for subdivisions, groups and classes  and conversion factors (Table 12)
 | 4 | Input to the Manufacturing industries, division and selected industries, index numbers, percentage changes and conversion factors (Table 13)
 | 5 | Input to the Manufacturing industries, subdivision index numbers and conversion factors (Table 14)
 | 6 | Metallic input to the Fabricated metal product manufacturing industry, index numbers and conversion factors (Table 15 )
 | 7 | Copper input to the Other electrical equipment manufacturing industry, index numbers, percentage changes and conversion factors (Table 16)
 | 8 | Output of the Construction industries, subdivision, class index numbers and conversion factors (Table 17)
 | 9 | Input to the House construction industry, six capital cities and the weighted average of six capital cities, index numbers and percentage changes and conversion factors (Table 18)
 | 10 | Asphalt supplied and placed, weighted average of six state capital cities, index numbers and conversion factors (Table 19)
 | 11 | Output of the Transport, postal and warehousing industries, group, class index numbers and conversion factors (Table 21)
 | 12 | Output of the Information media and telecommunications industries, group, class index numbers and conversion factors (Table 22)
 | 13 | Output of the Rental, hiring and real estate services industries, subdivision, group, class index numbers and conversion factors (Table 23)
 | 14 | Output of the Professional, scientific and technical services industries, group, class index numbers and conversion factors (Table 24)
 | 15 | Output of the Administrative and support services industries, group, class index numbers and coversion factors (Table 25)
 | 16 | Output of the Public administration and safety industries, group, class index numbers and conversion factors (Table 26)
 | 17 | Output of the Other services industries, group, class index numbers and conversion factors (Table 27)
 | More information available from the ABS website
 | Producer Price Indexes, Australia, Sep 2012
 | Summary
 | Explanatory Notes
 | Inquiries
 | For further information about these and related statistics, contact the National Information and Referral Service on 1300 135 070.
 | © Commonwealth of Australia 2012
Spreadsheet: 154902d1336593839-match-two-category-matching
Sheet: Sheet1

 |  | Schedule-1
 |  | ID# | Name
 |  | 1 | A
 |  | 2 | B
 |  | 3 | C
 |  | 4 | D
 |  | 5 | E
 |  | Schedule-2
 |  | ID# | Name | Answe | formula
 |  | 1 | A | YES | ?
 |  | 4 | D | YES
 |  | 3 | Z | NO
 |  | 5 | F | No
 |  | 9 | R | NO
 |  | 5 | E | YES
Spreadsheet: 6230f90c-6c79-479a-a467-71a0654d2736
Sheet: Sheet1

2014 General Election - OFFICIAL RESULTS | Unnamed: 1 | Unnamed: 2
State of North Dakota Results
Precincts Reporting: 427/427 - Total Ballots Cast: 255128
Downloaded at 11/23/2014 12:33:43 PM
 | Yes - | No -
Constitutional Measure No. 1 Relating to the inalienable rights to life of every human being at every stage of development. | 90224 | 161303
 | Yes - | No -
Constitutional Measure No. 2 Relating to the prohibition of the imposition of mortgage taxes or any sales or transfer taxes on the mortgage or transfer of real property. | 188283 | 60478
 | Yes - | No -
Constitutional Measure No. 3 Relating to repealing the existing Board of Higher Education and to creating a three member commission of higher education appointed by the Governor. | 61007 | 182492
 | Yes - | No -
Constitutional Measure No. 4 Relating to the fiscal impact of measures to initiate constitutional amendments and to the placing of initiated measures on the ballot | 104245 | 135899
 | Yes - | No -
Initiated Constitutional Measure No. 5 Constitutional Petition Related to a Clean Water, Wildlife, and Parks Trust and a Clean Water, Wildlife, and Parks Fund | 51775 | 199305
 | Yes - | No -
Initiated Statutory Measure No. 6 Relating to Parental Rights and Responsibilities | 92807 | 152004
 | Yes - | No -
Initiated Statutory Measure No. 7 Relating to the Operation of a Pharmacy | 102731 | 147644
 | Yes - | No -
Initiated Statutory Measure No. 8 Statutory Petition Related to School Classes Beginning After Labor Day | 109489 | 136963
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 476642d1471957523-date-and-time-not-recognized-in-cells-need-a-formula-book1
Sheet: Sheet2

6-28-2016 1:26:00 PM
6-28-2016 1:35:00 AM
6-28-2016 1:35:00 AM
6-28-2016 10:04:00 AM
6-28-2016 12:29:00 PM
6-28-2016 12:38:00 PM
6-28-2016 12:38:00 PM
6-28-2016 2:54:00 AM
6-28-2016 4:07:00 PM
6-28-2016 4:56:00 PM
6-28-2016 8:00:00 AM
6-28-2016 8:38:00 AM
6-29-2016 1:17:00 AM
6-29-2016 10:20:00 AM
6-29-2016 10:30:00 AM
6-29-2016 10:30:00 AM
6-29-2016 10:40:00 PM
6-29-2016 12:27:00 PM
6-29-2016 12:29:00 AM
6-29-2016 2:58:00 PM
6-29-2016 4:05:00 PM
6-29-2016 4:13:00 PM
6-29-2016 4:15:00 AM
6-29-2016 4:24:00 PM
6-29-2016 4:39:00 PM
6-29-2016 4:40:00 PM
6-29-2016 4:51:00 PM
6-29-2016 5:06:00 PM
6-29-2016 5:26:00 PM
6-29-2016 5:26:00 PM
6-29-2016 6:40:00 AM
6-29-2016 7:00:00 AM
6-29-2016 7:09:00 PM
6-29-2016 8:22:00 AM
6-29-2016 8:54:00 AM
6-29-2016 8:55:00 PM
6-29-2016 9:06:00 PM
6-29-2016 9:06:00 PM
6-29-2016 9:33:00 PM
6-29-2016 9:33:00 PM
6-30-2016 1:15:00 PM
6-30-2016 1:16:00 AM
6-30-2016 1:18:00 PM
6-30-2016 1:41:00 PM
6-30-2016 1:53:00 PM
6-30-2016 10:19:00 PM
6-30-2016 10:36:00 AM
6-30-2016 10:43:00 AM
6-30-2016 10:52:00 AM
6-30-2016 11:17:00 PM
6-30-2016 11:59:00 AM
6-30-2016 2:01:00 PM
6-30-2016 2:22:00 AM
6-30-2016 2:28:00 AM
6-30-2016 2:57:00 PM
6-30-2016 2:57:00 PM
6-30-2016 3:18:00 AM
6-30-2016 3:21:00 AM
6-30-2016 3:36:00 PM
6-30-2016 3:36:00 PM
6-30-2016 3:37:00 PM
6-30-2016 3:47:00 AM
6-30-2016 4:15:00 AM
6-30-2016 4:50:00 AM
6-30-2016 4:56:00 AM
6-30-2016 5:02:00 PM
6-30-2016 5:02:00 PM
6-30-2016 6:42:00 AM
6-30-2016 7:11:00 AM
6-30-2016 9:20:00 PM
7-13-2016 12:34:00 AM
7-18-2016 11:15:00 AM
7-18-2016 12:18:00 AM
7-21-2016 2:44:00 PM
7-21-2016 6:55:00 PM
7-23-2016 5:32:00 PM
7-23-2016 9:05:00 PM
7-24-2016 1:34:00 AM
7-24-2016 1:34:00 AM
7-24-2016 10:20:00 PM
7-24-2016 10:51:00 PM
7-24-2016 8:03:00 AM
7-24-2016 8:03:00 AM
7-25-2016 10:11:00 AM
7-25-2016 11:51:00 PM
7-25-2016 11:51:00 PM
7-26-2016 11:18:00 PM
7-26-2016 2:00:00 AM
7-26-2016 2:07:00 PM
7-26-2016 8:16:00 PM
7-26-2016 8:25:00 PM
7-26-2016 8:28:00 PM
7-27-2016 1:00:00 PM
7-27-2016 10:11:00 AM
7-27-2016 12:03:00 PM
7-27-2016 12:27:00 PM
7-27-2016 12:33:00 AM
7-27-2016 4:49:00 PM
7-27-2016 6:07:00 AM
7-27-2016 6:07:00 AM
7-27-2016 7:25:00 AM
7-27-2016 9:22:00 AM
7-27-2016 9:29:00 AM
7-27-2016 9:46:00 PM
7-28-2016 1:49:00 PM
7-28-2016 1:49:00 PM
7-28-2016 10:47:00 AM
7-28-2016 12:31:00 PM
7-28-2016 6:31:00 AM
7-28-2016 9:30:00 PM
7-28-2016 9:36:00 AM
7-28-2016 9:36:00 AM
7-29-2016 1:15:00 AM
7-29-2016 11:02:00 PM
7-29-2016 2:20:00 PM
7-29-2016 2:30:00 AM
7-29-2016 6:14:00 PM
7-29-2016 8:23:00 PM
7-29-2016 9:35:00 PM
7-29-2016 9:39:00 PM
7-30-2016 1:13:00 AM
7-30-2016 1:59:00 PM
7-30-2016 10:41:00 AM
7-30-2016 10:56:00 AM
7-30-2016 11:46:00 PM
7-30-2016 2:45:00 PM
7-30-2016 5:01:00 AM
7-30-2016 8:42:00 AM
7-30-2016 9:26:00 AM
7-31-2016 1:45:00 PM
7-31-2016 1:51:00 AM
7-31-2016 10:42:00 AM
7-31-2016 12:24:00 PM
7-31-2016 2:16:00 AM
7-31-2016 2:18:00 PM
7-31-2016 2:22:00 PM
7-31-2016 3:30:00 PM
7-31-2016 4:42:00 PM
7-31-2016 5:05:00 AM
7-31-2016 5:18:00 AM
7-31-2016 6:25:00 AM
7-31-2016 7:10:00 AM
7-31-2016 8:03:00 AM
7-31-2016 8:03:00 AM
AdmittedDate
Spreadsheet: 121633d1316206714-how-to-calculate-a-special-total-on-a-pivot-table-daily-available-balance-example
Sheet: Sheet1 (2)

Date | Type | DEST CITY/ST/CTRY | ITEM | Pack Type | QTY Shipped | Daily Prog Plan | Daily Prog Actual | Available to Ship | Daily Available Balance | Special  "IF" Formula
2010-09-19 00:00:00 | P | Program | Balloons | Red |  |  | 0
2010-09-20 00:00:00 | P | Program | Balloons | Red |  |  | 123 |  |  |  |  |  | Sum of Special Formula | Column Labels
2010-09-21 00:00:00 | P | Program | Balloons | Red |  |  | 162 |  |  |  |  |  | Row Labels | P | S | Grand Total
2010-09-22 00:00:00 | P | Program | Balloons | Red |  |  | 156 |  |  |  |  |  | 2010-09-19 00:00:00
2010-09-23 00:00:00 | P | Program | Balloons | Red |  | 200 | 153 |  |  |  |  |  | 2010-09-20 00:00:00 | 123 |  | 123
2010-09-23 00:00:00 | S | TX | Balloons | Red | 480 |  | 480 |  |  |  |  |  | 2010-09-21 00:00:00 | 285 |  | 285
2010-09-24 00:00:00 | P | Program | Balloons | Red |  | 220 | 230 |  |  |  |  |  | 2010-09-22 00:00:00 | 441 |  | 441
2010-09-25 00:00:00 | P | Program | Balloons | Red |  | 220 | 261 |  |  |  |  |  | 2010-09-23 00:00:00 | 594 | 114 | 708
2010-09-26 00:00:00 | P | Program | Balloons | Red |  | 220 | 198 |  |  |  |  |  | 2010-09-24 00:00:00 | 344 |  | 344
2010-09-26 00:00:00 | S | CHG | Balloons | Red | 803 |  | 803 |  |  |  |  |  | 2010-09-25 00:00:00 | 605 |  | 605
2010-09-27 00:00:00 | P | Program | Balloons | Red |  | 861 | 845 |  |  |  |  |  | 2010-09-26 00:00:00 | 803 | 0 | 803
2010-09-28 00:00:00 | P | Program | Balloons | Red |  | 925 | 1325 |  |  |  |  |  | 2010-09-27 00:00:00 | 845 |  | 845
2010-09-29 00:00:00 | P | Program | Balloons | Red |  | 1400 | 2012 |  |  |  |  |  | 2010-09-28 00:00:00 | 2170 |  | 2170
2010-09-29 00:00:00 | S | CHG | Balloons | Red | 2640 |  | 2640 |  |  |  |  |  | 2010-09-29 00:00:00 | 4182 | 1542 | 5724
2010-09-30 00:00:00 | P | Program | Balloons | Red |  | 2250 | 2291 |  |  |  |  |  | 2010-09-30 00:00:00 | 3833 |  | 3833
2010-10-01 00:00:00 | P | Program | Balloons | Red |  | 2250 | 2902 |  |  |  |  |  | 2010-10-01 00:00:00 | 6735 |  | 6735
2010-10-02 00:00:00 | P | Program | Balloons | Red |  | 2750 | 4179 |  |  |  |  |  | 2010-10-02 00:00:00 | 10914 | 16400 | 27314
2010-10-02 00:00:00 | S | DC | Balloons | Red | 3786 |  | 2160 |  |  |  |  |  | Grand Total | 31874 | 18056 | 49930
2010-10-02 00:00:00 | S | DC | Balloons | Red | 1892 |  | -638.4000000000001
2010-10-02 00:00:00 | S | MIA | Balloons | Red | 1200 |  | -1200
Spreadsheet: 75934d1276537306-how-to-transfer-infos-from-1-spreadsheet-to-the-other-finalwork
Sheet: Total sales (Jan)

Dopular
Total Sales by Product in the month of January
Product | Singapore - Location |  |  |  |  | Total Sales
 | Bedok | [NAME] | Woodlands | Orchard | Kallang
Children Books
Art and Craft
Puzzles and Games
Furnitures
Classroom Supplies
[NAME]
Block Play
CD-ROMS
Total
Average
Highest
Lowest
Spreadsheet: 03b97004-2834-4b67-8006-d612161f13ce
Sheet: <insert org. name here>

THIS FORM MUST BE SUBMITTED VIA EMAIL TO THE STUDENT GOVERNMENT ASSOCATION at [EMAIL]
By Friday, MARCH 15 at 4:30pm
Name of Organization: |  |  | Sample Travel Org
President of 2012-13 Academic Year: |  |  | [NAME] |  |  |  |  | This spreadsheet is [NAME].  Please do not alter Total cells.
Advisor(s): |  |  | [NAME]
E-Mail Address(es) of Those Attending Budget Hearings: |  |  | [EMAIL]
E-Mail Address of the Advisor(s): |  |  | [EMAIL]
Telephone Number of the President: |  |  | [PHONE] |  |  |  |  | PLEASE INDICATE ORG TYPE*
Telephone Number of the Advisor: |  |  | [PHONE] |  |  |  |  | On-Campus |  | (     )
 |  |  |  |  |  |  |  | Travel |  | (  x   )
 |  |  |  |  |  |  |  | *(please see guidelines for how this might affect your funding)
Operational Budget
 |  | Total Cost |  |  | What we need in your details are justifications, which include:
Promotional: |  |  |  |  | Function, quantities, separated costs.  For trips, the purpose and length of trip. As much information as you deem necessary, the more information you include, the better.
Speakers and Entertainment:
Capital: |  |  |  |  | Example:
Non-Capital Spending: |  |  |  |  | Item: | Details: |  |  |  | Total Item Costs:
Food: |  |  |  |  | Hotel for Trip 1 | Six rooms @ $120/room @ Courtyard Marriott, Roseville MN |  |  |  | 720
Student Planned Travel: |  |  |  |  | Paper | 2 boxes for fliers @ 70/box |  |  |  | 140
External Travel:
Performance Travel:
Total:
EQUIPMENT AND SUPPLY INVENTORY SHEET
Equipment and Supply Currently Owned |  |  |  | Quantity | Condition
# | Item
1
2
3
4
5
6
7
8
9
Equipment and [NAME] for the Current Year |  |  |  | Quantity | Condition
# | Item
1
2
3
4
5
6
7
8
9
Spreadsheet: 822789d1679528899-repeat-values-x-times-down-a-column-s666-pq-repeat-values
Sheet: Sheet1

Input data |  | Multiplier |  | output data
1 |  | 3 |  | 1 |  | after change value in multiplier table right click on the green table and select [NAME]
a |  |  |  | 1
test |  |  |  | 1
jkl |  |  |  | a
wjklwl |  |  |  | a
33 |  |  |  | a
502 |  |  |  | test
sdjkl |  |  |  | test
elkjl |  |  |  | test
[NAME] |  |  |  | jkl
 |  |  |  | jkl
 |  |  |  | jkl
 |  |  |  | wjklwl
 |  |  |  | wjklwl
 |  |  |  | wjklwl
 |  |  |  | 33
 |  |  |  | 33
 |  |  |  | 33
 |  |  |  | 502
 |  |  |  | 502
 |  |  |  | 502
 |  |  |  | sdjkl
 |  |  |  | sdjkl
 |  |  |  | sdjkl
 |  |  |  | elkjl
 |  |  |  | elkjl
 |  |  |  | elkjl
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 739055d1625488120-formula-when-a-row-has-a-different-number-of-month-nos-in-cells-then-turns-red-if-overdue-matrix-2-
Sheet: Training Matrix

Health and Safety MASTER Training Matrix |  |  | Training Expired |  | Today
 |  |  | Training In Date |  | Months | 12 | 36 | 60 | 0
 |  |  | Training Due to Expire in 3 Months Time |  | New Date
First Name | Surname | Department | Job Title | Line Manager | First Aid | LMS - Fire Warden Deputy Sweepers | [NAME] SOP TAB | Fire Awareness | Asbestos Awareness | [NAME] | LMS Confined Space Entry | Lone Working | Working at Height | FLT - On Site | [NAME] Site | Scissor Lift - On Site | Pallet Punp Truck - On Site | FLT Refresher On Site | MEWP - External | DSE | Slips, Trips and [NAME] | IOSH Managing Safely - External | IOSH Working Safely External | [NAME] | Harness Training - External | LMS - Accident Investigation Training | Risk Assessment Training | Slips, Trips And [NAME] | COSHH Training | Face fit Testing | Permit to Work - External | Ladders in the Workplace Awareness - External | Abrasive Wheels - External | Managing Contractors | Personal Protective Equipment | Panel Entry Training - External | IPAF Training - External | PASMA - External
WHO |  |  |  |  | Nominated First Aiders | Nominated Fire Warden and Sweepers | All | All | Job Specific -  Engineering Hygiene Civils | Job Specific -  Engineering Hygiene Environmental | Job Specific -  Engineering Hygiene Environmental | Job Specific -  Stores Tractor Drivers | All | Job Specific -  FLT Operators | Job Specific -  FLT Operators | Job Specific -  MEWP Operators | Job Specific -  Pump Truck Operators | Job Specific -  FLT Operators | Job Specific -  Engineering Civils | All Computer Users | All | Managers Team Leaders Supervisors |  | All Production | Job Specific - IK [NAME] Engineering Hygeine Environmental Civils | Managers Team Leaders Suervisors | Managers Team Leaders Suervisors | All | Job Specific -  IBC Yard Jet Wash Hygeiene Environmental Meat Kitchen Engineering Extrusion | Job Specific - Production Engineering Environmental Hygeine | Team Leaders Supervisors Engineering | Job Specific Ladder Inspections | All Engineering | Engineering Projects Environmental Civils | All Production Engineering Hygiene Environmental | Engineering Nominated IT Environmental Team Leaders (Nominated Colleagues) | Job Specific | Job specific
FREQUENCY OF TRAINING (Months) |  |  |  |  | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 60 | 60 | 60 | 60 | 60 | 36 | 36 | 36 | 60 | 60 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 12 | 60 | 60
Name |  |  |  |  | 2021-07-06 00:00:00 | 2021-07-05 00:00:00 |  | 2018-02-13 00:00:00
Name |  |  |  |  |  |  |  | 2021-10-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-20 00:00:00 | 2021-04-09 00:00:00 |  |  |  |  | 2020-12-09 00:00:00
Name |  |  |  |  |  | 2017-01-01 00:00:00 |  |  |  | 2019-06-05 00:00:00 | 2019-06-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2018-05-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-05-01 00:00:00
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 341465 | 329748 |  | 15605 | 36925 | 36557 | 171258 | 176277 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 333969 | 323101 |  | 10827 | 32325 | 36557 | 128578 | 132874 |  |  |  | [NAME] |  |  | -34361 |  | 25006
3 | 329682 | 320457 |  | 15442 | 35751 | 36557 | 144515 | 142776 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 342762 | 331995 |  | 15281 | 37608 | 36557 | 142892 | 142891 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 356704 | 341499 |  | 14075 | 42720 | 36557 | 154730 | 152625 |  |  |  | 2001-02-01 00:00:00 | 15256233 | 15290953 |  | 5.61
6 | 347396 | 339399 |  | 8714 | 42100 | 36557 | 137236 | 137167 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 |  |  |  |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 |  |  |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 |  |  |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.58
10 |  |  |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 |  |  |  |  |  |  |  |  |  |  |  | 2001-08-01 00:00:00 | 17850737 | 17815859 |  | 2.61
12 |  |  |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 16552948 | 16508018 |  | 1.73
13 |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 | 17924814 | 17872479 |  | 2.06
14 |  |  |  |  |  |  |  |  |  |  |  | 2001-11-01 00:00:00 |  |  |  | 1.98
15 |  |  |  |  |  |  |  |  |  |  |  | 2001-12-04 00:00:00
16
17
18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.98
20 |  |  |  |  |  |  |  |  |  |  |  |  | 1378106 | 1316146
21 |  |  |  |  |  |  |  |  |  |  |  |  | 9216070 | 9272400
22 |  |  |  |  |  |  |  |  |  |  |  |  | 3546065 | 3512740
23 |  |  |  |  |  |  |  |  |  |  |  |  | 1623705 | 1620245
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  | 0
2002-03-06 00:00:00
CBS Dollars
 |  |  | 84461
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
 |  |  | 2444.99
 |  |  | 250