tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861126d1709100092-summarizing-and-graphing-trends-energy-use-data-sample
Sheet: Sheet2

Solar Time | 9:00AM-4:59PM
BatteryTime | 5:00PM-8:59AM
Sample Data
DATE | START TIME | END TIME | USAGE
2022-08-01 00:00:00 | 00:00:00 | 00:59:00 | 0.58
2022-08-01 00:00:00 | 01:00:00 | 01:59:00 | 0.55
2022-08-01 00:00:00 | 02:00:00 | 02:59:00 | 0.58
2022-08-01 00:00:00 | 03:00:00 | 03:59:00 | 0.58
2022-08-01 00:00:00 | 04:00:00 | 04:59:00 | 1.42
2022-08-01 00:00:00 | 05:00:00 | 05:59:00 | 1.58
2022-08-01 00:00:00 | 06:00:00 | 06:59:00 | 1.38
2022-08-01 00:00:00 | 07:00:00 | 07:59:00 | 0.57
2022-08-01 00:00:00 | 08:00:00 | 08:59:00 | 0.41
2022-08-01 00:00:00 | 09:00:00 | 09:59:00 | 1.63
2022-08-01 00:00:00 | 10:00:00 | 10:59:00 | 2.84
2022-08-01 00:00:00 | 11:00:00 | 11:59:00 | 3.75
2022-08-01 00:00:00 | 12:00:00 | 12:59:00 | 3.41
2022-08-01 00:00:00 | 13:00:00 | 13:59:00 | 2.64
2022-08-01 00:00:00 | 14:00:00 | 14:59:00 | 2.35
2022-08-01 00:00:00 | 15:00:00 | 15:59:00 | 2.08
2022-08-01 00:00:00 | 16:00:00 | 16:59:00 | 2.99
2022-08-01 00:00:00 | 17:00:00 | 17:59:00 | 1.59
2022-08-01 00:00:00 | 18:00:00 | 18:59:00 | 1.88
2022-08-01 00:00:00 | 19:00:00 | 19:59:00 | 1.39
2022-08-01 00:00:00 | 20:00:00 | 20:59:00 | 2.7
2022-08-01 00:00:00 | 21:00:00 | 21:59:00 | 1.54
2022-08-01 00:00:00 | 22:00:00 | 22:59:00 | 1.11
2022-08-01 00:00:00 | 23:00:00 | 23:59:00 | 1.08
Desired Results
Date | Type | Usage kWH
2022-08-01 00:00:00 | Solar time
2022-08-01 00:00:00 | Battery time
Spreadsheet: 827977d1683160755-sumifs-with-dates-vertical-and-horizontal-test-sheet
Sheet: Sheet1

 |  |  |  |  |  |  |  | MAY |  |  |  |  | JUN |  |  |  | JUL
 | FRUIT | STATE | QTY | DATE |  |  |  | 2023-05-01 00:00:00
 | [NAME] | WA | 4 | 2023-05-27 00:00:00 |  | WA | BANANAS |  |  | 3 | 6 | 5
 | [NAME] | WA | 2 | 2023-05-22 00:00:00 |  | WA | APPLES
 | Apple | NSW | 4 | 2023-05-16 00:00:00 |  | NSW | BANANAS |  |  | 15
 | Apple | WA | 1 | 2023-05-16 00:00:00 |  | NSW | APPLES |  |  | 4
 | [NAME] | NSW | 15 | 2023-05-17 00:00:00
 | [NAME] | WA | 3 | 2023-05-16 00:00:00
 | [NAME] | WA | 5 | 2023-05-29 00:00:00
Spreadsheet: 227485d1365713624-need-help-to-avoid-pasting-the-incorrect-name-avoid-pasting-incorrect-name
Sheet: 041113

Date | Processor | Auditor
2013-04-11 00:00:00 | Elango | Durga
2013-04-11 00:00:00 | Elango | Durga
2013-04-11 00:00:00 | Elango | Elango
2013-04-11 00:00:00 | Elango | Durga
 |  | Help needed on
 |  | 1 | Here both the columns should contain different names.
 |  | 2 | If we are pasting or typing the same name as column B it should restrict it.
Spreadsheet: 52834d1252650719-extracting-data-to-another-workbook-with-a-certain-cretira-vlookup-example
Sheet: Sheet1

Date | Operator | Service | Destination | ID Number | Time | Comments
2009-09-09 00:00:00 | First | 6 | Livinghston | DEF 11 | 10:15:00 | No rear Display
2009-09-09 00:00:00 | First | 12 | Broxburn | ABC 123 | 10:00:00 | Ok
2009-09-09 00:00:00 | Stagecoach | 12 | Broxburn | GAR 12 | 10:31:00 | Ok
2009-09-09 00:00:00 | EMH | 13 | London | ASD 12 | 10:16:00 | Ok
2009-09-09 00:00:00 | EMH | 23 | Cardiff | WWW 34 | 10:31:00 | No Route Number
2009-09-09 00:00:00 | Stagecoach | 45 | Brighton | ID 567 | 10:30:00 | No Side Display
2009-09-09 00:00:00 | First | 89 | [NAME] | IO1 LTD | 10:40:00 | Ok
 | Operator | First
 | Count of Time
 | Service | Destination | ID Number | Time | Comments | Total
 | 6 | Livinghston | DEF 11 | 10:15:00 | No rear Display | 1
 | 12 | Broxburn | ABC 123 | 10:00:00 | Ok | 1
 | 89 | [NAME] | IO1 LTD | 10:40:00 | Ok | 1
Spreadsheet: 482257d1474984499-urgent-numbers-as-text-formatting-nightmare-numbering-sample-for-excel-help-forum-v1
Sheet: TEXT

NUM. POSITON 1 | NUM. POSITON 2 | NUM. POSITON 3 | NUM. POSITON 4 | NUM. POSITON 5 | NUM. POSITON 6 | NUM. POSITON 7 | NUM. POSITON 8 | NUM. POSITON 9 | NUM. POSITON 10 | NUM. POSITON 11
1 | 26 | 51 | 76 | 101 | 126 | 151 | 176 | 201 | 226 | 251
2 | 27 | 52 | 77 | 102 | 127 | 152 | 177 | 202 | 227 | 252
3 | 28 | 53 | 78 | 103 | 128 | 153 | 178 | 203 | 228 | 253
4 | 29 | 54 | 79 | 104 | 129 | 154 | 179 | 204 | 229 | 254
5 | 30 | 55 | 80 | 105 | 130 | 155 | 180 | 205 | 230 | 255
6 | 31 | 56 | 81 | 106 | 131 | 156 | 181 | 206 | 231 | 256
7 | 32 | 57 | 82 | 107 | 132 | 157 | 182 | 207 | 232 | 257
8 | 33 | 58 | 83 | 108 | 133 | 158 | 183 | 208 | 233 | 258
9 | 34 | 59 | 84 | 109 | 134 | 159 | 184 | 209 | 234 | 259
10 | 35 | 60 | 85 | 110 | 135 | 160 | 185 | 210 | 235 | 260
11 | 36 | 61 | 86 | 111 | 136 | 161 | 186 | 211 | 236 | 261
12 | 37 | 62 | 87 | 112 | 137 | 162 | 187 | 212 | 237 | 262
13 | 38 | 63 | 88 | 113 | 138 | 163 | 188 | 213 | 238 | 263
14 | 39 | 64 | 89 | 114 | 139 | 164 | 189 | 214 | 239 | 264
15 | 40 | 65 | 90 | 115 | 140 | 165 | 190 | 215 | 240 | 265
16 | 41 | 66 | 91 | 116 | 141 | 166 | 191 | 216 | 241 | 266
17 | 42 | 67 | 92 | 117 | 142 | 167 | 192 | 217 | 242 | 267
18 | 43 | 68 | 93 | 118 | 143 | 168 | 193 | 218 | 243 | 268
19 | 44 | 69 | 94 | 119 | 144 | 169 | 194 | 219 | 244 | 269
20 | 45 | 70 | 95 | 120 | 145 | 170 | 195 | 220 | 245 | 270
21 | 46 | 71 | 96 | 121 | 146 | 171 | 196 | 221 | 246 | 271
22 | 47 | 72 | 97 | 122 | 147 | 172 | 197 | 222 | 247 | 272
23 | 48 | 73 | 98 | 123 | 148 | 173 | 198 | 223 | 248 | 273
24 | 49 | 74 | 99 | 124 | 149 | 174 | 199 | 224 | 249 | 274
25 | 50 | 75 | 100 | 125 | 150 | 175 | 200 | 225 | 250 | 275
Spreadsheet: 715022d1611511145-index-match-where-categories-need-aggregating-sample-aggrigations
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Baseball Glove | [NAME] | Track Shoes | [NAME] | [NAME] | Golf Balls | [NAME] | [NAME] | Barbells
 |  | [NAME] | Balls | Apparel | Equipment |  |  |  |  |  |  |  |  | [NAME] | 10 | 1 | 2 | 5 | 8 | 12 | 5 | 6 | 2
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 8 | 30 | 16 | 20 | 18 | 7 | 5 | 3 | 10
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 6 | 38 | 9 | 22 | 4 | 17 | 90 | 6 | 8
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Sandy | 4 | 45 | 16 | 32.6666666666667 | 19 | 5 | 45 | 8 | 2
 |  | Sandy |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 12 | 19.5 | 41.1666666666667 | 50 | 6 | 6 | 16 | 5
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 19 | 23 | 49.6666666666667 | 36 | 45 | 8 | 14 | 9
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 16 | 26.5 | 58.1666666666667 | 22 | 60 | 12 | 12 | 95
 |  | Terelle |  |  |  |  |  |  |  |  |  |  |  | Terelle | 5 | 9 | 30 | 66.6666666666667 | 0 | 9 | 18 | 9 | 74
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 9 | 5 | 33.5 | 75.1666666666667 | 15 | 12 | 20 | 12 | 15
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 16 | 4 | 0 | 83.6666666666667 | 5 | 88 | 25 | 13 | 38
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 10 | 6 | 40.5 | 92.1666666666667 | 8 | 1 | 35 | 88 | 19
 |  | Brittany |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 12 | 2 | 44 | 100.666666666667 | 3 | 30 | 40 | 19 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Brittany | 14 | 8 | 47.5 | 109.166666666667 | 2 | 105 | 12 | 47 | 0
Spreadsheet: 93931d1293701735-returning-a-date-milestone-tracker
Sheet: Overview

 | SITE | DATE | RESOURCE | STAGE
 | SITE |  | Resource 1 | SITE SURVEY |  | Site Survey
 | SITE |  | Resource 2 | HOT STAGE |  |  |  |  |  |  | Hot Stage
 | SITE |  | Resource 3 | DATA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data
 | SITE |  | Resource 4 | INSTALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Install
 | SITE |  | Resource 5 | SYSTEM HANDOVER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 4

 | Oct 26 |  | Nov 2 |  | Nov 9 |  | Nov 16
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated net notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, cleared and uncleared.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 866419d1713337126-match-cells-from-various-rows-columns-if-name-matches-in-another-sheet-complete-list-mock-up-v1
Sheet: Sheet1

Client Names |  | Notes
1 Summer |  | manually input client name into [NAME] This needs to match full name in All_Clients_Incl_Contacts D4:D203
Vehicle Details |  | Make & Model | Notes | Vehicle Reg | Notes | MOT | Notes | Service
 |  | Nissan Qashqai | if [NAME] client name in All_Client_Incl_Contacts D4:D203 then make & model from All_Client_Incl_ContactsH4:H203 to go into C6     On my real template it will go into B6 | asd | if [NAME] client name in All_Client_Incl_Contacts D4:D203 then vehicle reg here from All_Client_Incl_ContactsI4:I203 to go into E6   On my real template it will go into C6 |  | if [NAME] client name in All_Client_Incl_Contacts D4:D203 then MOT info from All_Client_Incl_ContactsJ4:J203 to go into G6  On my real template it will go into D6 |  | if [NAME] client name in All_Client_Incl_Contacts D4:D203 then MOT info from All_Client_Incl_ContactsK4:K203 to go into I6  On my real template it will go into E6
OCC Approved  Drivers
Drivers Name | Notes | Driving Licence | Notes | [NAME] | Notes | Endorsements | Notes | [NAME]
Charlene | If name matches A3  drivers name from All-Clients_Incl_Contacts AG ( matching corresponding row of named client i.e AG4 ) AG4:AG203 | 1940 | If name matches A3  drivers name from All-Clients_Incl_Contacts AH ( matching corresponding row of named client [NAME] ) to go into C6   On my real template it will go into  B6 | 2024-04-08 00:00:00 |  | 1 |  | 1905-07-14 00:00:00
2010 | If name matches A3  drivers name  from All_Clients_Incl_Contacts AL ( matching corresponding row of named client [NAME]) AL4:AL203 | January | If name matches A3 then drivers name from All-Clients_Incl_Contacts AH ( matching corresponding row of named client [NAME] ) to go into B6 | 1902-09-26 00:00:00 |  | 100 |  | 2029-07-16 00:00:00
[NAME] | AQ | 12345 |  | December |  | Zero |  | 2032-06-06 00:00:00
maria | AV | 1020 |  | 1996-03-01 00:00:00 |  | 0 |  | 2025-11-15 00:00:00
 | BA
 | BF
 | BK
 | BP
 | BU
 | BZ
 | CE
 | CJ
 | CO
 | CT
 | CY
 | DD
 | DI
 | DN
 | DS
 | DX
 | EC
 | EH
 | EM
 | ER
 | EW
 | FB
 | FG
 | FL
Spreadsheet: 5cac051c-dd16-4339-bdcb-fa21e4f5342c
Sheet: Sheet1

GOVERNMENT SECURITIES' ISSUE CALENDAR FOR JUNE 2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | Auction Date | Payment Date | Issue № | Issue Date | Maturity Date | Maturity | Currency | Nominal
 | 2012-06-04 00:00:00 | 2012-06-06 00:00:00 | BG2030012111 | 2012-02-08 00:00:00 | 2014-02-08 00:00:00 | 2 Y | BGN | 20000000
Total for the June 2012 - BGN |  |  |  |  |  |  | BGN | 20000000
Notes:
The government securities'  issue calendar is pre-announced a month ahead, but not later than 30 days before the begining of the respective month.
Spreadsheet: 673023d1587126137-autofil-pairs-of-rows-example-abcpairs
Sheet: Explanations

 | Datset I have :
 | A |  | B |  | C |  |  | Matrix of pairs of 1 (green)
 | a | b | a | b | a | b |  |  | A | B | C
1 |  |  | 3 |  | 1 |  |  | A | 8 |  |  | I already have this matrix
2 |  |  | 3 |  |  | 1 |  | B | 6 | 11
3 |  |  | 3 |  | 1 |  |  | C | 3 | 3 | 11
4 | 1 |  | 3 |  |  | 1
5 | 1 |  | 1 |  |  |  |  | Matrix of neither has a 3 (non reds) |  |  |  | number of lines where there is no 3 either in A or B, A or C, B or C
6 | 1 |  | 1 |  |  |  |  |  | A | B | C
7 |  | 1 |  | 1 |  |  |  | A | 14 |  |  | I'm looking for a way to create this one
8 |  |  |  |  |  |  |  | B | 10 | 16 |  | Ex: for AB I count entries 5 to 12 then 19 and 20, total = 10
9 | 1 |  | 1 |  | 3 |  |  | C | 6 | 11 | 15
10 |  |  |  | 1 | 3 |  |  | so I count the number of line that has no 3 in either Aa or Ba, Aa or Ca, Ba or Ca etc… over the entire row (here from line 4 to line 23).
11 | 1 |  | 1 |  | 3 |  |  | Everytime there is a 3, do not count. I'm thinking playing with COUNTIF and a step dataset but I don't know how to autofil all the pairs
12 |  |  |  | 1 | 3 |  |  | we would need to autofil with pairs like this : (row)B and (row)D, then B and F, then D and F. 3s are always in the "a" rows.
13 | 3 |  | 1 |  | 3 |  |  | for this simple dataset it's easy, for for 31 entries that leave me with a lot of pairs so I really need to automate this.
14 | 3 |  | 1 |  | 1 |  |  | Even if I could simply create a step dataset with the sum of each pair for each line then I can COUNTIF(row;<3) over the entire rows and have my answers.
15 | 3 |  |  |  | 1 |  |  | that would leave me with my answers in a line instead of a matrix but I can manually refill if no better options.
16 | 3 |  |  |  | 1
17 | 3 |  |  |  |  | 1 |  | Comments :
18 | 3 |  | 1 |  | 1 |  |  | - "3" can be changed to anything preferable with a simple "replace" over the dataset.
19 |  | 1 |  | 1 |  | 1 |  | - there are 31 (a+b) so 62 rows
20 | 1 |  |  |  | 1 |  |  | - there is over 650 lines and growing potentially
 |  |  |  |  |  |  |  | - we can delete all the "b" row if important for autofilling
Seen total (1s) | 6 | 2 | 7 | 4 | 7 | 4
Over x potential (non-red) | 14 |  | 16 |  | 15
 |  |  |  |  |  |  |  |  | SEE SHEET2 for longer example, final matrix autofilled with all the formulas should be 31x31 (prepared in sheet3)
Spreadsheet: 689512d1596471664-sum-ifs-function-bbltd
Sheet: Ingredient

 | Bread Boutique Limited
 | Ingredient Allocation Recors
 | Description | QTY | Amount | Branch | Day
 | [NAME] | 4 | 565 | Spintex | Monday
 | Package | 4 | 600 | Spintex | Tuesday
 | Complete | 5 | 56 | UPSA | Wednesday
 | [NAME] | 6 | 43 | Bread House | Friday
 | Package | 7 | 58 | Bread House | Monday
 | [NAME] | 4 | 291 | kumasi | Tuesday
 | Yeast | 7 | 344 | Tema | Monday
 | Complete | 7 | 556 | Dansoman | Friday
 | Fruit | 6 | 44 | Dansoman | Saturday
Spreadsheet: 855363d1704962557-help-to-find-latest-previous-related-value-book1-1-1-
Sheet: Sheet1

4 | [NAME]
No. | Name | Point
1 | [NAME] | 10
2 | [NAME] | 8
3 | [NAME] | 6
4 | [NAME] | 10
5 | [NAME] | 7
6 | [NAME] | 6
7 | [NAME] | 10
Spreadsheet: 805540d1668757685-rolling-e-transfer-limit-drawdown-calculation-daily-weekly-monthly-rolling-e-transfer-limit-drawdown-1-
Sheet: Sheet2

Rolling e-transfer limit calculation
 |  |  |  |  |  |  | 1 day limit |  | 7 day limit |  | 31 day limit
 |  |  |  |  |  |  | 20000 |  | 50000 |  | 100000
Transaction Date | Rolling Date | Transaction $ |  | 1 day | 7 days | 31 days
2022-11-14 00:00:00 | day 1
2022-11-15 00:00:00 | day 2 | 15886.96
2022-11-16 00:00:00 | day 3
2022-11-17 00:00:00 | day 4 | 2902.2
2022-10-18 00:00:00 | day 5
2022-10-19 00:00:00 | day 6 | 11555.56
2022-10-20 00:00:00 | day 7
2022-10-21 00:00:00 | day 8
2022-10-22 00:00:00 | day 9
2022-10-23 00:00:00 | day 10
2022-10-24 00:00:00 | day 11
2022-10-25 00:00:00 | day 12
2022-10-26 00:00:00 | day 13
2022-10-27 00:00:00 | day 14
2022-10-28 00:00:00 | day 15
2022-10-29 00:00:00 | day 16
2022-10-30 00:00:00 | day 17
2022-10-31 00:00:00 | day 18
2022-11-01 00:00:00 | day 19 | 19748.27
2022-11-02 00:00:00 | day 20 | 19565.73
2022-11-03 00:00:00 | day 21
2022-11-04 00:00:00 | day 22 | 900 |  |  |  |  | 20000
2022-11-05 00:00:00 | day 23 |  |  |  |  |  | 20000
2022-11-06 00:00:00 | day 24 |  |  |  |  |  | 20000
2022-11-07 00:00:00 | day 25 |  |  |  |  |  | 20000
2022-11-08 00:00:00 | day 26 |  |  |  |  |  | 20000
2022-11-09 00:00:00 | day 27 |  |  |  |  |  | 20000
2022-11-10 00:00:00 | day 28 |  |  |  |  |  | 20000
2022-11-11 00:00:00 | day 29 |  |  |  |  |  | 20000
2022-11-12 00:00:00 | day 30 |  |  |  |  |  | 20000
2022-11-13 00:00:00 | day 31 |  |  |  |  |  | 20000
Spreadsheet: 889667d1740570664-calculating-pick-errors-with-yes-no-test-pick-data
Sheet: PickersData

NAME | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | JAN | FEB | TOTAL
[NAME]
[NAME] |  |  |  |  |  |  |  |  | 100 | 100
[NAME] |  |  |  |  |  |  |  |  | 99.19871794871796 | 100
[NAME] |  |  |  |  |  |  |  |  | 100 | 99.13793103448276
Ava Sinclair |  |  |  |  |  |  |  |  | 0 | 100
[NAME] |  |  |  |  |  |  |  |  | 100 | 100
[NAME] |  |  |  |  |  |  |  |  | 99.8798076923077 | 100
[NAME] |  |  |  |  |  |  |  |  | 96.49122807017544 | 99.80340760157273
[NAME] |  |  |  |  |  |  |  |  | 0 | 100
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 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: 76896d1277376223-summary-for-list-sample
Sheet: Sheet1

SO NO | Line | Despatch
10000001 | 1 | NOT OTD
10000001 | 2 | OTD
10000001 | 3 | OTD
10000001 | 4 | OTD
10000001 | 5 | NOT OTD |  | Ex 1: The order no 10000001 contains 9 line, and Descpatch result have  Both OTD & NOTD.  The final result of order is NOT OTD
10000001 | 6 | NOT OTD |  | EX2: The order No 10000001 Contains 13 Lines, The results of the order is OTD. [NAME] is not avalible against this order in any line.
10000001 | 7 | NOT OTD
10000001 | 8 | NOT OTD |  | OTD  - ON time Delivery
10000001 | 9 | NOT OTD |  | NOTD - NOT On time Delivery
10000002 | 1 | OTD
10000002 | 2 | OTD
10000002 | 3 | OTD
10000002 | 4 | OTD
10000002 | 5 | OTD
10000002 | 6 | OTD
10000002 | 7 | OTD
10000002 | 8 | OTD
10000002 | 9 | OTD
10000002 | 10 | OTD
10000002 | 11 | OTD
10000002 | 12 | OTD
10000002 | 13 | OTD
10000003 | 1 | NOT OTD
10000004 | 1 | OTD
10000004 | 2 | OTD
10000004 | 3 | NOT OTD
10000005 | 1 | NOT OTD
10000005 | 2 | NOT OTD
10000006 | 1 | OTD
10000006 | 2 | OTD
10000008 | 1 | OTD
10000008 | 2 | NOTD
10000008 | 3 | OTD
10000009 | 1 | OTD
10000009 | 2 | OTD
10000009 | 3 | NOT OTD
10000009 | 4 | NOT OTD
10000009 | 5 | NOT OTD
10000009 | 6 | NOT OTD
10000009 | 7 | NOT OTD
10000009 | 8 | OTD
10000009 | 9 | NOT OTD
10000010 | 1 | OTD
10000010 | 2 | OTD
10000010 | 3 | OTD
10000010 | 4 | OTD
10000010 | 5 | OTD
10000010 | 6 | OTD
Spreadsheet: 71232d1271930246-copying-entries-between-worksheets-copy-of-account-ledger2
Sheet: MAIN

 |  |  |  |  |  |  |  |  |  | YTD P&L Subtotal | -16200
 |  |  |  |  |  |  |  |  |  | Adjustments
 |  |  |  |  |  |  |  |  |  | YTD P&L Total | -16200
 | Date | Description | Bills | Supplies | IT | Transportation | Misc. Charges | Invoice Paid | Invoice Received | Notes | Balance
 | 2010-03-01 00:00:00 | Beginning Balance |  |  |  |  |  |  |  |  | 20000
 | 2010-03-02 00:00:00 | Payment | -4000 |  |  |  |  |  |  |  | 16000
 | 2010-03-03 00:00:00 | Misc |  |  |  |  | -800 |  |  | Odds and Ends | 15200
 | 2000-03-04 00:00:00 | Money received |  |  |  |  |  |  | 1000 |  | 16200
 | 2010-03-05 00:00:00 | Payment | -5000 |  |  |  |  |  |  |  | 11200
 | 2010-03-06 00:00:00 | Payment |  |  | -400 |  |  |  |  |  | 10800
 | 2010-03-07 00:00:00 | Refunded Fee |  |  |  |  | -100 |  |  |  | 10700
 | 2010-03-08 00:00:00 | Purchase |  | -500 |  |  |  |  |  |  | 10200
 | 2010-03-09 00:00:00 | Purchase |  | -300 |  |  |  |  |  |  | 9900
 | 2010-03-10 00:00:00 | Payment | -2500 |  |  |  |  |  |  |  | 7400
 | 2010-03-11 00:00:00 | Payment to Card |  |  |  |  | -1000 |  |  |  | 6400
 | 2010-03-12 00:00:00 | Money received |  |  |  |  |  |  | 5000 |  | 11400
 | 2010-03-13 00:00:00 | Payment to Card |  |  |  |  | -2000 |  |  |  | 9400
 | 2010-03-14 00:00:00 | Money received |  |  |  |  |  |  | 3500 |  | 12900
 | 2010-03-15 00:00:00 | Money received |  |  |  |  |  |  | 3000 |  | 15900
 | 2010-03-16 00:00:00 | Payment to Card |  |  |  |  | -4000 |  |  |  | 11900
 | 2010-03-17 00:00:00 | Payment | -2000 |  |  |  |  |  |  |  | 9900
 | 2010-04-02 00:00:00 | Charge |  | -100 |  |  |  |  |  |  | 9800
 | 2010-04-03 00:00:00 | Charge |  | -300 |  |  |  |  |  |  | 9500
 | 2010-04-04 00:00:00 | Charge | -3000 |  |  |  |  |  |  |  | 6500
 | 2010-04-06 00:00:00 | Purchase |  | -50 |  |  |  |  |  |  | 6450
 | 2010-04-07 00:00:00 | Purchase |  | -150 |  |  |  |  |  |  | 6300
 | 2010-04-08 00:00:00 | Purchase | -2500 |  |  |  |  |  |  |  | 3800
 |  | YTD TOTALS | -19000 | -1400 | -400 | 0 | -7900 | 0 | 12500
 | NOTES:
Spreadsheet: 85929d1285926408-planning-and-forecasting-tool-for-forum
Sheet: Work in Data

 |  |  |  |  |  |  |  |  |  |  |  |  | 2008 /2009 |  |  |  |  |  |  |  |  |  |  |  | 2009 / 2010 |  |  |  |  |  |  |  |  |  |  |  | 2010 / 2011
BEAUTY | SLN | NFR | PW | ACU | DU | Funding | Total [NAME] | Achievement | [NAME] "On-Programme" POT | Month 1 Payment | Subsequent months | Starts 2008/2009 | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Total starts |  | Duration (Months) | Installment Months
NVQ | 1.321 |  | 1.25 | 1.2 | 1.13 |  |  |  |  |  |  | 16 - 18 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
TC |  |  |  |  |  |  |  |  |  |  |  | Installments for Aug start
Key/Func Skill Maths | 0.08 |  | 1 | 1.2 | 1.13 |  |  |  |  |  |  | Installments for Sep start
Key/Func Skill English | 0.08 |  | 1 | 1.2 | 1.13 |  |  |  |  |  |  | Installments for Oct start
 |  |  |  |  |  |  |  |  |  |  |  | Installments for Nov start
 |  |  |  |  |  |  |  |  |  |  |  | Installments for Dec start
 |  |  |  |  |  |  |  |  |  |  |  | Installments for Jan start
 |  |  |  |  |  |  |  |  |  |  |  | Installments for Feb start
 |  |  |  |  |  |  |  |  |  |  |  | Installments for Mar start
 |  |  |  |  |  |  |  |  |  |  |  | Installments for Apr start
 |  |  |  |  |  |  |  |  |  |  |  | Installments for May start
 |  |  |  |  |  |  |  |  |  |  |  | Installments for Jun start
 |  |  |  |  |  |  |  |  |  |  |  | Installments for Jul start
 |  |  |  |  |  |  |  |  |  |  |  | Achievement
 |  |  |  |  |  |  |  |  |  |  |  | Balancing Payment
 |  |  |  |  |  |  |  |  |  |  |  | 16-18 |  | Aug 2010 | Sep 2010 | Oct 2010 | Nov 2010 | Dec 2010 | Jan 2011 | Feb 2011 | Mar 2011 | Apr 2011 | May 2011 | Jun 2011 | Aug 2010 | Sep 2010 | Oct 2010 | Nov 2010 | Dec 2010 | Jan 2011 | Feb 2011 | Mar 2011 | Apr 2011 | May 2011 | Jun 2011
 |  |  |  |  |  |  |  |  |  |  |  | Carried into 2010/11 | 167
 |  |  |  |  |  |  |  |  |  |  |  | Starts |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Completions |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | In Learning
 |  |  |  |  |  |  |  |  |  |  |  | Programme - Earned Cash
 |  |  |  |  |  |  |  |  |  |  |  | Additional Learning Support - Earned Cash
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Total - Earned Cash