tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 88117d1288034157-multiple-column-lookup-example
Sheet: Legend

Opting Into DB? | New or Existing | Original | Direct Mail Flag | [NAME] (Only if email exists; otherwise no action is taken)
Yes | Existing | Y | N | N
Yes | Existing | Null | Null | Null
Yes | Existing | N | N | N
Yes | New | New Record | Null | Null
No | Existing | Y | Y | Y
No | Existing | Null | Null | Null
No | Existing | N | N | N
No | New | New Record | Y | Y
New Record | Existing Record | Yes | No
New Record | Y | New | New
 | Null | Existing | Existing
 | N
Spreadsheet: 762841d1641848025-ranking-updates-when-using-autofilter-sample-ranking
Sheet: Sheet1

Rank | House | [NAME] | Chain Master | Chain | Customer | Customer Name | Customer Address | Metrics | Cs (YTD) | Cs (YTD LY) | Var (YTD TY-YTD LY) | % [NAME] (YTD TY vs. [NAME])
1 | CCR | OFF | CHAIN A | CHAIN A | 700008562 | Account 1 |  |  | 126 | 119 | 7 | 0.0588235294117647
2 | ELP | OFF | CHAIN B | CHAIN B | 701008307 | Account 2 |  |  | 91 | 76 | 15 | 0.197368421052632
3 | GRP | OFF | CHAIN C | CHAIN C | 700005963 | Account 3 |  |  | 80 | 49 | 31 | 0.63265306122449
4 | LUB | OFF | CHAIN A | CHAIN A | 700008069 | Account 4 |  |  | 76 | 80 | -4 | -0.05
5 | HOU | OFF | CHAIN B | CHAIN B | 700008030 | Account 5 |  |  | 74 | 70 | 4 | 0.0571428571428571
6 | SAA | OFF | CHAIN C | CHAIN C | 700003163 | Account 6 |  |  | 70.917 | 77.584 | -6.667 | -0.0859326665291813
7 | CCR | ON | CHAIN A | CHAIN A | 701008590 | Account 7 |  |  | 68 | 71 | -3 | -0.0422535211267606
8 | ELP | ON | CHAIN B | CHAIN B | 700004687 | Account 8 |  |  | 61 | 31 | 30 | 0.967741935483871
9 | GRP | ON | CHAIN C | CHAIN C | 700008210 | Account 9 |  |  | 59 | 62 | -3 | -0.0483870967741936
10 | LUB | ON | CHAIN A | CHAIN A | 701008291 | Account 10 |  |  | 50 | 57 | -7 | -0.12280701754386
11 | HOU | ON | CHAIN B | CHAIN B | 700008446 | Account 11 |  |  | 42 | 29 | 13 | 0.448275862068966
12 | SAA | ON | CHAIN C | CHAIN C | 700004711 | Account 12 |  |  | 38 | 37 | 1 | 0.027027027027027
13 | CCR | OFF | CHAIN A | CHAIN A | 700007841 | Account 13 |  |  | 35 |  | 35
14 | ELP | OFF | CHAIN B | CHAIN B | 700005435 | Account 14 |  |  | 35 | 35 | -1 | -0.0285714285714286
15 | GRP | OFF | CHAIN C | CHAIN C | 700001812 | Account 15 |  |  | 35
16 | LUB | OFF | CHAIN A | CHAIN A | 701008383 | Account 16 |  |  | 34
17 | HOU | OFF | CHAIN B | CHAIN B | 700008413 | Account 17 |  |  | 33
18 | SAA | OFF | CHAIN C | CHAIN C | 701002282 | Account 18 |  |  | 32
19 | CCR | ON | CHAIN A | CHAIN A | 700008488 | Account 19 |  |  | 31
20 | ELP | ON | CHAIN B | CHAIN B | 701004445 | Account 20 |  |  | 30
21 | GRP | ON | CHAIN C | CHAIN C | 700003151 | Account 21 |  |  | 29
22 | LUB | ON | CHAIN A | CHAIN A | 700004640 | Account 22 |  |  | 28
23 | HOU | ON | CHAIN B | CHAIN B | 700004691 | Account 23 |  |  | 27
24 | SAA | ON | CHAIN C | CHAIN C | 701008212 | Account 24 |  |  | 26
25 | HOU | ON | CHAIN A | CHAIN A | 701002286 | Account 25 |  |  | 25
Spreadsheet: 691396d1597677101-formula-based-on-variable-cells-and-values-bracket-example
Sheet: P1

CELLS THIS COLOUR ARE TO BE TYPED IN
CELLS THIS COLOUR ARE DROP DOWN CHOICES
CELLS THIS COLOUR SELF POPULATE
 | Sprinkler Bracket Take-Off P1
Section 1: General Details
Contract Name: |  |  |  |  |  |  | Contract Number:
Delivery Address: |  |  |  |  |  |  | Post Code:
Completed By: |  |  |  |  |  |  | Designer:
Date: |  |  |  |  |  |  | Revision:
Standard:
Section 2: Designer Details
Drawing Number:
Drawing Area:
Drawing Approved By: |  |  |  |  |  |  | Approval Date:
Section 3: Bracket Requirements
Bracket Limitations & Restrictions:
Bracket Type Requirements: Variation 1 | Reference | Description |  |  |  |  | Quantity
 | A | [NAME] |  |  |  |  | 1
 | B | Allthread Rod |  |  |  |  | X(mm)
 | C | Flange Nuts |  |  |  |  | 4
 | D | Filbows 25mm - 65mm |  |  |  |  | 1
Section 4: Component Quantities
Pipe Size: | 25 mm | 32 [NAME] | 40 mm | 50 mm | 65 mm | 80 mm | 100 mm | 150 mm | 200 mm | 250 mm | 300 mm | 350 mm | 400 mm
Number of Brackets: |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Section 5: Dimensions
Pipe Size: | 25 mm | 32 [NAME] | 40 mm | 50 mm | 65 mm | 80 mm | 100 mm | 150 mm | 200 mm | 250 mm | 300 mm | 350 mm | 400 mm
Length of X in mm: |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Section 6: Component Breakdown
Type | Stock Code |  |  | Stock Description |  |  |  | Quantity |  | Price | Qty Price | Location
Channel & Accessories |  |  |  | [NAME] |  |  |  |  |  | 0.01 |  | AA
Hangers |  |  |  | Filbows LPCB Approved 25mm |  |  |  |  |  | 0.01 |  | AB
Hangers |  |  |  | Filbows LPCB Approved 32[NAME] |  |  |  |  |  | 0.01 |  | AC
Hangers |  |  |  | Filbows LPCB Approved 40mm |  |  |  |  |  | 0.01 |  | AD
Hangers |  |  |  | Filbows LPCB Approved 50mm |  |  |  |  |  | 0.01 |  | AE
Hangers |  |  |  | Filbows LPCB Approved 65mm |  |  |  |  |  | 0.01 |  | AF
Nuts & Washers |  |  |  | Flange Nuts |  |  |  |  |  | 0.01 |  | AG
Sets / Bolts/ Screws |  |  |  | Allthread Rod |  |  |  |  |  | 0.01 |  | AH
Total Price Per Bracket
Total Price Per Number of Brackets:
Spreadsheet: 774771d1648652470-formula-to-calculate-elapsed-time-between-two-dates-times-covid-pay-audit
Sheet: Sheet2

 | Enter First Date |  |  |  |  |  |  | 00:00:00 |  | 07:00:00 |  | 19:00:00 |  | 23:59:00 |  |  | Day Shift Total | Night Shift Total
 | 2022-03-13 00:00:00
First Day of Data
Last Day of Data
Spreadsheet: 32fa4ea4-9156-4e23-bace-f99396a6d19e
Sheet: 6 Months

Johnson & Johnson and Subsidiaries
Condensed Consolidated Statement of Earnings
(Unaudited; in Millions Except Per Share Figures) |  |  | SIX MONTHS
 |  |  | 2010 |  |  |  | 2009 |  |  |  | Percent
 |  |  |  |  | Percent |  |  |  | Percent |  | Increase
 |  |  | Amount |  | to Sales |  | Amount |  | to Sales |  | (Decrease)
Sales to customers |  |  | 30961 |  | 100 |  | 30265 |  | 100 |  | 2.299686106063109
Cost of products sold |  |  | 9158 |  | 29.5791479603372 |  | 8701 |  | 28.74938047249298 |  | 5.252269854039766
Selling, marketing and administrative expenses |  |  | 9535 |  | 30.79680888860179 |  | 9405 |  | 31.075499752189 |  | 1.382243487506645
Research expense |  |  | 3205 |  | 10.35173282516715 |  | 3156 |  | 10.42788699818272 |  | 1.552598225602028
Interest (income)expense, net |  |  | 139 |  | 0.4489519072381383 |  | 166 |  | 0.648488352882868
Other (income)expense, net |  |  | -1576 |  | -5.090274861923064 |  | -69 |  | -0.2279861225838427
Earnings before provision for taxes on income |  |  | 10500 |  | 33.90363328057879 |  | 8906 |  | 29.42673054683628 |  | 17.89804626094768
Provision for taxes on income |  |  | 2525 |  | 8.145421336520139 |  | 2191 |  | 7.239385428713035 |  | 15.24418073938841
Net earnings |  |  | 7975 |  | 25.75821194405866 |  | 6715 |  | 22.18734511812324 |  | 18.76396128071482
Net earnings per share  (Diluted) |  |  | 2.85 |  |  |  | 2.41 |  |  |  | 18.25726141078838
Average shares outstanding  (Diluted) |  |  | 2796.1 |  |  |  | 2785.5
Effective tax rate |  |  | 24.04761904761905 | % |  |  | 24.60139231978442 | %
Adjusted earnings before provision for taxes and net earnings
Earnings before provision for taxes on income |  |  | 9160 | (1) | 29.58560770000969 |  | 8906 |  | 29.42673054683628 |  | 2.852009880979115
Net earnings |  |  | 6998 | (1) | 22.6026291140467 |  | 6715 |  | 22.18734511812324 |  | 4.214445271779598
Net earnings per share  (Diluted) |  |  | 2.5 | (1) |  |  | 2.41 |  |  |  | 3.73443983402489
Effective tax rate |  |  | 0.2360262008733625 |  |  |  | 0.2460139231978442
(1) The difference between as reported earnings and as adjusted earnings before provision for taxes on income, net earnings and net earnings per
share (diluted) is the exclusion of income from net litigation of $1,340 million, $977 million and $0.35 per share, respectively.
Spreadsheet: 0106eeea-0b67-4a72-84ac-22520e8fd084
Sheet: TEST 1 (T1)

TEST 1
 | Table 1a: Test 1 using 50 ul of sample and an additional analysis to determine [NAME] affectiveness |  |  |  |  |  |  |  |  |  |  |  | Table 1b: Test 1 repeats using 50 ul of sample.
 | FG3 experiment | Sample id. | v (ul) | 230 | 260 | 270 | 280 | 260/280 |  |  |  |  | NLIS tag | v (ul) | 230 | 260 | 270 | 280 | 260/280
 |  | 1 | 50 | 0.079 | 0.044 | 0.041 | 0.037 |  |  |  |  | Repeat | 5 | 50 | 0.002 | 0.001 | 0 | 0
 |  | 2 | 50 | 0.019 | 0.021 | 0.018 | 0.018 |  |  |  |  | Repeat | 11 | 50 | 0.023 | 0.005 | 0.005 | 0.005
 |  | 3 | 50 | 0.025 | 0.01 | 0.01 | 0.008 |  |  |  |  | Repeat | 21 | 50 | 0.01 | 0 | 0 | 0
 |  | 4 | 50 | 0.015 | 0.007 | 0.006 | 0.005 |  |  |  |  | Repeat | 22 | 50 | 0.011 | 0 | 0 | 0
 | Fresh 400 | 5 | 50 | 0 | -0.001 | -0.002 | -0.002 |  |  |  |  |  | Median
 |  | 6 | 50 | 0.033 | 0.012 | 0.012 | 0.01 |  |  |  |  |  | STDEV
 | Fresh 500 | 7 | 50 | 0.008 | 0.005 | 0.004 | 0.004 |  |  |  |  |  | AV
 |  | 8 | 50 | 0.033 | 0.016 | 0.015 | 0.012
Red mark |  | 9 | 50 | 0.037 | 0.022 | 0.019 | 0.015 |  |  |  |  |  | Table 1c: Test 1 displaying detailed data relating to increasing/replacing FG3 level
 | Fresh 1000 V | 10 | 50 | 0.003 | 0.002 | 0.001 | 0.001 |  |  |  |  |  | ANALYSE THIS BY T-TEST |  |  | TEST 1
 |  | 11 | 50 | 0.01 | 0 | 0.003 | 0.004 |  |  |  |  |  |  | [NAME] incorporated into samples |  |  |  |  | FG3 replaced with fresh [NAME] (total)
 | Add. 1000 V | 12 | 50 | 0.013 | 0.004 | 0.005 | 0 | 0 |  |  |  |  |  | FG3 (ul) | Sample id. | FG3 (ul) | Sample id. |  | FG3 (ul) | Sample id. | FG3 (ul) | Sample id.
 | Add. 1000 V | 13 | 50 | 0.015 | 0.005 | 0.005 | 0.005 |  |  |  |  |  | Non-vortexed | 400 | 15 | 500 | 22 |  | 400 | 5 | 500 | 7
 |  | 14 | 50 | 0.01 | 0.004 | 0.004 | 0.003 |  |  |  |  |  | Vortexed* | 400 | 12 | 500 | 13 |  | 400 | 20 | 500 | 10
 | Add. 400 | 15 | 50 | 0.014 | 0.004 | 0.004 | 0.003 |  |  |  |  |  | [NAME] | 100 |  | 100 |  |  | 100 |  | 100
 |  | 16 | 50 | 0.051 | 0.008 | 0.007 | 0.004 |  |  |  |  |  | " | 500 |  | 400 |  |  | 500 |  | 400
 |  | 17 | 50 | 0.046 | 0.016 | 0.016 | 0.013 |  |  |  |  |  | NOTE: Cross reference sample id. In the table opposite (left)
 |  | 18 | 50 | 0.01 | 0 | 0 | 0 | 0 |  |  |  |  | *Vortexing speed was at maximum rate for at least 50 secs.
 |  | 19 | 50 | 0.01 | 0.007 | 0.006 | 0.004
 | Fresh 1000 V | 20 | 50 | 0.004 | 0.003 | 0.002 | 0.002
 |  | 21 | 50 | 0.01 | 0 | 0 | 0 | 0
 | Add. 500 | 22 | 50 | 0.011 | 0 | 0 | 0.001
 |  | 23 | 50 | 0.022 | 0.007 | 0.006 | 0.005
Red mark |  | 24 | 50 | 0.018 | 0.018 | 0.011 | 0.009
 |  | Median
 |  | STDEV
 |  | AV
Spreadsheet: 464488d1465153087-how-count-occurences-in-multiple-separated-columns-using-countif-or-other-function-tr-eng
Sheet: Tom Smith

Monthly driving report
 | Terrain………………Month: May |  |  |  |  | [NAME]
No. | Monday | No. Of visits | Tuesday | No. Of visits | Wensday | No. Of visits | Thursday | No. Of visits | Friday | No. Of visits
1. | [NAME] |  | Unknown |  | 229 Tennessee Rd |  | 1164 15th Ave N |  | 1713 S Osprey Rd
2. | Head Quarters |  | Unknown |  | 229 Tennessee Rd |  | Head Quarters |  | Head Quarters
3. | Head Quarters |  | Unknown |  | xxxx |  | Head Quarters |  | Head [NAME]
4. | Station Line |  | 5992 S Fingo Rd |  | xxxx |  | Area Landscape |  | Station Line
5. | Head [NAME] |  | Head Quarters |  | Head Quarters |  | 5774  Harp Ave |  | Head [NAME]
6. | 163rd Ave |  | Head [NAME] |  | Head [NAME] |  | Area Landscape |  | 277 Farm Rd
7. | 13746 [NAME] Dr |  | Head Quarters |  | Head Quarters |  | Head Quarters |  | [NAME]
8. | Head Quarters |  | Head Quarters |  | 259 131st Trail |  | Head Quarters |  | [NAME]
9. | Head [NAME] |  | Patalerno Dr |  | 15 Nighthawk Dr |  | 16685 [NAME] |  | [NAME]
10. |  |  |  |  | 13 Nighthawk Dr |  | Head [NAME] |  | [NAME]
11. |  |  |  |  | 4557 [NAME]
12.
13.
14.
No. | Monday | No. Of visits | Tuesday | No. Of visits | Wensday | No. Of visits | Thursday | No. Of visits | Friday | No. Of visits
1. | 229 Tennessee Rd |  | 1713 S Osprey Rd |  | [NAME] |  | 5992 S Fingo Rd
2. | 229 Tennessee Rd |  | Head Quarters |  | Head Quarters |  | Head Quarters
3. | Base |  | Head [NAME] |  | Head Quarters |  | Head [NAME]
4. | Head [NAME] |  | Station Line |  | Station Line |  | Head Quarters
5. | Head Quarters |  | Head [NAME] |  | Head [NAME] |  | Head Quarters
6. | Head [NAME] |  | 277 Farm Rd |  | 163rd Ave |  | Patalerno Dr
7. | Head Quarters |  | [NAME] |  | 13746 [NAME] Dr |  | 5992 S Fingo Rd
8. | 259 131st Trail |  | [NAME] |  | Head Quarters |  | Head Quarters
9. | 15 Nighthawk Dr |  | [NAME] |  | Head [NAME] |  | Head [NAME]
10. | 13 Nighthawk Dr |  | [NAME] |  |  |  | Head Quarters
11. | 4557 [NAME] |  |  |  |  |  | Head Quarters
12. |  |  |  |  |  |  | Patalerno Dr
13.
14.
Spreadsheet: 215a2447-90c5-4a4b-af53-4a63405157c2
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
 | 6427.0 Producer Price Indexes, Australia
 | Table 27. Output of the Other services industries, group and class index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  9533 Parking services ; |  |  | Original | A2314112L | 1998-09-01 00:00:00 | 2013-03-01 00:00:00 | 59 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: 752206d1634650106-nested-if-and-not-returning-expected-value-example2
Sheet: Sheet1

Guar Acct ID | Guarantor Name | Account Type | SP Balance | Years
 |  | Personal/Family | 605.96
 |  | Personal/Family | 130.17
 |  | Personal/Family | 108.48
 |  | Personal/Family | 489.53
 |  | Personal/Family | 204.77
 |  | Personal/Family | 399.3
 |  | Personal/Family | 1699.5
 |  | Personal/Family | 221.11
 |  | Personal/Family | 183.27
 |  | Personal/Family | 148
 |  | Personal/Family | 73.96
 |  | Personal/Family | 156.62
 |  | Personal/Family | 840.32
 |  | Personal/Family | 125
 |  | Personal/Family | 632.66
 |  | Personal/Family | 1568
 |  | Personal/Family | 87.13
 |  | Personal/Family | 163.58
 |  | Personal/Family | 316.23
 |  | Personal/Family | 1457.8
 |  | Personal/Family | 174.25
 |  | Personal/Family | 39.28
 |  | Personal/Family | 604.02
 |  | Personal/Family | 132.12
 |  | Personal/Family | 339.37
 |  |  |  | x
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 64

कार्यक्रम PROGRAM |  |  | व्यर्खस्थि सॉफ्ट खिल प्रतिक्षण कार्यक्रम STRUCTURED SOFT SKILL TRAINING PROGRAM | PROG CODE
 |  |  |  | IT 2307
तर्षर् समूह/SUBJECT GROUP |  |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य/OBJECTIVE |  |  | CUSTOMER SERVICE, MOTIVATION & WORK LIFE BALANCE
लतक्षि समूह/TARGET GROUP |  |  | MIXED
अर्तध/DURATION |  |  | 1 DAY
DAY | SESSION | CONTENTS
Day 1 | I | Customer Service & Relationship Management - Customer Handling with empathy, Customer Grievance Management
 | II | Sales   &   Business   Ethics   -   Planning   Sales,   New   age   skills   of Marketing/Cross Selling, Reference Marketing
 | III | Motivation - Addressing root cause of dissatisfaction, Empowerment & Participation
 | IV | Work Life Balance - Prioritizing Work, Stress & Time Management
Spreadsheet: 825746d1681490100-verify-characters-in-same-cell-on-multiple-sheets-are-the-same-copy-2-etaf
Sheet: TOTAL

SITE | PROJECT | Project Number | Actual spent | P/R
MASTER TOTALS
 | 2022-07-15 00:00:00 | 33608600045 |  | R
 | 2022-07-31 00:00:00 | 33608600045 |  | P
 | 2022-08-15 00:00:00 | 33608600045 |  | P
 | 2022-08-31 00:00:00 | 33608600045 |  | P
 | 2022-09-15 00:00:00 | 33608600045 |  | R
 | 2022-09-30 00:00:00 | 33608600045 |  | P
 | 2022-10-15 00:00:00 | 33608600045 |  | P
 | 2022-10-31 00:00:00 | 33608600045 |  | P
 | 2022-11-15 00:00:00 | 33608600045 |  | P
 | 2022-11-30 00:00:00 | 33608600045 |  | P
 | 2022-12-15 00:00:00 | 33608600045 |  | P
 | 2022-12-31 00:00:00 | 33608600045 |  | P
AH [NAME]
Amicalola Falls
[NAME]
Black Rock Mountain
[NAME]
Brazell's Creek Golf Course
Cloudland Canyon
Crooked River
Dahlonega Gold Museum
[NAME]
[NAME]
Florence Marina
[NAME] George
[NAME]
Fort Morris
Fort Mountain
Fort Yargo
General Coffee
[NAME]
[NAME]
Georgia Veterans
Golf ops office
Gordonia-Alatamaha
Hamburg
Hard Labor Creek
Hart
[NAME]
Highland Walk Golf Course
Hofwyl-Broadfield Plantation
Indian Springs
[NAME]
Jarrell Plantation
[NAME]
[NAME]
Kolomoki Mounds
[NAME]
Little Ocmulgee
Little Ocmulgee Golf Course
Little White House
Lodge office
LP House
Magnolia Springs
Meadow Links Golf Course
Mistletoe
[NAME]
New Echota
New Echota
Panola Mountain
[NAME]
Providence Canyon
Red Top Mt.
Reed Bingham
Reg 1 Office
Reg 2 office
Reg 3 Office
Reynolds Mansion
[NAME]
[NAME]
Seminole
Skidaway Island
Smith Gall Woods
Sprewell Bluff
[NAME]
Sweetwater Creek
[NAME]
The Creek Golf Course
The Lakes Golf Course
Travelers Rest
Tugaloo
Unicoi
Vann House
[NAME]
Vogel
[NAME]
Wormsloe
Spreadsheet: hunter_shively__12722__Fundamentals_Netco
Sheet: Canada

 | Canada
 | 2002 Plan
 |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2002 |  | 2002 |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  |  |  | 0
 | Analysts & Associates | 0 |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  | 927072 | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | Analyst | 66000
ENATAXES | Taxes Other than Income |  |  |  |  |  | Associate | 97200 | 2
ENATOTDR | Total Direct Expenses |  |  |  |  |  | Manager | 120000
 |  |  |  |  |  |  | Director | 156000 | 4
 | Headcount |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  | VP | 216000
 | Analyst & Associate Headcount |  |  |  |  |  | CEO | 240000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | *  Analysts and Associates are billed through normal payroll for Canada. |  |  |  |  | Other Expense Calculation
ENAOUTTX
ENAINSUR |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
ENASYSDV
ENACORIT
ENACORRN
ENAOTHAL
ENADEPR
Spreadsheet: 741129d1626853507-countifs-and-dates-stats-wip
Sheet: Calculation

Current Open Tickets
Closed Calls
Total Calls
Calls Per SVD for June | OPEN | CLOSED
HUBBLE BI TEAM
SEAS AP C & VEN
SEAS DEVELOPMENT
SEAS SYS SUPDEV
SEAS HELPDESK
SEAS INTERFACES
SEAS SME Escalation
SEAS SYS ADMIN
SEAS T & B
Totals
Weekly Calls Logged | 31/5/21 | 7/6/21 | 14/6/21 | 21/6/21 | 28/6/21 | 5/7/21 | 12/7/21 | 19/7/21
HUBBLE BI TEAM
SEAS AP C & VEN
SEAS DEVELOPMENT
SEAS SYS SUPDEV
SEAS HELPDESK
SEAS INTERFACES
SEAS SME Escalation
SEAS SYS ADMIN
SEAS T & B
Weekly totals closed | 31/5/21 | 7/6/21 | 14/6/21 | 21/6/21 | 28/6/21 | 5/7/21 | 12/7/21 | 19/7/21
HUBBLE BI TEAM
SEAS AP C & VEN
SEAS DEVELOPMENT
SEAS SYS SUPDEV
SEAS HELPDESK
SEAS INTERFACES
SEAS SME Escalation
SEAS SYS ADMIN
SEAS T & B
Spreadsheet: 4c1d8b69-02f0-401d-935e-9c1062d0a1bd
Sheet: Sheet1

Unnamed: 0 | ROTARY INTERNATIONAL - REMBOURSEMENT DES DÉPENSES DE RELATIONS PUBLIQUES | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | District ___________________________ | RI FY 12-13
 | Nom/e-mail du contact ____________________________    MONTANT DE LA SUBVENTION _______________________ | Formulaires joints : RENSEIGNEMENTS SUR LE DESTINATAIRE DES FONDS  A RAPPORT DE L'ACTION A |  |  | SPA TO A/P ________________
 |  |  |  |  |  |  | PREUVE DE  RÉALISATION  DE L'ACTION
 | Veuillez vous référer à la lettre d’approbation de votre subvention pour connaître la liste des dépenses éligibles. [NAME] également des copies des factures, les justificatifs de paiement, une preuve de la réalisation de l’action Relations publiques ET le formulaire de renseignements sur le destinataire des fonds. Vous pouvez également consulter le document Instructions pour les paiements sur www.rotary.org/RIdocuments/fr_pdf/rits_payment_guidelines_fr.pdf
 |  |  |  |  | REÇU JOINT | FACTURE JOINTE
 |  |  | DEVISE | TOTAL
 | NOM DU FOURNISSEUR & INTITULÉ DE LA DÉPENSE | DATE
 | Office Use Only. Notes: |  | Sous-total |  | Devise
 |  |  | Office Use Only |  | Currency exchange rate
 |  |  |  |  | Total US$
 |  |  |  |  | [NAME] amount  (local currency)
 |  |  | TOTAL |  | TOTAL  US$ AMOUNT PAID
Spreadsheet: 168049d1342202038-pivot-table-calculating-percentage-on-grand-total-pivot-test
Sheet: Ark1

Order | Amount | Type |  | Sum of Amount | Type
101 | -1212 | Revenue |  | Order | Revenue | Cost | Grand Total
101 | -3434 | Revenue |  | 101 | -4646 | 3678 | -968
102 | -5678 | Revenue |  | 102 | -5801 | 2348 | -3453
101 | 3678 | Cost |  | 103 | -91346 | 56098 | -35248
102 | -123 | Revenue |  | 104 | -112436 | 81221 | -31215
102 | 2348 | Cost |  | 105 | -1456709 | 988756 | -467953
103 | -1001 | Revenue |  | 106 | -5564 | 1198 | -4366
103 | -90345 | Revenue |  | 107 | -453 | 333 | -120
103 | 56098 | Cost |  | 108 | -164456 | 97666 | -66790
104 | -112436 | Revenue |  | 109 | -34556 | 23345 | -11211
104 | 74545 | Cost |  | 110 | -112233 | 99999 | -12234
104 | 6676 | Cost |  | 111 | -86481 | 56346 | -30135
105 | 988756 | Cost |  | Grand Total | -2074681 | 1410988 | -663693
105 | -1456709 | Revenue
106 | 654 | Cost
106 | 544 | Cost
106 | -5564 | Revenue
108 | -164456 | Revenue
108 | 97666 | Cost
109 | -34556 | Revenue
107 | -453 | Revenue
107 | 333 | Cost
109 | 23345 | Cost
110 | -112233 | Revenue
110 | 99999 | Cost
111 | -86481 | Revenue
111 | 56346 | Cost