tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 193490d1352846199-could-anyone-help-me-simplify-a-very-long-and-drawn-out-process-ef263a_october-sales-analysis
Sheet: month_summary

 | Select MONTH: | 9
 | Select YEAR: | 2012
 | AB |  |  |  |  |  | SK |  |  |  |  |  | WP
Day | # of invoices | Daily total | Daily gross profit | Avg. $/trans |  | Day | # of invoices | Daily total | Daily gross profit | Avg. $/trans |  | Day | # of invoices | Daily total | Daily gross profit | Avg. $/trans
 |  |  |  | MONTHLY | invoices
 |  |  |  | MONTHLY | total
 |  |  |  | MONTHLY | profit
 |  |  |  | MONTHLY | average
 | 34 | 6536.42 | 18897.26 | 555.8017647058824
 | 16 | 5646.34 | 20124.89 | 1257.805625
 | 23 | 4056.41 | 12479.72 | 542.5965217391305
 | 23 | 4112.86 | 12015.82 | 522.4269565217392
 | 20 | 4154.1 | 11719.94 | 585.9970000000001
 | 23 | 9824.51 | 29438.95 | 1279.954347826087
 | 18 | 2895.34 | 9135.7 | 507.5388888888889
 | 35 | 15389.61 | 50297.35999999999 | 1437.067428571428
 | 34 | 19102.99 | 56950 | 1675
 | 35 | 10986.31 | 42836.64000000001 | 1223.904
 | 16 | 5903.679999999999 | 18497.4 | 1156.0875
 | 26 | 9719.400000000001 | 31819 | 1223.807692307692
 | 9 | 2260.53 | 5863.93 | 651.5477777777778
 | 22 | 3832.78 | 10303.04 | 468.3200000000001
 | 41 | -1440.4 | 4823.819999999999 | 117.6541463414634
 | 12 | 18757.31 | 75800.04000000001 | 6316.670000000001
 | 12 | 13876.32 | 52315.43 | 4359.619166666666
 | 15 | 2677.06 | 9839.99 | 655.9993333333333
 | 10 | 1304.1 | 4286.03 | 428.603
 | 8 | 977.8 | 3138.38 | 392.2975
 | 8 | 9705.75 | 44126.3 | 5515.787499999999
 | 8 | 402.23 | 1187.77 | 148.47125
 | 4 | 713.3599999999999 | 2260 | 564.9999999999999
 | 7 | 717.6800000000001 | 2344.1 | 334.8714285714286
 | 6 | 1060.85 | 3694.46 | 615.7433333333332
 | 9 | 2892.94 | 10497.39 | 1166.376666666667
 | 7 | 19236.75 | 81470.92 | 11638.70285714286
 | 4 | 634.66 | 2653.38 | 663.345
 | 12 | 4966.74 | 19018.77 | 1584.8975
 | 6 | 768.21 | 2379.13 | 396.5216666666667
 | 7 | 3078.28 | 12638.18 | 1805.454285714286
 | 5 | 3088.55 | 8043.41 | 1608.682
 | 11 | 5176.95 | 15935.77 | 1448.706363636364
 | 10 | 1761.76 | 6386.43 | 638.643
 | 1 | -1195 | -1395 | -1395
 | 22 | -1503.009619047617 | 23658.36 | 1075.38
 | 13 | 3516.26 | 16673.44 | 1282.572307692308
 | 19 | 6398.999999999999 | 19935.61 | 1049.242631578947
 | 11 | 1811.19 | 7558.29 | 687.1172727272727
 | 13 | 5412.72 | 23791.42 | 1830.109230769231
 | 14 | 4021.37 | 9657.35 | 689.8107142857143
 | 10 | 2617.29 | 10500.75 | 1050.075
 | 12 | 2429.46 | 9167.03 | 763.9191666666667
 | 12 | 6627.559999999999 | 23176.92 | 1931.41
 | 27 | 10938.38 | 49406.37 | 1829.865555555555
 | 8 | 2299.4 | 7946.950000000001 | 993.3687500000001
 | 18 | 14402.72 | 35944.02999999999 | 1996.890555555555
 | 22 | 14798.23 | 61510.94 | 2795.951818181818
 | 14 | 17076 | 53462.35 | 3818.739285714285
 | 10 | 493.5799999999999 | 199.9500000000007 | 19.99500000000007
 | 3 | 703.11 | 1830.94 | 610.3133333333333
 | 13 | 3672.44 | 19921.35 | 1532.411538461538
 | 12 | 36718.36 | 95487.57 | 7957.297500000001
 | 10 | 3986.76 | 33305.73 | 3330.572999999999
 | 1 | -2119.69 | -8209.6 | -8209.6
 | 1 | -294000 | -323904 | -323904
Spreadsheet: 201347d1355952492-solver-questions-solver_advertising
Sheet: Solver_model

 | Advertisment:
 |  | Cost | Audience | [NAME] usage
 | Television | 2000 | 100000 | 10
 | Radio | 300 | 18000 | 20
 | Newspaper | 600 | 40000 | 10
 | Total budget | 18200
 | 1) Do not allow radio advertisements to exceed 50% of the total usage
 | 2) Make sure television advertisements are at least 10% of the total usage
 |  | Usage | Cost | Auidience | Min usage | [NAME] usage
 | Television | 4
 | Radio | 14
 | Newspaper | 10
 | Total
 | Object func |  | [NAME] audience
Spreadsheet: 84713d1284720751-find-out-the-grand-total-from-different-sheets-on-a-summary-sheet-book1
Sheet: Sheet3

OIL ENGINE 10 W 30 - SJ GRADE | 1100661 | 12
COVER CYLINDER HEAD | 12301-GB6-9000 | 13
COVER R CYLINDER HEAD SIDE | 12331-GB0-9100 | 14
COVER L CYLINDER HEAD SIDE | 12341-GB6-9100 | 15
HOLE CAP TAPPET ADJUSTING | [PHONE] | 16
GASKET CYL HEAD COVER | 12391-GW8-6810 | 17
SPARK PLUG | 98056-57718-01 | 20
NUT CAP 7MM | 90201-GF6-0000 | 21
WASHER SEALING 7 MM | 90442-GF6-0000 | 22
Spreadsheet: 687754d1595392067-index-match-cleaning-data-simplified-workbook
Sheet: Sheet1

 | TABLE 1 |  |  |  | TABLE 2
 | Person | [Columns] | [Values] |  | Person | Country | City | Tables | Chairs
 | [NAME] | Country | Norway
 | [NAME] | City | Oslo
 | [NAME] | Tables | 5
 | [NAME] | Chairs | 20
 | [NAME] | Country | Sweden
 | [NAME] | City | Stockholm
 | [NAME] | Tables | 6
 | [NAME] | Chairs | 16
 | [NAME] | Country | Denmark
 | [NAME] | City | Copenhagen
 | [NAME] | Tables | 4
 | [NAME] | Chairs | 12
 | Emma | Country | Finland |  | TABLE 2: Need help completing the table using formulas ref table 1
 | Emma | City | Helsinki
 | Emma | Tables | 4
 | Emma | Chairs | 20
 | TABLE 1: Simplified and generalized from a large workbook with more than 70k rows
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S
Spreadsheet: 745118d1629763606-open-a-web-site-by-click-an-icon-based-on-validate-list-open-a-web-site-by-click-an-icon-based-on-validate-list
Sheet: Sheet1

Amazon | http://www.amazon.com/
Google Map | https://www.google.com/maps/ |  |  |  |  |  | D6 is a data validation list
Yahoo | https://www.yahoo.com |  |  |  |  |  | A1:B3 is a range list
 |  |  |  |  |  |  | Globe icon has hyperlink to H8
 |  |  | Amazon
 |  |  |  |  |  |  |  | =VLOOKUP(D6,A1:B3,2)
 |  |  |  |  |  |  |  | =HYPERLINK(H6, "Web Site")
 |  | Example:
 |  | 1 | [NAME] from D6.
 |  | 2 | Click globe icon to open Amazon web site.  But thre is a popup error.
 |  |  | I have tried enter the followings links to the globe address field.
 |  |  | H7 | Error
 |  |  | H8 | Error
 |  |  | =VLOOKUP(D6,A1:B3,2) | Error
 |  |  | http://www.amazon.com/ | working
 |  |  | Does address of hyperlink accept any link to a cell or formula?
Spreadsheet: 767733d1644597239-distribute-a-number-from-a-cell-across-others-based-on-the-percentage-of-another-cell-distribute-based-on-individual-percentage-of-available-updated-
Sheet: Fruit Available

FRUIT | TEAM
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
ORANGES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
APPLES | TEAM 1
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 2
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 3
ORANGES | TEAM 4
ORANGES | TEAM 4
ORANGES | TEAM 4
ORANGES | TEAM 4
ORANGES | TEAM 4
ORANGES | TEAM 4
ORANGES | TEAM 4
ORANGES | TEAM 4
ORANGES | TEAM 4
ORANGES | TEAM 4
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 3
APPLES | TEAM 4
APPLES | TEAM 4
APPLES | TEAM 4
APPLES | TEAM 4
APPLES | TEAM 4
APPLES | TEAM 4
APPLES | TEAM 4
APPLES | TEAM 2
APPLES | TEAM 2
Spreadsheet: 217638d1362137923-list-all-items-depending-on-drop-list-value-schedule-2
Sheet: SEARCH

DRAWING NUMBER SEARCH |  |  | if blank, no value entered in cell. ONLY enter data into grey "Drawing Number" cell.
DRAWING NUMBER |  | CUSTOMER | W.O.N | Customer P/O | P/O Date | Description | Quantity Req'd | due date | DRAWING
 |  |  | comments | Date Completed | material rqd | qty rqd | supplier | Insi PO number | JOB CARD
W.O.N SEARCH |  |  | if blank, no value entered in cell. ONLY enter data into grey "W.O.N" cell.
W.O.N |  | CUSTOMER | DRAWING NO | Customer P/O | P/O Date | Description | Quantity Req'd | due date
 |  |  | comments | Date Completed | material rqd | qty rqd | supplier | Insi PO number
COST CALCULATOR |  |  | Enter either mins or hours, not both. ONLY enter data into grey cells.
FELINHELI |  |  | MINS | HOURS | COST | RATE (PER HOUR) | 50 | [NAME]
CIBYN |  |  | MINS | HOURS | COST | RATE (PER HOUR) | 120 | HOURS > MINS
OTHER |  |  | MINS | HOURS | COST | RATE (PER HOUR)
PROGRESS
Spreadsheet: 861443d1709297815-how-to-fill-in-the-corresponding-table-with-the-names-of-each-unit-according-to-their-job-0301
Sheet: Sheet1

Table1 |  |  |  |  |  |  | Table2
Serial Number | unit | Name | position | employee attributes |  |  | unit | staff |  |  |  |  | outsource |  |  |  |  | Self employment
1 | Terminal group | T2 | maintenance | outsource |  |  |  | Number of people | maintenance | assemble | Receiving orders | handle | Number of people | maintenance | assemble | Receiving orders | handle | Number of people | maintenance | assemble | Receiving orders | handle
2 | Terminal group | W1 | maintenance | outsource |  |  | Terminal group |  |  |  |  |  | 3 | T2、W1 | [NAME]
3 | Terminal group | [NAME] | assemble | outsource |  |  | Complaint team | 1 |  |  | T1 |  | 1 |  |  |  | T4
4 | Complaint team | T1 | Receiving orders | staff |  |  | Transport Group |  |  |  |  |  | 2 |  |  | W5 | W4
5 | Complaint team | T4 | handle | outsource |  |  | Support group | 1 |  | T3 |  |  |  |  |  |  |  | 1 |  | W3
6 | Transport Group | W5 | Receiving orders | outsource
7 | Transport Group | W4 | handle | outsource
8 | Support group | T3 | assemble | staff
9 | Support group | W3 | assemble | Self employment
 |  | 3/4” |  |  | 7/8”
Spreadsheet: 376445d1423599892-project-time-log-dummy-template-ndmv3
Sheet: Janvier

[NAME] |  | [NAME]
Poste : |  | [NAME] scientifique
 |  |  |  |  | Date: | 2015-11-01 00:00:00 | 2015-11-02 00:00:00 | 2015-11-03 00:00:00 | 2015-11-04 00:00:00 | 2015-11-05 00:00:00 | 2015-11-06 00:00:00 | 2015-11-07 00:00:00 | 2015-11-08 00:00:00 | 2015-11-09 00:00:00 | 2015-11-10 00:00:00 | 2015-11-11 00:00:00 | 2015-11-12 00:00:00 | 2015-11-13 00:00:00 | 2015-11-14 00:00:00 | 2015-11-15 00:00:00 | 2015-11-16 00:00:00 | 2015-11-17 00:00:00 | 2015-11-18 00:00:00 | 2015-11-19 00:00:00 | 2015-11-20 00:00:00 | 2015-11-21 00:00:00 | 2015-11-22 00:00:00 | 2015-11-23 00:00:00 | 2015-11-24 00:00:00 | 2015-11-25 00:00:00 | 2015-11-26 00:00:00 | 2015-11-27 00:00:00 | 2015-11-28 00:00:00 | 2015-11-29 00:00:00 | 2015-11-30 00:00:00 | 2015-01-31 00:00:00
Projet 1: | Project 1 |  |  | Temps du projet
Task 1
Task 2 |  |  |  |  |  |  |  |  |  |  |  |  | 3
task 3 |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  | 1
Task 4 |  |  |  |  |  |  |  |  |  |  |  |  | 2
Task 5 |  |  |  |  |  |  |  |  |  |  |  |  | 1
Projet 2: | Project 2 |  |  | Temps du projet
Task 1
Task 2 |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 2 |  |  |  |  |  | 2 |  |  |  |  | 2
Task 8
[NAME] des heures
# de projet | Projet | Heures
Spreadsheet: 436cf8da-cad4-407d-a46a-ce9355f9ab29
Sheet: LTM Non-GAAP EPS

Avis Budget Group, Inc.
Reconciliation of net income, excluding certain items to net income
($ millions, except EPS)
 | Trailing twelve months ending Sept. 30, 2011
Earnings per share, excluding certain items (diluted)
Shares used to calculate Earnings per share, excluding certain items (diluted) | 128.288497663929
Net income, excluding certain items used to calculate Earnings per share, excluding certain items (diluted)
Less: Convertible debt interest, net of tax | 7.37501632191781
Net income, excluding certain items
Less certain items, net of tax:
Early extinguishment of debt | 8
Transaction-related expenses | 69
Acquisition-related interest | 18
Restructuring charges | 2
Net income | 117
Spreadsheet: 179149-payback-function-formula-with-a-growth-rate-payback_growth-rate
Sheet: Sheet1

 |  |  |  |  |  | Annual Income | Cumulative Annual Income
 |  | Market [NAME]: | 17500000 |  | Year 1 | 2576000 | 2576000
 |  | TTM Earnings: | 2300000 |  | Year 2 | 2885120 | 5461120
 |  | Growth Rate: | 0.12 |  | Year 3 | 3231334.4 | 8692454.4
 |  |  |  |  | Year 4 | 3619094.528 | 12311548.928
 |  |  |  |  | Year 5 | 4053385.87136 | 16364934.79936
 |  |  |  |  | Year 6 | 4539792.175923199 | 20904726.9752832 |  | Roughly 5.25 years to payback purchase price
 |  |  |  |  | Year 7 | 5084567.237033984 | 25989294.21231718
 |  | NPER Function | 21.55100475005931 |  | Year 8 | 5694715.305478062 | 31684009.51779525
 |  |  |  |  | Year 9 | 6378081.142135429 | 38062090.65993068
 |  |  |  |  | Year 10 | 7143450.879191681 | 45205541.53912236
Spreadsheet: 778637d1651188190-highlight-empty-cell-based-on-data-from-another-column-sample-data
Sheet: Sheet1

Type | Condition | Size | Amt
A | New | 1 | 5
B | Old |  | 10
C |  |  |  |  | Cell in yellow is what I want to achieve
D | New |  | 6
C | Old |  | 5
C |  | 1
A | New | 1
Spreadsheet: 108791d1305760721-search-a-value-from-two-columns-find-the-corresponding-value-in-third-column-code-excel
Sheet: Sheet1

101 | 99 | 65 |  |  |  | 1000
102 | 35 | 1000
103 | 48 | 86
104 | 25 | 45
105 | 96 | 32
101 | 1000 | 1000 |  |  |  | 1000
102 | 1000 | 1000
103 | 1000 | 1000
104 | 1000 | 1000
105 | 1000 | 1000
101 | 1000 | 1000 |  |  |  | 1000
102 | 850 | 223
103 | 132 | 145
104 | 1212 | 1212
105 | 1555 | 1000
Spreadsheet: 06ffbcc2-f9e6-442a-b886-bee360f85852
Sheet: External Interface

Monthly Reconfiguration Auction Result Report
SP_MRARESULT_<customer id>_<obligation month begin>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
External Interface Information |  |  |  | External Interface RA Result
External Interface Name | Capacity Zone ID | Capacity Zone Name | External Control Area | Commitment Period | Auction Name | Total Supply Offers Submitted | Total Demand Bids Submitted | Total Supply Offers Cleared | Total Demand Bids Cleared | Net Capacity Cleared | Clearing Price
String | Number | String | String | String | String | MW | MW | MW | MW | MW | $/kW-Month
Spreadsheet: 75757d1276285086-using-count-function-with-dates-grouped-into-months-book2
Sheet: Sheet1

incident | date 1 | Dollars
1 | 2010-04-03 00:00:00 | 100
1
1 | 2010-03-03 00:00:00 | 200
2 | 2010-03-01 00:00:00 | 800
2 | 2010-01-01 00:00:00 | 500 |  |  | Jan | Feb | Mar | Apr | May
2 | 2010-05-03 00:00:00 | 50 |  | incident
2 | 2010-02-02 00:00:00 | 750 |  | 1
2 |  |  |  | 2
3 | 2010-04-03 00:00:00 | 400 |  | 3
3 |  |  |  | 4
3 | 2010-01-25 00:00:00 | 30 |  | 5
3
4 | 2010-04-30 00:00:00 | 500
4 | 2010-01-01 00:00:00 | 300
5 | 2010-05-24 00:00:00 | 470
Spreadsheet: 192665d1352485160-using-fill-series-with-data-from-other-spreadsheets-john-doe
Sheet: Sheet1

[NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
Week Number | Date | Amount Paid |  |  | Weekly Fee | Current Balance |  | Week Number | Date | Amount Paid |  |  | Weekly Fee | Current Balance | Week Number | Date | Amount Paid |  |  | Weekly Fee | Current Balance
1 |  |  |  |  |  |  |  | 43 |  |  |  |  |  |  | 85
2 |  |  |  |  |  |  |  | 44 |  |  |  |  |  |  | 86
3 |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 87
4 |  |  |  |  |  |  |  | 46 |  |  |  |  |  |  | 88
5 |  |  |  |  |  |  |  | 47 |  |  |  |  |  |  | 89
6 |  |  |  |  |  |  |  | 48 |  |  |  |  |  |  | 90
7 |  |  |  |  |  |  |  | 49 |  |  |  |  |  |  | 91
8 |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  | 92
9 |  |  |  |  |  |  |  | 51 |  |  |  |  |  |  | 93
10 |  |  |  |  |  |  |  | 52 |  |  |  |  |  |  | 94
11 |  |  |  |  |  |  |  | 53 |  |  |  |  |  |  | 95
12 |  |  |  |  |  |  |  | 54 |  |  |  |  |  |  | 96
13 |  |  |  |  |  |  |  | 55 |  |  |  |  |  |  | 97
14 |  |  |  |  |  |  |  | 56 |  |  |  |  |  |  | 98
15 |  |  |  |  |  |  |  | 57 |  |  |  |  |  |  | 99
16 |  |  |  |  |  |  |  | 58 |  |  |  |  |  |  | 100
17 |  |  |  |  |  |  |  | 59 |  |  |  |  |  |  | 101
18 |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  | 102
19 |  |  |  |  |  |  |  | 61 |  |  |  |  |  |  | 103
20 |  |  |  |  |  |  |  | 62 |  |  |  |  |  |  | 104
21 |  |  |  |  |  |  |  | 63 |  |  |  |  |  |  | 105
22 |  |  |  |  |  |  |  | 64 |  |  |  |  |  |  | 106
23 |  |  |  |  |  |  |  | 65 |  |  |  |  |  |  | 107
24 |  |  |  |  |  |  |  | 66 |  |  |  |  |  |  | 108
25 |  |  |  |  |  |  |  | 67 |  |  |  |  |  |  | 109
26 |  |  |  |  |  |  |  | 68 |  |  |  |  |  |  | 110
27 |  |  |  |  |  |  |  | 69 |  |  |  |  |  |  | 111
28 |  |  |  |  |  |  |  | 70 |  |  |  |  |  |  | 112
29 |  |  |  |  |  |  |  | 71 |  |  |  |  |  |  | 113
30 |  |  |  |  |  |  |  | 72 |  |  |  |  |  |  | 114
31 |  |  |  |  |  |  |  | 73 |  |  |  |  |  |  | 115
32 |  |  |  |  |  |  |  | 74 |  |  |  |  |  |  | 116
33 |  |  |  |  |  |  |  | 75 |  |  |  |  |  |  | 117
34 |  |  |  |  |  |  |  | 76 |  |  |  |  |  |  | 118
35 |  |  |  |  |  |  |  | 77 |  |  |  |  |  |  | 119
36 |  |  |  |  |  |  |  | 78 |  |  |  |  |  |  | 120
37 |  |  |  |  |  |  |  | 79 |  |  |  |  |  |  | 121
38 |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  | 122
39 |  |  |  |  |  |  |  | 81 |  |  |  |  |  |  | 123
40 |  |  |  |  |  |  |  | 82 |  |  |  |  |  |  | 124
41 |  |  |  |  |  |  |  | 83 |  |  |  |  |  |  | 125
42 |  |  |  |  |  |  |  | 84 |  |  |  |  |  |  | 126
Spreadsheet: 210256d1359409370-ytd-calculation-with-partial-amount-example-brotherwo-oeldere-
Sheet: mine

 |  | Jul 2012 | Aug 2012 | Sep 2012 | Oct 2012 | Nov 2012 | Dec 2012 | Jan 2013 | Feb 2013 | Mar 2013 | Apr 2013 | May 2013 | Jun 2013
 | 2013 | Period 1, 2013 | Period 2, 2013 | Period 3, 2013 | Period 4, 2013 | Period 5, 2013 | Period 6, 2013 | Period 7, 2013 | Period 8, 2013 | Period 9, 2013 | Period 10, 2013 | Period 11, 2013 | Period 12, 2013 |  |  | FICA MAX Contribution
Taxable Gross | 308000 | 24901.18577075099 | 27272.72727272727 | 22529.6442687747 | 27272.72727272727 | 23715.41501976285 | 23715.41501976285 | 26086.95652173913 | 23715.41501976285 | 24901.18577075099 | 26086.95652173913 | 26086.95652173913 | 31715.41501976285 |  |  | FICA MAX | 110100
FICA if unlimited |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FICA % | 0.062
FICA - CALYTD if unlimited
FICA Calculation
Taxable Gross YTD (calendar)
Flag
 |  |  |  |  |  |  |  |  |  |  |  | if fica Cal YTD < [NAME] contribution
 |  |  |  |  |  |  |  |  |  |  |  |  | Taxable gross * FICA %
Spreadsheet: 715730d1611845102-help-reducing-the-amount-of-formulas-to-show-the-sum-attendance-sample-for-excel-help
Sheet: Annual Employee Report

Change the employee | à | Employee
 |  | Jones, [NAME]
Enter the rolling start date | à | Start Date
 |  | 2021-01-01 00:00:00
 |  | End Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee Start Date |  |  |  | End Date
 |  |  |  | See Data Table More than 1 Time Entry |  |  |  |  | Holiday |  |  |  | Weekends |  |  |  |  | NA / Not Employed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEARLY SUMMARY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | 1900-01-01 00:00:00 | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 | 1900-01-09 00:00:00 | 1900-01-10 00:00:00 | 1900-01-11 00:00:00 | 1900-01-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 1900-01-15 00:00:00 | 1900-01-16 00:00:00 | 1900-01-17 00:00:00 | 1900-01-18 00:00:00 | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00 | 1900-01-24 00:00:00 | 1900-01-25 00:00:00 | 1900-01-26 00:00:00 | 1900-01-27 00:00:00 | 1900-01-28 00:00:00 | 1900-01-29 00:00:00 | 1900-01-30 00:00:00 | 1900-01-31 00:00:00 |  | 1> |  |  |  |  |  |  |  | Total Negative | Work Days
 |  |  |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Negative |  |  | Work Days
Spreadsheet: 2f55f4a3-d3b1-432f-8d68-b15bd77cbd0e
Sheet: Base Growth Rates

 | Base Growth Rates - Tax Categories
 | FY14 | FY15 | FY16 | FY17 | FY18
Individual | 0.04476892305355748 | 0.04918195311302152 | 0.05152437752223369 | 0.04893594090320341 | 0.04686728821654732
Sales | 0.03946274593456238 | 0.04824133737969114 | 0.04639821633192118 | 0.04374951368552231 | 0.03968053165696622
Corporate | 0.02430909651664421 | 0.003464151708751737 | -0.007727693018119722 | -0.007533359974375809 | 0.002907577607767779
Franchise | 0.02412978627763485 | 0.02709177590469506 | 0.02757839415332461 | 0.02574789265309449 | 0.02393097876405749
Insurance | 0.05797311618048974 | 0.05820206237742773 | 0.05847664786805093 | 0.05873059453862261 | 0.0586927753960693
Alcohol | 0.01879672903305668 | 0.0184495884749016 | 0.01811536740127658 | 0.01779270991302003 | 0.01748231226715886
Estate | 0.724878321165543 | 0.29635158512644 | 0.06971727773443963 | 0.07073128960438446 | 0.0607908695024043
Priv Lic | 0.03553902950381334 | 0.03435236296282707 | 0.03449865430781066 | 0.03408514430657431 | 0.03455934023680408
Tob | -0.012 | -0.012 | -0.012 | -0.012 | -0.012
[NAME] | 0.01 | -0.05 | -0.03 | 0 | 0
Piped Gas | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0
Other | 0 | 0 | 0 | 0 | 0
 | Base Growth Rates - Nontax Categories
Inv Income | 0.35 | 0.75 | 0.5 | 0.2 | 0.05
Jud Fees | 0 | 0 | 0 | 0 | 0
DISH | 0 | 0 | 0 | 0 | 0
Other |  | 0.03 | 0.03 | 0.03 | 0.03
Insurance | 0.015 | 0.01 | 0 | 0 | 0
Spreadsheet: 1b51309f-b686-4fb3-92a1-bb2c3cf89f3e
Sheet: Bid Items

Attachment A: Itemized Cost Proposal
Enter fixed bid information in the yellow cells below and submit in native .xls format.
 |  | Vendor Name: |  | Date Bid Received:
Product | Brand | Product Number | Description | Quantity | Bid Price EA | Bid Price Ext
 |  |  |  |  | Equipment Subtotal
Support |  |  | Support Detail/Comments |  |  | Bid Price
On-Site systems Installation
Conferencing Support On-Site Labor Only Service, 3 Year
Conferencing Support Remote, 3 Year
Other (not listed above)
 |  |  |  |  | Support Subtotal
 |  |  |  |  | Sales Tax | TBD
 |  |  |  |  | GRAND TOTAL
Spreadsheet: 870559d1717059449-custom-sort-custom-aligw
Sheet: Required

 |  |  |  | OR
 | Guava | 97 |  | Guava | 97 |  |  | 97 |  |  | 97
 | Guava | 635 |  | Guava | 635 |  | Guava | 635 |  | Guava | 635
 | Guava Total |  |  | Mango | 86 |  | Guava Total | 732 |  | Mango | 86
 | Mango | 86 |  | Mango | 125 |  | Mango | 86 |  | Mango | 125
 | Mango | 125 |  | [NAME] | 36 |  | Mango | 125 |  | [NAME] | 36
 | Mango Total |  |  | [NAME] | 98 |  | Mango Total | 211 |  | [NAME] | 98
 | [NAME] | 36 |  | Apple | 526 |  | [NAME] | 36 |  | Apple | 526
 | [NAME] | 98 |  | Apple | 77 |  | [NAME] | 98 |  | Apple | 77
 | Banana Total |  |  | Orange | 36 |  | Banana Total | 134 |  | Orange | 36
 | Apple | 526 |  |  |  |  | Apple | 526
 | Apple | 77 |  |  |  |  | Apple | 77
 | Apple Total |  |  |  |  |  | Apple Total | 603
 | Orange | 36 |  |  |  |  | Orange | 36
 | Orange Total |  |  |  |  |  | Orange Total | 36