tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 81458d1281625158-excel-2007-trouble-with-a-simple-sum-formula-online-post
Sheet: Stats

 |  | Total |  | # | A | B | C | D | E | F | G | H | I | J | K | L | M | Mc | N | O | P | Q | R | S | St. | T | U | V | W | X | Y | Z | Cdn | USA | Int. | NFA
HTA |  | 97 |  | 6 | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | N/A | --- | --- | --- | 97 | 10 | ---
LLA |  | 14 |  | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | N/A | --- | --- | --- | 14 | 8 | ---
TTPA |  | 1 |  | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | N/A | --- | --- | --- | 1 | 1 | ---
Bylaw |  | 0 |  | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | N/A | --- | --- | --- | --- | --- | ---
Parking |  | 0 |  | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | N/A | --- | --- | --- | --- | --- | ---
CAIA |  | 2 |  | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | N/A | --- | --- | --- | 2 | --- | ---
Spreadsheet: 844303d1696015847-showing-daily-activity-from-a-list-of-starting-dates-excel-help-needed_1412777
Sheet: Sheet1

 | Starting with this data:
 |  | Days Required
 | Minor Inspection | 1
 | Major Inspection | 2
 | [NAME] | 4
 | Operating | 12
 |  |  |  | Given a list of dates | I want to show the resulting daily activity in this column:
 |  | Start Date
 | Inspection | 2024-01-01 00:00:00
 | Operating | 2024-01-02 00:00:00 |  | 2024-01-02 00:00:00
 | Minor inspection | 2024-01-14 00:00:00 |  | 2024-01-03 00:00:00
 | Operating | 2024-01-16 00:00:00 |  | 2024-01-04 00:00:00
 | Major inspection | 2024-01-28 00:00:00 |  | 2024-01-05 00:00:00
 | Operating | 2024-02-01 00:00:00 |  | 2024-01-06 00:00:00
 | [NAME] | 2024-02-07 00:00:00 |  | 2024-01-07 00:00:00
 | Operating | 2024-02-17 00:00:00 |  | 2024-01-08 00:00:00
 |  |  |  | 2024-01-09 00:00:00
 |  |  |  | 2024-01-10 00:00:00
 |  |  |  | 2024-01-11 00:00:00
 |  |  |  | 2024-01-12 00:00:00
 |  |  |  | 2024-01-13 00:00:00
 |  |  |  | 2024-01-14 00:00:00
 |  |  |  | 2024-01-15 00:00:00
 |  |  |  | 2024-01-16 00:00:00
 |  |  |  | 2024-01-17 00:00:00
 |  |  |  | 2024-01-18 00:00:00
 |  |  |  | 2024-01-19 00:00:00
 |  |  |  | 2024-01-20 00:00:00
 |  |  |  | 2024-01-21 00:00:00
 |  |  |  | 2024-01-22 00:00:00
 |  |  |  | 2024-01-23 00:00:00
 |  |  |  | 2024-01-24 00:00:00
 |  |  |  | 2024-01-25 00:00:00
 |  |  |  | 2024-01-26 00:00:00
 |  |  |  | 2024-01-27 00:00:00
 |  |  |  | 2024-01-28 00:00:00
 |  |  |  | 2024-01-29 00:00:00
 |  |  |  | 2024-01-30 00:00:00
 |  |  |  | 2024-01-31 00:00:00
 |  |  |  | 2024-02-01 00:00:00
 |  |  |  | 2024-02-02 00:00:00
 |  |  |  | 2024-02-03 00:00:00
 |  |  |  | 2024-02-04 00:00:00
 |  |  |  | 2024-02-05 00:00:00
 |  |  |  | 2024-02-06 00:00:00
 |  |  |  | 2024-02-07 00:00:00
 |  |  |  | 2024-02-08 00:00:00
 |  |  |  | 2024-02-09 00:00:00
 |  |  |  | 2024-02-10 00:00:00
 |  |  |  | 2024-02-11 00:00:00
 |  |  |  | 2024-02-12 00:00:00
 |  |  |  | 2024-02-13 00:00:00
 |  |  |  | 2024-02-14 00:00:00
 |  |  |  | 2024-02-15 00:00:00
 |  |  |  | 2024-02-16 00:00:00
 |  |  |  | 2024-02-17 00:00:00
 |  |  |  | 2024-02-18 00:00:00
 |  |  |  | 2024-02-19 00:00:00
 |  |  |  | 2024-02-20 00:00:00
 |  |  |  | 2024-02-21 00:00:00
 |  |  |  | 2024-02-22 00:00:00
 |  |  |  | 2024-02-23 00:00:00
 |  |  |  | 2024-02-24 00:00:00
 |  |  |  | 2024-02-25 00:00:00
 |  |  |  | 2024-02-26 00:00:00
 |  |  |  | 2024-02-27 00:00:00
 |  |  |  | 2024-02-28 00:00:00
Spreadsheet: 09e5ee41-0d64-4feb-bfc8-6064e6726dbb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | FORM H
INTERNATIONAL CIVIL AVIATION ORGANIZATION
AIR TRANSPORT REPORTING FORM
CIVIL AIRCRAFT ON REGISTER
Contact person: |  |  | State:
Organization:
[NAME].: |  |  |  | At 31 [NAME]:
Fax:
E-mail:
PART I:  SUMMARY OF ALL AIRCRAFT ON REGISTER
AIRCRAFT CATEGORY |  |  |  | TOTAL NUMBER OF AIRCRAFT
 |  |  |  | 9 000 kg (20000 lb)                and over | Under                      9000 kg (20 000 lb)
 |  |  |  |  | 9 000 kg
 |  |  |  |  | (20 000 lb)
a |  |  |  | b | c
FIXED-WING AIRCRAFT
Turbo-jet
6 engines
4 engines
3 engines
2 engines
1 engine
Propeller-driven (turbine)
4 engines
3 engines
2 engines
1 engine
Propeller-driven (piston)
4 engines
3 engines
2 engines
1 engine
ROTARY-WING AIRCRAFT
Turbine engines
2 engines
1 engine
Piston  engines
2 engines
1 engine
PART II -  NUMBER OF LARGE AIRCRAFT BY TYPE
TYPE OF AIRCRAFT |  |  |  |  | TOTAL NUMBER OF AIRCRAFT
List all aircraft with a maximum certificated take-off mass of 9 000 kg (20 000 lb) and over, which were included in the figures reported for column b of Part I.
a |  |  |  |  | b
Remarks (including a description of any unavoidable deviation from the instructions):
Spreadsheet: 396f9358-db45-45ae-82e0-0a1d1893cb96
Sheet: Sheet1

COGs | members | count | resolved clan
1 | anCYP505A8 fgCYP505A7 mgCYP505A6 ncuCYP505A2 | 4
2 | anCYP51F1 fgCYP51F1 mgCYP51F1 ncuCYP51F1 | 4
3 | anCYP531D2 fgCYP531C1 mgCYP531B1 ncuCYP531A1 | 4
4 | [NAME] | 4
5 | anCYP537B1 fgCYP537A2 mgCYP537A3 ncuCYP537A1 | 4
6 | anCYP539B2 fgCYP539A3 mgCYP539A2 ncuCYP539A1 | 4
7 | anCYP53A3 fgCYP53A8 [NAME] | 4
8 | anCYP548D1 fgCYP548A3 mgCYP548A2 ncuCYP548A1 | 4
9 | anCYP552A2 fgCYP552B3 [NAME] | 4
10 | anCYP61Ax fgCYP61A1 mgCYP61A1 ncuCYP61A5 | 4
11# | anCYP503B1 mgCYP604A1 ncuCYP560A1 | 3 | 54
12 | anCYP504A1 fgCYP504A5 mgCYP504A4 | 3
13 | anCYP504B1 fgCYP504B3 mgCYP504B2 | 3
14 | anCYP51F2 fgCYP51F2 mgCYP51F2 | 3
15 | anCYP530A3 fgCYP530A2 ncuCYP530A1 | 3
16 | anCYP540B4 fgCYP540B2 mgCYP540B1 | 3
17 | anCYP550B2 fgCYP550B1 ncuCYP550A1 | 3
18 | anCYP566C1 fgCYP566B1 mgCYP566A1 | 3
19 | [NAME] | 3
20 | [NAME] mgCYP584A1 | 3
21# | anCYP623B2 mgCYP559B1 ncuCYP559A1 | 3 | 559
22# | anCYP660A1 fgCYP636A1 mgCYP611A1 | 3 | 550*
23# | anCYP670B1 fgCYP628A1 mgCYP574A1 | 3 | 574
24 | [NAME] ncuCYP528A1 | 3
25 | fgCYP534C1 mgCYP534B1 ncuCYP534A1 | 3
26 | fgCYP544A3 mgCYP544A2 ncuCYP544A1 | 3
27 | fgCYP546B1 mgCYP546A2 ncuCYP546A1 | 3
28 | fgCYP54C1 mgCYP54B1 ncuCYP54A1 | 3
29# | [NAME] | 3 | 533
30# | anCYP52G1 [NAME] | 2 | 52
31 | anCYP532C2 fgCYP532C1 | 2
32 | anCYP532F1 fgCYP532B2 | 2
33 | anCYP535D1 mgCYP535C1 | 2
34 | anCYP540A2 ncuCYP540A1 | 2
35 | anCYP541B1 ncuCYP541A1 | 2
36 | anCYP567C1 fgCYP567B1 | 2
37 | anCYP58C1 fgCYP58A3 | 2
38# | anCYP59A1 mgCYP587A1 | 2 | 59
39 | [NAME] fgCYP59B1 | 2
40# | anCYP60A2 [NAME] | 2
41# | anCYP60B1 [NAME] | 2
42 | anCYP617B2 fgCYP617A1 | 2
43 | anCYP619B1 fgCYP619A1 | 2
44 | anCYP620D1 fgCYP620B1 | 2
45 | anCYP62C1 fgCYP62B1 | 2
46 | [NAME] | 2
47 | anCYP631B1 fgCYP631A1 | 2
48 | anCYP65T1 fgCYP65S1 | 2
49 | anCYP65U1 mgCYP65G1 | 2
50# | anCYP665A1 mgCYP592A1 | 2 | **
51# | anCYP676A1 fgCYP629A1 | 2 | 532
52# | anCYP68L1 mgCYP596A1 | 2 | 68
53 | fgCYP505C2 mgCYP505C1 | 2
54 | fgCYP526E1 mgCYP526D1 | 2
55 | fgCYP542B1 ncuCYP542A1 | 2
56 | fgCYP547B1 [NAME] | 2
57 | fgCYP551B1 ncuCYP551A1 | 2
58 | [NAME] | 2
59 | fgCYP55A8 ncuCYP55A6 | 2
60 | fgCYP561D1 mgCYP561A1 | 2
61 | fgCYP570C2 mgCYP570B1 | 2
62 | fgCYP577A2 mgCYP577A1 | 2
63 | fgCYP602B1 mgCYP602A1 | 2
64 | fgCYP606B1 mgCYP606A1 | 2
65# | fgCYP614A1 mgCYP590A1 | 2 | **
66# | [NAME] | 2 | 547
67# | fgCYP622A1 mgCYP595A1 | 2 | 68
68# | fgCYP633A1 ncuCYP553A1 | 2 | 550
69# | fgCYP644A1 mgCYP526C1 | 2 | 526
70 | fgCYP65Q1 mgCYP65F1 | 2
71 | fgCYP65R1 mgCYP65K1 | 2
72 | [NAME] | 2
73 | [NAME] | 2
74 | [NAME] | 2
75 | mgCYP529A2 ncuCYP529A1 | 2
76 | [NAME] | 2
77 | mgCYP536A2 ncuCYP536A1 | 2
78 | mgCYP538A2 ncuCYP538A1 | 2
79 | [NAME] | 2
80 | mgCYP65B2 ncuCYP65B1 | 2
# indicates COGs containing genes from a different P450 family.
* indicates CYP636A1 and CYP660A1 were assigned to clan550 while mgCYP611A1 was excluded.
** indicates bootstrap support <70% but >50%, see text for details.
Spreadsheet: 80671d1280879813-pivot-table-date-problem-pivot1
Sheet: Sheet1

ID | balance | date
1 | 4 | 2009-01-01 00:00:00
2 | 1 | 2009-01-16 00:00:00
3 | 44 | 2009-01-31 00:00:00
4 | 1 | 2009-02-15 00:00:00 |  |  |  | Sum of balance
5 | 44 | 2009-03-02 00:00:00 |  |  |  | date | Total
6 | 1 | 2009-03-17 00:00:00 |  |  |  | <1/08/2009 | 104
7 | 1 | 2009-04-01 00:00:00 |  |  |  | Jan | 45
8 | 1 | 2009-04-16 00:00:00 |  |  |  | Feb | 2
9 | 1 | 2009-05-01 00:00:00 |  |  |  | Mar | 2
10 | 1 | 2009-05-16 00:00:00 |  |  |  | Apr | 2
11 | 1 | 2009-05-31 00:00:00 |  |  |  | May | 2
12 | 1 | 2009-06-15 00:00:00 |  |  |  | Jun | 2
13 | 1 | 2009-06-30 00:00:00 |  |  |  | Jul | 45
14 | 1 | 2009-07-15 00:00:00 |  |  |  | Aug | 2
15 | 1 | 2009-07-30 00:00:00 |  |  |  | Sep | 2
16 | 1 | 2009-08-14 00:00:00 |  |  |  | Oct | 45
17 | 1 | 2009-08-29 00:00:00 |  |  |  | Nov | 2
18 | 1 | 2009-09-13 00:00:00 |  |  |  | Dec | 2
19 | 1 | 2009-09-28 00:00:00 |  |  |  | >31/07/2010 | 2805
20 | 44 | 2009-10-13 00:00:00 |  |  |  | Grand Total | 3062
21 | 1 | 2009-10-28 00:00:00
22 | 1 | 2009-11-12 00:00:00
23 | 1 | 2009-11-27 00:00:00
24 | 1 | 2009-12-12 00:00:00
25 | 1 | 2009-12-27 00:00:00
26 | 1 | 2010-01-11 00:00:00
27 | 44 | 2010-01-26 00:00:00
28 | 1 | 2010-02-10 00:00:00
29 | 1 | 2010-02-25 00:00:00
30 | 1 | 2010-03-12 00:00:00
31 | 1 | 2010-03-27 00:00:00
32 | 1 | 2010-04-11 00:00:00
33 | 1 | 2010-04-26 00:00:00
34 | 1 | 2010-05-11 00:00:00
35 | 1 | 2010-05-26 00:00:00
36 | 1 | 2010-06-10 00:00:00
37 | 1 | 2010-06-25 00:00:00
38 | 1 | 2010-07-10 00:00:00
39 | 44 | 2010-07-25 00:00:00
40 | 87 | 2010-08-09 00:00:00
41 | 130 | 2010-08-24 00:00:00
42 | 173 | 2010-09-08 00:00:00
43 | 216 | 2010-09-23 00:00:00
44 | 259 | 2010-10-08 00:00:00
45 | 302 | 2010-10-23 00:00:00
46 | 345 | 2010-11-07 00:00:00
47 | 388 | 2010-11-22 00:00:00
48 | 431 | 2010-12-07 00:00:00
49 | 474 | 2010-12-22 00:00:00
Spreadsheet: 886108d1736123711-calculating-wage-salary-increase-efsalary
Sheet: Sheet1

 |  |  |  |  |  | Correct - Intention |  |  | [NAME] |  |  | Mismatch
 |  |  |  |  |  |  |  |  | Hourly - Seeking Help | Annual
 |  |  |  |  |  | 0.025 |  | 17.85
 |  |  |  |  |  | 0.025 |  | 18.3
 |  |  |  |  |  | 0.025 |  | 18.76
 |  |  |  |  |  | 0.025 |  | 19.23
 |  |  |  |  |  | 0.025 |  | 19.72
 |  |  |  |  |  | 0.03 |  | 20.32
 |  |  |  |  |  | 0.03 |  | 20.93
 |  |  |  |  |  | 0.035 |  | 21.67
 |  |  |  |  |  | 0.02 |  | 22.11
 |  |  |  |  |  | 0.01 |  | 22.34
 |  |  |  |  |  | 0.035 |  | 23.14
 |  |  |  |  |  | 0.015 |  | 23.49
 |  |  |  |  |  | 0.015 |  | 23.84
 |  |  |  |  |  | 0.015 |  | 24.2
 |  |  |  |  |  | 0.02 |  | 24.69
 |  |  |  |  |  | 0.03 |  | 25.45
 |  |  |  |  |  | 0.03 |  | 26.21
 |  |  |  |  |  | 0.03 |  | 27
 |  |  |  |  |  | 0.05 |  | 28.35
 |  |  |  |  |  | 0 |  | 28.35
 |  |  |  |  |  | 0.06 |  | 30.05
 |  |  |  |  |  | 0.0325 |  | 31.03
 |  |  |  |  |  | 0.03 |  | 31.96
 |  |  |  |  |  | 0.03 |  | 32.92
Spreadsheet: 102189d1300199912-multiple-cell-formula-example-1
Sheet: Result

 | Jun | Jul | Aug | Sep | Oct |  | Nov | Dec | Jan
Price | 30736 | 30736 | 30736 | 30736 | 30736 |  | 30533 | 30533 | 30533
Pages | 40 | 42 | 43 | 40 | 41 |  | 42 | 42 | 44
Grand Total | 4713.6
Spreadsheet: 113747d1309559446-vlookup-multiple-row-results-copy-of-example-lot-
Sheet: Sheet1 (2)

ID # | Grid # | Lot # | Frequency |  | Unique IDs | Lot #s
99553 | 99 | 1000 | 1 |  | 99553 | 1000
99569 | 99 | N/A | 1 |  | 99569 | N/A
99570 | 99 | N/A | 1 |  | 99570 | N/A
99593 | 99 | N/A | 1 |  | 99593 | N/A
99659 | 99 | 1001 | 1 |  | 99659 | 1001
99655 | 99 | N/A | 1 |  | 99655 | N/A
99699 | 99 | N/A | 1 |  | 99699 | N/A
99962 | 99 | N/A | 1 |  | 99962 | N/A
99939 | 99 | N/A | 1 |  | 99939 | N/A
99993 | 99 | N/A | 1 |  | 99993 | N/A
95050 | 99 | N/A | 1 |  | 95050 | N/A
95232 | 99 | M1000 | 1 |  | 95232 | M1000
95677 | 99 | N/A | 1 |  | 95677 | N/A
95795 | 99 | [NAME] | 4 |  | 95795 | [NAME] | H1001 | H1002 | H1003
95795 | 99 | H1001 | 4 |  | 95796 | M2000
95795 | 99 | H1002 | 4 |  | 96016 | N/A
95795 | 99 | H1003 | 4 |  | 96095 | 1010
95796 | 99 | M2000 | 1 |  | 96137 | N1102 | N1103 | N1104
96016 | 99 | N/A | 1 |  | 96139 | M03013 | M03014 | M03015 | M03016 | M03017 | M03018 | [NAME] | M03020 | M03021 | M03022 | M03023
96095 | 99 | 1010 | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96137 | 99 | N1102 | 3 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96137 | 99 | N1103 | 3 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96137 | 99 | N1104 | 3 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96139 | 99 | M03013 | 11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96139 | 99 | M03014 | 11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96139 | 99 | M03015 | 11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96139 | 99 | M03016 | 11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96139 | 99 | M03017 | 11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96139 | 99 | M03018 | 11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96139 | 99 | [NAME] | 11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96139 | 99 | M03020 | 11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96139 | 99 | M03021 | 11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96139 | 99 | M03022 | 11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
96139 | 99 | M03023 | 11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 59fdd2d9-528b-43eb-b29f-e6ec891370d1
Sheet: Sheet1

 |  | Year | Year | Year | Year | Year-to-date
 |  | 2006 | 2007 | 2008 | 2009 | 2010
 | MONETARY CONTEXT
 | Exchange rate local currency / EUR (at period end) | 92 | 92.24 | 104.07 | 110.3 | 106.54
 | Annual Inflation Rate (%) | 0.156 | 0.1203 | 0.178 | 0.0534 | 0.045
Spreadsheet: 773368d1647828855-find-string-and-prefix-zero-for-0-9-sample_data_final
Sheet: Sheet1

Summary | [NAME] | [NAME] | [NAME] | [NAME]
Site: TN | Node Outage | [NAME] |  |  |  |  | Current populated data with [NAME]
Site: TN | Node Outage | C1N16 |  | C01 | NA | N16 | Manually updated data, required data
Site: BGL | [NAME] | C1N02 |  | C01 | NA | N02
Site: BGL| Node outage | C2M1N03 |  | C02 | M01 | N03
Site: TEL | [NAME] | C02N09 |  | C02 | NA | N09
Site: AP | [NAME] | C01N04 |  | C01 | NA | N04
Site: BGL | [NAME] | C02N04 |  | C02 | NA | N04
Site: SDGE Escondido 3 | [NAME] | C01M02N01 |  | C01 | M02 | N01
Spreadsheet: 85793d1285836248-add-up-values-of-a-specific-month-based-on-status-sum-of-values
Sheet: Sheet1

Date | Value | Status
2010-09-01 00:00:00 | 27.8784 | OK
2010-03-08 00:00:00 | 138.24 | NOK
2010-03-01 00:00:00 | 28.8 | NOK |  | Sum of value/month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2009-12-20 00:00:00 | 4.32 | OK |  | Total Sum
2010-04-30 00:00:00 | 3.6864 | NOK |  | Sum of OK
2010-01-29 00:00:00 | 7.2 | NOK |  | Sum of NOK
2010-06-07 00:00:00 | 197.298 | OK
2010-06-10 00:00:00 | 81.36 | NOK
2010-03-30 00:00:00 | 2.26 | NOK
2010-03-30 00:00:00 | 10.8932 | OK
2010-06-10 00:00:00 | 41.22239999999999 | OK
2010-06-14 00:00:00 | 116.39 | OK
2010-09-05 00:00:00 | 24.86 | NOK
2010-10-30 00:00:00 | 142.4704 | OK
2010-06-14 00:00:00 | 18.165 | OK
2010-08-01 00:00:00 | 8.65 | OK
2010-08-01 00:00:00 | 8.65 | OK
2010-08-01 00:00:00 | 8.65 | NOK
2010-08-01 00:00:00 | 8.65 | NOK
2010-08-01 00:00:00 | 8.65 | OK
2010-04-30 00:00:00 | 232.5293 | NOK
2009-12-21 00:00:00 | 12.7413 | NOK
2010-08-30 00:00:00 | 6.170999999999999 | OK
2010-07-30 00:00:00 | 12.1 | NOK
2010-09-01 00:00:00 | 0.0968 | OK
2010-09-01 00:00:00 | 2.5102 | NOK
2010-01-04 00:00:00 | 2.7412 | OK
2010-02-12 00:00:00 | 121.3674 | NOK
2010-09-01 00:00:00 | 16.016 | NOK
2010-06-01 00:00:00 | 14.322 | OK
2010-06-01 00:00:00 | 83.3294 | NOK
2010-06-01 00:00:00 | 37.1756 | NOK
2010-05-02 00:00:00 | 2.2484 | OK
2010-06-01 00:00:00 | 12.8193 | NOK
2010-01-04 00:00:00 | 7.785 | NOK
2010-06-01 00:00:00 | 93.26429999999999 | OK
2010-06-01 00:00:00 | 9.169 | OK
2009-11-20 00:00:00 | 73.853 | OK
2010-02-12 00:00:00 | 71.484 | NOK
2010-02-25 00:00:00 | 19.32 | OK
2010-02-12 00:00:00 | 79.35 | OK
2010-12-15 00:00:00 | 46.92 | OK
2009-12-14 00:00:00 | 10.12 | OK
2010-09-19 00:00:00 | 11.385 | NOK
2010-12-09 00:00:00 | 5.52 | NOK
2010-05-20 00:00:00 | 5.75 | OK
2010-10-01 00:00:00 | 80.5 | NOK
2010-06-28 00:00:00 | 23 | NOK
2010-05-15 00:00:00 | 69 | OK
2010-08-31 00:00:00 | 198.996 | NOK
2010-01-27 00:00:00 | 2.507 | OK
2010-12-15 00:00:00 | 86.34199999999998 | NOK
2010-03-20 00:00:00 | 34.5 | OK
2010-04-16 00:00:00 | 34.73 | NOK
2010-05-03 00:00:00 | 46.23 | NOK
2010-03-11 00:00:00 | 48.3 | OK
2010-09-30 00:00:00 | 46 | NOK
2010-12-15 00:00:00 | 22.77 | NOK
2010-03-23 00:00:00 | 34.96 | OK
2010-01-30 00:00:00 | 115 | NOK
2009-12-10 00:00:00 | 117.3 | NOK
Spreadsheet: 138619d1327768574-excel-2007-performing-calculations-in-cells-2012-income
Sheet: last march

2011-03-31 00:00:00
0 |  | yes | Amount | Taxable Merch | Shipping Taxable | Sales Tax Payable | Non- taxable Merch | Shipping Non-Taxable | Income tax Income | MiscellaneousNon- Taxable | Owner Loan
Received From | Check No | Invoices Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 816751d1675809901-use-a-conditional-formula-for-duplicates-excel-example1
Sheet: data

IDs | Reccurence | Status
20265636 | 1 | ABC
20265636 | 2 | ABC
20265636 | 3 | ABC
20265509 | 1 | ABC
20265509 | 2 | XYZ
20265509 | 3 | XYZ
20265636 | 3 | ABC
Spreadsheet: 68725d1269297052-variable-list-from-another-sheet-offset
Sheet: Sheet2

185 | 15 | 15
195 | 20 | 16
205 | 25 | 17
215 | 30 | 18
225 | 35 | 19
235 | 40
245 | 45
255 | 50
265 | 55
275 | 60
Spreadsheet: 069f7f65-baa3-4566-a5d4-30679e57f34c
Sheet: 인천광역시

사회서비스 제공기관 등록 현황 파악 양식 (행복e음 통해 등록완료 후 전송된 데이터 기준)
* 2012.8.5~2012.11.4 기간 동안 등록제로 등록 전송한 제공기관 현황
시도 | 사업구분 | 제공기관명 | [NAME] | 연락처 | 대표자(제공기관장)
인천광역시 | 산모신생아 | (사)인구보건복지협회인천광역시지회 | 인천광역시 남동구 간석3동 34-4 | [PHONE] | 김기신
인천광역시 | 산모신생아 | (주)아림 | 인천광역시 동구 송현동 56번지 256호 | [PHONE] | 성미순
인천광역시 | 산모신생아 | 강화행복나눔재가센터 | 인천광역시 강화군 선원면 창리 세광2차아파트  208동 803호 | [PHONE] | [NAME]
인천광역시 | 산모신생아 | 김포 해피케어 | 인천광역시 서구 마전동 582-4 영진프라자 4층 | [PHONE] | [NAME]
인천광역시 | 산모신생아 | 다사랑산모케어 | 인천광역시 남구 주안동 506번지 45호 3층(경인로 334-17) | [PHONE] | 오원호
인천광역시 | 산모신생아 | 사랑애 아가마지 | 인천광역시 동구 송림동 105 (송림동) | [PHONE] | 이미해
인천광역시 | 산모신생아 | 산모도우미 인천/김포지점 | [NAME] 부평1동 54-3 쌍용플래티넘 804호 | [PHONE] | 최진향
인천광역시 | 산모신생아 | 산모도우미119인천점 | 인천광역시 계양구 계산동 1074번지 4호 광성프라자 빌딩 201호 | [PHONE] | 이순옥
인천광역시 | 산모신생아 | 산모피아 | 인천광역시 계양구 용종동  212-6 계양스카이홈 719 | [PHONE] | 오신억
인천광역시 | 산모신생아 | 아이미래로 | 인천광역시 남동구 간석동 77, 101호 (간석동) | [PHONE] | 김덕희
인천광역시 | 산모신생아 | 인천광역시자립자활지원협회 | 인천광역시 남동구 만수동 1093 | [PHONE] | 정성기
인천광역시 | 산모신생아 | 해피케어 | 인천광역시 부평구 부평동  549-36 문화오피스텔 707호 | [PHONE] | 이승림
Spreadsheet: b30d4e46-12bd-4609-858d-1e39fa2429fb
Sheet: In-force - Net

Universal American Corp.
Annualized Premium In Force - Net Retained
Continuing Operations
As of December 31, 2011
($ in millions)
 |  |  | Current Quarter |  |  |  |  |  | Prior Quarter |  |  |  |  |  |  |  |  |  | Prior Year Quarter
 |  |  | 2011-12-31 00:00:00 |  |  |  |  |  | 2011-09-30 00:00:00 |  |  |  |  |  | Change vs Sep-11 |  |  |  | 2010-12-31 00:00:00 |  |  |  |  |  | Change vs Dec-10
 |  |  | Gross | Ceded | Net |  | % Retained |  |  |  |  |  |  |  | Net |  |  |  | Gross |  |  |  |  |  | Net
Medicare Advantage |  |  | 1801.50985224 | -4.872 | 1796.63785224 |  | 0.9972956018009326 |  | 1881.1381548 | -3.193000000000001 | 1877.9451548 |  | 0.9983026233390394 |  | -81.30730256000015 |  | -0.001007021538106834 |  | 3039.25476192 | -37.752 | 3001.50276192 |  | 0.9875785338981748 |  | -1204.86490968 |  | 0.009717067902757726
Traditional Insurance |  |  | 377.4038733599997 | -116.1981512570806 | 261.2057221029191 |  | 0.6921119271443169 |  | 385.709071 | -118.2122595879868 | 267.4968114120132 |  | 0.6935196279374337 |  | -6.291089309094048 |  | -0.001407700793116806 |  | 415.147655 | -130.5818720765528 | 284.5657829234472 |  | 0.6854567995173843 |  | -23.36006082052808 |  | 0.006655127626932655
 | Total |  | 2178.913725599999 | -121.0701512570806 | 2057.843574342919 |  | 0.944435546100504 |  | 2266.8472258 | -121.4052595879868 | 2145.441966212013 |  | 0.9464431223215135 |  | -87.5983918690942 |  | -0.002007576221009555 |  | 3454.40241692 | -168.3338720765528 | 3286.068544843447 |  | 0.9512697561662078 |  | -1228.224970500528 |  | -0.006834210065703838
Spreadsheet: 837428d1690178698-need-a-formula-that-adds-interval-to-last-visit-date-sample40-aligw
Sheet: Sheet1

 |  | Table 1 |  |  | Table 2
 |  | Last Visit | Category |  | Category | Interval | Interval2
 |  | 2023-06-17 00:00:00 | AB |  | AB | 2 | Month
 |  | 2023-07-09 00:00:00 | AVB |  | AVB | 3 | Month
 |  | 2023-07-13 00:00:00 | SYT |  | SYT | 1 | Year
 |  |  |  |  | Table 3
 |  |  |  |  | Due Date
 |  |  |  |  | Category | Due Date
 |  |  |  |  | AB | 2023-08-17 00:00:00
 |  |  |  |  | AVB | 2023-10-09 00:00:00
 |  |  |  |  | SYT | 2024-07-13 00:00:00
Spreadsheet: 479846d1473619787-find-name-that-carries-the-shift-on-that-day-modulo-prova-1-
Sheet: Ottobre (2)

 |  | [NAME]
 | Data
 | Turno Mattina | Turno Pomeriggio | Turno Notturno
 | 07.00 - 13.00 | 13.00 - 19.00 | 19.00 - 07.00
 | [NAME] dovrebbe contenere il resoconto giornaliero
 | Data
 | Turno Mattina | Turno Pomeriggio | Turno Notturno
 | 07.00 - 13.00 | 13.00 - 19.00 | 19.00 - 07.00
 |  |  | Pippo
 | Francesco B
 | Virginia | Virginia | Virginia
 | Pietro | Pietro | Pietro
 | Stefania | Stefania | Stefania
 | Giovanni
 | Simone | Simone | Simone
 | Valerio | Valerio | Valerio