tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 375873d1423388519-need-help-cleaning-up-pasted-text-and-comparing-two-lists-packingnotecomparison
Sheet: Paste Packing Note

Open packing-slip-template.pdf mark everything by pressing ctrl-a and paste in the yellow field below with ctrl-v
Date:
Quantity  2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I have no idea which is the best way to go about this, the packing notes are always from the same supplier and do always look the same even
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if the number of articles and pages varies. Do i need to make a macro to clean it up? On the next sheet is the desired result.
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I don't want it to be to much work because everybody at work should be able to do this…
8
15
Packed By:
Signature
My Company name [NAME] My company slogan
Ship To: Shipping Address: (If [NAME]) februari 8, 2015 [Name] [Name] Customer ID: [ABC12345] [Company Name] [Company Name] Order Date [Street Address] [Street Address] Purchase Order # [100001] [City, ST  ZIP Code] [City, ST  ZIP Code] Salesperson [NAME] [Phone] [Phone] Packing Date
Description 394948271 Mega Candy 123jkhgjh
[PHONE] Fatboy sugarbomb hkjsdhjfkhsdf
[PHONE] Fatboy sugarbomb hkjsdhjfkhsdf WAYS OF SENDING A PACKING SLIP TO A CLIENT
Do not send an Excel Packing Slip file to your clients, use PDF converter/printer to create a PDF file, that can be sent to clients via email, alternative method is to print it and send by mail service.
[PHONE] High sugar no vitamins drink 1234545
Special Notes Total Quantity of Goods/Boxes
[Name]
Checked By: [Managers Name] Thank you for your business! [Managers Signature]
Should you have any enquiries concerning this packing slip or your goods, please contact [NAME] on [PHONE] 111 Street, Town/City, County, ST, [NAME]: [PHONE] Fax: [PHONE] E-mail: [EMAIL] Web: www.yourcompanysite.com
Spreadsheet: 35209d1232738897-drop-down-list-filtering-data-sheet
Sheet: selections

 | NBA
 | CONFERENCE | REGION | TEAM | W
1 | WEST | PACIFIC | LAKERS
2 | WEST | SOUTHWEST | ROCKETS
3
4
5
6
7
8
9
10
Spreadsheet: kim_ward__20758__price indications_april_23_2001
Sheet: Sheet1

Price Indications for the City of Pasadena
2001-04-23 00:00:00
 |  |  | Socal | SP-15
 |  | Nymex | Basis | On-Peak | SP-15 RTC
2001-05-01 00:00:00 |  | 5.13 | 9 | 315 | 237
2001-06-01 00:00:00 |  | 5.19 | 8.9 | 335 | 262
2001-07-01 00:00:00 |  | 5.25 | 8.7 | 400 | 324
2001-08-01 00:00:00 |  | 5.33 | 8.7 | 470 | 376
2001-09-01 00:00:00 |  | 5.34 | 8.7 | 290 | 246
2001-10-01 00:00:00 |  | 5.36 | 7.25 | 230 | 199
2001-11-01 00:00:00 |  | 5.52 | 7 | 160 | 150
2001-12-01 00:00:00 |  | 5.67 | 7.25 | 180 | 160
2002-01-01 00:00:00 |  | 5.72 | 7.68 | 135 | 109
2002-02-01 00:00:00 |  | 5.52 | 6.75 | 118 | 99
2002-03-01 00:00:00 |  | 5.28 | 5.25 | 118 | 98
2002-04-01 00:00:00 |  | 4.84 | 3.05 | 95 | 84
2002-05-01 00:00:00 |  | 4.69 | 2.7 | 96 | 84
2002-06-01 00:00:00 |  | 4.74 | 2.3 | 114 | 98
2002-07-01 00:00:00 |  | 4.74 | 2.3 | 182 | 148
2002-08-01 00:00:00 |  | 4.75 | 2.8 | 197 | 157
2002-09-01 00:00:00 |  | 4.74 | 2.79 | 137 | 120
2002-10-01 00:00:00 |  | 4.76 | 1.98 | 104 | 88
2002-11-01 00:00:00 |  | 4.89 | 2.05 | 74 | 68
Cal 2002 |  | 4.94 | 3.5 | 126 | 100
Cal 2003 |  | 4.44 | 1.15 | 70 | 64
Cal 2004 |  | 4.37 | 0.6 | 68 | 59
Cal 2005 |  | 4.37 | 0.57 | 62 | 54
Cal 2006 |  | 4.39 | 0.55 | 59 | 52
Cal 2007 |  | 4.43 | 0.54 | 59 | 53
Cal 2008 |  | 4.48 | 0.53 | 59 | 53
Cal 2009 |  | 4.54 | 0.53 | 60 | 54
Cal 2010 |  | 4.62 | 0.52 | 60 | 54
Cal 2011 |  | 4.7 | 0.44 | 61 | 54
Q3, 2001 |  | 5.34 | 8.7 | 412
May 01-Apr 02 |  | 5.33 | 6.88 | 250 | 200
Spreadsheet: 619645d1554984321-rota-in-excel-formula-for-creating-daily-overview-based-on-shifts-times-rota-example
Sheet: Daily

Enter Date Here | 6-2 | 7-3 | 8-4 | 9-5 | 10-6 | 12-8 | 1-9 | 2-10 | 3-11 | 4-12 | 5-11 | 6-11
 | Advisor 5 | Advisor 18 | Advisor 4 | Advisor 8 | Advisor 2 | Advisor 1 | Advisor 19 | Advisor 10 |  | Advisor 16
 |  |  |  | Advisor 12 | Advisor 6 | Advisor 14
 |  |  |  |  | Advisor 13
 |  |  |  |  | Advisor 17
06/05/19 used as example
Spreadsheet: 864144d1711449046-using-if-and-or-functions-example-for-formula
Sheet: Sheet1

 | Main Variables Table | MCS^ | Samsung |  |  |  |  |  |  |  | Samsung ASHP Maximum Heating Capacity
 | Size of Heat Pump |  | 16 | kW |  |  |  |  |  |  |  | 35°C | 40°C | 45°C | 50°C
 | No of Bedrooms |  | 4 | rooms |  |  |  |  |  |  | 5kW | 4.98 |  | 4.64 | 4.44
 | Flow temp in HW mode |  | 50 | °C |  |  |  |  |  |  | 8kW | 7.21 | 6.98 | 6.75 | 6.36
 | HP capacity in HW mode |  | 0 | kW |  |  |  |  |  |  | 12kW | 11.52 | 11.25 | 10.96 | 10.42
 | COP in HW mode |  |  | SPF |  |  |  |  |  |  | 16kW | 14.04 | 13.66 | 13.29 | 12.38
 | Flow temp in Space Heat mode |  | 35 | °C |  |  |  |  |  |  | 8 + 16kW
 | HP capacity in Space Heat mode |  |  | kW |  |  |  |  |  |  | 16 + 16kW
 | COP in Space Heat mode |  |  | SPF |  |  |  |  |  |  | 8 + 16 + 16kW
 | Marginal Electricity Cost | 28.6 |  | p/kWh |  |  |  |  |  |  | 3 x 16kW
 | Running mode for CH pump |  |  | (hrs) |  |  |  |  |  |  | 4 x 16kW
 | Power CH Pump | 105 |  | W
 |  | ^based on Samsung figures, excluding COP
Spreadsheet: 6d7fcbd6-ac97-43de-8e19-abd7c355de56
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
BLUE | Test | BLUE | Blueberry, IgE | Blueberry, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel	 [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BLUE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BLUE | Result | BLUE | Blueberry, IgE | Blueberry, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7152-2 | Vaccinium [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 678886d1590099033-timesheet-with-rules-team-weekly-times-ww21-rev
Sheet: Option

WW21 | Friday |  |  |  | Saturday | Sunday | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Weekly Hours
Name | In | Out | Lunch | Hours |  |  | In | Out |  | Hours | In | Out |  | Hours | In | Out |  | Hours | In | Out |  | Hours
[NAME] | 07:27:00 | 14:59:00 | Y |  |  |  | 07:27:00 | 17:57:00 | Y |  | 07:32:00 | 18:53:00 | Y |  | 07:30:00 | 17:20:00 | Y |  | 07:34:00 | 18:30:00 | Y
[NAME] | 08:00:00 | 17:00:00 | Y |  |  |  | 08:00:00 | 17:00:00 | Y |  | 08:00:00 | 17:14:00 | Y |  | 08:00:00 | 17:00:00 | Y |  | 08:00:00 | 17:00:00 | Y
[NAME] | 08:00:00 | 17:30:00 | Y |  |  |  | 08:00:00 | 17:00:00 | Y |  | 08:00:00 | 17:00:00 | Y |  | 08:00:00 | 17:00:00 | Y |  | 13:00:00 | 17:00:00 | N
[NAME] | 07:50:00 | 17:15:00 | Y |  |  |  | 07:50:00 | 17:15:00 | Y |  | 07:50:00 | 17:15:00 | Y |  | 07:50:00 | 17:15:00 | Y |  | 08:00:00 | 14:59:00 | Y
[NAME] | 07:00:00 | 16:22:00 | Y |  |  |  | 08:13:00 | 21:15:00 | Y |  | 08:07:00 | 17:56:00 | Y |  | 08:01:00 | 17:11:00 | Y |  | 08:05:00 |  | Y
Ricardo Cardoso | 07:54:00 | 17:39:00 | Y |  |  |  | 07:58:00 | 18:09:00 | Y |  | 08:04:00 | 17:54:00 | Y |  | 08:00:00 | 18:17:00 | Y |  | 07:56:00 |  | Y
Hours worked = total time - 30 mins [NAME] break (should be built in)
If In OR Out times not entered then hours  = 0
If In AND Out times not entered then hours  = 0
If hours worked exceed 8.5 hours, then hours = 8.5
Spreadsheet: 59d69d3b-41bc-4456-acd7-7172520c60fd
Sheet: Table 1.3

Monthly Statistical Bulletin
1.3 Labour force
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Labour force (a) – '000
July | 11620.9110433 | 11818.045483 | 12017.0499131 | 12160.1483609 | 12350.8039969
August | 11601.1908152 | 11818.6457499 | 12034.9415374 | 12149.338028 | 12349.0571992
September | 11628.1476534 | 11855.8114235 | 12053.6545058 | 12214.6480621 | 12338.4059304
October | 11634.3510873 | 11911.1473927 | 12049.8989719 | 12205.8094233 | 12348.5253838
November | 11655.7945083 | 11956.103946 | 12067.6230598 | 12212.7828057
December | 11687.384356 | 11930.2608083 | 12027.21917 | 12228.0290979
January | 11697.0011456 | 11907.0515504 | 12055.631715 | 12289.0875651
February | 11709.7027825 | 11960.4428946 | 12073.9520305 | 12313.1368992
March | 11731.3872472 | 11994.3473495 | 12128.5721449 | 12304.3332739
April | 11753.1152193 | 11958.3447512 | 12096.6515451 | 12344.6163102
May | 11717.6309419 | 11958.603678 | 12158.4516118 | 12336.4570149
June | 11774.0145006 | 11992.0566239 | 12134.0653677 | 12367.9772323
Annual average | 11682.48306658333 | 11924.44913458334 | 12073.47079758333 | 12256.82264330833
Participation rate (a) (b) – per cent
July | 65.5182055 | 65.5079531 | 65.5727511 | 65.2337292 | 65.0858629
August | 65.298754 | 65.4305831 | 65.591489 | 65.0794244 | 64.9850163
September | 65.3422442 | 65.5561757 | 65.6155637 | 65.3330219 | 64.8381893
October | 65.2915656 | 65.7850591 | 65.5081555 | 65.1989642 | 64.7912055
November | 65.3263351 | 65.9550392 | 65.5170764 | 65.149098
December | 65.4179052 | 65.7356223 | 65.2113767 | 65.1439514
January | 65.3614411 | 65.4974046 | 65.2535351 | 65.3500719
February | 65.3215777 | 65.6882495 | 65.2407803 | 65.3586461
March | 65.332671 | 65.7721281 | 65.4241138 | 65.1934702
April | 65.3785803 | 65.4932124 | 65.1640676 | 65.3192731
May | 65.1054947 | 65.4125876 | 65.4088296 | 65.1886386
June | 65.3438911 | 65.5142576 | 65.1899808 | 65.2678689
Annual average | 65.33655545833332 | 65.61235602500001 | 65.39147663333334 | 65.234679825
(a) Monthly figures are seasonally adjusted.
(b) Labour force as a proportion of the civilian population aged 15 years and over. |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6202.0 |  |  |  |  |  |  |  | 2013-12-12 00:00:00
Spreadsheet: 710221d1608781662-duplicated-row-lookup-and-update-the-corresponding-columns-lookup_duplicated_update
Sheet: Before

 | ServerA | ServerB | ServerC
A | Y
B | Y
C | Y
D | Y
E | Y
A |  | Y
B |  | Y
D |  | Y
E |  |  | Y
F |  |  | Y
G |  |  | Y
C
D
G
Spreadsheet: 866264d1713223166-converting-american-odds-to-decimal-odds-with-if-formula-converting-american-odds-to-decimal-odds
Sheet: Sheet1

KELLY CRITERION
BETTING BANKROLL | [NAME]
200 | 0.1
 | MONEYLINE | DECIMAL ODDS | WIN% | WAGER
[NAME] | 166 |  | 0.3673
New York Yankees | -195 |  | 0.7461139896373057
(SOLUTION)
 | MONEYLINE | DECIMAL ODDS | WIN% | WAGER
[NAME] | -200 |  | 0.3673
New York Yankees | 250 |  | 0.7461139896373057
Spreadsheet: 111511d1307892447-summarising-data-from-multiple-worksheets-cashbook-sample
Sheet: Report Example

EXPENDITURE
Report Filter | OH18PD
Budget Header | Transaction Type | Paid To | Description | Amount |  | Helper Column
Subscriptions
Research & Development B/PAY
Sundries Cash
Russia Day
Parcels
Breakdown cover
 |  |  | Total
Spreadsheet: mary_fischer__25434__SS May Monthly Logs
Sheet: SCADA

GE Wind Maintenance Corp.
Site:     Sommerset
DATE:  6/01/02
SCADA MALFUNCTION LOG MAY 2002
Pad |  | Date | Date | Time | Time | Elapsed
Location | Description - Fault Indication/Activity | Begin | End | Begin | End | Hours
 | NONE
Scada problems that result in the loss of data which could effect availability.
Spreadsheet: louise_kitchen__24093__NEWCO HEADCOUNT NAMES
Sheet: Gas Settlements

Gas Settlements |  | ok
[NAME] | Mgr
[NAME] | Mgr
[NAME] | Mgr
[NAME] | Mgr
[NAME] | Mgr | 5
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
Priscilla Hamic | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
Wade Price | Spec | 12
[NAME] | Sr. [NAME] | 1
[NAME] | Sr. Spec
[NAME] | Sr. Spec | 2
[NAME] | Staff | 1
Spreadsheet: michelle_lokay__26570__imbalsumm0012
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 173271 | 176394
2 | 177225 | 188500
3 | 173559 | 172558
4 | 189185 | 195274
5 | 184869 | 181847
6 | 191676 | 192336
7 | 214250 | 217025
8 | 196255 | 195210
9 | 199789 | 197970
10 | 196513 | 203483
11 | 190798 | 188209
12 | 199342 | 206944
13 | 209774 | 206540
14 | 230821 | 227895
15 | 200667 | 215379
16 | 201563 | 211642
17 | 204380 | 221578
18 | 175953 | 170000
19 | 187798 | 175000
20 | 192800 | 192648
21 | 206330 | 212027
22 | 209500 | 205536
23 | 199462 | 199399
24 | 199184 | 199221
25 | 203753 | 200522
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | 0
2000-12-25 00:00:00
Spreadsheet: 885373d1734883970-if-a-cell-does-not-contain-either-abc-or-xyz-therefore-display-123-sample-unit
Sheet: Sheet1

 | Item List | Units | Number of Items | Single Price | Total Price
 | abc | pcs | 10 |  |  |  |  | abc | 1
 | xyz | pcs | 2 |  |  |  |  | bcd | 1
 | lmo | pcs | 3 |  |  |  |  | cde | 5
 | hij | pcs | 5 |  |  |  |  | def | 2
 |  |  |  |  |  |  |  | efg | 3
 |  |  |  |  |  |  |  | fgh | 4
 |  |  |  |  |  |  |  | ghi | 6
 |  |  |  |  |  |  |  | hij | 0.5
Spreadsheet: 132255d1323649035-formula-help-needed-leagues-2012
Sheet: LH Series

Shows
Driver |  | [NAME]
Derek | [NAME] | Bonnie & Clyde | S
[NAME] | [NAME] |  | S
Carole | Davenport | Wait & See | S
[NAME] | Eldridge | Mix & Match | S
[NAME] | [NAME] | Bobbie & Dazzler | S
Christine | Legate-Baggs | His & Hers | S
[NAME] | Litchfield | G & T | S
[NAME] | Marson | Gower Boys | S
[NAME] | Morris | Chalk & Cheese | S
[NAME] | Morris | Posh & Becks | S
[NAME] | Scott | Beauty & The Beast | S
Philippa | Scott | Wallace & Gromit | S
[NAME] | Sycamore |  | S
[NAME] | Sycamore |  | S
[NAME] |  | Jekyle & Hyde | S
Derek | [NAME] | Judge & Jury | L
[NAME] | Bean | Dun & Dusted | L
[NAME] | Eldridge | Just & Do It | L
[NAME] | [NAME] |  | L
[NAME] | Kinsella | Samson & Delilah | L
Christine | Legate-Baggs |  | L
[NAME] | Litchfield | Thunder & Lightning | L
[NAME] | Marson | [NAME] | L
Shelbie | McCullock | Pixie & Dixie | L
[NAME] | Morris | Suited & Booted | L
[NAME] | Mountain | Song & Dance | L
[NAME] | Scott | [NAME] | L
Philippa | Scott |  | L
[NAME] | Scott | Smokey & The Bandit | L
Trevor | Fairburn | Bangers & Mash
Trevor | Fairburn
[NAME] | Scott
Spreadsheet: 832048d1686076681-map-values-dynamic-arrays-color2
Sheet: Feuil1

color1 (ignore) | [NAME] (ignore) | color3 (ignore) |  | color (ignore) | abbreviation (ignore) |  |  | color | abbreviation |  | color1 | [NAME] | color3 |  | abbreviation (expected result, as spilling array)
black | white | yellow |  | black | B |  |  |  |  |  |  |  |  |  | B,W,Y
yellow | white |  |  | yellow | Y |  |  | yellow | Y |  | yellow | white |  |  | Y,W
blue | yellow | black |  | white | W |  |  | white | W |  | blue | yellow | black |  | B,Y,B
 |  |  |  | blue | B |  |  | blue | B
Spreadsheet: 437638d1451429141-weighted-average-for-totals-in-pivot-table-book2
Sheet: Sheet2

Row Labels | Count of Amount | Average of Contracts | Sum of per contract
Category1 | 56 | 109 | 0.06307339449541284
February | 28 | 104 | 0.06146978021978022
September | 28 | 114 | 0.06453634085213032
Grand Total | 56 | 109 | 0.06307339449541284
Spreadsheet: 858769d1707328552-copy-matching-cell-copy-church-name
Sheet: Copy Church Name

List 1 | List 2 | List 2 Church Name | Last Name | First Name |  |  |  |  |  |  |  |  |  |  |  |  | Copy Church Name from List 2
16193 | 16552 | ChurchBMC | A | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Church HS
 | 18718 |  | W | [NAME]
17092 |  |  | A | Irmgard |  |  |  |  |  |  |  |  |  |  |  |  | I want Church AMC to be copied here
 | 19121 |  | N | [NAME]
16215 |  |  | B | [NAME]
 | 17092 | Church AMC | S | Ravi
down to a 2000 | 2000 rows
Spreadsheet: 103356d1301084557-formatting-cftwoweeksand-yes
Sheet: Sheet1

2011-02-28 00:00:00 | 2011-03-16 00:00:00 | 2011-04-12 00:00:00 | 1 |  |  |  |  |  |  | Yes
2011-03-09 00:00:00 | 2011-03-27 00:00:00 | 2011-02-23 00:00:00 | 0 |  | Press F9 to do [NAME] |  |  |  |  | No
2011-03-12 00:00:00 | 2011-04-02 00:00:00 | 2011-04-24 00:00:00 | 1 |  |  |  |  |  |  | Yes
2011-04-21 00:00:00 | 2011-04-09 00:00:00 | 2011-02-24 00:00:00 | 0 |  |  |  |  |  |  | No
2011-04-04 00:00:00 | 2011-02-25 00:00:00 | 2011-02-24 00:00:00 | 1 |  |  |  |  |  |  | Yes
2011-03-26 00:00:00 | 2011-04-22 00:00:00 | 2011-04-14 00:00:00 | 0 |  |  |  |  |  |  | No
2011-03-05 00:00:00 | 2011-04-02 00:00:00 | 2011-03-09 00:00:00 | 1 |  |  |  |  |  |  | Yes
2011-04-21 00:00:00 | 2011-03-26 00:00:00 | 2011-02-26 00:00:00 | 0 |  |  |  |  |  |  | No
Spreadsheet: 41105d1239632469-excel-2007-nested-if-problem-os09
Sheet: batting totals

Name | GAMES | AT Bats | RUNS | T HITS | HITS | 2B | 3B | HR | RBI | T BASES | BB | SO | SB | CS | [NAME] | SB % | OB % | SLG. % | BAVG | SF | SH | HBP | Int. BB | GDP | TPA | NP | XBH | GO | FO | GO/FO | OPS | BB % | HOME RUN RATIO | ISO POWER | RUNS CREATED | STRIKEOUT RATIO | SB RUNS
ANDINO
FREEL
HUFF
IZTURIS
JONES
MARKAKIS
MOELLER
MORA
PIE
[NAME]
SCOTT
WIGGINTON
ZAUN
 | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________ | ________
Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Spreadsheet: 852598d1702574262-calculating-inflation-adjusted-trailing-returns-trailing-returns
Sheet: Annual Inflation Rate

Year | CPI-Total | Monthly Inflation
2018 | 0.02442583296928093
2019 | 0.01812210075260523
2020 | 0.01233584396306047
2021 | 0.04697858863638052
2022 | 0.08002799820520314
2023 | 0.035
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
2054
2055
2056
2057
2058
2059
2060
2061
2062
2063
2064
2065
2066
2067
2068
2069
2070
2071
2072
2073
2074
2075
Notes
Annual average CPI rates (non-seasonally adjusted) were obtained from the Federal Reserve Economic Data (FRED): https://fred.stlouisfed.org/series/CPALTT01USA661S
Spreadsheet: 549384d1511643902-color-formatting-based-on-completion-and-date-conditionalformatting
Sheet: Data

Today | 2017-11-23 00:00:00
Risk Level | Status | Responsible | Due Date | Percentage Complete | Months | Row | Color |  |  |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
High | Open | Team 1 | 2017-12-31 00:00:00 | 0.7 |  |  |  |  |  |  | Green |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Medium | Open | Team 1 | 2017-11-30 00:00:00 | 0.7 |  |  |  |  |  |  | Yellow
Medium | Open | Team 3 | 2018-01-31 00:00:00 | 0.5 |  |  |  |  |  |  | Orange
Medium | Open | Team 2 | 2018-02-28 00:00:00 | 0.9 |  |  |  |  |  |  | Red
Low | Open | Team 1 | 2018-04-30 00:00:00 | 0.75
Low | Open | Team 3 | 2018-03-31 00:00:00 | 0.6
High | Open | Team 3 | 2018-04-30 00:00:00 | 0.8
 |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 268554d1380684821-formulas-for-search-based-on-multiple-criteria-in-multiple-columns-book1
Sheet: Sheet1

LINE | CTYPE | POD | weight st | WEIGHT end | AMT
apl | 20' | NHS | 0 | 13000 | 1234
apl | 40' | NHS | 0 | 9999 | 2233
apl | 40' | NHS | 10000 | 25000 | 4455
apl | 20' | PIP | 0 | 13000 | 4321
apl | 40' | PIP | 0 | 9999 | 3322
apl | 40' | PIP | 10000 | 25000 | 5544
apl | 20' | NHS | 13001 | 20000 | 5678
apl | 20' | PIP | 13001 | 20000 | 8765
hamburg | 20' | PIP | 0 | 15000 | 1500
oocl | 20' | NHS | 0 | 10000 | 2468
oocl | 20' | NHS | 10001 | 20000 | 1357
oocl | 40' | NHS | 0 | 24000 | 7654
oocl | 20' | PIP | 0 | 10000 | 500
oocl | 20' | PIP | 10001 | 20000 | 1000
oocl | 40' | PIP | 0 | 24000 | 4567
Spreadsheet: 82814d1282830213-max-min-function-for-alpha-vendor-summary
Sheet: Sheet1

Roster |  |  |  |  |  | Desired Output
[NAME] |  |  |  |  |  | Braylon Edwards
[NAME] |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Derrel Revi$
 |  |  |  |  |  | [NAME]
Derrel Revi$ |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  | [NAME]
Braylon Edwards
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
[NAME]
Derrel Revi$
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
[NAME]
Derrel Revi$
[NAME]
[NAME]
[NAME]
Braylon Edwards
[NAME]
[NAME]
[NAME]
Braylon Edwards
Spreadsheet: 847086d1698172042-how-to-add-the-content-of-cell-to-the-next-empty-cell-if-cell-contains-a-specifc-string-how-to-select-independent-claims
Sheet: Sheet1

Actual data set 900 rows | Actual data set up to 90 columns
 |  |  |  |  |  |  |  |  |  |  | Outcome
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | A module | the module | the module | the module | A system | The system | The system | A method | The method | The method
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Desired
 | A module | the module | the module | the module | A system | The system | The system | A method | The method | The method | A module | A system | A method
 | Independent | Dependent | Dependent | Dependent | Independent | Dependent | Dependent | Independent | Dependent | Dependent
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Perfect
 | A module | the module | the module | the module | A system | The system | The system | A method | The method | The method | A module | A system | A method
Spreadsheet: 689553d1596512091-finding-all-tornado-outbreaks-on-a-particular-day-along-with-stats-for-that-event-finding-outbreaks
Sheet: Sheet1

Data Table
 |  |  |  |  |  |  |  |  |  | Month | Date |  | # of occurrence of date
Month | Day | Year | Number of Tornadoes | Injuries | Deaths |  |  |  | Select Date | 8 | 1
8 | 1 | 1950 | 1 | 0 | 5
8 | 2 | 1951 | 1 | 0 | 1
8 | 1 | 1952 | 2 | 0 | 0 |  |  |  | Result Table
8 | 1 | 1953 | 2 | 0 | 7
8 | 1 | 1954 | 3 | 0 | 8 |  |  |  | Occurrences | Month | Day | Year | # of Tornadoes | Injuries | Deaths
8 | 2 | 1955 | 3 | 15 | 0
8 | 2 | 1956 | 4 | 0 | 0
8 | 2 | 1957 | 4 | 0 | 0
7 | 1 | 1958 | 1 | 22 | 0
7 | 2 | 1959 | 2 | 17 | 0
7 | 1 | 1960 | 3 | 13 | 2
7 | 2 | 1961 | 4 | 14 | 3
7 | 1 | 1962 | 5 | 0 | 1
7 | 1 | 1963 | 3 | 0 | 4 |  |  |  | Desired Result Table
7 | 2 | 1964 | 2 | 0 | 5
7 | 2 | 1965 | 1 | 1 | 0 |  |  |  | Occurrences | Month | Day | Year | # of Tornadoes | Injuries | Deaths
7 | 2 | 1966 | 7 | 2 | 0 |  |  |  | 4 | 8 | 1 | 1950 | 1 | 0 | 5
 |  |  |  |  |  |  |  |  | 3 | 8 | 1 | 1952 | 2 | 0 | 0
 |  |  |  |  |  |  |  |  | 2 | 8 | 1 | 1953 | 2 | 0 | 7
 |  |  |  |  |  |  |  |  | 1 | 8 | 1 | 1954 | 3 | 0 | 8
Spreadsheet: 168849d1342607510-calculate-time-between-dates-with-conditions-example-sheet
Sheet: Example

Application # | Create date | Create time | Check date | Check time | Time took to review | Time considering weekends | 1900-01-02 00:00:00 | 1900-01-01 00:00:00
#1 | 2012-06-01 00:00:00 | 23:02:57 | 2012-06-04 00:00:00 | 08:45:13 | 1900-01-02 09:42:16
#2 | 2012-06-01 00:00:00 | 22:24:08 | 2012-06-04 00:00:00 | 08:38:51 | 1900-01-02 10:14:43
#3 | 2012-06-01 00:00:00 | 22:10:32 | 2012-06-04 00:00:00 | 08:14:46 | 1900-01-02 10:04:14
#4 | 2012-06-01 00:00:00 | 21:56:37 | 2012-06-04 00:00:00 | 07:58:19 | 1900-01-02 10:01:42
#5 | 2012-06-01 00:00:00 | 21:20:40 | 2012-06-04 00:00:00 | 07:51:07 | 1900-01-02 10:30:27
#6 | 2012-06-01 00:00:00 | 20:41:30 | 2012-06-04 00:00:00 | 07:44:42 | 1900-01-02 11:03:12
#7 | 2012-06-01 00:00:00 | 20:10:13 | 2012-06-04 00:00:00 | 07:18:45 | 1900-01-02 11:08:32
#8 | 2012-06-01 00:00:00 | 19:46:53 | 2012-06-04 00:00:00 | 07:41:20 | 1900-01-02 11:54:27
#9 | 2012-06-01 00:00:00 | 19:45:47 | 2012-06-04 00:00:00 | 07:31:43 | 1900-01-02 11:45:56