tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 99913d1298451204-calculate-holiday-accrued-at-current-month-monthly-accrual
Sheet: Monthly balance

 | Yearly Allowance | Name | Surname | Accrual as of Today | Monthly allowance/ accrual |  |  |  |  |  |  |  |  |  |  |  |  | TODAY
 |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | 2011-02-23 00:00:00
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 25 | [NAME] | Cricket | 4.166666666666667 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 682963d1592409012-calculate-completion-date-network-production-dates
Sheet: Sheet1

Start Date | DUE DATE | Production Days | Complettion Date |  |  |  |  | Stat Holiday
2020-06-15 00:00:00 | 2020-06-30 00:00:00 | 13.02083333333333 |  |  |  |  |  | 2020-01-01 00:00:00
2020-06-15 00:00:00 | 2020-06-30 00:00:00 | 6.25
2020-06-15 00:00:00 | 2020-06-30 00:00:00 | 52.08333333333334
2020-06-15 00:00:00 | 2020-07-15 00:00:00 | 14.88095238095238
2020-06-15 00:00:00 | 2020-07-15 00:00:00 | 6.25
2020-06-15 00:00:00 | 2020-07-15 00:00:00 | 10.41666666666667
2020-06-15 00:00:00 | 2020-07-15 00:00:00 | 14.88095238095238
2020-06-15 00:00:00 | 2020-07-15 00:00:00 | 13.02083333333333
2020-07-01 00:00:00 | 2020-07-30 00:00:00 | 1.5625
2020-07-01 00:00:00 | 2020-07-30 00:00:00 | 0.8680555555555556
2020-07-01 00:00:00 | 2020-07-30 00:00:00 | 0.496031746031746
Spreadsheet: 859758d1708010864-formula-on-color-coding-color-coding-v2
Sheet: Binary Digit

 |  |  |  |  |  |  |  |  |  |  |  |  | RED | ORANGE | YELLOW | GREEN | BLUE | INDIGO | VIOLET
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 0 | 1 | 0 | 1
65
66
67 |  |  |  |  |  |  |  |  |  | CODE "1" | CODE "0"
68 |  |  |  |  |  |  |  |  |  | RED | ORANGE
69 |  |  |  |  |  |  |  |  |  | YELLOW | GREEN
70 |  |  |  |  |  |  |  |  |  | BLUE | INDIGO
71 |  |  |  |  |  |  |  |  |  | VIOLET
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
Spreadsheet: 102896d1300805281-eliminating-double-numbers-workbook13
Sheet: Sheet1

 | DOUBLE
037 | 037
001
029 | 029
038 | 038
047 | 047
056 | 056
002
039 | 039
057 | 057
066
003
012 | 012
049 | 049
058 | 058
067 | 067
022
059 | 059
068 | 068
077
005
069 | 069
078 | 078
015 | 015
024 | 024
033
079 | 079
007
016 | 016
Spreadsheet: 377111d1423798878-find-value-that-doesnt-match-and-bring-back-column-heading-updated-file-ndmv2
Sheet: Year 2

PersID | PosCode | Org1 | Org2 | Org3
1001 | 21 | 8 | A1 | SS1 |  |  |  | Drag these formula in columns F, G, H down as far as needed
1002 | 21 | 9 | A2 | AQ1
1003 | 22 | 11 | B3 | D34
1004 | 23 | 12 | B2 | DW4
1005 | 23 | 22 | C1 | SS2
Spreadsheet: 139197d1328123971-complicated-countif-function-010
Sheet: Sheet1

 | Date | Text
12 | 2012-12-01 00:00:00 | A | 1
10 | 2012-10-26 15:13:16 | B | 1
8 | 2012-08-26 11:28:54 | B | 1
6 | 2012-06-24 02:50:55 | C | 1
3 | 2012-03-22 12:32:12 | D | 1
3 | 2012-03-22 11:45:34 | C | 1
1 | 2012-01-17 22:12:50 | B | 1
1 | 2012-01-17 14:10:53 | C | 1
 |  | 2012
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 | A
 | B
 | C
 | D
Spreadsheet: 599228d1542911915-conditional-formatting-and-counting-example
Sheet: Sheet1

ID | Department | Commune
AB1234C | North | [NAME]
CD1234E | North | [NAME]
EF1234G | South | Rogers
HI1234J | East | [NAME]
KL1234M | West | [NAME]
KL1234M | West | Johannsson
AB1234C | North | [NAME]
Spreadsheet: 825349d1681266242-cell-formatting-to-display-a-certain-text-or-number-try-out-report
Sheet: STAND BY REGULAR

D A I L Y   L A B O R   R E P O R T
DISTRICT: |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE:
FOREMAN: |  | [NAME], [NAME] |  |  |  | R/M HIGHWAY |  | X |  |  | OTHER |  |  |  |  | APPROVED:
 |  |  |  |  |  |  |  |  |  |  | W.O. #
L A B O R |  |  |  |  |  |  |  |  |  |  | E Q U I P M E N T (County & Rental)
HC NO | PAY | NAME |  |  | AREA | JOB | HOURS | HRLY | AMOUNT |  | CH NO. | HOURS | HRLY | EQUIP | REMARKS
 | CODE |  |  |  | CODE | CODE |  | RATE |  |  |  |  | RATE | COST
M A T E R I A L S  &  S U P P L I E S |  |  |  |  |  |  |  |  |  |  | J O B  C O S T  SUMMARY
QTY | ITEMS |  |  |  |  | AREA                  CODE | JOB          CODE | UNIT | AMOUNT |  | AREA | JOB | HRS |  |  | M/S | C/S | TOTAL
 |  |  |  |  |  |  |  | COST |  |  | CODE | CODE |  | LABOR | EQUIP
 |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL
Spreadsheet: 852345d1702406636-help-with-filtering-sample-workbook
Sheet: Sheet1

End_Latitude | End_Longitude | Confidence | IMSI | IMEI | Model | Make | Service_Type | Start_DateTime | Duration | Start_Cell | Start_eNodeB | Start_TAC_LAC | Start_Sector | End_Cell | End_eNodeB | End_Sector | Start_Timing_Advance_Miles | End_Timing_Advance_Miles | Start_Timing_Advance_Cell | End_Timing_Advance_Cell | Device_Technology | Market
 |  | High | Account 1 | IMEI 1 | IPHONE 11 | APPLE | Data Only | 2023-11-15 02:00:00 | 11 | 310260122096261 | 476938 | 20455 | 133 | 310260122096261 | 476938 | 133 | 0.29 | 0.29 | 310260122096261 | 310260122096261 | LTE | WASHINGTON DC
 |  | Low | Account 2 | IMEI 2 | MILAN 5G BOOST | MILAN 5G BOOST | Data Only | 2023-11-15 02:00:00 | 20 | 31026005500207406 | 1342824 | 5236480 | 46 | 31026005500207406 | 1342824 | 46 | 0.46 | 0.49 | 31026005500207406 | 31026005500207406 | 5G | WASHINGTON DC
 |  | Low | Account 3 | IMEI 3 | TAC: 01475700 |  | Data Only | 2023-11-15 02:00:00 | 11 | 310260011568898 | 45191 | 20455 | 2 | 310260011568898 | 45191 | 2 | 0.39 | 0.39 | 310260011568898 | 310260011568898 | LTE | WASHINGTON DC
 |  | High | Account 4 | IMEI4 | 30 XE 5G | ALCATEL/TCL | Data Only | 2023-11-15 02:00:01 | 10 | 310260013698154 | 53508 | 20455 | 106 | 310260013698154 | 53508 | 106 | 0.05 | 0.19 | 310260013698154 | 310260013698154 | 5G | WASHINGTON DC
Spreadsheet: 173315d1344513958-sum-if-trial
Sheet: Sheet1

 |  |  | Helper Columns |  |  |  | Budget |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | JAN |  |  | Fruits
 |  |  | You can hide these |  |  |  | Apple | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | FEB |  |  | Apple
 |  |  |  |  |  |  | Orange | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | MARTC |  |  | Orange
DATE | Commodity | PRIZE |  |  |  |  | Grapes | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | APR |  |  | Grapes
2012-06-01 00:00:00 | Apple | 2 | 6 | JUN |  | Annual Epenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | MAY |  |  | Total Expenses
2012-06-03 00:00:00 | Orange | 2 | 6 | JUN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | JUN |  |  | [NAME]
2012-07-08 00:00:00 | Grapes | 2 | 7 | JUL |  | Month | Commodity | Expenses | Above Budget | Below Budget |  |  |  |  |  |  |  |  |  |  |  | 7 | JUL |  |  | Kiwi
2012-07-10 00:00:00 | Water Melon | 5 | 7 | JUL | 6 | JUN | Grapes | 0 |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 8 | AUG |  |  | Total expenses
2012-07-16 00:00:00 | [NAME] | 5 | 7 | JUL | 7 | JUL | Orange | 5.3 |  | 4.7 |  |  |  |  |  |  |  |  |  |  |  | 9 | SEPT
2012-07-16 00:00:00 | Kiwi | 20 | 7 | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | OKT
2012-07-17 00:00:00 | Apple | 8 | 7 | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | NOV
2012-07-17 00:00:00 | Orange | 0.3 | 7 | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | DEC
2012-07-17 00:00:00 | Apple | 3 | 7 | JUL
2012-07-17 00:00:00 | Orange | 5 | 7 | JUL
2012-07-17 00:00:00 | Grapes | 2 | 7 | JUL
2012-07-17 00:00:00 | Water Melon | 2 | 7 | JUL
2012-07-21 00:00:00 | [NAME] | 4.8 | 7 | JUL
2012-07-21 00:00:00 | Kiwi | 4.8 | 7 | JUL
2012-07-22 00:00:00 | Apple | 10 | 7 | JUL |  |  |  | 2 |  | 8
2012-07-22 00:00:00 | Orange.in | 1 |  |  |  |  | 0 | 21 | 11
2012-07-22 00:00:00 | Orange.uk | 2
2012-07-22 00:00:00 | Orange.bl | 3
Spreadsheet: 124093d1318085926-how-to-improve-a-budget-worksheet-book2
Sheet: Sheet1

Date | Transaction | Cash or VISA | Payment | Deposit | Balance | Bank Balance | Gas | [NAME]. | Food +   Misc. | Hydro | Bell | House   Taxes | Insuranc. H & A | Auto  Repairs | Koko | Health & Dental | Dressing | Renov. & Decor. | Projects | [NAME].
 | TOTALS : |  | -685.1699999999998 | 295.25 |  |  | 45.91 | 120 | 28.84 | 229 | 96.09 | 25.84 | 45.81 | 15.59 | 16 | 0 | 0 | 27.65 | 223.82 | 6.69
Jan-01-11 | Balance |  |  |  | 400
 |  |  |  |  | 400
Jan-01-11 | Deposit |  |  | 200 | 600
Jan-03-11 | Project VISA for new CNC | -7.92 |  |  | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.92
Jan-04-11 | Project CASH IBM Laptop |  | -80 |  | 520 | 520 |  |  |  |  |  |  |  |  |  |  |  |  | 80
Jan-04-11 | Project Probotix |  | -37 |  | 483 |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
Jan-04-11 | [NAME] |  | -63 |  | 420 |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
Jan-04-11 | Tax City |  | -25.84 |  | 394.16 |  |  |  |  |  |  | 25.84
Jan-04-11 | Groceries CASH | -4.27 |  |  | 394.16 |  |  |  | 4.27
Jan-04-11 | Project Hardware VISA | -26.82 |  |  | 394.16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26.82
Jan-05-11 | Deposit |  |  | 95.25 | 489.41 | 489.41
Jan-06-11 | Gas |  | -45.91 |  | 443.5 |  | 45.91
Jan-06-11 | [NAME] |  | -6.69 |  | 436.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.69
Jan-07-11 | Bell |  | -96.09 |  | 340.72 | 340.72 |  |  |  |  | 96.09
Jan-09-11 | Groceries |  | -12.59 |  | 328.1300000000001 |  |  |  | 12.59
Jan-11-11 | Hydro |  | -200 |  | 128.1300000000001 | 129.13 |  |  |  | 200
Jan-11-11 | Insurance Home |  | -45.81 |  | 82.32000000000005 |  |  |  |  |  |  |  | 45.81
Jan-11-11 | Auto Repairs |  | -15.59 |  | 66.73000000000005 |  |  |  |  |  |  |  |  | 15.59
Jan-11-11 | Cigarettes CASH for 6 Cartons | -120 |  |  | 66.73000000000005 |  |  | 120
Jan-12-11 | [NAME] for Haircut | -16 |  |  | 66.73000000000005 |  |  |  |  |  |  |  |  |  | 16
Jan-12-11 | Groceries CASH | -7 |  |  | 66.73000000000005 |  |  |  | 7
Jan-12-11 | Hydro |  | -29 |  | 37.73000000000005 | 37.73 |  |  |  | 29
Jan-14-11 | Reno Plumbing |  | -27.65 |  | 10.08000000000005 |  |  |  |  |  |  |  |  |  |  |  |  | 27.65
Jan-14-11 | Groceries CASH | -4.98 |  |  | 10.08000000000005 |  |  |  | 4.98
Jan-14-11 | Project CASH Acces Electronique, | -9.08 |  |  | 10.08000000000005 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.08
Spreadsheet: 120668d1315435196-calculating-total-overtime-hours-worked-per-employee-overtime-1-
Sheet: Sheet1

Employee Number | Last Name | First Name | Contract Hours | Hed Code | Hours |  | Employee Number
1111111 | Smith | [NAME] | 37 | 012 | 12 |  | 1111111
2222222 | Jones | [NAME] | 15 | 013 | 15 |  | 2222222
1111111 | Smith | [NAME] | 37 | 003 | 10 |  | 3333333
1111111 | Smith | [NAME] | 37 | 015 | 5 |  | 4444444
3333333 | Maloney | [NAME] | 20 | 003 | 8 |  | 9999999
4444444 | [NAME] | [NAME] | 35 | 012 | 45 |  | 7777777
9999999 | [NAME] | [NAME] | 24.5 | 012 | 20
7777777 | [NAME] | [NAME] | 30 | 003 | 11.5
4444444 | [NAME] | [NAME] | 20 | 015 | 50
2222222 | Jones | [NAME] | 15 | 012 | 18
Spreadsheet: 691075d1597434853-at-wits-end-help-with-nested-if-statements-if-statement-help-try-1
Sheet: Call Log

First Name | Last Name | Phone | [NAME] | Overdue |  |  | # times called | Contact 1 Date | Contact 1 method | Contact 1 Topic | Responded | Contact 2 Date | Contact 2 method | Contact 2 Topic | Responded | Contact 3 Date | Contact 3 method | Contact 3 Topic | Responded | Contact 4 Date | Contact 4 method | Contact 4 Topic | Responded | Contact 5 Date | Contact 5 method | Contact 5 Topic | Responded | Contact 6 Date | Contact 6 method | Contact 6 Topic | Responded | Contact 7 Date | Contact 7 method | Contact 7 Topic | Responded | Notes
 |  |  |  |  | I tried to make it work |  | 1 | 2020-06-01 00:00:00 |  |  |  | 2020-08-12 00:00:00 |  |  |  | 2020-08-12 00:00:00 |  |  |  | 2020-08-12 00:00:00 |  |  |  | 2020-08-12 00:00:00 |  |  |  | 2020-08-12 00:00:00 |  |  |  | 2020-08-12 00:00:00
 |  |  |  |  | I only added AND statement |  | 1 | 2020-06-01 00:00:00
Spreadsheet: 246652d1372474286-excel-mass-inventory-update-problem-tablewithquantities-that-need-to-be-merged
Sheet: Sheet1

Item Name | Item Description | Regular Price | UPC | Tax Code | Order Cost | Item Type | Department Name | [NAME] | Qty 1
[NAME].Coffe Subst.10 | [NAME] | 9.702 | [PHONE] | NT | 6.93 | Inventory | Supplements | System | 5
Digest Biliv Tonic Tea 20tb | [NAME] | 8.246 | [PHONE] | HST | 5.89 | Inventory | Supplements | System | 2
Stress Vit. B Comp. 60tb | Natures Harmony | 8.288 | [PHONE] | HST | 5.92 | Inventory | Supplements | System | 0
Clove 15ml | Aromaforce | 8.638 | [PHONE] | HST | 6.17 | Inventory | Supplements | System | 5
Milk Thistle 50ml | [NAME] | 15.946 | [PHONE] | HST | 11.39 | Inventory | Supplements | System | 0
Herbamare 500g | [NAME] | 12.026 | [PHONE] | NT | 8.59 | Inventory | Supplements | System | 3
Spreadsheet: 780958d1652890108-look-up-a-match-between-workbooks-and-return-information-equipment-sheet
Sheet: Equipment

PWC | OWCID | EquipID | Nomenclature | TYPE | ORG Code | Personnel
AGSE | A135 | G8800 | DOLLY | AGE
AGSE | ARMS | GAC04 | A/M 32C-10C AIR CONDITIONER | AGE | 363 | Smith/Jones
AGSE | ARMS | GAC05 | A/M 32C-10C AIR CONDITIONER | AGE | 363 | Smith Jones
AGSE | AV16 | GAC08 | A/M 32C-10C AIR CONDITIONER | AGE
AGSE | AV16 | GAC09 | A/M 32C-10C AIR CONDITIONER | AGE
AGSE | AF16 | GAC10 | A/M 32C-10C AIR CONDITIONER | AGE
AGSE | AF15 | GAC11 | A/M 32C-10C AIR CONDITIONER | AGE
AGSE | AV15 | GAC13 | A/M 32C-10C AIR CONDITIONER | AGE
Spreadsheet: 274302d1383069647-or-function-template-test2
Sheet: Sheet2

EU |  |  |  | US |  |  |  | UK |  |  |  | AUS |  |  |  | CN/JP/KR |  |  |  | RU/IL |  |  |  | CA |  |  |  |  | Prices
Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop | Phase In | Phase Out | ROO | web shop |  | EUR | USA | GBP | AUD | KRW | [NAME] | CNY | RUB | NZ | CAN
x
 |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Spreadsheet: 858859d1707375722-addition-of-points-that-meet-certain-conditions-x-country-results-sheet-2
Sheet: Points

 |  | PARTICIPATION POINTS
 |  | Give 1 point for each competitor
 |  | Tibro | Coochin | Coonowrin
Preps |  | 2 | 4 | 4
Yr 1 |  | 3 | 3 | 3 |  |  |  | Tibro | Coochin | Coonowrin
Yr 2 |  | 4 | 2 | 4 |  |  | TOTAL
Yr 3 |  | 3 | 1 | 5
Yr 4 |  | 2 | 3 | 4
Yr 5 |  | 3 | 3 | 4
Yr 6 |  | 4 | 1 | 5
 | Total
 |  |  |  |  |  |  |  | CHAMPIONS | RUNNER UP
 |  | Tibro | Coochin | Coonowrin
BOYS |  | 12 | 13 | 32
GIRLS |  | 12 | 11 | 21
Spreadsheet: 275320d1383446623-ranking-up-to-15-numbers-in-column-d-ranking-skips-7-with-a-tie-at-6-and-2-book3
Sheet: Sheet1

78 | 73
62 | 70
79 | 76
66 | 76
78 | 71
83 | 76
61 | 76
68 | 76
74 | 74
81 | 92
Spreadsheet: 0734cd61-cf66-45f2-b852-ce1fd26e8e8c
Sheet: High Level Summary

High Level Summary Document
 | Insurance Company:
 | Market:
 |  |  | Total
 | Total Number of Plans
 | Number of Plans by Exchange Intentions
 | On Exchange
 | Both On and Off Exchange
 | Off Exchange
 | Total (should equal Total Number of Plans above)
 | Number of Plans By Metal Level
 | Catastrophic
 | [NAME] (60% AV)
 | Silver (70% AV)
 | Gold (80% AV)
 | Platinum (90% AV)
 | Total (should equal Total Number of Plans above)
 | Number of Plans by Plan Type
 | PPO
 | HMO
 | POS
 | EPO
 | Total (should equal Total Number of Plans above)
 | Number of Plans by Service Area
 | Statewide
 | Not Statewide*
 | Total (should equal Total Number of Plans above)
 | *If not all Statewide - Number of Counties
 | [NAME] of Counties in Service Area
 | Total Number of Counties Served
 | Insurer Notes:
 | General Notes:
▪ | [NAME] number of counties in a Service Area - for example, if all Service Areas have 5 counties, enter 5.  If one has 8 counties and others have 5, enter 8
▪ | Add up number of counties served across all Service Areas and enter here (for example 5 Service Areas with 5 counties each that don't overlap = 25)
 | Submit in Excel format in SERFF filing under Supporting Documents.
Spreadsheet: 727738d1618065787-getting-the-sum-of-values-after-removing-text-test
Sheet: Sheet1

 |  |  | find value *
 |  | 50
 |  | 100 *
 |  | 50
 |  | 50
 |  | .
 |  | 100
 |  | 100 *
 | total
 | total *
Spreadsheet: 021b0e50-4331-43dd-87d3-be360bf8ba3e
Sheet: Example Worksheet Qtrly Pay 

GCC Pay for Spring 2011
Month | Monthly Amt. | Weekly Flat Rate | Hourly rate | Work Weeks per Month | Pay for Weeks Worked | Gross Quarterly Pay
Feb. 2011 | 1457.34 |  |  | 1.8
Mar. 2011 | 1457.34 |  |  | 4.8
Apr. 2011 |  |  |  | 3.3
2011-05-01 00:00:00 |  |  |  | 4.4
Beg. Of June |  |  |  | 1.2
Total
GCC Pay for Summer 2011
Month | Monthly Amt. | Weekly Flat Rate | Hourly rate
2011-06-11 00:00:00 | 0
2011-07-01 00:00:00 | 0
2011-08-01 00:00:00 | 0
GCC Pay for Fall 2011
Month | Monthly Paystub Amt.(Gross) | Weekly Flat Rate (Total/15.5) | Hourly rate (Weekly flat rate/6.66 hrs.) | [NAME] per Month | Pay for Weeks Worked | Gross Quarterly Pay
Aug |  |  |  | 0.6
Sept. 2011 | 1457.34 |  |  | 4.3
Oct. 2011 | 1457.34 |  |  | 4.6
Nov. 2011 | 1457.34 |  |  | 4.2
Dec. 2011 | 1457.34 |  |  | 1.8
2012-01-01 00:00:00 | 1457.34 |  |  | 0
Total
GCC Pay for Spring 2012
Month | Monthly Amt. | Weekly Flat Rate (Total/15.5) | Hourly rate | Work Weeks per Month | Pay for Weeks Worked | Gross Quarterly Pay
Feb. 2012 | 1410.09 |  |  | 2.4
Mar. 2012 | 1410.09 |  |  | 4.5
Apr. 2012 | 1410.09 |  |  | 3.2
2012-05-01 00:00:00 | 1410.09 |  |  | 4.5
Beg. Of June | 1410.09 |  |  | 0.9
Total
Spreadsheet: 684427d1593359353-indirect-function-looking-for-worksheet-named-after-current-year-sample
Sheet: 2020

2020
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | sheet2
 |  | 2
Spreadsheet: 756538d1637619052-retrieve-hours-worked-based-on-day-of-week-in-rota-rota
Sheet: September

 | 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
 | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-05 00:00:00 | 2021-09-06 00:00:00 | 2021-09-07 00:00:00 | 2021-09-08 00:00:00 | 2021-09-09 00:00:00 | 2021-09-10 00:00:00 | 2021-09-11 00:00:00 | 2021-09-12 00:00:00 | 2021-09-13 00:00:00 | 2021-09-14 00:00:00 | 2021-09-15 00:00:00 | 2021-09-16 00:00:00 | 2021-09-17 00:00:00 | 2021-09-18 00:00:00 | 2021-09-19 00:00:00 | 2021-09-20 00:00:00 | 2021-09-21 00:00:00 | 2021-09-22 00:00:00 | 2021-09-23 00:00:00 | 2021-09-24 00:00:00 | 2021-09-25 00:00:00 | 2021-09-26 00:00:00 | 2021-09-27 00:00:00 | 2021-09-28 00:00:00 | 2021-09-29 00:00:00 | 2021-09-30 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | 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
 | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-05 00:00:00 | 2021-09-06 00:00:00 | 2021-09-07 00:00:00 | 2021-09-08 00:00:00 | 2021-09-09 00:00:00 | 2021-09-10 00:00:00 | 2021-09-11 00:00:00 | 2021-09-12 00:00:00 | 2021-09-13 00:00:00 | 2021-09-14 00:00:00 | 2021-09-15 00:00:00 | 2021-09-16 00:00:00 | 2021-09-17 00:00:00 | 2021-09-18 00:00:00 | 2021-09-19 00:00:00 | 2021-09-20 00:00:00 | 2021-09-21 00:00:00 | 2021-09-22 00:00:00 | 2021-09-23 00:00:00 | 2021-09-24 00:00:00 | 2021-09-25 00:00:00 | 2021-09-26 00:00:00 | 2021-09-27 00:00:00 | 2021-09-28 00:00:00 | 2021-09-29 00:00:00 | 2021-09-30 00:00:00
[NAME]
Scott
Adam