tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 766949d1644189157-need-help-with-a-formula-to-pull-data-from-worksheet-based-on-date-and-shift-to-monthreport-sample-worksheet-10-01-21
Sheet: Classification Worksheet

 | Specialist
# | Docket | Inmate | F | M | P | From | To | 98 | CIS | MV | Flags | 30/90 Day | PREA | Job Assign Moves | Job Assign CIS | [NAME]
1 | 1871993 | Jones, [NAME] |  |  |  | 2h1b | ew1 |  |  | x
2 | 1856316 | Jones, [NAME] |  |  |  | 4h3 | 4h2c |  |  | x | a
3 | 1841135 | Jones, [NAME] |  |  |  | jahosp | hdtemp |  |  | x
4 | 1875795 | Jones, [NAME] |  |  |  | 4h2a | 2h4b |  |  | x
5 | 1866126 | Jones, [NAME] |  |  |  | jahosp | hdtemp |  |  | x
6 | 1869023 | Jones, [NAME] |  |  |  | dw6 | dw6 |  | x
7 | 1853330 | Jones, [NAME] |  |  |  | cbar3 | cbar3 |  | x
8 | 1875412 | Jones, [NAME] |  |  |  | 3h1 | cbar2 | x |  | x | r
9 | 1872869 | Jones, [NAME] |  |  |  | 3h3 | gw9 | x |  | x | r
10 | 1867598 | Jones, [NAME] |  |  |  | 3h4a | ew6 | x |  | x | r
11 | 1841135 | Jones, [NAME] |  |  |  | hdtemp | 4h3 | x |  | x | a
12 | 1854707 | Jones, [NAME] |  |  |  | 3h4a | ew6 | x |  | x | r
13 | 1872731 | Jones, [NAME] |  |  |  | 3h4a | ew6 | x |  | x | r
14 | 1875785 | Jones, [NAME] |  |  |  | 2h2b | [NAME] | x |  | x | r
15 | 1875675 | Jones, [NAME] |  |  |  | 3h3 | 2f5 | x |  | x | r
16 | 1836082 | Jones, [NAME] |  |  |  | cwcc2 | 5fcc2 |  |  | x
17 | 1875360 | Jones, [NAME] |  |  |  | 3f1 | 2f5 |  |  | x
18 | 1874328 | Jones, [NAME] |  |  |  | 2h1b | 2h1b |  | x
19 | 1852529 | Jones, [NAME] |  |  |  | ew1 | 4h2b | x |  | x | a
20 | 1864866 | Jones, [NAME] |  |  |  | 2h2b | 3h3 | x |  | x | r
21 | 1875782 | Jones, [NAME] |  |  |  | 3h1 | 3h1 | x |  | x | r
22 | 1875904 | Jones, [NAME] |  |  |  | 3h3 | 3h3 | x | x |  | r
23 | 1875106 | Jones, [NAME] |  |  |  | 4h2c | 4h2c | x | x |  | r
24 | 1864418 | Jones, [NAME] |  |  |  | 4c4 | cbar4 |  |  | x | a
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
Spreadsheet: 0a81126b-d57e-437f-b545-b6db4d1f7f62
Sheet: Sheet1

Binge Drinking Among Adults Ages 18 Years and Over, by Year, Maine, 2007-2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Year | Unweighted Number |  | Weighted Number |  | % | LCL | UCL
2007 | 780 |  | 163353.3988476489 |  | 15.84264407390302 | 14.50869071555363 | 17.17659743225241
2008 | 761 |  | 163218.9873535978 |  | 15.77199332260335 | 14.45139480130348 | 17.09259184390322
2009 | 834 |  | 155354.1189089495 |  | 15.10458744186134 | 13.86600557958078 | 16.34316930414191
2010 | 870 |  | 148538.7659446261 |  | 14.45385954418766 | 13.28119419331193 | 15.62652489506339
Data Source: Behavioral Risk Factor Surveillance System Binge drinking is defined as having 5 or more drinks on 1 occasion for men, and 4 or more drinks on 1 occasion for women  %= Weighted percentage of respondents LCL= Lower 95% confidence level of the weighted percentage UCL= Upper 95% confidence level of the weighted percentage
Spreadsheet: 537687d1505226886-macro-for-hide-and-unhide-the-rows-upto-a-certain-column-sample-workbook
Sheet: Sheet1

 |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  | 11020000-01-001-01 |  | 101-09 |  | 7142.37 |  | 1053.98 | 0 | 0 |  | 34639.1 | 1 | 33585.12 | 0 | 31.86504487751191
 |  |  | 11030000-01-001-01 |  | 101-12 |  | 2406.92 |  | 137.52 | 0 | 0 |  | 1100.16 | 1 | 962.6400000000003 | 0 | 7.000000000000004
 |  |  | 11040000-01-001-01 |  | 101-10 |  | 2880.88 |  | 316.14 | 0 | 0 |  | 2549.76 | 1 | 2233.62 | 0 | 7.065287530840768
 |  |  | 11050000-01-001-01 |  | 101-14 |  | 0 |  | 38727.57 | 1 | 0 |  | 1966354.43 | 1 | 1927626.86 | 0 | 49.774020420078
 |  |  | 11060000-01-001-01 |  | 101-13 |  | 5118.47 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
 |  |  | 11070000-01-001-01 |  | 101-15 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
 |  |  | 11080000-01-001-01 |  | 101-16 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
 |  |  | 11500000-01-001-01 |  | 101-04 |  | 6611.39 |  | 10336.72 | 1 | 0 |  | 76714.75999999998 | 1 | 66378.03999999998 | 0 | 6.421576670355779
 |  |  | 11600000-01-001-01 |  | 101-05 |  | 0 |  | 0 |  | 0 |  | -6266 | 0 | -6266 | 0 | -1
Spreadsheet: 342836d1409696050-event-calendar-with-recurring-event-140902_-calendar-of-events-2014-_-test
Sheet: Event Calendar - DEC

 |  |  |  | EVENT CALENDAR
 |  |  |  |  |  | ENTER MONTH: | November
 |  |  |  |  |  | ENTER YEAR: | 2014
 |  |  |  |  |  | ENTER START DAY: | Sunday
 | TO EVENT LIST >>
Spreadsheet: cooper_richey__4020__AB Power Fax
Sheet: Flat load

 |  | GFI Alberta Electricity Desk
 |  | [NAME] [PHONE]
2002-01-03 00:00:00 |  | [EMAIL]
 |  | FLAT | LOAD
 | Maturity | bid $/Mwh | ask $/Mwh
 | Day Ahead | 36 | 38
 | BOM | 32 | 34
 | 2002-02-01 00:00:00 | 32.5 | 33.5
 | 2002-03-01 00:00:00 | 33 | 34
 | Q2 2002 | 31 | 32.5
 | Q3 2002 | 36 | 37.5
 | Q4 2002 | 36.5 | 38
 | Feb/Dec 02 | 34 | 35.5
 | Cal 2003 | 33 | 34.5
Note:
GFI Brokers Limited ("GFI") has provided this information on the basis that its intended use is for indicative price only.
GFI provides no warranties as to the accuracy of this information.
GFI (and its affiliates) accept no liability whatsoever for any loss that may arise as a result of the provision and use of this information.
Spreadsheet: 859492d1707866216-maxifs-max-count-based-on-multliple-criteria-tracking-test-03
Sheet: SUMMARY

 |  |  |  |  | START: | 2024-01-01 00:00:00
BANKS ISSUED | TOTAL COUNT | DAY | SWING | GRAVE | END: | 2024-02-28 00:00:00
BANK #01
BANK #03 |  | 1 | 3 | 0
BANK #04 |  | 1 | 1 | 0
BANK #02 (ISSUED) |  | 0 | 0 | 0
BANK #02 (RETURNED) |  | 0 | 0 | 0
DATE | SHIFT | EMPLOYEE | EMP # | TYPE | OUTLET | AMOUNT
 | DAY | 0 | 0 | ISSUED | BANK #01 | 900
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #01 | 900 |  | 2
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #01 | 900
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #01 | 900 |  | 2
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #01 | 900
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #01 | 900 |  | 2
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #01 | 900 |  | 1
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #01 | 900 |  | 1
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000 |  | 2
2024-01-02 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000 |  | 1
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURNED | BANK #02 | 15000 |  | 3
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000 |  | 4
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #02 | 15000 |  | 3
2024-01-03 00:00:00 | GRAVE | 0 | 0 | ISSUED | BANK #02 | 15000 |  | 1
2024-01-03 00:00:00 | DAY | 0 | 0 | RETURNED | BANK #02 | 15000 |  | 1
2024-01-03 00:00:00 | SWING | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-03 00:00:00 | SWING | 0 | 0 | RETURNED | BANK #02 | 15000 |  | 2
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURNED | BANK #02 | 15000 |  | 4
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #03 | 687.5 |  | 1
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #03 | 687.5
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #03 | 687.5 |  | 2
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #03 | 687.5 |  | 1
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #03 | 687.5
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #03 | 687.5
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #03 | 687.5 |  | 3
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #04 | 687.5 |  | 1
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #04 | 687.5 |  | 1
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #04 | 687.5 |  | 1
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #04 | 687.5 |  | 1
Spreadsheet: 24883d1215779449-dynamically-transpose-data-example
Sheet: Sheet1

How it is: |  |  |  | How I want it:
Employee | Place of Work |  |  | Place of Work | Employee 1 | Employee 2 | Employee 3 | Employee 4
[NAME] | Megacorp |  |  | Megacorp | [NAME] | [NAME] | Emma | [NAME]
[NAME] | Megacorp |  |  | Tiny PLC | [NAME]
Emma | Megacorp |  |  | TFP PLC | [NAME] | [NAME]
[NAME] | Megacorp
[NAME] | Tiny PLC
[NAME] | TFP PLC
[NAME] | TFP PLC
Spreadsheet: 2b414e5c-0392-4665-9b07-50ae32cda73b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4357 | 16966 | [NAME] | [NAME] | HUN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:24:37
4357 | 18493 | Andreas | Kübler | GER | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:31:48
4357 | 11532 | Franck | Paget | FRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:33:49
4357 | 23033 | [NAME] | Corringham | GBR | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 03:20:35
Spreadsheet: 61433d1262281640-selecting-max-values-scores
Sheet: Scores 2008

PLAYER | 2009-09-12 00:00:00 | 2009-09-26 00:00:00 | 2009-10-10 00:00:00 | 2009-10-24 00:00:00 | 2009-11-07 00:00:00 | 2009-11-21 00:00:00 | 2009-12-05 00:00:00 | 2009-12-19 00:00:00 | 2009-12-19 00:00:00 | 2008-05-24 00:00:00 | 2010-01-02 00:00:00 | 2010-01-16 00:00:00 | 2010-01-30 00:00:00 | 2010-02-13 00:00:00 | 2010-02-27 00:00:00 | 2010-03-13 00:00:00 | 2010-03-27 00:00:00 | 2010-04-10 00:00:00 | 2010-04-24 00:00:00 | 2010-05-08 00:00:00 | Total Scores
Brent Vickers | 4 | 1 | 13 | 7 | 7 | 10 | 15 |  | 10 |  | 0 | 7 | 14 | 16 | 15 | 7 | 11 | 13 | 9 | 12 | 171
[NAME] | 5 | 2 | 0 | 15 | 0 | 13 | 13 |  | 19 |  | 1 | 14 | 15 | 11 | 0 | 16 | 8 | 4 | 8 | 10 | 154
[NAME] | 0 | 0 | 0 | 0 | 14 | 0 | 0 |  | 0 |  | 16 | 0 | 16 | 17 | 14 | 17 | 15 | 16 | 5 | 14 | 144
[NAME] | 9 | 4 | 3 | 6 | 11 | 3 | 5 |  | 15 |  | 2 | 9 | 13 | 7 | 12 | 11 | 4 | 14 | 3 | 6 | 137
[NAME] | 13 | 0 | 8 | 3 | 3 | 14 | 6 |  | 0 |  | 9 | 12 | 11 | 14 | 0 | 1 | 12 | 7 | 11 | 5 | 129
[NAME] | 12 | 0 | 0 | 11 | 5 | 8 | 0 |  | 16 |  | 5 | 1 | 9 | 5 | 11 | 13 | 14 | 2 | 10 | 0 | 122
[NAME] | 2 | 0 | 1 | 0 | 9 | 29 | 9 |  | 3 |  | 4 | 2 | 12 | 10 | 1 | 12 | 7 | 9 | 1 | 7 | 118
[NAME] | 0 | 0 | 0 | 2 | 10 | 0 | 3 |  | 10 |  | 13 | 6 | 0 | 8 | 10 | 14 | 16 | 12 | 6 | 8 | 118
[NAME] | 0 | 0 | 14 | 8 | 10 | 0 | 14 |  | 1 |  | 10 | 8 | 3 | 4 | 0 | 5 | 6 | 2 | 15 | 13 | 113
[NAME] | 0 | 0 | 0 | 4 | 1 | 7 | 0 |  | 15 |  | 12 | 13 | 10 | 9 | 13 | 0 | 10 | 5 | 2 | 11 | 112
[NAME] | 0 | 12 | 9 | 0 | 0 | 1 | 0 |  | 0 |  | 14 | 11 | 7 | 13 | 3 | 9 | 5 | 8 | 18 | 2 | 112
[NAME] | 0 | 0 | 2 | 15 | 6 | 11 | 1 |  | 0 |  | 11 | 0 | 6 | 12 | 5 | 3 | 9 | 11 | 16 | 0 | 108
[NAME] | 0 | 0 | 17 | 0 | 0 | 0 | 0 |  | 0 |  | 15 | 12 | 8 | 15 | 0 | 10 | 3 | 15 | 12 | 0 | 107
[NAME] | 1 | 0 | 6 | 28 | 4 | 4 | 2 |  | 4 |  | 7 | 3 | 5 | 2 | 4 | 6 | 2 | 10 | 17 | 1 | 106
[NAME] | 10 | 0 | 0 | 1 | 30 | 5 | 0 |  | 5 |  | 6 | 0 | 4 | 1 | 7 | 15 | 0 | 1 | 13 | 3 | 101
[NAME] | 21 | 3 | 0 | 14 | 0 | 0 | 8 |  | 9 |  | 3 | 5 | 2 | 0 | 8 | 4 | 0 | 6 | 4 | 9 | 96
[NAME] | 6 | 5 | 5 | 5 | 17 | 4 | 0 |  | 6 |  | 8 | 4 | 1 | 3 | 2 | 2 | 13 | 0 | 14 | 0 | 95
[NAME] | 3 | 11 | 4 | 10 | 2 | 6 | 10 |  | 2 |  | 0 | 10 | 0 | 6 | 6 | 0 | 1 | 3 | 7 | 4 | 85
I want to use the best 8 out of the 18 scores from each individual and sum them
Spreadsheet: 796982d1663660479-check-column-wjth-al-least-2-conditions-welding-machines
Sheet: Welding Equipment

 |  |  |  |  |  |  |  | Internal Number | Brand | Model | Batch Number
Annual verification of welding machines |  |  |  |  |  | Reference: | Clamp meter | x | xx | xxx | NS Va160612356 |  | Acceptance criterium | 0.1
Details about welding machines |  |  |  |  |  | Set values on welding machine |  |  | 1ª Verification |  |  |  |  |  |  | 2ª Verification
 |  |  |  |  |  |  |  |  | Reference equipment measurements |  |  | Results with the acceptance criterium |  |  |  | Reference equipment measurements |  |  | Results with the acceptance criterium
Welding machine code | Test Type | Brand | Model | Serial number | Welding Process | Amperage (A) | Voltage (V) | Wire feed  (m/min) | Amperage (A) | Voltage (V) | Wire feed  (m/min) | % Erro Amperage | % Erro Voltage | % Erro Wire feed | Decision OK/NOK | Amperage (A) | Voltage (V) | Wire feed  (m/min) | % Erro Amperage | % Erro Voltage | % Erro Wire feed | Decision OK/NOK | Estado OK/NOK
SD-01 | Consistence | Cemont | MIG 31.2 | K369671 | 138 | NA | Min. - 4 | 2 | 80 | 16.7 | 2021-03-03 00:00:00 | - | - |  | - | 1111 | 1111 |  |  |  | - |  | -
 |  | Cemont | MIG 31.2 | K369671 |  | NA | Min. - 6 | 3 | 108 | 17.5 | 2021-03-03 00:00:00 | - | - |  | - |  |  |  |  |  | - |  | -
 |  | Cemont | MIG 31.2 | K369671 |  | NA | Máx. - 3 | 5 | 168 | 23 | 2021-03-03 00:00:00 | - | - |  | - |  |  |  |  |  | - |  | -
 |  | Cemont | MIG 31.2 | K369671 |  | NA | Máx. - 4 | 6.8 | 190 | 23.5 | 2021-03-03 00:00:00 | - | - |  | - |  |  |  |  |  | - |  | -
 |  | Cemont | MIG 31.2 | K369671 |  | NA | Máx. - 6 | 9 | 225 | 29 | 2021-03-03 00:00:00
SD-02 | Consistence | Cemont | [NAME] | 830341 | 138 | 130 | U-2 | 2.5 | 140 | 17 | 2020-01-29 00:00:00 | - | - |  | - |  |  |  |  |  | - |  | -
 |  | Cemont | [NAME] | 830341 |  | 180 | U-3 | 3.25 | 200 | 21.5 | 2020-01-29 00:00:00 | - | - |  | - |  |  |  |  |  | - |  | -
 |  | Cemont | [NAME] | 830341 |  | 220 | U-4 | 3.75 | 230 | 27 | 2020-01-29 00:00:00 | - | - |  | - |  |  |  |  |  | - |  | -
 |  | Cemont | [NAME] | 830341 |  | 250 | U-4.5 | 4.5 | 260 | 31 | 2020-01-29 00:00:00
 |  | Cemont | [NAME] | 830341 |  | 280 | U-5 | 5 | 285 | 32 | 2020-01-29 00:00:00
SD-03 | Calibration | Fronius | Transsteel 5000 | 25162971 | 138 | 116 | 14.9 | 2.8 | 120 | 16.4 | 2020-12-18 00:00:00 |  |  |  | Ok
 |  | Fronius | Transsteel 5000 | 25162971 |  | 162 | 20 | 4.2 | 175 | 22 | 2020-12-18 00:00:00 |  |  |  | Ok
 |  | Fronius | Transsteel 5000 | 25162971 |  | 244 | 25.5 | 8 | 270 | 27.5 | 2020-12-18 00:00:00 |  |  |  | Ok
 |  | Fronius | Transsteel 5000 | 25162971 |  | 282 | 26.7 | 10 | 310 | 30.3 | 2020-12-18 00:00:00 |  |  |  | Ok
Spreadsheet: 197926d1354616299-automatic-pivot-update-tickets-overdue-due-to-be-updated-template-online-version2-
Sheet: Dashboard

 | Oldest Tickets |  |  |  | Current Backlog: 5666
 | TL | Rep | Days Old
 | Team Leader Tickets |  |  | Overdue Tickets |  |  |  | Due Tickets
 | Team Leader Team Tickets |  |  | Date Status | Overdue | 10 |  | Date Status | Due Today
 |  |  |  |  |  | 0
Spreadsheet: 876899d1723620138-index-match-with-horizontal-and-vertical-criteria-book2
Sheet: Sheet1

Year | Age | Dn | Pn | Teams |  | Year | Age | Dn | 1 | 2 | 3 | 4
2003 | U16 | D1 | 2 | ROWVILLE |  | 2003 | U16 | D1
2003 | U16 | D1 | 3 | KNOX |  | Aiming for => |  |  | NORWOOD | ROWVILLE | KNOX | SURREY PARK
2003 | U16 | D1 | 4 | SURREY PARK |  | 2003 | U16 | D2
2003 | U16 | D1 | 1 | NORWOOD |  | 2003 | U16 | D3
2003 | U16 | D1 | 5 | THE BASIN |  | 2003 | U15 | D1
2003 | U16 | D1 | 6 | UPPER FERNTREE GULLY |  | 2003 | U15 | D2
2003 | U16 | D1 | 7 | ST SIMONS |  | 2003 | U15 | D3
 |  |  |  |  |  | 2003 | U14 | D1
Spreadsheet: 200090d1355412836-formatting-issues-budget-format-participation-sample
Sheet: Grant Budget Detail

ATTACHMENT GRANT BUDGET REFERENCE  (continued)
GRANT BUDGET LINE-ITEM DETAIL
(BUDGET PAGE NUMBER)
SALARIES | AMOUNT
SPECIFIC, DESCRIPTIVE, DETAIL (REPEAT ROW AS NECESSARY) | 0
TOTAL | 0
PROFESSIONAL FEE / GRANT & AWARD | AMOUNT
SPECIFIC, DESCRIPTIVE, DETAIL (REPEAT ROW AS NECESSARY) | 0
TOTAL | 0
TRAVEL / CONFERENCES & MEETINGS | AMOUNT
SPECIFIC, DESCRIPTIVE, DETAIL (REPEAT ROW AS NECESSARY) | 0
TOTAL | 0
INTEREST | AMOUNT
SPECIFIC, DESCRIPTIVE, DETAIL (REPEAT ROW AS NECESSARY) | AMOUNT
TOTAL | AMOUNT
SPECIFIC ASSISTANCE TO INDIVIDUALS | AMOUNT
SPECIFIC, DESCRIPTIVE, DETAIL (REPEAT ROW AS NECESSARY) | AMOUNT
TOTAL | AMOUNT
[NAME] | AMOUNT
SPECIFIC, DESCRIPTIVE, DETAIL (REPEAT ROW AS NECESSARY) | AMOUNT
TOTAL | AMOUNT
OTHER NON-PERSONNEL | AMOUNT
SPECIFIC, DESCRIPTIVE, DETAIL (REPEAT ROW AS NECESSARY) | AMOUNT
TOTAL | AMOUNT
CAPITAL PURCHASE | AMOUNT
SPECIFIC, DESCRIPTIVE, DETAIL (REPEAT ROW AS NECESSARY) | AMOUNT
TOTAL | AMOUNT
Spreadsheet: 793615d1661580272-pull-turn-static-values-into-a-dynamic-array-without-using-offset-excel-problem-1-
Sheet: Sheet1

 | [NAME] | 15 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
Method 1
 |  | INPUT ROW |  |  | 4 |  | 7 |  |  | 10 |  |  | 15
 |  | OUTPUT (USING OFFSET)
Method 2
 |  | INPUT ROW |  |  | 4 |  | 7 |  |  | 10 |  |  | 15
 |  | Step 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Step 2 |  |  | 4 | 4 | 11 | 11 | 11 | 21 | 21 | 21 | 36 | 36 | 36 | 36 | 36 | 36
 |  | Step 3 |  |  | 4 | 0 | 7 | 0 | 0 | 10 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 0
 |  |  |  | I usually just place put a IF(time<1 or an IFERROR to make the #N/A = 0
 |  |  |  | But left it as is for the sake of showing how messy this method is
Spreadsheet: 68354d1268878424-find-position-in-matrix-not-array-test
Sheet: Folha1

 | Φ | 10 | 12.5 | 15 | 17.5 | 20 | 25 | 30 | 35
 | 6 | 2.83 | 2.26 | 1.88 | 1.62 | 1.41 | 1.13 | 0.94 | 0.81
 | 8 | 5.03 | 4.02 | 3.35 | 2.87 | 2.51 | 2.01 | 1.68 | 1.44
 | 10 | 7.85 | 6.28 | 5.24 | 4.49 | 3.93 | 3.14 | 2.62 | 2.24
 | 12 | 11.31 | 9.05 | 7.54 | 6.46 | 5.65 | 4.52 | 3.77 | 3.23
 | 16 | 20.11 | 16.08 | 13.4 | 11.49 | 10.05 | 8.04 | 6.7 | 5.74
 | 20 | 31.42 | 25.13 | 20.94 | 17.95 | 15.71 | 12.57 | 10.47 | 8.98
 | 25 | 49.09 | 39.27 | 32.72 | 28.05 | 24.54 | 19.63 | 16.36 | 14.02
 |  | This value |  |  | Corresponds to
 |  | 11.31 |  | -> | 12Φ10
 |  |  | How to do this automatically?
Spreadsheet: ec29865f-10c5-419f-bd4e-eea6e938f0d2
Sheet: Sheet1

Release: Job Openings and Labor Turnover | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=192
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-12-04 11:12 PM CST
 | Real-Time | Period
Name: | Start | End
Job Openings and Labor Turnover | 2010-08-11 00:00:00 | Current
Link:
http://www.bls.gov/jlt/ | 2010-08-11 00:00:00 | Current
Source:
U.S. Department of Labor: Bureau of Labor Statistics | 2010-08-11 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-08-11 00:00:00
2010-09-08 00:00:00
2010-10-07 00:00:00
2010-11-09 00:00:00
2010-12-07 00:00:00
2011-01-11 00:00:00
2011-02-08 00:00:00
2011-03-11 00:00:00
2011-04-13 00:00:00
2011-05-11 00:00:00
2011-06-07 00:00:00
2011-07-12 00:00:00
2011-08-10 00:00:00
2011-09-07 00:00:00
2011-10-12 00:00:00
2011-11-08 00:00:00
2011-12-13 00:00:00
2012-01-10 00:00:00
2012-02-07 00:00:00
2012-03-13 00:00:00
2012-04-10 00:00:00
2012-05-08 00:00:00
2012-06-19 00:00:00
2012-07-10 00:00:00
2012-08-07 00:00:00
2012-09-11 00:00:00
2012-10-10 00:00:00
2012-11-06 00:00:00
2012-12-11 00:00:00
2013-01-10 00:00:00
2013-02-12 00:00:00
2013-03-12 00:00:00
2013-04-09 00:00:00
2013-05-07 00:00:00
2013-06-11 00:00:00
2013-07-09 00:00:00
2013-08-06 00:00:00
2013-09-10 00:00:00
2013-10-24 00:00:00
2013-11-22 00:00:00
Spreadsheet: kimberly_watson__20555__imbalsumm0108
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -77614 | -65229
2 | -71168 | -80300
3 | -41277 | -50000
4 | -41015 | -50000
5 | -41598 | -50000
6 | -67163 | -50000
7 | -78830 | -80300
8 | -82222 | -80300
9 | -81974 | -80168
10 | -77458 | -79752
11 | -77550 | -79499
12 | -79020 | -79795
13 | -81735 | -80070
14 | -83487 | -80300
15 | -61528 | -59563
16 | -41521 | -50000
17 | -42402 | -50000
18 | -52322 | -50000
19 | -79654 | -48847
20 | -81639 | -60462
21 | -82328 | -89045
22 | -70813 | -65162
23 | -69354 | -83170
24 | -40965 | -43257
25 | -40926 | -38167
26 | -41028 | -36581
27 | -41039 | -49678
28
29
30
31
2001-07-31 00:00:00 |  |  | 21736.76
2001-08-27 00:00:00
CBS Volume
Spreadsheet: 739170d1625564723-formula-to-state-availability-in-colunn-e-item-listing
Sheet: Availability

 | Item listing
 | Label | Item |  | Availability
 | 1 | Rivet set B1 |  | Available
 | 2 | Rivets set B2 |  | Not Available
 | 3 | Bosch 10.8V set1
 | 4 | Bosch 10.8V set2
 | 5 | Bosch 10.8V set3
 | 6 | [NAME] set
 | 7 | [NAME]
 | 8 | Stanley sortmaster
 | 9 | Hitachi jigsaw Fcj55
 | 10 | Crimper connector
 | 11 | Stanley Stel345
 | 12 | MD2000 manual dispenser
 | 13 | Metabo SBE 520
 | 14 | Titanuim organizer
 | 15 | Black decker
 | 16 | Bosch jigsaw GST65
 | 17 | DewaLT drill set
 | 18 | Bosch grinder
 | 19 | Mini drill set
 | 20 | Tool box C
 | 21 | Tool box C1
 | 22 | Tool box C2
 | 23 | Fluke power analyser
 | 24 | Vertex standard wakie talkie(pair)
 | 25 | Impedance meter
 | 26 | Light meter
 | 27 | Sound meter
 | 28 | Vernier caliper
 | 29 | Ldm-500 distant laser
 | 30 | Fiber tester
 | 31 | Power tape
 | 32 | Maktec saw
Spreadsheet: 879717d1727271641-changing-data-in-a-calculated-cell-deletes-formula-1460-abc
Sheet: Billing Invoice

 | WORK ORDER | 1460
 | 2024-09-20 00:00:00
 | ABC Testing |  | Car Radio Conversions
 | 50 Dust Street |  | 1234 Oakwood Dr.
 | Anywhere, USA 12345 |  | Anywhere, NY 13120
 | ph (222) 731-1234 |  |  | [PHONE]
 | QUANTITY | DETAILS | UNIT PRICE | TOTAL
 | Parts:
 | 1 | tran | 6
 | 2 | cap | 2
 | 3 |  | 5
 | 3 |  | 6.77
 | 4 |  | 7.99
 | 5 |  | 8.25
 | 6 |  | 3.44
 | 7 |  | 5.66
 | 8 |  | 6.77
 | 9 |  | 8.42
 | 3 |  | 6.33
 | 8 |  | 5.12
 | 2 |  | 3.44
 | 2 |  | 5.44
 | 5 |  | 4.44
 |  |  | Parts Total
 | Labor
 | 4 | Hours of Labor | 50
 | Parts + Labor
 | Shipping |  |  | 45
 |  |  | Subtotal
 |  |  | Credit Card 3.6%
 | Total
 |  | www.carradioconversions.com
Spreadsheet: 31788d1227730776-transferring-data-from-one-column-to-another-based-upon-a-variable-contract-example
Sheet: Original

Average Selling Price |  | 3350 |  | 5995 |  | Cash In | 800
Trade |  | 0
ACV |  | 0 |  |  |  | Cash Out | 1670
Average Cost |  | 1200 |  | 2500
Difference |  | 3350 |  |  |  | Net flow | -870
Tax | 0 | 0
Fees |  | 153 |  |  |  | Total Net Flow | -4350
Payoff |  | 0
Total |  | 3503
Cash Invest |  | 800 |  | 1000 |  |  | 1000 | 6 | 6000 |  | 5000
Adds |  | 157 |  |  |  |  | 2000 | 3.49 | 4980 |  | 6980
Amt Fin |  | 2860 |  |  |  |  | 3000 | 2.67 | 5010 |  | 8010
 |  |  |  |  |  |  | 4000 | 2.25 | 5000 |  | 9000
Profit |  | 2150 |  |  |  |  | 5000 | 2 | 5000 |  | 10000
 |  |  |  |  |  |  | 6000 | 1.83 | 4980 |  | 10980
Payment |  | 226.4849020769982 |  |  |  |  | 7000 | 1.71 | 4970 |  | 11970
Rate | 0.3
Term | 15
 |  | 225.3581115194012
 |  | 227.6116926345952
 |  | 1200
Total Interest |  | 537.2735311549732
Tot at Term |  | 2687.273531154973
Total Units Sold |  | 5
Commisssion |  | 160
Spreadsheet: 39011d1237229816-excel-2007-opening-excel-2007-in-excel-2003-issue-test
Sheet: PE

Construct Group: Physical Environment
Question | Strongly agree | Agree | Disagree | Strongly disagree | Question Grand Total
Total Responses
Total Responses
Total Responses
Total Responses
Total Responses
Grand Total of Responses |  |  |  |  | Overall Grand Total
Overall Construct Group Summary | Strongly Agree | Agree | Disagree | Strongly disagree