tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a2050792-7a7a-4659-ba69-70c8f4896fef
Sheet: Sheet1

Bid Request Number | RFB1012005195 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Organization | Iowa Procurement Services Division
Title | Performance Friction Brake Pads and Rotors for the Iowa State Patrol |  |  |  | Bid Creator | Ryan  Roovaart Purchasing Agent 3
Description |  |  |  |  | [NAME] | [EMAIL]
Bid Type | RFB |  |  |  | Phone | (515) 281-5602
Open Date | 1/18/2012 3:45:00 PM Central |  |  |  | Fax | (515) 725-0162
Close Date | 2/7/2012 3:00:00 PM Central
Responding Suppliers
Name | City | State | Response Submitted
[NAME] | Des Moines | IA | 1/24/2012 11:47:41 AM CST
O?Reilly Auto Parts | Springfield | MO | 1/31/2012 3:38:39 PM CST
Peterbilt of Des Moines | Altoona, Iowa | IA | 1/26/2012 7:49:59 AM CST
Johnson Industries, Inc. | Norcross | GA | 2/6/2012 12:17:40 PM CST
American Moving Parts LLC | Los Angeles | CA | 1/20/2012 2:24:01 PM CST
Factory Motor Parts | denver | CO | 1/31/2012 3:54:43 PM CST
Harts Auto Supply LLC | Omaha | NE | 2/1/2012 3:28:47 PM CST
Response Notes
Supplier | Notes
O?Reilly Auto Parts | Pricing per WSCA Contract.
Peterbilt of Des Moines | Website may contain a typo in your system.It should be www.pbtruck.comThanks
Factory Motor Parts | Iowa State Patrol will be serviced out of our Des Moines Iowa location
Spreadsheet: 103162d1300971591-excel-2007-how-to-convert-ex-8-4-30-into-total-hours-week-ending-3-26-11
Sheet: Sheet1

WEEK ENDING MARCH 26, 2011
NAME | TIME | MON | TUE | WED | THURS | FRI | SAT | TOTAL
[NAME] (started 3/21/11) | Reg | 8-4:30 | 8-4:30 | 8-4:30
 | O.T.
[NAME] (started 3/21/11) | Reg | 8-4:30 | 8-4:30 | 8-4:30 | 8-4:30
 | O.T.
[NAME] (started 3/22/11) | Reg |  | 8-4:30 | 8-4:30 | 8-4:30
 | O.T.
[NAME] (started 3/22/11) | Reg |  | 8-4:30 | Out | 8-4:30
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
 | Reg
 | O.T.
Spreadsheet: 51cdfb6b-d092-4c7f-9fb4-ee5f20448c09
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
[NAME] | Women's Tennis | Air Force Tournament | 12:00 AM | Results
[NAME] | Women's Tennis | Air Force Tournament | 12:00 AM | Results
09/29/2013 | Women's Tennis | Air Force Tournament | 12:00 AM | Results
10/04/2013 | Women's Tennis | University of Akron | 12:00 AM | Results
10/05/2013 | Women's Tennis | University of Akron | 12:00 AM | Results
10/06/2013 | Women's Tennis | University of Akron | 12:00 AM | Results
10/18/2013 | Women's Tennis | ITA Regional (Charlottesville, Va.) | 12:00 AM | Results
10/19/2013 | Women's Tennis | ITA Regional (Charlottesville, Va.) | 12:00 AM | Results
10/20/2013 | Women's Tennis | ITA Regional (Charlottesville, Va.) | 12:00 AM | Results
10/21/2013 | Women's Tennis | ITA Regional (Charlottesville, Va.) | 12:00 AM | Results
11/01/2013 | Women's Tennis | Big Green Invite (Hanover, N.H.) | 12:00 AM | Results
11/02/2013 | Women's Tennis | Big Green Invite (Hanover, N.H.) | 12:00 AM | Results
11/03/2013 | Women's Tennis | Big Green Invite (Hanover, N.H.) | 12:00 AM | Results
01/17/2014 | Women's Tennis | Akron | 12:00 AM | L, 4-3
01/25/2014 | Women's Tennis | Liberty | 12:00 AM | L, 6-1
02/01/2014 | Women's Tennis | at [NAME] | 12:00 AM | L, 6-1
02/07/2014 | Women's Tennis | Cal PA | 12:00 AM | W, 5-2
02/14/2014 | Women's Tennis | Richmond (Norfolk, Va.) | 12:00 AM | L, 4-1
02/15/2014 | Women's Tennis | at ODU | 12:00 AM | L, 6-1
02/21/2014 | Women's Tennis | University of Charleston | 12:00 AM | W, 6-1
[NAME] | Women's Tennis | Buffalo | 12:00 AM | L, 5-2
03/02/2014 | Women's Tennis | at Penn State | 12:00 AM | L, 6-1
03/08/2014 | Women's Tennis | Cornell | 02:00 PM | 2 p.m.
03/09/2014 | Women's Tennis | West Virginia State University | 12:00 PM | Noon
03/14/2014 | Women's Tennis | Kansas State | 01:00 PM | 1 p.m.
03/16/2014 | Women's Tennis | Kansas | 11:00 AM | 11 a.m.
03/21/2014 | Women's Tennis | at Baylor | 05:00 PM | 5 p.m.
03/23/2014 | Women's Tennis | at Texas | 12:00 PM | Noon
[NAME] | Women's Tennis | Texas Tech | 01:00 PM | 1 p.m.
03/30/2014 | Women's Tennis | TCU | 10:00 AM | 10 a.m.
04/04/2014 | Women's Tennis | at Oklahoma | 05:00 PM | 5 p.m.
04/06/2014 | Women's Tennis | at Oklahoma State | 12:00 PM | Noon
04/13/2014 | Women's Tennis | Iowa State | 11:00 AM | 11 a.m.
04/24/2014 | Women's Tennis | Big 12 Championship (Fort Worth, Texas) | 12:00 AM | All Day
04/25/2014 | Women's Tennis | Big 12 Championship (Fort Worth, Texas) | 12:00 AM | All Day
04/26/2014 | Women's Tennis | Big 12 Championship (Fort Worth, Texas) | 12:00 AM | All Day
04/27/2014 | Women's Tennis | Big 12 Championship (Fort Worth, Texas) | 12:00 AM | All Day
Spreadsheet: 176003d1345703616-substituting-values-from-one-column-to-another-on-specific-condition-challenge1
Sheet: Sheet1

Contig ID | Sequence
Contig1
Contig1
Contig1
Contig2
Contig2
Contig2
Contig3
Contig3
Contig9
Contig9
Contig9
Contig12
Contig12
Contig12
 |  | Sequence to be adjusted(in column B)
 |  | AcgtagcataAGCT
 |  | AGCtaACGATgat
 |  | acgTAGTAA
 |  | AGCtaACGATgat
 |  | AGCtaACGATgat
Spreadsheet: 760099d1639994617-one-to-one-many-to-one-one-to-many-formula-copy-of-sample-book-1-2226-1-
Sheet: old

Origin code | Destination code | expected | Revised | Check
307210000 | 307211000 | One to One
307210011 | 307211010 | Many to One
307210011 | 307211010 | Many to One
307210019 | 307211010 | One to One
307210091 | 307211090 | Many to One
307210091 | 307211090 | Many to One
307210099 | 307211091 | One to Many
307210099 | 307211092 | One to Many
Spreadsheet: 67342d1267968304-excel-2007-descriptive-statistics-descriptive
Sheet: Sheet1

 | Descriptive statistics
 | FEMALE |  |  |  | MALE
 |  | €/month |  |  |  | €/month
 | count | 57 |  |  | count | 43
 | mean | 1477.46 |  |  | mean | 1566.28
 | standard deviation | 273.08 |  |  | standard deviation | 394
 | minimum | 1180 |  |  | minimum | 1200
 | maximum | 2500 |  |  | maximum | 2790
 | range | 1320 |  |  | range | 1590
 | skewness | 1.54 |  |  | skewness | 1.66
 | kurtosis | 2.55 |  |  | kurtosis | 2.18
 | coefficient of variation | 0.185 |  |  | coefficient of variation | 0.2521
 | 1 st quartile | 1290 |  |  | 1 st quartile | 1290
 | median | 1400 |  |  | median | 1450
 | 3rd quartile | 1620 |  |  | 3rd quartile | 1670
 | interquartile range | 330 |  |  | interquartile range | 380
 | mode | 1290 |  |  | mode | 1290
Spreadsheet: 87672d1287563092-retrieve-values-in-another-workbook-based-on-conditions-no-vba-example-sheet
Sheet: Sheet1

File 1 |  |  |  |  |  |  |  | File 2
Team | Action | Action | Name | Date | Status |  |  | Result Team 1
TEAM 1 | Sport | Organise Tennis | [NAME] | 2010-01-01 00:00:00 | DONE
TEAM 1 | Sport | Workshop | [NAME] | 2010-01-02 00:00:00 | DONE |  |  | Action | Date | Status
TEAM 1 | Sport | Implement | [NAME] | 2010-01-03 00:00:00 | DONE |  |  | Sport | 2010-01-01 00:00:00 | DONE
TEAM 1 | Sport | Play | [NAME] | 2010-01-04 00:00:00 | DONE |  |  | Game | 2010-02-06 00:00:00 | ONGOING
TEAM 1 | Game | Organise Chess | Jan | 2010-02-03 00:00:00 | DONE
TEAM 1 | Game | Workshop | Jan | 2010-02-04 00:00:00 | DONE
TEAM 1 | Game | Implement | Nass | 2010-02-05 00:00:00 | DONE
TEAM 1 | Game | Play | Nass | 2010-02-06 00:00:00 | ONGOING
TEAM 2 | Game | Organise Chess | Jan | 2010-02-03 00:00:00 | DONE
TEAM 2 | Game | Workshop | Jan | 2010-02-04 00:00:00 | DONE
TEAM 2 | Game | Implement | Nass | 2010-02-05 00:00:00 | DONE
TEAM 2 | Game | Play | Nass | 2010-02-06 00:00:00 | NOT STARTED |  |  | Result Team 2
TEAM 2 | Sport | Organise Tennis | [NAME] | 2010-01-01 00:00:00 | DONE
TEAM 2 | Sport | Workshop | [NAME] | 2010-01-02 00:00:00 | DONE |  |  | Action | Date | Status
TEAM 2 | Sport | Implement | [NAME] | 2010-01-03 00:00:00 | DONE |  |  | Sport | 2010-01-04 00:00:00 | CANCELLED
TEAM 2 | Sport | Play | [NAME] | 2010-01-04 00:00:00 | CANCELLED |  |  | Game | 2010-02-06 00:00:00 | NOT STARTED
 |  | Sheet in File 2 retrieves values Action-Date-Status
 |  | based on "TEAM" & "PLAY" of sheet in File 1
 |  | (No [NAME] please, thanks !!!)
Spreadsheet: 884534d1733760665-search-an-array-but-return-only-certain-cells-lee-test-2
Sheet: Summary

Summary
Name | Full Quote |  |  |  | Drawing Only, Drawing & Budget |  |  |  | Total
 | Quantity | Equiv Total | [NAME] | Workload % | Quantity | Equiv Total | [NAME] | Workload % | Quantity | Workload %
[NAME]
Charlotte
Jo
Mat R
Monika
Total
Spreadsheet: 846499d1697664011-sum-month-sum-month-jacc
Sheet: Sum

 |  | Planilha2 | Planilha3 |  | Month
 | 2021-01-01 00:00:00 |  |  |  | 2021-01-01 00:00:00 |  |  |  |  | https://www.excelforum.com/excel-general/1413798-sum-month.html
 | 2021-02-01 00:00:00 |  |  |  | 2021-02-01 00:00:00
 | 2021-03-01 00:00:00 |  |  |  | 2021-03-01 00:00:00
 | 2021-04-01 00:00:00 |  |  |  | 2021-04-01 00:00:00
 | 2021-05-01 00:00:00 |  |  |  | 2021-05-01 00:00:00
 | 2021-06-01 00:00:00 |  |  |  | 2021-06-01 00:00:00
 | 2021-07-01 00:00:00 |  |  |  | 2021-07-01 00:00:00
 | 2021-08-01 00:00:00 |  |  |  | 2021-08-01 00:00:00
 | 2021-09-01 00:00:00 |  |  |  | 2021-09-01 00:00:00
 | 2021-10-01 00:00:00 |  |  |  | 2021-10-01 00:00:00
 | 2021-11-01 00:00:00 |  |  |  | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00 |  |  |  | 2021-12-01 00:00:00
 | 2022-01-01 00:00:00 |  |  |  | 2022-01-01 00:00:00
 | 2022-02-01 00:00:00 | 0 | 0 |  | 2022-02-01 00:00:00
 | 2022-03-01 00:00:00 | 0 | 0 |  | 2022-03-01 00:00:00
 | 2022-04-01 00:00:00 | 0 | 0 |  | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00 | 0 | 0 |  | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00 | 0 | 0 |  | 2022-06-01 00:00:00
 | 2022-07-01 00:00:00 | 0 | 0 |  | 2022-07-01 00:00:00
 | 2022-08-01 00:00:00 | 0 | 0 |  | 2022-08-01 00:00:00
 | 2022-09-01 00:00:00 | 0 | 0 |  | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00 | 0 | 0 |  | 2022-10-01 00:00:00
 | 2022-11-01 00:00:00 | 0 | 0 |  | 2022-11-01 00:00:00
 | 2022-12-01 00:00:00 | 0 | 0 |  | 2022-12-01 00:00:00
 | 2023-01-01 00:00:00 | 0 | 0 |  | 2023-01-01 00:00:00
 | 2023-02-01 00:00:00 | 0 | 0 |  | 2023-02-01 00:00:00
 | 2023-03-01 00:00:00 | 0 | 0 |  | 2023-03-01 00:00:00
 | 2023-04-01 00:00:00 | 0 | 0 |  | 2023-04-01 00:00:00
 | 2023-05-01 00:00:00 | 0 | 0 |  | 2023-05-01 00:00:00
 | 2023-06-01 00:00:00 | 0 | 0 |  | 2023-06-01 00:00:00
 | 2023-07-01 00:00:00 | 0 | 0 |  | 2023-07-01 00:00:00
 | 2023-08-01 00:00:00 | 0 | 0 |  | 2023-08-01 00:00:00
 | 2023-09-01 00:00:00 | 0 | 0 |  | 2023-09-01 00:00:00
 | 2023-10-01 00:00:00 | 0 | 0 |  | 2023-10-01 00:00:00
 | 2023-11-01 00:00:00 | 0 | 0 |  | 2023-11-01 00:00:00
 | 2023-12-01 00:00:00 | 0 | 0 |  | 2023-12-01 00:00:00
Spreadsheet: 92300d1291907611-different-layout-of-a-table-book22_a
Sheet: Sheet1

Source table |  |  |  |  |  | Target table
CODE | 1 | 2 | 3 | 4 |  | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
12 | 56 | 33 | 44 | 30 |  | 56 | 33 | 44 | 30
13 | 88 | 94 | 15 | 10 | 1 |  | 88 | 94 | 15 | 10
17 | 99 | 55 | 88 | 0 |  |  |  |  |  |  | 99 | 55 | 88 | 0
12 | 101 | 200 | 0 | 0 |  | 101 | 200 | 0 | 0
16 | 35 | -3 | 98 | 40 |  |  |  |  |  | 35 | -3 | 98 | 40
14 | 22 | 16 | 19 | -5 |  |  |  | 22 | 16 | 19 | -5
1) The Range from G1 and to the right will always be the highest value in column A, In the above example: 17+4-1=20
2) The sets of 4 values should be placed in the target table while the starting point is under the appropriate code.
3) The issue can easily be solved with a macro but I'm curious if it can be accomplished with a sheet formula.
4) Some receptive of codes can occur (like #12) and column A is and will not be sorted.
Spreadsheet: 754197d1636016325-google-sheets-counting-occurrence-in-conjunction-with-name-on-multiple-sheets-google-sheets-help
Sheet: Nov Pipeline

Prospects & Pipeline - NOVEMBER
First Name | Last name | IG Handle | [NAME] | Phone Number | Source | Sales Owner | Messaged | Form Sent | Call Booked | Call Date - DD/MM/YY | Closed Won/Lost | Follow Date (if NOT Closed Won) - DD/MM/YY | Membership | Price | AOB on Prospect (Reasons for Win/Loss/Follow up) | Has Prospect Been Added to Montly Pipeline if Follow up is in New Month?
 |  |  |  |  |  | ALLAN |  |  |  |  | CLOSED WON
 |  |  |  |  |  | ALLAN |  |  |  |  | CLOSED WON
 |  |  |  |  |  | SARAH |  |  |  |  | CLOSED WON
 |  |  |  |  |  | RYAN |  |  |  |  | CLOSED LOST
 |  |  |  |  |  | SARAH |  |  |  |  | CLOSED LOST
 |  |  |  |  |  | RYAN |  |  |  |  | CLOSED WON
 |  |  |  |  |  | ALLAN |  |  |  |  | CLOSED LOST
 |  |  |  |  |  | RYAN |  |  |  |  | CLOSED LOST
 |  |  |  |  |  | SARAH |  |  |  |  | CLOSED WON
 |  |  |  |  |  | SARAH |  |  |  |  | CLOSED WON
Spreadsheet: 647928d1572760948-sorting-using-formula-sort
Sheet: Sheet1

 |  | 10 B |  |  |  | SORTED DATA
Sl | Item | Name | Position |  |  | Item | Name | Position
1 | MAPPILAPPATTU (GIRLS) | FATHIMA BINSHIYA KT | 1
2 | MAPPILAPPATTU (BOYS) | DAVOOD IBRAHIM. [NAME] | 1
3 | MONO ACT (GIRLS) | FATHIMA RASMIYA P | 2
4 | VANCHIPATTU | DEVIKA.P | 2
5 | NADANPATTU | DEVIKA.P | 1
6 | NADANPATTU | JISHNA BUDHINI A | 2
7 | KATHAPRASANGAM | DEVIKA.P | 1
8 | PADYAM CHOLLAL - URDU | FATHIMA RASMIYA P | 1
9 | CHITHRA RACHANA - PENCIL | ABHIJITH E | 1
10 | CHITHRA RACHANA - PENCIL | MISHAL ALI KP | 3
11 | CHITHRA RACHANA - WATER COLOUR | ABHIJITH E | 1
12 | CHITHRA RACHANA - WATER COLOUR | MISHAL ALI KP | 3
13 | CHITHRA RACHANA - OIL COLOUR | ABHIJITH E | 2
14 | CARTOON | [NAME] | 1
15 | CARTOON | MISHAL ALI KP | 2
16 | CARTOON | MOHAMED NIHAD M | 3
17 | KAVITHARACHANA - MALAYALAM | RAGITHA RAJAN K | 2
18 | UPANYASAM - MALAYALAM | AMRUTHA. N.K | 1
19 | UPANYASAM - MALAYALAM | MUFEEDA K | 2
20 | SANGHA NRUTHAM (GIRLS) | ARYARAJ.P K | 1
21 | NADAKAM | FATHIMA BINSHIYA KT | 3
Spreadsheet: 221918d1363707991-using-a-combo-or-drop-down-list-test
Sheet: Sheet2

1 | CA [NAME] | H
2 |  | A
3
4 |  |  |  |  | This is an example of what I would like to see
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Spreadsheet: 704655d1605685409-sorting-cell-content-based-on-text-within-text-sorting-cell-content-based-on-text-within-text
Sheet: Sheet1

[NAME] | Sort order/Criteria | [NAME], but auto sorted correctly based on Column B's info
dpsiliulu01 | dll | dpsdllulu01 |  | Column B contains a string of text that exists in each cell on Column A. "dll" exists in A3, for example.  What I want is to basically sort A2, [NAME], and A4 using B2, B3 and B4 as a guide.  This would be output as seen on Column C.  Hopefully this is possible, thank you for any help you can provide!
dpsdllulu01 | rrr | dpsrrrulu01
dpsrrrulu01 | ili | dpsiliulu01
[NAME] |  | [NAME]
[NAME] |  | dpsrrrulu02
dpsrrrulu02 |  | [NAME]
dpsiliulu03 |  | dpsdllulu03
[NAME] |  | [NAME]
dpsdllulu03 |  | dpsiliulu03
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -908342
3531 | -493784 | -192208
60667 | -22936 | -1320780
60749 | 22379 | -60623
61206
61334 | -170352
62960
INDEX
2001-11-30 00:00:00 |  |  | 723510.56
2001-12-16 00:00:00
CBS Volume
 |  |  | 125165
Spreadsheet: 757219d1638125796-calculations-vlookup-social-fuel-excel-test-for-sem-
Sheet: Answer Sheet

 | DAC EXCEL TEST
 | 1. | Based on the July campaign report, on the campaign data tab - what campaign has the best efficiency?
 |  | a.
 | 2. | Based on the July campaign report - using a pivot table calculate the cost per lead for all campaigns. Have the pivot table to the right or share where the table can be found
 |  | a.
 | 3. | Using the table staring in cell P10, use a vlookup to pull clicks for the campaign "Example 3" |  |  |  |  |  |  |  |  |  |  |  |  | Campaign | Impr | Clicks | Cost
 |  | a. |  |  |  |  |  |  |  |  |  |  |  |  | Example 1 | 1000 | 400 | 900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example 2 | 800 | 280 | 630
 | 4. | Based on the July campaign report, on the campaign data tab - calculate the CPL for the east region |  |  |  |  |  |  |  |  |  |  |  |  | Example 3 | 1150 | 480 | 1080
 |  | a. |  |  |  |  |  |  |  |  |  |  |  |  | Example 4 | 880.0000000000001 | 313.6 | 705.6
 | 5. | Use a different method to calculate CPL for "Campaign - Midwest - WI"
 |  | a.
 | 6. | Based on both the July & August campaign reports, on the campaign data tab - calculate the variance of CTR for August vs July
 |  | a.
 | 7. | Using the keyword data make a chart showing trending clicks for the Account
 |  | a.
 | 8. | Looking at the ads in the ad upload tab, based on Google Expanded Text ad requirements - are there any ads that will be disapproved? If so, how many & why?
 |  | a
 | Bonus: | Create a macro  … Can be unique, solve one of the questions above, apply format, etc.
Spreadsheet: 0eb8e9d3-c397-4914-9e68-ae9b3653108f
Sheet: Sheet2

[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[NAME]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
Spreadsheet: 106976d1304107781-output-customer-name-for-a-specific-date-range-copy-of-sample2-1
Sheet: data

First Name | Last Name | Date |  |  |  |  |  |  |  | 2011-04-26 00:00:00
FName 1 | LName1 | 2011-04-19 00:00:00 |  |  |  |  |  |  |  | 2011-04-27 00:00:00
FName 2 | LName2 | 2011-04-02 00:00:00 |  |  |  |  |  |  | Date Range
FName 3 | LName3 | 2011-04-27 00:00:00
FName 4 | LName4 | 2011-04-19 00:00:00
FName 5 | LName5 | 2011-04-25 00:00:00
FName 6 | LName6 | 2011-04-26 00:00:00
FName 7 | LName7 | 2011-04-26 00:00:00
FName 8 | [NAME] | 2011-04-26 00:00:00
FName 9 | LName9 | 2011-04-27 00:00:00
FName 10 | [NAME] | 2011-04-19 00:00:00
FName 11 | [NAME] | 2011-04-27 00:00:00
FName 12 | LName12 | 2011-04-19 00:00:00
FName 13 | LName13 | 2011-04-18 00:00:00
FName 14 | [NAME] | 2011-04-27 00:00:00
Spreadsheet: 047d11d9-8ed7-44a7-a103-cf414a92a27e
Sheet: Daily_Spending

 |  |  |  | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | Month
Spreadsheet: 182950d1348665601-how-to-make-all-the-empty-cells-as-a-blank-cells-sample
Sheet: Sheet2

Click | Wait for (in secs) | [NAME] | className
Clear | Hit the URL | Check element is displayed | cssSelector
Check element is displayed | Close the driver | Check element is enabled | id
Check element is enabled | continue with the testcase | Check element is Selected | linkText
Check element is Selected | Delete all Cookies | Clear | name
Close the driver | Delete Cookie Named | Click | partialLinkText
Delete all Cookies | Navigate to back page | Close the driver | tagName
Navigate to back page | Navigate to forward page | continue with the testcase | xpath
Navigate to forward page | Refresh the page | Delete all Cookies
Refresh the page | Wait for new Window | Delete Cookie
Wait for new Window | Select last window opened | Delete Cookie Named
Select last window opened | Select parent window | Get Current URL
Select parent window | Get Current URL | Get Current Url and concat
Get Current URL | Verify Current URL contains | Get Current Url and replace
 | Verify Current URL equals | Get Current Url and Substring
 | Verify Current Ignorecase Equals | Hit the URL
 | Get Current Url and concat | Navigate to back page
 |  | Navigate to forward page
 |  | open replaced url
 |  | Refresh the page
 |  | Select last window opened
 |  | Select parent window
 |  | Type
 |  | Verify Current Ignorecase Equals
 |  | Verify Current URL contains
 |  | Verify Current URL equals
 |  | Verify Element Contains
 |  | Verify Element Equals
 |  | Wait for (in secs)
 |  | Wait for new Window
Spreadsheet: 682074d1591893954-lookup-based-on-conditions-lookup-based-on-conditions
Sheet: Sheet1

PRODUCT | COUNTRY | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 |  | PRODUCT | COUNTRY
AAA | UK | 100 | 200 | 300 | 400 | 500 |  | AAA
BBB | France | 0 | 0 | 700 | 800 | 0 |  | BBB
BBB | Germany | 900 | 1000 | 0 | 0 | 0 |  | CCC
CCC | Italy | 800 | 900 | 1000 | 1100 | 1200 |  | DDD
CCC | Belgium | 1700 | 1800 | 1900 | 2000 | 0
DDD | Spain | 1300 | 1400 | 1500 | 0 | 0
DDD | Portgugal | 0 | 0 | 0 | 1600 | 0
Spreadsheet: jeff_dasovich__14221__Wine case
Sheet: Sheet1

New Wine in Old Bottles Case
 |  |  |  | Entry | Continue
 |  |  |  | per 100 | per 100
 |  |  |  | Plastic | Steel
 | 1 | Direct Labour |  | 4.2 | 0
 | 2 | Direct Materials |  | 15.6 | 46.8
 | 3 | Variable Overhead |  |  | 37.44
 | 4 | Capital cost |  | 10000 | 0
 | 5 | Fixed Overhead |  |  | 56.16
 | 6 | Sales and Admin |  | 15.6 | 46.8
 |  | TOTAL
 |  | Q1 |  | per 100 units
 | (1+2+3+4) | Incremental Cost
 |  | first 100
 |  | Q2 |  | * | per 100 units
 |  | next 34,500
 |  | *assume materials is sunk cost for steel rings
 |  | Q3
 |  | Differential cost for steel already made is zero minus 1032.28
 |  | Differential cost between plastic and steel
 |  | Q4
 |  | What is more profitable, steel or plastic?
 |  |  |  | Entry | Continue
 |  |  |  | per 100 | per 100
 |  |  |  | Plastic | Steel
 | 1 | Direct Labour |  | 4.2 | 0
 | 2 | Direct Materials |  | 15.6 | 46.8
 | 3 | Variable Overhead |  |  | 37.44
 | 4 | Capital cost |  | 10000 | 0
 | 5 | Fixed Overhead |  |  | 56.16
 | 6 | Sales and Admin |  | 15.6 | 46.8
 |  | TOTAL
 |  | Case 1: Profitability of the first 100 plastic versus 100 steel inventory
 | per 100 | Selling Price |  | 325 | 325
 |  | Manufacturing Cost
 |  | Contribution Margin
Spreadsheet: 762800d1641828412-sumifs-criteria-matching-between-tables-help
Sheet: February

Project | Role | Resource | Reqd FTE
Bubble I | Manager | [NAME] | 0
Bubble II | Manager | [NAME] | 0.5
Bubble II | Deputy Manager | Lotus [NAME] | 0.5
Bubble II | Decorator | Emile Dunbar | 0.1
Bubble II | Gladiator | [NAME] | 0.3
Bubble II | Bagging | Nobody Inparticular | 0.1
Bubble II | Files | [NAME] | 0.1
Bubble II | Sales | Captain [NAME] | 0.2
Bubble III | Manager | [NAME] | 0.3
Bubble III | Gladiator | [NAME] | 0.1
Bubble III | Sales | Captain [NAME] | 0.1
Bubble III | Buyer | Ford Prefect | 0.1
Bubble IV | Manager | [NAME] | 0.3
Bubble IV | Horse Doctor | [NAME] | 0.05
Bubble IV | Gladiator | [NAME] | 0.2
Bubble IV | Sales | Captain [NAME] | 0.1
Bluenote | Manager | Horace Rumpole | 0.4
Bluenote | Horse Doctor | [NAME] | 0.05
Bluenote | Decorator | Emile Dunbar | 0.1
Bluenote | Grass | [NAME] | 0.05
Bluenote | Gladiator | [NAME] | 0.15
Bluenote | laundry | [NAME] | 0.1
Bluenote | Bagging | [NAME] | 0.2
Bluenote | Bagging | [NAME] | 0.2
[NAME] | Deputy Manager | Horace Rumpole | 0.2
[NAME] | Window [NAME] | [NAME] | 0.05
[NAME] | Decorator | [NAME] | 0.05
[NAME] | Fisherman | [NAME] | 0.1
[NAME] | Fisherman | [NAME] | 0.1
[NAME] | Grass | [NAME] | 0.05
[NAME] | Sales | Captain [NAME] | 0.05
[NAME] | Manager | Horace Rumpole | 0.2
[NAME] | Horse Doctor | [NAME] | 0.05
[NAME] | Painter | [NAME] | 0.05
[NAME] | Decorator | Emile Dunbar | 0.05
[NAME] | Fisherman | [NAME] | 0.1
[NAME] | Fisherman | [NAME] | 0.1
[NAME] | Grass | [NAME] | 0.05
[NAME] | Gladiator | [NAME] | 0.05
[NAME] | Files | [NAME] | 0.1
[NAME] | Sales | Captain [NAME] | 0.1
Crossflow | Manager | [NAME] | 0.6
Crossflow | Horse Doctor | [NAME] | 0.13
Crossflow | Window [NAME] | [NAME] | 0.13
Crossflow | Painter | [NAME] | 0.1
Crossflow | Decorator | [NAME] | 0.1
Crossflow | Gladiator | [NAME] | 0.2
Crossflow | Files | [NAME] | 0.07
Crossflow | Sales | Captain [NAME] | 0.07
Locomotive | Manager | Fred Davies | 0.4
Locomotive | Deputy Manager | [NAME] | 0.45
Locomotive | Horse Doctor | [NAME] | 0.1
Locomotive | Window [NAME] | [NAME] | 0.1
Locomotive | Painter | [NAME] | 0.1
Locomotive | Decorator | [NAME] | 0.1
Locomotive | Fisherman | [NAME] | 0.1
Locomotive | Grass | [NAME] | 0.1
Locomotive | Gladiator | [NAME] | 0.15
Locomotive | Files | [NAME] | 0.05
Locomotive | Sales | [NAME] | 0.05
Spreadsheet: 789597d1659207257-formula-for-checking-dates-in-range-book2
Sheet: Sheet1

Start | End | [NAME] | Date1 | Date2 | Date3
2022-05-16 00:00:00 | 2022-05-29 00:00:00 |  | 2022-05-02 00:00:00 | 2022-05-21 00:00:00
2022-05-20 00:00:00 | 2022-05-31 00:00:00 |  | 2022-05-15 00:00:00
2022-05-09 00:00:00 | 2022-05-15 00:00:00 |  | 2022-05-09 00:00:00 | 2022-05-07 00:00:00 | 2022-05-13 00:00:00