tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884774d1734036517-determine-the-4th-consecutive-value-higher-than-0-cid-arrears
Sheet: CID

Year | Hours worked | CID hours | CID arrears due? | Difference due
2013/2014 | 320 |  |  |  |  | After 4 consecutive contracts, the employee gets a contract of indefinite duration (CID) for the number of hours worked during that 4th year.
2014/2015 | 285 |  |  |  |  | After that, the CID hours are reviewed yearly.
2015/2016 | 423 |  |  |  |  | What formula could I use to indicate which one is the 4th consecutive year (col. B) and automatically use that figure in the corresponding cell in col. C?
2016/2017 | 605 |  |  |  |  | If the hours worked  during the years following that 4th year are below the CID hours, the employee is due arrears of pay for the difference.
2017/2018 | 380 |  |  |  |  | Where the hours worked in the years following that 4th year are higher than the CID hours, the higher number becomes the new CID.
2018/2019 | 701
2019/2020 | 526 |  |  |  |  | Different employees started at different times, so the 4th consecutive year may be different, e.g. 2019/2020.
2020/2021 | 392
2021/2022 | 160 |  |  |  |  | The user of this table will input the hours worked (column B) for each individual.
2022/2023 | 800 |  |  |  |  | Each employee has a separate table.
2023/2024 | 560
2024/2025
Spreadsheet: 817656d1676383702-formula-needed-to-calculate-values-for-nulls-between-values-example-32-ans
Sheet: Sheet1

1 |  | 1
 |  | 1.25
 |  | 1.5
 |  | 1.75
2 |  | 2
 |  | 2.67
 |  | 3.33
4 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
4 |  | 4
 |  | 3.8
 |  | 3.6
 |  | 3.4
 |  | 3.2
3 |  | 3
 |  | 2.33 |  |  |  | How C19 and C20 values are achieved.
 |  | 1.67
Spreadsheet: 290835d1389982515-tricky-troubles-with-transposing-pivot_tbl
Sheet: Sheet2

Date | Firm | Count |  | Sum of Count | Firm
2013-01-01 00:00:00 | A | 1 |  | Date | A | B | C | D
2013-01-01 00:00:00 | B | 3 |  | 2013-01-01 00:00:00 | 1 | 3 | 5
2013-01-01 00:00:00 | C | 5 |  | 2013-01-02 00:00:00 | 2 | 6 |  | 4
2013-01-02 00:00:00 | A | 2
2013-01-02 00:00:00 | D | 4
2013-01-02 00:00:00 | B | 6
Spreadsheet: 847998d1698823133-listing-of-data-with-countifs-formula-countifs_with_data
Sheet: Regions

 | From | 2023-09-01 00:00:00 | To | 2023-09-10 00:00:00
 | Region | CR
 |  | P3
 | APAC
 | EMEA
 | INDIA
 | NAM
 | SAM
 | Expected Result
 | Ticket No. | Creation date | Priority | Ticket Type | Region
 | CR-A1229422 | 2023-09-06 00:00:00 | P3 | CR | APAC
 | CR-A1228366 | 2023-09-01 00:00:00 | P3 | CR | APAC
 | CR-A1230282 | 2023-09-08 00:00:00 | P3 | CR | EMEA
 | CR-A1229885 | 2023-09-07 00:00:00 | P3 | CR | EMEA
 | CR-A1229652 | 2023-09-06 00:00:00 | P3 | CR | EMEA
 | CR-A1228815 | 2023-09-04 00:00:00 | P3 | CR | EMEA
 | CR-A1228087 | 2023-09-01 00:00:00 | P3 | CR | EMEA
 | CR-A1230439 | 2023-09-08 00:00:00 | P3 | CR | INDIA
 | CR-A1230274 | 2023-09-08 00:00:00 | P3 | CR | INDIA
 | CR-A1228556 | 2023-09-04 00:00:00 | P3 | CR | INDIA
 | CR-A1228442 | 2023-09-01 00:00:00 | P3 | CR | INDIA
 | CR-A1229715 | 2023-09-06 00:00:00 | P3 | CR | NAM
 | CR-A1229553 | 2023-09-06 00:00:00 | P3 | CR | SAM
 | CR-A1229099 | 2023-09-05 00:00:00 | P3 | CR | SAM
Spreadsheet: 862552d1710251198-need-help-totaling-based-on-selections-mix-id-calculator-bdh
Sheet: Sheet1

This section is where the results are displayed. |  |  |  |  |  |  |  |  |  | This section is where I manipulate the lists and price.  Can be done on another tab.
Base Price | Mix ID | Add On |  |  |  | Distance | Total |  |  | Mix ID | Price |  | Add On | Price |  | Distance | Price
 |  | Air | HRWR | 3/8 Agg | [NAME]
121 | COM351510 |  |  |  |  | 1-10 |  |  |  | COM301510 | base |  | Air | 3 |  | 1-10 | 0 |  | False
 |  |  |  |  |  |  |  |  |  | COM351510 | 5 |  | HRWR | 5 |  | 11-20 | 5 |  | False
 |  |  |  |  |  |  |  |  |  | COM401510 | 10 |  | 3/8 Agg | 7 |  | 21-30 | 10 |  | False
 |  |  |  |  |  |  |  |  |  | COM451510 | 15 |  | [NAME] | 13 |  | 31-40 | 20 |  | False
 |  |  |  |  |  |  |  |  |  | COM501510 | 20 |  | 1%Retard | 0
 |  |  |  |  |  |  |  |  |  | COM601510 | 30 |  | 2%Retard | 1
 |  |  |  |  |  |  |  |  |  | COM701510 | 40 |  | 3%Retard | 2
 |  |  |  |  |  |  |  |  |  | COM801510 | 50 |  | Fiber | 7
 |  |  |  |  |  |  |  |  |  | 500S | 7 |  | SRA | 75
 |  |  |  |  |  |  |  |  |  | 550S | 12 |  | SS | 7
 |  |  |  |  |  |  |  |  |  | 600S | 17
 |  |  |  |  |  |  |  |  |  | 650S | 22
 |  |  |  |  |  |  |  |  |  | 700S | 27
 |  |  |  |  |  |  |  |  |  | 800S | 32
Spreadsheet: 451285d1458136904-if-word-appears-in-column-b-within-date-range-in-column-q-sumproduct-for-year-and-month
Sheet: Sheet1

Site | Status | Postcode | Access comments | Special Delivery/Problem | Survey required | sent to RT | Received from RT | WO ID | Task No. | Remedy INC | ANOC Closure Code | Shields Order Date | Site Survey | Reason for Survey | Team | Planned/Actual Completion | Survey | Aborted | Aborted 2 | Battery type | Quantity
3084 | Active | GU151SP | require surry Police vetting |  |  |  |  | 45586888 | tas000000888467 |  |  | 2015-05-31 00:00:00 |  |  |  |  |  |  |  | 12V62F | 8
394 | Complete | NW87HS | Hotel Danubius |  |  |  |  | 49401774 | 1066894 |  |  | 2015-10-08 00:00:00 |  |  |  |  |  |  |  | 12V170F | 24
10916 | Active | BT22 1NB | Arqiva |  |  |  |  |  |  | INC000001858930 |  | 2015-11-23 00:00:00 |  |  |  |  |  |  |  | 12V62F | 8
4402 | Complete | PE68SD |  |  |  |  |  | 58610647 | 1503811 | INC000001982759 |  | 2016-01-25 00:00:00 |  |  | Newts & Morris | 2016-03-07 00:00:00 |  |  |  | 12V62F | 4
5377 | Active | CF623BD | require airport clearance |  |  |  |  | 58698649 | 1504585 | INC000001985090 |  | 2016-01-25 00:00:00 |  |  |  |  |  |  |  | 12V62F | 4
17076 | aborted | EX348NW | 24hr key broken in lock on attendance |  |  |  |  | 59536882 |  |  |  | 2016-02-24 00:00:00 |  |  | Newts & Morris |  |  | 2016-03-15 00:00:00 |  | 12V30F | 4
37155 | aborted | MK439LN | streetworks |  |  |  |  | 58290955 |  |  |  | 2016-02-25 00:00:00 |  |  | Newts & Morris |  |  | 2016-03-07 00:00:00 |  | 170a link bars only | 2
734 | Complete | ML119QA |  |  |  |  |  | 57645401 |  |  |  | 2016-03-01 00:00:00 |  |  | [NAME] | 2016-03-09 00:00:00 |  |  |  | 12V170F | 28
10199 | Complete | TN162EH |  |  |  |  |  | 58804368 |  |  |  | 2016-03-01 00:00:00 |  |  |  | 2016-03-03 00:00:00 |  |  |  | 4 X 12V170FS ACCESSORY KIT | 2
60536 | aborted | SP12SR |  |  |  |  |  | 59619309 |  |  |  | 2016-03-01 00:00:00 |  |  | Newts & Morris |  |  | 2016-03-08 00:00:00 |  | 12V30F | 1
10831 | Active | PA318QA | ATV | specialist delivery/ATV |  |  |  | 59536882 |  |  |  | 25.02.16 |  |  |  |  |  |  |  | SBS60 | 12
40633 | planned | OX145TJ | require site specific RAMS required |  |  |  |  | 58915218 | 1520501 | INC000001995289 |  | 2016-01-27 00:00:00 |  |  | [NAME] | 2016-03-17 00:00:00 |  |  |  | 12V62F | 4
 | 12v30F | 12v33F | 12V62F | 12V92F | 12V170F | SBS60 | Total
2016-01-01 00:00:00
2016-02-01 00:00:00
2016-03-01 00:00:00
2016-04-01 00:00:00
2016-05-01 00:00:00
2016-06-01 00:00:00
2016-07-01 00:00:00
2016-08-01 00:00:00
2016-09-01 00:00:00
Spreadsheet: 863666d1711076728-trying-to-count-txt-cells-down-a-screen-countif-multiple-columns-totals_a
Sheet: Sheet1

 |  | Option | Number |  | Count | This formula does not work
 |  | No | 4
 |  | Yes | 5 |  | '=countif("No"C4:C15,"No",["*4",D4:[NAME]"]..) |  |  |  |  | Count the number of No and place result in Cell F5
 |  | Yes
 |  | No | O5
 |  | No | [NAME] |  | '=countif("*4"D4:[NAME]:D15,"No"]..) |  |  |  |  | Count the number of 4  and place result in Cell F8
 |  |  | 5
 |  | No | O4
 |  | No | O4
 |  | No
 |  | No | 4
 |  | No | 4 |  | Require correct formulae to count number of txt cells for "No" and *4.
 |  | Yes | 4 |  | to exclude blank cells
Outcome
Correct answers |  | 8 | 7
 |  |  |  |  | Rquire formiula with  the following conditions
 |  |  |  |  | If D4 = 4 or *4, and C4 = No, then C4 = Yes
 |  |  |  |  | If D4 = any other value than 4 or *4 or blank C4 = 0
Spreadsheet: 794908d1662396034-return-the-consumption-amount-by-using-related-details-consumption-calculator
Sheet: Sheet1

From Date | To Date | Month Factor | Consumption Unit | Expected result by using the data of Cells (E9:F12) , Column C and Column D
2022-02-26 00:00:00 | 2022-04-09 00:00:00 |  | 447 | 1665.3
2022-04-09 00:00:00 | 2022-05-27 00:00:00 |  | 714 | 2973.6
2022-05-27 00:00:00 | 2022-08-27 00:00:00 |  | 1416 | 6413.400000000001
 |  |  |  | First 50 Units  Per Month | 2.65 Per Unit
 |  |  |  | Next 50 Units  Per Month | 3.10 Per Unit
 |  |  |  | Next 150 Units  Per Month | 3.75 Per Unit
 |  |  |  | Above 250 Units  Per Month | 4.90 Per Unit
Spreadsheet: 542963d1508176843-formula-to-return-text-based-on-two-criteria-excelforum-formula-to-return-text-based-on-two-criteria
Sheet: Sheet1

Option 1 |  |  |  | Option 2
Date | 1996-01-01 00:00:00 |  |  | Date | 2017-10-16 00:00:00
Category | Green |  |  | Category | Green
Cost |  | should be £1.00 |  | Cost |  | should be £1.50
Category | From | To | Cost
Blue | 1990-01-01 00:00:00 | 2004-12-31 00:00:00 | 1
Purple | 1990-01-01 00:00:00 | 2003-07-31 00:00:00 | 1
Green | 1990-01-01 00:00:00 | 2004-02-29 00:00:00 | 1
[NAME] | 1990-01-01 00:00:00 | 2003-05-31 00:00:00 | 1
Blue | 2005-01-01 00:00:00 | 2017-10-16 00:00:00 | 1.5
Purple | 2003-08-01 00:00:00 | 2017-10-16 00:00:00 | 1.5
Green | 2004-03-01 00:00:00 | 2017-10-16 00:00:00 | 1.5
[NAME] | 2003-06-01 00:00:00 | 2017-10-16 00:00:00 | 1.5
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Jul 22

Enter 1st of Month Here -> | 2022-07-01 00:00:00 | Controller | Volunteer 1 | Volunteer 2 | Volunteer 3 | Volunteer 4 | Volunteer 5 | Volunteer 6
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
Sat
Sun
Spreadsheet: 166293d1341522077-compare-two-values-but-does-not-need-to-be-perfect-match-this-way-hmm
Sheet: Sheet1

93708993350 | 9370 |  |  |  | 9379 |  |  | 9370 | 937 | 93
93705816605 | 9370 |  |  |  | 9378 |  |  | 9370 | 937 | 93
93772312000 | 9377 |  |  |  | 9377 |  |  | 9377 | 937 | 93
93705816563 | 9370 |  |  |  | 9375 |  |  | 9370 | 937 | 93
93762524088 | 937 |  |  |  | 9370 |  |  |  | 937 | 93
93752289896 | 9375 |  |  |  | 937 |  |  | 9375 | 937 | 93
93777463320 | 9377 |  |  |  | 93 |  |  | 9377 | 937 | 93
93780872287 | 9378 |  |  |  |  |  |  | 9378 | 937 | 93
93752289688 | 9375 |  |  |  |  |  |  | 9375 | 937 | 93
93742289688 | 937 |  |  |  |  |  |  |  | 937 | 93
93842222222 | 93 |  |  |  |  |  |  |  |  | 93
93718993350 | 937 |  |  |  |  |  |  |  | 937 | 93
92344444444 | 0
Spreadsheet: 75615d1276164504-left-lookup-sample
Sheet: Sheet1

Type | Value1 | Value2 |  | Find Type given Value |  | occurance
aa | 149 |  |  | Value | 150 | 1 | jj
bb | 145 | 150 |  |  |  | 2
cc | 148 | 146 |  |  |  | 3
dd | 150 | 146 |  |  |  | 4
ee |  | 150 |  |  |  | 5
ff | 147 | 140
gg | 150
hh |  | 150
ii | 142 | 145
jj | 147
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: DWR 1304563

THIS IS AN EQUITY FORWARD-NOT ON P&L
Stock Hedge
Warburg Dillon Read - Ref # 1304563 |  |  |  | Terminates | 2000-06-13 00:00:00
 |  | Quarter End |  | Quarter End | Quarter End | Quarter End | Quarter End
ENE |  |  |  | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | Year 2000 |  | LTD
 | Market Price
Shares: | 1220650
Opening price | 41.0449
Equity Payment (Warburg pays if price goes up/Enron pays if price goes down)
 | Opening value
 | Closing Value
 | MTM
Net receipt/(payment)
 |  |  |  |  |  |  |  |  |  | WDR1304771
Spreadsheet: 121881d1316477021-work-schedule-multiple-outputs-from-one-search-criteria-trucking-schedule-example
Sheet: Sheet2

 |  |  | [NAME] | 25
 |  |  | [NAME]
Truck | Type | [NAME] | Loadout time | Location
Truck 7 | Triaxle | [NAME] | 06:30:00 | STP
Truck 10 | Trailer | [NAME] | 07:30:00 | Plant
Truck 12 | Quint | [NAME] | 06:30:00 | Plant
Truck 16 | Quad | [NAME] | 07:30:00 | STP
Truck 21 | Trailer | [NAME] | 06:30:00 | Plant
Truck 26 | Trailer | [NAME] | 07:30:00 | STP
Truck 29 | Quint | [NAME] | 06:30:00 | Plant
Truck 31 | Quint | [NAME] | 06:30:00 | Plant
Truck 35 | Trailer | [NAME] | 06:30:00 | STP
Truck 40 | Trailer | [NAME] | 07:30:00 | Plant
Truck 45 | Trailer | [NAME] | 06:30:00 | Plant
Truck 48 | Quint | [NAME] | 07:30:00 | Plant
Truck 50 | Quad | [NAME] | 07:30:00 | Plant
Truck 54 | Trailer | [NAME] | 06:30:00 | Plant
Truck 59 | Triaxle | [NAME] | 06:30:00 | Plant
Truck 64 | Triaxle | [NAME] | 07:30:00 | Plant
Truck 67 | Quad | [NAME] | 06:30:00 | Plant
Truck 69 | Trailer | [NAME] | 06:30:00 | Plant
Truck 73 | Triaxle | [NAME] | 06:30:00 | Plant
Truck 78 | Trailer | [NAME] | 07:30:00 | Plant
Truck 83 | Tandem | [NAME] | 06:30:00 | Plant
Truck 86 | Trailer | [NAME] | 07:30:00 | Plant
Truck 88 | Trailer | [NAME] | 07:30:00 | STP
Truck 92 | Triaxle | [NAME] | 07:30:00 | Plant
Truck 97 | Quint | [NAME] | 06:30:00 | STP
Spreadsheet: 5835f8d6-e708-4198-8f0e-8ac063ab8977
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2011/12 |  |  | 2010/11 |  |  | 2009/10
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 14.08 | 14.4 |  | 9.58 | 9.68 |  | 11.33 | 11.42
September | 15.09 | 15.44 |  | 10.51 | 10.62 |  | 11.25 | 11.35
October | 15.63 | 15.99 |  | 12.15 | 12.29 |  | 11.02 | 11.11
November | 14.93 | 15.28 |  | 13.4 | 13.58 |  | 11.4 | 11.5
December | 13.9 | 14.21 |  | 14.5 | 14.67 |  | 13.03 | 13.15
January | 12.61 | 12.88 |  | 13.98 | 14.15 |  | 13.03 | 13.14
February | 11.81 | 12.2 |  | 12.68 | 13.35 |  | 12.74 | 12.99
March | 11.52 | 11.92 |  | 12.13 | 12.76 |  | 11.21 | 11.42
April | 11.15 | 11.54 |  | 11.76 | 12.36 |  | 10.53 | 10.72
May 2/ | 11.61 | 12.02 |  | 11.58 | 12.17 |  | 9.92 | 10.1
June |  |  |  | 11.78 | 12.39 |  | 9.41 | 9.57
July |  |  |  | 12.49 | 13.14 |  | 9.42 | 9.58
Market-year
average 1/ | 13.233 | 13.588 |  | 12.21166666666667 | 12.59666666666666 |  | 11.19083333333333 | 11.3375
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated May 11, 2012.
Spreadsheet: 172468d1344230107-extracting-required-values-from-one-filename-into-separate-columns-extracting-values-from-filesname
Sheet: Sheet1

 |  |  | HOW I WANT THEM TO BE EXTRACTED
Filesname | Date |  | TYPE | PN | SN | OPN | Date | TYPE | PN | SN | OPN | Date
44WDS_SO#_PN#2054085-30-01_SN#112092198.pdf | 2014-06-16 00:00:00 |  | WDS | 2054085-30-01 | 112092198 |  | 2014-06-16 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112092200.pdf | 2014-06-17 00:00:00 |  | WDS | 2054085-30-01 | 112092200 |  | 2014-06-17 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112094967.pdf | 2014-06-18 00:00:00 |  | WDS | 2054085-30-01 | 112094967 |  | 2014-06-18 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112095048.pdf | 2014-06-19 00:00:00 |  | WDS | 2054085-30-01 | 112095048 |  | 2014-06-19 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112095049.pdf | 2014-06-20 00:00:00 |  | WDS | 2054085-30-01 | 112095049 |  | 2014-06-20 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112176145.pdf | 2014-06-21 00:00:00 |  | WDS | 2054085-30-01 | 112176145 |  | 2014-06-21 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112176146.pdf | 2014-06-22 00:00:00 |  | WDS | 2054085-30-01 | 112176146 |  | 2014-06-22 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112176147.pdf | 2014-06-23 00:00:00 |  | WDS | 2054085-30-01 | 112176147 |  | 2014-06-23 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112176228.pdf | 2014-06-24 00:00:00 |  | WDS | 2054085-30-01 | 112176228 |  | 2014-06-24 00:00:00
44DIM_SO#_PN#2054085-30-01_SN#112092198_OPN1200/1300/1400/1800pdf | 2014-06-25 00:00:00 |  | DIM | 2054085-30-01 | 112092198 | 1300 | 2014-06-25 00:00:00
44DIM_SO#_PN#2054027-30-01_SN#112092888_OPN200/300/1400pdf | 2014-06-26 00:00:00 |  | DIM | 2054085-30-01 | 112092198 | 1400 | 2014-06-25 00:00:00
 |  |  | DIM | 2054085-30-01 | 112092198 | 1800 | 2014-06-25 00:00:00
 |  |  | DIM | 2054027-30-01 | 112092888 | 300 | 2014-06-26 00:00:00
 |  |  | DIM | 2054027-30-01 | 112092888 | 1400 | 2014-06-26 00:00:00
Spreadsheet: 143606d1330481174-excel-2007-adding-a-secondary-y-axis-graph-sample
Sheet: COM 400

COM 400 Assessment Questions
 | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
Strongly Agree | 20 |  | 19 |  | 15 |  | 17 |  | 17 |  | 15
Agree | 1 |  | 2 |  | 4 |  | 2 |  | 4 |  | 4
Neutral | 0 |  | 0 |  | 1 |  | 2 |  | 0 |  | 2
Disagree | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0
Strongly Disagree | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 682528d1592183056-average-without-calculating-blank-cells-statshelp
Sheet: Jun

Date | Time % | Wait % | Down | [NAME].
2020-06-01 00:00:00 | 32 | 44 | 44.55 | 1.55917828872974 |  | Average By Day
2020-06-02 00:00:00 | 37 | 44 | 35.22 | 1.641505864547862 |  |  | Mon. | Tue. | Wed. | Thu. | Fri. | Average
2020-06-03 00:00:00 | 30 | 42 | 42.26 | 1.647302904564315 |  | Time %
2020-06-04 00:00:00 | 41 | 47 | 41.65 | 1.67 |  | Wait%
2020-06-05 00:00:00 | 35 | 46 | 44.71 | 1.71 |  | Down |  |  |  |  |  | 0
2020-06-08 00:00:00 | 35 | 44 | 38.49 | 1.52 |  | [NAME].
2020-06-09 00:00:00 | 37 | 46 | 36.78 | 1.6
2020-06-10 00:00:00 | 35 | 50 | 43.33 | 1.76
2020-06-11 00:00:00 | 36 | 47 | 44.66 | 1.72
2020-06-12 00:00:00 | 35 | 47 | 42.11 | 1.66
2020-06-15 00:00:00
2020-06-16 00:00:00
2020-06-17 00:00:00
2020-06-18 00:00:00
2020-06-19 00:00:00
2020-06-22 00:00:00
2020-06-23 00:00:00
2020-06-24 00:00:00
2020-06-25 00:00:00
2020-06-26 00:00:00
2020-06-29 00:00:00
2020-06-30 00:00:00
Spreadsheet: 845368d1696904521-automatically-insert-rows-for-each-value-that-is-returned-example-2
Sheet: Lead Data

Number | Description | Quantity
1 | Company A | 3
2 | Company B
3 | Company C
4 | Company A
5 | Company B
6 | Company C
7 | Company A
8 | Company B | 102
9 | Company C
10 | Company A
11 | Company B
12 | Company C
13 | Company A
14 | Company B
Spreadsheet: 86170d1286205846-moving-data-when-a-match-is-found-on-a-different-tab-example
Sheet: Tracker

Number | Description | Authorization Status | Shipment Amount | Quantity Billed | PREVIOUS BILLED O/S | May | June | July | AUG | SEPT |  | Buyer | BILLING COMPLETE AFTER INVOICE | [NAME] | Mail Date | Notes
PWLE/66/1 | ZB0159 Estmated Campaign cost | Rels | 5500 |  |  |  |  |  |  | 0 | 5500
PWLE/35/1 |  | Rels | 110095.47 |  |  |  |  |  |  | 2244.5736
PWLE/55/1 |  | Rels |  |  |  |  |  |  | 0 | 1307.65442 | -1307.65442
 | FIND THESE IN REPORT TAB
Spreadsheet: john_lavorato__16496__OGC Cheques - 2000
Sheet: James Murphy

Order of [NAME]
Donations for deputy | [NAME]
CompanyName | FirstName | Initial | LastName | As it appears in the Brochure… | Address 1 | Address2 | City | Province | PostalCode | Donation | Category | Tax Receipt to Individual? | notes | Deputy | website address
Acumen Capital Partners | [NAME] |  | Laidlaw | Acumen Capital Partners | 200, 513 - 8 Ave SW |  | Calgary | AB | T2P 1E3 | 1000 | [NAME] |  |  | [NAME] | www.acumencapital.com
 | [NAME] |  | Kerr | [NAME] | Suite 2300, 707 8 Ave SW |  | Calgary | AB | T2P 1H5 | 1000 | [NAME] | Y | share donation | [NAME]
TrizecHahn Office Properties Ltd. | [NAME] |  | Kryczka | TrizecHahn Office Properties Ltd. | 1710, 700 2 St SW |  | Calgary | AB | T2P 2W1 | 1000 | [NAME] | Company |  | [NAME]
BURNCO |  |  |  | BURNCO |  |  |  |  |  | 10000 | Partner | Company | donation in product - completed Jan 24 | [NAME]
Spreadsheet: 216408d1361763018-averageif-ignoring-0-values-its-supposed-to-but-not-doing-it-averageif-example
Sheet: WPlStats

Player | Week | Opponent | Home or Away | AVG Shot % | Balls Made Total | 8 Balls Made | 8 Ball Fouls | 8 Ball Breaks | Break & Run | Sub
[NAME] | 2 | Kozy 2 | 1 | 58.33333333333333 | 14 | 2 | 0 | 0 | 0
Spreadsheet: 8cc4f519-83fe-4f4c-9674-98824f9a5858
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
35979397 | 2013-05-17 10:09:53 | AXIS | 1 | 4 | 0 | 1307379 | Blackcats16 | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
35979515 | 2013-05-17 10:27:23 | ALLIES | 0 | 3 | 4 | 1307379 | Blackcats16 | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
36040726 | 2013-05-21 10:06:27 | AXIS | 0 | 3 | 6 | 506159 | hurletout | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
36040862 | 2013-05-21 10:26:50 | ALLIES | 0 | 2 | 6 | 506159 | hurletout | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: michelle_lokay__26627__imbalsumm0102
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 109647 | 107420
2 | 92682 | 92009
3 | 119934 | 117811
4 | 118073 | 120448
5 | 125154 | 123014
6 | 148315 | 149289
7 | 121730 | 120413
8 | 95622 | 93136
9 | 124406 | 124579
10 | 116813 | 115232
11 | 117045 | 115461
12 | 116972 | 115139
13 | 115321 | 113468
14 | 117984 | 117992
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  | -32211
2001-02-14 00:00:00
Spreadsheet: 769716d1645649108-help-with-formula-to-pull-description-and-add-quantities-from-lookup-list-bom-template
Sheet: Networking

ROOM | Quantity | Part No. | Brief Description | Purchase From | (NU) Labor Cost | (U) Labor Cost | ( C ) Labor Cost | Device Cost | Cable | (NU) Labor Total | (U) Labor Total | ( C ) Labor Total | Hardware Total | Labor Sell | Hardware Sell |  | Totals Sell |  |  | Totals Cost
INTRUSION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Sell |  |  | Labor Cost
Sallyport |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hardware Sell |  |  | Hardware Cost
Intrusion keypad | 0
Spreadsheet: 374176d1422706933-sum-value-at-each-blank-cell-sum-value-at-blank
Sheet: Sample

Value | Required Sum Vaule Result
110
100
93.13297
81.53833
73.67305
67.17266
62.4084
58.32608
54.96524
70
 | 771.21673
99
77
54
63
55
65
93
55
64
47
23
 | 695
55
12
62
21
14
28
95
36
24
 | 347
Spreadsheet: 002ff8f7-34f1-4f75-ab90-dc7586af3484
Sheet: RLI-Other

Rate Level Indication Exhibit |  |  |  |  |  |  |  |  |  |  |  | RLI-Other
Insurance Company: |  | Insert Company Name
Program: |  | Insert Program Type
Effective Date: |  | MM/DD/YYYY
Coverage | [NAME]
Year | Earned Premium | Present Level Factor | Premium Trend Factor | Earned Premium at Current Rate Level | Accident Year Incurred Losses | LAE | Direct Incurred Loss Ratio | Loss Development Factor | Loss Trend Factor | Projected Accident Year Incurred Losses | Projected Loss Ratio | Individual Year Weights
Total
Weighted Projected Loss Ratio |  |  |  |  |  |  |  | Historical | Prospective
Fixed Expense Ratio |  |  |  |  |  | Premium Trend
Variable Expense Ratio |  |  |  |  |  | Loss Trend
Profit and Contingencies Provision |  |  |  |  |  | Net Trend
Indicated Change
Credibility Percentage
Complement of Credibility
Credibility Weighted Indicated Change
Insurer Notes:
Notes:
1. Provide South Carolina experience on a direct basis (gross of reinsurance)
2. Complete this exhibit for each Coverage and in total
3. A supporting exhibit establishing the credibility standard and how the complement of credibility value was calculated/selected is required
4. Complete this exhibit for each Program type being filed