tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 872509d1718882250-solved-12-month-rolling-count-if-formula-new-ncmr-log-temp
Sheet: Data Reference

 | Vendor Category: |  |  |  | Holiday Day | Holiday Date |  | Vendor Category for Suppliers Quality |  | Month for Suppliers Quality
 | 1 |  |  |  | 2024-12-25 00:00:00 | Christmas Day |  | ALL |  | 1
 | 2 |  |  |  | 2024-11-29 00:00:00 | Black Friday |  | 1 |  | 2
 | 3 |  |  |  | 2024-11-28 00:00:00 | Thanksgiving Day |  | 2 |  | 3
 | 4 |  |  |  | 2024-11-11 00:00:00 | Veterans Day |  | 3 |  | 4
 | 5 |  |  |  | 2024-10-14 00:00:00 | Columbus Day |  | 4 |  | 5
 | 6 |  |  |  | 2024-09-02 00:00:00 | Labor Day |  | 5 |  | 6
 |  |  |  |  | 2024-07-04 00:00:00 | Fourth of July |  | 6 |  | 7
 |  |  |  |  | 2024-06-19 00:00:00 | [NAME] |  |  |  | 8
 |  |  |  |  | 2024-05-27 00:00:00 | Memorial Day |  |  |  | 9
 |  |  |  |  | 2024-01-15 00:00:00 | [NAME] |  |  |  | 10
 |  |  |  |  | 2024-01-01 00:00:00 | New Years |  |  |  | 11
 |  |  |  |  | 2023-12-25 00:00:00 | Christmas Day |  |  |  | 12
 |  |  |  |  | 2023-11-24 00:00:00 | Black Friday
 |  |  |  |  | 2023-11-23 00:00:00 | Thanksgiving Day
 |  |  |  |  | 2023-11-10 00:00:00 | Veterans Day
 |  |  |  |  | 2023-10-09 00:00:00 | Columbus Day
 |  |  |  |  | 2023-09-04 00:00:00 | Labor Day
 |  |  |  |  | 2023-07-04 00:00:00 | Fourth of July
 |  |  |  |  | 2023-06-19 00:00:00 | [NAME]
 |  |  |  |  | 2023-05-29 00:00:00 | Memorial Day
 |  |  |  |  | 2023-01-16 00:00:00 | [NAME]
 |  |  |  |  | 2023-01-02 00:00:00 | New Years
 |  |  |  |  | 2022-12-31 00:00:00 | New Years
 |  |  |  |  | 2022-12-26 00:00:00 | Christmas Day
 |  |  |  |  | 2022-11-25 00:00:00 | Black Friday
 |  |  |  |  | 2022-11-24 00:00:00 | Thanksgiving Day
 |  |  |  |  | 2022-11-11 00:00:00 | Veterans Day
 |  |  |  |  | 2022-10-10 00:00:00 | Columbus Day
 |  |  |  |  | 2022-09-05 00:00:00 | Labor Day
 |  |  |  |  | 2022-07-04 00:00:00 | Fourth of July
 |  |  |  |  | 2022-06-20 00:00:00 | [NAME]
 |  |  |  |  | 2022-05-30 00:00:00 | Memorial Day
 |  |  |  |  | 2022-01-17 00:00:00 | [NAME]
 |  |  |  |  | 2021-12-24 00:00:00 | Christmas Day
 |  |  |  |  | 2021-11-26 00:00:00 | Black Friday
 |  |  |  |  | 2021-11-25 00:00:00 | Thanksgiving Day
 |  |  |  |  | 2021-11-11 00:00:00 | Veterans Day
 |  |  |  |  | 2021-10-11 00:00:00 | Columbus Day
 |  |  |  |  | 2021-09-06 00:00:00 | Labor Day
 |  |  |  |  | 2021-07-05 00:00:00 | Fourth of July
 |  |  |  |  | 2021-05-31 00:00:00 | Memorial Day
 |  |  |  |  | 2021-01-18 00:00:00 | [NAME]
 |  |  |  |  | 2021-01-01 00:00:00 | New Years
 |  |  |  |  | 2020-12-25 00:00:00 | Christmas Day
 |  |  |  |  | 2020-11-27 00:00:00 | Black Friday
 |  |  |  |  | 2020-11-26 00:00:00 | Thanksgiving Day
 |  |  |  |  | 2020-11-11 00:00:00 | Veterans Day
 |  |  |  |  | 2020-10-12 00:00:00 | Columbus Day
 |  |  |  |  | 2020-09-07 00:00:00 | Labor Day
 |  |  |  |  | 2020-07-03 00:00:00 | Fourth of July
 |  |  |  |  | 2020-05-25 00:00:00 | Memorial Day
 |  |  |  |  | 2020-01-20 00:00:00 | [NAME]
 |  |  |  |  | 2020-01-01 00:00:00 | New Years
Spreadsheet: 42787d1241443759-how-do-i-use-vlookup-for-multiple-occurrences-of-the-same-value-multiple-vlookup
Sheet: MAcro

2009-01-08 00:00:00 | 12 |  |  | 2009-02-08 00:00:00 | 15, 3, 6, 9, 14
2009-02-08 00:00:00 | 15
2009-02-08 00:00:00 | 3
2009-01-08 00:00:00 | 16
2009-01-08 00:00:00 | 5
2009-02-08 00:00:00 | 6
2009-01-08 00:00:00 | 7
2009-01-08 00:00:00 | 8
2009-02-08 00:00:00 | 9
2009-01-08 00:00:00 | 10
2009-01-08 00:00:00 | 11
2009-01-08 00:00:00 | 12
2009-01-08 00:00:00 | 13
2009-02-08 00:00:00 | 14
2009-01-08 00:00:00 | 15
2009-01-08 00:00:00 | 16
2009-01-08 00:00:00 | 17
2009-01-08 00:00:00 | 18
2009-01-08 00:00:00 | 19
2009-01-08 00:00:00 | 20
2009-01-08 00:00:00 | 21
2009-01-08 00:00:00 | 22
2009-01-08 00:00:00 | 245
2009-01-08 00:00:00 | 24
Spreadsheet: 879251d1726701055-excel-help-with-formula-to-get-values-from-another-column-example-file
Sheet: Sheet2

150mm - Retained Mass (g)
125mm - Retained Mass (g)
106mm - Retained Mass (g) | 0
75.0[NAME] (g)
63.0mm - Retained Mass (g) | 0
53.0[NAME] (g) | 1132.4
45.0mm - Retained Mass (g)
37.5mm - Retained Mass (g) | 19427.5
26.5mm - Retained Mass (g) | 7839.1
19.0mm - Retained Mass (g) | 927.6
16.0mm - Retained Mass (g)
13.2mm - Retained Mass (g)
12.5mm - Retained Mass (g)
9.5mm - Retained Mass (g) | 6.5
6.7mm - Retained Mass (g)
4.75mm - Retained Mass (g)
2.36mm - Retained Mass (g)
Spreadsheet: 804833d1668389193-convert-7-hours-30-minutes-7-30-to-1-work-day-time-date-calculator-update
Sheet: Sheet1

Days | Hours:Minutes |  |  |  | Days | Hours:Minutes
1 | 2:00:00 |  |  |  |  | 3:30:00
4 | 5:00:00 |  |  |  |  | 1:00:00
1 | 3:30:00 |  |  |  | 1 | 3:00:00
3 |  |  |  |  |  | 2:00:00
 | 4:30:00 |  |  |  |  | 2:00:00
3 | 1:00:00 |  |  |  |  | 2:00:00
1 | 5:00:00 |  |  |  |  | 6:00:00
Days | Hours:Minutes
 | 2:00:00
1 | 0:30:00
1 | 0:30:00
 | 3:30:00
 | 0:30:00
 | 1:30:00
 | 1:00:00
 | 0:30:00
 | 0:30:00
 | 0:30:00
 |  |  | 3 days and 3 hours 30 minutes
Spreadsheet: 677718d1589482664-lookup-column-a-for-the-maximum-value-until-a-certain-value-is-reached-in-column-b-excel-help
Sheet: Sheet1

official_rating | placing_numerical | Prev Rating
0 | 1 | 74
0 | 2 | 74
0 | 3 | 74
74 | 4 | 74
0 | 5 | 74
0 | 6 | 74
0 | 7 | 74
76 | 1 | 76
75 | 2 | 76
0 | 3 | 76
0 | 4 | 76
0 | 5 | 76
0 | 6 | 76
0 | 7 | 76
0 | 8 | 76
0 | 9 | 76
0 | 10 | 76
0 | 11 | 76
0 | 12 | 76
0 | 13 | 76
0 | 14 | 76
0 | 15 | 76
0 | 16 | 76
0 | 17 | 76
0 | 18 | 76
80 | 1 | 93
92 | 2 | 93
81 | 3 | 93
88 | 4 | 93
78 | 5 | 93
76 | 6 | 93
77 | 7 | 93
93 | 8 | 93
75 | 9 | 93
71 | 10 | 93
80 | 11 | 93
82 | 12 | 93
77 | 13 | 93
92 | 14 | 93
80 | 1 | 92
92 | 2 | 92
86 | 3 | 92
85 | 4 | 92
84 | 5 | 92
80 | 6 | 92
80 | 7 | 92
80 | 8 | 92
80 | 9 | 92
Spreadsheet: 79364d1279641699-excel-2007-summing-up-words-and-convert-to-numbers-scorecard-challenge
Sheet: February

 |  |  |  |  | McOpCo SCORECARD CHALLENGE
 |  |  |  |  |  | FEBRUARY 2010
Key performance Indicators |  |  | Below Target (0) | Slightly Below Target (1) |  | Meets or Exceeds Target (2) |  | Outstanding (3) |  |  |  |  | Below Target
 |  |  |  |  |  |  |  |  |  |  |  |  | Slightly Below
Restuarants |  | 400 North |  | Cookstown |  | Maple |  | [NAME] |  | Rutherford |  |  | Meets or Exceeds
 |  |  |  |  |  |  |  |  |  |  |  |  | Outstanding
Performance
Guest Counts
Sales vs. Last year
Build Your Peak
People
Crew Commitment
90 Day Terms(T6M)
Conv. and [NAME].
Late Night G.C
Drive Thru G.C
CSO
CSO (T6M)
[NAME] TET
Dine In TET
KVS Times
Mornings and Coffee
Morning G.C
Coffee Unit Growth
Profit
Food (vs. [NAME])
Food (FOB T3M)
Labour TPMH
Labour ACR
Labour (TPMH T3M)
P.A.C
Spreadsheet: 781658d1653471142-calculate-time-of-arrival-with-if-condition-based-on-departure-test-2
Sheet: Sheet1

Date | Departure | Destination | Truck nr | Planned hr for truck to load | Departure hr | Nr of hr from C to D | Estimated hr of arrival to store
 | BAIA MARE | SATU MARE | B400TBL | 11:00:00 | 12:00:00 | 01:45:00 |  |  |  |  | Unloadin time at 1st store
 | CAMPUS CALAN | BAIA MARE | B400TBL | 11:00:00 | 12:00:00 | 08:00:00 |  |  |  |  | 02:00:00
 | CAMPUS CALAN | [NAME] | B401TBL | 11:00:00 | 12:00:00 | 04:00:00
 | CAMPUS CALAN | TG.MURES ISTORIC | B402TBL | 11:00:00 | 12:00:00 | 05:00:00
 | [NAME] | [NAME] | B403TBL | 12:00:00 | 13:00:00 | 01:30:00
 | CAMPUS CALAN | [NAME] | B403TBL | 14:00:00 | 15:00:00 | 04:00:00
 | CAMPUS CALAN | TG.MURES [NAME] | B404TBL | 14:00:00 | 15:00:00 | 05:00:00
 | CAMPUS CALAN | ORADEA | B405TBL | 13:00:00 | 14:00:00 | 05:00:00
 | CAMPUS CALAN | CLUJ NORD | B406TBL | 15:00:00 | 16:00:00 | 04:00:00
 | CAMPUS CALAN | CLUJ ISTORIC | B407TBL | 16:00:00 | 17:00:00 | 04:00:00
 | CAMPUS CALAN | [NAME] | B408TBL | 17:00:00 | 18:00:00 | 01:00:00
 | CAMPUS CALAN | BUZIAS | B409TBL | 21:00:00 | 22:00:00 | 04:00:00
 | CAMPUS CALAN | TURDA | B410TBL | 21:00:00 | 22:00:00 | 04:00:00
Spreadsheet: 64273d1265141248-search-tabs-and-return-results-kc_environmental_aspects-1-
Sheet: Process - Activity 15

Operating Condition | Process Evaluated | process 15 | Date |  |  | Enter Date |  | Team | 0
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 0 | 0 | 6 | Yes
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
Spreadsheet: 725675d1616784598-auto-populate-values-from-raw-data-using-multiple-criteria-sheetscreenshot
Sheet: Sheet1

Date | Symbol | Type | Sector | MANUAL | CLOSE | H1 | H2 | H3 | H4 | H5 | DAY
2021-02-17 00:00:00 | TEMP | BEST | FMCG |  | 100 | 104 | 99 | 109 | 106 | 102 | 3
 | 2021-02-17 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-19 00:00:00 | 2021-02-22 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-24 00:00:00
Symbol | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH | CLOSE | HIGH
TEMP | 100 | 200 | 101 | 104 | 95 | 99 | 102 | 109 | 101 | 106 | 98 | 102
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: Greater Taree C242

DGB20 for Greater Taree
 | % Passing Sieve |  |  |  |  |  |  | % Passing | Greater Taree C242 |  | RMS Specification |  | Deviation | % Retained | [NAME] |  | Deviation | Result | Spec
Sieve mm | 20mm Roadbase | White Roadbase | Pit Fines | 10mm | Crun 210513 | Ammd 20mm Scalps | ROSA | Blend Result | Passing Lower | Passing Upper | Passing Lower | Passing Upper | Passing | Blend Result | Lower | Upper | Retained | ABC
26.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
19 | 99 | 100 | 100 | 100 | 99 | 100 | 100 | 99.4 | 95 | 100 | 95 | 100 | 0 | 0.5999999999999943
13.2 | 87 | 86 | 100 | 100 | 89 | 90 | 100 | 89.4 | 78 | 92 | 78 | 92 | 0 | 10 | 6 | 18 | 0
9.5 | 74 | 68 | 100 | 87 | 75 | 72 | 100 | 78 | 63 | 83 | 63 | 83 | 0 | 11.40000000000001 | 7 | 17 | 0
6.7 | 62 | 54 | 100 | 28 | 59 | 57 | 100 | 68 | 50 | 70 | 50 | 70 |  |  | 10 | 21
4.75 | 52 | 42 | 100 | 7 | 45 | 46 | 100 | 59.6 | 44 | 64 | 44 | 64 | 0 | 18.4 | 13 | 25 | 0
2.36 | 32 | 29 | 100 | 2 | 26 | 30 | 100 | 45 | 35 | 55 | 33 | 49 | 0 | 14.6 | 7 | 19 | 0
0.425 | 11 | 17 | 65 | 0 | 8 | 8 | 100 | 23 | 14 | 23 | 14 | 23 | 0 | 22 | 14 | 30 | 0 | 51.11111111111111 | 35-55
0.075 | 5.5 | 12 | 35 | 0 | 3 | 4 | 100 | 12.7 | 7 | 14 | 7 | 14 | 0 | 10.3 | 6 | 13 | 0 | 55.21739130434782 | 35-55
0.0135 | 3.5 | 6 | 17 | 0 | 1 | 2 | 40 | 6.7 | 3 | 7 | 3 | 7 | 0 | 5.999999999999999 | 3 | 8 | 0 | 52.75590551181103 | 35-60
PI | 0 | 7 | 0 |  |  |  |  | 1.034782608695652 | 1 | 3 | 2 | 6 | 0
Ratio | 60 | 20 | 20 | 0 | 0 | 0 | 0 | 100 | Min CBR | 100
 |  |  |  |  |  |  |  |  | Note: Pre-treatment required
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: Newsbank

Newsbank (Readex)
2009-2010
COUNTER-Compliant?: | Yes (R2)
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
American State Papers, 1789-1838 |  |  |  |  |  |  |  |  |  |  |  |  |  | Access fee only
Searches run | 2 | 0 | 0 | 4 | 0 | 0 | 1 | 0 | 8 | 1 | 0 | 0
Sessions | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
Serial Set Maps |  |  |  |  |  |  |  |  |  |  |  |  |  | Access fee only
Searches run | 1 | 0 | 0 | 5 | 6 | 0 | 1 | 0 | 36 | 5 | 0 | 7
Sessions | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
U.S. Congressional Serial Set 1817-1994 |  |  |  |  |  |  |  |  |  |  |  |  |  | Access fee only
Searches run | 3 | 58 | 51 | 48 | 14 | 12 | 0 | 12 | 89 | 65 | 0 | 2
Sessions | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
Total for Service Newsbank |  |  |  |  |  |  |  |  |  |  |  |  |  | Access fee only
Searches run | 19 | 60 | 52 | 74 | 43 | 12 | 6 | 287 | 133 | 81 | 0 | 19
Sessions | 17 | 55 | 28 | 78 | 42 | 30 | 11 | 47 | 93 | 68 | 14 | 18
Spreadsheet: 109891d1306710424-monthly-rollup-of-data-5-27-11
Sheet: Non Routine Flare Event

 |  |  |  |  |  | Prod. Date: | 2011-05-26 00:00:00
Is Flare Lit? | Yes |  | No
Hrs. Flare was [NAME]
Complete the following whenever there is a Non-Routine flare event
Note: Each Non Routine flare event requires a report!
Time Flare Started |  |  | am / pm
Is Flare Lit? | Yes |  | No
Was Flare Smoking? | Yes |  | No
Time Flare Stopped |  |  | am / pm
Signature of Person completing this report:
NOTE: If there was visible smoke for more than 5 minutes in a 120- minute period , Or if
The flare was [NAME] for any period complete the shaded areas.
Reason For Deviation:
Gas Volume Flared while Deviation Occurred emissions were present: |  |  |  |  |  |  | MCF
Make Verbal Contact With Someone from the list below so that the report may be filed with ADEM
[NAME](251) 454-4355 or (251) 331-2921
[NAME](251) 605-2325 or (251) 660-8292
[NAME](251) 404-3997 or (251) 679-0760
Corrective Action or Reccomendations:
Name of Chevron HES Representative Notified:
Chevron Employee completing this section:
Spreadsheet: 084e0e9d-8364-41d5-97f4-80999d8cc316
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 31. LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413975X | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413976A | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413977C | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413978F | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413979J | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413980T | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413981V | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413982W | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413983X | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413984A | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413985C | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413986F | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413987J | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413988K | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413989L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413990W | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 788377d1658423500-inserting-row-above-table-changes-formulas-despite-structured-references-sampleproblem
Sheet: Key data

Codes | Description
A01 | Description 1
A02 | Description 2
A03 | Description 3
A04 | Description 4
A05 | Description 5
A06 | Description 6
A07 | Description 7
A08 | Description 8
A09 | Description 9
A10 | Description 10
Spreadsheet: 825946d1681671625-refer-to-cell-search-sheet-column-for-refer-cell-including-other-cell-book4-notpaidtodothis-
Sheet: Sheet2

 | field compleated | desk compleated
job 1
job 2
job 1
job 5
job 2
job 5
Spreadsheet: 878766d1726048045-add-price-ranges-to-a-working-index-match-formula-index-match
Sheet: Sheet1 (2)

Item | Maj | Cat | Price | Code | IF using price too |  |  |  | Maj | Cat | Min Price | [NAME] | Code
0243 | ACC | 110 | 81 |  |  |  |  |  | ACC | 110 | 1 | 99 | A
0097 | ACC | 110 | 150 |  | Should return B |  |  |  | ACC | 110 | 100 | 199.99 | B
3318 | ACC | 110 | 84 |  |  |  |  |  | ACC | 110 | 200 | 1000 | C
4481 | ACC | 110 | 225 |  | Should return C |  |  |  | ARMS | 110 | 1 | 59 | A
3149 | ACC | 110 | 230 |  | Should return C |  |  |  | ARMS | 110 | 60 | 99.99 | E
4477 | ACC | 110 | 235 |  | Should return C |  |  |  | ARMS | 110 | 100 | 1000 | H
9387 | ACC | 110 | 99 |  |  |  |  |  | ARMS | 130 | 1 | 1000 | A
5816 | ACC | 110 | 115 |  | Should return B |  |  |  | ARRO | 110 | 1 | 1000 | D
6702 | ARMS | 110 | 42 |  |  |  |  |  | ARRO | 140 | 1 | 1000 | J
6669 | ARMS | 130 | 127 |  |  |  |  |  | ATLA | 110 | 1 | 1000 | E
6668 | ARMS | 110 | 65 |  | Should return E |  |  |  | ATLA | 130 | 1 | 1000 | F
6662 | ARMS | 110 | 115 |  | Should return H
6716 | ARMS | 110 | 131 |  | Should return H
S261 | ARRO | 110 | 66
S244 | ARRO | 110 | 75
S257 | ARRO | 140 | 83
0090 | ATLA | 110 | 49
0070 | ATLA | 130 | 44
Spreadsheet: 59705d1260284537-extract-lookup-from-another-worksheet-tester-database-dec09
Sheet: Sheet1

Business Name | Contact Name | Phone Number | Postcode | Date Received |  | Salesperson | Area Sales Manager | Status | Comment
Make Me Up | [NAME] | 02476 210172 | CV6 6BE | 2009-11-07 00:00:00 | E | [NAME] | [NAME] | Pending | Awaiting Objections
Fix it up [NAME] | [NAME] | 01454 415521 | BS35 4GB | 2009-12-07 00:00:00 | A | [NAME] | Nikki Turner TB | Pending | Awaiting Objections
Dodgy mech LTD | [NAME] smith | [PHONE] | B23 6HH | 2009-12-07 00:00:00 | A | [NAME] | [NAME] | Pending | Awaiting Objections
Spreadsheet: 860742d1708724892-countifs-sumifs-help-book3
Sheet: RawData

Project | Contact | Task | Confidence
Applesauce | Logistics | Task_51 | Missed
Applesauce | Logistics | Task_52 | Missed
Applesauce | Logistics | Task_53 | Complete
Applesauce | Logistics | Task_54 | Low
Applesauce | Logistics | Task_55 | Medium
Applesauce | Logistics | Task_56 | Low
Applesauce | Logistics | Task_57 | High
Applesauce | Tech Support | Task_58 | High
Applesauce | Tech Support | Task_59 | High
Applesauce | Tech Support | Task_60 | High
Applesauce | Tech Support | Task_61 | Low
Applesauce | Tech Support | Task_62 | Medium
Applesauce | Tech Support | Task_63 | Missed
Applesauce | Tech Support | Task_64 | Complete
Applesauce | Corporate | Task_65 | Complete
Applesauce | Corporate | Task_66 | Missed
Applesauce | Corporate | Task_67 | Missed
Applesauce | Corporate | Task_68 | Medium
Applesauce | Corporate | Task_69 | Low
Applesauce | Corporate | Task_70 | Low
Applesauce | Corporate | Task_71 | High
Applesauce | Sales | Task_72 | Medium
Applesauce | Sales | Task_73 | Medium
Applesauce | Sales | Task_74 | Low
Applesauce | Sales | Task_75 | High
Applesauce | Sales | [NAME] | Complete
Applesauce | Sales | Task_77 | Missed
Applesauce | Sales | Task_78 | Missed
Spreadsheet: 139767d1328455153-copying-data-from-one-source-to-a-blank-page-ina-given-period-ssp-mst-maintenance
Sheet: 2012

Equipment | Task No | Comp Code | Mod Code | Job Desc Code | MST Desc 1 | MST Desc 2 | [NAME] | Unit Required | Unit of Work | MST Type | Sched Ind | Work Group | Std Job No | LPD | LSD | NSD | Segment From | Segment To | Segment UOM | Assign To
[NAME] | 0 | 0 | 0 | 0 | BS7671: ELECTRICAL INSTALLATION TEST | 0 | 1820 | 1 | EA | 1 | 1 | DFPPREA | 10000 | 0 | 2007-02-28 00:00:00 | 2012-02-22 00:00:00 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | LOW VOLTAGE AC INSTALLATION G EXAM | 0 | 728 | 1 | EA | 1 | 1 | DFPPREA | 10190 | 0 | 2010-08-24 00:00:00 | 2012-08-23 00:00:00 | 0 | 0 | 0 | 0
MNT00005 | 0 | 0 | 0 | 0 | TRANSFORMER-SIGNAL SUPPLY-LV-MTCE [A] | 0 | 364 | 1 | EA | 1 | 1 | DFPPREA | 3416 | 0 | 1900-01-01 00:00:00 | 2012-04-16 00:00:00 | 0 | 0 | 0 | 0
MNT00006 | 0 | 0 | 0 | 0 | TRANSFORMER-SIGNAL SUPPLY-LV-MTCE [A] | 0 | 364 | 1 | EA | 1 | 1 | DFPPREA | 3416 | 0 | 1900-01-01 00:00:00 | 2012-04-16 00:00:00 | 0 | 0 | 0 | 0
MNT00008 | 0 | 0 | 0 | 0 | TRANSFORMER-SIGNAL SUPPLY-LV-MTCE [A] | 0 | 364 | 1 | EA | 1 | 1 | DFPPREA | 3416 | 0 | 2011-02-24 00:00:00 | 2012-02-23 00:00:00 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | TRANSFORMER-SIGNAL SUPPLY-LV-MTCE [A] | 0 | 364 | 1 | EA | 1 | 1 | DFPPREA | 3416 | 0 | 2011-02-24 00:00:00 | 2012-02-23 00:00:00 | 0 | 0 | 0 | 0
MNT00010 | 0 | 0 | 0 | 0 | TRANSFORMER-SIGNAL SUPPLY-LV-MTCE [A] | 0 | 364 | 1 | EA | 1 | 1 | DFPPREA | 3416 | 0 | 2011-01-24 00:00:00 | 2012-01-23 00:00:00 | 0 | 0 | 0 | 0
Spreadsheet: 221326d1363470234-using-if-function-in-conjuction-with-sum-help-cash-management1
Sheet: Sheet1

Date | Description | Revenue | Expense | Balance
 |  |  |  | 650
2012-10-01 00:00:00 | cat food |  | 8.5
2012-10-02 00:00:00 | cell phone |  | 90
2012-10-03 00:00:00 | wages | 1400
2012-10-04 00:00:00 | gym membership |  | 60
2012-10-04 00:00:00 | rent |  | 800
2012-10-05 00:00:00 | book purchase |  | 50
2012-10-15 00:00:00 | groceries |  | 150
2012-10-16 00:00:00 | dining out |  | 60
2012-10-17 00:00:00 | movies |  | 20
2012-10-18 00:00:00 | wages | 1400
2012-10-19 00:00:00 | directv |  | 60
2012-10-20 00:00:00 | tuition payment |  | 500
2012-10-21 00:00:00 | savings |  | 300
2012-10-22 00:00:00 | money payback |  | 100