tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18428__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-05 00:00:00 |  | 121.35 | 23072 | 72.24 | 5984
 | 2001-01-04 00:00:00 |  | 131.61 | 14064 | 79.75 | 6272 | 120.52 | 512 | 71.21 | 514
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.45 | 3584 | 129.29 | 613 | 75.14 | 791
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
 | 2000-12-31 00:00:00 |  | 94.03 | 2480 | 88.53 | 680 | 55.11 | 1961 | 56.69 | 816 |  | 89.07 | 1992
 | 2000-12-30 00:00:00 |  | 121.88 | 6160 | 88.79 | 1344 | 90.2 | 1203 | 69.44 | 897
 | 2000-12-29 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 146.94 | 2282 | 91.56 | 880
 | 2000-12-28 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 138.35 | 2041 | 123.17 | 293
 | 2000-12-27 00:00:00 |  | 232 | 10048 | 123.85 | 728 | 128.78 | 2370 | 96.27 | 690
 | 2000-12-26 00:00:00 |  | 250.55 | 12960 | 173.75 | 800 | 124.75 | 1488 | 90.47 | 590
 | 2000-12-25 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 78.91 | 709 | 55.11 | 871 |  | 204.22 | 10800
 | 2000-12-24 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 92.39 | 584 | 65.56 | 160 |  | 204.22 | 10800
 | 2000-12-23 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 140 | 35 | 121.09 | 184
 | 2000-12-22 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 267.5 | 0 | 80 | 375
 | 2000-12-21 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 252.65 | 1831 | 132.45 | 530
 | 2000-12-20 00:00:00 |  | 269.33 | 15200 | 190.33 | 2688 | 198.54 | 3261 | 151.82 | 927
 | 2000-12-19 00:00:00 |  | 258.18 | 10272 | 178.86 | 1968 | 195.85 | 2305 | 133.46 | 718
 | 2000-12-18 00:00:00 |  | 224.43 | 11840 | 176.78 | 1168 | 220.89 | 1072 | 124.85 | 495
 | 2000-12-17 00:00:00 |  | 196.67 | 1200 | 175.71 | 280 | 136.93 | 985 | 113.5 | 500 |  | 177.12 | 2664
 | 2000-12-16 00:00:00 |  | 233.65 | 12880 | 192.27 | 2704 | 130.23 | 922 | 120.83 | 60
 | 2000-12-15 00:00:00 |  | 238.8 | 13024 | 192.27 | 2704 | 180.19 | 1670 | 128.18 | 706
 | 2000-12-14 00:00:00 |  | 334.66 | 15184 | 213.55 | 2480 | 200 | 150 | 174.54 | 271
 | 2000-12-13 00:00:00 |  | 495.62 | 14992 | 223.93 | 4504 | 276 | 3139 | 184.69 | 2161
 | 2000-12-12 00:00:00 |  | 330 | 9200 | 211.98 | 2688 | 347.7 | 2622 | 193.04 | 1826
 | 2000-12-11 00:00:00 |  | 414.56 | 9200 | 213.96 | 2480 | 204.38 | 2263 | 187.04 | 1280
 | 2000-12-10 00:00:00 |  | 254.96 | 2160 | 217.63 | 2280 | 180.88 | 1906 | 161.34 | 780 |  | 172.02 | 600
 | 2000-12-09 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 189.51 | 1364 | 138.71 | 403
 | 2000-12-08 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 290.86 | 1368 | 205.28 | 799
 | 2000-12-07 00:00:00 |  | 262.73 | 15808 | 174.55 | 2816 | 241.93 | 1455 | 118.5 | 865
 | 2000-12-06 00:00:00 |  | 250.5 | 23472 | 154.65 | 3232 | 283.47 | 2363 | 157.27 | 595
Spreadsheet: 872439d1718813620-compare-2-rows-of-same-column-book2
Sheet: Sheet2

 | aa | 10 | hi | California |  |  |  | bb | 12.01 | good | Minesota
vdr2 | aa | 10.01 | hi | California |  |  | vdr2 | bb | 12.03 | good | Menesota
vdr1 | bb | 12.01 | good | Minesota |  |  | vdr1 | cc | 15.5 | hello | Florida
vdr2 | bb | 12.03 | good | Menesota |  |  | vdr2 | cc | 15.5 | hello | Tennessi
Spreadsheet: 88137d1288050504-help-with-running-7-day-count-goals-2010
Sheet: Sep

fuel | wednesday | thursday | friday | saturday | sunday | monday | tuesday | total | wkly variance |  | week | day | Sales
week 1 | 5566 | 6620 | 5565 | 6610 | 5201 | 6006 | 6100 | 41668 | -4602 |  | 1 | 1 | 5566
week 2 | 6610 | 6610 | 3455 | 6610 | 3984 | 8888 | 9933 | 46090 | -180 |  | 1 | 2 | 6620
week 3 | 3939 | 4959 | 4554 | 4545 | 4545 | 2 | 3 | 22547 | -23723 |  | 1 | 3 | 5565
week 4 | 1 | 2 | 3 | 4 | 5 | 6 | 5 | 26 | -46244 |  | 1 | 4 | 6610
week 5 |  |  |  |  |  |  |  | 0 | 0 |  | 1 | 5 | 5201
 |  |  |  |  | daily goal | 6610 | month total | 110331 |  |  | 1 | 6 | 6006
 |  |  |  |  | weekly goal | 46270 | actual mth goal | 185080 |  |  | 1 | 7 | 6100
 |  |  |  |  | monthly goal | 185080 | month variance | -74749 |  |  | 2 | 1 | 6610
 |  |  |  |  |  |  | 7 day total | 24 |  |  | 2 | 2 | 6610
 |  |  |  |  |  |  | 7 day variance | -46246 |  |  | 2 | 3 | 3455
 |  |  |  |  |  |  |  |  |  |  | 2 | 4 | 6610
 |  |  |  |  |  |  |  |  |  |  | 2 | 5 | 3984
 |  |  |  |  |  |  |  |  |  |  | 2 | 6 | 8888
 |  |  |  |  |  |  |  |  |  |  | 2 | 7 | 9933
 |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 3939
 |  |  |  |  |  |  |  |  |  |  | 3 | 2 | 4959
 |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 4554
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 4545
 |  |  |  |  |  |  |  |  |  |  | 3 | 5 | 4545
 |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 2
 |  |  |  |  |  |  |  |  |  |  | 3 | 7 | 3
 |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 4 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  | 4 | 3 | 3
 |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  | 4 | 5 | 5
 |  |  |  |  |  |  |  |  |  |  | 4 | 6 | 6
 |  |  |  |  |  |  |  |  |  |  | 4 | 7 | 5
 |  |  |  |  |  |  |  |  |  |  | 5 | 1
 |  |  |  |  |  |  |  |  |  |  | 5 | 2
 |  |  |  |  |  |  |  |  |  |  | 5 | 3
 |  |  |  |  |  |  |  |  |  |  | 5 | 4
 |  |  |  |  |  |  |  |  |  |  | 5 | 5
 |  |  |  |  |  |  |  |  |  |  | 5 | 6
 |  |  |  |  |  |  |  |  |  |  | 5 | 7
Spreadsheet: 140247d1328658301-help-with-a-60-day-certification-period-calendar-formula-60-recert-calendar-upload
Sheet: Sheet1

Patient:
 | Start of Care: |  |  |  |  |  | Cert Period: |  |  | 2012-02-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  |  | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
SN
HHA
PT
OT
MSW
SP
 | March |  |  |  |  |  |  | March |  |  |  |  |  |  | March |  |  |  |  |  |  | April |  |  |  |  |  |  |  |  |  |  | Totals
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | Visits
SN
HHA
PT
OT
MSW
SP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * = Therapy 13th and 19th Visits. |  |  |  |  |  |  |  | [A]= Therapapy Assessment |  |  |  |  |  | [S]=Supervisory Note
Spreadsheet: 57205d1257347122-look-up-value-from-master-sheet-based-on-criteria-in-current-sheet-billing-example
Sheet: Sheet5

Presentation of Fees
[NAME]
July
Pertaining to  staff, design, implementation and activities management expenses
Fees invoiced on the basis of work actually performed
On the basis of an hourly rate
Completed on a monthly basis
Information to be provided :
Personnel level |  | Daily rate $/day |  | Hourly rate $/hr
Executive Vice President |  | $2,400/day |  | $300/hr
Managing Director |  | $1,800/day |  | $225/hr
Account Director |  | $1,400/day |  | $175/hr
Account Coordinator |  | $600/day |  | $75/hr
Name of the individual involved |  | Personnel level
[NAME] |  | Managing Director
[NAME] |  | Managing Director
[NAME] |  | Account Director
[NAME] |  | Account Coordinator
[NAME] |  | Account Coordinator
[NAME] |  | Account Coordinator
Service provided |  | Date | Location(s) service took place | Name of the individual involved | Number of hours | Number of days | Total billing
 |  | July |  | [NAME] | 0 |  | 0
 |  | July |  | [NAME] | #N/A |  | #N/A
 |  | July |  | [NAME] | #N/A |  | #N/A
 |  | July |  | [NAME] | #N/A |  | #N/A
 |  | July |  | [NAME] | #N/A |  | #N/A
 |  | July |  | [NAME] | #N/A |  | #N/A
Total Days/Hours |  |  |  |  | #N/A
Total Fees |  |  |  |  |  |  | #N/A
Spreadsheet: chris_germany__2918__Marathon Ashland TestResults example
Sheet: Sheet1

 | Terminal | Roanoke
 | Tank No | 55-6
 | Product | LSDF
 | Sample Date | 1998-02-09 00:00:00
 | Sequence No. | 99028
 | API Gravity | 34.2
 | D86 Distillation ^F
 | IBP | 350
 | 10% Rec | 422
 | 20% Rec | 451
 | 50% Rec | 520
 | 90% Rec | 619
 | EP | 668
 | Cetane Index | 46.8
 | [NAME], wt%
 | per ASTM D2622 | 0.035
 | per ASTM D4737 | 0.037
 | Nitrogen % | 0.011
 | Workmanship | Pass
 | Flashpoint ^F | 148
 | ASTM Color | 1.5
 | [NAME] | 9
 | Pour Point ^F | -10
Spreadsheet: 788036d1658232902-excel-counting-and-removing-duplicates-count-test
Sheet: Results

 | Results |  | Total
 | Unit | Count |  |  | Total count excluding duplicate
Spreadsheet: 760285d1640118222-find-multiple-matches-test-match
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sleepers | Uniques | Repeaters
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Spin Ct |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # of [NAME] | # of Max-1 | Max-2 | #Max-3
30 |  |  | 1 |  | 1 | 2 | 3 | 4 | 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 | 31 | 32 | 33 | 34 | 35 | 36 | 0 | 1
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
25
21
7
7
36
4
15
20
36
10
11
31
12
21
10
15
23
3
13
34
16
21
0
26
4
14
20
29
17
4
1
3
3
15
0
31
8
15
26
31
26
3
24
25
23
26
32
26
36
0
22
10
28
24
6
3
15
4
21
22
31
4
2
3
34
8
24
6
13
25
20
34
20
9
10
19
35
9
18
33
14
36
11
8
24
12
10
36
28
17
21
33
14
20
28
0
22
13
21
9
7
21
30
7
21
30
4
14
23
4
34
2
9
25
31
13
15
8
7
24
20
7
33
27
32
23
23
17
20
21
2
24
1
32
8
6
1
23
13
21
33
2
36
12
28
27
15
21
26
18
23
6
25
21
5
6
20
23
6
28
30
6
30
6
26
16
17
19
25
21
15
36
14
29
4
6
31
8
24
16
6
33
14
36
14
33
0
4
21
28
34
9
30
4
2
28
29
24
13
3
0
0
27
31
3
29
3
11
1
28
16
6
26
27
20
28
27
8
10
2
31
29
8
33
25
33
36
14
15
34
31
25
1
5
16
2
34
35
12
17
30
30
2
28
16
26
25
20
0
23
1
36
16
35
28
30
16
9
3
28
13
36
13
31
0
34
23
24
23
18
27
31
17
1
9
26
34
14
8
35
26
9
29
16
23
30
5
18
33
0
25
26
25
12
7
9
15
9
33
36
36
22
12
16
32
0
4
31
22
27
28
17
34
18
28
10
17
32
34
10
29
20
2
13
35
23
18
18
13
Spreadsheet: 667847d1584528944-automating-supply-orders-frustration03
Sheet: Order form

Item of requisition | Acct Assignment Cat. | Item Category | Material | Short Text | Quantity requested | Unit of Measure | Valuation Price | Total Value | Delivery Date | Material Group | Plant | Storage Location | Purchasing Group | Requisitioner | Req. Tracking Number | Desired Vendor | Fixed vendor | Supplying Plant | Purch. Organization | Purchasing info rec. | MPN material | StatusCode | Purchase order | Purchase Order Date | Outline agreement | Princ.agreement item
 | K | PASTE THIS ROW | 100022222 | SPONGE,GAUZE,PRE,RYN,2X2,4PL,NWVN,200/PK,22222 | 7 | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | PASTE THIS ROW | 100044444 | IBUPROFEN,200MG,TABLET,200X2,44444 | 3 | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 153 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | PASTE THIS ROW | 100066666 | VIRUSTEST,50THINGS,144/BOX,66666 | 1 | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 |  | PASTE THIS ROW |  | XX12345XX | 1 | EA
 | K | PASTE THIS ROW | 100033333 | DRESSING,NONADH,TELFA,3"X4",BOX OF 100,33333 | 25 | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | PASTE THIS ROW | 100055555 | HOTDOG,BUNLENGTH,8/BOX,55555 | 1 | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | PASTE THIS ROW | 100077777 | CHAIR,RECLINER,LG,ONE,77777 | 2 | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | PASTE THIS ROW | 100088888 | BOOK,REGULATIONS,ONE,88888 | 3 | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | PASTE THIS ROW | 100099999 | TRIX,CEREAL,17OZBOX,99999 | 4 | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
 | K | PASTE THIS ROW | 100011111 | HAPPYZINGER,BANDAGE,3X3,100/BOX,11111 | 5 | EA |  |  |  | MROT-OFFICE SUPPLIES | Johnson City Plant | MRO Receiving | 157 | 204778 |  | 100086678 |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 71689d1272447568-number-banding-formula
Sheet: Sheet6

Data | Banding
12000 | <18000 | <<<<<< | This is the desired outcome
14500 | <18000
14500 | <18000
14000 | <18000
16000 | <18000
16000 | <18000
14500 | <18000
15000 | <18000 |  |  |  |  | 1 | <18000
15000 | <18000 |  |  |  |  | 2 | 18000-25000
12000 | <18000 |  |  |  |  | 3 | 25000-35000
15800 | <18000 |  |  |  |  | 4 | 35000+
15800 | <18000
15000 | <18000
57000 | 35000+
12500 | <18000
12000 | <18000
12000 | <18000
16000 | <18000
16000 | <18000
16000 | <18000
16000 | <18000
14000 | <18000
14000 | <18000
18500 | 18000-25000
26000 | 25000-35000
26000 | 25000-35000
26000 | 25000-35000
15500 | <18000
16000 | <18000
35000 | 35000+
12500 | <18000
16000 | <18000
Spreadsheet: 806733d1669540986-sumif-across-multiple-sheets-sumifexample
Sheet: TOTALS

UNIT | NAMES | sum
UNIT 1 | NAME 1 | 450
UNIT 1 | [NAME] 2 | 250
UNIT 1 | NAME 3 | 200
UNIT 2 | NAME 1 | 550
UNIT 2 | [NAME] 2 | 200
UNIT 2 | NAME 3 | 150
Spreadsheet: d61eb40b-beda-4c47-824d-c39ea66a8a95
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
FSMA | Test | FSMA | Spinal Muscular Atrophy Diagnostic Test | SMA Evaluation | Polymerase Chain Reaction (PCR), Quantitative Dose Analysis | EDTA (lavender-top) tube: EDTA Yellow-Top (ACD) Tube: ACD |  |  | 4 | mL | 4 mL whole blood collected in a lavender top EDTA or ACD yellow top tube. Send whole blood at refrigerated temperature.   Note:  Collection date is required. | 2 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA; ACD Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | An interpretive report will be faxed and/or mailed under separate cover.   Test Performed by Athena Diagnostics                             377 Plantation Street                             Four Biotech Park                             Worcester, MA 01605 | Upon Receipt | 7 days | 9 - 11 days | 1 | 81401 |  |  |  |  | Athena Diagnostics
FSMA | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 14 days
FSMA | Result | Z0100 | SMA Evaluation | SMA Evaluation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 56303988-b96b-416b-838c-7c7639ec930b
Sheet: Page 12

Permit No.: |  |  | WQ0028552 |  |  | Facility Name: |  | Briar Chapel Development |  |  |  |  |  | County: | Chatham |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  |  |  | Field Name: |  | C-15E |  | Field Name: |  | C-16A |  | Field Name: |  | C-20A
 |  |  |  |  |  | Area (acres): |  |  |  | Area (acres): |  | 1.4 |  | Area (acres): |  | 3.2 |  | Area (acres): |  | 0.4
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1
 |  |  |  |  |  | Annual Rate (in): |  |  |  | Annual Rate (in): |  | 37.31 |  | Annual Rate (in): |  | 37.31 |  | Annual Rate (in): |  | 37.31
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
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
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 60350d1260906320-auto-copy-part-of-row-in-a-worksheet-to-another-worksheet-based-on-criteria-case-assignments2010-temp
Sheet: Oct2010

 | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4 |  |  |  | Week 5
 | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code
 | Monday |  |  |  | 2009-10-05 00:00:00 |  |  |  | 2009-10-12 00:00:00 |  |  |  | 2009-10-19 00:00:00 |  |  |  | 2009-10-26 00:00:00
1
2
3
4
5
6
7
8
9
 | Tuesday |  |  |  | 2009-10-06 00:00:00 |  |  |  | 2009-10-13 00:00:00 |  |  |  | 2009-10-20 00:00:00 |  |  |  | 2009-10-27 00:00:00
1
2
3
4
5
6
7
8
9
 | Wednesday |  |  |  | 2009-10-07 00:00:00 |  |  |  | 2009-10-14 00:00:00 |  |  |  | 2009-10-21 00:00:00 |  |  |  | 2009-10-28 00:00:00
1
2
3
4
5
6
7
8
9
 | 2009-10-01 00:00:00 |  |  |  | 2009-10-08 00:00:00 |  |  |  | 2009-10-15 00:00:00 |  |  |  | 2009-10-22 00:00:00 |  |  |  | 2009-10-29 00:00:00
1
2
3
4
5
6
7
8
9
 | 2009-10-02 00:00:00 |  |  |  | 2009-10-09 00:00:00 |  |  |  | 2009-10-16 00:00:00 |  |  |  | 2009-10-23 00:00:00 |  |  |  | 2009-10-30 00:00:00
1
2
3
4
5
6
7
8
9
Spreadsheet: 215750d1361468147-using-vlookup-twice-on-the-same-cell-lookup-book-1
Sheet: Sheet1

Company | Customer No | Customer | Invoice Number | InvoiceDate | Invoice Type | Item Number | ItemDescription (Text) | Quantity | Unit Price | Reference (only for Commuter) | DueDate | PO Number | Control Total | Notes
W | 111 | Company 111 |  | 2013-02-21 00:00:00 | C | 12 | Text 1 | 0 | 0 |  | 2013-03-23 00:00:00 |  | 0
W | 222 | Company 222 |  | 2013-02-21 00:00:00 | C | 123 | Text 2 | 0 | 0 |  | 2013-03-23 00:00:00 |  | 0
W | 333 | Company 333 |  | 2013-02-21 00:00:00 | C | 1234 | Text 3 | 0 | 0 |  | 2013-03-23 00:00:00 |  | 0
W | 444 | Company 444 |  | 2013-02-21 00:00:00 | C | 12345 | Text 4 | 0 | 0 |  | 2013-03-23 00:00:00 |  | 0
Spreadsheet: 47865d1247036883-sorting-non-unique-rows-of-data-into-another-worksheet-example
Sheet: Control Budget

a | b | h | i | j | k=i+j
Description | Code | Costs | Cash spent | Plus accruals | = Costs to date
Development | 100 | 519444
something | 110 | 235603
somethingelse | 120 | 29284
[NAME] | 130 | 254557
Engineering | 200 | 21714
a | 210 | 11516
b | 220 | 2928
c | 230 | 0
d | 240 | 6925
e | 250 | 345
Construction | 300 | 167144
[NAME] | 310 | 64651
gurgle | 320 | 53605
rawr | 330 | 0
asif | 340 | 23564
canhaz | 350 | 25324
Spreadsheet: 82762d1282777169-connect-two-columns-together-riskregistertest
Sheet: Instructions

Instruction for filling out this excel sheet:
Steps:
1- Fill out the occurance date
 | a- Month
 | b- Day
 | c- Year
2- Select the risk Category
 | * Risk Category table is dynamic if the specific category was not in the drop down menu it can be added by going to list tab of this excel sheet and add the specific category fo the list it will appear in the drop down menu.
3- Select the sub category related to the risk from the drop down menu
 | * Risk sub Category table is dynamic if the specific sub category was not in the drop down menu it can be added by going to list tab of this excel sheet and add the specific sub category fo the list it will appear in the drop down menu.
4- Fill out the risk event ,this presents what the nature of the risk is and what is it relate to.
5- Feel out the impact level of the risk on the project ,this can be choose from 3 categories from the drop dowm menu High , Medium or low
 | a- High risks are usually risk
 | b- Medium risks are usually risks
 | c- Low risks are usually risks
6- Feel out the likihood of the risk same as Step 5
7- Rank Column will automatically fills it self and it is the multiplication of impact and likelihood
 | * This column has another color which indicates that there is no need to feel this cell out.
8- Overal risk will automatically fills itself from the data from the rank column
 | a- Rank smaller than 3 is Low
 | b- Rank Between 3 and 6 is Medium
 | c- Rank Bigger than 6 is High
 | * This column has another color which indicates that there is no need to feel this cell out.
9- Fill out the resolution plan cell
10- Choose the level of effectiveness of the resolution plan from the drop down menu (H,M,L) after the plan was applied.
11- Fill out names of  Actionees
12- Set an estimated date for resolving the problem
13- [NAME] out the actual completion date after the issue was resolved.
14- Write down the result for this risk
Spreadsheet: 783323d1654719969-vlookup-and-list-dropdown-example-wb
Sheet: Information

 | ICT Master Stock Sheet - Asset Information
 | Search Type | Search Data
 | Serial Number | 5CG1363X70
 | Serial Number | WeBuy Number | Asset Number | Received | Location | Purchaser | Model | Imaged | Postworked | User | Ticket No | Issued | [NAME] | Status
 | In-Stock | Ready to Deploy | Issued from Stock | Pending |  |  |  |  |  | Total Devices in Stock
 | Serial Number | WeBuy Number | Asset Tag | Date Received | Location | Purchaser | Model | Date Imaged | Postworked | User | Ticket No | Date Issued | [NAME] | Status
 | 5CG1363X70 | WB19102945 | 32354 | 10.10.22 | BS - 2F Build Room | Person 1 | 840 G7 | 12.10.22 | 13.10.22 | User 1 | SR-23725 | 15.10.22 | Test 1 | In-Stock
 | 5CG13506Y6 | WB01102183 | 32437 | 17.09.21 | BS - GF Stock Room | Person 2 | 840 G7 | 28.09.21 | 28.09.21 | User 2 | SR-18525 | 12.11.2021 | Test 2 | Ready to Deploy
Spreadsheet: 32963f1d-1cda-4978-83b3-325a2c0cb3a3
Sheet: Sheet1

MICO Metals | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Metric / Imperial Conversion
 | Select a conversion
 |  |  |  |  |  |  |  |  |  |  | Inches->Millimetres | 1 | 25.4 | 1
 | Enter measurement to be converted in Blue cell |  |  |  |  |  |  |  |  |  | Millimetres->Inches | 2 | 0.03937
 |  |  |  |  |  |  |  |  |  |  | Feet->Meters | 3 | 0.3048
 | 4 | 25.4 | Result | 101.6 |  |  |  |  |  |  | Meters->Feet | 4 | 3.2808
 |  |  |  |  |  |  |  |  |  |  | Pounds->Kgs | 5 | 0.4536
 |  |  |  |  |  |  |  |  |  |  | Kgs->Pounds | 6 | 2.2046